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

46 rows where bill_id = "108-hconres-486" 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 31
  • 0 15
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
108-hconres-486,F000392 Recognizing and honoring military unit family support volunteers for their dedicated service to the United States, the Armed Forces, and members of the Armed Forces and their families. 108-hconres-486 F000392 Rep. Frost, Martin [D-TX-24] D TX 2004-09-14 0
108-hconres-486,M000309 Recognizing and honoring military unit family support volunteers for their dedicated service to the United States, the Armed Forces, and members of the Armed Forces and their families. 108-hconres-486 M000309 Rep. McCarthy, Carolyn [D-NY-4] D NY 2004-09-14 0
108-hconres-486,B001203 Recognizing and honoring military unit family support volunteers for their dedicated service to the United States, the Armed Forces, and members of the Armed Forces and their families. 108-hconres-486 B001203 Rep. Buyer, Steve [R-IN-4] R IN 2004-09-14 0
108-hconres-486,B001244 Recognizing and honoring military unit family support volunteers for their dedicated service to the United States, the Armed Forces, and members of the Armed Forces and their families. 108-hconres-486 B001244 Rep. Bonner, Jo [R-AL-1] R AL 2004-09-14 0
108-hconres-486,B000490 Recognizing and honoring military unit family support volunteers for their dedicated service to the United States, the Armed Forces, and members of the Armed Forces and their families. 108-hconres-486 B000490 Rep. Bishop, Sanford D., Jr. [D-GA-2] D GA 2004-09-14 0
108-hconres-486,D000327 Recognizing and honoring military unit family support volunteers for their dedicated service to the United States, the Armed Forces, and members of the Armed Forces and their families. 108-hconres-486 D000327 Rep. Dicks, Norman D. [D-WA-6] D WA 2004-09-09 0
108-hconres-486,R000435 Recognizing and honoring military unit family support volunteers for their dedicated service to the United States, the Armed Forces, and members of the Armed Forces and their families. 108-hconres-486 R000435 Rep. Ros-Lehtinen, Ileana [R-FL-18] R FL 2004-09-09 0
108-hconres-486,K000172 Recognizing and honoring military unit family support volunteers for their dedicated service to the United States, the Armed Forces, and members of the Armed Forces and their families. 108-hconres-486 K000172 Rep. Kildee, Dale E. [D-MI-5] D MI 2004-09-09 0
108-hconres-486,S001150 Recognizing and honoring military unit family support volunteers for their dedicated service to the United States, the Armed Forces, and members of the Armed Forces and their families. 108-hconres-486 S001150 Rep. Schiff, Adam B. [D-CA-29] D CA 2004-09-09 0
108-hconres-486,G000180 Recognizing and honoring military unit family support volunteers for their dedicated service to the United States, the Armed Forces, and members of the Armed Forces and their families. 108-hconres-486 G000180 Rep. Gilchrest, Wayne T. [R-MD-1] R MD 2004-09-09 0
108-hconres-486,A000359 Recognizing and honoring military unit family support volunteers for their dedicated service to the United States, the Armed Forces, and members of the Armed Forces and their families. 108-hconres-486 A000359 Resident Commissioner Acevedo-Vila, Anibal [D-PR-At Large] D PR 2004-09-09 0
108-hconres-486,S000851 Recognizing and honoring military unit family support volunteers for their dedicated service to the United States, the Armed Forces, and members of the Armed Forces and their families. 108-hconres-486 S000851 Rep. Stenholm, Charles W. [D-TX-17] D TX 2004-09-08 0
108-hconres-486,M000404 Recognizing and honoring military unit family support volunteers for their dedicated service to the United States, the Armed Forces, and members of the Armed Forces and their families. 108-hconres-486 M000404 Rep. McDermott, Jim [D-WA-7] D WA 2004-09-08 0
108-hconres-486,G000551 Recognizing and honoring military unit family support volunteers for their dedicated service to the United States, the Armed Forces, and members of the Armed Forces and their families. 108-hconres-486 G000551 Rep. Grijalva, Raúl M. [D-AZ-7] D AZ 2004-09-08 0
108-hconres-486,M000316 Recognizing and honoring military unit family support volunteers for their dedicated service to the United States, the Armed Forces, and members of the Armed Forces and their families. 108-hconres-486 M000316 Rep. McCarthy, Karen [D-MO-5] D MO 2004-09-08 0
108-hconres-486,D000597 Recognizing and honoring military unit family support volunteers for their dedicated service to the United States, the Armed Forces, and members of the Armed Forces and their families. 108-hconres-486 D000597 Rep. Davis, Jo Ann [R-VA-1] R VA 2004-09-07 1
108-hconres-486,H000981 Recognizing and honoring military unit family support volunteers for their dedicated service to the United States, the Armed Forces, and members of the Armed Forces and their families. 108-hconres-486 H000981 Rep. Hunter, Duncan [R-CA-52] R CA 2004-09-07 1
108-hconres-486,W000268 Recognizing and honoring military unit family support volunteers for their dedicated service to the United States, the Armed Forces, and members of the Armed Forces and their families. 108-hconres-486 W000268 Rep. Weldon, Curt [R-PA-7] R PA 2004-09-07 1
108-hconres-486,H000444 Recognizing and honoring military unit family support volunteers for their dedicated service to the United States, the Armed Forces, and members of the Armed Forces and their families. 108-hconres-486 H000444 Rep. Hefley, Joel [R-CO-5] R CO 2004-09-07 1
108-hconres-486,M000472 Recognizing and honoring military unit family support volunteers for their dedicated service to the United States, the Armed Forces, and members of the Armed Forces and their families. 108-hconres-486 M000472 Rep. McHugh, John M. [R-NY-23] R NY 2004-09-07 1
108-hconres-486,W000789 Recognizing and honoring military unit family support volunteers for their dedicated service to the United States, the Armed Forces, and members of the Armed Forces and their families. 108-hconres-486 W000789 Rep. Wilson, Heather [R-NM-1] R NM 2004-09-07 1
108-hconres-486,S000465 Recognizing and honoring military unit family support volunteers for their dedicated service to the United States, the Armed Forces, and members of the Armed Forces and their families. 108-hconres-486 S000465 Rep. Skelton, Ike [D-MO-4] D MO 2004-09-07 1
108-hconres-486,B000208 Recognizing and honoring military unit family support volunteers for their dedicated service to the United States, the Armed Forces, and members of the Armed Forces and their families. 108-hconres-486 B000208 Rep. Bartlett, Roscoe G. [R-MD-6] R MD 2004-09-07 1
108-hconres-486,M001146 Recognizing and honoring military unit family support volunteers for their dedicated service to the United States, the Armed Forces, and members of the Armed Forces and their families. 108-hconres-486 M001146 Rep. Marshall, Jim [D-GA-3] D GA 2004-09-07 1
108-hconres-486,S001151 Recognizing and honoring military unit family support volunteers for their dedicated service to the United States, the Armed Forces, and members of the Armed Forces and their families. 108-hconres-486 S001151 Rep. Schrock, Edward L. [R-VA-2] R VA 2004-09-07 1
108-hconres-486,A000361 Recognizing and honoring military unit family support volunteers for their dedicated service to the United States, the Armed Forces, and members of the Armed Forces and their families. 108-hconres-486 A000361 Rep. Alexander, Rodney [R-LA-5] R LA 2004-09-07 1
108-hconres-486,P000034 Recognizing and honoring military unit family support volunteers for their dedicated service to the United States, the Armed Forces, and members of the Armed Forces and their families. 108-hconres-486 P000034 Rep. Pallone, Frank, Jr. [D-NJ-6] D NJ 2004-09-07 1
108-hconres-486,S000672 Recognizing and honoring military unit family support volunteers for their dedicated service to the United States, the Armed Forces, and members of the Armed Forces and their families. 108-hconres-486 S000672 Rep. Snyder, Vic [D-AR-2] D AR 2004-09-07 1
108-hconres-486,I000057 Recognizing and honoring military unit family support volunteers for their dedicated service to the United States, the Armed Forces, and members of the Armed Forces and their families. 108-hconres-486 I000057 Rep. Israel, Steve [D-NY-2] D NY 2004-09-07 1
108-hconres-486,S000097 Recognizing and honoring military unit family support volunteers for their dedicated service to the United States, the Armed Forces, and members of the Armed Forces and their families. 108-hconres-486 S000097 Rep. Saxton, Jim [R-NJ-3] R NJ 2004-09-07 1
108-hconres-486,T000057 Recognizing and honoring military unit family support volunteers for their dedicated service to the United States, the Armed Forces, and members of the Armed Forces and their families. 108-hconres-486 T000057 Rep. Tauscher, Ellen O. [D-CA-10] D CA 2004-09-07 1
108-hconres-486,M001144 Recognizing and honoring military unit family support volunteers for their dedicated service to the United States, the Armed Forces, and members of the Armed Forces and their families. 108-hconres-486 M001144 Rep. Miller, Jeff [R-FL-1] R FL 2004-09-07 1
108-hconres-486,S000510 Recognizing and honoring military unit family support volunteers for their dedicated service to the United States, the Armed Forces, and members of the Armed Forces and their families. 108-hconres-486 S000510 Rep. Smith, Adam [D-WA-9] D WA 2004-09-07 1
108-hconres-486,R000170 Recognizing and honoring military unit family support volunteers for their dedicated service to the United States, the Armed Forces, and members of the Armed Forces and their families. 108-hconres-486 R000170 Rep. Reyes, Silvestre [D-TX-16] D TX 2004-09-07 1
108-hconres-486,S000749 Recognizing and honoring military unit family support volunteers for their dedicated service to the United States, the Armed Forces, and members of the Armed Forces and their families. 108-hconres-486 S000749 Rep. Spratt, John M., Jr. [D-SC-5] D SC 2004-09-07 1
108-hconres-486,K000363 Recognizing and honoring military unit family support volunteers for their dedicated service to the United States, the Armed Forces, and members of the Armed Forces and their families. 108-hconres-486 K000363 Rep. Kline, John [R-MN-2] R MN 2004-09-07 1
108-hconres-486,O000107 Recognizing and honoring military unit family support volunteers for their dedicated service to the United States, the Armed Forces, and members of the Armed Forces and their families. 108-hconres-486 O000107 Rep. Ortiz, Solomon P. [D-TX-27] D TX 2004-09-07 1
108-hconres-486,B001234 Recognizing and honoring military unit family support volunteers for their dedicated service to the United States, the Armed Forces, and members of the Armed Forces and their families. 108-hconres-486 B001234 Rep. Baca, Joe [D-CA-43] D CA 2004-09-07 1
108-hconres-486,R000568 Recognizing and honoring military unit family support volunteers for their dedicated service to the United States, the Armed Forces, and members of the Armed Forces and their families. 108-hconres-486 R000568 Rep. Rodriguez, Ciro D. [D-TX-28] D TX 2004-09-07 1
108-hconres-486,E000250 Recognizing and honoring military unit family support volunteers for their dedicated service to the United States, the Armed Forces, and members of the Armed Forces and their families. 108-hconres-486 E000250 Rep. Evans, Lane [D-IL-17] D IL 2004-09-07 1
108-hconres-486,R000577 Recognizing and honoring military unit family support volunteers for their dedicated service to the United States, the Armed Forces, and members of the Armed Forces and their families. 108-hconres-486 R000577 Rep. Ryan, Tim [D-OH-17] D OH 2004-09-07 1
108-hconres-486,L000559 Recognizing and honoring military unit family support volunteers for their dedicated service to the United States, the Armed Forces, and members of the Armed Forces and their families. 108-hconres-486 L000559 Rep. Langevin, James R. [D-RI-2] D RI 2004-09-07 1
108-hconres-486,C000059 Recognizing and honoring military unit family support volunteers for their dedicated service to the United States, the Armed Forces, and members of the Armed Forces and their families. 108-hconres-486 C000059 Rep. Calvert, Ken [R-CA-44] R CA 2004-09-07 1
108-hconres-486,F000116 Recognizing and honoring military unit family support volunteers for their dedicated service to the United States, the Armed Forces, and members of the Armed Forces and their families. 108-hconres-486 F000116 Rep. Filner, Bob [D-CA-51] D CA 2004-09-07 1
108-hconres-486,L000560 Recognizing and honoring military unit family support volunteers for their dedicated service to the United States, the Armed Forces, and members of the Armed Forces and their families. 108-hconres-486 L000560 Rep. Larsen, Rick [D-WA-2] D WA 2004-09-07 1
108-hconres-486,H001030 Recognizing and honoring military unit family support volunteers for their dedicated service to the United States, the Armed Forces, and members of the Armed Forces and their families. 108-hconres-486 H001030 Rep. Hill, Baron P. [D-IN-9] D IN 2004-09-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);