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

56 rows where bill_id = "111-hr-4785" 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 53
  • 1 3
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
111-hr-4785,S001174 Rural Energy Savings Program Act 111-hr-4785 S001174 Rep. Sutton, Betty [D-OH-13] D OH 2010-09-14 0
111-hr-4785,W000800 Rural Energy Savings Program Act 111-hr-4785 W000800 Rep. Welch, Peter [D-VT-At Large] D VT 2010-07-29 0
111-hr-4785,S001179 Rural Energy Savings Program Act 111-hr-4785 S001179 Rep. Schock, Aaron [R-IL-18] R IL 2010-07-28 0
111-hr-4785,T000326 Rural Energy Savings Program Act 111-hr-4785 T000326 Rep. Towns, Edolphus [D-NY-10] D NY 2010-06-25 0
111-hr-4785,C001060 Rural Energy Savings Program Act 111-hr-4785 C001060 Rep. Carnahan, Russ [D-MO-3] D MO 2010-06-17 0
111-hr-4785,D000096 Rural Energy Savings Program Act 111-hr-4785 D000096 Rep. Davis, Danny K. [D-IL-7] D IL 2010-06-10 0
111-hr-4785,H000324 Rural Energy Savings Program Act 111-hr-4785 H000324 Rep. Hastings, Alcee L. [D-FL-23] D FL 2010-06-10 0
111-hr-4785,M000485 Rural Energy Savings Program Act 111-hr-4785 M000485 Rep. McIntyre, Mike [D-NC-7] D NC 2010-06-10 0
111-hr-4785,D000355 Rural Energy Savings Program Act 111-hr-4785 D000355 Rep. Dingell, John D. [D-MI-15] D MI 2010-05-28 0
111-hr-4785,P000523 Rural Energy Savings Program Act 111-hr-4785 P000523 Rep. Price, David E. [D-NC-4] D NC 2010-05-19 0
111-hr-4785,K000371 Rural Energy Savings Program Act 111-hr-4785 K000371 Rep. Kratovil, Frank, Jr. [D-MD-1] D MD 2010-05-19 0
111-hr-4785,T000467 Rural Energy Savings Program Act 111-hr-4785 T000467 Rep. Thompson, Glenn [R-PA-5] R PA 2010-05-19 0
111-hr-4785,B000574 Rural Energy Savings Program Act 111-hr-4785 B000574 Rep. Blumenauer, Earl [D-OR-3] D OR 2010-05-19 0
111-hr-4785,G000558 Rural Energy Savings Program Act 111-hr-4785 G000558 Rep. Guthrie, Brett [R-KY-2] R KY 2010-05-12 0
111-hr-4785,P000585 Rural Energy Savings Program Act 111-hr-4785 P000585 Rep. Platts, Todd Russell [R-PA-19] R PA 2010-05-11 0
111-hr-4785,R000573 Rural Energy Savings Program Act 111-hr-4785 R000573 Rep. Ross, Mike [D-AR-4] D AR 2010-05-11 0
111-hr-4785,B001263 Rural Energy Savings Program Act 111-hr-4785 B001263 Rep. Boccieri, John A. [D-OH-16] D OH 2010-05-11 0
111-hr-4785,H001042 Rural Energy Savings Program Act 111-hr-4785 H001042 Rep. Hirono, Mazie K. [D-HI-2] D HI 2010-05-05 0
111-hr-4785,L000570 Rural Energy Savings Program Act 111-hr-4785 L000570 Rep. Lujan, Ben Ray [D-NM-3] D NM 2010-05-05 0
111-hr-4785,S001173 Rural Energy Savings Program Act 111-hr-4785 S001173 Rep. Space, Zachary T. [D-OH-18] D OH 2010-05-05 0
111-hr-4785,H001040 Rural Energy Savings Program Act 111-hr-4785 H001040 Rep. Hare, Phil [D-IL-17] D IL 2010-05-05 0
111-hr-4785,S001158 Rural Energy Savings Program Act 111-hr-4785 S001158 Rep. Salazar, John T. [D-CO-3] D CO 2010-05-04 0
111-hr-4785,K000369 Rural Energy Savings Program Act 111-hr-4785 K000369 Rep. Kissell, Larry [D-NC-8] D NC 2010-05-04 0
111-hr-4785,B001236 Rural Energy Savings Program Act 111-hr-4785 B001236 Rep. Boozman, John [R-AR-3] R AR 2010-05-04 0
111-hr-4785,M001140 Rural Energy Savings Program Act 111-hr-4785 M001140 Rep. Moore, Dennis [D-KS-3] D KS 2010-05-04 0
111-hr-4785,W000801 Rural Energy Savings Program Act 111-hr-4785 W000801 Rep. Wilson, Charles A. [D-OH-6] D OH 2010-05-04 0
111-hr-4785,B000657 Rural Energy Savings Program Act 111-hr-4785 B000657 Rep. Boucher, Rick [D-VA-9] D VA 2010-05-04 0
111-hr-4785,R000568 Rural Energy Savings Program Act 111-hr-4785 R000568 Rep. Rodriguez, Ciro D. [D-TX-23] D TX 2010-05-04 0
111-hr-4785,H001030 Rural Energy Savings Program Act 111-hr-4785 H001030 Rep. Hill, Baron P. [D-IN-9] D IN 2010-04-29 0
111-hr-4785,B000652 Rural Energy Savings Program Act 111-hr-4785 B000652 Rep. Boswell, Leonard L. [D-IA-3] D IA 2010-04-26 0
111-hr-4785,R000575 Rural Energy Savings Program Act 111-hr-4785 R000575 Rep. Rogers, Mike D. [R-AL-3] R AL 2010-04-26 0
111-hr-4785,T000193 Rural Energy Savings Program Act 111-hr-4785 T000193 Rep. Thompson, Bennie G. [D-MS-2] D MS 2010-04-26 0
111-hr-4785,R000395 Rural Energy Savings Program Act 111-hr-4785 R000395 Rep. Rogers, Harold [R-KY-5] R KY 2010-04-26 0
111-hr-4785,W000799 Rural Energy Savings Program Act 111-hr-4785 W000799 Rep. Walz, Timothy J. [D-MN-1] D MN 2010-04-22 0
111-hr-4785,B000490 Rural Energy Savings Program Act 111-hr-4785 B000490 Rep. Bishop, Sanford D., Jr. [D-GA-2] D GA 2010-04-22 0
111-hr-4785,G000554 Rural Energy Savings Program Act 111-hr-4785 G000554 Rep. Giffords, Gabrielle [D-AZ-8] D AZ 2010-04-22 0
111-hr-4785,B001264 Rural Energy Savings Program Act 111-hr-4785 B001264 Rep. Bright, Bobby [D-AL-2] D AL 2010-04-20 0
111-hr-4785,B001251 Rural Energy Savings Program Act 111-hr-4785 B001251 Rep. Butterfield, G. K. [D-NC-1] D NC 2010-04-20 0
111-hr-4785,M001146 Rural Energy Savings Program Act 111-hr-4785 M001146 Rep. Marshall, Jim [D-GA-8] D GA 2010-04-20 0
111-hr-4785,R000582 Rural Energy Savings Program Act 111-hr-4785 R000582 Rep. Roe, David P. [R-TN-1] R TN 2010-04-20 0
111-hr-4785,H001037 Rural Energy Savings Program Act 111-hr-4785 H001037 Rep. Herseth Sandlin, Stephanie [D-SD-At Large] D SD 2010-04-20 0
111-hr-4785,C001058 Rural Energy Savings Program Act 111-hr-4785 C001058 Rep. Chandler, Ben [D-KY-6] D KY 2010-04-20 0
111-hr-4785,F000116 Rural Energy Savings Program Act 111-hr-4785 F000116 Rep. Filner, Bob [D-CA-51] D CA 2010-04-20 0
111-hr-4785,E000289 Rural Energy Savings Program Act 111-hr-4785 E000289 Rep. Ellsworth, Brad [D-IN-8] D IN 2010-04-20 0
111-hr-4785,C001063 Rural Energy Savings Program Act 111-hr-4785 C001063 Rep. Cuellar, Henry [D-TX-28] D TX 2010-04-20 0
111-hr-4785,J000288 Rural Energy Savings Program Act 111-hr-4785 J000288 Rep. Johnson, Henry C. "Hank," Jr. [D-GA-4] D GA 2010-04-14 0
111-hr-4785,G000309 Rural Energy Savings Program Act 111-hr-4785 G000309 Rep. Gordon, Bart [D-TN-6] D TN 2010-04-14 0
111-hr-4785,P000099 Rural Energy Savings Program Act 111-hr-4785 P000099 Rep. Pastor, Ed [D-AZ-4] D AZ 2010-04-14 0
111-hr-4785,M001172 Rural Energy Savings Program Act 111-hr-4785 M001172 Rep. Markey, Betsy [D-CO-4] D CO 2010-04-14 0
111-hr-4785,I000023 Rural Energy Savings Program Act 111-hr-4785 I000023 Rep. Inglis, Bob [R-SC-4] R SC 2010-03-19 0
111-hr-4785,S001045 Rural Energy Savings Program Act 111-hr-4785 S001045 Rep. Stupak, Bart [D-MI-1] D MI 2010-03-19 0
111-hr-4785,B001235 Rural Energy Savings Program Act 111-hr-4785 B001235 Rep. Brown, Henry E., Jr. [R-SC-1] R SC 2010-03-12 0
111-hr-4785,W000795 Rural Energy Savings Program Act 111-hr-4785 W000795 Rep. Wilson, Joe [R-SC-2] R SC 2010-03-12 0
111-hr-4785,W000413 Rural Energy Savings Program Act 111-hr-4785 W000413 Rep. Whitfield, Ed [R-KY-1] R KY 2010-03-09 1
111-hr-4785,P000600 Rural Energy Savings Program Act 111-hr-4785 P000600 Rep. Perriello, Thomas S.P. [D-VA-5] D VA 2010-03-09 1
111-hr-4785,S000749 Rural Energy Savings Program Act 111-hr-4785 S000749 Rep. Spratt, John M., Jr. [D-SC-5] D SC 2010-03-09 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);