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

53 rows where bill_id = "99-hr-3833" 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 33
  • 0 20
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
99-hr-3833,R000277 National Conference on Cities and Towns Act 99-hr-3833 R000277 Rep. Ritter, Don [R-PA-15] R PA 1986-04-15 0
99-hr-3833,E000077 National Conference on Cities and Towns Act 99-hr-3833 E000077 Rep. Edwards, Mickey [R-OK-5] R OK 1986-03-13 0
99-hr-3833,O000006 National Conference on Cities and Towns Act 99-hr-3833 O000006 Rep. Oberstar, James L. [D-MN-8] D MN 1986-03-06 0
99-hr-3833,W000647 National Conference on Cities and Towns Act 99-hr-3833 W000647 Rep. Wirth, Timothy [D-CO-2] D CO 1986-03-05 0
99-hr-3833,L000342 National Conference on Cities and Towns Act 99-hr-3833 L000342 Rep. Lipinski, William O. [D-IL-5] D IL 1986-02-20 0
99-hr-3833,Y000033 National Conference on Cities and Towns Act 99-hr-3833 Y000033 Rep. Young, Don [R-AK-At Large] R AK 1986-02-20 0
99-hr-3833,D000051 National Conference on Cities and Towns Act 99-hr-3833 D000051 Rep. Darden, George (Buddy) [D-GA-7] D GA 1986-02-19 0
99-hr-3833,M000206 National Conference on Cities and Towns Act 99-hr-3833 M000206 Rep. Martinez, Matthew G. [D-CA-30] D CA 1986-02-19 0
99-hr-3833,A000214 National Conference on Cities and Towns Act 99-hr-3833 A000214 Rep. Applegate, Douglas [D-OH-18] D OH 1986-02-18 0
99-hr-3833,C000079 National Conference on Cities and Towns Act 99-hr-3833 C000079 Rep. Campbell, Carroll A., Jr. [R-SC-4] R SC 1986-02-18 0
99-hr-3833,L000516 National Conference on Cities and Towns Act 99-hr-3833 L000516 Rep. Lundine, Stanley N. [D-NY-34] D NY 1986-02-18 0
99-hr-3833,M000342 National Conference on Cities and Towns Act 99-hr-3833 M000342 Rep. McCloskey, Frank [D-IN-8] D IN 1986-02-18 0
99-hr-3833,R000011 National Conference on Cities and Towns Act 99-hr-3833 R000011 Rep. Rahall, Nick J., II [D-WV-4] D WV 1986-02-18 0
99-hr-3833,R000146 National Conference on Cities and Towns Act 99-hr-3833 R000146 Rep. Reid, Harry [D-NV-1] D NV 1986-02-18 0
99-hr-3833,S000586 National Conference on Cities and Towns Act 99-hr-3833 S000586 Rep. Smith, Lawrence [D-FL-16] D FL 1986-02-18 0
99-hr-3833,V000006 National Conference on Cities and Towns Act 99-hr-3833 V000006 Rep. Valentine, Tim [D-NC-2] D NC 1986-02-06 0
99-hr-3833,S000785 National Conference on Cities and Towns Act 99-hr-3833 S000785 Rep. Stallings, Richard H. [D-ID-2] D ID 1986-02-05 0
99-hr-3833,B000592 National Conference on Cities and Towns Act 99-hr-3833 B000592 Rep. Boggs, Corinne C. (Lindy) [D-LA-2] D LA 1986-02-05 0
99-hr-3833,M000249 National Conference on Cities and Towns Act 99-hr-3833 M000249 Rep. Matsui, Robert T. [D-CA-3] D CA 1986-02-05 0
99-hr-3833,F000053 National Conference on Cities and Towns Act 99-hr-3833 F000053 Rep. Fazio, Vic [D-CA-4] D CA 1986-02-04 0
99-hr-3833,A000052 National Conference on Cities and Towns Act 99-hr-3833 A000052 Rep. Addabbo, Joseph P. [D-NY-6] D NY 1985-12-02 1
99-hr-3833,B000298 National Conference on Cities and Towns Act 99-hr-3833 B000298 Rep. Bedell, Berkley W. [D-IA-6] D IA 1985-12-02 1
99-hr-3833,B000431 National Conference on Cities and Towns Act 99-hr-3833 B000431 Rep. Bevill, Tom [D-AL-4] D AL 1985-12-02 1
99-hr-3833,B000463 National Conference on Cities and Towns Act 99-hr-3833 B000463 Rep. Bilirakis, Michael [R-FL-9] R FL 1985-12-02 1
99-hr-3833,B000644 National Conference on Cities and Towns Act 99-hr-3833 B000644 Rep. Borski, Robert A. [D-PA-3] D PA 1985-12-02 1
99-hr-3833,B000997 National Conference on Cities and Towns Act 99-hr-3833 B000997 Rep. Bryant, John W. [D-TX-5] D TX 1985-12-02 1
99-hr-3833,C000581 National Conference on Cities and Towns Act 99-hr-3833 C000581 Rep. Coelho, Anthony Lee [D-CA-15] D CA 1985-12-02 1
99-hr-3833,C000754 National Conference on Cities and Towns Act 99-hr-3833 C000754 Rep. Cooper, Jim [D-TN-4] D TN 1985-12-02 1
99-hr-3833,C000919 National Conference on Cities and Towns Act 99-hr-3833 C000919 Rep. Crockett, George W., Jr. [D-MI-13] D MI 1985-12-02 1
99-hr-3833,D000064 National Conference on Cities and Towns Act 99-hr-3833 D000064 Rep. Daschle, Thomas A. [D-SD-At Large] D SD 1985-12-02 1
99-hr-3833,D000203 National Conference on Cities and Towns Act 99-hr-3833 D000203 Rep. de la Garza, E. [D-TX-15] D TX 1985-12-02 1
99-hr-3833,D000534 National Conference on Cities and Towns Act 99-hr-3833 D000534 Rep. Duncan, John J. [R-TN-2] R TN 1985-12-02 1
99-hr-3833,F000041 National Conference on Cities and Towns Act 99-hr-3833 F000041 Rep. Fascell, Dante B. [D-FL-19] D FL 1985-12-02 1
99-hr-3833,F000261 National Conference on Cities and Towns Act 99-hr-3833 F000261 Rep. Ford, Harold E. [D-TN-9] D TN 1985-12-02 1
99-hr-3833,G000309 National Conference on Cities and Towns Act 99-hr-3833 G000309 Rep. Gordon, Bart [D-TN-6] D TN 1985-12-02 1
99-hr-3833,H000388 National Conference on Cities and Towns Act 99-hr-3833 H000388 Rep. Hayes, Charles A. [D-IL-1] D IL 1985-12-02 1
99-hr-3833,H000797 National Conference on Cities and Towns Act 99-hr-3833 H000797 Rep. Horton, Frank J. [R-NY-29] R NY 1985-12-02 1
99-hr-3833,H000874 National Conference on Cities and Towns Act 99-hr-3833 H000874 Rep. Hoyer, Steny H. [D-MD-5] D MD 1985-12-02 1
99-hr-3833,H000930 National Conference on Cities and Towns Act 99-hr-3833 H000930 Rep. Hughes, William J. [D-NJ-2] D NJ 1985-12-02 1
99-hr-3833,J000216 National Conference on Cities and Towns Act 99-hr-3833 J000216 Rep. Jones, Ed [D-TN-8] D TN 1985-12-02 1
99-hr-3833,K000307 National Conference on Cities and Towns Act 99-hr-3833 K000307 Rep. Kolter, Joseph P. [D-PA-4] D PA 1985-12-02 1
99-hr-3833,L000381 National Conference on Cities and Towns Act 99-hr-3833 L000381 Rep. Lloyd, Marilyn [D-TN-3] D TN 1985-12-02 1
99-hr-3833,M000844 National Conference on Cities and Towns Act 99-hr-3833 M000844 Rep. Mollohan, Alan B. [D-WV-1] D WV 1985-12-02 1
99-hr-3833,Q000013 National Conference on Cities and Towns Act 99-hr-3833 Q000013 Rep. Quillen, James H. (Jimmy) [R-TN-1] R TN 1985-12-02 1
99-hr-3833,R000053 National Conference on Cities and Towns Act 99-hr-3833 R000053 Rep. Rangel, Charles B. [D-NY-16] D NY 1985-12-02 1
99-hr-3833,S000005 National Conference on Cities and Towns Act 99-hr-3833 S000005 Rep. Sabo, Martin Olav [D-MN-5] D MN 1985-12-02 1
99-hr-3833,S000453 National Conference on Cities and Towns Act 99-hr-3833 S000453 Rep. Sisisky, Norman [D-VA-4] D VA 1985-12-02 1
99-hr-3833,S000810 National Conference on Cities and Towns Act 99-hr-3833 S000810 Rep. Stark, Fortney Pete [D-CA-9] D CA 1985-12-02 1
99-hr-3833,S001075 National Conference on Cities and Towns Act 99-hr-3833 S001075 Rep. Sundquist, Don [R-TN-7] R TN 1985-12-02 1
99-hr-3833,T000326 National Conference on Cities and Towns Act 99-hr-3833 T000326 Rep. Towns, Edolphus [D-NY-11] D NY 1985-12-02 1
99-hr-3833,T000350 National Conference on Cities and Towns Act 99-hr-3833 T000350 Rep. Traficant, James A., Jr. [D-OH-17] D OH 1985-12-02 1
99-hr-3833,W000752 National Conference on Cities and Towns Act 99-hr-3833 W000752 Rep. Wortley, George C. [R-NY-27] R NY 1985-12-02 1
99-hr-3833,D000209 National Conference on Cities and Towns Act 99-hr-3833 D000209 Del. de Lugo, Ron [D-VI-At Large] D VI 1985-12-02 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);