ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 8001 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
751924 | 751924 | 2020-11-21 | Adams | Colorado | 8001 | 25696 | 312 |
748678 | 748678 | 2020-11-20 | Adams | Colorado | 8001 | 25092 | 304 |
745432 | 745432 | 2020-11-19 | Adams | Colorado | 8001 | 24504 | 302 |
742185 | 742185 | 2020-11-18 | Adams | Colorado | 8001 | 23832 | 294 |
738938 | 738938 | 2020-11-17 | Adams | Colorado | 8001 | 23339 | 289 |
735694 | 735694 | 2020-11-16 | Adams | Colorado | 8001 | 22905 | 287 |
732448 | 732448 | 2020-11-15 | Adams | Colorado | 8001 | 22213 | 284 |
729203 | 729203 | 2020-11-14 | Adams | Colorado | 8001 | 21811 | 283 |
725960 | 725960 | 2020-11-13 | Adams | Colorado | 8001 | 21261 | 283 |
722717 | 722717 | 2020-11-12 | Adams | Colorado | 8001 | 20346 | 278 |
719474 | 719474 | 2020-11-11 | Adams | Colorado | 8001 | 19705 | 277 |
716231 | 716231 | 2020-11-10 | Adams | Colorado | 8001 | 19178 | 274 |
712987 | 712987 | 2020-11-09 | Adams | Colorado | 8001 | 18693 | 273 |
709743 | 709743 | 2020-11-08 | Adams | Colorado | 8001 | 18226 | 273 |
706499 | 706499 | 2020-11-07 | Adams | Colorado | 8001 | 17894 | 273 |
703256 | 703256 | 2020-11-06 | Adams | Colorado | 8001 | 17503 | 270 |
700013 | 700013 | 2020-11-05 | Adams | Colorado | 8001 | 17107 | 267 |
696769 | 696769 | 2020-11-04 | Adams | Colorado | 8001 | 16635 | 266 |
693527 | 693527 | 2020-11-03 | Adams | Colorado | 8001 | 16234 | 264 |
690284 | 690284 | 2020-11-02 | Adams | Colorado | 8001 | 15877 | 263 |
687039 | 687039 | 2020-11-01 | Adams | Colorado | 8001 | 15574 | 263 |
683795 | 683795 | 2020-10-31 | Adams | Colorado | 8001 | 15216 | 263 |
680552 | 680552 | 2020-10-30 | Adams | Colorado | 8001 | 14830 | 262 |
677309 | 677309 | 2020-10-29 | Adams | Colorado | 8001 | 14523 | 261 |
674066 | 674066 | 2020-10-28 | Adams | Colorado | 8001 | 14173 | 260 |
670824 | 670824 | 2020-10-27 | Adams | Colorado | 8001 | 13945 | 257 |
667581 | 667581 | 2020-10-26 | Adams | Colorado | 8001 | 13724 | 256 |
664336 | 664336 | 2020-10-25 | Adams | Colorado | 8001 | 13356 | 255 |
661092 | 661092 | 2020-10-24 | Adams | Colorado | 8001 | 13065 | 254 |
657848 | 657848 | 2020-10-23 | Adams | Colorado | 8001 | 12818 | 253 |
654603 | 654603 | 2020-10-22 | Adams | Colorado | 8001 | 12677 | 250 |
651358 | 651358 | 2020-10-21 | Adams | Colorado | 8001 | 12414 | 249 |
648114 | 648114 | 2020-10-20 | Adams | Colorado | 8001 | 12200 | 249 |
644869 | 644869 | 2020-10-19 | Adams | Colorado | 8001 | 12020 | 249 |
641621 | 641621 | 2020-10-18 | Adams | Colorado | 8001 | 11886 | 248 |
638374 | 638374 | 2020-10-17 | Adams | Colorado | 8001 | 11698 | 248 |
635129 | 635129 | 2020-10-16 | Adams | Colorado | 8001 | 11507 | 247 |
631883 | 631883 | 2020-10-15 | Adams | Colorado | 8001 | 11340 | 245 |
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);