ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 8085 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1277831 | 1277831 | 2021-05-02 | Montrose | Colorado | 8085 | 3434 | 57 |
1274584 | 1274584 | 2021-05-01 | Montrose | Colorado | 8085 | 3430 | 57 |
1271337 | 1271337 | 2021-04-30 | Montrose | Colorado | 8085 | 3422 | 57 |
1268090 | 1268090 | 2021-04-29 | Montrose | Colorado | 8085 | 3415 | 57 |
1264843 | 1264843 | 2021-04-28 | Montrose | Colorado | 8085 | 3405 | 57 |
1261596 | 1261596 | 2021-04-27 | Montrose | Colorado | 8085 | 3403 | 57 |
1258349 | 1258349 | 2021-04-26 | Montrose | Colorado | 8085 | 3396 | 58 |
1255102 | 1255102 | 2021-04-25 | Montrose | Colorado | 8085 | 3396 | 58 |
1251855 | 1251855 | 2021-04-24 | Montrose | Colorado | 8085 | 3394 | 58 |
1248608 | 1248608 | 2021-04-23 | Montrose | Colorado | 8085 | 3387 | 57 |
1245361 | 1245361 | 2021-04-22 | Montrose | Colorado | 8085 | 3383 | 57 |
1242114 | 1242114 | 2021-04-21 | Montrose | Colorado | 8085 | 3377 | 57 |
1238867 | 1238867 | 2021-04-20 | Montrose | Colorado | 8085 | 3372 | 57 |
1235620 | 1235620 | 2021-04-19 | Montrose | Colorado | 8085 | 3371 | 57 |
1232373 | 1232373 | 2021-04-18 | Montrose | Colorado | 8085 | 3368 | 57 |
1229124 | 1229124 | 2021-04-17 | Montrose | Colorado | 8085 | 3365 | 57 |
1225876 | 1225876 | 2021-04-16 | Montrose | Colorado | 8085 | 3362 | 57 |
1222629 | 1222629 | 2021-04-15 | Montrose | Colorado | 8085 | 3361 | 57 |
1219381 | 1219381 | 2021-04-14 | Montrose | Colorado | 8085 | 3359 | 57 |
1216133 | 1216133 | 2021-04-13 | Montrose | Colorado | 8085 | 3354 | 57 |
1212886 | 1212886 | 2021-04-12 | Montrose | Colorado | 8085 | 3352 | 57 |
1209638 | 1209638 | 2021-04-11 | Montrose | Colorado | 8085 | 3351 | 57 |
1206389 | 1206389 | 2021-04-10 | Montrose | Colorado | 8085 | 3349 | 57 |
1203141 | 1203141 | 2021-04-09 | Montrose | Colorado | 8085 | 3346 | 57 |
1199893 | 1199893 | 2021-04-08 | Montrose | Colorado | 8085 | 3342 | 57 |
1196644 | 1196644 | 2021-04-07 | Montrose | Colorado | 8085 | 3335 | 57 |
1193396 | 1193396 | 2021-04-06 | Montrose | Colorado | 8085 | 3335 | 57 |
1190146 | 1190146 | 2021-04-05 | Montrose | Colorado | 8085 | 3336 | 57 |
1186899 | 1186899 | 2021-04-04 | Montrose | Colorado | 8085 | 3335 | 57 |
1183652 | 1183652 | 2021-04-03 | Montrose | Colorado | 8085 | 3333 | 57 |
1180405 | 1180405 | 2021-04-02 | Montrose | Colorado | 8085 | 3331 | 57 |
1177158 | 1177158 | 2021-04-01 | Montrose | Colorado | 8085 | 3330 | 57 |
1173911 | 1173911 | 2021-03-31 | Montrose | Colorado | 8085 | 3328 | 57 |
1170664 | 1170664 | 2021-03-30 | Montrose | Colorado | 8085 | 3324 | 57 |
1167416 | 1167416 | 2021-03-29 | Montrose | Colorado | 8085 | 3321 | 57 |
1164168 | 1164168 | 2021-03-28 | Montrose | Colorado | 8085 | 3321 | 57 |
1160920 | 1160920 | 2021-03-27 | Montrose | Colorado | 8085 | 3320 | 57 |
1157672 | 1157672 | 2021-03-26 | Montrose | Colorado | 8085 | 3315 | 57 |
1154425 | 1154425 | 2021-03-25 | Montrose | Colorado | 8085 | 3310 | 57 |
1151178 | 1151178 | 2021-03-24 | Montrose | Colorado | 8085 | 3307 | 57 |
1147931 | 1147931 | 2021-03-23 | Montrose | Colorado | 8085 | 3306 | 57 |
1144684 | 1144684 | 2021-03-22 | Montrose | Colorado | 8085 | 3303 | 57 |
1141437 | 1141437 | 2021-03-21 | Montrose | Colorado | 8085 | 3302 | 57 |
1138191 | 1138191 | 2021-03-20 | Montrose | Colorado | 8085 | 3301 | 56 |
1134945 | 1134945 | 2021-03-19 | Montrose | Colorado | 8085 | 3295 | 56 |
1131698 | 1131698 | 2021-03-18 | Montrose | Colorado | 8085 | 3293 | 56 |
1128450 | 1128450 | 2021-03-17 | Montrose | Colorado | 8085 | 3293 | 54 |
1125204 | 1125204 | 2021-03-16 | Montrose | Colorado | 8085 | 3292 | 54 |
1121958 | 1121958 | 2021-03-15 | Montrose | Colorado | 8085 | 3288 | 54 |
1118711 | 1118711 | 2021-03-14 | Montrose | Colorado | 8085 | 3286 | 54 |
1115464 | 1115464 | 2021-03-13 | Montrose | Colorado | 8085 | 3282 | 54 |
1112218 | 1112218 | 2021-03-12 | Montrose | Colorado | 8085 | 3280 | 54 |
1108972 | 1108972 | 2021-03-11 | Montrose | Colorado | 8085 | 3279 | 54 |
1105726 | 1105726 | 2021-03-10 | Montrose | Colorado | 8085 | 3278 | 53 |
1102480 | 1102480 | 2021-03-09 | Montrose | Colorado | 8085 | 3278 | 53 |
1099234 | 1099234 | 2021-03-08 | Montrose | Colorado | 8085 | 3277 | 53 |
1095986 | 1095986 | 2021-03-07 | Montrose | Colorado | 8085 | 3275 | 53 |
1092740 | 1092740 | 2021-03-06 | Montrose | Colorado | 8085 | 3275 | 53 |
1089494 | 1089494 | 2021-03-05 | Montrose | Colorado | 8085 | 3272 | 53 |
1086249 | 1086249 | 2021-03-04 | Montrose | Colorado | 8085 | 3272 | 53 |
1083003 | 1083003 | 2021-03-03 | Montrose | Colorado | 8085 | 3269 | 53 |
1079757 | 1079757 | 2021-03-02 | Montrose | Colorado | 8085 | 3265 | 53 |
1076512 | 1076512 | 2021-03-01 | Montrose | Colorado | 8085 | 3250 | 53 |
1073266 | 1073266 | 2021-02-28 | Montrose | Colorado | 8085 | 3244 | 53 |
1070020 | 1070020 | 2021-02-27 | Montrose | Colorado | 8085 | 3237 | 52 |
1066775 | 1066775 | 2021-02-26 | Montrose | Colorado | 8085 | 3223 | 52 |
1063530 | 1063530 | 2021-02-25 | Montrose | Colorado | 8085 | 3223 | 52 |
1060285 | 1060285 | 2021-02-24 | Montrose | Colorado | 8085 | 3204 | 52 |
1057039 | 1057039 | 2021-02-23 | Montrose | Colorado | 8085 | 3199 | 52 |
1053793 | 1053793 | 2021-02-22 | Montrose | Colorado | 8085 | 3195 | 52 |
1050546 | 1050546 | 2021-02-21 | Montrose | Colorado | 8085 | 3188 | 52 |
1047299 | 1047299 | 2021-02-20 | Montrose | Colorado | 8085 | 3186 | 52 |
1044054 | 1044054 | 2021-02-19 | Montrose | Colorado | 8085 | 3184 | 52 |
1040809 | 1040809 | 2021-02-18 | Montrose | Colorado | 8085 | 3178 | 51 |
1037564 | 1037564 | 2021-02-17 | Montrose | Colorado | 8085 | 3171 | 51 |
1034319 | 1034319 | 2021-02-16 | Montrose | Colorado | 8085 | 3165 | 51 |
1031073 | 1031073 | 2021-02-15 | Montrose | Colorado | 8085 | 3158 | 51 |
1027826 | 1027826 | 2021-02-14 | Montrose | Colorado | 8085 | 3152 | 51 |
1024581 | 1024581 | 2021-02-13 | Montrose | Colorado | 8085 | 3138 | 51 |
1021336 | 1021336 | 2021-02-12 | Montrose | Colorado | 8085 | 3133 | 51 |
1018091 | 1018091 | 2021-02-11 | Montrose | Colorado | 8085 | 3123 | 50 |
1014846 | 1014846 | 2021-02-10 | Montrose | Colorado | 8085 | 3107 | 50 |
1011601 | 1011601 | 2021-02-09 | Montrose | Colorado | 8085 | 3104 | 49 |
1008355 | 1008355 | 2021-02-08 | Montrose | Colorado | 8085 | 3095 | 49 |
1005109 | 1005109 | 2021-02-07 | Montrose | Colorado | 8085 | 3094 | 49 |
1001863 | 1001863 | 2021-02-06 | Montrose | Colorado | 8085 | 3077 | 46 |
998617 | 998617 | 2021-02-05 | Montrose | Colorado | 8085 | 3068 | 46 |
995371 | 995371 | 2021-02-04 | Montrose | Colorado | 8085 | 3054 | 45 |
992125 | 992125 | 2021-02-03 | Montrose | Colorado | 8085 | 3046 | 45 |
988879 | 988879 | 2021-02-02 | Montrose | Colorado | 8085 | 3030 | 45 |
985632 | 985632 | 2021-02-01 | Montrose | Colorado | 8085 | 3026 | 45 |
982385 | 982385 | 2021-01-31 | Montrose | Colorado | 8085 | 2976 | 45 |
979139 | 979139 | 2021-01-30 | Montrose | Colorado | 8085 | 2976 | 45 |
975894 | 975894 | 2021-01-29 | Montrose | Colorado | 8085 | 2976 | 45 |
972649 | 972649 | 2021-01-28 | Montrose | Colorado | 8085 | 2956 | 43 |
969404 | 969404 | 2021-01-27 | Montrose | Colorado | 8085 | 2925 | 42 |
966160 | 966160 | 2021-01-26 | Montrose | Colorado | 8085 | 2918 | 42 |
962915 | 962915 | 2021-01-25 | Montrose | Colorado | 8085 | 2900 | 42 |
959670 | 959670 | 2021-01-24 | Montrose | Colorado | 8085 | 2900 | 42 |
956424 | 956424 | 2021-01-23 | Montrose | Colorado | 8085 | 2865 | 41 |
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);