Global Hotels (World)

Hotels and accommodations database of the world

Data Structure

chain [384]
bigint(20) unsigned
+ id (99.7%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ slug (100%)
country [226]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ slug (100%)
char(2)
+ iso_country_code_2 (100%)
char(3)
+ iso_country_code_3 (94.2%)
varchar(255)
+ calling_code (98.2%)
int(10) unsigned
+ count (99.1%)
country_sub [3,675]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ slug (100%)
varchar(255)
+ type (100%)
bigint(20) unsigned
+ country_id (100%)
int(10) unsigned
+ count (88.2%)
country_sub_sub [27,182]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
bigint(20) unsigned
+ country_sub_id (100%)
bigint(20) unsigned
+ country_id (100%)
int(10) unsigned
+ count (100%)
country_sub_sub_sub [15,288]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
bigint(20) unsigned
+ country_sub_sub_id (100%)
bigint(20) unsigned
+ country_sub_id (100%)
bigint(20) unsigned
+ country_id (100%)
int(10) unsigned
+ count (100%)
country_sub_sub_sub_to_hotel [118,452]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ hotel_id (100%)
bigint(20) unsigned
+ country_sub_sub_sub_id (100%)
country_sub_sub_to_hotel [293,949]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ hotel_id (100%)
bigint(20) unsigned
+ country_sub_sub_id (100%)
country_sub_to_hotel [576,180]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ hotel_id (100%)
bigint(20) unsigned
+ country_sub_id (100%)
country_sub_type [613]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
bigint(20) unsigned
+ country_id (100%)
hotel [337,187]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ hotel_name (100%)
varchar(255)
+ slug (100%)
bigint(20) unsigned
+ country_sub_id (100%)
varchar(255)
+ address_full (100%)
varchar(255)
+ address_short (99.2%)
varchar(255)
+ locations (100%)
varchar(255)
+ email (11.4%)
varchar(255)
+ website (36.9%)
varchar(255)
+ phone (28.2%)
varchar(255)
+ fax (11.8%)
varchar(255)
+ longitude (100%)
varchar(255)
+ latitude (100%)
varchar(255)
+ star_rating (90.4%)
varchar(255)
+ star_self_rated (1.9%)
varchar(255)
+ rooms (2.2%)
varchar(255)
+ local_currency_code (19.8%)
varchar(255)
+ price_usd (63.6%)
varchar(255)
+ price_from (63.6%)
varchar(255)
+ check_in (92%)
varchar(255)
+ check_out (91.4%)
bigint(20) unsigned
+ property_type_id (23.2%)
bigint(20) unsigned
+ chain_id (16.6%)
varchar(255)
+ rating_overall (45.7%)
varchar(255)
+ rating_overall_text (36.9%)
varchar(255)
+ rating_cleanliness (45.7%)
varchar(255)
+ rating_dining (45.7%)
varchar(255)
+ rating_facilities (45.7%)
varchar(255)
+ rating_location (45.7%)
varchar(255)
+ rating_rooms (45.7%)
varchar(255)
+ rating_service (45.7%)
varchar(255)
+ rating_points (38%)
varchar(255)
+ reviews_count (45.7%)
text
+ reviews_summary_positive (38%)
text
+ reviews_summary_negative (9.2%)
mediumtext
+ description (100%)
mediumtext
+ FAQ (10.4%)
int(10) unsigned
+ images_count (85%)
hotel_feature [177]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(127)
+ title (100%)
varchar(63)
+ type (100%)
hotel_feature_to_hotel [6,074,492]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ hotel_id (100%)
bigint(20) unsigned
+ hotel_feature_id (100%)
hotel_feature_type [5]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(63)
+ title (100%)
hotel_image [3,723,510]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ dir (100%)
varchar(255)
+ path (100%)
int(10) unsigned
+ file_size_bytes (100%)
int(10) unsigned
+ width_px (100%)
int(10) unsigned
+ height_px (100%)
bigint(20) unsigned
+ hotel_id (100%)
location [21,359]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ slug (100%)
bigint(20) unsigned
+ location_type_id (100%)
varchar(255)
+ latitude (100%)
varchar(255)
+ longitude (100%)
location_type [16]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ slug (100%)
place_of_interest [3,319,923]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ longitude (100%)
varchar(255)
+ latitude (100%)
varchar(255)
+ name (100%)
bigint(20) unsigned
+ hotel_id (100%)
place_of_interest_name [18,560]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
property_type [10]
bigint(20) unsigned
+ id (90%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ slug (100%)

Description

This is a worldwide hotels database across 226 countries and regions. Other than rich hotel fields and features, this also makes it easy to search for important locations and places of interest near the hotel since everything is marked with longitude and latitude.

Data Profile

Size 2.83G
Tables 19
Last Commit 2017-04-11 01:42:45

Updates / Commits

Time Size Tables Columns Rows
2017-04-11 01:42:45 2.83G 19 132 14531188
2016-08-11 22:05:41 2.83G 19 132 14531188
2016-08-11 20:16:37 2.82G 19 132 14531188

Pricing

All prices are in Datactory Credits.

TableRowsPrice per Row (Credits)Subtotal (Credits)
chain 384 .001 0.384
country 226 .001 0.226
country_sub 3,675 .001 3.675
country_sub_sub 27,182 .001 27.182
country_sub_sub_sub 15,288 .001 15.288
country_sub_sub_sub_to_hotel 118,452 .001 118.452
country_sub_sub_to_hotel 293,949 .001 293.949
country_sub_to_hotel 576,180 .001 576.18
country_sub_type 613 .001 0.613
hotel 337,187 .001 337.187
hotel_feature 177 .001 0.177
hotel_feature_to_hotel 6,074,492 .001 6074.492
hotel_feature_type 5 .001 0.005
hotel_image 3,723,510 .001 3723.51
location 21,359 .001 21.359
location_type 16 .001 0.016
place_of_interest 3,319,923 .001 3319.923
place_of_interest_name 18,560 .001 18.56
property_type 10 .001 0.01
Total Credits 14531.188 Credits (1) (2)
(1). Plus cost by query time at 0.1 credits per second. A typical query takes about 0.001 seconds which would then charge you 0.0001 credits.
(2). This is the total amount of credits required for ALL rows in these tables. You are free to query for only a selected part of them, even a single row, and pay only for that.

How to Access

Click to see how to access this dataset.