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

38 rows where bill_id = "111-hconres-267" 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

  • 0 37
  • 1 1
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
111-hconres-267,B001257 Congratulating the Baltic nations of Estonia, Latvia, and Lithuania on the 20th anniversary of their declarations on the restoration of independence from the Soviet Union. 111-hconres-267 B001257 Rep. Bilirakis, Gus M. [R-FL-9] R FL 2010-12-07 0
111-hconres-267,W000215 Congratulating the Baltic nations of Estonia, Latvia, and Lithuania on the 20th anniversary of their declarations on the restoration of independence from the Soviet Union. 111-hconres-267 W000215 Rep. Waxman, Henry A. [D-CA-30] D CA 2010-12-02 0
111-hconres-267,W000795 Congratulating the Baltic nations of Estonia, Latvia, and Lithuania on the 20th anniversary of their declarations on the restoration of independence from the Soviet Union. 111-hconres-267 W000795 Rep. Wilson, Joe [R-SC-2] R SC 2010-12-02 0
111-hconres-267,M000689 Congratulating the Baltic nations of Estonia, Latvia, and Lithuania on the 20th anniversary of their declarations on the restoration of independence from the Soviet Union. 111-hconres-267 M000689 Rep. Mica, John L. [R-FL-7] R FL 2010-12-02 0
111-hconres-267,A000055 Congratulating the Baltic nations of Estonia, Latvia, and Lithuania on the 20th anniversary of their declarations on the restoration of independence from the Soviet Union. 111-hconres-267 A000055 Rep. Aderholt, Robert B. [R-AL-4] R AL 2010-11-30 0
111-hconres-267,G000535 Congratulating the Baltic nations of Estonia, Latvia, and Lithuania on the 20th anniversary of their declarations on the restoration of independence from the Soviet Union. 111-hconres-267 G000535 Rep. Gutierrez, Luis V. [D-IL-4] D IL 2010-11-18 0
111-hconres-267,W000187 Congratulating the Baltic nations of Estonia, Latvia, and Lithuania on the 20th anniversary of their declarations on the restoration of independence from the Soviet Union. 111-hconres-267 W000187 Rep. Waters, Maxine [D-CA-35] D CA 2010-11-18 0
111-hconres-267,S000522 Congratulating the Baltic nations of Estonia, Latvia, and Lithuania on the 20th anniversary of their declarations on the restoration of independence from the Soviet Union. 111-hconres-267 S000522 Rep. Smith, Christopher H. [R-NJ-4] R NJ 2010-11-18 0
111-hconres-267,C000794 Congratulating the Baltic nations of Estonia, Latvia, and Lithuania on the 20th anniversary of their declarations on the restoration of independence from the Soviet Union. 111-hconres-267 C000794 Rep. Costello, Jerry F. [D-IL-12] D IL 2010-11-16 0
111-hconres-267,R000515 Congratulating the Baltic nations of Estonia, Latvia, and Lithuania on the 20th anniversary of their declarations on the restoration of independence from the Soviet Union. 111-hconres-267 R000515 Rep. Rush, Bobby L. [D-IL-1] D IL 2010-11-16 0
111-hconres-267,W000672 Congratulating the Baltic nations of Estonia, Latvia, and Lithuania on the 20th anniversary of their declarations on the restoration of independence from the Soviet Union. 111-hconres-267 W000672 Rep. Wolf, Frank R. [R-VA-10] R VA 2010-11-16 0
111-hconres-267,M001138 Congratulating the Baltic nations of Estonia, Latvia, and Lithuania on the 20th anniversary of their declarations on the restoration of independence from the Soviet Union. 111-hconres-267 M001138 Rep. Manzullo, Donald A. [R-IL-16] R IL 2010-09-29 0
111-hconres-267,G000021 Congratulating the Baltic nations of Estonia, Latvia, and Lithuania on the 20th anniversary of their declarations on the restoration of independence from the Soviet Union. 111-hconres-267 G000021 Rep. Gallegly, Elton [R-CA-24] R CA 2010-09-29 0
111-hconres-267,I000023 Congratulating the Baltic nations of Estonia, Latvia, and Lithuania on the 20th anniversary of their declarations on the restoration of independence from the Soviet Union. 111-hconres-267 I000023 Rep. Inglis, Bob [R-SC-4] R SC 2010-09-29 0
111-hconres-267,S001165 Congratulating the Baltic nations of Estonia, Latvia, and Lithuania on the 20th anniversary of their declarations on the restoration of independence from the Soviet Union. 111-hconres-267 S001165 Rep. Sires, Albio [D-NJ-13] D NJ 2010-09-29 0
111-hconres-267,P000592 Congratulating the Baltic nations of Estonia, Latvia, and Lithuania on the 20th anniversary of their declarations on the restoration of independence from the Soviet Union. 111-hconres-267 P000592 Rep. Poe, Ted [R-TX-2] R TX 2010-09-29 0
111-hconres-267,B001232 Congratulating the Baltic nations of Estonia, Latvia, and Lithuania on the 20th anniversary of their declarations on the restoration of independence from the Soviet Union. 111-hconres-267 B001232 Rep. Biggert, Judy [R-IL-13] R IL 2010-09-29 0
111-hconres-267,R000581 Congratulating the Baltic nations of Estonia, Latvia, and Lithuania on the 20th anniversary of their declarations on the restoration of independence from the Soviet Union. 111-hconres-267 R000581 Rep. Richardson, Laura [D-CA-37] D CA 2010-09-29 0
111-hconres-267,S000030 Congratulating the Baltic nations of Estonia, Latvia, and Lithuania on the 20th anniversary of their declarations on the restoration of independence from the Soviet Union. 111-hconres-267 S000030 Rep. Sanchez, Loretta [D-CA-47] D CA 2010-09-29 0
111-hconres-267,Q000023 Congratulating the Baltic nations of Estonia, Latvia, and Lithuania on the 20th anniversary of their declarations on the restoration of independence from the Soviet Union. 111-hconres-267 Q000023 Rep. Quigley, Mike [D-IL-5] D IL 2010-09-28 0
111-hconres-267,B001256 Congratulating the Baltic nations of Estonia, Latvia, and Lithuania on the 20th anniversary of their declarations on the restoration of independence from the Soviet Union. 111-hconres-267 B001256 Rep. Bachmann, Michele [R-MN-6] R MN 2010-09-28 0
111-hconres-267,R000409 Congratulating the Baltic nations of Estonia, Latvia, and Lithuania on the 20th anniversary of their declarations on the restoration of independence from the Soviet Union. 111-hconres-267 R000409 Rep. Rohrabacher, Dana [R-CA-46] R CA 2010-09-28 0
111-hconres-267,F000010 Congratulating the Baltic nations of Estonia, Latvia, and Lithuania on the 20th anniversary of their declarations on the restoration of independence from the Soviet Union. 111-hconres-267 F000010 Del. Faleomavaega, Eni F. H. [D-AS-At Large] D AS 2010-09-28 0
111-hconres-267,K000360 Congratulating the Baltic nations of Estonia, Latvia, and Lithuania on the 20th anniversary of their declarations on the restoration of independence from the Soviet Union. 111-hconres-267 K000360 Rep. Kirk, Mark Steven [R-IL-10] R IL 2010-09-23 0
111-hconres-267,P000373 Congratulating the Baltic nations of Estonia, Latvia, and Lithuania on the 20th anniversary of their declarations on the restoration of independence from the Soviet Union. 111-hconres-267 P000373 Rep. Pitts, Joseph R. [R-PA-16] R PA 2010-09-22 0
111-hconres-267,S001157 Congratulating the Baltic nations of Estonia, Latvia, and Lithuania on the 20th anniversary of their declarations on the restoration of independence from the Soviet Union. 111-hconres-267 S001157 Rep. Scott, David [D-GA-13] D GA 2010-09-22 0
111-hconres-267,H000712 Congratulating the Baltic nations of Estonia, Latvia, and Lithuania on the 20th anniversary of their declarations on the restoration of independence from the Soviet Union. 111-hconres-267 H000712 Rep. Holden, Tim [D-PA-17] D PA 2010-09-16 0
111-hconres-267,C001078 Congratulating the Baltic nations of Estonia, Latvia, and Lithuania on the 20th anniversary of their declarations on the restoration of independence from the Soviet Union. 111-hconres-267 C001078 Rep. Connolly, Gerald E. [D-VA-11] D VA 2010-09-15 0
111-hconres-267,P000594 Congratulating the Baltic nations of Estonia, Latvia, and Lithuania on the 20th anniversary of their declarations on the restoration of independence from the Soviet Union. 111-hconres-267 P000594 Rep. Paulsen, Erik [R-MN-3] R MN 2010-07-14 0
111-hconres-267,T000038 Congratulating the Baltic nations of Estonia, Latvia, and Lithuania on the 20th anniversary of their declarations on the restoration of independence from the Soviet Union. 111-hconres-267 T000038 Rep. Tanner, John S. [D-TN-8] D TN 2010-06-23 0
111-hconres-267,D000299 Congratulating the Baltic nations of Estonia, Latvia, and Lithuania on the 20th anniversary of their declarations on the restoration of independence from the Soviet Union. 111-hconres-267 D000299 Rep. Diaz-Balart, Lincoln [R-FL-21] R FL 2010-05-26 0
111-hconres-267,M001147 Congratulating the Baltic nations of Estonia, Latvia, and Lithuania on the 20th anniversary of their declarations on the restoration of independence from the Soviet Union. 111-hconres-267 M001147 Rep. McCotter, Thaddeus G. [R-MI-11] R MI 2010-05-25 0
111-hconres-267,L000563 Congratulating the Baltic nations of Estonia, Latvia, and Lithuania on the 20th anniversary of their declarations on the restoration of independence from the Soviet Union. 111-hconres-267 L000563 Rep. Lipinski, Daniel [D-IL-3] D IL 2010-05-20 0
111-hconres-267,Y000031 Congratulating the Baltic nations of Estonia, Latvia, and Lithuania on the 20th anniversary of their declarations on the restoration of independence from the Soviet Union. 111-hconres-267 Y000031 Rep. Young, C. W. Bill [R-FL-10] R FL 2010-05-20 0
111-hconres-267,S001179 Congratulating the Baltic nations of Estonia, Latvia, and Lithuania on the 20th anniversary of their declarations on the restoration of independence from the Soviet Union. 111-hconres-267 S001179 Rep. Schock, Aaron [R-IL-18] R IL 2010-05-11 0
111-hconres-267,H000324 Congratulating the Baltic nations of Estonia, Latvia, and Lithuania on the 20th anniversary of their declarations on the restoration of independence from the Soviet Union. 111-hconres-267 H000324 Rep. Hastings, Alcee L. [D-FL-23] D FL 2010-05-11 0
111-hconres-267,B001231 Congratulating the Baltic nations of Estonia, Latvia, and Lithuania on the 20th anniversary of their declarations on the restoration of independence from the Soviet Union. 111-hconres-267 B001231 Rep. Berkley, Shelley [D-NV-1] D NV 2010-05-04 0
111-hconres-267,K000336 Congratulating the Baltic nations of Estonia, Latvia, and Lithuania on the 20th anniversary of their declarations on the restoration of independence from the Soviet Union. 111-hconres-267 K000336 Rep. Kucinich, Dennis J. [D-OH-10] D OH 2010-04-26 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);