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

18 rows where bill_id = "110-hr-6860" 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 1

  • 0 18
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
110-hr-6860,W000795 Oil and Gas Lease Reform Act of 2008 110-hr-6860 W000795 Rep. Wilson, Joe [R-SC-2] R SC 2008-09-22 0
110-hr-6860,P000592 Oil and Gas Lease Reform Act of 2008 110-hr-6860 P000592 Rep. Poe, Ted [R-TX-2] R TX 2008-09-17 0
110-hr-6860,B001256 Oil and Gas Lease Reform Act of 2008 110-hr-6860 B001256 Rep. Bachmann, Michele [R-MN-6] R MN 2008-09-17 0
110-hr-6860,M001152 Oil and Gas Lease Reform Act of 2008 110-hr-6860 M001152 Rep. Musgrave, Marilyn N. [R-CO-4] R CO 2008-09-17 0
110-hr-6860,F000453 Oil and Gas Lease Reform Act of 2008 110-hr-6860 F000453 Rep. Fallin, Mary [R-OK-5] R OK 2008-09-17 0
110-hr-6860,B001235 Oil and Gas Lease Reform Act of 2008 110-hr-6860 B001235 Rep. Brown, Henry E., Jr. [R-SC-1] R SC 2008-09-17 0
110-hr-6860,P000591 Oil and Gas Lease Reform Act of 2008 110-hr-6860 P000591 Rep. Price, Tom [R-GA-6] R GA 2008-09-17 0
110-hr-6860,G000280 Oil and Gas Lease Reform Act of 2008 110-hr-6860 G000280 Rep. Goode, Virgil H., Jr. [R-VA-5] R VA 2008-09-17 0
110-hr-6860,S001164 Oil and Gas Lease Reform Act of 2008 110-hr-6860 S001164 Rep. Schmidt, Jean [R-OH-2] R OH 2008-09-17 0
110-hr-6860,M001147 Oil and Gas Lease Reform Act of 2008 110-hr-6860 M001147 Rep. McCotter, Thaddeus G. [R-MI-11] R MI 2008-09-17 0
110-hr-6860,B001262 Oil and Gas Lease Reform Act of 2008 110-hr-6860 B001262 Rep. Broun, Paul C. [R-GA-10] R GA 2008-09-17 0
110-hr-6860,L000564 Oil and Gas Lease Reform Act of 2008 110-hr-6860 L000564 Rep. Lamborn, Doug [R-CO-5] R CO 2008-09-17 0
110-hr-6860,G000550 Oil and Gas Lease Reform Act of 2008 110-hr-6860 G000550 Rep. Gingrey, Phil [R-GA-11] R GA 2008-09-17 0
110-hr-6860,D000429 Oil and Gas Lease Reform Act of 2008 110-hr-6860 D000429 Rep. Doolittle, John T. [R-CA-4] R CA 2008-09-17 0
110-hr-6860,H000528 Oil and Gas Lease Reform Act of 2008 110-hr-6860 H000528 Rep. Herger, Wally [R-CA-2] R CA 2008-09-17 0
110-hr-6860,M001158 Oil and Gas Lease Reform Act of 2008 110-hr-6860 M001158 Rep. Marchant, Kenny [R-TX-24] R TX 2008-09-17 0
110-hr-6860,M001134 Oil and Gas Lease Reform Act of 2008 110-hr-6860 M001134 Rep. Myrick, Sue Wilkins [R-NC-9] R NC 2008-09-15 0
110-hr-6860,D000605 Oil and Gas Lease Reform Act of 2008 110-hr-6860 D000605 Rep. Drake, Thelma D. [R-VA-2] R VA 2008-09-15 0

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);