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

50 rows where bill_id = "117-hr-9074" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party, sponsorship_date, sponsorship_date (date)

is_original_cosponsor 2

  • 0 42
  • 1 8
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
117-hr-9074,O000019 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 O000019 Rep. Obernolte, Jay [R-CA-8] R CA 2022-11-16 0
117-hr-9074,W000187 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 W000187 Rep. Waters, Maxine [D-CA-43] D CA 2022-11-15 0
117-hr-9074,B001285 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 B001285 Rep. Brownley, Julia [D-CA-26] D CA 2022-11-15 0
117-hr-9074,C001128 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 C001128 Rep. Conway, Connie [R-CA-22] R CA 2022-11-15 0
117-hr-9074,S001135 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 S001135 Rep. Steel, Michelle [R-CA-48] R CA 2022-11-14 0
117-hr-9074,B001287 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 B001287 Rep. Bera, Ami [D-CA-7] D CA 2022-11-03 0
117-hr-9074,L000551 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 L000551 Rep. Lee, Barbara [D-CA-13] D CA 2022-11-03 0
117-hr-9074,T000474 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 T000474 Rep. Torres, Norma J. [D-CA-35] D CA 2022-11-03 0
117-hr-9074,D000623 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 D000623 Rep. DeSaulnier, Mark [D-CA-11] D CA 2022-11-03 0
117-hr-9074,G000585 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 G000585 Rep. Gomez, Jimmy [D-CA-34] D CA 2022-11-03 0
117-hr-9074,K000389 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 K000389 Rep. Khanna, Ro [D-CA-17] D CA 2022-11-03 0
117-hr-9074,H001090 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 H001090 Rep. Harder, Josh [D-CA-10] D CA 2022-11-03 0
117-hr-9074,L000582 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 L000582 Rep. Lieu, Ted [D-CA-33] D CA 2022-11-03 0
117-hr-9074,E000215 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 E000215 Rep. Eshoo, Anna G. [D-CA-18] D CA 2022-11-03 0
117-hr-9074,M001177 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 M001177 Rep. McClintock, Tom [R-CA-4] R CA 2022-10-31 0
117-hr-9074,V000130 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 V000130 Rep. Vargas, Juan [D-CA-51] D CA 2022-10-28 0
117-hr-9074,S001175 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 S001175 Rep. Speier, Jackie [D-CA-14] D CA 2022-10-25 0
117-hr-9074,S001156 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 S001156 Rep. Sánchez, Linda T. [D-CA-38] D CA 2022-10-25 0
117-hr-9074,P000608 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 P000608 Rep. Peters, Scott H. [D-CA-52] D CA 2022-10-25 0
117-hr-9074,M001163 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 M001163 Rep. Matsui, Doris O. [D-CA-6] D CA 2022-10-25 0
117-hr-9074,H001068 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 H001068 Rep. Huffman, Jared [D-CA-2] D CA 2022-10-25 0
117-hr-9074,L000578 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 L000578 Rep. LaMalfa, Doug [R-CA-1] R CA 2022-10-25 0
117-hr-9074,G000559 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 G000559 Rep. Garamendi, John [D-CA-3] D CA 2022-10-25 0
117-hr-9074,C001097 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 C001097 Rep. Cárdenas, Tony [D-CA-29] D CA 2022-10-21 0
117-hr-9074,L000579 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 L000579 Rep. Lowenthal, Alan S. [D-CA-47] D CA 2022-10-21 0
117-hr-9074,C001110 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 C001110 Rep. Correa, J. Luis [D-CA-46] D CA 2022-10-21 0
117-hr-9074,G000061 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 G000061 Rep. Garcia, Mike [R-CA-25] R CA 2022-10-21 0
117-hr-9074,J000305 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 J000305 Rep. Jacobs, Sara [D-CA-53] D CA 2022-10-21 0
117-hr-9074,P000618 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 P000618 Rep. Porter, Katie [D-CA-45] D CA 2022-10-21 0
117-hr-9074,R000486 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 R000486 Rep. Roybal-Allard, Lucille [D-CA-40] D CA 2022-10-21 0
117-hr-9074,S001150 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 S001150 Rep. Schiff, Adam B. [D-CA-28] D CA 2022-10-21 0
117-hr-9074,C001112 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 C001112 Rep. Carbajal, Salud O. [D-CA-24] D CA 2022-10-21 0
117-hr-9074,A000371 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 A000371 Rep. Aguilar, Pete [D-CA-31] D CA 2022-10-21 0
117-hr-9074,T000460 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 T000460 Rep. Thompson, Mike [D-CA-5] D CA 2022-10-07 0
117-hr-9074,V000129 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 V000129 Rep. Valadao, David G. [R-CA-21] R CA 2022-10-07 0
117-hr-9074,S000344 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 S000344 Rep. Sherman, Brad [D-CA-30] D CA 2022-10-04 0
117-hr-9074,S001193 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 S001193 Rep. Swalwell, Eric [D-CA-15] D CA 2022-10-04 0
117-hr-9074,B001270 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 B001270 Rep. Bass, Karen [D-CA-37] D CA 2022-10-04 0
117-hr-9074,K000397 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 K000397 Rep. Kim, Young [R-CA-39] R CA 2022-10-04 0
117-hr-9074,M001166 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 M001166 Rep. McNerney, Jerry [D-CA-9] D CA 2022-10-04 0
117-hr-9074,L000397 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 L000397 Rep. Lofgren, Zoe [D-CA-19] D CA 2022-09-30 0
117-hr-9074,C000059 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 C000059 Rep. Calvert, Ken [R-CA-42] R CA 2022-09-30 0
117-hr-9074,C001059 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 C001059 Rep. Costa, Jim [D-CA-16] D CA 2022-09-29 1
117-hr-9074,P000613 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 P000613 Rep. Panetta, Jimmy [D-CA-20] D CA 2022-09-29 1
117-hr-9074,N000179 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 N000179 Rep. Napolitano, Grace F. [D-CA-32] D CA 2022-09-29 1
117-hr-9074,T000472 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 T000472 Rep. Takano, Mark [D-CA-41] D CA 2022-09-29 1
117-hr-9074,L000593 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 L000593 Rep. Levin, Mike [D-CA-49] D CA 2022-09-29 1
117-hr-9074,I000056 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 I000056 Rep. Issa, Darrell E. [R-CA-50] R CA 2022-09-29 1
117-hr-9074,B001300 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 B001300 Rep. Barragan, Nanette Diaz [D-CA-44] D CA 2022-09-29 1
117-hr-9074,C001080 To designate the facility of the United States Postal Service located at 333 North Sunrise Way in Palm Springs, California, as the "Chairman Richard Milanovich Post Office". 117-hr-9074 C001080 Rep. Chu, Judy [D-CA-27] D CA 2022-09-29 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);