daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
24 rows where country_or_region = "US", deaths = 498 and province_or_state = "California" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 1
- US · 24 ✖
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-07-14 | US | California | San Luis Obispo | 6079 | 65533 | 498 | 0 | 35.38822029 | -120.4039028 | 2022-07-15 04:20:53 | San Luis Obispo, California, US | |
2022-07-13 | US | California | San Luis Obispo | 6079 | 65182 | 498 | 0 | 35.38822029 | -120.4039028 | 2022-07-14 04:20:57 | San Luis Obispo, California, US | |
2022-07-12 | US | California | San Luis Obispo | 6079 | 65152 | 498 | 0 | 35.38822029 | -120.4039028 | 2022-07-13 04:20:58 | San Luis Obispo, California, US | |
2022-07-11 | US | California | San Luis Obispo | 6079 | 65120 | 498 | 0 | 35.38822029 | -120.4039028 | 2022-07-12 04:20:51 | San Luis Obispo, California, US | |
2022-07-10 | US | California | San Luis Obispo | 6079 | 64583 | 498 | 0 | 35.38822029 | -120.4039028 | 2022-07-11 04:20:46 | San Luis Obispo, California, US | |
2022-07-09 | US | California | San Luis Obispo | 6079 | 64564 | 498 | 0 | 35.38822029 | -120.4039028 | 2022-07-10 04:20:54 | San Luis Obispo, California, US | |
2022-07-08 | US | California | San Luis Obispo | 6079 | 64549 | 498 | 0 | 35.38822029 | -120.4039028 | 2022-07-09 04:20:59 | San Luis Obispo, California, US | |
2022-01-11 | US | California | Placer | 6061 | 51911 | 498 | 0 | 39.06167234 | -120.72405690000001 | 2022-01-12 04:21:44 | Placer, California, US | |
2022-01-10 | US | California | Placer | 6061 | 50932 | 498 | 0 | 39.06167234 | -120.72405690000001 | 2022-01-11 04:22:01 | Placer, California, US | |
2022-01-10 | US | California | Shasta | 6089 | 28194 | 498 | 0 | 40.76391419 | -122.0396884 | 2022-01-11 04:22:01 | Shasta, California, US | |
2022-01-09 | US | California | Shasta | 6089 | 28050 | 498 | 0 | 40.76391419 | -122.0396884 | 2022-01-10 04:22:07 | Shasta, California, US | |
2022-01-08 | US | California | Shasta | 6089 | 27678 | 498 | 0 | 40.76391419 | -122.0396884 | 2022-01-09 04:21:46 | Shasta, California, US | |
2022-01-07 | US | California | Shasta | 6089 | 27644 | 498 | 0 | 40.76391419 | -122.0396884 | 2022-01-08 04:21:53 | Shasta, California, US | |
2022-01-06 | US | California | Shasta | 6089 | 27594 | 498 | 0 | 40.76391419 | -122.0396884 | 2022-01-07 04:22:09 | Shasta, California, US | |
2022-01-05 | US | California | Shasta | 6089 | 27341 | 498 | 0 | 40.76391419 | -122.0396884 | 2022-01-06 04:22:09 | Shasta, California, US | |
2021-09-17 | US | California | Santa Barbara | 6083 | 42801 | 498 | 0 | 34.65329488 | -120.0188492 | 2021-09-18 04:21:24 | Santa Barbara, California, US | |
2021-08-31 | US | California | Merced | 6047 | 36870 | 498 | 0 | 37.18922369 | -120.72090349999999 | 2021-09-01 04:21:38 | Merced, California, US | |
2021-04-11 | US | California | San Francisco | 6075 | 37022 | 498 | 0 | 37.75215114 | -122.4385672 | 2021-04-12 04:21:00 | San Francisco, California, US | |
2021-04-10 | US | California | San Francisco | 6075 | 36978 | 498 | 0 | 37.75215114 | -122.4385672 | 2021-04-11 04:20:56 | San Francisco, California, US | |
2021-01-26 | US | California | Imperial | 6025 | 28122 | 498 | 0 | 27817 | 33.0393082 | -115.3669042 | 2021-01-27 05:23:41 | Imperial, California, US |
2020-12-12 | US | California | Santa Clara | 6085 | 46082 | 498 | 0 | 45584 | 37.23104908 | -121.6970462 | 2020-12-13 05:27:20 | Santa Clara, California, US |
2020-12-12 | US | California | Stanislaus | 6099 | 28472 | 498 | 0 | 28076 | 37.55862499 | -120.9970722 | 2020-12-13 05:27:20 | Stanislaus, California, US |
2020-10-29 | US | California | San Joaquin | 6077 | 21975 | 498 | 0 | 21484 | 37.93433732 | -121.2730061 | 2020-10-30 04:24:49 | San Joaquin, California, US |
2020-10-28 | US | California | San Joaquin | 6077 | 21935 | 498 | 0 | 21443 | 37.93433732 | -121.2730061 | 2020-10-29 04:24:49 | San Joaquin, California, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;