2a:null 2b:["$","title",null,{"children":"The Birthplace Effect: Country of Origin and Wikipedia Biographical Representation | PAC | Observable"}] 30:T64e,Plot.plot({ marks: [ Plot.line([8000, 1_000_000_000], { x: (d) => d, y: (d) => (d * 1000) / 1_000_000, stroke: "#cccccc", strokeWidth: 1.5, strokeDasharray: "4,4", clip: true }), Plot.line([8000, 1_000_000_000], { x: (d) => d, y: (d) => (d * 100) / 1_000_000, stroke: "#cccccc", strokeWidth: 1.5, strokeDasharray: "4,4", clip: true }), Plot.line([8000, 1_000_000_000], { x: (d) => d, y: (d) => (d * 10) / 1_000_000, stroke: "#cccccc", strokeWidth: 1.5, strokeDasharray: "4,4", clip: true }), Plot.dot(df_notability_by_country_en, { x: (d) => d.wpp_count, y: (d) => d.wd_count, r: 5, fill: (d) => d.ratio_cat, title: (d) => d.Name + "\n" + d.ratio.toFixed(1) + " bio per million births" + "\n" + d.wd_count.toLocaleString("en-US") + " biographies\n" + d.wpp_count.toLocaleString("en-US") + " births" }) ], color: { range: ["#b2182b", "#f4a582", "#92c5de", "#2166ac"], domain: ["> 1000", "100 - 999", "10 - 99", "< 10"], tickFormat: (d) => d.replace(" biographies per million births", ""), label: "Biographies per million births", legend: true }, x: { type: "log", label: "Births", domain: d3.extent(df_notability_by_country_en, (d) => d.wpp_count) }, y: { type: "log", label: "Biographies", domain: d3.extent(df_notability_by_country_en, (d) => d.wd_count) }, height: 600, marginLeft: 60, marginRight: 60 })31:T5b7,Plot.plot({ marks: [ Plot.ruleY([1_000, 100, 10], { stroke: "#cccccc", strokeWidth: 1.5, strokeDasharray: "4,4", clip: true }), Plot.dot(df_notability_by_country_en, { x: "wpp_count", y: "ratio", r: 4, fill: (d) => d.ratio_cat, fillOpacity: 0.8, color: "#462C7D", tip: true, title: (d) => `${d.Name} (${d.Alpha_3})\nRatio: ${d.ratio.toFixed(1)}` }), Plot.linearRegressionY(df_notability_by_country_en, { x: "wpp_count", y: "ratio", stroke: "#cccccc", ci: 0 }), Plot.text( df_notability_by_country_en.filter((d) => [ "SMR","AND","ISL","FLK","HKG","CHN","USA","PRI","ESH", "JPN","IRL","EST","SWE","CAN","FRO","GBR","IND","ETH", "SDN", "SSD", "NRU" ].includes(d.Alpha_3) ), { x: (d) => d.wpp_count, y: (d) => d.ratio, text: (d) => d.Alpha_3, dx: 15, fontSize: 12, fill: "black", clip: false } ) ], marginRight: 60, color: { range: ["#b2182b", "#f4a582", "#92c5de", "#2166ac"], domain: ["> 1000", "100 - 999", "10 - 99", "< 10"], tickFormat: (d) => d.replace(" biographies per million births", ""), label: "Biographies per million births", legend: true }, x: { type: "log", label: "Births (WPP) →" }, y: { type: "log", label: "↑ Biographies per million births" } })32:[{"id":"c3067a09091c9c8a6769e5486c35ef4c92e4963d86858df4aceb1ee4ee35435e5efdaaf01e487f069e8db3473df637de004ae2b3f28d5d829325c079bf5820a0","href":"https://static.observableusercontent.com/files/c3067a09091c9c8a6769e5486c35ef4c92e4963d86858df4aceb1ee4ee35435e5efdaaf01e487f069e8db3473df637de004ae2b3f28d5d829325c079bf5820a0","name":"df_iso@1.parquet","type":"application/octet-stream","lastModified":1776227650194.73,"size":7334},{"id":"c3067a09091c9c8a6769e5486c35ef4c92e4963d86858df4aceb1ee4ee35435e5efdaaf01e487f069e8db3473df637de004ae2b3f28d5d829325c079bf5820a0","href":"https://static.observableusercontent.com/files/c3067a09091c9c8a6769e5486c35ef4c92e4963d86858df4aceb1ee4ee35435e5efdaaf01e487f069e8db3473df637de004ae2b3f28d5d829325c079bf5820a0","name":"df_iso.parquet","type":"application/octet-stream","lastModified":1773560767928.98,"size":7334},{"id":"aabfa5f5dc0004378ba2274b660e5d50d0232cbc310ac1890a7284c34cf17c8f5a2a71b0ec2fbc80ce615c179687760f75b72ff9e47a0dca727b84a8cf02748e","href":"https://static.observableusercontent.com/files/aabfa5f5dc0004378ba2274b660e5d50d0232cbc310ac1890a7284c34cf17c8f5a2a71b0ec2fbc80ce615c179687760f75b72ff9e47a0dca727b84a8cf02748e","name":"df_notability@2.parquet","type":"application/octet-stream","lastModified":1776227588702.903,"size":349844},{"id":"f49aa5667ef6a3253bc60452163d66ae3b205775ef0ce3ee96e61b49534fe038ca90c4ac41bf864af4e0cfd6deda14b903039dcdb8e2fee36a9b02f6a928eb7c","href":"https://static.observableusercontent.com/files/f49aa5667ef6a3253bc60452163d66ae3b205775ef0ce3ee96e61b49534fe038ca90c4ac41bf864af4e0cfd6deda14b903039dcdb8e2fee36a9b02f6a928eb7c","name":"df_notability@3.parquet","type":"application/octet-stream","lastModified":1776230340771.856,"size":315440},{"id":"ec8ba33fedda18a9c9eb4356719e483ddd1ca06e1e9fe720330f94f99f69b6a0070df5a881da476b56941f4e875ffe61ed897d9d58fd701b1c24e0c45971fccc","href":"https://static.observableusercontent.com/files/ec8ba33fedda18a9c9eb4356719e483ddd1ca06e1e9fe720330f94f99f69b6a0070df5a881da476b56941f4e875ffe61ed897d9d58fd701b1c24e0c45971fccc","name":"df_wpp@1.parquet","type":"application/octet-stream","lastModified":1776227628274.376,"size":568984},{"id":"ec8ba33fedda18a9c9eb4356719e483ddd1ca06e1e9fe720330f94f99f69b6a0070df5a881da476b56941f4e875ffe61ed897d9d58fd701b1c24e0c45971fccc","href":"https://static.observableusercontent.com/files/ec8ba33fedda18a9c9eb4356719e483ddd1ca06e1e9fe720330f94f99f69b6a0070df5a881da476b56941f4e875ffe61ed897d9d58fd701b1c24e0c45971fccc","name":"df_wpp.parquet","type":"application/octet-stream","lastModified":1773560304952.78,"size":568984},{"id":"7158aab5dcbc220c658d8d7d263d6b3cf56ac40cf426b64cc328be59e85908fc49c242ceca0ff4aea44011a99cb89fb2f875013083b1c5d98e62ee5dc4434fb7","href":"https://static.observableusercontent.com/files/7158aab5dcbc220c658d8d7d263d6b3cf56ac40cf426b64cc328be59e85908fc49c242ceca0ff4aea44011a99cb89fb2f875013083b1c5d98e62ee5dc4434fb7","name":"image.png","type":"image/png","lastModified":1776230991719.712,"size":209617},{"id":"615ccb481994240ace4d520f5f4aaf7bec49e8c8204aac06022aedc00b5f0a591d95796b6e9d80741722daaa5dde40fa8c94f76386de0fc26f4b0d204332675d","href":"https://static.observableusercontent.com/files/615ccb481994240ace4d520f5f4aaf7bec49e8c8204aac06022aedc00b5f0a591d95796b6e9d80741722daaa5dde40fa8c94f76386de0fc26f4b0d204332675d","name":"df_global.parquet","type":"application/vnd.apache.parquet","lastModified":1783881146102,"size":20605},{"id":"d02b392eb3112cc6994013d9fa066bce40cc2bff56333f674a9d99322fcdf21a27d1e2a267e894e7cc8916fb40ecaf89b7a5106d42fb4526342416bfca5a9b60","href":"https://static.observableusercontent.com/files/d02b392eb3112cc6994013d9fa066bce40cc2bff56333f674a9d99322fcdf21a27d1e2a267e894e7cc8916fb40ecaf89b7a5106d42fb4526342416bfca5a9b60","name":"df_country.parquet","type":"application/vnd.apache.parquet","lastModified":1783881469708,"size":1816958},{"id":"b6f525b8858b74a5f413c74a26455a0fe34306ca6b881c49d7027e8c85488e7eb2b1cbecd10ed29accb055a5065694c7b41445323028c06ab76d9c22a714b6fa","href":"https://static.observableusercontent.com/files/b6f525b8858b74a5f413c74a26455a0fe34306ca6b881c49d7027e8c85488e7eb2b1cbecd10ed29accb055a5065694c7b41445323028c06ab76d9c22a714b6fa","name":"df_continent.parquet","type":"application/vnd.apache.parquet","lastModified":1782361955842,"size":2256}] 2e:{"id":"fd6bf539b6348b52","slug":"the-birthplace-effect-country-of-origin-and-wikipedia-biographical-representation","title":"The Birthplace Effect: Country of Origin and Wikipedia Biographical Representation","thumbnail":"7141956cd7ef1204afb4dfefe639adc30fba5bb748c2dab64f038feda5baca03","access_level":"public","create_time":"$D2026-09-12T05:08:14.996Z","update_time":"$D2026-09-23T19:10:46.638Z","view_time":null,"first_public_time":"$D2026-09-16T20:38:09.429Z","has_unpublished_edits":null,"fork":{"id":"5640051ecbeeeaad","slug":"does-the-country-of-birth-affect-the-likelihood-of","title":"Does the country of birth affect the likelihood of having a Wikipedia biography?","owner":{"id":"9232a635d4bd3de6","login":"pac02","name":"PAC"}},"stars":0,"starred":false,"owner":{"type":"team","id":"9232a635d4bd3de6","login":"pac02","name":"PAC","avatar_url":"https://avatars-next.observableusercontent.com/2e849389f24e4a039178c801e4df9065e03c23e4077b0ff6bfc8e2763dd06bf9","tier":"starter_2024"},"version":1889,"publish_version":1889,"role":null,"authored":false,"authors":[{"type":"individual","id":"c1c217aebd614b45","login":"pac02","name":"PAC","avatar_url":"https://avatars-next.observableusercontent.com/2e849389f24e4a039178c801e4df9065e03c23e4077b0ff6bfc8e2763dd06bf9","tier":null}],"members":[{"type":"team","id":"9232a635d4bd3de6","login":"pac02","name":"PAC","avatar_url":"https://avatars-next.observableusercontent.com/2e849389f24e4a039178c801e4df9065e03c23e4077b0ff6bfc8e2763dd06bf9","tier":"starter_2024","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"The Birthplace Effect: Country of Origin and Wikipedia Biographical Representation","cells":[{"id":0,"value":"# The Birthplace Effect: Country of Origin and Wikipedia Biographical Representation\n\nData collection: https://codeberg.org/pac2/biographies-vs-births","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":517,"value":"db = DuckDBClient.of({\n country: FileAttachment(\"df_country.parquet\"),\n global: FileAttachment(\"df_global.parquet\"),\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":546,"value":"db.describeTables()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1551,"value":"## Cross wiki comparison","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1518,"value":"df_by_wiki = db.query(`SELECT\n wiki,\n COUNT(DISTINCT isocode) AS distinct_isocodes,\n SUM(wpp_count) AS wpp_count,\n SUM(wd_count) AS wd_count,\n 1e6 * SUM(wd_count) / SUM(wpp_count) AS ratio\n FROM country\n WHERE year >= 1950 AND year < 1990\n GROUP BY wiki`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1560,"value":"db.query(`SELECT\n COUNT(DISTINCT isocode) AS distinct_isocodes,\n\n FROM country\n WHERE year >= 1950 AND year < 1990\n `)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1519,"value":"Inputs.table(df_by_wiki, {\n select: false,\n layout: \"auto\",\n sort: \"ratio\",\n reverse: true,\n columns: [\"wiki\", \"wd_count\", \"wpp_count\", \"ratio\"]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1520,"value":"toWikiTable(\n df_by_wiki\n .sort((a, b) => b.ratio - a.ratio)\n .map(({ wiki, wd_count, ratio }) => ({\n wiki,\n wd_count: \"{{formatnum:\" + wd_count + \"}}\",\n ratio: \"{{formatnum:\" + ratio.toFixed(1) + \"}}\"\n }))\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1525,"value":"## Results for Wikipedia in English","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1521,"value":"start = 1950","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1522,"value":"end = 1990","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1527,"value":"df_notability_by_country_en = await db.query(`SELECT\n Name,\nAlpha_3,\n SUM(wpp_count)::INTEGER AS wpp_count,\n SUM(wd_count)::INTEGER AS wd_count,\n 1e6 * SUM(wd_count) / SUM(wpp_count) AS ratio,\n RANK() OVER (ORDER BY 1e6 * SUM(wd_count) / SUM(wpp_count) DESC) AS rank,\n LOG(1e6 * SUM(wd_count) / SUM(wpp_count)) AS log_ratio,\n LOG( SUM(wpp_count)) AS log_wpp_count,\nCASE\n WHEN 1e6 * SUM(wd_count) / SUM(wpp_count) > 1000 THEN '> 1000'\n WHEN 1e6 * SUM(wd_count) / SUM(wpp_count) >= 100 THEN '100 - 999'\n WHEN 1e6 * SUM(wd_count) / SUM(wpp_count) >= 10 THEN '10 - 99'\n ELSE '< 10'\n END AS ratio_cat\nFROM country\nWHERE year >= 1950 AND year < 1990 AND wiki = 'en' AND wpp_count IS NOT NULL\nGROUP BY Name, Alpha_3\nHAVING SUM(wd_count)::INTEGER > 0`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1524,"value":"Inputs.table(df_notability_by_country_en, {\n columns: [\"Name\", \"wd_count\", \"wpp_count\", \"ratio\", \"rank\"],\n header: {\n Name: \"Country\",\n wd_count: \"People with a bio\",\n wpp_count: \"Births\",\n ratio: \"People with a bio per million births\",\n rank: \"Ranking\"\n },\n format: {\n ratio: (x) =>\n x.toLocaleString(\"en-US\", {\n maximumFractionDigits: 0\n })\n },\n sort: \"ratio\",\n reverse: true,\n layout: \"auto\",\n select: false\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1530,"value":"Top 20 countries","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1528,"value":"toWikiTable(\n df_notability_by_country_en\n .slice()\n .sort((a, b) => b.ratio - a.ratio)\n .slice(0, 20)\n .map(({ rank, Name, wd_count, wpp_count, ratio }) => ({\n rank: rank,\n Name: \"[[\" + Name + \"]]\",\n wd_count: \"{{formatnum:\" + wd_count + \"}}\",\n wpp_count: \"{{formatnum:\" + wpp_count + \"}}\",\n ratio: \"{{formatnum:\" + ratio.toFixed(1) + \"}}\"\n }))\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1531,"value":"Countries with more than 10 million births","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1529,"value":"toWikiTable(\n df_notability_by_country_en\n .slice()\n .sort((a, b) => b.ratio - a.ratio)\n .filter((d) => d.wpp_count > 10**7)\n .map(({ rank,Name, wd_count, wpp_count, ratio }) => ({\n rank: rank,\n Name: \"[[\" + Name + \"]]\",\n wd_count: \"{{formatnum:\" + wd_count + \"}}\",\n wpp_count: \"{{formatnum:\" + wpp_count + \"}}\",\n ratio: \"{{formatnum:\" + ratio.toFixed(1) + \"}}\"\n }))\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1543,"value":"### Biographies versus births","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1542,"value":"$30","pinned":false,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1544,"value":"### Biographies per million birth vs births","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1535,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1546,"value":"The coefficient of correlation between the number of births and the biographies per million births is ${ss.sampleCorrelation(\n df_notability_by_country_en.map((d) => Math.log(d.wpp_count)),\n df_notability_by_country_en.map((d) => Math.log(d.ratio))\n).toFixed(3)}.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1562,"value":"d3regression = require(\"d3-regression@1\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1563,"value":"df_notability_by_country_log = df_notability_by_country_en\n .filter(d => d.wpp_count > 0 && d.ratio > 0)\n .map(d => ({\n ...d,\n log_wpp: Math.log(d.wpp_count),\n log_ratio: Math.log(d.ratio)\n }))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1561,"value":"linearReg = {\n const regression = d3regression.regressionLinear()\n .x(d => d.log_wpp_count)\n .y(d => d.log_ratio);\n return regression(df_notability_by_country_en);\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1564,"value":"Inputs.table([\n {metric: \"Slope (a)\", value: linearReg.a},\n {metric: \"Intercept (b)\", value: linearReg.b},\n {metric: \"R²\", value: linearReg.rSquared}\n], {select: false} )","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1538,"value":"### Biographies per million births world map","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1537,"value":"geo_countries = d3.json(\n \"https://gisco-services.ec.europa.eu/distribution/v2/countries/geojson/CNTR_RG_60M_2020_4326.geojson\"\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1540,"value":"geo_notability = geoviz.tool.merge({\n geom: geo_countries,\n geom_id: \"ISO3_CODE\",\n data: df_notability_by_country_en,\n data_id: \"Alpha_3\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1541,"value":"geo_data = geo_notability.featureCollection","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1545,"value":"choro = geoviz.tool.choro(\n geo_data.features.map((d) => d.properties.ratio),\n {\n method: \"manual\",\n breaks: [0, 10, 100, 1000, 100000],\n precision: 0,\n colors: [\"#2166ac\", \"#92c5de\", \"#f4a582\", \"#b2182b\"]\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1536,"value":"geoviz.draw({\n params: { projection: d3.geoPeirceQuincuncial(), width: 700 },\n layers: [\n { type: \"outline\", fill: \"#fff\" },\n {\n type: \"graticule\",\n stroke: \"#a0b8cc\",\n strokeWidth: 0.5,\n strokeOpacity: 0.8\n },\n {\n type: \"layer\",\n data: geo_data,\n fill: \"#daeaf5\",\n stroke: \"#78909c\",\n strokeWidth: 0.6\n },\n {\n type: \"circle\",\n data: geo_data,\n r: 5,\n dodge: true,\n sort: \"wpp_count\",\n fill: (d) => choro.colorize(d.properties.ratio),\n fillOpacity: 0.9,\n stroke: \"#ffffff\",\n strokeWidth: 0.6,\n tip: (d) =>\n `${d.properties.NAME_ENGL}\\n` +\n `${d.properties.ratio.toLocaleString(\"en-US\", {\n maximumFractionDigits: 0\n })} biographies per million births`\n },\n {\n type: \"leg_choro_horizontal\",\n pos: [20, 50],\n title: \"Biographies per million births\",\n colorize: choro.colorize,\n breaks: choro.breaks,\n colors: choro.colors\n }\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":668,"value":"## Cross-wiki analysis","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":744,"value":"df_by_country_wiki = await db.query(`SELECT\n Name,\n wiki,\n SUM(wpp_count)::INTEGER AS wpp_count,\n SUM(wd_count)::INTEGER AS wd_count,\n 1e6 * SUM(wd_count) / SUM(wpp_count) AS ratio,\n LOG(1e6 * SUM(wd_count) / SUM(wpp_count)) AS log_ratio,\nFROM country\nWHERE year >= ${start} AND year < ${end}\nGROUP BY Name, wiki\nHAVING SUM(wd_count)::INTEGER > 0\n`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1549,"value":"df_wiki = await db.sql`SELECT DISTINCT wiki AS wiki FROM country`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1550,"value":"wikiList = df_wiki.map(row => row.wiki)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1344,"value":"## Similarity between Wikipedia editions","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1269,"value":"countryWikiMap = d3.group(df_by_country_wiki, (d) => d.Name)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1271,"value":"commonCountries = [...countryWikiMap]\n .filter(([, rows]) => rows.length === wikiList.length)\n .map(([name]) => name)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1273,"value":"pivoted = Object.fromEntries(\n commonCountries.map((name) => [\n name,\n Object.fromEntries(\n countryWikiMap.get(name).map((d) => [d.wiki, d.log_ratio])\n )\n ])\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1443,"value":"### Pearson's correlation matrix","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1275,"value":"correlationMatrix = wikiList.map((w1) =>\n wikiList.map((w2) => {\n const pairs = commonCountries\n .map((c) => [pivoted[c][w1], pivoted[c][w2]])\n .filter(([a, b]) => a != null && b != null && isFinite(a) && isFinite(b));\n return ss.sampleCorrelation(\n pairs.map((p) => p[0]),\n pairs.map((p) => p[1])\n );\n })\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1277,"value":"correlation = wikiList.map((w1, i) => ({\n wiki: w1,\n ...Object.fromEntries(\n wikiList.map((w2, j) => [w2,j <= i ? correlationMatrix[i][j].toFixed(3) : \"\"])\n )\n}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1558,"value":"Minimal value","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1304,"value":"d3.min(correlationMatrix.flat())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1280,"value":"Inputs.table(correlation, { layout: \"auto\" })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1553,"value":"toWikiTable(\n correlation\n)","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1448,"value":"### Pairwise comparisons","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1555,"value":"df_by_country2 = db.sql`\nPIVOT (\n SELECT\n Name,\n wiki,\n 1e6 * SUM(wd_count) / SUM(wpp_count) AS ratio\n FROM country\n WHERE year >= 1950 AND year < 1990\n GROUP BY Name, wiki\n)\nON wiki\nUSING SUM(ratio)\nGROUP BY Name\n`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":705,"value":"Inputs.table(df_by_country2, { layout: \"auto\", select: false })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1043,"value":"viewof xCol = Inputs.select(wikiList, { value: \"en\", label: \"X axis\" })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1019,"value":"viewof yCol = Inputs.select(\n wikiList.filter((d) => d != xCol),\n { value: \"ja\", label: \"Y axis\" }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1018,"value":"Plot.plot({\n marks: [\n Plot.dot(df_by_country2, {\n x: xCol,\n y: yCol,\n stroke: \"#462C7D\",\n fill: \"#831C91\",\n fillOpacity: 0.4,\n r: 5,\n tip: true,\n title: (d) =>\n `${d.Name}\\n${xCol}: ${d[xCol]?.toFixed(1)}\\n${yCol}: ${d[\n yCol\n ]?.toFixed(1)}`\n }),\n Plot.linearRegressionY(df_by_country2, {\n x: xCol,\n y: yCol,\n stroke: \"#D552A3\",\n strokeWidth: 1.5\n })\n ],\n x: {\n type: \"log\",\n label: xCol.replace(\"ratio_\", \"wikipedia — \"),\n tickFormat: (d) => d3.format(\"~r\")(d)\n },\n y: {\n type: \"log\",\n label: yCol.replace(\"ratio_\", \"wikipedia — \"),\n tickFormat: (d) => d3.format(\"~r\")(d)\n },\n height: 600,\n marginLeft: 60,\n marginRight: 60\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":701,"value":"df_by_country = db.query(`SELECT\n Name,\n COALESCE(MAX(CASE WHEN wiki = 'en' THEN ratio END), 0) AS ratio_en,\n COALESCE(MAX(CASE WHEN wiki = 'fr' THEN ratio END), 0) AS ratio_fr,\n COALESCE(MAX(CASE WHEN wiki = 'de' THEN ratio END), 0) AS ratio_de,\n COALESCE(MAX(CASE WHEN wiki = 'es' THEN ratio END), 0) AS ratio_es,\n COALESCE(MAX(CASE WHEN wiki = 'it' THEN ratio END), 0) AS ratio_it,\n COALESCE(MAX(CASE WHEN wiki = 'ja' THEN ratio END), 0) AS ratio_ja,\n COALESCE(MAX(CASE WHEN wiki = 'zh' THEN ratio END), 0) AS ratio_zh,\n COALESCE(MAX(CASE WHEN wiki = 'pl' THEN ratio END), 0) AS ratio_pl,\n COALESCE(MAX(CASE WHEN wiki = 'nl' THEN ratio END), 0) AS ratio_nl,\n COALESCE(MAX(CASE WHEN wiki = 'fa' THEN ratio END), 0) AS ratio_fa\nFROM (\n SELECT\n Name,\n wiki,\n 1e6 * SUM(wd_count) / SUM(wpp_count) AS ratio\n FROM country\n WHERE year >= 1950 AND year < 1990\n GROUP BY Name, wiki\n)\nGROUP BY Name`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1367,"value":"df_by_country_wiki_ranked = db.sql`\n PIVOT(\n SELECT\n Name,\n wiki,\n RANK() OVER (PARTITION BY wiki ORDER BY 1e6 * SUM(wd_count) / SUM(wpp_count) DESC) AS rank\n FROM country\n WHERE year >= 1950 AND year < 1990\n GROUP BY Name, wiki\n )\n ON wiki\n USING ANY_VALUE(rank)\n GROUP BY Name\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1371,"value":"Inputs.table(df_by_country_wiki_ranked, {\n sort: \"en\",\n select: false,\n layout: \"auto\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1556,"value":"toWikiTable(\n df_by_country_wiki_ranked\n .sort((a, b) => a.en - b.en)\n .slice(0, 20)\n .map(({ Name, ...d }) => ({\n Name,\n ...Object.fromEntries(wikiList.map((k) => [k, d[k]]))\n }))\n)","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1077,"value":"## Appendix","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":284,"value":"geoviz = require(\"geoviz\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":291,"value":"d3 = require(\"d3@7\", \"d3-geo-projection@4\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1337,"value":"ss = require(\"simple-statistics\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1131,"value":"import { toWikiTable } from \"@pac02/who-gets-a-biography-on-french-language-wikipedia\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W32","stdlib":"1","titling":"auto"}} 2f:"$2e:body"