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

48 rows where bill_id = "112-hr-6587" 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 46
  • 1 2
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
112-hr-6587,B001234 To designate the facility of the United States Postal Service located at 225 Simi Village Drive in Simi Valley, California, as the "Postal Inspector Terry Asbury Post Office Building". 112-hr-6587 B001234 Rep. Baca, Joe [D-CA-43] D CA 2012-12-07 0
112-hr-6587,B000461 To designate the facility of the United States Postal Service located at 225 Simi Village Drive in Simi Valley, California, as the "Postal Inspector Terry Asbury Post Office Building". 112-hr-6587 B000461 Rep. Bilbray, Brian P. [R-CA-50] R CA 2012-12-07 0
112-hr-6587,B001228 To designate the facility of the United States Postal Service located at 225 Simi Village Drive in Simi Valley, California, as the "Postal Inspector Terry Asbury Post Office Building". 112-hr-6587 B001228 Rep. Bono Mack, Mary [R-CA-45] R CA 2012-12-07 0
112-hr-6587,S000344 To designate the facility of the United States Postal Service located at 225 Simi Village Drive in Simi Valley, California, as the "Postal Inspector Terry Asbury Post Office Building". 112-hr-6587 S000344 Rep. Sherman, Brad [D-CA-27] D CA 2012-12-07 0
112-hr-6587,S001175 To designate the facility of the United States Postal Service located at 225 Simi Village Drive in Simi Valley, California, as the "Postal Inspector Terry Asbury Post Office Building". 112-hr-6587 S001175 Rep. Speier, Jackie [D-CA-12] D CA 2012-12-07 0
112-hr-6587,B001270 To designate the facility of the United States Postal Service located at 225 Simi Village Drive in Simi Valley, California, as the "Postal Inspector Terry Asbury Post Office Building". 112-hr-6587 B001270 Rep. Bass, Karen [D-CA-33] D CA 2012-12-05 0
112-hr-6587,C001036 To designate the facility of the United States Postal Service located at 225 Simi Village Drive in Simi Valley, California, as the "Postal Inspector Terry Asbury Post Office Building". 112-hr-6587 C001036 Rep. Capps, Lois [D-CA-23] D CA 2012-12-05 0
112-hr-6587,C001059 To designate the facility of the United States Postal Service located at 225 Simi Village Drive in Simi Valley, California, as the "Postal Inspector Terry Asbury Post Office Building". 112-hr-6587 C001059 Rep. Costa, Jim [D-CA-20] D CA 2012-12-05 0
112-hr-6587,D000598 To designate the facility of the United States Postal Service located at 225 Simi Village Drive in Simi Valley, California, as the "Postal Inspector Terry Asbury Post Office Building". 112-hr-6587 D000598 Rep. Davis, Susan A. [D-CA-53] D CA 2012-12-05 0
112-hr-6587,D000492 To designate the facility of the United States Postal Service located at 225 Simi Village Drive in Simi Valley, California, as the "Postal Inspector Terry Asbury Post Office Building". 112-hr-6587 D000492 Rep. Dreier, David [R-CA-26] R CA 2012-12-05 0
112-hr-6587,P000197 To designate the facility of the United States Postal Service located at 225 Simi Village Drive in Simi Valley, California, as the "Postal Inspector Terry Asbury Post Office Building". 112-hr-6587 P000197 Rep. Pelosi, Nancy [D-CA-8] D CA 2012-12-05 0
112-hr-6587,W000187 To designate the facility of the United States Postal Service located at 225 Simi Village Drive in Simi Valley, California, as the "Postal Inspector Terry Asbury Post Office Building". 112-hr-6587 W000187 Rep. Waters, Maxine [D-CA-35] D CA 2012-12-04 0
112-hr-6587,H001048 To designate the facility of the United States Postal Service located at 225 Simi Village Drive in Simi Valley, California, as the "Postal Inspector Terry Asbury Post Office Building". 112-hr-6587 H001048 Rep. Hunter, Duncan D. [R-CA-52] R CA 2012-12-04 0
112-hr-6587,B000287 To designate the facility of the United States Postal Service located at 225 Simi Village Drive in Simi Valley, California, as the "Postal Inspector Terry Asbury Post Office Building". 112-hr-6587 B000287 Rep. Becerra, Xavier [D-CA-31] D CA 2012-12-04 0
112-hr-6587,C001064 To designate the facility of the United States Postal Service located at 225 Simi Village Drive in Simi Valley, California, as the "Postal Inspector Terry Asbury Post Office Building". 112-hr-6587 C001064 Rep. Campbell, John [R-CA-48] R CA 2012-12-04 0
112-hr-6587,C001080 To designate the facility of the United States Postal Service located at 225 Simi Village Drive in Simi Valley, California, as the "Postal Inspector Terry Asbury Post Office Building". 112-hr-6587 C001080 Rep. Chu, Judy [D-CA-32] D CA 2012-12-04 0
112-hr-6587,D000612 To designate the facility of the United States Postal Service located at 225 Simi Village Drive in Simi Valley, California, as the "Postal Inspector Terry Asbury Post Office Building". 112-hr-6587 D000612 Rep. Denham, Jeff [R-CA-19] R CA 2012-12-04 0
112-hr-6587,G000559 To designate the facility of the United States Postal Service located at 225 Simi Village Drive in Simi Valley, California, as the "Postal Inspector Terry Asbury Post Office Building". 112-hr-6587 G000559 Rep. Garamendi, John [D-CA-10] D CA 2012-12-04 0
112-hr-6587,H001063 To designate the facility of the United States Postal Service located at 225 Simi Village Drive in Simi Valley, California, as the "Postal Inspector Terry Asbury Post Office Building". 112-hr-6587 H001063 Rep. Hahn, Janice [D-CA-36] D CA 2012-12-04 0
112-hr-6587,H000528 To designate the facility of the United States Postal Service located at 225 Simi Village Drive in Simi Valley, California, as the "Postal Inspector Terry Asbury Post Office Building". 112-hr-6587 H000528 Rep. Herger, Wally [R-CA-2] R CA 2012-12-04 0
112-hr-6587,L000274 To designate the facility of the United States Postal Service located at 225 Simi Village Drive in Simi Valley, California, as the "Postal Inspector Terry Asbury Post Office Building". 112-hr-6587 L000274 Rep. Lewis, Jerry [R-CA-41] R CA 2012-12-04 0
112-hr-6587,L000397 To designate the facility of the United States Postal Service located at 225 Simi Village Drive in Simi Valley, California, as the "Postal Inspector Terry Asbury Post Office Building". 112-hr-6587 L000397 Rep. Lofgren, Zoe [D-CA-16] D CA 2012-12-04 0
112-hr-6587,L000517 To designate the facility of the United States Postal Service located at 225 Simi Village Drive in Simi Valley, California, as the "Postal Inspector Terry Asbury Post Office Building". 112-hr-6587 L000517 Rep. Lungren, Daniel E. [R-CA-3] R CA 2012-12-04 0
112-hr-6587,M001163 To designate the facility of the United States Postal Service located at 225 Simi Village Drive in Simi Valley, California, as the "Postal Inspector Terry Asbury Post Office Building". 112-hr-6587 M001163 Rep. Matsui, Doris O. [D-CA-5] D CA 2012-12-04 0
112-hr-6587,M000725 To designate the facility of the United States Postal Service located at 225 Simi Village Drive in Simi Valley, California, as the "Postal Inspector Terry Asbury Post Office Building". 112-hr-6587 M000725 Rep. Miller, George [D-CA-7] D CA 2012-12-04 0
112-hr-6587,R000486 To designate the facility of the United States Postal Service located at 225 Simi Village Drive in Simi Valley, California, as the "Postal Inspector Terry Asbury Post Office Building". 112-hr-6587 R000486 Rep. Roybal-Allard, Lucille [D-CA-34] D CA 2012-12-04 0
112-hr-6587,W000215 To designate the facility of the United States Postal Service located at 225 Simi Village Drive in Simi Valley, California, as the "Postal Inspector Terry Asbury Post Office Building". 112-hr-6587 W000215 Rep. Waxman, Henry A. [D-CA-30] D CA 2012-12-04 0
112-hr-6587,M001166 To designate the facility of the United States Postal Service located at 225 Simi Village Drive in Simi Valley, California, as the "Postal Inspector Terry Asbury Post Office Building". 112-hr-6587 M001166 Rep. McNerney, Jerry [D-CA-11] D CA 2012-11-29 0
112-hr-6587,E000215 To designate the facility of the United States Postal Service located at 225 Simi Village Drive in Simi Valley, California, as the "Postal Inspector Terry Asbury Post Office Building". 112-hr-6587 E000215 Rep. Eshoo, Anna G. [D-CA-14] D CA 2012-11-29 0
112-hr-6587,S000810 To designate the facility of the United States Postal Service located at 225 Simi Village Drive in Simi Valley, California, as the "Postal Inspector Terry Asbury Post Office Building". 112-hr-6587 S000810 Rep. Stark, Fortney Pete [D-CA-13] D CA 2012-11-29 0
112-hr-6587,C000059 To designate the facility of the United States Postal Service located at 225 Simi Village Drive in Simi Valley, California, as the "Postal Inspector Terry Asbury Post Office Building". 112-hr-6587 C000059 Rep. Calvert, Ken [R-CA-44] R CA 2012-11-27 0
112-hr-6587,M001177 To designate the facility of the United States Postal Service located at 225 Simi Village Drive in Simi Valley, California, as the "Postal Inspector Terry Asbury Post Office Building". 112-hr-6587 M001177 Rep. McClintock, Tom [R-CA-4] R CA 2012-11-27 0
112-hr-6587,F000030 To designate the facility of the United States Postal Service located at 225 Simi Village Drive in Simi Valley, California, as the "Postal Inspector Terry Asbury Post Office Building". 112-hr-6587 F000030 Rep. Farr, Sam [D-CA-17] D CA 2012-11-27 0
112-hr-6587,H001034 To designate the facility of the United States Postal Service located at 225 Simi Village Drive in Simi Valley, California, as the "Postal Inspector Terry Asbury Post Office Building". 112-hr-6587 H001034 Rep. Honda, Michael M. [D-CA-15] D CA 2012-11-27 0
112-hr-6587,L000551 To designate the facility of the United States Postal Service located at 225 Simi Village Drive in Simi Valley, California, as the "Postal Inspector Terry Asbury Post Office Building". 112-hr-6587 L000551 Rep. Lee, Barbara [D-CA-9] D CA 2012-11-27 0
112-hr-6587,B000410 To designate the facility of the United States Postal Service located at 225 Simi Village Drive in Simi Valley, California, as the "Postal Inspector Terry Asbury Post Office Building". 112-hr-6587 B000410 Rep. Berman, Howard L. [D-CA-28] D CA 2012-11-27 0
112-hr-6587,S000030 To designate the facility of the United States Postal Service located at 225 Simi Village Drive in Simi Valley, California, as the "Postal Inspector Terry Asbury Post Office Building". 112-hr-6587 S000030 Rep. Sanchez, Loretta [D-CA-47] D CA 2012-11-27 0
112-hr-6587,R000487 To designate the facility of the United States Postal Service located at 225 Simi Village Drive in Simi Valley, California, as the "Postal Inspector Terry Asbury Post Office Building". 112-hr-6587 R000487 Rep. Royce, Edward R. [R-CA-40] R CA 2012-11-27 0
112-hr-6587,S001156 To designate the facility of the United States Postal Service located at 225 Simi Village Drive in Simi Valley, California, as the "Postal Inspector Terry Asbury Post Office Building". 112-hr-6587 S001156 Rep. Sánchez, Linda T. [D-CA-39] D CA 2012-11-27 0
112-hr-6587,N000181 To designate the facility of the United States Postal Service located at 225 Simi Village Drive in Simi Valley, California, as the "Postal Inspector Terry Asbury Post Office Building". 112-hr-6587 N000181 Rep. Nunes, Devin [R-CA-21] R CA 2012-11-27 0
112-hr-6587,T000460 To designate the facility of the United States Postal Service located at 225 Simi Village Drive in Simi Valley, California, as the "Postal Inspector Terry Asbury Post Office Building". 112-hr-6587 T000460 Rep. Thompson, Mike [D-CA-1] D CA 2012-11-15 0
112-hr-6587,R000409 To designate the facility of the United States Postal Service located at 225 Simi Village Drive in Simi Valley, California, as the "Postal Inspector Terry Asbury Post Office Building". 112-hr-6587 R000409 Rep. Rohrabacher, Dana [R-CA-46] R CA 2012-11-15 0
112-hr-6587,M001139 To designate the facility of the United States Postal Service located at 225 Simi Village Drive in Simi Valley, California, as the "Postal Inspector Terry Asbury Post Office Building". 112-hr-6587 M001139 Rep. Miller, Gary G. [R-CA-42] R CA 2012-11-15 0
112-hr-6587,N000179 To designate the facility of the United States Postal Service located at 225 Simi Village Drive in Simi Valley, California, as the "Postal Inspector Terry Asbury Post Office Building". 112-hr-6587 N000179 Rep. Napolitano, Grace F. [D-CA-38] D CA 2012-11-15 0
112-hr-6587,S001150 To designate the facility of the United States Postal Service located at 225 Simi Village Drive in Simi Valley, California, as the "Postal Inspector Terry Asbury Post Office Building". 112-hr-6587 S001150 Rep. Schiff, Adam B. [D-CA-29] D CA 2012-11-15 0
112-hr-6587,W000738 To designate the facility of the United States Postal Service located at 225 Simi Village Drive in Simi Valley, California, as the "Postal Inspector Terry Asbury Post Office Building". 112-hr-6587 W000738 Rep. Woolsey, Lynn C. [D-CA-6] D CA 2012-11-15 0
112-hr-6587,R000581 To designate the facility of the United States Postal Service located at 225 Simi Village Drive in Simi Valley, California, as the "Postal Inspector Terry Asbury Post Office Building". 112-hr-6587 R000581 Rep. Richardson, Laura [D-CA-37] D CA 2012-11-13 1
112-hr-6587,M000508 To designate the facility of the United States Postal Service located at 225 Simi Village Drive in Simi Valley, California, as the "Postal Inspector Terry Asbury Post Office Building". 112-hr-6587 M000508 Rep. McKeon, Howard P. "Buck" [R-CA-25] R CA 2012-11-13 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);