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
1 row where party = "Democrat", state = "KS" and year = 2021 sorted by date descending
This data as json, CSV (advanced)
| 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://davids.house.gov/media/press-releases/rep-sharice-davids-releases-recap-first-term-congress-0 | Rep. Sharice Davids Releases Recap of First Term in Congress | 2021-01-03 | 2021 | 2021-01 | Democrat | House | KS | Sharice Davids | D000629 | davids.house.gov | legacy | Davids marks first term with a focus on constituent services, bipartisan legislating, and creating opportunities for all Kansans | 1 | 2026-03-30T12:14:52Z | 2026-03-30T12:14:52Z |
Advanced export
JSON shape: default, array, newline-delimited, object
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]);