repos

6 rows where open_issues_count = 6

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: owner, homepage, has_projects, has_wiki, 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
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  
246381036 MDEwOlJlcG9zaXRvcnkyNDYzODEwMzY= covid-19-datasette simonw/covid-19-datasette 0 simonw 9599 https://github.com/simonw/covid-19-datasette Deploys a Datasette instance of COVID-19 data from Johns Hopkins CSSE and the New York Times 0 2020-03-10T18:44:52Z 2023-03-22T20:10:14Z 2022-03-22T01:53:05Z https://covid-19.datasettes.com/ 157 61 61 Python 1 0 1 0 0 0 6 0 0 6   1 0 0 ["covid-19", "datasette"] public 6 6 61 main  
303218369 MDEwOlJlcG9zaXRvcnkzMDMyMTgzNjk= evernote-to-sqlite dogsheep/evernote-to-sqlite 0 dogsheep 53015001 https://github.com/dogsheep/evernote-to-sqlite Tools for converting Evernote content to SQLite 0 2020-10-11T21:45:49Z 2023-06-26T01:36:28Z 2021-11-02T20:04:32Z   51 35 35 Python 1 1 1 1 0 0 5 0 0 6 Apache License 2.0 apache-2.0 1 0 0 ["datasette-io", "datasette-tool", "dogsheep", "evernote", "sqlite"] public 5 6 35 main  
315796015 MDEwOlJlcG9zaXRvcnkzMTU3OTYwMTU= datasette-ripgrep simonw/datasette-ripgrep 0 simonw 9599 https://github.com/simonw/datasette-ripgrep Web interface for searching your code using ripgrep, built as a Datasette plugin 0 2020-11-25T01:26:36Z 2023-11-27T20:34:01Z 2023-10-25T02:06:56Z https://ripgrep.datasette.io 66 69 69 Python 1 1 1 1 0 0 1 0 0 6 Apache License 2.0 apache-2.0 1 0 0 ["codesearch", "datasette", "datasette-io", "datasette-plugin", "ripgrep"] public 1 6 69 main  
571072624 R_kgDOIgngcA datasette-export simonw/datasette-export 0 simonw 9599 https://github.com/simonw/datasette-export Export pages from Datasette to files on disk 0 2022-11-27T04:03:08Z 2022-12-09T23:11:24Z 2022-11-27T04:20:09Z   8 3 3 Python 1 1 1 1 0 0 0 0 0 6 Apache License 2.0 apache-2.0 1 0 0 [] public 0 6 3 main  
625395502 R_kgDOJUbHLg sqlite-history simonw/sqlite-history 0 simonw 9599 https://github.com/simonw/sqlite-history Track changes to SQLite tables using triggers 0 2023-04-09T01:19:26Z 2024-01-11T14:04:42Z 2023-08-12T22:53:12Z   36 80 80 Python 1 1 1 1 0 0 1 0 0 6 Apache License 2.0 apache-2.0 1 0 0 [] public 1 6 80 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]);