johns_hopkins_csse_daily_reports
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: last_update (date)
day (date) >30 ✖
- 2021-09-16 60
- 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
- 2021-10-15 60
- …
province_or_state 1
- California · 59,941 ✖
country_or_region 1
- US 59,941
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude ▼ | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
808653 | 808653 | 2020-03-27 | US | California | Unassigned | 12 | 0 | 0 | 12 | 0.0 | 0.0 | 2020-03-27 22:14:55 | Unassigned, California, US | |
1872023 | 1872023 | 2020-03-30 | US | California | Unassigned | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 3/30/20 22:52 | Unassigned, California, US | |
2875264 | 2875264 | 2020-03-29 | US | California | Unassigned | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 3/29/20 23:08 | Unassigned, California, US | |
3364454 | 3364454 | 2020-04-01 | US | California | Unassigned | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-04-01 21:58:49 | Unassigned, California, US | |
3815550 | 3815550 | 2020-03-31 | US | California | Unassigned | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 2020-03-31 23:43:56 | Unassigned, California, US | |
905 | 905 | 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 | |
4920 | 4920 | 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 | |
8893 | 8893 | 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 |
12905 | 12905 | 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 |
16927 | 16927 | 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 | |
20938 | 20938 | 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 | |
24976 | 24976 | 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 | |
28991 | 28991 | 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 | |
32987 | 32987 | 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 | |
36997 | 36997 | 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 | |
42478 | 42478 | 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 |
44283 | 44283 | 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 | |
49567 | 49567 | 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 |
51359 | 51359 | 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 | |
55370 | 55370 | 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 | |
61040 | 61040 | 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 |
63641 | 63641 | 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 | |
67632 | 67632 | 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 | |
71666 | 71666 | 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 | |
75653 | 75653 | 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 |
79647 | 79647 | 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 |
83662 | 83662 | 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 | |
87700 | 87700 | 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 | |
91718 | 91718 | 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 | |
97370 | 97370 | 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 |
99901 | 99901 | 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 | |
103897 | 103897 | 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 | |
108021 | 108021 | 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 | |
113467 | 113467 | 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 |
115328 | 115328 | 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 | |
120964 | 120964 | 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 |
123268 | 123268 | 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 |
127308 | 127308 | 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 | |
131329 | 131329 | 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 | |
136700 | 136700 | 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 |
138546 | 138546 | 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 | |
142564 | 142564 | 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 | |
146530 | 146530 | 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 |
150559 | 150559 | 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 | |
154547 | 154547 | 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 |
158588 | 158588 | 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 | |
162603 | 162603 | 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 | |
166621 | 166621 | 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 | |
170611 | 170611 | 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 | |
176280 | 176280 | 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 |
178597 | 178597 | 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 | |
182605 | 182605 | 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 |
186646 | 186646 | 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 | |
190633 | 190633 | 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 |
194625 | 194625 | 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 |
198838 | 198838 | 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 | |
202820 | 202820 | 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 |
206812 | 206812 | 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 |
210802 | 210802 | 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 |
216319 | 216319 | 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 |
218559 | 218559 | 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 | |
222571 | 222571 | 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 | |
227952 | 227952 | 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 |
229803 | 229803 | 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 | |
233818 | 233818 | 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 | |
237805 | 237805 | 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 |
241822 | 241822 | 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 | |
245840 | 245840 | 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 | |
249854 | 249854 | 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 | |
253890 | 253890 | 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 | |
257909 | 257909 | 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 | |
262108 | 262108 | 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 | |
267565 | 267565 | 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 |
270916 | 270916 | 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 |
272718 | 272718 | 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 |
276758 | 276758 | 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 | |
280748 | 280748 | 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 |
286287 | 286287 | 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 |
288570 | 288570 | 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 | |
292592 | 292592 | 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 | |
296583 | 296583 | 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 | |
302150 | 302150 | 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 |
304444 | 304444 | 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 | |
308464 | 308464 | 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 | |
312480 | 312480 | 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 | |
316492 | 316492 | 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 | |
320512 | 320512 | 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 | |
326079 | 326079 | 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 |
328486 | 328486 | 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 | |
332477 | 332477 | 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 | |
336512 | 336512 | 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 | |
340840 | 340840 | 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 |
344833 | 344833 | 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 |
348876 | 348876 | 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 | |
352861 | 352861 | 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 | |
356902 | 356902 | 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 | |
360918 | 360918 | 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 | |
366491 | 366491 | 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 |
370436 | 370436 | 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 |
372776 | 372776 | 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 TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);