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

22 rows where bill_id = "118-hconres-71" 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 14
  • 0 8
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
118-hconres-71,D000032 Expressing the sense of Congress to encourage full participation of Taiwan in the Asia-Pacific Economic Cooperation forum. 118-hconres-71 D000032 Rep. Donalds, Byron [R-FL-19] R FL 2023-10-26 0
118-hconres-71,M001222 Expressing the sense of Congress to encourage full participation of Taiwan in the Asia-Pacific Economic Cooperation forum. 118-hconres-71 M001222 Rep. Miller, Max L. [R-OH-7] R OH 2023-10-26 0
118-hconres-71,C001039 Expressing the sense of Congress to encourage full participation of Taiwan in the Asia-Pacific Economic Cooperation forum. 118-hconres-71 C001039 Rep. Cammack, Kat [R-FL-3] R FL 2023-10-19 0
118-hconres-71,M001177 Expressing the sense of Congress to encourage full participation of Taiwan in the Asia-Pacific Economic Cooperation forum. 118-hconres-71 M001177 Rep. McClintock, Tom [R-CA-5] R CA 2023-10-18 0
118-hconres-71,W000823 Expressing the sense of Congress to encourage full participation of Taiwan in the Asia-Pacific Economic Cooperation forum. 118-hconres-71 W000823 Rep. Waltz, Michael [R-FL-6] R FL 2023-10-11 0
118-hconres-71,C001129 Expressing the sense of Congress to encourage full participation of Taiwan in the Asia-Pacific Economic Cooperation forum. 118-hconres-71 C001129 Rep. Collins, Mike [R-GA-10] R GA 2023-10-10 0
118-hconres-71,M001159 Expressing the sense of Congress to encourage full participation of Taiwan in the Asia-Pacific Economic Cooperation forum. 118-hconres-71 M001159 Rep. McMorris Rodgers, Cathy [R-WA-5] R WA 2023-10-06 0
118-hconres-71,F000459 Expressing the sense of Congress to encourage full participation of Taiwan in the Asia-Pacific Economic Cooperation forum. 118-hconres-71 F000459 Rep. Fleischmann, Charles J. "Chuck" [R-TN-3] R TN 2023-10-06 0
118-hconres-71,J000292 Expressing the sense of Congress to encourage full participation of Taiwan in the Asia-Pacific Economic Cooperation forum. 118-hconres-71 J000292 Rep. Johnson, Bill [R-OH-6] R OH 2023-10-03 1
118-hconres-71,T000165 Expressing the sense of Congress to encourage full participation of Taiwan in the Asia-Pacific Economic Cooperation forum. 118-hconres-71 T000165 Rep. Tiffany, Thomas P. [R-WI-7] R WI 2023-10-03 1
118-hconres-71,S001222 Expressing the sense of Congress to encourage full participation of Taiwan in the Asia-Pacific Economic Cooperation forum. 118-hconres-71 S001222 Rep. Santos, George [R-NY-3] R NY 2023-10-03 1
118-hconres-71,O000086 Expressing the sense of Congress to encourage full participation of Taiwan in the Asia-Pacific Economic Cooperation forum. 118-hconres-71 O000086 Rep. Owens, Burgess [R-UT-4] R UT 2023-10-03 1
118-hconres-71,Y000067 Expressing the sense of Congress to encourage full participation of Taiwan in the Asia-Pacific Economic Cooperation forum. 118-hconres-71 Y000067 Rep. Yakym, Rudy [R-IN-2] R IN 2023-10-03 1
118-hconres-71,O000175 Expressing the sense of Congress to encourage full participation of Taiwan in the Asia-Pacific Economic Cooperation forum. 118-hconres-71 O000175 Rep. Ogles, Andrew [R-TN-5] R TN 2023-10-03 1
118-hconres-71,W000814 Expressing the sense of Congress to encourage full participation of Taiwan in the Asia-Pacific Economic Cooperation forum. 118-hconres-71 W000814 Rep. Weber, Randy K., Sr. [R-TX-14] R TX 2023-10-03 1
118-hconres-71,G000593 Expressing the sense of Congress to encourage full participation of Taiwan in the Asia-Pacific Economic Cooperation forum. 118-hconres-71 G000593 Rep. Gimenez, Carlos A. [R-FL-28] R FL 2023-10-03 1
118-hconres-71,S001224 Expressing the sense of Congress to encourage full participation of Taiwan in the Asia-Pacific Economic Cooperation forum. 118-hconres-71 S001224 Rep. Self, Keith [R-TX-3] R TX 2023-10-03 1
118-hconres-71,F000478 Expressing the sense of Congress to encourage full participation of Taiwan in the Asia-Pacific Economic Cooperation forum. 118-hconres-71 F000478 Rep. Fry, Russell [R-SC-7] R SC 2023-10-03 1
118-hconres-71,F000246 Expressing the sense of Congress to encourage full participation of Taiwan in the Asia-Pacific Economic Cooperation forum. 118-hconres-71 F000246 Rep. Fallon, Pat [R-TX-4] R TX 2023-10-03 1
118-hconres-71,J000304 Expressing the sense of Congress to encourage full participation of Taiwan in the Asia-Pacific Economic Cooperation forum. 118-hconres-71 J000304 Rep. Jackson, Ronny [R-TX-13] R TX 2023-10-03 1
118-hconres-71,S000168 Expressing the sense of Congress to encourage full participation of Taiwan in the Asia-Pacific Economic Cooperation forum. 118-hconres-71 S000168 Rep. Salazar, Maria Elvira [R-FL-27] R FL 2023-10-03 1
118-hconres-71,B001302 Expressing the sense of Congress to encourage full participation of Taiwan in the Asia-Pacific Economic Cooperation forum. 118-hconres-71 B001302 Rep. Biggs, Andy [R-AZ-5] R AZ 2023-10-03 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);