johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
394 rows where active = 554 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 29
- US 324
- Russia 9
- Chile 6
- Colombia 6
- Japan 5
- Mexico 5
- Guinea-Bissau 4
- Australia 3
- Cabo Verde 3
- Eritrea 3
- Ghana 3
- India 3
- United Kingdom 3
- Italy 2
- China 1
- Costa Rica 1
- Cote d'Ivoire 1
- Germany 1
- Hungary 1
- Laos 1
- Malaysia 1
- Mali 1
- Malta 1
- Netherlands 1
- Pakistan 1
- Paraguay 1
- Taiwan* 1
- Ukraine 1
- Uzbekistan 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3385333 | 3385333 | 2021-07-29 | India | Delhi | 1436144 | 25049 | 1410541 | 554 | 28.646519 | 77.10898 | 2021-07-30 04:21:34 | Delhi, India | ||
2673792 | 2673792 | 2021-07-18 | Italy | Basilicata | 27091 | 591 | 25946 | 554 | 40.63947052 | 15.80514834 | 2021-07-19 04:21:24 | Basilicata, Italy | ||
3705885 | 3705885 | 2021-07-17 | Cabo Verde | 33270 | 295 | 32421 | 554 | 16.5388 | -23.0418 | 2021-07-18 04:22:07 | Cabo Verde | |||
578811 | 578811 | 2021-07-13 | Italy | Basilicata | 27044 | 591 | 25899 | 554 | 40.63947052 | 15.80514834 | 2021-07-14 04:21:35 | Basilicata, Italy | ||
829357 | 829357 | 2021-07-09 | Cabo Verde | 32928 | 289 | 32085 | 554 | 16.5388 | -23.0418 | 2021-07-10 04:21:25 | Cabo Verde | |||
2593642 | 2593642 | 2021-06-27 | Ukraine | Sumy Oblast | 77847 | 1318 | 75975 | 554 | 50.9077 | 34.7981 | 2021-06-28 04:21:29 | Sumy Oblast, Ukraine | ||
2910967 | 2910967 | 2021-06-17 | Chile | Tarapaca | 38177 | 710 | 36913 | 554 | -19.9232 | -69.5132 | 2021-06-18 04:22:16 | Tarapaca, Chile | ||
3381261 | 3381261 | 2021-06-13 | Eritrea | 4848 | 16 | 4278 | 554 | 15.1794 | 39.7823 | 2021-06-14 04:22:46 | Eritrea | |||
1736395 | 1736395 | 2021-06-12 | Eritrea | 4848 | 16 | 4278 | 554 | 15.1794 | 39.7823 | 2021-06-13 04:22:44 | Eritrea | |||
3970436 | 3970436 | 2021-06-11 | Eritrea | 4848 | 16 | 4278 | 554 | 15.1794 | 39.7823 | 2021-06-12 04:22:22 | Eritrea | |||
825378 | 825378 | 2021-06-06 | Chile | Tarapaca | 37306 | 683 | 36069 | 554 | -19.9232 | -69.5132 | 2021-06-07 04:22:51 | Tarapaca, Chile | ||
1806540 | 1806540 | 2021-05-27 | Chile | Tarapaca | 36453 | 667 | 35232 | 554 | -19.9232 | -69.5132 | 2021-05-28 04:20:36 | Tarapaca, Chile | ||
1310376 | 1310376 | 2021-05-26 | Russia | Kemerovo Oblast | 36695 | 713 | 35428 | 554 | 54.53357809999999 | 87.342861 | 2021-05-27 04:20:59 | Kemerovo Oblast, Russia | ||
1310198 | 1310198 | 2021-05-26 | Japan | Oita | 3269 | 40 | 2675 | 554 | 33.200697 | 131.43323999999998 | 2021-05-27 04:20:59 | Oita, Japan | ||
83302 | 83302 | 2021-05-25 | Russia | Kemerovo Oblast | 36640 | 710 | 35376 | 554 | 54.53357809999999 | 87.342861 | 2021-05-26 04:20:35 | Kemerovo Oblast, Russia | ||
2939655 | 2939655 | 2021-05-16 | Taiwan* | 1682 | 12 | 1116 | 554 | 23.7 | 121.0 | 2021-05-17 04:20:34 | Taiwan* | |||
2824807 | 2824807 | 2021-05-01 | Japan | Mie | 3814 | 82 | 3178 | 554 | 34.508018 | 136.376013 | 2021-05-02 04:20:48 | Mie, Japan | ||
383872 | 383872 | 2021-04-30 | Malaysia | Perak | 14747 | 45 | 14148 | 554 | 4.5921 | 101.0901 | 2021-05-01 04:20:47 | Perak, Malaysia | ||
3393451 | 3393451 | 2021-04-28 | Laos | 604 | 0 | 50 | 554 | 19.85627 | 102.495496 | 2021-04-29 04:20:55 | Laos | |||
1568356 | 1568356 | 2021-04-22 | Russia | Tomsk Oblast | 31928 | 386 | 30988 | 554 | 58.6124279 | 82.04753149999998 | 2021-04-23 04:20:52 | Tomsk Oblast, Russia | ||
605893 | 605893 | 2021-04-09 | Russia | Kamchatka Krai | 14241 | 213 | 13474 | 554 | 57.1914882 | 160.03838190000005 | 2021-04-10 04:20:59 | Kamchatka Krai, Russia | ||
2645823 | 2645823 | 2021-04-08 | Malta | 29463 | 401 | 28508 | 554 | 35.9375 | 14.3754 | 2021-04-09 04:21:13 | Malta | |||
1579995 | 1579995 | 2021-03-13 | Colombia | Cesar | 41211 | 1204 | 39453 | 554 | 9.3373 | -73.6536 | 2021-03-14 05:25:37 | Cesar, Colombia | ||
3670388 | 3670388 | 2021-03-06 | US | Puerto Rico | Salinas | 72123 | 554 | 0 | 0 | 554 | 18.010386999999994 | -66.256592 | 2021-03-07 05:21:54 | Salinas, Puerto Rico, US |
3669933 | 3669933 | 2021-03-06 | US | North Carolina | Graham | 37075 | 566 | 12 | 0 | 554 | 35.3506925 | -83.83369267 | 2021-03-07 05:21:54 | Graham, North Carolina, US |
1619009 | 1619009 | 2021-03-05 | US | Puerto Rico | Salinas | 72123 | 554 | 0 | 0 | 554 | 18.010386999999994 | -66.256592 | 2021-03-06 04:23:41 | Salinas, Puerto Rico, US |
1618554 | 1618554 | 2021-03-05 | US | North Carolina | Graham | 37075 | 566 | 12 | 0 | 554 | 35.3506925 | -83.83369267 | 2021-03-06 04:23:41 | Graham, North Carolina, US |
2209965 | 2209965 | 2021-03-04 | US | North Carolina | Graham | 37075 | 566 | 12 | 0 | 554 | 35.3506925 | -83.83369267 | 2021-03-05 05:26:29 | Graham, North Carolina, US |
3068710 | 3068710 | 2021-02-27 | US | Puerto Rico | Barceloneta | 72017 | 554 | 0 | 0 | 554 | 18.445533 | -66.56053100000001 | 2021-02-28 05:22:20 | Barceloneta, Puerto Rico, US |
2186751 | 2186751 | 2021-02-26 | US | Texas | Mitchell | 48335 | 1135 | 29 | 0 | 554 | 32.30623474 | -100.9212058 | 2021-02-27 05:22:28 | Mitchell, Texas, US |
2185639 | 2185639 | 2021-02-26 | US | Nebraska | Dixon | 31051 | 562 | 8 | 0 | 554 | 42.49188363 | -96.86782408 | 2021-02-27 05:22:28 | Dixon, Nebraska, US |
1861173 | 1861173 | 2021-02-25 | US | Texas | Mitchell | 48335 | 1135 | 29 | 0 | 554 | 32.30623474 | -100.9212058 | 2021-02-26 05:22:40 | Mitchell, Texas, US |
1858413 | 1858413 | 2021-02-25 | US | Alaska | Aleutians West | 2016 | 554 | 0 | 0 | 554 | 52.3233 | -174.1596 | 2021-02-26 05:22:40 | Aleutians West, Alaska, US |
471603 | 471603 | 2021-02-19 | Russia | Chechen Republic | 11192 | 111 | 10527 | 554 | 43.39761470000001 | 45.6985005 | 2021-02-20 05:22:51 | Chechen Republic, Russia | ||
1155520 | 1155520 | 2021-02-18 | US | North Dakota | McHenry | 38049 | 578 | 21 | 0 | 554 | 48.23104458 | -100.6324822 | 2021-02-19 05:24:16 | McHenry, North Dakota, US |
1153333 | 1153333 | 2021-02-18 | Russia | Komi Republic | 38621 | 735 | 37332 | 554 | 63.9881421 | 54.3326073 | 2021-02-19 05:24:16 | Komi Republic, Russia | ||
3602968 | 3602968 | 2021-02-17 | US | Missouri | Montgomery | 29139 | 564 | 10 | 0 | 554 | 38.94022054 | -91.47000721 | 2021-02-18 05:22:58 | Montgomery, Missouri, US |
3978361 | 3978361 | 2021-02-10 | Chile | Arica y Parinacota | 13747 | 265 | 12928 | 554 | -18.594 | -69.4785 | 2021-02-11 05:23:55 | Arica y Parinacota, Chile | ||
1527910 | 1527910 | 2021-02-09 | Japan | Ibaraki | 5213 | 81 | 4578 | 554 | 36.303588 | 140.319591 | 2021-02-10 05:22:41 | Ibaraki, Japan | ||
615327 | 615327 | 2021-02-08 | US | Michigan | Kalkaska | 26079 | 568 | 14 | 0 | 554 | 44.68512729 | -85.09085699 | 2021-02-09 05:23:30 | Kalkaska, Michigan, US |
791988 | 791988 | 2021-02-04 | US | Michigan | Baraga | 26013 | 585 | 31 | 0 | 554 | 46.6720582 | -88.36363591 | 2021-02-05 05:22:38 | Baraga, Michigan, US |
343772 | 343772 | 2021-02-03 | US | West Virginia | Pocahontas | 54075 | 563 | 9 | 0 | 554 | 38.32758728 | -80.00993811 | 2021-02-04 05:22:26 | Pocahontas, West Virginia, US |
343442 | 343442 | 2021-02-03 | US | Texas | Mills | 48333 | 686 | 19 | 0 | 554 | 31.49557106 | -98.59272068 | 2021-02-04 05:22:26 | Mills, Texas, US |
341880 | 341880 | 2021-02-03 | US | Michigan | Baraga | 26013 | 585 | 31 | 0 | 554 | 46.6720582 | -88.36363591 | 2021-02-04 05:22:26 | Baraga, Michigan, US |
1461715 | 1461715 | 2021-01-31 | US | Missouri | St. Clair | 29185 | 560 | 6 | 0 | 554 | 38.03699437 | -93.77631447 | 2021-02-01 05:22:53 | St. Clair, Missouri, US |
2214823 | 2214823 | 2021-01-30 | US | Texas | Martin | 48317 | 528 | 18 | 0 | 554 | 32.30600051 | -101.9513518 | 2021-01-31 05:22:42 | Martin, Texas, US |
1900273 | 1900273 | 2021-01-29 | US | Texas | Jack | 48237 | 560 | 13 | 0 | 554 | 33.23377248 | -98.17283469 | 2021-01-30 05:22:49 | Jack, Texas, US |
3157075 | 3157075 | 2021-01-27 | US | West Virginia | Gilmer | 54021 | 560 | 6 | 0 | 554 | 38.9251277 | -80.85952723 | 2021-01-28 05:22:24 | Gilmer, West Virginia, US |
3155410 | 3155410 | 2021-01-27 | US | Mississippi | Jefferson | 28063 | 575 | 21 | 0 | 554 | 31.73397872 | -91.03764977 | 2021-01-28 05:22:24 | Jefferson, Mississippi, US |
15989 | 15989 | 2021-01-26 | United Kingdom | Gibraltar | 4024 | 69 | 3401 | 554 | 36.1408 | -5.3536 | 2021-01-27 05:23:41 | Gibraltar, United Kingdom | ||
2570978 | 2570978 | 2021-01-25 | US | Virginia | Covington | 51580 | 558 | 4 | 0 | 554 | 37.7824656 | -79.98631446 | 2021-01-26 05:22:02 | Covington, Virginia, US |
1761337 | 1761337 | 2021-01-24 | US | Nebraska | Burt | 31021 | 564 | 10 | 0 | 554 | 41.85056773 | -96.32605633 | 2021-01-25 05:22:16 | Burt, Nebraska, US |
2429003 | 2429003 | 2021-01-23 | US | Nebraska | Pierce | 31139 | 574 | 20 | 0 | 554 | 42.26434853 | -97.60122773 | 2021-01-24 05:22:35 | Pierce, Nebraska, US |
437562 | 437562 | 2021-01-21 | US | New Mexico | Torrance | 35057 | 562 | 8 | 0 | 554 | 34.64048375 | -105.8508949 | 2021-01-22 05:22:10 | Torrance, New Mexico, US |
437397 | 437397 | 2021-01-21 | US | Nebraska | Burt | 31021 | 564 | 10 | 0 | 554 | 41.85056773 | -96.32605633 | 2021-01-22 05:22:10 | Burt, Nebraska, US |
1096187 | 1096187 | 2021-01-20 | US | Nebraska | Pierce | 31139 | 574 | 20 | 0 | 554 | 42.26434853 | -97.60122773 | 2021-01-21 05:22:01 | Pierce, Nebraska, US |
909516 | 909516 | 2021-01-19 | US | Kansas | Sherman | 20181 | 564 | 10 | 0 | 554 | 39.35147699 | -101.7197624 | 2021-01-20 05:21:54 | Sherman, Kansas, US |
240393 | 240393 | 2021-01-18 | US | Texas | Lynn | 48305 | 556 | 17 | 0 | 554 | 33.17657705 | -101.8162849 | 2021-01-19 05:22:15 | Lynn, Texas, US |
238579 | 238579 | 2021-01-18 | US | Kansas | Sherman | 20181 | 564 | 10 | 0 | 554 | 39.35147699 | -101.7197624 | 2021-01-19 05:22:15 | Sherman, Kansas, US |
3506510 | 3506510 | 2021-01-17 | US | Texas | Lynn | 48305 | 556 | 17 | 0 | 554 | 33.17657705 | -101.8162849 | 2021-01-18 05:22:34 | Lynn, Texas, US |
3104879 | 3104879 | 2021-01-16 | US | Washington | Klickitat | 53039 | 557 | 3 | 0 | 554 | 45.87325839 | -120.7913598 | 2021-01-17 05:22:17 | Klickitat, Washington, US |
3102985 | 3102985 | 2021-01-16 | US | Maine | Franklin | 23007 | 561 | 7 | 0 | 554 | 44.97330019 | -70.44381045 | 2021-01-17 05:22:17 | Franklin, Maine, US |
3518841 | 3518841 | 2021-01-15 | US | Washington | Klickitat | 53039 | 557 | 3 | 0 | 554 | 45.87325839 | -120.7913598 | 2021-01-16 05:22:40 | Klickitat, Washington, US |
3880519 | 3880519 | 2021-01-14 | US | Idaho | Power | 16077 | 560 | 6 | 0 | 554 | 42.69254894 | -112.83957420000002 | 2021-01-15 05:22:24 | Power, Idaho, US |
776879 | 776879 | 2021-01-12 | US | Oklahoma | Coal | 40029 | 560 | 6 | 0 | 554 | 34.58840127 | -96.29798747 | 2021-01-13 05:22:15 | Coal, Oklahoma, US |
192600 | 192600 | 2021-01-11 | US | Oklahoma | Coal | 40029 | 560 | 6 | 0 | 554 | 34.58840127 | -96.29798747 | 2021-01-12 05:22:15 | Coal, Oklahoma, US |
189929 | 189929 | 2021-01-11 | Colombia | Sucre | 17970 | 686 | 16730 | 554 | 8.814 | -74.7233 | 2021-01-12 05:22:15 | Sucre, Colombia | ||
2627871 | 2627871 | 2021-01-10 | US | Montana | Madison | 30057 | 557 | 3 | 0 | 554 | 45.30080065 | -111.9173017 | 2021-01-11 05:21:50 | Madison, Montana, US |
2627542 | 2627542 | 2021-01-10 | US | Michigan | Presque Isle | 26141 | 572 | 18 | 0 | 554 | 45.34018577 | -83.91498656 | 2021-01-11 05:21:50 | Presque Isle, Michigan, US |
3901630 | 3901630 | 2021-01-09 | US | Michigan | Presque Isle | 26141 | 572 | 18 | 0 | 554 | 45.34018577 | -83.91498656 | 2021-01-10 05:22:12 | Presque Isle, Michigan, US |
157137 | 157137 | 2021-01-08 | US | Texas | Martin | 48317 | 527 | 17 | 0 | 554 | 32.30600051 | -101.9513518 | 2021-01-09 05:22:18 | Martin, Texas, US |
155114 | 155114 | 2021-01-08 | US | Indiana | Switzerland | 18155 | 560 | 6 | 0 | 554 | 38.82767338 | -85.03022429 | 2021-01-09 05:22:18 | Switzerland, Indiana, US |
2543126 | 2543126 | 2021-01-07 | US | Minnesota | Koochiching | 27071 | 563 | 9 | 0 | 554 | 48.24539665 | -93.78352843 | 2021-01-08 05:22:42 | Koochiching, Minnesota, US |
2868017 | 2868017 | 2021-01-06 | US | Virginia | Buena Vista | 51530 | 558 | 4 | 0 | 554 | 37.73484642 | -79.35296097 | 2021-01-07 05:22:03 | Buena Vista, Virginia, US |
2867963 | 2867963 | 2021-01-06 | US | Texas | Winkler | 48495 | 561 | 15 | 0 | 554 | 31.85008651 | -103.0485163 | 2021-01-07 05:22:03 | Winkler, Texas, US |
2867125 | 2867125 | 2021-01-06 | US | North Dakota | Ransom | 38073 | 563 | 12 | 0 | 554 | 46.45621782 | -97.65742504 | 2021-01-07 05:22:03 | Ransom, North Dakota, US |
2865585 | 2865585 | 2021-01-06 | US | Georgia | Taylor | 13269 | 569 | 15 | 0 | 554 | 32.55792548 | -84.25077141 | 2021-01-07 05:22:03 | Taylor, Georgia, US |
3037576 | 3037576 | 2021-01-05 | US | Vermont | Franklin | 50011 | 584 | 30 | 0 | 554 | 44.85627605 | -72.91249563 | 2021-01-06 05:22:16 | Franklin, Vermont, US |
1063759 | 1063759 | 2021-01-04 | US | Missouri | Lewis | 29111 | 557 | 3 | 0 | 554 | 40.09673161 | -91.72070156 | 2021-01-05 05:21:49 | Lewis, Missouri, US |
1063281 | 1063281 | 2021-01-04 | US | Kentucky | McLean | 21149 | 574 | 20 | 0 | 554 | 37.5301951 | -87.26803443 | 2021-01-05 05:21:49 | McLean, Kentucky, US |
2231164 | 2231164 | 2021-01-02 | United Kingdom | Channel Islands | 0 | 0 | 2445 | 554 | 49.3723 | -2.3644 | 2021-01-03 05:22:52 | Channel Islands, United Kingdom | ||
1140528 | 1140528 | 2021-01-01 | United Kingdom | Channel Islands | 0 | 0 | 2445 | 554 | 49.3723 | -2.3644 | 2021-01-02 05:22:33 | Channel Islands, United Kingdom | ||
1138960 | 1138960 | 2021-01-01 | US | Nebraska | Jefferson | 31095 | 555 | 1 | 0 | 554 | 40.17584531 | -97.142601 | 2021-01-02 05:22:33 | Jefferson, Nebraska, US |
3698229 | 3698229 | 2020-12-31 | US | Puerto Rico | Juana Diaz | 72075 | 554 | 0 | 0 | 554 | 18.050764 | -66.49458100000001 | 2021-01-01 05:23:07 | Juana Diaz, Puerto Rico, US |
3697713 | 3697713 | 2020-12-31 | US | New York | Essex | 36031 | 570 | 16 | 0 | 554 | 44.11630765 | -73.77297842 | 2021-01-01 05:23:07 | Essex, New York, US |
3697566 | 3697566 | 2020-12-31 | US | Nebraska | Jefferson | 31095 | 555 | 1 | 0 | 554 | 40.17584531 | -97.142601 | 2021-01-01 05:23:07 | Jefferson, Nebraska, US |
3695954 | 3695954 | 2020-12-31 | US | Arkansas | Cleveland | 5025 | 571 | 17 | 0 | 554 | 33.89723187 | -92.18537045 | 2021-01-01 05:23:07 | Cleveland, Arkansas, US |
769342 | 769342 | 2020-12-29 | US | Texas | Brooks | 48047 | 578 | 27 | 0 | 554 | 27.03103197 | -98.21808402 | 2020-12-30 05:22:34 | Brooks, Texas, US |
3764895 | 3764895 | 2020-12-28 | US | Virginia | Colonial Heights | 51570 | 582 | 28 | 0 | 554 | 37.26420587 | -77.39609676 | 2020-12-29 05:22:37 | Colonial Heights, Virginia, US |
3762566 | 3762566 | 2020-12-28 | US | Illinois | Hamilton | 17065 | 564 | 10 | 0 | 554 | 38.08163641 | -88.53883373 | 2020-12-29 05:22:37 | Hamilton, Illinois, US |
3761435 | 3761435 | 2020-12-28 | Colombia | La Guajira | 14009 | 540 | 12915 | 554 | 11.3548 | -72.5205 | 2020-12-29 05:22:37 | La Guajira, Colombia | ||
3694832 | 3694832 | 2020-12-24 | US | Virginia | Lexington | 51678 | 557 | 3 | 0 | 554 | 37.78258621 | -79.44262866 | 2020-12-25 05:22:48 | Lexington, Virginia, US |
2410320 | 2410320 | 2020-12-23 | US | West Virginia | Monroe | 54063 | 565 | 11 | 0 | 554 | 37.56274716 | -80.54577965 | 2020-12-24 05:23:04 | Monroe, West Virginia, US |
3772939 | 3772939 | 2020-12-22 | US | Texas | Dimmit | 48127 | 603 | 10 | 0 | 554 | 28.42270064 | -99.75645095 | 2020-12-23 05:22:03 | Dimmit, Texas, US |
3771769 | 3771769 | 2020-12-22 | US | Missouri | Gentry | 29075 | 569 | 15 | 0 | 554 | 40.21097916 | -94.40944419 | 2020-12-23 05:22:03 | Gentry, Missouri, US |
3771597 | 3771597 | 2020-12-22 | US | Minnesota | Lac qui Parle | 27073 | 567 | 13 | 0 | 554 | 44.9973857 | -96.17488219 | 2020-12-23 05:22:03 | Lac qui Parle, Minnesota, US |
3771314 | 3771314 | 2020-12-22 | US | Kentucky | Metcalfe | 21169 | 561 | 7 | 0 | 554 | 36.99459295 | -85.63123699 | 2020-12-23 05:22:03 | Metcalfe, Kentucky, US |
928907 | 928907 | 2020-12-21 | US | Iowa | Monroe | 19135 | 570 | 16 | 0 | 554 | 41.02988815 | -92.8690667 | 2020-12-22 05:22:33 | Monroe, Iowa, US |
928505 | 928505 | 2020-12-21 | US | Georgia | Irwin | 13155 | 570 | 16 | 0 | 554 | 31.60213036 | -83.27501387 | 2020-12-22 05:22:33 | Irwin, Georgia, US |
1903736 | 1903736 | 2020-12-18 | US | Oklahoma | Nowata | 40105 | 562 | 8 | 0 | 554 | 36.79843529 | -95.61902331 | 2020-12-19 05:27:52 | Nowata, Oklahoma, US |
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]);