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

48 rows where bill_id = "99-hr-4787" 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 26
  • 0 22
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
99-hr-4787,K000306 Child Care Act of 1986 99-hr-4787 K000306 Rep. Kolbe, Jim [R-AZ-5] R AZ 1986-10-15 0
99-hr-4787,M000303 Child Care Act of 1986 99-hr-4787 M000303 Rep. McCain, John [R-AZ-1] R AZ 1986-08-07 0
99-hr-4787,S000606 Child Care Act of 1986 99-hr-4787 S000606 Rep. Smith, Bob [R-NH-1] R NH 1986-08-05 0
99-hr-4787,M000432 Child Care Act of 1986 99-hr-4787 M000432 Rep. McEwen, Bob [R-OH-6] R OH 1986-07-31 0
99-hr-4787,P000097 Child Care Act of 1986 99-hr-4787 P000097 Rep. Pashayan, Charles, Jr. [R-CA-17] R CA 1986-07-30 0
99-hr-4787,H000747 Child Care Act of 1986 99-hr-4787 H000747 Rep. Holt, Marjorie S. [R-MD-4] R MD 1986-07-30 0
99-hr-4787,E000031 Child Care Act of 1986 99-hr-4787 E000031 Rep. Eckart, Dennis E. [D-OH-11] D OH 1986-07-30 0
99-hr-4787,H001022 Child Care Act of 1986 99-hr-4787 H001022 Rep. Hyde, Henry J. [R-IL-6] R IL 1986-07-29 0
99-hr-4787,S000607 Child Care Act of 1986 99-hr-4787 S000607 Rep. Smith, Robert [R-OR-2] R OR 1986-07-23 0
99-hr-4787,M000692 Child Care Act of 1986 99-hr-4787 M000692 Rep. Michel, Robert H. [R-IL-18] R IL 1986-07-23 0
99-hr-4787,L000447 Child Care Act of 1986 99-hr-4787 L000447 Rep. Lott, Trent [R-MS-5] R MS 1986-07-17 0
99-hr-4787,G000524 Child Care Act of 1986 99-hr-4787 G000524 Rep. Gunderson, Steve [R-WI-3] R WI 1986-06-17 0
99-hr-4787,W000237 Child Care Act of 1986 99-hr-4787 W000237 Rep. Weber, Vin [R-MN-2] R MN 1986-06-17 0
99-hr-4787,M000736 Child Care Act of 1986 99-hr-4787 M000736 Rep. Miller, John R. [R-WA-1] R WA 1986-06-17 0
99-hr-4787,W000752 Child Care Act of 1986 99-hr-4787 W000752 Rep. Wortley, George C. [R-NY-27] R NY 1986-06-05 0
99-hr-4787,B000410 Child Care Act of 1986 99-hr-4787 B000410 Rep. Berman, Howard L. [D-CA-26] D CA 1986-06-05 0
99-hr-4787,N000016 Child Care Act of 1986 99-hr-4787 N000016 Rep. Neal, Stephen L. [D-NC-5] D NC 1986-06-05 0
99-hr-4787,C000634 Child Care Act of 1986 99-hr-4787 C000634 Rep. Collins, Cardiss [D-IL-7] D IL 1986-05-20 0
99-hr-4787,G000120 Child Care Act of 1986 99-hr-4787 G000120 Rep. Gejdenson, Sam [D-CT-2] D CT 1986-05-15 0
99-hr-4787,L000020 Child Care Act of 1986 99-hr-4787 L000020 Rep. Lagomarsino, Robert J. [R-CA-19] R CA 1986-05-15 0
99-hr-4787,B000298 Child Care Act of 1986 99-hr-4787 B000298 Rep. Bedell, Berkley W. [D-IA-6] D IA 1986-05-15 0
99-hr-4787,D000209 Child Care Act of 1986 99-hr-4787 D000209 Del. de Lugo, Ron [D-VI-At Large] D VI 1986-05-15 0
99-hr-4787,G000349 Child Care Act of 1986 99-hr-4787 G000349 Rep. Gradison, Willis D., Jr. [R-OH-2] R OH 1986-05-08 1
99-hr-4787,C000293 Child Care Act of 1986 99-hr-4787 C000293 Rep. Chandler, Rod D. [R-WA-8] R WA 1986-05-08 1
99-hr-4787,C000523 Child Care Act of 1986 99-hr-4787 C000523 Rep. Clinger, William F., Jr. [R-PA-23] R PA 1986-05-08 1
99-hr-4787,C000542 Child Care Act of 1986 99-hr-4787 C000542 Rep. Coats, Daniel [R-IN-4] R IN 1986-05-08 1
99-hr-4787,C000174 Child Care Act of 1986 99-hr-4787 C000174 Rep. Carper, Thomas R. [D-DE-At Large] D DE 1986-05-08 1
99-hr-4787,C000709 Child Care Act of 1986 99-hr-4787 C000709 Rep. Conte, Silvio O. [R-MA-1] R MA 1986-05-08 1
99-hr-4787,C000807 Child Care Act of 1986 99-hr-4787 C000807 Rep. Coughlin, Lawrence [R-PA-13] R PA 1986-05-08 1
99-hr-4787,F000141 Child Care Act of 1986 99-hr-4787 F000141 Rep. Fish, Hamilton, Jr. [R-NY-21] R NY 1986-05-08 1
99-hr-4787,F000261 Child Care Act of 1986 99-hr-4787 F000261 Rep. Ford, Harold E. [D-TN-9] D TN 1986-05-08 1
99-hr-4787,F000380 Child Care Act of 1986 99-hr-4787 F000380 Rep. Frenzel, Bill [R-MN-3] R MN 1986-05-08 1
99-hr-4787,G000417 Child Care Act of 1986 99-hr-4787 G000417 Rep. Green, S. William [R-NY-15] R NY 1986-05-08 1
99-hr-4787,H000514 Child Care Act of 1986 99-hr-4787 H000514 Rep. Henry, Paul B. [R-MI-5] R MI 1986-05-08 1
99-hr-4787,H000624 Child Care Act of 1986 99-hr-4787 H000624 Rep. Hillis, Elwood H. [R-IN-5] R IN 1986-05-08 1
99-hr-4787,H000797 Child Care Act of 1986 99-hr-4787 H000797 Rep. Horton, Frank J. [R-NY-29] R NY 1986-05-08 1
99-hr-4787,I000029 Child Care Act of 1986 99-hr-4787 I000029 Rep. Ireland, Andrew P. [R-FL-10] R FL 1986-05-08 1
99-hr-4787,L000371 Child Care Act of 1986 99-hr-4787 L000371 Rep. Livingston, Bob [R-LA-1] R LA 1986-05-08 1
99-hr-4787,M000399 Child Care Act of 1986 99-hr-4787 M000399 Rep. McDade, Joseph M. [R-PA-10] R PA 1986-05-08 1
99-hr-4787,K000009 Child Care Act of 1986 99-hr-4787 K000009 Rep. Kaptur, Marcy [D-OH-9] D OH 1986-05-08 1
99-hr-4787,M000195 Child Care Act of 1986 99-hr-4787 M000195 Rep. Martin, Lynn M. [R-IL-16] R IL 1986-05-08 1
99-hr-4787,M000512 Child Care Act of 1986 99-hr-4787 M000512 Rep. McKernan, John R., Jr. [R-ME-1] R ME 1986-05-08 1
99-hr-4787,P000265 Child Care Act of 1986 99-hr-4787 P000265 Rep. Petri, Thomas E. [R-WI-6] R WI 1986-05-08 1
99-hr-4787,W000406 Child Care Act of 1986 99-hr-4787 W000406 Rep. Whitehurst, G. William [R-VA-2] R VA 1986-05-08 1
99-hr-4787,R000482 Child Care Act of 1986 99-hr-4787 R000482 Rep. Rowland, John G. [R-CT-5] R CT 1986-05-08 1
99-hr-4787,V000124 Child Care Act of 1986 99-hr-4787 V000124 Rep. Vucanovich, Barbara F. [R-NV-2] R NV 1986-05-08 1
99-hr-4787,R000243 Child Care Act of 1986 99-hr-4787 R000243 Rep. Ridge, Thomas J. [R-PA-21] R PA 1986-05-08 1
99-hr-4787,S000136 Child Care Act of 1986 99-hr-4787 S000136 Rep. Schneider, Claudine [R-RI-2] R RI 1986-05-08 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);