⚠️ 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

20,236 rows where province_or_state = "California" sorted by day descending

View and edit SQL

province_or_state

  • California · 20,236

country_or_region

  • US 20,236
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
901212 2021-03-04 US California Alameda 6001 81086 1281 0 79805 37.64629437 -121.8929271 2021-03-05 05:26:29 Alameda, California, US
901213 2021-03-04 US California Alpine 6003 82 0 0 82 38.59678594 -119.8223594 2021-03-05 05:26:29 Alpine, California, US
901214 2021-03-04 US California Amador 6005 3478 41 0 3437 38.44583082 -120.65696 2021-03-05 05:26:29 Amador, California, US
901215 2021-03-04 US California Butte 6007 11014 167 0 10847 39.66727762 -121.6005252 2021-03-05 05:26:29 Butte, California, US
901216 2021-03-04 US California Calaveras 6009 1922 49 0 1873 38.20537103 -120.552913 2021-03-05 05:26:29 Calaveras, California, US
901217 2021-03-04 US California Colusa 6011 2140 13 0 2127 39.17881957 -122.2331726 2021-03-05 05:26:29 Colusa, California, US
901218 2021-03-04 US California Contra Costa 6013 63053 696 0 62357 37.91923498 -121.9289527 2021-03-05 05:26:29 Contra Costa, California, US
901219 2021-03-04 US California Del Norte 6015 1016 5 0 1011 41.74228275 -123.8974063 2021-03-05 05:26:29 Del Norte, California, US
901220 2021-03-04 US California El Dorado 6017 9201 100 0 9101 38.77965956 -120.5233166 2021-03-05 05:26:29 El Dorado, California, US
901221 2021-03-04 US California Fresno 6019 95893 1458 0 94435 36.75733899 -119.6466953 2021-03-05 05:26:29 Fresno, California, US
901222 2021-03-04 US California Glenn 6021 2233 23 0 2210 39.59875897 -122.3938452 2021-03-05 05:26:29 Glenn, California, US
901223 2021-03-04 US California Humboldt 6023 3246 33 0 3213 40.69923009 -123.876044 2021-03-05 05:26:29 Humboldt, California, US
901224 2021-03-04 US California Imperial 6025 26939 638 0 26301 33.0393082 -115.3669042 2021-03-05 05:26:29 Imperial, California, US
901225 2021-03-04 US California Inyo 6027 1326 37 0 1289 36.51112084 -117.41119779999998 2021-03-05 05:26:29 Inyo, California, US
901226 2021-03-04 US California Kern 6029 103894 924 0 102970 35.34329425 -118.7277796 2021-03-05 05:26:29 Kern, California, US
901227 2021-03-04 US California Kings 6031 22119 227 0 21892 36.07409056 -119.8159973 2021-03-05 05:26:29 Kings, California, US
901228 2021-03-04 US California Lake 6033 3175 41 0 3134 39.10124298 -122.7536244 2021-03-05 05:26:29 Lake, California, US
901229 2021-03-04 US California Lassen 6035 5623 24 0 5599 40.67311306 -120.59350990000002 2021-03-05 05:26:29 Lassen, California, US
901230 2021-03-04 US California Los Angeles 6037 1198178 21780 0 1176398 34.30828379 -118.2282411 2021-03-05 05:26:29 Los Angeles, California, US
901231 2021-03-04 US California Madera 6039 15553 214 0 15339 37.21513971 -119.76655890000002 2021-03-05 05:26:29 Madera, California, US
901232 2021-03-04 US California Marin 6041 13316 198 0 13118 38.07122463 -122.7210631 2021-03-05 05:26:29 Marin, California, US
901233 2021-03-04 US California Mariposa 6043 395 7 0 388 37.57978556 -119.9073334 2021-03-05 05:26:29 Mariposa, California, US
901234 2021-03-04 US California Mendocino 6045 3827 44 0 3783 39.4381191 -123.3911313 2021-03-05 05:26:29 Mendocino, California, US
901235 2021-03-04 US California Merced 6047 29325 412 0 28913 37.18922369 -120.7209035 2021-03-05 05:26:29 Merced, California, US
901236 2021-03-04 US California Modoc 6049 460 4 0 456 41.58965602 -120.7244817 2021-03-05 05:26:29 Modoc, California, US
901237 2021-03-04 US California Mono 6051 1219 4 0 1215 37.93899289 -118.8872409 2021-03-05 05:26:29 Mono, California, US
901238 2021-03-04 US California Monterey 6053 42362 329 0 42033 36.21862405 -121.2413397 2021-03-05 05:26:29 Monterey, California, US
901239 2021-03-04 US California Napa 6055 9090 74 0 9016 38.50735751 -122.332839 2021-03-05 05:26:29 Napa, California, US
901240 2021-03-04 US California Nevada 6057 4012 74 0 3938 39.30394768 -120.7627281 2021-03-05 05:26:29 Nevada, California, US
901241 2021-03-04 US California Orange 6059 261976 4013 0 257963 33.70147516 -117.76459979999998 2021-03-05 05:26:29 Orange, California, US
901242 2021-03-04 US California Placer 6061 19963 232 0 19731 39.06167234 -120.7240569 2021-03-05 05:26:29 Placer, California, US
901243 2021-03-04 US California Plumas 6063 653 6 0 647 40.00355989 -120.8395236 2021-03-05 05:26:29 Plumas, California, US
901244 2021-03-04 US California Riverside 6065 290744 3884 0 286860 33.74314981 -115.9933578 2021-03-05 05:26:29 Riverside, California, US
901245 2021-03-04 US California Sacramento 6067 93947 1506 0 92441 38.45106826 -121.3425374 2021-03-05 05:26:29 Sacramento, California, US
901246 2021-03-04 US California San Benito 6069 5774 61 0 5713 36.60308176 -121.069975 2021-03-05 05:26:29 San Benito, California, US
901247 2021-03-04 US California San Bernardino 6071 287246 3022 0 284224 34.84060306 -116.1774685 2021-03-05 05:26:29 San Bernardino, California, US
901248 2021-03-04 US California San Diego 6073 261861 3359 0 258502 33.03484597 -116.7365326 2021-03-05 05:26:29 San Diego, California, US
901249 2021-03-04 US California San Francisco 6075 34443 423 0 34020 37.75215114 -122.4385672 2021-03-05 05:26:29 San Francisco, California, US
901250 2021-03-04 US California San Joaquin 6077 67213 1177 0 66036 37.93433732 -121.2730061 2021-03-05 05:26:29 San Joaquin, California, US
901251 2021-03-04 US California San Luis Obispo 6079 19797 241 0 19556 35.38822029 -120.4039028 2021-03-05 05:26:29 San Luis Obispo, California, US
901252 2021-03-04 US California San Mateo 6081 39189 521 0 38668 37.4228808 -122.32755459999998 2021-03-05 05:26:29 San Mateo, California, US
901253 2021-03-04 US California Santa Barbara 6083 32219 421 0 31798 34.65329488 -120.0188492 2021-03-05 05:26:29 Santa Barbara, California, US
901254 2021-03-04 US California Santa Clara 6085 111281 1820 0 109461 37.23104908 -121.6970462 2021-03-05 05:26:29 Santa Clara, California, US
901255 2021-03-04 US California Santa Cruz 6087 14760 187 0 14573 37.05580291 -122.0066524 2021-03-05 05:26:29 Santa Cruz, California, US
901256 2021-03-04 US California Shasta 6089 11086 179 0 10907 40.76391419 -122.0396884 2021-03-05 05:26:29 Shasta, California, US
901257 2021-03-04 US California Sierra 6091 100 0 0 100 39.57713498 -120.52007009999998 2021-03-05 05:26:29 Sierra, California, US
901258 2021-03-04 US California Siskiyou 6093 1786 14 0 1772 41.59198861 -122.5407434 2021-03-05 05:26:29 Siskiyou, California, US
901259 2021-03-04 US California Solano 6095 30262 165 0 30097 38.26827353 -121.9357113 2021-03-05 05:26:29 Solano, California, US
901260 2021-03-04 US California Sonoma 6097 28307 301 0 28006 38.52746429 -122.8862506 2021-03-05 05:26:29 Sonoma, California, US
901261 2021-03-04 US California Stanislaus 6099 56522 955 0 55567 37.55862499 -120.9970722 2021-03-05 05:26:29 Stanislaus, California, US
901262 2021-03-04 US California Sutter 6101 8906 98 0 8808 39.03417539 -121.6945899 2021-03-05 05:26:29 Sutter, California, US
901263 2021-03-04 US California Tehama 6103 5118 52 0 5066 40.12570935 -122.2370171 2021-03-05 05:26:29 Tehama, California, US
901264 2021-03-04 US California Trinity 6105 373 5 0 368 40.64917670000001 -123.114713 2021-03-05 05:26:29 Trinity, California, US
901265 2021-03-04 US California Tulare 6107 48163 768 0 47395 36.22026558 -118.8020203 2021-03-05 05:26:29 Tulare, California, US
901266 2021-03-04 US California Tuolumne 6109 3968 59 0 3909 38.02644018 -119.9525093 2021-03-05 05:26:29 Tuolumne, California, US
901267 2021-03-04 US California Unassigned 90006 0 0 0 0 41.74228275 0.0 2021-03-05 05:26:29 Unassigned, California, US
901268 2021-03-04 US California Ventura 6111 78057 876 0 77181 34.44465746 -119.0910613 2021-03-05 05:26:29 Ventura, California, US
901269 2021-03-04 US California Yolo 6113 12890 185 0 12705 38.68278902 -121.9018288 2021-03-05 05:26:29 Yolo, California, US
901270 2021-03-04 US California Yuba 6115 5786 39 0 5747 39.26255932 -121.3535644 2021-03-05 05:26:29 Yuba, California, US
908937 2021-03-03 US California Alameda 6001 80950 1271 0 79679 37.64629437 -121.8929271 2021-03-04 05:24:24 Alameda, California, US
908938 2021-03-03 US California Alpine 6003 82 0 0 82 38.59678594 -119.8223594 2021-03-04 05:24:24 Alpine, California, US
908939 2021-03-03 US California Amador 6005 3474 41 0 3433 38.44583082 -120.65696 2021-03-04 05:24:24 Amador, California, US
908940 2021-03-03 US California Butte 6007 11007 167 0 10840 39.66727762 -121.6005252 2021-03-04 05:24:24 Butte, California, US
908941 2021-03-03 US California Calaveras 6009 1918 49 0 1869 38.20537103 -120.552913 2021-03-04 05:24:24 Calaveras, California, US
908942 2021-03-03 US California Colusa 6011 2140 13 0 2127 39.17881957 -122.2331726 2021-03-04 05:24:24 Colusa, California, US
908943 2021-03-03 US California Contra Costa 6013 62931 695 0 62236 37.91923498 -121.9289527 2021-03-04 05:24:24 Contra Costa, California, US
908944 2021-03-03 US California Del Norte 6015 1008 5 0 1003 41.74228275 -123.8974063 2021-03-04 05:24:24 Del Norte, California, US
908945 2021-03-03 US California El Dorado 6017 9195 100 0 9095 38.77965956 -120.5233166 2021-03-04 05:24:24 El Dorado, California, US
908946 2021-03-03 US California Fresno 6019 95785 1451 0 94334 36.75733899 -119.6466953 2021-03-04 05:24:24 Fresno, California, US
908947 2021-03-03 US California Glenn 6021 2232 23 0 2209 39.59875897 -122.3938452 2021-03-04 05:24:24 Glenn, California, US
908948 2021-03-03 US California Humboldt 6023 3230 33 0 3197 40.69923009 -123.876044 2021-03-04 05:24:24 Humboldt, California, US
908949 2021-03-03 US California Imperial 6025 26926 638 0 26288 33.0393082 -115.3669042 2021-03-04 05:24:24 Imperial, California, US
908950 2021-03-03 US California Inyo 6027 1321 37 0 1284 36.51112084 -117.41119779999998 2021-03-04 05:24:24 Inyo, California, US
908951 2021-03-03 US California Kern 6029 103756 915 0 102841 35.34329425 -118.7277796 2021-03-04 05:24:24 Kern, California, US
908952 2021-03-03 US California Kings 6031 22091 220 0 21871 36.07409056 -119.8159973 2021-03-04 05:24:24 Kings, California, US
908953 2021-03-03 US California Lake 6033 3169 41 0 3128 39.10124298 -122.7536244 2021-03-04 05:24:24 Lake, California, US
908954 2021-03-03 US California Lassen 6035 5623 24 0 5599 40.67311306 -120.59350990000002 2021-03-04 05:24:24 Lassen, California, US
908955 2021-03-03 US California Los Angeles 6037 1196017 21676 0 1174341 34.30828379 -118.2282411 2021-03-04 05:24:24 Los Angeles, California, US
908956 2021-03-03 US California Madera 6039 15523 214 0 15309 37.21513971 -119.76655890000002 2021-03-04 05:24:24 Madera, California, US
908957 2021-03-03 US California Marin 6041 13285 198 0 13087 38.07122463 -122.7210631 2021-03-04 05:24:24 Marin, California, US
908958 2021-03-03 US California Mariposa 6043 395 7 0 388 37.57978556 -119.9073334 2021-03-04 05:24:24 Mariposa, California, US
908959 2021-03-03 US California Mendocino 6045 3826 43 0 3783 39.4381191 -123.3911313 2021-03-04 05:24:24 Mendocino, California, US
908960 2021-03-03 US California Merced 6047 29264 407 0 28857 37.18922369 -120.7209035 2021-03-04 05:24:24 Merced, California, US
908961 2021-03-03 US California Modoc 6049 460 4 0 456 41.58965602 -120.7244817 2021-03-04 05:24:24 Modoc, California, US
908962 2021-03-03 US California Mono 6051 1214 4 0 1210 37.93899289 -118.8872409 2021-03-04 05:24:24 Mono, California, US
908963 2021-03-03 US California Monterey 6053 42335 329 0 42006 36.21862405 -121.2413397 2021-03-04 05:24:24 Monterey, California, US
908964 2021-03-03 US California Napa 6055 9080 72 0 9008 38.50735751 -122.332839 2021-03-04 05:24:24 Napa, California, US
908965 2021-03-03 US California Nevada 6057 3988 74 0 3914 39.30394768 -120.7627281 2021-03-04 05:24:24 Nevada, California, US
908966 2021-03-03 US California Orange 6059 261798 3966 0 257832 33.70147516 -117.76459979999998 2021-03-04 05:24:24 Orange, California, US
908967 2021-03-03 US California Placer 6061 19911 232 0 19679 39.06167234 -120.7240569 2021-03-04 05:24:24 Placer, California, US
908968 2021-03-03 US California Plumas 6063 653 6 0 647 40.00355989 -120.8395236 2021-03-04 05:24:24 Plumas, California, US
908969 2021-03-03 US California Riverside 6065 290498 3849 0 286649 33.74314981 -115.9933578 2021-03-04 05:24:24 Riverside, California, US
908970 2021-03-03 US California Sacramento 6067 93790 1498 0 92292 38.45106826 -121.3425374 2021-03-04 05:24:24 Sacramento, California, US
908971 2021-03-03 US California San Benito 6069 5770 61 0 5709 36.60308176 -121.069975 2021-03-04 05:24:24 San Benito, California, US
908972 2021-03-03 US California San Bernardino 6071 287055 2959 0 284096 34.84060306 -116.1774685 2021-03-04 05:24:24 San Bernardino, California, US
908973 2021-03-03 US California San Diego 6073 261353 3342 0 258011 33.03484597 -116.7365326 2021-03-04 05:24:24 San Diego, California, US
908974 2021-03-03 US California San Francisco 6075 34387 422 0 33965 37.75215114 -122.4385672 2021-03-04 05:24:24 San Francisco, California, US
908975 2021-03-03 US California San Joaquin 6077 67123 1150 0 65973 37.93433732 -121.2730061 2021-03-04 05:24:24 San Joaquin, California, US
908976 2021-03-03 US California San Luis Obispo 6079 19751 238 0 19513 35.38822029 -120.4039028 2021-03-04 05:24:24 San Luis Obispo, California, US
908977 2021-03-03 US California San Mateo 6081 39148 521 0 38627 37.4228808 -122.32755459999998 2021-03-04 05:24:24 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]);