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

56 rows where bill_id = "113-hr-4148" 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 1

  • 0 56
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
113-hr-4148,C000984 Humane Cosmetics Act 113-hr-4148 C000984 Rep. Cummings, Elijah E. [D-MD-7] D MD 2014-11-14 0
113-hr-4148,K000381 Humane Cosmetics Act 113-hr-4148 K000381 Rep. Kilmer, Derek [D-WA-6] D WA 2014-09-09 0
113-hr-4148,N000187 Humane Cosmetics Act 113-hr-4148 N000187 Rep. Negrete McLeod, Gloria [D-CA-35] D CA 2014-07-31 0
113-hr-4148,D000620 Humane Cosmetics Act 113-hr-4148 D000620 Rep. Delaney, John K. [D-MD-6] D MD 2014-07-25 0
113-hr-4148,H001034 Humane Cosmetics Act 113-hr-4148 H001034 Rep. Honda, Michael M. [D-CA-17] D CA 2014-07-22 0
113-hr-4148,C001049 Humane Cosmetics Act 113-hr-4148 C001049 Rep. Clay, Wm. Lacy [D-MO-1] D MO 2014-07-22 0
113-hr-4148,C001066 Humane Cosmetics Act 113-hr-4148 C001066 Rep. Castor, Kathy [D-FL-14] D FL 2014-07-17 0
113-hr-4148,L000562 Humane Cosmetics Act 113-hr-4148 L000562 Rep. Lynch, Stephen F. [D-MA-8] D MA 2014-07-10 0
113-hr-4148,E000293 Humane Cosmetics Act 113-hr-4148 E000293 Rep. Esty, Elizabeth H. [D-CT-5] D CT 2014-07-10 0
113-hr-4148,C001090 Humane Cosmetics Act 113-hr-4148 C001090 Rep. Cartwright, Matt [D-PA-17] D PA 2014-06-24 0
113-hr-4148,L000557 Humane Cosmetics Act 113-hr-4148 L000557 Rep. Larson, John B. [D-CT-1] D CT 2014-06-18 0
113-hr-4148,M001166 Humane Cosmetics Act 113-hr-4148 M001166 Rep. McNerney, Jerry [D-CA-9] D CA 2014-05-20 0
113-hr-4148,B001242 Humane Cosmetics Act 113-hr-4148 B001242 Rep. Bishop, Timothy H. [D-NY-1] D NY 2014-05-20 0
113-hr-4148,W000800 Humane Cosmetics Act 113-hr-4148 W000800 Rep. Welch, Peter [D-VT-At Large] D VT 2014-05-20 0
113-hr-4148,S001175 Humane Cosmetics Act 113-hr-4148 S001175 Rep. Speier, Jackie [D-CA-14] D CA 2014-05-20 0
113-hr-4148,L000397 Humane Cosmetics Act 113-hr-4148 L000397 Rep. Lofgren, Zoe [D-CA-19] D CA 2014-04-30 0
113-hr-4148,F000454 Humane Cosmetics Act 113-hr-4148 F000454 Rep. Foster, Bill [D-IL-11] D IL 2014-04-28 0
113-hr-4148,P000597 Humane Cosmetics Act 113-hr-4148 P000597 Rep. Pingree, Chellie [D-ME-1] D ME 2014-04-28 0
113-hr-4148,C001037 Humane Cosmetics Act 113-hr-4148 C001037 Rep. Capuano, Michael E. [D-MA-7] D MA 2014-04-28 0
113-hr-4148,D000191 Humane Cosmetics Act 113-hr-4148 D000191 Rep. DeFazio, Peter A. [D-OR-4] D OR 2014-04-28 0
113-hr-4148,M000725 Humane Cosmetics Act 113-hr-4148 M000725 Rep. Miller, George [D-CA-11] D CA 2014-04-28 0
113-hr-4148,S001150 Humane Cosmetics Act 113-hr-4148 S001150 Rep. Schiff, Adam B. [D-CA-28] D CA 2014-04-08 0
113-hr-4148,C000380 Humane Cosmetics Act 113-hr-4148 C000380 Del. Christensen, Donna M. [D-VI-At Large] D VI 2014-04-08 0
113-hr-4148,D000617 Humane Cosmetics Act 113-hr-4148 D000617 Rep. DelBene, Suzan K. [D-WA-1] D WA 2014-04-08 0
113-hr-4148,C001084 Humane Cosmetics Act 113-hr-4148 C001084 Rep. Cicilline, David N. [D-RI-1] D RI 2014-04-08 0
113-hr-4148,B001287 Humane Cosmetics Act 113-hr-4148 B001287 Rep. Bera, Ami [D-CA-7] D CA 2014-04-08 0
113-hr-4148,M000312 Humane Cosmetics Act 113-hr-4148 M000312 Rep. McGovern, James P. [D-MA-2] D MA 2014-04-01 0
113-hr-4148,B000574 Humane Cosmetics Act 113-hr-4148 B000574 Rep. Blumenauer, Earl [D-OR-3] D OR 2014-04-01 0
113-hr-4148,S000480 Humane Cosmetics Act 113-hr-4148 S000480 Rep. Slaughter, Louise McIntosh [D-NY-25] D NY 2014-04-01 0
113-hr-4148,C001097 Humane Cosmetics Act 113-hr-4148 C001097 Rep. Cárdenas, Tony [D-CA-29] D CA 2014-04-01 0
113-hr-4148,Q000023 Humane Cosmetics Act 113-hr-4148 Q000023 Rep. Quigley, Mike [D-IL-5] D IL 2014-04-01 0
113-hr-4148,D000610 Humane Cosmetics Act 113-hr-4148 D000610 Rep. Deutch, Theodore E. [D-FL-21] D FL 2014-04-01 0
113-hr-4148,L000551 Humane Cosmetics Act 113-hr-4148 L000551 Rep. Lee, Barbara [D-CA-13] D CA 2014-04-01 0
113-hr-4148,H001047 Humane Cosmetics Act 113-hr-4148 H001047 Rep. Himes, James A. [D-CT-4] D CT 2014-04-01 0
113-hr-4148,D000216 Humane Cosmetics Act 113-hr-4148 D000216 Rep. DeLauro, Rosa L. [D-CT-3] D CT 2014-03-24 0
113-hr-4148,J000288 Humane Cosmetics Act 113-hr-4148 J000288 Rep. Johnson, Henry C. "Hank," Jr. [D-GA-4] D GA 2014-03-24 0
113-hr-4148,C001080 Humane Cosmetics Act 113-hr-4148 C001080 Rep. Chu, Judy [D-CA-27] D CA 2014-03-24 0
113-hr-4148,C000714 Humane Cosmetics Act 113-hr-4148 C000714 Rep. Conyers, John, Jr. [D-MI-13] D MI 2014-03-24 0
113-hr-4148,C001101 Humane Cosmetics Act 113-hr-4148 C001101 Rep. Clark, Katherine M. [D-MA-5] D MA 2014-03-13 0
113-hr-4148,F000030 Humane Cosmetics Act 113-hr-4148 F000030 Rep. Farr, Sam [D-CA-20] D CA 2014-03-13 0
113-hr-4148,O000170 Humane Cosmetics Act 113-hr-4148 O000170 Rep. O'Rourke, Beto [D-TX-16] D TX 2014-03-13 0
113-hr-4148,S001162 Humane Cosmetics Act 113-hr-4148 S001162 Rep. Schwartz, Allyson Y. [D-PA-13] D PA 2014-03-13 0
113-hr-4148,T000266 Humane Cosmetics Act 113-hr-4148 T000266 Rep. Tierney, John F. [D-MA-6] D MA 2014-03-13 0
113-hr-4148,S001170 Humane Cosmetics Act 113-hr-4148 S001170 Rep. Shea-Porter, Carol [D-NH-1] D NH 2014-03-13 0
113-hr-4148,H001050 Humane Cosmetics Act 113-hr-4148 H001050 Rep. Hanabusa, Colleen W. [D-HI-1] D HI 2014-03-13 0
113-hr-4148,H001032 Humane Cosmetics Act 113-hr-4148 H001032 Rep. Holt, Rush [D-NJ-12] D NJ 2014-03-13 0
113-hr-4148,N000147 Humane Cosmetics Act 113-hr-4148 N000147 Del. Norton, Eleanor Holmes [D-DC-At Large] D DC 2014-03-11 0
113-hr-4148,J000126 Humane Cosmetics Act 113-hr-4148 J000126 Rep. Johnson, Eddie Bernice [D-TX-30] D TX 2014-03-11 0
113-hr-4148,R000053 Humane Cosmetics Act 113-hr-4148 R000053 Rep. Rangel, Charles B. [D-NY-13] D NY 2014-03-11 0
113-hr-4148,G000551 Humane Cosmetics Act 113-hr-4148 G000551 Rep. Grijalva, Raúl M. [D-AZ-3] D AZ 2014-03-11 0
113-hr-4148,W000808 Humane Cosmetics Act 113-hr-4148 W000808 Rep. Wilson, Frederica S. [D-FL-24] D FL 2014-03-11 0
113-hr-4148,T000468 Humane Cosmetics Act 113-hr-4148 T000468 Rep. Titus, Dina [D-NV-1] D NV 2014-03-11 0
113-hr-4148,C001068 Humane Cosmetics Act 113-hr-4148 C001068 Rep. Cohen, Steve [D-TN-9] D TN 2014-03-11 0
113-hr-4148,D000399 Humane Cosmetics Act 113-hr-4148 D000399 Rep. Doggett, Lloyd [D-TX-35] D TX 2014-03-11 0
113-hr-4148,H000324 Humane Cosmetics Act 113-hr-4148 H000324 Rep. Hastings, Alcee L. [D-FL-20] D FL 2014-03-11 0
113-hr-4148,G000569 Humane Cosmetics Act 113-hr-4148 G000569 Rep. Grimm, Michael G. [R-NY-11] R NY 2014-03-11 0

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 5.71ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API