Explore the Data

Search

Search Comments (Full Text)
Search comment titles and submitter names using full-text search. Use standard search syntax: quotes…
Search Federal Register
Full-text search across Federal Register document titles, abstracts, and agency names.
Search Dockets
Full-text search across docket titles. Find regulatory proceedings by keyword.
Search Regulatory Documents
Full-text search across regulatory document titles from Regulations.gov.
Search Executive Orders & Proclamations
Search presidential documents by keyword in title or abstract.
Look Up Executive Order by Number
Find a specific Executive Order by its number (e.g., 14110).
Search Spending Awards
Search grants and contracts by description keyword.
Search Legislation
Search bills and resolutions by keyword in title or summary.
Search Federal Regulations (eCFR)
Full-text search across the Code of Federal Regulations. Find what the actual regulations say about …
Search Congressional Record
Full-text search across everything said on the floor of Congress. Speeches, debates, procedural acti…
Search Congress Members
Find current or historical members of Congress by name.
Explore: Member Search
Search Congress members by name with stock trade, speech, and bill counts.

Public Comments & Dockets

Most Commented Dockets
Dockets with the most public comments, showing comment volume and submitter breakdown.
Currently Open for Comment
Regulatory documents with comment periods that haven't closed yet. These are opportunities for publi…
Comment Volume by Year & Agency
Annual comment volume for each agency, with breakdown by submitter type.
Most Active Organizational Commenters
Organizations that submit the most public comments across all agencies.
Comments for a Docket
View all comments submitted for a specific docket ID (e.g., EPA-HQ-OAR-2021-0317).
Dockets for an Agency
Browse all dockets for a specific agency code (e.g., EPA, FDA, FWS, USDA) with comment counts.
Comment Period Durations
How long agencies give the public to comment, by agency and document type.
Monthly Comment Activity
Comment volume by month across all agencies, useful for spotting surges in public engagement.
Comments by a Specific Submitter
See all comments from a specific organization or individual across all dockets.
Explore: Docket Detail
Docket information with document and comment counts.
Explore: Docket Documents
Documents in a specific regulatory docket ordered by date.
Explore: Docket Comment Stats
Comment statistics for a docket grouped by submitter type.
Explore: Open Comment Periods
Documents currently open for public comment, ordered by closing date.

Executive Orders & Proclamations

Executive Orders
All Executive Orders from 1994 to present, with EO numbers and signing dates.
Recent Executive Orders
The 50 most recently signed Executive Orders.
Presidential Documents by Year
Count of Executive Orders and Proclamations signed each year.
Presidential Proclamations
All Presidential Proclamations, most recent first.

Federal Register

Rulemaking Pipeline (Proposed → Final)
Dockets that have both proposed rules and final rules, showing the regulatory timeline.
Federal Register Documents by Agency
Search Federal Register documents by agency name and optional year.
Recently Published Rules
The most recently published final rules in the Federal Register.
Recently Proposed Rules
Proposed rules awaiting public comment or finalization, ordered by publication date.
Federal Register Activity by Year
Count of Federal Register documents by type and year, showing regulatory activity trends over three …
Regulations by Agency
Browse CFR sections by agency (EPA, FDA, APHIS, FWS, FSIS, NOAA).
CFR Parts Overview
List all parts (regulatory chapters) in each CFR title, with section counts.
Read a CFR Section
View the full text of a specific CFR section (e.g., '1.1' or '50.11').

Analysis & Trends

Federal Register ↔ Regulations.gov Lookup
Find the Regulations.gov documents linked to a Federal Register document number, or vice versa.
Federal Spending by Agency
Total grants and contracts by agency and fiscal year from USAspending.gov.
Top Grant Recipients
Organizations receiving the most federal grant money from our tracked agencies.
Top Contractors
Companies receiving the most federal contract money from our tracked agencies.
Federal Spending by State
Total awards by state of performance for our tracked agencies.
Legislation by Policy Area
Browse bills filtered by CRS policy area (e.g., Environmental Protection, Health, Agriculture and Fo…
Recently Introduced Legislation
The most recently introduced bills in our tracked policy areas.
Legislation by Sponsor
Bills sponsored by a specific member of Congress.
Most Cosponsored Bills
Bills with the most cosponsors, indicating broad congressional support.
Top Legislative Subjects
Most common CRS subject terms across all tracked legislation.
Congressional Record by Date
View everything said on the floor of Congress on a specific date (YYYY-MM-DD).
Floor Speeches by Topic
Search House and Senate floor speeches (excludes Daily Digest and procedural items).
Congressional Record by Congress
Volume of floor activity per Congress — speeches, proceedings, and extensions of remarks.
Floor Speeches by Member of Congress
All floor speeches and remarks by a specific member of Congress. Enter a last name (e.g., 'McConnell…
Most Active Speakers in Congress
Members of Congress with the most floor speeches, filtered by Congress number (e.g., 118 for 2023-20…
Bills Discussed on the Floor
Bills referenced in Congressional Record floor proceedings, showing how many times each was discusse…
Floor Debate for a Specific Bill
All Congressional Record entries referencing a specific bill. Enter bill_id format: congress-type-nu…
Member Profile: Trades, Speeches, Bills
Complete profile for a member of Congress — their stock trades, floor speeches, and sponsored bills.…
Stock Trades for a Member
All stock trading disclosures for a specific member. Enter a name (e.g., 'Pelosi') or bioguide_id.
Most Active Congressional Traders
Members of Congress with the most stock trading disclosures.
Most Traded Stocks by Congress
Stocks most frequently bought or sold by members of Congress (both chambers).
Who Traded a Specific Stock?
Find all members who traded a specific stock by ticker symbol (e.g., AAPL, MSFT).
Member Activity Timeline
See a member's stock trades alongside their floor speeches. Enter bioguide_id.
Current Members of Congress Overview
All current members with their trade count, speech count, and bills sponsored.
Committee Members
View all members of a specific committee. Enter a committee ID (e.g., SSEV for Senate Environment, H…
Committees for a Member
See all committee assignments for a specific member. Enter bioguide_id.
Committee Leadership
Chairs and ranking members of all committees.
Stock Trades by Committee Members
All stock trades by members of a specific committee. Enter committee ID.
Cosponsors for a Bill
View all cosponsors for a specific bill. Enter bill_id format: congress-type-number (e.g., '118-hr-3…
Most Prolific Cosponsors
Members who cosponsor the most bills in our tracked policy areas.
Bipartisan Bills (Cross-Party Cosponsorship)
Bills that have cosponsors from both parties, indicating bipartisan support.
Federal Spending by Sub-Agency
Total grants and contracts broken down by sub-agency within each parent agency, with award counts an…
Spending Trends Over Time
Federal spending by fiscal year and agency, showing how grant and contract funding changes year to y…
Explore: Member Profile
Full member profile by bioguide_id with activity counts.
Explore: Member Stock Trades
Stock trades for a specific Congress member ordered by date.
Explore: Member Floor Speeches
Congressional Record floor speeches for a specific member.
Explore: Member Legislation
Legislation sponsored by a specific Congress member.
Explore: Lobbying Client Search
Search lobbying clients by name with total spending and firm counts.
Explore: Client Lobbying Activity
Lobbying activity records for a specific client.
Explore: Client Lobbyists
Lobbyists working for a specific client, including covered government positions.
Explore: Lobbying Issue Areas
All lobbying issue areas with filing counts and client counts.
Explore: Revolving Door
Lobbyists with prior government positions (covered positions) and their current clients.

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

build_metadata

key, value

1 row

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,480 rows

comment_details

id, comment_text, organization, 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

41,807 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, lis_id, wikipedia_id, ballotpedia_id, birthday, gender, terms_count, served_until, trade_count, speech_count, bills_sponsored, vote_count, fec_total_received

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

docket_summary

docket_id, summary

26,195 rows

dockets

id, agency_id, title, docket_type, last_modified, object_id

86,706 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

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,627 rows

fara_registrant_docs

rowid, registration_number, registrant_name, date_stamped, document_type, short_form_name, foreign_principal_name, foreign_principal_country, url

151,348 rows

fara_registrants

registration_number, registration_date, termination_date, name, business_name, address_1, address_2, city, state, zip

7,035 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,363 rows

fec_candidate_crosswalk

fec_candidate_id, bioguide_id, full_name, party, state, chamber

1,711 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_contributions

cmte_id, cmte_name, cand_id, cand_name, transaction_dt, transaction_amt, entity_tp, state, employer, occupation, cycle

Many rows

fec_employer_to_candidate

employer, cand_id, bioguide_id, cand_name, party, office, state, cycle, donation_count, total_amount

Many rows

fec_employer_to_party

employer, party, cycle, donation_count, total_amount, candidate_count

Many rows

fec_employer_totals

employer, donation_count, total_amount, avg_amount, unique_states, min_cycle, max_cycle

Many rows

fec_top_occupations

employer, occupation, donation_count, total_amount

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

70,030 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

167,507 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

34 rows

legislation_sponsor_summary

sponsor_name, sponsor_party, sponsor_state, sponsor_bioguide_id, bill_count

1,437 rows

legislation_subjects

bill_id, subject

Many rows

lis_to_bioguide

lis_id, bioguide_id

326 rows

lobbying_activities

id, filing_uuid, filing_type, registrant_name, client_name, filing_year, filing_period, issue_code, specific_issues, government_entities, income_amount, expense_amount, is_no_activity, is_termination, received_date

Many 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

0 rows

lobbying_filings

filing_uuid, filing_type, registrant_id, registrant_name, client_id, client_name, filing_year, filing_period, received_date, amount_reported, is_amendment, is_no_activity, is_termination

Many rows

lobbying_issue_codes

code, description

79 rows

lobbying_issue_summary

issue_code, description, filing_count, client_count, total_income

80 rows

lobbying_lobbyists

id, filing_uuid, lobbyist_name, covered_position, is_new

Many rows

member_votes

congress, chamber, session, roll_call_number, bioguide_id, member_name, party, state, vote_cast

Many rows

presidential_documents

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

5,904 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,359 rows

spending_agency_summary

name, award_count, total_spending, sub_count

15 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

95,621 rows

... and 61 hidden tables

Views