repos

13 rows where open_issues_count = 5

✎ View and edit SQL

This data as json, CSV (advanced)

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

open_issues_count 1 ✖

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 has_discussions forks_count archived disabled open_issues_count license allow_forking is_template web_commit_signoff_required topics visibility 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 2023-12-26T20:38:21Z 2022-06-30T19:34:07Z   8 42 42 Python 1 1 1 1 0 0 12 0 0 5 Apache License 2.0 apache-2.0 1 0 0 ["datasette-io", "datasette-tool", "dbase", "dbf", "foxpro", "sqlite"] public 12 5 42 master  
213286752 MDEwOlJlcG9zaXRvcnkyMTMyODY3NTI= pocket-to-sqlite dogsheep/pocket-to-sqlite 0 dogsheep 53015001 https://github.com/dogsheep/pocket-to-sqlite Create a SQLite database containing data from your Pocket account 0 2019-10-07T03:24:14Z 2024-01-15T17:53:41Z 2023-07-10T19:24:26Z   25 98 98 Python 1 1 1 1 0 0 5 0 0 5 Apache License 2.0 apache-2.0 1 0 0 ["datasette", "datasette-io", "datasette-tool", "dogsheep", "pocket", "pocket-api", "sqlite"] public 5 5 98 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 2023-12-09T15:28:28Z 2024-01-19T19:08:44Z https://dogsheep.github.io/ 10 117 117   1 1 1 1 1 0 7 0 0 5   1 0 0 ["datasette", "dogsheep", "sqlite"] public 7 5 117 master  
247527438 MDEwOlJlcG9zaXRvcnkyNDc1Mjc0Mzg= datasette-edit-schema simonw/datasette-edit-schema 0 simonw 9599 https://github.com/simonw/datasette-edit-schema Datasette plugin for modifying table schemas 0 2020-03-15T18:34:06Z 2023-10-31T00:45:20Z 2023-12-23T01:04:18Z   521 11 11 JavaScript 1 1 1 1 0 0 0 0 0 5 Apache License 2.0 apache-2.0 1 0 0 ["datasette", "datasette-io", "datasette-plugin"] public 0 5 11 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 2023-12-29T18:01:32Z 2023-08-21T18:59:10Z   69 19 19 Python 1 1 1 1 0 0 7 0 0 5 Apache License 2.0 apache-2.0 1 0 0 ["datasette", "datasette-io", "datasette-plugin", "fly"] public 7 5 19 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 2023-08-06T05:38:49Z 2023-03-26T22:22:39Z   19 43 43 Python 1 1 1 1 0 0 5 0 0 5 Apache License 2.0 apache-2.0 1 0 0 ["datasette", "datasette-io", "datasette-tool", "dogsheep", "hacker-news"] public 5 5 43 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 2023-09-20T04:31:07Z 2023-09-20T04:31:03Z   13 8 8 Python 1 1 1 1 0 0 0 0 0 5   1 0 0 ["datasette", "datasette-io", "datasette-plugin"] public 0 5 8 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 2024-01-04T16:50:11Z 2022-03-22T01:49:36Z https://datasette-seaborn-demo.datasette.io/ 26 11 11 Python 1 1 1 1 0 0 0 0 0 5   1 0 0 ["datasette", "datasette-io", "datasette-plugin", "seaborn", "visualization"] public 0 5 11 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 2022-11-09T04:19:13Z 2022-04-27T20:58:13Z   124 7 7 JavaScript 1 1 1 1 0 0 2 0 0 5   1 0 0 ["datasette", "datasette-io", "datasette-plugin"] public 2 5 7 main  
498453589 R_kgDOHbXMVQ mbox-to-sqlite simonw/mbox-to-sqlite 0 simonw 9599 https://github.com/simonw/mbox-to-sqlite Load email from .mbox files into SQLite 0 2022-05-31T18:31:44Z 2024-01-26T13:46:20Z 2023-10-24T00:01:42Z   9 21 21 Python 1 1 1 1 0 0 4 0 0 5 Apache License 2.0 apache-2.0 1 0 0 ["email", "mbox", "sqlite"] public 4 5 21 main  
529472005 R_kgDOH48aBQ laion-aesthetic-datasette simonw/laion-aesthetic-datasette 0 simonw 9599 https://github.com/simonw/laion-aesthetic-datasette Use Datasette to explore LAION improved_aesthetics_6plus training data used by Stable DIffusion 0 2022-08-27T03:36:47Z 2024-01-06T13:22:41Z 2023-12-20T15:04:15Z   17 56 56 Python 1 1 1 1 0 0 12 0 0 5   1 0 0 [] public 12 5 56 main  
618260446 R_kgDOJNnn3g datasette-chatgpt-plugin simonw/datasette-chatgpt-plugin 0 simonw 9599 https://github.com/simonw/datasette-chatgpt-plugin A Datasette plugin that turns a Datasette instance into a ChatGPT plugin 0 2023-03-24T04:46:24Z 2024-01-05T01:29:41Z 2023-03-24T18:41:00Z https://datasette.io/plugins/datasette-chatgpt-plugin 19 54 54 Python 1 1 1 1 0 0 0 0 0 5 Apache License 2.0 apache-2.0 1 0 0 ["chatgpt", "chatgpt-plugin", "datasette", "datasette-plugin"] public 0 5 54 main  
669646940 R_kgDOJ-oAXA sqlite-migrate simonw/sqlite-migrate 0 simonw 9599 https://github.com/simonw/sqlite-migrate A simple database migration system for SQLite, based on sqlite-utils 0 2023-07-23T01:09:14Z 2024-01-14T00:09:00Z 2023-10-27T23:46:35Z   31 36 36 Python 1 1 1 1 0 0 2 0 0 5 Apache License 2.0 apache-2.0 1 0 0 [] public 2 5 36 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,
   [has_discussions] INTEGER,
   [forks_count] INTEGER,
   [archived] INTEGER,
   [disabled] INTEGER,
   [open_issues_count] INTEGER,
   [license] TEXT REFERENCES [licenses]([key]),
   [allow_forking] INTEGER,
   [is_template] INTEGER,
   [web_commit_signoff_required] INTEGER,
   [topics] TEXT,
   [visibility] TEXT,
   [forks] INTEGER,
   [open_issues] INTEGER,
   [watchers] INTEGER,
   [default_branch] TEXT,
   [organization] INTEGER REFERENCES [users]([id])
);
CREATE INDEX [idx_repos_organization]
    ON [repos] ([organization]);
CREATE INDEX [idx_repos_license]
    ON [repos] ([license]);
CREATE INDEX [idx_repos_owner]
    ON [repos] ([owner]);