openregs: legislation: 36 rows where bill_type = "sconres" and policy_area = "Agriculture and Food" sorted by introduced

Congressional bills and resolutions from Congress.gov, filtered to policy areas relevant to environmental, health, agriculture, and wildlife regulation.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

36 rows where bill_type = "sconres" and policy_area = "Agriculture and Food" sorted by introduced_date descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

bill_id	congress	bill_type	bill_number	title	policy_area	introduced_date ▲	latest_action_date	latest_action_text	origin_chamber	sponsor_name	sponsor_state	sponsor_party	sponsor_bioguide_id	cosponsor_count	summary_text	update_date
116-sconres-42	116	sconres	42	A concurrent resolution expressing the sense of Congress that August 30, 2020, be observed as the 130th anniversary of the 1890 Land-Grant Educational Institutions.	Agriculture and Food	2020-07-30	2020-07-30	Referred to the Committee on Agriculture, Nutrition, and Forestry. (text: CR S4638)	Senate	Sen. Boozman, John [R-AR]	AR	R	B001236	13	This concurrent resolution expresses the sense of Congress that (1) the 130th year anniversary of the 1890 Land-Grant Educational Institutions should be observed with appropriate ceremonies and activities to recognize the collective contributions that these 19 historically Black federal land-grant educational institutions have made to the United States, (2) the Department of Agriculture and the National Institute of Food and Agriculture should remain committed to supporting the goals of the Second Morrill Act and the Smith-Lever Act, and (3) the Second Morrill Act and the Smith-Lever Act have helped the United States develop agricultural leaders.	2023-01-11T13:45:32Z
116-sconres-36	116	sconres	36	A concurrent resolution supporting the Farmers Bill of Rights.	Agriculture and Food	2020-02-11	2020-02-11	Referred to the Committee on Agriculture, Nutrition, and Forestry. (text: CR S994-995)	Senate	Sen. Booker, Cory A. [D-NJ]	NJ	D	B001288	2	This concurrent resolution expresses the sense of Congress that (1) it recognizes the many contributions that family farmers and ranchers, including historically underserved farmers and ranchers, have made to America's agricultural industry, local food production, food sovereignty, rich variety of the country's abundant food supply, and traditional and cultural agricultural practices; and (2) the federal government should encourage support for family farmers and ranchers, in rural communities and on indigenous lands, and ensure access to open and fair agricultural markets in the United States, by introducing the Farmers Bill of Rights.	2022-03-02T16:21:34Z
116-sconres-24	116	sconres	24	A concurrent resolution recognizing the 50th anniversary of the Food and Nutrition Service of the Department of Agriculture.	Agriculture and Food	2019-07-31	2019-08-09	Referred to the Subcommittee on Nutrition, Oversight, and Department Operations.	Senate	Sen. Roberts, Pat [R-KS]	KS	R	R000307	1	This concurrent resolution recognizes the valuable historic and continued contributions of the Food and Nutrition Service and its employees to the nutrition, health, and well-being of the people of the United States.	2022-11-01T13:50:15Z
114-sconres-10	114	sconres	10	A concurrent resolution supporting the designation of the year of 2015 as the "International Year of Soils" and supporting locally led soil conservation.	Agriculture and Food	2015-03-17	2015-05-14	Held at the desk.	Senate	Sen. Donnelly, Joe [D-IN]	IN	D	D000607	7	Supports the designation of 2015 as the International Year of Soils, and supports locally led soil conservation. Encourages public participation in activities celebrating the importance of soils to the United States. Supports soil conservation through partnerships with local soil and water conservation districts and voluntary landowner participation in federal conservation programs.	2023-01-11T13:27:46Z
113-sconres-33	113	sconres	33	A concurrent resolution celebrating the 100th anniversary of the enactment of the Smith-Lever Act, which established the nationwide Cooperative Extension System.	Agriculture and Food	2014-02-27	2014-04-10	Held at the desk.	Senate	Sen. Stabenow, Debbie [D-MI]	MI	D	S000770	18	(This measure has not been amended since it was introduced. The summary of that version is repeated here.) Recognizes the significance of the Smith-Lever Act which established the Cooperative Extension System. Honors the university faculty and local educators who provide educational programs to help people, families, youth, businesses, and communities solve problems, develop skills, and build a better future. Thanks the volunteers who promote excellence for 4-H Clubs, the Master Gardeners program, the Family and Consumer Sciences program, and other Cooperative Extension System programs. Encourages continued collaboration and cooperation among federal, state, and local governments to assure the sustainability of the Cooperative Extension System.	2023-01-11T13:26:33Z
111-sconres-28	111	sconres	28	A concurrent resolution supporting the goals of Smart Irrigation Month, which recognizes the advances in irrigation technology and practices that help raise healthy plants and increase crop yields while using water resources more efficiently and encourages the adoption of smart irrigation practices throughout the United States to further improve water-use efficiency in agricultural, residential, and commercial activities.	Agriculture and Food	2009-06-16	2009-06-16	Referred to the Committee on Energy and Natural Resources. (text of measure as introduced: CR S6656)	Senate	Sen. Nelson, Ben [D-NE]	NE	D	N000180	4	Supports the goals of Smart Irrigation Month which are to: (1) recognize the advances in irrigation technology and practices that help raise healthy plants and increase crop yields while using water resources more efficiently; and (2) encourage the adoption of smart irrigation practices to improve agricultural, residential, and commercial water-use efficiency.	2023-01-11T13:18:34Z
109-sconres-119	109	sconres	119	A concurrent resolution expressing the sense of Congress that public policy should continue to protect and strengthen the ability of farmers and ranchers to join together in cooperative self-help efforts.	Agriculture and Food	2006-09-27	2006-12-05	Referred to the House Committee on Agriculture.	Senate	Sen. Lincoln, Blanche L. [D-AR]	AR	D	L000035	21	(This measure has not been amended since it was introduced. The summary of that version is repeated here.) Expresses the sense of Congress that public policy should continue to protect and strengthen the ability of farmers and ranchers to join together in cooperative self-help efforts to: (1) improve their income from the marketplace and their economic well-being; (2) capitalize on new market opportunities; and (3) help meet the food and fiber needs of consumers, provide for increased energy production, promote rural development, maintain and create needed jobs, and contribute to a growing U.S. economy.	2023-01-12T17:51:57Z
106-sconres-24	106	sconres	24	A bill to express the sense of the Congress on the need for United States to defend the American agricultural and food supply system from industrial sabotage and terrorist threats.	Agriculture and Food	1999-03-25	1999-03-25	Referred to the Committee on Agriculture.	Senate	Sen. Lugar, Richard G. [R-IN]	IN	R	L000504	1	Expresses the sense of the Congress on the need for the United States and the Department of Agriculture to defend the agricultural and food supply system from attack.	2025-04-07T13:42:35Z
106-sconres-11	106	sconres	11	A concurrent resolution expressing the sense of Congress with respect to the fair and equitable implementation of the amendments made by the Food Quality Protection Act of 1996.	Agriculture and Food	1999-02-12	1999-02-12	Referred to the Committee on Agriculture.	Senate	Sen. Campbell, Ben Nighthorse [R-CO]	CO	R	C000077	12	Expresses the sense of the Congress with respect to the implementation of the amendments made by the Food Quality Protection Act of 1996.	2025-01-14T16:41:20Z
106-sconres-8	106	sconres	8	A concurrent resolution expressing the sense of Congress that assistance should be provided to pork producers to alleviate economic conditions faced by the producers.	Agriculture and Food	1999-02-10	1999-02-10	Referred to the Committee on Agriculture.	Senate	Sen. Grassley, Chuck [R-IA]	IA	R	G000386	1	Expresses the sense of the Congress that: (1) the President and the Secretary of Agriculture are commended for their efforts to alleviate economic conditions faced by pork producers; and (2) specified additional assistance is necessary.	2025-01-14T16:41:20Z
104-sconres-63	104	sconres	63	A concurrent resolution to express the sense of Congress that the Secretary of Agriculture should dispose of all remaining commodities in the disaster reserve maintained under the Agricultural Act of 1970 to relieve the distress of livestock producers whose ability to maintain livestock is adversely affected by disaster conditions existing in certain areas of the United States, such as prolonged drought or flooding, and for other purposes.	Agriculture and Food	1996-05-24	1996-06-12	Motion to reconsider laid on the table Agreed to without objection.	Senate	Sen. Kassebaum, Nancy Landon [R-KS]	KS	R	K000017	12	States that the Secretary of Agriculture should use all disaster reserve commodities to assist livestock producers adversely affected by drought and flooding.	2025-04-07T15:28:40Z
103-sconres-65	103	sconres	65	A Child is Waiting Resolution	Agriculture and Food	1994-03-24	1994-03-24	Referred to the Committee on Agriculture.	Senate	Sen. Leahy, Patrick J. [D-VT]	VT	D	L000174	23	A Child is Waiting Resolution - Expresses the sense of the Congress that: (1) any health care reform legislation include guaranteed full funding for the special supplemental food program for women, infants, and children (WIC); and (2) specified amounts should be made available to move toward such full funding goal.	2025-08-26T13:49:32Z
101-sconres-114	101	sconres	114	A concurrent resolution expressing the sense of Congress regarding action by the Secretary of Agriculture and the Federal Crop Insurance Corporation to restore confidence in the Federal Crop Insurance Program pending consideration of legislation on the Crop Insurance Program.	Agriculture and Food	1990-03-30	1990-03-30	Referred to the Committee on Agriculture.	Senate	Sen. Daschle, Thomas A. [D-SD]	SD	D	D000064	11	States that the Secretary of Agriculture and the Federal Crop Insurance Corporation should continue to expend available funds for the crop insurance program and keep the program operating at current levels.	2025-01-14T16:41:20Z
100-sconres-67	100	sconres	67	A concurrent resolution to recognize the importance of the agricultural export enhancement program.	Agriculture and Food	1987-07-22	1987-07-24	Message on Senate action sent to the House.	Senate	Sen. Melcher, John [D-MT]	MT	D	M000635	27	Recognizes the importance of the agricultural export enhancement program established under the Food Security Act of 1985. Expresses the sense of the Congress that the Secretary of Agriculture should assure that sufficient FY 1987 through 1990 funding be available for such program.	2021-06-10T21:47:18Z
99-sconres-138	99	sconres	138	A concurrent resolution expressing the sense of the Congress with respect to Farm Credit System agricultural loan restructing.	Agriculture and Food	1986-05-14	1986-05-14	Referred to the Committee on Agriculture.	Senate	Sen. Dole, Robert J. [R-KS]	KS	R	D000401	63	Expresses the sense of the Congress that the Farm Credit System should take specified actions to assist borrowers, including: (1) participating to the maximum extent possible with the Farmers Home Administration and other Government guarantee programs to provide 1986 operating loans; (2) following policies of reasonable loan forbearance; (3) using loan restructuring; (4) emphasizing loan servicing approaches that help borrowers meet the conditions of their loan contracts; (5) resorting to foreclosure only when there is no alternative or when the associated costs would be less than loan restructuring; (6) providing defaulting borrowers with the opportunity to bid on foreclosed property; and (7) maintaining sound institutional credit policies.	2025-01-14T16:41:20Z
99-sconres-124	99	sconres	124	A concurrent resolution expressing the sense of the Congress with respect to the milk production termination program.	Agriculture and Food	1986-04-09	1986-04-21	Committee on Agriculture requested executive comment from Agriculture Department.	Senate	Sen. Baucus, Max [D-MT]	MT	D	B000243	11	Expresses the sense of the Congress that the Secretary of Agriculture shall take specified steps to address the current instability in the red meat market, including additional Federal purchases and proportional spacing of dairy cattle slaughter.	2025-01-14T16:41:20Z
99-sconres-122	99	sconres	122	A concurrent resolution to express the sense of Congress with respect to agricultural loan restructuring.	Agriculture and Food	1986-03-27	1986-04-21	Referred to Subcommittee on Agricultural Credit.	Senate	Sen. Nickles, Don [R-OK]	OK	R	N000102	7	Expresses the sense of the Congress that the Farm Credit Administration and its associated agencies and institutions should take additional actions to alleviate the agricultural financial situation, including restructuring, rather than foreclosing, loans.	2025-01-14T16:41:20Z
99-sconres-64	99	sconres	64	A concurrent resolution expressing the sense of the Congress that the President should form a National Commission on the Farm Credit System to make recommendations to the Congress.	Agriculture and Food	1985-09-13	1985-10-24	Committee on Governmental Affairs received executive comment from Farm Credit Administration.	Senate	Sen. Abdnor, James [R-SD]	SD	R	A000009	1	Expresses the sense of the Congress that the President should form a National Commission on the Farm Credit System to recommend agricultural credit reform.	2025-01-14T19:03:55Z
99-sconres-63	99	sconres	63	A concurrent resolution expressing the sense of the Congress in support of the efforts of and participants in the Farmaid Concert to be held in Champaign, Illinois, to bring the current crisis in American agriculture to the attention of the American people.	Agriculture and Food	1985-09-12	1985-09-12	Read twice and referred to the Committee on Agriculture.	Senate	Sen. Harkin, Tom [D-IA]	IA	D	H000206	0	Expresses the sense of the Congress that the efforts of the organizers of and participants in the Farmaid Concert to be held in Champaign, Illinois, to bring the current crisis in American agriculture to the attention of the American people should be supported.	2025-01-14T16:41:20Z
99-sconres-59	99	sconres	59	A concurrent resolution expressing the sense of the Congress that food producers who permit gleaning of their fields and nonprofit organizations which glean fields and distribute the resulting harvest to help alleviate hunger should be commended for their efforts, and for other purposes.	Agriculture and Food	1985-07-31	1985-10-03	Referred to Subcommittee on Nutrition (Agriculture).	Senate	Sen. Trible, Paul S., Jr. [R-VA]	VA	R	T000367	10	Expresses the sense of the Congress that: (1) food producers who permit gleaning of their fields and nonprofit organizations which glean fields and distribute the resulting harvest to help alleviate hunger should be commended for their efforts; and (2) State and local governments should be encouraged to offer tax and other incentives for such purposes.	2025-01-14T16:41:20Z
99-sconres-57	99	sconres	57	A concurrent resolution expressing the sense of Congress in opposition to the erosion of local control and participation by farmer- and rancher- borrowers in the farmer- and rancher- owned Farm Credit System and in opposition to the large-scale consolidation and mergers of production credit associations and Federal land bank associations within the Farm Credit System.	Agriculture and Food	1985-07-18	1985-10-09	Committee on Agriculture received executive comment from Farm Credit Administration. Favorable.	Senate	Sen. Grassley, Chuck [R-IA]	IA	R	G000386	1	Expresses the sense of the Congress that: (1) local control by farmer and rancher borrowers in the Farm Credit System should not be diminished; and (2) wide-scale consolidations and mergers of Federal land bank associations and production credit associations should not be pursued by the Farm Credit System or accomplished through coercive action such as the threat of liquidation of dissenting associations.	2025-01-14T16:41:20Z
99-sconres-13	99	sconres	13	A concurrent resolution to require implementation of a modified debt recovery program.	Agriculture and Food	1985-02-07	1985-04-22	Referred to Subcommittee on Agricultural Credit.	Senate	Sen. Durenberger, Dave [R-MN]	MN	R	D000566	2	Declares that the President direct the Secretary of Agriculture to implement a modified debt recovery program to make structural changes in the agricultural loan programs designed to benefit family farmers.	2025-01-14T16:41:20Z
98-sconres-130	98	sconres	130	A concurrent resolution expressing the sense of the Congress that the President should assure an adequate flow of affordable credit to farmers and should assure fair treatment to agricultural borrowers.	Agriculture and Food	1984-06-29	1984-08-07	Indefinitely postponed by Senate by Unanimous Consent.	Senate	Sen. Exon, J. James [D-NE]	NE	D	E000284	6	Expresses the sense of Congress that the President, in cooperation with the Board of Governors of the Federal Reserve System, should: (1) exercise appropriate authority to assure that an adequate flow of credit be available to American farmers at reasonable rates; and (2) take noninflationary actions necessary to reduce interest rates.	2021-06-29T21:26:25Z
98-sconres-99	98	sconres	99	A concurrent resolution expressing the sense of Congress that Federal bank regulatory agencies should require their examiners to exercise caution and restraint in adversely classifying loans made to farmers and ranchers.	Agriculture and Food	1984-03-21	1984-04-24	Committee on Banking received executive comment from Federal Deposit Insurance Corporation.	Senate	Sen. Huddleston, Walter (Dee) [D-KY]	KY	D	H000905	14	Declares that it is the sense of Congress that the Federal bank regulatory agencies should require their examiners to exercise caution and restraint in adversely classifying loans made to agricultural borrowers.	2025-01-14T18:20:21Z
98-sconres-87	98	sconres	87	A concurrent resolution relating to the dismantling of nontariff trade barriers of the Japanese to the import of beef.	Agriculture and Food	1984-01-24	1984-01-24	Referred to the Committee on Finance.	Senate	Sen. Baucus, Max [D-MT]	MT	D	B000243	22	Expresses the sense of the Congress that: (1) U.S. negotiators, in negotiations with Japan, should insist that Japan dismantle all nontariff barriers to imports of beef; and (2) if progress is not made toward the dismantling of such nontariff barriers by a specified time, the U.S. Trade Representative should seek appropriate relief under U.S. and international trade law.	2021-06-29T21:26:10Z
98-sconres-64	98	sconres	64	A concurrent resolution to express the sense of the Congress relating to agricultural marketing orders.	Agriculture and Food	1983-08-04	1983-08-04	Referred to the Committee on Agriculture.	Senate	Sen. Levin, Carl [D-MI]	MI	D	L000261	12	Expresses the sense of Congress that: (1) the existing agricultural marketing order system contributes substantially to the well-being of the American people and should be preserved; and (2) decisions regarding the timing or implementing of such marketing orders should be the responsibility of the Secretary of Agriculture in conjunction with the affected producers.	2025-01-14T16:41:20Z
97-sconres-134	97	sconres	134	A concurrent resolution expressing the sense of the Congress that the National Food and Agriculture Exposition is a significant development that will contribute to expanded exports of United States agricultural products.	Agriculture and Food	1982-12-17	1982-12-17	Referred to the Committee on Agriculture.	Senate	Sen. Helms, Jesse [R-NC]	NC	R	H000463	3	Expresses the sense of Congress that the National Association of State Departments of Agriculture National Food and Agriculture Exposition is a significant development that will contribute to expanded U.S. agricultural exports.	2025-01-14T16:41:20Z
97-sconres-122	97	sconres	122	A concurrent resolution relating to the processed product share of U.S. agricultural exports.	Agriculture and Food	1982-09-17	1982-12-21	Referred to House Committee on Ways and Means.	Senate	Sen. Percy, Charles H. [R-IL]	IL	R	P000222	18	(Measure passed Senate, amended) Expresses the sense of the Congress that the President should take action to encourage increasing the processed product share of farm exports, including but not limited to: (1) urging U.S. negotiators to try to include a quantity of value-added processed farm products in grain agreements with the Soviet Union or other nonmarket economy countries; (2) seeking elimination of unfair trade practices by foreign competitors by pursuing international trade negotiations; and (3) using authorities of the Commodity Credit Corporation and the Export-Import Bank to ensure that credit arrangements for farm exports and farm product exports are on terms equal to those offered by other countries.	2024-02-07T16:32:33Z
97-sconres-121	97	sconres	121	A concurrent resolution expressing the sense of the Congress that the United States should maintain Federal involvement in, and support for, the child nutrition programs, and for other purposes.	Agriculture and Food	1982-09-16	1982-09-16	Referred to the Committee on Agriculture.	Senate	Sen. Dole, Robert J. [R-KS]	KS	R	D000401	55	Expresses the sense of Congress that: (1) national efforts to reduce hunger and malnutrition should continue; (2) a national commitment to vital nutrition programs should continue; and (3) the Federal Government should retain primary responsibility for child nutrition programs.	2025-01-14T16:41:20Z
97-sconres-111	97	sconres	111	A concurrent resolution to express the sense of the Congress that the National Endowment for Soil and Water Conservation shall be and is hereby endorsed by the United States Congress.	Agriculture and Food	1982-06-24	1982-06-29	Referred to Subcommittee on Soil and Water Conservation.	Senate	Sen. Jepsen, Roger W. [R-IA]	IA	R	J000101	0	Expresses the sense of the Congress in support of the National Endowment for Soil and Water Conservation.	2025-01-14T16:41:20Z
97-sconres-10	97	sconres	10	A concurrent resolution expressing the sense of the Congress concerning the continuing permanent conversion of productive agricultural lands to nonagricultural uses.	Agriculture and Food	1981-02-24	1981-03-04	Referred to Subcommittee on Forestry.	Senate	Sen. Hatfield, Mark O. [R-OR]	OR	R	H000343	35	Expresses the sense of Congress that agricultural resources are of strategic importance to the United States' future and calling for Federal cooperation with State and local governments and assistance to persons engaged in agriculture.	2025-01-14T16:41:20Z
94-sconres-138	94	sconres	138	A concurrent resolution relating to hunger and nutrition throughout the world.	Agriculture and Food	1976-09-01	1976-09-16	Measure passed Senate.	Senate	Sen. Humphrey, Hubert H. [D-MN]	MN	D	H000953	0	Declares it the sense of the Congress that every person has the right to a nutritionally adequate diet. Stresses the need to combat hunger and makes it a basic reference point of United States policy in all areas relating to nutrition. Asserts that the goal of the United States should be to substantially increase its food assistance abroad, especially to those countries needing increased food production and more efficient distribution patterns. Expresses the view that assistance ought to be more effective through use of coordinated efforts between international organizations, donor nations, and recipient countries.	2025-01-14T19:00:46Z
94-sconres-102	94	sconres	102	A concurrent resolution relating to the level of price support on certain agricultural commodities.	Agriculture and Food	1976-03-11	1976-03-11	Referred to Senate Committee on Agriculture and Forestry.	Senate	Sen. Abourezk, James [D-SD]	SD	D	A000017	8	Requests the Secretary of Agriculture to increase the price support level for milk, wheat, corn, feed grains and soybeans to 90 percent of the parity price.	2025-01-14T16:41:20Z
94-sconres-66	94	sconres	66	A concurrent resolution with regard to the world food crisis.	Agriculture and Food	1975-09-25	1975-09-25	Referred to Senate Committee on Agriculture and Forestry.	Senate	Sen. Hatfield, Mark O. [R-OR]	OR	R	H000343	23	Expresses the sense of Congress that every person has a right to an adequate diet. Provides that recognition of this right should guide United States policy. Seeks to have all who are in need receive help through food assistance programs. Calls for this country to increase its assistance for self-help development among the world's poorest nations.	2025-01-14T16:41:20Z
94-sconres-19	94	sconres	19	A concurrent resolution relating to the World Food Conference.	Agriculture and Food	1975-02-24	1975-06-17	Measure passed House in lieu of H. Con. Res. 136.	Senate	Sen. Culver, John C. [D-IA]	IA	D	C000979	1	Endorses the World Food Conference to be held in Ames, Iowa, from June 27 through July 1, 1976, and commends the Iowa State University of Science and Technology for a humanitarian undertaking of international significance.	2025-01-14T19:00:46Z
93-sconres-70	93	sconres	70	Resolved by the Senate (the House of Representatives concurring), that it is the sense of the Congress that the Secretary of Agriculture should immediately conduct a survey of all wheat milling firms and bakeries to determine their position with regard to wheat supplies and requirements during the remainder of the 1973-74 marketing year.	Agriculture and Food	1974-02-25	1974-02-26	Referred to House Committee on Agriculture.	Senate	Sen. Dole, Robert J. [R-KS]	KS	R	D000401	0	Makes it the sense of the Congress that the Secretary of Agriculture should immediately conduct a survey of all wheat milling firms and bakeries to determine their position with regard to wheat supplies and requirements during the remainder of the 1973-74 marketing year. Expresses the sense of Congress that the Secretary of Agriculture, at the earliest practicable date, conduct a county-by-county survey to determine the amount of uncommitted wheat stocks remaining in the ownership of all grain dealers and farmers. Expresses the sense of the Congress that the Secretary of Agriculture work with the Interstate Commerce Commission to expedite transportation of existing wheat stocks to the millers and bakers in need of additional supplies. Directs the Secretary of the Senate to transmit copies of this resolution to the Secretary of Agriculture and Chairman of the Interstate Commerce Commission after it has been agreed to by both Houses of Congress.	2024-08-01T18:39:34Z

Advanced export

JSON shape: default, array, newline-delimited, object

CREATE TABLE legislation (
    bill_id TEXT PRIMARY KEY,
    congress INTEGER,
    bill_type TEXT,
    bill_number INTEGER,
    title TEXT,
    policy_area TEXT,
    introduced_date TEXT,
    latest_action_date TEXT,
    latest_action_text TEXT,
    origin_chamber TEXT,
    sponsor_name TEXT,
    sponsor_state TEXT,
    sponsor_party TEXT,
    sponsor_bioguide_id TEXT,
    cosponsor_count INTEGER DEFAULT 0,
    summary_text TEXT,
    update_date TEXT,
    url TEXT
);
CREATE INDEX idx_leg_congress ON legislation(congress);
CREATE INDEX idx_leg_type ON legislation(bill_type);
CREATE INDEX idx_leg_policy ON legislation(policy_area);
CREATE INDEX idx_leg_date ON legislation(introduced_date);
CREATE INDEX idx_leg_sponsor ON legislation(sponsor_name);
CREATE INDEX idx_leg_sponsor_bioguide ON legislation(sponsor_bioguide_id);