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

8 rows where bill_id = "119-hr-6808" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party, sponsorship_date (date)

is_original_cosponsor 1

  • 1 8
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
119-hr-6808,H001086 To designate the facility of the United States Postal Service located at 417 West 7th Street in Columbia, Tennessee, as the "Pharmacist's Mate First Class John Harlan Willis Post Office Building". 119-hr-6808 H001086 Rep. Harshbarger, Diana [R-TN-1] R TN 2025-12-17 1
119-hr-6808,B001309 To designate the facility of the United States Postal Service located at 417 West 7th Street in Columbia, Tennessee, as the "Pharmacist's Mate First Class John Harlan Willis Post Office Building". 119-hr-6808 B001309 Rep. Burchett, Tim [R-TN-2] R TN 2025-12-17 1
119-hr-6808,F000459 To designate the facility of the United States Postal Service located at 417 West 7th Street in Columbia, Tennessee, as the "Pharmacist's Mate First Class John Harlan Willis Post Office Building". 119-hr-6808 F000459 Rep. Fleischmann, Charles J. "Chuck" [R-TN-3] R TN 2025-12-17 1
119-hr-6808,D000616 To designate the facility of the United States Postal Service located at 417 West 7th Street in Columbia, Tennessee, as the "Pharmacist's Mate First Class John Harlan Willis Post Office Building". 119-hr-6808 D000616 Rep. DesJarlais, Scott [R-TN-4] R TN 2025-12-17 1
119-hr-6808,R000612 To designate the facility of the United States Postal Service located at 417 West 7th Street in Columbia, Tennessee, as the "Pharmacist's Mate First Class John Harlan Willis Post Office Building". 119-hr-6808 R000612 Rep. Rose, John W. [R-TN-6] R TN 2025-12-17 1
119-hr-6808,V000139 To designate the facility of the United States Postal Service located at 417 West 7th Street in Columbia, Tennessee, as the "Pharmacist's Mate First Class John Harlan Willis Post Office Building". 119-hr-6808 V000139 Rep. Van Epps, Matt [R-TN-7] R TN 2025-12-17 1
119-hr-6808,K000392 To designate the facility of the United States Postal Service located at 417 West 7th Street in Columbia, Tennessee, as the "Pharmacist's Mate First Class John Harlan Willis Post Office Building". 119-hr-6808 K000392 Rep. Kustoff, David [R-TN-8] R TN 2025-12-17 1
119-hr-6808,C001068 To designate the facility of the United States Postal Service located at 417 West 7th Street in Columbia, Tennessee, as the "Pharmacist's Mate First Class John Harlan Willis Post Office Building". 119-hr-6808 C001068 Rep. Cohen, Steve [D-TN-9] D TN 2025-12-17 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);