legislation_cosponsors
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
19 rows where bill_id = "109-s-22" 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 |
|---|---|---|---|---|---|---|---|
| 109-s-22,S001141 | Medical Care Access Protection Act of 2006 109-s-22 | S001141 | Sen. Sessions, Jeff [R-AL] | R | AL | 2006-05-08 | 0 |
| 109-s-22,L000447 | Medical Care Access Protection Act of 2006 109-s-22 | L000447 | Sen. Lott, Trent [R-MS] | R | MS | 2006-05-08 | 0 |
| 109-s-22,T000250 | Medical Care Access Protection Act of 2006 109-s-22 | T000250 | Sen. Thune, John [R-SD] | R | SD | 2006-05-05 | 0 |
| 109-s-22,A000360 | Medical Care Access Protection Act of 2006 109-s-22 | A000360 | Sen. Alexander, Lamar [R-TN] | R | TN | 2006-05-04 | 0 |
| 109-s-22,F000439 | Medical Care Access Protection Act of 2006 109-s-22 | F000439 | Sen. Frist, William H. [R-TN] | R | TN | 2006-05-03 | 1 |
| 109-s-22,G000445 | Medical Care Access Protection Act of 2006 109-s-22 | G000445 | Sen. Gregg, Judd [R-NH] | R | NH | 2006-05-03 | 1 |
| 109-s-22,M000355 | Medical Care Access Protection Act of 2006 109-s-22 | M000355 | Sen. McConnell, Mitch [R-KY] | R | KY | 2006-05-03 | 1 |
| 109-s-22,H000338 | Medical Care Access Protection Act of 2006 109-s-22 | H000338 | Sen. Hatch, Orrin G. [R-UT] | R | UT | 2006-05-03 | 1 |
| 109-s-22,S000059 | Medical Care Access Protection Act of 2006 109-s-22 | S000059 | Sen. Santorum, Rick [R-PA] | R | PA | 2006-05-03 | 1 |
| 109-s-22,D000595 | Medical Care Access Protection Act of 2006 109-s-22 | D000595 | Sen. DeMint, Jim [R-SC] | R | SC | 2006-05-03 | 1 |
| 109-s-22,I000024 | Medical Care Access Protection Act of 2006 109-s-22 | I000024 | Sen. Inhofe, James M. [R-OK] | R | OK | 2006-05-03 | 1 |
| 109-s-22,B001126 | Medical Care Access Protection Act of 2006 109-s-22 | B001126 | Sen. Burns, Conrad R. [R-MT] | R | MT | 2006-05-03 | 1 |
| 109-s-22,D000601 | Medical Care Access Protection Act of 2006 109-s-22 | D000601 | Sen. Dole, Elizabeth [R-NC] | R | NC | 2006-05-03 | 1 |
| 109-s-22,C001056 | Medical Care Access Protection Act of 2006 109-s-22 | C001056 | Sen. Cornyn, John [R-TX] | R | TX | 2006-05-03 | 1 |
| 109-s-22,V000126 | Medical Care Access Protection Act of 2006 109-s-22 | V000126 | Sen. Voinovich, George V. [R-OH] | R | OH | 2006-05-03 | 1 |
| 109-s-22,B001135 | Medical Care Access Protection Act of 2006 109-s-22 | B001135 | Sen. Burr, Richard [R-NC] | R | NC | 2006-05-03 | 1 |
| 109-s-22,A000109 | Medical Care Access Protection Act of 2006 109-s-22 | A000109 | Sen. Allard, Wayne [R-CO] | R | CO | 2006-05-03 | 1 |
| 109-s-22,C000560 | Medical Care Access Protection Act of 2006 109-s-22 | C000560 | Sen. Coburn, Tom [R-OK] | R | OK | 2006-05-03 | 1 |
| 109-s-22,V000127 | Medical Care Access Protection Act of 2006 109-s-22 | V000127 | Sen. Vitter, David [R-LA] | R | LA | 2006-05-03 | 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);