ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Washington" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
917257 | 917257 | 2021-01-11 | Washington | Alabama | 1129 | 1323 | 26 |
914012 | 914012 | 2021-01-10 | Washington | Alabama | 1129 | 1320 | 26 |
910767 | 910767 | 2021-01-09 | Washington | Alabama | 1129 | 1312 | 26 |
907522 | 907522 | 2021-01-08 | Washington | Alabama | 1129 | 1305 | 26 |
904276 | 904276 | 2021-01-07 | Washington | Alabama | 1129 | 1283 | 26 |
901031 | 901031 | 2021-01-06 | Washington | Alabama | 1129 | 1256 | 24 |
897786 | 897786 | 2021-01-05 | Washington | Alabama | 1129 | 1244 | 24 |
894540 | 894540 | 2021-01-04 | Washington | Alabama | 1129 | 1234 | 24 |
891294 | 891294 | 2021-01-03 | Washington | Alabama | 1129 | 1224 | 24 |
888047 | 888047 | 2021-01-02 | Washington | Alabama | 1129 | 1211 | 24 |
884802 | 884802 | 2021-01-01 | Washington | Alabama | 1129 | 1199 | 24 |
881557 | 881557 | 2020-12-31 | Washington | Alabama | 1129 | 1184 | 24 |
878312 | 878312 | 2020-12-30 | Washington | Alabama | 1129 | 1176 | 24 |
875067 | 875067 | 2020-12-29 | Washington | Alabama | 1129 | 1165 | 24 |
871822 | 871822 | 2020-12-28 | Washington | Alabama | 1129 | 1159 | 24 |
868577 | 868577 | 2020-12-27 | Washington | Alabama | 1129 | 1158 | 24 |
865332 | 865332 | 2020-12-26 | Washington | Alabama | 1129 | 1149 | 24 |
862087 | 862087 | 2020-12-25 | Washington | Alabama | 1129 | 1145 | 24 |
858842 | 858842 | 2020-12-24 | Washington | Alabama | 1129 | 1138 | 24 |
855597 | 855597 | 2020-12-23 | Washington | Alabama | 1129 | 1125 | 24 |
852352 | 852352 | 2020-12-22 | Washington | Alabama | 1129 | 1121 | 23 |
849107 | 849107 | 2020-12-21 | Washington | Alabama | 1129 | 1109 | 23 |
845862 | 845862 | 2020-12-20 | Washington | Alabama | 1129 | 1105 | 23 |
842616 | 842616 | 2020-12-19 | Washington | Alabama | 1129 | 1086 | 23 |
839371 | 839371 | 2020-12-18 | Washington | Alabama | 1129 | 1073 | 23 |
836126 | 836126 | 2020-12-17 | Washington | Alabama | 1129 | 1052 | 23 |
832880 | 832880 | 2020-12-16 | Washington | Alabama | 1129 | 1041 | 23 |
829633 | 829633 | 2020-12-15 | Washington | Alabama | 1129 | 1037 | 23 |
826387 | 826387 | 2020-12-14 | Washington | Alabama | 1129 | 1032 | 23 |
823140 | 823140 | 2020-12-13 | Washington | Alabama | 1129 | 1026 | 23 |
819894 | 819894 | 2020-12-12 | Washington | Alabama | 1129 | 1020 | 23 |
816648 | 816648 | 2020-12-11 | Washington | Alabama | 1129 | 1003 | 22 |
813402 | 813402 | 2020-12-10 | Washington | Alabama | 1129 | 992 | 22 |
810158 | 810158 | 2020-12-09 | Washington | Alabama | 1129 | 980 | 22 |
806913 | 806913 | 2020-12-08 | Washington | Alabama | 1129 | 969 | 22 |
803668 | 803668 | 2020-12-07 | Washington | Alabama | 1129 | 965 | 22 |
800423 | 800423 | 2020-12-06 | Washington | Alabama | 1129 | 952 | 22 |
797178 | 797178 | 2020-12-05 | Washington | Alabama | 1129 | 944 | 22 |
793933 | 793933 | 2020-12-04 | Washington | Alabama | 1129 | 942 | 22 |
790688 | 790688 | 2020-12-03 | Washington | Alabama | 1129 | 939 | 21 |
787443 | 787443 | 2020-12-02 | Washington | Alabama | 1129 | 933 | 19 |
784199 | 784199 | 2020-12-01 | Washington | Alabama | 1129 | 932 | 19 |
780954 | 780954 | 2020-11-30 | Washington | Alabama | 1129 | 922 | 19 |
777708 | 777708 | 2020-11-29 | Washington | Alabama | 1129 | 916 | 19 |
774463 | 774463 | 2020-11-28 | Washington | Alabama | 1129 | 912 | 19 |
771218 | 771218 | 2020-11-27 | Washington | Alabama | 1129 | 909 | 19 |
767972 | 767972 | 2020-11-26 | Washington | Alabama | 1129 | 907 | 19 |
764727 | 764727 | 2020-11-25 | Washington | Alabama | 1129 | 902 | 19 |
761482 | 761482 | 2020-11-24 | Washington | Alabama | 1129 | 899 | 18 |
758237 | 758237 | 2020-11-23 | Washington | Alabama | 1129 | 900 | 18 |
754990 | 754990 | 2020-11-22 | Washington | Alabama | 1129 | 898 | 18 |
751744 | 751744 | 2020-11-21 | Washington | Alabama | 1129 | 896 | 18 |
748498 | 748498 | 2020-11-20 | Washington | Alabama | 1129 | 891 | 18 |
745252 | 745252 | 2020-11-19 | Washington | Alabama | 1129 | 884 | 17 |
742005 | 742005 | 2020-11-18 | Washington | Alabama | 1129 | 878 | 17 |
738758 | 738758 | 2020-11-17 | Washington | Alabama | 1129 | 880 | 17 |
735514 | 735514 | 2020-11-16 | Washington | Alabama | 1129 | 877 | 12 |
732268 | 732268 | 2020-11-15 | Washington | Alabama | 1129 | 875 | 12 |
729023 | 729023 | 2020-11-14 | Washington | Alabama | 1129 | 869 | 12 |
725780 | 725780 | 2020-11-13 | Washington | Alabama | 1129 | 865 | 12 |
722537 | 722537 | 2020-11-12 | Washington | Alabama | 1129 | 852 | 12 |
719294 | 719294 | 2020-11-11 | Washington | Alabama | 1129 | 841 | 12 |
716051 | 716051 | 2020-11-10 | Washington | Alabama | 1129 | 828 | 12 |
712807 | 712807 | 2020-11-09 | Washington | Alabama | 1129 | 818 | 12 |
709563 | 709563 | 2020-11-08 | Washington | Alabama | 1129 | 812 | 12 |
706319 | 706319 | 2020-11-07 | Washington | Alabama | 1129 | 806 | 12 |
703076 | 703076 | 2020-11-06 | Washington | Alabama | 1129 | 801 | 12 |
699833 | 699833 | 2020-11-05 | Washington | Alabama | 1129 | 794 | 12 |
696589 | 696589 | 2020-11-04 | Washington | Alabama | 1129 | 787 | 12 |
693347 | 693347 | 2020-11-03 | Washington | Alabama | 1129 | 779 | 12 |
690104 | 690104 | 2020-11-02 | Washington | Alabama | 1129 | 776 | 12 |
686859 | 686859 | 2020-11-01 | Washington | Alabama | 1129 | 774 | 12 |
683615 | 683615 | 2020-10-31 | Washington | Alabama | 1129 | 768 | 12 |
680372 | 680372 | 2020-10-30 | Washington | Alabama | 1129 | 759 | 12 |
677129 | 677129 | 2020-10-29 | Washington | Alabama | 1129 | 758 | 12 |
673886 | 673886 | 2020-10-28 | Washington | Alabama | 1129 | 754 | 12 |
670644 | 670644 | 2020-10-27 | Washington | Alabama | 1129 | 751 | 12 |
667401 | 667401 | 2020-10-26 | Washington | Alabama | 1129 | 749 | 12 |
664156 | 664156 | 2020-10-25 | Washington | Alabama | 1129 | 749 | 12 |
660912 | 660912 | 2020-10-24 | Washington | Alabama | 1129 | 744 | 12 |
657668 | 657668 | 2020-10-23 | Washington | Alabama | 1129 | 734 | 12 |
654423 | 654423 | 2020-10-22 | Washington | Alabama | 1129 | 634 | 12 |
651178 | 651178 | 2020-10-21 | Washington | Alabama | 1129 | 623 | 12 |
647934 | 647934 | 2020-10-20 | Washington | Alabama | 1129 | 622 | 12 |
644689 | 644689 | 2020-10-19 | Washington | Alabama | 1129 | 621 | 12 |
641441 | 641441 | 2020-10-18 | Washington | Alabama | 1129 | 620 | 12 |
638194 | 638194 | 2020-10-17 | Washington | Alabama | 1129 | 614 | 12 |
634949 | 634949 | 2020-10-16 | Washington | Alabama | 1129 | 615 | 12 |
631704 | 631704 | 2020-10-15 | Washington | Alabama | 1129 | 613 | 12 |
628460 | 628460 | 2020-10-14 | Washington | Alabama | 1129 | 611 | 12 |
625217 | 625217 | 2020-10-13 | Washington | Alabama | 1129 | 607 | 12 |
621974 | 621974 | 2020-10-12 | Washington | Alabama | 1129 | 606 | 12 |
618731 | 618731 | 2020-10-11 | Washington | Alabama | 1129 | 605 | 12 |
615489 | 615489 | 2020-10-10 | Washington | Alabama | 1129 | 599 | 12 |
612248 | 612248 | 2020-10-09 | Washington | Alabama | 1129 | 589 | 12 |
609006 | 609006 | 2020-10-08 | Washington | Alabama | 1129 | 588 | 12 |
605763 | 605763 | 2020-10-07 | Washington | Alabama | 1129 | 587 | 12 |
602521 | 602521 | 2020-10-06 | Washington | Alabama | 1129 | 584 | 12 |
599278 | 599278 | 2020-10-05 | Washington | Alabama | 1129 | 582 | 12 |
596035 | 596035 | 2020-10-04 | Washington | Alabama | 1129 | 582 | 12 |
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);