ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Franklin" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193138 | 1193138 | 2021-04-06 | Franklin | Alabama | 1059 | 4190 | 82 |
1189888 | 1189888 | 2021-04-05 | Franklin | Alabama | 1059 | 4189 | 82 |
1186641 | 1186641 | 2021-04-04 | Franklin | Alabama | 1059 | 4189 | 82 |
1183394 | 1183394 | 2021-04-03 | Franklin | Alabama | 1059 | 4189 | 82 |
1180147 | 1180147 | 2021-04-02 | Franklin | Alabama | 1059 | 4187 | 82 |
1176900 | 1176900 | 2021-04-01 | Franklin | Alabama | 1059 | 4186 | 82 |
1173653 | 1173653 | 2021-03-31 | Franklin | Alabama | 1059 | 4185 | 82 |
1170406 | 1170406 | 2021-03-30 | Franklin | Alabama | 1059 | 4184 | 82 |
1167158 | 1167158 | 2021-03-29 | Franklin | Alabama | 1059 | 4184 | 82 |
1163910 | 1163910 | 2021-03-28 | Franklin | Alabama | 1059 | 4184 | 82 |
1160662 | 1160662 | 2021-03-27 | Franklin | Alabama | 1059 | 4184 | 82 |
1157414 | 1157414 | 2021-03-26 | Franklin | Alabama | 1059 | 4183 | 82 |
1154167 | 1154167 | 2021-03-25 | Franklin | Alabama | 1059 | 4183 | 82 |
1150920 | 1150920 | 2021-03-24 | Franklin | Alabama | 1059 | 4181 | 82 |
1147673 | 1147673 | 2021-03-23 | Franklin | Alabama | 1059 | 4180 | 82 |
1144426 | 1144426 | 2021-03-22 | Franklin | Alabama | 1059 | 4180 | 82 |
1141179 | 1141179 | 2021-03-21 | Franklin | Alabama | 1059 | 4177 | 82 |
1137933 | 1137933 | 2021-03-20 | Franklin | Alabama | 1059 | 4176 | 82 |
1134687 | 1134687 | 2021-03-19 | Franklin | Alabama | 1059 | 4176 | 82 |
1131439 | 1131439 | 2021-03-18 | Franklin | Alabama | 1059 | 4175 | 82 |
1128192 | 1128192 | 2021-03-17 | Franklin | Alabama | 1059 | 4175 | 82 |
1124946 | 1124946 | 2021-03-16 | Franklin | Alabama | 1059 | 4172 | 82 |
1121700 | 1121700 | 2021-03-15 | Franklin | Alabama | 1059 | 4171 | 82 |
1118453 | 1118453 | 2021-03-14 | Franklin | Alabama | 1059 | 4048 | 82 |
1115206 | 1115206 | 2021-03-13 | Franklin | Alabama | 1059 | 4048 | 82 |
1111960 | 1111960 | 2021-03-12 | Franklin | Alabama | 1059 | 4048 | 82 |
1108714 | 1108714 | 2021-03-11 | Franklin | Alabama | 1059 | 4042 | 82 |
1105468 | 1105468 | 2021-03-10 | Franklin | Alabama | 1059 | 4023 | 81 |
1102222 | 1102222 | 2021-03-09 | Franklin | Alabama | 1059 | 4013 | 80 |
1098976 | 1098976 | 2021-03-08 | Franklin | Alabama | 1059 | 4009 | 79 |
1095728 | 1095728 | 2021-03-07 | Franklin | Alabama | 1059 | 4008 | 79 |
1092482 | 1092482 | 2021-03-06 | Franklin | Alabama | 1059 | 4007 | 79 |
1089236 | 1089236 | 2021-03-05 | Franklin | Alabama | 1059 | 4000 | 78 |
1085991 | 1085991 | 2021-03-04 | Franklin | Alabama | 1059 | 3998 | 78 |
1082745 | 1082745 | 2021-03-03 | Franklin | Alabama | 1059 | 3997 | 78 |
1079499 | 1079499 | 2021-03-02 | Franklin | Alabama | 1059 | 3994 | 78 |
1076254 | 1076254 | 2021-03-01 | Franklin | Alabama | 1059 | 3991 | 77 |
1073008 | 1073008 | 2021-02-28 | Franklin | Alabama | 1059 | 3991 | 77 |
1069762 | 1069762 | 2021-02-27 | Franklin | Alabama | 1059 | 3989 | 77 |
1066517 | 1066517 | 2021-02-26 | Franklin | Alabama | 1059 | 3988 | 76 |
1063272 | 1063272 | 2021-02-25 | Franklin | Alabama | 1059 | 3978 | 76 |
1060027 | 1060027 | 2021-02-24 | Franklin | Alabama | 1059 | 3976 | 75 |
1056781 | 1056781 | 2021-02-23 | Franklin | Alabama | 1059 | 3965 | 75 |
1053535 | 1053535 | 2021-02-22 | Franklin | Alabama | 1059 | 3958 | 75 |
1050288 | 1050288 | 2021-02-21 | Franklin | Alabama | 1059 | 3957 | 75 |
1047041 | 1047041 | 2021-02-20 | Franklin | Alabama | 1059 | 3954 | 75 |
1043796 | 1043796 | 2021-02-19 | Franklin | Alabama | 1059 | 3954 | 75 |
1040551 | 1040551 | 2021-02-18 | Franklin | Alabama | 1059 | 3952 | 75 |
1037306 | 1037306 | 2021-02-17 | Franklin | Alabama | 1059 | 3949 | 75 |
1034061 | 1034061 | 2021-02-16 | Franklin | Alabama | 1059 | 3949 | 75 |
1030815 | 1030815 | 2021-02-15 | Franklin | Alabama | 1059 | 3947 | 75 |
1027568 | 1027568 | 2021-02-14 | Franklin | Alabama | 1059 | 3947 | 75 |
1024323 | 1024323 | 2021-02-13 | Franklin | Alabama | 1059 | 3945 | 75 |
1021078 | 1021078 | 2021-02-12 | Franklin | Alabama | 1059 | 3941 | 75 |
1017833 | 1017833 | 2021-02-11 | Franklin | Alabama | 1059 | 3937 | 74 |
1014588 | 1014588 | 2021-02-10 | Franklin | Alabama | 1059 | 3929 | 74 |
1011343 | 1011343 | 2021-02-09 | Franklin | Alabama | 1059 | 3923 | 69 |
1008097 | 1008097 | 2021-02-08 | Franklin | Alabama | 1059 | 3914 | 68 |
1004851 | 1004851 | 2021-02-07 | Franklin | Alabama | 1059 | 3910 | 68 |
1001605 | 1001605 | 2021-02-06 | Franklin | Alabama | 1059 | 3903 | 68 |
998359 | 998359 | 2021-02-05 | Franklin | Alabama | 1059 | 3889 | 68 |
995113 | 995113 | 2021-02-04 | Franklin | Alabama | 1059 | 3883 | 67 |
991867 | 991867 | 2021-02-03 | Franklin | Alabama | 1059 | 3863 | 65 |
988621 | 988621 | 2021-02-02 | Franklin | Alabama | 1059 | 3853 | 60 |
985374 | 985374 | 2021-02-01 | Franklin | Alabama | 1059 | 3846 | 60 |
982127 | 982127 | 2021-01-31 | Franklin | Alabama | 1059 | 3842 | 60 |
978881 | 978881 | 2021-01-30 | Franklin | Alabama | 1059 | 3832 | 55 |
975636 | 975636 | 2021-01-29 | Franklin | Alabama | 1059 | 3832 | 55 |
972391 | 972391 | 2021-01-28 | Franklin | Alabama | 1059 | 3829 | 55 |
969146 | 969146 | 2021-01-27 | Franklin | Alabama | 1059 | 3801 | 53 |
965902 | 965902 | 2021-01-26 | Franklin | Alabama | 1059 | 3781 | 50 |
962657 | 962657 | 2021-01-25 | Franklin | Alabama | 1059 | 3775 | 50 |
959412 | 959412 | 2021-01-24 | Franklin | Alabama | 1059 | 3749 | 50 |
956166 | 956166 | 2021-01-23 | Franklin | Alabama | 1059 | 3741 | 50 |
952921 | 952921 | 2021-01-22 | Franklin | Alabama | 1059 | 3724 | 48 |
949676 | 949676 | 2021-01-21 | Franklin | Alabama | 1059 | 3719 | 48 |
946430 | 946430 | 2021-01-20 | Franklin | Alabama | 1059 | 3699 | 48 |
943183 | 943183 | 2021-01-19 | Franklin | Alabama | 1059 | 3681 | 48 |
939938 | 939938 | 2021-01-18 | Franklin | Alabama | 1059 | 3675 | 48 |
936693 | 936693 | 2021-01-17 | Franklin | Alabama | 1059 | 3662 | 48 |
933448 | 933448 | 2021-01-16 | Franklin | Alabama | 1059 | 3652 | 48 |
930203 | 930203 | 2021-01-15 | Franklin | Alabama | 1059 | 3634 | 45 |
926958 | 926958 | 2021-01-14 | Franklin | Alabama | 1059 | 3621 | 45 |
923712 | 923712 | 2021-01-13 | Franklin | Alabama | 1059 | 3597 | 42 |
920467 | 920467 | 2021-01-12 | Franklin | Alabama | 1059 | 3571 | 42 |
917222 | 917222 | 2021-01-11 | Franklin | Alabama | 1059 | 3552 | 39 |
913977 | 913977 | 2021-01-10 | Franklin | Alabama | 1059 | 3530 | 39 |
910732 | 910732 | 2021-01-09 | Franklin | Alabama | 1059 | 3514 | 39 |
907487 | 907487 | 2021-01-08 | Franklin | Alabama | 1059 | 3462 | 39 |
904241 | 904241 | 2021-01-07 | Franklin | Alabama | 1059 | 3418 | 39 |
900996 | 900996 | 2021-01-06 | Franklin | Alabama | 1059 | 3383 | 39 |
897751 | 897751 | 2021-01-05 | Franklin | Alabama | 1059 | 3355 | 38 |
894505 | 894505 | 2021-01-04 | Franklin | Alabama | 1059 | 3340 | 38 |
891259 | 891259 | 2021-01-03 | Franklin | Alabama | 1059 | 3336 | 38 |
888012 | 888012 | 2021-01-02 | Franklin | Alabama | 1059 | 3317 | 37 |
884767 | 884767 | 2021-01-01 | Franklin | Alabama | 1059 | 3300 | 37 |
881522 | 881522 | 2020-12-31 | Franklin | Alabama | 1059 | 3270 | 37 |
878277 | 878277 | 2020-12-30 | Franklin | Alabama | 1059 | 3233 | 36 |
875032 | 875032 | 2020-12-29 | Franklin | Alabama | 1059 | 3185 | 36 |
871787 | 871787 | 2020-12-28 | Franklin | Alabama | 1059 | 3169 | 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);