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

27 rows where bill_id = "111-hres-997" 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 1

  • 0 27
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
111-hres-997,M001168 Expressing the sense of the House of Representatives regarding unfair and discriminatory practices of the government of Japan in its failure to apply its current and planned extension of the Government's Eco-friendly Vehicle Purchase and scrappage program to imported vehicles made by U.S. automakers. 111-hres-997 M001168 Rep. Murphy, Patrick J. [D-PA-8] D PA 2010-02-04 0
111-hres-997,F000030 Expressing the sense of the House of Representatives regarding unfair and discriminatory practices of the government of Japan in its failure to apply its current and planned extension of the Government's Eco-friendly Vehicle Purchase and scrappage program to imported vehicles made by U.S. automakers. 111-hres-997 F000030 Rep. Farr, Sam [D-CA-17] D CA 2010-01-21 0
111-hres-997,F000116 Expressing the sense of the House of Representatives regarding unfair and discriminatory practices of the government of Japan in its failure to apply its current and planned extension of the Government's Eco-friendly Vehicle Purchase and scrappage program to imported vehicles made by U.S. automakers. 111-hres-997 F000116 Rep. Filner, Bob [D-CA-51] D CA 2010-01-20 0
111-hres-997,G000410 Expressing the sense of the House of Representatives regarding unfair and discriminatory practices of the government of Japan in its failure to apply its current and planned extension of the Government's Eco-friendly Vehicle Purchase and scrappage program to imported vehicles made by U.S. automakers. 111-hres-997 G000410 Rep. Green, Gene [D-TX-29] D TX 2010-01-19 0
111-hres-997,C000794 Expressing the sense of the House of Representatives regarding unfair and discriminatory practices of the government of Japan in its failure to apply its current and planned extension of the Government's Eco-friendly Vehicle Purchase and scrappage program to imported vehicles made by U.S. automakers. 111-hres-997 C000794 Rep. Costello, Jerry F. [D-IL-12] D IL 2010-01-19 0
111-hres-997,K000180 Expressing the sense of the House of Representatives regarding unfair and discriminatory practices of the government of Japan in its failure to apply its current and planned extension of the Government's Eco-friendly Vehicle Purchase and scrappage program to imported vehicles made by U.S. automakers. 111-hres-997 K000180 Rep. Kilpatrick, Carolyn C. [D-MI-13] D MI 2010-01-19 0
111-hres-997,S001156 Expressing the sense of the House of Representatives regarding unfair and discriminatory practices of the government of Japan in its failure to apply its current and planned extension of the Government's Eco-friendly Vehicle Purchase and scrappage program to imported vehicles made by U.S. automakers. 111-hres-997 S001156 Rep. Sánchez, Linda T. [D-CA-39] D CA 2010-01-19 0
111-hres-997,H000676 Expressing the sense of the House of Representatives regarding unfair and discriminatory practices of the government of Japan in its failure to apply its current and planned extension of the Government's Eco-friendly Vehicle Purchase and scrappage program to imported vehicles made by U.S. automakers. 111-hres-997 H000676 Rep. Hoekstra, Peter [R-MI-2] R MI 2010-01-19 0
111-hres-997,U000031 Expressing the sense of the House of Representatives regarding unfair and discriminatory practices of the government of Japan in its failure to apply its current and planned extension of the Government's Eco-friendly Vehicle Purchase and scrappage program to imported vehicles made by U.S. automakers. 111-hres-997 U000031 Rep. Upton, Fred [R-MI-6] R MI 2010-01-19 0
111-hres-997,M001173 Expressing the sense of the House of Representatives regarding unfair and discriminatory practices of the government of Japan in its failure to apply its current and planned extension of the Government's Eco-friendly Vehicle Purchase and scrappage program to imported vehicles made by U.S. automakers. 111-hres-997 M001173 Rep. Massa, Eric J. J. [D-NY-29] D NY 2010-01-19 0
111-hres-997,S001170 Expressing the sense of the House of Representatives regarding unfair and discriminatory practices of the government of Japan in its failure to apply its current and planned extension of the Government's Eco-friendly Vehicle Purchase and scrappage program to imported vehicles made by U.S. automakers. 111-hres-997 S001170 Rep. Shea-Porter, Carol [D-NH-1] D NH 2010-01-13 0
111-hres-997,B001259 Expressing the sense of the House of Representatives regarding unfair and discriminatory practices of the government of Japan in its failure to apply its current and planned extension of the Government's Eco-friendly Vehicle Purchase and scrappage program to imported vehicles made by U.S. automakers. 111-hres-997 B001259 Rep. Braley, Bruce L. [D-IA-1] D IA 2010-01-13 0
111-hres-997,S000480 Expressing the sense of the House of Representatives regarding unfair and discriminatory practices of the government of Japan in its failure to apply its current and planned extension of the Government's Eco-friendly Vehicle Purchase and scrappage program to imported vehicles made by U.S. automakers. 111-hres-997 S000480 Rep. Slaughter, Louise McIntosh [D-NY-28] D NY 2010-01-13 0
111-hres-997,C001060 Expressing the sense of the House of Representatives regarding unfair and discriminatory practices of the government of Japan in its failure to apply its current and planned extension of the Government's Eco-friendly Vehicle Purchase and scrappage program to imported vehicles made by U.S. automakers. 111-hres-997 C001060 Rep. Carnahan, Russ [D-MO-3] D MO 2010-01-13 0
111-hres-997,Y000062 Expressing the sense of the House of Representatives regarding unfair and discriminatory practices of the government of Japan in its failure to apply its current and planned extension of the Government's Eco-friendly Vehicle Purchase and scrappage program to imported vehicles made by U.S. automakers. 111-hres-997 Y000062 Rep. Yarmuth, John A. [D-KY-3] D KY 2010-01-13 0
111-hres-997,C001069 Expressing the sense of the House of Representatives regarding unfair and discriminatory practices of the government of Japan in its failure to apply its current and planned extension of the Government's Eco-friendly Vehicle Purchase and scrappage program to imported vehicles made by U.S. automakers. 111-hres-997 C001069 Rep. Courtney, Joe [D-CT-2] D CT 2010-01-13 0
111-hres-997,M001138 Expressing the sense of the House of Representatives regarding unfair and discriminatory practices of the government of Japan in its failure to apply its current and planned extension of the Government's Eco-friendly Vehicle Purchase and scrappage program to imported vehicles made by U.S. automakers. 111-hres-997 M001138 Rep. Manzullo, Donald A. [R-IL-16] R IL 2010-01-13 0
111-hres-997,M001149 Expressing the sense of the House of Representatives regarding unfair and discriminatory practices of the government of Japan in its failure to apply its current and planned extension of the Government's Eco-friendly Vehicle Purchase and scrappage program to imported vehicles made by U.S. automakers. 111-hres-997 M001149 Rep. Michaud, Michael H. [D-ME-2] D ME 2010-01-13 0
111-hres-997,D000355 Expressing the sense of the House of Representatives regarding unfair and discriminatory practices of the government of Japan in its failure to apply its current and planned extension of the Government's Eco-friendly Vehicle Purchase and scrappage program to imported vehicles made by U.S. automakers. 111-hres-997 D000355 Rep. Dingell, John D. [D-MI-15] D MI 2010-01-12 0
111-hres-997,M000933 Expressing the sense of the House of Representatives regarding unfair and discriminatory practices of the government of Japan in its failure to apply its current and planned extension of the Government's Eco-friendly Vehicle Purchase and scrappage program to imported vehicles made by U.S. automakers. 111-hres-997 M000933 Rep. Moran, James P. [D-VA-8] D VA 2010-01-12 0
111-hres-997,K000009 Expressing the sense of the House of Representatives regarding unfair and discriminatory practices of the government of Japan in its failure to apply its current and planned extension of the Government's Eco-friendly Vehicle Purchase and scrappage program to imported vehicles made by U.S. automakers. 111-hres-997 K000009 Rep. Kaptur, Marcy [D-OH-9] D OH 2010-01-12 0
111-hres-997,M001150 Expressing the sense of the House of Representatives regarding unfair and discriminatory practices of the government of Japan in its failure to apply its current and planned extension of the Government's Eco-friendly Vehicle Purchase and scrappage program to imported vehicles made by U.S. automakers. 111-hres-997 M001150 Rep. Miller, Candice S. [R-MI-10] R MI 2010-01-12 0
111-hres-997,H001040 Expressing the sense of the House of Representatives regarding unfair and discriminatory practices of the government of Japan in its failure to apply its current and planned extension of the Government's Eco-friendly Vehicle Purchase and scrappage program to imported vehicles made by U.S. automakers. 111-hres-997 H001040 Rep. Hare, Phil [D-IL-17] D IL 2010-01-12 0
111-hres-997,B000911 Expressing the sense of the House of Representatives regarding unfair and discriminatory practices of the government of Japan in its failure to apply its current and planned extension of the Government's Eco-friendly Vehicle Purchase and scrappage program to imported vehicles made by U.S. automakers. 111-hres-997 B000911 Rep. Brown, Corrine [D-FL-3] D FL 2010-01-12 0
111-hres-997,S001178 Expressing the sense of the House of Representatives regarding unfair and discriminatory practices of the government of Japan in its failure to apply its current and planned extension of the Government's Eco-friendly Vehicle Purchase and scrappage program to imported vehicles made by U.S. automakers. 111-hres-997 S001178 Rep. Schauer, Mark H. [D-MI-7] D MI 2010-01-12 0
111-hres-997,R000577 Expressing the sense of the House of Representatives regarding unfair and discriminatory practices of the government of Japan in its failure to apply its current and planned extension of the Government's Eco-friendly Vehicle Purchase and scrappage program to imported vehicles made by U.S. automakers. 111-hres-997 R000577 Rep. Ryan, Tim [D-OH-17] D OH 2010-01-12 0
111-hres-997,M001174 Expressing the sense of the House of Representatives regarding unfair and discriminatory practices of the government of Japan in its failure to apply its current and planned extension of the Government's Eco-friendly Vehicle Purchase and scrappage program to imported vehicles made by U.S. automakers. 111-hres-997 M001174 Rep. McMahon, Michael E. [D-NY-13] D NY 2010-01-12 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);