The avatar for @clinton-brownley
Clinton Brownley
Data Scientist, Author, DataVis, Educator, Speaker, Public Service @ClintonBrownley https://cbrownley.github.io
Public
Edited
May 30, 2023
Fork of SQL Course: Session 1
Insert cell
Insert cell
Insert cell
Insert cell
import { pizzeriaDB } from "@observablehq/pizza-paradise-data"
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
whereIHaveLived = [
{ location: "Long Island", date: "2000-01-01" },
{ location: "Poughkeepsie", date: "2005-09-01" },
{ location: "Prague", date: "2007-09-01" },
{ location: "Poughkeepsie", date: "2008-01-01" },
{ location: "Brooklyn", date: "2009-06-01" },
{ location: "Boulder", date: "2011-08-01" },
{ location: "Brooklyn", date: "2013-04-01" },
{ location: "Boulder", date: "2019-12-01" }
]
Insert cell
whereIHaveLived
SELECT * FROM whereIHaveLived
Insert cell
Insert cell
Insert cell
pizzeriaDB
Type SQL, then Shift-Enter. Ctrl-space for more options.

Insert cell
Insert cell
Insert cell
pizzeriaDB
Type SQL, then Shift-Enter. Ctrl-space for more options.

Insert cell
Insert cell
Insert cell
pizzeriaDB
Type SQL, then Shift-Enter. Ctrl-space for more options.

Insert cell
Insert cell
pizzeriaDB
Type SQL, then Shift-Enter. Ctrl-space for more options.

Insert cell
Insert cell
Insert cell
pizzeriaDB
Type SQL, then Shift-Enter. Ctrl-space for more options.

Insert cell
Insert cell
pizzeriaDB
Type SQL, then Shift-Enter. Ctrl-space for more options.

Insert cell
Insert cell
pizzeriaDB
Type SQL, then Shift-Enter. Ctrl-space for more options.

Insert cell
Insert cell
pizzeriaDB
Type SQL, then Shift-Enter. Ctrl-space for more options.

Insert cell
Insert cell
pizzeriaDB
Type SQL, then Shift-Enter. Ctrl-space for more options.

Insert cell
Insert cell
pizzeriaDB
Type SQL, then Shift-Enter. Ctrl-space for more options.

Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
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