The avatar for @randomfractals
Taras Novak
I map 🗺️ & graph 📈 data 🈸
Public
Tables
Edited
Aug 31, 2023
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
db
SHOW TABLES
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
tableColumns = db.sql([`SHOW COLUMNS FROM ${table};`])
Insert cell
Insert cell
Insert cell
viewof tableSummary = SummaryTable(data, {label: table})
Insert cell
Insert cell
Insert cell
Insert cell
data = db.sql([`SELECT * FROM ${table} LIMIT -${rowLimit}`])
Insert cell
Insert cell
viewof queryEditor = Wrangler(data)
Insert cell
Insert cell
db
SELECT * FROM weather LIMIT -1000
Insert cell
Insert cell
Insert cell
tablesDiagram = diagram(db)
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell

One platform to build and deploy the best data apps

Experiment and prototype by building visualizations in live JavaScript notebooks. Collaborate with your team and decide which concepts to build out.
Use Observable Framework to build data apps locally. Use data loaders to build in any language or library, including Python, SQL, and R.
Seamlessly deploy to Observable. Test before you ship, use automatic deploy-on-commit, and ensure your projects are always up-to-date.
Learn more