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

62 rows where bill_id = "103-hr-739" 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 52
  • 1 10
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
103-hr-739,L000267 Declaration of Official Language Act of 1993 103-hr-739 L000267 Rep. Levy, David A. [R-NY-4] R NY 1994-09-29 0
103-hr-739,B000151 Declaration of Official Language Act of 1993 103-hr-739 B000151 Rep. Barlow, Tom [D-KY-1] D KY 1994-08-05 0
103-hr-739,H001015 Declaration of Official Language Act of 1993 103-hr-739 H001015 Rep. Hutchinson, Tim [R-AR-3] R AR 1994-04-19 0
103-hr-739,S001044 Declaration of Official Language Act of 1993 103-hr-739 S001044 Rep. Stump, Bob [R-AZ-3] R AZ 1994-02-02 0
103-hr-739,T000024 Declaration of Official Language Act of 1993 103-hr-739 T000024 Rep. Talent, Jim [R-MO-2] R MO 1994-02-02 0
103-hr-739,J000177 Declaration of Official Language Act of 1993 103-hr-739 J000177 Rep. Johnson, Tim [D-SD-At Large] D SD 1994-01-25 0
103-hr-739,P000148 Declaration of Official Language Act of 1993 103-hr-739 P000148 Rep. Paxon, Bill [R-NY-27] R NY 1994-01-25 0
103-hr-739,B000013 Declaration of Official Language Act of 1993 103-hr-739 B000013 Rep. Bachus, Spencer [R-AL-6] R AL 1994-01-25 0
103-hr-739,G000289 Declaration of Official Language Act of 1993 103-hr-739 G000289 Rep. Goodlatte, Bob [R-VA-6] R VA 1993-11-21 0
103-hr-739,T000162 Declaration of Official Language Act of 1993 103-hr-739 T000162 Rep. Thomas, Craig [R-WY-At Large] R WY 1993-11-09 0
103-hr-739,Z000004 Declaration of Official Language Act of 1993 103-hr-739 Z000004 Rep. Zeliff, William H., Jr. [R-NH-1] R NH 1993-11-09 0
103-hr-739,K000210 Declaration of Official Language Act of 1993 103-hr-739 K000210 Rep. King, Peter T. [R-NY-3] R NY 1993-11-04 0
103-hr-739,L000295 Declaration of Official Language Act of 1993 103-hr-739 L000295 Rep. Lewis, Thomas F. [R-FL-16] R FL 1993-09-28 0
103-hr-739,K000288 Declaration of Official Language Act of 1993 103-hr-739 K000288 Rep. Knollenberg, Joe [R-MI-11] R MI 1993-09-28 0
103-hr-739,C000830 Declaration of Official Language Act of 1993 103-hr-739 C000830 Rep. Cox, Christopher [R-CA-47] R CA 1993-09-28 0
103-hr-739,K000220 Declaration of Official Language Act of 1993 103-hr-739 K000220 Rep. Kingston, Jack [R-GA-1] R GA 1993-06-24 0
103-hr-739,G000180 Declaration of Official Language Act of 1993 103-hr-739 G000180 Rep. Gilchrest, Wayne T. [R-MD-1] R MD 1993-06-24 0
103-hr-739,R000307 Declaration of Official Language Act of 1993 103-hr-739 R000307 Rep. Roberts, Pat [R-KS-1] R KS 1993-06-08 0
103-hr-739,B000078 Declaration of Official Language Act of 1993 103-hr-739 B000078 Rep. Baker, Bill [R-CA-10] R CA 1993-06-08 0
103-hr-739,P000419 Declaration of Official Language Act of 1993 103-hr-739 P000419 Rep. Pombo, Richard W. [R-CA-11] R CA 1993-05-20 0
103-hr-739,F000328 Declaration of Official Language Act of 1993 103-hr-739 F000328 Rep. Fowler, Tillie [R-FL-4] R FL 1993-05-20 0
103-hr-739,S000394 Declaration of Official Language Act of 1993 103-hr-739 S000394 Rep. Shuster, Bud [R-PA-9] R PA 1993-05-12 0
103-hr-739,T000067 Declaration of Official Language Act of 1993 103-hr-739 T000067 Rep. Taylor, Charles H. [R-NC-11] R NC 1993-05-12 0
103-hr-739,R000395 Declaration of Official Language Act of 1993 103-hr-739 R000395 Rep. Rogers, Harold [R-KY-5] R KY 1993-04-29 0
103-hr-739,B000213 Declaration of Official Language Act of 1993 103-hr-739 B000213 Rep. Barton, Joe [R-TX-6] R TX 1993-04-29 0
103-hr-739,E000268 Declaration of Official Language Act of 1993 103-hr-739 E000268 Rep. Everett, Terry [R-AL-2] R AL 1993-04-29 0
103-hr-739,A000214 Declaration of Official Language Act of 1993 103-hr-739 A000214 Rep. Applegate, Douglas [D-OH-18] D OH 1993-04-21 0
103-hr-739,D000435 Declaration of Official Language Act of 1993 103-hr-739 D000435 Rep. Dornan, Robert K. [R-CA-46] R CA 1993-04-21 0
103-hr-739,S000244 Declaration of Official Language Act of 1993 103-hr-739 S000244 Rep. Sensenbrenner, F. James, Jr. [R-WI-9] R WI 1993-04-21 0
103-hr-739,B001066 Declaration of Official Language Act of 1993 103-hr-739 B001066 Rep. Bunning, Jim [R-KY-4] R KY 1993-04-21 0
103-hr-739,C000052 Declaration of Official Language Act of 1993 103-hr-739 C000052 Rep. Callahan, Sonny [R-AL-1] R AL 1993-03-29 0
103-hr-739,G000225 Declaration of Official Language Act of 1993 103-hr-739 G000225 Rep. Gingrich, Newt [R-GA-6] R GA 1993-03-29 0
103-hr-739,B000556 Declaration of Official Language Act of 1993 103-hr-739 B000556 Rep. Bliley, Tom [R-VA-7] R VA 1993-03-29 0
103-hr-739,I000023 Declaration of Official Language Act of 1993 103-hr-739 I000023 Rep. Inglis, Bob [R-SC-4] R SC 1993-03-29 0
103-hr-739,R000487 Declaration of Official Language Act of 1993 103-hr-739 R000487 Rep. Royce, Edward R. [R-CA-39] R CA 1993-03-29 0
103-hr-739,L000321 Declaration of Official Language Act of 1993 103-hr-739 L000321 Rep. Linder, John [R-GA-4] R GA 1993-03-29 0
103-hr-739,H000151 Declaration of Official Language Act of 1993 103-hr-739 H000151 Rep. Hancock, Mel [R-MO-7] R MO 1993-03-29 0
103-hr-739,J000174 Declaration of Official Language Act of 1993 103-hr-739 J000174 Rep. Johnson, Sam [R-TX-3] R TX 1993-03-18 0
103-hr-739,A000215 Declaration of Official Language Act of 1993 103-hr-739 A000215 Rep. Archer, Bill [R-TX-7] R TX 1993-03-18 0
103-hr-739,D000533 Declaration of Official Language Act of 1993 103-hr-739 D000533 Rep. Duncan, John J., Jr. [R-TN-2] R TN 1993-03-18 0
103-hr-739,V000006 Declaration of Official Language Act of 1993 103-hr-739 V000006 Rep. Valentine, Tim [D-NC-2] D NC 1993-03-18 0
103-hr-739,P000066 Declaration of Official Language Act of 1993 103-hr-739 P000066 Rep. Parker, Mike [D-MS-4] D MS 1993-03-11 0
103-hr-739,B001149 Declaration of Official Language Act of 1993 103-hr-739 B001149 Rep. Burton, Dan [R-IN-6] R IN 1993-03-11 0
103-hr-739,C000556 Declaration of Official Language Act of 1993 103-hr-739 C000556 Rep. Coble, Howard [R-NC-6] R NC 1993-03-11 0
103-hr-739,K000016 Declaration of Official Language Act of 1993 103-hr-739 K000016 Rep. Kasich, John R. [R-OH-12] R OH 1993-03-01 0
103-hr-739,G000025 Declaration of Official Language Act of 1993 103-hr-739 G000025 Rep. Gallo, Dean A. [R-NJ-11] R NJ 1993-03-01 0
103-hr-739,L000371 Declaration of Official Language Act of 1993 103-hr-739 L000371 Rep. Livingston, Bob [R-LA-1] R LA 1993-03-01 0
103-hr-739,I000024 Declaration of Official Language Act of 1993 103-hr-739 I000024 Rep. Inhofe, James M. [R-OK-1] R OK 1993-03-01 0
103-hr-739,D000429 Declaration of Official Language Act of 1993 103-hr-739 D000429 Rep. Doolittle, John T. [R-CA-4] R CA 1993-02-16 0
103-hr-739,L000342 Declaration of Official Language Act of 1993 103-hr-739 L000342 Rep. Lipinski, William O. [D-IL-3] D IL 1993-02-16 0
103-hr-739,S000059 Declaration of Official Language Act of 1993 103-hr-739 S000059 Rep. Santorum, Rick [R-PA-18] R PA 1993-02-16 0
103-hr-739,B000208 Declaration of Official Language Act of 1993 103-hr-739 B000208 Rep. Bartlett, Roscoe G. [R-MD-6] R MD 1993-02-16 0
103-hr-739,S000097 Declaration of Official Language Act of 1993 103-hr-739 S000097 Rep. Saxton, Jim [R-NJ-3] R NJ 1993-02-02 1
103-hr-739,P000005 Declaration of Official Language Act of 1993 103-hr-739 P000005 Rep. Packard, Ron [R-CA-48] R CA 1993-02-02 1
103-hr-739,B000072 Declaration of Official Language Act of 1993 103-hr-739 B000072 Rep. Baker, Richard H. [R-LA-6] R LA 1993-02-02 1
103-hr-739,S000453 Declaration of Official Language Act of 1993 103-hr-739 S000453 Rep. Sisisky, Norman [D-VA-4] D VA 1993-02-02 1
103-hr-739,C000873 Declaration of Official Language Act of 1993 103-hr-739 C000873 Rep. Crane, Philip M. [R-IL-8] R IL 1993-02-02 1
103-hr-739,A000217 Declaration of Official Language Act of 1993 103-hr-739 A000217 Rep. Armey, Richard K. [R-TX-26] R TX 1993-02-02 1
103-hr-739,O000163 Declaration of Official Language Act of 1993 103-hr-739 O000163 Rep. Oxley, Michael G. [R-OH-4] R OH 1993-02-02 1
103-hr-739,R000409 Declaration of Official Language Act of 1993 103-hr-739 R000409 Rep. Rohrabacher, Dana [R-CA-45] R CA 1993-02-02 1
103-hr-739,H001022 Declaration of Official Language Act of 1993 103-hr-739 H001022 Rep. Hyde, Henry J. [R-IL-6] R IL 1993-02-02 1
103-hr-739,H000528 Declaration of Official Language Act of 1993 103-hr-739 H000528 Rep. Herger, Wally [R-CA-2] R CA 1993-02-02 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);