johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,024 rows where country_or_region = "Canada" and province_or_state = "New Brunswick" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
589057 | 589057 | 2020-04-05 | Canada | New Brunswick | 98 | 0 | 0 | 98 | 46.5653 | -66.4619 | 2020-04-05 23:13:28 | New Brunswick, Canada | ||
1632073 | 1632073 | 2020-12-05 | Canada | New Brunswick | 530 | 7 | 425 | 98 | 46.5653 | -66.4619 | 2020-12-06 05:26:18 | New Brunswick, Canada | ||
3381143 | 3381143 | 2021-06-13 | Canada | New Brunswick | 2298 | 45 | 2155 | 98 | 46.5653 | -66.4619 | 2021-06-14 04:22:46 | New Brunswick, Canada | ||
3970318 | 3970318 | 2021-06-11 | Canada | New Brunswick | 2284 | 44 | 2142 | 98 | 46.5653 | -66.4619 | 2021-06-12 04:22:22 | New Brunswick, Canada | ||
3990381 | 3990381 | 2020-10-20 | Canada | New Brunswick | 313 | 3 | 215 | 95 | 46.5653 | -66.4619 | 2020-10-21 04:24:14 | New Brunswick, Canada | ||
1736277 | 1736277 | 2021-06-12 | Canada | New Brunswick | 2291 | 45 | 2152 | 94 | 46.5653 | -66.4619 | 2021-06-13 04:22:44 | New Brunswick, Canada | ||
1972357 | 1972357 | 2020-11-25 | Canada | New Brunswick | 453 | 7 | 352 | 94 | 46.5653 | -66.4619 | 2020-11-26 05:27:44 | New Brunswick, Canada | ||
1350088 | 1350088 | 2020-11-24 | Canada | New Brunswick | 450 | 7 | 350 | 93 | 46.5653 | -66.4619 | 2020-11-25 05:27:20 | New Brunswick, Canada | ||
1026123 | 1026123 | 2020-10-17 | Canada | New Brunswick | 297 | 2 | 203 | 92 | 46.5653 | -66.4619 | 2020-10-18 04:24:25 | New Brunswick, Canada | ||
2191370 | 2191370 | 2020-10-21 | Canada | New Brunswick | 319 | 4 | 223 | 92 | 46.5653 | -66.4619 | 2020-10-22 04:24:27 | New Brunswick, Canada | ||
2856618 | 2856618 | 2020-10-16 | Canada | New Brunswick | 297 | 2 | 203 | 92 | 46.5653 | -66.4619 | 2020-10-17 04:24:12 | New Brunswick, Canada | ||
1563860 | 1563860 | 2021-06-14 | Canada | New Brunswick | 2299 | 45 | 2163 | 91 | 46.5653 | -66.4619 | 2021-06-15 04:22:22 | New Brunswick, Canada | ||
1750701 | 1750701 | 2020-04-04 | Canada | New Brunswick | 91 | 0 | 0 | 91 | 46.5653 | -66.4619 | 4/4/20 23:40 | New Brunswick, Canada | ||
3701542 | 3701542 | 2020-04-02 | Canada | New Brunswick | 91 | 0 | 0 | 91 | 46.5653 | -66.4619 | 4/2/20 23:31 | New Brunswick, Canada | ||
3740512 | 3740512 | 2020-04-03 | Canada | New Brunswick | 91 | 0 | 0 | 91 | 46.5653 | -66.4619 | 2020-04-03 22:52:30 | New Brunswick, Canada | ||
78859 | 78859 | 2020-10-14 | Canada | New Brunswick | 292 | 2 | 200 | 90 | 46.5653 | -66.4619 | 2020-10-15 04:24:28 | New Brunswick, Canada | ||
1980384 | 1980384 | 2021-03-25 | Canada | New Brunswick | 1546 | 30 | 1426 | 90 | 46.5653 | -66.4619 | 2021-03-26 05:26:55 | New Brunswick, Canada | ||
295780 | 295780 | 2021-07-15 | Canada | New Brunswick | 2343 | 46 | 2288 | 9 | 46.5653 | -66.4619 | 2021-07-16 04:21:22 | New Brunswick, Canada | ||
408062 | 408062 | 2021-07-28 | Canada | New Brunswick | 2354 | 46 | 2299 | 9 | 46.5653 | -66.4619 | 2021-07-29 04:21:33 | New Brunswick, Canada | ||
483358 | 483358 | 2021-07-19 | Canada | New Brunswick | 2346 | 46 | 2291 | 9 | 46.5653 | -66.4619 | 2021-07-20 04:21:48 | New Brunswick, Canada | ||
582603 | 582603 | 2020-08-13 | Canada | New Brunswick | 180 | 2 | 169 | 9 | 46.5653 | -66.4619 | 2020-08-14 04:51:19 | New Brunswick, Canada | ||
1612019 | 1612019 | 2020-08-14 | Canada | New Brunswick | 180 | 2 | 169 | 9 | 46.5653 | -66.4619 | 2020-08-15 04:27:31 | New Brunswick, Canada | ||
2039875 | 2039875 | 2020-06-27 | Canada | New Brunswick | 165 | 2 | 154 | 9 | 46.5653 | -66.4619 | 2020-06-28 04:34:04 | New Brunswick, Canada | ||
2215439 | 2215439 | 2020-08-23 | Canada | New Brunswick | 189 | 2 | 178 | 9 | 46.5653 | -66.4619 | 2020-08-24 04:27:56 | New Brunswick, Canada | ||
2947124 | 2947124 | 2021-07-16 | Canada | New Brunswick | 2345 | 46 | 2290 | 9 | 46.5653 | -66.4619 | 2021-07-17 04:22:22 | New Brunswick, Canada | ||
2991044 | 2991044 | 2020-08-24 | Canada | New Brunswick | 189 | 2 | 178 | 9 | 46.5653 | -66.4619 | 2020-08-25 04:28:02 | New Brunswick, Canada | ||
3476079 | 3476079 | 2021-07-22 | Canada | New Brunswick | 2347 | 46 | 2292 | 9 | 46.5653 | -66.4619 | 2021-07-23 04:21:29 | New Brunswick, Canada | ||
3638875 | 3638875 | 2020-05-30 | Canada | New Brunswick | 129 | 0 | 120 | 9 | 46.5653 | -66.4619 | 2020-05-31 02:32:45 | New Brunswick, Canada | ||
3705893 | 3705893 | 2021-07-17 | Canada | New Brunswick | 2345 | 46 | 2290 | 9 | 46.5653 | -66.4619 | 2021-07-18 04:22:07 | New Brunswick, Canada | ||
678083 | 678083 | 2020-11-23 | Canada | New Brunswick | 445 | 7 | 349 | 89 | 46.5653 | -66.4619 | 2020-11-24 05:27:31 | New Brunswick, Canada | ||
786148 | 786148 | 2020-10-15 | Canada | New Brunswick | 292 | 2 | 201 | 89 | 46.5653 | -66.4619 | 2020-10-16 04:24:01 | New Brunswick, Canada | ||
181808 | 181808 | 2021-02-21 | Canada | New Brunswick | 1424 | 25 | 1311 | 88 | 46.5653 | -66.4619 | 2021-02-22 05:24:21 | New Brunswick, Canada | ||
742082 | 742082 | 2021-02-20 | Canada | New Brunswick | 1420 | 24 | 1308 | 88 | 46.5653 | -66.4619 | 2021-02-21 05:24:33 | New Brunswick, Canada | ||
2339164 | 2339164 | 2021-06-15 | Canada | New Brunswick | 2302 | 45 | 2171 | 86 | 46.5653 | -66.4619 | 2021-06-16 04:22:32 | New Brunswick, Canada | ||
530474 | 530474 | 2021-02-22 | Canada | New Brunswick | 1424 | 26 | 1313 | 85 | 46.5653 | -66.4619 | 2021-02-23 05:23:41 | New Brunswick, Canada | ||
1006064 | 1006064 | 2020-12-06 | Canada | New Brunswick | 534 | 7 | 445 | 82 | 46.5653 | -66.4619 | 2020-12-07 05:26:14 | New Brunswick, Canada | ||
1818558 | 1818558 | 2020-12-08 | Canada | New Brunswick | 541 | 7 | 452 | 82 | 46.5653 | -66.4619 | 2020-12-09 05:28:01 | New Brunswick, Canada | ||
3781674 | 3781674 | 2020-10-13 | Canada | New Brunswick | 284 | 2 | 200 | 82 | 46.5653 | -66.4619 | 2020-10-14 04:24:05 | New Brunswick, Canada | ||
1177265 | 1177265 | 2020-10-22 | Canada | New Brunswick | 322 | 4 | 237 | 81 | 46.5653 | -66.4619 | 2020-10-23 04:24:46 | New Brunswick, Canada | ||
2347194 | 2347194 | 2020-12-07 | Canada | New Brunswick | 536 | 7 | 448 | 81 | 46.5653 | -66.4619 | 2020-12-08 05:27:42 | New Brunswick, Canada | ||
3034072 | 3034072 | 2021-01-05 | Canada | New Brunswick | 662 | 9 | 572 | 81 | 46.5653 | -66.4619 | 2021-01-06 05:22:16 | New Brunswick, Canada | ||
3364746 | 3364746 | 2020-04-01 | Canada | New Brunswick | 81 | 0 | 0 | 81 | 46.5653 | -66.4619 | 2020-04-01 22:04:44 | New Brunswick, Canada | ||
829365 | 829365 | 2021-07-09 | Canada | New Brunswick | 2336 | 46 | 2282 | 8 | 46.5653 | -66.4619 | 2021-07-10 04:21:25 | New Brunswick, Canada | ||
1305923 | 1305923 | 2021-07-27 | Canada | New Brunswick | 2352 | 46 | 2298 | 8 | 46.5653 | -66.4619 | 2021-07-28 04:21:39 | New Brunswick, Canada | ||
1479328 | 1479328 | 2020-08-21 | Canada | New Brunswick | 188 | 2 | 178 | 8 | 46.5653 | -66.4619 | 2020-08-22 04:27:49 | New Brunswick, Canada | ||
1790416 | 1790416 | 2020-05-29 | Canada | New Brunswick | 128 | 0 | 120 | 8 | 46.5653 | -66.4619 | 2020-05-30 02:32:48 | New Brunswick, Canada | ||
1996416 | 1996416 | 2020-08-26 | Canada | New Brunswick | 190 | 2 | 180 | 8 | 46.5653 | -66.4619 | 2020-08-27 04:28:15 | New Brunswick, Canada | ||
2299221 | 2299221 | 2020-08-22 | Canada | New Brunswick | 188 | 2 | 178 | 8 | 46.5653 | -66.4619 | 2020-08-23 04:27:48 | New Brunswick, Canada | ||
2371279 | 2371279 | 2021-07-20 | Canada | New Brunswick | 2346 | 46 | 2292 | 8 | 46.5653 | -66.4619 | 2021-07-21 04:21:40 | New Brunswick, Canada | ||
3331298 | 3331298 | 2021-07-21 | Canada | New Brunswick | 2346 | 46 | 2292 | 8 | 46.5653 | -66.4619 | 2021-07-22 04:21:19 | New Brunswick, Canada | ||
3531222 | 3531222 | 2020-08-12 | Canada | New Brunswick | 178 | 2 | 168 | 8 | 46.5653 | -66.4619 | 2020-08-13 04:29:15 | New Brunswick, Canada | ||
860447 | 860447 | 2020-12-11 | Canada | New Brunswick | 554 | 8 | 468 | 78 | 46.5653 | -66.4619 | 2020-12-12 05:26:19 | New Brunswick, Canada | ||
3189759 | 3189759 | 2020-11-22 | Canada | New Brunswick | 430 | 6 | 347 | 77 | 46.5653 | -66.4619 | 2020-11-23 05:25:26 | New Brunswick, Canada | ||
1936219 | 1936219 | 2021-02-23 | Canada | New Brunswick | 1424 | 26 | 1322 | 76 | 46.5653 | -66.4619 | 2021-02-24 05:29:16 | New Brunswick, Canada | ||
2291214 | 2291214 | 2020-10-12 | Canada | New Brunswick | 278 | 2 | 200 | 76 | 46.5653 | -66.4619 | 2020-10-13 04:24:02 | New Brunswick, Canada | ||
1053595 | 1053595 | 2020-10-23 | Canada | New Brunswick | 324 | 4 | 245 | 75 | 46.5653 | -66.4619 | 2020-10-24 04:24:46 | New Brunswick, Canada | ||
1599989 | 1599989 | 2020-12-10 | Canada | New Brunswick | 546 | 7 | 464 | 75 | 46.5653 | -66.4619 | 2020-12-11 05:26:59 | New Brunswick, Canada | ||
2974998 | 2974998 | 2020-12-09 | Canada | New Brunswick | 542 | 7 | 461 | 74 | 46.5653 | -66.4619 | 2020-12-10 05:26:19 | New Brunswick, Canada | ||
845340 | 845340 | 2020-12-12 | Canada | New Brunswick | 555 | 8 | 475 | 72 | 46.5653 | -66.4619 | 2020-12-13 05:27:20 | New Brunswick, Canada | ||
3651340 | 3651340 | 2020-10-24 | Canada | New Brunswick | 326 | 4 | 250 | 72 | 46.5653 | -66.4619 | 2020-10-25 04:24:36 | New Brunswick, Canada | ||
3785667 | 3785667 | 2020-10-11 | Canada | New Brunswick | 272 | 2 | 199 | 71 | 46.5653 | -66.4619 | 2020-10-12 04:23:45 | New Brunswick, Canada | ||
3836253 | 3836253 | 2020-11-21 | Canada | New Brunswick | 424 | 6 | 347 | 71 | 46.5653 | -66.4619 | 2020-11-22 05:25:45 | New Brunswick, Canada | ||
3815839 | 3815839 | 2020-03-31 | Canada | New Brunswick | 70 | 0 | 0 | 70 | 46.5653 | -66.4619 | 2020-03-31 23:49:13 | New Brunswick, Canada | ||
625646 | 625646 | 2021-07-10 | Canada | New Brunswick | 2336 | 46 | 2283 | 7 | 46.5653 | -66.4619 | 2021-07-11 04:21:43 | New Brunswick, Canada | ||
662071 | 662071 | 2020-08-11 | Canada | New Brunswick | 177 | 2 | 168 | 7 | 46.5653 | -66.4619 | 2020-08-12 04:27:29 | New Brunswick, Canada | ||
1378275 | 1378275 | 2021-07-25 | Canada | New Brunswick | 2350 | 46 | 2297 | 7 | 46.5653 | -66.4619 | 2021-07-26 04:21:28 | New Brunswick, Canada | ||
1522955 | 1522955 | 2020-08-28 | Canada | New Brunswick | 191 | 2 | 182 | 7 | 46.5653 | -66.4619 | 2020-08-29 04:28:19 | New Brunswick, Canada | ||
2509956 | 2509956 | 2020-08-27 | Canada | New Brunswick | 190 | 2 | 181 | 7 | 46.5653 | -66.4619 | 2020-08-28 04:28:11 | New Brunswick, Canada | ||
3218066 | 3218066 | 2021-07-26 | Canada | New Brunswick | 2351 | 46 | 2298 | 7 | 46.5653 | -66.4619 | 2021-07-27 04:21:18 | New Brunswick, Canada | ||
3659362 | 3659362 | 2021-07-11 | Canada | New Brunswick | 2336 | 46 | 2283 | 7 | 46.5653 | -66.4619 | 2021-07-12 04:21:34 | New Brunswick, Canada | ||
1872391 | 1872391 | 2020-03-30 | Canada | New Brunswick | 68 | 0 | 0 | 68 | 46.5653 | -66.4619 | 3/30/20 22:58 | New Brunswick, Canada | ||
2875628 | 2875628 | 2020-03-29 | Canada | New Brunswick | 66 | 0 | 0 | 66 | 46.5653 | -66.4619 | 3/29/20 23:13 | New Brunswick, Canada | ||
8103 | 8103 | 2020-10-25 | Canada | New Brunswick | 328 | 6 | 257 | 65 | 46.5653 | -66.4619 | 2020-10-26 04:25:02 | New Brunswick, Canada | ||
279951 | 279951 | 2021-02-24 | Canada | New Brunswick | 1426 | 26 | 1335 | 65 | 46.5653 | -66.4619 | 2021-02-25 05:24:57 | New Brunswick, Canada | ||
3847558 | 3847558 | 2020-12-13 | Canada | New Brunswick | 557 | 8 | 484 | 65 | 46.5653 | -66.4619 | 2020-12-14 05:26:27 | New Brunswick, Canada | ||
2780762 | 2780762 | 2021-03-24 | Canada | New Brunswick | 1517 | 30 | 1423 | 64 | 46.5653 | -66.4619 | 2021-03-25 05:27:00 | New Brunswick, Canada | ||
2910940 | 2910940 | 2021-06-17 | Canada | New Brunswick | 2309 | 45 | 2202 | 62 | 46.5653 | -66.4619 | 2021-06-18 04:22:16 | New Brunswick, Canada | ||
1751038 | 1751038 | 2020-12-14 | Canada | New Brunswick | 558 | 8 | 490 | 60 | 46.5653 | -66.4619 | 2020-12-15 05:26:38 | New Brunswick, Canada | ||
3480082 | 3480082 | 2020-10-26 | Canada | New Brunswick | 331 | 6 | 265 | 60 | 46.5653 | -66.4619 | 2020-10-27 04:24:45 | New Brunswick, Canada | ||
371440 | 371440 | 2020-08-08 | Canada | New Brunswick | 176 | 2 | 168 | 6 | 46.5653 | -66.4619 | 2020-08-09 04:34:54 | New Brunswick, Canada | ||
458624 | 458624 | 2020-08-07 | Canada | New Brunswick | 176 | 2 | 168 | 6 | 46.5653 | -66.4619 | 2020-08-08 04:34:53 | New Brunswick, Canada | ||
609460 | 609460 | 2020-08-29 | Canada | New Brunswick | 191 | 2 | 183 | 6 | 46.5653 | -66.4619 | 2020-08-30 04:28:22 | New Brunswick, Canada | ||
966668 | 966668 | 2020-09-29 | Canada | New Brunswick | 200 | 2 | 192 | 6 | 46.5653 | -66.4619 | 2020-09-30 04:23:33 | New Brunswick, Canada | ||
1045587 | 1045587 | 2020-09-30 | Canada | New Brunswick | 200 | 2 | 192 | 6 | 46.5653 | -66.4619 | 2020-10-01 04:23:42 | New Brunswick, Canada | ||
1515165 | 1515165 | 2020-09-28 | Canada | New Brunswick | 200 | 2 | 192 | 6 | 46.5653 | -66.4619 | 2020-09-29 04:23:42 | New Brunswick, Canada | ||
1920463 | 1920463 | 2020-08-10 | Canada | New Brunswick | 176 | 2 | 168 | 6 | 46.5653 | -66.4619 | 2020-08-11 04:35:08 | New Brunswick, Canada | ||
2379401 | 2379401 | 2020-10-01 | Canada | New Brunswick | 200 | 2 | 192 | 6 | 46.5653 | -66.4619 | 2020-10-02 04:23:51 | New Brunswick, Canada | ||
2513942 | 2513942 | 2020-10-03 | Canada | New Brunswick | 201 | 2 | 193 | 6 | 46.5653 | -66.4619 | 2020-10-04 04:23:44 | New Brunswick, Canada | ||
2581753 | 2581753 | 2020-09-27 | Canada | New Brunswick | 200 | 2 | 192 | 6 | 46.5653 | -66.4619 | 2020-09-28 04:23:00 | New Brunswick, Canada | ||
2613805 | 2613805 | 2020-09-26 | Canada | New Brunswick | 200 | 2 | 192 | 6 | 46.5653 | -66.4619 | 2020-09-27 04:23:00 | New Brunswick, Canada | ||
2712295 | 2712295 | 2020-05-28 | Canada | New Brunswick | 126 | 0 | 120 | 6 | 46.5653 | -66.4619 | 2020-05-29 02:32:50 | New Brunswick, Canada | ||
2812520 | 2812520 | 2020-09-25 | Canada | New Brunswick | 200 | 2 | 192 | 6 | 46.5653 | -66.4619 | 2020-09-26 04:23:00 | New Brunswick, Canada | ||
3484077 | 3484077 | 2020-08-20 | Canada | New Brunswick | 186 | 2 | 178 | 6 | 46.5653 | -66.4619 | 2020-08-21 04:27:41 | New Brunswick, Canada | ||
3612309 | 3612309 | 2020-08-06 | Canada | New Brunswick | 176 | 2 | 168 | 6 | 46.5653 | -66.4619 | 2020-08-07 04:35:11 | New Brunswick, Canada | ||
3740849 | 3740849 | 2021-07-12 | Canada | New Brunswick | 2336 | 46 | 2284 | 6 | 46.5653 | -66.4619 | 2021-07-13 04:21:18 | New Brunswick, Canada | ||
3923272 | 3923272 | 2020-08-09 | Canada | New Brunswick | 176 | 2 | 168 | 6 | 46.5653 | -66.4619 | 2020-08-10 04:34:55 | New Brunswick, Canada | ||
3030058 | 3030058 | 2021-06-16 | Canada | New Brunswick | 2305 | 45 | 2201 | 59 | 46.5653 | -66.4619 | 2021-06-17 04:22:36 | New Brunswick, Canada | ||
1798407 | 1798407 | 2021-03-23 | Canada | New Brunswick | 1505 | 30 | 1418 | 57 | 46.5653 | -66.4619 | 2021-03-24 05:25:40 | New Brunswick, Canada | ||
2601805 | 2601805 | 2020-10-10 | Canada | New Brunswick | 258 | 2 | 199 | 57 | 46.5653 | -66.4619 | 2020-10-11 04:23:46 | New Brunswick, Canada | ||
2884136 | 2884136 | 2021-06-20 | Canada | New Brunswick | 2318 | 45 | 2216 | 57 | 46.5653 | -66.4619 | 2021-06-21 04:21:41 | New Brunswick, 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]);