ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Washington" and fips = 21229 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921552 | 921552 | 2021-01-12 | Washington | Kentucky | 21229 | 971 | 12 |
918307 | 918307 | 2021-01-11 | Washington | Kentucky | 21229 | 962 | 12 |
915062 | 915062 | 2021-01-10 | Washington | Kentucky | 21229 | 959 | 12 |
911817 | 911817 | 2021-01-09 | Washington | Kentucky | 21229 | 953 | 12 |
908572 | 908572 | 2021-01-08 | Washington | Kentucky | 21229 | 939 | 12 |
905326 | 905326 | 2021-01-07 | Washington | Kentucky | 21229 | 931 | 12 |
902081 | 902081 | 2021-01-06 | Washington | Kentucky | 21229 | 920 | 12 |
898836 | 898836 | 2021-01-05 | Washington | Kentucky | 21229 | 899 | 11 |
895591 | 895591 | 2021-01-04 | Washington | Kentucky | 21229 | 892 | 11 |
892344 | 892344 | 2021-01-03 | Washington | Kentucky | 21229 | 889 | 11 |
889098 | 889098 | 2021-01-02 | Washington | Kentucky | 21229 | 886 | 11 |
885852 | 885852 | 2021-01-01 | Washington | Kentucky | 21229 | 869 | 9 |
882607 | 882607 | 2020-12-31 | Washington | Kentucky | 21229 | 869 | 9 |
879362 | 879362 | 2020-12-30 | Washington | Kentucky | 21229 | 869 | 9 |
876117 | 876117 | 2020-12-29 | Washington | Kentucky | 21229 | 860 | 9 |
872872 | 872872 | 2020-12-28 | Washington | Kentucky | 21229 | 850 | 9 |
869627 | 869627 | 2020-12-27 | Washington | Kentucky | 21229 | 847 | 9 |
866382 | 866382 | 2020-12-26 | Washington | Kentucky | 21229 | 846 | 9 |
863137 | 863137 | 2020-12-25 | Washington | Kentucky | 21229 | 826 | 9 |
859892 | 859892 | 2020-12-24 | Washington | Kentucky | 21229 | 826 | 9 |
856647 | 856647 | 2020-12-23 | Washington | Kentucky | 21229 | 826 | 9 |
853402 | 853402 | 2020-12-22 | Washington | Kentucky | 21229 | 821 | 9 |
850157 | 850157 | 2020-12-21 | Washington | Kentucky | 21229 | 809 | 9 |
846912 | 846912 | 2020-12-20 | Washington | Kentucky | 21229 | 808 | 9 |
843666 | 843666 | 2020-12-19 | Washington | Kentucky | 21229 | 806 | 8 |
840421 | 840421 | 2020-12-18 | Washington | Kentucky | 21229 | 791 | 8 |
837176 | 837176 | 2020-12-17 | Washington | Kentucky | 21229 | 781 | 8 |
833930 | 833930 | 2020-12-16 | Washington | Kentucky | 21229 | 775 | 7 |
830683 | 830683 | 2020-12-15 | Washington | Kentucky | 21229 | 760 | 7 |
827437 | 827437 | 2020-12-14 | Washington | Kentucky | 21229 | 746 | 7 |
824190 | 824190 | 2020-12-13 | Washington | Kentucky | 21229 | 745 | 4 |
820944 | 820944 | 2020-12-12 | Washington | Kentucky | 21229 | 742 | 4 |
817698 | 817698 | 2020-12-11 | Washington | Kentucky | 21229 | 726 | 4 |
814452 | 814452 | 2020-12-10 | Washington | Kentucky | 21229 | 713 | 4 |
811207 | 811207 | 2020-12-09 | Washington | Kentucky | 21229 | 699 | 4 |
807962 | 807962 | 2020-12-08 | Washington | Kentucky | 21229 | 687 | 4 |
804717 | 804717 | 2020-12-07 | Washington | Kentucky | 21229 | 670 | 4 |
801472 | 801472 | 2020-12-06 | Washington | Kentucky | 21229 | 666 | 4 |
798227 | 798227 | 2020-12-05 | Washington | Kentucky | 21229 | 658 | 4 |
794982 | 794982 | 2020-12-04 | Washington | Kentucky | 21229 | 629 | 4 |
791737 | 791737 | 2020-12-03 | Washington | Kentucky | 21229 | 592 | 4 |
788492 | 788492 | 2020-12-02 | Washington | Kentucky | 21229 | 581 | 4 |
785248 | 785248 | 2020-12-01 | Washington | Kentucky | 21229 | 560 | 4 |
782003 | 782003 | 2020-11-30 | Washington | Kentucky | 21229 | 541 | 4 |
778757 | 778757 | 2020-11-29 | Washington | Kentucky | 21229 | 530 | 4 |
775512 | 775512 | 2020-11-28 | Washington | Kentucky | 21229 | 515 | 4 |
772267 | 772267 | 2020-11-27 | Washington | Kentucky | 21229 | 515 | 4 |
769022 | 769022 | 2020-11-26 | Washington | Kentucky | 21229 | 489 | 4 |
765776 | 765776 | 2020-11-25 | Washington | Kentucky | 21229 | 489 | 4 |
762531 | 762531 | 2020-11-24 | Washington | Kentucky | 21229 | 482 | 4 |
759286 | 759286 | 2020-11-23 | Washington | Kentucky | 21229 | 465 | 4 |
756039 | 756039 | 2020-11-22 | Washington | Kentucky | 21229 | 453 | 4 |
752793 | 752793 | 2020-11-21 | Washington | Kentucky | 21229 | 453 | 4 |
749547 | 749547 | 2020-11-20 | Washington | Kentucky | 21229 | 453 | 4 |
746301 | 746301 | 2020-11-19 | Washington | Kentucky | 21229 | 436 | 4 |
743054 | 743054 | 2020-11-18 | Washington | Kentucky | 21229 | 414 | 4 |
739807 | 739807 | 2020-11-17 | Washington | Kentucky | 21229 | 406 | 4 |
736563 | 736563 | 2020-11-16 | Washington | Kentucky | 21229 | 394 | 3 |
733317 | 733317 | 2020-11-15 | Washington | Kentucky | 21229 | 382 | 3 |
730072 | 730072 | 2020-11-14 | Washington | Kentucky | 21229 | 382 | 3 |
726829 | 726829 | 2020-11-13 | Washington | Kentucky | 21229 | 382 | 3 |
723586 | 723586 | 2020-11-12 | Washington | Kentucky | 21229 | 364 | 3 |
720343 | 720343 | 2020-11-11 | Washington | Kentucky | 21229 | 345 | 3 |
717100 | 717100 | 2020-11-10 | Washington | Kentucky | 21229 | 345 | 3 |
713856 | 713856 | 2020-11-09 | Washington | Kentucky | 21229 | 333 | 3 |
710612 | 710612 | 2020-11-08 | Washington | Kentucky | 21229 | 317 | 3 |
707368 | 707368 | 2020-11-07 | Washington | Kentucky | 21229 | 315 | 3 |
704125 | 704125 | 2020-11-06 | Washington | Kentucky | 21229 | 314 | 3 |
700883 | 700883 | 2020-11-05 | Washington | Kentucky | 21229 | 304 | 3 |
697639 | 697639 | 2020-11-04 | Washington | Kentucky | 21229 | 297 | 3 |
694396 | 694396 | 2020-11-03 | Washington | Kentucky | 21229 | 292 | 3 |
691154 | 691154 | 2020-11-02 | Washington | Kentucky | 21229 | 292 | 3 |
687909 | 687909 | 2020-11-01 | Washington | Kentucky | 21229 | 274 | 2 |
684665 | 684665 | 2020-10-31 | Washington | Kentucky | 21229 | 270 | 2 |
681422 | 681422 | 2020-10-30 | Washington | Kentucky | 21229 | 270 | 2 |
678178 | 678178 | 2020-10-29 | Washington | Kentucky | 21229 | 265 | 2 |
674936 | 674936 | 2020-10-28 | Washington | Kentucky | 21229 | 257 | 2 |
671693 | 671693 | 2020-10-27 | Washington | Kentucky | 21229 | 237 | 2 |
668451 | 668451 | 2020-10-26 | Washington | Kentucky | 21229 | 228 | 2 |
665207 | 665207 | 2020-10-25 | Washington | Kentucky | 21229 | 225 | 2 |
661962 | 661962 | 2020-10-24 | Washington | Kentucky | 21229 | 221 | 2 |
658718 | 658718 | 2020-10-23 | Washington | Kentucky | 21229 | 217 | 2 |
655473 | 655473 | 2020-10-22 | Washington | Kentucky | 21229 | 214 | 2 |
652228 | 652228 | 2020-10-21 | Washington | Kentucky | 21229 | 212 | 2 |
648983 | 648983 | 2020-10-20 | Washington | Kentucky | 21229 | 200 | 2 |
645739 | 645739 | 2020-10-19 | Washington | Kentucky | 21229 | 198 | 2 |
642492 | 642492 | 2020-10-18 | Washington | Kentucky | 21229 | 198 | 1 |
639245 | 639245 | 2020-10-17 | Washington | Kentucky | 21229 | 189 | 1 |
635999 | 635999 | 2020-10-16 | Washington | Kentucky | 21229 | 183 | 1 |
632753 | 632753 | 2020-10-15 | Washington | Kentucky | 21229 | 180 | 1 |
629509 | 629509 | 2020-10-14 | Washington | Kentucky | 21229 | 177 | 1 |
626265 | 626265 | 2020-10-13 | Washington | Kentucky | 21229 | 175 | 1 |
623023 | 623023 | 2020-10-12 | Washington | Kentucky | 21229 | 175 | 1 |
619779 | 619779 | 2020-10-11 | Washington | Kentucky | 21229 | 172 | 1 |
616537 | 616537 | 2020-10-10 | Washington | Kentucky | 21229 | 168 | 1 |
613296 | 613296 | 2020-10-09 | Washington | Kentucky | 21229 | 163 | 1 |
610054 | 610054 | 2020-10-08 | Washington | Kentucky | 21229 | 158 | 1 |
606812 | 606812 | 2020-10-07 | Washington | Kentucky | 21229 | 157 | 1 |
603570 | 603570 | 2020-10-06 | Washington | Kentucky | 21229 | 153 | 1 |
600327 | 600327 | 2020-10-05 | Washington | Kentucky | 21229 | 150 | 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);