ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Haywood" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955454 | 955454 | 2021-01-22 | Haywood | Tennessee | 47075 | 2437 | 47 |
952209 | 952209 | 2021-01-21 | Haywood | Tennessee | 47075 | 2417 | 47 |
948964 | 948964 | 2021-01-20 | Haywood | Tennessee | 47075 | 2410 | 45 |
945718 | 945718 | 2021-01-19 | Haywood | Tennessee | 47075 | 2406 | 45 |
942471 | 942471 | 2021-01-18 | Haywood | Tennessee | 47075 | 2398 | 45 |
939226 | 939226 | 2021-01-17 | Haywood | Tennessee | 47075 | 2397 | 45 |
935981 | 935981 | 2021-01-16 | Haywood | Tennessee | 47075 | 2385 | 45 |
932736 | 932736 | 2021-01-15 | Haywood | Tennessee | 47075 | 2372 | 45 |
929491 | 929491 | 2021-01-14 | Haywood | Tennessee | 47075 | 2346 | 44 |
926246 | 926246 | 2021-01-13 | Haywood | Tennessee | 47075 | 2344 | 44 |
923000 | 923000 | 2021-01-12 | Haywood | Tennessee | 47075 | 2335 | 44 |
919755 | 919755 | 2021-01-11 | Haywood | Tennessee | 47075 | 2331 | 43 |
916510 | 916510 | 2021-01-10 | Haywood | Tennessee | 47075 | 2327 | 41 |
913265 | 913265 | 2021-01-09 | Haywood | Tennessee | 47075 | 2302 | 41 |
910020 | 910020 | 2021-01-08 | Haywood | Tennessee | 47075 | 2294 | 38 |
906775 | 906775 | 2021-01-07 | Haywood | Tennessee | 47075 | 2282 | 39 |
903529 | 903529 | 2021-01-06 | Haywood | Tennessee | 47075 | 2260 | 38 |
900284 | 900284 | 2021-01-05 | Haywood | Tennessee | 47075 | 2250 | 37 |
897039 | 897039 | 2021-01-04 | Haywood | Tennessee | 47075 | 2241 | 37 |
893793 | 893793 | 2021-01-03 | Haywood | Tennessee | 47075 | 2230 | 36 |
890547 | 890547 | 2021-01-02 | Haywood | Tennessee | 47075 | 2225 | 36 |
887300 | 887300 | 2021-01-01 | Haywood | Tennessee | 47075 | 2169 | 36 |
884055 | 884055 | 2020-12-31 | Haywood | Tennessee | 47075 | 2169 | 36 |
880810 | 880810 | 2020-12-30 | Haywood | Tennessee | 47075 | 2156 | 36 |
877565 | 877565 | 2020-12-29 | Haywood | Tennessee | 47075 | 2145 | 36 |
874320 | 874320 | 2020-12-28 | Haywood | Tennessee | 47075 | 2131 | 36 |
871075 | 871075 | 2020-12-27 | Haywood | Tennessee | 47075 | 2125 | 35 |
867830 | 867830 | 2020-12-26 | Haywood | Tennessee | 47075 | 2122 | 35 |
864585 | 864585 | 2020-12-25 | Haywood | Tennessee | 47075 | 2112 | 35 |
861340 | 861340 | 2020-12-24 | Haywood | Tennessee | 47075 | 2093 | 35 |
858095 | 858095 | 2020-12-23 | Haywood | Tennessee | 47075 | 2075 | 35 |
854850 | 854850 | 2020-12-22 | Haywood | Tennessee | 47075 | 2057 | 34 |
851605 | 851605 | 2020-12-21 | Haywood | Tennessee | 47075 | 2053 | 34 |
848360 | 848360 | 2020-12-20 | Haywood | Tennessee | 47075 | 2031 | 34 |
845115 | 845115 | 2020-12-19 | Haywood | Tennessee | 47075 | 2008 | 34 |
841869 | 841869 | 2020-12-18 | Haywood | Tennessee | 47075 | 2000 | 34 |
838624 | 838624 | 2020-12-17 | Haywood | Tennessee | 47075 | 1970 | 33 |
835378 | 835378 | 2020-12-16 | Haywood | Tennessee | 47075 | 1951 | 31 |
832132 | 832132 | 2020-12-15 | Haywood | Tennessee | 47075 | 1917 | 31 |
828885 | 828885 | 2020-12-14 | Haywood | Tennessee | 47075 | 1904 | 31 |
825639 | 825639 | 2020-12-13 | Haywood | Tennessee | 47075 | 1867 | 31 |
822392 | 822392 | 2020-12-12 | Haywood | Tennessee | 47075 | 1845 | 30 |
819146 | 819146 | 2020-12-11 | Haywood | Tennessee | 47075 | 1822 | 30 |
815900 | 815900 | 2020-12-10 | Haywood | Tennessee | 47075 | 1797 | 30 |
812654 | 812654 | 2020-12-09 | Haywood | Tennessee | 47075 | 1789 | 30 |
809410 | 809410 | 2020-12-08 | Haywood | Tennessee | 47075 | 1758 | 30 |
806165 | 806165 | 2020-12-07 | Haywood | Tennessee | 47075 | 1737 | 30 |
802920 | 802920 | 2020-12-06 | Haywood | Tennessee | 47075 | 1717 | 30 |
799675 | 799675 | 2020-12-05 | Haywood | Tennessee | 47075 | 1704 | 30 |
796430 | 796430 | 2020-12-04 | Haywood | Tennessee | 47075 | 1695 | 30 |
793185 | 793185 | 2020-12-03 | Haywood | Tennessee | 47075 | 1688 | 30 |
789940 | 789940 | 2020-12-02 | Haywood | Tennessee | 47075 | 1685 | 30 |
786695 | 786695 | 2020-12-01 | Haywood | Tennessee | 47075 | 1665 | 30 |
783451 | 783451 | 2020-11-30 | Haywood | Tennessee | 47075 | 1658 | 30 |
780206 | 780206 | 2020-11-29 | Haywood | Tennessee | 47075 | 1633 | 30 |
776960 | 776960 | 2020-11-28 | Haywood | Tennessee | 47075 | 1629 | 30 |
773715 | 773715 | 2020-11-27 | Haywood | Tennessee | 47075 | 1608 | 30 |
770470 | 770470 | 2020-11-26 | Haywood | Tennessee | 47075 | 1602 | 30 |
767224 | 767224 | 2020-11-25 | Haywood | Tennessee | 47075 | 1600 | 30 |
763979 | 763979 | 2020-11-24 | Haywood | Tennessee | 47075 | 1595 | 30 |
760734 | 760734 | 2020-11-23 | Haywood | Tennessee | 47075 | 1596 | 29 |
757489 | 757489 | 2020-11-22 | Haywood | Tennessee | 47075 | 1591 | 29 |
754242 | 754242 | 2020-11-21 | Haywood | Tennessee | 47075 | 1576 | 29 |
750996 | 750996 | 2020-11-20 | Haywood | Tennessee | 47075 | 1553 | 29 |
747750 | 747750 | 2020-11-19 | Haywood | Tennessee | 47075 | 1534 | 29 |
744504 | 744504 | 2020-11-18 | Haywood | Tennessee | 47075 | 1527 | 29 |
741257 | 741257 | 2020-11-17 | Haywood | Tennessee | 47075 | 1506 | 29 |
738011 | 738011 | 2020-11-16 | Haywood | Tennessee | 47075 | 1511 | 28 |
734767 | 734767 | 2020-11-15 | Haywood | Tennessee | 47075 | 1486 | 28 |
731521 | 731521 | 2020-11-14 | Haywood | Tennessee | 47075 | 1474 | 28 |
728277 | 728277 | 2020-11-13 | Haywood | Tennessee | 47075 | 1460 | 28 |
725033 | 725033 | 2020-11-12 | Haywood | Tennessee | 47075 | 1445 | 28 |
721790 | 721790 | 2020-11-11 | Haywood | Tennessee | 47075 | 1434 | 28 |
718547 | 718547 | 2020-11-10 | Haywood | Tennessee | 47075 | 1425 | 28 |
715304 | 715304 | 2020-11-09 | Haywood | Tennessee | 47075 | 1421 | 28 |
712060 | 712060 | 2020-11-08 | Haywood | Tennessee | 47075 | 1405 | 28 |
708816 | 708816 | 2020-11-07 | Haywood | Tennessee | 47075 | 1392 | 28 |
705573 | 705573 | 2020-11-06 | Haywood | Tennessee | 47075 | 1378 | 28 |
702330 | 702330 | 2020-11-05 | Haywood | Tennessee | 47075 | 1378 | 28 |
699086 | 699086 | 2020-11-04 | Haywood | Tennessee | 47075 | 1371 | 28 |
695843 | 695843 | 2020-11-03 | Haywood | Tennessee | 47075 | 1353 | 28 |
692601 | 692601 | 2020-11-02 | Haywood | Tennessee | 47075 | 1352 | 28 |
689357 | 689357 | 2020-11-01 | Haywood | Tennessee | 47075 | 1339 | 28 |
686112 | 686112 | 2020-10-31 | Haywood | Tennessee | 47075 | 1338 | 28 |
682869 | 682869 | 2020-10-30 | Haywood | Tennessee | 47075 | 1334 | 28 |
679626 | 679626 | 2020-10-29 | Haywood | Tennessee | 47075 | 1320 | 28 |
676383 | 676383 | 2020-10-28 | Haywood | Tennessee | 47075 | 1317 | 28 |
673140 | 673140 | 2020-10-27 | Haywood | Tennessee | 47075 | 1305 | 28 |
669898 | 669898 | 2020-10-26 | Haywood | Tennessee | 47075 | 1297 | 28 |
666654 | 666654 | 2020-10-25 | Haywood | Tennessee | 47075 | 1295 | 27 |
663409 | 663409 | 2020-10-24 | Haywood | Tennessee | 47075 | 1272 | 27 |
660165 | 660165 | 2020-10-23 | Haywood | Tennessee | 47075 | 1253 | 27 |
656921 | 656921 | 2020-10-22 | Haywood | Tennessee | 47075 | 1210 | 27 |
653676 | 653676 | 2020-10-21 | Haywood | Tennessee | 47075 | 1200 | 26 |
650431 | 650431 | 2020-10-20 | Haywood | Tennessee | 47075 | 1195 | 26 |
647187 | 647187 | 2020-10-19 | Haywood | Tennessee | 47075 | 1190 | 25 |
643941 | 643941 | 2020-10-18 | Haywood | Tennessee | 47075 | 1183 | 25 |
640693 | 640693 | 2020-10-17 | Haywood | Tennessee | 47075 | 1179 | 25 |
637447 | 637447 | 2020-10-16 | Haywood | Tennessee | 47075 | 1173 | 25 |
634201 | 634201 | 2020-10-15 | Haywood | Tennessee | 47075 | 1169 | 25 |
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);