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 = "Niigata" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2235396 | 2235396 | 2022-06-12 | Japan | Niigata | 73736 | 91 | 0 | 37.521819 | 138.918647 | 2022-06-13 04:21:14 | Niigata, Japan | |||
3141594 | 3141594 | 2022-06-11 | Japan | Niigata | 73608 | 91 | 0 | 37.521819 | 138.918647 | 2022-06-12 04:20:53 | Niigata, Japan | |||
1944510 | 1944510 | 2022-06-10 | Japan | Niigata | 73473 | 91 | 0 | 37.521819 | 138.918647 | 2022-06-11 04:21:01 | Niigata, Japan | |||
3157649 | 3157649 | 2022-06-09 | Japan | Niigata | 73378 | 91 | 0 | 37.521819 | 138.918647 | 2022-06-10 04:20:55 | Niigata, Japan | |||
1421116 | 1421116 | 2022-06-08 | Japan | Niigata | 73230 | 91 | 0 | 37.521819 | 138.918647 | 2022-06-09 04:20:54 | Niigata, Japan | |||
3726230 | 3726230 | 2022-06-07 | Japan | Niigata | 73081 | 91 | 0 | 37.521819 | 138.918647 | 2022-06-08 04:20:55 | Niigata, Japan | |||
3887632 | 3887632 | 2022-06-06 | Japan | Niigata | 72983 | 91 | 0 | 37.521819 | 138.918647 | 2022-06-07 04:21:08 | Niigata, Japan | |||
3507401 | 3507401 | 2022-06-05 | Japan | Niigata | 72896 | 91 | 0 | 37.521819 | 138.918647 | 2022-06-06 04:20:57 | Niigata, Japan | |||
3527478 | 3527478 | 2022-06-04 | Japan | Niigata | 72723 | 91 | 0 | 37.521819 | 138.918647 | 2022-06-05 04:20:55 | Niigata, Japan | |||
3133564 | 3133564 | 2022-06-03 | Japan | Niigata | 72570 | 91 | 0 | 37.521819 | 138.918647 | 2022-06-04 04:20:58 | Niigata, Japan | |||
3578639 | 3578639 | 2022-06-02 | Japan | Niigata | 72361 | 91 | 0 | 37.521819 | 138.918647 | 2022-06-03 04:20:58 | Niigata, Japan | |||
970932 | 970932 | 2022-06-01 | Japan | Niigata | 72090 | 91 | 0 | 37.521819 | 138.918647 | 2022-06-02 05:20:39 | Niigata, Japan | |||
229239 | 229239 | 2022-05-31 | Japan | Niigata | 71836 | 91 | 0 | 37.521819 | 138.918647 | 2022-06-01 04:20:55 | Niigata, Japan | |||
3186004 | 3186004 | 2022-05-30 | Japan | Niigata | 71660 | 91 | 0 | 37.521819 | 138.918647 | 2022-05-31 04:20:51 | Niigata, Japan | |||
3198153 | 3198153 | 2022-05-29 | Japan | Niigata | 71479 | 91 | 0 | 37.521819 | 138.918647 | 2022-05-30 04:20:50 | Niigata, Japan | |||
2725031 | 2725031 | 2022-05-28 | Japan | Niigata | 71142 | 91 | 0 | 37.521819 | 138.918647 | 2022-05-29 04:20:53 | Niigata, Japan | |||
1314212 | 1314212 | 2022-05-27 | Japan | Niigata | 70808 | 91 | 0 | 37.521819 | 138.918647 | 2022-05-28 04:21:07 | Niigata, Japan | |||
1850004 | 1850004 | 2022-05-26 | Japan | Niigata | 70480 | 91 | 0 | 37.521819 | 138.918647 | 2022-05-27 04:20:56 | Niigata, Japan | |||
2047880 | 2047880 | 2022-05-25 | Japan | Niigata | 70055 | 91 | 0 | 37.521819 | 138.918647 | 2022-05-26 04:20:50 | Niigata, Japan | |||
2999318 | 2999318 | 2022-05-24 | Japan | Niigata | 69646 | 91 | 0 | 37.521819 | 138.918647 | 2022-05-25 04:20:56 | Niigata, Japan | |||
3593039 | 3593039 | 2022-05-23 | Japan | Niigata | 69406 | 91 | 0 | 37.521819 | 138.918647 | 2022-05-24 04:20:57 | Niigata, Japan | |||
621891 | 621891 | 2022-05-22 | Japan | Niigata | 70055 | 91 | 0 | 37.521819 | 138.918647 | 2022-05-26 04:20:50 | Niigata, Japan | |||
1109587 | 1109587 | 2022-05-21 | Japan | Niigata | 68785 | 91 | 0 | 37.521819 | 138.918647 | 2022-05-22 04:20:52 | Niigata, Japan | |||
1169211 | 1169211 | 2022-05-20 | Japan | Niigata | 68411 | 91 | 0 | 37.521819 | 138.918647 | 2022-05-21 04:20:58 | Niigata, Japan | |||
3895974 | 3895974 | 2022-05-19 | Japan | Niigata | 68022 | 91 | 0 | 37.521819 | 138.918647 | 2022-05-20 04:20:57 | Niigata, Japan | |||
1184758 | 1184758 | 2022-05-18 | Japan | Niigata | 67624 | 91 | 0 | 37.521819 | 138.918647 | 2022-05-19 04:20:54 | Niigata, Japan | |||
3582655 | 3582655 | 2022-05-17 | Japan | Niigata | 67139 | 91 | 0 | 37.521819 | 138.918647 | 2022-05-18 04:20:50 | Niigata, Japan | |||
1503612 | 1503612 | 2022-05-16 | Japan | Niigata | 66863 | 91 | 0 | 37.521819 | 138.918647 | 2022-05-17 04:20:59 | Niigata, Japan | |||
2083971 | 2083971 | 2022-05-15 | Japan | Niigata | 66568 | 91 | 0 | 37.521819 | 138.918647 | 2022-05-16 04:20:47 | Niigata, Japan | |||
3354682 | 3354682 | 2022-05-14 | Japan | Niigata | 66154 | 91 | 0 | 37.521819 | 138.918647 | 2022-05-15 04:20:53 | Niigata, Japan | |||
658327 | 658327 | 2022-05-13 | Japan | Niigata | 65694 | 91 | 0 | 37.521819 | 138.918647 | 2022-05-14 04:20:48 | Niigata, Japan | |||
2533410 | 2533410 | 2022-05-12 | Japan | Niigata | 65271 | 91 | 0 | 37.521819 | 138.918647 | 2022-05-13 04:20:51 | Niigata, Japan | |||
3444856 | 3444856 | 2022-05-11 | Japan | Niigata | 64807 | 91 | 0 | 37.521819 | 138.918647 | 2022-05-12 04:20:54 | Niigata, Japan | |||
3535473 | 3535473 | 2022-05-10 | Japan | Niigata | 64254 | 91 | 0 | 37.521819 | 138.918647 | 2022-05-11 04:20:48 | Niigata, Japan | |||
222008 | 222008 | 2022-05-09 | Japan | Niigata | 63853 | 91 | 0 | 37.521819 | 138.918647 | 2022-05-10 04:20:50 | Niigata, Japan | |||
2331393 | 2331393 | 2022-05-08 | Japan | Niigata | 63426 | 91 | 0 | 37.521819 | 138.918647 | 2022-05-09 04:20:54 | Niigata, Japan | |||
360355 | 360355 | 2022-05-07 | Japan | Niigata | 62822 | 91 | 0 | 37.521819 | 138.918647 | 2022-05-08 04:20:49 | Niigata, Japan | |||
1397706 | 1397706 | 2022-05-06 | Japan | Niigata | 62393 | 91 | 0 | 37.521819 | 138.918647 | 2022-05-07 04:21:09 | Niigata, Japan | |||
2598061 | 2598061 | 2022-05-05 | Japan | Niigata | 62120 | 91 | 0 | 37.521819 | 138.918647 | 2022-05-06 04:21:00 | Niigata, Japan | |||
3265510 | 3265510 | 2022-05-04 | Japan | Niigata | 61869 | 91 | 0 | 37.521819 | 138.918647 | 2022-05-05 04:20:55 | Niigata, Japan | |||
1572149 | 1572149 | 2022-05-03 | Japan | Niigata | 61444 | 91 | 0 | 37.521819 | 138.918647 | 2022-05-04 04:20:59 | Niigata, Japan | |||
463409 | 463409 | 2022-05-02 | Japan | Niigata | 61150 | 91 | 0 | 37.521819 | 138.918647 | 2022-05-03 04:21:00 | Niigata, Japan | |||
3916048 | 3916048 | 2022-05-01 | Japan | Niigata | 60943 | 91 | 0 | 37.521819 | 138.918647 | 2022-05-02 04:21:10 | Niigata, Japan | |||
2840852 | 2840852 | 2022-04-30 | Japan | Niigata | 60720 | 91 | 0 | 37.521819 | 138.918647 | 2022-05-01 04:20:57 | Niigata, Japan | |||
1157165 | 1157165 | 2022-04-29 | Japan | Niigata | 60398 | 91 | 0 | 37.521819 | 138.918647 | 2022-04-30 04:21:05 | Niigata, Japan | |||
1696347 | 1696347 | 2022-04-28 | Japan | Niigata | 59900 | 91 | 0 | 37.521819 | 138.918647 | 2022-04-29 04:20:59 | Niigata, Japan | |||
3851830 | 3851830 | 2022-04-27 | Japan | Niigata | 59390 | 91 | 0 | 37.521819 | 138.918647 | 2022-04-28 04:20:47 | Niigata, Japan | |||
1326260 | 1326260 | 2022-04-26 | Japan | Niigata | 58819 | 91 | 0 | 37.521819 | 138.918647 | 2022-04-27 04:20:52 | Niigata, Japan | |||
3722214 | 3722214 | 2022-04-25 | Japan | Niigata | 58479 | 91 | 0 | 37.521819 | 138.918647 | 2022-04-26 04:20:51 | Niigata, Japan | |||
2028782 | 2028782 | 2022-04-24 | Japan | Niigata | 58164 | 91 | 0 | 37.521819 | 138.918647 | 2022-04-25 04:20:56 | Niigata, Japan | |||
746357 | 746357 | 2022-04-23 | Japan | Niigata | 57604 | 91 | 0 | 37.521819 | 138.918647 | 2022-04-24 04:20:56 | Niigata, Japan | |||
3436842 | 3436842 | 2022-04-22 | Japan | Niigata | 57131 | 91 | 0 | 37.521819 | 138.918647 | 2022-04-23 04:20:50 | Niigata, Japan | |||
2892427 | 2892427 | 2022-04-21 | Japan | Niigata | 56549 | 91 | 0 | 37.521819 | 138.918647 | 2022-04-22 04:20:45 | Niigata, Japan | |||
2307299 | 2307299 | 2022-04-20 | Japan | Niigata | 55969 | 91 | 0 | 37.521819 | 138.918647 | 2022-04-21 04:20:46 | Niigata, Japan | |||
2251438 | 2251438 | 2022-04-19 | Japan | Niigata | 55348 | 91 | 0 | 37.521819 | 138.918647 | 2022-04-20 04:20:45 | Niigata, Japan | |||
1845988 | 1845988 | 2022-04-18 | Japan | Niigata | 54977 | 91 | 0 | 37.521819 | 138.918647 | 2022-04-19 04:21:00 | Niigata, Japan | |||
3416932 | 3416932 | 2022-04-17 | Japan | Niigata | 54531 | 91 | 0 | 37.521819 | 138.918647 | 2022-04-18 04:21:12 | Niigata, Japan | |||
303881 | 303881 | 2022-04-16 | Japan | Niigata | 53930 | 91 | 0 | 37.521819 | 138.918647 | 2022-04-17 04:20:59 | Niigata, Japan | |||
2669826 | 2669826 | 2022-04-15 | Japan | Niigata | 53236 | 91 | 0 | 37.521819 | 138.918647 | 2022-04-16 04:20:48 | Niigata, Japan | |||
1223611 | 1223611 | 2022-04-14 | Japan | Niigata | 52464 | 91 | 0 | 37.521819 | 138.918647 | 2022-04-15 04:20:57 | Niigata, Japan | |||
2442769 | 2442769 | 2022-04-13 | Japan | Niigata | 51650 | 91 | 0 | 37.521819 | 138.918647 | 2022-04-13 23:21:06 | Niigata, Japan | |||
1948526 | 1948526 | 2022-04-12 | Japan | Niigata | 50743 | 91 | 0 | 37.521819 | 138.918647 | 2022-04-13 04:21:03 | Niigata, Japan | |||
3206279 | 3206279 | 2022-04-11 | Japan | Niigata | 50226 | 91 | 0 | 37.521819 | 138.918647 | 2022-04-12 04:20:49 | Niigata, Japan | |||
1576165 | 1576165 | 2022-04-10 | Japan | Niigata | 49717 | 91 | 0 | 37.521819 | 138.918647 | 2022-04-11 04:21:02 | Niigata, Japan | |||
1652407 | 1652407 | 2022-04-09 | Japan | Niigata | 48821 | 91 | 0 | 37.521819 | 138.918647 | 2022-04-10 04:20:52 | Niigata, Japan | |||
2115729 | 2115729 | 2022-04-08 | Japan | Niigata | 48046 | 91 | 0 | 37.521819 | 138.918647 | 2022-04-09 04:20:42 | Niigata, Japan | |||
3320253 | 3320253 | 2022-04-07 | Japan | Niigata | 47186 | 91 | 0 | 37.521819 | 138.918647 | 2022-04-08 04:20:48 | Niigata, Japan | |||
2800789 | 2800789 | 2022-04-06 | Japan | Niigata | 46347 | 91 | 0 | 37.521819 | 138.918647 | 2022-04-07 04:20:53 | Niigata, Japan | |||
3867558 | 3867558 | 2022-04-05 | Japan | Niigata | 45466 | 91 | 0 | 37.521819 | 138.918647 | 2022-04-06 04:20:49 | Niigata, Japan | |||
2748900 | 2748900 | 2022-04-04 | Japan | Niigata | 44891 | 90 | 0 | 37.521819 | 138.918647 | 2022-04-05 04:20:48 | Niigata, Japan | |||
3730246 | 3730246 | 2022-04-03 | Japan | Niigata | 44472 | 90 | 0 | 37.521819 | 138.918647 | 2022-04-04 04:20:51 | Niigata, Japan | |||
499681 | 499681 | 2022-04-02 | Japan | Niigata | 43806 | 90 | 0 | 37.521819 | 138.918647 | 2022-04-03 04:20:48 | Niigata, Japan | |||
3350666 | 3350666 | 2022-04-01 | Japan | Niigata | 43210 | 90 | 0 | 37.521819 | 138.918647 | 2022-04-02 04:20:47 | Niigata, Japan | |||
1539971 | 1539971 | 2022-03-31 | Japan | Niigata | 42481 | 88 | 0 | 37.521819 | 138.918647 | 2022-04-01 04:20:28 | Niigata, Japan | |||
2477984 | 2477984 | 2022-03-30 | Japan | Niigata | 41805 | 88 | 0 | 37.521819 | 138.918647 | 2022-03-31 04:20:56 | Niigata, Japan | |||
158025 | 158025 | 2022-03-29 | Japan | Niigata | 41110 | 88 | 0 | 37.521819 | 138.918647 | 2022-03-30 04:20:45 | Niigata, Japan | |||
1436596 | 1436596 | 2022-03-28 | Japan | Niigata | 40761 | 87 | 0 | 37.521819 | 138.918647 | 2022-03-29 04:20:46 | Niigata, Japan | |||
876277 | 876277 | 2022-03-27 | Japan | Niigata | 40411 | 87 | 0 | 37.521819 | 138.918647 | 2022-03-28 04:20:33 | Niigata, Japan | |||
2163560 | 2163560 | 2022-03-26 | Japan | Niigata | 39904 | 87 | 0 | 37.521819 | 138.918647 | 2022-03-27 04:20:47 | Niigata, Japan | |||
1720496 | 1720496 | 2022-03-25 | Japan | Niigata | 39359 | 87 | 0 | 37.521819 | 138.918647 | 2022-03-26 04:20:23 | Niigata, Japan | |||
1468113 | 1468113 | 2022-03-24 | Japan | Niigata | 38835 | 87 | 0 | 37.521819 | 138.918647 | 2022-03-25 04:20:46 | Niigata, Japan | |||
3022287 | 3022287 | 2022-03-23 | Japan | Niigata | 38298 | 87 | 0 | 37.521819 | 138.918647 | 2022-03-24 04:20:43 | Niigata, Japan | |||
1905209 | 1905209 | 2022-03-22 | Japan | Niigata | 37957 | 87 | 0 | 37.521819 | 138.918647 | 2022-03-23 04:20:48 | Niigata, Japan | |||
3238340 | 3238340 | 2022-03-21 | Japan | Niigata | 37708 | 85 | 0 | 37.521819 | 138.918647 | 2022-03-22 04:20:54 | Niigata, Japan | |||
24413 | 24413 | 2022-03-20 | Japan | Niigata | 37396 | 85 | 0 | 37.521819 | 138.918647 | 2022-03-21 04:20:50 | Niigata, Japan | |||
1656423 | 1656423 | 2022-03-19 | Japan | Niigata | 36904 | 85 | 0 | 37.521819 | 138.918647 | 2022-03-20 04:20:45 | Niigata, Japan | |||
335949 | 335949 | 2022-03-18 | Japan | Niigata | 36558 | 85 | 0 | 37.521819 | 138.918647 | 2022-03-19 04:20:47 | Niigata, Japan | |||
694402 | 694402 | 2022-03-17 | Japan | Niigata | 36110 | 85 | 0 | 37.521819 | 138.918647 | 2022-03-18 04:20:55 | Niigata, Japan | |||
2319345 | 2319345 | 2022-03-16 | Japan | Niigata | 35582 | 85 | 0 | 37.521819 | 138.918647 | 2022-03-17 04:20:56 | Niigata, Japan | |||
261545 | 261545 | 2022-03-15 | Japan | Niigata | 35065 | 85 | 0 | 37.521819 | 138.918647 | 2022-03-16 04:20:50 | Niigata, Japan | |||
2263904 | 2263904 | 2022-03-14 | Japan | Niigata | 34664 | 85 | 0 | 37.521819 | 138.918647 | 2022-03-15 04:20:47 | Niigata, Japan | |||
3627970 | 3627970 | 2022-03-13 | Japan | Niigata | 34295 | 85 | 0 | 37.521819 | 138.918647 | 2022-03-14 04:20:46 | Niigata, Japan | |||
950878 | 950878 | 2022-03-12 | Japan | Niigata | 33853 | 85 | 0 | 37.521819 | 138.918647 | 2022-03-13 04:20:49 | Niigata, Japan | |||
356339 | 356339 | 2022-03-11 | Japan | Niigata | 33417 | 85 | 0 | 37.521819 | 138.918647 | 2022-03-12 04:20:50 | Niigata, Japan | |||
1865491 | 1865491 | 2022-03-10 | Japan | Niigata | 32983 | 80 | 0 | 37.521819 | 138.918647 | 2022-03-11 04:20:50 | Niigata, Japan | |||
2140186 | 2140186 | 2022-03-09 | Japan | Niigata | 32572 | 80 | 0 | 37.521819 | 138.918647 | 2022-03-10 04:20:48 | Niigata, Japan | |||
919697 | 919697 | 2022-03-08 | Japan | Niigata | 32160 | 80 | 0 | 37.521819 | 138.918647 | 2022-03-09 04:20:59 | Niigata, Japan | |||
1547984 | 1547984 | 2022-03-07 | Japan | Niigata | 31829 | 73 | 0 | 37.521819 | 138.918647 | 2022-03-08 04:20:54 | Niigata, Japan | |||
2199653 | 2199653 | 2022-03-06 | Japan | Niigata | 31597 | 73 | 0 | 37.521819 | 138.918647 | 2022-03-07 04:20:47 | Niigata, Japan | |||
2092110 | 2092110 | 2022-03-05 | Japan | Niigata | 31336 | 73 | 0 | 37.521819 | 138.918647 | 2022-03-06 04:20:49 | Niigata, 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]);