Overview

Gets car rental data 2 weeks out for top 10 most populated cities in US

Metadata

Frequency (UTC) Source Dataset ID Cron
At 07:00 AM https://www.kayak.com/ travel 0 7 * * *

Dependency Policy

Data Dictionary

Column Name Description Type Mode
startDate Date of the start of the rental string REQUIRED
endDate Date of the end of the rental string REQUIRED
city City of the rental string REQUIRED
state State of the rental string REQUIRED
code Kayak location code for the city string REQUIRED
category Category of car assigned by Kayak (e.g. Small, Large, etc.) string REQUIRED
resultID Unique ID for the result string REQUIRED
price Price of the rental number NULLABLE
currency Currency of the price string NULLABLE
isP2P Is the rental P2P boolean NULLABLE
isDelivered Is the rental delivered boolean NULLABLE
hasIncludedDriver Does the rental include a driver boolean NULLABLE
carType Type of car (e.g. Sedan, SUV, etc.) string NULLABLE
originalPrice Original price of the rental number NULLABLE
discount Discount on the rental number NULLABLE
agency Agency providing the rental string NULLABLE
brand Brand of the car string NULLABLE

Assumptions