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 deaths
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
302888 | 302888 | 2020-07-01 | Canada | British Columbia | 2916 | 174 | 2590 | 152 | 53.7267 | -127.6476 | 2020-07-02 04:33:46 | 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 | ||
2974266 | 2974266 | 2020-06-30 | Canada | British Columbia | 2916 | 174 | 2590 | 152 | 53.7267 | -127.6476 | 2020-07-01 04:33:52 | British Columbia, Canada | ||
415180 | 415180 | 2020-07-05 | Canada | British Columbia | 2947 | 177 | 2608 | 162 | 53.7267 | -127.6476 | 2020-07-06 04:33:57 | British Columbia, Canada | ||
529742 | 529742 | 2020-07-04 | Canada | British Columbia | 2947 | 177 | 2608 | 162 | 53.7267 | -127.6476 | 2020-07-05 04:33:46 | British Columbia, Canada | ||
2234403 | 2234403 | 2020-07-03 | Canada | British Columbia | 2947 | 177 | 2608 | 162 | 53.7267 | -127.6476 | 2020-07-04 04:33:51 | British Columbia, Canada | ||
3045197 | 3045197 | 2020-07-02 | Canada | British Columbia | 2940 | 177 | 2603 | 160 | 53.7267 | -127.6476 | 2020-07-03 04:33:54 | British Columbia, Canada | ||
887155 | 887155 | 2020-07-07 | Canada | British Columbia | 2990 | 183 | 2645 | 162 | 53.7267 | -127.6476 | 2020-07-08 05:33:48 | British Columbia, Canada | ||
2684715 | 2684715 | 2020-07-06 | Canada | British Columbia | 2978 | 183 | 2629 | 166 | 53.7267 | -127.6476 | 2020-07-07 04:34:00 | British Columbia, Canada | ||
1005330 | 1005330 | 2020-07-09 | Canada | British Columbia | 3028 | 186 | 2667 | 175 | 53.7267 | -127.6476 | 2020-07-10 04:34:24 | British Columbia, Canada | ||
2222546 | 2222546 | 2020-07-08 | Canada | British Columbia | 3008 | 186 | 2660 | 162 | 53.7267 | -127.6476 | 2020-07-09 04:34:23 | British Columbia, Canada | ||
3237345 | 3237345 | 2020-07-10 | Canada | British Columbia | 3053 | 187 | 2679 | 187 | 53.7267 | -127.6476 | 2020-07-11 04:34:26 | British Columbia, Canada | ||
3435847 | 3435847 | 2020-07-11 | Canada | British Columbia | 3053 | 187 | 2679 | 187 | 53.7267 | -127.6476 | 2020-07-12 04:34:30 | British Columbia, Canada | ||
3737452 | 3737452 | 2020-07-12 | Canada | British Columbia | 3053 | 187 | 2679 | 187 | 53.7267 | -127.6476 | 2020-07-13 04:43:04 | British Columbia, Canada | ||
121727 | 121727 | 2020-07-19 | Canada | British Columbia | 3198 | 189 | 2802 | 207 | 53.7267 | -127.6476 | 2020-07-20 05:34:40 | British Columbia, Canada | ||
326822 | 326822 | 2020-07-20 | Canada | British Columbia | 3300 | 189 | 2858 | 253 | 53.7267 | -127.6476 | 2020-07-21 04:38:46 | British Columbia, Canada | ||
367237 | 367237 | 2020-07-16 | Canada | British Columbia | 3170 | 189 | 2789 | 192 | 53.7267 | -127.6476 | 2020-07-17 04:34:50 | British Columbia, Canada | ||
844592 | 844592 | 2020-07-22 | Canada | British Columbia | 3328 | 189 | 2873 | 266 | 53.7267 | -127.6476 | 2020-07-23 05:15:04 | British Columbia, Canada | ||
1707331 | 1707331 | 2020-07-21 | Canada | British Columbia | 3328 | 189 | 2873 | 266 | 53.7267 | -127.6476 | 2020-07-22 04:34:42 | British Columbia, Canada | ||
2158549 | 2158549 | 2020-07-14 | Canada | British Columbia | 3128 | 189 | 2730 | 209 | 53.7267 | -127.6476 | 2020-07-15 04:34:39 | British Columbia, Canada | ||
2708418 | 2708418 | 2020-07-17 | Canada | British Columbia | 3198 | 189 | 2802 | 207 | 53.7267 | -127.6476 | 2020-07-18 04:34:45 | British Columbia, Canada | ||
2747905 | 2747905 | 2020-07-15 | Canada | British Columbia | 3149 | 189 | 2753 | 207 | 53.7267 | -127.6476 | 2020-07-16 04:44:59 | British Columbia, Canada | ||
3205116 | 3205116 | 2020-07-18 | Canada | British Columbia | 3198 | 189 | 2802 | 207 | 53.7267 | -127.6476 | 2020-07-19 04:34:58 | British Columbia, Canada | ||
3491190 | 3491190 | 2020-07-13 | Canada | British Columbia | 3053 | 189 | 2679 | 185 | 53.7267 | -127.6476 | 2020-07-14 04:34:46 | British Columbia, Canada | ||
61801 | 61801 | 2020-07-23 | Canada | British Columbia | 3392 | 190 | 2898 | 304 | 53.7267 | -127.6476 | 2020-07-24 05:30:40 | British Columbia, Canada | ||
2563572 | 2563572 | 2020-07-24 | Canada | British Columbia | 3392 | 190 | 2898 | 304 | 53.7267 | -127.6476 | 2020-07-25 04:47:39 | British Columbia, Canada | ||
442358 | 442358 | 2020-07-26 | Canada | British Columbia | 3419 | 191 | 2934 | 294 | 53.7267 | -127.6476 | 2020-07-27 04:35:02 | British Columbia, Canada | ||
1502602 | 1502602 | 2020-07-25 | Canada | British Columbia | 3419 | 191 | 2934 | 294 | 53.7267 | -127.6476 | 2020-07-26 04:35:00 | British Columbia, Canada | ||
177045 | 177045 | 2020-07-27 | Canada | British Columbia | 3500 | 193 | 3043 | 264 | 53.7267 | -127.6476 | 2020-07-28 04:58:43 | British Columbia, Canada | ||
1928209 | 1928209 | 2020-07-30 | Canada | British Columbia | 3591 | 194 | 3155 | 242 | 53.7267 | -127.6476 | 2020-07-31 04:35:18 | British Columbia, Canada | ||
2958377 | 2958377 | 2020-07-29 | Canada | British Columbia | 3562 | 194 | 3109 | 259 | 53.7267 | -127.6476 | 2020-07-30 04:35:05 | British Columbia, Canada | ||
3184993 | 3184993 | 2020-07-28 | Canada | British Columbia | 3523 | 194 | 3076 | 253 | 53.7267 | -127.6476 | 2020-07-29 04:35:11 | British Columbia, Canada | ||
98134 | 98134 | 2020-08-04 | Canada | British Columbia | 3787 | 195 | 3273 | 319 | 53.7267 | -127.6476 | 2020-08-05 04:34:43 | British Columbia, Canada | ||
371199 | 371199 | 2020-08-08 | Canada | British Columbia | 3934 | 195 | 3353 | 386 | 53.7267 | -127.6476 | 2020-08-09 04:34:54 | British Columbia, Canada | ||
458383 | 458383 | 2020-08-07 | Canada | British Columbia | 3934 | 195 | 3353 | 386 | 53.7267 | -127.6476 | 2020-08-08 04:34:53 | British Columbia, Canada | ||
662067 | 662067 | 2020-08-11 | Canada | British Columbia | 4111 | 195 | 3444 | 472 | 53.7267 | -127.6476 | 2020-08-12 04:27:29 | British Columbia, Canada | ||
753337 | 753337 | 2020-08-01 | Canada | British Columbia | 3641 | 195 | 3168 | 278 | 53.7267 | -127.6476 | 2020-08-02 04:34:47 | British Columbia, Canada | ||
1920222 | 1920222 | 2020-08-10 | Canada | British Columbia | 4065 | 195 | 3425 | 445 | 53.7267 | -127.6476 | 2020-08-11 04:35:08 | British Columbia, Canada | ||
2740017 | 2740017 | 2020-08-03 | Canada | British Columbia | 3641 | 195 | 3168 | 278 | 53.7267 | -127.6476 | 2020-08-04 04:41:59 | British Columbia, Canada | ||
2807769 | 2807769 | 2020-08-02 | Canada | British Columbia | 3641 | 195 | 3168 | 278 | 53.7267 | -127.6476 | 2020-08-03 04:34:35 | British Columbia, Canada | ||
3264502 | 3264502 | 2020-07-31 | Canada | British Columbia | 3641 | 195 | 3168 | 278 | 53.7267 | -127.6476 | 2020-08-01 04:36:27 | British Columbia, Canada | ||
3531218 | 3531218 | 2020-08-12 | Canada | British Columbia | 4111 | 195 | 3444 | 472 | 53.7267 | -127.6476 | 2020-08-13 04:29:15 | British Columbia, Canada | ||
3612068 | 3612068 | 2020-08-06 | Canada | British Columbia | 3881 | 195 | 3315 | 371 | 53.7267 | -127.6476 | 2020-08-07 04:35:11 | British Columbia, Canada | ||
3792898 | 3792898 | 2020-08-05 | Canada | British Columbia | 3834 | 195 | 3288 | 351 | 53.7267 | -127.6476 | 2020-08-06 04:35:02 | British Columbia, Canada | ||
3923031 | 3923031 | 2020-08-09 | Canada | British Columbia | 3934 | 195 | 3353 | 386 | 53.7267 | -127.6476 | 2020-08-10 04:34:55 | British Columbia, Canada | ||
145740 | 145740 | 2020-08-15 | Canada | British Columbia | 4358 | 196 | 3533 | 629 | 53.7267 | -127.6476 | 2020-08-16 04:27:42 | British Columbia, Canada | ||
582599 | 582599 | 2020-08-13 | Canada | British Columbia | 4274 | 196 | 3500 | 578 | 53.7267 | -127.6476 | 2020-08-14 04:51:19 | 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]);