johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where province_or_state = "Shizuoka" sorted by longitude
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, recovered, active, last_update, day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude ▼ | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
63084 | 63084 | 2022-11-12 | Japan | Shizuoka | 539492 | 791 | 0 | 34.916975 | 138.407784 | 2022-11-13 04:21:14 | Shizuoka, Japan | |||
91164 | 91164 | 2022-07-23 | Japan | Shizuoka | 224640 | 434 | 0 | 34.916975 | 138.407784 | 2022-07-24 04:20:47 | Shizuoka, Japan | |||
114774 | 114774 | 2022-09-06 | Japan | Shizuoka | 446066 | 690 | 0 | 34.916975 | 138.407784 | 2022-09-07 04:20:59 | Shizuoka, Japan | |||
130772 | 130772 | 2022-10-04 | Japan | Shizuoka | 496804 | 751 | 0 | 34.916975 | 138.407784 | 2022-10-05 04:23:06 | Shizuoka, Japan | |||
142010 | 142010 | 2022-07-09 | Japan | Shizuoka | 185568 | 423 | 0 | 34.916975 | 138.407784 | 2022-07-10 04:20:54 | Shizuoka, Japan | |||
166067 | 166067 | 2022-06-21 | Japan | Shizuoka | 176739 | 420 | 0 | 34.916975 | 138.407784 | 2022-06-22 04:20:54 | Shizuoka, Japan | |||
198281 | 198281 | 2022-10-19 | Japan | Shizuoka | 509881 | 761 | 0 | 34.916975 | 138.407784 | 2022-10-20 04:22:59 | Shizuoka, Japan | |||
218002 | 218002 | 2022-12-26 | Japan | Shizuoka | 669592 | 896 | 0 | 34.916975 | 138.407784 | 2022-12-27 04:21:07 | Shizuoka, Japan | |||
222018 | 222018 | 2022-05-09 | Japan | Shizuoka | 151654 | 404 | 0 | 34.916975 | 138.407784 | 2022-05-10 04:20:50 | Shizuoka, Japan | |||
229249 | 229249 | 2022-05-31 | Japan | Shizuoka | 170139 | 410 | 0 | 34.916975 | 138.407784 | 2022-06-01 04:20:55 | Shizuoka, Japan | |||
253336 | 253336 | 2022-09-08 | Japan | Shizuoka | 453661 | 690 | 0 | 34.916975 | 138.407784 | 2022-09-09 04:21:11 | Shizuoka, Japan | |||
257352 | 257352 | 2022-12-10 | Japan | Shizuoka | 604014 | 835 | 0 | 34.916975 | 138.407784 | 2022-12-11 04:20:50 | Shizuoka, Japan | |||
292035 | 292035 | 2022-11-15 | Japan | Shizuoka | 542456 | 792 | 0 | 34.916975 | 138.407784 | 2022-11-16 04:21:09 | Shizuoka, Japan | |||
307907 | 307907 | 2022-12-13 | Japan | Shizuoka | 611782 | 839 | 0 | 34.916975 | 138.407784 | 2022-12-14 04:21:04 | Shizuoka, Japan | |||
311923 | 311923 | 2022-11-13 | Japan | Shizuoka | 541245 | 794 | 0 | 34.916975 | 138.407784 | 2022-11-14 04:21:09 | Shizuoka, Japan | |||
319955 | 319955 | 2022-10-30 | Japan | Shizuoka | 519792 | 769 | 0 | 34.916975 | 138.407784 | 2022-10-31 04:21:36 | Shizuoka, Japan | |||
327929 | 327929 | 2022-12-27 | Japan | Shizuoka | 673638 | 899 | 0 | 34.916975 | 138.407784 | 2022-12-28 04:21:04 | Shizuoka, Japan | |||
348319 | 348319 | 2022-12-14 | Japan | Shizuoka | 617619 | 846 | 0 | 34.916975 | 138.407784 | 2022-12-15 04:20:58 | Shizuoka, Japan | |||
360365 | 360365 | 2022-05-07 | Japan | Shizuoka | 150165 | 404 | 0 | 34.916975 | 138.407784 | 2022-05-08 04:20:49 | Shizuoka, Japan | |||
372219 | 372219 | 2022-09-13 | Japan | Shizuoka | 465956 | 720 | 0 | 34.916975 | 138.407784 | 2022-09-14 04:20:44 | Shizuoka, Japan | |||
384246 | 384246 | 2022-09-23 | Japan | Shizuoka | 485809 | 737 | 0 | 34.916975 | 138.407784 | 2022-09-24 04:21:40 | Shizuoka, Japan | |||
396287 | 396287 | 2022-10-07 | Japan | Shizuoka | 499942 | 755 | 0 | 34.916975 | 138.407784 | 2022-10-08 04:22:56 | Shizuoka, Japan | |||
419358 | 419358 | 2022-09-18 | Japan | Shizuoka | 478151 | 728 | 0 | 34.916975 | 138.407784 | 2022-09-19 04:21:49 | Shizuoka, Japan | |||
431380 | 431380 | 2022-11-03 | Japan | Shizuoka | 525277 | 771 | 0 | 34.916975 | 138.407784 | 2022-11-04 04:22:11 | Shizuoka, Japan | |||
451410 | 451410 | 2022-12-21 | Japan | Shizuoka | 646492 | 869 | 0 | 34.916975 | 138.407784 | 2022-12-22 04:20:56 | Shizuoka, Japan | |||
463419 | 463419 | 2022-05-02 | Japan | Shizuoka | 147560 | 402 | 0 | 34.916975 | 138.407784 | 2022-05-03 04:21:00 | Shizuoka, Japan | |||
475465 | 475465 | 2022-06-26 | Japan | Shizuoka | 178125 | 421 | 0 | 34.916975 | 138.407784 | 2022-06-27 04:21:00 | Shizuoka, Japan | |||
479613 | 479613 | 2022-11-08 | Japan | Shizuoka | 531732 | 781 | 0 | 34.916975 | 138.407784 | 2022-11-09 04:21:22 | Shizuoka, Japan | |||
487643 | 487643 | 2022-11-25 | Japan | Shizuoka | 563166 | 798 | 0 | 34.916975 | 138.407784 | 2022-11-26 04:21:11 | Shizuoka, Japan | |||
503707 | 503707 | 2022-12-17 | Japan | Shizuoka | 630568 | 858 | 0 | 34.916975 | 138.407784 | 2022-12-18 04:21:03 | Shizuoka, Japan | |||
515751 | 515751 | 2022-10-15 | Japan | Shizuoka | 506291 | 759 | 0 | 34.916975 | 138.407784 | 2022-10-16 04:22:39 | Shizuoka, Japan | |||
538775 | 538775 | 2022-10-26 | Japan | Shizuoka | 515968 | 765 | 0 | 34.916975 | 138.407784 | 2022-10-27 04:22:01 | Shizuoka, Japan | |||
542791 | 542791 | 2022-12-15 | Japan | Shizuoka | 622265 | 848 | 0 | 34.916975 | 138.407784 | 2022-12-16 04:21:01 | Shizuoka, Japan | |||
558829 | 558829 | 2022-06-16 | Japan | Shizuoka | 175777 | 420 | 0 | 34.916975 | 138.407784 | 2022-06-17 04:20:56 | Shizuoka, Japan | |||
593681 | 593681 | 2022-07-01 | Japan | Shizuoka | 179808 | 421 | 0 | 34.916975 | 138.407784 | 2022-07-02 04:21:16 | Shizuoka, Japan | |||
617885 | 617885 | 2022-11-05 | Japan | Shizuoka | 527656 | 777 | 0 | 34.916975 | 138.407784 | 2022-11-06 04:21:24 | Shizuoka, Japan | |||
621901 | 621901 | 2022-05-22 | Japan | Shizuoka | 166742 | 407 | 0 | 34.916975 | 138.407784 | 2022-05-26 04:20:50 | Shizuoka, Japan | |||
629931 | 629931 | 2022-07-12 | Japan | Shizuoka | 189196 | 424 | 0 | 34.916975 | 138.407784 | 2022-07-13 04:20:58 | Shizuoka, Japan | |||
658337 | 658337 | 2022-05-13 | Japan | Shizuoka | 156167 | 404 | 0 | 34.916975 | 138.407784 | 2022-05-14 04:20:48 | Shizuoka, Japan | |||
666316 | 666316 | 2020-09-16 | Japan | Shizuoka | 511 | 2 | 488 | 21 | 34.916975 | 138.407784 | 2020-09-17 04:22:00 | Shizuoka, Japan | ||
670322 | 670322 | 2022-07-21 | Japan | Shizuoka | 212338 | 429 | 0 | 34.916975 | 138.407784 | 2022-07-22 04:21:15 | Shizuoka, Japan | |||
674338 | 674338 | 2022-07-30 | Japan | Shizuoka | 257415 | 448 | 0 | 34.916975 | 138.407784 | 2022-07-31 04:21:02 | Shizuoka, Japan | |||
690396 | 690396 | 2022-12-23 | Japan | Shizuoka | 656648 | 879 | 0 | 34.916975 | 138.407784 | 2022-12-24 04:21:02 | Shizuoka, Japan | |||
710473 | 710473 | 2022-11-01 | Japan | Shizuoka | 521529 | 769 | 0 | 34.916975 | 138.407784 | 2022-11-02 04:22:09 | Shizuoka, Japan | |||
718505 | 718505 | 2022-12-04 | Japan | Shizuoka | 586542 | 824 | 0 | 34.916975 | 138.407784 | 2022-12-05 04:20:58 | Shizuoka, Japan | |||
794437 | 794437 | 2022-10-24 | Japan | Shizuoka | 513846 | 764 | 0 | 34.916975 | 138.407784 | 2022-10-25 04:21:53 | Shizuoka, Japan | |||
833650 | 833650 | 2022-12-02 | Japan | Shizuoka | 581749 | 815 | 0 | 34.916975 | 138.407784 | 2022-12-03 04:21:02 | Shizuoka, Japan | |||
849622 | 849622 | 2022-11-02 | Japan | Shizuoka | 523486 | 771 | 0 | 34.916975 | 138.407784 | 2022-11-03 04:22:05 | Shizuoka, Japan | |||
853638 | 853638 | 2022-09-30 | Japan | Shizuoka | 493905 | 748 | 0 | 34.916975 | 138.407784 | 2022-10-01 04:23:01 | Shizuoka, Japan | |||
868822 | 868822 | 2022-12-11 | Japan | Shizuoka | 607134 | 837 | 0 | 34.916975 | 138.407784 | 2022-12-12 04:21:01 | Shizuoka, Japan | |||
880303 | 880303 | 2022-08-05 | Japan | Shizuoka | 290733 | 474 | 0 | 34.916975 | 138.407784 | 2022-08-06 04:20:56 | Shizuoka, Japan | |||
896170 | 896170 | 2022-07-24 | Japan | Shizuoka | 228429 | 435 | 0 | 34.916975 | 138.407784 | 2022-07-25 04:20:51 | Shizuoka, Japan | |||
900186 | 900186 | 2022-07-22 | Japan | Shizuoka | 218228 | 432 | 0 | 34.916975 | 138.407784 | 2022-07-23 04:20:53 | Shizuoka, Japan | |||
912231 | 912231 | 2022-10-29 | Japan | Shizuoka | 518883 | 769 | 0 | 34.916975 | 138.407784 | 2022-10-30 04:22:14 | Shizuoka, Japan | |||
938840 | 938840 | 2022-06-25 | Japan | Shizuoka | 177895 | 420 | 0 | 34.916975 | 138.407784 | 2022-06-26 04:21:02 | Shizuoka, Japan | |||
946872 | 946872 | 2022-06-14 | Japan | Shizuoka | 175181 | 419 | 0 | 34.916975 | 138.407784 | 2022-06-15 04:20:54 | Shizuoka, Japan | |||
958918 | 958918 | 2022-07-19 | Japan | Shizuoka | 203880 | 428 | 0 | 34.916975 | 138.407784 | 2022-07-20 04:20:59 | Shizuoka, Japan | |||
962934 | 962934 | 2022-09-09 | Japan | Shizuoka | 456398 | 702 | 0 | 34.916975 | 138.407784 | 2022-09-10 04:21:10 | Shizuoka, Japan | |||
970942 | 970942 | 2022-06-01 | Japan | Shizuoka | 170741 | 411 | 0 | 34.916975 | 138.407784 | 2022-06-02 05:20:39 | Shizuoka, Japan | |||
991017 | 991017 | 2022-08-16 | Japan | Shizuoka | 343272 | 553 | 0 | 34.916975 | 138.407784 | 2022-08-17 04:20:59 | Shizuoka, Japan | |||
1018373 | 1018373 | 2022-12-24 | Japan | Shizuoka | 662077 | 892 | 0 | 34.916975 | 138.407784 | 2022-12-25 04:21:04 | Shizuoka, Japan | |||
1022389 | 1022389 | 2022-11-04 | Japan | Shizuoka | 526522 | 775 | 0 | 34.916975 | 138.407784 | 2022-11-05 04:21:52 | Shizuoka, Japan | |||
1049861 | 1049861 | 2022-11-06 | Japan | Shizuoka | 529657 | 780 | 0 | 34.916975 | 138.407784 | 2022-11-07 04:21:26 | Shizuoka, Japan | |||
1065900 | 1065900 | 2022-07-28 | Japan | Shizuoka | 246080 | 444 | 0 | 34.916975 | 138.407784 | 2022-07-29 04:20:45 | Shizuoka, Japan | |||
1069916 | 1069916 | 2022-08-07 | Japan | Shizuoka | 301703 | 491 | 0 | 34.916975 | 138.407784 | 2022-08-08 04:21:08 | Shizuoka, Japan | |||
1073932 | 1073932 | 2022-12-28 | Japan | Shizuoka | 681200 | 910 | 0 | 34.916975 | 138.407784 | 2022-12-29 04:21:01 | Shizuoka, Japan | |||
1086098 | 1086098 | 2022-08-09 | Japan | Shizuoka | 310027 | 504 | 0 | 34.916975 | 138.407784 | 2022-08-10 04:20:57 | Shizuoka, Japan | |||
1098141 | 1098141 | 2022-08-03 | Japan | Shizuoka | 277170 | 460 | 0 | 34.916975 | 138.407784 | 2022-08-04 04:20:58 | Shizuoka, Japan | |||
1109597 | 1109597 | 2022-05-21 | Japan | Shizuoka | 163918 | 406 | 0 | 34.916975 | 138.407784 | 2022-05-22 04:20:52 | Shizuoka, Japan | |||
1121627 | 1121627 | 2020-09-17 | Japan | Shizuoka | 514 | 2 | 488 | 24 | 34.916975 | 138.407784 | 2020-09-18 05:05:00 | Shizuoka, Japan | ||
1148968 | 1148968 | 2022-12-12 | Japan | Shizuoka | 608985 | 837 | 0 | 34.916975 | 138.407784 | 2022-12-13 04:21:01 | Shizuoka, Japan | |||
1157175 | 1157175 | 2022-04-29 | Japan | Shizuoka | 146347 | 402 | 0 | 34.916975 | 138.407784 | 2022-04-30 04:21:05 | Shizuoka, Japan | |||
1161191 | 1161191 | 2022-08-18 | Japan | Shizuoka | 357448 | 566 | 0 | 34.916975 | 138.407784 | 2022-08-19 04:20:54 | Shizuoka, Japan | |||
1169221 | 1169221 | 2022-05-20 | Japan | Shizuoka | 162891 | 406 | 0 | 34.916975 | 138.407784 | 2022-05-21 04:20:58 | Shizuoka, Japan | |||
1184768 | 1184768 | 2022-05-18 | Japan | Shizuoka | 160752 | 404 | 0 | 34.916975 | 138.407784 | 2022-05-19 04:20:54 | Shizuoka, Japan | |||
1199830 | 1199830 | 2022-07-06 | Japan | Shizuoka | 182358 | 421 | 0 | 34.916975 | 138.407784 | 2022-07-07 04:20:55 | Shizuoka, Japan | |||
1211575 | 1211575 | 2022-07-11 | Japan | Shizuoka | 187314 | 423 | 0 | 34.916975 | 138.407784 | 2022-07-12 04:20:51 | Shizuoka, Japan | |||
1239684 | 1239684 | 2022-11-28 | Japan | Shizuoka | 570136 | 802 | 0 | 34.916975 | 138.407784 | 2022-11-29 04:21:05 | Shizuoka, Japan | |||
1250780 | 1250780 | 2022-08-23 | Japan | Shizuoka | 385592 | 601 | 0 | 34.916975 | 138.407784 | 2022-08-24 04:20:46 | Shizuoka, Japan | |||
1314222 | 1314222 | 2022-05-27 | Japan | Shizuoka | 168183 | 409 | 0 | 34.916975 | 138.407784 | 2022-05-28 04:21:07 | Shizuoka, Japan | |||
1346343 | 1346343 | 2022-08-10 | Japan | Shizuoka | 317114 | 514 | 0 | 34.916975 | 138.407784 | 2022-08-11 04:20:49 | Shizuoka, Japan | |||
1366500 | 1366500 | 2022-10-28 | Japan | Shizuoka | 517950 | 765 | 0 | 34.916975 | 138.407784 | 2022-10-29 04:21:13 | Shizuoka, Japan | |||
1370516 | 1370516 | 2022-09-21 | Japan | Shizuoka | 481650 | 736 | 0 | 34.916975 | 138.407784 | 2022-09-22 04:22:56 | Shizuoka, Japan | |||
1393700 | 1393700 | 2022-09-02 | Japan | Shizuoka | 434157 | 674 | 0 | 34.916975 | 138.407784 | 2022-09-03 04:21:04 | Shizuoka, Japan | |||
1397716 | 1397716 | 2022-05-06 | Japan | Shizuoka | 149372 | 403 | 0 | 34.916975 | 138.407784 | 2022-05-07 04:21:09 | Shizuoka, Japan | |||
1405066 | 1405066 | 2022-08-02 | Japan | Shizuoka | 269851 | 454 | 0 | 34.916975 | 138.407784 | 2022-08-03 04:20:59 | Shizuoka, Japan | |||
1417110 | 1417110 | 2022-07-08 | Japan | Shizuoka | 184286 | 421 | 0 | 34.916975 | 138.407784 | 2022-07-09 04:20:59 | Shizuoka, Japan | |||
1421126 | 1421126 | 2022-06-08 | Japan | Shizuoka | 173496 | 416 | 0 | 34.916975 | 138.407784 | 2022-06-09 04:20:54 | Shizuoka, Japan | |||
1487609 | 1487609 | 2022-07-26 | Japan | Shizuoka | 236012 | 439 | 0 | 34.916975 | 138.407784 | 2022-07-27 04:21:04 | Shizuoka, Japan | |||
1503622 | 1503622 | 2022-05-16 | Japan | Shizuoka | 158588 | 404 | 0 | 34.916975 | 138.407784 | 2022-05-17 04:20:59 | Shizuoka, Japan | |||
1531951 | 1531951 | 2022-08-26 | Japan | Shizuoka | 404054 | 616 | 0 | 34.916975 | 138.407784 | 2022-08-27 04:20:57 | Shizuoka, Japan | |||
1560115 | 1560115 | 2022-09-28 | Japan | Shizuoka | 491685 | 739 | 0 | 34.916975 | 138.407784 | 2022-09-29 04:22:34 | Shizuoka, Japan | |||
1572159 | 1572159 | 2022-05-03 | Japan | Shizuoka | 148104 | 403 | 0 | 34.916975 | 138.407784 | 2022-05-04 04:20:59 | Shizuoka, Japan | |||
1592230 | 1592230 | 2022-10-21 | Japan | Shizuoka | 511835 | 763 | 0 | 34.916975 | 138.407784 | 2022-10-22 04:22:53 | Shizuoka, Japan | |||
1608285 | 1608285 | 2022-07-20 | Japan | Shizuoka | 207604 | 428 | 0 | 34.916975 | 138.407784 | 2022-07-21 04:21:10 | Shizuoka, Japan | |||
1620296 | 1620296 | 2022-11-22 | Japan | Shizuoka | 555862 | 795 | 0 | 34.916975 | 138.407784 | 2022-11-23 04:21:06 | Shizuoka, Japan | |||
1624312 | 1624312 | 2022-09-22 | Japan | Shizuoka | 484145 | 737 | 0 | 34.916975 | 138.407784 | 2022-09-23 04:23:13 | Shizuoka, Japan | |||
1628328 | 1628328 | 2022-12-18 | Japan | Shizuoka | 634581 | 861 | 0 | 34.916975 | 138.407784 | 2022-12-19 04:21:03 | Shizuoka, Japan | |||
1640369 | 1640369 | 2022-11-20 | Japan | Shizuoka | 553145 | 795 | 0 | 34.916975 | 138.407784 | 2022-11-21 04:21:05 | Shizuoka, Japan | |||
1648401 | 1648401 | 2022-06-23 | Japan | Shizuoka | 177354 | 420 | 0 | 34.916975 | 138.407784 | 2022-06-24 04:20:58 | Shizuoka, 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]);