ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 8049 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1277813 | 1277813 | 2021-05-02 | Grand | Colorado | 8049 | 1460 | 7 |
1274566 | 1274566 | 2021-05-01 | Grand | Colorado | 8049 | 1455 | 7 |
1271319 | 1271319 | 2021-04-30 | Grand | Colorado | 8049 | 1451 | 7 |
1268072 | 1268072 | 2021-04-29 | Grand | Colorado | 8049 | 1449 | 7 |
1264825 | 1264825 | 2021-04-28 | Grand | Colorado | 8049 | 1441 | 7 |
1261578 | 1261578 | 2021-04-27 | Grand | Colorado | 8049 | 1440 | 7 |
1258331 | 1258331 | 2021-04-26 | Grand | Colorado | 8049 | 1437 | 7 |
1255084 | 1255084 | 2021-04-25 | Grand | Colorado | 8049 | 1437 | 7 |
1251837 | 1251837 | 2021-04-24 | Grand | Colorado | 8049 | 1427 | 7 |
1248590 | 1248590 | 2021-04-23 | Grand | Colorado | 8049 | 1422 | 6 |
1245343 | 1245343 | 2021-04-22 | Grand | Colorado | 8049 | 1420 | 6 |
1242096 | 1242096 | 2021-04-21 | Grand | Colorado | 8049 | 1412 | 6 |
1238849 | 1238849 | 2021-04-20 | Grand | Colorado | 8049 | 1412 | 6 |
1235602 | 1235602 | 2021-04-19 | Grand | Colorado | 8049 | 1409 | 6 |
1232355 | 1232355 | 2021-04-18 | Grand | Colorado | 8049 | 1408 | 6 |
1229106 | 1229106 | 2021-04-17 | Grand | Colorado | 8049 | 1404 | 6 |
1225858 | 1225858 | 2021-04-16 | Grand | Colorado | 8049 | 1400 | 6 |
1222611 | 1222611 | 2021-04-15 | Grand | Colorado | 8049 | 1397 | 6 |
1219363 | 1219363 | 2021-04-14 | Grand | Colorado | 8049 | 1390 | 6 |
1216115 | 1216115 | 2021-04-13 | Grand | Colorado | 8049 | 1390 | 6 |
1212868 | 1212868 | 2021-04-12 | Grand | Colorado | 8049 | 1386 | 6 |
1209620 | 1209620 | 2021-04-11 | Grand | Colorado | 8049 | 1380 | 6 |
1206371 | 1206371 | 2021-04-10 | Grand | Colorado | 8049 | 1374 | 6 |
1203123 | 1203123 | 2021-04-09 | Grand | Colorado | 8049 | 1370 | 6 |
1199875 | 1199875 | 2021-04-08 | Grand | Colorado | 8049 | 1369 | 6 |
1196626 | 1196626 | 2021-04-07 | Grand | Colorado | 8049 | 1351 | 6 |
1193378 | 1193378 | 2021-04-06 | Grand | Colorado | 8049 | 1351 | 6 |
1190128 | 1190128 | 2021-04-05 | Grand | Colorado | 8049 | 1350 | 6 |
1186881 | 1186881 | 2021-04-04 | Grand | Colorado | 8049 | 1344 | 6 |
1183634 | 1183634 | 2021-04-03 | Grand | Colorado | 8049 | 1343 | 6 |
1180387 | 1180387 | 2021-04-02 | Grand | Colorado | 8049 | 1342 | 6 |
1177140 | 1177140 | 2021-04-01 | Grand | Colorado | 8049 | 1338 | 6 |
1173893 | 1173893 | 2021-03-31 | Grand | Colorado | 8049 | 1335 | 6 |
1170646 | 1170646 | 2021-03-30 | Grand | Colorado | 8049 | 1329 | 6 |
1167398 | 1167398 | 2021-03-29 | Grand | Colorado | 8049 | 1327 | 6 |
1164150 | 1164150 | 2021-03-28 | Grand | Colorado | 8049 | 1327 | 6 |
1160902 | 1160902 | 2021-03-27 | Grand | Colorado | 8049 | 1324 | 6 |
1157654 | 1157654 | 2021-03-26 | Grand | Colorado | 8049 | 1322 | 6 |
1154407 | 1154407 | 2021-03-25 | Grand | Colorado | 8049 | 1318 | 6 |
1151160 | 1151160 | 2021-03-24 | Grand | Colorado | 8049 | 1317 | 6 |
1147913 | 1147913 | 2021-03-23 | Grand | Colorado | 8049 | 1313 | 6 |
1144666 | 1144666 | 2021-03-22 | Grand | Colorado | 8049 | 1312 | 6 |
1141419 | 1141419 | 2021-03-21 | Grand | Colorado | 8049 | 1312 | 6 |
1138173 | 1138173 | 2021-03-20 | Grand | Colorado | 8049 | 1310 | 6 |
1134927 | 1134927 | 2021-03-19 | Grand | Colorado | 8049 | 1309 | 6 |
1131680 | 1131680 | 2021-03-18 | Grand | Colorado | 8049 | 1308 | 6 |
1128432 | 1128432 | 2021-03-17 | Grand | Colorado | 8049 | 1304 | 6 |
1125186 | 1125186 | 2021-03-16 | Grand | Colorado | 8049 | 1302 | 6 |
1121940 | 1121940 | 2021-03-15 | Grand | Colorado | 8049 | 1301 | 6 |
1118693 | 1118693 | 2021-03-14 | Grand | Colorado | 8049 | 1299 | 6 |
1115446 | 1115446 | 2021-03-13 | Grand | Colorado | 8049 | 1299 | 6 |
1112200 | 1112200 | 2021-03-12 | Grand | Colorado | 8049 | 1297 | 6 |
1108954 | 1108954 | 2021-03-11 | Grand | Colorado | 8049 | 1296 | 6 |
1105708 | 1105708 | 2021-03-10 | Grand | Colorado | 8049 | 1295 | 6 |
1102462 | 1102462 | 2021-03-09 | Grand | Colorado | 8049 | 1292 | 6 |
1099216 | 1099216 | 2021-03-08 | Grand | Colorado | 8049 | 1290 | 6 |
1095968 | 1095968 | 2021-03-07 | Grand | Colorado | 8049 | 1289 | 6 |
1092722 | 1092722 | 2021-03-06 | Grand | Colorado | 8049 | 1289 | 6 |
1089476 | 1089476 | 2021-03-05 | Grand | Colorado | 8049 | 1287 | 5 |
1086231 | 1086231 | 2021-03-04 | Grand | Colorado | 8049 | 1288 | 5 |
1082985 | 1082985 | 2021-03-03 | Grand | Colorado | 8049 | 1282 | 5 |
1079739 | 1079739 | 2021-03-02 | Grand | Colorado | 8049 | 1273 | 5 |
1076494 | 1076494 | 2021-03-01 | Grand | Colorado | 8049 | 1272 | 5 |
1073248 | 1073248 | 2021-02-28 | Grand | Colorado | 8049 | 1271 | 5 |
1070002 | 1070002 | 2021-02-27 | Grand | Colorado | 8049 | 1271 | 5 |
1066757 | 1066757 | 2021-02-26 | Grand | Colorado | 8049 | 1259 | 5 |
1063512 | 1063512 | 2021-02-25 | Grand | Colorado | 8049 | 1259 | 5 |
1060267 | 1060267 | 2021-02-24 | Grand | Colorado | 8049 | 1252 | 5 |
1057021 | 1057021 | 2021-02-23 | Grand | Colorado | 8049 | 1243 | 5 |
1053775 | 1053775 | 2021-02-22 | Grand | Colorado | 8049 | 1242 | 5 |
1050528 | 1050528 | 2021-02-21 | Grand | Colorado | 8049 | 1241 | 5 |
1047281 | 1047281 | 2021-02-20 | Grand | Colorado | 8049 | 1234 | 5 |
1044036 | 1044036 | 2021-02-19 | Grand | Colorado | 8049 | 1226 | 5 |
1040791 | 1040791 | 2021-02-18 | Grand | Colorado | 8049 | 1218 | 5 |
1037546 | 1037546 | 2021-02-17 | Grand | Colorado | 8049 | 1211 | 5 |
1034301 | 1034301 | 2021-02-16 | Grand | Colorado | 8049 | 1184 | 5 |
1031055 | 1031055 | 2021-02-15 | Grand | Colorado | 8049 | 1167 | 5 |
1027808 | 1027808 | 2021-02-14 | Grand | Colorado | 8049 | 1166 | 5 |
1024563 | 1024563 | 2021-02-13 | Grand | Colorado | 8049 | 1159 | 5 |
1021318 | 1021318 | 2021-02-12 | Grand | Colorado | 8049 | 1159 | 5 |
1018073 | 1018073 | 2021-02-11 | Grand | Colorado | 8049 | 1127 | 5 |
1014828 | 1014828 | 2021-02-10 | Grand | Colorado | 8049 | 1119 | 5 |
1011583 | 1011583 | 2021-02-09 | Grand | Colorado | 8049 | 1104 | 5 |
1008337 | 1008337 | 2021-02-08 | Grand | Colorado | 8049 | 1103 | 5 |
1005091 | 1005091 | 2021-02-07 | Grand | Colorado | 8049 | 1083 | 5 |
1001845 | 1001845 | 2021-02-06 | Grand | Colorado | 8049 | 1074 | 5 |
998599 | 998599 | 2021-02-05 | Grand | Colorado | 8049 | 1063 | 5 |
995353 | 995353 | 2021-02-04 | Grand | Colorado | 8049 | 1038 | 5 |
992107 | 992107 | 2021-02-03 | Grand | Colorado | 8049 | 1005 | 5 |
988861 | 988861 | 2021-02-02 | Grand | Colorado | 8049 | 979 | 5 |
985614 | 985614 | 2021-02-01 | Grand | Colorado | 8049 | 975 | 5 |
982367 | 982367 | 2021-01-31 | Grand | Colorado | 8049 | 930 | 5 |
979121 | 979121 | 2021-01-30 | Grand | Colorado | 8049 | 930 | 5 |
975876 | 975876 | 2021-01-29 | Grand | Colorado | 8049 | 930 | 5 |
972631 | 972631 | 2021-01-28 | Grand | Colorado | 8049 | 924 | 5 |
969386 | 969386 | 2021-01-27 | Grand | Colorado | 8049 | 917 | 5 |
966142 | 966142 | 2021-01-26 | Grand | Colorado | 8049 | 908 | 5 |
962897 | 962897 | 2021-01-25 | Grand | Colorado | 8049 | 898 | 5 |
959652 | 959652 | 2021-01-24 | Grand | Colorado | 8049 | 898 | 5 |
956406 | 956406 | 2021-01-23 | Grand | Colorado | 8049 | 892 | 5 |
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);