johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
125 rows where country_or_region = "Japan" and "last_update" is on date 2022-11-22 sorted by longitude
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
country_or_region 1
- Japan · 125 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude ▼ | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
217997 | 217997 | 2022-12-26 | Japan | Port Quarantine | 22118 | 8 | 0 | 2022-11-22 23:21:06 | Port Quarantine, Japan | |||||
218008 | 218008 | 2022-12-26 | Japan | Unknown | 173 | 0 | 0 | 2022-11-22 23:21:06 | Unknown, Japan | |||||
257347 | 257347 | 2022-12-10 | Japan | Port Quarantine | 22118 | 8 | 0 | 2022-11-22 23:21:06 | Port Quarantine, Japan | |||||
257358 | 257358 | 2022-12-10 | Japan | Unknown | 173 | 0 | 0 | 2022-11-22 23:21:06 | Unknown, Japan | |||||
307902 | 307902 | 2022-12-13 | Japan | Port Quarantine | 22118 | 8 | 0 | 2022-11-22 23:21:06 | Port Quarantine, Japan | |||||
307913 | 307913 | 2022-12-13 | Japan | Unknown | 173 | 0 | 0 | 2022-11-22 23:21:06 | Unknown, Japan | |||||
327924 | 327924 | 2022-12-27 | Japan | Port Quarantine | 22118 | 8 | 0 | 2022-11-22 23:21:06 | Port Quarantine, Japan | |||||
327935 | 327935 | 2022-12-27 | Japan | Unknown | 173 | 0 | 0 | 2022-11-22 23:21:06 | Unknown, Japan | |||||
348314 | 348314 | 2022-12-14 | Japan | Port Quarantine | 22118 | 8 | 0 | 2022-11-22 23:21:06 | Port Quarantine, Japan | |||||
348325 | 348325 | 2022-12-14 | Japan | Unknown | 173 | 0 | 0 | 2022-11-22 23:21:06 | Unknown, Japan | |||||
451405 | 451405 | 2022-12-21 | Japan | Port Quarantine | 22118 | 8 | 0 | 2022-11-22 23:21:06 | Port Quarantine, Japan | |||||
451416 | 451416 | 2022-12-21 | Japan | Unknown | 173 | 0 | 0 | 2022-11-22 23:21:06 | Unknown, Japan | |||||
487638 | 487638 | 2022-11-25 | Japan | Port Quarantine | 22118 | 8 | 0 | 2022-11-22 23:21:06 | Port Quarantine, Japan | |||||
487649 | 487649 | 2022-11-25 | Japan | Unknown | 173 | 0 | 0 | 2022-11-22 23:21:06 | Unknown, Japan | |||||
503702 | 503702 | 2022-12-17 | Japan | Port Quarantine | 22118 | 8 | 0 | 2022-11-22 23:21:06 | Port Quarantine, Japan | |||||
503713 | 503713 | 2022-12-17 | Japan | Unknown | 173 | 0 | 0 | 2022-11-22 23:21:06 | Unknown, Japan | |||||
542786 | 542786 | 2022-12-15 | Japan | Port Quarantine | 22118 | 8 | 0 | 2022-11-22 23:21:06 | Port Quarantine, Japan | |||||
542797 | 542797 | 2022-12-15 | Japan | Unknown | 173 | 0 | 0 | 2022-11-22 23:21:06 | Unknown, Japan | |||||
690391 | 690391 | 2022-12-23 | Japan | Port Quarantine | 22118 | 8 | 0 | 2022-11-22 23:21:06 | Port Quarantine, Japan | |||||
690402 | 690402 | 2022-12-23 | Japan | Unknown | 173 | 0 | 0 | 2022-11-22 23:21:06 | Unknown, Japan | |||||
718500 | 718500 | 2022-12-04 | Japan | Port Quarantine | 22118 | 8 | 0 | 2022-11-22 23:21:06 | Port Quarantine, Japan | |||||
718511 | 718511 | 2022-12-04 | Japan | Unknown | 173 | 0 | 0 | 2022-11-22 23:21:06 | Unknown, Japan | |||||
833645 | 833645 | 2022-12-02 | Japan | Port Quarantine | 22118 | 8 | 0 | 2022-11-22 23:21:06 | Port Quarantine, Japan | |||||
833656 | 833656 | 2022-12-02 | Japan | Unknown | 173 | 0 | 0 | 2022-11-22 23:21:06 | Unknown, Japan | |||||
868817 | 868817 | 2022-12-11 | Japan | Port Quarantine | 22118 | 8 | 0 | 2022-11-22 23:21:06 | Port Quarantine, Japan | |||||
868828 | 868828 | 2022-12-11 | Japan | Unknown | 173 | 0 | 0 | 2022-11-22 23:21:06 | Unknown, Japan | |||||
1018368 | 1018368 | 2022-12-24 | Japan | Port Quarantine | 22118 | 8 | 0 | 2022-11-22 23:21:06 | Port Quarantine, Japan | |||||
1018379 | 1018379 | 2022-12-24 | Japan | Unknown | 173 | 0 | 0 | 2022-11-22 23:21:06 | Unknown, Japan | |||||
1073927 | 1073927 | 2022-12-28 | Japan | Port Quarantine | 22118 | 8 | 0 | 2022-11-22 23:21:06 | Port Quarantine, Japan | |||||
1073938 | 1073938 | 2022-12-28 | Japan | Unknown | 173 | 0 | 0 | 2022-11-22 23:21:06 | Unknown, Japan | |||||
1148963 | 1148963 | 2022-12-12 | Japan | Port Quarantine | 22118 | 8 | 0 | 2022-11-22 23:21:06 | Port Quarantine, Japan | |||||
1148974 | 1148974 | 2022-12-12 | Japan | Unknown | 173 | 0 | 0 | 2022-11-22 23:21:06 | Unknown, Japan | |||||
1239679 | 1239679 | 2022-11-28 | Japan | Port Quarantine | 22118 | 8 | 0 | 2022-11-22 23:21:06 | Port Quarantine, Japan | |||||
1239690 | 1239690 | 2022-11-28 | Japan | Unknown | 173 | 0 | 0 | 2022-11-22 23:21:06 | Unknown, Japan | |||||
1620291 | 1620291 | 2022-11-22 | Japan | Port Quarantine | 22118 | 8 | 0 | 2022-11-22 23:21:06 | Port Quarantine, Japan | |||||
1620302 | 1620302 | 2022-11-22 | Japan | Unknown | 173 | 0 | 0 | 2022-11-22 23:21:06 | Unknown, Japan | |||||
1628323 | 1628323 | 2022-12-18 | Japan | Port Quarantine | 22118 | 8 | 0 | 2022-11-22 23:21:06 | Port Quarantine, Japan | |||||
1628334 | 1628334 | 2022-12-18 | Japan | Unknown | 173 | 0 | 0 | 2022-11-22 23:21:06 | Unknown, Japan | |||||
1964591 | 1964591 | 2022-11-30 | Japan | Port Quarantine | 22118 | 8 | 0 | 2022-11-22 23:21:06 | Port Quarantine, Japan | |||||
1964602 | 1964602 | 2022-11-30 | Japan | Unknown | 173 | 0 | 0 | 2022-11-22 23:21:06 | Unknown, Japan | |||||
1984664 | 1984664 | 2022-12-07 | Japan | Port Quarantine | 22118 | 8 | 0 | 2022-11-22 23:21:06 | Port Quarantine, Japan | |||||
1984675 | 1984675 | 2022-12-07 | Japan | Unknown | 173 | 0 | 0 | 2022-11-22 23:21:06 | Unknown, Japan | |||||
2100147 | 2100147 | 2022-11-26 | Japan | Port Quarantine | 22118 | 8 | 0 | 2022-11-22 23:21:06 | Port Quarantine, Japan | |||||
2100158 | 2100158 | 2022-11-26 | Japan | Unknown | 173 | 0 | 0 | 2022-11-22 23:21:06 | Unknown, Japan | |||||
2136175 | 2136175 | 2022-12-01 | Japan | Port Quarantine | 22118 | 8 | 0 | 2022-11-22 23:21:06 | Port Quarantine, Japan | |||||
2136186 | 2136186 | 2022-12-01 | Japan | Unknown | 173 | 0 | 0 | 2022-11-22 23:21:06 | Unknown, Japan | |||||
2179601 | 2179601 | 2022-12-22 | Japan | Port Quarantine | 22118 | 8 | 0 | 2022-11-22 23:21:06 | Port Quarantine, Japan | |||||
2179612 | 2179612 | 2022-12-22 | Japan | Unknown | 173 | 0 | 0 | 2022-11-22 23:21:06 | Unknown, Japan | |||||
2414892 | 2414892 | 2022-12-05 | Japan | Port Quarantine | 22118 | 8 | 0 | 2022-11-22 23:21:06 | Port Quarantine, Japan | |||||
2414903 | 2414903 | 2022-12-05 | Japan | Unknown | 173 | 0 | 0 | 2022-11-22 23:21:06 | Unknown, Japan | |||||
2556605 | 2556605 | 2022-11-29 | Japan | Port Quarantine | 22118 | 8 | 0 | 2022-11-22 23:21:06 | Port Quarantine, Japan | |||||
2556616 | 2556616 | 2022-11-29 | Japan | Unknown | 173 | 0 | 0 | 2022-11-22 23:21:06 | Unknown, Japan | |||||
2752921 | 2752921 | 2022-12-29 | Japan | Port Quarantine | 22118 | 8 | 0 | 2022-11-22 23:21:06 | Port Quarantine, Japan | |||||
2752932 | 2752932 | 2022-12-29 | Japan | Unknown | 173 | 0 | 0 | 2022-11-22 23:21:06 | Unknown, Japan | |||||
2816789 | 2816789 | 2022-12-03 | Japan | Port Quarantine | 22118 | 8 | 0 | 2022-11-22 23:21:06 | Port Quarantine, Japan | |||||
2816800 | 2816800 | 2022-12-03 | Japan | Unknown | 173 | 0 | 0 | 2022-11-22 23:21:06 | Unknown, Japan | |||||
2951404 | 2951404 | 2022-12-20 | Japan | Port Quarantine | 22118 | 8 | 0 | 2022-11-22 23:21:06 | Port Quarantine, Japan | |||||
2951415 | 2951415 | 2022-12-20 | Japan | Unknown | 173 | 0 | 0 | 2022-11-22 23:21:06 | Unknown, Japan | |||||
3173806 | 3173806 | 2022-12-19 | Japan | Port Quarantine | 22118 | 8 | 0 | 2022-11-22 23:21:06 | Port Quarantine, Japan | |||||
3173817 | 3173817 | 2022-12-19 | Japan | Unknown | 173 | 0 | 0 | 2022-11-22 23:21:06 | Unknown, Japan | |||||
3222454 | 3222454 | 2022-12-25 | Japan | Port Quarantine | 22118 | 8 | 0 | 2022-11-22 23:21:06 | Port Quarantine, Japan | |||||
3222465 | 3222465 | 2022-12-25 | Japan | Unknown | 173 | 0 | 0 | 2022-11-22 23:21:06 | Unknown, Japan | |||||
3312250 | 3312250 | 2022-11-23 | Japan | Port Quarantine | 22118 | 8 | 0 | 2022-11-22 23:21:06 | Port Quarantine, Japan | |||||
3312261 | 3312261 | 2022-11-23 | Japan | Unknown | 173 | 0 | 0 | 2022-11-22 23:21:06 | Unknown, Japan | |||||
3324274 | 3324274 | 2022-12-16 | Japan | Port Quarantine | 22118 | 8 | 0 | 2022-11-22 23:21:06 | Port Quarantine, Japan | |||||
3324285 | 3324285 | 2022-12-16 | Japan | Unknown | 173 | 0 | 0 | 2022-11-22 23:21:06 | Unknown, Japan | |||||
3377393 | 3377393 | 2022-12-08 | Japan | Port Quarantine | 22118 | 8 | 0 | 2022-11-22 23:21:06 | Port Quarantine, Japan | |||||
3377404 | 3377404 | 2022-12-08 | Japan | Unknown | 173 | 0 | 0 | 2022-11-22 23:21:06 | Unknown, Japan | |||||
3460179 | 3460179 | 2022-11-21 | Japan | Port Quarantine | 22118 | 8 | 0 | 2022-11-22 04:20:47 | Port Quarantine, Japan | |||||
3460190 | 3460190 | 2022-11-21 | Japan | Unknown | 173 | 0 | 0 | 2022-11-22 04:20:47 | Unknown, Japan | |||||
3523467 | 3523467 | 2022-11-24 | Japan | Port Quarantine | 22118 | 8 | 0 | 2022-11-22 23:21:06 | Port Quarantine, Japan | |||||
3523478 | 3523478 | 2022-11-24 | Japan | Unknown | 173 | 0 | 0 | 2022-11-22 23:21:06 | Unknown, Japan | |||||
3551667 | 3551667 | 2022-11-27 | Japan | Port Quarantine | 22118 | 8 | 0 | 2022-11-22 23:21:06 | Port Quarantine, Japan | |||||
3551678 | 3551678 | 2022-11-27 | Japan | Unknown | 173 | 0 | 0 | 2022-11-22 23:21:06 | Unknown, Japan | |||||
3714187 | 3714187 | 2022-12-06 | Japan | Port Quarantine | 22118 | 8 | 0 | 2022-11-22 23:21:06 | Port Quarantine, Japan | |||||
3714198 | 3714198 | 2022-12-06 | Japan | Unknown | 173 | 0 | 0 | 2022-11-22 23:21:06 | Unknown, Japan | |||||
3936061 | 3936061 | 2022-12-09 | Japan | Port Quarantine | 22118 | 8 | 0 | 2022-11-22 23:21:06 | Port Quarantine, Japan | |||||
3936072 | 3936072 | 2022-12-09 | Japan | Unknown | 173 | 0 | 0 | 2022-11-22 23:21:06 | Unknown, Japan | |||||
3460177 | 3460177 | 2022-11-21 | Japan | Okinawa | 515421 | 812 | 0 | 25.768923 | 126.668016 | 2022-11-22 04:20:47 | Okinawa, Japan | |||
3460172 | 3460172 | 2022-11-21 | Japan | Nagasaki | 230852 | 345 | 0 | 33.235712 | 129.608033 | 2022-11-22 04:20:47 | Nagasaki, Japan | |||
3460180 | 3460180 | 2022-11-21 | Japan | Saga | 171477 | 253 | 0 | 33.286977 | 130.115738 | 2022-11-22 04:20:47 | Saga, Japan | |||
3460163 | 3460163 | 2022-11-21 | Japan | Kagoshima | 316022 | 556 | 0 | 31.009484 | 130.430665 | 2022-11-22 04:20:47 | Kagoshima, Japan | |||
3460152 | 3460152 | 2022-11-21 | Japan | Fukuoka | 1147325 | 2071 | 0 | 33.526032 | 130.666949 | 2022-11-22 04:20:47 | Fukuoka, Japan | |||
3460166 | 3460166 | 2022-11-21 | Japan | Kumamoto | 358958 | 679 | 0 | 32.608154 | 130.745231 | 2022-11-22 04:20:47 | Kumamoto, Japan | |||
3460170 | 3460170 | 2022-11-21 | Japan | Miyazaki | 210669 | 397 | 0 | 32.193204 | 131.299374 | 2022-11-22 04:20:47 | Miyazaki, Japan | |||
3460175 | 3460175 | 2022-11-21 | Japan | Oita | 193367 | 400 | 0 | 33.200697 | 131.43324 | 2022-11-22 04:20:47 | Oita, Japan | |||
3460193 | 3460193 | 2022-11-21 | Japan | Yamaguchi | 188721 | 412 | 0 | 34.20119 | 131.573293 | 2022-11-22 04:20:47 | Yamaguchi, Japan | |||
3460183 | 3460183 | 2022-11-21 | Japan | Shimane | 99698 | 108 | 0 | 35.07076 | 132.554064 | 2022-11-22 04:20:47 | Shimane, Japan | |||
3460156 | 3460156 | 2022-11-21 | Japan | Hiroshima | 505999 | 830 | 0 | 34.605309 | 132.788719 | 2022-11-22 04:20:47 | Hiroshima, Japan | |||
3460150 | 3460150 | 2022-11-21 | Japan | Ehime | 185739 | 313 | 0 | 33.624835 | 132.856842 | 2022-11-22 04:20:47 | Ehime, Japan | |||
3460165 | 3460165 | 2022-11-21 | Japan | Kochi | 109453 | 318 | 0 | 33.422519 | 133.367307 | 2022-11-22 04:20:47 | Kochi, Japan | |||
3460176 | 3460176 | 2022-11-21 | Japan | Okayama | 315179 | 444 | 0 | 34.89246 | 133.826252 | 2022-11-22 04:20:47 | Okayama, Japan | |||
3460188 | 3460188 | 2022-11-21 | Japan | Tottori | 76493 | 99 | 0 | 35.359069 | 133.863619 | 2022-11-22 04:20:47 | Tottori, Japan | |||
3460162 | 3460162 | 2022-11-21 | Japan | Kagawa | 162428 | 316 | 0 | 34.217292 | 133.969047 | 2022-11-22 04:20:47 | Kagawa, Japan | |||
3460186 | 3460186 | 2022-11-21 | Japan | Tokushima | 104213 | 196 | 0 | 33.919178 | 134.242091 | 2022-11-22 04:20:47 | Tokushima, Japan | |||
3460158 | 3460158 | 2022-11-21 | Japan | Hyogo | 1084158 | 2963 | 0 | 35.039913 | 134.828057 | 2022-11-22 04:20:47 | Hyogo, Japan | |||
3460167 | 3460167 | 2022-11-21 | Japan | Kyoto | 512190 | 1144 | 0 | 35.253815 | 135.443341 | 2022-11-22 04:20:47 | Kyoto, Japan | |||
3460191 | 3460191 | 2022-11-21 | Japan | Wakayama | 152923 | 279 | 0 | 33.911879 | 135.505446 | 2022-11-22 04:20:47 | Wakayama, Japan | |||
3460178 | 3460178 | 2022-11-21 | Japan | Osaka | 2241784 | 6698 | 0 | 34.620965 | 135.507481 | 2022-11-22 04:20:47 | Osaka, Japan | |||
3460173 | 3460173 | 2022-11-21 | Japan | Nara | 248684 | 572 | 0 | 34.317451 | 135.871644 | 2022-11-22 04:20:47 | Nara, 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]);