ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 8087 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1277832 | 1277832 | 2021-05-02 | Morgan | Colorado | 8087 | 2631 | 93 |
1274585 | 1274585 | 2021-05-01 | Morgan | Colorado | 8087 | 2630 | 93 |
1271338 | 1271338 | 2021-04-30 | Morgan | Colorado | 8087 | 2623 | 93 |
1268091 | 1268091 | 2021-04-29 | Morgan | Colorado | 8087 | 2618 | 93 |
1264844 | 1264844 | 2021-04-28 | Morgan | Colorado | 8087 | 2609 | 93 |
1261597 | 1261597 | 2021-04-27 | Morgan | Colorado | 8087 | 2609 | 93 |
1258350 | 1258350 | 2021-04-26 | Morgan | Colorado | 8087 | 2601 | 93 |
1255103 | 1255103 | 2021-04-25 | Morgan | Colorado | 8087 | 2601 | 93 |
1251856 | 1251856 | 2021-04-24 | Morgan | Colorado | 8087 | 2598 | 93 |
1248609 | 1248609 | 2021-04-23 | Morgan | Colorado | 8087 | 2593 | 93 |
1245362 | 1245362 | 2021-04-22 | Morgan | Colorado | 8087 | 2585 | 93 |
1242115 | 1242115 | 2021-04-21 | Morgan | Colorado | 8087 | 2581 | 93 |
1238868 | 1238868 | 2021-04-20 | Morgan | Colorado | 8087 | 2578 | 93 |
1235621 | 1235621 | 2021-04-19 | Morgan | Colorado | 8087 | 2576 | 93 |
1232374 | 1232374 | 2021-04-18 | Morgan | Colorado | 8087 | 2573 | 93 |
1229125 | 1229125 | 2021-04-17 | Morgan | Colorado | 8087 | 2573 | 93 |
1225877 | 1225877 | 2021-04-16 | Morgan | Colorado | 8087 | 2569 | 93 |
1222630 | 1222630 | 2021-04-15 | Morgan | Colorado | 8087 | 2566 | 93 |
1219382 | 1219382 | 2021-04-14 | Morgan | Colorado | 8087 | 2559 | 93 |
1216134 | 1216134 | 2021-04-13 | Morgan | Colorado | 8087 | 2561 | 93 |
1212887 | 1212887 | 2021-04-12 | Morgan | Colorado | 8087 | 2560 | 93 |
1209639 | 1209639 | 2021-04-11 | Morgan | Colorado | 8087 | 2557 | 93 |
1206390 | 1206390 | 2021-04-10 | Morgan | Colorado | 8087 | 2554 | 93 |
1203142 | 1203142 | 2021-04-09 | Morgan | Colorado | 8087 | 2553 | 93 |
1199894 | 1199894 | 2021-04-08 | Morgan | Colorado | 8087 | 2548 | 93 |
1196645 | 1196645 | 2021-04-07 | Morgan | Colorado | 8087 | 2545 | 92 |
1193397 | 1193397 | 2021-04-06 | Morgan | Colorado | 8087 | 2545 | 92 |
1190147 | 1190147 | 2021-04-05 | Morgan | Colorado | 8087 | 2543 | 92 |
1186900 | 1186900 | 2021-04-04 | Morgan | Colorado | 8087 | 2542 | 92 |
1183653 | 1183653 | 2021-04-03 | Morgan | Colorado | 8087 | 2542 | 92 |
1180406 | 1180406 | 2021-04-02 | Morgan | Colorado | 8087 | 2541 | 92 |
1177159 | 1177159 | 2021-04-01 | Morgan | Colorado | 8087 | 2540 | 92 |
1173912 | 1173912 | 2021-03-31 | Morgan | Colorado | 8087 | 2535 | 92 |
1170665 | 1170665 | 2021-03-30 | Morgan | Colorado | 8087 | 2531 | 92 |
1167417 | 1167417 | 2021-03-29 | Morgan | Colorado | 8087 | 2529 | 92 |
1164169 | 1164169 | 2021-03-28 | Morgan | Colorado | 8087 | 2526 | 92 |
1160921 | 1160921 | 2021-03-27 | Morgan | Colorado | 8087 | 2526 | 92 |
1157673 | 1157673 | 2021-03-26 | Morgan | Colorado | 8087 | 2523 | 92 |
1154426 | 1154426 | 2021-03-25 | Morgan | Colorado | 8087 | 2519 | 92 |
1151179 | 1151179 | 2021-03-24 | Morgan | Colorado | 8087 | 2517 | 92 |
1147932 | 1147932 | 2021-03-23 | Morgan | Colorado | 8087 | 2515 | 92 |
1144685 | 1144685 | 2021-03-22 | Morgan | Colorado | 8087 | 2509 | 92 |
1141438 | 1141438 | 2021-03-21 | Morgan | Colorado | 8087 | 2508 | 92 |
1138192 | 1138192 | 2021-03-20 | Morgan | Colorado | 8087 | 2504 | 92 |
1134946 | 1134946 | 2021-03-19 | Morgan | Colorado | 8087 | 2500 | 92 |
1131699 | 1131699 | 2021-03-18 | Morgan | Colorado | 8087 | 2492 | 92 |
1128451 | 1128451 | 2021-03-17 | Morgan | Colorado | 8087 | 2483 | 92 |
1125205 | 1125205 | 2021-03-16 | Morgan | Colorado | 8087 | 2483 | 92 |
1121959 | 1121959 | 2021-03-15 | Morgan | Colorado | 8087 | 2481 | 91 |
1118712 | 1118712 | 2021-03-14 | Morgan | Colorado | 8087 | 2480 | 91 |
1115465 | 1115465 | 2021-03-13 | Morgan | Colorado | 8087 | 2477 | 91 |
1112219 | 1112219 | 2021-03-12 | Morgan | Colorado | 8087 | 2474 | 90 |
1108973 | 1108973 | 2021-03-11 | Morgan | Colorado | 8087 | 2466 | 90 |
1105727 | 1105727 | 2021-03-10 | Morgan | Colorado | 8087 | 2460 | 90 |
1102481 | 1102481 | 2021-03-09 | Morgan | Colorado | 8087 | 2457 | 90 |
1099235 | 1099235 | 2021-03-08 | Morgan | Colorado | 8087 | 2455 | 90 |
1095987 | 1095987 | 2021-03-07 | Morgan | Colorado | 8087 | 2450 | 90 |
1092741 | 1092741 | 2021-03-06 | Morgan | Colorado | 8087 | 2450 | 90 |
1089495 | 1089495 | 2021-03-05 | Morgan | Colorado | 8087 | 2446 | 90 |
1086250 | 1086250 | 2021-03-04 | Morgan | Colorado | 8087 | 2442 | 90 |
1083004 | 1083004 | 2021-03-03 | Morgan | Colorado | 8087 | 2435 | 90 |
1079758 | 1079758 | 2021-03-02 | Morgan | Colorado | 8087 | 2433 | 90 |
1076513 | 1076513 | 2021-03-01 | Morgan | Colorado | 8087 | 2434 | 90 |
1073267 | 1073267 | 2021-02-28 | Morgan | Colorado | 8087 | 2423 | 90 |
1070021 | 1070021 | 2021-02-27 | Morgan | Colorado | 8087 | 2422 | 90 |
1066776 | 1066776 | 2021-02-26 | Morgan | Colorado | 8087 | 2416 | 90 |
1063531 | 1063531 | 2021-02-25 | Morgan | Colorado | 8087 | 2416 | 90 |
1060286 | 1060286 | 2021-02-24 | Morgan | Colorado | 8087 | 2416 | 90 |
1057040 | 1057040 | 2021-02-23 | Morgan | Colorado | 8087 | 2415 | 90 |
1053794 | 1053794 | 2021-02-22 | Morgan | Colorado | 8087 | 2415 | 90 |
1050547 | 1050547 | 2021-02-21 | Morgan | Colorado | 8087 | 2415 | 90 |
1047300 | 1047300 | 2021-02-20 | Morgan | Colorado | 8087 | 2412 | 90 |
1044055 | 1044055 | 2021-02-19 | Morgan | Colorado | 8087 | 2413 | 90 |
1040810 | 1040810 | 2021-02-18 | Morgan | Colorado | 8087 | 2409 | 90 |
1037565 | 1037565 | 2021-02-17 | Morgan | Colorado | 8087 | 2406 | 90 |
1034320 | 1034320 | 2021-02-16 | Morgan | Colorado | 8087 | 2405 | 90 |
1031074 | 1031074 | 2021-02-15 | Morgan | Colorado | 8087 | 2405 | 90 |
1027827 | 1027827 | 2021-02-14 | Morgan | Colorado | 8087 | 2403 | 90 |
1024582 | 1024582 | 2021-02-13 | Morgan | Colorado | 8087 | 2404 | 90 |
1021337 | 1021337 | 2021-02-12 | Morgan | Colorado | 8087 | 2402 | 90 |
1018092 | 1018092 | 2021-02-11 | Morgan | Colorado | 8087 | 2397 | 90 |
1014847 | 1014847 | 2021-02-10 | Morgan | Colorado | 8087 | 2398 | 89 |
1011602 | 1011602 | 2021-02-09 | Morgan | Colorado | 8087 | 2396 | 89 |
1008356 | 1008356 | 2021-02-08 | Morgan | Colorado | 8087 | 2393 | 89 |
1005110 | 1005110 | 2021-02-07 | Morgan | Colorado | 8087 | 2389 | 89 |
1001864 | 1001864 | 2021-02-06 | Morgan | Colorado | 8087 | 2386 | 89 |
998618 | 998618 | 2021-02-05 | Morgan | Colorado | 8087 | 2381 | 89 |
995372 | 995372 | 2021-02-04 | Morgan | Colorado | 8087 | 2374 | 89 |
992126 | 992126 | 2021-02-03 | Morgan | Colorado | 8087 | 2370 | 89 |
988880 | 988880 | 2021-02-02 | Morgan | Colorado | 8087 | 2367 | 89 |
985633 | 985633 | 2021-02-01 | Morgan | Colorado | 8087 | 2366 | 89 |
982386 | 982386 | 2021-01-31 | Morgan | Colorado | 8087 | 2354 | 88 |
979140 | 979140 | 2021-01-30 | Morgan | Colorado | 8087 | 2354 | 88 |
975895 | 975895 | 2021-01-29 | Morgan | Colorado | 8087 | 2354 | 88 |
972650 | 972650 | 2021-01-28 | Morgan | Colorado | 8087 | 2349 | 88 |
969405 | 969405 | 2021-01-27 | Morgan | Colorado | 8087 | 2345 | 88 |
966161 | 966161 | 2021-01-26 | Morgan | Colorado | 8087 | 2342 | 88 |
962916 | 962916 | 2021-01-25 | Morgan | Colorado | 8087 | 2338 | 87 |
959671 | 959671 | 2021-01-24 | Morgan | Colorado | 8087 | 2338 | 87 |
956425 | 956425 | 2021-01-23 | Morgan | Colorado | 8087 | 2337 | 87 |
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);