johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,013 rows where combined_key = "British Columbia, Canada" and country_or_region = "Canada" sorted by confirmed
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
province_or_state 1
- British Columbia 1,013
country_or_region 1
- Canada · 1,013 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed ▼ | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2910580 | 2910580 | 2020-03-22 | Canada | British Columbia | 424 | 10 | 0 | 414 | 53.7267 | -127.6476 | 3/22/20 23:48 | British Columbia, Canada | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
2875588 | 2875588 | 2020-03-29 | Canada | British Columbia | 884 | 17 | 0 | 867 | 53.7267 | -127.6476 | 3/29/20 23:13 | British Columbia, Canada | ||
3946924 | 3946924 | 2020-03-28 | Canada | British Columbia | 884 | 17 | 0 | 867 | 53.7267 | -127.6476 | 3/28/20 23:10 | British Columbia, Canada | ||
1872351 | 1872351 | 2020-03-30 | Canada | British Columbia | 970 | 19 | 0 | 951 | 53.7267 | -127.6476 | 3/30/20 22:58 | 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 | ||
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 | ||
3701502 | 3701502 | 2020-04-02 | Canada | British Columbia | 1121 | 31 | 0 | 1090 | 53.7267 | -127.6476 | 4/2/20 23:31 | 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 | ||
1750660 | 1750660 | 2020-04-04 | Canada | British Columbia | 1203 | 38 | 0 | 1165 | 53.7267 | -127.6476 | 4/4/20 23:40 | 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 | ||
3627328 | 3627328 | 2020-04-06 | Canada | British Columbia | 1266 | 38 | 0 | 1228 | 53.7267 | -127.6476 | 4/6/20 23:28 | 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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
287016 | 287016 | 2020-06-15 | Canada | British Columbia | 2745 | 168 | 2395 | 182 | 53.7267 | -127.6476 | 2020-06-16 04:33:09 | British Columbia, Canada | ||
2386453 | 2386453 | 2020-06-16 | Canada | British Columbia | 2756 | 168 | 2416 | 172 | 53.7267 | -127.6476 | 2020-06-17 04:33:21 | British Columbia, Canada | ||
1195690 | 1195690 | 2020-06-17 | Canada | British Columbia | 2775 | 168 | 2422 | 185 | 53.7267 | -127.6476 | 2020-06-18 04:33:18 | British Columbia, Canada | ||
3682487 | 3682487 | 2020-06-18 | Canada | British Columbia | 2783 | 168 | 2425 | 190 | 53.7267 | -127.6476 | 2020-06-19 04:33:17 | British Columbia, Canada | ||
1691338 | 1691338 | 2020-06-19 | Canada | British Columbia | 2790 | 168 | 2444 | 178 | 53.7267 | -127.6476 | 2020-06-20 04:33:19 | British Columbia, Canada | ||
2437760 | 2437760 | 2020-06-20 | Canada | British Columbia | 2790 | 168 | 2444 | 178 | 53.7267 | -127.6476 | 2020-06-21 04:33:19 | British Columbia, Canada | ||
3249167 | 3249167 | 2020-06-21 | Canada | British Columbia | 2790 | 168 | 2444 | 178 | 53.7267 | -127.6476 | 2020-06-22 04:33:20 | British Columbia, Canada | ||
1510428 | 1510428 | 2020-06-22 | Canada | British Columbia | 2822 | 169 | 2471 | 182 | 53.7267 | -127.6476 | 2020-06-23 04:33:22 | British Columbia, Canada | ||
1522234 | 1522234 | 2020-06-23 | Canada | British Columbia | 2835 | 170 | 2491 | 174 | 53.7267 | -127.6476 | 2020-06-24 04:33:28 | British Columbia, Canada | ||
2700549 | 2700549 | 2020-06-24 | Canada | British Columbia | 2849 | 171 | 2516 | 162 | 53.7267 | -127.6476 | 2020-06-25 05:26:54 | British Columbia, Canada | ||
2624909 | 2624909 | 2020-06-25 | Canada | British Columbia | 2869 | 173 | 2517 | 179 | 53.7267 | -127.6476 | 2020-06-26 04:33:43 | British Columbia, Canada | ||
1135922 | 1135922 | 2020-06-26 | Canada | British Columbia | 2878 | 174 | 2545 | 159 | 53.7267 | -127.6476 | 2020-06-27 04:33:35 | British Columbia, Canada | ||
2039641 | 2039641 | 2020-06-27 | Canada | British Columbia | 2878 | 174 | 2545 | 159 | 53.7267 | -127.6476 | 2020-06-28 04:34:04 | British Columbia, Canada | ||
2306306 | 2306306 | 2020-06-28 | Canada | British Columbia | 2878 | 174 | 2545 | 159 | 53.7267 | -127.6476 | 2020-06-29 04:33:44 | British Columbia, Canada | ||
2632743 | 2632743 | 2020-06-29 | Canada | British Columbia | 2904 | 174 | 2577 | 153 | 53.7267 | -127.6476 | 2020-06-30 04:33:48 | 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]);