johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
651 rows where deaths = 511 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 550
- Russia 24
- Sweden 15
- Japan 10
- India 6
- Chile 4
- Mali 4
- Brazil 3
- Italy 3
- Ukraine 3
- Angola 2
- Colombia 2
- Germany 2
- Malaysia 2
- Netherlands 2
- Pakistan 2
- Peru 2
- Sri Lanka 2
- Croatia 1
- Jamaica 1
- Kuwait 1
- Mauritania 1
- Mexico 1
- North Macedonia 1
- Norway 1
- Philippines 1
- Singapore 1
- Spain 1
- Uzbekistan 1
- Venezuela 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2952555 | 2952555 | 2022-12-20 | US | Iowa | Black Hawk | 19013 | 37935 | 511 | 0 | 42.4704581 | -92.30524729 | 2022-12-21 04:21:03 | Black Hawk, Iowa, US | |
3174957 | 3174957 | 2022-12-19 | US | Iowa | Black Hawk | 19013 | 37935 | 511 | 0 | 42.4704581 | -92.30524729 | 2022-12-20 04:21:04 | Black Hawk, Iowa, US | |
1629474 | 1629474 | 2022-12-18 | US | Iowa | Black Hawk | 19013 | 37935 | 511 | 0 | 42.4704581 | -92.30524729 | 2022-12-19 04:21:03 | Black Hawk, Iowa, US | |
504853 | 504853 | 2022-12-17 | US | Iowa | Black Hawk | 19013 | 37935 | 511 | 0 | 42.4704581 | -92.30524729 | 2022-12-18 04:21:03 | Black Hawk, Iowa, US | |
3325425 | 3325425 | 2022-12-16 | US | Iowa | Black Hawk | 19013 | 37935 | 511 | 0 | 42.4704581 | -92.30524729 | 2022-12-17 04:21:04 | Black Hawk, Iowa, US | |
3324271 | 3324271 | 2022-12-16 | Japan | Okayama | 362983 | 511 | 0 | 34.89246 | 133.826252 | 2022-12-17 04:21:04 | Okayama, Japan | |||
543937 | 543937 | 2022-12-15 | US | Iowa | Black Hawk | 19013 | 37935 | 511 | 0 | 42.4704581 | -92.30524729 | 2022-12-16 04:21:01 | Black Hawk, Iowa, US | |
543514 | 543514 | 2022-12-15 | US | Florida | Unassigned | 90012 | 22922 | 511 | 0 | 30.86747479 | 0.0 | 2022-12-16 04:21:01 | Unassigned, Florida, US | |
349465 | 349465 | 2022-12-14 | US | Iowa | Black Hawk | 19013 | 37935 | 511 | 0 | 42.4704581 | -92.30524729 | 2022-12-15 04:20:58 | Black Hawk, Iowa, US | |
309053 | 309053 | 2022-12-13 | US | Iowa | Black Hawk | 19013 | 37737 | 511 | 0 | 42.4704581 | -92.30524729 | 2022-12-14 04:21:04 | Black Hawk, Iowa, US | |
308336 | 308336 | 2022-12-13 | US | Arizona | Coconino | 4005 | 51697 | 511 | 0 | 35.83883429 | -111.7707178 | 2022-12-14 04:21:04 | Coconino, Arizona, US | |
1150606 | 1150606 | 2022-12-12 | US | Michigan | Livingston | 26093 | 55714 | 511 | 0 | 42.60302282 | -83.91297209 | 2022-12-13 04:21:01 | Livingston, Michigan, US | |
1150114 | 1150114 | 2022-12-12 | US | Iowa | Black Hawk | 19013 | 37737 | 511 | 0 | 42.4704581 | -92.30524729 | 2022-12-13 04:21:01 | Black Hawk, Iowa, US | |
1149397 | 1149397 | 2022-12-12 | US | Arizona | Coconino | 4005 | 51697 | 511 | 0 | 35.83883429 | -111.7707178 | 2022-12-13 04:21:01 | Coconino, Arizona, US | |
870460 | 870460 | 2022-12-11 | US | Michigan | Livingston | 26093 | 55714 | 511 | 0 | 42.60302282 | -83.91297209 | 2022-12-12 04:21:01 | Livingston, Michigan, US | |
869968 | 869968 | 2022-12-11 | US | Iowa | Black Hawk | 19013 | 37737 | 511 | 0 | 42.4704581 | -92.30524729 | 2022-12-12 04:21:01 | Black Hawk, Iowa, US | |
869827 | 869827 | 2022-12-11 | US | Illinois | McHenry | 17111 | 94495 | 511 | 0 | 42.32451172 | -88.45248227 | 2022-12-12 04:21:01 | McHenry, Illinois, US | |
869251 | 869251 | 2022-12-11 | US | Arizona | Coconino | 4005 | 51697 | 511 | 0 | 35.83883429 | -111.7707178 | 2022-12-12 04:21:01 | Coconino, Arizona, US | |
258990 | 258990 | 2022-12-10 | US | Michigan | Livingston | 26093 | 55714 | 511 | 0 | 42.60302282 | -83.91297209 | 2022-12-11 04:20:50 | Livingston, Michigan, US | |
258498 | 258498 | 2022-12-10 | US | Iowa | Black Hawk | 19013 | 37737 | 511 | 0 | 42.4704581 | -92.30524729 | 2022-12-11 04:20:50 | Black Hawk, Iowa, US | |
258357 | 258357 | 2022-12-10 | US | Illinois | McHenry | 17111 | 94495 | 511 | 0 | 42.32451172 | -88.45248227 | 2022-12-11 04:20:50 | McHenry, Illinois, US | |
257781 | 257781 | 2022-12-10 | US | Arizona | Coconino | 4005 | 51697 | 511 | 0 | 35.83883429 | -111.7707178 | 2022-12-11 04:20:50 | Coconino, Arizona, US | |
3937704 | 3937704 | 2022-12-09 | US | Michigan | Livingston | 26093 | 55714 | 511 | 0 | 42.60302282 | -83.91297209 | 2022-12-10 04:21:02 | Livingston, Michigan, US | |
3937212 | 3937212 | 2022-12-09 | US | Iowa | Black Hawk | 19013 | 37737 | 511 | 0 | 42.4704581 | -92.30524729 | 2022-12-10 04:21:02 | Black Hawk, Iowa, US | |
3937071 | 3937071 | 2022-12-09 | US | Illinois | McHenry | 17111 | 94495 | 511 | 0 | 42.32451172 | -88.45248227 | 2022-12-10 04:21:02 | McHenry, Illinois, US | |
3936495 | 3936495 | 2022-12-09 | US | Arizona | Coconino | 4005 | 51697 | 511 | 0 | 35.83883429 | -111.7707178 | 2022-12-10 04:21:02 | Coconino, Arizona, US | |
3379036 | 3379036 | 2022-12-08 | US | Michigan | Livingston | 26093 | 55714 | 511 | 0 | 42.60302282 | -83.91297209 | 2022-12-09 04:21:05 | Livingston, Michigan, US | |
3378544 | 3378544 | 2022-12-08 | US | Iowa | Black Hawk | 19013 | 37737 | 511 | 0 | 42.4704581 | -92.30524729 | 2022-12-09 04:21:05 | Black Hawk, Iowa, US | |
3377827 | 3377827 | 2022-12-08 | US | Arizona | Coconino | 4005 | 51697 | 511 | 0 | 35.83883429 | -111.7707178 | 2022-12-09 04:21:05 | Coconino, Arizona, US | |
1986307 | 1986307 | 2022-12-07 | US | Michigan | Livingston | 26093 | 55714 | 511 | 0 | 42.60302282 | -83.91297209 | 2022-12-08 04:21:07 | Livingston, Michigan, US | |
1985815 | 1985815 | 2022-12-07 | US | Iowa | Black Hawk | 19013 | 37737 | 511 | 0 | 42.4704581 | -92.30524729 | 2022-12-08 04:21:07 | Black Hawk, Iowa, US | |
1985098 | 1985098 | 2022-12-07 | US | Arizona | Coconino | 4005 | 51697 | 511 | 0 | 35.83883429 | -111.7707178 | 2022-12-08 04:21:07 | Coconino, Arizona, US | |
3715830 | 3715830 | 2022-12-06 | US | Michigan | Livingston | 26093 | 55714 | 511 | 0 | 42.60302282 | -83.91297209 | 2022-12-07 04:20:58 | Livingston, Michigan, US | |
2417061 | 2417061 | 2022-12-05 | US | New Jersey | Sussex | 34037 | 43032 | 511 | 0 | 41.13891592 | -74.69118243 | 2022-12-06 04:21:03 | Sussex, New Jersey, US | |
720669 | 720669 | 2022-12-04 | US | New Jersey | Sussex | 34037 | 42946 | 511 | 0 | 41.13891592 | -74.69118243 | 2022-12-05 04:20:58 | Sussex, New Jersey, US | |
2818958 | 2818958 | 2022-12-03 | US | New Jersey | Sussex | 34037 | 42946 | 511 | 0 | 41.13891592 | -74.69118243 | 2022-12-04 04:20:56 | Sussex, New Jersey, US | |
835814 | 835814 | 2022-12-02 | US | New Jersey | Sussex | 34037 | 42946 | 511 | 0 | 41.13891592 | -74.69118243 | 2022-12-03 04:21:02 | Sussex, New Jersey, US | |
2138344 | 2138344 | 2022-12-01 | US | New Jersey | Sussex | 34037 | 42902 | 511 | 0 | 41.13891592 | -74.69118243 | 2022-12-02 04:21:07 | Sussex, New Jersey, US | |
2556595 | 2556595 | 2022-11-29 | Japan | Miyagi | 357597 | 511 | 0 | 38.446859 | 140.927086 | 2022-11-30 04:21:07 | Miyagi, Japan | |||
481263 | 481263 | 2022-11-08 | US | Michigan | Monroe | 26115 | 45761 | 511 | 0 | 41.92734151 | -83.53749864 | 2022-11-09 04:21:22 | Monroe, Michigan, US | |
2440413 | 2440413 | 2022-11-07 | US | Michigan | Monroe | 26115 | 45761 | 511 | 0 | 41.92734151 | -83.53749864 | 2022-11-08 04:21:21 | Monroe, Michigan, US | |
2439412 | 2439412 | 2022-11-07 | US | Connecticut | Middlesex | 9007 | 36455 | 511 | 0 | 41.45949668 | -72.53714864 | 2022-11-08 04:21:21 | Middlesex, Connecticut, US | |
1051511 | 1051511 | 2022-11-06 | US | Michigan | Monroe | 26115 | 45761 | 511 | 0 | 41.92734151 | -83.53749864 | 2022-11-07 04:21:26 | Monroe, Michigan, US | |
1050510 | 1050510 | 2022-11-06 | US | Connecticut | Middlesex | 9007 | 36445 | 511 | 0 | 41.45949668 | -72.53714864 | 2022-11-07 04:21:26 | Middlesex, Connecticut, US | |
619535 | 619535 | 2022-11-05 | US | Michigan | Monroe | 26115 | 45761 | 511 | 0 | 41.92734151 | -83.53749864 | 2022-11-06 04:21:24 | Monroe, Michigan, US | |
618534 | 618534 | 2022-11-05 | US | Connecticut | Middlesex | 9007 | 36435 | 511 | 0 | 41.45949668 | -72.53714864 | 2022-11-06 04:21:24 | Middlesex, Connecticut, US | |
1024039 | 1024039 | 2022-11-04 | US | Michigan | Monroe | 26115 | 45761 | 511 | 0 | 41.92734151 | -83.53749864 | 2022-11-05 04:21:52 | Monroe, Michigan, US | |
1023038 | 1023038 | 2022-11-04 | US | Connecticut | Middlesex | 9007 | 36414 | 511 | 0 | 41.45949668 | -72.53714864 | 2022-11-05 04:21:52 | Middlesex, Connecticut, US | |
433030 | 433030 | 2022-11-03 | US | Michigan | Monroe | 26115 | 45761 | 511 | 0 | 41.92734151 | -83.53749864 | 2022-11-04 04:22:11 | Monroe, Michigan, US | |
432029 | 432029 | 2022-11-03 | US | Connecticut | Middlesex | 9007 | 36392 | 511 | 0 | 41.45949668 | -72.53714864 | 2022-11-04 04:22:11 | Middlesex, Connecticut, US | |
851272 | 851272 | 2022-11-02 | US | Michigan | Monroe | 26115 | 45761 | 511 | 0 | 41.92734151 | -83.53749864 | 2022-11-03 04:22:05 | Monroe, Michigan, US | |
850271 | 850271 | 2022-11-02 | US | Connecticut | Middlesex | 9007 | 36367 | 511 | 0 | 41.45949668 | -72.53714864 | 2022-11-03 04:22:05 | Middlesex, Connecticut, US | |
713836 | 713836 | 2022-11-01 | US | Virginia | Norfolk | 51710 | 50772 | 511 | 0 | 36.89934014 | -76.26420872 | 2022-11-02 04:22:09 | Norfolk, Virginia, US | |
712123 | 712123 | 2022-11-01 | US | Michigan | Monroe | 26115 | 45761 | 511 | 0 | 41.92734151 | -83.53749864 | 2022-11-02 04:22:09 | Monroe, Michigan, US | |
711122 | 711122 | 2022-11-01 | US | Connecticut | Middlesex | 9007 | 36347 | 511 | 0 | 41.45949668 | -72.53714864 | 2022-11-02 04:22:09 | Middlesex, Connecticut, US | |
3288285 | 3288285 | 2022-10-31 | US | Virginia | Norfolk | 51710 | 50750 | 511 | 0 | 36.89934014 | -76.26420872 | 2022-11-01 04:22:36 | Norfolk, Virginia, US | |
323318 | 323318 | 2022-10-30 | US | Virginia | Norfolk | 51710 | 50702 | 511 | 0 | 36.89934014 | -76.26420872 | 2022-10-31 04:21:36 | Norfolk, Virginia, US | |
915594 | 915594 | 2022-10-29 | US | Virginia | Norfolk | 51710 | 50702 | 511 | 0 | 36.89934014 | -76.26420872 | 2022-10-30 04:22:14 | Norfolk, Virginia, US | |
1369863 | 1369863 | 2022-10-28 | US | Virginia | Norfolk | 51710 | 50702 | 511 | 0 | 36.89934014 | -76.26420872 | 2022-10-29 04:21:13 | Norfolk, Virginia, US | |
3041718 | 3041718 | 2022-10-27 | US | Virginia | Norfolk | 51710 | 50669 | 511 | 0 | 36.89934014 | -76.26420872 | 2022-10-28 04:22:31 | Norfolk, Virginia, US | |
542138 | 542138 | 2022-10-26 | US | Virginia | Norfolk | 51710 | 50639 | 511 | 0 | 36.89934014 | -76.26420872 | 2022-10-27 04:22:01 | Norfolk, Virginia, US | |
1833539 | 1833539 | 2022-10-25 | US | Virginia | Norfolk | 51710 | 50614 | 511 | 0 | 36.89934014 | -76.26420872 | 2022-10-26 04:22:19 | Norfolk, Virginia, US | |
3252526 | 3252526 | 2022-10-11 | US | North Carolina | Union | 37179 | 73516 | 511 | 0 | 34.98960527 | -80.52955873 | 2022-10-12 04:22:51 | Union, North Carolina, US | |
2969785 | 2969785 | 2022-10-10 | US | North Carolina | Union | 37179 | 73516 | 511 | 0 | 34.98960527 | -80.52955873 | 2022-10-11 04:23:05 | Union, North Carolina, US | |
3099821 | 3099821 | 2022-10-09 | US | North Carolina | Union | 37179 | 73516 | 511 | 0 | 34.98960527 | -80.52955873 | 2022-10-10 04:22:32 | Union, North Carolina, US | |
4005046 | 4005046 | 2022-10-08 | US | North Carolina | Union | 37179 | 73516 | 511 | 0 | 34.98960527 | -80.52955873 | 2022-10-09 04:21:16 | Union, North Carolina, US | |
398643 | 398643 | 2022-10-07 | US | North Carolina | Union | 37179 | 73516 | 511 | 0 | 34.98960527 | -80.52955873 | 2022-10-08 04:22:56 | Union, North Carolina, US | |
2531760 | 2531760 | 2022-10-06 | US | North Carolina | Union | 37179 | 73516 | 511 | 0 | 34.98960527 | -80.52955873 | 2022-10-07 04:23:08 | Union, North Carolina, US | |
1813154 | 1813154 | 2022-10-05 | US | North Carolina | Union | 37179 | 73516 | 511 | 0 | 34.98960527 | -80.52955873 | 2022-10-06 04:21:22 | Union, North Carolina, US | |
131538 | 131538 | 2022-10-04 | US | Georgia | Coweta | 13077 | 38663 | 511 | 0 | 33.35334302 | -84.76129976 | 2022-10-05 04:23:06 | Coweta, Georgia, US | |
2687545 | 2687545 | 2022-10-03 | US | Mississippi | Rankin | 28121 | 43650 | 511 | 0 | 32.26469147 | -89.94537876 | 2022-10-04 04:22:55 | Rankin, Mississippi, US | |
2686485 | 2686485 | 2022-10-03 | US | Georgia | Coweta | 13077 | 38663 | 511 | 0 | 33.35334302 | -84.76129976 | 2022-10-04 04:22:55 | Coweta, Georgia, US | |
2261612 | 2261612 | 2022-10-02 | US | Mississippi | Rankin | 28121 | 43650 | 511 | 0 | 32.26469147 | -89.94537876 | 2022-10-03 04:23:11 | Rankin, Mississippi, US | |
2260552 | 2260552 | 2022-10-02 | US | Georgia | Coweta | 13077 | 38663 | 511 | 0 | 33.35334302 | -84.76129976 | 2022-10-03 04:23:11 | Coweta, Georgia, US | |
2997138 | 2997138 | 2022-10-01 | US | Mississippi | Rankin | 28121 | 43650 | 511 | 0 | 32.26469147 | -89.94537876 | 2022-10-02 04:21:23 | Rankin, Mississippi, US | |
2996078 | 2996078 | 2022-10-01 | US | Georgia | Coweta | 13077 | 38663 | 511 | 0 | 33.35334302 | -84.76129976 | 2022-10-02 04:21:23 | Coweta, Georgia, US | |
855464 | 855464 | 2022-09-30 | US | Mississippi | Rankin | 28121 | 43650 | 511 | 0 | 32.26469147 | -89.94537876 | 2022-10-01 04:23:01 | Rankin, Mississippi, US | |
854404 | 854404 | 2022-09-30 | US | Georgia | Coweta | 13077 | 38663 | 511 | 0 | 33.35334302 | -84.76129976 | 2022-10-01 04:23:01 | Coweta, Georgia, US | |
2377390 | 2377390 | 2022-09-29 | US | Mississippi | Rankin | 28121 | 43650 | 511 | 0 | 32.26469147 | -89.94537876 | 2022-09-30 04:23:09 | Rankin, Mississippi, US | |
2376330 | 2376330 | 2022-09-29 | US | Georgia | Coweta | 13077 | 38663 | 511 | 0 | 33.35334302 | -84.76129976 | 2022-09-30 04:23:09 | Coweta, Georgia, US | |
1561941 | 1561941 | 2022-09-28 | US | Mississippi | Rankin | 28121 | 43650 | 511 | 0 | 32.26469147 | -89.94537876 | 2022-09-29 04:22:34 | Rankin, Mississippi, US | |
1560881 | 1560881 | 2022-09-28 | US | Georgia | Coweta | 13077 | 38663 | 511 | 0 | 33.35334302 | -84.76129976 | 2022-09-29 04:22:34 | Coweta, Georgia, US | |
3995424 | 3995424 | 2022-09-27 | US | Georgia | Coweta | 13077 | 38589 | 511 | 0 | 33.35334302 | -84.76129976 | 2022-09-28 04:23:01 | Coweta, Georgia, US | |
2771785 | 2771785 | 2022-09-26 | US | South Carolina | Dorchester | 45035 | 65789 | 511 | 0 | 33.0794369 | -80.40502652 | 2022-09-27 04:23:01 | Dorchester, South Carolina, US | |
2769752 | 2769752 | 2022-09-26 | US | Georgia | Coweta | 13077 | 38589 | 511 | 0 | 33.35334302 | -84.76129976 | 2022-09-27 04:23:01 | Coweta, Georgia, US | |
1979438 | 1979438 | 2022-09-25 | US | South Carolina | Dorchester | 45035 | 65789 | 511 | 0 | 33.0794369 | -80.40502652 | 2022-09-26 04:20:52 | Dorchester, South Carolina, US | |
1977405 | 1977405 | 2022-09-25 | US | Georgia | Coweta | 13077 | 38589 | 511 | 0 | 33.35334302 | -84.76129976 | 2022-09-26 04:20:52 | Coweta, Georgia, US | |
2652605 | 2652605 | 2022-09-24 | US | South Carolina | Dorchester | 45035 | 65789 | 511 | 0 | 33.0794369 | -80.40502652 | 2022-09-25 04:23:31 | Dorchester, South Carolina, US | |
2650572 | 2650572 | 2022-09-24 | US | Georgia | Coweta | 13077 | 38589 | 511 | 0 | 33.35334302 | -84.76129976 | 2022-09-25 04:23:31 | Coweta, Georgia, US | |
387045 | 387045 | 2022-09-23 | US | South Carolina | Dorchester | 45035 | 65789 | 511 | 0 | 33.0794369 | -80.40502652 | 2022-09-24 04:21:40 | Dorchester, South Carolina, US | |
385012 | 385012 | 2022-09-23 | US | Georgia | Coweta | 13077 | 38589 | 511 | 0 | 33.35334302 | -84.76129976 | 2022-09-24 04:21:40 | Coweta, Georgia, US | |
1627111 | 1627111 | 2022-09-22 | US | South Carolina | Dorchester | 45035 | 65789 | 511 | 0 | 33.0794369 | -80.40502652 | 2022-09-23 04:23:13 | Dorchester, South Carolina, US | |
1625078 | 1625078 | 2022-09-22 | US | Georgia | Coweta | 13077 | 38589 | 511 | 0 | 33.35334302 | -84.76129976 | 2022-09-23 04:23:13 | Coweta, Georgia, US | |
1373315 | 1373315 | 2022-09-21 | US | South Carolina | Dorchester | 45035 | 65789 | 511 | 0 | 33.0794369 | -80.40502652 | 2022-09-22 04:22:56 | Dorchester, South Carolina, US | |
1371282 | 1371282 | 2022-09-21 | US | Georgia | Coweta | 13077 | 38589 | 511 | 0 | 33.35334302 | -84.76129976 | 2022-09-22 04:22:56 | Coweta, Georgia, US | |
2019545 | 2019545 | 2022-09-20 | US | South Carolina | Dorchester | 45035 | 65789 | 511 | 0 | 33.0794369 | -80.40502652 | 2022-09-21 04:23:22 | Dorchester, South Carolina, US | |
3573418 | 3573418 | 2022-09-19 | US | South Carolina | Dorchester | 45035 | 65546 | 511 | 0 | 33.0794369 | -80.40502652 | 2022-09-20 04:22:48 | Dorchester, South Carolina, US | |
3570603 | 3570603 | 2022-09-19 | Japan | Mie | 245228 | 511 | 0 | 34.508018 | 136.376013 | 2022-09-20 04:22:48 | Mie, Japan | |||
422157 | 422157 | 2022-09-18 | US | South Carolina | Dorchester | 45035 | 65546 | 511 | 0 | 33.0794369 | -80.40502652 | 2022-09-19 04:21:49 | Dorchester, South Carolina, US | |
3376181 | 3376181 | 2022-09-17 | US | South Carolina | Dorchester | 45035 | 65546 | 511 | 0 | 33.0794369 | -80.40502652 | 2022-09-18 04:22:50 | Dorchester, South Carolina, 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]);