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 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2462567 | 2462567 | 2021-09-14 | Canada | Quebec | 399058 | 11312 | 0 | 52.9399 | -73.5491 | 2021-09-15 03:22:37 | Quebec, Canada | |||
1385406 | 1385406 | 2021-09-13 | Canada | Quebec | 398425 | 11305 | 0 | 52.9399 | -73.5491 | 2021-09-14 04:21:41 | Quebec, Canada | |||
1884775 | 1884775 | 2021-09-12 | Canada | Quebec | 397786 | 11304 | 0 | 52.9399 | -73.5491 | 2021-09-13 04:21:15 | Quebec, Canada | |||
3805678 | 3805678 | 2021-09-11 | Canada | Quebec | 396034 | 11301 | 0 | 52.9399 | -73.5491 | 2021-09-12 04:21:13 | Quebec, Canada | |||
3448618 | 3448618 | 2021-09-10 | Canada | Quebec | 396034 | 11301 | 0 | 52.9399 | -73.5491 | 2021-09-11 04:21:30 | Quebec, Canada | |||
1262564 | 1262564 | 2021-09-09 | Canada | Quebec | 395155 | 11297 | 0 | 52.9399 | -73.5491 | 2021-09-10 04:21:20 | Quebec, Canada | |||
2278934 | 2278934 | 2021-09-08 | Canada | Quebec | 394452 | 11296 | 0 | 52.9399 | -73.5491 | 2021-09-09 04:21:27 | Quebec, Canada | |||
641713 | 641713 | 2021-09-07 | Canada | Quebec | 393852 | 11293 | 0 | 52.9399 | -73.5491 | 2021-09-08 04:21:31 | Quebec, Canada | |||
3193776 | 3193776 | 2021-09-06 | Canada | Quebec | 393337 | 11293 | 0 | 52.9399 | -73.5491 | 2021-09-07 04:21:35 | Quebec, Canada | |||
3280644 | 3280644 | 2021-09-05 | Canada | Quebec | 392807 | 11293 | 0 | 52.9399 | -73.5491 | 2021-09-06 04:21:22 | Quebec, Canada | |||
249058 | 249058 | 2021-09-04 | Canada | Quebec | 392029 | 11292 | 0 | 52.9399 | -73.5491 | 2021-09-05 04:21:33 | Quebec, Canada | |||
3974339 | 3974339 | 2021-09-03 | Canada | Quebec | 391363 | 11291 | 0 | 52.9399 | -73.5491 | 2021-09-04 04:21:28 | Quebec, Canada | |||
177801 | 177801 | 2021-09-02 | Canada | Quebec | 390613 | 11289 | 0 | 52.9399 | -73.5491 | 2021-09-03 04:21:20 | Quebec, Canada | |||
66836 | 66836 | 2021-09-01 | Canada | Quebec | 389914 | 11288 | 0 | 52.9399 | -73.5491 | 2021-09-02 04:21:15 | Quebec, Canada | |||
2067678 | 2067678 | 2021-08-31 | Canada | Quebec | 389224 | 11286 | 0 | 52.9399 | -73.5491 | 2021-09-01 04:21:38 | Quebec, Canada | |||
1775132 | 1775132 | 2021-08-30 | Canada | Quebec | 388799 | 11285 | 0 | 52.9399 | -73.5491 | 2021-08-31 04:21:46 | Quebec, Canada | |||
3891706 | 3891706 | 2021-08-29 | Canada | Quebec | 388413 | 11285 | 0 | 52.9399 | -73.5491 | 2021-08-30 04:21:23 | Quebec, Canada | |||
2792809 | 2792809 | 2021-08-28 | Canada | Quebec | 387834 | 11285 | 0 | 52.9399 | -73.5491 | 2021-08-29 04:21:14 | Quebec, Canada | |||
2922968 | 2922968 | 2021-08-27 | Canada | Quebec | 387230 | 11285 | 0 | 52.9399 | -73.5491 | 2021-08-28 04:21:28 | Quebec, Canada | |||
1595982 | 1595982 | 2021-08-26 | Canada | Quebec | 386618 | 11285 | 0 | 52.9399 | -73.5491 | 2021-08-27 04:21:37 | Quebec, Canada | |||
32191 | 32191 | 2021-08-25 | Canada | Quebec | 386015 | 11284 | 0 | 52.9399 | -73.5491 | 2021-08-26 04:21:28 | Quebec, Canada | |||
3105230 | 3105230 | 2021-08-24 | Canada | Quebec | 385465 | 11283 | 0 | 52.9399 | -73.5491 | 2021-08-25 04:21:41 | Quebec, Canada | |||
3165401 | 3165401 | 2021-08-23 | Canada | Quebec | 385120 | 11280 | 0 | 52.9399 | -73.5491 | 2021-08-24 04:21:19 | Quebec, Canada | |||
2175328 | 2175328 | 2021-08-22 | Canada | Quebec | 384744 | 11279 | 0 | 52.9399 | -73.5491 | 2021-08-23 04:21:27 | Quebec, Canada | |||
3555424 | 3555424 | 2021-08-21 | Canada | Quebec | 384281 | 11279 | 0 | 52.9399 | -73.5491 | 2021-08-22 04:21:29 | Quebec, Canada | |||
1853766 | 1853766 | 2021-08-20 | Canada | Quebec | 383718 | 11279 | 0 | 52.9399 | -73.5491 | 2021-08-21 04:21:38 | Quebec, Canada | |||
511473 | 511473 | 2021-08-19 | Canada | Quebec | 383191 | 11277 | 0 | 52.9399 | -73.5491 | 2021-08-20 04:21:33 | Quebec, Canada | |||
2517952 | 2517952 | 2021-08-18 | Canada | Quebec | 382755 | 11278 | 0 | 52.9399 | -73.5491 | 2021-08-19 04:21:15 | Quebec, Canada | |||
245044 | 245044 | 2021-08-17 | Canada | Quebec | 382319 | 11242 | 0 | 52.9399 | -73.5491 | 2021-08-18 04:21:35 | Quebec, Canada | |||
1604007 | 1604007 | 2021-08-16 | Canada | Quebec | 381996 | 11242 | 0 | 52.9399 | -73.5491 | 2021-08-17 04:21:49 | Quebec, Canada | |||
103101 | 103101 | 2021-08-15 | Canada | Quebec | 381587 | 11242 | 0 | 52.9399 | -73.5491 | 2021-08-16 04:21:31 | Quebec, Canada | |||
507459 | 507459 | 2021-08-14 | Canada | Quebec | 381266 | 11243 | 0 | 52.9399 | -73.5491 | 2021-08-15 04:21:41 | Quebec, Canada | |||
1483331 | 1483331 | 2021-08-13 | Canada | Quebec | 380833 | 11242 | 0 | 52.9399 | -73.5491 | 2021-08-14 04:21:25 | Quebec, Canada | |||
2899461 | 2899461 | 2021-08-12 | Canada | Quebec | 380407 | 11242 | 0 | 52.9399 | -73.5491 | 2021-08-13 04:21:24 | Quebec, Canada | |||
1342065 | 1342065 | 2021-08-11 | Canada | Quebec | 380038 | 11242 | 0 | 52.9399 | -73.5491 | 2021-08-12 04:21:25 | Quebec, Canada | |||
2351212 | 2351212 | 2021-08-10 | Canada | Quebec | 379673 | 11241 | 0 | 52.9399 | -73.5491 | 2021-08-11 04:21:58 | Quebec, Canada | |||
649741 | 649741 | 2021-08-09 | Canada | Quebec | 379439 | 11242 | 0 | 52.9399 | -73.5491 | 2021-08-10 04:21:27 | Quebec, Canada | |||
589403 | 589403 | 2021-08-08 | Canada | Quebec | 379189 | 11241 | 0 | 52.9399 | -73.5491 | 2021-08-09 04:21:24 | Quebec, Canada | |||
2203415 | 2203415 | 2021-08-07 | Canada | Quebec | 378915 | 11241 | 0 | 52.9399 | -73.5491 | 2021-08-08 04:21:33 | Quebec, Canada | |||
1117365 | 1117365 | 2021-08-06 | Canada | Quebec | 378680 | 11241 | 0 | 52.9399 | -73.5491 | 2021-08-07 04:21:30 | Quebec, Canada | |||
1956302 | 1956302 | 2021-08-05 | Canada | Quebec | 378462 | 11240 | 0 | 52.9399 | -73.5491 | 2021-08-06 04:21:18 | Quebec, Canada | |||
331681 | 331681 | 2021-08-04 | Canada | Quebec | 378157 | 11240 | 364033 | 2884 | 52.9399 | -73.5491 | 2021-08-05 04:21:51 | Quebec, Canada | ||
3467952 | 3467952 | 2021-08-03 | Canada | Quebec | 377973 | 11241 | 364033 | 2699 | 52.9399 | -73.5491 | 2021-08-04 04:21:25 | Quebec, Canada | ||
3683226 | 3683226 | 2021-08-02 | Canada | Quebec | 377798 | 11241 | 364033 | 2524 | 52.9399 | -73.5491 | 2021-08-03 04:21:39 | Quebec, Canada | ||
3015125 | 3015125 | 2021-08-01 | Canada | Quebec | 377644 | 11241 | 364033 | 2370 | 52.9399 | -73.5491 | 2021-08-02 04:21:36 | Quebec, Canada | ||
3903748 | 3903748 | 2021-07-31 | Canada | Quebec | 377486 | 11241 | 364033 | 2212 | 52.9399 | -73.5491 | 2021-08-01 04:21:50 | Quebec, Canada | ||
3295953 | 3295953 | 2021-07-30 | Canada | Quebec | 377297 | 11241 | 364033 | 2023 | 52.9399 | -73.5491 | 2021-07-31 04:21:35 | Quebec, Canada | ||
3385164 | 3385164 | 2021-07-29 | Canada | Quebec | 377172 | 11240 | 364033 | 1899 | 52.9399 | -73.5491 | 2021-07-30 04:21:34 | 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 | ||
1305930 | 1305930 | 2021-07-27 | Canada | Quebec | 376901 | 11240 | 364033 | 1628 | 52.9399 | -73.5491 | 2021-07-28 04:21:39 | Quebec, Canada | ||
3218073 | 3218073 | 2021-07-26 | Canada | Quebec | 376828 | 11240 | 364033 | 1555 | 52.9399 | -73.5491 | 2021-07-27 04:21:18 | Quebec, Canada | ||
1378282 | 1378282 | 2021-07-25 | Canada | Quebec | 376753 | 11240 | 364033 | 1480 | 52.9399 | -73.5491 | 2021-07-26 04:21:28 | Quebec, Canada | ||
1330022 | 1330022 | 2021-07-24 | Canada | Quebec | 376651 | 11239 | 364033 | 1379 | 52.9399 | -73.5491 | 2021-07-25 04:22:12 | Quebec, Canada | ||
3137326 | 3137326 | 2021-07-23 | Canada | Quebec | 376530 | 11239 | 364033 | 1258 | 52.9399 | -73.5491 | 2021-07-24 00:21:36 | Quebec, Canada | ||
3476086 | 3476086 | 2021-07-22 | Canada | Quebec | 376429 | 11238 | 364033 | 1158 | 52.9399 | -73.5491 | 2021-07-23 04:21:29 | Quebec, Canada | ||
3331305 | 3331305 | 2021-07-21 | Canada | Quebec | 376519 | 11235 | 364033 | 1251 | 52.9399 | -73.5491 | 2021-07-22 04:21:19 | Quebec, Canada | ||
2371286 | 2371286 | 2021-07-20 | Canada | Quebec | 376416 | 11236 | 364033 | 1147 | 52.9399 | -73.5491 | 2021-07-21 04:21:40 | 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 | ||
2673588 | 2673588 | 2021-07-18 | Canada | Quebec | 376370 | 11236 | 364033 | 1101 | 52.9399 | -73.5491 | 2021-07-19 04:21:24 | Quebec, Canada | ||
3705900 | 3705900 | 2021-07-17 | Canada | Quebec | 376289 | 11236 | 364033 | 1020 | 52.9399 | -73.5491 | 2021-07-18 04:22:07 | Quebec, Canada | ||
2947131 | 2947131 | 2021-07-16 | Canada | Quebec | 376192 | 11235 | 364033 | 924 | 52.9399 | -73.5491 | 2021-07-17 04:22:22 | Quebec, Canada | ||
295787 | 295787 | 2021-07-15 | Canada | Quebec | 376149 | 11232 | 364033 | 884 | 52.9399 | -73.5491 | 2021-07-16 04:21:22 | Quebec, Canada | ||
3631732 | 3631732 | 2021-07-14 | Canada | Quebec | 376109 | 11231 | 364033 | 845 | 52.9399 | -73.5491 | 2021-07-15 04:21:48 | 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 | ||
3740856 | 3740856 | 2021-07-12 | Canada | Quebec | 375997 | 11231 | 364033 | 733 | 52.9399 | -73.5491 | 2021-07-13 04:21:18 | Quebec, Canada | ||
3659369 | 3659369 | 2021-07-11 | Canada | Quebec | 375937 | 11230 | 363775 | 932 | 52.9399 | -73.5491 | 2021-07-12 04:21:34 | 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 | ||
829372 | 829372 | 2021-07-09 | Canada | Quebec | 375823 | 11230 | 363775 | 818 | 52.9399 | -73.5491 | 2021-07-10 04:21:25 | 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 | ||
1440358 | 1440358 | 2021-07-07 | Canada | Quebec | 375678 | 11219 | 363415 | 1044 | 52.9399 | -73.5491 | 2021-07-08 04:21:26 | Quebec, Canada | ||
2693463 | 2693463 | 2021-07-06 | Canada | Quebec | 375609 | 11218 | 363339 | 1052 | 52.9399 | -73.5491 | 2021-07-07 04:21:20 | Quebec, Canada | ||
1932212 | 1932212 | 2021-07-05 | Canada | Quebec | 375522 | 11218 | 363245 | 1059 | 52.9399 | -73.5491 | 2021-07-06 04:21:32 | Quebec, Canada | ||
1164943 | 1164943 | 2021-07-04 | Canada | Quebec | 375444 | 11217 | 362961 | 1266 | 52.9399 | -73.5491 | 2021-07-05 04:21:28 | Quebec, Canada | ||
1495377 | 1495377 | 2021-07-03 | Canada | Quebec | 375404 | 11217 | 362961 | 1226 | 52.9399 | -73.5491 | 2021-07-04 04:21:38 | Quebec, Canada | ||
2071692 | 2071692 | 2021-07-02 | Canada | Quebec | 375342 | 11217 | 362961 | 1164 | 52.9399 | -73.5491 | 2021-07-03 04:21:37 | Quebec, Canada | ||
2764708 | 2764708 | 2021-07-01 | Canada | Quebec | 375276 | 11210 | 362756 | 1310 | 52.9399 | -73.5491 | 2021-07-02 04:21:47 | Quebec, Canada | ||
1892916 | 1892916 | 2021-06-30 | Canada | Quebec | 375197 | 11210 | 362756 | 1231 | 52.9399 | -73.5491 | 2021-07-01 04:21:19 | 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 | ||
3125282 | 3125282 | 2021-06-28 | Canada | Quebec | 375018 | 11203 | 362523 | 1292 | 52.9399 | -73.5491 | 2021-06-29 04:21:28 | Quebec, Canada | ||
2589777 | 2589777 | 2021-06-27 | Canada | Quebec | 374921 | 11202 | 362130 | 1589 | 52.9399 | -73.5491 | 2021-06-28 04:21:29 | Quebec, Canada | ||
3958281 | 3958281 | 2021-06-26 | Canada | Quebec | 374872 | 11202 | 362130 | 1540 | 52.9399 | -73.5491 | 2021-06-27 04:21:39 | Quebec, Canada | ||
1712100 | 1712100 | 2021-06-25 | Canada | Quebec | 374793 | 11202 | 362130 | 1461 | 52.9399 | -73.5491 | 2021-06-26 04:21:43 | Quebec, Canada | ||
2295225 | 2295225 | 2021-06-24 | Canada | Quebec | 374689 | 11202 | 361952 | 1535 | 52.9399 | -73.5491 | 2021-06-25 04:21:33 | Quebec, Canada | ||
2422665 | 2422665 | 2021-06-23 | Canada | Quebec | 374608 | 11198 | 361840 | 1570 | 52.9399 | -73.5491 | 2021-06-24 04:21:55 | 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 | ||
3358444 | 3358444 | 2021-06-21 | Canada | Quebec | 374400 | 11191 | 361521 | 1688 | 52.9399 | -73.5491 | 2021-06-22 04:21:34 | Quebec, Canada | ||
2884143 | 2884143 | 2021-06-20 | Canada | Quebec | 374307 | 11191 | 361352 | 1764 | 52.9399 | -73.5491 | 2021-06-21 04:21:41 | Quebec, Canada | ||
107226 | 107226 | 2021-06-19 | Canada | Quebec | 374213 | 11189 | 361160 | 1864 | 52.9399 | -73.5491 | 2021-06-20 04:21:48 | Quebec, Canada | ||
1125369 | 1125369 | 2021-06-18 | Canada | Quebec | 374125 | 11180 | 360973 | 1972 | 52.9399 | -73.5491 | 2021-06-19 04:22:33 | Quebec, Canada | ||
2910947 | 2910947 | 2021-06-17 | Canada | Quebec | 373995 | 11178 | 360779 | 2038 | 52.9399 | -73.5491 | 2021-06-18 04:22:16 | Quebec, Canada | ||
3030065 | 3030065 | 2021-06-16 | Canada | Quebec | 373836 | 11177 | 360587 | 2072 | 52.9399 | -73.5491 | 2021-06-17 04:22:36 | Quebec, Canada | ||
2339171 | 2339171 | 2021-06-15 | Canada | Quebec | 373686 | 11177 | 360410 | 2099 | 52.9399 | -73.5491 | 2021-06-16 04:22:32 | Quebec, Canada | ||
1563867 | 1563867 | 2021-06-14 | Canada | Quebec | 373512 | 11173 | 360194 | 2145 | 52.9399 | -73.5491 | 2021-06-15 04:22:22 | Quebec, Canada | ||
3381150 | 3381150 | 2021-06-13 | Canada | Quebec | 373402 | 11172 | 359981 | 2249 | 52.9399 | -73.5491 | 2021-06-14 04:22:46 | Quebec, Canada | ||
1736284 | 1736284 | 2021-06-12 | Canada | Quebec | 373283 | 11170 | 359698 | 2415 | 52.9399 | -73.5491 | 2021-06-13 04:22:44 | Quebec, Canada | ||
3970325 | 3970325 | 2021-06-11 | Canada | Quebec | 373150 | 11167 | 359421 | 2562 | 52.9399 | -73.5491 | 2021-06-12 04:22:22 | Quebec, Canada | ||
2716747 | 2716747 | 2021-06-10 | Canada | Quebec | 372987 | 11166 | 359104 | 2717 | 52.9399 | -73.5491 | 2021-06-11 04:23:20 | 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 | ||
3472072 | 3472072 | 2021-06-08 | Canada | Quebec | 372616 | 11156 | 358553 | 2907 | 52.9399 | -73.5491 | 2021-06-09 04:23:31 | Quebec, Canada | ||
3145356 | 3145356 | 2021-06-07 | Canada | Quebec | 372417 | 11152 | 358221 | 3044 | 52.9399 | -73.5491 | 2021-06-08 04:22:35 | 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]);