ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 1015 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
631647 | 631647 | 2020-10-15 | Calhoun | Alabama | 1015 | 3949 | 59 |
628403 | 628403 | 2020-10-14 | Calhoun | Alabama | 1015 | 3922 | 57 |
625160 | 625160 | 2020-10-13 | Calhoun | Alabama | 1015 | 3897 | 49 |
621917 | 621917 | 2020-10-12 | Calhoun | Alabama | 1015 | 3861 | 49 |
618674 | 618674 | 2020-10-11 | Calhoun | Alabama | 1015 | 3841 | 49 |
615432 | 615432 | 2020-10-10 | Calhoun | Alabama | 1015 | 3823 | 49 |
612191 | 612191 | 2020-10-09 | Calhoun | Alabama | 1015 | 3803 | 47 |
608949 | 608949 | 2020-10-08 | Calhoun | Alabama | 1015 | 3752 | 45 |
605706 | 605706 | 2020-10-07 | Calhoun | Alabama | 1015 | 3743 | 45 |
602464 | 602464 | 2020-10-06 | Calhoun | Alabama | 1015 | 3730 | 45 |
599221 | 599221 | 2020-10-05 | Calhoun | Alabama | 1015 | 3705 | 44 |
595978 | 595978 | 2020-10-04 | Calhoun | Alabama | 1015 | 3679 | 44 |
592736 | 592736 | 2020-10-03 | Calhoun | Alabama | 1015 | 3660 | 44 |
589496 | 589496 | 2020-10-02 | Calhoun | Alabama | 1015 | 3628 | 44 |
586255 | 586255 | 2020-10-01 | Calhoun | Alabama | 1015 | 3587 | 44 |
583015 | 583015 | 2020-09-30 | Calhoun | Alabama | 1015 | 3569 | 44 |
579776 | 579776 | 2020-09-29 | Calhoun | Alabama | 1015 | 3556 | 44 |
576535 | 576535 | 2020-09-28 | Calhoun | Alabama | 1015 | 3548 | 44 |
573291 | 573291 | 2020-09-27 | Calhoun | Alabama | 1015 | 3534 | 44 |
570049 | 570049 | 2020-09-26 | Calhoun | Alabama | 1015 | 3515 | 44 |
566808 | 566808 | 2020-09-25 | Calhoun | Alabama | 1015 | 3499 | 42 |
563567 | 563567 | 2020-09-24 | Calhoun | Alabama | 1015 | 3466 | 41 |
560328 | 560328 | 2020-09-23 | Calhoun | Alabama | 1015 | 3401 | 40 |
557092 | 557092 | 2020-09-22 | Calhoun | Alabama | 1015 | 3390 | 40 |
553855 | 553855 | 2020-09-21 | Calhoun | Alabama | 1015 | 3374 | 39 |
550616 | 550616 | 2020-09-20 | Calhoun | Alabama | 1015 | 3338 | 39 |
547377 | 547377 | 2020-09-19 | Calhoun | Alabama | 1015 | 3320 | 39 |
544140 | 544140 | 2020-09-18 | Calhoun | Alabama | 1015 | 3249 | 39 |
540904 | 540904 | 2020-09-17 | Calhoun | Alabama | 1015 | 3211 | 39 |
537667 | 537667 | 2020-09-16 | Calhoun | Alabama | 1015 | 3165 | 38 |
534431 | 534431 | 2020-09-15 | Calhoun | Alabama | 1015 | 3127 | 38 |
531196 | 531196 | 2020-09-14 | Calhoun | Alabama | 1015 | 3110 | 38 |
527959 | 527959 | 2020-09-13 | Calhoun | Alabama | 1015 | 3093 | 38 |
524723 | 524723 | 2020-09-12 | Calhoun | Alabama | 1015 | 3047 | 38 |
521487 | 521487 | 2020-09-11 | Calhoun | Alabama | 1015 | 2988 | 38 |
518250 | 518250 | 2020-09-10 | Calhoun | Alabama | 1015 | 2958 | 38 |
515015 | 515015 | 2020-09-09 | Calhoun | Alabama | 1015 | 2907 | 39 |
511782 | 511782 | 2020-09-08 | Calhoun | Alabama | 1015 | 2891 | 39 |
508549 | 508549 | 2020-09-07 | Calhoun | Alabama | 1015 | 2877 | 39 |
505317 | 505317 | 2020-09-06 | Calhoun | Alabama | 1015 | 2842 | 39 |
502083 | 502083 | 2020-09-05 | Calhoun | Alabama | 1015 | 2830 | 39 |
498849 | 498849 | 2020-09-04 | Calhoun | Alabama | 1015 | 2747 | 38 |
495616 | 495616 | 2020-09-03 | Calhoun | Alabama | 1015 | 2678 | 38 |
492382 | 492382 | 2020-09-02 | Calhoun | Alabama | 1015 | 2633 | 38 |
489149 | 489149 | 2020-09-01 | Calhoun | Alabama | 1015 | 2619 | 38 |
485916 | 485916 | 2020-08-31 | Calhoun | Alabama | 1015 | 2567 | 36 |
482681 | 482681 | 2020-08-30 | Calhoun | Alabama | 1015 | 2533 | 35 |
479447 | 479447 | 2020-08-29 | Calhoun | Alabama | 1015 | 2499 | 35 |
476214 | 476214 | 2020-08-28 | Calhoun | Alabama | 1015 | 2443 | 32 |
472981 | 472981 | 2020-08-27 | Calhoun | Alabama | 1015 | 2413 | 30 |
469749 | 469749 | 2020-08-26 | Calhoun | Alabama | 1015 | 2400 | 28 |
466520 | 466520 | 2020-08-25 | Calhoun | Alabama | 1015 | 2345 | 28 |
463291 | 463291 | 2020-08-24 | Calhoun | Alabama | 1015 | 2327 | 27 |
460062 | 460062 | 2020-08-23 | Calhoun | Alabama | 1015 | 2286 | 25 |
456835 | 456835 | 2020-08-22 | Calhoun | Alabama | 1015 | 2276 | 25 |
453607 | 453607 | 2020-08-21 | Calhoun | Alabama | 1015 | 2247 | 25 |
450379 | 450379 | 2020-08-20 | Calhoun | Alabama | 1015 | 2214 | 25 |
447151 | 447151 | 2020-08-19 | Calhoun | Alabama | 1015 | 2159 | 25 |
443924 | 443924 | 2020-08-18 | Calhoun | Alabama | 1015 | 2107 | 25 |
440698 | 440698 | 2020-08-17 | Calhoun | Alabama | 1015 | 2055 | 23 |
437472 | 437472 | 2020-08-16 | Calhoun | Alabama | 1015 | 2037 | 20 |
434246 | 434246 | 2020-08-15 | Calhoun | Alabama | 1015 | 2019 | 20 |
431021 | 431021 | 2020-08-14 | Calhoun | Alabama | 1015 | 1975 | 20 |
427793 | 427793 | 2020-08-13 | Calhoun | Alabama | 1015 | 1959 | 20 |
424569 | 424569 | 2020-08-12 | Calhoun | Alabama | 1015 | 1935 | 20 |
421348 | 421348 | 2020-08-11 | Calhoun | Alabama | 1015 | 1914 | 19 |
418127 | 418127 | 2020-08-10 | Calhoun | Alabama | 1015 | 1883 | 17 |
414906 | 414906 | 2020-08-09 | Calhoun | Alabama | 1015 | 1860 | 14 |
411686 | 411686 | 2020-08-08 | Calhoun | Alabama | 1015 | 1836 | 13 |
408467 | 408467 | 2020-08-07 | Calhoun | Alabama | 1015 | 1777 | 13 |
405247 | 405247 | 2020-08-06 | Calhoun | Alabama | 1015 | 1741 | 13 |
402029 | 402029 | 2020-08-05 | Calhoun | Alabama | 1015 | 1683 | 13 |
398813 | 398813 | 2020-08-04 | Calhoun | Alabama | 1015 | 1646 | 12 |
395597 | 395597 | 2020-08-03 | Calhoun | Alabama | 1015 | 1612 | 9 |
392381 | 392381 | 2020-08-02 | Calhoun | Alabama | 1015 | 1580 | 9 |
389164 | 389164 | 2020-08-01 | Calhoun | Alabama | 1015 | 1480 | 9 |
385947 | 385947 | 2020-07-31 | Calhoun | Alabama | 1015 | 1450 | 9 |
382729 | 382729 | 2020-07-30 | Calhoun | Alabama | 1015 | 1336 | 8 |
379512 | 379512 | 2020-07-29 | Calhoun | Alabama | 1015 | 1292 | 6 |
376296 | 376296 | 2020-07-28 | Calhoun | Alabama | 1015 | 1244 | 6 |
373082 | 373082 | 2020-07-27 | Calhoun | Alabama | 1015 | 1194 | 6 |
369870 | 369870 | 2020-07-26 | Calhoun | Alabama | 1015 | 1113 | 6 |
366660 | 366660 | 2020-07-25 | Calhoun | Alabama | 1015 | 1062 | 6 |
363453 | 363453 | 2020-07-24 | Calhoun | Alabama | 1015 | 999 | 6 |
360247 | 360247 | 2020-07-23 | Calhoun | Alabama | 1015 | 934 | 6 |
357042 | 357042 | 2020-07-22 | Calhoun | Alabama | 1015 | 891 | 6 |
353839 | 353839 | 2020-07-21 | Calhoun | Alabama | 1015 | 869 | 6 |
350637 | 350637 | 2020-07-20 | Calhoun | Alabama | 1015 | 832 | 6 |
347436 | 347436 | 2020-07-19 | Calhoun | Alabama | 1015 | 785 | 6 |
344236 | 344236 | 2020-07-18 | Calhoun | Alabama | 1015 | 741 | 6 |
341037 | 341037 | 2020-07-17 | Calhoun | Alabama | 1015 | 720 | 6 |
337841 | 337841 | 2020-07-16 | Calhoun | Alabama | 1015 | 675 | 6 |
334646 | 334646 | 2020-07-15 | Calhoun | Alabama | 1015 | 655 | 6 |
331453 | 331453 | 2020-07-14 | Calhoun | Alabama | 1015 | 589 | 6 |
328267 | 328267 | 2020-07-13 | Calhoun | Alabama | 1015 | 566 | 5 |
325081 | 325081 | 2020-07-12 | Calhoun | Alabama | 1015 | 526 | 5 |
321900 | 321900 | 2020-07-11 | Calhoun | Alabama | 1015 | 500 | 5 |
318721 | 318721 | 2020-07-10 | Calhoun | Alabama | 1015 | 465 | 5 |
315548 | 315548 | 2020-07-09 | Calhoun | Alabama | 1015 | 445 | 5 |
312373 | 312373 | 2020-07-08 | Calhoun | Alabama | 1015 | 411 | 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);