ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 1017 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1076233 | 1076233 | 2021-03-01 | Chambers | Alabama | 1017 | 3413 | 110 |
1072987 | 1072987 | 2021-02-28 | Chambers | Alabama | 1017 | 3410 | 110 |
1069741 | 1069741 | 2021-02-27 | Chambers | Alabama | 1017 | 3406 | 110 |
1066496 | 1066496 | 2021-02-26 | Chambers | Alabama | 1017 | 3399 | 108 |
1063251 | 1063251 | 2021-02-25 | Chambers | Alabama | 1017 | 3392 | 108 |
1060006 | 1060006 | 2021-02-24 | Chambers | Alabama | 1017 | 3393 | 103 |
1056760 | 1056760 | 2021-02-23 | Chambers | Alabama | 1017 | 3382 | 102 |
1053514 | 1053514 | 2021-02-22 | Chambers | Alabama | 1017 | 3367 | 99 |
1050267 | 1050267 | 2021-02-21 | Chambers | Alabama | 1017 | 3367 | 99 |
1047020 | 1047020 | 2021-02-20 | Chambers | Alabama | 1017 | 3364 | 99 |
1043775 | 1043775 | 2021-02-19 | Chambers | Alabama | 1017 | 3358 | 99 |
1040530 | 1040530 | 2021-02-18 | Chambers | Alabama | 1017 | 3348 | 98 |
1037285 | 1037285 | 2021-02-17 | Chambers | Alabama | 1017 | 3338 | 98 |
1034040 | 1034040 | 2021-02-16 | Chambers | Alabama | 1017 | 3336 | 94 |
1030794 | 1030794 | 2021-02-15 | Chambers | Alabama | 1017 | 3325 | 94 |
1027547 | 1027547 | 2021-02-14 | Chambers | Alabama | 1017 | 3321 | 94 |
1024302 | 1024302 | 2021-02-13 | Chambers | Alabama | 1017 | 3318 | 94 |
1021057 | 1021057 | 2021-02-12 | Chambers | Alabama | 1017 | 3313 | 94 |
1017812 | 1017812 | 2021-02-11 | Chambers | Alabama | 1017 | 3305 | 92 |
1014567 | 1014567 | 2021-02-10 | Chambers | Alabama | 1017 | 3291 | 89 |
1011322 | 1011322 | 2021-02-09 | Chambers | Alabama | 1017 | 3283 | 84 |
1008076 | 1008076 | 2021-02-08 | Chambers | Alabama | 1017 | 3266 | 81 |
1004830 | 1004830 | 2021-02-07 | Chambers | Alabama | 1017 | 3263 | 81 |
1001584 | 1001584 | 2021-02-06 | Chambers | Alabama | 1017 | 3259 | 81 |
998338 | 998338 | 2021-02-05 | Chambers | Alabama | 1017 | 3249 | 81 |
995092 | 995092 | 2021-02-04 | Chambers | Alabama | 1017 | 3239 | 81 |
991846 | 991846 | 2021-02-03 | Chambers | Alabama | 1017 | 3233 | 80 |
988600 | 988600 | 2021-02-02 | Chambers | Alabama | 1017 | 3219 | 78 |
985353 | 985353 | 2021-02-01 | Chambers | Alabama | 1017 | 3210 | 76 |
982106 | 982106 | 2021-01-31 | Chambers | Alabama | 1017 | 3203 | 76 |
978860 | 978860 | 2021-01-30 | Chambers | Alabama | 1017 | 3174 | 76 |
975615 | 975615 | 2021-01-29 | Chambers | Alabama | 1017 | 3174 | 76 |
972370 | 972370 | 2021-01-28 | Chambers | Alabama | 1017 | 3159 | 76 |
969125 | 969125 | 2021-01-27 | Chambers | Alabama | 1017 | 3137 | 75 |
965881 | 965881 | 2021-01-26 | Chambers | Alabama | 1017 | 3085 | 75 |
962636 | 962636 | 2021-01-25 | Chambers | Alabama | 1017 | 3054 | 70 |
959391 | 959391 | 2021-01-24 | Chambers | Alabama | 1017 | 3042 | 70 |
956145 | 956145 | 2021-01-23 | Chambers | Alabama | 1017 | 3034 | 70 |
952900 | 952900 | 2021-01-22 | Chambers | Alabama | 1017 | 3011 | 70 |
949655 | 949655 | 2021-01-21 | Chambers | Alabama | 1017 | 2973 | 70 |
946409 | 946409 | 2021-01-20 | Chambers | Alabama | 1017 | 2931 | 70 |
943162 | 943162 | 2021-01-19 | Chambers | Alabama | 1017 | 2886 | 69 |
939917 | 939917 | 2021-01-18 | Chambers | Alabama | 1017 | 2842 | 69 |
936672 | 936672 | 2021-01-17 | Chambers | Alabama | 1017 | 2827 | 69 |
933427 | 933427 | 2021-01-16 | Chambers | Alabama | 1017 | 2818 | 69 |
930182 | 930182 | 2021-01-15 | Chambers | Alabama | 1017 | 2778 | 69 |
926937 | 926937 | 2021-01-14 | Chambers | Alabama | 1017 | 2757 | 69 |
923691 | 923691 | 2021-01-13 | Chambers | Alabama | 1017 | 2734 | 66 |
920446 | 920446 | 2021-01-12 | Chambers | Alabama | 1017 | 2697 | 66 |
917201 | 917201 | 2021-01-11 | Chambers | Alabama | 1017 | 2651 | 66 |
913956 | 913956 | 2021-01-10 | Chambers | Alabama | 1017 | 2639 | 66 |
910711 | 910711 | 2021-01-09 | Chambers | Alabama | 1017 | 2620 | 63 |
907466 | 907466 | 2021-01-08 | Chambers | Alabama | 1017 | 2592 | 63 |
904220 | 904220 | 2021-01-07 | Chambers | Alabama | 1017 | 2552 | 63 |
900975 | 900975 | 2021-01-06 | Chambers | Alabama | 1017 | 2519 | 63 |
897730 | 897730 | 2021-01-05 | Chambers | Alabama | 1017 | 2474 | 63 |
894484 | 894484 | 2021-01-04 | Chambers | Alabama | 1017 | 2415 | 63 |
891238 | 891238 | 2021-01-03 | Chambers | Alabama | 1017 | 2402 | 63 |
887991 | 887991 | 2021-01-02 | Chambers | Alabama | 1017 | 2386 | 63 |
884746 | 884746 | 2021-01-01 | Chambers | Alabama | 1017 | 2366 | 63 |
881501 | 881501 | 2020-12-31 | Chambers | Alabama | 1017 | 2341 | 63 |
878256 | 878256 | 2020-12-30 | Chambers | Alabama | 1017 | 2310 | 62 |
875011 | 875011 | 2020-12-29 | Chambers | Alabama | 1017 | 2275 | 61 |
871766 | 871766 | 2020-12-28 | Chambers | Alabama | 1017 | 2229 | 61 |
868521 | 868521 | 2020-12-27 | Chambers | Alabama | 1017 | 2214 | 61 |
865276 | 865276 | 2020-12-26 | Chambers | Alabama | 1017 | 2203 | 61 |
862031 | 862031 | 2020-12-25 | Chambers | Alabama | 1017 | 2200 | 61 |
858786 | 858786 | 2020-12-24 | Chambers | Alabama | 1017 | 2191 | 61 |
855541 | 855541 | 2020-12-23 | Chambers | Alabama | 1017 | 2176 | 61 |
852296 | 852296 | 2020-12-22 | Chambers | Alabama | 1017 | 2161 | 61 |
849051 | 849051 | 2020-12-21 | Chambers | Alabama | 1017 | 2133 | 60 |
845806 | 845806 | 2020-12-20 | Chambers | Alabama | 1017 | 2125 | 60 |
842560 | 842560 | 2020-12-19 | Chambers | Alabama | 1017 | 2116 | 60 |
839315 | 839315 | 2020-12-18 | Chambers | Alabama | 1017 | 2090 | 58 |
836070 | 836070 | 2020-12-17 | Chambers | Alabama | 1017 | 2076 | 58 |
832824 | 832824 | 2020-12-16 | Chambers | Alabama | 1017 | 2064 | 57 |
829577 | 829577 | 2020-12-15 | Chambers | Alabama | 1017 | 2040 | 57 |
826331 | 826331 | 2020-12-14 | Chambers | Alabama | 1017 | 2022 | 57 |
823084 | 823084 | 2020-12-13 | Chambers | Alabama | 1017 | 2013 | 57 |
819838 | 819838 | 2020-12-12 | Chambers | Alabama | 1017 | 1997 | 57 |
816592 | 816592 | 2020-12-11 | Chambers | Alabama | 1017 | 1982 | 55 |
813346 | 813346 | 2020-12-10 | Chambers | Alabama | 1017 | 1977 | 55 |
810102 | 810102 | 2020-12-09 | Chambers | Alabama | 1017 | 1961 | 55 |
806857 | 806857 | 2020-12-08 | Chambers | Alabama | 1017 | 1945 | 54 |
803612 | 803612 | 2020-12-07 | Chambers | Alabama | 1017 | 1915 | 54 |
800367 | 800367 | 2020-12-06 | Chambers | Alabama | 1017 | 1906 | 54 |
797122 | 797122 | 2020-12-05 | Chambers | Alabama | 1017 | 1901 | 54 |
793877 | 793877 | 2020-12-04 | Chambers | Alabama | 1017 | 1891 | 54 |
790632 | 790632 | 2020-12-03 | Chambers | Alabama | 1017 | 1875 | 51 |
787387 | 787387 | 2020-12-02 | Chambers | Alabama | 1017 | 1859 | 50 |
784143 | 784143 | 2020-12-01 | Chambers | Alabama | 1017 | 1827 | 50 |
780898 | 780898 | 2020-11-30 | Chambers | Alabama | 1017 | 1779 | 50 |
777652 | 777652 | 2020-11-29 | Chambers | Alabama | 1017 | 1772 | 50 |
774407 | 774407 | 2020-11-28 | Chambers | Alabama | 1017 | 1768 | 50 |
771162 | 771162 | 2020-11-27 | Chambers | Alabama | 1017 | 1765 | 50 |
767916 | 767916 | 2020-11-26 | Chambers | Alabama | 1017 | 1764 | 50 |
764671 | 764671 | 2020-11-25 | Chambers | Alabama | 1017 | 1737 | 49 |
761426 | 761426 | 2020-11-24 | Chambers | Alabama | 1017 | 1714 | 48 |
758181 | 758181 | 2020-11-23 | Chambers | Alabama | 1017 | 1680 | 48 |
754934 | 754934 | 2020-11-22 | Chambers | Alabama | 1017 | 1675 | 48 |
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);