johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
960 rows where country_or_region = "Italy" and province_or_state = "Emilia-Romagna" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
longitude 2 ✖
- 11.3417208 547
- 11.341720800000001 313
province_or_state 1
- Emilia-Romagna · 860 ✖
country_or_region 1
- Italy · 860 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2016690 | 2016690 | 2022-09-20 | Italy | Emilia-Romagna | 1845520 | 17989 | 0 | 44.49436681 | 11.3417208 | 2022-09-21 04:23:22 | Emilia-Romagna, Italy | |||
3570563 | 3570563 | 2022-09-19 | Italy | Emilia-Romagna | 1844561 | 17984 | 0 | 44.49436681 | 11.3417208 | 2022-09-20 04:22:48 | Emilia-Romagna, Italy | |||
419302 | 419302 | 2022-09-18 | Italy | Emilia-Romagna | 1843830 | 17981 | 0 | 44.49436681 | 11.3417208 | 2022-09-19 04:21:49 | Emilia-Romagna, Italy | |||
3373326 | 3373326 | 2022-09-17 | Italy | Emilia-Romagna | 1842757 | 17979 | 0 | 44.49436681 | 11.3417208 | 2022-09-18 04:22:50 | Emilia-Romagna, Italy | |||
2355434 | 2355434 | 2022-09-16 | Italy | Emilia-Romagna | 1841495 | 17977 | 0 | 44.49436681 | 11.3417208 | 2022-09-17 04:20:19 | Emilia-Romagna, Italy | |||
3986591 | 3986591 | 2022-09-15 | Italy | Emilia-Romagna | 1840265 | 17970 | 0 | 44.49436681 | 11.3417208 | 2022-09-16 04:21:19 | Emilia-Romagna, Italy | |||
1889108 | 1889108 | 2022-09-14 | Italy | Emilia-Romagna | 1838982 | 17965 | 0 | 44.49436681 | 11.3417208 | 2022-09-15 04:21:02 | Emilia-Romagna, Italy | |||
372163 | 372163 | 2022-09-13 | Italy | Emilia-Romagna | 1836555 | 17957 | 0 | 44.49436681 | 11.3417208 | 2022-09-14 04:20:44 | Emilia-Romagna, Italy | |||
2394768 | 2394768 | 2022-09-12 | Italy | Emilia-Romagna | 1836555 | 17957 | 0 | 44.49436681 | 11.3417208 | 2022-09-13 04:20:57 | Emilia-Romagna, Italy | |||
3765846 | 3765846 | 2022-09-11 | Italy | Emilia-Romagna | 1835813 | 17952 | 0 | 44.49436681 | 11.3417208 | 2022-09-12 04:20:58 | Emilia-Romagna, Italy | |||
3824421 | 3824421 | 2022-09-10 | Italy | Emilia-Romagna | 1834705 | 17947 | 0 | 44.49436681 | 11.3417208 | 2022-09-11 04:20:50 | Emilia-Romagna, Italy | |||
962878 | 962878 | 2022-09-09 | Italy | Emilia-Romagna | 1833543 | 17946 | 0 | 44.49436681 | 11.3417208 | 2022-09-10 04:21:10 | Emilia-Romagna, Italy | |||
253280 | 253280 | 2022-09-08 | Italy | Emilia-Romagna | 1832191 | 17939 | 0 | 44.49436681 | 11.3417208 | 2022-09-09 04:21:11 | Emilia-Romagna, Italy | |||
3745078 | 3745078 | 2022-09-07 | Italy | Emilia-Romagna | 1830728 | 17932 | 0 | 44.49436681 | 11.3417208 | 2022-09-08 04:21:02 | Emilia-Romagna, Italy | |||
114718 | 114718 | 2022-09-06 | Italy | Emilia-Romagna | 1829133 | 17925 | 0 | 44.49436681 | 11.3417208 | 2022-09-07 04:20:59 | Emilia-Romagna, Italy | |||
2633690 | 2633690 | 2022-09-05 | Italy | Emilia-Romagna | 1828082 | 17915 | 0 | 44.49436681 | 11.3417208 | 2022-09-06 04:21:02 | Emilia-Romagna, Italy | |||
2987254 | 2987254 | 2022-09-04 | Italy | Emilia-Romagna | 1827232 | 17905 | 0 | 44.49436681 | 11.3417208 | 2022-09-05 04:21:01 | Emilia-Romagna, Italy | |||
2712939 | 2712939 | 2022-09-03 | Italy | Emilia-Romagna | 1825991 | 17903 | 0 | 44.49436681 | 11.3417208 | 2022-09-04 04:21:22 | Emilia-Romagna, Italy | |||
1393644 | 1393644 | 2022-09-02 | Italy | Emilia-Romagna | 1824631 | 17900 | 0 | 44.49436681 | 11.3417208 | 2022-09-03 04:21:04 | Emilia-Romagna, Italy | |||
3547473 | 3547473 | 2022-09-01 | Italy | Emilia-Romagna | 1823059 | 17892 | 0 | 44.49436681 | 11.3417208 | 2022-09-02 04:21:07 | Emilia-Romagna, Italy | |||
2343393 | 2343393 | 2022-08-31 | Italy | Emilia-Romagna | 1821405 | 17889 | 0 | 44.49436681 | 11.3417208 | 2022-09-01 04:21:03 | Emilia-Romagna, Italy | |||
3773873 | 3773873 | 2022-08-30 | Italy | Emilia-Romagna | 1819487 | 17883 | 0 | 44.49436681 | 11.3417208 | 2022-08-31 04:20:57 | Emilia-Romagna, Italy | |||
1680469 | 1680469 | 2022-08-29 | Italy | Emilia-Romagna | 1818180 | 17876 | 0 | 44.49436681 | 11.3417208 | 2022-08-30 04:21:03 | Emilia-Romagna, Italy | |||
1876953 | 1876953 | 2022-08-28 | Italy | Emilia-Romagna | 1817163 | 17864 | 0 | 44.49436681 | 11.3417208 | 2022-08-29 04:21:06 | Emilia-Romagna, Italy | |||
2096080 | 2096080 | 2022-08-27 | Italy | Emilia-Romagna | 1815610 | 17864 | 0 | 44.49436681 | 11.3417208 | 2022-08-28 04:21:02 | Emilia-Romagna, Italy | |||
1531895 | 1531895 | 2022-08-26 | Italy | Emilia-Romagna | 1814104 | 17857 | 0 | 44.49436681 | 11.3417208 | 2022-08-27 04:20:57 | Emilia-Romagna, Italy | |||
2828782 | 2828782 | 2022-08-25 | Italy | Emilia-Romagna | 1812352 | 17849 | 0 | 44.49436681 | 11.3417208 | 2022-08-26 04:21:02 | Emilia-Romagna, Italy | |||
2323315 | 2323315 | 2022-08-24 | Italy | Emilia-Romagna | 1810641 | 17840 | 0 | 44.49436681 | 11.3417208 | 2022-08-25 04:21:13 | Emilia-Romagna, Italy | |||
1250724 | 1250724 | 2022-08-23 | Italy | Emilia-Romagna | 1808469 | 17829 | 0 | 44.49436681 | 11.3417208 | 2022-08-24 04:20:46 | Emilia-Romagna, Italy | |||
2852828 | 2852828 | 2022-08-22 | Italy | Emilia-Romagna | 1806974 | 17807 | 0 | 44.49436681 | 11.3417208 | 2022-08-23 04:20:56 | Emilia-Romagna, Italy | |||
2402800 | 2402800 | 2022-08-21 | Italy | Emilia-Romagna | 1805789 | 17796 | 0 | 44.49436681 | 11.3417208 | 2022-08-22 04:20:38 | Emilia-Romagna, Italy | |||
3797878 | 3797878 | 2022-08-20 | Italy | Emilia-Romagna | 1804062 | 17795 | 0 | 44.49436681 | 11.3417208 | 2022-08-21 04:20:44 | Emilia-Romagna, Italy | |||
2363464 | 2363464 | 2022-08-19 | Italy | Emilia-Romagna | 1802319 | 17787 | 0 | 44.49436681 | 11.3417208 | 2022-08-20 04:21:01 | Emilia-Romagna, Italy | |||
1161135 | 1161135 | 2022-08-18 | Italy | Emilia-Romagna | 1800315 | 17773 | 0 | 44.49436681 | 11.3417208 | 2022-08-19 04:20:54 | Emilia-Romagna, Italy | |||
3950459 | 3950459 | 2022-08-17 | Italy | Emilia-Romagna | 1798024 | 17759 | 0 | 44.49436681 | 11.3417208 | 2022-08-18 04:21:11 | Emilia-Romagna, Italy | |||
990961 | 990961 | 2022-08-16 | Italy | Emilia-Romagna | 1796606 | 17742 | 0 | 44.49436681 | 11.3417208 | 2022-08-17 04:20:59 | Emilia-Romagna, Italy | |||
2494000 | 2494000 | 2022-08-15 | Italy | Emilia-Romagna | 1795912 | 17732 | 0 | 44.49436681 | 11.3417208 | 2022-08-16 04:20:58 | Emilia-Romagna, Italy | |||
3647550 | 3647550 | 2022-08-14 | Italy | Emilia-Romagna | 1794843 | 17722 | 0 | 44.49436681 | 11.3417208 | 2022-08-15 04:20:59 | Emilia-Romagna, Italy | |||
1968556 | 1968556 | 2022-08-13 | Italy | Emilia-Romagna | 1793235 | 17716 | 0 | 44.49436681 | 11.3417208 | 2022-08-14 04:20:55 | Emilia-Romagna, Italy | |||
2888365 | 2888365 | 2022-08-12 | Italy | Emilia-Romagna | 1791309 | 17708 | 0 | 44.49436681 | 11.3417208 | 2022-08-13 04:20:52 | Emilia-Romagna, Italy | |||
3907970 | 3907970 | 2022-08-11 | Italy | Emilia-Romagna | 1789249 | 17695 | 0 | 44.49436681 | 11.3417208 | 2022-08-12 04:20:54 | Emilia-Romagna, Italy | |||
1346287 | 1346287 | 2022-08-10 | Italy | Emilia-Romagna | 1787044 | 17682 | 0 | 44.49436681 | 11.3417208 | 2022-08-11 04:20:49 | Emilia-Romagna, Italy | |||
1086042 | 1086042 | 2022-08-09 | Italy | Emilia-Romagna | 1783556 | 17661 | 0 | 44.49436681 | 11.3417208 | 2022-08-10 04:20:57 | Emilia-Romagna, Italy | |||
3543457 | 3543457 | 2022-08-08 | Italy | Emilia-Romagna | 1782284 | 17638 | 0 | 44.49436681 | 11.3417208 | 2022-08-09 04:20:34 | Emilia-Romagna, Italy | |||
1069860 | 1069860 | 2022-08-07 | Italy | Emilia-Romagna | 1780790 | 17623 | 0 | 44.49436681 | 11.3417208 | 2022-08-08 04:21:08 | Emilia-Romagna, Italy | |||
1940448 | 1940448 | 2022-08-06 | Italy | Emilia-Romagna | 1778323 | 17617 | 0 | 44.49436681 | 11.3417208 | 2022-08-07 04:20:54 | Emilia-Romagna, Italy | |||
880247 | 880247 | 2022-08-05 | Italy | Emilia-Romagna | 1775610 | 17586 | 0 | 44.49436681 | 11.3417208 | 2022-08-06 04:20:56 | Emilia-Romagna, Italy | |||
2008658 | 2008658 | 2022-08-04 | Italy | Emilia-Romagna | 1772388 | 17571 | 0 | 44.49436681 | 11.3417208 | 2022-08-05 04:20:52 | Emilia-Romagna, Italy | |||
1098085 | 1098085 | 2022-08-03 | Italy | Emilia-Romagna | 1768873 | 17561 | 0 | 44.49436681 | 11.3417208 | 2022-08-04 04:20:58 | Emilia-Romagna, Italy | |||
1405010 | 1405010 | 2022-08-02 | Italy | Emilia-Romagna | 1764686 | 17544 | 0 | 44.49436681 | 11.3417208 | 2022-08-03 04:20:59 | Emilia-Romagna, Italy | |||
3617048 | 3617048 | 2022-08-01 | Italy | Emilia-Romagna | 1761791 | 17521 | 0 | 44.49436681 | 11.3417208 | 2022-08-02 04:20:53 | Emilia-Romagna, Italy | |||
3871528 | 3871528 | 2022-07-31 | Italy | Emilia-Romagna | 1759194 | 17503 | 0 | 44.49436681 | 11.3417208 | 2022-08-01 04:21:03 | Emilia-Romagna, Italy | |||
674282 | 674282 | 2022-07-30 | Italy | Emilia-Romagna | 1755934 | 17493 | 0 | 44.49436681 | 11.3417208 | 2022-07-31 04:21:02 | Emilia-Romagna, Italy | |||
1783481 | 1783481 | 2022-07-29 | Italy | Emilia-Romagna | 1751804 | 17482 | 0 | 44.49436681 | 11.3417208 | 2022-07-30 04:20:42 | Emilia-Romagna, Italy | |||
1065844 | 1065844 | 2022-07-28 | Italy | Emilia-Romagna | 1745986 | 17463 | 0 | 44.49436681 | 11.3417208 | 2022-07-29 04:20:45 | Emilia-Romagna, Italy | |||
2335363 | 2335363 | 2022-07-27 | Italy | Emilia-Romagna | 1739994 | 17441 | 0 | 44.49436681 | 11.3417208 | 2022-07-28 04:20:56 | Emilia-Romagna, Italy | |||
1487553 | 1487553 | 2022-07-26 | Italy | Emilia-Romagna | 1735809 | 17418 | 0 | 44.49436681 | 11.3417208 | 2022-07-27 04:21:04 | Emilia-Romagna, Italy | |||
2593999 | 2593999 | 2022-07-25 | Italy | Emilia-Romagna | 1731920 | 17377 | 0 | 44.49436681 | 11.3417208 | 2022-07-26 04:20:58 | Emilia-Romagna, Italy | |||
896114 | 896114 | 2022-07-24 | Italy | Emilia-Romagna | 1728701 | 17360 | 0 | 44.49436681 | 11.3417208 | 2022-07-25 04:20:51 | Emilia-Romagna, Italy | |||
91108 | 91108 | 2022-07-23 | Italy | Emilia-Romagna | 1724270 | 17359 | 0 | 44.49436681 | 11.3417208 | 2022-07-24 04:20:47 | Emilia-Romagna, Italy | |||
900130 | 900130 | 2022-07-22 | Italy | Emilia-Romagna | 1719104 | 17348 | 0 | 44.49436681 | 11.3417208 | 2022-07-23 04:20:53 | Emilia-Romagna, Italy | |||
670266 | 670266 | 2022-07-21 | Italy | Emilia-Romagna | 1713109 | 17335 | 0 | 44.49436681 | 11.3417208 | 2022-07-22 04:21:15 | Emilia-Romagna, Italy | |||
1608229 | 1608229 | 2022-07-20 | Italy | Emilia-Romagna | 1706624 | 17320 | 0 | 44.49436681 | 11.3417208 | 2022-07-21 04:21:10 | Emilia-Romagna, Italy | |||
958862 | 958862 | 2022-07-19 | Italy | Emilia-Romagna | 1699123 | 17293 | 0 | 44.49436681 | 11.3417208 | 2022-07-20 04:20:59 | Emilia-Romagna, Italy | |||
3210249 | 3210249 | 2022-07-18 | Italy | Emilia-Romagna | 1693748 | 17271 | 0 | 44.49436681 | 11.3417208 | 2022-07-19 04:20:58 | Emilia-Romagna, Italy | |||
3405424 | 3405424 | 2022-07-17 | Italy | Emilia-Romagna | 1689574 | 17260 | 0 | 44.49436681 | 11.3417208 | 2022-07-18 04:20:59 | Emilia-Romagna, Italy | |||
2151624 | 2151624 | 2022-07-16 | Italy | Emilia-Romagna | 1683330 | 17256 | 0 | 44.49436681 | 11.3417208 | 2022-07-17 04:21:15 | Emilia-Romagna, Italy | |||
2418857 | 2418857 | 2022-07-15 | Italy | Emilia-Romagna | 1676172 | 17254 | 0 | 44.49436681 | 11.3417208 | 2022-07-16 04:21:05 | Emilia-Romagna, Italy | |||
3428932 | 3428932 | 2022-07-14 | Italy | Emilia-Romagna | 1668396 | 17236 | 0 | 44.49436681 | 11.3417208 | 2022-07-15 04:20:53 | Emilia-Romagna, Italy | |||
3109452 | 3109452 | 2022-07-13 | Italy | Emilia-Romagna | 1659957 | 17227 | 0 | 44.49436681 | 11.3417208 | 2022-07-14 04:20:57 | Emilia-Romagna, Italy | |||
629875 | 629875 | 2022-07-12 | Italy | Emilia-Romagna | 1650274 | 17214 | 0 | 44.49436681 | 11.3417208 | 2022-07-13 04:20:58 | Emilia-Romagna, Italy | |||
1211519 | 1211519 | 2022-07-11 | Italy | Emilia-Romagna | 1643771 | 17193 | 0 | 44.49436681 | 11.3417208 | 2022-07-12 04:20:51 | Emilia-Romagna, Italy | |||
2789001 | 2789001 | 2022-07-10 | Italy | Emilia-Romagna | 1639400 | 17181 | 0 | 44.49436681 | 11.3417208 | 2022-07-11 04:20:46 | Emilia-Romagna, Italy | |||
141954 | 141954 | 2022-07-09 | Italy | Emilia-Romagna | 1632663 | 17177 | 0 | 44.49436681 | 11.3417208 | 2022-07-10 04:20:54 | Emilia-Romagna, Italy | |||
1417054 | 1417054 | 2022-07-08 | Italy | Emilia-Romagna | 1625755 | 17171 | 0 | 44.49436681 | 11.3417208 | 2022-07-09 04:20:59 | Emilia-Romagna, Italy | |||
2740979 | 2740979 | 2022-07-07 | Italy | Emilia-Romagna | 1617992 | 17161 | 0 | 44.49436681 | 11.3417208 | 2022-07-08 04:20:56 | Emilia-Romagna, Italy | |||
1199774 | 1199774 | 2022-07-06 | Italy | Emilia-Romagna | 1609323 | 17152 | 0 | 44.49436681 | 11.3417208 | 2022-07-07 04:20:55 | Emilia-Romagna, Italy | |||
3966517 | 3966517 | 2022-07-05 | Italy | Emilia-Romagna | 1600308 | 17142 | 0 | 44.49436681 | 11.3417208 | 2022-07-06 04:20:58 | Emilia-Romagna, Italy | |||
3078028 | 3078028 | 2022-07-04 | Italy | Emilia-Romagna | 1594815 | 17133 | 0 | 44.49436681 | 11.3417208 | 2022-07-05 04:20:45 | Emilia-Romagna, Italy | |||
1767310 | 1767310 | 2022-07-03 | Italy | Emilia-Romagna | 1590749 | 17120 | 0 | 44.49436681 | 11.3417208 | 2022-07-04 04:20:54 | Emilia-Romagna, Italy | |||
3365296 | 3365296 | 2022-07-02 | Italy | Emilia-Romagna | 1584598 | 17114 | 0 | 44.49436681 | 11.3417208 | 2022-07-03 04:20:59 | Emilia-Romagna, Italy | |||
593625 | 593625 | 2022-07-01 | Italy | Emilia-Romagna | 1578311 | 17110 | 0 | 44.49436681 | 11.3417208 | 2022-07-02 04:21:16 | Emilia-Romagna, Italy | |||
3940026 | 3940026 | 2022-06-30 | Italy | Emilia-Romagna | 1571638 | 17103 | 0 | 44.49436681 | 11.3417208 | 2022-07-01 04:21:10 | Emilia-Romagna, Italy | |||
2489984 | 2489984 | 2022-06-29 | Italy | Emilia-Romagna | 1565255 | 17096 | 0 | 44.49436681 | 11.3417208 | 2022-06-30 04:21:01 | Emilia-Romagna, Italy | |||
2239366 | 2239366 | 2022-06-28 | Italy | Emilia-Romagna | 1558499 | 17089 | 0 | 44.49436681 | 11.3417208 | 2022-06-29 04:20:59 | Emilia-Romagna, Italy | |||
2147608 | 2147608 | 2022-06-27 | Italy | Emilia-Romagna | 1554149 | 17081 | 0 | 44.49436681 | 11.3417208 | 2022-06-28 04:20:58 | Emilia-Romagna, Italy | |||
475409 | 475409 | 2022-06-26 | Italy | Emilia-Romagna | 1551189 | 17069 | 0 | 44.49436681 | 11.3417208 | 2022-06-27 04:21:00 | Emilia-Romagna, Italy | |||
938784 | 938784 | 2022-06-25 | Italy | Emilia-Romagna | 1546702 | 17066 | 0 | 44.49436681 | 11.3417208 | 2022-06-26 04:21:02 | Emilia-Romagna, Italy | |||
3346604 | 3346604 | 2022-06-24 | Italy | Emilia-Romagna | 1542157 | 17066 | 0 | 44.49436681 | 11.3417208 | 2022-06-25 04:20:57 | Emilia-Romagna, Italy | |||
1648345 | 1648345 | 2022-06-23 | Italy | Emilia-Romagna | 1537383 | 17057 | 0 | 44.49436681 | 11.3417208 | 2022-06-24 04:20:58 | Emilia-Romagna, Italy | |||
2187580 | 2187580 | 2022-06-22 | Italy | Emilia-Romagna | 1533213 | 17052 | 0 | 44.49436681 | 11.3417208 | 2022-06-23 04:20:55 | Emilia-Romagna, Italy | |||
166011 | 166011 | 2022-06-21 | Italy | Emilia-Romagna | 1528629 | 17045 | 0 | 44.49436681 | 11.3417208 | 2022-06-22 04:20:54 | Emilia-Romagna, Italy | |||
1763294 | 1763294 | 2022-06-20 | Italy | Emilia-Romagna | 1525174 | 17042 | 0 | 44.49436681 | 11.3417208 | 2022-06-21 04:20:56 | Emilia-Romagna, Italy | |||
3269480 | 3269480 | 2022-06-19 | Italy | Emilia-Romagna | 1523449 | 17034 | 0 | 44.49436681 | 11.3417208 | 2022-06-20 04:21:01 | Emilia-Romagna, Italy | |||
3397392 | 3397392 | 2022-06-18 | Italy | Emilia-Romagna | 1520964 | 17033 | 0 | 44.49436681 | 11.3417208 | 2022-06-19 04:20:51 | Emilia-Romagna, Italy | |||
2311269 | 2311269 | 2022-06-17 | Italy | Emilia-Romagna | 1517809 | 17031 | 0 | 44.49436681 | 11.3417208 | 2022-06-18 04:21:10 | Emilia-Romagna, Italy | |||
558773 | 558773 | 2022-06-16 | Italy | Emilia-Romagna | 1514692 | 17026 | 0 | 44.49436681 | 11.3417208 | 2022-06-17 04:20:56 | Emilia-Romagna, Italy | |||
3982575 | 3982575 | 2022-06-15 | Italy | Emilia-Romagna | 1511020 | 17021 | 0 | 44.49436681 | 11.3417208 | 2022-06-16 04:20:55 | Emilia-Romagna, Italy | |||
946816 | 946816 | 2022-06-14 | Italy | Emilia-Romagna | 1508347 | 17017 | 0 | 44.49436681 | 11.3417208 | 2022-06-15 04:20:54 | Emilia-Romagna, Italy | |||
2979224 | 2979224 | 2022-06-13 | Italy | Emilia-Romagna | 1506612 | 17012 | 0 | 44.49436681 | 11.3417208 | 2022-06-14 04:20:52 | Emilia-Romagna, Italy |
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]);