Explorateur data copie privée

2b:null 2c:["$","title",null,{"children":"CP Tracker | Alain Ottenheimer | Observable"}] 31:Tad0,grid = htl.html` Explorateur data copie privée

SELECTEUR BENEFICIAIRES

MONTANTS PAR COLLECTEUR

NOMBRE D'ACTIONS PAR BENEFICIAIRE (Top 30)

MONTANTS PAR TYPE D'OEUVRES

MONTANTS PAR ANNEE

MONTANTS PAR TYPE D'AIDES

LISTE DES ACTIONS SELECTIONNEES

Collecteur	Année	Aide	Bénéficiaire	Projet	Montant	Oeuvre

`32:T5c9,function montantParCollecteurFit() { const all = data.groupAll(); const collecteur = data.dimension((d) => d["collecteur"]); const collecteurGroup = collecteur.group(); const reducer_collecteur = reductio() .count(true) .sum((d) => +d["montant"])(collecteurGroup); const montantParCollecteurChart = new dc.RowChart("#collecteur-chart") .width(250) .height(400) .margins({ top: 0, right: 20, bottom: 40, left: 5 }) .dimension(collecteur) .group(collecteurGroup) .valueAccessor((d) => d.value.sum) .label(function (d) { return d.value.sum < 1000 ? d.key + " - " + numberFormat(d.value.sum) + " €" : d.key + " - " + numberFormat(d.value.sum / 1000) + " k€"; }) .title(function (d) { return d.value.sum < 1000 ? d.key + " - " + numberFormat(d.value.sum) + " €" : d.key + " - " + numberFormat(d.value.sum / 1000) + " k€"; }) .elasticX(true) .ordering(function (d) { return -d.value.sum; }) .colors( d3 .scaleOrdinal() .range([ "#a6cee3", "#1f78b4", "#b2df8a", "#33a02c", "#fb9a99", "#e31a1c", "#fdbf6f", "#ff7f00", "#cab2d6", "#6a3d9a", "#ffff99", "#b15928" ]) ) .gap(3) .xAxis() .ticks(2) .tickFormat(numberFormat); return montantParCollecteurChart; }33:T46b,function montantParAideFit() { const all = data.groupAll(); const aide = data.dimension((d) => d["aide"]); const aideGroup = aide.group(); const reducer_aide = reductio() .count(true) .sum((d) => +d["montant"])(aideGroup); const montantParAideChart = new dc.RowChart("#aide-chart") .width(300) .height(200) .margins({ top: 0, right: 45, bottom: 40, left: 5 }) .dimension(aide) .group(aideGroup) .valueAccessor((d) => d.value.sum) .label(function (d) { return d.value.sum < 1000 ? d.key + " - " + numberFormat(d.value.sum) + " €" : d.key + " - " + numberFormat(d.value.sum / 1000) + " k€"; }) .title(function (d) { return d.value.sum < 1000 ? d.key + " - " + numberFormat(d.value.sum) + " €" : d.key + " - " + numberFormat(d.value.sum / 1000) + " k€"; }) .elasticX(true) .ordering(function (d) { return -d.value.sum; }) .colors(d3.scaleOrdinal().range(["#74a9cf"])) .gap(12) .xAxis() .ticks(2) .tickFormat(numberFormat); return montantParAideChart; }34:T5cf,function montantParOeuvreFit() { const all = data.groupAll(); const oeuvre = data.dimension((d) => d["oeuvre"]); const oeuvreGroup = oeuvre.group(); const reducer_oeuvre = reductio() .count(true) .sum((d) => +d["montant"])(oeuvreGroup); const montantParOeuvreChart = new dc.RowChart("#oeuvre-chart") .width(300) .height(400) .margins({ top: 0, right: 45, bottom: 40, left: 20 }) .dimension(oeuvre) .group(oeuvreGroup) .valueAccessor((d) => d.value.sum) .label(function (d) { return d.value.sum < 1000 ? d.key + " - " + numberFormat(d.value.sum) + " €" : d.key + " - " + numberFormat(d.value.sum / 1000) + " k€"; }) .title(function (d) { return d.value.sum < 1000 ? d.key + " - " + numberFormat(d.value.sum) + " €" : d.key + " - " + numberFormat(d.value.sum / 1000) + " k€"; }) .elasticX(true) .ordering(function (d) { return -d.value.sum; }) //.colors(d3.scaleOrdinal().range(["#74a9cf"])) .colors( d3 .scaleOrdinal() .range([ "#a6cee3", "#1f78b4", "#b2df8a", "#33a02c", "#fb9a99", "#e31a1c", "#fdbf6f", "#ff7f00", "#cab2d6", "#6a3d9a", "#ffff99", "#b15928" ]) ) .gap(8) .xAxis() .ticks(2) .tickFormat(numberFormat); return montantParOeuvreChart; }35:T5de,function montantParDateFit() { const all = data.groupAll(); const date = data.dimension((d) => d["annee"]); const dateGroup = date.group(); const reducer_date = reductio() .count(true) .sum((d) => +d["montant"])(dateGroup); const montantParDateChart = new dc.BarChart("#date-chart") .width(250) .height(200) .margins({ top: 10, right: 50, bottom: 50, left: 70 }) .dimension(date) .group(dateGroup) .valueAccessor((d) => d.value.sum) .brushOn(false) .elasticY(true) .y(d3.scaleLinear().domain([0, 1200])) .xUnits(dc.units.ordinal) .colors(d3.scaleOrdinal().range(["#feb24c"])) .x(d3.scaleOrdinal()) .renderLabel(false) .centerBar(0) .gap(10) .round((n) => d3.round(n)) .alwaysUseRounding(true) .yAxisLabel("En €") .renderHorizontalGridLines(true) .title(function (d) { return d.value.sum < 1000 ? d.key + " - " + numberFormat(d.value.sum) + " €" : d.key + " - " + numberFormat(d.value.sum / 1000) + " k€"; }); montantParDateChart.yAxis().tickFormat(function (s) { return s + ""; }); montantParDateChart.renderlet(function (montantParDateChart) { montantParDateChart .selectAll("g.x text") .attr("transform", "translate(-22,15) rotate(315) "); }); montantParDateChart.xAxis().ticks(6); //.tickFormat(d3.format("0f")); montantParDateChart.yAxis().ticks(5).tickFormat(numberFormat); return montantParDateChart; }36:T680,function numberParBeneficiaireFit() { const all = data.groupAll(); const beneficiaire = data.dimension((d) => d["beneficiaire"]); const beneficiaireGroup = beneficiaire.group(); const reducer_beneficiaire = reductio() .count(true) .sum((d) => +d["montant"])(beneficiaireGroup); const numberParBeneficiaireChart = new dc.RowChart("#beneficiaire-chart") .width(350) .height(600) .margins({ top: 0, right: 20, bottom: 40, left: 5 }) .dimension(beneficiaire) .group(beneficiaireGroup) .valueAccessor((d) => d.value.count) .label(function (d) { return d.value.sum < 1000 ? d.key + " - " + d.value.count + " actions - Total : " + numberFormat(d.value.sum) + " €" : d.key + " - " + d.value.count + " actions - Total : " + numberFormat(d.value.sum / 1000) + " k€"; }) .title(function (d) { return d.value.sum < 1000 ? d.key + " - " + d.value.count + " actions - Total : " + numberFormat(d.value.sum) + " €" : d.key + " - " + d.value.count + " actions - Total : " + numberFormat(d.value.sum / 1000) + " k€"; }) .elasticX(true) .cap(30) .othersGrouper(false) .ordering(function (d) { return -d.value.count; }) .colors(d3.scaleOrdinal().range(["#74a9cf"])) .gap(3) .xAxis() .ticks(2) .tickFormat(numberFormat); return numberParBeneficiaireChart; }37:[{"id":"7ab121f9f937a58eb792c744b3117130cf0c2298161eb90e590c202dc047d597c47b43c15ab5aefe2e8c46f178ded10fd01ff184fcf947a582cf951826481346","href":"https://static.observableusercontent.com/files/7ab121f9f937a58eb792c744b3117130cf0c2298161eb90e590c202dc047d597c47b43c15ab5aefe2e8c46f178ded10fd01ff184fcf947a582cf951826481346","name":"actions-culturelles-soutenues.csv","type":"text/csv","lastModified":1696942139283.978,"size":9853096},{"id":"bb3933f65ec053bd8ee0a0cf96d37c0c2c1c51e0e8c0bc6c4485e711468f0d0c43a99b48bc167c41e08196f670d1e06f7a0ecf79f88ea32dff7a72d4e840a495","href":"https://static.observableusercontent.com/files/bb3933f65ec053bd8ee0a0cf96d37c0c2c1c51e0e8c0bc6c4485e711468f0d0c43a99b48bc167c41e08196f670d1e06f7a0ecf79f88ea32dff7a72d4e840a495","name":"collecteurs.csv","type":"text/csv","lastModified":1696942139283.978,"size":3347}] 2f:{"id":"566a8a1ee156cd84","slug":"cp-tracker","title":" CP Tracker","thumbnail":"0ea00f1d07ba8c6f0a76f185d1d94bf73ea3997f74dbacd0e0b7788f795bfbf0","access_level":"public","create_time":"$D2023-10-10T12:48:59.283Z","update_time":"$D2023-12-21T11:16:56.770Z","view_time":null,"first_public_time":"$D2023-12-21T11:16:35.089Z","fork":{"id":"a66cf043c522e364","slug":"cp-tracker","title":" CP Tracker","owner":{"id":"356546a635010146","login":"tdvz","name":"ToulouseDataviz"}},"stars":0,"starred":false,"owner":{"type":"team","id":"8abb31dbb05a1a94","login":"aotten","name":"Alain Ottenheimer","avatar_url":"https://avatars-next.observableusercontent.com/c908270df8ca89015b1f236bb9cc9fb2d79a649dbedef18f6cf2290d288650c3","tier":"starter_2024"},"version":6694,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"39f8227195038a1f","login":"aotten","name":"Alain Ottenheimer","avatar_url":"https://avatars-next.observableusercontent.com/c908270df8ca89015b1f236bb9cc9fb2d79a649dbedef18f6cf2290d288650c3","tier":null}],"members":[{"type":"individual","id":"39f8227195038a1f","login":"aotten","name":"Alain Ottenheimer","avatar_url":"https://avatars-next.observableusercontent.com/c908270df8ca89015b1f236bb9cc9fb2d79a649dbedef18f6cf2290d288650c3","tier":null,"role":"editor"},{"type":"team","id":"8abb31dbb05a1a94","login":"aotten","name":"Alain Ottenheimer","avatar_url":"https://avatars-next.observableusercontent.com/c908270df8ca89015b1f236bb9cc9fb2d79a649dbedef18f6cf2290d288650c3","tier":"starter_2024","role":"viewer"}],"comments":[],"custom_thumbnail":true,"trashed":false,"subscribed":null,"forks":0,"collection":{"id":"635978eee692106d","slug":"projets","title":"1- Projets","owner":{"id":"8abb31dbb05a1a94","login":"aotten","name":"Alain Ottenheimer"}},"type":"notebook","body":{"title":" CP Tracker","cells":[{"id":4,"value":"note = md`\n# CP Tracker\n## Explorateur des données de la copie privée.\n\nVersion 1.0\n\nSee note 1 for more data informations ^{[[1](#footnote1)]} \n\nSee note 2 for references ^{[[2](#footnote2)]} \n\nsee note 3 for to do list ^{[[3](#footnote3)]}\n\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":6283,"value":"md`## EXPLORATEUR `","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":2513,"value":"md``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5697,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5001,"value":"md`## DATA TABLE `","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5214,"value":"Liste des actions culturelles soutenues ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":5203,"value":"viewof table_actions = Inputs.table(actions, {\n width: {\n annee: 50,\n Collecteur: 100\n },\n align: {\n montant: \"right\"\n },\n rows: 10,\n maxWidth: width,\n multiple: false,\n layout: \"fixed\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5224,"value":"Liste des organismes collecteurs ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":5219,"value":"//viewof table_collecteurs = Inputs.table(collecteurs)\n\nviewof table_collecteurs = Inputs.table(collecteurs, {\n width: {\n date_creation: 70,\n Collecteur: 100\n },\n align: {\n nb_membres: \"right\",\n date_creation: \"right\",\n nb_membres_annee: \"right\"\n },\n header: {\n date_creation: \"Création\",\n nb_membres_annee: \"Année\"\n },\n rows: 10,\n maxWidth: width,\n multiple: false,\n layout: \"fixed\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5052,"value":"md`\n## DATA \n\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5207,"value":"actions = FileAttachment(\"actions-culturelles-soutenues.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5217,"value":"collecteurs = FileAttachment(\"collecteurs.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5965,"value":"data = crossfilter(actions)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5686,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5689,"value":"montantParCollecteurChart = montantParCollecteurFit()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5719,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5725,"value":"montantParAideChart = montantParAideFit()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5744,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5746,"value":"montantParOeuvreChart = montantParOeuvreFit()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5766,"value":"function beneficiaireSelecteurFit() {\n const all = data.groupAll();\n const beneficiaire = data.dimension((d) => d[\"beneficiaire\"]);\n const beneficiaireGroup = beneficiaire.group();\n\n const selecteurBeneficiaire = new dc.SelectMenu(\"#selecteur-beneficiaire\")\n .dimension(beneficiaire)\n .group(beneficiaireGroup)\n .controlsUseVisibility(true)\n .promptText(\"Tous\");\n return selecteurBeneficiaire;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5780,"value":"selecteurBeneficiaire = beneficiaireSelecteurFit()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5870,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5872,"value":"montantParDateChart = montantParDateFit()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":6348,"value":"$36","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":6353,"value":"numberParBeneficiaireChart = numberParBeneficiaireFit()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":6092,"value":"function dataTableFit() {\n const all = data.groupAll();\n const date = data.dimension((d) => d[\"annee\"]);\n const dateGroup = date.group();\n\n const dataTable = new dc.DataTable(\"#table-chart, .dc-data-table\")\n .dimension(date)\n .group((d) => \"\")\n .size(400) //.size(Infinity)\n .columns([\n (d) => d.collecteur,\n (d) => d.annee,\n (d) => d.aide,\n (d) => d.beneficiaire,\n (d) => d.projet,\n (d) => d.montant,\n (d) => d.oeuvre\n ])\n .sortBy((d) => d.montant)\n .order(d3.ascending);\n return dataTable;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":6098,"value":"dataTableChart = dataTableFit()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5072,"value":"md`\n## CONFIGURATION \n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5730,"value":"function createView(options = {}) {\n const sub = d3.create(\"div\");\n if (options.title) sub.append(\"h4\").html(options.title);\n return { container: sub.node(), view: sub.append(\"div\").node() };\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5913,"value":"update(\n montantParCollecteurChart,\n montantParAideChart,\n montantParOeuvreChart,\n selecteurBeneficiaire,\n montantParDateChart,\n dataTableChart,\n numberParBeneficiaireChart\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5732,"value":"function update() {\n dc.renderAll();\n dc.filterAll();\n dc.renderAll();\n\n return html`Updated ${d3.timeFormat(\"%Y-%m-%dT%H:%M:%S\")(\n Date.now()\n )}`;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":6575,"value":"locale = d3.formatLocale({\n decimal: \",\",\n thousands: \" \",\n grouping: [3]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":6583,"value":"numberFormat = locale.format(\",.0f\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5078,"value":"md`\n## IMPORT \n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5116,"value":"d3 = require(\"d3@6\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5200,"value":"dc = require(\"dc\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5228,"value":"crossfilter = require(\"crossfilter2\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5274,"value":"reductio = require(\"https://bundle.run/reductio@1.0.0\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5123,"value":"md`\n## NOTES \n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5129,"value":"footnote = (referencingCellName, number, text) => {\n return html`
^ ${text}
`;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5127,"value":"footnote1 = footnote(\"note\", 1, \"Data informations\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":6270,"value":"Les données proviennent du site : copie privée.org","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined"},{"id":5132,"value":"footnote2 = footnote(\"note\", 2, \"References\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5682,"value":"1. https://observablehq.com/@gabrielsuassuna/d3-com-crossfilter-e-dc-js-parte-2\n2. https://observablehq.com/@kentarotakahira/dcjs-nasdaq\n3. https://observablehq.com/@tophtucker/differences-between-html-and-htl-html","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":5135,"value":"footnote3 = footnote(\"note\", 3, \"To Do List\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":6291,"value":"- Mettre un compteur d'enregistrements\n- Faire un histogramme des dépenses\n- Améliorer le scroll\n- Ajouter les montants par type d’œuvre en %\n- body{background-color: #fff;}","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":2528,"value":"md``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1862,"value":"md``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":2285,"value":"md``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"}],"files":"$W37","stdlib":"1","titling":"auto"}} 30:"$2f:body"