ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 8001 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1277788 | 1277788 | 2021-05-02 | Adams | Colorado | 8001 | 57422 | 701 |
1274541 | 1274541 | 2021-05-01 | Adams | Colorado | 8001 | 57233 | 701 |
1271294 | 1271294 | 2021-04-30 | Adams | Colorado | 8001 | 57234 | 701 |
1268047 | 1268047 | 2021-04-29 | Adams | Colorado | 8001 | 56999 | 701 |
1264800 | 1264800 | 2021-04-28 | Adams | Colorado | 8001 | 56577 | 699 |
1261553 | 1261553 | 2021-04-27 | Adams | Colorado | 8001 | 56578 | 699 |
1258306 | 1258306 | 2021-04-26 | Adams | Colorado | 8001 | 56421 | 698 |
1255059 | 1255059 | 2021-04-25 | Adams | Colorado | 8001 | 56140 | 698 |
1251812 | 1251812 | 2021-04-24 | Adams | Colorado | 8001 | 55876 | 695 |
1248565 | 1248565 | 2021-04-23 | Adams | Colorado | 8001 | 55876 | 695 |
1245318 | 1245318 | 2021-04-22 | Adams | Colorado | 8001 | 55656 | 692 |
1242071 | 1242071 | 2021-04-21 | Adams | Colorado | 8001 | 55434 | 692 |
1238824 | 1238824 | 2021-04-20 | Adams | Colorado | 8001 | 55322 | 690 |
1235577 | 1235577 | 2021-04-19 | Adams | Colorado | 8001 | 55124 | 689 |
1232330 | 1232330 | 2021-04-18 | Adams | Colorado | 8001 | 54665 | 685 |
1229081 | 1229081 | 2021-04-17 | Adams | Colorado | 8001 | 54665 | 685 |
1225833 | 1225833 | 2021-04-16 | Adams | Colorado | 8001 | 54665 | 685 |
1222586 | 1222586 | 2021-04-15 | Adams | Colorado | 8001 | 54498 | 685 |
1219338 | 1219338 | 2021-04-14 | Adams | Colorado | 8001 | 54282 | 685 |
1216090 | 1216090 | 2021-04-13 | Adams | Colorado | 8001 | 54100 | 684 |
1212843 | 1212843 | 2021-04-12 | Adams | Colorado | 8001 | 53996 | 646 |
1209595 | 1209595 | 2021-04-11 | Adams | Colorado | 8001 | 53878 | 646 |
1206346 | 1206346 | 2021-04-10 | Adams | Colorado | 8001 | 53537 | 646 |
1203098 | 1203098 | 2021-04-09 | Adams | Colorado | 8001 | 53538 | 644 |
1199850 | 1199850 | 2021-04-08 | Adams | Colorado | 8001 | 53360 | 644 |
1196601 | 1196601 | 2021-04-07 | Adams | Colorado | 8001 | 53167 | 643 |
1193353 | 1193353 | 2021-04-06 | Adams | Colorado | 8001 | 53068 | 643 |
1190103 | 1190103 | 2021-04-05 | Adams | Colorado | 8001 | 52982 | 642 |
1186856 | 1186856 | 2021-04-04 | Adams | Colorado | 8001 | 52890 | 642 |
1183609 | 1183609 | 2021-04-03 | Adams | Colorado | 8001 | 52599 | 641 |
1180362 | 1180362 | 2021-04-02 | Adams | Colorado | 8001 | 52599 | 641 |
1177115 | 1177115 | 2021-04-01 | Adams | Colorado | 8001 | 52466 | 641 |
1173868 | 1173868 | 2021-03-31 | Adams | Colorado | 8001 | 52312 | 641 |
1170621 | 1170621 | 2021-03-30 | Adams | Colorado | 8001 | 52190 | 640 |
1167373 | 1167373 | 2021-03-29 | Adams | Colorado | 8001 | 52137 | 639 |
1164125 | 1164125 | 2021-03-28 | Adams | Colorado | 8001 | 51972 | 640 |
1160877 | 1160877 | 2021-03-27 | Adams | Colorado | 8001 | 51972 | 640 |
1157629 | 1157629 | 2021-03-26 | Adams | Colorado | 8001 | 51597 | 640 |
1154382 | 1154382 | 2021-03-25 | Adams | Colorado | 8001 | 51597 | 640 |
1151135 | 1151135 | 2021-03-24 | Adams | Colorado | 8001 | 51597 | 640 |
1147888 | 1147888 | 2021-03-23 | Adams | Colorado | 8001 | 51275 | 639 |
1144641 | 1144641 | 2021-03-22 | Adams | Colorado | 8001 | 51275 | 639 |
1141394 | 1141394 | 2021-03-21 | Adams | Colorado | 8001 | 51275 | 639 |
1138148 | 1138148 | 2021-03-20 | Adams | Colorado | 8001 | 51273 | 639 |
1134902 | 1134902 | 2021-03-19 | Adams | Colorado | 8001 | 51011 | 638 |
1131655 | 1131655 | 2021-03-18 | Adams | Colorado | 8001 | 51011 | 638 |
1128407 | 1128407 | 2021-03-17 | Adams | Colorado | 8001 | 50874 | 637 |
1125161 | 1125161 | 2021-03-16 | Adams | Colorado | 8001 | 50793 | 637 |
1121915 | 1121915 | 2021-03-15 | Adams | Colorado | 8001 | 50778 | 636 |
1118668 | 1118668 | 2021-03-14 | Adams | Colorado | 8001 | 50575 | 636 |
1115421 | 1115421 | 2021-03-13 | Adams | Colorado | 8001 | 50575 | 636 |
1112175 | 1112175 | 2021-03-12 | Adams | Colorado | 8001 | 50472 | 636 |
1108929 | 1108929 | 2021-03-11 | Adams | Colorado | 8001 | 50389 | 636 |
1105683 | 1105683 | 2021-03-10 | Adams | Colorado | 8001 | 50310 | 633 |
1102437 | 1102437 | 2021-03-09 | Adams | Colorado | 8001 | 50208 | 631 |
1099191 | 1099191 | 2021-03-08 | Adams | Colorado | 8001 | 50149 | 631 |
1095943 | 1095943 | 2021-03-07 | Adams | Colorado | 8001 | 49858 | 631 |
1092697 | 1092697 | 2021-03-06 | Adams | Colorado | 8001 | 49858 | 631 |
1089451 | 1089451 | 2021-03-05 | Adams | Colorado | 8001 | 49858 | 631 |
1086206 | 1086206 | 2021-03-04 | Adams | Colorado | 8001 | 49759 | 631 |
1082960 | 1082960 | 2021-03-03 | Adams | Colorado | 8001 | 49615 | 630 |
1079714 | 1079714 | 2021-03-02 | Adams | Colorado | 8001 | 49497 | 628 |
1076469 | 1076469 | 2021-03-01 | Adams | Colorado | 8001 | 49444 | 628 |
1073223 | 1073223 | 2021-02-28 | Adams | Colorado | 8001 | 49369 | 628 |
1069977 | 1069977 | 2021-02-27 | Adams | Colorado | 8001 | 49264 | 628 |
1066732 | 1066732 | 2021-02-26 | Adams | Colorado | 8001 | 49150 | 628 |
1063487 | 1063487 | 2021-02-25 | Adams | Colorado | 8001 | 48996 | 627 |
1060242 | 1060242 | 2021-02-24 | Adams | Colorado | 8001 | 48876 | 627 |
1056996 | 1056996 | 2021-02-23 | Adams | Colorado | 8001 | 48791 | 627 |
1053750 | 1053750 | 2021-02-22 | Adams | Colorado | 8001 | 48712 | 627 |
1050503 | 1050503 | 2021-02-21 | Adams | Colorado | 8001 | 48643 | 627 |
1047256 | 1047256 | 2021-02-20 | Adams | Colorado | 8001 | 48525 | 626 |
1044011 | 1044011 | 2021-02-19 | Adams | Colorado | 8001 | 48380 | 625 |
1040766 | 1040766 | 2021-02-18 | Adams | Colorado | 8001 | 48279 | 625 |
1037521 | 1037521 | 2021-02-17 | Adams | Colorado | 8001 | 48149 | 623 |
1034276 | 1034276 | 2021-02-16 | Adams | Colorado | 8001 | 48071 | 623 |
1031030 | 1031030 | 2021-02-15 | Adams | Colorado | 8001 | 48032 | 623 |
1027783 | 1027783 | 2021-02-14 | Adams | Colorado | 8001 | 47830 | 623 |
1024538 | 1024538 | 2021-02-13 | Adams | Colorado | 8001 | 47830 | 623 |
1021293 | 1021293 | 2021-02-12 | Adams | Colorado | 8001 | 47784 | 623 |
1018048 | 1018048 | 2021-02-11 | Adams | Colorado | 8001 | 47511 | 623 |
1014803 | 1014803 | 2021-02-10 | Adams | Colorado | 8001 | 47503 | 623 |
1011558 | 1011558 | 2021-02-09 | Adams | Colorado | 8001 | 47449 | 620 |
1008312 | 1008312 | 2021-02-08 | Adams | Colorado | 8001 | 47390 | 619 |
1005066 | 1005066 | 2021-02-07 | Adams | Colorado | 8001 | 47314 | 619 |
1001820 | 1001820 | 2021-02-06 | Adams | Colorado | 8001 | 47218 | 618 |
998574 | 998574 | 2021-02-05 | Adams | Colorado | 8001 | 47080 | 615 |
995328 | 995328 | 2021-02-04 | Adams | Colorado | 8001 | 46896 | 613 |
992082 | 992082 | 2021-02-03 | Adams | Colorado | 8001 | 46755 | 612 |
988836 | 988836 | 2021-02-02 | Adams | Colorado | 8001 | 46655 | 611 |
985589 | 985589 | 2021-02-01 | Adams | Colorado | 8001 | 46592 | 610 |
982342 | 982342 | 2021-01-31 | Adams | Colorado | 8001 | 46516 | 609 |
979096 | 979096 | 2021-01-30 | Adams | Colorado | 8001 | 46268 | 603 |
975851 | 975851 | 2021-01-29 | Adams | Colorado | 8001 | 46268 | 603 |
972606 | 972606 | 2021-01-28 | Adams | Colorado | 8001 | 46101 | 600 |
969361 | 969361 | 2021-01-27 | Adams | Colorado | 8001 | 45944 | 597 |
966117 | 966117 | 2021-01-26 | Adams | Colorado | 8001 | 45750 | 590 |
962872 | 962872 | 2021-01-25 | Adams | Colorado | 8001 | 45750 | 590 |
959627 | 959627 | 2021-01-24 | Adams | Colorado | 8001 | 45480 | 587 |
956381 | 956381 | 2021-01-23 | Adams | Colorado | 8001 | 45305 | 582 |
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);