8 rows where open_issues = 3

View and edit SQL

Suggested facets: homepage, language, forks_count, topics, forks, 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
168474970 MDEwOlJlcG9zaXRvcnkxNjg0NzQ5NzA= dbf-to-sqlite simonw/dbf-to-sqlite 0 simonw 9599 https://github.com/simonw/dbf-to-sqlite CLI tool for converting DBF files (dBase, FoxPro etc) to SQLite 0 2019-01-31T06:30:46Z 2021-09-13T02:08:57Z 2020-02-16T00:41:20Z   8 27 27 Python 1 1 1 1 0 8 0 0 3 Apache License 2.0 apache-2.0 1 ["datasette-io", "datasette-tool", "dbase", "dbf", "foxpro", "sqlite"] 8 3 27 master  
195087137 MDEwOlJlcG9zaXRvcnkxOTUwODcxMzc= datasette-auth-github simonw/datasette-auth-github 0 simonw 9599 https://github.com/simonw/datasette-auth-github Datasette plugin that authenticates users against GitHub 0 2019-07-03T16:02:53Z 2021-08-18T19:32:04Z 2021-02-25T06:40:17Z https://datasette-auth-github-demo.datasette.io/ 119 36 36 Python 1 1 1 1 0 4 0 0 3 Apache License 2.0 apache-2.0 1 ["asgi", "datasette", "datasette-io", "datasette-plugin"] 4 3 36 main  
216305025 MDEwOlJlcG9zaXRvcnkyMTYzMDUwMjU= museums simonw/museums 0 simonw 9599 https://github.com/simonw/museums A website recommending niche museums to visit 0 2019-10-20T04:01:06Z 2021-08-31T15:15:46Z 2021-09-01T04:45:31Z https://www.niche-museums.com/ 710 22 22 CSS 1 1 1 1 0 5 0 0 3   1 ["datasette", "museums"] 5 3 22 main  
220716822 MDEwOlJlcG9zaXRvcnkyMjA3MTY4MjI= datasette-render-markdown simonw/datasette-render-markdown 0 simonw 9599 https://github.com/simonw/datasette-render-markdown Datasette plugin for rendering Markdown 0 2019-11-09T23:28:31Z 2021-06-02T09:05:12Z 2020-10-28T22:54:59Z   39 7 7 Python 1 1 1 1 0 0 0 0 3 Apache License 2.0 apache-2.0 1 ["datasette", "datasette-io", "datasette-plugin", "markdown"] 0 3 7 main  
236110759 MDEwOlJlcG9zaXRvcnkyMzYxMTA3NTk= datasette-auth-existing-cookies simonw/datasette-auth-existing-cookies 0 simonw 9599 https://github.com/simonw/datasette-auth-existing-cookies Datasette plugin that authenticates users based on existing domain cookies 0 2020-01-25T01:20:31Z 2021-03-26T16:27:41Z 2021-08-17T00:54:06Z   92 3 3 Python 1 1 1 1 0 1 0 0 3 Apache License 2.0 apache-2.0 1 ["datasette", "datasette-io", "datasette-plugin"] 1 3 3 main  
246108561 MDEwOlJlcG9zaXRvcnkyNDYxMDg1NjE= datasette-column-inspect simonw/datasette-column-inspect 0 simonw 9599 https://github.com/simonw/datasette-column-inspect Experimental plugin that adds a column inspector 0 2020-03-09T18:11:00Z 2020-12-09T21:46:10Z 2020-12-09T21:47:38Z   15 1 1 HTML 1 1 1 1 0 0 0 0 3 Apache License 2.0 apache-2.0 1 ["datasette", "datasette-io", "datasette-plugin"] 0 3 1 main  
277672753 MDEwOlJlcG9zaXRvcnkyNzc2NzI3NTM= sba-loans-covid-19-datasette simonw/sba-loans-covid-19-datasette 0 simonw 9599 https://github.com/simonw/sba-loans-covid-19-datasette   0 2020-07-06T23:51:44Z 2020-12-09T22:59:23Z 2020-09-06T02:15:30Z   107 12 12   1 1 1 1 0 0 0 0 3   1 [] 0 3 12 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  

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