ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 1047 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1076248 | 1076248 | 2021-03-01 | Dallas | Alabama | 1047 | 3403 | 141 |
1073002 | 1073002 | 2021-02-28 | Dallas | Alabama | 1047 | 3403 | 141 |
1069756 | 1069756 | 2021-02-27 | Dallas | Alabama | 1047 | 3401 | 141 |
1066511 | 1066511 | 2021-02-26 | Dallas | Alabama | 1047 | 3397 | 141 |
1063266 | 1063266 | 2021-02-25 | Dallas | Alabama | 1047 | 3397 | 141 |
1060021 | 1060021 | 2021-02-24 | Dallas | Alabama | 1047 | 3396 | 140 |
1056775 | 1056775 | 2021-02-23 | Dallas | Alabama | 1047 | 3385 | 139 |
1053529 | 1053529 | 2021-02-22 | Dallas | Alabama | 1047 | 3332 | 138 |
1050282 | 1050282 | 2021-02-21 | Dallas | Alabama | 1047 | 3331 | 138 |
1047035 | 1047035 | 2021-02-20 | Dallas | Alabama | 1047 | 3328 | 138 |
1043790 | 1043790 | 2021-02-19 | Dallas | Alabama | 1047 | 3328 | 138 |
1040545 | 1040545 | 2021-02-18 | Dallas | Alabama | 1047 | 3328 | 134 |
1037300 | 1037300 | 2021-02-17 | Dallas | Alabama | 1047 | 3307 | 133 |
1034055 | 1034055 | 2021-02-16 | Dallas | Alabama | 1047 | 3299 | 130 |
1030809 | 1030809 | 2021-02-15 | Dallas | Alabama | 1047 | 3285 | 130 |
1027562 | 1027562 | 2021-02-14 | Dallas | Alabama | 1047 | 3282 | 130 |
1024317 | 1024317 | 2021-02-13 | Dallas | Alabama | 1047 | 3278 | 130 |
1021072 | 1021072 | 2021-02-12 | Dallas | Alabama | 1047 | 3274 | 130 |
1017827 | 1017827 | 2021-02-11 | Dallas | Alabama | 1047 | 3269 | 126 |
1014582 | 1014582 | 2021-02-10 | Dallas | Alabama | 1047 | 3270 | 125 |
1011337 | 1011337 | 2021-02-09 | Dallas | Alabama | 1047 | 3266 | 123 |
1008091 | 1008091 | 2021-02-08 | Dallas | Alabama | 1047 | 3265 | 122 |
1004845 | 1004845 | 2021-02-07 | Dallas | Alabama | 1047 | 3268 | 122 |
1001599 | 1001599 | 2021-02-06 | Dallas | Alabama | 1047 | 3268 | 122 |
998353 | 998353 | 2021-02-05 | Dallas | Alabama | 1047 | 3263 | 122 |
995107 | 995107 | 2021-02-04 | Dallas | Alabama | 1047 | 3258 | 120 |
991861 | 991861 | 2021-02-03 | Dallas | Alabama | 1047 | 3253 | 120 |
988615 | 988615 | 2021-02-02 | Dallas | Alabama | 1047 | 3242 | 114 |
985368 | 985368 | 2021-02-01 | Dallas | Alabama | 1047 | 3228 | 111 |
982121 | 982121 | 2021-01-31 | Dallas | Alabama | 1047 | 3224 | 111 |
978875 | 978875 | 2021-01-30 | Dallas | Alabama | 1047 | 3195 | 111 |
975630 | 975630 | 2021-01-29 | Dallas | Alabama | 1047 | 3195 | 111 |
972385 | 972385 | 2021-01-28 | Dallas | Alabama | 1047 | 3181 | 108 |
969140 | 969140 | 2021-01-27 | Dallas | Alabama | 1047 | 3164 | 105 |
965896 | 965896 | 2021-01-26 | Dallas | Alabama | 1047 | 3141 | 97 |
962651 | 962651 | 2021-01-25 | Dallas | Alabama | 1047 | 3136 | 96 |
959406 | 959406 | 2021-01-24 | Dallas | Alabama | 1047 | 3132 | 96 |
956160 | 956160 | 2021-01-23 | Dallas | Alabama | 1047 | 3129 | 96 |
952915 | 952915 | 2021-01-22 | Dallas | Alabama | 1047 | 3120 | 96 |
949670 | 949670 | 2021-01-21 | Dallas | Alabama | 1047 | 3101 | 96 |
946424 | 946424 | 2021-01-20 | Dallas | Alabama | 1047 | 3088 | 96 |
943177 | 943177 | 2021-01-19 | Dallas | Alabama | 1047 | 3051 | 96 |
939932 | 939932 | 2021-01-18 | Dallas | Alabama | 1047 | 3033 | 96 |
936687 | 936687 | 2021-01-17 | Dallas | Alabama | 1047 | 3031 | 96 |
933442 | 933442 | 2021-01-16 | Dallas | Alabama | 1047 | 3028 | 96 |
930197 | 930197 | 2021-01-15 | Dallas | Alabama | 1047 | 3002 | 96 |
926952 | 926952 | 2021-01-14 | Dallas | Alabama | 1047 | 2979 | 88 |
923706 | 923706 | 2021-01-13 | Dallas | Alabama | 1047 | 2957 | 69 |
920461 | 920461 | 2021-01-12 | Dallas | Alabama | 1047 | 2959 | 69 |
917216 | 917216 | 2021-01-11 | Dallas | Alabama | 1047 | 2929 | 45 |
913971 | 913971 | 2021-01-10 | Dallas | Alabama | 1047 | 2923 | 44 |
910726 | 910726 | 2021-01-09 | Dallas | Alabama | 1047 | 2916 | 44 |
907481 | 907481 | 2021-01-08 | Dallas | Alabama | 1047 | 2908 | 45 |
904235 | 904235 | 2021-01-07 | Dallas | Alabama | 1047 | 2898 | 45 |
900990 | 900990 | 2021-01-06 | Dallas | Alabama | 1047 | 2883 | 44 |
897745 | 897745 | 2021-01-05 | Dallas | Alabama | 1047 | 2867 | 44 |
894499 | 894499 | 2021-01-04 | Dallas | Alabama | 1047 | 2844 | 43 |
891253 | 891253 | 2021-01-03 | Dallas | Alabama | 1047 | 2837 | 43 |
888006 | 888006 | 2021-01-02 | Dallas | Alabama | 1047 | 2827 | 43 |
884761 | 884761 | 2021-01-01 | Dallas | Alabama | 1047 | 2821 | 43 |
881516 | 881516 | 2020-12-31 | Dallas | Alabama | 1047 | 2769 | 43 |
878271 | 878271 | 2020-12-30 | Dallas | Alabama | 1047 | 2744 | 39 |
875026 | 875026 | 2020-12-29 | Dallas | Alabama | 1047 | 2726 | 39 |
871781 | 871781 | 2020-12-28 | Dallas | Alabama | 1047 | 2689 | 39 |
868536 | 868536 | 2020-12-27 | Dallas | Alabama | 1047 | 2689 | 39 |
865291 | 865291 | 2020-12-26 | Dallas | Alabama | 1047 | 2685 | 39 |
862046 | 862046 | 2020-12-25 | Dallas | Alabama | 1047 | 2690 | 39 |
858801 | 858801 | 2020-12-24 | Dallas | Alabama | 1047 | 2669 | 39 |
855556 | 855556 | 2020-12-23 | Dallas | Alabama | 1047 | 2649 | 38 |
852311 | 852311 | 2020-12-22 | Dallas | Alabama | 1047 | 2629 | 36 |
849066 | 849066 | 2020-12-21 | Dallas | Alabama | 1047 | 2605 | 36 |
845821 | 845821 | 2020-12-20 | Dallas | Alabama | 1047 | 2601 | 36 |
842575 | 842575 | 2020-12-19 | Dallas | Alabama | 1047 | 2594 | 36 |
839330 | 839330 | 2020-12-18 | Dallas | Alabama | 1047 | 2577 | 36 |
836085 | 836085 | 2020-12-17 | Dallas | Alabama | 1047 | 2555 | 36 |
832839 | 832839 | 2020-12-16 | Dallas | Alabama | 1047 | 2535 | 34 |
829592 | 829592 | 2020-12-15 | Dallas | Alabama | 1047 | 2517 | 34 |
826346 | 826346 | 2020-12-14 | Dallas | Alabama | 1047 | 2492 | 34 |
823099 | 823099 | 2020-12-13 | Dallas | Alabama | 1047 | 2490 | 34 |
819853 | 819853 | 2020-12-12 | Dallas | Alabama | 1047 | 2487 | 34 |
816607 | 816607 | 2020-12-11 | Dallas | Alabama | 1047 | 2481 | 34 |
813361 | 813361 | 2020-12-10 | Dallas | Alabama | 1047 | 2467 | 34 |
810117 | 810117 | 2020-12-09 | Dallas | Alabama | 1047 | 2429 | 34 |
806872 | 806872 | 2020-12-08 | Dallas | Alabama | 1047 | 2424 | 34 |
803627 | 803627 | 2020-12-07 | Dallas | Alabama | 1047 | 2385 | 33 |
800382 | 800382 | 2020-12-06 | Dallas | Alabama | 1047 | 2384 | 33 |
797137 | 797137 | 2020-12-05 | Dallas | Alabama | 1047 | 2378 | 33 |
793892 | 793892 | 2020-12-04 | Dallas | Alabama | 1047 | 2368 | 32 |
790647 | 790647 | 2020-12-03 | Dallas | Alabama | 1047 | 2349 | 32 |
787402 | 787402 | 2020-12-02 | Dallas | Alabama | 1047 | 2329 | 32 |
784158 | 784158 | 2020-12-01 | Dallas | Alabama | 1047 | 2315 | 32 |
780913 | 780913 | 2020-11-30 | Dallas | Alabama | 1047 | 2268 | 32 |
777667 | 777667 | 2020-11-29 | Dallas | Alabama | 1047 | 2265 | 32 |
774422 | 774422 | 2020-11-28 | Dallas | Alabama | 1047 | 2262 | 32 |
771177 | 771177 | 2020-11-27 | Dallas | Alabama | 1047 | 2259 | 32 |
767931 | 767931 | 2020-11-26 | Dallas | Alabama | 1047 | 2252 | 32 |
764686 | 764686 | 2020-11-25 | Dallas | Alabama | 1047 | 2245 | 31 |
761441 | 761441 | 2020-11-24 | Dallas | Alabama | 1047 | 2223 | 31 |
758196 | 758196 | 2020-11-23 | Dallas | Alabama | 1047 | 2202 | 31 |
754949 | 754949 | 2020-11-22 | Dallas | Alabama | 1047 | 2196 | 31 |
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);