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

65 rows where bill_id = "108-hr-3191" 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 12
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
108-hr-3191,E000268 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 E000268 Rep. Everett, Terry [R-AL-2] R AL 2004-04-27 0
108-hr-3191,C000116 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 C000116 Rep. Cannon, Chris [R-UT-3] R UT 2004-04-02 0
108-hr-3191,P000585 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 P000585 Rep. Platts, Todd Russell [R-PA-19] R PA 2004-02-04 0
108-hr-3191,D000595 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 D000595 Rep. DeMint, Jim [R-SC-4] R SC 2004-02-04 0
108-hr-3191,D000168 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 D000168 Rep. Deal, Nathan [R-GA-10] R GA 2004-01-27 0
108-hr-3191,G000021 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 G000021 Rep. Gallegly, Elton [R-CA-24] R CA 2004-01-27 0
108-hr-3191,K000358 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 K000358 Rep. Kennedy, Mark R. [R-MN-6] R MN 2003-12-08 0
108-hr-3191,R000571 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 R000571 Rep. Rehberg, Dennis R. [R-MT-At Large] R MT 2003-11-20 0
108-hr-3191,H000413 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 H000413 Rep. Hayworth, J. D. [R-AZ-5] R AZ 2003-11-20 0
108-hr-3191,J000286 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 J000286 Rep. Janklow, William J. [R-SD-At Large] R SD 2003-11-20 0
108-hr-3191,S000583 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 S000583 Rep. Smith, Lamar [R-TX-21] R TX 2003-11-18 0
108-hr-3191,M001146 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 M001146 Rep. Marshall, Jim [D-GA-3] D GA 2003-11-18 0
108-hr-3191,S000303 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 S000303 Rep. Shaw, E. Clay, Jr. [R-FL-22] R FL 2003-11-18 0
108-hr-3191,C000059 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 C000059 Rep. Calvert, Ken [R-CA-44] R CA 2003-11-18 0
108-hr-3191,M001138 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 M001138 Rep. Manzullo, Donald A. [R-IL-16] R IL 2003-11-18 0
108-hr-3191,G000152 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 G000152 Rep. Gibbons, Jim [R-NV-2] R NV 2003-11-18 0
108-hr-3191,G000289 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 G000289 Rep. Goodlatte, Bob [R-VA-6] R VA 2003-11-18 0
108-hr-3191,S001155 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 S001155 Rep. Sullivan, John [R-OK-1] R OK 2003-11-06 0
108-hr-3191,C001053 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 C001053 Rep. Cole, Tom [R-OK-4] R OK 2003-11-06 0
108-hr-3191,J000255 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 J000255 Rep. Jones, Walter B., Jr. [R-NC-3] R NC 2003-11-06 0
108-hr-3191,B000072 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 B000072 Rep. Baker, Richard H. [R-LA-6] R LA 2003-11-06 0
108-hr-3191,W000119 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 W000119 Rep. Wamp, Zach [R-TN-3] R TN 2003-11-06 0
108-hr-3191,B001239 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 B001239 Rep. Barrett, J. Gresham [R-SC-3] R SC 2003-10-21 0
108-hr-3191,M001144 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 M001144 Rep. Miller, Jeff [R-FL-1] R FL 2003-10-21 0
108-hr-3191,G000410 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 G000410 Rep. Green, Gene [D-TX-29] D TX 2003-10-21 0
108-hr-3191,M001152 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 M001152 Rep. Musgrave, Marilyn N. [R-CO-4] R CO 2003-10-21 0
108-hr-3191,N000159 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 N000159 Rep. Norwood, Charles W. [R-GA-9] R GA 2003-10-16 0
108-hr-3191,N000081 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 N000081 Rep. Ney, Robert W. [R-OH-18] R OH 2003-10-16 0
108-hr-3191,D000597 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 D000597 Rep. Davis, Jo Ann [R-VA-1] R VA 2003-10-16 0
108-hr-3191,U000031 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 U000031 Rep. Upton, Fred [R-MI-6] R MI 2003-10-16 0
108-hr-3191,B000213 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 B000213 Rep. Barton, Joe [R-TX-6] R TX 2003-10-08 0
108-hr-3191,R000033 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 R000033 Rep. Ramstad, Jim [R-MN-3] R MN 2003-10-08 0
108-hr-3191,W000437 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 W000437 Rep. Wicker, Roger F. [R-MS-1] R MS 2003-10-08 0
108-hr-3191,W000267 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 W000267 Rep. Weldon, Dave [R-FL-15] R FL 2003-10-08 0
108-hr-3191,G000546 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 G000546 Rep. Graves, Sam [R-MO-6] R MO 2003-10-08 0
108-hr-3191,T000461 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 T000461 Rep. Toomey, Patrick J. [R-PA-15] R PA 2003-10-08 0
108-hr-3191,W000795 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 W000795 Rep. Wilson, Joe [R-SC-2] R SC 2003-10-08 0
108-hr-3191,A000358 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 A000358 Rep. Akin, W. Todd [R-MO-2] R MO 2003-10-02 0
108-hr-3191,K000362 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 K000362 Rep. King, Steve [R-IA-5] R IA 2003-10-02 0
108-hr-3191,T000458 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 T000458 Rep. Tancredo, Thomas G. [R-CO-6] R CO 2003-10-02 0
108-hr-3191,J000174 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 J000174 Rep. Johnson, Sam [R-TX-3] R TX 2003-10-02 0
108-hr-3191,M001134 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 M001134 Rep. Myrick, Sue Wilkins [R-NC-9] R NC 2003-10-02 0
108-hr-3191,H000528 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 H000528 Rep. Herger, Wally [R-CA-2] R CA 2003-10-02 0
108-hr-3191,H000676 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 H000676 Rep. Hoekstra, Peter [R-MI-2] R MI 2003-10-02 0
108-hr-3191,C001052 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 C001052 Rep. Chocola, Chris [R-IN-2] R IN 2003-10-02 0
108-hr-3191,S000275 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 S000275 Rep. Shadegg, John B. [R-AZ-3] R AZ 2003-10-02 0
108-hr-3191,H000807 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 H000807 Rep. Hostettler, John N. [R-IN-8] R IN 2003-10-02 0
108-hr-3191,P000587 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 P000587 Rep. Pence, Mike [R-IN-6] R IN 2003-10-02 0
108-hr-3191,B001243 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 B001243 Rep. Blackburn, Marsha [R-TN-7] R TN 2003-10-02 0
108-hr-3191,G000548 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 G000548 Rep. Garrett, Scott [R-NJ-5] R NJ 2003-10-02 0
108-hr-3191,K000363 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 K000363 Rep. Kline, John [R-MN-2] R MN 2003-10-02 0
108-hr-3191,T000074 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 T000074 Rep. Taylor, Gene [D-MS-4] D MS 2003-10-02 0
108-hr-3191,H000067 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 H000067 Rep. Hall, Ralph M. [D-TX-4] D TX 2003-10-02 0
108-hr-3191,P000373 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 P000373 Rep. Pitts, Joseph R. [R-PA-16] R PA 2003-09-25 1
108-hr-3191,B000208 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 B000208 Rep. Bartlett, Roscoe G. [R-MD-6] R MD 2003-09-25 1
108-hr-3191,D000429 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 D000429 Rep. Doolittle, John T. [R-CA-4] R CA 2003-09-25 1
108-hr-3191,F000448 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 F000448 Rep. Franks, Trent [R-AZ-2] R AZ 2003-09-25 1
108-hr-3191,G000280 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 G000280 Rep. Goode, Virgil H., Jr. [R-VA-5] R VA 2003-09-25 1
108-hr-3191,T000260 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 T000260 Rep. Tiahrt, Todd [R-KS-4] R KS 2003-09-25 1
108-hr-3191,C000266 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 C000266 Rep. Chabot, Steve [R-OH-1] R OH 2003-09-25 1
108-hr-3191,H001022 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 H001022 Rep. Hyde, Henry J. [R-IL-6] R IL 2003-09-25 1
108-hr-3191,H000444 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 H000444 Rep. Hefley, Joel [R-CO-5] R CO 2003-09-25 1
108-hr-3191,R000570 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 R000570 Rep. Ryan, Paul [R-WI-1] R WI 2003-09-25 1
108-hr-3191,F000447 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 F000447 Rep. Feeney, Tom [R-FL-24] R FL 2003-09-25 1
108-hr-3191,H001036 To prescribe the oath of renunciation and allegiance for purposes of the Immigration and Nationality Act. 108-hr-3191 H001036 Rep. Hensarling, Jeb [R-TX-5] R TX 2003-09-25 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 1554.838ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API