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.

Path Parameters

owner string required
The owner of the repo.
Example: pingcap
repo string required
The name of the repo.
Example: tidb

Query Parameters

exclude_unknown boolean

Default value: true

Whether to exclude issue creators with unknown country/region information

from string

Default value: 2000-01-01

The start date of the range.

to string

Default value: 2099-01-01

The end date of the range.

Responses

• 200

---

Default Response

application/json

Schema

Example (from schema)

---

Schema

type string required

Possible values: [sql_endpoint]

The type of the endpoint.

data object required
columns object[] required
Array [
col string required
The name of the column in the query result.
data_type string required
Possible values: [CHAR, BIGINT, DECIMAL, INT, UNSIGNED BIGINT, TINYINT, TIMESTAMP, TEXT, VARCHAR, DATETIME, DOUBLE, FLOAT, DATE, TIME, YEAR, MEDIUMINT, SMALLINT, BIT, BINARY, VARBINARY, JSON, ENUM, SET, TINYTEXT, MEDIUMTEXT, LONGTEXT, TINYBLOB, MEDIUMBLOB, BLOB, LONGBLOB]
The data type of the column.
nullable boolean required
Whether the column is nullable.
]
rows object[] required
Array [
country_code string
Country/region code
percentage string
Percentage of pull request creators from the country/region
pull_request_creators string
Number of pull request creators from the country/region
]
result object required
code number
The code of the response.
message string
The message of the response.
start_ms number
The start time of the query in milliseconds.
end_ms number
The end time of the query in milliseconds.
latency string
The latency of the query.
row_count number
The number of rows in the query result.
row_affect number
The number of rows affected by the query.
limit number
The maximum number of rows in the query result.
databases string[]
The databases used in the query.
property name* any

{
  "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"
      ]
    }
  }
}

Loading...