legislation_cosponsors

Cosponsors for tracked legislation. Distinguishes original cosponsors (signed on at introduction) from later additions. Linked to congress_members via bioguide_id.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

25 rows where bill_id = "111-hconres-161" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: state, sponsorship_date, sponsorship_date (date)

is_original_cosponsor 2

  • 0 24
  • 1 1
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
111-hconres-161,B001256 Recognizing and congratulating the City of Colorado Springs, Colorado, as the new official site of the National Emergency Medical Services Memorial Service and the National EMS Memorial honoring emergency medical services personnel who have died in the line of duty. 111-hconres-161 B001256 Rep. Bachmann, Michele [R-MN-6] R MN 2009-10-20 0
111-hconres-161,C001077 Recognizing and congratulating the City of Colorado Springs, Colorado, as the new official site of the National Emergency Medical Services Memorial Service and the National EMS Memorial honoring emergency medical services personnel who have died in the line of duty. 111-hconres-161 C001077 Rep. Coffman, Mike [R-CO-6] R CO 2009-10-20 0
111-hconres-161,F000453 Recognizing and congratulating the City of Colorado Springs, Colorado, as the new official site of the National Emergency Medical Services Memorial Service and the National EMS Memorial honoring emergency medical services personnel who have died in the line of duty. 111-hconres-161 F000453 Rep. Fallin, Mary [R-OK-5] R OK 2009-10-20 0
111-hconres-161,B000208 Recognizing and congratulating the City of Colorado Springs, Colorado, as the new official site of the National Emergency Medical Services Memorial Service and the National EMS Memorial honoring emergency medical services personnel who have died in the line of duty. 111-hconres-161 B000208 Rep. Bartlett, Roscoe G. [R-MD-6] R MD 2009-10-20 0
111-hconres-161,G000550 Recognizing and congratulating the City of Colorado Springs, Colorado, as the new official site of the National Emergency Medical Services Memorial Service and the National EMS Memorial honoring emergency medical services personnel who have died in the line of duty. 111-hconres-161 G000550 Rep. Gingrey, Phil [R-GA-11] R GA 2009-10-20 0
111-hconres-161,B001243 Recognizing and congratulating the City of Colorado Springs, Colorado, as the new official site of the National Emergency Medical Services Memorial Service and the National EMS Memorial honoring emergency medical services personnel who have died in the line of duty. 111-hconres-161 B001243 Rep. Blackburn, Marsha [R-TN-7] R TN 2009-10-20 0
111-hconres-161,H001045 Recognizing and congratulating the City of Colorado Springs, Colorado, as the new official site of the National Emergency Medical Services Memorial Service and the National EMS Memorial honoring emergency medical services personnel who have died in the line of duty. 111-hconres-161 H001045 Rep. Harper, Gregg [R-MS-3] R MS 2009-10-20 0
111-hconres-161,K000363 Recognizing and congratulating the City of Colorado Springs, Colorado, as the new official site of the National Emergency Medical Services Memorial Service and the National EMS Memorial honoring emergency medical services personnel who have died in the line of duty. 111-hconres-161 K000363 Rep. Kline, John [R-MN-2] R MN 2009-10-20 0
111-hconres-161,C001053 Recognizing and congratulating the City of Colorado Springs, Colorado, as the new official site of the National Emergency Medical Services Memorial Service and the National EMS Memorial honoring emergency medical services personnel who have died in the line of duty. 111-hconres-161 C001053 Rep. Cole, Tom [R-OK-4] R OK 2009-10-20 0
111-hconres-161,F000448 Recognizing and congratulating the City of Colorado Springs, Colorado, as the new official site of the National Emergency Medical Services Memorial Service and the National EMS Memorial honoring emergency medical services personnel who have died in the line of duty. 111-hconres-161 F000448 Rep. Franks, Trent [R-AZ-2] R AZ 2009-10-20 0
111-hconres-161,K000362 Recognizing and congratulating the City of Colorado Springs, Colorado, as the new official site of the National Emergency Medical Services Memorial Service and the National EMS Memorial honoring emergency medical services personnel who have died in the line of duty. 111-hconres-161 K000362 Rep. King, Steve [R-IA-5] R IA 2009-10-20 0
111-hconres-161,M001177 Recognizing and congratulating the City of Colorado Springs, Colorado, as the new official site of the National Emergency Medical Services Memorial Service and the National EMS Memorial honoring emergency medical services personnel who have died in the line of duty. 111-hconres-161 M001177 Rep. McClintock, Tom [R-CA-4] R CA 2009-10-20 0
111-hconres-161,R000583 Recognizing and congratulating the City of Colorado Springs, Colorado, as the new official site of the National Emergency Medical Services Memorial Service and the National EMS Memorial honoring emergency medical services personnel who have died in the line of duty. 111-hconres-161 R000583 Rep. Rooney, Thomas J. [R-FL-16] R FL 2009-10-20 0
111-hconres-161,H001048 Recognizing and congratulating the City of Colorado Springs, Colorado, as the new official site of the National Emergency Medical Services Memorial Service and the National EMS Memorial honoring emergency medical services personnel who have died in the line of duty. 111-hconres-161 H001048 Rep. Hunter, Duncan D. [R-CA-52] R CA 2009-10-20 0
111-hconres-161,W000119 Recognizing and congratulating the City of Colorado Springs, Colorado, as the new official site of the National Emergency Medical Services Memorial Service and the National EMS Memorial honoring emergency medical services personnel who have died in the line of duty. 111-hconres-161 W000119 Rep. Wamp, Zach [R-TN-3] R TN 2009-10-20 0
111-hconres-161,B000461 Recognizing and congratulating the City of Colorado Springs, Colorado, as the new official site of the National Emergency Medical Services Memorial Service and the National EMS Memorial honoring emergency medical services personnel who have died in the line of duty. 111-hconres-161 B000461 Rep. Bilbray, Brian P. [R-CA-50] R CA 2009-10-20 0
111-hconres-161,P000599 Recognizing and congratulating the City of Colorado Springs, Colorado, as the new official site of the National Emergency Medical Services Memorial Service and the National EMS Memorial honoring emergency medical services personnel who have died in the line of duty. 111-hconres-161 P000599 Rep. Posey, Bill [R-FL-15] R FL 2009-10-20 0
111-hconres-161,L000569 Recognizing and congratulating the City of Colorado Springs, Colorado, as the new official site of the National Emergency Medical Services Memorial Service and the National EMS Memorial honoring emergency medical services personnel who have died in the line of duty. 111-hconres-161 L000569 Rep. Luetkemeyer, Blaine [R-MO-9] R MO 2009-10-20 0
111-hconres-161,B001250 Recognizing and congratulating the City of Colorado Springs, Colorado, as the new official site of the National Emergency Medical Services Memorial Service and the National EMS Memorial honoring emergency medical services personnel who have died in the line of duty. 111-hconres-161 B001250 Rep. Bishop, Rob [R-UT-1] R UT 2009-10-20 0
111-hconres-161,C001062 Recognizing and congratulating the City of Colorado Springs, Colorado, as the new official site of the National Emergency Medical Services Memorial Service and the National EMS Memorial honoring emergency medical services personnel who have died in the line of duty. 111-hconres-161 C001062 Rep. Conaway, K. Michael [R-TX-11] R TX 2009-10-20 0
111-hconres-161,B001235 Recognizing and congratulating the City of Colorado Springs, Colorado, as the new official site of the National Emergency Medical Services Memorial Service and the National EMS Memorial honoring emergency medical services personnel who have died in the line of duty. 111-hconres-161 B001235 Rep. Brown, Henry E., Jr. [R-SC-1] R SC 2009-10-20 0
111-hconres-161,A000358 Recognizing and congratulating the City of Colorado Springs, Colorado, as the new official site of the National Emergency Medical Services Memorial Service and the National EMS Memorial honoring emergency medical services personnel who have died in the line of duty. 111-hconres-161 A000358 Rep. Akin, W. Todd [R-MO-2] R MO 2009-10-20 0
111-hconres-161,J000174 Recognizing and congratulating the City of Colorado Springs, Colorado, as the new official site of the National Emergency Medical Services Memorial Service and the National EMS Memorial honoring emergency medical services personnel who have died in the line of duty. 111-hconres-161 J000174 Rep. Johnson, Sam [R-TX-3] R TX 2009-10-20 0
111-hconres-161,W000804 Recognizing and congratulating the City of Colorado Springs, Colorado, as the new official site of the National Emergency Medical Services Memorial Service and the National EMS Memorial honoring emergency medical services personnel who have died in the line of duty. 111-hconres-161 W000804 Rep. Wittman, Robert J. [R-VA-1] R VA 2009-07-09 0
111-hconres-161,G000289 Recognizing and congratulating the City of Colorado Springs, Colorado, as the new official site of the National Emergency Medical Services Memorial Service and the National EMS Memorial honoring emergency medical services personnel who have died in the line of duty. 111-hconres-161 G000289 Rep. Goodlatte, Bob [R-VA-6] R VA 2009-07-08 1

Advanced export

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

CSV options: 

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