Sundrug (サンドラッグ) store data
1,242 stores · 55 fields · As of 2026-07-15 · Updated daily
Monthly plan
¥12,420/mo
¥10/store × 1,242 stores
50% OFF
Annual plan
¥6,210/mo
Annual total ¥74,520 (¥60/store/year)
✓ Instant download✓ Cancel anytime✓ Daily auto-update✓ Excel / CSV + REST API
Data fields (all 55 fields)
In addition to 55 common fields across all chains, we also provide a full version including Sundrug (サンドラッグ)-specific attributes.
Identity & Classification
| Column | Type | Description |
|---|---|---|
ldb_id | TEXT | Permanent store ID |
brand_id | TEXT | Brand slug |
place_id | TEXT | Site-side store ID |
name | TEXT | Store name |
name_kana | TEXT | Name (kana) |
name_en | TEXT | English name |
store_type | TEXT | Store type |
description | TEXT | Store description |
Location & Access
| Column | Type | Description |
|---|---|---|
address | TEXT | Address |
prefecture | TEXT | Prefecture |
postal_code | TEXT | Postal code |
latitude | DOUBLE | Latitude |
longitude | DOUBLE | Longitude |
nearest_station | TEXT | Nearest station |
access_info | TEXT[] | Access info |
floor | TEXT | Floor |
building | TEXT | Building name |
Contact
| Column | Type | Description |
|---|---|---|
phone | TEXT | Phone |
fax | TEXT | Fax |
email | TEXT | |
store_url | TEXT | Store page URL |
Business Hours
| Column | Type | Description |
|---|---|---|
business_hours | TEXT | Business hours |
closed_days | TEXT | Closed days |
last_order_time | TEXT | Last order time |
open_24h | BOOLEAN | 24-hour |
open_date | DATE | Opening date |
Parking & Transport
| Column | Type | Description |
|---|---|---|
parking | BOOLEAN | Parking available |
parking_capacity | INTEGER | Parking capacity |
drive_through | BOOLEAN | Drive-through |
Dining & Service
| Column | Type | Description |
|---|---|---|
seat_count | INTEGER | Total seats |
private_room | BOOLEAN | Private room |
dine_in | BOOLEAN | Dine-in |
takeout | BOOLEAN | Takeout |
delivery | BOOLEAN | Delivery |
reservation | BOOLEAN | Reservations |
smoking_policy | TEXT | Smoking policy |
Payment
| Column | Type | Description |
|---|---|---|
accepts_credit_card | BOOLEAN | Credit cards |
accepts_e_money | BOOLEAN | E-money |
accepts_qr_payment | BOOLEAN | QR payment |
Facilities & Features
| Column | Type | Description |
|---|---|---|
barrier_free | BOOLEAN | Barrier-free |
wifi | BOOLEAN | Wi-Fi |
power_outlets | BOOLEAN | Power outlets |
pet_friendly | BOOLEAN | Pet-friendly |
serves_alcohol | BOOLEAN | Serves alcohol |
tax_free_shopping | BOOLEAN | Tax-free shopping |
atm | BOOLEAN | ATM |
pharmacy | BOOLEAN | Pharmacy |
services | TEXT[] | Services & facilities list |
Other
| Column | Type | Description |
|---|---|---|
price_range | TEXT | Price range |
reservation_url | TEXT | Reservation URL |
photo_url | TEXT | Store photo URL |
notes | TEXT | Notes |
first_seen | TIMESTAMP | First detected |
last_seen | TIMESTAMP | Last detected |
updated_at | TIMESTAMP | Data updated |
Sundrug (サンドラッグ)-specific attributes
| Column | Fill rate |
|---|---|
fax | 100% |
lat | 100% |
lng | 100% |
tel | 100% |
url | 100% |
name | 100% |
hours | 100% |
icons | 100% |
address | 100% |
name_en | 100% |
place_id | 100% |
stations | 100% |
Sample data (1 store)
This is an example of actually recorded data. Please verify data quality before purchase.
| Field | Value |
|---|---|
name | 明石東野店 |
name_kana | — |
name_en | Akashi Higashino Shop |
store_type | ドラッグストア |
address | 兵庫県明石市東野町1860-1 |
prefecture | 兵庫県 |
postal_code | 6730844 |
latitude | 34.654991 |
longitude | 135.007798 |
nearest_station | 山陽電鉄本線 大蔵谷(940m) |
access_info | 山陽電鉄本線 大蔵谷(940m) 山陽電鉄本線 人丸前(960m) JR神戸線 朝霧(1490m) |
floor | — |
building | — |
phone | 078-587-7351 |
fax | 078-915-7025 |
email | — |
store_url | https://sundrug-online.com/blogs/search-store/5235 |
business_hours | 9：00～21：30 |
closed_days | — |
last_order_time | — |
open_24h | — |
open_date | — |
parking | true |
parking_capacity | — |
drive_through | — |
seat_count | — |
private_room | — |
dine_in | — |
takeout | — |
delivery | true |
reservation | — |
smoking_policy | — |
accepts_credit_card | true |
accepts_e_money | true |
accepts_qr_payment | true |
barrier_free | — |
elevator | — |
wifi | — |
power_outlets | — |
pet_friendly | — |
serves_alcohol | — |
tax_free_shopping | true |
atm | — |
pharmacy | — |
price_range | — |
reservation_url | — |
photo_url | — |
services | 第一類医薬品, ベビー用品, ペット用品, 食品, AED |
notes | — |
address | 兵庫県明石市東野町1860-1 |
address_en | 1860-1 Higashinocho, Akashi City, Hyogo Prefecture |
fax | 078-915-7025 |
hours | 9：00～21：30 |
icons | on01_time-10, on07_car, on07_AED, on02_drug1, on02_baby, on02_pet, on03_shihseido, on03_kose, on03_kanebo, on03_sofina, on06_food, on06_daily, on06_cool, on06_rice, on05_delivery, on05_dutyfree, on04_paypay, on04_famipay, on04_aeonpay, on04_alipay, on04_jkopay, on04_unionPay, on04_credit, on04_edy, on04_waon |
lat | 34.654991 |
lng | 135.007798 |
name | 明石東野店 |
name_en | Akashi Higashino Shop |
place_id | 5235 |
postal_code | 6730844 |
stations | 山陽電鉄本線 大蔵谷(940m), 山陽電鉄本線 人丸前(960m), JR神戸線 朝霧(1490m) |
tel | 078-587-7351 |
title_raw | 明石東野店 Akashi Higashino Shop |
url | https://sundrug-online.com/blogs/search-store/5235 |
Data formats & access methods
Excel / CSV
Two versions: common 55 columns and full version. Download anytime from your dashboard.
REST API
GET api.locationsdb.com/v1/brands/sundrug/places for JSON. Area search and pagination supported.
MCP
Query directly from AI agents. Compatible with Claude, GPT, and other tools.
LocationsDB vs other store data services
| LocationsDB | Other services | |
|---|---|---|
| Data collection | ✓Self-collected from official sites | ✗Source undisclosed, quality varies |
| Update frequency | ✓Daily (automated) | ✗Monthly or less (manual delivery) |
| Delivery speed | ✓Instant download | ✗Quote → days to deliver |
| Brand-specific attributes | ✓Payment, Wi-Fi, seating, etc. structured | ✗Common columns only |
| Access methods | ✓Excel / CSV + REST API + MCP | ✗File delivery only |
| Pricing transparency | ✓Published pricing, self-service | ✗Quote-based, minimums apply |
| Opening/closing tracking | ✓Daily new store and closing detection | ✗Snapshot delivery, no diffs |
| Normalization | ✓Business hours, holidays, parking machine-readable | ✗Raw text as-is |
Frequently asked questions
How often is data updated?+
Data is automatically collected from each chain's official website every day. You can download the latest version anytime during your subscription.
Is sample data available?+
Yes. Download a free sample CSV from the homepage. Check column structure and data quality before purchasing.
Can I cancel anytime?+
Yes. Cancel from your dashboard anytime. You keep access until the end of your paid period. No prorated refunds.
Can I use the API?+
Yes. REST API access is available for subscribed chains. Usage-based pricing (¥0.01/request~), not included in subscription fee.
Can I subscribe to multiple chains?+
Yes. Select multiple chains on the purchase page for a bulk subscription. Unified CSV download across all chains is also available.
Are there usage restrictions?+
Internal use and embedding in your own products is allowed. Resale or redistribution to third parties is not covered. See terms of service for details.
Related datasets
We also provide data for other chains in the same category.
Start using Sundrug (サンドラッグ)'s 1,242 store data today
Annual plan: ¥6,210/mo (¥5/store/mo). Cancel anytime.