Public
Edited
Nov 17, 2022
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
unknowns
Type Table, then Shift-Enter. Ctrl-space for more options.

Insert cell
Wrangler(sexmf)
Insert cell
sexmfolder = aq
.from(sexmf)
.filter((d) => d["DecedentFirstName"] !== "ESSEX")
.filter((d) => d["DecedentFirstName"] !== "SEXTON")
.filter((d) => d["DecedentFirstName"] !== "SEXTUS")
.filter((d) => d["DecedentFirstName"] !== "SEXONDIN")
.filter((d) => op.match(d["DecedentAgeUnit"], "Yrs"))
.filter((d) => d["DecedentAge"] > 1)
.dedupe(
"YearofDeath",
"StateFileNumber",
"DecedentLastName",
"DecedentAgeUnit",
"DateofDeath"
)
Insert cell
SummaryTable(sexmf)
Insert cell
SummaryTable(sexmfolder)
Insert cell
nameless = FileAttachment("Nameless.csv").csv({ typed: true })
Insert cell
SummaryTable(nameless)
Insert cell
Wrangler(unknowns)
Insert cell
Insert cell
Insert cell
Insert cell
import { Wrangler, op } from "@observablehq/data-wrangler"
Insert cell
import { SummaryTable } from "@observablehq/summary-table"
Insert cell

Purpose-built for displays of data

Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
Learn more