daily_reports (view)

⚠️ This table has been renamed. Use johns_hopkins_csse_daily_reports instead.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

58 rows where "last_update" is on date 2020-05-26 and province_or_state = "California" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

province_or_state 1

  • California · 58 ✖

country_or_region 1

day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2020-05-25 US California Alameda 6001 2905 92 0 2810 37.64629437 -121.8929271 2020-05-26 02:32:35 Alameda, California, US
2020-05-25 US California Alpine 6003 2 0 0 2 38.59678594 -119.8223594 2020-05-26 02:32:35 Alpine, California, US
2020-05-25 US California Amador 6005 10 0 0 10 38.44583082 -120.65696 2020-05-26 02:32:35 Amador, California, US
2020-05-25 US California Butte 6007 40 0 0 38 39.66727762 -121.6005252 2020-05-26 02:32:35 Butte, California, US
2020-05-25 US California Calaveras 6009 13 0 0 13 38.20537103 -120.552913 2020-05-26 02:32:35 Calaveras, California, US
2020-05-25 US California Colusa 6011 4 0 0 4 39.17881957 -122.2331726 2020-05-26 02:32:35 Colusa, California, US
2020-05-25 US California Contra Costa 6013 1349 37 0 1311 37.91923498 -121.9289527 2020-05-26 02:32:35 Contra Costa, California, US
2020-05-25 US California Del Norte 6015 20 0 0 20 41.74228275 -123.8974063 2020-05-26 02:32:35 Del Norte, California, US
2020-05-25 US California El Dorado 6017 79 0 0 78 38.77965956 -120.5233166 2020-05-26 02:32:35 El Dorado, California, US
2020-05-25 US California Fresno 6019 1539 22 0 1509 36.75733899 -119.6466953 2020-05-26 02:32:35 Fresno, California, US
2020-05-25 US California Glenn 6021 12 0 0 12 39.59875897 -122.3938452 2020-05-26 02:32:35 Glenn, California, US
2020-05-25 US California Humboldt 6023 80 2 0 78 40.69923009 -123.876044 2020-05-26 02:32:35 Humboldt, California, US
2020-05-25 US California Imperial 6025 1373 14 0 1359 33.0393082 -115.3669042 2020-05-26 02:32:35 Imperial, California, US
2020-05-25 US California Inyo 6027 20 1 0 19 36.51112084 -117.41119779999998 2020-05-26 02:32:35 Inyo, California, US
2020-05-25 US California Kern 6029 1871 29 0 1842 35.34329425 -118.7277796 2020-05-26 02:32:35 Kern, California, US
2020-05-25 US California Kings 6031 448 2 0 447 36.07409056 -119.8159973 2020-05-26 02:32:35 Kings, California, US
2020-05-25 US California Lake 6033 13 0 0 13 39.10124298 -122.7536244 2020-05-26 02:32:35 Lake, California, US
2020-05-25 US California Lassen 6035 9 0 0 4 40.67311306 -120.59350990000002 2020-05-26 02:32:35 Lassen, California, US
2020-05-25 US California Los Angeles 6037 46023 2116 0 43907 34.30828379 -118.2282411 2020-05-26 02:32:35 Los Angeles, California, US
2020-05-25 US California Madera 6039 84 2 0 82 37.21513971 -119.76655890000002 2020-05-26 02:32:35 Madera, California, US
2020-05-25 US California Marin 6041 417 14 0 403 38.07122463 -122.7210631 2020-05-26 02:32:35 Marin, California, US
2020-05-25 US California Mariposa 6043 15 1 0 14 37.57978556 -119.9073334 2020-05-26 02:32:35 Mariposa, California, US
2020-05-25 US California Mendocino 6045 19 0 0 19 39.4381191 -123.3911313 2020-05-26 02:32:35 Mendocino, California, US
2020-05-25 US California Merced 6047 262 6 0 256 37.18922369 -120.7209035 2020-05-26 02:32:35 Merced, California, US
2020-05-25 US California Mono 6051 34 1 0 33 37.93899289 -118.8872409 2020-05-26 02:32:35 Mono, California, US
2020-05-25 US California Monterey 6053 419 8 0 410 36.21862405 -121.2413397 2020-05-26 02:32:35 Monterey, California, US
2020-05-25 US California Napa 6055 107 3 0 104 38.50735751 -122.332839 2020-05-26 02:32:35 Napa, California, US
2020-05-25 US California Nevada 6057 42 1 0 41 39.30394768 -120.7627281 2020-05-26 02:32:35 Nevada, California, US
2020-05-25 US California Orange 6059 6138 133 0 6005 33.70147516 -117.76459979999998 2020-05-26 02:32:35 Orange, California, US
2020-05-25 US California Placer 6061 186 9 0 177 39.06167234 -120.7240569 2020-05-26 02:32:35 Placer, California, US
2020-05-25 US California Plumas 6063 4 0 0 4 40.00355989 -120.8395236 2020-05-26 02:32:35 Plumas, California, US
2020-05-25 US California Riverside 6065 6920 284 0 6625 33.74314981 -115.9933578 2020-05-26 02:32:35 Riverside, California, US
2020-05-25 US California Sacramento 6067 1290 50 0 1240 38.45106826 -121.3425374 2020-05-26 02:32:35 Sacramento, California, US
2020-05-25 US California San Benito 6069 68 2 0 66 36.60308176 -121.069975 2020-05-26 02:32:35 San Benito, California, US
2020-05-25 US California San Bernardino 6071 4397 175 0 4221 34.84060306 -116.1774685 2020-05-26 02:32:35 San Bernardino, California, US
2020-05-25 US California San Diego 6073 6797 249 0 6548 33.03484597 -116.7365326 2020-05-26 02:32:35 San Diego, California, US
2020-05-25 US California San Francisco 6075 2358 40 0 2318 37.75215114 -122.4385672 2020-05-26 02:32:35 San Francisco, California, US
2020-05-25 US California San Joaquin 6077 763 33 0 731 37.93433732 -121.2730061 2020-05-26 02:32:35 San Joaquin, California, US
2020-05-25 US California San Luis Obispo 6079 264 1 0 261 35.38822029 -120.4039028 2020-05-26 02:32:35 San Luis Obispo, California, US
2020-05-25 US California San Mateo 6081 1940 71 0 1869 37.4228808 -122.32755459999998 2020-05-26 02:32:35 San Mateo, California, US
2020-05-25 US California Santa Barbara 6083 1599 9 0 1585 34.65329488 -120.0188492 2020-05-26 02:32:35 Santa Barbara, California, US
2020-05-25 US California Santa Clara 6085 2657 139 0 2509 37.23104908 -121.6970462 2020-05-26 02:32:35 Santa Clara, California, US
2020-05-25 US California Santa Cruz 6087 191 2 0 189 37.05580291 -122.0066524 2020-05-26 02:32:35 Santa Cruz, California, US
2020-05-25 US California Shasta 6089 36 4 0 32 40.76391419 -122.0396884 2020-05-26 02:32:35 Shasta, California, US
2020-05-25 US California Sierra 6091 1 0 0 1 39.57713498 -120.52007009999998 2020-05-26 02:32:35 Sierra, California, US
2020-05-25 US California Siskiyou 6093 6 0 0 6 41.59198861 -122.5407434 2020-05-26 02:32:35 Siskiyou, California, US
2020-05-25 US California Solano 6095 415 5 0 410 38.26827353 -121.9357113 2020-05-26 02:32:35 Solano, California, US
2020-05-25 US California Sonoma 6097 496 4 0 492 38.52746429 -122.8862506 2020-05-26 02:32:35 Sonoma, California, US
2020-05-25 US California Stanislaus 6099 656 27 0 629 37.55862499 -120.9970722 2020-05-26 02:32:35 Stanislaus, California, US
2020-05-25 US California Sutter 6101 38 2 0 36 39.03417539 -121.6945899 2020-05-26 02:32:35 Sutter, California, US
2020-05-25 US California Tehama 6103 3 1 0 2 40.12570935 -122.2370171 2020-05-26 02:32:35 Tehama, California, US
2020-05-25 US California Trinity 6105 3 0 0 2 40.64917670000001 -123.114713 2020-05-26 02:32:35 Trinity, California, US
2020-05-25 US California Tulare 6107 1757 76 0 1675 36.22026558 -118.8020203 2020-05-26 02:32:35 Tulare, California, US
2020-05-25 US California Tuolumne 6109 2 0 0 3 38.02644018 -119.9525093 2020-05-26 02:32:35 Tuolumne, California, US
2020-05-25 US California Unassigned 90006 0 0 0 0 41.74228275 0.0 2020-05-26 02:32:35 Unassigned, California, US
2020-05-25 US California Ventura 6111 1028 27 0 996 34.44465746 -119.0910613 2020-05-26 02:32:35 Ventura, California, US
2020-05-25 US California Yolo 6113 197 22 0 175 38.68278902 -121.9018288 2020-05-26 02:32:35 Yolo, California, US
2020-05-25 US California Yuba 6115 24 1 0 23 39.26255932 -121.3535644 2020-05-26 02:32:35 Yuba, California, US

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;