johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,016 rows where country_or_region = "Canada" and province_or_state = "Nova Scotia" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
3962291 | 3962291 | 2021-03-10 | Canada | Nova Scotia | 1665 | 65 | 1576 | 24 | 44.682 | -63.7443 | 2021-03-11 05:25:48 | Nova Scotia, Canada | ||
3663379 | 3663379 | 2021-03-09 | Canada | Nova Scotia | 1664 | 65 | 1573 | 26 | 44.682 | -63.7443 | 2021-03-10 05:24:35 | Nova Scotia, Canada | ||
2359238 | 2359238 | 2021-03-08 | Canada | Nova Scotia | 1659 | 65 | 1570 | 24 | 44.682 | -63.7443 | 2021-03-09 05:28:19 | Nova Scotia, Canada | ||
54576 | 54576 | 2021-03-07 | Canada | Nova Scotia | 1659 | 65 | 1565 | 29 | 44.682 | -63.7443 | 2021-03-08 05:24:48 | Nova Scotia, Canada | ||
3667393 | 3667393 | 2021-03-06 | Canada | Nova Scotia | 1657 | 65 | 1563 | 29 | 44.682 | -63.7443 | 2021-03-07 05:21:54 | Nova Scotia, Canada | ||
1616014 | 1616014 | 2021-03-05 | Canada | Nova Scotia | 1651 | 65 | 1555 | 31 | 44.682 | -63.7443 | 2021-03-06 04:23:41 | Nova Scotia, Canada | ||
2207425 | 2207425 | 2021-03-04 | Canada | Nova Scotia | 1649 | 65 | 1555 | 29 | 44.682 | -63.7443 | 2021-03-05 05:26:29 | Nova Scotia, Canada | ||
1089846 | 1089846 | 2021-03-03 | Canada | Nova Scotia | 1646 | 65 | 1551 | 30 | 44.682 | -63.7443 | 2021-03-04 05:24:24 | Nova Scotia, Canada | ||
3253918 | 3253918 | 2021-03-02 | Canada | Nova Scotia | 1643 | 65 | 1549 | 29 | 44.682 | -63.7443 | 2021-03-03 05:23:28 | Nova Scotia, Canada | ||
998210 | 998210 | 2021-03-01 | Canada | Nova Scotia | 1642 | 65 | 1542 | 35 | 44.682 | -63.7443 | 2021-03-02 05:23:30 | Nova Scotia, Canada | ||
2367268 | 2367268 | 2021-02-28 | Canada | Nova Scotia | 1641 | 65 | 1538 | 38 | 44.682 | -63.7443 | 2021-03-01 05:23:01 | Nova Scotia, Canada | ||
3065770 | 3065770 | 2021-02-27 | Canada | Nova Scotia | 1638 | 65 | 1534 | 39 | 44.682 | -63.7443 | 2021-02-28 05:22:20 | Nova Scotia, Canada | ||
2183354 | 2183354 | 2021-02-26 | Canada | Nova Scotia | 1634 | 65 | 1534 | 35 | 44.682 | -63.7443 | 2021-02-27 05:22:28 | Nova Scotia, Canada | ||
1857776 | 1857776 | 2021-02-25 | Canada | Nova Scotia | 1624 | 65 | 1532 | 27 | 44.682 | -63.7443 | 2021-02-26 05:22:40 | Nova Scotia, Canada | ||
279954 | 279954 | 2021-02-24 | Canada | Nova Scotia | 1616 | 65 | 1530 | 21 | 44.682 | -63.7443 | 2021-02-25 05:24:57 | Nova Scotia, Canada | ||
1936222 | 1936222 | 2021-02-23 | Canada | Nova Scotia | 1613 | 65 | 1528 | 20 | 44.682 | -63.7443 | 2021-02-24 05:29:16 | Nova Scotia, Canada | ||
530477 | 530477 | 2021-02-22 | Canada | Nova Scotia | 1610 | 65 | 1526 | 19 | 44.682 | -63.7443 | 2021-02-23 05:23:41 | Nova Scotia, Canada | ||
181811 | 181811 | 2021-02-21 | Canada | Nova Scotia | 1609 | 65 | 1525 | 19 | 44.682 | -63.7443 | 2021-02-22 05:24:21 | Nova Scotia, Canada | ||
742085 | 742085 | 2021-02-20 | Canada | Nova Scotia | 1608 | 65 | 1525 | 18 | 44.682 | -63.7443 | 2021-02-21 05:24:33 | Nova Scotia, Canada | ||
471183 | 471183 | 2021-02-19 | Canada | Nova Scotia | 1604 | 65 | 1524 | 15 | 44.682 | -63.7443 | 2021-02-20 05:22:51 | Nova Scotia, Canada | ||
1152893 | 1152893 | 2021-02-18 | Canada | Nova Scotia | 1602 | 65 | 1524 | 13 | 44.682 | -63.7443 | 2021-02-19 05:24:16 | Nova Scotia, Canada | ||
3600813 | 3600813 | 2021-02-17 | Canada | Nova Scotia | 1600 | 65 | 1521 | 14 | 44.682 | -63.7443 | 2021-02-18 05:22:58 | Nova Scotia, Canada | ||
3049948 | 3049948 | 2021-02-16 | Canada | Nova Scotia | 1597 | 65 | 1520 | 12 | 44.682 | -63.7443 | 2021-02-17 05:23:10 | Nova Scotia, Canada | ||
1338047 | 1338047 | 2021-02-15 | Canada | Nova Scotia | 1594 | 65 | 1519 | 10 | 44.682 | -63.7443 | 2021-02-16 05:24:38 | Nova Scotia, Canada | ||
2283198 | 2283198 | 2021-02-14 | Canada | Nova Scotia | 1593 | 65 | 1519 | 9 | 44.682 | -63.7443 | 2021-02-15 05:24:49 | Nova Scotia, Canada | ||
2677598 | 2677598 | 2021-02-13 | Canada | Nova Scotia | 1592 | 65 | 1517 | 10 | 44.682 | -63.7443 | 2021-02-14 05:23:43 | Nova Scotia, Canada | ||
3539231 | 3539231 | 2021-02-12 | Canada | Nova Scotia | 1590 | 65 | 1516 | 9 | 44.682 | -63.7443 | 2021-02-13 05:22:12 | Nova Scotia, Canada | ||
2637494 | 2637494 | 2021-02-11 | Canada | Nova Scotia | 1590 | 65 | 1514 | 11 | 44.682 | -63.7443 | 2021-02-12 05:23:29 | Nova Scotia, Canada | ||
3978349 | 3978349 | 2021-02-10 | Canada | Nova Scotia | 1588 | 65 | 1514 | 9 | 44.682 | -63.7443 | 2021-02-11 05:23:55 | Nova Scotia, Canada | ||
1527669 | 1527669 | 2021-02-09 | Canada | Nova Scotia | 1587 | 65 | 1513 | 9 | 44.682 | -63.7443 | 2021-02-10 05:22:41 | Nova Scotia, Canada | ||
613460 | 613460 | 2021-02-08 | Canada | Nova Scotia | 1586 | 65 | 1513 | 8 | 44.682 | -63.7443 | 2021-02-09 05:23:30 | Nova Scotia, Canada | ||
1672229 | 1672229 | 2021-02-07 | Canada | Nova Scotia | 1585 | 65 | 1512 | 8 | 44.682 | -63.7443 | 2021-02-08 05:22:39 | Nova Scotia, Canada | ||
974690 | 974690 | 2021-02-06 | Canada | Nova Scotia | 1584 | 65 | 1512 | 7 | 44.682 | -63.7443 | 2021-02-07 05:23:00 | Nova Scotia, Canada | ||
1587948 | 1587948 | 2021-02-05 | Canada | Nova Scotia | 1584 | 65 | 1511 | 8 | 44.682 | -63.7443 | 2021-02-06 05:23:55 | Nova Scotia, Canada | ||
790155 | 790155 | 2021-02-04 | Canada | Nova Scotia | 1584 | 65 | 1509 | 10 | 44.682 | -63.7443 | 2021-02-05 05:22:38 | Nova Scotia, Canada | ||
340047 | 340047 | 2021-02-03 | Canada | Nova Scotia | 1583 | 65 | 1507 | 11 | 44.682 | -63.7443 | 2021-02-04 05:22:26 | Nova Scotia, Canada | ||
1684273 | 1684273 | 2021-02-02 | Canada | Nova Scotia | 1582 | 65 | 1483 | 34 | 44.682 | -63.7443 | 2021-02-03 05:22:52 | Nova Scotia, Canada | ||
1676243 | 1676243 | 2021-02-01 | Canada | Nova Scotia | 1581 | 65 | 1483 | 33 | 44.682 | -63.7443 | 2021-02-02 05:22:49 | Nova Scotia, Canada | ||
1459531 | 1459531 | 2021-01-31 | Canada | Nova Scotia | 1580 | 65 | 1483 | 32 | 44.682 | -63.7443 | 2021-02-01 05:22:53 | Nova Scotia, Canada | ||
2211439 | 2211439 | 2021-01-30 | Canada | Nova Scotia | 1580 | 65 | 1483 | 32 | 44.682 | -63.7443 | 2021-01-31 05:22:42 | Nova Scotia, Canada | ||
1896926 | 1896926 | 2021-01-29 | Canada | Nova Scotia | 1577 | 65 | 1483 | 29 | 44.682 | -63.7443 | 2021-01-30 05:22:49 | Nova Scotia, Canada | ||
2481742 | 2481742 | 2021-01-28 | Canada | Nova Scotia | 1576 | 65 | 1483 | 28 | 44.682 | -63.7443 | 2021-01-29 05:22:23 | Nova Scotia, Canada | ||
3153377 | 3153377 | 2021-01-27 | Canada | Nova Scotia | 1576 | 65 | 1483 | 28 | 44.682 | -63.7443 | 2021-01-28 05:22:24 | Nova Scotia, Canada | ||
12112 | 12112 | 2021-01-26 | Canada | Nova Scotia | 1572 | 65 | 1483 | 24 | 44.682 | -63.7443 | 2021-01-27 05:23:41 | Nova Scotia, Canada | ||
2567436 | 2567436 | 2021-01-25 | Canada | Nova Scotia | 1571 | 65 | 1483 | 23 | 44.682 | -63.7443 | 2021-01-26 05:22:02 | Nova Scotia, Canada | ||
1759068 | 1759068 | 2021-01-24 | Canada | Nova Scotia | 1571 | 65 | 1483 | 23 | 44.682 | -63.7443 | 2021-01-25 05:22:16 | Nova Scotia, Canada | ||
2426675 | 2426675 | 2021-01-23 | Canada | Nova Scotia | 1570 | 65 | 1483 | 22 | 44.682 | -63.7443 | 2021-01-24 05:22:35 | 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]);