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
  • Search Dockets
  • Search Regulatory Documents
  • Currently Open for Comment
  • Comment Volume by Year & Agency
  • Most Active Organizational Commenters
  • Rulemaking Pipeline (Proposed → Final)
  • Comments for a Docket
  • Dockets for an Agency
  • Federal Register Documents by Agency
  • Recently Published Rules
  • Recently Proposed Rules
  • Comment Period Durations
  • Monthly Comment Activity
  • Federal Register ↔ Regulations.gov Lookup
  • Federal Register Activity by Year
  • Comments by a Specific Submitter
  • Executive Orders
  • Search Executive Orders & Proclamations
  • Recent Executive Orders
  • Look Up Executive Order by Number
  • Presidential Documents by Year
  • Presidential Proclamations
  • Federal Spending by Agency
  • Top Grant Recipients
  • Top Contractors
  • Search Spending Awards
  • Federal Spending by State

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

presidential_documents

document_number, title, document_type, executive_order_number, signing_date, publication_date, html_url, abstract

5,904 rows

spending_awards

generated_internal_id, award_id, agency, sub_agency, award_category, award_type, recipient_name, award_amount, total_outlays, description, start_date, end_date, fiscal_year, state_code, cfda_number, naics_code, naics_description

122,493 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 2663.328ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API