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

41 rows where bill_id = "108-hr-4064" 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 30
  • 1 11
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
108-hr-4064,G000289 Federal Contractor Security Act 108-hr-4064 G000289 Rep. Goodlatte, Bob [R-VA-6] R VA 2004-09-30 0
108-hr-4064,H000413 Federal Contractor Security Act 108-hr-4064 H000413 Rep. Hayworth, J. D. [R-AZ-5] R AZ 2004-09-30 0
108-hr-4064,S000275 Federal Contractor Security Act 108-hr-4064 S000275 Rep. Shadegg, John B. [R-AZ-3] R AZ 2004-07-22 0
108-hr-4064,M000472 Federal Contractor Security Act 108-hr-4064 M000472 Rep. McHugh, John M. [R-NY-23] R NY 2004-07-15 0
108-hr-4064,B000104 Federal Contractor Security Act 108-hr-4064 B000104 Rep. Ballenger, Cass [R-NC-10] R NC 2004-07-15 0
108-hr-4064,C001051 Federal Contractor Security Act 108-hr-4064 C001051 Rep. Carter, John R. [R-TX-31] R TX 2004-07-15 0
108-hr-4064,C000071 Federal Contractor Security Act 108-hr-4064 C000071 Rep. Camp, Dave [R-MI-4] R MI 2004-06-25 0
108-hr-4064,S000851 Federal Contractor Security Act 108-hr-4064 S000851 Rep. Stenholm, Charles W. [D-TX-17] D TX 2004-06-25 0
108-hr-4064,F000448 Federal Contractor Security Act 108-hr-4064 F000448 Rep. Franks, Trent [R-AZ-2] R AZ 2004-06-25 0
108-hr-4064,N000182 Federal Contractor Security Act 108-hr-4064 N000182 Rep. Neugebauer, Randy [R-TX-19] R TX 2004-06-09 0
108-hr-4064,S001155 Federal Contractor Security Act 108-hr-4064 S001155 Rep. Sullivan, John [R-OK-1] R OK 2004-06-09 0
108-hr-4064,H000528 Federal Contractor Security Act 108-hr-4064 H000528 Rep. Herger, Wally [R-CA-2] R CA 2004-06-09 0
108-hr-4064,S001144 Federal Contractor Security Act 108-hr-4064 S001144 Rep. Shays, Christopher [R-CT-4] R CT 2004-06-09 0
108-hr-4064,B001249 Federal Contractor Security Act 108-hr-4064 B001249 Rep. Burns, Max [R-GA-12] R GA 2004-05-20 0
108-hr-4064,J000174 Federal Contractor Security Act 108-hr-4064 J000174 Rep. Johnson, Sam [R-TX-3] R TX 2004-05-20 0
108-hr-4064,F000445 Federal Contractor Security Act 108-hr-4064 F000445 Rep. Forbes, J. Randy [R-VA-4] R VA 2004-05-20 0
108-hr-4064,H000444 Federal Contractor Security Act 108-hr-4064 H000444 Rep. Hefley, Joel [R-CO-5] R CO 2004-05-12 0
108-hr-4064,H000067 Federal Contractor Security Act 108-hr-4064 H000067 Rep. Hall, Ralph M. [R-TX-4] R TX 2004-05-12 0
108-hr-4064,R000033 Federal Contractor Security Act 108-hr-4064 R000033 Rep. Ramstad, Jim [R-MN-3] R MN 2004-05-12 0
108-hr-4064,B001149 Federal Contractor Security Act 108-hr-4064 B001149 Rep. Burton, Dan [R-IN-5] R IN 2004-05-12 0
108-hr-4064,J000082 Federal Contractor Security Act 108-hr-4064 J000082 Rep. Jenkins, William L. [R-TN-1] R TN 2004-05-12 0
108-hr-4064,G000536 Federal Contractor Security Act 108-hr-4064 G000536 Rep. Gutknecht, Gil [R-MN-1] R MN 2004-05-12 0
108-hr-4064,N000159 Federal Contractor Security Act 108-hr-4064 N000159 Rep. Norwood, Charles W. [R-GA-9] R GA 2004-05-06 0
108-hr-4064,B000403 Federal Contractor Security Act 108-hr-4064 B000403 Rep. Bereuter, Doug [R-NE-1] R NE 2004-05-06 0
108-hr-4064,M001138 Federal Contractor Security Act 108-hr-4064 M001138 Rep. Manzullo, Donald A. [R-IL-16] R IL 2004-05-06 0
108-hr-4064,D000429 Federal Contractor Security Act 108-hr-4064 D000429 Rep. Doolittle, John T. [R-CA-4] R CA 2004-05-06 0
108-hr-4064,M001144 Federal Contractor Security Act 108-hr-4064 M001144 Rep. Miller, Jeff [R-FL-1] R FL 2004-05-06 0
108-hr-4064,L000293 Federal Contractor Security Act 108-hr-4064 L000293 Rep. Lewis, Ron [R-KY-2] R KY 2004-05-06 0
108-hr-4064,K000363 Federal Contractor Security Act 108-hr-4064 K000363 Rep. Kline, John [R-MN-2] R MN 2004-05-06 0
108-hr-4064,B000755 Federal Contractor Security Act 108-hr-4064 B000755 Rep. Brady, Kevin [R-TX-8] R TX 2004-05-06 0
108-hr-4064,C000059 Federal Contractor Security Act 108-hr-4064 C000059 Rep. Calvert, Ken [R-CA-44] R CA 2004-03-30 1
108-hr-4064,S000583 Federal Contractor Security Act 108-hr-4064 S000583 Rep. Smith, Lamar [R-TX-21] R TX 2004-03-30 1
108-hr-4064,S001143 Federal Contractor Security Act 108-hr-4064 S001143 Rep. Souder, Mark E. [R-IN-3] R IN 2004-03-30 1
108-hr-4064,T000458 Federal Contractor Security Act 108-hr-4064 T000458 Rep. Tancredo, Thomas G. [R-CO-6] R CO 2004-03-30 1
108-hr-4064,I000056 Federal Contractor Security Act 108-hr-4064 I000056 Rep. Issa, Darrell E. [R-CA-49] R CA 2004-03-30 1
108-hr-4064,G000280 Federal Contractor Security Act 108-hr-4064 G000280 Rep. Goode, Virgil H., Jr. [R-VA-5] R VA 2004-03-30 1
108-hr-4064,R000487 Federal Contractor Security Act 108-hr-4064 R000487 Rep. Royce, Edward R. [R-CA-40] R CA 2004-03-30 1
108-hr-4064,K000362 Federal Contractor Security Act 108-hr-4064 K000362 Rep. King, Steve [R-IA-5] R IA 2004-03-30 1
108-hr-4064,R000409 Federal Contractor Security Act 108-hr-4064 R000409 Rep. Rohrabacher, Dana [R-CA-46] R CA 2004-03-30 1
108-hr-4064,G000548 Federal Contractor Security Act 108-hr-4064 G000548 Rep. Garrett, Scott [R-NJ-5] R NJ 2004-03-30 1
108-hr-4064,G000021 Federal Contractor Security Act 108-hr-4064 G000021 Rep. Gallegly, Elton [R-CA-24] R CA 2004-03-30 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);