BRATENAHL TRAFFIC STOPS (CLEAN)
Inputs.table(dt)
totalStops = dt.count().objects()[0]["count"]
unknownRace = dt
.filter((d) => d["race"] == "U")
.count()
.objects()[0]["count"]
stopsbyrace = dt
.groupby("race")
.count()
.derive({
pct: (row) => (row.count / aq.op.sum(row.count)) * 100
})
Inputs.table(stopsbyrace)
racenotlisted = dt
.filter((d) => d["race"] === "")
.groupby("dispo")
.count()
.derive({
pct: (row) => (row.count / aq.op.sum(row.count)) * 100
})
.view()
raceGrouped = dt
.groupby("race", "dispo")
.count()
.groupby("race")
.derive({
pct: (row) => row.count / aq.op.sum(row.count)
})
.orderby("race", aq.desc("pct"))
.derive({
count: aq.escape((d) => (typeof d.count == "undefined" ? 0 : d.count))
})
.pivot("dispo", "count")
Inputs.table(raceGrouped)
racearrests = dt
.filter((d) => d["dispo"] === "ARREST")
.groupby("race")
.count()
.derive({
pct: (row) => (row.count / aq.op.sum(row.count)) * 100
})
.orderby("race", aq.desc("pct"))
Inputs.table(racearrests)
racearrestspct = dt
.filter((d) => d["dispo"] === "ARREST")
.filter((d) => d["race"] !== "")
.groupby("race")
.count()
.derive({
pct: (row) => (row.count / aq.op.sum(row.count)) * 100
})
.orderby("race", aq.desc("pct"))
racecitation = dt
.filter((d) => d["dispo"] === "CITE ISSUED")
.groupby("race")
.count()
.derive({
pct: (row) => (row.count / aq.op.sum(row.count)) * 100
})
.orderby("race", aq.desc("pct"))
Inputs.table(racecitation)
racecitationpct = dt
.filter((d) => d["dispo"] === "CITE ISSUED")
.filter((d) => d["race"] !== "")
.filter((d) => d["race"] !== "U")
.groupby("race")
.count()
.derive({
pct: (row) => (row.count / aq.op.sum(row.count)) * 100
})
.orderby("race", aq.desc("pct"))
dt
.filter((d) => d.race == "A")
.derive({
consequence: (d) =>
op.includes(["ARREST", "CITE ISSUED", "CITE SRAD"], d["dispo"])
? "consequence"
: "no_consequence"
})
.orderby((d) => d.consequence)
.view()
dt
.derive({
consequence: (d) =>
op.includes(["ARREST", "CITE ISSUED", "CITE SRAD"], d["dispo"])
? "consequence"
: "no_consequence"
})
.groupby("race", "consequence")
.count()
.impute({ count: () => 0 })
.groupby("race")
.derive({
pct: (row) => row.count / aq.op.sum(row.count)
})
.orderby("race", aq.desc("pct"))
.derive({
count: aq.escape((d) => (typeof d.count == "undefined" ? 0 : d.count))
})
.pivot("consequence", "count")
.derive({
pct: (row) =>
Math.round(
(row.consequence / (row.consequence + row.no_consequence)) * 10000
) / 100
})
.view()
// Parse datetime objects and extract day of week
dtDayOfWeek = dt
.derive({ dateWithoutTime: (d) => op.replace(d["date"], " 0:00", "") })
.derive({ dateSplit: (d) => op.split(d["dateWithoutTime"], "/") })
.spread("dateSplit", { as: ["monthClean", "dateClean", "yearClean"] })
.derive({
dateTimeObject: (d) =>
// Really weird how op.datetime counts month from 0. Just, why?
op.datetime(d["yearClean"], d["monthClean"] - 1, d["dateClean"])
})
.derive({
dayOfWeekClean: aq.escape((d) =>
d["dateTimeObject"].toLocaleString("en-us", { weekday: "long" })
)
})
stops2020 = dtDayOfWeek.filter((d) => d.yearClean === "2020")
totalStops2020 = stops2020.count().objects()[0]["count"]
stopsbyrace20 = stops2020
.groupby("race")
.count()
// .groupby("race")
.derive({
pct: (row) => row.count / aq.op.sum(row.count)
})
.orderby("race", aq.desc("pct"))
Inputs.table(stopsbyrace20)
stops2021 = dtDayOfWeek.filter((d) => d.yearClean === "2021")
totalStops2021 = stops2021.count().objects()[0]["count"]
stopsbyrace21 = stops2021
.groupby("race")
.count()
// .groupby("race")
.derive({
pct: (row) => row.count / aq.op.sum(row.count)
})
.orderby("race", aq.desc("pct"))
Inputs.table(stopsbyrace21)
racedispoGrouped21 = stops2021
.groupby("race", "dispo")
.count()
.groupby("race")
.derive({
pct: (row) => row.count / aq.op.sum(row.count)
})
.orderby("race", aq.desc("pct"))
.derive({
count: aq.escape((d) => (typeof d.count == "undefined" ? 0 : d.count))
})
.pivot("dispo", "count")
Inputs.table(dtDayOfWeek)
raceGrouped
.derive({
consequences: (d) => d.ARREST + d["CITE ISSUED"] + d["CITE SRAD"]
})
.view()
Inputs.table(racearrestspct)
Inputs.table(racecitationpct)
stops = aq.from(
await FileAttachment("Jan 1 2020- Sept 15 2022 .xls - callracesex.csv").csv()
)
jan12020Sept152022XlsCallracesex = FileAttachment("Jan 1 2020- Sept 15 2022 .xls - callracesex.csv").csv()
import { addTooltips } from "@mkfreeman/plot-tooltip"
import { Plot } from "@mkfreeman/plot-tooltip"
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.
