ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 29095 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
384258 | 384258 | 2020-07-30 | Jackson | Missouri | 29095 | 3189 | 56 |
381042 | 381042 | 2020-07-29 | Jackson | Missouri | 29095 | 2957 | 55 |
377825 | 377825 | 2020-07-28 | Jackson | Missouri | 29095 | 2852 | 55 |
374610 | 374610 | 2020-07-27 | Jackson | Missouri | 29095 | 2774 | 56 |
371398 | 371398 | 2020-07-26 | Jackson | Missouri | 29095 | 2642 | 55 |
368187 | 368187 | 2020-07-25 | Jackson | Missouri | 29095 | 2554 | 53 |
364979 | 364979 | 2020-07-24 | Jackson | Missouri | 29095 | 2554 | 53 |
361772 | 361772 | 2020-07-23 | Jackson | Missouri | 29095 | 2466 | 50 |
358567 | 358567 | 2020-07-22 | Jackson | Missouri | 29095 | 2407 | 48 |
355364 | 355364 | 2020-07-21 | Jackson | Missouri | 29095 | 2330 | 48 |
352162 | 352162 | 2020-07-20 | Jackson | Missouri | 29095 | 2220 | 47 |
348962 | 348962 | 2020-07-19 | Jackson | Missouri | 29095 | 2209 | 47 |
345761 | 345761 | 2020-07-18 | Jackson | Missouri | 29095 | 2077 | 46 |
342561 | 342561 | 2020-07-17 | Jackson | Missouri | 29095 | 2077 | 46 |
339365 | 339365 | 2020-07-16 | Jackson | Missouri | 29095 | 1962 | 46 |
336169 | 336169 | 2020-07-15 | Jackson | Missouri | 29095 | 1936 | 46 |
332976 | 332976 | 2020-07-14 | Jackson | Missouri | 29095 | 1806 | 46 |
329789 | 329789 | 2020-07-13 | Jackson | Missouri | 29095 | 1781 | 44 |
326603 | 326603 | 2020-07-12 | Jackson | Missouri | 29095 | 1743 | 44 |
323420 | 323420 | 2020-07-11 | Jackson | Missouri | 29095 | 1657 | 43 |
320241 | 320241 | 2020-07-10 | Jackson | Missouri | 29095 | 1612 | 42 |
317066 | 317066 | 2020-07-09 | Jackson | Missouri | 29095 | 1527 | 42 |
313892 | 313892 | 2020-07-08 | Jackson | Missouri | 29095 | 1479 | 42 |
310721 | 310721 | 2020-07-07 | Jackson | Missouri | 29095 | 1436 | 42 |
307553 | 307553 | 2020-07-06 | Jackson | Missouri | 29095 | 1399 | 40 |
304386 | 304386 | 2020-07-05 | Jackson | Missouri | 29095 | 1367 | 40 |
301222 | 301222 | 2020-07-04 | Jackson | Missouri | 29095 | 1361 | 40 |
298059 | 298059 | 2020-07-03 | Jackson | Missouri | 29095 | 1306 | 39 |
294901 | 294901 | 2020-07-02 | Jackson | Missouri | 29095 | 1257 | 39 |
291747 | 291747 | 2020-07-01 | Jackson | Missouri | 29095 | 1233 | 37 |
288596 | 288596 | 2020-06-30 | Jackson | Missouri | 29095 | 1210 | 36 |
285446 | 285446 | 2020-06-29 | Jackson | Missouri | 29095 | 1172 | 36 |
282301 | 282301 | 2020-06-28 | Jackson | Missouri | 29095 | 1149 | 36 |
279153 | 279153 | 2020-06-27 | Jackson | Missouri | 29095 | 1132 | 35 |
276005 | 276005 | 2020-06-26 | Jackson | Missouri | 29095 | 1103 | 36 |
272862 | 272862 | 2020-06-25 | Jackson | Missouri | 29095 | 1074 | 36 |
269724 | 269724 | 2020-06-24 | Jackson | Missouri | 29095 | 1076 | 33 |
266591 | 266591 | 2020-06-23 | Jackson | Missouri | 29095 | 1054 | 33 |
263465 | 263465 | 2020-06-22 | Jackson | Missouri | 29095 | 1030 | 27 |
260337 | 260337 | 2020-06-21 | Jackson | Missouri | 29095 | 1018 | 27 |
257211 | 257211 | 2020-06-20 | Jackson | Missouri | 29095 | 1016 | 27 |
254091 | 254091 | 2020-06-19 | Jackson | Missouri | 29095 | 976 | 27 |
250976 | 250976 | 2020-06-18 | Jackson | Missouri | 29095 | 933 | 27 |
247863 | 247863 | 2020-06-17 | Jackson | Missouri | 29095 | 916 | 26 |
244750 | 244750 | 2020-06-16 | Jackson | Missouri | 29095 | 889 | 26 |
241639 | 241639 | 2020-06-15 | Jackson | Missouri | 29095 | 865 | 22 |
238529 | 238529 | 2020-06-14 | Jackson | Missouri | 29095 | 819 | 22 |
235422 | 235422 | 2020-06-13 | Jackson | Missouri | 29095 | 819 | 22 |
232316 | 232316 | 2020-06-12 | Jackson | Missouri | 29095 | 791 | 22 |
229212 | 229212 | 2020-06-11 | Jackson | Missouri | 29095 | 782 | 22 |
226109 | 226109 | 2020-06-10 | Jackson | Missouri | 29095 | 752 | 22 |
223011 | 223011 | 2020-06-09 | Jackson | Missouri | 29095 | 727 | 22 |
219916 | 219916 | 2020-06-08 | Jackson | Missouri | 29095 | 716 | 22 |
216824 | 216824 | 2020-06-07 | Jackson | Missouri | 29095 | 702 | 22 |
213736 | 213736 | 2020-06-06 | Jackson | Missouri | 29095 | 696 | 22 |
210652 | 210652 | 2020-06-05 | Jackson | Missouri | 29095 | 686 | 22 |
207571 | 207571 | 2020-06-04 | Jackson | Missouri | 29095 | 676 | 22 |
204490 | 204490 | 2020-06-03 | Jackson | Missouri | 29095 | 656 | 22 |
201413 | 201413 | 2020-06-02 | Jackson | Missouri | 29095 | 637 | 22 |
198340 | 198340 | 2020-06-01 | Jackson | Missouri | 29095 | 613 | 19 |
195269 | 195269 | 2020-05-31 | Jackson | Missouri | 29095 | 596 | 19 |
192200 | 192200 | 2020-05-30 | Jackson | Missouri | 29095 | 570 | 19 |
189136 | 189136 | 2020-05-29 | Jackson | Missouri | 29095 | 560 | 17 |
186078 | 186078 | 2020-05-28 | Jackson | Missouri | 29095 | 554 | 17 |
183022 | 183022 | 2020-05-27 | Jackson | Missouri | 29095 | 540 | 16 |
179976 | 179976 | 2020-05-26 | Jackson | Missouri | 29095 | 528 | 16 |
176932 | 176932 | 2020-05-25 | Jackson | Missouri | 29095 | 520 | 16 |
173889 | 173889 | 2020-05-24 | Jackson | Missouri | 29095 | 517 | 16 |
170847 | 170847 | 2020-05-23 | Jackson | Missouri | 29095 | 495 | 16 |
167808 | 167808 | 2020-05-22 | Jackson | Missouri | 29095 | 485 | 16 |
164772 | 164772 | 2020-05-21 | Jackson | Missouri | 29095 | 469 | 16 |
161743 | 161743 | 2020-05-20 | Jackson | Missouri | 29095 | 465 | 16 |
158717 | 158717 | 2020-05-19 | Jackson | Missouri | 29095 | 457 | 16 |
155699 | 155699 | 2020-05-18 | Jackson | Missouri | 29095 | 454 | 16 |
152685 | 152685 | 2020-05-17 | Jackson | Missouri | 29095 | 446 | 16 |
149674 | 149674 | 2020-05-16 | Jackson | Missouri | 29095 | 432 | 16 |
146669 | 146669 | 2020-05-15 | Jackson | Missouri | 29095 | 425 | 16 |
143668 | 143668 | 2020-05-14 | Jackson | Missouri | 29095 | 407 | 16 |
140673 | 140673 | 2020-05-13 | Jackson | Missouri | 29095 | 402 | 16 |
137679 | 137679 | 2020-05-12 | Jackson | Missouri | 29095 | 402 | 16 |
134689 | 134689 | 2020-05-11 | Jackson | Missouri | 29095 | 401 | 16 |
131698 | 131698 | 2020-05-10 | Jackson | Missouri | 29095 | 398 | 16 |
128708 | 128708 | 2020-05-09 | Jackson | Missouri | 29095 | 390 | 16 |
125721 | 125721 | 2020-05-08 | Jackson | Missouri | 29095 | 380 | 16 |
122739 | 122739 | 2020-05-07 | Jackson | Missouri | 29095 | 373 | 16 |
119765 | 119765 | 2020-05-06 | Jackson | Missouri | 29095 | 362 | 16 |
116805 | 116805 | 2020-05-05 | Jackson | Missouri | 29095 | 357 | 16 |
113923 | 113923 | 2020-05-04 | Jackson | Missouri | 29095 | 351 | 15 |
111044 | 111044 | 2020-05-03 | Jackson | Missouri | 29095 | 342 | 14 |
108173 | 108173 | 2020-05-02 | Jackson | Missouri | 29095 | 339 | 14 |
105308 | 105308 | 2020-05-01 | Jackson | Missouri | 29095 | 329 | 14 |
102447 | 102447 | 2020-04-30 | Jackson | Missouri | 29095 | 323 | 14 |
99595 | 99595 | 2020-04-29 | Jackson | Missouri | 29095 | 313 | 13 |
96749 | 96749 | 2020-04-28 | Jackson | Missouri | 29095 | 309 | 12 |
93913 | 93913 | 2020-04-27 | Jackson | Missouri | 29095 | 309 | 12 |
91092 | 91092 | 2020-04-26 | Jackson | Missouri | 29095 | 307 | 12 |
88276 | 88276 | 2020-04-25 | Jackson | Missouri | 29095 | 303 | 12 |
85466 | 85466 | 2020-04-24 | Jackson | Missouri | 29095 | 300 | 12 |
82662 | 82662 | 2020-04-23 | Jackson | Missouri | 29095 | 296 | 12 |
79866 | 79866 | 2020-04-22 | Jackson | Missouri | 29095 | 288 | 12 |
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);