ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "El Dorado" and fips = 6017 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499770 | 2499770 | 2022-05-13 | El Dorado | California | 6017 | 30508 | 212 |
2496512 | 2496512 | 2022-05-12 | El Dorado | California | 6017 | 30428 | 212 |
2493254 | 2493254 | 2022-05-11 | El Dorado | California | 6017 | 30428 | 212 |
2489996 | 2489996 | 2022-05-10 | El Dorado | California | 6017 | 30428 | 212 |
2486739 | 2486739 | 2022-05-09 | El Dorado | California | 6017 | 30337 | 210 |
2483481 | 2483481 | 2022-05-08 | El Dorado | California | 6017 | 30337 | 210 |
2480223 | 2480223 | 2022-05-07 | El Dorado | California | 6017 | 30337 | 210 |
2476965 | 2476965 | 2022-05-06 | El Dorado | California | 6017 | 30337 | 210 |
2473707 | 2473707 | 2022-05-05 | El Dorado | California | 6017 | 30261 | 210 |
2470450 | 2470450 | 2022-05-04 | El Dorado | California | 6017 | 30261 | 210 |
2467194 | 2467194 | 2022-05-03 | El Dorado | California | 6017 | 30261 | 210 |
2463939 | 2463939 | 2022-05-02 | El Dorado | California | 6017 | 30186 | 210 |
2460683 | 2460683 | 2022-05-01 | El Dorado | California | 6017 | 30186 | 210 |
2457427 | 2457427 | 2022-04-30 | El Dorado | California | 6017 | 30186 | 210 |
2454171 | 2454171 | 2022-04-29 | El Dorado | California | 6017 | 30186 | 210 |
2450915 | 2450915 | 2022-04-28 | El Dorado | California | 6017 | 30123 | 209 |
2447659 | 2447659 | 2022-04-27 | El Dorado | California | 6017 | 30123 | 209 |
2444403 | 2444403 | 2022-04-26 | El Dorado | California | 6017 | 30123 | 209 |
2441147 | 2441147 | 2022-04-25 | El Dorado | California | 6017 | 30062 | 209 |
2437891 | 2437891 | 2022-04-24 | El Dorado | California | 6017 | 30062 | 209 |
2434635 | 2434635 | 2022-04-23 | El Dorado | California | 6017 | 30062 | 209 |
2431379 | 2431379 | 2022-04-22 | El Dorado | California | 6017 | 30062 | 209 |
2428123 | 2428123 | 2022-04-21 | El Dorado | California | 6017 | 30039 | 209 |
2424867 | 2424867 | 2022-04-20 | El Dorado | California | 6017 | 30039 | 209 |
2421611 | 2421611 | 2022-04-19 | El Dorado | California | 6017 | 30039 | 209 |
2418355 | 2418355 | 2022-04-18 | El Dorado | California | 6017 | 30014 | 209 |
2415099 | 2415099 | 2022-04-17 | El Dorado | California | 6017 | 30014 | 209 |
2411843 | 2411843 | 2022-04-16 | El Dorado | California | 6017 | 30014 | 209 |
2408587 | 2408587 | 2022-04-15 | El Dorado | California | 6017 | 30014 | 209 |
2405331 | 2405331 | 2022-04-14 | El Dorado | California | 6017 | 30012 | 208 |
2402076 | 2402076 | 2022-04-13 | El Dorado | California | 6017 | 29969 | 207 |
2398821 | 2398821 | 2022-04-12 | El Dorado | California | 6017 | 29969 | 207 |
2395566 | 2395566 | 2022-04-11 | El Dorado | California | 6017 | 29969 | 207 |
2392310 | 2392310 | 2022-04-10 | El Dorado | California | 6017 | 29969 | 207 |
2389054 | 2389054 | 2022-04-09 | El Dorado | California | 6017 | 29969 | 207 |
2385799 | 2385799 | 2022-04-08 | El Dorado | California | 6017 | 29969 | 207 |
2382544 | 2382544 | 2022-04-07 | El Dorado | California | 6017 | 29956 | 205 |
2379289 | 2379289 | 2022-04-06 | El Dorado | California | 6017 | 29956 | 205 |
2376035 | 2376035 | 2022-04-05 | El Dorado | California | 6017 | 29956 | 205 |
2372783 | 2372783 | 2022-04-04 | El Dorado | California | 6017 | 29944 | 200 |
2369530 | 2369530 | 2022-04-03 | El Dorado | California | 6017 | 29944 | 200 |
2366277 | 2366277 | 2022-04-02 | El Dorado | California | 6017 | 29944 | 200 |
2363024 | 2363024 | 2022-04-01 | El Dorado | California | 6017 | 29944 | 200 |
2359770 | 2359770 | 2022-03-31 | El Dorado | California | 6017 | 29934 | 200 |
2356516 | 2356516 | 2022-03-30 | El Dorado | California | 6017 | 29913 | 200 |
2353263 | 2353263 | 2022-03-29 | El Dorado | California | 6017 | 29910 | 200 |
2350011 | 2350011 | 2022-03-28 | El Dorado | California | 6017 | 29906 | 200 |
2346758 | 2346758 | 2022-03-27 | El Dorado | California | 6017 | 29881 | 200 |
2343505 | 2343505 | 2022-03-26 | El Dorado | California | 6017 | 29881 | 200 |
2340252 | 2340252 | 2022-03-25 | El Dorado | California | 6017 | 29881 | 200 |
2336999 | 2336999 | 2022-03-24 | El Dorado | California | 6017 | 29877 | 200 |
2333745 | 2333745 | 2022-03-23 | El Dorado | California | 6017 | 29864 | 200 |
2330491 | 2330491 | 2022-03-22 | El Dorado | California | 6017 | 29821 | 199 |
2327239 | 2327239 | 2022-03-21 | El Dorado | California | 6017 | 29811 | 199 |
2323986 | 2323986 | 2022-03-20 | El Dorado | California | 6017 | 29821 | 199 |
2320732 | 2320732 | 2022-03-19 | El Dorado | California | 6017 | 29821 | 199 |
2317478 | 2317478 | 2022-03-18 | El Dorado | California | 6017 | 29821 | 199 |
2314225 | 2314225 | 2022-03-17 | El Dorado | California | 6017 | 29805 | 199 |
2310972 | 2310972 | 2022-03-16 | El Dorado | California | 6017 | 29781 | 199 |
2307719 | 2307719 | 2022-03-15 | El Dorado | California | 6017 | 29755 | 199 |
2304468 | 2304468 | 2022-03-14 | El Dorado | California | 6017 | 29748 | 199 |
2301216 | 2301216 | 2022-03-13 | El Dorado | California | 6017 | 29723 | 199 |
2297964 | 2297964 | 2022-03-12 | El Dorado | California | 6017 | 29723 | 199 |
2294712 | 2294712 | 2022-03-11 | El Dorado | California | 6017 | 29723 | 199 |
2291460 | 2291460 | 2022-03-10 | El Dorado | California | 6017 | 29700 | 198 |
2288208 | 2288208 | 2022-03-09 | El Dorado | California | 6017 | 29661 | 197 |
2284957 | 2284957 | 2022-03-08 | El Dorado | California | 6017 | 29645 | 196 |
2281705 | 2281705 | 2022-03-07 | El Dorado | California | 6017 | 29636 | 196 |
2278452 | 2278452 | 2022-03-06 | El Dorado | California | 6017 | 29604 | 193 |
2275199 | 2275199 | 2022-03-05 | El Dorado | California | 6017 | 29604 | 193 |
2271946 | 2271946 | 2022-03-04 | El Dorado | California | 6017 | 29604 | 193 |
2268694 | 2268694 | 2022-03-03 | El Dorado | California | 6017 | 29591 | 192 |
2265441 | 2265441 | 2022-03-02 | El Dorado | California | 6017 | 29552 | 192 |
2262190 | 2262190 | 2022-03-01 | El Dorado | California | 6017 | 29548 | 191 |
2258939 | 2258939 | 2022-02-28 | El Dorado | California | 6017 | 29549 | 191 |
2255688 | 2255688 | 2022-02-27 | El Dorado | California | 6017 | 29494 | 191 |
2252437 | 2252437 | 2022-02-26 | El Dorado | California | 6017 | 29494 | 191 |
2249186 | 2249186 | 2022-02-25 | El Dorado | California | 6017 | 29494 | 191 |
2245935 | 2245935 | 2022-02-24 | El Dorado | California | 6017 | 29456 | 189 |
2242684 | 2242684 | 2022-02-23 | El Dorado | California | 6017 | 29361 | 189 |
2239433 | 2239433 | 2022-02-22 | El Dorado | California | 6017 | 29345 | 189 |
2236182 | 2236182 | 2022-02-21 | El Dorado | California | 6017 | 29173 | 189 |
2232931 | 2232931 | 2022-02-20 | El Dorado | California | 6017 | 29173 | 189 |
2229680 | 2229680 | 2022-02-19 | El Dorado | California | 6017 | 29173 | 189 |
2226429 | 2226429 | 2022-02-18 | El Dorado | California | 6017 | 29173 | 189 |
2223178 | 2223178 | 2022-02-17 | El Dorado | California | 6017 | 29133 | 189 |
2219927 | 2219927 | 2022-02-16 | El Dorado | California | 6017 | 29080 | 189 |
2216676 | 2216676 | 2022-02-15 | El Dorado | California | 6017 | 29007 | 188 |
2213425 | 2213425 | 2022-02-14 | El Dorado | California | 6017 | 28963 | 188 |
2210173 | 2210173 | 2022-02-13 | El Dorado | California | 6017 | 28784 | 188 |
2206920 | 2206920 | 2022-02-12 | El Dorado | California | 6017 | 28784 | 188 |
2203667 | 2203667 | 2022-02-11 | El Dorado | California | 6017 | 28784 | 188 |
2200414 | 2200414 | 2022-02-10 | El Dorado | California | 6017 | 28664 | 186 |
2197160 | 2197160 | 2022-02-09 | El Dorado | California | 6017 | 28472 | 186 |
2193905 | 2193905 | 2022-02-08 | El Dorado | California | 6017 | 28283 | 185 |
2190652 | 2190652 | 2022-02-07 | El Dorado | California | 6017 | 28191 | 185 |
2187399 | 2187399 | 2022-02-06 | El Dorado | California | 6017 | 27839 | 185 |
2184146 | 2184146 | 2022-02-05 | El Dorado | California | 6017 | 27839 | 185 |
2180894 | 2180894 | 2022-02-04 | El Dorado | California | 6017 | 27839 | 185 |
2177643 | 2177643 | 2022-02-03 | El Dorado | California | 6017 | 27716 | 185 |
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);