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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3687491 | 3687491 | 2022-01-13 | Japan | Nagasaki | 6606 | 73 | 0 | 33.235712 | 129.608033 | 2022-01-14 04:21:54 | Nagasaki, Japan | |||
3613075 | 3613075 | 2022-01-12 | Japan | Nagasaki | 6446 | 73 | 0 | 33.235712 | 129.608033 | 2022-01-13 08:00:09 | Nagasaki, Japan | |||
1113600 | 1113600 | 2022-01-11 | Japan | Nagasaki | 6362 | 73 | 0 | 33.235712 | 129.608033 | 2022-01-12 04:21:44 | Nagasaki, Japan | |||
1692328 | 1692328 | 2022-01-10 | Japan | Nagasaki | 6299 | 73 | 0 | 33.235712 | 129.608033 | 2022-01-11 04:22:01 | Nagasaki, Japan | |||
126743 | 126743 | 2022-01-09 | Japan | Nagasaki | 6250 | 73 | 0 | 33.235712 | 129.608033 | 2022-01-10 04:22:07 | Nagasaki, Japan | |||
1215578 | 1215578 | 2022-01-08 | Japan | Nagasaki | 6219 | 73 | 0 | 33.235712 | 129.608033 | 2022-01-09 04:21:46 | Nagasaki, Japan | |||
1389671 | 1389671 | 2022-01-07 | Japan | Nagasaki | 6188 | 73 | 0 | 33.235712 | 129.608033 | 2022-01-08 04:21:53 | Nagasaki, Japan | |||
2610058 | 2610058 | 2022-01-06 | Japan | Nagasaki | 6159 | 73 | 0 | 33.235712 | 129.608033 | 2022-01-07 04:22:09 | Nagasaki, Japan | |||
1282000 | 1282000 | 2022-01-05 | Japan | Nagasaki | 6149 | 73 | 0 | 33.235712 | 129.608033 | 2022-01-06 04:22:09 | Nagasaki, Japan | |||
1286016 | 1286016 | 2022-01-04 | Japan | Nagasaki | 6133 | 73 | 0 | 33.235712 | 129.608033 | 2022-01-05 04:21:59 | Nagasaki, Japan | |||
1700360 | 1700360 | 2022-01-03 | Japan | Nagasaki | 6127 | 73 | 0 | 33.235712 | 129.608033 | 2022-01-04 04:22:17 | Nagasaki, Japan | |||
3519443 | 3519443 | 2022-01-02 | Japan | Nagasaki | 6126 | 73 | 0 | 33.235712 | 129.608033 | 2022-01-03 02:22:25 | Nagasaki, Japan | |||
2167573 | 2167573 | 2022-01-01 | Japan | Nagasaki | 6125 | 73 | 0 | 33.235712 | 129.608033 | 2022-01-02 04:20:52 | Nagasaki, Japan | |||
2777004 | 2777004 | 2021-12-31 | Japan | Nagasaki | 6124 | 73 | 0 | 33.235712 | 129.608033 | 2022-01-01 04:22:14 | Nagasaki, Japan | |||
3998661 | 3998661 | 2021-12-30 | Japan | Nagasaki | 6124 | 73 | 0 | 33.235712 | 129.608033 | 2021-12-31 04:21:50 | Nagasaki, Japan | |||
1668468 | 1668468 | 2021-12-29 | Japan | Nagasaki | 6124 | 73 | 0 | 33.235712 | 129.608033 | 2021-12-30 04:21:25 | Nagasaki, Japan | |||
1432577 | 1432577 | 2021-12-28 | Japan | Nagasaki | 6124 | 73 | 0 | 33.235712 | 129.608033 | 2021-12-29 03:21:43 | Nagasaki, Japan | |||
730538 | 730538 | 2021-12-27 | Japan | Nagasaki | 6123 | 73 | 0 | 33.235712 | 129.608033 | 2021-12-28 04:21:47 | Nagasaki, Japan | |||
2111710 | 2111710 | 2021-12-26 | Japan | Nagasaki | 6123 | 73 | 0 | 33.235712 | 129.608033 | 2021-12-27 04:21:58 | Nagasaki, Japan | |||
3605082 | 3605082 | 2021-12-25 | Japan | Nagasaki | 6123 | 73 | 0 | 33.235712 | 129.608033 | 2021-12-26 04:21:50 | Nagasaki, Japan | |||
2963400 | 2963400 | 2021-12-24 | Japan | Nagasaki | 6120 | 73 | 0 | 33.235712 | 129.608033 | 2021-12-25 04:21:37 | Nagasaki, Japan | |||
3816432 | 3816432 | 2021-12-23 | Japan | Nagasaki | 6120 | 73 | 0 | 33.235712 | 129.608033 | 2021-12-24 04:21:34 | Nagasaki, Japan | |||
798440 | 798440 | 2021-12-22 | Japan | Nagasaki | 6120 | 73 | 0 | 33.235712 | 129.608033 | 2021-12-23 04:21:21 | Nagasaki, Japan | |||
3828480 | 3828480 | 2021-12-21 | Japan | Nagasaki | 6119 | 73 | 0 | 33.235712 | 129.608033 | 2021-12-22 04:21:54 | Nagasaki, Japan | |||
1254783 | 1254783 | 2021-12-20 | Japan | Nagasaki | 6119 | 73 | 0 | 33.235712 | 129.608033 | 2021-12-21 03:21:27 | Nagasaki, Japan | |||
2903726 | 2903726 | 2021-12-19 | Japan | Nagasaki | 6119 | 73 | 0 | 33.235712 | 129.608033 | 2021-12-20 04:21:43 | Nagasaki, Japan | |||
1258799 | 1258799 | 2021-12-18 | Japan | Nagasaki | 6119 | 73 | 0 | 33.235712 | 129.608033 | 2021-12-19 04:21:11 | Nagasaki, Japan | |||
2398827 | 2398827 | 2021-12-17 | Japan | Nagasaki | 6119 | 73 | 0 | 33.235712 | 129.608033 | 2021-12-18 02:22:20 | Nagasaki, Japan | |||
1716365 | 1716365 | 2021-12-16 | Japan | Nagasaki | 6119 | 73 | 0 | 33.235712 | 129.608033 | 2021-12-17 04:22:14 | Nagasaki, Japan | |||
3496199 | 3496199 | 2021-12-15 | Japan | Nagasaki | 6119 | 73 | 0 | 33.235712 | 129.608033 | 2021-12-16 04:22:11 | Nagasaki, Japan | |||
2087984 | 2087984 | 2021-12-14 | Japan | Nagasaki | 6119 | 73 | 0 | 33.235712 | 129.608033 | 2021-12-15 03:22:16 | Nagasaki, Japan | |||
782401 | 782401 | 2021-12-13 | Japan | Nagasaki | 6119 | 73 | 0 | 33.235712 | 129.608033 | 2021-12-14 04:22:38 | Nagasaki, Japan | |||
1660436 | 1660436 | 2021-12-12 | Japan | Nagasaki | 6119 | 73 | 0 | 33.235712 | 129.608033 | 2021-12-13 04:22:02 | Nagasaki, Japan | |||
1664452 | 1664452 | 2021-12-11 | Japan | Nagasaki | 6119 | 73 | 0 | 33.235712 | 129.608033 | 2021-12-12 04:22:12 | Nagasaki, Japan | |||
3655604 | 3655604 | 2021-12-10 | Japan | Nagasaki | 6119 | 73 | 0 | 33.235712 | 129.608033 | 2021-12-11 04:22:45 | Nagasaki, Japan | |||
1077935 | 1077935 | 2021-12-09 | Japan | Nagasaki | 6119 | 73 | 0 | 33.235712 | 129.608033 | 2021-12-10 04:22:28 | Nagasaki, Japan | |||
550784 | 550784 | 2021-12-08 | Japan | Nagasaki | 6119 | 73 | 0 | 33.235712 | 129.608033 | 2021-12-09 04:22:49 | Nagasaki, Japan | |||
404304 | 404304 | 2021-12-07 | Japan | Nagasaki | 6119 | 73 | 0 | 33.235712 | 129.608033 | 2021-12-08 04:22:46 | Nagasaki, Japan | |||
1030386 | 1030386 | 2021-12-06 | Japan | Nagasaki | 6119 | 73 | 0 | 33.235712 | 129.608033 | 2021-12-07 04:22:34 | Nagasaki, Japan | |||
1740549 | 1740549 | 2021-12-05 | Japan | Nagasaki | 6119 | 73 | 0 | 33.235712 | 129.608033 | 2021-12-06 04:22:34 | Nagasaki, Japan | |||
137981 | 137981 | 2021-12-04 | Japan | Nagasaki | 6119 | 73 | 0 | 33.235712 | 129.608033 | 2021-12-05 04:22:25 | Nagasaki, Japan | |||
2195634 | 2195634 | 2021-12-03 | Japan | Nagasaki | 6119 | 73 | 0 | 33.235712 | 129.608033 | 2021-12-04 04:22:18 | Nagasaki, Japan | |||
340 | 340 | 2021-12-02 | Japan | Nagasaki | 6119 | 73 | 0 | 33.235712 | 129.608033 | 2021-12-03 04:23:05 | Nagasaki, Japan | |||
1144939 | 1144939 | 2021-12-01 | Japan | Nagasaki | 6119 | 73 | 0 | 33.235712 | 129.608033 | 2021-12-02 04:22:37 | Nagasaki, Japan | |||
3401451 | 3401451 | 2021-11-30 | Japan | Nagasaki | 6119 | 73 | 0 | 33.235712 | 129.608033 | 2021-12-01 04:22:29 | Nagasaki, Japan | |||
149994 | 149994 | 2021-11-29 | Japan | Nagasaki | 6119 | 73 | 0 | 33.235712 | 129.608033 | 2021-11-30 04:22:53 | Nagasaki, Japan | |||
1231640 | 1231640 | 2021-11-28 | Japan | Nagasaki | 6119 | 73 | 0 | 33.235712 | 129.608033 | 2021-11-29 04:22:30 | Nagasaki, Japan | |||
1358347 | 1358347 | 2021-11-27 | Japan | Nagasaki | 6119 | 73 | 0 | 33.235712 | 129.608033 | 2021-11-28 04:22:43 | Nagasaki, Japan | |||
758338 | 758338 | 2021-11-26 | Japan | Nagasaki | 6119 | 73 | 0 | 33.235712 | 129.608033 | 2021-11-27 04:22:45 | Nagasaki, Japan | |||
1802755 | 1802755 | 2021-11-25 | Japan | Nagasaki | 6119 | 73 | 0 | 33.235712 | 129.608033 | 2021-11-26 04:22:33 | Nagasaki, Japan | |||
904189 | 904189 | 2021-11-24 | Japan | Nagasaki | 6119 | 73 | 0 | 33.235712 | 129.608033 | 2021-11-25 04:22:33 | Nagasaki, Japan | |||
3070039 | 3070039 | 2021-11-23 | Japan | Nagasaki | 6119 | 73 | 0 | 33.235712 | 129.608033 | 2021-11-24 04:22:14 | Nagasaki, Japan | |||
3749137 | 3749137 | 2021-11-22 | Japan | Nagasaki | 6119 | 73 | 0 | 33.235712 | 129.608033 | 2021-11-23 04:22:39 | Nagasaki, Japan | |||
1014344 | 1014344 | 2021-11-21 | Japan | Nagasaki | 6119 | 73 | 0 | 33.235712 | 129.608033 | 2021-11-22 04:22:20 | Nagasaki, Japan | |||
722508 | 722508 | 2021-11-20 | Japan | Nagasaki | 6119 | 73 | 0 | 33.235712 | 129.608033 | 2021-11-21 04:22:13 | Nagasaki, Japan | |||
162038 | 162038 | 2021-11-19 | Japan | Nagasaki | 6118 | 73 | 0 | 33.235712 | 129.608033 | 2021-11-20 04:22:17 | Nagasaki, Japan | |||
3288925 | 3288925 | 2021-11-18 | Japan | Nagasaki | 6118 | 73 | 0 | 33.235712 | 129.608033 | 2021-11-19 04:21:40 | Nagasaki, Japan | |||
447381 | 447381 | 2021-11-17 | Japan | Nagasaki | 6118 | 73 | 0 | 33.235712 | 129.608033 | 2021-11-18 04:21:33 | Nagasaki, Japan | |||
3342631 | 3342631 | 2021-11-16 | Japan | Nagasaki | 6118 | 73 | 0 | 33.235712 | 129.608033 | 2021-11-17 04:21:48 | Nagasaki, Japan | |||
2287467 | 2287467 | 2021-11-15 | Japan | Nagasaki | 6118 | 73 | 0 | 33.235712 | 129.608033 | 2021-11-16 04:21:10 | Nagasaki, Japan | |||
1322241 | 1322241 | 2021-11-14 | Japan | Nagasaki | 6118 | 73 | 0 | 33.235712 | 129.608033 | 2021-11-15 04:21:36 | Nagasaki, Japan | |||
686367 | 686367 | 2021-11-13 | Japan | Nagasaki | 6118 | 73 | 0 | 33.235712 | 129.608033 | 2021-11-14 04:21:31 | Nagasaki, Japan | |||
714476 | 714476 | 2021-11-12 | Japan | Nagasaki | 6118 | 73 | 0 | 33.235712 | 129.608033 | 2021-11-13 04:21:38 | Nagasaki, Japan | |||
28426 | 28426 | 2021-11-11 | Japan | Nagasaki | 6118 | 73 | 0 | 33.235712 | 129.608033 | 2021-11-12 04:22:01 | Nagasaki, Japan | |||
2844865 | 2844865 | 2021-11-10 | Japan | Nagasaki | 6118 | 73 | 0 | 33.235712 | 129.608033 | 2021-11-11 04:21:45 | Nagasaki, Japan | |||
87135 | 87135 | 2021-11-09 | Japan | Nagasaki | 6118 | 73 | 0 | 33.235712 | 129.608033 | 2021-11-10 04:21:38 | Nagasaki, Japan | |||
3639563 | 3639563 | 2021-11-08 | Japan | Nagasaki | 6118 | 73 | 0 | 33.235712 | 129.608033 | 2021-11-09 04:21:36 | Nagasaki, Japan | |||
2000671 | 2000671 | 2021-11-07 | Japan | Nagasaki | 6118 | 73 | 0 | 33.235712 | 129.608033 | 2021-11-08 04:21:43 | Nagasaki, Japan | |||
495662 | 495662 | 2021-11-06 | Japan | Nagasaki | 6118 | 73 | 0 | 33.235712 | 129.608033 | 2021-11-07 04:21:53 | Nagasaki, Japan | |||
3121517 | 3121517 | 2021-11-05 | Japan | Nagasaki | 6118 | 73 | 0 | 33.235712 | 129.608033 | 2021-11-06 04:21:51 | Nagasaki, Japan | |||
698415 | 698415 | 2021-11-04 | Japan | Nagasaki | 6117 | 73 | 0 | 33.235712 | 129.608033 | 2021-11-05 04:21:54 | Nagasaki, Japan | |||
276193 | 276193 | 2021-11-03 | Japan | Nagasaki | 6117 | 73 | 0 | 33.235712 | 129.608033 | 2021-11-04 04:22:20 | Nagasaki, Japan | |||
43718 | 43718 | 2021-11-02 | Japan | Nagasaki | 6116 | 73 | 0 | 33.235712 | 129.608033 | 2021-11-03 06:22:09 | Nagasaki, Japan | |||
3511414 | 3511414 | 2021-11-01 | Japan | Nagasaki | 6116 | 73 | 0 | 33.235712 | 129.608033 | 2021-11-02 04:22:03 | Nagasaki, Japan | |||
288006 | 288006 | 2021-10-31 | Japan | Nagasaki | 6115 | 73 | 0 | 33.235712 | 129.608033 | 2021-11-01 04:22:01 | Nagasaki, Japan | |||
2721012 | 2721012 | 2021-10-30 | Japan | Nagasaki | 6112 | 73 | 0 | 33.235712 | 129.608033 | 2021-10-31 04:22:08 | Nagasaki, Japan | |||
567114 | 567114 | 2021-10-29 | Japan | Nagasaki | 6110 | 73 | 0 | 33.235712 | 129.608033 | 2021-10-30 04:22:03 | Nagasaki, Japan | |||
4356 | 4356 | 2021-10-28 | Japan | Nagasaki | 6105 | 73 | 0 | 33.235712 | 129.608033 | 2021-10-29 04:22:03 | Nagasaki, Japan | |||
534746 | 534746 | 2021-10-27 | Japan | Nagasaki | 6101 | 73 | 0 | 33.235712 | 129.608033 | 2021-10-28 04:22:08 | Nagasaki, Japan | |||
3492183 | 3492183 | 2021-10-26 | Japan | Nagasaki | 6098 | 73 | 0 | 33.235712 | 129.608033 | 2021-10-27 04:22:32 | Nagasaki, Japan | |||
3793905 | 3793905 | 2021-10-25 | Japan | Nagasaki | 6097 | 73 | 0 | 33.235712 | 129.608033 | 2021-10-26 04:22:09 | Nagasaki, Japan | |||
682351 | 682351 | 2021-10-24 | Japan | Nagasaki | 6097 | 73 | 0 | 33.235712 | 129.608033 | 2021-10-25 04:22:31 | Nagasaki, Japan | |||
770359 | 770359 | 2021-10-23 | Japan | Nagasaki | 6097 | 73 | 0 | 33.235712 | 129.608033 | 2021-10-24 04:21:22 | Nagasaki, Japan | |||
654006 | 654006 | 2021-10-22 | Japan | Nagasaki | 6095 | 73 | 0 | 33.235712 | 129.608033 | 2021-10-23 04:21:32 | Nagasaki, Japan | |||
2123753 | 2123753 | 2021-10-21 | Japan | Nagasaki | 6095 | 73 | 0 | 33.235712 | 129.608033 | 2021-10-22 04:21:14 | Nagasaki, Japan | |||
443365 | 443365 | 2021-10-20 | Japan | Nagasaki | 6090 | 73 | 0 | 33.235712 | 129.608033 | 2021-10-21 04:21:18 | Nagasaki, Japan | |||
597684 | 597684 | 2021-10-19 | Japan | Nagasaki | 6084 | 73 | 0 | 33.235712 | 129.608033 | 2021-10-20 04:21:00 | Nagasaki, Japan | |||
2043861 | 2043861 | 2021-10-18 | Japan | Nagasaki | 6078 | 73 | 0 | 33.235712 | 129.608033 | 2021-10-19 04:20:54 | Nagasaki, Japan | |||
1909222 | 1909222 | 2021-10-17 | Japan | Nagasaki | 6076 | 73 | 0 | 33.235712 | 129.608033 | 2021-10-18 04:21:10 | Nagasaki, Japan | |||
934811 | 934811 | 2021-10-16 | Japan | Nagasaki | 6065 | 73 | 0 | 33.235712 | 129.608033 | 2021-10-17 04:21:29 | Nagasaki, Japan | |||
2943366 | 2943366 | 2021-10-15 | Japan | Nagasaki | 6060 | 73 | 0 | 33.235712 | 129.608033 | 2021-10-16 04:21:15 | Nagasaki, Japan | |||
491646 | 491646 | 2021-10-14 | Japan | Nagasaki | 6056 | 73 | 0 | 33.235712 | 129.608033 | 2021-10-15 04:21:26 | Nagasaki, Japan | |||
633934 | 633934 | 2021-10-13 | Japan | Nagasaki | 6052 | 73 | 0 | 33.235712 | 129.608033 | 2021-10-14 04:21:29 | Nagasaki, Japan | |||
1491612 | 1491612 | 2021-10-12 | Japan | Nagasaki | 6047 | 73 | 0 | 33.235712 | 129.608033 | 2021-10-13 04:20:51 | Nagasaki, Japan | |||
3007345 | 3007345 | 2021-10-11 | Japan | Nagasaki | 6046 | 73 | 0 | 33.235712 | 129.608033 | 2021-10-12 04:21:09 | Nagasaki, Japan | |||
423361 | 423361 | 2021-10-10 | Japan | Nagasaki | 6043 | 72 | 0 | 33.235712 | 129.608033 | 2021-10-11 04:21:31 | Nagasaki, Japan | |||
2876218 | 2876218 | 2021-10-09 | Japan | Nagasaki | 6039 | 72 | 0 | 33.235712 | 129.608033 | 2021-10-10 04:21:38 | Nagasaki, Japan | |||
2959384 | 2959384 | 2021-10-08 | Japan | Nagasaki | 6034 | 72 | 0 | 33.235712 | 129.608033 | 2021-10-09 04:21:34 | Nagasaki, Japan | |||
467422 | 467422 | 2021-10-07 | Japan | Nagasaki | 6022 | 72 | 0 | 33.235712 | 129.608033 | 2021-10-08 04:21:25 | Nagasaki, Japan | |||
2458802 | 2458802 | 2021-10-06 | Japan | Nagasaki | 6019 | 72 | 0 | 33.235712 | 129.608033 | 2021-10-07 04:21:36 | 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]);