---
title: "Wellbore identities (25 free rows, bulk with a key)"
method: GET
path: "/api/v1/rrc/wellbores"
tags: ["rrc"]
---

# Wellbore identities (25 free rows, bulk with a key)

`GET /api/v1/rrc/wellbores`

## Request

- Base URL: `https://api.tppflow.com` (the document declares no server; this is the origin it was published from)
- URL: `https://api.tppflow.com/api/v1/rrc/wellbores`
- Auth: none declared

## Query parameters

- `district` integer, nullable: RRC district
- `county` integer, nullable: Texas county code
- `api_number` string, nullable: Exact 42-CCC-UUUUU
- `plugged` boolean, nullable
- `orphan_well_hold` boolean, nullable
- `completed_since` string, nullable: ISO date
- `completed_before` string, nullable: ISO date
- `min_depth` integer, nullable
- `limit` integer, nullable
- `offset` integer

## Headers

- `X-RapidAPI-Proxy-Secret` string, nullable
- `authorization` string, nullable
- `X-API-Key` string, nullable

## Response `200`

Successful Response

- WellboresResponse
  - `count` integer, required: Rows in this response
  - `total_matching` integer, required: Rows matching the query in the corpus
  - `metadata` ResponseMetadata, required
    - `total_matched` integer, required: Wellbores matching this query
    - `corpus_wells` integer, required: Total wellbores in the corpus
    - `returned` integer, required: Rows in this response
    - `withheld` integer, required: Matching rows not returned
    - `last_ingested` string, nullable: UTC timestamp of the most recent corpus load
    - `free_tier` boolean, required
    - `free_rows_per_request` integer, nullable
    - `free_queries_per_day` integer, nullable
    - `queries_used_today` integer, nullable
  - `query` object, required
  - `free_tier` boolean, required: True when served without a key
  - `upgrade` object, nullable: Present on the free tier: how to get the rest
  - `wellbores` Wellbore[], required
    - `api_number` string, required: Texas API well number, 42-CCC-UUUUU
    - `district` integer, nullable: RRC district
    - `api_county` integer, nullable: Texas county code
    - `completion_date` string, nullable: ISO date of original completion (W-2/G-1). NULL when the source value is not a valid calendar date.
    - `completion_date_raw` integer, nullable: The source's own CCYYMMDD integer, preserved even when it fails the calendar, so dirt is visible not hidden.
    - `total_depth` integer, nullable: Total depth, feet
    - `total_bonded_depth` integer, nullable
    - `shut_in_month` string, nullable: YYYY-MM
    - `plugged` boolean, nullable: Wellbore has been plugged
    - `subject_to_14b2` boolean, nullable: Inactive well operating under a 14(b)(2) extension
    - `pending_removal_14b2` boolean, nullable
    - `orphan_well_hold` boolean, nullable: Flagged in the orphan-well program
    - `fresh_water_protected` boolean, nullable
    - `except_13a_filed` boolean, nullable
    - `completion_data_on_file` boolean, nullable
    - `newest_drilling_permit_nbr` integer, nullable
    - `previous_api_nbr` integer, nullable

## Other responses

- `402`: No key, and the request asked for more than the 25-row free sample (limit > 25 or offset > 0). Body carries the checkout URL.
- `403`: Key is valid but scoped to a different module
- `422`: Validation Error

---

[API](https://skmtc.dev/tppflow/apis/teos-transmuter-tollbooth.md) · [All operations](https://skmtc.dev/tppflow/apis/teos-transmuter-tollbooth/llms.txt) · [OpenAPI document](https://skmtc.dev/tppflow/apis/teos-transmuter-tollbooth/revisions/9cc882993c5a?raw)