ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Grant" and state = "Washington" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
907281 | 907281 | 2021-01-07 | Grant | Washington | 53025 | 7226 | 90 |
904035 | 904035 | 2021-01-06 | Grant | Washington | 53025 | 7172 | 82 |
900790 | 900790 | 2021-01-05 | Grant | Washington | 53025 | 7124 | 82 |
897545 | 897545 | 2021-01-04 | Grant | Washington | 53025 | 7071 | 82 |
894299 | 894299 | 2021-01-03 | Grant | Washington | 53025 | 6923 | 82 |
891053 | 891053 | 2021-01-02 | Grant | Washington | 53025 | 6923 | 82 |
887806 | 887806 | 2021-01-01 | Grant | Washington | 53025 | 6923 | 82 |
884561 | 884561 | 2020-12-31 | Grant | Washington | 53025 | 6923 | 82 |
881316 | 881316 | 2020-12-30 | Grant | Washington | 53025 | 6823 | 82 |
878071 | 878071 | 2020-12-29 | Grant | Washington | 53025 | 6784 | 82 |
874826 | 874826 | 2020-12-28 | Grant | Washington | 53025 | 6736 | 72 |
871581 | 871581 | 2020-12-27 | Grant | Washington | 53025 | 6621 | 72 |
868336 | 868336 | 2020-12-26 | Grant | Washington | 53025 | 6621 | 72 |
865091 | 865091 | 2020-12-25 | Grant | Washington | 53025 | 6532 | 72 |
861846 | 861846 | 2020-12-24 | Grant | Washington | 53025 | 6532 | 72 |
858601 | 858601 | 2020-12-23 | Grant | Washington | 53025 | 6532 | 72 |
855356 | 855356 | 2020-12-22 | Grant | Washington | 53025 | 6465 | 72 |
852111 | 852111 | 2020-12-21 | Grant | Washington | 53025 | 6427 | 72 |
848866 | 848866 | 2020-12-20 | Grant | Washington | 53025 | 6289 | 72 |
845621 | 845621 | 2020-12-19 | Grant | Washington | 53025 | 6289 | 72 |
842375 | 842375 | 2020-12-18 | Grant | Washington | 53025 | 6289 | 72 |
839130 | 839130 | 2020-12-17 | Grant | Washington | 53025 | 6085 | 72 |
835884 | 835884 | 2020-12-16 | Grant | Washington | 53025 | 6085 | 72 |
832638 | 832638 | 2020-12-15 | Grant | Washington | 53025 | 6034 | 64 |
829391 | 829391 | 2020-12-14 | Grant | Washington | 53025 | 5931 | 64 |
826145 | 826145 | 2020-12-13 | Grant | Washington | 53025 | 5770 | 64 |
822898 | 822898 | 2020-12-12 | Grant | Washington | 53025 | 5770 | 64 |
819652 | 819652 | 2020-12-11 | Grant | Washington | 53025 | 5770 | 64 |
816406 | 816406 | 2020-12-10 | Grant | Washington | 53025 | 5713 | 64 |
813160 | 813160 | 2020-12-09 | Grant | Washington | 53025 | 5618 | 53 |
809916 | 809916 | 2020-12-08 | Grant | Washington | 53025 | 5584 | 53 |
806671 | 806671 | 2020-12-07 | Grant | Washington | 53025 | 5480 | 53 |
803426 | 803426 | 2020-12-06 | Grant | Washington | 53025 | 5315 | 53 |
800181 | 800181 | 2020-12-05 | Grant | Washington | 53025 | 5315 | 53 |
796936 | 796936 | 2020-12-04 | Grant | Washington | 53025 | 5315 | 53 |
793691 | 793691 | 2020-12-03 | Grant | Washington | 53025 | 5238 | 53 |
790446 | 790446 | 2020-12-02 | Grant | Washington | 53025 | 5157 | 43 |
787201 | 787201 | 2020-12-01 | Grant | Washington | 53025 | 5083 | 38 |
783957 | 783957 | 2020-11-30 | Grant | Washington | 53025 | 5018 | 35 |
780712 | 780712 | 2020-11-29 | Grant | Washington | 53025 | 4903 | 35 |
777466 | 777466 | 2020-11-28 | Grant | Washington | 53025 | 4903 | 35 |
774221 | 774221 | 2020-11-27 | Grant | Washington | 53025 | 4903 | 35 |
770976 | 770976 | 2020-11-26 | Grant | Washington | 53025 | 4814 | 35 |
767730 | 767730 | 2020-11-25 | Grant | Washington | 53025 | 4814 | 35 |
764485 | 764485 | 2020-11-24 | Grant | Washington | 53025 | 4704 | 32 |
761240 | 761240 | 2020-11-23 | Grant | Washington | 53025 | 4628 | 32 |
757995 | 757995 | 2020-11-22 | Grant | Washington | 53025 | 4401 | 31 |
754748 | 754748 | 2020-11-21 | Grant | Washington | 53025 | 4401 | 31 |
751502 | 751502 | 2020-11-20 | Grant | Washington | 53025 | 4401 | 31 |
748256 | 748256 | 2020-11-19 | Grant | Washington | 53025 | 4295 | 31 |
745010 | 745010 | 2020-11-18 | Grant | Washington | 53025 | 4250 | 31 |
741763 | 741763 | 2020-11-17 | Grant | Washington | 53025 | 4181 | 31 |
738516 | 738516 | 2020-11-16 | Grant | Washington | 53025 | 4093 | 30 |
735272 | 735272 | 2020-11-15 | Grant | Washington | 53025 | 3958 | 29 |
732026 | 732026 | 2020-11-14 | Grant | Washington | 53025 | 3958 | 29 |
728781 | 728781 | 2020-11-13 | Grant | Washington | 53025 | 3958 | 29 |
725538 | 725538 | 2020-11-12 | Grant | Washington | 53025 | 3890 | 29 |
722295 | 722295 | 2020-11-11 | Grant | Washington | 53025 | 3808 | 29 |
719052 | 719052 | 2020-11-10 | Grant | Washington | 53025 | 3808 | 29 |
715809 | 715809 | 2020-11-09 | Grant | Washington | 53025 | 3788 | 29 |
712565 | 712565 | 2020-11-08 | Grant | Washington | 53025 | 3720 | 28 |
709321 | 709321 | 2020-11-07 | Grant | Washington | 53025 | 3720 | 28 |
706077 | 706077 | 2020-11-06 | Grant | Washington | 53025 | 3720 | 28 |
702834 | 702834 | 2020-11-05 | Grant | Washington | 53025 | 3679 | 28 |
699591 | 699591 | 2020-11-04 | Grant | Washington | 53025 | 3659 | 28 |
696347 | 696347 | 2020-11-03 | Grant | Washington | 53025 | 3629 | 28 |
693105 | 693105 | 2020-11-02 | Grant | Washington | 53025 | 3614 | 27 |
689861 | 689861 | 2020-11-01 | Grant | Washington | 53025 | 3571 | 27 |
686616 | 686616 | 2020-10-31 | Grant | Washington | 53025 | 3571 | 27 |
683373 | 683373 | 2020-10-30 | Grant | Washington | 53025 | 3571 | 27 |
680130 | 680130 | 2020-10-29 | Grant | Washington | 53025 | 3555 | 27 |
676887 | 676887 | 2020-10-28 | Grant | Washington | 53025 | 3542 | 26 |
673644 | 673644 | 2020-10-27 | Grant | Washington | 53025 | 3522 | 25 |
670402 | 670402 | 2020-10-26 | Grant | Washington | 53025 | 3515 | 25 |
667159 | 667159 | 2020-10-25 | Grant | Washington | 53025 | 3491 | 25 |
663914 | 663914 | 2020-10-24 | Grant | Washington | 53025 | 3491 | 25 |
660670 | 660670 | 2020-10-23 | Grant | Washington | 53025 | 3491 | 25 |
657426 | 657426 | 2020-10-22 | Grant | Washington | 53025 | 3476 | 25 |
654181 | 654181 | 2020-10-21 | Grant | Washington | 53025 | 3467 | 25 |
650936 | 650936 | 2020-10-20 | Grant | Washington | 53025 | 3454 | 25 |
647692 | 647692 | 2020-10-19 | Grant | Washington | 53025 | 3442 | 24 |
644446 | 644446 | 2020-10-18 | Grant | Washington | 53025 | 3412 | 23 |
641198 | 641198 | 2020-10-17 | Grant | Washington | 53025 | 3412 | 23 |
637951 | 637951 | 2020-10-16 | Grant | Washington | 53025 | 3412 | 23 |
634706 | 634706 | 2020-10-15 | Grant | Washington | 53025 | 3381 | 23 |
631461 | 631461 | 2020-10-14 | Grant | Washington | 53025 | 3345 | 23 |
628217 | 628217 | 2020-10-13 | Grant | Washington | 53025 | 3325 | 23 |
624974 | 624974 | 2020-10-12 | Grant | Washington | 53025 | 3308 | 23 |
621731 | 621731 | 2020-10-11 | Grant | Washington | 53025 | 3252 | 22 |
618488 | 618488 | 2020-10-10 | Grant | Washington | 53025 | 3252 | 22 |
615246 | 615246 | 2020-10-09 | Grant | Washington | 53025 | 3252 | 22 |
612005 | 612005 | 2020-10-08 | Grant | Washington | 53025 | 3238 | 22 |
608763 | 608763 | 2020-10-07 | Grant | Washington | 53025 | 3215 | 22 |
605520 | 605520 | 2020-10-06 | Grant | Washington | 53025 | 3191 | 22 |
602278 | 602278 | 2020-10-05 | Grant | Washington | 53025 | 3173 | 22 |
599035 | 599035 | 2020-10-04 | Grant | Washington | 53025 | 3131 | 21 |
595792 | 595792 | 2020-10-03 | Grant | Washington | 53025 | 3131 | 21 |
592550 | 592550 | 2020-10-02 | Grant | Washington | 53025 | 3131 | 21 |
589310 | 589310 | 2020-10-01 | Grant | Washington | 53025 | 3131 | 21 |
586069 | 586069 | 2020-09-30 | Grant | Washington | 53025 | 3107 | 21 |
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);