legislation_cosponsors
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
9 rows where bill_id = "115-hr-6768" sorted by sponsorship_date descending
This data as json, CSV (advanced)
Suggested facets: state, sponsorship_date, sponsorship_date (date)
| Link | bill_id | bioguide_id | full_name | party | state | sponsorship_date ▲ | is_original_cosponsor |
|---|---|---|---|---|---|---|---|
| 115-hr-6768,W000797 | Fracking Disclosure and Safety Act 115-hr-6768 | W000797 | Rep. Wasserman Schultz, Debbie [D-FL-23] | D | FL | 2018-09-25 | 0 |
| 115-hr-6768,G000551 | Fracking Disclosure and Safety Act 115-hr-6768 | G000551 | Rep. Grijalva, Raúl M. [D-AZ-3] | D | AZ | 2018-09-25 | 0 |
| 115-hr-6768,G000574 | Fracking Disclosure and Safety Act 115-hr-6768 | G000574 | Rep. Gallego, Ruben [D-AZ-7] | D | AZ | 2018-09-10 | 1 |
| 115-hr-6768,Q000023 | Fracking Disclosure and Safety Act 115-hr-6768 | Q000023 | Rep. Quigley, Mike [D-IL-5] | D | IL | 2018-09-10 | 1 |
| 115-hr-6768,P000604 | Fracking Disclosure and Safety Act 115-hr-6768 | P000604 | Rep. Payne, Donald M., Jr. [D-NJ-10] | D | NJ | 2018-09-10 | 1 |
| 115-hr-6768,N000147 | Fracking Disclosure and Safety Act 115-hr-6768 | N000147 | Del. Norton, Eleanor Holmes [D-DC-At Large] | D | DC | 2018-09-10 | 1 |
| 115-hr-6768,B001300 | Fracking Disclosure and Safety Act 115-hr-6768 | B001300 | Rep. Barragan, Nanette Diaz [D-CA-44] | D | CA | 2018-09-10 | 1 |
| 115-hr-6768,C001090 | Fracking Disclosure and Safety Act 115-hr-6768 | C001090 | Rep. Cartwright, Matt [D-PA-17] | D | PA | 2018-09-10 | 1 |
| 115-hr-6768,M001160 | Fracking Disclosure and Safety Act 115-hr-6768 | M001160 | Rep. Moore, Gwen [D-WI-4] | D | WI | 2018-09-10 | 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);