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

14 rows where bill_id = "104-hr-3161" 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 12
  • 1 2
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
104-hr-3161,M001138 To authorize the extension of nondiscriminatory treatment (most-favored-nation treatment) to the products of Romania. 104-hr-3161 M001138 Rep. Manzullo, Donald A. [R-IL-16] R IL 1996-06-12 0
104-hr-3161,K000306 To authorize the extension of nondiscriminatory treatment (most-favored-nation treatment) to the products of Romania. 104-hr-3161 K000306 Rep. Kolbe, Jim [R-AZ-5] R AZ 1996-06-10 0
104-hr-3161,G000309 To authorize the extension of nondiscriminatory treatment (most-favored-nation treatment) to the products of Romania. 104-hr-3161 G000309 Rep. Gordon, Bart [D-TN-6] D TN 1996-06-10 0
104-hr-3161,E000282 To authorize the extension of nondiscriminatory treatment (most-favored-nation treatment) to the products of Romania. 104-hr-3161 E000282 Rep. Ewing, Thomas W. [R-IL-15] R IL 1996-06-05 0
104-hr-3161,F000257 To authorize the extension of nondiscriminatory treatment (most-favored-nation treatment) to the products of Romania. 104-hr-3161 F000257 Rep. Forbes, Michael P. [R-NY-1] R NY 1996-06-05 0
104-hr-3161,H000114 To authorize the extension of nondiscriminatory treatment (most-favored-nation treatment) to the products of Romania. 104-hr-3161 H000114 Rep. Hamilton, Lee H. [D-IN-9] D IN 1996-05-14 0
104-hr-3161,C000994 To authorize the extension of nondiscriminatory treatment (most-favored-nation treatment) to the products of Romania. 104-hr-3161 C000994 Rep. Cunningham, Randy (Duke) [R-CA-51] R CA 1996-05-08 0
104-hr-3161,J000126 To authorize the extension of nondiscriminatory treatment (most-favored-nation treatment) to the products of Romania. 104-hr-3161 J000126 Rep. Johnson, Eddie Bernice [D-TX-30] D TX 1996-05-01 0
104-hr-3161,L000090 To authorize the extension of nondiscriminatory treatment (most-favored-nation treatment) to the products of Romania. 104-hr-3161 L000090 Rep. Lantos, Tom [D-CA-12] D CA 1996-04-25 0
104-hr-3161,M000933 To authorize the extension of nondiscriminatory treatment (most-favored-nation treatment) to the products of Romania. 104-hr-3161 M000933 Rep. Moran, James P. [D-VA-8] D VA 1996-04-24 0
104-hr-3161,B000403 To authorize the extension of nondiscriminatory treatment (most-favored-nation treatment) to the products of Romania. 104-hr-3161 B000403 Rep. Bereuter, Doug [R-NE-1] R NE 1996-04-18 0
104-hr-3161,H000814 To authorize the extension of nondiscriminatory treatment (most-favored-nation treatment) to the products of Romania. 104-hr-3161 H000814 Rep. Houghton, Amo [R-NY-31] R NY 1996-04-16 0
104-hr-3161,G000153 To authorize the extension of nondiscriminatory treatment (most-favored-nation treatment) to the products of Romania. 104-hr-3161 G000153 Rep. Gibbons, Sam [D-FL-11] D FL 1996-03-26 1
104-hr-3161,K000118 To authorize the extension of nondiscriminatory treatment (most-favored-nation treatment) to the products of Romania. 104-hr-3161 K000118 Rep. Kennelly, Barbara B. [D-CT-1] D CT 1996-03-26 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);