ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Limestone" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
917234 | 917234 | 2021-01-11 | Limestone | Alabama | 1083 | 7638 | 60 |
913989 | 913989 | 2021-01-10 | Limestone | Alabama | 1083 | 7599 | 60 |
910744 | 910744 | 2021-01-09 | Limestone | Alabama | 1083 | 7548 | 60 |
907499 | 907499 | 2021-01-08 | Limestone | Alabama | 1083 | 7426 | 60 |
904253 | 904253 | 2021-01-07 | Limestone | Alabama | 1083 | 7337 | 60 |
901008 | 901008 | 2021-01-06 | Limestone | Alabama | 1083 | 7240 | 59 |
897763 | 897763 | 2021-01-05 | Limestone | Alabama | 1083 | 7132 | 58 |
894517 | 894517 | 2021-01-04 | Limestone | Alabama | 1083 | 7085 | 58 |
891271 | 891271 | 2021-01-03 | Limestone | Alabama | 1083 | 7037 | 58 |
888024 | 888024 | 2021-01-02 | Limestone | Alabama | 1083 | 6992 | 58 |
884779 | 884779 | 2021-01-01 | Limestone | Alabama | 1083 | 6879 | 58 |
881534 | 881534 | 2020-12-31 | Limestone | Alabama | 1083 | 6822 | 58 |
878289 | 878289 | 2020-12-30 | Limestone | Alabama | 1083 | 6724 | 56 |
875044 | 875044 | 2020-12-29 | Limestone | Alabama | 1083 | 6628 | 55 |
871799 | 871799 | 2020-12-28 | Limestone | Alabama | 1083 | 6561 | 55 |
868554 | 868554 | 2020-12-27 | Limestone | Alabama | 1083 | 6511 | 55 |
865309 | 865309 | 2020-12-26 | Limestone | Alabama | 1083 | 6479 | 55 |
862064 | 862064 | 2020-12-25 | Limestone | Alabama | 1083 | 6459 | 55 |
858819 | 858819 | 2020-12-24 | Limestone | Alabama | 1083 | 6369 | 55 |
855574 | 855574 | 2020-12-23 | Limestone | Alabama | 1083 | 6268 | 54 |
852329 | 852329 | 2020-12-22 | Limestone | Alabama | 1083 | 6166 | 52 |
849084 | 849084 | 2020-12-21 | Limestone | Alabama | 1083 | 6052 | 52 |
845839 | 845839 | 2020-12-20 | Limestone | Alabama | 1083 | 5987 | 52 |
842593 | 842593 | 2020-12-19 | Limestone | Alabama | 1083 | 5923 | 52 |
839348 | 839348 | 2020-12-18 | Limestone | Alabama | 1083 | 5821 | 51 |
836103 | 836103 | 2020-12-17 | Limestone | Alabama | 1083 | 5668 | 50 |
832857 | 832857 | 2020-12-16 | Limestone | Alabama | 1083 | 5545 | 50 |
829610 | 829610 | 2020-12-15 | Limestone | Alabama | 1083 | 5457 | 49 |
826364 | 826364 | 2020-12-14 | Limestone | Alabama | 1083 | 5377 | 49 |
823117 | 823117 | 2020-12-13 | Limestone | Alabama | 1083 | 5315 | 49 |
819871 | 819871 | 2020-12-12 | Limestone | Alabama | 1083 | 5244 | 49 |
816625 | 816625 | 2020-12-11 | Limestone | Alabama | 1083 | 5147 | 49 |
813379 | 813379 | 2020-12-10 | Limestone | Alabama | 1083 | 5068 | 49 |
810135 | 810135 | 2020-12-09 | Limestone | Alabama | 1083 | 4977 | 48 |
806890 | 806890 | 2020-12-08 | Limestone | Alabama | 1083 | 4905 | 48 |
803645 | 803645 | 2020-12-07 | Limestone | Alabama | 1083 | 4808 | 48 |
800400 | 800400 | 2020-12-06 | Limestone | Alabama | 1083 | 4744 | 48 |
797155 | 797155 | 2020-12-05 | Limestone | Alabama | 1083 | 4697 | 47 |
793910 | 793910 | 2020-12-04 | Limestone | Alabama | 1083 | 4624 | 46 |
790665 | 790665 | 2020-12-03 | Limestone | Alabama | 1083 | 4550 | 46 |
787420 | 787420 | 2020-12-02 | Limestone | Alabama | 1083 | 4475 | 46 |
784176 | 784176 | 2020-12-01 | Limestone | Alabama | 1083 | 4404 | 45 |
780931 | 780931 | 2020-11-30 | Limestone | Alabama | 1083 | 4333 | 45 |
777685 | 777685 | 2020-11-29 | Limestone | Alabama | 1083 | 4302 | 45 |
774440 | 774440 | 2020-11-28 | Limestone | Alabama | 1083 | 4251 | 45 |
771195 | 771195 | 2020-11-27 | Limestone | Alabama | 1083 | 4206 | 45 |
767949 | 767949 | 2020-11-26 | Limestone | Alabama | 1083 | 4186 | 45 |
764704 | 764704 | 2020-11-25 | Limestone | Alabama | 1083 | 4137 | 44 |
761459 | 761459 | 2020-11-24 | Limestone | Alabama | 1083 | 4088 | 44 |
758214 | 758214 | 2020-11-23 | Limestone | Alabama | 1083 | 4045 | 44 |
754967 | 754967 | 2020-11-22 | Limestone | Alabama | 1083 | 4008 | 44 |
751721 | 751721 | 2020-11-21 | Limestone | Alabama | 1083 | 3970 | 44 |
748475 | 748475 | 2020-11-20 | Limestone | Alabama | 1083 | 3901 | 44 |
745229 | 745229 | 2020-11-19 | Limestone | Alabama | 1083 | 3834 | 44 |
741982 | 741982 | 2020-11-18 | Limestone | Alabama | 1083 | 3759 | 42 |
738735 | 738735 | 2020-11-17 | Limestone | Alabama | 1083 | 3723 | 42 |
735491 | 735491 | 2020-11-16 | Limestone | Alabama | 1083 | 3689 | 41 |
732245 | 732245 | 2020-11-15 | Limestone | Alabama | 1083 | 3653 | 41 |
729000 | 729000 | 2020-11-14 | Limestone | Alabama | 1083 | 3615 | 41 |
725757 | 725757 | 2020-11-13 | Limestone | Alabama | 1083 | 3577 | 41 |
722514 | 722514 | 2020-11-12 | Limestone | Alabama | 1083 | 3512 | 38 |
719271 | 719271 | 2020-11-11 | Limestone | Alabama | 1083 | 3457 | 38 |
716028 | 716028 | 2020-11-10 | Limestone | Alabama | 1083 | 3414 | 37 |
712784 | 712784 | 2020-11-09 | Limestone | Alabama | 1083 | 3380 | 37 |
709540 | 709540 | 2020-11-08 | Limestone | Alabama | 1083 | 3350 | 37 |
706296 | 706296 | 2020-11-07 | Limestone | Alabama | 1083 | 3311 | 37 |
703053 | 703053 | 2020-11-06 | Limestone | Alabama | 1083 | 3271 | 37 |
699810 | 699810 | 2020-11-05 | Limestone | Alabama | 1083 | 3231 | 36 |
696566 | 696566 | 2020-11-04 | Limestone | Alabama | 1083 | 3200 | 35 |
693324 | 693324 | 2020-11-03 | Limestone | Alabama | 1083 | 3166 | 34 |
690081 | 690081 | 2020-11-02 | Limestone | Alabama | 1083 | 3141 | 34 |
686836 | 686836 | 2020-11-01 | Limestone | Alabama | 1083 | 3108 | 34 |
683592 | 683592 | 2020-10-31 | Limestone | Alabama | 1083 | 3031 | 34 |
680349 | 680349 | 2020-10-30 | Limestone | Alabama | 1083 | 3003 | 33 |
677106 | 677106 | 2020-10-29 | Limestone | Alabama | 1083 | 2970 | 31 |
673863 | 673863 | 2020-10-28 | Limestone | Alabama | 1083 | 2951 | 31 |
670621 | 670621 | 2020-10-27 | Limestone | Alabama | 1083 | 2936 | 31 |
667378 | 667378 | 2020-10-26 | Limestone | Alabama | 1083 | 2893 | 30 |
664133 | 664133 | 2020-10-25 | Limestone | Alabama | 1083 | 2872 | 30 |
660889 | 660889 | 2020-10-24 | Limestone | Alabama | 1083 | 2842 | 30 |
657645 | 657645 | 2020-10-23 | Limestone | Alabama | 1083 | 2797 | 30 |
654400 | 654400 | 2020-10-22 | Limestone | Alabama | 1083 | 2765 | 30 |
651155 | 651155 | 2020-10-21 | Limestone | Alabama | 1083 | 2736 | 30 |
647911 | 647911 | 2020-10-20 | Limestone | Alabama | 1083 | 2708 | 28 |
644666 | 644666 | 2020-10-19 | Limestone | Alabama | 1083 | 2692 | 27 |
641418 | 641418 | 2020-10-18 | Limestone | Alabama | 1083 | 2683 | 27 |
638171 | 638171 | 2020-10-17 | Limestone | Alabama | 1083 | 2658 | 27 |
634926 | 634926 | 2020-10-16 | Limestone | Alabama | 1083 | 2638 | 27 |
631681 | 631681 | 2020-10-15 | Limestone | Alabama | 1083 | 2605 | 27 |
628437 | 628437 | 2020-10-14 | Limestone | Alabama | 1083 | 2574 | 25 |
625194 | 625194 | 2020-10-13 | Limestone | Alabama | 1083 | 2541 | 23 |
621951 | 621951 | 2020-10-12 | Limestone | Alabama | 1083 | 2523 | 23 |
618708 | 618708 | 2020-10-11 | Limestone | Alabama | 1083 | 2502 | 23 |
615466 | 615466 | 2020-10-10 | Limestone | Alabama | 1083 | 2478 | 23 |
612225 | 612225 | 2020-10-09 | Limestone | Alabama | 1083 | 2439 | 23 |
608983 | 608983 | 2020-10-08 | Limestone | Alabama | 1083 | 2396 | 23 |
605740 | 605740 | 2020-10-07 | Limestone | Alabama | 1083 | 2368 | 22 |
602498 | 602498 | 2020-10-06 | Limestone | Alabama | 1083 | 2330 | 22 |
599255 | 599255 | 2020-10-05 | Limestone | Alabama | 1083 | 2298 | 22 |
596012 | 596012 | 2020-10-04 | Limestone | Alabama | 1083 | 2258 | 22 |
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);