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

16 rows where bill_id = "108-hconres-377" 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 13
  • 0 3
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
108-hconres-377,S000250 Recognizing the importance of Western civilization. 108-hconres-377 S000250 Rep. Sessions, Pete [R-TX-32] R TX 2004-06-18 0
108-hconres-377,A000014 Recognizing the importance of Western civilization. 108-hconres-377 A000014 Rep. Abercrombie, Neil [D-HI-1] D HI 2004-06-14 0
108-hconres-377,M001152 Recognizing the importance of Western civilization. 108-hconres-377 M001152 Rep. Musgrave, Marilyn N. [R-CO-4] R CO 2004-04-27 0
108-hconres-377,G000280 Recognizing the importance of Western civilization. 108-hconres-377 G000280 Rep. Goode, Virgil H., Jr. [R-VA-5] R VA 2004-03-02 1
108-hconres-377,A000358 Recognizing the importance of Western civilization. 108-hconres-377 A000358 Rep. Akin, W. Todd [R-MO-2] R MO 2004-03-02 1
108-hconres-377,A000055 Recognizing the importance of Western civilization. 108-hconres-377 A000055 Rep. Aderholt, Robert B. [R-AL-4] R AL 2004-03-02 1
108-hconres-377,P000587 Recognizing the importance of Western civilization. 108-hconres-377 P000587 Rep. Pence, Mike [R-IN-6] R IN 2004-03-02 1
108-hconres-377,P000373 Recognizing the importance of Western civilization. 108-hconres-377 P000373 Rep. Pitts, Joseph R. [R-PA-16] R PA 2004-03-02 1
108-hconres-377,S000583 Recognizing the importance of Western civilization. 108-hconres-377 S000583 Rep. Smith, Lamar [R-TX-21] R TX 2004-03-02 1
108-hconres-377,D000168 Recognizing the importance of Western civilization. 108-hconres-377 D000168 Rep. Deal, Nathan [R-GA-10] R GA 2004-03-02 1
108-hconres-377,K000361 Recognizing the importance of Western civilization. 108-hconres-377 K000361 Rep. Keller, Ric [R-FL-8] R FL 2004-03-02 1
108-hconres-377,K000220 Recognizing the importance of Western civilization. 108-hconres-377 K000220 Rep. Kingston, Jack [R-GA-1] R GA 2004-03-02 1
108-hconres-377,B000208 Recognizing the importance of Western civilization. 108-hconres-377 B000208 Rep. Bartlett, Roscoe G. [R-MD-6] R MD 2004-03-02 1
108-hconres-377,N000159 Recognizing the importance of Western civilization. 108-hconres-377 N000159 Rep. Norwood, Charles W. [R-GA-9] R GA 2004-03-02 1
108-hconres-377,J000255 Recognizing the importance of Western civilization. 108-hconres-377 J000255 Rep. Jones, Walter B., Jr. [R-NC-3] R NC 2004-03-02 1
108-hconres-377,B001247 Recognizing the importance of Western civilization. 108-hconres-377 B001247 Rep. Brown-Waite, Ginny [R-FL-5] R FL 2004-03-02 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);