johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
286 rows where active = 707 and country_or_region = "US" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Texas 27
- Georgia 22
- Kansas 17
- Indiana 14
- Iowa 14
- Virginia 14
- Louisiana 13
- Mississippi 11
- North Carolina 11
- Ohio 11
- Oklahoma 11
- Puerto Rico 10
- Alabama 8
- Colorado 7
- Nebraska 7
- Michigan 6
- Missouri 6
- Florida 5
- Minnesota 5
- Montana 5
- North Dakota 5
- Tennessee 5
- Arkansas 4
- Idaho 4
- Kentucky 4
- New York 4
- South Dakota 4
- Wisconsin 4
- California 3
- Illinois 3
- …
country_or_region 1
- US · 286 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1093545 | 1093545 | 2021-03-03 | US | West Virginia | Gilmer | 54021 | 715 | 8 | 0 | 707 | 38.9251277 | -80.85952723 | 2021-03-04 05:24:24 | Gilmer, West Virginia, US |
3257528 | 3257528 | 2021-03-02 | US | Virginia | Poquoson | 51735 | 722 | 15 | 0 | 707 | 37.14259351 | -76.35798148 | 2021-03-03 05:23:28 | Poquoson, Virginia, US |
1001654 | 1001654 | 2021-03-01 | US | Texas | Stephens | 48429 | 802 | 24 | 0 | 707 | 32.73553157 | -98.83631615 | 2021-03-02 05:23:30 | Stephens, Texas, US |
2370712 | 2370712 | 2021-02-28 | US | Texas | Stephens | 48429 | 802 | 24 | 0 | 707 | 32.73553157 | -98.83631615 | 2021-03-01 05:23:01 | Stephens, Texas, US |
3067557 | 3067557 | 2021-02-27 | US | Maine | Washington | 23029 | 721 | 14 | 0 | 707 | 45.01607142 | -67.62813524 | 2021-02-28 05:22:20 | Washington, Maine, US |
3069214 | 3069214 | 2021-02-27 | US | Texas | Stephens | 48429 | 802 | 24 | 0 | 707 | 32.73553157 | -98.83631615 | 2021-02-28 05:22:20 | Stephens, Texas, US |
2186484 | 2186484 | 2021-02-26 | US | South Dakota | Walworth | 46129 | 722 | 15 | 0 | 707 | 45.43019636 | -100.0307514 | 2021-02-27 05:22:28 | Walworth, South Dakota, US |
1858477 | 1858477 | 2021-02-25 | US | Arkansas | Dallas | 5039 | 719 | 12 | 0 | 707 | 33.97042763 | -92.65167437 | 2021-02-26 05:22:40 | Dallas, Arkansas, US |
1939778 | 1939778 | 2021-02-23 | US | Virginia | Floyd | 51063 | 725 | 18 | 0 | 707 | 36.9302126 | -80.36738849 | 2021-02-24 05:29:16 | Floyd, Virginia, US |
183335 | 183335 | 2021-02-21 | US | Kansas | Kingman | 20095 | 720 | 13 | 0 | 707 | 37.55909527 | -98.13638678 | 2021-02-22 05:24:21 | Kingman, Kansas, US |
183941 | 183941 | 2021-02-21 | US | Missouri | Howard | 29089 | 712 | 5 | 0 | 707 | 39.1435761 | -92.69756691 | 2021-02-22 05:24:21 | Howard, Missouri, US |
743609 | 743609 | 2021-02-20 | US | Kansas | Kingman | 20095 | 720 | 13 | 0 | 707 | 37.55909527 | -98.13638678 | 2021-02-21 05:24:33 | Kingman, Kansas, US |
472707 | 472707 | 2021-02-19 | US | Kansas | Kingman | 20095 | 720 | 13 | 0 | 707 | 37.55909527 | -98.13638678 | 2021-02-20 05:22:51 | Kingman, Kansas, US |
3604349 | 3604349 | 2021-02-17 | US | Virginia | Charlotte | 51037 | 718 | 11 | 0 | 707 | 37.01909701 | -78.66314092 | 2021-02-18 05:22:58 | Charlotte, Virginia, US |
1341155 | 1341155 | 2021-02-15 | US | South Dakota | McCook | 46087 | 731 | 24 | 0 | 707 | 43.6742571 | -97.36863144 | 2021-02-16 05:24:38 | McCook, South Dakota, US |
2284610 | 2284610 | 2021-02-14 | US | Iowa | Greene | 19073 | 717 | 10 | 0 | 707 | 42.03614551 | -94.39658081 | 2021-02-15 05:24:49 | Greene, Iowa, US |
2286306 | 2286306 | 2021-02-14 | US | South Dakota | McCook | 46087 | 731 | 24 | 0 | 707 | 43.6742571 | -97.36863144 | 2021-02-15 05:24:49 | McCook, South Dakota, US |
2679010 | 2679010 | 2021-02-13 | US | Iowa | Greene | 19073 | 717 | 10 | 0 | 707 | 42.03614551 | -94.39658081 | 2021-02-14 05:23:43 | Greene, Iowa, US |
2680850 | 2680850 | 2021-02-13 | US | Texas | Brooks | 48047 | 768 | 32 | 0 | 707 | 27.03103197 | -98.21808402 | 2021-02-14 05:23:43 | Brooks, Texas, US |
3540329 | 3540329 | 2021-02-12 | US | Georgia | Taylor | 13269 | 729 | 22 | 0 | 707 | 32.55792548 | -84.25077141 | 2021-02-13 05:22:12 | Taylor, Georgia, US |
2638906 | 2638906 | 2021-02-11 | US | Iowa | Greene | 19073 | 716 | 9 | 0 | 707 | 42.03614551 | -94.39658081 | 2021-02-12 05:23:29 | Greene, Iowa, US |
3980181 | 3980181 | 2021-02-10 | US | Michigan | Arenac | 26011 | 731 | 24 | 0 | 707 | 44.0636262 | -83.89277559 | 2021-02-11 05:23:55 | Arenac, Michigan, US |
3981181 | 3981181 | 2021-02-10 | US | Oregon | Crook | 41013 | 723 | 16 | 0 | 707 | 44.14230227 | -120.356297 | 2021-02-11 05:23:55 | Crook, Oregon, US |
3981945 | 3981945 | 2021-02-10 | US | Virginia | Nelson | 51125 | 713 | 6 | 0 | 707 | 37.78790447 | -78.88498513 | 2021-02-11 05:23:55 | Nelson, Virginia, US |
614861 | 614861 | 2021-02-08 | US | Iowa | Davis | 19051 | 730 | 23 | 0 | 707 | 40.74773536 | -92.41005468 | 2021-02-09 05:23:30 | Davis, Iowa, US |
614872 | 614872 | 2021-02-08 | US | Iowa | Greene | 19073 | 715 | 8 | 0 | 707 | 42.03614551 | -94.39658081 | 2021-02-09 05:23:30 | Greene, Iowa, US |
1673630 | 1673630 | 2021-02-07 | US | Iowa | Davis | 19051 | 730 | 23 | 0 | 707 | 40.74773536 | -92.41005468 | 2021-02-08 05:22:39 | Davis, Iowa, US |
976091 | 976091 | 2021-02-06 | US | Iowa | Davis | 19051 | 730 | 23 | 0 | 707 | 40.74773536 | -92.41005468 | 2021-02-07 05:23:00 | Davis, Iowa, US |
1589349 | 1589349 | 2021-02-05 | US | Iowa | Davis | 19051 | 730 | 23 | 0 | 707 | 40.74773536 | -92.41005468 | 2021-02-06 05:23:55 | Davis, Iowa, US |
1589936 | 1589936 | 2021-02-05 | US | Minnesota | Stevens | 27149 | 715 | 8 | 0 | 707 | 45.58613007 | -96.00163705 | 2021-02-06 05:23:55 | Stevens, Minnesota, US |
1591395 | 1591395 | 2021-02-05 | US | Texas | Swisher | 48437 | 868 | 15 | 0 | 707 | 34.53028891 | -101.7349174 | 2021-02-06 05:23:55 | Swisher, Texas, US |
790739 | 790739 | 2021-02-04 | US | Alabama | Coosa | 1037 | 728 | 21 | 0 | 707 | 32.93690146 | -86.24847739 | 2021-02-05 05:22:38 | Coosa, Alabama, US |
792175 | 792175 | 2021-02-04 | US | Mississippi | Franklin | 28037 | 726 | 19 | 0 | 707 | 31.47786634 | -90.89672989 | 2021-02-05 05:22:38 | Franklin, Mississippi, US |
342067 | 342067 | 2021-02-03 | US | Mississippi | Franklin | 28037 | 726 | 19 | 0 | 707 | 31.47786634 | -90.89672989 | 2021-02-04 05:22:26 | Franklin, Mississippi, US |
343490 | 343490 | 2021-02-03 | US | Texas | Stephens | 48429 | 799 | 21 | 0 | 707 | 32.73553157 | -98.83631615 | 2021-02-04 05:22:26 | Stephens, Texas, US |
1678879 | 1678879 | 2021-02-01 | US | North Dakota | Pembina | 38067 | 719 | 11 | 0 | 707 | 48.76623521 | -97.5523809 | 2021-02-02 05:22:49 | Pembina, North Dakota, US |
1462167 | 1462167 | 2021-01-31 | US | North Dakota | Pembina | 38067 | 718 | 11 | 0 | 707 | 48.76623521 | -97.5523809 | 2021-02-01 05:22:53 | Pembina, North Dakota, US |
2214075 | 2214075 | 2021-01-30 | US | North Dakota | Pembina | 38067 | 718 | 11 | 0 | 707 | 48.76623521 | -97.5523809 | 2021-01-31 05:22:42 | Pembina, North Dakota, US |
1899562 | 1899562 | 2021-01-29 | US | North Dakota | Pembina | 38067 | 718 | 11 | 0 | 707 | 48.76623521 | -97.5523809 | 2021-01-30 05:22:49 | Pembina, North Dakota, US |
1900326 | 1900326 | 2021-01-29 | US | Texas | Morris | 48343 | 872 | 19 | 0 | 707 | 33.11304005 | -94.73255695 | 2021-01-30 05:22:49 | Morris, Texas, US |
3156161 | 3156161 | 2021-01-27 | US | Oklahoma | Kiowa | 40075 | 720 | 13 | 0 | 707 | 34.91671958 | -98.97720696 | 2021-01-28 05:22:24 | Kiowa, Oklahoma, US |
13158 | 13158 | 2021-01-26 | US | Georgia | Jenkins | 13165 | 743 | 36 | 0 | 707 | 32.79248718 | -81.96040187 | 2021-01-27 05:23:41 | Jenkins, Georgia, US |
13601 | 13601 | 2021-01-26 | US | Kansas | Clay | 20027 | 730 | 23 | 0 | 707 | 39.34948772 | -97.16518128 | 2021-01-27 05:23:41 | Clay, Kansas, US |
14173 | 14173 | 2021-01-26 | US | Mississippi | Quitman | 28119 | 716 | 9 | 0 | 707 | 34.25157572 | -90.28908 | 2021-01-27 05:23:41 | Quitman, Mississippi, US |
14897 | 14897 | 2021-01-26 | US | Oklahoma | Latimer | 40077 | 714 | 7 | 0 | 707 | 34.87844729 | -95.25215049 | 2021-01-27 05:23:41 | Latimer, Oklahoma, US |
2568925 | 2568925 | 2021-01-25 | US | Kansas | Clay | 20027 | 730 | 23 | 0 | 707 | 39.34948772 | -97.16518128 | 2021-01-26 05:22:02 | Clay, Kansas, US |
2570221 | 2570221 | 2021-01-25 | US | Oklahoma | Latimer | 40077 | 714 | 7 | 0 | 707 | 34.87844729 | -95.25215049 | 2021-01-26 05:22:02 | Latimer, Oklahoma, US |
1761323 | 1761323 | 2021-01-24 | US | Montana | Valley | 30105 | 717 | 10 | 0 | 707 | 48.36435097 | -106.6669635 | 2021-01-25 05:22:16 | Valley, Montana, US |
438361 | 438361 | 2021-01-21 | US | Texas | Archer | 48009 | 741 | 10 | 0 | 707 | 33.61569967 | -98.68754589 | 2021-01-22 05:22:10 | Archer, Texas, US |
1096679 | 1096679 | 2021-01-20 | US | Oklahoma | Unassigned | 90040 | 707 | 0 | 0 | 707 | 36.83532655 | 0.0 | 2021-01-21 05:22:01 | Unassigned, Oklahoma, US |
909426 | 909426 | 2021-01-19 | US | Kansas | Anderson | 20003 | 715 | 8 | 0 | 707 | 38.21413251 | -95.29272815 | 2021-01-20 05:21:54 | Anderson, Kansas, US |
238489 | 238489 | 2021-01-18 | US | Kansas | Anderson | 20003 | 715 | 8 | 0 | 707 | 38.21413251 | -95.29272815 | 2021-01-19 05:22:15 | Anderson, Kansas, US |
3505432 | 3505432 | 2021-01-17 | US | Nebraska | Holt | 31089 | 721 | 14 | 0 | 707 | 42.45522056 | -98.78402558 | 2021-01-18 05:22:34 | Holt, Nebraska, US |
3103384 | 3103384 | 2021-01-16 | US | Missouri | Ralls | 29173 | 716 | 9 | 0 | 707 | 39.52817427 | -91.51838643 | 2021-01-17 05:22:17 | Ralls, Missouri, US |
3104795 | 3104795 | 2021-01-16 | US | Virginia | Lexington | 51678 | 721 | 14 | 0 | 707 | 37.78258621 | -79.44262866 | 2021-01-17 05:22:17 | Lexington, Virginia, US |
3516596 | 3516596 | 2021-01-15 | US | Iowa | Ida | 19093 | 737 | 30 | 0 | 707 | 42.38696136 | -95.51355387 | 2021-01-16 05:22:40 | Ida, Iowa, US |
3517346 | 3517346 | 2021-01-15 | US | Missouri | Ralls | 29173 | 716 | 9 | 0 | 707 | 39.52817427 | -91.51838643 | 2021-01-16 05:22:40 | Ralls, Missouri, US |
3310353 | 3310353 | 2021-01-13 | US | New Hampshire | Sullivan | 33019 | 713 | 6 | 0 | 707 | 43.36094111 | -72.22203125 | 2021-01-14 05:22:32 | Sullivan, New Hampshire, US |
776619 | 776619 | 2021-01-12 | US | New York | Yates | 36123 | 722 | 15 | 0 | 707 | 42.63505484 | -77.10369919 | 2021-01-13 05:22:15 | Yates, New York, US |
190583 | 190583 | 2021-01-11 | US | Arkansas | Scott | 5127 | 721 | 14 | 0 | 707 | 34.85588887 | -94.0632176 | 2021-01-12 05:22:15 | Scott, Arkansas, US |
190907 | 190907 | 2021-01-11 | US | Georgia | Montgomery | 13209 | 718 | 11 | 0 | 707 | 32.17201038 | -82.53527476 | 2021-01-12 05:22:15 | Montgomery, Georgia, US |
2628357 | 2628357 | 2021-01-10 | US | Ohio | Morgan | 39115 | 721 | 14 | 0 | 707 | 39.62081738 | -81.85308173 | 2021-01-11 05:21:50 | Morgan, Ohio, US |
154764 | 154764 | 2021-01-08 | US | Georgia | Dooly | 13093 | 732 | 25 | 0 | 707 | 32.15630737 | -83.79746561 | 2021-01-09 05:22:18 | Dooly, Georgia, US |
154772 | 154772 | 2021-01-08 | US | Georgia | Evans | 13109 | 721 | 14 | 0 | 707 | 32.15328841 | -81.8870105 | 2021-01-09 05:22:18 | Evans, Georgia, US |
154795 | 154795 | 2021-01-08 | US | Georgia | Irwin | 13155 | 725 | 18 | 0 | 707 | 31.60213036 | -83.27501387 | 2021-01-09 05:22:18 | Irwin, Georgia, US |
2542163 | 2542163 | 2021-01-07 | US | Georgia | Candler | 13043 | 744 | 37 | 0 | 707 | 32.40209349 | -82.07702563 | 2021-01-08 05:22:42 | Candler, Georgia, US |
2865594 | 2865594 | 2021-01-06 | US | Georgia | Turner | 13287 | 732 | 25 | 0 | 707 | 31.71612656 | -83.62069378 | 2021-01-07 05:22:03 | Turner, Georgia, US |
2229302 | 2229302 | 2021-01-02 | US | Mississippi | Claiborne | 28021 | 727 | 20 | 0 | 707 | 31.97061673 | -90.90702196 | 2021-01-03 05:22:52 | Claiborne, Mississippi, US |
2230237 | 2230237 | 2021-01-02 | US | Puerto Rico | Catano | 72033 | 707 | 0 | 0 | 707 | 18.437269 | -66.14330600000001 | 2021-01-03 05:22:52 | Catano, Puerto Rico, US |
1139230 | 1139230 | 2021-01-01 | US | North Carolina | Polk | 37149 | 720 | 13 | 0 | 707 | 35.27820615 | -82.16812354 | 2021-01-02 05:22:33 | Polk, North Carolina, US |
1139367 | 1139367 | 2021-01-01 | US | Ohio | Monroe | 39111 | 735 | 28 | 0 | 707 | 39.72984936 | -81.08464734 | 2021-01-02 05:22:33 | Monroe, Ohio, US |
1139598 | 1139598 | 2021-01-01 | US | Puerto Rico | Camuy | 72027 | 707 | 0 | 0 | 707 | 18.418578 | -66.860206 | 2021-01-02 05:22:33 | Camuy, Puerto Rico, US |
3697836 | 3697836 | 2020-12-31 | US | North Carolina | Polk | 37149 | 720 | 13 | 0 | 707 | 35.27820615 | -82.16812354 | 2021-01-01 05:23:07 | Polk, North Carolina, US |
3697973 | 3697973 | 2020-12-31 | US | Ohio | Monroe | 39111 | 735 | 28 | 0 | 707 | 39.72984936 | -81.08464734 | 2021-01-01 05:23:07 | Monroe, Ohio, US |
1011250 | 1011250 | 2020-12-30 | US | Idaho | Teton | 16081 | 709 | 2 | 0 | 707 | 43.75303583 | -111.2056773 | 2020-12-31 05:22:49 | Teton, Idaho, US |
1011527 | 1011527 | 2020-12-30 | US | Iowa | Pocahontas | 19151 | 718 | 11 | 0 | 707 | 42.73420133 | -94.67862564 | 2020-12-31 05:22:49 | Pocahontas, Iowa, US |
1012865 | 1012865 | 2020-12-30 | US | Oklahoma | Major | 40093 | 711 | 4 | 0 | 707 | 36.31149996 | -98.53467076 | 2020-12-31 05:22:49 | Major, Oklahoma, US |
1013312 | 1013312 | 2020-12-30 | US | Texas | Bailey | 48017 | 794 | 12 | 0 | 707 | 34.06854817 | -102.8299707 | 2020-12-31 05:22:49 | Bailey, Texas, US |
767025 | 767025 | 2020-12-29 | US | Florida | Liberty | 12077 | 721 | 14 | 0 | 707 | 30.23766008 | -84.8829258 | 2020-12-30 05:22:34 | Liberty, Florida, US |
3764727 | 3764727 | 2020-12-28 | US | Texas | Leon | 48289 | 929 | 22 | 0 | 707 | 31.29872538 | -95.9936328 | 2020-12-29 05:22:37 | Leon, Texas, US |
3781047 | 3781047 | 2020-12-27 | US | Texas | Leon | 48289 | 914 | 22 | 0 | 707 | 31.29872538 | -95.9936328 | 2020-12-28 05:22:06 | Leon, Texas, US |
3781203 | 3781203 | 2020-12-27 | US | Virginia | Buchanan | 51027 | 731 | 24 | 0 | 707 | 37.26818323 | -82.03749726 | 2020-12-28 05:22:06 | Buchanan, Virginia, US |
2224044 | 2224044 | 2020-12-26 | US | California | Del Norte | 6015 | 711 | 2 | 0 | 707 | 41.74228275 | -123.8974063 | 2020-12-27 05:22:55 | Del Norte, California, US |
3693524 | 3693524 | 2020-12-24 | US | Nebraska | Cheyenne | 31033 | 717 | 10 | 0 | 707 | 41.21999357 | -102.9941693 | 2020-12-25 05:22:48 | Cheyenne, Nebraska, US |
2407568 | 2407568 | 2020-12-23 | US | Georgia | Atkinson | 13003 | 716 | 9 | 0 | 707 | 31.29633502 | -82.87545866 | 2020-12-24 05:23:04 | Atkinson, Georgia, US |
2933961 | 2933961 | 2020-12-19 | US | Puerto Rico | Juncos | 72077 | 707 | 0 | 0 | 707 | 18.223793 | -65.909109 | 2020-12-20 05:27:32 | Juncos, Puerto Rico, US |
2934554 | 2934554 | 2020-12-19 | US | Virginia | Gloucester | 51073 | 714 | 7 | 0 | 707 | 37.40809042 | -76.53524337 | 2020-12-20 05:27:32 | Gloucester, Virginia, US |
3150016 | 3150016 | 2020-12-16 | US | Alaska | North Slope | 2185 | 709 | 2 | 0 | 707 | 69.31479216 | -153.4836093 | 2020-12-17 05:28:12 | North Slope, Alaska, US |
3150377 | 3150377 | 2020-12-16 | US | Georgia | Early | 13099 | 746 | 39 | 0 | 707 | 31.32155345 | -84.90255207 | 2020-12-17 05:28:12 | Early, Georgia, US |
1036591 | 1036591 | 2020-12-15 | US | New York | Clinton | 36019 | 712 | 5 | 0 | 707 | 44.74530905 | -73.67875352 | 2020-12-16 05:28:04 | Clinton, New York, US |
1037719 | 1037719 | 2020-12-15 | US | Virginia | Hopewell | 51670 | 716 | 9 | 0 | 707 | 37.29186313 | -77.29754684 | 2020-12-16 05:28:04 | Hopewell, Virginia, US |
1751687 | 1751687 | 2020-12-14 | US | Alaska | Kodiak Island | 2150 | 708 | 1 | 0 | 707 | 57.65529415 | -153.7493579 | 2020-12-15 05:26:38 | Kodiak Island, Alaska, US |
1751956 | 1751956 | 2020-12-14 | US | Florida | Glades | 12043 | 718 | 11 | 0 | 707 | 26.95635849 | -81.18996211 | 2020-12-15 05:26:38 | Glades, Florida, US |
1752572 | 1752572 | 2020-12-14 | US | Kansas | Marshall | 20117 | 724 | 17 | 0 | 707 | 39.78359669 | -96.52278974 | 2020-12-15 05:26:38 | Marshall, Kansas, US |
3848897 | 3848897 | 2020-12-13 | US | Indiana | Newton | 18111 | 730 | 23 | 0 | 707 | 40.95610449 | -87.39635768 | 2020-12-14 05:26:27 | Newton, Indiana, US |
3849092 | 3849092 | 2020-12-13 | US | Kansas | Marshall | 20117 | 724 | 17 | 0 | 707 | 39.78359669 | -96.52278974 | 2020-12-14 05:26:27 | Marshall, Kansas, US |
3851163 | 3851163 | 2020-12-13 | US | Virginia | Page | 51139 | 740 | 33 | 0 | 707 | 38.61807452 | -78.48797204 | 2020-12-14 05:26:27 | Page, Virginia, US |
846874 | 846874 | 2020-12-12 | US | Kansas | Marshall | 20117 | 724 | 17 | 0 | 707 | 39.78359669 | -96.52278974 | 2020-12-13 05:27:20 | Marshall, Kansas, US |
848324 | 848324 | 2020-12-12 | US | Puerto Rico | Naranjito | 72105 | 707 | 0 | 0 | 707 | 18.288019 | -66.252703 | 2020-12-13 05:27:20 | Naranjito, Puerto Rico, US |
861981 | 861981 | 2020-12-11 | US | Kansas | Marshall | 20117 | 724 | 17 | 0 | 707 | 39.78359669 | -96.52278974 | 2020-12-12 05:26:19 | Marshall, Kansas, 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]);