Puerto Rico Media: mediacloud_states.csv

Table actions

This table 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.csv contains 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.csv contains 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.

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette

51 rows

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ Date Texas "Puerto Rico" Florida
1 1 8/20/17 295 32 239
2 2 8/21/17 998 24 527
3 3 8/22/17 696 32 577
4 4 8/23/17 1130 36 596
5 5 8/24/17 1851 135 933
6 6 8/25/17 2693 39 533
7 7 8/26/17 1953 15 199
8 8 8/27/17 2962 11 211
9 9 8/28/17 5072 42 569
10 10 8/29/17 5013 14 508
11 11 8/30/17 4436 42 589
12 12 8/31/17 3935 40 553
13 13 9/1/17 2746 18 651
14 14 9/2/17 1919 15 569
15 15 9/3/17 1435 50 528
16 16 9/4/17 1522 224 584
17 17 9/5/17 2114 500 1580
18 18 9/6/17 1728 938 2781
19 19 9/7/17 1607 635 3056
20 20 9/8/17 1384 227 3434
21 21 9/9/17 814 121 2974
22 22 9/10/17 724 154 4003
23 23 9/11/17 1226 151 3760
24 24 9/12/17 1224 143 2525
25 25 9/13/17 1067 73 2004
26 26 9/14/17 1007 127 1781
27 27 9/15/17 1122 56 1087
28 28 9/16/17 554 36 703
29 29 9/17/17 522 125 542
30 30 9/18/17 725 485 700
31 31 9/19/17 983 908 912
32 32 9/20/17 866 1461 700
33 33 9/21/17 799 1415 620
34 34 9/22/17 1070 1270 577
35 35 9/23/17 844 665 541
36 36 9/24/17 411 674 360
37 37 9/25/17 812 1562 518
38 38 9/26/17 1295 2577 832
39 39 9/27/17 924 2107 728
40 40 9/28/17 863 2177 675
41 41 9/29/17 949 2202 559
42 42 9/30/17 504 1593 491
43 43 10/1/17 604 1394 621
44 44 10/2/17 839 1026 684
45 45 10/3/17 891 2217 746
46 46 10/4/17 779 1492 635
47 47 10/5/17 907 824 722
48 48 10/6/17 758 1252 695
49 49 10/7/17 411 352 466
50 50 10/8/17 400 317 395
51 51 10/9/17 828 580 427

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "puerto-rico-media/mediacloud_states" (
"Date" TEXT,
  "Texas" INTEGER,
  """Puerto Rico""" INTEGER,
  "Florida" INTEGER
);