| Name | n3_chennan_city_guide_usdirectory_com |
|---|---|
| Data | 47.97M (+ 0B) |
| Tables | 26 (+ 0) |
| Columns | 136 (+ 0) |
| Table Rows | 212,160 (+ 0) |
| Media | 317.15K (+ 0B) |
| Files | 49 (+ 0) |
| Last Commit | 2023-06-19 18:36:38 (+ 169 d) |
This is a fields-rich United States city guides database of 50 records with attraction, car rental, florist, hotel, night club, restaurant tables in each. Each city guide record is comprised of title, image url and description. In table attraction, there are 170 records with title, description, street address, locality, region, postal code, phone, latitude and longitude in each. In the US city guides data, there are 50 car rental records, florist with 50 records, hotel with 50 records, night club with 50 records and 50 florist, all these 5 tables have address, phone number, website and miles in each record.
There are 26 tables in the whole American city guides data set.
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| city_guide_x_attraction | 170 | city_guide_id |
100%
|
| attraction_id |
100%
|
||
| city_guide_x_car_rental | 50 | city_guide_id |
100%
|
| car_rental_id |
100%
|
||
| city_guide_x_florist | 50 | city_guide_id |
100%
|
| florist_id |
100%
|
||
| city_guide_x_hotel | 50 | city_guide_id |
100%
|
| hotel_id |
100%
|
||
| city_guide_x_night_club | 50 | city_guide_id |
100%
|
| night_club_id |
100%
|
||
| city_guide_x_restaurant_1 | 50 | city_guide_id |
100%
|
| restaurant_1_id |
100%
|
||
| city_x_city_guide | 50 | city_id |
100%
|
| city_guide_id |
100%
|
||
| florist | 50 | title |
100%
|
| florist_1 | 6,799 | title |
100%
|
| address |
100%
|
||
| phone |
100%
|
||
| website |
31.48%
|
||
| miles |
89.67%
|
||
| florist_x_florist_1 | 6,799 | florist_id |
100%
|
| florist_1_id |
100%
|
||
| hotel | 50 | title |
100%
|
| hotel_1 | 4,616 | title |
100%
|
| address |
100%
|
||
| phone |
100%
|
||
| website |
72.92%
|
||
| miles |
87.82%
|
||
| hotel_x_hotel_1 | 4,616 | hotel_id |
100%
|
| hotel_1_id |
100%
|
||
| night_club | 50 | title |
100%
|
| night_club_1 | 2,644 | title |
100%
|
| address |
100%
|
||
| phone |
100%
|
||
| website |
14.64%
|
||
| miles |
90.66%
|
||
| night_club_x_night_club_1 | 2,644 | night_club_id |
100%
|
| night_club_1_id |
100%
|
||
| restaurant_1 | 50 | title |
100%
|
| restaurant_1_x_restaurant_2 | 91,369 | restaurant_1_id |
100%
|
| restaurant_2_id |
100%
|
||
| restaurant_2 | 91,369 | title |
100%
|
| address |
100%
|
||
| phone |
100%
|
||
| website |
36.9%
|
||
| miles |
88.27%
|
||
| attraction | 170 | title |
100%
|
| description |
99.41%
|
||
| street_address |
66.47%
|
||
| locality |
65.88%
|
||
| region |
65.88%
|
||
| postalcode |
65.88%
|
||
| phone |
60.59%
|
||
| latitude |
98.82%
|
||
| longitude |
98.82%
|
||
| car_rental | 50 | title |
100%
|
| car_rental_1 | 157 | title |
100%
|
| address |
100%
|
||
| phone |
100%
|
||
| website |
56.69%
|
||
| miles |
23.57%
|
||
| car_rental_x_car_rental_1 | 157 | car_rental_id |
100%
|
| car_rental_1_id |
100%
|
||
| city | 50 | title |
100%
|
| city_guide | 50 | image_url |
98%
|
| title |
100%
|
||
| description |
98%
|
| Size (Bytes) | Files |
|---|---|
| 317.15K | 49 |
| Time | Data | Tables | Columns | Rows | Media | Files |
|---|---|---|---|---|---|---|
| 2023-06-19 (+ 169 d) | 47.97M (+ 0B) | 26 (+ 0) | 136 (+ 0) | 212,160 (+ 0) | 317.15K (+ 0B) | 49 (+ 0) |
| 2023-01-01 (+ 95 d) | 47.97M (+ 0B) | 26 (+ 0) | 136 (+ 0) | 212,160 (+ 0) | 317.15K (+ 0B) | 49 (+ 0) |
| 2022-09-27 (+ 271 d) | 47.97M (+ 0B) | 26 (+ 0) | 136 (+ 0) | 212,160 (+ 0) | 317.15K (+ 0B) | 49 (+ 0) |
| 2021-12-30 (+ 115 d) | 47.97M (+ 0B) | 26 (+ 0) | 136 (+ 0) | 212,160 (+ 0) | 317.15K (+ 0B) | 49 (+ 0) |
| 2021-09-05 (+ 150 d) | 47.97M (+ 0B) | 26 (+ 0) | 136 (+ 0) | 212,160 (+ 0) | 317.15K (+ 0B) | 49 (+ 0) |
| 2021-04-08 (+ 68 d) | 47.97M (+ 0B) | 26 (+ 0) | 136 (+ 0) | 212,160 (+ 0) | 317.15K (+ 0B) | 49 (+ 0) |
| 2021-01-29 (+ 120 d) | 47.97M (+ 0B) | 26 (+ 0) | 136 (+ 0) | 212,160 (+ 0) | 317.15K (+ 0B) | 49 (+ 0) |
| 2020-10-01 (+ 38 d) | 47.97M (+ 0B) | 26 (+ 0) | 136 (+ 0) | 212,160 (+ 0) | 317.15K (+ 0B) | 49 (+ 0) |
| 2020-08-23 (+ 141 d) | 47.97M (+ 0B) | 26 (+ 0) | 136 (+ 0) | 212,160 (+ 0) | 317.15K (+ 0B) | 49 (+ 0) |
| 2020-04-04 (+ 196 d) | 47.97M (+ 0B) | 26 (+ 0) | 136 (+ 0) | 212,160 (+ 0) | 317.15K (+ 0B) | 49 (+ 0) |
| 2019-09-21 (+ 197 d) | 47.97M (+ 0B) | 26 (+ 0) | 136 (+ 0) | 212,160 (+ 0) | 317.15K (+ 0B) | 49 (+ 0) |
| 2019-03-07 (+ 43 d) | 47.97M (+ 0B) | 26 (+ 0) | 136 (+ 0) | 212,160 (+ 0) | 317.15K (+ 0B) | 49 (+ 0) |
| 2019-01-23 (+ 44 d) | 47.97M (+ 0B) | 26 (+ 0) | 136 (+ 0) | 212,160 (+ 0) | 317.15K (+ 0B) | 49 (+ 0) |
| 2018-12-09 (+ 29 d) | 47.97M (+ 0B) | 26 (+ 0) | 136 (+ 0) | 212,160 (+ 0) | 317.15K (+ 0B) | 49 (+ 0) |
| 2018-11-09 (+ 27 d) | 47.97M (- 1.72M) | 26 (+ 0) | 136 (+ 0) | 212,160 (+ 0) | 317.15K (+ 0B) | 49 (+ 0) |
| 2018-10-13 (+ 29 d) | 49.69M (+ 0B) | 26 (+ 0) | 136 (+ 0) | 212,160 (+ 0) | 317.15K (+ 0B) | 49 (+ 0) |
| 2018-09-13 (+ 34 d) | 49.69M (+ 0B) | 26 (+ 0) | 136 (+ 0) | 212,160 (+ 0) | 317.15K (+ 0B) | 49 (+ 0) |
| 2018-08-09 (+ 27 d) | 49.69M (+ 0B) | 26 (+ 0) | 136 (+ 0) | 212,160 (+ 0) | 317.15K (+ 0B) | 49 (+ 0) |
| 2018-07-12 (+ 31 d) | 49.69M (+ 0B) | 26 (+ 0) | 136 (+ 0) | 212,160 (+ 0) | 317.15K (+ 0B) | 49 (+ 0) |
| 2018-06-10 (+ 31 d) | 49.69M (+ 0B) | 26 (+ 0) | 136 (+ 0) | 212,160 (+ 0) | 317.15K (+ 0B) | 49 (+ 0) |
| 2018-05-10 (+ 28 d) | 49.69M (+ 0B) | 26 (+ 0) | 136 (+ 0) | 212,160 (+ 0) | 317.15K (+ 0B) | 49 (+ 0) |
| 2018-04-11 (+ 38 d) | 49.69M (+ 0B) | 26 (+ 0) | 136 (+ 0) | 212,160 (+ 0) | 317.15K (+ 0B) | 49 (+ 0) |
| 2018-03-03 (+ 35 d) | 49.69M (+ 0B) | 26 (+ 0) | 136 (+ 0) | 212,160 (+ 0) | 317.15K (+ 0B) | 49 (+ 0) |
| 2018-01-27 (+ 29 d) | 49.69M (+ 0B) | 26 (+ 0) | 136 (+ 0) | 212,160 (+ 0) | 317.15K (+ 0B) | 49 (+ 0) |
| 2017-12-29 (+ 20 d) | 49.69M (+ 0B) | 26 (+ 0) | 136 (+ 0) | 212,160 (+ 0) | 317.15K (+ 0B) | 49 (+ 0) |
| 2017-12-08 | 49.69M | 26 | 136 | 212,160 | 317.15K | 49 |
Contact us for pricing to download the latest commit / release of this database.
In the same time, you can also access this data set via API.
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.
The scanning and profiling of data size increments are done separately from those of the number of rows.
Subscribe to be notified of major data releases and updates.
STAY IN THE LOOP.
