API Access
Access dataset files directly from scripts, code, or AI agents.
Browse dataset files
API Access
Access dataset files directly from scripts, code, or AI agents.
Each file has a stable URL (r-link) that you can use directly in scripts, apps, or AI agents. These URLs are permanent and safe to hardcode.
Start with these files — they give you everything you need to understand and access the dataset.
- 1. Fetch datapackage.json to inspect schema and resources
- 2. Download data resources listed in datapackage.json
- 3. Read README.md for full context
Data Files
Explore with AIgoogle_trends
| Field | Type | Format |
|---|---|---|
| day | date | default |
| hurricane harvey: (united states) | integer | default |
| hurricane irma: (united states) | integer | default |
| hurricane maria: (united states) | integer | default |
| hurricane jose: (united states) | integer | default |
Download
Download CSVAbout
- Last updated
- 12 March 2026
- Total rows
- ...
- Format
- CSV
- File size
- 864 B
mediacloud_hurricanes
| Field | Type | Format |
|---|---|---|
| date | string | default |
| harvey | integer | default |
| irma | integer | default |
| maria | integer | default |
| jose | integer | default |
Download
Download CSVAbout
- Last updated
- 12 March 2026
- Total rows
- ...
- Format
- CSV
- File size
- 771 B
mediacloud_states
| Field | Type | Format |
|---|---|---|
| date | string | default |
| texas | integer | default |
| puerto rico | integer | default |
| florida | integer | default |
Download
Download CSVAbout
- Last updated
- 12 March 2026
- Total rows
- ...
- Format
- CSV
- File size
- 1.07 kB
mediacloud_top_online_news
| Field | Type | Format |
|---|---|---|
| name | string | default |
| url | string | default |
Download
Download CSVAbout
- Last updated
- 12 March 2026
- Total rows
- ...
- Format
- CSV
- File size
- 1.71 kB
mediacloud_trump
| Field | Type | Format |
|---|---|---|
| date | date | default |
| title:puerto rico | integer | default |
| title:puerto rico and (title:trump or title:president) | integer | default |
| title:florida | integer | default |
| title:florida and (title:trump or title:president) | integer | default |
| title:texas | integer | default |
| title:texas and (title:trump or title:president) | integer | default |
Download
Download CSVAbout
- Last updated
- 12 March 2026
- Total rows
- ...
- Format
- CSV
- File size
- 1.57 kB
About this dataset
Puerto Rico Media
This folder contains data behind the stories:
- The Media Really Has Neglected Puerto Rico
- The Media Really Started Paying Attention To Puerto Rico When Trump Did
Online News Data
Data about Online News was collected using the Media Cloud dashboard, an open source suite of tools for analyzing a database of online news.
mediacloud_hurricanes.csvcontains the number of sentences per day that mention Hurricanes Harvey, Irma, Jose, and Maria in online news.mediacloud_states.csv(Updated through 10/10/2017) contains the number of sentences per day that mention Puerto Rico, Texas, and Florida in online news.mediacloud_trump.csv(Updated through 10/10/2017) contains the number of headlines that mention Puerto Rico, Texas, and Florida, as well as headlines that mention those three locations along with 'President' or 'Trump'.mediacloud_top_online_news.csvcontains a list of sources included in Media Cloud's U.S. Top Online News collection.
TV News Data
TV News Data was collected from the Internet TV News Archive using the Television Explorer tool.
tv_hurricanes.csv- contains the percent of sentences per day in TV News that mention Hurricanes Harvey, Irma, Jose, and Maria.tv_hurricanes_by_network.csv- contains the percent of sentences per day in TV News per network that mention Hurricanes Harvey, Irma, Jose, and Maria.tv_states.csv(Updated through 10/10/2017) - contains the percent of sentences per day in TV News that mention Puerto Rico, Texas, and Florida.
Google Search Queries
Google search data was collected using the Google Trends dashboard.
google_trends.csv- Contains data on google trend searches for Hurricanes Harvey, Irma, Jose, and Maria.
This dataset was scraped from FiveThirtyEight - puerto-rico-media