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)
county 1
- Delta · 2,222 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2393381 | 2393381 | 2022-04-10 | Delta | Michigan | 26041 | 9921 | 157 |
2394807 | 2394807 | 2022-04-10 | Delta | Texas | 48119 | 1812 | 25 |
2389119 | 2389119 | 2022-04-09 | Delta | Colorado | 8029 | 6028 | 134 |
2390125 | 2390125 | 2022-04-09 | Delta | Michigan | 26041 | 9921 | 157 |
2391551 | 2391551 | 2022-04-09 | Delta | Texas | 48119 | 1810 | 25 |
2385864 | 2385864 | 2022-04-08 | Delta | Colorado | 8029 | 6028 | 134 |
2386869 | 2386869 | 2022-04-08 | Delta | Michigan | 26041 | 9921 | 157 |
2388295 | 2388295 | 2022-04-08 | Delta | Texas | 48119 | 1810 | 25 |
2382609 | 2382609 | 2022-04-07 | Delta | Colorado | 8029 | 6023 | 134 |
2383614 | 2383614 | 2022-04-07 | Delta | Michigan | 26041 | 9921 | 157 |
2385040 | 2385040 | 2022-04-07 | Delta | Texas | 48119 | 1810 | 25 |
2379354 | 2379354 | 2022-04-06 | Delta | Colorado | 8029 | 6014 | 134 |
2380359 | 2380359 | 2022-04-06 | Delta | Michigan | 26041 | 9921 | 157 |
2381785 | 2381785 | 2022-04-06 | Delta | Texas | 48119 | 1810 | 25 |
2376100 | 2376100 | 2022-04-05 | Delta | Colorado | 8029 | 6011 | 134 |
2377104 | 2377104 | 2022-04-05 | Delta | Michigan | 26041 | 9917 | 155 |
2378530 | 2378530 | 2022-04-05 | Delta | Texas | 48119 | 1810 | 25 |
2372848 | 2372848 | 2022-04-04 | Delta | Colorado | 8029 | 6009 | 134 |
2373852 | 2373852 | 2022-04-04 | Delta | Michigan | 26041 | 9917 | 155 |
2375276 | 2375276 | 2022-04-04 | Delta | Texas | 48119 | 1809 | 25 |
2369595 | 2369595 | 2022-04-03 | Delta | Colorado | 8029 | 6001 | 134 |
2370599 | 2370599 | 2022-04-03 | Delta | Michigan | 26041 | 9917 | 155 |
2372024 | 2372024 | 2022-04-03 | Delta | Texas | 48119 | 1809 | 25 |
2366342 | 2366342 | 2022-04-02 | Delta | Colorado | 8029 | 6001 | 134 |
2367346 | 2367346 | 2022-04-02 | Delta | Michigan | 26041 | 9917 | 155 |
2368771 | 2368771 | 2022-04-02 | Delta | Texas | 48119 | 1809 | 25 |
2363089 | 2363089 | 2022-04-01 | Delta | Colorado | 8029 | 6001 | 134 |
2364093 | 2364093 | 2022-04-01 | Delta | Michigan | 26041 | 9917 | 155 |
2365518 | 2365518 | 2022-04-01 | Delta | Texas | 48119 | 1809 | 25 |
2359835 | 2359835 | 2022-03-31 | Delta | Colorado | 8029 | 6001 | 134 |
2360839 | 2360839 | 2022-03-31 | Delta | Michigan | 26041 | 9920 | 155 |
2362265 | 2362265 | 2022-03-31 | Delta | Texas | 48119 | 1809 | 25 |
2356581 | 2356581 | 2022-03-30 | Delta | Colorado | 8029 | 5988 | 134 |
2357585 | 2357585 | 2022-03-30 | Delta | Michigan | 26041 | 9920 | 155 |
2359011 | 2359011 | 2022-03-30 | Delta | Texas | 48119 | 1809 | 25 |
2353328 | 2353328 | 2022-03-29 | Delta | Colorado | 8029 | 5985 | 134 |
2354332 | 2354332 | 2022-03-29 | Delta | Michigan | 26041 | 9919 | 155 |
2355757 | 2355757 | 2022-03-29 | Delta | Texas | 48119 | 1808 | 25 |
2350076 | 2350076 | 2022-03-28 | Delta | Colorado | 8029 | 5977 | 134 |
2351080 | 2351080 | 2022-03-28 | Delta | Michigan | 26041 | 9919 | 155 |
2352504 | 2352504 | 2022-03-28 | Delta | Texas | 48119 | 1800 | 25 |
2346823 | 2346823 | 2022-03-27 | Delta | Colorado | 8029 | 5977 | 134 |
2347827 | 2347827 | 2022-03-27 | Delta | Michigan | 26041 | 9915 | 155 |
2349252 | 2349252 | 2022-03-27 | Delta | Texas | 48119 | 1800 | 25 |
2343570 | 2343570 | 2022-03-26 | Delta | Colorado | 8029 | 5977 | 134 |
2344574 | 2344574 | 2022-03-26 | Delta | Michigan | 26041 | 9915 | 155 |
2345999 | 2345999 | 2022-03-26 | Delta | Texas | 48119 | 1800 | 25 |
2340317 | 2340317 | 2022-03-25 | Delta | Colorado | 8029 | 5977 | 134 |
2341321 | 2341321 | 2022-03-25 | Delta | Michigan | 26041 | 9915 | 155 |
2342746 | 2342746 | 2022-03-25 | Delta | Texas | 48119 | 1800 | 25 |
2337064 | 2337064 | 2022-03-24 | Delta | Colorado | 8029 | 5972 | 134 |
2338068 | 2338068 | 2022-03-24 | Delta | Michigan | 26041 | 9915 | 155 |
2339493 | 2339493 | 2022-03-24 | Delta | Texas | 48119 | 1800 | 25 |
2333810 | 2333810 | 2022-03-23 | Delta | Colorado | 8029 | 5967 | 134 |
2334814 | 2334814 | 2022-03-23 | Delta | Michigan | 26041 | 9915 | 155 |
2336239 | 2336239 | 2022-03-23 | Delta | Texas | 48119 | 1800 | 25 |
2330556 | 2330556 | 2022-03-22 | Delta | Colorado | 8029 | 5966 | 134 |
2331560 | 2331560 | 2022-03-22 | Delta | Michigan | 26041 | 9916 | 154 |
2332985 | 2332985 | 2022-03-22 | Delta | Texas | 48119 | 1800 | 25 |
2327304 | 2327304 | 2022-03-21 | Delta | Colorado | 8029 | 5963 | 134 |
2328308 | 2328308 | 2022-03-21 | Delta | Michigan | 26041 | 9916 | 154 |
2329732 | 2329732 | 2022-03-21 | Delta | Texas | 48119 | 1800 | 25 |
2324051 | 2324051 | 2022-03-20 | Delta | Colorado | 8029 | 5961 | 134 |
2325055 | 2325055 | 2022-03-20 | Delta | Michigan | 26041 | 9912 | 154 |
2326480 | 2326480 | 2022-03-20 | Delta | Texas | 48119 | 1800 | 25 |
2320797 | 2320797 | 2022-03-19 | Delta | Colorado | 8029 | 5961 | 134 |
2321801 | 2321801 | 2022-03-19 | Delta | Michigan | 26041 | 9912 | 154 |
2323227 | 2323227 | 2022-03-19 | Delta | Texas | 48119 | 1800 | 25 |
2317543 | 2317543 | 2022-03-18 | Delta | Colorado | 8029 | 5961 | 134 |
2318547 | 2318547 | 2022-03-18 | Delta | Michigan | 26041 | 9912 | 154 |
2319973 | 2319973 | 2022-03-18 | Delta | Texas | 48119 | 1800 | 25 |
2314290 | 2314290 | 2022-03-17 | Delta | Colorado | 8029 | 5961 | 134 |
2315294 | 2315294 | 2022-03-17 | Delta | Michigan | 26041 | 9909 | 154 |
2316719 | 2316719 | 2022-03-17 | Delta | Texas | 48119 | 1800 | 25 |
2311037 | 2311037 | 2022-03-16 | Delta | Colorado | 8029 | 5955 | 132 |
2312041 | 2312041 | 2022-03-16 | Delta | Michigan | 26041 | 9909 | 154 |
2313466 | 2313466 | 2022-03-16 | Delta | Texas | 48119 | 1799 | 25 |
2307784 | 2307784 | 2022-03-15 | Delta | Colorado | 8029 | 5951 | 132 |
2308788 | 2308788 | 2022-03-15 | Delta | Michigan | 26041 | 9909 | 154 |
2310213 | 2310213 | 2022-03-15 | Delta | Texas | 48119 | 1799 | 25 |
2304533 | 2304533 | 2022-03-14 | Delta | Colorado | 8029 | 5946 | 131 |
2305537 | 2305537 | 2022-03-14 | Delta | Michigan | 26041 | 9909 | 154 |
2306960 | 2306960 | 2022-03-14 | Delta | Texas | 48119 | 1798 | 25 |
2301281 | 2301281 | 2022-03-13 | Delta | Colorado | 8029 | 5938 | 131 |
2302285 | 2302285 | 2022-03-13 | Delta | Michigan | 26041 | 9904 | 154 |
2303709 | 2303709 | 2022-03-13 | Delta | Texas | 48119 | 1798 | 25 |
2298029 | 2298029 | 2022-03-12 | Delta | Colorado | 8029 | 5938 | 131 |
2299033 | 2299033 | 2022-03-12 | Delta | Michigan | 26041 | 9904 | 154 |
2300457 | 2300457 | 2022-03-12 | Delta | Texas | 48119 | 1797 | 25 |
2294777 | 2294777 | 2022-03-11 | Delta | Colorado | 8029 | 5938 | 131 |
2295781 | 2295781 | 2022-03-11 | Delta | Michigan | 26041 | 9904 | 154 |
2297205 | 2297205 | 2022-03-11 | Delta | Texas | 48119 | 1796 | 25 |
2291525 | 2291525 | 2022-03-10 | Delta | Colorado | 8029 | 5936 | 131 |
2292529 | 2292529 | 2022-03-10 | Delta | Michigan | 26041 | 9897 | 155 |
2293953 | 2293953 | 2022-03-10 | Delta | Texas | 48119 | 1796 | 24 |
2288273 | 2288273 | 2022-03-09 | Delta | Colorado | 8029 | 5937 | 131 |
2289277 | 2289277 | 2022-03-09 | Delta | Michigan | 26041 | 9897 | 155 |
2290701 | 2290701 | 2022-03-09 | Delta | Texas | 48119 | 1796 | 24 |
2285022 | 2285022 | 2022-03-08 | Delta | Colorado | 8029 | 5932 | 130 |
2286026 | 2286026 | 2022-03-08 | Delta | Michigan | 26041 | 9894 | 153 |
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);