145 rows

View and edit SQL

open_issues

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 allow_forking 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   1 ["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   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   1 [] 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 2021-09-16T09:44:18Z 2021-09-11T02:44:32Z   5 1 1 Python 1 1 1 1 0 0 0 0 0   1 ["datasette", "datasette-io", "datasette-plugin"] 0 0 1 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   1 ["datasette", "greeninfo-network"] 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   1 ["datasette", "datasette-io", "datasette-plugin", "yaml"] 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 2021-07-30T21:13:36Z 2020-09-07T02:27:30Z   6 2 2 Python 1 1 1 1 0 0 0 0 3   1 ["datasette", "datasette-io", "datasette-plugin"] 0 3 2 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-09-11T06:47:07Z 2020-09-07T01:07:50Z   12 5 5 Python 1 0 1 0 0 0 0 0 1 Apache License 2.0 apache-2.0 1 [] 0 1 5 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   1 [] 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   1 ["datasette", "datasette-io", "datasette-plugin", "seaborn", "visualization"] 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 1 ["fts5", "sqlite", "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   1 ["datasette", "datasette-io", "datasette-plugin", "dateutil"] 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 2021-09-08T04:48:36Z 2021-09-08T04:49:48Z   14 0 0 Python 1 1 1 1 0 0 0 0 2   1 ["datasette", "datasette-io", "datasette-plugin"] 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   1 ["buildpacks", "datasette"] 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   1 ["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-08-31T18:07:38Z 2021-08-26T19:02:47Z   51 26 26 Python 1 1 1 1 0 4 0 0 4 Apache License 2.0 apache-2.0 1 ["datasette-io", "datasette-tool", "dogsheep", "evernote", "sqlite"] 4 4 26 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 2021-07-28T22:11:40Z 2020-10-22T04:55:45Z   9 3 3 Python 1 1 1 1 0 0 0 0 2 Apache License 2.0 apache-2.0 1 ["datasette-io", "datasette-tool", "sphinx", "sqlite"] 0 2 3 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   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   1 ["datasette", "datasette-io", "datasette-plugin", "indieauth"] 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 6   1 ["codesearch", "datasette", "datasette-io", "datasette-plugin", "ripgrep"] 0 6 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   1 ["datasette-io", "datasette-plugin"] 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-08-06T14:36:43Z 2021-07-17T04:01:49Z   21 9 9 Python 1 1 1 1 0 2 0 0 2   1 ["datasette-io", "datasette-plugin"] 2 2 9 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   1 ["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   1 ["datasette", "datasette-io", "datasette-plugin", "leafletjs"] 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   1 ["datasette", "datasette-io", "datasette-plugin"] 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   1 ["datasette", "datasette-io", "datasette-plugin", "mbtiles", "openstreetmap"] 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 8   1 ["datasette", "datasette-io", "datasette-plugin", "mbtiles"] 3 8 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 [] 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   1 ["datasette", "datasette-io", "datasette-plugin"] 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-08-22T20:05:55Z https://us-counties.datasette.io 7 5 5 Shell 1 1 1 1 0 1 0 0 1   1 ["datasette"] 1 1 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-29T13:56:42Z   212 8 8 Python 1 1 1 1 0 2 0 0 2 Apache License 2.0 apache-2.0 1 ["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-09-19T19:04:30Z 2021-08-06T22:05:40Z https://django-sql-dashboard.datasette.io/ 481 302 302 Python 1 1 1 1 0 22 0 0 23 Apache License 2.0 apache-2.0 1 ["dashboards", "datasette-io", "datasette-tool", "django", "sql"] 22 23 302 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 1 [] 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   1 ["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   1 [] 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   1 ["datasette", "datasette-io", "datasette-plugin", "placekey"] 0 1 1 main  
390535500 MDEwOlJlcG9zaXRvcnkzOTA1MzU1MDA= datasette-remote-metadata simonw/datasette-remote-metadata 0 simonw 9599 https://github.com/simonw/datasette-remote-metadata Periodically refresh Datasette metadata from a remote URL 0 2021-07-28T23:17:19Z 2021-07-29T05:40:42Z 2021-07-29T01:43:16Z   8 2 2 Python 1 1 1 1 0 0 0 0 0   1 [] 0 0 2 main  
393999598 MDEwOlJlcG9zaXRvcnkzOTM5OTk1OTg= datasette-pyinstrument simonw/datasette-pyinstrument 0 simonw 9599 https://github.com/simonw/datasette-pyinstrument Use pyinstrument to analyze Datasette page performance 0 2021-08-08T15:33:29Z 2021-08-08T23:47:06Z 2021-08-08T15:50:52Z   5 1 1 Python 1 1 1 1 0 0 0 0 0   1 [] 0 0 1 main  
394107614 MDEwOlJlcG9zaXRvcnkzOTQxMDc2MTQ= datasette-query-links simonw/datasette-query-links 0 simonw 9599 https://github.com/simonw/datasette-query-links Turn SELECT queries returned by a query into links to execute them 0 2021-08-09T01:16:59Z 2021-08-14T21:36:57Z 2021-08-09T02:56:40Z   7 4 4 Python 1 1 1 1 0 1 0 0 0   1 [] 1 0 4 main  
395137513 MDEwOlJlcG9zaXRvcnkzOTUxMzc1MTM= datasette-x-forwarded-host simonw/datasette-x-forwarded-host 0 simonw 9599 https://github.com/simonw/datasette-x-forwarded-host Treat the X-Forwarded-Host header as the Host header 0 2021-08-11T23:10:44Z 2021-08-12T20:39:07Z 2021-08-12T20:40:18Z   3 0 0 Python 1 1 1 1 0 0 0 0 0   1 ["datasette-io", "datasette-plugin"] 0 0 0 main  
399308604 MDEwOlJlcG9zaXRvcnkzOTkzMDg2MDQ= datasette-app simonw/datasette-app 0 simonw 9599 https://github.com/simonw/datasette-app The Datasette macOS application 0 2021-08-24T02:21:37Z 2021-09-19T01:20:15Z 2021-09-19T01:20:13Z https://datasette.io/desktop 948 54 54 JavaScript 1 1 1 1 0 2 0 0 16   1 ["datasette"] 2 16 54 main  
400678317 MDEwOlJlcG9zaXRvcnk0MDA2NzgzMTc= datasette-verify simonw/datasette-verify 0 simonw 9599 https://github.com/simonw/datasette-verify Verify that files can be opened by Datasette 0 2021-08-28T01:59:12Z 2021-09-07T22:56:11Z 2021-08-28T02:31:34Z https://datasette.io/tools/datasette-verify 3 2 2 Python 1 1 1 1 0 0 0 0 0   1 ["datasette", "datasette-io", "datasette-plugin"] 0 0 2 main  
400878073 MDEwOlJlcG9zaXRvcnk0MDA4NzgwNzM= datasette-plugin-template-repository simonw/datasette-plugin-template-repository 0 simonw 9599 https://github.com/simonw/datasette-plugin-template-repository GitHub template repository for creating new Datasette plugins, using the simonw/datasette-plugin cookiecutter template 0 2021-08-28T19:50:28Z 2021-08-30T14:30:04Z 2021-08-28T19:57:26Z   4 10 10   1 1 1 1 0 0 0 0 0   1 [] 0 0 10 main  
400878410 MDEwOlJlcG9zaXRvcnk0MDA4Nzg0MTA= datasette-plugin-template-repository-demo simonw/datasette-plugin-template-repository-demo 0 simonw 9599 https://github.com/simonw/datasette-plugin-template-repository-demo Demo of simonw/datasette-plugin-template-repository 0 2021-08-28T19:52:11Z 2021-08-28T19:52:32Z 2021-08-28T19:52:30Z   4 0 0 Python 1 1 1 1 0 0 0 0 0   1 [] 0 0 0 main  
406996472 MDEwOlJlcG9zaXRvcnk0MDY5OTY0NzI= datasette-statistics simonw/datasette-statistics 0 simonw 9599 https://github.com/simonw/datasette-statistics SQL statistics functions for Datasette 0 2021-09-16T02:51:09Z 2021-09-17T20:29:47Z 2021-09-16T03:21:38Z   7 1 1 Python 1 1 1 1 0 0 0 0 0   1 [] 0 0 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,
   [allow_forking] INTEGER,
   [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]);