ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,572 rows where county = "Yuma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
953001 | 953001 | 2021-01-22 | Yuma | Arizona | 4027 | 33872 | 665 |
953199 | 953199 | 2021-01-22 | Yuma | Colorado | 8125 | 632 | 14 |
949756 | 949756 | 2021-01-21 | Yuma | Arizona | 4027 | 33707 | 656 |
949954 | 949954 | 2021-01-21 | Yuma | Colorado | 8125 | 632 | 14 |
946510 | 946510 | 2021-01-20 | Yuma | Arizona | 4027 | 33567 | 648 |
946708 | 946708 | 2021-01-20 | Yuma | Colorado | 8125 | 623 | 14 |
943263 | 943263 | 2021-01-19 | Yuma | Arizona | 4027 | 33447 | 633 |
943461 | 943461 | 2021-01-19 | Yuma | Colorado | 8125 | 620 | 14 |
940018 | 940018 | 2021-01-18 | Yuma | Arizona | 4027 | 33163 | 633 |
940216 | 940216 | 2021-01-18 | Yuma | Colorado | 8125 | 619 | 14 |
936773 | 936773 | 2021-01-17 | Yuma | Arizona | 4027 | 32932 | 633 |
936971 | 936971 | 2021-01-17 | Yuma | Colorado | 8125 | 619 | 14 |
933528 | 933528 | 2021-01-16 | Yuma | Arizona | 4027 | 32736 | 632 |
933726 | 933726 | 2021-01-16 | Yuma | Colorado | 8125 | 614 | 14 |
930283 | 930283 | 2021-01-15 | Yuma | Arizona | 4027 | 32349 | 614 |
930481 | 930481 | 2021-01-15 | Yuma | Colorado | 8125 | 610 | 14 |
927038 | 927038 | 2021-01-14 | Yuma | Arizona | 4027 | 31958 | 610 |
927236 | 927236 | 2021-01-14 | Yuma | Colorado | 8125 | 604 | 14 |
923792 | 923792 | 2021-01-13 | Yuma | Arizona | 4027 | 31789 | 601 |
923990 | 923990 | 2021-01-13 | Yuma | Colorado | 8125 | 601 | 14 |
920547 | 920547 | 2021-01-12 | Yuma | Arizona | 4027 | 31658 | 591 |
920745 | 920745 | 2021-01-12 | Yuma | Colorado | 8125 | 597 | 14 |
917302 | 917302 | 2021-01-11 | Yuma | Arizona | 4027 | 31501 | 578 |
917500 | 917500 | 2021-01-11 | Yuma | Colorado | 8125 | 594 | 14 |
914057 | 914057 | 2021-01-10 | Yuma | Arizona | 4027 | 31268 | 578 |
914255 | 914255 | 2021-01-10 | Yuma | Colorado | 8125 | 593 | 14 |
910812 | 910812 | 2021-01-09 | Yuma | Arizona | 4027 | 30847 | 573 |
911010 | 911010 | 2021-01-09 | Yuma | Colorado | 8125 | 589 | 14 |
907567 | 907567 | 2021-01-08 | Yuma | Arizona | 4027 | 30368 | 574 |
907765 | 907765 | 2021-01-08 | Yuma | Colorado | 8125 | 583 | 14 |
904321 | 904321 | 2021-01-07 | Yuma | Arizona | 4027 | 29715 | 565 |
904519 | 904519 | 2021-01-07 | Yuma | Colorado | 8125 | 571 | 14 |
901076 | 901076 | 2021-01-06 | Yuma | Arizona | 4027 | 29394 | 549 |
901274 | 901274 | 2021-01-06 | Yuma | Colorado | 8125 | 563 | 13 |
897831 | 897831 | 2021-01-05 | Yuma | Arizona | 4027 | 29165 | 543 |
898029 | 898029 | 2021-01-05 | Yuma | Colorado | 8125 | 563 | 13 |
894586 | 894586 | 2021-01-04 | Yuma | Arizona | 4027 | 29109 | 528 |
894784 | 894784 | 2021-01-04 | Yuma | Colorado | 8125 | 559 | 13 |
891339 | 891339 | 2021-01-03 | Yuma | Arizona | 4027 | 28921 | 528 |
891537 | 891537 | 2021-01-03 | Yuma | Colorado | 8125 | 559 | 13 |
888092 | 888092 | 2021-01-02 | Yuma | Arizona | 4027 | 28375 | 528 |
888290 | 888290 | 2021-01-02 | Yuma | Colorado | 8125 | 556 | 13 |
884847 | 884847 | 2021-01-01 | Yuma | Arizona | 4027 | 27812 | 527 |
885045 | 885045 | 2021-01-01 | Yuma | Colorado | 8125 | 552 | 13 |
881602 | 881602 | 2020-12-31 | Yuma | Arizona | 4027 | 27366 | 519 |
881800 | 881800 | 2020-12-31 | Yuma | Colorado | 8125 | 549 | 13 |
878357 | 878357 | 2020-12-30 | Yuma | Arizona | 4027 | 27115 | 510 |
878555 | 878555 | 2020-12-30 | Yuma | Colorado | 8125 | 542 | 11 |
875112 | 875112 | 2020-12-29 | Yuma | Arizona | 4027 | 27068 | 504 |
875310 | 875310 | 2020-12-29 | Yuma | Colorado | 8125 | 542 | 10 |
871867 | 871867 | 2020-12-28 | Yuma | Arizona | 4027 | 26946 | 498 |
872065 | 872065 | 2020-12-28 | Yuma | Colorado | 8125 | 536 | 10 |
868622 | 868622 | 2020-12-27 | Yuma | Arizona | 4027 | 26586 | 498 |
868820 | 868820 | 2020-12-27 | Yuma | Colorado | 8125 | 527 | 10 |
865377 | 865377 | 2020-12-26 | Yuma | Arizona | 4027 | 26563 | 498 |
865575 | 865575 | 2020-12-26 | Yuma | Colorado | 8125 | 524 | 10 |
862132 | 862132 | 2020-12-25 | Yuma | Arizona | 4027 | 26074 | 498 |
862330 | 862330 | 2020-12-25 | Yuma | Colorado | 8125 | 518 | 10 |
858887 | 858887 | 2020-12-24 | Yuma | Arizona | 4027 | 25732 | 486 |
859085 | 859085 | 2020-12-24 | Yuma | Colorado | 8125 | 511 | 8 |
855642 | 855642 | 2020-12-23 | Yuma | Arizona | 4027 | 25588 | 482 |
855840 | 855840 | 2020-12-23 | Yuma | Colorado | 8125 | 509 | 6 |
852397 | 852397 | 2020-12-22 | Yuma | Arizona | 4027 | 25265 | 480 |
852595 | 852595 | 2020-12-22 | Yuma | Colorado | 8125 | 505 | 6 |
849152 | 849152 | 2020-12-21 | Yuma | Arizona | 4027 | 24964 | 465 |
849350 | 849350 | 2020-12-21 | Yuma | Colorado | 8125 | 501 | 6 |
845907 | 845907 | 2020-12-20 | Yuma | Arizona | 4027 | 24592 | 465 |
846105 | 846105 | 2020-12-20 | Yuma | Colorado | 8125 | 496 | 6 |
842661 | 842661 | 2020-12-19 | Yuma | Arizona | 4027 | 24341 | 465 |
842859 | 842859 | 2020-12-19 | Yuma | Colorado | 8125 | 492 | 6 |
839416 | 839416 | 2020-12-18 | Yuma | Arizona | 4027 | 24103 | 455 |
839614 | 839614 | 2020-12-18 | Yuma | Colorado | 8125 | 488 | 6 |
836171 | 836171 | 2020-12-17 | Yuma | Arizona | 4027 | 23550 | 448 |
836369 | 836369 | 2020-12-17 | Yuma | Colorado | 8125 | 484 | 5 |
832925 | 832925 | 2020-12-16 | Yuma | Arizona | 4027 | 23510 | 435 |
833123 | 833123 | 2020-12-16 | Yuma | Colorado | 8125 | 464 | 4 |
829678 | 829678 | 2020-12-15 | Yuma | Arizona | 4027 | 23510 | 427 |
829876 | 829876 | 2020-12-15 | Yuma | Colorado | 8125 | 452 | 4 |
826432 | 826432 | 2020-12-14 | Yuma | Arizona | 4027 | 23513 | 423 |
826630 | 826630 | 2020-12-14 | Yuma | Colorado | 8125 | 442 | 4 |
823185 | 823185 | 2020-12-13 | Yuma | Arizona | 4027 | 22384 | 423 |
823383 | 823383 | 2020-12-13 | Yuma | Colorado | 8125 | 442 | 4 |
819939 | 819939 | 2020-12-12 | Yuma | Arizona | 4027 | 21881 | 423 |
820137 | 820137 | 2020-12-12 | Yuma | Colorado | 8125 | 433 | 3 |
816693 | 816693 | 2020-12-11 | Yuma | Arizona | 4027 | 21493 | 420 |
816891 | 816891 | 2020-12-11 | Yuma | Colorado | 8125 | 427 | 3 |
813447 | 813447 | 2020-12-10 | Yuma | Arizona | 4027 | 21100 | 417 |
813645 | 813645 | 2020-12-10 | Yuma | Colorado | 8125 | 406 | 3 |
810203 | 810203 | 2020-12-09 | Yuma | Arizona | 4027 | 20788 | 415 |
810401 | 810401 | 2020-12-09 | Yuma | Colorado | 8125 | 394 | 3 |
806958 | 806958 | 2020-12-08 | Yuma | Arizona | 4027 | 20490 | 410 |
807156 | 807156 | 2020-12-08 | Yuma | Colorado | 8125 | 385 | 3 |
803713 | 803713 | 2020-12-07 | Yuma | Arizona | 4027 | 19755 | 409 |
803911 | 803911 | 2020-12-07 | Yuma | Colorado | 8125 | 379 | 3 |
800468 | 800468 | 2020-12-06 | Yuma | Arizona | 4027 | 19643 | 409 |
800666 | 800666 | 2020-12-06 | Yuma | Colorado | 8125 | 368 | 3 |
797223 | 797223 | 2020-12-05 | Yuma | Arizona | 4027 | 19235 | 409 |
797421 | 797421 | 2020-12-05 | Yuma | Colorado | 8125 | 367 | 3 |
793978 | 793978 | 2020-12-04 | Yuma | Arizona | 4027 | 18762 | 407 |
794176 | 794176 | 2020-12-04 | Yuma | Colorado | 8125 | 359 | 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);