ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 8125 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1053813 | 1053813 | 2021-02-22 | Yuma | Colorado | 8125 | 700 | 17 |
1050566 | 1050566 | 2021-02-21 | Yuma | Colorado | 8125 | 697 | 17 |
1047319 | 1047319 | 2021-02-20 | Yuma | Colorado | 8125 | 698 | 17 |
1044074 | 1044074 | 2021-02-19 | Yuma | Colorado | 8125 | 697 | 17 |
1040829 | 1040829 | 2021-02-18 | Yuma | Colorado | 8125 | 697 | 17 |
1037584 | 1037584 | 2021-02-17 | Yuma | Colorado | 8125 | 694 | 17 |
1034339 | 1034339 | 2021-02-16 | Yuma | Colorado | 8125 | 693 | 17 |
1031093 | 1031093 | 2021-02-15 | Yuma | Colorado | 8125 | 693 | 17 |
1027846 | 1027846 | 2021-02-14 | Yuma | Colorado | 8125 | 693 | 17 |
1024601 | 1024601 | 2021-02-13 | Yuma | Colorado | 8125 | 692 | 17 |
1021356 | 1021356 | 2021-02-12 | Yuma | Colorado | 8125 | 688 | 16 |
1018111 | 1018111 | 2021-02-11 | Yuma | Colorado | 8125 | 688 | 16 |
1014866 | 1014866 | 2021-02-10 | Yuma | Colorado | 8125 | 682 | 16 |
1011621 | 1011621 | 2021-02-09 | Yuma | Colorado | 8125 | 681 | 16 |
1008375 | 1008375 | 2021-02-08 | Yuma | Colorado | 8125 | 679 | 16 |
1005129 | 1005129 | 2021-02-07 | Yuma | Colorado | 8125 | 677 | 16 |
1001883 | 1001883 | 2021-02-06 | Yuma | Colorado | 8125 | 676 | 16 |
998637 | 998637 | 2021-02-05 | Yuma | Colorado | 8125 | 674 | 16 |
995391 | 995391 | 2021-02-04 | Yuma | Colorado | 8125 | 672 | 16 |
992145 | 992145 | 2021-02-03 | Yuma | Colorado | 8125 | 670 | 16 |
988899 | 988899 | 2021-02-02 | Yuma | Colorado | 8125 | 663 | 16 |
985652 | 985652 | 2021-02-01 | Yuma | Colorado | 8125 | 663 | 16 |
982405 | 982405 | 2021-01-31 | Yuma | Colorado | 8125 | 658 | 16 |
979159 | 979159 | 2021-01-30 | Yuma | Colorado | 8125 | 658 | 16 |
975914 | 975914 | 2021-01-29 | Yuma | Colorado | 8125 | 658 | 16 |
972669 | 972669 | 2021-01-28 | Yuma | Colorado | 8125 | 655 | 15 |
969424 | 969424 | 2021-01-27 | Yuma | Colorado | 8125 | 654 | 15 |
966180 | 966180 | 2021-01-26 | Yuma | Colorado | 8125 | 652 | 15 |
962935 | 962935 | 2021-01-25 | Yuma | Colorado | 8125 | 644 | 15 |
959690 | 959690 | 2021-01-24 | Yuma | Colorado | 8125 | 644 | 15 |
956444 | 956444 | 2021-01-23 | Yuma | Colorado | 8125 | 641 | 15 |
953199 | 953199 | 2021-01-22 | Yuma | Colorado | 8125 | 632 | 14 |
949954 | 949954 | 2021-01-21 | Yuma | Colorado | 8125 | 632 | 14 |
946708 | 946708 | 2021-01-20 | Yuma | Colorado | 8125 | 623 | 14 |
943461 | 943461 | 2021-01-19 | Yuma | Colorado | 8125 | 620 | 14 |
940216 | 940216 | 2021-01-18 | Yuma | Colorado | 8125 | 619 | 14 |
936971 | 936971 | 2021-01-17 | Yuma | Colorado | 8125 | 619 | 14 |
933726 | 933726 | 2021-01-16 | Yuma | Colorado | 8125 | 614 | 14 |
930481 | 930481 | 2021-01-15 | Yuma | Colorado | 8125 | 610 | 14 |
927236 | 927236 | 2021-01-14 | Yuma | Colorado | 8125 | 604 | 14 |
923990 | 923990 | 2021-01-13 | Yuma | Colorado | 8125 | 601 | 14 |
920745 | 920745 | 2021-01-12 | Yuma | Colorado | 8125 | 597 | 14 |
917500 | 917500 | 2021-01-11 | Yuma | Colorado | 8125 | 594 | 14 |
914255 | 914255 | 2021-01-10 | Yuma | Colorado | 8125 | 593 | 14 |
911010 | 911010 | 2021-01-09 | Yuma | Colorado | 8125 | 589 | 14 |
907765 | 907765 | 2021-01-08 | Yuma | Colorado | 8125 | 583 | 14 |
904519 | 904519 | 2021-01-07 | Yuma | Colorado | 8125 | 571 | 14 |
901274 | 901274 | 2021-01-06 | Yuma | Colorado | 8125 | 563 | 13 |
898029 | 898029 | 2021-01-05 | Yuma | Colorado | 8125 | 563 | 13 |
894784 | 894784 | 2021-01-04 | Yuma | Colorado | 8125 | 559 | 13 |
891537 | 891537 | 2021-01-03 | Yuma | Colorado | 8125 | 559 | 13 |
888290 | 888290 | 2021-01-02 | Yuma | Colorado | 8125 | 556 | 13 |
885045 | 885045 | 2021-01-01 | Yuma | Colorado | 8125 | 552 | 13 |
881800 | 881800 | 2020-12-31 | Yuma | Colorado | 8125 | 549 | 13 |
878555 | 878555 | 2020-12-30 | Yuma | Colorado | 8125 | 542 | 11 |
875310 | 875310 | 2020-12-29 | Yuma | Colorado | 8125 | 542 | 10 |
872065 | 872065 | 2020-12-28 | Yuma | Colorado | 8125 | 536 | 10 |
868820 | 868820 | 2020-12-27 | Yuma | Colorado | 8125 | 527 | 10 |
865575 | 865575 | 2020-12-26 | Yuma | Colorado | 8125 | 524 | 10 |
862330 | 862330 | 2020-12-25 | Yuma | Colorado | 8125 | 518 | 10 |
859085 | 859085 | 2020-12-24 | Yuma | Colorado | 8125 | 511 | 8 |
855840 | 855840 | 2020-12-23 | Yuma | Colorado | 8125 | 509 | 6 |
852595 | 852595 | 2020-12-22 | Yuma | Colorado | 8125 | 505 | 6 |
849350 | 849350 | 2020-12-21 | Yuma | Colorado | 8125 | 501 | 6 |
846105 | 846105 | 2020-12-20 | Yuma | Colorado | 8125 | 496 | 6 |
842859 | 842859 | 2020-12-19 | Yuma | Colorado | 8125 | 492 | 6 |
839614 | 839614 | 2020-12-18 | Yuma | Colorado | 8125 | 488 | 6 |
836369 | 836369 | 2020-12-17 | Yuma | Colorado | 8125 | 484 | 5 |
833123 | 833123 | 2020-12-16 | Yuma | Colorado | 8125 | 464 | 4 |
829876 | 829876 | 2020-12-15 | Yuma | Colorado | 8125 | 452 | 4 |
826630 | 826630 | 2020-12-14 | Yuma | Colorado | 8125 | 442 | 4 |
823383 | 823383 | 2020-12-13 | Yuma | Colorado | 8125 | 442 | 4 |
820137 | 820137 | 2020-12-12 | Yuma | Colorado | 8125 | 433 | 3 |
816891 | 816891 | 2020-12-11 | Yuma | Colorado | 8125 | 427 | 3 |
813645 | 813645 | 2020-12-10 | Yuma | Colorado | 8125 | 406 | 3 |
810401 | 810401 | 2020-12-09 | Yuma | Colorado | 8125 | 394 | 3 |
807156 | 807156 | 2020-12-08 | Yuma | Colorado | 8125 | 385 | 3 |
803911 | 803911 | 2020-12-07 | Yuma | Colorado | 8125 | 379 | 3 |
800666 | 800666 | 2020-12-06 | Yuma | Colorado | 8125 | 368 | 3 |
797421 | 797421 | 2020-12-05 | Yuma | Colorado | 8125 | 367 | 3 |
794176 | 794176 | 2020-12-04 | Yuma | Colorado | 8125 | 359 | 3 |
790931 | 790931 | 2020-12-03 | Yuma | Colorado | 8125 | 350 | 3 |
787686 | 787686 | 2020-12-02 | Yuma | Colorado | 8125 | 345 | 2 |
784442 | 784442 | 2020-12-01 | Yuma | Colorado | 8125 | 338 | 2 |
781197 | 781197 | 2020-11-30 | Yuma | Colorado | 8125 | 332 | 2 |
777951 | 777951 | 2020-11-29 | Yuma | Colorado | 8125 | 325 | 2 |
774706 | 774706 | 2020-11-28 | Yuma | Colorado | 8125 | 323 | 2 |
771461 | 771461 | 2020-11-27 | Yuma | Colorado | 8125 | 316 | 2 |
768216 | 768216 | 2020-11-26 | Yuma | Colorado | 8125 | 314 | 2 |
764970 | 764970 | 2020-11-25 | Yuma | Colorado | 8125 | 305 | 2 |
761725 | 761725 | 2020-11-24 | Yuma | Colorado | 8125 | 305 | 1 |
758480 | 758480 | 2020-11-23 | Yuma | Colorado | 8125 | 298 | 1 |
755233 | 755233 | 2020-11-22 | Yuma | Colorado | 8125 | 296 | 1 |
751987 | 751987 | 2020-11-21 | Yuma | Colorado | 8125 | 290 | 1 |
748741 | 748741 | 2020-11-20 | Yuma | Colorado | 8125 | 284 | 1 |
745495 | 745495 | 2020-11-19 | Yuma | Colorado | 8125 | 283 | 1 |
742248 | 742248 | 2020-11-18 | Yuma | Colorado | 8125 | 274 | 1 |
739001 | 739001 | 2020-11-17 | Yuma | Colorado | 8125 | 267 | 1 |
735757 | 735757 | 2020-11-16 | Yuma | Colorado | 8125 | 264 | 1 |
732511 | 732511 | 2020-11-15 | Yuma | Colorado | 8125 | 263 | 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);