ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,322 rows where county = "Delta" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths, date (date)
county 1
- Delta · 2,322 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499835 | 2499835 | 2022-05-13 | Delta | Colorado | 8029 | 6232 | 140 |
2500841 | 2500841 | 2022-05-13 | Delta | Michigan | 26041 | 10050 | 157 |
2502267 | 2502267 | 2022-05-13 | Delta | Texas | 48119 | 1820 | 25 |
2496577 | 2496577 | 2022-05-12 | Delta | Colorado | 8029 | 6232 | 140 |
2497583 | 2497583 | 2022-05-12 | Delta | Michigan | 26041 | 10050 | 157 |
2499009 | 2499009 | 2022-05-12 | Delta | Texas | 48119 | 1819 | 25 |
2493319 | 2493319 | 2022-05-11 | Delta | Colorado | 8029 | 6195 | 140 |
2494325 | 2494325 | 2022-05-11 | Delta | Michigan | 26041 | 10050 | 157 |
2495751 | 2495751 | 2022-05-11 | Delta | Texas | 48119 | 1819 | 25 |
2490061 | 2490061 | 2022-05-10 | Delta | Colorado | 8029 | 6195 | 140 |
2491067 | 2491067 | 2022-05-10 | Delta | Michigan | 26041 | 9984 | 157 |
2492493 | 2492493 | 2022-05-10 | Delta | Texas | 48119 | 1819 | 25 |
2486804 | 2486804 | 2022-05-09 | Delta | Colorado | 8029 | 6191 | 140 |
2487810 | 2487810 | 2022-05-09 | Delta | Michigan | 26041 | 9984 | 157 |
2489235 | 2489235 | 2022-05-09 | Delta | Texas | 48119 | 1819 | 25 |
2483546 | 2483546 | 2022-05-08 | Delta | Colorado | 8029 | 6189 | 140 |
2484552 | 2484552 | 2022-05-08 | Delta | Michigan | 26041 | 9984 | 157 |
2485978 | 2485978 | 2022-05-08 | Delta | Texas | 48119 | 1818 | 25 |
2480288 | 2480288 | 2022-05-07 | Delta | Colorado | 8029 | 6189 | 140 |
2481294 | 2481294 | 2022-05-07 | Delta | Michigan | 26041 | 9984 | 157 |
2482720 | 2482720 | 2022-05-07 | Delta | Texas | 48119 | 1818 | 25 |
2477030 | 2477030 | 2022-05-06 | Delta | Colorado | 8029 | 6189 | 140 |
2478036 | 2478036 | 2022-05-06 | Delta | Michigan | 26041 | 9984 | 157 |
2479462 | 2479462 | 2022-05-06 | Delta | Texas | 48119 | 1818 | 25 |
2473772 | 2473772 | 2022-05-05 | Delta | Colorado | 8029 | 6187 | 140 |
2474778 | 2474778 | 2022-05-05 | Delta | Michigan | 26041 | 9984 | 157 |
2476204 | 2476204 | 2022-05-05 | Delta | Texas | 48119 | 1817 | 25 |
2470515 | 2470515 | 2022-05-04 | Delta | Colorado | 8029 | 6183 | 140 |
2471521 | 2471521 | 2022-05-04 | Delta | Michigan | 26041 | 9984 | 157 |
2472947 | 2472947 | 2022-05-04 | Delta | Texas | 48119 | 1817 | 25 |
2467259 | 2467259 | 2022-05-03 | Delta | Colorado | 8029 | 6183 | 140 |
2468265 | 2468265 | 2022-05-03 | Delta | Michigan | 26041 | 9951 | 157 |
2469691 | 2469691 | 2022-05-03 | Delta | Texas | 48119 | 1817 | 25 |
2464004 | 2464004 | 2022-05-02 | Delta | Colorado | 8029 | 6183 | 134 |
2465010 | 2465010 | 2022-05-02 | Delta | Michigan | 26041 | 9951 | 157 |
2466435 | 2466435 | 2022-05-02 | Delta | Texas | 48119 | 1817 | 25 |
2460748 | 2460748 | 2022-05-01 | Delta | Colorado | 8029 | 6181 | 134 |
2461754 | 2461754 | 2022-05-01 | Delta | Michigan | 26041 | 9951 | 157 |
2463180 | 2463180 | 2022-05-01 | Delta | Texas | 48119 | 1817 | 25 |
2457492 | 2457492 | 2022-04-30 | Delta | Colorado | 8029 | 6181 | 134 |
2458498 | 2458498 | 2022-04-30 | Delta | Michigan | 26041 | 9951 | 157 |
2459924 | 2459924 | 2022-04-30 | Delta | Texas | 48119 | 1817 | 25 |
2454236 | 2454236 | 2022-04-29 | Delta | Colorado | 8029 | 6181 | 134 |
2455242 | 2455242 | 2022-04-29 | Delta | Michigan | 26041 | 9951 | 157 |
2456668 | 2456668 | 2022-04-29 | Delta | Texas | 48119 | 1817 | 25 |
2450980 | 2450980 | 2022-04-28 | Delta | Colorado | 8029 | 6181 | 134 |
2451986 | 2451986 | 2022-04-28 | Delta | Michigan | 26041 | 9951 | 157 |
2453412 | 2453412 | 2022-04-28 | Delta | Texas | 48119 | 1816 | 25 |
2447724 | 2447724 | 2022-04-27 | Delta | Colorado | 8029 | 6181 | 134 |
2448730 | 2448730 | 2022-04-27 | Delta | Michigan | 26041 | 9951 | 157 |
2450156 | 2450156 | 2022-04-27 | Delta | Texas | 48119 | 1816 | 25 |
2444468 | 2444468 | 2022-04-26 | Delta | Colorado | 8029 | 6177 | 134 |
2445474 | 2445474 | 2022-04-26 | Delta | Michigan | 26041 | 9935 | 157 |
2446899 | 2446899 | 2022-04-26 | Delta | Texas | 48119 | 1816 | 25 |
2441212 | 2441212 | 2022-04-25 | Delta | Colorado | 8029 | 6177 | 134 |
2442218 | 2442218 | 2022-04-25 | Delta | Michigan | 26041 | 9935 | 157 |
2443644 | 2443644 | 2022-04-25 | Delta | Texas | 48119 | 1815 | 25 |
2437956 | 2437956 | 2022-04-24 | Delta | Colorado | 8029 | 6176 | 134 |
2438962 | 2438962 | 2022-04-24 | Delta | Michigan | 26041 | 9935 | 157 |
2440388 | 2440388 | 2022-04-24 | Delta | Texas | 48119 | 1815 | 25 |
2434700 | 2434700 | 2022-04-23 | Delta | Colorado | 8029 | 6176 | 134 |
2435706 | 2435706 | 2022-04-23 | Delta | Michigan | 26041 | 9935 | 157 |
2437132 | 2437132 | 2022-04-23 | Delta | Texas | 48119 | 1815 | 25 |
2431444 | 2431444 | 2022-04-22 | Delta | Colorado | 8029 | 6176 | 134 |
2432450 | 2432450 | 2022-04-22 | Delta | Michigan | 26041 | 9935 | 157 |
2433876 | 2433876 | 2022-04-22 | Delta | Texas | 48119 | 1814 | 25 |
2428188 | 2428188 | 2022-04-21 | Delta | Colorado | 8029 | 6169 | 134 |
2429194 | 2429194 | 2022-04-21 | Delta | Michigan | 26041 | 9935 | 157 |
2430620 | 2430620 | 2022-04-21 | Delta | Texas | 48119 | 1814 | 25 |
2424932 | 2424932 | 2022-04-20 | Delta | Colorado | 8029 | 6157 | 134 |
2425938 | 2425938 | 2022-04-20 | Delta | Michigan | 26041 | 9935 | 157 |
2427364 | 2427364 | 2022-04-20 | Delta | Texas | 48119 | 1814 | 25 |
2421676 | 2421676 | 2022-04-19 | Delta | Colorado | 8029 | 6144 | 134 |
2422682 | 2422682 | 2022-04-19 | Delta | Michigan | 26041 | 9925 | 157 |
2424108 | 2424108 | 2022-04-19 | Delta | Texas | 48119 | 1814 | 25 |
2418420 | 2418420 | 2022-04-18 | Delta | Colorado | 8029 | 6133 | 134 |
2419426 | 2419426 | 2022-04-18 | Delta | Michigan | 26041 | 9925 | 157 |
2420852 | 2420852 | 2022-04-18 | Delta | Texas | 48119 | 1814 | 25 |
2415164 | 2415164 | 2022-04-17 | Delta | Colorado | 8029 | 6130 | 134 |
2416170 | 2416170 | 2022-04-17 | Delta | Michigan | 26041 | 9925 | 157 |
2417596 | 2417596 | 2022-04-17 | Delta | Texas | 48119 | 1813 | 25 |
2411908 | 2411908 | 2022-04-16 | Delta | Colorado | 8029 | 6130 | 134 |
2412914 | 2412914 | 2022-04-16 | Delta | Michigan | 26041 | 9925 | 157 |
2414340 | 2414340 | 2022-04-16 | Delta | Texas | 48119 | 1813 | 25 |
2408652 | 2408652 | 2022-04-15 | Delta | Colorado | 8029 | 6130 | 134 |
2409658 | 2409658 | 2022-04-15 | Delta | Michigan | 26041 | 9925 | 157 |
2411084 | 2411084 | 2022-04-15 | Delta | Texas | 48119 | 1813 | 25 |
2405396 | 2405396 | 2022-04-14 | Delta | Colorado | 8029 | 6128 | 134 |
2406402 | 2406402 | 2022-04-14 | Delta | Michigan | 26041 | 9925 | 157 |
2407828 | 2407828 | 2022-04-14 | Delta | Texas | 48119 | 1813 | 25 |
2402141 | 2402141 | 2022-04-13 | Delta | Colorado | 8029 | 6109 | 134 |
2403146 | 2403146 | 2022-04-13 | Delta | Michigan | 26041 | 9925 | 157 |
2404572 | 2404572 | 2022-04-13 | Delta | Texas | 48119 | 1813 | 25 |
2398886 | 2398886 | 2022-04-12 | Delta | Colorado | 8029 | 6104 | 134 |
2399892 | 2399892 | 2022-04-12 | Delta | Michigan | 26041 | 9921 | 157 |
2401317 | 2401317 | 2022-04-12 | Delta | Texas | 48119 | 1812 | 25 |
2395631 | 2395631 | 2022-04-11 | Delta | Colorado | 8029 | 6037 | 134 |
2396636 | 2396636 | 2022-04-11 | Delta | Michigan | 26041 | 9921 | 157 |
2398062 | 2398062 | 2022-04-11 | Delta | Texas | 48119 | 1812 | 25 |
2392375 | 2392375 | 2022-04-10 | Delta | Colorado | 8029 | 6028 | 134 |
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);