openregs: legislation: 61 rows where congress = 113 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

61 rows where congress = 113 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	cosponsor_count	summary_text	update_date
113-hr-5302	113	hr	5302	To authorize the President to award the Medal of Honor to Special Forces Command Sergeant Major Ramon Rodriguez of the United States Army for acts of valor during the Vietnam War.	Private Legislation	2014-07-30	2014-07-30	Referred to the House Committee on Armed Services.	House	Rep. Sanchez, Loretta [D-CA-46]	CA	D	S000030	0	Authorizes the President to award the Medal of Honor to Command Sergeant Major Ramon Rodriguez of the U.S. Army for acts of valor, sacrifice, and courage at the risk of his own life beyond the call of duty during the Vietnam War.	2023-01-11T13:25:54Z
113-hr-4884	113	hr	4884	For the relief of Zenon Kolenda and Orysya Bilyanska Kolenda.	Private Legislation	2014-06-17	2014-06-17	Referred to the House Committee on the Judiciary.	House	Rep. Maffei, Daniel B. [D-NY-24]	NY	D	M001171	0	Provides for the relief of Zenon Kolenda and Orysya Bilyanska Kolenda.	2023-01-11T13:26:15Z
113-s-2474	113	s	2474	A bill for the relief of Meriam Yahya Ibrahim, Martin Wani, and Maya Wani.	Private Legislation	2014-06-12	2014-06-12	Read twice and referred to the Committee on the Judiciary.	Senate	Sen. Shaheen, Jeanne [D-NH]	NH	D	S001181	4	Provides for the relief of Meriam Yahya Ibrahim, Martin Wani, and Maya Wani.	2023-01-11T13:26:07Z
113-hr-4821	113	hr	4821	For the relief of Meriam Yahya Ibrahim, Martin Wani, and Maya Wani.	Private Legislation	2014-06-09	2014-06-09	Referred to the House Committee on the Judiciary.	House	Rep. Cotton, Tom [R-AR-4]	AR	R	C001095	0	Provides for the relief of Meriam Yahya Ibrahim, Martin Wani, and Maya Wani.	2023-01-11T13:26:17Z
113-hr-4585	113	hr	4585	For the relief of Antonia Esmeralda Aguilar Belmontes.	Private Legislation	2014-05-06	2014-05-06	Referred to the House Committee on the Judiciary.	House	Rep. Miller, George [D-CA-11]	CA	D	M000725	0	Provides for the relief of Antonia Esmeralda Aguilar Belmontes.	2023-01-11T13:26:30Z
113-hr-4506	113	hr	4506	For the relief of Antonia Esmeralda Aguilar Belmontes.	Private Legislation	2014-04-28	2014-04-28	Referred to the House Committee on the Judiciary.	House	Rep. Lofgren, Zoe [D-CA-19]	CA	D	L000397	0	Provides for the relief of Antonia Esmeralda Aguilar Belmontes.	2023-01-11T13:26:38Z
113-hr-4224	113	hr	4224	For the relief of Victor Hugo Santos.	Private Legislation	2014-03-12	2014-03-25	Referred to the Subcommittee on Immigration and Border Security.	House	Rep. Brady, Robert A. [D-PA-1]	PA	D	B001227	0	Provides for the relief of Victor Hugo Santos.	2023-01-11T13:26:50Z
113-hr-3823	113	hr	3823	For the relief of John Cheruiyot Kemboi and Winnie Njeri Kemboi.	Private Legislation	2014-01-08	2014-01-08	Referred to the House Committee on the Judiciary.	House	Rep. Tiberi, Patrick J. [R-OH-12]	OH	R	T000462	0	Provides for the relief of John Cheruiyot Kemboi and Winnie Njeri Kemboi.	2023-01-11T13:23:30Z
113-hr-3817	113	hr	3817	For the relief of Jeanette Vizguerra-Ramirez.	Private Legislation	2014-01-07	2014-01-10	Sponsor introductory remarks on measure. (CR E41-42)	House	Rep. Polis, Jared [D-CO-2]	CO	D	P000598	0	Provides for the relief of Jeanette Vizguerra-Ramirez.	2023-01-11T13:23:30Z
113-s-1832	113	s	1832	A bill for the relief of Esther Karinge.	Private Legislation	2013-12-16	2013-12-16	Read twice and referred to the Committee on the Judiciary.	Senate	Sen. Markey, Edward J. [D-MA]	MA	D	M000133	0	Provides for the relief of Esther Karinge.	2023-01-11T13:23:33Z
113-hr-3618	113	hr	3618	For the relief of Kadiatou Diallo, Sankerala Diallo, Ibrahima Diallo, Abdoul Diallo, Mamadou Pathe Diallo, and Fatoumata Traore Diallo.	Private Legislation	2013-11-21	2013-11-21	Referred to the Subcommittee on Immigration and Border Security.	House	Rep. Rangel, Charles B. [D-NY-13]	NY	D	R000053	0	Provides for the relief of Kadiatou Diallo, Sankerala Diallo, Ibrahima Diallo, Abdoul Diallo, and Mamadou Pathe Diallo and Fatoumata Traore Diallo.	2023-01-11T13:23:46Z
113-hr-3503	113	hr	3503	To authorize the award of the Distinguished Service Cross to Robert L. Towles for acts of valor during the Vietnam War.	Private Legislation	2013-11-14	2014-01-24	Referred to the Subcommittee on Military Personnel.	House	Rep. Ryan, Tim [D-OH-13]	OH	D	R000577	0	Authorizes the Secretary of the Army to award the Distinguished Service Cross to Robert L. Towles for acts of valor during the Vietnam War, notwithstanding otherwise applicable time limitations.	2023-01-11T13:23:50Z
113-s-1605	113	s	1605	A bill for the relief of Michael G. Faber.	Private Legislation	2013-10-29	2014-07-30	Committee on Energy and Natural Resources Senate Subcommittee on Public Lands, Forests, and Mining. Hearings held. With printed Hearing: S.Hrg. 113-433.	Senate	Sen. Murkowski, Lisa [R-AK]	AK	R	M001153	0	Provides for the relief of Michael G. Faber.	2023-01-11T13:23:52Z
113-hr-3238	113	hr	3238	For the relief of Simeon Simeonov, Stela Simeonova, Stoyan Simeonov, and Vania Simeonova.	Private Legislation	2013-10-02	2013-10-15	Referred to the Subcommittee on Immigration and Border Security.	House	Rep. Gutierrez, Luis V. [D-IL-4]	IL	D	G000535	0	Provides for the relief of Simeon Simeonov, Stela Simeonova, Stoyan Simeonov, and Vania Simeonova.	2023-01-11T13:24:00Z
113-hr-3079	113	hr	3079	For the relief of Jesus Garcia Flores.	Private Legislation	2013-09-10	2013-09-26	Referred to the Subcommittee on Immigration and Border Security.	House	Rep. Pastor, Ed [D-AZ-7]	AZ	D	P000099	0	Provides for the relief of Jesus Garcia Flores.	2023-01-11T13:24:12Z
113-s-1492	113	s	1492	A bill for the relief of Vichai Sae Tung (also known as Chai Chaowasaree).	Private Legislation	2013-09-10	2013-09-10	Read twice and referred to the Committee on the Judiciary.	Senate	Sen. Hirono, Mazie K. [D-HI]	HI	D	H001042	1	Provides for the relief of Vichai Sae Tung (also known as Chai Chaowasaree).	2023-01-11T13:24:06Z
113-hr-2608	113	hr	2608	For the relief of Flavia Maboloc Cahoon.	Private Legislation	2013-06-28	2013-07-10	Referred to the Subcommittee on Immigration and Border Security.	House	Rep. Davis, Susan A. [D-CA-53]	CA	D	D000598	0	Provides for the relief of Flavia Maboloc Cahoon.	2023-01-11T13:24:43Z
113-hr-2570	113	hr	2570	Valley View Ferry Preservation Act of 2013	Private Legislation	2013-06-27	2013-06-28	Referred to the Subcommittee on Coast Guard and Maritime Transportation.	House	Rep. Barr, Andy [R-KY-6]	KY	R	B001282	0	Exempts the vessel John Craig from certain requirements when operating on a portion of the Kentucky River.	2023-01-11T13:24:44Z
113-hr-2427	113	hr	2427	To provide for the relief of Lori L. Rogers.	Private Legislation	2013-06-18	2013-07-15	Referred to the Subcommittee on Immigration and Border Security.	House	Rep. Stewart, Chris [R-UT-2]	UT	R	S001192	0	Provides for the relief of Lori L. Rogers.	2023-01-11T13:24:49Z
113-hr-2406	113	hr	2406	For the relief of Daniel Wachira.	Private Legislation	2013-06-17	2013-06-17	Referred to the House Committee on the Judiciary.	House	Rep. Rangel, Charles B. [D-NY-13]	NY	D	R000053	0	Provides for the relief of Daniel Wachira.	2023-01-11T13:24:49Z
113-hr-2392	113	hr	2392	For the relief of certain aliens who were aboard the Golden Venture.	Private Legislation	2013-06-14	2013-06-14	Referred to the House Committee on the Judiciary.	House	Rep. Smith, Christopher H. [R-NJ-4]	NJ	R	S000522	0	Provides for the relief of certain aliens who were aboard the Golden Venture.	2023-01-11T13:24:50Z
113-hr-2304	113	hr	2304	For the relief of Amer Numan Adi.	Private Legislation	2013-06-06	2013-06-06	Referred to the House Committee on the Judiciary.	House	Rep. Ryan, Tim [D-OH-13]	OH	D	R000577	0	Provides for the relief of Amer Numan Adi.	2023-01-11T13:24:52Z
113-hr-1935	113	hr	1935	For the relief of John Castellano.	Private Legislation	2013-05-09	2013-05-09	Referred to the Subcommittee on Immigration and Border Security.	House	Rep. Hahn, Janice [D-CA-44]	CA	D	H001063	0	Provides for the relief of John Castellano.	2022-11-15T16:32:34Z
113-hr-1519	113	hr	1519	For the relief of Alemseghed Mussie Tesfamical.	Private Legislation	2013-04-11	2013-04-11	Referred to the Subcommittee on Immigration and Border Security.	House	Rep. King, Peter T. [R-NY-2]	NY	R	K000210	0	Provides for the relief of Alemseghed Mussie Tesfamical.	2022-11-15T16:33:52Z
113-s-671	113	s	671	A bill for the relief of Deniss Nikanorov.	Private Legislation	2013-04-09	2013-04-09	Read twice and referred to the Committee on the Judiciary.	Senate	Sen. Tester, Jon [D-MT]	MT	D	T000464	0	Provides for the relief of Deniss Nikanorov.	2022-03-03T21:28:01Z
113-hr-1401	113	hr	1401	For the relief of Jose Luis Alvarado Cardenas.	Private Legislation	2013-03-21	2013-03-21	Referred to the Subcommittee on Immigration and Border Security.	House	Rep. Pastor, Ed [D-AZ-7]	AZ	D	P000099	0	Provides for the relief of Jose Luis Alvarado Cardenas.	2022-11-15T16:35:10Z
113-s-584	113	s	584	A bill for the relief of Jorge Rojas Gutierrez, Olivia Gonzalez Gonzalez, and Jorge Rojas Gonzalez.	Private Legislation	2013-03-18	2013-03-18	Read twice and referred to the Committee on the Judiciary. (text of measure as introduced: CR S1894-1895)	Senate	Sen. Feinstein, Dianne [D-CA]	CA	D	F000062	0	Provides for the relief of Jorge Rojas Gutierrez, Olivia Gonzalez Gonzalez, and Jorge Rojas Gonzalez.	2022-11-15T16:32:58Z
113-s-585	113	s	585	A bill for the relief of Jose Alberto Martinez Moreno, Micaela Lopez Martinez, and Adilene Martinez.	Private Legislation	2013-03-18	2013-03-18	Read twice and referred to the Committee on the Judiciary. (text of measure as introduced: CR S1895)	Senate	Sen. Feinstein, Dianne [D-CA]	CA	D	F000062	0	Provides for the relief of Jose Alberto Martinez Moreno, Micaela Lopez Martinez, and Adilene Martinez.	2022-11-15T16:32:24Z
113-s-586	113	s	586	A bill for the relief of Alfredo Plascencia Lopez and Maria Del Refugio Plascencia.	Private Legislation	2013-03-18	2013-03-18	Read twice and referred to the Committee on the Judiciary. (text of measure as introduced: CR S1896)	Senate	Sen. Feinstein, Dianne [D-CA]	CA	D	F000062	0	Provides for the relief of Alfredo Plascencia Lopez and Maria Del Refugio Plascencia.	2022-11-15T16:33:27Z
113-s-587	113	s	587	A bill for the relief of Ruben Mkoian, Asmik Karapetian, and Arthur Mkoyan.	Private Legislation	2013-03-18	2013-03-18	Read twice and referred to the Committee on the Judiciary. (text of measure as introduced: CR S1897)	Senate	Sen. Feinstein, Dianne [D-CA]	CA	D	F000062	0	Provides for the relief of Ruben Mkoian, Asmik Karapetian, and Arthur Mkoyan.	2022-11-15T16:32:37Z
113-s-588	113	s	588	A bill for the relief of Robert Liang and Alice Liang.	Private Legislation	2013-03-18	2013-03-18	Read twice and referred to the Committee on the Judiciary. (text of measure as introduced: CR S1898)	Senate	Sen. Feinstein, Dianne [D-CA]	CA	D	F000062	0	Provides for the relief of Robert Liang and Alice Liang.	2022-11-15T16:33:31Z
113-s-589	113	s	589	A bill for the relief of Joseph Gabra and Sharon Kamel.	Private Legislation	2013-03-18	2013-03-18	Read twice and referred to the Committee on the Judiciary. (text of measure as introduced: CR S1898-1899)	Senate	Sen. Feinstein, Dianne [D-CA]	CA	D	F000062	0	Provides for the relief of Joseph Gabra and Sharon Kamel.	2022-11-15T16:33:02Z
113-s-590	113	s	590	A bill for the relief of Claudia Marquez Rico.	Private Legislation	2013-03-18	2013-03-18	Read twice and referred to the Committee on the Judiciary. (text of measure as introduced: CR S1899)	Senate	Sen. Feinstein, Dianne [D-CA]	CA	D	F000062	0	Provides for the relief of Claudia Marquez Rico.	2022-03-03T21:28:09Z
113-s-591	113	s	591	A bill for the relief of Esidronio Arreola-Saucedo, Maria Elna Cobian Arreola, Nayely Arreola Carlos, and Cindy Jael Arreola.	Private Legislation	2013-03-18	2013-03-18	Read twice and referred to the Committee on the Judiciary. (text of measure as introduced: CR S1900)	Senate	Sen. Feinstein, Dianne [D-CA]	CA	D	F000062	0	Provides for the relief of Esidronio Arreola-Saucedo, Maria Elna Cobian Arreola, Nayely Arreola Carlos, and Cindy Jael Arreola.	2019-11-15T21:55:45Z
113-s-592	113	s	592	A bill for the relief of Alicia Aranda De Buendia and Ana Laura Buendia Aranda.	Private Legislation	2013-03-18	2013-03-18	Read twice and referred to the Committee on the Judiciary. (text of measure as introduced: CR S1901)	Senate	Sen. Feinstein, Dianne [D-CA]	CA	D	F000062	0	Provides for the relief of Alicia Aranda De Buendia and Ana Laura Buendia Aranda.	2022-11-15T16:33:42Z
113-s-593	113	s	593	A bill for the relief of Guy Privat Tape and Lou Nazie Raymonde Toto.	Private Legislation	2013-03-18	2013-03-18	Read twice and referred to the Committee on the Judiciary. (text of measure as introduced: CR S1901-1902)	Senate	Sen. Feinstein, Dianne [D-CA]	CA	D	F000062	0	Provides for the relief of Guy Privat Tape and Lou Nazie Raymonde Toto.	2019-11-15T21:55:45Z
113-s-594	113	s	594	A bill for the relief of Javier Lopez-Urenda and Maria Leticia Arenas.	Private Legislation	2013-03-18	2013-03-18	Read twice and referred to the Committee on the Judiciary. (text of measure as introduced: CR S1902-1903)	Senate	Sen. Feinstein, Dianne [D-CA]	CA	D	F000062	0	Provides for the relief of Javier Lopez-Urenda and Maria Leticia Arenas.	2019-11-15T21:55:45Z
113-s-595	113	s	595	A bill for the relief of Shirley Constantino Tan.	Private Legislation	2013-03-18	2013-03-18	Read twice and referred to the Committee on the Judiciary. (text of measure as introduced: CR S1903)	Senate	Sen. Feinstein, Dianne [D-CA]	CA	D	F000062	0	Provides for the relief of Shirley Constantino Tan.	2019-11-15T21:55:45Z
113-hr-1207	113	hr	1207	For the relief of Allan Bolor Kelley.	Private Legislation	2013-03-14	2013-03-14	Referred to the Subcommittee on Immigration and Border Security.	House	Rep. Waxman, Henry A. [D-CA-33]	CA	D	W000215	0	Provides for the relief of Allan Bolor Kelley.	2022-03-03T21:32:01Z
113-s-580	113	s	580	A bill for the relief of Maha Dakar.	Private Legislation	2013-03-14	2013-03-14	Read twice and referred to the Committee on the Judiciary.	Senate	Sen. Brown, Sherrod [D-OH]	OH	D	B000944	0	Provides for the relief of Maha Dakar.	2019-11-15T21:55:46Z
113-hr-1023	113	hr	1023	For the relief of Maria Carmen Castro Ramirez and J. Refugio Carreno Rojas.	Private Legislation	2013-03-06	2013-03-06	Referred to the Subcommittee on Immigration and Border Security.	House	Rep. Pelosi, Nancy [D-CA-12]	CA	D	P000197	0	Provides for the relief of Maria Carmen Castro Ramirez and J. Refugio Carreno Rojas.	2022-11-15T16:35:02Z
113-hr-977	113	hr	977	For the relief of Esther Karinge.	Private Legislation	2013-03-05	2013-03-05	Referred to the Subcommittee on Immigration and Border Security.	House	Rep. Markey, Edward J. [D-MA-5]	MA	D	M000133	0	Provides for the relief of Esther Karinge.	2022-11-15T16:33:19Z
113-s-449	113	s	449	A bill for the relief of Anton Dodaj, Gjyljana Dodaj, Franc Dodaj, and Kristjan Dodaj.	Private Legislation	2013-03-05	2013-03-05	Read twice and referred to the Committee on the Judiciary.	Senate	Sen. Levin, Carl [D-MI]	MI	D	L000261	0	Provides for the relief of Anton Dodaj, Gjyljana Dodaj, Franc Dodaj, and Kristjan Dodaj.	2022-11-15T16:35:19Z
113-hr-802	113	hr	802	For the relief of Roberto Luis Dunoyer Mejia, Consuelo Cardona Molina, Camilo Dunoyer Cardona, and Pablo Dunoyer Cardona.	Private Legislation	2013-02-15	2013-04-08	Referred to the Subcommittee on Immigration And Border Security.	House	Rep. Hunter, Duncan D. [R-CA-50]	CA	R	H001048	0	Provides for the relief of Roberto Luis Dunoyer Mejia, Consuelo Cardona Molina, Camilo Dunoyer Cardona, and Pablo Dunoyer Cardona.	2019-11-15T21:34:34Z
113-hr-682	113	hr	682	For the relief of Ibrahim Parlak.	Private Legislation	2013-02-13	2013-02-13	Referred to the Subcommittee on Immigration and Border Security.	House	Rep. Upton, Fred [R-MI-6]	MI	R	U000031	0	Provides for the relief of Ibrahim Parlak.	2022-03-03T21:32:07Z
113-hr-590	113	hr	590	For the relief of Nery Antonio Velasquez-Roblero.	Private Legislation	2013-02-06	2013-02-06	Referred to the Subcommittee on Immigration and Border Security.	House	Rep. Pastor, Ed [D-AZ-7]	AZ	D	P000099	0	Provides for the relief of Nery Antonio Velasquez-Roblero.	2022-11-15T16:33:11Z
113-s-158	113	s	158	A bill for the relief of Dr. Shakil Afridi.	Private Legislation	2013-01-28	2013-01-28	Read twice and referred to the Committee on the Judiciary.	Senate	Sen. Paul, Rand [R-KY]	KY	R	P000603	0	Provides for the relief of Dr. Shakil Afridi.	2022-11-15T16:34:41Z
113-s-69	113	s	69	A bill for the relief of Anton Dodaj, Gjyljana Dodaj, Franc Dodaj, Kristjan Dodaj, and Kanto Macotaj.	Private Legislation	2013-01-23	2013-01-23	Read twice and referred to the Committee on the Judiciary.	Senate	Sen. Levin, Carl [D-MI]	MI	D	L000261	0	Provides for the relief of Anton Dodaj, Gjyljana Dodaj, Franc Dodaj, Kristjan Dodaj, and Kanto Macotaj.	2023-01-11T13:23:13Z
113-s-70	113	s	70	A bill for the relief of Marcos Antonio Sanchez-Diaz.	Private Legislation	2013-01-23	2013-01-23	Read twice and referred to the Committee on the Judiciary.	Senate	Sen. Levin, Carl [D-MI]	MI	D	L000261	0	Provides for the relief of Marcos Antonio Sanchez-Diaz.	2023-01-11T13:23:13Z
113-s-71	113	s	71	A bill for the relief of Josephina Valera Lopez.	Private Legislation	2013-01-23	2013-01-23	Read twice and referred to the Committee on the Judiciary.	Senate	Sen. Levin, Carl [D-MI]	MI	D	L000261	0	Provides for the relief of Josephina Valera Lopez.	2023-01-11T13:23:13Z
113-s-72	113	s	72	A bill for the relief of Luay Hadad.	Private Legislation	2013-01-23	2013-01-23	Read twice and referred to the Committee on the Judiciary.	Senate	Sen. Levin, Carl [D-MI]	MI	D	L000261	0	Provides for the relief of Luay Hadad.	2023-01-11T13:23:13Z
113-s-73	113	s	73	A bill for the relief of Miguel Santillan.	Private Legislation	2013-01-23	2013-01-23	Read twice and referred to the Committee on the Judiciary.	Senate	Sen. Levin, Carl [D-MI]	MI	D	L000261	0	Provides for the relief of Miguel Santillan.	2023-01-11T13:23:13Z
113-s-74	113	s	74	A bill for the relief of Momo Krcic.	Private Legislation	2013-01-23	2013-01-23	Read twice and referred to the Committee on the Judiciary.	Senate	Sen. Levin, Carl [D-MI]	MI	D	L000261	0	Provides for the relief of Momo Krcic.	2023-01-11T13:23:13Z
113-s-75	113	s	75	A bill for the relief of Ibrahim Parlak.	Private Legislation	2013-01-23	2013-01-23	Read twice and referred to the Committee on the Judiciary.	Senate	Sen. Levin, Carl [D-MI]	MI	D	L000261	0	Provides for the relief of Ibrahim Parlak.	2023-01-11T13:23:13Z
113-s-76	113	s	76	A bill for the relief of Guy Vang, Genevieve Chong Foung, Caroline Vang, and Melanie Vang.	Private Legislation	2013-01-23	2013-01-23	Read twice and referred to the Committee on the Judiciary.	Senate	Sen. Levin, Carl [D-MI]	MI	D	L000261	0	Provides for the relief of Guy Vang, Genevieve Chong Foung, Caroline Vang, and Melanie Vang.	2023-01-11T13:23:13Z
113-s-78	113	s	78	A bill for the relief of Hussein Bazzi.	Private Legislation	2013-01-23	2013-01-23	Read twice and referred to the Committee on the Judiciary.	Senate	Sen. Levin, Carl [D-MI]	MI	D	L000261	0	Provides for the relief of Hussein Bazzi.	2023-01-11T13:23:12Z
113-s-79	113	s	79	A bill for the relief of Al-Housseynou Ba.	Private Legislation	2013-01-23	2013-01-23	Read twice and referred to the Committee on the Judiciary.	Senate	Sen. Levin, Carl [D-MI]	MI	D	L000261	0	Provides for the relief of Al-Housseynou Ba.	2023-01-11T13:23:12Z
113-s-36	113	s	36	A bill for the relief of Alemseghed Mussie Tesfamical.	Private Legislation	2013-01-22	2013-01-22	Read twice and referred to the Committee on the Judiciary.	Senate	Sen. Schumer, Charles E. [D-NY]	NY	D	S000148	0	Provides for the relief of Alemseghed Mussie Tesfamical.	2022-11-15T16:33:11Z
113-s-48	113	s	48	A bill for the relief of Genesio Januario Oliveira.	Private Legislation	2013-01-22	2013-01-22	Read twice and referred to the Committee on the Judiciary.	Senate	Sen. Kerry, John F. [D-MA]	MA	D	K000148	0	Provides for the relief of Genesio Januario Oliveira.	2023-01-11T13:23:13Z
113-hr-306	113	hr	306	For the relief of Corina de Chalup Turcinovic.	Private Legislation	2013-01-15	2014-07-16	Received in the Senate and Read twice and referred to the Committee on the Judiciary.	House	Rep. Lipinski, Daniel [D-IL-3]	IL	D	L000563	0	Provides for the relief of Corina de Chalup Turcinovic.	2023-01-11T13:26:03Z
113-hr-218	113	hr	218	For the relief of Enrique Soriano and Areli Soriano.	Private Legislation	2013-01-04	2013-01-04	Referred to the Subcommittee on Immigration and Border Security.	House	Rep. Green, Gene [D-TX-29]	TX	D	G000410	0	Provides for the relief of Enrique Soriano and Areli Soriano.	2019-11-15T21:34: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);