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'
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.
