|   rowid | day        | country_or_region   | province_or_state   | admin2     |   fips |   confirmed |   deaths |   recovered |   active |   latitude |   longitude | last_update         | combined_key             |
|---------+------------+---------------------+---------------------+------------+--------+-------------+----------+-------------+----------+------------+-------------+---------------------+--------------------------|
|  528954 | 2020-07-04 | US                  | Virginia            | Rockingham |  51165 |         743 |       11 |           0 |      732 |    38.5101 |    -78.8726 | 2020-07-05 04:33:46 | Rockingham, Virginia, US |