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 last_update
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: latitude, last_update (date)
day (date) >30 ✖
- 2020-01-28 1
- 2020-01-29 1
- 2020-01-30 1
- 2020-01-31 1
- 2020-02-01 1
- 2020-02-02 1
- 2020-02-03 1
- 2020-02-04 1
- 2020-02-05 1
- 2020-02-06 1
- 2020-02-07 1
- 2020-02-08 1
- 2020-02-09 1
- 2020-02-10 1
- 2020-02-11 1
- 2020-02-12 1
- 2020-02-13 1
- 2020-02-14 1
- 2020-02-15 1
- 2020-02-16 1
- 2020-02-17 1
- 2020-02-18 1
- 2020-02-19 1
- 2020-02-20 1
- 2020-02-21 1
- 2020-02-22 1
- 2020-02-23 1
- 2020-02-24 1
- 2020-02-25 1
- 2020-02-26 1
- …
province_or_state 1
- British Columbia · 1,067 ✖
country_or_region 1
- Canada · 1,067 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update ▼ | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1305798 | 1305798 | 2020-01-28 | Canada | British Columbia | 1 | 0 | 0 | 53.7267 | -127.6476 | 1/28/20 23:00 | ||||
197883 | 197883 | 2020-01-29 | Canada | British Columbia | 1 | 0 | 0 | 53.7267 | -127.6476 | 1/29/20 19:30 | ||||
1527536 | 1527536 | 2020-01-30 | Canada | British Columbia | 1 | 0 | 0 | 53.7267 | -127.6476 | 1/30/20 16:00 | ||||
3761229 | 3761229 | 2020-01-31 | Canada | British Columbia | 1 | 0 | 0 | 53.7267 | -127.6476 | 1/31/2020 23:59 | ||||
3413191 | 3413191 | 2020-02-01 | Canada | British Columbia | 1 | 0 | 0 | 53.7267 | -127.6476 | 2/1/2020 18:12 | ||||
2379281 | 2379281 | 2020-02-02 | Canada | British Columbia | 1 | 0 | 0 | 53.7267 | -127.6476 | 2020-02-01T18:12:49 | ||||
2860597 | 2860597 | 2020-02-03 | Canada | British Columbia | 1 | 0 | 0 | 53.7267 | -127.6476 | 2020-02-01T18:12:49 | ||||
3471934 | 3471934 | 2020-02-04 | Canada | British Columbia | 1 | 0 | 0 | 53.7267 | -127.6476 | 2020-02-01T18:12:49 | ||||
566714 | 566714 | 2020-02-06 | Canada | British Columbia | 2 | 0 | 0 | 53.7267 | -127.6476 | 2020-02-05T17:33:03 | ||||
2091707 | 2091707 | 2020-02-05 | Canada | British Columbia | 2 | 0 | 0 | 53.7267 | -127.6476 | 2020-02-05T17:33:03 | ||||
107073 | 107073 | 2020-02-15 | Canada | British Columbia | 4 | 0 | 0 | 53.7267 | -127.6476 | 2020-02-07T05:43:03 | ||||
1192492 | 1192492 | 2020-02-14 | Canada | British Columbia | 4 | 0 | 0 | 53.7267 | -127.6476 | 2020-02-07T05:43:03 | ||||
1366085 | 1366085 | 2020-02-08 | Canada | British Columbia | 4 | 0 | 0 | 53.7267 | -127.6476 | 2020-02-07T05:43:03 | ||||
1559699 | 1559699 | 2020-02-13 | Canada | British Columbia | 4 | 0 | 0 | 53.7267 | -127.6476 | 2020-02-07T05:43:03 | ||||
1888747 | 1888747 | 2020-02-16 | Canada | British Columbia | 4 | 0 | 0 | 53.7267 | -127.6476 | 2020-02-07T05:43:03 | ||||
2567289 | 2567289 | 2020-02-12 | Canada | British Columbia | 4 | 0 | 0 | 53.7267 | -127.6476 | 2020-02-07T05:43:03 | ||||
3089047 | 3089047 | 2020-02-10 | Canada | British Columbia | 4 | 0 | 0 | 53.7267 | -127.6476 | 2020-02-07T05:43:03 | ||||
3197748 | 3197748 | 2020-02-11 | Canada | British Columbia | 4 | 0 | 0 | 53.7267 | -127.6476 | 2020-02-07T05:43:03 | ||||
3222044 | 3222044 | 2020-02-07 | Canada | British Columbia | 4 | 0 | 0 | 53.7267 | -127.6476 | 2020-02-07T05:43:03 | ||||
3362415 | 3362415 | 2020-02-09 | Canada | British Columbia | 4 | 0 | 0 | 53.7267 | -127.6476 | 2020-02-07T05:43:03 | ||||
1243392 | 1243392 | 2020-02-17 | Canada | British Columbia | 5 | 0 | 0 | 53.7267 | -127.6476 | 2020-02-17T08:03:07 | ||||
1720086 | 1720086 | 2020-02-19 | Canada | British Columbia | 5 | 0 | 0 | 53.7267 | -127.6476 | 2020-02-17T08:03:07 | ||||
1783118 | 1783118 | 2020-02-18 | Canada | British Columbia | 5 | 0 | 0 | 53.7267 | -127.6476 | 2020-02-17T08:03:07 | ||||
2263494 | 2263494 | 2020-02-20 | Canada | British Columbia | 5 | 0 | 0 | 53.7267 | -127.6476 | 2020-02-17T08:03:07 | ||||
1085673 | 1085673 | 2020-02-22 | Canada | British Columbia | 6 | 0 | 0 | 53.7267 | -127.6476 | 2020-02-21T05:23:04 | ||||
2135754 | 2135754 | 2020-02-21 | Canada | British Columbia | 6 | 0 | 0 | 53.7267 | -127.6476 | 2020-02-21T05:23:04 | ||||
3173384 | 3173384 | 2020-02-23 | Canada | British Columbia | 6 | 0 | 0 | 53.7267 | -127.6476 | 2020-02-21T05:23:04 | ||||
3551240 | 3551240 | 2020-02-24 | Canada | British Columbia | 6 | 0 | 0 | 53.7267 | -127.6476 | 2020-02-21T05:23:04 | ||||
479178 | 479178 | 2020-02-25 | Canada | British Columbia | 7 | 0 | 0 | 53.7267 | -127.6476 | 2020-02-25T02:23:05 | ||||
2509796 | 2509796 | 2020-02-26 | Canada | British Columbia | 7 | 0 | 0 | 53.7267 | -127.6476 | 2020-02-25T02:23:05 | ||||
617441 | 617441 | 2020-02-27 | Canada | British Columbia | 7 | 0 | 3 | 53.7267 | -127.6476 | 2020-02-27T03:33:06 | ||||
2883956 | 2883956 | 2020-02-28 | Canada | British Columbia | 7 | 0 | 3 | 53.7267 | -127.6476 | 2020-02-27T03:33:06 | ||||
562553 | 562553 | 2020-03-01 | Canada | British Columbia | 8 | 0 | 3 | 49.2827 | -123.1207 | 2020-02-29T23:23:13 | ||||
1152695 | 1152695 | 2020-03-02 | Canada | British Columbia | 8 | 0 | 3 | 49.2827 | -123.1207 | 2020-02-29T23:23:13 | ||||
3205838 | 3205838 | 2020-02-29 | Canada | British Columbia | 8 | 0 | 3 | 53.7267 | -127.6476 | 2020-02-29T23:23:13 | ||||
261083 | 261083 | 2020-03-03 | Canada | British Columbia | 9 | 0 | 3 | 49.2827 | -123.1207 | 2020-03-03T23:53:03 | ||||
98866 | 98866 | 2020-03-04 | Canada | British Columbia | 12 | 0 | 3 | 49.2827 | -123.1207 | 2020-03-04T04:23:05 | ||||
40200 | 40200 | 2020-03-05 | Canada | British Columbia | 13 | 0 | 3 | 49.2827 | -123.1207 | 2020-03-05T04:43:03 | ||||
3177536 | 3177536 | 2020-03-06 | Canada | British Columbia | 21 | 0 | 3 | 49.2827 | -123.1207 | 2020-03-06T04:43:03 | ||||
62537 | 62537 | 2020-03-07 | Canada | British Columbia | 21 | 0 | 4 | 49.2827 | -123.1207 | 2020-03-07T03:53:03 | ||||
1527269 | 1527269 | 2020-03-08 | Canada | British Columbia | 27 | 0 | 4 | 49.2827 | -123.1207 | 2020-03-08T05:13:07 | ||||
657748 | 657748 | 2020-03-09 | Canada | British Columbia | 32 | 1 | 4 | 53.7267 | -127.6476 | 2020-03-09T22:43:25 | ||||
3752886 | 3752886 | 2020-03-10 | Canada | British Columbia | 32 | 1 | 4 | 53.7267 | -127.6476 | 2020-03-09T22:43:25 | ||||
2127505 | 2127505 | 2020-03-11 | Canada | British Columbia | 39 | 1 | 4 | 53.7267 | -127.6476 | 2020-03-11T02:18:28 | ||||
3765322 | 3765322 | 2020-03-13 | Canada | British Columbia | 64 | 1 | 4 | 53.7267 | -127.6476 | 2020-03-11T20:00:00 | ||||
2282934 | 2282934 | 2020-03-12 | Canada | British Columbia | 46 | 1 | 4 | 53.7267 | -127.6476 | 2020-03-12T01:53:03 | ||||
2111169 | 2111169 | 2020-03-14 | Canada | British Columbia | 64 | 1 | 4 | 53.7267 | -127.6476 | 2020-03-14T00:13:05 | ||||
1463544 | 1463544 | 2020-03-15 | Canada | British Columbia | 73 | 1 | 4 | 53.7267 | -127.6476 | 2020-03-15T01:53:02 | ||||
2255192 | 2255192 | 2020-03-16 | Canada | British Columbia | 103 | 4 | 4 | 53.7267 | -127.6476 | 2020-03-16T19:13:13 | ||||
3891392 | 3891392 | 2020-03-17 | Canada | British Columbia | 103 | 4 | 4 | 53.7267 | -127.6476 | 2020-03-16T19:13:13 | ||||
1176941 | 1176941 | 2020-03-18 | Canada | British Columbia | 186 | 7 | 4 | 53.7267 | -127.6476 | 2020-03-18T03:33:03 | ||||
1526942 | 1526942 | 2020-03-19 | Canada | British Columbia | 231 | 7 | 4 | 53.7267 | -127.6476 | 2020-03-19T03:13:26 | ||||
3733991 | 3733991 | 2020-03-20 | Canada | British Columbia | 271 | 8 | 4 | 53.7267 | -127.6476 | 2020-03-20T03:13:18 | ||||
339681 | 339681 | 2020-03-21 | Canada | British Columbia | 424 | 10 | 4 | 53.7267 | -127.6476 | 2020-03-21T21:13:30 | ||||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 |
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]);