ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Adams" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
953136 | 953136 | 2021-01-22 | Adams | Colorado | 8001 | 45305 | 582 |
949891 | 949891 | 2021-01-21 | Adams | Colorado | 8001 | 44980 | 578 |
946645 | 946645 | 2021-01-20 | Adams | Colorado | 8001 | 44980 | 578 |
943398 | 943398 | 2021-01-19 | Adams | Colorado | 8001 | 44877 | 577 |
940153 | 940153 | 2021-01-18 | Adams | Colorado | 8001 | 44683 | 577 |
936908 | 936908 | 2021-01-17 | Adams | Colorado | 8001 | 44595 | 576 |
933663 | 933663 | 2021-01-16 | Adams | Colorado | 8001 | 44426 | 575 |
930418 | 930418 | 2021-01-15 | Adams | Colorado | 8001 | 44253 | 568 |
927173 | 927173 | 2021-01-14 | Adams | Colorado | 8001 | 44077 | 567 |
923927 | 923927 | 2021-01-13 | Adams | Colorado | 8001 | 43821 | 564 |
920682 | 920682 | 2021-01-12 | Adams | Colorado | 8001 | 43644 | 562 |
917437 | 917437 | 2021-01-11 | Adams | Colorado | 8001 | 43529 | 559 |
914192 | 914192 | 2021-01-10 | Adams | Colorado | 8001 | 43370 | 559 |
910947 | 910947 | 2021-01-09 | Adams | Colorado | 8001 | 43090 | 556 |
907702 | 907702 | 2021-01-08 | Adams | Colorado | 8001 | 42493 | 547 |
904456 | 904456 | 2021-01-07 | Adams | Colorado | 8001 | 42493 | 547 |
901211 | 901211 | 2021-01-06 | Adams | Colorado | 8001 | 42170 | 543 |
897966 | 897966 | 2021-01-05 | Adams | Colorado | 8001 | 41785 | 537 |
894721 | 894721 | 2021-01-04 | Adams | Colorado | 8001 | 41506 | 536 |
891474 | 891474 | 2021-01-03 | Adams | Colorado | 8001 | 41102 | 535 |
888227 | 888227 | 2021-01-02 | Adams | Colorado | 8001 | 40904 | 535 |
884982 | 884982 | 2021-01-01 | Adams | Colorado | 8001 | 40696 | 533 |
881737 | 881737 | 2020-12-31 | Adams | Colorado | 8001 | 40344 | 529 |
878492 | 878492 | 2020-12-30 | Adams | Colorado | 8001 | 39915 | 524 |
875247 | 875247 | 2020-12-29 | Adams | Colorado | 8001 | 39711 | 515 |
872002 | 872002 | 2020-12-28 | Adams | Colorado | 8001 | 39486 | 513 |
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);