openregs: legislation: 11 rows where bill_type = "sconres" and policy_area = "Law" sorted by introduced

Congressional bills and resolutions from Congress.gov, filtered to policy areas relevant to environmental, health, agriculture, and wildlife regulation.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

11 rows where bill_type = "sconres" and policy_area = "Law" sorted by introduced_date descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

bill_id	congress	bill_type	bill_number	title	policy_area	introduced_date ▲	latest_action_date	latest_action_text	origin_chamber	sponsor_name	sponsor_state	sponsor_party	sponsor_bioguide_id	cosponsor_count	summary_text	update_date
112-sconres-11	112	sconres	11	A concurrent resolution expressing the sense of Congress with respect to the Obama administration's discontinuing to defend the Defense of Marriage Act.	Law	2011-04-06	2011-04-06	Referred to the Committee on the Judiciary. (text of measure as introduced: CR S2212)	Senate	Sen. Inhofe, James M. [R-OK]	OK	R	I000024	0	Condemns the Obama administration's direction that the Department of Justice (DOJ) should discontinue defending the Defense of Marriage Act (DOMA) and demands that the DOJ continue to defend DOMA in all instances.	2022-02-03T05:54:26Z
108-sconres-130	108	sconres	130	A concurrent resolution expressing the sense of Congress that the Supreme Court of the United States should act expeditiously to resolve the confusion and inconsistency in the Federal criminal justice system caused by its decision in Blakely v. Washington, and for other purposes.	Law	2004-07-21	2004-11-05	Referred to the Subcommittee on Courts, the Internet, and Intellectual Property.	Senate	Sen. Hatch, Orrin G. [R-UT]	UT	R	H000338	15	(This measure has not been amended since it was introduced. The summary of that version is repeated here.) Expresses the sense of Congress that the Supreme Court should act expeditiously to resolve the current confusion and inconsistency in the Federal criminal justice system by promptly considering and ruling on the constitutionality of the Federal Sentencing Guidelines.	2023-01-14T22:48:24Z
103-sconres-21	103	sconres	21	A concurrent resolution expressing the sense of the Congress that expert testimony concerning the nature and effect of domestic violence, including descriptions of the experiences of battered women, should be admissible if offered in a State court by a defendant in a criminal case.	Law	1993-03-30	1994-11-29	Referred to the House Committee on Judiciary.	Senate	Sen. Moseley-Braun, Carol [D-IL]	IL	D	M001025	8	Expresses the sense of the Congress that: (1) expert testimony concerning the nature and effect of domestic violence, including descriptions of the experiences of battered women, should be admissible when offered in a State court by a defendant in a criminal case to assist the trier of fact in understanding the behavior, beliefs, or perceptions of such defendant in a domestic relationship in which abuse has occurred; (2) a witness should be qualified to testify as an expert witness, with respect to a case in which abuse has occurred, based upon the witness's knowledge, skill, experience, training, or education, and should be permitted to testify in the form of an opinion or otherwise; and (3) domestic relationships about which such expert testimony should be admissible include relationships between spouses, former spouses, cohabitants, former cohabitants, partners or former partners, and between persons who are in, or have been in, a dating, courtship, or intimate relationship.	2025-07-21T19:32:26Z
102-sconres-120	102	sconres	120	A concurrent resolution declaring an article of amendment to be the Twenty-seventh Amendment to the Constitution of the United States.	Law	1992-05-19	1992-05-21	Message on Senate action sent to the House.	Senate	Sen. Byrd, Robert C. [D-WV]	WV	D	B001210	9	Declares a proposed article of amendment to the Constitution relating to the effective date of laws varying the compensation of Members of Congress to be valid as the 27th Amendment to the Constitution.	2021-06-02T15:41:28Z
102-sconres-121	102	sconres	121	A concurrent resolution declaring the time for ratification to have lapsed for four proposed articles of amendment to the Constitution of the United States.	Law	1992-05-19	1992-05-19	Referred to the Committee on Judiciary.	Senate	Sen. Byrd, Robert C. [D-WV]	WV	D	B001210	0	Declares that the periods for ratification have lapsed for four proposed amendments to the Constitution relating to: (1) the size of the House of Representatives; (2) the acceptance of titles of nobility from foreign governments; (3) the protection of slavery from abolition by the Constitution and the Congress; and (4) the regulation of child labor. Declares that such amendments are no longer subject to ratification as part of the Constitution.	2025-07-21T19:32:26Z
102-sconres-119	102	sconres	119	A concurrent resolution to state the finding of Congress that the Amendment to the Constitution of the United States relating to compensation for Members of Congress has been duly ratified, and for other purposes.	Law	1992-05-14	1992-05-14	Referred to the Committee on Judiciary.	Senate	Sen. Cochran, Thad [R-MS]	MS	R	C000567	0	States the finding of the Congress that: (1) the proposed Constitutional amendment, relating to the prohibition against varying the compensation of Members of Congress until an intervening election of Representatives, has been duly ratified; (2) the Archivist has stated that he shall publish such amendment as part of the Constitution; and (3) the Congress shall enact all laws relating to compensation of Members of Congress pursuant to such amendment.	2025-07-21T19:32:26Z
102-sconres-117	102	sconres	117	A concurrent resolution declaring an article of amendment to be part of the Constitution of the United States.	Law	1992-05-12	1992-05-12	Referred to the Committee on Judiciary.	Senate	Sen. Byrd, Robert C. [D-WV]	WV	D	B001210	0	Declares the 27th article of amendment to the Constitution, providing that no law varying the compensation for the services of Members of Congress shall take effect until an election of Representatives has intervened, to be part of the Constitution.	2025-07-21T19:32:26Z
102-sconres-118	102	sconres	118	A concurrent resolution declaring the ratification of the twenty-seventh Article of Amendment to the Constitution of the United States.	Law	1992-05-12	1992-05-12	Referred to the Committee on Judiciary.	Senate	Sen. Grassley, Chuck [R-IA]	IA	R	G000386	15	Declares the 27th article of amendment to the Constitution, providing that no law varying the compensation for the services of Members of Congress shall take effect until an election of Representatives has intervened, to be part of the Constitution.	2025-07-21T19:32:26Z
102-sconres-114	102	sconres	114	A concurrent resolution expressing the sense of the Congress relating to the ratification of an amendment to the Constitution of the United States which varies compensation of Members of Congress until after the next election of Representatives.	Law	1992-05-06	1992-05-06	Referred to the Committee on Judiciary.	Senate	Sen. Nickles, Don [R-OK]	OK	R	N000102	0	Expresses the sense of the Congress that at least one of the remaining 13 States should ratify the proposed second amendment to the Constitution which would delay the effect of any law which varies the compensation of Members of Congress until the next election of Representatives (these States are California, Hawaii, Illinois, Kentucky, Massachusetts, Michigan, Mississippi, Nebraska, New Jersey, New York, Pennsylvania, Rhode Island, and Washington).	2025-07-21T19:32:26Z
95-sconres-22	95	sconres	22	A concurrent resolution inviting the Chief Justice to address the Congress.	Law	1977-04-28	1977-04-28	Referred to Senate Committee on the Judiciary.	Senate	Sen. Kennedy, Edward M. [D-MA]	MA	D	K000105	4	Extends an invitation to the Chief Justice to appear before a joint session of the Congress to report on the state of judiciary.	2025-07-21T19:32:26Z
94-sconres-38	94	sconres	38	A concurrent resolution to request the Chief Justice of the United States to appear before a joint session of the Congress.	Law	1975-05-14	1975-05-14	Referred to Senate Committee on the Judiciary.	Senate	Sen. Bayh, Birch [D-IN]	IN	D	B000254	1	Requests the Chief Justice of the United States to appear before a joint session of Congress to report on the state of the Judiciary.	2025-07-21T19:32:26Z

Advanced export

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

CREATE TABLE legislation (
    bill_id TEXT PRIMARY KEY,
    congress INTEGER,
    bill_type TEXT,
    bill_number INTEGER,
    title TEXT,
    policy_area TEXT,
    introduced_date TEXT,
    latest_action_date TEXT,
    latest_action_text TEXT,
    origin_chamber TEXT,
    sponsor_name TEXT,
    sponsor_state TEXT,
    sponsor_party TEXT,
    sponsor_bioguide_id TEXT,
    cosponsor_count INTEGER DEFAULT 0,
    summary_text TEXT,
    update_date TEXT,
    url TEXT
);
CREATE INDEX idx_leg_congress ON legislation(congress);
CREATE INDEX idx_leg_type ON legislation(bill_type);
CREATE INDEX idx_leg_policy ON legislation(policy_area);
CREATE INDEX idx_leg_date ON legislation(introduced_date);
CREATE INDEX idx_leg_sponsor ON legislation(sponsor_name);
CREATE INDEX idx_leg_sponsor_bioguide ON legislation(sponsor_bioguide_id);