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

40 rows where bill_id = "108-hr-4585" 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 1

  • 0 40
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
108-hr-4585,G000535 Full-Service Community Schools Act of 2004 108-hr-4585 G000535 Rep. Gutierrez, Luis V. [D-IL-4] D IL 2004-12-07 0
108-hr-4585,P000149 Full-Service Community Schools Act of 2004 108-hr-4585 P000149 Rep. Payne, Donald M. [D-NJ-10] D NJ 2004-11-17 0
108-hr-4585,J000032 Full-Service Community Schools Act of 2004 108-hr-4585 J000032 Rep. Jackson-Lee, Sheila [D-TX-18] D TX 2004-11-17 0
108-hr-4585,M000714 Full-Service Community Schools Act of 2004 108-hr-4585 M000714 Rep. Millender-McDonald, Juanita [D-CA-37] D CA 2004-11-17 0
108-hr-4585,J000126 Full-Service Community Schools Act of 2004 108-hr-4585 J000126 Rep. Johnson, Eddie Bernice [D-TX-30] D TX 2004-10-09 0
108-hr-4585,W000314 Full-Service Community Schools Act of 2004 108-hr-4585 W000314 Rep. Wexler, Robert [D-FL-19] D FL 2004-10-08 0
108-hr-4585,W000215 Full-Service Community Schools Act of 2004 108-hr-4585 W000215 Rep. Waxman, Henry A. [D-CA-30] D CA 2004-10-08 0
108-hr-4585,E000215 Full-Service Community Schools Act of 2004 108-hr-4585 E000215 Rep. Eshoo, Anna G. [D-CA-14] D CA 2004-10-08 0
108-hr-4585,M000316 Full-Service Community Schools Act of 2004 108-hr-4585 M000316 Rep. McCarthy, Karen [D-MO-5] D MO 2004-10-08 0
108-hr-4585,W000784 Full-Service Community Schools Act of 2004 108-hr-4585 W000784 Rep. Wynn, Albert Russell [D-MD-4] D MD 2004-10-08 0
108-hr-4585,W000794 Full-Service Community Schools Act of 2004 108-hr-4585 W000794 Rep. Watson, Diane E. [D-CA-33] D CA 2004-09-28 0
108-hr-4585,H000636 Full-Service Community Schools Act of 2004 108-hr-4585 H000636 Rep. Hinojosa, Ruben [D-TX-15] D TX 2004-09-28 0
108-hr-4585,E000179 Full-Service Community Schools Act of 2004 108-hr-4585 E000179 Rep. Engel, Eliot L. [D-NY-17] D NY 2004-09-28 0
108-hr-4585,L000480 Full-Service Community Schools Act of 2004 108-hr-4585 L000480 Rep. Lowey, Nita M. [D-NY-18] D NY 2004-09-28 0
108-hr-4585,K000188 Full-Service Community Schools Act of 2004 108-hr-4585 K000188 Rep. Kind, Ron [D-WI-3] D WI 2004-09-09 0
108-hr-4585,F000116 Full-Service Community Schools Act of 2004 108-hr-4585 F000116 Rep. Filner, Bob [D-CA-51] D CA 2004-09-09 0
108-hr-4585,W000738 Full-Service Community Schools Act of 2004 108-hr-4585 W000738 Rep. Woolsey, Lynn C. [D-CA-6] D CA 2004-09-08 0
108-hr-4585,C000191 Full-Service Community Schools Act of 2004 108-hr-4585 C000191 Rep. Carson, Julia [D-IN-7] D IN 2004-09-07 0
108-hr-4585,H000627 Full-Service Community Schools Act of 2004 108-hr-4585 H000627 Rep. Hinchey, Maurice D. [D-NY-22] D NY 2004-09-07 0
108-hr-4585,G000309 Full-Service Community Schools Act of 2004 108-hr-4585 G000309 Rep. Gordon, Bart [D-TN-6] D TN 2004-07-22 0
108-hr-4585,S000248 Full-Service Community Schools Act of 2004 108-hr-4585 S000248 Rep. Serrano, Jose E. [D-NY-16] D NY 2004-07-22 0
108-hr-4585,G000551 Full-Service Community Schools Act of 2004 108-hr-4585 G000551 Rep. Grijalva, Raúl M. [D-AZ-7] D AZ 2004-07-22 0
108-hr-4585,P000034 Full-Service Community Schools Act of 2004 108-hr-4585 P000034 Rep. Pallone, Frank, Jr. [D-NJ-6] D NJ 2004-07-22 0
108-hr-4585,S001153 Full-Service Community Schools Act of 2004 108-hr-4585 S001153 Rep. Solis, Hilda L. [D-CA-32] D CA 2004-07-22 0
108-hr-4585,S000033 Full-Service Community Schools Act of 2004 108-hr-4585 S000033 Rep. Sanders, Bernard [I-VT-At Large] I VT 2004-07-22 0
108-hr-4585,M000404 Full-Service Community Schools Act of 2004 108-hr-4585 M000404 Rep. McDermott, Jim [D-WA-7] D WA 2004-07-22 0
108-hr-4585,C001038 Full-Service Community Schools Act of 2004 108-hr-4585 C001038 Rep. Crowley, Joseph [D-NY-7] D NY 2004-07-22 0
108-hr-4585,F000043 Full-Service Community Schools Act of 2004 108-hr-4585 F000043 Rep. Fattah, Chaka [D-PA-2] D PA 2004-07-22 0
108-hr-4585,E000287 Full-Service Community Schools Act of 2004 108-hr-4585 E000287 Rep. Emanuel, Rahm [D-IL-5] D IL 2004-07-22 0
108-hr-4585,R000053 Full-Service Community Schools Act of 2004 108-hr-4585 R000053 Rep. Rangel, Charles B. [D-NY-15] D NY 2004-07-09 0
108-hr-4585,E000226 Full-Service Community Schools Act of 2004 108-hr-4585 E000226 Rep. Etheridge, Bob [D-NC-2] D NC 2004-07-09 0
108-hr-4585,B001241 Full-Service Community Schools Act of 2004 108-hr-4585 B001241 Rep. Bell, Chris [D-TX-25] D TX 2004-07-09 0
108-hr-4585,D000598 Full-Service Community Schools Act of 2004 108-hr-4585 D000598 Rep. Davis, Susan A. [D-CA-53] D CA 2004-07-09 0
108-hr-4585,J000284 Full-Service Community Schools Act of 2004 108-hr-4585 J000284 Rep. Jones, Stephanie Tubbs [D-OH-11] D OH 2004-07-09 0
108-hr-4585,B000490 Full-Service Community Schools Act of 2004 108-hr-4585 B000490 Rep. Bishop, Sanford D., Jr. [D-GA-2] D GA 2004-06-25 0
108-hr-4585,K000172 Full-Service Community Schools Act of 2004 108-hr-4585 K000172 Rep. Kildee, Dale E. [D-MI-5] D MI 2004-06-25 0
108-hr-4585,G000410 Full-Service Community Schools Act of 2004 108-hr-4585 G000410 Rep. Green, Gene [D-TX-29] D TX 2004-06-25 0
108-hr-4585,M000725 Full-Service Community Schools Act of 2004 108-hr-4585 M000725 Rep. Miller, George [D-CA-7] D CA 2004-06-25 0
108-hr-4585,O000159 Full-Service Community Schools Act of 2004 108-hr-4585 O000159 Rep. Owens, Major R. [D-NY-11] D NY 2004-06-25 0
108-hr-4585,F000392 Full-Service Community Schools Act of 2004 108-hr-4585 F000392 Rep. Frost, Martin [D-TX-24] D TX 2004-06-25 0

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);