ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 8093 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
953183 | 953183 | 2021-01-22 | Park | Colorado | 8093 | 466 | 5 |
949938 | 949938 | 2021-01-21 | Park | Colorado | 8093 | 461 | 5 |
946692 | 946692 | 2021-01-20 | Park | Colorado | 8093 | 461 | 5 |
943445 | 943445 | 2021-01-19 | Park | Colorado | 8093 | 460 | 5 |
940200 | 940200 | 2021-01-18 | Park | Colorado | 8093 | 459 | 5 |
936955 | 936955 | 2021-01-17 | Park | Colorado | 8093 | 456 | 5 |
933710 | 933710 | 2021-01-16 | Park | Colorado | 8093 | 455 | 5 |
930465 | 930465 | 2021-01-15 | Park | Colorado | 8093 | 453 | 5 |
927220 | 927220 | 2021-01-14 | Park | Colorado | 8093 | 445 | 5 |
923974 | 923974 | 2021-01-13 | Park | Colorado | 8093 | 442 | 5 |
920729 | 920729 | 2021-01-12 | Park | Colorado | 8093 | 440 | 5 |
917484 | 917484 | 2021-01-11 | Park | Colorado | 8093 | 439 | 5 |
914239 | 914239 | 2021-01-10 | Park | Colorado | 8093 | 435 | 5 |
910994 | 910994 | 2021-01-09 | Park | Colorado | 8093 | 428 | 5 |
907749 | 907749 | 2021-01-08 | Park | Colorado | 8093 | 422 | 5 |
904503 | 904503 | 2021-01-07 | Park | Colorado | 8093 | 414 | 5 |
901258 | 901258 | 2021-01-06 | Park | Colorado | 8093 | 399 | 5 |
898013 | 898013 | 2021-01-05 | Park | Colorado | 8093 | 399 | 5 |
894768 | 894768 | 2021-01-04 | Park | Colorado | 8093 | 398 | 5 |
891521 | 891521 | 2021-01-03 | Park | Colorado | 8093 | 395 | 5 |
888274 | 888274 | 2021-01-02 | Park | Colorado | 8093 | 390 | 5 |
885029 | 885029 | 2021-01-01 | Park | Colorado | 8093 | 384 | 5 |
881784 | 881784 | 2020-12-31 | Park | Colorado | 8093 | 385 | 5 |
878539 | 878539 | 2020-12-30 | Park | Colorado | 8093 | 382 | 4 |
875294 | 875294 | 2020-12-29 | Park | Colorado | 8093 | 379 | 4 |
872049 | 872049 | 2020-12-28 | Park | Colorado | 8093 | 376 | 4 |
868804 | 868804 | 2020-12-27 | Park | Colorado | 8093 | 373 | 4 |
865559 | 865559 | 2020-12-26 | Park | Colorado | 8093 | 369 | 4 |
862314 | 862314 | 2020-12-25 | Park | Colorado | 8093 | 368 | 4 |
859069 | 859069 | 2020-12-24 | Park | Colorado | 8093 | 363 | 4 |
855824 | 855824 | 2020-12-23 | Park | Colorado | 8093 | 350 | 4 |
852579 | 852579 | 2020-12-22 | Park | Colorado | 8093 | 351 | 4 |
849334 | 849334 | 2020-12-21 | Park | Colorado | 8093 | 350 | 4 |
846089 | 846089 | 2020-12-20 | Park | Colorado | 8093 | 348 | 4 |
842843 | 842843 | 2020-12-19 | Park | Colorado | 8093 | 341 | 4 |
839598 | 839598 | 2020-12-18 | Park | Colorado | 8093 | 339 | 4 |
836353 | 836353 | 2020-12-17 | Park | Colorado | 8093 | 335 | 4 |
833107 | 833107 | 2020-12-16 | Park | Colorado | 8093 | 320 | 4 |
829860 | 829860 | 2020-12-15 | Park | Colorado | 8093 | 316 | 4 |
826614 | 826614 | 2020-12-14 | Park | Colorado | 8093 | 314 | 4 |
823367 | 823367 | 2020-12-13 | Park | Colorado | 8093 | 314 | 4 |
820121 | 820121 | 2020-12-12 | Park | Colorado | 8093 | 306 | 4 |
816875 | 816875 | 2020-12-11 | Park | Colorado | 8093 | 301 | 4 |
813629 | 813629 | 2020-12-10 | Park | Colorado | 8093 | 290 | 4 |
810385 | 810385 | 2020-12-09 | Park | Colorado | 8093 | 286 | 4 |
807140 | 807140 | 2020-12-08 | Park | Colorado | 8093 | 281 | 4 |
803895 | 803895 | 2020-12-07 | Park | Colorado | 8093 | 279 | 4 |
800650 | 800650 | 2020-12-06 | Park | Colorado | 8093 | 277 | 4 |
797405 | 797405 | 2020-12-05 | Park | Colorado | 8093 | 273 | 4 |
794160 | 794160 | 2020-12-04 | Park | Colorado | 8093 | 266 | 4 |
790915 | 790915 | 2020-12-03 | Park | Colorado | 8093 | 258 | 4 |
787670 | 787670 | 2020-12-02 | Park | Colorado | 8093 | 240 | 4 |
784426 | 784426 | 2020-12-01 | Park | Colorado | 8093 | 238 | 4 |
781181 | 781181 | 2020-11-30 | Park | Colorado | 8093 | 238 | 4 |
777935 | 777935 | 2020-11-29 | Park | Colorado | 8093 | 234 | 4 |
774690 | 774690 | 2020-11-28 | Park | Colorado | 8093 | 229 | 4 |
771445 | 771445 | 2020-11-27 | Park | Colorado | 8093 | 228 | 4 |
768200 | 768200 | 2020-11-26 | Park | Colorado | 8093 | 214 | 4 |
764954 | 764954 | 2020-11-25 | Park | Colorado | 8093 | 208 | 4 |
761709 | 761709 | 2020-11-24 | Park | Colorado | 8093 | 205 | 4 |
758464 | 758464 | 2020-11-23 | Park | Colorado | 8093 | 202 | 3 |
755217 | 755217 | 2020-11-22 | Park | Colorado | 8093 | 202 | 3 |
751971 | 751971 | 2020-11-21 | Park | Colorado | 8093 | 199 | 3 |
748725 | 748725 | 2020-11-20 | Park | Colorado | 8093 | 192 | 3 |
745479 | 745479 | 2020-11-19 | Park | Colorado | 8093 | 186 | 3 |
742232 | 742232 | 2020-11-18 | Park | Colorado | 8093 | 181 | 3 |
738985 | 738985 | 2020-11-17 | Park | Colorado | 8093 | 175 | 3 |
735741 | 735741 | 2020-11-16 | Park | Colorado | 8093 | 169 | 3 |
732495 | 732495 | 2020-11-15 | Park | Colorado | 8093 | 164 | 3 |
729250 | 729250 | 2020-11-14 | Park | Colorado | 8093 | 160 | 2 |
726007 | 726007 | 2020-11-13 | Park | Colorado | 8093 | 154 | 1 |
722764 | 722764 | 2020-11-12 | Park | Colorado | 8093 | 144 | 1 |
719521 | 719521 | 2020-11-11 | Park | Colorado | 8093 | 135 | 1 |
716278 | 716278 | 2020-11-10 | Park | Colorado | 8093 | 134 | 1 |
713034 | 713034 | 2020-11-09 | Park | Colorado | 8093 | 132 | 1 |
709790 | 709790 | 2020-11-08 | Park | Colorado | 8093 | 125 | 1 |
706546 | 706546 | 2020-11-07 | Park | Colorado | 8093 | 122 | 1 |
703303 | 703303 | 2020-11-06 | Park | Colorado | 8093 | 118 | 1 |
700060 | 700060 | 2020-11-05 | Park | Colorado | 8093 | 114 | 1 |
696816 | 696816 | 2020-11-04 | Park | Colorado | 8093 | 114 | 1 |
693574 | 693574 | 2020-11-03 | Park | Colorado | 8093 | 113 | 1 |
690331 | 690331 | 2020-11-02 | Park | Colorado | 8093 | 107 | 1 |
687086 | 687086 | 2020-11-01 | Park | Colorado | 8093 | 109 | 1 |
683842 | 683842 | 2020-10-31 | Park | Colorado | 8093 | 108 | 1 |
680599 | 680599 | 2020-10-30 | Park | Colorado | 8093 | 106 | 1 |
677356 | 677356 | 2020-10-29 | Park | Colorado | 8093 | 101 | 1 |
674113 | 674113 | 2020-10-28 | Park | Colorado | 8093 | 96 | 1 |
670871 | 670871 | 2020-10-27 | Park | Colorado | 8093 | 95 | 1 |
667628 | 667628 | 2020-10-26 | Park | Colorado | 8093 | 92 | 1 |
664383 | 664383 | 2020-10-25 | Park | Colorado | 8093 | 92 | 1 |
661139 | 661139 | 2020-10-24 | Park | Colorado | 8093 | 93 | 1 |
657895 | 657895 | 2020-10-23 | Park | Colorado | 8093 | 91 | 1 |
654650 | 654650 | 2020-10-22 | Park | Colorado | 8093 | 88 | 1 |
651405 | 651405 | 2020-10-21 | Park | Colorado | 8093 | 85 | 1 |
648161 | 648161 | 2020-10-20 | Park | Colorado | 8093 | 82 | 1 |
644916 | 644916 | 2020-10-19 | Park | Colorado | 8093 | 81 | 1 |
641668 | 641668 | 2020-10-18 | Park | Colorado | 8093 | 80 | 1 |
638421 | 638421 | 2020-10-17 | Park | Colorado | 8093 | 79 | 1 |
635176 | 635176 | 2020-10-16 | Park | Colorado | 8093 | 69 | 1 |
631930 | 631930 | 2020-10-15 | Park | Colorado | 8093 | 65 | 1 |
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);