ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where fips = 49023 and state = "Utah" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1420016 | 1420016 | 2021-06-14 | Juab | Utah | 49023 | 1303 | 12 |
1416771 | 1416771 | 2021-06-13 | Juab | Utah | 49023 | 1302 | 12 |
1413525 | 1413525 | 2021-06-12 | Juab | Utah | 49023 | 1302 | 12 |
1410280 | 1410280 | 2021-06-11 | Juab | Utah | 49023 | 1301 | 12 |
1407035 | 1407035 | 2021-06-10 | Juab | Utah | 49023 | 1298 | 12 |
1403789 | 1403789 | 2021-06-09 | Juab | Utah | 49023 | 1296 | 12 |
1400544 | 1400544 | 2021-06-08 | Juab | Utah | 49023 | 1296 | 12 |
1397299 | 1397299 | 2021-06-07 | Juab | Utah | 49023 | 1295 | 12 |
1394052 | 1394052 | 2021-06-06 | Juab | Utah | 49023 | 1294 | 12 |
1390807 | 1390807 | 2021-06-05 | Juab | Utah | 49023 | 1291 | 12 |
1387562 | 1387562 | 2021-06-04 | Juab | Utah | 49023 | 1291 | 12 |
1384317 | 1384317 | 2021-06-03 | Juab | Utah | 49023 | 1290 | 12 |
1381071 | 1381071 | 2021-06-02 | Juab | Utah | 49023 | 1287 | 12 |
1377826 | 1377826 | 2021-06-01 | Juab | Utah | 49023 | 1287 | 12 |
1374580 | 1374580 | 2021-05-31 | Juab | Utah | 49023 | 1287 | 12 |
1371335 | 1371335 | 2021-05-30 | Juab | Utah | 49023 | 1287 | 12 |
1368089 | 1368089 | 2021-05-29 | Juab | Utah | 49023 | 1284 | 12 |
1364843 | 1364843 | 2021-05-28 | Juab | Utah | 49023 | 1282 | 12 |
1361597 | 1361597 | 2021-05-27 | Juab | Utah | 49023 | 1279 | 12 |
1358351 | 1358351 | 2021-05-26 | Juab | Utah | 49023 | 1279 | 12 |
1355105 | 1355105 | 2021-05-25 | Juab | Utah | 49023 | 1278 | 12 |
1351859 | 1351859 | 2021-05-24 | Juab | Utah | 49023 | 1277 | 12 |
1348613 | 1348613 | 2021-05-23 | Juab | Utah | 49023 | 1277 | 12 |
1345365 | 1345365 | 2021-05-22 | Juab | Utah | 49023 | 1277 | 12 |
1342117 | 1342117 | 2021-05-21 | Juab | Utah | 49023 | 1276 | 12 |
1338869 | 1338869 | 2021-05-20 | Juab | Utah | 49023 | 1273 | 12 |
1335622 | 1335622 | 2021-05-19 | Juab | Utah | 49023 | 1273 | 12 |
1332375 | 1332375 | 2021-05-18 | Juab | Utah | 49023 | 1271 | 12 |
1329128 | 1329128 | 2021-05-17 | Juab | Utah | 49023 | 1271 | 12 |
1325882 | 1325882 | 2021-05-16 | Juab | Utah | 49023 | 1270 | 12 |
1322636 | 1322636 | 2021-05-15 | Juab | Utah | 49023 | 1270 | 12 |
1319390 | 1319390 | 2021-05-14 | Juab | Utah | 49023 | 1270 | 12 |
1316142 | 1316142 | 2021-05-13 | Juab | Utah | 49023 | 1270 | 12 |
1312896 | 1312896 | 2021-05-12 | Juab | Utah | 49023 | 1270 | 12 |
1309649 | 1309649 | 2021-05-11 | Juab | Utah | 49023 | 1267 | 12 |
1306403 | 1306403 | 2021-05-10 | Juab | Utah | 49023 | 1267 | 12 |
1303157 | 1303157 | 2021-05-09 | Juab | Utah | 49023 | 1267 | 12 |
1299910 | 1299910 | 2021-05-08 | Juab | Utah | 49023 | 1267 | 12 |
1296663 | 1296663 | 2021-05-07 | Juab | Utah | 49023 | 1267 | 12 |
1293417 | 1293417 | 2021-05-06 | Juab | Utah | 49023 | 1267 | 12 |
1290171 | 1290171 | 2021-05-05 | Juab | Utah | 49023 | 1266 | 12 |
1286925 | 1286925 | 2021-05-04 | Juab | Utah | 49023 | 1266 | 12 |
1283679 | 1283679 | 2021-05-03 | Juab | Utah | 49023 | 1266 | 12 |
1280432 | 1280432 | 2021-05-02 | Juab | Utah | 49023 | 1266 | 12 |
1277185 | 1277185 | 2021-05-01 | Juab | Utah | 49023 | 1265 | 12 |
1273938 | 1273938 | 2021-04-30 | Juab | Utah | 49023 | 1265 | 12 |
1270691 | 1270691 | 2021-04-29 | Juab | Utah | 49023 | 1264 | 12 |
1267444 | 1267444 | 2021-04-28 | Juab | Utah | 49023 | 1264 | 12 |
1264197 | 1264197 | 2021-04-27 | Juab | Utah | 49023 | 1264 | 12 |
1260950 | 1260950 | 2021-04-26 | Juab | Utah | 49023 | 1264 | 12 |
1257703 | 1257703 | 2021-04-25 | Juab | Utah | 49023 | 1264 | 12 |
1254456 | 1254456 | 2021-04-24 | Juab | Utah | 49023 | 1264 | 12 |
1251209 | 1251209 | 2021-04-23 | Juab | Utah | 49023 | 1263 | 12 |
1247962 | 1247962 | 2021-04-22 | Juab | Utah | 49023 | 1261 | 12 |
1244715 | 1244715 | 2021-04-21 | Juab | Utah | 49023 | 1261 | 12 |
1241468 | 1241468 | 2021-04-20 | Juab | Utah | 49023 | 1261 | 12 |
1238221 | 1238221 | 2021-04-19 | Juab | Utah | 49023 | 1261 | 12 |
1234974 | 1234974 | 2021-04-18 | Juab | Utah | 49023 | 1261 | 12 |
1231726 | 1231726 | 2021-04-17 | Juab | Utah | 49023 | 1261 | 12 |
1228478 | 1228478 | 2021-04-16 | Juab | Utah | 49023 | 1261 | 12 |
1225230 | 1225230 | 2021-04-15 | Juab | Utah | 49023 | 1261 | 12 |
1221983 | 1221983 | 2021-04-14 | Juab | Utah | 49023 | 1260 | 12 |
1218735 | 1218735 | 2021-04-13 | Juab | Utah | 49023 | 1259 | 12 |
1215487 | 1215487 | 2021-04-12 | Juab | Utah | 49023 | 1259 | 12 |
1212240 | 1212240 | 2021-04-11 | Juab | Utah | 49023 | 1257 | 12 |
1208991 | 1208991 | 2021-04-10 | Juab | Utah | 49023 | 1257 | 12 |
1205743 | 1205743 | 2021-04-09 | Juab | Utah | 49023 | 1257 | 12 |
1202495 | 1202495 | 2021-04-08 | Juab | Utah | 49023 | 1257 | 12 |
1199246 | 1199246 | 2021-04-07 | Juab | Utah | 49023 | 1256 | 12 |
1195997 | 1195997 | 2021-04-06 | Juab | Utah | 49023 | 1256 | 12 |
1192749 | 1192749 | 2021-04-05 | Juab | Utah | 49023 | 1256 | 12 |
1189500 | 1189500 | 2021-04-04 | Juab | Utah | 49023 | 1256 | 12 |
1186253 | 1186253 | 2021-04-03 | Juab | Utah | 49023 | 1256 | 12 |
1183006 | 1183006 | 2021-04-02 | Juab | Utah | 49023 | 1256 | 12 |
1179759 | 1179759 | 2021-04-01 | Juab | Utah | 49023 | 1251 | 12 |
1176512 | 1176512 | 2021-03-31 | Juab | Utah | 49023 | 1251 | 12 |
1173265 | 1173265 | 2021-03-30 | Juab | Utah | 49023 | 1250 | 12 |
1170018 | 1170018 | 2021-03-29 | Juab | Utah | 49023 | 1250 | 12 |
1166770 | 1166770 | 2021-03-28 | Juab | Utah | 49023 | 1250 | 12 |
1163522 | 1163522 | 2021-03-27 | Juab | Utah | 49023 | 1250 | 12 |
1160273 | 1160273 | 2021-03-26 | Juab | Utah | 49023 | 1250 | 12 |
1157026 | 1157026 | 2021-03-25 | Juab | Utah | 49023 | 1247 | 12 |
1153779 | 1153779 | 2021-03-24 | Juab | Utah | 49023 | 1246 | 12 |
1150532 | 1150532 | 2021-03-23 | Juab | Utah | 49023 | 1246 | 12 |
1147285 | 1147285 | 2021-03-22 | Juab | Utah | 49023 | 1245 | 12 |
1144038 | 1144038 | 2021-03-21 | Juab | Utah | 49023 | 1243 | 12 |
1140791 | 1140791 | 2021-03-20 | Juab | Utah | 49023 | 1243 | 12 |
1137545 | 1137545 | 2021-03-19 | Juab | Utah | 49023 | 1243 | 12 |
1134299 | 1134299 | 2021-03-18 | Juab | Utah | 49023 | 1242 | 12 |
1131051 | 1131051 | 2021-03-17 | Juab | Utah | 49023 | 1238 | 12 |
1127804 | 1127804 | 2021-03-16 | Juab | Utah | 49023 | 1232 | 12 |
1124558 | 1124558 | 2021-03-15 | Juab | Utah | 49023 | 1232 | 12 |
1121312 | 1121312 | 2021-03-14 | Juab | Utah | 49023 | 1231 | 12 |
1118065 | 1118065 | 2021-03-13 | Juab | Utah | 49023 | 1231 | 12 |
1114818 | 1114818 | 2021-03-12 | Juab | Utah | 49023 | 1231 | 12 |
1111572 | 1111572 | 2021-03-11 | Juab | Utah | 49023 | 1230 | 11 |
1108326 | 1108326 | 2021-03-10 | Juab | Utah | 49023 | 1226 | 11 |
1105080 | 1105080 | 2021-03-09 | Juab | Utah | 49023 | 1222 | 10 |
1101834 | 1101834 | 2021-03-08 | Juab | Utah | 49023 | 1211 | 10 |
1098588 | 1098588 | 2021-03-07 | Juab | Utah | 49023 | 1211 | 10 |
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);