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 day descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2462556 | 2462556 | 2021-09-14 | Canada | British Columbia | 175819 | 1866 | 0 | 53.7267 | -127.6476 | 2021-09-15 03:22:37 | British Columbia, Canada | |||
1385395 | 1385395 | 2021-09-13 | Canada | British Columbia | 175142 | 1865 | 0 | 53.7267 | -127.6476 | 2021-09-14 04:21:41 | British Columbia, Canada | |||
1884764 | 1884764 | 2021-09-12 | Canada | British Columbia | 173158 | 1856 | 0 | 53.7267 | -127.6476 | 2021-09-13 04:21:15 | British Columbia, Canada | |||
3805667 | 3805667 | 2021-09-11 | Canada | British Columbia | 173158 | 1856 | 0 | 53.7267 | -127.6476 | 2021-09-12 04:21:13 | British Columbia, Canada | |||
3448607 | 3448607 | 2021-09-10 | Canada | British Columbia | 173158 | 1856 | 0 | 53.7267 | -127.6476 | 2021-09-11 04:21:30 | British Columbia, Canada | |||
1262553 | 1262553 | 2021-09-09 | Canada | British Columbia | 172338 | 1847 | 0 | 53.7267 | -127.6476 | 2021-09-10 04:21:20 | British Columbia, Canada | |||
2278923 | 2278923 | 2021-09-08 | Canada | British Columbia | 171564 | 1842 | 0 | 53.7267 | -127.6476 | 2021-09-09 04:21:27 | British Columbia, Canada | |||
641702 | 641702 | 2021-09-07 | Canada | British Columbia | 170750 | 1842 | 0 | 53.7267 | -127.6476 | 2021-09-08 04:21:31 | British Columbia, Canada | |||
3193765 | 3193765 | 2021-09-06 | Canada | British Columbia | 168325 | 1827 | 0 | 53.7267 | -127.6476 | 2021-09-07 04:21:35 | British Columbia, Canada | |||
3280633 | 3280633 | 2021-09-05 | Canada | British Columbia | 168325 | 1827 | 0 | 53.7267 | -127.6476 | 2021-09-06 04:21:22 | British Columbia, Canada | |||
249047 | 249047 | 2021-09-04 | Canada | British Columbia | 168325 | 1827 | 0 | 53.7267 | -127.6476 | 2021-09-05 04:21:33 | British Columbia, Canada | |||
3974328 | 3974328 | 2021-09-03 | Canada | British Columbia | 168325 | 1827 | 0 | 53.7267 | -127.6476 | 2021-09-04 04:21:28 | British Columbia, Canada | |||
177790 | 177790 | 2021-09-02 | Canada | British Columbia | 167654 | 1824 | 0 | 53.7267 | -127.6476 | 2021-09-03 04:21:20 | British Columbia, Canada | |||
66825 | 66825 | 2021-09-01 | Canada | British Columbia | 166853 | 1818 | 0 | 53.7267 | -127.6476 | 2021-09-02 04:21:15 | British Columbia, Canada | |||
2067667 | 2067667 | 2021-08-31 | Canada | British Columbia | 166068 | 1816 | 0 | 53.7267 | -127.6476 | 2021-09-01 04:21:38 | British Columbia, Canada | |||
1775121 | 1775121 | 2021-08-30 | Canada | British Columbia | 165413 | 1814 | 0 | 53.7267 | -127.6476 | 2021-08-31 04:21:46 | British Columbia, Canada | |||
3891695 | 3891695 | 2021-08-29 | Canada | British Columbia | 163560 | 1807 | 0 | 53.7267 | -127.6476 | 2021-08-30 04:21:23 | British Columbia, Canada | |||
2792798 | 2792798 | 2021-08-28 | Canada | British Columbia | 163560 | 1807 | 0 | 53.7267 | -127.6476 | 2021-08-29 04:21:14 | British Columbia, Canada | |||
2922957 | 2922957 | 2021-08-27 | Canada | British Columbia | 163560 | 1807 | 0 | 53.7267 | -127.6476 | 2021-08-28 04:21:28 | British Columbia, Canada | |||
1595971 | 1595971 | 2021-08-26 | Canada | British Columbia | 162693 | 1804 | 0 | 53.7267 | -127.6476 | 2021-08-27 04:21:37 | British Columbia, Canada | |||
32180 | 32180 | 2021-08-25 | Canada | British Columbia | 161969 | 1802 | 0 | 53.7267 | -127.6476 | 2021-08-26 04:21:28 | British Columbia, Canada | |||
3105219 | 3105219 | 2021-08-24 | Canada | British Columbia | 161271 | 1801 | 0 | 53.7267 | -127.6476 | 2021-08-25 04:21:41 | British Columbia, Canada | |||
3165390 | 3165390 | 2021-08-23 | Canada | British Columbia | 160630 | 1801 | 0 | 53.7267 | -127.6476 | 2021-08-24 04:21:19 | British Columbia, Canada | |||
2175317 | 2175317 | 2021-08-22 | Canada | British Columbia | 158919 | 1785 | 0 | 53.7267 | -127.6476 | 2021-08-23 04:21:27 | British Columbia, Canada | |||
3555413 | 3555413 | 2021-08-21 | Canada | British Columbia | 158919 | 1785 | 0 | 53.7267 | -127.6476 | 2021-08-22 04:21:29 | British Columbia, Canada | |||
1853755 | 1853755 | 2021-08-20 | Canada | British Columbia | 158919 | 1785 | 0 | 53.7267 | -127.6476 | 2021-08-21 04:21:38 | British Columbia, Canada | |||
511462 | 511462 | 2021-08-19 | Canada | British Columbia | 158256 | 1784 | 0 | 53.7267 | -127.6476 | 2021-08-20 04:21:33 | British Columbia, Canada | |||
2517941 | 2517941 | 2021-08-18 | Canada | British Columbia | 157567 | 1782 | 0 | 53.7267 | -127.6476 | 2021-08-19 04:21:15 | British Columbia, Canada | |||
245033 | 245033 | 2021-08-17 | Canada | British Columbia | 157014 | 1781 | 0 | 53.7267 | -127.6476 | 2021-08-18 04:21:35 | British Columbia, Canada | |||
1603996 | 1603996 | 2021-08-16 | Canada | British Columbia | 156513 | 1780 | 0 | 53.7267 | -127.6476 | 2021-08-17 04:21:49 | British Columbia, Canada | |||
103090 | 103090 | 2021-08-15 | Canada | British Columbia | 155079 | 1779 | 0 | 53.7267 | -127.6476 | 2021-08-16 04:21:31 | British Columbia, Canada | |||
507448 | 507448 | 2021-08-14 | Canada | British Columbia | 155079 | 1779 | 0 | 53.7267 | -127.6476 | 2021-08-15 04:21:41 | British Columbia, Canada | |||
1483320 | 1483320 | 2021-08-13 | Canada | British Columbia | 155079 | 1779 | 0 | 53.7267 | -127.6476 | 2021-08-14 04:21:25 | British Columbia, Canada | |||
2899450 | 2899450 | 2021-08-12 | Canada | British Columbia | 154362 | 1779 | 0 | 53.7267 | -127.6476 | 2021-08-13 04:21:24 | British Columbia, Canada | |||
1342054 | 1342054 | 2021-08-11 | Canada | British Columbia | 153849 | 1778 | 0 | 53.7267 | -127.6476 | 2021-08-12 04:21:25 | British Columbia, Canada | |||
2351201 | 2351201 | 2021-08-10 | Canada | British Columbia | 153313 | 1777 | 0 | 53.7267 | -127.6476 | 2021-08-11 04:21:58 | British Columbia, Canada | |||
649730 | 649730 | 2021-08-09 | Canada | British Columbia | 152918 | 1777 | 0 | 53.7267 | -127.6476 | 2021-08-10 04:21:27 | British Columbia, Canada | |||
589392 | 589392 | 2021-08-08 | Canada | British Columbia | 151839 | 1772 | 0 | 53.7267 | -127.6476 | 2021-08-09 04:21:24 | British Columbia, Canada | |||
2203404 | 2203404 | 2021-08-07 | Canada | British Columbia | 151839 | 1772 | 0 | 53.7267 | -127.6476 | 2021-08-08 04:21:33 | British Columbia, Canada | |||
1117354 | 1117354 | 2021-08-06 | Canada | British Columbia | 151839 | 1772 | 0 | 53.7267 | -127.6476 | 2021-08-07 04:21:30 | British Columbia, Canada | |||
1956291 | 1956291 | 2021-08-05 | Canada | British Columbia | 151375 | 1772 | 0 | 53.7267 | -127.6476 | 2021-08-06 04:21:18 | British Columbia, Canada | |||
331670 | 331670 | 2021-08-04 | Canada | British Columbia | 150973 | 1772 | 147409 | 1792 | 53.7267 | -127.6476 | 2021-08-05 04:21:51 | British Columbia, Canada | ||
3467941 | 3467941 | 2021-08-03 | Canada | British Columbia | 150631 | 1772 | 147285 | 1574 | 53.7267 | -127.6476 | 2021-08-04 04:21:25 | British Columbia, Canada | ||
3683215 | 3683215 | 2021-08-02 | Canada | British Columbia | 149889 | 1771 | 146876 | 1242 | 53.7267 | -127.6476 | 2021-08-03 04:21:39 | British Columbia, Canada | ||
3015114 | 3015114 | 2021-08-01 | Canada | British Columbia | 149889 | 1771 | 146876 | 1242 | 53.7267 | -127.6476 | 2021-08-02 04:21:36 | British Columbia, Canada | ||
3903737 | 3903737 | 2021-07-31 | Canada | British Columbia | 149889 | 1771 | 146876 | 1242 | 53.7267 | -127.6476 | 2021-08-01 04:21:50 | British Columbia, Canada | ||
3295942 | 3295942 | 2021-07-30 | Canada | British Columbia | 149889 | 1771 | 146876 | 1242 | 53.7267 | -127.6476 | 2021-07-31 04:21:35 | British Columbia, Canada | ||
3385153 | 3385153 | 2021-07-29 | Canada | British Columbia | 149646 | 1771 | 146810 | 1065 | 53.7267 | -127.6476 | 2021-07-30 04:21:34 | 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 | ||
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 | ||
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 | ||
1378271 | 1378271 | 2021-07-25 | Canada | British Columbia | 148842 | 1767 | 146463 | 612 | 53.7267 | -127.6476 | 2021-07-26 04:21:28 | British Columbia, Canada | ||
1330011 | 1330011 | 2021-07-24 | Canada | British Columbia | 148842 | 1767 | 146463 | 612 | 53.7267 | -127.6476 | 2021-07-25 04:22:12 | British Columbia, Canada | ||
3137315 | 3137315 | 2021-07-23 | Canada | British Columbia | 148842 | 1767 | 146463 | 612 | 53.7267 | -127.6476 | 2021-07-24 00:21:36 | 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 | ||
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 | ||
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 | ||
483354 | 483354 | 2021-07-19 | Canada | British Columbia | 148487 | 1763 | 146062 | 662 | 53.7267 | -127.6476 | 2021-07-20 04:21:48 | British Columbia, Canada | ||
2673577 | 2673577 | 2021-07-18 | Canada | British Columbia | 148331 | 1761 | 145908 | 662 | 53.7267 | -127.6476 | 2021-07-19 04:21:24 | British Columbia, Canada | ||
3705889 | 3705889 | 2021-07-17 | Canada | British Columbia | 148331 | 1761 | 145908 | 662 | 53.7267 | -127.6476 | 2021-07-18 04:22:07 | British Columbia, Canada | ||
2947120 | 2947120 | 2021-07-16 | Canada | British Columbia | 148331 | 1761 | 145908 | 662 | 53.7267 | -127.6476 | 2021-07-17 04:22:22 | British Columbia, Canada | ||
295776 | 295776 | 2021-07-15 | Canada | British Columbia | 148286 | 1761 | 145859 | 666 | 53.7267 | -127.6476 | 2021-07-16 04:21:22 | British Columbia, Canada | ||
3631721 | 3631721 | 2021-07-14 | Canada | British Columbia | 148228 | 1760 | 145817 | 651 | 53.7267 | -127.6476 | 2021-07-15 04:21:48 | British Columbia, Canada | ||
578596 | 578596 | 2021-07-13 | Canada | British Columbia | 148187 | 1760 | 145775 | 652 | 53.7267 | -127.6476 | 2021-07-14 04:21:35 | British Columbia, Canada | ||
3740845 | 3740845 | 2021-07-12 | Canada | British Columbia | 148154 | 1760 | 145722 | 672 | 53.7267 | -127.6476 | 2021-07-13 04:21:18 | British Columbia, Canada | ||
3659358 | 3659358 | 2021-07-11 | Canada | British Columbia | 148031 | 1760 | 145594 | 677 | 53.7267 | -127.6476 | 2021-07-12 04:21:34 | British Columbia, Canada | ||
625642 | 625642 | 2021-07-10 | Canada | British Columbia | 148031 | 1760 | 145594 | 677 | 53.7267 | -127.6476 | 2021-07-11 04:21:43 | British Columbia, Canada | ||
829361 | 829361 | 2021-07-09 | Canada | British Columbia | 148031 | 1760 | 145594 | 677 | 53.7267 | -127.6476 | 2021-07-10 04:21:25 | British Columbia, Canada | ||
778125 | 778125 | 2021-07-08 | Canada | British Columbia | 147919 | 1760 | 145491 | 668 | 53.7267 | -127.6476 | 2021-07-09 04:21:21 | British Columbia, Canada | ||
1440347 | 1440347 | 2021-07-07 | Canada | British Columbia | 147856 | 1759 | 145455 | 642 | 53.7267 | -127.6476 | 2021-07-08 04:21:26 | British Columbia, Canada | ||
2693452 | 2693452 | 2021-07-06 | Canada | British Columbia | 147797 | 1759 | 145420 | 618 | 53.7267 | -127.6476 | 2021-07-07 04:21:20 | British Columbia, Canada | ||
1932201 | 1932201 | 2021-07-05 | Canada | British Columbia | 147790 | 1759 | 145362 | 669 | 53.7267 | -127.6476 | 2021-07-06 04:21:32 | 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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
2589766 | 2589766 | 2021-06-27 | Canada | British Columbia | 147418 | 1749 | 144554 | 1115 | 53.7267 | -127.6476 | 2021-06-28 04:21:29 | British Columbia, Canada | ||
3958270 | 3958270 | 2021-06-26 | Canada | British Columbia | 147418 | 1749 | 144554 | 1115 | 53.7267 | -127.6476 | 2021-06-27 04:21:39 | British Columbia, Canada | ||
1712089 | 1712089 | 2021-06-25 | Canada | British Columbia | 147418 | 1749 | 144554 | 1115 | 53.7267 | -127.6476 | 2021-06-26 04:21:43 | British Columbia, Canada | ||
2295214 | 2295214 | 2021-06-24 | Canada | British Columbia | 147346 | 1747 | 144466 | 1133 | 53.7267 | -127.6476 | 2021-06-25 04:21:33 | British Columbia, Canada | ||
2422654 | 2422654 | 2021-06-23 | Canada | British Columbia | 147271 | 1744 | 144383 | 1144 | 53.7267 | -127.6476 | 2021-06-24 04:21:55 | British Columbia, Canada | ||
562731 | 562731 | 2021-06-22 | Canada | British Columbia | 147187 | 1743 | 144263 | 1181 | 53.7267 | -127.6476 | 2021-06-23 04:21:46 | British Columbia, Canada | ||
3358433 | 3358433 | 2021-06-21 | Canada | British Columbia | 147131 | 1743 | 144153 | 1235 | 53.7267 | -127.6476 | 2021-06-22 04:21:34 | British Columbia, Canada | ||
2884132 | 2884132 | 2021-06-20 | Canada | British Columbia | 146902 | 1740 | 143748 | 1414 | 53.7267 | -127.6476 | 2021-06-21 04:21:41 | British Columbia, Canada | ||
107215 | 107215 | 2021-06-19 | Canada | British Columbia | 146902 | 1740 | 143748 | 1414 | 53.7267 | -127.6476 | 2021-06-20 04:21:48 | British Columbia, Canada | ||
1125358 | 1125358 | 2021-06-18 | Canada | British Columbia | 146902 | 1740 | 143748 | 1414 | 53.7267 | -127.6476 | 2021-06-19 04:22:33 | British Columbia, Canada | ||
2910936 | 2910936 | 2021-06-17 | Canada | British Columbia | 146794 | 1739 | 143579 | 1476 | 53.7267 | -127.6476 | 2021-06-18 04:22:16 | British Columbia, Canada | ||
3030054 | 3030054 | 2021-06-16 | Canada | British Columbia | 146674 | 1738 | 143449 | 1487 | 53.7267 | -127.6476 | 2021-06-17 04:22:36 | British Columbia, Canada | ||
2339160 | 2339160 | 2021-06-15 | Canada | British Columbia | 146561 | 1734 | 143299 | 1528 | 53.7267 | -127.6476 | 2021-06-16 04:22:32 | British Columbia, Canada | ||
1563856 | 1563856 | 2021-06-14 | Canada | British Columbia | 146453 | 1734 | 143147 | 1572 | 53.7267 | -127.6476 | 2021-06-15 04:22:22 | British Columbia, Canada | ||
3381139 | 3381139 | 2021-06-13 | Canada | British Columbia | 146176 | 1730 | 142526 | 1920 | 53.7267 | -127.6476 | 2021-06-14 04:22:46 | British Columbia, Canada | ||
1736273 | 1736273 | 2021-06-12 | Canada | British Columbia | 146176 | 1730 | 142526 | 1920 | 53.7267 | -127.6476 | 2021-06-13 04:22:44 | British Columbia, Canada | ||
3970314 | 3970314 | 2021-06-11 | Canada | British Columbia | 146176 | 1730 | 142526 | 1920 | 53.7267 | -127.6476 | 2021-06-12 04:22:22 | British Columbia, Canada | ||
2716736 | 2716736 | 2021-06-10 | Canada | British Columbia | 145996 | 1729 | 142314 | 1953 | 53.7267 | -127.6476 | 2021-06-11 04:23:20 | British Columbia, Canada | ||
522621 | 522621 | 2021-06-09 | Canada | British Columbia | 145843 | 1725 | 142106 | 2012 | 53.7267 | -127.6476 | 2021-06-10 04:23:17 | British Columbia, Canada | ||
3472061 | 3472061 | 2021-06-08 | Canada | British Columbia | 145695 | 1722 | 141879 | 2094 | 53.7267 | -127.6476 | 2021-06-09 04:23:31 | British Columbia, Canada | ||
3145345 | 3145345 | 2021-06-07 | Canada | British Columbia | 145530 | 1722 | 141663 | 2145 | 53.7267 | -127.6476 | 2021-06-08 04:22:35 | 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]);