Business Locations
This dataset provides comprehensive details on commercial business locations, including full address breakdown, GPS coordinates, business hours, contact information, and location type classifications. It is ideal for mapping, local search, market analysis, and operational planning, enabling users to identify, analyze, and visualize business presence and accessibility across regions.
Sample rows
preview · 8 of 200 rows · all 19 columns| business_idstring | location_typestring | is_activeboolean | business_hours_weekday_openstring | business_namestring | address_streetstring | address_citystring | address_statestring | address_postal_codestring | address_countrystring | latitudefloat | longitudefloat | business_hours_weekday_closestring | business_hours_weekend_openstring | business_hours_weekend_closestring | contact_phonestring | contact_emailstring | contact_websitestring | last_updateddatetime |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| retail-chicago-001 | retail | true | 09:00 | FreshMart Downtown | 1200 N Clark St | Chicago | IL | 60610 | US | 41.9045 | -87.6312 | 21:00 | 10:00 | 20:00 | +1-312-555-0192 | info@ | https://www.freshmart.com | 2024-06-04T17:42:05Z |
| retail-losangeles-002 | retail | true | 10:00 | Urban Outfitters LA | 431 S Broadway | Los Angeles | CA | 90013 | US | 34.0453 | -118.2509 | 21:00 | 11:00 | 19:00 | +1-213-555-0412 | contact@ | https://www.urbanoutfitters.com | 2024-06-05T09:14:22Z |
| retail-dallas-003 | retail | true | 08:30 | BestBuy NorthPark | 8687 N Central Expy | Dallas | TX | 75225 | US | 32.8661 | -96.7682 | 20:30 | 09:30 | 18:30 | +1-214-555-0178 | northpark@ | https://stores.bestbuy.com/dallas | 2024-06-03T13:11:44Z |
| retail-auckland-004 | retail | false | 09:00 | Kiwi Tech Outlet | 23 Queen Street | Auckland | AUK | 1010 | NZ | -36.8476 | 174.7633 | 18:00 | 10:00 | 16:00 | +64-9-555-0198 | info@ | https://www.kiwitech.co.nz | 2024-05-24T10:28:19Z |
| retail-johannesburg-005 | retail | true | 08:00 | Joburg Mall Electronics | 56 Rivonia Rd | Johannesburg | GP | 2196 | ZA | -26.1009 | 28.0538 | 20:00 | 09:00 | 17:00 | +27-11-555-0129 | info@ | https://www.joburgmall.co.za | 2024-06-01T11:22:51Z |
| retail-toronto-006 | retail | true | 10:00 | Maple Style Toronto | 250 Yonge St | Toronto | ON | M5B 2L7 | CA | 43.6544 | -79.3807 | 19:00 | 11:00 | 17:00 | +1-416-555-0145 | toronto@ | https://www.maplestyle.ca | 2024-06-05T08:09:16Z |
| retail-dubai-007 | retail | false | 09:00 | Desert Electronics | 100 Sheikh Zayed Rd | Dubai | DU | 00000 | AE | 25.2048 | 55.2708 | 22:00 | 10:00 | 20:00 | +971-4-555-0198 | info@ | https://www.desertelectronics.ae | 2024-05-21T19:14:21Z |
| retail-buenosaires-008 | retail | true | 09:30 | Mercado Central | Av. Corrientes 1234 | Buenos Aires | CABA | C1043AAN | AR | -34.6037 | -58.3816 | 20:00 | 10:00 | 19:00 | +54-11-555-0143 | contact@ | https://www.mercadocentral.com.ar | 2024-06-05T14:30:15Z |
| retail-phoenix-009 | retail | true | 08:00 | Sun Valley Market | 5225 N 16th St | Phoenix | AZ | 85016 | US | 33.5207 | -112.0472 | 21:30 | 09:00 | 17:00 | +1-602-555-0194 | info@ | https://www.sunvalleymarket.com | 2024-06-04T18:23:45Z |
| retail-houston-010 | retail | false | 08:30 | Galleria Essentials | 5085 Westheimer Rd | Houston | TX | 77056 | US | 29.7386 | -95.4651 | 20:00 | 09:00 | 18:30 | +1-713-555-0193 | houston@ | https://www.galleriaessentials.com | 2024-05-19T07:45:12Z |
| office-newyork-011 | office | true | 09:00 | TechHub Inc. | 45 Madison Ave | New York | NY | 10010 | US | 40.7424 | -73.9872 | 17:00 | blank | blank | +1-212-555-0167 | nyc@ | https://www.techhub.com | 2024-06-03T11:17:08Z |
| office-sanfrancisco-012 | office | true | 08:30 | TechHub Inc. | 180 Fremont St | San Francisco | CA | 94105 | US | 37.7898 | -122.3967 | 17:30 | blank | blank | +1-415-555-0134 | sf@ | https://www.techhub.com | 2024-06-02T08:20:44Z |
| office-toronto-013 | office | true | 09:00 | TechHub Inc. | 150 King St W | Toronto | ON | M5H 1J9 | CA | 43.6471 | -79.3827 | 17:00 | blank | blank | +1-416-555-0176 | toronto@ | https://www.techhub.com | 2024-06-04T08:01:53Z |
| office-helsinki-014 | office | true | 09:00 | Northern Consulting | Mannerheimintie 12 | Helsinki | UUS | 00100 | FI | 60.1719 | 24.9384 | 16:30 | blank | blank | +358-9-555-0173 | info@ | https://www.northernconsult.fi | 2024-06-04T14:33:44Z |
| office-mexicocity-015 | office | false | 08:30 | Global Office Co. | Paseo de la Reforma 350 | Mexico City | CDMX | 06600 | MX | 19.4255 | -99.1688 | 17:00 | blank | blank | +52-55-555-0128 | contact@ | https://www.globaloffice.mx | 2024-05-20T12:01:19Z |
| warehouse-houston-016 | warehouse | true | 05:00 | LogistiCo Depot | 4000 Navigation Blvd | Houston | TX | 77011 | US | 29.7335 | -95.3133 | 16:00 | 06:00 | 12:00 | +1-713-555-0112 | houston@ | https://www.logistico.com | 2024-06-02T16:12:27Z |
| warehouse-melbourne-017 | warehouse | false | 04:30 | LogistiCo Depot | 150 Sunshine Rd | Melbourne | VIC | 3020 | AU | -37.806 | 144.9217 | 15:00 | 05:00 | 12:00 | +61-3-555-0147 | melbourne@ | https://www.logistico.com.au | 2024-05-25T14:05:26Z |
| warehouse-lima-018 | warehouse | true | 06:00 | Andean Supplies | Av. Colonial 500 | Lima | LIM | 15001 | PE | -12.0464 | -77.0428 | 18:00 | 07:00 | 12:00 | +51-1-555-0183 | info@ | https://www.andeansupplies.pe | 2024-06-05T10:44:37Z |
| warehouse-anchorage-019 | warehouse | false | 05:30 | Polar Storage | 760 W 4th Ave | Anchorage | AK | 99501 | US | 61.2171 | -149.9003 | 14:00 | blank | blank | blank | blank | blank | 2024-05-15T12:55:34Z |
| warehouse-sydney-020 | warehouse | true | 06:00 | Global Freight | 25 Botany Rd | Sydney | NSW | 2017 | AU | -33.8915 | 151.2005 | 18:00 | 07:00 | 13:00 | +61-2-555-0138 | blank | blank | 2024-06-03T08:38:57Z |
What the 200 rows show
from the 200-row sample- 70%is_
active = true - 16business hours weekend opens
- 21business hours weekend closes
- 27business hours weekday closes
- 29address countries
- string 15
- float 2
- datetime 1
- boolean 1
Columns
19 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 15 columns | |||
business_id | string | Unique identifier for the business locationunique | retail-chicago-001 |
business_name | string | Official name of the business | FreshMart Downtown |
location_type | string | Classification of the business location (e.g., retail, office, warehouse, restaurant)6 values | retail |
address_street | string | Street address of the business location | 1200 N Clark St |
address_city | string | City where the business is located | Chicago |
address_state | string | State or province of the business location | IL |
address_postal_code | string | Postal or ZIP code of the business location | 60610 |
address_country | string | Country where the business is located | US |
business_hours_weekday_open | string | Opening time on weekdays (HH:MM format, local time)optional | 09:00 |
business_hours_weekday_close | string | Closing time on weekdays (HH:MM format, local time)optional | 21:00 |
business_hours_weekend_open | string | Opening time on weekends (HH:MM format, local time)optional | 10:00 |
business_hours_weekend_close | string | Closing time on weekends (HH:MM format, local time)optional | 20:00 |
contact_phone | string | Primary phone number for the business locationoptional | +1-312-555-0192 |
contact_email | string | Primary email address for the business locationoptional | info@ |
contact_website | string | Website URL for the business locationoptional | https://www.techhub.com |
| Numbers 2 columns | |||
latitude | float | Latitude coordinate of the business location-90 to 90 | 41.9045 |
longitude | float | Longitude coordinate of the business location-180 to 180 | -87.6312 |
| Dates and times 1 column | |||
last_updated | datetime | Timestamp of the last update to this business record | 2024-06-04T17:42:05Z |
| True or false 1 column | |||
is_active | boolean | Indicates if the business location is currently active/open | true |
Use it for
A dashboard
The is_
active rate, is_ active by location_ type and a breakdown of business_ hours_ weekday_ open. Excel, Power BI or Tableau. Why do 139 of 200 rows have is_
active = true? A class exercise
Hand out the rows and one question. Everyone works from the same 200 rows.
- Businesses200retail-chicago-001retailretail-losangeles-002retailretail-auckland-004retail
A software demo
Believable businesses with business_
name, location_ type and address_ street to fill a screen in front of a buyer.
blueprint · business-locations
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 19 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.
- Latitude between -90 and 90 degrees
- Longitude between -180 and 180 degrees
- Business hours follow timezone of location
- Location type: office, warehouse, retail, etc
- Operating status: active, closed, seasonal
1 credit per row. Preview 20 rows free. Buy rows for the full run.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- business-locations