31 rows where open_issues = 1

View and edit SQL

Suggested facets: homepage, size, stargazers_count, watchers_count, language, has_projects, has_wiki, forks_count, license, 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
129660868 MDEwOlJlcG9zaXRvcnkxMjk2NjA4Njg= datasette-plugin-demos simonw/datasette-plugin-demos 0 simonw 9599 https://github.com/simonw/datasette-plugin-demos Some examples plugins for Datasette 0 2018-04-15T23:45:27Z 2020-07-14T04:11:25Z 2020-07-14T04:12:32Z   6 0 0 Python 1 1 1 1 0 1 0 0 1   1 [] 1 1 0 master  
133958542 MDEwOlJlcG9zaXRvcnkxMzM5NTg1NDI= fivethirtyeight-datasette simonw/fivethirtyeight-datasette 0 simonw 9599 https://github.com/simonw/fivethirtyeight-datasette Code to package FiveThirtyEight data using Datasette 0 2018-05-18T13:33:05Z 2021-08-18T19:45:13Z 2021-06-05T22:42:17Z https://fivethirtyeight.datasettes.com 44 7 7 Python 1 1 1 1 0 2 0 0 1   1 ["datasette", "fivethirtyeight", "sqlite"] 2 1 7 main  
135372981 MDEwOlJlcG9zaXRvcnkxMzUzNzI5ODE= datasette-registry simonw/datasette-registry 0 simonw 9599 https://github.com/simonw/datasette-registry A registry of Datasette instances 0 2018-05-30T01:45:45Z 2021-01-12T17:01:05Z 2020-06-03T03:38:14Z https://registry.datasette.io/ 21 1 1 Python 1 1 1 1 0 0 0 0 1   1 ["datasette", "open-data"] 0 1 1 master  
162850894 MDEwOlJlcG9zaXRvcnkxNjI4NTA4OTQ= sqlite-fts4 simonw/sqlite-fts4 0 simonw 9599 https://github.com/simonw/sqlite-fts4 Custom Python functions for working with SQLite FTS4 0 2018-12-23T00:08:37Z 2021-01-22T04:15:18Z 2020-11-06T06:14:09Z   33 6 6 Python 1 1 1 1 0 2 0 0 1 Apache License 2.0 apache-2.0 1 ["fts", "python", "sqlite", "sqlite-fts4"] 2 1 6 main  
167730071 MDEwOlJlcG9zaXRvcnkxNjc3MzAwNzE= datasette-pretty-json simonw/datasette-pretty-json 0 simonw 9599 https://github.com/simonw/datasette-pretty-json Datasette plugin that pretty-prints any column values that are valid JSON objects or arrays 0 2019-01-26T19:30:43Z 2021-03-26T02:06:42Z 2020-12-09T21:22:43Z   9 8 8 Python 1 1 1 1 0 0 0 0 1 Apache License 2.0 apache-2.0 1 ["datasette", "datasette-io", "datasette-plugin", "json"] 0 1 8 master  
174715153 MDEwOlJlcG9zaXRvcnkxNzQ3MTUxNTM= datasette-jellyfish simonw/datasette-jellyfish 0 simonw 9599 https://github.com/simonw/datasette-jellyfish Datasette plugin adding SQL functions for fuzzy text matching powered by Jellyfish 0 2019-03-09T16:02:01Z 2021-02-06T02:33:49Z 2021-02-06T02:34:18Z https://datasette.io/plugins/datasette-jellyfish 15 9 9 Python 1 1 1 1 0 2 0 0 1 Apache License 2.0 apache-2.0 1 ["datasette", "datasette-io", "datasette-plugin"] 2 1 9 main  
184168864 MDEwOlJlcG9zaXRvcnkxODQxNjg4NjQ= datasette-render-html simonw/datasette-render-html 0 simonw 9599 https://github.com/simonw/datasette-render-html Plugin for selectively rendering the HTML is specific columns 0 2019-04-30T01:21:25Z 2021-09-12T01:43:15Z 2021-03-17T03:57:13Z https://datasette.io/plugins/datasette-render-html 8 2 2 Python 1 1 1 1 0 2 0 0 1   1 ["datasette", "datasette-io", "datasette-plugin"] 2 1 2 master  
189321671 MDEwOlJlcG9zaXRvcnkxODkzMjE2NzE= datasette-jq simonw/datasette-jq 0 simonw 9599 https://github.com/simonw/datasette-jq Datasette plugin that adds a custom SQL function for executing jq expressions against JSON values 0 2019-05-30T01:06:31Z 2021-07-24T23:52:41Z 2020-04-09T05:43:43Z   11 12 12 Python 1 1 1 1 0 0 0 0 1 Apache License 2.0 apache-2.0 1 ["datasette", "datasette-io", "datasette-plugin", "jq"] 0 1 12 master  
190950781 MDEwOlJlcG9zaXRvcnkxOTA5NTA3ODE= datasette-bplist simonw/datasette-bplist 0 simonw 9599 https://github.com/simonw/datasette-bplist Datasette plugin for working with Apple's binary plist format 0 2019-06-09T01:15:01Z 2021-06-07T18:05:00Z 2019-06-09T01:17:19Z   7 9 9 Python 1 1 1 1 0 0 0 0 1 Apache License 2.0 apache-2.0 1 ["bplist", "datasette", "datasette-io", "datasette-plugin"] 0 1 9 master  
191022928 MDEwOlJlcG9zaXRvcnkxOTEwMjI5Mjg= datasette-render-binary simonw/datasette-render-binary 0 simonw 9599 https://github.com/simonw/datasette-render-binary Datasette plugin for rendering binary data 0 2019-06-09T15:25:52Z 2021-09-01T14:44:01Z 2019-06-13T16:14:31Z   62 8 8 Python 1 1 1 1 0 0 0 0 1 Apache License 2.0 apache-2.0 1 ["datasette", "datasette-io", "datasette-plugin"] 0 1 8 master  
193603180 MDEwOlJlcG9zaXRvcnkxOTM2MDMxODA= fara-datasette simonw/fara-datasette 0 simonw 9599 https://github.com/simonw/fara-datasette Create a Datasette instance of data from https://efile.fara.gov/ords/f?p=API:BULKDATA 0 2019-06-25T00:36:31Z 2020-01-21T23:07:44Z 2020-01-21T23:07:42Z https://fara.datasettes.com/ 9 1 1 Python 1 1 1 1 0 0 0 0 1   1 ["datasette"] 0 1 1 master  
195696804 MDEwOlJlcG9zaXRvcnkxOTU2OTY4MDQ= datasette-cors simonw/datasette-cors 0 simonw 9599 https://github.com/simonw/datasette-cors Datasette plugin for configuring CORS headers 0 2019-07-07T21:03:11Z 2021-02-27T00:31:13Z 2019-07-11T04:40:57Z   11 9 9 Python 1 1 1 1 0 0 0 0 1 Apache License 2.0 apache-2.0 1 ["datasette", "datasette-io", "datasette-plugin"] 0 1 9 master  
221802296 MDEwOlJlcG9zaXRvcnkyMjE4MDIyOTY= datasette-template-sql simonw/datasette-template-sql 0 simonw 9599 https://github.com/simonw/datasette-template-sql Datasette plugin for executing SQL queries from templates 0 2019-11-14T23:05:34Z 2021-08-25T14:08:12Z 2021-05-18T17:58:44Z https://datasette.io/plugins/datasette-template-sql 23 7 7 Python 1 1 1 1 0 0 0 0 1 Apache License 2.0 apache-2.0 1 ["datasette", "datasette-io", "datasette-plugin"] 0 1 7 main  
228469685 MDEwOlJlcG9zaXRvcnkyMjg0Njk2ODU= asgi-log-to-sqlite simonw/asgi-log-to-sqlite 0 simonw 9599 https://github.com/simonw/asgi-log-to-sqlite ASGI middleware for logging traffic to a SQLite database 0 2019-12-16T20:27:04Z 2021-03-01T06:26:44Z 2020-02-24T20:15:50Z   12 5 5 Python 1 1 1 1 0 0 0 0 1 Apache License 2.0 apache-2.0 1 ["asgi", "datasette-io", "logging", "sqlite"] 0 1 5 master  
236867027 MDEwOlJlcG9zaXRvcnkyMzY4NjcwMjc= datasette-sentry simonw/datasette-sentry 0 simonw 9599 https://github.com/simonw/datasette-sentry Datasette plugin for configuring Sentry 0 2020-01-28T23:41:27Z 2021-03-26T02:10:18Z 2020-10-02T00:06:28Z   13 6 6 Python 1 1 1 1 0 0 0 0 1 Apache License 2.0 apache-2.0 1 ["datasette", "datasette-io", "datasette-plugin", "sentry"] 0 1 6 main  
245670670 MDEwOlJlcG9zaXRvcnkyNDU2NzA2NzA= fec-to-sqlite simonw/fec-to-sqlite 0 simonw 9599 https://github.com/simonw/fec-to-sqlite Save FEC campaign finance data to a SQLite database 0 2020-03-07T16:52:49Z 2020-12-19T05:09:05Z 2020-03-07T18:21:48Z   16 8 8 Python 1 1 1 1 0 0 0 0 1 Apache License 2.0 apache-2.0 1 ["datasette", "datasette-io", "datasette-tool", "fec", "sqlite"] 0 1 8 master  
245856731 MDEwOlJlcG9zaXRvcnkyNDU4NTY3MzE= datasette-search-all simonw/datasette-search-all 0 simonw 9599 https://github.com/simonw/datasette-search-all Datasette plugin for searching all searchable tables at once 0 2020-03-08T17:21:54Z 2021-05-12T22:36:32Z 2021-06-17T00:17:21Z   185 6 6 Python 1 1 1 1 0 1 0 0 1 Apache License 2.0 apache-2.0 1 ["datasette", "datasette-io", "datasette-plugin", "search"] 1 1 6 main  
248385299 MDEwOlJlcG9zaXRvcnkyNDgzODUyOTk= datasette-publish-fly simonw/datasette-publish-fly 0 simonw 9599 https://github.com/simonw/datasette-publish-fly Datasette plugin for publishing data using Fly 0 2020-03-19T01:47:01Z 2021-07-30T22:10:23Z 2021-07-30T22:11:11Z   16 4 4 Python 1 1 1 1 0 1 0 0 1 Apache License 2.0 apache-2.0 1 ["datasette", "datasette-io", "datasette-plugin", "fly"] 1 1 4 main  
248999994 MDEwOlJlcG9zaXRvcnkyNDg5OTk5OTQ= datasette-show-errors simonw/datasette-show-errors 0 simonw 9599 https://github.com/simonw/datasette-show-errors Datasette plugin for displaying error tracebacks 0 2020-03-21T15:06:04Z 2020-09-24T00:17:29Z 2020-09-01T00:32:23Z   7 1 1 Python 1 1 1 1 0 0 0 0 1 Apache License 2.0 apache-2.0 1 ["asgi", "datasette", "datasette-io", "datasette-plugin", "starlette"] 0 1 1 master  
271665336 MDEwOlJlcG9zaXRvcnkyNzE2NjUzMzY= datasette-auth-tokens simonw/datasette-auth-tokens 0 simonw 9599 https://github.com/simonw/datasette-auth-tokens Datasette plugin for authenticating access using API tokens 0 2020-06-11T23:23:30Z 2020-07-20T00:33:29Z 2020-07-20T00:33:43Z   28 3 3 Python 1 1 1 1 0 0 0 0 1 Apache License 2.0 apache-2.0 1 ["datasette", "datasette-io", "datasette-plugin"] 0 1 3 master  
272098486 MDEwOlJlcG9zaXRvcnkyNzIwOTg0ODY= datasette-psutil simonw/datasette-psutil 0 simonw 9599 https://github.com/simonw/datasette-psutil Datasette plugin adding a /-/psutil debugging endpoint 0 2020-06-13T22:57:07Z 2021-01-05T23:22:58Z 2020-06-15T20:50:56Z   10 1 1 Python 1 1 1 1 0 0 0 0 1 Apache License 2.0 apache-2.0 1 ["datasette", "datasette-io", "datasette-plugin", "psutil"] 0 1 1 main  
273609879 MDEwOlJlcG9zaXRvcnkyNzM2MDk4Nzk= datasette-saved-queries simonw/datasette-saved-queries 0 simonw 9599 https://github.com/simonw/datasette-saved-queries Datasette plugin that lets users save and execute queries 0 2020-06-20T00:20:42Z 2020-09-24T05:08:37Z 2020-08-15T23:38:46Z   12 2 2 Python 1 1 1 1 0 0 0 0 1   1 ["datasette", "datasette-io", "datasette-plugin"] 0 1 2 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  
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  
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  
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  
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  
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  
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  
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  

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