ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 1083 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
531230 | 531230 | 2020-09-14 | Limestone | Alabama | 1083 | 1867 | 19 |
527993 | 527993 | 2020-09-13 | Limestone | Alabama | 1083 | 1856 | 19 |
524757 | 524757 | 2020-09-12 | Limestone | Alabama | 1083 | 1835 | 19 |
521521 | 521521 | 2020-09-11 | Limestone | Alabama | 1083 | 1810 | 19 |
518284 | 518284 | 2020-09-10 | Limestone | Alabama | 1083 | 1797 | 19 |
515049 | 515049 | 2020-09-09 | Limestone | Alabama | 1083 | 1782 | 19 |
511816 | 511816 | 2020-09-08 | Limestone | Alabama | 1083 | 1771 | 19 |
508583 | 508583 | 2020-09-07 | Limestone | Alabama | 1083 | 1762 | 19 |
505351 | 505351 | 2020-09-06 | Limestone | Alabama | 1083 | 1759 | 19 |
502117 | 502117 | 2020-09-05 | Limestone | Alabama | 1083 | 1754 | 19 |
498883 | 498883 | 2020-09-04 | Limestone | Alabama | 1083 | 1728 | 19 |
495650 | 495650 | 2020-09-03 | Limestone | Alabama | 1083 | 1723 | 16 |
492416 | 492416 | 2020-09-02 | Limestone | Alabama | 1083 | 1713 | 16 |
489183 | 489183 | 2020-09-01 | Limestone | Alabama | 1083 | 1712 | 16 |
485950 | 485950 | 2020-08-31 | Limestone | Alabama | 1083 | 1687 | 16 |
482715 | 482715 | 2020-08-30 | Limestone | Alabama | 1083 | 1678 | 16 |
479481 | 479481 | 2020-08-29 | Limestone | Alabama | 1083 | 1658 | 16 |
476248 | 476248 | 2020-08-28 | Limestone | Alabama | 1083 | 1639 | 15 |
473015 | 473015 | 2020-08-27 | Limestone | Alabama | 1083 | 1634 | 15 |
469783 | 469783 | 2020-08-26 | Limestone | Alabama | 1083 | 1611 | 15 |
466554 | 466554 | 2020-08-25 | Limestone | Alabama | 1083 | 1587 | 15 |
463325 | 463325 | 2020-08-24 | Limestone | Alabama | 1083 | 1580 | 15 |
460096 | 460096 | 2020-08-23 | Limestone | Alabama | 1083 | 1565 | 15 |
456869 | 456869 | 2020-08-22 | Limestone | Alabama | 1083 | 1554 | 15 |
453641 | 453641 | 2020-08-21 | Limestone | Alabama | 1083 | 1548 | 15 |
450413 | 450413 | 2020-08-20 | Limestone | Alabama | 1083 | 1530 | 15 |
447185 | 447185 | 2020-08-19 | Limestone | Alabama | 1083 | 1523 | 14 |
443958 | 443958 | 2020-08-18 | Limestone | Alabama | 1083 | 1504 | 14 |
440732 | 440732 | 2020-08-17 | Limestone | Alabama | 1083 | 1486 | 14 |
437506 | 437506 | 2020-08-16 | Limestone | Alabama | 1083 | 1480 | 14 |
434280 | 434280 | 2020-08-15 | Limestone | Alabama | 1083 | 1462 | 14 |
431055 | 431055 | 2020-08-14 | Limestone | Alabama | 1083 | 1436 | 14 |
427827 | 427827 | 2020-08-13 | Limestone | Alabama | 1083 | 1421 | 14 |
424603 | 424603 | 2020-08-12 | Limestone | Alabama | 1083 | 1406 | 14 |
421382 | 421382 | 2020-08-11 | Limestone | Alabama | 1083 | 1387 | 14 |
418161 | 418161 | 2020-08-10 | Limestone | Alabama | 1083 | 1376 | 14 |
414940 | 414940 | 2020-08-09 | Limestone | Alabama | 1083 | 1360 | 14 |
411720 | 411720 | 2020-08-08 | Limestone | Alabama | 1083 | 1345 | 14 |
408501 | 408501 | 2020-08-07 | Limestone | Alabama | 1083 | 1311 | 14 |
405281 | 405281 | 2020-08-06 | Limestone | Alabama | 1083 | 1283 | 14 |
402063 | 402063 | 2020-08-05 | Limestone | Alabama | 1083 | 1249 | 14 |
398847 | 398847 | 2020-08-04 | Limestone | Alabama | 1083 | 1230 | 14 |
395631 | 395631 | 2020-08-03 | Limestone | Alabama | 1083 | 1218 | 14 |
392415 | 392415 | 2020-08-02 | Limestone | Alabama | 1083 | 1205 | 14 |
389198 | 389198 | 2020-08-01 | Limestone | Alabama | 1083 | 1177 | 13 |
385981 | 385981 | 2020-07-31 | Limestone | Alabama | 1083 | 1167 | 12 |
382763 | 382763 | 2020-07-30 | Limestone | Alabama | 1083 | 1134 | 12 |
379546 | 379546 | 2020-07-29 | Limestone | Alabama | 1083 | 1096 | 12 |
376330 | 376330 | 2020-07-28 | Limestone | Alabama | 1083 | 1064 | 11 |
373116 | 373116 | 2020-07-27 | Limestone | Alabama | 1083 | 1048 | 11 |
369904 | 369904 | 2020-07-26 | Limestone | Alabama | 1083 | 1023 | 10 |
366694 | 366694 | 2020-07-25 | Limestone | Alabama | 1083 | 1018 | 10 |
363487 | 363487 | 2020-07-24 | Limestone | Alabama | 1083 | 986 | 10 |
360281 | 360281 | 2020-07-23 | Limestone | Alabama | 1083 | 958 | 8 |
357076 | 357076 | 2020-07-22 | Limestone | Alabama | 1083 | 940 | 8 |
353873 | 353873 | 2020-07-21 | Limestone | Alabama | 1083 | 914 | 7 |
350671 | 350671 | 2020-07-20 | Limestone | Alabama | 1083 | 889 | 6 |
347470 | 347470 | 2020-07-19 | Limestone | Alabama | 1083 | 854 | 6 |
344270 | 344270 | 2020-07-18 | Limestone | Alabama | 1083 | 823 | 6 |
341071 | 341071 | 2020-07-17 | Limestone | Alabama | 1083 | 796 | 6 |
337875 | 337875 | 2020-07-16 | Limestone | Alabama | 1083 | 757 | 5 |
334680 | 334680 | 2020-07-15 | Limestone | Alabama | 1083 | 731 | 5 |
331487 | 331487 | 2020-07-14 | Limestone | Alabama | 1083 | 697 | 5 |
328301 | 328301 | 2020-07-13 | Limestone | Alabama | 1083 | 671 | 4 |
325115 | 325115 | 2020-07-12 | Limestone | Alabama | 1083 | 645 | 4 |
321934 | 321934 | 2020-07-11 | Limestone | Alabama | 1083 | 628 | 4 |
318755 | 318755 | 2020-07-10 | Limestone | Alabama | 1083 | 602 | 4 |
315582 | 315582 | 2020-07-09 | Limestone | Alabama | 1083 | 579 | 1 |
312407 | 312407 | 2020-07-08 | Limestone | Alabama | 1083 | 530 | 1 |
309238 | 309238 | 2020-07-07 | Limestone | Alabama | 1083 | 523 | 1 |
306069 | 306069 | 2020-07-06 | Limestone | Alabama | 1083 | 506 | 0 |
302905 | 302905 | 2020-07-05 | Limestone | Alabama | 1083 | 500 | 0 |
299741 | 299741 | 2020-07-04 | Limestone | Alabama | 1083 | 486 | 0 |
296579 | 296579 | 2020-07-03 | Limestone | Alabama | 1083 | 471 | 0 |
293424 | 293424 | 2020-07-02 | Limestone | Alabama | 1083 | 434 | 0 |
290271 | 290271 | 2020-07-01 | Limestone | Alabama | 1083 | 413 | 0 |
287121 | 287121 | 2020-06-30 | Limestone | Alabama | 1083 | 407 | 0 |
283975 | 283975 | 2020-06-29 | Limestone | Alabama | 1083 | 398 | 0 |
280829 | 280829 | 2020-06-28 | Limestone | Alabama | 1083 | 363 | 0 |
277681 | 277681 | 2020-06-27 | Limestone | Alabama | 1083 | 355 | 0 |
274533 | 274533 | 2020-06-26 | Limestone | Alabama | 1083 | 338 | 0 |
271393 | 271393 | 2020-06-25 | Limestone | Alabama | 1083 | 321 | 0 |
268259 | 268259 | 2020-06-24 | Limestone | Alabama | 1083 | 297 | 0 |
265130 | 265130 | 2020-06-23 | Limestone | Alabama | 1083 | 285 | 0 |
262001 | 262001 | 2020-06-22 | Limestone | Alabama | 1083 | 275 | 0 |
258874 | 258874 | 2020-06-21 | Limestone | Alabama | 1083 | 271 | 0 |
255747 | 255747 | 2020-06-20 | Limestone | Alabama | 1083 | 267 | 0 |
252628 | 252628 | 2020-06-19 | Limestone | Alabama | 1083 | 262 | 0 |
249513 | 249513 | 2020-06-18 | Limestone | Alabama | 1083 | 257 | 0 |
246401 | 246401 | 2020-06-17 | Limestone | Alabama | 1083 | 244 | 0 |
243288 | 243288 | 2020-06-16 | Limestone | Alabama | 1083 | 238 | 0 |
240177 | 240177 | 2020-06-15 | Limestone | Alabama | 1083 | 228 | 0 |
237069 | 237069 | 2020-06-14 | Limestone | Alabama | 1083 | 217 | 0 |
233962 | 233962 | 2020-06-13 | Limestone | Alabama | 1083 | 199 | 0 |
230857 | 230857 | 2020-06-12 | Limestone | Alabama | 1083 | 177 | 0 |
227753 | 227753 | 2020-06-11 | Limestone | Alabama | 1083 | 164 | 0 |
224652 | 224652 | 2020-06-10 | Limestone | Alabama | 1083 | 153 | 0 |
221556 | 221556 | 2020-06-09 | Limestone | Alabama | 1083 | 146 | 0 |
218464 | 218464 | 2020-06-08 | Limestone | Alabama | 1083 | 137 | 0 |
215374 | 215374 | 2020-06-07 | Limestone | Alabama | 1083 | 125 | 0 |
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);