ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
75 rows where county = "Eagle", deaths = 22 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1339492 | 1339492 | 2021-05-21 | Eagle | Colorado | 8037 | 6311 | 22 |
1336245 | 1336245 | 2021-05-20 | Eagle | Colorado | 8037 | 6307 | 22 |
1332998 | 1332998 | 2021-05-19 | Eagle | Colorado | 8037 | 6302 | 22 |
1329751 | 1329751 | 2021-05-18 | Eagle | Colorado | 8037 | 6298 | 22 |
1326504 | 1326504 | 2021-05-17 | Eagle | Colorado | 8037 | 6297 | 22 |
1323258 | 1323258 | 2021-05-16 | Eagle | Colorado | 8037 | 6297 | 22 |
1320012 | 1320012 | 2021-05-15 | Eagle | Colorado | 8037 | 6295 | 22 |
1316765 | 1316765 | 2021-05-14 | Eagle | Colorado | 8037 | 6291 | 22 |
1313518 | 1313518 | 2021-05-13 | Eagle | Colorado | 8037 | 6282 | 22 |
1310271 | 1310271 | 2021-05-12 | Eagle | Colorado | 8037 | 6279 | 22 |
1307025 | 1307025 | 2021-05-11 | Eagle | Colorado | 8037 | 6279 | 22 |
1303779 | 1303779 | 2021-05-10 | Eagle | Colorado | 8037 | 6268 | 22 |
1300532 | 1300532 | 2021-05-09 | Eagle | Colorado | 8037 | 6268 | 22 |
1297285 | 1297285 | 2021-05-08 | Eagle | Colorado | 8037 | 6269 | 22 |
1294039 | 1294039 | 2021-05-07 | Eagle | Colorado | 8037 | 6269 | 22 |
1290793 | 1290793 | 2021-05-06 | Eagle | Colorado | 8037 | 6261 | 22 |
1287547 | 1287547 | 2021-05-05 | Eagle | Colorado | 8037 | 6253 | 22 |
1284301 | 1284301 | 2021-05-04 | Eagle | Colorado | 8037 | 6240 | 22 |
1281054 | 1281054 | 2021-05-03 | Eagle | Colorado | 8037 | 6234 | 22 |
1277807 | 1277807 | 2021-05-02 | Eagle | Colorado | 8037 | 6231 | 22 |
1274560 | 1274560 | 2021-05-01 | Eagle | Colorado | 8037 | 6230 | 22 |
1271313 | 1271313 | 2021-04-30 | Eagle | Colorado | 8037 | 6215 | 22 |
1268066 | 1268066 | 2021-04-29 | Eagle | Colorado | 8037 | 6197 | 22 |
1264819 | 1264819 | 2021-04-28 | Eagle | Colorado | 8037 | 6184 | 22 |
1261572 | 1261572 | 2021-04-27 | Eagle | Colorado | 8037 | 6176 | 22 |
1258325 | 1258325 | 2021-04-26 | Eagle | Colorado | 8037 | 6157 | 22 |
1255078 | 1255078 | 2021-04-25 | Eagle | Colorado | 8037 | 6157 | 22 |
1251831 | 1251831 | 2021-04-24 | Eagle | Colorado | 8037 | 6150 | 22 |
1248584 | 1248584 | 2021-04-23 | Eagle | Colorado | 8037 | 6138 | 22 |
1245337 | 1245337 | 2021-04-22 | Eagle | Colorado | 8037 | 6123 | 22 |
1242090 | 1242090 | 2021-04-21 | Eagle | Colorado | 8037 | 6107 | 22 |
1238843 | 1238843 | 2021-04-20 | Eagle | Colorado | 8037 | 6089 | 22 |
1235596 | 1235596 | 2021-04-19 | Eagle | Colorado | 8037 | 6064 | 22 |
1232349 | 1232349 | 2021-04-18 | Eagle | Colorado | 8037 | 6055 | 22 |
1229100 | 1229100 | 2021-04-17 | Eagle | Colorado | 8037 | 6045 | 22 |
1225852 | 1225852 | 2021-04-16 | Eagle | Colorado | 8037 | 6036 | 22 |
1222605 | 1222605 | 2021-04-15 | Eagle | Colorado | 8037 | 6018 | 22 |
1219357 | 1219357 | 2021-04-14 | Eagle | Colorado | 8037 | 6009 | 22 |
1216109 | 1216109 | 2021-04-13 | Eagle | Colorado | 8037 | 5988 | 22 |
1212862 | 1212862 | 2021-04-12 | Eagle | Colorado | 8037 | 5961 | 22 |
1209614 | 1209614 | 2021-04-11 | Eagle | Colorado | 8037 | 5955 | 22 |
1206365 | 1206365 | 2021-04-10 | Eagle | Colorado | 8037 | 5937 | 22 |
1203117 | 1203117 | 2021-04-09 | Eagle | Colorado | 8037 | 5910 | 22 |
1199869 | 1199869 | 2021-04-08 | Eagle | Colorado | 8037 | 5889 | 22 |
1196620 | 1196620 | 2021-04-07 | Eagle | Colorado | 8037 | 5842 | 22 |
1193372 | 1193372 | 2021-04-06 | Eagle | Colorado | 8037 | 5842 | 22 |
1190122 | 1190122 | 2021-04-05 | Eagle | Colorado | 8037 | 5809 | 22 |
1186875 | 1186875 | 2021-04-04 | Eagle | Colorado | 8037 | 5799 | 22 |
1183628 | 1183628 | 2021-04-03 | Eagle | Colorado | 8037 | 5790 | 22 |
1180381 | 1180381 | 2021-04-02 | Eagle | Colorado | 8037 | 5777 | 22 |
1177134 | 1177134 | 2021-04-01 | Eagle | Colorado | 8037 | 5756 | 22 |
1173887 | 1173887 | 2021-03-31 | Eagle | Colorado | 8037 | 5738 | 22 |
1170640 | 1170640 | 2021-03-30 | Eagle | Colorado | 8037 | 5704 | 22 |
1167392 | 1167392 | 2021-03-29 | Eagle | Colorado | 8037 | 5694 | 22 |
1164144 | 1164144 | 2021-03-28 | Eagle | Colorado | 8037 | 5687 | 22 |
1160896 | 1160896 | 2021-03-27 | Eagle | Colorado | 8037 | 5663 | 22 |
1157648 | 1157648 | 2021-03-26 | Eagle | Colorado | 8037 | 5645 | 22 |
1154401 | 1154401 | 2021-03-25 | Eagle | Colorado | 8037 | 5612 | 22 |
1151154 | 1151154 | 2021-03-24 | Eagle | Colorado | 8037 | 5585 | 22 |
1147907 | 1147907 | 2021-03-23 | Eagle | Colorado | 8037 | 5566 | 22 |
1144660 | 1144660 | 2021-03-22 | Eagle | Colorado | 8037 | 5536 | 22 |
1141413 | 1141413 | 2021-03-21 | Eagle | Colorado | 8037 | 5523 | 22 |
1138167 | 1138167 | 2021-03-20 | Eagle | Colorado | 8037 | 5497 | 22 |
1134921 | 1134921 | 2021-03-19 | Eagle | Colorado | 8037 | 5489 | 22 |
1131674 | 1131674 | 2021-03-18 | Eagle | Colorado | 8037 | 5468 | 22 |
1128426 | 1128426 | 2021-03-17 | Eagle | Colorado | 8037 | 5431 | 22 |
1125180 | 1125180 | 2021-03-16 | Eagle | Colorado | 8037 | 5415 | 22 |
1121934 | 1121934 | 2021-03-15 | Eagle | Colorado | 8037 | 5398 | 22 |
1118687 | 1118687 | 2021-03-14 | Eagle | Colorado | 8037 | 5383 | 22 |
1115440 | 1115440 | 2021-03-13 | Eagle | Colorado | 8037 | 5364 | 22 |
1112194 | 1112194 | 2021-03-12 | Eagle | Colorado | 8037 | 5347 | 22 |
1108948 | 1108948 | 2021-03-11 | Eagle | Colorado | 8037 | 5323 | 22 |
1105702 | 1105702 | 2021-03-10 | Eagle | Colorado | 8037 | 5311 | 22 |
1102456 | 1102456 | 2021-03-09 | Eagle | Colorado | 8037 | 5289 | 22 |
1099210 | 1099210 | 2021-03-08 | Eagle | Colorado | 8037 | 5265 | 22 |
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);