Published
Edited
Apr 8, 2020
Insert cell
Insert cell
Insert cell
fiveResults = sql(`SELECT * FROM ? LIMIT 5`, [data_medicare_gov])
Insert cell
listOfMedicareDataAvailableByTitle = sql('select Lat, Long_ FROM ?', [time_series_covid19_confirmed_US])
Insert cell
sumOfAllCasesByState = sql(`SELECT state, SUM(cases) as cases, SUM(deaths) as deaths FROM ? GROUP BY state Order By cases desc`, [nytimes_covid_19_data_us_states])
Insert cell
sumOfCasesOrderedByDeaths = sql(`SELECT * FROM ? ORDER BY deaths`, [sumOfAllCasesByState])
Insert cell
Insert cell
md`### Table

Using \`sumOfAllCasesByState\`

${printTable(sumOfAllCasesByState)}`
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
Insert cell
Insert cell
Insert cell
Insert cell
sql = require('alasql')
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