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

16 rows where bill_id = "114-hres-445" 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 12
  • 1 4
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
114-hres-445,M000087 Expressing the sense of the House of Representatives that corporations should commit to utilizing the benefits of gender diversity in boards of directors and other senior management positions. 114-hres-445 M000087 Rep. Maloney, Carolyn B. [D-NY-12] D NY 2016-07-05 0
114-hres-445,R000589 Expressing the sense of the House of Representatives that corporations should commit to utilizing the benefits of gender diversity in boards of directors and other senior management positions. 114-hres-445 R000589 Rep. Rigell, E. Scott [R-VA-2] R VA 2016-02-11 0
114-hres-445,B001289 Expressing the sense of the House of Representatives that corporations should commit to utilizing the benefits of gender diversity in boards of directors and other senior management positions. 114-hres-445 B001289 Rep. Byrne, Bradley [R-AL-1] R AL 2016-01-11 0
114-hres-445,W000804 Expressing the sense of the House of Representatives that corporations should commit to utilizing the benefits of gender diversity in boards of directors and other senior management positions. 114-hres-445 W000804 Rep. Wittman, Robert J. [R-VA-1] R VA 2015-11-19 0
114-hres-445,S001196 Expressing the sense of the House of Representatives that corporations should commit to utilizing the benefits of gender diversity in boards of directors and other senior management positions. 114-hres-445 S001196 Rep. Stefanik, Elise M. [R-NY-21] R NY 2015-10-23 0
114-hres-445,B001286 Expressing the sense of the House of Representatives that corporations should commit to utilizing the benefits of gender diversity in boards of directors and other senior management positions. 114-hres-445 B001286 Rep. Bustos, Cheri [D-IL-17] D IL 2015-10-21 0
114-hres-445,B001278 Expressing the sense of the House of Representatives that corporations should commit to utilizing the benefits of gender diversity in boards of directors and other senior management positions. 114-hres-445 B001278 Rep. Bonamici, Suzanne [D-OR-1] D OR 2015-10-21 0
114-hres-445,A000373 Expressing the sense of the House of Representatives that corporations should commit to utilizing the benefits of gender diversity in boards of directors and other senior management positions. 114-hres-445 A000373 Rep. Ashford, Brad [D-NE-2] D NE 2015-10-09 0
114-hres-445,A000370 Expressing the sense of the House of Representatives that corporations should commit to utilizing the benefits of gender diversity in boards of directors and other senior management positions. 114-hres-445 A000370 Rep. Adams, Alma S. [D-NC-12] D NC 2015-10-08 0
114-hres-445,L000480 Expressing the sense of the House of Representatives that corporations should commit to utilizing the benefits of gender diversity in boards of directors and other senior management positions. 114-hres-445 L000480 Rep. Lowey, Nita M. [D-NY-17] D NY 2015-10-07 0
114-hres-445,M001196 Expressing the sense of the House of Representatives that corporations should commit to utilizing the benefits of gender diversity in boards of directors and other senior management positions. 114-hres-445 M001196 Rep. Moulton, Seth [D-MA-6] D MA 2015-10-06 0
114-hres-445,M001163 Expressing the sense of the House of Representatives that corporations should commit to utilizing the benefits of gender diversity in boards of directors and other senior management positions. 114-hres-445 M001163 Rep. Matsui, Doris O. [D-CA-6] D CA 2015-09-30 0
114-hres-445,E000294 Expressing the sense of the House of Representatives that corporations should commit to utilizing the benefits of gender diversity in boards of directors and other senior management positions. 114-hres-445 E000294 Rep. Emmer, Tom [R-MN-6] R MN 2015-09-28 1
114-hres-445,D000623 Expressing the sense of the House of Representatives that corporations should commit to utilizing the benefits of gender diversity in boards of directors and other senior management positions. 114-hres-445 D000623 Rep. DeSaulnier, Mark [D-CA-11] D CA 2015-09-28 1
114-hres-445,D000598 Expressing the sense of the House of Representatives that corporations should commit to utilizing the benefits of gender diversity in boards of directors and other senior management positions. 114-hres-445 D000598 Rep. Davis, Susan A. [D-CA-53] D CA 2015-09-28 1
114-hres-445,R000602 Expressing the sense of the House of Representatives that corporations should commit to utilizing the benefits of gender diversity in boards of directors and other senior management positions. 114-hres-445 R000602 Rep. Rice, Kathleen M. [D-NY-4] D NY 2015-09-28 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);