![]() I’d love your help improving the Datasette ecosystem to better serve your needs. If you are involved in any of the above please get in touch. My San Francisco tree search project for example uses data from the Department of Public Works-a CSV of 190,000 trees around the city.Ĭultural institutions because the museums and libraries of the world are sitting on enormous treasure troves of valuable information, and have an institutional mandate to share that data as widely as possible. When we started the Guardian Datablog we ended up using Google Sheets for this.Ĭivic open data because it turns out the open data movement mostly won! It’s incredible how much high quality data is published by local and national governments these days. The three areas I’m most excited in seeing adoption of Datasette are data journalism, civic open data and cultural institutions.ĭata journalism because when I worked at the Guardian Datasette is the tool I wish I had had for publishing data. I plan to add support for other useful formats in the future. Since so much of the data that IS published today uses CSV, this first release of Datasette Publish focuses on CSV conversion above anything else. Datasette encourages using SQLite instead: a powerful, flexible format that enables analysis via SQL queries and can easily be shared and hosted online. ![]() The world is full of interesting data that often ends up trapped in PDF blobs or other hard-to-use formats, if it gets published at all. The fundamental idea behind Datasette is that publishing structured data as both a web interface and a JSON API should be as quick and easy as possible. Who should use itĪnyone who has data they want to share with the world! Zeit’s generous free plan means you can try the tool out as many times as you like-and if you want to use it for an API powering a production website you can easily upgrade to a paid hosting plan. It’s built on top of the Zeit Now hosting service, which means anything you deploy with it lives on your own account with Zeit and stays entirely under your control. Here’s a demo application I built using Datasette Publish, showing Californian campaign finance data using CSV files released by the California Civic Data Coalition.Īnd here’s an animated screencast showing exactly how I built it:ĭatasette Publish combines my Datasette tool for publishing SQLite databases as an API with my csvs-to-sqlite tool for generating them. I’ve just released Datasette Publish, a web tool for turning one or more CSV files into an online database with a JSON API. Datasette Publish: a web app for publishing CSV files as an online database
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |