daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
59,941 rows where province_or_state = "California" sorted by longitude
This data as json, yaml, Notebook, copyable, CSV (advanced)
last_update (date) >30 ✖
- 2022-04-13 120
- 2022-05-26 120
- 2021-09-17 60
- 2021-09-18 60
- 2021-09-19 60
- 2021-09-20 60
- 2021-09-21 60
- 2021-09-22 60
- 2021-09-23 60
- 2021-09-24 60
- 2021-09-25 60
- 2021-09-26 60
- 2021-09-27 60
- 2021-09-28 60
- 2021-09-29 60
- 2021-09-30 60
- 2021-10-01 60
- 2021-10-02 60
- 2021-10-03 60
- 2021-10-04 60
- 2021-10-05 60
- 2021-10-06 60
- 2021-10-07 60
- 2021-10-08 60
- 2021-10-09 60
- 2021-10-10 60
- 2021-10-11 60
- 2021-10-12 60
- 2021-10-13 60
- 2021-10-14 60
- …
province_or_state 1
- California · 59,941 ✖
country_or_region 1
- US 59,941
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude ▼ | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-04-09 | US | California | Imperial | 6025 | 30342 | 717 | 0 | 33.0393082 | -115.3669042 | 2021-04-10 04:20:59 | Imperial, California, US | |
2020-08-29 | US | California | Imperial | 6025 | 9705 | 250 | 0 | 9453 | 33.0393082 | -115.3669042 | 2020-08-30 04:28:22 | Imperial, California, US |
2021-02-08 | US | California | Imperial | 6025 | 28904 | 567 | 0 | 28535 | 33.0393082 | -115.3669042 | 2021-02-09 05:23:30 | Imperial, California, US |
2022-11-05 | US | California | Imperial | 6025 | 82393 | 960 | 0 | 33.0393082 | -115.3669042 | 2022-11-06 04:21:24 | Imperial, California, US | |
2022-05-22 | US | California | Imperial | 6025 | 66804 | 923 | 0 | 33.0393082 | -115.3669042 | 2022-05-26 04:20:50 | Imperial, California, US | |
2021-07-10 | US | California | Imperial | 6025 | 31429 | 741 | 0 | 33.0393082 | -115.3669042 | 2021-07-11 04:21:43 | Imperial, California, US | |
2022-07-12 | US | California | Imperial | 6025 | 72787 | 944 | 0 | 33.0393082 | -115.3669042 | 2022-07-13 04:20:58 | Imperial, California, US | |
2021-03-31 | US | California | Imperial | 6025 | 30044 | 710 | 0 | 33.0393082 | -115.3669042 | 2021-04-01 04:27:05 | Imperial, California, US | |
2021-05-05 | US | California | Imperial | 6025 | 30940 | 720 | 0 | 33.0393082 | -115.3669042 | 2021-05-06 04:20:38 | Imperial, California, US | |
2022-05-13 | US | California | Imperial | 6025 | 66486 | 917 | 0 | 33.0393082 | -115.3669042 | 2022-05-14 04:20:48 | Imperial, California, US | |
2020-08-11 | US | California | Imperial | 6025 | 8525 | 165 | 0 | 8358 | 33.0393082 | -115.3669042 | 2020-08-12 04:27:29 | Imperial, California, US |
2020-09-16 | US | California | Imperial | 6025 | 10409 | 277 | 0 | 10129 | 33.0393082 | -115.3669042 | 2020-09-17 04:22:00 | Imperial, California, US |
2022-07-21 | US | California | Imperial | 6025 | 75261 | 944 | 0 | 33.0393082 | -115.3669042 | 2022-07-22 04:21:15 | Imperial, California, US | |
2022-07-30 | US | California | Imperial | 6025 | 76646 | 949 | 0 | 33.0393082 | -115.3669042 | 2022-07-31 04:21:02 | Imperial, California, US | |
2020-11-23 | US | California | Imperial | 6025 | 15185 | 355 | 0 | 14824 | 33.0393082 | -115.3669042 | 2020-11-24 05:27:31 | Imperial, California, US |
2022-12-23 | US | California | Imperial | 6025 | 86507 | 963 | 0 | 33.0393082 | -115.3669042 | 2022-12-24 04:21:02 | Imperial, California, US | |
2021-03-16 | US | California | Imperial | 6025 | 29646 | 689 | 0 | 33.0393082 | -115.3669042 | 2021-03-17 05:25:07 | Imperial, California, US | |
2022-11-01 | US | California | Imperial | 6025 | 82319 | 959 | 0 | 33.0393082 | -115.3669042 | 2022-11-02 04:22:09 | Imperial, California, US | |
2022-12-04 | US | California | Imperial | 6025 | 84619 | 960 | 0 | 33.0393082 | -115.3669042 | 2022-12-05 04:20:58 | Imperial, California, US | |
2021-05-22 | US | California | Imperial | 6025 | 31256 | 735 | 0 | 33.0393082 | -115.3669042 | 2021-05-23 04:20:51 | Imperial, California, US | |
2020-06-12 | US | California | Imperial | 6025 | 3547 | 36 | 0 | 3511 | 33.0393082 | -115.3669042 | 2020-06-13 03:33:14 | Imperial, California, US |
2020-12-02 | US | California | Imperial | 6025 | 16514 | 356 | 0 | 16166 | 33.0393082 | -115.3669042 | 2020-12-03 05:28:22 | Imperial, California, US |
2021-02-20 | US | California | Imperial | 6025 | 29186 | 590 | 0 | 28791 | 33.0393082 | -115.3669042 | 2021-02-21 05:24:33 | Imperial, California, US |
2020-08-01 | US | California | Imperial | 6025 | 7925 | 156 | 0 | 7767 | 33.0393082 | -115.3669042 | 2020-08-02 04:34:47 | Imperial, California, US |
2020-10-28 | US | California | Imperial | 6025 | 12749 | 333 | 0 | 12410 | 33.0393082 | -115.3669042 | 2020-10-29 04:24:49 | Imperial, California, US |
2020-10-18 | US | California | Imperial | 6025 | 12000 | 330 | 0 | 11665 | 33.0393082 | -115.3669042 | 2020-10-19 04:24:16 | Imperial, California, US |
2020-12-29 | US | California | Imperial | 6025 | 23479 | 407 | 0 | 23183 | 33.0393082 | -115.3669042 | 2020-12-30 05:22:34 | Imperial, California, US |
2021-01-12 | US | California | Imperial | 6025 | 26577 | 457 | 0 | 26275 | 33.0393082 | -115.3669042 | 2021-01-13 05:22:15 | Imperial, California, US |
2021-07-08 | US | California | Imperial | 6025 | 31427 | 741 | 0 | 33.0393082 | -115.3669042 | 2021-07-09 04:21:21 | Imperial, California, US | |
2020-10-15 | US | California | Imperial | 6025 | 11832 | 330 | 0 | 11497 | 33.0393082 | -115.3669042 | 2020-10-16 04:24:01 | Imperial, California, US |
2021-02-04 | US | California | Imperial | 6025 | 28780 | 556 | 0 | 28420 | 33.0393082 | -115.3669042 | 2021-02-05 05:22:38 | Imperial, California, US |
2022-10-24 | US | California | Imperial | 6025 | 81992 | 961 | 0 | 33.0393082 | -115.3669042 | 2022-10-25 04:21:53 | Imperial, California, US | |
2020-06-01 | US | California | Imperial | 6025 | 2370 | 14 | 0 | 2356 | 33.0393082 | -115.3669042 | 2020-06-02 02:33:08 | Imperial, California, US |
2020-09-05 | US | California | Imperial | 6025 | 10158 | 268 | 0 | 9888 | 33.0393082 | -115.3669042 | 2020-09-06 04:28:33 | Imperial, California, US |
2020-10-09 | US | California | Imperial | 6025 | 11526 | 330 | 0 | 11192 | 33.0393082 | -115.3669042 | 2020-10-10 04:23:57 | Imperial, California, US |
2020-11-19 | US | California | Imperial | 6025 | 14539 | 349 | 0 | 14183 | 33.0393082 | -115.3669042 | 2020-11-20 05:26:28 | Imperial, California, US |
2021-06-06 | US | California | Imperial | 6025 | 31455 | 738 | 0 | 33.0393082 | -115.3669042 | 2021-06-07 04:22:51 | Imperial, California, US | |
2021-07-09 | US | California | Imperial | 6025 | 31428 | 741 | 0 | 33.0393082 | -115.3669042 | 2021-07-10 04:21:25 | Imperial, California, US | |
2022-12-02 | US | California | Imperial | 6025 | 84582 | 960 | 0 | 33.0393082 | -115.3669042 | 2022-12-03 04:21:02 | Imperial, California, US | |
2020-08-17 | US | California | Imperial | 6025 | 8904 | 188 | 0 | 8714 | 33.0393082 | -115.3669042 | 2020-08-18 04:27:56 | Imperial, California, US |
2020-07-22 | US | California | Imperial | 6025 | 7538 | 134 | 0 | 7403 | 33.0393082 | -115.3669042 | 2020-07-23 05:15:04 | Imperial, California, US |
2020-12-12 | US | California | Imperial | 6025 | 19302 | 379 | 0 | 18946 | 33.0393082 | -115.3669042 | 2020-12-13 05:27:20 | Imperial, California, US |
2022-11-02 | US | California | Imperial | 6025 | 82327 | 959 | 0 | 33.0393082 | -115.3669042 | 2022-11-03 04:22:05 | Imperial, California, US | |
2022-09-30 | US | California | Imperial | 6025 | 81292 | 958 | 0 | 33.0393082 | -115.3669042 | 2022-10-01 04:23:01 | Imperial, California, US | |
2020-12-11 | US | California | Imperial | 6025 | 18910 | 377 | 0 | 18554 | 33.0393082 | -115.3669042 | 2020-12-12 05:26:19 | Imperial, California, US |
2020-11-12 | US | California | Imperial | 6025 | 13647 | 341 | 0 | 13300 | 33.0393082 | -115.3669042 | 2020-11-13 05:25:30 | Imperial, California, US |
2022-12-11 | US | California | Imperial | 6025 | 85606 | 962 | 0 | 33.0393082 | -115.3669042 | 2022-12-12 04:21:01 | Imperial, California, US | |
2020-05-24 | US | California | Imperial | 6025 | 1373 | 14 | 0 | 1359 | 33.0393082 | -115.3669042 | 2020-05-25 02:32:44 | Imperial, California, US |
2022-08-05 | US | California | Imperial | 6025 | 77695 | 949 | 0 | 33.0393082 | -115.3669042 | 2022-08-06 04:20:56 | Imperial, California, US | |
2020-07-07 | US | California | Imperial | 6025 | 6682 | 51 | 0 | 6631 | 33.0393082 | -115.3669042 | 2020-07-08 05:33:48 | Imperial, California, US |
2021-04-26 | US | California | Imperial | 6025 | 30764 | 720 | 0 | 33.0393082 | -115.3669042 | 2021-04-27 04:20:52 | Imperial, California, US | |
2020-11-05 | US | California | Imperial | 6025 | 13201 | 337 | 0 | 12858 | 33.0393082 | -115.3669042 | 2020-11-06 05:24:55 | Imperial, California, US |
2022-07-24 | US | California | Imperial | 6025 | 75410 | 948 | 0 | 33.0393082 | -115.3669042 | 2022-07-25 04:20:51 | Imperial, California, US | |
2022-07-22 | US | California | Imperial | 6025 | 75357 | 948 | 0 | 33.0393082 | -115.3669042 | 2022-07-23 04:20:53 | Imperial, California, US | |
2021-01-19 | US | California | Imperial | 6025 | 27525 | 452 | 0 | 27248 | 33.0393082 | -115.3669042 | 2021-01-20 05:21:54 | Imperial, California, US |
2022-10-29 | US | California | Imperial | 6025 | 82142 | 959 | 0 | 33.0393082 | -115.3669042 | 2022-10-30 04:22:14 | Imperial, California, US | |
2020-11-26 | US | California | Imperial | 6025 | 15814 | 355 | 0 | 15457 | 33.0393082 | -115.3669042 | 2020-11-27 05:26:53 | Imperial, California, US |
2020-12-21 | US | California | Imperial | 6025 | 22000 | 395 | 0 | 21696 | 33.0393082 | -115.3669042 | 2020-12-22 05:22:33 | Imperial, California, US |
2022-06-25 | US | California | Imperial | 6025 | 69713 | 944 | 0 | 33.0393082 | -115.3669042 | 2022-06-26 04:21:02 | Imperial, California, US | |
2022-06-14 | US | California | Imperial | 6025 | 68634 | 941 | 0 | 33.0393082 | -115.3669042 | 2022-06-15 04:20:54 | Imperial, California, US | |
2021-04-25 | US | California | Imperial | 6025 | 30750 | 720 | 0 | 33.0393082 | -115.3669042 | 2021-04-26 04:21:04 | Imperial, California, US | |
2022-07-19 | US | California | Imperial | 6025 | 74575 | 944 | 0 | 33.0393082 | -115.3669042 | 2022-07-20 04:20:59 | Imperial, California, US | |
2022-09-09 | US | California | Imperial | 6025 | 80529 | 956 | 0 | 33.0393082 | -115.3669042 | 2022-09-10 04:21:10 | Imperial, California, US | |
2020-09-29 | US | California | Imperial | 6025 | 10820 | 283 | 0 | 10534 | 33.0393082 | -115.3669042 | 2020-09-30 04:23:33 | Imperial, California, US |
2022-06-01 | US | California | Imperial | 6025 | 67390 | 938 | 0 | 33.0393082 | -115.3669042 | 2022-06-02 05:20:39 | Imperial, California, US | |
2021-02-06 | US | California | Imperial | 6025 | 28886 | 567 | 0 | 28515 | 33.0393082 | -115.3669042 | 2021-02-07 05:23:00 | Imperial, California, US |
2021-04-17 | US | California | Imperial | 6025 | 30586 | 719 | 0 | 33.0393082 | -115.3669042 | 2021-04-18 04:20:41 | Imperial, California, US | |
2022-08-16 | US | California | Imperial | 6025 | 78933 | 950 | 0 | 33.0393082 | -115.3669042 | 2022-08-17 04:20:59 | Imperial, California, US | |
2020-05-23 | US | California | Imperial | 6025 | 1287 | 14 | 0 | 1273 | 33.0393082 | -115.3669042 | 2020-05-24 02:32:43 | Imperial, California, US |
2021-03-01 | US | California | Imperial | 6025 | 29359 | 636 | 0 | 28922 | 33.0393082 | -115.3669042 | 2021-03-02 05:23:30 | Imperial, California, US |
2020-07-09 | US | California | Imperial | 6025 | 6782 | 87 | 0 | 6695 | 33.0393082 | -115.3669042 | 2020-07-10 04:34:24 | Imperial, California, US |
2020-12-06 | US | California | Imperial | 6025 | 17096 | 364 | 0 | 16742 | 33.0393082 | -115.3669042 | 2020-12-07 05:26:14 | Imperial, California, US |
2020-12-30 | US | California | Imperial | 6025 | 23554 | 412 | 0 | 23261 | 33.0393082 | -115.3669042 | 2020-12-31 05:22:49 | Imperial, California, US |
2022-12-24 | US | California | Imperial | 6025 | 86507 | 963 | 0 | 33.0393082 | -115.3669042 | 2022-12-25 04:21:04 | Imperial, California, US | |
2022-11-04 | US | California | Imperial | 6025 | 82385 | 960 | 0 | 33.0393082 | -115.3669042 | 2022-11-05 04:21:52 | Imperial, California, US | |
2020-10-17 | US | California | Imperial | 6025 | 11975 | 330 | 0 | 11640 | 33.0393082 | -115.3669042 | 2020-10-18 04:24:25 | Imperial, California, US |
2020-12-15 | US | California | Imperial | 6025 | 20360 | 380 | 0 | 20036 | 33.0393082 | -115.3669042 | 2020-12-16 05:28:04 | Imperial, California, US |
2020-05-26 | US | California | Imperial | 6025 | 1373 | 14 | 0 | 1359 | 33.0393082 | -115.3669042 | 2020-05-27 02:32:31 | Imperial, California, US |
2020-10-07 | US | California | Imperial | 6025 | 11298 | 330 | 0 | 10965 | 33.0393082 | -115.3669042 | 2020-10-08 04:23:56 | Imperial, California, US |
2020-09-30 | US | California | Imperial | 6025 | 10877 | 287 | 0 | 10587 | 33.0393082 | -115.3669042 | 2020-10-01 04:23:42 | Imperial, California, US |
2022-11-06 | US | California | Imperial | 6025 | 82405 | 960 | 0 | 33.0393082 | -115.3669042 | 2022-11-07 04:21:26 | Imperial, California, US | |
2020-10-23 | US | California | Imperial | 6025 | 12413 | 333 | 0 | 12075 | 33.0393082 | -115.3669042 | 2020-10-24 04:24:46 | Imperial, California, US |
2021-01-04 | US | California | Imperial | 6025 | 24745 | 420 | 0 | 24464 | 33.0393082 | -115.3669042 | 2021-01-05 05:21:49 | Imperial, California, US |
2022-07-28 | US | California | Imperial | 6025 | 76554 | 948 | 0 | 33.0393082 | -115.3669042 | 2022-07-29 04:20:45 | Imperial, California, US | |
2022-08-07 | US | California | Imperial | 6025 | 77762 | 949 | 0 | 33.0393082 | -115.3669042 | 2022-08-08 04:21:08 | Imperial, California, US | |
2022-12-28 | US | California | Imperial | 6025 | 86726 | 963 | 0 | 33.0393082 | -115.3669042 | 2022-12-29 04:21:01 | Imperial, California, US | |
2021-05-14 | US | California | Imperial | 6025 | 31159 | 728 | 0 | 33.0393082 | -115.3669042 | 2021-05-15 04:20:58 | Imperial, California, US | |
2022-08-09 | US | California | Imperial | 6025 | 78237 | 949 | 0 | 33.0393082 | -115.3669042 | 2022-08-10 04:20:57 | Imperial, California, US | |
2021-03-03 | US | California | Imperial | 6025 | 29395 | 640 | 0 | 28954 | 33.0393082 | -115.3669042 | 2021-03-04 05:24:24 | Imperial, California, US |
2021-01-20 | US | California | Imperial | 6025 | 27589 | 461 | 0 | 27305 | 33.0393082 | -115.3669042 | 2021-01-21 05:22:01 | Imperial, California, US |
2022-08-03 | US | California | Imperial | 6025 | 77276 | 949 | 0 | 33.0393082 | -115.3669042 | 2022-08-04 04:20:58 | Imperial, California, US | |
2020-05-25 | US | California | Imperial | 6025 | 1373 | 14 | 0 | 1359 | 33.0393082 | -115.3669042 | 2020-05-26 02:32:35 | Imperial, California, US |
2020-09-02 | US | California | Imperial | 6025 | 9839 | 255 | 0 | 9582 | 33.0393082 | -115.3669042 | 2020-09-03 04:28:22 | Imperial, California, US |
2022-05-21 | US | California | Imperial | 6025 | 66802 | 923 | 0 | 33.0393082 | -115.3669042 | 2022-05-22 04:20:52 | Imperial, California, US | |
2021-08-06 | US | California | Imperial | 6025 | 32139 | 745 | 0 | 33.0393082 | -115.3669042 | 2021-08-07 04:21:30 | Imperial, California, US | |
2020-09-17 | US | California | Imperial | 6025 | 10444 | 281 | 0 | 10160 | 33.0393082 | -115.3669042 | 2020-09-18 05:05:00 | Imperial, California, US |
2021-06-18 | US | California | Imperial | 6025 | 31502 | 740 | 0 | 33.0393082 | -115.3669042 | 2021-06-19 04:22:33 | Imperial, California, US | |
2020-06-26 | US | California | Imperial | 6025 | 5404 | 44 | 0 | 5360 | 33.0393082 | -115.3669042 | 2020-06-27 04:33:35 | Imperial, California, US |
2021-01-01 | US | California | Imperial | 6025 | 24264 | 418 | 0 | 23967 | 33.0393082 | -115.3669042 | 2021-01-02 05:22:33 | Imperial, California, US |
2022-12-12 | US | California | Imperial | 6025 | 85689 | 962 | 0 | 33.0393082 | -115.3669042 | 2022-12-13 04:21:01 | Imperial, California, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;