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
data
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
Insert cell
Insert cell
// @see {@link https://www.typescriptlang.org/docs/handbook/variable-declarations.html#property-renaming}
lookup
=
Object
.
fromEntries
(
query
.
sort
(
(
a
,
b
)
=>
a
[
0
]
.
localeCompare
(
b
[
0
]
)
)
.
map
(
(
item
)
=>
[
item
[
0
]
,
item
[
1
]
.
map
(
(
{
"File-Date"
:
discard
,
Type
,
...
rest
}
)
=>
/* drop File-Date & Type keys */
rest
)
]
)
)
Insert cell
synopsis
=
query
.
map
(
(
row
)
=>
(
{
Type
:
row
[
0
]
,
Count
:
row
[
1
]
.
length
}
)
)
Insert cell
query
=
d3
.
groups
(
records
.
slice
(
1
)
,
(
row
)
=>
row
.
Type
)
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
title
Edit
Copy import
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
data
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
filter
Edit
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
registry
Edit
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
data
Edit
Copy import
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
types
Edit
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
lookup
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
Edit
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
fields
Edit
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
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