ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "El Dorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174390 | 2174390 | 2022-02-02 | El Dorado | California | 6017 | 27516 | 184 |
2171137 | 2171137 | 2022-02-01 | El Dorado | California | 6017 | 27397 | 184 |
2167884 | 2167884 | 2022-01-31 | El Dorado | California | 6017 | 27343 | 184 |
2164629 | 2164629 | 2022-01-30 | El Dorado | California | 6017 | 26860 | 184 |
2161374 | 2161374 | 2022-01-29 | El Dorado | California | 6017 | 26860 | 184 |
2158118 | 2158118 | 2022-01-28 | El Dorado | California | 6017 | 26860 | 184 |
2154865 | 2154865 | 2022-01-27 | El Dorado | California | 6017 | 26671 | 181 |
2151612 | 2151612 | 2022-01-26 | El Dorado | California | 6017 | 25911 | 179 |
2148360 | 2148360 | 2022-01-25 | El Dorado | California | 6017 | 25700 | 179 |
2145108 | 2145108 | 2022-01-24 | El Dorado | California | 6017 | 25497 | 179 |
2141853 | 2141853 | 2022-01-23 | El Dorado | California | 6017 | 24845 | 179 |
2138598 | 2138598 | 2022-01-22 | El Dorado | California | 6017 | 24845 | 179 |
2135342 | 2135342 | 2022-01-21 | El Dorado | California | 6017 | 24845 | 179 |
2132090 | 2132090 | 2022-01-20 | El Dorado | California | 6017 | 24525 | 177 |
2128837 | 2128837 | 2022-01-19 | El Dorado | California | 6017 | 23973 | 175 |
2125583 | 2125583 | 2022-01-18 | El Dorado | California | 6017 | 23806 | 175 |
2122331 | 2122331 | 2022-01-17 | El Dorado | California | 6017 | 23569 | 175 |
2119079 | 2119079 | 2022-01-16 | El Dorado | California | 6017 | 22700 | 175 |
2115827 | 2115827 | 2022-01-15 | El Dorado | California | 6017 | 22700 | 175 |
2112576 | 2112576 | 2022-01-14 | El Dorado | California | 6017 | 22700 | 175 |
2109324 | 2109324 | 2022-01-13 | El Dorado | California | 6017 | 22358 | 175 |
2106073 | 2106073 | 2022-01-12 | El Dorado | California | 6017 | 21890 | 174 |
2102822 | 2102822 | 2022-01-11 | El Dorado | California | 6017 | 21654 | 172 |
2099571 | 2099571 | 2022-01-10 | El Dorado | California | 6017 | 21478 | 172 |
2096320 | 2096320 | 2022-01-09 | El Dorado | California | 6017 | 20647 | 172 |
2093068 | 2093068 | 2022-01-08 | El Dorado | California | 6017 | 20647 | 172 |
2089816 | 2089816 | 2022-01-07 | El Dorado | California | 6017 | 20647 | 172 |
2086565 | 2086565 | 2022-01-06 | El Dorado | California | 6017 | 20415 | 172 |
2083313 | 2083313 | 2022-01-05 | El Dorado | California | 6017 | 20274 | 172 |
2080061 | 2080061 | 2022-01-04 | El Dorado | California | 6017 | 20118 | 172 |
2076809 | 2076809 | 2022-01-03 | El Dorado | California | 6017 | 19556 | 172 |
2073558 | 2073558 | 2022-01-02 | El Dorado | California | 6017 | 19556 | 172 |
2070307 | 2070307 | 2022-01-01 | El Dorado | California | 6017 | 19556 | 172 |
2067056 | 2067056 | 2021-12-31 | El Dorado | California | 6017 | 19556 | 172 |
2063805 | 2063805 | 2021-12-30 | El Dorado | California | 6017 | 19424 | 172 |
2060555 | 2060555 | 2021-12-29 | El Dorado | California | 6017 | 19295 | 172 |
2057306 | 2057306 | 2021-12-28 | El Dorado | California | 6017 | 19237 | 172 |
2054057 | 2054057 | 2021-12-27 | El Dorado | California | 6017 | 19064 | 172 |
2050807 | 2050807 | 2021-12-26 | El Dorado | California | 6017 | 19064 | 172 |
2047557 | 2047557 | 2021-12-25 | El Dorado | California | 6017 | 19064 | 172 |
2044307 | 2044307 | 2021-12-24 | El Dorado | California | 6017 | 19064 | 172 |
2041058 | 2041058 | 2021-12-23 | El Dorado | California | 6017 | 19016 | 172 |
2037808 | 2037808 | 2021-12-22 | El Dorado | California | 6017 | 18956 | 172 |
2034558 | 2034558 | 2021-12-21 | El Dorado | California | 6017 | 18941 | 172 |
2031308 | 2031308 | 2021-12-20 | El Dorado | California | 6017 | 18925 | 172 |
2028057 | 2028057 | 2021-12-19 | El Dorado | California | 6017 | 18826 | 171 |
2024806 | 2024806 | 2021-12-18 | El Dorado | California | 6017 | 18826 | 171 |
2021555 | 2021555 | 2021-12-17 | El Dorado | California | 6017 | 18826 | 171 |
2018304 | 2018304 | 2021-12-16 | El Dorado | California | 6017 | 18794 | 171 |
2015054 | 2015054 | 2021-12-15 | El Dorado | California | 6017 | 18755 | 170 |
2011803 | 2011803 | 2021-12-14 | El Dorado | California | 6017 | 18736 | 170 |
2008552 | 2008552 | 2021-12-13 | El Dorado | California | 6017 | 18730 | 170 |
2005301 | 2005301 | 2021-12-12 | El Dorado | California | 6017 | 18636 | 170 |
2002050 | 2002050 | 2021-12-11 | El Dorado | California | 6017 | 18636 | 170 |
1998800 | 1998800 | 2021-12-10 | El Dorado | California | 6017 | 18636 | 170 |
1995549 | 1995549 | 2021-12-09 | El Dorado | California | 6017 | 18597 | 170 |
1992298 | 1992298 | 2021-12-08 | El Dorado | California | 6017 | 18569 | 170 |
1989047 | 1989047 | 2021-12-07 | El Dorado | California | 6017 | 18553 | 168 |
1985797 | 1985797 | 2021-12-06 | El Dorado | California | 6017 | 18544 | 168 |
1982547 | 1982547 | 2021-12-05 | El Dorado | California | 6017 | 18448 | 168 |
1979297 | 1979297 | 2021-12-04 | El Dorado | California | 6017 | 18448 | 168 |
1976047 | 1976047 | 2021-12-03 | El Dorado | California | 6017 | 18448 | 168 |
1972798 | 1972798 | 2021-12-02 | El Dorado | California | 6017 | 18402 | 166 |
1969548 | 1969548 | 2021-12-01 | El Dorado | California | 6017 | 18325 | 166 |
1966298 | 1966298 | 2021-11-30 | El Dorado | California | 6017 | 18301 | 166 |
1963046 | 1963046 | 2021-11-29 | El Dorado | California | 6017 | 18294 | 166 |
1959795 | 1959795 | 2021-11-28 | El Dorado | California | 6017 | 18166 | 161 |
1956544 | 1956544 | 2021-11-27 | El Dorado | California | 6017 | 18166 | 161 |
1953293 | 1953293 | 2021-11-26 | El Dorado | California | 6017 | 18166 | 161 |
1950042 | 1950042 | 2021-11-25 | El Dorado | California | 6017 | 18166 | 161 |
1946791 | 1946791 | 2021-11-24 | El Dorado | California | 6017 | 18166 | 161 |
1943540 | 1943540 | 2021-11-23 | El Dorado | California | 6017 | 18145 | 161 |
1940290 | 1940290 | 2021-11-22 | El Dorado | California | 6017 | 18137 | 161 |
1937040 | 1937040 | 2021-11-21 | El Dorado | California | 6017 | 18075 | 161 |
1933790 | 1933790 | 2021-11-20 | El Dorado | California | 6017 | 18075 | 161 |
1930538 | 1930538 | 2021-11-19 | El Dorado | California | 6017 | 18075 | 161 |
1927288 | 1927288 | 2021-11-18 | El Dorado | California | 6017 | 18036 | 161 |
1924038 | 1924038 | 2021-11-17 | El Dorado | California | 6017 | 18000 | 159 |
1920789 | 1920789 | 2021-11-16 | El Dorado | California | 6017 | 17988 | 159 |
1917539 | 1917539 | 2021-11-15 | El Dorado | California | 6017 | 17964 | 160 |
1914289 | 1914289 | 2021-11-14 | El Dorado | California | 6017 | 17915 | 159 |
1911039 | 1911039 | 2021-11-13 | El Dorado | California | 6017 | 17915 | 159 |
1907790 | 1907790 | 2021-11-12 | El Dorado | California | 6017 | 17837 | 159 |
1904541 | 1904541 | 2021-11-11 | El Dorado | California | 6017 | 17837 | 159 |
1901291 | 1901291 | 2021-11-10 | El Dorado | California | 6017 | 17797 | 160 |
1898041 | 1898041 | 2021-11-09 | El Dorado | California | 6017 | 17779 | 156 |
1894791 | 1894791 | 2021-11-08 | El Dorado | California | 6017 | 17764 | 156 |
1891541 | 1891541 | 2021-11-07 | El Dorado | California | 6017 | 17682 | 156 |
1888291 | 1888291 | 2021-11-06 | El Dorado | California | 6017 | 17682 | 156 |
1885041 | 1885041 | 2021-11-05 | El Dorado | California | 6017 | 17682 | 156 |
1881792 | 1881792 | 2021-11-04 | El Dorado | California | 6017 | 17639 | 156 |
1878543 | 1878543 | 2021-11-03 | El Dorado | California | 6017 | 17592 | 154 |
1875294 | 1875294 | 2021-11-02 | El Dorado | California | 6017 | 17567 | 154 |
1872045 | 1872045 | 2021-11-01 | El Dorado | California | 6017 | 17550 | 154 |
1868796 | 1868796 | 2021-10-31 | El Dorado | California | 6017 | 17461 | 154 |
1865547 | 1865547 | 2021-10-30 | El Dorado | California | 6017 | 17461 | 154 |
1862298 | 1862298 | 2021-10-29 | El Dorado | California | 6017 | 17461 | 154 |
1859049 | 1859049 | 2021-10-28 | El Dorado | California | 6017 | 17432 | 154 |
1855800 | 1855800 | 2021-10-27 | El Dorado | California | 6017 | 17357 | 153 |
1852551 | 1852551 | 2021-10-26 | El Dorado | California | 6017 | 17330 | 149 |
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);