repos

14 rows where owner = 53015001

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: homepage, 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 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
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 2024-01-25T12:20:58Z 2021-09-03T17:47:45Z https://dogsheep.github.io/ 61 176 176 Python 1 0 1 0 0 0 6 0 0 15   1 0 0 ["datasette", "datasette-io", "datasette-plugin", "datasette-tool", "dogsheep", "search"] public 6 15 176 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 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  
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  
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 2024-01-14T00:00:20Z 2022-12-28T23:33:31Z   307 391 391 Python 1 1 1 1 0 0 22 0 0 20 Apache License 2.0 apache-2.0 1 0 0 ["datasette", "datasette-io", "datasette-tool", "dogsheep", "sqlite", "twitter", "twitter-api"] public 22 20 391 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 2023-06-08T10:00:25Z 2020-10-22T00:08:58Z   17 6 6 Python 1 1 1 1 0 0 0 0 0 2 Apache License 2.0 apache-2.0 1 0 0 ["datasette", "datasette-io", "datasette-tool", "dogsheep", "inaturalist", "sqlite"] public 0 2 6 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 2024-01-22T12:33:23Z 2023-09-06T17:59:16Z   14 87 87 Python 1 1 1 1 0 0 8 0 0 13 Apache License 2.0 apache-2.0 1 0 0 ["datasette", "datasette-io", "datasette-tool", "dogsheep", "google", "sqlite"] public 8 13 87 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 2024-01-24T01:41:51Z 2024-01-15T05:56:13Z https://github-to-sqlite.dogsheep.net/ 143 363 363 Python 1 1 1 1 0 0 41 0 0 25 Apache License 2.0 apache-2.0 1 0 0 ["datasette", "datasette-io", "datasette-tool", "dogsheep", "github-api", "sqlite"] public 41 25 363 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 2023-10-07T13:11:49Z 2019-09-19T15:41:17Z   9 20 20 Python 1 1 1 1 0 0 1 0 0 2 Apache License 2.0 apache-2.0 1 0 0 ["23andme", "datasette", "datasette-io", "datasette-tool", "dogsheep", "genetics", "personal-analytics", "sqlite"] public 1 2 20 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 2024-01-15T17:53:41Z 2023-07-10T19:24:26Z   25 98 98 Python 1 1 1 1 0 0 5 0 0 5 Apache License 2.0 apache-2.0 1 0 0 ["datasette", "datasette-io", "datasette-tool", "dogsheep", "pocket", "pocket-api", "sqlite"] public 5 5 98 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  
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 2023-08-06T05:38:49Z 2023-03-26T22:22:39Z   19 43 43 Python 1 1 1 1 0 0 5 0 0 5 Apache License 2.0 apache-2.0 1 0 0 ["datasette", "datasette-io", "datasette-tool", "dogsheep", "hacker-news"] public 5 5 43 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 2024-01-22T12:00:59Z 2024-01-05T18:52:26Z   68 169 169 Python 1 1 1 1 0 0 15 0 0 22 Apache License 2.0 apache-2.0 1 0 0 ["datasette", "datasette-io", "datasette-tool", "dogsheep", "sqlite"] public 15 22 169 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 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  
611552758 R_kgDOJHON9g apple-notes-to-sqlite dogsheep/apple-notes-to-sqlite 0 dogsheep 53015001 https://github.com/dogsheep/apple-notes-to-sqlite Export Apple Notes to SQLite 0 2023-03-09T03:44:10Z 2024-01-25T08:38:14Z 2023-09-04T23:48:28Z   21 161 161 Python 1 1 1 1 0 0 5 0 0 8 Apache License 2.0 apache-2.0 1 0 0 ["apple-notes", "datasette", "datasette-tool", "dogsheep", "sqlite"] public 5 8 161 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]);