Hotel R9 the Yard (HOTEL R9 The Yard) store data

Name: Hotel R9 the Yard (HOTEL R9 The Yard) store data
Brand: LocationsDB
Price: 1410 JPY
Availability: InStock

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

Monthly plan

¥1,410/mo

¥10/store × 141 stores

50% OFF

Annual plan

¥705/mo

Annual total ¥8,460 (¥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 Hotel R9 the Yard (HOTEL R9 The Yard)-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

Hotel R9 the Yard (HOTEL R9 The Yard)-specific attributes

Column	Fill rate
`lat`	100%
`lng`	100%
`url`	100%
`info`	100%
`name`	100%
`news`	100%
`image`	100%
`rooms`	100%
`mapcode`	100%
`facility`	100%
`place_id`	100%
`num_rooms`	100%

Sample data (1 store)

This is an example of actually recorded data. Please verify data quality before purchase.

Field	Value
`name`	HOTEL R9 The Yard 熊本大津
`name_kana`	—
`name_en`	—
`store_type`	—
`address`	熊本県菊池郡大津町杉水3045-2
`prefecture`	熊本県
`postal_code`	869-1236
`latitude`	32.9059864
`longitude`	130.8498248
`nearest_station`	JR豊肥本線「肥後大津駅」北口よりタクシーで8分。
`access_info`	電車: JR豊肥本線「肥後大津駅」北口よりタクシーで8分。自動車: 九州自動車道「植木IC」「北熊本スマートIC」より車で25分。
`floor`	—
`building`	—
`phone`	096-283-6130
`fax`	—
`email`	—
`store_url`	https://hotel-r9.jp/hotels/kumamotoozu/
`business_hours`	—
`closed_days`	—
`last_order_time`	—
`open_24h`	—
`open_date`	2026-06-27
`parking`	true
`parking_capacity`	43
`drive_through`	—
`seat_count`	—
`private_room`	—
`dine_in`	—
`takeout`	—
`delivery`	—
`reservation`	true
`smoking_policy`	separated
`accepts_credit_card`	true
`accepts_e_money`	—
`accepts_qr_payment`	—
`barrier_free`	—
`elevator`	—
`wifi`	true
`power_outlets`	—
`pet_friendly`	false
`serves_alcohol`	—
`tax_free_shopping`	—
`atm`	—
`pharmacy`	—
`price_range`	6,200円〜
`reservation_url`	https://go-develophotels.reservation.jp/ja/hotels/r9kumamotoozu/searchInput
`photo_url`	https://hotel-r9.jp/images/img_theyard_kumamotoOzu.jpg
`services`	自動販売機, コインランドリー, 無料軽食コーナー, 無料ドリンクコーナー, スマートチェックイン
`notes`	—
`address_locality`	菊池郡大津町
`address_region`	熊本県
`car_access`	九州自動車道「植木IC」「北熊本スマートIC」より車で25分。
`checkin_time`	15:00
`checkout_time`	10:00
`description`	JR豊肥本線「肥後大津駅」より車で8分。「阿蘇くまもと空港」からは車で約15分とフライト前後のご宿泊に便利です。「菊池テクノパーク」「熊本中核工業団地」への出張などビジネス利用にも最適。「大津中央公園」「Honda KUMAMOTO WELCOME PARK」等の人気スポットへのアクセスも良好です。
`facility`	{"共有":["コインランドリー","自動販売機","無料ドリンクコーナー","無料軽食コーナー（客室の電子レンジで温めてお召し上がりいただけます。）","館内では、無料Wi-Fiをご利用いただけます。"],"客室":["ユニットバス","トイレ","テレビ","ドライヤー","冷凍冷蔵庫","電子レンジ","電気ポット","加湿空気清浄機","ハンガー","スリッパ","消臭スプレー","洋服ブラシ"],"駐車場":"普通車 / 軽自動車 43台（無料）※大型車（2トントラック以上）をご利用の際は、事前にお電話でお問い合わせください。","アメニティ":["シャンプー","コンディショナー","ボディソープ","ハンドソープ","ナイトウェア（ガウン）","ボディタオル","歯ブラシ","ヘアブラシ","T字カミソリ"]}
`facility_list`	[object Object], [object Object], [object Object], [object Object], [object Object], [object Object]
`image`	https://hotel-r9.jp/images/img_theyard_kumamotoOzu.jpg
`info`	{"住所":"〒869-1236 熊本県菊池郡大津町杉水3045-2","電話番号":"096-283-6130","ペット同伴":"不可","支払い方法（現地）":["現金","クレジットカード（VISA／JCB／Diners Club／American Express／MasterCard）"],"スマートチェックイン":"対応","チェックイン・アウト時間":"チェックイン 15時〜23時／チェックアウト 10時","支払い方法（オンライン事前決済）":["クレジットカード（VISA／JCB／Diners Club／American Express／MasterCard）"]}
`lat`	32.9059864
`lng`	130.8498248
`mapcode`	29 867 307*65
`name`	HOTEL R9 The Yard 熊本大津
`news`	[object Object], [object Object]
`num_rooms`	42
`place_id`	kumamotoozu
`postal_code`	869-1236
`reservation_url`	https://go-develophotels.reservation.jp/ja/hotels/r9kumamotoozu/searchInput
`rooms`	[object Object]
`street_address`	杉水3045-2
`telephone`	096-283-6130
`train_access`	JR豊肥本線「肥後大津駅」北口よりタクシーで8分。
`url`	https://hotel-r9.jp/hotels/kumamotoozu/

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/hotel-r9-the-yard/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.