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

19 rows where bill_id = "97-hr-6816" 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

  • 1 18
  • 0 1
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
97-hr-6816,B000153 Diversity Jurisdiction Reform Act of 1982 97-hr-6816 B000153 Rep. Barnard, Doug, Jr. [D-GA-10] D GA 1982-07-27 0
97-hr-6816,K000020 Diversity Jurisdiction Reform Act of 1982 97-hr-6816 K000020 Rep. Kastenmeier, Robert W. [D-WI-2] D WI 1982-07-21 1
97-hr-6816,R000012 Diversity Jurisdiction Reform Act of 1982 97-hr-6816 R000012 Rep. Railsback, Thomas F. [R-IL-19] R IL 1982-07-21 1
97-hr-6816,S000142 Diversity Jurisdiction Reform Act of 1982 97-hr-6816 S000142 Rep. Schroeder, Patricia [D-CO-1] D CO 1982-07-21 1
97-hr-6816,K000190 Diversity Jurisdiction Reform Act of 1982 97-hr-6816 K000190 Rep. Kindness, Thomas N. [R-OH-8] R OH 1982-07-21 1
97-hr-6816,M000340 Diversity Jurisdiction Reform Act of 1982 97-hr-6816 M000340 Rep. McClory, Robert [R-IL-13] R IL 1982-07-21 1
97-hr-6816,F000141 Diversity Jurisdiction Reform Act of 1982 97-hr-6816 F000141 Rep. Fish, Hamilton, Jr. [R-NY-25] R NY 1982-07-21 1
97-hr-6816,M000926 Diversity Jurisdiction Reform Act of 1982 97-hr-6816 M000926 Rep. Moorhead, Carlos J. [R-CA-22] R CA 1982-07-21 1
97-hr-6816,H001022 Diversity Jurisdiction Reform Act of 1982 97-hr-6816 H001022 Rep. Hyde, Henry J. [R-IL-6] R IL 1982-07-21 1
97-hr-6816,L000517 Diversity Jurisdiction Reform Act of 1982 97-hr-6816 L000517 Rep. Lungren, Daniel E. [R-CA-34] R CA 1982-07-21 1
97-hr-6816,O000006 Diversity Jurisdiction Reform Act of 1982 97-hr-6816 O000006 Rep. Oberstar, James L. [D-MN-8] D MN 1982-07-21 1
97-hr-6816,B000371 Diversity Jurisdiction Reform Act of 1982 97-hr-6816 B000371 Rep. Bennett, Charles E. [D-FL-3] D FL 1982-07-21 1
97-hr-6816,F000286 Diversity Jurisdiction Reform Act of 1982 97-hr-6816 F000286 Rep. Forsythe, Edwin B. [R-NJ-6] R NJ 1982-07-21 1
97-hr-6816,C000773 Diversity Jurisdiction Reform Act of 1982 97-hr-6816 C000773 Rep. Corcoran, Tom [R-IL-15] R IL 1982-07-21 1
97-hr-6816,S000596 Diversity Jurisdiction Reform Act of 1982 97-hr-6816 S000596 Rep. Smith, Neal Edward [D-IA-4] D IA 1982-07-21 1
97-hr-6816,S000948 Diversity Jurisdiction Reform Act of 1982 97-hr-6816 S000948 Rep. Stokes, Louis [D-OH-21] D OH 1982-07-21 1
97-hr-6816,F000041 Diversity Jurisdiction Reform Act of 1982 97-hr-6816 F000041 Rep. Fascell, Dante B. [D-FL-15] D FL 1982-07-21 1
97-hr-6816,B000472 Diversity Jurisdiction Reform Act of 1982 97-hr-6816 B000472 Rep. Bingham, Jonathan B. [D-NY-22] D NY 1982-07-21 1
97-hr-6816,W000215 Diversity Jurisdiction Reform Act of 1982 97-hr-6816 W000215 Rep. Waxman, Henry A. [D-CA-24] D CA 1982-07-21 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);