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

32 rows where bill_id = "110-hconres-411" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party, state, sponsorship_date, sponsorship_date (date)

is_original_cosponsor 2

  • 0 17
  • 1 15
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
110-hconres-411,B001256 Raising the awareness of the need for crime prevention in communities across the country and expressing support for designation of the week of October 2, 2008, through October 4, 2008, as "Celebrate Safe Communities" Week. 110-hconres-411 B001256 Rep. Bachmann, Michele [R-MN-6] R MN 2008-09-26 0
110-hconres-411,S001169 Raising the awareness of the need for crime prevention in communities across the country and expressing support for designation of the week of October 2, 2008, through October 4, 2008, as "Celebrate Safe Communities" Week. 110-hconres-411 S001169 Rep. Sestak, Joe [D-PA-7] D PA 2008-09-24 0
110-hconres-411,L000566 Raising the awareness of the need for crime prevention in communities across the country and expressing support for designation of the week of October 2, 2008, through October 4, 2008, as "Celebrate Safe Communities" Week. 110-hconres-411 L000566 Rep. Latta, Robert E. [R-OH-5] R OH 2008-09-23 0
110-hconres-411,H000329 Raising the awareness of the need for crime prevention in communities across the country and expressing support for designation of the week of October 2, 2008, through October 4, 2008, as "Celebrate Safe Communities" Week. 110-hconres-411 H000329 Rep. Hastings, Doc [R-WA-4] R WA 2008-09-22 0
110-hconres-411,D000600 Raising the awareness of the need for crime prevention in communities across the country and expressing support for designation of the week of October 2, 2008, through October 4, 2008, as "Celebrate Safe Communities" Week. 110-hconres-411 D000600 Rep. Diaz-Balart, Mario [R-FL-25] R FL 2008-09-22 0
110-hconres-411,S001167 Raising the awareness of the need for crime prevention in communities across the country and expressing support for designation of the week of October 2, 2008, through October 4, 2008, as "Celebrate Safe Communities" Week. 110-hconres-411 S001167 Rep. Sali, Bill [R-ID-1] R ID 2008-09-22 0
110-hconres-411,C001072 Raising the awareness of the need for crime prevention in communities across the country and expressing support for designation of the week of October 2, 2008, through October 4, 2008, as "Celebrate Safe Communities" Week. 110-hconres-411 C001072 Rep. Carson, Andre [D-IN-7] D IN 2008-09-18 0
110-hconres-411,C000059 Raising the awareness of the need for crime prevention in communities across the country and expressing support for designation of the week of October 2, 2008, through October 4, 2008, as "Celebrate Safe Communities" Week. 110-hconres-411 C000059 Rep. Calvert, Ken [R-CA-44] R CA 2008-09-18 0
110-hconres-411,C001068 Raising the awareness of the need for crime prevention in communities across the country and expressing support for designation of the week of October 2, 2008, through October 4, 2008, as "Celebrate Safe Communities" Week. 110-hconres-411 C001068 Rep. Cohen, Steve [D-TN-9] D TN 2008-09-18 0
110-hconres-411,S000185 Raising the awareness of the need for crime prevention in communities across the country and expressing support for designation of the week of October 2, 2008, through October 4, 2008, as "Celebrate Safe Communities" Week. 110-hconres-411 S000185 Rep. Scott, Robert C. "Bobby" [D-VA-3] D VA 2008-09-17 0
110-hconres-411,K000210 Raising the awareness of the need for crime prevention in communities across the country and expressing support for designation of the week of October 2, 2008, through October 4, 2008, as "Celebrate Safe Communities" Week. 110-hconres-411 K000210 Rep. King, Peter T. [R-NY-3] R NY 2008-09-17 0
110-hconres-411,G000552 Raising the awareness of the need for crime prevention in communities across the country and expressing support for designation of the week of October 2, 2008, through October 4, 2008, as "Celebrate Safe Communities" Week. 110-hconres-411 G000552 Rep. Gohmert, Louie [R-TX-1] R TX 2008-09-17 0
110-hconres-411,S001045 Raising the awareness of the need for crime prevention in communities across the country and expressing support for designation of the week of October 2, 2008, through October 4, 2008, as "Celebrate Safe Communities" Week. 110-hconres-411 S001045 Rep. Stupak, Bart [D-MI-1] D MI 2008-09-17 0
110-hconres-411,M000472 Raising the awareness of the need for crime prevention in communities across the country and expressing support for designation of the week of October 2, 2008, through October 4, 2008, as "Celebrate Safe Communities" Week. 110-hconres-411 M000472 Rep. McHugh, John M. [R-NY-23] R NY 2008-09-16 0
110-hconres-411,C000556 Raising the awareness of the need for crime prevention in communities across the country and expressing support for designation of the week of October 2, 2008, through October 4, 2008, as "Celebrate Safe Communities" Week. 110-hconres-411 C000556 Rep. Coble, Howard [R-NC-6] R NC 2008-09-16 0
110-hconres-411,E000172 Raising the awareness of the need for crime prevention in communities across the country and expressing support for designation of the week of October 2, 2008, through October 4, 2008, as "Celebrate Safe Communities" Week. 110-hconres-411 E000172 Rep. Emerson, Jo Ann [R-MO-8] R MO 2008-09-15 0
110-hconres-411,C000243 Raising the awareness of the need for crime prevention in communities across the country and expressing support for designation of the week of October 2, 2008, through October 4, 2008, as "Celebrate Safe Communities" Week. 110-hconres-411 C000243 Rep. Castle, Michael N. [R-DE-At Large] R DE 2008-09-15 0
110-hconres-411,B001245 Raising the awareness of the need for crime prevention in communities across the country and expressing support for designation of the week of October 2, 2008, through October 4, 2008, as "Celebrate Safe Communities" Week. 110-hconres-411 B001245 Del. Bordallo, Madeleine Z. [D-GU-At Large] D GU 2008-09-11 1
110-hconres-411,R000033 Raising the awareness of the need for crime prevention in communities across the country and expressing support for designation of the week of October 2, 2008, through October 4, 2008, as "Celebrate Safe Communities" Week. 110-hconres-411 R000033 Rep. Ramstad, Jim [R-MN-3] R MN 2008-09-11 1
110-hconres-411,D000482 Raising the awareness of the need for crime prevention in communities across the country and expressing support for designation of the week of October 2, 2008, through October 4, 2008, as "Celebrate Safe Communities" Week. 110-hconres-411 D000482 Rep. Doyle, Michael F. [D-PA-14] D PA 2008-09-11 1
110-hconres-411,H000712 Raising the awareness of the need for crime prevention in communities across the country and expressing support for designation of the week of October 2, 2008, through October 4, 2008, as "Celebrate Safe Communities" Week. 110-hconres-411 H000712 Rep. Holden, Tim [D-PA-17] D PA 2008-09-11 1
110-hconres-411,S000522 Raising the awareness of the need for crime prevention in communities across the country and expressing support for designation of the week of October 2, 2008, through October 4, 2008, as "Celebrate Safe Communities" Week. 110-hconres-411 S000522 Rep. Smith, Christopher H. [R-NJ-4] R NJ 2008-09-11 1
110-hconres-411,E000092 Raising the awareness of the need for crime prevention in communities across the country and expressing support for designation of the week of October 2, 2008, through October 4, 2008, as "Celebrate Safe Communities" Week. 110-hconres-411 E000092 Rep. Ehlers, Vernon J. [R-MI-3] R MI 2008-09-11 1
110-hconres-411,P000555 Raising the awareness of the need for crime prevention in communities across the country and expressing support for designation of the week of October 2, 2008, through October 4, 2008, as "Celebrate Safe Communities" Week. 110-hconres-411 P000555 Rep. Pryce, Deborah [R-OH-15] R OH 2008-09-11 1
110-hconres-411,P000592 Raising the awareness of the need for crime prevention in communities across the country and expressing support for designation of the week of October 2, 2008, through October 4, 2008, as "Celebrate Safe Communities" Week. 110-hconres-411 P000592 Rep. Poe, Ted [R-TX-2] R TX 2008-09-11 1
110-hconres-411,P000265 Raising the awareness of the need for crime prevention in communities across the country and expressing support for designation of the week of October 2, 2008, through October 4, 2008, as "Celebrate Safe Communities" Week. 110-hconres-411 P000265 Rep. Petri, Thomas E. [R-WI-6] R WI 2008-09-11 1
110-hconres-411,G000549 Raising the awareness of the need for crime prevention in communities across the country and expressing support for designation of the week of October 2, 2008, through October 4, 2008, as "Celebrate Safe Communities" Week. 110-hconres-411 G000549 Rep. Gerlach, Jim [R-PA-6] R PA 2008-09-11 1
110-hconres-411,M001159 Raising the awareness of the need for crime prevention in communities across the country and expressing support for designation of the week of October 2, 2008, through October 4, 2008, as "Celebrate Safe Communities" Week. 110-hconres-411 M001159 Rep. McMorris Rodgers, Cathy [R-WA-5] R WA 2008-09-11 1
110-hconres-411,B001227 Raising the awareness of the need for crime prevention in communities across the country and expressing support for designation of the week of October 2, 2008, through October 4, 2008, as "Celebrate Safe Communities" Week. 110-hconres-411 B001227 Rep. Brady, Robert A. [D-PA-1] D PA 2008-09-11 1
110-hconres-411,K000365 Raising the awareness of the need for crime prevention in communities across the country and expressing support for designation of the week of October 2, 2008, through October 4, 2008, as "Celebrate Safe Communities" Week. 110-hconres-411 K000365 Rep. Kagen, Steve [D-WI-8] D WI 2008-09-11 1
110-hconres-411,K000360 Raising the awareness of the need for crime prevention in communities across the country and expressing support for designation of the week of October 2, 2008, through October 4, 2008, as "Celebrate Safe Communities" Week. 110-hconres-411 K000360 Rep. Kirk, Mark Steven [R-IL-10] R IL 2008-09-11 1
110-hconres-411,S001144 Raising the awareness of the need for crime prevention in communities across the country and expressing support for designation of the week of October 2, 2008, through October 4, 2008, as "Celebrate Safe Communities" Week. 110-hconres-411 S001144 Rep. Shays, Christopher [R-CT-4] R CT 2008-09-11 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);