# h3hex store location files - data dictionary (schema v2)

Every brand file has the same 26 columns, in this order. A blank cell means the brand does not state the value.

| column | description |
|---|---|
| h3hex_id | Unique row id: <brand slug>_<the brand's own store id>. |
| name | The store's own name as the brand lists it, with any owner, franchisee or company name removed. |
| address1 | First address line. |
| address2 | Second address line, where given. |
| address3 | Any further address lines, joined with commas (optional). |
| town | The named district or locality inside the city, where the brand gives one that differs from the city. |
| city | Post town or city. |
| postcode | UK postcode. |
| lat | Latitude, WGS84, 6 decimal places. |
| lon | Longitude, WGS84, 6 decimal places. |
| drive_thru | True / False where the brand states it; blank where it does not. |
| Mon_open | Opening time that day, HH:MM 24-hour clock; 'closed' when the brand says closed; 00:00 with a 24:00 close = open all day. |
| Mon_close | Closing time that day; 24:00 = midnight; a time earlier than the opening time is the next morning. |
| Tue_open | Opening time that day, HH:MM 24-hour clock; 'closed' when the brand says closed; 00:00 with a 24:00 close = open all day. |
| Tue_close | Closing time that day; 24:00 = midnight; a time earlier than the opening time is the next morning. |
| Wed_open | Opening time that day, HH:MM 24-hour clock; 'closed' when the brand says closed; 00:00 with a 24:00 close = open all day. |
| Wed_close | Closing time that day; 24:00 = midnight; a time earlier than the opening time is the next morning. |
| Thu_open | Opening time that day, HH:MM 24-hour clock; 'closed' when the brand says closed; 00:00 with a 24:00 close = open all day. |
| Thu_close | Closing time that day; 24:00 = midnight; a time earlier than the opening time is the next morning. |
| Fri_open | Opening time that day, HH:MM 24-hour clock; 'closed' when the brand says closed; 00:00 with a 24:00 close = open all day. |
| Fri_close | Closing time that day; 24:00 = midnight; a time earlier than the opening time is the next morning. |
| Sat_open | Opening time that day, HH:MM 24-hour clock; 'closed' when the brand says closed; 00:00 with a 24:00 close = open all day. |
| Sat_close | Closing time that day; 24:00 = midnight; a time earlier than the opening time is the next morning. |
| Sun_open | Opening time that day, HH:MM 24-hour clock; 'closed' when the brand says closed; 00:00 with a 24:00 close = open all day. |
| Sun_close | Closing time that day; 24:00 = midnight; a time earlier than the opening time is the next morning. |
| services | Services and amenities the brand lists, separated by '; ' (staffed hours for 24/7 sites; breaks in the day). |

## Sources

- Store records: each brand's own website or store locator, a public register, or manual verification.
- City names filled from built-up areas: OS Open Built Up Areas. ORDNANCE SURVEY DATA LICENCE Your use of OS OpenData is subject to the terms at http://os.uk/opendata/licence Contains Ordnance Survey data © Crown copyright and database right 2026.
- Where the brand gives no town, the city column only is filled - from other stores sharing the same postcode district, or from the OS Open Built Up Area the store stands in. No other column is filled this way.