johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
126 rows where country_or_region = "US" and deaths = 1034 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 27
- Nebraska 16
- Alabama 15
- Georgia 14
- Texas 14
- South Carolina 10
- New Jersey 9
- Ohio 7
- Indiana 4
- New York 4
- Michigan 3
- North Carolina 3
- Pennsylvania 3
- Virginia 3
- Connecticut 2
- Florida 2
- Idaho 2
- Illinois 2
- Louisiana 2
- Maryland 2
- Washington 2
- Arizona 1
- Arkansas 1
- Colorado 1
- Kentucky 1
- Massachusetts 1
- Minnesota 1
- Oklahoma 1
country_or_region 1
- US · 126 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
330082 | 330082 | 2022-12-27 | US | New Jersey | Gloucester | 34015 | 87942 | 1034 | 0 | 39.71581067 | -75.13995546 | 2022-12-28 04:21:04 | Gloucester, New Jersey, US | |
220155 | 220155 | 2022-12-26 | US | New Jersey | Gloucester | 34015 | 87769 | 1034 | 0 | 39.71581067 | -75.13995546 | 2022-12-27 04:21:07 | Gloucester, New Jersey, US | |
3224612 | 3224612 | 2022-12-25 | US | New Jersey | Gloucester | 34015 | 87769 | 1034 | 0 | 39.71581067 | -75.13995546 | 2022-12-26 04:21:06 | Gloucester, New Jersey, US | |
1020526 | 1020526 | 2022-12-24 | US | New Jersey | Gloucester | 34015 | 87769 | 1034 | 0 | 39.71581067 | -75.13995546 | 2022-12-25 04:21:04 | Gloucester, New Jersey, US | |
692549 | 692549 | 2022-12-23 | US | New Jersey | Gloucester | 34015 | 87769 | 1034 | 0 | 39.71581067 | -75.13995546 | 2022-12-24 04:21:02 | Gloucester, New Jersey, US | |
2556980 | 2556980 | 2022-11-29 | US | Alabama | Madison | 1089 | 109327 | 1034 | 0 | 34.76327133 | -86.55069633 | 2022-11-30 04:21:07 | Madison, Alabama, US | |
1240054 | 1240054 | 2022-11-28 | US | Alabama | Madison | 1089 | 109327 | 1034 | 0 | 34.76327133 | -86.55069633 | 2022-11-29 04:21:05 | Madison, Alabama, US | |
3552042 | 3552042 | 2022-11-27 | US | Alabama | Madison | 1089 | 109327 | 1034 | 0 | 34.76327133 | -86.55069633 | 2022-11-28 04:21:02 | Madison, Alabama, US | |
2100522 | 2100522 | 2022-11-26 | US | Alabama | Madison | 1089 | 109327 | 1034 | 0 | 34.76327133 | -86.55069633 | 2022-11-27 04:21:05 | Madison, Alabama, US | |
488013 | 488013 | 2022-11-25 | US | Alabama | Madison | 1089 | 109327 | 1034 | 0 | 34.76327133 | -86.55069633 | 2022-11-26 04:21:11 | Madison, Alabama, US | |
3523842 | 3523842 | 2022-11-24 | US | Alabama | Madison | 1089 | 109327 | 1034 | 0 | 34.76327133 | -86.55069633 | 2022-11-25 04:21:06 | Madison, Alabama, US | |
3312625 | 3312625 | 2022-11-23 | US | Alabama | Madison | 1089 | 109327 | 1034 | 0 | 34.76327133 | -86.55069633 | 2022-11-24 04:21:09 | Madison, Alabama, US | |
1620666 | 1620666 | 2022-11-22 | US | Alabama | Madison | 1089 | 109100 | 1034 | 0 | 34.76327133 | -86.55069633 | 2022-11-23 04:21:06 | Madison, Alabama, US | |
3460554 | 3460554 | 2022-11-21 | US | Alabama | Madison | 1089 | 109100 | 1034 | 0 | 34.76327133 | -86.55069633 | 2022-11-22 04:20:47 | Madison, Alabama, US | |
1640739 | 1640739 | 2022-11-20 | US | Alabama | Madison | 1089 | 109100 | 1034 | 0 | 34.76327133 | -86.55069633 | 2022-11-21 04:21:05 | Madison, Alabama, US | |
2064296 | 2064296 | 2022-11-19 | US | Alabama | Madison | 1089 | 109100 | 1034 | 0 | 34.76327133 | -86.55069633 | 2022-11-20 04:21:08 | Madison, Alabama, US | |
1755690 | 1755690 | 2022-11-18 | US | Alabama | Madison | 1089 | 109100 | 1034 | 0 | 34.76327133 | -86.55069633 | 2022-11-19 04:21:14 | Madison, Alabama, US | |
3026683 | 3026683 | 2022-11-17 | US | Alabama | Madison | 1089 | 109100 | 1034 | 0 | 34.76327133 | -86.55069633 | 2022-11-18 04:21:15 | Madison, Alabama, US | |
2486394 | 2486394 | 2022-11-16 | US | Alabama | Madison | 1089 | 109100 | 1034 | 0 | 34.76327133 | -86.55069633 | 2022-11-17 04:21:11 | Madison, Alabama, US | |
3250929 | 3250929 | 2022-10-11 | US | Georgia | Clayton | 13063 | 74087 | 1034 | 0 | 33.54187245 | -84.35594188 | 2022-10-12 04:22:51 | Clayton, Georgia, US | |
2968188 | 2968188 | 2022-10-10 | US | Georgia | Clayton | 13063 | 74087 | 1034 | 0 | 33.54187245 | -84.35594188 | 2022-10-11 04:23:05 | Clayton, Georgia, US | |
2970214 | 2970214 | 2022-10-10 | US | South Carolina | Anderson | 45007 | 65385 | 1034 | 0 | 34.51828081 | -82.63959517 | 2022-10-11 04:23:05 | Anderson, South Carolina, US | |
3098224 | 3098224 | 2022-10-09 | US | Georgia | Clayton | 13063 | 74087 | 1034 | 0 | 33.54187245 | -84.35594188 | 2022-10-10 04:22:32 | Clayton, Georgia, US | |
3100250 | 3100250 | 2022-10-09 | US | South Carolina | Anderson | 45007 | 65385 | 1034 | 0 | 34.51828081 | -82.63959517 | 2022-10-10 04:22:32 | Anderson, South Carolina, US | |
4003449 | 4003449 | 2022-10-08 | US | Georgia | Clayton | 13063 | 74087 | 1034 | 0 | 33.54187245 | -84.35594188 | 2022-10-09 04:21:16 | Clayton, Georgia, US | |
4005475 | 4005475 | 2022-10-08 | US | South Carolina | Anderson | 45007 | 65385 | 1034 | 0 | 34.51828081 | -82.63959517 | 2022-10-09 04:21:16 | Anderson, South Carolina, US | |
397046 | 397046 | 2022-10-07 | US | Georgia | Clayton | 13063 | 74087 | 1034 | 0 | 33.54187245 | -84.35594188 | 2022-10-08 04:22:56 | Clayton, Georgia, US | |
399072 | 399072 | 2022-10-07 | US | South Carolina | Anderson | 45007 | 65385 | 1034 | 0 | 34.51828081 | -82.63959517 | 2022-10-08 04:22:56 | Anderson, South Carolina, US | |
2530163 | 2530163 | 2022-10-06 | US | Georgia | Clayton | 13063 | 74087 | 1034 | 0 | 33.54187245 | -84.35594188 | 2022-10-07 04:23:08 | Clayton, Georgia, US | |
2532189 | 2532189 | 2022-10-06 | US | South Carolina | Anderson | 45007 | 65385 | 1034 | 0 | 34.51828081 | -82.63959517 | 2022-10-07 04:23:08 | Anderson, South Carolina, US | |
1811557 | 1811557 | 2022-10-05 | US | Georgia | Clayton | 13063 | 74087 | 1034 | 0 | 33.54187245 | -84.35594188 | 2022-10-06 04:21:22 | Clayton, Georgia, US | |
1813583 | 1813583 | 2022-10-05 | US | South Carolina | Anderson | 45007 | 65385 | 1034 | 0 | 34.51828081 | -82.63959517 | 2022-10-06 04:21:22 | Anderson, South Carolina, US | |
131531 | 131531 | 2022-10-04 | US | Georgia | Clayton | 13063 | 73861 | 1034 | 0 | 33.54187245 | -84.35594188 | 2022-10-05 04:23:06 | Clayton, Georgia, US | |
133557 | 133557 | 2022-10-04 | US | South Carolina | Anderson | 45007 | 65385 | 1034 | 0 | 34.51828081 | -82.63959517 | 2022-10-05 04:23:06 | Anderson, South Carolina, US | |
2686478 | 2686478 | 2022-10-03 | US | Georgia | Clayton | 13063 | 73861 | 1034 | 0 | 33.54187245 | -84.35594188 | 2022-10-04 04:22:55 | Clayton, Georgia, US | |
2260545 | 2260545 | 2022-10-02 | US | Georgia | Clayton | 13063 | 73861 | 1034 | 0 | 33.54187245 | -84.35594188 | 2022-10-03 04:23:11 | Clayton, Georgia, US | |
2996071 | 2996071 | 2022-10-01 | US | Georgia | Clayton | 13063 | 73861 | 1034 | 0 | 33.54187245 | -84.35594188 | 2022-10-02 04:21:23 | Clayton, Georgia, US | |
854397 | 854397 | 2022-09-30 | US | Georgia | Clayton | 13063 | 73861 | 1034 | 0 | 33.54187245 | -84.35594188 | 2022-10-01 04:23:01 | Clayton, Georgia, US | |
2376323 | 2376323 | 2022-09-29 | US | Georgia | Clayton | 13063 | 73861 | 1034 | 0 | 33.54187245 | -84.35594188 | 2022-09-30 04:23:09 | Clayton, Georgia, US | |
1560874 | 1560874 | 2022-09-28 | US | Georgia | Clayton | 13063 | 73861 | 1034 | 0 | 33.54187245 | -84.35594188 | 2022-09-29 04:22:34 | Clayton, Georgia, US | |
3429883 | 3429883 | 2022-07-14 | US | Idaho | Ada | 16001 | 144368 | 1034 | 0 | 43.4526575 | -116.2415516 | 2022-07-15 04:20:53 | Ada, Idaho, US | |
3110403 | 3110403 | 2022-07-13 | US | Idaho | Ada | 16001 | 144368 | 1034 | 0 | 43.4526575 | -116.2415516 | 2022-07-14 04:20:57 | Ada, Idaho, US | |
2981327 | 2981327 | 2022-06-13 | US | Nebraska | Douglas | 31055 | 153457 | 1034 | 0 | 41.29518299 | -96.15085305 | 2022-06-14 04:20:52 | Douglas, Nebraska, US | |
2237453 | 2237453 | 2022-06-12 | US | Nebraska | Douglas | 31055 | 153457 | 1034 | 0 | 41.29518299 | -96.15085305 | 2022-06-13 04:21:14 | Douglas, Nebraska, US | |
3143651 | 3143651 | 2022-06-11 | US | Nebraska | Douglas | 31055 | 153457 | 1034 | 0 | 41.29518299 | -96.15085305 | 2022-06-12 04:20:53 | Douglas, Nebraska, US | |
1946567 | 1946567 | 2022-06-10 | US | Nebraska | Douglas | 31055 | 153457 | 1034 | 0 | 41.29518299 | -96.15085305 | 2022-06-11 04:21:01 | Douglas, Nebraska, US | |
3159706 | 3159706 | 2022-06-09 | US | Nebraska | Douglas | 31055 | 152957 | 1034 | 0 | 41.29518299 | -96.15085305 | 2022-06-10 04:20:55 | Douglas, Nebraska, US | |
1423173 | 1423173 | 2022-06-08 | US | Nebraska | Douglas | 31055 | 152957 | 1034 | 0 | 41.29518299 | -96.15085305 | 2022-06-09 04:20:54 | Douglas, Nebraska, US | |
3728287 | 3728287 | 2022-06-07 | US | Nebraska | Douglas | 31055 | 152957 | 1034 | 0 | 41.29518299 | -96.15085305 | 2022-06-08 04:20:55 | Douglas, Nebraska, US | |
3889689 | 3889689 | 2022-06-06 | US | Nebraska | Douglas | 31055 | 152957 | 1034 | 0 | 41.29518299 | -96.15085305 | 2022-06-07 04:21:08 | Douglas, Nebraska, US | |
3537529 | 3537529 | 2022-05-10 | US | Nebraska | Douglas | 31055 | 151622 | 1034 | 0 | 41.29518299 | -96.15085305 | 2022-05-11 04:20:48 | Douglas, Nebraska, US | |
224064 | 224064 | 2022-05-09 | US | Nebraska | Douglas | 31055 | 151622 | 1034 | 0 | 41.29518299 | -96.15085305 | 2022-05-10 04:20:50 | Douglas, Nebraska, US | |
2333449 | 2333449 | 2022-05-08 | US | Nebraska | Douglas | 31055 | 151622 | 1034 | 0 | 41.29518299 | -96.15085305 | 2022-05-09 04:20:54 | Douglas, Nebraska, US | |
362411 | 362411 | 2022-05-07 | US | Nebraska | Douglas | 31055 | 151622 | 1034 | 0 | 41.29518299 | -96.15085305 | 2022-05-08 04:20:49 | Douglas, Nebraska, US | |
1399762 | 1399762 | 2022-05-06 | US | Nebraska | Douglas | 31055 | 151622 | 1034 | 0 | 41.29518299 | -96.15085305 | 2022-05-07 04:21:09 | Douglas, Nebraska, US | |
2600117 | 2600117 | 2022-05-05 | US | Nebraska | Douglas | 31055 | 151622 | 1034 | 0 | 41.29518299 | -96.15085305 | 2022-05-06 04:21:00 | Douglas, Nebraska, US | |
3267566 | 3267566 | 2022-05-04 | US | Nebraska | Douglas | 31055 | 151622 | 1034 | 0 | 41.29518299 | -96.15085305 | 2022-05-05 04:20:55 | Douglas, Nebraska, US | |
1574205 | 1574205 | 2022-05-03 | US | Nebraska | Douglas | 31055 | 151622 | 1034 | 0 | 41.29518299 | -96.15085305 | 2022-05-04 04:20:59 | Douglas, Nebraska, US | |
466648 | 466648 | 2022-05-02 | US | Texas | Webb | 48479 | 95230 | 1034 | 0 | 27.7610369 | -99.33237355 | 2022-05-03 04:21:00 | Webb, Texas, US | |
3919287 | 3919287 | 2022-05-01 | US | Texas | Webb | 48479 | 94121 | 1034 | 0 | 27.7610369 | -99.33237355 | 2022-05-02 04:21:10 | Webb, Texas, US | |
2844091 | 2844091 | 2022-04-30 | US | Texas | Webb | 48479 | 93916 | 1034 | 0 | 27.7610369 | -99.33237355 | 2022-05-01 04:20:57 | Webb, Texas, US | |
1160404 | 1160404 | 2022-04-29 | US | Texas | Webb | 48479 | 93869 | 1034 | 0 | 27.7610369 | -99.33237355 | 2022-04-30 04:21:05 | Webb, Texas, US | |
1699586 | 1699586 | 2022-04-28 | US | Texas | Webb | 48479 | 93823 | 1034 | 0 | 27.7610369 | -99.33237355 | 2022-04-29 04:20:59 | Webb, Texas, US | |
3855069 | 3855069 | 2022-04-27 | US | Texas | Webb | 48479 | 93776 | 1034 | 0 | 27.7610369 | -99.33237355 | 2022-04-28 04:20:47 | Webb, Texas, US | |
1329499 | 1329499 | 2022-04-26 | US | Texas | Webb | 48479 | 93714 | 1034 | 0 | 27.7610369 | -99.33237355 | 2022-04-27 04:20:52 | Webb, Texas, US | |
1466777 | 1466777 | 2022-02-10 | US | Pennsylvania | Northampton | 42095 | 77993 | 1034 | 0 | 40.75182733 | -75.30471829 | 2022-02-11 04:21:09 | Northampton, Pennsylvania, US | |
459901 | 459901 | 2022-02-02 | US | Arkansas | Pulaski | 5119 | 98123 | 1034 | 0 | 34.77054088 | -92.31355101 | 2022-02-03 04:21:21 | Pulaski, Arkansas, US | |
979954 | 979954 | 2022-02-01 | US | Illinois | Kane | 17089 | 119562 | 1034 | 0 | 41.93842729 | -88.42861412 | 2022-02-02 04:21:09 | Kane, Illinois, US | |
2052949 | 2052949 | 2022-01-25 | US | Indiana | Allen | 18003 | 97158 | 1034 | 0 | 41.09194313 | -85.06800636 | 2022-01-26 04:21:07 | Allen, Indiana, US | |
2833291 | 2833291 | 2022-01-22 | US | Arizona | Yavapai | 4025 | 41871 | 1034 | 0 | 34.59933926 | -112.5538588 | 2022-01-23 04:21:13 | Yavapai, Arizona, US | |
1117046 | 1117046 | 2022-01-11 | US | Washington | Pierce | 53053 | 133202 | 1034 | 0 | 47.03892768 | -122.14059579999999 | 2022-01-12 04:21:44 | Pierce, Washington, US | |
1695774 | 1695774 | 2022-01-10 | US | Washington | Pierce | 53053 | 131631 | 1034 | 0 | 47.03892768 | -122.14059579999999 | 2022-01-11 04:22:01 | Pierce, Washington, US | |
1669058 | 1669058 | 2021-12-29 | US | Colorado | Arapahoe | 8005 | 108609 | 1034 | 0 | 39.64977461 | -104.3353617 | 2021-12-30 04:21:25 | Arapahoe, Colorado, US | |
2504 | 2504 | 2021-12-02 | US | New Jersey | Mercer | 34021 | 41999 | 1034 | 0 | 40.28047017 | -74.70479631 | 2021-12-03 04:23:05 | Mercer, New Jersey, US | |
3404043 | 3404043 | 2021-11-30 | US | Oklahoma | Unassigned | 90040 | 5720 | 1034 | 0 | 36.83532655 | 0.0 | 2021-12-01 04:22:29 | Unassigned, Oklahoma, US | |
3071786 | 3071786 | 2021-11-23 | US | Minnesota | Ramsey | 27123 | 71727 | 1034 | 0 | 45.01625271 | -93.09872295 | 2021-11-24 04:22:14 | Ramsey, Minnesota, US | |
688844 | 688844 | 2021-11-13 | US | Ohio | Lucas | 39095 | 59140 | 1034 | 0 | 41.62101218 | -83.65468618 | 2021-11-14 04:21:31 | Lucas, Ohio, US | |
689429 | 689429 | 2021-11-13 | US | Texas | Denton | 48121 | 105814 | 1034 | 0 | 33.20521901 | -97.11691153 | 2021-11-14 04:21:31 | Denton, Texas, US | |
1275921 | 1275921 | 2021-10-03 | US | Michigan | Genesee | 26049 | 47709 | 1034 | 0 | 43.02244215 | -83.70589709 | 2021-10-04 04:21:31 | Genesee, Michigan, US | |
3929674 | 3929674 | 2021-10-02 | US | Michigan | Genesee | 26049 | 47709 | 1034 | 0 | 43.02244215 | -83.70589709 | 2021-10-03 04:21:24 | Genesee, Michigan, US | |
2133654 | 2133654 | 2021-10-01 | US | Michigan | Genesee | 26049 | 47709 | 1034 | 0 | 43.02244215 | -83.70589709 | 2021-10-02 04:21:25 | Genesee, Michigan, US | |
604203 | 604203 | 2021-09-23 | US | Ohio | Stark | 39151 | 41836 | 1034 | 0 | 40.81482476 | -81.36437305 | 2021-09-24 04:21:44 | Stark, Ohio, US | |
67451 | 67451 | 2021-09-01 | US | Alabama | Mobile | 1097 | 64054 | 1034 | 0 | 30.78472347 | -88.20842409 | 2021-09-02 04:21:15 | Mobile, Alabama, US | |
68559 | 68559 | 2021-09-01 | US | Louisiana | East Baton Rouge | 22033 | 59282 | 1034 | 0 | 30.53842039 | -91.09777565 | 2021-09-02 04:21:15 | East Baton Rouge, Louisiana, US | |
68568 | 68568 | 2021-09-01 | US | Louisiana | Jefferson | 22051 | 66158 | 1034 | 0 | 29.74075478 | -90.11115756 | 2021-09-02 04:21:15 | Jefferson, Louisiana, US | |
3894270 | 3894270 | 2021-08-29 | US | North Carolina | Mecklenburg | 37119 | 133843 | 1034 | 0 | 35.24469268 | -80.8317671 | 2021-08-30 04:21:23 | Mecklenburg, North Carolina, US | |
2795373 | 2795373 | 2021-08-28 | US | North Carolina | Mecklenburg | 37119 | 133843 | 1034 | 0 | 35.24469268 | -80.8317671 | 2021-08-29 04:21:14 | Mecklenburg, North Carolina, US | |
2925532 | 2925532 | 2021-08-27 | US | North Carolina | Mecklenburg | 37119 | 133843 | 1034 | 0 | 35.24469268 | -80.8317671 | 2021-08-28 04:21:28 | Mecklenburg, North Carolina, US | |
1606744 | 1606744 | 2021-08-16 | US | Ohio | Summit | 39153 | 50232 | 1034 | 0 | 41.12464734 | -81.53123079 | 2021-08-17 04:21:49 | Summit, Ohio, US | |
105838 | 105838 | 2021-08-15 | US | Ohio | Summit | 39153 | 50171 | 1034 | 0 | 41.12464734 | -81.53123079 | 2021-08-16 04:21:31 | Summit, Ohio, US | |
510196 | 510196 | 2021-08-14 | US | Ohio | Summit | 39153 | 50110 | 1034 | 0 | 41.12464734 | -81.53123079 | 2021-08-15 04:21:41 | Summit, Ohio, US | |
1486068 | 1486068 | 2021-08-13 | US | Ohio | Summit | 39153 | 50018 | 1034 | 0 | 41.12464734 | -81.53123079 | 2021-08-14 04:21:25 | Summit, Ohio, US | |
590734 | 590734 | 2021-08-08 | US | Indiana | Lake | 18089 | 57448 | 1034 | 0 | 41.41874274 | -87.38277575 | 2021-08-09 04:21:24 | Lake, Indiana, US | |
2204746 | 2204746 | 2021-08-07 | US | Indiana | Lake | 18089 | 57448 | 1034 | 0 | 41.41874274 | -87.38277575 | 2021-08-08 04:21:33 | Lake, Indiana, US | |
1118696 | 1118696 | 2021-08-06 | US | Indiana | Lake | 18089 | 57448 | 1034 | 0 | 41.41874274 | -87.38277575 | 2021-08-07 04:21:30 | Lake, Indiana, US | |
2767751 | 2767751 | 2021-07-01 | US | South Carolina | Greenville | 45045 | 75688 | 1034 | 0 | 34.89502264 | -82.37295012 | 2021-07-02 04:21:47 | Greenville, South Carolina, US | |
1895959 | 1895959 | 2021-06-30 | US | South Carolina | Greenville | 45045 | 75672 | 1034 | 0 | 34.89502264 | -82.37295012 | 2021-07-01 04:21:19 | Greenville, South Carolina, US | |
403082 | 403082 | 2021-06-29 | US | South Carolina | Greenville | 45045 | 75661 | 1034 | 0 | 34.89502264 | -82.37295012 | 2021-06-30 04:21:41 | Greenville, South Carolina, US | |
564023 | 564023 | 2021-06-22 | US | Illinois | Will | 17197 | 76961 | 1034 | 0 | 41.44619267 | -87.97862712 | 2021-06-23 04:21:46 | Will, Illinois, US | |
566199 | 566199 | 2021-06-22 | US | Texas | Travis | 48453 | 90734 | 1034 | 0 | 30.33432034 | -97.7853562 | 2021-06-23 04:21:46 | Travis, Texas, 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]);