S
Satsudora (サツドラ) store data
194 stores · 55 fields · As of 2026-07-15 · Updated daily
Monthly plan
¥1,940/mo
¥10/store × 194 stores
50% OFF
Annual plan
¥970/mo
Annual total ¥11,640 (¥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 Satsudora (サツドラ)-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 |
Satsudora (サツドラ)-specific attributes
| Column | Fill rate |
|---|---|
id | 100% |
address | 100% |
gbpName | 100% |
placeId | 100% |
storeId | 100% |
baseInfo | 100% |
inputUrl | 100% |
latitude | 100% |
nameKana | 100% |
parentId | 100% |
longitude | 100% |
nameKanji | 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 | 北海道札幌市南区川沿３条３丁目３−１０ |
prefecture | 北海道 |
postal_code | 005-0803 |
latitude | 42.9961913 |
longitude | 141.331437 |
nearest_station | — |
access_info | — |
floor | — |
building | — |
phone | 011-572-5901 |
fax | — |
email | — |
store_url | https://shop.satudora.co.jp/detail/store-kawazoe/ |
business_hours | 09:00-21:00 |
closed_days | — |
last_order_time | — |
open_24h | — |
open_date | 2018-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 | true |
atm | — |
pharmacy | true |
price_range | — |
reservation_url | — |
photo_url | https://meocloud-image.can-ly.com/images/cms/edited/companies/659/stores/53532/20250724180824191%E3%80%80%E5%B7%9D%E6%B2%BF%E5%BA%97%EF%BC%882025%E5%B9%B46%E6%9C%88%E6%92%AE%E5%BD%B1%EF%BC%89.webp |
services | 購入品宅配, 給水器, AED, 食品, 酒類, 米, たばこ, 日配品, アイス, 精肉, 青果 |
notes | 併設薬局: サツドラ薬局 川沿店（TEL 011-205-3810） 営業時間: 月:10:00-14:00,15:00-19:00 火:10:00-14:00,15:00-19:00 水:10:00-14:00,15:00-19:00 木:10:00-14:00,15:00-19:00 金:10:00-14:00,15:00-19:00 |
address | 北海道札幌市南区川沿３条３丁目３−１０ |
attachedStore | {"id":25000,"address":"北海道札幌市南区川沿3条3丁目3番10号（サツドラ川沿店内）","gbpName":"サツドラ薬局 川沿店","storeId":128738,"latitude":"42.99619130000000000000","nameKana":"","parentId":659,"longitude":"141.33143700000000000000","nameKanji":"サツドラ薬局 川沿店","storeCode":"pharmacy-kawazoe","distanceKm":null,"postalCode":"005-0803","openingDate":null,"phoneNumber":"011-205-3810","isShowNearby":true,"specialHours":[{"id":4565990,"endDate":null,"isClosed":true,"openTime":null,"closeTime":null,"startDate":"2025-12-27"},{"id":4565991,"endDate":null,"isClosed":true,"openTime":null,"closeTime":null,"startDate":"2025-12-28"},{"id":4565993,"endDate":null,"isClosed":true,"openTime":null,"closeTime":null,"startDate":"2025-12-30"},{"id":4565995,"endDate":null,"isClosed":true,"openTime":null,"closeTime":null,"startDate":"2025-12-31"},{"id":4565997,"endDate":null,"isClosed":true,"openTime":null,"closeTime":null,"startDate":"2026-01-01"},{"id":4565999,"endDate":null,"isClosed":true,"openTime":null,"closeTime":null,"startDate":"2026-01-02"},{"id":4566001,"endDate":null,"isClosed":true,"openTime":null,"closeTime":null,"startDate":"2026-01-03"},{"id":4566003,"endDate":null,"isClosed":true,"openTime":null,"closeTime":null,"startDate":"2026-01-04"}],"businessHours":[{"name":"MONDAY","openTime":"10:00:00","closeTime":"14:00:00"},{"name":"TUESDAY","openTime":"10:00:00","closeTime":"14:00:00"},{"name":"WEDNESDAY","openTime":"10:00:00","closeTime":"14:00:00"},{"name":"THURSDAY","openTime":"10:00:00","closeTime":"14:00:00"},{"name":"FRIDAY","openTime":"10:00:00","closeTime":"14:00:00"},{"name":"MONDAY","openTime":"15:00:00","closeTime":"19:00:00"},{"name":"TUESDAY","openTime":"15:00:00","closeTime":"19:00:00"},{"name":"WEDNESDAY","openTime":"15:00:00","closeTime":"19:00:00"},{"name":"THURSDAY","openTime":"15:00:00","closeTime":"19:00:00"},{"name":"FRIDAY","openTime":"15:00:00","closeTime":"19:00:00"}],"cmsItemValues":[{"id":25692145,"content":{"title":"電話番号","keyword":"","remarks":{"top":"","bottom":"FAX番号 011-205-3816"},"hideTitle":false,"remarkType":2,"baseInfoPhone":{},"componentName":"baseInfoPhone","remarkFontSizeType":0,"isAttachedStoreFormat":true},"cmsItemId":2550},{"id":25692146,"content":{"title":"営業時間","keyword":"","remarks":{"top":"","bottom":"（祝日：定休日）"},"hideTitle":false,"remarkType":2,"componentName":"baseInfoBusinessHours","remarkFontSizeType":0,"baseInfoBusinessHours":{"specialHoursDescription":{"text":"","hideFlag":false},"specialHoursHolidayNotation":{"text":"","color":""},"businessHoursHolidayNotation":{"text":""}},"isAttachedStoreFormat":true},"cmsItemId":2551},{"id":25692147,"content":{"title":"ドラッグストア店舗サービス","keyword":"shop_service","remarks":{"top":"","bottom":""},"hideTitle":false,"remarkType":0,"componentName":"checkBoxIconText","checkBoxIconText":{"items":[{"id":"a02fc092-44aa-11f0-871b-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/202506261656051_%E7%AC%AC%E4%B8%80%E9%A1%9E%E5%8C%BB%E8%96%AC%E5%93%81%E5%8F%96%E6%89%B1%28%E6%96%BC%20%E3%83%88%E3%82%99%E3%83%A9%E3%83%83%E3%82%AF%E3%82%99%E3%82%B9%E3%83%88%E3%82%A2%29.webp","label":"第一類医薬品（於 ドラッグストア）","checked":false,"keyword":"shop_service"},{"id":"2a102326-44ab-11f0-871b-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/202506261656052_%E7%AC%AC%E4%B8%80%E9%A1%9E%E5%8C%BB%E8%96%AC%E5%93%81%28%E6%96%BC%20%E4%BD%B5%E8%A8%AD%E8%AA%BF%E5%89%A4%E8%96%AC%E5%B1%80%29.webp","label":"第一類医薬品（於 併設調剤薬局）","checked":false,"keyword":"shop_service"},{"id":"2a102332-44ab-11f0-871b-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/202506261656053_%E9%A7%90%E8%BB%8A%E5%A0%B4.webp","label":"駐車場","checked":false,"keyword":"shop_service"},{"id":"2a102335-44ab-11f0-871b-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/202506261656054_%E6%B7%B1%E5%A4%9C%E5%96%B6%E6%A5%AD%E5%BA%97%2822%E6%99%82%E4%BB%A5%E9%99%8D%E5%96%B6%E6%A5%AD%E5%BA%97%E8%88%97%29.webp","label":"深夜営業店（22時以降営業店舗）","checked":false,"keyword":"shop_service"},{"id":"2a102336-44ab-11f0-871b-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/202506261656055_%E5%85%8D%E7%A8%8E%E5%AF%BE%E5%BF%9C.webp","label":"免税対応","checked":false,"keyword":"shop_service"},{"id":"2a102337-44ab-11f0-871b-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/202506261656056_%E6%89%8B%E3%81%B5%E3%82%99%E3%82%89%E4%BE%BF%E5%AF%BE%E5%BF%9C%E2%80%BB%E9%81%93%E5%86%85%E5%AE%9A%E9%A1%8D%E9%85%8D%E9%80%81%E3%82%B5%E3%83%BC%E3%83%92%E3%82%99%E3%82%B9.webp","label":"手ぶら便対応※道内定額配送サービス","checked":false,"keyword":"shop_service"},{"id":"2a102338-44ab-11f0-871b-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/202506261656057_%E7%B5%A6%E6%B0%B4%E6%A9%9F.webp","label":"給水機","checked":false,"keyword":"shop_service"},{"id":"2a102339-44ab-11f0-871b-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/202506261656058_%E8%A8%BC%E6%98%8E%E5%86%99%E7%9C%9F%E6%A9%9F.webp","label":"証明写真機","checked":false,"keyword":"shop_service"},{"id":"2a10233a-44ab-11f0-871b-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/202506261656059_%E3%83%9E%E3%83%AB%E3%83%81%E3%82%B3%E3%83%92%E3%82%9A%E3%83%BC%E8%A1%8C%E6%94%BF%E3%82%B5%E3%83%BC%E3%83%92%E3%82%99%E3%82%B9.webp","label":"コピー機","checked":false,"keyword":"shop_service"},{"id":"2a10233b-44ab-11f0-871b-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/2025062616560510_amazonhub%E3%83%AD%E3%83%83%E3%82%AB%E3%83%BC.webp","label":"amazon hubロッカー","checked":false,"keyword":"shop_service"},{"id":"2a10233c-44ab-11f0-871b-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/2025062616560511_PUDOstation.webp","label":"PUDO station","checked":false,"keyword":"shop_service"},{"id":"2a10233d-44ab-11f0-871b-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/2025062616560512_AED%E8%A8%AD%E7%BD%AE.webp","label":"AED設置店","checked":false,"keyword":"shop_service"},{"id":"e18452a8-21a3-11f1-a5e2-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/2026031710515620260313-141220.webp","label":"モバイルバッテリーレンタル（充レン）","checked":false,"keyword":"shop_service"}],"maxColumnCount":2},"remarkFontSizeType":0,"isAttachedStoreFormat":true},"cmsItemId":2902},{"id":25692148,"content":{"title":"取扱商品","keyword":"goods","remarks":{"top":"","bottom":""},"hideTitle":false,"remarkType":0,"componentName":"checkBoxIconText","checkBoxIconText":{"items":[{"id":"fcb4c4fd-23ce-11f0-9bec-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/202506261701201_%E9%A3%9F%E5%93%81.webp","label":"食品","checked":false,"keyword":"goods"},{"id":"fcb4c507-23ce-11f0-9bec-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/202506261701202_%E9%85%92.webp","label":"酒","checked":false,"keyword":"goods"},{"id":"fcb4c50b-23ce-11f0-9bec-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/202506261701203_%E3%81%8A%E7%B1%B3.webp","label":"お米","checked":false,"keyword":"goods"},{"id":"fcb4c50d-23ce-11f0-9bec-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/202506261701204_%E3%82%BF%E3%83%8F%E3%82%99%E3%82%B3.webp","label":"タバコ","checked":false,"keyword":"goods"},{"id":"fcb4c510-23ce-11f0-9bec-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/202506261701205_%E6%97%A5%E9%85%8D%E5%93%81.webp","label":"日配品","checked":false,"keyword":"goods"},{"id":"fcb4c512-23ce-11f0-9bec-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/202506261701206_%E3%82%A2%E3%82%A4%E3%82%B9.webp","label":"アイス","checked":false,"keyword":"goods"},{"id":"fcb4c515-23ce-11f0-9bec-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/202506261701207_%E7%B2%BE%E8%82%89.webp","label":"精肉","checked":false,"keyword":"goods"},{"id":"fcb4c517-23ce-11f0-9bec-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/202506261701208_%E9%9D%92%E6%9E%9C.webp","label":"青果","checked":false,"keyword":"goods"},{"id":"fcb4c519-23ce-11f0-9bec-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/202506261701209_%E6%83%A3%E8%8F%9C.webp","label":"惣菜","checked":false,"keyword":"goods"},{"id":"fcb4c51b-23ce-11f0-9bec-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/2025062617012010_%E8%8A%B1.webp","label":"花","checked":false,"keyword":"goods"},{"id":"fcb4c51e-23ce-11f0-9bec-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/2025062617012011_100%E5%86%86%E3%82%B7%E3%83%A7%E3%83%83%E3%83%95%E3%82%9A.webp","label":"100円ショップ","checked":false,"keyword":"goods"}],"maxColumnCount":2},"remarkFontSizeType":0,"isAttachedStoreFormat":true},"cmsItemId":2558},{"id":25692149,"content":{"title":"調剤薬局サービス","keyword":"pharmacy_service","remarks":{"top":"","bottom":"処方箋のネット予約（無料）は<a href=\"https://satudora.yqb.jp/j/pharmacy-detail/?pharmacy_id=2411&utm_source=hp&utm_medium=organic&utm_campaign=satudora_kawazoe_hp_2501&utm_term=2411&utm_content=banner\">こちら</a>\n当薬局における掲示情報については<a href=\"https://satudora.jp.larksuite.com/base/DMKTbulcOaal3EsO9i5jTN7IpXc?table=tblJByfc26Bf2QKC&view=vewMCejVeV&_ga=2.150817590.1242369394.1750928064-2002150371.1728981584\">こちら</a>"},"hideTitle":false,"remarkType":2,"componentName":"checkBoxIconText","checkBoxIconText":{"items":[{"id":"8740df4b-44ab-11f0-871b-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/202506261658541_%E8%A6%81%E6%8C%87%E5%B0%8E%E5%8C%BB%E8%96%AC%E5%93%81%E3%83%BB%E7%AC%AC%E4%B8%80%E9%A1%9E%E5%8C%BB%E8%96%AC%E5%93%81.webp","label":"要指導医薬品/第一類医薬品","checked":true,"keyword":"pharmacy_service"},{"id":"8740df52-44ab-11f0-871b-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/202506261658542_%E4%B8%80%E8%88%AC%E7%94%A8%E5%8C%BB%E8%96%AC%E5%93%81%E7%AD%89%E3%81%AE%E8%B2%A9%E5%A3%B2.webp","label":"一般用医薬品等の販売","checked":true,"keyword":"pharmacy_service"},{"id":"65185ffe-44ac-11f0-bec1-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/202506261658543_%E7%B7%8A%E6%80%A5%E9%81%BF%E5%A6%8A%E8%96%AC%E3%81%AE%E5%8F%96%E6%89%B1%E3%81%84.webp","label":"緊急避妊薬の取扱い（※ご来局される前にお電話ください）","checked":true,"keyword":"pharmacy_service"},{"id":"65186005-44ac-11f0-bec1-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/202506261658544_%E7%84%A1%E8%8F%8C%E8%A3%BD%E5%89%A4%E8%AA%BF%E5%89%A4%E5%8F%AF%E8%83%BD.webp","label":"無菌製剤調剤可能","checked":false,"keyword":"pharmacy_service"},{"id":"6518600a-44ac-11f0-bec1-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/202506261658545_%E9%AB%98%E5%BA%A6%E7%AE%A1%E7%90%86%E5%8C%BB%E7%99%82%E6%A9%9F%E5%99%A8.webp","label":"高度管理医療機器","checked":true,"keyword":"pharmacy_service"},{"id":"6518600c-44ac-11f0-bec1-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/202506261658546_%E7%A5%9D%E6%97%A5%E5%96%B6%E6%A5%AD.webp","label":"祝日営業","checked":false,"keyword":"pharmacy_service"},{"id":"6518600d-44ac-11f0-bec1-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/202506261658547_%E5%9C%9F%E6%9B%9C%E6%97%A5%E5%96%B6%E6%A5%AD.webp","label":"土曜日営業","checked":false,"keyword":"pharmacy_service"},{"id":"6518600f-44ac-11f0-bec1-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/202506261658548_%E6%97%A5%E6%9B%9C%E6%97%A5%E5%96%B6%E6%A5%AD.webp","label":"日曜日営業","checked":false,"keyword":"pharmacy_service"},{"id":"65186011-44ac-11f0-bec1-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/202506261658549_%20%E5%A4%9C%E9%96%93%E5%96%B6%E6%A5%AD%E2%80%BB18%E6%99%82%E4%BB%A5%E9%99%8D.webp","label":"夜間営業（18時以降営業店舗）","checked":true,"keyword":"pharmacy_service"},{"id":"65186012-44ac-11f0-bec1-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/2025062616585410_%E9%A7%90%E8%BB%8A%E5%A0%B4.webp","label":"駐車場","checked":true,"keyword":"pharmacy_service"},{"id":"a5d5c5ed-44ac-11f0-871b-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/2025062616585411_%E9%A7%85%E8%BF%91%E9%9A%A3%28%E5%BE%92%E6%AD%A95%E5%88%86%E4%BB%A5%E5%86%85%29.webp","label":"駅近隣（徒歩5分以内）","checked":false,"keyword":"pharmacy_service"},{"id":"a5d5c5f3-44ac-11f0-871b-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/2025062616585412_%E8%BB%8A%E6%A4%85%E5%AD%90%E3%81%A6%E3%82%99%E3%81%AE%E6%9D%A5%E5%BA%97.webp","label":"車椅子での来店","checked":true,"keyword":"pharmacy_service"},{"id":"a5d5c5f6-44ac-11f0-871b-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/2025062616585413_%E5%8D%B3%E6%97%A5%E9%85%8D%E9%81%94.webp","label":"即日配達","checked":false,"keyword":"pharmacy_service"},{"id":"a5d5c5f7-44ac-11f0-871b-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/2025062616585414_%E5%9C%A8%E5%AE%85%E8%A8%AA%E5%95%8F.webp","label":"在宅訪問","checked":true,"keyword":"pharmacy_service"},{"id":"a5d5c5f8-44ac-11f0-871b-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/2025062616585415_%E3%81%8A%E3%81%8F%E3%81%99%E3%82%8A%E5%8F%97%E3%81%91%E5%8F%96%E3%82%8A%E3%83%AD%E3%83%83%E3%82%AB%E3%83%BC.webp","label":"おくすり受け取りロッカー","checked":false,"keyword":"pharmacy_service"},{"id":"a5d5c5f9-44ac-11f0-871b-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/2025062616585416_%E3%81%8A%E8%96%AC%E3%81%AE%E4%B8%80%E5%8C%85%E5%8C%96.webp","label":"お薬の一包化","checked":true,"keyword":"pharmacy_service"},{"id":"a5d5c5fa-44ac-11f0-871b-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/2025062616585417_%E6%B3%A8%E5%B0%84%E9%87%9D%E5%9B%9E%E5%8F%8E.webp","label":"注射針回収","checked":true,"keyword":"pharmacy_service"},{"id":"bed0a078-44ac-11f0-bec1-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/2025062616585418_%E3%82%A6%E3%82%A9%E3%83%BC%E3%82%BF%E3%83%BC%E3%82%B5%E3%83%BC%E3%83%8F%E3%82%99%E3%83%BC.webp","label":"ウォーターサーバー","checked":true,"keyword":"pharmacy_service"},{"id":"bed0a080-44ac-11f0-bec1-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/2025062616585419_%E3%82%AD%E3%83%83%E3%82%B9%E3%82%99%E3%82%B9%E3%83%98%E3%82%9A%E3%83%BC%E3%82%B9.webp","label":"キッズスペース","checked":false,"keyword":"pharmacy_service"},{"id":"bed0a084-44ac-11f0-bec1-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/2025062616585420_%E6%84%9F%E6%9F%93%E3%83%BB%E7%81%BD%E5%AE%B3%E7%AD%89%E7%99%BA%E6%B3%A8%E6%99%82%E3%81%AB%E8%96%AC%E5%89%A4%E4%BE%9B%E7%B5%A6%E7%AD%89%E3%82%92%E8%A1%8C%E3%81%86%E4%BD%93%E5%88%B6.webp","label":"感染・災害発生時に薬剤供給等を行う体制","checked":false,"keyword":"pharmacy_service"}],"maxColumnCount":2},"remarkFontSizeType":0,"isAttachedStoreFormat":true},"cmsItemId":2556},{"id":25692150,"content":{"title":"対応可能な保険調剤","keyword":"dispensing","remarks":{"top":"","bottom":""},"hideTitle":false,"remarkType":0,"componentName":"checkBoxIconText","checkBoxIconText":{"items":[{"id":"4bbf302e-23ce-11f0-9bec-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/202506261700301_%E7%94%9F%E6%B4%BB%E4%BF%9D%E8%AD%B7.webp","label":"生活保護","checked":true,"keyword":"dispensing"},{"id":"4bbf304c-23ce-11f0-9bec-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/202506261700302_%E7%B5%90%E6%A0%B8%E5%8C%BB%E7%99%82.webp","label":"結核医療","checked":true,"keyword":"dispensing"},{"id":"4bbf304f-23ce-11f0-9bec-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/202506261700303_%E7%B2%BE%E7%A5%9E%E9%80%9A%E9%99%A2.webp","label":"精神通院","checked":true,"keyword":"dispensing"},{"id":"4bbf3052-23ce-11f0-9bec-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/202506261700304_%E6%9B%B4%E7%94%9F%E3%83%BB%E8%82%B2%E6%88%90%E5%8C%BB%E7%99%82.webp","label":"更生・育成医療","checked":true,"keyword":"dispensing"},{"id":"4bbf3054-23ce-11f0-9bec-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/202506261700305_%E9%9B%A3%E7%97%85%E3%83%BB%E5%B0%8F%E5%85%90%E6%85%A2%E6%80%A7%E7%89%B9%E5%AE%9A%E7%96%BE%E7%97%85.webp","label":"難病・小児慢性特定疾病","checked":true,"keyword":"dispensing"},{"id":"4bbf3057-23ce-11f0-9bec-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/202506261700306_%E5%8A%B4%E7%81%BD%E5%AF%BE%E5%BF%9C%E5%8F%AF%E8%83%BD.webp","label":"労災対応可能","checked":true,"keyword":"dispensing"},{"id":"4bbf305a-23ce-11f0-9bec-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/202506261700307_%E8%87%AA%E8%B3%A0%E8%B2%AC%E5%AF%BE%E5%BF%9C%E5%8F%AF%E8%83%BD.webp","label":"自賠責対応可能","checked":true,"keyword":"dispensing"},{"id":"4bbf305b-23ce-11f0-9bec-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/202506261700308_%E3%82%AA%E3%83%B3%E3%83%A9%E3%82%A4%E3%83%B3%E8%B3%87%E6%A0%BC%E7%A2%BA%E8%AA%8D.webp","label":"オンライン資格確認","checked":true,"keyword":"dispensing"}],"maxColumnCount":2},"remarkFontSizeType":0,"isAttachedStoreFormat":true},"cmsItemId":2557}],"businessStatus":"OPEN","searchKeywords":"","attachedStoreId":53532,"attachedStoreType":2,"mapStoreNameDisplayType":0} |
attachedStoreId | 128738 |
attachedStoreType | 1 |
baseInfo | {"title":"-","keyword":"","remarks":{"top":"","bottom":""},"baseInfo":{"seo":{"isChecked":false},"latlng":{"latitude":"42.9961913","longitude":"141.331437"},"storeCode":{"text":"store-kawazoe"},"isShowNearby":{"isChecked":true},"publishStatus":{"isPublished":true},"storeNameKana":{"text":"","isChecked":true,"isRequired":false},"searchKeywords":{"text":"薬局 免税 taxfree","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":2,"componentName":"baseInfoBusinessHours","remarkFontSizeType":0,"baseInfoBusinessHours":{"specialHoursDescription":{"text":"","hideFlag":false},"specialHoursHolidayNotation":{"text":"","color":""},"businessHoursHolidayNotation":{"text":""}},"isAttachedStoreFormat":true} |
businessHours | [object Object], [object Object], [object Object], [object Object], [object Object], [object Object], [object Object] |
businessStatus | OPEN |
checkBoxLabel | {"title":"ラベル","keyword":"label","remarks":{"top":"","bottom":""},"hideTitle":false,"remarkType":0,"checkBoxLabel":{"items":[{"id":"ded5abea-44a8-11f0-bec1-0a58a9feac02","label":"ドラッグストア","checked":false,"keyword":"label"},{"id":"8b1564d3-23c9-11f0-9bec-0a58a9feac02","label":"調剤薬局","checked":true,"keyword":"label"},{"id":"337912cc-3616-11f0-b5ba-0a58a9feac02","label":"免税対応店","checked":true,"keyword":"label"}]},"componentName":"checkBoxLabel","remarkFontSizeType":0,"isAttachedStoreFormat":false} |
cmsItemValues | [object Object], [object Object], [object Object], [object Object], [object Object], [object Object], [object Object], [object Object], [object Object], [object Object], [object Object], [object Object], [object Object], [object Object], [object Object] |
distanceKm | — |
gbpName | サツドラ川沿店 |
id | 21308 |
inputUrl | {"title":"固定ボタン","keyword":"","remarks":{"top":"","bottom":""},"inputUrl":{"items":[{"id":"6009bab3-23c9-11f0-9bec-0a58a9feac02","url":"https://www.google.com/maps/dir/?api=1&destination=〒005-0803北海道札幌市南区川沿３条３丁目３−１０ サツドラ川沿店&origin=My+Location","label":"ルート検索","isEdit":true,"checked":true,"keyword":""},{"id":"2365f1f3-71c5-11f0-a96a-0a58a9feac02","url":"https://satudora.yqb.jp/j/pharmacy-detail/?pharmacy_id=2411&utm_source=hp&utm_medium=organic&utm_campaign=satudora_kawazoe_hp_2501&utm_term=2411&utm_content=banner","label":"処方箋を送る","isEdit":true,"checked":true,"keyword":""}]},"hideTitle":false,"remarkType":0,"componentName":"inputUrl","remarkFontSizeType":0,"isAttachedStoreFormat":false} |
inputUrlWithModal | — |
isShowNearby | true |
latitude | 42.99619130000000000000 |
longitude | 141.33143700000000000000 |
mapStoreNameDisplayType | 0 |
nameKana | — |
nameKanji | サツドラ川沿店 |
openingDate | 2018-09-01 |
parentId | 659 |
phoneNumber | 011-572-5901 |
placeId | ChIJmQm1rwnVCl8RzJEsebNPSuE |
postalCode | 005-0803 |
searchKeywords | 薬局 免税 taxfree |
selectArea | — |
selectBrand | {"title":"ブランド","keyword":"","remarks":{"top":"","bottom":""},"hideTitle":false,"remarkType":0,"selectBrand":{"items":[{"brand":{"id":"a8a7b32a-21b3-11f0-ad88-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/20250428093608%E3%83%95%E3%82%99%E3%83%A9%E3%83%B3%E3%83%88%E3%82%99%E3%83%AD%E3%82%B3%E3%82%99_144%C3%97144%20%281%29.webp","label":"サツドラ"},"brandGroup":{"id":null,"label":null}}],"selected":{"item":{"brand":{"id":"a8a7b32a-21b3-11f0-ad88-0a58a9feac02","img":"https://meocloud-image.can-ly.com/images/cms/managed/companies/659/20250428093608%E3%83%95%E3%82%99%E3%83%A9%E3%83%B3%E3%83%88%E3%82%99%E3%83%AD%E3%82%B3%E3%82%99_144%C3%97144%20%281%29.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 | store-kawazoe |
storeId | 53532 |
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/satsudora/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 Satsudora (サツドラ)'s 194 store data today
Annual plan: ¥970/mo (¥5/store/mo). Cancel anytime.