ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Elmore" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1050284 | 1050284 | 2021-02-21 | Elmore | Alabama | 1051 | 9250 | 178 |
1047037 | 1047037 | 2021-02-20 | Elmore | Alabama | 1051 | 9228 | 178 |
1043792 | 1043792 | 2021-02-19 | Elmore | Alabama | 1051 | 9214 | 178 |
1040547 | 1040547 | 2021-02-18 | Elmore | Alabama | 1051 | 9191 | 171 |
1037302 | 1037302 | 2021-02-17 | Elmore | Alabama | 1051 | 9155 | 170 |
1034057 | 1034057 | 2021-02-16 | Elmore | Alabama | 1051 | 9129 | 168 |
1030811 | 1030811 | 2021-02-15 | Elmore | Alabama | 1051 | 9110 | 168 |
1027564 | 1027564 | 2021-02-14 | Elmore | Alabama | 1051 | 9100 | 168 |
1024319 | 1024319 | 2021-02-13 | Elmore | Alabama | 1051 | 9088 | 168 |
1021074 | 1021074 | 2021-02-12 | Elmore | Alabama | 1051 | 9060 | 168 |
1017829 | 1017829 | 2021-02-11 | Elmore | Alabama | 1051 | 9033 | 165 |
1014584 | 1014584 | 2021-02-10 | Elmore | Alabama | 1051 | 8999 | 162 |
1011339 | 1011339 | 2021-02-09 | Elmore | Alabama | 1051 | 8961 | 155 |
1008093 | 1008093 | 2021-02-08 | Elmore | Alabama | 1051 | 8927 | 152 |
1004847 | 1004847 | 2021-02-07 | Elmore | Alabama | 1051 | 8896 | 152 |
1001601 | 1001601 | 2021-02-06 | Elmore | Alabama | 1051 | 8869 | 152 |
998355 | 998355 | 2021-02-05 | Elmore | Alabama | 1051 | 8795 | 151 |
995109 | 995109 | 2021-02-04 | Elmore | Alabama | 1051 | 8744 | 149 |
991863 | 991863 | 2021-02-03 | Elmore | Alabama | 1051 | 8723 | 143 |
988617 | 988617 | 2021-02-02 | Elmore | Alabama | 1051 | 8687 | 134 |
985370 | 985370 | 2021-02-01 | Elmore | Alabama | 1051 | 8640 | 134 |
982123 | 982123 | 2021-01-31 | Elmore | Alabama | 1051 | 8602 | 134 |
978877 | 978877 | 2021-01-30 | Elmore | Alabama | 1051 | 8534 | 132 |
975632 | 975632 | 2021-01-29 | Elmore | Alabama | 1051 | 8534 | 132 |
972387 | 972387 | 2021-01-28 | Elmore | Alabama | 1051 | 8449 | 131 |
969142 | 969142 | 2021-01-27 | Elmore | Alabama | 1051 | 8379 | 123 |
965898 | 965898 | 2021-01-26 | Elmore | Alabama | 1051 | 8283 | 112 |
962653 | 962653 | 2021-01-25 | Elmore | Alabama | 1051 | 8243 | 110 |
959408 | 959408 | 2021-01-24 | Elmore | Alabama | 1051 | 8214 | 110 |
956162 | 956162 | 2021-01-23 | Elmore | Alabama | 1051 | 8183 | 110 |
952917 | 952917 | 2021-01-22 | Elmore | Alabama | 1051 | 8120 | 104 |
949672 | 949672 | 2021-01-21 | Elmore | Alabama | 1051 | 8056 | 104 |
946426 | 946426 | 2021-01-20 | Elmore | Alabama | 1051 | 7999 | 104 |
943179 | 943179 | 2021-01-19 | Elmore | Alabama | 1051 | 7923 | 101 |
939934 | 939934 | 2021-01-18 | Elmore | Alabama | 1051 | 7849 | 101 |
936689 | 936689 | 2021-01-17 | Elmore | Alabama | 1051 | 7836 | 101 |
933444 | 933444 | 2021-01-16 | Elmore | Alabama | 1051 | 7783 | 101 |
930199 | 930199 | 2021-01-15 | Elmore | Alabama | 1051 | 7723 | 101 |
926954 | 926954 | 2021-01-14 | Elmore | Alabama | 1051 | 7670 | 101 |
923708 | 923708 | 2021-01-13 | Elmore | Alabama | 1051 | 7613 | 91 |
920463 | 920463 | 2021-01-12 | Elmore | Alabama | 1051 | 7533 | 91 |
917218 | 917218 | 2021-01-11 | Elmore | Alabama | 1051 | 7433 | 85 |
913973 | 913973 | 2021-01-10 | Elmore | Alabama | 1051 | 7390 | 85 |
910728 | 910728 | 2021-01-09 | Elmore | Alabama | 1051 | 7334 | 85 |
907483 | 907483 | 2021-01-08 | Elmore | Alabama | 1051 | 7238 | 85 |
904237 | 904237 | 2021-01-07 | Elmore | Alabama | 1051 | 7156 | 85 |
900992 | 900992 | 2021-01-06 | Elmore | Alabama | 1051 | 7059 | 86 |
897747 | 897747 | 2021-01-05 | Elmore | Alabama | 1051 | 6958 | 83 |
894501 | 894501 | 2021-01-04 | Elmore | Alabama | 1051 | 6710 | 83 |
891255 | 891255 | 2021-01-03 | Elmore | Alabama | 1051 | 6671 | 83 |
888008 | 888008 | 2021-01-02 | Elmore | Alabama | 1051 | 6625 | 83 |
884763 | 884763 | 2021-01-01 | Elmore | Alabama | 1051 | 6542 | 83 |
881518 | 881518 | 2020-12-31 | Elmore | Alabama | 1051 | 6435 | 83 |
878273 | 878273 | 2020-12-30 | Elmore | Alabama | 1051 | 6321 | 82 |
875028 | 875028 | 2020-12-29 | Elmore | Alabama | 1051 | 6187 | 81 |
871783 | 871783 | 2020-12-28 | Elmore | Alabama | 1051 | 6063 | 81 |
868538 | 868538 | 2020-12-27 | Elmore | Alabama | 1051 | 5994 | 81 |
865293 | 865293 | 2020-12-26 | Elmore | Alabama | 1051 | 5941 | 81 |
862048 | 862048 | 2020-12-25 | Elmore | Alabama | 1051 | 5934 | 81 |
858803 | 858803 | 2020-12-24 | Elmore | Alabama | 1051 | 5850 | 80 |
855558 | 855558 | 2020-12-23 | Elmore | Alabama | 1051 | 5773 | 80 |
852313 | 852313 | 2020-12-22 | Elmore | Alabama | 1051 | 5694 | 80 |
849068 | 849068 | 2020-12-21 | Elmore | Alabama | 1051 | 5579 | 80 |
845823 | 845823 | 2020-12-20 | Elmore | Alabama | 1051 | 5535 | 80 |
842577 | 842577 | 2020-12-19 | Elmore | Alabama | 1051 | 5472 | 80 |
839332 | 839332 | 2020-12-18 | Elmore | Alabama | 1051 | 5357 | 78 |
836087 | 836087 | 2020-12-17 | Elmore | Alabama | 1051 | 5239 | 78 |
832841 | 832841 | 2020-12-16 | Elmore | Alabama | 1051 | 5143 | 76 |
829594 | 829594 | 2020-12-15 | Elmore | Alabama | 1051 | 5076 | 74 |
826348 | 826348 | 2020-12-14 | Elmore | Alabama | 1051 | 4991 | 72 |
823101 | 823101 | 2020-12-13 | Elmore | Alabama | 1051 | 4959 | 72 |
819855 | 819855 | 2020-12-12 | Elmore | Alabama | 1051 | 4909 | 72 |
816609 | 816609 | 2020-12-11 | Elmore | Alabama | 1051 | 4870 | 72 |
813363 | 813363 | 2020-12-10 | Elmore | Alabama | 1051 | 4803 | 72 |
810119 | 810119 | 2020-12-09 | Elmore | Alabama | 1051 | 4690 | 70 |
806874 | 806874 | 2020-12-08 | Elmore | Alabama | 1051 | 4618 | 70 |
803629 | 803629 | 2020-12-07 | Elmore | Alabama | 1051 | 4511 | 70 |
800384 | 800384 | 2020-12-06 | Elmore | Alabama | 1051 | 4482 | 70 |
797139 | 797139 | 2020-12-05 | Elmore | Alabama | 1051 | 4446 | 70 |
793894 | 793894 | 2020-12-04 | Elmore | Alabama | 1051 | 4400 | 70 |
790649 | 790649 | 2020-12-03 | Elmore | Alabama | 1051 | 4325 | 67 |
787404 | 787404 | 2020-12-02 | Elmore | Alabama | 1051 | 4275 | 64 |
784160 | 784160 | 2020-12-01 | Elmore | Alabama | 1051 | 4211 | 64 |
780915 | 780915 | 2020-11-30 | Elmore | Alabama | 1051 | 4129 | 64 |
777669 | 777669 | 2020-11-29 | Elmore | Alabama | 1051 | 4094 | 64 |
774424 | 774424 | 2020-11-28 | Elmore | Alabama | 1051 | 4068 | 64 |
771179 | 771179 | 2020-11-27 | Elmore | Alabama | 1051 | 4045 | 64 |
767933 | 767933 | 2020-11-26 | Elmore | Alabama | 1051 | 4037 | 64 |
764688 | 764688 | 2020-11-25 | Elmore | Alabama | 1051 | 4007 | 62 |
761443 | 761443 | 2020-11-24 | Elmore | Alabama | 1051 | 3989 | 61 |
758198 | 758198 | 2020-11-23 | Elmore | Alabama | 1051 | 3939 | 61 |
754951 | 754951 | 2020-11-22 | Elmore | Alabama | 1051 | 3910 | 61 |
751705 | 751705 | 2020-11-21 | Elmore | Alabama | 1051 | 3885 | 61 |
748459 | 748459 | 2020-11-20 | Elmore | Alabama | 1051 | 3820 | 61 |
745213 | 745213 | 2020-11-19 | Elmore | Alabama | 1051 | 3797 | 61 |
741966 | 741966 | 2020-11-18 | Elmore | Alabama | 1051 | 3759 | 61 |
738719 | 738719 | 2020-11-17 | Elmore | Alabama | 1051 | 3720 | 61 |
735475 | 735475 | 2020-11-16 | Elmore | Alabama | 1051 | 3686 | 61 |
732229 | 732229 | 2020-11-15 | Elmore | Alabama | 1051 | 3648 | 61 |
728984 | 728984 | 2020-11-14 | Elmore | Alabama | 1051 | 3624 | 61 |
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);