|   rowid | day        | country_or_region   | province_or_state   | admin2   |   fips |   confirmed |   deaths |   recovered |   active |   latitude |   longitude | last_update         | combined_key              |
|---------+------------+---------------------+---------------------+----------+--------+-------------+----------+-------------+----------+------------+-------------+---------------------+---------------------------|
| 1278469 | 2020-06-04 | US                  | Pennsylvania        | Clarion  |  42031 |          27 |        2 |           0 |       25 |    41.1927 |    -79.4241 | 2020-06-05 02:33:06 | Clarion, Pennsylvania, US |