Home Data Travel & Tourism Accommodations Hotels

250,286 World Hotels API: Address, Phone, Total Room & Amenity, Image

Name	n3_chennan_hotel_cleartrip_ae
Data	1.91G (+ 0B)
Tables	14 (+ 0)
Columns	62 (+ 0)
Table Rows	12,644,831 (+ 0)
Media	147.33M (+ 0B)
Files	6,965 (+ 0)
Last Commit	2023-06-19 18:36:38 (+ 169 d)

This is a fields-rich hotels database with 250,286 records from 26,927 cities of 194 countries around the world. Each hotel is comprised of title, rating, description, street address, address region, address country, check in, check out and etc. There are 4 tables closely related with these hotels, they are table amenity with 9 records, 324 detail, room with 168,891 records and 199 room amenity records. It also comes with 4,725,373 images in the 147.33M media set of this data. The whole world hotels data set has 14 tables.

Data Samples

Main List (for Desktop / for Mobile) / JSON / XML / Excel / CSV (Download CSV) / View by Table

Data APIs

http://n3.datasn.io/data/api/v1/n3_chennan/country_hotel/ (By Table)

Media Files

hotel_image ^{Bytes: 147.33M / Files: 6,965}

Tables + Columns
Media Files
Updates
Download

Tables & Columns

Tables	Rows	Columns	Non-empty
amenity	9	value	100%
city	26,927	title	100%
		country	100%
		country_id	100%
city_x_hotel	250,286	city_id	100%
city_x_hotel	250,286	hotel_id	100%
country	194	title	100%
detail	324	value	100%
hotel	250,286	title	100%
		rating	100%
		description	98.68%
		street_address	98.73%
		address_locality	25.5%
		address_region	99.43%
		address_country	99.43%
		phone	86.21%
		check_in	99.65%
		check_out	99.65%
		total_room	76.21%
hotel_x_amenity	1,001,117	hotel_id	100%
hotel_x_amenity	1,001,117	amenity_id	100%
hotel_x_detail	3,442,226	hotel_id	100%
hotel_x_detail	3,442,226	detail_id	100%
hotel_x_room	1,077,737	hotel_id	100%
hotel_x_room	1,077,737	room_id	100%
image	4,725,373	image_url	100%
image	4,725,373	hotel_id	100%
room	168,891	title	100%
room_amenity	199	value	100%
room_x_room_amenity	1,701,262	room_id	100%
room_x_room_amenity	1,701,262	room_amenity_id	100%

Notes:

Meta columns id and ts are not shown here, but included in columns total.
Some statistical or memo columns are not shown here, but included in columns total.
Non-empty percentage indicates the percent of values that are non-empty for that particular column.

Media Sets

hotel_image

Size (Bytes)	Files
147.33M	6,965

Commits / Updates

Time	Data	Tables	Columns	Rows	Media	Files
2023-06-19 (+ 169 d)	1.91G (+ 0B)	14 (+ 0)	62 (+ 0)	12,644,831 (+ 0)	147.33M (+ 0B)	6,965 (+ 0)
2023-01-01 (+ 95 d)	1.91G (+ 0B)	14 (+ 0)	62 (+ 0)	12,644,831 (+ 0)	147.33M (+ 0B)	6,965 (+ 0)
2022-09-27 (+ 271 d)	1.91G (+ 0B)	14 (+ 0)	62 (+ 0)	12,644,831 (+ 0)	147.33M (+ 0B)	6,965 (+ 0)
2021-12-30 (+ 115 d)	1.91G (+ 0B)	14 (+ 0)	62 (+ 0)	12,644,831 (+ 0)	147.33M (+ 0B)	6,965 (+ 0)
2021-09-05 (+ 150 d)	1.91G (+ 0B)	14 (+ 0)	62 (+ 0)	12,644,831 (+ 0)	147.33M (+ 0B)	6,965 (+ 0)
2021-04-08 (+ 68 d)	1.91G (+ 0B)	14 (+ 0)	62 (+ 0)	12,644,831 (+ 0)	147.33M (+ 0B)	6,965 (+ 0)
2021-01-29 (+ 120 d)	1.91G (+ 0B)	14 (+ 0)	62 (+ 0)	12,644,831 (+ 0)	147.33M (+ 0B)	6,965 (+ 0)
2020-10-01 (+ 38 d)	1.91G (+ 0B)	14 (+ 0)	62 (+ 0)	12,644,831 (+ 0)	147.33M (+ 0B)	6,965 (+ 0)
2020-08-23 (+ 141 d)	1.91G (+ 0B)	14 (+ 0)	62 (+ 0)	12,644,831 (+ 0)	147.33M (+ 0B)	6,965 (+ 0)
2020-04-04 (+ 196 d)	1.91G (+ 0B)	14 (+ 0)	62 (+ 0)	12,644,831 (+ 0)	147.33M (+ 0B)	6,965 (+ 0)
2019-09-21 (+ 197 d)	1.91G (+ 0B)	14 (+ 0)	62 (+ 0)	12,644,831 (+ 0)	147.33M (+ 0B)	6,965 (+ 0)
2019-03-07 (+ 43 d)	1.91G (+ 0B)	14 (+ 0)	62 (+ 0)	12,644,831 (+ 0)	147.33M (+ 0B)	6,965 (+ 0)
2019-01-23 (+ 44 d)	1.91G (+ 0B)	14 (+ 0)	62 (+ 0)	12,644,831 (+ 0)	147.33M (+ 0B)	6,965 (+ 0)
2018-12-09 (+ 29 d)	1.91G (+ 0B)	14 (+ 0)	62 (+ 0)	12,644,831 (+ 0)	147.33M (+ 0B)	6,965 (+ 0)
2018-11-09 (+ 27 d)	1.91G (+ 1.45G)	14 (+ 0)	62 (+ 0)	12,644,831 (+ 0)	147.33M (+ 0B)	6,965 (+ 0)
2018-10-13 (+ 29 d)	472.20M (+ 0B)	14 (+ 0)	62 (+ 0)	12,644,831 (+ 0)	147.33M (+ 0B)	6,965 (+ 0)
2018-09-13 (+ 34 d)	472.20M (+ 0B)	14 (+ 0)	62 (+ 0)	12,644,831 (+ 0)	147.33M (+ 0B)	6,965 (+ 0)
2018-08-09 (+ 27 d)	472.20M (+ 0B)	14 (+ 0)	62 (+ 0)	12,644,831 (+ 0)	147.33M (+ 0B)	6,965 (+ 0)
2018-07-12 (+ 31 d)	472.20M (+ 0B)	14 (+ 0)	62 (+ 0)	12,644,831 (+ 0)	147.33M (+ 0B)	6,965 (+ 0)
2018-06-10 (+ 31 d)	472.20M (+ 0B)	14 (+ 0)	62 (+ 0)	12,644,831 (+ 0)	147.33M (+ 0B)	6,965 (+ 0)
2018-05-10 (+ 28 d)	472.20M (+ 0B)	14 (+ 0)	62 (+ 0)	12,644,831 (+ 0)	147.33M (+ 0B)	6,965 (+ 0)
2018-04-11 (+ 38 d)	472.20M (+ 0B)	14 (+ 0)	62 (+ 0)	12,644,831 (+ 0)	147.33M (+ 0B)	6,965 (+ 0)
2018-03-03 (+ 35 d)	472.20M (+ 0B)	14 (+ 0)	62 (+ 0)	12,644,831 (+ 0)	147.33M (+ 0B)	6,965 (+ 0)
2018-01-27 (+ 29 d)	472.20M (+ 5.66M)	14 (+ 0)	62 (+ 0)	12,644,831 (+ 0)	147.33M (+ 147.13M)	6,965 (+ 6,955)
2017-12-29	466.55M	14	62	12,644,831	199.93K	10

Download Latest Commit

In the same time, you can also access this data set via API.

Access Now!

How to use

View the page for data details.
Sign up for an account and log in.
Open Online Query to build API addresses / calls.
Open the API address / call to access the data.

FAQ

How to access the data?

Select a membership plan and sign up. Return to this page, click Online Query to access the API query maker. Create and open an API call to acquire the data.
Why are data size increments not in line with those of number of rows?

The scanning and profiling of data size increments are done separately from those of the number of rows.