home / openregs

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 = "111-hconres-232" 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

  • 1 13
  • 0 9
Link bill_id bioguide_id full_name party state sponsorship_date ▲ is_original_cosponsor
111-hconres-232,B000013 Expressing the sense of Congress that a site in Arlington National Cemetery should be provided for a memorial marker to honor the memory of the 14 members of the Army's 24th Infantry Division who have received the Medal of Honor. 111-hconres-232 B000013 Rep. Bachus, Spencer [R-AL-6] R AL 2010-07-13 0
111-hconres-232,O000085 Expressing the sense of Congress that a site in Arlington National Cemetery should be provided for a memorial marker to honor the memory of the 14 members of the Army's 24th Infantry Division who have received the Medal of Honor. 111-hconres-232 O000085 Rep. Olver, John W. [D-MA-1] D MA 2010-07-13 0
111-hconres-232,S001171 Expressing the sense of Congress that a site in Arlington National Cemetery should be provided for a memorial marker to honor the memory of the 14 members of the Army's 24th Infantry Division who have received the Medal of Honor. 111-hconres-232 S001171 Rep. Shuler, Heath [D-NC-11] D NC 2010-04-13 0
111-hconres-232,M001139 Expressing the sense of Congress that a site in Arlington National Cemetery should be provided for a memorial marker to honor the memory of the 14 members of the Army's 24th Infantry Division who have received the Medal of Honor. 111-hconres-232 M001139 Rep. Miller, Gary G. [R-CA-42] R CA 2010-03-12 0
111-hconres-232,M001144 Expressing the sense of Congress that a site in Arlington National Cemetery should be provided for a memorial marker to honor the memory of the 14 members of the Army's 24th Infantry Division who have received the Medal of Honor. 111-hconres-232 M001144 Rep. Miller, Jeff [R-FL-1] R FL 2010-02-22 0
111-hconres-232,K000210 Expressing the sense of Congress that a site in Arlington National Cemetery should be provided for a memorial marker to honor the memory of the 14 members of the Army's 24th Infantry Division who have received the Medal of Honor. 111-hconres-232 K000210 Rep. King, Peter T. [R-NY-3] R NY 2010-02-22 0
111-hconres-232,C001065 Expressing the sense of Congress that a site in Arlington National Cemetery should be provided for a memorial marker to honor the memory of the 14 members of the Army's 24th Infantry Division who have received the Medal of Honor. 111-hconres-232 C001065 Rep. Carney, Christopher P. [D-PA-10] D PA 2010-02-22 0
111-hconres-232,O000169 Expressing the sense of Congress that a site in Arlington National Cemetery should be provided for a memorial marker to honor the memory of the 14 members of the Army's 24th Infantry Division who have received the Medal of Honor. 111-hconres-232 O000169 Rep. Owens, William L. [D-NY-23] D NY 2010-02-22 0
111-hconres-232,M001173 Expressing the sense of Congress that a site in Arlington National Cemetery should be provided for a memorial marker to honor the memory of the 14 members of the Army's 24th Infantry Division who have received the Medal of Honor. 111-hconres-232 M001173 Rep. Massa, Eric J. J. [D-NY-29] D NY 2010-02-22 0
111-hconres-232,A000364 Expressing the sense of Congress that a site in Arlington National Cemetery should be provided for a memorial marker to honor the memory of the 14 members of the Army's 24th Infantry Division who have received the Medal of Honor. 111-hconres-232 A000364 Rep. Adler, John H. [D-NJ-3] D NJ 2010-01-26 1
111-hconres-232,S000364 Expressing the sense of Congress that a site in Arlington National Cemetery should be provided for a memorial marker to honor the memory of the 14 members of the Army's 24th Infantry Division who have received the Medal of Honor. 111-hconres-232 S000364 Rep. Shimkus, John [R-IL-19] R IL 2010-01-26 1
111-hconres-232,H001046 Expressing the sense of Congress that a site in Arlington National Cemetery should be provided for a memorial marker to honor the memory of the 14 members of the Army's 24th Infantry Division who have received the Medal of Honor. 111-hconres-232 H001046 Rep. Heinrich, Martin [D-NM-1] D NM 2010-01-26 1
111-hconres-232,T000466 Expressing the sense of Congress that a site in Arlington National Cemetery should be provided for a memorial marker to honor the memory of the 14 members of the Army's 24th Infantry Division who have received the Medal of Honor. 111-hconres-232 T000466 Rep. Teague, Harry [D-NM-2] D NM 2010-01-26 1
111-hconres-232,L000570 Expressing the sense of Congress that a site in Arlington National Cemetery should be provided for a memorial marker to honor the memory of the 14 members of the Army's 24th Infantry Division who have received the Medal of Honor. 111-hconres-232 L000570 Rep. Lujan, Ben Ray [D-NM-3] D NM 2010-01-26 1
111-hconres-232,C001079 Expressing the sense of Congress that a site in Arlington National Cemetery should be provided for a memorial marker to honor the memory of the 14 members of the Army's 24th Infantry Division who have received the Medal of Honor. 111-hconres-232 C001079 Rep. Cao, Anh "Joseph" [R-LA-2] R LA 2010-01-26 1
111-hconres-232,M001149 Expressing the sense of Congress that a site in Arlington National Cemetery should be provided for a memorial marker to honor the memory of the 14 members of the Army's 24th Infantry Division who have received the Medal of Honor. 111-hconres-232 M001149 Rep. Michaud, Michael H. [D-ME-2] D ME 2010-01-26 1
111-hconres-232,K000365 Expressing the sense of Congress that a site in Arlington National Cemetery should be provided for a memorial marker to honor the memory of the 14 members of the Army's 24th Infantry Division who have received the Medal of Honor. 111-hconres-232 K000365 Rep. Kagen, Steve [D-WI-8] D WI 2010-01-26 1
111-hconres-232,K000188 Expressing the sense of Congress that a site in Arlington National Cemetery should be provided for a memorial marker to honor the memory of the 14 members of the Army's 24th Infantry Division who have received the Medal of Honor. 111-hconres-232 K000188 Rep. Kind, Ron [D-WI-3] D WI 2010-01-26 1
111-hconres-232,R000395 Expressing the sense of Congress that a site in Arlington National Cemetery should be provided for a memorial marker to honor the memory of the 14 members of the Army's 24th Infantry Division who have received the Medal of Honor. 111-hconres-232 R000395 Rep. Rogers, Harold [R-KY-5] R KY 2010-01-26 1
111-hconres-232,D000599 Expressing the sense of Congress that a site in Arlington National Cemetery should be provided for a memorial marker to honor the memory of the 14 members of the Army's 24th Infantry Division who have received the Medal of Honor. 111-hconres-232 D000599 Rep. Davis, Lincoln [D-TN-4] D TN 2010-01-26 1
111-hconres-232,M001140 Expressing the sense of Congress that a site in Arlington National Cemetery should be provided for a memorial marker to honor the memory of the 14 members of the Army's 24th Infantry Division who have received the Medal of Honor. 111-hconres-232 M001140 Rep. Moore, Dennis [D-KS-3] D KS 2010-01-26 1
111-hconres-232,H001045 Expressing the sense of Congress that a site in Arlington National Cemetery should be provided for a memorial marker to honor the memory of the 14 members of the Army's 24th Infantry Division who have received the Medal of Honor. 111-hconres-232 H001045 Rep. Harper, Gregg [R-MS-3] R MS 2010-01-26 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);
Powered by Datasette · Queries took 778.605ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API