31:[] 2f:{"title":"People born between 1950 and 2000 with a biography in Wikipedia by country of birth","cells":[{"id":0,"value":"# People born between 1950 and 2000 with a biography in Wikipedia by country of birth\n## A companion notebook to [@pac02/does-the-country-of-birth-affect-the-likelihood-of](https://observablehq.com/@pac02/does-the-country-of-birth-affect-the-likelihood-of)\n\nThis notebook explores the list of people with a biography in Wikipedia by country of births. ","pinned":false,"hidden":false,"mode":"md"},{"id":72,"value":"viewof yo = Inputs.form({\n country: Inputs.select(countriesMap, {\n label: \"Choose a country code\",\n value: defaults.code\n }),\n wikipedia: Inputs.select(wikis, {\n label: \"Choose a Wikipedia page project\",\n value: defaults.wiki\n })\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":79,"value":"URL: https://observablehq.com/@pac02/people-born-between-1950-and-2000-with-a-biography?wiki=${ yo.wikipedia}&code=${yo.country} ","pinned":false,"hidden":false,"mode":"md"},{"id":134,"value":"viewof p = Inputs.form({\n start: Inputs.range([1950, 2000], { step: 10, value: 1950 }),\n end: Inputs.range([1950, 2000], { step: 10, value: 1990 })\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":130,"value":"$${filtered.length} biographies of people born between ${p.start} and ${p.end} in ${[...countriesMap.entries()].find(([k, v]) => v === yo.country)?.[0]} ","pinned":false,"hidden":false,"mode":"md"},{"id":30,"value":"Inputs.table(filtered2, {\n select: false,\n layout: \"auto\",\n columns: [\"year\", \"item2\", \"itemDescription\", \"birthplace2\"],\n format: {\n item2: (d) => html`${d}`,\n birthplace2: (d) => html`${d} `\n }\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":90,"value":"## Appendix","pinned":false,"hidden":false,"mode":"md"},{"id":141,"value":"filtered = data.filter((d) => (d.year >= p.start) & (d.year < p.end))","pinned":false,"hidden":false,"mode":"ojs"},{"id":150,"value":"filtered2 = filtered.map(\n ({\n year,\n item,\n itemLabel,\n itemDescription,\n birthplace,\n birthplaceLabel\n }) => ({\n year,\n item2: `${itemLabel}`,\n itemDescription,\n birthplace2: `${birthplaceLabel}`\n })\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":23,"value":"query = `PREFIX rdfs: \nPREFIX schema: \nPREFIX wdt: \n\nSELECT ?item ?itemLabel ?itemDescription ?birthplace ?birthplaceLabel ?country ?year \nWHERE {\n ?item wdt:P19 ?birthplace.\n \n {\n SELECT ?item (SAMPLE(?birthdate_raw) AS ?birthdate)\n WHERE { ?item wdt:P569 ?birthdate_raw }\n GROUP BY ?item\n }\n \n BIND(YEAR(?birthdate) AS ?year)\n FILTER(?year >= 1950)\n FILTER(?year < 2000)\n ?country wdt:P299 \"${yo.country}\".\n ?birthplace wdt:P17 ?country.\n ?sitelink schema:about ?item;\n schema:isPartOf .\n\n OPTIONAL { ?item rdfs:label ?itemLabel FILTER(LANG(?itemLabel) = \"en\") }\n OPTIONAL{\n ?item schema:description ?itemDescription FILTER(LANG(?itemDescription) = \"en\").\n }\n OPTIONAL { ?birthplace rdfs:label ?birthplaceLabel FILTER(LANG(?birthplaceLabel) = \"en\") }\n}\nORDER BY (?year)`","pinned":false,"hidden":false,"mode":"ojs"},{"id":10,"value":"res = await fetch(endpoint, {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/sparql-query\",\n Accept: \"application/sparql-results+json\"\n },\n body: query\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":12,"value":"json = await res.json();","pinned":false,"hidden":false,"mode":"ojs"},{"id":17,"value":"rows = json.results.bindings","pinned":false,"hidden":false,"mode":"ojs"},{"id":19,"value":"getId = (uri) => uri?.split(\"/\").pop()","pinned":false,"hidden":false,"mode":"ojs"},{"id":21,"value":"data = rows.map((row) => ({\n item: getId(row.item?.value),\n birthplace: getId(row.birthplace?.value),\n country: getId(row.country?.value),\n year: Number(row.year?.value),\n itemLabel: row.itemLabel?.value,\n itemDescription: row.itemDescription?.value,\n birthplaceLabel: row.birthplaceLabel?.value\n}))","pinned":false,"hidden":false,"mode":"ojs"},{"id":7,"value":"endpoint = \"https://qlever.dev/api/wikidata\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":33,"value":"import {\n countriesMap,\n wikis\n} from \"@pac02/does-the-country-of-birth-affect-the-likelihood-of\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":53,"value":"defaults = {\n const params = new URL(document.URL).searchParams;\n const d = {\n wiki: \"en\",\n code: \"674\"\n };\n if (params.has(\"wiki\")) {\n d.wiki = params.get(\"wiki\");\n }\n if (params.has(\"code\")) {\n d.code = params.get(\"code\");\n }\n return d;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":167,"value":"[...countriesMap.entries()].find(([k, v]) => v === yo.country)?.[0]","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W31","stdlib":"1","titling":"auto"}