johns_hopkins_csse_daily_reports

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

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

7,964 rows where province_or_state = "California" sorted by day descending

View and edit SQL

Suggested facets: recovered, day (date), last_update (date)

province_or_state

  • California · 7,964

country_or_region

  • US 7,964
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
391112 2020-08-08 US California Alameda 6001 13213 208 0 13005 37.64629437 -121.8929271 2020-08-09 04:34:54 Alameda, California, US
391140 2020-08-08 US California Alpine 6003 2 0 0 2 38.59678594 -119.8223594 2020-08-09 04:34:54 Alpine, California, US
391141 2020-08-08 US California Amador 6005 164 2 0 162 38.44583082 -120.65696 2020-08-09 04:34:54 Amador, California, US
391421 2020-08-08 US California Butte 6007 1095 8 0 1087 39.66727762 -121.6005252 2020-08-09 04:34:54 Butte, California, US
391430 2020-08-08 US California Calaveras 6009 147 1 0 146 38.20537103 -120.552913 2020-08-09 04:34:54 Calaveras, California, US
391714 2020-08-08 US California Colusa 6011 362 4 0 358 39.17881957 -122.2331726 2020-08-09 04:34:54 Colusa, California, US
391724 2020-08-08 US California Contra Costa 6013 9022 138 0 8884 37.91923498 -121.9289527 2020-08-09 04:34:54 Contra Costa, California, US
391857 2020-08-08 US California Del Norte 6015 99 0 0 99 41.74228275 -123.8974063 2020-08-09 04:34:54 Del Norte, California, US
391957 2020-08-08 US California El Dorado 6017 729 1 0 728 38.77965956 -120.5233166 2020-08-09 04:34:54 El Dorado, California, US
392091 2020-08-08 US California Fresno 6019 17031 171 0 16860 36.75733899 -119.6466953 2020-08-09 04:34:54 Fresno, California, US
392151 2020-08-08 US California Glenn 6021 360 3 0 357 39.59875897 -122.3938452 2020-08-09 04:34:54 Glenn, California, US
392422 2020-08-08 US California Humboldt 6023 282 4 0 278 40.69923009 -123.876044 2020-08-09 04:34:54 Humboldt, California, US
392441 2020-08-08 US California Imperial 6025 9693 244 0 9449 33.0393082 -115.3669042 2020-08-09 04:34:54 Imperial, California, US
392446 2020-08-08 US California Inyo 6027 64 3 0 61 36.51112084 -117.41119779999998 2020-08-09 04:34:54 Inyo, California, US
392599 2020-08-08 US California Kern 6029 22626 171 0 22455 35.34329425 -118.7277796 2020-08-09 04:34:54 Kern, California, US
392616 2020-08-08 US California Kings 6031 4453 56 0 4397 36.07409056 -119.8159973 2020-08-09 04:34:54 Kings, California, US
392665 2020-08-08 US California Lake 6033 220 2 0 218 39.10124298 -122.7536244 2020-08-09 04:34:54 Lake, California, US
392702 2020-08-08 US California Lassen 6035 638 0 0 638 40.67311306 -120.59350990000002 2020-08-09 04:34:54 Lassen, California, US
392822 2020-08-08 US California Los Angeles 6037 206778 4967 0 201811 34.30828379 -118.2282411 2020-08-09 04:34:54 Los Angeles, California, US
392860 2020-08-08 US California Madera 6039 2302 39 0 2263 37.21513971 -119.76655890000002 2020-08-09 04:34:54 Madera, California, US
392898 2020-08-08 US California Marin 6041 5287 79 0 5208 38.07122463 -122.7210631 2020-08-09 04:34:54 Marin, California, US
392917 2020-08-08 US California Mariposa 6043 60 2 0 58 37.57978556 -119.9073334 2020-08-09 04:34:54 Mariposa, California, US
393003 2020-08-08 US California Mendocino 6045 380 10 0 370 39.4381191 -123.3911313 2020-08-09 04:34:54 Mendocino, California, US
393007 2020-08-08 US California Merced 6047 5012 64 0 4948 37.18922369 -120.7209035 2020-08-09 04:34:54 Merced, California, US
393059 2020-08-08 US California Modoc 6049 5 0 0 5 41.58965602 -120.7244817 2020-08-09 04:34:54 Modoc, California, US
393064 2020-08-08 US California Mono 6051 153 1 0 152 37.93899289 -118.8872409 2020-08-09 04:34:54 Mono, California, US
393086 2020-08-08 US California Monterey 6053 5212 35 0 5177 36.21862405 -121.2413397 2020-08-09 04:34:54 Monterey, California, US
393153 2020-08-08 US California Napa 6055 1046 10 0 1036 38.50735751 -122.332839 2020-08-09 04:34:54 Napa, California, US
393171 2020-08-08 US California Nevada 6057 322 1 0 321 39.30394768 -120.7627281 2020-08-09 04:34:54 Nevada, California, US
393254 2020-08-08 US California Orange 6059 39076 720 0 38356 33.70147516 -117.76459979999998 2020-08-09 04:34:54 Orange, California, US
393406 2020-08-08 US California Placer 6061 2186 20 0 2166 39.06167234 -120.7240569 2020-08-09 04:34:54 Placer, California, US
393412 2020-08-08 US California Plumas 6063 34 0 0 34 40.00355989 -120.8395236 2020-08-09 04:34:54 Plumas, California, US
393558 2020-08-08 US California Riverside 6065 40452 799 0 39653 33.74314981 -115.9933578 2020-08-09 04:34:54 Riverside, California, US
393610 2020-08-08 US California Sacramento 6067 10795 161 0 10634 38.45106826 -121.3425374 2020-08-09 04:34:54 Sacramento, California, US
393626 2020-08-08 US California San Benito 6069 709 4 0 705 36.60308176 -121.069975 2020-08-09 04:34:54 San Benito, California, US
393627 2020-08-08 US California San Bernardino 6071 35452 502 0 34950 34.84060306 -116.1774685 2020-08-09 04:34:54 San Bernardino, California, US
393628 2020-08-08 US California San Diego 6073 31779 586 0 31193 33.03484597 -116.7365326 2020-08-09 04:34:54 San Diego, California, US
393629 2020-08-08 US California San Francisco 6075 7432 67 0 7365 37.75215114 -122.4385672 2020-08-09 04:34:54 San Francisco, California, US
393632 2020-08-08 US California San Joaquin 6077 12303 211 0 12092 37.93433732 -121.2730061 2020-08-09 04:34:54 San Joaquin, California, US
393639 2020-08-08 US California San Luis Obispo 6079 2093 15 0 2078 35.38822029 -120.4039028 2020-08-09 04:34:54 San Luis Obispo, California, US
393640 2020-08-08 US California San Mateo 6081 6110 120 0 5990 37.4228808 -122.32755459999998 2020-08-09 04:34:54 San Mateo, California, US
393652 2020-08-08 US California Santa Barbara 6083 6704 69 0 6635 34.65329488 -120.0188492 2020-08-09 04:34:54 Santa Barbara, California, US
393653 2020-08-08 US California Santa Clara 6085 11475 203 0 11272 37.23104908 -121.6970462 2020-08-09 04:34:54 Santa Clara, California, US
393655 2020-08-08 US California Santa Cruz 6087 1238 6 0 1232 37.05580291 -122.0066524 2020-08-09 04:34:54 Santa Cruz, California, US
393711 2020-08-08 US California Shasta 6089 418 10 0 408 40.76391419 -122.0396884 2020-08-09 04:34:54 Shasta, California, US
393738 2020-08-08 US California Sierra 6091 3 0 0 3 39.57713498 -120.52007009999998 2020-08-09 04:34:54 Sierra, California, US
393746 2020-08-08 US California Siskiyou 6093 93 0 0 93 41.59198861 -122.5407434 2020-08-09 04:34:54 Siskiyou, California, US
393759 2020-08-08 US California Solano 6095 4029 40 0 3989 38.26827353 -121.9357113 2020-08-09 04:34:54 Solano, California, US
393765 2020-08-08 US California Sonoma 6097 3431 47 0 3384 38.52746429 -122.8862506 2020-08-09 04:34:54 Sonoma, California, US
393805 2020-08-08 US California Stanislaus 6099 9566 161 0 9405 37.55862499 -120.9970722 2020-08-09 04:34:54 Stanislaus, California, US
393871 2020-08-08 US California Sutter 6101 921 7 0 914 39.03417539 -121.6945899 2020-08-09 04:34:54 Sutter, California, US
393902 2020-08-08 US California Tehama 6103 276 1 0 275 40.12570935 -122.2370171 2020-08-09 04:34:54 Tehama, California, US
393958 2020-08-08 US California Trinity 6105 5 0 0 5 40.64917670000001 -123.114713 2020-08-09 04:34:54 Trinity, California, US
393966 2020-08-08 US California Tulare 6107 10475 196 0 10279 36.22026558 -118.8020203 2020-08-09 04:34:54 Tulare, California, US
393969 2020-08-08 US California Tuolumne 6109 152 2 0 150 38.02644018 -119.9525093 2020-08-09 04:34:54 Tuolumne, California, US
393987 2020-08-08 US California Unassigned 90006 0 0 0 0 41.74228275 0.0 2020-08-09 04:34:54 Unassigned, California, US
394074 2020-08-08 US California Ventura 6111 8146 89 0 8057 34.44465746 -119.0910613 2020-08-09 04:34:54 Ventura, California, US
394313 2020-08-08 US California Yolo 6113 1690 43 0 1647 38.68278902 -121.9018288 2020-08-09 04:34:54 Yolo, California, US
394320 2020-08-08 US California Yuba 6115 588 4 0 584 39.26255932 -121.3535644 2020-08-09 04:34:54 Yuba, California, US
281676 2020-08-07 US California Alameda 6001 12884 206 0 12678 37.64629437 -121.8929271 2020-08-08 04:34:53 Alameda, California, US
281704 2020-08-07 US California Alpine 6003 2 0 0 2 38.59678594 -119.8223594 2020-08-08 04:34:53 Alpine, California, US
281705 2020-08-07 US California Amador 6005 162 0 0 162 38.44583082 -120.65696 2020-08-08 04:34:53 Amador, California, US
281985 2020-08-07 US California Butte 6007 1060 8 0 1052 39.66727762 -121.6005252 2020-08-08 04:34:53 Butte, California, US
281994 2020-08-07 US California Calaveras 6009 136 1 0 135 38.20537103 -120.552913 2020-08-08 04:34:53 Calaveras, California, US
282278 2020-08-07 US California Colusa 6011 362 4 0 358 39.17881957 -122.2331726 2020-08-08 04:34:53 Colusa, California, US
282288 2020-08-07 US California Contra Costa 6013 8760 136 0 8624 37.91923498 -121.9289527 2020-08-08 04:34:53 Contra Costa, California, US
282421 2020-08-07 US California Del Norte 6015 96 0 0 96 41.74228275 -123.8974063 2020-08-08 04:34:53 Del Norte, California, US
282521 2020-08-07 US California El Dorado 6017 716 1 0 715 38.77965956 -120.5233166 2020-08-08 04:34:53 El Dorado, California, US
282655 2020-08-07 US California Fresno 6019 16625 157 0 16468 36.75733899 -119.6466953 2020-08-08 04:34:53 Fresno, California, US
282715 2020-08-07 US California Glenn 6021 360 3 0 357 39.59875897 -122.3938452 2020-08-08 04:34:53 Glenn, California, US
282986 2020-08-07 US California Humboldt 6023 280 4 0 276 40.69923009 -123.876044 2020-08-08 04:34:53 Humboldt, California, US
283005 2020-08-07 US California Imperial 6025 9601 240 0 9361 33.0393082 -115.3669042 2020-08-08 04:34:53 Imperial, California, US
283010 2020-08-07 US California Inyo 6027 86 3 0 83 36.51112084 -117.41119779999998 2020-08-08 04:34:53 Inyo, California, US
283163 2020-08-07 US California Kern 6029 22009 160 0 21849 35.34329425 -118.7277796 2020-08-08 04:34:53 Kern, California, US
283180 2020-08-07 US California Kings 6031 4453 56 0 4397 36.07409056 -119.8159973 2020-08-08 04:34:53 Kings, California, US
283229 2020-08-07 US California Lake 6033 220 2 0 218 39.10124298 -122.7536244 2020-08-08 04:34:53 Lake, California, US
283266 2020-08-07 US California Lassen 6035 638 0 0 638 40.67311306 -120.59350990000002 2020-08-08 04:34:53 Lassen, California, US
283386 2020-08-07 US California Los Angeles 6037 204258 4919 0 199339 34.30828379 -118.2282411 2020-08-08 04:34:53 Los Angeles, California, US
283424 2020-08-07 US California Madera 6039 2267 36 0 2231 37.21513971 -119.76655890000002 2020-08-08 04:34:53 Madera, California, US
283462 2020-08-07 US California Marin 6041 5257 78 0 5179 38.07122463 -122.7210631 2020-08-08 04:34:53 Marin, California, US
283481 2020-08-07 US California Mariposa 6043 60 2 0 58 37.57978556 -119.9073334 2020-08-08 04:34:53 Mariposa, California, US
283567 2020-08-07 US California Mendocino 6045 363 10 0 353 39.4381191 -123.3911313 2020-08-08 04:34:53 Mendocino, California, US
283571 2020-08-07 US California Merced 6047 4855 62 0 4793 37.18922369 -120.7209035 2020-08-08 04:34:53 Merced, California, US
283623 2020-08-07 US California Modoc 6049 4 0 0 4 41.58965602 -120.7244817 2020-08-08 04:34:53 Modoc, California, US
283628 2020-08-07 US California Mono 6051 153 1 0 152 37.93899289 -118.8872409 2020-08-08 04:34:53 Mono, California, US
283650 2020-08-07 US California Monterey 6053 5156 35 0 5121 36.21862405 -121.2413397 2020-08-08 04:34:53 Monterey, California, US
283717 2020-08-07 US California Napa 6055 1046 10 0 1036 38.50735751 -122.332839 2020-08-08 04:34:53 Napa, California, US
283735 2020-08-07 US California Nevada 6057 321 1 0 320 39.30394768 -120.7627281 2020-08-08 04:34:53 Nevada, California, US
283818 2020-08-07 US California Orange 6059 38754 704 0 38050 33.70147516 -117.76459979999998 2020-08-08 04:34:53 Orange, California, US
283970 2020-08-07 US California Placer 6061 2099 20 0 2079 39.06167234 -120.7240569 2020-08-08 04:34:53 Placer, California, US
283976 2020-08-07 US California Plumas 6063 34 0 0 34 40.00355989 -120.8395236 2020-08-08 04:34:53 Plumas, California, US
284122 2020-08-07 US California Riverside 6065 40452 799 0 39653 33.74314981 -115.9933578 2020-08-08 04:34:53 Riverside, California, US
284174 2020-08-07 US California Sacramento 6067 10544 155 0 10389 38.45106826 -121.3425374 2020-08-08 04:34:53 Sacramento, California, US
284190 2020-08-07 US California San Benito 6069 699 4 0 695 36.60308176 -121.069975 2020-08-08 04:34:53 San Benito, California, US
284191 2020-08-07 US California San Bernardino 6071 34939 497 0 34442 34.84060306 -116.1774685 2020-08-08 04:34:53 San Bernardino, California, US
284192 2020-08-07 US California San Diego 6073 31127 583 0 30544 33.03484597 -116.7365326 2020-08-08 04:34:53 San Diego, California, US
284193 2020-08-07 US California San Francisco 6075 7326 64 0 7262 37.75215114 -122.4385672 2020-08-08 04:34:53 San Francisco, California, US
284196 2020-08-07 US California San Joaquin 6077 12119 192 0 11927 37.93433732 -121.2730061 2020-08-08 04:34:53 San Joaquin, California, US
284203 2020-08-07 US California San Luis Obispo 6079 2047 16 0 2031 35.38822029 -120.4039028 2020-08-08 04:34:53 San Luis Obispo, California, US
284204 2020-08-07 US California San Mateo 6081 5978 120 0 5858 37.4228808 -122.32755459999998 2020-08-08 04:34:53 San Mateo, California, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [johns_hopkins_csse_daily_reports] (
   [day] TEXT,
   [country_or_region] TEXT,
   [province_or_state] TEXT,
   [admin2] TEXT,
   [fips] TEXT,
   [confirmed] INTEGER,
   [deaths] INTEGER,
   [recovered] INTEGER,
   [active] INTEGER,
   [latitude] TEXT,
   [longitude] TEXT,
   [last_update] TEXT,
   [combined_key] TEXT
);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day]
                ON [johns_hopkins_csse_daily_reports] ([day]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state]
                ON [johns_hopkins_csse_daily_reports] ([province_or_state]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region]
                ON [johns_hopkins_csse_daily_reports] ([country_or_region]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key]
                ON [johns_hopkins_csse_daily_reports] ([combined_key]);
Powered by Datasette · Query took 1524.052ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette