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

18 rows where bill_id = "110-hr-6559" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party, state, sponsorship_date, sponsorship_date (date)

is_original_cosponsor 2

  • 0 15
  • 1 3
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
110-hr-6559,S001144 OFS Act 110-hr-6559 S001144 Rep. Shays, Christopher [R-CT-4] R CT 2008-09-29 0
110-hr-6559,C001045 OFS Act 110-hr-6559 C001045 Rep. Crenshaw, Ander [R-FL-4] R FL 2008-09-24 0
110-hr-6559,H000627 OFS Act 110-hr-6559 H000627 Rep. Hinchey, Maurice D. [D-NY-22] D NY 2008-09-23 0
110-hr-6559,S001162 OFS Act 110-hr-6559 S001162 Rep. Schwartz, Allyson Y. [D-PA-13] D PA 2008-09-23 0
110-hr-6559,L000563 OFS Act 110-hr-6559 L000563 Rep. Lipinski, Daniel [D-IL-3] D IL 2008-09-10 0
110-hr-6559,S001157 OFS Act 110-hr-6559 S001157 Rep. Scott, David [D-GA-13] D GA 2008-09-09 0
110-hr-6559,J000288 OFS Act 110-hr-6559 J000288 Rep. Johnson, Henry C. "Hank," Jr. [D-GA-4] D GA 2008-09-08 0
110-hr-6559,L000480 OFS Act 110-hr-6559 L000480 Rep. Lowey, Nita M. [D-NY-18] D NY 2008-08-01 0
110-hr-6559,B000490 OFS Act 110-hr-6559 B000490 Rep. Bishop, Sanford D., Jr. [D-GA-2] D GA 2008-07-31 0
110-hr-6559,B001252 OFS Act 110-hr-6559 B001252 Rep. Barrow, John [D-GA-12] D GA 2008-07-30 0
110-hr-6559,C001068 OFS Act 110-hr-6559 C001068 Rep. Cohen, Steve [D-TN-9] D TN 2008-07-30 0
110-hr-6559,W000314 OFS Act 110-hr-6559 W000314 Rep. Wexler, Robert [D-FL-19] D FL 2008-07-29 0
110-hr-6559,K000364 OFS Act 110-hr-6559 K000364 Rep. Kuhl, John R. "Randy", Jr. [R-NY-29] R NY 2008-07-24 0
110-hr-6559,B000208 OFS Act 110-hr-6559 B000208 Rep. Bartlett, Roscoe G. [R-MD-6] R MD 2008-07-24 0
110-hr-6559,M001138 OFS Act 110-hr-6559 M001138 Rep. Manzullo, Donald A. [R-IL-16] R IL 2008-07-24 0
110-hr-6559,K000220 OFS Act 110-hr-6559 K000220 Rep. Kingston, Jack [R-GA-1] R GA 2008-07-22 1
110-hr-6559,I000057 OFS Act 110-hr-6559 I000057 Rep. Israel, Steve [D-NY-2] D NY 2008-07-22 1
110-hr-6559,I000023 OFS Act 110-hr-6559 I000023 Rep. Inglis, Bob [R-SC-4] R SC 2008-07-22 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);