johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,001 rows where country_or_region = "Canada" and province_or_state = "Diamond Princess" sorted by rowid descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, day (date)
Link | rowid ▲ | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4002417 | 4002417 | 2022-10-08 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3998400 | 3998400 | 2021-12-30 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3994385 | 3994385 | 2022-09-27 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3990378 | 3990378 | 2020-10-20 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-10-21 04:24:14 | Diamond Princess, Canada | ||
3986374 | 3986374 | 2022-09-15 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3982358 | 3982358 | 2022-06-15 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3978343 | 3978343 | 2021-02-10 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3974329 | 3974329 | 2021-09-03 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3970315 | 3970315 | 2021-06-11 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3966300 | 3966300 | 2022-07-05 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3962285 | 3962285 | 2021-03-10 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3958271 | 3958271 | 2021-06-26 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3954257 | 3954257 | 2021-05-11 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3950242 | 3950242 | 2022-08-17 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3949870 | 3949870 | 2020-04-09 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-04-09 23:09:01 | Diamond Princess, Canada | ||
3946930 | 3946930 | 2020-03-28 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 3/28/20 23:10 | Diamond Princess, Canada | ||
3939809 | 3939809 | 2022-06-30 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3935793 | 3935793 | 2022-12-09 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3931795 | 3931795 | 2020-08-30 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-08-31 04:28:27 | Diamond Princess, Canada | ||
3927791 | 3927791 | 2021-10-02 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
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 | ||
3923083 | 3923083 | 2020-08-09 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-08-10 04:34:55 | Diamond Princess, Canada | ||
3915785 | 3915785 | 2022-05-01 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3911769 | 3911769 | 2022-02-20 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3907753 | 3907753 | 2022-08-11 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3903738 | 3903738 | 2021-07-31 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3899726 | 3899726 | 2021-01-09 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3895711 | 3895711 | 2022-05-19 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3891696 | 3891696 | 2021-08-29 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3887369 | 3887369 | 2022-06-06 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
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 | ||
3879342 | 3879342 | 2021-01-14 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3875327 | 3875327 | 2022-02-19 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3871311 | 3871311 | 2022-07-31 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3867295 | 3867295 | 2022-04-05 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3866665 | 3866665 | 2020-06-03 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-06-04 02:33:14 | Diamond Princess, Canada | ||
3859598 | 3859598 | 2020-12-04 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-05 05:27:36 | Diamond Princess, Canada | ||
3855583 | 3855583 | 2022-02-18 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3851567 | 3851567 | 2022-04-27 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3847555 | 3847555 | 2020-12-13 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-14 05:26:27 | Diamond Princess, Canada | ||
3847178 | 3847178 | 2020-05-13 | Canada | Diamond Princess | 1 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-05-14 03:32:28 | Diamond Princess, Canada | ||
3840260 | 3840260 | 2022-01-15 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3836250 | 3836250 | 2020-11-21 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-11-22 05:25:45 | Diamond Princess, Canada | ||
3832235 | 3832235 | 2021-10-05 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3828219 | 3828219 | 2021-12-21 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3824204 | 3824204 | 2022-09-10 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3820188 | 3820188 | 2022-02-16 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3816171 | 3816171 | 2021-12-23 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3815805 | 3815805 | 2020-03-31 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-03-31 23:49:13 | Diamond Princess, Canada | ||
3809682 | 3809682 | 2022-01-28 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3805668 | 3805668 | 2021-09-11 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3801665 | 3801665 | 2020-10-05 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-10-06 04:23:33 | Diamond Princess, Canada | ||
3797661 | 3797661 | 2022-08-20 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3793644 | 3793644 | 2021-10-25 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3792950 | 3792950 | 2020-08-05 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-08-06 04:35:02 | Diamond Princess, Canada | ||
3785664 | 3785664 | 2020-10-11 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-10-12 04:23:45 | Diamond Princess, Canada | ||
3781671 | 3781671 | 2020-10-13 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-10-14 04:24:05 | Diamond Princess, Canada | ||
3777671 | 3777671 | 2020-12-27 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3773656 | 3773656 | 2022-08-30 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3769644 | 3769644 | 2020-12-22 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3765629 | 3765629 | 2022-09-11 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3761351 | 3761351 | 2020-12-28 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3757238 | 3757238 | 2021-09-21 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3753223 | 3753223 | 2022-10-13 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3748876 | 3748876 | 2021-11-22 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3744861 | 3744861 | 2022-09-07 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3740846 | 3740846 | 2021-07-12 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3740478 | 3740478 | 2020-04-03 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-04-03 22:52:30 | Diamond Princess, Canada | ||
3737504 | 3737504 | 2020-07-12 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-07-13 04:43:04 | Diamond Princess, Canada | ||
3729983 | 3729983 | 2022-04-03 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3725967 | 3725967 | 2022-06-07 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3721951 | 3721951 | 2022-04-25 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3717935 | 3717935 | 2022-02-21 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3713919 | 3713919 | 2022-12-06 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
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 | ||
3705890 | 3705890 | 2021-07-17 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
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 | ||
3701508 | 3701508 | 2020-04-02 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 4/2/20 23:31 | Diamond Princess, Canada | ||
3695257 | 3695257 | 2020-12-31 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3691246 | 3691246 | 2020-12-24 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3687230 | 3687230 | 2022-01-13 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3683216 | 3683216 | 2021-08-02 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3682539 | 3682539 | 2020-06-18 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-06-19 04:33:17 | Diamond Princess, Canada | ||
3675417 | 3675417 | 2021-05-04 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3671402 | 3671402 | 2022-02-15 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3667387 | 3667387 | 2021-03-06 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3663373 | 3663373 | 2021-03-09 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3659359 | 3659359 | 2021-07-11 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3655343 | 3655343 | 2021-12-10 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3651337 | 3651337 | 2020-10-24 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-10-25 04:24:36 | Diamond Princess, Canada | ||
3647333 | 3647333 | 2022-08-14 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
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 | ||
3639302 | 3639302 | 2021-11-08 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3638763 | 3638763 | 2020-05-30 | Canada | Diamond Princess | 1 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-05-31 02:32:45 | Diamond Princess, Canada | ||
3631722 | 3631722 | 2021-07-14 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
3627707 | 3627707 | 2022-03-13 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3627334 | 3627334 | 2020-04-06 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 4/6/20 23:28 | Diamond Princess, Canada | ||
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 | ||
3616831 | 3616831 | 2022-08-01 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
3612814 | 3612814 | 2022-01-12 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada |
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]);