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

21 rows where bill_id = "95-hr-11282" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party

is_original_cosponsor 1

  • 0 21
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
95-hr-11282,T000200 Education Amendments 95-hr-11282 T000200 Rep. Thompson, Frank, Jr. [D-NJ-4] D     0
95-hr-11282,B000736 Education Amendments 95-hr-11282 B000736 Rep. Brademas, John [D-IN-3] D     0
95-hr-11282,H000367 Education Amendments 95-hr-11282 H000367 Rep. Hawkins, Augustus F. [D-CA-29] D     0
95-hr-11282,F000270 Education Amendments 95-hr-11282 F000270 Rep. Ford, William D. [D-MI-15] D     0
95-hr-11282,B001156 Education Amendments 95-hr-11282 B001156 Rep. Burton, Phillip [D-CA-6] D     0
95-hr-11282,G000105 Education Amendments 95-hr-11282 G000105 Rep. Gaydos, Joseph M. [D-PA-20] D     0
95-hr-11282,C000488 Education Amendments 95-hr-11282 C000488 Rep. Clay, William (Bill) [D-MO-1] D     0
95-hr-11282,B000432 Education Amendments 95-hr-11282 B000432 Rep. Biaggi, Mario [D-NY-10] D NY   0
95-hr-11282,A000207 Education Amendments 95-hr-11282 A000207 Rep. Andrews, Ike [D-NC-4] D     0
95-hr-11282,B000567 Education Amendments 95-hr-11282 B000567 Rep. Blouin, Michael [D-IA-2] D     0
95-hr-11282,S000423 Education Amendments 95-hr-11282 S000423 Rep. Simon, Paul [D-IL-24] D     0
95-hr-11282,B000279 Education Amendments 95-hr-11282 B000279 Rep. Beard, Edward [D-RI-2] D     0
95-hr-11282,Z000002 Education Amendments 95-hr-11282 Z000002 Rep. Zeferetti, Leo C. [D-NY-15] D     0
95-hr-11282,M000725 Education Amendments 95-hr-11282 M000725 Rep. Miller, George [D-CA-7] D CA   0
95-hr-11282,M001132 Education Amendments 95-hr-11282 M001132 Rep. Myers, Michael O. [D-PA-1] D     0
95-hr-11282,M001088 Education Amendments 95-hr-11282 M001088 Rep. Murphy, Austin J. [D-PA-22] D     0
95-hr-11282,W000258 Education Amendments 95-hr-11282 W000258 Rep. Weiss, Ted [D-NY-20] D     0
95-hr-11282,H000449 Education Amendments 95-hr-11282 H000449 Rep. Heftel, Cecil [D-HI-1] D     0
95-hr-11282,C000788 Education Amendments 95-hr-11282 C000788 Resident Commissioner Corrada, Baltasar [I-PR-At Large] I     0
95-hr-11282,K000172 Education Amendments 95-hr-11282 K000172 Rep. Kildee, Dale E. [D-MI-7] D     0
95-hr-11282,C000371 Education Amendments 95-hr-11282 C000371 Rep. Chisholm, Shirley [D-NY-12] D     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);