repos

14 rows where forks = 2

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: homepage, size, stargazers_count, watchers_count, language, 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
133958542 MDEwOlJlcG9zaXRvcnkxMzM5NTg1NDI= fivethirtyeight-datasette simonw/fivethirtyeight-datasette 0 simonw 9599 https://github.com/simonw/fivethirtyeight-datasette Code to package FiveThirtyEight data using Datasette 0 2018-05-18T13:33:05Z 2021-08-18T19:45:13Z 2021-06-05T22:42:17Z https://fivethirtyeight.datasettes.com 44 7 7 Python 1 1 1 1 0 2 0 0 1   1 ["datasette", "fivethirtyeight", "sqlite"] 2 1 7 main  
134587939 MDEwOlJlcG9zaXRvcnkxMzQ1ODc5Mzk= global-power-plants-datasette simonw/global-power-plants-datasette 0 simonw 9599 https://github.com/simonw/global-power-plants-datasette Datasette showing global power plant data from https://github.com/wri/global-power-plant-database 0 2018-05-23T15:14:40Z 2021-08-11T11:59:58Z 2021-06-05T22:24:40Z https://global-power-plants.datasettes.com/ 34 11 11   1 1 1 1 0 2 0 0 0   1 ["datasette", "energy"] 2 0 11 main  
138669673 MDEwOlJlcG9zaXRvcnkxMzg2Njk2NzM= datasette-vega simonw/datasette-vega 0 simonw 9599 https://github.com/simonw/datasette-vega Datasette plugin for visualizing data using Vega 0 2018-06-26T01:40:54Z 2021-09-01T14:58:36Z 2020-09-04T02:35:51Z   59 40 40 JavaScript 1 1 1 1 0 2 0 0 27 Apache License 2.0 apache-2.0 1 ["datasette", "datasette-io", "datasette-plugin", "plugin", "react", "vega"] 2 27 40 master  
145483077 MDEwOlJlcG9zaXRvcnkxNDU0ODMwNzc= datasette-render-images simonw/datasette-render-images 0 simonw 9599 https://github.com/simonw/datasette-render-images Datasette plugin that renders binary blob images using data-uris 0 2018-08-21T00:05:47Z 2021-09-02T23:41:55Z 2021-09-02T23:41:52Z https://datasette-render-images-demo.datasette.io/favicons/favicons 31 12 12 Python 1 1 1 1 0 2 0 0 2   1 ["datasette", "datasette-io", "datasette-plugin", "plugin"] 2 2 12 main  
162850894 MDEwOlJlcG9zaXRvcnkxNjI4NTA4OTQ= sqlite-fts4 simonw/sqlite-fts4 0 simonw 9599 https://github.com/simonw/sqlite-fts4 Custom Python functions for working with SQLite FTS4 0 2018-12-23T00:08:37Z 2021-01-22T04:15:18Z 2020-11-06T06:14:09Z   33 6 6 Python 1 1 1 1 0 2 0 0 1 Apache License 2.0 apache-2.0 1 ["fts", "python", "sqlite", "sqlite-fts4"] 2 1 6 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 2021-02-06T02:33:49Z 2021-02-06T02:34:18Z https://datasette.io/plugins/datasette-jellyfish 15 9 9 Python 1 1 1 1 0 2 0 0 1 Apache License 2.0 apache-2.0 1 ["datasette", "datasette-io", "datasette-plugin"] 2 1 9 main  
184168864 MDEwOlJlcG9zaXRvcnkxODQxNjg4NjQ= datasette-render-html simonw/datasette-render-html 0 simonw 9599 https://github.com/simonw/datasette-render-html Plugin for selectively rendering the HTML is specific columns 0 2019-04-30T01:21:25Z 2021-09-12T01:43:15Z 2021-03-17T03:57:13Z https://datasette.io/plugins/datasette-render-html 8 2 2 Python 1 1 1 1 0 2 0 0 1   1 ["datasette", "datasette-io", "datasette-plugin"] 2 1 2 master  
273547529 MDEwOlJlcG9zaXRvcnkyNzM1NDc1Mjk= datasette-plugin simonw/datasette-plugin 0 simonw 9599 https://github.com/simonw/datasette-plugin Cookiecutter template for creating Datasette plugins 0 2020-06-19T17:10:15Z 2021-09-09T07:58:42Z 2021-09-06T22:35:22Z   102 9 9 Python 1 1 1 1 0 2 0 0 2   1 ["cookiecutter-template", "datasette"] 2 2 9 main  
275711254 MDEwOlJlcG9zaXRvcnkyNzU3MTEyNTQ= datasette-write simonw/datasette-write 0 simonw 9599 https://github.com/simonw/datasette-write Datasette plugin providing a UI for executing SQL writes against the database 0 2020-06-29T02:27:31Z 2021-09-21T20:18:55Z 2021-09-11T06:03:07Z https://datasette.io/plugins/datasette-write 15 7 7 Python 1 1 1 1 0 2 0 0 2   1 ["datasette-io", "datasette-plugin"] 2 2 7 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 2020-10-10T23:15:39Z 2020-10-10T23:15:37Z   63 4 4 Ruby 1 1 1 1 0 2 0 0 1   1 [] 2 1 4 main  
327236119 MDEwOlJlcG9zaXRvcnkzMjcyMzYxMTk= datasette-export-notebook simonw/datasette-export-notebook 0 simonw 9599 https://github.com/simonw/datasette-export-notebook Datasette plugin providing instructions for exporting data to Jupyter or Observable 0 2021-01-06T07:37:00Z 2021-08-06T14:36:43Z 2021-07-17T04:01:49Z   21 9 9 Python 1 1 1 1 0 2 0 0 2   1 ["datasette-io", "datasette-plugin"] 2 2 9 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 2021-07-02T14:25:28Z 2021-02-28T10:24:00Z   1155 6 6 Python 1 1 1 1 0 2 0 0 2   1 ["datasette", "datasette-io", "datasette-plugin", "leafletjs"] 2 2 6 main  
346597557 MDEwOlJlcG9zaXRvcnkzNDY1OTc1NTc= tableau-to-sqlite simonw/tableau-to-sqlite 0 simonw 9599 https://github.com/simonw/tableau-to-sqlite Fetch data from Tableau into a SQLite database 0 2021-03-11T06:12:02Z 2021-06-10T04:40:44Z 2021-07-29T13:56:42Z   212 8 8 Python 1 1 1 1 0 2 0 0 2 Apache License 2.0 apache-2.0 1 ["datasette-io", "datasette-tool"] 2 2 8 main  
399308604 MDEwOlJlcG9zaXRvcnkzOTkzMDg2MDQ= datasette-app simonw/datasette-app 0 simonw 9599 https://github.com/simonw/datasette-app The Datasette macOS application 0 2021-08-24T02:21:37Z 2021-09-19T01:20:15Z 2021-09-19T01:20:13Z https://datasette.io/desktop 948 54 54 JavaScript 1 1 1 1 0 2 0 0 16   1 ["datasette"] 2 16 54 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]);