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

2 rows where bill_type = "sres", congress = 111 and policy_area = "Law" sorted by introduced_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

policy_area 1

congress 1

bill_type 1

  • sres · 2 ✖
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
111-sres-339 111 sres 339 A resolution to express the sense of the Senate in support of permitting the televising of Supreme Court proceedings. Law 2009-11-05 2010-06-08 Placed on Senate Legislative Calendar under General Orders. Calendar No. 421. Senate Sen. Specter, Arlen [D-PA] PA D S000709 9 (This measure has not been amended since it was introduced. The summary of that version is repeated here.) Expresses the sense of the Senate that the Supreme Court should permit live television coverage of all open sessions of the Court unless the Court decides, by a vote of the majority of justices, that allowing such coverage in a particular case would constitute a violation of the due process rights of one or more of the parties before the Court. 2023-01-11T13:17:03Z https://www.congress.gov/bill/111th-congress/senate-resolution/339
111-sres-15 111 sres 15 A resolution acknowledging the lifelong service of Griffin Boyette Bell, a legal icon, to the State of Georgia and to the United States. Law 2009-01-16 2009-01-16 Submitted in the Senate, considered, and agreed to without amendment and with a preamble by Unanimous Consent. (consideration: CR S657-658; text as passed Senate: CR S657-658; text of measure as introduced: CR S655) Senate Sen. Chambliss, Saxby [R-GA] GA R C000286 6 Acknowledges the lifelong services of Griffin Boyette Bell to the state of Georgia and the United States as a legal icon. Commends him for his tenure as Attorney General of the United States and his commitment to the American Civil Rights Movement. 2022-02-03T06:04:04Z https://www.congress.gov/bill/111th-congress/senate-resolution/15

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