johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
350 rows where active = 49 and province_or_state = "Diamond Princess" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: latitude, longitude, day (date), last_update (date)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3668289 | 3668289 | 2021-03-06 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
1616910 | 1616910 | 2021-03-05 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
2208321 | 2208321 | 2021-03-04 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
1090742 | 1090742 | 2021-03-03 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
3254814 | 3254814 | 2021-03-02 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
999106 | 999106 | 2021-03-01 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
2368164 | 2368164 | 2021-02-28 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
3066666 | 3066666 | 2021-02-27 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
2184250 | 2184250 | 2021-02-26 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
1858672 | 1858672 | 2021-02-25 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
280850 | 280850 | 2021-02-24 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
1937118 | 1937118 | 2021-02-23 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
531373 | 531373 | 2021-02-22 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
182707 | 182707 | 2021-02-21 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
742981 | 742981 | 2021-02-20 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
472079 | 472079 | 2021-02-19 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
1153788 | 1153788 | 2021-02-18 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
3601708 | 3601708 | 2021-02-17 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
3050843 | 3050843 | 2021-02-16 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
1338942 | 1338942 | 2021-02-15 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
2284093 | 2284093 | 2021-02-14 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
2678493 | 2678493 | 2021-02-13 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
3540126 | 3540126 | 2021-02-12 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
2638389 | 2638389 | 2021-02-11 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
3979244 | 3979244 | 2021-02-10 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
1528564 | 1528564 | 2021-02-09 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
614355 | 614355 | 2021-02-08 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
1673124 | 1673124 | 2021-02-07 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
975585 | 975585 | 2021-02-06 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
1588843 | 1588843 | 2021-02-05 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
791050 | 791050 | 2021-02-04 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
340942 | 340942 | 2021-02-03 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
1685168 | 1685168 | 2021-02-02 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
1677138 | 1677138 | 2021-02-01 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
1460426 | 1460426 | 2021-01-31 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
2212334 | 2212334 | 2021-01-30 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
1897821 | 1897821 | 2021-01-29 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
2482637 | 2482637 | 2021-01-28 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
3154272 | 3154272 | 2021-01-27 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
13007 | 13007 | 2021-01-26 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
2568331 | 2568331 | 2021-01-25 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
1759963 | 1759963 | 2021-01-24 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
2427570 | 2427570 | 2021-01-23 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
2467472 | 2467472 | 2021-01-22 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
436023 | 436023 | 2021-01-21 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
1094754 | 1094754 | 2021-01-20 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
908844 | 908844 | 2021-01-19 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
237907 | 237907 | 2021-01-18 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
3504024 | 3504024 | 2021-01-17 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
3102107 | 3102107 | 2021-01-16 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
3516069 | 3516069 | 2021-01-15 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
3880242 | 3880242 | 2021-01-14 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
3308869 | 3308869 | 2021-01-13 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
775014 | 775014 | 2021-01-12 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
190735 | 190735 | 2021-01-11 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
2626538 | 2626538 | 2021-01-10 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
3900626 | 3900626 | 2021-01-09 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
154649 | 154649 | 2021-01-08 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
2542073 | 2542073 | 2021-01-07 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
2865382 | 2865382 | 2021-01-06 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
3034969 | 3034969 | 2021-01-05 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
1062514 | 1062514 | 2021-01-04 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
3231117 | 3231117 | 2021-01-03 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
2228186 | 2228186 | 2021-01-02 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
1137550 | 1137550 | 2021-01-01 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
3696156 | 3696156 | 2020-12-31 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
1010971 | 1010971 | 2020-12-30 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
766986 | 766986 | 2020-12-29 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
3762250 | 3762250 | 2020-12-28 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
3778570 | 3778570 | 2020-12-27 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
2224175 | 2224175 | 2020-12-26 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
202922 | 202922 | 2020-12-25 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
3692145 | 3692145 | 2020-12-24 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
2407497 | 2407497 | 2020-12-23 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
3770543 | 3770543 | 2020-12-22 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
928359 | 928359 | 2020-12-21 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
2120380 | 2120380 | 2020-12-20 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
2931887 | 2931887 | 2020-12-19 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
1901833 | 1901833 | 2020-12-18 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
2128659 | 2128659 | 2020-12-17 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
3150259 | 3150259 | 2020-12-16 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
1035040 | 1035040 | 2020-12-15 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
1751934 | 1751934 | 2020-12-14 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
3848454 | 3848454 | 2020-12-13 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
846236 | 846236 | 2020-12-12 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
861343 | 861343 | 2020-12-11 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
1600885 | 1600885 | 2020-12-10 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
2975894 | 2975894 | 2020-12-09 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
1819454 | 1819454 | 2020-12-08 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
2348090 | 2348090 | 2020-12-07 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
1006960 | 1006960 | 2020-12-06 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
1632969 | 1632969 | 2020-12-05 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
3860497 | 3860497 | 2020-12-04 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
75755 | 75755 | 2020-12-03 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
738967 | 738967 | 2020-12-02 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
2538061 | 2538061 | 2020-12-01 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
1584830 | 1584830 | 2020-11-30 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
3567233 | 3567233 | 2020-11-29 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
2935898 | 2935898 | 2020-11-28 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | |
392901 | 392901 | 2020-11-27 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 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]);