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

41 rows where bill_id = "108-hr-3604" 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

  • 1 33
  • 0 8
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
108-hr-3604,A000361 Temporary Agricultural Labor Reform Act of 2003 108-hr-3604 A000361 Rep. Alexander, Rodney [D-LA-5] D LA 2004-06-02 0
108-hr-3604,B000104 Temporary Agricultural Labor Reform Act of 2003 108-hr-3604 B000104 Rep. Ballenger, Cass [R-NC-10] R NC 2004-06-02 0
108-hr-3604,M000388 Temporary Agricultural Labor Reform Act of 2003 108-hr-3604 M000388 Rep. McCrery, Jim [R-LA-4] R LA 2004-05-04 0
108-hr-3604,B000490 Temporary Agricultural Labor Reform Act of 2003 108-hr-3604 B000490 Rep. Bishop, Sanford D., Jr. [D-GA-2] D GA 2004-05-04 0
108-hr-3604,L000293 Temporary Agricultural Labor Reform Act of 2003 108-hr-3604 L000293 Rep. Lewis, Ron [R-KY-2] R KY 2004-02-25 0
108-hr-3604,W000413 Temporary Agricultural Labor Reform Act of 2003 108-hr-3604 W000413 Rep. Whitfield, Ed [R-KY-1] R KY 2004-02-25 0
108-hr-3604,I000055 Temporary Agricultural Labor Reform Act of 2003 108-hr-3604 I000055 Rep. Isakson, Johnny [R-GA-6] R GA 2004-02-10 0
108-hr-3604,M001152 Temporary Agricultural Labor Reform Act of 2003 108-hr-3604 M001152 Rep. Musgrave, Marilyn N. [R-CO-4] R CO 2003-12-08 0
108-hr-3604,S000851 Temporary Agricultural Labor Reform Act of 2003 108-hr-3604 S000851 Rep. Stenholm, Charles W. [D-TX-17] D TX 2003-11-21 1
108-hr-3604,L000491 Temporary Agricultural Labor Reform Act of 2003 108-hr-3604 L000491 Rep. Lucas, Frank D. [R-OK-3] R OK 2003-11-21 1
108-hr-3604,G000536 Temporary Agricultural Labor Reform Act of 2003 108-hr-3604 G000536 Rep. Gutknecht, Gil [R-MN-1] R MN 2003-11-21 1
108-hr-3604,B000575 Temporary Agricultural Labor Reform Act of 2003 108-hr-3604 B000575 Rep. Blunt, Roy [R-MO-7] R MO 2003-11-21 1
108-hr-3604,G000021 Temporary Agricultural Labor Reform Act of 2003 108-hr-3604 G000021 Rep. Gallegly, Elton [R-CA-24] R CA 2003-11-21 1
108-hr-3604,O000165 Temporary Agricultural Labor Reform Act of 2003 108-hr-3604 O000165 Rep. Osborne, Tom [R-NE-3] R NE 2003-11-21 1
108-hr-3604,B001249 Temporary Agricultural Labor Reform Act of 2003 108-hr-3604 B001249 Rep. Burns, Max [R-GA-12] R GA 2003-11-21 1
108-hr-3604,C001052 Temporary Agricultural Labor Reform Act of 2003 108-hr-3604 C001052 Rep. Chocola, Chris [R-IN-2] R IN 2003-11-21 1
108-hr-3604,N000182 Temporary Agricultural Labor Reform Act of 2003 108-hr-3604 N000182 Rep. Neugebauer, Randy [R-TX-19] R TX 2003-11-21 1
108-hr-3604,N000051 Temporary Agricultural Labor Reform Act of 2003 108-hr-3604 N000051 Rep. Nethercutt, George R., Jr. [R-WA-5] R WA 2003-11-21 1
108-hr-3604,S000597 Temporary Agricultural Labor Reform Act of 2003 108-hr-3604 S000597 Rep. Smith, Nick [R-MI-7] R MI 2003-11-21 1
108-hr-3604,K000220 Temporary Agricultural Labor Reform Act of 2003 108-hr-3604 K000220 Rep. Kingston, Jack [R-GA-1] R GA 2003-11-21 1
108-hr-3604,B000208 Temporary Agricultural Labor Reform Act of 2003 108-hr-3604 B000208 Rep. Bartlett, Roscoe G. [R-MD-6] R MD 2003-11-21 1
108-hr-3604,B001235 Temporary Agricultural Labor Reform Act of 2003 108-hr-3604 B001235 Rep. Brown, Henry E., Jr. [R-SC-1] R SC 2003-11-21 1
108-hr-3604,U000031 Temporary Agricultural Labor Reform Act of 2003 108-hr-3604 U000031 Rep. Upton, Fred [R-MI-6] R MI 2003-11-21 1
108-hr-3604,C000071 Temporary Agricultural Labor Reform Act of 2003 108-hr-3604 C000071 Rep. Camp, Dave [R-MI-4] R MI 2003-11-21 1
108-hr-3604,Y000033 Temporary Agricultural Labor Reform Act of 2003 108-hr-3604 Y000033 Rep. Young, Don [R-AK-At Large] R AK 2003-11-21 1
108-hr-3604,C000640 Temporary Agricultural Labor Reform Act of 2003 108-hr-3604 C000640 Rep. Collins, Mac [R-GA-8] R GA 2003-11-21 1
108-hr-3604,B000072 Temporary Agricultural Labor Reform Act of 2003 108-hr-3604 B000072 Rep. Baker, Richard H. [R-LA-6] R LA 2003-11-21 1
108-hr-3604,D000597 Temporary Agricultural Labor Reform Act of 2003 108-hr-3604 D000597 Rep. Davis, Jo Ann [R-VA-1] R VA 2003-11-21 1
108-hr-3604,D000533 Temporary Agricultural Labor Reform Act of 2003 108-hr-3604 D000533 Rep. Duncan, John J., Jr. [R-TN-2] R TN 2003-11-21 1
108-hr-3604,F000445 Temporary Agricultural Labor Reform Act of 2003 108-hr-3604 F000445 Rep. Forbes, J. Randy [R-VA-4] R VA 2003-11-21 1
108-hr-3604,G000548 Temporary Agricultural Labor Reform Act of 2003 108-hr-3604 G000548 Rep. Garrett, Scott [R-NJ-5] R NJ 2003-11-21 1
108-hr-3604,H000528 Temporary Agricultural Labor Reform Act of 2003 108-hr-3604 H000528 Rep. Herger, Wally [R-CA-2] R CA 2003-11-21 1
108-hr-3604,H000676 Temporary Agricultural Labor Reform Act of 2003 108-hr-3604 H000676 Rep. Hoekstra, Peter [R-MI-2] R MI 2003-11-21 1
108-hr-3604,J000286 Temporary Agricultural Labor Reform Act of 2003 108-hr-3604 J000286 Rep. Janklow, William J. [R-SD-At Large] R SD 2003-11-21 1
108-hr-3604,J000255 Temporary Agricultural Labor Reform Act of 2003 108-hr-3604 J000255 Rep. Jones, Walter B., Jr. [R-NC-3] R NC 2003-11-21 1
108-hr-3604,K000361 Temporary Agricultural Labor Reform Act of 2003 108-hr-3604 K000361 Rep. Keller, Ric [R-FL-8] R FL 2003-11-21 1
108-hr-3604,M001150 Temporary Agricultural Labor Reform Act of 2003 108-hr-3604 M001150 Rep. Miller, Candice S. [R-MI-10] R MI 2003-11-21 1
108-hr-3604,O000163 Temporary Agricultural Labor Reform Act of 2003 108-hr-3604 O000163 Rep. Oxley, Michael G. [R-OH-4] R OH 2003-11-21 1
108-hr-3604,S001143 Temporary Agricultural Labor Reform Act of 2003 108-hr-3604 S001143 Rep. Souder, Mark E. [R-IN-3] R IN 2003-11-21 1
108-hr-3604,T000462 Temporary Agricultural Labor Reform Act of 2003 108-hr-3604 T000462 Rep. Tiberi, Patrick J. [R-OH-12] R OH 2003-11-21 1
108-hr-3604,W000437 Temporary Agricultural Labor Reform Act of 2003 108-hr-3604 W000437 Rep. Wicker, Roger F. [R-MS-1] R MS 2003-11-21 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);