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

22 rows where bill_id = "117-hr-6629" 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 19
  • 1 3
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
117-hr-6629,V000129 Informed Lawmaking to Combat Inflation Act 117-hr-6629 V000129 Rep. Valadao, David G. [R-CA-21] R CA 2022-07-14 0
117-hr-6629,S001192 Informed Lawmaking to Combat Inflation Act 117-hr-6629 S001192 Rep. Stewart, Chris [R-UT-2] R UT 2022-07-13 0
117-hr-6629,G000576 Informed Lawmaking to Combat Inflation Act 117-hr-6629 G000576 Rep. Grothman, Glenn [R-WI-6] R WI 2022-07-13 0
117-hr-6629,G000590 Informed Lawmaking to Combat Inflation Act 117-hr-6629 G000590 Rep. Green, Mark E. [R-TN-7] R TN 2022-06-23 0
117-hr-6629,C001055 Informed Lawmaking to Combat Inflation Act 117-hr-6629 C001055 Rep. Case, Ed [D-HI-1] D HI 2022-06-14 0
117-hr-6629,C001120 Informed Lawmaking to Combat Inflation Act 117-hr-6629 C001120 Rep. Crenshaw, Dan [R-TX-2] R TX 2022-06-14 0
117-hr-6629,M000317 Informed Lawmaking to Combat Inflation Act 117-hr-6629 M000317 Rep. Malliotakis, Nicole [R-NY-11] R NY 2022-06-13 0
117-hr-6629,M001186 Informed Lawmaking to Combat Inflation Act 117-hr-6629 M001186 Rep. Meijer, Peter [R-MI-3] R MI 2022-06-13 0
117-hr-6629,K000392 Informed Lawmaking to Combat Inflation Act 117-hr-6629 K000392 Rep. Kustoff, David [R-TN-8] R TN 2022-06-13 0
117-hr-6629,O000086 Informed Lawmaking to Combat Inflation Act 117-hr-6629 O000086 Rep. Owens, Burgess [R-UT-4] R UT 2022-05-10 0
117-hr-6629,M000194 Informed Lawmaking to Combat Inflation Act 117-hr-6629 M000194 Rep. Mace, Nancy [R-SC-1] R SC 2022-04-18 0
117-hr-6629,G000597 Informed Lawmaking to Combat Inflation Act 117-hr-6629 G000597 Rep. Garbarino, Andrew R. [R-NY-2] R NY 2022-04-07 0
117-hr-6629,S001196 Informed Lawmaking to Combat Inflation Act 117-hr-6629 S001196 Rep. Stefanik, Elise M. [R-NY-21] R NY 2022-04-05 0
117-hr-6629,V000134 Informed Lawmaking to Combat Inflation Act 117-hr-6629 V000134 Rep. Van Duyne, Beth [R-TX-24] R TX 2022-03-17 0
117-hr-6629,R000609 Informed Lawmaking to Combat Inflation Act 117-hr-6629 R000609 Rep. Rutherford, John H. [R-FL-4] R FL 2022-03-16 0
117-hr-6629,L000266 Informed Lawmaking to Combat Inflation Act 117-hr-6629 L000266 Rep. LaTurner, Jake [R-KS-2] R KS 2022-02-22 0
117-hr-6629,C001087 Informed Lawmaking to Combat Inflation Act 117-hr-6629 C001087 Rep. Crawford, Eric A. "Rick" [R-AR-1] R AR 2022-02-11 0
117-hr-6629,B000740 Informed Lawmaking to Combat Inflation Act 117-hr-6629 B000740 Rep. Bice, Stephanie I. [R-OK-5] R OK 2022-02-11 0
117-hr-6629,M001215 Informed Lawmaking to Combat Inflation Act 117-hr-6629 M001215 Rep. Miller-Meeks, Mariannette [R-IA-2] R IA 2022-02-11 0
117-hr-6629,M001202 Informed Lawmaking to Combat Inflation Act 117-hr-6629 M001202 Rep. Murphy, Stephanie N. [D-FL-7] D FL 2022-02-07 1
117-hr-6629,H001091 Informed Lawmaking to Combat Inflation Act 117-hr-6629 H001091 Rep. Hinson, Ashley [R-IA-1] R IA 2022-02-07 1
117-hr-6629,S001180 Informed Lawmaking to Combat Inflation Act 117-hr-6629 S001180 Rep. Schrader, Kurt [D-OR-5] D OR 2022-02-07 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);