18 rows where open_issues = 2

View and edit SQL

Suggested facets: owner, homepage, size, stargazers_count, watchers_count, language, forks_count, topics, forks, watchers, default_branch, created_at (date), updated_at (date), pushed_at (date), topics (array)

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
135007287 MDEwOlJlcG9zaXRvcnkxMzUwMDcyODc= datasette-leaflet-geojson simonw/datasette-leaflet-geojson 0 simonw 9599 https://github.com/simonw/datasette-leaflet-geojson Datasette plugin that replaces any GeoJSON column values with a Leaflet map. 0 2018-05-27T01:42:30Z 2021-07-08T00:11:10Z 2021-01-26T02:41:08Z   96 11 11 Python 1 1 1 1 0 3 0 0 2   1 ["datasette", "datasette-io", "datasette-plugin", "gis", "leaflet"] 3 2 11 main  
145483077 MDEwOlJlcG9zaXRvcnkxNDU0ODMwNzc= datasette-render-images simonw/datasette-render-images 0 simonw 9599 https://github.com/simonw/datasette-render-images Datasette plugin that renders binary blob images using data-uris 0 2018-08-21T00:05:47Z 2021-09-02T23:41:55Z 2021-09-02T23:41:52Z https://datasette-render-images-demo.datasette.io/favicons/favicons 31 12 12 Python 1 1 1 1 0 2 0 0 2   1 ["datasette", "datasette-io", "datasette-plugin", "plugin"] 2 2 12 main  
205429375 MDEwOlJlcG9zaXRvcnkyMDU0MjkzNzU= swarm-to-sqlite dogsheep/swarm-to-sqlite 0 dogsheep 53015001 https://github.com/dogsheep/swarm-to-sqlite Create a SQLite database containing your checkin history from Foursquare Swarm 0 2019-08-30T17:37:29Z 2021-09-09T23:46:31Z 2021-01-18T04:36:03Z   49 41 41 Python 1 1 1 1 0 1 0 0 2 Apache License 2.0 apache-2.0 1 ["datasette", "datasette-io", "datasette-tool", "dogsheep", "foursquare", "foursquare-api", "sqlite", "swarm"] 1 2 41 main  
209590345 MDEwOlJlcG9zaXRvcnkyMDk1OTAzNDU= genome-to-sqlite dogsheep/genome-to-sqlite 0 dogsheep 53015001 https://github.com/dogsheep/genome-to-sqlite Import your genome into a SQLite database 0 2019-09-19T15:38:39Z 2021-07-29T07:34:46Z 2019-09-19T15:41:17Z   9 14 14 Python 1 1 1 1 0 0 0 0 2 Apache License 2.0 apache-2.0 1 ["23andme", "datasette", "datasette-io", "datasette-tool", "dogsheep", "genetics", "personal-analytics", "sqlite"] 0 2 14 master  
243887036 MDEwOlJlcG9zaXRvcnkyNDM4ODcwMzY= datasette-configure-fts simonw/datasette-configure-fts 0 simonw 9599 https://github.com/simonw/datasette-configure-fts Datasette plugin for enabling full-text search against selected table columns 0 2020-02-29T01:50:57Z 2021-07-05T18:38:38Z 2020-11-01T02:59:10Z   42 3 3 Python 1 1 1 1 0 0 0 0 2 Apache License 2.0 apache-2.0 1 ["datasette", "datasette-io", "datasette-plugin"] 0 2 3 main  
248903544 MDEwOlJlcG9zaXRvcnkyNDg5MDM1NDQ= hacker-news-to-sqlite dogsheep/hacker-news-to-sqlite 0 dogsheep 53015001 https://github.com/dogsheep/hacker-news-to-sqlite Create a SQLite database containing data pulled from Hacker News 0 2020-03-21T04:02:05Z 2021-08-10T13:22:28Z 2021-03-13T19:15:06Z   19 30 30 Python 1 1 1 1 0 3 0 0 2 Apache License 2.0 apache-2.0 1 ["datasette", "datasette-io", "datasette-tool", "dogsheep", "hacker-news"] 3 2 30 main  
273547529 MDEwOlJlcG9zaXRvcnkyNzM1NDc1Mjk= datasette-plugin simonw/datasette-plugin 0 simonw 9599 https://github.com/simonw/datasette-plugin Cookiecutter template for creating Datasette plugins 0 2020-06-19T17:10:15Z 2021-09-09T07:58:42Z 2021-09-06T22:35:22Z   102 9 9 Python 1 1 1 1 0 2 0 0 2   1 ["cookiecutter-template", "datasette"] 2 2 9 main  
275711254 MDEwOlJlcG9zaXRvcnkyNzU3MTEyNTQ= datasette-write simonw/datasette-write 0 simonw 9599 https://github.com/simonw/datasette-write Datasette plugin providing a UI for executing SQL writes against the database 0 2020-06-29T02:27:31Z 2021-09-21T20:18:55Z 2021-09-11T06:03:07Z https://datasette.io/plugins/datasette-write 15 7 7 Python 1 1 1 1 0 2 0 0 2   1 ["datasette-io", "datasette-plugin"] 2 2 7 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  
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  
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  
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  
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  
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  
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  
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  

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]);