ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Montrose" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
920725 | 920725 | 2021-01-12 | Montrose | Colorado | 8085 | 2482 | 38 |
917480 | 917480 | 2021-01-11 | Montrose | Colorado | 8085 | 2466 | 38 |
914235 | 914235 | 2021-01-10 | Montrose | Colorado | 8085 | 2418 | 38 |
910990 | 910990 | 2021-01-09 | Montrose | Colorado | 8085 | 2383 | 36 |
907745 | 907745 | 2021-01-08 | Montrose | Colorado | 8085 | 2348 | 35 |
904499 | 904499 | 2021-01-07 | Montrose | Colorado | 8085 | 2310 | 35 |
901254 | 901254 | 2021-01-06 | Montrose | Colorado | 8085 | 2287 | 34 |
898009 | 898009 | 2021-01-05 | Montrose | Colorado | 8085 | 2287 | 34 |
894764 | 894764 | 2021-01-04 | Montrose | Colorado | 8085 | 2268 | 33 |
891517 | 891517 | 2021-01-03 | Montrose | Colorado | 8085 | 2243 | 33 |
888270 | 888270 | 2021-01-02 | Montrose | Colorado | 8085 | 2199 | 33 |
885025 | 885025 | 2021-01-01 | Montrose | Colorado | 8085 | 2134 | 31 |
881780 | 881780 | 2020-12-31 | Montrose | Colorado | 8085 | 2114 | 31 |
878535 | 878535 | 2020-12-30 | Montrose | Colorado | 8085 | 2092 | 30 |
875290 | 875290 | 2020-12-29 | Montrose | Colorado | 8085 | 2072 | 30 |
872045 | 872045 | 2020-12-28 | Montrose | Colorado | 8085 | 2055 | 29 |
868800 | 868800 | 2020-12-27 | Montrose | Colorado | 8085 | 2034 | 29 |
865555 | 865555 | 2020-12-26 | Montrose | Colorado | 8085 | 1961 | 29 |
862310 | 862310 | 2020-12-25 | Montrose | Colorado | 8085 | 1944 | 29 |
859065 | 859065 | 2020-12-24 | Montrose | Colorado | 8085 | 1932 | 29 |
855820 | 855820 | 2020-12-23 | Montrose | Colorado | 8085 | 1910 | 29 |
852575 | 852575 | 2020-12-22 | Montrose | Colorado | 8085 | 1895 | 29 |
849330 | 849330 | 2020-12-21 | Montrose | Colorado | 8085 | 1862 | 28 |
846085 | 846085 | 2020-12-20 | Montrose | Colorado | 8085 | 1836 | 28 |
842839 | 842839 | 2020-12-19 | Montrose | Colorado | 8085 | 1806 | 27 |
839594 | 839594 | 2020-12-18 | Montrose | Colorado | 8085 | 1773 | 27 |
836349 | 836349 | 2020-12-17 | Montrose | Colorado | 8085 | 1746 | 26 |
833103 | 833103 | 2020-12-16 | Montrose | Colorado | 8085 | 1712 | 25 |
829856 | 829856 | 2020-12-15 | Montrose | Colorado | 8085 | 1700 | 23 |
826610 | 826610 | 2020-12-14 | Montrose | Colorado | 8085 | 1632 | 22 |
823363 | 823363 | 2020-12-13 | Montrose | Colorado | 8085 | 1632 | 22 |
820117 | 820117 | 2020-12-12 | Montrose | Colorado | 8085 | 1586 | 22 |
816871 | 816871 | 2020-12-11 | Montrose | Colorado | 8085 | 1532 | 22 |
813625 | 813625 | 2020-12-10 | Montrose | Colorado | 8085 | 1470 | 21 |
810381 | 810381 | 2020-12-09 | Montrose | Colorado | 8085 | 1436 | 19 |
807136 | 807136 | 2020-12-08 | Montrose | Colorado | 8085 | 1401 | 16 |
803891 | 803891 | 2020-12-07 | Montrose | Colorado | 8085 | 1367 | 16 |
800646 | 800646 | 2020-12-06 | Montrose | Colorado | 8085 | 1345 | 16 |
797401 | 797401 | 2020-12-05 | Montrose | Colorado | 8085 | 1319 | 16 |
794156 | 794156 | 2020-12-04 | Montrose | Colorado | 8085 | 1285 | 15 |
790911 | 790911 | 2020-12-03 | Montrose | Colorado | 8085 | 1225 | 15 |
787666 | 787666 | 2020-12-02 | Montrose | Colorado | 8085 | 1159 | 15 |
784422 | 784422 | 2020-12-01 | Montrose | Colorado | 8085 | 1146 | 15 |
781177 | 781177 | 2020-11-30 | Montrose | Colorado | 8085 | 1115 | 15 |
777931 | 777931 | 2020-11-29 | Montrose | Colorado | 8085 | 1094 | 15 |
774686 | 774686 | 2020-11-28 | Montrose | Colorado | 8085 | 1029 | 15 |
771441 | 771441 | 2020-11-27 | Montrose | Colorado | 8085 | 999 | 15 |
768196 | 768196 | 2020-11-26 | Montrose | Colorado | 8085 | 977 | 15 |
764950 | 764950 | 2020-11-25 | Montrose | Colorado | 8085 | 895 | 15 |
761705 | 761705 | 2020-11-24 | Montrose | Colorado | 8085 | 868 | 15 |
758460 | 758460 | 2020-11-23 | Montrose | Colorado | 8085 | 848 | 15 |
755213 | 755213 | 2020-11-22 | Montrose | Colorado | 8085 | 806 | 15 |
751967 | 751967 | 2020-11-21 | Montrose | Colorado | 8085 | 770 | 15 |
748721 | 748721 | 2020-11-20 | Montrose | Colorado | 8085 | 734 | 15 |
745475 | 745475 | 2020-11-19 | Montrose | Colorado | 8085 | 714 | 15 |
742228 | 742228 | 2020-11-18 | Montrose | Colorado | 8085 | 682 | 15 |
738981 | 738981 | 2020-11-17 | Montrose | Colorado | 8085 | 670 | 14 |
735737 | 735737 | 2020-11-16 | Montrose | Colorado | 8085 | 647 | 14 |
732491 | 732491 | 2020-11-15 | Montrose | Colorado | 8085 | 630 | 14 |
729246 | 729246 | 2020-11-14 | Montrose | Colorado | 8085 | 616 | 14 |
726003 | 726003 | 2020-11-13 | Montrose | Colorado | 8085 | 604 | 14 |
722760 | 722760 | 2020-11-12 | Montrose | Colorado | 8085 | 589 | 14 |
719517 | 719517 | 2020-11-11 | Montrose | Colorado | 8085 | 578 | 14 |
716274 | 716274 | 2020-11-10 | Montrose | Colorado | 8085 | 567 | 14 |
713030 | 713030 | 2020-11-09 | Montrose | Colorado | 8085 | 558 | 14 |
709786 | 709786 | 2020-11-08 | Montrose | Colorado | 8085 | 541 | 14 |
706542 | 706542 | 2020-11-07 | Montrose | Colorado | 8085 | 533 | 14 |
703299 | 703299 | 2020-11-06 | Montrose | Colorado | 8085 | 524 | 14 |
700056 | 700056 | 2020-11-05 | Montrose | Colorado | 8085 | 510 | 14 |
696812 | 696812 | 2020-11-04 | Montrose | Colorado | 8085 | 502 | 14 |
693570 | 693570 | 2020-11-03 | Montrose | Colorado | 8085 | 497 | 13 |
690327 | 690327 | 2020-11-02 | Montrose | Colorado | 8085 | 496 | 13 |
687082 | 687082 | 2020-11-01 | Montrose | Colorado | 8085 | 493 | 13 |
683838 | 683838 | 2020-10-31 | Montrose | Colorado | 8085 | 492 | 13 |
680595 | 680595 | 2020-10-30 | Montrose | Colorado | 8085 | 484 | 13 |
677352 | 677352 | 2020-10-29 | Montrose | Colorado | 8085 | 477 | 13 |
674109 | 674109 | 2020-10-28 | Montrose | Colorado | 8085 | 470 | 13 |
670867 | 670867 | 2020-10-27 | Montrose | Colorado | 8085 | 470 | 13 |
667624 | 667624 | 2020-10-26 | Montrose | Colorado | 8085 | 463 | 13 |
664379 | 664379 | 2020-10-25 | Montrose | Colorado | 8085 | 459 | 13 |
661135 | 661135 | 2020-10-24 | Montrose | Colorado | 8085 | 455 | 13 |
657891 | 657891 | 2020-10-23 | Montrose | Colorado | 8085 | 441 | 13 |
654646 | 654646 | 2020-10-22 | Montrose | Colorado | 8085 | 431 | 13 |
651401 | 651401 | 2020-10-21 | Montrose | Colorado | 8085 | 428 | 13 |
648157 | 648157 | 2020-10-20 | Montrose | Colorado | 8085 | 422 | 13 |
644912 | 644912 | 2020-10-19 | Montrose | Colorado | 8085 | 422 | 13 |
641664 | 641664 | 2020-10-18 | Montrose | Colorado | 8085 | 420 | 13 |
638417 | 638417 | 2020-10-17 | Montrose | Colorado | 8085 | 417 | 13 |
635172 | 635172 | 2020-10-16 | Montrose | Colorado | 8085 | 412 | 13 |
631926 | 631926 | 2020-10-15 | Montrose | Colorado | 8085 | 412 | 13 |
628682 | 628682 | 2020-10-14 | Montrose | Colorado | 8085 | 405 | 13 |
625439 | 625439 | 2020-10-13 | Montrose | Colorado | 8085 | 404 | 13 |
622196 | 622196 | 2020-10-12 | Montrose | Colorado | 8085 | 400 | 13 |
618953 | 618953 | 2020-10-11 | Montrose | Colorado | 8085 | 400 | 13 |
615711 | 615711 | 2020-10-10 | Montrose | Colorado | 8085 | 397 | 13 |
612470 | 612470 | 2020-10-09 | Montrose | Colorado | 8085 | 393 | 13 |
609228 | 609228 | 2020-10-08 | Montrose | Colorado | 8085 | 391 | 13 |
605985 | 605985 | 2020-10-07 | Montrose | Colorado | 8085 | 390 | 13 |
602743 | 602743 | 2020-10-06 | Montrose | Colorado | 8085 | 388 | 13 |
599500 | 599500 | 2020-10-05 | Montrose | Colorado | 8085 | 388 | 13 |
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);