johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,015 rows where country_or_region = "Canada" and province_or_state = "Grand Princess" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3101208 | 3101208 | 2021-01-16 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
3515170 | 3515170 | 2021-01-15 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
3879343 | 3879343 | 2021-01-14 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
3307970 | 3307970 | 2021-01-13 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
774115 | 774115 | 2021-01-12 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
189836 | 189836 | 2021-01-11 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
2625639 | 2625639 | 2021-01-10 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
3899727 | 3899727 | 2021-01-09 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
153750 | 153750 | 2021-01-08 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
2541174 | 2541174 | 2021-01-07 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
2864483 | 2864483 | 2021-01-06 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
3034070 | 3034070 | 2021-01-05 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
1061615 | 1061615 | 2021-01-04 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
3230218 | 3230218 | 2021-01-03 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
2227288 | 2227288 | 2021-01-02 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
1136652 | 1136652 | 2021-01-01 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
3695258 | 3695258 | 2020-12-31 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
1010073 | 1010073 | 2020-12-30 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
766088 | 766088 | 2020-12-29 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
3761352 | 3761352 | 2020-12-28 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
3777672 | 3777672 | 2020-12-27 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
2223277 | 2223277 | 2020-12-26 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
202024 | 202024 | 2020-12-25 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
3691247 | 3691247 | 2020-12-24 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
2406599 | 2406599 | 2020-12-23 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
3769645 | 3769645 | 2020-12-22 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
927461 | 927461 | 2020-12-21 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | ||
2119482 | 2119482 | 2020-12-20 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-21 05:27:58 | Grand Princess, Canada | ||
2930989 | 2930989 | 2020-12-19 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-20 05:27:32 | Grand Princess, Canada | ||
1900935 | 1900935 | 2020-12-18 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-19 05:27:52 | Grand Princess, Canada | ||
2127761 | 2127761 | 2020-12-17 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-18 05:28:18 | Grand Princess, Canada | ||
3149361 | 3149361 | 2020-12-16 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-17 05:28:12 | Grand Princess, Canada | ||
1034142 | 1034142 | 2020-12-15 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-16 05:28:04 | Grand Princess, Canada | ||
1751036 | 1751036 | 2020-12-14 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-15 05:26:38 | Grand Princess, Canada | ||
3847556 | 3847556 | 2020-12-13 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-14 05:26:27 | Grand Princess, Canada | ||
845338 | 845338 | 2020-12-12 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-13 05:27:20 | Grand Princess, Canada | ||
860445 | 860445 | 2020-12-11 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-12 05:26:19 | Grand Princess, Canada | ||
1599987 | 1599987 | 2020-12-10 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-11 05:26:59 | Grand Princess, Canada | ||
2974996 | 2974996 | 2020-12-09 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-10 05:26:19 | Grand Princess, Canada | ||
1818556 | 1818556 | 2020-12-08 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-09 05:28:01 | Grand Princess, Canada | ||
2347192 | 2347192 | 2020-12-07 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-08 05:27:42 | Grand Princess, Canada | ||
1006062 | 1006062 | 2020-12-06 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-07 05:26:14 | Grand Princess, Canada | ||
1632071 | 1632071 | 2020-12-05 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-06 05:26:18 | Grand Princess, Canada | ||
3859599 | 3859599 | 2020-12-04 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-05 05:27:36 | Grand Princess, Canada | ||
74857 | 74857 | 2020-12-03 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-04 05:27:27 | Grand Princess, Canada | ||
738069 | 738069 | 2020-12-02 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-03 05:28:22 | Grand Princess, Canada | ||
2537163 | 2537163 | 2020-12-01 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-02 05:27:41 | Grand Princess, Canada | ||
1583932 | 1583932 | 2020-11-30 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-12-01 05:26:18 | Grand Princess, Canada | ||
3566335 | 3566335 | 2020-11-29 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-11-30 05:26:13 | Grand Princess, Canada | ||
2935000 | 2935000 | 2020-11-28 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-11-29 05:25:55 | Grand Princess, Canada | ||
392003 | 392003 | 2020-11-27 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-11-28 05:25:50 | Grand Princess, Canada | ||
923450 | 923450 | 2020-11-26 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-11-27 05:26:53 | Grand Princess, Canada | ||
1972355 | 1972355 | 2020-11-25 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-11-26 05:27:44 | Grand Princess, Canada | ||
1350086 | 1350086 | 2020-11-24 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-11-25 05:27:20 | Grand Princess, Canada | ||
678081 | 678081 | 2020-11-23 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-11-24 05:27:31 | Grand Princess, Canada | ||
3189757 | 3189757 | 2020-11-22 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-11-23 05:25:26 | Grand Princess, Canada | ||
3836251 | 3836251 | 2020-11-21 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-11-22 05:25:45 | Grand Princess, Canada | ||
2701279 | 2701279 | 2020-11-20 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-11-21 05:25:51 | Grand Princess, Canada | ||
821339 | 821339 | 2020-11-19 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-11-20 05:26:28 | Grand Princess, Canada | ||
122473 | 122473 | 2020-11-18 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-11-19 05:25:23 | Grand Princess, Canada | ||
3338361 | 3338361 | 2020-11-17 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-11-18 05:40:31 | Grand Princess, Canada | ||
3169406 | 3169406 | 2020-11-16 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-11-17 05:25:54 | Grand Princess, Canada | ||
2879974 | 2879974 | 2020-11-15 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-11-16 05:25:57 | Grand Princess, Canada | ||
2914952 | 2914952 | 2020-11-14 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-11-15 05:26:53 | Grand Princess, Canada | ||
2784774 | 2784774 | 2020-11-13 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-11-14 05:25:37 | Grand Princess, Canada | ||
864539 | 864539 | 2020-11-12 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-11-13 05:25:30 | Grand Princess, Canada | ||
3440584 | 3440584 | 2020-11-11 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-11-12 05:25:55 | Grand Princess, Canada | ||
271924 | 271924 | 2020-11-10 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-11-11 05:25:30 | Grand Princess, Canada | ||
1988401 | 1988401 | 2020-11-09 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-11-10 05:40:07 | Grand Princess, Canada | ||
1728253 | 1728253 | 2020-11-08 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-11-09 05:25:45 | Grand Princess, Canada | ||
1543713 | 1543713 | 2020-11-07 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-11-08 05:24:56 | Grand Princess, Canada | ||
375951 | 375951 | 2020-11-06 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-11-07 05:24:52 | Grand Princess, Canada | ||
891889 | 891889 | 2020-11-05 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-11-06 05:24:55 | Grand Princess, Canada | ||
2918951 | 2918951 | 2020-11-04 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-11-05 06:05:03 | Grand Princess, Canada | ||
2497788 | 2497788 | 2020-11-03 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-11-04 05:25:09 | Grand Princess, Canada | ||
3303963 | 3303963 | 2020-11-02 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-11-03 06:00:16 | Grand Princess, Canada | ||
3409212 | 3409212 | 2020-11-01 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-11-02 05:25:04 | Grand Princess, Canada | ||
2079701 | 2079701 | 2020-10-31 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-11-01 04:36:19 | Grand Princess, Canada | ||
2243154 | 2243154 | 2020-10-30 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-10-31 04:24:44 | Grand Princess, Canada | ||
210009 | 210009 | 2020-10-29 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-10-30 04:24:49 | Grand Princess, Canada | ||
754071 | 754071 | 2020-10-28 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-10-29 04:24:49 | Grand Princess, Canada | ||
1452356 | 1452356 | 2020-10-27 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-10-28 04:24:39 | Grand Princess, Canada | ||
3480080 | 3480080 | 2020-10-26 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-10-27 04:24:45 | Grand Princess, Canada | ||
8101 | 8101 | 2020-10-25 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-10-26 04:25:02 | Grand Princess, Canada | ||
3651338 | 3651338 | 2020-10-24 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-10-25 04:24:36 | Grand Princess, Canada | ||
1053593 | 1053593 | 2020-10-23 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-10-24 04:24:46 | Grand Princess, Canada | ||
1177263 | 1177263 | 2020-10-22 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-10-23 04:24:46 | Grand Princess, Canada | ||
2191368 | 2191368 | 2020-10-21 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-10-22 04:24:27 | Grand Princess, Canada | ||
3990379 | 3990379 | 2020-10-20 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-10-21 04:24:14 | Grand Princess, Canada | ||
1794399 | 1794399 | 2020-10-19 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-10-20 04:24:22 | Grand Princess, Canada | ||
762083 | 762083 | 2020-10-18 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-10-19 04:24:16 | Grand Princess, Canada | ||
1026121 | 1026121 | 2020-10-17 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-10-18 04:24:25 | Grand Princess, Canada | ||
2856616 | 2856616 | 2020-10-16 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-10-17 04:24:12 | Grand Princess, Canada | ||
786146 | 786146 | 2020-10-15 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-10-16 04:24:01 | Grand Princess, Canada | ||
78857 | 78857 | 2020-10-14 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-10-15 04:24:28 | Grand Princess, Canada | ||
3781672 | 3781672 | 2020-10-13 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-10-14 04:24:05 | Grand Princess, Canada | ||
2291212 | 2291212 | 2020-10-12 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-10-13 04:24:02 | Grand Princess, Canada | ||
3785665 | 3785665 | 2020-10-11 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-10-12 04:23:45 | Grand Princess, Canada | ||
2601803 | 2601803 | 2020-10-10 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-10-11 04:23:46 | Grand Princess, Canada | ||
817336 | 817336 | 2020-10-09 | Canada | Grand Princess | 13 | 0 | 13 | 0 | 37.6489 | 0.0 | 2020-10-10 04:23:57 | Grand 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]);