repos

6 rows where forks = 7

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: owner, homepage, language, has_pages, open_issues_count, 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
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 2024-01-16T06:52:00Z 2024-01-01T09:50:34Z   93 14 14 Python 1 1 1 1 0 0 7 0 0 6   1 0 0 ["datasette", "datasette-io", "datasette-plugin", "gis", "leaflet"] public 7 6 14 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 2023-12-13T17:32:53Z 2023-08-27T22:01:00Z   59 55 55 JavaScript 1 1 1 1 0 0 7 0 0 37 Apache License 2.0 apache-2.0 1 0 0 ["datasette", "datasette-io", "datasette-plugin", "plugin", "react", "vega"] public 7 37 55 master  
197882382 MDEwOlJlcG9zaXRvcnkxOTc4ODIzODI= healthkit-to-sqlite dogsheep/healthkit-to-sqlite 0 dogsheep 53015001 https://github.com/dogsheep/healthkit-to-sqlite Convert an Apple Healthkit export zip to a SQLite database 0 2019-07-20T05:03:12Z 2024-01-22T12:33:18Z 2023-01-01T17:29:57Z https://datasette.io/tools/healthkit-to-sqlite 29 182 182 Python 1 1 1 1 0 0 7 0 0 12 Apache License 2.0 apache-2.0 1 0 0 ["datasette", "datasette-io", "datasette-tool", "dogsheep", "healthkit", "sqlite"] public 7 12 182 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  
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  
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 2024-01-04T01:26:31Z 2022-08-24T17:43:41Z   55 38 38 Python 1 1 1 1 0 0 7 0 0 19 Apache License 2.0 apache-2.0 1 0 0 ["datasette", "datasette-io", "datasette-plugin", "vercel", "zeit-now"] public 7 19 38 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]);