2f:["$","title",null,{"children":"How to tell someone's age when all you know is their name | Max Bo | Observable"}] 34:Tafd,plotName = async ({ name, sex, caption }) => { const nameData = await getNameData({name, sex}) return Plot.plot({ caption, style: "overflow: visible;", width: 800, tip: true, height: sex ? 350 : 700, facet: { data: nameData, y: "sex" }, color: { domain: ["M", "F"], scheme: "BuRd" }, x: { domain: xDomain }, y: { label: "↑ count" }, grid: true, marks: [ Plot.ruleY([0]), Plot.line(nameData, { clip: true, x: "date", y: "born", tip: true, title: tooltip }), Plot.areaY(nameData, { x: "date", y: "alive", fill: "sex", fillOpacity: 0.6 }), Plot.text( nameData, Plot.selectMaxY({ x: "date", frameAnchor: "middle", y: "born", stroke: "white", fill: "black", text: (d) => `Number of ${EXPANDED_SEX[d.sex]} ${name}s born each year` }) ), Plot.ruleX( nameData, Plot.select( { // find the median cumsum // https://github.com/observablehq/plot/blob/main/README.md#plotselectselector-options y: (I, V) => { const sum = d3.sum(I, (i) => V[i]); const i = d3 .cumsum(I, (i) => V[i]) .findIndex((d) => d >= sum / 2); return [I[i]]; } }, { x: "date", y: "alive", stroke: "sex", strokeWidth: 4 } ) ), Plot.text( nameData, Plot.selectMaxY({ x: "date", frameAnchor: "bottom", y: (d) => d.alive * 0.1, stroke: "white", fill: "sex", opacity: 0.9, text: (d) => `Number of ${EXPANDED_SEX[d.sex]} ${name}s born each year estimated to be alive on Jan 1 ${DATA_YEAR_END + 1}` }) ), Plot.text( nameData, Plot.select( { // find the median cumsum // https://github.com/observablehq/plot/blob/main/README.md#plotselectselector-options y: (I, V) => { const sum = d3.sum(I, (i) => V[i]); const i = d3 .cumsum(I, (i) => V[i]) .findIndex((d) => d >= sum / 2); return [I[i]]; } }, { x: "date", frameAnchor: "top-right", y: "alive", stroke: "white", fill: "sex", text: (d) => `The median living ${EXPANDED_SEX[d.sex]} ${name} in ${DATA_YEAR_END} was ${DATA_YEAR_END - d.date.getFullYear()}` } ) ) ] }); }35:T5ee,plotSpread = ({ names, sex }) => { const nameData = babynames .filter((d) => names.includes(d.name) && d.sex === sex) .map((d) => ({ ...d, alive: survivalCoefficient(d.year, d.sex) * d.born, date: new Date(d.year + "-01-01") })); return Plot.plot({ grid: true, height: 600, width: 400, facet: { data: nameData, y: "name", marginRight: 100 }, fy: { domain: names }, x: { domain: xDomain }, y: { ticks: false }, color: { domain: ["M", "F"], scheme: "BuRd" }, marginLeft: 100, marks: [ Plot.line(nameData, { clip: true, x: "date", y: "born", tip: true, title: tooltip }), Plot.areaY(nameData, { x: "date", y: "alive", fill: "sex" }), Plot.dotX( nameData, Plot.select( { // find the median cumsum // https://github.com/observablehq/plot/blob/main/README.md#plotselectselector-options y: (I, V) => { const sum = d3.sum(I, (i) => V[i]); const i = d3 .cumsum(I, (i) => V[i]) .findIndex((d) => d >= sum / 2); return [I[i]]; } }, { x: "date", y: "alive", stroke: "white", fill: "red", title: (d) => `Median: ${d.year}` } ) ) ] }); }36:[{"id":"daffdfa58963dd28bc05189ed17fd1454851b449480c217d32af69bd2131cc6d241b495773b6d235c02047e856e7ca237037c446f52c954b7366505edc1a4715","href":"https://static.observableusercontent.com/files/daffdfa58963dd28bc05189ed17fd1454851b449480c217d32af69bd2131cc6d241b495773b6d235c02047e856e7ca237037c446f52c954b7366505edc1a4715","name":"LifeTable@2.csv","type":"text/csv","lastModified":1678527405726.572,"size":374},{"id":"e4732b15824d2796f0ce3237a9b72056f44d921c7930b087d4900f47d4a00e21761c4a6ac6b0ace77905ab927bd6cda78ef5d55d90e4c66b96ee7a321d541aff","href":"https://static.observableusercontent.com/files/e4732b15824d2796f0ce3237a9b72056f44d921c7930b087d4900f47d4a00e21761c4a6ac6b0ace77905ab927bd6cda78ef5d55d90e4c66b96ee7a321d541aff","name":"babynames-3.parquet","type":"application/octet-stream","lastModified":1696637238527.555,"size":7201927}] 32:{"id":"4d2f68b33b084f79","slug":"how-to-tell-someones-age-when-all-you-know-is-their-name","title":"How to tell someone's age when all you know is their name","thumbnail":"401632affbbe6b54179ead19ee53dcb78f643a45f66287914b638a7d26aa0e93","access_level":"public","create_time":"$D2023-03-06T03:49:19.606Z","update_time":"$D2023-10-12T00:04:08.610Z","view_time":null,"first_public_time":"$D2023-03-06T03:49:19.606Z","has_unpublished_edits":null,"fork":false,"stars":7,"starred":false,"owner":{"type":"team","id":"cc48459e4293f942","login":"mjbo","name":"Max Bo","avatar_url":"https://avatars-next.observableusercontent.com/05ae9baba40510a4a22fa7d179f29dd4ffd85fcff859c54a31d42e166ae61dfa","tier":"starter_2024"},"version":2276,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"5bb83a6e9493ea1d","login":"mjbo","name":"Max Bo","avatar_url":"https://avatars-next.observableusercontent.com/05ae9baba40510a4a22fa7d179f29dd4ffd85fcff859c54a31d42e166ae61dfa","tier":null}],"members":[{"type":"individual","id":"5bb83a6e9493ea1d","login":"mjbo","name":"Max Bo","avatar_url":"https://avatars-next.observableusercontent.com/05ae9baba40510a4a22fa7d179f29dd4ffd85fcff859c54a31d42e166ae61dfa","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":true,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":{"id":"a5615d262872a60a","slug":"misc","title":"Misc","owner":{"id":"cc48459e4293f942","login":"mjbo","name":"Max Bo"}},"type":"notebook","body":{"title":"How to tell someone's age when all you know is their name","cells":[{"id":0,"value":"# How to tell someone's age when all you know is their name\n## An interactive reproduction of the similarly named [FiveThirtyEight article](https://fivethirtyeight.com/features/how-to-tell-someones-age-when-all-you-know-is-her-name/)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2105,"value":"I thought this was a great article. But I wanted to to see the same graphs with some names of my own choosing. Without further ado: ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1799,"value":"viewof scaleSetting = Inputs.radio([\"Normalized\", \"Absolute\"], {\n label: \"Scale setting\",\n value: \"Normalized\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":71,"value":"viewof searchedName = Inputs.text({\n label: \"Name\",\n value: \"Charlie\",\n placeholder: \"Charlie\",\n width: 400,\n autocomplete: true,\n autocapitalize: true,\n datalist: topNames\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1176,"value":"nameFigure({\n name: searchedName,\n sexes: scaleSetting === \"Normalized\" ? [\"F\", \"M\"] : undefined\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1202,"value":"---\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1211,"value":"nameFigure({ name: \"Joseph\", sexes: [\"M\"] })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1151,"value":"nameFigure({ name: \"Anna\", sexes: [\"F\"] })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1192,"value":"nameFigure({ name: \"Brittany\", sexes: [\"F\"] })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1195,"value":"nameFigure({ name: \"Violet\", sexes: [\"F\"] })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1525,"value":"spreadFigure({\n title: \"Median ages for the 25 most common names\",\n maleNames: topMaleNames,\n femaleNames: topFemaleNames,\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1662,"value":"viewof aliveThreshold = Inputs.range([1, 1000001], {\n label: \"Total number that need to be alive to be listed\",\n step: 50000,\n value: 50001\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1636,"value":"spreadFigure({\n title: \"Median ages for the 25 youngest names\",\n maleNames: youngestMaleNames,\n femaleNames: youngestFemaleNames\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1255,"value":"spreadFigure({\n title: \"Median ages for the 25 oldest names\",\n maleNames: oldestMaleNames,\n femaleNames: oldestFemaleNames\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":165,"value":"\n---\n\n## Implementation\n### Raw data\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":862,"value":"DATA_YEAR_START = 1880","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":644,"value":"DATA_YEAR_END = 2020","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1730,"value":"xDomain = [new Date(\"1900-01-01\"), new Date(\"2021-01-01\")]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":262,"value":"#### Life tables","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":154,"value":"I sourced a tidy dataset of the Social Security Administration \n[actuarial tables](https://www.ssa.gov/oact/NOTES/as120/LifeTables_Tbl_7.html) from https://github.com/bjloe/BabyNameExplorer/blob/main/FromNameToAge.ipynb:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":158,"value":"lifetable = await FileAttachment(\"LifeTable@2.csv\").csv({typed: \"auto\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"lifetable","database":"$undefined"},{"id":669,"value":"Looking at probability that a person born in a given year we expect to be alive:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":271,"value":"Plot.plot({\n color: {\n domain: [\"M\", \"F\"],\n scheme: \"BuRd\"\n },\n x: {\n tickFormat: \"c\"\n },\n y: {\n label: \"↑ probability\"\n },\n marks: [\n Plot.barY(lifetable, {\n x: \"year\",\n y: (d) => d.survival / 100000,\n fy: \"sex\",\n tip: true,\n fill: \"sex\"\n }),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":664,"value":"As per the [original article](https://fivethirtyeight.com/features/how-to-tell-someones-age-when-all-you-know-is-her-name/\n)\n> The SSA’s actuarial tables are listed by decade, e.g., for people born in 1920, 1930, 1940, etc., so we used linear extrapolation for years that don’t end in zero.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":146,"value":"/**\n * Gives the coefficient that describes the number of people\n * still living from that year with the specified sex.\n */\nfunction survivalCoefficient(year, sex) {\n year = Number(year);\n const hasSex = _.reverse(_.sortBy(lifetable, (d) => d.year)).filter(\n (d) => d.sex === sex\n );\n // Linearly interpolate between years with no data\n const left = hasSex.find((d) => d.year <= year);\n const right = hasSex.find((d) => d.year <= year + 10);\n const delta = right.survival - left.survival;\n const progress = (year - left.year) / 10;\n\n return (left.survival + delta * progress) / 100_000;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":881,"value":"interpolatedLifetable","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":873,"value":"interpolatedLifetable = {\n const acc = [];\n for (const year of d3.range(DATA_YEAR_START, DATA_YEAR_END + 1)) {\n for (const sex of [\"M\", \"F\"]) {\n acc.push({\n year,\n sex,\n survival: survivalCoefficient(year, sex)\n });\n }\n }\n\n return acc;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":647,"value":"#### Baby names","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":14,"value":"I have sourced a zip file from https://www.ssa.gov/oact/babynames/limits.html.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":21,"value":"It contains a bunch `.csv` files inside of it in the form `yob1880.txt` to `yob2021.txt` I glued all of these together with a Python script to give:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":25,"value":"```python\nwith open (\"allyears.csv\", \"w+\") as agg:\n agg.write(\"year,name,sex,born\")\n for year in range(1880, ${DATA_YEAR_END} + 1): # non-inclusive range, no life table data for 2021\n with open(\"yob{}.txt\".format(year), \"r\") as f:\n for line in f:\n agg.write(str(year) + \",\" + line)\n```","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2145,"value":"Then I converted it to Parquet using https://observablehq.com/@observablehq/csv-to-parquet.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":37,"value":"babynames = await FileAttachment(\"babynames-3.parquet\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"babynames","database":"$undefined"},{"id":1136,"value":"### Top names","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":916,"value":"duckDb = DuckDBClient.of({\n babynames: FileAttachment(\"babynames-3.parquet\"),\n lifetable: interpolatedLifetable\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1926,"value":"JOINED_QUERY = `SELECT babynames.name, babynames.sex, babynames.year, (lifetable.survival * babynames.born) as alive\nFROM lifetable JOIN babynames ON (lifetable.year = babynames.year AND lifetable.sex = babynames.sex)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1937,"value":"ROLLUP_QUERY = `SELECT name, sex, SUM(alive) as totalAlive, SUM(v.year * v.alive) / SUM(v.alive) as averageYear\nFROM (${JOINED_QUERY}) as v\nWHERE v.sex IS NOT NULL\nGROUP BY ROLLUP (v.name, v.sex)\nHAVING sex IS NOT NULL`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1010,"value":"topNames = duckDb\n .query(\n `SELECT name FROM (${ROLLUP_QUERY}) ORDER BY totalAlive DESC LIMIT 10000`\n )\n .then((rows) => rows.map((row) => row.name))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1224,"value":"topMaleNames = duckDb\n .query(\n `\nSELECT name\nFROM\n (SELECT * FROM (${ROLLUP_QUERY})\n WHERE sex = 'M' AND totalAlive > ${aliveThreshold}\n ORDER BY totalAlive DESC\n LIMIT 25)\nORDER BY averageYear\n`\n )\n .then((rows) => rows.map((row) => row.name))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1226,"value":"topFemaleNames = duckDb\n .query(\n `\nSELECT name\nFROM\n (SELECT * FROM (${ROLLUP_QUERY}) \n WHERE sex = 'F' AND totalAlive > ${aliveThreshold}\n ORDER BY totalAlive DESC\n LIMIT 25)\nORDER BY averageYear`\n )\n .then((rows) => rows.map((row) => row.name))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1608,"value":"youngestMaleNames = duckDb\n .query(\n `SELECT name\nFROM (${ROLLUP_QUERY})\nWHERE sex = 'M' AND totalAlive > ${aliveThreshold}\nORDER BY averageYear DESC NULLS LAST\nLIMIT 25;`).then((rows) => rows.map((row) => row.name))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1600,"value":"oldestMaleNames = duckDb\n .query(\n `SELECT name\nFROM (${ROLLUP_QUERY})\nWHERE sex = 'M' AND totalAlive > ${aliveThreshold}\nORDER BY averageYear ASC NULLS LAST\nLIMIT 25;\n`\n )\n .then((rows) => rows.map((row) => row.name))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1626,"value":"youngestFemaleNames =\nduckDb.query(\n `SELECT name\nFROM (${ROLLUP_QUERY})\nWHERE sex = 'F' AND totalAlive > ${aliveThreshold}\nORDER BY averageYear DESC NULLS LAST\nLIMIT 25;\n`\n).then((rows) => rows.map((row) => row.name))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1624,"value":"oldestFemaleNames = duckDb\n .query(\n `\nSELECT name\nFROM (${ROLLUP_QUERY})\nWHERE sex = 'F' AND totalAlive > ${aliveThreshold}\nORDER BY averageYear ASC NULLS LAST\nLIMIT 25;\n`\n )\n .then((rows) => rows.map((row) => row.name))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2082,"value":"VARIANCE_QUERY = `WITH frequency AS (${JOINED_QUERY}),\n populationMetrics AS (${ROLLUP_QUERY})\nSELECT frequency.name, frequency.sex, (SUM((frequency.alive * frequency.year^2) - populationMetrics.averageYear^2) / SUM(frequency.alive)) as variance\nFROM frequency, populationMetrics \nWHERE frequency.sex = populationMetrics.sex \n AND frequency.name = populationMetrics.name\n AND populationMetrics.totalAlive > ${aliveThreshold}\nGROUP BY ROLLUP (frequency.name, frequency.sex)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2009,"value":"topMaleVariance = duckDb\n .query(\n `\nSELECT name\nFROM (${VARIANCE_QUERY})\nWHERE sex = 'M'\nORDER BY variance ASC NULLS LAST\nLIMIT 25\n`\n )\n .then((rows) => rows.map((row) => row.name))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2089,"value":"topFemaleVariance = duckDb\n .query(\n `\nSELECT name\nFROM (${VARIANCE_QUERY})\nWHERE sex = 'F'\nORDER BY variance ASC NULLS LAST\nLIMIT 25\n`\n )\n .then((rows) => rows.map((row) => row.name))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":496,"value":"### Median\n\nThe median age is the age owned by the year of half the sum of the total people living from each year.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":514,"value":"getMedian = (nameData) => {\n if (!nameData.length) return new Date(\"1970-01-01\");\n\n const totalLiving = _.sumBy(nameData, (d) => d.alive);\n const index = d3\n .cumsum(nameData.map((d) => d.alive))\n .findIndex((d) => d >= totalLiving / 2);\n return nameData[index].date;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":731,"value":"### Figures","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":611,"value":"tooltip = ({ year, born, alive }) =>\n `${year}\\nBorn: ${born.toFixed(0)}\\nLiving: ${(alive || NaN).toFixed(0)}`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":600,"value":"EXPANDED_SEX = ({ M: \"male\", F: \"female\" })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1172,"value":"nameFigure = async ({ name, sexes }) => {\n const plots = await (sexes\n ? Promise.all(sexes.map((sex) => plotName({ name, sex })))\n : plotName({ name }));\n\n return htl.html`\n

Age distribution of Americans named ${name}

By year of birth

\n ${plots}\n

Source: Social Security Administration

`;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2187,"value":"getNameData = async ({ name, sex }) => {\n return duckDb.query(`\nSELECT \n babynames.sex, \nmake_date(babynames.year, 1, 1) as date, \nbabynames.born, \n(lifetable.survival * babynames.born) as alive\nFROM \n lifetable JOIN babynames ON (lifetable.year = babynames.year AND lifetable.sex = babynames.sex) \nWHERE \n babynames.name = '${name}'\n AND babynames.sex = '${sex}'`);\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":542,"value":"$34","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1387,"value":"### Spreads","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2196,"value":"getSpreadData = async ({ name }) => {\n return duckDb.query(`\nSELECT \n babynames.sex, \nmake_date(babynames.year, 1, 1) as date, \nbabynames.born, \n(lifetable.survival * babynames.born) as alive\nFROM \n lifetable JOIN babynames ON (lifetable.year = babynames.year AND lifetable.sex = babynames.sex) \nWHERE \n babynames.name = ${name}\n `);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1230,"value":"$35","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1507,"value":"spreadFigure = ({ title, maleNames, femaleNames }) => {\n return htl.html`\n

${title}

Among Americans estimated to be alive as of Jan. 1, ${\n DATA_YEAR_END + 1\n }

\n\n

\n ${plotSpread({ names: femaleNames, sex: \"F\" })}\n ${plotSpread({ names: maleNames, sex: \"M\" })}\n

\n\n

Source: Social Security Administration

`;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W36","stdlib":"1","titling":"auto"}} 33:"$32:body" 2e:E{"digest":"NEXT_REDIRECT;replace;/@mjbo/how-to-tell-someones-age-when-all-you-know-is-their-name;307;"}