home

openregs

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

Custom SQL query

Queries

  • Most Commented Dockets
  • Search Comments (Full Text)
  • Search Federal Register
  • Comment Volume by Year & Agency
  • Most Active Organizational Commenters
  • Rulemaking Pipeline (Proposed → Final)
  • Comments for a Docket
  • Federal Register Documents by Agency
  • Recently Published Rules
  • Monthly Comment Activity

Tables

agencies

id, name, raw_name, slug, parent_id

444 rows

agency_map

regs_code, fr_agency_id, fr_agency_name, fr_raw_name

5 rows

comments

id, agency_id, docket_id, title, submitter_name, submitter_type, document_type, posted_date, posted_year, posted_month, last_modified, withdrawn, object_id

Many rows

dockets

id, agency_id, title, docket_type, last_modified, object_id

14,654 rows

documents

id, agency_id, docket_id, title, document_type, subtype, posted_date, posted_year, posted_month, comment_start_date, comment_end_date, last_modified, fr_doc_num, open_for_comment, withdrawn, object_id

Many rows

federal_register

document_number, title, type, abstract, publication_date, pub_year, pub_month, html_url, pdf_url, agency_names, agency_ids, excerpts

Many rows

federal_register_agencies

document_number, agency_id

Many rows

fr_regs_crossref

fr_document_number, regs_document_id

61,877 rows

... and 20 hidden tables

Views

  • docket_stats
  • comments_by_year
  • fr_by_year
  • top_dockets
  • regulatory_pipeline
  • comments_monthly
  • agency_overview
  • top_submitters
Powered by Datasette · Queries took 474.97ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API