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

46 rows where bill_id = "116-sres-730" sorted by sponsorship_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party, sponsorship_date (date)

is_original_cosponsor 1

  • 1 46
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
116-sres-730,C000141 A resolution supporting the designation of the week beginning September 20, 2020, as "National Small Business Week" and commending the entrepreneurial spirit of the small business owners of the United States and their impact on their communities. 116-sres-730 C000141 Sen. Cardin, Benjamin L. [D-MD] D MD 2020-09-30 1
116-sres-730,C001056 A resolution supporting the designation of the week beginning September 20, 2020, as "National Small Business Week" and commending the entrepreneurial spirit of the small business owners of the United States and their impact on their communities. 116-sres-730 C001056 Sen. Cornyn, John [R-TX] R TX 2020-09-30 1
116-sres-730,C001113 A resolution supporting the designation of the week beginning September 20, 2020, as "National Small Business Week" and commending the entrepreneurial spirit of the small business owners of the United States and their impact on their communities. 116-sres-730 C001113 Sen. Cortez Masto, Catherine [D-NV] D NV 2020-09-30 1
116-sres-730,G000386 A resolution supporting the designation of the week beginning September 20, 2020, as "National Small Business Week" and commending the entrepreneurial spirit of the small business owners of the United States and their impact on their communities. 116-sres-730 G000386 Sen. Grassley, Chuck [R-IA] R IA 2020-09-30 1
116-sres-730,C000127 A resolution supporting the designation of the week beginning September 20, 2020, as "National Small Business Week" and commending the entrepreneurial spirit of the small business owners of the United States and their impact on their communities. 116-sres-730 C000127 Sen. Cantwell, Maria [D-WA] D WA 2020-09-30 1
116-sres-730,R000584 A resolution supporting the designation of the week beginning September 20, 2020, as "National Small Business Week" and commending the entrepreneurial spirit of the small business owners of the United States and their impact on their communities. 116-sres-730 R000584 Sen. Risch, James E. [R-ID] R ID 2020-09-30 1
116-sres-730,K000367 A resolution supporting the designation of the week beginning September 20, 2020, as "National Small Business Week" and commending the entrepreneurial spirit of the small business owners of the United States and their impact on their communities. 116-sres-730 K000367 Sen. Klobuchar, Amy [D-MN] D MN 2020-09-30 1
116-sres-730,K000393 A resolution supporting the designation of the week beginning September 20, 2020, as "National Small Business Week" and commending the entrepreneurial spirit of the small business owners of the United States and their impact on their communities. 116-sres-730 K000393 Sen. Kennedy, John [R-LA] R LA 2020-09-30 1
116-sres-730,V000128 A resolution supporting the designation of the week beginning September 20, 2020, as "National Small Business Week" and commending the entrepreneurial spirit of the small business owners of the United States and their impact on their communities. 116-sres-730 V000128 Sen. Van Hollen, Chris [D-MD] D MD 2020-09-30 1
116-sres-730,B000575 A resolution supporting the designation of the week beginning September 20, 2020, as "National Small Business Week" and commending the entrepreneurial spirit of the small business owners of the United States and their impact on their communities. 116-sres-730 B000575 Sen. Blunt, Roy [R-MO] R MO 2020-09-30 1
116-sres-730,C000174 A resolution supporting the designation of the week beginning September 20, 2020, as "National Small Business Week" and commending the entrepreneurial spirit of the small business owners of the United States and their impact on their communities. 116-sres-730 C000174 Sen. Carper, Thomas R. [D-DE] D DE 2020-09-30 1
116-sres-730,B001243 A resolution supporting the designation of the week beginning September 20, 2020, as "National Small Business Week" and commending the entrepreneurial spirit of the small business owners of the United States and their impact on their communities. 116-sres-730 B001243 Sen. Blackburn, Marsha [R-TN] R TN 2020-09-30 1
116-sres-730,B001288 A resolution supporting the designation of the week beginning September 20, 2020, as "National Small Business Week" and commending the entrepreneurial spirit of the small business owners of the United States and their impact on their communities. 116-sres-730 B001288 Sen. Booker, Cory A. [D-NJ] D NJ 2020-09-30 1
116-sres-730,H001061 A resolution supporting the designation of the week beginning September 20, 2020, as "National Small Business Week" and commending the entrepreneurial spirit of the small business owners of the United States and their impact on their communities. 116-sres-730 H001061 Sen. Hoeven, John [R-ND] R ND 2020-09-30 1
116-sres-730,D000563 A resolution supporting the designation of the week beginning September 20, 2020, as "National Small Business Week" and commending the entrepreneurial spirit of the small business owners of the United States and their impact on their communities. 116-sres-730 D000563 Sen. Durbin, Richard J. [D-IL] D IL 2020-09-30 1
116-sres-730,G000562 A resolution supporting the designation of the week beginning September 20, 2020, as "National Small Business Week" and commending the entrepreneurial spirit of the small business owners of the United States and their impact on their communities. 116-sres-730 G000562 Sen. Gardner, Cory [R-CO] R CO 2020-09-30 1
116-sres-730,C001088 A resolution supporting the designation of the week beginning September 20, 2020, as "National Small Business Week" and commending the entrepreneurial spirit of the small business owners of the United States and their impact on their communities. 116-sres-730 C001088 Sen. Coons, Christopher A. [D-DE] D DE 2020-09-30 1
116-sres-730,L000575 A resolution supporting the designation of the week beginning September 20, 2020, as "National Small Business Week" and commending the entrepreneurial spirit of the small business owners of the United States and their impact on their communities. 116-sres-730 L000575 Sen. Lankford, James [R-OK] R OK 2020-09-30 1
116-sres-730,S001181 A resolution supporting the designation of the week beginning September 20, 2020, as "National Small Business Week" and commending the entrepreneurial spirit of the small business owners of the United States and their impact on their communities. 116-sres-730 S001181 Sen. Shaheen, Jeanne [D-NH] D NH 2020-09-30 1
116-sres-730,F000463 A resolution supporting the designation of the week beginning September 20, 2020, as "National Small Business Week" and commending the entrepreneurial spirit of the small business owners of the United States and their impact on their communities. 116-sres-730 F000463 Sen. Fischer, Deb [R-NE] R NE 2020-09-30 1
116-sres-730,W000802 A resolution supporting the designation of the week beginning September 20, 2020, as "National Small Business Week" and commending the entrepreneurial spirit of the small business owners of the United States and their impact on their communities. 116-sres-730 W000802 Sen. Whitehouse, Sheldon [D-RI] D RI 2020-09-30 1
116-sres-730,C000880 A resolution supporting the designation of the week beginning September 20, 2020, as "National Small Business Week" and commending the entrepreneurial spirit of the small business owners of the United States and their impact on their communities. 116-sres-730 C000880 Sen. Crapo, Mike [R-ID] R ID 2020-09-30 1
116-sres-730,H001042 A resolution supporting the designation of the week beginning September 20, 2020, as "National Small Business Week" and commending the entrepreneurial spirit of the small business owners of the United States and their impact on their communities. 116-sres-730 H001042 Sen. Hirono, Mazie K. [D-HI] D HI 2020-09-30 1
116-sres-730,A000360 A resolution supporting the designation of the week beginning September 20, 2020, as "National Small Business Week" and commending the entrepreneurial spirit of the small business owners of the United States and their impact on their communities. 116-sres-730 A000360 Sen. Alexander, Lamar [R-TN] R TN 2020-09-30 1
116-sres-730,B000944 A resolution supporting the designation of the week beginning September 20, 2020, as "National Small Business Week" and commending the entrepreneurial spirit of the small business owners of the United States and their impact on their communities. 116-sres-730 B000944 Sen. Brown, Sherrod [D-OH] D OH 2020-09-30 1
116-sres-730,P000449 A resolution supporting the designation of the week beginning September 20, 2020, as "National Small Business Week" and commending the entrepreneurial spirit of the small business owners of the United States and their impact on their communities. 116-sres-730 P000449 Sen. Portman, Rob [R-OH] R OH 2020-09-30 1
116-sres-730,W000779 A resolution supporting the designation of the week beginning September 20, 2020, as "National Small Business Week" and commending the entrepreneurial spirit of the small business owners of the United States and their impact on their communities. 116-sres-730 W000779 Sen. Wyden, Ron [D-OR] D OR 2020-09-30 1
116-sres-730,E000295 A resolution supporting the designation of the week beginning September 20, 2020, as "National Small Business Week" and commending the entrepreneurial spirit of the small business owners of the United States and their impact on their communities. 116-sres-730 E000295 Sen. Ernst, Joni [R-IA] R IA 2020-09-30 1
116-sres-730,M001176 A resolution supporting the designation of the week beginning September 20, 2020, as "National Small Business Week" and commending the entrepreneurial spirit of the small business owners of the United States and their impact on their communities. 116-sres-730 M001176 Sen. Merkley, Jeff [D-OR] D OR 2020-09-30 1
116-sres-730,M001197 A resolution supporting the designation of the week beginning September 20, 2020, as "National Small Business Week" and commending the entrepreneurial spirit of the small business owners of the United States and their impact on their communities. 116-sres-730 M001197 Sen. McSally, Martha [R-AZ] R AZ 2020-09-30 1
116-sres-730,R000608 A resolution supporting the designation of the week beginning September 20, 2020, as "National Small Business Week" and commending the entrepreneurial spirit of the small business owners of the United States and their impact on their communities. 116-sres-730 R000608 Sen. Rosen, Jacky [D-NV] D NV 2020-09-30 1
116-sres-730,R000605 A resolution supporting the designation of the week beginning September 20, 2020, as "National Small Business Week" and commending the entrepreneurial spirit of the small business owners of the United States and their impact on their communities. 116-sres-730 R000605 Sen. Rounds, Mike [R-SD] R SD 2020-09-30 1
116-sres-730,P000595 A resolution supporting the designation of the week beginning September 20, 2020, as "National Small Business Week" and commending the entrepreneurial spirit of the small business owners of the United States and their impact on their communities. 116-sres-730 P000595 Sen. Peters, Gary C. [D-MI] D MI 2020-09-30 1
116-sres-730,H001089 A resolution supporting the designation of the week beginning September 20, 2020, as "National Small Business Week" and commending the entrepreneurial spirit of the small business owners of the United States and their impact on their communities. 116-sres-730 H001089 Sen. Hawley, Josh [R-MO] R MO 2020-09-30 1
116-sres-730,D000622 A resolution supporting the designation of the week beginning September 20, 2020, as "National Small Business Week" and commending the entrepreneurial spirit of the small business owners of the United States and their impact on their communities. 116-sres-730 D000622 Sen. Duckworth, Tammy [D-IL] D IL 2020-09-30 1
116-sres-730,F000062 A resolution supporting the designation of the week beginning September 20, 2020, as "National Small Business Week" and commending the entrepreneurial spirit of the small business owners of the United States and their impact on their communities. 116-sres-730 F000062 Sen. Feinstein, Dianne [D-CA] D CA 2020-09-30 1
116-sres-730,H001046 A resolution supporting the designation of the week beginning September 20, 2020, as "National Small Business Week" and commending the entrepreneurial spirit of the small business owners of the United States and their impact on their communities. 116-sres-730 H001046 Sen. Heinrich, Martin [D-NM] D NM 2020-09-30 1
116-sres-730,W000437 A resolution supporting the designation of the week beginning September 20, 2020, as "National Small Business Week" and commending the entrepreneurial spirit of the small business owners of the United States and their impact on their communities. 116-sres-730 W000437 Sen. Wicker, Roger F. [R-MS] R MS 2020-09-30 1
116-sres-730,H001079 A resolution supporting the designation of the week beginning September 20, 2020, as "National Small Business Week" and commending the entrepreneurial spirit of the small business owners of the United States and their impact on their communities. 116-sres-730 H001079 Sen. Hyde-Smith, Cindy [R-MS] R MS 2020-09-30 1
116-sres-730,T000476 A resolution supporting the designation of the week beginning September 20, 2020, as "National Small Business Week" and commending the entrepreneurial spirit of the small business owners of the United States and their impact on their communities. 116-sres-730 T000476 Sen. Tillis, Thomas [R-NC] R NC 2020-09-30 1
116-sres-730,C001096 A resolution supporting the designation of the week beginning September 20, 2020, as "National Small Business Week" and commending the entrepreneurial spirit of the small business owners of the United States and their impact on their communities. 116-sres-730 C001096 Sen. Cramer, Kevin [R-ND] R ND 2020-09-30 1
116-sres-730,C001095 A resolution supporting the designation of the week beginning September 20, 2020, as "National Small Business Week" and commending the entrepreneurial spirit of the small business owners of the United States and their impact on their communities. 116-sres-730 C001095 Sen. Cotton, Tom [R-AR] R AR 2020-09-30 1
116-sres-730,B001236 A resolution supporting the designation of the week beginning September 20, 2020, as "National Small Business Week" and commending the entrepreneurial spirit of the small business owners of the United States and their impact on their communities. 116-sres-730 B001236 Sen. Boozman, John [R-AR] R AR 2020-09-30 1
116-sres-730,P000612 A resolution supporting the designation of the week beginning September 20, 2020, as "National Small Business Week" and commending the entrepreneurial spirit of the small business owners of the United States and their impact on their communities. 116-sres-730 P000612 Sen. Perdue, David [R-GA] R GA 2020-09-30 1
116-sres-730,Y000064 A resolution supporting the designation of the week beginning September 20, 2020, as "National Small Business Week" and commending the entrepreneurial spirit of the small business owners of the United States and their impact on their communities. 116-sres-730 Y000064 Sen. Young, Todd [R-IN] R IN 2020-09-30 1
116-sres-730,R000615 A resolution supporting the designation of the week beginning September 20, 2020, as "National Small Business Week" and commending the entrepreneurial spirit of the small business owners of the United States and their impact on their communities. 116-sres-730 R000615 Sen. Romney, Mitt [R-UT] R UT 2020-09-30 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);