johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,862 rows where country_or_region = "US" and deaths = 221 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Florida 245
- Texas 167
- Ohio 117
- North Carolina 102
- Tennessee 101
- Georgia 90
- South Carolina 84
- Michigan 78
- Virginia 61
- New York 59
- Louisiana 57
- Kentucky 51
- Indiana 49
- California 45
- Alabama 40
- Arkansas 38
- New Mexico 35
- Washington 34
- Missouri 33
- Wisconsin 33
- Illinois 30
- Oregon 30
- Pennsylvania 29
- Mississippi 24
- Colorado 22
- Utah 20
- Iowa 18
- Maryland 17
- New Hampshire 17
- Oklahoma 15
- …
country_or_region 1
- US · 1,862 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2753807 | 2753807 | 2022-12-29 | US | Georgia | Wayne | 13305 | 8725 | 221 | 0 | 31.5521809 | -81.91894878 | 2022-12-30 04:21:04 | Wayne, Georgia, US | |
1074813 | 1074813 | 2022-12-28 | US | Georgia | Wayne | 13305 | 8725 | 221 | 0 | 31.5521809 | -81.91894878 | 2022-12-29 04:21:01 | Wayne, Georgia, US | |
1076119 | 1076119 | 2022-12-28 | US | New Mexico | Otero | 35035 | 16783 | 221 | 0 | 32.61348406 | -105.7417604 | 2022-12-29 04:21:01 | Otero, New Mexico, US | |
328810 | 328810 | 2022-12-27 | US | Georgia | Wayne | 13305 | 8694 | 221 | 0 | 31.5521809 | -81.91894878 | 2022-12-28 04:21:04 | Wayne, Georgia, US | |
330116 | 330116 | 2022-12-27 | US | New Mexico | Otero | 35035 | 16767 | 221 | 0 | 32.61348406 | -105.7417604 | 2022-12-28 04:21:04 | Otero, New Mexico, US | |
218883 | 218883 | 2022-12-26 | US | Georgia | Wayne | 13305 | 8694 | 221 | 0 | 31.5521809 | -81.91894878 | 2022-12-27 04:21:07 | Wayne, Georgia, US | |
220189 | 220189 | 2022-12-26 | US | New Mexico | Otero | 35035 | 16705 | 221 | 0 | 32.61348406 | -105.7417604 | 2022-12-27 04:21:07 | Otero, New Mexico, US | |
3223340 | 3223340 | 2022-12-25 | US | Georgia | Wayne | 13305 | 8694 | 221 | 0 | 31.5521809 | -81.91894878 | 2022-12-26 04:21:06 | Wayne, Georgia, US | |
3224646 | 3224646 | 2022-12-25 | US | New Mexico | Otero | 35035 | 16705 | 221 | 0 | 32.61348406 | -105.7417604 | 2022-12-26 04:21:06 | Otero, New Mexico, US | |
1019254 | 1019254 | 2022-12-24 | US | Georgia | Wayne | 13305 | 8694 | 221 | 0 | 31.5521809 | -81.91894878 | 2022-12-25 04:21:04 | Wayne, Georgia, US | |
1020560 | 1020560 | 2022-12-24 | US | New Mexico | Otero | 35035 | 16705 | 221 | 0 | 32.61348406 | -105.7417604 | 2022-12-25 04:21:04 | Otero, New Mexico, US | |
691277 | 691277 | 2022-12-23 | US | Georgia | Wayne | 13305 | 8694 | 221 | 0 | 31.5521809 | -81.91894878 | 2022-12-24 04:21:02 | Wayne, Georgia, US | |
692583 | 692583 | 2022-12-23 | US | New Mexico | Otero | 35035 | 16705 | 221 | 0 | 32.61348406 | -105.7417604 | 2022-12-24 04:21:02 | Otero, New Mexico, US | |
2180487 | 2180487 | 2022-12-22 | US | Georgia | Wayne | 13305 | 8694 | 221 | 0 | 31.5521809 | -81.91894878 | 2022-12-23 04:21:04 | Wayne, Georgia, US | |
452291 | 452291 | 2022-12-21 | US | Georgia | Wayne | 13305 | 8694 | 221 | 0 | 31.5521809 | -81.91894878 | 2022-12-22 04:20:56 | Wayne, Georgia, US | |
2952290 | 2952290 | 2022-12-20 | US | Georgia | Wayne | 13305 | 8663 | 221 | 0 | 31.5521809 | -81.91894878 | 2022-12-21 04:21:03 | Wayne, Georgia, US | |
3174692 | 3174692 | 2022-12-19 | US | Georgia | Wayne | 13305 | 8663 | 221 | 0 | 31.5521809 | -81.91894878 | 2022-12-20 04:21:04 | Wayne, Georgia, US | |
1629209 | 1629209 | 2022-12-18 | US | Georgia | Wayne | 13305 | 8663 | 221 | 0 | 31.5521809 | -81.91894878 | 2022-12-19 04:21:03 | Wayne, Georgia, US | |
504588 | 504588 | 2022-12-17 | US | Georgia | Wayne | 13305 | 8663 | 221 | 0 | 31.5521809 | -81.91894878 | 2022-12-18 04:21:03 | Wayne, Georgia, US | |
3325160 | 3325160 | 2022-12-16 | US | Georgia | Wayne | 13305 | 8663 | 221 | 0 | 31.5521809 | -81.91894878 | 2022-12-17 04:21:04 | Wayne, Georgia, US | |
543672 | 543672 | 2022-12-15 | US | Georgia | Wayne | 13305 | 8663 | 221 | 0 | 31.5521809 | -81.91894878 | 2022-12-16 04:21:01 | Wayne, Georgia, US | |
349200 | 349200 | 2022-12-14 | US | Georgia | Wayne | 13305 | 8663 | 221 | 0 | 31.5521809 | -81.91894878 | 2022-12-15 04:20:58 | Wayne, Georgia, US | |
308788 | 308788 | 2022-12-13 | US | Georgia | Wayne | 13305 | 8626 | 221 | 0 | 31.5521809 | -81.91894878 | 2022-12-14 04:21:04 | Wayne, Georgia, US | |
1149849 | 1149849 | 2022-12-12 | US | Georgia | Wayne | 13305 | 8626 | 221 | 0 | 31.5521809 | -81.91894878 | 2022-12-13 04:21:01 | Wayne, Georgia, US | |
869703 | 869703 | 2022-12-11 | US | Georgia | Wayne | 13305 | 8626 | 221 | 0 | 31.5521809 | -81.91894878 | 2022-12-12 04:21:01 | Wayne, Georgia, US | |
872283 | 872283 | 2022-12-11 | US | West Virginia | Fayette | 54019 | 16064 | 221 | 0 | 38.02974928 | -81.08286634 | 2022-12-12 04:21:01 | Fayette, West Virginia, US | |
258233 | 258233 | 2022-12-10 | US | Georgia | Wayne | 13305 | 8626 | 221 | 0 | 31.5521809 | -81.91894878 | 2022-12-11 04:20:50 | Wayne, Georgia, US | |
260813 | 260813 | 2022-12-10 | US | West Virginia | Fayette | 54019 | 16064 | 221 | 0 | 38.02974928 | -81.08286634 | 2022-12-11 04:20:50 | Fayette, West Virginia, US | |
3936947 | 3936947 | 2022-12-09 | US | Georgia | Wayne | 13305 | 8626 | 221 | 0 | 31.5521809 | -81.91894878 | 2022-12-10 04:21:02 | Wayne, Georgia, US | |
3939527 | 3939527 | 2022-12-09 | US | West Virginia | Fayette | 54019 | 16064 | 221 | 0 | 38.02974928 | -81.08286634 | 2022-12-10 04:21:02 | Fayette, West Virginia, US | |
3378279 | 3378279 | 2022-12-08 | US | Georgia | Wayne | 13305 | 8626 | 221 | 0 | 31.5521809 | -81.91894878 | 2022-12-09 04:21:05 | Wayne, Georgia, US | |
3379637 | 3379637 | 2022-12-08 | US | New York | Oswego | 36075 | 33412 | 221 | 0 | 43.42778894 | -76.14635194 | 2022-12-09 04:21:05 | Oswego, New York, US | |
3380859 | 3380859 | 2022-12-08 | US | West Virginia | Fayette | 54019 | 16064 | 221 | 0 | 38.02974928 | -81.08286634 | 2022-12-09 04:21:05 | Fayette, West Virginia, US | |
1985550 | 1985550 | 2022-12-07 | US | Georgia | Wayne | 13305 | 8587 | 221 | 0 | 31.5521809 | -81.91894878 | 2022-12-08 04:21:07 | Wayne, Georgia, US | |
1986908 | 1986908 | 2022-12-07 | US | New York | Oswego | 36075 | 33397 | 221 | 0 | 43.42778894 | -76.14635194 | 2022-12-08 04:21:07 | Oswego, New York, US | |
1988130 | 1988130 | 2022-12-07 | US | West Virginia | Fayette | 54019 | 16060 | 221 | 0 | 38.02974928 | -81.08286634 | 2022-12-08 04:21:07 | Fayette, West Virginia, US | |
3715073 | 3715073 | 2022-12-06 | US | Georgia | Wayne | 13305 | 8587 | 221 | 0 | 31.5521809 | -81.91894878 | 2022-12-07 04:20:58 | Wayne, Georgia, US | |
3716431 | 3716431 | 2022-12-06 | US | New York | Oswego | 36075 | 33372 | 221 | 0 | 43.42778894 | -76.14635194 | 2022-12-07 04:20:58 | Oswego, New York, US | |
3717653 | 3717653 | 2022-12-06 | US | West Virginia | Fayette | 54019 | 16046 | 221 | 0 | 38.02974928 | -81.08286634 | 2022-12-07 04:20:58 | Fayette, West Virginia, US | |
2415778 | 2415778 | 2022-12-05 | US | Georgia | Wayne | 13305 | 8587 | 221 | 0 | 31.5521809 | -81.91894878 | 2022-12-06 04:21:03 | Wayne, Georgia, US | |
2418358 | 2418358 | 2022-12-05 | US | West Virginia | Fayette | 54019 | 16045 | 221 | 0 | 38.02974928 | -81.08286634 | 2022-12-06 04:21:03 | Fayette, West Virginia, US | |
719386 | 719386 | 2022-12-04 | US | Georgia | Wayne | 13305 | 8587 | 221 | 0 | 31.5521809 | -81.91894878 | 2022-12-05 04:20:58 | Wayne, Georgia, US | |
721966 | 721966 | 2022-12-04 | US | West Virginia | Fayette | 54019 | 16011 | 221 | 0 | 38.02974928 | -81.08286634 | 2022-12-05 04:20:58 | Fayette, West Virginia, US | |
2817675 | 2817675 | 2022-12-03 | US | Georgia | Wayne | 13305 | 8587 | 221 | 0 | 31.5521809 | -81.91894878 | 2022-12-04 04:20:56 | Wayne, Georgia, US | |
2820255 | 2820255 | 2022-12-03 | US | West Virginia | Fayette | 54019 | 16011 | 221 | 0 | 38.02974928 | -81.08286634 | 2022-12-04 04:20:56 | Fayette, West Virginia, US | |
834531 | 834531 | 2022-12-02 | US | Georgia | Wayne | 13305 | 8587 | 221 | 0 | 31.5521809 | -81.91894878 | 2022-12-03 04:21:02 | Wayne, Georgia, US | |
837111 | 837111 | 2022-12-02 | US | West Virginia | Fayette | 54019 | 16011 | 221 | 0 | 38.02974928 | -81.08286634 | 2022-12-03 04:21:02 | Fayette, West Virginia, US | |
2137061 | 2137061 | 2022-12-01 | US | Georgia | Wayne | 13305 | 8587 | 221 | 0 | 31.5521809 | -81.91894878 | 2022-12-02 04:21:07 | Wayne, Georgia, US | |
2139641 | 2139641 | 2022-12-01 | US | West Virginia | Fayette | 54019 | 16002 | 221 | 0 | 38.02974928 | -81.08286634 | 2022-12-02 04:21:07 | Fayette, West Virginia, US | |
1965477 | 1965477 | 2022-11-30 | US | Georgia | Wayne | 13305 | 8587 | 221 | 0 | 31.5521809 | -81.91894878 | 2022-12-01 04:21:03 | Wayne, Georgia, US | |
1968005 | 1968005 | 2022-11-30 | US | Virginia | Wise | 51195 | 13200 | 221 | 0 | 36.9746148 | -82.62410519 | 2022-12-01 04:21:03 | Wise, Virginia, US | |
1968057 | 1968057 | 2022-11-30 | US | West Virginia | Fayette | 54019 | 15999 | 221 | 0 | 38.02974928 | -81.08286634 | 2022-12-01 04:21:03 | Fayette, West Virginia, US | |
2557491 | 2557491 | 2022-11-29 | US | Georgia | Wayne | 13305 | 8557 | 221 | 0 | 31.5521809 | -81.91894878 | 2022-11-30 04:21:07 | Wayne, Georgia, US | |
2560071 | 2560071 | 2022-11-29 | US | West Virginia | Fayette | 54019 | 15993 | 221 | 0 | 38.02974928 | -81.08286634 | 2022-11-30 04:21:07 | Fayette, West Virginia, US | |
1240565 | 1240565 | 2022-11-28 | US | Georgia | Wayne | 13305 | 8557 | 221 | 0 | 31.5521809 | -81.91894878 | 2022-11-29 04:21:05 | Wayne, Georgia, US | |
3552553 | 3552553 | 2022-11-27 | US | Georgia | Wayne | 13305 | 8557 | 221 | 0 | 31.5521809 | -81.91894878 | 2022-11-28 04:21:02 | Wayne, Georgia, US | |
2101033 | 2101033 | 2022-11-26 | US | Georgia | Wayne | 13305 | 8557 | 221 | 0 | 31.5521809 | -81.91894878 | 2022-11-27 04:21:05 | Wayne, Georgia, US | |
488524 | 488524 | 2022-11-25 | US | Georgia | Wayne | 13305 | 8557 | 221 | 0 | 31.5521809 | -81.91894878 | 2022-11-26 04:21:11 | Wayne, Georgia, US | |
3524353 | 3524353 | 2022-11-24 | US | Georgia | Wayne | 13305 | 8557 | 221 | 0 | 31.5521809 | -81.91894878 | 2022-11-25 04:21:06 | Wayne, Georgia, US | |
3313136 | 3313136 | 2022-11-23 | US | Georgia | Wayne | 13305 | 8557 | 221 | 0 | 31.5521809 | -81.91894878 | 2022-11-24 04:21:09 | Wayne, Georgia, US | |
2488942 | 2488942 | 2022-11-16 | US | Tennessee | Dyer | 47045 | 14816 | 221 | 0 | 36.05931946 | -89.41542855 | 2022-11-17 04:21:11 | Dyer, Tennessee, US | |
294953 | 294953 | 2022-11-15 | US | Tennessee | Dyer | 47045 | 14809 | 221 | 0 | 36.05931946 | -89.41542855 | 2022-11-16 04:21:09 | Dyer, Tennessee, US | |
3599983 | 3599983 | 2022-11-14 | US | Tennessee | Dyer | 47045 | 14802 | 221 | 0 | 36.05931946 | -89.41542855 | 2022-11-15 04:21:16 | Dyer, Tennessee, US | |
314841 | 314841 | 2022-11-13 | US | Tennessee | Dyer | 47045 | 14794 | 221 | 0 | 36.05931946 | -89.41542855 | 2022-11-14 04:21:09 | Dyer, Tennessee, US | |
66002 | 66002 | 2022-11-12 | US | Tennessee | Dyer | 47045 | 14794 | 221 | 0 | 36.05931946 | -89.41542855 | 2022-11-13 04:21:14 | Dyer, Tennessee, US | |
2930164 | 2930164 | 2022-11-11 | US | Tennessee | Dyer | 47045 | 14794 | 221 | 0 | 36.05931946 | -89.41542855 | 2022-11-12 04:20:41 | Dyer, Tennessee, US | |
2509000 | 2509000 | 2022-11-10 | US | Tennessee | Dyer | 47045 | 14792 | 221 | 0 | 36.05931946 | -89.41542855 | 2022-11-11 04:21:22 | Dyer, Tennessee, US | |
2433875 | 2433875 | 2022-11-09 | US | Tennessee | Dyer | 47045 | 14788 | 221 | 0 | 36.05931946 | -89.41542855 | 2022-11-10 04:21:16 | Dyer, Tennessee, US | |
482531 | 482531 | 2022-11-08 | US | Tennessee | Dyer | 47045 | 14784 | 221 | 0 | 36.05931946 | -89.41542855 | 2022-11-09 04:21:22 | Dyer, Tennessee, US | |
482558 | 482558 | 2022-11-08 | US | Tennessee | Lawrence | 47099 | 16330 | 221 | 0 | 35.21675201 | -87.39787695 | 2022-11-09 04:21:22 | Lawrence, Tennessee, US | |
2441681 | 2441681 | 2022-11-07 | US | Tennessee | Dyer | 47045 | 14779 | 221 | 0 | 36.05931946 | -89.41542855 | 2022-11-08 04:21:21 | Dyer, Tennessee, US | |
1052779 | 1052779 | 2022-11-06 | US | Tennessee | Dyer | 47045 | 14772 | 221 | 0 | 36.05931946 | -89.41542855 | 2022-11-07 04:21:26 | Dyer, Tennessee, US | |
620803 | 620803 | 2022-11-05 | US | Tennessee | Dyer | 47045 | 14772 | 221 | 0 | 36.05931946 | -89.41542855 | 2022-11-06 04:21:24 | Dyer, Tennessee, US | |
1025307 | 1025307 | 2022-11-04 | US | Tennessee | Dyer | 47045 | 14770 | 221 | 0 | 36.05931946 | -89.41542855 | 2022-11-05 04:21:52 | Dyer, Tennessee, US | |
434298 | 434298 | 2022-11-03 | US | Tennessee | Dyer | 47045 | 14768 | 221 | 0 | 36.05931946 | -89.41542855 | 2022-11-04 04:22:11 | Dyer, Tennessee, US | |
852540 | 852540 | 2022-11-02 | US | Tennessee | Dyer | 47045 | 14764 | 221 | 0 | 36.05931946 | -89.41542855 | 2022-11-03 04:22:05 | Dyer, Tennessee, US | |
713391 | 713391 | 2022-11-01 | US | Tennessee | Dyer | 47045 | 14757 | 221 | 0 | 36.05931946 | -89.41542855 | 2022-11-02 04:22:09 | Dyer, Tennessee, US | |
3287840 | 3287840 | 2022-10-31 | US | Tennessee | Dyer | 47045 | 14751 | 221 | 0 | 36.05931946 | -89.41542855 | 2022-11-01 04:22:36 | Dyer, Tennessee, US | |
322873 | 322873 | 2022-10-30 | US | Tennessee | Dyer | 47045 | 14742 | 221 | 0 | 36.05931946 | -89.41542855 | 2022-10-31 04:21:36 | Dyer, Tennessee, US | |
915149 | 915149 | 2022-10-29 | US | Tennessee | Dyer | 47045 | 14741 | 221 | 0 | 36.05931946 | -89.41542855 | 2022-10-30 04:22:14 | Dyer, Tennessee, US | |
1369418 | 1369418 | 2022-10-28 | US | Tennessee | Dyer | 47045 | 14740 | 221 | 0 | 36.05931946 | -89.41542855 | 2022-10-29 04:21:13 | Dyer, Tennessee, US | |
3041273 | 3041273 | 2022-10-27 | US | Tennessee | Dyer | 47045 | 14738 | 221 | 0 | 36.05931946 | -89.41542855 | 2022-10-28 04:22:31 | Dyer, Tennessee, US | |
541693 | 541693 | 2022-10-26 | US | Tennessee | Dyer | 47045 | 14737 | 221 | 0 | 36.05931946 | -89.41542855 | 2022-10-27 04:22:01 | Dyer, Tennessee, US | |
1831119 | 1831119 | 2022-10-25 | US | Illinois | Adams | 17001 | 26040 | 221 | 0 | 39.98815591 | -91.18786813 | 2022-10-26 04:22:19 | Adams, Illinois, US | |
1832614 | 1832614 | 2022-10-25 | US | Ohio | Crawford | 39033 | 13355 | 221 | 0 | 40.85065156 | -82.91989099 | 2022-10-26 04:22:19 | Crawford, Ohio, US | |
1833094 | 1833094 | 2022-10-25 | US | Tennessee | Dyer | 47045 | 14732 | 221 | 0 | 36.05931946 | -89.41542855 | 2022-10-26 04:22:19 | Dyer, Tennessee, US | |
795380 | 795380 | 2022-10-24 | US | Illinois | Adams | 17001 | 26028 | 221 | 0 | 39.98815591 | -91.18786813 | 2022-10-25 04:21:53 | Adams, Illinois, US | |
796046 | 796046 | 2022-10-24 | US | Michigan | Clinton | 26037 | 26256 | 221 | 0 | 42.94400871 | -84.60145248 | 2022-10-25 04:21:53 | Clinton, Michigan, US | |
796875 | 796875 | 2022-10-24 | US | Ohio | Crawford | 39033 | 13355 | 221 | 0 | 40.85065156 | -82.91989099 | 2022-10-25 04:21:53 | Crawford, Ohio, US | |
797355 | 797355 | 2022-10-24 | US | Tennessee | Dyer | 47045 | 14726 | 221 | 0 | 36.05931946 | -89.41542855 | 2022-10-25 04:21:53 | Dyer, Tennessee, US | |
3277835 | 3277835 | 2022-10-23 | US | Illinois | Adams | 17001 | 26017 | 221 | 0 | 39.98815591 | -91.18786813 | 2022-10-24 04:22:29 | Adams, Illinois, US | |
3278501 | 3278501 | 2022-10-23 | US | Michigan | Clinton | 26037 | 26256 | 221 | 0 | 42.94400871 | -84.60145248 | 2022-10-24 04:22:29 | Clinton, Michigan, US | |
3279330 | 3279330 | 2022-10-23 | US | Ohio | Crawford | 39033 | 13355 | 221 | 0 | 40.85065156 | -82.91989099 | 2022-10-24 04:22:29 | Crawford, Ohio, US | |
3279810 | 3279810 | 2022-10-23 | US | Tennessee | Dyer | 47045 | 14715 | 221 | 0 | 36.05931946 | -89.41542855 | 2022-10-24 04:22:29 | Dyer, Tennessee, US | |
2268873 | 2268873 | 2022-10-22 | US | Illinois | Adams | 17001 | 26017 | 221 | 0 | 39.98815591 | -91.18786813 | 2022-10-23 04:22:46 | Adams, Illinois, US | |
2269539 | 2269539 | 2022-10-22 | US | Michigan | Clinton | 26037 | 26256 | 221 | 0 | 42.94400871 | -84.60145248 | 2022-10-23 04:22:46 | Clinton, Michigan, US | |
2270368 | 2270368 | 2022-10-22 | US | Ohio | Crawford | 39033 | 13355 | 221 | 0 | 40.85065156 | -82.91989099 | 2022-10-23 04:22:46 | Crawford, Ohio, US | |
2270848 | 2270848 | 2022-10-22 | US | Tennessee | Dyer | 47045 | 14715 | 221 | 0 | 36.05931946 | -89.41542855 | 2022-10-23 04:22:46 | Dyer, Tennessee, US | |
1593173 | 1593173 | 2022-10-21 | US | Illinois | Adams | 17001 | 26017 | 221 | 0 | 39.98815591 | -91.18786813 | 2022-10-22 04:22:53 | Adams, Illinois, US | |
1593839 | 1593839 | 2022-10-21 | US | Michigan | Clinton | 26037 | 26256 | 221 | 0 | 42.94400871 | -84.60145248 | 2022-10-22 04:22:53 | Clinton, Michigan, 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]);