SQLite format 3@ * *-% |  ! pPPIC#%indextaggings_idxtaggingsCREATE UNIQUE INDEX "taggings_idx" ON "taggings" ("tag_id", "taggable_id", "taggable_type", "context", "tagger_id", "tagger_type")YtabletaggingstaggingsCREATE TABLE "taggings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "tag_id" integer, "taggable_id" integer, "taggable_type" varchar, "tagger_id" integer, "tagger_type" varchar, "context" varchar(128), "created_at" datetime)p?indexindex_snippets_on_user_idsnippetsCREATE INDEX "index_snippets_on_user_id" ON "snippets" ("user_id")YtablesnippetssnippetsCREATE TABLE "snippets" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "content" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "user_id" integer)yEindexindex_sessions_on_updated_atsessionsCREATE INDEX "index_sessions_on_updated_at" ON "sessions" ("updated_at")yEindexindex_sessions_on_session_idsessionsCREATE INDEX "index_sessions_on_session_id" ON "sessions" ("session_id")@StablesessionssessionsCREATE TABLE "sessions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "session_id" varchar NOT NULL, "data" text, "created_at" datetime, "updated_at" datetime) K+)indexindex_schema_comments_on_schemaschema_commentsCREATE INDEX "index_schema_comments_on_schema" ON "schema_comments" ("schema")g ++tableschema_commentsschema_commentsCREATE TABLE "schema_comments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "target_type" varchar, "schema" varchar, "table" varchar, "column" varchar, "text" text, "user_id" integer) O1indexindex_results_on_query_version_idresults CREATE INDEX "index_results_on_query_version_id" ON "results" ("query_version_id") {tableresultsresults CREATE TABLE "results" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime, "updated_at" datetime, "status" varchar, "error_message" text, "query_version_id" integer, "sample_data" text, "row_count" integer, "parameters" text, "headers" text, "compiled_body" text, "started_at" datetime, "deleted_at" datetime, "owner_id" integer, "completed_at" datetime) K))indexindex_query_versions_on_user_idquery_versions CREATE INDEX "index_query_versions_on_user_id" ON "query_versions" ("user_id"). e)[indexindex_query_versions_on_query_id_and_versionquery_versions CREATE INDEX "index_query_versions_on_query_id_and_version" ON "query_versions" ("query_id", "version")q))tablequery_versionsquery_versions CREATE TABLE "query_versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "query_id" integer, "version" integer, "created_at" datetime, "updated_at" datetime, "blob_sha" varchar(40), "parameters" text, "comment" text, "deleted_at" datetime, "body" text, "commit_sha" varchar(40), "tree_sha" varchar(40), "user_id" integer)G#!indexindex_query_roles_on_query_idquery_rolesCREATE INDEX "index_query_roles_on_query_id" ON "query_roles" ("query_id")##mtablequery_rolesquery_rolesCREATE TABLE "query_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "query_id" integer, "role" varchar)MqtablequeriesqueriesCREATE TABLE "queries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "created_at" datetime, "updated_at" datetime, "latest_body" text, "deleted_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)7ItablealertsalertsCREATE TABLE "alerts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "status" varchar, "comparator" varchar, "target" integer, "query_id" integer, "email" varchar, "error_message" text, "last_alert_result_id" integer, "created_at" datetime, "updated_at" datetime, "description" text)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")l//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT  )20140710204753 ) 20140710204753   kky sessions +schema_comments) visualizations# query_roles) query_versions  versions  queries  results sessions users n[AA#Avg Carrier + Aircraft Delay By Airline2016-05-27 22:19:10.1868712016-05-27 22:19:10.200281SELECT SPLIT_PART(al.description, ':', 1) airline, SPLIT_PART(al.description, ':', 2) code, avg(fi.carrier_delay + fi.late_aircraft_delay) delay FROM warehouse.flight_info fi JOIN warehouse.airlines al ON fi.airline_id = al.id GROUP by 1, 2 ORDER by 3 {SORT}   admin  }} AAq# 2016-05-27 22:19:10.1950522016-05-27 22:19:10.195052[{"name":"SORT","type":"string","default":"DESC"}]SELECT SPLIT_PART(al.description, ':', 1) airline, SPLIT_PART(al.description, ':', 2) code, avg(fi.carrier_delay + fi.late_aircraft_delay) delay FROM warehouse.flight_info fi JOIN warehouse.airlines al ON fi.airline_id = al.id GROUP by 1, 2 ORDER by 3 {SORT}    %AA A!A A2016-05-27 22:18:12.0413392016-05-27 22:19:10.196161complete[["SkyWest Airlines Inc."," OO","51.3107695546899674"],["Frontier Airlines Inc."," F9","48.6472392638036810"],["ExpressJet Airlines Inc."," EV","48.1855686274509804"],["JetBlue Airways"," B6","44.8663496228271564"],["United Air Lines Inc."," UA","42.7837013103572070"],["Delta Air Lines Inc."," DL","42.5245830625947585"],["American Airlines Inc."," AA","41.0146255223400836"],["Southwest Airlines Co."," WN","37.5500957243139757"],["Spirit Air Lines"," NK","37.1137071651090343"],["Virgin America"," VX","34.8846473029045643"],["Hawaiian Airlines Inc."," HA","34.0019607843137255"],["Alaska Airlines Inc."," AS","31.0018126888217523"]] {}["airline","code","delay"]SELECT SPLIT_PART(al.description, ':', 1) airline, SPLIT_PART(al.description, ':', 2) code, avg(fi.carrier_delay + fi.late_aircraft_delay) delay FROM warehouse.flight_info fi JOIN warehouse.airlines al ON fi.airline_id = al.id GROUP by 1, 2 ORDER by 3 DESC;2016-05-27 22:18:15.0444202016-05-27 22:18:16.377690   s+/Z ^ H } I  o R#3K int4warehouseflight_infolate_aircraft_delayLate Aircraft Delay, in MinutesH#)A int4warehouseflight_infosecurity_delaySecurity Delay, in MinutesF#'? int4warehouseflight_infoweather_delayWeather Delay, in MinutesF#'? int4warehouseflight_infocarrier_delayCarrier Delay, in MinutesN#W int4warehouseflight_infonas_delayNational Air System Delay, in MinutesU#3Q int4warehouseflight_infoactual_elapsed_timeElapsed Time of Flight, in Minutes  #/= int4warehouseflight_infoarr_delay_minutesDifference in minutes between scheduled and actual arrival time. Early arrivals set to 0N#Y int4warehouseflight_infoarr_timeActual Arrival Time (local time: hhmm) #/E int4warehouseflight_infodep_delay_minutesDifference in minutes between scheduled and actual departure time. Early departures set to 0P#] int4warehouseflight_infodep_timeActual Departure Time (local time: hhmm)K #+E int4warehouseflight_infodest_airport_idJoin with warehouse.airportsI #O int4warehouseflight_infodistanceDistance between airports (miles)< #5 int4warehouseflight_infodiverted0 or 1 boolean field= #5 int4warehouseflight_infocancelled0 or 1 boolean fieldM #/E int4warehouseflight_infoorigin_airport_idJoin with warehouse.airports#E int4warehouseflig)! int4warehouseairlinesidJoin field7#!' int4warehouseflight_infoflight_numFlight Number)! int4warehouseairportsidJoin field+! int4warehouseairlinesidJoin field@#7 varcharwarehouseairlinesdescriptionAirline name and codeF#!E int4warehouseflight_infoairline_idJoin with warehouse.airlinesE##; varcharwarehouseflight_infoflight_dateFlight Date as a stringD#? varcharwarehouseairportsdescriptionAirport name and location ugYK=/! warehouse warehouse warehouse warehouse warehouse warehouse warehouse warehouse warehouse warehouse warehouse warehouse warehouse warehouse warehouse warehouse warehouse warehouse warehouse warehouse warehouse  warehouse /e/MAAe69991694e4a92f0cdaeb0cdb0075efdBAh7BkkiGXdhcmRlbi51c2VyLnVzZXIua2V5BjoGRVRbB1sGaQZJIgAGOwBU 2016-05-28 00:08:20.9134032016-05-28 00:08:20.913403MAAf2c17035395dde8b57a47811f82b0849BAh7BkkiGXdhcmRlbi51c2VyLnVzZXIua2V5BjoGRVRbB1sGaQZJIgAGOwBU 2016-05-28 00:08:20.7896472016-05-28 00:08:20.789647MAA7d578194cdac37860c61936cc9e74916BAh7BkkiGXdhcmRlbi51c2VyLnVzZXIua2V5BjoGRVRbB1sGaQZJIgAGOwBU 2016-05-27 22:17:00.4548862016-05-27 22:17:00.454886 $Me69991694e4a92f0cdaeb0cdb0075efd$Mf2c17035395dde8b57a47811f82b0849#M 7d578194cdac37860c61936cc9e74916 A2016-05-28 00:08:20.913403A2016-05-28 00:08:20.789647A 2016-05-27 22:17:00.454886      PPH : / kPIC#%indextaggings_idxtaggingsCREATE UNIQUE INDEX "taggings_idx" ON "taggings" ("tag_id#%indextaggings_idxtaggingsCREATE UNIQUE INDEX "taggings_idx" ON "taggings" ("tag_id", "taggable_id", "taggable_type", "context", "tagger_id", "tagger_type")YtabletaggingstaggingsCREATE TABLE "taggings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "tag_id" integer, "taggable_id" integer, "taggable_type" varchar, "tagger_id" integer, "tagger_type" varchar, "context" varchar(128), "created_at" datetime)p?indexindex_snippets_on_user_idsnippetsCREATE INDEX "index_snippets_on_user_id" ON "snippets" ("user_id")YtablesnippetssnippetsCREATE TABLE "snippets" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "content" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "user_id" integer)yEindexindex_sessions_on_updated_atsessionsCREATE INDEX "index_sessions_on_updated_at" ON "sessions" ("updated_at")yEindexindex_sessions_on_session_idsessionsCREATE INDEX "index_sessions_on_session_id" ON "sessions" ("session_id")@StablesessionssessionsCREATE TABLE "sessions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "session_id" varchar NOT NULL, "data" text, "created_at" datetime, "updated_at" datetime) K+)indexindex_schema_comments_on_schemaschema_commentsCREATE INDEX "index_schema_comments_on_schema" ON "schema_comments" ("schema")g ++tableschema_commentsschema_commentsCREATE TABLE "schema_comments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "target_type" varchar, "schema" varchar, "table" varchar, "column" varchar, "text" text, "user_id" integer) O1indexindex_results_on_query_version_idresults CREATE INDEX "index_results_on_query_version_id" ON "results" ("query_version_id")l//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")7ItablealertsalertsCREATE TABLE "alerts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "status" varchar, "comparator" varchar, "target" integer, "query_id" integer, "email" varchar, "error_message" text, "last_alert_result_id" integer, "created_at" datetime, "updated_at" datetime, "description" text)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)MqtablequeriesqueriesCREATE TABLE "queries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "created_at" datetime, "updated_at" datetime, "latest_body" text, "deleted_at" datetime)##mtablequery_rolesquery_rolesCREATE TABLE "query_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "query_id" integer, "role" varchar)G#!indexindex_query_roles_on_query_idquery_rolesCREATE INDEX "index_query_roles_on_query_id" ON "query_roles" ("query_id")q))tablequery_versionsquery_versions CREATE TABLE "query_versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "query_id" integer, "version" integer, "created_at" datetime, "updated_at" datetime, "blob_sha" varchar(40), "parameters" text, "comment" text, "deleted_at" datetime, "body" text, "commit_sha" varchar(40), "tree_sha" varchar(40), "user_id" integer). e)[indexindex_query_versions_on_query_id_and_versionquery_versions CREATE INDEX "index_query_versions_on_query_id_and_version" ON "query_versions" ("query_id", "version") K))indexindex_query_versions_on_user_idquery_versions CREATE INDEX "index_query_versions_on_user_id" ON "query_versions" ("user_id") {tableresultsresults CREATE TABLE "results" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime, "updated_at" datetime, "status" varchar, "error_message" text, "query_version_id" integer, "sample_data" text, "row_count" integer, "parameters" text, "headers" text, "compiled_body" text, "started_at" datetime, "deleted_at" datetime, "owner_id" integer, "completed_at" datetime) u u 8 . |(=#])Mindexindex_visualizations_on_query_version_idvisualizations CREATE INDEX "index_visualizations_on_query_version_id" ON "visualizations" ("query_version_id")9))-tablevisualizationsvisualizationsCREATE TABLE "visualizations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "query_version_id" integer, "html_source" text, "title" varchar)[Gindexindex_versions_on_item_type_and_item_idversionsCREATE INDEX "index_versions_on_item_type_and_item_id" ON "versions" ("item_type", "item_id")u=tableversionsversionsCREATE TABLE "versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "item_type" varchar NOT NULL, "item_id" integer NOT NULL, "event" varchar NOT NULL, "whodunnit" varchar, "object" text, "created_at" datetime)tGtableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "email" varchar DEFAULT '' NOT NULL, "encrypted_password" varchar DEFAULT '' NOT NULL, "remember_created_at" datetime, "role" varchar)^1indexindex_tags_on_nametagsCREATE UNIQUE INDEX "index_tags_on_name" ON "tags" ("name")tabletagstagsCREATE TABLE "tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "taggings_count" integer DEFAULT 0) O1indexindex_results_on_query_version_idresults CREATE INDEX "index_results_on_query_version_id" ON "results" ("query_version_id")g ++tableschema_commentsschema_commentsCREATE TABLE "schema_comments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "target_type" varchar, "schema" varchar, "table" varchar, "column" varchar, "text" text, "user_id" integer) K+)indexindex_schema_comments_on_schemaschema_commentsCREATE INDEX "index_schema_comments_on_schema" ON "schema_comments" ("schema")@StablesessionssessionsCREATE TABLE "sessions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "session_id" varchar NOT NULL, "data" text, "created_at" datetime, "updated_at" datetime)yEindexindex_sessions_on_session_idsessionsCREATE INDEX "index_sessions_on_session_id" ON "sessions" ("session_id")yEindexindex_sessions_on_updated_atsessionsCREATE INDEX "index_sessions_on_updated_at" ON "sessions" ("updated_at")YtablesnippetssnippetsCREATE TABLE "snippets" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "content" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "user_id" integer)p?indexindex_snippets_on_user_idsnippetsCREATE INDEX "index_snippets_on_user_id" ON "snippets" ("user_id")YtabletaggingstaggingsCREATE TABLE "taggings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "tag_id" integer, "taggable_id" integer, "taggable_type" varchar, "tagger_id" integer, "tagger_type" varchar, "context" varchar(128), "created_at" datetime)#%indextaggings_idxtaggingsCREATE UNIQUE INDEX "taggings_idx" ON "taggings" ("tag_id", "taggable_id", "taggable_type", "context", "tagger_id", "tagger_type")Uindexindex_taggings_on_taggable_id_and_taggable_type_and_contexttaggingsCREATE INDEX "index_taggings_on_taggable_id_and_taggable_type_and_context" ON "taggings" ("taggable_id", "taggable_type", "context")   $3 Guestguest-user@test.comadmin . AQuerycreate12016-05-27 22:19:10.186871   Query  a-c3.generate({ bindto: PANEL, data: { x: HEADERS[0], columns: COLUMNS, type: 'bar' }, axis: { x: { type: 'category', categories: COLUMNS[0], tick: { culling: true } } } }); delay_comparison