tidy = (raw, type, regionKey, subRegionKey) => {
const data = [];
for (const d of raw) {
for (const column of Object.keys(d)) {
const date = parseDateMDY(column);
if (date === null) {
continue;
}
data.push(
{
type,
region: d[regionKey],
subRegion: d[subRegionKey],
lat: +d["Lat"],
long: +(d["Long"] || d["Long_"]),
ymd: d3.timeFormat("%Y-%m-%d")(date),
date,
total: parseInt(d[column], 10),
},
);
}
}
return data;
}