ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 47119 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
634221 | 634221 | 2020-10-15 | Maury | Tennessee | 47119 | 2874 | 34 |
630976 | 630976 | 2020-10-14 | Maury | Tennessee | 47119 | 2858 | 34 |
627732 | 627732 | 2020-10-13 | Maury | Tennessee | 47119 | 2805 | 34 |
624490 | 624490 | 2020-10-12 | Maury | Tennessee | 47119 | 2799 | 33 |
621247 | 621247 | 2020-10-11 | Maury | Tennessee | 47119 | 2760 | 33 |
618004 | 618004 | 2020-10-10 | Maury | Tennessee | 47119 | 2723 | 33 |
614762 | 614762 | 2020-10-09 | Maury | Tennessee | 47119 | 2684 | 32 |
611521 | 611521 | 2020-10-08 | Maury | Tennessee | 47119 | 2647 | 31 |
608279 | 608279 | 2020-10-07 | Maury | Tennessee | 47119 | 2602 | 30 |
605036 | 605036 | 2020-10-06 | Maury | Tennessee | 47119 | 2582 | 30 |
601794 | 601794 | 2020-10-05 | Maury | Tennessee | 47119 | 2570 | 29 |
598551 | 598551 | 2020-10-04 | Maury | Tennessee | 47119 | 2528 | 29 |
595308 | 595308 | 2020-10-03 | Maury | Tennessee | 47119 | 2500 | 29 |
592067 | 592067 | 2020-10-02 | Maury | Tennessee | 47119 | 2486 | 28 |
588826 | 588826 | 2020-10-01 | Maury | Tennessee | 47119 | 2472 | 27 |
585586 | 585586 | 2020-09-30 | Maury | Tennessee | 47119 | 2457 | 26 |
582346 | 582346 | 2020-09-29 | Maury | Tennessee | 47119 | 2427 | 25 |
579106 | 579106 | 2020-09-28 | Maury | Tennessee | 47119 | 2420 | 24 |
575865 | 575865 | 2020-09-27 | Maury | Tennessee | 47119 | 2409 | 24 |
572621 | 572621 | 2020-09-26 | Maury | Tennessee | 47119 | 2361 | 24 |
569379 | 569379 | 2020-09-25 | Maury | Tennessee | 47119 | 2329 | 23 |
566138 | 566138 | 2020-09-24 | Maury | Tennessee | 47119 | 2309 | 23 |
562897 | 562897 | 2020-09-23 | Maury | Tennessee | 47119 | 2289 | 23 |
559660 | 559660 | 2020-09-22 | Maury | Tennessee | 47119 | 2274 | 23 |
556423 | 556423 | 2020-09-21 | Maury | Tennessee | 47119 | 2260 | 23 |
553186 | 553186 | 2020-09-20 | Maury | Tennessee | 47119 | 2238 | 23 |
549947 | 549947 | 2020-09-19 | Maury | Tennessee | 47119 | 2183 | 23 |
546708 | 546708 | 2020-09-18 | Maury | Tennessee | 47119 | 2178 | 22 |
543471 | 543471 | 2020-09-17 | Maury | Tennessee | 47119 | 2136 | 22 |
540235 | 540235 | 2020-09-16 | Maury | Tennessee | 47119 | 2112 | 22 |
536998 | 536998 | 2020-09-15 | Maury | Tennessee | 47119 | 2082 | 21 |
533762 | 533762 | 2020-09-14 | Maury | Tennessee | 47119 | 2072 | 20 |
530527 | 530527 | 2020-09-13 | Maury | Tennessee | 47119 | 2027 | 20 |
527290 | 527290 | 2020-09-12 | Maury | Tennessee | 47119 | 2010 | 19 |
524054 | 524054 | 2020-09-11 | Maury | Tennessee | 47119 | 2000 | 18 |
520818 | 520818 | 2020-09-10 | Maury | Tennessee | 47119 | 1965 | 18 |
517582 | 517582 | 2020-09-09 | Maury | Tennessee | 47119 | 1902 | 18 |
514347 | 514347 | 2020-09-08 | Maury | Tennessee | 47119 | 1900 | 18 |
511114 | 511114 | 2020-09-07 | Maury | Tennessee | 47119 | 1892 | 18 |
507881 | 507881 | 2020-09-06 | Maury | Tennessee | 47119 | 1883 | 18 |
504649 | 504649 | 2020-09-05 | Maury | Tennessee | 47119 | 1856 | 18 |
501415 | 501415 | 2020-09-04 | Maury | Tennessee | 47119 | 1831 | 17 |
498181 | 498181 | 2020-09-03 | Maury | Tennessee | 47119 | 1822 | 16 |
494948 | 494948 | 2020-09-02 | Maury | Tennessee | 47119 | 1807 | 15 |
491714 | 491714 | 2020-09-01 | Maury | Tennessee | 47119 | 1778 | 15 |
488481 | 488481 | 2020-08-31 | Maury | Tennessee | 47119 | 1749 | 15 |
485248 | 485248 | 2020-08-30 | Maury | Tennessee | 47119 | 1735 | 15 |
482013 | 482013 | 2020-08-29 | Maury | Tennessee | 47119 | 1725 | 14 |
478779 | 478779 | 2020-08-28 | Maury | Tennessee | 47119 | 1711 | 14 |
475546 | 475546 | 2020-08-27 | Maury | Tennessee | 47119 | 1674 | 14 |
472313 | 472313 | 2020-08-26 | Maury | Tennessee | 47119 | 1648 | 13 |
469081 | 469081 | 2020-08-25 | Maury | Tennessee | 47119 | 1599 | 13 |
465852 | 465852 | 2020-08-24 | Maury | Tennessee | 47119 | 1593 | 11 |
462623 | 462623 | 2020-08-23 | Maury | Tennessee | 47119 | 1581 | 11 |
459395 | 459395 | 2020-08-22 | Maury | Tennessee | 47119 | 1540 | 11 |
456167 | 456167 | 2020-08-21 | Maury | Tennessee | 47119 | 1519 | 11 |
452939 | 452939 | 2020-08-20 | Maury | Tennessee | 47119 | 1492 | 11 |
449711 | 449711 | 2020-08-19 | Maury | Tennessee | 47119 | 1470 | 11 |
446483 | 446483 | 2020-08-18 | Maury | Tennessee | 47119 | 1449 | 11 |
443257 | 443257 | 2020-08-17 | Maury | Tennessee | 47119 | 1445 | 10 |
440030 | 440030 | 2020-08-16 | Maury | Tennessee | 47119 | 1433 | 10 |
436805 | 436805 | 2020-08-15 | Maury | Tennessee | 47119 | 1382 | 9 |
433578 | 433578 | 2020-08-14 | Maury | Tennessee | 47119 | 1367 | 9 |
430353 | 430353 | 2020-08-13 | Maury | Tennessee | 47119 | 1329 | 9 |
427126 | 427126 | 2020-08-12 | Maury | Tennessee | 47119 | 1299 | 8 |
423903 | 423903 | 2020-08-11 | Maury | Tennessee | 47119 | 1284 | 7 |
420681 | 420681 | 2020-08-10 | Maury | Tennessee | 47119 | 1272 | 7 |
417460 | 417460 | 2020-08-09 | Maury | Tennessee | 47119 | 1257 | 7 |
414239 | 414239 | 2020-08-08 | Maury | Tennessee | 47119 | 1225 | 7 |
411019 | 411019 | 2020-08-07 | Maury | Tennessee | 47119 | 1178 | 7 |
407800 | 407800 | 2020-08-06 | Maury | Tennessee | 47119 | 1159 | 7 |
404580 | 404580 | 2020-08-05 | Maury | Tennessee | 47119 | 1107 | 7 |
401362 | 401362 | 2020-08-04 | Maury | Tennessee | 47119 | 1089 | 7 |
398147 | 398147 | 2020-08-03 | Maury | Tennessee | 47119 | 1081 | 5 |
394930 | 394930 | 2020-08-02 | Maury | Tennessee | 47119 | 1066 | 5 |
391714 | 391714 | 2020-08-01 | Maury | Tennessee | 47119 | 1050 | 5 |
388497 | 388497 | 2020-07-31 | Maury | Tennessee | 47119 | 1010 | 5 |
385280 | 385280 | 2020-07-30 | Maury | Tennessee | 47119 | 971 | 5 |
382062 | 382062 | 2020-07-29 | Maury | Tennessee | 47119 | 953 | 5 |
378845 | 378845 | 2020-07-28 | Maury | Tennessee | 47119 | 933 | 4 |
375629 | 375629 | 2020-07-27 | Maury | Tennessee | 47119 | 904 | 4 |
372416 | 372416 | 2020-07-26 | Maury | Tennessee | 47119 | 881 | 4 |
369204 | 369204 | 2020-07-25 | Maury | Tennessee | 47119 | 821 | 4 |
365995 | 365995 | 2020-07-24 | Maury | Tennessee | 47119 | 792 | 4 |
362789 | 362789 | 2020-07-23 | Maury | Tennessee | 47119 | 758 | 4 |
359582 | 359582 | 2020-07-22 | Maury | Tennessee | 47119 | 712 | 4 |
356378 | 356378 | 2020-07-21 | Maury | Tennessee | 47119 | 689 | 4 |
353175 | 353175 | 2020-07-20 | Maury | Tennessee | 47119 | 665 | 4 |
349972 | 349972 | 2020-07-19 | Maury | Tennessee | 47119 | 629 | 4 |
346772 | 346772 | 2020-07-18 | Maury | Tennessee | 47119 | 606 | 4 |
343572 | 343572 | 2020-07-17 | Maury | Tennessee | 47119 | 580 | 4 |
340374 | 340374 | 2020-07-16 | Maury | Tennessee | 47119 | 557 | 4 |
337177 | 337177 | 2020-07-15 | Maury | Tennessee | 47119 | 529 | 3 |
333983 | 333983 | 2020-07-14 | Maury | Tennessee | 47119 | 513 | 3 |
330791 | 330791 | 2020-07-13 | Maury | Tennessee | 47119 | 499 | 3 |
327605 | 327605 | 2020-07-12 | Maury | Tennessee | 47119 | 462 | 3 |
324420 | 324420 | 2020-07-11 | Maury | Tennessee | 47119 | 454 | 3 |
321239 | 321239 | 2020-07-10 | Maury | Tennessee | 47119 | 431 | 3 |
318061 | 318061 | 2020-07-09 | Maury | Tennessee | 47119 | 420 | 3 |
314888 | 314888 | 2020-07-08 | Maury | Tennessee | 47119 | 406 | 3 |
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);