OpenRefine Community Metrics

Every year, I need to compile metrics regarding OpenRefine community, either for presentation or grant submission. Every year, I have to go back and check what I did and how I got those number. This year will be the last. Here are the metrics I track, and how I compile them. 

Slide from a presentation from August 2020


1. Number of downloads per release

The following curl command returns the stats for each package. To know the total download for a release you need to add the windows, mac and linux package. 

 curl -i  https://api.github.com/repos/openrefine/openrefine/releases -H "Accept: application/vnd.github.manifold-preview+json"

The number of downloads is not publicly available starting OpenRefine 3.6.0 - see discussion

2. Number of contributors on Github 

Now that OpenRefine documentation is also hosted in the same repo the count includes code contributor, translator and edit to OpenRefine documentation. 

From this URL, update the start and end date of your period of analysis in the URL: https://github.com/OpenRefine/OpenRefine/graphs/contributors?from=2021-01-01&to=2022-01-01&type=c

In your browser do ctrl +F  and search using the keyword commit. Subtract 4 to that result (excluding dependabot)

3. Number of Pull Requests and Issues

First search all all the PR here https://github.com/OpenRefine/OpenRefine/pulls using 

is:pr created:>2021-01-01

Then count how many are from dependabot so we can subtract them. 

is:pr created:>2021-01-01 involves:dependabot 

Do the same things from the Issue tab. 

Note that I was not able to do a time period using GitHub search parameters, so it is county everything up to today. 

4. Number of stars and forks on GitHub

From this page https://github.com/OpenRefine/OpenRefine 

5. Number of users on the mailing list 

You need to be an admin on the mailing list.
You can get the number of message between two date by using after:2021-01-01  before:2022-01-01
 search parameters from the discussion home page: https://groups.google.com/g/openrefine/
6. Traffic on the GitHub main project 

You need to be admin to see the page https://github.com/OpenRefine/OpenRefine/graphs/traffic 

7. Academic citations
From the result page, you can filter results by date: https://scholar.google.ca/scholar?hl=en&as_sdt=0%2C5&q=%22OpenRefine%22&btnG=


If you are interested in Open Source Metrics,  there are a lot of new projects on that area: