ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
337 rows where deaths = 13 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Plumas 98
- Napa 56
- Siskiyou 40
- Colusa 20
- Mariposa 19
- Inyo 13
- San Benito 9
- Lassen 8
- Ventura 8
- Marin 7
- Sutter 7
- El Dorado 5
- Lake 4
- San Mateo 4
- Calaveras 3
- San Bernardino 3
- Amador 2
- Fresno 2
- Madera 2
- Orange 2
- Placer 2
- Riverside 2
- San Francisco 2
- Stanislaus 2
- Trinity 2
- Tulare 2
- Yolo 2
- Alameda 1
- Del Norte 1
- Humboldt 1
- …
state 1
- California · 337 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499793 | 2499793 | 2022-05-13 | Plumas | California | 6063 | 3379 | 13 |
2496535 | 2496535 | 2022-05-12 | Plumas | California | 6063 | 3362 | 13 |
2493277 | 2493277 | 2022-05-11 | Plumas | California | 6063 | 3362 | 13 |
2490019 | 2490019 | 2022-05-10 | Plumas | California | 6063 | 3362 | 13 |
2486762 | 2486762 | 2022-05-09 | Plumas | California | 6063 | 3360 | 13 |
2483504 | 2483504 | 2022-05-08 | Plumas | California | 6063 | 3360 | 13 |
2480246 | 2480246 | 2022-05-07 | Plumas | California | 6063 | 3360 | 13 |
2476988 | 2476988 | 2022-05-06 | Plumas | California | 6063 | 3360 | 13 |
2473730 | 2473730 | 2022-05-05 | Plumas | California | 6063 | 3312 | 13 |
2470473 | 2470473 | 2022-05-04 | Plumas | California | 6063 | 3312 | 13 |
2467217 | 2467217 | 2022-05-03 | Plumas | California | 6063 | 3312 | 13 |
2463962 | 2463962 | 2022-05-02 | Plumas | California | 6063 | 3311 | 13 |
2460706 | 2460706 | 2022-05-01 | Plumas | California | 6063 | 3311 | 13 |
2457450 | 2457450 | 2022-04-30 | Plumas | California | 6063 | 3311 | 13 |
2454194 | 2454194 | 2022-04-29 | Plumas | California | 6063 | 3311 | 13 |
2450938 | 2450938 | 2022-04-28 | Plumas | California | 6063 | 3299 | 13 |
2447682 | 2447682 | 2022-04-27 | Plumas | California | 6063 | 3299 | 13 |
2444426 | 2444426 | 2022-04-26 | Plumas | California | 6063 | 3299 | 13 |
2441170 | 2441170 | 2022-04-25 | Plumas | California | 6063 | 3299 | 13 |
2437914 | 2437914 | 2022-04-24 | Plumas | California | 6063 | 3299 | 13 |
2434658 | 2434658 | 2022-04-23 | Plumas | California | 6063 | 3299 | 13 |
2431402 | 2431402 | 2022-04-22 | Plumas | California | 6063 | 3299 | 13 |
2428146 | 2428146 | 2022-04-21 | Plumas | California | 6063 | 3298 | 13 |
2424890 | 2424890 | 2022-04-20 | Plumas | California | 6063 | 3298 | 13 |
2421634 | 2421634 | 2022-04-19 | Plumas | California | 6063 | 3298 | 13 |
2418378 | 2418378 | 2022-04-18 | Plumas | California | 6063 | 3295 | 13 |
2415122 | 2415122 | 2022-04-17 | Plumas | California | 6063 | 3295 | 13 |
2411866 | 2411866 | 2022-04-16 | Plumas | California | 6063 | 3295 | 13 |
2408610 | 2408610 | 2022-04-15 | Plumas | California | 6063 | 3295 | 13 |
2405354 | 2405354 | 2022-04-14 | Plumas | California | 6063 | 3289 | 13 |
2402099 | 2402099 | 2022-04-13 | Plumas | California | 6063 | 3247 | 13 |
2398844 | 2398844 | 2022-04-12 | Plumas | California | 6063 | 3247 | 13 |
2395589 | 2395589 | 2022-04-11 | Plumas | California | 6063 | 3247 | 13 |
2359793 | 2359793 | 2022-03-31 | Plumas | California | 6063 | 3122 | 13 |
2356539 | 2356539 | 2022-03-30 | Plumas | California | 6063 | 3118 | 13 |
2353286 | 2353286 | 2022-03-29 | Plumas | California | 6063 | 3117 | 13 |
2350034 | 2350034 | 2022-03-28 | Plumas | California | 6063 | 3117 | 13 |
2346781 | 2346781 | 2022-03-27 | Plumas | California | 6063 | 3115 | 13 |
2343528 | 2343528 | 2022-03-26 | Plumas | California | 6063 | 3115 | 13 |
2340275 | 2340275 | 2022-03-25 | Plumas | California | 6063 | 3115 | 13 |
2337022 | 2337022 | 2022-03-24 | Plumas | California | 6063 | 3104 | 13 |
2333768 | 2333768 | 2022-03-23 | Plumas | California | 6063 | 3098 | 13 |
2330514 | 2330514 | 2022-03-22 | Plumas | California | 6063 | 3098 | 13 |
2327262 | 2327262 | 2022-03-21 | Plumas | California | 6063 | 3098 | 13 |
2324009 | 2324009 | 2022-03-20 | Plumas | California | 6063 | 3078 | 13 |
2320755 | 2320755 | 2022-03-19 | Plumas | California | 6063 | 3078 | 13 |
2317501 | 2317501 | 2022-03-18 | Plumas | California | 6063 | 3078 | 13 |
2314248 | 2314248 | 2022-03-17 | Plumas | California | 6063 | 3077 | 13 |
2310995 | 2310995 | 2022-03-16 | Plumas | California | 6063 | 3077 | 13 |
2307742 | 2307742 | 2022-03-15 | Plumas | California | 6063 | 3066 | 13 |
2304491 | 2304491 | 2022-03-14 | Plumas | California | 6063 | 3066 | 13 |
2301239 | 2301239 | 2022-03-13 | Plumas | California | 6063 | 3062 | 13 |
2297987 | 2297987 | 2022-03-12 | Plumas | California | 6063 | 3062 | 13 |
2294735 | 2294735 | 2022-03-11 | Plumas | California | 6063 | 3062 | 13 |
2291483 | 2291483 | 2022-03-10 | Plumas | California | 6063 | 3063 | 13 |
2288231 | 2288231 | 2022-03-09 | Plumas | California | 6063 | 3055 | 13 |
2284980 | 2284980 | 2022-03-08 | Plumas | California | 6063 | 3053 | 13 |
2281728 | 2281728 | 2022-03-07 | Plumas | California | 6063 | 3055 | 13 |
2278475 | 2278475 | 2022-03-06 | Plumas | California | 6063 | 3052 | 13 |
2275222 | 2275222 | 2022-03-05 | Plumas | California | 6063 | 3052 | 13 |
2271969 | 2271969 | 2022-03-04 | Plumas | California | 6063 | 3052 | 13 |
2268717 | 2268717 | 2022-03-03 | Plumas | California | 6063 | 3051 | 13 |
2265464 | 2265464 | 2022-03-02 | Plumas | California | 6063 | 3032 | 13 |
2262213 | 2262213 | 2022-03-01 | Plumas | California | 6063 | 3029 | 13 |
2258962 | 2258962 | 2022-02-28 | Plumas | California | 6063 | 3029 | 13 |
2255711 | 2255711 | 2022-02-27 | Plumas | California | 6063 | 3011 | 13 |
2252460 | 2252460 | 2022-02-26 | Plumas | California | 6063 | 3011 | 13 |
2249209 | 2249209 | 2022-02-25 | Plumas | California | 6063 | 3011 | 13 |
2245958 | 2245958 | 2022-02-24 | Plumas | California | 6063 | 3001 | 13 |
2242707 | 2242707 | 2022-02-23 | Plumas | California | 6063 | 2992 | 13 |
2239456 | 2239456 | 2022-02-22 | Plumas | California | 6063 | 2990 | 13 |
2236205 | 2236205 | 2022-02-21 | Plumas | California | 6063 | 2989 | 13 |
2232954 | 2232954 | 2022-02-20 | Plumas | California | 6063 | 2989 | 13 |
2229703 | 2229703 | 2022-02-19 | Plumas | California | 6063 | 2989 | 13 |
2226452 | 2226452 | 2022-02-18 | Plumas | California | 6063 | 2989 | 13 |
2223201 | 2223201 | 2022-02-17 | Plumas | California | 6063 | 2982 | 13 |
2219950 | 2219950 | 2022-02-16 | Plumas | California | 6063 | 2989 | 13 |
2216699 | 2216699 | 2022-02-15 | Plumas | California | 6063 | 2982 | 13 |
2213448 | 2213448 | 2022-02-14 | Plumas | California | 6063 | 2977 | 13 |
2210196 | 2210196 | 2022-02-13 | Plumas | California | 6063 | 2968 | 13 |
2206943 | 2206943 | 2022-02-12 | Plumas | California | 6063 | 2968 | 13 |
2203690 | 2203690 | 2022-02-11 | Plumas | California | 6063 | 2968 | 13 |
2200437 | 2200437 | 2022-02-10 | Plumas | California | 6063 | 2960 | 13 |
2197183 | 2197183 | 2022-02-09 | Plumas | California | 6063 | 2937 | 13 |
2193928 | 2193928 | 2022-02-08 | Plumas | California | 6063 | 2914 | 13 |
2190675 | 2190675 | 2022-02-07 | Plumas | California | 6063 | 2900 | 13 |
2187422 | 2187422 | 2022-02-06 | Plumas | California | 6063 | 2891 | 13 |
2184169 | 2184169 | 2022-02-05 | Plumas | California | 6063 | 2891 | 13 |
2180917 | 2180917 | 2022-02-04 | Plumas | California | 6063 | 2891 | 13 |
2050830 | 2050830 | 2021-12-26 | Plumas | California | 6063 | 2047 | 13 |
2047580 | 2047580 | 2021-12-25 | Plumas | California | 6063 | 2047 | 13 |
2044330 | 2044330 | 2021-12-24 | Plumas | California | 6063 | 2047 | 13 |
2041081 | 2041081 | 2021-12-23 | Plumas | California | 6063 | 2046 | 13 |
2037831 | 2037831 | 2021-12-22 | Plumas | California | 6063 | 2034 | 13 |
2034581 | 2034581 | 2021-12-21 | Plumas | California | 6063 | 2030 | 13 |
2028080 | 2028080 | 2021-12-19 | Plumas | California | 6063 | 2023 | 13 |
2024829 | 2024829 | 2021-12-18 | Plumas | California | 6063 | 2023 | 13 |
2021578 | 2021578 | 2021-12-17 | Plumas | California | 6063 | 2023 | 13 |
1898085 | 1898085 | 2021-11-09 | Trinity | California | 6105 | 939 | 13 |
1894835 | 1894835 | 2021-11-08 | Trinity | California | 6105 | 938 | 13 |
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);