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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
2665810 | 2665810 | 2022-03-04 | Japan | Niigata | 30968 | 73 | 0 | 37.521819 | 138.918647 | 2022-03-05 04:21:10 | Niigata, Japan | |||
1644375 | 1644375 | 2022-03-03 | Japan | Niigata | 30594 | 71 | 0 | 37.521819 | 138.918647 | 2022-03-04 04:21:09 | Niigata, Japan | |||
2525378 | 2525378 | 2022-03-02 | Japan | Niigata | 30197 | 71 | 0 | 37.521819 | 138.918647 | 2022-03-03 04:21:01 | Niigata, Japan | |||
1992672 | 1992672 | 2022-03-01 | Japan | Niigata | 29766 | 68 | 0 | 37.521819 | 138.918647 | 2022-03-02 04:21:07 | Niigata, Japan | |||
942846 | 942846 | 2022-02-28 | Japan | Niigata | 29453 | 68 | 0 | 37.521819 | 138.918647 | 2022-03-01 04:21:09 | Niigata, Japan | |||
2733037 | 2733037 | 2022-02-27 | Japan | Niigata | 29177 | 68 | 0 | 37.521819 | 138.918647 | 2022-02-28 04:21:05 | Niigata, Japan | |||
3046190 | 3046190 | 2022-02-26 | Japan | Niigata | 28724 | 68 | 0 | 37.521819 | 138.918647 | 2022-02-27 04:21:04 | Niigata, Japan | |||
574845 | 574845 | 2022-02-25 | Japan | Niigata | 28229 | 68 | 0 | 37.521819 | 138.918647 | 2022-02-26 04:21:12 | Niigata, Japan | |||
1511421 | 1511421 | 2022-02-24 | Japan | Niigata | 27869 | 68 | 0 | 37.521819 | 138.918647 | 2022-02-25 04:21:11 | Niigata, Japan | |||
1057862 | 1057862 | 2022-02-23 | Japan | Niigata | 27413 | 66 | 0 | 37.521819 | 138.918647 | 2022-02-24 04:21:14 | Niigata, Japan | |||
2446785 | 2446785 | 2022-02-22 | Japan | Niigata | 26851 | 66 | 0 | 37.521819 | 138.918647 | 2022-02-23 04:21:09 | Niigata, Japan | |||
3718198 | 3718198 | 2022-02-21 | Japan | Niigata | 26413 | 65 | 0 | 37.521819 | 138.918647 | 2022-02-22 04:21:01 | Niigata, Japan | |||
3912032 | 3912032 | 2022-02-20 | Japan | Niigata | 26113 | 65 | 0 | 37.521819 | 138.918647 | 2022-02-21 04:21:05 | Niigata, Japan | |||
3875590 | 3875590 | 2022-02-19 | Japan | Niigata | 25698 | 65 | 0 | 37.521819 | 138.918647 | 2022-02-20 04:21:00 | Niigata, Japan | |||
3855846 | 3855846 | 2022-02-18 | Japan | Niigata | 25214 | 65 | 0 | 37.521819 | 138.918647 | 2022-02-19 04:21:11 | Niigata, Japan | |||
1298065 | 1298065 | 2022-02-17 | Japan | Niigata | 24689 | 65 | 0 | 37.521819 | 138.918647 | 2022-02-18 04:21:04 | Niigata, Japan | |||
3820451 | 3820451 | 2022-02-16 | Japan | Niigata | 24139 | 65 | 0 | 37.521819 | 138.918647 | 2022-02-17 04:20:56 | Niigata, Japan | |||
3671665 | 3671665 | 2022-02-15 | Japan | Niigata | 23523 | 65 | 0 | 37.521819 | 138.918647 | 2022-02-16 04:21:10 | Niigata, Japan | |||
2641766 | 2641766 | 2022-02-14 | Japan | Niigata | 23047 | 65 | 0 | 37.521819 | 138.918647 | 2022-02-15 04:21:09 | Niigata, Japan | |||
186083 | 186083 | 2022-02-13 | Japan | Niigata | 22640 | 65 | 0 | 37.521819 | 138.918647 | 2022-02-14 04:20:51 | Niigata, Japan | |||
315929 | 315929 | 2022-02-12 | Japan | Niigata | 22293 | 65 | 0 | 37.521819 | 138.918647 | 2022-02-13 04:21:00 | Niigata, Japan | |||
233255 | 233255 | 2022-02-11 | Japan | Niigata | 21920 | 65 | 0 | 37.521819 | 138.918647 | 2022-02-12 04:21:06 | Niigata, Japan | |||
1464097 | 1464097 | 2022-02-10 | Japan | Niigata | 21316 | 65 | 0 | 37.521819 | 138.918647 | 2022-02-11 04:21:09 | Niigata, Japan | |||
3074058 | 3074058 | 2022-02-09 | Japan | Niigata | 20772 | 65 | 0 | 37.521819 | 138.918647 | 2022-02-10 04:21:14 | Niigata, Japan | |||
1362365 | 1362365 | 2022-02-08 | Japan | Niigata | 20152 | 64 | 0 | 37.521819 | 138.918647 | 2022-02-09 04:21:04 | Niigata, Japan | |||
71103 | 71103 | 2022-02-07 | Japan | Niigata | 19748 | 63 | 0 | 37.521819 | 138.918647 | 2022-02-08 04:21:15 | Niigata, Japan | |||
2012719 | 2012719 | 2022-02-06 | Japan | Niigata | 19415 | 63 | 0 | 37.521819 | 138.918647 | 2022-02-07 04:21:05 | Niigata, Japan | |||
1294048 | 1294048 | 2022-02-05 | Japan | Niigata | 19045 | 63 | 0 | 37.521819 | 138.918647 | 2022-02-06 04:21:00 | Niigata, Japan | |||
2327376 | 2327376 | 2022-02-04 | Japan | Niigata | 18495 | 63 | 0 | 37.521819 | 138.918647 | 2022-02-05 04:21:05 | Niigata, Japan | |||
2473967 | 2473967 | 2022-02-03 | Japan | Niigata | 18000 | 63 | 0 | 37.521819 | 138.918647 | 2022-02-04 04:21:10 | Niigata, Japan | |||
459392 | 459392 | 2022-02-02 | Japan | Niigata | 17428 | 63 | 0 | 37.521819 | 138.918647 | 2022-02-03 04:21:21 | 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]);