10 rows where forks = 3

View and edit SQL

Suggested facets: owner, homepage, size, stargazers_count, watchers_count, language, has_projects, has_wiki, open_issues_count, open_issues, watchers, default_branch, created_at (date), updated_at (date), pushed_at (date), topics (array)

forks

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  
162077240 MDEwOlJlcG9zaXRvcnkxNjIwNzcyNDA= 24ways-datasette simonw/24ways-datasette 0 simonw 9599 https://github.com/simonw/24ways-datasette Supporting material for my 24 ways article in 2018 0 2018-12-17T05:03:57Z 2020-12-10T00:40:22Z 2020-05-21T23:37:28Z https://24ways.org/2018/fast-autocomplete-search-for-your-website/ 14 3 3 Jupyter Notebook 1 1 1 1 0 3 0 0 0 Apache License 2.0 apache-2.0 1 ["24ways", "datasette", "jupyter-notebook", "sqlite"] 3 0 3 master  
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  
175550127 MDEwOlJlcG9zaXRvcnkxNzU1NTAxMjc= yaml-to-sqlite simonw/yaml-to-sqlite 0 simonw 9599 https://github.com/simonw/yaml-to-sqlite Utility for converting YAML files to SQLite 0 2019-03-14T04:49:08Z 2021-08-10T13:23:04Z 2021-06-13T04:45:52Z   19 39 39 Python 1 1 1 1 0 3 0 0 0 Apache License 2.0 apache-2.0 1 ["datasette-io", "datasette-tool", "sqlite", "yaml"] 3 0 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  
197431109 MDEwOlJlcG9zaXRvcnkxOTc0MzExMDk= dogsheep-beta dogsheep/dogsheep-beta 0 dogsheep 53015001 https://github.com/dogsheep/dogsheep-beta Build a search index across content from multiple SQLite database tables and run faceted searches against it using Datasette 0 2019-07-17T17:07:26Z 2021-09-19T08:58:53Z 2021-09-03T17:47:45Z https://dogsheep.github.io/ 61 109 109 Python 1 0 1 0 0 3 0 0 13   1 ["datasette", "datasette-io", "datasette-plugin", "datasette-tool", "dogsheep", "search"] 3 13 109 main  
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 2021-09-09T14:29:02Z 2020-11-24T23:25:14Z   17 53 53 Python 1 1 1 1 0 3 0 0 6 Apache License 2.0 apache-2.0 1 ["datasette", "datasette-io", "datasette-tool", "dogsheep", "pocket", "pocket-api", "sqlite"] 3 6 53 master  
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  
253632948 MDEwOlJlcG9zaXRvcnkyNTM2MzI5NDg= datasette-publish-vercel simonw/datasette-publish-vercel 0 simonw 9599 https://github.com/simonw/datasette-publish-vercel Datasette plugin for publishing data using Vercel 0 2020-04-06T22:47:13Z 2021-08-08T10:45:53Z 2021-07-25T18:38:42Z   85 11 11 Python 1 1 1 1 0 3 0 0 18 Apache License 2.0 apache-2.0 1 ["datasette", "datasette-io", "datasette-plugin", "vercel", "zeit-now"] 3 18 11 main  
335175637 MDEwOlJlcG9zaXRvcnkzMzUxNzU2Mzc= datasette-tiles simonw/datasette-tiles 0 simonw 9599 https://github.com/simonw/datasette-tiles Mapping tile server for Datasette, serving tiles from MBTiles packages 0 2021-02-02T05:11:12Z 2021-07-16T21:25:19Z 2021-02-12T00:56:29Z https://datasette.io/plugins/datasette-tiles 54 3 3 Python 1 1 1 1 0 3 0 0 8   1 ["datasette", "datasette-io", "datasette-plugin", "mbtiles"] 3 8 3 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]);