---
title: "Get a single game_player_prop by id"
method: GET
path: "/api/v1/mlb/game_player_props/{id}"
tags: ["MLB"]
---

# Get a single game_player_prop by id

`GET /api/v1/mlb/game_player_props/{id}`

## Request

- Base URL: `https://api.stat-api.com`
- URL: `https://api.stat-api.com/api/v1/mlb/game_player_props/{id}`
- Auth: HTTP bearer

⚠️ This endpoint is documented but not yet live. Calls return 503 until the MLB data load is in production.

## Path parameters

- `id` integer, required: Primary Key

## Response `200`

Single game_player_props row.

- MLBGamePlayerProps: MLB player prop bets for each game — hits, runs, RBIs, total bases, home runs, strikeouts (for pitchers), and other player-statistic markets offered by sportsbooks.
  - `book_count` integer, required: Number of curated books contributing to this consensus value
  - `captured_at` string, date-time, required
  - `category` string, required: Canonical category. Pitcher props: - strikeouts_pitcher, hits_allowed, walks_allowed, - earned_runs, outs_recorded, pitching_outs, win, quality_start Batter props: - hits, home_runs, rbis, total_bases, runs, walks, - stolen_bases, strikeouts_batter, hits_runs_rbis
  - `game_id` integer, required
  - `id` integer, required: Primary Key
  - `is_opening` boolean, required
  - `line` number, double, nullable: Prop line for over/under markets (e.g., 5.5 strikeouts)
  - `market_key` string, required: Raw market key from source API (e.g., pitcher_strikeouts)
  - `no_odds` integer, nullable
  - `operator_id` integer, required
  - `outcome_type` string, required: ou | yes_no
  - `over_odds` integer, nullable
  - `period_code` string, nullable: Optional period code (F5)
  - `player_id` integer, required
  - `season_id` integer, required: Denormalized for efficient season-level queries
  - `subcategory` string, nullable: Optional subtype (alternate, boosted, etc.)
  - `under_odds` integer, nullable
  - `yes_odds` integer, nullable

## Other responses

- `404`: Row not found.
- `503`: Coming soon — handler returns 503 until data is wired in.

---

[API](https://skmtc.dev/stat-api/apis/sports-db-public-api.md) · [All operations](https://skmtc.dev/stat-api/apis/sports-db-public-api/llms.txt) · [OpenAPI document](https://skmtc.dev/stat-api/apis/sports-db-public-api/revisions/23b66b957723?raw)