ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 1093 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1050305 | 1050305 | 2021-02-21 | Marion | Alabama | 1093 | 2736 | 92 |
1047058 | 1047058 | 2021-02-20 | Marion | Alabama | 1093 | 2729 | 92 |
1043813 | 1043813 | 2021-02-19 | Marion | Alabama | 1093 | 2730 | 92 |
1040568 | 1040568 | 2021-02-18 | Marion | Alabama | 1093 | 2725 | 92 |
1037323 | 1037323 | 2021-02-17 | Marion | Alabama | 1093 | 2716 | 91 |
1034078 | 1034078 | 2021-02-16 | Marion | Alabama | 1093 | 2714 | 91 |
1030832 | 1030832 | 2021-02-15 | Marion | Alabama | 1093 | 2709 | 91 |
1027585 | 1027585 | 2021-02-14 | Marion | Alabama | 1093 | 2706 | 91 |
1024340 | 1024340 | 2021-02-13 | Marion | Alabama | 1093 | 2702 | 91 |
1021095 | 1021095 | 2021-02-12 | Marion | Alabama | 1093 | 2698 | 88 |
1017850 | 1017850 | 2021-02-11 | Marion | Alabama | 1093 | 2691 | 87 |
1014605 | 1014605 | 2021-02-10 | Marion | Alabama | 1093 | 2691 | 86 |
1011360 | 1011360 | 2021-02-09 | Marion | Alabama | 1093 | 2678 | 82 |
1008114 | 1008114 | 2021-02-08 | Marion | Alabama | 1093 | 2664 | 81 |
1004868 | 1004868 | 2021-02-07 | Marion | Alabama | 1093 | 2659 | 81 |
1001622 | 1001622 | 2021-02-06 | Marion | Alabama | 1093 | 2654 | 81 |
998376 | 998376 | 2021-02-05 | Marion | Alabama | 1093 | 2651 | 81 |
995130 | 995130 | 2021-02-04 | Marion | Alabama | 1093 | 2644 | 81 |
991884 | 991884 | 2021-02-03 | Marion | Alabama | 1093 | 2641 | 80 |
988638 | 988638 | 2021-02-02 | Marion | Alabama | 1093 | 2632 | 76 |
985391 | 985391 | 2021-02-01 | Marion | Alabama | 1093 | 2617 | 74 |
982144 | 982144 | 2021-01-31 | Marion | Alabama | 1093 | 2613 | 74 |
978898 | 978898 | 2021-01-30 | Marion | Alabama | 1093 | 2597 | 73 |
975653 | 975653 | 2021-01-29 | Marion | Alabama | 1093 | 2597 | 73 |
972408 | 972408 | 2021-01-28 | Marion | Alabama | 1093 | 2585 | 69 |
969163 | 969163 | 2021-01-27 | Marion | Alabama | 1093 | 2566 | 67 |
965919 | 965919 | 2021-01-26 | Marion | Alabama | 1093 | 2557 | 63 |
962674 | 962674 | 2021-01-25 | Marion | Alabama | 1093 | 2546 | 61 |
959429 | 959429 | 2021-01-24 | Marion | Alabama | 1093 | 2537 | 61 |
956183 | 956183 | 2021-01-23 | Marion | Alabama | 1093 | 2531 | 61 |
952938 | 952938 | 2021-01-22 | Marion | Alabama | 1093 | 2515 | 58 |
949693 | 949693 | 2021-01-21 | Marion | Alabama | 1093 | 2501 | 55 |
946447 | 946447 | 2021-01-20 | Marion | Alabama | 1093 | 2489 | 53 |
943200 | 943200 | 2021-01-19 | Marion | Alabama | 1093 | 2473 | 50 |
939955 | 939955 | 2021-01-18 | Marion | Alabama | 1093 | 2462 | 50 |
936710 | 936710 | 2021-01-17 | Marion | Alabama | 1093 | 2456 | 50 |
933465 | 933465 | 2021-01-16 | Marion | Alabama | 1093 | 2446 | 50 |
930220 | 930220 | 2021-01-15 | Marion | Alabama | 1093 | 2405 | 49 |
926975 | 926975 | 2021-01-14 | Marion | Alabama | 1093 | 2386 | 49 |
923729 | 923729 | 2021-01-13 | Marion | Alabama | 1093 | 2372 | 49 |
920484 | 920484 | 2021-01-12 | Marion | Alabama | 1093 | 2358 | 47 |
917239 | 917239 | 2021-01-11 | Marion | Alabama | 1093 | 2335 | 46 |
913994 | 913994 | 2021-01-10 | Marion | Alabama | 1093 | 2320 | 46 |
910749 | 910749 | 2021-01-09 | Marion | Alabama | 1093 | 2304 | 46 |
907504 | 907504 | 2021-01-08 | Marion | Alabama | 1093 | 2281 | 46 |
904258 | 904258 | 2021-01-07 | Marion | Alabama | 1093 | 2248 | 46 |
901013 | 901013 | 2021-01-06 | Marion | Alabama | 1093 | 2223 | 45 |
897768 | 897768 | 2021-01-05 | Marion | Alabama | 1093 | 2190 | 43 |
894522 | 894522 | 2021-01-04 | Marion | Alabama | 1093 | 2164 | 43 |
891276 | 891276 | 2021-01-03 | Marion | Alabama | 1093 | 2152 | 43 |
888029 | 888029 | 2021-01-02 | Marion | Alabama | 1093 | 2134 | 43 |
884784 | 884784 | 2021-01-01 | Marion | Alabama | 1093 | 2112 | 43 |
881539 | 881539 | 2020-12-31 | Marion | Alabama | 1093 | 2087 | 43 |
878294 | 878294 | 2020-12-30 | Marion | Alabama | 1093 | 2049 | 43 |
875049 | 875049 | 2020-12-29 | Marion | Alabama | 1093 | 2019 | 43 |
871804 | 871804 | 2020-12-28 | Marion | Alabama | 1093 | 2004 | 43 |
868559 | 868559 | 2020-12-27 | Marion | Alabama | 1093 | 1997 | 43 |
865314 | 865314 | 2020-12-26 | Marion | Alabama | 1093 | 1990 | 43 |
862069 | 862069 | 2020-12-25 | Marion | Alabama | 1093 | 1986 | 43 |
858824 | 858824 | 2020-12-24 | Marion | Alabama | 1093 | 1952 | 43 |
855579 | 855579 | 2020-12-23 | Marion | Alabama | 1093 | 1933 | 43 |
852334 | 852334 | 2020-12-22 | Marion | Alabama | 1093 | 1913 | 42 |
849089 | 849089 | 2020-12-21 | Marion | Alabama | 1093 | 1880 | 42 |
845844 | 845844 | 2020-12-20 | Marion | Alabama | 1093 | 1853 | 42 |
842598 | 842598 | 2020-12-19 | Marion | Alabama | 1093 | 1841 | 42 |
839353 | 839353 | 2020-12-18 | Marion | Alabama | 1093 | 1813 | 42 |
836108 | 836108 | 2020-12-17 | Marion | Alabama | 1093 | 1779 | 42 |
832862 | 832862 | 2020-12-16 | Marion | Alabama | 1093 | 1739 | 41 |
829615 | 829615 | 2020-12-15 | Marion | Alabama | 1093 | 1716 | 41 |
826369 | 826369 | 2020-12-14 | Marion | Alabama | 1093 | 1708 | 40 |
823122 | 823122 | 2020-12-13 | Marion | Alabama | 1093 | 1684 | 40 |
819876 | 819876 | 2020-12-12 | Marion | Alabama | 1093 | 1669 | 40 |
816630 | 816630 | 2020-12-11 | Marion | Alabama | 1093 | 1648 | 39 |
813384 | 813384 | 2020-12-10 | Marion | Alabama | 1093 | 1632 | 39 |
810140 | 810140 | 2020-12-09 | Marion | Alabama | 1093 | 1597 | 37 |
806895 | 806895 | 2020-12-08 | Marion | Alabama | 1093 | 1585 | 36 |
803650 | 803650 | 2020-12-07 | Marion | Alabama | 1093 | 1558 | 36 |
800405 | 800405 | 2020-12-06 | Marion | Alabama | 1093 | 1537 | 36 |
797160 | 797160 | 2020-12-05 | Marion | Alabama | 1093 | 1530 | 36 |
793915 | 793915 | 2020-12-04 | Marion | Alabama | 1093 | 1502 | 36 |
790670 | 790670 | 2020-12-03 | Marion | Alabama | 1093 | 1482 | 36 |
787425 | 787425 | 2020-12-02 | Marion | Alabama | 1093 | 1461 | 36 |
784181 | 784181 | 2020-12-01 | Marion | Alabama | 1093 | 1447 | 36 |
780936 | 780936 | 2020-11-30 | Marion | Alabama | 1093 | 1436 | 36 |
777690 | 777690 | 2020-11-29 | Marion | Alabama | 1093 | 1413 | 36 |
774445 | 774445 | 2020-11-28 | Marion | Alabama | 1093 | 1402 | 36 |
771200 | 771200 | 2020-11-27 | Marion | Alabama | 1093 | 1379 | 36 |
767954 | 767954 | 2020-11-26 | Marion | Alabama | 1093 | 1371 | 36 |
764709 | 764709 | 2020-11-25 | Marion | Alabama | 1093 | 1365 | 35 |
761464 | 761464 | 2020-11-24 | Marion | Alabama | 1093 | 1355 | 35 |
758219 | 758219 | 2020-11-23 | Marion | Alabama | 1093 | 1345 | 35 |
754972 | 754972 | 2020-11-22 | Marion | Alabama | 1093 | 1339 | 35 |
751726 | 751726 | 2020-11-21 | Marion | Alabama | 1093 | 1330 | 35 |
748480 | 748480 | 2020-11-20 | Marion | Alabama | 1093 | 1320 | 33 |
745234 | 745234 | 2020-11-19 | Marion | Alabama | 1093 | 1303 | 33 |
741987 | 741987 | 2020-11-18 | Marion | Alabama | 1093 | 1300 | 33 |
738740 | 738740 | 2020-11-17 | Marion | Alabama | 1093 | 1294 | 33 |
735496 | 735496 | 2020-11-16 | Marion | Alabama | 1093 | 1284 | 32 |
732250 | 732250 | 2020-11-15 | Marion | Alabama | 1093 | 1276 | 32 |
729005 | 729005 | 2020-11-14 | Marion | Alabama | 1093 | 1263 | 32 |
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);