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

2 rows where party = "Republican", state = "NM" and year = 2015 sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

year 1

  • 2015 · 2 ✖

state 1

  • NM · 2 ✖

party 1

  • Republican · 2 ✖

chamber 1

  • House 2
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/event/mobile-office-hours-fort-sumner Mobile Office Hours - Fort Sumner 2015-03-24 2015 2015-03 Republican House NM Steve Pearce P000588 pearce.house.gov     legacy My staff will hold mobile office hours in Fort Sumner this week! When: Wednesday, March 24, 2015from 2:00-4:00 pm Where: City Hall, 173 East Avenue C, Fort Sumner, NM. Contact Bernadette Granger at 855-4-PEARCE to schedule an appointment 1 2026-03-30T12:14:52Z 2026-03-30T12:14:52Z
http://pearce.house.gov/event/carlsbad-staff-office-hours-18 Carlsbad: Staff Office Hours 2015-01-05 2015 2015-01 Republican House NM Steve Pearce P000588 pearce.house.gov     legacy I will have staff in Carlsbad on Thursday, January 8th to answer questions, discuss any ideas or concerns you might have, or assist you with casework or issue related to a federal agency. For details to set up an appointment, Please contact my office at 1-855-4-PEARCE. February 5th, 2014 Carlsbad, NM - Every 1st Thursday of the month 2:00pm - 4:00pm Eddy County Administration Building, Suite 110 101 W. Greene Street Carlsbad, NM 88220 Phone: 575-887-9511 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 196.354ms · Data license: MIT · Data source: dwillis/congress-press