ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
61 rows where deaths = 134 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2441155 | 2441155 | 2022-04-25 | Lake | California | 6033 | 11626 | 134 |
2437899 | 2437899 | 2022-04-24 | Lake | California | 6033 | 11626 | 134 |
2434643 | 2434643 | 2022-04-23 | Lake | California | 6033 | 11626 | 134 |
2431387 | 2431387 | 2022-04-22 | Lake | California | 6033 | 11626 | 134 |
2428131 | 2428131 | 2022-04-21 | Lake | California | 6033 | 11614 | 134 |
2424875 | 2424875 | 2022-04-20 | Lake | California | 6033 | 11614 | 134 |
2421619 | 2421619 | 2022-04-19 | Lake | California | 6033 | 11614 | 134 |
2418363 | 2418363 | 2022-04-18 | Lake | California | 6033 | 11605 | 134 |
2415107 | 2415107 | 2022-04-17 | Lake | California | 6033 | 11605 | 134 |
2411851 | 2411851 | 2022-04-16 | Lake | California | 6033 | 11605 | 134 |
2408595 | 2408595 | 2022-04-15 | Lake | California | 6033 | 11605 | 134 |
2405339 | 2405339 | 2022-04-14 | Lake | California | 6033 | 11598 | 134 |
2402084 | 2402084 | 2022-04-13 | Lake | California | 6033 | 11588 | 134 |
2398829 | 2398829 | 2022-04-12 | Lake | California | 6033 | 11588 | 134 |
2395574 | 2395574 | 2022-04-11 | Lake | California | 6033 | 11588 | 134 |
2392318 | 2392318 | 2022-04-10 | Lake | California | 6033 | 11588 | 134 |
2389062 | 2389062 | 2022-04-09 | Lake | California | 6033 | 11588 | 134 |
2385807 | 2385807 | 2022-04-08 | Lake | California | 6033 | 11588 | 134 |
2278471 | 2278471 | 2022-03-06 | Napa | California | 6055 | 26366 | 134 |
2275218 | 2275218 | 2022-03-05 | Napa | California | 6055 | 26366 | 134 |
2271965 | 2271965 | 2022-03-04 | Napa | California | 6055 | 26366 | 134 |
2268713 | 2268713 | 2022-03-03 | Napa | California | 6055 | 26343 | 134 |
2265460 | 2265460 | 2022-03-02 | Napa | California | 6055 | 26295 | 134 |
2193908 | 2193908 | 2022-02-08 | Humboldt | California | 6023 | 18441 | 134 |
2015097 | 2015097 | 2021-12-15 | Tehama | California | 6103 | 10392 | 134 |
2011846 | 2011846 | 2021-12-14 | Tehama | California | 6103 | 10387 | 134 |
2008595 | 2008595 | 2021-12-13 | Tehama | California | 6103 | 10383 | 134 |
2005344 | 2005344 | 2021-12-12 | Tehama | California | 6103 | 10363 | 134 |
2002093 | 2002093 | 2021-12-11 | Tehama | California | 6103 | 10363 | 134 |
1998843 | 1998843 | 2021-12-10 | Tehama | California | 6103 | 10363 | 134 |
1911085 | 1911085 | 2021-11-13 | Tuolumne | California | 6109 | 7564 | 134 |
1907836 | 1907836 | 2021-11-12 | Tuolumne | California | 6109 | 7564 | 134 |
1904587 | 1904587 | 2021-11-11 | Tuolumne | California | 6109 | 7564 | 134 |
1901337 | 1901337 | 2021-11-10 | Tuolumne | California | 6109 | 7564 | 134 |
1898087 | 1898087 | 2021-11-09 | Tuolumne | California | 6109 | 7539 | 134 |
1654413 | 1654413 | 2021-08-26 | Sutter | California | 6101 | 11673 | 134 |
1651166 | 1651166 | 2021-08-25 | Sutter | California | 6101 | 11519 | 134 |
1008301 | 1008301 | 2021-02-08 | Solano | California | 6095 | 28999 | 134 |
1005055 | 1005055 | 2021-02-07 | Solano | California | 6095 | 28691 | 134 |
1001809 | 1001809 | 2021-02-06 | Solano | California | 6095 | 28691 | 134 |
998563 | 998563 | 2021-02-05 | Solano | California | 6095 | 28691 | 134 |
995317 | 995317 | 2021-02-04 | Solano | California | 6095 | 28516 | 134 |
962817 | 962817 | 2021-01-25 | Butte | California | 6007 | 9820 | 134 |
959572 | 959572 | 2021-01-24 | Butte | California | 6007 | 9757 | 134 |
956326 | 956326 | 2021-01-23 | Butte | California | 6007 | 9711 | 134 |
829775 | 829775 | 2020-12-15 | Marin | California | 6041 | 8616 | 134 |
826529 | 826529 | 2020-12-14 | Marin | California | 6041 | 8538 | 134 |
800571 | 800571 | 2020-12-06 | Monterey | California | 6053 | 17077 | 134 |
661082 | 661082 | 2020-10-24 | Sonoma | California | 6097 | 9245 | 134 |
657838 | 657838 | 2020-10-23 | Sonoma | California | 6097 | 9163 | 134 |
654593 | 654593 | 2020-10-22 | Sonoma | California | 6097 | 9099 | 134 |
651348 | 651348 | 2020-10-21 | Sonoma | California | 6097 | 9073 | 134 |
648104 | 648104 | 2020-10-20 | Sonoma | California | 6097 | 9016 | 134 |
550818 | 550818 | 2020-09-20 | Merced | California | 6047 | 8750 | 134 |
547579 | 547579 | 2020-09-19 | Merced | California | 6047 | 8750 | 134 |
544341 | 544341 | 2020-09-18 | Merced | California | 6047 | 8750 | 134 |
405431 | 405431 | 2020-08-06 | Contra Costa | California | 6013 | 8532 | 134 |
325270 | 325270 | 2020-07-12 | Imperial | California | 6025 | 7827 | 134 |
322089 | 322089 | 2020-07-11 | Imperial | California | 6025 | 7827 | 134 |
139425 | 139425 | 2020-05-13 | Santa Clara | California | 6085 | 2364 | 134 |
136434 | 136434 | 2020-05-12 | Santa Clara | California | 6085 | 2364 | 134 |
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);