2f:[{"id":"c251971f83fa18eb24ceba68c8a89f4d0168069e7309ae1e88b035cbc007d70e8cb04cf09bf7398616ad07ff62113c9f8c97adb679464065ebde70bf624ac635","href":"https://static.observableusercontent.com/files/c251971f83fa18eb24ceba68c8a89f4d0168069e7309ae1e88b035cbc007d70e8cb04cf09bf7398616ad07ff62113c9f8c97adb679464065ebde70bf624ac635","name":"comptab_2023-09-19 07_54_comma_separated.csv","type":"text/csv","lastModified":1695113496916.019,"size":797923},{"id":"651f48ca28e4ea3f4c12e2da8a5b4160b5650325862ffbdb3088678b213859b67fc2ec42c7864496c0a159fb9561569d19420286598c3dfc0e92872f634e31bf","href":"https://static.observableusercontent.com/files/651f48ca28e4ea3f4c12e2da8a5b4160b5650325862ffbdb3088678b213859b67fc2ec42c7864496c0a159fb9561569d19420286598c3dfc0e92872f634e31bf","name":"eu_decisions_2023-09-19 13_10_comma_separated.csv","type":"text/csv","lastModified":1695125611305.38,"size":544889}] 2d:{"title":"CITE","cells":[{"id":0,"value":"# CITE","pinned":false,"hidden":false,"mode":"md"},{"id":16,"value":"trade_cite = await FileAttachment(\"comptab_2023-09-19 07_54_comma_separated.csv\").csv({typed: \"auto\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":33,"value":"vl.markBar()\n .data(trade_cite)\n .encode(\n vl.y().sum('Importer reported quantity').scale({ type:\"sqrt\"}).aggregate(\"sum\"),\n vl.x().fieldN('Order').sort(\"-y\"),\n vl.tooltip([\"Order\",{\n \"field\": 'Importer reported quantity',\n \"aggregate\": \"sum\",\n \"type\": \"quantitative\"\n }])\n )\n .render()","pinned":true,"hidden":false,"mode":"ojs"},{"id":269,"value":"countries","pinned":true,"hidden":false,"mode":"ojs"},{"id":266,"value":"import {countries} from \"@tophtucker/country-codes-and-flags\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":274,"value":"vl.lookupData(countries).fields([\"name\"]).key(\"two\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":259,"value":"vl.markBar()\n .data(\n trade_cite).transform(\n vl.lookup(\"Exporter\").from( // Lookup is even more advanced\n vl.lookupData(countries).key(\"two\").fields(\"name\")\n ).as(\"ExporterCountryName\"),\n vl.lookup(\"Origin\").from( // Lookup is even more advanced\n vl.lookupData(countries).key(\"two\").fields(\"name\")\n ).as(\"OriginCountryName\"),\n )\n .encode(\n vl.y().sum('Importer reported quantity').scale({ type:\"sqrt\"}).aggregate(\"sum\"),\n vl.x().fieldN('ExporterCountryName').sort(\"-y\"),\n vl.color().fieldN('OriginCountryName'),\n vl.tooltip([\"ExporterCountryName\",\"OriginCountryName\",{\n \"field\": 'Importer reported quantity',\n \"aggregate\": \"sum\",\n \"type\": \"quantitative\"\n }])\n )\n .render()","pinned":true,"hidden":false,"mode":"ojs"},{"id":112,"value":"vl.markBar()\n .data(trade_cite)\n .encode(\n vl.y().sum('Importer reported quantity').scale({ type:\"sqrt\"}).aggregate(\"count\"),\n vl.x().fieldN('Order').sort(\"-y\"),\n vl.tooltip([\"Order\",{\n \"field\": 'Importer reported quantity',\n \"aggregate\": \"count\",\n \"type\": \"quantitative\"\n }])\n )\n .render()","pinned":true,"hidden":false,"mode":"ojs"},{"id":128,"value":"# Sauroiden","pinned":false,"hidden":false,"mode":"md"},{"id":133,"value":"sauria_data = trade_cite.filter(d => d.Order === \"Sauria\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":122,"value":"vl.markBar()\n .data(sauria_data)\n .encode(\n vl.y().sum('Importer reported quantity').scale({ type:\"sqrt\"}).aggregate(\"count\"),\n vl.x().fieldN('Taxon').sort(\"-y\"),\n vl.tooltip([\"Class\",{\n \"field\": 'Importer reported quantity',\n \"aggregate\": \"count\",\n \"type\": \"quantitative\"\n }])\n )\n .render()","pinned":true,"hidden":false,"mode":"ojs"},{"id":135,"value":"sauria_species = await Promise.all(sauria_data.map(d => d.Taxon).filter((o,i,a) =>a.indexOf(o) === i ).map((s) => getSpecies(s)))","pinned":false,"hidden":false,"mode":"ojs"},{"id":176,"value":"sauria_species_images = (await Promise.all(sauria_species.map( s => getSpeciesFirstOccurrence(s.usageKey)))).map(d => d && d.media.length > 0 && d.media[0].identifier)","pinned":true,"hidden":false,"mode":"ojs"},{"id":185,"value":"html`

${sauria_species.map((s, i) => `

${s.scientificName}

${ '

`)}

`","pinned":true,"hidden":false,"mode":"ojs"},{"id":119,"value":"cites_list = await FileAttachment(\"eu_decisions_2023-09-19 13_10_comma_separated.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs"},{"id":367,"value":"Plot.plot({\n marks: [\n Plot.auto(cites_list, {y: \"Family\"})\n ]\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":341,"value":"cites_list_names = cites_list.map(d => d[\"Full Name\"]).filter((o,i,a) => a.indexOf(o) === i )","pinned":true,"hidden":false,"mode":"ojs"},{"id":373,"value":"cites_families = cites_list.map(d => d.Family).filter((o,i,a) => a.indexOf(o) === i )","pinned":true,"hidden":false,"mode":"ojs"},{"id":304,"value":"cites_list_images = await Promise.all(cites_list_names.map(async name => ({name,rows: cites_list.filter(d => d[\"Full Name\"] === name), image: await getSpeciesImage(name)})))","pinned":true,"hidden":false,"mode":"ojs"},{"id":377,"value":"cites_families_images = await Promise.all(cites_families.map(async name => ({name,rows: cites_list.filter(d => d.Family === name), image: await getSpeciesImage(cites_list.filter(d => d.Family === name)[0][\"Full Name\"])})))","pinned":true,"hidden":false,"mode":"ojs"},{"id":338,"value":"html`

${cites_families_images.map((s, i) => `

${s.name}

${ s.image ? '

' : 'No Image'}

`)}

`","pinned":true,"hidden":false,"mode":"ojs"},{"id":157,"value":"getSpecies = async (name) => {\n const res = await fetch(\"https://api.gbif.org/v1/species/match?\" + new URLSearchParams({\n name\n }))\n const species = await res.json();\n return species;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":179,"value":"getSpeciesMedia = async (species_id) => {\n const res2 = await fetch(`https://api.gbif.org/v1/species/${species_id}/media`);\n return await res2.json();\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":195,"value":"getSpeciesFirstOccurrence = async (species_id) => {\n const res = await fetch(`https://api.gbif.org/v1/occurrence/search?speciesKey=${species_id}`);\n return (await res.json()).results.filter(r => r.media.length > 0)[0];\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":314,"value":"getSpeciesImage = async (name) => {\n const species = await getSpecies(name);\n const occ = await getSpeciesFirstOccurrence(species.usageKey);\n return occ && occ.media && occ.media.length > 0 ? occ.media[0].identifier : undefined;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":166,"value":"species_smaug = await getSpecies(\"Smaug mossambicus\");\n","pinned":true,"hidden":false,"mode":"ojs"},{"id":200,"value":"occurrences_smaug = await getSpeciesFirstOccurrence(species_smaug.usageKey);\n","pinned":true,"hidden":false,"mode":"ojs"},{"id":216,"value":"occurrences_smaug.identifiers[0].identifier","pinned":true,"hidden":false,"mode":"ojs"},{"id":6,"value":"import {vl} from '@vega/vega-lite-api-v5'","pinned":true,"hidden":false,"mode":"ojs"},{"id":381,"value":"tuttiApi = require(\"https://cdn.jsdelivr.net/gh/filippofinke/tutti-api@latest/src/index.js\")","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W2f","stdlib":"1","titling":"auto"}