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 = "Nagasaki" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2533408 | 2533408 | 2022-05-12 | Japan | Nagasaki | 51731 | 124 | 0 | 33.235712 | 129.608033 | 2022-05-13 04:20:51 | Nagasaki, Japan | |||
3444854 | 3444854 | 2022-05-11 | Japan | Nagasaki | 51251 | 124 | 0 | 33.235712 | 129.608033 | 2022-05-12 04:20:54 | Nagasaki, Japan | |||
3535471 | 3535471 | 2022-05-10 | Japan | Nagasaki | 50682 | 124 | 0 | 33.235712 | 129.608033 | 2022-05-11 04:20:48 | Nagasaki, Japan | |||
222006 | 222006 | 2022-05-09 | Japan | Nagasaki | 50178 | 123 | 0 | 33.235712 | 129.608033 | 2022-05-10 04:20:50 | Nagasaki, Japan | |||
2331391 | 2331391 | 2022-05-08 | Japan | Nagasaki | 49845 | 123 | 0 | 33.235712 | 129.608033 | 2022-05-09 04:20:54 | Nagasaki, Japan | |||
360353 | 360353 | 2022-05-07 | Japan | Nagasaki | 49260 | 123 | 0 | 33.235712 | 129.608033 | 2022-05-08 04:20:49 | Nagasaki, Japan | |||
1397704 | 1397704 | 2022-05-06 | Japan | Nagasaki | 48683 | 123 | 0 | 33.235712 | 129.608033 | 2022-05-07 04:21:09 | Nagasaki, Japan | |||
2598059 | 2598059 | 2022-05-05 | Japan | Nagasaki | 48481 | 123 | 0 | 33.235712 | 129.608033 | 2022-05-06 04:21:00 | Nagasaki, Japan | |||
3265508 | 3265508 | 2022-05-04 | Japan | Nagasaki | 48252 | 122 | 0 | 33.235712 | 129.608033 | 2022-05-05 04:20:55 | Nagasaki, Japan | |||
1572147 | 1572147 | 2022-05-03 | Japan | Nagasaki | 47891 | 122 | 0 | 33.235712 | 129.608033 | 2022-05-04 04:20:59 | Nagasaki, Japan | |||
463407 | 463407 | 2022-05-02 | Japan | Nagasaki | 47479 | 122 | 0 | 33.235712 | 129.608033 | 2022-05-03 04:21:00 | Nagasaki, Japan | |||
3916046 | 3916046 | 2022-05-01 | Japan | Nagasaki | 47269 | 121 | 0 | 33.235712 | 129.608033 | 2022-05-02 04:21:10 | Nagasaki, Japan | |||
2840850 | 2840850 | 2022-04-30 | Japan | Nagasaki | 46928 | 121 | 0 | 33.235712 | 129.608033 | 2022-05-01 04:20:57 | Nagasaki, Japan | |||
1157163 | 1157163 | 2022-04-29 | Japan | Nagasaki | 46627 | 121 | 0 | 33.235712 | 129.608033 | 2022-04-30 04:21:05 | Nagasaki, Japan | |||
1696345 | 1696345 | 2022-04-28 | Japan | Nagasaki | 46127 | 120 | 0 | 33.235712 | 129.608033 | 2022-04-29 04:20:59 | Nagasaki, Japan | |||
3851828 | 3851828 | 2022-04-27 | Japan | Nagasaki | 45463 | 120 | 0 | 33.235712 | 129.608033 | 2022-04-28 04:20:47 | Nagasaki, Japan | |||
1326258 | 1326258 | 2022-04-26 | Japan | Nagasaki | 44785 | 120 | 0 | 33.235712 | 129.608033 | 2022-04-27 04:20:52 | Nagasaki, Japan | |||
3722212 | 3722212 | 2022-04-25 | Japan | Nagasaki | 44162 | 120 | 0 | 33.235712 | 129.608033 | 2022-04-26 04:20:51 | Nagasaki, Japan | |||
2028780 | 2028780 | 2022-04-24 | Japan | Nagasaki | 43878 | 120 | 0 | 33.235712 | 129.608033 | 2022-04-25 04:20:56 | Nagasaki, Japan | |||
746355 | 746355 | 2022-04-23 | Japan | Nagasaki | 43424 | 120 | 0 | 33.235712 | 129.608033 | 2022-04-24 04:20:56 | Nagasaki, Japan | |||
3436840 | 3436840 | 2022-04-22 | Japan | Nagasaki | 42879 | 120 | 0 | 33.235712 | 129.608033 | 2022-04-23 04:20:50 | Nagasaki, Japan | |||
2892425 | 2892425 | 2022-04-21 | Japan | Nagasaki | 42367 | 119 | 0 | 33.235712 | 129.608033 | 2022-04-22 04:20:45 | Nagasaki, Japan | |||
2307297 | 2307297 | 2022-04-20 | Japan | Nagasaki | 41913 | 119 | 0 | 33.235712 | 129.608033 | 2022-04-21 04:20:46 | Nagasaki, Japan | |||
2251436 | 2251436 | 2022-04-19 | Japan | Nagasaki | 41338 | 119 | 0 | 33.235712 | 129.608033 | 2022-04-20 04:20:45 | Nagasaki, Japan | |||
1845986 | 1845986 | 2022-04-18 | Japan | Nagasaki | 40782 | 118 | 0 | 33.235712 | 129.608033 | 2022-04-19 04:21:00 | Nagasaki, Japan | |||
3416930 | 3416930 | 2022-04-17 | Japan | Nagasaki | 40580 | 118 | 0 | 33.235712 | 129.608033 | 2022-04-18 04:21:12 | Nagasaki, Japan | |||
303879 | 303879 | 2022-04-16 | Japan | Nagasaki | 40234 | 118 | 0 | 33.235712 | 129.608033 | 2022-04-17 04:20:59 | Nagasaki, Japan | |||
2669824 | 2669824 | 2022-04-15 | Japan | Nagasaki | 39840 | 118 | 0 | 33.235712 | 129.608033 | 2022-04-16 04:20:48 | Nagasaki, Japan | |||
1223609 | 1223609 | 2022-04-14 | Japan | Nagasaki | 39316 | 118 | 0 | 33.235712 | 129.608033 | 2022-04-15 04:20:57 | Nagasaki, Japan | |||
2442767 | 2442767 | 2022-04-13 | Japan | Nagasaki | 38867 | 117 | 0 | 33.235712 | 129.608033 | 2022-04-13 23:21:06 | Nagasaki, Japan | |||
1948524 | 1948524 | 2022-04-12 | Japan | Nagasaki | 38398 | 117 | 0 | 33.235712 | 129.608033 | 2022-04-13 04:21:03 | Nagasaki, Japan | |||
3206277 | 3206277 | 2022-04-11 | Japan | Nagasaki | 37908 | 117 | 0 | 33.235712 | 129.608033 | 2022-04-12 04:20:49 | Nagasaki, Japan | |||
1576163 | 1576163 | 2022-04-10 | Japan | Nagasaki | 37716 | 117 | 0 | 33.235712 | 129.608033 | 2022-04-11 04:21:02 | Nagasaki, Japan | |||
1652405 | 1652405 | 2022-04-09 | Japan | Nagasaki | 37327 | 117 | 0 | 33.235712 | 129.608033 | 2022-04-10 04:20:52 | Nagasaki, Japan | |||
2115727 | 2115727 | 2022-04-08 | Japan | Nagasaki | 36939 | 117 | 0 | 33.235712 | 129.608033 | 2022-04-09 04:20:42 | Nagasaki, Japan | |||
3320251 | 3320251 | 2022-04-07 | Japan | Nagasaki | 36547 | 117 | 0 | 33.235712 | 129.608033 | 2022-04-08 04:20:48 | Nagasaki, Japan | |||
2800787 | 2800787 | 2022-04-06 | Japan | Nagasaki | 36150 | 116 | 0 | 33.235712 | 129.608033 | 2022-04-07 04:20:53 | Nagasaki, Japan | |||
3867556 | 3867556 | 2022-04-05 | Japan | Nagasaki | 35771 | 116 | 0 | 33.235712 | 129.608033 | 2022-04-06 04:20:49 | Nagasaki, Japan | |||
2748898 | 2748898 | 2022-04-04 | Japan | Nagasaki | 35399 | 116 | 0 | 33.235712 | 129.608033 | 2022-04-05 04:20:48 | Nagasaki, Japan | |||
3730244 | 3730244 | 2022-04-03 | Japan | Nagasaki | 35254 | 116 | 0 | 33.235712 | 129.608033 | 2022-04-04 04:20:51 | Nagasaki, Japan | |||
499679 | 499679 | 2022-04-02 | Japan | Nagasaki | 34997 | 116 | 0 | 33.235712 | 129.608033 | 2022-04-03 04:20:48 | Nagasaki, Japan | |||
3350664 | 3350664 | 2022-04-01 | Japan | Nagasaki | 34728 | 116 | 0 | 33.235712 | 129.608033 | 2022-04-02 04:20:47 | Nagasaki, Japan | |||
1539969 | 1539969 | 2022-03-31 | Japan | Nagasaki | 34404 | 116 | 0 | 33.235712 | 129.608033 | 2022-04-01 04:20:28 | Nagasaki, Japan | |||
2477982 | 2477982 | 2022-03-30 | Japan | Nagasaki | 34091 | 116 | 0 | 33.235712 | 129.608033 | 2022-03-31 04:20:56 | Nagasaki, Japan | |||
158023 | 158023 | 2022-03-29 | Japan | Nagasaki | 33794 | 116 | 0 | 33.235712 | 129.608033 | 2022-03-30 04:20:45 | Nagasaki, Japan | |||
1436594 | 1436594 | 2022-03-28 | Japan | Nagasaki | 33519 | 116 | 0 | 33.235712 | 129.608033 | 2022-03-29 04:20:46 | Nagasaki, Japan | |||
876275 | 876275 | 2022-03-27 | Japan | Nagasaki | 33421 | 116 | 0 | 33.235712 | 129.608033 | 2022-03-28 04:20:33 | Nagasaki, Japan | |||
2163558 | 2163558 | 2022-03-26 | Japan | Nagasaki | 33213 | 116 | 0 | 33.235712 | 129.608033 | 2022-03-27 04:20:47 | Nagasaki, Japan | |||
1720494 | 1720494 | 2022-03-25 | Japan | Nagasaki | 32957 | 116 | 0 | 33.235712 | 129.608033 | 2022-03-26 04:20:23 | Nagasaki, Japan | |||
1468111 | 1468111 | 2022-03-24 | Japan | Nagasaki | 32746 | 116 | 0 | 33.235712 | 129.608033 | 2022-03-25 04:20:46 | Nagasaki, Japan | |||
3022285 | 3022285 | 2022-03-23 | Japan | Nagasaki | 32452 | 116 | 0 | 33.235712 | 129.608033 | 2022-03-24 04:20:43 | Nagasaki, Japan | |||
1905207 | 1905207 | 2022-03-22 | Japan | Nagasaki | 32177 | 116 | 0 | 33.235712 | 129.608033 | 2022-03-23 04:20:48 | Nagasaki, Japan | |||
3238338 | 3238338 | 2022-03-21 | Japan | Nagasaki | 32056 | 116 | 0 | 33.235712 | 129.608033 | 2022-03-22 04:20:54 | Nagasaki, Japan | |||
24411 | 24411 | 2022-03-20 | Japan | Nagasaki | 31928 | 116 | 0 | 33.235712 | 129.608033 | 2022-03-21 04:20:50 | Nagasaki, Japan | |||
1656421 | 1656421 | 2022-03-19 | Japan | Nagasaki | 31727 | 116 | 0 | 33.235712 | 129.608033 | 2022-03-20 04:20:45 | Nagasaki, Japan | |||
335947 | 335947 | 2022-03-18 | Japan | Nagasaki | 31482 | 115 | 0 | 33.235712 | 129.608033 | 2022-03-19 04:20:47 | Nagasaki, Japan | |||
694400 | 694400 | 2022-03-17 | Japan | Nagasaki | 31296 | 114 | 0 | 33.235712 | 129.608033 | 2022-03-18 04:20:55 | Nagasaki, Japan | |||
2319343 | 2319343 | 2022-03-16 | Japan | Nagasaki | 31026 | 114 | 0 | 33.235712 | 129.608033 | 2022-03-17 04:20:56 | Nagasaki, Japan | |||
261543 | 261543 | 2022-03-15 | Japan | Nagasaki | 30784 | 114 | 0 | 33.235712 | 129.608033 | 2022-03-16 04:20:50 | Nagasaki, Japan | |||
2263902 | 2263902 | 2022-03-14 | Japan | Nagasaki | 30470 | 114 | 0 | 33.235712 | 129.608033 | 2022-03-15 04:20:47 | Nagasaki, Japan | |||
3627968 | 3627968 | 2022-03-13 | Japan | Nagasaki | 30336 | 114 | 0 | 33.235712 | 129.608033 | 2022-03-14 04:20:46 | Nagasaki, Japan | |||
950876 | 950876 | 2022-03-12 | Japan | Nagasaki | 30110 | 113 | 0 | 33.235712 | 129.608033 | 2022-03-13 04:20:49 | Nagasaki, Japan | |||
356337 | 356337 | 2022-03-11 | Japan | Nagasaki | 29800 | 112 | 0 | 33.235712 | 129.608033 | 2022-03-12 04:20:50 | Nagasaki, Japan | |||
1865489 | 1865489 | 2022-03-10 | Japan | Nagasaki | 29462 | 111 | 0 | 33.235712 | 129.608033 | 2022-03-11 04:20:50 | Nagasaki, Japan | |||
2140184 | 2140184 | 2022-03-09 | Japan | Nagasaki | 29105 | 111 | 0 | 33.235712 | 129.608033 | 2022-03-10 04:20:48 | Nagasaki, Japan | |||
919695 | 919695 | 2022-03-08 | Japan | Nagasaki | 28701 | 111 | 0 | 33.235712 | 129.608033 | 2022-03-09 04:20:59 | Nagasaki, Japan | |||
1547982 | 1547982 | 2022-03-07 | Japan | Nagasaki | 28302 | 110 | 0 | 33.235712 | 129.608033 | 2022-03-08 04:20:54 | Nagasaki, Japan | |||
2199651 | 2199651 | 2022-03-06 | Japan | Nagasaki | 28134 | 110 | 0 | 33.235712 | 129.608033 | 2022-03-07 04:20:47 | Nagasaki, Japan | |||
2092108 | 2092108 | 2022-03-05 | Japan | Nagasaki | 27874 | 109 | 0 | 33.235712 | 129.608033 | 2022-03-06 04:20:49 | Nagasaki, Japan | |||
2665808 | 2665808 | 2022-03-04 | Japan | Nagasaki | 27560 | 108 | 0 | 33.235712 | 129.608033 | 2022-03-05 04:21:10 | Nagasaki, Japan | |||
1644373 | 1644373 | 2022-03-03 | Japan | Nagasaki | 27168 | 108 | 0 | 33.235712 | 129.608033 | 2022-03-04 04:21:09 | Nagasaki, Japan | |||
2525376 | 2525376 | 2022-03-02 | Japan | Nagasaki | 26823 | 108 | 0 | 33.235712 | 129.608033 | 2022-03-03 04:21:01 | Nagasaki, Japan | |||
1992670 | 1992670 | 2022-03-01 | Japan | Nagasaki | 26406 | 108 | 0 | 33.235712 | 129.608033 | 2022-03-02 04:21:07 | Nagasaki, Japan | |||
942844 | 942844 | 2022-02-28 | Japan | Nagasaki | 25953 | 108 | 0 | 33.235712 | 129.608033 | 2022-03-01 04:21:09 | Nagasaki, Japan | |||
2733035 | 2733035 | 2022-02-27 | Japan | Nagasaki | 25737 | 108 | 0 | 33.235712 | 129.608033 | 2022-02-28 04:21:05 | Nagasaki, Japan | |||
3046188 | 3046188 | 2022-02-26 | Japan | Nagasaki | 25405 | 108 | 0 | 33.235712 | 129.608033 | 2022-02-27 04:21:04 | Nagasaki, Japan | |||
574843 | 574843 | 2022-02-25 | Japan | Nagasaki | 25037 | 107 | 0 | 33.235712 | 129.608033 | 2022-02-26 04:21:12 | Nagasaki, Japan | |||
1511419 | 1511419 | 2022-02-24 | Japan | Nagasaki | 24614 | 105 | 0 | 33.235712 | 129.608033 | 2022-02-25 04:21:11 | Nagasaki, Japan | |||
1057860 | 1057860 | 2022-02-23 | Japan | Nagasaki | 24394 | 103 | 0 | 33.235712 | 129.608033 | 2022-02-24 04:21:14 | Nagasaki, Japan | |||
2446783 | 2446783 | 2022-02-22 | Japan | Nagasaki | 23921 | 102 | 0 | 33.235712 | 129.608033 | 2022-02-23 04:21:09 | Nagasaki, Japan | |||
3718196 | 3718196 | 2022-02-21 | Japan | Nagasaki | 23541 | 99 | 0 | 33.235712 | 129.608033 | 2022-02-22 04:21:01 | Nagasaki, Japan | |||
3912030 | 3912030 | 2022-02-20 | Japan | Nagasaki | 23338 | 99 | 0 | 33.235712 | 129.608033 | 2022-02-21 04:21:05 | Nagasaki, Japan | |||
3875588 | 3875588 | 2022-02-19 | Japan | Nagasaki | 23080 | 99 | 0 | 33.235712 | 129.608033 | 2022-02-20 04:21:00 | Nagasaki, Japan | |||
3855844 | 3855844 | 2022-02-18 | Japan | Nagasaki | 22710 | 95 | 0 | 33.235712 | 129.608033 | 2022-02-19 04:21:11 | Nagasaki, Japan | |||
1298063 | 1298063 | 2022-02-17 | Japan | Nagasaki | 22328 | 95 | 0 | 33.235712 | 129.608033 | 2022-02-18 04:21:04 | Nagasaki, Japan | |||
3820449 | 3820449 | 2022-02-16 | Japan | Nagasaki | 21966 | 95 | 0 | 33.235712 | 129.608033 | 2022-02-17 04:20:56 | Nagasaki, Japan | |||
3671663 | 3671663 | 2022-02-15 | Japan | Nagasaki | 21387 | 92 | 0 | 33.235712 | 129.608033 | 2022-02-16 04:21:10 | Nagasaki, Japan | |||
2641764 | 2641764 | 2022-02-14 | Japan | Nagasaki | 20944 | 91 | 0 | 33.235712 | 129.608033 | 2022-02-15 04:21:09 | Nagasaki, Japan | |||
186081 | 186081 | 2022-02-13 | Japan | Nagasaki | 20653 | 89 | 0 | 33.235712 | 129.608033 | 2022-02-14 04:20:51 | Nagasaki, Japan | |||
315927 | 315927 | 2022-02-12 | Japan | Nagasaki | 20267 | 87 | 0 | 33.235712 | 129.608033 | 2022-02-13 04:21:00 | Nagasaki, Japan | |||
233253 | 233253 | 2022-02-11 | Japan | Nagasaki | 20019 | 85 | 0 | 33.235712 | 129.608033 | 2022-02-12 04:21:06 | Nagasaki, Japan | |||
1464095 | 1464095 | 2022-02-10 | Japan | Nagasaki | 19522 | 83 | 0 | 33.235712 | 129.608033 | 2022-02-11 04:21:09 | Nagasaki, Japan | |||
3074056 | 3074056 | 2022-02-09 | Japan | Nagasaki | 18950 | 83 | 0 | 33.235712 | 129.608033 | 2022-02-10 04:21:14 | Nagasaki, Japan | |||
1362363 | 1362363 | 2022-02-08 | Japan | Nagasaki | 18465 | 82 | 0 | 33.235712 | 129.608033 | 2022-02-09 04:21:04 | Nagasaki, Japan | |||
71101 | 71101 | 2022-02-07 | Japan | Nagasaki | 18001 | 81 | 0 | 33.235712 | 129.608033 | 2022-02-08 04:21:15 | Nagasaki, Japan | |||
2012717 | 2012717 | 2022-02-06 | Japan | Nagasaki | 17704 | 80 | 0 | 33.235712 | 129.608033 | 2022-02-07 04:21:05 | Nagasaki, Japan | |||
1294046 | 1294046 | 2022-02-05 | Japan | Nagasaki | 17282 | 79 | 0 | 33.235712 | 129.608033 | 2022-02-06 04:21:00 | Nagasaki, Japan | |||
2327374 | 2327374 | 2022-02-04 | Japan | Nagasaki | 16679 | 77 | 0 | 33.235712 | 129.608033 | 2022-02-05 04:21:05 | Nagasaki, Japan | |||
2473965 | 2473965 | 2022-02-03 | Japan | Nagasaki | 16113 | 77 | 0 | 33.235712 | 129.608033 | 2022-02-04 04:21:10 | Nagasaki, Japan | |||
459390 | 459390 | 2022-02-02 | Japan | Nagasaki | 15548 | 77 | 0 | 33.235712 | 129.608033 | 2022-02-03 04:21:21 | Nagasaki, 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]);