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.
| Table | Rows | Price 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.