Press releases

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

206 rows where party = "Democrat", state = "CA" and year = 2009 sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Next page

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]);