ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
9,229 rows where county = "Lake" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174398 | 2174398 | 2022-02-02 | Lake | California | 6033 | 10041 | 119 |
2174474 | 2174474 | 2022-02-02 | Lake | Colorado | 8065 | 1724 | 2 |
2174551 | 2174551 | 2022-02-02 | Lake | Florida | 12069 | 78050 | 1301 |
2174846 | 2174846 | 2022-02-02 | Lake | Illinois | 17097 | 141359 | 1316 |
2174945 | 2174945 | 2022-02-02 | Lake | Indiana | 18089 | 104056 | 1685 |
2175481 | 2175481 | 2022-02-02 | Lake | Michigan | 26085 | 1718 | 33 |
2175560 | 2175560 | 2022-02-02 | Lake | Minnesota | 27075 | 1899 | 26 |
2175833 | 2175833 | 2022-02-02 | Lake | Montana | 30047 | 5856 | 91 |
2176302 | 2176302 | 2022-02-02 | Lake | Ohio | 39085 | 48056 | 661 |
2176445 | 2176445 | 2022-02-02 | Lake | Oregon | 41037 | 1270 | 23 |
2176699 | 2176699 | 2022-02-02 | Lake | South Dakota | 46079 | 2273 | 26 |
2176774 | 2176774 | 2022-02-02 | Lake | Tennessee | 47095 | 2581 | 34 |
2171145 | 2171145 | 2022-02-01 | Lake | California | 6033 | 9971 | 119 |
2171221 | 2171221 | 2022-02-01 | Lake | Colorado | 8065 | 1721 | 2 |
2171298 | 2171298 | 2022-02-01 | Lake | Florida | 12069 | 78050 | 1276 |
2171593 | 2171593 | 2022-02-01 | Lake | Illinois | 17097 | 140683 | 1312 |
2171692 | 2171692 | 2022-02-01 | Lake | Indiana | 18089 | 103867 | 1671 |
2172228 | 2172228 | 2022-02-01 | Lake | Michigan | 26085 | 1687 | 33 |
2172307 | 2172307 | 2022-02-01 | Lake | Minnesota | 27075 | 1882 | 26 |
2172580 | 2172580 | 2022-02-01 | Lake | Montana | 30047 | 5820 | 91 |
2173048 | 2173048 | 2022-02-01 | Lake | Ohio | 39085 | 48010 | 661 |
2173191 | 2173191 | 2022-02-01 | Lake | Oregon | 41037 | 1254 | 23 |
2173445 | 2173445 | 2022-02-01 | Lake | South Dakota | 46079 | 2269 | 26 |
2173520 | 2173520 | 2022-02-01 | Lake | Tennessee | 47095 | 2489 | 34 |
2167892 | 2167892 | 2022-01-31 | Lake | California | 6033 | 9910 | 119 |
2167968 | 2167968 | 2022-01-31 | Lake | Colorado | 8065 | 1718 | 2 |
2168045 | 2168045 | 2022-01-31 | Lake | Florida | 12069 | 78050 | 1276 |
2168340 | 2168340 | 2022-01-31 | Lake | Illinois | 17097 | 140282 | 1308 |
2168439 | 2168439 | 2022-01-31 | Lake | Indiana | 18089 | 103679 | 1663 |
2168975 | 2168975 | 2022-01-31 | Lake | Michigan | 26085 | 1687 | 33 |
2169054 | 2169054 | 2022-01-31 | Lake | Minnesota | 27075 | 1849 | 26 |
2169327 | 2169327 | 2022-01-31 | Lake | Montana | 30047 | 5842 | 91 |
2169796 | 2169796 | 2022-01-31 | Lake | Ohio | 39085 | 47967 | 646 |
2169939 | 2169939 | 2022-01-31 | Lake | Oregon | 41037 | 1238 | 23 |
2170193 | 2170193 | 2022-01-31 | Lake | South Dakota | 46079 | 2262 | 26 |
2170268 | 2170268 | 2022-01-31 | Lake | Tennessee | 47095 | 2489 | 34 |
2164637 | 2164637 | 2022-01-30 | Lake | California | 6033 | 9577 | 119 |
2164713 | 2164713 | 2022-01-30 | Lake | Colorado | 8065 | 1710 | 2 |
2164790 | 2164790 | 2022-01-30 | Lake | Florida | 12069 | 78050 | 1276 |
2165085 | 2165085 | 2022-01-30 | Lake | Illinois | 17097 | 138901 | 1297 |
2165184 | 2165184 | 2022-01-30 | Lake | Indiana | 18089 | 103192 | 1653 |
2165720 | 2165720 | 2022-01-30 | Lake | Michigan | 26085 | 1664 | 33 |
2165799 | 2165799 | 2022-01-30 | Lake | Minnesota | 27075 | 1823 | 26 |
2166072 | 2166072 | 2022-01-30 | Lake | Montana | 30047 | 5784 | 91 |
2166541 | 2166541 | 2022-01-30 | Lake | Ohio | 39085 | 47924 | 646 |
2166684 | 2166684 | 2022-01-30 | Lake | Oregon | 41037 | 1234 | 23 |
2166939 | 2166939 | 2022-01-30 | Lake | South Dakota | 46079 | 2258 | 26 |
2167014 | 2167014 | 2022-01-30 | Lake | Tennessee | 47095 | 2489 | 34 |
2161382 | 2161382 | 2022-01-29 | Lake | California | 6033 | 9577 | 119 |
2161458 | 2161458 | 2022-01-29 | Lake | Colorado | 8065 | 1701 | 2 |
2161535 | 2161535 | 2022-01-29 | Lake | Florida | 12069 | 78050 | 1276 |
2161830 | 2161830 | 2022-01-29 | Lake | Illinois | 17097 | 138901 | 1297 |
2161929 | 2161929 | 2022-01-29 | Lake | Indiana | 18089 | 103192 | 1653 |
2162465 | 2162465 | 2022-01-29 | Lake | Michigan | 26085 | 1664 | 33 |
2162544 | 2162544 | 2022-01-29 | Lake | Minnesota | 27075 | 1823 | 26 |
2162817 | 2162817 | 2022-01-29 | Lake | Montana | 30047 | 5784 | 91 |
2163286 | 2163286 | 2022-01-29 | Lake | Ohio | 39085 | 47881 | 646 |
2163429 | 2163429 | 2022-01-29 | Lake | Oregon | 41037 | 1234 | 23 |
2163684 | 2163684 | 2022-01-29 | Lake | South Dakota | 46079 | 2258 | 26 |
2163759 | 2163759 | 2022-01-29 | Lake | Tennessee | 47095 | 2489 | 34 |
2158126 | 2158126 | 2022-01-28 | Lake | California | 6033 | 9577 | 119 |
2158202 | 2158202 | 2022-01-28 | Lake | Colorado | 8065 | 1710 | 2 |
2158279 | 2158279 | 2022-01-28 | Lake | Florida | 12069 | 78050 | 1276 |
2158575 | 2158575 | 2022-01-28 | Lake | Illinois | 17097 | 138901 | 1297 |
2158674 | 2158674 | 2022-01-28 | Lake | Indiana | 18089 | 103192 | 1653 |
2159210 | 2159210 | 2022-01-28 | Lake | Michigan | 26085 | 1664 | 33 |
2159289 | 2159289 | 2022-01-28 | Lake | Minnesota | 27075 | 1823 | 26 |
2159562 | 2159562 | 2022-01-28 | Lake | Montana | 30047 | 5784 | 91 |
2160031 | 2160031 | 2022-01-28 | Lake | Ohio | 39085 | 47837 | 646 |
2160174 | 2160174 | 2022-01-28 | Lake | Oregon | 41037 | 1234 | 23 |
2160429 | 2160429 | 2022-01-28 | Lake | South Dakota | 46079 | 2258 | 26 |
2160504 | 2160504 | 2022-01-28 | Lake | Tennessee | 47095 | 2489 | 34 |
2154873 | 2154873 | 2022-01-27 | Lake | California | 6033 | 9475 | 119 |
2154949 | 2154949 | 2022-01-27 | Lake | Colorado | 8065 | 1701 | 2 |
2155026 | 2155026 | 2022-01-27 | Lake | Florida | 12069 | 74451 | 1276 |
2155321 | 2155321 | 2022-01-27 | Lake | Illinois | 17097 | 137841 | 1292 |
2155420 | 2155420 | 2022-01-27 | Lake | Indiana | 18089 | 102780 | 1636 |
2155956 | 2155956 | 2022-01-27 | Lake | Michigan | 26085 | 1636 | 33 |
2156035 | 2156035 | 2022-01-27 | Lake | Minnesota | 27075 | 1796 | 26 |
2156308 | 2156308 | 2022-01-27 | Lake | Montana | 30047 | 5710 | 91 |
2156776 | 2156776 | 2022-01-27 | Lake | Ohio | 39085 | 47803 | 636 |
2156919 | 2156919 | 2022-01-27 | Lake | Oregon | 41037 | 1225 | 23 |
2157173 | 2157173 | 2022-01-27 | Lake | South Dakota | 46079 | 2247 | 26 |
2157248 | 2157248 | 2022-01-27 | Lake | Tennessee | 47095 | 2489 | 34 |
2151620 | 2151620 | 2022-01-26 | Lake | California | 6033 | 9126 | 118 |
2151696 | 2151696 | 2022-01-26 | Lake | Colorado | 8065 | 1698 | 2 |
2151773 | 2151773 | 2022-01-26 | Lake | Florida | 12069 | 74451 | 1276 |
2152068 | 2152068 | 2022-01-26 | Lake | Illinois | 17097 | 137048 | 1286 |
2152167 | 2152167 | 2022-01-26 | Lake | Indiana | 18089 | 102505 | 1624 |
2152703 | 2152703 | 2022-01-26 | Lake | Michigan | 26085 | 1636 | 33 |
2152782 | 2152782 | 2022-01-26 | Lake | Minnesota | 27075 | 1755 | 26 |
2153055 | 2153055 | 2022-01-26 | Lake | Montana | 30047 | 5614 | 91 |
2153523 | 2153523 | 2022-01-26 | Lake | Ohio | 39085 | 47723 | 636 |
2153666 | 2153666 | 2022-01-26 | Lake | Oregon | 41037 | 1221 | 23 |
2153920 | 2153920 | 2022-01-26 | Lake | South Dakota | 46079 | 2233 | 26 |
2153995 | 2153995 | 2022-01-26 | Lake | Tennessee | 47095 | 2489 | 34 |
2148368 | 2148368 | 2022-01-25 | Lake | California | 6033 | 9006 | 118 |
2148444 | 2148444 | 2022-01-25 | Lake | Colorado | 8065 | 1690 | 2 |
2148521 | 2148521 | 2022-01-25 | Lake | Florida | 12069 | 74451 | 1271 |
2148816 | 2148816 | 2022-01-25 | Lake | Illinois | 17097 | 136202 | 1284 |
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);