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-05-23 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
169543 | 169543 | 2020-05-23 | Alameda | California | 6001 | 2788 | 92 |
169544 | 169544 | 2020-05-23 | Alpine | California | 6003 | 2 | 0 |
169545 | 169545 | 2020-05-23 | Amador | California | 6005 | 9 | 0 |
169546 | 169546 | 2020-05-23 | Butte | California | 6007 | 34 | 0 |
169547 | 169547 | 2020-05-23 | Calaveras | California | 6009 | 13 | 0 |
169548 | 169548 | 2020-05-23 | Colusa | California | 6011 | 5 | 0 |
169549 | 169549 | 2020-05-23 | Contra Costa | California | 6013 | 1296 | 36 |
169550 | 169550 | 2020-05-23 | Del Norte | California | 6015 | 23 | 0 |
169551 | 169551 | 2020-05-23 | El Dorado | California | 6017 | 74 | 0 |
169552 | 169552 | 2020-05-23 | Fresno | California | 6019 | 1448 | 22 |
169553 | 169553 | 2020-05-23 | Glenn | California | 6021 | 12 | 0 |
169554 | 169554 | 2020-05-23 | Humboldt | California | 6023 | 93 | 2 |
169555 | 169555 | 2020-05-23 | Imperial | California | 6025 | 1214 | 22 |
169556 | 169556 | 2020-05-23 | Inyo | California | 6027 | 20 | 1 |
169557 | 169557 | 2020-05-23 | Kern | California | 6029 | 1767 | 30 |
169558 | 169558 | 2020-05-23 | Kings | California | 6031 | 506 | 2 |
169559 | 169559 | 2020-05-23 | Lake | California | 6033 | 12 | 0 |
169560 | 169560 | 2020-05-23 | Lassen | California | 6035 | 2 | 0 |
169561 | 169561 | 2020-05-23 | Los Angeles | California | 6037 | 44055 | 2090 |
169562 | 169562 | 2020-05-23 | Madera | California | 6039 | 84 | 2 |
169563 | 169563 | 2020-05-23 | Marin | California | 6041 | 388 | 14 |
169564 | 169564 | 2020-05-23 | Mariposa | California | 6043 | 15 | 1 |
169565 | 169565 | 2020-05-23 | Mendocino | California | 6045 | 21 | 0 |
169566 | 169566 | 2020-05-23 | Merced | California | 6047 | 251 | 6 |
169567 | 169567 | 2020-05-23 | Mono | California | 6051 | 34 | 1 |
169568 | 169568 | 2020-05-23 | Monterey | California | 6053 | 395 | 8 |
169569 | 169569 | 2020-05-23 | Napa | California | 6055 | 102 | 3 |
169570 | 169570 | 2020-05-23 | Nevada | California | 6057 | 41 | 1 |
169571 | 169571 | 2020-05-23 | Orange | California | 6059 | 5157 | 130 |
169572 | 169572 | 2020-05-23 | Placer | California | 6061 | 185 | 9 |
169573 | 169573 | 2020-05-23 | Plumas | California | 6063 | 4 | 0 |
169574 | 169574 | 2020-05-23 | Riverside | California | 6065 | 6464 | 298 |
169575 | 169575 | 2020-05-23 | Sacramento | California | 6067 | 1288 | 57 |
169576 | 169576 | 2020-05-23 | San Benito | California | 6069 | 69 | 2 |
169577 | 169577 | 2020-05-23 | San Bernardino | California | 6071 | 4315 | 176 |
169578 | 169578 | 2020-05-23 | San Diego | California | 6073 | 6622 | 271 |
169579 | 169579 | 2020-05-23 | San Francisco | California | 6075 | 2353 | 40 |
169580 | 169580 | 2020-05-23 | San Joaquin | California | 6077 | 752 | 33 |
169581 | 169581 | 2020-05-23 | San Luis Obispo | California | 6079 | 259 | 1 |
169582 | 169582 | 2020-05-23 | San Mateo | California | 6081 | 1847 | 76 |
169583 | 169583 | 2020-05-23 | Santa Barbara | California | 6083 | 1554 | 12 |
169584 | 169584 | 2020-05-23 | Santa Clara | California | 6085 | 2571 | 140 |
169585 | 169585 | 2020-05-23 | Santa Cruz | California | 6087 | 192 | 3 |
169586 | 169586 | 2020-05-23 | Shasta | California | 6089 | 36 | 4 |
169587 | 169587 | 2020-05-23 | Sierra | California | 6091 | 1 | 0 |
169588 | 169588 | 2020-05-23 | Siskiyou | California | 6093 | 6 | 0 |
169589 | 169589 | 2020-05-23 | Solano | California | 6095 | 460 | 20 |
169590 | 169590 | 2020-05-23 | Sonoma | California | 6097 | 482 | 4 |
169591 | 169591 | 2020-05-23 | Stanislaus | California | 6099 | 629 | 28 |
169592 | 169592 | 2020-05-23 | Sutter | California | 6101 | 40 | 2 |
169593 | 169593 | 2020-05-23 | Tehama | California | 6103 | 3 | 1 |
169594 | 169594 | 2020-05-23 | Trinity | California | 6105 | 2 | 0 |
169595 | 169595 | 2020-05-23 | Tulare | California | 6107 | 1662 | 75 |
169596 | 169596 | 2020-05-23 | Tuolumne | California | 6109 | 3 | 0 |
169597 | 169597 | 2020-05-23 | Ventura | California | 6111 | 937 | 30 |
169598 | 169598 | 2020-05-23 | Yolo | California | 6113 | 190 | 22 |
169599 | 169599 | 2020-05-23 | Yuba | California | 6115 | 28 | 1 |
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);