Platform
Resources
Pricing
Sign in
Get started
James Trimble's ONS work
Dataviz at Office for National Statistics (UK)
Workspace
Fork
Published
By
James Trimble's ONS work
Edited
Jun 22, 2021
1 fork
1
Insert cell
Insert cell
1
dataTable
=
JSONstat
(
await
FileAttachment
(
"hibeta.json"
)
.
json
(
)
)
.
toTable
(
)
Insert cell
tidyData
=
{
let
fields
=
dataTable
[
0
]
;
let
result
=
[
]
;
for
(
let
i
=
1
;
i
<
dataTable
.
length
;
i
++
)
{
let
tableRow
=
dataTable
[
i
]
;
let
outputRow
=
{
}
;
tableRow
.
forEach
(
(
d
,
i
)
=>
(
outputRow
[
fields
[
i
]
]
=
d
)
)
;
result
.
push
(
outputRow
)
;
}
return
result
;
}
Insert cell
table
(
tidyData
,
{
sortable
:
true
}
)
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.
Try it for free
Learn more
Fork
View
Export
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
dataTable
Show 1 comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
tidyData
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
JSONstat
Edit
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML