Platform
Resources
Pricing
Sign in
Contact us
Michaël Guitton
Over 2 decades of experience on the Web…
Workspace
Fork
Public
Flat Data
By
Michaël Guitton
Edited
Aug 13, 2024
Paused
ISC
Comments locked
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
mapping
Filter
Columns
Sort
Slice
Save
Type Table, then Shift-Enter. Ctrl-space for more options.
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
synopsis
=
query
.
map
(
(
row
)
=>
(
{
Status
:
row
[
0
]
,
Count
:
row
[
1
]
.
length
}
)
)
Insert cell
query
=
d3
.
groups
(
records
,
(
row
)
=>
row
.
Set
)
Insert cell
pivot
=
query
.
map
(
(
item
)
=>
(
{
Status
:
item
[
0
]
,
Entries
:
item
[
1
]
.
map
(
cut
)
}
)
)
Insert cell
pivot
.
slice
(
)
.
sort
(
(
a
,
b
)
=>
a
.
Status
.
localeCompare
(
b
.
Status
)
)
Insert cell
pivot
.
slice
(
)
.
sort
(
(
a
,
b
)
=>
b
.
Entries
.
length
-
a
.
Entries
.
length
)
Insert cell
lookup
=
Object
.
fromEntries
(
query
.
sort
(
(
a
,
b
)
=>
a
[
0
]
.
localeCompare
(
b
[
0
]
)
)
.
map
(
(
item
)
=>
[
item
[
0
]
,
item
[
1
]
.
map
(
cut
)
]
)
)
Insert cell
sets
=
Object
.
keys
(
lookup
)
Insert cell
Insert cell
Insert cell
Insert cell
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
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
view
Copy import
Select
Duplicate
Copy link
Embed
Delete
Cells
mapping
File attachments
Databases
Filter
Column
Operator
Columns
Sort
Column
Direction
Descending
Ascending
Slice
From
Start
To
End
Edit
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
filter
Edit
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
mapping
Edit
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
synopsis
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
query
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
pivot
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
lookup
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
sets
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
columns
Edit
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
records
Edit
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
endpoint
Edit
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
cut
Edit
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML