repos

12 rows where open_issues_count = 4

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: owner, homepage, size, forks_count, topics, forks, created_at (date), updated_at (date), pushed_at (date), topics (array)

open_issues_count 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
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 2023-07-05T10:26:55Z 2023-08-19T17:54:36Z https://datasette-render-images-demo.datasette.io/favicons/favicons 38 18 18 Python 1 1 1 1 0 0 5 0 0 4   1 0 0 ["datasette", "datasette-io", "datasette-plugin", "plugin"] public 5 4 18 main  
195087137 MDEwOlJlcG9zaXRvcnkxOTUwODcxMzc= datasette-auth-github simonw/datasette-auth-github 0 simonw 9599 https://github.com/simonw/datasette-auth-github Datasette plugin that authenticates users against GitHub 0 2019-07-03T16:02:53Z 2023-10-27T22:44:16Z 2022-11-22T17:20:25Z https://datasette-auth-github-demo.datasette.io/ 119 41 41 Python 1 1 1 1 0 0 6 0 0 4 Apache License 2.0 apache-2.0 1 0 0 ["asgi", "datasette", "datasette-io", "datasette-plugin"] public 6 4 41 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  
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 2024-01-12T20:42:05Z 2022-04-13T23:39:25Z   117 50 50 Python 1 1 1 1 0 0 5 0 0 4 Apache License 2.0 apache-2.0 1 0 0 ["datasette-io", "datasette-tool", "geojson", "gis", "sqlite"] public 5 4 50 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  
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 2023-02-14T12:23:36Z 2024-01-10T19:18:42Z   92 16 16 Python 1 1 1 1 0 0 4 0 0 4   1 0 0 ["cookiecutter-template", "datasette"] public 4 4 16 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 2023-09-08T18:09:19Z 2021-09-11T06:03:07Z https://datasette.io/plugins/datasette-write 15 8 8 Python 1 1 1 1 0 0 2 0 0 4   1 0 0 ["datasette-io", "datasette-plugin"] public 2 4 8 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  
423589294 R_kgDOGT91rg datasette-jupyterlite simonw/datasette-jupyterlite 0 simonw 9599 https://github.com/simonw/datasette-jupyterlite JupyterLite as a Datasette plugin 0 2021-11-01T19:22:51Z 2022-09-19T20:29:54Z 2021-11-05T05:12:33Z   9 11 11 Python 1 1 1 1 0 0 0 0 0 4   1 0 0 [] public 0 4 11 main  
494839851 R_kgDOHX6oKw google-calendar-to-sqlite simonw/google-calendar-to-sqlite 0 simonw 9599 https://github.com/simonw/google-calendar-to-sqlite Create a SQLite database containing your data from Google Calendar 0 2022-05-21T16:41:58Z 2024-01-04T17:08:43Z 2022-05-21T16:58:35Z   15 55 55 Python 1 1 1 1 0 0 2 0 0 4 Apache License 2.0 apache-2.0 1 0 0 [] public 2 4 55 main  
584885824 R_kgDOItymQA datasette-openai simonw/datasette-openai 0 simonw 9599 https://github.com/simonw/datasette-openai SQL functions for calling OpenAI APIs 0 2023-01-03T19:12:52Z 2023-08-22T19:20:13Z 2023-01-14T02:29:43Z https://datasette.io/plugins/datasette-openai 28 19 19 Python 1 1 1 1 0 0 2 0 0 4 Apache License 2.0 apache-2.0 1 0 0 ["datasette", "datasette-plugin", "gpt-3", "openai"] public 2 4 19 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]);