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

26 rows where bill_id = "116-hr-4768" 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 17
  • 0 9
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
116-hr-4768,M000312 Home Visiting to Reduce Maternal Mortality and Morbidity Act 116-hr-4768 M000312 Rep. McGovern, James P. [D-MA-2] D MA 2020-01-08 0
116-hr-4768,C001124 Home Visiting to Reduce Maternal Mortality and Morbidity Act 116-hr-4768 C001124 Rep. Cox, TJ [D-CA-21] D CA 2020-01-07 0
116-hr-4768,L000397 Home Visiting to Reduce Maternal Mortality and Morbidity Act 116-hr-4768 L000397 Rep. Lofgren, Zoe [D-CA-19] D CA 2019-12-19 0
116-hr-4768,Q000023 Home Visiting to Reduce Maternal Mortality and Morbidity Act 116-hr-4768 Q000023 Rep. Quigley, Mike [D-IL-5] D IL 2019-11-26 0
116-hr-4768,K000381 Home Visiting to Reduce Maternal Mortality and Morbidity Act 116-hr-4768 K000381 Rep. Kilmer, Derek [D-WA-6] D WA 2019-11-20 0
116-hr-4768,P000607 Home Visiting to Reduce Maternal Mortality and Morbidity Act 116-hr-4768 P000607 Rep. Pocan, Mark [D-WI-2] D WI 2019-11-18 0
116-hr-4768,C001063 Home Visiting to Reduce Maternal Mortality and Morbidity Act 116-hr-4768 C001063 Rep. Cuellar, Henry [D-TX-28] D TX 2019-11-12 0
116-hr-4768,H001080 Home Visiting to Reduce Maternal Mortality and Morbidity Act 116-hr-4768 H001080 Rep. Haaland, Debra A. [D-NM-1] D NM 2019-11-12 0
116-hr-4768,G000585 Home Visiting to Reduce Maternal Mortality and Morbidity Act 116-hr-4768 G000585 Rep. Gomez, Jimmy [D-CA-34] D CA 2019-10-28 0
116-hr-4768,N000015 Home Visiting to Reduce Maternal Mortality and Morbidity Act 116-hr-4768 N000015 Rep. Neal, Richard E. [D-MA-1] D MA 2019-10-21 1
116-hr-4768,D000399 Home Visiting to Reduce Maternal Mortality and Morbidity Act 116-hr-4768 D000399 Rep. Doggett, Lloyd [D-TX-35] D TX 2019-10-21 1
116-hr-4768,B000574 Home Visiting to Reduce Maternal Mortality and Morbidity Act 116-hr-4768 B000574 Rep. Blumenauer, Earl [D-OR-3] D OR 2019-10-21 1
116-hr-4768,C001066 Home Visiting to Reduce Maternal Mortality and Morbidity Act 116-hr-4768 C001066 Rep. Castor, Kathy [D-FL-14] D FL 2019-10-21 1
116-hr-4768,C001080 Home Visiting to Reduce Maternal Mortality and Morbidity Act 116-hr-4768 C001080 Rep. Chu, Judy [D-CA-27] D CA 2019-10-21 1
116-hr-4768,D000197 Home Visiting to Reduce Maternal Mortality and Morbidity Act 116-hr-4768 D000197 Rep. DeGette, Diana [D-CO-1] D CO 2019-10-21 1
116-hr-4768,E000296 Home Visiting to Reduce Maternal Mortality and Morbidity Act 116-hr-4768 E000296 Rep. Evans, Dwight [D-PA-3] D PA 2019-10-21 1
116-hr-4768,H001038 Home Visiting to Reduce Maternal Mortality and Morbidity Act 116-hr-4768 H001038 Rep. Higgins, Brian [D-NY-26] D NY 2019-10-21 1
116-hr-4768,H001066 Home Visiting to Reduce Maternal Mortality and Morbidity Act 116-hr-4768 H001066 Rep. Horsford, Steven [D-NV-4] D NV 2019-10-21 1
116-hr-4768,K000380 Home Visiting to Reduce Maternal Mortality and Morbidity Act 116-hr-4768 K000380 Rep. Kildee, Daniel T. [D-MI-5] D MI 2019-10-21 1
116-hr-4768,L000557 Home Visiting to Reduce Maternal Mortality and Morbidity Act 116-hr-4768 L000557 Rep. Larson, John B. [D-CT-1] D CT 2019-10-21 1
116-hr-4768,L000287 Home Visiting to Reduce Maternal Mortality and Morbidity Act 116-hr-4768 L000287 Rep. Lewis, John [D-GA-5] D GA 2019-10-21 1
116-hr-4768,M001160 Home Visiting to Reduce Maternal Mortality and Morbidity Act 116-hr-4768 M001160 Rep. Moore, Gwen [D-WI-4] D WI 2019-10-21 1
116-hr-4768,P000096 Home Visiting to Reduce Maternal Mortality and Morbidity Act 116-hr-4768 P000096 Rep. Pascrell, Bill, Jr. [D-NJ-9] D NJ 2019-10-21 1
116-hr-4768,S001156 Home Visiting to Reduce Maternal Mortality and Morbidity Act 116-hr-4768 S001156 Rep. Sánchez, Linda T. [D-CA-38] D CA 2019-10-21 1
116-hr-4768,S001185 Home Visiting to Reduce Maternal Mortality and Morbidity Act 116-hr-4768 S001185 Rep. Sewell, Terri A. [D-AL-7] D AL 2019-10-21 1
116-hr-4768,S001201 Home Visiting to Reduce Maternal Mortality and Morbidity Act 116-hr-4768 S001201 Rep. Suozzi, Thomas R. [D-NY-3] D NY 2019-10-21 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);
Powered by Datasette · Queries took 8.497ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API