COVID-19s Impact on Air TravelTraffic Lattice GermanyTraffic in the Pandemic by Distance
Weekend Mobility in Germany during the Pandemic
md`## Plot Specs`
md`## Data`
hourly_big3 = {
aq.addFunction(
"parse_ts",
(ts) => {
const date = new Date(ts);
const year = date.getUTCFullYear();
const month = date.getUTCMonth();
const day = date.getUTCDate();
const hour = date.getUTCHours();
return op.datetime(year, month, day, hour);
},
{
override: true
}
);
var raw = await aq.loadArrow(
await FileAttachment("hourly_big3_tl_20210825.arrow").url()
);
raw = raw.derive({ date: (d) => op.parse_ts(d.date) });
return raw;
}
daily_big3.orderby(aq.desc('date')).view(3)
daily_big3 = {
aq.addFunction(
"parse_ts",
(ts) => {
const date = new Date(ts);
const year = date.getUTCFullYear();
const month = date.getUTCMonth();
const day = date.getUTCDate();
const hour = date.getUTCHours();
return op.datetime(year, month, day, hour);
},
{
override: true
}
);
var raw = await aq.loadArrow(
await FileAttachment("daily_big3_20210824.arrow").url(),
{ autoType: true }
);
raw = raw.derive({ date: (d) => op.parse_ts(d.date) }, { before: "trips" });
return raw;
}
weather_big3.orderby(aq.desc("datetime")).view(3)
weather_big3 = {
const map_nuts3 = new Map([
[403, "DE300"],
[1975, "DE600"],
[3379, "DE212"]
]);
aq.addFunction("map_stations", (id) => map_nuts3.get(id), { override: true });
aq.addFunction(
"parse_ts",
(ts) => {
const date = new Date(ts);
const year = date.getUTCFullYear();
const month = date.getUTCMonth();
const day = date.getUTCDate();
const hour = date.getUTCHours();
return op.datetime(year, month, day, hour);
},
{
override: true
}
);
aq.addFunction("formatd3", d3.timeFormat("%b %d"), { override: true });
var raw = await aq.loadArrow(
await FileAttachment("weather_big3_20210824.arrow").url()
);
raw = raw
.derive(
{ nuts3: (d) => op.map_stations(d.stations_id) },
{ before: "date" }
)
.derive({ datetime: (d) => op.parse_ts(d.date) }, { before: "temp_mean" })
.derive({ date_label: (d) => op.formatd3(d.date) })
.select(aq.not("stations_id", "date"));
return raw;
}
_ = require("lodash@4.17.21")
import { aq, op } from '@uwdata/arquero'
vegalite = require('vega-lite@v5.1')
import { vl } from '@vega/vega-lite-api-v5'
d3 = require('d3@v6')
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.
