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

37 rows where bill_id = "100-hr-4002" 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 2

  • 1 24
  • 0 13
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
100-hr-4002,P000005 Child Care Services Improvement Act of 1988 100-hr-4002 P000005 Rep. Packard, Ron [R-CA-43] R CA 1988-05-18 0
100-hr-4002,L000243 Child Care Services Improvement Act of 1988 100-hr-4002 L000243 Rep. Lent, Norman F. [R-NY-4] R NY 1988-05-04 0
100-hr-4002,R000141 Child Care Services Improvement Act of 1988 100-hr-4002 R000141 Rep. Regula, Ralph [R-OH-16] R OH 1988-04-28 0
100-hr-4002,M000019 Child Care Services Improvement Act of 1988 100-hr-4002 M000019 Rep. Mack, Connie, III [R-FL-13] R FL 1988-04-19 0
100-hr-4002,S001075 Child Care Services Improvement Act of 1988 100-hr-4002 S001075 Rep. Sundquist, Don [R-TN-7] R TN 1988-04-13 0
100-hr-4002,C000174 Child Care Services Improvement Act of 1988 100-hr-4002 C000174 Rep. Carper, Thomas R. [D-DE-At Large] D DE 1988-03-29 0
100-hr-4002,B000403 Child Care Services Improvement Act of 1988 100-hr-4002 B000403 Rep. Bereuter, Doug [R-NE-1] R NE 1988-03-22 0
100-hr-4002,L000287 Child Care Services Improvement Act of 1988 100-hr-4002 L000287 Rep. Lewis, John [D-GA-5] D GA 1988-03-22 0
100-hr-4002,P000574 Child Care Services Improvement Act of 1988 100-hr-4002 P000574 Rep. Pursell, Carl D. [R-MI-2] R MI 1988-03-22 0
100-hr-4002,W000672 Child Care Services Improvement Act of 1988 100-hr-4002 W000672 Rep. Wolf, Frank R. [R-VA-10] R VA 1988-03-22 0
100-hr-4002,G000524 Child Care Services Improvement Act of 1988 100-hr-4002 G000524 Rep. Gunderson, Steve [R-WI-3] R WI 1988-03-03 0
100-hr-4002,H000814 Child Care Services Improvement Act of 1988 100-hr-4002 H000814 Rep. Houghton, Amo [R-NY-34] R NY 1988-03-03 0
100-hr-4002,B000586 Child Care Services Improvement Act of 1988 100-hr-4002 B000586 Rep. Boehlert, Sherwood [R-NY-25] R NY 1988-03-02 0
100-hr-4002,B001036 Child Care Services Improvement Act of 1988 100-hr-4002 B001036 Rep. Buechner, Jack [R-MO-2] R MO 1988-02-24 1
100-hr-4002,R000383 Child Care Services Improvement Act of 1988 100-hr-4002 R000383 Rep. Roe, Robert A. [D-NJ-8] D NJ 1988-02-24 1
100-hr-4002,S001144 Child Care Services Improvement Act of 1988 100-hr-4002 S001144 Rep. Shays, Christopher [R-CT-4] R CT 1988-02-24 1
100-hr-4002,S000795 Child Care Services Improvement Act of 1988 100-hr-4002 S000795 Rep. Stangeland, Arlan [R-MN-7] R MN 1988-02-24 1
100-hr-4002,P000097 Child Care Services Improvement Act of 1988 100-hr-4002 P000097 Rep. Pashayan, Charles, Jr. [R-CA-17] R CA 1988-02-24 1
100-hr-4002,S000675 Child Care Services Improvement Act of 1988 100-hr-4002 S000675 Rep. Solomon, Gerald B. H. [R-NY-24] R NY 1988-02-24 1
100-hr-4002,L000020 Child Care Services Improvement Act of 1988 100-hr-4002 L000020 Rep. Lagomarsino, Robert J. [R-CA-19] R CA 1988-02-24 1
100-hr-4002,C000523 Child Care Services Improvement Act of 1988 100-hr-4002 C000523 Rep. Clinger, William F., Jr. [R-PA-23] R PA 1988-02-24 1
100-hr-4002,S000143 Child Care Services Improvement Act of 1988 100-hr-4002 S000143 Rep. Schuette, Bill [R-MI-10] R MI 1988-02-24 1
100-hr-4002,C000293 Child Care Services Improvement Act of 1988 100-hr-4002 C000293 Rep. Chandler, Rod D. [R-WA-8] R WA 1988-02-24 1
100-hr-4002,S000463 Child Care Services Improvement Act of 1988 100-hr-4002 S000463 Rep. Skeen, Joe [R-NM-2] R NM 1988-02-24 1
100-hr-4002,M000736 Child Care Services Improvement Act of 1988 100-hr-4002 M000736 Rep. Miller, John R. [R-WA-1] R WA 1988-02-24 1
100-hr-4002,S000014 Child Care Services Improvement Act of 1988 100-hr-4002 S000014 Rep. Saiki, Patricia [R-HI-1] R HI 1988-02-24 1
100-hr-4002,H001022 Child Care Services Improvement Act of 1988 100-hr-4002 H001022 Rep. Hyde, Henry J. [R-IL-6] R IL 1988-02-24 1
100-hr-4002,H000586 Child Care Services Improvement Act of 1988 100-hr-4002 H000586 Rep. Hiler, John Patrick [R-IN-3] R IN 1988-02-24 1
100-hr-4002,S000109 Child Care Services Improvement Act of 1988 100-hr-4002 S000109 Rep. Schaefer, Dan [R-CO-6] R CO 1988-02-24 1
100-hr-4002,R000243 Child Care Services Improvement Act of 1988 100-hr-4002 R000243 Rep. Ridge, Thomas J. [R-PA-21] R PA 1988-02-24 1
100-hr-4002,K000309 Child Care Services Improvement Act of 1988 100-hr-4002 K000309 Rep. Konnyu, Ernest L. [R-CA-12] R CA 1988-02-24 1
100-hr-4002,U000031 Child Care Services Improvement Act of 1988 100-hr-4002 U000031 Rep. Upton, Fred [R-MI-4] R MI 1988-02-24 1
100-hr-4002,B000919 Child Care Services Improvement Act of 1988 100-hr-4002 B000919 Rep. Brown, Hank [R-CO-4] R CO 1988-02-24 1
100-hr-4002,M000195 Child Care Services Improvement Act of 1988 100-hr-4002 M000195 Rep. Martin, Lynn M. [R-IL-16] R IL 1988-02-24 1
100-hr-4002,G000417 Child Care Services Improvement Act of 1988 100-hr-4002 G000417 Rep. Green, S. William [R-NY-15] R NY 1988-02-24 1
100-hr-4002,F000141 Child Care Services Improvement Act of 1988 100-hr-4002 F000141 Rep. Fish, Hamilton, Jr. [R-NY-21] R NY 1988-02-24 1
100-hr-4002,W000237 Child Care Services Improvement Act of 1988 100-hr-4002 W000237 Rep. Weber, Vin [R-MN-2] R MN 1988-02-24 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);