31:[{"id":"254a99fef9cfdc739794cf276a25ffce226b9d17d64789497bbed4935f1fda7d621149894d3a06e546f0e5c53beda2580db0166433ff2fac65397af1aa3627ea","href":"https://static.observableusercontent.com/files/254a99fef9cfdc739794cf276a25ffce226b9d17d64789497bbed4935f1fda7d621149894d3a06e546f0e5c53beda2580db0166433ff2fac65397af1aa3627ea","name":"countries-50m.json","type":"application/json","lastModified":1657394284039.118,"size":756420},{"id":"10e48b39632d911343800798e0c3f35dbb6a17a1c6576f915537ebb9648e803fcf40570f4fa90cb67445eb45d3916b90cc3ad5cdb853f52cdf60f888ffd9c843","href":"https://static.observableusercontent.com/files/10e48b39632d911343800798e0c3f35dbb6a17a1c6576f915537ebb9648e803fcf40570f4fa90cb67445eb45d3916b90cc3ad5cdb853f52cdf60f888ffd9c843","name":"cobalt_p_all.csv","type":"text/csv","lastModified":1657394471557.003,"size":537639},{"id":"fe2243bbc86ae78217b8547f181ef879bb65e9d66b281d31dc842bd38f426c169844be004645fce64c762be2885b86c585c546157f6ca46423e567c0b05be29f","href":"https://static.observableusercontent.com/files/fe2243bbc86ae78217b8547f181ef879bb65e9d66b281d31dc842bd38f426c169844be004645fce64c762be2885b86c585c546157f6ca46423e567c0b05be29f","name":"cobalt_r_all.csv","type":"text/csv","lastModified":1657394674037.718,"size":759300}] 2f:{"title":"Comtrade commodity flow sketches","cells":[{"id":0,"value":"md`# Comtrade commodity flow sketches`","pinned":false,"hidden":false,"mode":"ojs"},{"id":29,"value":"map = htl.html``","pinned":false,"hidden":false,"mode":"ojs"},{"id":4,"value":"projection = d3.geoEqualEarth()","pinned":true,"hidden":false,"mode":"ojs"},{"id":141,"value":"# Data processing","pinned":false,"hidden":false,"mode":"md"},{"id":121,"value":"cobalt_p_all = FileAttachment(\"cobalt_p_all.csv\").csv()","pinned":true,"hidden":false,"mode":"ojs"},{"id":127,"value":"cobalt_r_all = FileAttachment(\"cobalt_r_all.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs"},{"id":122,"value":"cobalt_report = d3\n .nest()\n .key(function (d) {\n return d.yr;\n })\n .key(function (d) {\n return d.rtTitle;\n })\n .entries(cobalt_r_all.filter((f) => f.pt3ISO != \"WLD\"))\n .map((m) => {\n m.key = parseInt(m.key);\n return m;\n })","pinned":false,"hidden":false,"mode":"ojs"},{"id":230,"value":"sample = cobalt_report_exports[0].values","pinned":true,"hidden":false,"mode":"ojs"},{"id":291,"value":"cobalt_partner_exports = d3\n .nest()\n .key(function (d) {\n return d.yr;\n })\n .key(function (d) {\n return d.source;\n })\n .entries(\n cobalt_p_all\n .filter((f) => f.rgDesc == \"Import\")\n .filter((f) => f.ptTitle != \"World\")\n .filter((f) => f.cmdCode != \"2605\")\n .map((m) => {\n let newobj = {};\n newobj.source = m.ptTitle;\n newobj.target = m.rtTitle;\n newobj.value = m.NetWeight;\n newobj.yr = m.yr;\n return newobj;\n })\n )","pinned":true,"hidden":false,"mode":"ojs"},{"id":200,"value":"cobalt_report_exports = d3\n .nest()\n .key(function (d) {\n return d.yr;\n })\n .key(function (d) {\n return d.source;\n })\n .entries(\n cobalt_r_all\n .filter((f) => f.rgDesc == \"Export\")\n .filter((f) => f.ptTitle != \"World\")\n .filter((f) => f.cmdCode != \"2605\")\n .map((m) => {\n let newobj = {};\n newobj.source = m.rtTitle;\n newobj.target = m.ptTitle;\n newobj.value = m.NetWeight;\n newobj.yr = m.yr;\n return newobj;\n })\n )\n // .map((m) => {\n // m.key = parseInt(m.key);\n // return m;\n // })","pinned":true,"hidden":false,"mode":"ojs"},{"id":256,"value":"comtradeChanges = Array.from(comtrade_countries).filter(\n (f) => !countries.has(f)\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":278,"value":"countryChanges = [\n \"Dem. Rep. Congo\",\n \"United States of America\",\n \"Vietnam\",\n \"Russia\",\n \"South Korea\",\n \"Other Asia, nes\",\n \"Macedonia\",\n \"Moldova\",\n \"Tanzania\",\n \"Hong Kong\",\n \"Laos\",\n \"Antigua and Barb.\",\n \"Norfolk Island\",\n \"Gibraltar\",\n \"North Korea\",\n \"Areas, nes\",\n \"eSwatini\",\n \"Cook Isds\",\n \"Bolivia\"\n]","pinned":false,"hidden":false,"mode":"ojs"},{"id":185,"value":"countries = new Set(\n world.objects.countries.geometries.map((w) => w.properties.name)\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":260,"value":"function changeCountryValue(obj, val1, val2) {\n if (obj.target == val1) {\n obj.target = val2;\n }\n return obj;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":281,"value":"sample[5].values.map((m) =>\n changeCountryValue(m, \"Dem. Rep. of the Congo\", \"DRC\")\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":266,"value":"sample","pinned":true,"hidden":false,"mode":"ojs"},{"id":237,"value":"pt_comtrade = Array.from(\n new Set(\n cobalt_r_all\n .filter((f) => f.rgDesc == \"Export\")\n .filter((f) => f.ptTitle != \"World\")\n .map((m) => m.ptTitle)\n )\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":244,"value":"rt_comtrade = Array.from(\n new Set(\n cobalt_r_all\n .filter((f) => f.rgDesc == \"Export\")\n .filter((f) => f.ptTitle != \"World\")\n .map((m) => m.rtTitle)\n )\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":246,"value":"comtrade_countries = new Set([...rt_comtrade, ...pt_comtrade])","pinned":true,"hidden":false,"mode":"ojs"},{"id":131,"value":"cobalt_partner = d3\n .nest()\n .key(function (d) {\n return parseInt(d.yr);\n })\n .key(function (d) {\n return d.ptTitle;\n })\n .entries(cobalt_r_all.filter((f) => f.pt3ISO != \"WLD\"))\n .map((m) => {\n m.key = parseInt(m.key);\n return m;\n })","pinned":false,"hidden":false,"mode":"ojs"},{"id":179,"value":"cobalt_report[19].values","pinned":true,"hidden":false,"mode":"ojs"},{"id":143,"value":"# Maps Implementation Stuff","pinned":false,"hidden":false,"mode":"md"},{"id":86,"value":"Many other projections are available. [Browse them here](https://observablehq.com/collection/@d3/d3-geo-projection).","pinned":false,"hidden":false,"mode":"md"},{"id":40,"value":"path = d3.geoPath(projection)","pinned":true,"hidden":false,"mode":"ojs"},{"id":25,"value":"height = {\n const [[x0, y0], [x1, y1]] = d3.geoPath(projection.fitWidth(width, outline)).bounds(outline);\n const dy = Math.ceil(y1 - y0), l = Math.min(Math.ceil(x1 - x0), dy);\n projection.scale(projection.scale() * (l - 1) / l).precision(0.2);\n return dy;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":22,"value":"outline = ({type: \"Sphere\"})","pinned":true,"hidden":false,"mode":"ojs"},{"id":114,"value":"graticule = d3.geoGraticule10()","pinned":true,"hidden":false,"mode":"ojs"},{"id":16,"value":"land = topojson.feature(world, world.objects.land)","pinned":true,"hidden":false,"mode":"ojs"},{"id":105,"value":"borders = topojson.mesh(world, world.objects.countries, (a, b) => a !== b)","pinned":true,"hidden":false,"mode":"ojs"},{"id":13,"value":"world = FileAttachment(\"countries-50m.json\").json()","pinned":true,"hidden":false,"mode":"ojs"},{"id":124,"value":"d3 = require(\"d3-collection@latest\", \"d3@5.9\")","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W31","stdlib":"1","titling":"auto"}