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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2462563 | 2462563 | 2021-09-14 | Canada | Nova Scotia | 6254 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-09-15 03:22:37 | Nova Scotia, Canada | |||
1385402 | 1385402 | 2021-09-13 | Canada | Nova Scotia | 6188 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-09-14 04:21:41 | Nova Scotia, Canada | |||
1884771 | 1884771 | 2021-09-12 | Canada | Nova Scotia | 6178 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-09-13 04:21:15 | Nova Scotia, Canada | |||
3805674 | 3805674 | 2021-09-11 | Canada | Nova Scotia | 6149 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-09-12 04:21:13 | Nova Scotia, Canada | |||
3448614 | 3448614 | 2021-09-10 | Canada | Nova Scotia | 6117 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-09-11 04:21:30 | Nova Scotia, Canada | |||
1262560 | 1262560 | 2021-09-09 | Canada | Nova Scotia | 6107 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-09-10 04:21:20 | Nova Scotia, Canada | |||
2278930 | 2278930 | 2021-09-08 | Canada | Nova Scotia | 6090 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-09-09 04:21:27 | Nova Scotia, Canada | |||
641709 | 641709 | 2021-09-07 | Canada | Nova Scotia | 6076 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-09-08 04:21:31 | Nova Scotia, Canada | |||
3193772 | 3193772 | 2021-09-06 | Canada | Nova Scotia | 6072 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-09-07 04:21:35 | Nova Scotia, Canada | |||
3280640 | 3280640 | 2021-09-05 | Canada | Nova Scotia | 6065 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-09-06 04:21:22 | Nova Scotia, Canada | |||
249054 | 249054 | 2021-09-04 | Canada | Nova Scotia | 6054 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-09-05 04:21:33 | Nova Scotia, Canada | |||
3974335 | 3974335 | 2021-09-03 | Canada | Nova Scotia | 6047 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-09-04 04:21:28 | Nova Scotia, Canada | |||
177797 | 177797 | 2021-09-02 | Canada | Nova Scotia | 6042 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-09-03 04:21:20 | Nova Scotia, Canada | |||
66832 | 66832 | 2021-09-01 | Canada | Nova Scotia | 6038 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-09-02 04:21:15 | Nova Scotia, Canada | |||
2067674 | 2067674 | 2021-08-31 | Canada | Nova Scotia | 6031 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-09-01 04:21:38 | Nova Scotia, Canada | |||
1775128 | 1775128 | 2021-08-30 | Canada | Nova Scotia | 6030 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-08-31 04:21:46 | Nova Scotia, Canada | |||
3891702 | 3891702 | 2021-08-29 | Canada | Nova Scotia | 5999 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-08-30 04:21:23 | Nova Scotia, Canada | |||
2792805 | 2792805 | 2021-08-28 | Canada | Nova Scotia | 5999 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-08-29 04:21:14 | Nova Scotia, Canada | |||
2922964 | 2922964 | 2021-08-27 | Canada | Nova Scotia | 5999 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-08-28 04:21:28 | Nova Scotia, Canada | |||
1595978 | 1595978 | 2021-08-26 | Canada | Nova Scotia | 5990 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-08-27 04:21:37 | Nova Scotia, Canada | |||
32187 | 32187 | 2021-08-25 | Canada | Nova Scotia | 5989 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-08-26 04:21:28 | Nova Scotia, Canada | |||
3105226 | 3105226 | 2021-08-24 | Canada | Nova Scotia | 5982 | 93 | 0 | 44.681999999999995 | -63.7443 | 2021-08-25 04:21:41 | Nova Scotia, Canada | |||
3165397 | 3165397 | 2021-08-23 | Canada | Nova Scotia | 5973 | 93 | 0 | 44.681999999999995 | -63.7443 | 2021-08-24 04:21:19 | Nova Scotia, Canada | |||
2175324 | 2175324 | 2021-08-22 | Canada | Nova Scotia | 5956 | 93 | 0 | 44.681999999999995 | -63.7443 | 2021-08-23 04:21:27 | Nova Scotia, Canada | |||
3555420 | 3555420 | 2021-08-21 | Canada | Nova Scotia | 5956 | 93 | 0 | 44.681999999999995 | -63.7443 | 2021-08-22 04:21:29 | Nova Scotia, Canada | |||
1853762 | 1853762 | 2021-08-20 | Canada | Nova Scotia | 5956 | 93 | 0 | 44.681999999999995 | -63.7443 | 2021-08-21 04:21:38 | Nova Scotia, Canada | |||
511469 | 511469 | 2021-08-19 | Canada | Nova Scotia | 5946 | 93 | 0 | 44.681999999999995 | -63.7443 | 2021-08-20 04:21:33 | Nova Scotia, Canada | |||
2517948 | 2517948 | 2021-08-18 | Canada | Nova Scotia | 5938 | 93 | 0 | 44.681999999999995 | -63.7443 | 2021-08-19 04:21:15 | Nova Scotia, Canada | |||
245040 | 245040 | 2021-08-17 | Canada | Nova Scotia | 5929 | 93 | 0 | 44.681999999999995 | -63.7443 | 2021-08-18 04:21:35 | Nova Scotia, Canada | |||
1604003 | 1604003 | 2021-08-16 | Canada | Nova Scotia | 5928 | 93 | 0 | 44.681999999999995 | -63.7443 | 2021-08-17 04:21:49 | Nova Scotia, Canada | |||
103097 | 103097 | 2021-08-15 | Canada | Nova Scotia | 5919 | 93 | 0 | 44.681999999999995 | -63.7443 | 2021-08-16 04:21:31 | Nova Scotia, Canada | |||
507455 | 507455 | 2021-08-14 | Canada | Nova Scotia | 5919 | 93 | 0 | 44.681999999999995 | -63.7443 | 2021-08-15 04:21:41 | Nova Scotia, Canada | |||
1483327 | 1483327 | 2021-08-13 | Canada | Nova Scotia | 5919 | 93 | 0 | 44.681999999999995 | -63.7443 | 2021-08-14 04:21:25 | Nova Scotia, Canada | |||
2899457 | 2899457 | 2021-08-12 | Canada | Nova Scotia | 5918 | 93 | 0 | 44.681999999999995 | -63.7443 | 2021-08-13 04:21:24 | Nova Scotia, Canada | |||
1342061 | 1342061 | 2021-08-11 | Canada | Nova Scotia | 5911 | 93 | 0 | 44.681999999999995 | -63.7443 | 2021-08-12 04:21:25 | Nova Scotia, Canada | |||
2351208 | 2351208 | 2021-08-10 | Canada | Nova Scotia | 5908 | 93 | 0 | 44.681999999999995 | -63.7443 | 2021-08-11 04:21:58 | Nova Scotia, Canada | |||
649737 | 649737 | 2021-08-09 | Canada | Nova Scotia | 5907 | 93 | 0 | 44.681999999999995 | -63.7443 | 2021-08-10 04:21:27 | Nova Scotia, Canada | |||
589399 | 589399 | 2021-08-08 | Canada | Nova Scotia | 5900 | 93 | 0 | 44.682 | -63.7443 | 2021-08-09 04:21:24 | Nova Scotia, Canada | |||
2203411 | 2203411 | 2021-08-07 | Canada | Nova Scotia | 5900 | 93 | 0 | 44.682 | -63.7443 | 2021-08-08 04:21:33 | Nova Scotia, Canada | |||
1117361 | 1117361 | 2021-08-06 | Canada | Nova Scotia | 5900 | 93 | 0 | 44.682 | -63.7443 | 2021-08-07 04:21:30 | Nova Scotia, Canada | |||
1956298 | 1956298 | 2021-08-05 | Canada | Nova Scotia | 5899 | 93 | 0 | 44.682 | -63.7443 | 2021-08-06 04:21:18 | Nova Scotia, Canada | |||
331677 | 331677 | 2021-08-04 | Canada | Nova Scotia | 5895 | 93 | 5791 | 11 | 44.682 | -63.7443 | 2021-08-05 04:21:51 | Nova Scotia, Canada | ||
3467948 | 3467948 | 2021-08-03 | Canada | Nova Scotia | 5893 | 93 | 5788 | 12 | 44.682 | -63.7443 | 2021-08-04 04:21:25 | Nova Scotia, Canada | ||
3683222 | 3683222 | 2021-08-02 | Canada | Nova Scotia | 5887 | 93 | 5785 | 9 | 44.682 | -63.7443 | 2021-08-03 04:21:39 | Nova Scotia, Canada | ||
3015121 | 3015121 | 2021-08-01 | Canada | Nova Scotia | 5887 | 93 | 5785 | 9 | 44.682 | -63.7443 | 2021-08-02 04:21:36 | Nova Scotia, Canada | ||
3903744 | 3903744 | 2021-07-31 | Canada | Nova Scotia | 5887 | 93 | 5785 | 9 | 44.682 | -63.7443 | 2021-08-01 04:21:50 | Nova Scotia, Canada | ||
3295949 | 3295949 | 2021-07-30 | Canada | Nova Scotia | 5887 | 93 | 5785 | 9 | 44.682 | -63.7443 | 2021-07-31 04:21:35 | Nova Scotia, Canada | ||
3385160 | 3385160 | 2021-07-29 | Canada | Nova Scotia | 5886 | 93 | 5783 | 10 | 44.682 | -63.7443 | 2021-07-30 04:21:34 | Nova Scotia, Canada | ||
408065 | 408065 | 2021-07-28 | Canada | Nova Scotia | 5885 | 93 | 5783 | 9 | 44.682 | -63.7443 | 2021-07-29 04:21:33 | Nova Scotia, Canada | ||
1305926 | 1305926 | 2021-07-27 | Canada | Nova Scotia | 5885 | 93 | 5783 | 9 | 44.682 | -63.7443 | 2021-07-28 04:21:39 | Nova Scotia, Canada | ||
3218069 | 3218069 | 2021-07-26 | Canada | Nova Scotia | 5883 | 93 | 5777 | 13 | 44.682 | -63.7443 | 2021-07-27 04:21:18 | Nova Scotia, Canada | ||
1378278 | 1378278 | 2021-07-25 | Canada | Nova Scotia | 5882 | 93 | 5777 | 12 | 44.682 | -63.7443 | 2021-07-26 04:21:28 | Nova Scotia, Canada | ||
1330018 | 1330018 | 2021-07-24 | Canada | Nova Scotia | 5882 | 93 | 5777 | 12 | 44.682 | -63.7443 | 2021-07-25 04:22:12 | Nova Scotia, Canada | ||
3137322 | 3137322 | 2021-07-23 | Canada | Nova Scotia | 5882 | 93 | 5777 | 12 | 44.682 | -63.7443 | 2021-07-24 00:21:36 | Nova Scotia, Canada | ||
3476082 | 3476082 | 2021-07-22 | Canada | Nova Scotia | 5880 | 93 | 5776 | 11 | 44.682 | -63.7443 | 2021-07-23 04:21:29 | Nova Scotia, Canada | ||
3331301 | 3331301 | 2021-07-21 | Canada | Nova Scotia | 5880 | 92 | 5777 | 11 | 44.682 | -63.7443 | 2021-07-22 04:21:19 | Nova Scotia, Canada | ||
2371282 | 2371282 | 2021-07-20 | Canada | Nova Scotia | 5873 | 92 | 5774 | 7 | 44.682 | -63.7443 | 2021-07-21 04:21:40 | Nova Scotia, Canada | ||
483361 | 483361 | 2021-07-19 | Canada | Nova Scotia | 5873 | 92 | 5774 | 7 | 44.682 | -63.7443 | 2021-07-20 04:21:48 | Nova Scotia, Canada | ||
2673584 | 2673584 | 2021-07-18 | Canada | Nova Scotia | 5873 | 92 | 5773 | 8 | 44.682 | -63.7443 | 2021-07-19 04:21:24 | Nova Scotia, Canada | ||
3705896 | 3705896 | 2021-07-17 | Canada | Nova Scotia | 5870 | 92 | 5773 | 5 | 44.682 | -63.7443 | 2021-07-18 04:22:07 | Nova Scotia, Canada | ||
2947127 | 2947127 | 2021-07-16 | Canada | Nova Scotia | 5870 | 92 | 5770 | 8 | 44.682 | -63.7443 | 2021-07-17 04:22:22 | Nova Scotia, Canada | ||
295783 | 295783 | 2021-07-15 | Canada | Nova Scotia | 5870 | 92 | 5756 | 22 | 44.682 | -63.7443 | 2021-07-16 04:21:22 | Nova Scotia, Canada | ||
3631728 | 3631728 | 2021-07-14 | Canada | Nova Scotia | 5870 | 92 | 5750 | 28 | 44.682 | -63.7443 | 2021-07-15 04:21:48 | Nova Scotia, Canada | ||
578603 | 578603 | 2021-07-13 | Canada | Nova Scotia | 5870 | 92 | 5747 | 31 | 44.682 | -63.7443 | 2021-07-14 04:21:35 | Nova Scotia, Canada | ||
3740852 | 3740852 | 2021-07-12 | Canada | Nova Scotia | 5869 | 92 | 5742 | 37 | 44.682 | -63.7443 | 2021-07-13 04:21:18 | Nova Scotia, Canada | ||
3659365 | 3659365 | 2021-07-11 | Canada | Nova Scotia | 5869 | 92 | 5742 | 36 | 44.682 | -63.7443 | 2021-07-12 04:21:34 | Nova Scotia, Canada | ||
625649 | 625649 | 2021-07-10 | Canada | Nova Scotia | 5866 | 92 | 5735 | 39 | 44.682 | -63.7443 | 2021-07-11 04:21:43 | Nova Scotia, Canada | ||
829368 | 829368 | 2021-07-09 | Canada | Nova Scotia | 5865 | 92 | 5734 | 39 | 44.682 | -63.7443 | 2021-07-10 04:21:25 | Nova Scotia, Canada | ||
778132 | 778132 | 2021-07-08 | Canada | Nova Scotia | 5864 | 92 | 5733 | 39 | 44.682 | -63.7443 | 2021-07-09 04:21:21 | Nova Scotia, Canada | ||
1440354 | 1440354 | 2021-07-07 | Canada | Nova Scotia | 5862 | 92 | 5731 | 39 | 44.682 | -63.7443 | 2021-07-08 04:21:26 | Nova Scotia, Canada | ||
2693459 | 2693459 | 2021-07-06 | Canada | Nova Scotia | 5861 | 92 | 5725 | 44 | 44.682 | -63.7443 | 2021-07-07 04:21:20 | Nova Scotia, Canada | ||
1932208 | 1932208 | 2021-07-05 | Canada | Nova Scotia | 5854 | 92 | 5717 | 45 | 44.682 | -63.7443 | 2021-07-06 04:21:32 | Nova Scotia, Canada | ||
1164939 | 1164939 | 2021-07-04 | Canada | Nova Scotia | 5853 | 92 | 5708 | 53 | 44.682 | -63.7443 | 2021-07-05 04:21:28 | Nova Scotia, Canada | ||
1495373 | 1495373 | 2021-07-03 | Canada | Nova Scotia | 5850 | 92 | 5706 | 52 | 44.682 | -63.7443 | 2021-07-04 04:21:38 | Nova Scotia, Canada | ||
2071688 | 2071688 | 2021-07-02 | Canada | Nova Scotia | 5842 | 92 | 5703 | 47 | 44.682 | -63.7443 | 2021-07-03 04:21:37 | Nova Scotia, Canada | ||
2764704 | 2764704 | 2021-07-01 | Canada | Nova Scotia | 5840 | 92 | 5697 | 51 | 44.682 | -63.7443 | 2021-07-02 04:21:47 | Nova Scotia, Canada | ||
1892912 | 1892912 | 2021-06-30 | Canada | Nova Scotia | 5836 | 92 | 5689 | 55 | 44.682 | -63.7443 | 2021-07-01 04:21:19 | Nova Scotia, Canada | ||
400035 | 400035 | 2021-06-29 | Canada | Nova Scotia | 5832 | 92 | 5689 | 51 | 44.682 | -63.7443 | 2021-06-30 04:21:41 | Nova Scotia, Canada | ||
3125278 | 3125278 | 2021-06-28 | Canada | Nova Scotia | 5831 | 92 | 5682 | 57 | 44.682 | -63.7443 | 2021-06-29 04:21:28 | Nova Scotia, Canada | ||
2589773 | 2589773 | 2021-06-27 | Canada | Nova Scotia | 5828 | 92 | 5678 | 58 | 44.682 | -63.7443 | 2021-06-28 04:21:29 | Nova Scotia, Canada | ||
3958277 | 3958277 | 2021-06-26 | Canada | Nova Scotia | 5825 | 92 | 5671 | 62 | 44.682 | -63.7443 | 2021-06-27 04:21:39 | Nova Scotia, Canada | ||
1712096 | 1712096 | 2021-06-25 | Canada | Nova Scotia | 5814 | 92 | 5662 | 60 | 44.682 | -63.7443 | 2021-06-26 04:21:43 | Nova Scotia, Canada | ||
2295221 | 2295221 | 2021-06-24 | Canada | Nova Scotia | 5798 | 92 | 5647 | 59 | 44.682 | -63.7443 | 2021-06-25 04:21:33 | Nova Scotia, Canada | ||
2422661 | 2422661 | 2021-06-23 | Canada | Nova Scotia | 5793 | 92 | 5641 | 60 | 44.682 | -63.7443 | 2021-06-24 04:21:55 | Nova Scotia, Canada | ||
562738 | 562738 | 2021-06-22 | Canada | Nova Scotia | 5793 | 92 | 5627 | 74 | 44.682 | -63.7443 | 2021-06-23 04:21:46 | Nova Scotia, Canada | ||
3358440 | 3358440 | 2021-06-21 | Canada | Nova Scotia | 5791 | 90 | 5622 | 79 | 44.682 | -63.7443 | 2021-06-22 04:21:34 | Nova Scotia, Canada | ||
2884139 | 2884139 | 2021-06-20 | Canada | Nova Scotia | 5791 | 90 | 5618 | 83 | 44.682 | -63.7443 | 2021-06-21 04:21:41 | Nova Scotia, Canada | ||
107222 | 107222 | 2021-06-19 | Canada | Nova Scotia | 5789 | 90 | 5611 | 88 | 44.682 | -63.7443 | 2021-06-20 04:21:48 | Nova Scotia, Canada | ||
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 |
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]);