ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
309 rows where deaths = 48 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 |
---|---|---|---|---|---|---|---|
2463775 | 2463775 | 2022-05-02 | Greene | Alabama | 1063 | 1875 | 48 |
2460519 | 2460519 | 2022-05-01 | Greene | Alabama | 1063 | 1875 | 48 |
2457263 | 2457263 | 2022-04-30 | Greene | Alabama | 1063 | 1875 | 48 |
2454007 | 2454007 | 2022-04-29 | Greene | Alabama | 1063 | 1875 | 48 |
2450751 | 2450751 | 2022-04-28 | Greene | Alabama | 1063 | 1875 | 48 |
2447495 | 2447495 | 2022-04-27 | Greene | Alabama | 1063 | 1875 | 48 |
2444239 | 2444239 | 2022-04-26 | Greene | Alabama | 1063 | 1875 | 48 |
2440983 | 2440983 | 2022-04-25 | Greene | Alabama | 1063 | 1874 | 48 |
2437727 | 2437727 | 2022-04-24 | Greene | Alabama | 1063 | 1873 | 48 |
2434471 | 2434471 | 2022-04-23 | Greene | Alabama | 1063 | 1873 | 48 |
2431215 | 2431215 | 2022-04-22 | Greene | Alabama | 1063 | 1873 | 48 |
2427959 | 2427959 | 2022-04-21 | Greene | Alabama | 1063 | 1871 | 48 |
2424703 | 2424703 | 2022-04-20 | Greene | Alabama | 1063 | 1871 | 48 |
2421447 | 2421447 | 2022-04-19 | Greene | Alabama | 1063 | 1871 | 48 |
2418191 | 2418191 | 2022-04-18 | Greene | Alabama | 1063 | 1871 | 48 |
2414935 | 2414935 | 2022-04-17 | Greene | Alabama | 1063 | 1871 | 48 |
2411679 | 2411679 | 2022-04-16 | Greene | Alabama | 1063 | 1871 | 48 |
2408423 | 2408423 | 2022-04-15 | Greene | Alabama | 1063 | 1871 | 48 |
2405167 | 2405167 | 2022-04-14 | Greene | Alabama | 1063 | 1871 | 48 |
2401912 | 2401912 | 2022-04-13 | Greene | Alabama | 1063 | 1871 | 48 |
2398657 | 2398657 | 2022-04-12 | Greene | Alabama | 1063 | 1870 | 48 |
2395402 | 2395402 | 2022-04-11 | Greene | Alabama | 1063 | 1869 | 48 |
2392146 | 2392146 | 2022-04-10 | Greene | Alabama | 1063 | 1869 | 48 |
2388890 | 2388890 | 2022-04-09 | Greene | Alabama | 1063 | 1869 | 48 |
2385635 | 2385635 | 2022-04-08 | Greene | Alabama | 1063 | 1869 | 48 |
2382380 | 2382380 | 2022-04-07 | Greene | Alabama | 1063 | 1868 | 48 |
2379125 | 2379125 | 2022-04-06 | Greene | Alabama | 1063 | 1868 | 48 |
2375871 | 2375871 | 2022-04-05 | Greene | Alabama | 1063 | 1868 | 48 |
2372619 | 2372619 | 2022-04-04 | Greene | Alabama | 1063 | 1868 | 48 |
2369366 | 2369366 | 2022-04-03 | Greene | Alabama | 1063 | 1868 | 48 |
2366113 | 2366113 | 2022-04-02 | Greene | Alabama | 1063 | 1868 | 48 |
2362860 | 2362860 | 2022-04-01 | Greene | Alabama | 1063 | 1868 | 48 |
2359606 | 2359606 | 2022-03-31 | Greene | Alabama | 1063 | 1868 | 48 |
2356352 | 2356352 | 2022-03-30 | Greene | Alabama | 1063 | 1868 | 48 |
2353099 | 2353099 | 2022-03-29 | Greene | Alabama | 1063 | 1868 | 48 |
2349847 | 2349847 | 2022-03-28 | Greene | Alabama | 1063 | 1866 | 48 |
2346594 | 2346594 | 2022-03-27 | Greene | Alabama | 1063 | 1866 | 48 |
2343341 | 2343341 | 2022-03-26 | Greene | Alabama | 1063 | 1866 | 48 |
2340088 | 2340088 | 2022-03-25 | Greene | Alabama | 1063 | 1866 | 48 |
2336835 | 2336835 | 2022-03-24 | Greene | Alabama | 1063 | 1865 | 48 |
2333581 | 2333581 | 2022-03-23 | Greene | Alabama | 1063 | 1864 | 48 |
2330327 | 2330327 | 2022-03-22 | Greene | Alabama | 1063 | 1863 | 48 |
2327075 | 2327075 | 2022-03-21 | Greene | Alabama | 1063 | 1863 | 48 |
2323822 | 2323822 | 2022-03-20 | Greene | Alabama | 1063 | 1863 | 48 |
2320568 | 2320568 | 2022-03-19 | Greene | Alabama | 1063 | 1863 | 48 |
2317314 | 2317314 | 2022-03-18 | Greene | Alabama | 1063 | 1863 | 48 |
2314061 | 2314061 | 2022-03-17 | Greene | Alabama | 1063 | 1862 | 48 |
2310808 | 2310808 | 2022-03-16 | Greene | Alabama | 1063 | 1862 | 48 |
2307555 | 2307555 | 2022-03-15 | Greene | Alabama | 1063 | 1860 | 48 |
2304304 | 2304304 | 2022-03-14 | Greene | Alabama | 1063 | 1860 | 48 |
2301052 | 2301052 | 2022-03-13 | Greene | Alabama | 1063 | 1859 | 48 |
2297800 | 2297800 | 2022-03-12 | Greene | Alabama | 1063 | 1859 | 48 |
2294548 | 2294548 | 2022-03-11 | Greene | Alabama | 1063 | 1859 | 48 |
2291296 | 2291296 | 2022-03-10 | Greene | Alabama | 1063 | 1859 | 48 |
2291324 | 2291324 | 2022-03-10 | Sumter | Alabama | 1119 | 2563 | 48 |
2288044 | 2288044 | 2022-03-09 | Greene | Alabama | 1063 | 1858 | 48 |
2288072 | 2288072 | 2022-03-09 | Sumter | Alabama | 1119 | 2563 | 48 |
2284792 | 2284792 | 2022-03-08 | Greene | Alabama | 1063 | 1856 | 48 |
2284820 | 2284820 | 2022-03-08 | Sumter | Alabama | 1119 | 2563 | 48 |
2281540 | 2281540 | 2022-03-07 | Greene | Alabama | 1063 | 1856 | 48 |
2278287 | 2278287 | 2022-03-06 | Greene | Alabama | 1063 | 1856 | 48 |
2275034 | 2275034 | 2022-03-05 | Greene | Alabama | 1063 | 1856 | 48 |
2271781 | 2271781 | 2022-03-04 | Greene | Alabama | 1063 | 1856 | 48 |
2268529 | 2268529 | 2022-03-03 | Greene | Alabama | 1063 | 1855 | 48 |
2265276 | 2265276 | 2022-03-02 | Greene | Alabama | 1063 | 1854 | 48 |
2262026 | 2262026 | 2022-03-01 | Greene | Alabama | 1063 | 1853 | 48 |
2258775 | 2258775 | 2022-02-28 | Greene | Alabama | 1063 | 1852 | 48 |
2255524 | 2255524 | 2022-02-27 | Greene | Alabama | 1063 | 1852 | 48 |
2252273 | 2252273 | 2022-02-26 | Greene | Alabama | 1063 | 1852 | 48 |
2249022 | 2249022 | 2022-02-25 | Greene | Alabama | 1063 | 1848 | 48 |
2245771 | 2245771 | 2022-02-24 | Greene | Alabama | 1063 | 1848 | 48 |
2242520 | 2242520 | 2022-02-23 | Greene | Alabama | 1063 | 1848 | 48 |
2239269 | 2239269 | 2022-02-22 | Greene | Alabama | 1063 | 1848 | 48 |
2236018 | 2236018 | 2022-02-21 | Greene | Alabama | 1063 | 1848 | 48 |
2232767 | 2232767 | 2022-02-20 | Greene | Alabama | 1063 | 1847 | 48 |
2229516 | 2229516 | 2022-02-19 | Greene | Alabama | 1063 | 1845 | 48 |
2226265 | 2226265 | 2022-02-18 | Greene | Alabama | 1063 | 1844 | 48 |
2223014 | 2223014 | 2022-02-17 | Greene | Alabama | 1063 | 1844 | 48 |
2219763 | 2219763 | 2022-02-16 | Greene | Alabama | 1063 | 1825 | 48 |
2216513 | 2216513 | 2022-02-15 | Greene | Alabama | 1063 | 1802 | 48 |
2213262 | 2213262 | 2022-02-14 | Greene | Alabama | 1063 | 1787 | 48 |
2210009 | 2210009 | 2022-02-13 | Greene | Alabama | 1063 | 1787 | 48 |
2206756 | 2206756 | 2022-02-12 | Greene | Alabama | 1063 | 1786 | 48 |
2203503 | 2203503 | 2022-02-11 | Greene | Alabama | 1063 | 1777 | 48 |
2200249 | 2200249 | 2022-02-10 | Greene | Alabama | 1063 | 1774 | 48 |
2196995 | 2196995 | 2022-02-09 | Greene | Alabama | 1063 | 1772 | 48 |
2177452 | 2177452 | 2022-02-03 | Bullock | Alabama | 1011 | 2245 | 48 |
2174199 | 2174199 | 2022-02-02 | Bullock | Alabama | 1011 | 2245 | 48 |
2131913 | 2131913 | 2022-01-20 | Coosa | Alabama | 1037 | 2465 | 48 |
2128659 | 2128659 | 2022-01-19 | Coosa | Alabama | 1037 | 2424 | 48 |
2125406 | 2125406 | 2022-01-18 | Coosa | Alabama | 1037 | 2374 | 48 |
2122154 | 2122154 | 2022-01-17 | Coosa | Alabama | 1037 | 2340 | 48 |
2118902 | 2118902 | 2022-01-16 | Coosa | Alabama | 1037 | 2314 | 48 |
2115650 | 2115650 | 2022-01-15 | Coosa | Alabama | 1037 | 2202 | 48 |
2112398 | 2112398 | 2022-01-14 | Coosa | Alabama | 1037 | 2202 | 48 |
2109146 | 2109146 | 2022-01-13 | Coosa | Alabama | 1037 | 2202 | 48 |
2105895 | 2105895 | 2022-01-12 | Coosa | Alabama | 1037 | 2202 | 48 |
2102644 | 2102644 | 2022-01-11 | Coosa | Alabama | 1037 | 2175 | 48 |
2099393 | 2099393 | 2022-01-10 | Coosa | Alabama | 1037 | 2163 | 48 |
2096142 | 2096142 | 2022-01-09 | Coosa | Alabama | 1037 | 2155 | 48 |
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);