ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Wilcox" 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 |
---|---|---|---|---|---|---|---|
2499640 | 2499640 | 2022-05-13 | Wilcox | Alabama | 1131 | 2892 | 46 |
2496382 | 2496382 | 2022-05-12 | Wilcox | Alabama | 1131 | 2892 | 46 |
2493124 | 2493124 | 2022-05-11 | Wilcox | Alabama | 1131 | 2891 | 46 |
2489866 | 2489866 | 2022-05-10 | Wilcox | Alabama | 1131 | 2890 | 46 |
2486609 | 2486609 | 2022-05-09 | Wilcox | Alabama | 1131 | 2889 | 46 |
2483351 | 2483351 | 2022-05-08 | Wilcox | Alabama | 1131 | 2889 | 46 |
2480093 | 2480093 | 2022-05-07 | Wilcox | Alabama | 1131 | 2889 | 46 |
2476835 | 2476835 | 2022-05-06 | Wilcox | Alabama | 1131 | 2889 | 46 |
2473577 | 2473577 | 2022-05-05 | Wilcox | Alabama | 1131 | 2889 | 46 |
2470320 | 2470320 | 2022-05-04 | Wilcox | Alabama | 1131 | 2889 | 46 |
2467064 | 2467064 | 2022-05-03 | Wilcox | Alabama | 1131 | 2888 | 46 |
2463809 | 2463809 | 2022-05-02 | Wilcox | Alabama | 1131 | 2888 | 46 |
2460553 | 2460553 | 2022-05-01 | Wilcox | Alabama | 1131 | 2888 | 46 |
2457297 | 2457297 | 2022-04-30 | Wilcox | Alabama | 1131 | 2888 | 46 |
2454041 | 2454041 | 2022-04-29 | Wilcox | Alabama | 1131 | 2888 | 46 |
2450785 | 2450785 | 2022-04-28 | Wilcox | Alabama | 1131 | 2888 | 46 |
2447529 | 2447529 | 2022-04-27 | Wilcox | Alabama | 1131 | 2888 | 46 |
2444273 | 2444273 | 2022-04-26 | Wilcox | Alabama | 1131 | 2888 | 46 |
2441017 | 2441017 | 2022-04-25 | Wilcox | Alabama | 1131 | 2888 | 46 |
2437761 | 2437761 | 2022-04-24 | Wilcox | Alabama | 1131 | 2886 | 46 |
2434505 | 2434505 | 2022-04-23 | Wilcox | Alabama | 1131 | 2886 | 46 |
2431249 | 2431249 | 2022-04-22 | Wilcox | Alabama | 1131 | 2886 | 46 |
2427993 | 2427993 | 2022-04-21 | Wilcox | Alabama | 1131 | 2886 | 46 |
2424737 | 2424737 | 2022-04-20 | Wilcox | Alabama | 1131 | 2886 | 46 |
2421481 | 2421481 | 2022-04-19 | Wilcox | Alabama | 1131 | 2886 | 46 |
2418225 | 2418225 | 2022-04-18 | Wilcox | Alabama | 1131 | 2885 | 46 |
2414969 | 2414969 | 2022-04-17 | Wilcox | Alabama | 1131 | 2885 | 46 |
2411713 | 2411713 | 2022-04-16 | Wilcox | Alabama | 1131 | 2885 | 46 |
2408457 | 2408457 | 2022-04-15 | Wilcox | Alabama | 1131 | 2885 | 46 |
2405201 | 2405201 | 2022-04-14 | Wilcox | Alabama | 1131 | 2885 | 46 |
2401946 | 2401946 | 2022-04-13 | Wilcox | Alabama | 1131 | 2885 | 46 |
2398691 | 2398691 | 2022-04-12 | Wilcox | Alabama | 1131 | 2885 | 46 |
2395436 | 2395436 | 2022-04-11 | Wilcox | Alabama | 1131 | 2885 | 46 |
2392180 | 2392180 | 2022-04-10 | Wilcox | Alabama | 1131 | 2885 | 46 |
2388924 | 2388924 | 2022-04-09 | Wilcox | Alabama | 1131 | 2885 | 46 |
2385669 | 2385669 | 2022-04-08 | Wilcox | Alabama | 1131 | 2885 | 46 |
2382414 | 2382414 | 2022-04-07 | Wilcox | Alabama | 1131 | 2885 | 46 |
2379159 | 2379159 | 2022-04-06 | Wilcox | Alabama | 1131 | 2883 | 46 |
2375905 | 2375905 | 2022-04-05 | Wilcox | Alabama | 1131 | 2880 | 46 |
2372653 | 2372653 | 2022-04-04 | Wilcox | Alabama | 1131 | 2880 | 46 |
2369400 | 2369400 | 2022-04-03 | Wilcox | Alabama | 1131 | 2879 | 46 |
2366147 | 2366147 | 2022-04-02 | Wilcox | Alabama | 1131 | 2879 | 46 |
2362894 | 2362894 | 2022-04-01 | Wilcox | Alabama | 1131 | 2879 | 46 |
2359640 | 2359640 | 2022-03-31 | Wilcox | Alabama | 1131 | 2876 | 46 |
2356386 | 2356386 | 2022-03-30 | Wilcox | Alabama | 1131 | 2876 | 46 |
2353133 | 2353133 | 2022-03-29 | Wilcox | Alabama | 1131 | 2876 | 46 |
2349881 | 2349881 | 2022-03-28 | Wilcox | Alabama | 1131 | 2876 | 46 |
2346628 | 2346628 | 2022-03-27 | Wilcox | Alabama | 1131 | 2873 | 46 |
2343375 | 2343375 | 2022-03-26 | Wilcox | Alabama | 1131 | 2873 | 46 |
2340122 | 2340122 | 2022-03-25 | Wilcox | Alabama | 1131 | 2873 | 46 |
2336869 | 2336869 | 2022-03-24 | Wilcox | Alabama | 1131 | 2872 | 45 |
2333615 | 2333615 | 2022-03-23 | Wilcox | Alabama | 1131 | 2872 | 45 |
2330361 | 2330361 | 2022-03-22 | Wilcox | Alabama | 1131 | 2871 | 45 |
2327109 | 2327109 | 2022-03-21 | Wilcox | Alabama | 1131 | 2871 | 45 |
2323856 | 2323856 | 2022-03-20 | Wilcox | Alabama | 1131 | 2871 | 45 |
2320602 | 2320602 | 2022-03-19 | Wilcox | Alabama | 1131 | 2871 | 45 |
2317348 | 2317348 | 2022-03-18 | Wilcox | Alabama | 1131 | 2871 | 45 |
2314095 | 2314095 | 2022-03-17 | Wilcox | Alabama | 1131 | 2871 | 44 |
2310842 | 2310842 | 2022-03-16 | Wilcox | Alabama | 1131 | 2871 | 44 |
2307589 | 2307589 | 2022-03-15 | Wilcox | Alabama | 1131 | 2869 | 44 |
2304338 | 2304338 | 2022-03-14 | Wilcox | Alabama | 1131 | 2869 | 44 |
2301086 | 2301086 | 2022-03-13 | Wilcox | Alabama | 1131 | 2869 | 44 |
2297834 | 2297834 | 2022-03-12 | Wilcox | Alabama | 1131 | 2869 | 44 |
2294582 | 2294582 | 2022-03-11 | Wilcox | Alabama | 1131 | 2869 | 44 |
2291330 | 2291330 | 2022-03-10 | Wilcox | Alabama | 1131 | 2869 | 44 |
2288078 | 2288078 | 2022-03-09 | Wilcox | Alabama | 1131 | 2866 | 43 |
2284826 | 2284826 | 2022-03-08 | Wilcox | Alabama | 1131 | 2865 | 43 |
2281574 | 2281574 | 2022-03-07 | Wilcox | Alabama | 1131 | 2864 | 42 |
2278321 | 2278321 | 2022-03-06 | Wilcox | Alabama | 1131 | 2864 | 42 |
2275068 | 2275068 | 2022-03-05 | Wilcox | Alabama | 1131 | 2864 | 42 |
2271815 | 2271815 | 2022-03-04 | Wilcox | Alabama | 1131 | 2864 | 42 |
2268563 | 2268563 | 2022-03-03 | Wilcox | Alabama | 1131 | 2861 | 42 |
2265310 | 2265310 | 2022-03-02 | Wilcox | Alabama | 1131 | 2858 | 42 |
2262060 | 2262060 | 2022-03-01 | Wilcox | Alabama | 1131 | 2856 | 42 |
2258809 | 2258809 | 2022-02-28 | Wilcox | Alabama | 1131 | 2855 | 42 |
2255558 | 2255558 | 2022-02-27 | Wilcox | Alabama | 1131 | 2855 | 42 |
2252307 | 2252307 | 2022-02-26 | Wilcox | Alabama | 1131 | 2855 | 42 |
2249056 | 2249056 | 2022-02-25 | Wilcox | Alabama | 1131 | 2855 | 42 |
2245805 | 2245805 | 2022-02-24 | Wilcox | Alabama | 1131 | 2850 | 42 |
2242554 | 2242554 | 2022-02-23 | Wilcox | Alabama | 1131 | 2849 | 42 |
2239303 | 2239303 | 2022-02-22 | Wilcox | Alabama | 1131 | 2843 | 42 |
2236052 | 2236052 | 2022-02-21 | Wilcox | Alabama | 1131 | 2840 | 42 |
2232801 | 2232801 | 2022-02-20 | Wilcox | Alabama | 1131 | 2839 | 42 |
2229550 | 2229550 | 2022-02-19 | Wilcox | Alabama | 1131 | 2839 | 42 |
2226299 | 2226299 | 2022-02-18 | Wilcox | Alabama | 1131 | 2832 | 42 |
2223048 | 2223048 | 2022-02-17 | Wilcox | Alabama | 1131 | 2828 | 42 |
2219797 | 2219797 | 2022-02-16 | Wilcox | Alabama | 1131 | 2824 | 42 |
2216547 | 2216547 | 2022-02-15 | Wilcox | Alabama | 1131 | 2820 | 41 |
2213296 | 2213296 | 2022-02-14 | Wilcox | Alabama | 1131 | 2815 | 40 |
2210043 | 2210043 | 2022-02-13 | Wilcox | Alabama | 1131 | 2815 | 40 |
2206790 | 2206790 | 2022-02-12 | Wilcox | Alabama | 1131 | 2813 | 40 |
2203537 | 2203537 | 2022-02-11 | Wilcox | Alabama | 1131 | 2801 | 40 |
2200283 | 2200283 | 2022-02-10 | Wilcox | Alabama | 1131 | 2792 | 40 |
2197029 | 2197029 | 2022-02-09 | Wilcox | Alabama | 1131 | 2786 | 40 |
2193774 | 2193774 | 2022-02-08 | Wilcox | Alabama | 1131 | 2776 | 40 |
2190521 | 2190521 | 2022-02-07 | Wilcox | Alabama | 1131 | 2764 | 40 |
2187268 | 2187268 | 2022-02-06 | Wilcox | Alabama | 1131 | 2755 | 40 |
2184015 | 2184015 | 2022-02-05 | Wilcox | Alabama | 1131 | 2755 | 40 |
2180763 | 2180763 | 2022-02-04 | Wilcox | Alabama | 1131 | 2751 | 40 |
2177512 | 2177512 | 2022-02-03 | Wilcox | Alabama | 1131 | 2711 | 39 |
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);