ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 29019 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
384220 | 384220 | 2020-07-30 | Boone | Missouri | 29019 | 1146 | 3 |
381004 | 381004 | 2020-07-29 | Boone | Missouri | 29019 | 1118 | 3 |
377787 | 377787 | 2020-07-28 | Boone | Missouri | 29019 | 1090 | 3 |
374572 | 374572 | 2020-07-27 | Boone | Missouri | 29019 | 1061 | 3 |
371360 | 371360 | 2020-07-26 | Boone | Missouri | 29019 | 1051 | 3 |
368149 | 368149 | 2020-07-25 | Boone | Missouri | 29019 | 1039 | 3 |
364941 | 364941 | 2020-07-24 | Boone | Missouri | 29019 | 1003 | 3 |
361734 | 361734 | 2020-07-23 | Boone | Missouri | 29019 | 978 | 3 |
358529 | 358529 | 2020-07-22 | Boone | Missouri | 29019 | 953 | 3 |
355326 | 355326 | 2020-07-21 | Boone | Missouri | 29019 | 927 | 3 |
352124 | 352124 | 2020-07-20 | Boone | Missouri | 29019 | 901 | 3 |
348924 | 348924 | 2020-07-19 | Boone | Missouri | 29019 | 892 | 3 |
345723 | 345723 | 2020-07-18 | Boone | Missouri | 29019 | 871 | 3 |
342523 | 342523 | 2020-07-17 | Boone | Missouri | 29019 | 843 | 3 |
339327 | 339327 | 2020-07-16 | Boone | Missouri | 29019 | 821 | 3 |
336131 | 336131 | 2020-07-15 | Boone | Missouri | 29019 | 800 | 3 |
332938 | 332938 | 2020-07-14 | Boone | Missouri | 29019 | 777 | 3 |
329751 | 329751 | 2020-07-13 | Boone | Missouri | 29019 | 764 | 3 |
326565 | 326565 | 2020-07-12 | Boone | Missouri | 29019 | 758 | 2 |
323382 | 323382 | 2020-07-11 | Boone | Missouri | 29019 | 726 | 2 |
320203 | 320203 | 2020-07-10 | Boone | Missouri | 29019 | 670 | 2 |
317028 | 317028 | 2020-07-09 | Boone | Missouri | 29019 | 639 | 2 |
313854 | 313854 | 2020-07-08 | Boone | Missouri | 29019 | 597 | 2 |
310684 | 310684 | 2020-07-07 | Boone | Missouri | 29019 | 547 | 2 |
307516 | 307516 | 2020-07-06 | Boone | Missouri | 29019 | 513 | 2 |
304349 | 304349 | 2020-07-05 | Boone | Missouri | 29019 | 498 | 2 |
301185 | 301185 | 2020-07-04 | Boone | Missouri | 29019 | 478 | 2 |
298022 | 298022 | 2020-07-03 | Boone | Missouri | 29019 | 460 | 2 |
294864 | 294864 | 2020-07-02 | Boone | Missouri | 29019 | 429 | 2 |
291710 | 291710 | 2020-07-01 | Boone | Missouri | 29019 | 390 | 2 |
288559 | 288559 | 2020-06-30 | Boone | Missouri | 29019 | 379 | 2 |
285409 | 285409 | 2020-06-29 | Boone | Missouri | 29019 | 354 | 2 |
282264 | 282264 | 2020-06-28 | Boone | Missouri | 29019 | 353 | 2 |
279116 | 279116 | 2020-06-27 | Boone | Missouri | 29019 | 342 | 2 |
275968 | 275968 | 2020-06-26 | Boone | Missouri | 29019 | 334 | 2 |
272825 | 272825 | 2020-06-25 | Boone | Missouri | 29019 | 319 | 2 |
269687 | 269687 | 2020-06-24 | Boone | Missouri | 29019 | 288 | 2 |
266554 | 266554 | 2020-06-23 | Boone | Missouri | 29019 | 280 | 2 |
263428 | 263428 | 2020-06-22 | Boone | Missouri | 29019 | 266 | 2 |
260300 | 260300 | 2020-06-21 | Boone | Missouri | 29019 | 258 | 2 |
257174 | 257174 | 2020-06-20 | Boone | Missouri | 29019 | 257 | 2 |
254054 | 254054 | 2020-06-19 | Boone | Missouri | 29019 | 246 | 2 |
250939 | 250939 | 2020-06-18 | Boone | Missouri | 29019 | 226 | 2 |
247826 | 247826 | 2020-06-17 | Boone | Missouri | 29019 | 222 | 2 |
244713 | 244713 | 2020-06-16 | Boone | Missouri | 29019 | 216 | 2 |
241602 | 241602 | 2020-06-15 | Boone | Missouri | 29019 | 215 | 2 |
238493 | 238493 | 2020-06-14 | Boone | Missouri | 29019 | 208 | 2 |
235386 | 235386 | 2020-06-13 | Boone | Missouri | 29019 | 208 | 2 |
232280 | 232280 | 2020-06-12 | Boone | Missouri | 29019 | 204 | 2 |
229176 | 229176 | 2020-06-11 | Boone | Missouri | 29019 | 201 | 1 |
226073 | 226073 | 2020-06-10 | Boone | Missouri | 29019 | 197 | 1 |
222975 | 222975 | 2020-06-09 | Boone | Missouri | 29019 | 194 | 1 |
219880 | 219880 | 2020-06-08 | Boone | Missouri | 29019 | 193 | 1 |
216788 | 216788 | 2020-06-07 | Boone | Missouri | 29019 | 189 | 1 |
213700 | 213700 | 2020-06-06 | Boone | Missouri | 29019 | 178 | 1 |
210616 | 210616 | 2020-06-05 | Boone | Missouri | 29019 | 173 | 1 |
207535 | 207535 | 2020-06-04 | Boone | Missouri | 29019 | 163 | 1 |
204454 | 204454 | 2020-06-03 | Boone | Missouri | 29019 | 156 | 1 |
201377 | 201377 | 2020-06-02 | Boone | Missouri | 29019 | 154 | 1 |
198304 | 198304 | 2020-06-01 | Boone | Missouri | 29019 | 153 | 1 |
195233 | 195233 | 2020-05-31 | Boone | Missouri | 29019 | 152 | 1 |
192165 | 192165 | 2020-05-30 | Boone | Missouri | 29019 | 143 | 1 |
189101 | 189101 | 2020-05-29 | Boone | Missouri | 29019 | 144 | 1 |
186043 | 186043 | 2020-05-28 | Boone | Missouri | 29019 | 137 | 1 |
182987 | 182987 | 2020-05-27 | Boone | Missouri | 29019 | 130 | 1 |
179941 | 179941 | 2020-05-26 | Boone | Missouri | 29019 | 123 | 1 |
176897 | 176897 | 2020-05-25 | Boone | Missouri | 29019 | 122 | 1 |
173854 | 173854 | 2020-05-24 | Boone | Missouri | 29019 | 116 | 1 |
170812 | 170812 | 2020-05-23 | Boone | Missouri | 29019 | 113 | 1 |
167774 | 167774 | 2020-05-22 | Boone | Missouri | 29019 | 111 | 1 |
164738 | 164738 | 2020-05-21 | Boone | Missouri | 29019 | 107 | 1 |
161709 | 161709 | 2020-05-20 | Boone | Missouri | 29019 | 106 | 1 |
158683 | 158683 | 2020-05-19 | Boone | Missouri | 29019 | 106 | 1 |
155665 | 155665 | 2020-05-18 | Boone | Missouri | 29019 | 105 | 1 |
152651 | 152651 | 2020-05-17 | Boone | Missouri | 29019 | 104 | 1 |
149640 | 149640 | 2020-05-16 | Boone | Missouri | 29019 | 100 | 1 |
146635 | 146635 | 2020-05-15 | Boone | Missouri | 29019 | 100 | 1 |
143635 | 143635 | 2020-05-14 | Boone | Missouri | 29019 | 100 | 1 |
140640 | 140640 | 2020-05-13 | Boone | Missouri | 29019 | 100 | 1 |
137646 | 137646 | 2020-05-12 | Boone | Missouri | 29019 | 100 | 1 |
134656 | 134656 | 2020-05-11 | Boone | Missouri | 29019 | 100 | 1 |
131665 | 131665 | 2020-05-10 | Boone | Missouri | 29019 | 100 | 1 |
128675 | 128675 | 2020-05-09 | Boone | Missouri | 29019 | 98 | 1 |
125688 | 125688 | 2020-05-08 | Boone | Missouri | 29019 | 98 | 1 |
122706 | 122706 | 2020-05-07 | Boone | Missouri | 29019 | 97 | 1 |
119732 | 119732 | 2020-05-06 | Boone | Missouri | 29019 | 98 | 1 |
116772 | 116772 | 2020-05-05 | Boone | Missouri | 29019 | 97 | 1 |
113890 | 113890 | 2020-05-04 | Boone | Missouri | 29019 | 97 | 1 |
111011 | 111011 | 2020-05-03 | Boone | Missouri | 29019 | 102 | 1 |
108140 | 108140 | 2020-05-02 | Boone | Missouri | 29019 | 102 | 1 |
105275 | 105275 | 2020-05-01 | Boone | Missouri | 29019 | 102 | 1 |
102414 | 102414 | 2020-04-30 | Boone | Missouri | 29019 | 100 | 1 |
99562 | 99562 | 2020-04-29 | Boone | Missouri | 29019 | 99 | 1 |
96716 | 96716 | 2020-04-28 | Boone | Missouri | 29019 | 99 | 1 |
93880 | 93880 | 2020-04-27 | Boone | Missouri | 29019 | 98 | 1 |
91059 | 91059 | 2020-04-26 | Boone | Missouri | 29019 | 98 | 1 |
88243 | 88243 | 2020-04-25 | Boone | Missouri | 29019 | 98 | 1 |
85433 | 85433 | 2020-04-24 | Boone | Missouri | 29019 | 99 | 1 |
82629 | 82629 | 2020-04-23 | Boone | Missouri | 29019 | 98 | 1 |
79833 | 79833 | 2020-04-22 | Boone | Missouri | 29019 | 97 | 1 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);