ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Park" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1053797 | 1053797 | 2021-02-22 | Park | Colorado | 8093 | 540 | 5 |
1050550 | 1050550 | 2021-02-21 | Park | Colorado | 8093 | 539 | 5 |
1047303 | 1047303 | 2021-02-20 | Park | Colorado | 8093 | 537 | 5 |
1044058 | 1044058 | 2021-02-19 | Park | Colorado | 8093 | 534 | 5 |
1040813 | 1040813 | 2021-02-18 | Park | Colorado | 8093 | 529 | 5 |
1037568 | 1037568 | 2021-02-17 | Park | Colorado | 8093 | 529 | 5 |
1034323 | 1034323 | 2021-02-16 | Park | Colorado | 8093 | 528 | 5 |
1031077 | 1031077 | 2021-02-15 | Park | Colorado | 8093 | 527 | 5 |
1027830 | 1027830 | 2021-02-14 | Park | Colorado | 8093 | 526 | 5 |
1024585 | 1024585 | 2021-02-13 | Park | Colorado | 8093 | 526 | 5 |
1021340 | 1021340 | 2021-02-12 | Park | Colorado | 8093 | 523 | 5 |
1018095 | 1018095 | 2021-02-11 | Park | Colorado | 8093 | 521 | 5 |
1014850 | 1014850 | 2021-02-10 | Park | Colorado | 8093 | 514 | 5 |
1011605 | 1011605 | 2021-02-09 | Park | Colorado | 8093 | 511 | 5 |
1008359 | 1008359 | 2021-02-08 | Park | Colorado | 8093 | 510 | 5 |
1005113 | 1005113 | 2021-02-07 | Park | Colorado | 8093 | 510 | 5 |
1001867 | 1001867 | 2021-02-06 | Park | Colorado | 8093 | 509 | 5 |
998621 | 998621 | 2021-02-05 | Park | Colorado | 8093 | 504 | 5 |
995375 | 995375 | 2021-02-04 | Park | Colorado | 8093 | 502 | 5 |
992129 | 992129 | 2021-02-03 | Park | Colorado | 8093 | 496 | 5 |
988883 | 988883 | 2021-02-02 | Park | Colorado | 8093 | 491 | 5 |
985636 | 985636 | 2021-02-01 | Park | Colorado | 8093 | 489 | 5 |
982389 | 982389 | 2021-01-31 | Park | Colorado | 8093 | 484 | 5 |
979143 | 979143 | 2021-01-30 | Park | Colorado | 8093 | 484 | 5 |
975898 | 975898 | 2021-01-29 | Park | Colorado | 8093 | 484 | 5 |
972653 | 972653 | 2021-01-28 | Park | Colorado | 8093 | 479 | 5 |
969408 | 969408 | 2021-01-27 | Park | Colorado | 8093 | 478 | 5 |
966164 | 966164 | 2021-01-26 | Park | Colorado | 8093 | 473 | 5 |
962919 | 962919 | 2021-01-25 | Park | Colorado | 8093 | 471 | 5 |
959674 | 959674 | 2021-01-24 | Park | Colorado | 8093 | 471 | 5 |
956428 | 956428 | 2021-01-23 | Park | Colorado | 8093 | 469 | 5 |
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 |
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);