🔭 Two summers of one researcher — across BOTH datasets

SELECT ?year ?month ?repo (COUNT(*) AS ?events) (COUNT(DI…
WHERE {
  ?ev prov:wasAssociatedWith <https://github.com/caviri> ;
      a ?type ; gh:repo ?repo ; prov:atTime ?t .
  BIND(year(?t) AS ?year) BIND(month(?t) AS ?month)
} GROUP BY ?year ?month ?repo ORDER BY ?year DESC(?events…

Run this query → no server · no download · no account

caviri.github.io/rete

Run this query in the playground → no server, no download — the query runs in your browser.

The query

PREFIX gh: <https://w3id.org/rete/gharchive#> PREFIX prov: <http://www.w3.org/ns/prov#> SELECT ?year ?month ?repo (COUNT(*) AS ?events) (COUNT(DISTINCT ?type) AS ?kinds) WHERE { ?ev prov:wasAssociatedWith <https://github.com/caviri> ; a ?type ; gh:repo ?repo ; prov:atTime ?t . BIND(year(?t) AS ?year) BIND(month(?t) AS ?month) } GROUP BY ?year ?month ?repo ORDER BY ?year DESC(?events) LIMIT 50

rete playground · documentation · github.com/caviri/rete