home / openregs

legislation

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

6 rows where bill_type = "sconres", congress = 102 and policy_area = "Law" sorted by introduced_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

policy_area 1

  • Law · 6 ✖

congress 1

  • 102 · 6 ✖

bill_type 1

  • sconres · 6 ✖
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 url
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 https://www.congress.gov/bill/102nd-congress/senate-concurrent-resolution/120
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 https://www.congress.gov/bill/102nd-congress/senate-concurrent-resolution/121
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 https://www.congress.gov/bill/102nd-congress/senate-concurrent-resolution/119
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 https://www.congress.gov/bill/102nd-congress/senate-concurrent-resolution/117
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 https://www.congress.gov/bill/102nd-congress/senate-concurrent-resolution/118
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 https://www.congress.gov/bill/102nd-congress/senate-concurrent-resolution/114

Advanced export

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

CSV options:

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);
Powered by Datasette · Queries took 23.964ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API · Privacy