observable-data-tools
Random Fractals stash of Observable Data Tools .js, .nb.json, .ojs, .omd, .html and .qmd document formats for Data Previews in a browser and in VSCode IDE with Observable JS extension, Quarto extension, and new Quarto publishing tools.
Observable Data Notebooks
Our Tables Notebook Collection
| Notebook | Description |
|---|---|
| Data Table Viewer | Simple data notebook to view public data files in .csv, .arrow, .json array, and .geojson data formats. Allows to load a data file accessible via https:// with dataUrl query parameter and share data table viewer notebook with the loaded data with others. Provides a list of sample vega-datasets to preview. Includes simple Observable Inputs.table data view cell and Summary Table cell for a quick overview of dataset columns, total rows, data snapshot graph, missing, mean, median and standard deviation info for the numeric data fields. |
| Tabular Data Viewer 中 | Use this Tabular Data Viewer 中 Notebook |
| Data Package
|
View Frictionless Data Package tabular data resources with datapackage JS library. This notebook includes sample datasets from https://github.com/datasets for some quick tabular data previews. |
| Datapackage
|
Create Data Package
datapackage.json and datapackage.yml data descriptor files. |
| Datapackage
|
Query Frictionless Data Package tabular data resources with datapackage-js, Observable Data Wrangler and Arquero JS without writing any data query code. |
| SQLite ER Diagram | Create SQLite ER Diagram with Graphviz html-like node labels. This notebook uses chinook.db sample SQLite database from Observable FileAttachment as an example. |
| Datasette
|
Load and view Datasette examples data, database schema, tables, and Graphviz ER diagram using Observable Datasette Client API, and query it with new Observable SQL cell tool. |
| QuestDB | Use QuestDB Observable DatabaseClient implementation to connect to the QuestDB demo database instance and run QuestDB SQL queries. This QuestDB intro notebook displays database tables and columns, table data and summary, Graphviz and Mermaid ER diagrams, and lets you query data via no code Data Wrangler UI or Sql editor cell tools. |
| DuckDB Data Tables | DuckDB Data Tables notebook covers sample .json, .csv, and .parquet data loading from Observable FileAttachments. It lists created DuckDB tables, lets you pick a table and view table schema and data summary with Observable Summary Table data tool. You can also view and search table data results via standard Observable Inputs.search and Inputs.table controls, using Data Wrangler with Arguero, or query selected table data with new Observable SQL cell. This DuckDB Data Tables intro notebook also creates Tables diagrams from the loaded data files with Graphviz html tables and Mermaid ER Diagram, and briefly covers DuckDB Information Schema views, Pragmas, and created DuckDB instance Configuration Options. |
| Datapackage
|
DataPackage DuckDB notebook lets you load tabular data described in Data Package format by changing datapackage.json Url. It creates tabular data resources list, data package tables diagram, lists selected table data, imports tabular data into new DuckDB instance, shows db tables diagram, and lets you filter and query imported data with Observable Data table cell and SQL cell tools. You can learn more about Data Package format in our Datapackage Observable notebooks collection. |
| DuckDB Data Import | This notebook lets you import data into new DuckDB instance from public data Url. Supported data files include: .csv, .json array, .geojson, .arrow and .parquet. In case of GeoJSON we flatten it similar to how github flat data viewer handles geo data loading and display. The usual set of Observable data table, SQL cell, and Table Summary data tools are provided in this notebook to preview loaded data and created DuckDB tables. Try Sample Data Files in that notebook and loading your own data and sharing it with notebook dataUrl query param. |
| SQLite to DuckDB | The last notebook in our DuckDB Notebooks
chinook.db from Observable FileAttachments, lists loaded SQLite DB tables, creates SQLite Tables Diagram, DuckDB CREATE TABLE statements, creates new DuckDB instance and tables and shows created DuckDB Tables Diagram. The last remaining task to finish this notebook is to add bulk data insert pending PRAGMA foreign_keys = on/off (#4201) and ALTER TABLE ADD CONSTRAINT .. FOREIGN KEY (#4203) features implementation in duckdb. |
| Database Viewer | Database Viewer Notebook |
7 Sep 1, 2022
3 May 18, 2022
4 May 3, 2022
14 Jan 3, 2023
5 Oct 17, 2022
7 Jul 31, 2022
2 Nov 17, 2022
1 Aug 16, 2022
5 Aug 23, 2022
29 Dec 8, 2022