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

17 rows where bill_id = "115-hconres-43" 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 16
  • 1 1
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
115-hconres-43,M001160 Providing official recognition of the massacre of 11 African-American soldiers of the 333rd Field Artillery Battalion of the United States Army who had been captured in Wereth, Belgium, during the Battle of the Bulge on December 17, 1944. 115-hconres-43 M001160 Rep. Moore, Gwen [D-WI-4] D WI 2017-10-25 0
115-hconres-43,K000389 Providing official recognition of the massacre of 11 African-American soldiers of the 333rd Field Artillery Battalion of the United States Army who had been captured in Wereth, Belgium, during the Battle of the Bulge on December 17, 1944. 115-hconres-43 K000389 Rep. Khanna, Ro [D-CA-17] D CA 2017-10-25 0
115-hconres-43,N000147 Providing official recognition of the massacre of 11 African-American soldiers of the 333rd Field Artillery Battalion of the United States Army who had been captured in Wereth, Belgium, during the Battle of the Bulge on December 17, 1944. 115-hconres-43 N000147 Del. Norton, Eleanor Holmes [D-DC-At Large] D DC 2017-10-25 0
115-hconres-43,C001068 Providing official recognition of the massacre of 11 African-American soldiers of the 333rd Field Artillery Battalion of the United States Army who had been captured in Wereth, Belgium, during the Battle of the Bulge on December 17, 1944. 115-hconres-43 C001068 Rep. Cohen, Steve [D-TN-9] D TN 2017-10-23 0
115-hconres-43,C000714 Providing official recognition of the massacre of 11 African-American soldiers of the 333rd Field Artillery Battalion of the United States Army who had been captured in Wereth, Belgium, during the Battle of the Bulge on December 17, 1944. 115-hconres-43 C000714 Rep. Conyers, John, Jr. [D-MI-13] D MI 2017-10-23 0
115-hconres-43,S001189 Providing official recognition of the massacre of 11 African-American soldiers of the 333rd Field Artillery Battalion of the United States Army who had been captured in Wereth, Belgium, during the Battle of the Bulge on December 17, 1944. 115-hconres-43 S001189 Rep. Scott, Austin [R-GA-8] R GA 2017-10-10 0
115-hconres-43,H000324 Providing official recognition of the massacre of 11 African-American soldiers of the 333rd Field Artillery Battalion of the United States Army who had been captured in Wereth, Belgium, during the Battle of the Bulge on December 17, 1944. 115-hconres-43 H000324 Rep. Hastings, Alcee L. [D-FL-20] D FL 2017-10-10 0
115-hconres-43,D000482 Providing official recognition of the massacre of 11 African-American soldiers of the 333rd Field Artillery Battalion of the United States Army who had been captured in Wereth, Belgium, during the Battle of the Bulge on December 17, 1944. 115-hconres-43 D000482 Rep. Doyle, Michael F. [D-PA-14] D PA 2017-10-10 0
115-hconres-43,D000624 Providing official recognition of the massacre of 11 African-American soldiers of the 333rd Field Artillery Battalion of the United States Army who had been captured in Wereth, Belgium, during the Battle of the Bulge on December 17, 1944. 115-hconres-43 D000624 Rep. Dingell, Debbie [D-MI-12] D MI 2017-05-24 0
115-hconres-43,E000296 Providing official recognition of the massacre of 11 African-American soldiers of the 333rd Field Artillery Battalion of the United States Army who had been captured in Wereth, Belgium, during the Battle of the Bulge on December 17, 1944. 115-hconres-43 E000296 Rep. Evans, Dwight [D-PA-2] D PA 2017-05-22 0
115-hconres-43,J000255 Providing official recognition of the massacre of 11 African-American soldiers of the 333rd Field Artillery Battalion of the United States Army who had been captured in Wereth, Belgium, during the Battle of the Bulge on December 17, 1944. 115-hconres-43 J000255 Rep. Jones, Walter B., Jr. [R-NC-3] R NC 2017-04-28 0
115-hconres-43,K000388 Providing official recognition of the massacre of 11 African-American soldiers of the 333rd Field Artillery Battalion of the United States Army who had been captured in Wereth, Belgium, during the Battle of the Bulge on December 17, 1944. 115-hconres-43 K000388 Rep. Kelly, Trent [R-MS-1] R MS 2017-04-28 0
115-hconres-43,C001072 Providing official recognition of the massacre of 11 African-American soldiers of the 333rd Field Artillery Battalion of the United States Army who had been captured in Wereth, Belgium, during the Battle of the Bulge on December 17, 1944. 115-hconres-43 C001072 Rep. Carson, Andre [D-IN-7] D IN 2017-04-26 0
115-hconres-43,C001049 Providing official recognition of the massacre of 11 African-American soldiers of the 333rd Field Artillery Battalion of the United States Army who had been captured in Wereth, Belgium, during the Battle of the Bulge on December 17, 1944. 115-hconres-43 C001049 Rep. Clay, Wm. Lacy [D-MO-1] D MO 2017-04-20 0
115-hconres-43,B001281 Providing official recognition of the massacre of 11 African-American soldiers of the 333rd Field Artillery Battalion of the United States Army who had been captured in Wereth, Belgium, during the Battle of the Bulge on December 17, 1944. 115-hconres-43 B001281 Rep. Beatty, Joyce [D-OH-3] D OH 2017-04-20 0
115-hconres-43,B001227 Providing official recognition of the massacre of 11 African-American soldiers of the 333rd Field Artillery Battalion of the United States Army who had been captured in Wereth, Belgium, during the Battle of the Bulge on December 17, 1944. 115-hconres-43 B001227 Rep. Brady, Robert A. [D-PA-1] D PA 2017-04-20 0
115-hconres-43,R000515 Providing official recognition of the massacre of 11 African-American soldiers of the 333rd Field Artillery Battalion of the United States Army who had been captured in Wereth, Belgium, during the Battle of the Bulge on December 17, 1944. 115-hconres-43 R000515 Rep. Rush, Bobby L. [D-IL-1] D IL 2017-04-04 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);