johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,026 rows where country_or_region = "Canada" and province_or_state = "Quebec" sorted by longitude
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
392012 | 392012 | 2020-11-27 | Canada | Quebec | 139443 | 7056 | 119727 | 12660 | 52.9399 | -73.5491 | 2020-11-28 05:25:50 | Quebec, Canada | ||
396024 | 396024 | 2022-10-07 | Canada | Quebec | 1207016 | 16836 | 0 | 52.9399 | -73.5491 | 2022-10-08 04:22:56 | Quebec, Canada | |||
400039 | 400039 | 2021-06-29 | Canada | Quebec | 375123 | 11207 | 362646 | 1270 | 52.9399 | -73.5491 | 2021-06-30 04:21:41 | Quebec, Canada | ||
404053 | 404053 | 2021-12-07 | Canada | Quebec | 457058 | 11594 | 0 | 52.9399 | -73.5491 | 2021-12-08 04:22:46 | Quebec, Canada | |||
408069 | 408069 | 2021-07-28 | Canada | Quebec | 377034 | 11240 | 364033 | 1761 | 52.9399 | -73.5491 | 2021-07-29 04:21:33 | Quebec, Canada | ||
415477 | 415477 | 2020-07-05 | Canada | Quebec | 55772 | 5658 | 25346 | 24768 | 52.9399 | -73.5491 | 2020-07-06 04:33:57 | Quebec, Canada | ||
418761 | 418761 | 2020-04-18 | Canada | Quebec | 19523 | 1274 | 0 | 18249 | 52.9399 | -73.5491 | 2020-04-18 22:40:03 | Quebec, Canada | ||
419095 | 419095 | 2022-09-18 | Canada | Quebec | 1190603 | 16673 | 0 | 52.9399 | -73.5491 | 2022-09-19 04:21:49 | Quebec, Canada | |||
423110 | 423110 | 2021-10-10 | Canada | Quebec | 415786 | 11415 | 0 | 52.9399 | -73.5491 | 2021-10-11 04:21:31 | Quebec, Canada | |||
427115 | 427115 | 2020-09-07 | Canada | Quebec | 63753 | 5786 | 55960 | 2007 | 52.9399 | -73.5491 | 2020-09-08 04:28:25 | Quebec, Canada | ||
431117 | 431117 | 2022-11-03 | Canada | Quebec | 1230606 | 17077 | 0 | 52.9399 | -73.5491 | 2022-11-04 04:22:11 | Quebec, Canada | |||
435132 | 435132 | 2021-01-21 | Canada | Quebec | 250073 | 9338 | 221327 | 19408 | 52.9399 | -73.5491 | 2021-01-22 05:22:10 | Quebec, Canada | ||
442663 | 442663 | 2020-07-26 | Canada | Quebec | 58645 | 5711 | 50812 | 2122 | 52.9399 | -73.5491 | 2020-07-27 04:35:02 | Quebec, Canada | ||
443114 | 443114 | 2021-10-20 | Canada | Quebec | 420928 | 11455 | 0 | 52.9399 | -73.5491 | 2021-10-21 04:21:18 | Quebec, Canada | |||
447130 | 447130 | 2021-11-17 | Canada | Quebec | 436083 | 11548 | 0 | 52.9399 | -73.5491 | 2021-11-18 04:21:33 | Quebec, Canada | |||
451147 | 451147 | 2022-12-21 | Canada | Quebec | 1275579 | 17586 | 0 | 52.9399 | -73.5491 | 2022-12-22 04:20:56 | Quebec, Canada | |||
458689 | 458689 | 2020-08-07 | Canada | Quebec | 60189 | 5730 | 50886 | 3573 | 52.9399 | -73.5491 | 2020-08-08 04:34:53 | Quebec, Canada | ||
459139 | 459139 | 2022-02-02 | Canada | Quebec | 868435 | 13336 | 0 | 52.9399 | -73.5491 | 2022-02-03 04:21:21 | Quebec, Canada | |||
463156 | 463156 | 2022-05-02 | Canada | Quebec | 1044635 | 15009 | 0 | 52.9399 | -73.5491 | 2022-05-03 04:21:00 | Quebec, Canada | |||
467171 | 467171 | 2021-10-07 | Canada | Quebec | 413929 | 11405 | 0 | 52.9399 | -73.5491 | 2021-10-08 04:21:25 | Quebec, Canada | |||
471187 | 471187 | 2021-02-19 | Canada | Quebec | 280468 | 10278 | 261429 | 8761 | 52.9399 | -73.5491 | 2021-02-20 05:22:51 | Quebec, Canada | ||
475202 | 475202 | 2022-06-26 | Canada | Quebec | 1085058 | 15567 | 0 | 52.9399 | -73.5491 | 2022-06-27 04:21:00 | Quebec, Canada | |||
479350 | 479350 | 2022-11-08 | Canada | Quebec | 1234477 | 17125 | 0 | 52.9399 | -73.5491 | 2022-11-09 04:21:22 | Quebec, Canada | |||
483365 | 483365 | 2021-07-19 | Canada | Quebec | 376431 | 11236 | 364033 | 1162 | 52.9399 | -73.5491 | 2021-07-20 04:21:48 | Quebec, Canada | ||
487380 | 487380 | 2022-11-25 | Canada | Quebec | 1248200 | 17314 | 0 | 52.9399 | -73.5491 | 2022-11-26 04:21:11 | Quebec, Canada | |||
491395 | 491395 | 2021-10-14 | Canada | Quebec | 417831 | 11431 | 0 | 52.9399 | -73.5491 | 2021-10-15 04:21:26 | Quebec, Canada | |||
495411 | 495411 | 2021-11-06 | Canada | Quebec | 429318 | 11515 | 0 | 52.9399 | -73.5491 | 2021-11-07 04:21:53 | Quebec, Canada | |||
499428 | 499428 | 2022-04-02 | Canada | Quebec | 974009 | 14397 | 0 | 52.9399 | -73.5491 | 2022-04-03 04:20:48 | Quebec, Canada | |||
503444 | 503444 | 2022-12-17 | Canada | Quebec | 1271168 | 17537 | 0 | 52.9399 | -73.5491 | 2022-12-18 04:21:03 | Quebec, Canada | |||
507459 | 507459 | 2021-08-14 | Canada | Quebec | 381266 | 11243 | 0 | 52.9399 | -73.5491 | 2021-08-15 04:21:41 | Quebec, Canada | |||
511473 | 511473 | 2021-08-19 | Canada | Quebec | 383191 | 11277 | 0 | 52.9399 | -73.5491 | 2021-08-20 04:21:33 | Quebec, Canada | |||
515488 | 515488 | 2022-10-15 | Canada | Quebec | 1214497 | 16884 | 0 | 52.9399 | -73.5491 | 2022-10-16 04:22:39 | Quebec, Canada | |||
522299 | 522299 | 2020-04-21 | Canada | Quebec | 22058 | 1618 | 0 | 20440 | 52.9399 | -73.5491 | 2020-04-21 23:38:53 | Quebec, Canada | ||
522632 | 522632 | 2021-06-09 | Canada | Quebec | 372771 | 11164 | 358849 | 2758 | 52.9399 | -73.5491 | 2021-06-10 04:23:17 | Quebec, Canada | ||
530039 | 530039 | 2020-07-04 | Canada | Quebec | 55715 | 5655 | 25280 | 24780 | 52.9399 | -73.5491 | 2020-07-05 04:33:46 | Quebec, Canada | ||
530481 | 530481 | 2021-02-22 | Canada | Quebec | 282638 | 10318 | 264497 | 7823 | 52.9399 | -73.5491 | 2021-02-23 05:23:41 | Quebec, Canada | ||
534495 | 534495 | 2021-10-27 | Canada | Quebec | 423812 | 11485 | 0 | 52.9399 | -73.5491 | 2021-10-28 04:22:08 | Quebec, Canada | |||
538512 | 538512 | 2022-10-26 | Canada | Quebec | 1223930 | 16998 | 0 | 52.9399 | -73.5491 | 2022-10-27 04:22:01 | Quebec, Canada | |||
542528 | 542528 | 2022-12-15 | Canada | Quebec | 1268912 | 17514 | 0 | 52.9399 | -73.5491 | 2022-12-16 04:21:01 | Quebec, Canada | |||
546532 | 546532 | 2020-09-12 | Canada | Quebec | 65058 | 5793 | 57054 | 2211 | 52.9399 | -73.5491 | 2020-09-13 04:30:52 | Quebec, Canada | ||
550533 | 550533 | 2021-12-08 | Canada | Quebec | 458425 | 11596 | 0 | 52.9399 | -73.5491 | 2021-12-09 04:22:49 | Quebec, Canada | |||
554549 | 554549 | 2022-01-16 | Canada | Quebec | 795752 | 12310 | 0 | 52.9399 | -73.5491 | 2022-01-17 04:21:08 | Quebec, Canada | |||
558566 | 558566 | 2022-06-16 | Canada | Quebec | 1076379 | 15523 | 0 | 52.9399 | -73.5491 | 2022-06-17 04:20:56 | Quebec, Canada | |||
562742 | 562742 | 2021-06-22 | Canada | Quebec | 374528 | 11195 | 361675 | 1658 | 52.9399 | -73.5491 | 2021-06-23 04:21:46 | Quebec, Canada | ||
566863 | 566863 | 2021-10-29 | Canada | Quebec | 424801 | 11491 | 0 | 52.9399 | -73.5491 | 2021-10-30 04:22:03 | Quebec, Canada | |||
574154 | 574154 | 2020-06-06 | Canada | Quebec | 52646 | 5348 | 18412 | 28886 | 52.9399 | -73.5491 | 2020-06-07 03:53:30 | Quebec, Canada | ||
574592 | 574592 | 2022-02-25 | Canada | Quebec | 918819 | 13955 | 0 | 52.9399 | -73.5491 | 2022-02-26 04:21:12 | Quebec, Canada | |||
578607 | 578607 | 2021-07-13 | Canada | Quebec | 376077 | 11231 | 364033 | 813 | 52.9399 | -73.5491 | 2021-07-14 04:21:35 | Quebec, Canada | ||
582610 | 582610 | 2020-08-13 | Canada | Quebec | 60788 | 5743 | 53441 | 1604 | 52.9399 | -73.5491 | 2020-08-14 04:51:19 | Quebec, Canada | ||
589071 | 589071 | 2020-04-05 | Canada | Quebec | 8663 | 251 | 0 | 8412 | 52.9399 | -73.5491 | 2020-04-05 23:13:28 | Quebec, Canada | ||
589403 | 589403 | 2021-08-08 | Canada | Quebec | 379189 | 11241 | 0 | 52.9399 | -73.5491 | 2021-08-09 04:21:24 | Quebec, Canada | |||
593418 | 593418 | 2022-07-01 | Canada | Quebec | 1091740 | 15596 | 0 | 52.9399 | -73.5491 | 2022-07-02 04:21:16 | Quebec, Canada | |||
597433 | 597433 | 2021-10-19 | Canada | Quebec | 420470 | 11453 | 0 | 52.9399 | -73.5491 | 2021-10-20 04:21:00 | Quebec, Canada | |||
601449 | 601449 | 2021-09-23 | Canada | Quebec | 405728 | 11347 | 0 | 52.9399 | -73.5491 | 2021-09-24 04:21:44 | Quebec, Canada | |||
605464 | 605464 | 2021-04-09 | Canada | Quebec | 324533 | 10726 | 300471 | 13336 | 52.9399 | -73.5491 | 2021-04-10 04:20:59 | Quebec, Canada | ||
609467 | 609467 | 2020-08-29 | Canada | Quebec | 62175 | 5778 | 55235 | 1162 | 52.9399 | -73.5491 | 2020-08-30 04:28:22 | Quebec, Canada | ||
613464 | 613464 | 2021-02-08 | Canada | Quebec | 270807 | 10046 | 249361 | 11400 | 52.9399 | -73.5491 | 2021-02-09 05:23:30 | Quebec, Canada | ||
617622 | 617622 | 2022-11-05 | Canada | Quebec | 1231520 | 17086 | 0 | 52.9399 | -73.5491 | 2022-11-06 04:21:24 | Quebec, Canada | |||
621638 | 621638 | 2022-05-22 | Canada | Quebec | 1063033 | 15378 | 0 | 52.9399 | -73.5491 | 2022-05-26 04:20:50 | Quebec, Canada | |||
625653 | 625653 | 2021-07-10 | Canada | Quebec | 375883 | 11230 | 363775 | 878 | 52.9399 | -73.5491 | 2021-07-11 04:21:43 | Quebec, Canada | ||
629668 | 629668 | 2022-07-12 | Canada | Quebec | 1104909 | 15674 | 0 | 52.9399 | -73.5491 | 2022-07-13 04:20:58 | Quebec, Canada | |||
633683 | 633683 | 2021-10-13 | Canada | Quebec | 417187 | 11429 | 0 | 52.9399 | -73.5491 | 2021-10-14 04:21:29 | Quebec, Canada | |||
637699 | 637699 | 2021-03-31 | Canada | Quebec | 311776 | 10667 | 291906 | 9203 | 52.9399 | -73.5491 | 2021-04-01 04:27:05 | Quebec, Canada | ||
641713 | 641713 | 2021-09-07 | Canada | Quebec | 393852 | 11293 | 0 | 52.9399 | -73.5491 | 2021-09-08 04:21:31 | Quebec, Canada | |||
645727 | 645727 | 2021-05-05 | Canada | Quebec | 355057 | 10964 | 334531 | 9562 | 52.9399 | -73.5491 | 2021-05-06 04:20:38 | Quebec, Canada | ||
649741 | 649741 | 2021-08-09 | Canada | Quebec | 379439 | 11242 | 0 | 52.9399 | -73.5491 | 2021-08-10 04:21:27 | Quebec, Canada | |||
653755 | 653755 | 2021-10-22 | Canada | Quebec | 421685 | 11466 | 0 | 52.9399 | -73.5491 | 2021-10-23 04:21:32 | Quebec, Canada | |||
657822 | 657822 | 2020-03-09 | Canada | Quebec | 15 | 0 | 0 | 52.9399 | -73.5491 | 2020-03-09T08:43:03 | ||||
658074 | 658074 | 2022-05-13 | Canada | Quebec | 1056174 | 15256 | 0 | 52.9399 | -73.5491 | 2022-05-14 04:20:48 | Quebec, Canada | |||
662078 | 662078 | 2020-08-11 | Canada | Quebec | 60600 | 5739 | 53135 | 1726 | 52.9399 | -73.5491 | 2020-08-12 04:27:29 | Quebec, Canada | ||
666057 | 666057 | 2020-09-16 | Canada | Quebec | 66275 | 5806 | 57804 | 2665 | 52.9399 | -73.5491 | 2020-09-17 04:22:00 | Quebec, Canada | ||
670059 | 670059 | 2022-07-21 | Canada | Quebec | 1132764 | 15834 | 0 | 52.9399 | -73.5491 | 2022-07-22 04:21:15 | Quebec, Canada | |||
674075 | 674075 | 2022-07-30 | Canada | Quebec | 1146894 | 15957 | 0 | 52.9399 | -73.5491 | 2022-07-31 04:21:02 | Quebec, Canada | |||
678090 | 678090 | 2020-11-23 | Canada | Quebec | 134221 | 6934 | 115367 | 11920 | 52.9399 | -73.5491 | 2020-11-24 05:27:31 | Quebec, Canada | ||
682100 | 682100 | 2021-10-24 | Canada | Quebec | 422670 | 11472 | 0 | 52.9399 | -73.5491 | 2021-10-25 04:22:31 | Quebec, Canada | |||
686116 | 686116 | 2021-11-13 | Canada | Quebec | 433705 | 11541 | 0 | 52.9399 | -73.5491 | 2021-11-14 04:21:31 | Quebec, Canada | |||
690133 | 690133 | 2022-12-23 | Canada | Quebec | 1277720 | 17615 | 0 | 52.9399 | -73.5491 | 2022-12-24 04:21:02 | Quebec, Canada | |||
694149 | 694149 | 2022-03-17 | Canada | Quebec | 939648 | 14232 | 0 | 52.9399 | -73.5491 | 2022-03-18 04:20:55 | Quebec, Canada | |||
698164 | 698164 | 2021-11-04 | Canada | Quebec | 428059 | 11510 | 0 | 52.9399 | -73.5491 | 2021-11-05 04:21:54 | Quebec, Canada | |||
702180 | 702180 | 2021-03-16 | Canada | Quebec | 298495 | 10558 | 281436 | 6501 | 52.9399 | -73.5491 | 2021-03-17 05:25:07 | Quebec, Canada | ||
706194 | 706194 | 2021-09-29 | Canada | Quebec | 409525 | 11369 | 0 | 52.9399 | -73.5491 | 2021-09-30 04:21:20 | Quebec, Canada | |||
710210 | 710210 | 2022-11-01 | Canada | Quebec | 1228697 | 17059 | 0 | 52.9399 | -73.5491 | 2022-11-02 04:22:09 | Quebec, Canada | |||
714225 | 714225 | 2021-11-12 | Canada | Quebec | 432990 | 11535 | 0 | 52.9399 | -73.5491 | 2021-11-13 04:21:38 | Quebec, Canada | |||
718242 | 718242 | 2022-12-04 | Canada | Quebec | 1254067 | 17361 | 0 | 52.9399 | -73.5491 | 2022-12-02 18:21:06 | Quebec, Canada | |||
722257 | 722257 | 2021-11-20 | Canada | Quebec | 438363 | 11555 | 0 | 52.9399 | -73.5491 | 2021-11-21 04:22:13 | Quebec, Canada | |||
726273 | 726273 | 2021-05-22 | Canada | Quebec | 367575 | 11081 | 348694 | 7800 | 52.9399 | -73.5491 | 2021-05-23 04:20:51 | Quebec, Canada | ||
730287 | 730287 | 2021-12-27 | Canada | Quebec | 546436 | 11677 | 0 | 52.9399 | -73.5491 | 2021-12-28 04:21:47 | Quebec, Canada | |||
737636 | 737636 | 2020-06-12 | Canada | Quebec | 53619 | 5465 | 20823 | 27331 | 52.9399 | -73.5491 | 2020-06-13 03:33:14 | Quebec, Canada | ||
738078 | 738078 | 2020-12-02 | Canada | Quebec | 146584 | 7206 | 125197 | 14181 | 52.9399 | -73.5491 | 2020-12-03 05:28:22 | Quebec, Canada | ||
742089 | 742089 | 2021-02-20 | Canada | Quebec | 281186 | 10292 | 262506 | 8388 | 52.9399 | -73.5491 | 2021-02-21 05:24:33 | Quebec, Canada | ||
746104 | 746104 | 2022-04-23 | Canada | Quebec | 1030942 | 14846 | 0 | 52.9399 | -73.5491 | 2022-04-24 04:20:56 | Quebec, Canada | |||
753643 | 753643 | 2020-08-01 | Canada | Quebec | 59458 | 5721 | 50886 | 2851 | 52.9399 | -73.5491 | 2020-08-02 04:34:47 | Quebec, Canada | ||
754080 | 754080 | 2020-10-28 | Canada | Quebec | 103894 | 6263 | 87638 | 9993 | 52.9399 | -73.5491 | 2020-10-29 04:24:49 | Quebec, Canada | ||
758087 | 758087 | 2021-11-26 | Canada | Quebec | 444584 | 11571 | 0 | 52.9399 | -73.5491 | 2021-11-27 04:22:45 | Quebec, Canada | |||
762092 | 762092 | 2020-10-18 | Canada | Quebec | 94448 | 6082 | 78559 | 9807 | 52.9399 | -73.5491 | 2020-10-19 04:24:16 | Quebec, Canada | ||
766097 | 766097 | 2020-12-29 | Canada | Quebec | 200327 | 8265 | 168061 | 24001 | 52.9399 | -73.5491 | 2020-12-30 05:22:34 | Quebec, Canada | ||
770108 | 770108 | 2021-10-23 | Canada | Quebec | 422241 | 11470 | 0 | 52.9399 | -73.5491 | 2021-10-24 04:21:22 | Quebec, Canada | |||
774124 | 774124 | 2021-01-12 | Canada | Quebec | 234567 | 8886 | 199920 | 25761 | 52.9399 | -73.5491 | 2021-01-13 05:22:15 | Quebec, Canada | ||
778136 | 778136 | 2021-07-08 | Canada | Quebec | 375751 | 11229 | 363484 | 1038 | 52.9399 | -73.5491 | 2021-07-09 04:21:21 | Quebec, Canada | ||
782150 | 782150 | 2021-12-13 | Canada | Quebec | 467608 | 11611 | 0 | 52.9399 | -73.5491 | 2021-12-14 04:22:38 | Quebec, 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]);