ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33 rows where deaths = 194 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases
county 11
- Butte 16
- San Diego 3
- San Francisco 3
- San Luis Obispo 3
- Marin 2
- Contra Costa 1
- Kings 1
- Merced 1
- Riverside 1
- Sacramento 1
- Shasta 1
state 1
- California · 33 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1440042 | 1440042 | 2021-06-21 | Butte | California | 6007 | 12668 | 194 |
1436795 | 1436795 | 2021-06-20 | Butte | California | 6007 | 12659 | 194 |
1433548 | 1433548 | 2021-06-19 | Butte | California | 6007 | 12653 | 194 |
1430302 | 1430302 | 2021-06-18 | Butte | California | 6007 | 12644 | 194 |
1427057 | 1427057 | 2021-06-17 | Butte | California | 6007 | 12635 | 194 |
1423812 | 1423812 | 2021-06-16 | Butte | California | 6007 | 12620 | 194 |
1420564 | 1420564 | 2021-06-15 | Butte | California | 6007 | 12613 | 194 |
1417319 | 1417319 | 2021-06-14 | Butte | California | 6007 | 12586 | 194 |
1414073 | 1414073 | 2021-06-13 | Butte | California | 6007 | 12576 | 194 |
1410828 | 1410828 | 2021-06-12 | Butte | California | 6007 | 12576 | 194 |
1407583 | 1407583 | 2021-06-11 | Butte | California | 6007 | 12565 | 194 |
1404337 | 1404337 | 2021-06-10 | Butte | California | 6007 | 12555 | 194 |
1401092 | 1401092 | 2021-06-09 | Butte | California | 6007 | 12540 | 194 |
1397847 | 1397847 | 2021-06-08 | Butte | California | 6007 | 12533 | 194 |
1394600 | 1394600 | 2021-06-07 | Butte | California | 6007 | 12527 | 194 |
1391355 | 1391355 | 2021-06-06 | Butte | California | 6007 | 12514 | 194 |
1128393 | 1128393 | 2021-03-17 | Shasta | California | 6089 | 11084 | 194 |
1050465 | 1050465 | 2021-02-21 | Marin | California | 6041 | 12945 | 194 |
1047218 | 1047218 | 2021-02-20 | Marin | California | 6041 | 12919 | 194 |
1005023 | 1005023 | 2021-02-07 | Kings | California | 6031 | 21224 | 194 |
1005047 | 1005047 | 2021-02-07 | San Luis Obispo | California | 6079 | 18467 | 194 |
1001801 | 1001801 | 2021-02-06 | San Luis Obispo | California | 6079 | 18467 | 194 |
998555 | 998555 | 2021-02-05 | San Luis Obispo | California | 6079 | 18467 | 194 |
894700 | 894700 | 2021-01-04 | San Francisco | California | 6075 | 24591 | 194 |
891453 | 891453 | 2021-01-03 | San Francisco | California | 6075 | 24417 | 194 |
888206 | 888206 | 2021-01-02 | San Francisco | California | 6075 | 24148 | 194 |
803813 | 803813 | 2020-12-07 | Merced | California | 6047 | 13637 | 194 |
534615 | 534615 | 2020-09-15 | Contra Costa | California | 6013 | 15489 | 194 |
428004 | 428004 | 2020-08-13 | Sacramento | California | 6067 | 13215 | 194 |
133438 | 133438 | 2020-05-11 | San Diego | California | 6073 | 5128 | 194 |
130448 | 130448 | 2020-05-10 | San Diego | California | 6073 | 4989 | 194 |
127458 | 127458 | 2020-05-09 | San Diego | California | 6073 | 4839 | 194 |
121489 | 121489 | 2020-05-07 | Riverside | California | 6065 | 4756 | 194 |
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);