OSossinsight
Pull Request Creators

List countries/regions of PR creators

List countries/regions of pull request creators for the specified repository.

Notice: In the overall data, about 3.5% of GitHub users provided valid country/region information.

Note: By default, the API does not count users without valid country/region information. If you need to count these users, you can set the exclude_unknown parameter to false.

get/v1/repos/{owner}/{repo}/pull_request_creators/countries/

Request

Path parameters

ownerstring required

The owner of the repo.

repostring required

The name of the repo.

Query parameters

exclude_unknownboolean

Whether to exclude issue creators with unknown country/region information

fromstring

The start date of the range.

tostring

The end date of the range.

Response

Default Response

type'sql_endpoint' required

The type of the endpoint.

Example response

{
  "type": "sql_endpoint",
  "data": {
    "columns": [
      {
        "col": "country_code",
        "data_type": "CHAR",
        "nullable": true
      },
      {
        "col": "pull_request_creators",
        "data_type": "BIGINT",
        "nullable": true
      },
      {
        "col": "percentage",
        "data_type": "DECIMAL",
        "nullable": true
      }
    ],
    "rows": [
      {
        "country_code": "CN",
        "percentage": "0.8802",
        "pull_request_creators": "13619"
      },
      {
        "country_code": "NL",
        "percentage": "0.0508",
        "pull_request_creators": "786"
      },
      {
        "country_code": "US",
        "percentage": "0.0400",
        "pull_request_creators": "619"
      }
    ],
    "result": {
      "code": 200,
      "message": "Query OK!",
      "start_ms": 1690957407469,
      "end_ms": 1690957407499,
      "latency": "30ms",
      "row_count": 3,
      "row_affect": 0,
      "limit": 50,
      "databases": [
        "gharchive_dev"
      ]
    }
  }
}

Changes

No recorded changes to this operation across all 3 revisions of this API.