openregs

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

Custom SQL query

Queries

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

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_subjects

bill_id, subject

25,049 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

sqlite_sequence

name, seq

1 row

... and 20 hidden tables

Views