Skip to content

Latest commit

 

History

History

data

About datasets

gzip -dc airlines.json.gz | \
jq -c '.[] | {
  airport: .airport.code,
  carrier: .carrier.code,
  total_flights: .statistics.flights.total,
  cancelled: .statistics.flights.cancelled,
  delayed: .statistics.flights.delayed,
  min_delayed_aircraft: .statistics."minutes delayed"."late aircraft",
  min_delayed_weather: .statistics."minutes delayed".weather,
  min_delayed_security: .statistics."minutes delayed".security,
  min_delayed_carrier: .statistics."minutes delayed".carrier,
  year: .time.year,
  month: .time.month
}' | gzip -9 > airlines-delayed.json.gz