13 rows where owner = 53015001

View and edit SQL

Suggested facets: homepage, size, has_projects, has_wiki, has_pages, forks_count, open_issues_count, forks, open_issues, default_branch, 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 allow_forking topics forks open_issues watchers default_branch organization
197431109 MDEwOlJlcG9zaXRvcnkxOTc0MzExMDk= dogsheep-beta dogsheep/dogsheep-beta 0 dogsheep 53015001 https://github.com/dogsheep/dogsheep-beta Build a search index across content from multiple SQLite database tables and run faceted searches against it using Datasette 0 2019-07-17T17:07:26Z 2021-09-19T08:58:53Z 2021-09-03T17:47:45Z https://dogsheep.github.io/ 61 109 109 Python 1 0 1 0 0 3 0 0 13   1 ["datasette", "datasette-io", "datasette-plugin", "datasette-tool", "dogsheep", "search"] 3 13 109 main  
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 2021-09-17T14:16:47Z 2021-08-24T13:13:39Z https://datasette.io/tools/healthkit-to-sqlite 29 106 106 Python 1 1 1 1 0 5 0 0 10 Apache License 2.0 apache-2.0 1 ["datasette", "datasette-io", "datasette-tool", "dogsheep", "healthkit", "sqlite"] 5 10 106 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 2021-09-09T23:46:31Z 2021-01-18T04:36:03Z   49 41 41 Python 1 1 1 1 0 1 0 0 2 Apache License 2.0 apache-2.0 1 ["datasette", "datasette-io", "datasette-tool", "dogsheep", "foursquare", "foursquare-api", "sqlite", "swarm"] 1 2 41 main  
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 2021-09-21T18:02:30Z 2021-09-21T17:41:05Z   298 253 253 Python 1 1 1 1 0 12 0 0 7 Apache License 2.0 apache-2.0 1 ["datasette", "datasette-io", "datasette-tool", "dogsheep", "sqlite", "twitter", "twitter-api"] 12 7 253 main  
206202864 MDEwOlJlcG9zaXRvcnkyMDYyMDI4NjQ= inaturalist-to-sqlite dogsheep/inaturalist-to-sqlite 0 dogsheep 53015001 https://github.com/dogsheep/inaturalist-to-sqlite Create a SQLite database containing your observation history from iNaturalist 0 2019-09-04T01:21:21Z 2021-07-28T05:39:02Z 2020-10-22T00:08:58Z   17 4 4 Python 1 1 1 1 0 0 0 0 0 Apache License 2.0 apache-2.0 1 ["datasette", "datasette-io", "datasette-tool", "dogsheep", "inaturalist", "sqlite"] 0 0 4 master  
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 2021-08-17T10:39:00Z 2021-08-10T23:26:32Z   14 58 58 Python 1 1 1 1 0 5 0 0 8 Apache License 2.0 apache-2.0 1 ["datasette", "datasette-io", "datasette-tool", "dogsheep", "google", "sqlite"] 5 8 58 master  
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 2021-09-19T23:16:25Z 2021-08-28T01:26:41Z https://github-to-sqlite.dogsheep.net/ 253 153 153 Python 1 1 1 1 0 21 0 0 14 Apache License 2.0 apache-2.0 1 ["datasette", "datasette-io", "datasette-tool", "dogsheep", "github-api", "sqlite"] 21 14 153 main  
209590345 MDEwOlJlcG9zaXRvcnkyMDk1OTAzNDU= genome-to-sqlite dogsheep/genome-to-sqlite 0 dogsheep 53015001 https://github.com/dogsheep/genome-to-sqlite Import your genome into a SQLite database 0 2019-09-19T15:38:39Z 2021-07-29T07:34:46Z 2019-09-19T15:41:17Z   9 14 14 Python 1 1 1 1 0 0 0 0 2 Apache License 2.0 apache-2.0 1 ["23andme", "datasette", "datasette-io", "datasette-tool", "dogsheep", "genetics", "personal-analytics", "sqlite"] 0 2 14 master  
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 2021-09-09T14:29:02Z 2020-11-24T23:25:14Z   17 53 53 Python 1 1 1 1 0 3 0 0 6 Apache License 2.0 apache-2.0 1 ["datasette", "datasette-io", "datasette-tool", "dogsheep", "pocket", "pocket-api", "sqlite"] 3 6 53 master  
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 2021-09-19T23:48:18Z 2021-06-19T12:26:16Z https://dogsheep.github.io/ 16 99 99   1 1 1 1 1 6 0 0 5   1 ["datasette", "dogsheep", "sqlite"] 6 5 99 master  
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 2021-08-10T13:22:28Z 2021-03-13T19:15:06Z   19 30 30 Python 1 1 1 1 0 3 0 0 2 Apache License 2.0 apache-2.0 1 ["datasette", "datasette-io", "datasette-tool", "dogsheep", "hacker-news"] 3 2 30 main  
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 2021-09-18T05:29:37Z 2021-09-05T12:05:40Z   64 121 121 Python 1 1 1 1 0 6 0 0 19 Apache License 2.0 apache-2.0 1 ["datasette", "datasette-io", "datasette-tool", "dogsheep", "sqlite"] 6 19 121 master  
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 2021-08-31T18:07:38Z 2021-08-26T19:02:47Z   51 26 26 Python 1 1 1 1 0 4 0 0 4 Apache License 2.0 apache-2.0 1 ["datasette-io", "datasette-tool", "dogsheep", "evernote", "sqlite"] 4 4 26 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]);