Software engineer, available for freelance work! • he/him/his
db = DatasetteClient("https://ds.agarcia.dev/congress/congress-members")
db`
SELECT
bioguide,
first_name,
last_name
FROM members
WHERE first_name LIKE "ALEX%"
LIMIT 25;`
info = db.info()
viewof millennialMembers = db.table`
SELECT bioguide,
first_name,
last_name,
CAST(strftime('%Y', DATE(birthday)) AS INTEGER) AS birth_year
FROM members
WHERE
birth_year >= 1981
AND birth_year <= 1996
ORDER BY birth_year DESC`
millennialMembers
viewof party = html`<select>
<option>Democrat</option>
<option>Republican</option>
<option>Independent</option>`
db.table`
SELECT
full_name,
terms.type,
terms.state,
terms.party,
terms.start,
terms.end
FROM members
LEFT JOIN terms ON terms.member = members.bioguide
GROUP BY bioguide
HAVING
date(max(terms.end)) > date("now")
and terms.type = "sen"
and terms.party = ${party}
ORDER BY state ASC`
// Note: There are more than these two genders! But in this dataset of members of US Congress, there are only "M" and "F" values in the gender field (so far!)
viewof gender = html`<select>
<option>M</option>
<option selected>F</option>`
beforeDate = '1900-01-01'
// Try removing the "dry" to see the results of the query!
db.dry`SELECT * FROM members WHERE gender = ${gender} AND birthday < ${beforeDate}`
viewof selectedMembers = html`<select multiple>
<option selected>alexandria</option>
<option selected>ilhan</option>
<option>nancy</option>
<option>mitt</option>
<option>karen</option>`
db.table`
SELECT *
FROM members
WHERE LOWER(first_name) in
${selectedMembers}`
db.table`select from members;`
db.table`select not_exist from members;`
chartData = Object.assign(
repsGenerations.map(d => ({ ...d, date: new Date(d.date) })),
{ columns: repsGenerations.columns }
)
color = d3
.scaleOrdinal()
.domain(chartData.columns.slice(1))
.range(['#ccc', '#2b6455', '#53887b', '#ddc172', '#c79a27'])
import { d3, chart, swatches } with {
chartData as data,
color
} from '@d3/stacked-area-chart'
swatches({ color })
chart
import { DatasetteClient } from '@asg017/datasette-client-core'
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.