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 |
---|---|---|---|---|---|---|---|
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 |
868757 | 868757 | 2020-12-27 | Adams | Colorado | 8001 | 39189 | 505 |
865512 | 865512 | 2020-12-26 | Adams | Colorado | 8001 | 39094 | 505 |
862267 | 862267 | 2020-12-25 | Adams | Colorado | 8001 | 38882 | 499 |
859022 | 859022 | 2020-12-24 | Adams | Colorado | 8001 | 38517 | 499 |
855777 | 855777 | 2020-12-23 | Adams | Colorado | 8001 | 38309 | 489 |
852532 | 852532 | 2020-12-22 | Adams | Colorado | 8001 | 38081 | 484 |
849287 | 849287 | 2020-12-21 | Adams | Colorado | 8001 | 37848 | 477 |
846042 | 846042 | 2020-12-20 | Adams | Colorado | 8001 | 37620 | 477 |
842796 | 842796 | 2020-12-19 | Adams | Colorado | 8001 | 37413 | 471 |
839551 | 839551 | 2020-12-18 | Adams | Colorado | 8001 | 37007 | 459 |
836306 | 836306 | 2020-12-17 | Adams | Colorado | 8001 | 36604 | 452 |
833060 | 833060 | 2020-12-16 | Adams | Colorado | 8001 | 36306 | 443 |
829813 | 829813 | 2020-12-15 | Adams | Colorado | 8001 | 36130 | 437 |
826567 | 826567 | 2020-12-14 | Adams | Colorado | 8001 | 35808 | 434 |
823320 | 823320 | 2020-12-13 | Adams | Colorado | 8001 | 35516 | 430 |
820074 | 820074 | 2020-12-12 | Adams | Colorado | 8001 | 35273 | 418 |
816828 | 816828 | 2020-12-11 | Adams | Colorado | 8001 | 34701 | 412 |
813582 | 813582 | 2020-12-10 | Adams | Colorado | 8001 | 34248 | 409 |
810338 | 810338 | 2020-12-09 | Adams | Colorado | 8001 | 33825 | 400 |
807093 | 807093 | 2020-12-08 | Adams | Colorado | 8001 | 33469 | 391 |
803848 | 803848 | 2020-12-07 | Adams | Colorado | 8001 | 33049 | 389 |
800603 | 800603 | 2020-12-06 | Adams | Colorado | 8001 | 32678 | 386 |
797358 | 797358 | 2020-12-05 | Adams | Colorado | 8001 | 32044 | 374 |
794113 | 794113 | 2020-12-04 | Adams | Colorado | 8001 | 31594 | 373 |
790868 | 790868 | 2020-12-03 | Adams | Colorado | 8001 | 31038 | 367 |
787623 | 787623 | 2020-12-02 | Adams | Colorado | 8001 | 30646 | 346 |
784379 | 784379 | 2020-12-01 | Adams | Colorado | 8001 | 30381 | 340 |
781134 | 781134 | 2020-11-30 | Adams | Colorado | 8001 | 29730 | 336 |
777888 | 777888 | 2020-11-29 | Adams | Colorado | 8001 | 29252 | 334 |
774643 | 774643 | 2020-11-28 | Adams | Colorado | 8001 | 28839 | 331 |
771398 | 771398 | 2020-11-27 | Adams | Colorado | 8001 | 28413 | 331 |
768153 | 768153 | 2020-11-26 | Adams | Colorado | 8001 | 27856 | 329 |
764907 | 764907 | 2020-11-25 | Adams | Colorado | 8001 | 27259 | 321 |
761662 | 761662 | 2020-11-24 | Adams | Colorado | 8001 | 26942 | 317 |
758417 | 758417 | 2020-11-23 | Adams | Colorado | 8001 | 26474 | 316 |
755170 | 755170 | 2020-11-22 | Adams | Colorado | 8001 | 26129 | 315 |
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);