ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where fips = 1025 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1076237 | 1076237 | 2021-03-01 | Clarke | Alabama | 1025 | 3436 | 50 |
1072991 | 1072991 | 2021-02-28 | Clarke | Alabama | 1025 | 3436 | 50 |
1069745 | 1069745 | 2021-02-27 | Clarke | Alabama | 1025 | 3436 | 50 |
1066500 | 1066500 | 2021-02-26 | Clarke | Alabama | 1025 | 3431 | 49 |
1063255 | 1063255 | 2021-02-25 | Clarke | Alabama | 1025 | 3429 | 49 |
1060010 | 1060010 | 2021-02-24 | Clarke | Alabama | 1025 | 3427 | 49 |
1056764 | 1056764 | 2021-02-23 | Clarke | Alabama | 1025 | 3423 | 48 |
1053518 | 1053518 | 2021-02-22 | Clarke | Alabama | 1025 | 3421 | 48 |
1050271 | 1050271 | 2021-02-21 | Clarke | Alabama | 1025 | 3419 | 48 |
1047024 | 1047024 | 2021-02-20 | Clarke | Alabama | 1025 | 3418 | 48 |
1043779 | 1043779 | 2021-02-19 | Clarke | Alabama | 1025 | 3417 | 48 |
1040534 | 1040534 | 2021-02-18 | Clarke | Alabama | 1025 | 3416 | 48 |
1037289 | 1037289 | 2021-02-17 | Clarke | Alabama | 1025 | 3413 | 47 |
1034044 | 1034044 | 2021-02-16 | Clarke | Alabama | 1025 | 3399 | 46 |
1030798 | 1030798 | 2021-02-15 | Clarke | Alabama | 1025 | 3397 | 46 |
1027551 | 1027551 | 2021-02-14 | Clarke | Alabama | 1025 | 3391 | 46 |
1024306 | 1024306 | 2021-02-13 | Clarke | Alabama | 1025 | 3384 | 46 |
1021061 | 1021061 | 2021-02-12 | Clarke | Alabama | 1025 | 3376 | 46 |
1017816 | 1017816 | 2021-02-11 | Clarke | Alabama | 1025 | 3367 | 43 |
1014571 | 1014571 | 2021-02-10 | Clarke | Alabama | 1025 | 3352 | 42 |
1011326 | 1011326 | 2021-02-09 | Clarke | Alabama | 1025 | 3346 | 42 |
1008080 | 1008080 | 2021-02-08 | Clarke | Alabama | 1025 | 3336 | 40 |
1004834 | 1004834 | 2021-02-07 | Clarke | Alabama | 1025 | 3331 | 40 |
1001588 | 1001588 | 2021-02-06 | Clarke | Alabama | 1025 | 3327 | 40 |
998342 | 998342 | 2021-02-05 | Clarke | Alabama | 1025 | 3317 | 40 |
995096 | 995096 | 2021-02-04 | Clarke | Alabama | 1025 | 3302 | 40 |
991850 | 991850 | 2021-02-03 | Clarke | Alabama | 1025 | 3277 | 39 |
988604 | 988604 | 2021-02-02 | Clarke | Alabama | 1025 | 3254 | 38 |
985357 | 985357 | 2021-02-01 | Clarke | Alabama | 1025 | 3228 | 38 |
982110 | 982110 | 2021-01-31 | Clarke | Alabama | 1025 | 3227 | 38 |
978864 | 978864 | 2021-01-30 | Clarke | Alabama | 1025 | 3182 | 38 |
975619 | 975619 | 2021-01-29 | Clarke | Alabama | 1025 | 3182 | 38 |
972374 | 972374 | 2021-01-28 | Clarke | Alabama | 1025 | 3150 | 38 |
969129 | 969129 | 2021-01-27 | Clarke | Alabama | 1025 | 3111 | 39 |
965885 | 965885 | 2021-01-26 | Clarke | Alabama | 1025 | 3073 | 39 |
962640 | 962640 | 2021-01-25 | Clarke | Alabama | 1025 | 3033 | 36 |
959395 | 959395 | 2021-01-24 | Clarke | Alabama | 1025 | 3002 | 36 |
956149 | 956149 | 2021-01-23 | Clarke | Alabama | 1025 | 2980 | 36 |
952904 | 952904 | 2021-01-22 | Clarke | Alabama | 1025 | 2933 | 36 |
949659 | 949659 | 2021-01-21 | Clarke | Alabama | 1025 | 2905 | 36 |
946413 | 946413 | 2021-01-20 | Clarke | Alabama | 1025 | 2878 | 33 |
943166 | 943166 | 2021-01-19 | Clarke | Alabama | 1025 | 2831 | 33 |
939921 | 939921 | 2021-01-18 | Clarke | Alabama | 1025 | 2821 | 33 |
936676 | 936676 | 2021-01-17 | Clarke | Alabama | 1025 | 2814 | 33 |
933431 | 933431 | 2021-01-16 | Clarke | Alabama | 1025 | 2796 | 33 |
930186 | 930186 | 2021-01-15 | Clarke | Alabama | 1025 | 2782 | 33 |
926941 | 926941 | 2021-01-14 | Clarke | Alabama | 1025 | 2729 | 33 |
923695 | 923695 | 2021-01-13 | Clarke | Alabama | 1025 | 2692 | 32 |
920450 | 920450 | 2021-01-12 | Clarke | Alabama | 1025 | 2649 | 26 |
917205 | 917205 | 2021-01-11 | Clarke | Alabama | 1025 | 2643 | 26 |
913960 | 913960 | 2021-01-10 | Clarke | Alabama | 1025 | 2633 | 26 |
910715 | 910715 | 2021-01-09 | Clarke | Alabama | 1025 | 2619 | 26 |
907470 | 907470 | 2021-01-08 | Clarke | Alabama | 1025 | 2575 | 26 |
904224 | 904224 | 2021-01-07 | Clarke | Alabama | 1025 | 2550 | 26 |
900979 | 900979 | 2021-01-06 | Clarke | Alabama | 1025 | 2498 | 26 |
897734 | 897734 | 2021-01-05 | Clarke | Alabama | 1025 | 2483 | 26 |
894488 | 894488 | 2021-01-04 | Clarke | Alabama | 1025 | 2461 | 26 |
891242 | 891242 | 2021-01-03 | Clarke | Alabama | 1025 | 2461 | 26 |
887995 | 887995 | 2021-01-02 | Clarke | Alabama | 1025 | 2438 | 26 |
884750 | 884750 | 2021-01-01 | Clarke | Alabama | 1025 | 2418 | 26 |
881505 | 881505 | 2020-12-31 | Clarke | Alabama | 1025 | 2390 | 25 |
878260 | 878260 | 2020-12-30 | Clarke | Alabama | 1025 | 2357 | 25 |
875015 | 875015 | 2020-12-29 | Clarke | Alabama | 1025 | 2332 | 25 |
871770 | 871770 | 2020-12-28 | Clarke | Alabama | 1025 | 2311 | 25 |
868525 | 868525 | 2020-12-27 | Clarke | Alabama | 1025 | 2299 | 25 |
865280 | 865280 | 2020-12-26 | Clarke | Alabama | 1025 | 2283 | 25 |
862035 | 862035 | 2020-12-25 | Clarke | Alabama | 1025 | 2273 | 25 |
858790 | 858790 | 2020-12-24 | Clarke | Alabama | 1025 | 2255 | 25 |
855545 | 855545 | 2020-12-23 | Clarke | Alabama | 1025 | 2225 | 25 |
852300 | 852300 | 2020-12-22 | Clarke | Alabama | 1025 | 2211 | 25 |
849055 | 849055 | 2020-12-21 | Clarke | Alabama | 1025 | 2191 | 24 |
845810 | 845810 | 2020-12-20 | Clarke | Alabama | 1025 | 2182 | 24 |
842564 | 842564 | 2020-12-19 | Clarke | Alabama | 1025 | 2174 | 24 |
839319 | 839319 | 2020-12-18 | Clarke | Alabama | 1025 | 2154 | 24 |
836074 | 836074 | 2020-12-17 | Clarke | Alabama | 1025 | 2137 | 24 |
832828 | 832828 | 2020-12-16 | Clarke | Alabama | 1025 | 2110 | 24 |
829581 | 829581 | 2020-12-15 | Clarke | Alabama | 1025 | 2101 | 24 |
826335 | 826335 | 2020-12-14 | Clarke | Alabama | 1025 | 2051 | 24 |
823088 | 823088 | 2020-12-13 | Clarke | Alabama | 1025 | 2041 | 24 |
819842 | 819842 | 2020-12-12 | Clarke | Alabama | 1025 | 2033 | 24 |
816596 | 816596 | 2020-12-11 | Clarke | Alabama | 1025 | 1760 | 24 |
813350 | 813350 | 2020-12-10 | Clarke | Alabama | 1025 | 1755 | 23 |
810106 | 810106 | 2020-12-09 | Clarke | Alabama | 1025 | 1707 | 23 |
806861 | 806861 | 2020-12-08 | Clarke | Alabama | 1025 | 1699 | 23 |
803616 | 803616 | 2020-12-07 | Clarke | Alabama | 1025 | 1679 | 22 |
800371 | 800371 | 2020-12-06 | Clarke | Alabama | 1025 | 1671 | 22 |
797126 | 797126 | 2020-12-05 | Clarke | Alabama | 1025 | 1660 | 22 |
793881 | 793881 | 2020-12-04 | Clarke | Alabama | 1025 | 1654 | 22 |
790636 | 790636 | 2020-12-03 | Clarke | Alabama | 1025 | 1641 | 20 |
787391 | 787391 | 2020-12-02 | Clarke | Alabama | 1025 | 1618 | 19 |
784147 | 784147 | 2020-12-01 | Clarke | Alabama | 1025 | 1610 | 19 |
780902 | 780902 | 2020-11-30 | Clarke | Alabama | 1025 | 1598 | 19 |
777656 | 777656 | 2020-11-29 | Clarke | Alabama | 1025 | 1589 | 19 |
774411 | 774411 | 2020-11-28 | Clarke | Alabama | 1025 | 1584 | 19 |
771166 | 771166 | 2020-11-27 | Clarke | Alabama | 1025 | 1580 | 19 |
767920 | 767920 | 2020-11-26 | Clarke | Alabama | 1025 | 1576 | 19 |
764675 | 764675 | 2020-11-25 | Clarke | Alabama | 1025 | 1563 | 19 |
761430 | 761430 | 2020-11-24 | Clarke | Alabama | 1025 | 1553 | 19 |
758185 | 758185 | 2020-11-23 | Clarke | Alabama | 1025 | 1554 | 19 |
754938 | 754938 | 2020-11-22 | Clarke | Alabama | 1025 | 1549 | 19 |
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);