Live Tract Database — Real D1-backed Records

—Loading...

ID	Legal Description	County	Basin	Formations	Title	Top FDS	Median Comp

ID	Operator	Ticker	HQ	Avg FDS	Leases (12mo)	Avg Bonus	Grade

RRC API	Well Name	Operator	Formation	Status	BOPD	MCFD	Spud

Date	Source	Tract	County	Operator	Bonus/ac	Royalty	FDS

ID	Tract	Owner	County	NMA	Ask Bonus	Royalty	FDS	Status

ID	Listing	Operator	Bonus	Royalty	Term	Pugh	Deductions	FDS

API Endpoints

All endpoints are public, JSON-only, edge-cached for 60s. Test them in your browser.

GET /api/statsOpen ↗

Top-line counts + 90-day median bonus

GET /api/tractsOpen ↗

All tracts in database

GET /api/tracts/:idSample ↗

Tract + wells + listings + offers

GET /api/operatorsOpen ↗

Real public operators (PR, FANG, EOG, etc.)

GET /api/operators/:idPR ↗

Operator + recent deals + wells

GET /api/wellsOpen ↗

All wells. Filter: ?operator=ID, ?tract=ID

GET /api/comps90d ↗

Comp data. Filter: ?basin, ?county, ?days=N

GET /api/listingsOpen ↗

Active listings on platform

GET /api/offers/:listing_idListing 1 ↗

All offers on a listing, FDS-sorted

Architecture:
D1 (SQLite at edge) → Pages Functions (V8 isolate) → JSON response.
~10ms p50 latency. Globally distributed via Cloudflare's 300+ PoPs.

The real database powering the platform.Every record below is live.

The real database powering the platform.
Every record below is live.