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.

1 row where chamber = "House" and congress = 105 sorted by date_issued descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date_issued (date)

congress 1

  • 105 · 1 ✖

chamber 1

  • House · 1 ✖
package_id title chamber congress session date_issued ▲ committees detail_url html_url pdf_url
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 188.202ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API