Data Catalog

Field-level reference for all ALPI data products. Select a product below to explore its schema.

Overview

ALPI's primary data surface is the auction_cases_enriched dataset — a fully joined, computation-ready record combining raw auction data with API-enriched property and contact intelligence. Every field documented below is available on this surface.

Records are sourced from public county-level filings across select states, normalized into a consistent schema, and enriched with property valuation and skip-trace data. Enrichment fields are populated asynchronously within minutes of initial case capture.

Case identification

Field	Type	Description	Example
`case_number`	text	Unique case identifier assigned by the county court. Format varies by county.	`A250288311499`
`county`	text	County name in lowercase, no spaces.	`hamilton`
`source`	text	Data source identifier.	`alpi_foreclosure`

Dates and timestamps

Field	Type	Description	Example
`auction_date`	date	Scheduled auction date.	`2026-03-25`
`date_of_sale`	text	Actual sale date if the property sold at auction. Null if not yet sold.	`03/25/2026`
`scraped_at`	timestamptz	Timestamp of the most recent data capture from the county source.	`2026-03-07T14:32:11Z`
`updated_at`	timestamptz	Timestamp of the most recent record update in ALPI's database.	`2026-03-07T14:32:11Z`
`enriched_at`	timestamptz	Timestamp when enrichment data was last fetched. Null until enrichment completes.	`2026-03-07T14:35:00Z`

Property location

Field	Type	Description	Example
`address`	text	Property street address.	`3389 GLENMORE AVE`
`city`	text	Property city.	`CINCINNATI`
`state`	text	Property state. Always `OH` for current coverage.	`OH`
`zip`	text	Property ZIP code, 5 digits.	`45211`

Case classification and status

Field	Type	Description	Values / Example
`auction_status`	text	Current lifecycle status of the auction event.	`Scheduled`, `Sold`, `Withdrawn`, `Cancelled`, `Postponed`
`foreclosure_type`	text	Legal filing type as recorded by the county court.	`Mortgage`, `Alias`, `Non-Tax Sale`
`sale_type`	text	Classification of the sale event.	`NON-TAX SALE`, `Foreclosure`
`case_type`	text	ALPI internal case classification.	`Surplus`
`case_status`	text	ALPI internal processing status.	`New Case`

Parties

Field	Type	Description	Example
`defendant_name`	text	Full name of the property owner or defendant as recorded in the county filing.	`JENNIFER ROLLINGER`

Financial data

Field	Type	Description	Example
`sale_amount`	numeric	Auction sale price in USD. Null if the property has not yet sold.	`142000.00`
`arv`	numeric	After-repair value — estimated current market valuation sourced via property API.	`218000.00`
`loan_balance_est`	numeric	Estimated outstanding mortgage balance sourced via loan balance API.	`110000.00`
`estimated_equity`	numeric	Computed: `arv − loan_balance_est`. Indicates notional equity in the property prior to sale.	`108000.00`
`post_sale_surplus`	numeric	Computed: `sale_amount − loan_balance_est`. Estimates funds potentially owed back to the former owner after a completed sale.	`32000.00`

Contact information

Contact fields are populated via skip-trace API after initial case capture. They may be null in the minutes immediately following ingestion.

Field	Type	Description	Example
`phone_numbers`	jsonb	Array of skip-traced phone numbers associated with the defendant.	`["+15134820000"]`
`emails`	jsonb	Array of skip-traced email addresses associated with the defendant.	`["jane@example.com"]`

Data quality notes

County format: County values are stored in lowercase without the word "county" — e.g. hamilton, not Hamilton County.
Enrichment lag: Fields sourced from external APIs (arv, loan_balance_est, phone_numbers, emails) are populated asynchronously and may be null for a short window after initial case capture.
Computed fields: estimated_equity and post_sale_surplus are null if either of their input fields is missing.
Post-sale fields: date_of_sale and sale_amount are populated only for cases where auction_status = 'Sold'.
Address normalization: Address components are parsed from raw county data. Complex or multi-parcel properties may have partial address data.

Administrative Boundaries

Time-series boundary datasets spanning multiple decades for international administrative units. Full field reference is coming soon. Contact us for early access or a data sample.

Field	Type	Description
`boundary_id`	text	Unique identifier for the boundary feature.
`admin_level`	integer	Administrative hierarchy level (1 = country, 2 = province/state, 3 = district, etc.).
`name`	text	Official name of the administrative unit.
`iso_country`	text	ISO 3166-1 alpha-2 country code.
`valid_from`	date	Date from which this boundary definition is valid.
`valid_to`	date	Date on which this boundary definition was superseded, or null if current.
`geometry`	geometry	Polygon or multipolygon in WGS84 (EPSG:4326).

Historical Building Data

Georeferenced historical building footprints with vintage dating and structural attributes. Full field reference is coming soon. Contact us for early access.

Field	Type	Description
`building_id`	text	Unique identifier for the building record.
`vintage_year`	integer	Year of first documented construction or appearance.
`occupancy_class`	text	Primary occupancy classification (residential, commercial, industrial, etc.).
`construction_material`	text	Primary structural material where available.
`floor_count`	integer	Number of floors where source data permits.
`footprint`	geometry	Building footprint polygon in WGS84.

Place Names Geocoding

Authoritative place name to coordinate resolution from curated gazetteer sources. Full field reference is coming soon. Contact us for early access.

Field	Type	Description
`place_id`	text	Unique identifier for the named place record.
`name`	text	Official or authoritative place name.
`feature_class`	text	Type of geographic feature (populated place, water body, landform, etc.).
`country_code`	text	ISO 3166-1 alpha-2 country code.
`latitude`	numeric	Decimal degrees latitude (WGS84).
`longitude`	numeric	Decimal degrees longitude (WGS84).
`source`	text	Gazetteer or authoritative source attribution.
`confidence`	text	Confidence level of the coordinate assignment (high / medium / low).

Digital Elevation Models

High-resolution terrain rasters delivered as GeoTIFF. Metadata fields describe each tile. Full field reference is coming soon. Contact us for early access.

Field	Type	Description
`tile_id`	text	Unique tile identifier matching the delivery filename.
`resolution_m`	numeric	Ground sampling distance in metres.
`vertical_datum`	text	Vertical reference datum (e.g. EGM2008, NAVD88).
`crs`	text	Coordinate reference system as EPSG code.
`bbox`	geometry	Bounding box of the tile extent.
`source`	text	Source sensor or program (e.g. SRTM, LiDAR).

Satellite Geocoding (L0–L3)

Structured satellite imagery classification from raw sensor output through fully georeferenced product. Full field reference is coming soon. Contact us for early access.

Field	Type	Description
`scene_id`	text	Unique identifier for the imagery scene.
`processing_level`	text	Processing level: L0, L1, L2, or L3.
`sensor`	text	Sensor or satellite platform name.
`acquisition_date`	date	Date of image capture.
`cloud_cover_pct`	numeric	Percentage cloud cover at time of acquisition.
`crs`	text	Coordinate reference system as EPSG code (L3 only).
`bbox`	geometry	Bounding box of the scene footprint.