The avatar for @zhik
Zhi Keng He
Public
oca-eviction-data
Edited
Aug 10, 2022
oca-eviction-data
Overview of cases and their queries in the OCA database
Insert cell
Insert cell
Insert cell
Insert cell
nycdb
select * from oca_index limit 5
Insert cell
Insert cell
Insert cell
nycdb
select classification, count(indexnumberid) from oca_index group by classification order by count desc
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
nycdb
select fileddate, count(indexnumberid) from oca_index group by fileddate order by fileddate desc limit 30
Insert cell
Plot.plot({
grid: true,
width: width,
x: {
tickFormat: (date) => d3.timeFormat("%B %d")(date) //format date to show month and day
},
marks: [Plot.barY(cases_count_by_date, { y: "count", x: "fileddate" })] // grab the data
})
Insert cell
Insert cell
nycdb
select * from oca_addresses limit 10
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