ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 8015 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
920690 | 920690 | 2021-01-12 | Chaffee | Colorado | 8015 | 1186 | 21 |
917445 | 917445 | 2021-01-11 | Chaffee | Colorado | 8015 | 1173 | 21 |
914200 | 914200 | 2021-01-10 | Chaffee | Colorado | 8015 | 1170 | 21 |
910955 | 910955 | 2021-01-09 | Chaffee | Colorado | 8015 | 1165 | 21 |
907710 | 907710 | 2021-01-08 | Chaffee | Colorado | 8015 | 1155 | 21 |
904464 | 904464 | 2021-01-07 | Chaffee | Colorado | 8015 | 1125 | 21 |
901219 | 901219 | 2021-01-06 | Chaffee | Colorado | 8015 | 1114 | 21 |
897974 | 897974 | 2021-01-05 | Chaffee | Colorado | 8015 | 1114 | 21 |
894729 | 894729 | 2021-01-04 | Chaffee | Colorado | 8015 | 1111 | 21 |
891482 | 891482 | 2021-01-03 | Chaffee | Colorado | 8015 | 1105 | 21 |
888235 | 888235 | 2021-01-02 | Chaffee | Colorado | 8015 | 1081 | 21 |
884990 | 884990 | 2021-01-01 | Chaffee | Colorado | 8015 | 1072 | 21 |
881745 | 881745 | 2020-12-31 | Chaffee | Colorado | 8015 | 1020 | 21 |
878500 | 878500 | 2020-12-30 | Chaffee | Colorado | 8015 | 1016 | 21 |
875255 | 875255 | 2020-12-29 | Chaffee | Colorado | 8015 | 1014 | 20 |
872010 | 872010 | 2020-12-28 | Chaffee | Colorado | 8015 | 1002 | 20 |
868765 | 868765 | 2020-12-27 | Chaffee | Colorado | 8015 | 1002 | 20 |
865520 | 865520 | 2020-12-26 | Chaffee | Colorado | 8015 | 998 | 20 |
862275 | 862275 | 2020-12-25 | Chaffee | Colorado | 8015 | 995 | 20 |
859030 | 859030 | 2020-12-24 | Chaffee | Colorado | 8015 | 976 | 20 |
855785 | 855785 | 2020-12-23 | Chaffee | Colorado | 8015 | 935 | 20 |
852540 | 852540 | 2020-12-22 | Chaffee | Colorado | 8015 | 927 | 20 |
849295 | 849295 | 2020-12-21 | Chaffee | Colorado | 8015 | 918 | 21 |
846050 | 846050 | 2020-12-20 | Chaffee | Colorado | 8015 | 917 | 21 |
842804 | 842804 | 2020-12-19 | Chaffee | Colorado | 8015 | 904 | 21 |
839559 | 839559 | 2020-12-18 | Chaffee | Colorado | 8015 | 898 | 21 |
836314 | 836314 | 2020-12-17 | Chaffee | Colorado | 8015 | 881 | 20 |
833068 | 833068 | 2020-12-16 | Chaffee | Colorado | 8015 | 852 | 22 |
829821 | 829821 | 2020-12-15 | Chaffee | Colorado | 8015 | 848 | 22 |
826575 | 826575 | 2020-12-14 | Chaffee | Colorado | 8015 | 821 | 22 |
823328 | 823328 | 2020-12-13 | Chaffee | Colorado | 8015 | 821 | 22 |
820082 | 820082 | 2020-12-12 | Chaffee | Colorado | 8015 | 809 | 22 |
816836 | 816836 | 2020-12-11 | Chaffee | Colorado | 8015 | 800 | 22 |
813590 | 813590 | 2020-12-10 | Chaffee | Colorado | 8015 | 788 | 22 |
810346 | 810346 | 2020-12-09 | Chaffee | Colorado | 8015 | 757 | 22 |
807101 | 807101 | 2020-12-08 | Chaffee | Colorado | 8015 | 753 | 21 |
803856 | 803856 | 2020-12-07 | Chaffee | Colorado | 8015 | 747 | 21 |
800611 | 800611 | 2020-12-06 | Chaffee | Colorado | 8015 | 734 | 21 |
797366 | 797366 | 2020-12-05 | Chaffee | Colorado | 8015 | 730 | 21 |
794121 | 794121 | 2020-12-04 | Chaffee | Colorado | 8015 | 713 | 21 |
790876 | 790876 | 2020-12-03 | Chaffee | Colorado | 8015 | 700 | 21 |
787631 | 787631 | 2020-12-02 | Chaffee | Colorado | 8015 | 668 | 21 |
784387 | 784387 | 2020-12-01 | Chaffee | Colorado | 8015 | 663 | 21 |
781142 | 781142 | 2020-11-30 | Chaffee | Colorado | 8015 | 658 | 21 |
777896 | 777896 | 2020-11-29 | Chaffee | Colorado | 8015 | 656 | 21 |
774651 | 774651 | 2020-11-28 | Chaffee | Colorado | 8015 | 627 | 21 |
771406 | 771406 | 2020-11-27 | Chaffee | Colorado | 8015 | 611 | 21 |
768161 | 768161 | 2020-11-26 | Chaffee | Colorado | 8015 | 604 | 21 |
764915 | 764915 | 2020-11-25 | Chaffee | Colorado | 8015 | 595 | 21 |
761670 | 761670 | 2020-11-24 | Chaffee | Colorado | 8015 | 590 | 21 |
758425 | 758425 | 2020-11-23 | Chaffee | Colorado | 8015 | 587 | 21 |
755178 | 755178 | 2020-11-22 | Chaffee | Colorado | 8015 | 576 | 21 |
751932 | 751932 | 2020-11-21 | Chaffee | Colorado | 8015 | 566 | 21 |
748686 | 748686 | 2020-11-20 | Chaffee | Colorado | 8015 | 539 | 21 |
745440 | 745440 | 2020-11-19 | Chaffee | Colorado | 8015 | 518 | 21 |
742193 | 742193 | 2020-11-18 | Chaffee | Colorado | 8015 | 510 | 21 |
738946 | 738946 | 2020-11-17 | Chaffee | Colorado | 8015 | 508 | 20 |
735702 | 735702 | 2020-11-16 | Chaffee | Colorado | 8015 | 506 | 20 |
732456 | 732456 | 2020-11-15 | Chaffee | Colorado | 8015 | 501 | 20 |
729211 | 729211 | 2020-11-14 | Chaffee | Colorado | 8015 | 487 | 20 |
725968 | 725968 | 2020-11-13 | Chaffee | Colorado | 8015 | 484 | 20 |
722725 | 722725 | 2020-11-12 | Chaffee | Colorado | 8015 | 475 | 20 |
719482 | 719482 | 2020-11-11 | Chaffee | Colorado | 8015 | 473 | 20 |
716239 | 716239 | 2020-11-10 | Chaffee | Colorado | 8015 | 472 | 20 |
712995 | 712995 | 2020-11-09 | Chaffee | Colorado | 8015 | 469 | 20 |
709751 | 709751 | 2020-11-08 | Chaffee | Colorado | 8015 | 466 | 20 |
706507 | 706507 | 2020-11-07 | Chaffee | Colorado | 8015 | 461 | 20 |
703264 | 703264 | 2020-11-06 | Chaffee | Colorado | 8015 | 454 | 20 |
700021 | 700021 | 2020-11-05 | Chaffee | Colorado | 8015 | 445 | 20 |
696777 | 696777 | 2020-11-04 | Chaffee | Colorado | 8015 | 439 | 20 |
693535 | 693535 | 2020-11-03 | Chaffee | Colorado | 8015 | 435 | 20 |
690292 | 690292 | 2020-11-02 | Chaffee | Colorado | 8015 | 435 | 20 |
687047 | 687047 | 2020-11-01 | Chaffee | Colorado | 8015 | 433 | 20 |
683803 | 683803 | 2020-10-31 | Chaffee | Colorado | 8015 | 431 | 20 |
680560 | 680560 | 2020-10-30 | Chaffee | Colorado | 8015 | 422 | 20 |
677317 | 677317 | 2020-10-29 | Chaffee | Colorado | 8015 | 417 | 20 |
674074 | 674074 | 2020-10-28 | Chaffee | Colorado | 8015 | 402 | 20 |
670832 | 670832 | 2020-10-27 | Chaffee | Colorado | 8015 | 394 | 20 |
667589 | 667589 | 2020-10-26 | Chaffee | Colorado | 8015 | 393 | 20 |
664344 | 664344 | 2020-10-25 | Chaffee | Colorado | 8015 | 391 | 20 |
661100 | 661100 | 2020-10-24 | Chaffee | Colorado | 8015 | 386 | 20 |
657856 | 657856 | 2020-10-23 | Chaffee | Colorado | 8015 | 381 | 20 |
654611 | 654611 | 2020-10-22 | Chaffee | Colorado | 8015 | 375 | 20 |
651366 | 651366 | 2020-10-21 | Chaffee | Colorado | 8015 | 374 | 20 |
648122 | 648122 | 2020-10-20 | Chaffee | Colorado | 8015 | 373 | 20 |
644877 | 644877 | 2020-10-19 | Chaffee | Colorado | 8015 | 372 | 20 |
641629 | 641629 | 2020-10-18 | Chaffee | Colorado | 8015 | 370 | 20 |
638382 | 638382 | 2020-10-17 | Chaffee | Colorado | 8015 | 369 | 20 |
635137 | 635137 | 2020-10-16 | Chaffee | Colorado | 8015 | 359 | 20 |
631891 | 631891 | 2020-10-15 | Chaffee | Colorado | 8015 | 358 | 20 |
628647 | 628647 | 2020-10-14 | Chaffee | Colorado | 8015 | 358 | 20 |
625404 | 625404 | 2020-10-13 | Chaffee | Colorado | 8015 | 358 | 20 |
622161 | 622161 | 2020-10-12 | Chaffee | Colorado | 8015 | 357 | 20 |
618918 | 618918 | 2020-10-11 | Chaffee | Colorado | 8015 | 356 | 20 |
615676 | 615676 | 2020-10-10 | Chaffee | Colorado | 8015 | 356 | 20 |
612435 | 612435 | 2020-10-09 | Chaffee | Colorado | 8015 | 350 | 20 |
609193 | 609193 | 2020-10-08 | Chaffee | Colorado | 8015 | 350 | 20 |
605950 | 605950 | 2020-10-07 | Chaffee | Colorado | 8015 | 344 | 20 |
602708 | 602708 | 2020-10-06 | Chaffee | Colorado | 8015 | 340 | 20 |
599465 | 599465 | 2020-10-05 | Chaffee | Colorado | 8015 | 337 | 20 |
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);