Yuzuan (ゆず庵) store data

Name: Yuzuan (ゆず庵) store data
Brand: LocationsDB
Price: 1160 JPY
Availability: InStock

116 stores · 55 fields · As of 2026-07-16 · Updated daily

Monthly plan

¥1,160/mo

¥10/store × 116 stores

50% OFF

Annual plan

¥580/mo

Annual total ¥6,960 (¥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 Yuzuan (ゆず庵)-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

Yuzuan (ゆず庵)-specific attributes

Column	Fill rate
`id`	100%
`name`	100%
`note`	100%
`seat`	100%
`access`	100%
`address`	100%
`city_id`	100%
`parking`	100%
`payment`	100%
`brand_id`	100%
`faspa_id`	100%
`latitude`	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`	宮城県石巻市大街道西3-83-17
`prefecture`	宮城県
`postal_code`	986-0859
`latitude`	38.43053856
`longitude`	141.2689573
`nearest_station`	—
`access_info`	—
`floor`	—
`building`	—
`phone`	050-1792-7321
`fax`	—
`email`	—
`store_url`	https://www.shabu-yuzuan.jp/shop/4217/
`business_hours`	営業時間：11:00 - 24:00 最終入店時間：22:00
`closed_days`	—
`last_order_time`	22:00
`open_24h`	—
`open_date`	—
`parking`	true
`parking_capacity`	—
`drive_through`	false
`seat_count`	150
`private_room`	—
`dine_in`	—
`takeout`	false
`delivery`	—
`reservation`	true
`smoking_policy`	no_smoking
`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`	—
`price_range`	—
`reservation_url`	https://justpass.epark.jp/reserve/booking/6455
`photo_url`	—
`services`	おむつ替え台
`notes`	—
`access`	—
`address`	宮城県石巻市大街道西3-83-17
`administrative_area`	宮城県
`app_reservation_flag`	1
`app_reservation_url`	https://dl.shabu-yuzuan.jp/shop_detail?id=4217
`brand_id`	4
`business_hour`	営業時間：11:00 - 24:00 最終入店時間：22:00
`city_id`	259
`equipment_note`	—
`faspa_id`	—
`google_map_link`	https://maps.google.com/maps?ll=141.268957,38.430539&z=17&q=%E3%82%86%E3%81%9A%E5%BA%B5+%E7%9F%B3%E5%B7%BB%E5%BA%97
`google_review_url`	—
`has_drive_thru`	0
`has_takeout`	0
`id`	2601
`justpass_id`	—
`latitude`	38.43053856
`longitude`	141.2689573
`maintenance_message`	8月8日(土)～8月16日(日) 「平日限定ランチ御膳各種」「ランチメニュー各種」の取り扱いはございません。
`mobile_order_url`	—
`name`	ゆず庵石巻店
`news_visible`	1
`not_public_flag`	0
`note`	—
`opening_times`	営業時間：11:00 - 24:00 最終入店時間：22:00
`opening_times_extra`	—
`opening_times_note`	—
`parking`	有
`payment`	クレジットカード： VISA、Mastercard、JCB、American Express、Diners Club、DISCOVER、中国銀聯バーコード決済： PayPay、d払い、au PAY、WeChat Pay、J-Coin Pay、Alipay、楽天ペイ、メルペイ、銀行Pay 電子マネー： iD・QUICPay、交通系 IC カード
`phone_reservation_telephone_number`	050-1792-7321
`postal_code`	986-0859
`prefecture_id`	4
`reservation_note`	8月8日(土)～8月16日(日) 「平日限定ランチ御膳各種」「ランチメニュー各種」の取り扱いはございません。
`reservation_url`	https://justpass.epark.jp/reserve/booking/6455
`seat`	150
`shop_code`	4217
`shop_deliveries`	—
`shop_equipments`	[object Object], [object Object], [object Object], [object Object]
`shop_images`	—
`shop_info_visible`	1
`shop_menu`	8月8日(土)～8月16日(日) 「平日限定ランチ御膳各種」「ランチメニュー各種」の取り扱いはございません。
`shop_payment_methods`	[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], [object Object], [object Object], [object Object]
`shop_services`	—
`specific_datetime_reservation_url`	—
`telephone_number`	050-1792-7321
`waiting_reservation_url`	—

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