ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Hardin" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1091768 | 1091768 | 2021-03-05 | Hardin | Tennessee | 47071 | 3319 | 63 |
1088522 | 1088522 | 2021-03-04 | Hardin | Tennessee | 47071 | 3315 | 63 |
1085277 | 1085277 | 2021-03-03 | Hardin | Tennessee | 47071 | 3313 | 63 |
1082031 | 1082031 | 2021-03-02 | Hardin | Tennessee | 47071 | 3310 | 63 |
1078785 | 1078785 | 2021-03-01 | Hardin | Tennessee | 47071 | 3311 | 63 |
1075540 | 1075540 | 2021-02-28 | Hardin | Tennessee | 47071 | 3311 | 63 |
1072294 | 1072294 | 2021-02-27 | Hardin | Tennessee | 47071 | 3308 | 63 |
1069048 | 1069048 | 2021-02-26 | Hardin | Tennessee | 47071 | 3307 | 63 |
1065803 | 1065803 | 2021-02-25 | Hardin | Tennessee | 47071 | 3304 | 62 |
1062558 | 1062558 | 2021-02-24 | Hardin | Tennessee | 47071 | 3297 | 62 |
1059313 | 1059313 | 2021-02-23 | Hardin | Tennessee | 47071 | 3295 | 62 |
1056067 | 1056067 | 2021-02-22 | Hardin | Tennessee | 47071 | 3291 | 62 |
1052821 | 1052821 | 2021-02-21 | Hardin | Tennessee | 47071 | 3289 | 62 |
1049574 | 1049574 | 2021-02-20 | Hardin | Tennessee | 47071 | 3288 | 62 |
1046327 | 1046327 | 2021-02-19 | Hardin | Tennessee | 47071 | 3287 | 62 |
1043082 | 1043082 | 2021-02-18 | Hardin | Tennessee | 47071 | 3286 | 62 |
1039837 | 1039837 | 2021-02-17 | Hardin | Tennessee | 47071 | 3284 | 62 |
1036592 | 1036592 | 2021-02-16 | Hardin | Tennessee | 47071 | 3281 | 62 |
1033347 | 1033347 | 2021-02-15 | Hardin | Tennessee | 47071 | 3266 | 62 |
1030101 | 1030101 | 2021-02-14 | Hardin | Tennessee | 47071 | 3252 | 62 |
1026854 | 1026854 | 2021-02-13 | Hardin | Tennessee | 47071 | 3229 | 62 |
1023609 | 1023609 | 2021-02-12 | Hardin | Tennessee | 47071 | 3216 | 62 |
1020364 | 1020364 | 2021-02-11 | Hardin | Tennessee | 47071 | 3214 | 60 |
1017119 | 1017119 | 2021-02-10 | Hardin | Tennessee | 47071 | 3194 | 60 |
1013874 | 1013874 | 2021-02-09 | Hardin | Tennessee | 47071 | 3150 | 60 |
1010629 | 1010629 | 2021-02-08 | Hardin | Tennessee | 47071 | 3139 | 59 |
1007383 | 1007383 | 2021-02-07 | Hardin | Tennessee | 47071 | 3138 | 58 |
1004137 | 1004137 | 2021-02-06 | Hardin | Tennessee | 47071 | 3136 | 58 |
1000891 | 1000891 | 2021-02-05 | Hardin | Tennessee | 47071 | 3127 | 58 |
997645 | 997645 | 2021-02-04 | Hardin | Tennessee | 47071 | 3119 | 57 |
994399 | 994399 | 2021-02-03 | Hardin | Tennessee | 47071 | 3118 | 57 |
991153 | 991153 | 2021-02-02 | Hardin | Tennessee | 47071 | 3112 | 56 |
987907 | 987907 | 2021-02-01 | Hardin | Tennessee | 47071 | 3112 | 56 |
984660 | 984660 | 2021-01-31 | Hardin | Tennessee | 47071 | 3110 | 55 |
981413 | 981413 | 2021-01-30 | Hardin | Tennessee | 47071 | 3104 | 55 |
978167 | 978167 | 2021-01-29 | Hardin | Tennessee | 47071 | 3100 | 54 |
974922 | 974922 | 2021-01-28 | Hardin | Tennessee | 47071 | 3081 | 54 |
971677 | 971677 | 2021-01-27 | Hardin | Tennessee | 47071 | 3079 | 52 |
968432 | 968432 | 2021-01-26 | Hardin | Tennessee | 47071 | 3075 | 51 |
965188 | 965188 | 2021-01-25 | Hardin | Tennessee | 47071 | 3066 | 50 |
961943 | 961943 | 2021-01-24 | Hardin | Tennessee | 47071 | 3063 | 50 |
958698 | 958698 | 2021-01-23 | Hardin | Tennessee | 47071 | 3054 | 50 |
955452 | 955452 | 2021-01-22 | Hardin | Tennessee | 47071 | 3042 | 50 |
952207 | 952207 | 2021-01-21 | Hardin | Tennessee | 47071 | 3027 | 48 |
948962 | 948962 | 2021-01-20 | Hardin | Tennessee | 47071 | 3000 | 48 |
945716 | 945716 | 2021-01-19 | Hardin | Tennessee | 47071 | 2989 | 47 |
942469 | 942469 | 2021-01-18 | Hardin | Tennessee | 47071 | 2981 | 47 |
939224 | 939224 | 2021-01-17 | Hardin | Tennessee | 47071 | 2976 | 47 |
935979 | 935979 | 2021-01-16 | Hardin | Tennessee | 47071 | 2960 | 47 |
932734 | 932734 | 2021-01-15 | Hardin | Tennessee | 47071 | 2954 | 46 |
929489 | 929489 | 2021-01-14 | Hardin | Tennessee | 47071 | 2935 | 46 |
926244 | 926244 | 2021-01-13 | Hardin | Tennessee | 47071 | 2927 | 45 |
922998 | 922998 | 2021-01-12 | Hardin | Tennessee | 47071 | 2911 | 42 |
919753 | 919753 | 2021-01-11 | Hardin | Tennessee | 47071 | 2899 | 38 |
916508 | 916508 | 2021-01-10 | Hardin | Tennessee | 47071 | 2896 | 38 |
913263 | 913263 | 2021-01-09 | Hardin | Tennessee | 47071 | 2863 | 38 |
910018 | 910018 | 2021-01-08 | Hardin | Tennessee | 47071 | 2843 | 37 |
906773 | 906773 | 2021-01-07 | Hardin | Tennessee | 47071 | 2831 | 37 |
903527 | 903527 | 2021-01-06 | Hardin | Tennessee | 47071 | 2778 | 36 |
900282 | 900282 | 2021-01-05 | Hardin | Tennessee | 47071 | 2757 | 36 |
897037 | 897037 | 2021-01-04 | Hardin | Tennessee | 47071 | 2735 | 36 |
893791 | 893791 | 2021-01-03 | Hardin | Tennessee | 47071 | 2724 | 35 |
890545 | 890545 | 2021-01-02 | Hardin | Tennessee | 47071 | 2713 | 35 |
887298 | 887298 | 2021-01-01 | Hardin | Tennessee | 47071 | 2630 | 35 |
884053 | 884053 | 2020-12-31 | Hardin | Tennessee | 47071 | 2630 | 35 |
880808 | 880808 | 2020-12-30 | Hardin | Tennessee | 47071 | 2612 | 35 |
877563 | 877563 | 2020-12-29 | Hardin | Tennessee | 47071 | 2581 | 35 |
874318 | 874318 | 2020-12-28 | Hardin | Tennessee | 47071 | 2535 | 34 |
871073 | 871073 | 2020-12-27 | Hardin | Tennessee | 47071 | 2521 | 34 |
867828 | 867828 | 2020-12-26 | Hardin | Tennessee | 47071 | 2502 | 34 |
864583 | 864583 | 2020-12-25 | Hardin | Tennessee | 47071 | 2488 | 34 |
861338 | 861338 | 2020-12-24 | Hardin | Tennessee | 47071 | 2456 | 34 |
858093 | 858093 | 2020-12-23 | Hardin | Tennessee | 47071 | 2438 | 34 |
854848 | 854848 | 2020-12-22 | Hardin | Tennessee | 47071 | 2413 | 34 |
851603 | 851603 | 2020-12-21 | Hardin | Tennessee | 47071 | 2399 | 33 |
848358 | 848358 | 2020-12-20 | Hardin | Tennessee | 47071 | 2370 | 33 |
845113 | 845113 | 2020-12-19 | Hardin | Tennessee | 47071 | 2332 | 33 |
841867 | 841867 | 2020-12-18 | Hardin | Tennessee | 47071 | 2317 | 33 |
838622 | 838622 | 2020-12-17 | Hardin | Tennessee | 47071 | 2274 | 33 |
835376 | 835376 | 2020-12-16 | Hardin | Tennessee | 47071 | 2246 | 33 |
832130 | 832130 | 2020-12-15 | Hardin | Tennessee | 47071 | 2196 | 32 |
828883 | 828883 | 2020-12-14 | Hardin | Tennessee | 47071 | 2160 | 32 |
825637 | 825637 | 2020-12-13 | Hardin | Tennessee | 47071 | 2123 | 31 |
822390 | 822390 | 2020-12-12 | Hardin | Tennessee | 47071 | 2070 | 30 |
819144 | 819144 | 2020-12-11 | Hardin | Tennessee | 47071 | 2047 | 30 |
815898 | 815898 | 2020-12-10 | Hardin | Tennessee | 47071 | 2025 | 30 |
812652 | 812652 | 2020-12-09 | Hardin | Tennessee | 47071 | 2009 | 30 |
809408 | 809408 | 2020-12-08 | Hardin | Tennessee | 47071 | 1962 | 30 |
806163 | 806163 | 2020-12-07 | Hardin | Tennessee | 47071 | 1945 | 30 |
802918 | 802918 | 2020-12-06 | Hardin | Tennessee | 47071 | 1918 | 29 |
799673 | 799673 | 2020-12-05 | Hardin | Tennessee | 47071 | 1906 | 29 |
796428 | 796428 | 2020-12-04 | Hardin | Tennessee | 47071 | 1865 | 29 |
793183 | 793183 | 2020-12-03 | Hardin | Tennessee | 47071 | 1860 | 27 |
789938 | 789938 | 2020-12-02 | Hardin | Tennessee | 47071 | 1848 | 25 |
786693 | 786693 | 2020-12-01 | Hardin | Tennessee | 47071 | 1821 | 25 |
783449 | 783449 | 2020-11-30 | Hardin | Tennessee | 47071 | 1800 | 25 |
780204 | 780204 | 2020-11-29 | Hardin | Tennessee | 47071 | 1790 | 25 |
776958 | 776958 | 2020-11-28 | Hardin | Tennessee | 47071 | 1781 | 25 |
773713 | 773713 | 2020-11-27 | Hardin | Tennessee | 47071 | 1748 | 25 |
770468 | 770468 | 2020-11-26 | Hardin | Tennessee | 47071 | 1741 | 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);