johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
21 rows where country_or_region = "Canada" and deaths = 67 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: latitude, combined_key
province_or_state 4
- Nova Scotia 18
- Manitoba 1
- Ontario 1
- Quebec 1
country_or_region 1
- Canada · 21 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2760690 | 2760690 | 2021-05-03 | Canada | Nova Scotia | 2854 | 67 | 1844 | 943 | 44.682 | -63.7443 | 2021-05-04 04:20:34 | Nova Scotia, Canada | ||
2450543 | 2450543 | 2021-05-02 | Canada | Nova Scotia | 2708 | 67 | 1819 | 822 | 44.682 | -63.7443 | 2021-05-03 04:20:39 | Nova Scotia, Canada | ||
2824556 | 2824556 | 2021-05-01 | Canada | Nova Scotia | 2575 | 67 | 1795 | 713 | 44.682 | -63.7443 | 2021-05-02 04:20:48 | Nova Scotia, Canada | ||
379964 | 379964 | 2021-04-30 | Canada | Nova Scotia | 2427 | 67 | 1771 | 589 | 44.682 | -63.7443 | 2021-05-01 04:20:47 | Nova Scotia, Canada | ||
1636087 | 1636087 | 2021-04-29 | Canada | Nova Scotia | 2360 | 67 | 1745 | 548 | 44.682 | -63.7443 | 2021-04-30 04:21:03 | Nova Scotia, Canada | ||
3393166 | 3393166 | 2021-04-28 | Canada | Nova Scotia | 2290 | 67 | 1734 | 489 | 44.682 | -63.7443 | 2021-04-29 04:20:55 | Nova Scotia, Canada | ||
3701882 | 3701882 | 2021-04-27 | Canada | Nova Scotia | 2215 | 67 | 1729 | 419 | 44.682 | -63.7443 | 2021-04-28 04:20:32 | Nova Scotia, Canada | ||
887891 | 887891 | 2021-04-26 | Canada | Nova Scotia | 2119 | 67 | 1729 | 323 | 44.682 | -63.7443 | 2021-04-27 04:20:52 | Nova Scotia, Canada | ||
954636 | 954636 | 2021-04-25 | Canada | Nova Scotia | 2053 | 67 | 1723 | 263 | 44.682 | -63.7443 | 2021-04-26 04:21:04 | Nova Scotia, Canada | ||
3923783 | 3923783 | 2021-04-24 | Canada | Nova Scotia | 1990 | 67 | 1722 | 201 | 44.682 | -63.7443 | 2021-04-25 04:20:32 | Nova Scotia, Canada | ||
1408814 | 1408814 | 2021-04-23 | Canada | Nova Scotia | 1938 | 67 | 1721 | 150 | 44.682 | -63.7443 | 2021-04-24 04:20:38 | Nova Scotia, Canada | ||
1567877 | 1567877 | 2021-04-22 | Canada | Nova Scotia | 1894 | 67 | 1716 | 111 | 44.682 | -63.7443 | 2021-04-23 04:20:52 | Nova Scotia, Canada | ||
3242098 | 3242098 | 2021-04-21 | Canada | Nova Scotia | 1856 | 67 | 1710 | 79 | 44.682 | -63.7443 | 2021-04-22 04:20:53 | Nova Scotia, Canada | ||
2020494 | 2020494 | 2021-04-20 | Canada | Nova Scotia | 1831 | 67 | 1696 | 68 | 44.682 | -63.7443 | 2021-04-21 04:21:14 | Nova Scotia, Canada | ||
2410615 | 2410615 | 2021-04-19 | Canada | Nova Scotia | 1822 | 67 | 1692 | 63 | 44.682 | -63.7443 | 2021-04-20 04:20:41 | Nova Scotia, Canada | ||
3129292 | 3129292 | 2021-04-18 | Canada | Nova Scotia | 1807 | 67 | 1691 | 49 | 44.682 | -63.7443 | 2021-04-19 04:20:57 | Nova Scotia, Canada | ||
982720 | 982720 | 2021-04-17 | Canada | Nova Scotia | 1800 | 67 | 1689 | 44 | 44.682 | -63.7443 | 2021-04-18 04:20:41 | Nova Scotia, Canada | ||
169815 | 169815 | 2021-04-16 | Canada | Nova Scotia | 1792 | 67 | 1683 | 42 | 44.682 | -63.7443 | 2021-04-17 04:20:40 | Nova Scotia, Canada | ||
2079702 | 2079702 | 2020-10-31 | Canada | Manitoba | 5723 | 67 | 2646 | 3010 | 53.7609 | -98.8139 | 2020-11-01 04:36:19 | Manitoba, Canada | ||
3740522 | 3740522 | 2020-04-03 | Canada | Ontario | 4780 | 67 | 0 | 3188 | 51.2538 | -85.3232 | 2020-04-03 22:52:30 | Ontario, Canada | ||
1872405 | 1872405 | 2020-03-30 | Canada | Quebec | 4153 | 67 | 0 | 4086 | 52.9399 | -73.5491 | 3/30/20 22:58 | Quebec, 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]);