home / press

Menu
  • Search all tables

Press releases

One row per release. Full-text search runs over title + body text.

Data license: MIT · Data source: dwillis/congress-press

url
Link to the original release on the member's official site
text
Extracted body text (may be empty if the page could not be fetched)
has_text
1 if body text was successfully extracted
date_source
How the publication date was determined
bioguide_id
Bioguide ID of the member

1 row where party = "Democrat", state = "KY" and year = 2022 sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

year 1

  • 2022 · 1 ✖

state 1

  • KY · 1 ✖

party 1

  • Democrat · 1 ✖

chamber 1

  • House 1
url title date ▲ year month party chamber state member_name bioguide_id domain scraper source date_source text has_text collected_at updated_at
https://mcgarvey.house.gov/media/press-releases/test-press Test Press 2022-04-01 2022 2022-04 Democrat House KY Morgan McGarvey M001220 mcgarvey.house.gov mcgarvey https://mcgarvey.house.gov/media/press-releases scraper Test Press Lorem ipsum dolor sit amet, consectetur adipiscing elit. In nisl tellus, imperdiet a vestibulum ut, aliquam eu dui. Aliquam erat volutpat. Nulla nec orci congue, iaculis lectus a, laoreet turpis. Cras pulvinar eros ante, a pulvinar dolor hendrerit nec. In quis dictum enim, eget lacinia felis. Vivamus ut justo bibendum, commodo nisi sit amet, pulvinar sapien. Aenean rutrum sodales ligula, eu scelerisque tellus. Integer id gravida nunc, a varius odio. Etiam ornare semper lorem, id tincidunt metus. Sed aliquet sed ipsum et gravida. Morbi in nulla bibendum, ornare mauris nec, aliquam sem. Nunc non aliquam dui. Suspendisse pellentesque a urna vitae placerat. Maecenas iaculis hendrerit ex, quis pretium sem vestibulum ut. 1 2026-03-30T01:40:41Z 2026-04-08T02:19:30Z

Advanced export

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

CSV options:

CREATE TABLE [releases] (
   [url] TEXT PRIMARY KEY,
   [title] TEXT,
   [date] TEXT,
   [year] TEXT,
   [month] TEXT,
   [party] TEXT,
   [chamber] TEXT,
   [state] TEXT,
   [member_name] TEXT,
   [bioguide_id] TEXT,
   [domain] TEXT,
   [scraper] TEXT,
   [source] TEXT,
   [date_source] TEXT,
   [text] TEXT,
   [has_text] INTEGER,
   [collected_at] TEXT,
   [updated_at] TEXT
);
CREATE INDEX [idx_releases_date]
    ON [releases] ([date]);
CREATE INDEX [idx_releases_year]
    ON [releases] ([year]);
CREATE INDEX [idx_releases_party]
    ON [releases] ([party]);
CREATE INDEX [idx_releases_chamber]
    ON [releases] ([chamber]);
CREATE INDEX [idx_releases_state]
    ON [releases] ([state]);
CREATE INDEX [idx_releases_bioguide_id]
    ON [releases] ([bioguide_id]);
CREATE INDEX [idx_releases_has_text]
    ON [releases] ([has_text]);
Powered by Datasette · Queries took 169.203ms · Data license: MIT · Data source: dwillis/congress-press