johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
177 rows where confirmed = 5207 and country_or_region = "US" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Florida 14
- Oklahoma 14
- Texas 12
- Virginia 11
- Kentucky 10
- North Carolina 10
- Wisconsin 9
- Mississippi 8
- Ohio 8
- Tennessee 8
- Georgia 7
- Idaho 7
- Illinois 7
- Indiana 7
- Kansas 7
- Nebraska 7
- Arkansas 5
- New Mexico 4
- Alabama 3
- New York 3
- Puerto Rico 3
- Louisiana 2
- West Virginia 2
- Colorado 1
- Hawaii 1
- Maryland 1
- Minnesota 1
- Missouri 1
- North Dakota 1
- Pennsylvania 1
- …
country_or_region 1
- US · 177 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755199 | 2755199 | 2022-12-29 | US | North Carolina | Bertie | 37015 | 5207 | 77 | 0 | 36.0688473 | -76.96545943 | 2022-12-30 04:21:04 | Bertie, North Carolina, US | |
1076205 | 1076205 | 2022-12-28 | US | North Carolina | Bertie | 37015 | 5207 | 77 | 0 | 36.0688473 | -76.96545943 | 2022-12-29 04:21:01 | Bertie, North Carolina, US | |
330202 | 330202 | 2022-12-27 | US | North Carolina | Bertie | 37015 | 5207 | 77 | 0 | 36.0688473 | -76.96545943 | 2022-12-28 04:21:04 | Bertie, North Carolina, US | |
220275 | 220275 | 2022-12-26 | US | North Carolina | Bertie | 37015 | 5207 | 77 | 0 | 36.0688473 | -76.96545943 | 2022-12-27 04:21:07 | Bertie, North Carolina, US | |
3224732 | 3224732 | 2022-12-25 | US | North Carolina | Bertie | 37015 | 5207 | 77 | 0 | 36.0688473 | -76.96545943 | 2022-12-26 04:21:06 | Bertie, North Carolina, US | |
1020646 | 1020646 | 2022-12-24 | US | North Carolina | Bertie | 37015 | 5207 | 77 | 0 | 36.0688473 | -76.96545943 | 2022-12-25 04:21:04 | Bertie, North Carolina, US | |
692669 | 692669 | 2022-12-23 | US | North Carolina | Bertie | 37015 | 5207 | 77 | 0 | 36.0688473 | -76.96545943 | 2022-12-24 04:21:02 | Bertie, North Carolina, US | |
2181879 | 2181879 | 2022-12-22 | US | North Carolina | Bertie | 37015 | 5207 | 77 | 0 | 36.0688473 | -76.96545943 | 2022-12-23 04:21:04 | Bertie, North Carolina, US | |
453683 | 453683 | 2022-12-21 | US | North Carolina | Bertie | 37015 | 5207 | 77 | 0 | 36.0688473 | -76.96545943 | 2022-12-22 04:20:56 | Bertie, North Carolina, US | |
3029212 | 3029212 | 2022-11-17 | US | Tennessee | Bledsoe | 47007 | 5207 | 62 | 0 | 35.59942968 | -85.20611967 | 2022-11-18 04:21:15 | Bledsoe, Tennessee, US | |
711718 | 711718 | 2022-11-01 | US | Kansas | Bourbon | 20011 | 5207 | 63 | 0 | 37.85508555 | -94.84865997 | 2022-11-02 04:22:09 | Bourbon, Kansas, US | |
713554 | 713554 | 2022-11-01 | US | Texas | Gonzales | 48177 | 5207 | 106 | 0 | 29.45634206 | -97.49424032 | 2022-11-02 04:22:09 | Gonzales, Texas, US | |
3286167 | 3286167 | 2022-10-31 | US | Kansas | Bourbon | 20011 | 5207 | 63 | 0 | 37.85508555 | -94.84865997 | 2022-11-01 04:22:36 | Bourbon, Kansas, US | |
3288003 | 3288003 | 2022-10-31 | US | Texas | Gonzales | 48177 | 5207 | 106 | 0 | 29.45634206 | -97.49424032 | 2022-11-01 04:22:36 | Gonzales, Texas, US | |
321200 | 321200 | 2022-10-30 | US | Kansas | Bourbon | 20011 | 5207 | 63 | 0 | 37.85508555 | -94.84865997 | 2022-10-31 04:21:36 | Bourbon, Kansas, US | |
913476 | 913476 | 2022-10-29 | US | Kansas | Bourbon | 20011 | 5207 | 63 | 0 | 37.85508555 | -94.84865997 | 2022-10-30 04:22:14 | Bourbon, Kansas, US | |
1367745 | 1367745 | 2022-10-28 | US | Kansas | Bourbon | 20011 | 5207 | 63 | 0 | 37.85508555 | -94.84865997 | 2022-10-29 04:21:13 | Bourbon, Kansas, US | |
3039600 | 3039600 | 2022-10-27 | US | Kansas | Bourbon | 20011 | 5207 | 63 | 0 | 37.85508555 | -94.84865997 | 2022-10-28 04:22:31 | Bourbon, Kansas, US | |
540020 | 540020 | 2022-10-26 | US | Kansas | Bourbon | 20011 | 5207 | 63 | 0 | 37.85508555 | -94.84865997 | 2022-10-27 04:22:01 | Bourbon, Kansas, US | |
2760309 | 2760309 | 2022-10-18 | US | Virginia | Nottoway | 51135 | 5207 | 100 | 0 | 37.1435975 | -78.05065922 | 2022-10-19 04:22:26 | Nottoway, Virginia, US | |
1373414 | 1373414 | 2022-09-21 | US | Tennessee | Benton | 47005 | 5207 | 99 | 0 | 36.07110411 | -88.06849355 | 2022-09-22 04:22:56 | Benton, Tennessee, US | |
2634694 | 2634694 | 2022-09-05 | US | Illinois | Cass | 17017 | 5207 | 35 | 0 | 39.96991073 | -90.24734436 | 2022-09-06 04:21:02 | Cass, Illinois, US | |
2988258 | 2988258 | 2022-09-04 | US | Illinois | Cass | 17017 | 5207 | 35 | 0 | 39.96991073 | -90.24734436 | 2022-09-05 04:21:01 | Cass, Illinois, US | |
2713943 | 2713943 | 2022-09-03 | US | Illinois | Cass | 17017 | 5207 | 35 | 0 | 39.96991073 | -90.24734436 | 2022-09-04 04:21:22 | Cass, Illinois, US | |
1394648 | 1394648 | 2022-09-02 | US | Illinois | Cass | 17017 | 5207 | 35 | 0 | 39.96991073 | -90.24734436 | 2022-09-03 04:21:04 | Cass, Illinois, US | |
2829515 | 2829515 | 2022-08-25 | US | Florida | Gilchrist | 12041 | 5207 | 104 | 0 | 29.72856978 | -82.79880657 | 2022-08-26 04:21:02 | Gilchrist, Florida, US | |
2324048 | 2324048 | 2022-08-24 | US | Florida | Gilchrist | 12041 | 5207 | 104 | 0 | 29.72856978 | -82.79880657 | 2022-08-25 04:21:13 | Gilchrist, Florida, US | |
1251457 | 1251457 | 2022-08-23 | US | Florida | Gilchrist | 12041 | 5207 | 104 | 0 | 29.72856978 | -82.79880657 | 2022-08-24 04:20:46 | Gilchrist, Florida, US | |
2853561 | 2853561 | 2022-08-22 | US | Florida | Gilchrist | 12041 | 5207 | 104 | 0 | 29.72856978 | -82.79880657 | 2022-08-23 04:20:56 | Gilchrist, Florida, US | |
2403363 | 2403363 | 2022-08-21 | US | Arkansas | Sharp | 5135 | 5207 | 113 | 0 | 36.16258158 | -91.47819342 | 2022-08-22 04:20:38 | Sharp, Arkansas, US | |
2403533 | 2403533 | 2022-08-21 | US | Florida | Gilchrist | 12041 | 5207 | 104 | 0 | 29.72856978 | -82.79880657 | 2022-08-22 04:20:38 | Gilchrist, Florida, US | |
3798441 | 3798441 | 2022-08-20 | US | Arkansas | Sharp | 5135 | 5207 | 113 | 0 | 36.16258158 | -91.47819342 | 2022-08-21 04:20:44 | Sharp, Arkansas, US | |
3798611 | 3798611 | 2022-08-20 | US | Florida | Gilchrist | 12041 | 5207 | 104 | 0 | 29.72856978 | -82.79880657 | 2022-08-21 04:20:44 | Gilchrist, Florida, US | |
2364197 | 2364197 | 2022-08-19 | US | Florida | Gilchrist | 12041 | 5207 | 104 | 0 | 29.72856978 | -82.79880657 | 2022-08-20 04:21:01 | Gilchrist, Florida, US | |
1161868 | 1161868 | 2022-08-18 | US | Florida | Gilchrist | 12041 | 5207 | 104 | 0 | 29.72856978 | -82.79880657 | 2022-08-19 04:20:54 | Gilchrist, Florida, US | |
3951192 | 3951192 | 2022-08-17 | US | Florida | Gilchrist | 12041 | 5207 | 104 | 0 | 29.72856978 | -82.79880657 | 2022-08-18 04:21:11 | Gilchrist, Florida, US | |
991694 | 991694 | 2022-08-16 | US | Florida | Gilchrist | 12041 | 5207 | 104 | 0 | 29.72856978 | -82.79880657 | 2022-08-17 04:20:59 | Gilchrist, Florida, US | |
2494733 | 2494733 | 2022-08-15 | US | Florida | Gilchrist | 12041 | 5207 | 104 | 0 | 29.72856978 | -82.79880657 | 2022-08-16 04:20:58 | Gilchrist, Florida, US | |
3648283 | 3648283 | 2022-08-14 | US | Florida | Gilchrist | 12041 | 5207 | 104 | 0 | 29.72856978 | -82.79880657 | 2022-08-15 04:20:59 | Gilchrist, Florida, US | |
3651111 | 3651111 | 2022-08-14 | US | Wisconsin | Adams | 55001 | 5207 | 64 | 0 | 43.96974651 | -89.76782777 | 2022-08-15 04:20:59 | Adams, Wisconsin, US | |
1969289 | 1969289 | 2022-08-13 | US | Florida | Gilchrist | 12041 | 5207 | 104 | 0 | 29.72856978 | -82.79880657 | 2022-08-14 04:20:55 | Gilchrist, Florida, US | |
1972117 | 1972117 | 2022-08-13 | US | Wisconsin | Adams | 55001 | 5207 | 64 | 0 | 43.96974651 | -89.76782777 | 2022-08-14 04:20:55 | Adams, Wisconsin, US | |
2891926 | 2891926 | 2022-08-12 | US | Wisconsin | Adams | 55001 | 5207 | 64 | 0 | 43.96974651 | -89.76782777 | 2022-08-13 04:20:52 | Adams, Wisconsin, US | |
3911531 | 3911531 | 2022-08-11 | US | Wisconsin | Adams | 55001 | 5207 | 64 | 0 | 43.96974651 | -89.76782777 | 2022-08-12 04:20:54 | Adams, Wisconsin, US | |
1070984 | 1070984 | 2022-08-07 | US | Indiana | Fulton | 18049 | 5207 | 106 | 0 | 41.0469907 | -86.26252745 | 2022-08-08 04:21:08 | Fulton, Indiana, US | |
1941572 | 1941572 | 2022-08-06 | US | Indiana | Fulton | 18049 | 5207 | 106 | 0 | 41.0469907 | -86.26252745 | 2022-08-07 04:20:54 | Fulton, Indiana, US | |
881371 | 881371 | 2022-08-05 | US | Indiana | Fulton | 18049 | 5207 | 106 | 0 | 41.0469907 | -86.26252745 | 2022-08-06 04:20:56 | Fulton, Indiana, US | |
1405525 | 1405525 | 2022-08-02 | US | Arkansas | Cross | 5037 | 5207 | 88 | 0 | 35.29631396 | -90.77185818 | 2022-08-03 04:20:59 | Cross, Arkansas, US | |
1405976 | 1405976 | 2022-08-02 | US | Idaho | Cassia | 16031 | 5207 | 55 | 0 | 42.28347888 | -113.6012409 | 2022-08-03 04:20:59 | Cassia, Idaho, US | |
1408627 | 1408627 | 2022-08-02 | US | Wisconsin | Sawyer | 55113 | 5207 | 63 | 0 | 45.87931905 | -91.14504927 | 2022-08-03 04:20:59 | Sawyer, Wisconsin, US | |
3618014 | 3618014 | 2022-08-01 | US | Idaho | Cassia | 16031 | 5207 | 55 | 0 | 42.28347888 | -113.6012409 | 2022-08-02 04:20:53 | Cassia, Idaho, US | |
94099 | 94099 | 2022-07-23 | US | Tennessee | Humphreys | 47085 | 5207 | 77 | 0 | 36.03958805 | -87.77992872 | 2022-07-24 04:20:47 | Humphreys, Tennessee, US | |
673519 | 673519 | 2022-07-21 | US | Texas | Scurry | 48415 | 5207 | 104 | 0 | 32.74613808 | -100.9162664 | 2022-07-22 04:21:15 | Scurry, Texas, US | |
2791244 | 2791244 | 2022-07-10 | US | New Mexico | Roosevelt | 35041 | 5207 | 98 | 0 | 34.02097406 | -103.4799493 | 2022-07-11 04:20:46 | Roosevelt, New Mexico, US | |
144197 | 144197 | 2022-07-09 | US | New Mexico | Roosevelt | 35041 | 5207 | 98 | 0 | 34.02097406 | -103.4799493 | 2022-07-10 04:20:54 | Roosevelt, New Mexico, US | |
1419297 | 1419297 | 2022-07-08 | US | New Mexico | Roosevelt | 35041 | 5207 | 98 | 0 | 34.02097406 | -103.4799493 | 2022-07-09 04:20:59 | Roosevelt, New Mexico, US | |
1420125 | 1420125 | 2022-07-08 | US | Texas | Burleson | 48051 | 5207 | 66 | 0 | 30.49273808 | -96.62158484 | 2022-07-09 04:20:59 | Burleson, Texas, US | |
2240231 | 2240231 | 2022-06-28 | US | Georgia | Jones | 13169 | 5207 | 109 | 0 | 33.02512137 | -83.56019163 | 2022-06-29 04:20:59 | Jones, Georgia, US | |
2148473 | 2148473 | 2022-06-27 | US | Georgia | Jones | 13169 | 5207 | 109 | 0 | 33.02512137 | -83.56019163 | 2022-06-28 04:20:58 | Jones, Georgia, US | |
476274 | 476274 | 2022-06-26 | US | Georgia | Jones | 13169 | 5207 | 109 | 0 | 33.02512137 | -83.56019163 | 2022-06-27 04:21:00 | Jones, Georgia, US | |
939649 | 939649 | 2022-06-25 | US | Georgia | Jones | 13169 | 5207 | 109 | 0 | 33.02512137 | -83.56019163 | 2022-06-26 04:21:02 | Jones, Georgia, US | |
3347469 | 3347469 | 2022-06-24 | US | Georgia | Jones | 13169 | 5207 | 109 | 0 | 33.02512137 | -83.56019163 | 2022-06-25 04:20:57 | Jones, Georgia, US | |
1649210 | 1649210 | 2022-06-23 | US | Georgia | Jones | 13169 | 5207 | 109 | 0 | 33.02512137 | -83.56019163 | 2022-06-24 04:20:58 | Jones, Georgia, US | |
2188445 | 2188445 | 2022-06-22 | US | Georgia | Jones | 13169 | 5207 | 109 | 0 | 33.02512137 | -83.56019163 | 2022-06-23 04:20:55 | Jones, Georgia, US | |
974315 | 974315 | 2022-06-01 | US | Virginia | Prince Edward | 51147 | 5207 | 75 | 0 | 37.22554789 | -78.43597949 | 2022-06-02 05:20:39 | Prince Edward, Virginia, US | |
2334719 | 2334719 | 2022-05-08 | US | Virginia | Fluvanna | 51065 | 5207 | 45 | 0 | 37.84157909 | -78.27715475 | 2022-05-09 04:20:54 | Fluvanna, Virginia, US | |
363681 | 363681 | 2022-05-07 | US | Virginia | Fluvanna | 51065 | 5207 | 45 | 0 | 37.84157909 | -78.27715475 | 2022-05-08 04:20:49 | Fluvanna, Virginia, US | |
1401032 | 1401032 | 2022-05-06 | US | Virginia | Fluvanna | 51065 | 5207 | 45 | 0 | 37.84157909 | -78.27715475 | 2022-05-07 04:21:09 | Fluvanna, Virginia, US | |
2895974 | 2895974 | 2022-04-21 | US | Wisconsin | Langlade | 55067 | 5207 | 90 | 0 | 45.26271619 | -89.07483625 | 2022-04-22 04:20:45 | Langlade, Wisconsin, US | |
3419850 | 3419850 | 2022-04-17 | US | Tennessee | Crockett | 47033 | 5207 | 85 | 0 | 35.81830662 | -89.14916269 | 2022-04-18 04:21:12 | Crockett, Tennessee, US | |
306799 | 306799 | 2022-04-16 | US | Tennessee | Crockett | 47033 | 5207 | 85 | 0 | 35.81830662 | -89.14916269 | 2022-04-17 04:20:59 | Crockett, Tennessee, US | |
2672744 | 2672744 | 2022-04-15 | US | Tennessee | Crockett | 47033 | 5207 | 85 | 0 | 35.81830662 | -89.14916269 | 2022-04-16 04:20:48 | Crockett, Tennessee, US | |
1950102 | 1950102 | 2022-04-12 | US | Maryland | Somerset | 24039 | 5207 | 73 | 0 | 38.1163542 | -75.75118623 | 2022-04-13 04:21:03 | Somerset, Maryland, US | |
878129 | 878129 | 2022-03-27 | US | Mississippi | Winston | 28159 | 5207 | 104 | 0 | 33.08747908 | -89.03391385 | 2022-03-28 04:20:33 | Winston, Mississippi, US | |
2165412 | 2165412 | 2022-03-26 | US | Mississippi | Winston | 28159 | 5207 | 104 | 0 | 33.08747908 | -89.03391385 | 2022-03-27 04:20:47 | Winston, Mississippi, US | |
1722348 | 1722348 | 2022-03-25 | US | Mississippi | Winston | 28159 | 5207 | 104 | 0 | 33.08747908 | -89.03391385 | 2022-03-26 04:20:23 | Winston, Mississippi, US | |
1469965 | 1469965 | 2022-03-24 | US | Mississippi | Winston | 28159 | 5207 | 104 | 0 | 33.08747908 | -89.03391385 | 2022-03-25 04:20:46 | Winston, Mississippi, US | |
3024139 | 3024139 | 2022-03-23 | US | Mississippi | Winston | 28159 | 5207 | 104 | 0 | 33.08747908 | -89.03391385 | 2022-03-24 04:20:43 | Winston, Mississippi, US | |
1907061 | 1907061 | 2022-03-22 | US | Mississippi | Winston | 28159 | 5207 | 104 | 0 | 33.08747908 | -89.03391385 | 2022-03-23 04:20:48 | Winston, Mississippi, US | |
3240192 | 3240192 | 2022-03-21 | US | Mississippi | Winston | 28159 | 5207 | 104 | 0 | 33.08747908 | -89.03391385 | 2022-03-22 04:20:54 | Winston, Mississippi, US | |
2320777 | 2320777 | 2022-03-16 | US | Kentucky | McCreary | 21147 | 5207 | 75 | 0 | 36.73874143 | -84.48102924 | 2022-03-17 04:20:56 | McCreary, Kentucky, US | |
262977 | 262977 | 2022-03-15 | US | Kentucky | McCreary | 21147 | 5207 | 75 | 0 | 36.73874143 | -84.48102924 | 2022-03-16 04:20:50 | McCreary, Kentucky, US | |
2265336 | 2265336 | 2022-03-14 | US | Kentucky | McCreary | 21147 | 5207 | 75 | 0 | 36.73874143 | -84.48102924 | 2022-03-15 04:20:47 | McCreary, Kentucky, US | |
3629402 | 3629402 | 2022-03-13 | US | Kentucky | McCreary | 21147 | 5207 | 75 | 0 | 36.73874143 | -84.48102924 | 2022-03-14 04:20:46 | McCreary, Kentucky, US | |
952310 | 952310 | 2022-03-12 | US | Kentucky | McCreary | 21147 | 5207 | 75 | 0 | 36.73874143 | -84.48102924 | 2022-03-13 04:20:49 | McCreary, Kentucky, US | |
357771 | 357771 | 2022-03-11 | US | Kentucky | McCreary | 21147 | 5207 | 75 | 0 | 36.73874143 | -84.48102924 | 2022-03-12 04:20:50 | McCreary, Kentucky, US | |
1866923 | 1866923 | 2022-03-10 | US | Kentucky | McCreary | 21147 | 5207 | 75 | 0 | 36.73874143 | -84.48102924 | 2022-03-11 04:20:50 | McCreary, Kentucky, US | |
2200778 | 2200778 | 2022-03-06 | US | Indiana | Spencer | 18147 | 5207 | 58 | 0 | 38.01519732 | -87.0079644 | 2022-03-07 04:20:47 | Spencer, Indiana, US | |
2093235 | 2093235 | 2022-03-05 | US | Indiana | Spencer | 18147 | 5207 | 58 | 0 | 38.01519732 | -87.0079644 | 2022-03-06 04:20:49 | Spencer, Indiana, US | |
2666935 | 2666935 | 2022-03-04 | US | Indiana | Spencer | 18147 | 5207 | 58 | 0 | 38.01519732 | -87.0079644 | 2022-03-05 04:21:10 | Spencer, Indiana, US | |
3048911 | 3048911 | 2022-02-26 | US | Puerto Rico | Cidra | 72041 | 5207 | 0 | 0 | 18.173559 | -66.161179 | 2022-02-27 04:21:04 | Cidra, Puerto Rico, US | |
2447248 | 2447248 | 2022-02-22 | US | Arkansas | Columbia | 5027 | 5207 | 81 | 0 | 33.21230701 | -93.22642793 | 2022-02-23 04:21:09 | Columbia, Arkansas, US | |
3719108 | 3719108 | 2022-02-21 | US | Idaho | Blaine | 16013 | 5207 | 30 | 0 | 43.4085812 | -113.9752658 | 2022-02-22 04:21:01 | Blaine, Idaho, US | |
3912942 | 3912942 | 2022-02-20 | US | Idaho | Blaine | 16013 | 5207 | 30 | 0 | 43.4085812 | -113.9752658 | 2022-02-21 04:21:05 | Blaine, Idaho, US | |
3915443 | 3915443 | 2022-02-20 | US | Virginia | Waynesboro | 51820 | 5207 | 59 | 0 | 38.06451466 | -78.90293905 | 2022-02-21 04:21:05 | Waynesboro, Virginia, US | |
3876500 | 3876500 | 2022-02-19 | US | Idaho | Blaine | 16013 | 5207 | 30 | 0 | 43.4085812 | -113.9752658 | 2022-02-20 04:21:00 | Blaine, Idaho, US | |
3879001 | 3879001 | 2022-02-19 | US | Virginia | Waynesboro | 51820 | 5207 | 59 | 0 | 38.06451466 | -78.90293905 | 2022-02-20 04:21:00 | Waynesboro, Virginia, US | |
3859257 | 3859257 | 2022-02-18 | US | Virginia | Waynesboro | 51820 | 5207 | 59 | 0 | 38.06451466 | -78.90293905 | 2022-02-19 04:21:11 | Waynesboro, Virginia, US | |
1299111 | 1299111 | 2022-02-17 | US | Illinois | Wayne | 17191 | 5207 | 78 | 0 | 38.42955355 | -88.42586459 | 2022-02-18 04:21:04 | Wayne, Illinois, US | |
2644203 | 2644203 | 2022-02-14 | US | Ohio | Carroll | 39019 | 5207 | 126 | 0 | 40.578968599999996 | -81.09178213 | 2022-02-15 04:21:09 | Carroll, Ohio, 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]);