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
  • Search Legislation
  • Legislation by Policy Area
  • Recently Introduced Legislation
  • Legislation by Sponsor
  • Most Cosponsored Bills
  • Top Legislative Subjects
  • Search Federal Regulations (eCFR)
  • Regulations by Agency
  • CFR Parts Overview
  • Read a CFR Section
  • Search Congressional Record
  • Congressional Record by Date
  • Floor Speeches by Topic
  • Congressional Record by Congress
  • Floor Speeches by Member of Congress
  • Most Active Speakers in Congress
  • Bills Discussed on the Floor
  • Floor Debate for a Specific Bill
  • Search Congress Members
  • Member Profile: Trades, Speeches, Bills
  • Stock Trades for a Member
  • Most Active Congressional Traders
  • Most Traded Stocks by Congress
  • Who Traded a Specific Stock?
  • Member Activity Timeline
  • Current Members of Congress Overview
  • Committee Members
  • Committees for a Member
  • Committee Leadership
  • Stock Trades by Committee Members
  • Cosponsors for a Bill
  • Most Prolific Cosponsors
  • Bipartisan Bills (Cross-Party Cosponsorship)

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

cfr_sections

section_id, title_number, title_name, chapter, subchapter, part_number, part_name, subpart, subpart_name, section_number, section_heading, agency, authority, source_citation, amendment_citations, full_text

55,845 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

committee_memberships

bioguide_id, committee_id, member_name, party, title, rank

3,908 rows

committees

committee_id, name, chamber, url, parent_committee_id

233 rows

congress_members

bioguide_id, first_name, last_name, full_name, nickname, party, state, chamber, district, first_served, last_served, is_current, opensecrets_id, fec_ids, govtrack_id, thomas_id, votesmart_id, wikipedia_id, ballotpedia_id, birthday, gender

12,763 rows

congressional_record

granule_id, date, congress, session, volume, issue, title, chamber, granule_class, sub_granule_class, page_start, page_end, speakers, bills, citation, full_text

Many rows

crec_bills

granule_id, congress, bill_type, bill_number, bill_id

Many rows

crec_speakers

granule_id, speaker_name, speaker_role, bioguide_id, party, state

Many rows

dockets

id, agency_id, title, docket_type, last_modified, object_id

Many 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

Many rows

legislation

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

8,696 rows

legislation_actions

id, bill_id, action_date, action_text, action_type, chamber, action_code

40,506 rows

legislation_cosponsors

bill_id, bioguide_id, full_name, party, state, sponsorship_date, is_original_cosponsor

83,426 rows

legislation_subjects

bill_id, subject

25,049 rows

presidential_documents

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

Many 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

Many rows

sqlite_sequence

name, seq

2 rows

stock_trades

id, member_name, bioguide_id, chamber, transaction_date, disclosure_date, ticker, asset_description, asset_type, transaction_type, amount_range, owner, comment, source_url, filing_type, state_district, doc_id

54,745 rows

... and 30 hidden tables

Views

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