johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
451 rows where active = 484 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
- US 380
- Russia 9
- Chile 8
- Japan 7
- Colombia 6
- India 3
- Mexico 3
- Ukraine 3
- Andorra 2
- Germany 2
- Mongolia 2
- Netherlands 2
- Timor-Leste 2
- Australia 1
- Azerbaijan 1
- Bosnia and Herzegovina 1
- Brazil 1
- Cameroon 1
- Canada 1
- China 1
- Costa Rica 1
- Cote d'Ivoire 1
- Cyprus 1
- Finland 1
- Hungary 1
- Liberia 1
- Luxembourg 1
- Malawi 1
- Malaysia 1
- Mali 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2796722 | 2796722 | 2021-08-28 | Malaysia | W.P. Putrajaya | 5283 | 21 | 4778 | 484 | 2.9264 | 101.6964 | 2021-08-29 04:21:14 | W.P. Putrajaya, Malaysia | ||
3018978 | 3018978 | 2021-08-01 | Ukraine | Kherson Oblast | 36416 | 1163 | 34769 | 484 | 46.6354 | 32.6169 | 2021-08-02 04:21:36 | Kherson Oblast, Ukraine | ||
1306095 | 1306095 | 2021-07-27 | India | Bihar | 724597 | 9639 | 714474 | 484 | 25.679658 | 85.60484 | 2021-07-28 04:21:39 | Bihar, India | ||
3476095 | 3476095 | 2021-07-22 | Chile | Atacama | 26455 | 306 | 25665 | 484 | -27.5661 | -70.0503 | 2021-07-23 04:21:29 | Atacama, Chile | ||
2375145 | 2375145 | 2021-07-20 | Ukraine | Lviv Oblast | 137854 | 3676 | 133694 | 484 | 49.8397 | 24.0297 | 2021-07-21 04:21:40 | Lviv Oblast, Ukraine | ||
578672 | 578672 | 2021-07-13 | Colombia | Caqueta | 21233 | 813 | 19936 | 484 | 0.8699 | -73.8419 | 2021-07-14 04:21:35 | Caqueta, Colombia | ||
578577 | 578577 | 2021-07-13 | Brazil | Piaui | 303225 | 6718 | 295300 | 484 | -7.7183 | -42.7289 | 2021-07-14 04:21:35 | Piaui, Brazil | ||
778273 | 778273 | 2021-07-08 | Germany | Hamburg | 77542 | 1597 | 75500 | 484 | 53.5511 | 9.9937 | 2021-07-09 04:21:21 | Hamburg, Germany | ||
2339350 | 2339350 | 2021-06-15 | India | Lakshadweep | 9297 | 45 | 8768 | 484 | 13.6999972 | 72.18333259999999 | 2021-06-16 04:22:32 | Lakshadweep, India | ||
3381627 | 3381627 | 2021-06-13 | Russia | Tula Oblast | 40854 | 2109 | 38261 | 484 | 53.9570701 | 37.3690909 | 2021-06-14 04:22:46 | Tula Oblast, Russia | ||
2315338 | 2315338 | 2021-06-04 | Japan | Shiga | 5247 | 81 | 4682 | 484 | 35.21582700000001 | 136.138064 | 2021-06-05 04:23:03 | Shiga, Japan | ||
2315213 | 2315213 | 2021-06-04 | Germany | Bremen | 27195 | 475 | 26260 | 484 | 53.0793 | 8.8017 | 2021-06-05 04:23:03 | Bremen, Germany | ||
2390788 | 2390788 | 2021-05-18 | Japan | Kagoshima | 2946 | 28 | 2434 | 484 | 31.009484000000004 | 130.430665 | 2021-05-19 04:20:42 | Kagoshima, Japan | ||
2820784 | 2820784 | 2021-05-10 | Japan | Ibaraki | 8606 | 135 | 7987 | 484 | 36.303588 | 140.319591 | 2021-05-11 04:20:41 | Ibaraki, Japan | ||
3129311 | 3129311 | 2021-04-18 | Chile | Magallanes | 24094 | 365 | 23245 | 484 | -52.368 | -70.9863 | 2021-04-19 04:20:57 | Magallanes, Chile | ||
169734 | 169734 | 2021-04-16 | Andorra | 12712 | 123 | 12105 | 484 | 42.5063 | 1.5218 | 2021-04-17 04:20:40 | Andorra | |||
36684 | 36684 | 2021-04-12 | Russia | Tyva Republic | 15778 | 200 | 15094 | 484 | 51.4017149 | 93.8582593 | 2021-04-13 04:20:37 | Tyva Republic, Russia | ||
2247728 | 2247728 | 2021-04-07 | Timor-Leste | 779 | 1 | 294 | 484 | -8.874217 | 125.727539 | 2021-04-08 04:21:13 | Timor-Leste | |||
3003638 | 3003638 | 2021-04-06 | Timor-Leste | 779 | 1 | 294 | 484 | -8.874217 | 125.727539 | 2021-04-07 04:20:53 | Timor-Leste | |||
702257 | 702257 | 2021-03-16 | Colombia | Meta | 43069 | 986 | 41599 | 484 | 3.272 | -73.0877 | 2021-03-17 05:25:07 | Meta, Colombia | ||
1580158 | 1580158 | 2021-03-13 | Japan | Fukuoka | 18472 | 313 | 17675 | 484 | 33.526032 | 130.666949 | 2021-03-14 05:25:37 | Fukuoka, Japan | ||
3670946 | 3670946 | 2021-03-06 | US | Virginia | Fairfax City | 51600 | 498 | 14 | 0 | 484 | 38.85157547 | -77.29779640000002 | 2021-03-07 05:21:54 | Fairfax City, Virginia, US |
3669333 | 3669333 | 2021-03-06 | US | Minnesota | Grant | 27051 | 492 | 8 | 0 | 484 | 45.93424769 | -96.01139609 | 2021-03-07 05:21:54 | Grant, Minnesota, US |
1619567 | 1619567 | 2021-03-05 | US | Virginia | Fairfax City | 51600 | 497 | 13 | 0 | 484 | 38.85157547 | -77.29779640000002 | 2021-03-06 04:23:41 | Fairfax City, Virginia, US |
1093352 | 1093352 | 2021-03-03 | US | Vermont | Lamoille | 50015 | 486 | 2 | 0 | 484 | 44.60353043 | -72.64356694 | 2021-03-04 05:24:24 | Lamoille, Vermont, US |
1093012 | 1093012 | 2021-03-03 | US | Tennessee | Hancock | 47067 | 512 | 12 | 0 | 484 | 36.52692871 | -83.22375847 | 2021-03-04 05:24:24 | Hancock, Tennessee, US |
1092056 | 1092056 | 2021-03-03 | US | Montana | Chouteau | 30015 | 489 | 5 | 0 | 484 | 47.88084126 | -110.4353362 | 2021-03-04 05:24:24 | Chouteau, Montana, US |
3255374 | 3255374 | 2021-03-02 | US | Iowa | Ringgold | 19159 | 504 | 20 | 0 | 484 | 40.73518949 | -94.24368535 | 2021-03-03 05:23:28 | Ringgold, Iowa, US |
3255133 | 3255133 | 2021-03-02 | US | Illinois | Henderson | 17071 | 498 | 14 | 0 | 484 | 40.81908672 | -90.92491462 | 2021-03-03 05:23:28 | Henderson, Illinois, US |
999425 | 999425 | 2021-03-01 | US | Illinois | Henderson | 17071 | 498 | 14 | 0 | 484 | 40.81908672 | -90.92491462 | 2021-03-02 05:23:30 | Henderson, Illinois, US |
2370434 | 2370434 | 2021-02-28 | US | Tennessee | Hancock | 47067 | 508 | 12 | 0 | 484 | 36.52692871 | -83.22375847 | 2021-03-01 05:23:01 | Hancock, Tennessee, US |
2369478 | 2369478 | 2021-02-28 | US | Montana | Chouteau | 30015 | 489 | 5 | 0 | 484 | 47.88084126 | -110.4353362 | 2021-03-01 05:23:01 | Chouteau, Montana, US |
2368483 | 2368483 | 2021-02-28 | US | Illinois | Henderson | 17071 | 498 | 14 | 0 | 484 | 40.81908672 | -90.92491462 | 2021-03-01 05:23:01 | Henderson, Illinois, US |
2367357 | 2367357 | 2021-02-28 | Colombia | Sucre | 20550 | 780 | 19286 | 484 | 8.814 | -74.7233 | 2021-03-01 05:23:01 | Sucre, Colombia | ||
3068936 | 3068936 | 2021-02-27 | US | Tennessee | Hancock | 47067 | 508 | 12 | 0 | 484 | 36.52692871 | -83.22375847 | 2021-02-28 05:22:20 | Hancock, Tennessee, US |
3066985 | 3066985 | 2021-02-27 | US | Illinois | Henderson | 17071 | 498 | 14 | 0 | 484 | 40.81908672 | -90.92491462 | 2021-02-28 05:22:20 | Henderson, Illinois, US |
2186520 | 2186520 | 2021-02-26 | US | Tennessee | Hancock | 47067 | 508 | 12 | 0 | 484 | 36.52692871 | -83.22375847 | 2021-02-27 05:22:28 | Hancock, Tennessee, US |
2185592 | 2185592 | 2021-02-26 | US | Montana | Phillips | 30071 | 498 | 14 | 0 | 484 | 48.25936577 | -107.9128511 | 2021-02-27 05:22:28 | Phillips, Montana, US |
2184569 | 2184569 | 2021-02-26 | US | Illinois | Henderson | 17071 | 498 | 14 | 0 | 484 | 40.81908672 | -90.92491462 | 2021-02-27 05:22:28 | Henderson, Illinois, US |
1860014 | 1860014 | 2021-02-25 | US | Montana | Phillips | 30071 | 498 | 14 | 0 | 484 | 48.25936577 | -107.9128511 | 2021-02-26 05:22:40 | Phillips, Montana, US |
1858991 | 1858991 | 2021-02-25 | US | Illinois | Henderson | 17071 | 498 | 14 | 0 | 484 | 40.81908672 | -90.92491462 | 2021-02-26 05:22:40 | Henderson, Illinois, US |
282192 | 282192 | 2021-02-24 | US | Montana | Phillips | 30071 | 498 | 14 | 0 | 484 | 48.25936577 | -107.9128511 | 2021-02-25 05:24:57 | Phillips, Montana, US |
281070 | 281070 | 2021-02-24 | US | Georgia | Warren | 13301 | 496 | 12 | 0 | 484 | 33.41146451 | -82.67795848 | 2021-02-25 05:24:57 | Warren, Georgia, US |
1939954 | 1939954 | 2021-02-23 | US | West Virginia | Roane | 54087 | 491 | 7 | 0 | 484 | 38.71622686 | -81.35243568 | 2021-02-24 05:29:16 | Roane, West Virginia, US |
1939505 | 1939505 | 2021-02-23 | US | Texas | Crosby | 48107 | 808 | 26 | 0 | 484 | 33.61431553 | -101.3000364 | 2021-02-24 05:29:16 | Crosby, Texas, US |
1938460 | 1938460 | 2021-02-23 | US | Montana | Phillips | 30071 | 498 | 14 | 0 | 484 | 48.25936577 | -107.9128511 | 2021-02-24 05:29:16 | Phillips, Montana, US |
533821 | 533821 | 2021-02-22 | US | Texas | Hudspeth | 48229 | 647 | 11 | 0 | 484 | 31.45628381 | -105.388178 | 2021-02-23 05:23:41 | Hudspeth, Texas, US |
533760 | 533760 | 2021-02-22 | US | Texas | Crosby | 48107 | 807 | 25 | 0 | 484 | 33.61431553 | -101.3000364 | 2021-02-23 05:23:41 | Crosby, Texas, US |
533454 | 533454 | 2021-02-22 | US | Puerto Rico | Luquillo | 72089 | 484 | 0 | 0 | 484 | 18.342114 | -65.72509699999999 | 2021-02-23 05:23:41 | Luquillo, Puerto Rico, US |
531692 | 531692 | 2021-02-22 | US | Illinois | Henderson | 17071 | 492 | 8 | 0 | 484 | 40.81908672 | -90.92491462 | 2021-02-23 05:23:41 | Henderson, Illinois, US |
185155 | 185155 | 2021-02-21 | US | Texas | Hudspeth | 48229 | 647 | 11 | 0 | 484 | 31.45628381 | -105.388178 | 2021-02-22 05:24:21 | Hudspeth, Texas, US |
185094 | 185094 | 2021-02-21 | US | Texas | Crosby | 48107 | 807 | 25 | 0 | 484 | 33.61431553 | -101.3000364 | 2021-02-22 05:24:21 | Crosby, Texas, US |
184788 | 184788 | 2021-02-21 | US | Puerto Rico | Luquillo | 72089 | 484 | 0 | 0 | 484 | 18.342114 | -65.72509699999999 | 2021-02-22 05:24:21 | Luquillo, Puerto Rico, US |
745368 | 745368 | 2021-02-20 | US | Texas | Crosby | 48107 | 807 | 25 | 0 | 484 | 33.61431553 | -101.3000364 | 2021-02-21 05:24:33 | Crosby, Texas, US |
743300 | 743300 | 2021-02-20 | US | Illinois | Henderson | 17071 | 492 | 8 | 0 | 484 | 40.81908672 | -90.92491462 | 2021-02-21 05:24:33 | Henderson, Illinois, US |
2284258 | 2284258 | 2021-02-14 | US | Georgia | Marion | 13197 | 497 | 13 | 0 | 484 | 32.3483402 | -84.52733571 | 2021-02-15 05:24:49 | Marion, Georgia, US |
2283915 | 2283915 | 2021-02-14 | US | Arkansas | Lafayette | 5073 | 491 | 7 | 0 | 484 | 33.24116713 | -93.60677071 | 2021-02-15 05:24:49 | Lafayette, Arkansas, US |
2681241 | 2681241 | 2021-02-13 | US | Virginia | Williamsburg | 51830 | 493 | 9 | 0 | 484 | 37.28131268 | -76.70905141 | 2021-02-14 05:23:43 | Williamsburg, Virginia, US |
2678658 | 2678658 | 2021-02-13 | US | Georgia | Marion | 13197 | 497 | 13 | 0 | 484 | 32.3483402 | -84.52733571 | 2021-02-14 05:23:43 | Marion, Georgia, US |
3981123 | 3981123 | 2021-02-10 | US | Oklahoma | Greer | 40055 | 500 | 16 | 0 | 484 | 34.93535801 | -99.5605612 | 2021-02-11 05:23:55 | Greer, Oklahoma, US |
3980268 | 3980268 | 2021-02-10 | US | Minnesota | Big Stone | 27011 | 487 | 3 | 0 | 484 | 45.42712824 | -96.41403739 | 2021-02-11 05:23:55 | Big Stone, Minnesota, US |
1672317 | 1672317 | 2021-02-07 | Colombia | Sucre | 19697 | 728 | 18485 | 484 | 8.814 | -74.7233 | 2021-02-08 05:22:39 | Sucre, Colombia | ||
977206 | 977206 | 2021-02-06 | US | North Carolina | Camden | 37029 | 489 | 5 | 0 | 484 | 36.33804939 | -76.15568396 | 2021-02-07 05:23:00 | Camden, North Carolina, US |
1685851 | 1685851 | 2021-02-02 | US | Kansas | Washington | 20201 | 492 | 8 | 0 | 484 | 39.78420784 | -97.0875323 | 2021-02-03 05:22:52 | Washington, Kansas, US |
1677821 | 1677821 | 2021-02-01 | US | Kansas | Washington | 20201 | 492 | 8 | 0 | 484 | 39.78420784 | -97.0875323 | 2021-02-02 05:22:49 | Washington, Kansas, US |
1677107 | 1677107 | 2021-02-01 | US | Colorado | Park | 8093 | 524 | 5 | 0 | 484 | 39.120926 | -105.7182065 | 2021-02-02 05:22:49 | Park, Colorado, US |
2485022 | 2485022 | 2021-01-28 | US | Texas | Crane | 48103 | 361 | 11 | 0 | 484 | 31.43052248 | -102.5143314 | 2021-01-29 05:22:23 | Crane, Texas, US |
2483281 | 2483281 | 2021-01-28 | US | Kansas | Morris | 20127 | 501 | 17 | 0 | 484 | 38.68827511 | -96.65128437 | 2021-01-29 05:22:23 | Morris, Kansas, US |
3156657 | 3156657 | 2021-01-27 | US | Texas | Crane | 48103 | 361 | 11 | 0 | 484 | 31.43052248 | -102.5143314 | 2021-01-28 05:22:24 | Crane, Texas, US |
3156014 | 3156014 | 2021-01-27 | US | North Dakota | Pierce | 38069 | 508 | 24 | 0 | 484 | 48.24977025 | -99.96407787 | 2021-01-28 05:22:24 | Pierce, North Dakota, US |
3154916 | 3154916 | 2021-01-27 | US | Kansas | Morris | 20127 | 501 | 17 | 0 | 484 | 38.68827511 | -96.65128437 | 2021-01-28 05:22:24 | Morris, Kansas, US |
14749 | 14749 | 2021-01-26 | US | North Dakota | Pierce | 38069 | 507 | 24 | 0 | 484 | 48.24977025 | -99.96407787 | 2021-01-27 05:23:41 | Pierce, North Dakota, US |
2570523 | 2570523 | 2021-01-25 | US | South Dakota | Fall River | 46047 | 498 | 14 | 0 | 484 | 43.23929297 | -103.5275691 | 2021-01-26 05:22:02 | Fall River, South Dakota, US |
2570408 | 2570408 | 2021-01-25 | US | Puerto Rico | Lares | 72081 | 484 | 0 | 0 | 484 | 18.269035 | -66.867236 | 2021-01-26 05:22:02 | Lares, Puerto Rico, US |
2570378 | 2570378 | 2021-01-25 | US | Puerto Rico | Cabo Rojo | 72023 | 484 | 0 | 0 | 484 | 18.040993 | -67.154391 | 2021-01-26 05:22:02 | Cabo Rojo, Puerto Rico, US |
2570073 | 2570073 | 2021-01-25 | US | North Dakota | Pierce | 38069 | 507 | 24 | 0 | 484 | 48.24977025 | -99.96407787 | 2021-01-26 05:22:02 | Pierce, North Dakota, US |
1762155 | 1762155 | 2021-01-24 | US | South Dakota | Fall River | 46047 | 498 | 14 | 0 | 484 | 43.23929297 | -103.5275691 | 2021-01-25 05:22:16 | Fall River, South Dakota, US |
1761705 | 1761705 | 2021-01-24 | US | North Dakota | Pierce | 38069 | 507 | 24 | 0 | 484 | 48.24977025 | -99.96407787 | 2021-01-25 05:22:16 | Pierce, North Dakota, US |
2469911 | 2469911 | 2021-01-22 | US | Texas | Hemphill | 48211 | 595 | 2 | 0 | 484 | 35.83764858 | -100.2703577 | 2021-01-23 05:22:03 | Hemphill, Texas, US |
2469537 | 2469537 | 2021-01-22 | US | Puerto Rico | Guayama | 72057 | 484 | 0 | 0 | 484 | 18.007516 | -66.13390799999999 | 2021-01-23 05:22:03 | Guayama, Puerto Rico, US |
2466915 | 2466915 | 2021-01-22 | Mongolia | 1592 | 2 | 1125 | 484 | 46.8625 | 103.8467 | 2021-01-23 05:22:03 | Mongolia | |||
437765 | 437765 | 2021-01-21 | US | North Dakota | Pierce | 38069 | 506 | 22 | 0 | 484 | 48.24977025 | -99.96407787 | 2021-01-22 05:22:10 | Pierce, North Dakota, US |
1097468 | 1097468 | 2021-01-20 | US | Virginia | Poquoson | 51735 | 491 | 7 | 0 | 484 | 37.14259351 | -76.35798148 | 2021-01-21 05:22:01 | Poquoson, Virginia, US |
1095324 | 1095324 | 2021-01-20 | US | Iowa | Van Buren | 19177 | 497 | 13 | 0 | 484 | 40.75326764 | -91.95017958 | 2021-01-21 05:22:01 | Van Buren, Iowa, US |
1094733 | 1094733 | 2021-01-20 | US | Colorado | San Miguel | 8113 | 616 | 0 | 0 | 484 | 38.00450883 | -108.4020725 | 2021-01-21 05:22:01 | San Miguel, Colorado, US |
911498 | 911498 | 2021-01-19 | US | Virginia | Emporia | 51595 | 514 | 30 | 0 | 484 | 36.69455571 | -77.53406129 | 2021-01-20 05:21:54 | Emporia, Virginia, US |
238477 | 238477 | 2021-01-18 | US | Iowa | Van Buren | 19177 | 496 | 12 | 0 | 484 | 40.75326764 | -91.95017958 | 2021-01-19 05:22:15 | Van Buren, Iowa, US |
3503884 | 3503884 | 2021-01-17 | US | Arkansas | Woodruff | 5147 | 489 | 5 | 0 | 484 | 35.18902527 | -91.2439489 | 2021-01-18 05:22:34 | Woodruff, Arkansas, US |
3104942 | 3104942 | 2021-01-16 | US | West Virginia | Ritchie | 54085 | 492 | 8 | 0 | 484 | 39.18094587 | -81.06356878 | 2021-01-17 05:22:17 | Ritchie, West Virginia, US |
3518714 | 3518714 | 2021-01-15 | US | Virginia | Clarke | 51043 | 491 | 7 | 0 | 484 | 39.11271747 | -77.99199425 | 2021-01-16 05:22:40 | Clarke, Virginia, US |
3517727 | 3517727 | 2021-01-15 | US | North Carolina | Jones | 37103 | 500 | 16 | 0 | 484 | 35.02254606 | -77.35870791 | 2021-01-16 05:22:40 | Jones, North Carolina, US |
3515263 | 3515263 | 2021-01-15 | Colombia | Sucre | 18131 | 688 | 16959 | 484 | 8.814 | -74.7233 | 2021-01-16 05:22:40 | Sucre, Colombia | ||
3879924 | 3879924 | 2021-01-14 | US | Alabama | Choctaw | 1023 | 508 | 24 | 0 | 484 | 32.02227341 | -88.26564429999998 | 2021-01-15 05:22:24 | Choctaw, Alabama, US |
3311515 | 3311515 | 2021-01-13 | US | Virginia | Covington | 51580 | 488 | 4 | 0 | 484 | 37.7824656 | -79.98631446 | 2021-01-14 05:22:32 | Covington, Virginia, US |
3310120 | 3310120 | 2021-01-13 | US | Missouri | Maries | 29125 | 491 | 7 | 0 | 484 | 38.16193985 | -91.92249662 | 2021-01-14 05:22:32 | Maries, Missouri, US |
776881 | 776881 | 2021-01-12 | US | Oklahoma | Cotton | 40033 | 496 | 12 | 0 | 484 | 34.28845626 | -98.37053567 | 2021-01-13 05:22:15 | Cotton, Oklahoma, US |
3903038 | 3903038 | 2021-01-09 | US | Texas | Franklin | 48159 | 615 | 13 | 0 | 484 | 33.17653242 | -95.21917243 | 2021-01-10 05:22:12 | Franklin, Texas, US |
157023 | 157023 | 2021-01-08 | US | Texas | Coleman | 48083 | 572 | 16 | 0 | 484 | 31.76736834 | -99.45240766 | 2021-01-09 05:22:18 | Coleman, Texas, US |
156743 | 156743 | 2021-01-08 | US | Puerto Rico | Quebradillas | 72115 | 484 | 0 | 0 | 484 | 18.439692 | -66.926113 | 2021-01-09 05:22:18 | Quebradillas, Puerto Rico, US |
2544187 | 2544187 | 2021-01-07 | US | Puerto Rico | Yauco | 72153 | 484 | 0 | 0 | 484 | 18.080374 | -66.858814 | 2021-01-08 05:22:42 | Yauco, Puerto Rico, 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]);