|   rowid | day        | country_or_region   | province_or_state   | admin2   |   fips |   confirmed |   deaths |   recovered |   active |   latitude |   longitude | last_update         | combined_key             |
|--------:|:-----------|:--------------------|:--------------------|:---------|-------:|------------:|---------:|------------:|---------:|-----------:|------------:|:--------------------|:-------------------------|
|  528936 | 2020-07-04 | US                  | West Virginia       | Roane    |  54087 |          11 |        1 |           0 |       10 |    38.7162 |    -81.3524 | 2020-07-05 04:33:46 | Roane, West Virginia, US |