openregs: legislation_cosponsors: 27 rows where bill_id = "112-sconres-4" sorted by sponsorship

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

27 rows where bill_id = "112-sconres-4" sorted by sponsorship_date descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Link	bill_id	bioguide_id	full_name	party	state	sponsorship_date ▲
112-sconres-4,L000261	A concurrent resolution expressing the sense of Congress that an appropriate site on Chaplains Hill in Arlington National Cemetery should be provided for a memorial marker to honor the memory of the Jewish chaplains who died while on active duty in the Armed Forces of the United States. 112-sconres-4	L000261	Sen. Levin, Carl [D-MI]	D	MI	2011-05-25
112-sconres-4,P000449	A concurrent resolution expressing the sense of Congress that an appropriate site on Chaplains Hill in Arlington National Cemetery should be provided for a memorial marker to honor the memory of the Jewish chaplains who died while on active duty in the Armed Forces of the United States. 112-sconres-4	P000449	Sen. Portman, Rob [R-OH]	R	OH	2011-05-23
112-sconres-4,C000174	A concurrent resolution expressing the sense of Congress that an appropriate site on Chaplains Hill in Arlington National Cemetery should be provided for a memorial marker to honor the memory of the Jewish chaplains who died while on active duty in the Armed Forces of the United States. 112-sconres-4	C000174	Sen. Carper, Thomas R. [D-DE]	D	DE	2011-05-19
112-sconres-4,W000779	A concurrent resolution expressing the sense of Congress that an appropriate site on Chaplains Hill in Arlington National Cemetery should be provided for a memorial marker to honor the memory of the Jewish chaplains who died while on active duty in the Armed Forces of the United States. 112-sconres-4	W000779	Sen. Wyden, Ron [D-OR]	D	OR	2011-05-19
112-sconres-4,J000291	A concurrent resolution expressing the sense of Congress that an appropriate site on Chaplains Hill in Arlington National Cemetery should be provided for a memorial marker to honor the memory of the Jewish chaplains who died while on active duty in the Armed Forces of the United States. 112-sconres-4	J000291	Sen. Johanns, Mike [R-NE]	R	NE	2011-05-17
112-sconres-4,N000032	A concurrent resolution expressing the sense of Congress that an appropriate site on Chaplains Hill in Arlington National Cemetery should be provided for a memorial marker to honor the memory of the Jewish chaplains who died while on active duty in the Armed Forces of the United States. 112-sconres-4	N000032	Sen. Nelson, Bill [D-FL]	D	FL	2011-05-17
112-sconres-4,U000038	A concurrent resolution expressing the sense of Congress that an appropriate site on Chaplains Hill in Arlington National Cemetery should be provided for a memorial marker to honor the memory of the Jewish chaplains who died while on active duty in the Armed Forces of the United States. 112-sconres-4	U000038	Sen. Udall, Mark [D-CO]	D	CO	2011-05-17
112-sconres-4,B001268	A concurrent resolution expressing the sense of Congress that an appropriate site on Chaplains Hill in Arlington National Cemetery should be provided for a memorial marker to honor the memory of the Jewish chaplains who died while on active duty in the Armed Forces of the United States. 112-sconres-4	B001268	Sen. Brown, Scott P. [R-MA]	R	MA	2011-05-16
112-sconres-4,R000595	A concurrent resolution expressing the sense of Congress that an appropriate site on Chaplains Hill in Arlington National Cemetery should be provided for a memorial marker to honor the memory of the Jewish chaplains who died while on active duty in the Armed Forces of the United States. 112-sconres-4	R000595	Sen. Rubio, Marco [R-FL]	R	FL	2011-05-16
112-sconres-4,B000711	A concurrent resolution expressing the sense of Congress that an appropriate site on Chaplains Hill in Arlington National Cemetery should be provided for a memorial marker to honor the memory of the Jewish chaplains who died while on active duty in the Armed Forces of the United States. 112-sconres-4	B000711	Sen. Boxer, Barbara [D-CA]	D	CA	2011-04-14
112-sconres-4,F000062	A concurrent resolution expressing the sense of Congress that an appropriate site on Chaplains Hill in Arlington National Cemetery should be provided for a memorial marker to honor the memory of the Jewish chaplains who died while on active duty in the Armed Forces of the United States. 112-sconres-4	F000062	Sen. Feinstein, Dianne [D-CA]	D	CA	2011-04-13
112-sconres-4,B001277	A concurrent resolution expressing the sense of Congress that an appropriate site on Chaplains Hill in Arlington National Cemetery should be provided for a memorial marker to honor the memory of the Jewish chaplains who died while on active duty in the Armed Forces of the United States. 112-sconres-4	B001277	Sen. Blumenthal, Richard [D-CT]	D	CT	2011-04-07
112-sconres-4,F000457	A concurrent resolution expressing the sense of Congress that an appropriate site on Chaplains Hill in Arlington National Cemetery should be provided for a memorial marker to honor the memory of the Jewish chaplains who died while on active duty in the Armed Forces of the United States. 112-sconres-4	F000457	Sen. Franken, Al [D-MN]	D	MN	2011-04-05
112-sconres-4,B000944	A concurrent resolution expressing the sense of Congress that an appropriate site on Chaplains Hill in Arlington National Cemetery should be provided for a memorial marker to honor the memory of the Jewish chaplains who died while on active duty in the Armed Forces of the United States. 112-sconres-4	B000944	Sen. Brown, Sherrod [D-OH]	D	OH	2011-03-28
112-sconres-4,L000304	A concurrent resolution expressing the sense of Congress that an appropriate site on Chaplains Hill in Arlington National Cemetery should be provided for a memorial marker to honor the memory of the Jewish chaplains who died while on active duty in the Armed Forces of the United States. 112-sconres-4	L000304	Sen. Lieberman, Joseph I. [ID-CT]	ID	CT	2011-03-17
112-sconres-4,C001070	A concurrent resolution expressing the sense of Congress that an appropriate site on Chaplains Hill in Arlington National Cemetery should be provided for a memorial marker to honor the memory of the Jewish chaplains who died while on active duty in the Armed Forces of the United States. 112-sconres-4	C001070	Sen. Casey, Robert P., Jr. [D-PA]	D	PA	2011-03-15
112-sconres-4,M000702	A concurrent resolution expressing the sense of Congress that an appropriate site on Chaplains Hill in Arlington National Cemetery should be provided for a memorial marker to honor the memory of the Jewish chaplains who died while on active duty in the Armed Forces of the United States. 112-sconres-4	M000702	Sen. Mikulski, Barbara A. [D-MD]	D	MD	2011-03-14
112-sconres-4,K000360	A concurrent resolution expressing the sense of Congress that an appropriate site on Chaplains Hill in Arlington National Cemetery should be provided for a memorial marker to honor the memory of the Jewish chaplains who died while on active duty in the Armed Forces of the United States. 112-sconres-4	K000360	Sen. Kirk, Mark Steven [R-IL]	R	IL	2011-03-10
112-sconres-4,M000639	A concurrent resolution expressing the sense of Congress that an appropriate site on Chaplains Hill in Arlington National Cemetery should be provided for a memorial marker to honor the memory of the Jewish chaplains who died while on active duty in the Armed Forces of the United States. 112-sconres-4	M000639	Sen. Menendez, Robert [D-NJ]	D	NJ	2011-03-03
112-sconres-4,K000367	A concurrent resolution expressing the sense of Congress that an appropriate site on Chaplains Hill in Arlington National Cemetery should be provided for a memorial marker to honor the memory of the Jewish chaplains who died while on active duty in the Armed Forces of the United States. 112-sconres-4	K000367	Sen. Klobuchar, Amy [D-MN]	D	MN	2011-03-02
112-sconres-4,K000148	A concurrent resolution expressing the sense of Congress that an appropriate site on Chaplains Hill in Arlington National Cemetery should be provided for a memorial marker to honor the memory of the Jewish chaplains who died while on active duty in the Armed Forces of the United States. 112-sconres-4	K000148	Sen. Kerry, John F. [D-MA]	D	MA	2011-03-01
112-sconres-4,R000122	A concurrent resolution expressing the sense of Congress that an appropriate site on Chaplains Hill in Arlington National Cemetery should be provided for a memorial marker to honor the memory of the Jewish chaplains who died while on active duty in the Armed Forces of the United States. 112-sconres-4	R000122	Sen. Reed, Jack [D-RI]	D	RI	2011-03-01
112-sconres-4,M001170	A concurrent resolution expressing the sense of Congress that an appropriate site on Chaplains Hill in Arlington National Cemetery should be provided for a memorial marker to honor the memory of the Jewish chaplains who died while on active duty in the Armed Forces of the United States. 112-sconres-4	M001170	Sen. McCaskill, Claire [D-MO]	D	MO	2011-02-28
112-sconres-4,L000123	A concurrent resolution expressing the sense of Congress that an appropriate site on Chaplains Hill in Arlington National Cemetery should be provided for a memorial marker to honor the memory of the Jewish chaplains who died while on active duty in the Armed Forces of the United States. 112-sconres-4	L000123	Sen. Lautenberg, Frank R. [D-NJ]	D	NJ	2011-02-14
112-sconres-4,G000555	A concurrent resolution expressing the sense of Congress that an appropriate site on Chaplains Hill in Arlington National Cemetery should be provided for a memorial marker to honor the memory of the Jewish chaplains who died while on active duty in the Armed Forces of the United States. 112-sconres-4	G000555	Sen. Gillibrand, Kirsten E. [D-NY]	D	NY	2011-02-14
112-sconres-4,W000802	A concurrent resolution expressing the sense of Congress that an appropriate site on Chaplains Hill in Arlington National Cemetery should be provided for a memorial marker to honor the memory of the Jewish chaplains who died while on active duty in the Armed Forces of the United States. 112-sconres-4	W000802	Sen. Whitehouse, Sheldon [D-RI]	D	RI	2011-02-03
112-sconres-4,C000141	A concurrent resolution expressing the sense of Congress that an appropriate site on Chaplains Hill in Arlington National Cemetery should be provided for a memorial marker to honor the memory of the Jewish chaplains who died while on active duty in the Armed Forces of the United States. 112-sconres-4	C000141	Sen. Cardin, Benjamin L. [D-MD]	D	MD	2011-02-03

Advanced export

JSON shape: default, array, newline-delimited, object

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);