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

20 rows where bill_id = "110-s-3538" 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 15
  • 0 5
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
110-s-3538,I000055 A bill to amend the Food, Conservation, and Energy Act of 2008 to suspend a prohibition on payments to certain farms with limited base acres for the 2008 and 2009 crop years, to extend the signup for direct payments and counter-cyclical payments for the 2008 crop year, and for other purposes. 110-s-3538 I000055 Sen. Isakson, Johnny [R-GA] R GA 2008-09-25 0
110-s-3538,C001071 A bill to amend the Food, Conservation, and Energy Act of 2008 to suspend a prohibition on payments to certain farms with limited base acres for the 2008 and 2009 crop years, to extend the signup for direct payments and counter-cyclical payments for the 2008 crop year, and for other purposes. 110-s-3538 C001071 Sen. Corker, Bob [R-TN] R TN 2008-09-24 0
110-s-3538,L000035 A bill to amend the Food, Conservation, and Energy Act of 2008 to suspend a prohibition on payments to certain farms with limited base acres for the 2008 and 2009 crop years, to extend the signup for direct payments and counter-cyclical payments for the 2008 crop year, and for other purposes. 110-s-3538 L000035 Sen. Lincoln, Blanche L. [D-AR] D AR 2008-09-24 0
110-s-3538,N000180 A bill to amend the Food, Conservation, and Energy Act of 2008 to suspend a prohibition on payments to certain farms with limited base acres for the 2008 and 2009 crop years, to extend the signup for direct payments and counter-cyclical payments for the 2008 crop year, and for other purposes. 110-s-3538 N000180 Sen. Nelson, Ben [D-NE] D NE 2008-09-24 0
110-s-3538,R000307 A bill to amend the Food, Conservation, and Energy Act of 2008 to suspend a prohibition on payments to certain farms with limited base acres for the 2008 and 2009 crop years, to extend the signup for direct payments and counter-cyclical payments for the 2008 crop year, and for other purposes. 110-s-3538 R000307 Sen. Roberts, Pat [R-KS] R KS 2008-09-24 0
110-s-3538,H000206 A bill to amend the Food, Conservation, and Energy Act of 2008 to suspend a prohibition on payments to certain farms with limited base acres for the 2008 and 2009 crop years, to extend the signup for direct payments and counter-cyclical payments for the 2008 crop year, and for other purposes. 110-s-3538 H000206 Sen. Harkin, Tom [D-IA] D IA 2008-09-23 1
110-s-3538,C000286 A bill to amend the Food, Conservation, and Energy Act of 2008 to suspend a prohibition on payments to certain farms with limited base acres for the 2008 and 2009 crop years, to extend the signup for direct payments and counter-cyclical payments for the 2008 crop year, and for other purposes. 110-s-3538 C000286 Sen. Chambliss, Saxby [R-GA] R GA 2008-09-23 1
110-s-3538,K000305 A bill to amend the Food, Conservation, and Energy Act of 2008 to suspend a prohibition on payments to certain farms with limited base acres for the 2008 and 2009 crop years, to extend the signup for direct payments and counter-cyclical payments for the 2008 crop year, and for other purposes. 110-s-3538 K000305 Sen. Kohl, Herb [D-WI] D WI 2008-09-23 1
110-s-3538,C001070 A bill to amend the Food, Conservation, and Energy Act of 2008 to suspend a prohibition on payments to certain farms with limited base acres for the 2008 and 2009 crop years, to extend the signup for direct payments and counter-cyclical payments for the 2008 crop year, and for other purposes. 110-s-3538 C001070 Sen. Casey, Robert P., Jr. [D-PA] D PA 2008-09-23 1
110-s-3538,F000061 A bill to amend the Food, Conservation, and Energy Act of 2008 to suspend a prohibition on payments to certain farms with limited base acres for the 2008 and 2009 crop years, to extend the signup for direct payments and counter-cyclical payments for the 2008 crop year, and for other purposes. 110-s-3538 F000061 Sen. Feingold, Russell D. [D-WI] D WI 2008-09-23 1
110-s-3538,L000174 A bill to amend the Food, Conservation, and Energy Act of 2008 to suspend a prohibition on payments to certain farms with limited base acres for the 2008 and 2009 crop years, to extend the signup for direct payments and counter-cyclical payments for the 2008 crop year, and for other purposes. 110-s-3538 L000174 Sen. Leahy, Patrick J. [D-VT] D VT 2008-09-23 1
110-s-3538,C000858 A bill to amend the Food, Conservation, and Energy Act of 2008 to suspend a prohibition on payments to certain farms with limited base acres for the 2008 and 2009 crop years, to extend the signup for direct payments and counter-cyclical payments for the 2008 crop year, and for other purposes. 110-s-3538 C000858 Sen. Craig, Larry E. [R-ID] R ID 2008-09-23 1
110-s-3538,B000944 A bill to amend the Food, Conservation, and Energy Act of 2008 to suspend a prohibition on payments to certain farms with limited base acres for the 2008 and 2009 crop years, to extend the signup for direct payments and counter-cyclical payments for the 2008 crop year, and for other purposes. 110-s-3538 B000944 Sen. Brown, Sherrod [D-OH] D OH 2008-09-23 1
110-s-3538,S000770 A bill to amend the Food, Conservation, and Energy Act of 2008 to suspend a prohibition on payments to certain farms with limited base acres for the 2008 and 2009 crop years, to extend the signup for direct payments and counter-cyclical payments for the 2008 crop year, and for other purposes. 110-s-3538 S000770 Sen. Stabenow, Debbie [D-MI] D MI 2008-09-23 1
110-s-3538,C000880 A bill to amend the Food, Conservation, and Energy Act of 2008 to suspend a prohibition on payments to certain farms with limited base acres for the 2008 and 2009 crop years, to extend the signup for direct payments and counter-cyclical payments for the 2008 crop year, and for other purposes. 110-s-3538 C000880 Sen. Crapo, Mike [R-ID] R ID 2008-09-23 1
110-s-3538,C001057 A bill to amend the Food, Conservation, and Energy Act of 2008 to suspend a prohibition on payments to certain farms with limited base acres for the 2008 and 2009 crop years, to extend the signup for direct payments and counter-cyclical payments for the 2008 crop year, and for other purposes. 110-s-3538 C001057 Sen. Coleman, Norm [R-MN] R MN 2008-09-23 1
110-s-3538,C001035 A bill to amend the Food, Conservation, and Energy Act of 2008 to suspend a prohibition on payments to certain farms with limited base acres for the 2008 and 2009 crop years, to extend the signup for direct payments and counter-cyclical payments for the 2008 crop year, and for other purposes. 110-s-3538 C001035 Sen. Collins, Susan M. [R-ME] R ME 2008-09-23 1
110-s-3538,C001041 A bill to amend the Food, Conservation, and Energy Act of 2008 to suspend a prohibition on payments to certain farms with limited base acres for the 2008 and 2009 crop years, to extend the signup for direct payments and counter-cyclical payments for the 2008 crop year, and for other purposes. 110-s-3538 C001041 Sen. Clinton, Hillary Rodham [D-NY] D NY 2008-09-23 1
110-s-3538,D000601 A bill to amend the Food, Conservation, and Energy Act of 2008 to suspend a prohibition on payments to certain farms with limited base acres for the 2008 and 2009 crop years, to extend the signup for direct payments and counter-cyclical payments for the 2008 crop year, and for other purposes. 110-s-3538 D000601 Sen. Dole, Elizabeth [R-NC] R NC 2008-09-23 1
110-s-3538,B000243 A bill to amend the Food, Conservation, and Energy Act of 2008 to suspend a prohibition on payments to certain farms with limited base acres for the 2008 and 2009 crop years, to extend the signup for direct payments and counter-cyclical payments for the 2008 crop year, and for other purposes. 110-s-3538 B000243 Sen. Baucus, Max [D-MT] D MT 2008-09-23 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);