[go: up one dir, main page]

Examples of sites built using Datasette

datasette.io (this website)

datasette.io runs using a heavily customized Datasette instance implementing the Baked Data pattern. Read more about how it works in datasette.io, an official project website for Datasette and Building a search engine for datasette.io.

You can explore the database that powers this site at datasette.io/content.

A screenshot of the datasette.io homepage

San Francisco Microscopical Society Archive

The San Francisco Microscopical Society have archives dating back to 1870, and recently started digitizing them as scanned images in PDF files.

s3-ocr is a tool for bulk OCRing PDF files in an S3 bucket and extracting out the resulting text into a searchable SQLite database.

Their archive site uses a templated Datasette instance to allow people to search and browse through their archives.

Building a searchable archive for the San Francisco Microscopical Society describes in detail how this project was built.

Screenshot of the homepage of the San Francisco Microscopical Society Archive website, showing thumbnails of scanned PDF pages

Global Power Plants

The World Resources Institute publishes a Global Power Plants Database with information about over 30,000 power plants around the world.

This Datasette instance presents those power plants on a map, using the datasette-cluster-map plugin to support zooming in to see individual plants.

Screenshot of a Datasette instance showing a map of North America, covered in markers representing different power plants. The table also has facets showing the top values for primary_fuel, owner and country_long in the table.

More examples

United States members of congress

datasette.io/legislators lists United States members of congress, plus Presidents and Vice Presidents, using data from unitedstates/congress-legislators on GitHub.

The official Datasette tutorials Exploring a database with Datasette and Learn SQL with Datasette demonstrate how to use Datasette to explore and query this database.

UK Register of Members Interests

register-of-members-interests.datasettes.com provides a searchable interface to the UK Register of Members Interests - a database of the financial interests of members of the UK Parliament.

See Exploring the UK Register of Members Interests with SQL and Datasette for background on this project.