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

22 rows where bill_id = "110-hr-5489" 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 10
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
110-hr-5489,Y000031 To designate the facility of the United States Postal Service located at 6892 Main Street in Gloucester, Virginia, as the "Congresswoman Jo Ann S. Davis Post Office". 110-hr-5489 Y000031 Rep. Young, C. W. Bill [R-FL-10] R FL 2008-03-13 0
110-hr-5489,P000586 To designate the facility of the United States Postal Service located at 6892 Main Street in Gloucester, Virginia, as the "Congresswoman Jo Ann S. Davis Post Office". 110-hr-5489 P000586 Rep. Putnam, Adam H. [R-FL-12] R FL 2008-03-13 0
110-hr-5489,C001036 To designate the facility of the United States Postal Service located at 6892 Main Street in Gloucester, Virginia, as the "Congresswoman Jo Ann S. Davis Post Office". 110-hr-5489 C001036 Rep. Capps, Lois [D-CA-23] D CA 2008-03-13 0
110-hr-5489,D000603 To designate the facility of the United States Postal Service located at 6892 Main Street in Gloucester, Virginia, as the "Congresswoman Jo Ann S. Davis Post Office". 110-hr-5489 D000603 Rep. Davis, Geoff [R-KY-4] R KY 2008-03-12 0
110-hr-5489,F000010 To designate the facility of the United States Postal Service located at 6892 Main Street in Gloucester, Virginia, as the "Congresswoman Jo Ann S. Davis Post Office". 110-hr-5489 F000010 Del. Faleomavaega, Eni F. H. [D-AS-At Large] D AS 2008-03-12 0
110-hr-5489,M001134 To designate the facility of the United States Postal Service located at 6892 Main Street in Gloucester, Virginia, as the "Congresswoman Jo Ann S. Davis Post Office". 110-hr-5489 M001134 Rep. Myrick, Sue Wilkins [R-NC-9] R NC 2008-03-12 0
110-hr-5489,S000465 To designate the facility of the United States Postal Service located at 6892 Main Street in Gloucester, Virginia, as the "Congresswoman Jo Ann S. Davis Post Office". 110-hr-5489 S000465 Rep. Skelton, Ike [D-MO-4] D MO 2008-03-11 0
110-hr-5489,R000011 To designate the facility of the United States Postal Service located at 6892 Main Street in Gloucester, Virginia, as the "Congresswoman Jo Ann S. Davis Post Office". 110-hr-5489 R000011 Rep. Rahall, Nick J., II [D-WV-3] D WV 2008-03-11 0
110-hr-5489,D000299 To designate the facility of the United States Postal Service located at 6892 Main Street in Gloucester, Virginia, as the "Congresswoman Jo Ann S. Davis Post Office". 110-hr-5489 D000299 Rep. Diaz-Balart, Lincoln [R-FL-21] R FL 2008-03-11 0
110-hr-5489,M001146 To designate the facility of the United States Postal Service located at 6892 Main Street in Gloucester, Virginia, as the "Congresswoman Jo Ann S. Davis Post Office". 110-hr-5489 M001146 Rep. Marshall, Jim [D-GA-8] D GA 2008-03-11 0
110-hr-5489,E000187 To designate the facility of the United States Postal Service located at 6892 Main Street in Gloucester, Virginia, as the "Congresswoman Jo Ann S. Davis Post Office". 110-hr-5489 E000187 Rep. English, Phil [R-PA-3] R PA 2008-03-11 0
110-hr-5489,L000321 To designate the facility of the United States Postal Service located at 6892 Main Street in Gloucester, Virginia, as the "Congresswoman Jo Ann S. Davis Post Office". 110-hr-5489 L000321 Rep. Linder, John [R-GA-7] R GA 2008-03-11 0
110-hr-5489,C001046 To designate the facility of the United States Postal Service located at 6892 Main Street in Gloucester, Virginia, as the "Congresswoman Jo Ann S. Davis Post Office". 110-hr-5489 C001046 Rep. Cantor, Eric [R-VA-7] R VA 2008-02-26 1
110-hr-5489,D000136 To designate the facility of the United States Postal Service located at 6892 Main Street in Gloucester, Virginia, as the "Congresswoman Jo Ann S. Davis Post Office". 110-hr-5489 D000136 Rep. Davis, Tom [R-VA-11] R VA 2008-02-26 1
110-hr-5489,M000933 To designate the facility of the United States Postal Service located at 6892 Main Street in Gloucester, Virginia, as the "Congresswoman Jo Ann S. Davis Post Office". 110-hr-5489 M000933 Rep. Moran, James P. [D-VA-8] D VA 2008-02-26 1
110-hr-5489,G000280 To designate the facility of the United States Postal Service located at 6892 Main Street in Gloucester, Virginia, as the "Congresswoman Jo Ann S. Davis Post Office". 110-hr-5489 G000280 Rep. Goode, Virgil H., Jr. [R-VA-5] R VA 2008-02-26 1
110-hr-5489,S000185 To designate the facility of the United States Postal Service located at 6892 Main Street in Gloucester, Virginia, as the "Congresswoman Jo Ann S. Davis Post Office". 110-hr-5489 S000185 Rep. Scott, Robert C. "Bobby" [D-VA-3] D VA 2008-02-26 1
110-hr-5489,W000672 To designate the facility of the United States Postal Service located at 6892 Main Street in Gloucester, Virginia, as the "Congresswoman Jo Ann S. Davis Post Office". 110-hr-5489 W000672 Rep. Wolf, Frank R. [R-VA-10] R VA 2008-02-26 1
110-hr-5489,B000657 To designate the facility of the United States Postal Service located at 6892 Main Street in Gloucester, Virginia, as the "Congresswoman Jo Ann S. Davis Post Office". 110-hr-5489 B000657 Rep. Boucher, Rick [D-VA-9] D VA 2008-02-26 1
110-hr-5489,D000605 To designate the facility of the United States Postal Service located at 6892 Main Street in Gloucester, Virginia, as the "Congresswoman Jo Ann S. Davis Post Office". 110-hr-5489 D000605 Rep. Drake, Thelma D. [R-VA-2] R VA 2008-02-26 1
110-hr-5489,F000445 To designate the facility of the United States Postal Service located at 6892 Main Street in Gloucester, Virginia, as the "Congresswoman Jo Ann S. Davis Post Office". 110-hr-5489 F000445 Rep. Forbes, J. Randy [R-VA-4] R VA 2008-02-26 1
110-hr-5489,G000289 To designate the facility of the United States Postal Service located at 6892 Main Street in Gloucester, Virginia, as the "Congresswoman Jo Ann S. Davis Post Office". 110-hr-5489 G000289 Rep. Goodlatte, Bob [R-VA-6] R VA 2008-02-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);