repos
117 rows where forks = 0 sorted by license descending
This data as json, CSV (advanced)
created_at (date) >30 ✖
- 2020-09-28 2
- 2021-08-28 2
- 2020-09-11 1
- 2020-10-06 1
- 2020-10-11 1
- 2020-10-31 1
- 2020-11-15 1
- 2021-01-08 1
- 2021-02-02 1
- 2021-02-25 1
- 2021-03-28 1
- 2021-06-10 1
- 2021-08-08 1
- 2021-08-11 1
- 2021-09-23 1
- 2021-10-21 1
- 2021-11-01 1
- 2021-11-06 1
- 2021-11-20 1
- 2021-11-28 1
- 2021-12-02 1
- 2022-02-25 1
- 2022-05-25 1
- 2022-07-31 1
- 2022-08-20 1
- 2022-09-03 1
- 2023-01-12 1
- 2023-07-24 1
- 2023-08-11 1
- 2023-08-12 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
294706267 | MDEwOlJlcG9zaXRvcnkyOTQ3MDYyNjc= | datasette-seaborn | simonw/datasette-seaborn | 0 | simonw 9599 | https://github.com/simonw/datasette-seaborn | Statistical visualizations for Datasette using Seaborn | 0 | 2020-09-11T13:43:08Z | 2024-01-04T16:50:11Z | 2022-03-22T01:49:36Z | https://datasette-seaborn-demo.datasette.io/ | 26 | 11 | 11 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 5 | 1 | 0 | 0 | ["datasette", "datasette-io", "datasette-plugin", "seaborn", "visualization"] | public | 0 | 5 | 11 | main | ||
299143849 | MDEwOlJlcG9zaXRvcnkyOTkxNDM4NDk= | datasette-dateutil | simonw/datasette-dateutil | 0 | simonw 9599 | https://github.com/simonw/datasette-dateutil | dateutil functions for Datasette | 0 | 2020-09-28T00:14:20Z | 2023-01-21T21:38:29Z | 2022-03-01T01:40:21Z | 18 | 7 | 7 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 0 | 0 | ["datasette", "datasette-io", "datasette-plugin", "dateutil"] | public | 0 | 2 | 7 | main | |||
299198369 | MDEwOlJlcG9zaXRvcnkyOTkxOTgzNjk= | datasette-import-table | simonw/datasette-import-table | 0 | simonw 9599 | https://github.com/simonw/datasette-import-table | Datasette plugin for importing tables from other Datasette instances | 0 | 2020-09-28T05:30:07Z | 2022-06-09T15:27:33Z | 2022-11-18T06:30:26Z | 22 | 0 | 0 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 0 | 0 | ["datasette", "datasette-io", "datasette-plugin"] | public | 0 | 2 | 0 | main | |||
301879297 | MDEwOlJlcG9zaXRvcnkzMDE4NzkyOTc= | buildpack-datasette | simonw/buildpack-datasette | 0 | simonw 9599 | https://github.com/simonw/buildpack-datasette | Repository template for creating a new Datasette buildpack instance | 0 | 2020-10-06T23:31:39Z | 2021-03-12T00:21:17Z | 2020-12-18T02:31:46Z | https://docs.datasette.io/en/stable/deploying.html#deploying-using-buildpacks | 48 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | ["buildpacks", "datasette"] | public | 0 | 0 | 1 | main | |||
303184040 | MDEwOlJlcG9zaXRvcnkzMDMxODQwNDA= | datasette-json-preview | simonw/datasette-json-preview | 0 | simonw 9599 | https://github.com/simonw/datasette-json-preview | Preview of new JSON default format for Datasette | 0 | 2020-10-11T18:15:24Z | 2021-02-20T20:26:42Z | 2021-02-20T20:26:41Z | https://github.com/simonw/datasette/issues/782 | 9 | 1 | 1 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 0 | 0 | ["datasette"] | public | 0 | 2 | 1 | main | ||
308930118 | MDEwOlJlcG9zaXRvcnkzMDg5MzAxMTg= | datasette-edit-templates | simonw/datasette-edit-templates | 0 | simonw 9599 | https://github.com/simonw/datasette-edit-templates | Plugin allowing Datasette templates to be edited within Datasette | 0 | 2020-10-31T16:58:29Z | 2023-03-01T23:30:04Z | 2024-01-17T00:39:07Z | 103 | 2 | 2 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 3 | 1 | 0 | 0 | [] | public | 0 | 3 | 2 | main | |||
312934001 | MDEwOlJlcG9zaXRvcnkzMTI5MzQwMDE= | datasette-indieauth | simonw/datasette-indieauth | 0 | simonw 9599 | https://github.com/simonw/datasette-indieauth | Datasette authentication using IndieAuth and RelMeAuth | 0 | 2020-11-15T01:18:21Z | 2022-10-25T01:00:43Z | 2022-11-18T06:48:02Z | 55 | 8 | 8 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | ["datasette", "datasette-io", "datasette-plugin", "indieauth"] | public | 0 | 1 | 8 | main | |||
327957983 | MDEwOlJlcG9zaXRvcnkzMjc5NTc5ODM= | cbsa-datasette | simonw/cbsa-datasette | 0 | simonw 9599 | https://github.com/simonw/cbsa-datasette | Using Datasette to provide an API for Core Based Statistical Areas | 0 | 2021-01-08T16:40:25Z | 2022-03-22T01:55:14Z | 2023-01-09T20:56:39Z | https://cbsa.datasettes.com | 19 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | ["datasette"] | public | 0 | 0 | 0 | main | |||
335137108 | MDEwOlJlcG9zaXRvcnkzMzUxMzcxMDg= | datasette-basemap | simonw/datasette-basemap | 0 | simonw 9599 | https://github.com/simonw/datasette-basemap | A basemap for Datasette and datasette-leaflet | 0 | 2021-02-02T01:49:09Z | 2022-06-01T04:32:03Z | 2021-02-03T21:56:18Z | https://datasette.io/plugins/datasette-basemap | 43 | 2 | 2 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | ["datasette", "datasette-io", "datasette-plugin", "mbtiles", "openstreetmap"] | public | 0 | 0 | 2 | main | ||
342126610 | MDEwOlJlcG9zaXRvcnkzNDIxMjY2MTA= | datasette-block | simonw/datasette-block | 0 | simonw 9599 | https://github.com/simonw/datasette-block | Block all access to specific path prefixes | 0 | 2021-02-25T04:51:08Z | 2021-02-25T08:18:28Z | 2021-02-25T05:03:45Z | https://datasette.io/plugins/datasette-block | 4 | 1 | 1 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | ["datasette", "datasette-io", "datasette-plugin"] | public | 0 | 0 | 1 | main | ||
352249703 | MDEwOlJlcG9zaXRvcnkzNTIyNDk3MDM= | datasette-publish-azure | simonw/datasette-publish-azure | 0 | simonw 9599 | https://github.com/simonw/datasette-publish-azure | Publish Datasette instances to Azure Functions (in progress) | 0 | 2021-03-28T05:35:15Z | 2021-04-17T19:01:07Z | 2021-03-28T05:36:41Z | 3 | 1 | 1 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | [] | public | 0 | 0 | 1 | main | |||
375546675 | MDEwOlJlcG9zaXRvcnkzNzU1NDY2NzU= | datasette-placekey | simonw/datasette-placekey | 0 | simonw 9599 | https://github.com/simonw/datasette-placekey | SQL functions for working with placekeys | 0 | 2021-06-10T02:31:27Z | 2021-06-22T22:13:18Z | 2021-06-10T02:32:42Z | https://datasette.io/plugins/datasette-placekey | 3 | 1 | 1 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | ["datasette", "datasette-io", "datasette-plugin", "placekey"] | public | 0 | 1 | 1 | main | ||
393999598 | MDEwOlJlcG9zaXRvcnkzOTM5OTk1OTg= | datasette-pyinstrument | simonw/datasette-pyinstrument | 0 | simonw 9599 | https://github.com/simonw/datasette-pyinstrument | Use pyinstrument to analyze Datasette page performance | 0 | 2021-08-08T15:33:29Z | 2022-04-27T15:06:42Z | 2021-08-08T15:50:52Z | 5 | 2 | 2 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | [] | public | 0 | 0 | 2 | main | |||
395137513 | MDEwOlJlcG9zaXRvcnkzOTUxMzc1MTM= | datasette-x-forwarded-host | simonw/datasette-x-forwarded-host | 0 | simonw 9599 | https://github.com/simonw/datasette-x-forwarded-host | Treat the X-Forwarded-Host header as the Host header | 0 | 2021-08-11T23:10:44Z | 2022-04-27T15:06:31Z | 2021-11-12T20:48:41Z | 4 | 1 | 1 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | ["datasette-io", "datasette-plugin"] | public | 0 | 0 | 1 | main | |||
400678317 | MDEwOlJlcG9zaXRvcnk0MDA2NzgzMTc= | datasette-verify | simonw/datasette-verify | 0 | simonw 9599 | https://github.com/simonw/datasette-verify | Verify that files can be opened by Datasette | 0 | 2021-08-28T01:59:12Z | 2021-09-07T22:56:11Z | 2021-08-28T02:31:34Z | https://datasette.io/tools/datasette-verify | 3 | 2 | 2 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | ["datasette", "datasette-io", "datasette-plugin"] | public | 0 | 0 | 2 | main | ||
400878073 | MDEwOlJlcG9zaXRvcnk0MDA4NzgwNzM= | datasette-plugin-template-repository | simonw/datasette-plugin-template-repository | 0 | simonw 9599 | https://github.com/simonw/datasette-plugin-template-repository | GitHub template repository for creating new Datasette plugins, using the simonw/datasette-plugin cookiecutter template | 0 | 2021-08-28T19:50:28Z | 2024-01-15T10:21:01Z | 2023-03-14T04:34:37Z | 11 | 23 | 23 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | [] | public | 0 | 0 | 23 | main | ||||
409678203 | R_kgDOGGsxew | datasette-template-request | simonw/datasette-template-request | 0 | simonw 9599 | https://github.com/simonw/datasette-template-request | Expose the Datasette request object to custom templates | 0 | 2021-09-23T17:07:00Z | 2022-02-01T17:06:52Z | 2021-09-23T17:29:36Z | https://datasette.io/plugins/datasette-template-request | 6 | 1 | 1 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | ["datasette", "datasette-io", "datasette-plugin"] | public | 0 | 0 | 1 | main | ||
419525110 | R_kgDOGQFx9g | datasette-hello-world | simonw/datasette-hello-world | 0 | simonw 9599 | https://github.com/simonw/datasette-hello-world | The hello world of Datasette plugins | 0 | 2021-10-21T00:01:35Z | 2021-11-14T04:58:05Z | 2021-11-14T04:58:36Z | 8 | 0 | 0 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | [] | public | 0 | 0 | 0 | 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 | |||
425143660 | R_kgDOGVctbA | iam-definitions-datasette | simonw/iam-definitions-datasette | 0 | simonw 9599 | https://github.com/simonw/iam-definitions-datasette | IAM definitions published using Datasette | 0 | 2021-11-06T03:09:30Z | 2022-04-22T12:27:51Z | 2021-11-06T03:44:17Z | https://iam-definitions.vercel.app/ | 5 | 3 | 3 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | ["datasette", "iam"] | public | 0 | 1 | 3 | main | ||
430224716 | R_kgDOGaS1TA | datasette-redirect-to-https | simonw/datasette-redirect-to-https | 0 | simonw 9599 | https://github.com/simonw/datasette-redirect-to-https | Datasette plugin that redirects all non-https requests to https | 0 | 2021-11-20T22:43:33Z | 2022-04-24T03:48:01Z | 2022-07-07T17:38:32Z | 12 | 1 | 1 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | ["asgi", "datasette", "datasette-io", "datasette-plugin"] | public | 0 | 0 | 1 | main | |||
432792661 | R_kgDOGcvkVQ | datasette-table | simonw/datasette-table | 0 | simonw 9599 | https://github.com/simonw/datasette-table | A Web Component for embedding a Datasette table on a page | 0 | 2021-11-28T18:28:31Z | 2024-01-07T09:25:13Z | 2022-07-13T15:53:43Z | https://simonw.github.io/datasette-table/ | 7 | 27 | 27 | JavaScript | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | ["datasette", "web-components"] | public | 0 | 1 | 27 | main | ||
434308974 | R_kgDOGeMHbg | datasette-hovercards | simonw/datasette-hovercards | 0 | simonw 9599 | https://github.com/simonw/datasette-hovercards | Add preview hovercards to links in Datasette | 0 | 2021-12-02T17:11:59Z | 2022-04-27T15:06:11Z | 2021-12-02T19:57:32Z | 8 | 3 | 3 | JavaScript | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | [] | public | 0 | 1 | 3 | main | |||
463623833 | R_kgDOG6JWmQ | congress-legislators-datasette | simonw/congress-legislators-datasette | 0 | simonw 9599 | https://github.com/simonw/congress-legislators-datasette | Datasette instance with data from unitedstates/congress-legislators | 0 | 2022-02-25T17:42:08Z | 2023-12-30T07:55:21Z | 2022-12-06T18:45:05Z | https://congress-legislators.datasettes.com/ | 11 | 3 | 3 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | [] | public | 0 | 0 | 3 | main | ||
496273000 | R_kgDOHZSGaA | datasette-unsafe-expose-env | simonw/datasette-unsafe-expose-env | 0 | simonw 9599 | https://github.com/simonw/datasette-unsafe-expose-env | Datasette plugin to expose some environment variables at /-/env for debugging | 0 | 2022-05-25T14:46:03Z | 2023-01-27T23:22:47Z | 2022-07-03T21:42:37Z | 6 | 1 | 1 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | [] | public | 0 | 0 | 1 | main | |||
519842266 | R_kgDOHvwp2g | manatees-datasette | simonw/manatees-datasette | 0 | simonw 9599 | https://github.com/simonw/manatees-datasette | Datasette demo showing manatee carcass recovery locations | 0 | 2022-07-31T17:25:43Z | 2022-07-31T17:39:21Z | 2022-07-31T18:05:39Z | https://manatees.vercel.app/manatees/locations | 546 | 0 | 0 | Shell | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | [] | public | 0 | 0 | 0 | main | ||
527045109 | R_kgDOH2oR9Q | scotrail-datasette | simonw/scotrail-datasette | 0 | simonw 9599 | https://github.com/simonw/scotrail-datasette | ScotRail announcements in Datasette | 0 | 2022-08-20T21:37:29Z | 2023-11-03T01:24:18Z | 2022-08-21T20:53:05Z | https://scotrail.datasette.io | 50 | 6 | 6 | Shell | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | ["scotrail"] | public | 0 | 0 | 6 | main | ||
532144482 | R_kgDOH7fhYg | pldb-datasette | simonw/pldb-datasette | 0 | simonw 9599 | https://github.com/simonw/pldb-datasette | A Datasette instance for pldb.com | 0 | 2022-09-03T03:29:46Z | 2023-02-02T14:31:07Z | 2022-09-03T03:57:14Z | 4 | 2 | 2 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | [] | public | 0 | 0 | 2 | main | ||||
587971415 | R_kgDOIwu7Vw | datasette-sql-strip-tags | simonw/datasette-sql-strip-tags | 0 | simonw 9599 | https://github.com/simonw/datasette-sql-strip-tags | Adds a simple SQL function for stripping XML-style tags | 0 | 2023-01-12T02:29:38Z | 2023-01-15T15:34:51Z | 2023-01-12T02:29:40Z | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | [] | public | 0 | 0 | 1 | main | ||||
669958782 | R_kgDOJ-7Cfg | sqlite-utils-plugin | simonw/sqlite-utils-plugin | 0 | simonw 9599 | https://github.com/simonw/sqlite-utils-plugin | A cookiecutter template for building plugins for sqlite-utils | 0 | 2023-07-24T01:19:08Z | 2023-07-25T03:36:00Z | 2023-07-25T20:39:30Z | 12 | 3 | 3 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | [] | public | 0 | 0 | 3 | main | |||
677187897 | R_kgDOKF0ROQ | sqlite-utils-jq | simonw/sqlite-utils-jq | 0 | simonw 9599 | https://github.com/simonw/sqlite-utils-jq | Plugin adding a jq() SQL function to sqlite-utils | 0 | 2023-08-11T00:45:35Z | 2023-12-31T15:57:19Z | 2023-08-11T00:53:58Z | 3 | 8 | 8 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | [] | public | 0 | 0 | 8 | main | |||
677869915 | R_kgDOKGd5Ww | datasette-llm | simonw/datasette-llm | 0 | simonw 9599 | https://github.com/simonw/datasette-llm | Datasette plugin for interacting with Large Language Models using LLM | 0 | 2023-08-12T23:16:33Z | 2023-12-24T13:37:29Z | 2023-08-13T18:19:37Z | 178 | 8 | 8 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 0 | 0 | [] | public | 0 | 2 | 8 | main | |||
680224318 | R_kgDOKItmPg | sqlite-utils-fast-fks | simonw/sqlite-utils-fast-fks | 0 | simonw 9599 | https://github.com/simonw/sqlite-utils-fast-fks | Fast foreign key addition for sqlite-utils | 0 | 2023-08-18T16:41:23Z | 2023-08-20T01:15:50Z | 2023-08-18T17:00:42Z | 8 | 3 | 3 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | [] | public | 0 | 0 | 3 | main | |||
689860422 | R_kgDOKR5vRg | sqlite-chronicle | simonw/sqlite-chronicle | 0 | simonw 9599 | https://github.com/simonw/sqlite-chronicle | Use triggers to track when rows in a SQLite table were updated or deleted | 0 | 2023-09-11T04:05:33Z | 2024-01-07T09:14:26Z | 2023-12-06T05:20:19Z | 27 | 24 | 24 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 3 | 1 | 0 | 0 | [] | public | 0 | 3 | 24 | main | |||
694371833 | R_kgDOKWNF-Q | sqlite-authorizer-examples | simonw/sqlite-authorizer-examples | 0 | simonw 9599 | https://github.com/simonw/sqlite-authorizer-examples | Examples of actions checked by the SQLite authorizer mechanism | 0 | 2023-09-20T21:42:26Z | 2023-09-21T00:44:42Z | 2023-09-21T17:03:01Z | 11 | 2 | 2 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | [] | public | 0 | 0 | 2 | main | |||
697938018 | R_kgDOKZmwYg | federal-register-to-datasette | simonw/federal-register-to-datasette | 0 | simonw 9599 | https://github.com/simonw/federal-register-to-datasette | 0 | 2023-09-28T19:34:17Z | 2023-11-14T07:49:54Z | 2023-10-27T05:11:38Z | 5 | 2 | 2 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | [] | public | 0 | 0 | 2 | main |
Advanced export
JSON shape: default, array, newline-delimited, object
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]);