johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
111 rows where country_or_region = "Canada", deaths = 7 and province_or_state = "Newfoundland and Labrador" sorted by day 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2075700 | 2075700 | 2021-09-26 | Canada | Newfoundland and Labrador | 1692 | 7 | 0 | 53.1355 | -57.6604 | 2021-09-27 04:21:16 | Newfoundland and Labrador, Canada | |||
1724252 | 1724252 | 2021-09-25 | Canada | Newfoundland and Labrador | 1668 | 7 | 0 | 53.1355 | -57.6604 | 2021-09-26 04:21:29 | Newfoundland and Labrador, Canada | |||
1920972 | 1920972 | 2021-09-24 | Canada | Newfoundland and Labrador | 1654 | 7 | 0 | 53.1355 | -57.6604 | 2021-09-25 04:21:31 | Newfoundland and Labrador, Canada | |||
601443 | 601443 | 2021-09-23 | Canada | Newfoundland and Labrador | 1609 | 7 | 0 | 53.1355 | -57.6604 | 2021-09-24 04:21:44 | Newfoundland and Labrador, Canada | |||
3011104 | 3011104 | 2021-09-22 | Canada | Newfoundland and Labrador | 1609 | 7 | 0 | 53.1355 | -57.6604 | 2021-09-23 04:21:43 | Newfoundland and Labrador, Canada | |||
3757242 | 3757242 | 2021-09-21 | Canada | Newfoundland and Labrador | 1586 | 7 | 0 | 53.1355 | -57.6604 | 2021-09-22 04:21:45 | Newfoundland and Labrador, Canada | |||
809345 | 809345 | 2021-09-20 | Canada | Newfoundland and Labrador | 1570 | 7 | 0 | 53.1355 | -57.6604 | 2021-09-21 04:21:26 | Newfoundland and Labrador, Canada | |||
1814544 | 1814544 | 2021-09-19 | Canada | Newfoundland and Labrador | 1555 | 7 | 0 | 53.1355 | -57.6604 | 2021-09-20 04:21:22 | Newfoundland and Labrador, Canada | |||
16124 | 16124 | 2021-09-18 | Canada | Newfoundland and Labrador | 1555 | 7 | 0 | 53.1355 | -57.6604 | 2021-09-19 04:21:34 | Newfoundland and Labrador, Canada | |||
2617809 | 2617809 | 2021-09-17 | Canada | Newfoundland and Labrador | 1555 | 7 | 0 | 53.1355 | -57.6604 | 2021-09-18 04:21:24 | Newfoundland and Labrador, Canada | |||
2808517 | 2808517 | 2021-09-16 | Canada | Newfoundland and Labrador | 1551 | 7 | 0 | 53.1355 | -57.6604 | 2021-09-17 04:21:46 | Newfoundland and Labrador, Canada | |||
1374262 | 1374262 | 2021-09-15 | Canada | Newfoundland and Labrador | 1551 | 7 | 0 | 53.1355 | -57.6604 | 2021-09-16 04:22:19 | Newfoundland and Labrador, Canada | |||
2462561 | 2462561 | 2021-09-14 | Canada | Newfoundland and Labrador | 1541 | 7 | 0 | 53.1355 | -57.6604 | 2021-09-15 03:22:37 | Newfoundland and Labrador, Canada | |||
1385400 | 1385400 | 2021-09-13 | Canada | Newfoundland and Labrador | 1541 | 7 | 0 | 53.1355 | -57.6604 | 2021-09-14 04:21:41 | Newfoundland and Labrador, Canada | |||
1884769 | 1884769 | 2021-09-12 | Canada | Newfoundland and Labrador | 1532 | 7 | 0 | 53.1355 | -57.6604 | 2021-09-13 04:21:15 | Newfoundland and Labrador, Canada | |||
3805672 | 3805672 | 2021-09-11 | Canada | Newfoundland and Labrador | 1532 | 7 | 0 | 53.1355 | -57.6604 | 2021-09-12 04:21:13 | Newfoundland and Labrador, Canada | |||
3448612 | 3448612 | 2021-09-10 | Canada | Newfoundland and Labrador | 1532 | 7 | 0 | 53.1355 | -57.6604 | 2021-09-11 04:21:30 | Newfoundland and Labrador, Canada | |||
1262558 | 1262558 | 2021-09-09 | Canada | Newfoundland and Labrador | 1520 | 7 | 0 | 53.1355 | -57.6604 | 2021-09-10 04:21:20 | Newfoundland and Labrador, Canada | |||
2278928 | 2278928 | 2021-09-08 | Canada | Newfoundland and Labrador | 1520 | 7 | 0 | 53.1355 | -57.6604 | 2021-09-09 04:21:27 | Newfoundland and Labrador, Canada | |||
641707 | 641707 | 2021-09-07 | Canada | Newfoundland and Labrador | 1511 | 7 | 0 | 53.1355 | -57.6604 | 2021-09-08 04:21:31 | Newfoundland and Labrador, Canada | |||
3193770 | 3193770 | 2021-09-06 | Canada | Newfoundland and Labrador | 1506 | 7 | 0 | 53.1355 | -57.6604 | 2021-09-07 04:21:35 | Newfoundland and Labrador, Canada | |||
3280638 | 3280638 | 2021-09-05 | Canada | Newfoundland and Labrador | 1491 | 7 | 0 | 53.1355 | -57.6604 | 2021-09-06 04:21:22 | Newfoundland and Labrador, Canada | |||
249052 | 249052 | 2021-09-04 | Canada | Newfoundland and Labrador | 1491 | 7 | 0 | 53.1355 | -57.6604 | 2021-09-05 04:21:33 | Newfoundland and Labrador, Canada | |||
3974333 | 3974333 | 2021-09-03 | Canada | Newfoundland and Labrador | 1491 | 7 | 0 | 53.1355 | -57.6604 | 2021-09-04 04:21:28 | Newfoundland and Labrador, Canada | |||
177795 | 177795 | 2021-09-02 | Canada | Newfoundland and Labrador | 1486 | 7 | 0 | 53.1355 | -57.6604 | 2021-09-03 04:21:20 | Newfoundland and Labrador, Canada | |||
66830 | 66830 | 2021-09-01 | Canada | Newfoundland and Labrador | 1486 | 7 | 0 | 53.1355 | -57.6604 | 2021-09-02 04:21:15 | Newfoundland and Labrador, Canada | |||
2067672 | 2067672 | 2021-08-31 | Canada | Newfoundland and Labrador | 1478 | 7 | 0 | 53.1355 | -57.6604 | 2021-09-01 04:21:38 | Newfoundland and Labrador, Canada | |||
1775126 | 1775126 | 2021-08-30 | Canada | Newfoundland and Labrador | 1478 | 7 | 0 | 53.1355 | -57.6604 | 2021-08-31 04:21:46 | Newfoundland and Labrador, Canada | |||
3891700 | 3891700 | 2021-08-29 | Canada | Newfoundland and Labrador | 1469 | 7 | 0 | 53.1355 | -57.6604 | 2021-08-30 04:21:23 | Newfoundland and Labrador, Canada | |||
2792803 | 2792803 | 2021-08-28 | Canada | Newfoundland and Labrador | 1469 | 7 | 0 | 53.1355 | -57.6604 | 2021-08-29 04:21:14 | Newfoundland and Labrador, Canada | |||
2922962 | 2922962 | 2021-08-27 | Canada | Newfoundland and Labrador | 1469 | 7 | 0 | 53.1355 | -57.6604 | 2021-08-28 04:21:28 | Newfoundland and Labrador, Canada | |||
1595976 | 1595976 | 2021-08-26 | Canada | Newfoundland and Labrador | 1462 | 7 | 0 | 53.1355 | -57.6604 | 2021-08-27 04:21:37 | Newfoundland and Labrador, Canada | |||
32185 | 32185 | 2021-08-25 | Canada | Newfoundland and Labrador | 1462 | 7 | 0 | 53.1355 | -57.6604 | 2021-08-26 04:21:28 | Newfoundland and Labrador, Canada | |||
3105224 | 3105224 | 2021-08-24 | Canada | Newfoundland and Labrador | 1460 | 7 | 0 | 53.1355 | -57.6604 | 2021-08-25 04:21:41 | Newfoundland and Labrador, Canada | |||
3165395 | 3165395 | 2021-08-23 | Canada | Newfoundland and Labrador | 1460 | 7 | 0 | 53.1355 | -57.6604 | 2021-08-24 04:21:19 | Newfoundland and Labrador, Canada | |||
2175322 | 2175322 | 2021-08-22 | Canada | Newfoundland and Labrador | 1458 | 7 | 0 | 53.1355 | -57.6604 | 2021-08-23 04:21:27 | Newfoundland and Labrador, Canada | |||
3555418 | 3555418 | 2021-08-21 | Canada | Newfoundland and Labrador | 1458 | 7 | 0 | 53.1355 | -57.6604 | 2021-08-22 04:21:29 | Newfoundland and Labrador, Canada | |||
1853760 | 1853760 | 2021-08-20 | Canada | Newfoundland and Labrador | 1458 | 7 | 0 | 53.1355 | -57.6604 | 2021-08-21 04:21:38 | Newfoundland and Labrador, Canada | |||
511467 | 511467 | 2021-08-19 | Canada | Newfoundland and Labrador | 1456 | 7 | 0 | 53.1355 | -57.6604 | 2021-08-20 04:21:33 | Newfoundland and Labrador, Canada | |||
2517946 | 2517946 | 2021-08-18 | Canada | Newfoundland and Labrador | 1456 | 7 | 0 | 53.1355 | -57.6604 | 2021-08-19 04:21:15 | Newfoundland and Labrador, Canada | |||
245038 | 245038 | 2021-08-17 | Canada | Newfoundland and Labrador | 1450 | 7 | 0 | 53.1355 | -57.6604 | 2021-08-18 04:21:35 | Newfoundland and Labrador, Canada | |||
1604001 | 1604001 | 2021-08-16 | Canada | Newfoundland and Labrador | 1450 | 7 | 0 | 53.1355 | -57.6604 | 2021-08-17 04:21:49 | Newfoundland and Labrador, Canada | |||
103095 | 103095 | 2021-08-15 | Canada | Newfoundland and Labrador | 1447 | 7 | 0 | 53.1355 | -57.6604 | 2021-08-16 04:21:31 | Newfoundland and Labrador, Canada | |||
507453 | 507453 | 2021-08-14 | Canada | Newfoundland and Labrador | 1447 | 7 | 0 | 53.1355 | -57.6604 | 2021-08-15 04:21:41 | Newfoundland and Labrador, Canada | |||
1483325 | 1483325 | 2021-08-13 | Canada | Newfoundland and Labrador | 1447 | 7 | 0 | 53.1355 | -57.6604 | 2021-08-14 04:21:25 | Newfoundland and Labrador, Canada | |||
2899455 | 2899455 | 2021-08-12 | Canada | Newfoundland and Labrador | 1443 | 7 | 0 | 53.1355 | -57.6604 | 2021-08-13 04:21:24 | Newfoundland and Labrador, Canada | |||
1342059 | 1342059 | 2021-08-11 | Canada | Newfoundland and Labrador | 1443 | 7 | 0 | 53.1355 | -57.6604 | 2021-08-12 04:21:25 | Newfoundland and Labrador, Canada | |||
2351206 | 2351206 | 2021-08-10 | Canada | Newfoundland and Labrador | 1443 | 7 | 0 | 53.1355 | -57.6604 | 2021-08-11 04:21:58 | Newfoundland and Labrador, Canada | |||
649735 | 649735 | 2021-08-09 | Canada | Newfoundland and Labrador | 1443 | 7 | 0 | 53.1355 | -57.6604 | 2021-08-10 04:21:27 | Newfoundland and Labrador, Canada | |||
589397 | 589397 | 2021-08-08 | Canada | Newfoundland and Labrador | 1443 | 7 | 0 | 53.1355 | -57.6604 | 2021-08-09 04:21:24 | Newfoundland and Labrador, Canada | |||
2203409 | 2203409 | 2021-08-07 | Canada | Newfoundland and Labrador | 1443 | 7 | 0 | 53.1355 | -57.6604 | 2021-08-08 04:21:33 | Newfoundland and Labrador, Canada | |||
1117359 | 1117359 | 2021-08-06 | Canada | Newfoundland and Labrador | 1443 | 7 | 0 | 53.1355 | -57.6604 | 2021-08-07 04:21:30 | Newfoundland and Labrador, Canada | |||
1956296 | 1956296 | 2021-08-05 | Canada | Newfoundland and Labrador | 1441 | 7 | 0 | 53.1355 | -57.6604 | 2021-08-06 04:21:18 | Newfoundland and Labrador, Canada | |||
331675 | 331675 | 2021-08-04 | Canada | Newfoundland and Labrador | 1441 | 7 | 1421 | 13 | 53.1355 | -57.6604 | 2021-08-05 04:21:51 | Newfoundland and Labrador, Canada | ||
3467946 | 3467946 | 2021-08-03 | Canada | Newfoundland and Labrador | 1440 | 7 | 1421 | 12 | 53.1355 | -57.6604 | 2021-08-04 04:21:25 | Newfoundland and Labrador, Canada | ||
3683220 | 3683220 | 2021-08-02 | Canada | Newfoundland and Labrador | 1440 | 7 | 1421 | 12 | 53.1355 | -57.6604 | 2021-08-03 04:21:39 | Newfoundland and Labrador, Canada | ||
3015119 | 3015119 | 2021-08-01 | Canada | Newfoundland and Labrador | 1437 | 7 | 1421 | 9 | 53.1355 | -57.6604 | 2021-08-02 04:21:36 | Newfoundland and Labrador, Canada | ||
3903742 | 3903742 | 2021-07-31 | Canada | Newfoundland and Labrador | 1437 | 7 | 1421 | 9 | 53.1355 | -57.6604 | 2021-08-01 04:21:50 | Newfoundland and Labrador, Canada | ||
3295947 | 3295947 | 2021-07-30 | Canada | Newfoundland and Labrador | 1437 | 7 | 1421 | 9 | 53.1355 | -57.6604 | 2021-07-31 04:21:35 | Newfoundland and Labrador, Canada | ||
3385158 | 3385158 | 2021-07-29 | Canada | Newfoundland and Labrador | 1437 | 7 | 1421 | 9 | 53.1355 | -57.6604 | 2021-07-30 04:21:34 | Newfoundland and Labrador, Canada | ||
408063 | 408063 | 2021-07-28 | Canada | Newfoundland and Labrador | 1437 | 7 | 1421 | 9 | 53.1355 | -57.6604 | 2021-07-29 04:21:33 | Newfoundland and Labrador, Canada | ||
1305924 | 1305924 | 2021-07-27 | Canada | Newfoundland and Labrador | 1437 | 7 | 1391 | 39 | 53.1355 | -57.6604 | 2021-07-28 04:21:39 | Newfoundland and Labrador, Canada | ||
3218067 | 3218067 | 2021-07-26 | Canada | Newfoundland and Labrador | 1437 | 7 | 1391 | 39 | 53.1355 | -57.6604 | 2021-07-27 04:21:18 | Newfoundland and Labrador, Canada | ||
1378276 | 1378276 | 2021-07-25 | Canada | Newfoundland and Labrador | 1437 | 7 | 1391 | 39 | 53.1355 | -57.6604 | 2021-07-26 04:21:28 | Newfoundland and Labrador, Canada | ||
1330016 | 1330016 | 2021-07-24 | Canada | Newfoundland and Labrador | 1437 | 7 | 1391 | 39 | 53.1355 | -57.6604 | 2021-07-25 04:22:12 | Newfoundland and Labrador, Canada | ||
3137320 | 3137320 | 2021-07-23 | Canada | Newfoundland and Labrador | 1437 | 7 | 1391 | 39 | 53.1355 | -57.6604 | 2021-07-24 00:21:36 | Newfoundland and Labrador, Canada | ||
3476080 | 3476080 | 2021-07-22 | Canada | Newfoundland and Labrador | 1437 | 7 | 1377 | 53 | 53.1355 | -57.6604 | 2021-07-23 04:21:29 | Newfoundland and Labrador, Canada | ||
3331299 | 3331299 | 2021-07-21 | Canada | Newfoundland and Labrador | 1437 | 7 | 1377 | 53 | 53.1355 | -57.6604 | 2021-07-22 04:21:19 | Newfoundland and Labrador, Canada | ||
2371280 | 2371280 | 2021-07-20 | Canada | Newfoundland and Labrador | 1437 | 7 | 1377 | 53 | 53.1355 | -57.6604 | 2021-07-21 04:21:40 | Newfoundland and Labrador, Canada | ||
483359 | 483359 | 2021-07-19 | Canada | Newfoundland and Labrador | 1437 | 7 | 1376 | 54 | 53.1355 | -57.6604 | 2021-07-20 04:21:48 | Newfoundland and Labrador, Canada | ||
2673582 | 2673582 | 2021-07-18 | Canada | Newfoundland and Labrador | 1433 | 7 | 1376 | 50 | 53.1355 | -57.6604 | 2021-07-19 04:21:24 | Newfoundland and Labrador, Canada | ||
3705894 | 3705894 | 2021-07-17 | Canada | Newfoundland and Labrador | 1433 | 7 | 1376 | 50 | 53.1355 | -57.6604 | 2021-07-18 04:22:07 | Newfoundland and Labrador, Canada | ||
2947125 | 2947125 | 2021-07-16 | Canada | Newfoundland and Labrador | 1433 | 7 | 1376 | 50 | 53.1355 | -57.6604 | 2021-07-17 04:22:22 | Newfoundland and Labrador, Canada | ||
295781 | 295781 | 2021-07-15 | Canada | Newfoundland and Labrador | 1433 | 7 | 1376 | 50 | 53.1355 | -57.6604 | 2021-07-16 04:21:22 | Newfoundland and Labrador, Canada | ||
3631726 | 3631726 | 2021-07-14 | Canada | Newfoundland and Labrador | 1410 | 7 | 1376 | 27 | 53.1355 | -57.6604 | 2021-07-15 04:21:48 | Newfoundland and Labrador, Canada | ||
578601 | 578601 | 2021-07-13 | Canada | Newfoundland and Labrador | 1407 | 7 | 1376 | 24 | 53.1355 | -57.6604 | 2021-07-14 04:21:35 | Newfoundland and Labrador, Canada | ||
3740850 | 3740850 | 2021-07-12 | Canada | Newfoundland and Labrador | 1402 | 7 | 1375 | 20 | 53.1355 | -57.6604 | 2021-07-13 04:21:18 | Newfoundland and Labrador, Canada | ||
3659363 | 3659363 | 2021-07-11 | Canada | Newfoundland and Labrador | 1402 | 7 | 1375 | 20 | 53.1355 | -57.6604 | 2021-07-12 04:21:34 | Newfoundland and Labrador, Canada | ||
625647 | 625647 | 2021-07-10 | Canada | Newfoundland and Labrador | 1402 | 7 | 1375 | 20 | 53.1355 | -57.6604 | 2021-07-11 04:21:43 | Newfoundland and Labrador, Canada | ||
829366 | 829366 | 2021-07-09 | Canada | Newfoundland and Labrador | 1402 | 7 | 1375 | 20 | 53.1355 | -57.6604 | 2021-07-10 04:21:25 | Newfoundland and Labrador, Canada | ||
778130 | 778130 | 2021-07-08 | Canada | Newfoundland and Labrador | 1400 | 7 | 1375 | 18 | 53.1355 | -57.6604 | 2021-07-09 04:21:21 | Newfoundland and Labrador, Canada | ||
1440352 | 1440352 | 2021-07-07 | Canada | Newfoundland and Labrador | 1400 | 7 | 1375 | 18 | 53.1355 | -57.6604 | 2021-07-08 04:21:26 | Newfoundland and Labrador, Canada | ||
2693457 | 2693457 | 2021-07-06 | Canada | Newfoundland and Labrador | 1400 | 7 | 1373 | 20 | 53.1355 | -57.6604 | 2021-07-07 04:21:20 | Newfoundland and Labrador, Canada | ||
1932206 | 1932206 | 2021-07-05 | Canada | Newfoundland and Labrador | 1400 | 7 | 1372 | 21 | 53.1355 | -57.6604 | 2021-07-06 04:21:32 | Newfoundland and Labrador, Canada | ||
1164937 | 1164937 | 2021-07-04 | Canada | Newfoundland and Labrador | 1387 | 7 | 1372 | 8 | 53.1355 | -57.6604 | 2021-07-05 04:21:28 | Newfoundland and Labrador, Canada | ||
1495371 | 1495371 | 2021-07-03 | Canada | Newfoundland and Labrador | 1387 | 7 | 1372 | 8 | 53.1355 | -57.6604 | 2021-07-04 04:21:38 | Newfoundland and Labrador, Canada | ||
2071686 | 2071686 | 2021-07-02 | Canada | Newfoundland and Labrador | 1387 | 7 | 1372 | 8 | 53.1355 | -57.6604 | 2021-07-03 04:21:37 | Newfoundland and Labrador, Canada | ||
2764702 | 2764702 | 2021-07-01 | Canada | Newfoundland and Labrador | 1386 | 7 | 1370 | 9 | 53.1355 | -57.6604 | 2021-07-02 04:21:47 | Newfoundland and Labrador, Canada | ||
1892910 | 1892910 | 2021-06-30 | Canada | Newfoundland and Labrador | 1386 | 7 | 1370 | 9 | 53.1355 | -57.6604 | 2021-07-01 04:21:19 | Newfoundland and Labrador, Canada | ||
400033 | 400033 | 2021-06-29 | Canada | Newfoundland and Labrador | 1385 | 7 | 1369 | 9 | 53.1355 | -57.6604 | 2021-06-30 04:21:41 | Newfoundland and Labrador, Canada | ||
3125276 | 3125276 | 2021-06-28 | Canada | Newfoundland and Labrador | 1385 | 7 | 1368 | 10 | 53.1355 | -57.6604 | 2021-06-29 04:21:28 | Newfoundland and Labrador, Canada | ||
2589771 | 2589771 | 2021-06-27 | Canada | Newfoundland and Labrador | 1384 | 7 | 1366 | 11 | 53.1355 | -57.6604 | 2021-06-28 04:21:29 | Newfoundland and Labrador, Canada | ||
3958275 | 3958275 | 2021-06-26 | Canada | Newfoundland and Labrador | 1384 | 7 | 1366 | 11 | 53.1355 | -57.6604 | 2021-06-27 04:21:39 | Newfoundland and Labrador, Canada | ||
1712094 | 1712094 | 2021-06-25 | Canada | Newfoundland and Labrador | 1384 | 7 | 1366 | 11 | 53.1355 | -57.6604 | 2021-06-26 04:21:43 | Newfoundland and Labrador, Canada | ||
2295219 | 2295219 | 2021-06-24 | Canada | Newfoundland and Labrador | 1384 | 7 | 1366 | 11 | 53.1355 | -57.6604 | 2021-06-25 04:21:33 | Newfoundland and Labrador, Canada | ||
2422659 | 2422659 | 2021-06-23 | Canada | Newfoundland and Labrador | 1384 | 7 | 1360 | 17 | 53.1355 | -57.6604 | 2021-06-24 04:21:55 | Newfoundland and Labrador, Canada | ||
562736 | 562736 | 2021-06-22 | Canada | Newfoundland and Labrador | 1384 | 7 | 1360 | 17 | 53.1355 | -57.6604 | 2021-06-23 04:21:46 | Newfoundland and Labrador, Canada | ||
3358438 | 3358438 | 2021-06-21 | Canada | Newfoundland and Labrador | 1383 | 7 | 1350 | 26 | 53.1355 | -57.6604 | 2021-06-22 04:21:34 | Newfoundland and Labrador, Canada | ||
2884137 | 2884137 | 2021-06-20 | Canada | Newfoundland and Labrador | 1383 | 7 | 1350 | 26 | 53.1355 | -57.6604 | 2021-06-21 04:21:41 | Newfoundland and Labrador, Canada | ||
107220 | 107220 | 2021-06-19 | Canada | Newfoundland and Labrador | 1383 | 7 | 1350 | 26 | 53.1355 | -57.6604 | 2021-06-20 04:21:48 | Newfoundland and Labrador, 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]);