Entries tagged datasette

Filters: Type: entry × datasette × Sorted by date

223 results «« first « previous page 8 / 8

Analyzing US Election Russian Facebook Ads

Two interesting data sources have emerged in the past few weeks concerning the Russian impact on the 2016 US elections.

4:01 pm / 6th August 2018 / politics, projects, yaml, datasette, sqliteutils

Analyzing US Election troll tweets with Datasette

FiveThirtyEight published nearly 3 million tweets from accounts associated with the Russian “Internet Research Agency”, based on research by Darren Linvill and Patrick Warren at at Clemson University.

[... 110 words]

3:15 pm / 6th August 2018 / datasette

Documentation unit tests

Or: Test-driven documentation.

[... 1521 words]

3:59 pm / 28th July 2018 / documentation, restructuredtext, testing, datasette, pytest

Datasette Facets

Datasette 0.22 is out with the most significant new feature I’ve added since the initial release: faceted browse.

[... 1189 words]

11:42 pm / 20th May 2018 / facets, projects, facetedsearch, datasette

Notes from my appearance on the Changelog podcast

After I spoke at Zeit Day SF last weekend I sat down with Adam Stacoviak to record a 25 minute segment for episode 296 of the Changelog podcast, talking about Datasette. We covered a lot of ground!

[... 536 words]

6:03 pm / 9th May 2018 / datajournalism, podcasts, speaking, sqlite, datasette

Exploring the UK Register of Members Interests with SQL and Datasette

Ever wondered which UK Members of Parliament get gifted the most helicopter rides? How about which MPs have been given Christmas hampers by the Sultan of Brunei? (David Cameron, William Hague and Michael Howard apparently). Here’s how to dig through the Register of Members Interests using SQL and Datasette.

[... 1167 words]

3:49 pm / 25th April 2018 / mysociety, politicalhacking, politics, projects, sqlite, xml, datasette

Datasette plugins, and building a clustered map visualization

Datasette now supports plugins!

[... 751 words]

3:41 pm / 20th April 2018 / maps, plugins, projects, visualization, datasette, pytest

Datasette Demo (video) from the SF Python Meetup

I gave a short talk about Datasette last month at the SF Python Meetup Holiday Party. They’ve just posted the video, so here it is:

[... 63 words]

5:52 am / 29th January 2018 / presentations, python, datasette

Analyzing my Twitter followers with Datasette

I decided to do some ad-hoc analsis of my social network on Twitter this afternoon… and since everything is more fun if you bundle it up into a SQLite database and publish it to the internet I performed the analysis using Datasette.

[... 1314 words]

6:41 am / 28th January 2018 / pandas, projects, sqlite, twitter, datasette

Datasette Publish: a web app for publishing CSV files as an online database

I’ve just released Datasette Publish, a web tool for turning one or more CSV files into an online database with a JSON API.

[... 863 words]

2:11 pm / 17th January 2018 / csv, projects, zeitnow, datasette

Building a location to time zone API with SpatiaLite, OpenStreetMap and Datasette

Given a latitude and longitude, how can we tell what time zone that point lies within? Here’s how I built a simple JSON API to answer that question, using a combination of data from OpenStreetMap, the SpatiaLite extension for SQLite and my Datasette API tool.

[... 2185 words]

3:52 pm / 12th December 2017 / geospatial, openstreetmap, sqlite, timezones, datasette