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

29 rows where bill_id = "115-hconres-87" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: state, sponsorship_date (date)

is_original_cosponsor 1

  • 1 29
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
115-hconres-87,S001185 Expressing the sense of the Congress that temporary protected status for Haitian nationals should be extended until that country has demonstrably recovered from the 2010 earthquake, the cholera epidemic, Hurricane Matthew, and other disasters. 115-hconres-87 S001185 Rep. Sewell, Terri A. [D-AL-7] D AL 2017-10-25 1
115-hconres-87,E000288 Expressing the sense of the Congress that temporary protected status for Haitian nationals should be extended until that country has demonstrably recovered from the 2010 earthquake, the cholera epidemic, Hurricane Matthew, and other disasters. 115-hconres-87 E000288 Rep. Ellison, Keith [D-MN-5] D MN 2017-10-25 1
115-hconres-87,D000096 Expressing the sense of the Congress that temporary protected status for Haitian nationals should be extended until that country has demonstrably recovered from the 2010 earthquake, the cholera epidemic, Hurricane Matthew, and other disasters. 115-hconres-87 D000096 Rep. Davis, Danny K. [D-IL-7] D IL 2017-10-25 1
115-hconres-87,R000515 Expressing the sense of the Congress that temporary protected status for Haitian nationals should be extended until that country has demonstrably recovered from the 2010 earthquake, the cholera epidemic, Hurricane Matthew, and other disasters. 115-hconres-87 R000515 Rep. Rush, Bobby L. [D-IL-1] D IL 2017-10-25 1
115-hconres-87,L000551 Expressing the sense of the Congress that temporary protected status for Haitian nationals should be extended until that country has demonstrably recovered from the 2010 earthquake, the cholera epidemic, Hurricane Matthew, and other disasters. 115-hconres-87 L000551 Rep. Lee, Barbara [D-CA-13] D CA 2017-10-25 1
115-hconres-87,C000714 Expressing the sense of the Congress that temporary protected status for Haitian nationals should be extended until that country has demonstrably recovered from the 2010 earthquake, the cholera epidemic, Hurricane Matthew, and other disasters. 115-hconres-87 C000714 Rep. Conyers, John, Jr. [D-MI-13] D MI 2017-10-25 1
115-hconres-87,L000287 Expressing the sense of the Congress that temporary protected status for Haitian nationals should be extended until that country has demonstrably recovered from the 2010 earthquake, the cholera epidemic, Hurricane Matthew, and other disasters. 115-hconres-87 L000287 Rep. Lewis, John [D-GA-5] D GA 2017-10-25 1
115-hconres-87,S000185 Expressing the sense of the Congress that temporary protected status for Haitian nationals should be extended until that country has demonstrably recovered from the 2010 earthquake, the cholera epidemic, Hurricane Matthew, and other disasters. 115-hconres-87 S000185 Rep. Scott, Robert C. "Bobby" [D-VA-3] D VA 2017-10-25 1
115-hconres-87,J000288 Expressing the sense of the Congress that temporary protected status for Haitian nationals should be extended until that country has demonstrably recovered from the 2010 earthquake, the cholera epidemic, Hurricane Matthew, and other disasters. 115-hconres-87 J000288 Rep. Johnson, Henry C. "Hank," Jr. [D-GA-4] D GA 2017-10-25 1
115-hconres-87,H000324 Expressing the sense of the Congress that temporary protected status for Haitian nationals should be extended until that country has demonstrably recovered from the 2010 earthquake, the cholera epidemic, Hurricane Matthew, and other disasters. 115-hconres-87 H000324 Rep. Hastings, Alcee L. [D-FL-20] D FL 2017-10-25 1
115-hconres-87,C001061 Expressing the sense of the Congress that temporary protected status for Haitian nationals should be extended until that country has demonstrably recovered from the 2010 earthquake, the cholera epidemic, Hurricane Matthew, and other disasters. 115-hconres-87 C001061 Rep. Cleaver, Emanuel [D-MO-5] D MO 2017-10-25 1
115-hconres-87,C001049 Expressing the sense of the Congress that temporary protected status for Haitian nationals should be extended until that country has demonstrably recovered from the 2010 earthquake, the cholera epidemic, Hurricane Matthew, and other disasters. 115-hconres-87 C001049 Rep. Clay, Wm. Lacy [D-MO-1] D MO 2017-10-25 1
115-hconres-87,B001251 Expressing the sense of the Congress that temporary protected status for Haitian nationals should be extended until that country has demonstrably recovered from the 2010 earthquake, the cholera epidemic, Hurricane Matthew, and other disasters. 115-hconres-87 B001251 Rep. Butterfield, G. K. [D-NC-1] D NC 2017-10-25 1
115-hconres-87,V000131 Expressing the sense of the Congress that temporary protected status for Haitian nationals should be extended until that country has demonstrably recovered from the 2010 earthquake, the cholera epidemic, Hurricane Matthew, and other disasters. 115-hconres-87 V000131 Rep. Veasey, Marc A. [D-TX-33] D TX 2017-10-25 1
115-hconres-87,J000032 Expressing the sense of the Congress that temporary protected status for Haitian nationals should be extended until that country has demonstrably recovered from the 2010 earthquake, the cholera epidemic, Hurricane Matthew, and other disasters. 115-hconres-87 J000032 Rep. Jackson Lee, Sheila [D-TX-18] D TX 2017-10-25 1
115-hconres-87,P000604 Expressing the sense of the Congress that temporary protected status for Haitian nationals should be extended until that country has demonstrably recovered from the 2010 earthquake, the cholera epidemic, Hurricane Matthew, and other disasters. 115-hconres-87 P000604 Rep. Payne, Donald M., Jr. [D-NJ-10] D NJ 2017-10-25 1
115-hconres-87,L000586 Expressing the sense of the Congress that temporary protected status for Haitian nationals should be extended until that country has demonstrably recovered from the 2010 earthquake, the cholera epidemic, Hurricane Matthew, and other disasters. 115-hconres-87 L000586 Rep. Lawson, Al, Jr. [D-FL-5] D FL 2017-10-25 1
115-hconres-87,E000296 Expressing the sense of the Congress that temporary protected status for Haitian nationals should be extended until that country has demonstrably recovered from the 2010 earthquake, the cholera epidemic, Hurricane Matthew, and other disasters. 115-hconres-87 E000296 Rep. Evans, Dwight [D-PA-2] D PA 2017-10-25 1
115-hconres-87,T000193 Expressing the sense of the Congress that temporary protected status for Haitian nationals should be extended until that country has demonstrably recovered from the 2010 earthquake, the cholera epidemic, Hurricane Matthew, and other disasters. 115-hconres-87 T000193 Rep. Thompson, Bennie G. [D-MS-2] D MS 2017-10-25 1
115-hconres-87,C000537 Expressing the sense of the Congress that temporary protected status for Haitian nationals should be extended until that country has demonstrably recovered from the 2010 earthquake, the cholera epidemic, Hurricane Matthew, and other disasters. 115-hconres-87 C000537 Rep. Clyburn, James E. [D-SC-6] D SC 2017-10-25 1
115-hconres-87,G000553 Expressing the sense of the Congress that temporary protected status for Haitian nationals should be extended until that country has demonstrably recovered from the 2010 earthquake, the cholera epidemic, Hurricane Matthew, and other disasters. 115-hconres-87 G000553 Rep. Green, Al [D-TX-9] D TX 2017-10-25 1
115-hconres-87,F000455 Expressing the sense of the Congress that temporary protected status for Haitian nationals should be extended until that country has demonstrably recovered from the 2010 earthquake, the cholera epidemic, Hurricane Matthew, and other disasters. 115-hconres-87 F000455 Rep. Fudge, Marcia L. [D-OH-11] D OH 2017-10-25 1
115-hconres-87,C001067 Expressing the sense of the Congress that temporary protected status for Haitian nationals should be extended until that country has demonstrably recovered from the 2010 earthquake, the cholera epidemic, Hurricane Matthew, and other disasters. 115-hconres-87 C001067 Rep. Clarke, Yvette D. [D-NY-9] D NY 2017-10-25 1
115-hconres-87,M001160 Expressing the sense of the Congress that temporary protected status for Haitian nationals should be extended until that country has demonstrably recovered from the 2010 earthquake, the cholera epidemic, Hurricane Matthew, and other disasters. 115-hconres-87 M001160 Rep. Moore, Gwen [D-WI-4] D WI 2017-10-25 1
115-hconres-87,C001072 Expressing the sense of the Congress that temporary protected status for Haitian nationals should be extended until that country has demonstrably recovered from the 2010 earthquake, the cholera epidemic, Hurricane Matthew, and other disasters. 115-hconres-87 C001072 Rep. Carson, Andre [D-IN-7] D IN 2017-10-25 1
115-hconres-87,R000588 Expressing the sense of the Congress that temporary protected status for Haitian nationals should be extended until that country has demonstrably recovered from the 2010 earthquake, the cholera epidemic, Hurricane Matthew, and other disasters. 115-hconres-87 R000588 Rep. Richmond, Cedric L. [D-LA-2] D LA 2017-10-25 1
115-hconres-87,B001270 Expressing the sense of the Congress that temporary protected status for Haitian nationals should be extended until that country has demonstrably recovered from the 2010 earthquake, the cholera epidemic, Hurricane Matthew, and other disasters. 115-hconres-87 B001270 Rep. Bass, Karen [D-CA-37] D CA 2017-10-25 1
115-hconres-87,B001281 Expressing the sense of the Congress that temporary protected status for Haitian nationals should be extended until that country has demonstrably recovered from the 2010 earthquake, the cholera epidemic, Hurricane Matthew, and other disasters. 115-hconres-87 B001281 Rep. Beatty, Joyce [D-OH-3] D OH 2017-10-25 1
115-hconres-87,C001101 Expressing the sense of the Congress that temporary protected status for Haitian nationals should be extended until that country has demonstrably recovered from the 2010 earthquake, the cholera epidemic, Hurricane Matthew, and other disasters. 115-hconres-87 C001101 Rep. Clark, Katherine M. [D-MA-5] D MA 2017-10-25 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);