ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 47167 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637493 | 637493 | 2020-10-16 | Tipton | Tennessee | 47167 | 2128 | 22 |
634247 | 634247 | 2020-10-15 | Tipton | Tennessee | 47167 | 2123 | 22 |
631002 | 631002 | 2020-10-14 | Tipton | Tennessee | 47167 | 2113 | 22 |
627758 | 627758 | 2020-10-13 | Tipton | Tennessee | 47167 | 2084 | 22 |
624516 | 624516 | 2020-10-12 | Tipton | Tennessee | 47167 | 2066 | 22 |
621273 | 621273 | 2020-10-11 | Tipton | Tennessee | 47167 | 2044 | 22 |
618030 | 618030 | 2020-10-10 | Tipton | Tennessee | 47167 | 2014 | 22 |
614788 | 614788 | 2020-10-09 | Tipton | Tennessee | 47167 | 1996 | 22 |
611547 | 611547 | 2020-10-08 | Tipton | Tennessee | 47167 | 1987 | 22 |
608305 | 608305 | 2020-10-07 | Tipton | Tennessee | 47167 | 1964 | 22 |
605062 | 605062 | 2020-10-06 | Tipton | Tennessee | 47167 | 1944 | 22 |
601820 | 601820 | 2020-10-05 | Tipton | Tennessee | 47167 | 1921 | 22 |
598577 | 598577 | 2020-10-04 | Tipton | Tennessee | 47167 | 1897 | 22 |
595334 | 595334 | 2020-10-03 | Tipton | Tennessee | 47167 | 1885 | 21 |
592093 | 592093 | 2020-10-02 | Tipton | Tennessee | 47167 | 1878 | 20 |
588852 | 588852 | 2020-10-01 | Tipton | Tennessee | 47167 | 1874 | 20 |
585612 | 585612 | 2020-09-30 | Tipton | Tennessee | 47167 | 1860 | 19 |
582372 | 582372 | 2020-09-29 | Tipton | Tennessee | 47167 | 1845 | 19 |
579132 | 579132 | 2020-09-28 | Tipton | Tennessee | 47167 | 1836 | 19 |
575891 | 575891 | 2020-09-27 | Tipton | Tennessee | 47167 | 1832 | 19 |
572647 | 572647 | 2020-09-26 | Tipton | Tennessee | 47167 | 1818 | 19 |
569405 | 569405 | 2020-09-25 | Tipton | Tennessee | 47167 | 1805 | 19 |
566164 | 566164 | 2020-09-24 | Tipton | Tennessee | 47167 | 1781 | 18 |
562923 | 562923 | 2020-09-23 | Tipton | Tennessee | 47167 | 1766 | 17 |
559686 | 559686 | 2020-09-22 | Tipton | Tennessee | 47167 | 1745 | 17 |
556449 | 556449 | 2020-09-21 | Tipton | Tennessee | 47167 | 1739 | 17 |
553212 | 553212 | 2020-09-20 | Tipton | Tennessee | 47167 | 1733 | 17 |
549973 | 549973 | 2020-09-19 | Tipton | Tennessee | 47167 | 1711 | 17 |
546734 | 546734 | 2020-09-18 | Tipton | Tennessee | 47167 | 1704 | 17 |
543497 | 543497 | 2020-09-17 | Tipton | Tennessee | 47167 | 1684 | 17 |
540261 | 540261 | 2020-09-16 | Tipton | Tennessee | 47167 | 1677 | 17 |
537024 | 537024 | 2020-09-15 | Tipton | Tennessee | 47167 | 1650 | 17 |
533788 | 533788 | 2020-09-14 | Tipton | Tennessee | 47167 | 1642 | 17 |
530553 | 530553 | 2020-09-13 | Tipton | Tennessee | 47167 | 1614 | 16 |
527316 | 527316 | 2020-09-12 | Tipton | Tennessee | 47167 | 1605 | 15 |
524080 | 524080 | 2020-09-11 | Tipton | Tennessee | 47167 | 1603 | 15 |
520844 | 520844 | 2020-09-10 | Tipton | Tennessee | 47167 | 1590 | 15 |
517608 | 517608 | 2020-09-09 | Tipton | Tennessee | 47167 | 1572 | 15 |
514373 | 514373 | 2020-09-08 | Tipton | Tennessee | 47167 | 1566 | 15 |
511140 | 511140 | 2020-09-07 | Tipton | Tennessee | 47167 | 1561 | 15 |
507907 | 507907 | 2020-09-06 | Tipton | Tennessee | 47167 | 1556 | 15 |
504675 | 504675 | 2020-09-05 | Tipton | Tennessee | 47167 | 1532 | 15 |
501441 | 501441 | 2020-09-04 | Tipton | Tennessee | 47167 | 1522 | 15 |
498207 | 498207 | 2020-09-03 | Tipton | Tennessee | 47167 | 1518 | 15 |
494974 | 494974 | 2020-09-02 | Tipton | Tennessee | 47167 | 1481 | 15 |
491740 | 491740 | 2020-09-01 | Tipton | Tennessee | 47167 | 1470 | 15 |
488507 | 488507 | 2020-08-31 | Tipton | Tennessee | 47167 | 1462 | 15 |
485274 | 485274 | 2020-08-30 | Tipton | Tennessee | 47167 | 1455 | 15 |
482039 | 482039 | 2020-08-29 | Tipton | Tennessee | 47167 | 1448 | 15 |
478805 | 478805 | 2020-08-28 | Tipton | Tennessee | 47167 | 1431 | 15 |
475572 | 475572 | 2020-08-27 | Tipton | Tennessee | 47167 | 1392 | 14 |
472339 | 472339 | 2020-08-26 | Tipton | Tennessee | 47167 | 1356 | 14 |
469107 | 469107 | 2020-08-25 | Tipton | Tennessee | 47167 | 1349 | 13 |
465878 | 465878 | 2020-08-24 | Tipton | Tennessee | 47167 | 1337 | 13 |
462649 | 462649 | 2020-08-23 | Tipton | Tennessee | 47167 | 1323 | 13 |
459421 | 459421 | 2020-08-22 | Tipton | Tennessee | 47167 | 1309 | 13 |
456193 | 456193 | 2020-08-21 | Tipton | Tennessee | 47167 | 1301 | 13 |
452965 | 452965 | 2020-08-20 | Tipton | Tennessee | 47167 | 1295 | 13 |
449737 | 449737 | 2020-08-19 | Tipton | Tennessee | 47167 | 1295 | 12 |
446509 | 446509 | 2020-08-18 | Tipton | Tennessee | 47167 | 1274 | 12 |
443283 | 443283 | 2020-08-17 | Tipton | Tennessee | 47167 | 1268 | 12 |
440056 | 440056 | 2020-08-16 | Tipton | Tennessee | 47167 | 1256 | 12 |
436831 | 436831 | 2020-08-15 | Tipton | Tennessee | 47167 | 1253 | 12 |
433604 | 433604 | 2020-08-14 | Tipton | Tennessee | 47167 | 1247 | 12 |
430379 | 430379 | 2020-08-13 | Tipton | Tennessee | 47167 | 1233 | 12 |
427152 | 427152 | 2020-08-12 | Tipton | Tennessee | 47167 | 1217 | 10 |
423929 | 423929 | 2020-08-11 | Tipton | Tennessee | 47167 | 1217 | 10 |
420707 | 420707 | 2020-08-10 | Tipton | Tennessee | 47167 | 1211 | 10 |
417486 | 417486 | 2020-08-09 | Tipton | Tennessee | 47167 | 1208 | 10 |
414265 | 414265 | 2020-08-08 | Tipton | Tennessee | 47167 | 1195 | 9 |
411045 | 411045 | 2020-08-07 | Tipton | Tennessee | 47167 | 1183 | 9 |
407826 | 407826 | 2020-08-06 | Tipton | Tennessee | 47167 | 1155 | 9 |
404606 | 404606 | 2020-08-05 | Tipton | Tennessee | 47167 | 1137 | 9 |
401388 | 401388 | 2020-08-04 | Tipton | Tennessee | 47167 | 1123 | 9 |
398173 | 398173 | 2020-08-03 | Tipton | Tennessee | 47167 | 1106 | 9 |
394956 | 394956 | 2020-08-02 | Tipton | Tennessee | 47167 | 1104 | 9 |
391740 | 391740 | 2020-08-01 | Tipton | Tennessee | 47167 | 1094 | 9 |
388523 | 388523 | 2020-07-31 | Tipton | Tennessee | 47167 | 1065 | 9 |
385306 | 385306 | 2020-07-30 | Tipton | Tennessee | 47167 | 1040 | 9 |
382088 | 382088 | 2020-07-29 | Tipton | Tennessee | 47167 | 1026 | 9 |
378871 | 378871 | 2020-07-28 | Tipton | Tennessee | 47167 | 1000 | 8 |
375655 | 375655 | 2020-07-27 | Tipton | Tennessee | 47167 | 966 | 8 |
372442 | 372442 | 2020-07-26 | Tipton | Tennessee | 47167 | 931 | 8 |
369230 | 369230 | 2020-07-25 | Tipton | Tennessee | 47167 | 912 | 8 |
366021 | 366021 | 2020-07-24 | Tipton | Tennessee | 47167 | 899 | 8 |
362815 | 362815 | 2020-07-23 | Tipton | Tennessee | 47167 | 877 | 8 |
359608 | 359608 | 2020-07-22 | Tipton | Tennessee | 47167 | 840 | 8 |
356404 | 356404 | 2020-07-21 | Tipton | Tennessee | 47167 | 835 | 8 |
353201 | 353201 | 2020-07-20 | Tipton | Tennessee | 47167 | 809 | 8 |
349998 | 349998 | 2020-07-19 | Tipton | Tennessee | 47167 | 798 | 8 |
346798 | 346798 | 2020-07-18 | Tipton | Tennessee | 47167 | 792 | 8 |
343598 | 343598 | 2020-07-17 | Tipton | Tennessee | 47167 | 780 | 8 |
340400 | 340400 | 2020-07-16 | Tipton | Tennessee | 47167 | 763 | 7 |
337203 | 337203 | 2020-07-15 | Tipton | Tennessee | 47167 | 740 | 7 |
334009 | 334009 | 2020-07-14 | Tipton | Tennessee | 47167 | 727 | 7 |
330817 | 330817 | 2020-07-13 | Tipton | Tennessee | 47167 | 717 | 7 |
327631 | 327631 | 2020-07-12 | Tipton | Tennessee | 47167 | 698 | 7 |
324446 | 324446 | 2020-07-11 | Tipton | Tennessee | 47167 | 696 | 7 |
321265 | 321265 | 2020-07-10 | Tipton | Tennessee | 47167 | 692 | 6 |
318087 | 318087 | 2020-07-09 | Tipton | Tennessee | 47167 | 674 | 6 |
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);