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

66 rows where bill_id = "105-hr-2003" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

is_original_cosponsor 2

  • 0 50
  • 1 16
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
105-hr-2003,R000385 Budget Enforcement Act of 1997 105-hr-2003 R000385 Rep. Roemer, Tim [D-IN-3] D IN 1997-07-23 0
105-hr-2003,C000722 Budget Enforcement Act of 1997 105-hr-2003 C000722 Rep. Cook, Merrill [R-UT-2] R UT 1997-07-22 0
105-hr-2003,T000253 Budget Enforcement Act of 1997 105-hr-2003 T000253 Rep. Thurman, Karen L. [D-FL-5] D FL 1997-07-22 0
105-hr-2003,D000312 Budget Enforcement Act of 1997 105-hr-2003 D000312 Rep. Dickey, Jay [R-AR-4] R AR 1997-07-22 0
105-hr-2003,S000250 Budget Enforcement Act of 1997 105-hr-2003 S000250 Rep. Sessions, Pete [R-TX-5] R TX 1997-07-22 0
105-hr-2003,D000114 Budget Enforcement Act of 1997 105-hr-2003 D000114 Rep. Davis, Jim [D-FL-11] D FL 1997-07-22 0
105-hr-2003,S000718 Budget Enforcement Act of 1997 105-hr-2003 S000718 Rep. Spence, Floyd [R-SC-2] R SC 1997-07-22 0
105-hr-2003,S000125 Budget Enforcement Act of 1997 105-hr-2003 S000125 Rep. Schiff, Steven [R-NM-1] R NM 1997-07-22 0
105-hr-2003,T000074 Budget Enforcement Act of 1997 105-hr-2003 T000074 Rep. Taylor, Gene [D-MS-5] D MS 1997-07-22 0
105-hr-2003,H000789 Budget Enforcement Act of 1997 105-hr-2003 H000789 Rep. Horn, Stephen [R-CA-38] R CA 1997-07-22 0
105-hr-2003,E000063 Budget Enforcement Act of 1997 105-hr-2003 E000063 Rep. Edwards, Chet [D-TX-11] D TX 1997-07-17 0
105-hr-2003,G000280 Budget Enforcement Act of 1997 105-hr-2003 G000280 Rep. Goode, Virgil H., Jr. [D-VA-5] D VA 1997-07-17 0
105-hr-2003,B000420 Budget Enforcement Act of 1997 105-hr-2003 B000420 Rep. Berry, Marion [D-AR-1] D AR 1997-07-17 0
105-hr-2003,H000814 Budget Enforcement Act of 1997 105-hr-2003 H000814 Rep. Houghton, Amo [R-NY-31] R NY 1997-07-17 0
105-hr-2003,H000114 Budget Enforcement Act of 1997 105-hr-2003 H000114 Rep. Hamilton, Lee H. [D-IN-9] D IN 1997-07-17 0
105-hr-2003,C000868 Budget Enforcement Act of 1997 105-hr-2003 C000868 Rep. Cramer, Robert E. (Bud), Jr. [D-AL-5] D AL 1997-07-17 0
105-hr-2003,D000275 Budget Enforcement Act of 1997 105-hr-2003 D000275 Rep. Deutsch, Peter [D-FL-20] D FL 1997-07-17 0
105-hr-2003,M000466 Budget Enforcement Act of 1997 105-hr-2003 M000466 Rep. McHale, Paul [D-PA-15] D PA 1997-07-17 0
105-hr-2003,K000188 Budget Enforcement Act of 1997 105-hr-2003 K000188 Rep. Kind, Ron [D-WI-3] D WI 1997-07-17 0
105-hr-2003,B000177 Budget Enforcement Act of 1997 105-hr-2003 B000177 Rep. Barrett, Thomas M. [D-WI-5] D WI 1997-07-17 0
105-hr-2003,E000215 Budget Enforcement Act of 1997 105-hr-2003 E000215 Rep. Eshoo, Anna G. [D-CA-14] D CA 1997-07-17 0
105-hr-2003,H000448 Budget Enforcement Act of 1997 105-hr-2003 H000448 Rep. Hefner, W. G. (Bill) [D-NC-8] D NC 1997-07-17 0
105-hr-2003,B000652 Budget Enforcement Act of 1997 105-hr-2003 B000652 Rep. Boswell, Leonard L. [D-IA-3] D IA 1997-07-17 0
105-hr-2003,B000490 Budget Enforcement Act of 1997 105-hr-2003 B000490 Rep. Bishop, Sanford D., Jr. [D-GA-2] D GA 1997-07-17 0
105-hr-2003,S000453 Budget Enforcement Act of 1997 105-hr-2003 S000453 Rep. Sisisky, Norman [D-VA-4] D VA 1997-07-17 0
105-hr-2003,J000149 Budget Enforcement Act of 1997 105-hr-2003 J000149 Rep. Johnson, Jay W. [D-WI-8] D WI 1997-07-17 0
105-hr-2003,K000274 Budget Enforcement Act of 1997 105-hr-2003 K000274 Rep. Klug, Scott L. [R-WI-2] R WI 1997-07-17 0
105-hr-2003,B000134 Budget Enforcement Act of 1997 105-hr-2003 B000134 Rep. Barcia, James A. [D-MI-5] D MI 1997-07-17 0
105-hr-2003,K000118 Budget Enforcement Act of 1997 105-hr-2003 K000118 Rep. Kennelly, Barbara B. [D-CT-1] D CT 1997-07-17 0
105-hr-2003,M000523 Budget Enforcement Act of 1997 105-hr-2003 M000523 Rep. McKinney, Cynthia A. [D-GA-4] D GA 1997-07-17 0
105-hr-2003,S001045 Budget Enforcement Act of 1997 105-hr-2003 S001045 Rep. Stupak, Bart [D-MI-1] D MI 1997-07-17 0
105-hr-2003,M000485 Budget Enforcement Act of 1997 105-hr-2003 M000485 Rep. McIntyre, Mike [D-NC-7] D NC 1997-07-17 0
105-hr-2003,E000187 Budget Enforcement Act of 1997 105-hr-2003 E000187 Rep. English, Phil [R-PA-21] R PA 1997-07-17 0
105-hr-2003,S000109 Budget Enforcement Act of 1997 105-hr-2003 S000109 Rep. Schaefer, Dan [R-CO-6] R CO 1997-07-17 0
105-hr-2003,M000933 Budget Enforcement Act of 1997 105-hr-2003 M000933 Rep. Moran, James P. [D-VA-8] D VA 1997-07-09 0
105-hr-2003,C000560 Budget Enforcement Act of 1997 105-hr-2003 C000560 Rep. Coburn, Tom [R-OK-2] R OK 1997-07-09 0
105-hr-2003,M000316 Budget Enforcement Act of 1997 105-hr-2003 M000316 Rep. McCarthy, Karen [D-MO-5] D MO 1997-07-09 0
105-hr-2003,P000258 Budget Enforcement Act of 1997 105-hr-2003 P000258 Rep. Peterson, Collin C. [D-MN-7] D MN 1997-06-26 0
105-hr-2003,H000712 Budget Enforcement Act of 1997 105-hr-2003 H000712 Rep. Holden, Tim [D-PA-6] D PA 1997-06-26 0
105-hr-2003,H000213 Budget Enforcement Act of 1997 105-hr-2003 H000213 Rep. Harman, Jane [D-CA-36] D CA 1997-06-26 0
105-hr-2003,T000424 Budget Enforcement Act of 1997 105-hr-2003 T000424 Rep. Turner, Jim [D-TX-2] D TX 1997-06-26 0
105-hr-2003,B000028 Budget Enforcement Act of 1997 105-hr-2003 B000028 Rep. Baesler, Scotty [D-KY-6] D KY 1997-06-26 0
105-hr-2003,J000110 Budget Enforcement Act of 1997 105-hr-2003 J000110 Rep. John, Christopher [D-LA-7] D LA 1997-06-26 0
105-hr-2003,U000031 Budget Enforcement Act of 1997 105-hr-2003 U000031 Rep. Upton, Fred [R-MI-6] R MI 1997-06-26 0
105-hr-2003,M000627 Budget Enforcement Act of 1997 105-hr-2003 M000627 Rep. Meehan, Martin T. [D-MA-5] D MA 1997-06-24 0
105-hr-2003,D000424 Budget Enforcement Act of 1997 105-hr-2003 D000424 Rep. Dooley, Calvin M. [D-CA-20] D CA 1997-06-24 0
105-hr-2003,D000482 Budget Enforcement Act of 1997 105-hr-2003 D000482 Rep. Doyle, Michael F. [D-PA-18] D PA 1997-06-24 0
105-hr-2003,M000941 Budget Enforcement Act of 1997 105-hr-2003 M000941 Rep. Morella, Constance A. [R-MD-8] R MD 1997-06-24 0
105-hr-2003,R000465 Budget Enforcement Act of 1997 105-hr-2003 R000465 Rep. Roukema, Marge [R-NJ-5] R NJ 1997-06-24 0
105-hr-2003,H000067 Budget Enforcement Act of 1997 105-hr-2003 H000067 Rep. Hall, Ralph M. [D-TX-4] D TX 1997-06-24 0
105-hr-2003,M000795 Budget Enforcement Act of 1997 105-hr-2003 M000795 Rep. Minge, David [D-MN-2] D MN 1997-06-20 1
105-hr-2003,S000851 Budget Enforcement Act of 1997 105-hr-2003 S000851 Rep. Stenholm, Charles W. [D-TX-17] D TX 1997-06-20 1
105-hr-2003,W000119 Budget Enforcement Act of 1997 105-hr-2003 W000119 Rep. Wamp, Zach [R-TN-3] R TN 1997-06-20 1
105-hr-2003,A000210 Budget Enforcement Act of 1997 105-hr-2003 A000210 Rep. Andrews, Robert E. [D-NJ-1] D NJ 1997-06-20 1
105-hr-2003,B000104 Budget Enforcement Act of 1997 105-hr-2003 B000104 Rep. Ballenger, Cass [R-NC-10] R NC 1997-06-20 1
105-hr-2003,B000716 Budget Enforcement Act of 1997 105-hr-2003 B000716 Rep. Boyd, Allen [D-FL-2] D FL 1997-06-20 1
105-hr-2003,C000243 Budget Enforcement Act of 1997 105-hr-2003 C000243 Rep. Castle, Michael N. [R-DE-At Large] R DE 1997-06-20 1
105-hr-2003,T000038 Budget Enforcement Act of 1997 105-hr-2003 T000038 Rep. Tanner, John S. [D-TN-8] D TN 1997-06-20 1
105-hr-2003,T000057 Budget Enforcement Act of 1997 105-hr-2003 T000057 Rep. Tauscher, Ellen O. [D-CA-10] D CA 1997-06-20 1
105-hr-2003,V000108 Budget Enforcement Act of 1997 105-hr-2003 V000108 Rep. Visclosky, Peter J. [D-IN-1] D IN 1997-06-20 1
105-hr-2003,C000670 Budget Enforcement Act of 1997 105-hr-2003 C000670 Rep. Condit, Gary A. [D-CA-18] D CA 1997-06-20 1
105-hr-2003,L000521 Budget Enforcement Act of 1997 105-hr-2003 L000521 Rep. Luther, Bill [D-MN-6] D MN 1997-06-20 1
105-hr-2003,S000030 Budget Enforcement Act of 1997 105-hr-2003 S000030 Rep. Sanchez, Loretta [D-CA-46] D CA 1997-06-20 1
105-hr-2003,R000033 Budget Enforcement Act of 1997 105-hr-2003 R000033 Rep. Ramstad, Jim [R-MN-3] R MN 1997-06-20 1
105-hr-2003,N000054 Budget Enforcement Act of 1997 105-hr-2003 N000054 Rep. Neumann, Mark W. [R-WI-1] R WI 1997-06-20 1
105-hr-2003,G000359 Budget Enforcement Act of 1997 105-hr-2003 G000359 Rep. Graham, Lindsey [R-SC-3] R SC 1997-06-20 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 2.159ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API · Privacy