{"id":31,"date":"2009-05-21T23:43:25","date_gmt":"2009-05-21T23:43:25","guid":{"rendered":"http:\/\/paulmaiorana.com\/notes\/?p=31"},"modified":"2018-01-02T17:10:48","modified_gmt":"2018-01-02T17:10:48","slug":"average-airline-departure-delays","status":"publish","type":"post","link":"https:\/\/paulmaiorana.com\/notes\/2009\/05\/average-airline-departure-delays\/","title":{"rendered":"Average Airline Departure Delays"},"content":{"rendered":"<p>Like any good nerd, I was excited about today&#8217;s <a href=\"http:\/\/www.data.gov\">Data.gov<\/a> announcement, so I put together this infographic (using Google&#8217;s fancy <a href=\"http:\/\/code.google.com\/apis\/visualization\/documentation\/gallery\/motionchart.html\">MotionChart API<\/a>) which charts <a href=\"http:\/\/www.data.gov\/details\/123\">the yearly average departure times for major domestic air carriers<\/a>.<\/p>\n<p>The chart isn&#8217;t terribly interesting; this was more of a mental exercise than an attempt to do anything useful with the data.<\/p>\n<p>There is one notable data point in the chart though, and that&#8217;s JetBlue circa 2007\u2014their average departure time spikes as a result of the infamous <a href=\"http:\/\/www.nytimes.com\/2007\/02\/19\/business\/19jetblue.html?_r=1\">Valentines Day<\/a> screwup. Having myself spent 9 hours (and my first wedding anniversary) on the tarmac at JFK during that fiasco, I was curious to see how that would be reflected in the data.<\/p>\n<p><script type=\"text\/javascript\" src=\"http:\/\/www.google.com\/jsapi\"><\/script><script type=\"text\/javascript\">\/\/ <![CDATA[\n google.load('visualization', '1', {packages: ['motionchart']}); \n\/\/ ]]><\/script><script type=\"text\/javascript\">\/\/ <![CDATA[\n var visualization; function drawVisualization() { var query = new google.visualization.Query( 'http:\/\/spreadsheets.google.com\/tq?key=rDWPxAeRuSJk3K9QtDTUv8w&#038;hl=en'); query.send(handleQueryResponse); } function handleQueryResponse(response) { if (response.isError()) { return; } var data = response.getDataTable(); var motionchart = new google.visualization.MotionChart( document.getElementById('domestic-airline-visualization')); var options = {}; options['state'] = '{\"xZoomedIn\":false,\"orderedByY\":false,\"xZoomedDataMax\":24,\"sizeOption\":\"_UNISIZE\",\"dimensions\":{\"iconDimensions\":[\"dim0\"]},\"orderedByX\":false,\"yZoomedDataMin\":-1.3977,\"yZoomedIn\":false,\"yLambda\":1,\"time\":\"1999\",\"duration\":{\"multiplier\":1,\"timeUnit\":\"Y\"},\"xLambda\":1,\"stateVersion\":3,\"yAxisOption\":\"2\",\"showTrails\":true,\"iconKeySettings\":[],\"iconType\":\"BUBBLE\",\"yZoomedDataMax\":20.2209,\"xAxisOption\":\"_ALPHABETICAL\",\"playDuration\":40,\"nonSelectedAlpha\":0.4,\"colorOption\":\"2\",\"xZoomedDataMin\":0};'; options['width'] = 550; options['height'] = 400; options['showSidePanel'] = false; options['showAdvancedPanel'] = false; options['showYScalePicker'] = false; options['showXScalePicker'] = false; motionchart.draw(data, options); } google.setOnLoadCallback(drawVisualization); \n\/\/ ]]><\/script><\/p>\n<div id=\"domestic-airline-visualization\" style=\"height: 400px; width: 400px;\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Like any good nerd, I was excited about today&#8217;s Data.gov announcement, so I put together this infographic (using Google&#8217;s fancy MotionChart API) which charts the yearly average departure times for major domestic air carriers. The chart isn&#8217;t terribly interesting; this was more of a mental exercise than an attempt to do anything useful with the [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[1],"tags":[10,28,29,47,54,174],"class_list":["post-31","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-apis","tag-data","tag-data-gov","tag-google","tag-infographics","tag-projects"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p1G65p-v","jetpack_sharing_enabled":true,"jetpack_likes_enabled":false,"_links":{"self":[{"href":"https:\/\/paulmaiorana.com\/notes\/wp-json\/wp\/v2\/posts\/31","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/paulmaiorana.com\/notes\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/paulmaiorana.com\/notes\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/paulmaiorana.com\/notes\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/paulmaiorana.com\/notes\/wp-json\/wp\/v2\/comments?post=31"}],"version-history":[{"count":1,"href":"https:\/\/paulmaiorana.com\/notes\/wp-json\/wp\/v2\/posts\/31\/revisions"}],"predecessor-version":[{"id":860,"href":"https:\/\/paulmaiorana.com\/notes\/wp-json\/wp\/v2\/posts\/31\/revisions\/860"}],"wp:attachment":[{"href":"https:\/\/paulmaiorana.com\/notes\/wp-json\/wp\/v2\/media?parent=31"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/paulmaiorana.com\/notes\/wp-json\/wp\/v2\/categories?post=31"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/paulmaiorana.com\/notes\/wp-json\/wp\/v2\/tags?post=31"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}