⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

509 rows where country_or_region = "Canada" and province_or_state = "British Columbia" sorted by day descending

View and edit SQL

Suggested facets: latitude, longitude, day (date), last_update (date)

province_or_state

  • British Columbia · 509

country_or_region

  • Canada · 509
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
168224 2021-06-19 Canada British Columbia     146902 1740 143748 1414 53.7267 -127.6476 2021-06-20 04:21:48 British Columbia, Canada
685749 2021-06-18 Canada British Columbia     146902 1740 143748 1414 53.7267 -127.6476 2021-06-19 04:22:33 British Columbia, Canada
957806 2021-06-17 Canada British Columbia     146794 1739 143579 1476 53.7267 -127.6476 2021-06-18 04:22:16 British Columbia, Canada
1281173 2021-06-16 Canada British Columbia     146674 1738 143449 1487 53.7267 -127.6476 2021-06-17 04:22:36 British Columbia, Canada
681763 2021-06-15 Canada British Columbia     146561 1734 143299 1528 53.7267 -127.6476 2021-06-16 04:22:32 British Columbia, Canada
372317 2021-06-14 Canada British Columbia     146453 1734 143147 1572 53.7267 -127.6476 2021-06-15 04:22:22 British Columbia, Canada
1223133 2021-06-13 Canada British Columbia     146176 1730 142526 1920 53.7267 -127.6476 2021-06-14 04:22:46 British Columbia, Canada
80414 2021-06-12 Canada British Columbia     146176 1730 142526 1920 53.7267 -127.6476 2021-06-13 04:22:44 British Columbia, Canada
969717 2021-06-11 Canada British Columbia     146176 1730 142526 1920 53.7267 -127.6476 2021-06-12 04:22:22 British Columbia, Canada
1438290 2021-06-10 Canada British Columbia     145996 1729 142314 1953 53.7267 -127.6476 2021-06-11 04:23:20 British Columbia, Canada
1156789 2021-06-09 Canada British Columbia     145843 1725 142106 2012 53.7267 -127.6476 2021-06-10 04:23:17 British Columbia, Canada
1231105 2021-06-08 Canada British Columbia     145695 1722 141879 2094 53.7267 -127.6476 2021-06-09 04:23:31 British Columbia, Canada
360101 2021-06-07 Canada British Columbia     145530 1722 141663 2145 53.7267 -127.6476 2021-06-08 04:22:35 British Columbia, Canada
1075729 2021-06-06 Canada British Columbia     145049 1710 140835 2504 53.7267 -127.6476 2021-06-07 04:22:51 British Columbia, Canada
1613121 2021-06-05 Canada British Columbia     145049 1710 140835 2504 53.7267 -127.6476 2021-06-06 04:24:03 British Columbia, Canada
1125407 2021-06-04 Canada British Columbia     145049 1710 140835 2504 53.7267 -127.6476 2021-06-05 04:23:03 British Columbia, Canada
317863 2021-06-03 Canada British Columbia     144866 1709 140537 2620 53.7267 -127.6476 2021-06-04 04:23:37 British Columbia, Canada
1133376 2021-06-02 Canada British Columbia     144667 1707 140238 2722 53.7267 -127.6476 2021-06-03 04:23:32 British Columbia, Canada
291553 2021-06-01 Canada British Columbia     144473 1703 139899 2871 53.7267 -127.6476 2021-06-02 04:24:34 British Columbia, Canada
1651504 2021-05-31 Canada British Columbia     144289 1703 139562 3024 53.7267 -127.6476 2021-06-01 04:23:09 British Columbia, Canada
980732 2021-05-30 Canada British Columbia     143581 1692 138360 3529 53.7267 -127.6476 2021-05-31 03:08:59 British Columbia, Canada
841113 2021-05-29 Canada British Columbia     143581 1692 138360 3529 53.7267 -127.6476 2021-05-30 04:20:55 British Columbia, Canada
697685 2021-05-28 Canada British Columbia     143581 1692 138360 3529 53.7267 -127.6476 2021-05-29 04:20:41 British Columbia, Canada
1369186 2021-05-27 Canada British Columbia     143264 1690 137929 3645 53.7267 -127.6476 2021-05-28 04:20:36 British Columbia, Canada
1292271 2021-05-26 Canada British Columbia     142886 1683 137517 3686 53.7267 -127.6476 2021-05-27 04:20:59 British Columbia, Canada
602642 2021-05-25 Canada British Columbia     142636 1680 137062 3894 53.7267 -127.6476 2021-05-26 04:20:35 British Columbia, Canada
1365200 2021-05-24 Canada British Columbia     141373 1667 135068 4638 53.7267 -127.6476 2021-05-25 04:21:08 British Columbia, Canada
419713 2021-05-23 Canada British Columbia     141373 1667 135068 4638 53.7267 -127.6476 2021-05-24 04:20:53 British Columbia, Canada
54052 2021-05-22 Canada British Columbia     141373 1667 135068 4638 53.7267 -127.6476 2021-05-23 04:20:51 British Columbia, Canada
368331 2021-05-21 Canada British Columbia     141373 1667 135068 4638 53.7267 -127.6476 2021-05-22 04:20:45 British Columbia, Canada
1024130 2021-05-20 Canada British Columbia     140953 1661 134521 4771 53.7267 -127.6476 2021-05-21 04:20:43 British Columbia, Canada
1678756 2021-05-19 Canada British Columbia     140596 1658 133985 4953 53.7267 -127.6476 2021-05-20 04:21:05 British Columbia, Canada
64743 2021-05-18 Canada British Columbia     140075 1650 133383 5042 53.7267 -127.6476 2021-05-19 04:20:42 British Columbia, Canada
1242815 2021-05-17 Canada British Columbia     139664 1648 132841 5175 53.7267 -127.6476 2021-05-18 04:20:33 British Columbia, Canada
1067663 2021-05-16 Canada British Columbia     138304 1634 130953 5717 53.7267 -127.6476 2021-05-17 04:20:34 British Columbia, Canada
504791 2021-05-15 Canada British Columbia     138304 1634 130953 5717 53.7267 -127.6476 2021-05-16 04:20:49 British Columbia, Canada
892396 2021-05-14 Canada British Columbia     138304 1634 130953 5717 53.7267 -127.6476 2021-05-15 04:20:58 British Columbia, Canada
531731 2021-05-13 Canada British Columbia     137810 1632 130310 5868 53.7267 -127.6476 2021-05-14 04:20:41 British Columbia, Canada
1719018 2021-05-12 Canada British Columbia     137223 1627 129524 6072 53.7267 -127.6476 2021-05-13 04:20:51 British Columbia, Canada
1723004 2021-05-11 Canada British Columbia     136623 1624 128782 6217 53.7267 -127.6476 2021-05-12 04:21:29 British Columbia, Canada
1164761 2021-05-10 Canada British Columbia     136108 1622 128139 6347 53.7267 -127.6476 2021-05-11 04:20:41 British Columbia, Canada
1168747 2021-05-09 Canada British Columbia     134341 1602 125799 6940 53.7267 -127.6476 2021-05-10 04:20:38 British Columbia, Canada
1659534 2021-05-08 Canada British Columbia     134341 1602 125799 6940 53.7267 -127.6476 2021-05-09 04:20:35 British Columbia, Canada
799632 2021-05-07 Canada British Columbia     134341 1602 125799 6940 53.7267 -127.6476 2021-05-08 04:21:04 British Columbia, Canada
1219147 2021-05-06 Canada British Columbia     133619 1595 125025 6999 53.7267 -127.6476 2021-05-07 04:20:40 British Columbia, Canada
415727 2021-05-05 Canada British Columbia     132925 1594 124252 7079 53.7267 -127.6476 2021-05-06 04:20:38 British Columbia, Canada
673748 2021-05-04 Canada British Columbia     132353 1597 123383 7373 53.7267 -127.6476 2021-05-05 04:20:43 British Columbia, Canada
1087772 2021-05-03 Canada British Columbia     131656 1596 122518 7542 53.7267 -127.6476 2021-05-04 04:20:34 British Columbia, Canada
1726990 2021-05-02 Canada British Columbia     129482 1581 119785 8116 53.7267 -127.6476 2021-05-03 04:20:39 British Columbia, Canada
1083786 2021-05-01 Canada British Columbia     129482 1581 119785 8116 53.7267 -127.6476 2021-05-02 04:20:48 British Columbia, Canada
1388314 2021-04-30 Canada British Columbia     129482 1581 119785 8116 53.7267 -127.6476 2021-05-01 04:20:47 British Columbia, Canada
38133 2021-04-29 Canada British Columbia     128742 1577 118937 8228 53.7267 -127.6476 2021-04-30 04:21:03 British Columbia, Canada
11706 2021-04-28 Canada British Columbia     127889 1576 118057 8256 53.7267 -127.6476 2021-04-29 04:20:55 British Columbia, Canada
853089 2021-04-27 Canada British Columbia     127048 1571 117150 8327 53.7267 -127.6476 2021-04-28 04:20:32 British Columbia, Canada
1063677 2021-04-26 Canada British Columbia     126249 1571 116241 8437 53.7267 -127.6476 2021-04-27 04:20:52 British Columbia, Canada
1475927 2021-04-25 Canada British Columbia     123758 1554 113139 9065 53.7267 -127.6476 2021-04-26 04:21:04 British Columbia, Canada
743548 2021-04-24 Canada British Columbia     123758 1554 113139 9065 53.7267 -127.6476 2021-04-25 04:20:32 British Columbia, Canada
1430347 2021-04-23 Canada British Columbia     123758 1554 113139 9065 53.7267 -127.6476 2021-04-24 04:20:38 British Columbia, Canada
96176 2021-04-22 Canada British Columbia     122757 1550 112235 8972 53.7267 -127.6476 2021-04-23 04:20:52 British Columbia, Canada
849103 2021-04-21 Canada British Columbia     121751 1546 111039 9166 53.7267 -127.6476 2021-04-22 04:20:53 British Columbia, Canada
826721 2021-04-20 Canada British Columbia     120889 1539 109973 9377 53.7267 -127.6476 2021-04-21 04:21:14 British Columbia, Canada
770432 2021-04-19 Canada British Columbia     120040 1538 108919 9583 53.7267 -127.6476 2021-04-20 04:20:41 British Columbia, Canada
1415741 2021-04-18 Canada British Columbia     117080 1530 105291 10259 53.7267 -127.6476 2021-04-19 04:20:57 British Columbia, Canada
984718 2021-04-17 Canada British Columbia     117080 1530 105291 10259 53.7267 -127.6476 2021-04-18 04:20:41 British Columbia, Canada
237781 2021-04-16 Canada British Columbia     117080 1530 105291 10259 53.7267 -127.6476 2021-04-17 04:20:40 British Columbia, Canada
579510 2021-04-15 Canada British Columbia     116075 1524 104331 10220 53.7267 -127.6476 2021-04-16 04:20:46 British Columbia, Canada
1266138 2021-04-14 Canada British Columbia     114870 1521 103360 9989 53.7267 -127.6476 2021-04-15 04:20:54 British Columbia, Canada
701671 2021-04-13 Canada British Columbia     113702 1515 102268 9919 53.7267 -127.6476 2021-04-14 04:20:41 British Columbia, Canada
1670784 2021-04-12 Canada British Columbia     112829 1513 101216 10100 53.7267 -127.6476 2021-04-13 04:20:37 British Columbia, Canada
784489 2021-04-11 Canada British Columbia     109540 1495 98336 9709 53.7267 -127.6476 2021-04-12 04:21:00 British Columbia, Canada
1392300 2021-04-10 Canada British Columbia     109540 1495 98336 9709 53.7267 -127.6476 2021-04-11 04:20:56 British Columbia, Canada
965731 2021-04-09 Canada British Columbia     109540 1495 98336 9709 53.7267 -127.6476 2021-04-10 04:20:59 British Columbia, Canada
689735 2021-04-08 Canada British Columbia     108278 1493 97462 9323 53.7267 -127.6476 2021-04-09 04:21:13 British Columbia, Canada
1277187 2021-04-07 Canada British Columbia     106985 1491 96626 8868 53.7267 -127.6476 2021-04-08 04:21:13 British Columbia, Canada
88206 2021-04-06 Canada British Columbia     105988 1489 95691 8808 53.7267 -127.6476 2021-04-07 04:20:53 British Columbia, Canada
122588 2021-04-05 Canada British Columbia     100880 1463 91732 7685 53.7267 -127.6476 2021-04-06 04:20:32 British Columbia, Canada
73090 2021-04-04 Canada British Columbia     100880 1463 91732 7685 53.7267 -127.6476 2021-04-05 04:20:35 British Columbia, Canada
791706 2021-04-03 Canada British Columbia     100880 1463 91732 7685 53.7267 -127.6476 2021-04-04 04:20:49 British Columbia, Canada
1020144 2021-04-02 Canada British Columbia     100880 1463 91732 7685 53.7267 -127.6476 2021-04-03 04:20:44 British Columbia, Canada
1350306 2021-04-01 Canada British Columbia     100880 1463 91732 7685 53.7267 -127.6476 2021-04-02 04:20:36 British Columbia, Canada
1690692 2021-03-31 Canada British Columbia     100048 1458 91066 7524 53.7267 -127.6476 2021-04-01 04:27:05 British Columbia, Canada
873061 2021-03-30 Canada British Columbia     99035 1455 90401 7179 53.7267 -127.6476 2021-03-31 04:26:25 British Columbia, Canada
1400108 2021-03-29 Canada British Columbia     98195 1455 89722 7018 53.7267 -127.6476 2021-03-30 04:26:23 British Columbia, Canada
1624511 2021-03-28 Canada British Columbia     95677 1449 87866 6362 53.7267 -127.6476 2021-03-29 04:28:35 British Columbia, Canada
1471941 2021-03-27 Canada British Columbia     95677 1449 87866 6362 53.7267 -127.6476 2021-03-28 05:28:10 British Columbia, Canada
720488 2021-03-26 Canada British Columbia     95677 1449 87866 6362 53.7267 -127.6476 2021-03-27 05:25:04 British Columbia, Canada
1617107 2021-03-25 Canada British Columbia     94769 1446 87351 5972 53.7267 -127.6476 2021-03-26 05:26:55 British Columbia, Canada
469768 2021-03-24 Canada British Columbia     93969 1441 86857 5671 53.7267 -127.6476 2021-03-25 05:27:00 British Columbia, Canada
1584808 2021-03-23 Canada British Columbia     93253 1438 86307 5508 53.7267 -127.6476 2021-03-24 05:25:40 British Columbia, Canada
716502 2021-03-22 Canada British Columbia     92571 1437 85746 5388 53.7267 -127.6476 2021-03-23 05:26:18 British Columbia, Canada
1674770 2021-03-21 Canada British Columbia     90786 1421 84078 5287 53.7267 -127.6476 2021-03-22 05:25:43 British Columbia, Canada
1746709 2021-03-20 Canada British Columbia     90786 1421 84078 5287 53.7267 -127.6476 2021-03-21 05:25:44 British Columbia, Canada
229831 2021-03-19 Canada British Columbia     90786 1421 84078 5287 53.7267 -127.6476 2021-03-20 05:25:46 British Columbia, Canada
477766 2021-03-18 Canada British Columbia     90049 1419 83613 5017 53.7267 -127.6476 2021-03-19 05:26:09 British Columbia, Canada
1426361 2021-03-17 Canada British Columbia     89427 1411 83083 4933 53.7267 -127.6476 2021-03-18 05:26:22 British Columbia, Canada
1592949 2021-03-16 Canada British Columbia     88929 1407 82436 5086 53.7267 -127.6476 2021-03-17 05:25:07 British Columbia, Canada
1175948 2021-03-15 Canada British Columbia     88373 1407 81890 5076 53.7267 -127.6476 2021-03-16 05:25:13 British Columbia, Canada
275633 2021-03-14 Canada British Columbia     86867 1397 80325 5145 53.7267 -127.6476 2021-03-15 05:25:51 British Columbia, Canada
1160775 2021-03-13 Canada British Columbia     86867 1397 80325 5145 53.7267 -127.6476 2021-03-14 05:25:37 British Columbia, Canada
22282 2021-03-12 Canada British Columbia     86867 1397 80325 5145 53.7267 -127.6476 2021-03-13 05:25:15 British Columbia, Canada

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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] INTEGER,
   [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]);