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 rowid
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2483 | 2483 | 2021-12-02 | US | New Hampshire | Belknap | 33001 | 7875 | 134 | 0 | 43.51637314 | -71.41684235 | 2021-12-03 04:23:05 | Belknap, New Hampshire, US | |
2484 | 2484 | 2021-12-02 | US | New Hampshire | Carroll | 33003 | 5081 | 23 | 0 | 43.87498583 | -71.20430216 | 2021-12-03 04:23:05 | Carroll, New Hampshire, US | |
2485 | 2485 | 2021-12-02 | US | New Hampshire | Cheshire | 33005 | 7207 | 59 | 0 | 42.92015988 | -72.25311043 | 2021-12-03 04:23:05 | Cheshire, New Hampshire, US | |
2486 | 2486 | 2021-12-02 | US | New Hampshire | Coos | 33007 | 4179 | 74 | 0 | 44.69063265 | -71.30633239 | 2021-12-03 04:23:05 | Coos, New Hampshire, US | |
2487 | 2487 | 2021-12-02 | US | New Hampshire | Grafton | 33009 | 7832 | 38 | 0 | 43.93779815 | -71.82057197 | 2021-12-03 04:23:05 | Grafton, New Hampshire, US | |
2488 | 2488 | 2021-12-02 | US | New Hampshire | Hillsborough | 33011 | 55058 | 723 | 0 | 42.91537785 | -71.7200253 | 2021-12-03 04:23:05 | Hillsborough, New Hampshire, US | |
2489 | 2489 | 2021-12-02 | US | New Hampshire | Merrimack | 33013 | 17034 | 149 | 0 | 43.29662971 | -71.6811573 | 2021-12-03 04:23:05 | Merrimack, New Hampshire, US | |
2490 | 2490 | 2021-12-02 | US | New Hampshire | Rockingham | 33015 | 36975 | 340 | 0 | 42.98499744 | -71.12883377 | 2021-12-03 04:23:05 | Rockingham, New Hampshire, US | |
2491 | 2491 | 2021-12-02 | US | New Hampshire | Strafford | 33017 | 16215 | 142 | 0 | 43.291833000000004 | -71.02336013 | 2021-12-03 04:23:05 | Strafford, New Hampshire, US | |
2492 | 2492 | 2021-12-02 | US | New Hampshire | Sullivan | 33019 | 4952 | 40 | 0 | 43.36094111 | -72.22203125 | 2021-12-03 04:23:05 | Sullivan, New Hampshire, US | |
2493 | 2493 | 2021-12-02 | US | New Hampshire | Unassigned | 90033 | 1553 | 10 | 0 | 44.69063265 | 0.0 | 2021-12-03 04:23:05 | Unassigned, New Hampshire, US | |
6498 | 6498 | 2021-10-28 | US | New Hampshire | Belknap | 33001 | 6183 | 124 | 0 | 43.51637314 | -71.41684235 | 2021-10-29 04:22:03 | Belknap, New Hampshire, US | |
6499 | 6499 | 2021-10-28 | US | New Hampshire | Carroll | 33003 | 3770 | 19 | 0 | 43.87498583 | -71.20430216 | 2021-10-29 04:22:03 | Carroll, New Hampshire, US | |
6500 | 6500 | 2021-10-28 | US | New Hampshire | Cheshire | 33005 | 5715 | 49 | 0 | 42.92015988 | -72.25311043 | 2021-10-29 04:22:03 | Cheshire, New Hampshire, US | |
6501 | 6501 | 2021-10-28 | US | New Hampshire | Coos | 33007 | 3424 | 53 | 0 | 44.69063265 | -71.30633239 | 2021-10-29 04:22:03 | Coos, New Hampshire, US | |
6502 | 6502 | 2021-10-28 | US | New Hampshire | Grafton | 33009 | 5923 | 30 | 0 | 43.93779815 | -71.82057197 | 2021-10-29 04:22:03 | Grafton, New Hampshire, US | |
6503 | 6503 | 2021-10-28 | US | New Hampshire | Hillsborough | 33011 | 45720 | 677 | 0 | 42.91537785 | -71.7200253 | 2021-10-29 04:22:03 | Hillsborough, New Hampshire, US | |
6504 | 6504 | 2021-10-28 | US | New Hampshire | Merrimack | 33013 | 13471 | 131 | 0 | 43.29662971 | -71.6811573 | 2021-10-29 04:22:03 | Merrimack, New Hampshire, US | |
6505 | 6505 | 2021-10-28 | US | New Hampshire | Rockingham | 33015 | 31041 | 303 | 0 | 42.98499744 | -71.12883377 | 2021-10-29 04:22:03 | Rockingham, New Hampshire, US | |
6506 | 6506 | 2021-10-28 | US | New Hampshire | Strafford | 33017 | 13220 | 121 | 0 | 43.291833000000004 | -71.02336013 | 2021-10-29 04:22:03 | Strafford, New Hampshire, US | |
6507 | 6507 | 2021-10-28 | US | New Hampshire | Sullivan | 33019 | 3321 | 36 | 0 | 43.36094111 | -72.22203125 | 2021-10-29 04:22:03 | Sullivan, New Hampshire, US | |
6508 | 6508 | 2021-10-28 | US | New Hampshire | Unassigned | 90033 | 653 | 1 | 0 | 44.69063265 | 0.0 | 2021-10-29 04:22:03 | Unassigned, New Hampshire, US | |
10470 | 10470 | 2020-10-25 | US | New Hampshire | Belknap | 33001 | 223 | 5 | 0 | 218 | 43.51637314 | -71.41684235 | 2020-10-26 04:25:02 | Belknap, New Hampshire, US |
10471 | 10471 | 2020-10-25 | US | New Hampshire | Carroll | 33003 | 142 | 2 | 0 | 140 | 43.87498583 | -71.20430216 | 2020-10-26 04:25:02 | Carroll, New Hampshire, US |
10472 | 10472 | 2020-10-25 | US | New Hampshire | Cheshire | 33005 | 182 | 3 | 0 | 179 | 42.92015988 | -72.25311043 | 2020-10-26 04:25:02 | Cheshire, New Hampshire, US |
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 |
10474 | 10474 | 2020-10-25 | US | New Hampshire | Grafton | 33009 | 196 | 1 | 0 | 195 | 43.93779815 | -71.82057197 | 2020-10-26 04:25:02 | Grafton, New Hampshire, US |
10475 | 10475 | 2020-10-25 | US | New Hampshire | Hillsborough | 33011 | 5367 | 315 | 0 | 5052 | 42.91537785 | -71.7200253 | 2020-10-26 04:25:02 | Hillsborough, New Hampshire, US |
10476 | 10476 | 2020-10-25 | US | New Hampshire | Merrimack | 33013 | 852 | 27 | 0 | 825 | 43.29662971 | -71.6811573 | 2020-10-26 04:25:02 | Merrimack, New Hampshire, US |
10477 | 10477 | 2020-10-25 | US | New Hampshire | Rockingham | 33015 | 2534 | 105 | 0 | 2429 | 42.98499744 | -71.12883377 | 2020-10-26 04:25:02 | Rockingham, New Hampshire, US |
10478 | 10478 | 2020-10-25 | US | New Hampshire | Strafford | 33017 | 699 | 14 | 0 | 685 | 43.291833 | -71.02336013 | 2020-10-26 04:25:02 | Strafford, New Hampshire, US |
10479 | 10479 | 2020-10-25 | US | New Hampshire | Sullivan | 33019 | 76 | 1 | 0 | 75 | 43.36094111 | -72.22203125 | 2020-10-26 04:25:02 | Sullivan, 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 |
14483 | 14483 | 2021-01-26 | US | New Hampshire | Belknap | 33001 | 2701 | 85 | 0 | 2616 | 43.51637314 | -71.41684235 | 2021-01-27 05:23:41 | Belknap, New Hampshire, US |
14484 | 14484 | 2021-01-26 | US | New Hampshire | Carroll | 33003 | 1401 | 4 | 0 | 1397 | 43.87498583 | -71.20430216 | 2021-01-27 05:23:41 | Carroll, New Hampshire, US |
14485 | 14485 | 2021-01-26 | US | New Hampshire | Cheshire | 33005 | 2156 | 12 | 0 | 2144 | 42.92015988 | -72.25311043 | 2021-01-27 05:23:41 | Cheshire, New Hampshire, US |
14486 | 14486 | 2021-01-26 | US | New Hampshire | Coos | 33007 | 1109 | 24 | 0 | 1085 | 44.69063265 | -71.30633239 | 2021-01-27 05:23:41 | Coos, New Hampshire, US |
14487 | 14487 | 2021-01-26 | US | New Hampshire | Grafton | 33009 | 1850 | 13 | 0 | 1837 | 43.93779815 | -71.82057197 | 2021-01-27 05:23:41 | Grafton, New Hampshire, US |
14488 | 14488 | 2021-01-26 | US | New Hampshire | Hillsborough | 33011 | 24697 | 523 | 0 | 24174 | 42.91537785 | -71.7200253 | 2021-01-27 05:23:41 | Hillsborough, New Hampshire, US |
14489 | 14489 | 2021-01-26 | US | New Hampshire | Merrimack | 33013 | 6432 | 92 | 0 | 6340 | 43.29662971 | -71.6811573 | 2021-01-27 05:23:41 | Merrimack, New Hampshire, US |
14490 | 14490 | 2021-01-26 | US | New Hampshire | Rockingham | 33015 | 15377 | 176 | 0 | 15201 | 42.98499744 | -71.12883377 | 2021-01-27 05:23:41 | Rockingham, New Hampshire, US |
14491 | 14491 | 2021-01-26 | US | New Hampshire | Strafford | 33017 | 5358 | 51 | 0 | 5307 | 43.291833 | -71.02336013 | 2021-01-27 05:23:41 | Strafford, New Hampshire, US |
14492 | 14492 | 2021-01-26 | US | New Hampshire | Sullivan | 33019 | 997 | 13 | 0 | 984 | 43.36094111 | -72.22203125 | 2021-01-27 05:23:41 | Sullivan, New Hampshire, US |
14493 | 14493 | 2021-01-26 | US | New Hampshire | Unassigned | 90033 | 1289 | 1 | 0 | 1288 | 44.69063265 | 0.0 | 2021-01-27 05:23:41 | Unassigned, New Hampshire, US |
18505 | 18505 | 2021-09-18 | US | New Hampshire | Belknap | 33001 | 5120 | 111 | 0 | 43.51637314 | -71.41684235 | 2021-09-19 04:21:34 | Belknap, New Hampshire, US | |
18506 | 18506 | 2021-09-18 | US | New Hampshire | Carroll | 33003 | 3071 | 17 | 0 | 43.87498583 | -71.20430216 | 2021-09-19 04:21:34 | Carroll, New Hampshire, US | |
18507 | 18507 | 2021-09-18 | US | New Hampshire | Cheshire | 33005 | 4724 | 43 | 0 | 42.92015988 | -72.25311043 | 2021-09-19 04:21:34 | Cheshire, New Hampshire, US | |
18508 | 18508 | 2021-09-18 | US | New Hampshire | Coos | 33007 | 2404 | 46 | 0 | 44.69063265 | -71.30633239 | 2021-09-19 04:21:34 | Coos, New Hampshire, US | |
18509 | 18509 | 2021-09-18 | US | New Hampshire | Grafton | 33009 | 4871 | 30 | 0 | 43.93779815 | -71.82057197 | 2021-09-19 04:21:34 | Grafton, New Hampshire, US | |
18510 | 18510 | 2021-09-18 | US | New Hampshire | Hillsborough | 33011 | 40585 | 662 | 0 | 42.91537785 | -71.7200253 | 2021-09-19 04:21:34 | Hillsborough, New Hampshire, US | |
18511 | 18511 | 2021-09-18 | US | New Hampshire | Merrimack | 33013 | 11241 | 125 | 0 | 43.29662971 | -71.6811573 | 2021-09-19 04:21:34 | Merrimack, New Hampshire, US | |
18512 | 18512 | 2021-09-18 | US | New Hampshire | Rockingham | 33015 | 27747 | 286 | 0 | 42.98499744 | -71.12883377 | 2021-09-19 04:21:34 | Rockingham, New Hampshire, US | |
18513 | 18513 | 2021-09-18 | US | New Hampshire | Strafford | 33017 | 11540 | 105 | 0 | 43.291833000000004 | -71.02336013 | 2021-09-19 04:21:34 | Strafford, New Hampshire, US | |
18514 | 18514 | 2021-09-18 | US | New Hampshire | Sullivan | 33019 | 2279 | 31 | 0 | 43.36094111 | -72.22203125 | 2021-09-19 04:21:34 | Sullivan, New Hampshire, US | |
18515 | 18515 | 2021-09-18 | US | New Hampshire | Unassigned | 90033 | 740 | 1 | 0 | 44.69063265 | 0.0 | 2021-09-19 04:21:34 | Unassigned, New Hampshire, US | |
22516 | 22516 | 2021-05-28 | US | New Hampshire | Belknap | 33001 | 4102 | 100 | 0 | 43.51637314 | -71.41684235 | 2021-05-29 04:20:41 | Belknap, New Hampshire, US | |
22517 | 22517 | 2021-05-28 | US | New Hampshire | Carroll | 33003 | 2458 | 11 | 0 | 43.87498583 | -71.20430216 | 2021-05-29 04:20:41 | Carroll, New Hampshire, US | |
22518 | 22518 | 2021-05-28 | US | New Hampshire | Cheshire | 33005 | 3855 | 34 | 0 | 42.92015988 | -72.25311043 | 2021-05-29 04:20:41 | Cheshire, New Hampshire, US | |
22519 | 22519 | 2021-05-28 | US | New Hampshire | Coos | 33007 | 2028 | 41 | 0 | 44.69063265 | -71.30633239 | 2021-05-29 04:20:41 | Coos, New Hampshire, US | |
22520 | 22520 | 2021-05-28 | US | New Hampshire | Grafton | 33009 | 4023 | 26 | 0 | 43.93779815 | -71.82057197 | 2021-05-29 04:20:41 | Grafton, New Hampshire, US | |
22521 | 22521 | 2021-05-28 | US | New Hampshire | Hillsborough | 33011 | 36124 | 643 | 0 | 42.91537785 | -71.7200253 | 2021-05-29 04:20:41 | Hillsborough, New Hampshire, US | |
22522 | 22522 | 2021-05-28 | US | New Hampshire | Merrimack | 33013 | 9602 | 116 | 0 | 43.29662971 | -71.6811573 | 2021-05-29 04:20:41 | Merrimack, New Hampshire, US | |
22523 | 22523 | 2021-05-28 | US | New Hampshire | Rockingham | 33015 | 24240 | 262 | 0 | 42.98499744 | -71.12883377 | 2021-05-29 04:20:41 | Rockingham, New Hampshire, US | |
22524 | 22524 | 2021-05-28 | US | New Hampshire | Strafford | 33017 | 9887 | 92 | 0 | 43.291833 | -71.02336013 | 2021-05-29 04:20:41 | Strafford, New Hampshire, US | |
22525 | 22525 | 2021-05-28 | US | New Hampshire | Sullivan | 33019 | 1804 | 25 | 0 | 43.36094111 | -72.22203125 | 2021-05-29 04:20:41 | Sullivan, New Hampshire, US | |
22526 | 22526 | 2021-05-28 | US | New Hampshire | Unassigned | 90033 | 527 | 1 | 0 | 44.69063265 | 0.0 | 2021-05-29 04:20:41 | Unassigned, New Hampshire, US | |
26554 | 26554 | 2022-03-20 | US | New Hampshire | Belknap | 33001 | 13380 | 172 | 0 | 43.51637314 | -71.41684235 | 2022-03-21 04:20:50 | Belknap, New Hampshire, US | |
26555 | 26555 | 2022-03-20 | US | New Hampshire | Carroll | 33003 | 9158 | 56 | 0 | 43.87498583 | -71.20430216 | 2022-03-21 04:20:50 | Carroll, New Hampshire, US | |
26556 | 26556 | 2022-03-20 | US | New Hampshire | Cheshire | 33005 | 14456 | 108 | 0 | 42.92015988 | -72.25311043 | 2022-03-21 04:20:50 | Cheshire, New Hampshire, US | |
26557 | 26557 | 2022-03-20 | US | New Hampshire | Coos | 33007 | 6810 | 110 | 0 | 44.69063265 | -71.30633239 | 2022-03-21 04:20:50 | Coos, New Hampshire, US | |
26558 | 26558 | 2022-03-20 | US | New Hampshire | Grafton | 33009 | 17154 | 63 | 0 | 43.93779815 | -71.82057197 | 2022-03-21 04:20:50 | Grafton, New Hampshire, US | |
26559 | 26559 | 2022-03-20 | US | New Hampshire | Hillsborough | 33011 | 96311 | 890 | 0 | 42.91537785 | -71.7200253 | 2022-03-21 04:20:50 | Hillsborough, New Hampshire, US | |
26560 | 26560 | 2022-03-20 | US | New Hampshire | Merrimack | 33013 | 31815 | 222 | 0 | 43.29662971 | -71.6811573 | 2022-03-21 04:20:50 | Merrimack, New Hampshire, US | |
26561 | 26561 | 2022-03-20 | US | New Hampshire | Rockingham | 33015 | 66086 | 516 | 0 | 42.98499744 | -71.12883377 | 2022-03-21 04:20:50 | Rockingham, New Hampshire, US | |
26562 | 26562 | 2022-03-20 | US | New Hampshire | Strafford | 33017 | 28659 | 204 | 0 | 43.291833000000004 | -71.02336013 | 2022-03-21 04:20:50 | Strafford, New Hampshire, US | |
26563 | 26563 | 2022-03-20 | US | New Hampshire | Sullivan | 33019 | 9146 | 67 | 0 | 43.36094111 | -72.22203125 | 2022-03-21 04:20:50 | Sullivan, New Hampshire, US | |
26564 | 26564 | 2022-03-20 | US | New Hampshire | Unassigned | 90033 | 7966 | 26 | 0 | 44.69063265 | 0.0 | 2022-03-21 04:20:50 | Unassigned, New Hampshire, US | |
30569 | 30569 | 2021-11-11 | US | New Hampshire | Belknap | 33001 | 6807 | 129 | 0 | 43.51637314 | -71.41684235 | 2021-11-12 04:22:01 | Belknap, New Hampshire, US | |
30570 | 30570 | 2021-11-11 | US | New Hampshire | Carroll | 33003 | 4231 | 20 | 0 | 43.87498583 | -71.20430216 | 2021-11-12 04:22:01 | Carroll, New Hampshire, US | |
30571 | 30571 | 2021-11-11 | US | New Hampshire | Cheshire | 33005 | 6204 | 52 | 0 | 42.92015988 | -72.25311043 | 2021-11-12 04:22:01 | Cheshire, New Hampshire, US | |
30572 | 30572 | 2021-11-11 | US | New Hampshire | Coos | 33007 | 3758 | 66 | 0 | 44.69063265 | -71.30633239 | 2021-11-12 04:22:01 | Coos, New Hampshire, US | |
30573 | 30573 | 2021-11-11 | US | New Hampshire | Grafton | 33009 | 6513 | 35 | 0 | 43.93779815 | -71.82057197 | 2021-11-12 04:22:01 | Grafton, New Hampshire, US | |
30574 | 30574 | 2021-11-11 | US | New Hampshire | Hillsborough | 33011 | 48558 | 695 | 0 | 42.91537785 | -71.7200253 | 2021-11-12 04:22:01 | Hillsborough, New Hampshire, US | |
30575 | 30575 | 2021-11-11 | US | New Hampshire | Merrimack | 33013 | 14640 | 138 | 0 | 43.29662971 | -71.6811573 | 2021-11-12 04:22:01 | Merrimack, New Hampshire, US | |
30576 | 30576 | 2021-11-11 | US | New Hampshire | Rockingham | 33015 | 32868 | 314 | 0 | 42.98499744 | -71.12883377 | 2021-11-12 04:22:01 | Rockingham, New Hampshire, US | |
30577 | 30577 | 2021-11-11 | US | New Hampshire | Strafford | 33017 | 14229 | 127 | 0 | 43.291833000000004 | -71.02336013 | 2021-11-12 04:22:01 | Strafford, New Hampshire, US | |
30578 | 30578 | 2021-11-11 | US | New Hampshire | Sullivan | 33019 | 3824 | 37 | 0 | 43.36094111 | -72.22203125 | 2021-11-12 04:22:01 | Sullivan, New Hampshire, US | |
30579 | 30579 | 2021-11-11 | US | New Hampshire | Unassigned | 90033 | 837 | 4 | 0 | 44.69063265 | 0.0 | 2021-11-12 04:22:01 | Unassigned, New Hampshire, US | |
34565 | 34565 | 2021-08-25 | US | New Hampshire | Belknap | 33001 | 4574 | 104 | 0 | 43.51637314 | -71.41684235 | 2021-08-26 04:21:28 | Belknap, New Hampshire, US | |
34566 | 34566 | 2021-08-25 | US | New Hampshire | Carroll | 33003 | 2710 | 13 | 0 | 43.87498583 | -71.20430216 | 2021-08-26 04:21:28 | Carroll, New Hampshire, US | |
34567 | 34567 | 2021-08-25 | US | New Hampshire | Cheshire | 33005 | 4238 | 36 | 0 | 42.92015988 | -72.25311043 | 2021-08-26 04:21:28 | Cheshire, New Hampshire, US | |
34568 | 34568 | 2021-08-25 | US | New Hampshire | Coos | 33007 | 2225 | 45 | 0 | 44.69063265 | -71.30633239 | 2021-08-26 04:21:28 | Coos, New Hampshire, US | |
34569 | 34569 | 2021-08-25 | US | New Hampshire | Grafton | 33009 | 4467 | 30 | 0 | 43.93779815 | -71.82057197 | 2021-08-26 04:21:28 | Grafton, New Hampshire, US | |
34570 | 34570 | 2021-08-25 | US | New Hampshire | Hillsborough | 33011 | 38241 | 654 | 0 | 42.91537785 | -71.7200253 | 2021-08-26 04:21:28 | Hillsborough, New Hampshire, US | |
34571 | 34571 | 2021-08-25 | US | New Hampshire | Merrimack | 33013 | 10269 | 120 | 0 | 43.29662971 | -71.6811573 | 2021-08-26 04:21:28 | Merrimack, New Hampshire, US | |
34572 | 34572 | 2021-08-25 | US | New Hampshire | Rockingham | 33015 | 25867 | 276 | 0 | 42.98499744 | -71.12883377 | 2021-08-26 04:21:28 | Rockingham, New Hampshire, US | |
34573 | 34573 | 2021-08-25 | US | New Hampshire | Strafford | 33017 | 10700 | 101 | 0 | 43.291833000000004 | -71.02336013 | 2021-08-26 04:21:28 | Strafford, New Hampshire, US | |
34574 | 34574 | 2021-08-25 | US | New Hampshire | Sullivan | 33019 | 2065 | 28 | 0 | 43.36094111 | -72.22203125 | 2021-08-26 04:21:28 | Sullivan, New Hampshire, US | |
34575 | 34575 | 2021-08-25 | US | New Hampshire | Unassigned | 90033 | 527 | 1 | 0 | 44.69063265 | 0.0 | 2021-08-26 04:21:28 | Unassigned, New Hampshire, US | |
38575 | 38575 | 2021-04-12 | US | New Hampshire | Belknap | 33001 | 3575 | 96 | 0 | 43.51637314 | -71.41684235 | 2021-04-13 04:20:37 | 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]);