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

30 rows where bill_id = "115-hr-5248" 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 24
  • 1 6
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
115-hr-5248,N000147 Sustainable Shark Fisheries and Trade Act 115-hr-5248 N000147 Del. Norton, Eleanor Holmes [D-DC-At Large] D DC 2018-11-29 0
115-hr-5248,J000288 Sustainable Shark Fisheries and Trade Act 115-hr-5248 J000288 Rep. Johnson, Henry C. "Hank," Jr. [D-GA-4] D GA 2018-07-16 0
115-hr-5248,C001067 Sustainable Shark Fisheries and Trade Act 115-hr-5248 C001067 Rep. Clarke, Yvette D. [D-NY-9] D NY 2018-06-27 0
115-hr-5248,T000469 Sustainable Shark Fisheries and Trade Act 115-hr-5248 T000469 Rep. Tonko, Paul [D-NY-20] D NY 2018-06-25 0
115-hr-5248,M001137 Sustainable Shark Fisheries and Trade Act 115-hr-5248 M001137 Rep. Meeks, Gregory W. [D-NY-5] D NY 2018-06-20 0
115-hr-5248,K000380 Sustainable Shark Fisheries and Trade Act 115-hr-5248 K000380 Rep. Kildee, Daniel T. [D-MI-5] D MI 2018-06-14 0
115-hr-5248,F000449 Sustainable Shark Fisheries and Trade Act 115-hr-5248 F000449 Rep. Fortenberry, Jeff [R-NE-1] R NE 2018-06-12 0
115-hr-5248,S001170 Sustainable Shark Fisheries and Trade Act 115-hr-5248 S001170 Rep. Shea-Porter, Carol [D-NH-1] D NH 2018-06-08 0
115-hr-5248,K000210 Sustainable Shark Fisheries and Trade Act 115-hr-5248 K000210 Rep. King, Peter T. [R-NY-2] R NY 2018-06-07 0
115-hr-5248,D000619 Sustainable Shark Fisheries and Trade Act 115-hr-5248 D000619 Rep. Davis, Rodney [R-IL-13] R IL 2018-05-29 0
115-hr-5248,P000034 Sustainable Shark Fisheries and Trade Act 115-hr-5248 P000034 Rep. Pallone, Frank, Jr. [D-NJ-6] D NJ 2018-05-29 0
115-hr-5248,S000248 Sustainable Shark Fisheries and Trade Act 115-hr-5248 S000248 Rep. Serrano, Jose E. [D-NY-15] D NY 2018-05-17 0
115-hr-5248,J000294 Sustainable Shark Fisheries and Trade Act 115-hr-5248 J000294 Rep. Jeffries, Hakeem S. [D-NY-8] D NY 2018-05-16 0
115-hr-5248,H001038 Sustainable Shark Fisheries and Trade Act 115-hr-5248 H001038 Rep. Higgins, Brian [D-NY-26] D NY 2018-05-16 0
115-hr-5248,R000593 Sustainable Shark Fisheries and Trade Act 115-hr-5248 R000593 Rep. Ross, Dennis A. [R-FL-15] R FL 2018-05-08 0
115-hr-5248,D000628 Sustainable Shark Fisheries and Trade Act 115-hr-5248 D000628 Rep. Dunn, Neal P. [R-FL-2] R FL 2018-04-26 0
115-hr-5248,Y000065 Sustainable Shark Fisheries and Trade Act 115-hr-5248 Y000065 Rep. Yoho, Ted S. [R-FL-3] R FL 2018-04-26 0
115-hr-5248,R000583 Sustainable Shark Fisheries and Trade Act 115-hr-5248 R000583 Rep. Rooney, Thomas J. [R-FL-17] R FL 2018-04-26 0
115-hr-5248,D000600 Sustainable Shark Fisheries and Trade Act 115-hr-5248 D000600 Rep. Diaz-Balart, Mario [R-FL-25] R FL 2018-04-26 0
115-hr-5248,L000554 Sustainable Shark Fisheries and Trade Act 115-hr-5248 L000554 Rep. LoBiondo, Frank A. [R-NJ-2] R NJ 2018-04-18 0
115-hr-5248,L000397 Sustainable Shark Fisheries and Trade Act 115-hr-5248 L000397 Rep. Lofgren, Zoe [D-CA-19] D CA 2018-04-18 0
115-hr-5248,Y000033 Sustainable Shark Fisheries and Trade Act 115-hr-5248 Y000033 Rep. Young, Don [R-AK-At Large] R AK 2018-04-11 0
115-hr-5248,P000096 Sustainable Shark Fisheries and Trade Act 115-hr-5248 P000096 Rep. Pascrell, Bill, Jr. [D-NJ-9] D NJ 2018-04-11 0
115-hr-5248,M001193 Sustainable Shark Fisheries and Trade Act 115-hr-5248 M001193 Rep. MacArthur, Thomas [R-NJ-3] R NJ 2018-04-05 0
115-hr-5248,L000582 Sustainable Shark Fisheries and Trade Act 115-hr-5248 L000582 Rep. Lieu, Ted [D-CA-33] D CA 2018-03-13 1
115-hr-5248,P000599 Sustainable Shark Fisheries and Trade Act 115-hr-5248 P000599 Rep. Posey, Bill [R-FL-8] R FL 2018-03-13 1
115-hr-5248,J000255 Sustainable Shark Fisheries and Trade Act 115-hr-5248 J000255 Rep. Jones, Walter B., Jr. [R-NC-3] R NC 2018-03-13 1
115-hr-5248,C001049 Sustainable Shark Fisheries and Trade Act 115-hr-5248 C001049 Rep. Clay, Wm. Lacy [D-MO-1] D MO 2018-03-13 1
115-hr-5248,S001200 Sustainable Shark Fisheries and Trade Act 115-hr-5248 S001200 Rep. Soto, Darren [D-FL-9] D FL 2018-03-13 1
115-hr-5248,B001257 Sustainable Shark Fisheries and Trade Act 115-hr-5248 B001257 Rep. Bilirakis, Gus M. [R-FL-12] R FL 2018-03-13 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 740.16ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API