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

31 rows where bill_id = "111-hr-3206" 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 26
  • 0 5
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
111-hr-3206,R000581 Safe Drinking Water for Healthy Communities Act of 2009 111-hr-3206 R000581 Rep. Richardson, Laura [D-CA-37] D CA 2009-10-14 0
111-hr-3206,O000085 Safe Drinking Water for Healthy Communities Act of 2009 111-hr-3206 O000085 Rep. Olver, John W. [D-MA-1] D MA 2009-09-22 0
111-hr-3206,W000794 Safe Drinking Water for Healthy Communities Act of 2009 111-hr-3206 W000794 Rep. Watson, Diane E. [D-CA-33] D CA 2009-09-22 0
111-hr-3206,B001229 Safe Drinking Water for Healthy Communities Act of 2009 111-hr-3206 B001229 Rep. Baird, Brian [D-WA-3] D WA 2009-09-22 0
111-hr-3206,D000191 Safe Drinking Water for Healthy Communities Act of 2009 111-hr-3206 D000191 Rep. DeFazio, Peter A. [D-OR-4] D OR 2009-07-24 0
111-hr-3206,B001230 Safe Drinking Water for Healthy Communities Act of 2009 111-hr-3206 B001230 Rep. Baldwin, Tammy [D-WI-2] D WI 2009-07-14 1
111-hr-3206,B001251 Safe Drinking Water for Healthy Communities Act of 2009 111-hr-3206 B001251 Rep. Butterfield, G. K. [D-NC-1] D NC 2009-07-14 1
111-hr-3206,B000410 Safe Drinking Water for Healthy Communities Act of 2009 111-hr-3206 B000410 Rep. Berman, Howard L. [D-CA-28] D CA 2009-07-14 1
111-hr-3206,S000344 Safe Drinking Water for Healthy Communities Act of 2009 111-hr-3206 S000344 Rep. Sherman, Brad [D-CA-27] D CA 2009-07-14 1
111-hr-3206,S001150 Safe Drinking Water for Healthy Communities Act of 2009 111-hr-3206 S001150 Rep. Schiff, Adam B. [D-CA-29] D CA 2009-07-14 1
111-hr-3206,I000026 Safe Drinking Water for Healthy Communities Act of 2009 111-hr-3206 I000026 Rep. Inslee, Jay [D-WA-1] D WA 2009-07-14 1
111-hr-3206,S000030 Safe Drinking Water for Healthy Communities Act of 2009 111-hr-3206 S000030 Rep. Sanchez, Loretta [D-CA-47] D CA 2009-07-14 1
111-hr-3206,P000034 Safe Drinking Water for Healthy Communities Act of 2009 111-hr-3206 P000034 Rep. Pallone, Frank, Jr. [D-NJ-6] D NJ 2009-07-14 1
111-hr-3206,N000002 Safe Drinking Water for Healthy Communities Act of 2009 111-hr-3206 N000002 Rep. Nadler, Jerrold [D-NY-8] D NY 2009-07-14 1
111-hr-3206,H001034 Safe Drinking Water for Healthy Communities Act of 2009 111-hr-3206 H001034 Rep. Honda, Michael M. [D-CA-15] D CA 2009-07-14 1
111-hr-3206,H000324 Safe Drinking Water for Healthy Communities Act of 2009 111-hr-3206 H000324 Rep. Hastings, Alcee L. [D-FL-23] D FL 2009-07-14 1
111-hr-3206,E000215 Safe Drinking Water for Healthy Communities Act of 2009 111-hr-3206 E000215 Rep. Eshoo, Anna G. [D-CA-14] D CA 2009-07-14 1
111-hr-3206,W000792 Safe Drinking Water for Healthy Communities Act of 2009 111-hr-3206 W000792 Rep. Weiner, Anthony D. [D-NY-9] D NY 2009-07-14 1
111-hr-3206,N000179 Safe Drinking Water for Healthy Communities Act of 2009 111-hr-3206 N000179 Rep. Napolitano, Grace F. [D-CA-38] D CA 2009-07-14 1
111-hr-3206,M000725 Safe Drinking Water for Healthy Communities Act of 2009 111-hr-3206 M000725 Rep. Miller, George [D-CA-7] D CA 2009-07-14 1
111-hr-3206,M001166 Safe Drinking Water for Healthy Communities Act of 2009 111-hr-3206 M001166 Rep. McNerney, Jerry [D-CA-11] D CA 2009-07-14 1
111-hr-3206,M000087 Safe Drinking Water for Healthy Communities Act of 2009 111-hr-3206 M000087 Rep. Maloney, Carolyn B. [D-NY-14] D NY 2009-07-14 1
111-hr-3206,H000627 Safe Drinking Water for Healthy Communities Act of 2009 111-hr-3206 H000627 Rep. Hinchey, Maurice D. [D-NY-22] D NY 2009-07-14 1
111-hr-3206,B000574 Safe Drinking Water for Healthy Communities Act of 2009 111-hr-3206 B000574 Rep. Blumenauer, Earl [D-OR-3] D OR 2009-07-14 1
111-hr-3206,M000404 Safe Drinking Water for Healthy Communities Act of 2009 111-hr-3206 M000404 Rep. McDermott, Jim [D-WA-7] D WA 2009-07-14 1
111-hr-3206,S001145 Safe Drinking Water for Healthy Communities Act of 2009 111-hr-3206 S001145 Rep. Schakowsky, Janice D. [D-IL-9] D IL 2009-07-14 1
111-hr-3206,D000197 Safe Drinking Water for Healthy Communities Act of 2009 111-hr-3206 D000197 Rep. DeGette, Diana [D-CO-1] D CO 2009-07-14 1
111-hr-3206,L000551 Safe Drinking Water for Healthy Communities Act of 2009 111-hr-3206 L000551 Rep. Lee, Barbara [D-CA-9] D CA 2009-07-14 1
111-hr-3206,G000551 Safe Drinking Water for Healthy Communities Act of 2009 111-hr-3206 G000551 Rep. Grijalva, Raúl M. [D-AZ-7] D AZ 2009-07-14 1
111-hr-3206,M001163 Safe Drinking Water for Healthy Communities Act of 2009 111-hr-3206 M001163 Rep. Matsui, Doris O. [D-CA-5] D CA 2009-07-14 1
111-hr-3206,M001154 Safe Drinking Water for Healthy Communities Act of 2009 111-hr-3206 M001154 Rep. Miller, Brad [D-NC-13] D NC 2009-07-14 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);