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

25 rows where bill_id = "112-sjres-25" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: state, sponsorship_date, sponsorship_date (date)

is_original_cosponsor 2

  • 1 23
  • 0 2
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
112-sjres-25,C000880 A joint resolution relating to the disapproval of the President's exercise of authority to increase the debt limit, as submitted under section 3101A of title 31, United States Code, on August 2, 2011. 112-sjres-25 C000880 Sen. Crapo, Mike [R-ID] R ID 2011-09-08 0
112-sjres-25,R000584 A joint resolution relating to the disapproval of the President's exercise of authority to increase the debt limit, as submitted under section 3101A of title 31, United States Code, on August 2, 2011. 112-sjres-25 R000584 Sen. Risch, James E. [R-ID] R ID 2011-09-07 0
112-sjres-25,M000303 A joint resolution relating to the disapproval of the President's exercise of authority to increase the debt limit, as submitted under section 3101A of title 31, United States Code, on August 2, 2011. 112-sjres-25 M000303 Sen. McCain, John [R-AZ] R AZ 2011-09-06 1
112-sjres-25,P000603 A joint resolution relating to the disapproval of the President's exercise of authority to increase the debt limit, as submitted under section 3101A of title 31, United States Code, on August 2, 2011. 112-sjres-25 P000603 Sen. Paul, Rand [R-KY] R KY 2011-09-06 1
112-sjres-25,I000024 A joint resolution relating to the disapproval of the President's exercise of authority to increase the debt limit, as submitted under section 3101A of title 31, United States Code, on August 2, 2011. 112-sjres-25 I000024 Sen. Inhofe, James M. [R-OK] R OK 2011-09-06 1
112-sjres-25,B000575 A joint resolution relating to the disapproval of the President's exercise of authority to increase the debt limit, as submitted under section 3101A of title 31, United States Code, on August 2, 2011. 112-sjres-25 B000575 Sen. Blunt, Roy [R-MO] R MO 2011-09-06 1
112-sjres-25,C000542 A joint resolution relating to the disapproval of the President's exercise of authority to increase the debt limit, as submitted under section 3101A of title 31, United States Code, on August 2, 2011. 112-sjres-25 C000542 Sen. Coats, Daniel [R-IN] R IN 2011-09-06 1
112-sjres-25,E000285 A joint resolution relating to the disapproval of the President's exercise of authority to increase the debt limit, as submitted under section 3101A of title 31, United States Code, on August 2, 2011. 112-sjres-25 E000285 Sen. Enzi, Michael B. [R-WY] R WY 2011-09-06 1
112-sjres-25,G000386 A joint resolution relating to the disapproval of the President's exercise of authority to increase the debt limit, as submitted under section 3101A of title 31, United States Code, on August 2, 2011. 112-sjres-25 G000386 Sen. Grassley, Chuck [R-IA] R IA 2011-09-06 1
112-sjres-25,H001016 A joint resolution relating to the disapproval of the President's exercise of authority to increase the debt limit, as submitted under section 3101A of title 31, United States Code, on August 2, 2011. 112-sjres-25 H001016 Sen. Hutchison, Kay Bailey [R-TX] R TX 2011-09-06 1
112-sjres-25,R000307 A joint resolution relating to the disapproval of the President's exercise of authority to increase the debt limit, as submitted under section 3101A of title 31, United States Code, on August 2, 2011. 112-sjres-25 R000307 Sen. Roberts, Pat [R-KS] R KS 2011-09-06 1
112-sjres-25,S001141 A joint resolution relating to the disapproval of the President's exercise of authority to increase the debt limit, as submitted under section 3101A of title 31, United States Code, on August 2, 2011. 112-sjres-25 S001141 Sen. Sessions, Jeff [R-AL] R AL 2011-09-06 1
112-sjres-25,B001261 A joint resolution relating to the disapproval of the President's exercise of authority to increase the debt limit, as submitted under section 3101A of title 31, United States Code, on August 2, 2011. 112-sjres-25 B001261 Sen. Barrasso, John [R-WY] R WY 2011-09-06 1
112-sjres-25,B001236 A joint resolution relating to the disapproval of the President's exercise of authority to increase the debt limit, as submitted under section 3101A of title 31, United States Code, on August 2, 2011. 112-sjres-25 B001236 Sen. Boozman, John [R-AR] R AR 2011-09-06 1
112-sjres-25,C001056 A joint resolution relating to the disapproval of the President's exercise of authority to increase the debt limit, as submitted under section 3101A of title 31, United States Code, on August 2, 2011. 112-sjres-25 C001056 Sen. Cornyn, John [R-TX] R TX 2011-09-06 1
112-sjres-25,R000595 A joint resolution relating to the disapproval of the President's exercise of authority to increase the debt limit, as submitted under section 3101A of title 31, United States Code, on August 2, 2011. 112-sjres-25 R000595 Sen. Rubio, Marco [R-FL] R FL 2011-09-06 1
112-sjres-25,K000352 A joint resolution relating to the disapproval of the President's exercise of authority to increase the debt limit, as submitted under section 3101A of title 31, United States Code, on August 2, 2011. 112-sjres-25 K000352 Sen. Kyl, Jon [R-AZ] R AZ 2011-09-06 1
112-sjres-25,A000360 A joint resolution relating to the disapproval of the President's exercise of authority to increase the debt limit, as submitted under section 3101A of title 31, United States Code, on August 2, 2011. 112-sjres-25 A000360 Sen. Alexander, Lamar [R-TN] R TN 2011-09-06 1
112-sjres-25,H000338 A joint resolution relating to the disapproval of the President's exercise of authority to increase the debt limit, as submitted under section 3101A of title 31, United States Code, on August 2, 2011. 112-sjres-25 H000338 Sen. Hatch, Orrin G. [R-UT] R UT 2011-09-06 1
112-sjres-25,A000368 A joint resolution relating to the disapproval of the President's exercise of authority to increase the debt limit, as submitted under section 3101A of title 31, United States Code, on August 2, 2011. 112-sjres-25 A000368 Sen. Ayotte, Kelly [R-NH] R NH 2011-09-06 1
112-sjres-25,C000286 A joint resolution relating to the disapproval of the President's exercise of authority to increase the debt limit, as submitted under section 3101A of title 31, United States Code, on August 2, 2011. 112-sjres-25 C000286 Sen. Chambliss, Saxby [R-GA] R GA 2011-09-06 1
112-sjres-25,M000934 A joint resolution relating to the disapproval of the President's exercise of authority to increase the debt limit, as submitted under section 3101A of title 31, United States Code, on August 2, 2011. 112-sjres-25 M000934 Sen. Moran, Jerry [R-KS] R KS 2011-09-06 1
112-sjres-25,W000437 A joint resolution relating to the disapproval of the President's exercise of authority to increase the debt limit, as submitted under section 3101A of title 31, United States Code, on August 2, 2011. 112-sjres-25 W000437 Sen. Wicker, Roger F. [R-MS] R MS 2011-09-06 1
112-sjres-25,S000320 A joint resolution relating to the disapproval of the President's exercise of authority to increase the debt limit, as submitted under section 3101A of title 31, United States Code, on August 2, 2011. 112-sjres-25 S000320 Sen. Shelby, Richard C. [R-AL] R AL 2011-09-06 1
112-sjres-25,L000577 A joint resolution relating to the disapproval of the President's exercise of authority to increase the debt limit, as submitted under section 3101A of title 31, United States Code, on August 2, 2011. 112-sjres-25 L000577 Sen. Lee, Mike [R-UT] R UT 2011-09-06 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 106.298ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API