2e:null 2f:["$","title",null,{"children":"Regional Normalized Difference Vegetation Index (NDVI) - McKinsey Space Miners | Fotis Zapantis | Observable"}] 34:T62b,async function shapefileZipToGeoJSON( zipBuffer, { encoding = "windows-1253" } = {} ) { // 1) Unzip in memory const files = fflate.unzipSync( zipBuffer instanceof Uint8Array ? zipBuffer : new Uint8Array(zipBuffer) ); const names = Object.keys(files); if (!names.length) throw new Error("ZIP is empty."); // 2) Find a matching .shp and .dbf (case-insensitive), preferring same basename const byExt = (ext) => names.filter((n) => n.toLowerCase().endsWith(ext)); const shpNames = byExt(".shp"); const dbfNames = byExt(".dbf"); if (!shpNames.length || !dbfNames.length) { throw new Error("ZIP must contain at least one .shp and one .dbf."); } // Try to match basenames (ignore directory and extension) const base = (p) => p .replace(/^.*[\\/]/, "") .replace(/\.[^.]+$/, "") .toLowerCase(); let shpName = shpNames[0], dbfName = dbfNames[0]; // Attempt best match: pick the .dbf sharing the .shp's basename const match = dbfNames.find((d) => base(d) === base(shpName)); if (match) dbfName = match; // 3) Turn Uint8Array files into ReadableStreams for shapefile.open const toStream = (u8) => new Response(u8).body; const shpStream = toStream(files[shpName]); const dbfStream = toStream(files[dbfName]); // 4) Open with explicit encoding and collect features const src = await shapefile.open(shpStream, dbfStream, { encoding }); const features = []; for (;;) { const { done, value } = await src.read(); if (done) break; features.push(value); } return { type: "FeatureCollection", features }; }35:[{"id":"1dc886ba9fd867e4ded73b541f5e4641a1a0e11940a48bd0e3b6a9745cab1d6dcb2ccfd2f2f787fd503db52ebe930191c28697268b26372e955eee2a916475a0","href":"https://static.observableusercontent.com/files/1dc886ba9fd867e4ded73b541f5e4641a1a0e11940a48bd0e3b6a9745cab1d6dcb2ccfd2f2f787fd503db52ebe930191c28697268b26372e955eee2a916475a0","name":"Space-Miners-McK.jpg","type":"image/jpeg","lastModified":1761576040770.648,"size":28546},{"id":"f9fed7c69b6b21d15f82c0559ed59a4e40987e7c85a30978179e6a901f0a3c42cec980cee30ebe35dc941cbc70e60c3d6d2623b4481bf8d9cacf16ed88969e89","href":"https://static.observableusercontent.com/files/f9fed7c69b6b21d15f82c0559ed59a4e40987e7c85a30978179e6a901f0a3c42cec980cee30ebe35dc941cbc70e60c3d6d2623b4481bf8d9cacf16ed88969e89","name":"grc_adm_2025_ab_adm2.zip","type":"application/zip","lastModified":1761566757442.811,"size":394010},{"id":"5386de550cd8dc8c92367681a4184e12643ee77c1738d707bab5888c937d23573aa3d1530d6e89e11f9446cd5b73f23d94cdc0671af4351491787a157c4dacc3","href":"https://static.observableusercontent.com/files/5386de550cd8dc8c92367681a4184e12643ee77c1738d707bab5888c937d23573aa3d1530d6e89e11f9446cd5b73f23d94cdc0671af4351491787a157c4dacc3","name":"We Are Global Changemakers.jpg","type":"image/jpeg","lastModified":1761566757442.811,"size":173880},{"id":"67c74708dc73ca33653dcf0252ecef721415bda183b1bfdb9d851a03cc886e98b0561ba4be4084ba0a5e5a962df2a72fe129608a8f4133f0db379ac66ef9d277","href":"https://static.observableusercontent.com/files/67c74708dc73ca33653dcf0252ecef721415bda183b1bfdb9d851a03cc886e98b0561ba4be4084ba0a5e5a962df2a72fe129608a8f4133f0db379ac66ef9d277","name":"grc-ndvi-subnat-5ytd@3.csv","type":"text/csv","lastModified":1761579159293.545,"size":1282759}] 32:{"id":"f3175a838d7afe5e","slug":"reg-normalized-difference-vegetation-index-ndvi","title":"Regional Normalized Difference Vegetation Index (NDVI) - McKinsey Space Miners","thumbnail":"163fe492474620ab90f69e2e225b158e704713f55c140d6ec7a9bf39b07352c0","access_level":"public","create_time":"$D2025-10-27T12:05:57.442Z","update_time":"$D2025-11-08T11:07:27.361Z","view_time":null,"first_public_time":"$D2025-10-27T22:17:01.652Z","has_unpublished_edits":null,"fork":{"id":"291d0f48ef86e432","slug":"regional-rainfall-indicators","title":"Regional Rainfall Indicators (CHIRPS-GEFS) - McKinsey Forward Learners","owner":{"id":"1a8df8d954834dc2","login":"fotisz","name":"Fotis Zapantis"}},"stars":0,"starred":false,"owner":{"type":"team","id":"1a8df8d954834dc2","login":"fotisz","name":"Fotis Zapantis","avatar_url":"https://avatars-next.observableusercontent.com/901e545cdb3cac06c4e839534bbc428dfeaf42076ff667a94c51a36ffa05a710","tier":"starter_2024"},"version":1329,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"acd5a464e612f2ce","login":"fotisz","name":"Fotis Zapantis","avatar_url":"https://avatars-next.observableusercontent.com/15771ec342f0d7ed8668e8ab4d7b9e0ec698cf2903a9002e4ac0c9b5f5178a99","tier":null}],"members":[{"type":"individual","id":"acd5a464e612f2ce","login":"fotisz","name":"Fotis Zapantis","avatar_url":"https://avatars-next.observableusercontent.com/15771ec342f0d7ed8668e8ab4d7b9e0ec698cf2903a9002e4ac0c9b5f5178a99","tier":null,"role":"editor"},{"type":"team","id":"1a8df8d954834dc2","login":"fotisz","name":"Fotis Zapantis","avatar_url":"https://avatars-next.observableusercontent.com/901e545cdb3cac06c4e839534bbc428dfeaf42076ff667a94c51a36ffa05a710","tier":"starter_2024","role":"viewer"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":3,"collection":null,"type":"notebook","body":{"title":"Regional Normalized Difference Vegetation Index (NDVI) - McKinsey Space Miners","cells":[{"id":0,"value":"# Regional Normalized Difference Vegetation Index (NDVI) - McKinsey Space Miners","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1016,"value":"_For more information and up to date analysis please check: https://fotioszapantis.podia.com/nautilus-the-making-of_","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":738,"value":"This dataset contains dekadal NDVI indicators computed from **[NASA's Moderate Resolution Imaging Spectroradiometer (MODIS)](https://modis.gsfc.nasa.gov/)** collection 6.1 from the **Aqua and Terra satellite** aggregated by sub-national administrative units (regions).","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1028,"value":"spaceMinersMck = FileAttachment(\"Space-Miners-McK.jpg\").image()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":238,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":417,"value":"import { SummaryTable } from \"@observablehq/summary-table\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":430,"value":"viewof summary_data = SummaryTable(grcRainfallReg5ytd3, {\n label: \"NDVI Normalised Difference Vegetation Index [.3,.8]\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":742,"value":"**Included indicators are (for each dekad):**\n\n - _10 day NDVI_ (**vim**)\n - _NDVI long term average_ (**vim_lta**)\n - _10 day NDVI anomaly [%] _(**viq**)\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":745,"value":"The administrative units used for aggregation are based on **WFP (UN World Food Programme)** data and contain a Pcode reference attributed to each unit. The number of input pixels used to create the aggregates, is provided in the n_pixels column. ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":197,"value":"archive = FileAttachment(\"grc_adm_2025_ab_adm2.zip\").arrayBuffer()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":200,"value":"greeceRegions = shp(archive)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":225,"value":"countiesEPSG4326 = greeceRegions","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":15,"value":"Plot.plot({\n // Initialize the plot\n projection: { type: \"mercator\", domain: countiesEPSG4326GR }, // Set the projection\n width,\n marks: [\n Plot.geo(countiesEPSG4326GR, { fill: \"lightgray\", stroke: \"darkgray\" }), // Add the county boundaries\n Plot.geo(\n countiesEPSG4326GR,\n Plot.pointer(Plot.centroid({ fill: \"yellow\" }))\n ),\n Plot.dot(\n countiesEPSG4326GR.features,\n Plot.centroid({ fill: \"red\", stroke: \"white\" })\n ),\n Plot.tip(\n countiesEPSG4326GR.features,\n Plot.pointer(Plot.centroid({ title: (d) => d.properties.ADM2_EN }))\n )\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":275,"value":"countiesEPSG4326GR = shapefileZipToGeoJSON(archive)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":121,"value":"countiesTable = bertin.properties.table(countiesEPSG4326)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":179,"value":"viewof search = Inputs.search(countiesTable)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":171,"value":"Inputs.table(countiesTable)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1101,"value":"viewof startdate = Inputs.datetime({\n label: \"Start Date\",\n submit: true,\n min: \"2019-12-31\",\n max: \"2025-11-01\",\n description: \"Only dates within the past 5 calendar years to date are allowed\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1119,"value":"startDate = startdate ?? new Date()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1106,"value":"viewof enddate = Inputs.datetime({\n label: \"End Date\",\n submit: true,\n min: \"2019-12-31\",\n max: \"2025-11-01\",\n description: \"Only dates within the past 5 calendar years to date are allowed\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1122,"value":"endDate = enddate ?? new Date()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1301,"value":"luxonstartDate = DateTime.fromJSDate(startDate).toUTC()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1311,"value":"luxonstartDate.toFormat(\"dd-MM-yyyy\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1303,"value":"luxonendDate = DateTime.fromJSDate(endDate).toUTC()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1316,"value":"luxonendDate.toFormat(\"dd-MM-yyyy\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1128,"value":"timeScale = d3.scaleTime()\n .domain([startdate, enddate])\n\t.range([0, numberOfDays])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1130,"value":"numberOfDays = d3.timeDay.count(startdate, enddate)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1237,"value":"DateTime = luxon.DateTime","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":464,"value":"viewof selectAdministration = Inputs.select(\n grcRainfallReg5ytd3.map((d) => d.adm2_name),\n { label: \"Select Administration:\", unique: true }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":957,"value":"filteredData = grcNDVIReg5ytd.filter((d) => {\n if (selectAdministration === d.adm2_name) {\n return true;\n }\n return false;\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1278,"value":"dataParsed = filteredData.filter(\n (d) =>\n d.date >= luxonstartDate.toFormat(\"dd-MM-yyyy\") &&\n d.date <= luxonendDate.toFormat(\"dd-MM-yyyy\")\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":445,"value":"Plot.plot({\n marginRight: 10,\n marginLeft: 60,\n x: { label: \"Vegetation Index Median [.3,.8]\", inset: 10 },\n y: { inset: 10 },\n width,\n grid: true,\n color: { legend: true },\n marks: [\n Plot.frame(),\n Plot.crosshair(filteredData, { x: \"vim\", y: \"date\" }),\n Plot.dot(filteredData, {\n x: \"vim\",\n y: \"date\",\n fx: \"adm_id\",\n type: \"log\",\n fill: \"green\",\n tip: true\n })\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":22,"value":"// countiesEPSG4326 = fetch(\"https://geodata.gov.gr/geoserver/wfs/?service=WFS&version=1.0.0&request=GetFeature&typeName=geodata.gov.gr:d7f50467-e5ef-49ac-a7ce-15df3e2ed738&outputFormat=application/json&srsName=epsg:4326\").then((response) => response.json())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":538,"value":"grcNDVIReg5ytd = FileAttachment(\"grc-ndvi-subnat-5ytd@3.csv\").csv({\n typed: true\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":337,"value":"grcRainfallReg5ytd3 = await FileAttachment(\"grc-ndvi-subnat-5ytd@3.csv\").csv({typed: \"auto\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"grcRainfallReg5ytd3","database":"$undefined"},{"id":448,"value":"ndvi = aq // To use copied code replace \"data\" with your own variable\n .from(grcRainfallReg5ytd3)\n .select(\n \"date\",\n \"adm2_pcode\",\n \"adm2_name\",\n \"n_pixels\",\n \"vim\",\n \"vim_avg\",\n \"viq\"\n )\n .groupby(\"adm2_pcode\", \"adm2_name\")\n .rollup({ mean: (d) => op.mean(d[\"vim\"]) })\n .objects() // Uncomment to return an array of objects","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":651,"value":"ndviMAP = aq // To use copied code replace \"data\" with your own variable\n .from(ndvi)\n .select(\"adm2_pcode\", \"mean\")\n /*.filter((d) => op.match(d[\"n_pixels\"], \"final\"))*/\n .objects() // Uncomment to return an array of objects","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":680,"value":"matchedData = ndviMAP.map((data) => {\n const county = countiesTable.find((c) => c.ADM2_PCODE === data.adm2_pcode);\n return { ...data, ...county };\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":685,"value":"ndviMatch = new Map(\n matchedData.map(({ adm2_pcode, mean }) => [adm2_pcode, mean])\n)\n//broadband_access_2018 = new Map(us_broadband_2018.map(({id, broadband}) => [id, broadband]))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":622,"value":"uniquePCode = d3.groups(ndvi, (d) => d.adm2_pcode)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1267,"value":"**[NDVI always ranges from -1 to 1](https://custom-scripts.sentinel-hub.com/custom-scripts/sentinel-2/ndvi/)**.But there isn’t a distinct boundary for each type of land cover. For example, when you have **negative values**, it’s highly likely that it’s water. On the other hand, if you have an **NDVI value close to +1,** there’s a high possibility that it’s dense green leaves. But when **NDVI is close to zero**, there are likely no green leaves and it could even be an urbanized area.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":759,"value":"## 10 day normalised index vegetation index [-1,1] (NDVI)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":624,"value":"html`\n \n \n \n ${Array.from(\n uniquePCode,\n ([key, values]) => html`\n \n \n \n `\n )}\n

Admin (Pcode)	Mean Value
${key}	${values.map((d) => d.mean).join(\", \")}

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":637,"value":"Plot.plot({\n // Initialize the plot\n projection: { type: \"mercator\", domain: countiesEPSG4326GR }, // Set the projection\n width,\n color: {\n scheme: \"Greens\",\n unknown: \"#ddd\",\n label: \"NDVI (10 day 'greeness' [-1,1])\",\n reverse: false,\n legend: true\n },\n\n marks: [\n Plot.geo(\n countiesEPSG4326.features,\n Plot.centroid({\n fill: (d) => ndviMatch.get(d.properties.ADM2_PCODE),\n stroke: \"black\"\n })\n ),\n Plot.dot(\n countiesEPSG4326GR.features,\n Plot.centroid({ fill: \"red\", stroke: \"white\" })\n ),\n Plot.tip(\n countiesEPSG4326GR.features,\n Plot.pointer(Plot.centroid({ title: (d) => d.properties.ADM2_EN }))\n )\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":267,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":195,"value":"shp = require(\"https://unpkg.com/shpjs@latest/dist/shp.js\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":206,"value":"view = require(\"geoverview@1.2\").then((f) => f.view)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":247,"value":"shapefile = require(\"shapefile\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":249,"value":"fflate = import(\"https://cdn.skypack.dev/fflate?min\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":244,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":269,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1009,"value":"## Exploratory Data Analysis","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":394,"value":"Wrangler(ndvi)\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":848,"value":"Plot.plot({\n x: {\n label: \"10 day NDVI [-1,1] (vim)\",\n domain: [0.3, 0.8],\n interval: 0.01,\n tickFormat: (x) => x.toFixed(1),\n align: 0\n },\n y: {\n // week days\n /*domain: d3\n .utcDays(...d3.extent(filteredData, (d) => d.date))\n .filter((d) => d.getUTCDay() > 0 && d.getUTCDay() < enddate),\n // Monday ticks\n ticks: d3.utcMondays(...d3.extent(filteredData, (d) => d.date)),\n //tickFormat: \"%-m/%-d\",*/\n label: \"Date\"\n },\n width,\n marginLeft: 10,\n marginRight: 0,\n grid: true,\n color: { legend: true, scheme: \"YlGn\" },\n marks: [\n Plot.frame(),\n Plot.boxX(filteredData, {\n /*filter: (d) => selectAdministration.includes(d.adm2_code),*/\n x: \"vim\",\n y: \"date\",\n fx: \"pcode\",\n fill: \"pcode\"\n })\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1213,"value":"color = ({ domain: [-1, 0, 1], range: [\"#e41a1c\", \"#000000\", \"#4daf4a\"] })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1231,"value":"luxon = require(\"luxon@1/build/amd/luxon.js\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":167,"value":"bertin = require(\"bertin@latest\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":405,"value":"function formatDateUTC(date) {\n let day = date.getUTCDate();\n let month = date.getUTCMonth();\n let year = date.getUTCFullYear();\n return `${year}-${month + 1}-${day}`;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1227,"value":"function formatDate(date) {\n let day = date.getDate();\n let month = date.getMonth();\n let year = date.getFullYear();\n return `${year}-${month + 1}-${day}`;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":384,"value":"import { Wrangler, op } from \"@observablehq/data-wrangler\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1096,"value":"import { rangeSlider } from \"@mootari/range-slider\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":766,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":747,"value":"![We Are Global Changemakers.jpg](${await FileAttachment(\"We Are Global Changemakers.jpg\").url()})","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"}],"files":"$W35","stdlib":"1","titling":"auto"}} 33:"$32:body"