List countries/regions of issue creators
List countries/regions of stargazers 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 tofalse
.
Path Parameters
The owner of the repo.
The name of the repo.
Query Parameters
Default value: true
Whether to exclude issue creators with unknown country/region information
Default value: 2000-01-01
The start date of the range.
Default value: 2099-01-01
The end date of the range.
- 200
Default Response
Schema
- Array [
- ]
- Array [
- ]
Possible values: [sql_endpoint
]
The type of the endpoint.
data object required
columns object[] required
The name of the column in the query result.
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.
Whether the column is nullable.
rows object[] required
Country/region code
Number of issue creators from the country/region
Percentage of issue creators from the country/region
result object required
The code of the response.
The message of the response.
The start time of the query in milliseconds.
The end time of the query in milliseconds.
The latency of the query.
The number of rows in the query result.
The number of rows affected by the query.
The maximum number of rows in the query result.
The databases used in the query.
{
"type": "sql_endpoint",
"data": {
"columns": [
{
"col": "country_code",
"data_type": "CHAR",
"nullable": true
},
{
"col": "percentage",
"data_type": "DECIMAL",
"nullable": true
},
{
"col": "issue_creators",
"data_type": "BIGINT",
"nullable": true
}
],
"rows": [
{
"country_code": "CN",
"issue_creators": "7131",
"percentage": "0.8749"
},
{
"country_code": "US",
"issue_creators": "316",
"percentage": "0.0388"
},
{
"country_code": "CA",
"issue_creators": "243",
"percentage": "0.0298"
},
{
"country_code": "NL",
"issue_creators": "223",
"percentage": "0.0274"
}
],
"result": {
"code": 200,
"message": "Query OK!",
"start_ms": 1690957407469,
"end_ms": 1690957407499,
"latency": "30ms",
"row_count": 4,
"row_affect": 0,
"limit": 50,
"databases": [
"gharchive_dev"
]
}
}
}