The avatar for @observablehq
Observable
The end-to-end solution for building and hosting better data apps, dashboards, and reports.
Public
Edited
Apr 5, 2023
29 forks
33 stars
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
// Describe the tables in the database
db.describe()
Insert cell
Insert cell
db
select * from items
Insert cell
Insert cell
// type your code here

Insert cell
Insert cell
Insert cell
Insert cell
db
-- type your SQL code here
select * from events where type = 'purchase'
Insert cell
Insert cell
Insert cell
Insert cell
db
select * from events
join items on events.item_id = items.id
where type = 'purchase'
LIMIT 5
Insert cell
Insert cell
db
select name, category, brand,
count(*)::int as count,
sum(price_in_usd)::int as revenue
from events
join items on events.item_id = items.id
where type = 'purchase'
group by name, category, brand
order by revenue desc
Insert cell
// type your code here

Insert cell
Insert cell
Insert cell
Insert cell
// type your code here

Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
// type your code here

Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
// type your code here

Insert cell
Insert cell
Insert cell
Insert cell
// type your code here

Insert cell
Insert cell
Insert cell
Insert cell
// type your code here

Insert cell
Insert cell
Insert cell
Insert cell
// type your code here

Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
// type your code here

Insert cell
Insert cell
Insert cell
Insert cell
// type your code here

Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
// type your code here

Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
// type your code here

Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
// type your code here

Insert cell
Insert cell
Insert cell
// Get the unique list of brands in the dataset for the checkboxes below
brandOptions = new Set(items.map(d => d.brand))
Insert cell
Insert cell
// type your code here

Insert cell
Insert cell
Insert cell
Insert cell
// type your code here

Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
// type your code here
Insert cell
Insert cell
Insert cell
Insert cell
viewof reducer = Inputs.radio(["mean", "min", "max", "deviation", "sum"], {
value: "mean",
label: "Summary statistic (reducer):"
})
Insert cell
Insert cell
// type your code here
Insert cell
Insert cell
Insert cell
Insert cell
db
select brand, date_trunc('day', date) as day, SUM(price_in_usd)::INT as revenue from events
left join items on events.item_id = items.id
where type = 'purchase'
group by brand, day
Insert cell
Insert cell
// type your code here
Insert cell
Insert cell
Insert cell
Insert cell
viewof k = Inputs.range([1, 30], {
label: "Number of days for moving average (K)",
value: 7,
step: 1
})
Insert cell
// type your code here
Insert cell
Insert cell
Insert cell
Insert cell
import { Treemap } from "@d3/treemap"
Insert cell
tree = Treemap(items, {
path: (d) => d.category + "/" + d.name,
value: (d) => d?.revenue, // size of each node
group: (d) => d.category, // for color
label: (d, n) => d.name + "\n" + numformat(d.revenue) + "\n " + d.category,
width: width,
height: 700
})
Insert cell
numformat = d3.format(",d")
Insert cell
Insert cell
import {showMe} from "@observablehq/show-me"
Insert cell
import {toc} from "@nebrius/indented-toc"
Insert cell
sampleData = d3.range(100).map(d => ({x: Math.random(), y: Math.random()}))
Insert cell
Insert cell
getSnippet = () => svg`<svg width="16" height="20" viewBox="0 -4 16 16" fill="none"><path d="M13 3H3C2.44772 3 2 3.44772 2 4V12C2 12.5523 2.44772 13 3 13H13C13.5523 13 14 12.5523 14 12V4C14 3.44772 13.5523 3 13 3Z" stroke="currentColor" stroke-width="2"></path><rect x="4" y="9" width="2" height="2" rx="0.5" fill="currentColor"></rect><rect x="7" y="5.5" width="2" height="5.5" rx="0.5" fill="currentColor"></rect><rect x="10" y="7" width="2" height="4" rx="0.5" fill="currentColor"></rect></svg>`
Insert cell
getTop10 = () => svg`<svg width="30" height="20" viewBox="0 0 60 25" fill="none" class="jsx-98319bc75a420d73 mr2 ba b--light-gray moon-gray snippet-thumbnail" style="border-radius: 5px;"><rect width="60" height="40" rx="4" fill="#F5F5F5"></rect><rect x="8.5" y="8.5" width="43" height="23" rx="1.5" fill="white" stroke="currentColor"></rect><rect x="10" y="10" width="33" height="6" rx="1" fill="currentColor"></rect><rect x="10" y="17" width="16" height="6" rx="1" fill="currentColor"></rect><rect x="10" y="24" width="10" height="6" rx="1" fill="currentColor"></rect></svg>`
Insert cell
getScatter = () => svg`<svg width="30" height="20" viewBox="0 0 60 40" fill="none" class="jsx-285534909 mr2 ba b--light-gray moon-gray snippet-thumbnail" style="border-radius: 5px;"><rect width="60" height="40" rx="4" fill="#F5F5F5"></rect><rect x="8.5" y="8.5" width="43" height="23" rx="1.5" fill="white" stroke="#C4C4C4"></rect><circle cx="15.5" cy="25.5" r="2" stroke="currentColor"></circle><circle cx="19.5" cy="20.5" r="2" stroke="currentColor"></circle><circle cx="21.5" cy="21.5" r="2" stroke="currentColor"></circle><circle cx="33.5" cy="19.5" r="2" stroke="currentColor"></circle><circle cx="39.5" cy="18.5" r="2" stroke="currentColor"></circle><circle cx="41.5" cy="17.5" r="2" stroke="currentColor"></circle><circle cx="28.5" cy="23.5" r="2" stroke="currentColor"></circle><circle cx="25.5" cy="17.5" r="2" stroke="currentColor"></circle><circle cx="45.5" cy="13.5" r="2" stroke="currentColor"></circle></svg>`
Insert cell
getRange = () =>
svg`<svg width="40" height="20" viewBox="0 0 60 30" fill="none" class="jsx-285534909 mr2 ba b--light-gray moon-gray snippet-thumbnail" style="border-radius: 5px;"><rect width="60" height="40" rx="4" ></rect><rect x="7.5" y="17.5" width="47" height="5" rx="2.5" fill="white" stroke="currentColor"></rect><rect x="7" y="17" width="33" height="6" rx="3" fill="currentColor"></rect><circle cx="38" cy="20" r="5.5" fill="white" stroke="currentColor"></circle></svg>`
Insert cell

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.
Learn more