|   rowid | day        | country_or_region   | province_or_state   | admin2        |   fips |   confirmed |   deaths |   recovered |   active |   latitude |   longitude | last_update         | combined_key             |
|---------+------------+---------------------+---------------------+---------------+--------+-------------+----------+-------------+----------+------------+-------------+---------------------+--------------------------|
|  528998 | 2020-07-04 | US                  | Texas               | San Augustine |  48405 |          40 |        7 |           0 |      107 |    31.3946 |      -94.17 | 2020-07-05 04:33:46 | San Augustine, Texas, US |