ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "Hamilton" and state = "Nebraska" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1418838 | 1418838 | 2021-06-14 | Hamilton | Nebraska | 31081 | 970 | 18 |
1415593 | 1415593 | 2021-06-13 | Hamilton | Nebraska | 31081 | 970 | 18 |
1412347 | 1412347 | 2021-06-12 | Hamilton | Nebraska | 31081 | 970 | 18 |
1409102 | 1409102 | 2021-06-11 | Hamilton | Nebraska | 31081 | 970 | 18 |
1405857 | 1405857 | 2021-06-10 | Hamilton | Nebraska | 31081 | 970 | 18 |
1402611 | 1402611 | 2021-06-09 | Hamilton | Nebraska | 31081 | 970 | 18 |
1399366 | 1399366 | 2021-06-08 | Hamilton | Nebraska | 31081 | 970 | 18 |
1396120 | 1396120 | 2021-06-07 | Hamilton | Nebraska | 31081 | 970 | 18 |
1392874 | 1392874 | 2021-06-06 | Hamilton | Nebraska | 31081 | 970 | 18 |
1389629 | 1389629 | 2021-06-05 | Hamilton | Nebraska | 31081 | 970 | 18 |
1386384 | 1386384 | 2021-06-04 | Hamilton | Nebraska | 31081 | 970 | 18 |
1383139 | 1383139 | 2021-06-03 | Hamilton | Nebraska | 31081 | 970 | 18 |
1379893 | 1379893 | 2021-06-02 | Hamilton | Nebraska | 31081 | 970 | 18 |
1376648 | 1376648 | 2021-06-01 | Hamilton | Nebraska | 31081 | 970 | 18 |
1373402 | 1373402 | 2021-05-31 | Hamilton | Nebraska | 31081 | 969 | 18 |
1370157 | 1370157 | 2021-05-30 | Hamilton | Nebraska | 31081 | 969 | 18 |
1366911 | 1366911 | 2021-05-29 | Hamilton | Nebraska | 31081 | 969 | 18 |
1363665 | 1363665 | 2021-05-28 | Hamilton | Nebraska | 31081 | 969 | 18 |
1360418 | 1360418 | 2021-05-27 | Hamilton | Nebraska | 31081 | 969 | 18 |
1357172 | 1357172 | 2021-05-26 | Hamilton | Nebraska | 31081 | 969 | 18 |
1353926 | 1353926 | 2021-05-25 | Hamilton | Nebraska | 31081 | 968 | 18 |
1350680 | 1350680 | 2021-05-24 | Hamilton | Nebraska | 31081 | 968 | 18 |
1347434 | 1347434 | 2021-05-23 | Hamilton | Nebraska | 31081 | 968 | 18 |
1344186 | 1344186 | 2021-05-22 | Hamilton | Nebraska | 31081 | 968 | 18 |
1340938 | 1340938 | 2021-05-21 | Hamilton | Nebraska | 31081 | 968 | 18 |
1337690 | 1337690 | 2021-05-20 | Hamilton | Nebraska | 31081 | 966 | 18 |
1334443 | 1334443 | 2021-05-19 | Hamilton | Nebraska | 31081 | 966 | 18 |
1331196 | 1331196 | 2021-05-18 | Hamilton | Nebraska | 31081 | 965 | 18 |
1327949 | 1327949 | 2021-05-17 | Hamilton | Nebraska | 31081 | 963 | 18 |
1324703 | 1324703 | 2021-05-16 | Hamilton | Nebraska | 31081 | 963 | 18 |
1321457 | 1321457 | 2021-05-15 | Hamilton | Nebraska | 31081 | 963 | 18 |
1318211 | 1318211 | 2021-05-14 | Hamilton | Nebraska | 31081 | 963 | 18 |
1314963 | 1314963 | 2021-05-13 | Hamilton | Nebraska | 31081 | 962 | 18 |
1311717 | 1311717 | 2021-05-12 | Hamilton | Nebraska | 31081 | 962 | 18 |
1308470 | 1308470 | 2021-05-11 | Hamilton | Nebraska | 31081 | 958 | 18 |
1305224 | 1305224 | 2021-05-10 | Hamilton | Nebraska | 31081 | 958 | 18 |
1301978 | 1301978 | 2021-05-09 | Hamilton | Nebraska | 31081 | 956 | 18 |
1298730 | 1298730 | 2021-05-08 | Hamilton | Nebraska | 31081 | 956 | 18 |
1295484 | 1295484 | 2021-05-07 | Hamilton | Nebraska | 31081 | 956 | 18 |
1292238 | 1292238 | 2021-05-06 | Hamilton | Nebraska | 31081 | 953 | 18 |
1288992 | 1288992 | 2021-05-05 | Hamilton | Nebraska | 31081 | 953 | 18 |
1285746 | 1285746 | 2021-05-04 | Hamilton | Nebraska | 31081 | 945 | 18 |
1282500 | 1282500 | 2021-05-03 | Hamilton | Nebraska | 31081 | 945 | 18 |
1279253 | 1279253 | 2021-05-02 | Hamilton | Nebraska | 31081 | 936 | 18 |
1276006 | 1276006 | 2021-05-01 | Hamilton | Nebraska | 31081 | 936 | 18 |
1272759 | 1272759 | 2021-04-30 | Hamilton | Nebraska | 31081 | 936 | 18 |
1269512 | 1269512 | 2021-04-29 | Hamilton | Nebraska | 31081 | 936 | 18 |
1266265 | 1266265 | 2021-04-28 | Hamilton | Nebraska | 31081 | 936 | 18 |
1263018 | 1263018 | 2021-04-27 | Hamilton | Nebraska | 31081 | 936 | 18 |
1259771 | 1259771 | 2021-04-26 | Hamilton | Nebraska | 31081 | 936 | 18 |
1256524 | 1256524 | 2021-04-25 | Hamilton | Nebraska | 31081 | 933 | 18 |
1253277 | 1253277 | 2021-04-24 | Hamilton | Nebraska | 31081 | 933 | 18 |
1250030 | 1250030 | 2021-04-23 | Hamilton | Nebraska | 31081 | 930 | 18 |
1246783 | 1246783 | 2021-04-22 | Hamilton | Nebraska | 31081 | 930 | 18 |
1243536 | 1243536 | 2021-04-21 | Hamilton | Nebraska | 31081 | 930 | 18 |
1240289 | 1240289 | 2021-04-20 | Hamilton | Nebraska | 31081 | 929 | 18 |
1237042 | 1237042 | 2021-04-19 | Hamilton | Nebraska | 31081 | 929 | 18 |
1233795 | 1233795 | 2021-04-18 | Hamilton | Nebraska | 31081 | 928 | 18 |
1230547 | 1230547 | 2021-04-17 | Hamilton | Nebraska | 31081 | 927 | 18 |
1227299 | 1227299 | 2021-04-16 | Hamilton | Nebraska | 31081 | 927 | 18 |
1224051 | 1224051 | 2021-04-15 | Hamilton | Nebraska | 31081 | 928 | 18 |
1220804 | 1220804 | 2021-04-14 | Hamilton | Nebraska | 31081 | 928 | 18 |
1217556 | 1217556 | 2021-04-13 | Hamilton | Nebraska | 31081 | 924 | 18 |
1214309 | 1214309 | 2021-04-12 | Hamilton | Nebraska | 31081 | 924 | 18 |
1211061 | 1211061 | 2021-04-11 | Hamilton | Nebraska | 31081 | 924 | 18 |
1207812 | 1207812 | 2021-04-10 | Hamilton | Nebraska | 31081 | 924 | 18 |
1204564 | 1204564 | 2021-04-09 | Hamilton | Nebraska | 31081 | 921 | 18 |
1201316 | 1201316 | 2021-04-08 | Hamilton | Nebraska | 31081 | 920 | 18 |
1198067 | 1198067 | 2021-04-07 | Hamilton | Nebraska | 31081 | 920 | 18 |
1194818 | 1194818 | 2021-04-06 | Hamilton | Nebraska | 31081 | 920 | 18 |
1191569 | 1191569 | 2021-04-05 | Hamilton | Nebraska | 31081 | 920 | 18 |
1188321 | 1188321 | 2021-04-04 | Hamilton | Nebraska | 31081 | 917 | 18 |
1185074 | 1185074 | 2021-04-03 | Hamilton | Nebraska | 31081 | 917 | 18 |
1181828 | 1181828 | 2021-04-02 | Hamilton | Nebraska | 31081 | 916 | 18 |
1178581 | 1178581 | 2021-04-01 | Hamilton | Nebraska | 31081 | 915 | 18 |
1175334 | 1175334 | 2021-03-31 | Hamilton | Nebraska | 31081 | 915 | 18 |
1172087 | 1172087 | 2021-03-30 | Hamilton | Nebraska | 31081 | 912 | 18 |
1168839 | 1168839 | 2021-03-29 | Hamilton | Nebraska | 31081 | 912 | 18 |
1165591 | 1165591 | 2021-03-28 | Hamilton | Nebraska | 31081 | 908 | 18 |
1162343 | 1162343 | 2021-03-27 | Hamilton | Nebraska | 31081 | 908 | 18 |
1159095 | 1159095 | 2021-03-26 | Hamilton | Nebraska | 31081 | 908 | 18 |
1155848 | 1155848 | 2021-03-25 | Hamilton | Nebraska | 31081 | 906 | 18 |
1152601 | 1152601 | 2021-03-24 | Hamilton | Nebraska | 31081 | 906 | 18 |
1149354 | 1149354 | 2021-03-23 | Hamilton | Nebraska | 31081 | 906 | 17 |
1146107 | 1146107 | 2021-03-22 | Hamilton | Nebraska | 31081 | 906 | 17 |
1142860 | 1142860 | 2021-03-21 | Hamilton | Nebraska | 31081 | 906 | 17 |
1139613 | 1139613 | 2021-03-20 | Hamilton | Nebraska | 31081 | 906 | 17 |
1136367 | 1136367 | 2021-03-19 | Hamilton | Nebraska | 31081 | 906 | 17 |
1133121 | 1133121 | 2021-03-18 | Hamilton | Nebraska | 31081 | 904 | 17 |
1129873 | 1129873 | 2021-03-17 | Hamilton | Nebraska | 31081 | 904 | 17 |
1126626 | 1126626 | 2021-03-16 | Hamilton | Nebraska | 31081 | 905 | 17 |
1123380 | 1123380 | 2021-03-15 | Hamilton | Nebraska | 31081 | 905 | 17 |
1120133 | 1120133 | 2021-03-14 | Hamilton | Nebraska | 31081 | 904 | 17 |
1116886 | 1116886 | 2021-03-13 | Hamilton | Nebraska | 31081 | 904 | 17 |
1113640 | 1113640 | 2021-03-12 | Hamilton | Nebraska | 31081 | 904 | 17 |
1110394 | 1110394 | 2021-03-11 | Hamilton | Nebraska | 31081 | 903 | 17 |
1107148 | 1107148 | 2021-03-10 | Hamilton | Nebraska | 31081 | 903 | 17 |
1103902 | 1103902 | 2021-03-09 | Hamilton | Nebraska | 31081 | 896 | 17 |
1100656 | 1100656 | 2021-03-08 | Hamilton | Nebraska | 31081 | 891 | 17 |
1097409 | 1097409 | 2021-03-07 | Hamilton | Nebraska | 31081 | 891 | 17 |
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);