johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,067 rows where country_or_region = "Canada" and province_or_state = "British Columbia" sorted by last_update
This data as json, yaml, Notebook, copyable, CSV (advanced)
day (date) >30 ✖
- 2020-02-29 1
- 2020-03-01 1
- 2020-03-02 1
- 2020-03-03 1
- 2020-03-04 1
- 2020-03-05 1
- 2020-03-06 1
- 2020-03-07 1
- 2020-03-08 1
- 2020-03-09 1
- 2020-03-10 1
- 2020-03-11 1
- 2020-03-12 1
- 2020-03-13 1
- 2020-03-14 1
- 2020-03-15 1
- 2020-03-16 1
- 2020-03-17 1
- 2020-03-18 1
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- …
province_or_state 1
- British Columbia · 1,035 ✖
country_or_region 1
- Canada · 1,035 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update ▼ | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
562553 | 562553 | 2020-03-01 | Canada | British Columbia | 8 | 0 | 3 | 49.2827 | -123.1207 | 2020-02-29T23:23:13 | ||||
1152695 | 1152695 | 2020-03-02 | Canada | British Columbia | 8 | 0 | 3 | 49.2827 | -123.1207 | 2020-02-29T23:23:13 | ||||
3205838 | 3205838 | 2020-02-29 | Canada | British Columbia | 8 | 0 | 3 | 53.7267 | -127.6476 | 2020-02-29T23:23:13 | ||||
261083 | 261083 | 2020-03-03 | Canada | British Columbia | 9 | 0 | 3 | 49.2827 | -123.1207 | 2020-03-03T23:53:03 | ||||
98866 | 98866 | 2020-03-04 | Canada | British Columbia | 12 | 0 | 3 | 49.2827 | -123.1207 | 2020-03-04T04:23:05 | ||||
40200 | 40200 | 2020-03-05 | Canada | British Columbia | 13 | 0 | 3 | 49.2827 | -123.1207 | 2020-03-05T04:43:03 | ||||
3177536 | 3177536 | 2020-03-06 | Canada | British Columbia | 21 | 0 | 3 | 49.2827 | -123.1207 | 2020-03-06T04:43:03 | ||||
62537 | 62537 | 2020-03-07 | Canada | British Columbia | 21 | 0 | 4 | 49.2827 | -123.1207 | 2020-03-07T03:53:03 | ||||
1527269 | 1527269 | 2020-03-08 | Canada | British Columbia | 27 | 0 | 4 | 49.2827 | -123.1207 | 2020-03-08T05:13:07 | ||||
657748 | 657748 | 2020-03-09 | Canada | British Columbia | 32 | 1 | 4 | 53.7267 | -127.6476 | 2020-03-09T22:43:25 | ||||
3752886 | 3752886 | 2020-03-10 | Canada | British Columbia | 32 | 1 | 4 | 53.7267 | -127.6476 | 2020-03-09T22:43:25 | ||||
2127505 | 2127505 | 2020-03-11 | Canada | British Columbia | 39 | 1 | 4 | 53.7267 | -127.6476 | 2020-03-11T02:18:28 | ||||
3765322 | 3765322 | 2020-03-13 | Canada | British Columbia | 64 | 1 | 4 | 53.7267 | -127.6476 | 2020-03-11T20:00:00 | ||||
2282934 | 2282934 | 2020-03-12 | Canada | British Columbia | 46 | 1 | 4 | 53.7267 | -127.6476 | 2020-03-12T01:53:03 | ||||
2111169 | 2111169 | 2020-03-14 | Canada | British Columbia | 64 | 1 | 4 | 53.7267 | -127.6476 | 2020-03-14T00:13:05 | ||||
1463544 | 1463544 | 2020-03-15 | Canada | British Columbia | 73 | 1 | 4 | 53.7267 | -127.6476 | 2020-03-15T01:53:02 | ||||
2255192 | 2255192 | 2020-03-16 | Canada | British Columbia | 103 | 4 | 4 | 53.7267 | -127.6476 | 2020-03-16T19:13:13 | ||||
3891392 | 3891392 | 2020-03-17 | Canada | British Columbia | 103 | 4 | 4 | 53.7267 | -127.6476 | 2020-03-16T19:13:13 | ||||
1176941 | 1176941 | 2020-03-18 | Canada | British Columbia | 186 | 7 | 4 | 53.7267 | -127.6476 | 2020-03-18T03:33:03 | ||||
1526942 | 1526942 | 2020-03-19 | Canada | British Columbia | 231 | 7 | 4 | 53.7267 | -127.6476 | 2020-03-19T03:13:26 | ||||
3733991 | 3733991 | 2020-03-20 | Canada | British Columbia | 271 | 8 | 4 | 53.7267 | -127.6476 | 2020-03-20T03:13:18 | ||||
339681 | 339681 | 2020-03-21 | Canada | British Columbia | 424 | 10 | 4 | 53.7267 | -127.6476 | 2020-03-21T21:13:30 | ||||
2147037 | 2147037 | 2020-03-23 | Canada | British Columbia | 472 | 13 | 0 | 459 | 53.7267 | -127.6476 | 2020-03-23 23:23:10 | British Columbia, Canada | ||
1478979 | 1478979 | 2020-03-24 | Canada | British Columbia | 617 | 13 | 0 | 604 | 53.7267 | -127.6476 | 2020-03-24 23:41:36 | British Columbia, Canada | ||
1132471 | 1132471 | 2020-03-25 | Canada | British Columbia | 617 | 13 | 0 | 604 | 53.7267 | -127.6476 | 2020-03-25 23:37:36 | British Columbia, Canada | ||
919068 | 919068 | 2020-03-26 | Canada | British Columbia | 725 | 14 | 0 | 711 | 53.7267 | -127.6476 | 2020-03-26 23:53:11 | British Columbia, Canada | ||
808975 | 808975 | 2020-03-27 | Canada | British Columbia | 725 | 14 | 0 | 711 | 53.7267 | -127.6476 | 2020-03-27 23:27:32 | British Columbia, Canada | ||
3815799 | 3815799 | 2020-03-31 | Canada | British Columbia | 1013 | 24 | 0 | 989 | 53.7267 | -127.6476 | 2020-03-31 23:49:13 | British Columbia, Canada | ||
3364706 | 3364706 | 2020-04-01 | Canada | British Columbia | 1013 | 24 | 0 | 989 | 53.7267 | -127.6476 | 2020-04-01 22:04:44 | British Columbia, Canada | ||
3740472 | 3740472 | 2020-04-03 | Canada | British Columbia | 1174 | 31 | 0 | 1143 | 53.7267 | -127.6476 | 2020-04-03 22:52:30 | British Columbia, Canada | ||
589016 | 589016 | 2020-04-05 | Canada | British Columbia | 1203 | 38 | 0 | 1165 | 53.7267 | -127.6476 | 2020-04-05 23:13:28 | British Columbia, Canada | ||
3021646 | 3021646 | 2020-04-07 | Canada | British Columbia | 1266 | 39 | 0 | 1227 | 53.7267 | -127.6476 | 2020-04-07 23:11:15 | British Columbia, Canada | ||
3561971 | 3561971 | 2020-04-08 | Canada | British Columbia | 1291 | 43 | 0 | 1248 | 53.7267 | -127.6476 | 2020-04-08 22:58:44 | British Columbia, Canada | ||
3949864 | 3949864 | 2020-04-09 | Canada | British Columbia | 1336 | 48 | 0 | 1288 | 53.7267 | -127.6476 | 2020-04-09 23:09:01 | British Columbia, Canada | ||
1250127 | 1250127 | 2020-04-10 | Canada | British Columbia | 1370 | 50 | 0 | 1320 | 53.7267 | -127.6476 | 2020-04-10 23:01:26 | British Columbia, Canada | ||
2566942 | 2566942 | 2020-04-11 | Canada | British Columbia | 1445 | 58 | 0 | 1387 | 53.7267 | -127.6476 | 2020-04-11 22:52:28 | British Columbia, Canada | ||
2578106 | 2578106 | 2020-04-12 | Canada | British Columbia | 1445 | 58 | 0 | 1387 | 53.7267 | -127.6476 | 2020-04-12 23:24:00 | British Columbia, Canada | ||
43080 | 43080 | 2020-04-13 | Canada | British Columbia | 1490 | 69 | 0 | 1421 | 53.7267 | -127.6476 | 2020-04-13 23:15:25 | British Columbia, Canada | ||
3337983 | 3337983 | 2020-04-14 | Canada | British Columbia | 1490 | 69 | 0 | 1421 | 53.7267 | -127.6476 | 2020-04-14 23:40:54 | British Columbia, Canada | ||
860067 | 860067 | 2020-04-15 | Canada | British Columbia | 1517 | 72 | 0 | 1445 | 53.7267 | -127.6476 | 2020-04-15 23:04:09 | British Columbia, Canada | ||
934173 | 934173 | 2020-04-16 | Canada | British Columbia | 1561 | 75 | 0 | 1486 | 53.7267 | -127.6476 | 2020-04-16 23:38:03 | British Columbia, Canada | ||
50179 | 50179 | 2020-04-17 | Canada | British Columbia | 1575 | 77 | 0 | 1498 | 53.7267 | -127.6476 | 2020-04-17 23:38:31 | British Columbia, Canada | ||
418707 | 418707 | 2020-04-18 | Canada | British Columbia | 1618 | 78 | 0 | 1540 | 53.7267 | -127.6476 | 2020-04-18 22:40:03 | British Columbia, Canada | ||
1385019 | 1385019 | 2020-04-19 | Canada | British Columbia | 1647 | 81 | 0 | 1566 | 53.7267 | -127.6476 | 2020-04-19 23:48:49 | British Columbia, Canada | ||
2473327 | 2473327 | 2020-04-20 | Canada | British Columbia | 1647 | 82 | 0 | 1565 | 53.7267 | -127.6476 | 2020-04-20 23:44:34 | British Columbia, Canada | ||
522245 | 522245 | 2020-04-21 | Canada | British Columbia | 1724 | 87 | 0 | 1637 | 53.7267 | -127.6476 | 2020-04-21 23:38:53 | British Columbia, Canada | ||
1199180 | 1199180 | 2020-04-22 | Canada | British Columbia | 1795 | 90 | 0 | 1705 | 53.7267 | -127.6476 | 2020-04-22 23:38:42 | British Columbia, Canada | ||
2524736 | 2524736 | 2020-04-23 | Canada | British Columbia | 1824 | 94 | 0 | 1730 | 53.7267 | -127.6476 | 2020-04-24 03:31:19 | British Columbia, Canada | ||
1459150 | 1459150 | 2020-04-24 | Canada | British Columbia | 1853 | 98 | 0 | 1755 | 53.7267 | -127.6476 | 2020-04-25 06:30:55 | British Columbia, Canada | ||
3502749 | 3502749 | 2020-04-25 | Canada | British Columbia | 1948 | 100 | 0 | 1848 | 53.7267 | -127.6476 | 2020-04-26 02:30:54 | British Columbia, Canada | ||
3592400 | 3592400 | 2020-04-26 | Canada | British Columbia | 1948 | 100 | 0 | 1848 | 53.7267 | -127.6476 | 2020-04-27 02:30:55 | British Columbia, Canada | ||
3589218 | 3589218 | 2020-04-27 | Canada | British Columbia | 1998 | 104 | 0 | 1894 | 53.7267 | -127.6476 | 2020-04-28 02:30:53 | British Columbia, Canada | ||
271556 | 271556 | 2020-04-28 | Canada | British Columbia | 2053 | 106 | 0 | 1947 | 53.7267 | -127.6476 | 2020-04-29 02:32:29 | British Columbia, Canada | ||
137342 | 137342 | 2020-04-29 | Canada | British Columbia | 2087 | 109 | 0 | 1978 | 53.7267 | -127.6476 | 2020-04-30 02:32:27 | British Columbia, Canada | ||
228595 | 228595 | 2020-04-30 | Canada | British Columbia | 2112 | 111 | 0 | 2001 | 53.7267 | -127.6476 | 2020-05-01 02:32:28 | British Columbia, Canada | ||
1184114 | 1184114 | 2020-05-01 | Canada | British Columbia | 2145 | 112 | 0 | 2033 | 53.7267 | -127.6476 | 2020-05-02 02:32:27 | British Columbia, Canada | ||
2043220 | 2043220 | 2020-05-02 | Canada | British Columbia | 2171 | 114 | 0 | 2057 | 53.7267 | -127.6476 | 2020-05-03 02:32:28 | British Columbia, Canada | ||
2278544 | 2278544 | 2020-05-03 | Canada | British Columbia | 2171 | 114 | 0 | 2057 | 53.7267 | -127.6476 | 2020-05-04 02:32:28 | British Columbia, Canada | ||
3084685 | 3084685 | 2020-05-04 | Canada | British Columbia | 2224 | 117 | 0 | 2107 | 53.7267 | -127.6476 | 2020-05-05 02:32:34 | British Columbia, Canada | ||
1931822 | 1931822 | 2020-05-05 | Canada | British Columbia | 2232 | 121 | 0 | 2111 | 53.7267 | -127.6476 | 2020-05-06 02:32:31 | British Columbia, Canada | ||
2110782 | 2110782 | 2020-05-06 | Canada | British Columbia | 2255 | 124 | 0 | 2131 | 53.7267 | -127.6476 | 2020-05-07 02:32:28 | British Columbia, Canada | ||
3295561 | 3295561 | 2020-05-07 | Canada | British Columbia | 2288 | 126 | 0 | 2162 | 53.7267 | -127.6476 | 2020-05-08 02:32:32 | British Columbia, Canada | ||
114118 | 114118 | 2020-05-08 | Canada | British Columbia | 2315 | 127 | 0 | 2188 | 53.7267 | -127.6476 | 2020-05-09 02:32:35 | British Columbia, Canada | ||
2899069 | 2899069 | 2020-05-09 | Canada | British Columbia | 2330 | 129 | 0 | 2201 | 53.7267 | -127.6476 | 2020-05-10 02:32:30 | British Columbia, Canada | ||
3459528 | 3459528 | 2020-05-10 | Canada | British Columbia | 2330 | 129 | 0 | 2201 | 53.7267 | -127.6476 | 2020-05-11 02:32:30 | British Columbia, Canada | ||
3330913 | 3330913 | 2020-05-11 | Canada | British Columbia | 2353 | 130 | 0 | 2223 | 53.7267 | -127.6476 | 2020-05-12 03:32:27 | British Columbia, Canada | ||
2581379 | 2581379 | 2020-05-12 | Canada | British Columbia | 2360 | 132 | 0 | 2228 | 53.7267 | -127.6476 | 2020-05-13 03:32:26 | British Columbia, Canada | ||
3847172 | 3847172 | 2020-05-13 | Canada | British Columbia | 2376 | 132 | 0 | 2244 | 53.7267 | -127.6476 | 2020-05-14 03:32:28 | British Columbia, Canada | ||
1404367 | 1404367 | 2020-05-14 | Canada | British Columbia | 2392 | 135 | 1885 | 372 | 53.7267 | -127.6476 | 2020-05-15 02:33:02 | British Columbia, Canada | ||
3276193 | 3276193 | 2020-05-15 | Canada | British Columbia | 2407 | 140 | 1908 | 359 | 53.7267 | -127.6476 | 2020-05-16 02:32:19 | British Columbia, Canada | ||
1829477 | 1829477 | 2020-05-16 | Canada | British Columbia | 2428 | 141 | 1932 | 355 | 53.7267 | -127.6476 | 2020-05-17 02:32:32 | British Columbia, Canada | ||
3416243 | 3416243 | 2020-05-17 | Canada | British Columbia | 2428 | 141 | 1932 | 355 | 53.7267 | -127.6476 | 2020-05-18 02:32:21 | British Columbia, Canada | ||
3260849 | 3260849 | 2020-05-18 | Canada | British Columbia | 2444 | 143 | 1966 | 335 | 53.7267 | -127.6476 | 2020-05-19 02:32:18 | British Columbia, Canada | ||
2390110 | 2390110 | 2020-05-19 | Canada | British Columbia | 2446 | 146 | 1981 | 319 | 53.7267 | -127.6476 | 2020-05-20 02:32:19 | British Columbia, Canada | ||
1431830 | 1431830 | 2020-05-20 | Canada | British Columbia | 2467 | 149 | 2005 | 313 | 53.7267 | -127.6476 | 2020-05-21 02:32:48 | British Columbia, Canada | ||
268247 | 268247 | 2020-05-21 | Canada | British Columbia | 2479 | 152 | 2023 | 304 | 53.7267 | -127.6476 | 2020-05-22 02:36:51 | British Columbia, Canada | ||
1864741 | 1864741 | 2020-05-22 | Canada | British Columbia | 2507 | 155 | 2043 | 309 | 53.7267 | -127.6476 | 2020-05-23 02:32:42 | British Columbia, Canada | ||
997718 | 997718 | 2020-05-23 | Canada | British Columbia | 2517 | 157 | 2057 | 303 | 53.7267 | -127.6476 | 2020-05-24 02:32:43 | British Columbia, Canada | ||
875527 | 875527 | 2020-05-24 | Canada | British Columbia | 2517 | 157 | 2057 | 303 | 53.7267 | -127.6476 | 2020-05-25 02:32:44 | British Columbia, Canada | ||
1104847 | 1104847 | 2020-05-25 | Canada | British Columbia | 2530 | 161 | 2102 | 267 | 53.7267 | -127.6476 | 2020-05-26 02:32:35 | British Columbia, Canada | ||
1041117 | 1041117 | 2020-05-26 | Canada | British Columbia | 2541 | 161 | 2122 | 258 | 53.7267 | -127.6476 | 2020-05-27 02:32:31 | British Columbia, Canada | ||
2548154 | 2548154 | 2020-05-27 | Canada | British Columbia | 2550 | 162 | 2144 | 244 | 53.7267 | -127.6476 | 2020-05-28 02:32:31 | British Columbia, Canada | ||
2712148 | 2712148 | 2020-05-28 | Canada | British Columbia | 2558 | 164 | 2153 | 241 | 53.7267 | -127.6476 | 2020-05-29 02:32:50 | British Columbia, Canada | ||
1790268 | 1790268 | 2020-05-29 | Canada | British Columbia | 2562 | 164 | 2177 | 221 | 53.7267 | -127.6476 | 2020-05-30 02:32:48 | British Columbia, Canada | ||
3638727 | 3638727 | 2020-05-30 | Canada | British Columbia | 2573 | 164 | 2181 | 228 | 53.7267 | -127.6476 | 2020-05-31 02:32:45 | British Columbia, Canada | ||
1793834 | 1793834 | 2020-05-31 | Canada | British Columbia | 2573 | 164 | 2181 | 228 | 53.7267 | -127.6476 | 2020-06-01 02:32:46 | British Columbia, Canada | ||
805197 | 805197 | 2020-06-01 | Canada | British Columbia | 2597 | 165 | 2207 | 225 | 53.7267 | -127.6476 | 2020-06-02 02:33:08 | British Columbia, Canada | ||
2555661 | 2555661 | 2020-06-02 | Canada | British Columbia | 2601 | 165 | 2229 | 207 | 53.7267 | -127.6476 | 2020-06-03 02:33:13 | British Columbia, Canada | ||
3866618 | 3866618 | 2020-06-03 | Canada | British Columbia | 2623 | 166 | 2243 | 214 | 53.7267 | -127.6476 | 2020-06-04 02:33:14 | British Columbia, Canada | ||
1281063 | 1281063 | 2020-06-04 | Canada | British Columbia | 2632 | 166 | 2265 | 201 | 53.7267 | -127.6476 | 2020-06-05 02:33:06 | British Columbia, Canada | ||
1269583 | 1269583 | 2020-06-05 | Canada | British Columbia | 2632 | 167 | 2272 | 193 | 53.7267 | -127.6476 | 2020-06-06 02:33:00 | British Columbia, Canada | ||
573886 | 573886 | 2020-06-06 | Canada | British Columbia | 2632 | 167 | 2272 | 193 | 53.7267 | -127.6476 | 2020-06-07 03:53:30 | British Columbia, Canada | ||
2799830 | 2799830 | 2020-06-07 | Canada | British Columbia | 2632 | 167 | 2272 | 193 | 53.7267 | -127.6476 | 2020-06-08 03:33:22 | British Columbia, Canada | ||
217033 | 217033 | 2020-06-08 | Canada | British Columbia | 2659 | 167 | 2309 | 183 | 53.7267 | -127.6476 | 2020-06-09 03:33:03 | British Columbia, Canada | ||
1210606 | 1210606 | 2020-06-09 | Canada | British Columbia | 2669 | 167 | 2319 | 183 | 53.7267 | -127.6476 | 2020-06-10 04:07:00 | British Columbia, Canada | ||
2863753 | 2863753 | 2020-06-10 | Canada | British Columbia | 2680 | 167 | 2328 | 185 | 53.7267 | -127.6476 | 2020-06-11 03:33:41 | British Columbia, Canada | ||
1273309 | 1273309 | 2020-06-11 | Canada | British Columbia | 2694 | 167 | 2344 | 183 | 53.7267 | -127.6476 | 2020-06-12 05:09:52 | British Columbia, Canada | ||
737339 | 737339 | 2020-06-12 | Canada | British Columbia | 2709 | 168 | 2354 | 187 | 53.7267 | -127.6476 | 2020-06-13 03:33:14 | British Columbia, Canada | ||
3061019 | 3061019 | 2020-06-13 | Canada | British Columbia | 2709 | 168 | 2354 | 187 | 53.7267 | -127.6476 | 2020-06-14 03:33:15 | British Columbia, Canada | ||
1836967 | 1836967 | 2020-06-14 | Canada | British Columbia | 2709 | 168 | 2354 | 187 | 53.7267 | -127.6476 | 2020-06-15 03:33:14 | British Columbia, 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]);