Published
Edited
Dec 10, 2020
5 stars
2021 Pride Month and LGBTQIA+ EqualityWomen in the German Bundestag by PartyAnti-Trans Legislation TrackerThe Racial Wealth GapGeorge Floyd Protests:
Press Freedom Violations Per DayRacial demographic dot-density mapA Growing Threat to Life: Taser usage by Greater Manchester PoliceThe Woman Citizen's Wheel of Progress, 1917Rejected Mail Ballots in North CarolinaPride Month and LGBTQIA+ EqualityBlack Lives Matter and Anti-RacismJuneteenth: History and ResourcesBlack Lives Matter and Racial Equality Resources
How much money does MTC owe Mississippi for vacant guard jobs?
Also listed in…
data/Releases
data = rawData.map(d => ({
...d,
supervisor_vacancy: d.authorized_supervisors - d.ft_supervisors,
co_vacancy: d.authorized_cos - d.ft_cos,
vacancy:
d.authorized_supervisors + d.authorized_cos - d.ft_supervisors - d.ft_cos
}))
totalVacanciesMarshall = marshallMonthlyVacancies.reduce(function(sum, d) {
return sum + d.vacancy;
}, 0)
marshallMonthlyVacancies = data.filter(
d =>
d.facility === 'Marshall' &&
d.co_vacancy > 0 &&
d.supervisor_vacancy > -1 && // In one month, there is a clear data entry error that causes supervisor vacancies to be negative
d.date >= moment(marshallStartDate) &&
d.date <= moment(marshallEndDate)
)
marshallMonthlyCostPerVacancy = marshallMonthlyVacancies.map(d => ({
date: d.date,
cost_per_vacancy: d.mandatory_post_remittances / d.vacancy,
vacancy: d.vacancy,
mandatory_post_remittances: d.mandatory_post_remittances,
ref: d
}))
calculateExpected = (facilityName, filtered) => {
const facility = filtered.filter(d => d.facility === facilityName);
const remittances = d3.sum(facility, d => d.mandatory_post_remittances);
const expected = d3.sum(facility, d => d.vacancy * assumedVacancyCost);
return Math.trunc(expected - remittances);
}
wilkinsonExpectedRefund = calculateExpected("Wilkinson", data)
emcfExpectedRefund = calculateExpected("EMCF", data)
rawData = d3.csv(
`${URLROOT}/mdoc-remittances20201103/assets/mdoc-remittances-combined.${fileVersion}.csv`,
d => ({
date: moment(d.month, "MMMM YYYY"),
facility: d.facility,
billed: +d.billed,
paid: +d.paid,
mandatory_post_remittances: +d.mandatory_post_remittances,
ft_cos: +d.ft_cos,
ft_supervisors: +d.ft_supervisors,
authorized_cos: +d.authorized_cos,
authorized_supervisors: +d.authorized_supervisors
})
)
moment = require("moment")
d3 = require("d3@6", "d3-array@2")
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.
