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 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3101210 | 3101210 | 2021-01-16 | Canada | New Brunswick | 911 | 12 | 631 | 268 | 46.5653 | -66.4619 | 2021-01-17 05:22:17 | New Brunswick, Canada | ||
3515172 | 3515172 | 2021-01-15 | Canada | New Brunswick | 884 | 12 | 615 | 257 | 46.5653 | -66.4619 | 2021-01-16 05:22:40 | New Brunswick, Canada | ||
3879345 | 3879345 | 2021-01-14 | Canada | New Brunswick | 859 | 12 | 600 | 247 | 46.5653 | -66.4619 | 2021-01-15 05:22:24 | New Brunswick, Canada | ||
3307972 | 3307972 | 2021-01-13 | Canada | New Brunswick | 836 | 12 | 593 | 231 | 46.5653 | -66.4619 | 2021-01-14 05:22:32 | New Brunswick, Canada | ||
774117 | 774117 | 2021-01-12 | Canada | New Brunswick | 817 | 11 | 586 | 220 | 46.5653 | -66.4619 | 2021-01-13 05:22:15 | New Brunswick, Canada | ||
189838 | 189838 | 2021-01-11 | Canada | New Brunswick | 800 | 9 | 586 | 205 | 46.5653 | -66.4619 | 2021-01-12 05:22:15 | New Brunswick, Canada | ||
2625641 | 2625641 | 2021-01-10 | Canada | New Brunswick | 779 | 9 | 585 | 185 | 46.5653 | -66.4619 | 2021-01-11 05:21:50 | New Brunswick, Canada | ||
3899729 | 3899729 | 2021-01-09 | Canada | New Brunswick | 765 | 9 | 584 | 172 | 46.5653 | -66.4619 | 2021-01-10 05:22:12 | New Brunswick, Canada | ||
153752 | 153752 | 2021-01-08 | Canada | New Brunswick | 735 | 9 | 582 | 144 | 46.5653 | -66.4619 | 2021-01-09 05:22:18 | New Brunswick, Canada | ||
2541176 | 2541176 | 2021-01-07 | Canada | New Brunswick | 717 | 9 | 577 | 131 | 46.5653 | -66.4619 | 2021-01-08 05:22:42 | New Brunswick, Canada | ||
2864485 | 2864485 | 2021-01-06 | Canada | New Brunswick | 693 | 9 | 573 | 111 | 46.5653 | -66.4619 | 2021-01-07 05:22:03 | 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 | ||
1061617 | 1061617 | 2021-01-04 | Canada | New Brunswick | 635 | 9 | 570 | 56 | 46.5653 | -66.4619 | 2021-01-05 05:21:49 | New Brunswick, Canada | ||
3230220 | 3230220 | 2021-01-03 | Canada | New Brunswick | 618 | 9 | 567 | 42 | 46.5653 | -66.4619 | 2021-01-04 05:22:02 | New Brunswick, Canada | ||
2227290 | 2227290 | 2021-01-02 | Canada | New Brunswick | 611 | 9 | 567 | 35 | 46.5653 | -66.4619 | 2021-01-03 05:22:52 | New Brunswick, Canada | ||
1136654 | 1136654 | 2021-01-01 | Canada | New Brunswick | 601 | 9 | 567 | 25 | 46.5653 | -66.4619 | 2021-01-02 05:22:33 | New Brunswick, Canada | ||
3695260 | 3695260 | 2020-12-31 | Canada | New Brunswick | 599 | 9 | 561 | 29 | 46.5653 | -66.4619 | 2021-01-01 05:23:07 | New Brunswick, Canada | ||
1010075 | 1010075 | 2020-12-30 | Canada | New Brunswick | 596 | 8 | 560 | 28 | 46.5653 | -66.4619 | 2020-12-31 05:22:49 | New Brunswick, Canada | ||
766090 | 766090 | 2020-12-29 | Canada | New Brunswick | 595 | 8 | 555 | 32 | 46.5653 | -66.4619 | 2020-12-30 05:22:34 | New Brunswick, Canada | ||
3761354 | 3761354 | 2020-12-28 | Canada | New Brunswick | 593 | 8 | 551 | 34 | 46.5653 | -66.4619 | 2020-12-29 05:22:37 | New Brunswick, Canada | ||
3777674 | 3777674 | 2020-12-27 | Canada | New Brunswick | 592 | 8 | 549 | 35 | 46.5653 | -66.4619 | 2020-12-28 05:22:06 | New Brunswick, Canada | ||
2223279 | 2223279 | 2020-12-26 | Canada | New Brunswick | 590 | 8 | 543 | 39 | 46.5653 | -66.4619 | 2020-12-27 05:22:55 | New Brunswick, Canada | ||
202026 | 202026 | 2020-12-25 | Canada | New Brunswick | 588 | 8 | 536 | 44 | 46.5653 | -66.4619 | 2020-12-26 05:22:28 | New Brunswick, Canada | ||
3691249 | 3691249 | 2020-12-24 | Canada | New Brunswick | 587 | 8 | 534 | 45 | 46.5653 | -66.4619 | 2020-12-25 05:22:48 | New Brunswick, Canada | ||
2406601 | 2406601 | 2020-12-23 | Canada | New Brunswick | 585 | 8 | 530 | 47 | 46.5653 | -66.4619 | 2020-12-24 05:23:04 | New Brunswick, Canada | ||
3769647 | 3769647 | 2020-12-22 | Canada | New Brunswick | 580 | 8 | 525 | 47 | 46.5653 | -66.4619 | 2020-12-23 05:22:03 | New Brunswick, Canada | ||
927463 | 927463 | 2020-12-21 | Canada | New Brunswick | 578 | 8 | 521 | 49 | 46.5653 | -66.4619 | 2020-12-22 05:22:33 | New Brunswick, Canada | ||
2119484 | 2119484 | 2020-12-20 | Canada | New Brunswick | 574 | 8 | 520 | 46 | 46.5653 | -66.4619 | 2020-12-21 05:27:58 | New Brunswick, Canada | ||
2930991 | 2930991 | 2020-12-19 | Canada | New Brunswick | 578 | 8 | 520 | 50 | 46.5653 | -66.4619 | 2020-12-20 05:27:32 | New Brunswick, Canada | ||
1900937 | 1900937 | 2020-12-18 | Canada | New Brunswick | 573 | 8 | 512 | 53 | 46.5653 | -66.4619 | 2020-12-19 05:27:52 | New Brunswick, Canada | ||
2127763 | 2127763 | 2020-12-17 | Canada | New Brunswick | 573 | 8 | 509 | 56 | 46.5653 | -66.4619 | 2020-12-18 05:28:18 | New Brunswick, Canada | ||
3149363 | 3149363 | 2020-12-16 | Canada | New Brunswick | 567 | 8 | 507 | 52 | 46.5653 | -66.4619 | 2020-12-17 05:28:12 | New Brunswick, Canada | ||
1034144 | 1034144 | 2020-12-15 | Canada | New Brunswick | 559 | 8 | 503 | 48 | 46.5653 | -66.4619 | 2020-12-16 05:28:04 | 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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
3859601 | 3859601 | 2020-12-04 | Canada | New Brunswick | 528 | 7 | 410 | 111 | 46.5653 | -66.4619 | 2020-12-05 05:27:36 | New Brunswick, Canada | ||
74859 | 74859 | 2020-12-03 | Canada | New Brunswick | 520 | 7 | 402 | 111 | 46.5653 | -66.4619 | 2020-12-04 05:27:27 | New Brunswick, Canada | ||
738071 | 738071 | 2020-12-02 | Canada | New Brunswick | 514 | 7 | 388 | 119 | 46.5653 | -66.4619 | 2020-12-03 05:28:22 | New Brunswick, Canada | ||
2537165 | 2537165 | 2020-12-01 | Canada | New Brunswick | 508 | 7 | 385 | 116 | 46.5653 | -66.4619 | 2020-12-02 05:27:41 | New Brunswick, Canada | ||
1583934 | 1583934 | 2020-11-30 | Canada | New Brunswick | 501 | 7 | 374 | 120 | 46.5653 | -66.4619 | 2020-12-01 05:26:18 | New Brunswick, Canada | ||
3566337 | 3566337 | 2020-11-29 | Canada | New Brunswick | 495 | 7 | 369 | 119 | 46.5653 | -66.4619 | 2020-11-30 05:26:13 | New Brunswick, Canada | ||
2935002 | 2935002 | 2020-11-28 | Canada | New Brunswick | 481 | 7 | 363 | 111 | 46.5653 | -66.4619 | 2020-11-29 05:25:55 | New Brunswick, Canada | ||
392005 | 392005 | 2020-11-27 | Canada | New Brunswick | 477 | 7 | 356 | 114 | 46.5653 | -66.4619 | 2020-11-28 05:25:50 | New Brunswick, Canada | ||
923452 | 923452 | 2020-11-26 | Canada | New Brunswick | 465 | 7 | 353 | 105 | 46.5653 | -66.4619 | 2020-11-27 05:26:53 | 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 | ||
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 | ||
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 | ||
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 | ||
2701281 | 2701281 | 2020-11-20 | Canada | New Brunswick | 401 | 6 | 344 | 51 | 46.5653 | -66.4619 | 2020-11-21 05:25:51 | New Brunswick, Canada | ||
821341 | 821341 | 2020-11-19 | Canada | New Brunswick | 392 | 6 | 343 | 43 | 46.5653 | -66.4619 | 2020-11-20 05:26:28 | New Brunswick, Canada | ||
122475 | 122475 | 2020-11-18 | Canada | New Brunswick | 388 | 6 | 342 | 40 | 46.5653 | -66.4619 | 2020-11-19 05:25:23 | New Brunswick, Canada | ||
3338363 | 3338363 | 2020-11-17 | Canada | New Brunswick | 379 | 6 | 341 | 32 | 46.5653 | -66.4619 | 2020-11-18 05:40:31 | New Brunswick, Canada | ||
3169408 | 3169408 | 2020-11-16 | Canada | New Brunswick | 375 | 6 | 341 | 28 | 46.5653 | -66.4619 | 2020-11-17 05:25:54 | New Brunswick, Canada | ||
2879976 | 2879976 | 2020-11-15 | Canada | New Brunswick | 367 | 6 | 339 | 22 | 46.5653 | -66.4619 | 2020-11-16 05:25:57 | New Brunswick, Canada | ||
2914954 | 2914954 | 2020-11-14 | Canada | New Brunswick | 364 | 6 | 339 | 19 | 46.5653 | -66.4619 | 2020-11-15 05:26:53 | New Brunswick, Canada | ||
2784776 | 2784776 | 2020-11-13 | Canada | New Brunswick | 358 | 6 | 338 | 14 | 46.5653 | -66.4619 | 2020-11-14 05:25:37 | New Brunswick, Canada | ||
864541 | 864541 | 2020-11-12 | Canada | New Brunswick | 356 | 6 | 337 | 13 | 46.5653 | -66.4619 | 2020-11-13 05:25:30 | New Brunswick, Canada | ||
3440586 | 3440586 | 2020-11-11 | Canada | New Brunswick | 355 | 6 | 333 | 16 | 46.5653 | -66.4619 | 2020-11-12 05:25:55 | New Brunswick, Canada | ||
271926 | 271926 | 2020-11-10 | Canada | New Brunswick | 355 | 6 | 332 | 17 | 46.5653 | -66.4619 | 2020-11-11 05:25:30 | New Brunswick, Canada | ||
1988403 | 1988403 | 2020-11-09 | Canada | New Brunswick | 355 | 6 | 328 | 21 | 46.5653 | -66.4619 | 2020-11-10 05:40:07 | New Brunswick, Canada | ||
1728255 | 1728255 | 2020-11-08 | Canada | New Brunswick | 354 | 6 | 324 | 24 | 46.5653 | -66.4619 | 2020-11-09 05:25:45 | New Brunswick, Canada | ||
1543715 | 1543715 | 2020-11-07 | Canada | New Brunswick | 353 | 6 | 321 | 26 | 46.5653 | -66.4619 | 2020-11-08 05:24:56 | New Brunswick, Canada | ||
375953 | 375953 | 2020-11-06 | Canada | New Brunswick | 350 | 6 | 320 | 24 | 46.5653 | -66.4619 | 2020-11-07 05:24:52 | New Brunswick, Canada | ||
891891 | 891891 | 2020-11-05 | Canada | New Brunswick | 349 | 6 | 315 | 28 | 46.5653 | -66.4619 | 2020-11-06 05:24:55 | New Brunswick, Canada | ||
2918953 | 2918953 | 2020-11-04 | Canada | New Brunswick | 347 | 6 | 313 | 28 | 46.5653 | -66.4619 | 2020-11-05 06:05:03 | New Brunswick, Canada | ||
2497790 | 2497790 | 2020-11-03 | Canada | New Brunswick | 344 | 6 | 309 | 29 | 46.5653 | -66.4619 | 2020-11-04 05:25:09 | New Brunswick, Canada | ||
3303965 | 3303965 | 2020-11-02 | Canada | New Brunswick | 344 | 6 | 305 | 33 | 46.5653 | -66.4619 | 2020-11-03 06:00:16 | New Brunswick, Canada | ||
3409214 | 3409214 | 2020-11-01 | Canada | New Brunswick | 344 | 6 | 303 | 35 | 46.5653 | -66.4619 | 2020-11-02 05:25:04 | New Brunswick, Canada | ||
2079703 | 2079703 | 2020-10-31 | Canada | New Brunswick | 343 | 6 | 299 | 38 | 46.5653 | -66.4619 | 2020-11-01 04:36:19 | New Brunswick, Canada | ||
2243156 | 2243156 | 2020-10-30 | Canada | New Brunswick | 342 | 6 | 297 | 39 | 46.5653 | -66.4619 | 2020-10-31 04:24:44 | New Brunswick, Canada | ||
210011 | 210011 | 2020-10-29 | Canada | New Brunswick | 341 | 6 | 294 | 41 | 46.5653 | -66.4619 | 2020-10-30 04:24:49 | New Brunswick, Canada | ||
754073 | 754073 | 2020-10-28 | Canada | New Brunswick | 337 | 6 | 284 | 47 | 46.5653 | -66.4619 | 2020-10-29 04:24:49 | New Brunswick, Canada | ||
1452358 | 1452358 | 2020-10-27 | Canada | New Brunswick | 334 | 6 | 273 | 55 | 46.5653 | -66.4619 | 2020-10-28 04:24:39 | 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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
1794401 | 1794401 | 2020-10-19 | Canada | New Brunswick | 313 | 3 | 207 | 103 | 46.5653 | -66.4619 | 2020-10-20 04:24:22 | New Brunswick, Canada | ||
762085 | 762085 | 2020-10-18 | Canada | New Brunswick | 310 | 3 | 203 | 104 | 46.5653 | -66.4619 | 2020-10-19 04:24:16 | 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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
817338 | 817338 | 2020-10-09 | Canada | New Brunswick | 238 | 2 | 199 | 37 | 46.5653 | -66.4619 | 2020-10-10 04:23:57 | 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]);