johns_hopkins_csse_daily_reports

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

34,021 rows where province_or_state = "California" sorted by day descending

✎ View and edit SQL

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

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

province_or_state

  • California · 34,021 ✖

country_or_region

  • US 34,021
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
32820 32820 2021-10-23 US California Alameda 6001 120692 1400 0   37.64629437 -121.8929271 2021-10-24 04:21:22 Alameda, California, US
32821 32821 2021-10-23 US California Alpine 6003 105 0 0   38.59678594 -119.82235940000001 2021-10-24 04:21:22 Alpine, California, US
32822 32822 2021-10-23 US California Amador 6005 5473 64 0   38.44583082 -120.65696000000001 2021-10-24 04:21:22 Amador, California, US
32823 32823 2021-10-23 US California Butte 6007 23818 273 0   39.66727762 -121.6005252 2021-10-24 04:21:22 Butte, California, US
32824 32824 2021-10-23 US California Calaveras 6009 3914 81 0   38.20537103 -120.55291299999999 2021-10-24 04:21:22 Calaveras, California, US
32825 32825 2021-10-23 US California Colusa 6011 3076 18 0   39.17881957 -122.2331726 2021-10-24 04:21:22 Colusa, California, US
32826 32826 2021-10-23 US California Contra Costa 6013 100018 1008 0   37.91923498 -121.9289527 2021-10-24 04:21:22 Contra Costa, California, US
32827 32827 2021-10-23 US California Del Norte 6015 3587 42 0   41.74228275 -123.89740630000001 2021-10-24 04:21:22 Del Norte, California, US
32828 32828 2021-10-23 US California El Dorado 6017 17207 149 0   38.77965956 -120.5233166 2021-10-24 04:21:22 El Dorado, California, US
32829 32829 2021-10-23 US California Fresno 6019 146318 2094 0   36.75733899 -119.6466953 2021-10-24 04:21:22 Fresno, California, US
32830 32830 2021-10-23 US California Glenn 6021 4384 33 0   39.59875897 -122.3938452 2021-10-24 04:21:22 Glenn, California, US
32831 32831 2021-10-23 US California Humboldt 6023 9269 109 0   40.69923009 -123.876044 2021-10-24 04:21:22 Humboldt, California, US
32832 32832 2021-10-23 US California Imperial 6025 36071 766 0   33.0393082 -115.36690420000001 2021-10-24 04:21:22 Imperial, California, US
32833 32833 2021-10-23 US California Inyo 6027 2142 41 0   36.51112084 -117.41119779999998 2021-10-24 04:21:22 Inyo, California, US
32834 32834 2021-10-23 US California Kern 6029 146348 1648 0   35.34329425 -118.72777959999999 2021-10-24 04:21:22 Kern, California, US
32835 32835 2021-10-23 US California Kings 6031 32938 325 0   36.07409056 -119.8159973 2021-10-24 04:21:22 Kings, California, US
32836 32836 2021-10-23 US California Lake 6033 6631 105 0   39.10124298 -122.75362439999999 2021-10-24 04:21:22 Lake, California, US
32837 32837 2021-10-23 US California Lassen 6035 7543 47 0   40.67311306 -120.59350990000002 2021-10-24 04:21:22 Lassen, California, US
32838 32838 2021-10-23 US California Los Angeles 6037 1484192 26540 0   34.30828379 -118.22824109999999 2021-10-24 04:21:22 Los Angeles, California, US
32839 32839 2021-10-23 US California Madera 6039 23955 285 0   37.21513971 -119.76655890000002 2021-10-24 04:21:22 Madera, California, US
32840 32840 2021-10-23 US California Marin 6041 17706 244 0   38.07122463 -122.72106310000001 2021-10-24 04:21:22 Marin, California, US
32841 32841 2021-10-23 US California Mariposa 6043 1339 16 0   37.57978556 -119.9073334 2021-10-24 04:21:22 Mariposa, California, US
32842 32842 2021-10-23 US California Mendocino 6045 7667 87 0   39.4381191 -123.39113130000001 2021-10-24 04:21:22 Mendocino, California, US
32843 32843 2021-10-23 US California Merced 6047 42422 581 0   37.18922369 -120.72090349999999 2021-10-24 04:21:22 Merced, California, US
32844 32844 2021-10-23 US California Modoc 6049 689 5 0   41.58965602 -120.7244817 2021-10-24 04:21:22 Modoc, California, US
32845 32845 2021-10-23 US California Mono 6051 1672 3 0   37.93899289 -118.8872409 2021-10-24 04:21:22 Mono, California, US
32846 32846 2021-10-23 US California Monterey 6053 50911 586 0   36.21862405 -121.24133970000001 2021-10-24 04:21:22 Monterey, California, US
32847 32847 2021-10-23 US California Napa 6055 12898 100 0   38.50735751 -122.33283899999999 2021-10-24 04:21:22 Napa, California, US
32848 32848 2021-10-23 US California Nevada 6057 9167 90 0   39.30394768 -120.76272809999999 2021-10-24 04:21:22 Nevada, California, US
32849 32849 2021-10-23 US California Orange 6059 324288 5562 0   33.70147516 -117.76459979999998 2021-10-24 04:21:22 Orange, California, US
32850 32850 2021-10-23 US California Out of CA 80006 0 0 0   41.74228275 0.0 2021-10-24 04:21:22 Out of CA, California, US
32851 32851 2021-10-23 US California Placer 6061 39435 429 0   39.06167234 -120.72405690000001 2021-10-24 04:21:22 Placer, California, US
32852 32852 2021-10-23 US California Plumas 6063 1660 7 0   40.00355989 -120.8395236 2021-10-24 04:21:22 Plumas, California, US
32853 32853 2021-10-23 US California Riverside 6065 371670 5041 0   33.74314981 -115.9933578 2021-10-24 04:21:22 Riverside, California, US
32854 32854 2021-10-23 US California Sacramento 6067 159636 2309 0   38.45106826 -121.34253740000001 2021-10-24 04:21:22 Sacramento, California, US
32855 32855 2021-10-23 US California San Benito 6069 7449 72 0   36.60308176 -121.069975 2021-10-24 04:21:22 San Benito, California, US
32856 32856 2021-10-23 US California San Bernardino 6071 358677 5692 0   34.84060306 -116.1774685 2021-10-24 04:21:22 San Bernardino, California, US
32857 32857 2021-10-23 US California San Diego 6073 367361 4183 0   33.03484597 -116.73653259999999 2021-10-24 04:21:22 San Diego, California, US
32858 32858 2021-10-23 US California San Francisco 6075 54440 649 0   37.75215114 -122.43856720000001 2021-10-24 04:21:22 San Francisco, California, US
32859 32859 2021-10-23 US California San Joaquin 6077 102776 1721 0   37.93433732 -121.2730061 2021-10-24 04:21:22 San Joaquin, California, US
32860 32860 2021-10-23 US California San Luis Obispo 6079 29973 333 0   35.38822029 -120.4039028 2021-10-24 04:21:22 San Luis Obispo, California, US
32861 32861 2021-10-23 US California San Mateo 6081 54168 623 0   37.422880799999994 -122.32755459999998 2021-10-24 04:21:22 San Mateo, California, US
32862 32862 2021-10-23 US California Santa Barbara 6083 45223 523 0   34.65329488 -120.0188492 2021-10-24 04:21:22 Santa Barbara, California, US
32863 32863 2021-10-23 US California Santa Clara 6085 145543 1897 0   37.23104908 -121.6970462 2021-10-24 04:21:22 Santa Clara, California, US
32864 32864 2021-10-23 US California Santa Cruz 6087 21034 221 0   37.05580291 -122.0066524 2021-10-24 04:21:22 Santa Cruz, California, US
32865 32865 2021-10-23 US California Shasta 6089 23924 352 0   40.76391419 -122.0396884 2021-10-24 04:21:22 Shasta, California, US
32866 32866 2021-10-23 US California Sierra 6091 188 0 0   39.57713498 -120.52007009999998 2021-10-24 04:21:22 Sierra, California, US
32867 32867 2021-10-23 US California Siskiyou 6093 4512 46 0   41.59198861 -122.54074340000001 2021-10-24 04:21:22 Siskiyou, California, US
32868 32868 2021-10-23 US California Solano 6095 46063 341 0   38.26827353 -121.9357113 2021-10-24 04:21:22 Solano, California, US
32869 32869 2021-10-23 US California Sonoma 6097 40997 404 0   38.52746429 -122.88625060000001 2021-10-24 04:21:22 Sonoma, California, US
32870 32870 2021-10-23 US California Stanislaus 6099 86299 1335 0   37.55862499 -120.9970722 2021-10-24 04:21:22 Stanislaus, California, US
32871 32871 2021-10-23 US California Sutter 6101 13937 175 0   39.03417539 -121.6945899 2021-10-24 04:21:22 Sutter, California, US
32872 32872 2021-10-23 US California Tehama 6103 9534 110 0   40.12570935 -122.23701709999999 2021-10-24 04:21:22 Tehama, California, US
32873 32873 2021-10-23 US California Trinity 6105 880 11 0   40.64917670000001 -123.114713 2021-10-24 04:21:22 Trinity, California, US
32874 32874 2021-10-23 US California Tulare 6107 80375 978 0   36.22026558 -118.8020203 2021-10-24 04:21:22 Tulare, California, US
32875 32875 2021-10-23 US California Tuolumne 6109 6917 90 0   38.02644018 -119.95250929999999 2021-10-24 04:21:22 Tuolumne, California, US
32876 32876 2021-10-23 US California Unassigned 90006 146 0 0   41.74228275 0.0 2021-10-24 04:21:22 Unassigned, California, US
32877 32877 2021-10-23 US California Ventura 6111 101038 1167 0   34.44465746 -119.09106129999999 2021-10-24 04:21:22 Ventura, California, US
32878 32878 2021-10-23 US California Yolo 6113 20397 248 0   38.68278902 -121.90182879999999 2021-10-24 04:21:22 Yolo, California, US
32879 32879 2021-10-23 US California Yuba 6115 10115 82 0   39.26255932 -121.35356440000001 2021-10-24 04:21:22 Yuba, California, US
313304 313304 2021-10-22 US California Alameda 6001 120692 1400 0   37.64629437 -121.8929271 2021-10-23 04:21:32 Alameda, California, US
313305 313305 2021-10-22 US California Alpine 6003 105 0 0   38.59678594 -119.82235940000001 2021-10-23 04:21:32 Alpine, California, US
313306 313306 2021-10-22 US California Amador 6005 5473 64 0   38.44583082 -120.65696000000001 2021-10-23 04:21:32 Amador, California, US
313307 313307 2021-10-22 US California Butte 6007 23818 273 0   39.66727762 -121.6005252 2021-10-23 04:21:32 Butte, California, US
313308 313308 2021-10-22 US California Calaveras 6009 3914 81 0   38.20537103 -120.55291299999999 2021-10-23 04:21:32 Calaveras, California, US
313309 313309 2021-10-22 US California Colusa 6011 3076 18 0   39.17881957 -122.2331726 2021-10-23 04:21:32 Colusa, California, US
313310 313310 2021-10-22 US California Contra Costa 6013 100018 1008 0   37.91923498 -121.9289527 2021-10-23 04:21:32 Contra Costa, California, US
313311 313311 2021-10-22 US California Del Norte 6015 3587 42 0   41.74228275 -123.89740630000001 2021-10-23 04:21:32 Del Norte, California, US
313312 313312 2021-10-22 US California El Dorado 6017 17207 149 0   38.77965956 -120.5233166 2021-10-23 04:21:32 El Dorado, California, US
313313 313313 2021-10-22 US California Fresno 6019 146318 2094 0   36.75733899 -119.6466953 2021-10-23 04:21:32 Fresno, California, US
313314 313314 2021-10-22 US California Glenn 6021 4384 33 0   39.59875897 -122.3938452 2021-10-23 04:21:32 Glenn, California, US
313315 313315 2021-10-22 US California Humboldt 6023 9269 109 0   40.69923009 -123.876044 2021-10-23 04:21:32 Humboldt, California, US
313316 313316 2021-10-22 US California Imperial 6025 36071 766 0   33.0393082 -115.36690420000001 2021-10-23 04:21:32 Imperial, California, US
313317 313317 2021-10-22 US California Inyo 6027 2142 41 0   36.51112084 -117.41119779999998 2021-10-23 04:21:32 Inyo, California, US
313318 313318 2021-10-22 US California Kern 6029 146348 1648 0   35.34329425 -118.72777959999999 2021-10-23 04:21:32 Kern, California, US
313319 313319 2021-10-22 US California Kings 6031 32938 325 0   36.07409056 -119.8159973 2021-10-23 04:21:32 Kings, California, US
313320 313320 2021-10-22 US California Lake 6033 6631 105 0   39.10124298 -122.75362439999999 2021-10-23 04:21:32 Lake, California, US
313321 313321 2021-10-22 US California Lassen 6035 7543 47 0   40.67311306 -120.59350990000002 2021-10-23 04:21:32 Lassen, California, US
313322 313322 2021-10-22 US California Los Angeles 6037 1483031 26527 0   34.30828379 -118.22824109999999 2021-10-23 04:21:32 Los Angeles, California, US
313323 313323 2021-10-22 US California Madera 6039 23955 285 0   37.21513971 -119.76655890000002 2021-10-23 04:21:32 Madera, California, US
313324 313324 2021-10-22 US California Marin 6041 17706 244 0   38.07122463 -122.72106310000001 2021-10-23 04:21:32 Marin, California, US
313325 313325 2021-10-22 US California Mariposa 6043 1339 16 0   37.57978556 -119.9073334 2021-10-23 04:21:32 Mariposa, California, US
313326 313326 2021-10-22 US California Mendocino 6045 7667 87 0   39.4381191 -123.39113130000001 2021-10-23 04:21:32 Mendocino, California, US
313327 313327 2021-10-22 US California Merced 6047 42422 581 0   37.18922369 -120.72090349999999 2021-10-23 04:21:32 Merced, California, US
313328 313328 2021-10-22 US California Modoc 6049 689 5 0   41.58965602 -120.7244817 2021-10-23 04:21:32 Modoc, California, US
313329 313329 2021-10-22 US California Mono 6051 1672 3 0   37.93899289 -118.8872409 2021-10-23 04:21:32 Mono, California, US
313330 313330 2021-10-22 US California Monterey 6053 50911 586 0   36.21862405 -121.24133970000001 2021-10-23 04:21:32 Monterey, California, US
313331 313331 2021-10-22 US California Napa 6055 12898 100 0   38.50735751 -122.33283899999999 2021-10-23 04:21:32 Napa, California, US
313332 313332 2021-10-22 US California Nevada 6057 9167 90 0   39.30394768 -120.76272809999999 2021-10-23 04:21:32 Nevada, California, US
313333 313333 2021-10-22 US California Orange 6059 324288 5562 0   33.70147516 -117.76459979999998 2021-10-23 04:21:32 Orange, California, US
313334 313334 2021-10-22 US California Out of CA 80006 0 0 0   41.74228275 0.0 2021-10-23 04:21:32 Out of CA, California, US
313335 313335 2021-10-22 US California Placer 6061 39435 429 0   39.06167234 -120.72405690000001 2021-10-23 04:21:32 Placer, California, US
313336 313336 2021-10-22 US California Plumas 6063 1660 7 0   40.00355989 -120.8395236 2021-10-23 04:21:32 Plumas, California, US
313337 313337 2021-10-22 US California Riverside 6065 371670 5041 0   33.74314981 -115.9933578 2021-10-23 04:21:32 Riverside, California, US
313338 313338 2021-10-22 US California Sacramento 6067 159636 2309 0   38.45106826 -121.34253740000001 2021-10-23 04:21:32 Sacramento, California, US
313339 313339 2021-10-22 US California San Benito 6069 7449 72 0   36.60308176 -121.069975 2021-10-23 04:21:32 San Benito, California, US
313340 313340 2021-10-22 US California San Bernardino 6071 358677 5692 0   34.84060306 -116.1774685 2021-10-23 04:21:32 San Bernardino, California, US
313341 313341 2021-10-22 US California San Diego 6073 366661 4183 0   33.03484597 -116.73653259999999 2021-10-23 04:21:32 San Diego, California, US
313342 313342 2021-10-22 US California San Francisco 6075 54440 649 0   37.75215114 -122.43856720000001 2021-10-23 04:21:32 San Francisco, California, US
313343 313343 2021-10-22 US California San Joaquin 6077 102776 1721 0   37.93433732 -121.2730061 2021-10-23 04:21:32 San Joaquin, 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]);