Explore the Data
Search
Public Comments & Dockets
Executive Orders & Proclamations
Federal Register
Analysis & Trends
openregs
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
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)
- Federal Spending by Sub-Agency
- Spending Trends Over Time
- Explore: Member Search
- Explore: Member Profile
- Explore: Member Stock Trades
- Explore: Member Floor Speeches
- Explore: Member Legislation
- Explore: Docket Detail
- Explore: Docket Documents
- Explore: Docket Comment Stats
- Explore: Lobbying Client Search
- Explore: Client Lobbying Activity
- Explore: Client Lobbyists
- Explore: Lobbying Issue Areas
- Explore: Revolving Door
- FARA: Foreign Principals by Country
- FARA: Search Registrants
- FARA: Agents Representing a Country
- FEC: Top PAC Donors to a Candidate
- FEC: Top Employer Aggregates
- FEC: Employer Donations to a Member
- Votes: Member Voting Record
- Votes: Most Partisan Roll Calls
- Votes: Recent Roll Calls
- Nomination Confirmation Rates by Congress
- Most Frequent Hearing Witnesses
- Committee Hearing Activity
- GAO Reports by Subject Area
- CRS Reports by Topic
- Recently Confirmed Nominations
- Treaties by Country
- Hearing Witnesses Who Also Lobby Congress
- Organizations That Comment on Regulations AND Lobby
- Stock Trading by Committee Members
- Top Campaign Donors to Committee Members
- Floor Speeches Within 7 Days of Stock Trades
- Most Lobbied Bills
- Stock Trades in Committee-Regulated Sectors
- The Revolving Door: Former Members Who Became Lobbyists
- Committee Jurisdiction → Regulated Sectors
- Lobbying Issue Codes → Agencies & Committees
- Senate top offices by spending
- House top vendors (non-personnel)
- House office quarterly spending (2016+)
- House: personnel vs non-personnel spending per office
- House pre-2016 member office totals
- WH top policy visitors (named)
- WH most-visited hosts
- WH daily visit volume by admin
- WH visitor full-text search
- Entity name search (FTS)
- Entities with full identifier coverage
- Industry: top entities by size
- Public-actors search (FTS)
- OGE senior officials by department
- OGE transactions by ticker
- OGE recent transactions (sorted by value bracket)
Tables
bills_floor_time
bill_id, congress, bill_type, bill_number, bill_title, policy_area, sponsor_name, floor_mentions, days_discussed, first_discussed, last_discussed
135,378 rows
bmf_group_exemptions
gen, member_count, most_common_state, inferred_parent_hint, parent_ein, parent_name
3,895 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
123,069 rows
comment_details
id, comment_text, organization, organization_normalized, first_name, last_name, city, state_province, zip, country, subtype, category, tracking_number, duplicate_comments, comment_on_document_id, receive_date, postmark_date, gov_agency, gov_agency_type, page_count, attachment_count, attachment_urls
428,838 rows
commenter_lobby_overlap
organization, comments_filed, agencies_commented, lobby_filings, total_lobby_income, lobby_issues
4,663 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
comments_by_year
agency_id, posted_year, comment_count, docket_count, org_comments, individual_comments, anonymous_comments
1,303 rows
comments_monthly
agency_id, posted_year, posted_month, year_month, comment_count, active_dockets
10,301 rows
committee_donor_summary
committee_name, member_name, party, state, bioguide_id, donor_committee, donor_cmte_id, total_donated, contribution_count
Many rows
committee_jurisdiction
id, committee_id, committee_name, chamber, jurisdiction_desc, sic_codes, jurisdiction_tier, notes
27 rows
committee_sectors
committee_id, committee_name, chamber, regulated_sectors, example_tickers, gics_sectors, sic_ranges, notes
33 rows
committee_trade_conflicts
full_name, party, state, bioguide_id, committee_name, jurisdiction_desc, jurisdiction_tier, sic_code, sic_description, transaction_date, ticker, asset_description, transaction_type, amount_range
3,183 rows
committee_trade_counts
committee_name, committee_id, member_name, party, state, bioguide_id, trade_count, unique_tickers, purchases, sales, first_trade, last_trade
1,420 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, lis_id, wikipedia_id, ballotpedia_id, birthday, gender, terms_count, served_until, trade_count, speech_count, bills_sponsored, vote_count, fec_total_received
12,766 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
878,583 rows
crs_reports
id, title, publish_date, update_date, status, content_type, authors, topics, summary, pdf_url, html_url
13,727 rows
docket_importance
docket_id, agency_id, title, total_docs, doc_type_count, proposed_rules, final_rules, comment_count, fr_crossref_count, importance_score
111,363 rows
docket_stats
id, agency_id, title, docket_type, comment_count, document_count, earliest_comment, latest_comment, earliest_document, latest_document
254,910 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
earmark_spending_crossref
earmark_id, bioguide_id, member_name, earmark_fy, earmark_recipient, amount_requested, project_description, spending_id, spending_recipient, award_amount, spending_agency, spending_description, spending_fy, match_type
148,162 rows
earmarks
id, fiscal_year, chamber, member_name, member_last, member_first, bioguide_id, party, state, district, subcommittee, recipient, recipient_normalized, project_description, recipient_address, amount_requested
70,826 rows
entities
entity_id, canonical_name, name_normalized, display_name, entity_type, ein, cik, uei, lei, ticker, fec_committee_id, duns, sic_code, naics_code, ntee_code, state_of_incorporation, primary_state, country, status, merged_into_entity_id, source_provenance, first_seen_date, last_seen_date, created_at, updated_at, notes, dd_id, predecessor_names, primary_industry, industry_codes, naics_description, psc_code
Many rows
entity_aliases
entity_id, alias_name, alias_normalized, alias_source, effective_start, effective_end
444,289 rows
entity_dominance
name_normalized, entity_id, dominance_ratio, candidate_count, size, notes
17,705 rows
entity_relationships
relationship_id, parent_entity_id, child_entity_id, relationship_type, source, source_ref, gen, effective_start, effective_end, confidence_score, notes, created_at
Many rows
fara_foreign_principals
rowid, registration_number, registrant_date, registrant_name, foreign_principal, fp_registration_date, fp_termination_date, country, address_1, address_2, city, state, zip
17,652 rows
fara_hearing_overlap
registrant_name, registration_number, hearings_testified, countries_represented, countries, foreign_principals, first_hearing, last_hearing, registration_date, termination_date
83 rows
fara_registrant_docs
rowid, registration_number, registrant_name, date_stamped, document_type, short_form_name, foreign_principal_name, foreign_principal_country, url
151,987 rows
fara_registrants
registration_number, registration_date, termination_date, name, name_normalized, business_name, address_1, address_2, city, state, zip
7,043 rows
fara_short_forms
rowid, registration_number, registration_date, registrant_name, short_form_date, short_form_termination_date, last_name, first_name, address_1, address_2, city, state, zip
44,416 rows
fec_candidates
cand_id, cand_name, cand_pty_affiliation, cand_election_yr, cand_office_st, cand_office, cand_office_district, cand_ici, cand_status, cand_pcc, cycle
64,679 rows
fec_committees
cmte_id, cmte_nm, cmte_tp, cmte_dsgn, cmte_pty_affiliation, org_tp, connected_org_nm, cand_id, cycle
154,967 rows
fec_communication_costs
cmte_id, cmte_nm, cand_id, cand_name, cand_office, transaction_dt, transaction_amt, communication_tp, purpose, sup_opp, cycle
25,641 rows
fec_contributions
cmte_id, cmte_name, cand_id, cand_name, transaction_dt, transaction_amt, entity_tp, state, employer, occupation, cycle
Many rows
fec_electioneering
cmte_id, cmte_nm, cand_id, cand_name, cand_office, disb_amt, disb_dt, comm_dt, payee_name, cycle
1,679 rows
fec_employer_to_candidate
employer, cand_id, bioguide_id, cand_name, party, office, state, cycle, donation_count, total_amount
476,534 rows
fec_employer_to_party
employer, party, cycle, donation_count, total_amount, candidate_count
286,908 rows
fec_employer_totals
employer, donation_count, total_amount, avg_amount, unique_states, min_cycle, max_cycle
352,103 rows
fec_independent_expenditures
cand_id, cand_name, spe_id, spe_nam, can_office, can_office_state, cand_pty_aff, exp_amo, exp_date, agg_amo, sup_opp, pur, pay, dissem_dt, fec_election_yr, cycle
666,910 rows
fec_operating_expenditures
cmte_id, cmte_name, form_tp_cd, name, city, state, zip_code, transaction_dt, transaction_amt, purpose, category, category_desc, entity_tp, memo_cd, memo_text, cycle
Many rows
fec_pac_summary
cmte_id, cmte_nm, cmte_tp, cmte_dsgn, ttl_receipts, indv_contrib, other_pol_cmte_contrib, ttl_disb, contrib_to_other_cmte, ind_exp, pty_coord_exp, coh_cop, debts_owed_by, cvg_end_dt, cycle
98,614 rows
federal_register
document_number, title, type, abstract, publication_date, pub_year, pub_month, html_url, pdf_url, agency_names, agency_ids, excerpts, regulation_id_numbers
994,487 rows
gao_reports
package_id, title, date_issued, report_number, document_type, doc_class, abstract, subjects, public_laws, usc_references, statute_references, citation, pdf_url, html_url, detail_url, sudocs
73,725 rows
government_units
gov_unit_id, census_pid6, census_gidid, level, unit_type, name, name_normalized, state, fips_state, fips_county, county_name, city, zip, web_address, population, source, source_year, dd_id
92,206 rows
hearing_witnesses
id, package_id, name, title, organization, organization_normalized, location
109,242 rows
hearings
package_id, title, chamber, congress, session, date_issued, committees, detail_url, html_url, pdf_url
46,177 rows
house_disbursements_nonpersonnel
id, quarter, organization, organization_code, fiscal_year, program, program_code, sort_subtotal, budget_obj_class, transaction_date, data_source, document, vendor_name, vendor_id, perform_start, perform_end, description, budget_obj_code, amount
Many rows
house_disbursements_personnel_agg
quarter, organization, organization_code, sort_subtotal, budget_obj_class, program, n_transactions, n_distinct_employees, total_amount
50,777 rows
house_disbursements_summary
id, quarter, organization, organization_code, program, program_code, sort_subtotal, budget_obj_class, amount, description
161,684 rows
house_pre2016_office_totals
id, quarter, office_year, office_type, office_name, category, ytd_amount, quarter_amount, source_pdf
222,650 rows
ig_recommendations
report_id, rec_number, significant, text, questioned_costs, funds_for_better_use
11,999 rows
ig_reports
report_id, title, date_issued, report_number, report_type, agency_reviewed, submitting_oig, location, description, num_recommendations, questioned_costs, funds_for_better_use, pdf_url, detail_url
34,880 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
375,620 rows
legislation_actions
id, bill_id, action_date, action_text, action_type, chamber, action_code
Many rows
legislation_cosponsors
bill_id, bioguide_id, full_name, party, state, sponsorship_date, is_original_cosponsor
Many rows
legislation_policy_summary
policy_area, bill_count, sponsor_count, from_congress, to_congress
717 rows
legislation_sponsor_summary
sponsor_name, sponsor_party, sponsor_state, sponsor_bioguide_id, bill_count
2,585 rows
lobbying_activities
id, filing_uuid, filing_type, registrant_name, registrant_id, client_name, client_name_normalized, filing_year, filing_period, issue_code, specific_issues, government_entities, income_amount, expense_amount, is_no_activity, is_termination, received_date
Many rows
lobbying_bill_summary
bill_id, bill_title, policy_area, lobby_filings, unique_clients, issue_codes, clients
105,212 rows
lobbying_bills
id, filing_uuid, bill_congress, bill_type, bill_number, bill_id, client_name, issue_code
Many rows
lobbying_by_year
filing_year, filing_count, unique_clients, unique_registrants, total_income_reported, total_expense_reported
28 rows
lobbying_contributions
id, filing_uuid, lobbyist_name, contributor_name, payee_name, recipient_name, contribution_type, amount, contribution_date, filing_year, filing_period, registrant_name, received_date
Many rows
lobbying_filings
filing_uuid, filing_type, registrant_id, registrant_name, registrant_state, registrant_country, registrant_house_id, client_id, client_name, client_state, client_ppb_state, client_country, client_ppb_country, client_general_description, client_government_entity, filing_year, filing_period, received_date, amount_reported, is_amendment, is_no_activity, is_termination, affiliated_org_count
Many rows
lobbying_issue_agencies
issue_code, issue_description, primary_agencies, secondary_agencies, regs_gov_agency_prefixes, federal_register_agency_slugs, related_committee_ids, notes
73 rows
member_votes
congress, chamber, session, roll_call_number, bioguide_id, member_name, party, state, vote_cast
Many rows
nominations
id, congress, number, part_number, citation, description, organization, received_date, authority_date, is_civilian, is_military, status, vote_yea, vote_nay
40,184 rows
oge_pas_filings
filing_id, filer_slug, filer_last, filer_first, filer_name_full, person_name_normalized, department, position, doc_type, filing_date, filing_date_iso, page_count, file_size, original_filename, public_actor_id, parse_status
799 rows
oge_pas_transactions
transaction_id, filer_slug, filer_last, filer_first, person_name_normalized, department, position, filing_date, tx_number, asset_description, asset_name, asset_class, ticker, tx_type, tx_date, tx_date_iso, notification_over_30d, amount_range, amount_min, amount_max, source_filename, public_actor_id
3,248 rows
oira_meeting_attendees
meeting_id, attendee_name, attendee_org, participation_type, is_government
90,711 rows
oira_meetings
meeting_id, rin, title, agency_acronym, rule_stage, meeting_date, requestor_org, requestor_name, meeting_type, type_cd, source
8,663 rows
oira_reviews
rin, agency_code, title, stage, economically_significant, date_received, date_completed, decision, date_published, major
48,434 rows
presidential_documents
document_number, title, document_type, executive_order_number, signing_date, publication_date, html_url, abstract
5,926 rows
public_actors
public_actor_id, role_context, source_id, name_full, name_normalized, name_first, name_last, bioguide_id, fec_cand_id, fara_registration_number, oge_filer_slug, sec_reporter_cik, employer_entity_id, employer_entity_name, employer_ein, employer_cik, employer_lda_registrant_id, role_title, role_start_date, role_end_date, is_current, materiality_tier, materiality_reason, merged_into_public_actor_id, merge_method, merge_confidence, first_seen_date, last_seen_date, source_table, created_at, updated_at, notes, dd_id
Many rows
revolving_door
bioguide_id, full_name, party, state, congress_chamber, lobbying_filing_count, client_count, firm_count, first_lobbying_year, last_lobbying_year, total_reported_income, lobbying_firms, covered_position_sample
181 rows
roll_call_votes
congress, chamber, session, roll_call_number, date, question, vote_type, description, result, bill_id, legislation_type, legislation_number, yea_count, nay_count, present_count, not_voting_count, source_url
26,472 rows
senate_office_totals
id, report_id, congress_num, session_num, report_seq, report_period, office_name, office_party, line_category, net_funds, net_expenditures, total_funding, source_pdf
25,606 rows
speaker_activity
speaker_name, bioguide_id, official_name, party, state, total_speeches, active_days, first_appearance, last_appearance, chambers, congresses_active
2,118 rows
speeches_near_trades
full_name, party, state, bioguide_id, trade_date, ticker, asset_description, transaction_type, amount_range, speech_date, speech_title, days_apart
77,666 rows
spending_awards
generated_internal_id, award_id, agency, sub_agency, award_category, award_type, recipient_name, recipient_name_normalized, recipient_uei, recipient_duns, recipient_id, recipient_location_state, award_amount, total_outlays, description, start_date, end_date, fiscal_year, state_code, cfda_number, naics_code, naics_description
903,135 rows
spending_by_agency
agency, sub_agency, award_category, award_count, total_amount, avg_amount, earliest, latest
111 rows
stock_trades
id, member_name, bioguide_id, chamber, transaction_date, disclosure_date, ticker, cik, asset_description, asset_type, transaction_type, amount_range, owner, comment, source_url, filing_type, state_district, doc_id
61,928 rows
stock_trades_by_ticker
ticker, asset_description, trade_count, trader_count, traders, purchases, sales, first_trade, last_trade
3,979 rows
top_dockets
docket_id, agency_id, docket_title, docket_type, comment_count, unique_submitters, org_comments, individual_comments, anonymous_comments, first_comment, last_comment
38,622 rows
top_lobbying_clients
client_name, filing_count, firms_hired, issue_areas, total_reported_income, first_year, last_year, issue_codes
70,652 rows
top_submitters
submitter_name, submitter_type, comment_count, agencies_commented, dockets_commented, first_comment, last_comment, agency_list
5,407 rows
treaties
id, congress, number, title, topic, transmitted_date, in_force_date, countries, index_terms, resolution_text
777 rows
uei_registry
uei, canonical_name, canonical_name_normalized, state, n_awards, total_amount, first_fiscal_year, last_fiscal_year, match_method, matched_entity_id, matched_gov_unit_id, created_at
97,796 rows
wh_visits
visit_id, admin, appt_start, appt_end, appt_made, visitor_name_full, visitor_name_hash, visitor_is_tour, visitee_name_last, visitee_name_first, visitee_full, visitee_public_actor_id, meeting_loc, meeting_room, description, total_people, access_type, post, source_file, uin, visitor_public_actor_id, visitor_is_lda_lobbyist, visitor_match_confidence, appt_start_iso
Many rows
wh_visits_daily_agg
admin, visit_date, visitee_name_last, visitee_name_first, n_visits, n_unique_visitors, n_tour_visits, total_people
421,928 rows
witness_lobby_overlap
organization, hearings_testified, lobby_filings, total_lobby_income, first_hearing, last_hearing, lobby_issues
4,040 rows
... and 131 hidden tables