ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 29097 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535964 | 535964 | 2020-09-15 | Jasper | Missouri | 29097 | 2035 | 20 |
532729 | 532729 | 2020-09-14 | Jasper | Missouri | 29097 | 2003 | 18 |
529493 | 529493 | 2020-09-13 | Jasper | Missouri | 29097 | 1993 | 18 |
526257 | 526257 | 2020-09-12 | Jasper | Missouri | 29097 | 1967 | 18 |
523021 | 523021 | 2020-09-11 | Jasper | Missouri | 29097 | 1927 | 18 |
519784 | 519784 | 2020-09-10 | Jasper | Missouri | 29097 | 1894 | 16 |
516549 | 516549 | 2020-09-09 | Jasper | Missouri | 29097 | 1851 | 16 |
513315 | 513315 | 2020-09-08 | Jasper | Missouri | 29097 | 1795 | 16 |
510083 | 510083 | 2020-09-07 | Jasper | Missouri | 29097 | 1785 | 16 |
506850 | 506850 | 2020-09-06 | Jasper | Missouri | 29097 | 1783 | 16 |
503617 | 503617 | 2020-09-05 | Jasper | Missouri | 29097 | 1768 | 15 |
500383 | 500383 | 2020-09-04 | Jasper | Missouri | 29097 | 1751 | 15 |
497149 | 497149 | 2020-09-03 | Jasper | Missouri | 29097 | 1710 | 15 |
493916 | 493916 | 2020-09-02 | Jasper | Missouri | 29097 | 1671 | 15 |
490682 | 490682 | 2020-09-01 | Jasper | Missouri | 29097 | 1640 | 15 |
487449 | 487449 | 2020-08-31 | Jasper | Missouri | 29097 | 1625 | 15 |
484215 | 484215 | 2020-08-30 | Jasper | Missouri | 29097 | 1617 | 15 |
480980 | 480980 | 2020-08-29 | Jasper | Missouri | 29097 | 1585 | 15 |
477748 | 477748 | 2020-08-28 | Jasper | Missouri | 29097 | 1560 | 14 |
474515 | 474515 | 2020-08-27 | Jasper | Missouri | 29097 | 1539 | 14 |
471283 | 471283 | 2020-08-26 | Jasper | Missouri | 29097 | 1508 | 14 |
468053 | 468053 | 2020-08-25 | Jasper | Missouri | 29097 | 1477 | 14 |
464824 | 464824 | 2020-08-24 | Jasper | Missouri | 29097 | 1466 | 14 |
461593 | 461593 | 2020-08-23 | Jasper | Missouri | 29097 | 1460 | 14 |
458366 | 458366 | 2020-08-22 | Jasper | Missouri | 29097 | 1440 | 14 |
455138 | 455138 | 2020-08-21 | Jasper | Missouri | 29097 | 1427 | 14 |
451910 | 451910 | 2020-08-20 | Jasper | Missouri | 29097 | 1401 | 14 |
448682 | 448682 | 2020-08-19 | Jasper | Missouri | 29097 | 1393 | 14 |
445456 | 445456 | 2020-08-18 | Jasper | Missouri | 29097 | 1378 | 14 |
442230 | 442230 | 2020-08-17 | Jasper | Missouri | 29097 | 1377 | 12 |
439003 | 439003 | 2020-08-16 | Jasper | Missouri | 29097 | 1363 | 12 |
435778 | 435778 | 2020-08-15 | Jasper | Missouri | 29097 | 1365 | 12 |
432552 | 432552 | 2020-08-14 | Jasper | Missouri | 29097 | 1332 | 12 |
429325 | 429325 | 2020-08-13 | Jasper | Missouri | 29097 | 1325 | 11 |
426101 | 426101 | 2020-08-12 | Jasper | Missouri | 29097 | 1322 | 11 |
422879 | 422879 | 2020-08-11 | Jasper | Missouri | 29097 | 1271 | 11 |
419657 | 419657 | 2020-08-10 | Jasper | Missouri | 29097 | 1264 | 11 |
416436 | 416436 | 2020-08-09 | Jasper | Missouri | 29097 | 1260 | 11 |
413216 | 413216 | 2020-08-08 | Jasper | Missouri | 29097 | 1248 | 10 |
409996 | 409996 | 2020-08-07 | Jasper | Missouri | 29097 | 1248 | 10 |
406776 | 406776 | 2020-08-06 | Jasper | Missouri | 29097 | 1224 | 8 |
403558 | 403558 | 2020-08-05 | Jasper | Missouri | 29097 | 1217 | 7 |
400341 | 400341 | 2020-08-04 | Jasper | Missouri | 29097 | 1208 | 7 |
397127 | 397127 | 2020-08-03 | Jasper | Missouri | 29097 | 1206 | 5 |
393911 | 393911 | 2020-08-02 | Jasper | Missouri | 29097 | 1204 | 5 |
390694 | 390694 | 2020-08-01 | Jasper | Missouri | 29097 | 1201 | 5 |
387477 | 387477 | 2020-07-31 | Jasper | Missouri | 29097 | 1190 | 4 |
384259 | 384259 | 2020-07-30 | Jasper | Missouri | 29097 | 1176 | 4 |
381043 | 381043 | 2020-07-29 | Jasper | Missouri | 29097 | 1166 | 4 |
377826 | 377826 | 2020-07-28 | Jasper | Missouri | 29097 | 1161 | 4 |
374611 | 374611 | 2020-07-27 | Jasper | Missouri | 29097 | 1132 | 4 |
371399 | 371399 | 2020-07-26 | Jasper | Missouri | 29097 | 1106 | 4 |
368188 | 368188 | 2020-07-25 | Jasper | Missouri | 29097 | 1092 | 4 |
364980 | 364980 | 2020-07-24 | Jasper | Missouri | 29097 | 1046 | 3 |
361773 | 361773 | 2020-07-23 | Jasper | Missouri | 29097 | 997 | 3 |
358568 | 358568 | 2020-07-22 | Jasper | Missouri | 29097 | 967 | 2 |
355365 | 355365 | 2020-07-21 | Jasper | Missouri | 29097 | 950 | 2 |
352163 | 352163 | 2020-07-20 | Jasper | Missouri | 29097 | 937 | 1 |
348963 | 348963 | 2020-07-19 | Jasper | Missouri | 29097 | 923 | 1 |
345762 | 345762 | 2020-07-18 | Jasper | Missouri | 29097 | 908 | 1 |
342562 | 342562 | 2020-07-17 | Jasper | Missouri | 29097 | 877 | 1 |
339366 | 339366 | 2020-07-16 | Jasper | Missouri | 29097 | 840 | 1 |
336170 | 336170 | 2020-07-15 | Jasper | Missouri | 29097 | 823 | 1 |
332977 | 332977 | 2020-07-14 | Jasper | Missouri | 29097 | 807 | 1 |
329790 | 329790 | 2020-07-13 | Jasper | Missouri | 29097 | 778 | 1 |
326604 | 326604 | 2020-07-12 | Jasper | Missouri | 29097 | 772 | 1 |
323421 | 323421 | 2020-07-11 | Jasper | Missouri | 29097 | 761 | 1 |
320242 | 320242 | 2020-07-10 | Jasper | Missouri | 29097 | 748 | 1 |
317067 | 317067 | 2020-07-09 | Jasper | Missouri | 29097 | 733 | 2 |
313893 | 313893 | 2020-07-08 | Jasper | Missouri | 29097 | 692 | 1 |
310722 | 310722 | 2020-07-07 | Jasper | Missouri | 29097 | 652 | 1 |
307554 | 307554 | 2020-07-06 | Jasper | Missouri | 29097 | 611 | 1 |
304387 | 304387 | 2020-07-05 | Jasper | Missouri | 29097 | 587 | 1 |
301223 | 301223 | 2020-07-04 | Jasper | Missouri | 29097 | 582 | 1 |
298060 | 298060 | 2020-07-03 | Jasper | Missouri | 29097 | 515 | 1 |
294902 | 294902 | 2020-07-02 | Jasper | Missouri | 29097 | 481 | 1 |
291748 | 291748 | 2020-07-01 | Jasper | Missouri | 29097 | 474 | 1 |
288597 | 288597 | 2020-06-30 | Jasper | Missouri | 29097 | 449 | 1 |
285447 | 285447 | 2020-06-29 | Jasper | Missouri | 29097 | 398 | 1 |
282302 | 282302 | 2020-06-28 | Jasper | Missouri | 29097 | 368 | 1 |
279154 | 279154 | 2020-06-27 | Jasper | Missouri | 29097 | 356 | 1 |
276006 | 276006 | 2020-06-26 | Jasper | Missouri | 29097 | 338 | 1 |
272863 | 272863 | 2020-06-25 | Jasper | Missouri | 29097 | 311 | 1 |
269725 | 269725 | 2020-06-24 | Jasper | Missouri | 29097 | 309 | 0 |
266592 | 266592 | 2020-06-23 | Jasper | Missouri | 29097 | 303 | 0 |
263466 | 263466 | 2020-06-22 | Jasper | Missouri | 29097 | 260 | 0 |
260338 | 260338 | 2020-06-21 | Jasper | Missouri | 29097 | 260 | 0 |
257212 | 257212 | 2020-06-20 | Jasper | Missouri | 29097 | 235 | 0 |
254092 | 254092 | 2020-06-19 | Jasper | Missouri | 29097 | 195 | 0 |
250977 | 250977 | 2020-06-18 | Jasper | Missouri | 29097 | 191 | 0 |
247864 | 247864 | 2020-06-17 | Jasper | Missouri | 29097 | 168 | 0 |
244751 | 244751 | 2020-06-16 | Jasper | Missouri | 29097 | 163 | 0 |
241640 | 241640 | 2020-06-15 | Jasper | Missouri | 29097 | 131 | 0 |
238530 | 238530 | 2020-06-14 | Jasper | Missouri | 29097 | 115 | 0 |
235423 | 235423 | 2020-06-13 | Jasper | Missouri | 29097 | 115 | 0 |
232317 | 232317 | 2020-06-12 | Jasper | Missouri | 29097 | 103 | 0 |
229213 | 229213 | 2020-06-11 | Jasper | Missouri | 29097 | 80 | 0 |
226110 | 226110 | 2020-06-10 | Jasper | Missouri | 29097 | 73 | 0 |
223012 | 223012 | 2020-06-09 | Jasper | Missouri | 29097 | 65 | 0 |
219917 | 219917 | 2020-06-08 | Jasper | Missouri | 29097 | 58 | 0 |
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);