Platform
Resources
Pricing
Sign in
Get started
JR
Workspace
Fork
Public
By
JR
Edited
Apr 25, 2023
1
Insert cell
Insert cell
db
=
FileAttachment
(
"sql-murder-mystery.db"
)
.
sqlite
(
)
Insert cell
interviews
=
db
.
query
(
`select * from interview where person_id in (14887, 16371, 67318)`
)
Insert cell
Inputs
.
table
(
interviews
)
Insert cell
interviews
.
map
(
d
=>
d
.
transcript
)
Insert cell
Inputs
.
table
(
interviews
,
{
width
:
{
transcript
:
width
-
100
}
}
)
Insert cell
Inputs
.
table
(
interviews
,
{
width
:
{
transcript
:
width
-
800
}
,
format
:
{
transcript
:
d
=>
html
`<span style="white-space:break-spaces;">${
d
}</span>`
}
}
)
Insert cell
${
interviews
.
map
(
d
=>
html
`<p>${
d
.
transcript
}</p>`
)
}
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
db
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
interviews
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
Add comment
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