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)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2953545 | 2953545 | 2022-12-20 | US | New Hampshire | Carroll | 33003 | 11925 | 70 | 0 | 43.87498583 | -71.20430216 | 2022-12-21 04:21:03 | Carroll, New Hampshire, US | |
2953546 | 2953546 | 2022-12-20 | US | New Hampshire | Cheshire | 33005 | 18417 | 131 | 0 | 42.92015988 | -72.25311043 | 2022-12-21 04:21:03 | Cheshire, New Hampshire, US | |
2953547 | 2953547 | 2022-12-20 | US | New Hampshire | Coos | 33007 | 8132 | 131 | 0 | 44.69063265 | -71.30633239 | 2022-12-21 04:21:03 | Coos, New Hampshire, US | |
2953548 | 2953548 | 2022-12-20 | US | New Hampshire | Grafton | 33009 | 22548 | 88 | 0 | 43.93779815 | -71.82057197 | 2022-12-21 04:21:03 | Grafton, New Hampshire, US | |
2953549 | 2953549 | 2022-12-20 | US | New Hampshire | Hillsborough | 33011 | 117463 | 1001 | 0 | 42.91537785 | -71.7200253 | 2022-12-21 04:21:03 | Hillsborough, New Hampshire, US | |
2953550 | 2953550 | 2022-12-20 | US | New Hampshire | Merrimack | 33013 | 38902 | 278 | 0 | 43.29662971 | -71.6811573 | 2022-12-21 04:21:03 | Merrimack, New Hampshire, US | |
2953551 | 2953551 | 2022-12-20 | US | New Hampshire | Rockingham | 33015 | 81650 | 616 | 0 | 42.98499744 | -71.12883377 | 2022-12-21 04:21:03 | Rockingham, New Hampshire, US | |
2953552 | 2953552 | 2022-12-20 | US | New Hampshire | Strafford | 33017 | 35753 | 239 | 0 | 43.291833 | -71.02336013 | 2022-12-21 04:21:03 | Strafford, New Hampshire, US | |
2953553 | 2953553 | 2022-12-20 | US | New Hampshire | Sullivan | 33019 | 11531 | 80 | 0 | 43.36094111 | -72.22203125 | 2022-12-21 04:21:03 | Sullivan, New Hampshire, US | |
2953554 | 2953554 | 2022-12-20 | US | New Hampshire | Unassigned | 90033 | 2101 | 6 | 0 | 44.69063265 | 0.0 | 2022-12-21 04:21:03 | Unassigned, New Hampshire, US | |
3175946 | 3175946 | 2022-12-19 | US | New Hampshire | Belknap | 33001 | 16783 | 204 | 0 | 43.51637314 | -71.41684235 | 2022-12-20 04:21:04 | Belknap, New Hampshire, US | |
3175947 | 3175947 | 2022-12-19 | US | New Hampshire | Carroll | 33003 | 11922 | 70 | 0 | 43.87498583 | -71.20430216 | 2022-12-20 04:21:04 | Carroll, New Hampshire, US | |
3175948 | 3175948 | 2022-12-19 | US | New Hampshire | Cheshire | 33005 | 18411 | 131 | 0 | 42.92015988 | -72.25311043 | 2022-12-20 04:21:04 | Cheshire, New Hampshire, US | |
3175949 | 3175949 | 2022-12-19 | US | New Hampshire | Coos | 33007 | 8130 | 131 | 0 | 44.69063265 | -71.30633239 | 2022-12-20 04:21:04 | Coos, New Hampshire, US | |
3175950 | 3175950 | 2022-12-19 | US | New Hampshire | Grafton | 33009 | 22545 | 88 | 0 | 43.93779815 | -71.82057197 | 2022-12-20 04:21:04 | Grafton, New Hampshire, US | |
3175951 | 3175951 | 2022-12-19 | US | New Hampshire | Hillsborough | 33011 | 117392 | 1000 | 0 | 42.91537785 | -71.7200253 | 2022-12-20 04:21:04 | Hillsborough, New Hampshire, US | |
3175952 | 3175952 | 2022-12-19 | US | New Hampshire | Merrimack | 33013 | 38884 | 278 | 0 | 43.29662971 | -71.6811573 | 2022-12-20 04:21:04 | Merrimack, New Hampshire, US | |
3175953 | 3175953 | 2022-12-19 | US | New Hampshire | Rockingham | 33015 | 81610 | 616 | 0 | 42.98499744 | -71.12883377 | 2022-12-20 04:21:04 | Rockingham, New Hampshire, US | |
3175954 | 3175954 | 2022-12-19 | US | New Hampshire | Strafford | 33017 | 35736 | 239 | 0 | 43.291833 | -71.02336013 | 2022-12-20 04:21:04 | Strafford, New Hampshire, US | |
3175955 | 3175955 | 2022-12-19 | US | New Hampshire | Sullivan | 33019 | 11526 | 80 | 0 | 43.36094111 | -72.22203125 | 2022-12-20 04:21:04 | Sullivan, New Hampshire, US | |
3175956 | 3175956 | 2022-12-19 | US | New Hampshire | Unassigned | 90033 | 2155 | 6 | 0 | 44.69063265 | 0.0 | 2022-12-20 04:21:04 | Unassigned, New Hampshire, US | |
1630463 | 1630463 | 2022-12-18 | US | New Hampshire | Belknap | 33001 | 16763 | 204 | 0 | 43.51637314 | -71.41684235 | 2022-12-19 04:21:03 | Belknap, New Hampshire, US | |
1630464 | 1630464 | 2022-12-18 | US | New Hampshire | Carroll | 33003 | 11910 | 70 | 0 | 43.87498583 | -71.20430216 | 2022-12-19 04:21:03 | Carroll, New Hampshire, US | |
1630465 | 1630465 | 2022-12-18 | US | New Hampshire | Cheshire | 33005 | 18388 | 131 | 0 | 42.92015988 | -72.25311043 | 2022-12-19 04:21:03 | Cheshire, New Hampshire, US | |
1630466 | 1630466 | 2022-12-18 | US | New Hampshire | Coos | 33007 | 8125 | 131 | 0 | 44.69063265 | -71.30633239 | 2022-12-19 04:21:03 | Coos, New Hampshire, US | |
1630467 | 1630467 | 2022-12-18 | US | New Hampshire | Grafton | 33009 | 22529 | 87 | 0 | 43.93779815 | -71.82057197 | 2022-12-19 04:21:03 | Grafton, New Hampshire, US | |
1630468 | 1630468 | 2022-12-18 | US | New Hampshire | Hillsborough | 33011 | 117181 | 1000 | 0 | 42.91537785 | -71.7200253 | 2022-12-19 04:21:03 | Hillsborough, New Hampshire, US | |
1630469 | 1630469 | 2022-12-18 | US | New Hampshire | Merrimack | 33013 | 38818 | 278 | 0 | 43.29662971 | -71.6811573 | 2022-12-19 04:21:03 | Merrimack, New Hampshire, US | |
1630470 | 1630470 | 2022-12-18 | US | New Hampshire | Rockingham | 33015 | 81509 | 616 | 0 | 42.98499744 | -71.12883377 | 2022-12-19 04:21:03 | Rockingham, New Hampshire, US | |
1630471 | 1630471 | 2022-12-18 | US | New Hampshire | Strafford | 33017 | 35675 | 239 | 0 | 43.291833 | -71.02336013 | 2022-12-19 04:21:03 | Strafford, New Hampshire, US | |
1630472 | 1630472 | 2022-12-18 | US | New Hampshire | Sullivan | 33019 | 11510 | 80 | 0 | 43.36094111 | -72.22203125 | 2022-12-19 04:21:03 | Sullivan, New Hampshire, US | |
1630473 | 1630473 | 2022-12-18 | US | New Hampshire | Unassigned | 90033 | 2128 | 6 | 0 | 44.69063265 | 0.0 | 2022-12-19 04:21:03 | Unassigned, New Hampshire, US | |
505842 | 505842 | 2022-12-17 | US | New Hampshire | Belknap | 33001 | 16763 | 204 | 0 | 43.51637314 | -71.41684235 | 2022-12-18 04:21:03 | Belknap, New Hampshire, US | |
505843 | 505843 | 2022-12-17 | US | New Hampshire | Carroll | 33003 | 11910 | 70 | 0 | 43.87498583 | -71.20430216 | 2022-12-18 04:21:03 | Carroll, New Hampshire, US | |
505844 | 505844 | 2022-12-17 | US | New Hampshire | Cheshire | 33005 | 18388 | 131 | 0 | 42.92015988 | -72.25311043 | 2022-12-18 04:21:03 | Cheshire, New Hampshire, US | |
505845 | 505845 | 2022-12-17 | US | New Hampshire | Coos | 33007 | 8125 | 131 | 0 | 44.69063265 | -71.30633239 | 2022-12-18 04:21:03 | Coos, New Hampshire, US | |
505846 | 505846 | 2022-12-17 | US | New Hampshire | Grafton | 33009 | 22529 | 87 | 0 | 43.93779815 | -71.82057197 | 2022-12-18 04:21:03 | Grafton, New Hampshire, US | |
505847 | 505847 | 2022-12-17 | US | New Hampshire | Hillsborough | 33011 | 117181 | 1000 | 0 | 42.91537785 | -71.7200253 | 2022-12-18 04:21:03 | Hillsborough, New Hampshire, US | |
505848 | 505848 | 2022-12-17 | US | New Hampshire | Merrimack | 33013 | 38818 | 278 | 0 | 43.29662971 | -71.6811573 | 2022-12-18 04:21:03 | Merrimack, New Hampshire, US | |
505849 | 505849 | 2022-12-17 | US | New Hampshire | Rockingham | 33015 | 81509 | 616 | 0 | 42.98499744 | -71.12883377 | 2022-12-18 04:21:03 | Rockingham, New Hampshire, US | |
505850 | 505850 | 2022-12-17 | US | New Hampshire | Strafford | 33017 | 35675 | 239 | 0 | 43.291833 | -71.02336013 | 2022-12-18 04:21:03 | Strafford, New Hampshire, US | |
505851 | 505851 | 2022-12-17 | US | New Hampshire | Sullivan | 33019 | 11510 | 80 | 0 | 43.36094111 | -72.22203125 | 2022-12-18 04:21:03 | Sullivan, New Hampshire, US | |
505852 | 505852 | 2022-12-17 | US | New Hampshire | Unassigned | 90033 | 2128 | 6 | 0 | 44.69063265 | 0.0 | 2022-12-18 04:21:03 | Unassigned, New Hampshire, US | |
3326414 | 3326414 | 2022-12-16 | US | New Hampshire | Belknap | 33001 | 16763 | 204 | 0 | 43.51637314 | -71.41684235 | 2022-12-17 04:21:04 | Belknap, New Hampshire, US | |
3326415 | 3326415 | 2022-12-16 | US | New Hampshire | Carroll | 33003 | 11910 | 70 | 0 | 43.87498583 | -71.20430216 | 2022-12-17 04:21:04 | Carroll, New Hampshire, US | |
3326416 | 3326416 | 2022-12-16 | US | New Hampshire | Cheshire | 33005 | 18388 | 131 | 0 | 42.92015988 | -72.25311043 | 2022-12-17 04:21:04 | Cheshire, New Hampshire, US | |
3326417 | 3326417 | 2022-12-16 | US | New Hampshire | Coos | 33007 | 8125 | 131 | 0 | 44.69063265 | -71.30633239 | 2022-12-17 04:21:04 | Coos, New Hampshire, US | |
3326418 | 3326418 | 2022-12-16 | US | New Hampshire | Grafton | 33009 | 22529 | 87 | 0 | 43.93779815 | -71.82057197 | 2022-12-17 04:21:04 | Grafton, New Hampshire, US | |
3326419 | 3326419 | 2022-12-16 | US | New Hampshire | Hillsborough | 33011 | 117181 | 1000 | 0 | 42.91537785 | -71.7200253 | 2022-12-17 04:21:04 | Hillsborough, New Hampshire, US | |
3326420 | 3326420 | 2022-12-16 | US | New Hampshire | Merrimack | 33013 | 38818 | 278 | 0 | 43.29662971 | -71.6811573 | 2022-12-17 04:21:04 | Merrimack, New Hampshire, US | |
3326421 | 3326421 | 2022-12-16 | US | New Hampshire | Rockingham | 33015 | 81509 | 616 | 0 | 42.98499744 | -71.12883377 | 2022-12-17 04:21:04 | Rockingham, New Hampshire, US | |
3326422 | 3326422 | 2022-12-16 | US | New Hampshire | Strafford | 33017 | 35675 | 239 | 0 | 43.291833 | -71.02336013 | 2022-12-17 04:21:04 | Strafford, New Hampshire, US | |
3326423 | 3326423 | 2022-12-16 | US | New Hampshire | Sullivan | 33019 | 11510 | 80 | 0 | 43.36094111 | -72.22203125 | 2022-12-17 04:21:04 | Sullivan, New Hampshire, US | |
3326424 | 3326424 | 2022-12-16 | US | New Hampshire | Unassigned | 90033 | 2128 | 6 | 0 | 44.69063265 | 0.0 | 2022-12-17 04:21:04 | Unassigned, New Hampshire, US | |
544926 | 544926 | 2022-12-15 | US | New Hampshire | Belknap | 33001 | 16755 | 202 | 0 | 43.51637314 | -71.41684235 | 2022-12-16 04:21:01 | Belknap, New Hampshire, US | |
544927 | 544927 | 2022-12-15 | US | New Hampshire | Carroll | 33003 | 11906 | 70 | 0 | 43.87498583 | -71.20430216 | 2022-12-16 04:21:01 | Carroll, New Hampshire, US | |
544928 | 544928 | 2022-12-15 | US | New Hampshire | Cheshire | 33005 | 18384 | 131 | 0 | 42.92015988 | -72.25311043 | 2022-12-16 04:21:01 | Cheshire, New Hampshire, US | |
544929 | 544929 | 2022-12-15 | US | New Hampshire | Coos | 33007 | 8122 | 131 | 0 | 44.69063265 | -71.30633239 | 2022-12-16 04:21:01 | Coos, New Hampshire, US | |
544930 | 544930 | 2022-12-15 | US | New Hampshire | Grafton | 33009 | 22518 | 87 | 0 | 43.93779815 | -71.82057197 | 2022-12-16 04:21:01 | Grafton, New Hampshire, US | |
544931 | 544931 | 2022-12-15 | US | New Hampshire | Hillsborough | 33011 | 117102 | 999 | 0 | 42.91537785 | -71.7200253 | 2022-12-16 04:21:01 | Hillsborough, New Hampshire, US | |
544932 | 544932 | 2022-12-15 | US | New Hampshire | Merrimack | 33013 | 38777 | 278 | 0 | 43.29662971 | -71.6811573 | 2022-12-16 04:21:01 | Merrimack, New Hampshire, US | |
544933 | 544933 | 2022-12-15 | US | New Hampshire | Rockingham | 33015 | 81468 | 616 | 0 | 42.98499744 | -71.12883377 | 2022-12-16 04:21:01 | Rockingham, New Hampshire, US | |
544934 | 544934 | 2022-12-15 | US | New Hampshire | Strafford | 33017 | 35648 | 239 | 0 | 43.291833 | -71.02336013 | 2022-12-16 04:21:01 | Strafford, New Hampshire, US | |
544935 | 544935 | 2022-12-15 | US | New Hampshire | Sullivan | 33019 | 11496 | 80 | 0 | 43.36094111 | -72.22203125 | 2022-12-16 04:21:01 | Sullivan, New Hampshire, US | |
544936 | 544936 | 2022-12-15 | US | New Hampshire | Unassigned | 90033 | 2111 | 6 | 0 | 44.69063265 | 0.0 | 2022-12-16 04:21:01 | Unassigned, New Hampshire, US | |
350454 | 350454 | 2022-12-14 | US | New Hampshire | Belknap | 33001 | 16741 | 202 | 0 | 43.51637314 | -71.41684235 | 2022-12-15 04:20:58 | Belknap, New Hampshire, US | |
350455 | 350455 | 2022-12-14 | US | New Hampshire | Carroll | 33003 | 11895 | 70 | 0 | 43.87498583 | -71.20430216 | 2022-12-15 04:20:58 | Carroll, New Hampshire, US | |
350456 | 350456 | 2022-12-14 | US | New Hampshire | Cheshire | 33005 | 18377 | 131 | 0 | 42.92015988 | -72.25311043 | 2022-12-15 04:20:58 | Cheshire, New Hampshire, US | |
350457 | 350457 | 2022-12-14 | US | New Hampshire | Coos | 33007 | 8119 | 131 | 0 | 44.69063265 | -71.30633239 | 2022-12-15 04:20:58 | Coos, New Hampshire, US | |
350458 | 350458 | 2022-12-14 | US | New Hampshire | Grafton | 33009 | 22512 | 86 | 0 | 43.93779815 | -71.82057197 | 2022-12-15 04:20:58 | Grafton, New Hampshire, US | |
350459 | 350459 | 2022-12-14 | US | New Hampshire | Hillsborough | 33011 | 117015 | 997 | 0 | 42.91537785 | -71.7200253 | 2022-12-15 04:20:58 | Hillsborough, New Hampshire, US | |
350460 | 350460 | 2022-12-14 | US | New Hampshire | Merrimack | 33013 | 38723 | 278 | 0 | 43.29662971 | -71.6811573 | 2022-12-15 04:20:58 | Merrimack, New Hampshire, US | |
350461 | 350461 | 2022-12-14 | US | New Hampshire | Rockingham | 33015 | 81410 | 616 | 0 | 42.98499744 | -71.12883377 | 2022-12-15 04:20:58 | Rockingham, New Hampshire, US | |
350462 | 350462 | 2022-12-14 | US | New Hampshire | Strafford | 33017 | 35632 | 239 | 0 | 43.291833 | -71.02336013 | 2022-12-15 04:20:58 | Strafford, New Hampshire, US | |
350463 | 350463 | 2022-12-14 | US | New Hampshire | Sullivan | 33019 | 11490 | 80 | 0 | 43.36094111 | -72.22203125 | 2022-12-15 04:20:58 | Sullivan, New Hampshire, US | |
350464 | 350464 | 2022-12-14 | US | New Hampshire | Unassigned | 90033 | 2094 | 6 | 0 | 44.69063265 | 0.0 | 2022-12-15 04:20:58 | Unassigned, New Hampshire, US | |
310042 | 310042 | 2022-12-13 | US | New Hampshire | Belknap | 33001 | 16725 | 202 | 0 | 43.51637314 | -71.41684235 | 2022-12-14 04:21:04 | Belknap, New Hampshire, US | |
310043 | 310043 | 2022-12-13 | US | New Hampshire | Carroll | 33003 | 11886 | 70 | 0 | 43.87498583 | -71.20430216 | 2022-12-14 04:21:04 | Carroll, New Hampshire, US | |
310044 | 310044 | 2022-12-13 | US | New Hampshire | Cheshire | 33005 | 18360 | 131 | 0 | 42.92015988 | -72.25311043 | 2022-12-14 04:21:04 | Cheshire, New Hampshire, US | |
310045 | 310045 | 2022-12-13 | US | New Hampshire | Coos | 33007 | 8117 | 130 | 0 | 44.69063265 | -71.30633239 | 2022-12-14 04:21:04 | Coos, New Hampshire, US | |
310046 | 310046 | 2022-12-13 | US | New Hampshire | Grafton | 33009 | 22499 | 86 | 0 | 43.93779815 | -71.82057197 | 2022-12-14 04:21:04 | Grafton, New Hampshire, US | |
310047 | 310047 | 2022-12-13 | US | New Hampshire | Hillsborough | 33011 | 116902 | 997 | 0 | 42.91537785 | -71.7200253 | 2022-12-14 04:21:04 | Hillsborough, New Hampshire, US | |
310048 | 310048 | 2022-12-13 | US | New Hampshire | Merrimack | 33013 | 38689 | 278 | 0 | 43.29662971 | -71.6811573 | 2022-12-14 04:21:04 | Merrimack, New Hampshire, US | |
310049 | 310049 | 2022-12-13 | US | New Hampshire | Rockingham | 33015 | 81342 | 616 | 0 | 42.98499744 | -71.12883377 | 2022-12-14 04:21:04 | Rockingham, New Hampshire, US | |
310050 | 310050 | 2022-12-13 | US | New Hampshire | Strafford | 33017 | 35605 | 239 | 0 | 43.291833 | -71.02336013 | 2022-12-14 04:21:04 | Strafford, New Hampshire, US | |
310051 | 310051 | 2022-12-13 | US | New Hampshire | Sullivan | 33019 | 11478 | 80 | 0 | 43.36094111 | -72.22203125 | 2022-12-14 04:21:04 | Sullivan, New Hampshire, US | |
310052 | 310052 | 2022-12-13 | US | New Hampshire | Unassigned | 90033 | 2074 | 6 | 0 | 44.69063265 | 0.0 | 2022-12-14 04:21:04 | Unassigned, New Hampshire, US | |
1151103 | 1151103 | 2022-12-12 | US | New Hampshire | Belknap | 33001 | 16716 | 202 | 0 | 43.51637314 | -71.41684235 | 2022-12-13 04:21:01 | Belknap, New Hampshire, US | |
1151104 | 1151104 | 2022-12-12 | US | New Hampshire | Carroll | 33003 | 11883 | 70 | 0 | 43.87498583 | -71.20430216 | 2022-12-13 04:21:01 | Carroll, New Hampshire, US | |
1151105 | 1151105 | 2022-12-12 | US | New Hampshire | Cheshire | 33005 | 18355 | 131 | 0 | 42.92015988 | -72.25311043 | 2022-12-13 04:21:01 | Cheshire, New Hampshire, US | |
1151106 | 1151106 | 2022-12-12 | US | New Hampshire | Coos | 33007 | 8116 | 130 | 0 | 44.69063265 | -71.30633239 | 2022-12-13 04:21:01 | Coos, New Hampshire, US | |
1151107 | 1151107 | 2022-12-12 | US | New Hampshire | Grafton | 33009 | 22488 | 86 | 0 | 43.93779815 | -71.82057197 | 2022-12-13 04:21:01 | Grafton, New Hampshire, US | |
1151108 | 1151108 | 2022-12-12 | US | New Hampshire | Hillsborough | 33011 | 116826 | 997 | 0 | 42.91537785 | -71.7200253 | 2022-12-13 04:21:01 | Hillsborough, New Hampshire, US | |
1151109 | 1151109 | 2022-12-12 | US | New Hampshire | Merrimack | 33013 | 38669 | 278 | 0 | 43.29662971 | -71.6811573 | 2022-12-13 04:21:01 | Merrimack, New Hampshire, US | |
1151110 | 1151110 | 2022-12-12 | US | New Hampshire | Rockingham | 33015 | 81306 | 615 | 0 | 42.98499744 | -71.12883377 | 2022-12-13 04:21:01 | Rockingham, New Hampshire, US | |
1151111 | 1151111 | 2022-12-12 | US | New Hampshire | Strafford | 33017 | 35599 | 239 | 0 | 43.291833 | -71.02336013 | 2022-12-13 04:21:01 | Strafford, New Hampshire, US | |
1151112 | 1151112 | 2022-12-12 | US | New Hampshire | Sullivan | 33019 | 11464 | 80 | 0 | 43.36094111 | -72.22203125 | 2022-12-13 04:21:01 | Sullivan, New Hampshire, US | |
1151113 | 1151113 | 2022-12-12 | US | New Hampshire | Unassigned | 90033 | 2063 | 6 | 0 | 44.69063265 | 0.0 | 2022-12-13 04:21:01 | Unassigned, New Hampshire, US | |
870957 | 870957 | 2022-12-11 | US | New Hampshire | Belknap | 33001 | 16699 | 202 | 0 | 43.51637314 | -71.41684235 | 2022-12-12 04:21:01 | Belknap, New Hampshire, US | |
870958 | 870958 | 2022-12-11 | US | New Hampshire | Carroll | 33003 | 11864 | 70 | 0 | 43.87498583 | -71.20430216 | 2022-12-12 04:21:01 | Carroll, 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]);