johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
191 rows where active = 903 and country_or_region = "US" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Georgia 13
- Mississippi 12
- Kentucky 10
- Texas 10
- Virginia 10
- Alabama 9
- Arkansas 8
- Indiana 8
- Iowa 8
- South Carolina 8
- Minnesota 7
- Tennessee 7
- Illinois 6
- Kansas 6
- Missouri 6
- Oklahoma 6
- Puerto Rico 5
- Florida 4
- Louisiana 4
- Michigan 4
- Nebraska 4
- North Carolina 4
- Pennsylvania 4
- Wisconsin 4
- Montana 3
- Nevada 3
- California 2
- Colorado 2
- Idaho 2
- New York 2
- …
country_or_region 1
- US · 191 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3669422 | 3669422 | 2021-03-06 | US | Mississippi | Humphreys | 28053 | 931 | 28 | 0 | 903 | 33.12825718 | -90.52252707 | 2021-03-07 05:21:54 | Humphreys, Mississippi, US |
1618043 | 1618043 | 2021-03-05 | US | Mississippi | Humphreys | 28053 | 931 | 28 | 0 | 903 | 33.12825718 | -90.52252707 | 2021-03-06 04:23:41 | Humphreys, Mississippi, US |
2209454 | 2209454 | 2021-03-04 | US | Mississippi | Humphreys | 28053 | 930 | 27 | 0 | 903 | 33.12825718 | -90.52252707 | 2021-03-05 05:26:29 | Humphreys, Mississippi, US |
1859063 | 1859063 | 2021-02-25 | US | Indiana | Benton | 18007 | 916 | 13 | 0 | 903 | 40.60626947 | -87.31093999 | 2021-02-26 05:22:40 | Benton, Indiana, US |
280680 | 280680 | 2021-02-24 | US | Arkansas | Marion | 5089 | 933 | 30 | 0 | 903 | 36.26844485 | -92.68451899 | 2021-02-25 05:24:57 | Marion, Arkansas, US |
281786 | 281786 | 2021-02-24 | US | Michigan | Antrim | 26009 | 922 | 19 | 0 | 903 | 44.99690221 | -85.15503082 | 2021-02-25 05:24:57 | Antrim, Michigan, US |
283322 | 283322 | 2021-02-24 | US | Texas | La Salle | 48283 | 1093 | 22 | 0 | 903 | 28.34453111 | -99.09908775 | 2021-02-25 05:24:57 | La Salle, Texas, US |
531767 | 531767 | 2021-02-22 | US | Indiana | Brown | 18013 | 942 | 39 | 0 | 903 | 39.19605589 | -86.22868909 | 2021-02-23 05:23:41 | Brown, Indiana, US |
183101 | 183101 | 2021-02-21 | US | Indiana | Brown | 18013 | 942 | 39 | 0 | 903 | 39.19605589 | -86.22868909 | 2021-02-22 05:24:21 | Brown, Indiana, US |
1154473 | 1154473 | 2021-02-18 | US | Kansas | Wilson | 20205 | 917 | 14 | 0 | 903 | 37.55937174 | -95.74323255 | 2021-02-19 05:24:16 | Wilson, Kansas, US |
3602393 | 3602393 | 2021-02-17 | US | Kansas | Wilson | 20205 | 917 | 14 | 0 | 903 | 37.55937174 | -95.74323255 | 2021-02-18 05:22:58 | Wilson, Kansas, US |
3602491 | 3602491 | 2021-02-17 | US | Kentucky | Pendleton | 21191 | 904 | 1 | 0 | 903 | 38.69607718 | -84.35599463 | 2021-02-18 05:22:58 | Pendleton, Kentucky, US |
3980715 | 3980715 | 2021-02-10 | US | Nevada | Pershing | 32027 | 922 | 19 | 0 | 903 | 40.44003782 | -118.40056409999998 | 2021-02-11 05:23:55 | Pershing, Nevada, US |
1530035 | 1530035 | 2021-02-09 | US | Nevada | Pershing | 32027 | 922 | 19 | 0 | 903 | 40.44003782 | -118.40056409999998 | 2021-02-10 05:22:41 | Pershing, Nevada, US |
1530384 | 1530384 | 2021-02-09 | US | Ohio | Morgan | 39115 | 924 | 21 | 0 | 903 | 39.62081738 | -81.85308173 | 2021-02-10 05:22:41 | Morgan, Ohio, US |
1590880 | 1590880 | 2021-02-05 | US | Puerto Rico | Aguada | 72003 | 903 | 0 | 0 | 903 | 18.360255 | -67.17513100000001 | 2021-02-06 05:23:55 | Aguada, Puerto Rico, US |
1591769 | 1591769 | 2021-02-05 | US | Wyoming | Converse | 56009 | 917 | 14 | 0 | 903 | 42.97272268 | -105.5081848 | 2021-02-06 05:23:55 | Converse, Wyoming, US |
791770 | 791770 | 2021-02-04 | US | Kentucky | Estill | 21065 | 903 | 0 | 0 | 903 | 37.69241417 | -83.95956369 | 2021-02-05 05:22:38 | Estill, Kentucky, US |
342995 | 342995 | 2021-02-03 | US | Puerto Rico | Cayey | 72035 | 903 | 0 | 0 | 903 | 18.102851 | -66.14914 | 2021-02-04 05:22:26 | Cayey, Puerto Rico, US |
2214406 | 2214406 | 2021-01-30 | US | Puerto Rico | Isabela | 72071 | 903 | 0 | 0 | 903 | 18.44981 | -67.005093 | 2021-01-31 05:22:42 | Isabela, Puerto Rico, US |
12953 | 12953 | 2021-01-26 | US | Colorado | Grand | 8049 | 955 | 5 | 0 | 903 | 40.10603347 | -106.1178042 | 2021-01-27 05:23:41 | Grand, Colorado, US |
2428639 | 2428639 | 2021-01-23 | US | Minnesota | Murray | 27101 | 909 | 6 | 0 | 903 | 44.02216709 | -95.76328482 | 2021-01-24 05:22:35 | Murray, Minnesota, US |
436577 | 436577 | 2021-01-21 | US | Iowa | Palo Alto | 19147 | 914 | 11 | 0 | 903 | 43.08193849 | -94.67824621 | 2021-01-22 05:22:10 | Palo Alto, Iowa, US |
908962 | 908962 | 2021-01-19 | US | Georgia | Early | 13099 | 946 | 43 | 0 | 903 | 31.32155345 | -84.90255207 | 2021-01-20 05:21:54 | Early, Georgia, US |
909053 | 909053 | 2021-01-19 | US | Georgia | Towns | 13281 | 941 | 38 | 0 | 903 | 34.91369188 | -83.74107459999998 | 2021-01-20 05:21:54 | Towns, Georgia, US |
910162 | 910162 | 2021-01-19 | US | Montana | Deer Lodge | 30023 | 912 | 9 | 0 | 903 | 46.05953325 | -113.073353 | 2021-01-20 05:21:54 | Deer Lodge, Montana, US |
911207 | 911207 | 2021-01-19 | US | Texas | Callahan | 48059 | 922 | 28 | 0 | 903 | 32.29760619 | -99.37326312 | 2021-01-20 05:21:54 | Callahan, Texas, US |
3515895 | 3515895 | 2021-01-15 | US | Arkansas | Little River | 5081 | 942 | 39 | 0 | 903 | 33.70375665 | -94.23468591 | 2021-01-16 05:22:40 | Little River, Arkansas, US |
3880902 | 3880902 | 2021-01-14 | US | Kansas | Rice | 20159 | 907 | 4 | 0 | 903 | 38.34616184 | -98.19992118 | 2021-01-15 05:22:24 | Rice, Kansas, US |
3880951 | 3880951 | 2021-01-14 | US | Kentucky | Casey | 21045 | 929 | 26 | 0 | 903 | 37.32533118 | -84.92726209 | 2021-01-15 05:22:24 | Casey, Kentucky, US |
3881318 | 3881318 | 2021-01-14 | US | Minnesota | Pipestone | 27117 | 925 | 22 | 0 | 903 | 44.02301619 | -96.25841142 | 2021-01-15 05:22:24 | Pipestone, Minnesota, US |
3882275 | 3882275 | 2021-01-14 | US | Pennsylvania | Wyoming | 42131 | 935 | 32 | 0 | 903 | 41.51955538 | -76.01074915 | 2021-01-15 05:22:24 | Wyoming, Pennsylvania, US |
3882519 | 3882519 | 2021-01-14 | US | Tennessee | Houston | 47083 | 956 | 22 | 0 | 903 | 36.28872054 | -87.71878828 | 2021-01-15 05:22:24 | Houston, Tennessee, US |
3308557 | 3308557 | 2021-01-13 | US | Alabama | Conecuh | 1035 | 921 | 18 | 0 | 903 | 31.43401703 | -86.99320044 | 2021-01-14 05:22:32 | Conecuh, Alabama, US |
3309529 | 3309529 | 2021-01-13 | US | Kansas | Rice | 20159 | 907 | 4 | 0 | 903 | 38.34616184 | -98.19992118 | 2021-01-14 05:22:32 | Rice, Kansas, US |
774702 | 774702 | 2021-01-12 | US | Alabama | Conecuh | 1035 | 921 | 18 | 0 | 903 | 31.43401703 | -86.99320044 | 2021-01-13 05:22:15 | Conecuh, Alabama, US |
777100 | 777100 | 2021-01-12 | US | Puerto Rico | Morovis | 72101 | 903 | 0 | 0 | 903 | 18.316963 | -66.420383 | 2021-01-13 05:22:15 | Morovis, Puerto Rico, US |
777144 | 777144 | 2021-01-12 | US | South Carolina | Calhoun | 45017 | 926 | 23 | 0 | 903 | 33.66926881 | -80.77722168 | 2021-01-13 05:22:15 | Calhoun, South Carolina, US |
192865 | 192865 | 2021-01-11 | US | South Carolina | Calhoun | 45017 | 925 | 22 | 0 | 903 | 33.66926881 | -80.77722168 | 2021-01-12 05:22:15 | Calhoun, South Carolina, US |
192912 | 192912 | 2021-01-11 | US | South Dakota | Butte | 46019 | 923 | 20 | 0 | 903 | 44.90608745 | -103.5079318 | 2021-01-12 05:22:15 | Butte, South Dakota, US |
2865058 | 2865058 | 2021-01-06 | US | Alabama | Bullock | 1011 | 925 | 22 | 0 | 903 | 32.10030533 | -85.71265535 | 2021-01-07 05:22:03 | Bullock, Alabama, US |
2866085 | 2866085 | 2021-01-06 | US | Kentucky | Caldwell | 21033 | 919 | 16 | 0 | 903 | 37.14749129 | -87.86948214 | 2021-01-07 05:22:03 | Caldwell, Kentucky, US |
3036724 | 3036724 | 2021-01-05 | US | North Dakota | Traill | 38097 | 911 | 17 | 0 | 903 | 47.45367788 | -97.16323288 | 2021-01-06 05:22:16 | Traill, North Dakota, US |
1065046 | 1065046 | 2021-01-04 | US | Texas | Runnels | 48399 | 919 | 18 | 0 | 903 | 31.8314342 | -99.97616148 | 2021-01-05 05:21:49 | Runnels, Texas, US |
2228701 | 2228701 | 2021-01-02 | US | Iowa | Franklin | 19069 | 920 | 17 | 0 | 903 | 42.73270384 | -93.26256925 | 2021-01-03 05:22:52 | Franklin, Iowa, US |
1138314 | 1138314 | 2021-01-01 | US | Kentucky | Mason | 21161 | 920 | 17 | 0 | 903 | 38.59471935 | -83.82151043 | 2021-01-02 05:22:33 | Mason, Kentucky, US |
1138694 | 1138694 | 2021-01-01 | US | Mississippi | Lawrence | 28077 | 919 | 16 | 0 | 903 | 31.55147224 | -90.10841127 | 2021-01-02 05:22:33 | Lawrence, Mississippi, US |
1138866 | 1138866 | 2021-01-01 | US | Montana | Dawson | 30021 | 926 | 23 | 0 | 903 | 47.26584855 | -104.89444170000002 | 2021-01-02 05:22:33 | Dawson, Montana, US |
3696920 | 3696920 | 2020-12-31 | US | Kentucky | Mason | 21161 | 920 | 17 | 0 | 903 | 38.59471935 | -83.82151043 | 2021-01-01 05:23:07 | Mason, Kentucky, US |
3697472 | 3697472 | 2020-12-31 | US | Montana | Dawson | 30021 | 926 | 23 | 0 | 903 | 47.26584855 | -104.89444170000002 | 2021-01-01 05:23:07 | Dawson, Montana, US |
1010662 | 1010662 | 2020-12-30 | US | Alabama | Crenshaw | 1041 | 939 | 36 | 0 | 903 | 31.72941803 | -86.31593104 | 2020-12-31 05:22:49 | Crenshaw, Alabama, US |
1011230 | 1011230 | 2020-12-30 | US | Idaho | Franklin | 16041 | 911 | 8 | 0 | 903 | 42.18332217 | -111.8149666 | 2020-12-31 05:22:49 | Franklin, Idaho, US |
1011735 | 1011735 | 2020-12-30 | US | Kentucky | Mason | 21161 | 920 | 17 | 0 | 903 | 38.59471935 | -83.82151043 | 2020-12-31 05:22:49 | Mason, Kentucky, US |
1012128 | 1012128 | 2020-12-30 | US | Mississippi | Noxubee | 28103 | 923 | 20 | 0 | 903 | 33.11009499 | -88.56949061 | 2020-12-31 05:22:49 | Noxubee, Mississippi, US |
3762056 | 3762056 | 2020-12-28 | US | Arkansas | Desha | 5041 | 914 | 11 | 0 | 903 | 33.83011025 | -91.25500948 | 2020-12-29 05:22:37 | Desha, Arkansas, US |
3763300 | 3763300 | 2020-12-28 | US | Minnesota | Kanabec | 27065 | 921 | 18 | 0 | 903 | 45.9459309 | -93.29275192 | 2020-12-29 05:22:37 | Kanabec, Minnesota, US |
3764480 | 3764480 | 2020-12-28 | US | South Dakota | Turner | 46125 | 950 | 47 | 0 | 903 | 43.3109081 | -97.14865776 | 2020-12-29 05:22:37 | Turner, South Dakota, US |
3764608 | 3764608 | 2020-12-28 | US | Texas | Burleson | 48051 | 1055 | 14 | 0 | 903 | 30.49273808 | -96.62158484 | 2020-12-29 05:22:37 | Burleson, Texas, US |
3764836 | 3764836 | 2020-12-28 | US | Texas | Zapata | 48505 | 959 | 9 | 0 | 903 | 27.00156391 | -99.16987152 | 2020-12-29 05:22:37 | Zapata, Texas, US |
3781156 | 3781156 | 2020-12-27 | US | Texas | Zapata | 48505 | 941 | 9 | 0 | 903 | 27.00156391 | -99.16987152 | 2020-12-28 05:22:06 | Zapata, Texas, US |
203005 | 203005 | 2020-12-25 | US | Georgia | Brooks | 13027 | 933 | 30 | 0 | 903 | 30.83922642 | -83.58303423 | 2020-12-26 05:22:28 | Brooks, Georgia, US |
3692116 | 3692116 | 2020-12-24 | US | Colorado | Pitkin | 8097 | 1052 | 4 | 0 | 903 | 39.21720112 | -106.9310027 | 2020-12-25 05:22:48 | Pitkin, Colorado, US |
928890 | 928890 | 2020-12-21 | US | Iowa | Jefferson | 19101 | 923 | 20 | 0 | 903 | 41.03192394 | -91.94849466 | 2020-12-22 05:22:33 | Jefferson, Iowa, US |
2123087 | 2123087 | 2020-12-20 | US | Virginia | Nottoway | 51135 | 927 | 24 | 0 | 903 | 37.1435975 | -78.05065922 | 2020-12-21 05:27:58 | Nottoway, Virginia, US |
1902116 | 1902116 | 2020-12-18 | US | Idaho | Washington | 16087 | 917 | 14 | 0 | 903 | 44.45275475 | -116.7847688 | 2020-12-19 05:27:52 | Washington, Idaho, US |
1902627 | 1902627 | 2020-12-18 | US | Kentucky | Spencer | 21215 | 906 | 3 | 0 | 903 | 38.03223971 | -85.32749335 | 2020-12-19 05:27:52 | Spencer, Kentucky, US |
3151564 | 3151564 | 2020-12-16 | US | Missouri | Wright | 29229 | 922 | 19 | 0 | 903 | 37.27029221 | -92.46914488 | 2020-12-17 05:28:12 | Wright, Missouri, US |
1037149 | 1037149 | 2020-12-15 | US | Puerto Rico | Vega Alta | 72143 | 903 | 0 | 0 | 903 | 18.409346 | -66.33725 | 2020-12-16 05:28:04 | Vega Alta, Puerto Rico, US |
1037968 | 1037968 | 2020-12-15 | US | Wyoming | Goshen | 56015 | 915 | 12 | 0 | 903 | 42.08798185 | -104.3534743 | 2020-12-16 05:28:04 | Goshen, Wyoming, US |
1752292 | 1752292 | 2020-12-14 | US | Illinois | Piatt | 17147 | 908 | 5 | 0 | 903 | 40.01360584 | -88.59319339 | 2020-12-15 05:26:38 | Piatt, Illinois, US |
3851126 | 3851126 | 2020-12-13 | US | Virginia | Halifax | 51083 | 927 | 24 | 0 | 903 | 36.76654925 | -78.93512622 | 2020-12-14 05:26:27 | Halifax, Virginia, US |
1601678 | 1601678 | 2020-12-10 | US | Kentucky | Simpson | 21213 | 912 | 9 | 0 | 903 | 36.74058474 | -86.58047435 | 2020-12-11 05:26:59 | Simpson, Kentucky, US |
1603635 | 1603635 | 2020-12-10 | US | Virginia | Wythe | 51197 | 913 | 10 | 0 | 903 | 36.91582035 | -81.07834059 | 2020-12-11 05:26:59 | Wythe, Virginia, US |
1603738 | 1603738 | 2020-12-10 | US | Wisconsin | Buffalo | 55011 | 908 | 5 | 0 | 903 | 44.37835084 | -91.75332578 | 2020-12-11 05:26:59 | Buffalo, Wisconsin, US |
2976806 | 2976806 | 2020-12-09 | US | Maryland | Talbot | 24041 | 910 | 7 | 0 | 903 | 38.76618159 | -76.10882561 | 2020-12-10 05:26:19 | Talbot, Maryland, US |
3861939 | 3861939 | 2020-12-04 | US | Nebraska | Seward | 31159 | 912 | 9 | 0 | 903 | 40.87241834 | -97.139673 | 2020-12-05 05:27:36 | Seward, Nebraska, US |
3862946 | 3862946 | 2020-12-04 | US | Texas | Hutchinson | 48233 | 1605 | 29 | 0 | 903 | 35.84006574 | -101.3546643 | 2020-12-05 05:27:36 | Hutchinson, Texas, US |
3863240 | 3863240 | 2020-12-04 | US | Virginia | Warren | 51187 | 930 | 27 | 0 | 903 | 38.90847745 | -78.20280433 | 2020-12-05 05:27:36 | Warren, Virginia, US |
76872 | 76872 | 2020-12-03 | US | Mississippi | Clarke | 28023 | 956 | 53 | 0 | 903 | 32.04158545 | -88.68896219999998 | 2020-12-04 05:27:27 | Clarke, Mississippi, US |
740217 | 740217 | 2020-12-02 | US | Missouri | Madison | 29123 | 912 | 9 | 0 | 903 | 37.47865134 | -90.3467143 | 2020-12-03 05:28:22 | Madison, Missouri, US |
1584567 | 1584567 | 2020-11-30 | US | Alabama | Washington | 1129 | 922 | 19 | 0 | 903 | 31.4092794 | -88.20689944 | 2020-12-01 05:26:18 | Washington, Alabama, US |
1586717 | 1586717 | 2020-11-30 | US | Oklahoma | Kingfisher | 40073 | 909 | 6 | 0 | 903 | 35.94530008 | -97.94193268 | 2020-12-01 05:26:18 | Kingfisher, Oklahoma, US |
2937837 | 2937837 | 2020-11-28 | US | Oregon | Douglas | 41019 | 921 | 18 | 0 | 903 | 43.27941273 | -123.167291 | 2020-11-29 05:25:55 | Douglas, Oregon, US |
1974709 | 1974709 | 2020-11-25 | US | Nebraska | York | 31185 | 906 | 3 | 0 | 903 | 40.87272618 | -97.59710186 | 2020-11-26 05:27:44 | York, Nebraska, US |
1353240 | 1353240 | 2020-11-24 | US | Tennessee | Decatur | 47039 | 921 | 13 | 0 | 903 | 35.60048904 | -88.11043779 | 2020-11-25 05:27:20 | Decatur, Tennessee, US |
680712 | 680712 | 2020-11-23 | US | North Dakota | McLean | 38055 | 926 | 14 | 0 | 903 | 47.60766714 | -101.3182418 | 2020-11-24 05:27:31 | McLean, North Dakota, US |
681234 | 681234 | 2020-11-23 | US | Tennessee | Decatur | 47039 | 917 | 12 | 0 | 903 | 35.60048904 | -88.11043779 | 2020-11-24 05:27:31 | Decatur, Tennessee, US |
3190940 | 3190940 | 2020-11-22 | US | Illinois | Bond | 17005 | 913 | 10 | 0 | 903 | 38.88829622 | -89.43534887 | 2020-11-23 05:25:26 | Bond, Illinois, US |
3191213 | 3191213 | 2020-11-22 | US | Iowa | Poweshiek | 19157 | 915 | 12 | 0 | 903 | 41.68625425 | -92.53155731 | 2020-11-23 05:25:26 | Poweshiek, Iowa, US |
124395 | 124395 | 2020-11-18 | US | Minnesota | Brown | 27015 | 909 | 6 | 0 | 903 | 44.24205652 | -94.72562874 | 2020-11-19 05:25:23 | Brown, Minnesota, US |
3170427 | 3170427 | 2020-11-16 | US | Georgia | Fannin | 13111 | 939 | 36 | 0 | 903 | 34.86430205 | -84.316964 | 2020-11-17 05:25:54 | Fannin, Georgia, US |
3172430 | 3172430 | 2020-11-16 | US | South Carolina | Barnwell | 45011 | 928 | 25 | 0 | 903 | 33.26679302 | -81.43584352 | 2020-11-17 05:25:54 | Barnwell, South Carolina, US |
3172469 | 3172469 | 2020-11-16 | US | South Carolina | Union | 45087 | 927 | 24 | 0 | 903 | 34.68835752 | -81.61730349 | 2020-11-17 05:25:54 | Union, South Carolina, US |
2917425 | 2917425 | 2020-11-14 | US | New York | Ontario | 36069 | 939 | 36 | 0 | 903 | 42.85145728 | -77.30874425 | 2020-11-15 05:26:53 | Ontario, New York, US |
2918485 | 2918485 | 2020-11-14 | US | Virginia | Campbell | 51031 | 914 | 11 | 0 | 903 | 37.20553386 | -79.09678609 | 2020-11-15 05:26:53 | Campbell, Virginia, US |
2785758 | 2785758 | 2020-11-13 | US | Georgia | Butts | 13035 | 948 | 45 | 0 | 903 | 33.283094500000004 | -83.95435040000002 | 2020-11-14 05:25:37 | Butts, Georgia, US |
2785821 | 2785821 | 2020-11-13 | US | Georgia | Jefferson | 13163 | 941 | 38 | 0 | 903 | 33.05867328 | -82.41609057 | 2020-11-14 05:25:37 | Jefferson, Georgia, US |
2788136 | 2788136 | 2020-11-13 | US | Texas | Kerr | 48265 | 867 | 17 | 0 | 903 | 30.06040006 | -99.34930144 | 2020-11-14 05:25:37 | Kerr, Texas, US |
868107 | 868107 | 2020-11-12 | US | Virginia | Greensville | 51081 | 918 | 15 | 0 | 903 | 36.67878901 | -77.56351439 | 2020-11-13 05:25:30 | Greensville, Virginia, US |
1989478 | 1989478 | 2020-11-09 | US | Georgia | Peach | 13225 | 929 | 26 | 0 | 903 | 32.56934316 | -83.82937 | 2020-11-10 05:40:07 | Peach, Georgia, 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]);