On ttime performance

on_time_performance.sql

CREATE TABLE airline.on_time_performance (
    id integer NOT NULL,
    "Year" integer,
    "Quarter" integer,
    "Month" integer,
    "DayofMonth" integer,
    "DayOfWeek" integer,
    "FlightDate" integer,
    "UniqueCarrier" integer,
    "AirlineID" integer,
    "Carrier" integer,  
    "TailNum" integer,
    "FlightNum" integer,
    "OriginAirportID" integer,
    "OriginAirportSeqID" integer,   
    "OriginCityMarketID" integer,
    "Origin" text,
    "OriginCityName" text,
    "OriginState" text,
    "OriginStateFips" integer,
    "OriginStateName" text,
    "OriginWac" integer,
    "DestAirportID" integer,
    "DestAirportSeqID" integer,
    "DestCityMarketID" integer,
    "Dest" text,
    "DestCityName" text,
    "DestState" text,
    "DestStateFips" integer,
    "DestStateName" text,
    "DestWac" integer,
    "CRSDepTime" integer,
    "DepTime" integer,
    "DepDelay" integer,
    "DepDelayMinutes" integer,
    "DepDel15" integer,
    "DepartureDelayGroups" integer,
    "DepTimeBlk" integer,
    "TaxiOut" integer,
    "WheelsOff" integer,
    "WheelsOn" integer,
    "TaxiIn" integer,
    "CRSArrTime" integer,
    "ArrTime" integer,
    "ArrDelay" integer,
    "ArrDelayMinutes" integer,
    "ArrDel15" integer,
    "ArrivalDelayGroups" integer,
    "ArrTimeBlk" integer,
    "Cancelled" integer,
    "CancellationCode" integer,
    "Diverted" integer,
    "CRSElapsedTime" integer,
    "ActualElapsedTime" integer,
    "AirTime" integer,
    "Flights" integer,
    "Distance" integer,
    "DistanceGroup" integer,
    "CarrierDelay" integer,
    "WeatherDelay" integer,
    "NASDelay" integer,
    "SecurityDelay" integer,
    "LateAircraftDelay" integer,
    "FirstDepTime" integer,
    "TotalAddGTime" integer,
    "LongestAddGTime" integer,
    "DivAirportLandings" integer,
    "DivReachedDest" integer,
    "DivActualElapsedTime" integer,
    "DivArrDelay" integer,
    "DivDistance" integer,
    "Div1Airport" integer,
    "Div1AirportID" integer,
    "iv1AirportSeqID" integer,
    "Div1WheelsOn" integer,
    "Div1TotalGTime" integer,
    "Div1LongestGTime" integer,
    "Div1WheelsOff" integer,
    "Div1TailNum" integer,
    "Div2Airport" integer,
    "Div2AirportID" integer,
    "Div2AirportSeqID" integer,
    "Div2WheelsOn" integer,
    "Div2TotalGTime" integer,
    "Div2LongestGTime" integer,
    "Div2WheelsOff" integer,
    "Div2TailNum" integer,
    "Div3Airport" integer,
    "Div3AirportID" integer,
    "Div3AirportSeqID" integer,
    "Div3WheelsOn" integer,
    "Div3TotalGTime" integer,
    "Div3LongestGTime" integer,
    "Div3WheelsOff" integer,
    "Div3TailNum" integer,
    "Div4Airport" integer,
    "Div4AirportID" integer,
    "Div4AirportSeqID" integer,
    "Div4WheelsOn" integer,
    "Div4TotalGTime" integer,
    "Div4LongestGTime" integer,
    "Div4WheelsOff" integer,
    "Div4TailNum" integer,
    "Div5Airport" integer,
    "Div5AirportID" integer,
    "Div5AirportSeqID" integer,
    "Div5WheelsOn" integer,
    "Div5TotalGTime" integer,
    "Div5LongestGTime" integer,
    "Div5WheelsOff" integer,
    "Div5TailNum" integer
);