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

85 rows where bill_id = "97-hconres-401" 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 53
  • 0 32
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
97-hconres-401,B000432 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 B000432 Rep. Biaggi, Mario [D-NY-10] D NY 1982-12-07 0
97-hconres-401,L000486 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 L000486 Rep. Lowry, Mike [D-WA-7] D WA 1982-12-07 0
97-hconres-401,M000264 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 M000264 Rep. Mavroules, Nicholas [D-MA-6] D MA 1982-12-07 0
97-hconres-401,B000298 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 B000298 Rep. Bedell, Berkley W. [D-IA-6] D IA 1982-12-07 0
97-hconres-401,M000794 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 M000794 Rep. Mineta, Norman Y. [D-CA-13] D CA 1982-12-07 0
97-hconres-401,R000383 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 R000383 Rep. Roe, Robert A. [D-NJ-8] D NJ 1982-12-07 0
97-hconres-401,P000047 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 P000047 Rep. Panetta, Leon [D-CA-16] D CA 1982-12-07 0
97-hconres-401,K000118 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 K000118 Rep. Kennelly, Barbara B. [D-CT-1] D CT 1982-12-07 0
97-hconres-401,F000235 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 F000235 Rep. Foglietta, Thomas M. [D-PA-1] D PA 1982-12-07 0
97-hconres-401,S001040 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 S001040 Rep. Studds, Gerry E. [D-MA-12] D MA 1982-12-07 0
97-hconres-401,N000163 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 N000163 Rep. Nowak, Henry [D-NY-37] D NY 1982-12-07 0
97-hconres-401,G000212 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 G000212 Rep. Gilman, Benjamin A. [R-NY-26] R NY 1982-12-07 0
97-hconres-401,M000206 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 M000206 Rep. Martinez, Matthew G. [D-CA-30] D CA 1982-12-07 0
97-hconres-401,S000303 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 S000303 Rep. Shaw, E. Clay, Jr. [R-FL-12] R FL 1982-12-07 0
97-hconres-401,W000180 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 W000180 Rep. Washington, Harold [D-IL-1] D IL 1982-12-07 0
97-hconres-401,M000725 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 M000725 Rep. Miller, George [D-CA-7] D CA 1982-09-08 0
97-hconres-401,A000052 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 A000052 Rep. Addabbo, Joseph P. [D-NY-7] D NY 1982-09-08 0
97-hconres-401,W000215 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 W000215 Rep. Waxman, Henry A. [D-CA-24] D CA 1982-09-08 0
97-hconres-401,G000120 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 G000120 Rep. Gejdenson, Sam [D-CT-2] D CT 1982-09-08 0
97-hconres-401,R000308 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 R000308 Rep. Roberts, Clint [R-SD-2] R SD 1982-09-08 0
97-hconres-401,E000043 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 E000043 Rep. Edgar, Robert W. [D-PA-7] D PA 1982-09-08 0
97-hconres-401,C000634 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 C000634 Rep. Collins, Cardiss [D-IL-7] D IL 1982-09-08 0
97-hconres-401,L000516 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 L000516 Rep. Lundine, Stanley N. [D-NY-39] D NY 1982-09-08 0
97-hconres-401,S000465 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 S000465 Rep. Skelton, Ike [D-MO-4] D MO 1982-09-08 0
97-hconres-401,M000249 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 M000249 Rep. Matsui, Robert T. [D-CA-3] D CA 1982-09-08 0
97-hconres-401,S000948 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 S000948 Rep. Stokes, Louis [D-OH-21] D OH 1982-09-08 0
97-hconres-401,C000371 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 C000371 Rep. Chisholm, Shirley [D-NY-12] D NY 1982-09-08 0
97-hconres-401,S000058 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 S000058 Rep. Santini, James D. [D-NV-98] D NV 1982-09-08 0
97-hconres-401,B000160 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 B000160 Rep. Barnes, Michael D. [D-MD-8] D MD 1982-09-08 0
97-hconres-401,M000133 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 M000133 Rep. Markey, Edward J. [D-MA-7] D MA 1982-09-08 0
97-hconres-401,F000078 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 F000078 Rep. Fenwick, Millicent H. [R-NJ-5] R NJ 1982-09-08 0
97-hconres-401,F000041 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 F000041 Rep. Fascell, Dante B. [D-FL-15] D FL 1982-09-08 0
97-hconres-401,L000226 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 L000226 Rep. Lehman, William [D-FL-13] D FL 1982-08-19 1
97-hconres-401,R000442 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 R000442 Rep. Rosenthal, Benjamin S. [D-NY-8] D NY 1982-08-19 1
97-hconres-401,O000006 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 O000006 Rep. Oberstar, James L. [D-MN-8] D MN 1982-08-19 1
97-hconres-401,E000064 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 E000064 Rep. Edwards, Don [D-CA-10] D CA 1982-08-19 1
97-hconres-401,S000148 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 S000148 Rep. Schumer, Charles E. [D-NY-16] D NY 1982-08-19 1
97-hconres-401,S000423 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 S000423 Rep. Simon, Paul [D-IL-24] D IL 1982-08-19 1
97-hconres-401,S000124 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 S000124 Rep. Scheuer, James H. [D-NY-11] D NY 1982-08-19 1
97-hconres-401,B000862 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 B000862 Rep. Brodhead, William [D-MI-17] D MI 1982-08-19 1
97-hconres-401,F000046 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 F000046 Del. Fauntroy, Walter E. [D-DC-At Large] D DC 1982-08-19 1
97-hconres-401,P000280 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 P000280 Rep. Peyser, Peter A. [D-NY-23] D NY 1982-08-19 1
97-hconres-401,H000930 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 H000930 Rep. Hughes, William J. [D-NJ-2] D NJ 1982-08-19 1
97-hconres-401,S000282 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 S000282 Rep. Shamansky, Bob [D-OH-12] D OH 1982-08-19 1
97-hconres-401,D000471 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 D000471 Rep. Downey, Thomas J. [D-NY-2] D NY 1982-08-19 1
97-hconres-401,M001088 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 M001088 Rep. Murphy, Austin J. [D-PA-22] D PA 1982-08-19 1
97-hconres-401,K000172 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 K000172 Rep. Kildee, Dale E. [D-MI-7] D MI 1982-08-19 1
97-hconres-401,M000702 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 M000702 Rep. Mikulski, Barbara A. [D-MD-3] D MD 1982-08-19 1
97-hconres-401,Y000013 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 Y000013 Rep. Yates, Sidney R. [D-IL-9] D IL 1982-08-19 1
97-hconres-401,U000001 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 U000001 Rep. Udall, Morris K. [D-AZ-2] D AZ 1982-08-19 1
97-hconres-401,P000218 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 P000218 Rep. Pepper, Claude [D-FL-14] D FL 1982-08-19 1
97-hconres-401,S000810 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 S000810 Rep. Stark, Fortney Pete [D-CA-9] D CA 1982-08-19 1
97-hconres-401,M000839 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 M000839 Rep. Moffett, Toby [D-CT-6] D CT 1982-08-19 1
97-hconres-401,S000286 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 S000286 Rep. Shannon, James M. [D-MA-5] D MA 1982-08-19 1
97-hconres-401,F000141 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 F000141 Rep. Fish, Hamilton, Jr. [R-NY-25] R NY 1982-08-19 1
97-hconres-401,C000919 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 C000919 Rep. Crockett, George W., Jr. [D-MI-13] D MI 1982-08-19 1
97-hconres-401,V000087 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 V000087 Rep. Vento, Bruce F. [D-MN-4] D MN 1982-08-19 1
97-hconres-401,W000779 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 W000779 Rep. Wyden, Ron [D-OR-3] D OR 1982-08-19 1
97-hconres-401,D000592 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 D000592 Rep. Dymally, Mervyn M. [D-CA-31] D CA 1982-08-19 1
97-hconres-401,D000222 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 D000222 Rep. Dellums, Ronald V. [D-CA-8] D CA 1982-08-19 1
97-hconres-401,R000067 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 R000067 Rep. Ratchford, William R. [D-CT-5] D CT 1982-08-19 1
97-hconres-401,S001139 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 S001139 Rep. Synar, Mike [D-OK-2] D OK 1982-08-19 1
97-hconres-401,F000270 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 F000270 Rep. Ford, William D. [D-MI-15] D MI 1982-08-19 1
97-hconres-401,F000261 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 F000261 Rep. Ford, Harold E. [D-TN-8] D TN 1982-08-19 1
97-hconres-401,B000615 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 B000615 Rep. Boner, William H. [D-TN-5] D TN 1982-08-19 1
97-hconres-401,O000001 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 O000001 Rep. Oakar, Mary Rose [D-OH-20] D OH 1982-08-19 1
97-hconres-401,F000339 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 F000339 Rep. Frank, Barney [D-MA-4] D MA 1982-08-19 1
97-hconres-401,B001156 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 B001156 Rep. Burton, Phillip [D-CA-6] D CA 1982-08-19 1
97-hconres-401,B001153 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 B001153 Rep. Burton, John [D-CA-5] D CA 1982-08-19 1
97-hconres-401,R000485 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 R000485 Rep. Roybal, Edward R. [D-CA-25] D CA 1982-08-19 1
97-hconres-401,M001044 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 M001044 Rep. Mottl, Ronald M. [D-OH-23] D OH 1982-08-19 1
97-hconres-401,P000170 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 P000170 Rep. Pease, Donald J. [D-OH-13] D OH 1982-08-19 1
97-hconres-401,E000198 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 E000198 Rep. Erdahl, Arlen [R-MN-1] R MN 1982-08-19 1
97-hconres-401,O000134 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 O000134 Rep. Ottinger, Richard L. [D-NY-24] D NY 1982-08-19 1
97-hconres-401,G000047 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 G000047 Rep. Garcia, Robert [D-NY-21] D NY 1982-08-19 1
97-hconres-401,F000088 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 F000088 Rep. Ferraro, Geraldine A. [D-NY-9] D NY 1982-08-19 1
97-hconres-401,B000472 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 B000472 Rep. Bingham, Jonathan B. [D-NY-22] D NY 1982-08-19 1
97-hconres-401,M000826 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 M000826 Rep. Mitchell, Parren J. [D-MD-7] D MD 1982-08-19 1
97-hconres-401,C000714 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 C000714 Rep. Conyers, John, Jr. [D-MI-1] D MI 1982-08-19 1
97-hconres-401,S000142 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 S000142 Rep. Schroeder, Patricia [D-CO-1] D CO 1982-08-19 1
97-hconres-401,G000511 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 G000511 Rep. Guarini, Frank J. [D-NJ-14] D NJ 1982-08-19 1
97-hconres-401,R000232 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 R000232 Rep. Richmond, Frederick W. [D-NY-14] D NY 1982-08-19 1
97-hconres-401,W000520 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 W000520 Rep. Williams, Pat [D-MT-1] D MT 1982-08-19 1
97-hconres-401,F000215 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 F000215 Rep. Florio, James J. [D-NJ-1] D NJ 1982-08-19 1
97-hconres-401,S000673 A concurrent resolution expressing the sense of the Congress that the Secretary of Health and Human Services should withdraw a proposed reduction in public notice and comment opportunities. 97-hconres-401 S000673 Rep. Solarz, Stephen J. [D-NY-13] D NY 1982-08-19 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 7.942ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API