johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,242 rows where deaths = 301 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755596 | 2755596 | 2022-12-29 | US | Pennsylvania | Mifflin | 42087 | 14711 | 301 | 0 | 40.61116939 | -77.61070738 | 2022-12-30 04:21:04 | Mifflin, Pennsylvania, US | |
2753833 | 2753833 | 2022-12-29 | US | Idaho | Bonneville | 16019 | 34989 | 301 | 0 | 43.38713372 | -111.6161537 | 2022-12-30 04:21:04 | Bonneville, Idaho, US | |
1076602 | 1076602 | 2022-12-28 | US | Pennsylvania | Mifflin | 42087 | 14711 | 301 | 0 | 40.61116939 | -77.61070738 | 2022-12-29 04:21:01 | Mifflin, Pennsylvania, US | |
1076506 | 1076506 | 2022-12-28 | US | Oklahoma | Pottawatomie | 40125 | 25652 | 301 | 0 | 35.20614018 | -96.94923008 | 2022-12-29 04:21:01 | Pottawatomie, Oklahoma, US | |
1074839 | 1074839 | 2022-12-28 | US | Idaho | Bonneville | 16019 | 34989 | 301 | 0 | 43.38713372 | -111.6161537 | 2022-12-29 04:21:01 | Bonneville, Idaho, US | |
331172 | 331172 | 2022-12-27 | US | Texas | Wood | 48499 | 9450 | 301 | 0 | 32.78722382 | -95.38236368 | 2022-12-28 04:21:04 | Wood, Texas, US | |
330599 | 330599 | 2022-12-27 | US | Pennsylvania | Mifflin | 42087 | 14658 | 301 | 0 | 40.61116939 | -77.61070738 | 2022-12-28 04:21:04 | Mifflin, Pennsylvania, US | |
330503 | 330503 | 2022-12-27 | US | Oklahoma | Pottawatomie | 40125 | 25652 | 301 | 0 | 35.20614018 | -96.94923008 | 2022-12-28 04:21:04 | Pottawatomie, Oklahoma, US | |
330058 | 330058 | 2022-12-27 | US | Nevada | Nye | 32023 | 9056 | 301 | 0 | 38.04264256 | -116.4722702 | 2022-12-28 04:21:04 | Nye, Nevada, US | |
328836 | 328836 | 2022-12-27 | US | Idaho | Bonneville | 16019 | 34922 | 301 | 0 | 43.38713372 | -111.6161537 | 2022-12-28 04:21:04 | Bonneville, Idaho, US | |
221245 | 221245 | 2022-12-26 | US | Texas | Wood | 48499 | 9450 | 301 | 0 | 32.78722382 | -95.38236368 | 2022-12-27 04:21:07 | Wood, Texas, US | |
220672 | 220672 | 2022-12-26 | US | Pennsylvania | Mifflin | 42087 | 14658 | 301 | 0 | 40.61116939 | -77.61070738 | 2022-12-27 04:21:07 | Mifflin, Pennsylvania, US | |
220576 | 220576 | 2022-12-26 | US | Oklahoma | Pottawatomie | 40125 | 25652 | 301 | 0 | 35.20614018 | -96.94923008 | 2022-12-27 04:21:07 | Pottawatomie, Oklahoma, US | |
220131 | 220131 | 2022-12-26 | US | Nevada | Nye | 32023 | 9056 | 301 | 0 | 38.04264256 | -116.4722702 | 2022-12-27 04:21:07 | Nye, Nevada, US | |
218909 | 218909 | 2022-12-26 | US | Idaho | Bonneville | 16019 | 34922 | 301 | 0 | 43.38713372 | -111.6161537 | 2022-12-27 04:21:07 | Bonneville, Idaho, US | |
3225702 | 3225702 | 2022-12-25 | US | Texas | Wood | 48499 | 9450 | 301 | 0 | 32.78722382 | -95.38236368 | 2022-12-26 04:21:06 | Wood, Texas, US | |
3225129 | 3225129 | 2022-12-25 | US | Pennsylvania | Mifflin | 42087 | 14658 | 301 | 0 | 40.61116939 | -77.61070738 | 2022-12-26 04:21:06 | Mifflin, Pennsylvania, US | |
3225033 | 3225033 | 2022-12-25 | US | Oklahoma | Pottawatomie | 40125 | 25652 | 301 | 0 | 35.20614018 | -96.94923008 | 2022-12-26 04:21:06 | Pottawatomie, Oklahoma, US | |
3224588 | 3224588 | 2022-12-25 | US | Nevada | Nye | 32023 | 9056 | 301 | 0 | 38.04264256 | -116.4722702 | 2022-12-26 04:21:06 | Nye, Nevada, US | |
3223366 | 3223366 | 2022-12-25 | US | Idaho | Bonneville | 16019 | 34922 | 301 | 0 | 43.38713372 | -111.6161537 | 2022-12-26 04:21:06 | Bonneville, Idaho, US | |
1021616 | 1021616 | 2022-12-24 | US | Texas | Wood | 48499 | 9450 | 301 | 0 | 32.78722382 | -95.38236368 | 2022-12-25 04:21:04 | Wood, Texas, US | |
1021043 | 1021043 | 2022-12-24 | US | Pennsylvania | Mifflin | 42087 | 14658 | 301 | 0 | 40.61116939 | -77.61070738 | 2022-12-25 04:21:04 | Mifflin, Pennsylvania, US | |
1020947 | 1020947 | 2022-12-24 | US | Oklahoma | Pottawatomie | 40125 | 25652 | 301 | 0 | 35.20614018 | -96.94923008 | 2022-12-25 04:21:04 | Pottawatomie, Oklahoma, US | |
1020502 | 1020502 | 2022-12-24 | US | Nevada | Nye | 32023 | 9056 | 301 | 0 | 38.04264256 | -116.4722702 | 2022-12-25 04:21:04 | Nye, Nevada, US | |
1019280 | 1019280 | 2022-12-24 | US | Idaho | Bonneville | 16019 | 34922 | 301 | 0 | 43.38713372 | -111.6161537 | 2022-12-25 04:21:04 | Bonneville, Idaho, US | |
693639 | 693639 | 2022-12-23 | US | Texas | Wood | 48499 | 9450 | 301 | 0 | 32.78722382 | -95.38236368 | 2022-12-24 04:21:02 | Wood, Texas, US | |
693066 | 693066 | 2022-12-23 | US | Pennsylvania | Mifflin | 42087 | 14658 | 301 | 0 | 40.61116939 | -77.61070738 | 2022-12-24 04:21:02 | Mifflin, Pennsylvania, US | |
692970 | 692970 | 2022-12-23 | US | Oklahoma | Pottawatomie | 40125 | 25652 | 301 | 0 | 35.20614018 | -96.94923008 | 2022-12-24 04:21:02 | Pottawatomie, Oklahoma, US | |
692525 | 692525 | 2022-12-23 | US | Nevada | Nye | 32023 | 9056 | 301 | 0 | 38.04264256 | -116.4722702 | 2022-12-24 04:21:02 | Nye, Nevada, US | |
691303 | 691303 | 2022-12-23 | US | Idaho | Bonneville | 16019 | 34922 | 301 | 0 | 43.38713372 | -111.6161537 | 2022-12-24 04:21:02 | Bonneville, Idaho, US | |
2182849 | 2182849 | 2022-12-22 | US | Texas | Wood | 48499 | 9450 | 301 | 0 | 32.78722382 | -95.38236368 | 2022-12-23 04:21:04 | Wood, Texas, US | |
2182276 | 2182276 | 2022-12-22 | US | Pennsylvania | Mifflin | 42087 | 14658 | 301 | 0 | 40.61116939 | -77.61070738 | 2022-12-23 04:21:04 | Mifflin, Pennsylvania, US | |
2182180 | 2182180 | 2022-12-22 | US | Oklahoma | Pottawatomie | 40125 | 25652 | 301 | 0 | 35.20614018 | -96.94923008 | 2022-12-23 04:21:04 | Pottawatomie, Oklahoma, US | |
2181735 | 2181735 | 2022-12-22 | US | Nevada | Nye | 32023 | 9056 | 301 | 0 | 38.04264256 | -116.4722702 | 2022-12-23 04:21:04 | Nye, Nevada, US | |
2180513 | 2180513 | 2022-12-22 | US | Idaho | Bonneville | 16019 | 34922 | 301 | 0 | 43.38713372 | -111.6161537 | 2022-12-23 04:21:04 | Bonneville, Idaho, US | |
454653 | 454653 | 2022-12-21 | US | Texas | Wood | 48499 | 9450 | 301 | 0 | 32.78722382 | -95.38236368 | 2022-12-22 04:20:56 | Wood, Texas, US | |
454080 | 454080 | 2022-12-21 | US | Pennsylvania | Mifflin | 42087 | 14658 | 301 | 0 | 40.61116939 | -77.61070738 | 2022-12-22 04:20:56 | Mifflin, Pennsylvania, US | |
453984 | 453984 | 2022-12-21 | US | Oklahoma | Pottawatomie | 40125 | 25486 | 301 | 0 | 35.20614018 | -96.94923008 | 2022-12-22 04:20:56 | Pottawatomie, Oklahoma, US | |
453539 | 453539 | 2022-12-21 | US | Nevada | Nye | 32023 | 9056 | 301 | 0 | 38.04264256 | -116.4722702 | 2022-12-22 04:20:56 | Nye, Nevada, US | |
452317 | 452317 | 2022-12-21 | US | Idaho | Bonneville | 16019 | 34922 | 301 | 0 | 43.38713372 | -111.6161537 | 2022-12-22 04:20:56 | Bonneville, Idaho, US | |
2953983 | 2953983 | 2022-12-20 | US | Oklahoma | Pottawatomie | 40125 | 25486 | 301 | 0 | 35.20614018 | -96.94923008 | 2022-12-21 04:21:03 | Pottawatomie, Oklahoma, US | |
3176385 | 3176385 | 2022-12-19 | US | Oklahoma | Pottawatomie | 40125 | 25486 | 301 | 0 | 35.20614018 | -96.94923008 | 2022-12-20 04:21:04 | Pottawatomie, Oklahoma, US | |
1630902 | 1630902 | 2022-12-18 | US | Oklahoma | Pottawatomie | 40125 | 25486 | 301 | 0 | 35.20614018 | -96.94923008 | 2022-12-19 04:21:03 | Pottawatomie, Oklahoma, US | |
506281 | 506281 | 2022-12-17 | US | Oklahoma | Pottawatomie | 40125 | 25486 | 301 | 0 | 35.20614018 | -96.94923008 | 2022-12-18 04:21:03 | Pottawatomie, Oklahoma, US | |
3326853 | 3326853 | 2022-12-16 | US | Oklahoma | Pottawatomie | 40125 | 25486 | 301 | 0 | 35.20614018 | -96.94923008 | 2022-12-17 04:21:04 | Pottawatomie, Oklahoma, US | |
545365 | 545365 | 2022-12-15 | US | Oklahoma | Pottawatomie | 40125 | 25486 | 301 | 0 | 35.20614018 | -96.94923008 | 2022-12-16 04:21:01 | Pottawatomie, Oklahoma, US | |
351670 | 351670 | 2022-12-14 | US | Virginia | Lynchburg | 51680 | 23028 | 301 | 0 | 37.40021399 | -79.19888138 | 2022-12-15 04:20:58 | Lynchburg, Virginia, US | |
351259 | 351259 | 2022-12-14 | US | Tennessee | Jefferson | 47089 | 18938 | 301 | 0 | 36.04818632 | -83.45148924 | 2022-12-15 04:20:58 | Jefferson, Tennessee, US | |
311258 | 311258 | 2022-12-13 | US | Virginia | Lynchburg | 51680 | 23004 | 301 | 0 | 37.40021399 | -79.19888138 | 2022-12-14 04:21:04 | Lynchburg, Virginia, US | |
308814 | 308814 | 2022-12-13 | US | Idaho | Bonneville | 16019 | 34765 | 301 | 0 | 43.38713372 | -111.6161537 | 2022-12-14 04:21:04 | Bonneville, Idaho, US | |
1152319 | 1152319 | 2022-12-12 | US | Virginia | Lynchburg | 51680 | 22994 | 301 | 0 | 37.40021399 | -79.19888138 | 2022-12-13 04:21:01 | Lynchburg, Virginia, US | |
1151212 | 1151212 | 2022-12-12 | US | New York | Rensselaer | 36083 | 40472 | 301 | 0 | 42.71348136 | -73.51089874 | 2022-12-13 04:21:01 | Rensselaer, New York, US | |
1149875 | 1149875 | 2022-12-12 | US | Idaho | Bonneville | 16019 | 34765 | 301 | 0 | 43.38713372 | -111.6161537 | 2022-12-13 04:21:01 | Bonneville, Idaho, US | |
872173 | 872173 | 2022-12-11 | US | Virginia | Lynchburg | 51680 | 22963 | 301 | 0 | 37.40021399 | -79.19888138 | 2022-12-12 04:21:01 | Lynchburg, Virginia, US | |
871066 | 871066 | 2022-12-11 | US | New York | Rensselaer | 36083 | 40459 | 301 | 0 | 42.71348136 | -73.51089874 | 2022-12-12 04:21:01 | Rensselaer, New York, US | |
869729 | 869729 | 2022-12-11 | US | Idaho | Bonneville | 16019 | 34765 | 301 | 0 | 43.38713372 | -111.6161537 | 2022-12-12 04:21:01 | Bonneville, Idaho, US | |
260703 | 260703 | 2022-12-10 | US | Virginia | Lynchburg | 51680 | 22963 | 301 | 0 | 37.40021399 | -79.19888138 | 2022-12-11 04:20:50 | Lynchburg, Virginia, US | |
259596 | 259596 | 2022-12-10 | US | New York | Rensselaer | 36083 | 40451 | 301 | 0 | 42.71348136 | -73.51089874 | 2022-12-11 04:20:50 | Rensselaer, New York, US | |
258259 | 258259 | 2022-12-10 | US | Idaho | Bonneville | 16019 | 34765 | 301 | 0 | 43.38713372 | -111.6161537 | 2022-12-11 04:20:50 | Bonneville, Idaho, US | |
3939417 | 3939417 | 2022-12-09 | US | Virginia | Lynchburg | 51680 | 22963 | 301 | 0 | 37.40021399 | -79.19888138 | 2022-12-10 04:21:02 | Lynchburg, Virginia, US | |
3938310 | 3938310 | 2022-12-09 | US | New York | Rensselaer | 36083 | 40434 | 301 | 0 | 42.71348136 | -73.51089874 | 2022-12-10 04:21:02 | Rensselaer, New York, US | |
3936973 | 3936973 | 2022-12-09 | US | Idaho | Bonneville | 16019 | 34765 | 301 | 0 | 43.38713372 | -111.6161537 | 2022-12-10 04:21:02 | Bonneville, Idaho, US | |
3380749 | 3380749 | 2022-12-08 | US | Virginia | Lynchburg | 51680 | 22927 | 301 | 0 | 37.40021399 | -79.19888138 | 2022-12-09 04:21:05 | Lynchburg, Virginia, US | |
3379642 | 3379642 | 2022-12-08 | US | New York | Rensselaer | 36083 | 40417 | 301 | 0 | 42.71348136 | -73.51089874 | 2022-12-09 04:21:05 | Rensselaer, New York, US | |
3378305 | 3378305 | 2022-12-08 | US | Idaho | Bonneville | 16019 | 34765 | 301 | 0 | 43.38713372 | -111.6161537 | 2022-12-09 04:21:05 | Bonneville, Idaho, US | |
1988020 | 1988020 | 2022-12-07 | US | Virginia | Lynchburg | 51680 | 22908 | 301 | 0 | 37.40021399 | -79.19888138 | 2022-12-08 04:21:07 | Lynchburg, Virginia, US | |
1986913 | 1986913 | 2022-12-07 | US | New York | Rensselaer | 36083 | 40398 | 301 | 0 | 42.71348136 | -73.51089874 | 2022-12-08 04:21:07 | Rensselaer, New York, US | |
1985576 | 1985576 | 2022-12-07 | US | Idaho | Bonneville | 16019 | 34765 | 301 | 0 | 43.38713372 | -111.6161537 | 2022-12-08 04:21:07 | Bonneville, Idaho, US | |
3717543 | 3717543 | 2022-12-06 | US | Virginia | Lynchburg | 51680 | 22899 | 301 | 0 | 37.40021399 | -79.19888138 | 2022-12-07 04:20:58 | Lynchburg, Virginia, US | |
3716436 | 3716436 | 2022-12-06 | US | New York | Rensselaer | 36083 | 40383 | 301 | 0 | 42.71348136 | -73.51089874 | 2022-12-07 04:20:58 | Rensselaer, New York, US | |
3715099 | 3715099 | 2022-12-06 | US | Idaho | Bonneville | 16019 | 34658 | 301 | 0 | 43.38713372 | -111.6161537 | 2022-12-07 04:20:58 | Bonneville, Idaho, US | |
2418424 | 2418424 | 2022-12-05 | US | Wisconsin | Fond du Lac | 55039 | 37853 | 301 | 0 | 43.75354908 | -88.48885325 | 2022-12-06 04:21:03 | Fond du Lac, Wisconsin, US | |
2417141 | 2417141 | 2022-12-05 | US | New York | Rensselaer | 36083 | 40367 | 301 | 0 | 42.71348136 | -73.51089874 | 2022-12-06 04:21:03 | Rensselaer, New York, US | |
2416569 | 2416569 | 2022-12-05 | US | Michigan | Tuscola | 26157 | 15288 | 301 | 0 | 43.46606813 | -83.41897025 | 2022-12-06 04:21:03 | Tuscola, Michigan, US | |
2415804 | 2415804 | 2022-12-05 | US | Idaho | Bonneville | 16019 | 34658 | 301 | 0 | 43.38713372 | -111.6161537 | 2022-12-06 04:21:03 | Bonneville, Idaho, US | |
722032 | 722032 | 2022-12-04 | US | Wisconsin | Fond du Lac | 55039 | 37807 | 301 | 0 | 43.75354908 | -88.48885325 | 2022-12-05 04:20:58 | Fond du Lac, Wisconsin, US | |
720749 | 720749 | 2022-12-04 | US | New York | Rensselaer | 36083 | 40346 | 301 | 0 | 42.71348136 | -73.51089874 | 2022-12-05 04:20:58 | Rensselaer, New York, US | |
720177 | 720177 | 2022-12-04 | US | Michigan | Tuscola | 26157 | 15288 | 301 | 0 | 43.46606813 | -83.41897025 | 2022-12-05 04:20:58 | Tuscola, Michigan, US | |
719412 | 719412 | 2022-12-04 | US | Idaho | Bonneville | 16019 | 34658 | 301 | 0 | 43.38713372 | -111.6161537 | 2022-12-05 04:20:58 | Bonneville, Idaho, US | |
2820321 | 2820321 | 2022-12-03 | US | Wisconsin | Fond du Lac | 55039 | 37807 | 301 | 0 | 43.75354908 | -88.48885325 | 2022-12-04 04:20:56 | Fond du Lac, Wisconsin, US | |
2819038 | 2819038 | 2022-12-03 | US | New York | Rensselaer | 36083 | 40339 | 301 | 0 | 42.71348136 | -73.51089874 | 2022-12-04 04:20:56 | Rensselaer, New York, US | |
2818466 | 2818466 | 2022-12-03 | US | Michigan | Tuscola | 26157 | 15288 | 301 | 0 | 43.46606813 | -83.41897025 | 2022-12-04 04:20:56 | Tuscola, Michigan, US | |
2817701 | 2817701 | 2022-12-03 | US | Idaho | Bonneville | 16019 | 34658 | 301 | 0 | 43.38713372 | -111.6161537 | 2022-12-04 04:20:56 | Bonneville, Idaho, US | |
2816801 | 2816801 | 2022-12-03 | Japan | Wakayama | 160824 | 301 | 0 | 33.911879 | 135.505446 | 2022-12-04 04:20:56 | Wakayama, Japan | |||
837177 | 837177 | 2022-12-02 | US | Wisconsin | Fond du Lac | 55039 | 37807 | 301 | 0 | 43.75354908 | -88.48885325 | 2022-12-03 04:21:02 | Fond du Lac, Wisconsin, US | |
835894 | 835894 | 2022-12-02 | US | New York | Rensselaer | 36083 | 40310 | 301 | 0 | 42.71348136 | -73.51089874 | 2022-12-03 04:21:02 | Rensselaer, New York, US | |
835322 | 835322 | 2022-12-02 | US | Michigan | Tuscola | 26157 | 15288 | 301 | 0 | 43.46606813 | -83.41897025 | 2022-12-03 04:21:02 | Tuscola, Michigan, US | |
834557 | 834557 | 2022-12-02 | US | Idaho | Bonneville | 16019 | 34658 | 301 | 0 | 43.38713372 | -111.6161537 | 2022-12-03 04:21:02 | Bonneville, Idaho, US | |
2139707 | 2139707 | 2022-12-01 | US | Wisconsin | Fond du Lac | 55039 | 37785 | 301 | 0 | 43.75354908 | -88.48885325 | 2022-12-02 04:21:07 | Fond du Lac, Wisconsin, US | |
2138424 | 2138424 | 2022-12-01 | US | New York | Rensselaer | 36083 | 40279 | 301 | 0 | 42.71348136 | -73.51089874 | 2022-12-02 04:21:07 | Rensselaer, New York, US | |
2137852 | 2137852 | 2022-12-01 | US | Michigan | Tuscola | 26157 | 15288 | 301 | 0 | 43.46606813 | -83.41897025 | 2022-12-02 04:21:07 | Tuscola, Michigan, US | |
2137087 | 2137087 | 2022-12-01 | US | Idaho | Bonneville | 16019 | 34658 | 301 | 0 | 43.38713372 | -111.6161537 | 2022-12-02 04:21:07 | Bonneville, Idaho, US | |
1968123 | 1968123 | 2022-11-30 | US | Wisconsin | Fond du Lac | 55039 | 37760 | 301 | 0 | 43.75354908 | -88.48885325 | 2022-12-01 04:21:03 | Fond du Lac, Wisconsin, US | |
1966840 | 1966840 | 2022-11-30 | US | New York | Rensselaer | 36083 | 40239 | 301 | 0 | 42.71348136 | -73.51089874 | 2022-12-01 04:21:03 | Rensselaer, New York, US | |
1966268 | 1966268 | 2022-11-30 | US | Michigan | Tuscola | 26157 | 15288 | 301 | 0 | 43.46606813 | -83.41897025 | 2022-12-01 04:21:03 | Tuscola, Michigan, US | |
1965503 | 1965503 | 2022-11-30 | US | Idaho | Bonneville | 16019 | 34658 | 301 | 0 | 43.38713372 | -111.6161537 | 2022-12-01 04:21:03 | Bonneville, Idaho, US | |
2560137 | 2560137 | 2022-11-29 | US | Wisconsin | Fond du Lac | 55039 | 37718 | 301 | 0 | 43.75354908 | -88.48885325 | 2022-11-30 04:21:07 | Fond du Lac, Wisconsin, US | |
2558854 | 2558854 | 2022-11-29 | US | New York | Rensselaer | 36083 | 40220 | 301 | 0 | 42.71348136 | -73.51089874 | 2022-11-30 04:21:07 | Rensselaer, New York, US | |
2558282 | 2558282 | 2022-11-29 | US | Michigan | Tuscola | 26157 | 15288 | 301 | 0 | 43.46606813 | -83.41897025 | 2022-11-30 04:21:07 | Tuscola, Michigan, US | |
1243211 | 1243211 | 2022-11-28 | US | Wisconsin | Fond du Lac | 55039 | 37679 | 301 | 0 | 43.75354908 | -88.48885325 | 2022-11-29 04:21:05 | Fond du Lac, Wisconsin, 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]);