2b:null 2c:["$","title",null,{"children":"Résultats au bac par lycée entre 2012 et 2024 | Maxime Tiran | Observable"}] 31:T892,viewof selectedDatum = { let value = null; const plot = Plot.plot({ projection: { type: "mercator", domain: { type: "FeatureCollection", features: departements.features.filter(d => dpt_filter.dpt_no === "100" ? true : d.properties.code === dpt_filter.dpt_no) } }, color: { scheme: "RdYlGn", pivot: d3.mean([d3.quantile(keyMetricValues,.01),d3.quantile(keyMetricValues,.99)]), domain: [d3.quantile(keyMetricValues,.01),d3.quantile(keyMetricValues,.99)], // using 1st/99th percentile to avoid outliers legend: true, label: all_column_names.get(keyMetric) }, x : { axis: null }, y: { axis: null }, height: 1000, width: 1000, marks: [ Plot.geo(departements.features.filter(d => dpt_filter.dpt_no === "100" ? true : d.properties.code === dpt_filter.dpt_no), {strokeOpacity: 0.2}), Plot.dot(search, { x: "longitude", y: "latitude", stroke: keyMetric, fill: keyMetric, channels: { nom: { label: "", value: "appellation_officielle" }, secteur: { label: "", value: "secteur" }, commune: { label: "", value: d => `${d.commune} (${d.dpt})` }, academie: { label: "Académie" ,value: "academie" }, taux_men_total: { label: "Taux de mentions (%)", value: "taux_men_total" } }, tip: { format: { nom: true, secteur: true, x: false, y: false, commune: true, academie: true, } } })]}); const dots = d3.select(plot).selectAll("circle, path"); // Adjust selector if needed // Add a click listener dots.on("click", (event, d) => { // 'd' is the datum associated with the clicked element (dot) // Update the cell's value value = d; // Store the selected data point // Make the plot visually reflect the selection (optional) dots.attr("stroke-width", dd => dd === d ? 3 : 1); // Example: Thicker stroke for selected dots.attr("stroke", dd => dd === d ? "black" : "taux_reu_total"); // Example: Orange stroke mutable lyceeSelectionne = value; }); // Return the plot element to display it return plot; }32:Ta47,Plot.plot({ projection: { type: "mercator", domain: { type: "FeatureCollection", features: departements.features.filter(d => dpt_filter.dpt_no === "100" ? true : d.properties.code === dpt_filter.dpt_no) } }, length: {type: "sqrt"}, x : { axis: null }, y: { axis: null }, height: 800, width: 800, marginRight: 100, marks: [ Plot.geo(departements.features.filter(d => dpt_filter.dpt_no === "100" ? true : d.properties.code === dpt_filter.dpt_no), {strokeOpacity: 0.2}), Plot.vector( etablissements2geoProgression.features .filter(d => dpt_filter.dpt_no === "100" ? true : parseInt(d.properties.code_departement) === parseInt(dpt_filter.dpt_no)), Plot.centroid({ anchor: "start", length: { value: (d) => d.properties.progression === 0 ? 1 : Math.abs(d.properties.progression), // The data value to scale type: "linear", domain: [Math.abs(d3.min(etablissements2geoProgression.features.map(d => d.properties.progression))), d3.max(etablissements2geoProgression.features.map(d => d.properties.progression))], // Your data's progression range range: [0, 5] // The desired visual length range (e.g., [0, 50] pixels) }, stroke: (d) => { if(d.properties.progression > 0) return "green"; else if(d.properties.progression === 0) return "gray"; else //if(d.properties.progression > 0) return "red"; }, rotate: (d) => { if(d.properties.progression > 0) return 45; else if(d.properties.progression === 0) return 90; else //if(d.properties.progression > 0) return 135; }, channels: { nom: {label: '', value: "appellation_officielle"}, commune: "commune", academie: "academie", progression: "progression", [year]: "taux_reu_total_current_year", [year-1]: "taux_reu_total_previous_year" }, tip: { anchor: "left", format: { nom: true, length: false, rotate: false, [year]: d => d + '%', [year-1]: d => d + '%', progression: d => `${new Intl.NumberFormat('en-US', { signDisplay: 'always' }).format(d)}pp`, //textOverflow: "" } } }) ) ] });33:T54b,# ${lyceeAnnuaire[0].nom_etablissement} ${lycee[0].secteur.toUpperCase()} - ${lycee[0].libelle_commune} - ${lycee[0].libelle_departement} (${lycee[0].code_departement}) - Académie de ${lycee[0].libelle_academie} - ${lycee[0].libelle_region} ${lyceeAnnuaire[0].adresse_1} ${lyceeAnnuaire[0].adresse_2 ? '\n' + lyceeAnnuaire[0].adresse_2 + ' ' : ''} ${lyceeAnnuaire[0].code_postal} ${lyceeAnnuaire[0].nom_commune} tel: ${lyceeAnnuaire[0].telephone} ${ lyceeAnnuaire[0].fax ? `\nfax: ${lyceeAnnuaire[0].fax}`: ''} <${lyceeAnnuaire[0].web}> <${lyceeAnnuaire[0].mail}> [Fiche Onisep](${lyceeAnnuaire[0].fiche_onisep}) **Nb élèves:** ${frNbFormat(lyceeAnnuaire[0].nombre_d_eleves)} **Voies:** ${['voie_generale','voie_technologique','voie_professionelle'].filter(d => lyceeAnnuaire[0][d] == 1).map(d => d.substr(5)).join(' - ')} **Sections:** ${['section_arts','section_cinema','section_theatre','section_internationale','section_europeenne'].filter(d => lyceeAnnuaire[0][d] == 1).map(d => d.substr(8)).join(' - ')} **Langues:** - LV1: ${languesParLycee.LV1.join(', ')} - LV2: ${languesParLycee.LV2.join(', ')} ${languesParLycee.LV3 ? '- LV3: ' + languesParLycee.LV3.join(', ') : ''} ${languesParLycee.LCA ? '- LCA: ' + languesParLycee.LCA.join(', ') : ''} 34:T457,#### Taux de réussite au bac - ${lycee[0].dpt_reu_rank}e du département (${lycee[0].libelle_departement}) - ${lycee[0].academie_reu_rank}e de l'académie (${lycee[0].libelle_academie}) - ${frNbFormat(lycee[0].fr_reu_rank)}e de France #### Taux de réussite au bac - ${lycee[0].dpt_secteur_reu_rank}e des etablissements ${lycee[0].secteur} du département (${lycee[0].libelle_departement}) - ${lycee[0].academie_secteur_reu_rank}e des etablissements ${lycee[0].secteur} de l'académie (${lycee[0].libelle_academie}) - ${frNbFormat(lycee[0].fr_secteur_reu_rank)}e des etablissements ${lycee[0].secteur} de France #### Taux de mentions au bac - ${lycee[0].dpt_men_rank}e du département (${lycee[0].libelle_departement}) - ${lycee[0].academie_men_rank}e de l'académie (${lycee[0].libelle_academie}) - ${frNbFormat(lycee[0].fr_men_rank)}e de France #### Classement Le Figaro Etudiant - ${lycee[0].dpt_fig_score_rank}e du département (${lycee[0].libelle_departement}) - ${lycee[0].academie_fig_score_rank}e de l'académie (${lycee[0].libelle_academie}) - ${frNbFormat(lycee[0].fr_fig_score_rank)}e de France35:T935,SELECT uai, libelle_uai as appellation_officielle, secteur_public_prive_libe as secteur, etablissements.libelle_commune as commune, etablissements.libelle_departement as dpt, etablissements.libelle_academie as academie, CASE etablissements.code_departement WHEN '971' THEN (${insetTranslation[0].orig_lat} + ((latitude - ${insetTranslation[0].orig_lat}) * ${insetTranslation[0].scale})) + ${insetTranslation[0].delta_lat} WHEN '972' THEN (${insetTranslation[1].orig_lat} + ((latitude - ${insetTranslation[1].orig_lat}) * ${insetTranslation[1].scale})) + ${insetTranslation[1].delta_lat} WHEN '973' THEN (${insetTranslation[2].orig_lat} + ((latitude - ${insetTranslation[2].orig_lat}) * ${insetTranslation[2].scale})) + ${insetTranslation[2].delta_lat} WHEN '974' THEN (${insetTranslation[3].orig_lat} + ((latitude - ${insetTranslation[3].orig_lat}) * ${insetTranslation[3].scale})) + ${insetTranslation[3].delta_lat} WHEN '976' THEN (${insetTranslation[4].orig_lat} + ((latitude - ${insetTranslation[4].orig_lat}) * ${insetTranslation[4].scale})) + ${insetTranslation[4].delta_lat} ELSE latitude END AS latitude, CASE etablissements.code_departement WHEN '971' THEN (${insetTranslation[0].orig_lon} + ((longitude - ${insetTranslation[0].orig_lon}) * ${insetTranslation[0].scale})) + ${insetTranslation[0].delta_lon} WHEN '972' THEN (${insetTranslation[1].orig_lon} + ((longitude - ${insetTranslation[1].orig_lon}) * ${insetTranslation[1].scale})) + ${insetTranslation[1].delta_lon} WHEN '973' THEN (${insetTranslation[2].orig_lon} + ((longitude - ${insetTranslation[2].orig_lon}) * ${insetTranslation[2].scale})) + ${insetTranslation[2].delta_lon} WHEN '974' THEN (${insetTranslation[3].orig_lon} + ((longitude - ${insetTranslation[3].orig_lon}) * ${insetTranslation[3].scale})) + ${insetTranslation[3].delta_lon} WHEN '976' THEN (${insetTranslation[4].orig_lon} + ((longitude - ${insetTranslation[4].orig_lon}) * ${insetTranslation[4].scale})) + ${insetTranslation[4].delta_lon} ELSE longitude END AS longitude, date_ouverture, resultats.* FROM "etablissements" LEFT JOIN "resultats" ON (numero_uai = uai) WHERE IF(${dpt_filter.dpt_no} = 100, TRUE, try_cast(etablissements.code_departement as int) = ${dpt_filter.dpt_no}) AND annee = make_date(${year}::INTEGER,1,1)36:T8c2,SELECT numero_uai, appellation_officielle, secteur_public_prive_libe as secteur, etablissements.libelle_departement as dpt, etablissements.libelle_commune as commune, etablissements.libelle_academie as academie, CASE etablissements.code_departement WHEN '971' THEN (${insetTranslation[0].orig_lat} + ((latitude - ${insetTranslation[0].orig_lat}) * ${insetTranslation[0].scale})) + ${insetTranslation[0].delta_lat} WHEN '972' THEN (${insetTranslation[1].orig_lat} + ((latitude - ${insetTranslation[1].orig_lat}) * ${insetTranslation[1].scale})) + ${insetTranslation[1].delta_lat} WHEN '973' THEN (${insetTranslation[2].orig_lat} + ((latitude - ${insetTranslation[2].orig_lat}) * ${insetTranslation[2].scale})) + ${insetTranslation[2].delta_lat} WHEN '974' THEN (${insetTranslation[3].orig_lat} + ((latitude - ${insetTranslation[3].orig_lat}) * ${insetTranslation[3].scale})) + ${insetTranslation[3].delta_lat} WHEN '976' THEN (${insetTranslation[4].orig_lat} + ((latitude - ${insetTranslation[4].orig_lat}) * ${insetTranslation[4].scale})) + ${insetTranslation[4].delta_lat} ELSE latitude END AS latitude, CASE etablissements.code_departement WHEN '971' THEN (${insetTranslation[0].orig_lon} + ((longitude - ${insetTranslation[0].orig_lon}) * ${insetTranslation[0].scale})) + ${insetTranslation[0].delta_lon} WHEN '972' THEN (${insetTranslation[1].orig_lon} + ((longitude - ${insetTranslation[1].orig_lon}) * ${insetTranslation[1].scale})) + ${insetTranslation[1].delta_lon} WHEN '973' THEN (${insetTranslation[2].orig_lon} + ((longitude - ${insetTranslation[2].orig_lon}) * ${insetTranslation[2].scale})) + ${insetTranslation[2].delta_lon} WHEN '974' THEN (${insetTranslation[3].orig_lon} + ((longitude - ${insetTranslation[3].orig_lon}) * ${insetTranslation[3].scale})) + ${insetTranslation[3].delta_lon} WHEN '976' THEN (${insetTranslation[4].orig_lon} + ((longitude - ${insetTranslation[4].orig_lon}) * ${insetTranslation[4].scale})) + ${insetTranslation[4].delta_lon} ELSE longitude END AS longitude, date_ouverture, FROM "etablissements" WHERE IF(${dpt_filter.dpt_no} = 100, TRUE, try_cast(etablissements.code_departement as int) = ${dpt_filter.dpt_no})37:T608,lycee = db.query(` WITH all_lycees AS ( SELECT *, round(taux_acces_2nde/100 * CAST(taux_reu_gnle AS DOUBLE)/100 * CAST(taux_men_gnle AS DOUBLE)/100,2) as fig_score, RANK() OVER (PARTITION BY annee, libelle_academie ORDER BY taux_reu_total DESC) AS academie_reu_rank, RANK() OVER (PARTITION BY annee, code_departement ORDER BY taux_reu_total DESC) AS dpt_reu_rank, RANK() OVER (PARTITION BY annee ORDER BY taux_reu_total DESC) AS fr_reu_rank, RANK() OVER (PARTITION BY annee, libelle_academie ORDER BY taux_men_total DESC) AS academie_men_rank, RANK() OVER (PARTITION BY annee, code_departement ORDER BY taux_men_total DESC) AS dpt_men_rank, RANK() OVER (PARTITION BY annee ORDER BY taux_men_total DESC) AS fr_men_rank, RANK() OVER (PARTITION BY annee, libelle_academie ORDER BY fig_score DESC) AS academie_fig_score_rank, RANK() OVER (PARTITION BY annee, code_departement ORDER BY fig_score DESC) AS dpt_fig_score_rank, RANK() OVER (PARTITION BY annee ORDER BY fig_score DESC) AS fr_fig_score_rank, RANK() OVER (PARTITION BY annee, libelle_academie, secteur ORDER BY taux_reu_total DESC) AS academie_secteur_reu_rank, RANK() OVER (PARTITION BY annee, code_departement, secteur ORDER BY taux_reu_total DESC) AS dpt_secteur_reu_rank, RANK() OVER (PARTITION BY annee, secteur ORDER BY taux_reu_total DESC) AS fr_secteur_reu_rank, -- Rank by public/prive -- Rank by resultats du bac, mentions, va, classement Figaro FROM resultats ORDER BY date_part('year', annee) DESC) SELECT * FROM all_lycees WHERE uai = '${search[lyceeSelectionne]?.uai}'`)38:[{"id":"a6221fa08c64b65b2f5ce1230ffa74f2e64679108d3a080d1dfdad804ec148730287ab47886ee80f1d3611966e9011699dbe55ffad26bc25cba9a1336e8693ba","href":"https://static.observableusercontent.com/files/a6221fa08c64b65b2f5ce1230ffa74f2e64679108d3a080d1dfdad804ec148730287ab47886ee80f1d3611966e9011699dbe55ffad26bc25cba9a1336e8693ba","name":"annuaire-lycees.parquet","type":"application/octet-stream","lastModified":1745617850257.356,"size":1118989},{"id":"ffdca2f8861e7b2f537c5b65b47b83e2a3b9a30f57895bafa8188071c5a10ab644b167f21c2bb00dfec24876464730b354b86e5acb79bc6d7a68da2251a2768c","href":"https://static.observableusercontent.com/files/ffdca2f8861e7b2f537c5b65b47b83e2a3b9a30f57895bafa8188071c5a10ab644b167f21c2bb00dfec24876464730b354b86e5acb79bc6d7a68da2251a2768c","name":"langues-lycees.parquet","type":"application/octet-stream","lastModified":1745617900567.251,"size":101511},{"id":"94ebdfbbddb7c61e352c897b334fc6500e4749f62137d6881cfa7d07dccaf76b84c042e6112e57e986d0e0abd3e18defe45cfc42f2ea72845b8a46b8b27ef3a2","href":"https://static.observableusercontent.com/files/94ebdfbbddb7c61e352c897b334fc6500e4749f62137d6881cfa7d07dccaf76b84c042e6112e57e986d0e0abd3e18defe45cfc42f2ea72845b8a46b8b27ef3a2","name":"fr-en-ips-lycees-ap2023.parquet","type":"application/octet-stream","lastModified":1745617900724.717,"size":351553},{"id":"0dd0e62569554ae7e8264f41b3d45e5ecbd5b61ddd4442cf7dde9a071c07d10fba9ff712e25a9830dad13e1ffb205e47254f85f4bc2b0dfb92642dbb2eec56d7","href":"https://static.observableusercontent.com/files/0dd0e62569554ae7e8264f41b3d45e5ecbd5b61ddd4442cf7dde9a071c07d10fba9ff712e25a9830dad13e1ffb205e47254f85f4bc2b0dfb92642dbb2eec56d7","name":"fr-en-indicateurs-de-resultat-des-lycees-gt_v2.parquet","type":"application/octet-stream","lastModified":1744931168083.266,"size":1569174},{"id":"3ba2cd9f21435089096f6ad53e48fab525e352977de00c5841603f9d7103c3efb6f079239c17fdcb45ef29859e7cc1d09a5385a8f98e20278a8596427c83c93a","href":"https://static.observableusercontent.com/files/3ba2cd9f21435089096f6ad53e48fab525e352977de00c5841603f9d7103c3efb6f079239c17fdcb45ef29859e7cc1d09a5385a8f98e20278a8596427c83c93a","name":"fr-en-adresse-et-geolocalisation-etablissements-premier-et-second-degre.parquet","type":"application/octet-stream","lastModified":1744931626525.163,"size":7905628},{"id":"78c4d997407b905d6e0a397e44386ec0a7783c09a7a5432959d1d6624a80eee4c79c7af44020dc93e974ce37b15f89274a59208257a1f833588f33a6c7a225be","href":"https://static.observableusercontent.com/files/78c4d997407b905d6e0a397e44386ec0a7783c09a7a5432959d1d6624a80eee4c79c7af44020dc93e974ce37b15f89274a59208257a1f833588f33a6c7a225be","name":"resultats_schema.json","type":"application/json","lastModified":1745023248673.636,"size":12631},{"id":"29f0c6b9943850f171fd9681338728c5d208a1f1e9b0a3ad5dbaa4a8a20cec05bee2dca6a3824dbb75200cdd642eb6be0ca0644e995b9b831373e0af24641354","href":"https://static.observableusercontent.com/files/29f0c6b9943850f171fd9681338728c5d208a1f1e9b0a3ad5dbaa4a8a20cec05bee2dca6a3824dbb75200cdd642eb6be0ca0644e995b9b831373e0af24641354","name":"lycees_schema@1.json","type":"application/json","lastModified":1745023248673.849,"size":12010},{"id":"0dcd38e7dfd2567ac74e276e85cbdaeddf899f3ae44a16812a5cc727b2c4ba44cee998ef8e10b104b6433901ad9fa4233f4f6caf6b1f4d21717add7b230befb8","href":"https://static.observableusercontent.com/files/0dcd38e7dfd2567ac74e276e85cbdaeddf899f3ae44a16812a5cc727b2c4ba44cee998ef8e10b104b6433901ad9fa4233f4f6caf6b1f4d21717add7b230befb8","name":"fr-en-reussite-au-baccalaureat-origine-sociale.parquet","type":"application/octet-stream","lastModified":1745905614535.64,"size":19252}] 2f:{"id":"59bb9cd917be1625","slug":null,"title":"Résultats au bac par lycée entre 2012 et 2024","thumbnail":"cadfb54e9710f9a7771add8ff9fbf0df41e0942418b661eefb99c1da1583b36f","access_level":"public","create_time":"$D2025-04-17T23:05:50.700Z","update_time":"$D2025-05-09T07:05:06.733Z","view_time":null,"first_public_time":"$D2025-04-18T05:59:22.688Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"9a863e6e8fd9162a","login":"maxime-tiran","name":"Maxime Tiran","avatar_url":"https://avatars-next.observableusercontent.com/3bb6ce53630c8461b072ef094350bc521ff28b5197fc428ae1d28697d4c3597e","tier":"starter_2024","bio":""},"version":2860,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"b1a105d58de87cb6","login":"maxime-tiran","name":"Maxime Tiran","avatar_url":"https://avatars-next.observableusercontent.com/d9dcc253effa99894cc1f98ba875f02b20f0fcb50eb8a9ead253ac469fd1c9f6","tier":null,"bio":""}],"members":[{"type":"team","id":"9a863e6e8fd9162a","login":"maxime-tiran","name":"Maxime Tiran","avatar_url":"https://avatars-next.observableusercontent.com/3bb6ce53630c8461b072ef094350bc521ff28b5197fc428ae1d28697d4c3597e","tier":"starter_2024","role":"editor"},{"type":"individual","id":"b1a105d58de87cb6","login":"maxime-tiran","name":"Maxime Tiran","avatar_url":"https://avatars-next.observableusercontent.com/d9dcc253effa99894cc1f98ba875f02b20f0fcb50eb8a9ead253ac469fd1c9f6","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":true,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Résultats au bac par lycée entre 2012 et 2024","cells":[{"id":0,"value":"# Résultats au bac par lycée entre 2012 et 2024\nSource: [data.education.gouv.fr](https://data.education.gouv.fr/explore/dataset/fr-en-indicateurs-de-resultat-des-lycees-gt_v2/information/)\n\nLe Ministère ne transmet pas les données pour des lycées ayant moins de 20 élèves candidats au Bac Général & Technique ou 10 élèves candidats au Bac Pro.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":215,"value":"viewof dpt_filter = Inputs.select(\n [{name: \"Tous (France entiere)\", dpt_no: \"100\"}].concat(\n departements.features.map(d => ({\n name: d.properties.code + \" \" + d.properties.nom, \n dpt_no: d.properties.code\n })).sort((a,b) => parseInt(a.dpt_no) - parseInt(b.dpt_no))), \n {\n label: \"Departement: \",\n format: d => d.name, \n value: d => d.dpt_no\n })\n\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":306,"value":"viewof year = Inputs.range([2012, 2024], {step: 1, label: \"Annee\", value: 2024})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1873,"value":"viewof section = Inputs.select(sections, {label: \"Série: \", value: \"TOTAL\", format: d => d === 'TOTAL' ? 'Toutes' : d})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1786,"value":"viewof metric = Inputs.select(metrics, {\n label: \"Mesure: \",\n format: d => metrics_labels.get(d),\n value: \"taux_reu\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":992,"value":"viewof search = Inputs.search(etablissements2geo.features.map(d=>d.properties), {placeholder: \"Cherchez par lycée, ville, dpt, académie...\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":995,"value":"table = Inputs.table(search, {\n width: {\n uai: 80,\n appellation_officielle: 500,\n },\n columns: ['uai','appellation_officielle','secteur','commune','academie'],\n multiple: false\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1815,"value":"# ${all_column_names.get(keyMetric)}\nMin - Max : ${Math.min(...keyMetricValues)}% - ${Math.max(...keyMetricValues)}% \n1er centile : ${d3.quantile(keyMetricValues,.01).toLocaleString(\"fr-FR\",{maximumFractionDigits: 1})}% \n99e centile : ${d3.quantile(keyMetricValues,.99).toLocaleString(\"fr-FR\",{maximumFractionDigits: 1})}% \nMédiane : ${d3.median(keyMetricValues)}% \nMoyenne : ${d3.mean(keyMetricValues).toLocaleString(\"fr-FR\",{maximumFractionDigits: 1})}% ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1822,"value":"Plot.plot({\n height: 100,\n width: 200,\n y:{label: \"Lycees\"},\n x : {label: \"%\"},\n marks: [\n Plot.rectY(keyMetricValues, \n Plot.binX({\n y:\"count\"\n },\n {\n thresholds: Array.from({length: 41}, (_, i) => i * 2.5), \n tip: true\n })),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":31,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1721,"value":"### Evolution du taux de réussite au bac de ${year-1} a ${year}","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1628,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1922,"value":"Plot.plot({\n projection: {\n type: \"mercator\",\n domain: {\n type: \"FeatureCollection\", \n features: departements.features\n }\n },\n height: 150,\n width: 150,\n marginRight: 10,\n marks: [\n Plot.geo(departements,\n {strokeOpacity: 0.1}),\n Plot.dot([lyceeAnnuaire[0]],{x: \"longitude\", y:\"latitude\", r: 3, stroke: \"black\", fill: \"black\"}),\n ]\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1454,"value":"$33","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":2121,"value":"## Indice de Position Sociale (IPS) \n \n \n| | IPS de l'établissement | Ecart Type | Département | Académie | National |\n| ------ | --- | ---------- | ---------- | ----------- | -------- | -------- | \n| Voie Générale et Technique | ${ips[0].ips_voie_gt} | ${ips[0].ecart_type_voie_gt} | ${ips[0].ips_departemental_legt} | ${ips[0].ips_academique_legt} | ${ips[0].ips_national_legt} | ${ips[0].ips_voie_pro ? `\\n| Voie pro | ${ips[0].ips_voie_pro} | ${ips[0].ecart_type_voie_pro} | ${ips[0].ips_departemental_lp} | ${ips[0].ips_academique_lp} | ${ips[0].ips_national_lp}` : ''} ${ips[0].ips_post_bac ? `\\n| Post bac | ${ips[0].ips_post_bac} | | ` : ''}\n| Etablissement | ${ips[0].ips_etab} | ${ips[0].ecart_type_etablissement} | ${ips[0].ips_departemental_lpo} | ${ips[0].ips_academique_lpo} | ${ips[0].ips_national_lpo} |\n\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1952,"value":"Plot.plot({\n y: {label: \"Lycees\"},\n x: {label: \"IPS\"},\n fx: {label:'', tickFormat: d => ips_labels.get(d)},\n fy: {label: '', domain: ['public','privé sous contrat']},\n facet: {data: ips_values, x: \"metric\", y: \"secteur\" },\n marginRight: 100,\n color: {legend: true},\n marks: [\n Plot.rectY(ips_values, \n Plot.binX({y:\"count\", fill: (data,bin) => {\n const current_lycee_ips = parseFloat(ips[0][data[0].metric]);\n if(bin.x1 < current_lycee_ips && current_lycee_ips < bin.x2)\n return \"red\";\n else\n return \"lightskyblue\";\n }},{\n x: \"value\",\n thresholds:20, \n tip: false,\n })),\n Plot.text(ips_lycee, {\n fx: d => d.metric,\n fy: d => d.secteur,\n x: Plot.dodgeX({ round: true }),\n frameAnchor: \"top\",\n text: d => d.value,\n fontSize: 13,\n }),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2131,"value":"ips_lycee = [\n {secteur: lycee[0].secteur, metric: 'ips_voie_gt',value: ips[0].ips_voie_gt},\n {secteur: lycee[0].secteur, metric: 'ips_voie_pro',value: ips[0].ips_voie_pro},\n {secteur: lycee[0].secteur, metric: 'ips_post_bac',value: ips[0].ips_post_bac},\n {secteur: lycee[0].secteur, metric: 'ips_etab',value: ips[0].ips_etab},\n]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":705,"value":"md`\n| Classe | Effectif | Accès au bac (vs attendu) |\n| :--: | :--: | :--: | :--: | :--: | :--: |\n| 2nde | ${lycee[0].eff_2nde} | ${lycee[0].taux_acces_2nde}% (${vaFormatter.format(lycee[0].va_acces_2nde) ?? '-'}) |\n| 1ère | ${lycee[0].eff_1ere} | ${lycee[0].taux_acces_1ere}% (${vaFormatter.format(lycee[0].va_acces_1ere) ?? '-'}) |\n| Teminale | ${lycee[0].eff_term} | ${lycee[0].taux_acces_term}% (${vaFormatter.format(lycee[0].va_acces_term) ?? '-'}) |\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1104,"value":"md`\n| Voie \\\\ Mentions | Assez Bien | Bien | Très Bien (sans fél.) | Très Bien (avec fél.) |\n| :--: | :--: | :--: | :--: | :--: |\n| Générale | ${lycee[0].nb_mentions_ab_g ?? 0} | ${lycee[0].nb_mentions_b_g ?? 0} | ${lycee[0].nb_mentions_tb_sansf_g ?? 0} | ${lycee[0].nb_mentions_tb_avecf_g ?? 0} |\n| Technique | ${lycee[0].nb_mentions_ab_t ?? 0} | ${lycee[0].nb_mentions_b_t ?? 0} | ${lycee[0].nb_mentions_tb_sansf_t ?? 0} | ${lycee[0].nb_mentions_tb_avecf_g ?? 0} |\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1082,"value":"md`\n| Série | Présents | Réussite au bac (vs. attendu) | Mentions (vs attendu) |\n| :--: | :--: | :--: | :--: |\n${resultats_par_section.map(d => `|${d.section.toUpperCase()}|${d.presents}|${d.taux_reu}% (${vaFormatter.format(d.va_reu)})|${d.taux_men}% (${vaFormatter.format(d.va_men)})\\n`)}\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2793,"value":"$34","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":945,"value":"Plot.plot({\n marginRight: 60,\n x: {tickFormat: \"d\", ticks: 5, grid: true},\n y: {label: \"Taux (%)\", grid: true},\n facet: {data: resultats_par_section_et_par_an, x: \"metric\", y: \"section\" },\n fx: {label: \"Taux de réussite et mentions au bac vs attendu\"},\n fy: {label: \"Série\", domain: sections.filter(d => resultats_par_section_et_par_an.map(a => a.section).includes(d))},\n marks: [\n Plot.frame(),\n Plot.ruleY([0]),\n Plot.differenceY(resultats_par_section_et_par_an, {\n x: \"year\", \n y2: \"taux\", // actual\n y1: d => d.taux - d.va, // expected\n sort: \"year\",\n title: d => `${d.year}\\n${d.metric}: ${d.taux}% (${vaFormatter.format(d.va)})`,\n tip: true,\n negativeFill: \"red\"\n }),\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2732,"value":"md`| Rang | Etablissement | Score | Réussite | Mentions | \n| :--: | :-- | :--: | :--: | :--: | :--: |\n|${lycee_ranks.filter(d => d.annee === year).slice(0,20).map(d => [\n `

${d.figaro_rank === 1 ? '🥇' :\n d.figaro_rank === 2 ? '🥈' :\n d.figaro_rank === 3 ? '🥉' :\n d.figaro_rank}

`, \n `

${d.libelle_uai}

${d.libelle_commune} - ${d.secteur}

`, \n d.score,\n d.taux_reu_total + '%',\n d.taux_men_total + '%'\n].join('|'))\n.join('\\n|')}|`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1294,"value":"SELECT \n date_part('year', annee) as annee,\n libelle_uai,\n secteur,\n round(taux_acces_2nde/100 * CAST(taux_reu_gnle AS DOUBLE)/100 * CAST(taux_men_gnle AS DOUBLE)/100,2) as score,\n IFNULL(va_acces_2nde,0) + IFNULL(TRY_CAST(va_reu_gnle AS INT),0) + IFNULL(TRY_CAST(va_men_gnle AS INT),0) as va,\n RANK() OVER (PARTITION BY annee ORDER BY score DESC, va DESC) AS figaro_rank,\n taux_reu_total,\n taux_men_total,\n libelle_commune,\n taux_acces_2nde,\n presents_total, \n va_reu_total,\nFROM resultats\n WHERE score IS NOT NULL\nORDER BY date_part('year', annee) DESC, figaro_rank ASC","pinned":false,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"lycee_ranks","database":"var:db"},{"id":152,"value":"$35","pinned":false,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"resultats_etablissements","database":"var:db"},{"id":1631,"value":"$36","pinned":false,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"etablissements","database":"var:db"},{"id":1641,"value":"SELECT etablissements.*, \n r1.taux_reu_total as taux_reu_total_current_year,\n r2.taux_reu_total as taux_reu_total_previous_year,\n r1.taux_reu_total - r2.taux_reu_total as progression\n FROM etablissements \n JOIN resultats as r1 ON numero_uai = r1.uai \n JOIN resultats as r2 ON r1.uai = r2.uai\n WHERE r1.annee = make_date(${year}::INTEGER,1,1) AND r2.annee = make_date(${year-1}::INTEGER,1,1) ","pinned":false,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"progression","database":"var:db"},{"id":555,"value":"lycees_schema = FileAttachment(\"lycees_schema@1.json\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":560,"value":"column_names = new Map(\n Object.entries(lycees_schema.definitions['fr-en-adresse-et-geolocalisation-etablissements-premier-et-second-degre_records'].properties.fields.properties)\n .map(d => [\n d[0], \n d[1].description.length > 50 ? d[0] : d[1].description\n ])\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":606,"value":"resultats_schema = FileAttachment(\"resultats_schema.json\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":617,"value":"all_column_names = new Map([...column_names, ...resultats_column_names])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":603,"value":"resultats_column_names = new Map(\n Object.entries(resultats_schema.definitions['fr-en-indicateurs-de-resultat-des-lycees-gt_v2_records'].properties.fields.properties)\n .map(d => [\n d[0],\n d[1].title\n ])\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":669,"value":"sections = ['L','ES','S','GNLE','STI2D','STD2A','STMG','STL','ST2S','S2TMD','STHR','TOTAL']","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":678,"value":"metrics = ['presents','taux_reu','va_reu','taux_men','va_men']","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1884,"value":"metrics_labels = new Map([\n [\"presents\", \"Présents\"],\n [\"taux_reu\", \"Taux de réussite\"], \n [\"va_reu\",\"Valeur ajoutée au taux de réussite\"], \n [\"taux_men\", \"Taux de mentions\"], \n [\"va_men\", \"Valeur ajoutée au taux de mentions\"]\n ])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1782,"value":"metrics_by_sections = sections.flatMap(d => metrics.map(x => x + '_' + d.toLowerCase()))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":42,"value":"etablissements2geo = geo.coords2geo(resultats_etablissements, { lat: \"latitude\", lon: \"longitude\" })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1656,"value":"etablissements2geoProgression = geo.coords2geo(progression, { lat: \"latitude\", lon: \"longitude\" })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":406,"value":"insetTranslation = [\n {dpt_no: 971, scale: 3, delta_lat: 34.80227083315512 , delta_lon: 54.31577971685846, orig_lon: -61.53943, orig_lat: 16.19773},\n {dpt_no: 972, scale: 3, delta_lat: 34.346815331503464 , delta_lon: 53.79475812830232, orig_lon: -61.01841 , orig_lat: 14.65318},\n {dpt_no: 973, scale: 0.45, delta_lat: 43.076417030966844 , delta_lon: 46.011693861377545, orig_lon: -53.23535, orig_lat: 3.92358},\n {dpt_no: 974, scale: 3, delta_lat: 66.13325609700435 , delta_lon: -62.756192214959334, orig_lon: 55.53254 , orig_lat: -21.13326},\n {dpt_no: 976, scale: 3, delta_lat: 55.82061630358814, delta_lon: -52.37109553170058, orig_lon: 45.14744, orig_lat: -12.82062}\n]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":390,"value":"insetLocations = [\n { code: \"971\", name: \"Guadeloupe\", targetLon: -6.0, targetLat: 41.5 },\n { code: \"972\", name: \"Martinique\", targetLon: -4.5, targetLat: 41.5 },\n { code: \"973\", name: \"Guyane\", targetLon: -3.0, targetLat: 41.5 },\n { code: \"974\", name: \"Réunion\", targetLon: -1.5, targetLat: 41.5 },\n { code: \"976\", name: \"Mayotte\", targetLon: 0.0, targetLat: 41.5 },\n // Add more as needed\n];","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":124,"value":"db = DuckDBClient.of({\n etablissements: FileAttachment(\"fr-en-adresse-et-geolocalisation-etablissements-premier-et-second-degre.parquet\"),\n resultats: FileAttachment(\"fr-en-indicateurs-de-resultat-des-lycees-gt_v2.parquet\")\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":181,"value":"departements = FileAttachment(\"departement_avec_outremer_rapprochée.geojson\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":22,"value":"geo = require(\"geotoolbox@3\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1169,"value":"vaFormatter = new Intl.NumberFormat('fr-FR', { signDisplay: 'always' })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2811,"value":"frNbFormat = new Intl.NumberFormat(\"fr-FR\").format","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1133,"value":"resultats_par_section = sections.map(d => d.toLowerCase()).map(d => ({\n section: d,\n presents: lycee[0]['presents_' + d],\n taux_reu: lycee[0]['taux_reu_' + d],\n va_reu: lycee[0]['va_reu_' + d],\n taux_men: lycee[0]['taux_men_' + d],\n va_men: lycee[0]['va_men_' + d],\n})).filter(d => Object.values(d).slice(1).some(x => x !== null))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1214,"value":"resultats_par_section_et_par_an = \n sections.map(d => d.toLowerCase())\n .flatMap(d => \n lycee.flatMap(l => ([\n {\n section: d.toUpperCase(),\n year: new Date(l.annee).getFullYear(), // TODO: fix timezone issue between France and US\n metric: 'reussite',\n taux: parseInt(l['taux_reu_' + d]),\n va: isNaN(l['va_reu_' + d]) ? 0 : parseInt(l['va_reu_' + d]),\n },\n {\n section: d.toUpperCase(),\n year: new Date(l.annee).getFullYear(), // TODO: fix timezone issue between France and US\n metric: 'mentions',\n taux: parseInt(l['taux_men_' + d]),\n va: isNaN(l['va_men_' + d]) ? 0 : parseInt(l['va_men_' + d]),\n }\n ])\n )\n ).filter(d => Object.values(d).slice(2).some(x => !isNaN(x)))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":900,"value":"mutable lyceeSelectionne = null;","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1380,"value":"$37","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1438,"value":"SELECT *\nFROM \"annuaire-lycees\"\nWHERE identifiant_de_l_etablissement = ${search[lyceeSelectionne].uai}\n","pinned":false,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"lyceeAnnuaire","database":"annuaire-lycees.parquet"},{"id":1501,"value":"SELECT enseignements, langues \n FROM \"langues-lycees\" \n WHERE uai = ${search[lyceeSelectionne]?.uai}","pinned":false,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"langues","database":"langues-lycees.parquet"},{"id":1507,"value":"languesParLycee = Object.fromEntries(Array.from(d3.group(langues, d => d.enseignements)).map(d => [d[0],d[1].map(x => x.langues)]))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1541,"value":"SELECT *\n FROM \"fr-en-ips-lycees-ap2023\"\nWHERE uai = ${search[lyceeSelectionne].uai} \n AND rentree_scolaire = '2024-2025'","pinned":false,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"ips","database":"fr-en-ips-lycees-ap2023.parquet"},{"id":2206,"value":"ipsdb = DuckDBClient.of({ips: FileAttachment(\"fr-en-ips-lycees-ap2023.parquet\")});\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2228,"value":"SELECT \n uai, \n ips_voie_gt, \n PERCENT_RANK() OVER (ORDER BY ips_voie_gt::DOUBLE) as ips_voie_gt_percentile, \n ips_voie_pro,\n PERCENT_RANK() OVER (ORDER BY ips_voie_pro::DOUBLE) as ips_voie_pro_percentile, \n ips_post_bac, \n PERCENT_RANK() OVER (ORDER BY ips_post_bac::DOUBLE) as ips_post_bac_percentile, \n ips_etab,\n PERCENT_RANK() OVER (ORDER BY ips_etab::DOUBLE) as ips_etab_percentile, \nFROM ips\nWHERE ips_voie_gt <> 'NS' AND ips_voie_pro <> 'NS' AND ips_etab <> 'NS' AND ips_post_bac <> 'NS'","pinned":false,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"ips_percentiles","database":"var:ipsdb"},{"id":1957,"value":"WITH test AS (SELECT\n secteur,\n rentree_scolaire,\n 'ips_voie_gt' AS metric,\n ips_voie_gt AS value\nFROM \"fr-en-ips-lycees-ap2023\"\n\nUNION ALL\nSELECT\n secteur,\n rentree_scolaire,\n 'ips_voie_pro' AS metric,\n ips_voie_pro AS value\nFROM \"fr-en-ips-lycees-ap2023\"\nUNION ALL\nSELECT\n secteur,\n rentree_scolaire,\n 'ips_post_bac' AS metric,\n ips_post_bac AS value\nFROM \"fr-en-ips-lycees-ap2023\"\nUNION ALL\nSELECT\n secteur,\n rentree_scolaire,\n 'ips_etab' AS metric,\n ips_etab AS value\nFROM \"fr-en-ips-lycees-ap2023\"\n) \nselect \n secteur,\n -- CASE metric\n -- WHEN 'ips_etab' THEN 'Etablissement'\n -- WHEN 'ips_voie_gt' THEN 'Voie Generale & Technique'\n -- WHEN 'ips_voie_pro' THEN 'Voie Pro'\n -- WHEN 'ips_post_bac' THEN 'Post Bac'\n -- END AS \n metric,\n try_cast(value as DOUBLE) AS value\nfrom test\nWHERE rentree_scolaire = ${year.toFixed(0)} || '-' || ${(year+1).toFixed(0)}\n AND value is not null\n","pinned":false,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"ips_values","database":"fr-en-ips-lycees-ap2023.parquet"},{"id":2107,"value":"ips_labels = new Map([[\"ips_voie_gt\",\"Voie Gnle & Technique\"],[\"ips_voie_pro\",\"Voie Pro\"],[\"ips_etab\",\"Etablissement\"],[\"ips_post_bac\",\"Post bac\"]])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1805,"value":"keyMetricValues = search.map(d => parseInt(d[keyMetric])).filter(d => d !== null && !isNaN(d))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1878,"value":"keyMetric = metric + '_' + section.toLowerCase()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1335,"value":"## TODO\n- Finish rankings incl. rank by dpt, academie, prive/public ([Le Figaro etudiant](https://etudiant.lefigaro.fr/article/lycee/comment-sont-construits-les-classements-des-colleges-et-des-lycees-du-figaro-etudiant-20240319/), [L'Etudiant](https://www.letudiant.fr/classements/classement-lycees.html), [BFM](https://public.flourish.studio/visualisation/22320271/), [L'internaute](https://www.linternaute.com/ville/lycee/lestelle-betharram/ville-64339#methodologie), [Le Parisien](https://www.leparisien.fr/etudiant/orientation/palmares-lycees/))\n- Rang dans le dpt, academie, France\n- Improve map selection\n- Improve input selection\n- Fix insets\n- Fix timezone bug\n- Fix Corsica bug","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"}],"files":"$W38","stdlib":"1"}} 30:"$2f:body"