ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Denver" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
953152 | 953152 | 2021-01-22 | Denver | Colorado | 8031 | 54163 | 728 |
949907 | 949907 | 2021-01-21 | Denver | Colorado | 8031 | 54006 | 728 |
946661 | 946661 | 2021-01-20 | Denver | Colorado | 8031 | 53777 | 725 |
943414 | 943414 | 2021-01-19 | Denver | Colorado | 8031 | 53625 | 721 |
940169 | 940169 | 2021-01-18 | Denver | Colorado | 8031 | 53460 | 720 |
936924 | 936924 | 2021-01-17 | Denver | Colorado | 8031 | 53319 | 720 |
933679 | 933679 | 2021-01-16 | Denver | Colorado | 8031 | 53158 | 720 |
930434 | 930434 | 2021-01-15 | Denver | Colorado | 8031 | 52917 | 720 |
927189 | 927189 | 2021-01-14 | Denver | Colorado | 8031 | 52624 | 715 |
923943 | 923943 | 2021-01-13 | Denver | Colorado | 8031 | 52354 | 713 |
920698 | 920698 | 2021-01-12 | Denver | Colorado | 8031 | 51986 | 708 |
917453 | 917453 | 2021-01-11 | Denver | Colorado | 8031 | 51825 | 708 |
914208 | 914208 | 2021-01-10 | Denver | Colorado | 8031 | 51618 | 707 |
910963 | 910963 | 2021-01-09 | Denver | Colorado | 8031 | 51355 | 706 |
907718 | 907718 | 2021-01-08 | Denver | Colorado | 8031 | 51047 | 699 |
904472 | 904472 | 2021-01-07 | Denver | Colorado | 8031 | 50658 | 694 |
901227 | 901227 | 2021-01-06 | Denver | Colorado | 8031 | 49991 | 684 |
897982 | 897982 | 2021-01-05 | Denver | Colorado | 8031 | 49648 | 681 |
894737 | 894737 | 2021-01-04 | Denver | Colorado | 8031 | 48605 | 681 |
891490 | 891490 | 2021-01-03 | Denver | Colorado | 8031 | 48433 | 681 |
888243 | 888243 | 2021-01-02 | Denver | Colorado | 8031 | 48246 | 679 |
884998 | 884998 | 2021-01-01 | Denver | Colorado | 8031 | 48023 | 674 |
881753 | 881753 | 2020-12-31 | Denver | Colorado | 8031 | 47711 | 674 |
878508 | 878508 | 2020-12-30 | Denver | Colorado | 8031 | 47353 | 672 |
875263 | 875263 | 2020-12-29 | Denver | Colorado | 8031 | 46917 | 667 |
872018 | 872018 | 2020-12-28 | Denver | Colorado | 8031 | 46708 | 662 |
868773 | 868773 | 2020-12-27 | Denver | Colorado | 8031 | 46570 | 658 |
865528 | 865528 | 2020-12-26 | Denver | Colorado | 8031 | 46455 | 658 |
862283 | 862283 | 2020-12-25 | Denver | Colorado | 8031 | 46258 | 654 |
859038 | 859038 | 2020-12-24 | Denver | Colorado | 8031 | 45920 | 654 |
855793 | 855793 | 2020-12-23 | Denver | Colorado | 8031 | 45666 | 654 |
852548 | 852548 | 2020-12-22 | Denver | Colorado | 8031 | 45365 | 648 |
849303 | 849303 | 2020-12-21 | Denver | Colorado | 8031 | 45104 | 647 |
846058 | 846058 | 2020-12-20 | Denver | Colorado | 8031 | 44854 | 650 |
842812 | 842812 | 2020-12-19 | Denver | Colorado | 8031 | 44645 | 649 |
839567 | 839567 | 2020-12-18 | Denver | Colorado | 8031 | 44353 | 642 |
836322 | 836322 | 2020-12-17 | Denver | Colorado | 8031 | 43979 | 642 |
833076 | 833076 | 2020-12-16 | Denver | Colorado | 8031 | 43591 | 635 |
829829 | 829829 | 2020-12-15 | Denver | Colorado | 8031 | 43335 | 626 |
826583 | 826583 | 2020-12-14 | Denver | Colorado | 8031 | 43057 | 623 |
823336 | 823336 | 2020-12-13 | Denver | Colorado | 8031 | 42590 | 612 |
820090 | 820090 | 2020-12-12 | Denver | Colorado | 8031 | 42590 | 612 |
816844 | 816844 | 2020-12-11 | Denver | Colorado | 8031 | 42228 | 593 |
813598 | 813598 | 2020-12-10 | Denver | Colorado | 8031 | 41624 | 592 |
810354 | 810354 | 2020-12-09 | Denver | Colorado | 8031 | 41053 | 582 |
807109 | 807109 | 2020-12-08 | Denver | Colorado | 8031 | 40714 | 582 |
803864 | 803864 | 2020-12-07 | Denver | Colorado | 8031 | 40429 | 571 |
800619 | 800619 | 2020-12-06 | Denver | Colorado | 8031 | 40078 | 567 |
797374 | 797374 | 2020-12-05 | Denver | Colorado | 8031 | 39582 | 566 |
794129 | 794129 | 2020-12-04 | Denver | Colorado | 8031 | 38825 | 552 |
790884 | 790884 | 2020-12-03 | Denver | Colorado | 8031 | 38756 | 547 |
787639 | 787639 | 2020-12-02 | Denver | Colorado | 8031 | 37938 | 547 |
784395 | 784395 | 2020-12-01 | Denver | Colorado | 8031 | 37421 | 539 |
781150 | 781150 | 2020-11-30 | Denver | Colorado | 8031 | 37033 | 531 |
777904 | 777904 | 2020-11-29 | Denver | Colorado | 8031 | 36618 | 527 |
774659 | 774659 | 2020-11-28 | Denver | Colorado | 8031 | 36232 | 526 |
771414 | 771414 | 2020-11-27 | Denver | Colorado | 8031 | 35787 | 523 |
768169 | 768169 | 2020-11-26 | Denver | Colorado | 8031 | 35075 | 521 |
764923 | 764923 | 2020-11-25 | Denver | Colorado | 8031 | 34816 | 515 |
761678 | 761678 | 2020-11-24 | Denver | Colorado | 8031 | 33971 | 510 |
758433 | 758433 | 2020-11-23 | Denver | Colorado | 8031 | 33404 | 507 |
755186 | 755186 | 2020-11-22 | Denver | Colorado | 8031 | 32836 | 506 |
751940 | 751940 | 2020-11-21 | Denver | Colorado | 8031 | 32087 | 502 |
748694 | 748694 | 2020-11-20 | Denver | Colorado | 8031 | 31540 | 494 |
745448 | 745448 | 2020-11-19 | Denver | Colorado | 8031 | 30631 | 493 |
742201 | 742201 | 2020-11-18 | Denver | Colorado | 8031 | 30082 | 492 |
738954 | 738954 | 2020-11-17 | Denver | Colorado | 8031 | 29229 | 491 |
735710 | 735710 | 2020-11-16 | Denver | Colorado | 8031 | 28654 | 491 |
732464 | 732464 | 2020-11-15 | Denver | Colorado | 8031 | 27986 | 482 |
729219 | 729219 | 2020-11-14 | Denver | Colorado | 8031 | 27316 | 482 |
725976 | 725976 | 2020-11-13 | Denver | Colorado | 8031 | 26751 | 482 |
722733 | 722733 | 2020-11-12 | Denver | Colorado | 8031 | 26097 | 482 |
719490 | 719490 | 2020-11-11 | Denver | Colorado | 8031 | 25275 | 482 |
716247 | 716247 | 2020-11-10 | Denver | Colorado | 8031 | 24541 | 481 |
713003 | 713003 | 2020-11-09 | Denver | Colorado | 8031 | 24041 | 473 |
709759 | 709759 | 2020-11-08 | Denver | Colorado | 8031 | 23569 | 468 |
706515 | 706515 | 2020-11-07 | Denver | Colorado | 8031 | 22908 | 468 |
703272 | 703272 | 2020-11-06 | Denver | Colorado | 8031 | 22225 | 468 |
700029 | 700029 | 2020-11-05 | Denver | Colorado | 8031 | 21885 | 468 |
696785 | 696785 | 2020-11-04 | Denver | Colorado | 8031 | 21194 | 468 |
693543 | 693543 | 2020-11-03 | Denver | Colorado | 8031 | 20742 | 462 |
690300 | 690300 | 2020-11-02 | Denver | Colorado | 8031 | 20375 | 462 |
687055 | 687055 | 2020-11-01 | Denver | Colorado | 8031 | 20128 | 459 |
683811 | 683811 | 2020-10-31 | Denver | Colorado | 8031 | 19538 | 459 |
680568 | 680568 | 2020-10-30 | Denver | Colorado | 8031 | 19197 | 459 |
677325 | 677325 | 2020-10-29 | Denver | Colorado | 8031 | 18745 | 459 |
674082 | 674082 | 2020-10-28 | Denver | Colorado | 8031 | 18400 | 459 |
670840 | 670840 | 2020-10-27 | Denver | Colorado | 8031 | 18140 | 459 |
667597 | 667597 | 2020-10-26 | Denver | Colorado | 8031 | 17882 | 459 |
664352 | 664352 | 2020-10-25 | Denver | Colorado | 8031 | 17652 | 450 |
661108 | 661108 | 2020-10-24 | Denver | Colorado | 8031 | 17271 | 450 |
657864 | 657864 | 2020-10-23 | Denver | Colorado | 8031 | 16896 | 450 |
654619 | 654619 | 2020-10-22 | Denver | Colorado | 8031 | 16666 | 450 |
651374 | 651374 | 2020-10-21 | Denver | Colorado | 8031 | 16455 | 450 |
648130 | 648130 | 2020-10-20 | Denver | Colorado | 8031 | 16252 | 450 |
644885 | 644885 | 2020-10-19 | Denver | Colorado | 8031 | 16117 | 450 |
641637 | 641637 | 2020-10-18 | Denver | Colorado | 8031 | 16005 | 449 |
638390 | 638390 | 2020-10-17 | Denver | Colorado | 8031 | 15821 | 449 |
635145 | 635145 | 2020-10-16 | Denver | Colorado | 8031 | 15645 | 449 |
631899 | 631899 | 2020-10-15 | Denver | Colorado | 8031 | 15466 | 449 |
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);