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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2701284 | 2701284 | 2020-11-20 | Canada | Nova Scotia | 1160 | 65 | 1067 | 28 | 44.682 | -63.7443 | 2020-11-21 05:25:51 | Nova Scotia, Canada | ||
821344 | 821344 | 2020-11-19 | Canada | Nova Scotia | 1155 | 65 | 1067 | 23 | 44.682 | -63.7443 | 2020-11-20 05:26:28 | Nova Scotia, Canada | ||
122478 | 122478 | 2020-11-18 | Canada | Nova Scotia | 1154 | 65 | 1065 | 24 | 44.682 | -63.7443 | 2020-11-19 05:25:23 | Nova Scotia, Canada | ||
3338366 | 3338366 | 2020-11-17 | Canada | Nova Scotia | 1151 | 65 | 1062 | 24 | 44.682 | -63.7443 | 2020-11-18 05:40:31 | Nova Scotia, Canada | ||
3169411 | 3169411 | 2020-11-16 | Canada | Nova Scotia | 1146 | 65 | 1058 | 23 | 44.682 | -63.7443 | 2020-11-17 05:25:54 | Nova Scotia, Canada | ||
2879979 | 2879979 | 2020-11-15 | Canada | Nova Scotia | 1144 | 65 | 1058 | 21 | 44.682 | -63.7443 | 2020-11-16 05:25:57 | Nova Scotia, Canada | ||
2914957 | 2914957 | 2020-11-14 | Canada | Nova Scotia | 1142 | 65 | 1056 | 21 | 44.682 | -63.7443 | 2020-11-15 05:26:53 | Nova Scotia, Canada | ||
2784779 | 2784779 | 2020-11-13 | Canada | Nova Scotia | 1136 | 65 | 1052 | 19 | 44.682 | -63.7443 | 2020-11-14 05:25:37 | Nova Scotia, Canada | ||
864544 | 864544 | 2020-11-12 | Canada | Nova Scotia | 1134 | 65 | 1050 | 19 | 44.682 | -63.7443 | 2020-11-13 05:25:30 | Nova Scotia, Canada | ||
3440589 | 3440589 | 2020-11-11 | Canada | Nova Scotia | 1134 | 65 | 1049 | 20 | 44.682 | -63.7443 | 2020-11-12 05:25:55 | Nova Scotia, Canada | ||
271929 | 271929 | 2020-11-10 | Canada | Nova Scotia | 1132 | 65 | 1049 | 18 | 44.682 | -63.7443 | 2020-11-11 05:25:30 | Nova Scotia, Canada | ||
1988406 | 1988406 | 2020-11-09 | Canada | Nova Scotia | 1129 | 65 | 1048 | 16 | 44.682 | -63.7443 | 2020-11-10 05:40:07 | Nova Scotia, Canada | ||
1728258 | 1728258 | 2020-11-08 | Canada | Nova Scotia | 1128 | 65 | 1043 | 20 | 44.682 | -63.7443 | 2020-11-09 05:25:45 | Nova Scotia, Canada | ||
1543718 | 1543718 | 2020-11-07 | Canada | Nova Scotia | 1125 | 65 | 1040 | 20 | 44.682 | -63.7443 | 2020-11-08 05:24:56 | Nova Scotia, Canada | ||
375956 | 375956 | 2020-11-06 | Canada | Nova Scotia | 1121 | 65 | 1040 | 16 | 44.682 | -63.7443 | 2020-11-07 05:24:52 | Nova Scotia, Canada | ||
891894 | 891894 | 2020-11-05 | Canada | Nova Scotia | 1119 | 65 | 1036 | 18 | 44.682 | -63.7443 | 2020-11-06 05:24:55 | Nova Scotia, Canada | ||
2918956 | 2918956 | 2020-11-04 | Canada | Nova Scotia | 1118 | 65 | 1034 | 19 | 44.682 | -63.7443 | 2020-11-05 06:05:03 | Nova Scotia, Canada | ||
2497793 | 2497793 | 2020-11-03 | Canada | Nova Scotia | 1114 | 65 | 1033 | 16 | 44.682 | -63.7443 | 2020-11-04 05:25:09 | Nova Scotia, Canada | ||
3303968 | 3303968 | 2020-11-02 | Canada | Nova Scotia | 1113 | 65 | 1033 | 15 | 44.682 | -63.7443 | 2020-11-03 06:00:16 | Nova Scotia, Canada | ||
3409217 | 3409217 | 2020-11-01 | Canada | Nova Scotia | 1111 | 65 | 1033 | 13 | 44.682 | -63.7443 | 2020-11-02 05:25:04 | Nova Scotia, Canada | ||
2079706 | 2079706 | 2020-10-31 | Canada | Nova Scotia | 1109 | 65 | 1033 | 11 | 44.682 | -63.7443 | 2020-11-01 04:36:19 | Nova Scotia, Canada | ||
2243159 | 2243159 | 2020-10-30 | Canada | Nova Scotia | 1104 | 65 | 1033 | 6 | 44.682 | -63.7443 | 2020-10-31 04:24:44 | Nova Scotia, Canada | ||
210014 | 210014 | 2020-10-29 | Canada | Nova Scotia | 1102 | 65 | 1033 | 4 | 44.682 | -63.7443 | 2020-10-30 04:24:49 | Nova Scotia, Canada | ||
754076 | 754076 | 2020-10-28 | Canada | Nova Scotia | 1102 | 65 | 1032 | 5 | 44.682 | -63.7443 | 2020-10-29 04:24:49 | Nova Scotia, Canada | ||
1452361 | 1452361 | 2020-10-27 | Canada | Nova Scotia | 1102 | 65 | 1031 | 6 | 44.682 | -63.7443 | 2020-10-28 04:24:39 | Nova Scotia, Canada | ||
3480085 | 3480085 | 2020-10-26 | Canada | Nova Scotia | 1101 | 65 | 1031 | 5 | 44.682 | -63.7443 | 2020-10-27 04:24:45 | Nova Scotia, Canada | ||
8106 | 8106 | 2020-10-25 | Canada | Nova Scotia | 1100 | 65 | 1029 | 6 | 44.682 | -63.7443 | 2020-10-26 04:25:02 | Nova Scotia, Canada | ||
3651343 | 3651343 | 2020-10-24 | Canada | Nova Scotia | 1100 | 65 | 1029 | 6 | 44.682 | -63.7443 | 2020-10-25 04:24:36 | Nova Scotia, Canada | ||
1053598 | 1053598 | 2020-10-23 | Canada | Nova Scotia | 1097 | 65 | 1028 | 4 | 44.682 | -63.7443 | 2020-10-24 04:24:46 | Nova Scotia, Canada | ||
1177268 | 1177268 | 2020-10-22 | Canada | Nova Scotia | 1097 | 65 | 1028 | 4 | 44.682 | -63.7443 | 2020-10-23 04:24:46 | Nova Scotia, Canada | ||
2191373 | 2191373 | 2020-10-21 | Canada | Nova Scotia | 1097 | 65 | 1027 | 5 | 44.682 | -63.7443 | 2020-10-22 04:24:27 | Nova Scotia, Canada | ||
3990384 | 3990384 | 2020-10-20 | Canada | Nova Scotia | 1097 | 65 | 1027 | 5 | 44.682 | -63.7443 | 2020-10-21 04:24:14 | Nova Scotia, Canada | ||
1794404 | 1794404 | 2020-10-19 | Canada | Nova Scotia | 1097 | 65 | 1026 | 6 | 44.682 | -63.7443 | 2020-10-20 04:24:22 | Nova Scotia, Canada | ||
762088 | 762088 | 2020-10-18 | Canada | Nova Scotia | 1097 | 65 | 1026 | 6 | 44.682 | -63.7443 | 2020-10-19 04:24:16 | Nova Scotia, Canada | ||
1026126 | 1026126 | 2020-10-17 | Canada | Nova Scotia | 1095 | 65 | 1024 | 4 | 44.682 | -63.7443 | 2020-10-18 04:24:25 | Nova Scotia, Canada | ||
2856621 | 2856621 | 2020-10-16 | Canada | Nova Scotia | 1093 | 65 | 1024 | 4 | 44.682 | -63.7443 | 2020-10-17 04:24:12 | Nova Scotia, Canada | ||
786151 | 786151 | 2020-10-15 | Canada | Nova Scotia | 1092 | 65 | 1024 | 3 | 44.682 | -63.7443 | 2020-10-16 04:24:01 | Nova Scotia, Canada | ||
78862 | 78862 | 2020-10-14 | Canada | Nova Scotia | 1092 | 65 | 1023 | 4 | 44.682 | -63.7443 | 2020-10-15 04:24:28 | Nova Scotia, Canada | ||
3781677 | 3781677 | 2020-10-13 | Canada | Nova Scotia | 1092 | 65 | 1023 | 4 | 44.682 | -63.7443 | 2020-10-14 04:24:05 | Nova Scotia, Canada | ||
2291217 | 2291217 | 2020-10-12 | Canada | Nova Scotia | 1092 | 65 | 1023 | 4 | 44.682 | -63.7443 | 2020-10-13 04:24:02 | Nova Scotia, Canada | ||
3785670 | 3785670 | 2020-10-11 | Canada | Nova Scotia | 1092 | 65 | 1023 | 4 | 44.682 | -63.7443 | 2020-10-12 04:23:45 | Nova Scotia, Canada | ||
2601808 | 2601808 | 2020-10-10 | Canada | Nova Scotia | 1092 | 65 | 1022 | 5 | 44.682 | -63.7443 | 2020-10-11 04:23:46 | Nova Scotia, Canada | ||
817341 | 817341 | 2020-10-09 | Canada | Nova Scotia | 1089 | 65 | 1021 | 3 | 44.682 | -63.7443 | 2020-10-10 04:23:57 | Nova Scotia, Canada | ||
2689456 | 2689456 | 2020-10-08 | Canada | Nova Scotia | 1089 | 65 | 1021 | 3 | 44.682 | -63.7443 | 2020-10-09 04:23:59 | Nova Scotia, Canada | ||
1041598 | 1041598 | 2020-10-07 | Canada | Nova Scotia | 1089 | 65 | 1021 | 3 | 44.682 | -63.7443 | 2020-10-08 04:23:56 | Nova Scotia, Canada | ||
3117259 | 3117259 | 2020-10-06 | Canada | Nova Scotia | 1089 | 65 | 1021 | 3 | 44.682 | -63.7443 | 2020-10-07 04:23:40 | Nova Scotia, Canada | ||
3801671 | 3801671 | 2020-10-05 | Canada | Nova Scotia | 1089 | 65 | 1021 | 3 | 44.682 | -63.7443 | 2020-10-06 04:23:33 | Nova Scotia, Canada | ||
1822561 | 1822561 | 2020-10-04 | Canada | Nova Scotia | 1089 | 65 | 1021 | 3 | 44.682 | -63.7443 | 2020-10-05 04:23:33 | Nova Scotia, Canada | ||
2513945 | 2513945 | 2020-10-03 | Canada | Nova Scotia | 1089 | 65 | 1021 | 3 | 44.682 | -63.7443 | 2020-10-04 04:23:44 | Nova Scotia, Canada | ||
3389163 | 3389163 | 2020-10-02 | Canada | Nova Scotia | 1089 | 65 | 1021 | 3 | 44.682 | -63.7443 | 2020-10-03 04:23:40 | Nova Scotia, Canada | ||
2379404 | 2379404 | 2020-10-01 | Canada | Nova Scotia | 1088 | 65 | 1021 | 2 | 44.682 | -63.7443 | 2020-10-02 04:23:51 | Nova Scotia, Canada | ||
1045590 | 1045590 | 2020-09-30 | Canada | Nova Scotia | 1088 | 65 | 1021 | 2 | 44.682 | -63.7443 | 2020-10-01 04:23:42 | Nova Scotia, Canada | ||
966671 | 966671 | 2020-09-29 | Canada | Nova Scotia | 1087 | 65 | 1021 | 1 | 44.682 | -63.7443 | 2020-09-30 04:23:33 | Nova Scotia, Canada | ||
1515168 | 1515168 | 2020-09-28 | Canada | Nova Scotia | 1087 | 65 | 1021 | 1 | 44.682 | -63.7443 | 2020-09-29 04:23:42 | Nova Scotia, Canada | ||
2581756 | 2581756 | 2020-09-27 | Canada | Nova Scotia | 1087 | 65 | 1021 | 1 | 44.682 | -63.7443 | 2020-09-28 04:23:00 | Nova Scotia, Canada | ||
2613808 | 2613808 | 2020-09-26 | Canada | Nova Scotia | 1087 | 65 | 1021 | 1 | 44.682 | -63.7443 | 2020-09-27 04:23:00 | Nova Scotia, Canada | ||
2812523 | 2812523 | 2020-09-25 | Canada | Nova Scotia | 1087 | 65 | 1021 | 1 | 44.682 | -63.7443 | 2020-09-26 04:23:00 | Nova Scotia, Canada | ||
2605800 | 2605800 | 2020-09-24 | Canada | Nova Scotia | 1087 | 65 | 1021 | 1 | 44.682 | -63.7443 | 2020-09-25 04:23:00 | Nova Scotia, Canada | ||
2653543 | 2653543 | 2020-09-23 | Canada | Nova Scotia | 1087 | 65 | 1021 | 1 | 44.682 | -63.7443 | 2020-09-24 04:23:00 | Nova Scotia, Canada | ||
3315992 | 3315992 | 2020-09-22 | Canada | Nova Scotia | 1087 | 65 | 1021 | 1 | 44.682 | -63.7443 | 2020-09-23 04:23:00 | Nova Scotia, Canada | ||
2836591 | 2836591 | 2020-09-21 | Canada | Nova Scotia | 1086 | 65 | 1021 | 0 | 44.682 | -63.7443 | 2020-09-22 04:23:00 | Nova Scotia, Canada | ||
3093196 | 3093196 | 2020-09-20 | Canada | Nova Scotia | 1086 | 65 | 1021 | 0 | 44.682 | -63.7443 | 2020-09-21 04:23:00 | Nova Scotia, Canada | ||
2454546 | 2454546 | 2020-09-19 | Canada | Nova Scotia | 1086 | 65 | 1021 | 0 | 44.682 | -63.7443 | 2020-09-20 04:22:00 | Nova Scotia, Canada | ||
2848615 | 2848615 | 2020-09-18 | Canada | Nova Scotia | 1086 | 65 | 1021 | 0 | 44.682 | -63.7443 | 2020-09-19 04:22:00 | Nova Scotia, Canada | ||
1121364 | 1121364 | 2020-09-17 | Canada | Nova Scotia | 1086 | 65 | 1020 | 1 | 44.682 | -63.7443 | 2020-09-18 05:05:00 | Nova Scotia, Canada | ||
666053 | 666053 | 2020-09-16 | Canada | Nova Scotia | 1086 | 65 | 1020 | 1 | 44.682 | -63.7443 | 2020-09-17 04:22:00 | Nova Scotia, Canada | ||
2728778 | 2728778 | 2020-09-15 | Canada | Nova Scotia | 1086 | 65 | 1020 | 1 | 44.682 | -63.7443 | 2020-09-16 04:22:53 | Nova Scotia, Canada | ||
344050 | 344050 | 2020-09-14 | Canada | Nova Scotia | 1086 | 65 | 1020 | 1 | 44.682 | -63.7443 | 2020-09-15 03:22:50 | Nova Scotia, Canada | ||
2868489 | 2868489 | 2020-09-13 | Canada | Nova Scotia | 1086 | 65 | 1020 | 1 | 44.682 | -63.7443 | 2020-09-14 04:26:00 | Nova Scotia, Canada | ||
546528 | 546528 | 2020-09-12 | Canada | Nova Scotia | 1086 | 65 | 1020 | 1 | 44.682 | -63.7443 | 2020-09-13 04:30:52 | Nova Scotia, Canada | ||
1444357 | 1444357 | 2020-09-11 | Canada | Nova Scotia | 1086 | 65 | 1019 | 2 | 44.682 | -63.7443 | 2020-09-12 04:25:05 | Nova Scotia, Canada | ||
1172958 | 1172958 | 2020-09-10 | Canada | Nova Scotia | 1086 | 65 | 1019 | 2 | 44.682 | -63.7443 | 2020-09-11 04:46:23 | Nova Scotia, Canada | ||
2171323 | 2171323 | 2020-09-09 | Canada | Nova Scotia | 1086 | 65 | 1018 | 3 | 44.682 | -63.7443 | 2020-09-10 04:29:01 | Nova Scotia, Canada | ||
1243532 | 1243532 | 2020-09-08 | Canada | Nova Scotia | 1086 | 65 | 1018 | 3 | 44.682 | -63.7443 | 2020-09-09 04:28:48 | Nova Scotia, Canada | ||
427111 | 427111 | 2020-09-07 | Canada | Nova Scotia | 1086 | 65 | 1017 | 4 | 44.682 | -63.7443 | 2020-09-08 04:28:25 | Nova Scotia, Canada | ||
3161396 | 3161396 | 2020-09-06 | Canada | Nova Scotia | 1085 | 65 | 1017 | 3 | 44.682 | -63.7443 | 2020-09-07 04:28:30 | Nova Scotia, Canada | ||
813351 | 813351 | 2020-09-05 | Canada | Nova Scotia | 1085 | 65 | 1015 | 5 | 44.682 | -63.7443 | 2020-09-06 04:28:33 | Nova Scotia, Canada | ||
2661551 | 2661551 | 2020-09-04 | Canada | Nova Scotia | 1085 | 65 | 1015 | 5 | 44.682 | -63.7443 | 2020-09-05 04:28:19 | Nova Scotia, Canada | ||
1354091 | 1354091 | 2020-09-03 | Canada | Nova Scotia | 1085 | 65 | 1014 | 6 | 44.682 | -63.7443 | 2020-09-04 04:28:26 | Nova Scotia, Canada | ||
1105328 | 1105328 | 2020-09-02 | Canada | Nova Scotia | 1085 | 65 | 1014 | 6 | 44.682 | -63.7443 | 2020-09-03 04:28:22 | Nova Scotia, Canada | ||
2059657 | 2059657 | 2020-09-01 | Canada | Nova Scotia | 1085 | 65 | 1014 | 6 | 44.682 | -63.7443 | 2020-09-02 04:28:25 | Nova Scotia, Canada | ||
193842 | 193842 | 2020-08-31 | Canada | Nova Scotia | 1085 | 65 | 1013 | 7 | 44.682 | -63.7443 | 2020-09-01 04:28:31 | Nova Scotia, Canada | ||
3931801 | 3931801 | 2020-08-30 | Canada | Nova Scotia | 1083 | 65 | 1013 | 5 | 44.682 | -63.7443 | 2020-08-31 04:28:27 | Nova Scotia, Canada | ||
609463 | 609463 | 2020-08-29 | Canada | Nova Scotia | 1083 | 65 | 1013 | 5 | 44.682 | -63.7443 | 2020-08-30 04:28:22 | Nova Scotia, Canada | ||
1522958 | 1522958 | 2020-08-28 | Canada | Nova Scotia | 1083 | 65 | 1013 | 5 | 44.682 | -63.7443 | 2020-08-29 04:28:19 | Nova Scotia, Canada | ||
2509959 | 2509959 | 2020-08-27 | Canada | Nova Scotia | 1081 | 65 | 1011 | 5 | 44.682 | -63.7443 | 2020-08-28 04:28:11 | Nova Scotia, Canada | ||
1996419 | 1996419 | 2020-08-26 | Canada | Nova Scotia | 1081 | 65 | 1011 | 5 | 44.682 | -63.7443 | 2020-08-27 04:28:15 | Nova Scotia, Canada | ||
3562343 | 3562343 | 2020-08-25 | Canada | Nova Scotia | 1080 | 65 | 1011 | 4 | 44.682 | -63.7443 | 2020-08-26 04:28:11 | Nova Scotia, Canada | ||
2991047 | 2991047 | 2020-08-24 | Canada | Nova Scotia | 1080 | 65 | 1008 | 7 | 44.682 | -63.7443 | 2020-08-25 04:28:02 | Nova Scotia, Canada | ||
2215442 | 2215442 | 2020-08-23 | Canada | Nova Scotia | 1080 | 65 | 1008 | 7 | 44.682 | -63.7443 | 2020-08-24 04:27:56 | Nova Scotia, Canada | ||
2299224 | 2299224 | 2020-08-22 | Canada | Nova Scotia | 1078 | 64 | 1008 | 6 | 44.682 | -63.7443 | 2020-08-23 04:27:48 | Nova Scotia, Canada | ||
1479331 | 1479331 | 2020-08-21 | Canada | Nova Scotia | 1077 | 64 | 1008 | 5 | 44.682 | -63.7443 | 2020-08-22 04:27:49 | Nova Scotia, Canada | ||
3484080 | 3484080 | 2020-08-20 | Canada | Nova Scotia | 1077 | 64 | 1007 | 6 | 44.682 | -63.7443 | 2020-08-21 04:27:41 | Nova Scotia, Canada | ||
206029 | 206029 | 2020-08-19 | Canada | Nova Scotia | 1076 | 64 | 1007 | 5 | 44.682 | -63.7443 | 2020-08-20 04:27:43 | Nova Scotia, Canada | ||
3177783 | 3177783 | 2020-08-18 | Canada | Nova Scotia | 1075 | 64 | 1007 | 4 | 44.682 | -63.7443 | 2020-08-19 04:27:00 | Nova Scotia, Canada | ||
837387 | 837387 | 2020-08-17 | Canada | Nova Scotia | 1075 | 64 | 1007 | 4 | 44.682 | -63.7443 | 2020-08-18 04:27:56 | Nova Scotia, Canada | ||
1555745 | 1555745 | 2020-08-16 | Canada | Nova Scotia | 1074 | 64 | 1007 | 3 | 44.682 | -63.7443 | 2020-08-17 04:27:20 | Nova Scotia, Canada | ||
145747 | 145747 | 2020-08-15 | Canada | Nova Scotia | 1074 | 64 | 1007 | 3 | 44.682 | -63.7443 | 2020-08-16 04:27:42 | Nova Scotia, Canada | ||
1612022 | 1612022 | 2020-08-14 | Canada | Nova Scotia | 1072 | 64 | 1007 | 1 | 44.682 | -63.7443 | 2020-08-15 04:27:31 | Nova Scotia, Canada | ||
582606 | 582606 | 2020-08-13 | Canada | Nova Scotia | 1071 | 64 | 1007 | 0 | 44.682 | -63.7443 | 2020-08-14 04:51:19 | 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]);