ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Hamblen" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195667 | 1195667 | 2021-04-06 | Hamblen | Tennessee | 47063 | 8387 | 170 |
1192419 | 1192419 | 2021-04-05 | Hamblen | Tennessee | 47063 | 8387 | 170 |
1189170 | 1189170 | 2021-04-04 | Hamblen | Tennessee | 47063 | 8363 | 170 |
1185923 | 1185923 | 2021-04-03 | Hamblen | Tennessee | 47063 | 8363 | 170 |
1182676 | 1182676 | 2021-04-02 | Hamblen | Tennessee | 47063 | 8363 | 170 |
1179429 | 1179429 | 2021-04-01 | Hamblen | Tennessee | 47063 | 8363 | 170 |
1176182 | 1176182 | 2021-03-31 | Hamblen | Tennessee | 47063 | 8355 | 170 |
1172935 | 1172935 | 2021-03-30 | Hamblen | Tennessee | 47063 | 8348 | 170 |
1169688 | 1169688 | 2021-03-29 | Hamblen | Tennessee | 47063 | 8338 | 170 |
1166440 | 1166440 | 2021-03-28 | Hamblen | Tennessee | 47063 | 8326 | 170 |
1163192 | 1163192 | 2021-03-27 | Hamblen | Tennessee | 47063 | 8326 | 170 |
1159943 | 1159943 | 2021-03-26 | Hamblen | Tennessee | 47063 | 8326 | 170 |
1156696 | 1156696 | 2021-03-25 | Hamblen | Tennessee | 47063 | 8307 | 170 |
1153449 | 1153449 | 2021-03-24 | Hamblen | Tennessee | 47063 | 8298 | 170 |
1150202 | 1150202 | 2021-03-23 | Hamblen | Tennessee | 47063 | 8293 | 170 |
1146955 | 1146955 | 2021-03-22 | Hamblen | Tennessee | 47063 | 8281 | 169 |
1143708 | 1143708 | 2021-03-21 | Hamblen | Tennessee | 47063 | 8245 | 169 |
1140461 | 1140461 | 2021-03-20 | Hamblen | Tennessee | 47063 | 8245 | 169 |
1137215 | 1137215 | 2021-03-19 | Hamblen | Tennessee | 47063 | 8245 | 169 |
1133969 | 1133969 | 2021-03-18 | Hamblen | Tennessee | 47063 | 8236 | 169 |
1130721 | 1130721 | 2021-03-17 | Hamblen | Tennessee | 47063 | 8229 | 169 |
1127474 | 1127474 | 2021-03-16 | Hamblen | Tennessee | 47063 | 8197 | 169 |
1124228 | 1124228 | 2021-03-15 | Hamblen | Tennessee | 47063 | 8180 | 169 |
1120982 | 1120982 | 2021-03-14 | Hamblen | Tennessee | 47063 | 8148 | 169 |
1117735 | 1117735 | 2021-03-13 | Hamblen | Tennessee | 47063 | 8148 | 169 |
1114488 | 1114488 | 2021-03-12 | Hamblen | Tennessee | 47063 | 8148 | 169 |
1111242 | 1111242 | 2021-03-11 | Hamblen | Tennessee | 47063 | 8140 | 168 |
1107996 | 1107996 | 2021-03-10 | Hamblen | Tennessee | 47063 | 8130 | 168 |
1104750 | 1104750 | 2021-03-09 | Hamblen | Tennessee | 47063 | 8111 | 167 |
1101504 | 1101504 | 2021-03-08 | Hamblen | Tennessee | 47063 | 8099 | 166 |
1098258 | 1098258 | 2021-03-07 | Hamblen | Tennessee | 47063 | 8097 | 166 |
1095010 | 1095010 | 2021-03-06 | Hamblen | Tennessee | 47063 | 8088 | 166 |
1091764 | 1091764 | 2021-03-05 | Hamblen | Tennessee | 47063 | 8086 | 165 |
1088518 | 1088518 | 2021-03-04 | Hamblen | Tennessee | 47063 | 8063 | 165 |
1085273 | 1085273 | 2021-03-03 | Hamblen | Tennessee | 47063 | 8048 | 164 |
1082027 | 1082027 | 2021-03-02 | Hamblen | Tennessee | 47063 | 8023 | 164 |
1078781 | 1078781 | 2021-03-01 | Hamblen | Tennessee | 47063 | 8019 | 163 |
1075536 | 1075536 | 2021-02-28 | Hamblen | Tennessee | 47063 | 8013 | 162 |
1072290 | 1072290 | 2021-02-27 | Hamblen | Tennessee | 47063 | 8000 | 162 |
1069044 | 1069044 | 2021-02-26 | Hamblen | Tennessee | 47063 | 7987 | 162 |
1065799 | 1065799 | 2021-02-25 | Hamblen | Tennessee | 47063 | 7972 | 161 |
1062554 | 1062554 | 2021-02-24 | Hamblen | Tennessee | 47063 | 7958 | 161 |
1059309 | 1059309 | 2021-02-23 | Hamblen | Tennessee | 47063 | 7936 | 160 |
1056063 | 1056063 | 2021-02-22 | Hamblen | Tennessee | 47063 | 7919 | 160 |
1052817 | 1052817 | 2021-02-21 | Hamblen | Tennessee | 47063 | 7918 | 161 |
1049570 | 1049570 | 2021-02-20 | Hamblen | Tennessee | 47063 | 7911 | 160 |
1046323 | 1046323 | 2021-02-19 | Hamblen | Tennessee | 47063 | 7890 | 161 |
1043078 | 1043078 | 2021-02-18 | Hamblen | Tennessee | 47063 | 7859 | 161 |
1039833 | 1039833 | 2021-02-17 | Hamblen | Tennessee | 47063 | 7838 | 157 |
1036588 | 1036588 | 2021-02-16 | Hamblen | Tennessee | 47063 | 7819 | 156 |
1033343 | 1033343 | 2021-02-15 | Hamblen | Tennessee | 47063 | 7788 | 156 |
1030097 | 1030097 | 2021-02-14 | Hamblen | Tennessee | 47063 | 7751 | 156 |
1026850 | 1026850 | 2021-02-13 | Hamblen | Tennessee | 47063 | 7710 | 156 |
1023605 | 1023605 | 2021-02-12 | Hamblen | Tennessee | 47063 | 7676 | 156 |
1020360 | 1020360 | 2021-02-11 | Hamblen | Tennessee | 47063 | 7658 | 153 |
1017115 | 1017115 | 2021-02-10 | Hamblen | Tennessee | 47063 | 7614 | 153 |
1013870 | 1013870 | 2021-02-09 | Hamblen | Tennessee | 47063 | 7623 | 151 |
1010625 | 1010625 | 2021-02-08 | Hamblen | Tennessee | 47063 | 7633 | 151 |
1007379 | 1007379 | 2021-02-07 | Hamblen | Tennessee | 47063 | 7626 | 151 |
1004133 | 1004133 | 2021-02-06 | Hamblen | Tennessee | 47063 | 7597 | 151 |
1000887 | 1000887 | 2021-02-05 | Hamblen | Tennessee | 47063 | 7540 | 149 |
997641 | 997641 | 2021-02-04 | Hamblen | Tennessee | 47063 | 7511 | 148 |
994395 | 994395 | 2021-02-03 | Hamblen | Tennessee | 47063 | 7483 | 144 |
991149 | 991149 | 2021-02-02 | Hamblen | Tennessee | 47063 | 7458 | 143 |
987903 | 987903 | 2021-02-01 | Hamblen | Tennessee | 47063 | 7440 | 144 |
984656 | 984656 | 2021-01-31 | Hamblen | Tennessee | 47063 | 7425 | 144 |
981409 | 981409 | 2021-01-30 | Hamblen | Tennessee | 47063 | 7400 | 144 |
978163 | 978163 | 2021-01-29 | Hamblen | Tennessee | 47063 | 7384 | 142 |
974918 | 974918 | 2021-01-28 | Hamblen | Tennessee | 47063 | 7341 | 141 |
971673 | 971673 | 2021-01-27 | Hamblen | Tennessee | 47063 | 7323 | 137 |
968428 | 968428 | 2021-01-26 | Hamblen | Tennessee | 47063 | 7286 | 128 |
965184 | 965184 | 2021-01-25 | Hamblen | Tennessee | 47063 | 7261 | 119 |
961939 | 961939 | 2021-01-24 | Hamblen | Tennessee | 47063 | 7244 | 118 |
958694 | 958694 | 2021-01-23 | Hamblen | Tennessee | 47063 | 7213 | 117 |
955448 | 955448 | 2021-01-22 | Hamblen | Tennessee | 47063 | 7172 | 117 |
952203 | 952203 | 2021-01-21 | Hamblen | Tennessee | 47063 | 7114 | 115 |
948958 | 948958 | 2021-01-20 | Hamblen | Tennessee | 47063 | 7088 | 112 |
945712 | 945712 | 2021-01-19 | Hamblen | Tennessee | 47063 | 7018 | 109 |
942465 | 942465 | 2021-01-18 | Hamblen | Tennessee | 47063 | 6990 | 109 |
939220 | 939220 | 2021-01-17 | Hamblen | Tennessee | 47063 | 6954 | 109 |
935975 | 935975 | 2021-01-16 | Hamblen | Tennessee | 47063 | 6910 | 109 |
932730 | 932730 | 2021-01-15 | Hamblen | Tennessee | 47063 | 6855 | 106 |
929485 | 929485 | 2021-01-14 | Hamblen | Tennessee | 47063 | 6779 | 106 |
926240 | 926240 | 2021-01-13 | Hamblen | Tennessee | 47063 | 6716 | 103 |
922994 | 922994 | 2021-01-12 | Hamblen | Tennessee | 47063 | 6660 | 102 |
919749 | 919749 | 2021-01-11 | Hamblen | Tennessee | 47063 | 6611 | 96 |
916504 | 916504 | 2021-01-10 | Hamblen | Tennessee | 47063 | 6576 | 96 |
913259 | 913259 | 2021-01-09 | Hamblen | Tennessee | 47063 | 6494 | 96 |
910014 | 910014 | 2021-01-08 | Hamblen | Tennessee | 47063 | 6441 | 95 |
906769 | 906769 | 2021-01-07 | Hamblen | Tennessee | 47063 | 6391 | 91 |
903523 | 903523 | 2021-01-06 | Hamblen | Tennessee | 47063 | 6289 | 91 |
900278 | 900278 | 2021-01-05 | Hamblen | Tennessee | 47063 | 6200 | 91 |
897033 | 897033 | 2021-01-04 | Hamblen | Tennessee | 47063 | 6142 | 90 |
893787 | 893787 | 2021-01-03 | Hamblen | Tennessee | 47063 | 6114 | 89 |
890541 | 890541 | 2021-01-02 | Hamblen | Tennessee | 47063 | 6044 | 89 |
887294 | 887294 | 2021-01-01 | Hamblen | Tennessee | 47063 | 5862 | 86 |
884049 | 884049 | 2020-12-31 | Hamblen | Tennessee | 47063 | 5862 | 86 |
880804 | 880804 | 2020-12-30 | Hamblen | Tennessee | 47063 | 5799 | 83 |
877559 | 877559 | 2020-12-29 | Hamblen | Tennessee | 47063 | 5718 | 80 |
874314 | 874314 | 2020-12-28 | Hamblen | Tennessee | 47063 | 5662 | 79 |
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);