daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
283 rows where country_or_region = "US", deaths = 63 and province_or_state = "California" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-03-29 | US | California | Lassen | 6035 | 9842 | 63 | 0 | 40.67311306 | -120.59350990000002 | 2022-03-30 04:20:45 | Lassen, California, US | |
2022-03-28 | US | California | Lassen | 6035 | 9842 | 63 | 0 | 40.67311306 | -120.59350990000002 | 2022-03-29 04:20:46 | Lassen, California, US | |
2022-03-27 | US | California | Lassen | 6035 | 9840 | 63 | 0 | 40.67311306 | -120.59350990000002 | 2022-03-28 04:20:33 | Lassen, California, US | |
2022-03-26 | US | California | Lassen | 6035 | 9840 | 63 | 0 | 40.67311306 | -120.59350990000002 | 2022-03-27 04:20:47 | Lassen, California, US | |
2022-03-25 | US | California | Lassen | 6035 | 9840 | 63 | 0 | 40.67311306 | -120.59350990000002 | 2022-03-26 04:20:23 | Lassen, California, US | |
2022-03-24 | US | California | Lassen | 6035 | 9840 | 63 | 0 | 40.67311306 | -120.59350990000002 | 2022-03-25 04:20:46 | Lassen, California, US | |
2022-03-23 | US | California | Lassen | 6035 | 9833 | 63 | 0 | 40.67311306 | -120.59350990000002 | 2022-03-24 04:20:43 | Lassen, California, US | |
2022-03-22 | US | California | Lassen | 6035 | 9832 | 63 | 0 | 40.67311306 | -120.59350990000002 | 2022-03-23 04:20:48 | Lassen, California, US | |
2022-03-21 | US | California | Lassen | 6035 | 9831 | 63 | 0 | 40.67311306 | -120.59350990000002 | 2022-03-22 04:20:54 | Lassen, California, US | |
2022-03-20 | US | California | Lassen | 6035 | 9818 | 63 | 0 | 40.67311306 | -120.59350990000002 | 2022-03-21 04:20:50 | Lassen, California, US | |
2022-03-19 | US | California | Lassen | 6035 | 9818 | 63 | 0 | 40.67311306 | -120.59350990000002 | 2022-03-20 04:20:45 | Lassen, California, US | |
2022-03-18 | US | California | Lassen | 6035 | 9818 | 63 | 0 | 40.67311306 | -120.59350990000002 | 2022-03-19 04:20:47 | Lassen, California, US | |
2021-10-13 | US | California | Amador | 6005 | 5361 | 63 | 0 | 38.44583082 | -120.65696000000001 | 2021-10-14 04:21:29 | Amador, California, US | |
2021-10-12 | US | California | Amador | 6005 | 5357 | 63 | 0 | 38.44583082 | -120.65696000000001 | 2021-10-13 04:20:51 | Amador, California, US | |
2021-09-08 | US | California | Calaveras | 6009 | 3179 | 63 | 0 | 38.20537103 | -120.55291299999999 | 2021-09-09 04:21:27 | Calaveras, California, US | |
2021-09-07 | US | California | Calaveras | 6009 | 3160 | 63 | 0 | 38.20537103 | -120.55291299999999 | 2021-09-08 04:21:31 | Calaveras, California, US | |
2021-09-06 | US | California | Calaveras | 6009 | 3142 | 63 | 0 | 38.20537103 | -120.55291299999999 | 2021-09-07 04:21:35 | Calaveras, California, US | |
2021-09-05 | US | California | Calaveras | 6009 | 3126 | 63 | 0 | 38.20537103 | -120.55291299999999 | 2021-09-06 04:21:22 | Calaveras, California, US | |
2021-09-04 | US | California | Calaveras | 6009 | 3106 | 63 | 0 | 38.20537103 | -120.55291299999999 | 2021-09-05 04:21:33 | Calaveras, California, US | |
2021-09-03 | US | California | Calaveras | 6009 | 3088 | 63 | 0 | 38.20537103 | -120.55291299999999 | 2021-09-04 04:21:28 | Calaveras, California, US | |
2021-08-09 | US | California | San Benito | 6069 | 6474 | 63 | 0 | 36.60308176 | -121.069975 | 2021-08-10 04:21:27 | San Benito, California, US | |
2021-08-08 | US | California | San Benito | 6069 | 6464 | 63 | 0 | 36.60308176 | -121.069975 | 2021-08-09 04:21:24 | San Benito, California, US | |
2021-08-07 | US | California | San Benito | 6069 | 6446 | 63 | 0 | 36.60308176 | -121.069975 | 2021-08-08 04:21:33 | San Benito, California, US | |
2021-08-06 | US | California | San Benito | 6069 | 6429 | 63 | 0 | 36.60308176 | -121.069975 | 2021-08-07 04:21:30 | San Benito, California, US | |
2021-08-05 | US | California | San Benito | 6069 | 6419 | 63 | 0 | 36.60308176 | -121.069975 | 2021-08-06 04:21:18 | San Benito, California, US | |
2021-08-04 | US | California | San Benito | 6069 | 6414 | 63 | 0 | 36.60308176 | -121.069975 | 2021-08-05 04:21:51 | San Benito, California, US | |
2021-08-03 | US | California | San Benito | 6069 | 6397 | 63 | 0 | 36.60308176 | -121.069975 | 2021-08-04 04:21:25 | San Benito, California, US | |
2021-08-02 | US | California | San Benito | 6069 | 6388 | 63 | 0 | 36.60308176 | -121.069975 | 2021-08-03 04:21:39 | San Benito, California, US | |
2021-08-01 | US | California | San Benito | 6069 | 6383 | 63 | 0 | 36.60308176 | -121.069975 | 2021-08-02 04:21:36 | San Benito, California, US | |
2021-07-31 | US | California | San Benito | 6069 | 6363 | 63 | 0 | 36.60308176 | -121.069975 | 2021-08-01 04:21:50 | San Benito, California, US | |
2021-07-30 | US | California | San Benito | 6069 | 6363 | 63 | 0 | 36.60308176 | -121.069975 | 2021-07-31 04:21:35 | San Benito, California, US | |
2021-07-29 | US | California | San Benito | 6069 | 6363 | 63 | 0 | 36.60308176 | -121.069975 | 2021-07-30 04:21:34 | San Benito, California, US | |
2021-07-28 | US | California | San Benito | 6069 | 6348 | 63 | 0 | 36.60308176 | -121.069975 | 2021-07-29 04:21:33 | San Benito, California, US | |
2021-07-27 | US | California | San Benito | 6069 | 6341 | 63 | 0 | 36.60308176 | -121.069975 | 2021-07-28 04:21:39 | San Benito, California, US | |
2021-07-26 | US | California | San Benito | 6069 | 6334 | 63 | 0 | 36.60308176 | -121.069975 | 2021-07-27 04:21:18 | San Benito, California, US | |
2021-07-25 | US | California | San Benito | 6069 | 6329 | 63 | 0 | 36.60308176 | -121.069975 | 2021-07-26 04:21:28 | San Benito, California, US | |
2021-07-24 | US | California | San Benito | 6069 | 6311 | 63 | 0 | 36.60308176 | -121.069975 | 2021-07-25 04:22:12 | San Benito, California, US | |
2021-07-23 | US | California | San Benito | 6069 | 6311 | 63 | 0 | 36.60308176 | -121.069975 | 2021-07-24 00:21:36 | San Benito, California, US | |
2021-07-22 | US | California | San Benito | 6069 | 6311 | 63 | 0 | 36.60308176 | -121.069975 | 2021-07-23 04:21:29 | San Benito, California, US | |
2021-07-21 | US | California | San Benito | 6069 | 6307 | 63 | 0 | 36.60308176 | -121.069975 | 2021-07-22 04:21:19 | San Benito, California, US | |
2021-07-20 | US | California | San Benito | 6069 | 6307 | 63 | 0 | 36.60308176 | -121.069975 | 2021-07-21 04:21:40 | San Benito, California, US | |
2021-07-19 | US | California | San Benito | 6069 | 6304 | 63 | 0 | 36.60308176 | -121.069975 | 2021-07-20 04:21:48 | San Benito, California, US | |
2021-07-18 | US | California | San Benito | 6069 | 6302 | 63 | 0 | 36.60308176 | -121.069975 | 2021-07-19 04:21:24 | San Benito, California, US | |
2021-07-17 | US | California | San Benito | 6069 | 6292 | 63 | 0 | 36.60308176 | -121.069975 | 2021-07-18 04:22:07 | San Benito, California, US | |
2021-07-16 | US | California | San Benito | 6069 | 6292 | 63 | 0 | 36.60308176 | -121.069975 | 2021-07-17 04:22:22 | San Benito, California, US | |
2021-07-15 | US | California | San Benito | 6069 | 6292 | 63 | 0 | 36.60308176 | -121.069975 | 2021-07-16 04:21:22 | San Benito, California, US | |
2021-07-14 | US | California | Lake | 6033 | 3753 | 63 | 0 | 39.10124298 | -122.7536244 | 2021-07-15 04:21:48 | Lake, California, US | |
2021-07-14 | US | California | San Benito | 6069 | 6288 | 63 | 0 | 36.60308176 | -121.069975 | 2021-07-15 04:21:48 | San Benito, California, US | |
2021-07-13 | US | California | Lake | 6033 | 3732 | 63 | 0 | 39.10124298 | -122.7536244 | 2021-07-14 04:21:35 | Lake, California, US | |
2021-07-13 | US | California | San Benito | 6069 | 6284 | 63 | 0 | 36.60308176 | -121.069975 | 2021-07-14 04:21:35 | San Benito, California, US | |
2021-07-12 | US | California | Lake | 6033 | 3719 | 63 | 0 | 39.10124298 | -122.7536244 | 2021-07-13 04:21:18 | Lake, California, US | |
2021-07-12 | US | California | San Benito | 6069 | 6277 | 63 | 0 | 36.60308176 | -121.069975 | 2021-07-13 04:21:18 | San Benito, California, US | |
2021-07-12 | US | California | Tehama | 6103 | 5725 | 63 | 0 | 40.12570935 | -122.2370171 | 2021-07-13 04:21:18 | Tehama, California, US | |
2021-07-11 | US | California | Lake | 6033 | 3712 | 63 | 0 | 39.10124298 | -122.7536244 | 2021-07-12 04:21:34 | Lake, California, US | |
2021-07-11 | US | California | San Benito | 6069 | 6274 | 63 | 0 | 36.60308176 | -121.069975 | 2021-07-12 04:21:34 | San Benito, California, US | |
2021-07-11 | US | California | Tehama | 6103 | 5725 | 63 | 0 | 40.12570935 | -122.2370171 | 2021-07-12 04:21:34 | Tehama, California, US | |
2021-07-10 | US | California | Lake | 6033 | 3680 | 63 | 0 | 39.10124298 | -122.7536244 | 2021-07-11 04:21:43 | Lake, California, US | |
2021-07-10 | US | California | San Benito | 6069 | 6252 | 63 | 0 | 36.60308176 | -121.069975 | 2021-07-11 04:21:43 | San Benito, California, US | |
2021-07-10 | US | California | Tehama | 6103 | 5718 | 63 | 0 | 40.12570935 | -122.2370171 | 2021-07-11 04:21:43 | Tehama, California, US | |
2021-07-09 | US | California | Lake | 6033 | 3680 | 63 | 0 | 39.10124298 | -122.7536244 | 2021-07-10 04:21:25 | Lake, California, US | |
2021-07-09 | US | California | San Benito | 6069 | 6252 | 63 | 0 | 36.60308176 | -121.069975 | 2021-07-10 04:21:25 | San Benito, California, US | |
2021-07-09 | US | California | Tehama | 6103 | 5718 | 63 | 0 | 40.12570935 | -122.2370171 | 2021-07-10 04:21:25 | Tehama, California, US | |
2021-07-08 | US | California | Lake | 6033 | 3680 | 63 | 0 | 39.10124298 | -122.7536244 | 2021-07-09 04:21:21 | Lake, California, US | |
2021-07-08 | US | California | San Benito | 6069 | 6252 | 63 | 0 | 36.60308176 | -121.069975 | 2021-07-09 04:21:21 | San Benito, California, US | |
2021-07-08 | US | California | Tehama | 6103 | 5717 | 63 | 0 | 40.12570935 | -122.2370171 | 2021-07-09 04:21:21 | Tehama, California, US | |
2021-07-07 | US | California | Lake | 6033 | 3673 | 63 | 0 | 39.10124298 | -122.7536244 | 2021-07-08 04:21:26 | Lake, California, US | |
2021-07-07 | US | California | San Benito | 6069 | 6248 | 63 | 0 | 36.60308176 | -121.069975 | 2021-07-08 04:21:26 | San Benito, California, US | |
2021-07-07 | US | California | Tehama | 6103 | 5715 | 63 | 0 | 40.12570935 | -122.2370171 | 2021-07-08 04:21:26 | Tehama, California, US | |
2021-07-06 | US | California | Lake | 6033 | 3672 | 63 | 0 | 39.10124298 | -122.7536244 | 2021-07-07 04:21:20 | Lake, California, US | |
2021-07-06 | US | California | San Benito | 6069 | 6248 | 63 | 0 | 36.60308176 | -121.069975 | 2021-07-07 04:21:20 | San Benito, California, US | |
2021-07-06 | US | California | Tehama | 6103 | 5711 | 63 | 0 | 40.12570935 | -122.2370171 | 2021-07-07 04:21:20 | Tehama, California, US | |
2021-07-05 | US | California | Lake | 6033 | 3658 | 63 | 0 | 39.10124298 | -122.7536244 | 2021-07-06 04:21:32 | Lake, California, US | |
2021-07-05 | US | California | San Benito | 6069 | 6248 | 63 | 0 | 36.60308176 | -121.069975 | 2021-07-06 04:21:32 | San Benito, California, US | |
2021-07-05 | US | California | Tehama | 6103 | 5710 | 63 | 0 | 40.12570935 | -122.2370171 | 2021-07-06 04:21:32 | Tehama, California, US | |
2021-07-04 | US | California | San Benito | 6069 | 6219 | 63 | 0 | 36.60308176 | -121.069975 | 2021-07-05 04:21:28 | San Benito, California, US | |
2021-07-04 | US | California | Tehama | 6103 | 5709 | 63 | 0 | 40.12570935 | -122.2370171 | 2021-07-05 04:21:28 | Tehama, California, US | |
2021-07-03 | US | California | San Benito | 6069 | 6219 | 63 | 0 | 36.60308176 | -121.069975 | 2021-07-04 04:21:38 | San Benito, California, US | |
2021-07-03 | US | California | Tehama | 6103 | 5709 | 63 | 0 | 40.12570935 | -122.2370171 | 2021-07-04 04:21:38 | Tehama, California, US | |
2021-07-02 | US | California | San Benito | 6069 | 6219 | 63 | 0 | 36.60308176 | -121.069975 | 2021-07-03 04:21:37 | San Benito, California, US | |
2021-07-02 | US | California | Tehama | 6103 | 5707 | 63 | 0 | 40.12570935 | -122.2370171 | 2021-07-03 04:21:37 | Tehama, California, US | |
2021-07-01 | US | California | San Benito | 6069 | 6219 | 63 | 0 | 36.60308176 | -121.069975 | 2021-07-02 04:21:47 | San Benito, California, US | |
2021-07-01 | US | California | Tehama | 6103 | 5706 | 63 | 0 | 40.12570935 | -122.2370171 | 2021-07-02 04:21:47 | Tehama, California, US | |
2021-06-30 | US | California | San Benito | 6069 | 6216 | 63 | 0 | 36.60308176 | -121.069975 | 2021-07-01 04:21:19 | San Benito, California, US | |
2021-06-30 | US | California | Tehama | 6103 | 5706 | 63 | 0 | 40.12570935 | -122.2370171 | 2021-07-01 04:21:19 | Tehama, California, US | |
2021-06-29 | US | California | San Benito | 6069 | 6210 | 63 | 0 | 36.60308176 | -121.069975 | 2021-06-30 04:21:41 | San Benito, California, US | |
2021-06-29 | US | California | Tehama | 6103 | 5706 | 63 | 0 | 40.12570935 | -122.2370171 | 2021-06-30 04:21:41 | Tehama, California, US | |
2021-06-28 | US | California | San Benito | 6069 | 6212 | 63 | 0 | 36.60308176 | -121.069975 | 2021-06-29 04:21:28 | San Benito, California, US | |
2021-06-28 | US | California | Tehama | 6103 | 5704 | 63 | 0 | 40.12570935 | -122.2370171 | 2021-06-29 04:21:28 | Tehama, California, US | |
2021-06-27 | US | California | San Benito | 6069 | 6212 | 63 | 0 | 36.60308176 | -121.069975 | 2021-06-28 04:21:29 | San Benito, California, US | |
2021-06-27 | US | California | Tehama | 6103 | 5704 | 63 | 0 | 40.12570935 | -122.2370171 | 2021-06-28 04:21:29 | Tehama, California, US | |
2021-06-26 | US | California | San Benito | 6069 | 6211 | 63 | 0 | 36.60308176 | -121.069975 | 2021-06-27 04:21:39 | San Benito, California, US | |
2021-06-26 | US | California | Tehama | 6103 | 5701 | 63 | 0 | 40.12570935 | -122.2370171 | 2021-06-27 04:21:39 | Tehama, California, US | |
2021-06-25 | US | California | San Benito | 6069 | 6209 | 63 | 0 | 36.60308176 | -121.069975 | 2021-06-26 04:21:43 | San Benito, California, US | |
2021-06-25 | US | California | Tehama | 6103 | 5701 | 63 | 0 | 40.12570935 | -122.2370171 | 2021-06-26 04:21:43 | Tehama, California, US | |
2021-06-24 | US | California | San Benito | 6069 | 6209 | 63 | 0 | 36.60308176 | -121.069975 | 2021-06-25 04:21:33 | San Benito, California, US | |
2021-06-24 | US | California | Tehama | 6103 | 5697 | 63 | 0 | 40.12570935 | -122.2370171 | 2021-06-25 04:21:33 | Tehama, California, US | |
2021-06-23 | US | California | San Benito | 6069 | 6208 | 63 | 0 | 36.60308176 | -121.069975 | 2021-06-24 04:21:55 | San Benito, California, US | |
2021-06-23 | US | California | Tehama | 6103 | 5700 | 63 | 0 | 40.12570935 | -122.2370171 | 2021-06-24 04:21:55 | Tehama, California, US | |
2021-06-22 | US | California | San Benito | 6069 | 6209 | 63 | 0 | 36.60308176 | -121.069975 | 2021-06-23 04:21:46 | San Benito, California, US | |
2021-06-22 | US | California | Tehama | 6103 | 5698 | 63 | 0 | 40.12570935 | -122.2370171 | 2021-06-23 04:21:46 | Tehama, California, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;