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

18 rows where bill_id = "110-hr-5233" 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 1

  • 0 18
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
110-hr-5233,P000373 Giving Relief to Our Small Businesses Act 110-hr-5233 P000373 Rep. Pitts, Joseph R. [R-PA-16] R PA 2008-04-10 0
110-hr-5233,G000180 Giving Relief to Our Small Businesses Act 110-hr-5233 G000180 Rep. Gilchrest, Wayne T. [R-MD-1] R MD 2008-04-09 0
110-hr-5233,B001255 Giving Relief to Our Small Businesses Act 110-hr-5233 B001255 Rep. Boustany, Charles W., Jr. [R-LA-7] R LA 2008-04-08 0
110-hr-5233,G000548 Giving Relief to Our Small Businesses Act 110-hr-5233 G000548 Rep. Garrett, Scott [R-NJ-5] R NJ 2008-03-12 0
110-hr-5233,B001232 Giving Relief to Our Small Businesses Act 110-hr-5233 B001232 Rep. Biggert, Judy [R-IL-13] R IL 2008-03-12 0
110-hr-5233,B001242 Giving Relief to Our Small Businesses Act 110-hr-5233 B001242 Rep. Bishop, Timothy H. [D-NY-1] D NY 2008-03-05 0
110-hr-5233,C001062 Giving Relief to Our Small Businesses Act 110-hr-5233 C001062 Rep. Conaway, K. Michael [R-TX-11] R TX 2008-02-27 0
110-hr-5233,F000447 Giving Relief to Our Small Businesses Act 110-hr-5233 F000447 Rep. Feeney, Tom [R-FL-24] R FL 2008-02-25 0
110-hr-5233,K000364 Giving Relief to Our Small Businesses Act 110-hr-5233 K000364 Rep. Kuhl, John R. "Randy", Jr. [R-NY-29] R NY 2008-02-14 0
110-hr-5233,C001046 Giving Relief to Our Small Businesses Act 110-hr-5233 C001046 Rep. Cantor, Eric [R-VA-7] R VA 2008-02-14 0
110-hr-5233,M001152 Giving Relief to Our Small Businesses Act 110-hr-5233 M001152 Rep. Musgrave, Marilyn N. [R-CO-4] R CO 2008-02-14 0
110-hr-5233,M001134 Giving Relief to Our Small Businesses Act 110-hr-5233 M001134 Rep. Myrick, Sue Wilkins [R-NC-9] R NC 2008-02-13 0
110-hr-5233,F000450 Giving Relief to Our Small Businesses Act 110-hr-5233 F000450 Rep. Foxx, Virginia [R-NC-5] R NC 2008-02-12 0
110-hr-5233,W000804 Giving Relief to Our Small Businesses Act 110-hr-5233 W000804 Rep. Wittman, Robert J. [R-VA-1] R VA 2008-02-12 0
110-hr-5233,M001148 Giving Relief to Our Small Businesses Act 110-hr-5233 M001148 Rep. Meek, Kendrick B. [D-FL-17] D FL 2008-02-12 0
110-hr-5233,G000549 Giving Relief to Our Small Businesses Act 110-hr-5233 G000549 Rep. Gerlach, Jim [R-PA-6] R PA 2008-02-12 0
110-hr-5233,C000556 Giving Relief to Our Small Businesses Act 110-hr-5233 C000556 Rep. Coble, Howard [R-NC-6] R NC 2008-02-12 0
110-hr-5233,F000448 Giving Relief to Our Small Businesses Act 110-hr-5233 F000448 Rep. Franks, Trent [R-AZ-2] R AZ 2008-02-12 0

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);