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 |
---|---|---|---|---|---|---|---|
1193155 | 1193155 | 2021-04-06 | Marion | Alabama | 1093 | 3063 | 101 |
1189905 | 1189905 | 2021-04-05 | Marion | Alabama | 1093 | 3066 | 101 |
1186658 | 1186658 | 2021-04-04 | Marion | Alabama | 1093 | 3066 | 101 |
1183411 | 1183411 | 2021-04-03 | Marion | Alabama | 1093 | 3065 | 101 |
1180164 | 1180164 | 2021-04-02 | Marion | Alabama | 1093 | 3064 | 101 |
1176917 | 1176917 | 2021-04-01 | Marion | Alabama | 1093 | 3063 | 99 |
1173670 | 1173670 | 2021-03-31 | Marion | Alabama | 1093 | 3062 | 99 |
1170423 | 1170423 | 2021-03-30 | Marion | Alabama | 1093 | 3056 | 99 |
1167175 | 1167175 | 2021-03-29 | Marion | Alabama | 1093 | 3050 | 99 |
1163927 | 1163927 | 2021-03-28 | Marion | Alabama | 1093 | 3050 | 99 |
1160679 | 1160679 | 2021-03-27 | Marion | Alabama | 1093 | 3049 | 99 |
1157431 | 1157431 | 2021-03-26 | Marion | Alabama | 1093 | 3049 | 99 |
1154184 | 1154184 | 2021-03-25 | Marion | Alabama | 1093 | 3046 | 99 |
1150937 | 1150937 | 2021-03-24 | Marion | Alabama | 1093 | 3044 | 99 |
1147690 | 1147690 | 2021-03-23 | Marion | Alabama | 1093 | 3040 | 99 |
1144443 | 1144443 | 2021-03-22 | Marion | Alabama | 1093 | 3042 | 99 |
1141196 | 1141196 | 2021-03-21 | Marion | Alabama | 1093 | 3042 | 99 |
1137950 | 1137950 | 2021-03-20 | Marion | Alabama | 1093 | 3042 | 99 |
1134704 | 1134704 | 2021-03-19 | Marion | Alabama | 1093 | 3042 | 99 |
1131456 | 1131456 | 2021-03-18 | Marion | Alabama | 1093 | 3042 | 99 |
1128209 | 1128209 | 2021-03-17 | Marion | Alabama | 1093 | 3041 | 98 |
1124963 | 1124963 | 2021-03-16 | Marion | Alabama | 1093 | 3031 | 98 |
1121717 | 1121717 | 2021-03-15 | Marion | Alabama | 1093 | 3011 | 98 |
1118470 | 1118470 | 2021-03-14 | Marion | Alabama | 1093 | 2948 | 98 |
1115223 | 1115223 | 2021-03-13 | Marion | Alabama | 1093 | 2948 | 98 |
1111977 | 1111977 | 2021-03-12 | Marion | Alabama | 1093 | 2945 | 98 |
1108731 | 1108731 | 2021-03-11 | Marion | Alabama | 1093 | 2939 | 97 |
1105485 | 1105485 | 2021-03-10 | Marion | Alabama | 1093 | 2933 | 97 |
1102239 | 1102239 | 2021-03-09 | Marion | Alabama | 1093 | 2909 | 96 |
1098993 | 1098993 | 2021-03-08 | Marion | Alabama | 1093 | 2890 | 96 |
1095745 | 1095745 | 2021-03-07 | Marion | Alabama | 1093 | 2889 | 96 |
1092499 | 1092499 | 2021-03-06 | Marion | Alabama | 1093 | 2887 | 96 |
1089253 | 1089253 | 2021-03-05 | Marion | Alabama | 1093 | 2885 | 95 |
1086008 | 1086008 | 2021-03-04 | Marion | Alabama | 1093 | 2886 | 95 |
1082762 | 1082762 | 2021-03-03 | Marion | Alabama | 1093 | 2888 | 95 |
1079516 | 1079516 | 2021-03-02 | Marion | Alabama | 1093 | 2834 | 95 |
1076271 | 1076271 | 2021-03-01 | Marion | Alabama | 1093 | 2819 | 95 |
1073025 | 1073025 | 2021-02-28 | Marion | Alabama | 1093 | 2818 | 95 |
1069779 | 1069779 | 2021-02-27 | Marion | Alabama | 1093 | 2816 | 95 |
1066534 | 1066534 | 2021-02-26 | Marion | Alabama | 1093 | 2812 | 95 |
1063289 | 1063289 | 2021-02-25 | Marion | Alabama | 1093 | 2808 | 94 |
1060044 | 1060044 | 2021-02-24 | Marion | Alabama | 1093 | 2807 | 93 |
1056798 | 1056798 | 2021-02-23 | Marion | Alabama | 1093 | 2774 | 92 |
1053552 | 1053552 | 2021-02-22 | Marion | Alabama | 1093 | 2737 | 92 |
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 |
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);