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 = "NM" and year = 2016 sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

year 1

  • 2016 · 1 ✖

state 1

  • NM · 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
http://pearce.house.gov/video/2016-post-state-union-response 2016 Post State of the Union Response 2016-01-12 2016 2016-01 Republican House NM Steve Pearce P000588 pearce.house.gov     legacy The President demonstrated how out-of-touch he is with the American people. When he risks our national security or damages our health care system that hurts American jobs, he calls it an accomplishment. He cannot implement his policies without increasing taxes. Instead of helping Americans, he has put their jobs, economy, and way of life at risk. All of us are looking for a government that is effective, efficient, and accountable to the people. This country stands as a symbol, a destination where generations came looking for a better life. We must renew this promise to the American people. Looking forward, we have an opportunity in 2016 to drive bold ideas that redesign our government and will define a newer, bolder vision for America. A vision that that lowers taxes, makes America energy independent, brings manufacturing jobs back to our shores, and upholds the Constitution. It is time we put the American people back in charge of their own lives 1 2026-03-30T12:14:52Z 2026-03-30T12:14:52Z

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