repos

10 rows where forks = 3

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: owner, homepage, language, open_issues_count, topics, open_issues, default_branch, created_at (date), updated_at (date), pushed_at (date), topics (array)

forks 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
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 2021-09-22T04:45:41Z 2020-05-21T23:37:28Z https://24ways.org/2018/fast-autocomplete-search-for-your-website/ 14 4 4 Jupyter Notebook 1 1 1 1 0 0 3 0 0 0 Apache License 2.0 apache-2.0 1 0 0 ["24ways", "datasette", "jupyter-notebook", "sqlite"] public 3 0 4 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 2024-01-05T12:52:52Z 2022-05-13T18:09:22Z   13 72 72 Python 1 1 1 1 0 0 3 0 0 2 Apache License 2.0 apache-2.0 1 0 0 ["datasette-io", "datasette-tool", "markdown", "sqlite", "yaml"] public 3 2 72 main  
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 2023-08-27T07:23:28Z 2023-08-24T21:45:20Z https://datasette.io/plugins/datasette-jellyfish 16 12 12 Python 1 1 1 1 0 0 3 0 0 1 Apache License 2.0 apache-2.0 1 0 0 ["datasette", "datasette-io", "datasette-plugin"] public 3 1 12 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 2023-12-13T11:09:03Z 2022-08-18T22:49:29Z   30 88 88 Python 1 1 1 1 0 0 3 0 0 4 Apache License 2.0 apache-2.0 1 0 0 ["datasette-io", "datasette-tool", "sqlite"] public 3 4 88 main  
205429375 MDEwOlJlcG9zaXRvcnkyMDU0MjkzNzU= swarm-to-sqlite dogsheep/swarm-to-sqlite 0 dogsheep 53015001 https://github.com/dogsheep/swarm-to-sqlite Create a SQLite database containing your checkin history from Foursquare Swarm 0 2019-08-30T17:37:29Z 2024-01-11T15:23:44Z 2023-04-11T03:18:16Z   34 56 56 Python 1 1 1 1 0 0 3 0 0 4 Apache License 2.0 apache-2.0 1 0 0 ["datasette", "datasette-io", "datasette-tool", "dogsheep", "foursquare", "foursquare-api", "sqlite", "swarm"] public 3 4 56 main  
240815938 MDEwOlJlcG9zaXRvcnkyNDA4MTU5Mzg= shapefile-to-sqlite simonw/shapefile-to-sqlite 0 simonw 9599 https://github.com/simonw/shapefile-to-sqlite Load shapefiles into a SQLite (optionally SpatiaLite) database 0 2020-02-16T01:55:29Z 2024-01-13T01:52:47Z 2023-01-08T20:24:46Z   61 27 27 Python 1 1 1 1 0 0 3 0 0 4 Apache License 2.0 apache-2.0 1 0 0 ["datasette", "datasette-io", "datasette-tool", "gis", "shapefiles", "spatialite", "sqlite"] public 3 4 27 main  
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 2024-01-25T12:23:14Z 2024-01-09T05:10:26Z   186 13 13 Python 1 1 1 1 0 0 3 0 0 1 Apache License 2.0 apache-2.0 1 0 0 ["datasette", "datasette-io", "datasette-plugin", "search"] public 3 1 13 main  
279357123 MDEwOlJlcG9zaXRvcnkyNzkzNTcxMjM= datasette-auth-passwords simonw/datasette-auth-passwords 0 simonw 9599 https://github.com/simonw/datasette-auth-passwords Datasette plugin for authentication using passwords 0 2020-07-13T16:34:39Z 2023-10-06T19:18:58Z 2023-09-25T18:53:20Z https://datasette-auth-passwords-demo.datasette.io 39 19 19 Python 1 1 1 1 0 0 3 0 0 7   1 0 0 ["datasette", "datasette-io", "datasette-plugin"] public 3 7 19 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 2023-07-25T14:38:13Z 2023-02-26T19:23:46Z   63 6 6 Ruby 1 1 1 1 0 0 3 0 0 2   1 0 0 [] public 3 2 6 main  
331151708 MDEwOlJlcG9zaXRvcnkzMzExNTE3MDg= datasette-leaflet-freedraw simonw/datasette-leaflet-freedraw 0 simonw 9599 https://github.com/simonw/datasette-leaflet-freedraw Draw polygons on maps in Datasette 0 2021-01-20T00:55:03Z 2023-10-21T03:05:25Z 2023-01-09T20:17:06Z   1179 14 14 Python 1 1 1 1 0 0 3 0 0 4   1 0 0 ["datasette", "datasette-io", "datasette-plugin", "leafletjs"] public 3 4 14 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]);