home / openregs

hearings

Committee hearing transcripts from GovInfo (1993–present). Includes committee info, witness testimony, and member attendance.

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

chamber
HOUSE, SENATE, or JOINT.
congress
Congress number (e.g., 118 for 2023–2024).
committees
JSON array of committee names and hierarchies.

2 rows where chamber = "House" sorted by date_issued descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date_issued (date)

congress 2

  • 105 1
  • 110 1

chamber 1

  • House · 2 ✖
package_id title chamber congress session date_issued ▲ committees detail_url html_url pdf_url
GPO-CHRG-110jhrg46860 LESSONS LEARNED: ENSURING THE DELIVERY OF DONATED GOODS TO SURVIVORS OF CATASTROPHES House 110 2 2008-07-31   https://www.govinfo.gov/app/details/GPO-CHRG-110jhrg46860 https://www.govinfo.gov/content/pkg/GPO-CHRG-110jhrg46860/html/GPO-CHRG-110jhrg46860.htm https://www.govinfo.gov/content/pkg/GPO-CHRG-110jhrg46860/pdf/GPO-CHRG-110jhrg46860.pdf
GPO-CHRG-105jhrg41800 SUCCESSES IN URBAN PROBLEM-SOLVING, MAYORAL PERSPECTIVES House 105 1 1997-03-11   https://www.govinfo.gov/app/details/GPO-CHRG-105jhrg41800 https://www.govinfo.gov/content/pkg/GPO-CHRG-105jhrg41800/html/GPO-CHRG-105jhrg41800.htm https://www.govinfo.gov/content/pkg/GPO-CHRG-105jhrg41800/pdf/GPO-CHRG-105jhrg41800.pdf

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE hearings (
    package_id TEXT PRIMARY KEY,
    title TEXT,
    chamber TEXT,
    congress INTEGER,
    session TEXT,
    date_issued TEXT,
    committees TEXT,
    detail_url TEXT,
    html_url TEXT,
    pdf_url TEXT
);
CREATE INDEX idx_hear_chamber ON hearings(chamber);
CREATE INDEX idx_hear_congress ON hearings(congress);
CREATE INDEX idx_hear_date ON hearings(date_issued);
Powered by Datasette · Queries took 21.153ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API