ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 1093 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
382768 | 382768 | 2020-07-30 | Marion | Alabama | 1093 | 537 | 24 |
379551 | 379551 | 2020-07-29 | Marion | Alabama | 1093 | 519 | 24 |
376335 | 376335 | 2020-07-28 | Marion | Alabama | 1093 | 509 | 24 |
373121 | 373121 | 2020-07-27 | Marion | Alabama | 1093 | 504 | 24 |
369909 | 369909 | 2020-07-26 | Marion | Alabama | 1093 | 493 | 24 |
366699 | 366699 | 2020-07-25 | Marion | Alabama | 1093 | 483 | 23 |
363492 | 363492 | 2020-07-24 | Marion | Alabama | 1093 | 478 | 22 |
360286 | 360286 | 2020-07-23 | Marion | Alabama | 1093 | 465 | 21 |
357081 | 357081 | 2020-07-22 | Marion | Alabama | 1093 | 453 | 21 |
353878 | 353878 | 2020-07-21 | Marion | Alabama | 1093 | 447 | 17 |
350676 | 350676 | 2020-07-20 | Marion | Alabama | 1093 | 441 | 16 |
347475 | 347475 | 2020-07-19 | Marion | Alabama | 1093 | 428 | 16 |
344275 | 344275 | 2020-07-18 | Marion | Alabama | 1093 | 416 | 16 |
341076 | 341076 | 2020-07-17 | Marion | Alabama | 1093 | 389 | 14 |
337880 | 337880 | 2020-07-16 | Marion | Alabama | 1093 | 369 | 14 |
334685 | 334685 | 2020-07-15 | Marion | Alabama | 1093 | 359 | 14 |
331492 | 331492 | 2020-07-14 | Marion | Alabama | 1093 | 336 | 14 |
328306 | 328306 | 2020-07-13 | Marion | Alabama | 1093 | 313 | 14 |
325120 | 325120 | 2020-07-12 | Marion | Alabama | 1093 | 294 | 14 |
321939 | 321939 | 2020-07-11 | Marion | Alabama | 1093 | 279 | 14 |
318760 | 318760 | 2020-07-10 | Marion | Alabama | 1093 | 271 | 14 |
315587 | 315587 | 2020-07-09 | Marion | Alabama | 1093 | 249 | 14 |
312412 | 312412 | 2020-07-08 | Marion | Alabama | 1093 | 245 | 14 |
309243 | 309243 | 2020-07-07 | Marion | Alabama | 1093 | 240 | 13 |
306074 | 306074 | 2020-07-06 | Marion | Alabama | 1093 | 237 | 13 |
302910 | 302910 | 2020-07-05 | Marion | Alabama | 1093 | 228 | 13 |
299746 | 299746 | 2020-07-04 | Marion | Alabama | 1093 | 223 | 13 |
296584 | 296584 | 2020-07-03 | Marion | Alabama | 1093 | 218 | 13 |
293429 | 293429 | 2020-07-02 | Marion | Alabama | 1093 | 210 | 13 |
290276 | 290276 | 2020-07-01 | Marion | Alabama | 1093 | 208 | 12 |
287126 | 287126 | 2020-06-30 | Marion | Alabama | 1093 | 205 | 12 |
283980 | 283980 | 2020-06-29 | Marion | Alabama | 1093 | 202 | 12 |
280834 | 280834 | 2020-06-28 | Marion | Alabama | 1093 | 194 | 12 |
277686 | 277686 | 2020-06-27 | Marion | Alabama | 1093 | 193 | 12 |
274538 | 274538 | 2020-06-26 | Marion | Alabama | 1093 | 189 | 12 |
271398 | 271398 | 2020-06-25 | Marion | Alabama | 1093 | 188 | 12 |
268264 | 268264 | 2020-06-24 | Marion | Alabama | 1093 | 184 | 12 |
265135 | 265135 | 2020-06-23 | Marion | Alabama | 1093 | 176 | 12 |
262006 | 262006 | 2020-06-22 | Marion | Alabama | 1093 | 173 | 12 |
258879 | 258879 | 2020-06-21 | Marion | Alabama | 1093 | 173 | 12 |
255752 | 255752 | 2020-06-20 | Marion | Alabama | 1093 | 173 | 12 |
252633 | 252633 | 2020-06-19 | Marion | Alabama | 1093 | 170 | 12 |
249518 | 249518 | 2020-06-18 | Marion | Alabama | 1093 | 165 | 12 |
246406 | 246406 | 2020-06-17 | Marion | Alabama | 1093 | 153 | 12 |
243293 | 243293 | 2020-06-16 | Marion | Alabama | 1093 | 149 | 12 |
240182 | 240182 | 2020-06-15 | Marion | Alabama | 1093 | 146 | 12 |
237074 | 237074 | 2020-06-14 | Marion | Alabama | 1093 | 144 | 12 |
233967 | 233967 | 2020-06-13 | Marion | Alabama | 1093 | 138 | 12 |
230862 | 230862 | 2020-06-12 | Marion | Alabama | 1093 | 136 | 12 |
227758 | 227758 | 2020-06-11 | Marion | Alabama | 1093 | 133 | 12 |
224657 | 224657 | 2020-06-10 | Marion | Alabama | 1093 | 130 | 12 |
221561 | 221561 | 2020-06-09 | Marion | Alabama | 1093 | 130 | 11 |
218469 | 218469 | 2020-06-08 | Marion | Alabama | 1093 | 130 | 11 |
215379 | 215379 | 2020-06-07 | Marion | Alabama | 1093 | 130 | 11 |
212292 | 212292 | 2020-06-06 | Marion | Alabama | 1093 | 130 | 11 |
209207 | 209207 | 2020-06-05 | Marion | Alabama | 1093 | 129 | 11 |
206125 | 206125 | 2020-06-04 | Marion | Alabama | 1093 | 128 | 11 |
203046 | 203046 | 2020-06-03 | Marion | Alabama | 1093 | 128 | 11 |
199970 | 199970 | 2020-06-02 | Marion | Alabama | 1093 | 128 | 11 |
196897 | 196897 | 2020-06-01 | Marion | Alabama | 1093 | 126 | 11 |
193827 | 193827 | 2020-05-31 | Marion | Alabama | 1093 | 122 | 11 |
190761 | 190761 | 2020-05-30 | Marion | Alabama | 1093 | 121 | 11 |
187697 | 187697 | 2020-05-29 | Marion | Alabama | 1093 | 120 | 11 |
184640 | 184640 | 2020-05-28 | Marion | Alabama | 1093 | 119 | 11 |
181588 | 181588 | 2020-05-27 | Marion | Alabama | 1093 | 117 | 11 |
178544 | 178544 | 2020-05-26 | Marion | Alabama | 1093 | 117 | 11 |
175499 | 175499 | 2020-05-25 | Marion | Alabama | 1093 | 114 | 10 |
172456 | 172456 | 2020-05-24 | Marion | Alabama | 1093 | 113 | 10 |
169415 | 169415 | 2020-05-23 | Marion | Alabama | 1093 | 109 | 10 |
166379 | 166379 | 2020-05-22 | Marion | Alabama | 1093 | 107 | 10 |
163347 | 163347 | 2020-05-21 | Marion | Alabama | 1093 | 108 | 10 |
160319 | 160319 | 2020-05-20 | Marion | Alabama | 1093 | 108 | 10 |
157295 | 157295 | 2020-05-19 | Marion | Alabama | 1093 | 106 | 9 |
154279 | 154279 | 2020-05-18 | Marion | Alabama | 1093 | 103 | 9 |
151267 | 151267 | 2020-05-17 | Marion | Alabama | 1093 | 101 | 9 |
148258 | 148258 | 2020-05-16 | Marion | Alabama | 1093 | 101 | 9 |
145255 | 145255 | 2020-05-15 | Marion | Alabama | 1093 | 101 | 9 |
142256 | 142256 | 2020-05-14 | Marion | Alabama | 1093 | 101 | 9 |
139260 | 139260 | 2020-05-13 | Marion | Alabama | 1093 | 100 | 9 |
136269 | 136269 | 2020-05-12 | Marion | Alabama | 1093 | 97 | 7 |
133279 | 133279 | 2020-05-11 | Marion | Alabama | 1093 | 96 | 7 |
130289 | 130289 | 2020-05-10 | Marion | Alabama | 1093 | 96 | 7 |
127299 | 127299 | 2020-05-09 | Marion | Alabama | 1093 | 96 | 7 |
124314 | 124314 | 2020-05-08 | Marion | Alabama | 1093 | 95 | 7 |
121334 | 121334 | 2020-05-07 | Marion | Alabama | 1093 | 93 | 7 |
118368 | 118368 | 2020-05-06 | Marion | Alabama | 1093 | 92 | 7 |
115409 | 115409 | 2020-05-05 | Marion | Alabama | 1093 | 90 | 7 |
112526 | 112526 | 2020-05-04 | Marion | Alabama | 1093 | 85 | 6 |
109651 | 109651 | 2020-05-03 | Marion | Alabama | 1093 | 83 | 6 |
106782 | 106782 | 2020-05-02 | Marion | Alabama | 1093 | 82 | 6 |
103917 | 103917 | 2020-05-01 | Marion | Alabama | 1093 | 78 | 6 |
101062 | 101062 | 2020-04-30 | Marion | Alabama | 1093 | 75 | 6 |
98212 | 98212 | 2020-04-29 | Marion | Alabama | 1093 | 75 | 6 |
95367 | 95367 | 2020-04-28 | Marion | Alabama | 1093 | 76 | 6 |
92537 | 92537 | 2020-04-27 | Marion | Alabama | 1093 | 75 | 6 |
89719 | 89719 | 2020-04-26 | Marion | Alabama | 1093 | 74 | 5 |
86903 | 86903 | 2020-04-25 | Marion | Alabama | 1093 | 73 | 5 |
84095 | 84095 | 2020-04-24 | Marion | Alabama | 1093 | 69 | 5 |
81294 | 81294 | 2020-04-23 | Marion | Alabama | 1093 | 67 | 5 |
78501 | 78501 | 2020-04-22 | Marion | Alabama | 1093 | 65 | 5 |
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);