home / fivethirtyeight

Puerto Rico Media: mediacloud_states.csv

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.

TV News Data

TV News Data was collected from the Internet TV News Archive using the Television Explorer tool.

Google Search Queries

Google search data was collected using the Google Trends dashboard.

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub

51 rows

View and edit SQL

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

Advanced export

JSON shape: default, array

CSV options:

CREATE TABLE "puerto-rico-media/mediacloud_states" (
"Date" TEXT,
  "Texas" INTEGER,
  """Puerto Rico""" INTEGER,
  "Florida" INTEGER
)
Powered by Datasette · Query took 83.894ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub