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 = "Republican", state = "MT" and year = 2022 sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

year 1

  • 2022 · 1 ✖

state 1

  • MT · 1 ✖

party 1

  • Republican · 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://zinke.house.gov/media/press-releases/official-portrait-congressman-elect-zinke Official portrait of Congressman-elect Zinke 2022-12-22 2022 2022-12 Republican House MT Ryan K. Zinke Z000018 zinke.house.gov zinke https://zinke.house.gov/media/press-releases scraper (WASHINGTON, DC) Today the office of Congressman-elect Ryan Zinke released Zinke’s official portrait available for public and media use (below and attached). He will be sworn in as a Member of the House of Representatives on January 3, 2023. Committee assignments will be made in mid-January. Ryan Zinke was elected on November 7th to represent Montana’s First Congressional District (MT-01). Ryan Zinke has dedicated his life and career in service of Montana. Prior to serving as western Montana’s Congressman, Zinke served as U.S. Secretary of the Interior (2017-2019), Montana’s at-large Member of Congress (2015-2017), Montana State Senator (2009-2013) and 23 years as a U.S. Navy SEAL officer (1985-2008). Ryan and his wife Lola have three adult children and two granddaughters. A fifth generation and lifelong Montanan, Zinke lives in his boyhood hometown, Whitefish, on the same property his grandparents bought in the 1950s. 1 2026-03-30T01:40:41Z 2026-04-08T03:32:05Z

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 81.623ms · Data license: MIT · Data source: dwillis/congress-press