johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where province_or_state = "Saitama" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2016743 | 2016743 | 2022-09-20 | Japan | Saitama | 1161161 | 2336 | 0 | 35.997101 | 139.347635 | 2022-09-21 04:23:22 | Saitama, Japan | |||
3570616 | 3570616 | 2022-09-19 | Japan | Saitama | 1159378 | 2328 | 0 | 35.997101 | 139.347635 | 2022-09-20 04:22:48 | Saitama, Japan | |||
419355 | 419355 | 2022-09-18 | Japan | Saitama | 1156443 | 2328 | 0 | 35.997101 | 139.347635 | 2022-09-19 04:21:49 | Saitama, Japan | |||
3373379 | 3373379 | 2022-09-17 | Japan | Saitama | 1152256 | 2327 | 0 | 35.997101 | 139.347635 | 2022-09-18 04:22:50 | Saitama, Japan | |||
2355487 | 2355487 | 2022-09-16 | Japan | Saitama | 1147920 | 2320 | 0 | 35.997101 | 139.347635 | 2022-09-17 04:20:19 | Saitama, Japan | |||
3986644 | 3986644 | 2022-09-15 | Japan | Saitama | 1143138 | 2314 | 0 | 35.997101 | 139.347635 | 2022-09-16 04:21:19 | Saitama, Japan | |||
1889161 | 1889161 | 2022-09-14 | Japan | Saitama | 1137341 | 2304 | 0 | 35.997101 | 139.347635 | 2022-09-15 04:21:02 | Saitama, Japan | |||
372216 | 372216 | 2022-09-13 | Japan | Saitama | 1131303 | 2286 | 0 | 35.997101 | 139.347635 | 2022-09-14 04:20:44 | Saitama, Japan | |||
2394821 | 2394821 | 2022-09-12 | Japan | Saitama | 1128321 | 2268 | 0 | 35.997101 | 139.347635 | 2022-09-13 04:20:57 | Saitama, Japan | |||
3765899 | 3765899 | 2022-09-11 | Japan | Saitama | 1124635 | 2251 | 0 | 35.997101 | 139.347635 | 2022-09-12 04:20:58 | Saitama, Japan | |||
3824474 | 3824474 | 2022-09-10 | Japan | Saitama | 1119817 | 2248 | 0 | 35.997101 | 139.347635 | 2022-09-11 04:20:50 | Saitama, Japan | |||
962931 | 962931 | 2022-09-09 | Japan | Saitama | 1115164 | 2245 | 0 | 35.997101 | 139.347635 | 2022-09-10 04:21:10 | Saitama, Japan | |||
253333 | 253333 | 2022-09-08 | Japan | Saitama | 1109861 | 2216 | 0 | 35.997101 | 139.347635 | 2022-09-09 04:21:11 | Saitama, Japan | |||
3745131 | 3745131 | 2022-09-07 | Japan | Saitama | 1103912 | 2216 | 0 | 35.997101 | 139.347635 | 2022-09-08 04:21:02 | Saitama, Japan | |||
114771 | 114771 | 2022-09-06 | Japan | Saitama | 1097112 | 2198 | 0 | 35.997101 | 139.347635 | 2022-09-07 04:20:59 | Saitama, Japan | |||
2633743 | 2633743 | 2022-09-05 | Japan | Saitama | 1093644 | 2180 | 0 | 35.997101 | 139.347635 | 2022-09-06 04:21:02 | Saitama, Japan | |||
2987307 | 2987307 | 2022-09-04 | Japan | Saitama | 1089692 | 2163 | 0 | 35.997101 | 139.347635 | 2022-09-05 04:21:01 | Saitama, Japan | |||
2712992 | 2712992 | 2022-09-03 | Japan | Saitama | 1084089 | 2147 | 0 | 35.997101 | 139.347635 | 2022-09-04 04:21:22 | Saitama, Japan | |||
1393697 | 1393697 | 2022-09-02 | Japan | Saitama | 1078101 | 2129 | 0 | 35.997101 | 139.347635 | 2022-09-03 04:21:04 | Saitama, Japan | |||
3547526 | 3547526 | 2022-09-01 | Japan | Saitama | 1071897 | 2111 | 0 | 35.997101 | 139.347635 | 2022-09-02 04:21:07 | Saitama, Japan | |||
2343446 | 2343446 | 2022-08-31 | Japan | Saitama | 1064404 | 2093 | 0 | 35.997101 | 139.347635 | 2022-09-01 04:21:03 | Saitama, Japan | |||
3773926 | 3773926 | 2022-08-30 | Japan | Saitama | 1056228 | 2076 | 0 | 35.997101 | 139.347635 | 2022-08-31 04:20:57 | Saitama, Japan | |||
1680522 | 1680522 | 2022-08-29 | Japan | Saitama | 1051532 | 2061 | 0 | 35.997101 | 139.347635 | 2022-08-30 04:21:03 | Saitama, Japan | |||
1877006 | 1877006 | 2022-08-28 | Japan | Saitama | 1046114 | 2042 | 0 | 35.997101 | 139.347635 | 2022-08-29 04:21:06 | Saitama, Japan | |||
2096133 | 2096133 | 2022-08-27 | Japan | Saitama | 1038380 | 2025 | 0 | 35.997101 | 139.347635 | 2022-08-28 04:21:02 | Saitama, Japan | |||
1531948 | 1531948 | 2022-08-26 | Japan | Saitama | 1030503 | 2006 | 0 | 35.997101 | 139.347635 | 2022-08-27 04:20:57 | Saitama, Japan | |||
2828835 | 2828835 | 2022-08-25 | Japan | Saitama | 1021592 | 1987 | 0 | 35.997101 | 139.347635 | 2022-08-26 04:21:02 | Saitama, Japan | |||
2323368 | 2323368 | 2022-08-24 | Japan | Saitama | 1011490 | 1971 | 0 | 35.997101 | 139.347635 | 2022-08-25 04:21:13 | Saitama, Japan | |||
1250777 | 1250777 | 2022-08-23 | Japan | Saitama | 1000578 | 1952 | 0 | 35.997101 | 139.347635 | 2022-08-24 04:20:46 | Saitama, Japan | |||
2852881 | 2852881 | 2022-08-22 | Japan | Saitama | 994701 | 1933 | 0 | 35.997101 | 139.347635 | 2022-08-23 04:20:56 | Saitama, Japan | |||
2402853 | 2402853 | 2022-08-21 | Japan | Saitama | 986545 | 1914 | 0 | 35.997101 | 139.347635 | 2022-08-22 04:20:38 | Saitama, Japan | |||
3797931 | 3797931 | 2022-08-20 | Japan | Saitama | 975096 | 1898 | 0 | 35.997101 | 139.347635 | 2022-08-21 04:20:44 | Saitama, Japan | |||
2363517 | 2363517 | 2022-08-19 | Japan | Saitama | 963600 | 1883 | 0 | 35.997101 | 139.347635 | 2022-08-20 04:21:01 | Saitama, Japan | |||
1161188 | 1161188 | 2022-08-18 | Japan | Saitama | 952274 | 1864 | 0 | 35.997101 | 139.347635 | 2022-08-19 04:20:54 | Saitama, Japan | |||
3950512 | 3950512 | 2022-08-17 | Japan | Saitama | 941087 | 1852 | 0 | 35.997101 | 139.347635 | 2022-08-18 04:21:11 | Saitama, Japan | |||
991014 | 991014 | 2022-08-16 | Japan | Saitama | 931097 | 1839 | 0 | 35.997101 | 139.347635 | 2022-08-17 04:20:59 | Saitama, Japan | |||
2494053 | 2494053 | 2022-08-15 | Japan | Saitama | 925157 | 1827 | 0 | 35.997101 | 139.347635 | 2022-08-16 04:20:58 | Saitama, Japan | |||
3647603 | 3647603 | 2022-08-14 | Japan | Saitama | 918029 | 1815 | 0 | 35.997101 | 139.347635 | 2022-08-15 04:20:59 | Saitama, Japan | |||
1968609 | 1968609 | 2022-08-13 | Japan | Saitama | 908370 | 1802 | 0 | 35.997101 | 139.347635 | 2022-08-14 04:20:55 | Saitama, Japan | |||
2888418 | 2888418 | 2022-08-12 | Japan | Saitama | 901592 | 1790 | 0 | 35.997101 | 139.347635 | 2022-08-13 04:20:52 | Saitama, Japan | |||
3908023 | 3908023 | 2022-08-11 | Japan | Saitama | 891064 | 1778 | 0 | 35.997101 | 139.347635 | 2022-08-12 04:20:54 | Saitama, Japan | |||
1346340 | 1346340 | 2022-08-10 | Japan | Saitama | 877632 | 1769 | 0 | 35.997101 | 139.347635 | 2022-08-11 04:20:49 | Saitama, Japan | |||
1086095 | 1086095 | 2022-08-09 | Japan | Saitama | 864599 | 1758 | 0 | 35.997101 | 139.347635 | 2022-08-10 04:20:57 | Saitama, Japan | |||
3543510 | 3543510 | 2022-08-08 | Japan | Saitama | 857516 | 1748 | 0 | 35.997101 | 139.347635 | 2022-08-09 04:20:34 | Saitama, Japan | |||
1069913 | 1069913 | 2022-08-07 | Japan | Saitama | 848684 | 1737 | 0 | 35.997101 | 139.347635 | 2022-08-08 04:21:08 | Saitama, Japan | |||
1940501 | 1940501 | 2022-08-06 | Japan | Saitama | 835677 | 1729 | 0 | 35.997101 | 139.347635 | 2022-08-07 04:20:54 | Saitama, Japan | |||
880300 | 880300 | 2022-08-05 | Japan | Saitama | 822800 | 1720 | 0 | 35.997101 | 139.347635 | 2022-08-06 04:20:56 | Saitama, Japan | |||
2008711 | 2008711 | 2022-08-04 | Japan | Saitama | 808809 | 1708 | 0 | 35.997101 | 139.347635 | 2022-08-05 04:20:52 | Saitama, Japan | |||
1098138 | 1098138 | 2022-08-03 | Japan | Saitama | 794988 | 1699 | 0 | 35.997101 | 139.347635 | 2022-08-04 04:20:58 | Saitama, Japan | |||
1405063 | 1405063 | 2022-08-02 | Japan | Saitama | 781209 | 1690 | 0 | 35.997101 | 139.347635 | 2022-08-03 04:20:59 | Saitama, Japan | |||
3617101 | 3617101 | 2022-08-01 | Japan | Saitama | 773943 | 1687 | 0 | 35.997101 | 139.347635 | 2022-08-02 04:20:53 | Saitama, Japan | |||
3871581 | 3871581 | 2022-07-31 | Japan | Saitama | 764129 | 1682 | 0 | 35.997101 | 139.347635 | 2022-08-01 04:21:03 | Saitama, Japan | |||
674335 | 674335 | 2022-07-30 | Japan | Saitama | 750438 | 1680 | 0 | 35.997101 | 139.347635 | 2022-07-31 04:21:02 | Saitama, Japan | |||
1783534 | 1783534 | 2022-07-29 | Japan | Saitama | 737671 | 1678 | 0 | 35.997101 | 139.347635 | 2022-07-30 04:20:42 | Saitama, Japan | |||
1065897 | 1065897 | 2022-07-28 | Japan | Saitama | 724521 | 1673 | 0 | 35.997101 | 139.347635 | 2022-07-29 04:20:45 | Saitama, Japan | |||
2335416 | 2335416 | 2022-07-27 | Japan | Saitama | 711464 | 1671 | 0 | 35.997101 | 139.347635 | 2022-07-28 04:20:56 | Saitama, Japan | |||
1487606 | 1487606 | 2022-07-26 | Japan | Saitama | 698572 | 1670 | 0 | 35.997101 | 139.347635 | 2022-07-27 04:21:04 | Saitama, Japan | |||
2594052 | 2594052 | 2022-07-25 | Japan | Saitama | 691570 | 1669 | 0 | 35.997101 | 139.347635 | 2022-07-26 04:20:58 | Saitama, Japan | |||
896167 | 896167 | 2022-07-24 | Japan | Saitama | 682310 | 1669 | 0 | 35.997101 | 139.347635 | 2022-07-25 04:20:51 | Saitama, Japan | |||
91161 | 91161 | 2022-07-23 | Japan | Saitama | 670125 | 1669 | 0 | 35.997101 | 139.347635 | 2022-07-24 04:20:47 | Saitama, Japan | |||
900183 | 900183 | 2022-07-22 | Japan | Saitama | 657701 | 1669 | 0 | 35.997101 | 139.347635 | 2022-07-23 04:20:53 | Saitama, Japan | |||
670319 | 670319 | 2022-07-21 | Japan | Saitama | 646104 | 1669 | 0 | 35.997101 | 139.347635 | 2022-07-22 04:21:15 | Saitama, Japan | |||
1608282 | 1608282 | 2022-07-20 | Japan | Saitama | 635282 | 1669 | 0 | 35.997101 | 139.347635 | 2022-07-21 04:21:10 | Saitama, Japan | |||
958915 | 958915 | 2022-07-19 | Japan | Saitama | 630471 | 1669 | 0 | 35.997101 | 139.347635 | 2022-07-20 04:20:59 | Saitama, Japan | |||
3210302 | 3210302 | 2022-07-18 | Japan | Saitama | 627091 | 1669 | 0 | 35.997101 | 139.347635 | 2022-07-19 04:20:58 | Saitama, Japan | |||
3405477 | 3405477 | 2022-07-17 | Japan | Saitama | 621452 | 1669 | 0 | 35.997101 | 139.347635 | 2022-07-18 04:20:59 | Saitama, Japan | |||
2151677 | 2151677 | 2022-07-16 | Japan | Saitama | 614906 | 1669 | 0 | 35.997101 | 139.347635 | 2022-07-17 04:21:15 | Saitama, Japan | |||
2418910 | 2418910 | 2022-07-15 | Japan | Saitama | 608791 | 1668 | 0 | 35.997101 | 139.347635 | 2022-07-16 04:21:05 | Saitama, Japan | |||
3428985 | 3428985 | 2022-07-14 | Japan | Saitama | 603038 | 1667 | 0 | 35.997101 | 139.347635 | 2022-07-15 04:20:53 | Saitama, Japan | |||
3109505 | 3109505 | 2022-07-13 | Japan | Saitama | 597288 | 1667 | 0 | 35.997101 | 139.347635 | 2022-07-14 04:20:57 | Saitama, Japan | |||
629928 | 629928 | 2022-07-12 | Japan | Saitama | 592286 | 1667 | 0 | 35.997101 | 139.347635 | 2022-07-13 04:20:58 | Saitama, Japan | |||
1211572 | 1211572 | 2022-07-11 | Japan | Saitama | 589936 | 1667 | 0 | 35.997101 | 139.347635 | 2022-07-12 04:20:51 | Saitama, Japan | |||
2789054 | 2789054 | 2022-07-10 | Japan | Saitama | 587507 | 1667 | 0 | 35.997101 | 139.347635 | 2022-07-11 04:20:46 | Saitama, Japan | |||
142007 | 142007 | 2022-07-09 | Japan | Saitama | 584565 | 1667 | 0 | 35.997101 | 139.347635 | 2022-07-10 04:20:54 | Saitama, Japan | |||
1417107 | 1417107 | 2022-07-08 | Japan | Saitama | 582019 | 1666 | 0 | 35.997101 | 139.347635 | 2022-07-09 04:20:59 | Saitama, Japan | |||
2741032 | 2741032 | 2022-07-07 | Japan | Saitama | 579738 | 1665 | 0 | 35.997101 | 139.347635 | 2022-07-08 04:20:56 | Saitama, Japan | |||
1199827 | 1199827 | 2022-07-06 | Japan | Saitama | 577304 | 1665 | 0 | 35.997101 | 139.347635 | 2022-07-07 04:20:55 | Saitama, Japan | |||
3966570 | 3966570 | 2022-07-05 | Japan | Saitama | 575261 | 1665 | 0 | 35.997101 | 139.347635 | 2022-07-06 04:20:58 | Saitama, Japan | |||
3078081 | 3078081 | 2022-07-04 | Japan | Saitama | 574172 | 1665 | 0 | 35.997101 | 139.347635 | 2022-07-05 04:20:45 | Saitama, Japan | |||
1767363 | 1767363 | 2022-07-03 | Japan | Saitama | 573260 | 1665 | 0 | 35.997101 | 139.347635 | 2022-07-04 04:20:54 | Saitama, Japan | |||
3365349 | 3365349 | 2022-07-02 | Japan | Saitama | 572028 | 1665 | 0 | 35.997101 | 139.347635 | 2022-07-03 04:20:59 | Saitama, Japan | |||
593678 | 593678 | 2022-07-01 | Japan | Saitama | 570808 | 1664 | 0 | 35.997101 | 139.347635 | 2022-07-02 04:21:16 | Saitama, Japan | |||
3940079 | 3940079 | 2022-06-30 | Japan | Saitama | 569675 | 1663 | 0 | 35.997101 | 139.347635 | 2022-07-01 04:21:10 | Saitama, Japan | |||
2490037 | 2490037 | 2022-06-29 | Japan | Saitama | 568503 | 1663 | 0 | 35.997101 | 139.347635 | 2022-06-30 04:21:01 | Saitama, Japan | |||
2239419 | 2239419 | 2022-06-28 | Japan | Saitama | 567478 | 1662 | 0 | 35.997101 | 139.347635 | 2022-06-29 04:20:59 | Saitama, Japan | |||
2147661 | 2147661 | 2022-06-27 | Japan | Saitama | 567000 | 1660 | 0 | 35.997101 | 139.347635 | 2022-06-28 04:20:58 | Saitama, Japan | |||
475462 | 475462 | 2022-06-26 | Japan | Saitama | 566504 | 1660 | 0 | 35.997101 | 139.347635 | 2022-06-27 04:21:00 | Saitama, Japan | |||
938837 | 938837 | 2022-06-25 | Japan | Saitama | 565811 | 1660 | 0 | 35.997101 | 139.347635 | 2022-06-26 04:21:02 | Saitama, Japan | |||
3346657 | 3346657 | 2022-06-24 | Japan | Saitama | 565164 | 1660 | 0 | 35.997101 | 139.347635 | 2022-06-25 04:20:57 | Saitama, Japan | |||
1648398 | 1648398 | 2022-06-23 | Japan | Saitama | 564474 | 1658 | 0 | 35.997101 | 139.347635 | 2022-06-24 04:20:58 | Saitama, Japan | |||
2187633 | 2187633 | 2022-06-22 | Japan | Saitama | 563704 | 1658 | 0 | 35.997101 | 139.347635 | 2022-06-23 04:20:55 | Saitama, Japan | |||
166064 | 166064 | 2022-06-21 | Japan | Saitama | 562924 | 1655 | 0 | 35.997101 | 139.347635 | 2022-06-22 04:20:54 | Saitama, Japan | |||
1763347 | 1763347 | 2022-06-20 | Japan | Saitama | 562445 | 1655 | 0 | 35.997101 | 139.347635 | 2022-06-21 04:20:56 | Saitama, Japan | |||
3269533 | 3269533 | 2022-06-19 | Japan | Saitama | 562032 | 1653 | 0 | 35.997101 | 139.347635 | 2022-06-20 04:21:01 | Saitama, Japan | |||
3397445 | 3397445 | 2022-06-18 | Japan | Saitama | 561397 | 1653 | 0 | 35.997101 | 139.347635 | 2022-06-19 04:20:51 | Saitama, Japan | |||
2311322 | 2311322 | 2022-06-17 | Japan | Saitama | 560792 | 1650 | 0 | 35.997101 | 139.347635 | 2022-06-18 04:21:10 | Saitama, Japan | |||
558826 | 558826 | 2022-06-16 | Japan | Saitama | 560182 | 1646 | 0 | 35.997101 | 139.347635 | 2022-06-17 04:20:56 | Saitama, Japan | |||
3982628 | 3982628 | 2022-06-15 | Japan | Saitama | 559477 | 1643 | 0 | 35.997101 | 139.347635 | 2022-06-16 04:20:55 | Saitama, Japan | |||
946869 | 946869 | 2022-06-14 | Japan | Saitama | 558806 | 1642 | 0 | 35.997101 | 139.347635 | 2022-06-15 04:20:54 | Saitama, Japan | |||
2979277 | 2979277 | 2022-06-13 | Japan | Saitama | 558361 | 1642 | 0 | 35.997101 | 139.347635 | 2022-06-14 04:20:52 | Saitama, 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]);