Platform
Resources
Pricing
Sign in
Get started
Patrick Wojda
Workspace
Fork
Public
By
Patrick Wojda
Edited
May 3, 2023
1 star
Insert cell
Insert cell
Insert cell
Insert cell
ds
=
JSONstat
(
jsonURL
)
Insert cell
Insert cell
dtRaw
=
aq
.
table
(
ds
.
toTable
(
{
type
:
"objarr"
,
content
:
"id"
,
}
)
// show raw data
)
Insert cell
Insert cell
dtRaw
.
view
(
)
Insert cell
Insert cell
Insert cell
dtParsed
=
aq
.
table
(
ds
.
toTable
(
{
type
:
"objarr"
,
content
:
"label"
}
)
// show parsed data
)
Insert cell
dtParsed
.
view
(
)
Insert cell
dtParsed
.
dedupe
(
'age'
)
.
array
(
'age'
)
Insert cell
Insert cell
Insert cell
dtRaw
.
columnNames
(
)
Insert cell
Insert cell
dtRaw
.
dedupe
(
'age'
)
.
array
(
'age'
)
Insert cell
Insert cell
Insert cell
ds
.
toTable
(
{
type
:
"arrobj"
,
content
:
"id"
,
}
,
(
d
,
i
)
=>
{
const
geoLabel
=
ds
.
Dataset
(
"dataset"
)
.
Dimension
(
"geo"
)
.
Category
(
d
.
geo
)
.
label
;
delete
d
.
unit
;
delete
d
.
freq
;
delete
d
.
age
;
delete
d
.
time
;
return
{
...
d
,
geoLabel
:
geoLabel
}
}
)
Insert cell
Insert cell
dtRaw
.
toCSV
(
)
// .toTSV(), .toJSON(), etc.
Insert cell
Insert cell
Insert cell
import
{
aq
,
op
}
from
'@uwdata/arquero'
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.
Try it for free
Learn more
Fork
View
Export
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
jsonURL
Edit
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
ds
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
dtRaw
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
dtParsed
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML