ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
38 rows where deaths = 124 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- California · 38 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499784 | 2499784 | 2022-05-13 | Mendocino | California | 6045 | 16568 | 124 |
2496526 | 2496526 | 2022-05-12 | Mendocino | California | 6045 | 16466 | 124 |
2493268 | 2493268 | 2022-05-11 | Mendocino | California | 6045 | 16466 | 124 |
2490010 | 2490010 | 2022-05-10 | Mendocino | California | 6045 | 16466 | 124 |
2486753 | 2486753 | 2022-05-09 | Mendocino | California | 6045 | 16416 | 124 |
2483495 | 2483495 | 2022-05-08 | Mendocino | California | 6045 | 16416 | 124 |
2480237 | 2480237 | 2022-05-07 | Mendocino | California | 6045 | 16416 | 124 |
2476979 | 2476979 | 2022-05-06 | Mendocino | California | 6045 | 16416 | 124 |
2210192 | 2210192 | 2022-02-13 | Napa | California | 6055 | 25470 | 124 |
2206939 | 2206939 | 2022-02-12 | Napa | California | 6055 | 25470 | 124 |
2203686 | 2203686 | 2022-02-11 | Napa | California | 6055 | 25470 | 124 |
2187407 | 2187407 | 2022-02-06 | Lake | California | 6033 | 10236 | 124 |
2184154 | 2184154 | 2022-02-05 | Lake | California | 6033 | 10236 | 124 |
2180902 | 2180902 | 2022-02-04 | Lake | California | 6033 | 10236 | 124 |
2099574 | 2099574 | 2022-01-10 | Humboldt | California | 6023 | 12545 | 124 |
2096323 | 2096323 | 2022-01-09 | Humboldt | California | 6023 | 12112 | 124 |
2093071 | 2093071 | 2022-01-08 | Humboldt | California | 6023 | 12112 | 124 |
2089819 | 2089819 | 2022-01-07 | Humboldt | California | 6023 | 12112 | 124 |
2086568 | 2086568 | 2022-01-06 | Humboldt | California | 6023 | 11901 | 124 |
2083316 | 2083316 | 2022-01-05 | Humboldt | California | 6023 | 11681 | 124 |
1878589 | 1878589 | 2021-11-03 | Tuolumne | California | 6109 | 7428 | 124 |
1875340 | 1875340 | 2021-11-02 | Tuolumne | California | 6109 | 7398 | 124 |
1872091 | 1872091 | 2021-11-01 | Tuolumne | California | 6109 | 7367 | 124 |
787591 | 787591 | 2020-12-02 | Monterey | California | 6053 | 15835 | 124 |
644831 | 644831 | 2020-10-19 | Marin | California | 6041 | 7030 | 124 |
641583 | 641583 | 2020-10-18 | Marin | California | 6041 | 7019 | 124 |
638336 | 638336 | 2020-10-17 | Marin | California | 6041 | 6982 | 124 |
635091 | 635091 | 2020-10-16 | Marin | California | 6041 | 6982 | 124 |
631845 | 631845 | 2020-10-15 | Marin | California | 6041 | 6966 | 124 |
628601 | 628601 | 2020-10-14 | Marin | California | 6041 | 6940 | 124 |
625358 | 625358 | 2020-10-13 | Marin | California | 6041 | 6934 | 124 |
622115 | 622115 | 2020-10-12 | Marin | California | 6041 | 6920 | 124 |
618872 | 618872 | 2020-10-11 | Marin | California | 6041 | 6902 | 124 |
615630 | 615630 | 2020-10-10 | Marin | California | 6041 | 6877 | 124 |
612389 | 612389 | 2020-10-09 | Marin | California | 6041 | 6874 | 124 |
609147 | 609147 | 2020-10-08 | Marin | California | 6041 | 6857 | 124 |
312562 | 312562 | 2020-07-08 | Imperial | California | 6025 | 7464 | 124 |
284167 | 284167 | 2020-06-29 | Tulare | California | 6107 | 3872 | 124 |
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);