ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Cache" and state = "Utah" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1420007 | 1420007 | 2021-06-14 | Cache | Utah | 49005 | 16436 | 48 |
1416762 | 1416762 | 2021-06-13 | Cache | Utah | 49005 | 16430 | 48 |
1413516 | 1413516 | 2021-06-12 | Cache | Utah | 49005 | 16422 | 48 |
1410271 | 1410271 | 2021-06-11 | Cache | Utah | 49005 | 16398 | 48 |
1407026 | 1407026 | 2021-06-10 | Cache | Utah | 49005 | 16388 | 48 |
1403780 | 1403780 | 2021-06-09 | Cache | Utah | 49005 | 16379 | 48 |
1400535 | 1400535 | 2021-06-08 | Cache | Utah | 49005 | 16368 | 48 |
1397290 | 1397290 | 2021-06-07 | Cache | Utah | 49005 | 16362 | 48 |
1394043 | 1394043 | 2021-06-06 | Cache | Utah | 49005 | 16354 | 47 |
1390798 | 1390798 | 2021-06-05 | Cache | Utah | 49005 | 16328 | 47 |
1387553 | 1387553 | 2021-06-04 | Cache | Utah | 49005 | 16328 | 47 |
1384308 | 1384308 | 2021-06-03 | Cache | Utah | 49005 | 16318 | 47 |
1381062 | 1381062 | 2021-06-02 | Cache | Utah | 49005 | 16302 | 47 |
1377817 | 1377817 | 2021-06-01 | Cache | Utah | 49005 | 16296 | 47 |
1374571 | 1374571 | 2021-05-31 | Cache | Utah | 49005 | 16290 | 47 |
1371326 | 1371326 | 2021-05-30 | Cache | Utah | 49005 | 16285 | 47 |
1368080 | 1368080 | 2021-05-29 | Cache | Utah | 49005 | 16278 | 47 |
1364834 | 1364834 | 2021-05-28 | Cache | Utah | 49005 | 16269 | 47 |
1361588 | 1361588 | 2021-05-27 | Cache | Utah | 49005 | 16251 | 47 |
1358342 | 1358342 | 2021-05-26 | Cache | Utah | 49005 | 16251 | 47 |
1355096 | 1355096 | 2021-05-25 | Cache | Utah | 49005 | 16242 | 47 |
1351850 | 1351850 | 2021-05-24 | Cache | Utah | 49005 | 16237 | 47 |
1348604 | 1348604 | 2021-05-23 | Cache | Utah | 49005 | 16231 | 47 |
1345356 | 1345356 | 2021-05-22 | Cache | Utah | 49005 | 16227 | 47 |
1342108 | 1342108 | 2021-05-21 | Cache | Utah | 49005 | 16219 | 47 |
1338860 | 1338860 | 2021-05-20 | Cache | Utah | 49005 | 16205 | 47 |
1335613 | 1335613 | 2021-05-19 | Cache | Utah | 49005 | 16205 | 47 |
1332366 | 1332366 | 2021-05-18 | Cache | Utah | 49005 | 16188 | 47 |
1329119 | 1329119 | 2021-05-17 | Cache | Utah | 49005 | 16181 | 47 |
1325873 | 1325873 | 2021-05-16 | Cache | Utah | 49005 | 16174 | 47 |
1322627 | 1322627 | 2021-05-15 | Cache | Utah | 49005 | 16164 | 47 |
1319381 | 1319381 | 2021-05-14 | Cache | Utah | 49005 | 16156 | 47 |
1316133 | 1316133 | 2021-05-13 | Cache | Utah | 49005 | 16142 | 47 |
1312887 | 1312887 | 2021-05-12 | Cache | Utah | 49005 | 16128 | 47 |
1309640 | 1309640 | 2021-05-11 | Cache | Utah | 49005 | 16108 | 47 |
1306394 | 1306394 | 2021-05-10 | Cache | Utah | 49005 | 16102 | 47 |
1303148 | 1303148 | 2021-05-09 | Cache | Utah | 49005 | 16091 | 47 |
1299901 | 1299901 | 2021-05-08 | Cache | Utah | 49005 | 16083 | 47 |
1296654 | 1296654 | 2021-05-07 | Cache | Utah | 49005 | 16071 | 47 |
1293408 | 1293408 | 2021-05-06 | Cache | Utah | 49005 | 16049 | 47 |
1290162 | 1290162 | 2021-05-05 | Cache | Utah | 49005 | 16025 | 45 |
1286916 | 1286916 | 2021-05-04 | Cache | Utah | 49005 | 16025 | 45 |
1283670 | 1283670 | 2021-05-03 | Cache | Utah | 49005 | 16025 | 45 |
1280423 | 1280423 | 2021-05-02 | Cache | Utah | 49005 | 16021 | 45 |
1277176 | 1277176 | 2021-05-01 | Cache | Utah | 49005 | 16007 | 45 |
1273929 | 1273929 | 2021-04-30 | Cache | Utah | 49005 | 15986 | 45 |
1270682 | 1270682 | 2021-04-29 | Cache | Utah | 49005 | 15973 | 45 |
1267435 | 1267435 | 2021-04-28 | Cache | Utah | 49005 | 15961 | 45 |
1264188 | 1264188 | 2021-04-27 | Cache | Utah | 49005 | 15953 | 45 |
1260941 | 1260941 | 2021-04-26 | Cache | Utah | 49005 | 15946 | 45 |
1257694 | 1257694 | 2021-04-25 | Cache | Utah | 49005 | 15939 | 45 |
1254447 | 1254447 | 2021-04-24 | Cache | Utah | 49005 | 15938 | 45 |
1251200 | 1251200 | 2021-04-23 | Cache | Utah | 49005 | 15928 | 45 |
1247953 | 1247953 | 2021-04-22 | Cache | Utah | 49005 | 15883 | 45 |
1244706 | 1244706 | 2021-04-21 | Cache | Utah | 49005 | 15883 | 45 |
1241459 | 1241459 | 2021-04-20 | Cache | Utah | 49005 | 15837 | 45 |
1238212 | 1238212 | 2021-04-19 | Cache | Utah | 49005 | 15831 | 45 |
1234965 | 1234965 | 2021-04-18 | Cache | Utah | 49005 | 15813 | 45 |
1231717 | 1231717 | 2021-04-17 | Cache | Utah | 49005 | 15813 | 45 |
1228469 | 1228469 | 2021-04-16 | Cache | Utah | 49005 | 15803 | 45 |
1225221 | 1225221 | 2021-04-15 | Cache | Utah | 49005 | 15786 | 45 |
1221974 | 1221974 | 2021-04-14 | Cache | Utah | 49005 | 15766 | 45 |
1218726 | 1218726 | 2021-04-13 | Cache | Utah | 49005 | 15718 | 45 |
1215478 | 1215478 | 2021-04-12 | Cache | Utah | 49005 | 15696 | 45 |
1212231 | 1212231 | 2021-04-11 | Cache | Utah | 49005 | 15693 | 45 |
1208982 | 1208982 | 2021-04-10 | Cache | Utah | 49005 | 15680 | 45 |
1205734 | 1205734 | 2021-04-09 | Cache | Utah | 49005 | 15665 | 45 |
1202486 | 1202486 | 2021-04-08 | Cache | Utah | 49005 | 15645 | 44 |
1199237 | 1199237 | 2021-04-07 | Cache | Utah | 49005 | 15621 | 44 |
1195988 | 1195988 | 2021-04-06 | Cache | Utah | 49005 | 15608 | 44 |
1192740 | 1192740 | 2021-04-05 | Cache | Utah | 49005 | 15601 | 44 |
1189491 | 1189491 | 2021-04-04 | Cache | Utah | 49005 | 15599 | 44 |
1186244 | 1186244 | 2021-04-03 | Cache | Utah | 49005 | 15571 | 44 |
1182997 | 1182997 | 2021-04-02 | Cache | Utah | 49005 | 15563 | 44 |
1179750 | 1179750 | 2021-04-01 | Cache | Utah | 49005 | 15553 | 44 |
1176503 | 1176503 | 2021-03-31 | Cache | Utah | 49005 | 15524 | 44 |
1173256 | 1173256 | 2021-03-30 | Cache | Utah | 49005 | 15497 | 44 |
1170009 | 1170009 | 2021-03-29 | Cache | Utah | 49005 | 15480 | 44 |
1166761 | 1166761 | 2021-03-28 | Cache | Utah | 49005 | 15470 | 44 |
1163513 | 1163513 | 2021-03-27 | Cache | Utah | 49005 | 15458 | 43 |
1160264 | 1160264 | 2021-03-26 | Cache | Utah | 49005 | 15441 | 43 |
1157017 | 1157017 | 2021-03-25 | Cache | Utah | 49005 | 15426 | 43 |
1153770 | 1153770 | 2021-03-24 | Cache | Utah | 49005 | 15400 | 43 |
1150523 | 1150523 | 2021-03-23 | Cache | Utah | 49005 | 15367 | 42 |
1147276 | 1147276 | 2021-03-22 | Cache | Utah | 49005 | 15351 | 41 |
1144029 | 1144029 | 2021-03-21 | Cache | Utah | 49005 | 15342 | 41 |
1140782 | 1140782 | 2021-03-20 | Cache | Utah | 49005 | 15322 | 41 |
1137536 | 1137536 | 2021-03-19 | Cache | Utah | 49005 | 15298 | 41 |
1134290 | 1134290 | 2021-03-18 | Cache | Utah | 49005 | 15284 | 39 |
1131042 | 1131042 | 2021-03-17 | Cache | Utah | 49005 | 15263 | 39 |
1127795 | 1127795 | 2021-03-16 | Cache | Utah | 49005 | 15222 | 39 |
1124549 | 1124549 | 2021-03-15 | Cache | Utah | 49005 | 15208 | 39 |
1121303 | 1121303 | 2021-03-14 | Cache | Utah | 49005 | 15194 | 39 |
1118056 | 1118056 | 2021-03-13 | Cache | Utah | 49005 | 15166 | 39 |
1114809 | 1114809 | 2021-03-12 | Cache | Utah | 49005 | 15137 | 39 |
1111563 | 1111563 | 2021-03-11 | Cache | Utah | 49005 | 15098 | 39 |
1108317 | 1108317 | 2021-03-10 | Cache | Utah | 49005 | 15063 | 38 |
1105071 | 1105071 | 2021-03-09 | Cache | Utah | 49005 | 15038 | 38 |
1101825 | 1101825 | 2021-03-08 | Cache | Utah | 49005 | 15004 | 38 |
1098579 | 1098579 | 2021-03-07 | Cache | Utah | 49005 | 14991 | 38 |
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);