johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,354 rows where deaths = 145 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
- US 4,018
- Japan 45
- Russia 37
- Antigua and Barbuda 33
- Pakistan 24
- Sweden 24
- Spain 23
- Burkina Faso 12
- Chile 11
- Colombia 10
- Trinidad and Tobago 10
- Malaysia 9
- Andorra 8
- Peru 8
- India 7
- France 6
- Germany 6
- Netherlands 6
- Mexico 5
- Namibia 5
- Italy 4
- Ukraine 3
- Brazil 2
- Cabo Verde 2
- Croatia 2
- Gabon 2
- Haiti 2
- Mozambique 2
- Senegal 2
- Slovenia 2
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2754975 | 2754975 | 2022-12-29 | US | Nebraska | Dodge | 31053 | 11408 | 145 | 0 | 41.58071748 | -96.65598179 | 2022-12-30 04:21:04 | Dodge, Nebraska, US | |
2754399 | 2754399 | 2022-12-29 | US | Louisiana | Beauregard | 22011 | 10892 | 145 | 0 | 30.64836518 | -93.34173616 | 2022-12-30 04:21:04 | Beauregard, Louisiana, US | |
2754341 | 2754341 | 2022-12-29 | US | Kentucky | Lincoln | 21137 | 8548 | 145 | 0 | 37.45475628 | -84.6565327 | 2022-12-30 04:21:04 | Lincoln, Kentucky, US | |
2753550 | 2753550 | 2022-12-29 | US | Colorado | Morgan | 8087 | 6812 | 145 | 0 | 40.2627981 | -103.8093302 | 2022-12-30 04:21:04 | Morgan, Colorado, US | |
1076187 | 1076187 | 2022-12-28 | US | New York | Sullivan | 36105 | 23803 | 145 | 0 | 41.71579493 | -74.76394559 | 2022-12-29 04:21:01 | Sullivan, New York, US | |
1075981 | 1075981 | 2022-12-28 | US | Nebraska | Dodge | 31053 | 11408 | 145 | 0 | 41.58071748 | -96.65598179 | 2022-12-29 04:21:01 | Dodge, Nebraska, US | |
1075405 | 1075405 | 2022-12-28 | US | Louisiana | Beauregard | 22011 | 10892 | 145 | 0 | 30.64836518 | -93.34173616 | 2022-12-29 04:21:01 | Beauregard, Louisiana, US | |
1075347 | 1075347 | 2022-12-28 | US | Kentucky | Lincoln | 21137 | 8548 | 145 | 0 | 37.45475628 | -84.6565327 | 2022-12-29 04:21:01 | Lincoln, Kentucky, US | |
1074556 | 1074556 | 2022-12-28 | US | Colorado | Morgan | 8087 | 6811 | 145 | 0 | 40.2627981 | -103.8093302 | 2022-12-29 04:21:01 | Morgan, Colorado, US | |
330184 | 330184 | 2022-12-27 | US | New York | Sullivan | 36105 | 23774 | 145 | 0 | 41.71579493 | -74.76394559 | 2022-12-28 04:21:04 | Sullivan, New York, US | |
329978 | 329978 | 2022-12-27 | US | Nebraska | Dodge | 31053 | 11408 | 145 | 0 | 41.58071748 | -96.65598179 | 2022-12-28 04:21:04 | Dodge, Nebraska, US | |
329402 | 329402 | 2022-12-27 | US | Louisiana | Beauregard | 22011 | 10858 | 145 | 0 | 30.64836518 | -93.34173616 | 2022-12-28 04:21:04 | Beauregard, Louisiana, US | |
329344 | 329344 | 2022-12-27 | US | Kentucky | Lincoln | 21137 | 8548 | 145 | 0 | 37.45475628 | -84.6565327 | 2022-12-28 04:21:04 | Lincoln, Kentucky, US | |
328553 | 328553 | 2022-12-27 | US | Colorado | Morgan | 8087 | 6808 | 145 | 0 | 40.2627981 | -103.8093302 | 2022-12-28 04:21:04 | Morgan, Colorado, US | |
220257 | 220257 | 2022-12-26 | US | New York | Sullivan | 36105 | 23767 | 145 | 0 | 41.71579493 | -74.76394559 | 2022-12-27 04:21:07 | Sullivan, New York, US | |
220051 | 220051 | 2022-12-26 | US | Nebraska | Dodge | 31053 | 11408 | 145 | 0 | 41.58071748 | -96.65598179 | 2022-12-27 04:21:07 | Dodge, Nebraska, US | |
219475 | 219475 | 2022-12-26 | US | Louisiana | Beauregard | 22011 | 10858 | 145 | 0 | 30.64836518 | -93.34173616 | 2022-12-27 04:21:07 | Beauregard, Louisiana, US | |
219417 | 219417 | 2022-12-26 | US | Kentucky | Lincoln | 21137 | 8496 | 145 | 0 | 37.45475628 | -84.6565327 | 2022-12-27 04:21:07 | Lincoln, Kentucky, US | |
218626 | 218626 | 2022-12-26 | US | Colorado | Morgan | 8087 | 6808 | 145 | 0 | 40.2627981 | -103.8093302 | 2022-12-27 04:21:07 | Morgan, Colorado, US | |
3224714 | 3224714 | 2022-12-25 | US | New York | Sullivan | 36105 | 23752 | 145 | 0 | 41.71579493 | -74.76394559 | 2022-12-26 04:21:06 | Sullivan, New York, US | |
3224508 | 3224508 | 2022-12-25 | US | Nebraska | Dodge | 31053 | 11408 | 145 | 0 | 41.58071748 | -96.65598179 | 2022-12-26 04:21:06 | Dodge, Nebraska, US | |
3223932 | 3223932 | 2022-12-25 | US | Louisiana | Beauregard | 22011 | 10858 | 145 | 0 | 30.64836518 | -93.34173616 | 2022-12-26 04:21:06 | Beauregard, Louisiana, US | |
3223874 | 3223874 | 2022-12-25 | US | Kentucky | Lincoln | 21137 | 8496 | 145 | 0 | 37.45475628 | -84.6565327 | 2022-12-26 04:21:06 | Lincoln, Kentucky, US | |
3223083 | 3223083 | 2022-12-25 | US | Colorado | Morgan | 8087 | 6805 | 145 | 0 | 40.2627981 | -103.8093302 | 2022-12-26 04:21:06 | Morgan, Colorado, US | |
1020628 | 1020628 | 2022-12-24 | US | New York | Sullivan | 36105 | 23729 | 145 | 0 | 41.71579493 | -74.76394559 | 2022-12-25 04:21:04 | Sullivan, New York, US | |
1020422 | 1020422 | 2022-12-24 | US | Nebraska | Dodge | 31053 | 11408 | 145 | 0 | 41.58071748 | -96.65598179 | 2022-12-25 04:21:04 | Dodge, Nebraska, US | |
1019846 | 1019846 | 2022-12-24 | US | Louisiana | Beauregard | 22011 | 10858 | 145 | 0 | 30.64836518 | -93.34173616 | 2022-12-25 04:21:04 | Beauregard, Louisiana, US | |
1019788 | 1019788 | 2022-12-24 | US | Kentucky | Lincoln | 21137 | 8496 | 145 | 0 | 37.45475628 | -84.6565327 | 2022-12-25 04:21:04 | Lincoln, Kentucky, US | |
1018997 | 1018997 | 2022-12-24 | US | Colorado | Morgan | 8087 | 6805 | 145 | 0 | 40.2627981 | -103.8093302 | 2022-12-25 04:21:04 | Morgan, Colorado, US | |
692651 | 692651 | 2022-12-23 | US | New York | Sullivan | 36105 | 23714 | 145 | 0 | 41.71579493 | -74.76394559 | 2022-12-24 04:21:02 | Sullivan, New York, US | |
692445 | 692445 | 2022-12-23 | US | Nebraska | Dodge | 31053 | 11408 | 145 | 0 | 41.58071748 | -96.65598179 | 2022-12-24 04:21:02 | Dodge, Nebraska, US | |
691869 | 691869 | 2022-12-23 | US | Louisiana | Beauregard | 22011 | 10858 | 145 | 0 | 30.64836518 | -93.34173616 | 2022-12-24 04:21:02 | Beauregard, Louisiana, US | |
691811 | 691811 | 2022-12-23 | US | Kentucky | Lincoln | 21137 | 8496 | 145 | 0 | 37.45475628 | -84.6565327 | 2022-12-24 04:21:02 | Lincoln, Kentucky, US | |
691020 | 691020 | 2022-12-23 | US | Colorado | Morgan | 8087 | 6805 | 145 | 0 | 40.2627981 | -103.8093302 | 2022-12-24 04:21:02 | Morgan, Colorado, US | |
690400 | 690400 | 2022-12-23 | Japan | Tottori | 102840 | 145 | 0 | 35.359069 | 133.863619 | 2022-12-24 04:21:02 | Tottori, Japan | |||
2181861 | 2181861 | 2022-12-22 | US | New York | Sullivan | 36105 | 23689 | 145 | 0 | 41.71579493 | -74.76394559 | 2022-12-23 04:21:04 | Sullivan, New York, US | |
2181655 | 2181655 | 2022-12-22 | US | Nebraska | Dodge | 31053 | 11408 | 145 | 0 | 41.58071748 | -96.65598179 | 2022-12-23 04:21:04 | Dodge, Nebraska, US | |
2181079 | 2181079 | 2022-12-22 | US | Louisiana | Beauregard | 22011 | 10858 | 145 | 0 | 30.64836518 | -93.34173616 | 2022-12-23 04:21:04 | Beauregard, Louisiana, US | |
2181021 | 2181021 | 2022-12-22 | US | Kentucky | Lincoln | 21137 | 8496 | 145 | 0 | 37.45475628 | -84.6565327 | 2022-12-23 04:21:04 | Lincoln, Kentucky, US | |
453459 | 453459 | 2022-12-21 | US | Nebraska | Dodge | 31053 | 11408 | 145 | 0 | 41.58071748 | -96.65598179 | 2022-12-22 04:20:56 | Dodge, Nebraska, US | |
452883 | 452883 | 2022-12-21 | US | Louisiana | Beauregard | 22011 | 10858 | 145 | 0 | 30.64836518 | -93.34173616 | 2022-12-22 04:20:56 | Beauregard, Louisiana, US | |
452825 | 452825 | 2022-12-21 | US | Kentucky | Lincoln | 21137 | 8496 | 145 | 0 | 37.45475628 | -84.6565327 | 2022-12-22 04:20:56 | Lincoln, Kentucky, US | |
2953683 | 2953683 | 2022-12-20 | US | North Carolina | Bladen | 37017 | 11294 | 145 | 0 | 34.61296243 | -78.56180059 | 2022-12-21 04:21:03 | Bladen, North Carolina, US | |
2953458 | 2953458 | 2022-12-20 | US | Nebraska | Dodge | 31053 | 11408 | 145 | 0 | 41.58071748 | -96.65598179 | 2022-12-21 04:21:03 | Dodge, Nebraska, US | |
2952882 | 2952882 | 2022-12-20 | US | Louisiana | Beauregard | 22011 | 10803 | 145 | 0 | 30.64836518 | -93.34173616 | 2022-12-21 04:21:03 | Beauregard, Louisiana, US | |
2952824 | 2952824 | 2022-12-20 | US | Kentucky | Lincoln | 21137 | 8496 | 145 | 0 | 37.45475628 | -84.6565327 | 2022-12-21 04:21:03 | Lincoln, Kentucky, US | |
3176085 | 3176085 | 2022-12-19 | US | North Carolina | Bladen | 37017 | 11294 | 145 | 0 | 34.61296243 | -78.56180059 | 2022-12-20 04:21:04 | Bladen, North Carolina, US | |
3175860 | 3175860 | 2022-12-19 | US | Nebraska | Dodge | 31053 | 11408 | 145 | 0 | 41.58071748 | -96.65598179 | 2022-12-20 04:21:04 | Dodge, Nebraska, US | |
3175284 | 3175284 | 2022-12-19 | US | Louisiana | Beauregard | 22011 | 10803 | 145 | 0 | 30.64836518 | -93.34173616 | 2022-12-20 04:21:04 | Beauregard, Louisiana, US | |
3175226 | 3175226 | 2022-12-19 | US | Kentucky | Lincoln | 21137 | 8496 | 145 | 0 | 37.45475628 | -84.6565327 | 2022-12-20 04:21:04 | Lincoln, Kentucky, US | |
1630602 | 1630602 | 2022-12-18 | US | North Carolina | Bladen | 37017 | 11294 | 145 | 0 | 34.61296243 | -78.56180059 | 2022-12-19 04:21:03 | Bladen, North Carolina, US | |
1630377 | 1630377 | 2022-12-18 | US | Nebraska | Dodge | 31053 | 11408 | 145 | 0 | 41.58071748 | -96.65598179 | 2022-12-19 04:21:03 | Dodge, Nebraska, US | |
1629801 | 1629801 | 2022-12-18 | US | Louisiana | Beauregard | 22011 | 10803 | 145 | 0 | 30.64836518 | -93.34173616 | 2022-12-19 04:21:03 | Beauregard, Louisiana, US | |
1629743 | 1629743 | 2022-12-18 | US | Kentucky | Lincoln | 21137 | 8458 | 145 | 0 | 37.45475628 | -84.6565327 | 2022-12-19 04:21:03 | Lincoln, Kentucky, US | |
505981 | 505981 | 2022-12-17 | US | North Carolina | Bladen | 37017 | 11294 | 145 | 0 | 34.61296243 | -78.56180059 | 2022-12-18 04:21:03 | Bladen, North Carolina, US | |
505756 | 505756 | 2022-12-17 | US | Nebraska | Dodge | 31053 | 11408 | 145 | 0 | 41.58071748 | -96.65598179 | 2022-12-18 04:21:03 | Dodge, Nebraska, US | |
505180 | 505180 | 2022-12-17 | US | Louisiana | Beauregard | 22011 | 10803 | 145 | 0 | 30.64836518 | -93.34173616 | 2022-12-18 04:21:03 | Beauregard, Louisiana, US | |
505122 | 505122 | 2022-12-17 | US | Kentucky | Lincoln | 21137 | 8458 | 145 | 0 | 37.45475628 | -84.6565327 | 2022-12-18 04:21:03 | Lincoln, Kentucky, US | |
3326553 | 3326553 | 2022-12-16 | US | North Carolina | Bladen | 37017 | 11294 | 145 | 0 | 34.61296243 | -78.56180059 | 2022-12-17 04:21:04 | Bladen, North Carolina, US | |
3326328 | 3326328 | 2022-12-16 | US | Nebraska | Dodge | 31053 | 11408 | 145 | 0 | 41.58071748 | -96.65598179 | 2022-12-17 04:21:04 | Dodge, Nebraska, US | |
3325752 | 3325752 | 2022-12-16 | US | Louisiana | Beauregard | 22011 | 10803 | 145 | 0 | 30.64836518 | -93.34173616 | 2022-12-17 04:21:04 | Beauregard, Louisiana, US | |
3325694 | 3325694 | 2022-12-16 | US | Kentucky | Lincoln | 21137 | 8458 | 145 | 0 | 37.45475628 | -84.6565327 | 2022-12-17 04:21:04 | Lincoln, Kentucky, US | |
545065 | 545065 | 2022-12-15 | US | North Carolina | Bladen | 37017 | 11294 | 145 | 0 | 34.61296243 | -78.56180059 | 2022-12-16 04:21:01 | Bladen, North Carolina, US | |
544840 | 544840 | 2022-12-15 | US | Nebraska | Dodge | 31053 | 11408 | 145 | 0 | 41.58071748 | -96.65598179 | 2022-12-16 04:21:01 | Dodge, Nebraska, US | |
544264 | 544264 | 2022-12-15 | US | Louisiana | Beauregard | 22011 | 10803 | 145 | 0 | 30.64836518 | -93.34173616 | 2022-12-16 04:21:01 | Beauregard, Louisiana, US | |
544206 | 544206 | 2022-12-15 | US | Kentucky | Lincoln | 21137 | 8458 | 145 | 0 | 37.45475628 | -84.6565327 | 2022-12-16 04:21:01 | Lincoln, Kentucky, US | |
350593 | 350593 | 2022-12-14 | US | North Carolina | Bladen | 37017 | 11294 | 145 | 0 | 34.61296243 | -78.56180059 | 2022-12-15 04:20:58 | Bladen, North Carolina, US | |
350368 | 350368 | 2022-12-14 | US | Nebraska | Dodge | 31053 | 11408 | 145 | 0 | 41.58071748 | -96.65598179 | 2022-12-15 04:20:58 | Dodge, Nebraska, US | |
349792 | 349792 | 2022-12-14 | US | Louisiana | Beauregard | 22011 | 10803 | 145 | 0 | 30.64836518 | -93.34173616 | 2022-12-15 04:20:58 | Beauregard, Louisiana, US | |
349734 | 349734 | 2022-12-14 | US | Kentucky | Lincoln | 21137 | 8458 | 145 | 0 | 37.45475628 | -84.6565327 | 2022-12-15 04:20:58 | Lincoln, Kentucky, US | |
311425 | 311425 | 2022-12-13 | US | Wisconsin | Columbia | 55021 | 19008 | 145 | 0 | 43.46492199 | -89.33589004 | 2022-12-14 04:21:04 | Columbia, Wisconsin, US | |
311016 | 311016 | 2022-12-13 | US | Texas | Hutchinson | 48233 | 7420 | 145 | 0 | 35.84006574 | -101.3546643 | 2022-12-14 04:21:04 | Hutchinson, Texas, US | |
310181 | 310181 | 2022-12-13 | US | North Carolina | Bladen | 37017 | 11238 | 145 | 0 | 34.61296243 | -78.56180059 | 2022-12-14 04:21:04 | Bladen, North Carolina, US | |
309956 | 309956 | 2022-12-13 | US | Nebraska | Dodge | 31053 | 11408 | 145 | 0 | 41.58071748 | -96.65598179 | 2022-12-14 04:21:04 | Dodge, Nebraska, US | |
309380 | 309380 | 2022-12-13 | US | Louisiana | Beauregard | 22011 | 10767 | 145 | 0 | 30.64836518 | -93.34173616 | 2022-12-14 04:21:04 | Beauregard, Louisiana, US | |
309322 | 309322 | 2022-12-13 | US | Kentucky | Lincoln | 21137 | 8458 | 145 | 0 | 37.45475628 | -84.6565327 | 2022-12-14 04:21:04 | Lincoln, Kentucky, US | |
1152486 | 1152486 | 2022-12-12 | US | Wisconsin | Columbia | 55021 | 18999 | 145 | 0 | 43.46492199 | -89.33589004 | 2022-12-13 04:21:01 | Columbia, Wisconsin, US | |
1152077 | 1152077 | 2022-12-12 | US | Texas | Hutchinson | 48233 | 7420 | 145 | 0 | 35.84006574 | -101.3546643 | 2022-12-13 04:21:01 | Hutchinson, Texas, US | |
1151242 | 1151242 | 2022-12-12 | US | North Carolina | Bladen | 37017 | 11238 | 145 | 0 | 34.61296243 | -78.56180059 | 2022-12-13 04:21:01 | Bladen, North Carolina, US | |
1151017 | 1151017 | 2022-12-12 | US | Nebraska | Dodge | 31053 | 11408 | 145 | 0 | 41.58071748 | -96.65598179 | 2022-12-13 04:21:01 | Dodge, Nebraska, US | |
1150441 | 1150441 | 2022-12-12 | US | Louisiana | Beauregard | 22011 | 10767 | 145 | 0 | 30.64836518 | -93.34173616 | 2022-12-13 04:21:01 | Beauregard, Louisiana, US | |
1150383 | 1150383 | 2022-12-12 | US | Kentucky | Lincoln | 21137 | 8458 | 145 | 0 | 37.45475628 | -84.6565327 | 2022-12-13 04:21:01 | Lincoln, Kentucky, US | |
1149935 | 1149935 | 2022-12-12 | US | Illinois | Effingham | 17049 | 12529 | 145 | 0 | 39.05935711 | -88.58969584 | 2022-12-13 04:21:01 | Effingham, Illinois, US | |
872340 | 872340 | 2022-12-11 | US | Wisconsin | Columbia | 55021 | 18975 | 145 | 0 | 43.46492199 | -89.33589004 | 2022-12-12 04:21:01 | Columbia, Wisconsin, US | |
871931 | 871931 | 2022-12-11 | US | Texas | Hutchinson | 48233 | 7420 | 145 | 0 | 35.84006574 | -101.3546643 | 2022-12-12 04:21:01 | Hutchinson, Texas, US | |
871096 | 871096 | 2022-12-11 | US | North Carolina | Bladen | 37017 | 11238 | 145 | 0 | 34.61296243 | -78.56180059 | 2022-12-12 04:21:01 | Bladen, North Carolina, US | |
870871 | 870871 | 2022-12-11 | US | Nebraska | Dodge | 31053 | 11408 | 145 | 0 | 41.58071748 | -96.65598179 | 2022-12-12 04:21:01 | Dodge, Nebraska, US | |
870295 | 870295 | 2022-12-11 | US | Louisiana | Beauregard | 22011 | 10767 | 145 | 0 | 30.64836518 | -93.34173616 | 2022-12-12 04:21:01 | Beauregard, Louisiana, US | |
870237 | 870237 | 2022-12-11 | US | Kentucky | Lincoln | 21137 | 8428 | 145 | 0 | 37.45475628 | -84.6565327 | 2022-12-12 04:21:01 | Lincoln, Kentucky, US | |
869789 | 869789 | 2022-12-11 | US | Illinois | Effingham | 17049 | 12514 | 145 | 0 | 39.05935711 | -88.58969584 | 2022-12-12 04:21:01 | Effingham, Illinois, US | |
260870 | 260870 | 2022-12-10 | US | Wisconsin | Columbia | 55021 | 18975 | 145 | 0 | 43.46492199 | -89.33589004 | 2022-12-11 04:20:50 | Columbia, Wisconsin, US | |
260461 | 260461 | 2022-12-10 | US | Texas | Hutchinson | 48233 | 7420 | 145 | 0 | 35.84006574 | -101.3546643 | 2022-12-11 04:20:50 | Hutchinson, Texas, US | |
259626 | 259626 | 2022-12-10 | US | North Carolina | Bladen | 37017 | 11238 | 145 | 0 | 34.61296243 | -78.56180059 | 2022-12-11 04:20:50 | Bladen, North Carolina, US | |
259401 | 259401 | 2022-12-10 | US | Nebraska | Dodge | 31053 | 11408 | 145 | 0 | 41.58071748 | -96.65598179 | 2022-12-11 04:20:50 | Dodge, Nebraska, US | |
258825 | 258825 | 2022-12-10 | US | Louisiana | Beauregard | 22011 | 10767 | 145 | 0 | 30.64836518 | -93.34173616 | 2022-12-11 04:20:50 | Beauregard, Louisiana, US | |
258767 | 258767 | 2022-12-10 | US | Kentucky | Lincoln | 21137 | 8428 | 145 | 0 | 37.45475628 | -84.6565327 | 2022-12-11 04:20:50 | Lincoln, Kentucky, US | |
258319 | 258319 | 2022-12-10 | US | Illinois | Effingham | 17049 | 12514 | 145 | 0 | 39.05935711 | -88.58969584 | 2022-12-11 04:20:50 | Effingham, Illinois, US | |
3939584 | 3939584 | 2022-12-09 | US | Wisconsin | Columbia | 55021 | 18975 | 145 | 0 | 43.46492199 | -89.33589004 | 2022-12-10 04:21:02 | Columbia, Wisconsin, US | |
3939175 | 3939175 | 2022-12-09 | US | Texas | Hutchinson | 48233 | 7420 | 145 | 0 | 35.84006574 | -101.3546643 | 2022-12-10 04:21:02 | Hutchinson, Texas, US | |
3938340 | 3938340 | 2022-12-09 | US | North Carolina | Bladen | 37017 | 11238 | 145 | 0 | 34.61296243 | -78.56180059 | 2022-12-10 04:21:02 | Bladen, North Carolina, 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]);