---
title: "Get DebiAI projects columns statistics"
method: GET
path: "/data-providers/{dataProviderId}/projects/{projectId}/columnsStatistics"
tags: ["Explorations"]
---

# Get DebiAI projects columns statistics

`GET /data-providers/{dataProviderId}/projects/{projectId}/columnsStatistics`

## Path parameters

- `dataProviderId` string, required
- `projectId` string, required

## Response `200`

A list of columns with their statistics.

- object
  - `columns` object[]
    - `name` string — The name of the column.
    - `type` string — The type of the column (e.g., text, number).
    - `categoty` string — The category of the column (e.g., groundtruth, context).
    - `nbUniqueValues` integer — The number of unique values in the column.
    - `average` number, nullable — The average value of the column (if applicable).
    - `min` number, nullable — The minimum value of the column (if applicable).
    - `max` number, nullable — The maximum value of the column (if applicable).
    - `nbNullValues` integer, nullable — The number of null values in the column.
  - `status` 'ongoing' | 'failed' | 'completed' — The status of the column statistics computation.
  - `nbCurrentSample` integer — The current number of samples processed (optional).
  - `nbTotalSample` integer — The total number of samples to process (optional).

## Other responses

- `400` — Bad request. Invalid parameters.
- `500` — Internal server error.

## Changes

- **2025-06-05** `392978012c60` — 1 info
  - added the optional property `columns/items/categoty` to the response with the `200` status
- **2025-05-22** `b190f5e1471c` — 1 warning
  - removed the optional property `columns/items/categoty` from the response with the `200` status

[Change history](https://skmtc.dev/debiai/apis/debiai-s-exploration-statistics-api/changes/data-providers/:dataProviderId/projects/:projectId/columnsStatistics/get.md)

---

[API](https://skmtc.dev/debiai/apis/debiai-s-exploration-statistics-api.md) · [All operations](https://skmtc.dev/debiai/apis/debiai-s-exploration-statistics-api/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/debiai/debiai-s-exploration-statistics-api/revisions/6b934a413bd9/schema)