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)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude ▼ | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
376745 | 376745 | 2020-11-06 | US | California | San Diego | 6073 | 61085 | 907 | 0 | 60178 | 33.03484597 | -116.7365326 | 2020-11-07 05:24:52 | San Diego, California, US |
380760 | 380760 | 2021-04-30 | US | California | San Diego | 6073 | 290651 | 3702 | 0 | 33.03484597 | -116.7365326 | 2021-05-01 04:20:47 | San Diego, California, US | |
384803 | 384803 | 2022-09-23 | US | California | San Diego | 6073 | 991029 | 5487 | 0 | 33.03484597 | -116.7365326 | 2022-09-24 04:21:40 | San Diego, California, US | |
388790 | 388790 | 2021-04-04 | US | California | San Diego | 6073 | 285207 | 3571 | 0 | 33.03484597 | -116.7365326 | 2021-04-05 04:20:35 | San Diego, California, US | |
392799 | 392799 | 2020-11-27 | US | California | San Diego | 6073 | 81351 | 996 | 0 | 80355 | 33.03484597 | -116.7365326 | 2020-11-28 05:25:50 | San Diego, California, US |
396844 | 396844 | 2022-10-07 | US | California | San Diego | 6073 | 996765 | 5498 | 0 | 33.03484597 | -116.7365326 | 2022-10-08 04:22:56 | San Diego, California, US | |
400835 | 400835 | 2021-06-29 | US | California | San Diego | 6073 | 297919 | 3780 | 0 | 33.03484597 | -116.7365326 | 2021-06-30 04:21:41 | San Diego, California, US | |
404869 | 404869 | 2021-12-07 | US | California | San Diego | 6073 | 410451 | 4351 | 0 | 33.03484597 | -116.73653259999999 | 2021-12-08 04:22:46 | San Diego, California, US | |
408865 | 408865 | 2021-07-28 | US | California | San Diego | 6073 | 311273 | 3798 | 0 | 33.03484597 | -116.7365326 | 2021-07-29 04:21:33 | San Diego, California, US | |
414438 | 414438 | 2020-07-05 | US | California | San Diego | 6073 | 16728 | 387 | 0 | 16341 | 33.03484597 | -116.7365326 | 2020-07-06 04:33:57 | San Diego, California, US |
418094 | 418094 | 2020-04-18 | US | California | San Diego | 6073 | 2213 | 70 | 0 | 2143 | 33.03484597 | -116.7365326 | 2020-04-18 22:32:47 | San Diego, California, US |
419915 | 419915 | 2022-09-18 | US | California | San Diego | 6073 | 987866 | 5483 | 0 | 33.03484597 | -116.7365326 | 2022-09-19 04:21:49 | San Diego, California, US | |
423925 | 423925 | 2021-10-10 | US | California | San Diego | 6073 | 382110 | 4113 | 0 | 33.03484597 | -116.73653259999999 | 2021-10-11 04:21:31 | San Diego, California, US | |
427894 | 427894 | 2020-09-07 | US | California | San Diego | 6073 | 41493 | 707 | 0 | 40786 | 33.03484597 | -116.7365326 | 2020-09-08 04:28:25 | San Diego, California, US |
431937 | 431937 | 2022-11-03 | US | California | San Diego | 6073 | 1004205 | 5532 | 0 | 33.03484597 | -116.7365326 | 2022-11-04 04:22:11 | San Diego, California, US | |
435921 | 435921 | 2021-01-21 | US | California | San Diego | 6073 | 230616 | 2222 | 0 | 228394 | 33.03484597 | -116.7365326 | 2021-01-22 05:22:10 | San Diego, California, US |
441593 | 441593 | 2020-07-26 | US | California | San Diego | 6073 | 26987 | 533 | 0 | 26454 | 33.03484597 | -116.7365326 | 2020-07-27 04:35:02 | San Diego, California, US |
443929 | 443929 | 2021-10-20 | US | California | San Diego | 6073 | 387054 | 4178 | 0 | 33.03484597 | -116.73653259999999 | 2021-10-21 04:21:18 | San Diego, California, US | |
447946 | 447946 | 2021-11-17 | US | California | San Diego | 6073 | 401279 | 4287 | 0 | 33.03484597 | -116.73653259999999 | 2021-11-18 04:21:33 | San Diego, California, US | |
451967 | 451967 | 2022-12-21 | US | California | San Diego | 6073 | 1029152 | 5608 | 0 | 33.03484597 | -116.7365326 | 2022-12-22 04:20:56 | San Diego, California, US | |
457620 | 457620 | 2020-08-07 | US | California | San Diego | 6073 | 31859 | 583 | 0 | 31276 | 33.03484597 | -116.7365326 | 2020-08-08 04:34:53 | San Diego, California, US |
459955 | 459955 | 2022-02-02 | US | California | San Diego | 6073 | 744053 | 4710 | 0 | 33.03484597 | -116.73653259999999 | 2022-02-03 04:21:21 | San Diego, California, US | |
463972 | 463972 | 2022-05-02 | US | California | San Diego | 6073 | 814292 | 5238 | 0 | 33.03484597 | -116.7365326 | 2022-05-03 04:21:00 | San Diego, California, US | |
467986 | 467986 | 2021-10-07 | US | California | San Diego | 6073 | 380931 | 4111 | 0 | 33.03484597 | -116.73653259999999 | 2021-10-08 04:21:25 | San Diego, California, US | |
471977 | 471977 | 2021-02-19 | US | California | San Diego | 6073 | 268429 | 3169 | 0 | 265260 | 33.03484597 | -116.7365326 | 2021-02-20 05:22:51 | San Diego, California, US |
476019 | 476019 | 2022-06-26 | US | California | San Diego | 6073 | 883070 | 5332 | 0 | 33.03484597 | -116.7365326 | 2022-06-27 04:21:00 | San Diego, California, US | |
480170 | 480170 | 2022-11-08 | US | California | San Diego | 6073 | 1004519 | 5532 | 0 | 33.03484597 | -116.7365326 | 2022-11-09 04:21:22 | San Diego, California, US | |
484161 | 484161 | 2021-07-19 | US | California | San Diego | 6073 | 304179 | 3786 | 0 | 33.03484597 | -116.7365326 | 2021-07-20 04:21:48 | San Diego, California, US | |
488200 | 488200 | 2022-11-25 | US | California | San Diego | 6073 | 1012391 | 5562 | 0 | 33.03484597 | -116.7365326 | 2022-11-26 04:21:11 | San Diego, California, US | |
492210 | 492210 | 2021-10-14 | US | California | San Diego | 6073 | 384317 | 4151 | 0 | 33.03484597 | -116.73653259999999 | 2021-10-15 04:21:26 | San Diego, California, US | |
496227 | 496227 | 2021-11-06 | US | California | San Diego | 6073 | 395063 | 4246 | 0 | 33.03484597 | -116.73653259999999 | 2021-11-07 04:21:53 | San Diego, California, US | |
500244 | 500244 | 2022-04-02 | US | California | San Diego | 6073 | 803799 | 5178 | 0 | 33.03484597 | -116.73653259999999 | 2022-04-03 04:20:48 | San Diego, California, US | |
504264 | 504264 | 2022-12-17 | US | California | San Diego | 6073 | 1029152 | 5608 | 0 | 33.03484597 | -116.7365326 | 2022-12-18 04:21:03 | San Diego, California, US | |
508255 | 508255 | 2021-08-14 | US | California | San Diego | 6073 | 331887 | 3824 | 0 | 33.03484597 | -116.73653259999999 | 2021-08-15 04:21:41 | San Diego, California, US | |
512269 | 512269 | 2021-08-19 | US | California | San Diego | 6073 | 338361 | 3839 | 0 | 33.03484597 | -116.73653259999999 | 2021-08-20 04:21:33 | San Diego, California, US | |
516308 | 516308 | 2022-10-15 | US | California | San Diego | 6073 | 998737 | 5507 | 0 | 33.03484597 | -116.7365326 | 2022-10-16 04:22:39 | San Diego, California, US | |
521623 | 521623 | 2020-04-21 | US | California | San Diego | 6073 | 2434 | 72 | 0 | 2362 | 33.03484597 | -116.7365326 | 2020-04-21 23:30:50 | San Diego, California, US |
523425 | 523425 | 2021-06-09 | US | California | San Diego | 6073 | 296029 | 3765 | 0 | 33.03484597 | -116.7365326 | 2021-06-10 04:23:17 | San Diego, California, US | |
529001 | 529001 | 2020-07-04 | US | California | San Diego | 6073 | 16166 | 387 | 0 | 15779 | 33.03484597 | -116.7365326 | 2020-07-05 04:33:46 | San Diego, California, US |
531271 | 531271 | 2021-02-22 | US | California | San Diego | 6073 | 270076 | 3190 | 0 | 266886 | 33.03484597 | -116.7365326 | 2021-02-23 05:23:41 | San Diego, California, US |
535310 | 535310 | 2021-10-27 | US | California | San Diego | 6073 | 391042 | 4207 | 0 | 33.03484597 | -116.73653259999999 | 2021-10-28 04:22:08 | San Diego, California, US | |
539332 | 539332 | 2022-10-26 | US | California | San Diego | 6073 | 1000581 | 5517 | 0 | 33.03484597 | -116.7365326 | 2022-10-27 04:22:01 | San Diego, California, US | |
543348 | 543348 | 2022-12-15 | US | California | San Diego | 6073 | 1028340 | 5608 | 0 | 33.03484597 | -116.7365326 | 2022-12-16 04:21:01 | San Diego, California, US | |
547311 | 547311 | 2020-09-12 | US | California | San Diego | 6073 | 43125 | 734 | 0 | 42391 | 33.03484597 | -116.7365326 | 2020-09-13 04:30:52 | San Diego, California, US |
551349 | 551349 | 2021-12-08 | US | California | San Diego | 6073 | 413582 | 4357 | 0 | 33.03484597 | -116.73653259999999 | 2021-12-09 04:22:49 | San Diego, California, US | |
555365 | 555365 | 2022-01-16 | US | California | San Diego | 6073 | 595420 | 4540 | 0 | 33.03484597 | -116.73653259999999 | 2022-01-17 04:21:08 | San Diego, California, US | |
559383 | 559383 | 2022-06-16 | US | California | San Diego | 6073 | 868593 | 5318 | 0 | 33.03484597 | -116.7365326 | 2022-06-17 04:20:56 | San Diego, California, US | |
563537 | 563537 | 2021-06-22 | US | California | San Diego | 6073 | 297145 | 3771 | 0 | 33.03484597 | -116.7365326 | 2021-06-23 04:21:46 | San Diego, California, US | |
567678 | 567678 | 2021-10-29 | US | California | San Diego | 6073 | 391471 | 4213 | 0 | 33.03484597 | -116.73653259999999 | 2021-10-30 04:22:03 | San Diego, California, US | |
573173 | 573173 | 2020-06-06 | US | California | San Diego | 6073 | 8345 | 296 | 0 | 8049 | 33.03484597 | -116.7365326 | 2020-06-07 03:53:30 | San Diego, California, US |
575408 | 575408 | 2022-02-25 | US | California | San Diego | 6073 | 784349 | 5002 | 0 | 33.03484597 | -116.73653259999999 | 2022-02-26 04:21:12 | San Diego, California, US | |
579403 | 579403 | 2021-07-13 | US | California | San Diego | 6073 | 301046 | 3785 | 0 | 33.03484597 | -116.7365326 | 2021-07-14 04:21:35 | San Diego, California, US | |
583389 | 583389 | 2020-08-13 | US | California | San Diego | 6073 | 33817 | 608 | 0 | 33209 | 33.03484597 | -116.7365326 | 2020-08-14 04:51:19 | San Diego, California, US |
588461 | 588461 | 2020-04-05 | US | California | San Diego | 6073 | 1326 | 18 | 0 | 1308 | 33.03484597 | -116.73653259999999 | 2020-04-05 23:06:45 | San Diego, California, US |
590199 | 590199 | 2021-08-08 | US | California | San Diego | 6073 | 323752 | 3811 | 0 | 33.03484597 | -116.7365326 | 2021-08-09 04:21:24 | San Diego, California, US | |
594235 | 594235 | 2022-07-01 | US | California | San Diego | 6073 | 895480 | 5341 | 0 | 33.03484597 | -116.7365326 | 2022-07-02 04:21:16 | San Diego, California, US | |
598248 | 598248 | 2021-10-19 | US | California | San Diego | 6073 | 386612 | 4170 | 0 | 33.03484597 | -116.73653259999999 | 2021-10-20 04:21:00 | San Diego, California, US | |
602263 | 602263 | 2021-09-23 | US | California | San Diego | 6073 | 372625 | 4039 | 0 | 33.03484597 | -116.73653259999999 | 2021-09-24 04:21:44 | San Diego, California, US | |
606256 | 606256 | 2021-04-09 | US | California | San Diego | 6073 | 286552 | 3600 | 0 | 33.03484597 | -116.7365326 | 2021-04-10 04:20:59 | San Diego, California, US | |
610246 | 610246 | 2020-08-29 | US | California | San Diego | 6073 | 38507 | 679 | 0 | 37828 | 33.03484597 | -116.7365326 | 2020-08-30 04:28:22 | San Diego, California, US |
614253 | 614253 | 2021-02-08 | US | California | San Diego | 6073 | 259532 | 2821 | 0 | 256711 | 33.03484597 | -116.7365326 | 2021-02-09 05:23:30 | San Diego, California, US |
618442 | 618442 | 2022-11-05 | US | California | San Diego | 6073 | 1004519 | 5532 | 0 | 33.03484597 | -116.7365326 | 2022-11-06 04:21:24 | San Diego, California, US | |
622455 | 622455 | 2022-05-22 | US | California | San Diego | 6073 | 837288 | 5284 | 0 | 33.03484597 | -116.7365326 | 2022-05-26 04:20:50 | San Diego, California, US | |
626449 | 626449 | 2021-07-10 | US | California | San Diego | 6073 | 299412 | 3784 | 0 | 33.03484597 | -116.7365326 | 2021-07-11 04:21:43 | San Diego, California, US | |
630485 | 630485 | 2022-07-12 | US | California | San Diego | 6073 | 914120 | 5363 | 0 | 33.03484597 | -116.7365326 | 2022-07-13 04:20:58 | San Diego, California, US | |
634498 | 634498 | 2021-10-13 | US | California | San Diego | 6073 | 383751 | 4141 | 0 | 33.03484597 | -116.73653259999999 | 2021-10-14 04:21:29 | San Diego, California, US | |
638489 | 638489 | 2021-03-31 | US | California | San Diego | 6073 | 283858 | 3555 | 0 | 33.03484597 | -116.7365326 | 2021-04-01 04:27:05 | San Diego, California, US | |
642509 | 642509 | 2021-09-07 | US | California | San Diego | 6073 | 360711 | 3922 | 0 | 33.03484597 | -116.73653259999999 | 2021-09-08 04:21:31 | San Diego, California, US | |
646519 | 646519 | 2021-05-05 | US | California | San Diego | 6073 | 291693 | 3716 | 0 | 33.03484597 | -116.7365326 | 2021-05-06 04:20:38 | San Diego, California, US | |
650537 | 650537 | 2021-08-09 | US | California | San Diego | 6073 | 324718 | 3811 | 0 | 33.03484597 | -116.73653259999999 | 2021-08-10 04:21:27 | San Diego, California, US | |
654570 | 654570 | 2021-10-22 | US | California | San Diego | 6073 | 387470 | 4183 | 0 | 33.03484597 | -116.73653259999999 | 2021-10-23 04:21:32 | San Diego, California, US | |
658890 | 658890 | 2022-05-13 | US | California | San Diego | 6073 | 824523 | 5271 | 0 | 33.03484597 | -116.7365326 | 2022-05-14 04:20:48 | San Diego, California, US | |
662903 | 662903 | 2020-08-11 | US | California | San Diego | 6073 | 33276 | 594 | 0 | 32682 | 33.03484597 | -116.7365326 | 2020-08-12 04:27:29 | San Diego, California, US |
666836 | 666836 | 2020-09-16 | US | California | San Diego | 6073 | 44241 | 748 | 0 | 43493 | 33.03484597 | -116.7365326 | 2020-09-17 04:22:00 | San Diego, California, US |
670876 | 670876 | 2022-07-21 | US | California | San Diego | 6073 | 928479 | 5387 | 0 | 33.03484597 | -116.7365326 | 2022-07-22 04:21:15 | San Diego, California, US | |
674892 | 674892 | 2022-07-30 | US | California | San Diego | 6073 | 948173 | 5409 | 0 | 33.03484597 | -116.7365326 | 2022-07-31 04:21:02 | San Diego, California, US | |
678876 | 678876 | 2020-11-23 | US | California | San Diego | 6073 | 75707 | 968 | 0 | 74739 | 33.03484597 | -116.7365326 | 2020-11-24 05:27:31 | San Diego, California, US |
682915 | 682915 | 2021-10-24 | US | California | San Diego | 6073 | 387498 | 4183 | 0 | 33.03484597 | -116.73653259999999 | 2021-10-25 04:22:31 | San Diego, California, US | |
686932 | 686932 | 2021-11-13 | US | California | San Diego | 6073 | 399477 | 4280 | 0 | 33.03484597 | -116.73653259999999 | 2021-11-14 04:21:31 | San Diego, California, US | |
690953 | 690953 | 2022-12-23 | US | California | San Diego | 6073 | 1034654 | 5626 | 0 | 33.03484597 | -116.7365326 | 2022-12-24 04:21:02 | San Diego, California, US | |
694965 | 694965 | 2022-03-17 | US | California | San Diego | 6073 | 797420 | 5126 | 0 | 33.03484597 | -116.73653259999999 | 2022-03-18 04:20:55 | San Diego, California, US | |
698980 | 698980 | 2021-11-04 | US | California | San Diego | 6073 | 394591 | 4241 | 0 | 33.03484597 | -116.73653259999999 | 2021-11-05 04:21:54 | San Diego, California, US | |
702970 | 702970 | 2021-03-16 | US | California | San Diego | 6073 | 279138 | 3462 | 0 | 33.03484597 | -116.7365326 | 2021-03-17 05:25:07 | San Diego, California, US | |
707008 | 707008 | 2021-09-29 | US | California | San Diego | 6073 | 376690 | 4066 | 0 | 33.03484597 | -116.73653259999999 | 2021-09-30 04:21:20 | San Diego, California, US | |
711030 | 711030 | 2022-11-01 | US | California | San Diego | 6073 | 1002442 | 5524 | 0 | 33.03484597 | -116.7365326 | 2022-11-02 04:22:09 | San Diego, California, US | |
715041 | 715041 | 2021-11-12 | US | California | San Diego | 6073 | 398272 | 4272 | 0 | 33.03484597 | -116.73653259999999 | 2021-11-13 04:21:38 | San Diego, California, US | |
719062 | 719062 | 2022-12-04 | US | California | San Diego | 6073 | 1016893 | 5569 | 0 | 33.03484597 | -116.7365326 | 2022-12-05 04:20:58 | San Diego, California, US | |
723073 | 723073 | 2021-11-20 | US | California | San Diego | 6073 | 402221 | 4311 | 0 | 33.03484597 | -116.73653259999999 | 2021-11-21 04:22:13 | San Diego, California, US | |
727065 | 727065 | 2021-05-22 | US | California | San Diego | 6073 | 294505 | 3751 | 0 | 33.03484597 | -116.7365326 | 2021-05-23 04:20:51 | San Diego, California, US | |
731103 | 731103 | 2021-12-27 | US | California | San Diego | 6073 | 429976 | 4442 | 0 | 33.03484597 | -116.73653259999999 | 2021-12-28 04:21:47 | San Diego, California, US | |
736613 | 736613 | 2020-06-12 | US | California | San Diego | 6073 | 9131 | 308 | 0 | 8823 | 33.03484597 | -116.7365326 | 2020-06-13 03:33:14 | San Diego, California, US |
738865 | 738865 | 2020-12-02 | US | California | San Diego | 6073 | 88392 | 1035 | 0 | 87357 | 33.03484597 | -116.7365326 | 2020-12-03 05:28:22 | San Diego, California, US |
742879 | 742879 | 2021-02-20 | US | California | San Diego | 6073 | 269163 | 3188 | 0 | 265975 | 33.03484597 | -116.7365326 | 2021-02-21 05:24:33 | San Diego, California, US |
746920 | 746920 | 2022-04-23 | US | California | San Diego | 6073 | 810841 | 5233 | 0 | 33.03484597 | -116.73653259999999 | 2022-04-24 04:20:56 | San Diego, California, US | |
752572 | 752572 | 2020-08-01 | US | California | San Diego | 6073 | 29595 | 561 | 0 | 29034 | 33.03484597 | -116.7365326 | 2020-08-02 04:34:47 | San Diego, California, US |
754864 | 754864 | 2020-10-28 | US | California | San Diego | 6073 | 57209 | 881 | 0 | 56328 | 33.03484597 | -116.7365326 | 2020-10-29 04:24:49 | San Diego, California, US |
758903 | 758903 | 2021-11-26 | US | California | San Diego | 6073 | 404708 | 4319 | 0 | 33.03484597 | -116.73653259999999 | 2021-11-27 04:22:45 | San Diego, California, US | |
762874 | 762874 | 2020-10-18 | US | California | San Diego | 6073 | 53765 | 853 | 0 | 52912 | 33.03484597 | -116.7365326 | 2020-10-19 04:24:16 | San Diego, California, US |
766884 | 766884 | 2020-12-29 | US | California | San Diego | 6073 | 157637 | 1435 | 0 | 156202 | 33.03484597 | -116.7365326 | 2020-12-30 05:22:34 | San Diego, California, US |
770923 | 770923 | 2021-10-23 | US | California | San Diego | 6073 | 387483 | 4183 | 0 | 33.03484597 | -116.73653259999999 | 2021-10-24 04:21:22 | 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]);