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

32 rows where bill_id = "108-hr-4261" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: state, sponsorship_date, sponsorship_date (date)

is_original_cosponsor 2

  • 0 16
  • 1 16
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
108-hr-4261,M001145 Reading Failure Prevention Act of 2004 108-hr-4261 M001145 Rep. Majette, Denise L. [D-GA-4] D GA 2004-09-28 0
108-hr-4261,O000006 Reading Failure Prevention Act of 2004 108-hr-4261 O000006 Rep. Oberstar, James L. [D-MN-8] D MN 2004-09-22 0
108-hr-4261,P000034 Reading Failure Prevention Act of 2004 108-hr-4261 P000034 Rep. Pallone, Frank, Jr. [D-NJ-6] D NJ 2004-07-06 0
108-hr-4261,M001148 Reading Failure Prevention Act of 2004 108-hr-4261 M001148 Rep. Meek, Kendrick B. [D-FL-17] D FL 2004-06-24 0
108-hr-4261,C000141 Reading Failure Prevention Act of 2004 108-hr-4261 C000141 Rep. Cardin, Benjamin L. [D-MD-3] D MD 2004-06-21 0
108-hr-4261,T000193 Reading Failure Prevention Act of 2004 108-hr-4261 T000193 Rep. Thompson, Bennie G. [D-MS-2] D MS 2004-06-21 0
108-hr-4261,G000551 Reading Failure Prevention Act of 2004 108-hr-4261 G000551 Rep. Grijalva, Raúl M. [D-AZ-7] D AZ 2004-06-09 0
108-hr-4261,D000598 Reading Failure Prevention Act of 2004 108-hr-4261 D000598 Rep. Davis, Susan A. [D-CA-53] D CA 2004-06-09 0
108-hr-4261,S001156 Reading Failure Prevention Act of 2004 108-hr-4261 S001156 Rep. Sánchez, Linda T. [D-CA-39] D CA 2004-06-08 0
108-hr-4261,F000392 Reading Failure Prevention Act of 2004 108-hr-4261 F000392 Rep. Frost, Martin [D-TX-24] D TX 2004-06-08 0
108-hr-4261,F000043 Reading Failure Prevention Act of 2004 108-hr-4261 F000043 Rep. Fattah, Chaka [D-PA-2] D PA 2004-06-08 0
108-hr-4261,M000590 Reading Failure Prevention Act of 2004 108-hr-4261 M000590 Rep. McNulty, Michael R. [D-NY-21] D NY 2004-06-08 0
108-hr-4261,O000159 Reading Failure Prevention Act of 2004 108-hr-4261 O000159 Rep. Owens, Major R. [D-NY-11] D NY 2004-06-01 0
108-hr-4261,C001049 Reading Failure Prevention Act of 2004 108-hr-4261 C001049 Rep. Clay, Wm. Lacy [D-MO-1] D MO 2004-06-01 0
108-hr-4261,M000312 Reading Failure Prevention Act of 2004 108-hr-4261 M000312 Rep. McGovern, James P. [D-MA-3] D MA 2004-06-01 0
108-hr-4261,T000326 Reading Failure Prevention Act of 2004 108-hr-4261 T000326 Rep. Towns, Edolphus [D-NY-10] D NY 2004-06-01 0
108-hr-4261,B000490 Reading Failure Prevention Act of 2004 108-hr-4261 B000490 Rep. Bishop, Sanford D., Jr. [D-GA-2] D GA 2004-05-04 1
108-hr-4261,B000911 Reading Failure Prevention Act of 2004 108-hr-4261 B000911 Rep. Brown, Corrine [D-FL-3] D FL 2004-05-04 1
108-hr-4261,C000714 Reading Failure Prevention Act of 2004 108-hr-4261 C000714 Rep. Conyers, John, Jr. [D-MI-14] D MI 2004-05-04 1
108-hr-4261,M001137 Reading Failure Prevention Act of 2004 108-hr-4261 M001137 Rep. Meeks, Gregory W. [D-NY-6] D NY 2004-05-04 1
108-hr-4261,J000032 Reading Failure Prevention Act of 2004 108-hr-4261 J000032 Rep. Jackson-Lee, Sheila [D-TX-18] D TX 2004-05-04 1
108-hr-4261,K000180 Reading Failure Prevention Act of 2004 108-hr-4261 K000180 Rep. Kilpatrick, Carolyn C. [D-MI-13] D MI 2004-05-04 1
108-hr-4261,R000576 Reading Failure Prevention Act of 2004 108-hr-4261 R000576 Rep. Ruppersberger, C. A. Dutch [D-MD-2] D MD 2004-05-04 1
108-hr-4261,W000784 Reading Failure Prevention Act of 2004 108-hr-4261 W000784 Rep. Wynn, Albert Russell [D-MD-4] D MD 2004-05-04 1
108-hr-4261,J000284 Reading Failure Prevention Act of 2004 108-hr-4261 J000284 Rep. Jones, Stephanie Tubbs [D-OH-11] D OH 2004-05-04 1
108-hr-4261,L000551 Reading Failure Prevention Act of 2004 108-hr-4261 L000551 Rep. Lee, Barbara [D-CA-9] D CA 2004-05-04 1
108-hr-4261,V000128 Reading Failure Prevention Act of 2004 108-hr-4261 V000128 Rep. Van Hollen, Chris [D-MD-8] D MD 2004-05-04 1
108-hr-4261,M000714 Reading Failure Prevention Act of 2004 108-hr-4261 M000714 Rep. Millender-McDonald, Juanita [D-CA-37] D CA 2004-05-04 1
108-hr-4261,P000149 Reading Failure Prevention Act of 2004 108-hr-4261 P000149 Rep. Payne, Donald M. [D-NJ-10] D NJ 2004-05-04 1
108-hr-4261,R000515 Reading Failure Prevention Act of 2004 108-hr-4261 R000515 Rep. Rush, Bobby L. [D-IL-1] D IL 2004-05-04 1
108-hr-4261,H000324 Reading Failure Prevention Act of 2004 108-hr-4261 H000324 Rep. Hastings, Alcee L. [D-FL-23] D FL 2004-05-04 1
108-hr-4261,B001238 Reading Failure Prevention Act of 2004 108-hr-4261 B001238 Rep. Ballance, Frank W., Jr. [D-NC-1] D NC 2004-05-04 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 6.82ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API