ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
599 rows where deaths = 6 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 216
- Colusa 103
- Mono 49
- Modoc 34
- Del Norte 30
- Monterey 13
- Yuba 13
- Kings 12
- Merced 11
- Sutter 11
- Glenn 10
- Humboldt 10
- Shasta 8
- Trinity 8
- Santa Cruz 7
- Nevada 6
- San Luis Obispo 6
- Tuolumne 6
- Ventura 6
- Mendocino 5
- San Mateo 4
- Lassen 3
- Riverside 3
- Sacramento 3
- Alameda 2
- Lake 2
- Marin 2
- San Bernardino 2
- San Francisco 2
- Santa Barbara 2
- …
state 1
- California · 599 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499787 | 2499787 | 2022-05-13 | Mono | California | 6051 | 3144 | 6 |
2496529 | 2496529 | 2022-05-12 | Mono | California | 6051 | 3127 | 6 |
2493271 | 2493271 | 2022-05-11 | Mono | California | 6051 | 3127 | 6 |
2490013 | 2490013 | 2022-05-10 | Mono | California | 6051 | 3127 | 6 |
2486756 | 2486756 | 2022-05-09 | Mono | California | 6051 | 3125 | 6 |
2483498 | 2483498 | 2022-05-08 | Mono | California | 6051 | 3125 | 6 |
2480240 | 2480240 | 2022-05-07 | Mono | California | 6051 | 3125 | 6 |
2476982 | 2476982 | 2022-05-06 | Mono | California | 6051 | 3125 | 6 |
2473724 | 2473724 | 2022-05-05 | Mono | California | 6051 | 3120 | 6 |
2470467 | 2470467 | 2022-05-04 | Mono | California | 6051 | 3120 | 6 |
2467211 | 2467211 | 2022-05-03 | Mono | California | 6051 | 3120 | 6 |
2463956 | 2463956 | 2022-05-02 | Mono | California | 6051 | 3116 | 6 |
2460700 | 2460700 | 2022-05-01 | Mono | California | 6051 | 3116 | 6 |
2457444 | 2457444 | 2022-04-30 | Mono | California | 6051 | 3116 | 6 |
2454188 | 2454188 | 2022-04-29 | Mono | California | 6051 | 3116 | 6 |
2450932 | 2450932 | 2022-04-28 | Mono | California | 6051 | 3116 | 6 |
2447676 | 2447676 | 2022-04-27 | Mono | California | 6051 | 3116 | 6 |
2444420 | 2444420 | 2022-04-26 | Mono | California | 6051 | 3116 | 6 |
2441164 | 2441164 | 2022-04-25 | Mono | California | 6051 | 3113 | 6 |
2437908 | 2437908 | 2022-04-24 | Mono | California | 6051 | 3113 | 6 |
2434652 | 2434652 | 2022-04-23 | Mono | California | 6051 | 3113 | 6 |
2431396 | 2431396 | 2022-04-22 | Mono | California | 6051 | 3113 | 6 |
2428140 | 2428140 | 2022-04-21 | Mono | California | 6051 | 3107 | 6 |
2424884 | 2424884 | 2022-04-20 | Mono | California | 6051 | 3107 | 6 |
2421628 | 2421628 | 2022-04-19 | Mono | California | 6051 | 3107 | 6 |
2418372 | 2418372 | 2022-04-18 | Mono | California | 6051 | 3100 | 6 |
2415116 | 2415116 | 2022-04-17 | Mono | California | 6051 | 3100 | 6 |
2411860 | 2411860 | 2022-04-16 | Mono | California | 6051 | 3100 | 6 |
2408604 | 2408604 | 2022-04-15 | Mono | California | 6051 | 3100 | 6 |
2405348 | 2405348 | 2022-04-14 | Mono | California | 6051 | 3094 | 6 |
2402093 | 2402093 | 2022-04-13 | Mono | California | 6051 | 3089 | 6 |
2398838 | 2398838 | 2022-04-12 | Mono | California | 6051 | 3089 | 6 |
2395583 | 2395583 | 2022-04-11 | Mono | California | 6051 | 3089 | 6 |
2392327 | 2392327 | 2022-04-10 | Mono | California | 6051 | 3089 | 6 |
2389071 | 2389071 | 2022-04-09 | Mono | California | 6051 | 3089 | 6 |
2385816 | 2385816 | 2022-04-08 | Mono | California | 6051 | 3089 | 6 |
2382561 | 2382561 | 2022-04-07 | Mono | California | 6051 | 3089 | 6 |
2379306 | 2379306 | 2022-04-06 | Mono | California | 6051 | 3089 | 6 |
2376052 | 2376052 | 2022-04-05 | Mono | California | 6051 | 3089 | 6 |
2372800 | 2372800 | 2022-04-04 | Mono | California | 6051 | 3089 | 6 |
2369547 | 2369547 | 2022-04-03 | Mono | California | 6051 | 3089 | 6 |
2366294 | 2366294 | 2022-04-02 | Mono | California | 6051 | 3089 | 6 |
2363041 | 2363041 | 2022-04-01 | Mono | California | 6051 | 3089 | 6 |
2359787 | 2359787 | 2022-03-31 | Mono | California | 6051 | 3089 | 6 |
2281722 | 2281722 | 2022-03-07 | Mono | California | 6051 | 3080 | 6 |
2278469 | 2278469 | 2022-03-06 | Mono | California | 6051 | 3080 | 6 |
2275216 | 2275216 | 2022-03-05 | Mono | California | 6051 | 3080 | 6 |
2271963 | 2271963 | 2022-03-04 | Mono | California | 6051 | 3080 | 6 |
2265458 | 2265458 | 2022-03-02 | Mono | California | 6051 | 3078 | 6 |
2242700 | 2242700 | 2022-02-23 | Modoc | California | 6049 | 954 | 6 |
2239449 | 2239449 | 2022-02-22 | Modoc | California | 6049 | 952 | 6 |
2236198 | 2236198 | 2022-02-21 | Modoc | California | 6049 | 948 | 6 |
2232947 | 2232947 | 2022-02-20 | Modoc | California | 6049 | 948 | 6 |
2229696 | 2229696 | 2022-02-19 | Modoc | California | 6049 | 948 | 6 |
2226445 | 2226445 | 2022-02-18 | Modoc | California | 6049 | 948 | 6 |
2223194 | 2223194 | 2022-02-17 | Modoc | California | 6049 | 945 | 6 |
2219943 | 2219943 | 2022-02-16 | Modoc | California | 6049 | 946 | 6 |
2216692 | 2216692 | 2022-02-15 | Modoc | California | 6049 | 943 | 6 |
2213441 | 2213441 | 2022-02-14 | Modoc | California | 6049 | 940 | 6 |
2210189 | 2210189 | 2022-02-13 | Modoc | California | 6049 | 933 | 6 |
2206936 | 2206936 | 2022-02-12 | Modoc | California | 6049 | 933 | 6 |
2203683 | 2203683 | 2022-02-11 | Modoc | California | 6049 | 933 | 6 |
2200430 | 2200430 | 2022-02-10 | Modoc | California | 6049 | 927 | 6 |
2197176 | 2197176 | 2022-02-09 | Modoc | California | 6049 | 920 | 6 |
2193921 | 2193921 | 2022-02-08 | Modoc | California | 6049 | 915 | 6 |
2190668 | 2190668 | 2022-02-07 | Modoc | California | 6049 | 911 | 6 |
2187415 | 2187415 | 2022-02-06 | Modoc | California | 6049 | 900 | 6 |
2184162 | 2184162 | 2022-02-05 | Modoc | California | 6049 | 900 | 6 |
2180910 | 2180910 | 2022-02-04 | Modoc | California | 6049 | 900 | 6 |
2177659 | 2177659 | 2022-02-03 | Modoc | California | 6049 | 898 | 6 |
2174406 | 2174406 | 2022-02-02 | Modoc | California | 6049 | 894 | 6 |
1829828 | 1829828 | 2021-10-19 | Plumas | California | 6063 | 1612 | 6 |
1826579 | 1826579 | 2021-10-18 | Plumas | California | 6063 | 1604 | 6 |
1823330 | 1823330 | 2021-10-17 | Plumas | California | 6063 | 1575 | 6 |
1820081 | 1820081 | 2021-10-16 | Plumas | California | 6063 | 1575 | 6 |
1816832 | 1816832 | 2021-10-15 | Plumas | California | 6063 | 1575 | 6 |
1813584 | 1813584 | 2021-10-14 | Plumas | California | 6063 | 1547 | 6 |
1810335 | 1810335 | 2021-10-13 | Plumas | California | 6063 | 1518 | 6 |
1807086 | 1807086 | 2021-10-12 | Plumas | California | 6063 | 1499 | 6 |
1803835 | 1803835 | 2021-10-11 | Plumas | California | 6063 | 1498 | 6 |
1800586 | 1800586 | 2021-10-10 | Plumas | California | 6063 | 1448 | 6 |
1797337 | 1797337 | 2021-10-09 | Plumas | California | 6063 | 1448 | 6 |
1794088 | 1794088 | 2021-10-08 | Plumas | California | 6063 | 1448 | 6 |
1790840 | 1790840 | 2021-10-07 | Plumas | California | 6063 | 1413 | 6 |
1787591 | 1787591 | 2021-10-06 | Plumas | California | 6063 | 1386 | 6 |
1784342 | 1784342 | 2021-10-05 | Plumas | California | 6063 | 1358 | 6 |
1781093 | 1781093 | 2021-10-04 | Plumas | California | 6063 | 1357 | 6 |
1777843 | 1777843 | 2021-10-03 | Plumas | California | 6063 | 1327 | 6 |
1774593 | 1774593 | 2021-10-02 | Plumas | California | 6063 | 1327 | 6 |
1771343 | 1771343 | 2021-10-01 | Plumas | California | 6063 | 1327 | 6 |
1768094 | 1768094 | 2021-09-30 | Plumas | California | 6063 | 1318 | 6 |
1764845 | 1764845 | 2021-09-29 | Plumas | California | 6063 | 1305 | 6 |
1761596 | 1761596 | 2021-09-28 | Plumas | California | 6063 | 1298 | 6 |
1758348 | 1758348 | 2021-09-27 | Plumas | California | 6063 | 1297 | 6 |
1755100 | 1755100 | 2021-09-26 | Plumas | California | 6063 | 1267 | 6 |
1751852 | 1751852 | 2021-09-25 | Plumas | California | 6063 | 1267 | 6 |
1748603 | 1748603 | 2021-09-24 | Plumas | California | 6063 | 1267 | 6 |
1745353 | 1745353 | 2021-09-23 | Plumas | California | 6063 | 1259 | 6 |
1742104 | 1742104 | 2021-09-22 | Plumas | California | 6063 | 1254 | 6 |
1738855 | 1738855 | 2021-09-21 | Plumas | California | 6063 | 1240 | 6 |
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);