8 rows where open_issues = 5

View and edit SQL

Suggested facets: owner, homepage, size, stargazers_count, watchers_count, has_pages, forks_count, 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
166159072 MDEwOlJlcG9zaXRvcnkxNjYxNTkwNzI= db-to-sqlite simonw/db-to-sqlite 0 simonw 9599 https://github.com/simonw/db-to-sqlite CLI tool for exporting tables or queries from any SQL database to a SQLite file 0 2019-01-17T04:16:48Z 2021-09-14T11:02:12Z 2021-08-07T20:59:43Z   77 248 248 Python 1 1 1 1 0 16 0 0 5 Apache License 2.0 apache-2.0 1 ["datasette", "datasette-io", "datasette-tool", "sqlalchemy", "sqlite"] 16 5 248 main  
167759846 MDEwOlJlcG9zaXRvcnkxNjc3NTk4NDY= markdown-to-sqlite simonw/markdown-to-sqlite 0 simonw 9599 https://github.com/simonw/markdown-to-sqlite CLI tool for loading markdown files into a SQLite database 0 2019-01-27T02:04:54Z 2021-09-20T19:25:31Z 2021-08-23T09:57:22Z   11 39 39 Python 1 1 1 1 0 3 0 0 5 Apache License 2.0 apache-2.0 1 ["datasette-io", "datasette-tool", "markdown", "sqlite", "yaml"] 3 5 39 main  
195145678 MDEwOlJlcG9zaXRvcnkxOTUxNDU2Nzg= sqlite-diffable simonw/sqlite-diffable 0 simonw 9599 https://github.com/simonw/sqlite-diffable Tools for dumping/loading a SQLite database to diffable directory structure 0 2019-07-04T00:58:46Z 2021-08-10T13:21:51Z 2020-08-17T21:04:22Z   12 22 22 Python 1 1 1 1 0 3 0 0 5 Apache License 2.0 apache-2.0 1 ["datasette-io", "datasette-tool", "sqlite"] 3 5 22 main  
214746582 MDEwOlJlcG9zaXRvcnkyMTQ3NDY1ODI= dogsheep.github.io dogsheep/dogsheep.github.io 0 dogsheep 53015001 https://github.com/dogsheep/dogsheep.github.io Tools for personal analytics using SQLite and Datasette 0 2019-10-13T02:10:13Z 2021-09-19T23:48:18Z 2021-06-19T12:26:16Z https://dogsheep.github.io/ 16 99 99   1 1 1 1 1 6 0 0 5   1 ["datasette", "dogsheep", "sqlite"] 6 5 99 master  
234825790 MDEwOlJlcG9zaXRvcnkyMzQ4MjU3OTA= datasette-upload-csvs simonw/datasette-upload-csvs 0 simonw 9599 https://github.com/simonw/datasette-upload-csvs Datasette plugin for uploading CSV files and converting them to database tables 0 2020-01-19T02:07:05Z 2021-06-07T19:12:22Z 2021-06-07T16:41:25Z   43 7 7 Python 1 1 1 1 0 1 0 0 5 Apache License 2.0 apache-2.0 1 ["csvs", "datasette", "datasette-io", "datasette-plugin"] 1 5 7 main  
237321267 MDEwOlJlcG9zaXRvcnkyMzczMjEyNjc= geojson-to-sqlite simonw/geojson-to-sqlite 0 simonw 9599 https://github.com/simonw/geojson-to-sqlite CLI tool for converting GeoJSON files to SQLite (with SpatiaLite) 0 2020-01-30T22:51:05Z 2021-07-27T02:48:49Z 2021-05-20T19:15:44Z   77 30 30 Python 1 1 1 1 0 1 0 0 5 Apache License 2.0 apache-2.0 1 ["datasette-io", "datasette-tool", "geojson", "gis", "sqlite"] 1 5 30 main  
280500027 MDEwOlJlcG9zaXRvcnkyODA1MDAwMjc= datasette-insert simonw/datasette-insert 0 simonw 9599 https://github.com/simonw/datasette-insert Datasette plugin for inserting and updating data 0 2020-07-17T18:40:34Z 2021-07-16T10:15:29Z 2020-08-09T17:12:12Z   39 7 7 Python 1 1 1 1 0 0 0 0 5   1 ["datasette", "datasette-io", "datasette-plugin"] 0 5 7 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  

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