ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Elbert" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1277809 | 1277809 | 2021-05-02 | Elbert | Colorado | 8039 | 1674 | 13 |
1274562 | 1274562 | 2021-05-01 | Elbert | Colorado | 8039 | 1669 | 13 |
1271315 | 1271315 | 2021-04-30 | Elbert | Colorado | 8039 | 1662 | 13 |
1268068 | 1268068 | 2021-04-29 | Elbert | Colorado | 8039 | 1659 | 13 |
1264821 | 1264821 | 2021-04-28 | Elbert | Colorado | 8039 | 1644 | 13 |
1261574 | 1261574 | 2021-04-27 | Elbert | Colorado | 8039 | 1641 | 13 |
1258327 | 1258327 | 2021-04-26 | Elbert | Colorado | 8039 | 1617 | 13 |
1255080 | 1255080 | 2021-04-25 | Elbert | Colorado | 8039 | 1617 | 13 |
1251833 | 1251833 | 2021-04-24 | Elbert | Colorado | 8039 | 1604 | 13 |
1248586 | 1248586 | 2021-04-23 | Elbert | Colorado | 8039 | 1596 | 13 |
1245339 | 1245339 | 2021-04-22 | Elbert | Colorado | 8039 | 1587 | 12 |
1242092 | 1242092 | 2021-04-21 | Elbert | Colorado | 8039 | 1573 | 12 |
1238845 | 1238845 | 2021-04-20 | Elbert | Colorado | 8039 | 1565 | 12 |
1235598 | 1235598 | 2021-04-19 | Elbert | Colorado | 8039 | 1555 | 12 |
1232351 | 1232351 | 2021-04-18 | Elbert | Colorado | 8039 | 1552 | 12 |
1229102 | 1229102 | 2021-04-17 | Elbert | Colorado | 8039 | 1549 | 12 |
1225854 | 1225854 | 2021-04-16 | Elbert | Colorado | 8039 | 1539 | 12 |
1222607 | 1222607 | 2021-04-15 | Elbert | Colorado | 8039 | 1523 | 12 |
1219359 | 1219359 | 2021-04-14 | Elbert | Colorado | 8039 | 1513 | 12 |
1216111 | 1216111 | 2021-04-13 | Elbert | Colorado | 8039 | 1502 | 12 |
1212864 | 1212864 | 2021-04-12 | Elbert | Colorado | 8039 | 1498 | 12 |
1209616 | 1209616 | 2021-04-11 | Elbert | Colorado | 8039 | 1491 | 12 |
1206367 | 1206367 | 2021-04-10 | Elbert | Colorado | 8039 | 1484 | 12 |
1203119 | 1203119 | 2021-04-09 | Elbert | Colorado | 8039 | 1478 | 12 |
1199871 | 1199871 | 2021-04-08 | Elbert | Colorado | 8039 | 1471 | 12 |
1196622 | 1196622 | 2021-04-07 | Elbert | Colorado | 8039 | 1455 | 12 |
1193374 | 1193374 | 2021-04-06 | Elbert | Colorado | 8039 | 1455 | 12 |
1190124 | 1190124 | 2021-04-05 | Elbert | Colorado | 8039 | 1447 | 12 |
1186877 | 1186877 | 2021-04-04 | Elbert | Colorado | 8039 | 1442 | 12 |
1183630 | 1183630 | 2021-04-03 | Elbert | Colorado | 8039 | 1439 | 12 |
1180383 | 1180383 | 2021-04-02 | Elbert | Colorado | 8039 | 1429 | 12 |
1177136 | 1177136 | 2021-04-01 | Elbert | Colorado | 8039 | 1427 | 12 |
1173889 | 1173889 | 2021-03-31 | Elbert | Colorado | 8039 | 1421 | 12 |
1170642 | 1170642 | 2021-03-30 | Elbert | Colorado | 8039 | 1411 | 12 |
1167394 | 1167394 | 2021-03-29 | Elbert | Colorado | 8039 | 1408 | 12 |
1164146 | 1164146 | 2021-03-28 | Elbert | Colorado | 8039 | 1403 | 12 |
1160898 | 1160898 | 2021-03-27 | Elbert | Colorado | 8039 | 1399 | 12 |
1157650 | 1157650 | 2021-03-26 | Elbert | Colorado | 8039 | 1396 | 12 |
1154403 | 1154403 | 2021-03-25 | Elbert | Colorado | 8039 | 1394 | 12 |
1151156 | 1151156 | 2021-03-24 | Elbert | Colorado | 8039 | 1388 | 12 |
1147909 | 1147909 | 2021-03-23 | Elbert | Colorado | 8039 | 1384 | 12 |
1144662 | 1144662 | 2021-03-22 | Elbert | Colorado | 8039 | 1375 | 12 |
1141415 | 1141415 | 2021-03-21 | Elbert | Colorado | 8039 | 1375 | 12 |
1138169 | 1138169 | 2021-03-20 | Elbert | Colorado | 8039 | 1368 | 12 |
1134923 | 1134923 | 2021-03-19 | Elbert | Colorado | 8039 | 1358 | 12 |
1131676 | 1131676 | 2021-03-18 | Elbert | Colorado | 8039 | 1346 | 12 |
1128428 | 1128428 | 2021-03-17 | Elbert | Colorado | 8039 | 1340 | 12 |
1125182 | 1125182 | 2021-03-16 | Elbert | Colorado | 8039 | 1337 | 12 |
1121936 | 1121936 | 2021-03-15 | Elbert | Colorado | 8039 | 1335 | 12 |
1118689 | 1118689 | 2021-03-14 | Elbert | Colorado | 8039 | 1334 | 12 |
1115442 | 1115442 | 2021-03-13 | Elbert | Colorado | 8039 | 1327 | 12 |
1112196 | 1112196 | 2021-03-12 | Elbert | Colorado | 8039 | 1326 | 12 |
1108950 | 1108950 | 2021-03-11 | Elbert | Colorado | 8039 | 1318 | 12 |
1105704 | 1105704 | 2021-03-10 | Elbert | Colorado | 8039 | 1314 | 12 |
1102458 | 1102458 | 2021-03-09 | Elbert | Colorado | 8039 | 1312 | 12 |
1099212 | 1099212 | 2021-03-08 | Elbert | Colorado | 8039 | 1307 | 12 |
1095964 | 1095964 | 2021-03-07 | Elbert | Colorado | 8039 | 1297 | 12 |
1092718 | 1092718 | 2021-03-06 | Elbert | Colorado | 8039 | 1297 | 12 |
1089472 | 1089472 | 2021-03-05 | Elbert | Colorado | 8039 | 1296 | 12 |
1086227 | 1086227 | 2021-03-04 | Elbert | Colorado | 8039 | 1295 | 12 |
1082981 | 1082981 | 2021-03-03 | Elbert | Colorado | 8039 | 1289 | 12 |
1079735 | 1079735 | 2021-03-02 | Elbert | Colorado | 8039 | 1287 | 12 |
1076490 | 1076490 | 2021-03-01 | Elbert | Colorado | 8039 | 1288 | 12 |
1073244 | 1073244 | 2021-02-28 | Elbert | Colorado | 8039 | 1286 | 12 |
1069998 | 1069998 | 2021-02-27 | Elbert | Colorado | 8039 | 1281 | 12 |
1066753 | 1066753 | 2021-02-26 | Elbert | Colorado | 8039 | 1271 | 12 |
1063508 | 1063508 | 2021-02-25 | Elbert | Colorado | 8039 | 1271 | 12 |
1060263 | 1060263 | 2021-02-24 | Elbert | Colorado | 8039 | 1268 | 12 |
1057017 | 1057017 | 2021-02-23 | Elbert | Colorado | 8039 | 1263 | 12 |
1053771 | 1053771 | 2021-02-22 | Elbert | Colorado | 8039 | 1257 | 12 |
1050524 | 1050524 | 2021-02-21 | Elbert | Colorado | 8039 | 1254 | 12 |
1047277 | 1047277 | 2021-02-20 | Elbert | Colorado | 8039 | 1251 | 12 |
1044032 | 1044032 | 2021-02-19 | Elbert | Colorado | 8039 | 1250 | 12 |
1040787 | 1040787 | 2021-02-18 | Elbert | Colorado | 8039 | 1242 | 12 |
1037542 | 1037542 | 2021-02-17 | Elbert | Colorado | 8039 | 1240 | 12 |
1034297 | 1034297 | 2021-02-16 | Elbert | Colorado | 8039 | 1233 | 12 |
1031051 | 1031051 | 2021-02-15 | Elbert | Colorado | 8039 | 1232 | 12 |
1027804 | 1027804 | 2021-02-14 | Elbert | Colorado | 8039 | 1230 | 12 |
1024559 | 1024559 | 2021-02-13 | Elbert | Colorado | 8039 | 1227 | 12 |
1021314 | 1021314 | 2021-02-12 | Elbert | Colorado | 8039 | 1222 | 12 |
1018069 | 1018069 | 2021-02-11 | Elbert | Colorado | 8039 | 1219 | 12 |
1014824 | 1014824 | 2021-02-10 | Elbert | Colorado | 8039 | 1216 | 12 |
1011579 | 1011579 | 2021-02-09 | Elbert | Colorado | 8039 | 1212 | 12 |
1008333 | 1008333 | 2021-02-08 | Elbert | Colorado | 8039 | 1207 | 12 |
1005087 | 1005087 | 2021-02-07 | Elbert | Colorado | 8039 | 1202 | 12 |
1001841 | 1001841 | 2021-02-06 | Elbert | Colorado | 8039 | 1196 | 12 |
998595 | 998595 | 2021-02-05 | Elbert | Colorado | 8039 | 1187 | 12 |
995349 | 995349 | 2021-02-04 | Elbert | Colorado | 8039 | 1174 | 12 |
992103 | 992103 | 2021-02-03 | Elbert | Colorado | 8039 | 1164 | 12 |
988857 | 988857 | 2021-02-02 | Elbert | Colorado | 8039 | 1161 | 12 |
985610 | 985610 | 2021-02-01 | Elbert | Colorado | 8039 | 1160 | 12 |
982363 | 982363 | 2021-01-31 | Elbert | Colorado | 8039 | 1141 | 12 |
979117 | 979117 | 2021-01-30 | Elbert | Colorado | 8039 | 1141 | 12 |
975872 | 975872 | 2021-01-29 | Elbert | Colorado | 8039 | 1141 | 12 |
972627 | 972627 | 2021-01-28 | Elbert | Colorado | 8039 | 1138 | 12 |
969382 | 969382 | 2021-01-27 | Elbert | Colorado | 8039 | 1134 | 12 |
966138 | 966138 | 2021-01-26 | Elbert | Colorado | 8039 | 1123 | 12 |
962893 | 962893 | 2021-01-25 | Elbert | Colorado | 8039 | 1120 | 12 |
959648 | 959648 | 2021-01-24 | Elbert | Colorado | 8039 | 1120 | 12 |
956402 | 956402 | 2021-01-23 | Elbert | Colorado | 8039 | 1115 | 12 |
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);