ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "St. Clair" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
917251 | 917251 | 2021-01-11 | St. Clair | Alabama | 1115 | 7250 | 115 |
914006 | 914006 | 2021-01-10 | St. Clair | Alabama | 1115 | 7213 | 115 |
910761 | 910761 | 2021-01-09 | St. Clair | Alabama | 1115 | 7167 | 115 |
907516 | 907516 | 2021-01-08 | St. Clair | Alabama | 1115 | 7055 | 74 |
904270 | 904270 | 2021-01-07 | St. Clair | Alabama | 1115 | 6991 | 74 |
901025 | 901025 | 2021-01-06 | St. Clair | Alabama | 1115 | 6922 | 73 |
897780 | 897780 | 2021-01-05 | St. Clair | Alabama | 1115 | 6873 | 73 |
894534 | 894534 | 2021-01-04 | St. Clair | Alabama | 1115 | 6799 | 73 |
891288 | 891288 | 2021-01-03 | St. Clair | Alabama | 1115 | 6752 | 73 |
888041 | 888041 | 2021-01-02 | St. Clair | Alabama | 1115 | 6709 | 73 |
884796 | 884796 | 2021-01-01 | St. Clair | Alabama | 1115 | 6577 | 73 |
881551 | 881551 | 2020-12-31 | St. Clair | Alabama | 1115 | 6467 | 73 |
878306 | 878306 | 2020-12-30 | St. Clair | Alabama | 1115 | 6416 | 72 |
875061 | 875061 | 2020-12-29 | St. Clair | Alabama | 1115 | 6351 | 71 |
871816 | 871816 | 2020-12-28 | St. Clair | Alabama | 1115 | 6280 | 71 |
868571 | 868571 | 2020-12-27 | St. Clair | Alabama | 1115 | 6232 | 71 |
865326 | 865326 | 2020-12-26 | St. Clair | Alabama | 1115 | 6193 | 71 |
862081 | 862081 | 2020-12-25 | St. Clair | Alabama | 1115 | 6172 | 71 |
858836 | 858836 | 2020-12-24 | St. Clair | Alabama | 1115 | 6077 | 71 |
855591 | 855591 | 2020-12-23 | St. Clair | Alabama | 1115 | 6015 | 69 |
852346 | 852346 | 2020-12-22 | St. Clair | Alabama | 1115 | 5960 | 64 |
849101 | 849101 | 2020-12-21 | St. Clair | Alabama | 1115 | 5814 | 63 |
845856 | 845856 | 2020-12-20 | St. Clair | Alabama | 1115 | 5770 | 63 |
842610 | 842610 | 2020-12-19 | St. Clair | Alabama | 1115 | 5722 | 63 |
839365 | 839365 | 2020-12-18 | St. Clair | Alabama | 1115 | 5648 | 63 |
836120 | 836120 | 2020-12-17 | St. Clair | Alabama | 1115 | 5567 | 63 |
832874 | 832874 | 2020-12-16 | St. Clair | Alabama | 1115 | 5465 | 62 |
829627 | 829627 | 2020-12-15 | St. Clair | Alabama | 1115 | 5391 | 62 |
826381 | 826381 | 2020-12-14 | St. Clair | Alabama | 1115 | 5323 | 62 |
823134 | 823134 | 2020-12-13 | St. Clair | Alabama | 1115 | 5261 | 62 |
819888 | 819888 | 2020-12-12 | St. Clair | Alabama | 1115 | 5210 | 62 |
816642 | 816642 | 2020-12-11 | St. Clair | Alabama | 1115 | 5107 | 62 |
813396 | 813396 | 2020-12-10 | St. Clair | Alabama | 1115 | 5058 | 60 |
810152 | 810152 | 2020-12-09 | St. Clair | Alabama | 1115 | 4995 | 60 |
806907 | 806907 | 2020-12-08 | St. Clair | Alabama | 1115 | 4938 | 57 |
803662 | 803662 | 2020-12-07 | St. Clair | Alabama | 1115 | 4815 | 57 |
800417 | 800417 | 2020-12-06 | St. Clair | Alabama | 1115 | 4768 | 57 |
797172 | 797172 | 2020-12-05 | St. Clair | Alabama | 1115 | 4733 | 57 |
793927 | 793927 | 2020-12-04 | St. Clair | Alabama | 1115 | 4665 | 57 |
790682 | 790682 | 2020-12-03 | St. Clair | Alabama | 1115 | 4603 | 57 |
787437 | 787437 | 2020-12-02 | St. Clair | Alabama | 1115 | 4518 | 57 |
784193 | 784193 | 2020-12-01 | St. Clair | Alabama | 1115 | 4419 | 56 |
780948 | 780948 | 2020-11-30 | St. Clair | Alabama | 1115 | 4325 | 55 |
777702 | 777702 | 2020-11-29 | St. Clair | Alabama | 1115 | 4257 | 55 |
774457 | 774457 | 2020-11-28 | St. Clair | Alabama | 1115 | 4195 | 55 |
771212 | 771212 | 2020-11-27 | St. Clair | Alabama | 1115 | 4158 | 55 |
767966 | 767966 | 2020-11-26 | St. Clair | Alabama | 1115 | 4136 | 55 |
764721 | 764721 | 2020-11-25 | St. Clair | Alabama | 1115 | 4090 | 55 |
761476 | 761476 | 2020-11-24 | St. Clair | Alabama | 1115 | 4039 | 55 |
758231 | 758231 | 2020-11-23 | St. Clair | Alabama | 1115 | 3984 | 55 |
754984 | 754984 | 2020-11-22 | St. Clair | Alabama | 1115 | 3960 | 55 |
751738 | 751738 | 2020-11-21 | St. Clair | Alabama | 1115 | 3930 | 55 |
748492 | 748492 | 2020-11-20 | St. Clair | Alabama | 1115 | 3891 | 55 |
745246 | 745246 | 2020-11-19 | St. Clair | Alabama | 1115 | 3856 | 55 |
741999 | 741999 | 2020-11-18 | St. Clair | Alabama | 1115 | 3820 | 55 |
738752 | 738752 | 2020-11-17 | St. Clair | Alabama | 1115 | 3764 | 55 |
735508 | 735508 | 2020-11-16 | St. Clair | Alabama | 1115 | 3750 | 55 |
732262 | 732262 | 2020-11-15 | St. Clair | Alabama | 1115 | 3736 | 55 |
729017 | 729017 | 2020-11-14 | St. Clair | Alabama | 1115 | 3709 | 55 |
725774 | 725774 | 2020-11-13 | St. Clair | Alabama | 1115 | 3668 | 54 |
722531 | 722531 | 2020-11-12 | St. Clair | Alabama | 1115 | 3613 | 54 |
719288 | 719288 | 2020-11-11 | St. Clair | Alabama | 1115 | 3580 | 54 |
716045 | 716045 | 2020-11-10 | St. Clair | Alabama | 1115 | 3537 | 52 |
712801 | 712801 | 2020-11-09 | St. Clair | Alabama | 1115 | 3499 | 52 |
709557 | 709557 | 2020-11-08 | St. Clair | Alabama | 1115 | 3477 | 52 |
706313 | 706313 | 2020-11-07 | St. Clair | Alabama | 1115 | 3447 | 52 |
703070 | 703070 | 2020-11-06 | St. Clair | Alabama | 1115 | 3417 | 52 |
699827 | 699827 | 2020-11-05 | St. Clair | Alabama | 1115 | 3378 | 51 |
696583 | 696583 | 2020-11-04 | St. Clair | Alabama | 1115 | 3357 | 50 |
693341 | 693341 | 2020-11-03 | St. Clair | Alabama | 1115 | 3298 | 46 |
690098 | 690098 | 2020-11-02 | St. Clair | Alabama | 1115 | 3254 | 43 |
686853 | 686853 | 2020-11-01 | St. Clair | Alabama | 1115 | 3240 | 43 |
683609 | 683609 | 2020-10-31 | St. Clair | Alabama | 1115 | 3206 | 43 |
680366 | 680366 | 2020-10-30 | St. Clair | Alabama | 1115 | 3138 | 43 |
677123 | 677123 | 2020-10-29 | St. Clair | Alabama | 1115 | 3113 | 42 |
673880 | 673880 | 2020-10-28 | St. Clair | Alabama | 1115 | 3070 | 42 |
670638 | 670638 | 2020-10-27 | St. Clair | Alabama | 1115 | 3040 | 42 |
667395 | 667395 | 2020-10-26 | St. Clair | Alabama | 1115 | 2999 | 42 |
664150 | 664150 | 2020-10-25 | St. Clair | Alabama | 1115 | 2955 | 42 |
660906 | 660906 | 2020-10-24 | St. Clair | Alabama | 1115 | 2925 | 42 |
657662 | 657662 | 2020-10-23 | St. Clair | Alabama | 1115 | 2891 | 42 |
654417 | 654417 | 2020-10-22 | St. Clair | Alabama | 1115 | 2871 | 42 |
651172 | 651172 | 2020-10-21 | St. Clair | Alabama | 1115 | 2838 | 42 |
647928 | 647928 | 2020-10-20 | St. Clair | Alabama | 1115 | 2821 | 42 |
644683 | 644683 | 2020-10-19 | St. Clair | Alabama | 1115 | 2797 | 42 |
641435 | 641435 | 2020-10-18 | St. Clair | Alabama | 1115 | 2767 | 42 |
638188 | 638188 | 2020-10-17 | St. Clair | Alabama | 1115 | 2735 | 42 |
634943 | 634943 | 2020-10-16 | St. Clair | Alabama | 1115 | 2705 | 42 |
631698 | 631698 | 2020-10-15 | St. Clair | Alabama | 1115 | 2676 | 42 |
628454 | 628454 | 2020-10-14 | St. Clair | Alabama | 1115 | 2647 | 41 |
625211 | 625211 | 2020-10-13 | St. Clair | Alabama | 1115 | 2631 | 41 |
621968 | 621968 | 2020-10-12 | St. Clair | Alabama | 1115 | 2590 | 41 |
618725 | 618725 | 2020-10-11 | St. Clair | Alabama | 1115 | 2582 | 41 |
615483 | 615483 | 2020-10-10 | St. Clair | Alabama | 1115 | 2573 | 41 |
612242 | 612242 | 2020-10-09 | St. Clair | Alabama | 1115 | 2557 | 41 |
609000 | 609000 | 2020-10-08 | St. Clair | Alabama | 1115 | 2521 | 38 |
605757 | 605757 | 2020-10-07 | St. Clair | Alabama | 1115 | 2510 | 38 |
602515 | 602515 | 2020-10-06 | St. Clair | Alabama | 1115 | 2491 | 38 |
599272 | 599272 | 2020-10-05 | St. Clair | Alabama | 1115 | 2474 | 37 |
596029 | 596029 | 2020-10-04 | St. Clair | Alabama | 1115 | 2461 | 37 |
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);