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 = 108 and policy_area = "Sports and Recreation" sorted by introduced_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

policy_area 1

  • Sports and Recreation · 2 ✖

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
108-sres-335 108 sres 335 A resolution expressing the sense of the Senate that Major League Baseball clubs and their players should take immediate action to adopt a drug-testing policy that effectively deters Major League Baseball players from using anabolic steroids and any other performance-enhancing substances that create a competitive advantage for, and pose a serious health risk to, such players and the children and teenagers who emulate them. Sports and Recreation 2004-04-08 2004-04-08 Submitted in the Senate, considered, and agreed to without amendment and with a preamble by Unanimous Consent. (consideration: CR S3996-3999; text as passed Senate: CR S3999; text of measure as introduced: CR S4054) Senate Sen. McCain, John [R-AZ] AZ R M000303 6 (This measure has not been amended since it was introduced. The summary of that version is repeated here.) Urges Major League Baseball and its players to exercise their collective bargaining authority to negotiate and adopt a more stringent drug-testing policy that is sufficient to effectively deter Major League Baseball players from using anabolic steroids or other similar performance-enhancing substances to gain a competitive advantage. 2021-09-29T22:08:04Z https://www.congress.gov/bill/108th-congress/senate-resolution/335
108-sres-279 108 sres 279 A resolution recognizing the importance and contributions of sportsmen to American society, supporting the traditions and values of sportsmen, and recognizing the many economic benefits associated with outdoor sporting activities. Sports and Recreation 2003-12-09 2003-12-09 Referred to the Committee on Environment and Public Works. (text of measure as introduced: CR S16140) Senate Sen. Coleman, Norm [R-MN] MN R C001057 0 Recognizes: (1) the importance and contributions of sportsmen to American society; (2) the many economic benefits associated with outdoor sporting activities; and (3) the importance of encouraging the recruitment of, and teaching the traditions of hunting, trapping, and fishing to, future sportsmen. Supports the traditions and values of, and the many conservation programs implemented by, sportsmen. 2023-01-15T09:17:37Z https://www.congress.gov/bill/108th-congress/senate-resolution/279

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