daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
59,941 rows where province_or_state = "California" sorted by latitude
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-03-27 | US | California | Unassigned | 12 | 0 | 0 | 12 | 0.0 | 0.0 | 2020-03-27 22:14:55 | Unassigned, California, US | |
2020-03-30 | US | California | Unassigned | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 3/30/20 22:52 | Unassigned, California, US | |
2020-03-29 | US | California | Unassigned | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 3/29/20 23:08 | Unassigned, California, US | |
2020-04-01 | US | California | Unassigned | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-04-01 21:58:49 | Unassigned, California, US | |
2020-03-31 | US | California | Unassigned | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 2020-03-31 23:43:56 | Unassigned, California, US | |
2021-12-02 | US | California | San Diego | 6073 | 408528 | 4346 | 0 | 33.03484597 | -116.73653259999999 | 2021-12-03 04:23:05 | San Diego, California, US | |
2021-10-28 | US | California | San Diego | 6073 | 391469 | 4207 | 0 | 33.03484597 | -116.73653259999999 | 2021-10-29 04:22:03 | San Diego, California, US | |
2020-10-25 | US | California | San Diego | 6073 | 56159 | 870 | 0 | 55289 | 33.03484597 | -116.7365326 | 2020-10-26 04:25:02 | San Diego, California, US |
2021-01-26 | US | California | San Diego | 6073 | 241397 | 2421 | 0 | 238976 | 33.03484597 | -116.7365326 | 2021-01-27 05:23:41 | San Diego, California, US |
2021-09-18 | US | California | San Diego | 6073 | 369327 | 4006 | 0 | 33.03484597 | -116.73653259999999 | 2021-09-19 04:21:34 | San Diego, California, US | |
2021-05-28 | US | California | San Diego | 6073 | 294992 | 3756 | 0 | 33.03484597 | -116.7365326 | 2021-05-29 04:20:41 | San Diego, California, US | |
2022-03-20 | US | California | San Diego | 6073 | 797794 | 5133 | 0 | 33.03484597 | -116.73653259999999 | 2022-03-21 04:20:50 | San Diego, California, US | |
2021-11-11 | US | California | San Diego | 6073 | 398272 | 4272 | 0 | 33.03484597 | -116.73653259999999 | 2021-11-12 04:22:01 | San Diego, California, US | |
2021-08-25 | US | California | San Diego | 6073 | 346447 | 3859 | 0 | 33.03484597 | -116.73653259999999 | 2021-08-26 04:21:28 | San Diego, California, US | |
2021-04-12 | US | California | San Diego | 6073 | 287405 | 3621 | 0 | 33.03484597 | -116.7365326 | 2021-04-13 04:20:37 | San Diego, California, US | |
2020-04-13 | US | California | San Diego | 6073 | 1847 | 45 | 0 | 1802 | 33.03484597 | -116.73653259999999 | 2020-04-13 23:07:54 | San Diego, California, US |
2021-11-02 | US | California | San Diego | 6073 | 393508 | 4232 | 0 | 33.03484597 | -116.73653259999999 | 2021-11-03 06:22:09 | San Diego, California, US | |
2020-04-17 | US | California | San Diego | 6073 | 2158 | 63 | 0 | 2095 | 33.03484597 | -116.73653259999999 | 2020-04-17 23:30:52 | San Diego, California, US |
2021-05-29 | US | California | San Diego | 6073 | 295111 | 3756 | 0 | 33.03484597 | -116.7365326 | 2021-05-30 04:20:55 | San Diego, California, US | |
2021-03-07 | US | California | San Diego | 6073 | 276061 | 3385 | 0 | 33.03484597 | -116.7365326 | 2021-03-08 05:24:48 | San Diego, California, US | |
2020-07-23 | US | California | San Diego | 6073 | 25110 | 512 | 0 | 24598 | 33.03484597 | -116.7365326 | 2020-07-24 05:30:40 | San Diego, California, US |
2022-11-12 | US | California | San Diego | 6073 | 1006956 | 5543 | 0 | 33.03484597 | -116.7365326 | 2022-11-13 04:21:14 | San Diego, California, US | |
2021-09-01 | US | California | San Diego | 6073 | 355020 | 3908 | 0 | 33.03484597 | -116.73653259999999 | 2021-09-02 04:21:15 | San Diego, California, US | |
2022-02-07 | US | California | San Diego | 6073 | 755534 | 4786 | 0 | 33.03484597 | -116.73653259999999 | 2022-02-08 04:21:15 | San Diego, California, US | |
2020-12-03 | US | California | San Diego | 6073 | 90010 | 1040 | 0 | 88970 | 33.03484597 | -116.7365326 | 2020-12-04 05:27:27 | San Diego, California, US |
2020-10-14 | US | California | San Diego | 6073 | 52670 | 844 | 0 | 51826 | 33.03484597 | -116.7365326 | 2020-10-15 04:24:28 | San Diego, California, US |
2021-05-25 | US | California | San Diego | 6073 | 294706 | 3753 | 0 | 33.03484597 | -116.7365326 | 2021-05-26 04:20:35 | San Diego, California, US | |
2021-11-09 | US | California | San Diego | 6073 | 397197 | 4259 | 0 | 33.03484597 | -116.73653259999999 | 2021-11-10 04:21:38 | San Diego, California, US | |
2022-07-23 | US | California | San Diego | 6073 | 935595 | 5387 | 0 | 33.03484597 | -116.7365326 | 2022-07-24 04:20:47 | San Diego, California, US | |
2020-08-04 | US | California | San Diego | 6073 | 30561 | 568 | 0 | 29993 | 33.03484597 | -116.7365326 | 2020-08-05 04:34:43 | San Diego, California, US |
2022-01-14 | US | California | San Diego | 6073 | 595420 | 4540 | 0 | 33.03484597 | -116.73653259999999 | 2022-01-15 04:21:07 | San Diego, California, US | |
2021-08-15 | US | California | San Diego | 6073 | 332613 | 3824 | 0 | 33.03484597 | -116.73653259999999 | 2021-08-16 04:21:31 | San Diego, California, US | |
2021-06-19 | US | California | San Diego | 6073 | 296904 | 3771 | 0 | 33.03484597 | -116.7365326 | 2021-06-20 04:21:48 | San Diego, California, US | |
2020-05-08 | US | California | San Diego | 6073 | 4662 | 165 | 0 | 4497 | 33.03484597 | -116.7365326 | 2020-05-09 02:32:35 | San Diego, California, US |
2022-09-06 | US | California | San Diego | 6073 | 984681 | 5468 | 0 | 33.03484597 | -116.7365326 | 2022-09-07 04:20:59 | San Diego, California, US | |
2020-07-19 | US | California | San Diego | 6073 | 23684 | 478 | 0 | 23206 | 33.03484597 | -116.7365326 | 2020-07-20 05:34:40 | San Diego, California, US |
2020-11-18 | US | California | San Diego | 6073 | 69757 | 945 | 0 | 68812 | 33.03484597 | -116.7365326 | 2020-11-19 05:25:23 | San Diego, California, US |
2022-01-09 | US | California | San Diego | 6073 | 498384 | 4495 | 0 | 33.03484597 | -116.73653259999999 | 2022-01-10 04:22:07 | San Diego, California, US | |
2022-10-04 | US | California | San Diego | 6073 | 993465 | 5491 | 0 | 33.03484597 | -116.7365326 | 2022-10-05 04:23:06 | San Diego, California, US | |
2020-04-29 | US | California | San Diego | 6073 | 3432 | 120 | 0 | 3312 | 33.03484597 | -116.73653259999999 | 2020-04-30 02:32:27 | San Diego, California, US |
2021-12-04 | US | California | San Diego | 6073 | 409182 | 4350 | 0 | 33.03484597 | -116.73653259999999 | 2021-12-05 04:22:25 | San Diego, California, US | |
2022-07-09 | US | California | San Diego | 6073 | 906609 | 5357 | 0 | 33.03484597 | -116.7365326 | 2022-07-10 04:20:54 | San Diego, California, US | |
2020-08-15 | US | California | San Diego | 6073 | 34527 | 622 | 0 | 33905 | 33.03484597 | -116.7365326 | 2020-08-16 04:27:42 | San Diego, California, US |
2021-11-29 | US | California | San Diego | 6073 | 405099 | 4325 | 0 | 33.03484597 | -116.73653259999999 | 2021-11-30 04:22:53 | San Diego, California, US | |
2021-01-08 | US | California | San Diego | 6073 | 194472 | 1771 | 0 | 192701 | 33.03484597 | -116.7365326 | 2021-01-09 05:22:18 | San Diego, California, US |
2022-03-29 | US | California | San Diego | 6073 | 801703 | 5155 | 0 | 33.03484597 | -116.73653259999999 | 2022-03-30 04:20:45 | San Diego, California, US | |
2021-11-19 | US | California | San Diego | 6073 | 402221 | 4311 | 0 | 33.03484597 | -116.73653259999999 | 2021-11-20 04:22:17 | San Diego, California, US | |
2022-06-21 | US | California | San Diego | 6073 | 873486 | 5318 | 0 | 33.03484597 | -116.7365326 | 2022-06-22 04:20:54 | San Diego, California, US | |
2021-04-16 | US | California | San Diego | 6073 | 288693 | 3662 | 0 | 33.03484597 | -116.7365326 | 2021-04-17 04:20:40 | San Diego, California, US | |
2020-07-27 | US | California | San Diego | 6073 | 27511 | 533 | 0 | 26978 | 33.03484597 | -116.7365326 | 2020-07-28 04:58:43 | San Diego, California, US |
2021-09-02 | US | California | San Diego | 6073 | 356148 | 3909 | 0 | 33.03484597 | -116.73653259999999 | 2021-09-03 04:21:20 | San Diego, California, US | |
2021-02-21 | US | California | San Diego | 6073 | 269709 | 3190 | 0 | 266519 | 33.03484597 | -116.7365326 | 2021-02-22 05:24:21 | San Diego, California, US |
2022-02-13 | US | California | San Diego | 6073 | 766947 | 4854 | 0 | 33.03484597 | -116.73653259999999 | 2022-02-14 04:20:51 | San Diego, California, US | |
2021-01-11 | US | California | San Diego | 6073 | 204585 | 1857 | 0 | 202728 | 33.03484597 | -116.7365326 | 2021-01-12 05:22:15 | San Diego, California, US |
2020-08-31 | US | California | San Diego | 6073 | 39103 | 682 | 0 | 38421 | 33.03484597 | -116.7365326 | 2020-09-01 04:28:31 | San Diego, California, US |
2022-10-19 | US | California | San Diego | 6073 | 998737 | 5507 | 0 | 33.03484597 | -116.7365326 | 2022-10-20 04:22:59 | San Diego, California, US | |
2020-12-25 | US | California | San Diego | 6073 | 146837 | 1402 | 0 | 145435 | 33.03484597 | -116.7365326 | 2020-12-26 05:22:28 | San Diego, California, US |
2020-08-19 | US | California | San Diego | 6073 | 35636 | 638 | 0 | 34998 | 33.03484597 | -116.7365326 | 2020-08-20 04:27:43 | San Diego, California, US |
2020-10-29 | US | California | San Diego | 6073 | 57598 | 885 | 0 | 56713 | 33.03484597 | -116.7365326 | 2020-10-30 04:24:49 | San Diego, California, US |
2020-06-08 | US | California | San Diego | 6073 | 8619 | 296 | 0 | 8323 | 33.03484597 | -116.7365326 | 2020-06-09 03:33:03 | San Diego, California, US |
2022-12-26 | US | California | San Diego | 6073 | 1034654 | 5626 | 0 | 33.03484597 | -116.7365326 | 2022-12-27 04:21:07 | San Diego, California, US | |
2022-05-09 | US | California | San Diego | 6073 | 818936 | 5244 | 0 | 33.03484597 | -116.7365326 | 2022-05-10 04:20:50 | San Diego, California, US | |
2020-04-30 | US | California | San Diego | 6073 | 3564 | 120 | 0 | 3444 | 33.03484597 | -116.73653259999999 | 2020-05-01 02:32:28 | San Diego, California, US |
2022-05-31 | US | California | San Diego | 6073 | 847261 | 5292 | 0 | 33.03484597 | -116.7365326 | 2022-06-01 04:20:55 | San Diego, California, US | |
2022-02-11 | US | California | San Diego | 6073 | 766947 | 4854 | 0 | 33.03484597 | -116.73653259999999 | 2022-02-12 04:21:06 | San Diego, California, US | |
2021-01-18 | US | California | San Diego | 6073 | 224894 | 2103 | 0 | 222791 | 33.03484597 | -116.7365326 | 2021-01-19 05:22:15 | San Diego, California, US |
2021-04-02 | US | California | San Diego | 6073 | 284672 | 3568 | 0 | 33.03484597 | -116.7365326 | 2021-04-03 04:20:44 | San Diego, California, US | |
2021-08-17 | US | California | San Diego | 6073 | 335675 | 3824 | 0 | 33.03484597 | -116.73653259999999 | 2021-08-18 04:21:35 | San Diego, California, US | |
2021-09-04 | US | California | San Diego | 6073 | 358596 | 3914 | 0 | 33.03484597 | -116.73653259999999 | 2021-09-05 04:21:33 | San Diego, California, US | |
2022-09-08 | US | California | San Diego | 6073 | 984681 | 5474 | 0 | 33.03484597 | -116.7365326 | 2022-09-09 04:21:11 | San Diego, California, US | |
2022-12-10 | US | California | San Diego | 6073 | 1023491 | 5584 | 0 | 33.03484597 | -116.7365326 | 2022-12-11 04:20:50 | San Diego, California, US | |
2022-03-15 | US | California | San Diego | 6073 | 795115 | 5108 | 0 | 33.03484597 | -116.73653259999999 | 2022-03-16 04:20:50 | San Diego, California, US | |
2020-05-21 | US | California | San Diego | 6073 | 6315 | 230 | 0 | 6085 | 33.03484597 | -116.7365326 | 2020-05-22 02:36:51 | San Diego, California, US |
2020-04-28 | US | California | San Diego | 6073 | 3314 | 113 | 0 | 3201 | 33.03484597 | -116.7365326 | 2020-04-29 02:32:29 | San Diego, California, US |
2020-11-10 | US | California | San Diego | 6073 | 63175 | 915 | 0 | 62260 | 33.03484597 | -116.7365326 | 2020-11-11 05:25:30 | San Diego, California, US |
2021-11-03 | US | California | San Diego | 6073 | 393905 | 4232 | 0 | 33.03484597 | -116.73653259999999 | 2021-11-04 04:22:20 | San Diego, California, US | |
2021-02-24 | US | California | San Diego | 6073 | 271253 | 3230 | 0 | 268023 | 33.03484597 | -116.7365326 | 2021-02-25 05:24:57 | San Diego, California, US |
2020-06-15 | US | California | San Diego | 6073 | 9611 | 320 | 0 | 9291 | 33.03484597 | -116.7365326 | 2020-06-16 04:33:09 | San Diego, California, US |
2021-10-31 | US | California | San Diego | 6073 | 391471 | 4213 | 0 | 33.03484597 | -116.73653259999999 | 2021-11-01 04:22:01 | San Diego, California, US | |
2022-11-15 | US | California | San Diego | 6073 | 1006956 | 5543 | 0 | 33.03484597 | -116.7365326 | 2022-11-16 04:21:09 | San Diego, California, US | |
2021-07-15 | US | California | San Diego | 6073 | 301908 | 3786 | 0 | 33.03484597 | -116.7365326 | 2021-07-16 04:21:22 | San Diego, California, US | |
2020-07-01 | US | California | San Diego | 6073 | 14624 | 370 | 0 | 14254 | 33.03484597 | -116.7365326 | 2020-07-02 04:33:46 | San Diego, California, US |
2022-04-16 | US | California | San Diego | 6073 | 808047 | 5229 | 0 | 33.03484597 | -116.73653259999999 | 2022-04-17 04:20:59 | San Diego, California, US | |
2022-12-13 | US | California | San Diego | 6073 | 1023491 | 5584 | 0 | 33.03484597 | -116.7365326 | 2022-12-14 04:21:04 | San Diego, California, US | |
2022-11-13 | US | California | San Diego | 6073 | 1006956 | 5543 | 0 | 33.03484597 | -116.7365326 | 2022-11-14 04:21:09 | San Diego, California, US | |
2022-02-12 | US | California | San Diego | 6073 | 766947 | 4854 | 0 | 33.03484597 | -116.73653259999999 | 2022-02-13 04:21:00 | San Diego, California, US | |
2022-10-30 | US | California | San Diego | 6073 | 1002442 | 5524 | 0 | 33.03484597 | -116.7365326 | 2022-10-31 04:21:36 | San Diego, California, US | |
2020-07-20 | US | California | San Diego | 6073 | 24137 | 478 | 0 | 23659 | 33.03484597 | -116.73653259999999 | 2020-07-21 04:38:46 | San Diego, California, US |
2022-12-27 | US | California | San Diego | 6073 | 1034654 | 5626 | 0 | 33.03484597 | -116.7365326 | 2022-12-28 04:21:04 | San Diego, California, US | |
2021-08-04 | US | California | San Diego | 6073 | 318644 | 3805 | 0 | 33.03484597 | -116.7365326 | 2021-08-05 04:21:51 | San Diego, California, US | |
2022-03-18 | US | California | San Diego | 6073 | 797794 | 5133 | 0 | 33.03484597 | -116.73653259999999 | 2022-03-19 04:20:47 | San Diego, California, US | |
2021-02-03 | US | California | San Diego | 6073 | 253041 | 2683 | 0 | 250358 | 33.03484597 | -116.7365326 | 2021-02-04 05:22:26 | San Diego, California, US |
2020-09-14 | US | California | San Diego | 6073 | 43642 | 734 | 0 | 42908 | 33.03484597 | -116.7365326 | 2020-09-15 03:22:50 | San Diego, California, US |
2022-12-14 | US | California | San Diego | 6073 | 1023491 | 5584 | 0 | 33.03484597 | -116.7365326 | 2022-12-15 04:20:58 | San Diego, California, US | |
2021-03-11 | US | California | San Diego | 6073 | 277692 | 3422 | 0 | 33.03484597 | -116.7365326 | 2021-03-12 05:26:50 | San Diego, California, US | |
2022-03-11 | US | California | San Diego | 6073 | 793986 | 5090 | 0 | 33.03484597 | -116.73653259999999 | 2022-03-12 04:20:50 | San Diego, California, US | |
2022-05-07 | US | California | San Diego | 6073 | 818936 | 5244 | 0 | 33.03484597 | -116.7365326 | 2022-05-08 04:20:49 | San Diego, California, US | |
2020-07-16 | US | California | San Diego | 6073 | 21857 | 465 | 0 | 21392 | 33.03484597 | -116.7365326 | 2020-07-17 04:34:50 | San Diego, California, US |
2020-08-08 | US | California | San Diego | 6073 | 32413 | 586 | 0 | 31827 | 33.03484597 | -116.7365326 | 2020-08-09 04:34:54 | San Diego, California, US |
2022-09-13 | US | California | San Diego | 6073 | 986145 | 5474 | 0 | 33.03484597 | -116.7365326 | 2022-09-14 04:20:44 | San Diego, California, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;