home / openregs

crec_bills

Bills referenced in Congressional Record floor proceedings. Links floor debate to specific legislation. Cross-references with the legislation table via bill_id.

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

7 rows where granule_id = "CREC-2026-03-02-pt1-PgD228" sorted by congress descending

✎ View and edit SQL

This data as json, CSV (advanced)

bill_type 4

  • hr 2
  • s 2
  • sres 2
  • hconres 1

congress 1

  • 119 7
Link granule_id congress ▲ bill_type bill_number bill_id
CREC-2026-03-02-pt1-PgD228,119,sres,625 Daily Digest/Highlights + Senate CREC-2026-03-02-pt1-PgD228 119 sres 625 119-sres-625
CREC-2026-03-02-pt1-PgD228,119,sres,624 Daily Digest/Highlights + Senate CREC-2026-03-02-pt1-PgD228 119 sres 624 119-sres-624
CREC-2026-03-02-pt1-PgD228,119,s,3962 Daily Digest/Highlights + Senate CREC-2026-03-02-pt1-PgD228 119 s 3962 119-s-3962
CREC-2026-03-02-pt1-PgD228,119,s,3956 Daily Digest/Highlights + Senate CREC-2026-03-02-pt1-PgD228 119 s 3956 119-s-3956
CREC-2026-03-02-pt1-PgD228,119,hr,6719 Daily Digest/Highlights + Senate CREC-2026-03-02-pt1-PgD228 119 hr 6719 119-hr-6719
CREC-2026-03-02-pt1-PgD228,119,hr,6644 Daily Digest/Highlights + Senate CREC-2026-03-02-pt1-PgD228 119 hr 6644 119-hr-6644
CREC-2026-03-02-pt1-PgD228,119,hconres,72 Daily Digest/Highlights + Senate CREC-2026-03-02-pt1-PgD228 119 hconres 72 119-hconres-72

Advanced export

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

CSV options:

CREATE TABLE crec_bills (
    granule_id TEXT NOT NULL REFERENCES congressional_record(granule_id),
    congress INTEGER,
    bill_type TEXT,
    bill_number INTEGER,
    bill_id TEXT,
    PRIMARY KEY (granule_id, congress, bill_type, bill_number)
);
CREATE INDEX idx_crec_bill_id ON crec_bills(bill_id);
CREATE INDEX idx_crec_bill_type ON crec_bills(bill_type, bill_number);
Powered by Datasette · Queries took 269.163ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API