ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
57 rows where "date" is on date 2020-07-08 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
312550 | 312550 | 2020-07-08 | Alameda | California | 6001 | 7266 | 142 |
312551 | 312551 | 2020-07-08 | Alpine | California | 6003 | 1 | 0 |
312552 | 312552 | 2020-07-08 | Amador | California | 6005 | 33 | 0 |
312553 | 312553 | 2020-07-08 | Butte | California | 6007 | 295 | 4 |
312554 | 312554 | 2020-07-08 | Calaveras | California | 6009 | 61 | 0 |
312555 | 312555 | 2020-07-08 | Colusa | California | 6011 | 98 | 0 |
312556 | 312556 | 2020-07-08 | Contra Costa | California | 6013 | 4241 | 86 |
312557 | 312557 | 2020-07-08 | Del Norte | California | 6015 | 58 | 0 |
312558 | 312558 | 2020-07-08 | El Dorado | California | 6017 | 280 | 0 |
312559 | 312559 | 2020-07-08 | Fresno | California | 6019 | 7281 | 84 |
312560 | 312560 | 2020-07-08 | Glenn | California | 6021 | 145 | 0 |
312561 | 312561 | 2020-07-08 | Humboldt | California | 6023 | 157 | 4 |
312562 | 312562 | 2020-07-08 | Imperial | California | 6025 | 7464 | 124 |
312563 | 312563 | 2020-07-08 | Inyo | California | 6027 | 32 | 1 |
312564 | 312564 | 2020-07-08 | Kern | California | 6029 | 5769 | 87 |
312565 | 312565 | 2020-07-08 | Kings | California | 6031 | 2823 | 38 |
312566 | 312566 | 2020-07-08 | Lake | California | 6033 | 100 | 1 |
312567 | 312567 | 2020-07-08 | Lassen | California | 6035 | 267 | 0 |
312568 | 312568 | 2020-07-08 | Los Angeles | California | 6037 | 123004 | 3642 |
312569 | 312569 | 2020-07-08 | Madera | California | 6039 | 857 | 8 |
312570 | 312570 | 2020-07-08 | Marin | California | 6041 | 2891 | 23 |
312571 | 312571 | 2020-07-08 | Mariposa | California | 6043 | 31 | 1 |
312572 | 312572 | 2020-07-08 | Mendocino | California | 6045 | 107 | 0 |
312573 | 312573 | 2020-07-08 | Merced | California | 6047 | 1702 | 12 |
312574 | 312574 | 2020-07-08 | Mono | California | 6051 | 49 | 1 |
312575 | 312575 | 2020-07-08 | Monterey | California | 6053 | 2270 | 17 |
312576 | 312576 | 2020-07-08 | Napa | California | 6055 | 460 | 4 |
312577 | 312577 | 2020-07-08 | Nevada | California | 6057 | 155 | 1 |
312578 | 312578 | 2020-07-08 | Orange | California | 6059 | 21741 | 369 |
312579 | 312579 | 2020-07-08 | Placer | California | 6061 | 970 | 11 |
312580 | 312580 | 2020-07-08 | Plumas | California | 6063 | 12 | 0 |
312581 | 312581 | 2020-07-08 | Riverside | California | 6065 | 23279 | 515 |
312582 | 312582 | 2020-07-08 | Sacramento | California | 6067 | 4775 | 78 |
312583 | 312583 | 2020-07-08 | San Benito | California | 6069 | 304 | 2 |
312584 | 312584 | 2020-07-08 | San Bernardino | California | 6071 | 16586 | 293 |
312585 | 312585 | 2020-07-08 | San Diego | California | 6073 | 17905 | 406 |
312586 | 312586 | 2020-07-08 | San Francisco | California | 6075 | 4074 | 50 |
312587 | 312587 | 2020-07-08 | San Joaquin | California | 6077 | 5817 | 61 |
312588 | 312588 | 2020-07-08 | San Luis Obispo | California | 6079 | 845 | 3 |
312589 | 312589 | 2020-07-08 | San Mateo | California | 6081 | 3743 | 111 |
312590 | 312590 | 2020-07-08 | Santa Barbara | California | 6083 | 3866 | 30 |
312591 | 312591 | 2020-07-08 | Santa Clara | California | 6085 | 5552 | 166 |
312592 | 312592 | 2020-07-08 | Santa Cruz | California | 6087 | 503 | 3 |
312593 | 312593 | 2020-07-08 | Shasta | California | 6089 | 171 | 5 |
312594 | 312594 | 2020-07-08 | Sierra | California | 6091 | 1 | 0 |
312595 | 312595 | 2020-07-08 | Siskiyou | California | 6093 | 33 | 0 |
312596 | 312596 | 2020-07-08 | Solano | California | 6095 | 1927 | 27 |
312597 | 312597 | 2020-07-08 | Sonoma | California | 6097 | 1519 | 14 |
312598 | 312598 | 2020-07-08 | Stanislaus | California | 6099 | 4101 | 50 |
312599 | 312599 | 2020-07-08 | Sutter | California | 6101 | 323 | 4 |
312600 | 312600 | 2020-07-08 | Tehama | California | 6103 | 95 | 1 |
312601 | 312601 | 2020-07-08 | Trinity | California | 6105 | 3 | 0 |
312602 | 312602 | 2020-07-08 | Tulare | California | 6107 | 5298 | 148 |
312603 | 312603 | 2020-07-08 | Tuolumne | California | 6109 | 58 | 0 |
312604 | 312604 | 2020-07-08 | Ventura | California | 6111 | 3992 | 50 |
312605 | 312605 | 2020-07-08 | Yolo | California | 6113 | 760 | 28 |
312606 | 312606 | 2020-07-08 | Yuba | California | 6115 | 154 | 3 |
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);