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

15 rows where bill_id = "104-hconres-28" 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 14
  • 1 1
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
104-hconres-28,B000619 Expressing the sense of Congress that a proposed cross-border fee for vehicles and pedestrians entering the United States from Canada or Mexico is unwise and should not be enacted. 104-hconres-28 B000619 Rep. Bonior, David E. [D-MI-10] D MI 1995-03-21 0
104-hconres-28,C000714 Expressing the sense of Congress that a proposed cross-border fee for vehicles and pedestrians entering the United States from Canada or Mexico is unwise and should not be enacted. 104-hconres-28 C000714 Rep. Conyers, John, Jr. [D-MI-14] D MI 1995-02-27 0
104-hconres-28,B000617 Expressing the sense of Congress that a proposed cross-border fee for vehicles and pedestrians entering the United States from Canada or Mexico is unwise and should not be enacted. 104-hconres-28 B000617 Rep. Bonilla, Henry [R-TX-23] R TX 1995-02-23 0
104-hconres-28,K000306 Expressing the sense of Congress that a proposed cross-border fee for vehicles and pedestrians entering the United States from Canada or Mexico is unwise and should not be enacted. 104-hconres-28 K000306 Rep. Kolbe, Jim [R-AZ-5] R AZ 1995-02-23 0
104-hconres-28,P000099 Expressing the sense of Congress that a proposed cross-border fee for vehicles and pedestrians entering the United States from Canada or Mexico is unwise and should not be enacted. 104-hconres-28 P000099 Rep. Pastor, Ed [D-AZ-2] D AZ 1995-02-23 0
104-hconres-28,N000051 Expressing the sense of Congress that a proposed cross-border fee for vehicles and pedestrians entering the United States from Canada or Mexico is unwise and should not be enacted. 104-hconres-28 N000051 Rep. Nethercutt, George R., Jr. [R-WA-5] R WA 1995-02-23 0
104-hconres-28,D000549 Expressing the sense of Congress that a proposed cross-border fee for vehicles and pedestrians entering the United States from Canada or Mexico is unwise and should not be enacted. 104-hconres-28 D000549 Rep. Dunn, Jennifer [R-WA-8] R WA 1995-02-23 0
104-hconres-28,S000587 Expressing the sense of Congress that a proposed cross-border fee for vehicles and pedestrians entering the United States from Canada or Mexico is unwise and should not be enacted. 104-hconres-28 S000587 Rep. Smith, Linda [R-WA-3] R WA 1995-02-21 0
104-hconres-28,S001045 Expressing the sense of Congress that a proposed cross-border fee for vehicles and pedestrians entering the United States from Canada or Mexico is unwise and should not be enacted. 104-hconres-28 S001045 Rep. Stupak, Bart [D-MI-1] D MI 1995-02-21 0
104-hconres-28,C000312 Expressing the sense of Congress that a proposed cross-border fee for vehicles and pedestrians entering the United States from Canada or Mexico is unwise and should not be enacted. 104-hconres-28 C000312 Rep. Chapman, Jim [D-TX-1] D TX 1995-02-21 0
104-hconres-28,M000669 Expressing the sense of Congress that a proposed cross-border fee for vehicles and pedestrians entering the United States from Canada or Mexico is unwise and should not be enacted. 104-hconres-28 M000669 Rep. Metcalf, Jack [R-WA-2] R WA 1995-02-21 0
104-hconres-28,M000472 Expressing the sense of Congress that a proposed cross-border fee for vehicles and pedestrians entering the United States from Canada or Mexico is unwise and should not be enacted. 104-hconres-28 M000472 Rep. McHugh, John M. [R-NY-24] R NY 1995-02-21 0
104-hconres-28,B000081 Expressing the sense of Congress that a proposed cross-border fee for vehicles and pedestrians entering the United States from Canada or Mexico is unwise and should not be enacted. 104-hconres-28 B000081 Rep. Baldacci, John Elias [D-ME-2] D ME 1995-02-21 0
104-hconres-28,O000107 Expressing the sense of Congress that a proposed cross-border fee for vehicles and pedestrians entering the United States from Canada or Mexico is unwise and should not be enacted. 104-hconres-28 O000107 Rep. Ortiz, Solomon P. [D-TX-27] D TX 1995-02-21 0
104-hconres-28,D000203 Expressing the sense of Congress that a proposed cross-border fee for vehicles and pedestrians entering the United States from Canada or Mexico is unwise and should not be enacted. 104-hconres-28 D000203 Rep. de la Garza, E. [D-TX-15] D TX 1995-02-14 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);