johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where province_or_state = "Tokyo" sorted by admin2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
427377 | 427377 | 2020-09-07 | Japan | Tokyo | 21845 | 372 | 18967 | 2506 | 35.711343 | 139.446921 | 2020-09-08 04:28:25 | Tokyo, Japan | ||
431383 | 431383 | 2022-11-03 | Japan | Tokyo | 3288749 | 6021 | 0 | 35.711343 | 139.446921 | 2022-11-04 04:22:11 | Tokyo, Japan | |||
435397 | 435397 | 2021-01-21 | Japan | Tokyo | 91469 | 761 | 68901 | 21807 | 35.711343 | 139.446921 | 2021-01-22 05:22:10 | Tokyo, Japan | ||
442747 | 442747 | 2020-07-26 | Japan | Tokyo | 11213 | 328 | 7966 | 2919 | 35.711343 | 139.446921 | 2020-07-27 04:35:02 | Tokyo, Japan | ||
443380 | 443380 | 2021-10-20 | Japan | Tokyo | 381370 | 3113 | 0 | 35.711343 | 139.446921 | 2021-10-21 04:21:18 | Tokyo, Japan | |||
447396 | 447396 | 2021-11-17 | Japan | Tokyo | 382017 | 3160 | 0 | 35.711343 | 139.446921 | 2021-11-18 04:21:33 | Tokyo, Japan | |||
451413 | 451413 | 2022-12-21 | Japan | Tokyo | 3824262 | 6541 | 0 | 35.711343 | 139.446921 | 2022-12-22 04:20:56 | Tokyo, Japan | |||
458773 | 458773 | 2020-08-07 | Japan | Tokyo | 15104 | 333 | 11007 | 3764 | 35.711343 | 139.446921 | 2020-08-08 04:34:53 | Tokyo, Japan | ||
459405 | 459405 | 2022-02-02 | Japan | Tokyo | 613804 | 3212 | 0 | 35.711343 | 139.446921 | 2022-02-03 04:21:21 | Tokyo, Japan | |||
463422 | 463422 | 2022-05-02 | Japan | Tokyo | 1444208 | 4337 | 0 | 35.711343 | 139.446921 | 2022-05-03 04:21:00 | Tokyo, Japan | |||
467437 | 467437 | 2021-10-07 | Japan | Tokyo | 380561 | 2994 | 0 | 35.711343 | 139.446921 | 2021-10-08 04:21:25 | Tokyo, Japan | |||
471453 | 471453 | 2021-02-19 | Japan | Tokyo | 109135 | 1221 | 103202 | 4712 | 35.711343 | 139.446921 | 2021-02-20 05:22:51 | Tokyo, Japan | ||
475468 | 475468 | 2022-06-26 | Japan | Tokyo | 1587467 | 4568 | 0 | 35.711343 | 139.446921 | 2022-06-27 04:21:00 | Tokyo, Japan | |||
479616 | 479616 | 2022-11-08 | Japan | Tokyo | 3318224 | 6031 | 0 | 35.711343 | 139.446921 | 2022-11-09 04:21:22 | Tokyo, Japan | |||
483631 | 483631 | 2021-07-19 | Japan | Tokyo | 189822 | 2270 | 177854 | 9698 | 35.711343 | 139.446921 | 2021-07-20 04:21:48 | Tokyo, Japan | ||
487646 | 487646 | 2022-11-25 | Japan | Tokyo | 3468005 | 6141 | 0 | 35.711343 | 139.446921 | 2022-11-26 04:21:11 | Tokyo, Japan | |||
491661 | 491661 | 2021-10-14 | Japan | Tokyo | 381101 | 3069 | 0 | 35.711343 | 139.446921 | 2021-10-15 04:21:26 | Tokyo, Japan | |||
495677 | 495677 | 2021-11-06 | Japan | Tokyo | 381775 | 3155 | 0 | 35.711343 | 139.446921 | 2021-11-07 04:21:53 | Tokyo, Japan | |||
499694 | 499694 | 2022-04-02 | Japan | Tokyo | 1266028 | 4182 | 0 | 35.711343 | 139.446921 | 2022-04-03 04:20:48 | Tokyo, Japan | |||
503710 | 503710 | 2022-12-17 | Japan | Tokyo | 3760973 | 6481 | 0 | 35.711343 | 139.446921 | 2022-12-18 04:21:03 | Tokyo, Japan | |||
507725 | 507725 | 2021-08-14 | Japan | Tokyo | 276977 | 2332 | 0 | 35.711343 | 139.446921 | 2021-08-15 04:21:41 | Tokyo, Japan | |||
511739 | 511739 | 2021-08-19 | Japan | Tokyo | 300284 | 2358 | 0 | 35.711343 | 139.446921 | 2021-08-20 04:21:33 | Tokyo, Japan | |||
515754 | 515754 | 2022-10-15 | Japan | Tokyo | 3216041 | 5938 | 0 | 35.711343 | 139.446921 | 2022-10-16 04:22:39 | Tokyo, Japan | |||
522898 | 522898 | 2021-06-09 | Japan | Tokyo | 164703 | 2128 | 158392 | 4183 | 35.711343 | 139.446921 | 2021-06-10 04:23:17 | Tokyo, Japan | ||
530123 | 530123 | 2020-07-04 | Japan | Tokyo | 6654 | 325 | 5617 | 712 | 35.711343 | 139.446921 | 2020-07-05 04:33:46 | Tokyo, Japan | ||
530747 | 530747 | 2021-02-22 | Japan | Tokyo | 109912 | 1274 | 104317 | 4321 | 35.711343 | 139.446921 | 2021-02-23 05:23:41 | Tokyo, Japan | ||
534761 | 534761 | 2021-10-27 | Japan | Tokyo | 381565 | 3127 | 0 | 35.711343 | 139.446921 | 2021-10-28 04:22:08 | Tokyo, Japan | |||
538778 | 538778 | 2022-10-26 | Japan | Tokyo | 3251909 | 5988 | 0 | 35.711343 | 139.446921 | 2022-10-27 04:22:01 | Tokyo, Japan | |||
542794 | 542794 | 2022-12-15 | Japan | Tokyo | 3727680 | 6437 | 0 | 35.711343 | 139.446921 | 2022-12-16 04:21:01 | Tokyo, Japan | |||
546794 | 546794 | 2020-09-12 | Japan | Tokyo | 22853 | 382 | 20019 | 2452 | 35.711343 | 139.446921 | 2020-09-13 04:30:52 | Tokyo, Japan | ||
550799 | 550799 | 2021-12-08 | Japan | Tokyo | 382307 | 3169 | 0 | 35.711343 | 139.446921 | 2021-12-09 04:22:49 | Tokyo, Japan | |||
554815 | 554815 | 2022-01-16 | Japan | Tokyo | 407834 | 3178 | 0 | 35.711343 | 139.446921 | 2022-01-17 04:21:08 | Tokyo, Japan | |||
558832 | 558832 | 2022-06-16 | Japan | Tokyo | 1568442 | 4549 | 0 | 35.711343 | 139.446921 | 2022-06-17 04:20:56 | Tokyo, Japan | |||
563008 | 563008 | 2021-06-22 | Japan | Tokyo | 169728 | 2203 | 163854 | 3671 | 35.711343 | 139.446921 | 2021-06-23 04:21:46 | Tokyo, Japan | ||
567129 | 567129 | 2021-10-29 | Japan | Tokyo | 381610 | 3142 | 0 | 35.711343 | 139.446921 | 2021-10-30 04:22:03 | Tokyo, Japan | |||
574232 | 574232 | 2020-06-06 | Japan | Tokyo | 5364 | 311 | 4687 | 366 | 35.711343 | 139.446921 | 2020-06-07 03:53:30 | Tokyo, Japan | ||
574858 | 574858 | 2022-02-25 | Japan | Tokyo | 962673 | 3564 | 0 | 35.711343 | 139.446921 | 2022-02-26 04:21:12 | Tokyo, Japan | |||
578873 | 578873 | 2021-07-13 | Japan | Tokyo | 182945 | 2258 | 173720 | 6967 | 35.711343 | 139.446921 | 2021-07-14 04:21:35 | Tokyo, Japan | ||
582872 | 582872 | 2020-08-13 | Japan | Tokyo | 16677 | 338 | 12526 | 3813 | 35.711343 | 139.446921 | 2020-08-14 04:51:19 | Tokyo, Japan | ||
589669 | 589669 | 2021-08-08 | Japan | Tokyo | 250515 | 2311 | 0 | 35.711343 | 139.446921 | 2021-08-09 04:21:24 | Tokyo, Japan | |||
593684 | 593684 | 2022-07-01 | Japan | Tokyo | 1602377 | 4577 | 0 | 35.711343 | 139.446921 | 2022-07-02 04:21:16 | Tokyo, Japan | |||
597699 | 597699 | 2021-10-19 | Japan | Tokyo | 381329 | 3108 | 0 | 35.711343 | 139.446921 | 2021-10-20 04:21:00 | Tokyo, Japan | |||
601715 | 601715 | 2021-09-23 | Japan | Tokyo | 377664 | 2838 | 0 | 35.711343 | 139.446921 | 2021-09-24 04:21:44 | Tokyo, Japan | |||
605730 | 605730 | 2021-04-09 | Japan | Tokyo | 124977 | 1798 | 118732 | 4447 | 35.711343 | 139.446921 | 2021-04-10 04:20:59 | Tokyo, Japan | ||
609729 | 609729 | 2020-08-29 | Japan | Tokyo | 20566 | 358 | 17411 | 2797 | 35.711343 | 139.446921 | 2020-08-30 04:28:22 | Tokyo, Japan | ||
613729 | 613729 | 2021-02-08 | Japan | Tokyo | 104959 | 1035 | 95648 | 8276 | 35.711343 | 139.446921 | 2021-02-09 05:23:30 | Tokyo, Japan | ||
617888 | 617888 | 2022-11-05 | Japan | Tokyo | 3299806 | 6026 | 0 | 35.711343 | 139.446921 | 2022-11-06 04:21:24 | Tokyo, Japan | |||
621904 | 621904 | 2022-05-22 | Japan | Tokyo | 1525929 | 4464 | 0 | 35.711343 | 139.446921 | 2022-05-26 04:20:50 | Tokyo, Japan | |||
625919 | 625919 | 2021-07-10 | Japan | Tokyo | 181000 | 2253 | 171941 | 6806 | 35.711343 | 139.446921 | 2021-07-11 04:21:43 | Tokyo, Japan | ||
629934 | 629934 | 2022-07-12 | Japan | Tokyo | 1680442 | 4588 | 0 | 35.711343 | 139.446921 | 2022-07-13 04:20:58 | Tokyo, Japan | |||
633949 | 633949 | 2021-10-13 | Japan | Tokyo | 381039 | 3057 | 0 | 35.711343 | 139.446921 | 2021-10-14 04:21:29 | Tokyo, Japan | |||
637965 | 637965 | 2021-03-31 | Japan | Tokyo | 120986 | 1770 | 115690 | 3526 | 35.711343 | 139.446921 | 2021-04-01 04:27:05 | Tokyo, Japan | ||
641979 | 641979 | 2021-09-07 | Japan | Tokyo | 363189 | 2577 | 0 | 35.711343 | 139.446921 | 2021-09-08 04:21:31 | Tokyo, Japan | |||
645993 | 645993 | 2021-05-05 | Japan | Tokyo | 142921 | 1899 | 133488 | 7534 | 35.711343 | 139.446921 | 2021-05-06 04:20:38 | Tokyo, Japan | ||
650007 | 650007 | 2021-08-09 | Japan | Tokyo | 253487 | 2314 | 0 | 35.711343 | 139.446921 | 2021-08-10 04:21:27 | Tokyo, Japan | |||
654021 | 654021 | 2021-10-22 | Japan | Tokyo | 381432 | 3116 | 0 | 35.711343 | 139.446921 | 2021-10-23 04:21:32 | Tokyo, Japan | |||
658340 | 658340 | 2022-05-13 | Japan | Tokyo | 1484636 | 4383 | 0 | 35.711343 | 139.446921 | 2022-05-14 04:20:48 | Tokyo, Japan | |||
662340 | 662340 | 2020-08-11 | Japan | Tokyo | 16249 | 336 | 11970 | 3943 | 35.711343 | 139.446921 | 2020-08-12 04:27:29 | Tokyo, Japan | ||
666319 | 666319 | 2020-09-16 | Japan | Tokyo | 23433 | 389 | 20603 | 2441 | 35.711343 | 139.446921 | 2020-09-17 04:22:00 | Tokyo, Japan | ||
670325 | 670325 | 2022-07-21 | Japan | Tokyo | 1845743 | 4607 | 0 | 35.711343 | 139.446921 | 2022-07-22 04:21:15 | Tokyo, Japan | |||
674341 | 674341 | 2022-07-30 | Japan | Tokyo | 2135250 | 4661 | 0 | 35.711343 | 139.446921 | 2022-07-31 04:21:02 | Tokyo, Japan | |||
678353 | 678353 | 2020-11-23 | Japan | Tokyo | 38009 | 479 | 33383 | 4147 | 35.711343 | 139.446921 | 2020-11-24 05:27:31 | Tokyo, Japan | ||
682366 | 682366 | 2021-10-24 | Japan | Tokyo | 381483 | 3117 | 0 | 35.711343 | 139.446921 | 2021-10-25 04:22:31 | Tokyo, Japan | |||
686382 | 686382 | 2021-11-13 | Japan | Tokyo | 381946 | 3158 | 0 | 35.711343 | 139.446921 | 2021-11-14 04:21:31 | Tokyo, Japan | |||
690399 | 690399 | 2022-12-23 | Japan | Tokyo | 3860414 | 6581 | 0 | 35.711343 | 139.446921 | 2022-12-24 04:21:02 | Tokyo, Japan | |||
694415 | 694415 | 2022-03-17 | Japan | Tokyo | 1153712 | 4021 | 0 | 35.711343 | 139.446921 | 2022-03-18 04:20:55 | Tokyo, Japan | |||
698430 | 698430 | 2021-11-04 | Japan | Tokyo | 381721 | 3154 | 0 | 35.711343 | 139.446921 | 2021-11-05 04:21:54 | Tokyo, Japan | |||
702446 | 702446 | 2021-03-16 | Japan | Tokyo | 115884 | 1605 | 111367 | 2912 | 35.711343 | 139.446921 | 2021-03-17 05:25:07 | Tokyo, Japan | ||
706460 | 706460 | 2021-09-29 | Japan | Tokyo | 379260 | 2908 | 0 | 35.711343 | 139.446921 | 2021-09-30 04:21:20 | Tokyo, Japan | |||
710476 | 710476 | 2022-11-01 | Japan | Tokyo | 3275717 | 6016 | 0 | 35.711343 | 139.446921 | 2022-11-02 04:22:09 | Tokyo, Japan | |||
714491 | 714491 | 2021-11-12 | Japan | Tokyo | 381922 | 3158 | 0 | 35.711343 | 139.446921 | 2021-11-13 04:21:38 | Tokyo, Japan | |||
718508 | 718508 | 2022-12-04 | Japan | Tokyo | 3574118 | 6244 | 0 | 35.711343 | 139.446921 | 2022-12-05 04:20:58 | Tokyo, Japan | |||
722523 | 722523 | 2021-11-20 | Japan | Tokyo | 382069 | 3163 | 0 | 35.711343 | 139.446921 | 2021-11-21 04:22:13 | Tokyo, Japan | |||
726539 | 726539 | 2021-05-22 | Japan | Tokyo | 156237 | 2015 | 147406 | 6816 | 35.711343 | 139.446921 | 2021-05-23 04:20:51 | Tokyo, Japan | ||
730553 | 730553 | 2021-12-27 | Japan | Tokyo | 382834 | 3174 | 0 | 35.711343 | 139.446921 | 2021-12-28 04:21:47 | Tokyo, Japan | |||
737720 | 737720 | 2020-06-12 | Japan | Tokyo | 5468 | 313 | 4856 | 299 | 35.711343 | 139.446921 | 2020-06-13 03:33:14 | Tokyo, Japan | ||
738342 | 738342 | 2020-12-02 | Japan | Tokyo | 41814 | 499 | 36880 | 4435 | 35.711343 | 139.446921 | 2020-12-03 05:28:22 | Tokyo, Japan | ||
742355 | 742355 | 2021-02-20 | Japan | Tokyo | 109462 | 1248 | 103667 | 4547 | 35.711343 | 139.446921 | 2021-02-21 05:24:33 | Tokyo, Japan | ||
746370 | 746370 | 2022-04-23 | Japan | Tokyo | 1407320 | 4305 | 0 | 35.711343 | 139.446921 | 2022-04-24 04:20:56 | Tokyo, Japan | |||
753727 | 753727 | 2020-08-01 | Japan | Tokyo | 13161 | 332 | 9615 | 3214 | 35.711343 | 139.446921 | 2020-08-02 04:34:47 | Tokyo, Japan | ||
754343 | 754343 | 2020-10-28 | Japan | Tokyo | 30444 | 451 | 28218 | 1775 | 35.711343 | 139.446921 | 2020-10-29 04:24:49 | Tokyo, Japan | ||
758353 | 758353 | 2021-11-26 | Japan | Tokyo | 382163 | 3164 | 0 | 35.711343 | 139.446921 | 2021-11-27 04:22:45 | Tokyo, Japan | |||
762355 | 762355 | 2020-10-18 | Japan | Tokyo | 28955 | 436 | 26306 | 2213 | 35.711343 | 139.446921 | 2020-10-19 04:24:16 | Tokyo, Japan | ||
766361 | 766361 | 2020-12-29 | Japan | Tokyo | 57998 | 618 | 48932 | 8448 | 35.711343 | 139.446921 | 2020-12-30 05:22:34 | Tokyo, Japan | ||
770374 | 770374 | 2021-10-23 | Japan | Tokyo | 381464 | 3117 | 0 | 35.711343 | 139.446921 | 2021-10-24 04:21:22 | Tokyo, Japan | |||
774389 | 774389 | 2021-01-12 | Japan | Tokyo | 77718 | 691 | 56551 | 20476 | 35.711343 | 139.446921 | 2021-01-13 05:22:15 | Tokyo, Japan | ||
778402 | 778402 | 2021-07-08 | Japan | Tokyo | 179226 | 2246 | 170752 | 6228 | 35.711343 | 139.446921 | 2021-07-09 04:21:21 | Tokyo, Japan | ||
782416 | 782416 | 2021-12-13 | Japan | Tokyo | 382389 | 3171 | 0 | 35.711343 | 139.446921 | 2021-12-14 04:22:38 | Tokyo, Japan | |||
786418 | 786418 | 2020-10-15 | Japan | Tokyo | 28405 | 427 | 25846 | 2132 | 35.711343 | 139.446921 | 2020-10-16 04:24:01 | Tokyo, Japan | ||
790424 | 790424 | 2021-02-04 | Japan | Tokyo | 103038 | 974 | 90663 | 11401 | 35.711343 | 139.446921 | 2021-02-05 05:22:38 | Tokyo, Japan | ||
794440 | 794440 | 2022-10-24 | Japan | Tokyo | 3242860 | 5983 | 0 | 35.711343 | 139.446921 | 2022-10-25 04:21:53 | Tokyo, Japan | |||
798455 | 798455 | 2021-12-22 | Japan | Tokyo | 382642 | 3173 | 0 | 35.711343 | 139.446921 | 2021-12-23 04:21:21 | Tokyo, Japan | |||
805529 | 805529 | 2020-06-01 | Japan | Tokyo | 5244 | 305 | 4539 | 400 | 35.711343 | 139.446921 | 2020-06-02 02:33:08 | Tokyo, Japan | ||
809617 | 809617 | 2021-09-20 | Japan | Tokyo | 376335 | 2801 | 0 | 35.711343 | 139.446921 | 2021-09-21 04:21:26 | Tokyo, Japan | |||
813617 | 813617 | 2020-09-05 | Japan | Tokyo | 21653 | 369 | 18735 | 2549 | 35.711343 | 139.446921 | 2020-09-06 04:28:33 | Tokyo, Japan | ||
817608 | 817608 | 2020-10-09 | Japan | Tokyo | 27306 | 421 | 24733 | 2152 | 35.711343 | 139.446921 | 2020-10-10 04:23:57 | Tokyo, Japan | ||
821611 | 821611 | 2020-11-19 | Japan | Tokyo | 36243 | 476 | 32222 | 3545 | 35.711343 | 139.446921 | 2020-11-20 05:26:28 | Tokyo, Japan | ||
825624 | 825624 | 2021-06-06 | Japan | Tokyo | 163656 | 2108 | 156786 | 4762 | 35.711343 | 139.446921 | 2021-06-07 04:22:51 | Tokyo, Japan | ||
829638 | 829638 | 2021-07-09 | Japan | Tokyo | 180049 | 2248 | 171321 | 6480 | 35.711343 | 139.446921 | 2021-07-10 04:21:25 | Tokyo, Japan | ||
833653 | 833653 | 2022-12-02 | Japan | Tokyo | 3550343 | 6215 | 0 | 35.711343 | 139.446921 | 2022-12-03 04:21:02 | Tokyo, Japan |
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]);