Home Data Travel & Tourism Accommodations Hotels

32,516 US Hotels Data: Address, Price, Check in / out Overview, Image

Name	n3_chennan_hotel_hotelguides_com_us
Data	77.08M (+ 0B)
Tables	6 (+ 0)
Columns	29 (+ 0)
Table Rows	273,637 (+ 0)
Media	10.54M (+ 0B)
Files	300 (+ 0)
Last Commit	2023-06-19 18:36:38 (+ 169 d)

In the hotels database, there are 32,516 records from 2,826 cities of 54 states in America. Each record has title, address, overview note, price, check in and check outc. It also contains 195,499 hotels images with URL in the 2.87G media set of this data.

The whole America hotels data set has 6 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/us_hotel/ (By Table)

Media Files

hotel_image ^{Bytes: 10.54M / Files: 300}

Tables + Columns
Media Files
Updates
Download

Tables & Columns

Tables	Rows	Columns	Non-empty
city	2,826	title	100%
		state	100%
		state_id	100%
city_x_hotel	42,742	city_id	100%
city_x_hotel	42,742	hotel_id	100%
hotel	32,516	address	100%
		title	100%
		check_in	42.57%
		check_out	42.57%
		overview_note	99.96%
		price	99.98%
image	195,499	image_url	100%
image	195,499	hotel_id	100%
state	54	title	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
10.54M	300

Commits / Updates

Time	Data	Tables	Columns	Rows	Media	Files
2023-06-19 (+ 169 d)	77.08M (+ 0B)	6 (+ 0)	29 (+ 0)	273,637 (+ 0)	10.54M (+ 0B)	300 (+ 0)
2023-01-01 (+ 95 d)	77.08M (+ 0B)	6 (+ 0)	29 (+ 0)	273,637 (+ 0)	10.54M (+ 0B)	300 (+ 0)
2022-09-27 (+ 271 d)	77.08M (+ 0B)	6 (+ 0)	29 (+ 0)	273,637 (+ 0)	10.54M (+ 0B)	300 (+ 0)
2021-12-30 (+ 115 d)	77.08M (+ 0B)	6 (+ 0)	29 (+ 0)	273,637 (+ 0)	10.54M (+ 0B)	300 (+ 0)
2021-09-05 (+ 150 d)	77.08M (+ 0B)	6 (+ 0)	29 (+ 0)	273,637 (+ 0)	10.54M (+ 0B)	300 (+ 0)
2021-04-08 (+ 68 d)	77.08M (+ 0B)	6 (+ 0)	29 (+ 0)	273,637 (+ 0)	10.54M (+ 0B)	300 (+ 0)
2021-01-29 (+ 120 d)	77.08M (- 30.95M)	6 (+ 0)	29 (+ 0)	273,637 (+ 0)	10.54M (+ 0B)	300 (+ 0)
2020-10-01 (+ 38 d)	108.03M (+ 0B)	6 (+ 0)	29 (+ 0)	273,637 (+ 0)	10.54M (+ 0B)	300 (+ 0)
2020-08-23 (+ 141 d)	108.03M (+ 0B)	6 (+ 0)	29 (+ 0)	273,637 (+ 0)	10.54M (+ 0B)	300 (+ 0)
2020-04-04 (+ 196 d)	108.03M (+ 0B)	6 (+ 0)	29 (+ 0)	273,637 (+ 0)	10.54M (+ 0B)	300 (+ 0)
2019-09-21 (+ 197 d)	108.03M (- 5.14M)	6 (+ 0)	29 (+ 0)	273,637 (+ 0)	10.54M (- 2.86G)	300 (- 78,621)
2019-03-07 (+ 43 d)	113.17M (+ 0B)	6 (+ 0)	29 (+ 0)	273,637 (+ 0)	2.87G (+ 0B)	78,921 (+ 0)
2019-01-23 (+ 44 d)	113.17M (+ 0B)	6 (+ 0)	29 (+ 0)	273,637 (+ 0)	2.87G (+ 0B)	78,921 (+ 0)
2018-12-09 (+ 29 d)	113.17M (+ 0B)	6 (+ 0)	29 (+ 0)	273,637 (+ 0)	2.87G (+ 0B)	78,921 (+ 0)
2018-11-09 (+ 27 d)	113.17M (+ 71.22M)	6 (+ 0)	29 (+ 0)	273,637 (+ 0)	2.87G (+ 0B)	78,921 (+ 0)
2018-10-13 (+ 29 d)	41.95M (+ 0B)	6 (+ 0)	29 (+ 0)	273,637 (+ 0)	2.87G (+ 0B)	78,921 (+ 0)
2018-09-13 (+ 34 d)	41.95M (+ 0B)	6 (+ 0)	29 (+ 0)	273,637 (+ 0)	2.87G (+ 0B)	78,921 (+ 0)
2018-08-09 (+ 27 d)	41.95M (+ 0B)	6 (+ 0)	29 (+ 0)	273,637 (+ 0)	2.87G (+ 0B)	78,921 (+ 0)
2018-07-12 (+ 31 d)	41.95M (+ 0B)	6 (+ 0)	29 (+ 0)	273,637 (+ 0)	2.87G (+ 0B)	78,921 (+ 0)
2018-06-10 (+ 31 d)	41.95M (+ 0B)	6 (+ 0)	29 (+ 0)	273,637 (+ 0)	2.87G (+ 0B)	78,921 (+ 0)
2018-05-10 (+ 28 d)	41.95M (+ 0B)	6 (+ 0)	29 (+ 0)	273,637 (+ 0)	2.87G (+ 0B)	78,921 (+ 0)
2018-04-11 (+ 38 d)	41.95M (+ 0B)	6 (+ 0)	29 (+ 0)	273,637 (+ 0)	2.87G (+ 0B)	78,921 (+ 0)
2018-03-03 (+ 35 d)	41.95M (+ 0B)	6 (+ 0)	29 (+ 0)	273,637 (+ 0)	2.87G (+ 0B)	78,921 (+ 0)
2018-01-27 (+ 29 d)	41.95M (+ 0B)	6 (+ 0)	29 (+ 0)	273,637 (+ 0)	2.87G (+ 110.30M)	78,921 (+ 3,113)
2017-12-29	41.95M	6	29	273,637	2.76G	75,808

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.