data = {
let data = d3.csvParse(
await (
await (
await fetch(
"https://docs.google.com/spreadsheets/d/e/2PACX-1vQBEbQoWMn_P81DuwmlQC0_jr2sJDzkkC0mvF6WLcM53ZYXi8RMfUlunvP1B5W0jRrJvH-wc-WGjDB1/pub?gid=0&single=true&output=csv"
)
).text()
).replace("location", "city")
);
data.forEach(function (o) {
o.location = o.location.trim().toLowerCase();
o.year = parseInt(o.year);
o.fatalities = parseInt(o.fatalities);
o.latitude = parseFloat(o.latitude);
o.longitude = parseFloat(o.longitude);
let date;
date = d3.timeParse("%m/%d/%y")(o.date);
if (date == null) {
date = d3.timeParse("%m/%d/%Y")(o.date);
}
o.date = date;
if (date.getTime() == 1653364800000) {
o.latitude = 29.1995881;
o.longitude = -99.7903341;
} else if (date.getTime() == 1652500800000) {
o.latitude = 42.9097295;
o.longitude = -78.855039;
}
});
data = d3.sort(data, (o) => o.fatalities);
data.reverse();
data.extent = d3.extent(data.map((o) => o.year));
return data;
}