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

192 rows where bill_id = "99-hr-4142" 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

  • 0 182
  • 1 10
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
99-hr-4142,B000615 General Aviation Tort Reform Act of 1986 99-hr-4142 B000615 Rep. Boner, William H. [D-TN-5] D TN 1986-10-06 0
99-hr-4142,S000622 General Aviation Tort Reform Act of 1986 99-hr-4142 S000622 Rep. Smith, Virginia [R-NE-3] R NE 1986-10-06 0
99-hr-4142,V000027 General Aviation Tort Reform Act of 1986 99-hr-4142 V000027 Rep. Vander Jagt, Guy [R-MI-9] R MI 1986-10-06 0
99-hr-4142,H000074 General Aviation Tort Reform Act of 1986 99-hr-4142 H000074 Rep. Hall, Tony P. [D-OH-3] D OH 1986-10-06 0
99-hr-4142,L000447 General Aviation Tort Reform Act of 1986 99-hr-4142 L000447 Rep. Lott, Trent [R-MS-5] R MS 1986-10-06 0
99-hr-4142,P000215 General Aviation Tort Reform Act of 1986 99-hr-4142 P000215 Rep. Penny, Timothy J. [D-MN-1] D MN 1986-10-06 0
99-hr-4142,Z000014 General Aviation Tort Reform Act of 1986 99-hr-4142 Z000014 Rep. Zschau, Edwin V. W. [R-CA-12] R CA 1986-10-06 0
99-hr-4142,D000326 General Aviation Tort Reform Act of 1986 99-hr-4142 D000326 Rep. Dickinson, William L. [R-AL-2] R AL 1986-10-06 0
99-hr-4142,H000878 General Aviation Tort Reform Act of 1986 99-hr-4142 H000878 Rep. Hubbard, Carroll, Jr. [D-KY-1] D KY 1986-10-06 0
99-hr-4142,C000174 General Aviation Tort Reform Act of 1986 99-hr-4142 C000174 Rep. Carper, Thomas R. [D-DE-At Large] D DE 1986-10-06 0
99-hr-4142,B000657 General Aviation Tort Reform Act of 1986 99-hr-4142 B000657 Rep. Boucher, Rick [D-VA-9] D VA 1986-09-18 0
99-hr-4142,M000512 General Aviation Tort Reform Act of 1986 99-hr-4142 M000512 Rep. McKernan, John R., Jr. [R-ME-1] R ME 1986-09-18 0
99-hr-4142,T000075 General Aviation Tort Reform Act of 1986 99-hr-4142 T000075 Rep. Taylor, G. [R-MO-7] R MO 1986-09-18 0
99-hr-4142,G000291 General Aviation Tort Reform Act of 1986 99-hr-4142 G000291 Rep. Goodling, William F. [R-PA-19] R PA 1986-09-18 0
99-hr-4142,J000256 General Aviation Tort Reform Act of 1986 99-hr-4142 J000256 Rep. Jones, Walter B. [D-NC-1] D NC 1986-09-18 0
99-hr-4142,G000309 General Aviation Tort Reform Act of 1986 99-hr-4142 G000309 Rep. Gordon, Bart [D-TN-6] D TN 1986-09-18 0
99-hr-4142,D000435 General Aviation Tort Reform Act of 1986 99-hr-4142 D000435 Rep. Dornan, Robert K. [R-CA-38] R CA 1986-09-18 0
99-hr-4142,G000025 General Aviation Tort Reform Act of 1986 99-hr-4142 G000025 Rep. Gallo, Dean A. [R-NJ-11] R NJ 1986-09-18 0
99-hr-4142,S000795 General Aviation Tort Reform Act of 1986 99-hr-4142 S000795 Rep. Stangeland, Arlan [R-MN-7] R MN 1986-09-18 0
99-hr-4142,S000851 General Aviation Tort Reform Act of 1986 99-hr-4142 S000851 Rep. Stenholm, Charles W. [D-TX-17] D TX 1986-09-18 0
99-hr-4142,N000016 General Aviation Tort Reform Act of 1986 99-hr-4142 N000016 Rep. Neal, Stephen L. [D-NC-5] D NC 1986-09-18 0
99-hr-4142,C000555 General Aviation Tort Reform Act of 1986 99-hr-4142 C000555 Rep. Cobey, William W. [R-NC-4] R NC 1986-08-14 0
99-hr-4142,R000395 General Aviation Tort Reform Act of 1986 99-hr-4142 R000395 Rep. Rogers, Harold [R-KY-5] R KY 1986-08-14 0
99-hr-4142,F000041 General Aviation Tort Reform Act of 1986 99-hr-4142 F000041 Rep. Fascell, Dante B. [D-FL-19] D FL 1986-08-14 0
99-hr-4142,C000079 General Aviation Tort Reform Act of 1986 99-hr-4142 C000079 Rep. Campbell, Carroll A., Jr. [R-SC-4] R SC 1986-08-12 0
99-hr-4142,D000065 General Aviation Tort Reform Act of 1986 99-hr-4142 D000065 Rep. Daub, Hal [R-NE-2] R NE 1986-08-12 0
99-hr-4142,R000053 General Aviation Tort Reform Act of 1986 99-hr-4142 R000053 Rep. Rangel, Charles B. [D-NY-16] D NY 1986-08-12 0
99-hr-4142,S000143 General Aviation Tort Reform Act of 1986 99-hr-4142 S000143 Rep. Schuette, Bill [R-MI-10] R MI 1986-08-12 0
99-hr-4142,M000844 General Aviation Tort Reform Act of 1986 99-hr-4142 M000844 Rep. Mollohan, Alan B. [D-WV-1] D WV 1986-08-12 0
99-hr-4142,Y000033 General Aviation Tort Reform Act of 1986 99-hr-4142 Y000033 Rep. Young, Don [R-AK-At Large] R AK 1986-08-12 0
99-hr-4142,O000001 General Aviation Tort Reform Act of 1986 99-hr-4142 O000001 Rep. Oakar, Mary Rose [D-OH-20] D OH 1986-08-12 0
99-hr-4142,A000226 General Aviation Tort Reform Act of 1986 99-hr-4142 A000226 Rep. Atkins, Chester G. [D-MA-5] D MA 1986-08-12 0
99-hr-4142,Y000051 General Aviation Tort Reform Act of 1986 99-hr-4142 Y000051 Rep. Young, Robert A. [D-MO-2] D MO 1986-08-12 0
99-hr-4142,S000749 General Aviation Tort Reform Act of 1986 99-hr-4142 S000749 Rep. Spratt, John M., Jr. [D-SC-5] D SC 1986-08-01 0
99-hr-4142,R000229 General Aviation Tort Reform Act of 1986 99-hr-4142 R000229 Rep. Richardson, Bill [D-NM-3] D NM 1986-08-01 0
99-hr-4142,W000682 General Aviation Tort Reform Act of 1986 99-hr-4142 W000682 Rep. Wolpe, Howard E. [D-MI-3] D MI 1986-08-01 0
99-hr-4142,C000858 General Aviation Tort Reform Act of 1986 99-hr-4142 C000858 Rep. Craig, Larry E. [R-ID-1] R ID 1986-08-01 0
99-hr-4142,R000080 General Aviation Tort Reform Act of 1986 99-hr-4142 R000080 Rep. Ray, Richard B. [D-GA-3] D GA 1986-08-01 0
99-hr-4142,P000229 General Aviation Tort Reform Act of 1986 99-hr-4142 P000229 Rep. Perkins, Carl C. [D-KY-7] D KY 1986-08-01 0
99-hr-4142,B000648 General Aviation Tort Reform Act of 1986 99-hr-4142 B000648 Rep. Bosco, Douglas H. [D-CA-1] D CA 1986-08-01 0
99-hr-4142,B000213 General Aviation Tort Reform Act of 1986 99-hr-4142 B000213 Rep. Barton, Joe [R-TX-6] R TX 1986-08-01 0
99-hr-4142,W000763 General Aviation Tort Reform Act of 1986 99-hr-4142 W000763 Rep. Wright, James C., Jr. [D-TX-12] D TX 1986-08-01 0
99-hr-4142,R000465 General Aviation Tort Reform Act of 1986 99-hr-4142 R000465 Rep. Roukema, Marge [R-NJ-5] R NJ 1986-08-01 0
99-hr-4142,M000174 General Aviation Tort Reform Act of 1986 99-hr-4142 M000174 Rep. Martin, David O'B. [R-NY-26] R NY 1986-08-01 0
99-hr-4142,S000607 General Aviation Tort Reform Act of 1986 99-hr-4142 S000607 Rep. Smith, Robert [R-OR-2] R OR 1986-08-01 0
99-hr-4142,J000163 General Aviation Tort Reform Act of 1986 99-hr-4142 J000163 Rep. Johnson, Nancy L. [R-CT-6] R CT 1986-08-01 0
99-hr-4142,F000059 General Aviation Tort Reform Act of 1986 99-hr-4142 F000059 Rep. Feighan, Edward F. [D-OH-19] D OH 1986-08-01 0
99-hr-4142,B000204 General Aviation Tort Reform Act of 1986 99-hr-4142 B000204 Rep. Bartlett, Steve [R-TX-3] R TX 1986-08-01 0
99-hr-4142,M000139 General Aviation Tort Reform Act of 1986 99-hr-4142 M000139 Rep. Marlenee, Ron [R-MT-2] R MT 1986-08-01 0
99-hr-4142,M000399 General Aviation Tort Reform Act of 1986 99-hr-4142 M000399 Rep. McDade, Joseph M. [R-PA-10] R PA 1986-08-01 0
99-hr-4142,F000380 General Aviation Tort Reform Act of 1986 99-hr-4142 F000380 Rep. Frenzel, Bill [R-MN-3] R MN 1986-08-01 0
99-hr-4142,V000112 General Aviation Tort Reform Act of 1986 99-hr-4142 V000112 Rep. Volkmer, Harold L. [D-MO-9] D MO 1986-08-01 0
99-hr-4142,B001172 General Aviation Tort Reform Act of 1986 99-hr-4142 B001172 Rep. Bustamante, Albert G. [D-TX-23] D TX 1986-08-01 0
99-hr-4142,D000131 General Aviation Tort Reform Act of 1986 99-hr-4142 D000131 Rep. Davis, Robert W. [R-MI-11] R MI 1986-08-01 0
99-hr-4142,G000153 General Aviation Tort Reform Act of 1986 99-hr-4142 G000153 Rep. Gibbons, Sam [D-FL-7] D FL 1986-08-01 0
99-hr-4142,S000081 General Aviation Tort Reform Act of 1986 99-hr-4142 S000081 Rep. Savage, Gus [D-IL-2] D IL 1986-08-01 0
99-hr-4142,H000448 General Aviation Tort Reform Act of 1986 99-hr-4142 H000448 Rep. Hefner, W. G. (Bill) [D-NC-8] D NC 1986-08-01 0
99-hr-4142,R000383 General Aviation Tort Reform Act of 1986 99-hr-4142 R000383 Rep. Roe, Robert A. [D-NJ-8] D NJ 1986-08-01 0
99-hr-4142,S001077 General Aviation Tort Reform Act of 1986 99-hr-4142 S001077 Del. Sunia, Foto I. F. [D-AS-At Large] D AS 1986-08-01 0
99-hr-4142,D000593 General Aviation Tort Reform Act of 1986 99-hr-4142 D000593 Rep. Dyson, Roy [D-MD-1] D MD 1986-08-01 0
99-hr-4142,B000463 General Aviation Tort Reform Act of 1986 99-hr-4142 B000463 Rep. Bilirakis, Michael [R-FL-9] R FL 1986-08-01 0
99-hr-4142,M000860 General Aviation Tort Reform Act of 1986 99-hr-4142 M000860 Rep. Monson, David S. [R-UT-2] R UT 1986-08-01 0
99-hr-4142,W000419 General Aviation Tort Reform Act of 1986 99-hr-4142 W000419 Rep. Whitley, Charles O., Sr. [D-NC-3] D NC 1986-08-01 0
99-hr-4142,M000195 General Aviation Tort Reform Act of 1986 99-hr-4142 M000195 Rep. Martin, Lynn M. [R-IL-16] R IL 1986-08-01 0
99-hr-4142,C000312 General Aviation Tort Reform Act of 1986 99-hr-4142 C000312 Rep. Chapman, Jim [D-TX-1] D TX 1986-08-01 0
99-hr-4142,B000644 General Aviation Tort Reform Act of 1986 99-hr-4142 B000644 Rep. Borski, Robert A. [D-PA-3] D PA 1986-08-01 0
99-hr-4142,R000436 General Aviation Tort Reform Act of 1986 99-hr-4142 R000436 Rep. Rose, Charlie [D-NC-7] D NC 1986-08-01 0
99-hr-4142,K000009 General Aviation Tort Reform Act of 1986 99-hr-4142 K000009 Rep. Kaptur, Marcy [D-OH-9] D OH 1986-07-16 0
99-hr-4142,P000218 General Aviation Tort Reform Act of 1986 99-hr-4142 P000218 Rep. Pepper, Claude [D-FL-18] D FL 1986-07-16 0
99-hr-4142,H000388 General Aviation Tort Reform Act of 1986 99-hr-4142 H000388 Rep. Hayes, Charles A. [D-IL-1] D IL 1986-07-16 0
99-hr-4142,S000991 General Aviation Tort Reform Act of 1986 99-hr-4142 S000991 Rep. Strang, Michael L. [R-CO-3] R CO 1986-07-16 0
99-hr-4142,Y000031 General Aviation Tort Reform Act of 1986 99-hr-4142 Y000031 Rep. Young, C. W. Bill [R-FL-8] R FL 1986-07-16 0
99-hr-4142,L000020 General Aviation Tort Reform Act of 1986 99-hr-4142 L000020 Rep. Lagomarsino, Robert J. [R-CA-19] R CA 1986-07-16 0
99-hr-4142,P000097 General Aviation Tort Reform Act of 1986 99-hr-4142 P000097 Rep. Pashayan, Charles, Jr. [R-CA-17] R CA 1986-07-16 0
99-hr-4142,G000400 General Aviation Tort Reform Act of 1986 99-hr-4142 G000400 Rep. Gray, Kenneth J. [D-IL-22] D IL 1986-07-16 0
99-hr-4142,P000265 General Aviation Tort Reform Act of 1986 99-hr-4142 P000265 Rep. Petri, Thomas E. [R-WI-6] R WI 1986-07-16 0
99-hr-4142,B000432 General Aviation Tort Reform Act of 1986 99-hr-4142 B000432 Rep. Biaggi, Mario [D-NY-19] D NY 1986-07-16 0
99-hr-4142,M000264 General Aviation Tort Reform Act of 1986 99-hr-4142 M000264 Rep. Mavroules, Nicholas [D-MA-6] D MA 1986-07-16 0
99-hr-4142,L000305 General Aviation Tort Reform Act of 1986 99-hr-4142 L000305 Rep. Lightfoot, Jim [R-IA-5] R IA 1986-07-16 0
99-hr-4142,A000214 General Aviation Tort Reform Act of 1986 99-hr-4142 A000214 Rep. Applegate, Douglas [D-OH-18] D OH 1986-07-16 0
99-hr-4142,P000170 General Aviation Tort Reform Act of 1986 99-hr-4142 P000170 Rep. Pease, Donald J. [D-OH-13] D OH 1986-07-16 0
99-hr-4142,P000574 General Aviation Tort Reform Act of 1986 99-hr-4142 P000574 Rep. Pursell, Carl D. [R-MI-2] R MI 1986-07-16 0
99-hr-4142,M000398 General Aviation Tort Reform Act of 1986 99-hr-4142 M000398 Rep. McCurdy, Dave [D-OK-4] D OK 1986-06-24 0
99-hr-4142,B001220 General Aviation Tort Reform Act of 1986 99-hr-4142 B001220 Rep. Byron, Beverly B. [D-MD-6] D MD 1986-06-24 0
99-hr-4142,T000326 General Aviation Tort Reform Act of 1986 99-hr-4142 T000326 Rep. Towns, Edolphus [D-NY-11] D NY 1986-06-24 0
99-hr-4142,C000556 General Aviation Tort Reform Act of 1986 99-hr-4142 C000556 Rep. Coble, Howard [R-NC-6] R NC 1986-06-24 0
99-hr-4142,S001122 General Aviation Tort Reform Act of 1986 99-hr-4142 S001122 Rep. Swindall, Patrick L. [R-GA-4] R GA 1986-06-24 0
99-hr-4142,E000174 General Aviation Tort Reform Act of 1986 99-hr-4142 E000174 Rep. Emerson, Bill [R-MO-8] R MO 1986-06-24 0
99-hr-4142,S001101 General Aviation Tort Reform Act of 1986 99-hr-4142 S001101 Rep. Sweeney, David McCann [R-TX-14] R TX 1986-06-24 0
99-hr-4142,R000277 General Aviation Tort Reform Act of 1986 99-hr-4142 R000277 Rep. Ritter, Don [R-PA-15] R PA 1986-06-24 0
99-hr-4142,C000809 General Aviation Tort Reform Act of 1986 99-hr-4142 C000809 Rep. Courter, Jim [R-NJ-12] R NJ 1986-06-24 0
99-hr-4142,S000005 General Aviation Tort Reform Act of 1986 99-hr-4142 S000005 Rep. Sabo, Martin Olav [D-MN-5] D MN 1986-06-24 0
99-hr-4142,S000463 General Aviation Tort Reform Act of 1986 99-hr-4142 S000463 Rep. Skeen, Joe [R-NM-2] R NM 1986-06-24 0
99-hr-4142,D000327 General Aviation Tort Reform Act of 1986 99-hr-4142 D000327 Rep. Dicks, Norman D. [D-WA-6] D WA 1986-06-24 0
99-hr-4142,R000459 General Aviation Tort Reform Act of 1986 99-hr-4142 R000459 Rep. Roth, Toby [R-WI-8] R WI 1986-06-24 0
99-hr-4142,D000209 General Aviation Tort Reform Act of 1986 99-hr-4142 D000209 Del. de Lugo, Ron [D-VI-At Large] D VI 1986-06-24 0
99-hr-4142,R000011 General Aviation Tort Reform Act of 1986 99-hr-4142 R000011 Rep. Rahall, Nick J., II [D-WV-4] D WV 1986-06-24 0
99-hr-4142,S000136 General Aviation Tort Reform Act of 1986 99-hr-4142 S000136 Rep. Schneider, Claudine [R-RI-2] R RI 1986-06-24 0
99-hr-4142,L000342 General Aviation Tort Reform Act of 1986 99-hr-4142 L000342 Rep. Lipinski, William O. [D-IL-5] D IL 1986-06-24 0
99-hr-4142,T000034 General Aviation Tort Reform Act of 1986 99-hr-4142 T000034 Rep. Tallon, Robert M. (Robin) [D-SC-6] D SC 1986-06-24 0

Next page

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 44.565ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API