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

42 rows where bill_id = "104-hconres-83" 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 32
  • 0 10
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
104-hconres-83,M000206 Entitled, the "English Plus Resolution". 104-hconres-83 M000206 Rep. Martinez, Matthew G. [D-CA-31] D CA 1996-07-23 0
104-hconres-83,P000149 Entitled, the "English Plus Resolution". 104-hconres-83 P000149 Rep. Payne, Donald M. [D-NJ-10] D NJ 1996-07-23 0
104-hconres-83,S000094 Entitled, the "English Plus Resolution". 104-hconres-83 S000094 Rep. Sawyer, Tom [D-OH-14] D OH 1996-07-23 0
104-hconres-83,F000434 Entitled, the "English Plus Resolution". 104-hconres-83 F000434 Rep. Furse, Elizabeth [D-OR-1] D OR 1996-07-12 0
104-hconres-83,A000022 Entitled, the "English Plus Resolution". 104-hconres-83 A000022 Rep. Ackerman, Gary L. [D-NY-5] D NY 1996-06-11 0
104-hconres-83,B000619 Entitled, the "English Plus Resolution". 104-hconres-83 B000619 Rep. Bonior, David E. [D-MI-10] D MI 1996-06-05 0
104-hconres-83,J000070 Entitled, the "English Plus Resolution". 104-hconres-83 J000070 Rep. Jefferson, William J. [D-LA-2] D LA 1996-04-30 0
104-hconres-83,V000087 Entitled, the "English Plus Resolution". 104-hconres-83 V000087 Rep. Vento, Bruce F. [D-MN-4] D MN 1996-04-25 0
104-hconres-83,G000410 Entitled, the "English Plus Resolution". 104-hconres-83 G000410 Rep. Green, Gene [D-TX-29] D TX 1996-04-18 0
104-hconres-83,M000466 Entitled, the "English Plus Resolution". 104-hconres-83 M000466 Rep. McHale, Paul [D-PA-15] D PA 1996-03-06 0
104-hconres-83,P000099 Entitled, the "English Plus Resolution". 104-hconres-83 P000099 Rep. Pastor, Ed [D-AZ-2] D AZ 1995-07-13 1
104-hconres-83,R000435 Entitled, the "English Plus Resolution". 104-hconres-83 R000435 Rep. Ros-Lehtinen, Ileana [R-FL-18] R FL 1995-07-13 1
104-hconres-83,V000081 Entitled, the "English Plus Resolution". 104-hconres-83 V000081 Rep. Velazquez, Nydia M. [D-NY-12] D NY 1995-07-13 1
104-hconres-83,U000014 Entitled, the "English Plus Resolution". 104-hconres-83 U000014 Del. Underwood, Robert A. [D-GU-At Large] D GU 1995-07-13 1
104-hconres-83,R000417 Entitled, the "English Plus Resolution". 104-hconres-83 R000417 Resident Commissioner Romero-Barcelo, Carlos A. [D-PR-At Large] D PR 1995-07-13 1
104-hconres-83,G000535 Entitled, the "English Plus Resolution". 104-hconres-83 G000535 Rep. Gutierrez, Luis V. [D-IL-4] D IL 1995-07-13 1
104-hconres-83,R000229 Entitled, the "English Plus Resolution". 104-hconres-83 R000229 Rep. Richardson, Bill [D-NM-3] D NM 1995-07-13 1
104-hconres-83,T000316 Entitled, the "English Plus Resolution". 104-hconres-83 T000316 Rep. Torres, Esteban Edward [D-CA-34] D CA 1995-07-13 1
104-hconres-83,B000287 Entitled, the "English Plus Resolution". 104-hconres-83 B000287 Rep. Becerra, Xavier [D-CA-30] D CA 1995-07-13 1
104-hconres-83,R000486 Entitled, the "English Plus Resolution". 104-hconres-83 R000486 Rep. Roybal-Allard, Lucille [D-CA-33] D CA 1995-07-13 1
104-hconres-83,G000272 Entitled, the "English Plus Resolution". 104-hconres-83 G000272 Rep. Gonzalez, Henry B. [D-TX-20] D TX 1995-07-13 1
104-hconres-83,O000107 Entitled, the "English Plus Resolution". 104-hconres-83 O000107 Rep. Ortiz, Solomon P. [D-TX-27] D TX 1995-07-13 1
104-hconres-83,T000113 Entitled, the "English Plus Resolution". 104-hconres-83 T000113 Rep. Tejeda, Frank [D-TX-28] D TX 1995-07-13 1
104-hconres-83,M000639 Entitled, the "English Plus Resolution". 104-hconres-83 M000639 Rep. Menendez, Robert [D-NJ-13] D NJ 1995-07-13 1
104-hconres-83,T000326 Entitled, the "English Plus Resolution". 104-hconres-83 T000326 Rep. Towns, Edolphus [D-NY-10] D NY 1995-07-13 1
104-hconres-83,O000159 Entitled, the "English Plus Resolution". 104-hconres-83 O000159 Rep. Owens, Major R. [D-NY-11] D NY 1995-07-13 1
104-hconres-83,F000030 Entitled, the "English Plus Resolution". 104-hconres-83 F000030 Rep. Farr, Sam [D-CA-17] D CA 1995-07-13 1
104-hconres-83,M000404 Entitled, the "English Plus Resolution". 104-hconres-83 M000404 Rep. McDermott, Jim [D-WA-7] D WA 1995-07-13 1
104-hconres-83,M000933 Entitled, the "English Plus Resolution". 104-hconres-83 M000933 Rep. Moran, James P. [D-VA-8] D VA 1995-07-13 1
104-hconres-83,M000628 Entitled, the "English Plus Resolution". 104-hconres-83 M000628 Rep. Meek, Carrie P. [D-FL-17] D FL 1995-07-13 1
104-hconres-83,J000032 Entitled, the "English Plus Resolution". 104-hconres-83 J000032 Rep. Jackson-Lee, Sheila [D-TX-18] D TX 1995-07-13 1
104-hconres-83,F000043 Entitled, the "English Plus Resolution". 104-hconres-83 F000043 Rep. Fattah, Chaka [D-PA-2] D PA 1995-07-13 1
104-hconres-83,S000185 Entitled, the "English Plus Resolution". 104-hconres-83 S000185 Rep. Scott, Robert C. "Bobby" [D-VA-3] D VA 1995-07-13 1
104-hconres-83,D000222 Entitled, the "English Plus Resolution". 104-hconres-83 D000222 Rep. Dellums, Ronald V. [D-CA-9] D CA 1995-07-13 1
104-hconres-83,P000197 Entitled, the "English Plus Resolution". 104-hconres-83 P000197 Rep. Pelosi, Nancy [D-CA-8] D CA 1995-07-13 1
104-hconres-83,M000725 Entitled, the "English Plus Resolution". 104-hconres-83 M000725 Rep. Miller, George [D-CA-7] D CA 1995-07-13 1
104-hconres-83,L000287 Entitled, the "English Plus Resolution". 104-hconres-83 L000287 Rep. Lewis, John [D-GA-5] D GA 1995-07-13 1
104-hconres-83,N000002 Entitled, the "English Plus Resolution". 104-hconres-83 N000002 Rep. Nadler, Jerrold [D-NY-8] D NY 1995-07-13 1
104-hconres-83,R000053 Entitled, the "English Plus Resolution". 104-hconres-83 R000053 Rep. Rangel, Charles B. [D-NY-15] D NY 1995-07-13 1
104-hconres-83,M000794 Entitled, the "English Plus Resolution". 104-hconres-83 M000794 Rep. Mineta, Norman Y. [D-CA-15] D CA 1995-07-13 1
104-hconres-83,M000797 Entitled, the "English Plus Resolution". 104-hconres-83 M000797 Rep. Mink, Patsy T. [D-HI-2] D HI 1995-07-13 1
104-hconres-83,A000014 Entitled, the "English Plus Resolution". 104-hconres-83 A000014 Rep. Abercrombie, Neil [D-HI-1] D HI 1995-07-13 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 313.49ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API