repos

20 rows where license = "apache-2.0" and stargazers_count > 10 sorted by fork

View and edit SQL

Suggested facets: owner, homepage, size, stargazers_count, watchers_count, language, has_projects, has_pages, forks_count, open_issues_count, forks, open_issues, watchers, default_branch, permissions, organization, delete_branch_on_merge, network_count, subscribers_count, created_at (date), updated_at (date), pushed_at (date), topics (array)

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 topics forks open_issues watchers default_branch permissions organization temp_clone_token allow_squash_merge allow_merge_commit allow_rebase_merge delete_branch_on_merge network_count subscribers_count parent source
107914493 MDEwOlJlcG9zaXRvcnkxMDc5MTQ0OTM= datasette simonw/datasette 0 simonw 9599 https://github.com/simonw/datasette An open source multi-tool for exploring and publishing data 0 2017-10-23T00:39:03Z 2020-10-19T23:15:50Z 2020-10-19T22:38:11Z https://docs.datasette.io 3709 3929 3929 Python 1 0 1 1 0 215 0 0 206 Apache License 2.0 apache-2.0 ["asgi", "automatic-api", "csv", "datasets", "datasette", "datasette-io", "docker", "json", "python", "sql", "sqlite"] 215 206 3929 main {"admin": true, "push": true, "pull": true}     1 1 1 1 215 85    
130236762 MDEwOlJlcG9zaXRvcnkxMzAyMzY3NjI= datasette-cluster-map simonw/datasette-cluster-map 0 simonw 9599 https://github.com/simonw/datasette-cluster-map Datasette plugin that shows a cluster map for any data with latitude/longitude columns 0 2018-04-19T15:31:55Z 2020-04-08T02:34:34Z 2020-04-08T02:35:04Z   35 12 12 JavaScript 1 1 1 1 0 3 0 0 7 Apache License 2.0 apache-2.0 ["datasette", "datasette-io", "datasette-plugin", "leafletjs"] 3 7 12 master {"admin": true, "push": true, "pull": true}     1 1 1 0 3 1    
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 2020-04-28T03:09:35Z 2019-08-05T11:45:29Z   87 17 17 JavaScript 1 1 1 1 0 2 0 0 12 Apache License 2.0 apache-2.0 ["datasette", "datasette-io", "datasette-plugin", "plugin", "react", "vega"] 2 12 17 master {"admin": true, "push": true, "pull": true}     1 1 1 0 2 1    
140912432 MDEwOlJlcG9zaXRvcnkxNDA5MTI0MzI= sqlite-utils simonw/sqlite-utils 0 simonw 9599 https://github.com/simonw/sqlite-utils Python CLI utility and library for manipulating SQLite databases 0 2018-07-14T03:21:46Z 2020-10-19T04:51:57Z 2020-10-19T04:51:55Z https://sqlite-utils.readthedocs.io/ 610 233 233 Python 1 1 1 1 0 15 0 0 25 Apache License 2.0 apache-2.0 ["cli", "click", "datasette", "datasette-io", "python", "sqlite", "sqlite-database"] 15 25 233 main {"admin": true, "push": true, "pull": true}     1 1 1 0 15 8    
166159072 MDEwOlJlcG9zaXRvcnkxNjYxNTkwNzI= db-to-sqlite simonw/db-to-sqlite 0 simonw 9599 https://github.com/simonw/db-to-sqlite CLI tool for exporting tables or queries from any SQL database to a SQLite file 0 2019-01-17T04:16:48Z 2020-04-18T00:03:50Z 2020-02-11T21:03:41Z   54 183 183 Python 1 1 1 1 0 6 0 0 4 Apache License 2.0 apache-2.0 ["datasette", "datasette-io", "sqlalchemy", "sqlite"] 6 4 183 master {"admin": true, "push": true, "pull": true}     1 1 1 0 6 4    
167759846 MDEwOlJlcG9zaXRvcnkxNjc3NTk4NDY= markdown-to-sqlite simonw/markdown-to-sqlite 0 simonw 9599 https://github.com/simonw/markdown-to-sqlite CLI tool for loading markdown files into a SQLite database 0 2019-01-27T02:04:54Z 2020-03-23T10:58:17Z 2019-01-27T02:39:13Z   7 16 16 Python 1 1 1 1 0 0 0 0 0 Apache License 2.0 apache-2.0 ["datasette-io", "markdown", "sqlite", "yaml"] 0 0 16 master {"admin": true, "push": true, "pull": true}     1 1 1 0 0 1    
168474970 MDEwOlJlcG9zaXRvcnkxNjg0NzQ5NzA= dbf-to-sqlite simonw/dbf-to-sqlite 0 simonw 9599 https://github.com/simonw/dbf-to-sqlite CLI tool for converting DBF files (dBase, FoxPro etc) to SQLite 0 2019-01-31T06:30:46Z 2020-02-23T03:14:31Z 2020-02-16T00:41:20Z   8 17 17 Python 1 1 1 1 0 2 0 0 2 Apache License 2.0 apache-2.0 ["datasette-io", "dbase", "dbf", "foxpro", "sqlite"] 2 2 17 master {"admin": true, "push": true, "pull": true}     1 1 1 0 2 2    
175550127 MDEwOlJlcG9zaXRvcnkxNzU1NTAxMjc= yaml-to-sqlite simonw/yaml-to-sqlite 0 simonw 9599 https://github.com/simonw/yaml-to-sqlite Utility for converting YAML files to SQLite 0 2019-03-14T04:49:08Z 2020-01-31T06:51:18Z 2019-12-26T16:21:52Z   11 14 14 Python 1 1 1 1 0 1 0 0 1 Apache License 2.0 apache-2.0 ["datasette-io", "sqlite", "yaml"] 1 1 14 master {"admin": true, "push": true, "pull": true}     1 1 1 0 1 2    
191292066 MDEwOlJlcG9zaXRvcnkxOTEyOTIwNjY= pge-outages simonw/pge-outages 0 simonw 9599 https://github.com/simonw/pge-outages Tracking PG&E outages 0 2019-06-11T04:12:45Z 2020-04-29T20:36:03Z 2020-02-14T12:10:25Z   40211 34 34 Python 1 1 1 1 0 7 0 0 1 Apache License 2.0 apache-2.0 ["git-scraping", "pge-outages", "power", "scraping"] 7 1 34 master {"admin": true, "push": true, "pull": true}     1 1 1 0 7 3    
195087137 MDEwOlJlcG9zaXRvcnkxOTUwODcxMzc= datasette-auth-github simonw/datasette-auth-github 0 simonw 9599 https://github.com/simonw/datasette-auth-github Datasette plugin and ASGI middleware that authenticates users against GitHub 0 2019-07-03T16:02:53Z 2020-04-15T02:02:45Z 2020-04-10T04:41:02Z   119 19 19 Python 1 1 1 1 0 4 0 0 6 Apache License 2.0 apache-2.0 ["asgi", "datasette", "datasette-io", "datasette-plugin"] 4 6 19 master {"admin": true, "push": true, "pull": true}     1 1 1 0 4 1    
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 2020-10-17T21:23:48Z 2020-10-17T21:23:27Z   44 46 46 Python 1 1 1 1 0 1 0 0 0 Apache License 2.0 apache-2.0 ["datasette", "datasette-io", "dogsheep", "healthkit", "sqlite"] 1 0 46 main {"admin": true, "push": true, "pull": true} dogsheep 53015001   1 1 1 0 1 1    
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 2020-10-12T20:31:27Z 2020-10-12T20:33:48Z   43 21 21 Python 1 1 1 1 0 1 0 0 1 Apache License 2.0 apache-2.0 ["datasette", "datasette-io", "dogsheep", "foursquare", "foursquare-api", "sqlite", "swarm"] 1 1 21 main {"admin": true, "push": true, "pull": true} dogsheep 53015001   1 1 1 0 1 2    
206156866 MDEwOlJlcG9zaXRvcnkyMDYxNTY4NjY= twitter-to-sqlite dogsheep/twitter-to-sqlite 0 dogsheep 53015001 https://github.com/dogsheep/twitter-to-sqlite Save data from Twitter to a SQLite database 0 2019-09-03T19:30:08Z 2020-10-17T18:55:50Z 2020-08-19T06:10:53Z   238 146 146 Python 1 1 1 1 0 6 0 0 7 Apache License 2.0 apache-2.0 ["datasette", "datasette-io", "dogsheep", "sqlite", "twitter", "twitter-api"] 6 7 146 master {"admin": true, "push": true, "pull": true} dogsheep 53015001   1 1 1 0 6 2    
206649770 MDEwOlJlcG9zaXRvcnkyMDY2NDk3NzA= google-takeout-to-sqlite dogsheep/google-takeout-to-sqlite 0 dogsheep 53015001 https://github.com/dogsheep/google-takeout-to-sqlite Save data from Google Takeout to a SQLite database 0 2019-09-05T20:15:15Z 2020-09-24T00:10:59Z 2019-09-08T03:13:55Z   14 26 26 Python 1 1 1 1 0 1 0 0 1 Apache License 2.0 apache-2.0 ["datasette", "datasette-io", "dogsheep", "google", "sqlite"] 1 1 26 master {"admin": true, "push": true, "pull": true} dogsheep 53015001   1 1 1 0 1 2    
207052882 MDEwOlJlcG9zaXRvcnkyMDcwNTI4ODI= github-to-sqlite dogsheep/github-to-sqlite 0 dogsheep 53015001 https://github.com/dogsheep/github-to-sqlite Save data from GitHub to a SQLite database 0 2019-09-08T02:50:28Z 2020-10-19T05:36:35Z 2020-10-19T05:38:34Z https://github-to-sqlite.dogsheep.net/ 133 66 66 Python 1 1 1 1 0 6 0 0 7 Apache License 2.0 apache-2.0 ["datasette", "datasette-io", "dogsheep", "github-api", "sqlite"] 6 7 66 main {"admin": true, "push": true, "pull": true} dogsheep 53015001   1 1 1 0 6 2    
213286752 MDEwOlJlcG9zaXRvcnkyMTMyODY3NTI= pocket-to-sqlite dogsheep/pocket-to-sqlite 0 dogsheep 53015001 https://github.com/dogsheep/pocket-to-sqlite Create a SQLite database containing data from your Pocket account 0 2019-10-07T03:24:14Z 2020-10-19T12:16:31Z 2020-03-27T22:26:30Z   16 21 21 Python 1 1 1 1 0 1 0 0 3 Apache License 2.0 apache-2.0 ["datasette", "datasette-io", "dogsheep", "pocket", "pocket-api", "sqlite"] 1 3 21 master {"admin": true, "push": true, "pull": true} dogsheep 53015001   1 1 1 0 1 3    
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 2020-04-27T17:57:29Z 2020-02-17T01:12:59Z   42 12 12 Python 1 1 1 1 0 1 0 0 4 Apache License 2.0 apache-2.0 ["datasette-io", "geojson", "gis", "sqlite"] 1 4 12 master {"admin": true, "push": true, "pull": true}     1 1 1 0 1 1    
246929362 MDEwOlJlcG9zaXRvcnkyNDY5MjkzNjI= covid19-dashboard github/covid19-dashboard 0 github 9919 https://github.com/github/covid19-dashboard A site that displays up to date COVID-19 stats, powered by fastpages. 0 2020-03-12T20:55:50Z 2020-07-29T21:49:27Z 2020-07-29T18:21:15Z https://covid19dashboards.com 739654 1057 1057 Jupyter Notebook 1 1 1 1 1 331 0 0 0 Apache License 2.0 apache-2.0 ["altair", "analytics", "covid-19", "covid-data", "covid19", "data-science", "data-visualisation", "fastai", "fastpages", "github-actions", "github-pages", "jupyter", "matplotlib", "nteract", "papermill", "pymc3", "python"] 331 0 1057 master {"admin": false, "push": false, "pull": true} github 9919           331 154    
248903544 MDEwOlJlcG9zaXRvcnkyNDg5MDM1NDQ= hacker-news-to-sqlite dogsheep/hacker-news-to-sqlite 0 dogsheep 53015001 https://github.com/dogsheep/hacker-news-to-sqlite Create a SQLite database containing data pulled from Hacker News 0 2020-03-21T04:02:05Z 2020-10-17T18:55:36Z 2020-03-22T15:44:51Z   16 16 16 Python 1 1 1 1 0 1 0 0 0 Apache License 2.0 apache-2.0 ["datasette", "datasette-io", "dogsheep", "hacker-news"] 1 0 16 master {"admin": true, "push": true, "pull": true} dogsheep 53015001   1 1 1 0 1 1    
256834907 MDEwOlJlcG9zaXRvcnkyNTY4MzQ5MDc= dogsheep-photos dogsheep/dogsheep-photos 0 dogsheep 53015001 https://github.com/dogsheep/dogsheep-photos Upload your photos to S3 and import metadata about them into a SQLite database 0 2020-04-18T19:22:13Z 2020-10-10T23:24:24Z 2020-07-13T16:15:27Z   64 74 74 Python 1 1 1 1 0 2 0 0 14 Apache License 2.0 apache-2.0 ["datasette", "datasette-io", "dogsheep", "sqlite"] 2 14 74 master {"admin": true, "push": true, "pull": true} dogsheep 53015001   1 1 1 0 2 7    

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,
   [topics] TEXT,
   [forks] INTEGER,
   [open_issues] INTEGER,
   [watchers] INTEGER,
   [default_branch] TEXT,
   [permissions] TEXT,
   [organization] INTEGER REFERENCES [users]([id]), [temp_clone_token] TEXT, [allow_squash_merge] INTEGER, [allow_merge_commit] INTEGER, [allow_rebase_merge] INTEGER, [delete_branch_on_merge] INTEGER, [network_count] INTEGER, [subscribers_count] INTEGER, [parent] TEXT, [source] TEXT,
   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]);
Powered by Datasette · Query took 111.091ms · About: simonw/datasette-graphql