Tsuruha Drug (ツルハドラッグ) store data

Name: Tsuruha Drug (ツルハドラッグ) store data
Brand: LocationsDB
Price: 19940 JPY
Availability: InStock

1,994 stores · 55 fields · As of 2026-07-16 · Updated daily

Monthly plan

¥19,940/mo

¥10/store × 1,994 stores

50% OFF

Annual plan

¥9,970/mo

Annual total ¥119,640 (¥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 Tsuruha Drug (ツルハドラッグ)-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

Tsuruha Drug (ツルハドラッグ)-specific attributes

Column	Fill rate
`meta`	100%
`name`	100%
`slug`	100%
`hours`	100%
`address`	100%
`timezone`	100%
`mainPhone`	100%
`c_nameKana`	100%
`c_pagesURL`	100%
`websiteUrl`	100%
`c_localized`	100%
`categoryIds`	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`	DISPENSING_PHARMACY
`address`	宮城県仙台市中山7丁目2-30号
`prefecture`	宮城県
`postal_code`	981-0952
`latitude`	38.2956373539224
`longitude`	140.836112491882
`nearest_station`	—
`access_info`	—
`floor`	—
`building`	—
`phone`	0223468778
`fax`	022-346-8778
`email`	—
`store_url`	https://shop.tsuruha-g.com/1187c
`business_hours`	月:09:30〜13:30,14:30〜18:30 火:09:30〜13:30,14:30〜18:30 水:09:30〜13:30,14:30〜18:30 木:09:30〜13:30,14:30〜18:30 金:09:30〜13:30,14:30〜18:30 土:09:30〜13:30 日:定休
`closed_days`	日曜 / 祝日
`last_order_time`	—
`open_24h`	false
`open_date`	2024-03-01
`parking`	true
`parking_capacity`	—
`drive_through`	true
`seat_count`	—
`private_room`	—
`dine_in`	—
`takeout`	—
`delivery`	true
`reservation`	true
`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`	—
`atm`	—
`pharmacy`	true
`price_range`	—
`reservation_url`	https://www.kusurinomadoguchi.com/miyagi/s1000126412?k_ref=064&utm_source=www.tsuruha.co.jp&utm_medium=referral&utm_content=pharmacy_HP_shop&utm_campaign=pharmacy_HP
`photo_url`	—
`services`	AED, 在宅介護支援センター, 第一類医薬品, セルフ採血, オンライン服薬指導, マイナ受付, お薬受取りロッカー, 電子処方箋, 災害対応薬局, 在宅医療対応
`notes`	—
`address`	{"city":"仙台市","line1":"中山7丁目2-30号","region":"宮城県","postalCode":"981-0952","countryCode":"JP","sublocality":"青葉区"}
`appleBusinessDescription`	「全国の処方せんを受付いたします」ツルハ（tsuruha）グループは、より近くのドラッグストア（drugstore・藥妝店・드럭스토어）・より近くの調剤薬局として信頼され魅力ある店づくり・薬局（pharmacy・藥店・약국）作りに努めています。より身近な「地域の薬局」として、お気軽にご利用ください。
`appleBusinessId`	1545496721332600832
`appleCompanyId`	1456145545620286464
`appleDisplayName`	調剤薬局ツルハドラッグ仙台中山店
`brandReference`	tsuruhaBrand
`c_appIntegrationBrand`	TSURUHA_DRUG
`c_brandFilter`	TSURUHA_DRUG
`c_dispensingForm`	WITH_DISPENSING_PHARMACY
`c_endDateForNewShopIconDisplay`	2024-04-01
`c_faxWeb`	[object Object]
`c_guidanceRequiredAndCategory1OTCSalesHours`	{"friday":{"openIntervals":[{"end":"13:30","start":"09:30"},{"end":"18:30","start":"14:30"}]},"monday":{"openIntervals":[{"end":"13:30","start":"09:30"},{"end":"18:30","start":"14:30"}]},"sunday":{"isClosed":true},"tuesday":{"openIntervals":[{"end":"13:30","start":"09:30"},{"end":"18:30","start":"14:30"}]},"saturday":{"openIntervals":[{"end":"13:30","start":"09:30"}]},"thursday":{"openIntervals":[{"end":"13:30","start":"09:30"},{"end":"18:30","start":"14:30"}]},"wednesday":{"openIntervals":[{"end":"13:30","start":"09:30"},{"end":"18:30","start":"14:30"}]}}
`c_instorePharmacy`	true
`c_internalStoreCode`	6031
`c_linkPharmacy`	1187
`c_localized`	true
`c_nameKana`	センダイナカヤマテン
`c_notes`	[閉局時間]13:30～14:30 [自己採血受付] 調剤営業時間内・調剤コーナーにて！
`c_openDate`	2024-03-01
`c_operatingType`	DIRECTLY_OPERATED
`c_pagesURL`	https://shop.tsuruha-g.com/1187c
`c_pharmacyAvailableAfter17`	true
`c_pharmacyAvailableBefore10`	true
`c_prescriptionNetReservationURL`	https://www.kusurinomadoguchi.com/miyagi/s1000126412?k_ref=064&utm_source=www.tsuruha.co.jp&utm_medium=referral&utm_content=pharmacy_HP_shop&utm_campaign=pharmacy_HP
`c_regularClosingDay`	日曜 / 祝日
`c_sa_dp_dAAInfectiousDiseasePreparedness`	true
`c_sa_dp_dispensingPharmacy`	true
`c_sa_dp_driveThruPharmacyService`	true
`c_sa_dp_electronicPrescription`	true
`c_sa_dp_emergencyContraceptivesViaOMC`	true
`c_sa_dp_homeMedicalCare`	true
`c_sa_dp_onlineMedicationGuidance`	true
`c_sa_dp_onlineQualificationVerification`	true
`c_sa_dp_pharmacyPickUpLocker`	true
`c_sa_dp_providingAfterhours`	false
`c_sa_dp_usingTheIndividualNumberCard`	true
`c_sa_fd_basicDispensingFee3C`	true
`c_sa_fd_biosimilarDispensingSystemPremium`	true
`c_sa_fd_collaborationReinforcementAddition`	true
`c_sa_fd_medicalDXPromotionSystemDevelopment`	true
`c_sa_fd_regionalSupportSystemPremium1`	true
`c_sa_fs_facilities_paidParkingLot`	true
`c_sa_fs_facilities_parkingLot`	true
`c_sa_fs_others_aED`	true
`c_sa_fs_others_inHomeCareSupportCenter`	true
`c_sa_fs_service_AtHomeLongTermCareSupport`	true
`c_sa_fs_service_DeliveryService`	true
`c_sa_fs_service_serviceRegisteredDietitianConsul`	false
`c_sa_pl_cadn_babyProducts`	true
`c_sa_pl_cadn_cosmetics`	true
`c_sa_pl_cadn_dailyNecessities`	true
`c_sa_pl_cadn_petProducts`	true
`c_sa_pl_food_healthFoods`	true
`c_sa_pl_meds_bloodGlucoseLevelMonitoringDevices`	true
`c_sa_pl_meds_coloredContactLenses`	true
`c_sa_pl_meds_emergencyContraceptives2`	true
`c_sa_pl_meds_guidancerequiredAndCategory1OTCDrugs`	true
`c_sa_pl_meds_medicalAntigenTestKit`	true
`c_sa_pl_meds_medicines`	true
`c_sa_pl_meds_prescriptionContactLenses`	true
`c_sa_pl_meds_selfcollectionOfBlood`	true
`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`	false
`c_sa_pm_payPay`	true
`c_sa_pm_qUICPay`	true
`c_sa_pm_rabbitCard`	false
`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`	true
`c_sf_businessHoursDispensingPharmacy`	ACCEPTS_CUSTOMERS_FROM_BEFORE_10:00, ACCEPTS_CUSTOMERS_EVEN_AFTER_17:00
`c_sf_dispensingPharmacyRelated`	DISPENSING_PHARMACY, ONLINE_MEDICATION_GUIDANCE, ONLINE_QUALIFICATION_VERIFICATION, HOME_MEDICAL_CARE, PHARMACY_PICK_UP_LOCKER, ELECTRONIC_PRESCRIPTION, DRIVE-THRU_PHARMACY_SERVICE, DISPENSING_EMERGENCY_CONTRACEPTIVES_VIA_ONLINE_MEDICAL_CONSULTATIONS, DISASTER_AND_EMERGING_INFECTIOUS_DISEASE_PREPAREDNESS, ACCESS_TO_MEDICAL_INFORMATION_USING_THE_INDIVIDUAL_NUMBER_CARD
`c_sf_dispensingPharmacyRelatedFSWADN`	BASIC_DISPENSING_FEE_3C, REGIONAL_SUPPORT_SYSTEM_PREMIUM_1, MEDICAL_DX_PROMOTION_SYSTEM_DEVELOPMENT_PREMIUM, COLLABORATION_REINFORCEMENT_ADDITION, BIO-SIMILAR_DISPENSING_SYSTEM_PREMIUM
`c_sf_facilitiesAndServicesFacilities`	PARKING_LOT, PAID_PARKING_LOT
`c_sf_facilitiesAndServicesOthers`	IN-HOME_CARE_SUPPORT_CENTER, AED
`c_sf_facilitiesAndServicesServices`	DELIVERY_SERVICE, AT-HOME_LONG-TERM_CARE_SUPPORT
`c_sf_paymentMethod`	HAPPAY, CREDIT_CARD, RAKUTEN_EDY, ID, GINREN_CARD, IC_CARDS_FOR_TRANSPORTATION, QUICPAY, WAON_CARD, RAKUTEN_POINT_CARD, NANACO, D_BARAI, WECHAT_PAY, ALIPAY+, PAYPAY, AU_PAY, MERPAY, RAKUTEN_PAY, FAMIPAY
`c_sf_productLineCADN`	COSMETICS, DAILY_NECESSITIES, BABY_PRODUCTS, PET_PRODUCTS
`c_sf_productLineFood`	HEALTH_FOODS
`c_sf_productLineMedicines`	GUIDANCE-REQUIRED_AND_CATEGORY-1_OTC_DRUGS, MEDICINES, EMERGENCY_CONTRACEPTIVES, SELF-COLLECTION_OF_BLOOD, BLOOD_GLUCOSE_LEVEL_MONITORING_DEVICES, MEDICAL_ANTIGEN_TEST_KIT, PRESCRIPTION_CONTACT_LENSES, COLORED_CONTACT_LENSES
`c_sf_storeType`	DISPENSING_PHARMACY
`c_shopStatus`	NEW_STORE
`c_yahooAuthEntityId`	oauth-settings-yahoo
`c_yahooPlaceSeq`	625912
`categoryIds`	1551116, 178, 1379996
`cityCoordinate`	{"latitude":38.267982482910156,"longitude":140.86953735351562}
`description`	「全国の処方せんを受付いたします」ツルハ（tsuruha）グループは、より近くのドラッグストア（drugstore・藥妝店・드럭스토어）・より近くの調剤薬局として信頼され魅力ある店づくり・薬局（pharmacy・藥店・약국）作りに努めています。より身近な「地域の薬局」として、お気軽にご利用ください。
`displayCoordinate`	{"latitude":38.29589079,"longitude":140.8361369}
`dm_directoryParents`	defaultDirectory, defaultDirectory_gong_cheng_xian, defaultDirectory_gong_cheng_xian_xian_tai_shi
`facebookCoverPhoto`	{"url":"https://a.mktgcdn.com/p/obIM_plalToPQWOfCQdsO7Zh_jFSUf6wgrhBxfcnL-w/2048x1456.jpg","width":2048,"height":1456,"sourceUrl":"https://a.mktgcdn.com/p/obIM_plalToPQWOfCQdsO7Zh_jFSUf6wgrhBxfcnL-w/2048x1456.jpg","thumbnails":[{"url":"https://a.mktgcdn.com/p/obIM_plalToPQWOfCQdsO7Zh_jFSUf6wgrhBxfcnL-w/2048x1456.jpg","width":2048,"height":1456}]}
`facebookPageUrl`	https://www.facebook.com/237526932782605
`facebookParentPageId`	802536333091572
`facebookProfilePhoto`	{"url":"http://a.mktgcdn.com/p/v1FIump4wjKKp8OYwwtuaAdOJaM4lzqAeVkL6DIp7RM/200x200.jpg","width":200,"height":200}
`generatedFaq`	[object Object], [object Object], [object Object], [object Object], [object Object], [object Object], [object Object], [object Object], [object Object], [object Object]
`geocodedCoordinate`	{"latitude":38.2956761,"longitude":140.8361369}
`googleAccountId`	107720380151468963557
`googleCid`	5108953865280133949
`googlePlaceId`	ChIJdcwYNb2HiV8RPZvh2Xim5kY
`googleProfilePhoto`	{"url":"https://a.mktgcdn.com/p/iQ9lkwUFScBbo0yp8zgQ16hRWlCyTHOqQh6KMkU_p1s/512x512.png","width":512,"height":512,"thumbnails":[{"url":"https://a.mktgcdn.com/p/iQ9lkwUFScBbo0yp8zgQ16hRWlCyTHOqQh6KMkU_p1s/512x512.png","width":512,"height":512}],"alternateText":"ツルハドラッグ"}
`hours`	{"friday":{"openIntervals":[{"end":"13:30","start":"09:30"},{"end":"18:30","start":"14:30"}]},"monday":{"openIntervals":[{"end":"13:30","start":"09:30"},{"end":"18:30","start":"14:30"}]},"sunday":{"isClosed":true},"tuesday":{"openIntervals":[{"end":"13:30","start":"09:30"},{"end":"18:30","start":"14:30"}]},"saturday":{"openIntervals":[{"end":"13:30","start":"09:30"}]},"thursday":{"openIntervals":[{"end":"13:30","start":"09:30"},{"end":"18:30","start":"14:30"}]},"wednesday":{"openIntervals":[{"end":"13:30","start":"09:30"},{"end":"18:30","start":"14:30"}]},"holidayHours":[{"date":"2026-07-20","isClosed":true},{"date":"2026-08-11","isClosed":true},{"date":"2026-09-21","isClosed":true},{"date":"2026-09-22","isClosed":true},{"date":"2026-09-23","isClosed":true},{"date":"2026-10-12","isClosed":true},{"date":"2026-11-03","isClosed":true},{"date":"2026-11-23","isClosed":true}]}
`isoRegionCode`	04
`logo`	{"image":{"url":"https://a.mktgcdn.com/p/iQ9lkwUFScBbo0yp8zgQ16hRWlCyTHOqQh6KMkU_p1s/512x512.png","width":512,"height":512,"thumbnails":[{"url":"https://a.mktgcdn.com/p/iQ9lkwUFScBbo0yp8zgQ16hRWlCyTHOqQh6KMkU_p1s/512x512.png","width":512,"height":512},{"url":"https://a.mktgcdn.com/p/iQ9lkwUFScBbo0yp8zgQ16hRWlCyTHOqQh6KMkU_p1s/150x150.png","width":150,"height":150},{"url":"https://a.mktgcdn.com/p/iQ9lkwUFScBbo0yp8zgQ16hRWlCyTHOqQh6KMkU_p1s/94x94.png","width":94,"height":94}],"alternateText":"ツルハドラッグ"},"details":"ツルハドラッグ","description":"ツルハドラッグ"}
`mainPhone`	+81223468778
`meta`	{"id":"1187c","uid":"1035263277","labels":["add030124","備考5_102824","備考用_122624","備考_多言語","開店中"],"folderId":"32仙台2地区","language":"ja","accountId":"5224829878542080524","timestamp":"2026-07-09T04:26:00","entityType":"location","countryCode":"JP","schemaTypes":["Pharmacy","ConvenienceStore"],"createdTimestamp":"2024-03-01T00:46:48"}
`name`	調剤薬局ツルハドラッグ仙台中山店
`phoneticName`	センダイナカヤマテン
`savedFilters`	231467, 232277, 248649, 248774, 248863, 248874, 249773, 249829, 250049, 250050, 250372, 250373, 262774
`slug`	1187c
`timeZoneUtcOffset`	+09:00
`timezone`	Asia/Tokyo
`websiteUrl`	{"url":"https://shop.tsuruha-g.com/1187c"}
`yextDisplayCoordinate`	{"latitude":38.29563735392244,"longitude":140.83611249188158}
`yextRoutableCoordinate`	{"latitude":38.29561,"longitude":140.83602108}

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/tsuruha-drug/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.