ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 47115 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955472 | 955472 | 2021-01-22 | Marion | Tennessee | 47115 | 2339 | 32 |
952227 | 952227 | 2021-01-21 | Marion | Tennessee | 47115 | 2327 | 31 |
948982 | 948982 | 2021-01-20 | Marion | Tennessee | 47115 | 2308 | 31 |
945736 | 945736 | 2021-01-19 | Marion | Tennessee | 47115 | 2292 | 31 |
942489 | 942489 | 2021-01-18 | Marion | Tennessee | 47115 | 2284 | 31 |
939244 | 939244 | 2021-01-17 | Marion | Tennessee | 47115 | 2277 | 31 |
935999 | 935999 | 2021-01-16 | Marion | Tennessee | 47115 | 2266 | 31 |
932754 | 932754 | 2021-01-15 | Marion | Tennessee | 47115 | 2227 | 31 |
929509 | 929509 | 2021-01-14 | Marion | Tennessee | 47115 | 2200 | 31 |
926264 | 926264 | 2021-01-13 | Marion | Tennessee | 47115 | 2186 | 31 |
923018 | 923018 | 2021-01-12 | Marion | Tennessee | 47115 | 2160 | 31 |
919773 | 919773 | 2021-01-11 | Marion | Tennessee | 47115 | 2144 | 28 |
916528 | 916528 | 2021-01-10 | Marion | Tennessee | 47115 | 2120 | 27 |
913283 | 913283 | 2021-01-09 | Marion | Tennessee | 47115 | 2092 | 26 |
910038 | 910038 | 2021-01-08 | Marion | Tennessee | 47115 | 2071 | 26 |
906793 | 906793 | 2021-01-07 | Marion | Tennessee | 47115 | 2039 | 26 |
903547 | 903547 | 2021-01-06 | Marion | Tennessee | 47115 | 2007 | 26 |
900302 | 900302 | 2021-01-05 | Marion | Tennessee | 47115 | 1974 | 26 |
897057 | 897057 | 2021-01-04 | Marion | Tennessee | 47115 | 1957 | 26 |
893811 | 893811 | 2021-01-03 | Marion | Tennessee | 47115 | 1946 | 26 |
890565 | 890565 | 2021-01-02 | Marion | Tennessee | 47115 | 1932 | 26 |
887318 | 887318 | 2021-01-01 | Marion | Tennessee | 47115 | 1860 | 26 |
884073 | 884073 | 2020-12-31 | Marion | Tennessee | 47115 | 1860 | 26 |
880828 | 880828 | 2020-12-30 | Marion | Tennessee | 47115 | 1839 | 25 |
877583 | 877583 | 2020-12-29 | Marion | Tennessee | 47115 | 1807 | 25 |
874338 | 874338 | 2020-12-28 | Marion | Tennessee | 47115 | 1791 | 25 |
871093 | 871093 | 2020-12-27 | Marion | Tennessee | 47115 | 1780 | 25 |
867848 | 867848 | 2020-12-26 | Marion | Tennessee | 47115 | 1775 | 25 |
864603 | 864603 | 2020-12-25 | Marion | Tennessee | 47115 | 1759 | 25 |
861358 | 861358 | 2020-12-24 | Marion | Tennessee | 47115 | 1727 | 25 |
858113 | 858113 | 2020-12-23 | Marion | Tennessee | 47115 | 1714 | 25 |
854868 | 854868 | 2020-12-22 | Marion | Tennessee | 47115 | 1691 | 24 |
851623 | 851623 | 2020-12-21 | Marion | Tennessee | 47115 | 1687 | 23 |
848378 | 848378 | 2020-12-20 | Marion | Tennessee | 47115 | 1665 | 22 |
845133 | 845133 | 2020-12-19 | Marion | Tennessee | 47115 | 1648 | 22 |
841887 | 841887 | 2020-12-18 | Marion | Tennessee | 47115 | 1630 | 22 |
838642 | 838642 | 2020-12-17 | Marion | Tennessee | 47115 | 1590 | 22 |
835396 | 835396 | 2020-12-16 | Marion | Tennessee | 47115 | 1559 | 22 |
832150 | 832150 | 2020-12-15 | Marion | Tennessee | 47115 | 1526 | 21 |
828903 | 828903 | 2020-12-14 | Marion | Tennessee | 47115 | 1501 | 21 |
825657 | 825657 | 2020-12-13 | Marion | Tennessee | 47115 | 1469 | 21 |
822410 | 822410 | 2020-12-12 | Marion | Tennessee | 47115 | 1426 | 21 |
819164 | 819164 | 2020-12-11 | Marion | Tennessee | 47115 | 1410 | 22 |
815918 | 815918 | 2020-12-10 | Marion | Tennessee | 47115 | 1369 | 22 |
812672 | 812672 | 2020-12-09 | Marion | Tennessee | 47115 | 1326 | 22 |
809428 | 809428 | 2020-12-08 | Marion | Tennessee | 47115 | 1290 | 21 |
806183 | 806183 | 2020-12-07 | Marion | Tennessee | 47115 | 1262 | 21 |
802938 | 802938 | 2020-12-06 | Marion | Tennessee | 47115 | 1239 | 19 |
799693 | 799693 | 2020-12-05 | Marion | Tennessee | 47115 | 1227 | 19 |
796448 | 796448 | 2020-12-04 | Marion | Tennessee | 47115 | 1212 | 19 |
793203 | 793203 | 2020-12-03 | Marion | Tennessee | 47115 | 1187 | 19 |
789958 | 789958 | 2020-12-02 | Marion | Tennessee | 47115 | 1166 | 19 |
786713 | 786713 | 2020-12-01 | Marion | Tennessee | 47115 | 1153 | 19 |
783469 | 783469 | 2020-11-30 | Marion | Tennessee | 47115 | 1122 | 19 |
780224 | 780224 | 2020-11-29 | Marion | Tennessee | 47115 | 1101 | 19 |
776978 | 776978 | 2020-11-28 | Marion | Tennessee | 47115 | 1098 | 19 |
773733 | 773733 | 2020-11-27 | Marion | Tennessee | 47115 | 1077 | 19 |
770488 | 770488 | 2020-11-26 | Marion | Tennessee | 47115 | 1062 | 19 |
767242 | 767242 | 2020-11-25 | Marion | Tennessee | 47115 | 1054 | 19 |
763997 | 763997 | 2020-11-24 | Marion | Tennessee | 47115 | 1040 | 17 |
760752 | 760752 | 2020-11-23 | Marion | Tennessee | 47115 | 1039 | 17 |
757507 | 757507 | 2020-11-22 | Marion | Tennessee | 47115 | 1031 | 17 |
754260 | 754260 | 2020-11-21 | Marion | Tennessee | 47115 | 1022 | 16 |
751014 | 751014 | 2020-11-20 | Marion | Tennessee | 47115 | 1014 | 16 |
747768 | 747768 | 2020-11-19 | Marion | Tennessee | 47115 | 1009 | 15 |
744522 | 744522 | 2020-11-18 | Marion | Tennessee | 47115 | 1001 | 15 |
741275 | 741275 | 2020-11-17 | Marion | Tennessee | 47115 | 991 | 15 |
738029 | 738029 | 2020-11-16 | Marion | Tennessee | 47115 | 986 | 15 |
734785 | 734785 | 2020-11-15 | Marion | Tennessee | 47115 | 968 | 15 |
731539 | 731539 | 2020-11-14 | Marion | Tennessee | 47115 | 959 | 15 |
728295 | 728295 | 2020-11-13 | Marion | Tennessee | 47115 | 944 | 15 |
725051 | 725051 | 2020-11-12 | Marion | Tennessee | 47115 | 940 | 15 |
721808 | 721808 | 2020-11-11 | Marion | Tennessee | 47115 | 932 | 15 |
718565 | 718565 | 2020-11-10 | Marion | Tennessee | 47115 | 928 | 14 |
715322 | 715322 | 2020-11-09 | Marion | Tennessee | 47115 | 917 | 14 |
712078 | 712078 | 2020-11-08 | Marion | Tennessee | 47115 | 905 | 14 |
708834 | 708834 | 2020-11-07 | Marion | Tennessee | 47115 | 901 | 14 |
705591 | 705591 | 2020-11-06 | Marion | Tennessee | 47115 | 881 | 14 |
702348 | 702348 | 2020-11-05 | Marion | Tennessee | 47115 | 877 | 14 |
699104 | 699104 | 2020-11-04 | Marion | Tennessee | 47115 | 867 | 14 |
695861 | 695861 | 2020-11-03 | Marion | Tennessee | 47115 | 855 | 14 |
692619 | 692619 | 2020-11-02 | Marion | Tennessee | 47115 | 845 | 14 |
689375 | 689375 | 2020-11-01 | Marion | Tennessee | 47115 | 835 | 14 |
686130 | 686130 | 2020-10-31 | Marion | Tennessee | 47115 | 834 | 14 |
682887 | 682887 | 2020-10-30 | Marion | Tennessee | 47115 | 826 | 13 |
679644 | 679644 | 2020-10-29 | Marion | Tennessee | 47115 | 812 | 10 |
676401 | 676401 | 2020-10-28 | Marion | Tennessee | 47115 | 809 | 10 |
673158 | 673158 | 2020-10-27 | Marion | Tennessee | 47115 | 794 | 10 |
669916 | 669916 | 2020-10-26 | Marion | Tennessee | 47115 | 783 | 9 |
666672 | 666672 | 2020-10-25 | Marion | Tennessee | 47115 | 773 | 9 |
663427 | 663427 | 2020-10-24 | Marion | Tennessee | 47115 | 747 | 9 |
660183 | 660183 | 2020-10-23 | Marion | Tennessee | 47115 | 741 | 9 |
656939 | 656939 | 2020-10-22 | Marion | Tennessee | 47115 | 724 | 9 |
653694 | 653694 | 2020-10-21 | Marion | Tennessee | 47115 | 715 | 9 |
650449 | 650449 | 2020-10-20 | Marion | Tennessee | 47115 | 708 | 9 |
647205 | 647205 | 2020-10-19 | Marion | Tennessee | 47115 | 699 | 9 |
643959 | 643959 | 2020-10-18 | Marion | Tennessee | 47115 | 684 | 9 |
640711 | 640711 | 2020-10-17 | Marion | Tennessee | 47115 | 670 | 9 |
637465 | 637465 | 2020-10-16 | Marion | Tennessee | 47115 | 654 | 9 |
634219 | 634219 | 2020-10-15 | Marion | Tennessee | 47115 | 652 | 9 |
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);