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 day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755061 | 2755061 | 2022-12-29 | US | New Hampshire | Belknap | 33001 | 16862 | 204 | 0 | 43.51637314 | -71.41684235 | 2022-12-30 04:21:04 | Belknap, New Hampshire, US | |
2755062 | 2755062 | 2022-12-29 | US | New Hampshire | Carroll | 33003 | 11972 | 71 | 0 | 43.87498583 | -71.20430216 | 2022-12-30 04:21:04 | Carroll, New Hampshire, US | |
2755063 | 2755063 | 2022-12-29 | US | New Hampshire | Cheshire | 33005 | 18498 | 131 | 0 | 42.92015988 | -72.25311043 | 2022-12-30 04:21:04 | Cheshire, New Hampshire, US | |
2755064 | 2755064 | 2022-12-29 | US | New Hampshire | Coos | 33007 | 8175 | 132 | 0 | 44.69063265 | -71.30633239 | 2022-12-30 04:21:04 | Coos, New Hampshire, US | |
2755065 | 2755065 | 2022-12-29 | US | New Hampshire | Grafton | 33009 | 22624 | 90 | 0 | 43.93779815 | -71.82057197 | 2022-12-30 04:21:04 | Grafton, New Hampshire, US | |
2755066 | 2755066 | 2022-12-29 | US | New Hampshire | Hillsborough | 33011 | 118028 | 1003 | 0 | 42.91537785 | -71.7200253 | 2022-12-30 04:21:04 | Hillsborough, New Hampshire, US | |
2755067 | 2755067 | 2022-12-29 | US | New Hampshire | Merrimack | 33013 | 39078 | 278 | 0 | 43.29662971 | -71.6811573 | 2022-12-30 04:21:04 | Merrimack, New Hampshire, US | |
2755068 | 2755068 | 2022-12-29 | US | New Hampshire | Rockingham | 33015 | 82018 | 616 | 0 | 42.98499744 | -71.12883377 | 2022-12-30 04:21:04 | Rockingham, New Hampshire, US | |
2755069 | 2755069 | 2022-12-29 | US | New Hampshire | Strafford | 33017 | 35948 | 239 | 0 | 43.291833 | -71.02336013 | 2022-12-30 04:21:04 | Strafford, New Hampshire, US | |
2755070 | 2755070 | 2022-12-29 | US | New Hampshire | Sullivan | 33019 | 11582 | 81 | 0 | 43.36094111 | -72.22203125 | 2022-12-30 04:21:04 | Sullivan, New Hampshire, US | |
2755071 | 2755071 | 2022-12-29 | US | New Hampshire | Unassigned | 90033 | 2172 | 7 | 0 | 44.69063265 | 0.0 | 2022-12-30 04:21:04 | Unassigned, New Hampshire, US | |
1076067 | 1076067 | 2022-12-28 | US | New Hampshire | Belknap | 33001 | 16862 | 204 | 0 | 43.51637314 | -71.41684235 | 2022-12-29 04:21:01 | Belknap, New Hampshire, US | |
1076068 | 1076068 | 2022-12-28 | US | New Hampshire | Carroll | 33003 | 11972 | 71 | 0 | 43.87498583 | -71.20430216 | 2022-12-29 04:21:01 | Carroll, New Hampshire, US | |
1076069 | 1076069 | 2022-12-28 | US | New Hampshire | Cheshire | 33005 | 18498 | 131 | 0 | 42.92015988 | -72.25311043 | 2022-12-29 04:21:01 | Cheshire, New Hampshire, US | |
1076070 | 1076070 | 2022-12-28 | US | New Hampshire | Coos | 33007 | 8175 | 132 | 0 | 44.69063265 | -71.30633239 | 2022-12-29 04:21:01 | Coos, New Hampshire, US | |
1076071 | 1076071 | 2022-12-28 | US | New Hampshire | Grafton | 33009 | 22624 | 90 | 0 | 43.93779815 | -71.82057197 | 2022-12-29 04:21:01 | Grafton, New Hampshire, US | |
1076072 | 1076072 | 2022-12-28 | US | New Hampshire | Hillsborough | 33011 | 118028 | 1003 | 0 | 42.91537785 | -71.7200253 | 2022-12-29 04:21:01 | Hillsborough, New Hampshire, US | |
1076073 | 1076073 | 2022-12-28 | US | New Hampshire | Merrimack | 33013 | 39078 | 278 | 0 | 43.29662971 | -71.6811573 | 2022-12-29 04:21:01 | Merrimack, New Hampshire, US | |
1076074 | 1076074 | 2022-12-28 | US | New Hampshire | Rockingham | 33015 | 82018 | 616 | 0 | 42.98499744 | -71.12883377 | 2022-12-29 04:21:01 | Rockingham, New Hampshire, US | |
1076075 | 1076075 | 2022-12-28 | US | New Hampshire | Strafford | 33017 | 35948 | 239 | 0 | 43.291833 | -71.02336013 | 2022-12-29 04:21:01 | Strafford, New Hampshire, US | |
1076076 | 1076076 | 2022-12-28 | US | New Hampshire | Sullivan | 33019 | 11582 | 81 | 0 | 43.36094111 | -72.22203125 | 2022-12-29 04:21:01 | Sullivan, New Hampshire, US | |
1076077 | 1076077 | 2022-12-28 | US | New Hampshire | Unassigned | 90033 | 2172 | 7 | 0 | 44.69063265 | 0.0 | 2022-12-29 04:21:01 | Unassigned, New Hampshire, US | |
330064 | 330064 | 2022-12-27 | US | New Hampshire | Belknap | 33001 | 16855 | 204 | 0 | 43.51637314 | -71.41684235 | 2022-12-28 04:21:04 | Belknap, New Hampshire, US | |
330065 | 330065 | 2022-12-27 | US | New Hampshire | Carroll | 33003 | 11966 | 71 | 0 | 43.87498583 | -71.20430216 | 2022-12-28 04:21:04 | Carroll, New Hampshire, US | |
330066 | 330066 | 2022-12-27 | US | New Hampshire | Cheshire | 33005 | 18492 | 131 | 0 | 42.92015988 | -72.25311043 | 2022-12-28 04:21:04 | Cheshire, New Hampshire, US | |
330067 | 330067 | 2022-12-27 | US | New Hampshire | Coos | 33007 | 8165 | 132 | 0 | 44.69063265 | -71.30633239 | 2022-12-28 04:21:04 | Coos, New Hampshire, US | |
330068 | 330068 | 2022-12-27 | US | New Hampshire | Grafton | 33009 | 22611 | 90 | 0 | 43.93779815 | -71.82057197 | 2022-12-28 04:21:04 | Grafton, New Hampshire, US | |
330069 | 330069 | 2022-12-27 | US | New Hampshire | Hillsborough | 33011 | 117965 | 1003 | 0 | 42.91537785 | -71.7200253 | 2022-12-28 04:21:04 | Hillsborough, New Hampshire, US | |
330070 | 330070 | 2022-12-27 | US | New Hampshire | Merrimack | 33013 | 39062 | 278 | 0 | 43.29662971 | -71.6811573 | 2022-12-28 04:21:04 | Merrimack, New Hampshire, US | |
330071 | 330071 | 2022-12-27 | US | New Hampshire | Rockingham | 33015 | 81981 | 616 | 0 | 42.98499744 | -71.12883377 | 2022-12-28 04:21:04 | Rockingham, New Hampshire, US | |
330072 | 330072 | 2022-12-27 | US | New Hampshire | Strafford | 33017 | 35927 | 239 | 0 | 43.291833 | -71.02336013 | 2022-12-28 04:21:04 | Strafford, New Hampshire, US | |
330073 | 330073 | 2022-12-27 | US | New Hampshire | Sullivan | 33019 | 11574 | 80 | 0 | 43.36094111 | -72.22203125 | 2022-12-28 04:21:04 | Sullivan, New Hampshire, US | |
330074 | 330074 | 2022-12-27 | US | New Hampshire | Unassigned | 90033 | 2156 | 7 | 0 | 44.69063265 | 0.0 | 2022-12-28 04:21:04 | Unassigned, New Hampshire, US | |
220137 | 220137 | 2022-12-26 | US | New Hampshire | Belknap | 33001 | 16842 | 204 | 0 | 43.51637314 | -71.41684235 | 2022-12-27 04:21:07 | Belknap, New Hampshire, US | |
220138 | 220138 | 2022-12-26 | US | New Hampshire | Carroll | 33003 | 11951 | 71 | 0 | 43.87498583 | -71.20430216 | 2022-12-27 04:21:07 | Carroll, New Hampshire, US | |
220139 | 220139 | 2022-12-26 | US | New Hampshire | Cheshire | 33005 | 18443 | 131 | 0 | 42.92015988 | -72.25311043 | 2022-12-27 04:21:07 | Cheshire, New Hampshire, US | |
220140 | 220140 | 2022-12-26 | US | New Hampshire | Coos | 33007 | 8160 | 132 | 0 | 44.69063265 | -71.30633239 | 2022-12-27 04:21:07 | Coos, New Hampshire, US | |
220141 | 220141 | 2022-12-26 | US | New Hampshire | Grafton | 33009 | 22589 | 90 | 0 | 43.93779815 | -71.82057197 | 2022-12-27 04:21:07 | Grafton, New Hampshire, US | |
220142 | 220142 | 2022-12-26 | US | New Hampshire | Hillsborough | 33011 | 117758 | 1003 | 0 | 42.91537785 | -71.7200253 | 2022-12-27 04:21:07 | Hillsborough, New Hampshire, US | |
220143 | 220143 | 2022-12-26 | US | New Hampshire | Merrimack | 33013 | 38982 | 278 | 0 | 43.29662971 | -71.6811573 | 2022-12-27 04:21:07 | Merrimack, New Hampshire, US | |
220144 | 220144 | 2022-12-26 | US | New Hampshire | Rockingham | 33015 | 81869 | 616 | 0 | 42.98499744 | -71.12883377 | 2022-12-27 04:21:07 | Rockingham, New Hampshire, US | |
220145 | 220145 | 2022-12-26 | US | New Hampshire | Strafford | 33017 | 35850 | 239 | 0 | 43.291833 | -71.02336013 | 2022-12-27 04:21:07 | Strafford, New Hampshire, US | |
220146 | 220146 | 2022-12-26 | US | New Hampshire | Sullivan | 33019 | 11555 | 80 | 0 | 43.36094111 | -72.22203125 | 2022-12-27 04:21:07 | Sullivan, New Hampshire, US | |
220147 | 220147 | 2022-12-26 | US | New Hampshire | Unassigned | 90033 | 2122 | 7 | 0 | 44.69063265 | 0.0 | 2022-12-27 04:21:07 | Unassigned, New Hampshire, US | |
3224594 | 3224594 | 2022-12-25 | US | New Hampshire | Belknap | 33001 | 16842 | 204 | 0 | 43.51637314 | -71.41684235 | 2022-12-26 04:21:06 | Belknap, New Hampshire, US | |
3224595 | 3224595 | 2022-12-25 | US | New Hampshire | Carroll | 33003 | 11951 | 71 | 0 | 43.87498583 | -71.20430216 | 2022-12-26 04:21:06 | Carroll, New Hampshire, US | |
3224596 | 3224596 | 2022-12-25 | US | New Hampshire | Cheshire | 33005 | 18443 | 131 | 0 | 42.92015988 | -72.25311043 | 2022-12-26 04:21:06 | Cheshire, New Hampshire, US | |
3224597 | 3224597 | 2022-12-25 | US | New Hampshire | Coos | 33007 | 8160 | 132 | 0 | 44.69063265 | -71.30633239 | 2022-12-26 04:21:06 | Coos, New Hampshire, US | |
3224598 | 3224598 | 2022-12-25 | US | New Hampshire | Grafton | 33009 | 22589 | 90 | 0 | 43.93779815 | -71.82057197 | 2022-12-26 04:21:06 | Grafton, New Hampshire, US | |
3224599 | 3224599 | 2022-12-25 | US | New Hampshire | Hillsborough | 33011 | 117758 | 1003 | 0 | 42.91537785 | -71.7200253 | 2022-12-26 04:21:06 | Hillsborough, New Hampshire, US | |
3224600 | 3224600 | 2022-12-25 | US | New Hampshire | Merrimack | 33013 | 38982 | 278 | 0 | 43.29662971 | -71.6811573 | 2022-12-26 04:21:06 | Merrimack, New Hampshire, US | |
3224601 | 3224601 | 2022-12-25 | US | New Hampshire | Rockingham | 33015 | 81869 | 616 | 0 | 42.98499744 | -71.12883377 | 2022-12-26 04:21:06 | Rockingham, New Hampshire, US | |
3224602 | 3224602 | 2022-12-25 | US | New Hampshire | Strafford | 33017 | 35850 | 239 | 0 | 43.291833 | -71.02336013 | 2022-12-26 04:21:06 | Strafford, New Hampshire, US | |
3224603 | 3224603 | 2022-12-25 | US | New Hampshire | Sullivan | 33019 | 11555 | 80 | 0 | 43.36094111 | -72.22203125 | 2022-12-26 04:21:06 | Sullivan, New Hampshire, US | |
3224604 | 3224604 | 2022-12-25 | US | New Hampshire | Unassigned | 90033 | 2122 | 7 | 0 | 44.69063265 | 0.0 | 2022-12-26 04:21:06 | Unassigned, New Hampshire, US | |
1020508 | 1020508 | 2022-12-24 | US | New Hampshire | Belknap | 33001 | 16842 | 204 | 0 | 43.51637314 | -71.41684235 | 2022-12-25 04:21:04 | Belknap, New Hampshire, US | |
1020509 | 1020509 | 2022-12-24 | US | New Hampshire | Carroll | 33003 | 11951 | 71 | 0 | 43.87498583 | -71.20430216 | 2022-12-25 04:21:04 | Carroll, New Hampshire, US | |
1020510 | 1020510 | 2022-12-24 | US | New Hampshire | Cheshire | 33005 | 18443 | 131 | 0 | 42.92015988 | -72.25311043 | 2022-12-25 04:21:04 | Cheshire, New Hampshire, US | |
1020511 | 1020511 | 2022-12-24 | US | New Hampshire | Coos | 33007 | 8160 | 132 | 0 | 44.69063265 | -71.30633239 | 2022-12-25 04:21:04 | Coos, New Hampshire, US | |
1020512 | 1020512 | 2022-12-24 | US | New Hampshire | Grafton | 33009 | 22589 | 90 | 0 | 43.93779815 | -71.82057197 | 2022-12-25 04:21:04 | Grafton, New Hampshire, US | |
1020513 | 1020513 | 2022-12-24 | US | New Hampshire | Hillsborough | 33011 | 117758 | 1003 | 0 | 42.91537785 | -71.7200253 | 2022-12-25 04:21:04 | Hillsborough, New Hampshire, US | |
1020514 | 1020514 | 2022-12-24 | US | New Hampshire | Merrimack | 33013 | 38982 | 278 | 0 | 43.29662971 | -71.6811573 | 2022-12-25 04:21:04 | Merrimack, New Hampshire, US | |
1020515 | 1020515 | 2022-12-24 | US | New Hampshire | Rockingham | 33015 | 81869 | 616 | 0 | 42.98499744 | -71.12883377 | 2022-12-25 04:21:04 | Rockingham, New Hampshire, US | |
1020516 | 1020516 | 2022-12-24 | US | New Hampshire | Strafford | 33017 | 35850 | 239 | 0 | 43.291833 | -71.02336013 | 2022-12-25 04:21:04 | Strafford, New Hampshire, US | |
1020517 | 1020517 | 2022-12-24 | US | New Hampshire | Sullivan | 33019 | 11555 | 80 | 0 | 43.36094111 | -72.22203125 | 2022-12-25 04:21:04 | Sullivan, New Hampshire, US | |
1020518 | 1020518 | 2022-12-24 | US | New Hampshire | Unassigned | 90033 | 2122 | 7 | 0 | 44.69063265 | 0.0 | 2022-12-25 04:21:04 | Unassigned, New Hampshire, US | |
692531 | 692531 | 2022-12-23 | US | New Hampshire | Belknap | 33001 | 16842 | 204 | 0 | 43.51637314 | -71.41684235 | 2022-12-24 04:21:02 | Belknap, New Hampshire, US | |
692532 | 692532 | 2022-12-23 | US | New Hampshire | Carroll | 33003 | 11951 | 71 | 0 | 43.87498583 | -71.20430216 | 2022-12-24 04:21:02 | Carroll, New Hampshire, US | |
692533 | 692533 | 2022-12-23 | US | New Hampshire | Cheshire | 33005 | 18443 | 131 | 0 | 42.92015988 | -72.25311043 | 2022-12-24 04:21:02 | Cheshire, New Hampshire, US | |
692534 | 692534 | 2022-12-23 | US | New Hampshire | Coos | 33007 | 8160 | 132 | 0 | 44.69063265 | -71.30633239 | 2022-12-24 04:21:02 | Coos, New Hampshire, US | |
692535 | 692535 | 2022-12-23 | US | New Hampshire | Grafton | 33009 | 22589 | 90 | 0 | 43.93779815 | -71.82057197 | 2022-12-24 04:21:02 | Grafton, New Hampshire, US | |
692536 | 692536 | 2022-12-23 | US | New Hampshire | Hillsborough | 33011 | 117758 | 1003 | 0 | 42.91537785 | -71.7200253 | 2022-12-24 04:21:02 | Hillsborough, New Hampshire, US | |
692537 | 692537 | 2022-12-23 | US | New Hampshire | Merrimack | 33013 | 38982 | 278 | 0 | 43.29662971 | -71.6811573 | 2022-12-24 04:21:02 | Merrimack, New Hampshire, US | |
692538 | 692538 | 2022-12-23 | US | New Hampshire | Rockingham | 33015 | 81869 | 616 | 0 | 42.98499744 | -71.12883377 | 2022-12-24 04:21:02 | Rockingham, New Hampshire, US | |
692539 | 692539 | 2022-12-23 | US | New Hampshire | Strafford | 33017 | 35850 | 239 | 0 | 43.291833 | -71.02336013 | 2022-12-24 04:21:02 | Strafford, New Hampshire, US | |
692540 | 692540 | 2022-12-23 | US | New Hampshire | Sullivan | 33019 | 11555 | 80 | 0 | 43.36094111 | -72.22203125 | 2022-12-24 04:21:02 | Sullivan, New Hampshire, US | |
692541 | 692541 | 2022-12-23 | US | New Hampshire | Unassigned | 90033 | 2122 | 7 | 0 | 44.69063265 | 0.0 | 2022-12-24 04:21:02 | Unassigned, New Hampshire, US | |
2181741 | 2181741 | 2022-12-22 | US | New Hampshire | Belknap | 33001 | 16821 | 204 | 0 | 43.51637314 | -71.41684235 | 2022-12-23 04:21:04 | Belknap, New Hampshire, US | |
2181742 | 2181742 | 2022-12-22 | US | New Hampshire | Carroll | 33003 | 11942 | 71 | 0 | 43.87498583 | -71.20430216 | 2022-12-23 04:21:04 | Carroll, New Hampshire, US | |
2181743 | 2181743 | 2022-12-22 | US | New Hampshire | Cheshire | 33005 | 18433 | 131 | 0 | 42.92015988 | -72.25311043 | 2022-12-23 04:21:04 | Cheshire, New Hampshire, US | |
2181744 | 2181744 | 2022-12-22 | US | New Hampshire | Coos | 33007 | 8150 | 132 | 0 | 44.69063265 | -71.30633239 | 2022-12-23 04:21:04 | Coos, New Hampshire, US | |
2181745 | 2181745 | 2022-12-22 | US | New Hampshire | Grafton | 33009 | 22576 | 89 | 0 | 43.93779815 | -71.82057197 | 2022-12-23 04:21:04 | Grafton, New Hampshire, US | |
2181746 | 2181746 | 2022-12-22 | US | New Hampshire | Hillsborough | 33011 | 117660 | 1003 | 0 | 42.91537785 | -71.7200253 | 2022-12-23 04:21:04 | Hillsborough, New Hampshire, US | |
2181747 | 2181747 | 2022-12-22 | US | New Hampshire | Merrimack | 33013 | 38956 | 278 | 0 | 43.29662971 | -71.6811573 | 2022-12-23 04:21:04 | Merrimack, New Hampshire, US | |
2181748 | 2181748 | 2022-12-22 | US | New Hampshire | Rockingham | 33015 | 81798 | 616 | 0 | 42.98499744 | -71.12883377 | 2022-12-23 04:21:04 | Rockingham, New Hampshire, US | |
2181749 | 2181749 | 2022-12-22 | US | New Hampshire | Strafford | 33017 | 35826 | 239 | 0 | 43.291833 | -71.02336013 | 2022-12-23 04:21:04 | Strafford, New Hampshire, US | |
2181750 | 2181750 | 2022-12-22 | US | New Hampshire | Sullivan | 33019 | 11545 | 80 | 0 | 43.36094111 | -72.22203125 | 2022-12-23 04:21:04 | Sullivan, New Hampshire, US | |
2181751 | 2181751 | 2022-12-22 | US | New Hampshire | Unassigned | 90033 | 2145 | 7 | 0 | 44.69063265 | 0.0 | 2022-12-23 04:21:04 | Unassigned, New Hampshire, US | |
453545 | 453545 | 2022-12-21 | US | New Hampshire | Belknap | 33001 | 16809 | 204 | 0 | 43.51637314 | -71.41684235 | 2022-12-22 04:20:56 | Belknap, New Hampshire, US | |
453546 | 453546 | 2022-12-21 | US | New Hampshire | Carroll | 33003 | 11931 | 70 | 0 | 43.87498583 | -71.20430216 | 2022-12-22 04:20:56 | Carroll, New Hampshire, US | |
453547 | 453547 | 2022-12-21 | US | New Hampshire | Cheshire | 33005 | 18421 | 131 | 0 | 42.92015988 | -72.25311043 | 2022-12-22 04:20:56 | Cheshire, New Hampshire, US | |
453548 | 453548 | 2022-12-21 | US | New Hampshire | Coos | 33007 | 8150 | 132 | 0 | 44.69063265 | -71.30633239 | 2022-12-22 04:20:56 | Coos, New Hampshire, US | |
453549 | 453549 | 2022-12-21 | US | New Hampshire | Grafton | 33009 | 22569 | 89 | 0 | 43.93779815 | -71.82057197 | 2022-12-22 04:20:56 | Grafton, New Hampshire, US | |
453550 | 453550 | 2022-12-21 | US | New Hampshire | Hillsborough | 33011 | 117555 | 1002 | 0 | 42.91537785 | -71.7200253 | 2022-12-22 04:20:56 | Hillsborough, New Hampshire, US | |
453551 | 453551 | 2022-12-21 | US | New Hampshire | Merrimack | 33013 | 38929 | 278 | 0 | 43.29662971 | -71.6811573 | 2022-12-22 04:20:56 | Merrimack, New Hampshire, US | |
453552 | 453552 | 2022-12-21 | US | New Hampshire | Rockingham | 33015 | 81745 | 616 | 0 | 42.98499744 | -71.12883377 | 2022-12-22 04:20:56 | Rockingham, New Hampshire, US | |
453553 | 453553 | 2022-12-21 | US | New Hampshire | Strafford | 33017 | 35783 | 239 | 0 | 43.291833 | -71.02336013 | 2022-12-22 04:20:56 | Strafford, New Hampshire, US | |
453554 | 453554 | 2022-12-21 | US | New Hampshire | Sullivan | 33019 | 11537 | 80 | 0 | 43.36094111 | -72.22203125 | 2022-12-22 04:20:56 | Sullivan, New Hampshire, US | |
453555 | 453555 | 2022-12-21 | US | New Hampshire | Unassigned | 90033 | 2130 | 6 | 0 | 44.69063265 | 0.0 | 2022-12-22 04:20:56 | Unassigned, New Hampshire, US | |
2953544 | 2953544 | 2022-12-20 | US | New Hampshire | Belknap | 33001 | 16789 | 204 | 0 | 43.51637314 | -71.41684235 | 2022-12-21 04:21:03 | Belknap, 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]);