|   rowid | day        | country_or_region   | province_or_state   | admin2    |   fips |   confirmed |   deaths |   recovered |   active |   latitude |   longitude | last_update         | combined_key            |
|--------:|:-----------|:--------------------|:--------------------|:----------|-------:|------------:|---------:|------------:|---------:|-----------:|------------:|:--------------------|:------------------------|
|  669577 | 2020-09-16 | US                  | Virginia            | Charlotte |  51037 |          97 |        0 |           0 |       97 |    37.0191 |    -78.6631 | 2020-09-17 04:22:00 | Charlotte, Virginia, US |