johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
2,039 rows where province_or_state = "Diamond Princess" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
country_or_region 3
- US 419
- Canada 395
- Cruise Ship 13
province_or_state 1
- Diamond Princess · 827 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2450537 | 2450537 | 2021-05-02 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
2451441 | 2451441 | 2021-05-02 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
2824550 | 2824550 | 2021-05-01 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
2825454 | 2825454 | 2021-05-01 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
379958 | 379958 | 2021-04-30 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
380862 | 380862 | 2021-04-30 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
1636081 | 1636081 | 2021-04-29 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
1636985 | 1636985 | 2021-04-29 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
3393160 | 3393160 | 2021-04-28 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3394064 | 3394064 | 2021-04-28 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
3701876 | 3701876 | 2021-04-27 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3702780 | 3702780 | 2021-04-27 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
887885 | 887885 | 2021-04-26 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
888789 | 888789 | 2021-04-26 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
954630 | 954630 | 2021-04-25 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
955534 | 955534 | 2021-04-25 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
3923777 | 3923777 | 2021-04-24 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3924681 | 3924681 | 2021-04-24 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
1408808 | 1408808 | 2021-04-23 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
1409712 | 1409712 | 2021-04-23 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
1567871 | 1567871 | 2021-04-22 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
1568775 | 1568775 | 2021-04-22 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
3242092 | 3242092 | 2021-04-21 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3242996 | 3242996 | 2021-04-21 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
2020488 | 2020488 | 2021-04-20 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
2021392 | 2021392 | 2021-04-20 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
2410609 | 2410609 | 2021-04-19 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
2411513 | 2411513 | 2021-04-19 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
3129286 | 3129286 | 2021-04-18 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3130190 | 3130190 | 2021-04-18 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
982714 | 982714 | 2021-04-17 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
983618 | 983618 | 2021-04-17 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
169809 | 169809 | 2021-04-16 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
170713 | 170713 | 2021-04-16 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
2548640 | 2548640 | 2021-04-15 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
2549544 | 2549544 | 2021-04-15 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
1841710 | 1841710 | 2021-04-14 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
1842614 | 1842614 | 2021-04-14 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
2571444 | 2571444 | 2021-04-13 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
2572348 | 2572348 | 2021-04-13 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
36195 | 36195 | 2021-04-12 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
37099 | 37099 | 2021-04-12 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
3883354 | 3883354 | 2021-04-11 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3884258 | 3884258 | 2021-04-11 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
2983022 | 2983022 | 2021-04-10 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
2983926 | 2983926 | 2021-04-10 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
605454 | 605454 | 2021-04-09 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
606358 | 606358 | 2021-04-09 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
2645518 | 2645518 | 2021-04-08 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
2646422 | 2646422 | 2021-04-08 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
2247160 | 2247160 | 2021-04-07 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
2248064 | 2248064 | 2021-04-07 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
3003070 | 3003070 | 2021-04-06 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3003974 | 3003974 | 2021-04-06 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
3085065 | 3085065 | 2021-04-05 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3085969 | 3085969 | 2021-04-05 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
387988 | 387988 | 2021-04-04 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
388892 | 388892 | 2021-04-04 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
3709904 | 3709904 | 2021-04-03 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3710808 | 3710808 | 2021-04-03 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
241020 | 241020 | 2021-04-02 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
241924 | 241924 | 2021-04-02 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
1301817 | 1301817 | 2021-04-01 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
1302719 | 1302719 | 2021-04-01 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
637689 | 637689 | 2021-03-31 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
638591 | 638591 | 2021-03-31 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
3643318 | 3643318 | 2021-03-30 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3644220 | 3644220 | 2021-03-30 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
1289771 | 1289771 | 2021-03-29 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
1290673 | 1290673 | 2021-03-29 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
1535693 | 1535693 | 2021-03-28 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
1536595 | 1536595 | 2021-03-28 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
1219333 | 1219333 | 2021-03-27 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
1220235 | 1220235 | 2021-03-27 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
1880751 | 1880751 | 2021-03-26 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
1881653 | 1881653 | 2021-03-26 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
1980381 | 1980381 | 2021-03-25 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
1981283 | 1981283 | 2021-03-25 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
2780759 | 2780759 | 2021-03-24 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
2781661 | 2781661 | 2021-03-24 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
1798404 | 1798404 | 2021-03-23 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
1799306 | 1799306 | 2021-03-23 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
1203572 | 1203572 | 2021-03-22 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
1204474 | 1204474 | 2021-03-22 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
3369094 | 3369094 | 2021-03-21 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3369996 | 3369996 | 2021-03-21 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
1744304 | 1744304 | 2021-03-20 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
1745206 | 1745206 | 2021-03-20 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
3420684 | 3420684 | 2021-03-19 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3421586 | 3421586 | 2021-03-19 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
3452622 | 3452622 | 2021-03-18 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3453524 | 3453524 | 2021-03-18 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
3620846 | 3620846 | 2021-03-17 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3621748 | 3621748 | 2021-03-17 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
702170 | 702170 | 2021-03-16 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
703072 | 703072 | 2021-03-16 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
2055648 | 2055648 | 2021-03-15 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
2056550 | 2056550 | 2021-03-15 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
1732260 | 1732260 | 2021-03-14 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
1733162 | 1733162 | 2021-03-14 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US |
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]);