Sugi Pharmacy (スギ薬局) store data

Name: Sugi Pharmacy (スギ薬局) store data
Brand: LocationsDB
Price: 19670 JPY
Availability: InStock

1,967 stores · 55 fields · As of 2026-07-15 · Updated daily

Monthly plan

¥19,670/mo

¥10/store × 1,967 stores

50% OFF

Annual plan

¥9,835/mo

Annual total ¥118,020 (¥60/store/year)

Subscribe to this data Download free sample

✓ 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 Sugi Pharmacy (スギ薬局)-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	Email
`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

Sugi Pharmacy (スギ薬局)-specific attributes

Column	Fill rate
`id`	100%
`name`	100%
`_list`	100%
`address`	100%
`freeText`	100%
`position`	100%
`bannerUrl`	100%
`storeInfo`	100%
`tokubaiId`	100%
`bannerType`	100%
`isFavorite`	100%
`isPharmacy`	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`	—
`store_type`	スギドラッグ
`address`	東京都世田谷区桜新町二丁目31番5号
`prefecture`	東京都
`postal_code`	154-0015
`latitude`	35.633423
`longitude`	139.63904
`nearest_station`	—
`access_info`	—
`floor`	—
`building`	—
`phone`	03-5799-7761
`fax`	03-5799-7762
`email`	—
`store_url`	https://www.sugi-net.jp/stores/001644
`business_hours`	月〜祝 09:00〜22:00
`closed_days`	日・祝
`last_order_time`	—
`open_24h`	false
`open_date`	—
`parking`	true
`parking_capacity`	18
`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`	false
`power_outlets`	—
`pet_friendly`	—
`serves_alcohol`	true
`tax_free_shopping`	true
`atm`	—
`pharmacy`	true
`price_range`	—
`reservation_url`	—
`photo_url`	—
`services`	電子処方箋, 水自販機, マイナ受付, 特定保健指導, 涼み処, 健康測定
`notes`	当店は災害や新興感染症の発生時に近隣薬局店舗との医薬品供給及び人的な相互サポート体制を有しており、地域医療の維持及び推進に努めております。
`_list`	{"id":"001644","name":"桜新町店","address":"〒154-0015 東京都世田谷区桜新町二丁目31番5号","position":{"lat":35.633423,"lng":139.63904,"distance":null},"storeInfo":[{"status":"CLOSED","dbaName":"スギドラッグ","holidays":[],"storeType":"sales","statusText":"営業時間外","nextStatusTime":null,"businessHoursNote":null,"statusStoreTypeLabel":"店舗"},{"status":"CLOSED","dbaName":"スギ薬局調剤","holidays":["日","祝"],"storeType":"pharmacy","statusText":"受付時間外","nextStatusTime":null,"businessHoursNote":"当店は災害や新興感染症の発生時に\r\n近隣薬局店舗との医薬品供給及び\r\n人的な相互サポート体制を有しており、\r\n地域医療の維持及び推進に努めております。","statusStoreTypeLabel":"調剤"}],"hasParking":true,"isPharmacy":true}
`address`	〒154-0015 東京都世田谷区桜新町二丁目31番5号
`bannerType`	sugi
`bannerUrl`	—
`freeText`	—
`id`	001644
`isFavorite`	false
`isPharmacy`	true
`name`	桜新町店
`parkingLot`	18
`position`	{"lat":35.633423,"lng":139.63904,"distance":null}
`storeInfo`	[object Object], [object Object]
`supportedInsuranceDispensing`	在宅医療, 麻薬調剤, 生活保護, 結核医療, 被爆, 労災, 難病・小児慢性特定疾病
`supportedPayments`	クレジット, バーコード, IC, スギPay
`supportedPharmacyStandardsNotifications`	調剤基本料3ハ, 地域支援・医薬品供給対応体制加算1, 連携強化加算, 電子的調剤情報連携体制整備加算, 調剤ベースアップ評価料, バイオ後続品調剤体制加算, 在宅患者訪問薬剤管理指導料
`supportedProducts`	医薬品, 化粧品, 日配食品, 米, 酒
`supportedServices`	処方せん, 電子処方せん, 水自販機, 免税, 血圧測定, 血管年齢, 脳年齢, 体組成, マイナ保険証・オンライン資格確認, 特定保健指導, ペットボトル回収機, 宅配サービス, 涼み処
`tokubaiId`	184808

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/sugi-pharmacy/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.