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

28 rows where bill_id = "110-hconres-285" 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

  • 1 15
  • 0 13
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
110-hconres-285,S001169 Expressing the sense of the Congress that a postage stamp should be issued honoring the Nation's coal miners. 110-hconres-285 S001169 Rep. Sestak, Joe [D-PA-7] D PA 2008-06-04 0
110-hconres-285,S001162 Expressing the sense of the Congress that a postage stamp should be issued honoring the Nation's coal miners. 110-hconres-285 S001162 Rep. Schwartz, Allyson Y. [D-PA-13] D PA 2008-05-01 0
110-hconres-285,D000482 Expressing the sense of the Congress that a postage stamp should be issued honoring the Nation's coal miners. 110-hconres-285 D000482 Rep. Doyle, Michael F. [D-PA-14] D PA 2008-05-01 0
110-hconres-285,L000293 Expressing the sense of the Congress that a postage stamp should be issued honoring the Nation's coal miners. 110-hconres-285 L000293 Rep. Lewis, Ron [R-KY-2] R KY 2008-05-01 0
110-hconres-285,S000465 Expressing the sense of the Congress that a postage stamp should be issued honoring the Nation's coal miners. 110-hconres-285 S000465 Rep. Skelton, Ike [D-MO-4] D MO 2008-05-01 0
110-hconres-285,W000413 Expressing the sense of the Congress that a postage stamp should be issued honoring the Nation's coal miners. 110-hconres-285 W000413 Rep. Whitfield, Ed [R-KY-1] R KY 2008-05-01 0
110-hconres-285,M001142 Expressing the sense of the Congress that a postage stamp should be issued honoring the Nation's coal miners. 110-hconres-285 M001142 Rep. Matheson, Jim [D-UT-2] D UT 2008-05-01 0
110-hconres-285,E000187 Expressing the sense of the Congress that a postage stamp should be issued honoring the Nation's coal miners. 110-hconres-285 E000187 Rep. English, Phil [R-PA-3] R PA 2008-05-01 0
110-hconres-285,P000585 Expressing the sense of the Congress that a postage stamp should be issued honoring the Nation's coal miners. 110-hconres-285 P000585 Rep. Platts, Todd Russell [R-PA-19] R PA 2008-02-27 0
110-hconres-285,C000794 Expressing the sense of the Congress that a postage stamp should be issued honoring the Nation's coal miners. 110-hconres-285 C000794 Rep. Costello, Jerry F. [D-IL-12] D IL 2008-02-13 0
110-hconres-285,M001168 Expressing the sense of the Congress that a postage stamp should be issued honoring the Nation's coal miners. 110-hconres-285 M001168 Rep. Murphy, Patrick J. [D-PA-8] D PA 2008-02-13 0
110-hconres-285,R000395 Expressing the sense of the Congress that a postage stamp should be issued honoring the Nation's coal miners. 110-hconres-285 R000395 Rep. Rogers, Harold [R-KY-5] R KY 2008-02-07 0
110-hconres-285,S001156 Expressing the sense of the Congress that a postage stamp should be issued honoring the Nation's coal miners. 110-hconres-285 S001156 Rep. Sánchez, Linda T. [D-CA-39] D CA 2008-02-06 0
110-hconres-285,C001047 Expressing the sense of the Congress that a postage stamp should be issued honoring the Nation's coal miners. 110-hconres-285 C001047 Rep. Capito, Shelley Moore [R-WV-2] R WV 2008-01-29 1
110-hconres-285,W000801 Expressing the sense of the Congress that a postage stamp should be issued honoring the Nation's coal miners. 110-hconres-285 W000801 Rep. Wilson, Charles A. [D-OH-6] D OH 2008-01-29 1
110-hconres-285,A000362 Expressing the sense of the Congress that a postage stamp should be issued honoring the Nation's coal miners. 110-hconres-285 A000362 Rep. Altmire, Jason [D-PA-4] D PA 2008-01-29 1
110-hconres-285,M001120 Expressing the sense of the Congress that a postage stamp should be issued honoring the Nation's coal miners. 110-hconres-285 M001120 Rep. Murtha, John P. [D-PA-12] D PA 2008-01-29 1
110-hconres-285,C001065 Expressing the sense of the Congress that a postage stamp should be issued honoring the Nation's coal miners. 110-hconres-285 C001065 Rep. Carney, Christopher P. [D-PA-10] D PA 2008-01-29 1
110-hconres-285,M001151 Expressing the sense of the Congress that a postage stamp should be issued honoring the Nation's coal miners. 110-hconres-285 M001151 Rep. Murphy, Tim [R-PA-18] R PA 2008-01-29 1
110-hconres-285,C001058 Expressing the sense of the Congress that a postage stamp should be issued honoring the Nation's coal miners. 110-hconres-285 C001058 Rep. Chandler, Ben [D-KY-6] D KY 2008-01-29 1
110-hconres-285,P000263 Expressing the sense of the Congress that a postage stamp should be issued honoring the Nation's coal miners. 110-hconres-285 P000263 Rep. Peterson, John E. [R-PA-5] R PA 2008-01-29 1
110-hconres-285,M000725 Expressing the sense of the Congress that a postage stamp should be issued honoring the Nation's coal miners. 110-hconres-285 M000725 Rep. Miller, George [D-CA-7] D CA 2008-01-29 1
110-hconres-285,H000712 Expressing the sense of the Congress that a postage stamp should be issued honoring the Nation's coal miners. 110-hconres-285 H000712 Rep. Holden, Tim [D-PA-17] D PA 2008-01-29 1
110-hconres-285,G000549 Expressing the sense of the Congress that a postage stamp should be issued honoring the Nation's coal miners. 110-hconres-285 G000549 Rep. Gerlach, Jim [R-PA-6] R PA 2008-01-29 1
110-hconres-285,S000364 Expressing the sense of the Congress that a postage stamp should be issued honoring the Nation's coal miners. 110-hconres-285 S000364 Rep. Shimkus, John [R-IL-19] R IL 2008-01-29 1
110-hconres-285,S001154 Expressing the sense of the Congress that a postage stamp should be issued honoring the Nation's coal miners. 110-hconres-285 S001154 Rep. Shuster, Bill [R-PA-9] R PA 2008-01-29 1
110-hconres-285,W000672 Expressing the sense of the Congress that a postage stamp should be issued honoring the Nation's coal miners. 110-hconres-285 W000672 Rep. Wolf, Frank R. [R-VA-10] R VA 2008-01-29 1
110-hconres-285,S001173 Expressing the sense of the Congress that a postage stamp should be issued honoring the Nation's coal miners. 110-hconres-285 S001173 Rep. Space, Zachary T. [D-OH-18] D OH 2008-01-29 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);