softwareheritage-indexer=#

select
  origin.url,
  metadata->'name' as name,
  metadata->'description' as description,
  metadata->'keywords' as tags
from origin_intrinsic_metadata
join origin on origin_id = origin.id
limit 10;

                           url                           |            name            |                                                                                         description                                                                                         |                 tags                  
---------------------------------------------------------+----------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------
 https://github.com/archerbj/angular2-webpack-starter    | "angular2-webpack-starter" | "An Angular 2 Webpack Starter kit featuring Angular 2 (Router, Http, Forms, Services, Tests, E2E, Coverage), Karma, Protractor, Jasmine, Istanbul, TypeScript, and Webpack by AngularClass" | ["angular2", "webpack", "typescript"]
 https://github.com/mmalolepszy/angular2-webpack-starter | "angular2-webpack-starter" | "An Angular 2 Webpack Starter kit featuring Angular 2 (Router, Http, Forms, Services, Tests, E2E, Coverage), Karma, Protractor, Jasmine, Istanbul, TypeScript, and Webpack by AngularClass" | ["angular2", "webpack", "typescript"]
 https://github.com/jennet/angular2-webpack-starter      | "angular2-webpack-starter" | "An Angular 2 Webpack Starter kit featuring Angular 2 (Router, Http, Forms, Services, Tests, E2E, Coverage), Karma, Protractor, Jasmine, Istanbul, TypeScript, and Webpack by AngularClass" | ["angular2", "webpack", "typescript"]
 https://github.com/kisskie/angular2-webpack-starter     | "angular2-webpack-starter" | "An Angular 2 Webpack Starter kit featuring Angular 2 (Router, Http, Forms, Services, Tests, E2E, Coverage), Karma, Protractor, Jasmine, Istanbul, TypeScript, and Webpack by AngularClass" | ["angular2", "webpack", "typescript"]
 https://github.com/doloris-ukr/testRepository           |                            |                                                                                                                                                                                             | 
 https://github.com/JonathanMH/jmh_wc                    |                            |                                                                                                                                                                                             | 
 https://github.com/peel3r/angular2-webpack-starter      | "angular2-webpack-starter" | "An Angular 2 Webpack Starter kit featuring Angular 2 (Router, Http, Forms, Services, Tests, E2E, Coverage), Karma, Protractor, Jasmine, Istanbul, TypeScript, and Webpack by AngularClass" | ["angular2", "webpack", "typescript"]
 https://github.com/benbjohnson/go-raft-runner           |                            |                                                                                                                                                                                             | 
 https://github.com/z0mt3c/IconicDroid                   | "IconicDroid (Parent)"     | "IconicDroid is a custom Android Drawable which allows to draw icons from several iconic fonts."                                                                                            | 
 https://github.com/mimoccc/IconicDroid                  | "IconicDroid (Parent)"     | "IconicDroid is a custom Android Drawable which allows to draw icons from several iconic fonts."                                                                                            | 
(10 rows)
