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

31 rows where bill_id = "108-hr-4576" 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 16
  • 1 15
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
108-hr-4576,B001236 Food Promotion Act of 2004 108-hr-4576 B001236 Rep. Boozman, John [R-AR-3] R AR 2004-10-05 0
108-hr-4576,S000364 Food Promotion Act of 2004 108-hr-4576 S000364 Rep. Shimkus, John [R-IL-19] R IL 2004-07-22 0
108-hr-4576,M001138 Food Promotion Act of 2004 108-hr-4576 M001138 Rep. Manzullo, Donald A. [R-IL-16] R IL 2004-07-22 0
108-hr-4576,P000555 Food Promotion Act of 2004 108-hr-4576 P000555 Rep. Pryce, Deborah [R-OH-15] R OH 2004-07-15 0
108-hr-4576,L000552 Food Promotion Act of 2004 108-hr-4576 L000552 Rep. LaHood, Ray [R-IL-18] R IL 2004-07-15 0
108-hr-4576,H000636 Food Promotion Act of 2004 108-hr-4576 H000636 Rep. Hinojosa, Ruben [D-TX-15] D TX 2004-06-24 0
108-hr-4576,M000477 Food Promotion Act of 2004 108-hr-4576 M000477 Rep. McInnis, Scott [R-CO-3] R CO 2004-06-24 0
108-hr-4576,K000363 Food Promotion Act of 2004 108-hr-4576 K000363 Rep. Kline, John [R-MN-2] R MN 2004-06-24 0
108-hr-4576,P000587 Food Promotion Act of 2004 108-hr-4576 P000587 Rep. Pence, Mike [R-IN-6] R IN 2004-06-24 0
108-hr-4576,Y000033 Food Promotion Act of 2004 108-hr-4576 Y000033 Rep. Young, Don [R-AK-At Large] R AK 2004-06-24 0
108-hr-4576,O000163 Food Promotion Act of 2004 108-hr-4576 O000163 Rep. Oxley, Michael G. [R-OH-4] R OH 2004-06-24 0
108-hr-4576,B001246 Food Promotion Act of 2004 108-hr-4576 B001246 Rep. Bradley, Jeb [R-NH-1] R NH 2004-06-24 0
108-hr-4576,M000933 Food Promotion Act of 2004 108-hr-4576 M000933 Rep. Moran, James P. [D-VA-8] D VA 2004-06-24 0
108-hr-4576,B000575 Food Promotion Act of 2004 108-hr-4576 B000575 Rep. Blunt, Roy [R-MO-7] R MO 2004-06-24 0
108-hr-4576,P000265 Food Promotion Act of 2004 108-hr-4576 P000265 Rep. Petri, Thomas E. [R-WI-6] R WI 2004-06-24 0
108-hr-4576,R000574 Food Promotion Act of 2004 108-hr-4576 R000574 Rep. Renzi, Rick [R-AZ-1] R AZ 2004-06-24 0
108-hr-4576,S000851 Food Promotion Act of 2004 108-hr-4576 S000851 Rep. Stenholm, Charles W. [D-TX-17] D TX 2004-06-15 1
108-hr-4576,N000182 Food Promotion Act of 2004 108-hr-4576 N000182 Rep. Neugebauer, Randy [R-TX-19] R TX 2004-06-15 1
108-hr-4576,B000617 Food Promotion Act of 2004 108-hr-4576 B000617 Rep. Bonilla, Henry [R-TX-23] R TX 2004-06-15 1
108-hr-4576,B000589 Food Promotion Act of 2004 108-hr-4576 B000589 Rep. Boehner, John A. [R-OH-8] R OH 2004-06-15 1
108-hr-4576,S000597 Food Promotion Act of 2004 108-hr-4576 S000597 Rep. Smith, Nick [R-MI-7] R MI 2004-06-15 1
108-hr-4576,M001152 Food Promotion Act of 2004 108-hr-4576 M001152 Rep. Musgrave, Marilyn N. [R-CO-4] R CO 2004-06-15 1
108-hr-4576,H001029 Food Promotion Act of 2004 108-hr-4576 H001029 Rep. Hayes, Robin [R-NC-8] R NC 2004-06-15 1
108-hr-4576,D000424 Food Promotion Act of 2004 108-hr-4576 D000424 Rep. Dooley, Calvin M. [D-CA-20] D CA 2004-06-15 1
108-hr-4576,O000107 Food Promotion Act of 2004 108-hr-4576 O000107 Rep. Ortiz, Solomon P. [D-TX-27] D TX 2004-06-15 1
108-hr-4576,K000358 Food Promotion Act of 2004 108-hr-4576 K000358 Rep. Kennedy, Mark R. [R-MN-6] R MN 2004-06-15 1
108-hr-4576,P000263 Food Promotion Act of 2004 108-hr-4576 P000263 Rep. Peterson, John E. [R-PA-5] R PA 2004-06-15 1
108-hr-4576,F000030 Food Promotion Act of 2004 108-hr-4576 F000030 Rep. Farr, Sam [D-CA-17] D CA 2004-06-15 1
108-hr-4576,C001052 Food Promotion Act of 2004 108-hr-4576 C001052 Rep. Chocola, Chris [R-IN-2] R IN 2004-06-15 1
108-hr-4576,B000420 Food Promotion Act of 2004 108-hr-4576 B000420 Rep. Berry, Marion [D-AR-1] D AR 2004-06-15 1
108-hr-4576,A000359 Food Promotion Act of 2004 108-hr-4576 A000359 Resident Commissioner Acevedo-Vila, Anibal [D-PR-At Large] D PR 2004-06-15 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);