136 rows

View and edit SQL

id ▼ node_id name full_name private owner html_url description fork created_at updated_at pushed_at homepage size stargazers_count watchers_count language has_issues has_projects has_downloads has_wiki has_pages forks_count archived disabled open_issues_count license topics forks open_issues watchers default_branch organization
286125406 MDEwOlJlcG9zaXRvcnkyODYxMjU0MDY= parlgov-datasette simonw/parlgov-datasette 0 simonw 9599 https://github.com/simonw/parlgov-datasette   0 2020-08-08T22:00:35Z 2020-12-04T21:14:03Z 2020-12-04T21:14:00Z https://parlgov.datasettes.com/ 8 0 0 Python 1 1 1 1 0 0 0 0 0   ["datasette", "parlgov-database"] 0 0 0 main  
286637373 MDEwOlJlcG9zaXRvcnkyODY2MzczNzM= homebrew-datasette simonw/homebrew-datasette 0 simonw 9599 https://github.com/simonw/homebrew-datasette Datasette formula for Homebrew 0 2020-08-11T03:34:29Z 2020-10-10T23:15:39Z 2020-10-10T23:15:37Z   63 4 4 Ruby 1 1 1 1 0 2 0 0 1   [] 2 1 4 main  
287625934 MDEwOlJlcG9zaXRvcnkyODc2MjU5MzQ= datasette-io-redirect simonw/datasette-io-redirect 0 simonw 9599 https://github.com/simonw/datasette-io-redirect Redirect datasette.io to docs.datasette.io 0 2020-08-14T21:18:29Z 2020-08-14T21:21:00Z 2020-08-14T21:20:26Z https://datasette.io/ 0 0 0   1 1 1 1 0 0 0 0 0   [] 0 0 0 main  
288629766 MDEwOlJlcG9zaXRvcnkyODg2Mjk3NjY= datasette-schema-versions simonw/datasette-schema-versions 0 simonw 9599 https://github.com/simonw/datasette-schema-versions Datasette plugin that shows the schema version of every attached database 0 2020-08-19T04:04:39Z 2020-08-19T04:29:48Z 2020-08-19T04:05:17Z   3 0 0 Python 1 1 1 1 0 0 0 0 0   ["datasette", "datasette-plugin", "datasette-io"] 0 0 0 main  
289340983 MDEwOlJlcG9zaXRvcnkyODkzNDA5ODM= calands-datasette simonw/calands-datasette 0 simonw 9599 https://github.com/simonw/calands-datasette Datasette instance with data from calands.org 0 2020-08-21T18:41:25Z 2021-03-27T16:19:03Z 2021-03-27T16:19:01Z https://calands.datasettes.com 28 2 2 Shell 1 1 1 1 0 1 0 0 2   ["greeninfo-network", "datasette"] 1 2 2 main  
291359358 MDEwOlJlcG9zaXRvcnkyOTEzNTkzNTg= datasette-yaml simonw/datasette-yaml 0 simonw 9599 https://github.com/simonw/datasette-yaml Export Datasette records as YAML 0 2020-08-29T22:32:15Z 2020-12-28T03:20:36Z 2021-05-13T08:59:53Z   7 2 2 Python 1 1 1 1 0 1 0 0 1   ["yaml", "datasette", "datasette-plugin", "datasette-io"] 1 1 2 main  
293164447 MDEwOlJlcG9zaXRvcnkyOTMxNjQ0NDc= datasette-backup simonw/datasette-backup 0 simonw 9599 https://github.com/simonw/datasette-backup Plugin adding backup options to Datasette 0 2020-09-05T22:33:29Z 2020-09-24T00:16:59Z 2020-09-07T02:27:30Z   6 1 1 Python 1 1 1 1 0 0 0 0 3   ["datasette", "datasette-plugin", "datasette-io"] 0 3 1 main  
293302651 MDEwOlJlcG9zaXRvcnkyOTMzMDI2NTE= sqlite-dump simonw/sqlite-dump 0 simonw 9599 https://github.com/simonw/sqlite-dump An improved version of .iterdump() for sqlite3 0 2020-09-06T15:14:26Z 2021-04-16T13:25:36Z 2020-09-07T01:07:50Z   12 4 4 Python 1 0 1 0 0 0 0 0 0 Apache License 2.0 apache-2.0 [] 0 0 4 main  
294305203 MDEwOlJlcG9zaXRvcnkyOTQzMDUyMDM= datasette-dns simonw/datasette-dns 0 simonw 9599 https://github.com/simonw/datasette-dns Custom SQL function for making DNS lookups 0 2020-09-10T04:44:43Z 2020-09-26T11:58:34Z 2020-09-10T15:58:55Z   7 4 4 Python 1 1 1 1 0 0 0 0 2   [] 0 2 4 main  
294706267 MDEwOlJlcG9zaXRvcnkyOTQ3MDYyNjc= datasette-seaborn simonw/datasette-seaborn 0 simonw 9599 https://github.com/simonw/datasette-seaborn Statistical visualizations for Datasette using Seaborn 0 2020-09-11T13:43:08Z 2021-01-19T11:11:19Z 2020-12-07T01:39:12Z https://datasette-seaborn-demo.datasette.io/ 24 11 11 Python 1 1 1 1 0 0 0 0 5   ["visualization", "seaborn", "datasette", "datasette-plugin", "datasette-io"] 0 5 11 main  
296966739 MDEwOlJlcG9zaXRvcnkyOTY5NjY3Mzk= sqlite-fts5-trigram simonw/sqlite-fts5-trigram 0 simonw 9599 https://github.com/simonw/sqlite-fts5-trigram Trigram tokenizer module for SQLite FTS5 0 2020-09-19T23:14:51Z 2021-03-26T02:18:16Z 2021-02-22T04:07:54Z https://sqlite.org/forum/forumpost/ca90da691a?t=h 9 4 4 C 1 1 1 1 0 0 0 0 1 Other other ["sqlite", "fts5", "trigram"] 0 1 4 main  
299143849 MDEwOlJlcG9zaXRvcnkyOTkxNDM4NDk= datasette-dateutil simonw/datasette-dateutil 0 simonw 9599 https://github.com/simonw/datasette-dateutil dateutil functions for Datasette 0 2020-09-28T00:14:20Z 2021-03-08T22:09:08Z 2020-09-30T01:07:35Z   15 5 5 Python 1 1 1 1 0 0 0 0 2   ["dateutil", "datasette", "datasette-plugin", "datasette-io"] 0 2 5 main  
299198369 MDEwOlJlcG9zaXRvcnkyOTkxOTgzNjk= datasette-import-table simonw/datasette-import-table 0 simonw 9599 https://github.com/simonw/datasette-import-table Datasette plugin for importing tables from other Datasette instances 0 2020-09-28T05:30:07Z 2020-09-28T15:26:40Z 2020-09-28T15:27:45Z   11 0 0 Python 1 1 1 1 0 0 0 0 2   ["datasette", "datasette-plugin", "datasette-io"] 0 2 0 main  
301879297 MDEwOlJlcG9zaXRvcnkzMDE4NzkyOTc= buildpack-datasette simonw/buildpack-datasette 0 simonw 9599 https://github.com/simonw/buildpack-datasette Repository template for creating a new Datasette buildpack instance 0 2020-10-06T23:31:39Z 2021-03-12T00:21:17Z 2020-12-18T02:31:46Z https://docs.datasette.io/en/stable/deploying.html#deploying-using-buildpacks 48 1 1   1 1 1 1 0 1 0 0 0   ["datasette", "buildpacks"] 1 0 1 main  
303184040 MDEwOlJlcG9zaXRvcnkzMDMxODQwNDA= datasette-json-preview simonw/datasette-json-preview 0 simonw 9599 https://github.com/simonw/datasette-json-preview Preview of new JSON default format for Datasette 0 2020-10-11T18:15:24Z 2021-02-20T20:26:42Z 2021-02-20T20:26:41Z https://github.com/simonw/datasette/issues/782 9 1 1 Python 1 1 1 1 0 0 0 0 2   ["datasette"] 0 2 1 main  
303218369 MDEwOlJlcG9zaXRvcnkzMDMyMTgzNjk= evernote-to-sqlite dogsheep/evernote-to-sqlite 0 dogsheep 53015001 https://github.com/dogsheep/evernote-to-sqlite Tools for converting Evernote content to SQLite 0 2020-10-11T21:45:49Z 2021-06-20T12:26:18Z 2021-05-15T19:57:51Z   44 23 23 Python 1 1 1 1 0 4 0 0 3 Apache License 2.0 apache-2.0 ["sqlite", "evernote", "dogsheep", "datasette-io", "datasette-tool"] 4 3 23 main  
305199661 MDEwOlJlcG9zaXRvcnkzMDUxOTk2NjE= sphinx-to-sqlite simonw/sphinx-to-sqlite 0 simonw 9599 https://github.com/simonw/sphinx-to-sqlite Create a SQLite database from Sphinx documentation 0 2020-10-18T21:26:55Z 2020-12-19T05:08:12Z 2020-10-22T04:55:45Z   9 2 2 Python 1 1 1 1 0 0 0 0 2 Apache License 2.0 apache-2.0 ["sqlite", "sphinx", "datasette-io", "datasette-tool"] 0 2 2 main  
308930118 MDEwOlJlcG9zaXRvcnkzMDg5MzAxMTg= datasette-edit-templates simonw/datasette-edit-templates 0 simonw 9599 https://github.com/simonw/datasette-edit-templates Plugin allowing Datasette templates to be edited within Datasette 0 2020-10-31T16:58:29Z 2020-11-01T05:26:49Z 2020-11-01T05:26:47Z   9 1 1 Python 1 1 1 1 0 0 0 0 1   [] 0 1 1 main  
312934001 MDEwOlJlcG9zaXRvcnkzMTI5MzQwMDE= datasette-indieauth simonw/datasette-indieauth 0 simonw 9599 https://github.com/simonw/datasette-indieauth Datasette authentication using IndieAuth and RelMeAuth 0 2020-11-15T01:18:21Z 2021-03-26T02:09:35Z 2020-11-19T23:13:13Z   70 6 6 Python 1 1 1 1 0 0 0 0 1   ["indieauth", "datasette", "datasette-plugin", "datasette-io"] 0 1 6 main  
315796015 MDEwOlJlcG9zaXRvcnkzMTU3OTYwMTU= datasette-ripgrep simonw/datasette-ripgrep 0 simonw 9599 https://github.com/simonw/datasette-ripgrep Web interface for searching your code using ripgrep, built as a Datasette plugin 0 2020-11-25T01:26:36Z 2021-07-23T05:12:50Z 2021-05-14T18:20:02Z https://ripgrep.datasette.io 88 56 56 Python 1 1 1 1 0 0 0 0 5   ["codesearch", "ripgrep", "datasette", "datasette-plugin", "datasette-io"] 0 5 56 main  
327087207 MDEwOlJlcG9zaXRvcnkzMjcwODcyMDc= datasette-css-properties simonw/datasette-css-properties 0 simonw 9599 https://github.com/simonw/datasette-css-properties Experimental Datasette output plugin using CSS properties 0 2021-01-05T18:38:07Z 2021-01-12T17:43:11Z 2021-01-07T22:07:19Z   10 12 12 Python 1 1 1 1 0 0 0 0 1   ["datasette-plugin", "datasette-io"] 0 1 12 main  
327236119 MDEwOlJlcG9zaXRvcnkzMjcyMzYxMTk= datasette-export-notebook simonw/datasette-export-notebook 0 simonw 9599 https://github.com/simonw/datasette-export-notebook Datasette plugin providing instructions for exporting data to Jupyter or Observable 0 2021-01-06T07:37:00Z 2021-07-18T22:55:05Z 2021-07-17T04:01:49Z   21 7 7 Python 1 1 1 1 0 2 0 0 2   ["datasette-plugin", "datasette-io"] 2 2 7 main  
327957983 MDEwOlJlcG9zaXRvcnkzMjc5NTc5ODM= cbsa-datasette simonw/cbsa-datasette 0 simonw 9599 https://github.com/simonw/cbsa-datasette Using Datasette to provide an API for Core Based Statistical Areas 0 2021-01-08T16:40:25Z 2021-01-10T00:32:55Z 2021-01-10T00:32:52Z https://cbsa.datasettes.com 8 0 0   1 1 1 1 0 0 0 0 0   ["datasette"] 0 0 0 main  
331151708 MDEwOlJlcG9zaXRvcnkzMzExNTE3MDg= datasette-leaflet-freedraw simonw/datasette-leaflet-freedraw 0 simonw 9599 https://github.com/simonw/datasette-leaflet-freedraw Draw polygons on maps in Datasette 0 2021-01-20T00:55:03Z 2021-07-02T14:25:28Z 2021-02-28T10:24:00Z   1155 6 6 Python 1 1 1 1 0 2 0 0 2   ["leafletjs", "datasette", "datasette-plugin", "datasette-io"] 2 2 6 main  
331720824 MDEwOlJlcG9zaXRvcnkzMzE3MjA4MjQ= datasette-leaflet simonw/datasette-leaflet 0 simonw 9599 https://github.com/simonw/datasette-leaflet Datasette plugin adding the Leaflet JavaScript library 0 2021-01-21T18:41:19Z 2021-07-05T01:36:48Z 2021-02-01T22:20:28Z   124 4 4 JavaScript 1 1 1 1 0 0 0 0 2   ["datasette", "datasette-plugin", "datasette-io"] 0 2 4 main  
335137108 MDEwOlJlcG9zaXRvcnkzMzUxMzcxMDg= datasette-basemap simonw/datasette-basemap 0 simonw 9599 https://github.com/simonw/datasette-basemap A basemap for Datasette and datasette-leaflet 0 2021-02-02T01:49:09Z 2021-02-03T21:56:20Z 2021-02-03T21:56:18Z https://datasette.io/plugins/datasette-basemap 43 1 1 Python 1 1 1 1 0 0 0 0 0   ["openstreetmap", "mbtiles", "datasette", "datasette-plugin", "datasette-io"] 0 0 1 main  
335175637 MDEwOlJlcG9zaXRvcnkzMzUxNzU2Mzc= datasette-tiles simonw/datasette-tiles 0 simonw 9599 https://github.com/simonw/datasette-tiles Mapping tile server for Datasette, serving tiles from MBTiles packages 0 2021-02-02T05:11:12Z 2021-07-16T21:25:19Z 2021-02-12T00:56:29Z https://datasette.io/plugins/datasette-tiles 54 3 3 Python 1 1 1 1 0 3 0 0 7   ["mbtiles", "datasette", "datasette-plugin", "datasette-io"] 3 7 3 main  
341312930 MDEwOlJlcG9zaXRvcnkzNDEzMTI5MzA= vaccinate-ca-datasette simonw/vaccinate-ca-datasette 0 simonw 9599 https://github.com/simonw/vaccinate-ca-datasette   0 2021-02-22T19:27:02Z 2021-03-24T00:32:41Z 2021-03-02T09:10:00Z https://vaccinateca.datasette.io/ 13 0 0 Shell 1 1 1 1 0 1 0 0 0   [] 1 0 0 main  
342126610 MDEwOlJlcG9zaXRvcnkzNDIxMjY2MTA= datasette-block simonw/datasette-block 0 simonw 9599 https://github.com/simonw/datasette-block Block all access to specific path prefixes 0 2021-02-25T04:51:08Z 2021-02-25T08:18:28Z 2021-02-25T05:03:45Z https://datasette.io/plugins/datasette-block 4 1 1 Python 1 1 1 1 0 0 0 0 0   ["datasette", "datasette-plugin", "datasette-io"] 0 0 1 main  
345505165 MDEwOlJlcG9zaXRvcnkzNDU1MDUxNjU= us-counties-datasette simonw/us-counties-datasette 0 simonw 9599 https://github.com/simonw/us-counties-datasette A Datasette instance exposing names, FIPS codes and polygons of US counties 0 2021-03-08T02:16:19Z 2021-06-16T23:38:02Z 2021-06-16T23:37:59Z https://us-counties.datasette.io 7 5 5 Shell 1 1 1 1 0 0 0 0 0   ["datasette"] 0 0 5 main  
346597557 MDEwOlJlcG9zaXRvcnkzNDY1OTc1NTc= tableau-to-sqlite simonw/tableau-to-sqlite 0 simonw 9599 https://github.com/simonw/tableau-to-sqlite Fetch data from Tableau into a SQLite database 0 2021-03-11T06:12:02Z 2021-06-10T04:40:44Z 2021-07-20T14:01:29Z   212 8 8 Python 1 1 1 1 0 2 0 0 2 Apache License 2.0 apache-2.0 ["datasette-io", "datasette-tool"] 2 2 8 main  
347263722 MDEwOlJlcG9zaXRvcnkzNDcyNjM3MjI= django-sql-dashboard simonw/django-sql-dashboard 0 simonw 9599 https://github.com/simonw/django-sql-dashboard Django app for building dashboards using raw SQL queries 0 2021-03-13T03:38:23Z 2021-07-24T17:17:43Z 2021-07-06T00:37:06Z https://django-sql-dashboard.datasette.io/ 481 292 292 Python 1 1 1 1 0 20 0 0 19 Apache License 2.0 apache-2.0 ["django", "sql", "dashboards", "datasette-io", "datasette-tool"] 20 19 292 main  
350895171 MDEwOlJlcG9zaXRvcnkzNTA4OTUxNzE= iam-to-sqlite simonw/iam-to-sqlite 0 simonw 9599 https://github.com/simonw/iam-to-sqlite Load Amazon IAM data into a SQLite database 0 2021-03-24T00:16:15Z 2021-04-11T00:50:43Z 2021-03-24T00:20:26Z   7 7 7 Python 1 1 1 1 0 0 0 0 0 Apache License 2.0 apache-2.0 [] 0 0 7 main  
352183222 MDEwOlJlcG9zaXRvcnkzNTIxODMyMjI= azure-functions-datasette simonw/azure-functions-datasette 0 simonw 9599 https://github.com/simonw/azure-functions-datasette Example of running Datasette on Azure Functions 0 2021-03-27T21:42:28Z 2021-06-10T14:33:31Z 2021-03-27T22:40:41Z https://azure-functions-datasette.azurewebsites.net/ 2848 9 9 Python 1 1 1 1 0 0 0 0 0   ["azure-functions", "datasette"] 0 0 9 main  
352249703 MDEwOlJlcG9zaXRvcnkzNTIyNDk3MDM= datasette-publish-azure simonw/datasette-publish-azure 0 simonw 9599 https://github.com/simonw/datasette-publish-azure Publish Datasette instances to Azure Functions (in progress) 0 2021-03-28T05:35:15Z 2021-04-17T19:01:07Z 2021-03-28T05:36:41Z   3 1 1 Python 1 1 1 1 0 0 0 0 0   [] 0 0 1 main  
375546675 MDEwOlJlcG9zaXRvcnkzNzU1NDY2NzU= datasette-placekey simonw/datasette-placekey 0 simonw 9599 https://github.com/simonw/datasette-placekey SQL functions for working with placekeys 0 2021-06-10T02:31:27Z 2021-06-22T22:13:18Z 2021-06-10T02:32:42Z https://datasette.io/plugins/datasette-placekey 3 1 1 Python 1 1 1 1 0 0 0 0 1   ["datasette", "datasette-plugin", "datasette-io", "placekey"] 0 1 1 main  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [repos] (
   [id] INTEGER PRIMARY KEY,
   [node_id] TEXT,
   [name] TEXT,
   [full_name] TEXT,
   [private] INTEGER,
   [owner] INTEGER REFERENCES [users]([id]),
   [html_url] TEXT,
   [description] TEXT,
   [fork] INTEGER,
   [created_at] TEXT,
   [updated_at] TEXT,
   [pushed_at] TEXT,
   [homepage] TEXT,
   [size] INTEGER,
   [stargazers_count] INTEGER,
   [watchers_count] INTEGER,
   [language] TEXT,
   [has_issues] INTEGER,
   [has_projects] INTEGER,
   [has_downloads] INTEGER,
   [has_wiki] INTEGER,
   [has_pages] INTEGER,
   [forks_count] INTEGER,
   [archived] INTEGER,
   [disabled] INTEGER,
   [open_issues_count] INTEGER,
   [license] TEXT,
   [topics] TEXT,
   [forks] INTEGER,
   [open_issues] INTEGER,
   [watchers] INTEGER,
   [default_branch] TEXT,
   [organization] INTEGER REFERENCES [users]([id]),
   FOREIGN KEY([license]) REFERENCES [licenses]([key])
);
CREATE INDEX [idx_repos_license]
    ON [repos] ([license]);
CREATE INDEX [idx_repos_organization]
    ON [repos] ([organization]);
CREATE INDEX [idx_repos_owner]
    ON [repos] ([owner]);