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

7 rows where bill_id = "110-hr-4504" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: sponsorship_date, sponsorship_date (date)

is_original_cosponsor 2

Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
110-hr-4504,G000553 To authorize the International Boundary and Water Commission to reimburse State and local governments of the States of Arizona, California, New Mexico, and Texas for expenses incurred by such a government in designing, constructing, and rehabilitating water projects under the jurisdiction of such Commission. 110-hr-4504 G000553 Rep. Green, Al [D-TX-9] D TX 2008-01-17 0
110-hr-4504,O000107 To authorize the International Boundary and Water Commission to reimburse State and local governments of the States of Arizona, California, New Mexico, and Texas for expenses incurred by such a government in designing, constructing, and rehabilitating water projects under the jurisdiction of such Commission. 110-hr-4504 O000107 Rep. Ortiz, Solomon P. [D-TX-27] D TX 2007-12-12 1
110-hr-4504,R000568 To authorize the International Boundary and Water Commission to reimburse State and local governments of the States of Arizona, California, New Mexico, and Texas for expenses incurred by such a government in designing, constructing, and rehabilitating water projects under the jurisdiction of such Commission. 110-hr-4504 R000568 Rep. Rodriguez, Ciro D. [D-TX-23] D TX 2007-12-12 1
110-hr-4504,R000170 To authorize the International Boundary and Water Commission to reimburse State and local governments of the States of Arizona, California, New Mexico, and Texas for expenses incurred by such a government in designing, constructing, and rehabilitating water projects under the jurisdiction of such Commission. 110-hr-4504 R000170 Rep. Reyes, Silvestre [D-TX-16] D TX 2007-12-12 1
110-hr-4504,C001063 To authorize the International Boundary and Water Commission to reimburse State and local governments of the States of Arizona, California, New Mexico, and Texas for expenses incurred by such a government in designing, constructing, and rehabilitating water projects under the jurisdiction of such Commission. 110-hr-4504 C001063 Rep. Cuellar, Henry [D-TX-28] D TX 2007-12-12 1
110-hr-4504,G000410 To authorize the International Boundary and Water Commission to reimburse State and local governments of the States of Arizona, California, New Mexico, and Texas for expenses incurred by such a government in designing, constructing, and rehabilitating water projects under the jurisdiction of such Commission. 110-hr-4504 G000410 Rep. Green, Gene [D-TX-29] D TX 2007-12-12 1
110-hr-4504,J000032 To authorize the International Boundary and Water Commission to reimburse State and local governments of the States of Arizona, California, New Mexico, and Texas for expenses incurred by such a government in designing, constructing, and rehabilitating water projects under the jurisdiction of such Commission. 110-hr-4504 J000032 Rep. Jackson-Lee, Sheila [D-TX-18] D TX 2007-12-12 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);