v11

OpenAPI 3.0.3raw.githubusercontent.com2024-01-1200163.6 KB
Issue Creators

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 to false.

get/repos/{owner}/{repo}/issue_creators/countries/

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