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

45 rows where bill_id = "111-hr-4690" 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

  • 0 26
  • 1 19
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
111-hr-4690,B001230 Livable Communities Act of 2010 111-hr-4690 B001230 Rep. Baldwin, Tammy [D-WI-2] D WI 2010-12-22 0
111-hr-4690,W000792 Livable Communities Act of 2010 111-hr-4690 W000792 Rep. Weiner, Anthony D. [D-NY-9] D NY 2010-11-18 0
111-hr-4690,C001078 Livable Communities Act of 2010 111-hr-4690 C001078 Rep. Connolly, Gerald E. [D-VA-11] D VA 2010-11-18 0
111-hr-4690,G000553 Livable Communities Act of 2010 111-hr-4690 G000553 Rep. Green, Al [D-TX-9] D TX 2010-11-18 0
111-hr-4690,L000480 Livable Communities Act of 2010 111-hr-4690 L000480 Rep. Lowey, Nita M. [D-NY-18] D NY 2010-11-18 0
111-hr-4690,P000597 Livable Communities Act of 2010 111-hr-4690 P000597 Rep. Pingree, Chellie [D-ME-1] D ME 2010-11-18 0
111-hr-4690,P000523 Livable Communities Act of 2010 111-hr-4690 P000523 Rep. Price, David E. [D-NC-4] D NC 2010-09-28 0
111-hr-4690,M001171 Livable Communities Act of 2010 111-hr-4690 M001171 Rep. Maffei, Daniel B. [D-NY-25] D NY 2010-09-28 0
111-hr-4690,S001145 Livable Communities Act of 2010 111-hr-4690 S001145 Rep. Schakowsky, Janice D. [D-IL-9] D IL 2010-09-28 0
111-hr-4690,J000288 Livable Communities Act of 2010 111-hr-4690 J000288 Rep. Johnson, Henry C. "Hank," Jr. [D-GA-4] D GA 2010-07-29 0
111-hr-4690,S001170 Livable Communities Act of 2010 111-hr-4690 S001170 Rep. Shea-Porter, Carol [D-NH-1] D NH 2010-07-29 0
111-hr-4690,K000172 Livable Communities Act of 2010 111-hr-4690 K000172 Rep. Kildee, Dale E. [D-MI-5] D MI 2010-07-29 0
111-hr-4690,P000099 Livable Communities Act of 2010 111-hr-4690 P000099 Rep. Pastor, Ed [D-AZ-4] D AZ 2010-07-19 0
111-hr-4690,M000933 Livable Communities Act of 2010 111-hr-4690 M000933 Rep. Moran, James P. [D-VA-8] D VA 2010-07-14 0
111-hr-4690,H001034 Livable Communities Act of 2010 111-hr-4690 H001034 Rep. Honda, Michael M. [D-CA-15] D CA 2010-07-14 0
111-hr-4690,L000551 Livable Communities Act of 2010 111-hr-4690 L000551 Rep. Lee, Barbara [D-CA-9] D CA 2010-06-22 0
111-hr-4690,K000365 Livable Communities Act of 2010 111-hr-4690 K000365 Rep. Kagen, Steve [D-WI-8] D WI 2010-05-25 0
111-hr-4690,F000116 Livable Communities Act of 2010 111-hr-4690 F000116 Rep. Filner, Bob [D-CA-51] D CA 2010-05-06 0
111-hr-4690,M001143 Livable Communities Act of 2010 111-hr-4690 M001143 Rep. McCollum, Betty [D-MN-4] D MN 2010-04-29 0
111-hr-4690,M000725 Livable Communities Act of 2010 111-hr-4690 M000725 Rep. Miller, George [D-CA-7] D CA 2010-04-14 0
111-hr-4690,L000562 Livable Communities Act of 2010 111-hr-4690 L000562 Rep. Lynch, Stephen F. [D-MA-9] D MA 2010-04-14 0
111-hr-4690,D000216 Livable Communities Act of 2010 111-hr-4690 D000216 Rep. DeLauro, Rosa L. [D-CT-3] D CT 2010-03-09 0
111-hr-4690,M001169 Livable Communities Act of 2010 111-hr-4690 M001169 Rep. Murphy, Christopher [D-CT-5] D CT 2010-03-04 0
111-hr-4690,C001066 Livable Communities Act of 2010 111-hr-4690 C001066 Rep. Castor, Kathy [D-FL-11] D FL 2010-03-04 0
111-hr-4690,C001036 Livable Communities Act of 2010 111-hr-4690 C001036 Rep. Capps, Lois [D-CA-23] D CA 2010-03-02 0
111-hr-4690,C001061 Livable Communities Act of 2010 111-hr-4690 C001061 Rep. Cleaver, Emanuel [D-MO-5] D MO 2010-03-02 0
111-hr-4690,W000187 Livable Communities Act of 2010 111-hr-4690 W000187 Rep. Waters, Maxine [D-CA-35] D CA 2010-02-25 1
111-hr-4690,H001044 Livable Communities Act of 2010 111-hr-4690 H001044 Rep. Halvorson, Deborah L. [D-IL-11] D IL 2010-02-25 1
111-hr-4690,L000557 Livable Communities Act of 2010 111-hr-4690 L000557 Rep. Larson, John B. [D-CT-1] D CT 2010-02-25 1
111-hr-4690,B000574 Livable Communities Act of 2010 111-hr-4690 B000574 Rep. Blumenauer, Earl [D-OR-3] D OR 2010-02-25 1
111-hr-4690,H001043 Livable Communities Act of 2010 111-hr-4690 H001043 Rep. Hodes, Paul W. [D-NH-2] D NH 2010-02-25 1
111-hr-4690,H001047 Livable Communities Act of 2010 111-hr-4690 H001047 Rep. Himes, James A. [D-CT-4] D CT 2010-02-25 1
111-hr-4690,S001165 Livable Communities Act of 2010 111-hr-4690 S001165 Rep. Sires, Albio [D-NJ-13] D NJ 2010-02-25 1
111-hr-4690,C001072 Livable Communities Act of 2010 111-hr-4690 C001072 Rep. Carson, Andre [D-IN-7] D IN 2010-02-25 1
111-hr-4690,E000288 Livable Communities Act of 2010 111-hr-4690 E000288 Rep. Ellison, Keith [D-MN-5] D MN 2010-02-25 1
111-hr-4690,C000380 Livable Communities Act of 2010 111-hr-4690 C000380 Del. Christensen, Donna M. [D-VI-At Large] D VI 2010-02-25 1
111-hr-4690,C001060 Livable Communities Act of 2010 111-hr-4690 C001060 Rep. Carnahan, Russ [D-MO-3] D MO 2010-02-25 1
111-hr-4690,H001032 Livable Communities Act of 2010 111-hr-4690 H001032 Rep. Holt, Rush [D-NJ-12] D NJ 2010-02-25 1
111-hr-4690,C001068 Livable Communities Act of 2010 111-hr-4690 C001068 Rep. Cohen, Steve [D-TN-9] D TN 2010-02-25 1
111-hr-4690,C001069 Livable Communities Act of 2010 111-hr-4690 C001069 Rep. Courtney, Joe [D-CT-2] D CT 2010-02-25 1
111-hr-4690,M000404 Livable Communities Act of 2010 111-hr-4690 M000404 Rep. McDermott, Jim [D-WA-7] D WA 2010-02-25 1
111-hr-4690,Q000023 Livable Communities Act of 2010 111-hr-4690 Q000023 Rep. Quigley, Mike [D-IL-5] D IL 2010-02-25 1
111-hr-4690,S001162 Livable Communities Act of 2010 111-hr-4690 S001162 Rep. Schwartz, Allyson Y. [D-PA-13] D PA 2010-02-25 1
111-hr-4690,T000469 Livable Communities Act of 2010 111-hr-4690 T000469 Rep. Tonko, Paul [D-NY-21] D NY 2010-02-25 1
111-hr-4690,S001168 Livable Communities Act of 2010 111-hr-4690 S001168 Rep. Sarbanes, John P. [D-MD-3] D MD 2010-02-25 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);