ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 8015 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1277796 | 1277796 | 2021-05-02 | Chaffee | Colorado | 8015 | 1633 | 25 |
1274549 | 1274549 | 2021-05-01 | Chaffee | Colorado | 8015 | 1632 | 25 |
1271302 | 1271302 | 2021-04-30 | Chaffee | Colorado | 8015 | 1626 | 25 |
1268055 | 1268055 | 2021-04-29 | Chaffee | Colorado | 8015 | 1616 | 25 |
1264808 | 1264808 | 2021-04-28 | Chaffee | Colorado | 8015 | 1606 | 25 |
1261561 | 1261561 | 2021-04-27 | Chaffee | Colorado | 8015 | 1601 | 25 |
1258314 | 1258314 | 2021-04-26 | Chaffee | Colorado | 8015 | 1597 | 25 |
1255067 | 1255067 | 2021-04-25 | Chaffee | Colorado | 8015 | 1597 | 25 |
1251820 | 1251820 | 2021-04-24 | Chaffee | Colorado | 8015 | 1596 | 25 |
1248573 | 1248573 | 2021-04-23 | Chaffee | Colorado | 8015 | 1592 | 25 |
1245326 | 1245326 | 2021-04-22 | Chaffee | Colorado | 8015 | 1590 | 25 |
1242079 | 1242079 | 2021-04-21 | Chaffee | Colorado | 8015 | 1586 | 24 |
1238832 | 1238832 | 2021-04-20 | Chaffee | Colorado | 8015 | 1563 | 24 |
1235585 | 1235585 | 2021-04-19 | Chaffee | Colorado | 8015 | 1559 | 24 |
1232338 | 1232338 | 2021-04-18 | Chaffee | Colorado | 8015 | 1559 | 24 |
1229089 | 1229089 | 2021-04-17 | Chaffee | Colorado | 8015 | 1556 | 24 |
1225841 | 1225841 | 2021-04-16 | Chaffee | Colorado | 8015 | 1556 | 24 |
1222594 | 1222594 | 2021-04-15 | Chaffee | Colorado | 8015 | 1555 | 24 |
1219346 | 1219346 | 2021-04-14 | Chaffee | Colorado | 8015 | 1550 | 24 |
1216098 | 1216098 | 2021-04-13 | Chaffee | Colorado | 8015 | 1547 | 24 |
1212851 | 1212851 | 2021-04-12 | Chaffee | Colorado | 8015 | 1542 | 24 |
1209603 | 1209603 | 2021-04-11 | Chaffee | Colorado | 8015 | 1540 | 24 |
1206354 | 1206354 | 2021-04-10 | Chaffee | Colorado | 8015 | 1532 | 24 |
1203106 | 1203106 | 2021-04-09 | Chaffee | Colorado | 8015 | 1532 | 24 |
1199858 | 1199858 | 2021-04-08 | Chaffee | Colorado | 8015 | 1530 | 24 |
1196609 | 1196609 | 2021-04-07 | Chaffee | Colorado | 8015 | 1516 | 24 |
1193361 | 1193361 | 2021-04-06 | Chaffee | Colorado | 8015 | 1516 | 24 |
1190111 | 1190111 | 2021-04-05 | Chaffee | Colorado | 8015 | 1516 | 24 |
1186864 | 1186864 | 2021-04-04 | Chaffee | Colorado | 8015 | 1510 | 24 |
1183617 | 1183617 | 2021-04-03 | Chaffee | Colorado | 8015 | 1508 | 24 |
1180370 | 1180370 | 2021-04-02 | Chaffee | Colorado | 8015 | 1505 | 24 |
1177123 | 1177123 | 2021-04-01 | Chaffee | Colorado | 8015 | 1504 | 24 |
1173876 | 1173876 | 2021-03-31 | Chaffee | Colorado | 8015 | 1503 | 24 |
1170629 | 1170629 | 2021-03-30 | Chaffee | Colorado | 8015 | 1499 | 24 |
1167381 | 1167381 | 2021-03-29 | Chaffee | Colorado | 8015 | 1497 | 24 |
1164133 | 1164133 | 2021-03-28 | Chaffee | Colorado | 8015 | 1496 | 24 |
1160885 | 1160885 | 2021-03-27 | Chaffee | Colorado | 8015 | 1495 | 24 |
1157637 | 1157637 | 2021-03-26 | Chaffee | Colorado | 8015 | 1491 | 24 |
1154390 | 1154390 | 2021-03-25 | Chaffee | Colorado | 8015 | 1489 | 24 |
1151143 | 1151143 | 2021-03-24 | Chaffee | Colorado | 8015 | 1489 | 24 |
1147896 | 1147896 | 2021-03-23 | Chaffee | Colorado | 8015 | 1485 | 24 |
1144649 | 1144649 | 2021-03-22 | Chaffee | Colorado | 8015 | 1484 | 24 |
1141402 | 1141402 | 2021-03-21 | Chaffee | Colorado | 8015 | 1484 | 24 |
1138156 | 1138156 | 2021-03-20 | Chaffee | Colorado | 8015 | 1484 | 24 |
1134910 | 1134910 | 2021-03-19 | Chaffee | Colorado | 8015 | 1481 | 24 |
1131663 | 1131663 | 2021-03-18 | Chaffee | Colorado | 8015 | 1481 | 24 |
1128415 | 1128415 | 2021-03-17 | Chaffee | Colorado | 8015 | 1481 | 24 |
1125169 | 1125169 | 2021-03-16 | Chaffee | Colorado | 8015 | 1478 | 24 |
1121923 | 1121923 | 2021-03-15 | Chaffee | Colorado | 8015 | 1477 | 24 |
1118676 | 1118676 | 2021-03-14 | Chaffee | Colorado | 8015 | 1477 | 24 |
1115429 | 1115429 | 2021-03-13 | Chaffee | Colorado | 8015 | 1477 | 24 |
1112183 | 1112183 | 2021-03-12 | Chaffee | Colorado | 8015 | 1476 | 24 |
1108937 | 1108937 | 2021-03-11 | Chaffee | Colorado | 8015 | 1473 | 24 |
1105691 | 1105691 | 2021-03-10 | Chaffee | Colorado | 8015 | 1469 | 24 |
1102445 | 1102445 | 2021-03-09 | Chaffee | Colorado | 8015 | 1465 | 24 |
1099199 | 1099199 | 2021-03-08 | Chaffee | Colorado | 8015 | 1464 | 24 |
1095951 | 1095951 | 2021-03-07 | Chaffee | Colorado | 8015 | 1464 | 24 |
1092705 | 1092705 | 2021-03-06 | Chaffee | Colorado | 8015 | 1464 | 24 |
1089459 | 1089459 | 2021-03-05 | Chaffee | Colorado | 8015 | 1463 | 24 |
1086214 | 1086214 | 2021-03-04 | Chaffee | Colorado | 8015 | 1463 | 24 |
1082968 | 1082968 | 2021-03-03 | Chaffee | Colorado | 8015 | 1463 | 24 |
1079722 | 1079722 | 2021-03-02 | Chaffee | Colorado | 8015 | 1454 | 25 |
1076477 | 1076477 | 2021-03-01 | Chaffee | Colorado | 8015 | 1454 | 24 |
1073231 | 1073231 | 2021-02-28 | Chaffee | Colorado | 8015 | 1442 | 24 |
1069985 | 1069985 | 2021-02-27 | Chaffee | Colorado | 8015 | 1441 | 24 |
1066740 | 1066740 | 2021-02-26 | Chaffee | Colorado | 8015 | 1430 | 23 |
1063495 | 1063495 | 2021-02-25 | Chaffee | Colorado | 8015 | 1430 | 23 |
1060250 | 1060250 | 2021-02-24 | Chaffee | Colorado | 8015 | 1425 | 23 |
1057004 | 1057004 | 2021-02-23 | Chaffee | Colorado | 8015 | 1419 | 23 |
1053758 | 1053758 | 2021-02-22 | Chaffee | Colorado | 8015 | 1411 | 23 |
1050511 | 1050511 | 2021-02-21 | Chaffee | Colorado | 8015 | 1411 | 23 |
1047264 | 1047264 | 2021-02-20 | Chaffee | Colorado | 8015 | 1411 | 23 |
1044019 | 1044019 | 2021-02-19 | Chaffee | Colorado | 8015 | 1408 | 23 |
1040774 | 1040774 | 2021-02-18 | Chaffee | Colorado | 8015 | 1402 | 23 |
1037529 | 1037529 | 2021-02-17 | Chaffee | Colorado | 8015 | 1391 | 23 |
1034284 | 1034284 | 2021-02-16 | Chaffee | Colorado | 8015 | 1389 | 23 |
1031038 | 1031038 | 2021-02-15 | Chaffee | Colorado | 8015 | 1380 | 23 |
1027791 | 1027791 | 2021-02-14 | Chaffee | Colorado | 8015 | 1380 | 23 |
1024546 | 1024546 | 2021-02-13 | Chaffee | Colorado | 8015 | 1375 | 23 |
1021301 | 1021301 | 2021-02-12 | Chaffee | Colorado | 8015 | 1372 | 23 |
1018056 | 1018056 | 2021-02-11 | Chaffee | Colorado | 8015 | 1366 | 23 |
1014811 | 1014811 | 2021-02-10 | Chaffee | Colorado | 8015 | 1360 | 23 |
1011566 | 1011566 | 2021-02-09 | Chaffee | Colorado | 8015 | 1351 | 23 |
1008320 | 1008320 | 2021-02-08 | Chaffee | Colorado | 8015 | 1348 | 23 |
1005074 | 1005074 | 2021-02-07 | Chaffee | Colorado | 8015 | 1349 | 23 |
1001828 | 1001828 | 2021-02-06 | Chaffee | Colorado | 8015 | 1343 | 23 |
998582 | 998582 | 2021-02-05 | Chaffee | Colorado | 8015 | 1339 | 23 |
995336 | 995336 | 2021-02-04 | Chaffee | Colorado | 8015 | 1333 | 23 |
992090 | 992090 | 2021-02-03 | Chaffee | Colorado | 8015 | 1326 | 23 |
988844 | 988844 | 2021-02-02 | Chaffee | Colorado | 8015 | 1323 | 23 |
985597 | 985597 | 2021-02-01 | Chaffee | Colorado | 8015 | 1314 | 23 |
982350 | 982350 | 2021-01-31 | Chaffee | Colorado | 8015 | 1299 | 23 |
979104 | 979104 | 2021-01-30 | Chaffee | Colorado | 8015 | 1299 | 23 |
975859 | 975859 | 2021-01-29 | Chaffee | Colorado | 8015 | 1299 | 23 |
972614 | 972614 | 2021-01-28 | Chaffee | Colorado | 8015 | 1290 | 23 |
969369 | 969369 | 2021-01-27 | Chaffee | Colorado | 8015 | 1274 | 23 |
966125 | 966125 | 2021-01-26 | Chaffee | Colorado | 8015 | 1271 | 23 |
962880 | 962880 | 2021-01-25 | Chaffee | Colorado | 8015 | 1258 | 23 |
959635 | 959635 | 2021-01-24 | Chaffee | Colorado | 8015 | 1258 | 23 |
956389 | 956389 | 2021-01-23 | Chaffee | Colorado | 8015 | 1255 | 23 |
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);