johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where country_or_region = "Japan" and province_or_state = "Miyagi" sorted by day descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
190092 | 190092 | 2021-01-11 | Japan | Miyagi | 2654 | 17 | 2126 | 511 | 38.446859 | 140.927086 | 2021-01-12 05:22:15 | Miyagi, Japan | ||
2625895 | 2625895 | 2021-01-10 | Japan | Miyagi | 2623 | 17 | 2104 | 502 | 38.446859 | 140.927086 | 2021-01-11 05:21:50 | Miyagi, Japan | ||
3899983 | 3899983 | 2021-01-09 | Japan | Miyagi | 2560 | 17 | 2072 | 471 | 38.446859 | 140.927086 | 2021-01-10 05:22:12 | Miyagi, Japan | ||
154006 | 154006 | 2021-01-08 | Japan | Miyagi | 2488 | 17 | 2022 | 449 | 38.446859 | 140.927086 | 2021-01-09 05:22:18 | Miyagi, Japan | ||
2541430 | 2541430 | 2021-01-07 | Japan | Miyagi | 2427 | 16 | 1997 | 414 | 38.446859 | 140.927086 | 2021-01-08 05:22:42 | Miyagi, Japan | ||
2864739 | 2864739 | 2021-01-06 | Japan | Miyagi | 2352 | 16 | 1966 | 370 | 38.446859 | 140.927086 | 2021-01-07 05:22:03 | Miyagi, Japan | ||
3034326 | 3034326 | 2021-01-05 | Japan | Miyagi | 2300 | 16 | 1831 | 453 | 38.446859 | 140.927086 | 2021-01-06 05:22:16 | Miyagi, Japan | ||
1061871 | 1061871 | 2021-01-04 | Japan | Miyagi | 2263 | 16 | 1815 | 432 | 38.446859 | 140.927086 | 2021-01-05 05:21:49 | Miyagi, Japan | ||
3230474 | 3230474 | 2021-01-03 | Japan | Miyagi | 2245 | 16 | 1760 | 469 | 38.446859 | 140.927086 | 2021-01-04 05:22:02 | Miyagi, Japan | ||
2227543 | 2227543 | 2021-01-02 | Japan | Miyagi | 2225 | 16 | 1732 | 477 | 38.446859 | 140.927086 | 2021-01-03 05:22:52 | Miyagi, Japan | ||
1136907 | 1136907 | 2021-01-01 | Japan | Miyagi | 2221 | 16 | 1694 | 511 | 38.446859 | 140.927086 | 2021-01-02 05:22:33 | Miyagi, Japan | ||
3695513 | 3695513 | 2020-12-31 | Japan | Miyagi | 2191 | 16 | 1675 | 500 | 38.446859 | 140.927086 | 2021-01-01 05:23:07 | Miyagi, Japan | ||
1010328 | 1010328 | 2020-12-30 | Japan | Miyagi | 2165 | 16 | 1653 | 496 | 38.446859 | 140.927086 | 2020-12-31 05:22:49 | Miyagi, Japan | ||
766343 | 766343 | 2020-12-29 | Japan | Miyagi | 2131 | 15 | 1602 | 514 | 38.446859 | 140.927086 | 2020-12-30 05:22:34 | Miyagi, Japan | ||
3761607 | 3761607 | 2020-12-28 | Japan | Miyagi | 2092 | 14 | 1569 | 509 | 38.446859 | 140.927086 | 2020-12-29 05:22:37 | Miyagi, Japan | ||
3777927 | 3777927 | 2020-12-27 | Japan | Miyagi | 2064 | 14 | 1552 | 498 | 38.446859 | 140.927086 | 2020-12-28 05:22:06 | Miyagi, Japan | ||
2223532 | 2223532 | 2020-12-26 | Japan | Miyagi | 2025 | 14 | 1532 | 479 | 38.446859 | 140.927086 | 2020-12-27 05:22:55 | Miyagi, Japan | ||
202279 | 202279 | 2020-12-25 | Japan | Miyagi | 1969 | 13 | 1490 | 466 | 38.446859 | 140.927086 | 2020-12-26 05:22:28 | Miyagi, Japan | ||
3691502 | 3691502 | 2020-12-24 | Japan | Miyagi | 1921 | 13 | 1462 | 446 | 38.446859 | 140.927086 | 2020-12-25 05:22:48 | Miyagi, Japan | ||
2406854 | 2406854 | 2020-12-23 | Japan | Miyagi | 1873 | 13 | 1419 | 441 | 38.446859 | 140.927086 | 2020-12-24 05:23:04 | Miyagi, Japan | ||
3769900 | 3769900 | 2020-12-22 | Japan | Miyagi | 1822 | 12 | 1410 | 400 | 38.446859 | 140.927086 | 2020-12-23 05:22:03 | Miyagi, Japan | ||
927716 | 927716 | 2020-12-21 | Japan | Miyagi | 1781 | 12 | 1381 | 388 | 38.446859 | 140.927086 | 2020-12-22 05:22:33 | Miyagi, Japan | ||
2119737 | 2119737 | 2020-12-20 | Japan | Miyagi | 1775 | 12 | 1323 | 440 | 38.446859 | 140.927086 | 2020-12-21 05:27:58 | Miyagi, Japan | ||
2931244 | 2931244 | 2020-12-19 | Japan | Miyagi | 1742 | 12 | 1311 | 419 | 38.446859 | 140.927086 | 2020-12-20 05:27:32 | Miyagi, Japan | ||
1901190 | 1901190 | 2020-12-18 | Japan | Miyagi | 1695 | 12 | 1267 | 416 | 38.446859 | 140.927086 | 2020-12-19 05:27:52 | Miyagi, Japan | ||
2128016 | 2128016 | 2020-12-17 | Japan | Miyagi | 1679 | 12 | 1258 | 409 | 38.446859 | 140.927086 | 2020-12-18 05:28:18 | Miyagi, Japan | ||
3149616 | 3149616 | 2020-12-16 | Japan | Miyagi | 1625 | 12 | 1241 | 372 | 38.446859 | 140.927086 | 2020-12-17 05:28:12 | Miyagi, Japan | ||
1034397 | 1034397 | 2020-12-15 | Japan | Miyagi | 1580 | 12 | 1232 | 336 | 38.446859 | 140.927086 | 2020-12-16 05:28:04 | Miyagi, Japan | ||
1751291 | 1751291 | 2020-12-14 | Japan | Miyagi | 1543 | 12 | 1218 | 313 | 38.446859 | 140.927086 | 2020-12-15 05:26:38 | Miyagi, Japan | ||
3847811 | 3847811 | 2020-12-13 | Japan | Miyagi | 1527 | 12 | 1206 | 309 | 38.446859 | 140.927086 | 2020-12-14 05:26:27 | Miyagi, Japan | ||
845593 | 845593 | 2020-12-12 | Japan | Miyagi | 1498 | 12 | 1197 | 289 | 38.446859 | 140.927086 | 2020-12-13 05:27:20 | Miyagi, Japan | ||
860700 | 860700 | 2020-12-11 | Japan | Miyagi | 1463 | 12 | 1185 | 266 | 38.446859 | 140.927086 | 2020-12-12 05:26:19 | Miyagi, Japan | ||
1600242 | 1600242 | 2020-12-10 | Japan | Miyagi | 1417 | 12 | 1173 | 232 | 38.446859 | 140.927086 | 2020-12-11 05:26:59 | Miyagi, Japan | ||
2975251 | 2975251 | 2020-12-09 | Japan | Miyagi | 1379 | 12 | 1158 | 209 | 38.446859 | 140.927086 | 2020-12-10 05:26:19 | Miyagi, Japan | ||
1818811 | 1818811 | 2020-12-08 | Japan | Miyagi | 1336 | 11 | 1144 | 181 | 38.446859 | 140.927086 | 2020-12-09 05:28:01 | Miyagi, Japan | ||
2347447 | 2347447 | 2020-12-07 | Japan | Miyagi | 1319 | 10 | 1133 | 176 | 38.446859 | 140.927086 | 2020-12-08 05:27:42 | Miyagi, Japan | ||
1006317 | 1006317 | 2020-12-06 | Japan | Miyagi | 1311 | 10 | 1117 | 184 | 38.446859 | 140.927086 | 2020-12-07 05:26:14 | Miyagi, Japan | ||
1632326 | 1632326 | 2020-12-05 | Japan | Miyagi | 1293 | 10 | 1107 | 176 | 38.446859 | 140.927086 | 2020-12-06 05:26:18 | Miyagi, Japan | ||
3859854 | 3859854 | 2020-12-04 | Japan | Miyagi | 1272 | 10 | 1092 | 170 | 38.446859 | 140.927086 | 2020-12-05 05:27:36 | Miyagi, Japan | ||
75112 | 75112 | 2020-12-03 | Japan | Miyagi | 1251 | 10 | 1075 | 166 | 38.446859 | 140.927086 | 2020-12-04 05:27:27 | Miyagi, Japan | ||
738324 | 738324 | 2020-12-02 | Japan | Miyagi | 1230 | 10 | 1052 | 168 | 38.446859 | 140.927086 | 2020-12-03 05:28:22 | Miyagi, Japan | ||
2537418 | 2537418 | 2020-12-01 | Japan | Miyagi | 1221 | 10 | 1034 | 177 | 38.446859 | 140.927086 | 2020-12-02 05:27:41 | Miyagi, Japan | ||
1584187 | 1584187 | 2020-11-30 | Japan | Miyagi | 1210 | 10 | 1025 | 175 | 38.446859 | 140.927086 | 2020-12-01 05:26:18 | Miyagi, Japan | ||
3566590 | 3566590 | 2020-11-29 | Japan | Miyagi | 1201 | 10 | 997 | 194 | 38.446859 | 140.927086 | 2020-11-30 05:26:13 | Miyagi, Japan | ||
2935255 | 2935255 | 2020-11-28 | Japan | Miyagi | 1194 | 10 | 969 | 215 | 38.446859 | 140.927086 | 2020-11-29 05:25:55 | Miyagi, Japan | ||
392258 | 392258 | 2020-11-27 | Japan | Miyagi | 1181 | 10 | 945 | 226 | 38.446859 | 140.927086 | 2020-11-28 05:25:50 | Miyagi, Japan | ||
923705 | 923705 | 2020-11-26 | Japan | Miyagi | 1168 | 9 | 930 | 229 | 38.446859 | 140.927086 | 2020-11-27 05:26:53 | Miyagi, Japan | ||
1972610 | 1972610 | 2020-11-25 | Japan | Miyagi | 1147 | 9 | 914 | 224 | 38.446859 | 140.927086 | 2020-11-26 05:27:44 | Miyagi, Japan | ||
1350341 | 1350341 | 2020-11-24 | Japan | Miyagi | 1128 | 9 | 901 | 218 | 38.446859 | 140.927086 | 2020-11-25 05:27:20 | Miyagi, Japan | ||
678335 | 678335 | 2020-11-23 | Japan | Miyagi | 1116 | 9 | 887 | 220 | 38.446859 | 140.927086 | 2020-11-24 05:27:31 | Miyagi, Japan | ||
3190011 | 3190011 | 2020-11-22 | Japan | Miyagi | 1100 | 9 | 881 | 210 | 38.446859 | 140.927086 | 2020-11-23 05:25:26 | Miyagi, Japan | ||
3836505 | 3836505 | 2020-11-21 | Japan | Miyagi | 1091 | 9 | 863 | 219 | 38.446859 | 140.927086 | 2020-11-22 05:25:45 | Miyagi, Japan | ||
2701533 | 2701533 | 2020-11-20 | Japan | Miyagi | 1075 | 9 | 848 | 218 | 38.446859 | 140.927086 | 2020-11-21 05:25:51 | Miyagi, Japan | ||
821593 | 821593 | 2020-11-19 | Japan | Miyagi | 1061 | 9 | 829 | 223 | 38.446859 | 140.927086 | 2020-11-20 05:26:28 | Miyagi, Japan | ||
122727 | 122727 | 2020-11-18 | Japan | Miyagi | 1046 | 9 | 815 | 222 | 38.446859 | 140.927086 | 2020-11-19 05:25:23 | Miyagi, Japan | ||
3338615 | 3338615 | 2020-11-17 | Japan | Miyagi | 1027 | 8 | 807 | 212 | 38.446859 | 140.927086 | 2020-11-18 05:40:31 | Miyagi, Japan | ||
3169660 | 3169660 | 2020-11-16 | Japan | Miyagi | 995 | 8 | 789 | 198 | 38.446859 | 140.927086 | 2020-11-17 05:25:54 | Miyagi, Japan | ||
2880228 | 2880228 | 2020-11-15 | Japan | Miyagi | 988 | 8 | 778 | 202 | 38.446859 | 140.927086 | 2020-11-16 05:25:57 | Miyagi, Japan | ||
2915206 | 2915206 | 2020-11-14 | Japan | Miyagi | 983 | 8 | 752 | 223 | 38.446859 | 140.927086 | 2020-11-15 05:26:53 | Miyagi, Japan | ||
2785028 | 2785028 | 2020-11-13 | Japan | Miyagi | 973 | 8 | 733 | 232 | 38.446859 | 140.927086 | 2020-11-14 05:25:37 | Miyagi, Japan | ||
864793 | 864793 | 2020-11-12 | Japan | Miyagi | 943 | 8 | 704 | 231 | 38.446859 | 140.927086 | 2020-11-13 05:25:30 | Miyagi, Japan | ||
3440838 | 3440838 | 2020-11-11 | Japan | Miyagi | 925 | 6 | 677 | 242 | 38.446859 | 140.927086 | 2020-11-12 05:25:55 | Miyagi, Japan | ||
272178 | 272178 | 2020-11-10 | Japan | Miyagi | 892 | 6 | 652 | 234 | 38.446859 | 140.927086 | 2020-11-11 05:25:30 | Miyagi, Japan | ||
1988655 | 1988655 | 2020-11-09 | Japan | Miyagi | 872 | 6 | 634 | 232 | 38.446859 | 140.927086 | 2020-11-10 05:40:07 | Miyagi, Japan | ||
1728507 | 1728507 | 2020-11-08 | Japan | Miyagi | 865 | 5 | 616 | 244 | 38.446859 | 140.927086 | 2020-11-09 05:25:45 | Miyagi, Japan | ||
1543967 | 1543967 | 2020-11-07 | Japan | Miyagi | 852 | 4 | 597 | 251 | 38.446859 | 140.927086 | 2020-11-08 05:24:56 | Miyagi, Japan | ||
376205 | 376205 | 2020-11-06 | Japan | Miyagi | 834 | 3 | 573 | 258 | 38.446859 | 140.927086 | 2020-11-07 05:24:52 | Miyagi, Japan | ||
892143 | 892143 | 2020-11-05 | Japan | Miyagi | 821 | 3 | 567 | 251 | 38.446859 | 140.927086 | 2020-11-06 05:24:55 | Miyagi, Japan | ||
2919205 | 2919205 | 2020-11-04 | Japan | Miyagi | 803 | 3 | 559 | 241 | 38.446859 | 140.927086 | 2020-11-05 06:05:03 | Miyagi, Japan | ||
2498042 | 2498042 | 2020-11-03 | Japan | Miyagi | 787 | 2 | 553 | 232 | 38.446859 | 140.927086 | 2020-11-04 05:25:09 | Miyagi, Japan | ||
3304217 | 3304217 | 2020-11-02 | Japan | Miyagi | 771 | 2 | 548 | 221 | 38.446859 | 140.927086 | 2020-11-03 06:00:16 | Miyagi, Japan | ||
3409466 | 3409466 | 2020-11-01 | Japan | Miyagi | 742 | 2 | 544 | 196 | 38.446859 | 140.927086 | 2020-11-02 05:25:04 | Miyagi, Japan | ||
2079955 | 2079955 | 2020-10-31 | Japan | Miyagi | 726 | 2 | 538 | 186 | 38.446859 | 140.927086 | 2020-11-01 04:36:19 | Miyagi, Japan | ||
2243408 | 2243408 | 2020-10-30 | Japan | Miyagi | 700 | 2 | 535 | 163 | 38.446859 | 140.927086 | 2020-10-31 04:24:44 | Miyagi, Japan | ||
210263 | 210263 | 2020-10-29 | Japan | Miyagi | 689 | 2 | 528 | 159 | 38.446859 | 140.927086 | 2020-10-30 04:24:49 | Miyagi, Japan | ||
754325 | 754325 | 2020-10-28 | Japan | Miyagi | 679 | 2 | 523 | 154 | 38.446859 | 140.927086 | 2020-10-29 04:24:49 | Miyagi, Japan | ||
1452610 | 1452610 | 2020-10-27 | Japan | Miyagi | 655 | 2 | 516 | 137 | 38.446859 | 140.927086 | 2020-10-28 04:24:39 | Miyagi, Japan | ||
3480334 | 3480334 | 2020-10-26 | Japan | Miyagi | 610 | 2 | 509 | 99 | 38.446859 | 140.927086 | 2020-10-27 04:24:45 | Miyagi, Japan | ||
8355 | 8355 | 2020-10-25 | Japan | Miyagi | 602 | 2 | 504 | 96 | 38.446859 | 140.927086 | 2020-10-26 04:25:02 | Miyagi, Japan | ||
3651592 | 3651592 | 2020-10-24 | Japan | Miyagi | 572 | 2 | 499 | 71 | 38.446859 | 140.927086 | 2020-10-25 04:24:36 | Miyagi, Japan | ||
1053847 | 1053847 | 2020-10-23 | Japan | Miyagi | 565 | 2 | 497 | 66 | 38.446859 | 140.927086 | 2020-10-24 04:24:46 | Miyagi, Japan | ||
1177517 | 1177517 | 2020-10-22 | Japan | Miyagi | 545 | 2 | 491 | 52 | 38.446859 | 140.927086 | 2020-10-23 04:24:46 | Miyagi, Japan | ||
2191622 | 2191622 | 2020-10-21 | Japan | Miyagi | 544 | 2 | 487 | 55 | 38.446859 | 140.927086 | 2020-10-22 04:24:27 | Miyagi, Japan | ||
3990633 | 3990633 | 2020-10-20 | Japan | Miyagi | 538 | 2 | 482 | 54 | 38.446859 | 140.927086 | 2020-10-21 04:24:14 | Miyagi, Japan | ||
1794653 | 1794653 | 2020-10-19 | Japan | Miyagi | 529 | 2 | 479 | 48 | 38.446859 | 140.927086 | 2020-10-20 04:24:22 | Miyagi, Japan | ||
762337 | 762337 | 2020-10-18 | Japan | Miyagi | 526 | 2 | 463 | 61 | 38.446859 | 140.927086 | 2020-10-19 04:24:16 | Miyagi, Japan | ||
1026375 | 1026375 | 2020-10-17 | Japan | Miyagi | 524 | 2 | 463 | 59 | 38.446859 | 140.927086 | 2020-10-18 04:24:25 | Miyagi, Japan | ||
2856870 | 2856870 | 2020-10-16 | Japan | Miyagi | 522 | 2 | 461 | 59 | 38.446859 | 140.927086 | 2020-10-17 04:24:12 | Miyagi, Japan | ||
786400 | 786400 | 2020-10-15 | Japan | Miyagi | 508 | 2 | 452 | 54 | 38.446859 | 140.927086 | 2020-10-16 04:24:01 | Miyagi, Japan | ||
79111 | 79111 | 2020-10-14 | Japan | Miyagi | 504 | 2 | 442 | 60 | 38.446859 | 140.927086 | 2020-10-15 04:24:28 | Miyagi, Japan | ||
3781926 | 3781926 | 2020-10-13 | Japan | Miyagi | 499 | 2 | 427 | 70 | 38.446859 | 140.927086 | 2020-10-14 04:24:05 | Miyagi, Japan | ||
2291466 | 2291466 | 2020-10-12 | Japan | Miyagi | 491 | 2 | 420 | 69 | 38.446859 | 140.927086 | 2020-10-13 04:24:02 | Miyagi, Japan | ||
3785919 | 3785919 | 2020-10-11 | Japan | Miyagi | 486 | 2 | 414 | 70 | 38.446859 | 140.927086 | 2020-10-12 04:23:45 | Miyagi, Japan | ||
2602057 | 2602057 | 2020-10-10 | Japan | Miyagi | 484 | 2 | 410 | 72 | 38.446859 | 140.927086 | 2020-10-11 04:23:46 | Miyagi, Japan | ||
817590 | 817590 | 2020-10-09 | Japan | Miyagi | 474 | 2 | 398 | 74 | 38.446859 | 140.927086 | 2020-10-10 04:23:57 | Miyagi, Japan | ||
2689705 | 2689705 | 2020-10-08 | Japan | Miyagi | 461 | 2 | 394 | 65 | 38.446859 | 140.927086 | 2020-10-09 04:23:59 | Miyagi, Japan | ||
1041847 | 1041847 | 2020-10-07 | Japan | Miyagi | 453 | 2 | 388 | 63 | 38.446859 | 140.927086 | 2020-10-08 04:23:56 | Miyagi, Japan | ||
3117508 | 3117508 | 2020-10-06 | Japan | Miyagi | 441 | 2 | 377 | 62 | 38.446859 | 140.927086 | 2020-10-07 04:23:40 | Miyagi, Japan | ||
3801920 | 3801920 | 2020-10-05 | Japan | Miyagi | 433 | 2 | 376 | 55 | 38.446859 | 140.927086 | 2020-10-06 04:23:33 | Miyagi, Japan | ||
1822810 | 1822810 | 2020-10-04 | Japan | Miyagi | 428 | 2 | 372 | 54 | 38.446859 | 140.927086 | 2020-10-05 04:23:33 | Miyagi, 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]);