home / openregs

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

68 rows where bill_id = "113-hr-5071" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party, sponsorship_date, sponsorship_date (date)

is_original_cosponsor 2

  • 0 62
  • 1 6
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
113-hr-5071,K000363 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 K000363 Rep. Kline, John [R-MN-2] R MN 2014-09-19 0
113-hr-5071,M001149 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 M001149 Rep. Michaud, Michael H. [D-ME-2] D ME 2014-09-18 0
113-hr-5071,D000618 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 D000618 Rep. Daines, Steve [R-MT-At Large] R MT 2014-09-18 0
113-hr-5071,L000565 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 L000565 Rep. Loebsack, David [D-IA-2] D IA 2014-09-17 0
113-hr-5071,K000188 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 K000188 Rep. Kind, Ron [D-WI-3] D WI 2014-09-16 0
113-hr-5071,D000612 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 D000612 Rep. Denham, Jeff [R-CA-10] R CA 2014-09-16 0
113-hr-5071,S000937 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 S000937 Rep. Stockman, Steve [R-TX-36] R TX 2014-09-16 0
113-hr-5071,M001190 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 M001190 Rep. Mullin, Markwayne [R-OK-2] R OK 2014-09-11 0
113-hr-5071,K000362 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 K000362 Rep. King, Steve [R-IA-4] R IA 2014-09-11 0
113-hr-5071,B001259 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 B001259 Rep. Braley, Bruce L. [D-IA-1] D IA 2014-09-10 0
113-hr-5071,L000578 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 L000578 Rep. LaMalfa, Doug [R-CA-1] R CA 2014-09-10 0
113-hr-5071,C001059 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 C001059 Rep. Costa, Jim [D-CA-16] D CA 2014-09-10 0
113-hr-5071,B001289 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 B001289 Rep. Byrne, Bradley [R-AL-1] R AL 2014-09-09 0
113-hr-5071,N000184 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 N000184 Rep. Noem, Kristi L. [R-SD-At Large] R SD 2014-09-09 0
113-hr-5071,D000617 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 D000617 Rep. DelBene, Suzan K. [D-WA-1] D WA 2014-09-09 0
113-hr-5071,C001093 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 C001093 Rep. Collins, Doug [R-GA-9] R GA 2014-09-08 0
113-hr-5071,M001185 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 M001185 Rep. Maloney, Sean Patrick [D-NY-18] D NY 2014-09-08 0
113-hr-5071,M001179 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 M001179 Rep. Marino, Tom [R-PA-10] R PA 2014-09-08 0
113-hr-5071,M000485 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 M000485 Rep. McIntyre, Mike [D-NC-7] D NC 2014-09-08 0
113-hr-5071,S001189 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 S001189 Rep. Scott, Austin [R-GA-8] R GA 2014-09-08 0
113-hr-5071,T000459 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 T000459 Rep. Terry, Lee [R-NE-2] R NE 2014-09-08 0
113-hr-5071,R000598 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 R000598 Rep. Rothfus, Keith J. [R-PA-12] R PA 2014-08-01 0
113-hr-5071,S001195 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 S001195 Rep. Smith, Jason [R-MO-8] R MO 2014-08-01 0
113-hr-5071,W000809 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 W000809 Rep. Womack, Steve [R-AR-3] R AR 2014-07-31 0
113-hr-5071,H001053 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 H001053 Rep. Hartzler, Vicky [R-MO-4] R MO 2014-07-31 0
113-hr-5071,S000244 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 S000244 Rep. Sensenbrenner, F. James, Jr. [R-WI-5] R WI 2014-07-31 0
113-hr-5071,S001187 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 S001187 Rep. Stivers, Steve [R-OH-15] R OH 2014-07-31 0
113-hr-5071,L000571 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 L000571 Rep. Lummis, Cynthia M. [R-WY-At Large] R WY 2014-07-31 0
113-hr-5071,G000550 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 G000550 Rep. Gingrey, Phil [R-GA-11] R GA 2014-07-31 0
113-hr-5071,N000182 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 N000182 Rep. Neugebauer, Randy [R-TX-19] R TX 2014-07-31 0
113-hr-5071,B001283 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 B001283 Rep. Bridenstine, Jim [R-OK-1] R OK 2014-07-30 0
113-hr-5071,C001053 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 C001053 Rep. Cole, Tom [R-OK-4] R OK 2014-07-29 0
113-hr-5071,T000470 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 T000470 Rep. Tipton, Scott R. [R-CO-3] R CO 2014-07-29 0
113-hr-5071,N000186 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 N000186 Rep. Nunnelee, Alan [R-MS-1] R MS 2014-07-29 0
113-hr-5071,L000576 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 L000576 Rep. Long, Billy [R-MO-7] R MO 2014-07-29 0
113-hr-5071,H000329 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 H000329 Rep. Hastings, Doc [R-WA-4] R WA 2014-07-29 0
113-hr-5071,V000129 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 V000129 Rep. Valadao, David G. [R-CA-21] R CA 2014-07-29 0
113-hr-5071,D000614 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 D000614 Rep. Duffy, Sean P. [R-WI-7] R WI 2014-07-28 0
113-hr-5071,G000567 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 G000567 Rep. Griffin, Tim [R-AR-2] R AR 2014-07-28 0
113-hr-5071,M001182 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 M001182 Rep. Mulvaney, Mick [R-SC-5] R SC 2014-07-28 0
113-hr-5071,B000490 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 B000490 Rep. Bishop, Sanford D., Jr. [D-GA-2] D GA 2014-07-28 0
113-hr-5071,C001096 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 C001096 Rep. Cramer, Kevin [R-ND-At Large] R ND 2014-07-28 0
113-hr-5071,P000588 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 P000588 Rep. Pearce, Stevan [R-NM-2] R NM 2014-07-28 0
113-hr-5071,N000181 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 N000181 Rep. Nunes, Devin [R-CA-22] R CA 2014-07-25 0
113-hr-5071,P000265 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 P000265 Rep. Petri, Thomas E. [R-WI-6] R WI 2014-07-25 0
113-hr-5071,B001271 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 B001271 Rep. Benishek, Dan [R-MI-1] R MI 2014-07-24 0
113-hr-5071,D000619 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 D000619 Rep. Davis, Rodney [R-IL-13] R IL 2014-07-24 0
113-hr-5071,P000592 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 P000592 Rep. Poe, Ted [R-TX-2] R TX 2014-07-24 0
113-hr-5071,C001062 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 C001062 Rep. Conaway, K. Michael [R-TX-11] R TX 2014-07-24 0
113-hr-5071,S001186 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 S001186 Rep. Southerland, Steve II [R-FL-2] R FL 2014-07-24 0
113-hr-5071,E000292 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 E000292 Rep. Enyart, William L. [D-IL-12] D IL 2014-07-23 0
113-hr-5071,C000556 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 C000556 Rep. Coble, Howard [R-NC-6] R NC 2014-07-23 0
113-hr-5071,L000566 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 L000566 Rep. Latta, Robert E. [R-OH-5] R OH 2014-07-23 0
113-hr-5071,O000169 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 O000169 Rep. Owens, William L. [D-NY-21] D NY 2014-07-23 0
113-hr-5071,P000602 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 P000602 Rep. Pompeo, Mike [R-KS-4] R KS 2014-07-23 0
113-hr-5071,K000376 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 K000376 Rep. Kelly, Mike [R-PA-3] R PA 2014-07-23 0
113-hr-5071,S001148 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 S001148 Rep. Simpson, Michael K. [R-ID-2] R ID 2014-07-23 0
113-hr-5071,G000546 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 G000546 Rep. Graves, Sam [R-MO-6] R MO 2014-07-23 0
113-hr-5071,H001051 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 H001051 Rep. Hanna, Richard L. [R-NY-22] R NY 2014-07-22 0
113-hr-5071,J000255 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 J000255 Rep. Jones, Walter B., Jr. [R-NC-3] R NC 2014-07-22 0
113-hr-5071,C001087 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 C001087 Rep. Crawford, Eric A. "Rick" [R-AR-1] R AR 2014-07-22 0
113-hr-5071,R000011 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 R000011 Rep. Rahall, Nick J., II [D-WV-3] D WV 2014-07-22 0
113-hr-5071,S001180 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 S001180 Rep. Schrader, Kurt [D-OR-5] D OR 2014-07-10 1
113-hr-5071,C001092 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 C001092 Rep. Collins, Chris [R-NY-27] R NY 2014-07-10 1
113-hr-5071,T000467 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 T000467 Rep. Thompson, Glenn [R-PA-5] R PA 2014-07-10 1
113-hr-5071,G000563 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 G000563 Rep. Gibbs, Bob [R-OH-7] R OH 2014-07-10 1
113-hr-5071,L000491 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 L000491 Rep. Lucas, Frank D. [R-OK-3] R OK 2014-07-10 1
113-hr-5071,P000258 Agricultural Conservation Flexibility Act of 2014 113-hr-5071 P000258 Rep. Peterson, Collin C. [D-MN-7] D MN 2014-07-10 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);
Powered by Datasette · Queries took 7.263ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API