ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 47147 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637483 | 637483 | 2020-10-16 | Robertson | Tennessee | 47147 | 2426 | 40 |
634237 | 634237 | 2020-10-15 | Robertson | Tennessee | 47147 | 2419 | 39 |
630992 | 630992 | 2020-10-14 | Robertson | Tennessee | 47147 | 2401 | 39 |
627748 | 627748 | 2020-10-13 | Robertson | Tennessee | 47147 | 2396 | 39 |
624506 | 624506 | 2020-10-12 | Robertson | Tennessee | 47147 | 2387 | 39 |
621263 | 621263 | 2020-10-11 | Robertson | Tennessee | 47147 | 2368 | 39 |
618020 | 618020 | 2020-10-10 | Robertson | Tennessee | 47147 | 2352 | 39 |
614778 | 614778 | 2020-10-09 | Robertson | Tennessee | 47147 | 2348 | 39 |
611537 | 611537 | 2020-10-08 | Robertson | Tennessee | 47147 | 2342 | 39 |
608295 | 608295 | 2020-10-07 | Robertson | Tennessee | 47147 | 2326 | 38 |
605052 | 605052 | 2020-10-06 | Robertson | Tennessee | 47147 | 2305 | 38 |
601810 | 601810 | 2020-10-05 | Robertson | Tennessee | 47147 | 2298 | 38 |
598567 | 598567 | 2020-10-04 | Robertson | Tennessee | 47147 | 2285 | 38 |
595324 | 595324 | 2020-10-03 | Robertson | Tennessee | 47147 | 2279 | 41 |
592083 | 592083 | 2020-10-02 | Robertson | Tennessee | 47147 | 2272 | 39 |
588842 | 588842 | 2020-10-01 | Robertson | Tennessee | 47147 | 2266 | 39 |
585602 | 585602 | 2020-09-30 | Robertson | Tennessee | 47147 | 2255 | 39 |
582362 | 582362 | 2020-09-29 | Robertson | Tennessee | 47147 | 2239 | 39 |
579122 | 579122 | 2020-09-28 | Robertson | Tennessee | 47147 | 2231 | 35 |
575881 | 575881 | 2020-09-27 | Robertson | Tennessee | 47147 | 2225 | 35 |
572637 | 572637 | 2020-09-26 | Robertson | Tennessee | 47147 | 2210 | 35 |
569395 | 569395 | 2020-09-25 | Robertson | Tennessee | 47147 | 2203 | 35 |
566154 | 566154 | 2020-09-24 | Robertson | Tennessee | 47147 | 2190 | 35 |
562913 | 562913 | 2020-09-23 | Robertson | Tennessee | 47147 | 2188 | 35 |
559676 | 559676 | 2020-09-22 | Robertson | Tennessee | 47147 | 2173 | 34 |
556439 | 556439 | 2020-09-21 | Robertson | Tennessee | 47147 | 2172 | 33 |
553202 | 553202 | 2020-09-20 | Robertson | Tennessee | 47147 | 2162 | 33 |
549963 | 549963 | 2020-09-19 | Robertson | Tennessee | 47147 | 2151 | 33 |
546724 | 546724 | 2020-09-18 | Robertson | Tennessee | 47147 | 2141 | 34 |
543487 | 543487 | 2020-09-17 | Robertson | Tennessee | 47147 | 2126 | 34 |
540251 | 540251 | 2020-09-16 | Robertson | Tennessee | 47147 | 2120 | 33 |
537014 | 537014 | 2020-09-15 | Robertson | Tennessee | 47147 | 2107 | 32 |
533778 | 533778 | 2020-09-14 | Robertson | Tennessee | 47147 | 2091 | 32 |
530543 | 530543 | 2020-09-13 | Robertson | Tennessee | 47147 | 2070 | 31 |
527306 | 527306 | 2020-09-12 | Robertson | Tennessee | 47147 | 2055 | 31 |
524070 | 524070 | 2020-09-11 | Robertson | Tennessee | 47147 | 2051 | 31 |
520834 | 520834 | 2020-09-10 | Robertson | Tennessee | 47147 | 2041 | 31 |
517598 | 517598 | 2020-09-09 | Robertson | Tennessee | 47147 | 2015 | 31 |
514363 | 514363 | 2020-09-08 | Robertson | Tennessee | 47147 | 2014 | 31 |
511130 | 511130 | 2020-09-07 | Robertson | Tennessee | 47147 | 1991 | 30 |
507897 | 507897 | 2020-09-06 | Robertson | Tennessee | 47147 | 1987 | 30 |
504665 | 504665 | 2020-09-05 | Robertson | Tennessee | 47147 | 1971 | 30 |
501431 | 501431 | 2020-09-04 | Robertson | Tennessee | 47147 | 1956 | 29 |
498197 | 498197 | 2020-09-03 | Robertson | Tennessee | 47147 | 1942 | 29 |
494964 | 494964 | 2020-09-02 | Robertson | Tennessee | 47147 | 1908 | 26 |
491730 | 491730 | 2020-09-01 | Robertson | Tennessee | 47147 | 1892 | 26 |
488497 | 488497 | 2020-08-31 | Robertson | Tennessee | 47147 | 1886 | 26 |
485264 | 485264 | 2020-08-30 | Robertson | Tennessee | 47147 | 1885 | 26 |
482029 | 482029 | 2020-08-29 | Robertson | Tennessee | 47147 | 1869 | 26 |
478795 | 478795 | 2020-08-28 | Robertson | Tennessee | 47147 | 1790 | 26 |
475562 | 475562 | 2020-08-27 | Robertson | Tennessee | 47147 | 1788 | 26 |
472329 | 472329 | 2020-08-26 | Robertson | Tennessee | 47147 | 1779 | 25 |
469097 | 469097 | 2020-08-25 | Robertson | Tennessee | 47147 | 1772 | 25 |
465868 | 465868 | 2020-08-24 | Robertson | Tennessee | 47147 | 1751 | 25 |
462639 | 462639 | 2020-08-23 | Robertson | Tennessee | 47147 | 1748 | 25 |
459411 | 459411 | 2020-08-22 | Robertson | Tennessee | 47147 | 1732 | 25 |
456183 | 456183 | 2020-08-21 | Robertson | Tennessee | 47147 | 1708 | 25 |
452955 | 452955 | 2020-08-20 | Robertson | Tennessee | 47147 | 1694 | 23 |
449727 | 449727 | 2020-08-19 | Robertson | Tennessee | 47147 | 1678 | 23 |
446499 | 446499 | 2020-08-18 | Robertson | Tennessee | 47147 | 1650 | 22 |
443273 | 443273 | 2020-08-17 | Robertson | Tennessee | 47147 | 1647 | 21 |
440046 | 440046 | 2020-08-16 | Robertson | Tennessee | 47147 | 1638 | 21 |
436821 | 436821 | 2020-08-15 | Robertson | Tennessee | 47147 | 1630 | 21 |
433594 | 433594 | 2020-08-14 | Robertson | Tennessee | 47147 | 1616 | 21 |
430369 | 430369 | 2020-08-13 | Robertson | Tennessee | 47147 | 1596 | 21 |
427142 | 427142 | 2020-08-12 | Robertson | Tennessee | 47147 | 1587 | 20 |
423919 | 423919 | 2020-08-11 | Robertson | Tennessee | 47147 | 1578 | 20 |
420697 | 420697 | 2020-08-10 | Robertson | Tennessee | 47147 | 1567 | 20 |
417476 | 417476 | 2020-08-09 | Robertson | Tennessee | 47147 | 1558 | 19 |
414255 | 414255 | 2020-08-08 | Robertson | Tennessee | 47147 | 1535 | 19 |
411035 | 411035 | 2020-08-07 | Robertson | Tennessee | 47147 | 1521 | 19 |
407816 | 407816 | 2020-08-06 | Robertson | Tennessee | 47147 | 1506 | 19 |
404596 | 404596 | 2020-08-05 | Robertson | Tennessee | 47147 | 1475 | 19 |
401378 | 401378 | 2020-08-04 | Robertson | Tennessee | 47147 | 1459 | 19 |
398163 | 398163 | 2020-08-03 | Robertson | Tennessee | 47147 | 1450 | 17 |
394946 | 394946 | 2020-08-02 | Robertson | Tennessee | 47147 | 1432 | 16 |
391730 | 391730 | 2020-08-01 | Robertson | Tennessee | 47147 | 1417 | 16 |
388513 | 388513 | 2020-07-31 | Robertson | Tennessee | 47147 | 1409 | 16 |
385296 | 385296 | 2020-07-30 | Robertson | Tennessee | 47147 | 1374 | 16 |
382078 | 382078 | 2020-07-29 | Robertson | Tennessee | 47147 | 1344 | 16 |
378861 | 378861 | 2020-07-28 | Robertson | Tennessee | 47147 | 1315 | 16 |
375645 | 375645 | 2020-07-27 | Robertson | Tennessee | 47147 | 1296 | 16 |
372432 | 372432 | 2020-07-26 | Robertson | Tennessee | 47147 | 1278 | 16 |
369220 | 369220 | 2020-07-25 | Robertson | Tennessee | 47147 | 1236 | 16 |
366011 | 366011 | 2020-07-24 | Robertson | Tennessee | 47147 | 1225 | 16 |
362805 | 362805 | 2020-07-23 | Robertson | Tennessee | 47147 | 1197 | 16 |
359598 | 359598 | 2020-07-22 | Robertson | Tennessee | 47147 | 1184 | 15 |
356394 | 356394 | 2020-07-21 | Robertson | Tennessee | 47147 | 1160 | 15 |
353191 | 353191 | 2020-07-20 | Robertson | Tennessee | 47147 | 1143 | 14 |
349988 | 349988 | 2020-07-19 | Robertson | Tennessee | 47147 | 1130 | 14 |
346788 | 346788 | 2020-07-18 | Robertson | Tennessee | 47147 | 1105 | 14 |
343588 | 343588 | 2020-07-17 | Robertson | Tennessee | 47147 | 1076 | 14 |
340390 | 340390 | 2020-07-16 | Robertson | Tennessee | 47147 | 1084 | 14 |
337193 | 337193 | 2020-07-15 | Robertson | Tennessee | 47147 | 1010 | 13 |
333999 | 333999 | 2020-07-14 | Robertson | Tennessee | 47147 | 984 | 13 |
330807 | 330807 | 2020-07-13 | Robertson | Tennessee | 47147 | 973 | 13 |
327621 | 327621 | 2020-07-12 | Robertson | Tennessee | 47147 | 948 | 13 |
324436 | 324436 | 2020-07-11 | Robertson | Tennessee | 47147 | 924 | 13 |
321255 | 321255 | 2020-07-10 | Robertson | Tennessee | 47147 | 901 | 13 |
318077 | 318077 | 2020-07-09 | Robertson | Tennessee | 47147 | 882 | 13 |
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);