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

51 rows where bill_id = "113-hr-5331" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party, sponsorship_date (date)

is_original_cosponsor 1

  • 1 51
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
113-hr-5331,B001270 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 B001270 Rep. Bass, Karen [D-CA-37] D CA 2014-07-31 1
113-hr-5331,B000287 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 B000287 Rep. Becerra, Xavier [D-CA-34] D CA 2014-07-31 1
113-hr-5331,B001287 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 B001287 Rep. Bera, Ami [D-CA-7] D CA 2014-07-31 1
113-hr-5331,B001285 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 B001285 Rep. Brownley, Julia [D-CA-26] D CA 2014-07-31 1
113-hr-5331,C000059 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 C000059 Rep. Calvert, Ken [R-CA-42] R CA 2014-07-31 1
113-hr-5331,C001064 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 C001064 Rep. Campbell, John [R-CA-45] R CA 2014-07-31 1
113-hr-5331,C001036 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 C001036 Rep. Capps, Lois [D-CA-24] D CA 2014-07-31 1
113-hr-5331,C001097 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 C001097 Rep. Cárdenas, Tony [D-CA-29] D CA 2014-07-31 1
113-hr-5331,C001080 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 C001080 Rep. Chu, Judy [D-CA-27] D CA 2014-07-31 1
113-hr-5331,C001059 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 C001059 Rep. Costa, Jim [D-CA-16] D CA 2014-07-31 1
113-hr-5331,D000598 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 D000598 Rep. Davis, Susan A. [D-CA-53] D CA 2014-07-31 1
113-hr-5331,D000612 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 D000612 Rep. Denham, Jeff [R-CA-10] R CA 2014-07-31 1
113-hr-5331,E000215 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 E000215 Rep. Eshoo, Anna G. [D-CA-18] D CA 2014-07-31 1
113-hr-5331,F000030 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 F000030 Rep. Farr, Sam [D-CA-20] D CA 2014-07-31 1
113-hr-5331,G000559 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 G000559 Rep. Garamendi, John [D-CA-3] D CA 2014-07-31 1
113-hr-5331,H001063 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 H001063 Rep. Hahn, Janice [D-CA-44] D CA 2014-07-31 1
113-hr-5331,H001034 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 H001034 Rep. Honda, Michael M. [D-CA-17] D CA 2014-07-31 1
113-hr-5331,H001068 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 H001068 Rep. Huffman, Jared [D-CA-2] D CA 2014-07-31 1
113-hr-5331,H001048 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 H001048 Rep. Hunter, Duncan D. [R-CA-50] R CA 2014-07-31 1
113-hr-5331,L000578 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 L000578 Rep. LaMalfa, Doug [R-CA-1] R CA 2014-07-31 1
113-hr-5331,L000551 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 L000551 Rep. Lee, Barbara [D-CA-13] D CA 2014-07-31 1
113-hr-5331,L000397 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 L000397 Rep. Lofgren, Zoe [D-CA-19] D CA 2014-07-31 1
113-hr-5331,L000579 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 L000579 Rep. Lowenthal, Alan S. [D-CA-47] D CA 2014-07-31 1
113-hr-5331,M001163 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 M001163 Rep. Matsui, Doris O. [D-CA-6] D CA 2014-07-31 1
113-hr-5331,M001165 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 M001165 Rep. McCarthy, Kevin [R-CA-23] R CA 2014-07-31 1
113-hr-5331,M001177 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 M001177 Rep. McClintock, Tom [R-CA-4] R CA 2014-07-31 1
113-hr-5331,M000508 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 M000508 Rep. McKeon, Howard P. "Buck" [R-CA-25] R CA 2014-07-31 1
113-hr-5331,N000187 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 N000187 Rep. Negrete McLeod, Gloria [D-CA-35] D CA 2014-07-31 1
113-hr-5331,M001166 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 M001166 Rep. McNerney, Jerry [D-CA-9] D CA 2014-07-31 1
113-hr-5331,M001139 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 M001139 Rep. Miller, Gary G. [R-CA-31] R CA 2014-07-31 1
113-hr-5331,M000725 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 M000725 Rep. Miller, George [D-CA-11] D CA 2014-07-31 1
113-hr-5331,N000179 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 N000179 Rep. Napolitano, Grace F. [D-CA-32] D CA 2014-07-31 1
113-hr-5331,N000181 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 N000181 Rep. Nunes, Devin [R-CA-22] R CA 2014-07-31 1
113-hr-5331,P000197 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 P000197 Rep. Pelosi, Nancy [D-CA-12] D CA 2014-07-31 1
113-hr-5331,P000608 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 P000608 Rep. Peters, Scott H. [D-CA-52] D CA 2014-07-31 1
113-hr-5331,R000409 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 R000409 Rep. Rohrabacher, Dana [R-CA-48] R CA 2014-07-31 1
113-hr-5331,R000486 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 R000486 Rep. Roybal-Allard, Lucille [D-CA-40] D CA 2014-07-31 1
113-hr-5331,R000487 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 R000487 Rep. Royce, Edward R. [R-CA-39] R CA 2014-07-31 1
113-hr-5331,R000599 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 R000599 Rep. Ruiz, Raul [D-CA-36] D CA 2014-07-31 1
113-hr-5331,S001156 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 S001156 Rep. Sánchez, Linda T. [D-CA-38] D CA 2014-07-31 1
113-hr-5331,S000030 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 S000030 Rep. Sanchez, Loretta [D-CA-46] D CA 2014-07-31 1
113-hr-5331,S001150 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 S001150 Rep. Schiff, Adam B. [D-CA-28] D CA 2014-07-31 1
113-hr-5331,S000344 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 S000344 Rep. Sherman, Brad [D-CA-30] D CA 2014-07-31 1
113-hr-5331,S001175 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 S001175 Rep. Speier, Jackie [D-CA-14] D CA 2014-07-31 1
113-hr-5331,S001193 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 S001193 Rep. Swalwell, Eric [D-CA-15] D CA 2014-07-31 1
113-hr-5331,T000472 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 T000472 Rep. Takano, Mark [D-CA-41] D CA 2014-07-31 1
113-hr-5331,T000460 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 T000460 Rep. Thompson, Mike [D-CA-5] D CA 2014-07-31 1
113-hr-5331,V000129 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 V000129 Rep. Valadao, David G. [R-CA-21] R CA 2014-07-31 1
113-hr-5331,V000130 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 V000130 Rep. Vargas, Juan [D-CA-51] D CA 2014-07-31 1
113-hr-5331,W000187 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 W000187 Rep. Waters, Maxine [D-CA-43] D CA 2014-07-31 1
113-hr-5331,W000215 To designate the facility of the United States Postal Service located at 73839 Gorgonio Drive in Twentynine Palms, California, as the "Colonel M.J. 'Mac' Dube, USMC Post Office Building". 113-hr-5331 W000215 Rep. Waxman, Henry A. [D-CA-33] D CA 2014-07-31 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 304.525ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API