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

32 rows where bill_id = "103-hr-3201" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party, state, sponsorship_date (date)

is_original_cosponsor 1

  • 1 32
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
103-hr-3201,A000014 Comprehensive Early Childhood Education Act of 1993 103-hr-3201 A000014 Rep. Abercrombie, Neil [D-HI-1] D HI 1993-09-30 1
103-hr-3201,B000517 Comprehensive Early Childhood Education Act of 1993 103-hr-3201 B000517 Rep. Blackwell, Lucien E. [D-PA-2] D PA 1993-09-30 1
103-hr-3201,B000287 Comprehensive Early Childhood Education Act of 1993 103-hr-3201 B000287 Rep. Becerra, Xavier [D-CA-30] D CA 1993-09-30 1
103-hr-3201,B001213 Comprehensive Early Childhood Education Act of 1993 103-hr-3201 B001213 Rep. Byrne, Leslie L. [D-VA-11] D VA 1993-09-30 1
103-hr-3201,C000494 Comprehensive Early Childhood Education Act of 1993 103-hr-3201 C000494 Rep. Clayton, Eva M. [D-NC-1] D NC 1993-09-30 1
103-hr-3201,C000621 Comprehensive Early Childhood Education Act of 1993 103-hr-3201 C000621 Rep. Coleman, Ronald D. [D-TX-16] D TX 1993-09-30 1
103-hr-3201,C000634 Comprehensive Early Childhood Education Act of 1993 103-hr-3201 C000634 Rep. Collins, Cardiss [D-IL-7] D IL 1993-09-30 1
103-hr-3201,C000633 Comprehensive Early Childhood Education Act of 1993 103-hr-3201 C000633 Rep. Collins, Barbara-Rose [D-MI-15] D MI 1993-09-30 1
103-hr-3201,D000222 Comprehensive Early Childhood Education Act of 1993 103-hr-3201 D000222 Rep. Dellums, Ronald V. [D-CA-9] D CA 1993-09-30 1
103-hr-3201,D000209 Comprehensive Early Childhood Education Act of 1993 103-hr-3201 D000209 Del. de Lugo, Ron [D-VI-At Large] D VI 1993-09-30 1
103-hr-3201,E000064 Comprehensive Early Childhood Education Act of 1993 103-hr-3201 E000064 Rep. Edwards, Don [D-CA-16] D CA 1993-09-30 1
103-hr-3201,F000010 Comprehensive Early Childhood Education Act of 1993 103-hr-3201 F000010 Del. Faleomavaega, Eni F. H. [D-AS-At Large] D AS 1993-09-30 1
103-hr-3201,F000116 Comprehensive Early Childhood Education Act of 1993 103-hr-3201 F000116 Rep. Filner, Bob [D-CA-50] D CA 1993-09-30 1
103-hr-3201,G000212 Comprehensive Early Childhood Education Act of 1993 103-hr-3201 G000212 Rep. Gilman, Benjamin A. [R-NY-20] R NY 1993-09-30 1
103-hr-3201,K000118 Comprehensive Early Childhood Education Act of 1993 103-hr-3201 K000118 Rep. Kennelly, Barbara B. [D-CT-1] D CT 1993-09-30 1
103-hr-3201,M000206 Comprehensive Early Childhood Education Act of 1993 103-hr-3201 M000206 Rep. Martinez, Matthew G. [D-CA-31] D CA 1993-09-30 1
103-hr-3201,M000249 Comprehensive Early Childhood Education Act of 1993 103-hr-3201 M000249 Rep. Matsui, Robert T. [D-CA-5] D CA 1993-09-30 1
103-hr-3201,M000523 Comprehensive Early Childhood Education Act of 1993 103-hr-3201 M000523 Rep. McKinney, Cynthia A. [D-GA-11] D GA 1993-09-30 1
103-hr-3201,M000725 Comprehensive Early Childhood Education Act of 1993 103-hr-3201 M000725 Rep. Miller, George [D-CA-7] D CA 1993-09-30 1
103-hr-3201,M000794 Comprehensive Early Childhood Education Act of 1993 103-hr-3201 M000794 Rep. Mineta, Norman Y. [D-CA-15] D CA 1993-09-30 1
103-hr-3201,N000002 Comprehensive Early Childhood Education Act of 1993 103-hr-3201 N000002 Rep. Nadler, Jerrold [D-NY-8] D NY 1993-09-30 1
103-hr-3201,O000159 Comprehensive Early Childhood Education Act of 1993 103-hr-3201 O000159 Rep. Owens, Major R. [D-NY-11] D NY 1993-09-30 1
103-hr-3201,P000197 Comprehensive Early Childhood Education Act of 1993 103-hr-3201 P000197 Rep. Pelosi, Nancy [D-CA-8] D CA 1993-09-30 1
103-hr-3201,R000053 Comprehensive Early Childhood Education Act of 1993 103-hr-3201 R000053 Rep. Rangel, Charles B. [D-NY-15] D NY 1993-09-30 1
103-hr-3201,S000033 Comprehensive Early Childhood Education Act of 1993 103-hr-3201 S000033 Rep. Sanders, Bernard [I-VT-At Large] I VT 1993-09-30 1
103-hr-3201,S000480 Comprehensive Early Childhood Education Act of 1993 103-hr-3201 S000480 Rep. Slaughter, Louise McIntosh [D-NY-28] D NY 1993-09-30 1
103-hr-3201,T000326 Comprehensive Early Childhood Education Act of 1993 103-hr-3201 T000326 Rep. Towns, Edolphus [D-NY-10] D NY 1993-09-30 1
103-hr-3201,T000405 Comprehensive Early Childhood Education Act of 1993 103-hr-3201 T000405 Rep. Tucker, Walter R., III [D-CA-37] D CA 1993-09-30 1
103-hr-3201,U000017 Comprehensive Early Childhood Education Act of 1993 103-hr-3201 U000017 Rep. Unsoeld, Jolene [D-WA-3] D WA 1993-09-30 1
103-hr-3201,W000177 Comprehensive Early Childhood Education Act of 1993 103-hr-3201 W000177 Rep. Washington, Craig A. [D-TX-18] D TX 1993-09-30 1
103-hr-3201,W000187 Comprehensive Early Childhood Education Act of 1993 103-hr-3201 W000187 Rep. Waters, Maxine [D-CA-35] D CA 1993-09-30 1
103-hr-3201,W000738 Comprehensive Early Childhood Education Act of 1993 103-hr-3201 W000738 Rep. Woolsey, Lynn C. [D-CA-6] D CA 1993-09-30 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 69.608ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API