K
Kyorindo (杏林堂) store data
103 stores · 55 fields · As of 2026-07-15 · Updated daily
Monthly plan
¥1,030/mo
¥10/store × 103 stores
50% OFF
Annual plan
¥515/mo
Annual total ¥6,180 (¥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 Kyorindo (杏林堂)-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 |
Kyorindo (杏林堂)-specific attributes
| Column | Fill rate |
|---|---|
logo | 100% |
meta | 100% |
name | 100% |
slug | 100% |
hours | 100% |
address | 100% |
c_faxWeb | 100% |
c_lINEID | 100% |
timezone | 100% |
googleCid | 100% |
mainPhone | 100% |
c_nameKana | 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 | DRUGSTORE |
address | 静岡県静岡市三保111-2 |
prefecture | 静岡県 |
postal_code | 424-0901 |
latitude | 34.9986429 |
longitude | 138.5158035 |
nearest_station | — |
access_info | — |
floor | — |
building | — |
phone | 0543341211 |
fax | 054-334-1212 |
email | — |
store_url | https://shop.tsuruha-g.com/2079 |
business_hours | 月:09:00〜22:00 火:09:00〜22:00 水:09:00〜22:00 木:09:00〜22:00 金:09:00〜22:00 土:09:00〜22:00 日:09:00〜22:00 |
closed_days | — |
last_order_time | — |
open_24h | false |
open_date | 2009-10-20 |
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 | — |
elevator | — |
wifi | — |
power_outlets | — |
pet_friendly | — |
serves_alcohol | true |
tax_free_shopping | true |
atm | — |
pharmacy | true |
price_range | — |
reservation_url | — |
photo_url | — |
services | ウォーターサーバー, 証明写真, 100円ショップ, ベーカリー, コピー機, 収納代行, 管理栄養士相談, AED, 第一類医薬品, オンライン服薬指導, マイナ受付, 在宅医療対応, 電子処方箋, 災害対応薬局 |
notes | 調剤受付: 月:09:00〜19:00 火:09:00〜19:00 水:09:00〜19:00 木:09:00〜19:00 金:09:00〜19:00 土:09:00〜19:00 日:定休 |
_pharmacy_entity | {"logo":{"image":{"url":"https://a.mktgcdn.com/p/6Vb7c4MHQbnxfsextDd3d9v-xHdn-Y9m3MUi6tFYupM/512x512.png","width":512,"height":512,"thumbnails":[{"url":"https://a.mktgcdn.com/p/6Vb7c4MHQbnxfsextDd3d9v-xHdn-Y9m3MUi6tFYupM/512x512.png","width":512,"height":512},{"url":"https://a.mktgcdn.com/p/6Vb7c4MHQbnxfsextDd3d9v-xHdn-Y9m3MUi6tFYupM/150x150.png","width":150,"height":150},{"url":"https://a.mktgcdn.com/p/6Vb7c4MHQbnxfsextDd3d9v-xHdn-Y9m3MUi6tFYupM/94x94.png","width":94,"height":94}],"alternateText":"杏林堂薬局"},"details":"杏林堂薬局","description":"杏林堂薬局"},"meta":{"id":"2079c","uid":"1018831456","labels":["add101123","開店中"],"folderId":"調剤薬局4","language":"ja","accountId":"5224829878542080524","timestamp":"2026-07-09T04:45:21","entityType":"location","countryCode":"JP","schemaTypes":["Pharmacy","ConvenienceStore"],"createdTimestamp":"2023-10-11T01:54:35"},"name":"杏林堂薬局 清水三保店 調剤","slug":"2079c","hours":{"friday":{"openIntervals":[{"end":"19:00","start":"09:00"}]},"monday":{"openIntervals":[{"end":"19:00","start":"09:00"}]},"sunday":{"isClosed":true},"tuesday":{"openIntervals":[{"end":"19:00","start":"09:00"}]},"saturday":{"openIntervals":[{"end":"19:00","start":"09:00"}]},"thursday":{"openIntervals":[{"end":"19:00","start":"09:00"}]},"wednesday":{"openIntervals":[{"end":"19:00","start":"09:00"}]}},"address":{"city":"静岡市","line1":"三保111-2","region":"静岡県","postalCode":"424-0901","countryCode":"JP","sublocality":"清水区"},"c_faxWeb":[{"link":"0120-77-6508","label":"フリーダイヤル","linkType":"OTHER"},{"link":"054-334-2012","label":"固定FAX","linkType":"OTHER"}],"c_lINEID":"049upbpe","timezone":"Asia/Tokyo","googleCid":"10721517699434224914","mainPhone":"+81543342011","c_nameKana":"シミズミホテン","c_pagesURL":"https://shop.tsuruha-g.com/2079c","websiteUrl":{"url":"https://shop.tsuruha-g.com/2079c"},"c_localized":true,"categoryIds":["1634231","178","1379996"],"description":"処方せん受付に関して、全国どこの医療機関の処方せんも受付可能です。『電子処方せん』『オンライン服薬指導』『リフィル処方せん』などにも対応しています。お支払いは、全店クレジットカード・電子マネー・QRコード決済にも対応しています。ドラッグストア併設の為、待ち時間を利用しお買い物をして頂けます。LINEを利用した処方せん予約システムにより、待ち時間を短縮する事やお薬をお渡しした後のサポートも可能ですので、当店処方せん受付にてお声掛け下さい。","c_shopStatus":"OPEN","generatedFaq":[{"answer":"杏林堂薬局 清水三保店 調剤 is open from 9:00 AM to 7:00 PM Monday through Saturday and is closed on Sundays.","question":"What are the business hours of 杏林堂薬局 清水三保店 調剤?"},{"answer":"It is located at 三保111-2, 清水区, 静岡市, 静岡県, postal code 424-0901, Japan.","question":"Where is 杏林堂薬局 清水三保店 調剤 located?"},{"answer":"杏林堂薬局 清水三保店 調剤 is a pharmacy under the Kyorindo category.","question":"What type of business is 杏林堂薬局 清水三保店 調剤?"},{"answer":"The main phone number is +81 543 342 011.","question":"What is the contact phone number for 杏林堂薬局 清水三保店 調剤?"},{"answer":"Yes, you can visit their website at https://shop.tsuruha-g.com/2079c.","question":"Does 杏林堂薬局 清水三保店 調剤 have a website?"},{"answer":"Yes, nearby related places under the same name offer pharmacy, cosmetic and beauty supplies, and beauty and spa services.","question":"Does 杏林堂薬局 清水三保店 調剤 provide any beauty or cosmetic products?"},{"answer":"Yes, 杏林堂 清水三保店 is a nearby drugstore, convenient for additional health and wellness needs.","question":"Are there any nearby drugstores near 杏林堂薬局 清水三保店 調剤?"},{"answer":"静岡銀行 三保支店 (Shizuoka Bank Miho Branch) is located nearby for your banking needs.","question":"Which banks are near 杏林堂薬局 清水三保店 調剤?"},{"answer":"Yes, 髪工房Ishigaya is a nearby beauty salon offering beauty and spa services in the area.","question":"Are there any beauty salons close to 杏林堂薬局 清水三保店 調剤?"},{"answer":"Yes, 三保行政書士事務所 provides legal services and is located nearby for your legal consultation needs.","question":"Is there any legal service office near 杏林堂薬局 清水三保店 調剤?"}],"phoneticName":"シミズミホテン","savedFilters":["248649","248774","248863","249773","249829","250049","250050","250372","250373","262774"],"c_brandFilter":"KYORINDO_DRUGSTORE","googlePlaceId":"ChIJoagusksxGmAREh3X54p7ypQ","isoRegionCode":"22","appleCompanyId":"1465525096352787968","brandReference":"tsuruhaBrand","c_linkPharmacy":["2079"],"c_sf_storeType":"DISPENSING_PHARMACY","cityCoordinate":{"latitude":34.9755973815918,"longitude":138.3827667236328},"appleBusinessId":"1553579475422773248","c_yahooPlaceSeq":"628567","googleAccountId":"113305931334339646076","appleDisplayName":"杏林堂薬局 清水三保店 調剤","c_dispensingForm":"WITH_DISPENSING_PHARMACY","c_instorePharmacy":true,"displayCoordinate":{"latitude":34.99873,"longitude":138.51583},"timeZoneUtcOffset":"+09:00","c_amazonPharmacyID":"A3OIEFEDC2HF6U","geocodedCoordinate":{"latitude":34.9987342,"longitude":138.5155418},"googleProfilePhoto":{"url":"https://a.mktgcdn.com/p/6Vb7c4MHQbnxfsextDd3d9v-xHdn-Y9m3MUi6tFYupM/512x512.png","width":512,"height":512,"thumbnails":[{"url":"https://a.mktgcdn.com/p/6Vb7c4MHQbnxfsextDd3d9v-xHdn-Y9m3MUi6tFYupM/512x512.png","width":512,"height":512}],"alternateText":"杏林堂薬局"},"c_regularClosingDay":"日・祝","c_yahooAuthEntityId":"oauth-settings-yahoo","dm_directoryParents":["defaultDirectory","defaultDirectory_jing_gang_xian","defaultDirectory_jing_gang_xian_jing_gang_shi"],"c_isHoursFlagInvalid":false,"c_appIntegrationBrand":"KYORINDO_SUPER_DRUG_STORE","c_linePrescriptionURL":"https://line-auth-proxy.pocket-musubi.net/api/authorize/?client_id=2002496281&pharmacy_id=4017®istration_route=musubi_web_questionnaire","yextDisplayCoordinate":{"latitude":34.9986429,"longitude":138.5158035},"c_sa_dp_homeMedicalCare":true,"appleBusinessDescription":"処方せん受付に関して、全国どこの医療機関の処方せんも受付可能です。『電子処方せん』『オンライン服薬指導』『リフィル処方せん』などにも対応しています。お支払いは、全店クレジットカード・電子マネー・QRコード決済にも対応しています。ドラッグストア併設の為、待ち時間を利用しお買い物をして頂けます。LINEを利用した処方せん予約システムにより、待ち時間を短縮する事やお薬をお渡しした後のサポートも可能ですので、当店処方せん受付にてお声掛け下さい。","c_sf_productLineMedicines":["EMERGENCY_CONTRACEPTIVES","BLOOD_GLUCOSE_LEVEL_MONITORING_DEVICES"],"c_pharmacyAvailableAfter17":true,"c_sa_dp_dispensingPharmacy":true,"c_pharmacyAvailableBefore10":true,"c_sa_dp_providingAfterhours":true,"c_sa_dp_pharmacyPickUpLocker":false,"c_sa_fd_basicDispensingFee3C":true,"c_sa_dp_healthSupportPharmacy":false,"c_sa_fd_asepticPreparationFee":true,"c_sa_dp_electronicPrescription":true,"c_sf_dispensingPharmacyRelated":["DISPENSING_PHARMACY","ONLINE_MEDICATION_GUIDANCE","ONLINE_QUALIFICATION_VERIFICATION","HOME_MEDICAL_CARE","ELECTRONIC_PRESCRIPTION","DISPENSING_EMERGENCY_CONTRACEPTIVES_VIA_ONLINE_MEDICAL_CONSULTATIONS","DISASTER_AND_EMERGING_INFECTIOUS_DISEASE_PREPAREDNESS","ACCESS_TO_MEDICAL_INFORMATION_USING_THE_INDIVIDUAL_NUMBER_CARD","PROVIDING_AFTER-HOURS_HOME_HEALTHCARE"],"c_sa_dp_driveThruPharmacyService":false,"c_sa_dp_onlineMedicationGuidance":true,"c_sa_fd_homePharmaCareSystemTier1":true,"c_sa_pl_meds_medicalAntigenTestKit":false,"c_sa_pl_meds_selfcollectionOfBlood":false,"c_sa_dp_usingTheIndividualNumberCard":true,"c_sf_businessHoursDispensingPharmacy":["ACCEPTS_CUSTOMERS_FROM_BEFORE_10:00","ACCEPTS_CUSTOMERS_EVEN_AFTER_17:00"],"c_sf_dispensingPharmacyRelatedFSWADN":["BASIC_DISPENSING_FEE_3C","COMMUNITY_SUPPORT_SYSTEM_ADDITION_4","MEDICAL_DX_PROMOTION_SYSTEM_DEVELOPMENT_PREMIUM","COLLABORATION_REINFORCEMENT_ADDITION","HOME_PHARMACY_COMPREHENSIVE_SYSTEM_PREMIUM_1","ASEPTIC_PREPARATION_FEE","SPECIFIC_DRUG_MANAGEMENT_GUIDANCE_PREMIUM_2","FAMILY_PHARMACIST_GUIDANCE_FEE_AND_FAMILY_PHARMACIST_COMPREHENSIVE_MANAGEMENT_FEE","HOME_MEDICAL_NARCOTIC_CONTINUOUS_INJECTION_THERAPY_PREMIUM","HOME_PARENTERAL_NUTRITION_PREMIUM","BIO-SIMILAR_DISPENSING_SYSTEM_PREMIUM"],"c_sa_dp_emergencyContraceptivesViaOMC":true,"c_sa_pl_meds_emergencyContraceptives2":true,"c_sa_dp_communityCollaborationPharmacy":false,"c_sa_fd_homeParenteralNutritionPremium":true,"c_sa_dp_onlineQualificationVerification":true,"c_sa_fd_communitySupportSystemAddition4":true,"c_sa_dp_dAAInfectiousDiseasePreparedness":true,"c_sa_dp_expertMedicalClinicLinkedPharmacy":false,"c_sa_fd_biosimilarDispensingSystemPremium":true,"c_sa_fd_collaborationReinforcementAddition":true,"c_sa_fd_homeNarcoticInfusionTherapyPremium":true,"c_sa_fd_medicalDXPromotionSystemDevelopment":true,"c_sa_fd_specificDrugManagementGuidancePremium2":true,"c_sa_pl_meds_bloodGlucoseLevelMonitoringDevices":true,"c_sa_fd_familyPharmacistGuidanceAndManagementFee":true} |
address | {"city":"静岡市","line1":"三保111-2","region":"静岡県","postalCode":"424-0901","countryCode":"JP","sublocality":"清水区"} |
appleBusinessDescription | 杏林堂スーパードラッグストア Kyorindo Super Drug Store(ツルハグループ)は、より近くのドラッグストア(drugstore ・藥妝店・드럭스토어)として信頼され魅力ある店づくりに努めてまいりました。今後も「健康と暮らしのパートナー」を合言葉として専門性に特化した、医薬品、化粧品、健康食品はもちろんのこと、日用品や食品まで幅広い品揃えで皆様のご来店をお待ちしております。 |
appleBusinessId | 1553579475422773248 |
appleCompanyId | 1465525096352787968 |
appleDisplayName | 杏林堂薬局 清水三保店 |
brandReference | tsuruhaBrand |
c_aS1ClosingHour | 22:00 |
c_aS1OpeningHour | 9:00 |
c_aS1ShopCategoryName | 精肉テナント |
c_aS1ShopName | 肉の雅屋 |
c_appIntegrationBrand | KYORINDO_SUPER_DRUG_STORE |
c_brandFilter | KYORINDO_DRUGSTORE |
c_dispensingForm | WITH_DISPENSING_PHARMACY |
c_drugStoreOpenAfter21 | true |
c_drugStoreOpenBefore10 | true |
c_faxWeb | [object Object] |
c_isHoursFlagInvalid | false |
c_lINEID | eza5871w |
c_linkPharmacy | 2079c |
c_localized | true |
c_nameKana | シミズミホテン |
c_openDate | 2009-10-20 |
c_pagesURL | https://shop.tsuruha-g.com/2079 |
c_sa_dp_communityCollaborationPharmacy | false |
c_sa_dp_dispensingPharmacy | true |
c_sa_dp_driveThruPharmacyService | false |
c_sa_dp_electronicPrescription | false |
c_sa_dp_expertMedicalClinicLinkedPharmacy | false |
c_sa_dp_healthSupportPharmacy | false |
c_sa_dp_homeMedicalCare | true |
c_sa_dp_onlineMedicationGuidance | true |
c_sa_dp_onlineQualificationVerification | true |
c_sa_dp_pharmacyPickUpLocker | false |
c_sa_fs_facilities_100yenShop | true |
c_sa_fs_facilities_alkalineIonWaterFeeder | true |
c_sa_fs_facilities_amazonLocker | false |
c_sa_fs_facilities_bakery | true |
c_sa_fs_facilities_collagenMachine | false |
c_sa_fs_facilities_copyMachine | true |
c_sa_fs_facilities_iDPhoto | true |
c_sa_fs_facilities_mercariPost | false |
c_sa_fs_facilities_nailCorner | false |
c_sa_fs_facilities_osteopathyClinic | false |
c_sa_fs_facilities_paidParkingLot | false |
c_sa_fs_facilities_parkingLot | true |
c_sa_fs_facilities_pureWaterFeeder | false |
c_sa_fs_facilities_waterFeeder | false |
c_sa_fs_others_aED | true |
c_sa_fs_others_hairSalon | false |
c_sa_fs_others_inHomeCareSupportCenter | false |
c_sa_fs_others_wastepaperCollection | true |
c_sa_fs_others_welfareEquipment | false |
c_sa_fs_service_AgencyPaymentService | false |
c_sa_fs_service_AtHomeLongTermCareSupport | false |
c_sa_fs_service_ChargeSPOT | false |
c_sa_fs_service_CounterCoffee | false |
c_sa_fs_service_DPE | false |
c_sa_fs_service_DeliveryService | false |
c_sa_fs_service_DutyFreeShop | true |
c_sa_fs_service_HomeCareService | false |
c_sa_fs_service_OnlineSupermarket | false |
c_sa_fs_service_PickGo | false |
c_sa_fs_service_PremiumGiftCertificates | false |
c_sa_fs_service_UberEats | false |
c_sa_fs_service_YamatoTransportPickupService | false |
c_sa_fs_service_YumeCoupon | false |
c_sa_fs_service_serviceRegisteredDietitianConsul | true |
c_sa_fs_service_shutoku | true |
c_sa_pl_cadn_babyProducts | true |
c_sa_pl_cadn_books | true |
c_sa_pl_cadn_cosmetics | true |
c_sa_pl_cadn_dailyNecessities | true |
c_sa_pl_cadn_pOSACard | true |
c_sa_pl_cadn_petProducts | true |
c_sa_pl_cadn_tobacco | false |
c_sa_pl_food_alcoholicBeverages | true |
c_sa_pl_food_dailyDeliveredFoods | true |
c_sa_pl_food_deli | false |
c_sa_pl_food_food | true |
c_sa_pl_food_freshFish | true |
c_sa_pl_food_frozenFoods | true |
c_sa_pl_food_fruitAndVegetables | true |
c_sa_pl_food_healthFoods | true |
c_sa_pl_food_meat | true |
c_sa_pl_food_variousKindsOfRice | true |
c_sa_pl_meds_bloodGlucoseLevelMonitoringDevices | true |
c_sa_pl_meds_coloredContactLenses | true |
c_sa_pl_meds_emergencyContraceptives2 | false |
c_sa_pl_meds_guidancerequiredAndCategory1OTCDrugs | true |
c_sa_pl_meds_medicalAntigenTestKit | false |
c_sa_pl_meds_medicines | true |
c_sa_pl_meds_prescriptionContactLenses | true |
c_sa_pl_meds_selfcollectionOfBlood | false |
c_sa_pm_alipay | true |
c_sa_pm_auPAY | true |
c_sa_pm_creditCard | true |
c_sa_pm_dBarai | true |
c_sa_pm_famiPay | true |
c_sa_pm_fcaMoney | false |
c_sa_pm_ginrenCard | true |
c_sa_pm_hAPPAY | true |
c_sa_pm_iD | true |
c_sa_pm_icCardsForTransportation | true |
c_sa_pm_merpay | true |
c_sa_pm_nAVERPay | false |
c_sa_pm_nanaco | true |
c_sa_pm_nicopi | true |
c_sa_pm_payPay | true |
c_sa_pm_qUICPay | true |
c_sa_pm_rabbitCard | true |
c_sa_pm_rakutenEdy | true |
c_sa_pm_rakutenPay | true |
c_sa_pm_rakutenPointCard | true |
c_sa_pm_tCard | false |
c_sa_pm_tMoney | false |
c_sa_pm_taiwanSmartPay | false |
c_sa_pm_wAONCard | true |
c_sa_pm_weChatPay | false |
c_sf_businessHoursDrugstore | OPEN_BEFORE_10:00, OPEN_EVEN_AFTER_21:00 |
c_sf_dispensingPharmacyRelated | DISPENSING_PHARMACY, ONLINE_MEDICATION_GUIDANCE, ONLINE_QUALIFICATION_VERIFICATION, HOME_MEDICAL_CARE |
c_sf_facilitiesAndServicesFacilities | PARKING_LOT, 100-YEN_SHOP, ALKALINE_ION_WATER_FEEDER, BAKERY, ID_PHOTO, COPY_MACHINE |
c_sf_facilitiesAndServicesOthers | WASTEPAPER_COLLECTION, AED |
c_sf_facilitiesAndServicesServices | SHUTOKU, DUTY-FREE_SHOP, REGISTERED_DIETITIAN_CONSULTATION |
c_sf_paymentMethod | HAPPAY, NICOPI, CREDIT_CARD, RAKUTEN_EDY, ID, GINREN_CARD, IC_CARDS_FOR_TRANSPORTATION, QUICPAY, WAON_CARD, RAKUTEN_POINT_CARD, NANACO, D_BARAI, ALIPAY+, PAYPAY, AU_PAY, MERPAY, RAKUTEN_PAY, RABBIT_CARD, FAMIPAY |
c_sf_productLineCADN | COSMETICS, DAILY_NECESSITIES, BABY_PRODUCTS, PET_PRODUCTS, BOOKS, POSA_CARD |
c_sf_productLineFood | HEALTH_FOODS, DAILY_DELIVERED_FOODS, FROZEN_FOODS, FOOD, VARIOUS_KINDS_OF_RICE, ALCOHOLIC_BEVERAGES, MEAT, FRUIT_AND_VEGETABLES, FRESH_FISH |
c_sf_productLineMedicines | GUIDANCE-REQUIRED_AND_CATEGORY-1_OTC_DRUGS, MEDICINES, BLOOD_GLUCOSE_LEVEL_MONITORING_DEVICES, PRESCRIPTION_CONTACT_LENSES, COLORED_CONTACT_LENSES |
c_sf_storeType | DRUGSTORE |
c_shopStatus | OPEN |
c_shufooID | 860350 |
c_tokubaiID | 19413 |
c_yahooAuthEntityId | oauth-settings-yahoo |
c_yahooPlaceSeq | 628564 |
categoryIds | 1634231, 1379996, 595 |
cityCoordinate | {"latitude":34.9755973815918,"longitude":138.3827667236328} |
description | 杏林堂スーパードラッグストア Kyorindo Super Drug Store(ツルハグループ)は、より近くのドラッグストア(drugstore ・藥妝店・드럭스토어)として信頼され魅力ある店づくりに努めてまいりました。今後も「健康と暮らしのパートナー」を合言葉として専門性に特化した、医薬品、化粧品、健康食品はもちろんのこと、日用品や食品まで幅広い品揃えで皆様のご来店をお待ちしております。 |
displayCoordinate | {"latitude":34.99873,"longitude":138.51583} |
dm_directoryParents | defaultDirectory, defaultDirectory_jing_gang_xian, defaultDirectory_jing_gang_xian_jing_gang_shi |
generatedFaq | [object Object], [object Object], [object Object], [object Object], [object Object], [object Object], [object Object], [object Object], [object Object], [object Object] |
geocodedCoordinate | {"latitude":34.9987342,"longitude":138.5155418} |
googleAccountId | 113305931334339646076 |
googleCid | 1129269144897299962 |
googlePlaceId | ChIJAYZm8AYxGmAR-qVp3U34qw8 |
googleProfilePhoto | {"url":"https://a.mktgcdn.com/p/6Vb7c4MHQbnxfsextDd3d9v-xHdn-Y9m3MUi6tFYupM/512x512.png","width":512,"height":512,"thumbnails":[{"url":"https://a.mktgcdn.com/p/6Vb7c4MHQbnxfsextDd3d9v-xHdn-Y9m3MUi6tFYupM/512x512.png","width":512,"height":512}],"alternateText":"杏林堂薬局"} |
hours | {"friday":{"openIntervals":[{"end":"22:00","start":"09:00"}]},"monday":{"openIntervals":[{"end":"22:00","start":"09:00"}]},"sunday":{"openIntervals":[{"end":"22:00","start":"09:00"}]},"tuesday":{"openIntervals":[{"end":"22:00","start":"09:00"}]},"saturday":{"openIntervals":[{"end":"22:00","start":"09:00"}]},"thursday":{"openIntervals":[{"end":"22:00","start":"09:00"}]},"wednesday":{"openIntervals":[{"end":"22:00","start":"09:00"}]}} |
isoRegionCode | 22 |
logo | {"image":{"url":"https://a.mktgcdn.com/p/6Vb7c4MHQbnxfsextDd3d9v-xHdn-Y9m3MUi6tFYupM/512x512.png","width":512,"height":512,"thumbnails":[{"url":"https://a.mktgcdn.com/p/6Vb7c4MHQbnxfsextDd3d9v-xHdn-Y9m3MUi6tFYupM/512x512.png","width":512,"height":512},{"url":"https://a.mktgcdn.com/p/6Vb7c4MHQbnxfsextDd3d9v-xHdn-Y9m3MUi6tFYupM/150x150.png","width":150,"height":150},{"url":"https://a.mktgcdn.com/p/6Vb7c4MHQbnxfsextDd3d9v-xHdn-Y9m3MUi6tFYupM/94x94.png","width":94,"height":94}],"alternateText":"杏林堂薬局"},"details":"杏林堂薬局","description":"杏林堂薬局"} |
mainPhone | +81543341211 |
meta | {"id":"2079","uid":"1018831560","labels":["add101123","開店中"],"folderId":"ドラッグストア","language":"ja","accountId":"5224829878542080524","timestamp":"2026-07-09T04:45:24","entityType":"location","countryCode":"JP","schemaTypes":["ConvenienceStore","HealthAndBeautyBusiness"],"createdTimestamp":"2023-10-11T01:54:52"} |
name | 杏林堂薬局 清水三保店 |
phoneticName | シミズミホテン |
savedFilters | 248649, 248774, 248863, 249773, 249829, 250049, 250050, 250372, 250373, 262774 |
slug | 2079 |
timeZoneUtcOffset | +09:00 |
timezone | Asia/Tokyo |
websiteUrl | {"url":"https://shop.tsuruha-g.com/2079"} |
yextDisplayCoordinate | {"latitude":34.9986429,"longitude":138.5158035} |
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/kyorindo/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 Kyorindo (杏林堂)'s 103 store data today
Annual plan: ¥515/mo (¥5/store/mo). Cancel anytime.