All 1,212 chains and 336,077 stores. Two CSVs per brand (BOM UTF-8 / RFC 4180 / compatible with Excel, BigQuery, pandas, etc.).
Fixed 33 columns across all chains. Provided in both Excel and CSV. Same column structure for every chain, so you can concatenate multiple chains vertically for cross-chain analysis.
| Column | Description |
|---|---|
| ldb_id | Permanent store ID (unchanged across re-scrapes, site redesigns, and brand renames. Recommended join key) |
| brand_id | Brand ID (ASCII slug, e.g. starbucks) |
| place_id | Stable ID unique within brand — unchanged across re-scrapes |
| name | Store name |
| name_kana | Name (kana reading) |
| name_en | English store name |
| address | Address (from prefecture) |
| prefecture | Prefecture (auto-extracted from address — use directly in GROUP BY) |
| postal_code | Postal code |
| latitude / longitude | Latitude/longitude (WGS84). Coordinate fill rate is nearly 100% |
| access_info | Access info (nearest station, bus stop, IC, etc.) |
| phone | Phone number |
| store_url | Store detail page URL |
| business_hours | Business hours |
| closed_days | Closed days |
| open_24h | 24-hour operation (TRUE/FALSE) |
| open_date | Opening date |
| parking | Parking available (TRUE/FALSE) |
| parking_capacity | Parking capacity (integer) |
| drive_through | Drive-through (TRUE/FALSE) |
| seat_count | Seat count |
| dine_in / takeout / delivery | Dine-in, takeout, delivery (TRUE/FALSE) |
| accepts_credit_card | Credit card accepted (TRUE/FALSE) |
| accepts_e_money | E-money accepted (TRUE/FALSE) |
| accepts_qr_payment | QR payment accepted (TRUE/FALSE) |
| wifi | Wi-Fi available (TRUE/FALSE) |
| barrier_free | Barrier-free (TRUE/FALSE) |
| serves_alcohol | Serves alcohol (TRUE/FALSE) |
| services | Services & facilities list (AED, multi-copier, Uber Eats, etc.) |
| notes | Notes |
| first_seen | First detection date in our database (basis for new store detection) |
| last_seen | Last verified date — the last date this store was confirmed on the official website |
| updated_at | Last content change date — when business hours, address, etc. actually changed (not updated by daily existence checks) |
Three date columns are key: last_seen tells you if the store is active, first_seen tells you when it appeared, updated_at tells you if content recently changed. Closed stores are excluded from CSV by default.
In addition to the common columns from standard, this file includes all brand-specific attributes available from the chain's official website as columns. Brand-specific columns vary by chain. Examples:
Download the sample (all St. Marc Café stores) to see the actual format.
Downloaded filename is "brandID_type_date.csv" (e.g. starbucks_standard_20260612.csv). Contents update daily, so the date in the filename = data date.
Contracted brands are also accessible via REST API. Usage-based billing from prepaid credits. Issue API keys and top up on yourdashboardSend via Authorization: Bearer ldb_… header. Authorization: Bearer ldb_…
| Endpoint | Description |
|---|---|
| GET /v1/brands | List contracted brands with metadata (store count, last update) |
| GET /v1/brands/{brand}/places | Store list for a brand (active only, max 1,000 per request; pass the response's next_cursor as ?cursor= for more). ?area=渋谷区 for partial address match |
| GET /v1/places/{ldb_id} | Single store lookup (ldb_id = our permanent store ID) |
$ curl "https://api.locationsdb.com/v1/brands/starbucks/places?area=中央区" \
-H "Authorization: Bearer ldb_****"
{
"brand_id": "starbucks",
"total": 42,
"places": [
{
"ldb_id": "15efa89cfeb71ddd",
"name": "銀座マロニエ通り店",
"address": "東京都中央区銀座3-7-3",
"latitude": 35.6717, "longitude": 139.7659,
"business_hours": "07:00～22:00",
"wifi": true,
"services": ["モバイルオーダー"],
"first_seen": "2026-02-28",
"last_seen": "2026-07-01"
}
]
}Evaluating for your team?
Need full data for a specific chain for evaluation, or want to request an uncovered chain (added as soon as next day)? Contact us.