ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 47011 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637415 | 637415 | 2020-10-16 | Bradley | Tennessee | 47011 | 3312 | 21 |
634169 | 634169 | 2020-10-15 | Bradley | Tennessee | 47011 | 3306 | 21 |
630924 | 630924 | 2020-10-14 | Bradley | Tennessee | 47011 | 3279 | 20 |
627680 | 627680 | 2020-10-13 | Bradley | Tennessee | 47011 | 3266 | 20 |
624438 | 624438 | 2020-10-12 | Bradley | Tennessee | 47011 | 3250 | 20 |
621195 | 621195 | 2020-10-11 | Bradley | Tennessee | 47011 | 3225 | 20 |
617952 | 617952 | 2020-10-10 | Bradley | Tennessee | 47011 | 3199 | 20 |
614710 | 614710 | 2020-10-09 | Bradley | Tennessee | 47011 | 3186 | 19 |
611469 | 611469 | 2020-10-08 | Bradley | Tennessee | 47011 | 3167 | 19 |
608227 | 608227 | 2020-10-07 | Bradley | Tennessee | 47011 | 3139 | 19 |
604984 | 604984 | 2020-10-06 | Bradley | Tennessee | 47011 | 3121 | 19 |
601742 | 601742 | 2020-10-05 | Bradley | Tennessee | 47011 | 3093 | 19 |
598499 | 598499 | 2020-10-04 | Bradley | Tennessee | 47011 | 3060 | 19 |
595256 | 595256 | 2020-10-03 | Bradley | Tennessee | 47011 | 3022 | 18 |
592015 | 592015 | 2020-10-02 | Bradley | Tennessee | 47011 | 3009 | 17 |
588774 | 588774 | 2020-10-01 | Bradley | Tennessee | 47011 | 2998 | 17 |
585534 | 585534 | 2020-09-30 | Bradley | Tennessee | 47011 | 2988 | 17 |
582294 | 582294 | 2020-09-29 | Bradley | Tennessee | 47011 | 2972 | 17 |
579054 | 579054 | 2020-09-28 | Bradley | Tennessee | 47011 | 2967 | 17 |
575813 | 575813 | 2020-09-27 | Bradley | Tennessee | 47011 | 2962 | 17 |
572569 | 572569 | 2020-09-26 | Bradley | Tennessee | 47011 | 2934 | 17 |
569327 | 569327 | 2020-09-25 | Bradley | Tennessee | 47011 | 2914 | 17 |
566086 | 566086 | 2020-09-24 | Bradley | Tennessee | 47011 | 2893 | 17 |
562845 | 562845 | 2020-09-23 | Bradley | Tennessee | 47011 | 2883 | 17 |
559608 | 559608 | 2020-09-22 | Bradley | Tennessee | 47011 | 2868 | 17 |
556371 | 556371 | 2020-09-21 | Bradley | Tennessee | 47011 | 2858 | 16 |
553134 | 553134 | 2020-09-20 | Bradley | Tennessee | 47011 | 2850 | 16 |
549895 | 549895 | 2020-09-19 | Bradley | Tennessee | 47011 | 2818 | 16 |
546656 | 546656 | 2020-09-18 | Bradley | Tennessee | 47011 | 2800 | 16 |
543419 | 543419 | 2020-09-17 | Bradley | Tennessee | 47011 | 2779 | 16 |
540183 | 540183 | 2020-09-16 | Bradley | Tennessee | 47011 | 2767 | 16 |
536946 | 536946 | 2020-09-15 | Bradley | Tennessee | 47011 | 2747 | 16 |
533710 | 533710 | 2020-09-14 | Bradley | Tennessee | 47011 | 2740 | 16 |
530475 | 530475 | 2020-09-13 | Bradley | Tennessee | 47011 | 2710 | 16 |
527238 | 527238 | 2020-09-12 | Bradley | Tennessee | 47011 | 2683 | 16 |
524002 | 524002 | 2020-09-11 | Bradley | Tennessee | 47011 | 2683 | 16 |
520766 | 520766 | 2020-09-10 | Bradley | Tennessee | 47011 | 2648 | 16 |
517530 | 517530 | 2020-09-09 | Bradley | Tennessee | 47011 | 2606 | 16 |
514295 | 514295 | 2020-09-08 | Bradley | Tennessee | 47011 | 2595 | 16 |
511062 | 511062 | 2020-09-07 | Bradley | Tennessee | 47011 | 2587 | 16 |
507829 | 507829 | 2020-09-06 | Bradley | Tennessee | 47011 | 2578 | 16 |
504597 | 504597 | 2020-09-05 | Bradley | Tennessee | 47011 | 2569 | 16 |
501363 | 501363 | 2020-09-04 | Bradley | Tennessee | 47011 | 2535 | 16 |
498129 | 498129 | 2020-09-03 | Bradley | Tennessee | 47011 | 2526 | 16 |
494896 | 494896 | 2020-09-02 | Bradley | Tennessee | 47011 | 2524 | 16 |
491662 | 491662 | 2020-09-01 | Bradley | Tennessee | 47011 | 2501 | 16 |
488429 | 488429 | 2020-08-31 | Bradley | Tennessee | 47011 | 2473 | 16 |
485196 | 485196 | 2020-08-30 | Bradley | Tennessee | 47011 | 2468 | 16 |
481961 | 481961 | 2020-08-29 | Bradley | Tennessee | 47011 | 2460 | 16 |
478727 | 478727 | 2020-08-28 | Bradley | Tennessee | 47011 | 2439 | 16 |
475494 | 475494 | 2020-08-27 | Bradley | Tennessee | 47011 | 2416 | 16 |
472261 | 472261 | 2020-08-26 | Bradley | Tennessee | 47011 | 2398 | 16 |
469029 | 469029 | 2020-08-25 | Bradley | Tennessee | 47011 | 2370 | 16 |
465800 | 465800 | 2020-08-24 | Bradley | Tennessee | 47011 | 2359 | 16 |
462571 | 462571 | 2020-08-23 | Bradley | Tennessee | 47011 | 2336 | 16 |
459343 | 459343 | 2020-08-22 | Bradley | Tennessee | 47011 | 2306 | 16 |
456115 | 456115 | 2020-08-21 | Bradley | Tennessee | 47011 | 2276 | 16 |
452887 | 452887 | 2020-08-20 | Bradley | Tennessee | 47011 | 2247 | 16 |
449659 | 449659 | 2020-08-19 | Bradley | Tennessee | 47011 | 2232 | 16 |
446431 | 446431 | 2020-08-18 | Bradley | Tennessee | 47011 | 2192 | 16 |
443205 | 443205 | 2020-08-17 | Bradley | Tennessee | 47011 | 2175 | 16 |
439978 | 439978 | 2020-08-16 | Bradley | Tennessee | 47011 | 2166 | 16 |
436753 | 436753 | 2020-08-15 | Bradley | Tennessee | 47011 | 2126 | 16 |
433526 | 433526 | 2020-08-14 | Bradley | Tennessee | 47011 | 2102 | 15 |
430301 | 430301 | 2020-08-13 | Bradley | Tennessee | 47011 | 2066 | 15 |
427074 | 427074 | 2020-08-12 | Bradley | Tennessee | 47011 | 2013 | 15 |
423851 | 423851 | 2020-08-11 | Bradley | Tennessee | 47011 | 1991 | 15 |
420629 | 420629 | 2020-08-10 | Bradley | Tennessee | 47011 | 1956 | 13 |
417408 | 417408 | 2020-08-09 | Bradley | Tennessee | 47011 | 1943 | 12 |
414187 | 414187 | 2020-08-08 | Bradley | Tennessee | 47011 | 1903 | 12 |
410967 | 410967 | 2020-08-07 | Bradley | Tennessee | 47011 | 1874 | 12 |
407748 | 407748 | 2020-08-06 | Bradley | Tennessee | 47011 | 1817 | 12 |
404528 | 404528 | 2020-08-05 | Bradley | Tennessee | 47011 | 1771 | 12 |
401310 | 401310 | 2020-08-04 | Bradley | Tennessee | 47011 | 1739 | 10 |
398095 | 398095 | 2020-08-03 | Bradley | Tennessee | 47011 | 1713 | 10 |
394878 | 394878 | 2020-08-02 | Bradley | Tennessee | 47011 | 1705 | 10 |
391662 | 391662 | 2020-08-01 | Bradley | Tennessee | 47011 | 1681 | 10 |
388445 | 388445 | 2020-07-31 | Bradley | Tennessee | 47011 | 1651 | 10 |
385228 | 385228 | 2020-07-30 | Bradley | Tennessee | 47011 | 1593 | 10 |
382010 | 382010 | 2020-07-29 | Bradley | Tennessee | 47011 | 1555 | 10 |
378793 | 378793 | 2020-07-28 | Bradley | Tennessee | 47011 | 1525 | 10 |
375577 | 375577 | 2020-07-27 | Bradley | Tennessee | 47011 | 1492 | 10 |
372364 | 372364 | 2020-07-26 | Bradley | Tennessee | 47011 | 1449 | 9 |
369152 | 369152 | 2020-07-25 | Bradley | Tennessee | 47011 | 1390 | 9 |
365943 | 365943 | 2020-07-24 | Bradley | Tennessee | 47011 | 1359 | 9 |
362737 | 362737 | 2020-07-23 | Bradley | Tennessee | 47011 | 1330 | 9 |
359530 | 359530 | 2020-07-22 | Bradley | Tennessee | 47011 | 1284 | 8 |
356326 | 356326 | 2020-07-21 | Bradley | Tennessee | 47011 | 1271 | 8 |
353123 | 353123 | 2020-07-20 | Bradley | Tennessee | 47011 | 1239 | 7 |
349920 | 349920 | 2020-07-19 | Bradley | Tennessee | 47011 | 1205 | 7 |
346720 | 346720 | 2020-07-18 | Bradley | Tennessee | 47011 | 1177 | 7 |
343520 | 343520 | 2020-07-17 | Bradley | Tennessee | 47011 | 1165 | 6 |
340322 | 340322 | 2020-07-16 | Bradley | Tennessee | 47011 | 1114 | 6 |
337125 | 337125 | 2020-07-15 | Bradley | Tennessee | 47011 | 1096 | 6 |
333931 | 333931 | 2020-07-14 | Bradley | Tennessee | 47011 | 1061 | 5 |
330739 | 330739 | 2020-07-13 | Bradley | Tennessee | 47011 | 1010 | 4 |
327553 | 327553 | 2020-07-12 | Bradley | Tennessee | 47011 | 972 | 4 |
324368 | 324368 | 2020-07-11 | Bradley | Tennessee | 47011 | 959 | 4 |
321187 | 321187 | 2020-07-10 | Bradley | Tennessee | 47011 | 925 | 4 |
318009 | 318009 | 2020-07-09 | Bradley | Tennessee | 47011 | 889 | 4 |
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);