ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Chilton" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1050269 | 1050269 | 2021-02-21 | Chilton | Alabama | 1021 | 3785 | 93 |
1047022 | 1047022 | 2021-02-20 | Chilton | Alabama | 1021 | 3777 | 93 |
1043777 | 1043777 | 2021-02-19 | Chilton | Alabama | 1021 | 3772 | 93 |
1040532 | 1040532 | 2021-02-18 | Chilton | Alabama | 1021 | 3760 | 92 |
1037287 | 1037287 | 2021-02-17 | Chilton | Alabama | 1021 | 3750 | 92 |
1034042 | 1034042 | 2021-02-16 | Chilton | Alabama | 1021 | 3745 | 90 |
1030796 | 1030796 | 2021-02-15 | Chilton | Alabama | 1021 | 3739 | 90 |
1027549 | 1027549 | 2021-02-14 | Chilton | Alabama | 1021 | 3731 | 90 |
1024304 | 1024304 | 2021-02-13 | Chilton | Alabama | 1021 | 3718 | 90 |
1021059 | 1021059 | 2021-02-12 | Chilton | Alabama | 1021 | 3694 | 90 |
1017814 | 1017814 | 2021-02-11 | Chilton | Alabama | 1021 | 3672 | 87 |
1014569 | 1014569 | 2021-02-10 | Chilton | Alabama | 1021 | 3643 | 86 |
1011324 | 1011324 | 2021-02-09 | Chilton | Alabama | 1021 | 3629 | 83 |
1008078 | 1008078 | 2021-02-08 | Chilton | Alabama | 1021 | 3622 | 82 |
1004832 | 1004832 | 2021-02-07 | Chilton | Alabama | 1021 | 3615 | 82 |
1001586 | 1001586 | 2021-02-06 | Chilton | Alabama | 1021 | 3609 | 82 |
998340 | 998340 | 2021-02-05 | Chilton | Alabama | 1021 | 3588 | 82 |
995094 | 995094 | 2021-02-04 | Chilton | Alabama | 1021 | 3579 | 82 |
991848 | 991848 | 2021-02-03 | Chilton | Alabama | 1021 | 3568 | 81 |
988602 | 988602 | 2021-02-02 | Chilton | Alabama | 1021 | 3561 | 79 |
985355 | 985355 | 2021-02-01 | Chilton | Alabama | 1021 | 3553 | 79 |
982108 | 982108 | 2021-01-31 | Chilton | Alabama | 1021 | 3544 | 79 |
978862 | 978862 | 2021-01-30 | Chilton | Alabama | 1021 | 3531 | 79 |
975617 | 975617 | 2021-01-29 | Chilton | Alabama | 1021 | 3531 | 79 |
972372 | 972372 | 2021-01-28 | Chilton | Alabama | 1021 | 3523 | 79 |
969127 | 969127 | 2021-01-27 | Chilton | Alabama | 1021 | 3513 | 79 |
965883 | 965883 | 2021-01-26 | Chilton | Alabama | 1021 | 3480 | 79 |
962638 | 962638 | 2021-01-25 | Chilton | Alabama | 1021 | 3468 | 73 |
959393 | 959393 | 2021-01-24 | Chilton | Alabama | 1021 | 3454 | 73 |
956147 | 956147 | 2021-01-23 | Chilton | Alabama | 1021 | 3443 | 73 |
952902 | 952902 | 2021-01-22 | Chilton | Alabama | 1021 | 3428 | 73 |
949657 | 949657 | 2021-01-21 | Chilton | Alabama | 1021 | 3409 | 72 |
946411 | 946411 | 2021-01-20 | Chilton | Alabama | 1021 | 3389 | 66 |
943164 | 943164 | 2021-01-19 | Chilton | Alabama | 1021 | 3378 | 65 |
939919 | 939919 | 2021-01-18 | Chilton | Alabama | 1021 | 3376 | 65 |
936674 | 936674 | 2021-01-17 | Chilton | Alabama | 1021 | 3361 | 65 |
933429 | 933429 | 2021-01-16 | Chilton | Alabama | 1021 | 3353 | 65 |
930184 | 930184 | 2021-01-15 | Chilton | Alabama | 1021 | 3335 | 65 |
926939 | 926939 | 2021-01-14 | Chilton | Alabama | 1021 | 3329 | 65 |
923693 | 923693 | 2021-01-13 | Chilton | Alabama | 1021 | 3315 | 64 |
920448 | 920448 | 2021-01-12 | Chilton | Alabama | 1021 | 3300 | 60 |
917203 | 917203 | 2021-01-11 | Chilton | Alabama | 1021 | 3277 | 54 |
913958 | 913958 | 2021-01-10 | Chilton | Alabama | 1021 | 3253 | 54 |
910713 | 910713 | 2021-01-09 | Chilton | Alabama | 1021 | 3237 | 54 |
907468 | 907468 | 2021-01-08 | Chilton | Alabama | 1021 | 3218 | 54 |
904222 | 904222 | 2021-01-07 | Chilton | Alabama | 1021 | 3159 | 54 |
900977 | 900977 | 2021-01-06 | Chilton | Alabama | 1021 | 3127 | 54 |
897732 | 897732 | 2021-01-05 | Chilton | Alabama | 1021 | 3085 | 54 |
894486 | 894486 | 2021-01-04 | Chilton | Alabama | 1021 | 3054 | 54 |
891240 | 891240 | 2021-01-03 | Chilton | Alabama | 1021 | 3032 | 54 |
887993 | 887993 | 2021-01-02 | Chilton | Alabama | 1021 | 3019 | 54 |
884748 | 884748 | 2021-01-01 | Chilton | Alabama | 1021 | 3004 | 54 |
881503 | 881503 | 2020-12-31 | Chilton | Alabama | 1021 | 2970 | 54 |
878258 | 878258 | 2020-12-30 | Chilton | Alabama | 1021 | 2913 | 54 |
875013 | 875013 | 2020-12-29 | Chilton | Alabama | 1021 | 2865 | 54 |
871768 | 871768 | 2020-12-28 | Chilton | Alabama | 1021 | 2845 | 54 |
868523 | 868523 | 2020-12-27 | Chilton | Alabama | 1021 | 2822 | 54 |
865278 | 865278 | 2020-12-26 | Chilton | Alabama | 1021 | 2812 | 54 |
862033 | 862033 | 2020-12-25 | Chilton | Alabama | 1021 | 2801 | 54 |
858788 | 858788 | 2020-12-24 | Chilton | Alabama | 1021 | 2790 | 53 |
855543 | 855543 | 2020-12-23 | Chilton | Alabama | 1021 | 2773 | 51 |
852298 | 852298 | 2020-12-22 | Chilton | Alabama | 1021 | 2743 | 50 |
849053 | 849053 | 2020-12-21 | Chilton | Alabama | 1021 | 2719 | 49 |
845808 | 845808 | 2020-12-20 | Chilton | Alabama | 1021 | 2696 | 49 |
842562 | 842562 | 2020-12-19 | Chilton | Alabama | 1021 | 2676 | 49 |
839317 | 839317 | 2020-12-18 | Chilton | Alabama | 1021 | 2649 | 47 |
836072 | 836072 | 2020-12-17 | Chilton | Alabama | 1021 | 2631 | 47 |
832826 | 832826 | 2020-12-16 | Chilton | Alabama | 1021 | 2604 | 46 |
829579 | 829579 | 2020-12-15 | Chilton | Alabama | 1021 | 2585 | 46 |
826333 | 826333 | 2020-12-14 | Chilton | Alabama | 1021 | 2553 | 46 |
823086 | 823086 | 2020-12-13 | Chilton | Alabama | 1021 | 2547 | 46 |
819840 | 819840 | 2020-12-12 | Chilton | Alabama | 1021 | 2527 | 46 |
816594 | 816594 | 2020-12-11 | Chilton | Alabama | 1021 | 2514 | 47 |
813348 | 813348 | 2020-12-10 | Chilton | Alabama | 1021 | 2507 | 47 |
810104 | 810104 | 2020-12-09 | Chilton | Alabama | 1021 | 2457 | 47 |
806859 | 806859 | 2020-12-08 | Chilton | Alabama | 1021 | 2441 | 46 |
803614 | 803614 | 2020-12-07 | Chilton | Alabama | 1021 | 2409 | 45 |
800369 | 800369 | 2020-12-06 | Chilton | Alabama | 1021 | 2391 | 45 |
797124 | 797124 | 2020-12-05 | Chilton | Alabama | 1021 | 2372 | 45 |
793879 | 793879 | 2020-12-04 | Chilton | Alabama | 1021 | 2354 | 45 |
790634 | 790634 | 2020-12-03 | Chilton | Alabama | 1021 | 2336 | 41 |
787389 | 787389 | 2020-12-02 | Chilton | Alabama | 1021 | 2308 | 41 |
784145 | 784145 | 2020-12-01 | Chilton | Alabama | 1021 | 2289 | 39 |
780900 | 780900 | 2020-11-30 | Chilton | Alabama | 1021 | 2274 | 38 |
777654 | 777654 | 2020-11-29 | Chilton | Alabama | 1021 | 2250 | 38 |
774409 | 774409 | 2020-11-28 | Chilton | Alabama | 1021 | 2234 | 38 |
771164 | 771164 | 2020-11-27 | Chilton | Alabama | 1021 | 2219 | 38 |
767918 | 767918 | 2020-11-26 | Chilton | Alabama | 1021 | 2206 | 38 |
764673 | 764673 | 2020-11-25 | Chilton | Alabama | 1021 | 2196 | 38 |
761428 | 761428 | 2020-11-24 | Chilton | Alabama | 1021 | 2185 | 37 |
758183 | 758183 | 2020-11-23 | Chilton | Alabama | 1021 | 2169 | 37 |
754936 | 754936 | 2020-11-22 | Chilton | Alabama | 1021 | 2161 | 37 |
751690 | 751690 | 2020-11-21 | Chilton | Alabama | 1021 | 2144 | 37 |
748444 | 748444 | 2020-11-20 | Chilton | Alabama | 1021 | 2125 | 36 |
745198 | 745198 | 2020-11-19 | Chilton | Alabama | 1021 | 2122 | 36 |
741951 | 741951 | 2020-11-18 | Chilton | Alabama | 1021 | 2104 | 36 |
738704 | 738704 | 2020-11-17 | Chilton | Alabama | 1021 | 2093 | 37 |
735460 | 735460 | 2020-11-16 | Chilton | Alabama | 1021 | 2084 | 36 |
732214 | 732214 | 2020-11-15 | Chilton | Alabama | 1021 | 2078 | 36 |
728969 | 728969 | 2020-11-14 | Chilton | Alabama | 1021 | 2068 | 36 |
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);