openregs: legislation: 204 rows where bill_type = "hres" and policy_area = "Private Legislation" 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

204 rows where bill_type = "hres" and policy_area = "Private Legislation" 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	summary_text	update_date
112-hres-191	112	hres	191	Referring the bill (H.R. 1107), entitled "For the relief of Adrian Rodriguez", to the chief judge of the United States Court of Federal Claims for a report thereon.	Private Legislation	2011-03-30	2011-03-30	Referred to the House Committee on the Judiciary.	House	Rep. Filner, Bob [D-CA-51]	CA	D	F000116	Refers a private relief bill (H.R. 1107) to the chief judge of the U.S. Court of Federal Claims with instructions to report back to the House of Representatives.	2019-02-20T19:56:32Z
112-hres-192	112	hres	192	Referring the bill (H.R. 1108), entitled "For the relief of Francisco Rivera and Alfonso Calderon", to the chief judge of the United States Court of Federal Claims for a report thereon.	Private Legislation	2011-03-30	2011-03-30	Referred to the House Committee on the Judiciary.	House	Rep. Filner, Bob [D-CA-51]	CA	D	F000116	Refers a private relief bill (H.R. 1108) to the chief judge of the U.S. Court of Federal Claims with instructions to report back to the House of Representatives.	2019-02-20T19:56:32Z
111-hres-105	111	hres	105	Referring the bill (H.R. 798), entitled "For the relief of Adrian Rodriguez", to the chief judge of the United States Court of Federal Claims for a report thereon.	Private Legislation	2009-02-03	2009-03-16	Referred to the Subcommittee on Immigration, Citizenship, Refugees, Border Security, and International Law.	House	Rep. Filner, Bob [D-CA-51]	CA	D	F000116	Refers a specified private relief bill to the chief judge of the United States Court of Federal Claims with instructions for a report back to the House of Representatives.	2019-11-15T21:35:18Z
111-hres-106	111	hres	106	Referring the bill (H.R. 799), entitled "For the relief of Francisco Rivera and Alfonso Calderon", to the chief judge of the United States Court of Federal Claims for a report thereon.	Private Legislation	2009-02-03	2009-03-16	Referred to the Subcommittee on Immigration, Citizenship, Refugees, Border Security, and International Law.	House	Rep. Filner, Bob [D-CA-51]	CA	D	F000116	Refers a specified private relief bill to the chief judge of the United States Court of Federal Claims with instructions for a report back to the House of Representatives.	2019-11-15T21:35:18Z
110-hres-797	110	hres	797	Referring the bill (H.R. 4038), entitled "For the relief of Adrian Rodriguez", to the chief judge of the United States Court of Federal Claims for a report thereon.	Private Legislation	2007-11-05	2007-11-05	Referred to the House Committee on the Judiciary.	House	Rep. Filner, Bob [D-CA-51]	CA	D	F000116	Refers H.R. 4038 (private relief) to the chief judge of the United States Court of Federal Claims for a report.	2023-01-11T20:11:06Z
110-hres-798	110	hres	798	Referring the bill (H.R. 4037), entitled "For the relief of Francisco Rivera and Alfonso Calderon", to the chief judge of the United States Court of Federal Claims for a report thereon.	Private Legislation	2007-11-05	2007-11-05	Referred to the House Committee on the Judiciary.	House	Rep. Filner, Bob [D-CA-51]	CA	D	F000116	Refers H.R. 4037 (private relief) to the chief judge of the United States Court of Federal Claims for a report.	2023-01-11T20:11:07Z
110-hres-381	110	hres	381	Referring the bill (H.R. 2124), entitled "A bill for the relief of Adela and Darryl Bailor", to the chief judge of the United States Court of Federal Claims for a report thereon.	Private Legislation	2007-05-07	2007-05-07	Referred to the House Committee on the Judiciary.	House	Rep. Carson, Julia [D-IN-7]	IN	D	C000191	Refers a pending private bill for the relief of Adela and Darryl Bailor to the chief judge of the United States Court of Federal Claims for preparation of a report to the House of Representatives that provides: (1) findings of fact and conclusions of law on the nature, extent, and character of the claim for compensation referred to in the pending bill as a legal or equitable claim against the United States; and (2) the amount, if any, that is legally or equitably due from the United States to Adela and Darryl Bailor.	2023-01-11T16:32:46Z
109-hres-201	109	hres	201	Referring the bill (H.R. 1328) entitled "A bill for the relief of Adela and Darryl Bailor" to the chief judge of the United States Court of Federal Claims for a report thereon.	Private Legislation	2005-04-06	2006-07-27	Forwarded by Subcommittee to Full Committee by Voice Vote .	House	Rep. Carson, Julia [D-IN-7]	IN	D	C000191	Refers "A bill for the relief of Adela and Darryl Bailor", which is now pending in the House of Representatives, to the chief judge of the United States Court of Federal Claims.	2019-11-15T21:34:41Z
108-hres-589	108	hres	589	Referring the bill (H.R. 3646) entitled "A bill for the relief of Adela and Darryl Bailor" to the chief judge of the United States Court of Federal Claims for a report thereon.	Private Legislation	2004-03-30	2004-09-14	Forwarded by Subcommittee to Full Committee by Voice Vote.	House	Rep. Carson, Julia [D-IN-7]	IN	D	C000191	Refers a pending private bill for the relief of Adela and Darryl Bailor to the chief judge of the United States Court of Federal Claims for preparation of a report to the House of Representatives that provides: (1) findings of fact and conclusions of law on the nature, extent, and character of the claim for compensation referred to in the pending bill as a legal or equitable claim against the United States; and (2) the amount, if any, that is legally or equitably due from the United States to Adela and Darryl Bailor.	2023-01-15T10:47:54Z
106-hres-636	106	hres	636	Referring the bill (H.R. ), entitled "A bill for the relief of Sarabeth M. Davis, Robert S. Borders, Victor Maron, Irving Berke, and Adele E. Conrad", to the chief judge of the United States Court of Federal Claims for a report thereon.	Private Legislation	2000-10-17	2000-10-25	Referred to the Subcommittee on Immigration and Claims.	House	Rep. Cox, Christopher [R-CA-47]	CA	R	C000830	Refers H.R. 5481 (private relief) to the chief judge of the United States Court of Federal Claims for a report.	2025-01-02T17:08:29Z
106-hres-141	106	hres	141	For the relief of Vince Munoz, Governor of the Tribal Council of the Ysleta del Sur Pueblo and all other enrolled members of the Ysleta del Sur Pueblo.	Private Legislation	1999-04-15	1999-04-28	Referred to the Subcommittee on Immigration and Claims.	House	Rep. Reyes, Silvestre [D-TX-16]	TX	D	R000170	Refers H.R. 1473 (for the relief of a named individual and enrolled members of a specified Indian tribe) to the Chief Judge of the United States Court of Federal Claims for review.	2025-01-02T17:07:55Z
105-hres-222	105	hres	222	For the relief of Vince Munoz, Governor of the Tribal Council of the Ysleta del Sur Pueblo and all other enrolled members of the Ysleta del Sur Pueblo.	Private Legislation	1997-09-05	1997-09-05	Referred to the House Committee on the Judiciary.	House	Rep. Reyes, Silvestre [D-TX-16]	TX	D	R000170	Refers H.R. 2426 (for the relief of a named individual and enrolled members of a specified Indian tribe) to the chief judge of the United States Court of Federal Claims for review.	2025-04-07T15:33:55Z
103-hres-178	103	hres	178	Referring the bill (H.R. 2196) for the relief of John W. Ruth, Sr., to the chief judge of the United States Court of Federal Claims.	Private Legislation	1993-05-19	1993-05-24	Referred to the Subcommittee on Administrative Law and Governmental Relations.	House	Rep. Duncan, John J., Jr. [R-TN-2]	TN	R	D000533	Refers a specified bill for the relief of a named individual to the chief judge of the United States Court of Federal Claims.	2025-01-02T17:21:05Z
103-hres-157	103	hres	157	Referring the bill (H.R. 1752) for the relief of Sergeant Major Earnest Sands (Ret.) and Roger Sands to the chief judge of the United States Claims Court.	Private Legislation	1993-04-21	1993-04-23	Referred to the Subcommittee on Administrative Law and Governmental Relations.	House	Rep. Hyde, Henry J. [R-IL-6]	IL	R	H001022	Refers H.R. 1752 (for the relief of certain named individuals) to the chief judge of the United States Court of Federal Claims.	2025-01-02T17:21:05Z
102-hres-568	102	hres	568	Referring the bill (H.R. 5953) for the relief of Donald W. Sneeden, Mary S. Sneeden, and Henry C. Best, to the chief judge of the United States Claims Court.	Private Legislation	1992-09-16	1992-10-04	The title of the measure was amended. Agreed to without objection.	House	Rep. Rose, Charlie [D-NC-7]	NC	D	R000436	Refers, H.R. 5953, a bill for the relief of three named individuals, to the chief judge of the United States Claims Court.	2021-06-07T15:22:51Z
102-hres-492	102	hres	492	Referring the bill (H.R. 5426) for the relief of Bear Claw Tribe, Incorporated, to the chief judge of the United States Claims Court.	Private Legislation	1992-06-17	1992-09-15	The title of the measure was amended. Agreed to without objection.	House	Rep. Williams, Pat [D-MT-1]	MT	D	W000520	Refers a specified bill for the relief of a named public benefit corporation to the chief judge of the United States Claims Court.	2021-06-07T15:22:52Z
102-hres-29	102	hres	29	For the relief of Global Exploration and Development Corporation, Kerr-McGee Corporation, and Kerr-McGee Chemical Corporation.	Private Legislation	1991-01-10	1992-07-21	Motion to reconsider laid on the table Agreed to without objection.	House	Rep. McCollum, Bill [R-FL-5]	FL	R	M000350	Refers H.R. 477, a bill for the relief of three named corporations, to the chief judge of the United States Claims Court.	2021-06-07T15:22:52Z
101-hres-491	101	hres	491	For the relief of Global Exploration and Development Corporation, Kerr-McGee Corporation and Kerr-McGee Chemical Corporation.	Private Legislation	1990-10-02	1990-10-11	Referred to the Subcommittee on Administrative Law and Governmental Relations.	House	Rep. McCollum, Bill [R-FL-5]	FL	R	M000350	Refers H.R. 5776, a bill for the relief of certain corporations, to the chief judge of the United States Claims Court.	2021-07-01T13:17:20Z
101-hres-308	101	hres	308	Referring the bill (H.R. 3894) for the relief of Banfi Products Corporation to the chief judge of the United States Claims Court.	Private Legislation	1990-01-24	1990-10-02	Motion to reconsider laid on the table Agreed to without objection.	House	Rep. Mrazek, Robert J. [D-NY-3]	NY	D	M001057	Refers H.R. 3894, a bill for the relief of a named corporation, to the chief judge of the United States Claims Court.	2021-07-01T15:54:49Z
101-hres-147	101	hres	147	Referring the bill (H.R. 1555) for the relief of Harold N. Holt to the chief judge of the United States Claims Court.	Private Legislation	1989-05-03	1989-05-09	Referred to the Subcommittee on Administrative Law and Governmental Relations.	House	Rep. Saxton, Jim [R-NJ-13]	NJ	R	S000097	Refers H.R. 1555, a bill for the relief of a named individual, to the chief judge of the United States Claims Court.	2021-07-01T13:15:09Z
100-hres-398	100	hres	398	A resolution honoring the American Culinary Federation for its contributions to American cuisine and for its support of the 1988 American Culinary Olympic Team.	Private Legislation	1988-03-09	1988-03-21	Referred to Subcommittee on Census and Population.	House	Rep. Panetta, Leon [D-CA-16]	CA	D	P000047	Declares that the House of Representatives honors a named culinary professional association for its contributions to American cuisine and for its support of the 1988 American Culinary Olympic Team.	2024-02-06T20:04:02Z
100-hres-200	100	hres	200	A resolution referring the bill (H.R. 2098) for the relief of Frederick Paul of Seattle, Washington, to the chief judge of the United States Claims Court.	Private Legislation	1987-06-17	1988-10-04	Recommitted by House to House Committee on The Judiciary by Virtue of Objection Made on Call of Private Calendar.	House	Rep. Lowry, Mike [D-WA-7]	WA	D	L000486	Refers H.R. 2098, a bill for the relief of a named individual, to the chief judge of the United States Claims Court.	2021-06-10T20:22:44Z
100-hres-147	100	hres	147	A resolution referring the bill (H.R. 2098) for the relief of Frederick Paul of Seattle, Washington, to the chief judge of the United States Claims Court.	Private Legislation	1987-04-09	1987-04-14	Referred to Subcommittee on Administrative Law and Governmental Relations.	House	Rep. Lowry, Mike [D-WA-7]	WA	D	L000486	Refers H.R. 2098, a bill for the relief of a named individual, to the chief judge of the United States Claims Court.	2021-06-10T20:22:34Z
100-hres-123	100	hres	123	A resolution to refer the bill (H.R. 1669) for the relief of John W. Ruth, Senior, to the chief judge of the United States Claims Court.	Private Legislation	1987-03-17	1987-03-24	Referred to Subcommittee on Administrative Law and Governmental Relations.	House	Rep. Duncan, John J. [R-TN-2]	TN	R	D000534	Refers H.R. 1669, a bill for the relief of a named individual, to the chief judge of the United States Claims Court.	2021-06-10T20:22:27Z
100-hres-120	100	hres	120	A resolution to refer H.R. 1540 to the chief judge of the United States Claims Court.	Private Legislation	1987-03-11	1987-03-13	Referred to Subcommittee on Administrative Law and Governmental Relations.	House	Rep. Pashayan, Charles, Jr. [R-CA-17]	CA	R	P000097	Refers H.R. 1540, a bill for the relief of two named individuals, to the chief judge of the United States Claims Court.	2021-06-10T20:22:25Z
100-hres-92	100	hres	92	A resolution referring the bill (H.R.1192) for the relief of Harold N. Holt to the chief judge of the United States Claims Court.	Private Legislation	1987-02-19	1987-02-24	Referred to Subcommittee on Administrative Law and Governmental Relations.	House	Rep. Saxton, Jim [R-NJ-13]	NJ	R	S000097	Refers H.R. 1192, a bill for the relief of a named individual, to the chief judge of the United States Claims Court.	2021-06-10T20:22:19Z
100-hres-61	100	hres	61	A resolution to refer H.R. 816 to the Chief Commissioner of the United States Court of Claims.	Private Legislation	1987-02-02	1988-09-22	Resolution Agreed to in House by Voice Vote.	House	Rep. Brown, Hank [R-CO-4]	CO	R	B000919	Refers H.R. 816, a bill for the relief of certain individuals, to the chief judge of the United States Claims Court.	2021-06-10T20:22:11Z
99-hres-579	99	hres	579	A resolution to refer the bill (H.R. 5663) for the relief of John W. Ruth, Senior, to the chief judge of the United States Claims Court.	Private Legislation	1986-10-07	1986-10-07	Referred to House Committee on The Judiciary.	House	Rep. Duncan, John J. [R-TN-2]	TN	R	D000534	Refers H.R. 5663, a bill for the relief of a named individual, to the chief judge of the United States Claims Court.	2021-06-30T18:55:06Z
99-hres-467	99	hres	467	A resolution to refer the bill H.R. 4955 for the relief of Harold N. Holt to the chief judge of the United States Claims Court.	Private Legislation	1986-06-05	1986-06-05	Referred to House Committee on The Judiciary.	House	Rep. Saxton, Jim [R-NJ-13]	NJ	R	S000097	Refers H.R. 4955, a bill for the relief of a named individual, to the chief judge of the United States Claims Court.	2021-06-30T18:54:39Z
99-hres-396	99	hres	396	A resolution recognizing and commending Lee Iacocca for his contribution in the renovation of the Statue of Liberty and Ellis Island, and calling on the Department of the Interior to reinstate Mr. Iacocca as Chairman of the Statue of Liberty-Ellis Island Centennial Commission.	Private Legislation	1986-03-11	1986-03-18	Referred to Subcommittee on Census and Population.	House	Rep. Roe, Robert A. [D-NJ-8]	NJ	D	R000383	Commends a named individual for his outstanding efforts toward the renovation of the Statue of Liberty and Ellis Island. Calls upon the Department of the Interior to reinstate such individual as Chairman of the Statue of Liberty-Ellis Island Centennial Commission.	2024-02-06T20:04:02Z
99-hres-61	99	hres	61	A resolution referring the bill (H.R. 1151) for the relief of Frederick Paul to the Chief Judge of the United States Claims Court.	Private Legislation	1985-02-19	1985-02-19	Referred to House Committee on The Judiciary.	House	Rep. Lowry, Mike [D-WA-7]	WA	D	L000486	Refers H.R. 1151, a bill for the relief of a named individual, to the chief judge of the United States Claims Court.	2021-06-30T18:53:00Z
99-hres-26	99	hres	26	A resolution to refer H.R. 487 to the chief commissioner of the United States Court of Claims.	Private Legislation	1985-01-03	1985-01-03	Referred to House Committee on The Judiciary.	House	Rep. Brown, Hank [R-CO-4]	CO	R	B000919	Refers H.R. 487, a bill for the relief of certain individuals, to the chief judge of the United States Claims Court.	2021-06-30T18:52:54Z
98-hres-571	98	hres	571	A resolution referring the bill H.R. 6143 for the relief of Frederick Paul to the Chief Judge of the United States Claims Court.	Private Legislation	1984-08-09	1984-08-09	Referred to House Committee on The Judiciary.	House	Rep. Lowry, Mike [D-WA-7]	WA	D	L000486	Refers H.R. 6143, a bill for the relief of a named individual, to the chief judge of the United States Claims Court.	2021-06-29T19:59:42Z
98-hres-538	98	hres	538	A resolution to refer H.R. 5895 to the chief commissioner of the United States Court of Claims.	Private Legislation	1984-06-26	1984-06-26	Referred to House Committee on The Judiciary.	House	Rep. Brown, Hank [R-CO-4]	CO	R	B000919	Refers H.R. 5895, a bill for the relief of named individuals, to the chief judge of the United States Claims Court.	2021-06-29T19:59:32Z
98-hres-525	98	hres	525	A resolution to refer the bill H.R. 5869 for the relief of Naum S. Bers to the Chief Judge of the United States Claims Court.	Private Legislation	1984-06-18	1984-06-18	Referred to House Committee on The Judiciary.	House	Del. Fauntroy, Walter E. [D-DC-At Large]	DC	D	F000046	Refers H.R. 5869, a bill for the relief of a named individual, to the chief judge of the United States Claims Court.	2021-06-29T19:59:29Z
98-hres-368	98	hres	368	A resolution to refer H.R. 4349 to the chief Judge of the United States Claims Court.	Private Legislation	1983-11-09	1983-11-09	Referred to House Committee on The Judiciary.	House	Rep. Lagomarsino, Robert J. [R-CA-19]	CA	R	L000020	Refers H.R. 4349, a bill for the relief of a named individual, to the chief judge of the United States Claims Court.	2021-06-29T19:58:45Z
98-hres-369	98	hres	369	A resolution to refer H.R. 4292 to the chief judge of the United States Claims Court.	Private Legislation	1983-11-09	1983-11-09	Referred to House Committee on The Judiciary.	House	Rep. Pashayan, Charles, Jr. [R-CA-17]	CA	R	P000097	Refers H.R. 4292, a bill for the relief of two named individuals, to the chief judge of the United States Claims Court.	2021-06-29T19:58:46Z
98-hres-294	98	hres	294	A resolution to refer H.R. 3685 to the Chief Commissioner of the United States Claims Court.	Private Legislation	1983-08-01	1983-08-01	Referred to House Committee on The Judiciary.	House	Rep. Hyde, Henry J. [R-IL-6]	IL	R	H001022	Refers H.R. 3685, a bill for the relief of a named individual, to the chief judge of the United States Claims Court.	2021-06-29T19:58:26Z
98-hres-264	98	hres	264	A resolution to commend Gregory Karam for his actions as an air traffic controller in the rescue of the crew and passengers of a burning Canadian aircraft.	Private Legislation	1983-07-13	1983-07-18	Referred to Subcommittee on Census and Population.	House	Rep. McEwen, Bob [R-OH-6]	OH	R	M000432	Commends a named air traffic controller for his performance during a fire emergency situation.	2024-02-06T20:04:02Z
98-hres-162	98	hres	162	A resolution to refer the bill, H.R. 2569, for the relief of Harold N. Holt to the Chief Commissioner of the Court of Claims.	Private Legislation	1983-04-14	1983-04-14	Referred to House Committee on The Judiciary.	House	Rep. Forsythe, Edwin B. [R-NJ-13]	NJ	R	F000286	Refers H.R. 2569, a bill for the relief of a named individual, to the chief judge of the United States Claims Court.	2021-06-29T19:57:40Z
98-hres-148	98	hres	148	A resolution to commend the Golden 1 Credit Union of Sacramento, California for 50 years of growth and success in serving the consumer financial needs of its depositors and borrowers.	Private Legislation	1983-03-22	1983-05-02	Referred to Subcommittee on Census and Population.	House	Rep. Fazio, Vic [D-CA-4]	CA	D	F000053	Commends a named credit union of Sacramento, California.	2024-02-06T20:04:02Z
98-hres-131	98	hres	131	A resolution honoring Colonel George Snyder.	Private Legislation	1983-03-09	1983-03-17	Referred to Subcommittee on Census and Population.	House	Rep. Frank, Barney [D-MA-4]	MA	D	F000339	Honors a named individual for his role in forming the Non-Commissioned Officers Leadership School.	2024-02-06T20:04:02Z
98-hres-129	98	hres	129	A resolution to refer H.R. 1982 to the Chief Commissioner of the United States Court of Claims.	Private Legislation	1983-03-08	1983-03-08	Referred to House Committee on The Judiciary.	House	Rep. Bryant, John W. [D-TX-5]	TX	D	B000997	Refers H.R. 1982, a bill for the relief of three named individuals, to the chief judge of the United States Claims Court.	2021-06-29T19:57:30Z
98-hres-96	98	hres	96	A resolution to refer H.R. 1559 to the Chief Commissioner of the Court of Claims.	Private Legislation	1983-02-17	1983-02-17	Referred to House Committee on The Judiciary.	House	Rep. Foley, Thomas S. [D-WA-5]	WA	D	F000239	Refers H.R. 1559, a bill for the relief of a named individual, to the chief judge of the United States Claims Court.	2021-06-29T19:57:21Z
98-hres-69	98	hres	69	A resolution to refer the bill, H.R. 1232, to the Chief Judge of the U.S. Claims Court.	Private Legislation	1983-02-08	1983-11-01	Resolution Agreed to in House (Amended) by Unanimous Consent.	House	Rep. Breaux, John B. [D-LA-7]	LA	D	B000780	Refers H.R. 1232, a bill for the relief of a named individual and members of named Indian tribes, to the chief judge of the United States Claims Court.	2021-06-29T19:57:09Z
98-hres-57	98	hres	57	A resolution to refer H.R. 744 to the chief judge of the United States Claims Court.	Private Legislation	1983-02-02	1983-11-01	Resolution Agreed to in House by Unanimous Consent.	House	Rep. Stump, Bob [R-AZ-3]	AZ	R	S001044	Refers H.R. 744, a bill for the relief of a named business, to the chief judge of the United States Claims Court.	2021-06-29T19:57:05Z
98-hres-23	98	hres	23	A resolution to refer the bill entitled "A bill for the relief of Aetna Insurance Company, and other insurance companies" to the Chief Commissioner of the United States Court of Claims.	Private Legislation	1983-01-03	1983-01-03	Referred to House Committee on The Judiciary.	House	Rep. Hansen, George V. [R-ID-2]	ID	R	H000171	Refers H.R. 439, a bill for the relief of named insurance companies, to the chief judge of the United States Claims Court.	2021-06-29T19:56:54Z
97-hres-564	97	hres	564	A resolution opposing the granting of permanent residence in the United States to certain aliens.	Private Legislation	1982-08-16	1982-08-16	Referred to House Committee on The Judiciary.	House	Rep. Mazzoli, Romano L. [D-KY-3]	KY	D	M000291	Expresses the disapproval of the House of Representatives for the granting of permanent residence to certain named aliens.	2023-05-11T13:00:48Z
97-hres-442	97	hres	442	A resolution to refer that bill entitled, "a bill for the relief of Aetna Insurance Company, and other Insurance Companies" to the Chief Commissioner of the United States Court of Claims.	Private Legislation	1982-04-28	1982-04-28	Referred to House Committee on The Judiciary.	House	Rep. Hansen, George V. [R-ID-2]	ID	R	H000171	Refers to the Chief Commissioner of the Court of Claims a bill for the relief of a named company.	2023-05-11T13:00:39Z
97-hres-416	97	hres	416	A resolution acknowledging April 10, 1982, as the one hundredth anniversary of the founding of the Matson Navigation Company.	Private Legislation	1982-03-30	1982-04-15	Referred to Subcommittee on Census and Population.	House	Rep. Heftel, Cecil [D-HI-1]	HI	D	H000449	Extends the congratulations of the House of Representatives to the Matson Navigation Company.	2024-02-06T20:04:02Z
97-hres-386	97	hres	386	A resolution to refer H.R. 5784 to the Chief Commissioner of the United States Court of Claims.	Private Legislation	1982-03-10	1982-03-10	Referred to House Committee on The Judiciary.	House	Rep. Hyde, Henry J. [R-IL-6]	IL	R	H001022	Refers a bill for the relief of a named individual to the Chief Commissioner of the Court of Claims.	2023-05-11T13:00:35Z
97-hres-354	97	hres	354	A resolution to refer H.R. 5482 to the Chief Commissioner of the Court of Claims.	Private Legislation	1982-02-08	1982-02-08	Referred to House Committee on The Judiciary.	House	Rep. Foley, Thomas S. [D-WA-5]	WA	D	F000239	Refers to the Chief Commissioner of the Court of Claims a bill for the relief of a named individual.	2023-05-11T13:00:33Z
97-hres-298	97	hres	298	A resolution to refer H.R. 5143 to the chief commissioner of the United States Court of Claims.	Private Legislation	1981-12-09	1981-12-09	Referred to House Committee on The Judiciary.	House	Rep. Brown, Hank [R-CO-4]	CO	R	B000919	Refers to the Chief Commissioner of the Court of Claims, a bill for relief of a named individual.	2023-05-11T13:00:28Z
97-hres-293	97	hres	293	A resolution opposing the granting of permanent residence in the United States to certain aliens.	Private Legislation	1981-12-08	1981-12-15	Resolution Agreed to in House by Voice Vote.	House	Rep. Mazzoli, Romano L. [D-KY-3]	KY	D	M000291	Expresses the opposition of the House of Representatives to the granting of permanent residence in the United States to six named individuals.	2023-05-11T13:00:28Z
97-hres-282	97	hres	282	A resolution opposing the granting of permanent residence in the United States to certain aliens.	Private Legislation	1981-11-19	1981-12-15	Resolution Agreed to in House by Unanimous Consent.	House	Rep. Mazzoli, Romano L. [D-KY-3]	KY	D	M000291	Expresses the opposition of the House of Representatives to the granting of permanent residence in the United States to certain named individuals.	2023-05-11T13:00:27Z
97-hres-278	97	hres	278	A resolution to refer H.R. 4994 to the chief commissioner of the United States Court of Claims.	Private Legislation	1981-11-17	1981-11-17	Referred to House Committee on The Judiciary.	House	Rep. Stump, Bob [D-AZ-3]	AZ	D	S001044	Refers a bill for the relief of a named individual to the Chief Commissioner of the Court of Claims.	2023-05-11T13:00:27Z
97-hres-136	97	hres	136	A resolution authorizing the Committee on the Judiciary to refer H.R. 3316 to the court of claims for further proceedings in accordance with applicable law.	Private Legislation	1981-05-01	1981-05-01	Referred to House Committee on The Judiciary.	House	Rep. Shumway, Norman D. [R-CA-14]	CA	R	S000393	Refers to the Chief Commissioner of the Court of Claims a bill for the relief of a named individual. Directs the Commissioner to report to the House of Representatives on the nature of the claim against the United States and the amount, if any, due such individual from the United States.	2023-05-11T13:00:14Z
97-hres-114	97	hres	114	A resolution to refer the bill, H.R. 2337, to the Chief Commissioner of the Court of Claims.	Private Legislation	1981-03-19	1981-03-19	Referred to House Committee on The Judiciary.	House	Rep. Breaux, John B. [D-LA-7]	LA	D	B000780	Refers to the Chief Commissioner of the Court of Claims a bill for the relief of named Indian tribes. Directs the Commissioner to report to the House of Representatives on the nature of the claim against the United States and the amount, if any, due such tribes from the United States.	2023-05-11T13:00:11Z
97-hres-103	97	hres	103	A resolution to refer the bill for the relief of Harold N. Holt to the Chief Commissioner of the Court of Claims.	Private Legislation	1981-03-05	1981-03-05	Referred to House Committee on The Judiciary.	House	Rep. Forsythe, Edwin B. [R-NJ-6]	NJ	R	F000286	Refers to the Chief Commissioner of the Court of Claims a bill for the relief of a named individual. Directs the Commission to report to the House of Representatives on the nature of the claim against the United States and the amount, if any, due such individual from the United States.	2023-05-11T13:00:09Z
97-hres-40	97	hres	40	A resolution for the relief of Robert Jayson, William Jayson and Jennie Jayson.	Private Legislation	1981-01-23	1981-01-23	Referred to House Committee on The Judiciary.	House	Rep. Mattox, James A. [D-TX-5]	TX	D	M000260	Refers to the Chief Commissioner of the Court of Claims a bill for the relief of a named individual.	2023-05-11T13:00:00Z
96-hres-816	96	hres	816	A resolution opposing the granting of permanent residence in the United States to certain aliens.	Private Legislation	1980-12-01	1980-12-03	Measure passed House.	House	Rep. Holtzman, Elizabeth [D-NY-16]	NY	D	H000752	Disapproves the granting of permanent residence in the United States to 50 named individuals pursuant to the Immigration and Nationality Act.	2025-04-07T14:20:29Z
96-hres-817	96	hres	817	A resolution opposing the granting of permanent residence in the United States to certain Aliens.	Private Legislation	1980-12-01	1980-12-03	Measure passed House.	House	Rep. Holtzman, Elizabeth [D-NY-16]	NY	D	H000752	Disapproves the granting of permanent residence in the United States to a named individual pursuant to the Immigration and Nationality Act.	2025-04-07T14:20:29Z
96-hres-741	96	hres	741	A resolution to refer the bill, H. R. 6559, to the Chief Commissioner of the Court of Claims.	Private Legislation	1980-07-02	1980-07-02	Referred to House Committee on the Judiciary.	House	Rep. Butler, M. Caldwell [R-VA-6]	VA	R	B001182	Refers to the Chief Commissioner of the Court of Claims a bill for the relief of two named individuals.	2021-06-14T19:15:10Z
96-hres-742	96	hres	742	A resolution to refer the bill, H.R. 7683, to the Chief Commissioner of the Court of Claims.	Private Legislation	1980-07-02	1980-07-02	Referred to House Committee on the Judiciary.	House	Rep. Petri, Thomas E. [R-WI-6]	WI	R	P000265	Refers to the Chief Commissioner of the Court of Claims a bill for the relief of two named individuals.	2021-06-14T19:15:10Z
96-hres-613	96	hres	613	A resolution to refer the bill (H.R. 6803) entitled "A bill for the relief of the estate of Colonel Leslie A. Skinner", to the Chief Commissioner of the United States Court of Claims for a report thereon.	Private Legislation	1980-03-18	1980-03-18	Referred to House Committee on the Judiciary.	House	Rep. Gudger, V. Lamar [D-NC-11]	NC	D	G000515	Refers to the Chief Commissioner of the Court of Claims, a bill for the relief of a named individual's estate. Directs the Commissioner to report to the House of Representatives on the nature of the claim against the United States and the amount, if any, due such individual's estate from the United States.	2021-06-14T19:14:41Z
96-hres-413	96	hres	413	A resolution to refer the bill (H.R. 5358) for the relief of Stencel Aero Engineering Corporation to the Chief Commissioner of the Court of Claims.	Private Legislation	1979-09-20	1979-09-20	Referred to House Committee on the Judiciary.	House	Rep. Gudger, V. Lamar [D-NC-11]	NC	D	G000515	Refers H.R. 5358 to the Chief Commissioner of the United States Court of Claims for further proceedings.	2021-06-14T19:13:48Z
96-hres-377	96	hres	377	A resolution to refer the bill, H.R. 4836, entitled "A bill for the relief of the Upper Allegheny Sand and Gravel Company", together with all the accompanying papers, to the Chief Commissioner of the Court of Claims.	Private Legislation	1979-07-18	1979-07-18	Referred to House Committee on the Judiciary.	House	Rep. Clinger, William F., Jr. [R-PA-23]	PA	R	C000523	Refers to the Chief Commissioner of the Court of Claims a bill for the relief of a named company, for further proceedings in accordance with applicable law.	2021-06-14T19:13:40Z
96-hres-327	96	hres	327	A resolution to refer H.R. 4482, a bill for the relief of Larry Land, Marie Land, et. al., to the Chief Commissioner of the United States Court of Claims.	Private Legislation	1979-06-21	1979-06-21	Referred to House Committee on the Judiciary.	House	Rep. Johnson, James P. (Jim) [R-CO-4]	CO	R	J000148	Refers H.R. 4482 to the Chief Commissioner of the United States Court of Claims for further proceedings.	2021-06-14T19:13:28Z
96-hres-295	96	hres	295	A resolution to refer the bill H.R. 4162 for the relief of the Estate of Major John E. Doyle to the Chief Commissioner of the United States Court of Claims.	Private Legislation	1979-05-31	1979-05-31	Referred to House Committee on the Judiciary.	House	Rep. Brown, Clarence, Jr. [R-OH-7]	OH	R	B000910	Refers H.R. 4162 to the Chief Commissioner of the United States Court of Claims for further proceedings.	2021-06-14T19:13:21Z
96-hres-269	96	hres	269	A resolution to refer the bill (H.R. 4089) entitled "A bill for the relief of Robert Jayson, William Jayson, and Jennie Jayson," to the Chief Commissioner of the United States Court of Claims.	Private Legislation	1979-05-14	1979-05-14	Referred to House Committee on the Judiciary.	House	Rep. Mattox, James A. [D-TX-5]	TX	D	M000260	Refers to the Chief Commissioner of the Court of Claims a bill for the relief of named individuals, for further proceedings in accordance with specified law.	2021-06-14T19:13:14Z
96-hres-264	96	hres	264	A resolution to refer H.R. 2319, a bill for the relief of Elena Schwarze-Chamier, to the Chief Commissioner of the Court of Claims.	Private Legislation	1979-05-09	1979-05-09	Referred to House Committee on the Judiciary.	House	Rep. Fisher, Joesph L. [D-VA-10]	VA	D	F000151	Refers to the Chief Commissioner of the Court of Claims a bill for the relief of a named individual, for further proceedings in accordance with applicable law.	2021-06-14T19:13:12Z
96-hres-246	96	hres	246	A resolution referring H.R. 912 to the Chief Commissioner of the Court of Claims.	Private Legislation	1979-05-01	1979-05-01	Referred to House Committee on the Judiciary.	House	Rep. Horton, Frank J. [R-NY-34]	NY	R	H000797	Refers to the Chief Commissioner of the Court of Claims a bill for the relief of a named individual, for further proceedings in accordance with applicable law.	2021-06-14T19:13:09Z
96-hres-237	96	hres	237	A bill to refer the bill, H. R. 3705, to the Chief Commissioner of the Court of Claims.	Private Legislation	1979-04-25	1979-04-25	Referred to House Committee on the Judiciary.	House	Rep. Green, S. William [R-NY-18]	NY	R	G000417	Refers to the Chief Commissioner of the Court of Claims a bill for the relief of a named individual, for further proceedings in accordance with applicable law.	2021-06-14T19:13:07Z
96-hres-226	96	hres	226	A resolution expressing the sense of the House that Dr. Harold R. Denton, Director of the Office of Nuclear Reactor Regulation at the Nuclear Regulatory Commission, is to be commended highly for his extraordinary leadership, dedication and hard work in the effort to resolve the problems at Three Mile Island.	Private Legislation	1979-04-10	1979-04-10	Referred to House Committee on Post Office and Civil Service.	House	Rep. Walker, Robert S. [R-PA-16]	PA	R	W000068	Commends the Director of the Office of Nuclear Reactor Regulation at the Nuclear Regulatory Commission for his leadership and efforts in resolving the problems at Three Mile Island.	2024-02-06T20:04:02Z
96-hres-188	96	hres	188	A resolution noting the retirement of Joel W. Solomon, and expressing gratitude for his contributions as a public servant.	Private Legislation	1979-03-28	1979-03-28	Referred to House Committee on Post Office and Civil Service.	House	Rep. Jones, Ed [D-TN-7]	TN	D	J000216	Honors and expresses the gratitude of the House of Representatives to a named individual at the time of his retirement from the position of Administrator of the General Services Administration.	2024-02-06T20:04:02Z
96-hres-175	96	hres	175	A resolution to refer the bill, H.R. 2711, to the Chief Commissioner of the Court of Claims.	Private Legislation	1979-03-21	1979-03-21	Referred to House Committee on the Judiciary.	House	Rep. Breaux, John B. [D-LA-7]	LA	D	B000780	Refers to the Chief Commissioner of the Court of Claims, a bill to direct the Secretary of the Treasury to pay two named individuals, chief of the Tribal Council of the Alabama Coushatta Tribes of Texas and chairman of the Coushatta Tribe of Louisiana, respectively, for the benefit of and distribution to themselves and all other enrolled members of such tribes, in full settlement of specified claims against the United States. Directs the Commissioner to report to the House of Representatives on such claim and the amount, if any, due such claimants from the United States.	2021-06-14T19:12:54Z
96-hres-170	96	hres	170	A resolution to refer the bill (H.R. 3137) for the relief of William H. Spratling to the Chief Commissioner of the Court of Claims.	Private Legislation	1979-03-20	1979-03-20	Referred to House Committee on the Judiciary.	House	Rep. Barnard, Doug, Jr. [D-GA-10]	GA	D	B000153	Refers to the Chief Commissioner of the Court of Claims, a bill for the relief of a named individual. Directs the Commissioner to report to the House of Representatives on the nature of the claim against the United States and the amount, if any, due such individual from the United States.	2021-06-14T19:12:52Z
96-hres-153	96	hres	153	A resolution to refer the bill (H.R. 2800) for the relief of Harold N. Holt to the Chief Commissioner of the Court of Claims.	Private Legislation	1979-03-12	1979-03-12	Referred to House Committee on the Judiciary.	House	Rep. Forsythe, Edwin B. [R-NJ-6]	NJ	R	F000286	Refers to the Chief Commissioner of the Court of Claims, a bill for the relief of a named individual.	2021-06-14T19:12:49Z
96-hres-147	96	hres	147	A resolution to refer the bill (H.R. 2616) for the relief of McNamara Construction of Manitoba, Limited, of Willowdale, Ontario, Canada, to the Chief Commissioner of the Court of Claims.	Private Legislation	1979-03-06	1979-03-06	Referred to House Committee on the Judiciary.	House	Rep. Mazzoli, Romano L. [D-KY-3]	KY	D	M000291	Refers to the Chief Commissioner of the Court of Claims, a bill for the relief of a specified corporation.	2021-06-14T19:12:48Z
96-hres-116	96	hres	116	A resolution to refer the bill (H.R. 2146) for the relief of Sidney G. Kanouse to the Chief Commissioner of the Court of Claims.	Private Legislation	1979-02-13	1979-02-13	Referred to House Committee on the Judiciary.	House	Rep. Pease, Donald J. [D-OH-13]	OH	D	P000170	Refers to the Chief Commissioner of the Court of Claims, a bill which directs the Secretary of the Treasury to pay an unspecified sum to a named individual in satisfaction of specified claims against the United States.	2021-06-14T19:12:40Z
96-hres-46	96	hres	46	A resolution relating to the payment of a gratuity to Mrs. Janet D. Steiger, wife of the late Hon. William A. Steiger.	Private Legislation	1979-01-18	1979-01-18	Measure passed House.	House	Rep. Thompson, Frank, Jr. [D-NJ-4]	NJ	D	T000200	Directs that a specified sum be paid from the contingent fund of the House of Representatives as a gratuity to the widow of a deceased Representative.	2021-06-14T19:12:17Z
96-hres-47	96	hres	47	A resolution relating to the payment of a gratuity to the children of the late Representative Leo J. Ryan.	Private Legislation	1979-01-18	1979-01-18	Measure passed House.	House	Rep. Thompson, Frank, Jr. [D-NJ-4]	NJ	D	T000200	Directs that a specified sum be paid from the contingent fund of the House of Representatives as a gratuity to the children of a deceased Representative.	2021-06-14T19:12:18Z
96-hres-44	96	hres	44	A resolution to refer the bill for the relief of P. S. Seymour-Heath to the Chief Commissioner of the Court of Claims.	Private Legislation	1979-01-15	1979-01-15	Referred to House Committee on the Judiciary.	House	Rep. Danielson, George E. [D-CA-30]	CA	D	D000043	Refers H.R. 897 to the Chief Commissioner of the United States Court of Claims for further proceedings.	2021-06-14T19:12:15Z
95-hres-1436	95	hres	1436	A resolution providing for a contingency fund payment to the widow of the Honorable Ralph Metcalfe.	Private Legislation	1978-10-14	1978-10-14	Measure passed House.	House	Rep. Thompson, Frank, Jr. [D-NJ-4]	NJ	D	T000200	Directs that a specified sum be paid from the contingent fund of the House of Representatives as a gratuity to the widow of a deceased Representative.	2024-08-01T19:56:48Z
95-hres-1437	95	hres	1437	A resolution providing for a contingency fund payment to the widow of the Honorable Goodloe Byron.	Private Legislation	1978-10-14	1978-10-14	Measure passed House.	House	Rep. Thompson, Frank, Jr. [D-NJ-4]	NJ	D	T000200	Directs that a specified sum be paid from the contingent fund of the House of Representatives as a gratuity to the widow of a deceased Representative.	2024-08-01T19:56:48Z
95-hres-1357	95	hres	1357	A resolution to refer H.R. 12856, a bill for the relief of Elena Schwarze-Chamier, to the Chief Commissioner of the Court of Claims.	Private Legislation	1978-09-19	1978-09-19	Referred to House Committee on the Judiciary.	House	Rep. Fisher, Joesph L. [D-VA-10]	VA	D	F000151	Refers H.R. 12856, a bill for the relief of a certain individual, to the Chief Commissioner of the United States Court of Claims.	2024-08-01T19:56:48Z
95-hres-1344	95	hres	1344	A resolution referring the bill for the relief of Amis Construction Company to the Court of Claims.	Private Legislation	1978-09-12	1978-09-12	Referred to House Committee on the Judiciary.	House	Rep. Edwards, Mickey [R-OK-5]	OK	R	E000077	Refers a bill for the relief of a specified corporation to the Chief Commissioner of the United States Court of Claims.	2024-08-01T19:56:48Z
95-hres-1077	95	hres	1077	A resolution to refer the bill for the relief of Sidney J. Kanouse to the Chief Commissioner of the Court of Claims.	Private Legislation	1978-03-14	1978-03-14	Referred to House Committee on the Judiciary.	House	Rep. Pease, Donald J. [D-OH-13]	OH	D	P000170	Refers H.R. 11555 to the Chief Commissioner of the U.S. Court of Claims.	2024-08-01T19:56:35Z
95-hres-1073	95	hres	1073	A bill to refer the bill (H.R. 11450) entitled "A bill for the relief of Stencel Aero Engineering Corporation", to the Chief Commissioner of the United States Court of Claims for a report thereon.	Private Legislation	1978-03-13	1978-03-13	Referred to House Committee on the Judiciary.	House	Rep. Gudger, V. Lamar [D-NC-11]	NC	D	G000515	Refers H.R. 11450 to the Chief Commissioner of the U.S. Court of Claims.	2024-08-01T19:56:35Z
95-hres-1055	95	hres	1055	A resolution to refer the bill, H.R. 11300 for the relief of Lance Industries, Incorporated, to the Chief Commissioner of the Court of Claims.	Private Legislation	1978-03-03	1978-03-03	Referred to House Committee on the Judiciary.	House	Rep. Allen, Clifford R. [D-TN-5]	TN	D	A000118	Refers H. R. 11300 to the Chief Commissioner of the U.S. Court of Claims.	2024-08-01T19:56:35Z
95-hres-962	95	hres	962	A resolution to refer the bill H.R. 10470 for the relief of Major John E. Doyle to the Chief Commissioner of the United States Court of Claims.	Private Legislation	1978-01-23	1978-01-23	Referred to House Committee on the Judiciary.	House	Rep. Brown, Clarence, Jr. [R-OH-7]	OH	R	B000910	Refers HR 10470 to the Chief Commissioner of the United States Court of Claims.	2024-08-01T19:56:35Z
95-hres-936	95	hres	936	A resolution relating to the payment of death gratuity to the widow of Laurence N. Woodworth.	Private Legislation	1977-12-15	1977-12-15	Measure passed House.	House	Rep. Ullman, Al [D-OR-2]	OR	D	U000004	Directs the payment of a death gratuity to the widow of a specified House employee.	2024-08-01T19:56:35Z
95-hres-946	95	hres	946	A resolution to refer H.R. 10404 to the Chief Commissioner of the United States Court of Claims.	Private Legislation	1977-12-15	1977-12-15	Referred to House Committee on the Judiciary.	House	Rep. Mattox, James A. [D-TX-5]	TX	D	M000260	Refers H.R. 10404 to the Chief Commissioner of the Court of Claims.	2024-08-01T19:56:35Z
95-hres-806	95	hres	806	A resolution refer the bill H.R. 9424 to the Chief Commissioner of the Court of Claims.	Private Legislation	1977-10-03	1977-10-03	Referred to House Committee on the Judiciary.	House	Rep. Breaux, John B. [D-LA-7]	LA	D	B000780	Refers H.R. 9424 to the Chief Commissioner of the Court of Claims.	2024-08-01T19:56:29Z
95-hres-795	95	hres	795	A resolution opposing the granting of permanent residence in the United States to certain aliens.	Private Legislation	1977-09-27	1977-10-25	Measure passed House.	House	Rep. Eilberg, Joshua [D-PA-4]	PA	D	E000096	Expresses the disapproval of the House of Representatives toward the granting of permanent residence in the United States to specified aliens.	2024-08-01T19:56:24Z
95-hres-796	95	hres	796	A resolution opposing the granting of permanent residence in the United States to Arif Raza Zaidi Syed.	Private Legislation	1977-09-27	1977-10-25	Measure passed House.	House	Rep. Eilberg, Joshua [D-PA-4]	PA	D	E000096	Expresses the disapproval of the House of Representatives toward the granting of permanent residence in the United States to a specified alien.	2024-08-01T19:56:29Z
95-hres-737	95	hres	737	A resolution to refer the bill (H.R. 8114) for the relief of William H. Spratling to the Chief Commissioner of the Court of Claims.	Private Legislation	1977-08-03	1977-08-03	Referred to House Committee on the Judiciary.	House	Rep. Barnard, Doug, Jr. [D-GA-10]	GA	D	B000153	Refers H.R. 8114 to the Chief Commissioner of the Court of Claims.	2024-08-01T19:56:24Z
95-hres-726	95	hres	726	A resolution to refer the bill (H.R. 8532) for the relief of McNamara Construction of Manitoba, Ltd., of Willowdade, Ontario, Canada, to the Chief Commissioner of the Court of Claims.	Private Legislation	1977-07-28	1977-07-28	Referred to House Committee on the Judiciary.	House	Rep. Mazzoli, Romano L. [D-KY-3]	KY	D	M000291	Refers H.R. 8532 to the Chief Commissioner of the United States Court of Claims.	2024-08-01T19:56:24Z
95-hres-717	95	hres	717	A resolution to pay tribute to Frances G. Knight on the occasion of her retirement from Federal service.	Private Legislation	1977-07-26	1977-07-26	Referred to House Committee on Post Office and Civil Service.	House	Rep. Archer, Bill [R-TX-7]	TX	R	A000215	Declares the sense of the House of Representatives that Frances G. Knight be commended for her outstanding service to the Nation upon the occasion of her retirement from Federal service.	2024-08-01T19:56:25Z
95-hres-614	95	hres	614	A resolution to refer the bill H.R. 7635 for the relief of Philip G. Kemp to the Court of Claims.	Private Legislation	1977-06-06	1977-06-06	Referred to House Committee on the Judiciary.	House	Rep. Steers, Newton I., Jr. [R-MD-8]	MD	R	S000844	Refers H.R. 7635 to the Chief Trial Judge of the Court of Claims.	2024-08-01T19:56:17Z

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);