legislation

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

17 rows where congress = 117 and policy_area = "Private Legislation" sorted by introduced_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: introduced_date, latest_action_date, latest_action_text, sponsor_name, sponsor_state, sponsor_party, sponsor_bioguide_id, introduced_date (date), latest_action_date (date), update_date (date)

policy_area 1

  • Private Legislation · 17 ✖

congress 1

  • 117 · 17 ✖

bill_type 1

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 url
117-hr-9694 117 hr 9694 For the relief of Jan van Hoek. Private Legislation 2022-12-23 2022-12-23 Referred to the House Committee on Energy and Commerce. House Rep. Franklin, C. Scott [R-FL-15] FL R F000472 0 Provides for the relief of Jan van Hoek. 2023-07-07T17:00:24Z  
117-hr-9447 117 hr 9447 For the relief of Terence George. Private Legislation 2022-12-06 2022-12-06 Referred to the House Committee on the Judiciary. House Rep. McGovern, James P. [D-MA-2] MA D M000312 0 Provides for the relief of Terence George. 2023-07-07T17:00:24Z  
117-hr-9276 117 hr 9276 For the relief of Jaime Avalos Rosales. Private Legislation 2022-11-03 2022-11-03 Referred to the House Committee on the Judiciary. House Rep. Green, Al [D-TX-9] TX D G000553 0 Provides for the relief of Jaime Avalos Rosales. 2023-07-07T17:00:24Z  
117-hr-8139 117 hr 8139 For the relief of Ivana Alexandra Sifuentes Arbirio and Luisa Mariana Sifuentes Arbirio. Private Legislation 2022-06-16 2022-11-01 Referred to the Subcommittee on Immigration and Citizenship. House Rep. Correa, J. Luis [D-CA-46] CA D C001110 0 Provides for the relief of Ivana Alexandra Sifuentes Arbirio and Luisa Mariana Sifuentes Arbirio. 2023-07-07T17:00:24Z  
117-hr-7531 117 hr 7531 For the relief of Michael Ragas Rey. Private Legislation 2022-04-14 2022-11-01 Referred to the Subcommittee on Immigration and Citizenship. House Rep. Correa, J. Luis [D-CA-46] CA D C001110 0 Provides for the relief of Michael Ragas Rey. 2023-07-07T17:00:24Z  
117-hr-6908 117 hr 6908 For the relief of Mykhaylo Gnatyuk and Melnik Gnatyuk. Private Legislation 2022-03-02 2022-11-01 Referred to the Subcommittee on Immigration and Citizenship. House Rep. Davis, Danny K. [D-IL-7] IL D D000096 0 Provides for the relief of Mykhaylo Gnatyuk and Melnik Gnatyuk. 2023-07-07T17:00:24Z  
117-hr-6909 117 hr 6909 For the relief of Tetyana Zvarychuk. Private Legislation 2022-03-02 2022-11-01 Referred to the Subcommittee on Immigration and Citizenship. House Rep. Davis, Danny K. [D-IL-7] IL D D000096 0 Provides for the relief of Tetyana Zvarychuk. 2023-07-07T17:00:24Z  
117-hr-6910 117 hr 6910 For the relief of Igor Klyuchenko. Private Legislation 2022-03-02 2022-11-01 Referred to the Subcommittee on Immigration and Citizenship. House Rep. Davis, Danny K. [D-IL-7] IL D D000096 0 Provides for the relief of Igor Klyuchenko. 2023-07-07T17:00:24Z  
117-hr-6822 117 hr 6822 For the relief of Vitaly Stepanov and Yuliya Stepanova. Private Legislation 2022-02-22 2022-11-01 Referred to the Subcommittee on Immigration and Citizenship. House Rep. Cohen, Steve [D-TN-9] TN D C001068 0 Provides for the relief of Vitaly Stepanov and Yuliya Stepanova. 2023-07-07T17:00:24Z  
117-hr-6804 117 hr 6804 For the relief of Oli Mohammed. Private Legislation 2022-02-18 2022-11-01 Referred to the Subcommittee on Immigration and Citizenship. House Rep. Garcia, Sylvia R. [D-TX-29] TX D G000587 0 Provides for the relief of Oli Mohammed. 2023-07-07T17:00:24Z  
117-hr-6652 117 hr 6652 For the relief of Reverend Olusegun Samson Olaoye. Private Legislation 2022-02-08 2022-11-01 Referred to the Subcommittee on Immigration and Citizenship. House Rep. Davis, Danny K. [D-IL-7] IL D D000096 0 Provides for the relief of Reverend Olusegun Samson Olaoye. 2023-07-07T17:00:24Z  
117-hr-6325 117 hr 6325 For the relief of Melecio Andazola-Morales. Private Legislation 2021-12-16 2022-11-01 Referred to the Subcommittee on Immigration and Citizenship. House Rep. Perlmutter, Ed [D-CO-7] CO D P000593 0 Provides for the relief of Melecio Andazola-Morales. 2023-07-07T17:00:24Z  
117-hr-5408 117 hr 5408 For the relief of Michael Janssen and Steven Passantino. Private Legislation 2021-09-28 2022-11-01 Referred to the Subcommittee on Immigration and Citizenship. House Rep. Ferguson, A. Drew, IV [R-GA-3] GA R F000465 0 Provides for the relief of Michael Janssen and Steven Passantino. 2023-07-07T17:00:24Z  
117-hr-4936 117 hr 4936 For the relief of Rosa Aurora Sabido-Valdivia. Private Legislation 2021-08-03 2022-11-01 Referred to the Subcommittee on Immigration and Citizenship. House Rep. Neguse, Joe [D-CO-2] CO D N000191 0 Provides for the relief of Rosa Aurora Sabido-Valdivia. 2023-07-07T17:00:24Z  
117-hr-2904 117 hr 2904 For the relief of Jose Garcia Alarcon. Private Legislation 2021-04-28 2021-10-19 Referred to the Subcommittee on Immigration and Citizenship. House Rep. Garcia, Jesus G. "Chuy" [D-IL-4] IL D G000586 0 Provides for the relief of Jose Garcia Alarcon. 2023-07-07T17:00:24Z  
117-hr-2905 117 hr 2905 For the relief of Francisca Burciaga-Amaro. Private Legislation 2021-04-28 2021-10-19 Referred to the Subcommittee on Immigration and Citizenship. House Rep. Garcia, Jesus G. "Chuy" [D-IL-4] IL D G000586 0 Provides for the relief of Francisca Burciaga-Amaro. 2023-07-07T17:00:24Z  
117-hr-445 117 hr 445 For the relief of Yazmin Fabiola Juarez Coyoy. Private Legislation 2021-01-21 2021-03-05 Referred to the Subcommittee on Immigration and Citizenship. House Rep. Watson Coleman, Bonnie [D-NJ-12] NJ D W000822 0 Provides for the relief of Yazmin Fabiola Juarez Coyoy. 2023-07-07T17:00:24Z  

Advanced export

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

CSV options: 

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