ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 49049 and state = "Utah" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1420030 | 1420030 | 2021-06-14 | Utah | Utah | 49049 | 97653 | 400 |
1416785 | 1416785 | 2021-06-13 | Utah | Utah | 49049 | 97617 | 400 |
1413539 | 1413539 | 2021-06-12 | Utah | Utah | 49049 | 97581 | 400 |
1410294 | 1410294 | 2021-06-11 | Utah | Utah | 49049 | 97492 | 398 |
1407049 | 1407049 | 2021-06-10 | Utah | Utah | 49049 | 97438 | 398 |
1403803 | 1403803 | 2021-06-09 | Utah | Utah | 49049 | 97383 | 398 |
1400558 | 1400558 | 2021-06-08 | Utah | Utah | 49049 | 97301 | 398 |
1397313 | 1397313 | 2021-06-07 | Utah | Utah | 49049 | 97262 | 397 |
1394066 | 1394066 | 2021-06-06 | Utah | Utah | 49049 | 97218 | 396 |
1390821 | 1390821 | 2021-06-05 | Utah | Utah | 49049 | 97167 | 396 |
1387576 | 1387576 | 2021-06-04 | Utah | Utah | 49049 | 97105 | 396 |
1384331 | 1384331 | 2021-06-03 | Utah | Utah | 49049 | 97048 | 396 |
1381085 | 1381085 | 2021-06-02 | Utah | Utah | 49049 | 96977 | 395 |
1377840 | 1377840 | 2021-06-01 | Utah | Utah | 49049 | 96949 | 394 |
1374594 | 1374594 | 2021-05-31 | Utah | Utah | 49049 | 96934 | 394 |
1371349 | 1371349 | 2021-05-30 | Utah | Utah | 49049 | 96893 | 394 |
1368103 | 1368103 | 2021-05-29 | Utah | Utah | 49049 | 96862 | 394 |
1364857 | 1364857 | 2021-05-28 | Utah | Utah | 49049 | 96828 | 393 |
1361611 | 1361611 | 2021-05-27 | Utah | Utah | 49049 | 96787 | 393 |
1358365 | 1358365 | 2021-05-26 | Utah | Utah | 49049 | 96735 | 393 |
1355119 | 1355119 | 2021-05-25 | Utah | Utah | 49049 | 96687 | 393 |
1351873 | 1351873 | 2021-05-24 | Utah | Utah | 49049 | 96663 | 393 |
1348627 | 1348627 | 2021-05-23 | Utah | Utah | 49049 | 96636 | 392 |
1345379 | 1345379 | 2021-05-22 | Utah | Utah | 49049 | 96594 | 392 |
1342131 | 1342131 | 2021-05-21 | Utah | Utah | 49049 | 96556 | 391 |
1338883 | 1338883 | 2021-05-20 | Utah | Utah | 49049 | 96507 | 390 |
1335636 | 1335636 | 2021-05-19 | Utah | Utah | 49049 | 96458 | 390 |
1332389 | 1332389 | 2021-05-18 | Utah | Utah | 49049 | 96366 | 390 |
1329142 | 1329142 | 2021-05-17 | Utah | Utah | 49049 | 96323 | 387 |
1325896 | 1325896 | 2021-05-16 | Utah | Utah | 49049 | 96284 | 386 |
1322650 | 1322650 | 2021-05-15 | Utah | Utah | 49049 | 96248 | 386 |
1319404 | 1319404 | 2021-05-14 | Utah | Utah | 49049 | 96183 | 385 |
1316156 | 1316156 | 2021-05-13 | Utah | Utah | 49049 | 96119 | 385 |
1312910 | 1312910 | 2021-05-12 | Utah | Utah | 49049 | 96028 | 384 |
1309663 | 1309663 | 2021-05-11 | Utah | Utah | 49049 | 95940 | 382 |
1306417 | 1306417 | 2021-05-10 | Utah | Utah | 49049 | 95897 | 381 |
1303171 | 1303171 | 2021-05-09 | Utah | Utah | 49049 | 95853 | 381 |
1299924 | 1299924 | 2021-05-08 | Utah | Utah | 49049 | 95809 | 381 |
1296677 | 1296677 | 2021-05-07 | Utah | Utah | 49049 | 95752 | 381 |
1293431 | 1293431 | 2021-05-06 | Utah | Utah | 49049 | 95654 | 381 |
1290185 | 1290185 | 2021-05-05 | Utah | Utah | 49049 | 95563 | 381 |
1286939 | 1286939 | 2021-05-04 | Utah | Utah | 49049 | 95486 | 381 |
1283693 | 1283693 | 2021-05-03 | Utah | Utah | 49049 | 95442 | 381 |
1280446 | 1280446 | 2021-05-02 | Utah | Utah | 49049 | 95393 | 381 |
1277199 | 1277199 | 2021-05-01 | Utah | Utah | 49049 | 95336 | 380 |
1273952 | 1273952 | 2021-04-30 | Utah | Utah | 49049 | 95259 | 380 |
1270705 | 1270705 | 2021-04-29 | Utah | Utah | 49049 | 95184 | 378 |
1267458 | 1267458 | 2021-04-28 | Utah | Utah | 49049 | 95084 | 377 |
1264211 | 1264211 | 2021-04-27 | Utah | Utah | 49049 | 94999 | 375 |
1260964 | 1260964 | 2021-04-26 | Utah | Utah | 49049 | 94932 | 375 |
1257717 | 1257717 | 2021-04-25 | Utah | Utah | 49049 | 94861 | 375 |
1254470 | 1254470 | 2021-04-24 | Utah | Utah | 49049 | 94800 | 375 |
1251223 | 1251223 | 2021-04-23 | Utah | Utah | 49049 | 94715 | 375 |
1247976 | 1247976 | 2021-04-22 | Utah | Utah | 49049 | 94641 | 374 |
1244729 | 1244729 | 2021-04-21 | Utah | Utah | 49049 | 94511 | 374 |
1241482 | 1241482 | 2021-04-20 | Utah | Utah | 49049 | 94401 | 373 |
1238235 | 1238235 | 2021-04-19 | Utah | Utah | 49049 | 94323 | 372 |
1234988 | 1234988 | 2021-04-18 | Utah | Utah | 49049 | 94292 | 372 |
1231740 | 1231740 | 2021-04-17 | Utah | Utah | 49049 | 94247 | 372 |
1228492 | 1228492 | 2021-04-16 | Utah | Utah | 49049 | 94153 | 372 |
1225244 | 1225244 | 2021-04-15 | Utah | Utah | 49049 | 94052 | 372 |
1221997 | 1221997 | 2021-04-14 | Utah | Utah | 49049 | 93958 | 372 |
1218749 | 1218749 | 2021-04-13 | Utah | Utah | 49049 | 93867 | 372 |
1215501 | 1215501 | 2021-04-12 | Utah | Utah | 49049 | 93784 | 372 |
1212254 | 1212254 | 2021-04-11 | Utah | Utah | 49049 | 93748 | 372 |
1209005 | 1209005 | 2021-04-10 | Utah | Utah | 49049 | 93672 | 372 |
1205757 | 1205757 | 2021-04-09 | Utah | Utah | 49049 | 93595 | 371 |
1202509 | 1202509 | 2021-04-08 | Utah | Utah | 49049 | 93527 | 371 |
1199260 | 1199260 | 2021-04-07 | Utah | Utah | 49049 | 93457 | 369 |
1196011 | 1196011 | 2021-04-06 | Utah | Utah | 49049 | 93366 | 369 |
1192763 | 1192763 | 2021-04-05 | Utah | Utah | 49049 | 93322 | 368 |
1189514 | 1189514 | 2021-04-04 | Utah | Utah | 49049 | 93298 | 367 |
1186267 | 1186267 | 2021-04-03 | Utah | Utah | 49049 | 93218 | 367 |
1183020 | 1183020 | 2021-04-02 | Utah | Utah | 49049 | 93118 | 366 |
1179773 | 1179773 | 2021-04-01 | Utah | Utah | 49049 | 93027 | 365 |
1176526 | 1176526 | 2021-03-31 | Utah | Utah | 49049 | 92952 | 365 |
1173279 | 1173279 | 2021-03-30 | Utah | Utah | 49049 | 92865 | 365 |
1170032 | 1170032 | 2021-03-29 | Utah | Utah | 49049 | 92807 | 364 |
1166784 | 1166784 | 2021-03-28 | Utah | Utah | 49049 | 92776 | 364 |
1163536 | 1163536 | 2021-03-27 | Utah | Utah | 49049 | 92702 | 361 |
1160287 | 1160287 | 2021-03-26 | Utah | Utah | 49049 | 92612 | 359 |
1157040 | 1157040 | 2021-03-25 | Utah | Utah | 49049 | 92525 | 359 |
1153793 | 1153793 | 2021-03-24 | Utah | Utah | 49049 | 92420 | 357 |
1150546 | 1150546 | 2021-03-23 | Utah | Utah | 49049 | 92320 | 357 |
1147299 | 1147299 | 2021-03-22 | Utah | Utah | 49049 | 92229 | 353 |
1144052 | 1144052 | 2021-03-21 | Utah | Utah | 49049 | 92202 | 353 |
1140805 | 1140805 | 2021-03-20 | Utah | Utah | 49049 | 92134 | 353 |
1137559 | 1137559 | 2021-03-19 | Utah | Utah | 49049 | 92063 | 353 |
1134313 | 1134313 | 2021-03-18 | Utah | Utah | 49049 | 91964 | 353 |
1131065 | 1131065 | 2021-03-17 | Utah | Utah | 49049 | 91824 | 351 |
1127818 | 1127818 | 2021-03-16 | Utah | Utah | 49049 | 91677 | 350 |
1124572 | 1124572 | 2021-03-15 | Utah | Utah | 49049 | 91566 | 349 |
1121326 | 1121326 | 2021-03-14 | Utah | Utah | 49049 | 91534 | 349 |
1118079 | 1118079 | 2021-03-13 | Utah | Utah | 49049 | 91461 | 345 |
1114832 | 1114832 | 2021-03-12 | Utah | Utah | 49049 | 91358 | 345 |
1111586 | 1111586 | 2021-03-11 | Utah | Utah | 49049 | 91265 | 345 |
1108340 | 1108340 | 2021-03-10 | Utah | Utah | 49049 | 91127 | 343 |
1105094 | 1105094 | 2021-03-09 | Utah | Utah | 49049 | 91004 | 343 |
1101848 | 1101848 | 2021-03-08 | Utah | Utah | 49049 | 90889 | 341 |
1098602 | 1098602 | 2021-03-07 | Utah | Utah | 49049 | 90840 | 341 |
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);