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

42 rows where bill_id = "110-hconres-83" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: state, sponsorship_date, sponsorship_date (date)

is_original_cosponsor 2

  • 1 27
  • 0 15
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
110-hconres-83,B001260 Expressing the sense of the Congress that State and local governments should be supported for taking actions to discourage illegal immigration and that legislation should be enacted to ease the burden on State and local governments for taking such actions. 110-hconres-83 B001260 Rep. Buchanan, Vern [R-FL-13] R FL 2007-09-25 0
110-hconres-83,K000362 Expressing the sense of the Congress that State and local governments should be supported for taking actions to discourage illegal immigration and that legislation should be enacted to ease the burden on State and local governments for taking such actions. 110-hconres-83 K000362 Rep. King, Steve [R-IA-5] R IA 2007-09-24 0
110-hconres-83,S001167 Expressing the sense of the Congress that State and local governments should be supported for taking actions to discourage illegal immigration and that legislation should be enacted to ease the burden on State and local governments for taking such actions. 110-hconres-83 S001167 Rep. Sali, Bill [R-ID-1] R ID 2007-09-19 0
110-hconres-83,E000172 Expressing the sense of the Congress that State and local governments should be supported for taking actions to discourage illegal immigration and that legislation should be enacted to ease the burden on State and local governments for taking such actions. 110-hconres-83 E000172 Rep. Emerson, Jo Ann [R-MO-8] R MO 2007-09-19 0
110-hconres-83,C001051 Expressing the sense of the Congress that State and local governments should be supported for taking actions to discourage illegal immigration and that legislation should be enacted to ease the burden on State and local governments for taking such actions. 110-hconres-83 C001051 Rep. Carter, John R. [R-TX-31] R TX 2007-09-18 0
110-hconres-83,F000448 Expressing the sense of the Congress that State and local governments should be supported for taking actions to discourage illegal immigration and that legislation should be enacted to ease the burden on State and local governments for taking such actions. 110-hconres-83 F000448 Rep. Franks, Trent [R-AZ-2] R AZ 2007-09-18 0
110-hconres-83,S000583 Expressing the sense of the Congress that State and local governments should be supported for taking actions to discourage illegal immigration and that legislation should be enacted to ease the burden on State and local governments for taking such actions. 110-hconres-83 S000583 Rep. Smith, Lamar [R-TX-21] R TX 2007-09-17 0
110-hconres-83,D000606 Expressing the sense of the Congress that State and local governments should be supported for taking actions to discourage illegal immigration and that legislation should be enacted to ease the burden on State and local governments for taking such actions. 110-hconres-83 D000606 Rep. Davis, David [R-TN-1] R TN 2007-09-17 0
110-hconres-83,H001041 Expressing the sense of the Congress that State and local governments should be supported for taking actions to discourage illegal immigration and that legislation should be enacted to ease the burden on State and local governments for taking such actions. 110-hconres-83 H001041 Rep. Heller, Dean [R-NV-2] R NV 2007-08-03 0
110-hconres-83,M001144 Expressing the sense of the Congress that State and local governments should be supported for taking actions to discourage illegal immigration and that legislation should be enacted to ease the burden on State and local governments for taking such actions. 110-hconres-83 M001144 Rep. Miller, Jeff [R-FL-1] R FL 2007-06-25 0
110-hconres-83,M001147 Expressing the sense of the Congress that State and local governments should be supported for taking actions to discourage illegal immigration and that legislation should be enacted to ease the burden on State and local governments for taking such actions. 110-hconres-83 M001147 Rep. McCotter, Thaddeus G. [R-MI-11] R MI 2007-04-19 0
110-hconres-83,M001152 Expressing the sense of the Congress that State and local governments should be supported for taking actions to discourage illegal immigration and that legislation should be enacted to ease the burden on State and local governments for taking such actions. 110-hconres-83 M001152 Rep. Musgrave, Marilyn N. [R-CO-4] R CO 2007-03-21 0
110-hconres-83,T000458 Expressing the sense of the Congress that State and local governments should be supported for taking actions to discourage illegal immigration and that legislation should be enacted to ease the burden on State and local governments for taking such actions. 110-hconres-83 T000458 Rep. Tancredo, Thomas G. [R-CO-6] R CO 2007-03-12 0
110-hconres-83,F000450 Expressing the sense of the Congress that State and local governments should be supported for taking actions to discourage illegal immigration and that legislation should be enacted to ease the burden on State and local governments for taking such actions. 110-hconres-83 F000450 Rep. Foxx, Virginia [R-NC-5] R NC 2007-03-12 0
110-hconres-83,C000059 Expressing the sense of the Congress that State and local governments should be supported for taking actions to discourage illegal immigration and that legislation should be enacted to ease the burden on State and local governments for taking such actions. 110-hconres-83 C000059 Rep. Calvert, Ken [R-CA-44] R CA 2007-03-12 0
110-hconres-83,G000546 Expressing the sense of the Congress that State and local governments should be supported for taking actions to discourage illegal immigration and that legislation should be enacted to ease the burden on State and local governments for taking such actions. 110-hconres-83 G000546 Rep. Graves, Sam [R-MO-6] R MO 2007-03-06 1
110-hconres-83,G000550 Expressing the sense of the Congress that State and local governments should be supported for taking actions to discourage illegal immigration and that legislation should be enacted to ease the burden on State and local governments for taking such actions. 110-hconres-83 G000550 Rep. Gingrey, Phil [R-GA-11] R GA 2007-03-06 1
110-hconres-83,D000603 Expressing the sense of the Congress that State and local governments should be supported for taking actions to discourage illegal immigration and that legislation should be enacted to ease the burden on State and local governments for taking such actions. 110-hconres-83 D000603 Rep. Davis, Geoff [R-KY-4] R KY 2007-03-06 1
110-hconres-83,S001148 Expressing the sense of the Congress that State and local governments should be supported for taking actions to discourage illegal immigration and that legislation should be enacted to ease the burden on State and local governments for taking such actions. 110-hconres-83 S001148 Rep. Simpson, Michael K. [R-ID-2] R ID 2007-03-06 1
110-hconres-83,G000280 Expressing the sense of the Congress that State and local governments should be supported for taking actions to discourage illegal immigration and that legislation should be enacted to ease the burden on State and local governments for taking such actions. 110-hconres-83 G000280 Rep. Goode, Virgil H., Jr. [R-VA-5] R VA 2007-03-06 1
110-hconres-83,W000119 Expressing the sense of the Congress that State and local governments should be supported for taking actions to discourage illegal immigration and that legislation should be enacted to ease the burden on State and local governments for taking such actions. 110-hconres-83 W000119 Rep. Wamp, Zach [R-TN-3] R TN 2007-03-06 1
110-hconres-83,A000358 Expressing the sense of the Congress that State and local governments should be supported for taking actions to discourage illegal immigration and that legislation should be enacted to ease the burden on State and local governments for taking such actions. 110-hconres-83 A000358 Rep. Akin, W. Todd [R-MO-2] R MO 2007-03-06 1
110-hconres-83,B001243 Expressing the sense of the Congress that State and local governments should be supported for taking actions to discourage illegal immigration and that legislation should be enacted to ease the burden on State and local governments for taking such actions. 110-hconres-83 B001243 Rep. Blackburn, Marsha [R-TN-7] R TN 2007-03-06 1
110-hconres-83,J000255 Expressing the sense of the Congress that State and local governments should be supported for taking actions to discourage illegal immigration and that legislation should be enacted to ease the burden on State and local governments for taking such actions. 110-hconres-83 J000255 Rep. Jones, Walter B., Jr. [R-NC-3] R NC 2007-03-06 1
110-hconres-83,M001139 Expressing the sense of the Congress that State and local governments should be supported for taking actions to discourage illegal immigration and that legislation should be enacted to ease the burden on State and local governments for taking such actions. 110-hconres-83 M001139 Rep. Miller, Gary G. [R-CA-42] R CA 2007-03-06 1
110-hconres-83,F000447 Expressing the sense of the Congress that State and local governments should be supported for taking actions to discourage illegal immigration and that legislation should be enacted to ease the burden on State and local governments for taking such actions. 110-hconres-83 F000447 Rep. Feeney, Tom [R-FL-24] R FL 2007-03-06 1
110-hconres-83,H000981 Expressing the sense of the Congress that State and local governments should be supported for taking actions to discourage illegal immigration and that legislation should be enacted to ease the burden on State and local governments for taking such actions. 110-hconres-83 H000981 Rep. Hunter, Duncan [R-CA-52] R CA 2007-03-06 1
110-hconres-83,M001134 Expressing the sense of the Congress that State and local governments should be supported for taking actions to discourage illegal immigration and that legislation should be enacted to ease the burden on State and local governments for taking such actions. 110-hconres-83 M001134 Rep. Myrick, Sue Wilkins [R-NC-9] R NC 2007-03-06 1
110-hconres-83,B001149 Expressing the sense of the Congress that State and local governments should be supported for taking actions to discourage illegal immigration and that legislation should be enacted to ease the burden on State and local governments for taking such actions. 110-hconres-83 B001149 Rep. Burton, Dan [R-IN-5] R IN 2007-03-06 1
110-hconres-83,M001158 Expressing the sense of the Congress that State and local governments should be supported for taking actions to discourage illegal immigration and that legislation should be enacted to ease the burden on State and local governments for taking such actions. 110-hconres-83 M001158 Rep. Marchant, Kenny [R-TX-24] R TX 2007-03-06 1
110-hconres-83,M001156 Expressing the sense of the Congress that State and local governments should be supported for taking actions to discourage illegal immigration and that legislation should be enacted to ease the burden on State and local governments for taking such actions. 110-hconres-83 M001156 Rep. McHenry, Patrick T. [R-NC-10] R NC 2007-03-06 1
110-hconres-83,F000445 Expressing the sense of the Congress that State and local governments should be supported for taking actions to discourage illegal immigration and that legislation should be enacted to ease the burden on State and local governments for taking such actions. 110-hconres-83 F000445 Rep. Forbes, J. Randy [R-VA-4] R VA 2007-03-06 1
110-hconres-83,D000429 Expressing the sense of the Congress that State and local governments should be supported for taking actions to discourage illegal immigration and that legislation should be enacted to ease the burden on State and local governments for taking such actions. 110-hconres-83 D000429 Rep. Doolittle, John T. [R-CA-4] R CA 2007-03-06 1
110-hconres-83,M000388 Expressing the sense of the Congress that State and local governments should be supported for taking actions to discourage illegal immigration and that legislation should be enacted to ease the burden on State and local governments for taking such actions. 110-hconres-83 M000388 Rep. McCrery, Jim [R-LA-4] R LA 2007-03-06 1
110-hconres-83,B001247 Expressing the sense of the Congress that State and local governments should be supported for taking actions to discourage illegal immigration and that legislation should be enacted to ease the burden on State and local governments for taking such actions. 110-hconres-83 B001247 Rep. Brown-Waite, Ginny [R-FL-5] R FL 2007-03-06 1
110-hconres-83,G000548 Expressing the sense of the Congress that State and local governments should be supported for taking actions to discourage illegal immigration and that legislation should be enacted to ease the burden on State and local governments for taking such actions. 110-hconres-83 G000548 Rep. Garrett, Scott [R-NJ-5] R NJ 2007-03-06 1
110-hconres-83,M001157 Expressing the sense of the Congress that State and local governments should be supported for taking actions to discourage illegal immigration and that legislation should be enacted to ease the burden on State and local governments for taking such actions. 110-hconres-83 M001157 Rep. McCaul, Michael T. [R-TX-10] R TX 2007-03-06 1
110-hconres-83,C001064 Expressing the sense of the Congress that State and local governments should be supported for taking actions to discourage illegal immigration and that legislation should be enacted to ease the burden on State and local governments for taking such actions. 110-hconres-83 C001064 Rep. Campbell, John [R-CA-48] R CA 2007-03-06 1
110-hconres-83,J000174 Expressing the sense of the Congress that State and local governments should be supported for taking actions to discourage illegal immigration and that legislation should be enacted to ease the burden on State and local governments for taking such actions. 110-hconres-83 J000174 Rep. Johnson, Sam [R-TX-3] R TX 2007-03-06 1
110-hconres-83,R000487 Expressing the sense of the Congress that State and local governments should be supported for taking actions to discourage illegal immigration and that legislation should be enacted to ease the burden on State and local governments for taking such actions. 110-hconres-83 R000487 Rep. Royce, Edward R. [R-CA-40] R CA 2007-03-06 1
110-hconres-83,R000409 Expressing the sense of the Congress that State and local governments should be supported for taking actions to discourage illegal immigration and that legislation should be enacted to ease the burden on State and local governments for taking such actions. 110-hconres-83 R000409 Rep. Rohrabacher, Dana [R-CA-46] R CA 2007-03-06 1
110-hconres-83,B000461 Expressing the sense of the Congress that State and local governments should be supported for taking actions to discourage illegal immigration and that legislation should be enacted to ease the burden on State and local governments for taking such actions. 110-hconres-83 B000461 Rep. Bilbray, Brian P. [R-CA-50] R CA 2007-03-06 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);