ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Tallapoosa" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1277605 | 1277605 | 2021-05-02 | Tallapoosa | Alabama | 1123 | 4002 | 150 |
1274358 | 1274358 | 2021-05-01 | Tallapoosa | Alabama | 1123 | 3994 | 150 |
1271111 | 1271111 | 2021-04-30 | Tallapoosa | Alabama | 1123 | 3990 | 149 |
1267864 | 1267864 | 2021-04-29 | Tallapoosa | Alabama | 1123 | 3981 | 149 |
1264617 | 1264617 | 2021-04-28 | Tallapoosa | Alabama | 1123 | 3967 | 149 |
1261370 | 1261370 | 2021-04-27 | Tallapoosa | Alabama | 1123 | 3963 | 149 |
1258123 | 1258123 | 2021-04-26 | Tallapoosa | Alabama | 1123 | 3956 | 149 |
1254876 | 1254876 | 2021-04-25 | Tallapoosa | Alabama | 1123 | 3954 | 149 |
1251629 | 1251629 | 2021-04-24 | Tallapoosa | Alabama | 1123 | 3953 | 149 |
1248382 | 1248382 | 2021-04-23 | Tallapoosa | Alabama | 1123 | 3949 | 149 |
1245135 | 1245135 | 2021-04-22 | Tallapoosa | Alabama | 1123 | 3948 | 149 |
1241888 | 1241888 | 2021-04-21 | Tallapoosa | Alabama | 1123 | 3943 | 149 |
1238641 | 1238641 | 2021-04-20 | Tallapoosa | Alabama | 1123 | 3928 | 148 |
1235394 | 1235394 | 2021-04-19 | Tallapoosa | Alabama | 1123 | 3922 | 148 |
1232146 | 1232146 | 2021-04-18 | Tallapoosa | Alabama | 1123 | 3919 | 148 |
1228898 | 1228898 | 2021-04-17 | Tallapoosa | Alabama | 1123 | 3915 | 148 |
1225650 | 1225650 | 2021-04-16 | Tallapoosa | Alabama | 1123 | 3907 | 146 |
1222403 | 1222403 | 2021-04-15 | Tallapoosa | Alabama | 1123 | 3904 | 146 |
1219155 | 1219155 | 2021-04-14 | Tallapoosa | Alabama | 1123 | 3902 | 146 |
1215907 | 1215907 | 2021-04-13 | Tallapoosa | Alabama | 1123 | 3898 | 146 |
1212660 | 1212660 | 2021-04-12 | Tallapoosa | Alabama | 1123 | 3893 | 146 |
1209411 | 1209411 | 2021-04-11 | Tallapoosa | Alabama | 1123 | 3893 | 146 |
1206163 | 1206163 | 2021-04-10 | Tallapoosa | Alabama | 1123 | 3892 | 146 |
1202915 | 1202915 | 2021-04-09 | Tallapoosa | Alabama | 1123 | 3895 | 147 |
1199667 | 1199667 | 2021-04-08 | Tallapoosa | Alabama | 1123 | 3889 | 147 |
1196418 | 1196418 | 2021-04-07 | Tallapoosa | Alabama | 1123 | 3886 | 147 |
1193170 | 1193170 | 2021-04-06 | Tallapoosa | Alabama | 1123 | 3882 | 147 |
1189920 | 1189920 | 2021-04-05 | Tallapoosa | Alabama | 1123 | 3877 | 146 |
1186673 | 1186673 | 2021-04-04 | Tallapoosa | Alabama | 1123 | 3875 | 146 |
1183426 | 1183426 | 2021-04-03 | Tallapoosa | Alabama | 1123 | 3874 | 146 |
1180179 | 1180179 | 2021-04-02 | Tallapoosa | Alabama | 1123 | 3873 | 146 |
1176932 | 1176932 | 2021-04-01 | Tallapoosa | Alabama | 1123 | 3848 | 144 |
1173685 | 1173685 | 2021-03-31 | Tallapoosa | Alabama | 1123 | 3847 | 144 |
1170438 | 1170438 | 2021-03-30 | Tallapoosa | Alabama | 1123 | 3846 | 144 |
1167190 | 1167190 | 2021-03-29 | Tallapoosa | Alabama | 1123 | 3845 | 144 |
1163942 | 1163942 | 2021-03-28 | Tallapoosa | Alabama | 1123 | 3842 | 144 |
1160694 | 1160694 | 2021-03-27 | Tallapoosa | Alabama | 1123 | 3842 | 144 |
1157446 | 1157446 | 2021-03-26 | Tallapoosa | Alabama | 1123 | 3843 | 144 |
1154199 | 1154199 | 2021-03-25 | Tallapoosa | Alabama | 1123 | 3841 | 143 |
1150952 | 1150952 | 2021-03-24 | Tallapoosa | Alabama | 1123 | 3843 | 144 |
1147705 | 1147705 | 2021-03-23 | Tallapoosa | Alabama | 1123 | 3834 | 144 |
1144458 | 1144458 | 2021-03-22 | Tallapoosa | Alabama | 1123 | 3832 | 144 |
1141211 | 1141211 | 2021-03-21 | Tallapoosa | Alabama | 1123 | 3832 | 144 |
1137965 | 1137965 | 2021-03-20 | Tallapoosa | Alabama | 1123 | 3830 | 144 |
1134719 | 1134719 | 2021-03-19 | Tallapoosa | Alabama | 1123 | 3828 | 144 |
1131471 | 1131471 | 2021-03-18 | Tallapoosa | Alabama | 1123 | 3826 | 144 |
1128224 | 1128224 | 2021-03-17 | Tallapoosa | Alabama | 1123 | 3818 | 143 |
1124978 | 1124978 | 2021-03-16 | Tallapoosa | Alabama | 1123 | 3808 | 143 |
1121732 | 1121732 | 2021-03-15 | Tallapoosa | Alabama | 1123 | 3807 | 143 |
1118485 | 1118485 | 2021-03-14 | Tallapoosa | Alabama | 1123 | 3670 | 143 |
1115238 | 1115238 | 2021-03-13 | Tallapoosa | Alabama | 1123 | 3669 | 143 |
1111992 | 1111992 | 2021-03-12 | Tallapoosa | Alabama | 1123 | 3668 | 143 |
1108746 | 1108746 | 2021-03-11 | Tallapoosa | Alabama | 1123 | 3668 | 143 |
1105500 | 1105500 | 2021-03-10 | Tallapoosa | Alabama | 1123 | 3660 | 143 |
1102254 | 1102254 | 2021-03-09 | Tallapoosa | Alabama | 1123 | 3645 | 143 |
1099008 | 1099008 | 2021-03-08 | Tallapoosa | Alabama | 1123 | 3636 | 143 |
1095760 | 1095760 | 2021-03-07 | Tallapoosa | Alabama | 1123 | 3637 | 143 |
1092514 | 1092514 | 2021-03-06 | Tallapoosa | Alabama | 1123 | 3637 | 143 |
1089268 | 1089268 | 2021-03-05 | Tallapoosa | Alabama | 1123 | 3631 | 143 |
1086023 | 1086023 | 2021-03-04 | Tallapoosa | Alabama | 1123 | 3622 | 143 |
1082777 | 1082777 | 2021-03-03 | Tallapoosa | Alabama | 1123 | 3613 | 143 |
1079531 | 1079531 | 2021-03-02 | Tallapoosa | Alabama | 1123 | 3596 | 143 |
1076286 | 1076286 | 2021-03-01 | Tallapoosa | Alabama | 1123 | 3588 | 142 |
1073040 | 1073040 | 2021-02-28 | Tallapoosa | Alabama | 1123 | 3585 | 142 |
1069794 | 1069794 | 2021-02-27 | Tallapoosa | Alabama | 1123 | 3581 | 142 |
1066549 | 1066549 | 2021-02-26 | Tallapoosa | Alabama | 1123 | 3572 | 141 |
1063304 | 1063304 | 2021-02-25 | Tallapoosa | Alabama | 1123 | 3572 | 141 |
1060059 | 1060059 | 2021-02-24 | Tallapoosa | Alabama | 1123 | 3559 | 139 |
1056813 | 1056813 | 2021-02-23 | Tallapoosa | Alabama | 1123 | 3533 | 138 |
1053567 | 1053567 | 2021-02-22 | Tallapoosa | Alabama | 1123 | 3519 | 139 |
1050320 | 1050320 | 2021-02-21 | Tallapoosa | Alabama | 1123 | 3518 | 139 |
1047073 | 1047073 | 2021-02-20 | Tallapoosa | Alabama | 1123 | 3504 | 139 |
1043828 | 1043828 | 2021-02-19 | Tallapoosa | Alabama | 1123 | 3497 | 139 |
1040583 | 1040583 | 2021-02-18 | Tallapoosa | Alabama | 1123 | 3475 | 138 |
1037338 | 1037338 | 2021-02-17 | Tallapoosa | Alabama | 1123 | 3458 | 137 |
1034093 | 1034093 | 2021-02-16 | Tallapoosa | Alabama | 1123 | 3446 | 134 |
1030847 | 1030847 | 2021-02-15 | Tallapoosa | Alabama | 1123 | 3428 | 134 |
1027600 | 1027600 | 2021-02-14 | Tallapoosa | Alabama | 1123 | 3426 | 134 |
1024355 | 1024355 | 2021-02-13 | Tallapoosa | Alabama | 1123 | 3413 | 134 |
1021110 | 1021110 | 2021-02-12 | Tallapoosa | Alabama | 1123 | 3397 | 134 |
1017865 | 1017865 | 2021-02-11 | Tallapoosa | Alabama | 1123 | 3387 | 129 |
1014620 | 1014620 | 2021-02-10 | Tallapoosa | Alabama | 1123 | 3440 | 127 |
1011375 | 1011375 | 2021-02-09 | Tallapoosa | Alabama | 1123 | 3427 | 125 |
1008129 | 1008129 | 2021-02-08 | Tallapoosa | Alabama | 1123 | 3411 | 124 |
1004883 | 1004883 | 2021-02-07 | Tallapoosa | Alabama | 1123 | 3406 | 124 |
1001637 | 1001637 | 2021-02-06 | Tallapoosa | Alabama | 1123 | 3393 | 124 |
998391 | 998391 | 2021-02-05 | Tallapoosa | Alabama | 1123 | 3382 | 123 |
995145 | 995145 | 2021-02-04 | Tallapoosa | Alabama | 1123 | 3373 | 123 |
991899 | 991899 | 2021-02-03 | Tallapoosa | Alabama | 1123 | 3357 | 122 |
988653 | 988653 | 2021-02-02 | Tallapoosa | Alabama | 1123 | 3349 | 118 |
985406 | 985406 | 2021-02-01 | Tallapoosa | Alabama | 1123 | 3334 | 114 |
982159 | 982159 | 2021-01-31 | Tallapoosa | Alabama | 1123 | 3325 | 114 |
978913 | 978913 | 2021-01-30 | Tallapoosa | Alabama | 1123 | 3283 | 113 |
975668 | 975668 | 2021-01-29 | Tallapoosa | Alabama | 1123 | 3283 | 113 |
972423 | 972423 | 2021-01-28 | Tallapoosa | Alabama | 1123 | 3258 | 112 |
969178 | 969178 | 2021-01-27 | Tallapoosa | Alabama | 1123 | 3228 | 111 |
965934 | 965934 | 2021-01-26 | Tallapoosa | Alabama | 1123 | 3184 | 109 |
962689 | 962689 | 2021-01-25 | Tallapoosa | Alabama | 1123 | 3163 | 109 |
959444 | 959444 | 2021-01-24 | Tallapoosa | Alabama | 1123 | 3149 | 109 |
956198 | 956198 | 2021-01-23 | Tallapoosa | Alabama | 1123 | 3143 | 109 |
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);