The end-to-end solution for building and hosting better data apps, dashboards, and reports.
SQL Mystery GameSQL TutorialData Table TutorialSolving the SQL Mystery Game
SQL Murder Mystery in DuckDB
db = FileAttachment("sql-murder-mystery.db").sqlite()
db
tables
function convertDates(data, dateField) {
for (let row of data) {
const date = ""+row[dateField];
row[dateField] = date.slice(0, 4)+"-"+date.slice(4, 6)+"-"+date.slice(6, 8);
}
return data;
}
allData = {
let data = {};
for (let t of tables) {
if (t.name !== 'solution') {
data[t.name] = await db.query(`SELECT * FROM ${t.name};`)
if (t.name === 'crime_scene_report' || t.name === 'facebook_event_checkin') {
data[t.name] = convertDates(data[t.name], 'date');
} else if (t.name === 'get_fit_now_check_in') {
data[t.name] = convertDates(data[t.name], 'check_in_date');
} else if (t.name === 'get_fit_now_member') {
data[t.name] = convertDates(data[t.name], 'membership_start_date');
}
}
}
return data;
}
mysteryDuck = DuckDBClient.of(allData)
mysteryDuck
Type Table, then Shift-Enter. Ctrl-space for more options.
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.
