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

12 rows where bill_id = "110-hr-6859" 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 12
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
110-hr-6859,W000796 To designate the facility of the United States Postal Service located at 1501 South Slappey Boulevard in Albany, Georgia, as the "Dr. Walter Carl Gordon, Jr. Post Office Building". 110-hr-6859 W000796 Rep. Westmoreland, Lynn A. [R-GA-3] R GA 2008-09-10 1
110-hr-6859,J000288 To designate the facility of the United States Postal Service located at 1501 South Slappey Boulevard in Albany, Georgia, as the "Dr. Walter Carl Gordon, Jr. Post Office Building". 110-hr-6859 J000288 Rep. Johnson, Henry C. "Hank," Jr. [D-GA-4] D GA 2008-09-10 1
110-hr-6859,D000168 To designate the facility of the United States Postal Service located at 1501 South Slappey Boulevard in Albany, Georgia, as the "Dr. Walter Carl Gordon, Jr. Post Office Building". 110-hr-6859 D000168 Rep. Deal, Nathan [R-GA-9] R GA 2008-09-10 1
110-hr-6859,L000287 To designate the facility of the United States Postal Service located at 1501 South Slappey Boulevard in Albany, Georgia, as the "Dr. Walter Carl Gordon, Jr. Post Office Building". 110-hr-6859 L000287 Rep. Lewis, John [D-GA-5] D GA 2008-09-10 1
110-hr-6859,B001262 To designate the facility of the United States Postal Service located at 1501 South Slappey Boulevard in Albany, Georgia, as the "Dr. Walter Carl Gordon, Jr. Post Office Building". 110-hr-6859 B001262 Rep. Broun, Paul C. [R-GA-10] R GA 2008-09-10 1
110-hr-6859,S001157 To designate the facility of the United States Postal Service located at 1501 South Slappey Boulevard in Albany, Georgia, as the "Dr. Walter Carl Gordon, Jr. Post Office Building". 110-hr-6859 S001157 Rep. Scott, David [D-GA-13] D GA 2008-09-10 1
110-hr-6859,L000321 To designate the facility of the United States Postal Service located at 1501 South Slappey Boulevard in Albany, Georgia, as the "Dr. Walter Carl Gordon, Jr. Post Office Building". 110-hr-6859 L000321 Rep. Linder, John [R-GA-7] R GA 2008-09-10 1
110-hr-6859,B001252 To designate the facility of the United States Postal Service located at 1501 South Slappey Boulevard in Albany, Georgia, as the "Dr. Walter Carl Gordon, Jr. Post Office Building". 110-hr-6859 B001252 Rep. Barrow, John [D-GA-12] D GA 2008-09-10 1
110-hr-6859,G000550 To designate the facility of the United States Postal Service located at 1501 South Slappey Boulevard in Albany, Georgia, as the "Dr. Walter Carl Gordon, Jr. Post Office Building". 110-hr-6859 G000550 Rep. Gingrey, Phil [R-GA-11] R GA 2008-09-10 1
110-hr-6859,M001146 To designate the facility of the United States Postal Service located at 1501 South Slappey Boulevard in Albany, Georgia, as the "Dr. Walter Carl Gordon, Jr. Post Office Building". 110-hr-6859 M001146 Rep. Marshall, Jim [D-GA-8] D GA 2008-09-10 1
110-hr-6859,P000591 To designate the facility of the United States Postal Service located at 1501 South Slappey Boulevard in Albany, Georgia, as the "Dr. Walter Carl Gordon, Jr. Post Office Building". 110-hr-6859 P000591 Rep. Price, Tom [R-GA-6] R GA 2008-09-10 1
110-hr-6859,K000220 To designate the facility of the United States Postal Service located at 1501 South Slappey Boulevard in Albany, Georgia, as the "Dr. Walter Carl Gordon, Jr. Post Office Building". 110-hr-6859 K000220 Rep. Kingston, Jack [R-GA-1] R GA 2008-09-10 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);