ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Washington" and state = "Utah" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1420032 | 1420032 | 2021-06-14 | Washington | Utah | 49053 | 21378 | 208 |
1416787 | 1416787 | 2021-06-13 | Washington | Utah | 49053 | 21366 | 208 |
1413541 | 1413541 | 2021-06-12 | Washington | Utah | 49053 | 21360 | 208 |
1410296 | 1410296 | 2021-06-11 | Washington | Utah | 49053 | 21346 | 207 |
1407051 | 1407051 | 2021-06-10 | Washington | Utah | 49053 | 21344 | 207 |
1403805 | 1403805 | 2021-06-09 | Washington | Utah | 49053 | 21335 | 207 |
1400560 | 1400560 | 2021-06-08 | Washington | Utah | 49053 | 21325 | 207 |
1397315 | 1397315 | 2021-06-07 | Washington | Utah | 49053 | 21319 | 207 |
1394068 | 1394068 | 2021-06-06 | Washington | Utah | 49053 | 21310 | 207 |
1390823 | 1390823 | 2021-06-05 | Washington | Utah | 49053 | 21294 | 207 |
1387578 | 1387578 | 2021-06-04 | Washington | Utah | 49053 | 21294 | 207 |
1384333 | 1384333 | 2021-06-03 | Washington | Utah | 49053 | 21282 | 207 |
1381087 | 1381087 | 2021-06-02 | Washington | Utah | 49053 | 21268 | 206 |
1377842 | 1377842 | 2021-06-01 | Washington | Utah | 49053 | 21264 | 206 |
1374596 | 1374596 | 2021-05-31 | Washington | Utah | 49053 | 21262 | 206 |
1371351 | 1371351 | 2021-05-30 | Washington | Utah | 49053 | 21254 | 206 |
1368105 | 1368105 | 2021-05-29 | Washington | Utah | 49053 | 21247 | 206 |
1364859 | 1364859 | 2021-05-28 | Washington | Utah | 49053 | 21242 | 206 |
1361613 | 1361613 | 2021-05-27 | Washington | Utah | 49053 | 21212 | 206 |
1358367 | 1358367 | 2021-05-26 | Washington | Utah | 49053 | 21212 | 206 |
1355121 | 1355121 | 2021-05-25 | Washington | Utah | 49053 | 21201 | 206 |
1351875 | 1351875 | 2021-05-24 | Washington | Utah | 49053 | 21194 | 206 |
1348629 | 1348629 | 2021-05-23 | Washington | Utah | 49053 | 21188 | 206 |
1345381 | 1345381 | 2021-05-22 | Washington | Utah | 49053 | 21183 | 206 |
1342133 | 1342133 | 2021-05-21 | Washington | Utah | 49053 | 21174 | 206 |
1338885 | 1338885 | 2021-05-20 | Washington | Utah | 49053 | 21151 | 205 |
1335638 | 1335638 | 2021-05-19 | Washington | Utah | 49053 | 21151 | 205 |
1332391 | 1332391 | 2021-05-18 | Washington | Utah | 49053 | 21131 | 205 |
1329144 | 1329144 | 2021-05-17 | Washington | Utah | 49053 | 21120 | 205 |
1325898 | 1325898 | 2021-05-16 | Washington | Utah | 49053 | 21114 | 205 |
1322652 | 1322652 | 2021-05-15 | Washington | Utah | 49053 | 21103 | 205 |
1319406 | 1319406 | 2021-05-14 | Washington | Utah | 49053 | 21090 | 205 |
1316158 | 1316158 | 2021-05-13 | Washington | Utah | 49053 | 21073 | 205 |
1312912 | 1312912 | 2021-05-12 | Washington | Utah | 49053 | 21054 | 205 |
1309665 | 1309665 | 2021-05-11 | Washington | Utah | 49053 | 21039 | 204 |
1306419 | 1306419 | 2021-05-10 | Washington | Utah | 49053 | 21030 | 204 |
1303173 | 1303173 | 2021-05-09 | Washington | Utah | 49053 | 21024 | 204 |
1299926 | 1299926 | 2021-05-08 | Washington | Utah | 49053 | 21018 | 204 |
1296679 | 1296679 | 2021-05-07 | Washington | Utah | 49053 | 21010 | 204 |
1293433 | 1293433 | 2021-05-06 | Washington | Utah | 49053 | 20999 | 204 |
1290187 | 1290187 | 2021-05-05 | Washington | Utah | 49053 | 20957 | 204 |
1286941 | 1286941 | 2021-05-04 | Washington | Utah | 49053 | 20957 | 204 |
1283695 | 1283695 | 2021-05-03 | Washington | Utah | 49053 | 20957 | 204 |
1280448 | 1280448 | 2021-05-02 | Washington | Utah | 49053 | 20957 | 204 |
1277201 | 1277201 | 2021-05-01 | Washington | Utah | 49053 | 20950 | 204 |
1273954 | 1273954 | 2021-04-30 | Washington | Utah | 49053 | 20938 | 204 |
1270707 | 1270707 | 2021-04-29 | Washington | Utah | 49053 | 20927 | 204 |
1267460 | 1267460 | 2021-04-28 | Washington | Utah | 49053 | 20918 | 204 |
1264213 | 1264213 | 2021-04-27 | Washington | Utah | 49053 | 20897 | 204 |
1260966 | 1260966 | 2021-04-26 | Washington | Utah | 49053 | 20887 | 204 |
1257719 | 1257719 | 2021-04-25 | Washington | Utah | 49053 | 20878 | 204 |
1254472 | 1254472 | 2021-04-24 | Washington | Utah | 49053 | 20871 | 204 |
1251225 | 1251225 | 2021-04-23 | Washington | Utah | 49053 | 20896 | 204 |
1247978 | 1247978 | 2021-04-22 | Washington | Utah | 49053 | 20826 | 204 |
1244731 | 1244731 | 2021-04-21 | Washington | Utah | 49053 | 20826 | 204 |
1241484 | 1241484 | 2021-04-20 | Washington | Utah | 49053 | 20798 | 204 |
1238237 | 1238237 | 2021-04-19 | Washington | Utah | 49053 | 20784 | 204 |
1234990 | 1234990 | 2021-04-18 | Washington | Utah | 49053 | 20769 | 204 |
1231742 | 1231742 | 2021-04-17 | Washington | Utah | 49053 | 20769 | 204 |
1228494 | 1228494 | 2021-04-16 | Washington | Utah | 49053 | 20744 | 204 |
1225246 | 1225246 | 2021-04-15 | Washington | Utah | 49053 | 20719 | 204 |
1221999 | 1221999 | 2021-04-14 | Washington | Utah | 49053 | 20704 | 204 |
1218751 | 1218751 | 2021-04-13 | Washington | Utah | 49053 | 20690 | 204 |
1215503 | 1215503 | 2021-04-12 | Washington | Utah | 49053 | 20681 | 204 |
1212256 | 1212256 | 2021-04-11 | Washington | Utah | 49053 | 20676 | 204 |
1209007 | 1209007 | 2021-04-10 | Washington | Utah | 49053 | 20667 | 204 |
1205759 | 1205759 | 2021-04-09 | Washington | Utah | 49053 | 20635 | 204 |
1202511 | 1202511 | 2021-04-08 | Washington | Utah | 49053 | 20635 | 204 |
1199262 | 1199262 | 2021-04-07 | Washington | Utah | 49053 | 20624 | 204 |
1196013 | 1196013 | 2021-04-06 | Washington | Utah | 49053 | 20600 | 204 |
1192765 | 1192765 | 2021-04-05 | Washington | Utah | 49053 | 20592 | 204 |
1189516 | 1189516 | 2021-04-04 | Washington | Utah | 49053 | 20592 | 204 |
1186269 | 1186269 | 2021-04-03 | Washington | Utah | 49053 | 20565 | 204 |
1183022 | 1183022 | 2021-04-02 | Washington | Utah | 49053 | 20565 | 204 |
1179775 | 1179775 | 2021-04-01 | Washington | Utah | 49053 | 20549 | 204 |
1176528 | 1176528 | 2021-03-31 | Washington | Utah | 49053 | 20522 | 204 |
1173281 | 1173281 | 2021-03-30 | Washington | Utah | 49053 | 20522 | 204 |
1170034 | 1170034 | 2021-03-29 | Washington | Utah | 49053 | 20504 | 204 |
1166786 | 1166786 | 2021-03-28 | Washington | Utah | 49053 | 20470 | 203 |
1163538 | 1163538 | 2021-03-27 | Washington | Utah | 49053 | 20470 | 203 |
1160289 | 1160289 | 2021-03-26 | Washington | Utah | 49053 | 20470 | 203 |
1157042 | 1157042 | 2021-03-25 | Washington | Utah | 49053 | 20459 | 203 |
1153795 | 1153795 | 2021-03-24 | Washington | Utah | 49053 | 20445 | 202 |
1150548 | 1150548 | 2021-03-23 | Washington | Utah | 49053 | 20427 | 199 |
1147301 | 1147301 | 2021-03-22 | Washington | Utah | 49053 | 20418 | 190 |
1144054 | 1144054 | 2021-03-21 | Washington | Utah | 49053 | 20418 | 190 |
1140807 | 1140807 | 2021-03-20 | Washington | Utah | 49053 | 20418 | 190 |
1137561 | 1137561 | 2021-03-19 | Washington | Utah | 49053 | 20418 | 190 |
1134315 | 1134315 | 2021-03-18 | Washington | Utah | 49053 | 20418 | 190 |
1131067 | 1131067 | 2021-03-17 | Washington | Utah | 49053 | 20418 | 190 |
1127820 | 1127820 | 2021-03-16 | Washington | Utah | 49053 | 20418 | 190 |
1124574 | 1124574 | 2021-03-15 | Washington | Utah | 49053 | 20418 | 190 |
1121328 | 1121328 | 2021-03-14 | Washington | Utah | 49053 | 20418 | 190 |
1118081 | 1118081 | 2021-03-13 | Washington | Utah | 49053 | 20418 | 190 |
1114834 | 1114834 | 2021-03-12 | Washington | Utah | 49053 | 20418 | 190 |
1111588 | 1111588 | 2021-03-11 | Washington | Utah | 49053 | 20368 | 185 |
1108342 | 1108342 | 2021-03-10 | Washington | Utah | 49053 | 20368 | 185 |
1105096 | 1105096 | 2021-03-09 | Washington | Utah | 49053 | 20304 | 185 |
1101850 | 1101850 | 2021-03-08 | Washington | Utah | 49053 | 20304 | 185 |
1098604 | 1098604 | 2021-03-07 | Washington | Utah | 49053 | 20189 | 184 |
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);