ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 8051 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1277814 | 1277814 | 2021-05-02 | Gunnison | Colorado | 8051 | 1324 | 6 |
1274567 | 1274567 | 2021-05-01 | Gunnison | Colorado | 8051 | 1324 | 6 |
1271320 | 1271320 | 2021-04-30 | Gunnison | Colorado | 8051 | 1322 | 6 |
1268073 | 1268073 | 2021-04-29 | Gunnison | Colorado | 8051 | 1321 | 6 |
1264826 | 1264826 | 2021-04-28 | Gunnison | Colorado | 8051 | 1317 | 6 |
1261579 | 1261579 | 2021-04-27 | Gunnison | Colorado | 8051 | 1317 | 6 |
1258332 | 1258332 | 2021-04-26 | Gunnison | Colorado | 8051 | 1312 | 6 |
1255085 | 1255085 | 2021-04-25 | Gunnison | Colorado | 8051 | 1312 | 6 |
1251838 | 1251838 | 2021-04-24 | Gunnison | Colorado | 8051 | 1310 | 6 |
1248591 | 1248591 | 2021-04-23 | Gunnison | Colorado | 8051 | 1307 | 6 |
1245344 | 1245344 | 2021-04-22 | Gunnison | Colorado | 8051 | 1307 | 6 |
1242097 | 1242097 | 2021-04-21 | Gunnison | Colorado | 8051 | 1303 | 6 |
1238850 | 1238850 | 2021-04-20 | Gunnison | Colorado | 8051 | 1303 | 6 |
1235603 | 1235603 | 2021-04-19 | Gunnison | Colorado | 8051 | 1299 | 6 |
1232356 | 1232356 | 2021-04-18 | Gunnison | Colorado | 8051 | 1298 | 6 |
1229107 | 1229107 | 2021-04-17 | Gunnison | Colorado | 8051 | 1296 | 6 |
1225859 | 1225859 | 2021-04-16 | Gunnison | Colorado | 8051 | 1292 | 6 |
1222612 | 1222612 | 2021-04-15 | Gunnison | Colorado | 8051 | 1288 | 6 |
1219364 | 1219364 | 2021-04-14 | Gunnison | Colorado | 8051 | 1285 | 6 |
1216116 | 1216116 | 2021-04-13 | Gunnison | Colorado | 8051 | 1276 | 6 |
1212869 | 1212869 | 2021-04-12 | Gunnison | Colorado | 8051 | 1275 | 6 |
1209621 | 1209621 | 2021-04-11 | Gunnison | Colorado | 8051 | 1275 | 6 |
1206372 | 1206372 | 2021-04-10 | Gunnison | Colorado | 8051 | 1273 | 6 |
1203124 | 1203124 | 2021-04-09 | Gunnison | Colorado | 8051 | 1272 | 6 |
1199876 | 1199876 | 2021-04-08 | Gunnison | Colorado | 8051 | 1265 | 6 |
1196627 | 1196627 | 2021-04-07 | Gunnison | Colorado | 8051 | 1262 | 6 |
1193379 | 1193379 | 2021-04-06 | Gunnison | Colorado | 8051 | 1262 | 6 |
1190129 | 1190129 | 2021-04-05 | Gunnison | Colorado | 8051 | 1262 | 6 |
1186882 | 1186882 | 2021-04-04 | Gunnison | Colorado | 8051 | 1262 | 6 |
1183635 | 1183635 | 2021-04-03 | Gunnison | Colorado | 8051 | 1260 | 6 |
1180388 | 1180388 | 2021-04-02 | Gunnison | Colorado | 8051 | 1259 | 6 |
1177141 | 1177141 | 2021-04-01 | Gunnison | Colorado | 8051 | 1258 | 6 |
1173894 | 1173894 | 2021-03-31 | Gunnison | Colorado | 8051 | 1252 | 6 |
1170647 | 1170647 | 2021-03-30 | Gunnison | Colorado | 8051 | 1242 | 6 |
1167399 | 1167399 | 2021-03-29 | Gunnison | Colorado | 8051 | 1241 | 6 |
1164151 | 1164151 | 2021-03-28 | Gunnison | Colorado | 8051 | 1240 | 6 |
1160903 | 1160903 | 2021-03-27 | Gunnison | Colorado | 8051 | 1238 | 6 |
1157655 | 1157655 | 2021-03-26 | Gunnison | Colorado | 8051 | 1232 | 6 |
1154408 | 1154408 | 2021-03-25 | Gunnison | Colorado | 8051 | 1230 | 6 |
1151161 | 1151161 | 2021-03-24 | Gunnison | Colorado | 8051 | 1227 | 6 |
1147914 | 1147914 | 2021-03-23 | Gunnison | Colorado | 8051 | 1225 | 6 |
1144667 | 1144667 | 2021-03-22 | Gunnison | Colorado | 8051 | 1225 | 6 |
1141420 | 1141420 | 2021-03-21 | Gunnison | Colorado | 8051 | 1225 | 6 |
1138174 | 1138174 | 2021-03-20 | Gunnison | Colorado | 8051 | 1225 | 6 |
1134928 | 1134928 | 2021-03-19 | Gunnison | Colorado | 8051 | 1225 | 6 |
1131681 | 1131681 | 2021-03-18 | Gunnison | Colorado | 8051 | 1225 | 6 |
1128433 | 1128433 | 2021-03-17 | Gunnison | Colorado | 8051 | 1224 | 6 |
1125187 | 1125187 | 2021-03-16 | Gunnison | Colorado | 8051 | 1225 | 6 |
1121941 | 1121941 | 2021-03-15 | Gunnison | Colorado | 8051 | 1226 | 6 |
1118694 | 1118694 | 2021-03-14 | Gunnison | Colorado | 8051 | 1226 | 6 |
1115447 | 1115447 | 2021-03-13 | Gunnison | Colorado | 8051 | 1225 | 6 |
1112201 | 1112201 | 2021-03-12 | Gunnison | Colorado | 8051 | 1222 | 6 |
1108955 | 1108955 | 2021-03-11 | Gunnison | Colorado | 8051 | 1218 | 6 |
1105709 | 1105709 | 2021-03-10 | Gunnison | Colorado | 8051 | 1215 | 6 |
1102463 | 1102463 | 2021-03-09 | Gunnison | Colorado | 8051 | 1214 | 6 |
1099217 | 1099217 | 2021-03-08 | Gunnison | Colorado | 8051 | 1212 | 6 |
1095969 | 1095969 | 2021-03-07 | Gunnison | Colorado | 8051 | 1212 | 6 |
1092723 | 1092723 | 2021-03-06 | Gunnison | Colorado | 8051 | 1212 | 6 |
1089477 | 1089477 | 2021-03-05 | Gunnison | Colorado | 8051 | 1211 | 6 |
1086232 | 1086232 | 2021-03-04 | Gunnison | Colorado | 8051 | 1211 | 6 |
1082986 | 1082986 | 2021-03-03 | Gunnison | Colorado | 8051 | 1211 | 6 |
1079740 | 1079740 | 2021-03-02 | Gunnison | Colorado | 8051 | 1207 | 6 |
1076495 | 1076495 | 2021-03-01 | Gunnison | Colorado | 8051 | 1203 | 6 |
1073249 | 1073249 | 2021-02-28 | Gunnison | Colorado | 8051 | 1203 | 6 |
1070003 | 1070003 | 2021-02-27 | Gunnison | Colorado | 8051 | 1202 | 6 |
1066758 | 1066758 | 2021-02-26 | Gunnison | Colorado | 8051 | 1199 | 6 |
1063513 | 1063513 | 2021-02-25 | Gunnison | Colorado | 8051 | 1199 | 6 |
1060268 | 1060268 | 2021-02-24 | Gunnison | Colorado | 8051 | 1198 | 6 |
1057022 | 1057022 | 2021-02-23 | Gunnison | Colorado | 8051 | 1192 | 6 |
1053776 | 1053776 | 2021-02-22 | Gunnison | Colorado | 8051 | 1182 | 6 |
1050529 | 1050529 | 2021-02-21 | Gunnison | Colorado | 8051 | 1181 | 6 |
1047282 | 1047282 | 2021-02-20 | Gunnison | Colorado | 8051 | 1182 | 6 |
1044037 | 1044037 | 2021-02-19 | Gunnison | Colorado | 8051 | 1181 | 6 |
1040792 | 1040792 | 2021-02-18 | Gunnison | Colorado | 8051 | 1179 | 6 |
1037547 | 1037547 | 2021-02-17 | Gunnison | Colorado | 8051 | 1179 | 6 |
1034302 | 1034302 | 2021-02-16 | Gunnison | Colorado | 8051 | 1176 | 6 |
1031056 | 1031056 | 2021-02-15 | Gunnison | Colorado | 8051 | 1175 | 6 |
1027809 | 1027809 | 2021-02-14 | Gunnison | Colorado | 8051 | 1175 | 6 |
1024564 | 1024564 | 2021-02-13 | Gunnison | Colorado | 8051 | 1159 | 6 |
1021319 | 1021319 | 2021-02-12 | Gunnison | Colorado | 8051 | 1138 | 6 |
1018074 | 1018074 | 2021-02-11 | Gunnison | Colorado | 8051 | 1100 | 6 |
1014829 | 1014829 | 2021-02-10 | Gunnison | Colorado | 8051 | 1092 | 6 |
1011584 | 1011584 | 2021-02-09 | Gunnison | Colorado | 8051 | 1091 | 6 |
1008338 | 1008338 | 2021-02-08 | Gunnison | Colorado | 8051 | 1089 | 6 |
1005092 | 1005092 | 2021-02-07 | Gunnison | Colorado | 8051 | 1086 | 6 |
1001846 | 1001846 | 2021-02-06 | Gunnison | Colorado | 8051 | 1082 | 6 |
998600 | 998600 | 2021-02-05 | Gunnison | Colorado | 8051 | 1079 | 6 |
995354 | 995354 | 2021-02-04 | Gunnison | Colorado | 8051 | 1075 | 6 |
992108 | 992108 | 2021-02-03 | Gunnison | Colorado | 8051 | 1069 | 6 |
988862 | 988862 | 2021-02-02 | Gunnison | Colorado | 8051 | 1061 | 6 |
985615 | 985615 | 2021-02-01 | Gunnison | Colorado | 8051 | 1056 | 6 |
982368 | 982368 | 2021-01-31 | Gunnison | Colorado | 8051 | 1042 | 6 |
979122 | 979122 | 2021-01-30 | Gunnison | Colorado | 8051 | 1042 | 6 |
975877 | 975877 | 2021-01-29 | Gunnison | Colorado | 8051 | 1042 | 6 |
972632 | 972632 | 2021-01-28 | Gunnison | Colorado | 8051 | 1034 | 6 |
969387 | 969387 | 2021-01-27 | Gunnison | Colorado | 8051 | 1029 | 6 |
966143 | 966143 | 2021-01-26 | Gunnison | Colorado | 8051 | 1014 | 6 |
962898 | 962898 | 2021-01-25 | Gunnison | Colorado | 8051 | 987 | 6 |
959653 | 959653 | 2021-01-24 | Gunnison | Colorado | 8051 | 987 | 6 |
956407 | 956407 | 2021-01-23 | Gunnison | Colorado | 8051 | 975 | 6 |
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);