daily_reports (view)
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)
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths ▼ | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-12-02 | US | California | Alpine | 6003 | 108 | 0 | 0 | 38.59678594 | -119.82235940000001 | 2021-12-03 04:23:05 | Alpine, California, US | |
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 | |
2021-12-02 | US | California | Sierra | 6091 | 217 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2021-12-03 04:23:05 | Sierra, California, US | |
2021-12-02 | US | California | Unassigned | 90006 | 136 | 0 | 0 | 41.74228275 | 0.0 | 2021-12-03 04:23:05 | Unassigned, California, US | |
2021-10-28 | US | California | Alpine | 6003 | 105 | 0 | 0 | 38.59678594 | -119.82235940000001 | 2021-10-29 04:22:03 | Alpine, California, US | |
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 | |
2021-10-28 | US | California | Sierra | 6091 | 195 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2021-10-29 04:22:03 | Sierra, California, US | |
2021-10-28 | US | California | Unassigned | 90006 | 222 | 0 | 0 | 41.74228275 | 0.0 | 2021-10-29 04:22:03 | Unassigned, California, US | |
2020-10-25 | US | California | Alpine | 6003 | 3 | 0 | 0 | 3 | 38.59678594 | -119.8223594 | 2020-10-26 04:25:02 | Alpine, California, US |
2020-10-25 | US | California | Modoc | 6049 | 28 | 0 | 0 | 28 | 41.58965602 | -120.7244817 | 2020-10-26 04:25:02 | Modoc, California, US |
2020-10-25 | US | California | Plumas | 6063 | 63 | 0 | 0 | 63 | 40.00355989 | -120.8395236 | 2020-10-26 04:25:02 | Plumas, California, US |
2020-10-25 | US | California | Sierra | 6091 | 6 | 0 | 0 | 6 | 39.57713498 | -120.52007009999998 | 2020-10-26 04:25:02 | Sierra, California, US |
2020-10-25 | US | California | Siskiyou | 6093 | 186 | 0 | 0 | 186 | 41.59198861 | -122.5407434 | 2020-10-26 04:25:02 | Siskiyou, California, US |
2020-10-25 | US | California | Trinity | 6105 | 36 | 0 | 0 | 33 | 40.64917670000001 | -123.114713 | 2020-10-26 04:25:02 | Trinity, California, US |
2020-10-25 | US | California | Unassigned | 90006 | 0 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2020-10-26 04:25:02 | Unassigned, California, US |
2021-01-26 | US | California | Alpine | 6003 | 74 | 0 | 0 | 74 | 38.59678594 | -119.8223594 | 2021-01-27 05:23:41 | Alpine, California, US |
2021-01-26 | US | California | Modoc | 6049 | 385 | 0 | 0 | 388 | 41.58965602 | -120.7244817 | 2021-01-27 05:23:41 | Modoc, California, US |
2021-01-26 | US | California | Sierra | 6091 | 55 | 0 | 0 | 57 | 39.57713498 | -120.52007009999998 | 2021-01-27 05:23:41 | Sierra, California, US |
2021-01-26 | US | California | Unassigned | 90006 | 0 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2021-01-27 05:23:41 | Unassigned, California, US |
2021-09-18 | US | California | Alpine | 6003 | 99 | 0 | 0 | 38.59678594 | -119.82235940000001 | 2021-09-19 04:21:34 | Alpine, California, US | |
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 | |
2021-09-18 | US | California | Sierra | 6091 | 138 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2021-09-19 04:21:34 | Sierra, California, US | |
2021-09-18 | US | California | Unassigned | 90006 | 101 | 0 | 0 | 41.74228275 | 0.0 | 2021-09-19 04:21:34 | Unassigned, California, US | |
2021-05-28 | US | California | Alpine | 6003 | 89 | 0 | 0 | 38.59678594 | -119.8223594 | 2021-05-29 04:20:41 | Alpine, California, US | |
2021-05-28 | US | California | Sierra | 6091 | 66 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2021-05-29 04:20:41 | Sierra, California, US | |
2021-05-28 | US | California | Unassigned | 90006 | 39 | 0 | 0 | 41.74228275 | 0.0 | 2021-05-29 04:20:41 | Unassigned, California, US | |
2022-03-20 | US | California | Alpine | 6003 | 123 | 0 | 0 | 38.59678594 | -119.82235940000001 | 2022-03-21 04:20:50 | Alpine, California, US | |
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 | |
2021-11-11 | US | California | Alpine | 6003 | 105 | 0 | 0 | 38.59678594 | -119.82235940000001 | 2021-11-12 04:22:01 | Alpine, California, US | |
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 | |
2021-11-11 | US | California | Sierra | 6091 | 207 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2021-11-12 04:22:01 | Sierra, California, US | |
2021-11-11 | US | California | Unassigned | 90006 | 127 | 0 | 0 | 41.74228275 | 0.0 | 2021-11-12 04:22:01 | Unassigned, California, US | |
2021-08-25 | US | California | Alpine | 6003 | 92 | 0 | 0 | 38.59678594 | -119.82235940000001 | 2021-08-26 04:21:28 | Alpine, California, US | |
2021-08-25 | US | California | Sierra | 6091 | 103 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2021-08-26 04:21:28 | Sierra, California, US | |
2021-08-25 | US | California | Unassigned | 90006 | 258 | 0 | 0 | 41.74228275 | 0.0 | 2021-08-26 04:21:28 | Unassigned, California, US | |
2021-04-12 | US | California | Alpine | 6003 | 88 | 0 | 0 | 38.59678594 | -119.8223594 | 2021-04-13 04:20:37 | Alpine, California, US | |
2021-04-12 | US | California | Sierra | 6091 | 63 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2021-04-13 04:20:37 | Sierra, California, US | |
2021-04-12 | US | California | Unassigned | 90006 | 65 | 0 | 0 | 41.74228275 | 0.0 | 2021-04-13 04:20:37 | Unassigned, California, US | |
2020-04-13 | US | California | Alpine | 6003 | 2 | 0 | 0 | 2 | 38.59678594 | -119.82235940000001 | 2020-04-13 23:07:54 | Alpine, California, US |
2020-04-13 | US | California | Amador | 6005 | 6 | 0 | 0 | 6 | 38.44583082 | -120.65696000000001 | 2020-04-13 23:07:54 | Amador, California, US |
2020-04-13 | US | California | Butte | 6007 | 15 | 0 | 0 | 14 | 39.66727762 | -121.6005252 | 2020-04-13 23:07:54 | Butte, California, US |
2020-04-13 | US | California | Calaveras | 6009 | 5 | 0 | 0 | 5 | 38.20537103 | -120.55291299999999 | 2020-04-13 23:07:54 | Calaveras, California, US |
2020-04-13 | US | California | Colusa | 6011 | 3 | 0 | 0 | 3 | 39.17881957 | -122.2331726 | 2020-04-13 23:07:54 | Colusa, California, US |
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 |
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 |
2020-04-13 | US | California | Glenn | 6021 | 3 | 0 | 0 | 3 | 39.59875897 | -122.3938452 | 2020-04-13 23:07:54 | Glenn, California, US |
2020-04-13 | US | California | Humboldt | 6023 | 43 | 0 | 0 | 43 | 40.69923009 | -123.876044 | 2020-04-13 23:07:54 | Humboldt, California, US |
2020-04-13 | US | California | Inyo | 6027 | 12 | 0 | 0 | 12 | 36.51112084 | -117.41119779999998 | 2020-04-13 23:07:54 | Inyo, California, US |
2020-04-13 | US | California | Kings | 6031 | 9 | 0 | 0 | 10 | 36.07409056 | -119.8159973 | 2020-04-13 23:07:54 | Kings, California, US |
2020-04-13 | US | California | Lake | 6033 | 3 | 0 | 0 | 3 | 39.10124298 | -122.75362439999999 | 2020-04-13 23:07:54 | Lake, California, US |
2020-04-13 | US | California | Mendocino | 6045 | 4 | 0 | 0 | 4 | 39.4381191 | -123.39113130000001 | 2020-04-13 23:07:54 | Mendocino, California, US |
2020-04-13 | US | California | Plumas | 6063 | 3 | 0 | 0 | 3 | 40.00355989 | -120.8395236 | 2020-04-13 23:07:54 | Plumas, California, US |
2020-04-13 | US | California | Siskiyou | 6093 | 5 | 0 | 0 | 5 | 41.59198861 | -122.54074340000001 | 2020-04-13 23:07:54 | Siskiyou, California, US |
2020-04-13 | US | California | Tehama | 6103 | 1 | 0 | 0 | 1 | 40.12570935 | -122.23701709999999 | 2020-04-13 23:07:54 | Tehama, California, US |
2020-04-13 | US | California | Tuolumne | 6109 | 0 | 0 | 0 | 0 | 38.02644018 | -119.95250929999999 | 2020-04-13 23:07:54 | Tuolumne, California, US |
2020-04-13 | US | California | Unassigned | 90006 | 0 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2020-04-13 23:07:54 | Unassigned, California, US |
2021-11-02 | US | California | Alpine | 6003 | 105 | 0 | 0 | 38.59678594 | -119.82235940000001 | 2021-11-03 06:22:09 | Alpine, California, US | |
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 | |
2021-11-02 | US | California | Sierra | 6091 | 200 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2021-11-03 06:22:09 | Sierra, California, US | |
2021-11-02 | US | California | Unassigned | 90006 | 584 | 0 | 0 | 41.74228275 | 0.0 | 2021-11-03 06:22:09 | Unassigned, California, US | |
2020-04-17 | US | California | Alpine | 6003 | 2 | 0 | 0 | 2 | 38.59678594 | -119.82235940000001 | 2020-04-17 23:30:52 | Alpine, California, US |
2020-04-17 | US | California | Amador | 6005 | 7 | 0 | 0 | 7 | 38.44583082 | -120.65696000000001 | 2020-04-17 23:30:52 | Amador, California, US |
2020-04-17 | US | California | Butte | 6007 | 17 | 0 | 0 | 16 | 39.66727762 | -121.6005252 | 2020-04-17 23:30:52 | Butte, California, US |
2020-04-17 | US | California | Calaveras | 6009 | 11 | 0 | 0 | 11 | 38.20537103 | -120.55291299999999 | 2020-04-17 23:30:52 | Calaveras, California, US |
2020-04-17 | US | California | Colusa | 6011 | 3 | 0 | 0 | 3 | 39.17881957 | -122.2331726 | 2020-04-17 23:30:52 | Colusa, California, US |
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 |
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 |
2020-04-17 | US | California | Glenn | 6021 | 3 | 0 | 0 | 3 | 39.59875897 | -122.3938452 | 2020-04-17 23:30:52 | Glenn, California, US |
2020-04-17 | US | California | Humboldt | 6023 | 51 | 0 | 0 | 51 | 40.69923009 | -123.876044 | 2020-04-17 23:30:52 | Humboldt, California, US |
2020-04-17 | US | California | Inyo | 6027 | 17 | 0 | 0 | 17 | 36.51112084 | -117.41119779999998 | 2020-04-17 23:30:52 | Inyo, California, US |
2020-04-17 | US | California | Lake | 6033 | 6 | 0 | 0 | 6 | 39.10124298 | -122.75362439999999 | 2020-04-17 23:30:52 | Lake, California, US |
2020-04-17 | US | California | Mendocino | 6045 | 4 | 0 | 0 | 4 | 39.4381191 | -123.39113130000001 | 2020-04-17 23:30:52 | Mendocino, California, US |
2020-04-17 | US | California | Plumas | 6063 | 4 | 0 | 0 | 4 | 40.00355989 | -120.8395236 | 2020-04-17 23:30:52 | Plumas, California, US |
2020-04-17 | US | California | Siskiyou | 6093 | 5 | 0 | 0 | 5 | 41.59198861 | -122.54074340000001 | 2020-04-17 23:30:52 | Siskiyou, California, US |
2020-04-17 | US | California | Tuolumne | 6109 | 2 | 0 | 0 | 2 | 38.02644018 | -119.95250929999999 | 2020-04-17 23:30:52 | Tuolumne, California, US |
2020-04-17 | US | California | Unassigned | 90006 | 0 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2020-04-17 23:30:52 | Unassigned, California, US |
2021-05-29 | US | California | Alpine | 6003 | 89 | 0 | 0 | 38.59678594 | -119.8223594 | 2021-05-30 04:20:55 | Alpine, California, US | |
2021-05-29 | US | California | Sierra | 6091 | 67 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2021-05-30 04:20:55 | Sierra, California, US | |
2021-05-29 | US | California | Unassigned | 90006 | 35 | 0 | 0 | 41.74228275 | 0.0 | 2021-05-30 04:20:55 | Unassigned, California, US | |
2021-03-07 | US | California | Alpine | 6003 | 84 | 0 | 0 | 38.59678594 | -119.8223594 | 2021-03-08 05:24:48 | Alpine, California, US | |
2021-03-07 | US | California | Sierra | 6091 | 60 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2021-03-08 05:24:48 | Sierra, California, US | |
2021-03-07 | US | California | Unassigned | 90006 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2021-03-08 05:24:48 | Unassigned, California, US | |
2020-07-23 | US | California | Alpine | 6003 | 2 | 0 | 0 | 2 | 38.59678594 | -119.8223594 | 2020-07-24 05:30:40 | Alpine, California, US |
2020-07-23 | US | California | Amador | 6005 | 61 | 0 | 0 | 61 | 38.44583082 | -120.65696 | 2020-07-24 05:30:40 | Amador, California, US |
2020-07-23 | US | California | Calaveras | 6009 | 102 | 0 | 0 | 102 | 38.20537103 | -120.552913 | 2020-07-24 05:30:40 | Calaveras, California, US |
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 |
2020-07-23 | US | California | Lassen | 6035 | 571 | 0 | 0 | 538 | 40.67311306 | -120.59350990000002 | 2020-07-24 05:30:40 | Lassen, California, US |
2020-07-23 | US | California | Mendocino | 6045 | 178 | 0 | 0 | 178 | 39.4381191 | -123.3911313 | 2020-07-24 05:30:40 | Mendocino, California, US |
2020-07-23 | US | California | Plumas | 6063 | 21 | 0 | 0 | 21 | 40.00355989 | -120.8395236 | 2020-07-24 05:30:40 | Plumas, California, US |
2020-07-23 | US | California | Sierra | 6091 | 1 | 0 | 0 | 1 | 39.57713498 | -120.52007009999998 | 2020-07-24 05:30:40 | Sierra, California, US |
2020-07-23 | US | California | Siskiyou | 6093 | 53 | 0 | 0 | 53 | 41.59198861 | -122.5407434 | 2020-07-24 05:30:40 | Siskiyou, California, US |
2020-07-23 | US | California | Trinity | 6105 | 9 | 0 | 0 | 8 | 40.64917670000001 | -123.114713 | 2020-07-24 05:30:40 | Trinity, California, US |
2020-07-23 | US | California | Tuolumne | 6109 | 97 | 0 | 0 | 95 | 38.02644018 | -119.9525093 | 2020-07-24 05:30:40 | Tuolumne, California, US |
2020-07-23 | US | California | Unassigned | 90006 | 0 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2020-07-24 05:30:40 | Unassigned, California, US |
2022-11-12 | US | California | Alpine | 6003 | 137 | 0 | 0 | 38.59678594 | -119.8223594 | 2022-11-13 04:21:14 | Alpine, California, US | |
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 | |
2022-11-12 | US | California | Unassigned | 90006 | 4345 | 0 | 0 | 41.74228275 | 0.0 | 2022-11-13 04:21:14 | Unassigned, California, US | |
2021-09-01 | US | California | Alpine | 6003 | 92 | 0 | 0 | 38.59678594 | -119.82235940000001 | 2021-09-02 04:21:15 | Alpine, California, US | |
2021-09-01 | US | California | Sierra | 6091 | 111 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2021-09-02 04:21:15 | Sierra, California, US | |
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 VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;