ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 1097 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
531237 | 531237 | 2020-09-14 | Mobile | Alabama | 1097 | 12875 | 287 |
528000 | 528000 | 2020-09-13 | Mobile | Alabama | 1097 | 12841 | 284 |
524764 | 524764 | 2020-09-12 | Mobile | Alabama | 1097 | 12791 | 283 |
521528 | 521528 | 2020-09-11 | Mobile | Alabama | 1097 | 12749 | 281 |
518291 | 518291 | 2020-09-10 | Mobile | Alabama | 1097 | 12711 | 277 |
515056 | 515056 | 2020-09-09 | Mobile | Alabama | 1097 | 12658 | 276 |
511823 | 511823 | 2020-09-08 | Mobile | Alabama | 1097 | 12604 | 272 |
508590 | 508590 | 2020-09-07 | Mobile | Alabama | 1097 | 12576 | 271 |
505358 | 505358 | 2020-09-06 | Mobile | Alabama | 1097 | 12559 | 271 |
502124 | 502124 | 2020-09-05 | Mobile | Alabama | 1097 | 12536 | 270 |
498890 | 498890 | 2020-09-04 | Mobile | Alabama | 1097 | 12453 | 268 |
495657 | 495657 | 2020-09-03 | Mobile | Alabama | 1097 | 12402 | 268 |
492423 | 492423 | 2020-09-02 | Mobile | Alabama | 1097 | 12346 | 267 |
489190 | 489190 | 2020-09-01 | Mobile | Alabama | 1097 | 12318 | 263 |
485957 | 485957 | 2020-08-31 | Mobile | Alabama | 1097 | 12259 | 261 |
482722 | 482722 | 2020-08-30 | Mobile | Alabama | 1097 | 12197 | 260 |
479488 | 479488 | 2020-08-29 | Mobile | Alabama | 1097 | 12136 | 257 |
476255 | 476255 | 2020-08-28 | Mobile | Alabama | 1097 | 12040 | 256 |
473022 | 473022 | 2020-08-27 | Mobile | Alabama | 1097 | 11983 | 253 |
469790 | 469790 | 2020-08-26 | Mobile | Alabama | 1097 | 11923 | 252 |
466561 | 466561 | 2020-08-25 | Mobile | Alabama | 1097 | 11736 | 250 |
463332 | 463332 | 2020-08-24 | Mobile | Alabama | 1097 | 11700 | 250 |
460103 | 460103 | 2020-08-23 | Mobile | Alabama | 1097 | 11656 | 246 |
456876 | 456876 | 2020-08-22 | Mobile | Alabama | 1097 | 11626 | 246 |
453648 | 453648 | 2020-08-21 | Mobile | Alabama | 1097 | 11558 | 242 |
450420 | 450420 | 2020-08-20 | Mobile | Alabama | 1097 | 11445 | 240 |
447192 | 447192 | 2020-08-19 | Mobile | Alabama | 1097 | 11369 | 235 |
443965 | 443965 | 2020-08-18 | Mobile | Alabama | 1097 | 11241 | 234 |
440739 | 440739 | 2020-08-17 | Mobile | Alabama | 1097 | 11177 | 233 |
437513 | 437513 | 2020-08-16 | Mobile | Alabama | 1097 | 11125 | 232 |
434287 | 434287 | 2020-08-15 | Mobile | Alabama | 1097 | 11055 | 230 |
431062 | 431062 | 2020-08-14 | Mobile | Alabama | 1097 | 10930 | 228 |
427834 | 427834 | 2020-08-13 | Mobile | Alabama | 1097 | 10841 | 226 |
424610 | 424610 | 2020-08-12 | Mobile | Alabama | 1097 | 10763 | 221 |
421389 | 421389 | 2020-08-11 | Mobile | Alabama | 1097 | 10673 | 217 |
418168 | 418168 | 2020-08-10 | Mobile | Alabama | 1097 | 10599 | 212 |
414947 | 414947 | 2020-08-09 | Mobile | Alabama | 1097 | 10029 | 212 |
411727 | 411727 | 2020-08-08 | Mobile | Alabama | 1097 | 9917 | 211 |
408508 | 408508 | 2020-08-07 | Mobile | Alabama | 1097 | 9646 | 211 |
405288 | 405288 | 2020-08-06 | Mobile | Alabama | 1097 | 9493 | 209 |
402070 | 402070 | 2020-08-05 | Mobile | Alabama | 1097 | 9326 | 209 |
398854 | 398854 | 2020-08-04 | Mobile | Alabama | 1097 | 9228 | 203 |
395638 | 395638 | 2020-08-03 | Mobile | Alabama | 1097 | 9144 | 197 |
392422 | 392422 | 2020-08-02 | Mobile | Alabama | 1097 | 9056 | 197 |
389205 | 389205 | 2020-08-01 | Mobile | Alabama | 1097 | 8522 | 194 |
385988 | 385988 | 2020-07-31 | Mobile | Alabama | 1097 | 8135 | 192 |
382770 | 382770 | 2020-07-30 | Mobile | Alabama | 1097 | 7915 | 186 |
379553 | 379553 | 2020-07-29 | Mobile | Alabama | 1097 | 7717 | 185 |
376337 | 376337 | 2020-07-28 | Mobile | Alabama | 1097 | 7528 | 182 |
373123 | 373123 | 2020-07-27 | Mobile | Alabama | 1097 | 7394 | 181 |
369911 | 369911 | 2020-07-26 | Mobile | Alabama | 1097 | 7226 | 180 |
366701 | 366701 | 2020-07-25 | Mobile | Alabama | 1097 | 7129 | 180 |
363494 | 363494 | 2020-07-24 | Mobile | Alabama | 1097 | 6932 | 175 |
360288 | 360288 | 2020-07-23 | Mobile | Alabama | 1097 | 6829 | 176 |
357083 | 357083 | 2020-07-22 | Mobile | Alabama | 1097 | 6473 | 174 |
353880 | 353880 | 2020-07-21 | Mobile | Alabama | 1097 | 6308 | 166 |
350678 | 350678 | 2020-07-20 | Mobile | Alabama | 1097 | 6178 | 166 |
347477 | 347477 | 2020-07-19 | Mobile | Alabama | 1097 | 6045 | 166 |
344277 | 344277 | 2020-07-18 | Mobile | Alabama | 1097 | 5927 | 166 |
341078 | 341078 | 2020-07-17 | Mobile | Alabama | 1097 | 5740 | 166 |
337882 | 337882 | 2020-07-16 | Mobile | Alabama | 1097 | 5540 | 163 |
334687 | 334687 | 2020-07-15 | Mobile | Alabama | 1097 | 5375 | 162 |
331494 | 331494 | 2020-07-14 | Mobile | Alabama | 1097 | 5231 | 152 |
328308 | 328308 | 2020-07-13 | Mobile | Alabama | 1097 | 5086 | 145 |
325122 | 325122 | 2020-07-12 | Mobile | Alabama | 1097 | 4929 | 145 |
321941 | 321941 | 2020-07-11 | Mobile | Alabama | 1097 | 4778 | 144 |
318762 | 318762 | 2020-07-10 | Mobile | Alabama | 1097 | 4649 | 142 |
315589 | 315589 | 2020-07-09 | Mobile | Alabama | 1097 | 4442 | 141 |
312414 | 312414 | 2020-07-08 | Mobile | Alabama | 1097 | 4339 | 140 |
309245 | 309245 | 2020-07-07 | Mobile | Alabama | 1097 | 4243 | 140 |
306076 | 306076 | 2020-07-06 | Mobile | Alabama | 1097 | 4153 | 138 |
302912 | 302912 | 2020-07-05 | Mobile | Alabama | 1097 | 4104 | 138 |
299748 | 299748 | 2020-07-04 | Mobile | Alabama | 1097 | 4029 | 138 |
296586 | 296586 | 2020-07-03 | Mobile | Alabama | 1097 | 3928 | 138 |
293431 | 293431 | 2020-07-02 | Mobile | Alabama | 1097 | 3823 | 138 |
290278 | 290278 | 2020-07-01 | Mobile | Alabama | 1097 | 3724 | 138 |
287128 | 287128 | 2020-06-30 | Mobile | Alabama | 1097 | 3660 | 138 |
283982 | 283982 | 2020-06-29 | Mobile | Alabama | 1097 | 3562 | 137 |
280836 | 280836 | 2020-06-28 | Mobile | Alabama | 1097 | 3441 | 135 |
277688 | 277688 | 2020-06-27 | Mobile | Alabama | 1097 | 3385 | 135 |
274540 | 274540 | 2020-06-26 | Mobile | Alabama | 1097 | 3294 | 135 |
271400 | 271400 | 2020-06-25 | Mobile | Alabama | 1097 | 3241 | 135 |
268266 | 268266 | 2020-06-24 | Mobile | Alabama | 1097 | 3186 | 135 |
265137 | 265137 | 2020-06-23 | Mobile | Alabama | 1097 | 3074 | 133 |
262008 | 262008 | 2020-06-22 | Mobile | Alabama | 1097 | 3036 | 133 |
258881 | 258881 | 2020-06-21 | Mobile | Alabama | 1097 | 3016 | 133 |
255754 | 255754 | 2020-06-20 | Mobile | Alabama | 1097 | 2954 | 133 |
252635 | 252635 | 2020-06-19 | Mobile | Alabama | 1097 | 2921 | 132 |
249520 | 249520 | 2020-06-18 | Mobile | Alabama | 1097 | 2856 | 131 |
246408 | 246408 | 2020-06-17 | Mobile | Alabama | 1097 | 2808 | 130 |
243295 | 243295 | 2020-06-16 | Mobile | Alabama | 1097 | 2790 | 129 |
240184 | 240184 | 2020-06-15 | Mobile | Alabama | 1097 | 2742 | 129 |
237076 | 237076 | 2020-06-14 | Mobile | Alabama | 1097 | 2716 | 129 |
233969 | 233969 | 2020-06-13 | Mobile | Alabama | 1097 | 2679 | 129 |
230864 | 230864 | 2020-06-12 | Mobile | Alabama | 1097 | 2642 | 129 |
227760 | 227760 | 2020-06-11 | Mobile | Alabama | 1097 | 2612 | 128 |
224659 | 224659 | 2020-06-10 | Mobile | Alabama | 1097 | 2563 | 127 |
221563 | 221563 | 2020-06-09 | Mobile | Alabama | 1097 | 2504 | 126 |
218471 | 218471 | 2020-06-08 | Mobile | Alabama | 1097 | 2478 | 124 |
215381 | 215381 | 2020-06-07 | Mobile | Alabama | 1097 | 2450 | 125 |
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);