|   rowid | day        | country_or_region   | province_or_state   | admin2   |   fips |   confirmed |   deaths |   recovered |   active |   latitude |   longitude | last_update         | combined_key                 |
|---------+------------+---------------------+---------------------+----------+--------+-------------+----------+-------------+----------+------------+-------------+---------------------+------------------------------|
|  528923 | 2020-07-04 | US                  | North Carolina      | Richmond |  37153 |         309 |        7 |           0 |      302 |    35.0042 |    -79.7449 | 2020-07-05 04:33:46 | Richmond, North Carolina, US |