---
title: "List countries/regions of PR creators"
method: GET
path: "/v1/repos/{owner}/{repo}/pull_request_creators/countries/"
tags: ["Pull Request Creators"]
---

# List countries/regions of PR creators

`GET /v1/repos/{owner}/{repo}/pull_request_creators/countries/`

## Request

- Base URL: `https://api.ossinsight.io` (the document declares no server; this is the origin it was published from)
- URL: `https://api.ossinsight.io/v1/repos/{owner}/{repo}/pull_request_creators/countries/`
- Auth: none declared
- TypeScript: <https://skmtc.dev/ossinsight/apis/ossinsight-api/docs/v1/repos/:owner/:repo/pull_request_creators/countries/get.ts> (a function with typed inputs; its response is checked against the schema)

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
- `repo` string, required

## Query parameters

- `exclude_unknown` boolean
- `from` string
- `to` string

## Response `200`

Default Response

- object
  - `type` 'sql_endpoint', required: The type of the endpoint.
  - `data` object, required
    - `columns` object[], required
      - `col` string, required: The name of the column in the query result.
      - `data_type` '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', required: The data type of the column.
      - `nullable` boolean, required: Whether the column is nullable.
    - `rows` object[], required
      - `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.

---

[API](https://skmtc.dev/ossinsight/apis/ossinsight-api.md) - [All operations](https://skmtc.dev/ossinsight/apis/ossinsight-api/llms.txt) - [OpenAPI document](https://skmtc.dev/ossinsight/apis/ossinsight-api/revisions/d5e73696aea8?raw)