johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
59,941 rows where province_or_state = "California" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths ▼ | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
869 | 869 | 2021-12-02 | US | California | Alpine | 6003 | 108 | 0 | 0 | 38.59678594 | -119.82235940000001 | 2021-12-03 04:23:05 | Alpine, California, US | |
898 | 898 | 2021-12-02 | US | California | Out of CA | 80006 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2021-12-03 04:23:05 | Out of CA, California, US | |
914 | 914 | 2021-12-02 | US | California | Sierra | 6091 | 217 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2021-12-03 04:23:05 | Sierra, California, US | |
924 | 924 | 2021-12-02 | US | California | Unassigned | 90006 | 136 | 0 | 0 | 41.74228275 | 0.0 | 2021-12-03 04:23:05 | Unassigned, California, US | |
4884 | 4884 | 2021-10-28 | US | California | Alpine | 6003 | 105 | 0 | 0 | 38.59678594 | -119.82235940000001 | 2021-10-29 04:22:03 | Alpine, California, US | |
4913 | 4913 | 2021-10-28 | US | California | Out of CA | 80006 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2021-10-29 04:22:03 | Out of CA, California, US | |
4929 | 4929 | 2021-10-28 | US | California | Sierra | 6091 | 195 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2021-10-29 04:22:03 | Sierra, California, US | |
4939 | 4939 | 2021-10-28 | US | California | Unassigned | 90006 | 222 | 0 | 0 | 41.74228275 | 0.0 | 2021-10-29 04:22:03 | Unassigned, California, US | |
8858 | 8858 | 2020-10-25 | US | California | Alpine | 6003 | 3 | 0 | 0 | 3 | 38.59678594 | -119.8223594 | 2020-10-26 04:25:02 | Alpine, California, US |
8881 | 8881 | 2020-10-25 | US | California | Modoc | 6049 | 28 | 0 | 0 | 28 | 41.58965602 | -120.7244817 | 2020-10-26 04:25:02 | Modoc, California, US |
8888 | 8888 | 2020-10-25 | US | California | Plumas | 6063 | 63 | 0 | 0 | 63 | 40.00355989 | -120.8395236 | 2020-10-26 04:25:02 | Plumas, California, US |
8902 | 8902 | 2020-10-25 | US | California | Sierra | 6091 | 6 | 0 | 0 | 6 | 39.57713498 | -120.52007009999998 | 2020-10-26 04:25:02 | Sierra, California, US |
8903 | 8903 | 2020-10-25 | US | California | Siskiyou | 6093 | 186 | 0 | 0 | 186 | 41.59198861 | -122.5407434 | 2020-10-26 04:25:02 | Siskiyou, California, US |
8909 | 8909 | 2020-10-25 | US | California | Trinity | 6105 | 36 | 0 | 0 | 33 | 40.64917670000001 | -123.114713 | 2020-10-26 04:25:02 | Trinity, California, US |
8912 | 8912 | 2020-10-25 | US | California | Unassigned | 90006 | 0 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2020-10-26 04:25:02 | Unassigned, California, US |
12870 | 12870 | 2021-01-26 | US | California | Alpine | 6003 | 74 | 0 | 0 | 74 | 38.59678594 | -119.8223594 | 2021-01-27 05:23:41 | Alpine, California, US |
12893 | 12893 | 2021-01-26 | US | California | Modoc | 6049 | 385 | 0 | 0 | 388 | 41.58965602 | -120.7244817 | 2021-01-27 05:23:41 | Modoc, California, US |
12914 | 12914 | 2021-01-26 | US | California | Sierra | 6091 | 55 | 0 | 0 | 57 | 39.57713498 | -120.52007009999998 | 2021-01-27 05:23:41 | Sierra, California, US |
12924 | 12924 | 2021-01-26 | US | California | Unassigned | 90006 | 0 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2021-01-27 05:23:41 | Unassigned, California, US |
16891 | 16891 | 2021-09-18 | US | California | Alpine | 6003 | 99 | 0 | 0 | 38.59678594 | -119.82235940000001 | 2021-09-19 04:21:34 | Alpine, California, US | |
16920 | 16920 | 2021-09-18 | US | California | Out of CA | 80006 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2021-09-19 04:21:34 | Out of CA, California, US | |
16936 | 16936 | 2021-09-18 | US | California | Sierra | 6091 | 138 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2021-09-19 04:21:34 | Sierra, California, US | |
16946 | 16946 | 2021-09-18 | US | California | Unassigned | 90006 | 101 | 0 | 0 | 41.74228275 | 0.0 | 2021-09-19 04:21:34 | Unassigned, California, US | |
20903 | 20903 | 2021-05-28 | US | California | Alpine | 6003 | 89 | 0 | 0 | 38.59678594 | -119.8223594 | 2021-05-29 04:20:41 | Alpine, California, US | |
20947 | 20947 | 2021-05-28 | US | California | Sierra | 6091 | 66 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2021-05-29 04:20:41 | Sierra, California, US | |
20957 | 20957 | 2021-05-28 | US | California | Unassigned | 90006 | 39 | 0 | 0 | 41.74228275 | 0.0 | 2021-05-29 04:20:41 | Unassigned, California, US | |
24940 | 24940 | 2022-03-20 | US | California | Alpine | 6003 | 123 | 0 | 0 | 38.59678594 | -119.82235940000001 | 2022-03-21 04:20:50 | Alpine, California, US | |
24969 | 24969 | 2022-03-20 | US | California | Out of CA | 80006 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2022-03-21 04:20:50 | Out of CA, California, US | |
28955 | 28955 | 2021-11-11 | US | California | Alpine | 6003 | 105 | 0 | 0 | 38.59678594 | -119.82235940000001 | 2021-11-12 04:22:01 | Alpine, California, US | |
28984 | 28984 | 2021-11-11 | US | California | Out of CA | 80006 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2021-11-12 04:22:01 | Out of CA, California, US | |
29000 | 29000 | 2021-11-11 | US | California | Sierra | 6091 | 207 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2021-11-12 04:22:01 | Sierra, California, US | |
29010 | 29010 | 2021-11-11 | US | California | Unassigned | 90006 | 127 | 0 | 0 | 41.74228275 | 0.0 | 2021-11-12 04:22:01 | Unassigned, California, US | |
32952 | 32952 | 2021-08-25 | US | California | Alpine | 6003 | 92 | 0 | 0 | 38.59678594 | -119.82235940000001 | 2021-08-26 04:21:28 | Alpine, California, US | |
32996 | 32996 | 2021-08-25 | US | California | Sierra | 6091 | 103 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2021-08-26 04:21:28 | Sierra, California, US | |
33006 | 33006 | 2021-08-25 | US | California | Unassigned | 90006 | 258 | 0 | 0 | 41.74228275 | 0.0 | 2021-08-26 04:21:28 | Unassigned, California, US | |
36962 | 36962 | 2021-04-12 | US | California | Alpine | 6003 | 88 | 0 | 0 | 38.59678594 | -119.8223594 | 2021-04-13 04:20:37 | Alpine, California, US | |
37006 | 37006 | 2021-04-12 | US | California | Sierra | 6091 | 63 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2021-04-13 04:20:37 | Sierra, California, US | |
37016 | 37016 | 2021-04-12 | US | California | Unassigned | 90006 | 65 | 0 | 0 | 41.74228275 | 0.0 | 2021-04-13 04:20:37 | Unassigned, California, US | |
40384 | 40384 | 2020-04-13 | US | California | Alpine | 6003 | 2 | 0 | 0 | 2 | 38.59678594 | -119.82235940000001 | 2020-04-13 23:07:54 | Alpine, California, US |
40385 | 40385 | 2020-04-13 | US | California | Amador | 6005 | 6 | 0 | 0 | 6 | 38.44583082 | -120.65696000000001 | 2020-04-13 23:07:54 | Amador, California, US |
40622 | 40622 | 2020-04-13 | US | California | Butte | 6007 | 15 | 0 | 0 | 14 | 39.66727762 | -121.6005252 | 2020-04-13 23:07:54 | Butte, California, US |
40630 | 40630 | 2020-04-13 | US | California | Calaveras | 6009 | 5 | 0 | 0 | 5 | 38.20537103 | -120.55291299999999 | 2020-04-13 23:07:54 | Calaveras, California, US |
40873 | 40873 | 2020-04-13 | US | California | Colusa | 6011 | 3 | 0 | 0 | 3 | 39.17881957 | -122.2331726 | 2020-04-13 23:07:54 | Colusa, California, US |
40995 | 40995 | 2020-04-13 | US | California | Del Norte | 6015 | 2 | 0 | 0 | 2 | 41.74228275 | -123.89740630000001 | 2020-04-13 23:07:54 | Del Norte, California, US |
41076 | 41076 | 2020-04-13 | US | California | El Dorado | 6017 | 29 | 0 | 0 | 29 | 38.77965956 | -120.5233166 | 2020-04-13 23:07:54 | El Dorado, California, US |
41238 | 41238 | 2020-04-13 | US | California | Glenn | 6021 | 3 | 0 | 0 | 3 | 39.59875897 | -122.3938452 | 2020-04-13 23:07:54 | Glenn, California, US |
41452 | 41452 | 2020-04-13 | US | California | Humboldt | 6023 | 43 | 0 | 0 | 43 | 40.69923009 | -123.876044 | 2020-04-13 23:07:54 | Humboldt, California, US |
41473 | 41473 | 2020-04-13 | US | California | Inyo | 6027 | 12 | 0 | 0 | 12 | 36.51112084 | -117.41119779999998 | 2020-04-13 23:07:54 | Inyo, California, US |
41618 | 41618 | 2020-04-13 | US | California | Kings | 6031 | 9 | 0 | 0 | 10 | 36.07409056 | -119.8159973 | 2020-04-13 23:07:54 | Kings, California, US |
41657 | 41657 | 2020-04-13 | US | California | Lake | 6033 | 3 | 0 | 0 | 3 | 39.10124298 | -122.75362439999999 | 2020-04-13 23:07:54 | Lake, California, US |
41951 | 41951 | 2020-04-13 | US | California | Mendocino | 6045 | 4 | 0 | 0 | 4 | 39.4381191 | -123.39113130000001 | 2020-04-13 23:07:54 | Mendocino, California, US |
42303 | 42303 | 2020-04-13 | US | California | Plumas | 6063 | 3 | 0 | 0 | 3 | 40.00355989 | -120.8395236 | 2020-04-13 23:07:54 | Plumas, California, US |
42571 | 42571 | 2020-04-13 | US | California | Siskiyou | 6093 | 5 | 0 | 0 | 5 | 41.59198861 | -122.54074340000001 | 2020-04-13 23:07:54 | Siskiyou, California, US |
42710 | 42710 | 2020-04-13 | US | California | Tehama | 6103 | 1 | 0 | 0 | 1 | 40.12570935 | -122.23701709999999 | 2020-04-13 23:07:54 | Tehama, California, US |
42759 | 42759 | 2020-04-13 | US | California | Tuolumne | 6109 | 0 | 0 | 0 | 0 | 38.02644018 | -119.95250929999999 | 2020-04-13 23:07:54 | Tuolumne, California, US |
42777 | 42777 | 2020-04-13 | US | California | Unassigned | 90006 | 0 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2020-04-13 23:07:54 | Unassigned, California, US |
44247 | 44247 | 2021-11-02 | US | California | Alpine | 6003 | 105 | 0 | 0 | 38.59678594 | -119.82235940000001 | 2021-11-03 06:22:09 | Alpine, California, US | |
44276 | 44276 | 2021-11-02 | US | California | Out of CA | 80006 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2021-11-03 06:22:09 | Out of CA, California, US | |
44292 | 44292 | 2021-11-02 | US | California | Sierra | 6091 | 200 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2021-11-03 06:22:09 | Sierra, California, US | |
44302 | 44302 | 2021-11-02 | US | California | Unassigned | 90006 | 584 | 0 | 0 | 41.74228275 | 0.0 | 2021-11-03 06:22:09 | Unassigned, California, US | |
47442 | 47442 | 2020-04-17 | US | California | Alpine | 6003 | 2 | 0 | 0 | 2 | 38.59678594 | -119.82235940000001 | 2020-04-17 23:30:52 | Alpine, California, US |
47443 | 47443 | 2020-04-17 | US | California | Amador | 6005 | 7 | 0 | 0 | 7 | 38.44583082 | -120.65696000000001 | 2020-04-17 23:30:52 | Amador, California, US |
47683 | 47683 | 2020-04-17 | US | California | Butte | 6007 | 17 | 0 | 0 | 16 | 39.66727762 | -121.6005252 | 2020-04-17 23:30:52 | Butte, California, US |
47690 | 47690 | 2020-04-17 | US | California | Calaveras | 6009 | 11 | 0 | 0 | 11 | 38.20537103 | -120.55291299999999 | 2020-04-17 23:30:52 | Calaveras, California, US |
47936 | 47936 | 2020-04-17 | US | California | Colusa | 6011 | 3 | 0 | 0 | 3 | 39.17881957 | -122.2331726 | 2020-04-17 23:30:52 | Colusa, California, US |
48059 | 48059 | 2020-04-17 | US | California | Del Norte | 6015 | 2 | 0 | 0 | 2 | 41.74228275 | -123.89740630000001 | 2020-04-17 23:30:52 | Del Norte, California, US |
48141 | 48141 | 2020-04-17 | US | California | El Dorado | 6017 | 35 | 0 | 0 | 35 | 38.77965956 | -120.5233166 | 2020-04-17 23:30:52 | El Dorado, California, US |
48303 | 48303 | 2020-04-17 | US | California | Glenn | 6021 | 3 | 0 | 0 | 3 | 39.59875897 | -122.3938452 | 2020-04-17 23:30:52 | Glenn, California, US |
48520 | 48520 | 2020-04-17 | US | California | Humboldt | 6023 | 51 | 0 | 0 | 51 | 40.69923009 | -123.876044 | 2020-04-17 23:30:52 | Humboldt, California, US |
48541 | 48541 | 2020-04-17 | US | California | Inyo | 6027 | 17 | 0 | 0 | 17 | 36.51112084 | -117.41119779999998 | 2020-04-17 23:30:52 | Inyo, California, US |
48728 | 48728 | 2020-04-17 | US | California | Lake | 6033 | 6 | 0 | 0 | 6 | 39.10124298 | -122.75362439999999 | 2020-04-17 23:30:52 | Lake, California, US |
49025 | 49025 | 2020-04-17 | US | California | Mendocino | 6045 | 4 | 0 | 0 | 4 | 39.4381191 | -123.39113130000001 | 2020-04-17 23:30:52 | Mendocino, California, US |
49387 | 49387 | 2020-04-17 | US | California | Plumas | 6063 | 4 | 0 | 0 | 4 | 40.00355989 | -120.8395236 | 2020-04-17 23:30:52 | Plumas, California, US |
49662 | 49662 | 2020-04-17 | US | California | Siskiyou | 6093 | 5 | 0 | 0 | 5 | 41.59198861 | -122.54074340000001 | 2020-04-17 23:30:52 | Siskiyou, California, US |
49852 | 49852 | 2020-04-17 | US | California | Tuolumne | 6109 | 2 | 0 | 0 | 2 | 38.02644018 | -119.95250929999999 | 2020-04-17 23:30:52 | Tuolumne, California, US |
49870 | 49870 | 2020-04-17 | US | California | Unassigned | 90006 | 0 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2020-04-17 23:30:52 | Unassigned, California, US |
51324 | 51324 | 2021-05-29 | US | California | Alpine | 6003 | 89 | 0 | 0 | 38.59678594 | -119.8223594 | 2021-05-30 04:20:55 | Alpine, California, US | |
51368 | 51368 | 2021-05-29 | US | California | Sierra | 6091 | 67 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2021-05-30 04:20:55 | Sierra, California, US | |
51378 | 51378 | 2021-05-29 | US | California | Unassigned | 90006 | 35 | 0 | 0 | 41.74228275 | 0.0 | 2021-05-30 04:20:55 | Unassigned, California, US | |
55335 | 55335 | 2021-03-07 | US | California | Alpine | 6003 | 84 | 0 | 0 | 38.59678594 | -119.8223594 | 2021-03-08 05:24:48 | Alpine, California, US | |
55379 | 55379 | 2021-03-07 | US | California | Sierra | 6091 | 60 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2021-03-08 05:24:48 | Sierra, California, US | |
55389 | 55389 | 2021-03-07 | US | California | Unassigned | 90006 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2021-03-08 05:24:48 | Unassigned, California, US | |
58564 | 58564 | 2020-07-23 | US | California | Alpine | 6003 | 2 | 0 | 0 | 2 | 38.59678594 | -119.8223594 | 2020-07-24 05:30:40 | Alpine, California, US |
58565 | 58565 | 2020-07-23 | US | California | Amador | 6005 | 61 | 0 | 0 | 61 | 38.44583082 | -120.65696 | 2020-07-24 05:30:40 | Amador, California, US |
58853 | 58853 | 2020-07-23 | US | California | Calaveras | 6009 | 102 | 0 | 0 | 102 | 38.20537103 | -120.552913 | 2020-07-24 05:30:40 | Calaveras, California, US |
59279 | 59279 | 2020-07-23 | US | California | Del Norte | 6015 | 66 | 0 | 0 | 66 | 41.74228275 | -123.8974063 | 2020-07-24 05:30:40 | Del Norte, California, US |
60121 | 60121 | 2020-07-23 | US | California | Lassen | 6035 | 571 | 0 | 0 | 538 | 40.67311306 | -120.59350990000002 | 2020-07-24 05:30:40 | Lassen, California, US |
60420 | 60420 | 2020-07-23 | US | California | Mendocino | 6045 | 178 | 0 | 0 | 178 | 39.4381191 | -123.3911313 | 2020-07-24 05:30:40 | Mendocino, California, US |
60826 | 60826 | 2020-07-23 | US | California | Plumas | 6063 | 21 | 0 | 0 | 21 | 40.00355989 | -120.8395236 | 2020-07-24 05:30:40 | Plumas, California, US |
61150 | 61150 | 2020-07-23 | US | California | Sierra | 6091 | 1 | 0 | 0 | 1 | 39.57713498 | -120.52007009999998 | 2020-07-24 05:30:40 | Sierra, California, US |
61158 | 61158 | 2020-07-23 | US | California | Siskiyou | 6093 | 53 | 0 | 0 | 53 | 41.59198861 | -122.5407434 | 2020-07-24 05:30:40 | Siskiyou, California, US |
61370 | 61370 | 2020-07-23 | US | California | Trinity | 6105 | 9 | 0 | 0 | 8 | 40.64917670000001 | -123.114713 | 2020-07-24 05:30:40 | Trinity, California, US |
61381 | 61381 | 2020-07-23 | US | California | Tuolumne | 6109 | 97 | 0 | 0 | 95 | 38.02644018 | -119.9525093 | 2020-07-24 05:30:40 | Tuolumne, California, US |
61399 | 61399 | 2020-07-23 | US | California | Unassigned | 90006 | 0 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2020-07-24 05:30:40 | Unassigned, California, US |
63605 | 63605 | 2022-11-12 | US | California | Alpine | 6003 | 137 | 0 | 0 | 38.59678594 | -119.8223594 | 2022-11-13 04:21:14 | Alpine, California, US | |
63634 | 63634 | 2022-11-12 | US | California | Out of CA | 80006 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2022-11-13 04:21:14 | Out of CA, California, US | |
63660 | 63660 | 2022-11-12 | US | California | Unassigned | 90006 | 4345 | 0 | 0 | 41.74228275 | 0.0 | 2022-11-13 04:21:14 | Unassigned, California, US | |
67597 | 67597 | 2021-09-01 | US | California | Alpine | 6003 | 92 | 0 | 0 | 38.59678594 | -119.82235940000001 | 2021-09-02 04:21:15 | Alpine, California, US | |
67641 | 67641 | 2021-09-01 | US | California | Sierra | 6091 | 111 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2021-09-02 04:21:15 | Sierra, California, US | |
67651 | 67651 | 2021-09-01 | US | California | Unassigned | 90006 | 223 | 0 | 0 | 41.74228275 | 0.0 | 2021-09-02 04:21:15 | Unassigned, California, US |
Advanced export
JSON shape: default, array, newline-delimited
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] TEXT, [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]);