ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 49021 and state = "Utah" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1420015 | 1420015 | 2021-06-14 | Iron | Utah | 49021 | 6032 | 33 |
1416770 | 1416770 | 2021-06-13 | Iron | Utah | 49021 | 6029 | 33 |
1413524 | 1413524 | 2021-06-12 | Iron | Utah | 49021 | 6024 | 33 |
1410279 | 1410279 | 2021-06-11 | Iron | Utah | 49021 | 6020 | 33 |
1407034 | 1407034 | 2021-06-10 | Iron | Utah | 49021 | 6012 | 33 |
1403788 | 1403788 | 2021-06-09 | Iron | Utah | 49021 | 6007 | 33 |
1400543 | 1400543 | 2021-06-08 | Iron | Utah | 49021 | 5999 | 33 |
1397298 | 1397298 | 2021-06-07 | Iron | Utah | 49021 | 5994 | 33 |
1394051 | 1394051 | 2021-06-06 | Iron | Utah | 49021 | 5986 | 33 |
1390806 | 1390806 | 2021-06-05 | Iron | Utah | 49021 | 5972 | 33 |
1387561 | 1387561 | 2021-06-04 | Iron | Utah | 49021 | 5972 | 33 |
1384316 | 1384316 | 2021-06-03 | Iron | Utah | 49021 | 5965 | 33 |
1381070 | 1381070 | 2021-06-02 | Iron | Utah | 49021 | 5955 | 33 |
1377825 | 1377825 | 2021-06-01 | Iron | Utah | 49021 | 5954 | 33 |
1374579 | 1374579 | 2021-05-31 | Iron | Utah | 49021 | 5951 | 33 |
1371334 | 1371334 | 2021-05-30 | Iron | Utah | 49021 | 5945 | 33 |
1368088 | 1368088 | 2021-05-29 | Iron | Utah | 49021 | 5939 | 33 |
1364842 | 1364842 | 2021-05-28 | Iron | Utah | 49021 | 5932 | 32 |
1361596 | 1361596 | 2021-05-27 | Iron | Utah | 49021 | 5912 | 32 |
1358350 | 1358350 | 2021-05-26 | Iron | Utah | 49021 | 5912 | 32 |
1355104 | 1355104 | 2021-05-25 | Iron | Utah | 49021 | 5893 | 32 |
1351858 | 1351858 | 2021-05-24 | Iron | Utah | 49021 | 5893 | 32 |
1348612 | 1348612 | 2021-05-23 | Iron | Utah | 49021 | 5888 | 32 |
1345364 | 1345364 | 2021-05-22 | Iron | Utah | 49021 | 5882 | 32 |
1342116 | 1342116 | 2021-05-21 | Iron | Utah | 49021 | 5876 | 32 |
1338868 | 1338868 | 2021-05-20 | Iron | Utah | 49021 | 5861 | 32 |
1335621 | 1335621 | 2021-05-19 | Iron | Utah | 49021 | 5861 | 32 |
1332374 | 1332374 | 2021-05-18 | Iron | Utah | 49021 | 5850 | 32 |
1329127 | 1329127 | 2021-05-17 | Iron | Utah | 49021 | 5846 | 32 |
1325881 | 1325881 | 2021-05-16 | Iron | Utah | 49021 | 5844 | 32 |
1322635 | 1322635 | 2021-05-15 | Iron | Utah | 49021 | 5835 | 32 |
1319389 | 1319389 | 2021-05-14 | Iron | Utah | 49021 | 5822 | 32 |
1316141 | 1316141 | 2021-05-13 | Iron | Utah | 49021 | 5818 | 32 |
1312895 | 1312895 | 2021-05-12 | Iron | Utah | 49021 | 5813 | 32 |
1309648 | 1309648 | 2021-05-11 | Iron | Utah | 49021 | 5799 | 32 |
1306402 | 1306402 | 2021-05-10 | Iron | Utah | 49021 | 5798 | 32 |
1303156 | 1303156 | 2021-05-09 | Iron | Utah | 49021 | 5787 | 32 |
1299909 | 1299909 | 2021-05-08 | Iron | Utah | 49021 | 5780 | 32 |
1296662 | 1296662 | 2021-05-07 | Iron | Utah | 49021 | 5775 | 32 |
1293416 | 1293416 | 2021-05-06 | Iron | Utah | 49021 | 5758 | 32 |
1290170 | 1290170 | 2021-05-05 | Iron | Utah | 49021 | 5735 | 32 |
1286924 | 1286924 | 2021-05-04 | Iron | Utah | 49021 | 5735 | 32 |
1283678 | 1283678 | 2021-05-03 | Iron | Utah | 49021 | 5735 | 32 |
1280431 | 1280431 | 2021-05-02 | Iron | Utah | 49021 | 5724 | 32 |
1277184 | 1277184 | 2021-05-01 | Iron | Utah | 49021 | 5719 | 32 |
1273937 | 1273937 | 2021-04-30 | Iron | Utah | 49021 | 5714 | 32 |
1270690 | 1270690 | 2021-04-29 | Iron | Utah | 49021 | 5712 | 32 |
1267443 | 1267443 | 2021-04-28 | Iron | Utah | 49021 | 5708 | 32 |
1264196 | 1264196 | 2021-04-27 | Iron | Utah | 49021 | 5692 | 32 |
1260949 | 1260949 | 2021-04-26 | Iron | Utah | 49021 | 5687 | 32 |
1257702 | 1257702 | 2021-04-25 | Iron | Utah | 49021 | 5683 | 32 |
1254455 | 1254455 | 2021-04-24 | Iron | Utah | 49021 | 5675 | 32 |
1251208 | 1251208 | 2021-04-23 | Iron | Utah | 49021 | 5655 | 32 |
1247961 | 1247961 | 2021-04-22 | Iron | Utah | 49021 | 5621 | 32 |
1244714 | 1244714 | 2021-04-21 | Iron | Utah | 49021 | 5621 | 32 |
1241467 | 1241467 | 2021-04-20 | Iron | Utah | 49021 | 5611 | 32 |
1238220 | 1238220 | 2021-04-19 | Iron | Utah | 49021 | 5605 | 32 |
1234973 | 1234973 | 2021-04-18 | Iron | Utah | 49021 | 5596 | 32 |
1231725 | 1231725 | 2021-04-17 | Iron | Utah | 49021 | 5596 | 32 |
1228477 | 1228477 | 2021-04-16 | Iron | Utah | 49021 | 5587 | 32 |
1225229 | 1225229 | 2021-04-15 | Iron | Utah | 49021 | 5575 | 32 |
1221982 | 1221982 | 2021-04-14 | Iron | Utah | 49021 | 5567 | 32 |
1218734 | 1218734 | 2021-04-13 | Iron | Utah | 49021 | 5548 | 32 |
1215486 | 1215486 | 2021-04-12 | Iron | Utah | 49021 | 5539 | 32 |
1212239 | 1212239 | 2021-04-11 | Iron | Utah | 49021 | 5529 | 32 |
1208990 | 1208990 | 2021-04-10 | Iron | Utah | 49021 | 5524 | 32 |
1205742 | 1205742 | 2021-04-09 | Iron | Utah | 49021 | 5495 | 32 |
1202494 | 1202494 | 2021-04-08 | Iron | Utah | 49021 | 5495 | 32 |
1199245 | 1199245 | 2021-04-07 | Iron | Utah | 49021 | 5478 | 32 |
1195996 | 1195996 | 2021-04-06 | Iron | Utah | 49021 | 5433 | 32 |
1192748 | 1192748 | 2021-04-05 | Iron | Utah | 49021 | 5424 | 32 |
1189499 | 1189499 | 2021-04-04 | Iron | Utah | 49021 | 5424 | 32 |
1186252 | 1186252 | 2021-04-03 | Iron | Utah | 49021 | 5401 | 32 |
1183005 | 1183005 | 2021-04-02 | Iron | Utah | 49021 | 5401 | 32 |
1179758 | 1179758 | 2021-04-01 | Iron | Utah | 49021 | 5388 | 32 |
1176511 | 1176511 | 2021-03-31 | Iron | Utah | 49021 | 5374 | 32 |
1173264 | 1173264 | 2021-03-30 | Iron | Utah | 49021 | 5374 | 32 |
1170017 | 1170017 | 2021-03-29 | Iron | Utah | 49021 | 5357 | 31 |
1166769 | 1166769 | 2021-03-28 | Iron | Utah | 49021 | 5338 | 31 |
1163521 | 1163521 | 2021-03-27 | Iron | Utah | 49021 | 5338 | 31 |
1160272 | 1160272 | 2021-03-26 | Iron | Utah | 49021 | 5338 | 31 |
1157025 | 1157025 | 2021-03-25 | Iron | Utah | 49021 | 5323 | 31 |
1153778 | 1153778 | 2021-03-24 | Iron | Utah | 49021 | 5318 | 31 |
1150531 | 1150531 | 2021-03-23 | Iron | Utah | 49021 | 5306 | 34 |
1147284 | 1147284 | 2021-03-22 | Iron | Utah | 49021 | 5127 | 33 |
1144037 | 1144037 | 2021-03-21 | Iron | Utah | 49021 | 5127 | 33 |
1140790 | 1140790 | 2021-03-20 | Iron | Utah | 49021 | 5127 | 33 |
1137544 | 1137544 | 2021-03-19 | Iron | Utah | 49021 | 5127 | 33 |
1134298 | 1134298 | 2021-03-18 | Iron | Utah | 49021 | 5127 | 33 |
1131050 | 1131050 | 2021-03-17 | Iron | Utah | 49021 | 5127 | 33 |
1127803 | 1127803 | 2021-03-16 | Iron | Utah | 49021 | 5127 | 33 |
1124557 | 1124557 | 2021-03-15 | Iron | Utah | 49021 | 5127 | 33 |
1121311 | 1121311 | 2021-03-14 | Iron | Utah | 49021 | 5127 | 33 |
1118064 | 1118064 | 2021-03-13 | Iron | Utah | 49021 | 5127 | 33 |
1114817 | 1114817 | 2021-03-12 | Iron | Utah | 49021 | 5127 | 33 |
1111571 | 1111571 | 2021-03-11 | Iron | Utah | 49021 | 5100 | 32 |
1108325 | 1108325 | 2021-03-10 | Iron | Utah | 49021 | 5100 | 32 |
1105079 | 1105079 | 2021-03-09 | Iron | Utah | 49021 | 5085 | 32 |
1101833 | 1101833 | 2021-03-08 | Iron | Utah | 49021 | 5085 | 32 |
1098587 | 1098587 | 2021-03-07 | Iron | Utah | 49021 | 5036 | 32 |
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);