21 rows where forks = 1

View and edit SQL

Suggested facets: owner, homepage, size, stargazers_count, watchers_count, language, archived, open_issues_count, topics, 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
129660868 MDEwOlJlcG9zaXRvcnkxMjk2NjA4Njg= datasette-plugin-demos simonw/datasette-plugin-demos 0 simonw 9599 https://github.com/simonw/datasette-plugin-demos Some examples plugins for Datasette 0 2018-04-15T23:45:27Z 2020-07-14T04:11:25Z 2020-07-14T04:12:32Z   6 0 0 Python 1 1 1 1 0 1 0 0 1   1 [] 1 1 0 master  
143637623 MDEwOlJlcG9zaXRvcnkxNDM2Mzc2MjM= russian-troll-tweets-datasette simonw/russian-troll-tweets-datasette 0 simonw 9599 https://github.com/simonw/russian-troll-tweets-datasette The FiveThirtyEight collection of Russian troll tweets published using Datasette 0 2018-08-05T18:25:00Z 2021-01-18T05:57:59Z 2021-01-18T05:57:56Z http://russian-troll-tweets.datasettes.com/ 4 2 2 Dockerfile 1 1 1 1 0 1 0 0 0   1 ["datasette", "fivethirtyeight"] 1 0 2 main  
158149672 MDEwOlJlcG9zaXRvcnkxNTgxNDk2NzI= datasette-small simonw/datasette-small 0 simonw 9599 https://github.com/simonw/datasette-small Experimental project for building smallest possible Docker image for Datasette 0 2018-11-19T02:18:11Z 2018-11-19T02:53:45Z 2018-11-19T02:53:43Z   0 0 0 Dockerfile 1 1 1 1 0 1 0 0 0   1 [] 1 0 0 master  
163790822 MDEwOlJlcG9zaXRvcnkxNjM3OTA4MjI= datasette-sqlite-fts4 simonw/datasette-sqlite-fts4 0 simonw 9599 https://github.com/simonw/datasette-sqlite-fts4 Datasette plugin that adds custom SQL functions for working with SQLite FTS4 0 2019-01-02T03:40:41Z 2020-09-24T04:45:12Z 2019-01-07T06:38:08Z   9 2 2 Python 1 1 1 1 0 1 0 0 0 Apache License 2.0 apache-2.0 1 ["datasette", "datasette-io", "datasette-plugin", "plugin"] 1 0 2 master  
174619733 MDEwOlJlcG9zaXRvcnkxNzQ2MTk3MzM= datasette-car-2019 simonw/datasette-car-2019 0 simonw 9599 https://github.com/simonw/datasette-car-2019 Notes from my CAR 2019 Datasette tutorial 0 2019-03-08T22:34:27Z 2019-10-04T17:35:53Z 2019-03-09T17:01:11Z   20 7 7   1 1 1 1 0 1 0 0 0   1 [] 1 0 7 master  
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 2021-09-09T23:46:31Z 2021-01-18T04:36:03Z   49 41 41 Python 1 1 1 1 0 1 0 0 2 Apache License 2.0 apache-2.0 1 ["datasette", "datasette-io", "datasette-tool", "dogsheep", "foursquare", "foursquare-api", "sqlite", "swarm"] 1 2 41 main  
214299267 MDEwOlJlcG9zaXRvcnkyMTQyOTkyNjc= datasette-render-timestamps simonw/datasette-render-timestamps 0 simonw 9599 https://github.com/simonw/datasette-render-timestamps Datasette plugin for rendering timestamps 0 2019-10-10T22:50:50Z 2020-10-17T11:09:42Z 2020-03-22T17:57:17Z   17 4 4 Python 1 1 1 1 0 1 0 0 0 Apache License 2.0 apache-2.0 1 ["datasette", "datasette-io", "datasette-plugin"] 1 0 4 master  
219372133 MDEwOlJlcG9zaXRvcnkyMTkzNzIxMzM= sqlite-transform simonw/sqlite-transform 0 simonw 9599 https://github.com/simonw/sqlite-transform Tool for running transformations on columns in a SQLite database 0 2019-11-03T22:07:53Z 2021-08-23T07:35:13Z 2021-08-02T22:07:57Z   64 29 29 Python 1 1 1 1 0 1 1 0 0 Apache License 2.0 apache-2.0 1 ["datasette-io", "datasette-tool", "sqlite"] 1 0 29 main  
220558687 MDEwOlJlcG9zaXRvcnkyMjA1NTg2ODc= datasette-csvs simonw/datasette-csvs 0 simonw 9599 https://github.com/simonw/datasette-csvs Glitch project that converts and serves CSV files using Datasette 0 2019-11-08T22:38:30Z 2020-02-28T16:35:25Z 2020-02-28T16:35:23Z https://glitch.com/~datasette-csvs 4 0 0 Shell 1 1 1 1 0 1 0 0 0   1 ["datasette", "glitch"] 1 0 0 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  
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  
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  
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 2021-05-12T22:36:32Z 2021-06-17T00:17:21Z   185 6 6 Python 1 1 1 1 0 1 0 0 1 Apache License 2.0 apache-2.0 1 ["datasette", "datasette-io", "datasette-plugin", "search"] 1 1 6 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 2021-07-30T22:10:23Z 2021-07-30T22:11:11Z   16 4 4 Python 1 1 1 1 0 1 0 0 1 Apache License 2.0 apache-2.0 1 ["datasette", "datasette-io", "datasette-plugin", "fly"] 1 1 4 main  
274213732 MDEwOlJlcG9zaXRvcnkyNzQyMTM3MzI= datasette.io simonw/datasette.io 0 simonw 9599 https://github.com/simonw/datasette.io The official project website for Datasette 0 2020-06-22T18:29:44Z 2021-09-15T12:58:03Z 2021-09-14T03:41:11Z https://datasette.io 764 20 20 HTML 1 1 1 1 0 1 0 0 12   1 ["datasette"] 1 12 20 main  
289340983 MDEwOlJlcG9zaXRvcnkyODkzNDA5ODM= calands-datasette simonw/calands-datasette 0 simonw 9599 https://github.com/simonw/calands-datasette Datasette instance with data from calands.org 0 2020-08-21T18:41:25Z 2021-03-27T16:19:03Z 2021-03-27T16:19:01Z https://calands.datasettes.com 28 2 2 Shell 1 1 1 1 0 1 0 0 2   1 ["datasette", "greeninfo-network"] 1 2 2 main  
291359358 MDEwOlJlcG9zaXRvcnkyOTEzNTkzNTg= datasette-yaml simonw/datasette-yaml 0 simonw 9599 https://github.com/simonw/datasette-yaml Export Datasette records as YAML 0 2020-08-29T22:32:15Z 2020-12-28T03:20:36Z 2021-05-13T08:59:53Z   7 2 2 Python 1 1 1 1 0 1 0 0 1   1 ["datasette", "datasette-io", "datasette-plugin", "yaml"] 1 1 2 main  
301879297 MDEwOlJlcG9zaXRvcnkzMDE4NzkyOTc= buildpack-datasette simonw/buildpack-datasette 0 simonw 9599 https://github.com/simonw/buildpack-datasette Repository template for creating a new Datasette buildpack instance 0 2020-10-06T23:31:39Z 2021-03-12T00:21:17Z 2020-12-18T02:31:46Z https://docs.datasette.io/en/stable/deploying.html#deploying-using-buildpacks 48 1 1   1 1 1 1 0 1 0 0 0   1 ["buildpacks", "datasette"] 1 0 1 main  
341312930 MDEwOlJlcG9zaXRvcnkzNDEzMTI5MzA= vaccinate-ca-datasette simonw/vaccinate-ca-datasette 0 simonw 9599 https://github.com/simonw/vaccinate-ca-datasette   0 2021-02-22T19:27:02Z 2021-03-24T00:32:41Z 2021-03-02T09:10:00Z https://vaccinateca.datasette.io/ 13 0 0 Shell 1 1 1 1 0 1 0 0 0   1 [] 1 0 0 main  
345505165 MDEwOlJlcG9zaXRvcnkzNDU1MDUxNjU= us-counties-datasette simonw/us-counties-datasette 0 simonw 9599 https://github.com/simonw/us-counties-datasette A Datasette instance exposing names, FIPS codes and polygons of US counties 0 2021-03-08T02:16:19Z 2021-06-16T23:38:02Z 2021-08-22T20:05:55Z https://us-counties.datasette.io 7 5 5 Shell 1 1 1 1 0 1 0 0 1   1 ["datasette"] 1 1 5 main  
394107614 MDEwOlJlcG9zaXRvcnkzOTQxMDc2MTQ= datasette-query-links simonw/datasette-query-links 0 simonw 9599 https://github.com/simonw/datasette-query-links Turn SELECT queries returned by a query into links to execute them 0 2021-08-09T01:16:59Z 2021-08-14T21:36:57Z 2021-08-09T02:56:40Z   7 4 4 Python 1 1 1 1 0 1 0 0 0   1 [] 1 0 4 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]);