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

31 rows where bill_id = "116-hr-8058" 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

  • 0 30
  • 1 1
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
116-hr-8058,C001118 Chinese Research Funds Accounting Act 116-hr-8058 C001118 Rep. Cline, Ben [R-VA-6] R VA 2020-12-04 0
116-hr-8058,G000568 Chinese Research Funds Accounting Act 116-hr-8058 G000568 Rep. Griffith, H. Morgan [R-VA-9] R VA 2020-11-19 0
116-hr-8058,G000591 Chinese Research Funds Accounting Act 116-hr-8058 G000591 Rep. Guest, Michael [R-MS-3] R MS 2020-10-27 0
116-hr-8058,W000821 Chinese Research Funds Accounting Act 116-hr-8058 W000821 Rep. Westerman, Bruce [R-AR-4] R AR 2020-10-27 0
116-hr-8058,J000020 Chinese Research Funds Accounting Act 116-hr-8058 J000020 Rep. Jacobs, Chris [R-NY-27] R NY 2020-10-20 0
116-hr-8058,L000578 Chinese Research Funds Accounting Act 116-hr-8058 L000578 Rep. LaMalfa, Doug [R-CA-1] R CA 2020-10-16 0
116-hr-8058,H001071 Chinese Research Funds Accounting Act 116-hr-8058 H001071 Rep. Hice, Jody B. [R-GA-10] R GA 2020-10-16 0
116-hr-8058,W000815 Chinese Research Funds Accounting Act 116-hr-8058 W000815 Rep. Wenstrup, Brad R. [R-OH-2] R OH 2020-10-16 0
116-hr-8058,C001053 Chinese Research Funds Accounting Act 116-hr-8058 C001053 Rep. Cole, Tom [R-OK-4] R OK 2020-10-16 0
116-hr-8058,B001291 Chinese Research Funds Accounting Act 116-hr-8058 B001291 Rep. Babin, Brian [R-TX-36] R TX 2020-10-09 0
116-hr-8058,G000563 Chinese Research Funds Accounting Act 116-hr-8058 G000563 Rep. Gibbs, Bob [R-OH-7] R OH 2020-10-09 0
116-hr-8058,W000814 Chinese Research Funds Accounting Act 116-hr-8058 W000814 Rep. Weber, Randy K., Sr. [R-TX-14] R TX 2020-10-09 0
116-hr-8058,T000165 Chinese Research Funds Accounting Act 116-hr-8058 T000165 Rep. Tiffany, Thomas P. [R-WI-7] R WI 2020-10-09 0
116-hr-8058,F000466 Chinese Research Funds Accounting Act 116-hr-8058 F000466 Rep. Fitzpatrick, Brian K. [R-PA-1] R PA 2020-10-09 0
116-hr-8058,R000610 Chinese Research Funds Accounting Act 116-hr-8058 R000610 Rep. Reschenthaler, Guy [R-PA-14] R PA 2020-10-09 0
116-hr-8058,B001309 Chinese Research Funds Accounting Act 116-hr-8058 B001309 Rep. Burchett, Tim [R-TN-2] R TN 2020-10-09 0
116-hr-8058,W000806 Chinese Research Funds Accounting Act 116-hr-8058 W000806 Rep. Webster, Daniel [R-FL-11] R FL 2020-10-09 0
116-hr-8058,T000479 Chinese Research Funds Accounting Act 116-hr-8058 T000479 Rep. Taylor, Van [R-TX-3] R TX 2020-10-09 0
116-hr-8058,M001159 Chinese Research Funds Accounting Act 116-hr-8058 M001159 Rep. McMorris Rodgers, Cathy [R-WA-5] R WA 2020-10-09 0
116-hr-8058,J000295 Chinese Research Funds Accounting Act 116-hr-8058 J000295 Rep. Joyce, David P. [R-OH-14] R OH 2020-10-09 0
116-hr-8058,A000372 Chinese Research Funds Accounting Act 116-hr-8058 A000372 Rep. Allen, Rick W. [R-GA-12] R GA 2020-10-09 0
116-hr-8058,B001248 Chinese Research Funds Accounting Act 116-hr-8058 B001248 Rep. Burgess, Michael C. [R-TX-26] R TX 2020-10-09 0
116-hr-8058,G000578 Chinese Research Funds Accounting Act 116-hr-8058 G000578 Rep. Gaetz, Matt [R-FL-1] R FL 2020-10-01 0
116-hr-8058,S001192 Chinese Research Funds Accounting Act 116-hr-8058 S001192 Rep. Stewart, Chris [R-UT-2] R UT 2020-10-01 0
116-hr-8058,R000575 Chinese Research Funds Accounting Act 116-hr-8058 R000575 Rep. Rogers, Mike D. [R-AL-3] R AL 2020-10-01 0
116-hr-8058,B001306 Chinese Research Funds Accounting Act 116-hr-8058 B001306 Rep. Balderson, Troy [R-OH-12] R OH 2020-09-30 0
116-hr-8058,P000605 Chinese Research Funds Accounting Act 116-hr-8058 P000605 Rep. Perry, Scott [R-PA-10] R PA 2020-09-30 0
116-hr-8058,R000611 Chinese Research Funds Accounting Act 116-hr-8058 R000611 Rep. Riggleman, Denver [R-VA-5] R VA 2020-09-30 0
116-hr-8058,P000599 Chinese Research Funds Accounting Act 116-hr-8058 P000599 Rep. Posey, Bill [R-FL-8] R FL 2020-09-30 0
116-hr-8058,Y000065 Chinese Research Funds Accounting Act 116-hr-8058 Y000065 Rep. Yoho, Ted S. [R-FL-3] R FL 2020-08-28 0
116-hr-8058,G000588 Chinese Research Funds Accounting Act 116-hr-8058 G000588 Rep. Gonzalez, Anthony [R-OH-16] R OH 2020-08-14 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 6.643ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API