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

39 rows where bill_id = "99-hr-4766" 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 32
  • 1 7
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
99-hr-4766,B000204 Product Liability Reform Act of 1986 99-hr-4766 B000204 Rep. Bartlett, Steve [R-TX-3] R TX 1986-09-24 0
99-hr-4766,M000139 Product Liability Reform Act of 1986 99-hr-4766 M000139 Rep. Marlenee, Ron [R-MT-2] R MT 1986-08-06 0
99-hr-4766,B000213 Product Liability Reform Act of 1986 99-hr-4766 B000213 Rep. Barton, Joe [R-TX-6] R TX 1986-07-21 0
99-hr-4766,M000527 Product Liability Reform Act of 1986 99-hr-4766 M000527 Rep. McKinney, Stewart B. [R-CT-4] R CT 1986-07-16 0
99-hr-4766,S001122 Product Liability Reform Act of 1986 99-hr-4766 S001122 Rep. Swindall, Patrick L. [R-GA-4] R GA 1986-07-15 0
99-hr-4766,S000143 Product Liability Reform Act of 1986 99-hr-4766 S000143 Rep. Schuette, Bill [R-MI-10] R MI 1986-07-15 0
99-hr-4766,V000124 Product Liability Reform Act of 1986 99-hr-4766 V000124 Rep. Vucanovich, Barbara F. [R-NV-2] R NV 1986-07-15 0
99-hr-4766,M000195 Product Liability Reform Act of 1986 99-hr-4766 M000195 Rep. Martin, Lynn M. [R-IL-16] R IL 1986-07-14 0
99-hr-4766,S000527 Product Liability Reform Act of 1986 99-hr-4766 S000527 Rep. Smith, Denny [R-OR-5] R OR 1986-06-26 0
99-hr-4766,H001018 Product Liability Reform Act of 1986 99-hr-4766 H001018 Rep. Hutto, Earl [D-FL-1] D FL 1986-06-25 0
99-hr-4766,S000991 Product Liability Reform Act of 1986 99-hr-4766 S000991 Rep. Strang, Michael L. [R-CO-3] R CO 1986-06-24 0
99-hr-4766,R000277 Product Liability Reform Act of 1986 99-hr-4766 R000277 Rep. Ritter, Don [R-PA-15] R PA 1986-06-24 0
99-hr-4766,H000448 Product Liability Reform Act of 1986 99-hr-4766 H000448 Rep. Hefner, W. G. (Bill) [D-NC-8] D NC 1986-06-17 0
99-hr-4766,H000747 Product Liability Reform Act of 1986 99-hr-4766 H000747 Rep. Holt, Marjorie S. [R-MD-4] R MD 1986-06-17 0
99-hr-4766,R000307 Product Liability Reform Act of 1986 99-hr-4766 R000307 Rep. Roberts, Pat [R-KS-1] R KS 1986-06-17 0
99-hr-4766,B000298 Product Liability Reform Act of 1986 99-hr-4766 B000298 Rep. Bedell, Berkley W. [D-IA-6] D IA 1986-06-17 0
99-hr-4766,H000490 Product Liability Reform Act of 1986 99-hr-4766 H000490 Rep. Hendon, Bill [R-NC-11] R NC 1986-06-12 0
99-hr-4766,B001149 Product Liability Reform Act of 1986 99-hr-4766 B001149 Rep. Burton, Dan [R-IN-6] R IN 1986-06-12 0
99-hr-4766,W000426 Product Liability Reform Act of 1986 99-hr-4766 W000426 Rep. Whittaker, Bob [R-KS-5] R KS 1986-06-12 0
99-hr-4766,B000024 Product Liability Reform Act of 1986 99-hr-4766 B000024 Rep. Badham, Robert E. [R-CA-40] R CA 1986-06-12 0
99-hr-4766,Y000033 Product Liability Reform Act of 1986 99-hr-4766 Y000033 Rep. Young, Don [R-AK-At Large] R AK 1986-06-12 0
99-hr-4766,G000445 Product Liability Reform Act of 1986 99-hr-4766 G000445 Rep. Gregg, Judd [R-NH-2] R NH 1986-06-12 0
99-hr-4766,S000607 Product Liability Reform Act of 1986 99-hr-4766 S000607 Rep. Smith, Robert [R-OR-2] R OR 1986-06-11 0
99-hr-4766,S000675 Product Liability Reform Act of 1986 99-hr-4766 S000675 Rep. Solomon, Gerald B. H. [R-NY-24] R NY 1986-06-11 0
99-hr-4766,S000244 Product Liability Reform Act of 1986 99-hr-4766 S000244 Rep. Sensenbrenner, F. James, Jr. [R-WI-9] R WI 1986-06-11 0
99-hr-4766,B000586 Product Liability Reform Act of 1986 99-hr-4766 B000586 Rep. Boehlert, Sherwood [R-NY-25] R NY 1986-06-11 0
99-hr-4766,D000435 Product Liability Reform Act of 1986 99-hr-4766 D000435 Rep. Dornan, Robert K. [R-CA-38] R CA 1986-06-10 0
99-hr-4766,P000265 Product Liability Reform Act of 1986 99-hr-4766 P000265 Rep. Petri, Thomas E. [R-WI-6] R WI 1986-06-10 0
99-hr-4766,W000237 Product Liability Reform Act of 1986 99-hr-4766 W000237 Rep. Weber, Vin [R-MN-2] R MN 1986-06-04 0
99-hr-4766,F000380 Product Liability Reform Act of 1986 99-hr-4766 F000380 Rep. Frenzel, Bill [R-MN-3] R MN 1986-05-22 0
99-hr-4766,P000444 Product Liability Reform Act of 1986 99-hr-4766 P000444 Rep. Porter, John Edward [R-IL-10] R IL 1986-05-22 0
99-hr-4766,L000116 Product Liability Reform Act of 1986 99-hr-4766 L000116 Rep. Latta, Delbert L. [R-OH-5] R OH 1986-05-15 0
99-hr-4766,K000190 Product Liability Reform Act of 1986 99-hr-4766 K000190 Rep. Kindness, Thomas N. [R-OH-8] R OH 1986-05-07 1
99-hr-4766,L000517 Product Liability Reform Act of 1986 99-hr-4766 L000517 Rep. Lungren, Daniel E. [R-CA-42] R CA 1986-05-07 1
99-hr-4766,S000303 Product Liability Reform Act of 1986 99-hr-4766 S000303 Rep. Shaw, E. Clay, Jr. [R-FL-15] R FL 1986-05-07 1
99-hr-4766,G000121 Product Liability Reform Act of 1986 99-hr-4766 G000121 Rep. Gekas, George W. [R-PA-17] R PA 1986-05-07 1
99-hr-4766,B000919 Product Liability Reform Act of 1986 99-hr-4766 B000919 Rep. Brown, Hank [R-CO-4] R CO 1986-05-07 1
99-hr-4766,S000146 Product Liability Reform Act of 1986 99-hr-4766 S000146 Rep. Schulze, Richard T. [R-PA-5] R PA 1986-05-07 1
99-hr-4766,L000274 Product Liability Reform Act of 1986 99-hr-4766 L000274 Rep. Lewis, Jerry [R-CA-35] R CA 1986-05-07 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 4.597ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API