johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
11,145 rows where province_or_state = "New Hampshire" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: admin2, longitude, combined_key, day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths ▼ | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10473 | 10473 | 2020-10-25 | US | New Hampshire | Coos | 33007 | 39 | 0 | 0 | 39 | 44.69063265 | -71.30633239 | 2020-10-26 04:25:02 | Coos, New Hampshire, US |
10480 | 10480 | 2020-10-25 | US | New Hampshire | Unassigned | 90033 | 18 | 0 | 0 | 18 | 44.69063265 | 0.0 | 2020-10-26 04:25:02 | Unassigned, New Hampshire, US |
40487 | 40487 | 2020-04-13 | US | New Hampshire | Belknap | 33001 | 22 | 0 | 0 | 22 | 43.51637314 | -71.41684235 | 2020-04-13 23:07:54 | Belknap, New Hampshire, US |
40686 | 40686 | 2020-04-13 | US | New Hampshire | Carroll | 33003 | 28 | 0 | 0 | 28 | 43.87498583 | -71.20430216 | 2020-04-13 23:07:54 | Carroll, New Hampshire, US |
40757 | 40757 | 2020-04-13 | US | New Hampshire | Cheshire | 33005 | 19 | 0 | 0 | 19 | 42.92015988 | -72.25311043 | 2020-04-13 23:07:54 | Cheshire, New Hampshire, US |
40887 | 40887 | 2020-04-13 | US | New Hampshire | Coos | 33007 | 2 | 0 | 0 | 2 | 44.69063265 | -71.30633239 | 2020-04-13 23:07:54 | Coos, New Hampshire, US |
41255 | 41255 | 2020-04-13 | US | New Hampshire | Grafton | 33009 | 45 | 0 | 0 | 45 | 43.93779815 | -71.82057197 | 2020-04-13 23:07:54 | Grafton, New Hampshire, US |
41965 | 41965 | 2020-04-13 | US | New Hampshire | Merrimack | 33013 | 73 | 0 | 0 | 73 | 43.29662971 | -71.6811573 | 2020-04-13 23:07:54 | Merrimack, New Hampshire, US |
42655 | 42655 | 2020-04-13 | US | New Hampshire | Strafford | 33017 | 59 | 0 | 0 | 59 | 43.291833000000004 | -71.02336013 | 2020-04-13 23:07:54 | Strafford, New Hampshire, US |
42662 | 42662 | 2020-04-13 | US | New Hampshire | Sullivan | 33019 | 6 | 0 | 0 | 6 | 43.36094111 | -72.22203125 | 2020-04-13 23:07:54 | Sullivan, New Hampshire, US |
47547 | 47547 | 2020-04-17 | US | New Hampshire | Belknap | 33001 | 25 | 0 | 0 | 25 | 43.51637314 | -71.41684235 | 2020-04-17 23:30:52 | Belknap, New Hampshire, US |
47745 | 47745 | 2020-04-17 | US | New Hampshire | Carroll | 33003 | 32 | 0 | 0 | 32 | 43.87498583 | -71.20430216 | 2020-04-17 23:30:52 | Carroll, New Hampshire, US |
47818 | 47818 | 2020-04-17 | US | New Hampshire | Cheshire | 33005 | 27 | 0 | 0 | 27 | 42.92015988 | -72.25311043 | 2020-04-17 23:30:52 | Cheshire, New Hampshire, US |
47950 | 47950 | 2020-04-17 | US | New Hampshire | Coos | 33007 | 2 | 0 | 0 | 2 | 44.69063265 | -71.30633239 | 2020-04-17 23:30:52 | Coos, New Hampshire, US |
48320 | 48320 | 2020-04-17 | US | New Hampshire | Grafton | 33009 | 44 | 0 | 0 | 44 | 43.93779815 | -71.82057197 | 2020-04-17 23:30:52 | Grafton, New Hampshire, US |
49039 | 49039 | 2020-04-17 | US | New Hampshire | Merrimack | 33013 | 88 | 0 | 0 | 88 | 43.29662971 | -71.6811573 | 2020-04-17 23:30:52 | Merrimack, New Hampshire, US |
49747 | 49747 | 2020-04-17 | US | New Hampshire | Strafford | 33017 | 84 | 0 | 0 | 84 | 43.291833000000004 | -71.02336013 | 2020-04-17 23:30:52 | Strafford, New Hampshire, US |
49754 | 49754 | 2020-04-17 | US | New Hampshire | Sullivan | 33019 | 9 | 0 | 0 | 9 | 43.36094111 | -72.22203125 | 2020-04-17 23:30:52 | Sullivan, New Hampshire, US |
59155 | 59155 | 2020-07-23 | US | New Hampshire | Coos | 33007 | 14 | 0 | 0 | 14 | 44.69063265 | -71.30633239 | 2020-07-24 05:30:40 | Coos, New Hampshire, US |
61423 | 61423 | 2020-07-23 | US | New Hampshire | Unassigned | 90033 | 0 | 0 | 0 | 0 | 44.69063265 | 0.0 | 2020-07-24 05:30:40 | Unassigned, New Hampshire, US |
81227 | 81227 | 2020-10-14 | US | New Hampshire | Coos | 33007 | 23 | 0 | 0 | 23 | 44.69063265 | -71.30633239 | 2020-10-15 04:24:28 | Coos, New Hampshire, US |
81234 | 81234 | 2020-10-14 | US | New Hampshire | Unassigned | 90033 | 8 | 0 | 0 | 8 | 44.69063265 | 0.0 | 2020-10-15 04:24:28 | Unassigned, New Hampshire, US |
95477 | 95477 | 2020-08-04 | US | New Hampshire | Coos | 33007 | 16 | 0 | 0 | 16 | 44.69063265 | -71.30633239 | 2020-08-05 04:34:43 | Coos, New Hampshire, US |
97752 | 97752 | 2020-08-04 | US | New Hampshire | Unassigned | 90033 | 4 | 0 | 0 | 4 | 44.69063265 | 0.0 | 2020-08-05 04:34:43 | Unassigned, New Hampshire, US |
111309 | 111309 | 2020-05-08 | US | New Hampshire | Belknap | 33001 | 42 | 0 | 0 | 42 | 43.51637314 | -71.41684235 | 2020-05-09 02:32:35 | Belknap, New Hampshire, US |
111520 | 111520 | 2020-05-08 | US | New Hampshire | Carroll | 33003 | 36 | 0 | 0 | 36 | 43.87498583 | -71.20430216 | 2020-05-09 02:32:35 | Carroll, New Hampshire, US |
111742 | 111742 | 2020-05-08 | US | New Hampshire | Coos | 33007 | 2 | 0 | 0 | 2 | 44.69063265 | -71.30633239 | 2020-05-09 02:32:35 | Coos, New Hampshire, US |
118848 | 118848 | 2020-07-19 | US | New Hampshire | Carroll | 33003 | 71 | 0 | 0 | 71 | 43.87498583 | -71.20430216 | 2020-07-20 05:34:40 | Carroll, New Hampshire, US |
119084 | 119084 | 2020-07-19 | US | New Hampshire | Coos | 33007 | 13 | 0 | 0 | 13 | 44.69063265 | -71.30633239 | 2020-07-20 05:34:40 | Coos, New Hampshire, US |
121347 | 121347 | 2020-07-19 | US | New Hampshire | Unassigned | 90033 | 0 | 0 | 0 | 0 | 44.69063265 | 0.0 | 2020-07-20 05:34:40 | Unassigned, New Hampshire, US |
124855 | 124855 | 2020-11-18 | US | New Hampshire | Unassigned | 90033 | 186 | 0 | 0 | 186 | 44.69063265 | 0.0 | 2020-11-19 05:25:23 | Unassigned, New Hampshire, US |
134591 | 134591 | 2020-04-29 | US | New Hampshire | Belknap | 33001 | 34 | 0 | 0 | 34 | 43.51637314 | -71.41684235 | 2020-04-30 02:32:27 | Belknap, New Hampshire, US |
134794 | 134794 | 2020-04-29 | US | New Hampshire | Carroll | 33003 | 31 | 0 | 0 | 31 | 43.87498583 | -71.20430216 | 2020-04-30 02:32:27 | Carroll, New Hampshire, US |
134871 | 134871 | 2020-04-29 | US | New Hampshire | Cheshire | 33005 | 40 | 0 | 0 | 40 | 42.92015988 | -72.25311043 | 2020-04-30 02:32:27 | Cheshire, New Hampshire, US |
135011 | 135011 | 2020-04-29 | US | New Hampshire | Coos | 33007 | 2 | 0 | 0 | 2 | 44.69063265 | -71.30633239 | 2020-04-30 02:32:27 | Coos, New Hampshire, US |
135397 | 135397 | 2020-04-29 | US | New Hampshire | Grafton | 33009 | 48 | 0 | 0 | 48 | 43.93779815 | -71.82057197 | 2020-04-30 02:32:27 | Grafton, New Hampshire, US |
136148 | 136148 | 2020-04-29 | US | New Hampshire | Merrimack | 33013 | 145 | 0 | 0 | 145 | 43.29662971 | -71.6811573 | 2020-04-30 02:32:27 | Merrimack, New Hampshire, US |
136890 | 136890 | 2020-04-29 | US | New Hampshire | Strafford | 33017 | 139 | 0 | 0 | 139 | 43.291833000000004 | -71.02336013 | 2020-04-30 02:32:27 | Strafford, New Hampshire, US |
136897 | 136897 | 2020-04-29 | US | New Hampshire | Sullivan | 33019 | 11 | 0 | 0 | 11 | 43.36094111 | -72.22203125 | 2020-04-30 02:32:27 | Sullivan, New Hampshire, US |
148105 | 148105 | 2020-08-15 | US | New Hampshire | Coos | 33007 | 17 | 0 | 0 | 17 | 44.69063265 | -71.30633239 | 2020-08-16 04:27:42 | Coos, New Hampshire, US |
148112 | 148112 | 2020-08-15 | US | New Hampshire | Unassigned | 90033 | 0 | 0 | 0 | 0 | 44.69063265 | 0.0 | 2020-08-16 04:27:42 | Unassigned, New Hampshire, US |
174394 | 174394 | 2020-07-27 | US | New Hampshire | Coos | 33007 | 16 | 0 | 0 | 16 | 44.69063265 | -71.30633239 | 2020-07-28 04:58:43 | Coos, New Hampshire, US |
176663 | 176663 | 2020-07-27 | US | New Hampshire | Unassigned | 90033 | 0 | 0 | 0 | 0 | 44.69063265 | 0.0 | 2020-07-28 04:58:43 | Unassigned, New Hampshire, US |
192220 | 192220 | 2021-01-11 | US | New Hampshire | Unassigned | 90033 | 2626 | 0 | 0 | 2626 | 44.69063265 | 0.0 | 2021-01-12 05:22:15 | Unassigned, New Hampshire, US |
196205 | 196205 | 2020-08-31 | US | New Hampshire | Coos | 33007 | 18 | 0 | 0 | 18 | 44.69063265 | -71.30633239 | 2020-09-01 04:28:31 | Coos, New Hampshire, US |
196212 | 196212 | 2020-08-31 | US | New Hampshire | Unassigned | 90033 | 2 | 0 | 0 | 2 | 44.69063265 | 0.0 | 2020-09-01 04:28:31 | Unassigned, New Hampshire, US |
204407 | 204407 | 2020-12-25 | US | New Hampshire | Unassigned | 90033 | 2542 | 0 | 0 | 2542 | 44.69063265 | 0.0 | 2020-12-26 05:22:28 | Unassigned, New Hampshire, US |
208391 | 208391 | 2020-08-19 | US | New Hampshire | Coos | 33007 | 17 | 0 | 0 | 17 | 44.69063265 | -71.30633239 | 2020-08-20 04:27:43 | Coos, New Hampshire, US |
208398 | 208398 | 2020-08-19 | US | New Hampshire | Unassigned | 90033 | 0 | 0 | 0 | 0 | 44.69063265 | 0.0 | 2020-08-20 04:27:43 | Unassigned, New Hampshire, US |
212382 | 212382 | 2020-10-29 | US | New Hampshire | Coos | 33007 | 64 | 0 | 0 | 64 | 44.69063265 | -71.30633239 | 2020-10-30 04:24:49 | Coos, New Hampshire, US |
212389 | 212389 | 2020-10-29 | US | New Hampshire | Unassigned | 90033 | 18 | 0 | 0 | 18 | 44.69063265 | 0.0 | 2020-10-30 04:24:49 | Unassigned, New Hampshire, US |
214099 | 214099 | 2020-06-08 | US | New Hampshire | Belknap | 33001 | 70 | 0 | 0 | 70 | 43.51637314 | -71.41684235 | 2020-06-09 03:33:03 | Belknap, New Hampshire, US |
214317 | 214317 | 2020-06-08 | US | New Hampshire | Carroll | 33003 | 48 | 0 | 0 | 48 | 43.87498583 | -71.20430216 | 2020-06-09 03:33:03 | Carroll, New Hampshire, US |
214542 | 214542 | 2020-06-08 | US | New Hampshire | Coos | 33007 | 6 | 0 | 0 | 6 | 44.69063265 | -71.30633239 | 2020-06-09 03:33:03 | Coos, New Hampshire, US |
216675 | 216675 | 2020-06-08 | US | New Hampshire | Unassigned | 90033 | 9 | 0 | 0 | 9 | 44.69063265 | 0.0 | 2020-06-09 03:33:03 | Unassigned, New Hampshire, US |
225837 | 225837 | 2020-04-30 | US | New Hampshire | Belknap | 33001 | 34 | 0 | 0 | 34 | 43.51637314 | -71.41684235 | 2020-05-01 02:32:28 | Belknap, New Hampshire, US |
226040 | 226040 | 2020-04-30 | US | New Hampshire | Carroll | 33003 | 31 | 0 | 0 | 31 | 43.87498583 | -71.20430216 | 2020-05-01 02:32:28 | Carroll, New Hampshire, US |
226257 | 226257 | 2020-04-30 | US | New Hampshire | Coos | 33007 | 2 | 0 | 0 | 2 | 44.69063265 | -71.30633239 | 2020-05-01 02:32:28 | Coos, New Hampshire, US |
226647 | 226647 | 2020-04-30 | US | New Hampshire | Grafton | 33009 | 50 | 0 | 0 | 50 | 43.93779815 | -71.82057197 | 2020-05-01 02:32:28 | Grafton, New Hampshire, US |
265379 | 265379 | 2020-05-21 | US | New Hampshire | Belknap | 33001 | 54 | 0 | 0 | 54 | 43.51637314 | -71.41684235 | 2020-05-22 02:36:51 | Belknap, New Hampshire, US |
265595 | 265595 | 2020-05-21 | US | New Hampshire | Carroll | 33003 | 46 | 0 | 0 | 46 | 43.87498583 | -71.20430216 | 2020-05-22 02:36:51 | Carroll, New Hampshire, US |
265818 | 265818 | 2020-05-21 | US | New Hampshire | Coos | 33007 | 4 | 0 | 0 | 4 | 44.69063265 | -71.30633239 | 2020-05-22 02:36:51 | Coos, New Hampshire, US |
268810 | 268810 | 2020-04-28 | US | New Hampshire | Belknap | 33001 | 34 | 0 | 0 | 34 | 43.51637314 | -71.41684235 | 2020-04-29 02:32:29 | Belknap, New Hampshire, US |
269013 | 269013 | 2020-04-28 | US | New Hampshire | Carroll | 33003 | 31 | 0 | 0 | 31 | 43.87498583 | -71.20430216 | 2020-04-29 02:32:29 | Carroll, New Hampshire, US |
269090 | 269090 | 2020-04-28 | US | New Hampshire | Cheshire | 33005 | 40 | 0 | 0 | 40 | 42.92015988 | -72.25311043 | 2020-04-29 02:32:29 | Cheshire, New Hampshire, US |
269230 | 269230 | 2020-04-28 | US | New Hampshire | Coos | 33007 | 2 | 0 | 0 | 2 | 44.69063265 | -71.30633239 | 2020-04-29 02:32:29 | Coos, New Hampshire, US |
269614 | 269614 | 2020-04-28 | US | New Hampshire | Grafton | 33009 | 48 | 0 | 0 | 48 | 43.93779815 | -71.82057197 | 2020-04-29 02:32:29 | Grafton, New Hampshire, US |
270364 | 270364 | 2020-04-28 | US | New Hampshire | Merrimack | 33013 | 144 | 0 | 0 | 144 | 43.29662971 | -71.6811573 | 2020-04-29 02:32:29 | Merrimack, New Hampshire, US |
271105 | 271105 | 2020-04-28 | US | New Hampshire | Strafford | 33017 | 133 | 0 | 0 | 133 | 43.291833 | -71.02336013 | 2020-04-29 02:32:29 | Strafford, New Hampshire, US |
271112 | 271112 | 2020-04-28 | US | New Hampshire | Sullivan | 33019 | 11 | 0 | 0 | 11 | 43.36094111 | -72.22203125 | 2020-04-29 02:32:29 | Sullivan, New Hampshire, US |
274298 | 274298 | 2020-11-10 | US | New Hampshire | Coos | 33007 | 174 | 0 | 0 | 174 | 44.69063265 | -71.30633239 | 2020-11-11 05:25:30 | Coos, New Hampshire, US |
274305 | 274305 | 2020-11-10 | US | New Hampshire | Unassigned | 90033 | 43 | 0 | 0 | 43 | 44.69063265 | 0.0 | 2020-11-11 05:25:30 | Unassigned, New Hampshire, US |
284268 | 284268 | 2020-06-15 | US | New Hampshire | Carroll | 33003 | 49 | 0 | 0 | 49 | 43.87498583 | -71.20430216 | 2020-06-16 04:33:09 | Carroll, New Hampshire, US |
284494 | 284494 | 2020-06-15 | US | New Hampshire | Coos | 33007 | 6 | 0 | 0 | 6 | 44.69063265 | -71.30633239 | 2020-06-16 04:33:09 | Coos, New Hampshire, US |
286649 | 286649 | 2020-06-15 | US | New Hampshire | Unassigned | 90033 | 5 | 0 | 0 | 5 | 44.69063265 | 0.0 | 2020-06-16 04:33:09 | Unassigned, New Hampshire, US |
300102 | 300102 | 2020-07-01 | US | New Hampshire | Carroll | 33003 | 54 | 0 | 0 | 54 | 43.87498583 | -71.20430216 | 2020-07-02 04:33:46 | Carroll, New Hampshire, US |
300330 | 300330 | 2020-07-01 | US | New Hampshire | Coos | 33007 | 7 | 0 | 0 | 7 | 44.69063265 | -71.30633239 | 2020-07-02 04:33:46 | Coos, New Hampshire, US |
302516 | 302516 | 2020-07-01 | US | New Hampshire | Unassigned | 90033 | 1 | 0 | 0 | 1 | 44.69063265 | 0.0 | 2020-07-02 04:33:46 | Unassigned, New Hampshire, US |
324020 | 324020 | 2020-07-20 | US | New Hampshire | Carroll | 33003 | 71 | 0 | 0 | 71 | 43.87498583 | -71.20430216 | 2020-07-21 04:38:46 | Carroll, New Hampshire, US |
324249 | 324249 | 2020-07-20 | US | New Hampshire | Coos | 33007 | 13 | 0 | 0 | 13 | 44.69063265 | -71.30633239 | 2020-07-21 04:38:46 | Coos, New Hampshire, US |
326451 | 326451 | 2020-07-20 | US | New Hampshire | Unassigned | 90033 | 0 | 0 | 0 | 0 | 44.69063265 | 0.0 | 2020-07-21 04:38:46 | Unassigned, New Hampshire, US |
339783 | 339783 | 2020-03-21 | US | New Hampshire | 55 | 0 | 0 | 43.4525 | -71.5639 | 2020-03-21T00:13:22 | ||||
346413 | 346413 | 2020-09-14 | US | New Hampshire | Coos | 33007 | 21 | 0 | 0 | 21 | 44.69063265 | -71.30633239 | 2020-09-15 03:22:50 | Coos, New Hampshire, US |
346420 | 346420 | 2020-09-14 | US | New Hampshire | Unassigned | 90033 | 3 | 0 | 0 | 3 | 44.69063265 | 0.0 | 2020-09-15 03:22:50 | Unassigned, New Hampshire, US |
364423 | 364423 | 2020-07-16 | US | New Hampshire | Carroll | 33003 | 69 | 0 | 0 | 69 | 43.87498583 | -71.20430216 | 2020-07-17 04:34:50 | Carroll, New Hampshire, US |
364651 | 364651 | 2020-07-16 | US | New Hampshire | Coos | 33007 | 11 | 0 | 0 | 11 | 44.69063265 | -71.30633239 | 2020-07-17 04:34:50 | Coos, New Hampshire, US |
366865 | 366865 | 2020-07-16 | US | New Hampshire | Unassigned | 90033 | 0 | 0 | 0 | 0 | 44.69063265 | 0.0 | 2020-07-17 04:34:50 | Unassigned, New Hampshire, US |
368540 | 368540 | 2020-08-08 | US | New Hampshire | Coos | 33007 | 17 | 0 | 0 | 17 | 44.69063265 | -71.30633239 | 2020-08-09 04:34:54 | Coos, New Hampshire, US |
370818 | 370818 | 2020-08-08 | US | New Hampshire | Unassigned | 90033 | 6 | 0 | 0 | 6 | 44.69063265 | 0.0 | 2020-08-09 04:34:54 | Unassigned, New Hampshire, US |
378325 | 378325 | 2020-11-06 | US | New Hampshire | Coos | 33007 | 147 | 0 | 0 | 147 | 44.69063265 | -71.30633239 | 2020-11-07 05:24:52 | Coos, New Hampshire, US |
378332 | 378332 | 2020-11-06 | US | New Hampshire | Unassigned | 90033 | 32 | 0 | 0 | 32 | 44.69063265 | 0.0 | 2020-11-07 05:24:52 | Unassigned, New Hampshire, US |
412386 | 412386 | 2020-07-05 | US | New Hampshire | Carroll | 33003 | 60 | 0 | 0 | 60 | 43.87498583 | -71.20430216 | 2020-07-06 04:33:57 | Carroll, New Hampshire, US |
412614 | 412614 | 2020-07-05 | US | New Hampshire | Coos | 33007 | 7 | 0 | 0 | 7 | 44.69063265 | -71.30633239 | 2020-07-06 04:33:57 | Coos, New Hampshire, US |
414808 | 414808 | 2020-07-05 | US | New Hampshire | Unassigned | 90033 | 4 | 0 | 0 | 4 | 44.69063265 | 0.0 | 2020-07-06 04:33:57 | Unassigned, New Hampshire, US |
416067 | 416067 | 2020-04-18 | US | New Hampshire | Belknap | 33001 | 25 | 0 | 0 | 25 | 43.51637314 | -71.41684235 | 2020-04-18 22:32:47 | Belknap, New Hampshire, US |
416266 | 416266 | 2020-04-18 | US | New Hampshire | Carroll | 33003 | 30 | 0 | 0 | 30 | 43.87498583 | -71.20430216 | 2020-04-18 22:32:47 | Carroll, New Hampshire, US |
416339 | 416339 | 2020-04-18 | US | New Hampshire | Cheshire | 33005 | 28 | 0 | 0 | 28 | 42.92015988 | -72.25311043 | 2020-04-18 22:32:47 | Cheshire, New Hampshire, US |
416471 | 416471 | 2020-04-18 | US | New Hampshire | Coos | 33007 | 2 | 0 | 0 | 2 | 44.69063265 | -71.30633239 | 2020-04-18 22:32:47 | Coos, New Hampshire, US |
416842 | 416842 | 2020-04-18 | US | New Hampshire | Grafton | 33009 | 45 | 0 | 0 | 45 | 43.93779815 | -71.82057197 | 2020-04-18 22:32:47 | Grafton, New Hampshire, US |
417565 | 417565 | 2020-04-18 | US | New Hampshire | Merrimack | 33013 | 92 | 0 | 0 | 92 | 43.29662971 | -71.6811573 | 2020-04-18 22:32:47 | Merrimack, New Hampshire, 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]);