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 active descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▲ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1841709 | 1841709 | 2021-04-14 | Canada | British Columbia | 114870 | 1521 | 103360 | 9989 | 53.7267 | -127.6476 | 2021-04-15 04:20:54 | British Columbia, Canada | ||
1006060 | 1006060 | 2020-12-06 | Canada | British Columbia | 36132 | 492 | 25658 | 9982 | 53.7267 | -127.6476 | 2020-12-07 05:26:14 | British Columbia, Canada | ||
1632069 | 1632069 | 2020-12-05 | Canada | British Columbia | 36132 | 492 | 25658 | 9982 | 53.7267 | -127.6476 | 2020-12-06 05:26:18 | British Columbia, Canada | ||
3859597 | 3859597 | 2020-12-04 | Canada | British Columbia | 36132 | 492 | 25658 | 9982 | 53.7267 | -127.6476 | 2020-12-05 05:27:36 | British Columbia, Canada | ||
2571443 | 2571443 | 2021-04-13 | Canada | British Columbia | 113702 | 1515 | 102268 | 9919 | 53.7267 | -127.6476 | 2021-04-14 04:20:41 | 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 | ||
738067 | 738067 | 2020-12-02 | Canada | British Columbia | 34728 | 469 | 24424 | 9835 | 53.7267 | -127.6476 | 2020-12-03 05:28:22 | British Columbia, Canada | ||
609456 | 609456 | 2020-08-29 | Canada | British Columbia | 5496 | 204 | 4310 | 982 | 53.7267 | -127.6476 | 2020-08-30 04:28:22 | British Columbia, Canada | ||
1522951 | 1522951 | 2020-08-28 | Canada | British Columbia | 5496 | 204 | 4310 | 982 | 53.7267 | -127.6476 | 2020-08-29 04:28:19 | British Columbia, Canada | ||
3931794 | 3931794 | 2020-08-30 | Canada | British Columbia | 5496 | 204 | 4310 | 982 | 53.7267 | -127.6476 | 2020-08-31 04:28:27 | British Columbia, Canada | ||
605453 | 605453 | 2021-04-09 | Canada | British Columbia | 109540 | 1495 | 98336 | 9709 | 53.7267 | -127.6476 | 2021-04-10 04:20:59 | British Columbia, Canada | ||
2983021 | 2983021 | 2021-04-10 | Canada | British Columbia | 109540 | 1495 | 98336 | 9709 | 53.7267 | -127.6476 | 2021-04-11 04:20:56 | British Columbia, Canada | ||
3883353 | 3883353 | 2021-04-11 | Canada | British Columbia | 109540 | 1495 | 98336 | 9709 | 53.7267 | -127.6476 | 2021-04-12 04:21:00 | British Columbia, Canada | ||
1583930 | 1583930 | 2020-11-30 | Canada | British Columbia | 33238 | 441 | 23111 | 9686 | 53.7267 | -127.6476 | 2020-12-01 05:26:18 | British Columbia, Canada | ||
2537161 | 2537161 | 2020-12-01 | Canada | British Columbia | 33894 | 457 | 23774 | 9663 | 53.7267 | -127.6476 | 2020-12-02 05:27:41 | British Columbia, Canada | ||
923448 | 923448 | 2020-11-26 | Canada | British Columbia | 29973 | 384 | 19998 | 9591 | 53.7267 | -127.6476 | 2020-11-27 05:26:53 | British Columbia, Canada | ||
2410608 | 2410608 | 2021-04-19 | Canada | British Columbia | 120040 | 1538 | 108919 | 9583 | 53.7267 | -127.6476 | 2021-04-20 04:20:41 | 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 | ||
3125271 | 3125271 | 2021-06-28 | Canada | British Columbia | 147549 | 1754 | 144848 | 947 | 53.7267 | -127.6476 | 2021-06-29 04:21:28 | British Columbia, Canada | ||
2020487 | 2020487 | 2021-04-20 | Canada | British Columbia | 120889 | 1539 | 109973 | 9377 | 53.7267 | -127.6476 | 2021-04-21 04:21:14 | British Columbia, Canada | ||
2645517 | 2645517 | 2021-04-08 | Canada | British Columbia | 108278 | 1493 | 97462 | 9323 | 53.7267 | -127.6476 | 2021-04-09 04:21:13 | British Columbia, Canada | ||
3562336 | 3562336 | 2020-08-25 | Canada | British Columbia | 5242 | 203 | 4114 | 925 | 53.7267 | -127.6476 | 2020-08-26 04:28:11 | British Columbia, Canada | ||
392001 | 392001 | 2020-11-27 | Canada | British Columbia | 30884 | 395 | 21304 | 9185 | 53.7267 | -127.6476 | 2020-11-28 05:25:50 | British Columbia, Canada | ||
2934998 | 2934998 | 2020-11-28 | Canada | British Columbia | 30884 | 395 | 21304 | 9185 | 53.7267 | -127.6476 | 2020-11-29 05:25:55 | British Columbia, Canada | ||
3566333 | 3566333 | 2020-11-29 | Canada | British Columbia | 30884 | 395 | 21304 | 9185 | 53.7267 | -127.6476 | 2020-11-30 05:26:13 | British Columbia, Canada | ||
408058 | 408058 | 2021-07-28 | Canada | British Columbia | 149444 | 1771 | 146756 | 917 | 53.7267 | -127.6476 | 2021-07-29 04:21:33 | British Columbia, Canada | ||
3242091 | 3242091 | 2021-04-21 | Canada | British Columbia | 121751 | 1546 | 111039 | 9166 | 53.7267 | -127.6476 | 2021-04-22 04:20:53 | British Columbia, Canada | ||
2509952 | 2509952 | 2020-08-27 | Canada | British Columbia | 5372 | 204 | 4253 | 915 | 53.7267 | -127.6476 | 2020-08-28 04:28:11 | British Columbia, Canada | ||
2991040 | 2991040 | 2020-08-24 | Canada | British Columbia | 5184 | 203 | 4068 | 913 | 53.7267 | -127.6476 | 2020-08-25 04:28:02 | British Columbia, Canada | ||
954629 | 954629 | 2021-04-25 | Canada | British Columbia | 123758 | 1554 | 113139 | 9065 | 53.7267 | -127.6476 | 2021-04-26 04:21:04 | British Columbia, Canada | ||
1408807 | 1408807 | 2021-04-23 | Canada | British Columbia | 123758 | 1554 | 113139 | 9065 | 53.7267 | -127.6476 | 2021-04-24 04:20:38 | British Columbia, Canada | ||
3923776 | 3923776 | 2021-04-24 | Canada | British Columbia | 123758 | 1554 | 113139 | 9065 | 53.7267 | -127.6476 | 2021-04-25 04:20:32 | British Columbia, Canada | ||
1996412 | 1996412 | 2020-08-26 | Canada | British Columbia | 5304 | 203 | 4199 | 902 | 53.7267 | -127.6476 | 2020-08-27 04:28:15 | British Columbia, Canada | ||
1567870 | 1567870 | 2021-04-22 | Canada | British Columbia | 122757 | 1550 | 112235 | 8972 | 53.7267 | -127.6476 | 2021-04-23 04:20:52 | British Columbia, Canada | ||
1136650 | 1136650 | 2021-01-01 | Canada | British Columbia | 51990 | 901 | 42127 | 8962 | 53.7267 | -127.6476 | 2021-01-02 05:22:33 | British Columbia, Canada | ||
2227286 | 2227286 | 2021-01-02 | Canada | British Columbia | 51990 | 901 | 42127 | 8962 | 53.7267 | -127.6476 | 2021-01-03 05:22:52 | British Columbia, Canada | ||
3230216 | 3230216 | 2021-01-03 | Canada | British Columbia | 51990 | 901 | 42127 | 8962 | 53.7267 | -127.6476 | 2021-01-04 05:22:02 | British Columbia, Canada | ||
3695256 | 3695256 | 2020-12-31 | Canada | British Columbia | 51990 | 901 | 42127 | 8962 | 53.7267 | -127.6476 | 2021-01-01 05:23:07 | British Columbia, Canada | ||
400028 | 400028 | 2021-06-29 | Canada | British Columbia | 147578 | 1754 | 144931 | 893 | 53.7267 | -127.6476 | 2021-06-30 04:21:41 | British Columbia, Canada | ||
1972353 | 1972353 | 2020-11-25 | Canada | British Columbia | 29086 | 371 | 19814 | 8901 | 53.7267 | -127.6476 | 2020-11-26 05:27:44 | British Columbia, Canada | ||
2247159 | 2247159 | 2021-04-07 | Canada | British Columbia | 106985 | 1491 | 96626 | 8868 | 53.7267 | -127.6476 | 2021-04-08 04:21:13 | British Columbia, Canada | ||
3003069 | 3003069 | 2021-04-06 | Canada | British Columbia | 105988 | 1489 | 95691 | 8808 | 53.7267 | -127.6476 | 2021-04-07 04:20:53 | British Columbia, Canada | ||
766086 | 766086 | 2020-12-29 | Canada | British Columbia | 50815 | 882 | 41175 | 8758 | 53.7267 | -127.6476 | 2020-12-30 05:22:34 | British Columbia, Canada | ||
1010071 | 1010071 | 2020-12-30 | Canada | British Columbia | 51300 | 893 | 41681 | 8726 | 53.7267 | -127.6476 | 2020-12-31 05:22:49 | 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 | ||
887884 | 887884 | 2021-04-26 | Canada | British Columbia | 126249 | 1571 | 116241 | 8437 | 53.7267 | -127.6476 | 2021-04-27 04:20:52 | British Columbia, Canada | ||
1350084 | 1350084 | 2020-11-24 | Canada | British Columbia | 28348 | 358 | 19605 | 8385 | 53.7267 | -127.6476 | 2020-11-25 05:27:20 | British Columbia, Canada | ||
1892905 | 1892905 | 2021-06-30 | Canada | British Columbia | 147621 | 1754 | 145032 | 835 | 53.7267 | -127.6476 | 2021-07-01 04:21:19 | British Columbia, Canada | ||
2764697 | 2764697 | 2021-07-01 | Canada | British Columbia | 147621 | 1754 | 145032 | 835 | 53.7267 | -127.6476 | 2021-07-02 04:21:47 | British Columbia, Canada | ||
3701875 | 3701875 | 2021-04-27 | Canada | British Columbia | 127048 | 1571 | 117150 | 8327 | 53.7267 | -127.6476 | 2021-04-28 04:20:32 | British Columbia, Canada | ||
3393159 | 3393159 | 2021-04-28 | Canada | British Columbia | 127889 | 1576 | 118057 | 8256 | 53.7267 | -127.6476 | 2021-04-29 04:20:55 | British Columbia, Canada | ||
1479324 | 1479324 | 2020-08-21 | Canada | British Columbia | 4915 | 202 | 3889 | 824 | 53.7267 | -127.6476 | 2020-08-22 04:27:49 | British Columbia, Canada | ||
2215435 | 2215435 | 2020-08-23 | Canada | British Columbia | 4915 | 202 | 3889 | 824 | 53.7267 | -127.6476 | 2020-08-24 04:27:56 | British Columbia, Canada | ||
2299217 | 2299217 | 2020-08-22 | Canada | British Columbia | 4915 | 202 | 3889 | 824 | 53.7267 | -127.6476 | 2020-08-23 04:27:48 | British Columbia, Canada | ||
1636080 | 1636080 | 2021-04-29 | Canada | British Columbia | 128742 | 1577 | 118937 | 8228 | 53.7267 | -127.6476 | 2021-04-30 04:21:03 | British Columbia, Canada | ||
379957 | 379957 | 2021-04-30 | Canada | British Columbia | 129482 | 1581 | 119785 | 8116 | 53.7267 | -127.6476 | 2021-05-01 04:20:47 | British Columbia, Canada | ||
2450536 | 2450536 | 2021-05-02 | Canada | British Columbia | 129482 | 1581 | 119785 | 8116 | 53.7267 | -127.6476 | 2021-05-03 04:20:39 | British Columbia, Canada | ||
2824549 | 2824549 | 2021-05-01 | Canada | British Columbia | 129482 | 1581 | 119785 | 8116 | 53.7267 | -127.6476 | 2021-05-02 04:20:48 | British Columbia, Canada | ||
1061613 | 1061613 | 2021-01-04 | Canada | British Columbia | 54201 | 946 | 45229 | 8026 | 53.7267 | -127.6476 | 2021-01-05 05:21:49 | British Columbia, Canada | ||
206022 | 206022 | 2020-08-19 | Canada | British Columbia | 4745 | 198 | 3749 | 798 | 53.7267 | -127.6476 | 2020-08-20 04:27:43 | British Columbia, Canada | ||
3484073 | 3484073 | 2020-08-20 | Canada | British Columbia | 4745 | 198 | 3749 | 798 | 53.7267 | -127.6476 | 2020-08-21 04:27:41 | British Columbia, Canada | ||
1305919 | 1305919 | 2021-07-27 | Canada | British Columbia | 149259 | 1768 | 146700 | 791 | 53.7267 | -127.6476 | 2021-07-28 04:21:39 | British Columbia, Canada | ||
3476075 | 3476075 | 2021-07-22 | Canada | British Columbia | 148730 | 1763 | 146178 | 789 | 53.7267 | -127.6476 | 2021-07-23 04:21:29 | British Columbia, Canada | ||
3177776 | 3177776 | 2020-08-18 | Canada | British Columbia | 4677 | 198 | 3704 | 775 | 53.7267 | -127.6476 | 2020-08-19 04:27:00 | British Columbia, Canada | ||
241019 | 241019 | 2021-04-02 | Canada | British Columbia | 100880 | 1463 | 91732 | 7685 | 53.7267 | -127.6476 | 2021-04-03 04:20:44 | British Columbia, Canada | ||
387987 | 387987 | 2021-04-04 | Canada | British Columbia | 100880 | 1463 | 91732 | 7685 | 53.7267 | -127.6476 | 2021-04-05 04:20:35 | British Columbia, Canada | ||
1301816 | 1301816 | 2021-04-01 | Canada | British Columbia | 100880 | 1463 | 91732 | 7685 | 53.7267 | -127.6476 | 2021-04-02 04:20:36 | British Columbia, Canada | ||
3085064 | 3085064 | 2021-04-05 | Canada | British Columbia | 100880 | 1463 | 91732 | 7685 | 53.7267 | -127.6476 | 2021-04-06 04:20:32 | British Columbia, Canada | ||
3709903 | 3709903 | 2021-04-03 | Canada | British Columbia | 100880 | 1463 | 91732 | 7685 | 53.7267 | -127.6476 | 2021-04-04 04:20:49 | British Columbia, Canada | ||
3034068 | 3034068 | 2021-01-05 | Canada | British Columbia | 54629 | 954 | 45999 | 7676 | 53.7267 | -127.6476 | 2021-01-06 05:22:16 | British Columbia, Canada | ||
2541172 | 2541172 | 2021-01-07 | Canada | British Columbia | 56015 | 970 | 47374 | 7671 | 53.7267 | -127.6476 | 2021-01-08 05:22:42 | British Columbia, Canada | ||
2864481 | 2864481 | 2021-01-06 | Canada | British Columbia | 55254 | 962 | 46728 | 7564 | 53.7267 | -127.6476 | 2021-01-07 05:22:03 | British Columbia, Canada | ||
2760683 | 2760683 | 2021-05-03 | Canada | British Columbia | 131656 | 1596 | 122518 | 7542 | 53.7267 | -127.6476 | 2021-05-04 04:20:34 | British Columbia, Canada | ||
637688 | 637688 | 2021-03-31 | Canada | British Columbia | 100048 | 1458 | 91066 | 7524 | 53.7267 | -127.6476 | 2021-04-01 04:27:05 | British Columbia, Canada | ||
1164932 | 1164932 | 2021-07-04 | Canada | British Columbia | 147705 | 1756 | 145200 | 749 | 53.7267 | -127.6476 | 2021-07-05 04:21:28 | British Columbia, Canada | ||
1495366 | 1495366 | 2021-07-03 | Canada | British Columbia | 147705 | 1756 | 145200 | 749 | 53.7267 | -127.6476 | 2021-07-04 04:21:38 | British Columbia, Canada | ||
2071681 | 2071681 | 2021-07-02 | Canada | British Columbia | 147705 | 1756 | 145200 | 749 | 53.7267 | -127.6476 | 2021-07-03 04:21:37 | British Columbia, Canada | ||
153748 | 153748 | 2021-01-08 | Canada | British Columbia | 56632 | 988 | 48205 | 7439 | 53.7267 | -127.6476 | 2021-01-09 05:22:18 | British Columbia, Canada | ||
2625637 | 2625637 | 2021-01-10 | Canada | British Columbia | 56632 | 988 | 48205 | 7439 | 53.7267 | -127.6476 | 2021-01-11 05:21:50 | British Columbia, Canada | ||
3899725 | 3899725 | 2021-01-09 | Canada | British Columbia | 56632 | 988 | 48205 | 7439 | 53.7267 | -127.6476 | 2021-01-10 05:22:12 | British Columbia, Canada | ||
3675416 | 3675416 | 2021-05-04 | Canada | British Columbia | 132353 | 1597 | 123383 | 7373 | 53.7267 | -127.6476 | 2021-05-05 04:20:43 | British Columbia, Canada | ||
678079 | 678079 | 2020-11-23 | Canada | British Columbia | 27407 | 348 | 19699 | 7360 | 53.7267 | -127.6476 | 2020-11-24 05:27:31 | British Columbia, Canada | ||
3331294 | 3331294 | 2021-07-21 | Canada | British Columbia | 148641 | 1763 | 146142 | 736 | 53.7267 | -127.6476 | 2021-07-22 04:21:19 | British Columbia, Canada | ||
3643317 | 3643317 | 2021-03-30 | Canada | British Columbia | 99035 | 1455 | 90401 | 7179 | 53.7267 | -127.6476 | 2021-03-31 04:26:25 | British Columbia, Canada | ||
2701277 | 2701277 | 2020-11-20 | Canada | British Columbia | 25474 | 331 | 18021 | 7122 | 53.7267 | -127.6476 | 2020-11-21 05:25:51 | British Columbia, Canada | ||
3189755 | 3189755 | 2020-11-22 | Canada | British Columbia | 25474 | 331 | 18021 | 7122 | 53.7267 | -127.6476 | 2020-11-23 05:25:26 | British Columbia, Canada | ||
3836249 | 3836249 | 2020-11-21 | Canada | British Columbia | 25474 | 331 | 18021 | 7122 | 53.7267 | -127.6476 | 2020-11-22 05:25:45 | 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 | ||
645716 | 645716 | 2021-05-05 | Canada | British Columbia | 132925 | 1594 | 124252 | 7079 | 53.7267 | -127.6476 | 2021-05-06 04:20:38 | British Columbia, Canada | ||
3218062 | 3218062 | 2021-07-26 | Canada | British Columbia | 149109 | 1768 | 146636 | 705 | 53.7267 | -127.6476 | 2021-07-27 04:21:18 | British Columbia, Canada | ||
1289770 | 1289770 | 2021-03-29 | Canada | British Columbia | 98195 | 1455 | 89722 | 7018 | 53.7267 | -127.6476 | 2021-03-30 04:26:23 | British Columbia, Canada | ||
2371275 | 2371275 | 2021-07-20 | Canada | British Columbia | 148563 | 1763 | 146099 | 701 | 53.7267 | -127.6476 | 2021-07-21 04:21:40 | British Columbia, Canada | ||
3113249 | 3113249 | 2021-05-06 | Canada | British Columbia | 133619 | 1595 | 125025 | 6999 | 53.7267 | -127.6476 | 2021-05-07 04:20:40 | British Columbia, Canada | ||
1424867 | 1424867 | 2021-05-09 | Canada | British Columbia | 134341 | 1602 | 125799 | 6940 | 53.7267 | -127.6476 | 2021-05-10 04:20:38 | British Columbia, Canada | ||
1551735 | 1551735 | 2021-05-08 | Canada | British Columbia | 134341 | 1602 | 125799 | 6940 | 53.7267 | -127.6476 | 2021-05-09 04:20:35 | British Columbia, Canada | ||
2501793 | 2501793 | 2021-05-07 | Canada | British Columbia | 134341 | 1602 | 125799 | 6940 | 53.7267 | -127.6476 | 2021-05-08 04:21:04 | British Columbia, Canada | ||
821337 | 821337 | 2020-11-19 | Canada | British Columbia | 24960 | 321 | 17710 | 6929 | 53.7267 | -127.6476 | 2020-11-20 05:26:28 | 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]);