legislation_cosponsors
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
11 rows where bill_id = "112-hr-5892" sorted by sponsorship_date descending
This data as json, CSV (advanced)
Suggested facets: party, state, sponsorship_date, sponsorship_date (date)
| Link | bill_id | bioguide_id | full_name | party | state | sponsorship_date ▲ | is_original_cosponsor |
|---|---|---|---|---|---|---|---|
| 112-hr-5892,P000585 | Hydropower Regulatory Efficiency Act of 2012 112-hr-5892 | P000585 | Rep. Platts, Todd Russell [R-PA-19] | R | PA | 2012-06-26 | 0 |
| 112-hr-5892,L000570 | Hydropower Regulatory Efficiency Act of 2012 112-hr-5892 | L000570 | Rep. Lujan, Ben Ray [D-NM-3] | D | NM | 2012-06-26 | 0 |
| 112-hr-5892,W000791 | Hydropower Regulatory Efficiency Act of 2012 112-hr-5892 | W000791 | Rep. Walden, Greg [R-OR-2] | R | OR | 2012-06-08 | 0 |
| 112-hr-5892,G000562 | Hydropower Regulatory Efficiency Act of 2012 112-hr-5892 | G000562 | Rep. Gardner, Cory [R-CO-4] | R | CO | 2012-06-08 | 0 |
| 112-hr-5892,D000197 | Hydropower Regulatory Efficiency Act of 2012 112-hr-5892 | D000197 | Rep. DeGette, Diana [D-CO-1] | D | CO | 2012-06-05 | 1 |
| 112-hr-5892,S000583 | Hydropower Regulatory Efficiency Act of 2012 112-hr-5892 | S000583 | Rep. Smith, Lamar [R-TX-21] | R | TX | 2012-06-05 | 1 |
| 112-hr-5892,M001142 | Hydropower Regulatory Efficiency Act of 2012 112-hr-5892 | M001142 | Rep. Matheson, Jim [D-UT-2] | D | UT | 2012-06-05 | 1 |
| 112-hr-5892,D000355 | Hydropower Regulatory Efficiency Act of 2012 112-hr-5892 | D000355 | Rep. Dingell, John D. [D-MI-15] | D | MI | 2012-06-05 | 1 |
| 112-hr-5892,L000566 | Hydropower Regulatory Efficiency Act of 2012 112-hr-5892 | L000566 | Rep. Latta, Robert E. [R-OH-5] | R | OH | 2012-06-05 | 1 |
| 112-hr-5892,T000459 | Hydropower Regulatory Efficiency Act of 2012 112-hr-5892 | T000459 | Rep. Terry, Lee [R-NE-2] | R | NE | 2012-06-05 | 1 |
| 112-hr-5892,M000133 | Hydropower Regulatory Efficiency Act of 2012 112-hr-5892 | M000133 | Rep. Markey, Edward J. [D-MA-7] | D | MA | 2012-06-05 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE legislation_cosponsors (
bill_id TEXT NOT NULL REFERENCES legislation(bill_id),
bioguide_id TEXT NOT NULL,
full_name TEXT,
party TEXT,
state TEXT,
sponsorship_date TEXT,
is_original_cosponsor INTEGER,
PRIMARY KEY (bill_id, bioguide_id)
);
CREATE INDEX idx_lc_bioguide ON legislation_cosponsors(bioguide_id);
CREATE INDEX idx_lc_bill ON legislation_cosponsors(bill_id);
CREATE INDEX idx_lc_original ON legislation_cosponsors(is_original_cosponsor);