Trump News: trump_news_data.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
286 rows sorted by detail
This data as json, copyable, CSV (advanced)
Suggested facets: major_category
Link | rowid | date | major_category | detail ▼ |
---|---|---|---|---|
1 | 1 | 6/16/15 | Noncampaign | |
3 | 3 | 6/18/15 | Noncampaign | |
4 | 4 | 6/19/15 | Noncampaign | |
5 | 5 | 6/20/15 | Noncampaign | |
6 | 6 | 6/21/15 | Noncampaign | |
7 | 7 | 6/22/15 | Noncampaign | |
8 | 8 | 6/23/15 | Noncampaign | |
9 | 9 | 6/24/15 | Noncampaign | |
10 | 10 | 6/25/15 | Noncampaign | |
11 | 11 | 6/26/15 | Noncampaign | |
12 | 12 | 6/27/15 | Noncampaign | |
13 | 13 | 6/28/15 | Noncampaign | |
14 | 14 | 6/29/15 | Noncampaign | |
15 | 15 | 6/30/15 | Noncampaign | |
18 | 18 | 7/3/15 | Noncampaign | |
19 | 19 | 7/4/15 | Noncampaign | |
21 | 21 | 7/6/15 | Noncampaign | |
22 | 22 | 7/7/15 | Noncampaign | |
26 | 26 | 7/11/15 | Noncampaign | |
29 | 29 | 7/14/15 | Noncampaign | |
32 | 32 | 7/17/15 | Noncampaign | |
33 | 33 | 7/18/15 | Noncampaign | |
37 | 37 | 7/22/15 | Noncampaign | |
61 | 61 | 8/15/15 | Noncampaign | |
62 | 62 | 8/16/15 | Noncampaign | |
63 | 63 | 8/17/15 | Noncampaign | |
68 | 68 | 8/22/15 | Noncampaign | |
70 | 70 | 8/24/15 | Noncampaign | |
72 | 72 | 8/26/15 | Noncampaign | |
73 | 73 | 8/27/15 | Noncampaign | |
83 | 83 | 9/6/15 | Noncampaign | |
85 | 85 | 9/8/15 | Noncampaign | |
89 | 89 | 9/12/15 | Noncampaign | |
91 | 91 | 9/14/15 | Noncampaign | |
93 | 93 | 9/16/15 | Noncampaign | |
101 | 101 | 9/24/15 | Noncampaign | |
102 | 102 | 9/25/15 | Noncampaign | |
103 | 103 | 9/26/15 | Noncampaign | |
105 | 105 | 9/28/15 | Noncampaign | |
106 | 106 | 9/29/15 | Noncampaign | |
107 | 107 | 9/30/15 | Noncampaign | |
108 | 108 | 10/1/15 | Noncampaign | |
109 | 109 | 10/2/15 | Noncampaign | |
111 | 111 | 10/4/15 | Noncampaign | |
112 | 112 | 10/5/15 | Noncampaign | |
113 | 113 | 10/6/15 | Noncampaign | |
116 | 116 | 10/9/15 | Noncampaign | |
117 | 117 | 10/10/15 | Noncampaign | |
125 | 125 | 10/18/15 | Noncampaign | |
126 | 126 | 10/19/15 | Noncampaign | |
129 | 129 | 10/22/15 | Noncampaign | |
130 | 130 | 10/23/15 | Noncampaign | |
152 | 152 | 11/14/15 | Noncampaign | |
154 | 154 | 11/16/15 | Noncampaign | |
155 | 155 | 11/17/15 | Noncampaign | |
156 | 156 | 11/18/15 | Noncampaign | |
158 | 158 | 11/20/15 | Noncampaign | |
162 | 162 | 11/24/15 | Noncampaign | |
163 | 163 | 11/25/15 | Noncampaign | |
164 | 164 | 11/26/15 | Noncampaign | |
165 | 165 | 11/27/15 | Noncampaign | |
166 | 166 | 11/28/15 | Noncampaign | |
167 | 167 | 11/29/15 | Noncampaign | |
171 | 171 | 12/3/15 | Noncampaign | |
172 | 172 | 12/4/15 | Noncampaign | |
173 | 173 | 12/5/15 | Noncampaign | |
174 | 174 | 12/6/15 | Noncampaign | |
175 | 175 | 12/7/15 | Noncampaign | |
183 | 183 | 12/15/15 | Noncampaign | |
185 | 185 | 12/17/15 | Noncampaign | |
192 | 192 | 12/24/15 | Noncampaign | |
193 | 193 | 12/25/15 | Noncampaign | |
194 | 194 | 12/26/15 | Noncampaign | |
198 | 198 | 12/30/15 | Noncampaign | |
200 | 200 | 1/1/16 | Noncampaign | |
202 | 202 | 1/3/16 | Noncampaign | |
204 | 204 | 1/5/16 | Noncampaign | |
205 | 205 | 1/6/16 | Noncampaign | |
209 | 209 | 1/10/16 | Noncampaign | |
213 | 213 | 1/14/16 | Noncampaign | |
226 | 226 | 1/27/16 | Noncampaign | |
244 | 244 | 2/14/16 | Noncampaign | |
245 | 245 | 2/15/16 | Noncampaign | |
246 | 246 | 2/16/16 | Noncampaign | |
252 | 252 | 2/22/16 | Noncampaign | |
277 | 277 | 3/18/16 | Noncampaign | |
281 | 281 | 3/22/16 | Noncampaign | |
96 | 96 | 9/19/15 | Trump - other | "Birther" controversy |
236 | 236 | 2/6/16 | Trump - comments | "Go f---" themselves" comments |
250 | 250 | 2/20/16 | Trump - comments | "Pigs blood" comments |
190 | 190 | 12/22/15 | Trump - comments | "Schlonged" comments |
201 | 201 | 1/2/16 | Trump - other | Anti-Trump Rose Parade skywriting |
69 | 69 | 8/23/15 | Dem. campaign | Biden |
71 | 71 | 8/25/15 | Dem. campaign | Biden |
100 | 100 | 9/23/15 | Dem. campaign | Biden |
114 | 114 | 10/7/15 | Dem. campaign | Biden |
110 | 110 | 10/3/15 | GOP campaign | Bush |
118 | 118 | 10/11/15 | GOP campaign | Bush |
124 | 124 | 10/17/15 | GOP campaign | Bush |
207 | 207 | 1/8/16 | GOP campaign | Bush |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "trump-news/trump_news_data" ( "date" TEXT, "major_category" TEXT, "detail" TEXT );