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

103 rows where bill_id = "112-hr-3548" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: sponsorship_date, sponsorship_date (date)

is_original_cosponsor 2

  • 0 62
  • 1 41
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
112-hr-3548,R000487 North American Energy Access Act 112-hr-3548 R000487 Rep. Royce, Edward R. [R-CA-40] R CA 2012-02-09 0
112-hr-3548,S001187 North American Energy Access Act 112-hr-3548 S001187 Rep. Stivers, Steve [R-OH-15] R OH 2012-02-09 0
112-hr-3548,B001256 North American Energy Access Act 112-hr-3548 B001256 Rep. Bachmann, Michele [R-MN-6] R MN 2012-02-09 0
112-hr-3548,H001036 North American Energy Access Act 112-hr-3548 H001036 Rep. Hensarling, Jeb [R-TX-5] R TX 2012-02-07 0
112-hr-3548,C001047 North American Energy Access Act 112-hr-3548 C001047 Rep. Capito, Shelley Moore [R-WV-2] R WV 2012-02-07 0
112-hr-3548,M001150 North American Energy Access Act 112-hr-3548 M001150 Rep. Miller, Candice S. [R-MI-10] R MI 2012-02-06 0
112-hr-3548,B000013 North American Energy Access Act 112-hr-3548 B000013 Rep. Bachus, Spencer [R-AL-6] R AL 2012-02-06 0
112-hr-3548,M001158 North American Energy Access Act 112-hr-3548 M001158 Rep. Marchant, Kenny [R-TX-24] R TX 2012-02-06 0
112-hr-3548,W000795 North American Energy Access Act 112-hr-3548 W000795 Rep. Wilson, Joe [R-SC-2] R SC 2012-02-06 0
112-hr-3548,H001045 North American Energy Access Act 112-hr-3548 H001045 Rep. Harper, Gregg [R-MS-3] R MS 2012-02-06 0
112-hr-3548,M001155 North American Energy Access Act 112-hr-3548 M001155 Rep. Mack, Connie [R-FL-14] R FL 2012-02-06 0
112-hr-3548,C001075 North American Energy Access Act 112-hr-3548 C001075 Rep. Cassidy, Bill [R-LA-6] R LA 2012-02-06 0
112-hr-3548,B001228 North American Energy Access Act 112-hr-3548 B001228 Rep. Bono Mack, Mary [R-CA-45] R CA 2012-02-06 0
112-hr-3548,C001045 North American Energy Access Act 112-hr-3548 C001045 Rep. Crenshaw, Ander [R-FL-4] R FL 2012-02-06 0
112-hr-3548,C001076 North American Energy Access Act 112-hr-3548 C001076 Rep. Chaffetz, Jason [R-UT-3] R UT 2012-02-06 0
112-hr-3548,N000181 North American Energy Access Act 112-hr-3548 N000181 Rep. Nunes, Devin [R-CA-21] R CA 2012-02-06 0
112-hr-3548,S001148 North American Energy Access Act 112-hr-3548 S001148 Rep. Simpson, Michael K. [R-ID-2] R ID 2012-02-06 0
112-hr-3548,G000549 North American Energy Access Act 112-hr-3548 G000549 Rep. Gerlach, Jim [R-PA-6] R PA 2012-02-06 0
112-hr-3548,S000244 North American Energy Access Act 112-hr-3548 S000244 Rep. Sensenbrenner, F. James, Jr. [R-WI-5] R WI 2012-02-06 0
112-hr-3548,G000546 North American Energy Access Act 112-hr-3548 G000546 Rep. Graves, Sam [R-MO-6] R MO 2012-02-06 0
112-hr-3548,G000567 North American Energy Access Act 112-hr-3548 G000567 Rep. Griffin, Tim [R-AR-2] R AR 2012-02-06 0
112-hr-3548,D000612 North American Energy Access Act 112-hr-3548 D000612 Rep. Denham, Jeff [R-CA-19] R CA 2012-02-06 0
112-hr-3548,C001087 North American Energy Access Act 112-hr-3548 C001087 Rep. Crawford, Eric A. "Rick" [R-AR-1] R AR 2012-02-06 0
112-hr-3548,S001189 North American Energy Access Act 112-hr-3548 S001189 Rep. Scott, Austin [R-GA-8] R GA 2012-02-06 0
112-hr-3548,M001157 North American Energy Access Act 112-hr-3548 M001157 Rep. McCaul, Michael T. [R-TX-10] R TX 2012-02-06 0
112-hr-3548,L000491 North American Energy Access Act 112-hr-3548 L000491 Rep. Lucas, Frank D. [R-OK-3] R OK 2012-02-06 0
112-hr-3548,B001274 North American Energy Access Act 112-hr-3548 B001274 Rep. Brooks, Mo [R-AL-5] R AL 2012-02-06 0
112-hr-3548,H001060 North American Energy Access Act 112-hr-3548 H001060 Rep. Hurt, Robert [R-VA-5] R VA 2012-02-06 0
112-hr-3548,J000289 North American Energy Access Act 112-hr-3548 J000289 Rep. Jordan, Jim [R-OH-4] R OH 2012-02-06 0
112-hr-3548,R000592 North American Energy Access Act 112-hr-3548 R000592 Rep. Rokita, Todd [R-IN-4] R IN 2012-02-06 0
112-hr-3548,M001182 North American Energy Access Act 112-hr-3548 M001182 Rep. Mulvaney, Mick [R-SC-5] R SC 2012-02-06 0
112-hr-3548,G000566 North American Energy Access Act 112-hr-3548 G000566 Rep. Gowdy, Trey [R-SC-4] R SC 2012-02-06 0
112-hr-3548,Y000063 North American Energy Access Act 112-hr-3548 Y000063 Rep. Yoder, Kevin [R-KS-3] R KS 2012-02-06 0
112-hr-3548,C001062 North American Energy Access Act 112-hr-3548 C001062 Rep. Conaway, K. Michael [R-TX-11] R TX 2012-02-02 0
112-hr-3548,C000266 North American Energy Access Act 112-hr-3548 C000266 Rep. Chabot, Steve [R-OH-1] R OH 2012-02-02 0
112-hr-3548,P000265 North American Energy Access Act 112-hr-3548 P000265 Rep. Petri, Thomas E. [R-WI-6] R WI 2012-01-31 0
112-hr-3548,W000796 North American Energy Access Act 112-hr-3548 W000796 Rep. Westmoreland, Lynn A. [R-GA-3] R GA 2012-01-31 0
112-hr-3548,K000210 North American Energy Access Act 112-hr-3548 K000210 Rep. King, Peter T. [R-NY-3] R NY 2012-01-31 0
112-hr-3548,R000580 North American Energy Access Act 112-hr-3548 R000580 Rep. Roskam, Peter J. [R-IL-6] R IL 2012-01-25 0
112-hr-3548,P000592 North American Energy Access Act 112-hr-3548 P000592 Rep. Poe, Ted [R-TX-2] R TX 2012-01-25 0
112-hr-3548,C001082 North American Energy Access Act 112-hr-3548 C001082 Rep. Canseco, Francisco "Quico" [R-TX-23] R TX 2012-01-25 0
112-hr-3548,D000616 North American Energy Access Act 112-hr-3548 D000616 Rep. DesJarlais, Scott [R-TN-4] R TN 2012-01-23 0
112-hr-3548,H001059 North American Energy Access Act 112-hr-3548 H001059 Rep. Hultgren, Randy [R-IL-14] R IL 2012-01-23 0
112-hr-3548,J000292 North American Energy Access Act 112-hr-3548 J000292 Rep. Johnson, Bill [R-OH-6] R OH 2012-01-23 0
112-hr-3548,B001149 North American Energy Access Act 112-hr-3548 B001149 Rep. Burton, Dan [R-IN-5] R IN 2012-01-23 0
112-hr-3548,G000550 North American Energy Access Act 112-hr-3548 G000550 Rep. Gingrey, Phil [R-GA-11] R GA 2012-01-23 0
112-hr-3548,P000601 North American Energy Access Act 112-hr-3548 P000601 Rep. Palazzo, Steven M. [R-MS-4] R MS 2012-01-23 0
112-hr-3548,M001177 North American Energy Access Act 112-hr-3548 M001177 Rep. McClintock, Tom [R-CA-4] R CA 2012-01-23 0
112-hr-3548,F000458 North American Energy Access Act 112-hr-3548 F000458 Rep. Fincher, Stephen Lee [R-TN-8] R TN 2012-01-23 0
112-hr-3548,C001053 North American Energy Access Act 112-hr-3548 C001053 Rep. Cole, Tom [R-OK-4] R OK 2012-01-23 0
112-hr-3548,L000575 North American Energy Access Act 112-hr-3548 L000575 Rep. Lankford, James [R-OK-5] R OK 2011-12-14 0
112-hr-3548,L000576 North American Energy Access Act 112-hr-3548 L000576 Rep. Long, Billy [R-MO-7] R MO 2011-12-13 0
112-hr-3548,B001262 North American Energy Access Act 112-hr-3548 B001262 Rep. Broun, Paul C. [R-GA-10] R GA 2011-12-08 0
112-hr-3548,F000461 North American Energy Access Act 112-hr-3548 F000461 Rep. Flores, Bill [R-TX-17] R TX 2011-12-08 0
112-hr-3548,L000564 North American Energy Access Act 112-hr-3548 L000564 Rep. Lamborn, Doug [R-CO-5] R CO 2011-12-08 0
112-hr-3548,W000791 North American Energy Access Act 112-hr-3548 W000791 Rep. Walden, Greg [R-OR-2] R OR 2011-12-08 0
112-hr-3548,C000556 North American Energy Access Act 112-hr-3548 C000556 Rep. Coble, Howard [R-NC-6] R NC 2011-12-06 0
112-hr-3548,E000291 North American Energy Access Act 112-hr-3548 E000291 Rep. Ellmers, Renee L. [R-NC-2] R NC 2011-12-05 0
112-hr-3548,G000558 North American Energy Access Act 112-hr-3548 G000558 Rep. Guthrie, Brett [R-KY-2] R KY 2011-12-05 0
112-hr-3548,H001058 North American Energy Access Act 112-hr-3548 H001058 Rep. Huizenga, Bill [R-MI-2] R MI 2011-12-05 0
112-hr-3548,M001180 North American Energy Access Act 112-hr-3548 M001180 Rep. McKinley, David B. [R-WV-1] R WV 2011-12-05 0
112-hr-3548,C001077 North American Energy Access Act 112-hr-3548 C001077 Rep. Coffman, Mike [R-CO-6] R CO 2011-12-05 0
112-hr-3548,U000031 North American Energy Access Act 112-hr-3548 U000031 Rep. Upton, Fred [R-MI-6] R MI 2011-12-02 1
112-hr-3548,W000413 North American Energy Access Act 112-hr-3548 W000413 Rep. Whitfield, Ed [R-KY-1] R KY 2011-12-02 1
112-hr-3548,B001243 North American Energy Access Act 112-hr-3548 B001243 Rep. Blackburn, Marsha [R-TN-7] R TN 2011-12-02 1
112-hr-3548,L000566 North American Energy Access Act 112-hr-3548 L000566 Rep. Latta, Robert E. [R-OH-5] R OH 2011-12-02 1
112-hr-3548,M001151 North American Energy Access Act 112-hr-3548 M001151 Rep. Murphy, Tim [R-PA-18] R PA 2011-12-02 1
112-hr-3548,M001159 North American Energy Access Act 112-hr-3548 M001159 Rep. McMorris Rodgers, Cathy [R-WA-5] R WA 2011-12-02 1
112-hr-3548,R000571 North American Energy Access Act 112-hr-3548 R000571 Rep. Rehberg, Denny [R-MT-At Large] R MT 2011-12-02 1
112-hr-3548,B001272 North American Energy Access Act 112-hr-3548 B001272 Rep. Berg, Rick [R-ND-At Large] R ND 2011-12-02 1
112-hr-3548,H001052 North American Energy Access Act 112-hr-3548 H001052 Rep. Harris, Andy [R-MD-1] R MD 2011-12-02 1
112-hr-3548,P000373 North American Energy Access Act 112-hr-3548 P000373 Rep. Pitts, Joseph R. [R-PA-16] R PA 2011-12-02 1
112-hr-3548,S001155 North American Energy Access Act 112-hr-3548 S001155 Rep. Sullivan, John [R-OK-1] R OK 2011-12-02 1
112-hr-3548,S000364 North American Energy Access Act 112-hr-3548 S000364 Rep. Shimkus, John [R-IL-19] R IL 2011-12-02 1
112-hr-3548,S001176 North American Energy Access Act 112-hr-3548 S001176 Rep. Scalise, Steve [R-LA-1] R LA 2011-12-02 1
112-hr-3548,O000168 North American Energy Access Act 112-hr-3548 O000168 Rep. Olson, Pete [R-TX-22] R TX 2011-12-02 1
112-hr-3548,G000562 North American Energy Access Act 112-hr-3548 G000562 Rep. Gardner, Cory [R-CO-4] R CO 2011-12-02 1
112-hr-3548,P000602 North American Energy Access Act 112-hr-3548 P000602 Rep. Pompeo, Mike [R-KS-4] R KS 2011-12-02 1
112-hr-3548,K000378 North American Energy Access Act 112-hr-3548 K000378 Rep. Kinzinger, Adam [R-IL-11] R IL 2011-12-02 1
112-hr-3548,B001255 North American Energy Access Act 112-hr-3548 B001255 Rep. Boustany, Charles W., Jr. [R-LA-7] R LA 2011-12-02 1
112-hr-3548,G000569 North American Energy Access Act 112-hr-3548 G000569 Rep. Grimm, Michael G. [R-NY-13] R NY 2011-12-02 1
112-hr-3548,B001248 North American Energy Access Act 112-hr-3548 B001248 Rep. Burgess, Michael C. [R-TX-26] R TX 2011-12-02 1
112-hr-3548,T000238 North American Energy Access Act 112-hr-3548 T000238 Rep. Thornberry, Mac [R-TX-13] R TX 2011-12-02 1
112-hr-3548,C001051 North American Energy Access Act 112-hr-3548 C001051 Rep. Carter, John R. [R-TX-31] R TX 2011-12-02 1
112-hr-3548,N000182 North American Energy Access Act 112-hr-3548 N000182 Rep. Neugebauer, Randy [R-TX-19] R TX 2011-12-02 1
112-hr-3548,G000377 North American Energy Access Act 112-hr-3548 G000377 Rep. Granger, Kay [R-TX-12] R TX 2011-12-02 1
112-hr-3548,C001048 North American Energy Access Act 112-hr-3548 C001048 Rep. Culberson, John Abney [R-TX-7] R TX 2011-12-02 1
112-hr-3548,J000174 North American Energy Access Act 112-hr-3548 J000174 Rep. Johnson, Sam [R-TX-3] R TX 2011-12-02 1
112-hr-3548,B001269 North American Energy Access Act 112-hr-3548 B001269 Rep. Barletta, Lou [R-PA-11] R PA 2011-12-02 1
112-hr-3548,M001179 North American Energy Access Act 112-hr-3548 M001179 Rep. Marino, Tom [R-PA-10] R PA 2011-12-02 1
112-hr-3548,K000376 North American Energy Access Act 112-hr-3548 K000376 Rep. Kelly, Mike [R-PA-3] R PA 2011-12-02 1
112-hr-3548,S001179 North American Energy Access Act 112-hr-3548 S001179 Rep. Schock, Aaron [R-IL-18] R IL 2011-12-02 1
112-hr-3548,L000553 North American Energy Access Act 112-hr-3548 L000553 Rep. LaTourette, Steven C. [R-OH-14] R OH 2011-12-02 1
112-hr-3548,M001147 North American Energy Access Act 112-hr-3548 M001147 Rep. McCotter, Thaddeus G. [R-MI-11] R MI 2011-12-02 1
112-hr-3548,D000603 North American Energy Access Act 112-hr-3548 D000603 Rep. Davis, Geoff [R-KY-4] R KY 2011-12-02 1
112-hr-3548,T000463 North American Energy Access Act 112-hr-3548 T000463 Rep. Turner, Michael R. [R-OH-3] R OH 2011-12-02 1
112-hr-3548,P000588 North American Energy Access Act 112-hr-3548 P000588 Rep. Pearce, Stevan [R-NM-2] R NM 2011-12-02 1
112-hr-3548,G000563 North American Energy Access Act 112-hr-3548 G000563 Rep. Gibbs, Bob [R-OH-18] R OH 2011-12-02 1
112-hr-3548,M001144 North American Energy Access Act 112-hr-3548 M001144 Rep. Miller, Jeff [R-FL-1] R FL 2011-12-02 1
112-hr-3548,F000445 North American Energy Access Act 112-hr-3548 F000445 Rep. Forbes, J. Randy [R-VA-4] R VA 2011-12-02 1

Next page

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 33.943ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API