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

87 rows where bill_id = "99-hr-5000" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party, sponsorship_date, sponsorship_date (date)

is_original_cosponsor 2

  • 1 48
  • 0 39
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
99-hr-5000,Y000031 Child Protection Act of 1986 99-hr-5000 Y000031 Rep. Young, C. W. Bill [R-FL-8] R FL 1986-10-17 0
99-hr-5000,M000923 Child Protection Act of 1986 99-hr-5000 M000923 Rep. Moore, W. Henson [R-LA-6] R LA 1986-09-10 0
99-hr-5000,B000229 Child Protection Act of 1986 99-hr-5000 B000229 Rep. Bateman, Herbert H. [R-VA-1] R VA 1986-09-10 0
99-hr-5000,M000019 Child Protection Act of 1986 99-hr-5000 M000019 Rep. Mack, Connie, III [R-FL-13] R FL 1986-09-10 0
99-hr-5000,M000350 Child Protection Act of 1986 99-hr-5000 M000350 Rep. McCollum, Bill [R-FL-5] R FL 1986-09-10 0
99-hr-5000,L000305 Child Protection Act of 1986 99-hr-5000 L000305 Rep. Lightfoot, Jim [R-IA-5] R IA 1986-09-10 0
99-hr-5000,S000785 Child Protection Act of 1986 99-hr-5000 S000785 Rep. Stallings, Richard H. [D-ID-2] D ID 1986-09-10 0
99-hr-5000,H000840 Child Protection Act of 1986 99-hr-5000 H000840 Rep. Howard, James J. [D-NJ-3] D NJ 1986-08-12 0
99-hr-5000,K000016 Child Protection Act of 1986 99-hr-5000 K000016 Rep. Kasich, John R. [R-OH-12] R OH 1986-08-12 0
99-hr-5000,W000781 Child Protection Act of 1986 99-hr-5000 W000781 Rep. Wylie, Chalmers P. [R-OH-15] R OH 1986-08-12 0
99-hr-5000,M000702 Child Protection Act of 1986 99-hr-5000 M000702 Rep. Mikulski, Barbara A. [D-MD-3] D MD 1986-08-05 0
99-hr-5000,L000342 Child Protection Act of 1986 99-hr-5000 L000342 Rep. Lipinski, William O. [D-IL-5] D IL 1986-08-05 0
99-hr-5000,M000458 Child Protection Act of 1986 99-hr-5000 M000458 Rep. McGrath, Raymond J. [R-NY-5] R NY 1986-08-05 0
99-hr-5000,O000069 Child Protection Act of 1986 99-hr-5000 O000069 Rep. Olin, James R. [D-VA-6] D VA 1986-08-05 0
99-hr-5000,H000172 Child Protection Act of 1986 99-hr-5000 H000172 Rep. Hansen, James V. [R-UT-1] R UT 1986-07-31 0
99-hr-5000,S000522 Child Protection Act of 1986 99-hr-5000 S000522 Rep. Smith, Christopher H. [R-NJ-4] R NJ 1986-07-31 0
99-hr-5000,B001220 Child Protection Act of 1986 99-hr-5000 B001220 Rep. Byron, Beverly B. [D-MD-6] D MD 1986-07-31 0
99-hr-5000,P000097 Child Protection Act of 1986 99-hr-5000 P000097 Rep. Pashayan, Charles, Jr. [R-CA-17] R CA 1986-07-31 0
99-hr-5000,L000486 Child Protection Act of 1986 99-hr-5000 L000486 Rep. Lowry, Mike [D-WA-7] D WA 1986-07-29 0
99-hr-5000,S000143 Child Protection Act of 1986 99-hr-5000 S000143 Rep. Schuette, Bill [R-MI-10] R MI 1986-07-29 0
99-hr-5000,B000615 Child Protection Act of 1986 99-hr-5000 B000615 Rep. Boner, William H. [D-TN-5] D TN 1986-07-29 0
99-hr-5000,M000865 Child Protection Act of 1986 99-hr-5000 M000865 Rep. Montgomery, G. V. (Sonny) [D-MS-3] D MS 1986-07-29 0
99-hr-5000,K000009 Child Protection Act of 1986 99-hr-5000 K000009 Rep. Kaptur, Marcy [D-OH-9] D OH 1986-07-22 0
99-hr-5000,E000031 Child Protection Act of 1986 99-hr-5000 E000031 Rep. Eckart, Dennis E. [D-OH-11] D OH 1986-07-22 0
99-hr-5000,M001130 Child Protection Act of 1986 99-hr-5000 M001130 Rep. Myers, John T. [R-IN-7] R IN 1986-07-22 0
99-hr-5000,F000347 Child Protection Act of 1986 99-hr-5000 F000347 Rep. Franklin, William W. [R-MS-2] R MS 1986-07-22 0
99-hr-5000,I000029 Child Protection Act of 1986 99-hr-5000 I000029 Rep. Ireland, Andrew P. [R-FL-10] R FL 1986-07-22 0
99-hr-5000,S000393 Child Protection Act of 1986 99-hr-5000 S000393 Rep. Shumway, Norman D. [R-CA-14] R CA 1986-07-15 0
99-hr-5000,M000844 Child Protection Act of 1986 99-hr-5000 M000844 Rep. Mollohan, Alan B. [D-WV-1] D WV 1986-07-15 0
99-hr-5000,W000426 Child Protection Act of 1986 99-hr-5000 W000426 Rep. Whittaker, Bob [R-KS-5] R KS 1986-07-15 0
99-hr-5000,N000016 Child Protection Act of 1986 99-hr-5000 N000016 Rep. Neal, Stephen L. [D-NC-5] D NC 1986-07-15 0
99-hr-5000,B000298 Child Protection Act of 1986 99-hr-5000 B000298 Rep. Bedell, Berkley W. [D-IA-6] D IA 1986-07-15 0
99-hr-5000,D000359 Child Protection Act of 1986 99-hr-5000 D000359 Rep. DioGuardi, Joseph J. [R-NY-20] R NY 1986-06-26 0
99-hr-5000,S000081 Child Protection Act of 1986 99-hr-5000 S000081 Rep. Savage, Gus [D-IL-2] D IL 1986-06-25 0
99-hr-5000,W000570 Child Protection Act of 1986 99-hr-5000 W000570 Rep. Wilson, Charles [D-TX-2] D TX 1986-06-25 0
99-hr-5000,H000797 Child Protection Act of 1986 99-hr-5000 H000797 Rep. Horton, Frank J. [R-NY-29] R NY 1986-06-25 0
99-hr-5000,P000005 Child Protection Act of 1986 99-hr-5000 P000005 Rep. Packard, Ron [R-CA-43] R CA 1986-06-17 0
99-hr-5000,K000306 Child Protection Act of 1986 99-hr-5000 K000306 Rep. Kolbe, Jim [R-AZ-5] R AZ 1986-06-17 0
99-hr-5000,C000079 Child Protection Act of 1986 99-hr-5000 C000079 Rep. Campbell, Carroll A., Jr. [R-SC-4] R SC 1986-06-17 0
99-hr-5000,S000851 Child Protection Act of 1986 99-hr-5000 S000851 Rep. Stenholm, Charles W. [D-TX-17] D TX 1986-06-11 1
99-hr-5000,A000214 Child Protection Act of 1986 99-hr-5000 A000214 Rep. Applegate, Douglas [D-OH-18] D OH 1986-06-11 1
99-hr-5000,B000024 Child Protection Act of 1986 99-hr-5000 B000024 Rep. Badham, Robert E. [R-CA-40] R CA 1986-06-11 1
99-hr-5000,B000213 Child Protection Act of 1986 99-hr-5000 B000213 Rep. Barton, Joe [R-TX-6] R TX 1986-06-11 1
99-hr-5000,B000392 Child Protection Act of 1986 99-hr-5000 B000392 Rep. Bentley, Helen Delich [R-MD-2] R MD 1986-06-11 1
99-hr-5000,B000403 Child Protection Act of 1986 99-hr-5000 B000403 Rep. Bereuter, Doug [R-NE-1] R NE 1986-06-11 1
99-hr-5000,B000431 Child Protection Act of 1986 99-hr-5000 B000431 Rep. Bevill, Tom [D-AL-4] D AL 1986-06-11 1
99-hr-5000,B000463 Child Protection Act of 1986 99-hr-5000 B000463 Rep. Bilirakis, Michael [R-FL-9] R FL 1986-06-11 1
99-hr-5000,B000556 Child Protection Act of 1986 99-hr-5000 B000556 Rep. Bliley, Tom [R-VA-3] R VA 1986-06-11 1
99-hr-5000,B000997 Child Protection Act of 1986 99-hr-5000 B000997 Rep. Bryant, John W. [D-TX-5] D TX 1986-06-11 1
99-hr-5000,B001149 Child Protection Act of 1986 99-hr-5000 B001149 Rep. Burton, Dan [R-IN-6] R IN 1986-06-11 1
99-hr-5000,C000555 Child Protection Act of 1986 99-hr-5000 C000555 Rep. Cobey, William W. [R-NC-4] R NC 1986-06-11 1
99-hr-5000,D000044 Child Protection Act of 1986 99-hr-5000 D000044 Rep. Dannemeyer, William E. [R-CA-39] R CA 1986-06-11 1
99-hr-5000,D000065 Child Protection Act of 1986 99-hr-5000 D000065 Rep. Daub, Hal [R-NE-2] R NE 1986-06-11 1
99-hr-5000,D000209 Child Protection Act of 1986 99-hr-5000 D000209 Del. de Lugo, Ron [D-VI-At Large] D VI 1986-06-11 1
99-hr-5000,D000435 Child Protection Act of 1986 99-hr-5000 D000435 Rep. Dornan, Robert K. [R-CA-38] R CA 1986-06-11 1
99-hr-5000,D000466 Child Protection Act of 1986 99-hr-5000 D000466 Rep. Dowdy, Wayne [D-MS-4] D MS 1986-06-11 1
99-hr-5000,E000174 Child Protection Act of 1986 99-hr-5000 E000174 Rep. Emerson, Bill [R-MO-8] R MO 1986-06-11 1
99-hr-5000,F000049 Child Protection Act of 1986 99-hr-5000 F000049 Rep. Fawell, Harris W. [R-IL-13] R IL 1986-06-11 1
99-hr-5000,F000392 Child Protection Act of 1986 99-hr-5000 F000392 Rep. Frost, Martin [D-TX-24] D TX 1986-06-11 1
99-hr-5000,G000524 Child Protection Act of 1986 99-hr-5000 G000524 Rep. Gunderson, Steve [R-WI-3] R WI 1986-06-11 1
99-hr-5000,H000302 Child Protection Act of 1986 99-hr-5000 H000302 Rep. Hartnett, Thomas F. [R-SC-1] R SC 1986-06-11 1
99-hr-5000,H000981 Child Protection Act of 1986 99-hr-5000 H000981 Rep. Hunter, Duncan [R-CA-45] R CA 1986-06-11 1
99-hr-5000,H001022 Child Protection Act of 1986 99-hr-5000 H001022 Rep. Hyde, Henry J. [R-IL-6] R IL 1986-06-11 1
99-hr-5000,K000190 Child Protection Act of 1986 99-hr-5000 K000190 Rep. Kindness, Thomas N. [R-OH-8] R OH 1986-06-11 1
99-hr-5000,L000020 Child Protection Act of 1986 99-hr-5000 L000020 Rep. Lagomarsino, Robert J. [R-CA-19] R CA 1986-06-11 1
99-hr-5000,L000381 Child Protection Act of 1986 99-hr-5000 L000381 Rep. Lloyd, Marilyn [D-TN-3] D TN 1986-06-11 1
99-hr-5000,M000206 Child Protection Act of 1986 99-hr-5000 M000206 Rep. Martinez, Matthew G. [D-CA-30] D CA 1986-06-11 1
99-hr-5000,M000399 Child Protection Act of 1986 99-hr-5000 M000399 Rep. McDade, Joseph M. [R-PA-10] R PA 1986-06-11 1
99-hr-5000,M000566 Child Protection Act of 1986 99-hr-5000 M000566 Rep. McMillan, J. Alex [R-NC-9] R NC 1986-06-11 1
99-hr-5000,M000860 Child Protection Act of 1986 99-hr-5000 M000860 Rep. Monson, David S. [R-UT-2] R UT 1986-06-11 1
99-hr-5000,M000926 Child Protection Act of 1986 99-hr-5000 M000926 Rep. Moorhead, Carlos J. [R-CA-22] R CA 1986-06-11 1
99-hr-5000,N000106 Child Protection Act of 1986 99-hr-5000 N000106 Rep. Nielson, Howard C. [R-UT-3] R UT 1986-06-11 1
99-hr-5000,P000574 Child Protection Act of 1986 99-hr-5000 P000574 Rep. Pursell, Carl D. [R-MI-2] R MI 1986-06-11 1
99-hr-5000,R000243 Child Protection Act of 1986 99-hr-5000 R000243 Rep. Ridge, Thomas J. [R-PA-21] R PA 1986-06-11 1
99-hr-5000,S000606 Child Protection Act of 1986 99-hr-5000 S000606 Rep. Smith, Bob [R-NH-1] R NH 1986-06-11 1
99-hr-5000,S001122 Child Protection Act of 1986 99-hr-5000 S001122 Rep. Swindall, Patrick L. [R-GA-4] R GA 1986-06-11 1
99-hr-5000,T000317 Child Protection Act of 1986 99-hr-5000 T000317 Rep. Torricelli, Robert G. [D-NJ-9] D NJ 1986-06-11 1
99-hr-5000,V000006 Child Protection Act of 1986 99-hr-5000 V000006 Rep. Valentine, Tim [D-NC-2] D NC 1986-06-11 1
99-hr-5000,W000068 Child Protection Act of 1986 99-hr-5000 W000068 Rep. Walker, Robert S. [R-PA-16] R PA 1986-06-11 1
99-hr-5000,W000406 Child Protection Act of 1986 99-hr-5000 W000406 Rep. Whitehurst, G. William [R-VA-2] R VA 1986-06-11 1
99-hr-5000,W000752 Child Protection Act of 1986 99-hr-5000 W000752 Rep. Wortley, George C. [R-NY-27] R NY 1986-06-11 1
99-hr-5000,Y000051 Child Protection Act of 1986 99-hr-5000 Y000051 Rep. Young, Robert A. [D-MO-2] D MO 1986-06-11 1
99-hr-5000,L000295 Child Protection Act of 1986 99-hr-5000 L000295 Rep. Lewis, Thomas F. [R-FL-12] R FL 1986-06-11 1
99-hr-5000,E000077 Child Protection Act of 1986 99-hr-5000 E000077 Rep. Edwards, Mickey [R-OK-5] R OK 1986-06-11 1
99-hr-5000,N000095 Child Protection Act of 1986 99-hr-5000 N000095 Rep. Nichols, Bill [D-AL-3] D AL 1986-06-11 1
99-hr-5000,S000607 Child Protection Act of 1986 99-hr-5000 S000607 Rep. Smith, Robert [R-OR-2] R OR 1986-06-11 1
99-hr-5000,H000448 Child Protection Act of 1986 99-hr-5000 H000448 Rep. Hefner, W. G. (Bill) [D-NC-8] D NC 1986-06-11 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 794.678ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API