johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,010 rows where combined_key = "Nova Scotia, Canada" and country_or_region = "Canada" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 1
- Nova Scotia 451
country_or_region 1
- Canada · 451 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1125365 | 1125365 | 2021-06-18 | Canada | Nova Scotia | 5784 | 90 | 5601 | 93 | 44.682 | -63.7443 | 2021-06-19 04:22:33 | Nova Scotia, Canada | ||
2910943 | 2910943 | 2021-06-17 | Canada | Nova Scotia | 5773 | 90 | 5586 | 97 | 44.682 | -63.7443 | 2021-06-18 04:22:16 | Nova Scotia, Canada | ||
3030061 | 3030061 | 2021-06-16 | Canada | Nova Scotia | 5759 | 90 | 5577 | 92 | 44.682 | -63.7443 | 2021-06-17 04:22:36 | Nova Scotia, Canada | ||
2339167 | 2339167 | 2021-06-15 | Canada | Nova Scotia | 5751 | 90 | 5564 | 97 | 44.682 | -63.7443 | 2021-06-16 04:22:32 | Nova Scotia, Canada | ||
1563863 | 1563863 | 2021-06-14 | Canada | Nova Scotia | 5749 | 90 | 5535 | 124 | 44.682 | -63.7443 | 2021-06-15 04:22:22 | Nova Scotia, Canada | ||
3381146 | 3381146 | 2021-06-13 | Canada | Nova Scotia | 5742 | 89 | 5513 | 140 | 44.682 | -63.7443 | 2021-06-14 04:22:46 | Nova Scotia, Canada | ||
1736280 | 1736280 | 2021-06-12 | Canada | Nova Scotia | 5736 | 89 | 5502 | 145 | 44.682 | -63.7443 | 2021-06-13 04:22:44 | Nova Scotia, Canada | ||
3970321 | 3970321 | 2021-06-11 | Canada | Nova Scotia | 5726 | 89 | 5497 | 143 | 44.682 | -63.7443 | 2021-06-12 04:22:22 | Nova Scotia, Canada | ||
2716743 | 2716743 | 2021-06-10 | Canada | Nova Scotia | 5721 | 88 | 5486 | 147 | 44.682 | -63.7443 | 2021-06-11 04:23:20 | Nova Scotia, Canada | ||
522628 | 522628 | 2021-06-09 | Canada | Nova Scotia | 5707 | 88 | 5455 | 164 | 44.682 | -63.7443 | 2021-06-10 04:23:17 | Nova Scotia, Canada | ||
3472068 | 3472068 | 2021-06-08 | Canada | Nova Scotia | 5694 | 88 | 5435 | 171 | 44.682 | -63.7443 | 2021-06-09 04:23:31 | Nova Scotia, Canada | ||
3145352 | 3145352 | 2021-06-07 | Canada | Nova Scotia | 5680 | 88 | 5407 | 185 | 44.682 | -63.7443 | 2021-06-08 04:22:35 | Nova Scotia, Canada | ||
825354 | 825354 | 2021-06-06 | Canada | Nova Scotia | 5663 | 88 | 5371 | 204 | 44.682 | -63.7443 | 2021-06-07 04:22:51 | Nova Scotia, Canada | ||
2585759 | 2585759 | 2021-06-05 | Canada | Nova Scotia | 5651 | 88 | 5339 | 224 | 44.682 | -63.7443 | 2021-06-06 04:24:03 | Nova Scotia, Canada | ||
2315073 | 2315073 | 2021-06-04 | Canada | Nova Scotia | 5633 | 88 | 5294 | 251 | 44.682 | -63.7443 | 2021-06-05 04:23:03 | Nova Scotia, Canada | ||
1448358 | 1448358 | 2021-06-03 | Canada | Nova Scotia | 5618 | 88 | 5257 | 273 | 44.682 | -63.7443 | 2021-06-04 04:23:37 | Nova Scotia, Canada | ||
1708082 | 1708082 | 2021-06-02 | Canada | Nova Scotia | 5593 | 87 | 5197 | 311 | 44.682 | -63.7443 | 2021-06-03 04:23:32 | Nova Scotia, Canada | ||
2103900 | 2103900 | 2021-06-01 | Canada | Nova Scotia | 5579 | 85 | 5125 | 369 | 44.682 | -63.7443 | 2021-06-02 04:24:34 | Nova Scotia, Canada | ||
1188516 | 1188516 | 2021-05-31 | Canada | Nova Scotia | 5567 | 85 | 5034 | 448 | 44.682 | -63.7443 | 2021-06-01 04:23:09 | Nova Scotia, Canada | ||
3089193 | 3089193 | 2021-05-30 | Canada | Nova Scotia | 5550 | 85 | 4960 | 505 | 44.682 | -63.7443 | 2021-05-31 03:08:59 | Nova Scotia, Canada | ||
50562 | 50562 | 2021-05-29 | Canada | Nova Scotia | 5530 | 84 | 4880 | 566 | 44.682 | -63.7443 | 2021-05-30 04:20:55 | Nova Scotia, Canada | ||
20141 | 20141 | 2021-05-28 | Canada | Nova Scotia | 5497 | 80 | 4832 | 585 | 44.682 | -63.7443 | 2021-05-29 04:20:41 | Nova Scotia, Canada | ||
1806516 | 1806516 | 2021-05-27 | Canada | Nova Scotia | 5457 | 79 | 4740 | 638 | 44.682 | -63.7443 | 2021-05-28 04:20:36 | Nova Scotia, Canada | ||
1309940 | 1309940 | 2021-05-26 | Canada | Nova Scotia | 5424 | 79 | 4558 | 787 | 44.682 | -63.7443 | 2021-05-27 04:20:59 | Nova Scotia, Canada | ||
82866 | 82866 | 2021-05-25 | Canada | Nova Scotia | 5387 | 79 | 4464 | 846 | 44.682 | -63.7443 | 2021-05-26 04:20:35 | Nova Scotia, Canada | ||
1412828 | 1412828 | 2021-05-24 | Canada | Nova Scotia | 5335 | 79 | 4362 | 894 | 44.682 | -63.7443 | 2021-05-25 04:21:08 | Nova Scotia, Canada | ||
1771114 | 1771114 | 2021-05-23 | Canada | Nova Scotia | 5286 | 79 | 4264 | 943 | 44.682 | -63.7443 | 2021-05-24 04:20:53 | Nova Scotia, Canada | ||
726269 | 726269 | 2021-05-22 | Canada | Nova Scotia | 5213 | 77 | 4161 | 975 | 44.682 | -63.7443 | 2021-05-23 04:20:51 | Nova Scotia, Canada | ||
1952284 | 1952284 | 2021-05-21 | Canada | Nova Scotia | 5149 | 76 | 4045 | 1028 | 44.682 | -63.7443 | 2021-05-22 04:20:45 | Nova Scotia, Canada | ||
1912983 | 1912983 | 2021-05-20 | Canada | Nova Scotia | 5065 | 74 | 3848 | 1143 | 44.682 | -63.7443 | 2021-05-21 04:20:43 | Nova Scotia, Canada | ||
2255504 | 2255504 | 2021-05-19 | Canada | Nova Scotia | 5000 | 74 | 3664 | 1262 | 44.682 | -63.7443 | 2021-05-20 04:21:05 | Nova Scotia, Canada | ||
2390542 | 2390542 | 2021-05-18 | Canada | Nova Scotia | 4917 | 72 | 3500 | 1345 | 44.682 | -63.7443 | 2021-05-19 04:20:42 | Nova Scotia, Canada | ||
3574367 | 3574367 | 2021-05-17 | Canada | Nova Scotia | 4827 | 72 | 3320 | 1435 | 44.682 | -63.7443 | 2021-05-18 04:20:33 | Nova Scotia, Canada | ||
2939097 | 2939097 | 2021-05-16 | Canada | Nova Scotia | 4736 | 72 | 3133 | 1531 | 44.682 | -63.7443 | 2021-05-17 04:20:34 | Nova Scotia, Canada | ||
1872727 | 1872727 | 2021-05-15 | Canada | Nova Scotia | 4610 | 72 | 3030 | 1508 | 44.682 | -63.7443 | 2021-05-16 04:20:49 | Nova Scotia, Canada | ||
1081696 | 1081696 | 2021-05-14 | Canada | Nova Scotia | 4524 | 72 | 2915 | 1537 | 44.682 | -63.7443 | 2021-05-15 04:20:58 | Nova Scotia, Canada | ||
3053962 | 3053962 | 2021-05-13 | Canada | Nova Scotia | 4407 | 71 | 2764 | 1572 | 44.682 | -63.7443 | 2021-05-14 04:20:41 | Nova Scotia, Canada | ||
2004432 | 2004432 | 2021-05-12 | Canada | Nova Scotia | 4297 | 71 | 2609 | 1621 | 44.682 | -63.7443 | 2021-05-13 04:20:51 | Nova Scotia, Canada | ||
3954263 | 3954263 | 2021-05-11 | Canada | Nova Scotia | 4152 | 71 | 2490 | 1591 | 44.682 | -63.7443 | 2021-05-12 04:21:29 | Nova Scotia, Canada | ||
2820542 | 2820542 | 2021-05-10 | Canada | Nova Scotia | 4034 | 71 | 2312 | 1655 | 44.682 | -63.7443 | 2021-05-11 04:20:41 | Nova Scotia, Canada | ||
1424874 | 1424874 | 2021-05-09 | Canada | Nova Scotia | 3917 | 71 | 2222 | 1626 | 44.682 | -63.7443 | 2021-05-10 04:20:38 | Nova Scotia, Canada | ||
1551742 | 1551742 | 2021-05-08 | Canada | Nova Scotia | 3754 | 71 | 2145 | 1538 | 44.682 | -63.7443 | 2021-05-09 04:20:35 | Nova Scotia, Canada | ||
2501800 | 2501800 | 2021-05-07 | Canada | Nova Scotia | 3591 | 70 | 2057 | 1464 | 44.682 | -63.7443 | 2021-05-08 04:21:04 | Nova Scotia, Canada | ||
3113256 | 3113256 | 2021-05-06 | Canada | Nova Scotia | 3364 | 69 | 1986 | 1309 | 44.682 | -63.7443 | 2021-05-07 04:20:40 | Nova Scotia, Canada | ||
645723 | 645723 | 2021-05-05 | Canada | Nova Scotia | 3182 | 69 | 1910 | 1203 | 44.682 | -63.7443 | 2021-05-06 04:20:38 | Nova Scotia, Canada | ||
3675423 | 3675423 | 2021-05-04 | Canada | Nova Scotia | 3007 | 69 | 1878 | 1060 | 44.682 | -63.7443 | 2021-05-05 04:20:43 | Nova Scotia, Canada | ||
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 | ||
2548646 | 2548646 | 2021-04-15 | Canada | Nova Scotia | 1786 | 66 | 1678 | 42 | 44.682 | -63.7443 | 2021-04-16 04:20:46 | Nova Scotia, Canada | ||
1841716 | 1841716 | 2021-04-14 | Canada | Nova Scotia | 1783 | 66 | 1675 | 42 | 44.682 | -63.7443 | 2021-04-15 04:20:54 | Nova Scotia, Canada | ||
2571450 | 2571450 | 2021-04-13 | Canada | Nova Scotia | 1781 | 66 | 1670 | 45 | 44.682 | -63.7443 | 2021-04-14 04:20:41 | Nova Scotia, Canada | ||
36201 | 36201 | 2021-04-12 | Canada | Nova Scotia | 1775 | 66 | 1663 | 46 | 44.682 | -63.7443 | 2021-04-13 04:20:37 | Nova Scotia, Canada | ||
3883360 | 3883360 | 2021-04-11 | Canada | Nova Scotia | 1768 | 66 | 1662 | 40 | 44.682 | -63.7443 | 2021-04-12 04:21:00 | Nova Scotia, Canada | ||
2983028 | 2983028 | 2021-04-10 | Canada | Nova Scotia | 1763 | 66 | 1655 | 43 | 44.682 | -63.7443 | 2021-04-11 04:20:56 | Nova Scotia, Canada | ||
605460 | 605460 | 2021-04-09 | Canada | Nova Scotia | 1756 | 66 | 1649 | 41 | 44.682 | -63.7443 | 2021-04-10 04:20:59 | Nova Scotia, Canada | ||
2645524 | 2645524 | 2021-04-08 | Canada | Nova Scotia | 1754 | 66 | 1648 | 40 | 44.682 | -63.7443 | 2021-04-09 04:21:13 | Nova Scotia, Canada | ||
2247166 | 2247166 | 2021-04-07 | Canada | Nova Scotia | 1749 | 66 | 1646 | 37 | 44.682 | -63.7443 | 2021-04-08 04:21:13 | Nova Scotia, Canada | ||
3003076 | 3003076 | 2021-04-06 | Canada | Nova Scotia | 1747 | 66 | 1645 | 36 | 44.682 | -63.7443 | 2021-04-07 04:20:53 | Nova Scotia, Canada | ||
3085071 | 3085071 | 2021-04-05 | Canada | Nova Scotia | 1741 | 66 | 1645 | 31 | 44.682 | -63.7443 | 2021-04-06 04:20:32 | Nova Scotia, Canada | ||
387994 | 387994 | 2021-04-04 | Canada | Nova Scotia | 1739 | 66 | 1639 | 34 | 44.682 | -63.7443 | 2021-04-05 04:20:35 | Nova Scotia, Canada | ||
3709910 | 3709910 | 2021-04-03 | Canada | Nova Scotia | 1732 | 66 | 1634 | 32 | 44.682 | -63.7443 | 2021-04-04 04:20:49 | Nova Scotia, Canada | ||
241026 | 241026 | 2021-04-02 | Canada | Nova Scotia | 1728 | 66 | 1631 | 31 | 44.682 | -63.7443 | 2021-04-03 04:20:44 | Nova Scotia, Canada | ||
1301823 | 1301823 | 2021-04-01 | Canada | Nova Scotia | 1719 | 66 | 1629 | 24 | 44.682 | -63.7443 | 2021-04-02 04:20:36 | Nova Scotia, Canada | ||
637695 | 637695 | 2021-03-31 | Canada | Nova Scotia | 1716 | 66 | 1627 | 23 | 44.682 | -63.7443 | 2021-04-01 04:27:05 | Nova Scotia, Canada | ||
3643324 | 3643324 | 2021-03-30 | Canada | Nova Scotia | 1714 | 66 | 1624 | 24 | 44.682 | -63.7443 | 2021-03-31 04:26:25 | Nova Scotia, Canada | ||
1289777 | 1289777 | 2021-03-29 | Canada | Nova Scotia | 1711 | 66 | 1621 | 24 | 44.682 | -63.7443 | 2021-03-30 04:26:23 | Nova Scotia, Canada | ||
1535699 | 1535699 | 2021-03-28 | Canada | Nova Scotia | 1711 | 66 | 1620 | 25 | 44.682 | -63.7443 | 2021-03-29 04:28:35 | Nova Scotia, Canada | ||
1219339 | 1219339 | 2021-03-27 | Canada | Nova Scotia | 1709 | 66 | 1618 | 25 | 44.682 | -63.7443 | 2021-03-28 05:28:10 | Nova Scotia, Canada | ||
1880757 | 1880757 | 2021-03-26 | Canada | Nova Scotia | 1704 | 66 | 1611 | 27 | 44.682 | -63.7443 | 2021-03-27 05:25:04 | Nova Scotia, Canada | ||
1980387 | 1980387 | 2021-03-25 | Canada | Nova Scotia | 1699 | 66 | 1608 | 25 | 44.682 | -63.7443 | 2021-03-26 05:26:55 | Nova Scotia, Canada | ||
2780765 | 2780765 | 2021-03-24 | Canada | Nova Scotia | 1696 | 66 | 1606 | 24 | 44.682 | -63.7443 | 2021-03-25 05:27:00 | Nova Scotia, Canada | ||
1798410 | 1798410 | 2021-03-23 | Canada | Nova Scotia | 1691 | 66 | 1604 | 21 | 44.682 | -63.7443 | 2021-03-24 05:25:40 | Nova Scotia, Canada | ||
1203578 | 1203578 | 2021-03-22 | Canada | Nova Scotia | 1690 | 66 | 1604 | 20 | 44.682 | -63.7443 | 2021-03-23 05:26:18 | Nova Scotia, Canada | ||
3369100 | 3369100 | 2021-03-21 | Canada | Nova Scotia | 1688 | 66 | 1601 | 21 | 44.682 | -63.7443 | 2021-03-22 05:25:43 | Nova Scotia, Canada | ||
1744310 | 1744310 | 2021-03-20 | Canada | Nova Scotia | 1682 | 66 | 1599 | 17 | 44.682 | -63.7443 | 2021-03-21 05:25:44 | Nova Scotia, Canada | ||
3420690 | 3420690 | 2021-03-19 | Canada | Nova Scotia | 1680 | 66 | 1597 | 17 | 44.682 | -63.7443 | 2021-03-20 05:25:46 | Nova Scotia, Canada | ||
3452628 | 3452628 | 2021-03-18 | Canada | Nova Scotia | 1677 | 66 | 1594 | 17 | 44.682 | -63.7443 | 2021-03-19 05:26:09 | Nova Scotia, Canada | ||
3620852 | 3620852 | 2021-03-17 | Canada | Nova Scotia | 1674 | 65 | 1594 | 15 | 44.682 | -63.7443 | 2021-03-18 05:26:22 | Nova Scotia, Canada | ||
702176 | 702176 | 2021-03-16 | Canada | Nova Scotia | 1672 | 65 | 1590 | 17 | 44.682 | -63.7443 | 2021-03-17 05:25:07 | Nova Scotia, Canada | ||
2055654 | 2055654 | 2021-03-15 | Canada | Nova Scotia | 1670 | 65 | 1588 | 17 | 44.682 | -63.7443 | 2021-03-16 05:25:13 | Nova Scotia, Canada | ||
1732266 | 1732266 | 2021-03-14 | Canada | Nova Scotia | 1670 | 65 | 1587 | 18 | 44.682 | -63.7443 | 2021-03-15 05:25:51 | Nova Scotia, Canada | ||
1579923 | 1579923 | 2021-03-13 | Canada | Nova Scotia | 1669 | 65 | 1585 | 20 | 44.682 | -63.7443 | 2021-03-14 05:25:37 | Nova Scotia, Canada | ||
1837702 | 1837702 | 2021-03-12 | Canada | Nova Scotia | 1665 | 65 | 1584 | 17 | 44.682 | -63.7443 | 2021-03-13 05:25:15 | Nova Scotia, Canada | ||
352067 | 352067 | 2021-03-11 | Canada | Nova Scotia | 1665 | 65 | 1581 | 19 | 44.682 | -63.7443 | 2021-03-12 05:26:50 | Nova Scotia, 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]);