ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,175 rows where deaths = 4 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Mono 282
- Modoc 142
- Humboldt 101
- El Dorado 80
- Sierra 74
- Shasta 54
- Plumas 52
- Mariposa 48
- Sonoma 47
- Tuolumne 41
- Napa 28
- Trinity 27
- Yuba 27
- San Benito 21
- Sutter 20
- Santa Cruz 16
- Butte 12
- Colusa 12
- Monterey 9
- Stanislaus 8
- Tehama 8
- Del Norte 7
- Madera 6
- Solano 6
- Placer 5
- Kern 4
- San Luis Obispo 4
- Lake 3
- Merced 3
- Santa Barbara 3
- …
state 1
- California · 1,175 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499807 | 2499807 | 2022-05-13 | Sierra | California | 6091 | 324 | 4 |
2496549 | 2496549 | 2022-05-12 | Sierra | California | 6091 | 324 | 4 |
2493291 | 2493291 | 2022-05-11 | Sierra | California | 6091 | 324 | 4 |
2490033 | 2490033 | 2022-05-10 | Sierra | California | 6091 | 324 | 4 |
2486776 | 2486776 | 2022-05-09 | Sierra | California | 6091 | 324 | 4 |
2483518 | 2483518 | 2022-05-08 | Sierra | California | 6091 | 324 | 4 |
2480260 | 2480260 | 2022-05-07 | Sierra | California | 6091 | 324 | 4 |
2477002 | 2477002 | 2022-05-06 | Sierra | California | 6091 | 324 | 4 |
2473744 | 2473744 | 2022-05-05 | Sierra | California | 6091 | 323 | 4 |
2470487 | 2470487 | 2022-05-04 | Sierra | California | 6091 | 323 | 4 |
2467231 | 2467231 | 2022-05-03 | Sierra | California | 6091 | 323 | 4 |
2463976 | 2463976 | 2022-05-02 | Sierra | California | 6091 | 322 | 4 |
2460720 | 2460720 | 2022-05-01 | Sierra | California | 6091 | 322 | 4 |
2457464 | 2457464 | 2022-04-30 | Sierra | California | 6091 | 322 | 4 |
2454208 | 2454208 | 2022-04-29 | Sierra | California | 6091 | 322 | 4 |
2450952 | 2450952 | 2022-04-28 | Sierra | California | 6091 | 324 | 4 |
2447696 | 2447696 | 2022-04-27 | Sierra | California | 6091 | 324 | 4 |
2444440 | 2444440 | 2022-04-26 | Sierra | California | 6091 | 324 | 4 |
2441184 | 2441184 | 2022-04-25 | Sierra | California | 6091 | 324 | 4 |
2437928 | 2437928 | 2022-04-24 | Sierra | California | 6091 | 324 | 4 |
2434672 | 2434672 | 2022-04-23 | Sierra | California | 6091 | 324 | 4 |
2431416 | 2431416 | 2022-04-22 | Sierra | California | 6091 | 324 | 4 |
2428160 | 2428160 | 2022-04-21 | Sierra | California | 6091 | 318 | 4 |
2424904 | 2424904 | 2022-04-20 | Sierra | California | 6091 | 318 | 4 |
2421648 | 2421648 | 2022-04-19 | Sierra | California | 6091 | 318 | 4 |
2418392 | 2418392 | 2022-04-18 | Sierra | California | 6091 | 318 | 4 |
2415136 | 2415136 | 2022-04-17 | Sierra | California | 6091 | 318 | 4 |
2411880 | 2411880 | 2022-04-16 | Sierra | California | 6091 | 318 | 4 |
2408624 | 2408624 | 2022-04-15 | Sierra | California | 6091 | 318 | 4 |
2405368 | 2405368 | 2022-04-14 | Sierra | California | 6091 | 318 | 4 |
2402113 | 2402113 | 2022-04-13 | Sierra | California | 6091 | 314 | 4 |
2398858 | 2398858 | 2022-04-12 | Sierra | California | 6091 | 314 | 4 |
2395603 | 2395603 | 2022-04-11 | Sierra | California | 6091 | 314 | 4 |
2392347 | 2392347 | 2022-04-10 | Sierra | California | 6091 | 314 | 4 |
2389091 | 2389091 | 2022-04-09 | Sierra | California | 6091 | 314 | 4 |
2385836 | 2385836 | 2022-04-08 | Sierra | California | 6091 | 314 | 4 |
2382581 | 2382581 | 2022-04-07 | Sierra | California | 6091 | 314 | 4 |
2379326 | 2379326 | 2022-04-06 | Sierra | California | 6091 | 314 | 4 |
2376072 | 2376072 | 2022-04-05 | Sierra | California | 6091 | 314 | 4 |
2372820 | 2372820 | 2022-04-04 | Sierra | California | 6091 | 315 | 4 |
2369567 | 2369567 | 2022-04-03 | Sierra | California | 6091 | 315 | 4 |
2366314 | 2366314 | 2022-04-02 | Sierra | California | 6091 | 315 | 4 |
2363061 | 2363061 | 2022-04-01 | Sierra | California | 6091 | 315 | 4 |
2359807 | 2359807 | 2022-03-31 | Sierra | California | 6091 | 315 | 4 |
2356553 | 2356553 | 2022-03-30 | Sierra | California | 6091 | 315 | 4 |
2353300 | 2353300 | 2022-03-29 | Sierra | California | 6091 | 315 | 4 |
2350048 | 2350048 | 2022-03-28 | Sierra | California | 6091 | 315 | 4 |
2346795 | 2346795 | 2022-03-27 | Sierra | California | 6091 | 315 | 4 |
2343542 | 2343542 | 2022-03-26 | Sierra | California | 6091 | 315 | 4 |
2340289 | 2340289 | 2022-03-25 | Sierra | California | 6091 | 315 | 4 |
2337036 | 2337036 | 2022-03-24 | Sierra | California | 6091 | 315 | 4 |
2333782 | 2333782 | 2022-03-23 | Sierra | California | 6091 | 315 | 4 |
2330528 | 2330528 | 2022-03-22 | Sierra | California | 6091 | 315 | 4 |
2327276 | 2327276 | 2022-03-21 | Sierra | California | 6091 | 315 | 4 |
2324023 | 2324023 | 2022-03-20 | Sierra | California | 6091 | 315 | 4 |
2320769 | 2320769 | 2022-03-19 | Sierra | California | 6091 | 315 | 4 |
2317515 | 2317515 | 2022-03-18 | Sierra | California | 6091 | 315 | 4 |
2314262 | 2314262 | 2022-03-17 | Sierra | California | 6091 | 315 | 4 |
2311009 | 2311009 | 2022-03-16 | Sierra | California | 6091 | 315 | 4 |
2307756 | 2307756 | 2022-03-15 | Sierra | California | 6091 | 315 | 4 |
2304505 | 2304505 | 2022-03-14 | Sierra | California | 6091 | 315 | 4 |
2301253 | 2301253 | 2022-03-13 | Sierra | California | 6091 | 315 | 4 |
2298001 | 2298001 | 2022-03-12 | Sierra | California | 6091 | 315 | 4 |
2294749 | 2294749 | 2022-03-11 | Sierra | California | 6091 | 315 | 4 |
2291497 | 2291497 | 2022-03-10 | Sierra | California | 6091 | 315 | 4 |
2288245 | 2288245 | 2022-03-09 | Sierra | California | 6091 | 314 | 4 |
2284994 | 2284994 | 2022-03-08 | Sierra | California | 6091 | 314 | 4 |
2281742 | 2281742 | 2022-03-07 | Sierra | California | 6091 | 314 | 4 |
2278489 | 2278489 | 2022-03-06 | Sierra | California | 6091 | 314 | 4 |
2275236 | 2275236 | 2022-03-05 | Sierra | California | 6091 | 314 | 4 |
2271983 | 2271983 | 2022-03-04 | Sierra | California | 6091 | 314 | 4 |
2268731 | 2268731 | 2022-03-03 | Sierra | California | 6091 | 314 | 4 |
2262227 | 2262227 | 2022-03-01 | Sierra | California | 6091 | 313 | 4 |
2258976 | 2258976 | 2022-02-28 | Sierra | California | 6091 | 313 | 4 |
2154882 | 2154882 | 2022-01-27 | Mono | California | 6051 | 2967 | 4 |
2151629 | 2151629 | 2022-01-26 | Mono | California | 6051 | 2929 | 4 |
2148377 | 2148377 | 2022-01-25 | Mono | California | 6051 | 2905 | 4 |
2145125 | 2145125 | 2022-01-24 | Mono | California | 6051 | 2891 | 4 |
2141870 | 2141870 | 2022-01-23 | Mono | California | 6051 | 2826 | 4 |
2138615 | 2138615 | 2022-01-22 | Mono | California | 6051 | 2826 | 4 |
2135359 | 2135359 | 2022-01-21 | Mono | California | 6051 | 2826 | 4 |
2132107 | 2132107 | 2022-01-20 | Mono | California | 6051 | 2780 | 4 |
2128854 | 2128854 | 2022-01-19 | Mono | California | 6051 | 2729 | 4 |
2125600 | 2125600 | 2022-01-18 | Mono | California | 6051 | 2728 | 4 |
2122348 | 2122348 | 2022-01-17 | Mono | California | 6051 | 2700 | 4 |
2119096 | 2119096 | 2022-01-16 | Mono | California | 6051 | 2594 | 4 |
2115844 | 2115844 | 2022-01-15 | Mono | California | 6051 | 2594 | 4 |
2112593 | 2112593 | 2022-01-14 | Mono | California | 6051 | 2594 | 4 |
2109341 | 2109341 | 2022-01-13 | Mono | California | 6051 | 2552 | 4 |
2106090 | 2106090 | 2022-01-12 | Mono | California | 6051 | 2458 | 4 |
2102839 | 2102839 | 2022-01-11 | Mono | California | 6051 | 2448 | 4 |
2099588 | 2099588 | 2022-01-10 | Mono | California | 6051 | 2423 | 4 |
2096337 | 2096337 | 2022-01-09 | Mono | California | 6051 | 2273 | 4 |
2093085 | 2093085 | 2022-01-08 | Mono | California | 6051 | 2273 | 4 |
2089833 | 2089833 | 2022-01-07 | Mono | California | 6051 | 2273 | 4 |
2086582 | 2086582 | 2022-01-06 | Mono | California | 6051 | 2234 | 4 |
2083330 | 2083330 | 2022-01-05 | Mono | California | 6051 | 2211 | 4 |
2080078 | 2080078 | 2022-01-04 | Mono | California | 6051 | 2193 | 4 |
2076826 | 2076826 | 2022-01-03 | Mono | California | 6051 | 2122 | 4 |
2073575 | 2073575 | 2022-01-02 | Mono | California | 6051 | 2122 | 4 |
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);