2e:null 2f:["$","title",null,{"children":"Genealogy Visualization Concept | Michael Bricknell | Observable"}] 34:[] 32:{"id":"280edf32efb79620","slug":"genealogy-visualization-concepts","title":"Genealogy Visualization Concept","thumbnail":"feff9a1d01d427347db6759e894fe49bb2efffbab99432179e78c1e8ff28aa12","access_level":"public","create_time":"$D2025-05-23T11:30:25.045Z","update_time":"$D2025-06-09T19:21:52.336Z","view_time":null,"first_public_time":"$D2025-05-23T11:52:24.536Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"aa36944c9e64c088","login":"mbrickmaps","name":"Michael Bricknell","avatar_url":"https://avatars-next.observableusercontent.com/2f0578a8eeb34ee1c8a3bd6be41477c4bc13989c0c53551154178a64c9f2945f","tier":"pro_2024"},"version":241,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"8a8aec8a4dd1da2d","login":"mbrickmaps","name":"Michael Bricknell","avatar_url":"https://avatars-next.observableusercontent.com/669d4a33f00b7dbf619507bedb374f580b5457ee3c0717ba47d37e4869518958","tier":null}],"members":[{"type":"individual","id":"8a8aec8a4dd1da2d","login":"mbrickmaps","name":"Michael Bricknell","avatar_url":"https://avatars-next.observableusercontent.com/669d4a33f00b7dbf619507bedb374f580b5457ee3c0717ba47d37e4869518958","tier":null,"role":"editor"},{"type":"team","id":"aa36944c9e64c088","login":"mbrickmaps","name":"Michael Bricknell","avatar_url":"https://avatars-next.observableusercontent.com/2f0578a8eeb34ee1c8a3bd6be41477c4bc13989c0c53551154178a64c9f2945f","tier":"pro_2024","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":{"id":"50906241d55409c7","slug":"geneaology","title":"Geneaology","owner":{"id":"aa36944c9e64c088","login":"mbrickmaps","name":"Michael Bricknell"}},"type":"notebook","body":{"title":"Genealogy Visualization Concept","cells":[{"id":0,"value":"# Genealogy Visualization Concept","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":6,"value":"import { FMP_geo as data } from \"@mbrickmaps/tracking-down-a-bricknell\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4,"value":"data","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":18,"value":"clustered = {\n const groups = new Map();\n\n for (const record of data) {\n const location = record.geo.search || \"Unknown\";\n const year = +record.data.Year;\n if (!year || year < 1500) continue;\n\n const decade = Math.floor(year / 10) * 10;\n const key = `${location}|${decade}`;\n\n if (!groups.has(key)) {\n groups.set(key, {\n location,\n decade,\n records: []\n });\n }\n\n groups.get(key).records.push(record);\n }\n\n return Array.from(groups.values());\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":21,"value":"clusters = clustered.map((group) => {\n const names = group.records\n .map((r) => r.data[\"First name(s)\"])\n .filter((n) => n && n !== \"—\");\n\n const years = group.records.map((r) => +r.data.Year).filter((y) => y > 0);\n\n return {\n location: group.location,\n decade: group.decade,\n count: group.records.length,\n uniqueNames: [...new Set(names)],\n yearSpan: years.length ? Math.max(...years) - Math.min(...years) : 0,\n avgYear: years.length\n ? Math.round(years.reduce((a, b) => a + b) / years.length)\n : group.decade\n };\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":47,"value":"clustersWithCountry = clusters.map((c) => {\n const group =\n []\n .concat(scottishRegions, englishRegions)\n .find((g) => c.location.includes(g)) || \"Other\";\n return { ...c, group };\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":29,"value":"migrations = {\n const nameMap = new Map();\n\n for (const record of data) {\n const name = record.data[\"First name(s)\"];\n if (!name || name === \"—\") continue;\n\n const year = +record.data.Year;\n const location = record.geo.match;\n if (!year || !location) continue;\n\n if (!nameMap.has(name)) nameMap.set(name, []);\n nameMap\n .get(name)\n .push({ year, location, record: record.data[\"Record set\"] });\n }\n\n return Array.from(nameMap.entries())\n .filter(([name, locs]) => {\n const uniqueLocs = [...new Set(locs.map((l) => l.location))];\n return uniqueLocs.length > 1 && locs.length > 2;\n })\n .map(([name, locs]) => ({\n name,\n locations: locs.sort((a, b) => a.year - b.year),\n locationCount: [...new Set(locs.map((l) => l.location))].length\n }))\n .sort((a, b) => b.locations.length - a.locations.length);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":36,"value":"locationSummary = d3\n .groups(clustersWithCountry, (d) => d.location)\n .map(([location, clusters]) => ({\n location,\n totalRecords: d3.sum(clusters, (d) => d.count),\n decades: clusters.map((d) => d.decade).sort(),\n span: d3.max(clusters, (d) => d.decade) - d3.min(clusters, (d) => d.decade),\n firstYear: d3.min(clusters, (d) => d.decade),\n lastYear: d3.max(clusters, (d) => d.decade)\n }))\n .sort((a, b) => b.totalRecords - a.totalRecords)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":119,"value":"selectedData = clustersWithCountry.filter(\n (c) =>\n c.count >= minRecords &&\n ([].concat(scottishRegions, englishRegions).includes(c.group) ||\n ([].concat(scottishRegions, englishRegions).includes(\"Other\") &&\n c.group === \"Other\"))\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":24,"value":"viewof minRecords = Inputs.range([1, 20], {\n value: 3,\n step: 1,\n label: \"Minimum records per cluster\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":126,"value":"Plot.plot({\n marks: [\n Plot.dot(selectedData, {\n x: \"decade\",\n y: \"group\",\n r: \"count\",\n fill: \"group\",\n tip: true\n })\n ],\n x: { label: \"Decade\" },\n y: {\n label: null,\n domain: d3\n .groupSort(\n selectedData,\n (g) => d3.min(g, (d) => d.decade),\n (d) => d.group // Changed from d.location to d.group\n )\n .reverse()\n },\n r: { range: [2, 20] },\n color: { scheme: \"category10\" },\n marginLeft: 100,\n width: 800,\n height: 200 + selectedData.length // Much more reasonable height\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":66,"value":"scottishRegions = [\"Longforgan\", \"Forfarshire\", \"Moray\", \"Edinburgh\", \"Dundee\"]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":69,"value":"englishRegions = [\n \"Warwickshire\",\n \"Devon\",\n \"Hampshire\",\n \"Ireland\",\n \"Oxfordshire\",\n \"London\",\n \"Kent\",\n \"Other\"\n]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":178,"value":"allTerms = clusters\n .flatMap((c) => c.location.split(/[,\\s]+/)) // Split by comma and space\n .map((term) => term.trim())\n .filter((term) => term && term !== \"\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":180,"value":"termCounts = d3.rollup(\n allTerms,\n (v) => v.length,\n (d) => d\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":185,"value":"sortedTerms = Array.from(termCounts, ([term, count]) => ({term, count}))\n .sort((a, b) => b.count - a.count)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":193,"value":"// Add names display to your clusters\nclustersWithNames = clusters.map((c) => ({\n ...c,\n namesList: c.uniqueNames.join(\", \"),\n nameCount: c.uniqueNames.length\n}))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":206,"value":"

Name Statistics

Total Records: ${nameSummary.totalRecords}

Records with Names: ${nameSummary.recordsWithNames}

Unique First Names: ${nameSummary.uniqueNames}

Most Common: ${nameSummary.mostCommonName.name} (${nameSummary.mostCommonName.count} records)

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":195,"value":"clusterDetails = Inputs.table(\n clustersWithNames.filter((c) => c.count >= minRecords),\n {\n columns: [\"location\", \"decade\", \"count\", \"nameCount\", \"namesList\"],\n header: {\n location: \"Location\",\n decade: \"Decade\",\n count: \"Records\",\n nameCount: \"Unique Names\",\n namesList: \"Names\"\n },\n width: {\n location: 200,\n namesList: 400\n },\n rows: 20\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":197,"value":"nameFrequency = d3.rollup(\n data.filter(\n (d) => d.data[\"First name(s)\"] && d.data[\"First name(s)\"] !== \"—\"\n ),\n (v) => v.length,\n (d) => d.data[\"First name(s)\"]\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":199,"value":"topNames = Array.from(nameFrequency, ([name, count]) => ({ name, count })).sort(\n (a, b) => b.count - a.count\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":202,"value":"nameSummary = ({\n totalRecords: data.length,\n recordsWithNames: data.filter(\n (d) => d.data[\"First name(s)\"] && d.data[\"First name(s)\"] !== \"—\"\n ).length,\n uniqueNames: nameFrequency.size,\n mostCommonName: topNames[0]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":212,"value":"namesByDecade = data\n .filter(\n (d) =>\n d.data[\"First name(s)\"] &&\n d.data[\"First name(s)\"] !== \"—\" &&\n +d.data.Year > 0\n )\n .map((d) => ({\n name: d.data[\"First name(s)\"],\n decade: Math.floor(+d.data.Year / 10) * 10,\n year: +d.data.Year\n }))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":214,"value":"nameDecadeCounts = d3.rollup(\n namesByDecade,\n v => v.length,\n d => d.name,\n d => d.decade\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":217,"value":"nameTimeline = Array.from(nameDecadeCounts, ([name, decades]) =>\n Array.from(decades, ([decade, count]) => ({ name, decade, count }))\n).flat()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":219,"value":"topNamesOverTime = topNames.slice(0, 10).map((d) => d.name)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":228,"value":"viewof selectedNames = Inputs.checkbox(\n topNames.slice(0, 20).map((d) => d.name),\n { value: [\"Andrew\", \"John\", \"Mary\", \"William\"], label: \"Select names:\" }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":226,"value":"selectedNamesData = selectedNames.flatMap((name) => {\n const nameData = d3.rollup(\n namesByDecade.filter((d) => d.name === name),\n (v) => v.length,\n (d) => d.decade\n );\n\n // Get all decades in the data\n const allDecades = [...new Set(namesByDecade.map((d) => d.decade))].sort();\n\n // Fill in missing decades with 0\n return allDecades.map((decade) => ({\n name,\n decade,\n count: nameData.get(decade) || 0\n }));\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":221,"value":"Plot.plot({\n marks: [\n Plot.barY(selectedNamesData, {\n x: \"decade\",\n y: \"count\",\n fill: \"name\",\n tip: true\n }),\n Plot.ruleY([0])\n ],\n x: { label: \"Decade\" },\n y: { label: \"Number of Records\" },\n color: { legend: true },\n width: 800,\n height: 400\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W34","stdlib":"1","titling":"auto"}} 33:"$32:body"