To download the data set, please sign up or log in

LuggageHero

LuggageHero

Tables

Column Descriptions

Table, Wonderful Copenhagen Hackaton Bookings Retailers Reviews Csv Csv

Column Type Comment
booking_id int Data source did not contain a description for booking_id. Column booking_id has 3695 rows, out of which 31 are empty, making the null percent 0.84. Minimum value is 9 and maximum value is 1973.
retailer_id int Data source did not contain a description for retailer_id. Column retailer_id has 3695 rows, out of which 31 are empty, making the null percent 0.84. Minimum value is 2 and maximum value is 143.
booking_phone int Data source did not contain a description for booking_phone. Column booking_phone has 3695 rows, out of which 3302 are empty, making the null percent 89.36. Minimum value is -517382385 and maximum value is 2118415684.
expectedstart string Data source did not contain a description for expectedstart. Column expectedstart has 3695 rows, out of which 29 are empty, making the null percent 0.78. Minimum string is and maximum string is 2017-04-12T09:30.
expectedend string Data source did not contain a description for expectedend. Column expectedend has 3695 rows, out of which 29 are empty, making the null percent 0.78. Minimum string is and maximum string is 2017-04-12T13:00.
actualstart string Data source did not contain a description for actualstart. Column actualstart has 3695 rows, out of which 29 are empty, making the null percent 0.78. Minimum string is and maximum string is 2017-04-12T09:57:57+01:00.
actualend string Data source did not contain a description for actualend. Column actualend has 3695 rows, out of which 31 are empty, making the null percent 0.84. Minimum string is and maximum string is 2017-04-12T19:07:00+01:00.
timespentinhours int Data source did not contain a description for timespentinhours. Column timespentinhours has 3695 rows, out of which 397 are empty, making the null percent 10.74. Minimum value is 1 and maximum value is 716.
luggagesmall int Data source did not contain a description for luggagesmall. Column luggagesmall has 3695 rows, out of which 31 are empty, making the null percent 0.84. Minimum value is 0 and maximum value is 17.
luggagemedium int Data source did not contain a description for luggagemedium. Column luggagemedium has 3695 rows, out of which 31 are empty, making the null percent 0.84. Minimum value is 0 and maximum value is 11.
luggageodd int Data source did not contain a description for luggageodd. Column luggageodd has 3695 rows, out of which 31 are empty, making the null percent 0.84. Minimum value is 0 and maximum value is 2.
booking_state int Data source did not contain a description for booking_state. Column booking_state has 3695 rows, out of which 31 are empty, making the null percent 0.84. Minimum value is 1 and maximum value is 4.
subscriptionid int Data source did not contain a description for subscriptionid. Column subscriptionid has 3695 rows, out of which 31 are empty, making the null percent 0.84. Minimum value is 3345600 and maximum value is 5881539.
transactionid int Data source did not contain a description for transactionid. Column transactionid has 3695 rows, out of which 397 are empty, making the null percent 10.74. Minimum value is 0 and maximum value is 102284301.
orderid string Data source did not contain a description for orderid. Column orderid has 3695 rows, out of which 31 are empty, making the null percent 0.84. Minimum string is and maximum string is h3pd12042017094036.
idtoken string Data source did not contain a description for idtoken. Column idtoken has 3695 rows, out of which 31 are empty, making the null percent 0.84. First 25 characters of minimum string: ... and first 25 characters of maximum string: f4a9fbaca79c16c583a7c5c47...
voucher string Data source did not contain a description for voucher. Column voucher has 3695 rows, out of which 31 are empty, making the null percent 0.84. Minimum string is and maximum string is NULL.
retailer_name string Data source did not contain a description for retailer_name. Column retailer_name has 3695 rows, out of which 31 are empty, making the null percent 0.84. Minimum string is and maximum string is Mail Boxes etc. Camden.
capacitysmall int Data source did not contain a description for capacitysmall. Column capacitysmall has 3695 rows, out of which 31 are empty, making the null percent 0.84. Minimum value is 0 and maximum value is 741.
capacitymedium int Data source did not contain a description for capacitymedium. Column capacitymedium has 3695 rows, out of which 31 are empty, making the null percent 0.84. Minimum value is 0 and maximum value is 100.
capacityodd int Data source did not contain a description for capacityodd. Column capacityodd has 3695 rows, out of which 31 are empty, making the null percent 0.84. Minimum value is 0 and maximum value is 100.
retailer_phone string Data source did not contain a description for retailer_phone. Column retailer_phone has 3695 rows, out of which 31 are empty, making the null percent 0.84. Minimum string is and maximum string is +44 979602864.
url string Data source did not contain a description for url. Column url has 3695 rows, out of which 31 are empty, making the null percent 0.84. The single string value is: .
address string Data source did not contain a description for address. Column address has 3695 rows, out of which 31 are empty, making the null percent 0.84. First 25 characters of minimum string: ... and first 25 characters of maximum string: 33 Parkway, London NW1, S...
postcode string Data source did not contain a description for postcode. Column postcode has 3695 rows, out of which 31 are empty, making the null percent 0.84. The single string value is: .
city string Data source did not contain a description for city. Column city has 3695 rows, out of which 31 are empty, making the null percent 0.84. The single string value is: .
positionlat string Data source did not contain a description for positionlat. Column positionlat has 3695 rows, out of which 31 are empty, making the null percent 0.84. Minimum string is and maximum string is 89764.34.00.
positionlng float Data source did not contain a description for positionlng. Column positionlng has 3695 rows, out of which 705 are empty, making the null percent 19.08. Minimum value is 0.34 and maximum value is 23.49.
utc_offset int Data source did not contain a description for utc_offset. Column utc_offset has 3695 rows, out of which 31 are empty, making the null percent 0.84. Minimum value is 0 and maximum value is 600.
timezonekey string Data source did not contain a description for timezonekey. Column timezonekey has 3695 rows, out of which 31 are empty, making the null percent 0.84. Minimum string is and maximum string is Europe/London.
phone_in_booking_confirmation int Data source did not contain a description for phone_in_booking_confirmation. Column phone_in_booking_confirmation has 3695 rows, out of which 1990 are empty, making the null percent 53.86. Minimum value is 0 and maximum value is 1.
phone_on_profile int Data source did not contain a description for phone_on_profile. Column phone_on_profile has 3695 rows, out of which 1990 are empty, making the null percent 53.86. Minimum value is 0 and maximum value is 1.
rating string Data source did not contain a description for rating. Column rating has 3695 rows, out of which 31 are empty, making the null percent 0.84. Minimum string is and maximum string is NULL.
headline string Data source did not contain a description for headline. Column headline has 3695 rows, out of which 31 are empty, making the null percent 0.84. Minimum string is and maximum string is NULL.
review_location string Data source did not contain a description for review_location. Column review_location has 3695 rows, out of which 45 are empty, making the null percent 1.22. Minimum string is and maximum string is NULL.
review_experience string Data source did not contain a description for review_experience. Column review_experience has 3695 rows, out of which 46 are empty, making the null percent 1.24. Minimum string is and maximum string is NULL.
suggestions string Data source did not contain a description for suggestions. Column suggestions has 3695 rows, out of which 50 are empty, making the null percent 1.35. Minimum string is and maximum string is NULL.
user_facebook_id string Data source did not contain a description for user_facebook_id. Column user_facebook_id has 3695 rows, out of which 50 are empty, making the null percent 1.35. Minimum string is and maximum string is NULL.
user_picture_url string Data source did not contain a description for user_picture_url. Column user_picture_url has 3695 rows, out of which 50 are empty, making the null percent 1.35. Minimum string is and maximum string is NULL.
notified int Data source did not contain a description for notified. Column notified has 3695 rows, out of which 531 are empty, making the null percent 14.37. Constant value is 1.
created string Data source did not contain a description for created. Column created has 3695 rows, out of which 50 are empty, making the null percent 1.35. Minimum string is and maximum string is 2017-04-13 20:00:16.167.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated April 12, 2019
Created February 7, 2019