Sakura Pharmacy (さくら薬局) store data

Name: Sakura Pharmacy (さくら薬局) store data
Brand: LocationsDB
Price: 6730 JPY
Availability: InStock

673 stores · 55 fields · As of 2026-09-06 · Updated daily

Monthly plan

¥6,730/mo

¥10/store × 673 stores

50% OFF

Annual plan

¥3,365/mo

Annual total ¥40,380 (¥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 Sakura 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

Sakura Pharmacy (さくら薬局)-specific attributes

Column	Fill rate
`_detail`	100%
`address`	100%
`baseInfo`	100%
`baseInfoBusinessHours`	100%
`businessHours`	100%
`businessStatus`	100%
`checkBoxLabel`	100%
`cmsItemValues`	100%
`distanceKm`	100%
`id`	100%
`inputUrl`	100%
`inputUrlWithModal`	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`	埼玉県さいたま市緑区東浦和二丁目18番3
`prefecture`	埼玉県
`postal_code`	3360926
`latitude`	35.86118
`longitude`	139.70139
`nearest_station`	—
`access_info`	JR 東浦和駅より徒歩5分
`floor`	—
`building`	—
`phone`	048-762-7247
`fax`	048-762-7248
`email`	—
`store_url`	https://store.ainj.co.jp/detail/4481/
`business_hours`	月・火・水・木・金・土 08:45-17:45
`closed_days`	日・祝日
`last_order_time`	—
`open_24h`	—
`open_date`	2026-09-01
`parking`	true
`parking_capacity`	—
`drive_through`	—
`seat_count`	—
`private_room`	—
`dine_in`	—
`takeout`	—
`delivery`	—
`reservation`	—
`smoking_policy`	—
`accepts_credit_card`	true
`accepts_e_money`	true
`accepts_qr_payment`	true
`barrier_free`	true
`elevator`	—
`wifi`	—
`power_outlets`	—
`pet_friendly`	—
`serves_alcohol`	—
`tax_free_shopping`	—
`atm`	—
`pharmacy`	true
`price_range`	—
`reservation_url`	—
`photo_url`	—
`services`	オンライン服薬指導, 電子処方箋, マイナ保険証（オンライン資格確認）, 在宅医療, かかりつけ薬剤師, 車椅子対応
`notes`	—
`_detail`	{"code":"4481","place_id":"4481","text_FAX番号":"048-762-7248","text_定休日":"日・祝日","text_駐車場":"あり","text_アクセス":"JR 東浦和駅より徒歩5分","flag_設備等_駐車場":true,"flag_設備等_土曜営業":true,"text_このページを印刷":"このページを印刷","text_店舗毎の取り組み":"当薬局ではジェネリック医薬品を積極的に調剤しております\nジェネリック医薬品（後発医薬品）のある先発医薬品（長期収載品）の選定療養について","flag_設備等_車椅子対応":true,"flag_設備等_車椅子トイレ":true,"flag_電子マネー・QR決済_iD":true,"flag_電子マネー・QR決済_atone":true,"flag_電子マネー・QR決済_pring":true,"flag_電子マネー・QR決済_PayPay":true,"flag_電子マネー・QR決済_au PAY":true,"flag_電子マネー・QR決済_nanaco":true,"text_処方箋（しょほうせん）":"全国の医療機関の処方箋を受け付けております\n処方箋の有効期限が、原則4日間となっているのはなぜですか？\n処方箋の受付後、後日薬を取りに行ってもいいですか？","flag_対応可能な保険調剤_労災":true,"flag_対応可能な保険調剤_原爆":true,"flag_機能・サービス_在宅医療":true,"flag_電子マネー・QR決済_ANA Pay":true,"flag_電子マネー・QR決済_FamiPay":true,"flag_電子マネー・QR決済_JAL Pay":true,"flag_電子マネー・QR決済_d払い":true,"flag_電子マネー・QR決済_BNPJ Pay":true,"flag_電子マネー・QR決済_EPOS PAY":true,"flag_電子マネー・QR決済_QUICPay+":true,"flag_電子マネー・QR決済_MyJCB Pay":true,"flag_電子マネー・QR決済_Payどん":true,"flag_電子マネー・QR決済_WeChatPay":true,"flag_電子マネー・QR決済_楽天Edy":true,"flag_機能・サービス_電子処方箋":true,"flag_電子マネー・QR決済_Lu Vit Pay":true,"flag_電子マネー・QR決済_メルペイ":true,"flag_電子マネー・QR決済_楽天ペイ":true,"flag_対応可能な保険調剤_在宅医療":true,"flag_対応可能な保険調剤_生活保護":true,"flag_対応可能な保険調剤_精神通院":true,"flag_対応可能な保険調剤_結核医療":true,"flag_対応可能な保険調剤_麻薬調剤":true,"flag_電子マネー・QR決済_QUOカードPay":true,"flag_施設基準の届出_調剤物価対応料":true,"flag_特記事項１_抗原検査キット販売":true,"flag_対応可能な保険調剤_更生育成医療":true,"flag_機能・サービス_かかりつけ薬剤師":true,"flag_電子マネー・QR決済_みきゃんアプリ":true,"flag_機能・サービス_オンライン服薬指導":true,"flag_施設基準の届出_服薬管理指導料の注1":true,"flag_対応可能な保険調剤_高度管理医療機器":true,"flag_電子マネー・QR決済_K +(カシコン銀行）":true,"flag_電子マネー・QR決済_ギフティプレモPlus":true,"flag_現金以外のお支払い方法_交通系ICカード":true,"flag_現金以外のお支払い方法_クレジットカード":true,"flag_施設基準の届出_在宅患者訪問薬剤管理指導料":true,"flag_対応可能な保険調剤_難病・小児慢性\n特定疾病":true,"flag_機能・サービス_マイナ保険証（オンライン資格確認）":true}
`address`	埼玉県さいたま市緑区東浦和二丁目18番3
`baseInfo`	{"title":"-","keyword":"","remarks":{"top":"","bottom":""},"baseInfo":{"seo":{"isChecked":false},"latlng":{"latitude":"35.86118","longitude":"139.70139"},"storeCode":{"text":"4481"},"isShowNearby":{"isChecked":true},"publishStatus":{"isPublished":true},"storeNameKana":{"text":"","isChecked":true,"isRequired":false},"searchKeywords":{"text":"","isChecked":true},"storeNameKanji":{"text":"","isChecked":true,"isRequired":false}},"hideTitle":false,"remarkType":0,"componentName":"baseInfo","remarkFontSizeType":0,"isAttachedStoreFormat":false}
`baseInfoBusinessHours`	{"title":"営業時間","keyword":"","remarks":{"top":"","bottom":""},"hideTitle":false,"remarkType":3,"componentName":"baseInfoBusinessHours","remarkFontSizeType":1,"baseInfoBusinessHours":{"specialHoursDescription":{"text":"下記もご確認ください","hideFlag":false},"specialHoursHolidayNotation":{"text":"定休日","color":"000000"},"businessHoursHolidayNotation":{"text":""}},"isAttachedStoreFormat":false}
`businessHours`	[object Object], [object Object], [object Object], [object Object], [object Object], [object Object]
`businessStatus`	OPEN
`checkBoxLabel`	{"title":"ラベル","keyword":"","remarks":{"top":"","bottom":""},"hideTitle":false,"remarkType":0,"checkBoxLabel":{"items":[{"id":"dff5d435-1009-11ee-a148-0a58a9feac02","label":"365日営業","checked":false,"keyword":""},{"id":"dff5d43f-1009-11ee-a148-0a58a9feac02","label":"24時間営業","checked":false,"keyword":""},{"id":"dff5d441-1009-11ee-a148-0a58a9feac02","label":"19時以降も営業","checked":false,"keyword":""},{"id":"dff5d443-1009-11ee-a148-0a58a9feac02","label":"日曜営業","checked":false,"keyword":""},{"id":"dff5d444-1009-11ee-a148-0a58a9feac02","label":"土曜営業","checked":true,"keyword":""}]},"componentName":"checkBoxLabel","remarkFontSizeType":0,"isAttachedStoreFormat":false}
`cmsItemValues`	[object Object], [object Object]
`distanceKm`	—
`id`	29340
`inputUrl`	{"title":"固定ボタン","keyword":"","remarks":{"top":"","bottom":""},"inputUrl":{"items":[{"id":"e5110ebe-e01d-11ed-a170-0a58a9feac02","url":"https://www.google.com/maps?daddr=〒336-0926埼玉県さいたま市緑区東浦和2丁目18-3さくら薬局東浦和店&saddr=My+Location","label":"経路案内","isEdit":true,"checked":true,"keyword":""},{"id":"e5110ec8-e01d-11ed-a170-0a58a9feac02","url":"tel:048-762-7247","label":"電話する","isEdit":true,"checked":true,"keyword":""}]},"hideTitle":false,"remarkType":0,"componentName":"inputUrl","remarkFontSizeType":0,"isAttachedStoreFormat":false}
`inputUrlWithModal`	—
`isShowNearby`	true
`latitude`	35.86118000000000000000
`longitude`	139.70139000000000000000
`mapStoreNameDisplayType`	0
`nameKana`	—
`nameKanji`	さくら薬局東浦和店
`openingDate`	2026-09-01
`phoneNumber`	048-762-7247
`postalCode`	336-0926
`searchKeywords`	—
`selectArea`	—
`selectBrand`	{"title":"ブランド","keyword":"","remarks":{"top":"","bottom":""},"hideTitle":false,"remarkType":0,"selectBrand":{"items":[{"brand":{"id":"f2e687a7-e01b-11ed-b7d3-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/783/20230714125535logo.webp","label":"調剤薬局"},"brandGroup":{"id":null,"label":null}}],"selected":{"item":{"brand":{"id":"f2e687a7-e01b-11ed-b7d3-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/783/20230714125535logo.webp","label":"調剤薬局"},"brandGroup":{"id":null,"label":null}},"keyword":""}},"componentName":"selectBrand","remarkFontSizeType":0,"isAttachedStoreFormat":false}
`specialHours`	[object Object], [object Object], [object Object], [object Object], [object Object], [object Object]
`storeCode`	4481
`storeId`	152256

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/sakura-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.