johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
954 rows where country_or_region = "Brazil" and province_or_state = "Minas Gerais" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: last_update (date)
day (date) >30 ✖
- 2020-05-20 1
- 2020-05-21 1
- 2020-05-22 1
- 2020-05-23 1
- 2020-05-24 1
- 2020-05-25 1
- 2020-05-26 1
- 2020-05-27 1
- 2020-05-28 1
- 2020-05-29 1
- 2020-05-30 1
- 2020-05-31 1
- 2020-06-01 1
- 2020-06-02 1
- 2020-06-03 1
- 2020-06-04 1
- 2020-06-05 1
- 2020-06-06 1
- 2020-06-07 1
- 2020-06-08 1
- 2020-06-09 1
- 2020-06-10 1
- 2020-06-11 1
- 2020-06-12 1
- 2020-06-13 1
- 2020-06-14 1
- 2020-06-15 1
- 2020-06-16 1
- 2020-06-17 1
- 2020-06-18 1
- …
province_or_state 1
- Minas Gerais · 954 ✖
country_or_region 1
- Brazil · 954 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths ▼ | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1431919 | 1431919 | 2020-05-20 | Brazil | Minas Gerais | 5286 | 177 | 0 | 5109 | -18.5122 | -44.555 | 2020-05-21 02:32:48 | Minas Gerais, Brazil | ||
268336 | 268336 | 2020-05-21 | Brazil | Minas Gerais | 5596 | 191 | 0 | 5405 | -18.5122 | -44.555 | 2020-05-22 02:36:51 | Minas Gerais, Brazil | ||
1864830 | 1864830 | 2020-05-22 | Brazil | Minas Gerais | 5995 | 201 | 0 | 5794 | -18.5122 | -44.555 | 2020-05-23 02:32:42 | Minas Gerais, Brazil | ||
997807 | 997807 | 2020-05-23 | Brazil | Minas Gerais | 6338 | 217 | 0 | 6121 | -18.5122 | -44.555 | 2020-05-24 02:32:43 | Minas Gerais, Brazil | ||
875616 | 875616 | 2020-05-24 | Brazil | Minas Gerais | 6668 | 226 | 0 | 6442 | -18.5122 | -44.555 | 2020-05-25 02:32:44 | Minas Gerais, Brazil | ||
1104936 | 1104936 | 2020-05-25 | Brazil | Minas Gerais | 6962 | 230 | 0 | 6732 | -18.5122 | -44.555 | 2020-05-26 02:32:35 | Minas Gerais, Brazil | ||
1041206 | 1041206 | 2020-05-26 | Brazil | Minas Gerais | 7516 | 234 | 0 | 7282 | -18.5122 | -44.555 | 2020-05-27 02:32:31 | Minas Gerais, Brazil | ||
2548243 | 2548243 | 2020-05-27 | Brazil | Minas Gerais | 8011 | 240 | 0 | 7771 | -18.5122 | -44.555 | 2020-05-28 02:32:31 | Minas Gerais, Brazil | ||
2712281 | 2712281 | 2020-05-28 | Brazil | Minas Gerais | 8686 | 255 | 0 | 8431 | -18.5122 | -44.555 | 2020-05-29 02:32:50 | Minas Gerais, Brazil | ||
1790402 | 1790402 | 2020-05-29 | Brazil | Minas Gerais | 9232 | 257 | 0 | 8975 | -18.5122 | -44.555 | 2020-05-30 02:32:48 | Minas Gerais, Brazil | ||
3638861 | 3638861 | 2020-05-30 | Brazil | Minas Gerais | 9630 | 263 | 0 | 9367 | -18.5122 | -44.555 | 2020-05-31 02:32:45 | Minas Gerais, Brazil | ||
1793968 | 1793968 | 2020-05-31 | Brazil | Minas Gerais | 10464 | 271 | 0 | 10193 | -18.5122 | -44.555 | 2020-06-01 02:32:46 | Minas Gerais, Brazil | ||
805379 | 805379 | 2020-06-01 | Brazil | Minas Gerais | 10670 | 278 | 0 | 10392 | -18.5122 | -44.555 | 2020-06-02 02:33:08 | Minas Gerais, Brazil | ||
2555842 | 2555842 | 2020-06-02 | Brazil | Minas Gerais | 10939 | 289 | 0 | 10650 | -18.5122 | -44.555 | 2020-06-03 02:33:13 | Minas Gerais, Brazil | ||
3866800 | 3866800 | 2020-06-03 | Brazil | Minas Gerais | 12010 | 306 | 0 | 11704 | -18.5122 | -44.555 | 2020-06-04 02:33:14 | Minas Gerais, Brazil | ||
1281245 | 1281245 | 2020-06-04 | Brazil | Minas Gerais | 13034 | 323 | 0 | 12711 | -18.5122 | -44.555 | 2020-06-05 02:33:06 | Minas Gerais, Brazil | ||
1269773 | 1269773 | 2020-06-05 | Brazil | Minas Gerais | 13995 | 344 | 0 | 13651 | -18.5122 | -44.555 | 2020-06-06 02:33:00 | Minas Gerais, Brazil | ||
574076 | 574076 | 2020-06-06 | Brazil | Minas Gerais | 14939 | 368 | 0 | 14571 | -18.5122 | -44.555 | 2020-06-07 03:53:30 | Minas Gerais, Brazil | ||
2800020 | 2800020 | 2020-06-07 | Brazil | Minas Gerais | 15703 | 376 | 0 | 15327 | -18.5122 | -44.555 | 2020-06-08 03:33:22 | Minas Gerais, Brazil | ||
217224 | 217224 | 2020-06-08 | Brazil | Minas Gerais | 15883 | 380 | 6857 | 8646 | -18.5122 | -44.555 | 2020-06-09 03:33:03 | Minas Gerais, Brazil | ||
1210797 | 1210797 | 2020-06-09 | Brazil | Minas Gerais | 16102 | 399 | 7363 | 8340 | -18.5122 | -44.555 | 2020-06-10 04:07:00 | Minas Gerais, Brazil | ||
2863964 | 2863964 | 2020-06-10 | Brazil | Minas Gerais | 17501 | 409 | 7816 | 9276 | -18.5122 | -44.555 | 2020-06-11 03:33:41 | Minas Gerais, Brazil | ||
1273521 | 1273521 | 2020-06-11 | Brazil | Minas Gerais | 18448 | 431 | 8307 | 9710 | -18.5122 | -44.555 | 2020-06-12 05:09:52 | Minas Gerais, Brazil | ||
737551 | 737551 | 2020-06-12 | Brazil | Minas Gerais | 20106 | 446 | 9822 | 9838 | -18.5122 | -44.555 | 2020-06-13 03:33:14 | Minas Gerais, Brazil | ||
3061231 | 3061231 | 2020-06-13 | Brazil | Minas Gerais | 20614 | 454 | 10647 | 9513 | -18.5122 | -44.555 | 2020-06-14 03:33:15 | Minas Gerais, Brazil | ||
1837179 | 1837179 | 2020-06-14 | Brazil | Minas Gerais | 21381 | 475 | 11156 | 9750 | -18.5122 | -44.555 | 2020-06-15 03:33:14 | Minas Gerais, Brazil | ||
287228 | 287228 | 2020-06-15 | Brazil | Minas Gerais | 21728 | 481 | 11553 | 9694 | -18.5122 | -44.555 | 2020-06-16 04:33:09 | Minas Gerais, Brazil | ||
2386665 | 2386665 | 2020-06-16 | Brazil | Minas Gerais | 22024 | 502 | 11826 | 9696 | -18.5122 | -44.555 | 2020-06-17 04:33:21 | Minas Gerais, Brazil | ||
1195902 | 1195902 | 2020-06-17 | Brazil | Minas Gerais | 23347 | 537 | 12695 | 10115 | -18.5122 | -44.555 | 2020-06-18 04:33:18 | Minas Gerais, Brazil | ||
3682699 | 3682699 | 2020-06-18 | Brazil | Minas Gerais | 24906 | 570 | 13678 | 10658 | -18.5122 | -44.555 | 2020-06-19 04:33:17 | Minas Gerais, Brazil | ||
1691550 | 1691550 | 2020-06-19 | Brazil | Minas Gerais | 26052 | 600 | 15138 | 10314 | -18.5122 | -44.555 | 2020-06-20 04:33:19 | Minas Gerais, Brazil | ||
2437972 | 2437972 | 2020-06-20 | Brazil | Minas Gerais | 27305 | 636 | 15989 | 9427 | -18.5122 | -44.555 | 2020-06-21 04:33:19 | Minas Gerais, Brazil | ||
3249379 | 3249379 | 2020-06-21 | Brazil | Minas Gerais | 27641 | 661 | 16446 | 10534 | -18.5122 | -44.555 | 2020-06-22 04:33:20 | Minas Gerais, Brazil | ||
1510640 | 1510640 | 2020-06-22 | Brazil | Minas Gerais | 28918 | 688 | 17040 | 11190 | -18.5122 | -44.555 | 2020-06-23 04:33:22 | Minas Gerais, Brazil | ||
1522446 | 1522446 | 2020-06-23 | Brazil | Minas Gerais | 29897 | 720 | 17295 | 11882 | -18.5122 | -44.555 | 2020-06-24 04:33:28 | Minas Gerais, Brazil | ||
2700761 | 2700761 | 2020-06-24 | Brazil | Minas Gerais | 31343 | 771 | 18255 | 12317 | -18.5122 | -44.555 | 2020-06-25 05:26:54 | Minas Gerais, Brazil | ||
2625121 | 2625121 | 2020-06-25 | Brazil | Minas Gerais | 32769 | 806 | 19466 | 12497 | -18.5122 | -44.555 | 2020-06-26 04:33:43 | Minas Gerais, Brazil | ||
1136134 | 1136134 | 2020-06-26 | Brazil | Minas Gerais | 38891 | 833 | 20120 | 17938 | -18.5122 | -44.555 | 2020-06-27 04:33:35 | Minas Gerais, Brazil | ||
2039853 | 2039853 | 2020-06-27 | Brazil | Minas Gerais | 40966 | 882 | 23139 | 16945 | -18.5122 | -44.555 | 2020-06-28 04:34:04 | Minas Gerais, Brazil | ||
2306518 | 2306518 | 2020-06-28 | Brazil | Minas Gerais | 42741 | 899 | 24438 | 17404 | -18.5122 | -44.555 | 2020-06-29 04:33:44 | Minas Gerais, Brazil | ||
2632955 | 2632955 | 2020-06-29 | Brazil | Minas Gerais | 43864 | 940 | 25154 | 17770 | -18.5122 | -44.555 | 2020-06-30 04:33:48 | Minas Gerais, Brazil | ||
2974478 | 2974478 | 2020-06-30 | Brazil | Minas Gerais | 45001 | 965 | 26432 | 17604 | -18.5122 | -44.555 | 2020-07-01 04:33:52 | Minas Gerais, Brazil | ||
303100 | 303100 | 2020-07-01 | Brazil | Minas Gerais | 47584 | 1007 | 27912 | 18665 | -18.5122 | -44.555 | 2020-07-02 04:33:46 | Minas Gerais, Brazil | ||
3045409 | 3045409 | 2020-07-02 | Brazil | Minas Gerais | 50707 | 1059 | 30469 | 19179 | -18.5122 | -44.555 | 2020-07-03 04:33:54 | Minas Gerais, Brazil | ||
2234615 | 2234615 | 2020-07-03 | Brazil | Minas Gerais | 53351 | 1110 | 31682 | 20559 | -18.5122 | -44.555 | 2020-07-04 04:33:51 | Minas Gerais, Brazil | ||
529954 | 529954 | 2020-07-04 | Brazil | Minas Gerais | 55958 | 1183 | 33479 | 21296 | -18.5122 | -44.555 | 2020-07-05 04:33:46 | Minas Gerais, Brazil | ||
415392 | 415392 | 2020-07-05 | Brazil | Minas Gerais | 58283 | 1201 | 35622 | 21460 | -18.5122 | -44.555 | 2020-07-06 04:33:57 | Minas Gerais, Brazil | ||
2684927 | 2684927 | 2020-07-06 | Brazil | Minas Gerais | 59626 | 1230 | 37000 | 21396 | -18.5122 | -44.555 | 2020-07-07 04:34:00 | Minas Gerais, Brazil | ||
887367 | 887367 | 2020-07-07 | Brazil | Minas Gerais | 60897 | 1282 | 38554 | 21061 | -18.5122 | -44.555 | 2020-07-08 05:33:48 | Minas Gerais, Brazil | ||
2222758 | 2222758 | 2020-07-08 | Brazil | Minas Gerais | 64035 | 1355 | 40731 | 21949 | -18.5122 | -44.555 | 2020-07-09 04:34:23 | Minas Gerais, Brazil | ||
1005542 | 1005542 | 2020-07-09 | Brazil | Minas Gerais | 66864 | 1445 | 43117 | 22302 | -18.5122 | -44.555 | 2020-07-10 04:34:24 | Minas Gerais, Brazil | ||
3237557 | 3237557 | 2020-07-10 | Brazil | Minas Gerais | 70086 | 1504 | 45145 | 23437 | -18.5122 | -44.555 | 2020-07-11 04:34:26 | Minas Gerais, Brazil | ||
3436059 | 3436059 | 2020-07-11 | Brazil | Minas Gerais | 73813 | 1550 | 49050 | 23213 | -18.5122 | -44.555 | 2020-07-12 04:34:30 | Minas Gerais, Brazil | ||
3737664 | 3737664 | 2020-07-12 | Brazil | Minas Gerais | 75851 | 1576 | 49769 | 24506 | -18.5122 | -44.555 | 2020-07-13 04:43:04 | Minas Gerais, Brazil | ||
3491401 | 3491401 | 2020-07-13 | Brazil | Minas Gerais | 76822 | 1615 | 50510 | 24697 | -18.5122 | -44.555 | 2020-07-14 04:34:46 | Minas Gerais, Brazil | ||
2158760 | 2158760 | 2020-07-14 | Brazil | Minas Gerais | 78643 | 1688 | 53111 | 23844 | -18.5122 | -44.555 | 2020-07-15 04:34:39 | Minas Gerais, Brazil | ||
2748116 | 2748116 | 2020-07-15 | Brazil | Minas Gerais | 82010 | 1752 | 56001 | 24257 | -18.5122 | -44.555 | 2020-07-16 04:44:59 | Minas Gerais, Brazil | ||
367448 | 367448 | 2020-07-16 | Brazil | Minas Gerais | 84470 | 1834 | 57930 | 24706 | -18.5122 | -44.555 | 2020-07-17 04:34:50 | Minas Gerais, Brazil | ||
2708635 | 2708635 | 2020-07-17 | Brazil | Minas Gerais | 87271 | 1904 | 60134 | 25233 | -18.5122 | -44.555 | 2020-07-18 04:34:45 | Minas Gerais, Brazil | ||
3205334 | 3205334 | 2020-07-18 | Brazil | Minas Gerais | 90875 | 1964 | 64245 | 24666 | -18.5122 | -44.555 | 2020-07-19 04:34:58 | Minas Gerais, Brazil | ||
121945 | 121945 | 2020-07-19 | Brazil | Minas Gerais | 92972 | 1982 | 64245 | 26745 | -18.5122 | -44.555 | 2020-07-20 05:34:40 | Minas Gerais, Brazil | ||
327040 | 327040 | 2020-07-20 | Brazil | Minas Gerais | 94132 | 2004 | 66369 | 25759 | -18.5122 | -44.555 | 2020-07-21 04:38:46 | Minas Gerais, Brazil | ||
1707549 | 1707549 | 2020-07-21 | Brazil | Minas Gerais | 95566 | 2071 | 68223 | 25272 | -18.5122 | -44.555 | 2020-07-22 04:34:42 | Minas Gerais, Brazil | ||
844810 | 844810 | 2020-07-22 | Brazil | Minas Gerais | 98741 | 2166 | 71478 | 25097 | -18.5122 | -44.555 | 2020-07-23 05:15:04 | Minas Gerais, Brazil | ||
62006 | 62006 | 2020-07-23 | Brazil | Minas Gerais | 102568 | 2238 | 71478 | 28852 | -18.5122 | -44.555 | 2020-07-24 05:30:40 | Minas Gerais, Brazil | ||
2563790 | 2563790 | 2020-07-24 | Brazil | Minas Gerais | 106812 | 2315 | 76240 | 28257 | -18.5122 | -44.555 | 2020-07-25 04:47:39 | Minas Gerais, Brazil | ||
1502820 | 1502820 | 2020-07-25 | Brazil | Minas Gerais | 110093 | 2404 | 82447 | 25242 | -18.5122 | -44.555 | 2020-07-26 04:35:00 | Minas Gerais, Brazil | ||
442576 | 442576 | 2020-07-26 | Brazil | Minas Gerais | 112571 | 2429 | 83211 | 26931 | -18.5122 | -44.555 | 2020-07-27 04:35:02 | Minas Gerais, Brazil | ||
177263 | 177263 | 2020-07-27 | Brazil | Minas Gerais | 113718 | 2461 | 84335 | 26922 | -18.5122 | -44.555 | 2020-07-28 04:58:43 | Minas Gerais, Brazil | ||
3185212 | 3185212 | 2020-07-28 | Brazil | Minas Gerais | 116645 | 2551 | 86794 | 27300 | -18.5122 | -44.555 | 2020-07-29 04:35:11 | Minas Gerais, Brazil | ||
2958596 | 2958596 | 2020-07-29 | Brazil | Minas Gerais | 119394 | 2608 | 89795 | 26991 | -18.5122 | -44.555 | 2020-07-30 04:35:05 | Minas Gerais, Brazil | ||
1928428 | 1928428 | 2020-07-30 | Brazil | Minas Gerais | 123415 | 2692 | 93768 | 26955 | -18.5122 | -44.555 | 2020-07-31 04:35:18 | Minas Gerais, Brazil | ||
3264721 | 3264721 | 2020-07-31 | Brazil | Minas Gerais | 127106 | 2769 | 97048 | 27289 | -18.5122 | -44.555 | 2020-08-01 04:36:27 | Minas Gerais, Brazil | ||
753556 | 753556 | 2020-08-01 | Brazil | Minas Gerais | 129985 | 2861 | 99598 | 27526 | -18.5122 | -44.555 | 2020-08-02 04:34:47 | Minas Gerais, Brazil | ||
2807988 | 2807988 | 2020-08-02 | Brazil | Minas Gerais | 132801 | 2891 | 101782 | 28128 | -18.5122 | -44.555 | 2020-08-03 04:34:35 | Minas Gerais, Brazil | ||
2740236 | 2740236 | 2020-08-03 | Brazil | Minas Gerais | 133743 | 2894 | 102562 | 28287 | -18.5122 | -44.555 | 2020-08-04 04:41:59 | Minas Gerais, Brazil | ||
98353 | 98353 | 2020-08-04 | Brazil | Minas Gerais | 135728 | 3043 | 104939 | 27895 | -18.5122 | -44.555 | 2020-08-05 04:34:43 | Minas Gerais, Brazil | ||
3793117 | 3793117 | 2020-08-05 | Brazil | Minas Gerais | 139661 | 3195 | 104939 | 31527 | -18.5122 | -44.555 | 2020-08-06 04:35:02 | Minas Gerais, Brazil | ||
3612287 | 3612287 | 2020-08-06 | Brazil | Minas Gerais | 142828 | 3304 | 111801 | 27723 | -18.5122 | -44.555 | 2020-08-07 04:35:11 | Minas Gerais, Brazil | ||
458602 | 458602 | 2020-08-07 | Brazil | Minas Gerais | 147323 | 3381 | 115582 | 28360 | -18.5122 | -44.555 | 2020-08-08 04:34:53 | Minas Gerais, Brazil | ||
371418 | 371418 | 2020-08-08 | Brazil | Minas Gerais | 150723 | 3449 | 119148 | 28126 | -18.5122 | -44.555 | 2020-08-09 04:34:54 | Minas Gerais, Brazil | ||
3923250 | 3923250 | 2020-08-09 | Brazil | Minas Gerais | 153927 | 3537 | 121341 | 29049 | -18.5122 | -44.555 | 2020-08-10 04:34:55 | Minas Gerais, Brazil | ||
1920441 | 1920441 | 2020-08-10 | Brazil | Minas Gerais | 155075 | 3597 | 122478 | 29000 | -18.5122 | -44.555 | 2020-08-11 04:35:08 | Minas Gerais, Brazil | ||
662043 | 662043 | 2020-08-11 | Brazil | Minas Gerais | 156551 | 3613 | 125002 | 27936 | -18.5122 | -44.555 | 2020-08-12 04:27:29 | Minas Gerais, Brazil | ||
3531194 | 3531194 | 2020-08-12 | Brazil | Minas Gerais | 160485 | 3783 | 128957 | 27745 | -18.5122 | -44.555 | 2020-08-13 04:29:15 | Minas Gerais, Brazil | ||
582575 | 582575 | 2020-08-13 | Brazil | Minas Gerais | 164915 | 3846 | 132934 | 28135 | -18.5122 | -44.555 | 2020-08-14 04:51:19 | Minas Gerais, Brazil | ||
1611991 | 1611991 | 2020-08-14 | Brazil | Minas Gerais | 168428 | 3943 | 132934 | 31551 | -18.5122 | -44.555 | 2020-08-15 04:27:31 | Minas Gerais, Brazil | ||
145716 | 145716 | 2020-08-15 | Brazil | Minas Gerais | 171514 | 4044 | 139144 | 28326 | -18.5122 | -44.555 | 2020-08-16 04:27:42 | Minas Gerais, Brazil | ||
1555714 | 1555714 | 2020-08-16 | Brazil | Minas Gerais | 174402 | 4132 | 141083 | 29187 | -18.5122 | -44.555 | 2020-08-17 04:27:20 | Minas Gerais, Brazil | ||
837356 | 837356 | 2020-08-17 | Brazil | Minas Gerais | 175715 | 4223 | 142118 | 29374 | -18.5122 | -44.555 | 2020-08-18 04:27:56 | Minas Gerais, Brazil | ||
3177752 | 3177752 | 2020-08-18 | Brazil | Minas Gerais | 177787 | 4306 | 144132 | 29349 | -18.5122 | -44.555 | 2020-08-19 04:27:00 | Minas Gerais, Brazil | ||
205998 | 205998 | 2020-08-19 | Brazil | Minas Gerais | 181158 | 4436 | 147246 | 29476 | -18.5122 | -44.555 | 2020-08-20 04:27:43 | Minas Gerais, Brazil | ||
3484049 | 3484049 | 2020-08-20 | Brazil | Minas Gerais | 185062 | 4543 | 151391 | 29128 | -18.5122 | -44.555 | 2020-08-21 04:27:41 | Minas Gerais, Brazil | ||
1479300 | 1479300 | 2020-08-21 | Brazil | Minas Gerais | 188623 | 4663 | 155339 | 28621 | -18.5122 | -44.555 | 2020-08-22 04:27:49 | Minas Gerais, Brazil | ||
2299193 | 2299193 | 2020-08-22 | Brazil | Minas Gerais | 191507 | 4737 | 157391 | 29379 | -18.5122 | -44.555 | 2020-08-23 04:27:48 | Minas Gerais, Brazil | ||
2215411 | 2215411 | 2020-08-23 | Brazil | Minas Gerais | 194614 | 4790 | 159130 | 30694 | -18.5122 | -44.555 | 2020-08-24 04:27:56 | Minas Gerais, Brazil | ||
2991016 | 2991016 | 2020-08-24 | Brazil | Minas Gerais | 195920 | 4805 | 160139 | 30976 | -18.5122 | -44.555 | 2020-08-25 04:28:02 | Minas Gerais, Brazil | ||
3562312 | 3562312 | 2020-08-25 | Brazil | Minas Gerais | 198736 | 4847 | 162540 | 31349 | -18.5122 | -44.555 | 2020-08-26 04:28:11 | Minas Gerais, Brazil | ||
1996388 | 1996388 | 2020-08-26 | Brazil | Minas Gerais | 201973 | 4948 | 165541 | 31484 | -18.5122 | -44.555 | 2020-08-27 04:28:15 | Minas Gerais, Brazil | ||
2509928 | 2509928 | 2020-08-27 | Brazil | Minas Gerais | 205942 | 5049 | 169967 | 30926 | -18.5122 | -44.555 | 2020-08-28 04:28:11 | Minas Gerais, Brazil |
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]);