ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 47155 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637487 | 637487 | 2020-10-16 | Sevier | Tennessee | 47155 | 3054 | 20 |
634241 | 634241 | 2020-10-15 | Sevier | Tennessee | 47155 | 3044 | 20 |
630996 | 630996 | 2020-10-14 | Sevier | Tennessee | 47155 | 3006 | 19 |
627752 | 627752 | 2020-10-13 | Sevier | Tennessee | 47155 | 2973 | 19 |
624510 | 624510 | 2020-10-12 | Sevier | Tennessee | 47155 | 2944 | 19 |
621267 | 621267 | 2020-10-11 | Sevier | Tennessee | 47155 | 2910 | 19 |
618024 | 618024 | 2020-10-10 | Sevier | Tennessee | 47155 | 2886 | 19 |
614782 | 614782 | 2020-10-09 | Sevier | Tennessee | 47155 | 2871 | 19 |
611541 | 611541 | 2020-10-08 | Sevier | Tennessee | 47155 | 2857 | 19 |
608299 | 608299 | 2020-10-07 | Sevier | Tennessee | 47155 | 2811 | 18 |
605056 | 605056 | 2020-10-06 | Sevier | Tennessee | 47155 | 2786 | 18 |
601814 | 601814 | 2020-10-05 | Sevier | Tennessee | 47155 | 2767 | 17 |
598571 | 598571 | 2020-10-04 | Sevier | Tennessee | 47155 | 2747 | 17 |
595328 | 595328 | 2020-10-03 | Sevier | Tennessee | 47155 | 2739 | 17 |
592087 | 592087 | 2020-10-02 | Sevier | Tennessee | 47155 | 2715 | 16 |
588846 | 588846 | 2020-10-01 | Sevier | Tennessee | 47155 | 2698 | 16 |
585606 | 585606 | 2020-09-30 | Sevier | Tennessee | 47155 | 2677 | 15 |
582366 | 582366 | 2020-09-29 | Sevier | Tennessee | 47155 | 2664 | 15 |
579126 | 579126 | 2020-09-28 | Sevier | Tennessee | 47155 | 2647 | 15 |
575885 | 575885 | 2020-09-27 | Sevier | Tennessee | 47155 | 2638 | 15 |
572641 | 572641 | 2020-09-26 | Sevier | Tennessee | 47155 | 2623 | 15 |
569399 | 569399 | 2020-09-25 | Sevier | Tennessee | 47155 | 2596 | 15 |
566158 | 566158 | 2020-09-24 | Sevier | Tennessee | 47155 | 2570 | 15 |
562917 | 562917 | 2020-09-23 | Sevier | Tennessee | 47155 | 2553 | 15 |
559680 | 559680 | 2020-09-22 | Sevier | Tennessee | 47155 | 2537 | 15 |
556443 | 556443 | 2020-09-21 | Sevier | Tennessee | 47155 | 2518 | 13 |
553206 | 553206 | 2020-09-20 | Sevier | Tennessee | 47155 | 2515 | 13 |
549967 | 549967 | 2020-09-19 | Sevier | Tennessee | 47155 | 2500 | 13 |
546728 | 546728 | 2020-09-18 | Sevier | Tennessee | 47155 | 2493 | 13 |
543491 | 543491 | 2020-09-17 | Sevier | Tennessee | 47155 | 2467 | 13 |
540255 | 540255 | 2020-09-16 | Sevier | Tennessee | 47155 | 2459 | 13 |
537018 | 537018 | 2020-09-15 | Sevier | Tennessee | 47155 | 2443 | 13 |
533782 | 533782 | 2020-09-14 | Sevier | Tennessee | 47155 | 2440 | 13 |
530547 | 530547 | 2020-09-13 | Sevier | Tennessee | 47155 | 2420 | 13 |
527310 | 527310 | 2020-09-12 | Sevier | Tennessee | 47155 | 2401 | 13 |
524074 | 524074 | 2020-09-11 | Sevier | Tennessee | 47155 | 2393 | 13 |
520838 | 520838 | 2020-09-10 | Sevier | Tennessee | 47155 | 2374 | 13 |
517602 | 517602 | 2020-09-09 | Sevier | Tennessee | 47155 | 2342 | 13 |
514367 | 514367 | 2020-09-08 | Sevier | Tennessee | 47155 | 2329 | 13 |
511134 | 511134 | 2020-09-07 | Sevier | Tennessee | 47155 | 2326 | 13 |
507901 | 507901 | 2020-09-06 | Sevier | Tennessee | 47155 | 2325 | 13 |
504669 | 504669 | 2020-09-05 | Sevier | Tennessee | 47155 | 2315 | 13 |
501435 | 501435 | 2020-09-04 | Sevier | Tennessee | 47155 | 2302 | 13 |
498201 | 498201 | 2020-09-03 | Sevier | Tennessee | 47155 | 2283 | 13 |
494968 | 494968 | 2020-09-02 | Sevier | Tennessee | 47155 | 2278 | 12 |
491734 | 491734 | 2020-09-01 | Sevier | Tennessee | 47155 | 2246 | 12 |
488501 | 488501 | 2020-08-31 | Sevier | Tennessee | 47155 | 2236 | 12 |
485268 | 485268 | 2020-08-30 | Sevier | Tennessee | 47155 | 2232 | 12 |
482033 | 482033 | 2020-08-29 | Sevier | Tennessee | 47155 | 2219 | 12 |
478799 | 478799 | 2020-08-28 | Sevier | Tennessee | 47155 | 2211 | 11 |
475566 | 475566 | 2020-08-27 | Sevier | Tennessee | 47155 | 2200 | 11 |
472333 | 472333 | 2020-08-26 | Sevier | Tennessee | 47155 | 2181 | 11 |
469101 | 469101 | 2020-08-25 | Sevier | Tennessee | 47155 | 2157 | 11 |
465872 | 465872 | 2020-08-24 | Sevier | Tennessee | 47155 | 2154 | 11 |
462643 | 462643 | 2020-08-23 | Sevier | Tennessee | 47155 | 2152 | 11 |
459415 | 459415 | 2020-08-22 | Sevier | Tennessee | 47155 | 2140 | 11 |
456187 | 456187 | 2020-08-21 | Sevier | Tennessee | 47155 | 2126 | 11 |
452959 | 452959 | 2020-08-20 | Sevier | Tennessee | 47155 | 2108 | 11 |
449731 | 449731 | 2020-08-19 | Sevier | Tennessee | 47155 | 2096 | 10 |
446503 | 446503 | 2020-08-18 | Sevier | Tennessee | 47155 | 2060 | 10 |
443277 | 443277 | 2020-08-17 | Sevier | Tennessee | 47155 | 2055 | 10 |
440050 | 440050 | 2020-08-16 | Sevier | Tennessee | 47155 | 2038 | 9 |
436825 | 436825 | 2020-08-15 | Sevier | Tennessee | 47155 | 2021 | 9 |
433598 | 433598 | 2020-08-14 | Sevier | Tennessee | 47155 | 1989 | 9 |
430373 | 430373 | 2020-08-13 | Sevier | Tennessee | 47155 | 1947 | 9 |
427146 | 427146 | 2020-08-12 | Sevier | Tennessee | 47155 | 1916 | 9 |
423923 | 423923 | 2020-08-11 | Sevier | Tennessee | 47155 | 1902 | 9 |
420701 | 420701 | 2020-08-10 | Sevier | Tennessee | 47155 | 1894 | 7 |
417480 | 417480 | 2020-08-09 | Sevier | Tennessee | 47155 | 1886 | 7 |
414259 | 414259 | 2020-08-08 | Sevier | Tennessee | 47155 | 1850 | 7 |
411039 | 411039 | 2020-08-07 | Sevier | Tennessee | 47155 | 1830 | 7 |
407820 | 407820 | 2020-08-06 | Sevier | Tennessee | 47155 | 1791 | 6 |
404600 | 404600 | 2020-08-05 | Sevier | Tennessee | 47155 | 1763 | 6 |
401382 | 401382 | 2020-08-04 | Sevier | Tennessee | 47155 | 1756 | 5 |
398167 | 398167 | 2020-08-03 | Sevier | Tennessee | 47155 | 1713 | 5 |
394950 | 394950 | 2020-08-02 | Sevier | Tennessee | 47155 | 1702 | 5 |
391734 | 391734 | 2020-08-01 | Sevier | Tennessee | 47155 | 1679 | 5 |
388517 | 388517 | 2020-07-31 | Sevier | Tennessee | 47155 | 1644 | 5 |
385300 | 385300 | 2020-07-30 | Sevier | Tennessee | 47155 | 1572 | 5 |
382082 | 382082 | 2020-07-29 | Sevier | Tennessee | 47155 | 1541 | 5 |
378865 | 378865 | 2020-07-28 | Sevier | Tennessee | 47155 | 1497 | 5 |
375649 | 375649 | 2020-07-27 | Sevier | Tennessee | 47155 | 1401 | 4 |
372436 | 372436 | 2020-07-26 | Sevier | Tennessee | 47155 | 1357 | 4 |
369224 | 369224 | 2020-07-25 | Sevier | Tennessee | 47155 | 1330 | 4 |
366015 | 366015 | 2020-07-24 | Sevier | Tennessee | 47155 | 1302 | 4 |
362809 | 362809 | 2020-07-23 | Sevier | Tennessee | 47155 | 1269 | 4 |
359602 | 359602 | 2020-07-22 | Sevier | Tennessee | 47155 | 1174 | 4 |
356398 | 356398 | 2020-07-21 | Sevier | Tennessee | 47155 | 1156 | 4 |
353195 | 353195 | 2020-07-20 | Sevier | Tennessee | 47155 | 1112 | 4 |
349992 | 349992 | 2020-07-19 | Sevier | Tennessee | 47155 | 1087 | 4 |
346792 | 346792 | 2020-07-18 | Sevier | Tennessee | 47155 | 1077 | 4 |
343592 | 343592 | 2020-07-17 | Sevier | Tennessee | 47155 | 1052 | 4 |
340394 | 340394 | 2020-07-16 | Sevier | Tennessee | 47155 | 1010 | 4 |
337197 | 337197 | 2020-07-15 | Sevier | Tennessee | 47155 | 978 | 4 |
334003 | 334003 | 2020-07-14 | Sevier | Tennessee | 47155 | 942 | 4 |
330811 | 330811 | 2020-07-13 | Sevier | Tennessee | 47155 | 924 | 4 |
327625 | 327625 | 2020-07-12 | Sevier | Tennessee | 47155 | 912 | 3 |
324440 | 324440 | 2020-07-11 | Sevier | Tennessee | 47155 | 915 | 3 |
321259 | 321259 | 2020-07-10 | Sevier | Tennessee | 47155 | 884 | 3 |
318081 | 318081 | 2020-07-09 | Sevier | Tennessee | 47155 | 863 | 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);