Details
-
Task
-
Resolution: Fixed
-
Blocker
-
4.5.0
-
4.5.0-1875 Mac
Description
For FTS we added new documents of type “hotel” to the travel-sample MB-18221. The bucket analyzer results don’t display the common elements for hotel docs (the type value, for one) but it does identify the hotel documents as belonging to a single flavor.
In the screenshot above, the bucket analyzer indicates that the information is indexed but then the type=hotel doesn’t show up in the parenthesis for Flavor 1. I would expect to see (in-common: type = “hotel”).
I don’t think it’s capitalization or pluralization – select * from `travel-sample` where type=“Hotel" limit 10; returns 0, as does select with type=“hotels”.
These documents are built to have everything (or nearly everything) you can have in JSON, and they are pretty big. Could that be an issue?
I also ran INFER on them. The JSON output is below.
It seems to find flavors within the hotel document itself.
The table also has a lot of misaligned elements in the tree view.
I include those things in case they are a clue.
[
|
[
|
{
|
"#docs": 11, |
"$schema": "http://json-schema.org/schema#", |
"Flavor": "type = \"airline\"", |
"properties": { |
"callsign": { |
"#docs": 11, |
"%docs": 100, |
"samples": [ |
"ALOHA", |
"GIANT", |
"BRICKYARD", |
"CACTUS" |
],
|
"type": "string" |
},
|
"country": { |
"#docs": 11, |
"%docs": 100, |
"samples": [ |
"United States", |
"United Kingdom", |
"France" |
],
|
"type": "string" |
},
|
"iata": { |
"#docs": 11, |
"%docs": 100, |
"samples": [ |
"AQ", |
"5Y", |
"RW", |
"HP", |
"76" |
],
|
"type": "string" |
},
|
"icao": { |
"#docs": 11, |
"%docs": 100, |
"samples": [ |
"AAH", |
"GTI", |
"RPA", |
"AWE", |
"SJS" |
],
|
"type": "string" |
},
|
"id": { |
"#docs": 11, |
"%docs": 100, |
"samples": [ |
22, |
928, |
4187, |
281, |
17859 |
],
|
"type": "number" |
},
|
"name": { |
"#docs": 11, |
"%docs": 100, |
"samples": [ |
"Aloha Airlines", |
"Atlas Air", |
"Republic Airlines", |
"America West Airlines", |
"Southjet" |
],
|
"type": "string" |
},
|
"type": { |
"#docs": 11, |
"%docs": 100, |
"samples": [ |
"airline" |
],
|
"type": "string" |
}
|
}
|
},
|
{
|
"#docs": 157, |
"$schema": "http://json-schema.org/schema#", |
"Flavor": "", |
"properties": { |
"activity": { |
"#docs": 133, |
"%docs": 84.71, |
"samples": [ |
"see", |
"do", |
"drink", |
"buy", |
"eat" |
],
|
"type": "string" |
},
|
"address": { |
"#docs": 157, |
"%docs": 100, |
"samples": [ |
"Rosebery Ave, EC1R 4TN", |
"Craven Cottage, Stevenage Rd, ...", |
"6 Belgrave Mews West, SW1X 8HT", |
"Ariel Way, W12 7GF" |
],
|
"type": "string" |
},
|
"alt": { |
"#docs": 157, |
"%docs": 100, |
"samples": [ |
"1.5 mi (2.4 km) round-trip", |
"Couleurs du Quai Voltaire", |
"7.2 mi (11.6 km) round-trip", |
"Jardin archéologique" |
],
|
"type": "string" |
},
|
"checkin": { |
"#docs": 157, |
"%docs": 100, |
"samples": [ |
"15:00", |
"14:00", |
"3PM" |
],
|
"type": "string" |
},
|
"checkout": { |
"#docs": 157, |
"%docs": 100, |
"samples": [ |
"12:00", |
"noon", |
"12PM" |
],
|
"type": "string" |
},
|
"city": { |
"#docs": 157, |
"%docs": 100, |
"samples": [ |
"London", |
"Isle of Anglesey", |
"Powys", |
"Carpentras", |
"Gwynedd" |
],
|
"type": "string" |
},
|
"content": { |
"#docs": 157, |
"%docs": 100, |
"samples": [ |
"A large open park which is mai...", |
"Leading dance production theat...", |
"The home of Premier League foo...", |
"Ellin's Tower view point ad vi...", |
"One of only two London pubs (a..." |
],
|
"type": "string" |
},
|
"country": { |
"#docs": 157, |
"%docs": 100, |
"samples": [ |
"United Kingdom", |
"France", |
"United States" |
],
|
"type": "string" |
},
|
"directions": { |
"#docs": 157, |
"%docs": 100, |
"samples": [ |
"tube: Putney Bridge", |
"tube: Angel", |
"about 10 min walk from both Pu...", |
"tube: Knightsbridge ''or'' Hyd..." |
],
|
"type": "string" |
},
|
"email": { |
"#docs": 157, |
"%docs": 100, |
"samples": [ |
"enquiries@fulhamfc.com", |
"startavern@fullers.co.uk", |
"carrickarede@nationaltrust.org...", |
"westontouristinfo@n-somerset.g...", |
"meg.shiffler@sfgov.org", |
"bookings@roxybarandscreen.co.u..." |
],
|
"type": "string" |
},
|
"fax": { |
"#docs": 157, |
"%docs": 100, |
"samples": [ |
"+1 714 278-7066", |
"+44 1934 641 741", |
"+1 415 554-6093", |
"+1 805 643-7831" |
],
|
"type": "string" |
},
|
"geo": { |
"#docs": 157, |
"%docs": 100, |
"properties": { |
"accuracy": { |
"#docs": 157, |
"%docs": 100, |
"samples": [ |
"ROOFTOP", |
"APPROXIMATE", |
"RANGE_INTERPOLATED" |
],
|
"type": "string" |
},
|
"lat": { |
"#docs": 157, |
"%docs": 100, |
"samples": [ |
51.4692, |
51.5294, |
51.4749, |
53.304352, |
51.4984 |
],
|
"type": "number" |
},
|
"lon": { |
"#docs": 157, |
"%docs": 100, |
"samples": [ |
-0.2021, |
-0.1061, |
-0.2216, |
-4.693153, |
-0.1559 |
],
|
"type": "number" |
}
|
},
|
"samples": [ |
{
|
"accuracy": "ROOFTOP", |
"lat": 51.4692, |
"lon": -0.2021 |
},
|
{
|
"accuracy": "APPROXIMATE", |
"lat": 51.5294, |
"lon": -0.1061 |
},
|
{
|
"accuracy": "APPROXIMATE", |
"lat": 51.4749, |
"lon": -0.2216 |
},
|
{
|
"accuracy": "APPROXIMATE", |
"lat": 53.304352, |
"lon": -4.693153 |
},
|
{
|
"accuracy": "ROOFTOP", |
"lat": 51.4984, |
"lon": -0.1559 |
}
|
],
|
"type": "object" |
},
|
"hours": { |
"#docs": 157, |
"%docs": 100, |
"samples": [ |
"M–F 11:00–23:00; Sa noon��...", |
"M–Sa 10:00–22:00; Su noon�...", |
"4 Nov-31 Mar daily 10:00-16:00...", |
"M-F 8AM-5PM, Sa-Su 10AM-4PM", |
"8AM-4:30PM (extended hours in ...", |
"11:00 - 16:00", |
"Th-M 11AM-5PM" |
],
|
"type": "string" |
},
|
"id": { |
"#docs": 157, |
"%docs": 100, |
"samples": [ |
16136, |
16201, |
16149, |
41251, |
16508 |
],
|
"type": "number" |
},
|
"image": { |
"#docs": 157, |
"%docs": 100, |
"samples": [ |
"https://en.wikivoyage.org/wiki...", |
"https://en.wikivoyage.org/wiki...", |
"https://en.wikivoyage.org/wiki...", |
"https://en.wikivoyage.org/wiki...", |
"https://en.wikivoyage.org/wiki..." |
],
|
"type": "string" |
},
|
"image_direct_url": { |
"#docs": 12, |
"%docs": 7.64, |
"samples": [ |
"https://upload.wikimedia.org/w...", |
"https://upload.wikimedia.org/w...", |
"https://upload.wikimedia.org/w...", |
"https://upload.wikimedia.org/w...", |
"" |
],
|
"type": "string" |
},
|
"name": { |
"#docs": 157, |
"%docs": 100, |
"samples": [ |
"Hurlingham Park", |
"Sadler's Wells Theatre", |
"Fulham FC", |
"South Stack Cliffs RSPB reserv...", |
"The Star Tavern" |
],
|
"type": "string" |
},
|
"phone": { |
"#docs": 157, |
"%docs": 100, |
"samples": [ |
"+44 20 7863-8000", |
"+44 870 442 1222", |
"+44 20 7235-3019", |
"+44 20 3371-2300" |
],
|
"type": "string" |
},
|
"price": { |
"#docs": 157, |
"%docs": 100, |
"samples": [ |
"4 Nov-31 Mar: Free, 1 Apr-3 No...", |
"$3-5", |
"Free - suggested $3 donation", |
"Free but charges apply to tour...", |
"$12, $7 student (includes admi..." |
],
|
"type": "string" |
},
|
"public_likes": { |
"#docs": 24, |
"%docs": 15.28, |
"items": { |
"#schema": "FieldType", |
"subtype": null, |
"type": "string" |
},
|
"maxItems": 9, |
"minItems": 0, |
"samples": [ |
[],
|
[
|
"Jarod Nikolaus" |
],
|
[
|
"Devan Halvorson", |
"Alia Senger", |
"Anastacio Miller" |
],
|
[
|
"Lillian Johns", |
"Desmond Goodwin", |
"Jerald Funk" |
],
|
[
|
"Maude Macejkovic", |
"Edwin Thompson Jr.", |
"Erick Ryan", |
"Mr. Jaclyn Kassulke", |
"Corene Hickle", |
"Dorothea Walker", |
"Eleonore Romaguera" |
]
|
],
|
"type": "array" |
},
|
"reviews": { |
"#docs": 24, |
"%docs": 15.28, |
"items": [ |
{
|
"#schema": "FieldType", |
"subtype": { |
"#docs": 1, |
"$schema": "http://json-schema.org/schema#", |
"Flavor": "author = \"Letitia Lind\", content = \"We booked and paid , date = \"2012-02-03 13:48:43", |
"properties": { |
"author": { |
"samples": [ |
"Letitia Lind" |
],
|
"type": "string" |
},
|
"content": { |
"samples": [ |
"We booked and paid in advance ..." |
],
|
"type": "string" |
},
|
"date": { |
"samples": [ |
"2012-02-03 13:48:43 +0300" |
],
|
"type": "string" |
},
|
"ratings": { |
"properties": { |
"Overall": { |
"samples": [ |
1 |
],
|
"type": "number" |
},
|
"Service": { |
"samples": [ |
1 |
],
|
"type": "number" |
},
|
"Value": { |
"samples": [ |
1 |
],
|
"type": "number" |
}
|
},
|
"samples": [ |
{
|
"Overall": 1, |
"Service": 1, |
"Value": 1 |
}
|
],
|
"type": "object" |
}
|
}
|
},
|
"type": "object" |
},
|
{
|
"#schema": "FieldType", |
"subtype": { |
"#docs": 1, |
"$schema": "http://json-schema.org/schema#", |
"Flavor": "author = \"Kaitlyn Osinski\", content = \"We stayed here whil, date = \"2013-09-14 05:45:21", |
"properties": { |
"author": { |
"samples": [ |
"Kaitlyn Osinski" |
],
|
"type": "string" |
},
|
"content": { |
"samples": [ |
"We stayed here while so that w..." |
],
|
"type": "string" |
},
|
"date": { |
"samples": [ |
"2013-09-14 05:45:21 +0300" |
],
|
"type": "string" |
},
|
"ratings": { |
"properties": { |
"Cleanliness": { |
"samples": [ |
5 |
],
|
"type": "number" |
},
|
"Overall": { |
"samples": [ |
4 |
],
|
"type": "number" |
},
|
"Rooms": { |
"samples": [ |
4 |
],
|
"type": "number" |
},
|
"Service": { |
"samples": [ |
5 |
],
|
"type": "number" |
},
|
"Value": { |
"samples": [ |
4 |
],
|
"type": "number" |
}
|
},
|
"samples": [ |
{
|
"Cleanliness": 5, |
"Overall": 4, |
"Rooms": 4, |
"Service": 5, |
"Value": 4 |
}
|
],
|
"type": "object" |
}
|
}
|
},
|
"type": "object" |
},
|
{
|
"#schema": "FieldType", |
"subtype": { |
"#docs": 1, |
"$schema": "http://json-schema.org/schema#", |
"Flavor": "author = \"Rodolfo Emmerich\", content = \"When we arrived I w, date = \"2014-11-04 07:44:02", |
"properties": { |
"author": { |
"samples": [ |
"Rodolfo Emmerich" |
],
|
"type": "string" |
},
|
"content": { |
"samples": [ |
"When we arrived I was supprise..." |
],
|
"type": "string" |
},
|
"date": { |
"samples": [ |
"2014-11-04 07:44:02 +0300" |
],
|
"type": "string" |
},
|
"ratings": { |
"properties": { |
"Check in / front desk": { |
"samples": [ |
5 |
],
|
"type": "number" |
},
|
"Cleanliness": { |
"samples": [ |
5 |
],
|
"type": "number" |
},
|
"Location": { |
"samples": [ |
3 |
],
|
"type": "number" |
},
|
"Overall": { |
"samples": [ |
5 |
],
|
"type": "number" |
},
|
"Rooms": { |
"samples": [ |
5 |
],
|
"type": "number" |
},
|
"Service": { |
"samples": [ |
5 |
],
|
"type": "number" |
},
|
"Value": { |
"samples": [ |
5 |
],
|
"type": "number" |
}
|
},
|
"samples": [ |
{
|
"Check in / front desk": 5, |
"Cleanliness": 5, |
"Location": 3, |
"Overall": 5, |
"Rooms": 5, |
"Service": 5, |
"Value": 5 |
}
|
],
|
"type": "object" |
}
|
}
|
},
|
"type": "object" |
},
|
{
|
"#schema": "FieldType", |
"subtype": { |
"#docs": 1, |
"$schema": "http://json-schema.org/schema#", |
"Flavor": "author = \"Claud Moen\", content = \"Our trip began as a, date = \"2014-12-28 09:44:17", |
"properties": { |
"author": { |
"samples": [ |
"Claud Moen" |
],
|
"type": "string" |
},
|
"content": { |
"samples": [ |
"Our trip began as a two day tr..." |
],
|
"type": "string" |
},
|
"date": { |
"samples": [ |
"2014-12-28 09:44:17 +0300" |
],
|
"type": "string" |
},
|
"ratings": { |
"properties": { |
"Location": { |
"samples": [ |
4 |
],
|
"type": "number" |
},
|
"Overall": { |
"samples": [ |
4 |
],
|
"type": "number" |
},
|
"Rooms": { |
"samples": [ |
4 |
],
|
"type": "number" |
},
|
"Service": { |
"samples": [ |
4 |
],
|
"type": "number" |
},
|
"Value": { |
"samples": [ |
4 |
],
|
"type": "number" |
}
|
},
|
"samples": [ |
{
|
"Location": 4, |
"Overall": 4, |
"Rooms": 4, |
"Service": 4, |
"Value": 4 |
}
|
],
|
"type": "object" |
}
|
}
|
},
|
"type": "object" |
},
|
{
|
"#schema": "FieldType", |
"subtype": { |
"#docs": 1, |
"$schema": "http://json-schema.org/schema#", |
"Flavor": "author = \"Jerry Gutkowski\", content = \"Takes a bit of gett, date = \"2012-06-12 07:02:44", |
"properties": { |
"author": { |
"samples": [ |
"Jerry Gutkowski" |
],
|
"type": "string" |
},
|
"content": { |
"samples": [ |
"Takes a bit of getting to, but..." |
],
|
"type": "string" |
},
|
"date": { |
"samples": [ |
"2012-06-12 07:02:44 +0300" |
],
|
"type": "string" |
},
|
"ratings": { |
"properties": { |
"Cleanliness": { |
"samples": [ |
5 |
],
|
"type": "number" |
},
|
"Location": { |
"samples": [ |
3 |
],
|
"type": "number" |
},
|
"Overall": { |
"samples": [ |
5 |
],
|
"type": "number" |
},
|
"Rooms": { |
"samples": [ |
5 |
],
|
"type": "number" |
},
|
"Service": { |
"samples": [ |
5 |
],
|
"type": "number" |
},
|
"Sleep Quality": { |
"samples": [ |
5 |
],
|
"type": "number" |
},
|
"Value": { |
"samples": [ |
3 |
],
|
"type": "number" |
}
|
},
|
"samples": [ |
{
|
"Cleanliness": 5, |
"Location": 3, |
"Overall": 5, |
"Rooms": 5, |
"Service": 5, |
"Sleep Quality": 5, |
"Value": 3 |
}
|
],
|
"type": "object" |
}
|
}
|
},
|
"type": "object" |
},
|
{
|
"#schema": "FieldType", |
"subtype": { |
"#docs": 1, |
"$schema": "http://json-schema.org/schema#", |
"Flavor": "author = \"Al Hartmann\", content = \"Resort is written a, date = \"2013-02-15 12:51:51", |
"properties": { |
"author": { |
"samples": [ |
"Al Hartmann" |
],
|
"type": "string" |
},
|
"content": { |
"samples": [ |
"Resort is written all over thi..." |
],
|
"type": "string" |
},
|
"date": { |
"samples": [ |
"2013-02-15 12:51:51 +0300" |
],
|
"type": "string" |
},
|
"ratings": { |
"properties": { |
"Business service (e.g., internet access)": { |
"samples": [ |
5 |
],
|
"type": "number" |
},
|
"Check in / front desk": { |
"samples": [ |
5 |
],
|
"type": "number" |
},
|
"Cleanliness": { |
"samples": [ |
5 |
],
|
"type": "number" |
},
|
"Location": { |
"samples": [ |
5 |
],
|
"type": "number" |
},
|
"Overall": { |
"samples": [ |
5 |
],
|
"type": "number" |
},
|
"Rooms": { |
"samples": [ |
5 |
],
|
"type": "number" |
},
|
"Service": { |
"samples": [ |
5 |
],
|
"type": "number" |
},
|
"Value": { |
"samples": [ |
5 |
],
|
"type": "number" |
}
|
},
|
"samples": [ |
{
|
"Business service (e.g., internet access)": 5, |
"Check in / front desk": 5, |
"Cleanliness": 5, |
"Location": 5, |
"Overall": 5, |
"Rooms": 5, |
"Service": 5, |
"Value": 5 |
}
|
],
|
"type": "object" |
}
|
}
|
},
|
"type": "object" |
},
|
{
|
"#schema": "FieldType", |
"subtype": { |
"#docs": 1, |
"$schema": "http://json-schema.org/schema#", |
"Flavor": "author = \"Ward Miller PhD\", content = \"we spent 4 days at , date = \"2012-01-29 03:05:18", |
"properties": { |
"author": { |
"samples": [ |
"Ward Miller PhD" |
],
|
"type": "string" |
},
|
"content": { |
"samples": [ |
"we spent 4 days at the jw marr..." |
],
|
"type": "string" |
},
|
"date": { |
"samples": [ |
"2012-01-29 03:05:18 +0300" |
],
|
"type": "string" |
},
|
"ratings": { |
"properties": { |
"Overall": { |
"samples": [ |
5 |
],
|
"type": "number" |
}
|
},
|
"samples": [ |
{
|
"Overall": 5 |
}
|
],
|
"type": "object" |
}
|
}
|
},
|
"type": "object" |
},
|
{
|
"#schema": "FieldType", |
"subtype": { |
"#docs": 1, |
"$schema": "http://json-schema.org/schema#", |
"Flavor": "author = \"Reva Rippin\", content = \"Excellent Bargain F, date = \"2015-01-08 14:51:09", |
"properties": { |
"author": { |
"samples": [ |
"Reva Rippin" |
],
|
"type": "string" |
},
|
"content": { |
"samples": [ |
"Excellent Bargain For the cost..." |
],
|
"type": "string" |
},
|
"date": { |
"samples": [ |
"2015-01-08 14:51:09 +0300" |
],
|
"type": "string" |
},
|
"ratings": { |
"properties": { |
"Business service": { |
"samples": [ |
-1 |
],
|
"type": "number" |
},
|
"Check in / front desk": { |
"samples": [ |
-1 |
],
|
"type": "number" |
},
|
"Cleanliness": { |
"samples": [ |
3 |
],
|
"type": "number" |
},
|
"Location": { |
"samples": [ |
-1 |
],
|
"type": "number" |
},
|
"Overall": { |
"samples": [ |
4 |
],
|
"type": "number" |
},
|
"Rooms": { |
"samples": [ |
3 |
],
|
"type": "number" |
},
|
"Service": { |
"samples": [ |
4 |
],
|
"type": "number" |
},
|
"Value": { |
"samples": [ |
5 |
],
|
"type": "number" |
}
|
},
|
"samples": [ |
{
|
"Business service": -1, |
"Check in / front desk": -1, |
"Cleanliness": 3, |
"Location": -1, |
"Overall": 4, |
"Rooms": 3, |
"Service": 4, |
"Value": 5 |
}
|
],
|
"type": "object" |
}
|
}
|
},
|
"type": "object" |
},
|
{
|
"#schema": "FieldType", |
"subtype": { |
"#docs": 1, |
"$schema": "http://json-schema.org/schema#", |
"Flavor": "author = \"Ernestine Kutch\", content = \"My now Husband \\u00, date = \"2015-03-14 23:03:08", |
"properties": { |
"author": { |
"samples": [ |
"Ernestine Kutch" |
],
|
"type": "string" |
},
|
"content": { |
"samples": [ |
"My now Husband && I traveled t..." |
],
|
"type": "string" |
},
|
"date": { |
"samples": [ |
"2015-03-14 23:03:08 +0300" |
],
|
"type": "string" |
},
|
"ratings": { |
"properties": { |
"Cleanliness": { |
"samples": [ |
5 |
],
|
"type": "number" |
},
|
"Overall": { |
"samples": [ |
4 |
],
|
"type": "number" |
},
|
"Service": { |
"samples": [ |
5 |
],
|
"type": "number" |
},
|
"Sleep Quality": { |
"samples": [ |
5 |
],
|
"type": "number" |
},
|
"Value": { |
"samples": [ |
5 |
],
|
"type": "number" |
}
|
},
|
"samples": [ |
{
|
"Cleanliness": 5, |
"Overall": 4, |
"Service": 5, |
"Sleep Quality": 5, |
"Value": 5 |
}
|
],
|
"type": "object" |
}
|
}
|
},
|
"type": "object" |
},
|
{
|
"#schema": "FieldType", |
"subtype": { |
"#docs": 1, |
"$schema": "http://json-schema.org/schema#", |
"Flavor": "author = \"Blaze Bernhard\", content = \"This was my 2nd sta, date = \"2013-10-06 20:17:48", |
"properties": { |
"author": { |
"samples": [ |
"Blaze Bernhard" |
],
|
"type": "string" |
},
|
"content": { |
"samples": [ |
"This was my 2nd stay at The Ch..." |
],
|
"type": "string" |
},
|
"date": { |
"samples": [ |
"2013-10-06 20:17:48 +0300" |
],
|
"type": "string" |
},
|
"ratings": { |
"properties": { |
"Cleanliness": { |
"samples": [ |
5 |
],
|
"type": "number" |
},
|
"Location": { |
"samples": [ |
5 |
],
|
"type": "number" |
},
|
"Overall": { |
"samples": [ |
5 |
],
|
"type": "number" |
},
|
"Rooms": { |
"samples": [ |
5 |
],
|
"type": "number" |
},
|
"Service": { |
"samples": [ |
5 |
],
|
"type": "number" |
},
|
"Value": { |
"samples": [ |
5 |
],
|
"type": "number" |
}
|
},
|
"samples": [ |
{
|
"Cleanliness": 5, |
"Location": 5, |
"Overall": 5, |
"Rooms": 5, |
"Service": 5, |
"Value": 5 |
}
|
],
|
"type": "object" |
}
|
}
|
},
|
"type": "object" |
}
|
],
|
"maxItems": 9, |
"minItems": 0, |
"samples": [ |
[
|
{
|
"author": "Rebeca Marquardt", |
"content": "Loved this hotel! Great beds and bathroom ... the two most important things in a hotel. Also found the concierge very helpful in suggesting and booking beau wine tours for us. Liked the location close to everything.", |
"date": "2015-02-22 23:49:12 +0300", |
"ratings": { |
"Cleanliness": 4, |
"Location": 5, |
"Overall": 4, |
"Rooms": 4, |
"Service": 4, |
"Sleep Quality": 5, |
"Value": 5 |
}
|
},
|
{
|
"author": "Dolores Littel", |
"content": "Good hotel at a good location. I would stay here again. It was relatively quiet for our stay.", |
"date": "2015-12-30 13:33:42 +0300", |
"ratings": { |
"Cleanliness": 3, |
"Location": 3, |
"Overall": 4, |
"Rooms": 3, |
"Service": 3, |
"Sleep Quality": 3, |
"Value": 3 |
}
|
},
|
{
|
"author": "Dallin Thompson", |
"content": "we arrived at the hotel fairly late at night due to delays by the airlines, but we called ahead and the friendly staff were informed of our delay.. we stayed at the hotel only a few short months after its opening and if i could describe it in one word..WOW !! the hotel is amazing.. the surrounding area is in the heart of napa but still up and coming, there were many of new business( store fronts) buildings that were vacant. the staff was very nice and polite and the concierge station was extreamly helpful in planning some great wine tours, they even gave us free sampling cards of other local shops and winemakers. the patio area has a fireplace which is great for enjoying a bottle of wine and winding down after a long day. the rooms were very nice, clean and had a safe in each room along with flat screen tv and a incredibly big walk in shower!! valley parking is expensive but there is a free parking garage literally right behind the hotel !! ( 30 second walk if you go out thru the dinning room exit ) altho you must park on the 3rd floor for free overnight parking. you will get towed on the first 2 floors!! hotel prices were little on the steep side but it is Napa Valley !! i would absolutely stay at this hotel again.. also anyone planning a trip to Napa .. the wine train dinner is a must !! great 4 course meal with a relaxing view of the Napa countryside", |
"date": "2015-07-04 14:33:51 +0300", |
"ratings": { |
"Cleanliness": 5, |
"Location": 3, |
"Overall": 5, |
"Rooms": 5, |
"Service": 5, |
"Value": 2 |
}
|
}
|
],
|
[
|
{
|
"author": "Dr. Rhiannon Collier", |
"content": "All I can say is Wow! What a beautiful hotel!!! I thought I was in a different era! The chandeliers were absolutely gorgeous. The hotel itself was so elegant and very clean. Although our room and bathroom was small, but that part of the charm. After all it was built with the European flair. Check out the third floor where Merilyn Monroe suite is located. Can you imagine?? I don't know what the other people expect, but I thought it was just beautiful. I wish I could have been there when all the movies stars stayed there. Like Hollywood away from Hollywood!!", |
"date": "2015-06-06 19:19:07 +0300", |
"ratings": { |
"Cleanliness": 4, |
"Location": 5, |
"Overall": 4, |
"Rooms": 4, |
"Service": 4, |
"Sleep Quality": 4, |
"Value": 2 |
}
|
},
|
{
|
"author": "Ms. Kamryn Nicolas", |
"content": "What a dump! Save your money and stay at the local hostel - you'll get nicer accommodations, a quieter night's rest and food.", |
"date": "2014-07-16 06:30:47 +0300", |
"ratings": { |
"Cleanliness": 3, |
"Location": 5, |
"Overall": 1, |
"Rooms": 1, |
"Service": 2, |
"Value": 1 |
}
|
},
|
{
|
"author": "Darrion Gibson", |
"content": "Lots of disappointments. We arrived at 5:00 PM on Saturday. There was no valet. Parking was two blocks away. No bellman to help with the bags. Small rooms were expected, but light emitting vents over the door was not. The place was noisy, as there were no double paned windows and the vents in the bathroom were like a megaphone to others rooms! Shower was clogged, it took 20 minutes for the drain to go down. Worst of all was the lack of advertised wireless internet. The connection kept dropping after one or two minutes making any kind of web work impossible! Staff gave an explanation which was not believable by anyone with even the basics of networking, let alone an IP professional. If they don't know, then say so...don't give me a story. Did I mention that there was no food service on Sunday morning? The clerk cheerfully directed guests to a diner four blocks away, which was closed! Bottom line: We will not stay here again.", |
"date": "2015-02-26 21:22:08 +0300", |
"ratings": { |
"Business service (e.g., internet access)": 1, |
"Check in / front desk": 3, |
"Cleanliness": 3, |
"Location": 3, |
"Overall": 1, |
"Rooms": 1, |
"Service": 1, |
"Value": 1 |
}
|
},
|
{
|
"author": "Foster Fahey", |
"content": "They did not give the price quoted once we arrivered in Phoenix, the security was awesome, but the front desk clerks were rude.", |
"date": "2013-07-05 03:14:02 +0300", |
"ratings": { |
"Overall": 1 |
}
|
},
|
{
|
"author": "Letitia Lind", |
"content": "We booked and paid in advance through Expedia. On arrival at 9pm, we were informed that they were overbooked and had no available rooms. There was a second customer being told the same. We were given a room at the Ramada, which is clearly lower cost and standard. No refund offered or given. Reception staff were very aloof and very slow.", |
"date": "2012-02-03 13:48:43 +0300", |
"ratings": { |
"Overall": 1, |
"Service": 1, |
"Value": 1 |
}
|
},
|
{
|
"author": "Amie Stamm", |
"content": "This is another place that I think other reviewers and I went to two different places. I would definitely stay here again. Pros - Room was very clean and comfortable. It is an extended stay, so you get the couch, kitchen, and such. Bathroom was clean and had plenty of towels to choose from. Very quiet all night and when you travel in the immediate area, you have some good choices for a meal. Front desk people were generally friendly. Cons - Wifi didn't exist or you had to pay, never quite figured it out. Hallway had a funny smell. Location is a bit off I-10, but it wasn't too far and minimal traffic made it easy to get to it and back to I-10.", |
"date": "2014-04-15 04:40:04 +0300", |
"ratings": { |
"Cleanliness": 5, |
"Location": 4, |
"Overall": 4, |
"Rooms": 5, |
"Service": 5, |
"Sleep Quality": 4, |
"Value": 5 |
}
|
}
|
],
|
[
|
{
|
"author": "Marilyne Reichel", |
"content": "i had a bad experience over there. Just feel myself being cheated. I had booked a room for 2 for through internet, and even from the preference coloumn i had mentioned i wanna 2 beds in a room. Guess what? whenever we reach there (which is about 10pm), they bring us in a room, which a standard size single bed, and claim that it is double bed, and that is a room for 2! i suspected they had rented out the actual double room to the walk in customers. In fact, i had been go through some of the review, and understand that the room is small, but i just couldnt understand that why they treat me like idiot and keep mentioning that this is HK standard size double bed!! we have no choice as that was the peak season of HK and i believe i could not locate another hotel in the new year eve. However, it spoilt my new year mood, and my 2009 was started in a bad experience! U might find it is difficult to get the hotel as it is not reachable by MTR. However, you really enjoy the local life of Hong Kees. With the crowded wet and dry market, fruit stalls, and food stalls, we did enjoy ourselves throughout our stay. Further, the bus station is 2 minute walking distance from the hotel, easily reach causeway bay, central through the bus. what i want to mean is, it is not easy to find the hotel, but easy to go central those places from the hotel.", |
"date": "2014-07-16 03:20:52 +0300", |
"ratings": { |
"Cleanliness": 4, |
"Location": 3, |
"Overall": 2, |
"Rooms": 1, |
"Service": 3, |
"Value": 1 |
}
|
}
|
],
|
[
|
{
|
"author": "Lera Stoltenberg I", |
"content": "I want to commend Hotel Le Marais on their hospitality, competence, reliability, efficiency and attentiveness regarding our hotel stay. From the beginning of our booking process earlier this year to the final checkout I have been very pleased with all stages and personnel. Shawn was excellent booking my room and giving me the room I requested. He was always cheerful and anxious to help The next day after we checked in, we overslept for breakfast and we came down to the front desk and explained that we have missed breakfast this morning and asked to the young lady who was working if we could get some fruit and yogurt. As fast as she could she ran to the kitchen and brought us oranges, apples, yogurt and amazingly she also included muffins, sausage patties with English muffins, milk and orange juice. Seriously…this is SERVICE!!! The type of service you don’t find everywhere. She went above and beyond our expectations and if I remembered correctly her name was Daphneey. The room was clean and nice, with everything you could possibly need. The bar was awesome with candles lighting up in every table. Shawn and Alex at the bar were amazing. The heated outdoor pool was relaxing. My wife and I were really impressed with the overall appearance of the hotel, the staff and especially the comfort of the beds. Thank you Hotel Le Marais, your immediate staff, the front desk staff, to the housekeeping department—each person made my wife and I feel welcomed, cared about and treated like a friend. We will definitely comeback again and again!!!!!", |
"date": "2015-07-27 21:51:40 +0300", |
"ratings": { |
"Cleanliness": 5, |
"Location": 5, |
"Overall": 5, |
"Rooms": 5, |
"Service": 5, |
"Sleep Quality": 5, |
"Value": 5 |
}
|
},
|
{
|
"author": "Isai Johns", |
"content": "This hotel is newly renovated. It looks great today. They cut corners in renovation, for example, they didn't replace the elevator which is painfully slow. They used cheap doors and you can hear right through them. While waiting for an elevator we could clearly hear a shower in one room and a whoopie session in another. The complimentary breakfast is lame. A few boxes of cereal and bagels laid out in the bar, not a service person to be seen. That said, the bed was great, free wifi is appreciated,location is great and quiet. The rooms are pretty, small but nice.", |
"date": "2015-12-01 22:27:49 +0300", |
"ratings": { |
"Cleanliness": 4, |
"Location": 5, |
"Overall": 4, |
"Rooms": 4, |
"Service": 3, |
"Sleep Quality": 4, |
"Value": 5 |
}
|
},
|
{
|
"author": "Athena Feil", |
"content": "I recently had the pleasure of staying at the newest French Quarter property, Hotel Le Marais. While still undergoing the final touches of a massive renovation, this is a beautiful little gem right off of Bourbon Street. Upon arriving, parking can be a little tricky, as with all of the boutique hotels in the quarter. But valet was great. Lobby was small but very efficient, with the hotel lounge overlooking a stunningly beautiful courtyard, complete with a small pool. The rooms were very nice and stylish,. The beds were incredibly comfortable. LOVED the step in shower. Although no tub, the shower was great! And, even though you are less than a block off of Bourbon street, I couldn't hear any of the noise. This property is a real asset to the French Quarter and I would highly recommend it whether your going to the city for business or pleasure. Can't wait to stay again!!", |
"date": "2012-12-15 15:34:51 +0300", |
"ratings": { |
"Cleanliness": 5, |
"Location": 5, |
"Overall": 5, |
"Rooms": 4, |
"Service": 4, |
"Sleep Quality": 5, |
"Value": 5 |
}
|
},
|
{
|
"author": "Georgianna Nitzsche", |
"content": "I would highly recommend this hotel. The room was great, very modern, comfortable bed, and very nice and clean room and bathroom. The restaurant and bar are amazing. They have a few tables with beer taps at the table very cool. The bar is very modern and well stocked, if Abby is your bartender then your in for a treat, she is the best. Great staff and service. I stayed with my uncle and his friend booked the room and he did not know I was coming so when we asked for a room with two beds they had nothing available so they took some $$ of our bill and gave us two money vouchers towards the bar or restaurant. Great location a few blocks from bourbon street so you don't get all the noisy rift raft at night, and walking distance to Jackson square and the Frenchman. If Acme has a line 30 deep which it usually does go across the street to Felix's its better and is where the locals go, huge fresh oysters the best I have ever had. Enjoy the devils play ground I did.", |
"date": "2012-12-19 11:32:48 +0300", |
"ratings": { |
"Cleanliness": 5, |
"Location": 5, |
"Overall": 4, |
"Rooms": 5, |
"Service": 5, |
"Sleep Quality": 5, |
"Value": 4 |
}
|
},
|
{
|
"author": "Doyle Trantow", |
"content": "Recently stayed there for a night. It was my first trip to New Orleans, and the staff (especially Helbert) had great recommendations for food and entertainment. They were incredibly nice. Parking was cheapish and on-site, so I just drove right up to the hotel and valet-parked. The room was what you'd expect from a W: stylish, comfortable bed, nice bathroom. There is some construction going on at the hotel, which is sort of annoying, but it was not a problem on my floor. There's a great pool as well.", |
"date": "2013-12-10 19:44:20 +0300", |
"ratings": { |
"Cleanliness": 5, |
"Location": 5, |
"Overall": 4, |
"Rooms": 5, |
"Service": 5, |
"Sleep Quality": 5, |
"Value": 5 |
}
|
},
|
{
|
"author": "Princess Reichert", |
"content": "I had a pretty nice stay for three nights at the W under renovation in the French Quarter. Great location, nice staff, service variable, but OK, and I am fussy. Was in a new room. The good news is that unlike most W's there was enough light for my aging eyes. The bad, the new decor is really terrible. Why didnt they keep it simple instead of painting the walls orange with an eyesore of a design as the focal point of the room and the ugliest carpet I have ever seen. Could have been amazing, now certainly comfortable, and the good part is you close your eyes at night and dont have to look up at the scary design above you. I'd stay again, but sorry for the poor designer.", |
"date": "2015-11-16 17:19:12 +0300", |
"ratings": { |
"Cleanliness": 3, |
"Location": 5, |
"Overall": 4, |
"Rooms": 4, |
"Service": 3, |
"Sleep Quality": 4, |
"Value": 3 |
}
|
},
|
{
|
"author": "Maia Wehner", |
"content": "Love this place. The construction is a pain, but should be wrapped by summer. The staff was so over the top nice and helpful it made up for any jack hammers. Especially ask for Halbert and Daniel. The two guys were super cool and couldn't be more helpful. Southern hospitality at its finest. Ya'll.", |
"date": "2013-12-11 19:51:00 +0300", |
"ratings": { |
"Cleanliness": 4, |
"Location": 5, |
"Overall": 5, |
"Rooms": 4, |
"Service": 5, |
"Sleep Quality": 4, |
"Value": 4 |
}
|
},
|
{
|
"author": "Joannie Effertz MD", |
"content": "The staff at this hotel was the friendliest and most helpful of any hotel we've ever stayed in. Since there is currently construction going on at this W, it is difficult to give a fair rating. As SPG members we expected a better room. The only available room was small and there wasn't even a comfortable chair in it. But at least it was at the rear of the total away from the construction noise and jackhammers. A stay at this W will probably be better after the construction is completed and, hopefully, the rooms are upgraded a bit. The extremely friendly and accommodating staff and great location in the French Quarter are reason enough for us to return to the W on our next visit (after renovations are completed).", |
"date": "2013-10-14 07:08:13 +0300", |
"ratings": { |
"Cleanliness": 5, |
"Location": 5, |
"Overall": 3, |
"Rooms": 3, |
"Service": 5, |
"Sleep Quality": 4, |
"Value": 5 |
}
|
},
|
{
|
"author": "Arlie Leannon", |
"content": "We just stayed at the W New Orleans French Quarter. We had a very unfortunate experience with our room being located close to construction taking place in the hotel. The staff at the hotel was extremely attentive and did their very best to make things right for us. I can't say enough about the concierge Halbert. Truly a stand-out in service. Recommend verifying up front if construction is still taking place and if so doing what you can to ensure you are not going to be affected by it. Don't expect a fancy W - this hotel is older and going through remodel - but do expect excellent service. Some of the nicest people we met in NOLA - a place where everyone is friendly and nice.", |
"date": "2013-12-16 04:30:34 +0300", |
"ratings": { |
"Cleanliness": 3, |
"Location": 5, |
"Overall": 4, |
"Rooms": 3, |
"Service": 5, |
"Sleep Quality": 3, |
"Value": 3 |
}
|
}
|
],
|
[
|
{
|
"author": "Joseph Hackett PhD", |
"content": "We were recently in Seattle for two days and stayed at the Hotel Monaco. We had a basic room with a kingsize bed, and felt the room was sizeable. Loved the crazy print robes! They were a nice touch. Did not adopt a goldfish for our stay, but had a chance to visit with some in the hallway and lobby. Another nice, quirky touch that makes you remember this place. The bedding was some of the most comfortable that we have had. We also enjoyed the wine hour in the lobby, where we got a chance to meet some other people and share travel stories. Aside from a lackluster breakfast at Sazerac where our waiter was one of the worst we have ever had, we would highly recommend this place to travellers.", |
"date": "2013-02-22 08:11:09 +0300", |
"ratings": { |
"Cleanliness": 5, |
"Overall": 5, |
"Rooms": 5, |
"Service": 4, |
"Value": 4 |
}
|
},
|
{
|
"author": "Alexis Schiller", |
"content": "I arrived after nightfall and was greeted by a spectacular view of the Space Needle. Parking was easy. People friendly.", |
"date": "2014-09-09 03:23:36 +0300", |
"ratings": { |
"Cleanliness": 5, |
"Location": 4, |
"Overall": 4, |
"Rooms": 5, |
"Service": 5, |
"Value": 4 |
}
|
},
|
{
|
"author": "Kristoffer Mraz", |
"content": "The Warwick is in an older building but the rooms and public areas are up to snuff. Flat screen TV, good internet (albeit at a charge), a dorm fridge, small bathroom but nicely appointed with good soaps and big towels, nice lounge. Public areas are small, but that is what you get with older structures. Easy to walk to a lot of places. Valet parking is $30/day, but I didn't need a car. This is no more than other downtown hotels where the rooms are much more expensive. Staff was courteous and friendly. I would definitely stay there again.", |
"date": "2015-07-27 21:52:52 +0300", |
"ratings": { |
"Cleanliness": 5, |
"Location": 5, |
"Overall": 4, |
"Rooms": 4, |
"Service": 5, |
"Sleep Quality": 4, |
"Value": 5 |
}
|
},
|
{
|
"author": "Mrs. Harmon Murray", |
"content": "Love the Warwick! Two old friends joined me in Seattle to celebrate the New Year and we chose the Warwick. We were absolutely delighted! The staff is exemplary...Brian, Robert and, yes, even Bill, were so helpful and so very, very patient with a very tired and picky Alaskan guest.This hotel is located three blocks from Macy's; five blocks from Nordstroms...what more could we want? Oh yeah, and right across the street is Ralph's so if you need a latte in the morning or a bottle of wine in the evening you've got it! Perfect. I want to thank the whole Warwick staff for making the start of 2012 so good! I hope to see you again!", |
"date": "2015-12-31 23:09:42 +0300", |
"ratings": { |
"Cleanliness": 5, |
"Location": 5, |
"Overall": 5, |
"Rooms": 4, |
"Service": 5, |
"Sleep Quality": 5, |
"Value": 4 |
}
|
}
|
]
|
],
|
"type": "array" |
},
|
"state": { |
"#docs": 157, |
"%docs": 100, |
"samples": [ |
"Provence-Alpes-Côte d'Azur", |
"California", |
"Île-de-France", |
"Rhône-Alpes" |
],
|
"type": "string" |
},
|
"title": { |
"#docs": 157, |
"%docs": 100, |
"samples": [ |
"London/Hammersmith and Fulham", |
"London/Holborn-Clerkenwell", |
"South Stack", |
"London/Westminster", |
"Wales Coast Path" |
],
|
"type": "string" |
},
|
"tollfree": { |
"#docs": 157, |
"%docs": 100, |
"samples": [ |
"+1-877-496-5599", |
"+1-877-643-3779", |
"+1-800-572-0679" |
],
|
"type": "string" |
},
|
"type": { |
"#docs": 157, |
"%docs": 100, |
"samples": [ |
"landmark", |
"hotel" |
],
|
"type": "string" |
},
|
"url": { |
"#docs": 157, |
"%docs": 100, |
"samples": [ |
"http://www.sadlerswells.com/pa...", |
"http://www.fulhamfc.com/", |
"http://www.rspb.org.uk/reserve...", |
"http://www.star-tavern-belgrav...", |
"http://uk.westfield.com/london..." |
],
|
"type": "string" |
},
|
"vacancy": { |
"#docs": 24, |
"%docs": 15.28, |
"samples": [ |
true, |
false |
],
|
"type": "boolean" |
}
|
}
|
},
|
{
|
"#docs": 768, |
"$schema": "http://json-schema.org/schema#", |
"Flavor": "type = \"route\"", |
"properties": { |
"airline": { |
"#docs": 768, |
"%docs": 100, |
"samples": [ |
"WN", |
"FR", |
"BA", |
"AA", |
"FL" |
],
|
"type": "string" |
},
|
"airlineid": { |
"#docs": 768, |
"%docs": 100, |
"samples": [ |
"airline_4547", |
"airline_4296", |
"airline_1355", |
"airline_24", |
"airline_1316" |
],
|
"type": "string" |
},
|
"destinationairport": { |
"#docs": 768, |
"%docs": 100, |
"samples": [ |
"BWI", |
"RIX", |
"LGW", |
"LHR", |
"KUN" |
],
|
"type": "string" |
},
|
"distance": { |
"#docs": 768, |
"%docs": 100, |
"samples": [ |
1268.992996532523, |
1625.1904262257979, |
1361.490929037204, |
1368.1264206456553, |
1608.5015387952758 |
],
|
"type": "number" |
},
|
"equipment": { |
"#docs": 768, |
"%docs": 100, |
"samples": [ |
"73W 733 73C 738", |
"738", |
"737", |
"319 320", |
"777" |
],
|
"type": "string" |
},
|
"id": { |
"#docs": 768, |
"%docs": 100, |
"samples": [ |
64045, |
27953, |
14853, |
7004, |
27910 |
],
|
"type": "number" |
},
|
"schedule": { |
"#docs": 768, |
"%docs": 100, |
"items": { |
"#schema": "FieldType", |
"subtype": { |
"#docs": 1, |
"$schema": "http://json-schema.org/schema#", |
"Flavor": "day = 6, flight = \"GS047\", utc = \"23:43:00\"", |
"properties": { |
"day": { |
"samples": [ |
6 |
],
|
"type": "number" |
},
|
"flight": { |
"samples": [ |
"GS047" |
],
|
"type": "string" |
},
|
"utc": { |
"samples": [ |
"23:43:00" |
],
|
"type": "string" |
}
|
}
|
},
|
"type": "object" |
},
|
"maxItems": 31, |
"minItems": 10, |
"samples": [ |
[
|
{
|
"day": 0, |
"flight": "WN611", |
"utc": "09:33:00" |
},
|
{
|
"day": 0, |
"flight": "WN393", |
"utc": "10:51:00" |
},
|
{
|
"day": 0, |
"flight": "WN038", |
"utc": "12:06:00" |
},
|
{
|
"day": 0, |
"flight": "WN389", |
"utc": "14:04:00" |
},
|
{
|
"day": 0, |
"flight": "WN480", |
"utc": "19:49:00" |
},
|
{
|
"day": 1, |
"flight": "WN800", |
"utc": "08:24:00" |
},
|
{
|
"day": 1, |
"flight": "WN865", |
"utc": "17:40:00" |
},
|
{
|
"day": 1, |
"flight": "WN450", |
"utc": "16:11:00" |
},
|
{
|
"day": 2, |
"flight": "WN603", |
"utc": "08:20:00" |
},
|
{
|
"day": 2, |
"flight": "WN295", |
"utc": "21:08:00" |
},
|
{
|
"day": 3, |
"flight": "WN063", |
"utc": "07:20:00" |
},
|
{
|
"day": 3, |
"flight": "WN780", |
"utc": "19:01:00" |
},
|
{
|
"day": 3, |
"flight": "WN776", |
"utc": "19:13:00" |
},
|
{
|
"day": 4, |
"flight": "WN576", |
"utc": "23:38:00" |
},
|
{
|
"day": 4, |
"flight": "WN613", |
"utc": "18:27:00" |
},
|
{
|
"day": 5, |
"flight": "WN756", |
"utc": "20:24:00" |
},
|
{
|
"day": 5, |
"flight": "WN657", |
"utc": "01:07:00" |
},
|
{
|
"day": 5, |
"flight": "WN792", |
"utc": "14:16:00" |
},
|
{
|
"day": 5, |
"flight": "WN827", |
"utc": "10:36:00" |
},
|
{
|
"day": 6, |
"flight": "WN242", |
"utc": "16:44:00" |
},
|
{
|
"day": 6, |
"flight": "WN078", |
"utc": "00:26:00" |
},
|
{
|
"day": 6, |
"flight": "WN348", |
"utc": "02:03:00" |
}
|
],
|
[
|
{
|
"day": 0, |
"flight": "FR812", |
"utc": "14:00:00" |
},
|
{
|
"day": 0, |
"flight": "FR920", |
"utc": "07:12:00" |
},
|
{
|
"day": 0, |
"flight": "FR390", |
"utc": "14:13:00" |
},
|
{
|
"day": 1, |
"flight": "FR682", |
"utc": "03:07:00" |
},
|
{
|
"day": 1, |
"flight": "FR434", |
"utc": "23:26:00" |
},
|
{
|
"day": 1, |
"flight": "FR675", |
"utc": "06:54:00" |
},
|
{
|
"day": 1, |
"flight": "FR587", |
"utc": "11:55:00" |
},
|
{
|
"day": 2, |
"flight": "FR225", |
"utc": "16:54:00" |
},
|
{
|
"day": 3, |
"flight": "FR620", |
"utc": "00:38:00" |
},
|
{
|
"day": 3, |
"flight": "FR779", |
"utc": "07:01:00" |
},
|
{
|
"day": 3, |
"flight": "FR952", |
"utc": "00:56:00" |
},
|
{
|
"day": 3, |
"flight": "FR486", |
"utc": "00:42:00" |
},
|
{
|
"day": 3, |
"flight": "FR970", |
"utc": "09:44:00" |
},
|
{
|
"day": 4, |
"flight": "FR814", |
"utc": "13:36:00" |
},
|
{
|
"day": 4, |
"flight": "FR927", |
"utc": "18:34:00" |
},
|
{
|
"day": 4, |
"flight": "FR009", |
"utc": "11:33:00" |
},
|
{
|
"day": 4, |
"flight": "FR548", |
"utc": "21:23:00" |
},
|
{
|
"day": 4, |
"flight": "FR099", |
"utc": "01:13:00" |
},
|
{
|
"day": 5, |
"flight": "FR375", |
"utc": "13:05:00" |
},
|
{
|
"day": 6, |
"flight": "FR639", |
"utc": "11:40:00" |
},
|
{
|
"day": 6, |
"flight": "FR364", |
"utc": "23:11:00" |
},
|
{
|
"day": 6, |
"flight": "FR866", |
"utc": "04:46:00" |
}
|
],
|
[
|
{
|
"day": 0, |
"flight": "BA188", |
"utc": "10:00:00" |
},
|
{
|
"day": 0, |
"flight": "BA255", |
"utc": "23:17:00" |
},
|
{
|
"day": 1, |
"flight": "BA375", |
"utc": "17:19:00" |
},
|
{
|
"day": 1, |
"flight": "BA436", |
"utc": "03:38:00" |
},
|
{
|
"day": 2, |
"flight": "BA027", |
"utc": "04:29:00" |
},
|
{
|
"day": 2, |
"flight": "BA848", |
"utc": "17:38:00" |
},
|
{
|
"day": 2, |
"flight": "BA473", |
"utc": "08:58:00" |
},
|
{
|
"day": 2, |
"flight": "BA339", |
"utc": "22:48:00" |
},
|
{
|
"day": 2, |
"flight": "BA927", |
"utc": "20:54:00" |
},
|
{
|
"day": 3, |
"flight": "BA879", |
"utc": "20:07:00" |
},
|
{
|
"day": 3, |
"flight": "BA480", |
"utc": "12:06:00" |
},
|
{
|
"day": 4, |
"flight": "BA314", |
"utc": "09:28:00" |
},
|
{
|
"day": 4, |
"flight": "BA049", |
"utc": "02:48:00" |
},
|
{
|
"day": 4, |
"flight": "BA605", |
"utc": "21:00:00" |
},
|
{
|
"day": 5, |
"flight": "BA217", |
"utc": "04:59:00" |
},
|
{
|
"day": 5, |
"flight": "BA166", |
"utc": "20:17:00" |
},
|
{
|
"day": 5, |
"flight": "BA503", |
"utc": "13:17:00" |
},
|
{
|
"day": 5, |
"flight": "BA660", |
"utc": "20:53:00" |
},
|
{
|
"day": 5, |
"flight": "BA208", |
"utc": "19:16:00" |
},
|
{
|
"day": 6, |
"flight": "BA539", |
"utc": "15:28:00" |
},
|
{
|
"day": 6, |
"flight": "BA882", |
"utc": "16:20:00" |
},
|
{
|
"day": 6, |
"flight": "BA187", |
"utc": "19:40:00" |
},
|
{
|
"day": 6, |
"flight": "BA526", |
"utc": "07:10:00" |
},
|
{
|
"day": 6, |
"flight": "BA487", |
"utc": "06:36:00" |
}
|
],
|
[
|
{
|
"day": 0, |
"flight": "AA988", |
"utc": "11:50:00" |
},
|
{
|
"day": 0, |
"flight": "AA778", |
"utc": "08:52:00" |
},
|
{
|
"day": 0, |
"flight": "AA124", |
"utc": "21:43:00" |
},
|
{
|
"day": 0, |
"flight": "AA149", |
"utc": "11:51:00" |
},
|
{
|
"day": 0, |
"flight": "AA535", |
"utc": "11:06:00" |
},
|
{
|
"day": 1, |
"flight": "AA816", |
"utc": "22:16:00" |
},
|
{
|
"day": 1, |
"flight": "AA843", |
"utc": "13:20:00" |
},
|
{
|
"day": 2, |
"flight": "AA075", |
"utc": "15:21:00" |
},
|
{
|
"day": 2, |
"flight": "AA158", |
"utc": "03:01:00" |
},
|
{
|
"day": 2, |
"flight": "AA096", |
"utc": "22:13:00" |
},
|
{
|
"day": 2, |
"flight": "AA808", |
"utc": "20:28:00" |
},
|
{
|
"day": 3, |
"flight": "AA023", |
"utc": "08:30:00" |
},
|
{
|
"day": 3, |
"flight": "AA273", |
"utc": "08:39:00" |
},
|
{
|
"day": 3, |
"flight": "AA355", |
"utc": "08:54:00" |
},
|
{
|
"day": 3, |
"flight": "AA372", |
"utc": "09:58:00" |
},
|
{
|
"day": 3, |
"flight": "AA923", |
"utc": "12:31:00" |
},
|
{
|
"day": 4, |
"flight": "AA257", |
"utc": "08:14:00" |
},
|
{
|
"day": 4, |
"flight": "AA960", |
"utc": "12:53:00" |
},
|
{
|
"day": 4, |
"flight": "AA478", |
"utc": "13:31:00" |
},
|
{
|
"day": 4, |
"flight": "AA105", |
"utc": "17:28:00" |
},
|
{
|
"day": 5, |
"flight": "AA626", |
"utc": "20:34:00" |
},
|
{
|
"day": 5, |
"flight": "AA447", |
"utc": "14:40:00" |
},
|
{
|
"day": 5, |
"flight": "AA488", |
"utc": "13:00:00" |
},
|
{
|
"day": 5, |
"flight": "AA299", |
"utc": "23:07:00" |
},
|
{
|
"day": 6, |
"flight": "AA784", |
"utc": "11:12:00" |
},
|
{
|
"day": 6, |
"flight": "AA006", |
"utc": "19:42:00" |
},
|
{
|
"day": 6, |
"flight": "AA235", |
"utc": "03:34:00" |
},
|
{
|
"day": 6, |
"flight": "AA235", |
"utc": "09:41:00" |
}
|
],
|
[
|
{
|
"day": 0, |
"flight": "FR939", |
"utc": "02:47:00" |
},
|
{
|
"day": 0, |
"flight": "FR010", |
"utc": "22:15:00" |
},
|
{
|
"day": 0, |
"flight": "FR284", |
"utc": "22:56:00" |
},
|
{
|
"day": 0, |
"flight": "FR406", |
"utc": "21:13:00" |
},
|
{
|
"day": 0, |
"flight": "FR426", |
"utc": "14:14:00" |
},
|
{
|
"day": 1, |
"flight": "FR356", |
"utc": "16:38:00" |
},
|
{
|
"day": 1, |
"flight": "FR163", |
"utc": "15:15:00" |
},
|
{
|
"day": 2, |
"flight": "FR339", |
"utc": "09:43:00" |
},
|
{
|
"day": 2, |
"flight": "FR670", |
"utc": "15:05:00" |
},
|
{
|
"day": 2, |
"flight": "FR921", |
"utc": "16:44:00" |
},
|
{
|
"day": 2, |
"flight": "FR079", |
"utc": "08:07:00" |
},
|
{
|
"day": 3, |
"flight": "FR596", |
"utc": "21:26:00" |
},
|
{
|
"day": 3, |
"flight": "FR780", |
"utc": "02:33:00" |
},
|
{
|
"day": 3, |
"flight": "FR322", |
"utc": "21:34:00" |
},
|
{
|
"day": 4, |
"flight": "FR936", |
"utc": "22:58:00" |
},
|
{
|
"day": 4, |
"flight": "FR843", |
"utc": "12:33:00" |
},
|
{
|
"day": 5, |
"flight": "FR479", |
"utc": "18:31:00" |
},
|
{
|
"day": 5, |
"flight": "FR711", |
"utc": "12:58:00" |
},
|
{
|
"day": 5, |
"flight": "FR920", |
"utc": "09:26:00" |
},
|
{
|
"day": 5, |
"flight": "FR596", |
"utc": "23:02:00" |
},
|
{
|
"day": 6, |
"flight": "FR178", |
"utc": "11:37:00" |
},
|
{
|
"day": 6, |
"flight": "FR155", |
"utc": "07:47:00" |
},
|
{
|
"day": 6, |
"flight": "FR809", |
"utc": "01:32:00" |
},
|
{
|
"day": 6, |
"flight": "FR998", |
"utc": "22:02:00" |
},
|
{
|
"day": 6, |
"flight": "FR366", |
"utc": "01:09:00" |
}
|
]
|
],
|
"type": "array" |
},
|
"sourceairport": { |
"#docs": 768, |
"%docs": 100, |
"samples": [ |
"MCO", |
"STN", |
"OLB", |
"ZAG", |
"SAN" |
],
|
"type": "string" |
},
|
"stops": { |
"#docs": 768, |
"%docs": 100, |
"samples": [ |
0, |
1 |
],
|
"type": "number" |
},
|
"type": { |
"#docs": 768, |
"%docs": 100, |
"samples": [ |
"route" |
],
|
"type": "string" |
}
|
}
|
},
|
{
|
"#docs": 64, |
"$schema": "http://json-schema.org/schema#", |
"Flavor": "type = \"airport\"", |
"properties": { |
"airportname": { |
"#docs": 64, |
"%docs": 100, |
"samples": [ |
"Portland Hillsboro", |
"Blakely Island Airport", |
"Bourscheid", |
"Valdosta Regional Airport", |
"Sebastian Municipal" |
],
|
"type": "string" |
},
|
"city": { |
"#docs": 64, |
"%docs": 100, |
"samples": [ |
"Hillsboro", |
"Blakely Island", |
"Phalsbourg", |
"Valdosta", |
"Sebastian" |
],
|
"type": "string" |
},
|
"country": { |
"#docs": 64, |
"%docs": 100, |
"samples": [ |
"United States", |
"France", |
"United Kingdom" |
],
|
"type": "string" |
},
|
"faa": { |
"#docs": 64, |
"%docs": 100, |
"samples": [ |
"HIO", |
"BYW", |
"VLD", |
"X26" |
],
|
"type": "string" |
},
|
"geo": { |
"#docs": 64, |
"%docs": 100, |
"properties": { |
"alt": { |
"#docs": 64, |
"%docs": 100, |
"samples": [ |
204, |
0, |
1017, |
203, |
21 |
],
|
"type": "number" |
},
|
"lat": { |
"#docs": 64, |
"%docs": 100, |
"samples": [ |
45.540394, |
48.56025, |
48.76625, |
30.7825, |
27.81325 |
],
|
"type": "number" |
},
|
"lon": { |
"#docs": 64, |
"%docs": 100, |
"samples": [ |
-122.949825, |
-122.80243, |
7.200519, |
-83.2767, |
-80.4955833 |
],
|
"type": "number" |
}
|
},
|
"samples": [ |
{
|
"alt": 204, |
"lat": 45.540394, |
"lon": -122.949825 |
},
|
{
|
"alt": 0, |
"lat": 48.56025, |
"lon": -122.80243 |
},
|
{
|
"alt": 1017, |
"lat": 48.76625, |
"lon": 7.200519 |
},
|
{
|
"alt": 203, |
"lat": 30.7825, |
"lon": -83.2767 |
},
|
{
|
"alt": 21, |
"lat": 27.81325, |
"lon": -80.4955833 |
}
|
],
|
"type": "object" |
},
|
"icao": { |
"#docs": 64, |
"%docs": 100, |
"samples": [ |
"KHIO", |
"LFQP", |
"KVLD", |
"KPAE" |
],
|
"type": "string" |
},
|
"id": { |
"#docs": 64, |
"%docs": 100, |
"samples": [ |
8122, |
8171, |
1398, |
5776, |
9200 |
],
|
"type": "number" |
},
|
"type": { |
"#docs": 64, |
"%docs": 100, |
"samples": [ |
"airport" |
],
|
"type": "string" |
},
|
"tz": { |
"#docs": 64, |
"%docs": 100, |
"samples": [ |
"America/Los_Angeles", |
"Europe/Paris", |
"America/New_York", |
"Europe/London", |
"America/Chicago" |
],
|
"type": "string" |
}
|
}
|
}
|
]
|
]
|
Attachments
Issue Links
- relates to
-
MB-18221 [FTS] Create Travel Sample Demo Database for FTS
-
- Closed
-