johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
388 rows where country_or_region = "Canada" and latitude = "44.681999999999995" sorted by last_update
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 1
- Nova Scotia 288
country_or_region 1
- Canada · 288 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update ▼ | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2748154 | 2748154 | 2020-07-15 | Canada | Nova Scotia | 1067 | 63 | 1002 | 2 | 44.681999999999995 | -63.7443 | 2020-07-16 04:44:59 | Nova Scotia, Canada | ||
367486 | 367486 | 2020-07-16 | Canada | Nova Scotia | 1067 | 63 | 1002 | 2 | 44.681999999999995 | -63.7443 | 2020-07-17 04:34:50 | Nova Scotia, Canada | ||
2708675 | 2708675 | 2020-07-17 | Canada | Nova Scotia | 1067 | 63 | 1002 | 2 | 44.681999999999995 | -63.7443 | 2020-07-18 04:34:45 | Nova Scotia, Canada | ||
3205374 | 3205374 | 2020-07-18 | Canada | Nova Scotia | 1067 | 63 | 1002 | 2 | 44.681999999999995 | -63.7443 | 2020-07-19 04:34:58 | Nova Scotia, Canada | ||
121985 | 121985 | 2020-07-19 | Canada | Nova Scotia | 1067 | 63 | 1002 | 2 | 44.681999999999995 | -63.7443 | 2020-07-20 05:34:40 | Nova Scotia, Canada | ||
327080 | 327080 | 2020-07-20 | Canada | Nova Scotia | 1067 | 63 | 1003 | 1 | 44.681999999999995 | -63.7443 | 2020-07-21 04:38:46 | Nova Scotia, Canada | ||
1707589 | 1707589 | 2020-07-21 | Canada | Nova Scotia | 1067 | 63 | 1003 | 1 | 44.681999999999995 | -63.7443 | 2020-07-22 04:34:42 | Nova Scotia, Canada | ||
844850 | 844850 | 2020-07-22 | Canada | Nova Scotia | 1067 | 63 | 1003 | 1 | 44.681999999999995 | -63.7443 | 2020-07-23 05:15:04 | Nova Scotia, Canada | ||
62044 | 62044 | 2020-07-23 | Canada | Nova Scotia | 1067 | 63 | 1003 | 1 | 44.681999999999995 | -63.7443 | 2020-07-24 05:30:40 | Nova Scotia, Canada | ||
2563830 | 2563830 | 2020-07-24 | Canada | Nova Scotia | 1067 | 63 | 1003 | 1 | 44.681999999999995 | -63.7443 | 2020-07-25 04:47:39 | Nova Scotia, Canada | ||
1502860 | 1502860 | 2020-07-25 | Canada | Nova Scotia | 1067 | 63 | 1003 | 1 | 44.681999999999995 | -63.7443 | 2020-07-26 04:35:00 | Nova Scotia, Canada | ||
442616 | 442616 | 2020-07-26 | Canada | Nova Scotia | 1067 | 63 | 1004 | 0 | 44.681999999999995 | -63.7443 | 2020-07-27 04:35:02 | Nova Scotia, Canada | ||
177303 | 177303 | 2020-07-27 | Canada | Nova Scotia | 1067 | 63 | 1004 | 0 | 44.681999999999995 | -63.7443 | 2020-07-28 04:58:43 | Nova Scotia, Canada | ||
3185252 | 3185252 | 2020-07-28 | Canada | Nova Scotia | 1067 | 63 | 1004 | 0 | 44.681999999999995 | -63.7443 | 2020-07-29 04:35:11 | Nova Scotia, Canada | ||
2958636 | 2958636 | 2020-07-29 | Canada | Nova Scotia | 1067 | 64 | 1003 | 0 | 44.681999999999995 | -63.7443 | 2020-07-30 04:35:05 | Nova Scotia, Canada | ||
1928468 | 1928468 | 2020-07-30 | Canada | Nova Scotia | 1067 | 64 | 1003 | 0 | 44.681999999999995 | -63.7443 | 2020-07-31 04:35:18 | Nova Scotia, Canada | ||
3264761 | 3264761 | 2020-07-31 | Canada | Nova Scotia | 1069 | 64 | 1003 | 2 | 44.681999999999995 | -63.7443 | 2020-08-01 04:36:27 | Nova Scotia, Canada | ||
753596 | 753596 | 2020-08-01 | Canada | Nova Scotia | 1069 | 64 | 1003 | 2 | 44.681999999999995 | -63.7443 | 2020-08-02 04:34:47 | Nova Scotia, Canada | ||
2808028 | 2808028 | 2020-08-02 | Canada | Nova Scotia | 1071 | 64 | 1003 | 4 | 44.681999999999995 | -63.7443 | 2020-08-03 04:34:35 | Nova Scotia, Canada | ||
2740276 | 2740276 | 2020-08-03 | Canada | Nova Scotia | 1071 | 64 | 1005 | 2 | 44.681999999999995 | -63.7443 | 2020-08-04 04:41:59 | Nova Scotia, Canada | ||
98393 | 98393 | 2020-08-04 | Canada | Nova Scotia | 1071 | 64 | 1005 | 2 | 44.681999999999995 | -63.7443 | 2020-08-05 04:34:43 | Nova Scotia, Canada | ||
3793157 | 3793157 | 2020-08-05 | Canada | Nova Scotia | 1071 | 64 | 1005 | 2 | 44.681999999999995 | -63.7443 | 2020-08-06 04:35:02 | Nova Scotia, Canada | ||
3612327 | 3612327 | 2020-08-06 | Canada | Nova Scotia | 1071 | 64 | 1005 | 2 | 44.681999999999995 | -63.7443 | 2020-08-07 04:35:11 | Nova Scotia, Canada | ||
458642 | 458642 | 2020-08-07 | Canada | Nova Scotia | 1071 | 64 | 1005 | 2 | 44.681999999999995 | -63.7443 | 2020-08-08 04:34:53 | Nova Scotia, Canada | ||
371458 | 371458 | 2020-08-08 | Canada | Nova Scotia | 1071 | 64 | 1005 | 2 | 44.681999999999995 | -63.7443 | 2020-08-09 04:34:54 | Nova Scotia, Canada | ||
3923290 | 3923290 | 2020-08-09 | Canada | Nova Scotia | 1071 | 64 | 1006 | 1 | 44.681999999999995 | -63.7443 | 2020-08-10 04:34:55 | Nova Scotia, Canada | ||
1920481 | 1920481 | 2020-08-10 | Canada | Nova Scotia | 1071 | 64 | 1007 | 0 | 44.681999999999995 | -63.7443 | 2020-08-11 04:35:08 | 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 | |||
2351208 | 2351208 | 2021-08-10 | Canada | Nova Scotia | 5908 | 93 | 0 | 44.681999999999995 | -63.7443 | 2021-08-11 04:21:58 | 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 | |||
2899457 | 2899457 | 2021-08-12 | Canada | Nova Scotia | 5918 | 93 | 0 | 44.681999999999995 | -63.7443 | 2021-08-13 04:21:24 | 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 | |||
507455 | 507455 | 2021-08-14 | Canada | Nova Scotia | 5919 | 93 | 0 | 44.681999999999995 | -63.7443 | 2021-08-15 04:21:41 | 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 | |||
1604003 | 1604003 | 2021-08-16 | Canada | Nova Scotia | 5928 | 93 | 0 | 44.681999999999995 | -63.7443 | 2021-08-17 04:21:49 | 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 | |||
2517948 | 2517948 | 2021-08-18 | Canada | Nova Scotia | 5938 | 93 | 0 | 44.681999999999995 | -63.7443 | 2021-08-19 04:21:15 | 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 | |||
1853762 | 1853762 | 2021-08-20 | Canada | Nova Scotia | 5956 | 93 | 0 | 44.681999999999995 | -63.7443 | 2021-08-21 04:21:38 | 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 | |||
2175324 | 2175324 | 2021-08-22 | Canada | Nova Scotia | 5956 | 93 | 0 | 44.681999999999995 | -63.7443 | 2021-08-23 04:21:27 | 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 | |||
3105226 | 3105226 | 2021-08-24 | Canada | Nova Scotia | 5982 | 93 | 0 | 44.681999999999995 | -63.7443 | 2021-08-25 04:21:41 | 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 | |||
1595978 | 1595978 | 2021-08-26 | Canada | Nova Scotia | 5990 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-08-27 04:21:37 | 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 | |||
2792805 | 2792805 | 2021-08-28 | Canada | Nova Scotia | 5999 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-08-29 04:21:14 | 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 | |||
1775128 | 1775128 | 2021-08-30 | Canada | Nova Scotia | 6030 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-08-31 04:21:46 | 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 | |||
66832 | 66832 | 2021-09-01 | Canada | Nova Scotia | 6038 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-09-02 04:21:15 | 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 | |||
3974335 | 3974335 | 2021-09-03 | Canada | Nova Scotia | 6047 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-09-04 04:21:28 | 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 | |||
3280640 | 3280640 | 2021-09-05 | Canada | Nova Scotia | 6065 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-09-06 04:21:22 | 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 | |||
641709 | 641709 | 2021-09-07 | Canada | Nova Scotia | 6076 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-09-08 04:21:31 | 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 | |||
1262560 | 1262560 | 2021-09-09 | Canada | Nova Scotia | 6107 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-09-10 04:21:20 | 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 | |||
3805674 | 3805674 | 2021-09-11 | Canada | Nova Scotia | 6149 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-09-12 04:21:13 | 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 | |||
1385402 | 1385402 | 2021-09-13 | Canada | Nova Scotia | 6188 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-09-14 04:21:41 | Nova Scotia, Canada | |||
2462563 | 2462563 | 2021-09-14 | Canada | Nova Scotia | 6254 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-09-15 03:22:37 | Nova Scotia, Canada | |||
1374264 | 1374264 | 2021-09-15 | Canada | Nova Scotia | 6260 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-09-16 04:22:19 | Nova Scotia, Canada | |||
2808519 | 2808519 | 2021-09-16 | Canada | Nova Scotia | 6294 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-09-17 04:21:46 | Nova Scotia, Canada | |||
2617811 | 2617811 | 2021-09-17 | Canada | Nova Scotia | 6312 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-09-18 04:21:24 | Nova Scotia, Canada | |||
16126 | 16126 | 2021-09-18 | Canada | Nova Scotia | 6312 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-09-19 04:21:34 | Nova Scotia, Canada | |||
1814546 | 1814546 | 2021-09-19 | Canada | Nova Scotia | 6312 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-09-20 04:21:22 | Nova Scotia, Canada | |||
809347 | 809347 | 2021-09-20 | Canada | Nova Scotia | 6367 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-09-21 04:21:26 | Nova Scotia, Canada | |||
3757244 | 3757244 | 2021-09-21 | Canada | Nova Scotia | 6392 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-09-22 04:21:45 | Nova Scotia, Canada | |||
3011106 | 3011106 | 2021-09-22 | Canada | Nova Scotia | 6411 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-09-23 04:21:43 | Nova Scotia, Canada | |||
601445 | 601445 | 2021-09-23 | Canada | Nova Scotia | 6452 | 95 | 0 | 44.681999999999995 | -63.7443 | 2021-09-24 04:21:44 | Nova Scotia, Canada | |||
1920974 | 1920974 | 2021-09-24 | Canada | Nova Scotia | 6486 | 95 | 0 | 44.681999999999995 | -63.7443 | 2021-09-25 04:21:31 | Nova Scotia, Canada | |||
1724254 | 1724254 | 2021-09-25 | Canada | Nova Scotia | 6486 | 95 | 0 | 44.681999999999995 | -63.7443 | 2021-09-26 04:21:29 | Nova Scotia, Canada | |||
2075702 | 2075702 | 2021-09-26 | Canada | Nova Scotia | 6486 | 95 | 0 | 44.681999999999995 | -63.7443 | 2021-09-27 04:21:16 | Nova Scotia, Canada | |||
1235401 | 1235401 | 2021-09-27 | Canada | Nova Scotia | 6569 | 96 | 0 | 44.681999999999995 | -63.7443 | 2021-09-28 04:21:28 | Nova Scotia, Canada | |||
1334032 | 1334032 | 2021-09-28 | Canada | Nova Scotia | 6598 | 97 | 0 | 44.681999999999995 | -63.7443 | 2021-09-29 04:21:45 | Nova Scotia, Canada | |||
706190 | 706190 | 2021-09-29 | Canada | Nova Scotia | 6638 | 97 | 0 | 44.681999999999995 | -63.7443 | 2021-09-30 04:21:20 | Nova Scotia, Canada | |||
2772734 | 2772734 | 2021-09-30 | Canada | Nova Scotia | 6638 | 97 | 0 | 44.681999999999995 | -63.7443 | 2021-10-01 04:21:35 | Nova Scotia, Canada | |||
2131777 | 2131777 | 2021-10-01 | Canada | Nova Scotia | 6715 | 97 | 0 | 44.681999999999995 | -63.7443 | 2021-10-02 04:21:25 | Nova Scotia, Canada | |||
3927797 | 3927797 | 2021-10-02 | Canada | Nova Scotia | 6715 | 97 | 0 | 44.681999999999995 | -63.7443 | 2021-10-03 04:21:24 | Nova Scotia, Canada | |||
1274044 | 1274044 | 2021-10-03 | Canada | Nova Scotia | 6715 | 97 | 0 | 44.681999999999995 | -63.7443 | 2021-10-04 04:21:31 | Nova Scotia, Canada | |||
986734 | 986734 | 2021-10-04 | Canada | Nova Scotia | 6800 | 97 | 0 | 44.681999999999995 | -63.7443 | 2021-10-05 04:21:27 | Nova Scotia, Canada | |||
3832241 | 3832241 | 2021-10-05 | Canada | Nova Scotia | 6839 | 97 | 0 | 44.681999999999995 | -63.7443 | 2021-10-06 04:21:33 | Nova Scotia, Canada | |||
2458547 | 2458547 | 2021-10-06 | Canada | Nova Scotia | 6864 | 98 | 0 | 44.681999999999995 | -63.7443 | 2021-10-07 04:21:36 | Nova Scotia, Canada | |||
467167 | 467167 | 2021-10-07 | Canada | Nova Scotia | 6893 | 98 | 0 | 44.681999999999995 | -63.7443 | 2021-10-08 04:21:25 | Nova Scotia, Canada | |||
2959129 | 2959129 | 2021-10-08 | Canada | Nova Scotia | 6918 | 98 | 0 | 44.681999999999995 | -63.7443 | 2021-10-09 04:21:34 | Nova Scotia, Canada | |||
2875963 | 2875963 | 2021-10-09 | Canada | Nova Scotia | 6945 | 98 | 0 | 44.681999999999995 | -63.7443 | 2021-10-10 04:21:38 | Nova Scotia, Canada | |||
423106 | 423106 | 2021-10-10 | Canada | Nova Scotia | 6961 | 98 | 0 | 44.681999999999995 | -63.7443 | 2021-10-11 04:21:31 | Nova Scotia, Canada | |||
3007090 | 3007090 | 2021-10-11 | Canada | Nova Scotia | 6977 | 98 | 0 | 44.681999999999995 | -63.7443 | 2021-10-12 04:21:09 | Nova Scotia, Canada | |||
1491357 | 1491357 | 2021-10-12 | Canada | Nova Scotia | 7011 | 98 | 0 | 44.681999999999995 | -63.7443 | 2021-10-13 04:20:51 | Nova Scotia, Canada | |||
633679 | 633679 | 2021-10-13 | Canada | Nova Scotia | 7033 | 98 | 0 | 44.681999999999995 | -63.7443 | 2021-10-14 04:21:29 | Nova Scotia, Canada | |||
491391 | 491391 | 2021-10-14 | Canada | Nova Scotia | 7059 | 98 | 0 | 44.681999999999995 | -63.7443 | 2021-10-15 04:21:26 | Nova Scotia, Canada | |||
2943111 | 2943111 | 2021-10-15 | Canada | Nova Scotia | 7077 | 98 | 0 | 44.681999999999995 | -63.7443 | 2021-10-16 04:21:15 | Nova Scotia, Canada | |||
934556 | 934556 | 2021-10-16 | Canada | Nova Scotia | 7114 | 98 | 0 | 44.681999999999995 | -63.7443 | 2021-10-17 04:21:29 | Nova Scotia, Canada | |||
1908967 | 1908967 | 2021-10-17 | Canada | Nova Scotia | 7133 | 98 | 0 | 44.681999999999995 | -63.7443 | 2021-10-18 04:21:10 | Nova Scotia, Canada | |||
2043606 | 2043606 | 2021-10-18 | Canada | Nova Scotia | 7155 | 98 | 0 | 44.681999999999995 | -63.7443 | 2021-10-19 04:20:54 | Nova Scotia, Canada | |||
597429 | 597429 | 2021-10-19 | Canada | Nova Scotia | 7161 | 98 | 0 | 44.681999999999995 | -63.7443 | 2021-10-20 04:21:00 | Nova Scotia, Canada | |||
443110 | 443110 | 2021-10-20 | Canada | Nova Scotia | 7166 | 98 | 0 | 44.681999999999995 | -63.7443 | 2021-10-21 04:21:18 | 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]);