Calcul de l’indicateur
Formule de calcul SQL
SELECT
communes,
qpv,
annee_labellisation
FROM cites_educatives
ORDER BY
communes
Format des données
{
"type": "array",
"items": {
"type": "object",
"properties": {
"communes": {
"title": "Communes",
"type": "string"
},
"qpv": {
"title": "Quartiers",
"type": "array",
"items": {
"type": "string"
}
},
"annee_labellisation": {
"title": "Année de labellisation",
"type": "integer"
}
}
}
}