johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
305 rows where active = 723 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 23
- US 259
- Mexico 6
- Russia 6
- Chile 5
- Colombia 4
- Japan 4
- Germany 3
- India 2
- Ukraine 2
- Brazil 1
- Cabo Verde 1
- Cameroon 1
- Cote d'Ivoire 1
- Croatia 1
- Cuba 1
- Iceland 1
- Korea, South 1
- Malaysia 1
- Mozambique 1
- Namibia 1
- Sudan 1
- Timor-Leste 1
- Togo 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3296217 | 3296217 | 2021-07-30 | Japan | Tochigi | 8154 | 85 | 7346 | 723 | 36.689912 | 139.819213 | 2021-07-31 04:21:35 | Tochigi, Japan | ||
3705996 | 3705996 | 2021-07-17 | Croatia | 361488 | 8236 | 352529 | 723 | 45.1 | 15.2 | 2021-07-18 04:22:07 | Croatia | |||
1444210 | 1444210 | 2021-07-07 | Ukraine | Kharkiv Oblast | 148687 | 3546 | 144418 | 723 | 49.9935 | 36.2304 | 2021-07-08 04:21:26 | Kharkiv Oblast, Ukraine | ||
2422802 | 2422802 | 2021-06-23 | Germany | Hamburg | 77154 | 1588 | 74900 | 723 | 53.5511 | 9.9937 | 2021-06-24 04:21:55 | Hamburg, Germany | ||
2422740 | 2422740 | 2021-06-23 | Colombia | La Guajira | 38882 | 1225 | 36934 | 723 | 11.3548 | -72.5205 | 2021-06-24 04:21:55 | La Guajira, Colombia | ||
1708229 | 1708229 | 2021-06-02 | Germany | Saarland | 40871 | 1011 | 39200 | 723 | 49.3964 | 7.023 | 2021-06-03 04:23:32 | Saarland, Germany | ||
3089442 | 3089442 | 2021-05-30 | Japan | Kumamoto | 6238 | 97 | 5418 | 723 | 32.608154 | 130.74523100000002 | 2021-05-31 03:08:59 | Kumamoto, Japan | ||
1807080 | 1807080 | 2021-05-27 | Togo | 13420 | 125 | 12572 | 723 | 8.6195 | 0.8248 | 2021-05-28 04:20:36 | Togo | |||
1081781 | 1081781 | 2021-05-14 | Colombia | Quindio | 41429 | 1244 | 39462 | 723 | 4.461 | -75.6674 | 2021-05-15 04:20:58 | Quindio, Colombia | ||
3053975 | 3053975 | 2021-05-13 | Chile | Atacama | 19408 | 212 | 18473 | 723 | -27.5661 | -70.0503 | 2021-05-14 04:20:41 | Atacama, Chile | ||
2021056 | 2021056 | 2021-04-20 | Timor-Leste | 1452 | 2 | 727 | 723 | -8.874217 | 125.727539 | 2021-04-21 04:21:14 | Timor-Leste | |||
3962531 | 3962531 | 2021-03-10 | Japan | Hokkaido | 19663 | 697 | 18243 | 723 | 43.385711 | 142.552318 | 2021-03-11 05:25:48 | Hokkaido, Japan | ||
3667287 | 3667287 | 2021-03-09 | Malaysia | Perak | 11971 | 42 | 11206 | 723 | 4.5921 | 101.0901 | 2021-03-10 05:24:35 | Perak, Malaysia | ||
3670502 | 3670502 | 2021-03-06 | US | South Dakota | McCook | 46087 | 747 | 24 | 0 | 723 | 43.6742571 | -97.36863144 | 2021-03-07 05:21:54 | McCook, South Dakota, US |
3669947 | 3669947 | 2021-03-06 | US | North Carolina | Jones | 37103 | 739 | 16 | 0 | 723 | 35.02254606 | -77.35870791 | 2021-03-07 05:21:54 | Jones, North Carolina, US |
1619216 | 1619216 | 2021-03-05 | US | Tennessee | Pickett | 47137 | 751 | 23 | 0 | 723 | 36.55606529 | -85.07763299999998 | 2021-03-06 04:23:41 | Pickett, Tennessee, US |
1619123 | 1619123 | 2021-03-05 | US | South Dakota | McCook | 46087 | 747 | 24 | 0 | 723 | 43.6742571 | -97.36863144 | 2021-03-06 04:23:41 | McCook, South Dakota, US |
1617115 | 1617115 | 2021-03-05 | US | Georgia | Terrell | 13273 | 766 | 43 | 0 | 723 | 31.77527543 | -84.44069698 | 2021-03-06 04:23:41 | Terrell, Georgia, US |
2210627 | 2210627 | 2021-03-04 | US | Tennessee | Pickett | 47137 | 750 | 23 | 0 | 723 | 36.55606529 | -85.07763299999998 | 2021-03-05 05:26:29 | Pickett, Tennessee, US |
2208526 | 2208526 | 2021-03-04 | US | Georgia | Terrell | 13273 | 765 | 42 | 0 | 723 | 31.77527543 | -84.44069698 | 2021-03-05 05:26:29 | Terrell, Georgia, US |
1093048 | 1093048 | 2021-03-03 | US | Tennessee | Pickett | 47137 | 750 | 23 | 0 | 723 | 36.55606529 | -85.07763299999998 | 2021-03-04 05:24:24 | Pickett, Tennessee, US |
3257362 | 3257362 | 2021-03-02 | US | Texas | Stephens | 48429 | 818 | 24 | 0 | 723 | 32.73553157 | -98.83631615 | 2021-03-03 05:23:28 | Stephens, Texas, US |
3257120 | 3257120 | 2021-03-02 | US | Tennessee | Pickett | 47137 | 750 | 23 | 0 | 723 | 36.55606529 | -85.07763299999998 | 2021-03-03 05:23:28 | Pickett, Tennessee, US |
1001412 | 1001412 | 2021-03-01 | US | Tennessee | Pickett | 47137 | 750 | 23 | 0 | 723 | 36.55606529 | -85.07763299999998 | 2021-03-02 05:23:30 | Pickett, Tennessee, US |
2370470 | 2370470 | 2021-02-28 | US | Tennessee | Pickett | 47137 | 750 | 23 | 0 | 723 | 36.55606529 | -85.07763299999998 | 2021-03-01 05:23:01 | Pickett, Tennessee, US |
2367699 | 2367699 | 2021-02-28 | Russia | Kalmykia Republic | 19001 | 296 | 17982 | 723 | 46.2313018 | 45.3275745 | 2021-03-01 05:23:01 | Kalmykia Republic, Russia | ||
3068972 | 3068972 | 2021-02-27 | US | Tennessee | Pickett | 47137 | 750 | 23 | 0 | 723 | 36.55606529 | -85.07763299999998 | 2021-02-28 05:22:20 | Pickett, Tennessee, US |
2186556 | 2186556 | 2021-02-26 | US | Tennessee | Pickett | 47137 | 750 | 23 | 0 | 723 | 36.55606529 | -85.07763299999998 | 2021-02-27 05:22:28 | Pickett, Tennessee, US |
1861275 | 1861275 | 2021-02-25 | US | Vermont | Addison | 50001 | 731 | 8 | 0 | 723 | 44.03217337 | -73.14130877 | 2021-02-26 05:22:40 | Addison, Vermont, US |
1860786 | 1860786 | 2021-02-25 | US | Puerto Rico | Yabucoa | 72151 | 723 | 0 | 0 | 723 | 18.070399 | -65.896289 | 2021-02-26 05:22:40 | Yabucoa, Puerto Rico, US |
281787 | 281787 | 2021-02-24 | US | Michigan | Arenac | 26011 | 747 | 24 | 0 | 723 | 44.0636262 | -83.89277559 | 2021-02-25 05:24:57 | Arenac, Michigan, US |
1939759 | 1939759 | 2021-02-23 | US | Virginia | Charlotte | 51037 | 733 | 10 | 0 | 723 | 37.01909701 | -78.66314092 | 2021-02-24 05:29:16 | Charlotte, Virginia, US |
1939424 | 1939424 | 2021-02-23 | US | Tennessee | Pickett | 47137 | 750 | 23 | 0 | 723 | 36.55606529 | -85.07763299999998 | 2021-02-24 05:29:16 | Pickett, Tennessee, US |
532797 | 532797 | 2021-02-22 | US | Nebraska | Merrick | 31121 | 736 | 13 | 0 | 723 | 41.16624273 | -98.0374887 | 2021-02-23 05:23:41 | Merrick, Nebraska, US |
183697 | 183697 | 2021-02-21 | US | Michigan | Missaukee | 26113 | 740 | 17 | 0 | 723 | 44.33772443 | -85.09256478 | 2021-02-22 05:24:21 | Missaukee, Michigan, US |
743971 | 743971 | 2021-02-20 | US | Michigan | Missaukee | 26113 | 740 | 17 | 0 | 723 | 44.33772443 | -85.09256478 | 2021-02-21 05:24:33 | Missaukee, Michigan, US |
472772 | 472772 | 2021-02-19 | US | Kentucky | Bath | 21011 | 739 | 16 | 0 | 723 | 38.14735938 | -83.74588932 | 2021-02-20 05:22:51 | Bath, Kentucky, US |
472282 | 472282 | 2021-02-19 | US | Georgia | Taylor | 13269 | 746 | 23 | 0 | 723 | 32.55792548 | -84.25077141 | 2021-02-20 05:22:51 | Taylor, Georgia, US |
1154545 | 1154545 | 2021-02-18 | US | Kentucky | Livingston | 21139 | 739 | 16 | 0 | 723 | 37.21137452 | -88.34797529 | 2021-02-19 05:24:16 | Livingston, Kentucky, US |
1153991 | 1153991 | 2021-02-18 | US | Georgia | Taylor | 13269 | 745 | 22 | 0 | 723 | 32.55792548 | -84.25077141 | 2021-02-19 05:24:16 | Taylor, Georgia, US |
3602465 | 3602465 | 2021-02-17 | US | Kentucky | Livingston | 21139 | 739 | 16 | 0 | 723 | 37.21137452 | -88.34797529 | 2021-02-18 05:22:58 | Livingston, Kentucky, US |
3602401 | 3602401 | 2021-02-17 | US | Kentucky | Bath | 21011 | 739 | 16 | 0 | 723 | 38.14735938 | -83.74588932 | 2021-02-18 05:22:58 | Bath, Kentucky, US |
3051349 | 3051349 | 2021-02-16 | US | Iowa | Davis | 19051 | 746 | 23 | 0 | 723 | 40.74773536 | -92.41005468 | 2021-02-17 05:23:10 | Davis, Iowa, US |
2285834 | 2285834 | 2021-02-14 | US | North Dakota | Pembina | 38067 | 737 | 11 | 0 | 723 | 48.76623521 | -97.5523809 | 2021-02-15 05:24:49 | Pembina, North Dakota, US |
2681194 | 2681194 | 2021-02-13 | US | Virginia | Nelson | 51125 | 730 | 7 | 0 | 723 | 37.78790447 | -78.88498513 | 2021-02-14 05:23:43 | Nelson, Virginia, US |
2680234 | 2680234 | 2021-02-13 | US | North Dakota | Pembina | 38067 | 733 | 11 | 0 | 723 | 48.76623521 | -97.5523809 | 2021-02-14 05:23:43 | Pembina, North Dakota, US |
3541867 | 3541867 | 2021-02-12 | US | North Dakota | Pembina | 38067 | 733 | 11 | 0 | 723 | 48.76623521 | -97.5523809 | 2021-02-13 05:22:12 | Pembina, North Dakota, US |
1531530 | 1531530 | 2021-02-09 | Ukraine | Sevastopol* | 10565 | 425 | 9417 | 723 | 44.6054 | 33.522 | 2021-02-10 05:22:41 | Sevastopol*, Ukraine | ||
1531086 | 1531086 | 2021-02-09 | US | Texas | Presidio | 48377 | 681 | 23 | 0 | 723 | 29.99954402 | -104.2408079 | 2021-02-10 05:22:41 | Presidio, Texas, US |
791219 | 791219 | 2021-02-04 | US | Georgia | Miller | 13201 | 730 | 7 | 0 | 723 | 31.16568912 | -84.73151117 | 2021-02-05 05:22:38 | Miller, Georgia, US |
791193 | 791193 | 2021-02-04 | US | Georgia | Heard | 13149 | 738 | 15 | 0 | 723 | 33.29686567 | -85.12886832 | 2021-02-05 05:22:38 | Heard, Georgia, US |
2482847 | 2482847 | 2021-01-28 | US | Georgia | Treutlen | 13283 | 741 | 18 | 0 | 723 | 32.40422134 | -82.56904553 | 2021-01-29 05:22:23 | Treutlen, Georgia, US |
3153555 | 3153555 | 2021-01-27 | India | Jharkhand | 118495 | 1066 | 116706 | 723 | 23.654536 | 85.557631 | 2021-01-28 05:22:24 | Jharkhand, India | ||
14284 | 14284 | 2021-01-26 | US | Missouri | Ralls | 29173 | 733 | 10 | 0 | 723 | 39.52817427 | -91.51838643 | 2021-01-27 05:23:41 | Ralls, Missouri, US |
2570669 | 2570669 | 2021-01-25 | US | Texas | Archer | 48009 | 757 | 10 | 0 | 723 | 33.61569967 | -98.68754589 | 2021-01-26 05:22:02 | Archer, Texas, US |
1762301 | 1762301 | 2021-01-24 | US | Texas | Archer | 48009 | 757 | 10 | 0 | 723 | 33.61569967 | -98.68754589 | 2021-01-25 05:22:16 | Archer, Texas, US |
2429908 | 2429908 | 2021-01-23 | US | Texas | Archer | 48009 | 757 | 10 | 0 | 723 | 33.61569967 | -98.68754589 | 2021-01-24 05:22:35 | Archer, Texas, US |
2428008 | 2428008 | 2021-01-23 | US | Indiana | Martin | 18101 | 737 | 14 | 0 | 723 | 38.7099921 | -86.80373186 | 2021-01-24 05:22:35 | Martin, Indiana, US |
2469698 | 2469698 | 2021-01-22 | US | South Dakota | Spink | 46115 | 747 | 24 | 0 | 723 | 44.93837606 | -98.34626602 | 2021-01-23 05:22:03 | Spink, South Dakota, US |
2469674 | 2469674 | 2021-01-22 | US | South Dakota | Hutchinson | 46067 | 746 | 23 | 0 | 723 | 43.33449012 | -97.75536441 | 2021-01-23 05:22:03 | Hutchinson, South Dakota, US |
438249 | 438249 | 2021-01-21 | US | South Dakota | Spink | 46115 | 747 | 24 | 0 | 723 | 44.93837606 | -98.34626602 | 2021-01-22 05:22:10 | Spink, South Dakota, US |
436605 | 436605 | 2021-01-21 | US | Kansas | Anderson | 20003 | 731 | 8 | 0 | 723 | 38.21413251 | -95.29272815 | 2021-01-22 05:22:10 | Anderson, Kansas, US |
436217 | 436217 | 2021-01-21 | US | Georgia | Screven | 13251 | 740 | 17 | 0 | 723 | 32.74976524 | -81.60779441 | 2021-01-22 05:22:10 | Screven, Georgia, US |
1096980 | 1096980 | 2021-01-20 | US | South Dakota | Spink | 46115 | 747 | 24 | 0 | 723 | 44.93837606 | -98.34626602 | 2021-01-21 05:22:01 | Spink, South Dakota, US |
1095336 | 1095336 | 2021-01-20 | US | Kansas | Anderson | 20003 | 731 | 8 | 0 | 723 | 38.21413251 | -95.29272815 | 2021-01-21 05:22:01 | Anderson, Kansas, US |
3506063 | 3506063 | 2021-01-17 | US | Puerto Rico | Aguas Buenas | 72007 | 723 | 0 | 0 | 723 | 18.251619 | -66.126806 | 2021-01-18 05:22:34 | Aguas Buenas, Puerto Rico, US |
3104770 | 3104770 | 2021-01-16 | US | Virginia | Franklin City | 51620 | 741 | 18 | 0 | 723 | 36.6831435 | -76.93859681 | 2021-01-17 05:22:17 | Franklin City, Virginia, US |
3882261 | 3882261 | 2021-01-14 | US | Pennsylvania | Potter | 42105 | 740 | 17 | 0 | 723 | 41.74471626 | -77.89559864 | 2021-01-15 05:22:24 | Potter, Pennsylvania, US |
3881691 | 3881691 | 2021-01-14 | US | Nebraska | Thurston | 31173 | 732 | 9 | 0 | 723 | 42.15725356 | -96.54157099 | 2021-01-15 05:22:24 | Thurston, Nebraska, US |
3311210 | 3311210 | 2021-01-13 | US | Texas | Bailey | 48017 | 822 | 13 | 0 | 723 | 34.06854817 | -102.8299707 | 2021-01-14 05:22:32 | Bailey, Texas, US |
3310087 | 3310087 | 2021-01-13 | US | Missouri | Dallas | 29059 | 742 | 19 | 0 | 723 | 37.6811355 | -93.02127031 | 2021-01-14 05:22:32 | Dallas, Missouri, US |
777355 | 777355 | 2021-01-12 | US | Texas | Bailey | 48017 | 822 | 13 | 0 | 723 | 34.06854817 | -102.8299707 | 2021-01-13 05:22:15 | Bailey, Texas, US |
2627954 | 2627954 | 2021-01-10 | US | Nebraska | Knox | 31107 | 730 | 7 | 0 | 723 | 42.63758421 | -97.89178836 | 2021-01-11 05:21:50 | Knox, Nebraska, US |
2625885 | 2625885 | 2021-01-10 | Japan | Ibaraki | 3140 | 40 | 2377 | 723 | 36.303588 | 140.319591 | 2021-01-11 05:21:50 | Ibaraki, Japan | ||
3902215 | 3902215 | 2021-01-09 | US | New York | Schoharie | 36095 | 728 | 5 | 0 | 723 | 42.58831742 | -74.44339029999998 | 2021-01-10 05:22:12 | Schoharie, New York, US |
3902042 | 3902042 | 2021-01-09 | US | Nebraska | Knox | 31107 | 730 | 7 | 0 | 723 | 42.63758421 | -97.89178836 | 2021-01-10 05:22:12 | Knox, Nebraska, US |
3900716 | 3900716 | 2021-01-09 | US | Georgia | Candler | 13043 | 760 | 37 | 0 | 723 | 32.40209349 | -82.07702563 | 2021-01-10 05:22:12 | Candler, Georgia, US |
157388 | 157388 | 2021-01-08 | US | Virginia | Sussex | 51183 | 736 | 13 | 0 | 723 | 36.92432914 | -77.25791182 | 2021-01-09 05:22:18 | Sussex, Virginia, US |
157315 | 157315 | 2021-01-08 | US | Virginia | Giles | 51071 | 728 | 5 | 0 | 723 | 37.31234791 | -80.70636931 | 2021-01-09 05:22:18 | Giles, Virginia, US |
2543447 | 2543447 | 2021-01-07 | US | Nebraska | Butler | 31023 | 733 | 10 | 0 | 723 | 41.22703692 | -97.13106306 | 2021-01-08 05:22:42 | Butler, Nebraska, US |
2542737 | 2542737 | 2021-01-07 | US | Kansas | Russell | 20167 | 743 | 20 | 0 | 723 | 38.91462787 | -98.76254297 | 2021-01-08 05:22:42 | Russell, Kansas, US |
2866142 | 2866142 | 2021-01-06 | US | Kentucky | Magoffin | 21153 | 724 | 1 | 0 | 723 | 37.70820545 | -83.0657714 | 2021-01-07 05:22:03 | Magoffin, Kentucky, US |
2866046 | 2866046 | 2021-01-06 | US | Kansas | Russell | 20167 | 743 | 20 | 0 | 723 | 38.91462787 | -98.76254297 | 2021-01-07 05:22:03 | Russell, Kansas, US |
2865376 | 2865376 | 2021-01-06 | US | Connecticut | Unassigned | 90009 | 723 | 0 | 0 | 723 | 41.85853803 | 0.0 | 2021-01-07 05:22:03 | Unassigned, Connecticut, US |
3037856 | 3037856 | 2021-01-05 | US | Wisconsin | Menominee | 55078 | 733 | 10 | 0 | 723 | 45.00422544 | -88.70950714 | 2021-01-06 05:22:16 | Menominee, Wisconsin, US |
3035633 | 3035633 | 2021-01-05 | US | Kansas | Russell | 20167 | 743 | 20 | 0 | 723 | 38.91462787 | -98.76254297 | 2021-01-06 05:22:16 | Russell, Kansas, US |
1063178 | 1063178 | 2021-01-04 | US | Kansas | Russell | 20167 | 743 | 20 | 0 | 723 | 38.91462787 | -98.76254297 | 2021-01-05 05:21:49 | Russell, Kansas, US |
1137898 | 1137898 | 2021-01-01 | US | Illinois | Menard | 17129 | 729 | 6 | 0 | 723 | 40.02742725 | -89.80246001 | 2021-01-02 05:22:33 | Menard, Illinois, US |
3698633 | 3698633 | 2020-12-31 | US | Texas | Leon | 48289 | 1104 | 24 | 0 | 723 | 31.29872538 | -95.9936328 | 2021-01-01 05:23:07 | Leon, Texas, US |
3696504 | 3696504 | 2020-12-31 | US | Illinois | Menard | 17129 | 729 | 6 | 0 | 723 | 40.02742725 | -89.80246001 | 2021-01-01 05:23:07 | Menard, Illinois, US |
768417 | 768417 | 2020-12-29 | US | Nebraska | Phelps | 31137 | 731 | 8 | 0 | 723 | 40.51156033 | -99.41461667 | 2020-12-30 05:22:34 | Phelps, Nebraska, US |
767190 | 767190 | 2020-12-29 | US | Georgia | Telfair | 13271 | 759 | 36 | 0 | 723 | 31.92829517 | -82.93491155 | 2020-12-30 05:22:34 | Telfair, Georgia, US |
3763004 | 3763004 | 2020-12-28 | US | Kentucky | Lewis | 21135 | 745 | 22 | 0 | 723 | 38.53184419 | -83.37735618 | 2020-12-29 05:22:37 | Lewis, Kentucky, US |
3781131 | 3781131 | 2020-12-27 | US | Texas | Tyler | 48457 | 763 | 10 | 0 | 723 | 30.77031716 | -94.37690895 | 2020-12-28 05:22:06 | Tyler, Texas, US |
3779300 | 3779300 | 2020-12-27 | US | Kentucky | Green | 21087 | 733 | 10 | 0 | 723 | 37.26484328 | -85.5540745 | 2020-12-28 05:22:06 | Green, Kentucky, US |
2226736 | 2226736 | 2020-12-26 | US | Texas | Tyler | 48457 | 763 | 10 | 0 | 723 | 30.77031716 | -94.37690895 | 2020-12-27 05:22:55 | Tyler, Texas, US |
205483 | 205483 | 2020-12-25 | US | Texas | Tyler | 48457 | 759 | 10 | 0 | 723 | 30.77031716 | -94.37690895 | 2020-12-26 05:22:28 | Tyler, Texas, US |
3694706 | 3694706 | 2020-12-24 | US | Texas | Tyler | 48457 | 737 | 10 | 0 | 723 | 30.77031716 | -94.37690895 | 2020-12-25 05:22:48 | Tyler, Texas, US |
2410058 | 2410058 | 2020-12-23 | US | Texas | Tyler | 48457 | 730 | 10 | 0 | 723 | 30.77031716 | -94.37690895 | 2020-12-24 05:23:04 | Tyler, Texas, US |
2408824 | 2408824 | 2020-12-23 | US | Montana | Jefferson | 30043 | 726 | 3 | 0 | 723 | 46.14907081 | -112.094396 | 2020-12-24 05:23:04 | Jefferson, Montana, 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]);