ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where fips = 1041 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499595 | 2499595 | 2022-05-13 | Crenshaw | Alabama | 1041 | 3834 | 100 |
2496337 | 2496337 | 2022-05-12 | Crenshaw | Alabama | 1041 | 3834 | 100 |
2493079 | 2493079 | 2022-05-11 | Crenshaw | Alabama | 1041 | 3834 | 99 |
2489821 | 2489821 | 2022-05-10 | Crenshaw | Alabama | 1041 | 3833 | 99 |
2486564 | 2486564 | 2022-05-09 | Crenshaw | Alabama | 1041 | 3831 | 99 |
2483306 | 2483306 | 2022-05-08 | Crenshaw | Alabama | 1041 | 3830 | 99 |
2480048 | 2480048 | 2022-05-07 | Crenshaw | Alabama | 1041 | 3830 | 99 |
2476790 | 2476790 | 2022-05-06 | Crenshaw | Alabama | 1041 | 3830 | 99 |
2473532 | 2473532 | 2022-05-05 | Crenshaw | Alabama | 1041 | 3830 | 99 |
2470275 | 2470275 | 2022-05-04 | Crenshaw | Alabama | 1041 | 3830 | 99 |
2467019 | 2467019 | 2022-05-03 | Crenshaw | Alabama | 1041 | 3830 | 99 |
2463764 | 2463764 | 2022-05-02 | Crenshaw | Alabama | 1041 | 3830 | 99 |
2460508 | 2460508 | 2022-05-01 | Crenshaw | Alabama | 1041 | 3829 | 99 |
2457252 | 2457252 | 2022-04-30 | Crenshaw | Alabama | 1041 | 3829 | 99 |
2453996 | 2453996 | 2022-04-29 | Crenshaw | Alabama | 1041 | 3829 | 99 |
2450740 | 2450740 | 2022-04-28 | Crenshaw | Alabama | 1041 | 3823 | 99 |
2447484 | 2447484 | 2022-04-27 | Crenshaw | Alabama | 1041 | 3819 | 99 |
2444228 | 2444228 | 2022-04-26 | Crenshaw | Alabama | 1041 | 3817 | 99 |
2440972 | 2440972 | 2022-04-25 | Crenshaw | Alabama | 1041 | 3816 | 99 |
2437716 | 2437716 | 2022-04-24 | Crenshaw | Alabama | 1041 | 3809 | 99 |
2434460 | 2434460 | 2022-04-23 | Crenshaw | Alabama | 1041 | 3809 | 99 |
2431204 | 2431204 | 2022-04-22 | Crenshaw | Alabama | 1041 | 3809 | 99 |
2427948 | 2427948 | 2022-04-21 | Crenshaw | Alabama | 1041 | 3809 | 99 |
2424692 | 2424692 | 2022-04-20 | Crenshaw | Alabama | 1041 | 3807 | 99 |
2421436 | 2421436 | 2022-04-19 | Crenshaw | Alabama | 1041 | 3802 | 99 |
2418180 | 2418180 | 2022-04-18 | Crenshaw | Alabama | 1041 | 3799 | 99 |
2414924 | 2414924 | 2022-04-17 | Crenshaw | Alabama | 1041 | 3799 | 99 |
2411668 | 2411668 | 2022-04-16 | Crenshaw | Alabama | 1041 | 3799 | 99 |
2408412 | 2408412 | 2022-04-15 | Crenshaw | Alabama | 1041 | 3799 | 99 |
2405156 | 2405156 | 2022-04-14 | Crenshaw | Alabama | 1041 | 3799 | 98 |
2401901 | 2401901 | 2022-04-13 | Crenshaw | Alabama | 1041 | 3800 | 98 |
2398646 | 2398646 | 2022-04-12 | Crenshaw | Alabama | 1041 | 3800 | 98 |
2395391 | 2395391 | 2022-04-11 | Crenshaw | Alabama | 1041 | 3799 | 98 |
2392135 | 2392135 | 2022-04-10 | Crenshaw | Alabama | 1041 | 3799 | 98 |
2388879 | 2388879 | 2022-04-09 | Crenshaw | Alabama | 1041 | 3799 | 98 |
2385624 | 2385624 | 2022-04-08 | Crenshaw | Alabama | 1041 | 3799 | 98 |
2382369 | 2382369 | 2022-04-07 | Crenshaw | Alabama | 1041 | 3798 | 98 |
2379114 | 2379114 | 2022-04-06 | Crenshaw | Alabama | 1041 | 3798 | 98 |
2375860 | 2375860 | 2022-04-05 | Crenshaw | Alabama | 1041 | 3798 | 98 |
2372608 | 2372608 | 2022-04-04 | Crenshaw | Alabama | 1041 | 3797 | 98 |
2369355 | 2369355 | 2022-04-03 | Crenshaw | Alabama | 1041 | 3797 | 98 |
2366102 | 2366102 | 2022-04-02 | Crenshaw | Alabama | 1041 | 3797 | 98 |
2362849 | 2362849 | 2022-04-01 | Crenshaw | Alabama | 1041 | 3797 | 98 |
2359595 | 2359595 | 2022-03-31 | Crenshaw | Alabama | 1041 | 3797 | 98 |
2356341 | 2356341 | 2022-03-30 | Crenshaw | Alabama | 1041 | 3797 | 98 |
2353088 | 2353088 | 2022-03-29 | Crenshaw | Alabama | 1041 | 3797 | 98 |
2349836 | 2349836 | 2022-03-28 | Crenshaw | Alabama | 1041 | 3797 | 98 |
2346583 | 2346583 | 2022-03-27 | Crenshaw | Alabama | 1041 | 3787 | 98 |
2343330 | 2343330 | 2022-03-26 | Crenshaw | Alabama | 1041 | 3787 | 98 |
2340077 | 2340077 | 2022-03-25 | Crenshaw | Alabama | 1041 | 3787 | 98 |
2336824 | 2336824 | 2022-03-24 | Crenshaw | Alabama | 1041 | 3786 | 97 |
2333570 | 2333570 | 2022-03-23 | Crenshaw | Alabama | 1041 | 3786 | 97 |
2330316 | 2330316 | 2022-03-22 | Crenshaw | Alabama | 1041 | 3785 | 97 |
2327064 | 2327064 | 2022-03-21 | Crenshaw | Alabama | 1041 | 3784 | 96 |
2323811 | 2323811 | 2022-03-20 | Crenshaw | Alabama | 1041 | 3784 | 96 |
2320557 | 2320557 | 2022-03-19 | Crenshaw | Alabama | 1041 | 3784 | 96 |
2317303 | 2317303 | 2022-03-18 | Crenshaw | Alabama | 1041 | 3784 | 96 |
2314050 | 2314050 | 2022-03-17 | Crenshaw | Alabama | 1041 | 3784 | 96 |
2310797 | 2310797 | 2022-03-16 | Crenshaw | Alabama | 1041 | 3784 | 95 |
2307544 | 2307544 | 2022-03-15 | Crenshaw | Alabama | 1041 | 3782 | 95 |
2304293 | 2304293 | 2022-03-14 | Crenshaw | Alabama | 1041 | 3781 | 95 |
2301041 | 2301041 | 2022-03-13 | Crenshaw | Alabama | 1041 | 3781 | 95 |
2297789 | 2297789 | 2022-03-12 | Crenshaw | Alabama | 1041 | 3781 | 95 |
2294537 | 2294537 | 2022-03-11 | Crenshaw | Alabama | 1041 | 3781 | 95 |
2291285 | 2291285 | 2022-03-10 | Crenshaw | Alabama | 1041 | 3781 | 95 |
2288033 | 2288033 | 2022-03-09 | Crenshaw | Alabama | 1041 | 3778 | 95 |
2284781 | 2284781 | 2022-03-08 | Crenshaw | Alabama | 1041 | 3779 | 95 |
2281529 | 2281529 | 2022-03-07 | Crenshaw | Alabama | 1041 | 3779 | 95 |
2278276 | 2278276 | 2022-03-06 | Crenshaw | Alabama | 1041 | 3776 | 94 |
2275023 | 2275023 | 2022-03-05 | Crenshaw | Alabama | 1041 | 3776 | 94 |
2271770 | 2271770 | 2022-03-04 | Crenshaw | Alabama | 1041 | 3776 | 94 |
2268518 | 2268518 | 2022-03-03 | Crenshaw | Alabama | 1041 | 3775 | 93 |
2265265 | 2265265 | 2022-03-02 | Crenshaw | Alabama | 1041 | 3770 | 92 |
2262015 | 2262015 | 2022-03-01 | Crenshaw | Alabama | 1041 | 3770 | 92 |
2258764 | 2258764 | 2022-02-28 | Crenshaw | Alabama | 1041 | 3770 | 91 |
2255513 | 2255513 | 2022-02-27 | Crenshaw | Alabama | 1041 | 3770 | 91 |
2252262 | 2252262 | 2022-02-26 | Crenshaw | Alabama | 1041 | 3770 | 91 |
2249011 | 2249011 | 2022-02-25 | Crenshaw | Alabama | 1041 | 3768 | 91 |
2245760 | 2245760 | 2022-02-24 | Crenshaw | Alabama | 1041 | 3770 | 91 |
2242509 | 2242509 | 2022-02-23 | Crenshaw | Alabama | 1041 | 3769 | 88 |
2239258 | 2239258 | 2022-02-22 | Crenshaw | Alabama | 1041 | 3765 | 86 |
2236007 | 2236007 | 2022-02-21 | Crenshaw | Alabama | 1041 | 3763 | 86 |
2232756 | 2232756 | 2022-02-20 | Crenshaw | Alabama | 1041 | 3763 | 86 |
2229505 | 2229505 | 2022-02-19 | Crenshaw | Alabama | 1041 | 3762 | 86 |
2226254 | 2226254 | 2022-02-18 | Crenshaw | Alabama | 1041 | 3763 | 86 |
2223003 | 2223003 | 2022-02-17 | Crenshaw | Alabama | 1041 | 3760 | 86 |
2219752 | 2219752 | 2022-02-16 | Crenshaw | Alabama | 1041 | 3755 | 86 |
2216502 | 2216502 | 2022-02-15 | Crenshaw | Alabama | 1041 | 3750 | 85 |
2213251 | 2213251 | 2022-02-14 | Crenshaw | Alabama | 1041 | 3744 | 84 |
2209998 | 2209998 | 2022-02-13 | Crenshaw | Alabama | 1041 | 3741 | 84 |
2206745 | 2206745 | 2022-02-12 | Crenshaw | Alabama | 1041 | 3741 | 84 |
2203492 | 2203492 | 2022-02-11 | Crenshaw | Alabama | 1041 | 3739 | 84 |
2200238 | 2200238 | 2022-02-10 | Crenshaw | Alabama | 1041 | 3727 | 84 |
2196984 | 2196984 | 2022-02-09 | Crenshaw | Alabama | 1041 | 3712 | 84 |
2193729 | 2193729 | 2022-02-08 | Crenshaw | Alabama | 1041 | 3696 | 84 |
2190476 | 2190476 | 2022-02-07 | Crenshaw | Alabama | 1041 | 3687 | 84 |
2187223 | 2187223 | 2022-02-06 | Crenshaw | Alabama | 1041 | 3679 | 84 |
2183970 | 2183970 | 2022-02-05 | Crenshaw | Alabama | 1041 | 3679 | 84 |
2180718 | 2180718 | 2022-02-04 | Crenshaw | Alabama | 1041 | 3673 | 84 |
2177467 | 2177467 | 2022-02-03 | Crenshaw | Alabama | 1041 | 3645 | 82 |
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);