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

68 rows where bill_id = "102-hr-4585" 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

  • 0 63
  • 1 5
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
102-hr-4585,S001144 National Child Protection Act of 1992 102-hr-4585 S001144 Rep. Shays, Christopher [R-CT-4] R CT 1992-10-02 0
102-hr-4585,D000051 National Child Protection Act of 1992 102-hr-4585 D000051 Rep. Darden, George (Buddy) [D-GA-7] D GA 1992-10-01 0
102-hr-4585,R000080 National Child Protection Act of 1992 102-hr-4585 R000080 Rep. Ray, Richard B. [D-GA-3] D GA 1992-10-01 0
102-hr-4585,K000172 National Child Protection Act of 1992 102-hr-4585 K000172 Rep. Kildee, Dale E. [D-MI-7] D MI 1992-10-01 0
102-hr-4585,S000607 National Child Protection Act of 1992 102-hr-4585 S000607 Rep. Smith, Robert [R-OR-2] R OR 1992-08-12 0
102-hr-4585,P000523 National Child Protection Act of 1992 102-hr-4585 P000523 Rep. Price, David E. [D-NC-4] D NC 1992-08-04 0
102-hr-4585,H000547 National Child Protection Act of 1992 102-hr-4585 H000547 Rep. Hertel, Dennis M. [D-MI-14] D MI 1992-08-04 0
102-hr-4585,J000163 National Child Protection Act of 1992 102-hr-4585 J000163 Rep. Johnson, Nancy L. [R-CT-6] R CT 1992-08-04 0
102-hr-4585,M000687 National Child Protection Act of 1992 102-hr-4585 M000687 Rep. Mfume, Kweisi [D-MD-7] D MD 1992-08-04 0
102-hr-4585,S000810 National Child Protection Act of 1992 102-hr-4585 S000810 Rep. Stark, Fortney Pete [D-CA-9] D CA 1992-08-04 0
102-hr-4585,A000022 National Child Protection Act of 1992 102-hr-4585 A000022 Rep. Ackerman, Gary L. [D-NY-7] D NY 1992-08-04 0
102-hr-4585,C000077 National Child Protection Act of 1992 102-hr-4585 C000077 Rep. Campbell, Ben Nighthorse [D-CO-3] D CO 1992-07-24 0
102-hr-4585,H000930 National Child Protection Act of 1992 102-hr-4585 H000930 Rep. Hughes, William J. [D-NJ-2] D NJ 1992-07-24 0
102-hr-4585,C000488 National Child Protection Act of 1992 102-hr-4585 C000488 Rep. Clay, William (Bill) [D-MO-1] D MO 1992-07-24 0
102-hr-4585,S000948 National Child Protection Act of 1992 102-hr-4585 S000948 Rep. Stokes, Louis [D-OH-21] D OH 1992-07-24 0
102-hr-4585,L000556 National Child Protection Act of 1992 102-hr-4585 L000556 Rep. LaFalce, John J. [D-NY-32] D NY 1992-07-24 0
102-hr-4585,S000407 National Child Protection Act of 1992 102-hr-4585 S000407 Rep. Sikorski, Gerry E. [D-MN-6] D MN 1992-07-24 0
102-hr-4585,C000714 National Child Protection Act of 1992 102-hr-4585 C000714 Rep. Conyers, John, Jr. [D-MI-1] D MI 1992-07-24 0
102-hr-4585,R000011 National Child Protection Act of 1992 102-hr-4585 R000011 Rep. Rahall, Nick J., II [D-WV-4] D WV 1992-07-24 0
102-hr-4585,R000053 National Child Protection Act of 1992 102-hr-4585 R000053 Rep. Rangel, Charles B. [D-NY-16] D NY 1992-07-24 0
102-hr-4585,W000326 National Child Protection Act of 1992 102-hr-4585 W000326 Rep. Wheat, Alan [D-MO-5] D MO 1992-07-02 0
102-hr-4585,R000072 National Child Protection Act of 1992 102-hr-4585 R000072 Rep. Ravenel, Arthur, Jr. [R-SC-1] R SC 1992-07-02 0
102-hr-4585,E000201 National Child Protection Act of 1992 102-hr-4585 E000201 Rep. Erdreich, Ben [D-AL-6] D AL 1992-07-02 0
102-hr-4585,P000197 National Child Protection Act of 1992 102-hr-4585 P000197 Rep. Pelosi, Nancy [D-CA-5] D CA 1992-07-02 0
102-hr-4585,G000153 National Child Protection Act of 1992 102-hr-4585 G000153 Rep. Gibbons, Sam [D-FL-7] D FL 1992-07-02 0
102-hr-4585,J000033 National Child Protection Act of 1992 102-hr-4585 J000033 Rep. Jacobs, Andrew, Jr. [D-IN-10] D IN 1992-07-02 0
102-hr-4585,D000373 National Child Protection Act of 1992 102-hr-4585 D000373 Rep. Dixon, Julian C. [D-CA-28] D CA 1992-07-02 0
102-hr-4585,H000388 National Child Protection Act of 1992 102-hr-4585 H000388 Rep. Hayes, Charles A. [D-IL-1] D IL 1992-07-02 0
102-hr-4585,H000236 National Child Protection Act of 1992 102-hr-4585 H000236 Rep. Harris, Claude [D-AL-7] D AL 1992-07-02 0
102-hr-4585,W000215 National Child Protection Act of 1992 102-hr-4585 W000215 Rep. Waxman, Henry A. [D-CA-24] D CA 1992-06-11 0
102-hr-4585,H000670 National Child Protection Act of 1992 102-hr-4585 H000670 Rep. Hochbrueckner, George J. [D-NY-1] D NY 1992-06-11 0
102-hr-4585,F000235 National Child Protection Act of 1992 102-hr-4585 F000235 Rep. Foglietta, Thomas M. [D-PA-1] D PA 1992-06-11 0
102-hr-4585,J000211 National Child Protection Act of 1992 102-hr-4585 J000211 Rep. Jones, Ben [D-GA-4] D GA 1992-05-20 0
102-hr-4585,L000371 National Child Protection Act of 1992 102-hr-4585 L000371 Rep. Livingston, Bob [R-LA-1] R LA 1992-05-20 0
102-hr-4585,E000250 National Child Protection Act of 1992 102-hr-4585 E000250 Rep. Evans, Lane [D-IL-17] D IL 1992-05-20 0
102-hr-4585,A000226 National Child Protection Act of 1992 102-hr-4585 A000226 Rep. Atkins, Chester G. [D-MA-5] D MA 1992-05-20 0
102-hr-4585,D000222 National Child Protection Act of 1992 102-hr-4585 D000222 Rep. Dellums, Ronald V. [D-CA-8] D CA 1992-05-20 0
102-hr-4585,N000147 National Child Protection Act of 1992 102-hr-4585 N000147 Del. Norton, Eleanor Holmes [D-DC-At Large] D DC 1992-05-20 0
102-hr-4585,L000045 National Child Protection Act of 1992 102-hr-4585 L000045 Rep. Lancaster, H. Martin [D-NC-3] D NC 1992-05-20 0
102-hr-4585,W000779 National Child Protection Act of 1992 102-hr-4585 W000779 Rep. Wyden, Ron [D-OR-3] D OR 1992-04-29 0
102-hr-4585,Y000013 National Child Protection Act of 1992 102-hr-4585 Y000013 Rep. Yates, Sidney R. [D-IL-9] D IL 1992-04-29 0
102-hr-4585,O000159 National Child Protection Act of 1992 102-hr-4585 O000159 Rep. Owens, Major R. [D-NY-12] D NY 1992-04-29 0
102-hr-4585,G000417 National Child Protection Act of 1992 102-hr-4585 G000417 Rep. Green, S. William [R-NY-15] R NY 1992-04-29 0
102-hr-4585,E000218 National Child Protection Act of 1992 102-hr-4585 E000218 Rep. Espy, Mike [D-MS-2] D MS 1992-04-29 0
102-hr-4585,W000682 National Child Protection Act of 1992 102-hr-4585 W000682 Rep. Wolpe, Howard E. [D-MI-3] D MI 1992-04-29 0
102-hr-4585,L000342 National Child Protection Act of 1992 102-hr-4585 L000342 Rep. Lipinski, William O. [D-IL-5] D IL 1992-04-29 0
102-hr-4585,F000261 National Child Protection Act of 1992 102-hr-4585 F000261 Rep. Ford, Harold E. [D-TN-9] D TN 1992-04-29 0
102-hr-4585,L000225 National Child Protection Act of 1992 102-hr-4585 L000225 Rep. Lehman, Richard H. [D-CA-18] D CA 1992-04-29 0
102-hr-4585,M001057 National Child Protection Act of 1992 102-hr-4585 M001057 Rep. Mrazek, Robert J. [D-NY-3] D NY 1992-04-29 0
102-hr-4585,M000736 National Child Protection Act of 1992 102-hr-4585 M000736 Rep. Miller, John R. [R-WA-1] R WA 1992-04-29 0
102-hr-4585,H000797 National Child Protection Act of 1992 102-hr-4585 H000797 Rep. Horton, Frank J. [R-NY-29] R NY 1992-04-29 0
102-hr-4585,M000206 National Child Protection Act of 1992 102-hr-4585 M000206 Rep. Martinez, Matthew G. [D-CA-30] D CA 1992-04-29 0
102-hr-4585,S000480 National Child Protection Act of 1992 102-hr-4585 S000480 Rep. Slaughter, Louise McIntosh [D-NY-30] D NY 1992-04-29 0
102-hr-4585,M000566 National Child Protection Act of 1992 102-hr-4585 M000566 Rep. McMillan, J. Alex [R-NC-9] R NC 1992-04-29 0
102-hr-4585,W000258 National Child Protection Act of 1992 102-hr-4585 W000258 Rep. Weiss, Ted [D-NY-17] D NY 1992-04-29 0
102-hr-4585,U000017 National Child Protection Act of 1992 102-hr-4585 U000017 Rep. Unsoeld, Jolene [D-WA-3] D WA 1992-04-29 0
102-hr-4585,B000711 National Child Protection Act of 1992 102-hr-4585 B000711 Rep. Boxer, Barbara [D-CA-6] D CA 1992-04-29 0
102-hr-4585,B000517 National Child Protection Act of 1992 102-hr-4585 B000517 Rep. Blackwell, Lucien E. [D-PA-2] D PA 1992-04-29 0
102-hr-4585,G000511 National Child Protection Act of 1992 102-hr-4585 G000511 Rep. Guarini, Frank J. [D-NJ-14] D NJ 1992-04-29 0
102-hr-4585,S000248 National Child Protection Act of 1992 102-hr-4585 S000248 Rep. Serrano, Jose E. [D-NY-18] D NY 1992-04-29 0
102-hr-4585,G000134 National Child Protection Act of 1992 102-hr-4585 G000134 Rep. Geren, Pete [D-TX-12] D TX 1992-04-29 0
102-hr-4585,L000264 National Child Protection Act of 1992 102-hr-4585 L000264 Rep. Levine, Mel [D-CA-27] D CA 1992-04-29 0
102-hr-4585,P000229 National Child Protection Act of 1992 102-hr-4585 P000229 Rep. Perkins, Carl C. [D-KY-7] D KY 1992-04-29 0
102-hr-4585,E000064 National Child Protection Act of 1992 102-hr-4585 E000064 Rep. Edwards, Don [D-CA-10] D CA 1992-03-25 1
102-hr-4585,C000868 National Child Protection Act of 1992 102-hr-4585 C000868 Rep. Cramer, Robert E. (Bud), Jr. [D-AL-5] D AL 1992-03-25 1
102-hr-4585,J000047 National Child Protection Act of 1992 102-hr-4585 J000047 Rep. James, Craig T. [R-FL-4] R FL 1992-03-25 1
102-hr-4585,K000312 National Child Protection Act of 1992 102-hr-4585 K000312 Rep. Kopetski, Mike [D-OR-5] D OR 1992-03-25 1
102-hr-4585,R000033 National Child Protection Act of 1992 102-hr-4585 R000033 Rep. Ramstad, Jim [R-MN-3] R MN 1992-03-25 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);