johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
229 rows where confirmed = 3094 and country_or_region = "US" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Georgia 21
- Oklahoma 21
- Louisiana 18
- Iowa 15
- Mississippi 14
- Texas 12
- Michigan 10
- Ohio 9
- Tennessee 9
- Arkansas 8
- Illinois 8
- Puerto Rico 8
- North Carolina 7
- Indiana 6
- Minnesota 6
- Virginia 6
- Kentucky 5
- Missouri 4
- New York 4
- West Virginia 4
- Alabama 3
- Colorado 3
- Florida 3
- Kansas 3
- Massachusetts 3
- New Mexico 3
- Pennsylvania 3
- Idaho 2
- Nebraska 2
- California 1
- …
country_or_region 1
- US · 229 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2753378 | 2753378 | 2022-12-29 | US | Arkansas | Chicot | 5017 | 3094 | 63 | 0 | 33.26458973 | -91.29539209 | 2022-12-30 04:21:04 | Chicot, Arkansas, US | |
1074384 | 1074384 | 2022-12-28 | US | Arkansas | Chicot | 5017 | 3094 | 63 | 0 | 33.26458973 | -91.29539209 | 2022-12-29 04:21:01 | Chicot, Arkansas, US | |
506450 | 506450 | 2022-12-17 | US | Puerto Rico | Maunabo | 72095 | 3094 | 0 | 0 | 18.017889 | -65.922235 | 2022-12-18 04:21:03 | Maunabo, Puerto Rico, US | |
200844 | 200844 | 2022-10-19 | US | Oklahoma | Nowata | 40105 | 3094 | 43 | 0 | 36.79843529 | -95.61902331 | 2022-10-20 04:22:59 | Nowata, Oklahoma, US | |
2759505 | 2759505 | 2022-10-18 | US | Oklahoma | Nowata | 40105 | 3094 | 43 | 0 | 36.79843529 | -95.61902331 | 2022-10-19 04:22:26 | Nowata, Oklahoma, US | |
2027339 | 2027339 | 2022-10-17 | US | Oklahoma | Nowata | 40105 | 3094 | 43 | 0 | 36.79843529 | -95.61902331 | 2022-10-18 04:22:42 | Nowata, Oklahoma, US | |
2162117 | 2162117 | 2022-10-16 | US | Oklahoma | Nowata | 40105 | 3094 | 43 | 0 | 36.79843529 | -95.61902331 | 2022-10-17 04:20:31 | Nowata, Oklahoma, US | |
2162774 | 2162774 | 2022-10-16 | US | Texas | Trinity | 48455 | 3094 | 75 | 0 | 31.0879489 | -95.1367187 | 2022-10-17 04:20:31 | Trinity, Texas, US | |
518314 | 518314 | 2022-10-15 | US | Oklahoma | Nowata | 40105 | 3094 | 43 | 0 | 36.79843529 | -95.61902331 | 2022-10-16 04:22:39 | Nowata, Oklahoma, US | |
518971 | 518971 | 2022-10-15 | US | Texas | Trinity | 48455 | 3094 | 75 | 0 | 31.0879489 | -95.1367187 | 2022-10-16 04:22:39 | Trinity, Texas, US | |
2035371 | 2035371 | 2022-10-14 | US | Oklahoma | Nowata | 40105 | 3094 | 43 | 0 | 36.79843529 | -95.61902331 | 2022-10-15 04:22:00 | Nowata, Oklahoma, US | |
2036028 | 2036028 | 2022-10-14 | US | Texas | Trinity | 48455 | 3094 | 75 | 0 | 31.0879489 | -95.1367187 | 2022-10-15 04:22:00 | Trinity, Texas, US | |
3756059 | 3756059 | 2022-10-13 | US | Oklahoma | Nowata | 40105 | 3094 | 43 | 0 | 36.79843529 | -95.61902331 | 2022-10-14 04:22:28 | Nowata, Oklahoma, US | |
3216884 | 3216884 | 2022-10-12 | US | Oklahoma | Nowata | 40105 | 3094 | 43 | 0 | 36.79843529 | -95.61902331 | 2022-10-13 04:22:39 | Nowata, Oklahoma, US | |
3217044 | 3217044 | 2022-10-12 | US | Puerto Rico | Guanica | 72055 | 3094 | 0 | 0 | 17.982429 | -66.919643 | 2022-10-13 04:22:39 | Guanica, Puerto Rico, US | |
3252733 | 3252733 | 2022-10-11 | US | Oklahoma | Nowata | 40105 | 3094 | 43 | 0 | 36.79843529 | -95.61902331 | 2022-10-12 04:22:51 | Nowata, Oklahoma, US | |
2969992 | 2969992 | 2022-10-10 | US | Oklahoma | Nowata | 40105 | 3094 | 43 | 0 | 36.79843529 | -95.61902331 | 2022-10-11 04:23:05 | Nowata, Oklahoma, US | |
3100028 | 3100028 | 2022-10-09 | US | Oklahoma | Nowata | 40105 | 3094 | 43 | 0 | 36.79843529 | -95.61902331 | 2022-10-10 04:22:32 | Nowata, Oklahoma, US | |
4005253 | 4005253 | 2022-10-08 | US | Oklahoma | Nowata | 40105 | 3094 | 43 | 0 | 36.79843529 | -95.61902331 | 2022-10-09 04:21:16 | Nowata, Oklahoma, US | |
398850 | 398850 | 2022-10-07 | US | Oklahoma | Nowata | 40105 | 3094 | 43 | 0 | 36.79843529 | -95.61902331 | 2022-10-08 04:22:56 | Nowata, Oklahoma, US | |
2531967 | 2531967 | 2022-10-06 | US | Oklahoma | Nowata | 40105 | 3094 | 43 | 0 | 36.79843529 | -95.61902331 | 2022-10-07 04:23:08 | Nowata, Oklahoma, US | |
132304 | 132304 | 2022-10-04 | US | Louisiana | West Feliciana | 22125 | 3094 | 48 | 0 | 30.87882871 | -91.4148538 | 2022-10-05 04:23:06 | West Feliciana, Louisiana, US | |
2687251 | 2687251 | 2022-10-03 | US | Louisiana | West Feliciana | 22125 | 3094 | 48 | 0 | 30.87882871 | -91.4148538 | 2022-10-04 04:22:55 | West Feliciana, Louisiana, US | |
2261318 | 2261318 | 2022-10-02 | US | Louisiana | West Feliciana | 22125 | 3094 | 48 | 0 | 30.87882871 | -91.4148538 | 2022-10-03 04:23:11 | West Feliciana, Louisiana, US | |
2996844 | 2996844 | 2022-10-01 | US | Louisiana | West Feliciana | 22125 | 3094 | 48 | 0 | 30.87882871 | -91.4148538 | 2022-10-02 04:21:23 | West Feliciana, Louisiana, US | |
855170 | 855170 | 2022-09-30 | US | Louisiana | West Feliciana | 22125 | 3094 | 48 | 0 | 30.87882871 | -91.4148538 | 2022-10-01 04:23:01 | West Feliciana, Louisiana, US | |
2377096 | 2377096 | 2022-09-29 | US | Louisiana | West Feliciana | 22125 | 3094 | 48 | 0 | 30.87882871 | -91.4148538 | 2022-09-30 04:23:09 | West Feliciana, Louisiana, US | |
1561647 | 1561647 | 2022-09-28 | US | Louisiana | West Feliciana | 22125 | 3094 | 48 | 0 | 30.87882871 | -91.4148538 | 2022-09-29 04:22:34 | West Feliciana, Louisiana, US | |
3996190 | 3996190 | 2022-09-27 | US | Louisiana | West Feliciana | 22125 | 3094 | 48 | 0 | 30.87882871 | -91.4148538 | 2022-09-28 04:23:01 | West Feliciana, Louisiana, US | |
2770518 | 2770518 | 2022-09-26 | US | Louisiana | West Feliciana | 22125 | 3094 | 48 | 0 | 30.87882871 | -91.4148538 | 2022-09-27 04:23:01 | West Feliciana, Louisiana, US | |
1978171 | 1978171 | 2022-09-25 | US | Louisiana | West Feliciana | 22125 | 3094 | 48 | 0 | 30.87882871 | -91.4148538 | 2022-09-26 04:20:52 | West Feliciana, Louisiana, US | |
2651338 | 2651338 | 2022-09-24 | US | Louisiana | West Feliciana | 22125 | 3094 | 48 | 0 | 30.87882871 | -91.4148538 | 2022-09-25 04:23:31 | West Feliciana, Louisiana, US | |
385778 | 385778 | 2022-09-23 | US | Louisiana | West Feliciana | 22125 | 3094 | 48 | 0 | 30.87882871 | -91.4148538 | 2022-09-24 04:21:40 | West Feliciana, Louisiana, US | |
1625844 | 1625844 | 2022-09-22 | US | Louisiana | West Feliciana | 22125 | 3094 | 48 | 0 | 30.87882871 | -91.4148538 | 2022-09-23 04:23:13 | West Feliciana, Louisiana, US | |
1372048 | 1372048 | 2022-09-21 | US | Louisiana | West Feliciana | 22125 | 3094 | 48 | 0 | 30.87882871 | -91.4148538 | 2022-09-22 04:22:56 | West Feliciana, Louisiana, US | |
2018278 | 2018278 | 2022-09-20 | US | Louisiana | West Feliciana | 22125 | 3094 | 48 | 0 | 30.87882871 | -91.4148538 | 2022-09-21 04:23:22 | West Feliciana, Louisiana, US | |
3572151 | 3572151 | 2022-09-19 | US | Louisiana | West Feliciana | 22125 | 3094 | 48 | 0 | 30.87882871 | -91.4148538 | 2022-09-20 04:22:48 | West Feliciana, Louisiana, US | |
375536 | 375536 | 2022-09-13 | US | Virginia | Falls Church | 51610 | 3094 | 18 | 0 | 38.88485255 | -77.17560759 | 2022-09-14 04:20:44 | Falls Church, Virginia, US | |
1251920 | 1251920 | 2022-08-23 | US | Iowa | Appanoose | 19007 | 3094 | 70 | 0 | 40.74324454 | -92.86865906 | 2022-08-24 04:20:46 | Appanoose, Iowa, US | |
2854024 | 2854024 | 2022-08-22 | US | Iowa | Appanoose | 19007 | 3094 | 70 | 0 | 40.74324454 | -92.86865906 | 2022-08-23 04:20:56 | Appanoose, Iowa, US | |
2403996 | 2403996 | 2022-08-21 | US | Iowa | Appanoose | 19007 | 3094 | 70 | 0 | 40.74324454 | -92.86865906 | 2022-08-22 04:20:38 | Appanoose, Iowa, US | |
3799074 | 3799074 | 2022-08-20 | US | Iowa | Appanoose | 19007 | 3094 | 70 | 0 | 40.74324454 | -92.86865906 | 2022-08-21 04:20:44 | Appanoose, Iowa, US | |
2364660 | 2364660 | 2022-08-19 | US | Iowa | Appanoose | 19007 | 3094 | 70 | 0 | 40.74324454 | -92.86865906 | 2022-08-20 04:21:01 | Appanoose, Iowa, US | |
1162331 | 1162331 | 2022-08-18 | US | Iowa | Appanoose | 19007 | 3094 | 70 | 0 | 40.74324454 | -92.86865906 | 2022-08-19 04:20:54 | Appanoose, Iowa, US | |
3951655 | 3951655 | 2022-08-17 | US | Iowa | Appanoose | 19007 | 3094 | 70 | 0 | 40.74324454 | -92.86865906 | 2022-08-18 04:21:11 | Appanoose, Iowa, US | |
3908505 | 3908505 | 2022-08-11 | US | Arkansas | Lee | 5077 | 3094 | 62 | 0 | 34.78498904 | -90.78383866 | 2022-08-12 04:20:54 | Lee, Arkansas, US | |
3620279 | 3620279 | 2022-08-01 | US | Texas | Pecos | 48371 | 3094 | 71 | 0 | 30.78097267 | -102.7241261 | 2022-08-02 04:20:53 | Pecos, Texas, US | |
2595053 | 2595053 | 2022-07-25 | US | Illinois | Marshall | 17123 | 3094 | 31 | 0 | 41.0327901 | -89.34510444 | 2022-07-26 04:20:58 | Marshall, Illinois, US | |
3211951 | 3211951 | 2022-07-18 | US | Michigan | Missaukee | 26113 | 3094 | 63 | 0 | 44.33772443 | -85.09256478 | 2022-07-19 04:20:58 | Missaukee, Michigan, US | |
3407126 | 3407126 | 2022-07-17 | US | Michigan | Missaukee | 26113 | 3094 | 63 | 0 | 44.33772443 | -85.09256478 | 2022-07-18 04:20:59 | Missaukee, Michigan, US | |
2153326 | 2153326 | 2022-07-16 | US | Michigan | Missaukee | 26113 | 3094 | 63 | 0 | 44.33772443 | -85.09256478 | 2022-07-17 04:21:15 | Missaukee, Michigan, US | |
2420559 | 2420559 | 2022-07-15 | US | Michigan | Missaukee | 26113 | 3094 | 63 | 0 | 44.33772443 | -85.09256478 | 2022-07-16 04:21:05 | Missaukee, Michigan, US | |
3430634 | 3430634 | 2022-07-14 | US | Michigan | Missaukee | 26113 | 3094 | 63 | 0 | 44.33772443 | -85.09256478 | 2022-07-15 04:20:53 | Missaukee, Michigan, US | |
3111154 | 3111154 | 2022-07-13 | US | Michigan | Missaukee | 26113 | 3094 | 63 | 0 | 44.33772443 | -85.09256478 | 2022-07-14 04:20:57 | Missaukee, Michigan, US | |
631577 | 631577 | 2022-07-12 | US | Michigan | Missaukee | 26113 | 3094 | 63 | 0 | 44.33772443 | -85.09256478 | 2022-07-13 04:20:58 | Missaukee, Michigan, US | |
2743646 | 2743646 | 2022-07-07 | US | Oregon | Morrow | 41049 | 3094 | 34 | 0 | 45.41846568 | -119.584546 | 2022-07-08 04:20:56 | Morrow, Oregon, US | |
3967322 | 3967322 | 2022-07-05 | US | Georgia | Charlton | 13049 | 3094 | 62 | 0 | 30.78371028 | -82.13951596 | 2022-07-06 04:20:58 | Charlton, Georgia, US | |
3078833 | 3078833 | 2022-07-04 | US | Georgia | Charlton | 13049 | 3094 | 62 | 0 | 30.78371028 | -82.13951596 | 2022-07-05 04:20:45 | Charlton, Georgia, US | |
1768115 | 1768115 | 2022-07-03 | US | Georgia | Charlton | 13049 | 3094 | 62 | 0 | 30.78371028 | -82.13951596 | 2022-07-04 04:20:54 | Charlton, Georgia, US | |
3366101 | 3366101 | 2022-07-02 | US | Georgia | Charlton | 13049 | 3094 | 62 | 0 | 30.78371028 | -82.13951596 | 2022-07-03 04:20:59 | Charlton, Georgia, US | |
594430 | 594430 | 2022-07-01 | US | Georgia | Charlton | 13049 | 3094 | 62 | 0 | 30.78371028 | -82.13951596 | 2022-07-02 04:21:16 | Charlton, Georgia, US | |
3940528 | 3940528 | 2022-06-30 | US | Arkansas | Bradley | 5011 | 3094 | 52 | 0 | 33.46755808 | -92.15980837 | 2022-07-01 04:21:10 | Bradley, Arkansas, US | |
3940831 | 3940831 | 2022-06-30 | US | Georgia | Charlton | 13049 | 3094 | 62 | 0 | 30.78371028 | -82.13951596 | 2022-07-01 04:21:10 | Charlton, Georgia, US | |
2490789 | 2490789 | 2022-06-29 | US | Georgia | Charlton | 13049 | 3094 | 62 | 0 | 30.78371028 | -82.13951596 | 2022-06-30 04:21:01 | Charlton, Georgia, US | |
2240053 | 2240053 | 2022-06-28 | US | Colorado | Rio Grande | 8105 | 3094 | 46 | 0 | 37.5836865 | -106.3847838 | 2022-06-29 04:20:59 | Rio Grande, Colorado, US | |
475926 | 475926 | 2022-06-26 | US | Arkansas | Desha | 5041 | 3094 | 41 | 0 | 33.83011025 | -91.25500948 | 2022-06-27 04:21:00 | Desha, Arkansas, US | |
478631 | 478631 | 2022-06-26 | US | Texas | Nolan | 48353 | 3094 | 99 | 0 | 32.30365282 | -100.4060208 | 2022-06-27 04:21:00 | Nolan, Texas, US | |
939301 | 939301 | 2022-06-25 | US | Arkansas | Desha | 5041 | 3094 | 41 | 0 | 33.83011025 | -91.25500948 | 2022-06-26 04:21:02 | Desha, Arkansas, US | |
942006 | 942006 | 2022-06-25 | US | Texas | Nolan | 48353 | 3094 | 99 | 0 | 32.30365282 | -100.4060208 | 2022-06-26 04:21:02 | Nolan, Texas, US | |
1765168 | 1765168 | 2022-06-20 | US | Mississippi | Perry | 28111 | 3094 | 64 | 0 | 31.17161885 | -88.99281835 | 2022-06-21 04:20:56 | Perry, Mississippi, US | |
3271354 | 3271354 | 2022-06-19 | US | Mississippi | Perry | 28111 | 3094 | 64 | 0 | 31.17161885 | -88.99281835 | 2022-06-20 04:21:01 | Perry, Mississippi, US | |
3399266 | 3399266 | 2022-06-18 | US | Mississippi | Perry | 28111 | 3094 | 64 | 0 | 31.17161885 | -88.99281835 | 2022-06-19 04:20:51 | Perry, Mississippi, US | |
2313143 | 2313143 | 2022-06-17 | US | Mississippi | Perry | 28111 | 3094 | 64 | 0 | 31.17161885 | -88.99281835 | 2022-06-18 04:21:10 | Perry, Mississippi, US | |
560647 | 560647 | 2022-06-16 | US | Mississippi | Perry | 28111 | 3094 | 64 | 0 | 31.17161885 | -88.99281835 | 2022-06-17 04:20:56 | Perry, Mississippi, US | |
3984449 | 3984449 | 2022-06-15 | US | Mississippi | Perry | 28111 | 3094 | 64 | 0 | 31.17161885 | -88.99281835 | 2022-06-16 04:20:55 | Perry, Mississippi, US | |
948690 | 948690 | 2022-06-14 | US | Mississippi | Perry | 28111 | 3094 | 64 | 0 | 31.17161885 | -88.99281835 | 2022-06-15 04:20:54 | Perry, Mississippi, US | |
2981098 | 2981098 | 2022-06-13 | US | Mississippi | Perry | 28111 | 3094 | 64 | 0 | 31.17161885 | -88.99281835 | 2022-06-14 04:20:52 | Perry, Mississippi, US | |
2236031 | 2236031 | 2022-06-12 | US | Colorado | Park | 8093 | 3094 | 21 | 0 | 39.120926 | -105.7182065 | 2022-06-13 04:21:14 | Park, Colorado, US | |
3000437 | 3000437 | 2022-05-24 | US | Indiana | Pulaski | 18131 | 3094 | 86 | 0 | 41.04166107 | -86.69890683 | 2022-05-25 04:20:56 | Pulaski, Indiana, US | |
3594158 | 3594158 | 2022-05-23 | US | Indiana | Pulaski | 18131 | 3094 | 86 | 0 | 41.04166107 | -86.69890683 | 2022-05-24 04:20:57 | Pulaski, Indiana, US | |
2334148 | 2334148 | 2022-05-08 | US | Puerto Rico | Orocovis | 72107 | 3094 | 0 | 0 | 18.215046 | -66.433604 | 2022-05-09 04:20:54 | Orocovis, Puerto Rico, US | |
363110 | 363110 | 2022-05-07 | US | Puerto Rico | Orocovis | 72107 | 3094 | 0 | 0 | 18.215046 | -66.433604 | 2022-05-08 04:20:49 | Orocovis, Puerto Rico, US | |
1573844 | 1573844 | 2022-05-03 | US | Minnesota | Chippewa | 27023 | 3094 | 48 | 0 | 45.02343421 | -95.56403693 | 2022-05-04 04:20:59 | Chippewa, Minnesota, US | |
2309858 | 2309858 | 2022-04-20 | US | Oklahoma | Love | 40085 | 3094 | 39 | 0 | 33.95273467 | -97.23906784 | 2022-04-21 04:20:46 | Love, Oklahoma, US | |
2253997 | 2253997 | 2022-04-19 | US | Oklahoma | Love | 40085 | 3094 | 39 | 0 | 33.95273467 | -97.23906784 | 2022-04-20 04:20:45 | Love, Oklahoma, US | |
1848547 | 1848547 | 2022-04-18 | US | Oklahoma | Love | 40085 | 3094 | 39 | 0 | 33.95273467 | -97.23906784 | 2022-04-19 04:21:00 | Love, Oklahoma, US | |
3419491 | 3419491 | 2022-04-17 | US | Oklahoma | Love | 40085 | 3094 | 39 | 0 | 33.95273467 | -97.23906784 | 2022-04-18 04:21:12 | Love, Oklahoma, US | |
306440 | 306440 | 2022-04-16 | US | Oklahoma | Love | 40085 | 3094 | 39 | 0 | 33.95273467 | -97.23906784 | 2022-04-17 04:20:59 | Love, Oklahoma, US | |
2672385 | 2672385 | 2022-04-15 | US | Oklahoma | Love | 40085 | 3094 | 39 | 0 | 33.95273467 | -97.23906784 | 2022-04-16 04:20:48 | Love, Oklahoma, US | |
1226170 | 1226170 | 2022-04-14 | US | Oklahoma | Love | 40085 | 3094 | 39 | 0 | 33.95273467 | -97.23906784 | 2022-04-15 04:20:57 | Love, Oklahoma, US | |
1993729 | 1993729 | 2022-03-01 | US | Indiana | Blackford | 18009 | 3094 | 64 | 0 | 40.47388153 | -85.32499702 | 2022-03-02 04:21:07 | Blackford, Indiana, US | |
2733812 | 2733812 | 2022-02-27 | US | Georgia | Dade | 13083 | 3094 | 28 | 0 | 34.854916700000004 | -85.50490424 | 2022-02-28 04:21:05 | Dade, Georgia, US | |
3046965 | 3046965 | 2022-02-26 | US | Georgia | Dade | 13083 | 3094 | 28 | 0 | 34.854916700000004 | -85.50490424 | 2022-02-27 04:21:04 | Dade, Georgia, US | |
575620 | 575620 | 2022-02-25 | US | Georgia | Dade | 13083 | 3094 | 28 | 0 | 34.854916700000004 | -85.50490424 | 2022-02-26 04:21:12 | Dade, Georgia, US | |
2447598 | 2447598 | 2022-02-22 | US | Georgia | Jasper | 13159 | 3094 | 68 | 0 | 33.31535543 | -83.68844964 | 2022-02-23 04:21:09 | Jasper, Georgia, US | |
1364296 | 1364296 | 2022-02-08 | US | Missouri | Osage | 29151 | 3094 | 39 | 0 | 38.46036182 | -91.8613635 | 2022-02-09 04:21:04 | Osage, Missouri, US | |
462956 | 462956 | 2022-02-02 | US | Wisconsin | Price | 55099 | 3094 | 28 | 0 | 45.68051754 | -90.36098879999999 | 2022-02-03 04:21:21 | Price, Wisconsin, US | |
980585 | 980585 | 2022-02-01 | US | Michigan | Gogebic | 26053 | 3094 | 64 | 0 | 46.40862701 | -89.69377193 | 2022-02-02 04:21:09 | Gogebic, Michigan, US | |
981449 | 981449 | 2022-02-01 | US | Ohio | Noble | 39121 | 3094 | 55 | 0 | 39.76818851 | -81.45937183 | 2022-02-02 04:21:09 | Noble, Ohio, US | |
2659427 | 2659427 | 2022-01-31 | US | Michigan | Gogebic | 26053 | 3094 | 64 | 0 | 46.40862701 | -89.69377193 | 2022-02-01 04:21:11 | Gogebic, 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]);