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

24 rows where bill_id = "95-hr-9804" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party, state

is_original_cosponsor 1

  • 0 24
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
95-hr-9804,C000598 Civil Rights Act 95-hr-9804 C000598 Rep. Cohen, William S. [R-ME-2] R     0
95-hr-9804,F000380 Civil Rights Act 95-hr-9804 F000380 Rep. Frenzel, Bill [R-MN-3] R     0
95-hr-9804,P000546 Civil Rights Act 95-hr-9804 P000546 Rep. Pritchard, Joel [R-WA-1] R     0
95-hr-9804,A000195 Civil Rights Act 95-hr-9804 A000195 Rep. Anderson, John B. [R-IL-16] R     0
95-hr-9804,F000141 Civil Rights Act 95-hr-9804 F000141 Rep. Fish, Hamilton, Jr. [R-NY-25] R NY   0
95-hr-9804,A000208 Civil Rights Act 95-hr-9804 A000208 Rep. Andrews, Mark [R-ND-At Large] R     0
95-hr-9804,B001008 Civil Rights Act 95-hr-9804 B001008 Rep. Buchanan, John [R-AL-6] R     0
95-hr-9804,C000567 Civil Rights Act 95-hr-9804 C000567 Rep. Cochran, Thad [R-MS-4] R MS   0
95-hr-9804,C000666 Civil Rights Act 95-hr-9804 C000666 Rep. Conable, Barber B., Jr. [R-NY-35] R NY   0
95-hr-9804,C000807 Civil Rights Act 95-hr-9804 C000807 Rep. Coughlin, Lawrence [R-PA-13] R     0
95-hr-9804,E000204 Civil Rights Act 95-hr-9804 E000204 Rep. Erlenborn, John N. [R-IL-14] R     0
95-hr-9804,G000349 Civil Rights Act 95-hr-9804 G000349 Rep. Gradison, Willis D., Jr. [R-OH-1] R     0
95-hr-9804,H000440 Civil Rights Act 95-hr-9804 H000440 Rep. Heckler, Margaret M. [R-MA-10] R     0
95-hr-9804,H000624 Civil Rights Act 95-hr-9804 H000624 Rep. Hillis, Elwood H. [R-IN-5] R     0
95-hr-9804,J000072 Civil Rights Act 95-hr-9804 J000072 Rep. Jeffords, James M. [R-VT-At Large] I     0
95-hr-9804,K000019 Civil Rights Act 95-hr-9804 K000019 Rep. Kasten, Robert W., Jr. [R-WI-9] R     0
95-hr-9804,K000086 Civil Rights Act 95-hr-9804 K000086 Rep. Kemp, Jack [R-NY-38] R NY   0
95-hr-9804,L000169 Civil Rights Act 95-hr-9804 L000169 Rep. Leach, James A. [R-IA-1] R     0
95-hr-9804,M000340 Civil Rights Act 95-hr-9804 M000340 Rep. McClory, Robert [R-IL-13] R IL   0
95-hr-9804,M000343 Civil Rights Act 95-hr-9804 M000343 Rep. McCloskey, Paul N., Jr. [R-CA-12] R CA   0
95-hr-9804,M000399 Civil Rights Act 95-hr-9804 M000399 Rep. McDade, Joseph M. [R-PA-10] R     0
95-hr-9804,M000527 Civil Rights Act 95-hr-9804 M000527 Rep. McKinney, Stewart B. [R-CT-4] R     0
95-hr-9804,M000136 Civil Rights Act 95-hr-9804 M000136 Rep. Marks, Marc L. [R-PA-24] R     0
95-hr-9804,P000273 Civil Rights Act 95-hr-9804 P000273 Rep. Pettis, Shirley N. [R-CA-37] R     0

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