25:["$","title",null,{"children":"Brazilian Airline Industry | Christian Miranda | Observable"}] 49:T4a8,chartAnac = vl .markLine({ point: "transparent", interpolate: "monotone", strokeWidth: 2.5 }) .title({ text: "ANAC - Number of Passengers", subtitle: "Data from ANAC, Belo Forecast", anchor: "start" }) .data(dadosANACAlt) .encode( vl .x() .fieldT("date") .title("") .scale({ domain: ["2017", "2023"] }) .axis({ offset: 20, domainOpacity: 1, domainColor: "black", domainWidth: 1, format: "%Y", tickCount: "year", tickColor: "black", titlePadding: 15, labelPadding: 5, grid: false }), vl .y() .fieldQ("value") .scale({ domain: [0, 12e6] }) .title("Passengers") .axis({ format: "~s", domainOpacity: 1, titlePadding: 15, tickColor: "black" }), vl .color() .fieldN("field") .scale({ range: ["#fa6b2b", "#007094"] }) .title("") .legend({ labelExpr: '{"value":"Passengers","prediction":"Prediction"}[datum.label]' }) ) .width(950) .config(config.vegalite.en_us) .height(500) .render({ renderer: "svg" })4a:T464,chartGoogleTrends = vl .markLine({ point: "transparent", interpolate: "monotone", tooltip: false, strokeWidth: 2.5 }) .data(dadosGTrendsAlt) .title({ text: "Interest Index in plane tickets (Google Trends)", subtitle: "Data from Google Trends", anchor: "start" }) .encode( vl.x().fieldT("date").axis({ offset: 5, domainOpacity: 1, domainColor: "black", domainWidth: 1, format: "%Y", tickCount: "year", tickColor: "black", titlePadding: 15, labelPadding: 5, grid: false, title: "Date - Year", titlePadding: 15 }), vl .y() .fieldQ("value") .axis({ title: "Passengers", titlePadding: 15 }) .scale({ domain: [15, 80] }), vl .color() .fieldN("field") .scale({ range: ["#fa6b2b", "#007094"] }) .title("") .legend({ labelExpr: '{"value":"Passengers","prediction":"Prediction"}[datum.label]' }) ) .width(950) .config(config.vegalite.en_us) .height(400) .render({ renderer: "svg" })4b:T4bb,chartMobIndex = vl .markLine({ point: "transparent", interpolate: "monotone", tooltip: false, strokeWidth: 2.5 }) .title({ text: "Mobility Index", subtitle: "COVID-19 Community Mobility Reports by Google", anchor: "start" }) .data(dadosCVDalt) .encode( vl .x() .fieldT("date") .axis({ offset: 15, domainOpacity: 1, domainColor: "black", tickColor: "black", titlePadding: 15, labelPadding: 5, grid: false, title: "", titlePadding: 15, tickCount: { interval: "month", step: 3 } }), vl .y() .fieldQ("value") .axis({ title: "Passengers", titlePadding: 15, tickColor: "black", grid: true, gridWidth: 2 }) .scale({ domain: [20, 85] }), vl.color().fieldN("field").title("").legend({ labelExpr: '{"varejo":"Retail","mercados":"Markets","parques":"Parks","estacoes":"Trans. Stations","trabalho":"Work","residencias":"Residential"} [datum.label]' }) ) .width(950) .height(450) .config(config.vegalite.en_us) .render({ renderer: "svg" })4c:[{"id":"8d71ef6234ff35bb349692c3213d0f38a38a0c776cca77e0db734ff55abcb128d574fc1f8ce2fdb01b94773f3714a69e041e70c22e499518a78828a5c6b78e7c","href":"https://static.observableusercontent.com/files/8d71ef6234ff35bb349692c3213d0f38a38a0c776cca77e0db734ff55abcb128d574fc1f8ce2fdb01b94773f3714a69e041e70c22e499518a78828a5c6b78e7c","name":"Dados 2017-2022 - Dados - Passageiros (ANAC).csv","type":"text/csv","lastModified":1695905333899.175,"size":4008},{"id":"88376d7bf88a4038a29f10769d5917a0ac8a4e4fbd34b8eedd5083bfab050fbc4b256deedc441a9c31b3465e8143ffc1421ac46f4b0fc923aa387723352e68b9","href":"https://static.observableusercontent.com/files/88376d7bf88a4038a29f10769d5917a0ac8a4e4fbd34b8eedd5083bfab050fbc4b256deedc441a9c31b3465e8143ffc1421ac46f4b0fc923aa387723352e68b9","name":"Dados 2017-2022 - Dados - Buscas (Google Trends).csv","type":"text/csv","lastModified":1695905333899.175,"size":6881},{"id":"ec74b9dbdc7bf7ccae1c1d1030539811a17f578676a6fbbeb4db73dee36da151d5f37fcd8e8cd4f1290e25c79482032e377201e78e9d3c1e266b0ec2b638d11f","href":"https://static.observableusercontent.com/files/ec74b9dbdc7bf7ccae1c1d1030539811a17f578676a6fbbeb4db73dee36da151d5f37fcd8e8cd4f1290e25c79482032e377201e78e9d3c1e266b0ec2b638d11f","name":"Dados 2017-2022 - Dados - Mobilidade (COVID19 Mobility).csv","type":"text/csv","lastModified":1695905333899.175,"size":2873},{"id":"a4cf6ffd6d518743c4fcbfc80b09a9f0c78ace5ca64ba41f594d01e2b64577e2e38bc521f181f7576d9fb07097aed5333cdfeb608004c91cd207a7385aad8c0f","href":"https://static.observableusercontent.com/files/a4cf6ffd6d518743c4fcbfc80b09a9f0c78ace5ca64ba41f594d01e2b64577e2e38bc521f181f7576d9fb07097aed5333cdfeb608004c91cd207a7385aad8c0f","name":"belo-logo.png","type":"image/png","lastModified":1695905333899.175,"size":9476}] 29:{"id":"4398a6e7ea336a7c","slug":null,"title":"Brazilian Airline Industry","thumbnail":"3bf450aa362e0a5a4b9d77feb9f4cb4d8077b177b8d2fe9f6ae28348af2fd20c","access_level":"public","create_time":"$D2023-09-28T12:48:53.899Z","update_time":"$D2023-09-28T13:13:11.967Z","view_time":null,"first_public_time":"$D2023-09-28T12:48:53.899Z","has_unpublished_edits":null,"fork":true,"stars":0,"starred":false,"owner":{"type":"team","id":"b073b8ee488ecb63","login":"c-miranda","name":"Christian Miranda","avatar_url":"https://avatars-next.observableusercontent.com/4619d1aba2dedd112f55ddac191761e0aeabfdb38ddd23aae4162ebfded5c721","tier":"starter_2024","bio":"","followed_by_you":false,"follows_you":false},"version":2018,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"1b2df6d767d150a9","login":"c-miranda","name":"Christian Miranda","avatar_url":"https://avatars-next.observableusercontent.com/4619d1aba2dedd112f55ddac191761e0aeabfdb38ddd23aae4162ebfded5c721","tier":null,"bio":"","followed_by_you":false,"follows_you":false}],"members":[{"type":"individual","id":"1b2df6d767d150a9","login":"c-miranda","name":"Christian Miranda","avatar_url":"https://avatars-next.observableusercontent.com/4619d1aba2dedd112f55ddac191761e0aeabfdb38ddd23aae4162ebfded5c721","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Brazilian Airline Industry","cells":[{"id":0,"value":"mainTitle=md`# Brazilian Airline Industry`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":701,"value":"mainExp = md`

This is a read of the Brazilian airline sector between the periods from 2017 to 2022. Actual figures for passengers data are taken from ANAC. Forecast factors in and how the COVID-19 pandemic impacted the number of domestic flights in this period, using [Google Trends](https://trends.google.com/trends/explore?cat=67&date=2017-01-01%202022-09-01&geo=BR&q=Flight\" target=\"_blank) as a proxy for interest in airline tickets in Brazil during that same period, and [Google Mobility](https://www.google.com/covid19/mobility/) for foot traffic.

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1023,"value":"$49","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1629,"value":"anacTable = Inputs.table(dadosANACAlt, {\n columns: [\"date\", \"value\"],\n format: {\n value: (v, i) =>\n dadosANACAlt[i].field === \"value\"\n ? htl.html`${Math.round(\n v / 1000000\n )}M`\n : htl.html`${Math.round(\n v / 1000000\n )}M`\n },\n header: {\n date: \"Date\",\n value: \"Number of Passengers\",\n field: \"Type of Data\"\n },\n layout: \"center\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":913,"value":"$4a","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1691,"value":"gtrendsTable = Inputs.table(dadosGTrendsAlt, {\n columns: [\"date\", \"value\"],\n format: {\n value: (v, i) =>\n dadosGTrendsAlt[i].field === \"value\"\n ? htl.html`${v}`\n : htl.html`${v}`\n },\n header: {\n date: \"Date\",\n value: \"Number of Passengers\",\n field: \"Type of Data\"\n },\n layout: \"center\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":813,"value":"$4b","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1707,"value":"colorMap = {\n return {\n varejo: colors.blueSea,\n mercado: colors.orangeRed,\n parques: colors.orange,\n estacoes: colors.red,\n trabalho: colors.green,\n residencias: colors.yellow\n };\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1702,"value":"mobTable = Inputs.table(dadosCVDalt, {\n columns: [\"date\", \"value\"],\n format: {\n value: (v, i) =>\n htl.html`${v}`\n },\n header: {\n date: \"Date\",\n value: \"Number of Passengers\",\n field: \"Type of Data\"\n },\n layout: \"center\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1514,"value":"import { renderEnUs, config } from \"@belo/config\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":123,"value":"import { colors } from \"@belo/colors\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":98,"value":"import { base, fonts } from \"@belo/styles\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":705,"value":"import { vl } from \"@vega/vega-lite-api-v5\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":318,"value":"dadosANACraw = FileAttachment(\n \"Dados 2017-2022 - Dados - Passageiros (ANAC).csv\"\n).csv()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":333,"value":"function dateFormated(dateString) {\n const dateArray = _.map(dateString.split(\"/\"), (e) =>\n _.size(e) === 1 ? \"0\" + e : e\n );\n const dateArrayOrdered = [dateArray[2], dateArray[0], dateArray[1]];\n\n const date = new Date(dateArrayOrdered.join(\"-\"));\n\n return date;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":306,"value":"dadosANAC = {\n const arryRaw = _.map(dadosANACraw, (e) => ({\n date: dateFormated(_.get(e, \"Mês/Ano\")),\n value: parseInt(e[\"Passageiros\"]),\n prediction: parseFloat(e[\"Passageiros (Previsão)\"])\n }));\n\n const arry = _.map(arryRaw, (e) =>\n _.isNaN(e.prediction) ? { date: e.date, value: e.value } : e\n );\n\n return arry;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1018,"value":"dadosANACAlt = dadosANAC.reduce((accumulator, currentValue) => {\n if (\"value\" in currentValue && currentValue.value) {\n const item = {\n date: currentValue.date,\n value: currentValue.value,\n field: \"value\"\n };\n accumulator.push(item);\n }\n if (\"prediction\" in currentValue) {\n const item = {\n date: currentValue.date,\n value: currentValue.prediction,\n field: \"prediction\"\n };\n accumulator.push(item);\n }\n return accumulator;\n}, [])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":365,"value":"dadosGTrendsRaw = FileAttachment(\n \"Dados 2017-2022 - Dados - Buscas (Google Trends).csv\"\n).csv()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":367,"value":"dadosGTrends = {\n const arryRaw = _.map(dadosGTrendsRaw, (e) => ({\n date: dateFormated(_.get(e, \"date\")),\n value: parseInt(e[\"Total\"]),\n prediction: parseFloat(e[\"Total (Previsto)\"])\n }));\n\n const arry = _.map(arryRaw, (e) =>\n _.isNaN(e.prediction)\n ? { date: e.date, value: e.value }\n : _.isNaN(e.value)\n ? { date: e.date, prediction: e.prediction }\n : e\n );\n\n return arry;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":943,"value":"dadosGTrendsAlt = dadosGTrends.reduce((accumulator, currentValue) => {\n if (\"value\" in currentValue) {\n const item = {\n date: currentValue.date,\n value: currentValue.value,\n field: \"value\"\n };\n accumulator.push(item);\n }\n if (\"prediction\" in currentValue) {\n const item = {\n date: currentValue.date,\n value: currentValue.prediction,\n field: \"prediction\"\n };\n accumulator.push(item);\n }\n return accumulator;\n}, [])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":384,"value":"dadosCVDraw = FileAttachment(\n \"Dados 2017-2022 - Dados - Mobilidade (COVID19 Mobility).csv\"\n).csv()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":463,"value":"dadosCVD = {\n return _.map(dadosCVDraw, (e) => ({\n date: new Date(e.date),\n varejo: _.toNumber(_.get(e, \"Varejo e Lazer\")),\n mercados: _.toNumber(_.get(e, \"Mercados e Farmácias\")),\n parques: _.toNumber(_.get(e, \"Parques\")),\n estacoes: _.toNumber(_.get(e, \"Estações de Transporte Público\")),\n trabalho: _.toNumber(_.get(e, \"Locais de Trabalho\")),\n residencias: _.toNumber(_.get(e, \"Áreas Residenciais\"))\n }));\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":807,"value":"dadosCVDalt = {\n let obj = _.filter(\n _.flatten(\n _.map(dadosCVD, (line) =>\n _.map(Object.keys(line), (key) => ({\n date: line.date,\n field: key,\n value: _.round(line[key], 1)\n }))\n )\n ),\n (e) => e.field !== \"date\"\n );\n\n return obj;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1994,"value":"logo = FileAttachment(\"belo-logo.png\").url()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1517,"value":"fonts","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1519,"value":"base","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1667,"value":"","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"}],"files":"$W4c","stdlib":"1"}} 24:null