Everything underneath

Screen master

One row for every screen any other dataset in your delivery carries: coordinates, geohash, country, state, postal code, DMA, venue category and OpenOOH venue type, placement, timezone, whether the screen moves, and when it last checked in.

Request a sample All datasets

The question it answers

Where is each screen, what kind of place is it in, and which market does it serve?

14,437

screens in a 28-day delivery

OpenOOH venue types

110

DMAs of those screens

countries of those screens

Measured over the 28 days to October 11, 2026.

The dataset

Grain: One row per screen.
Cadence: One row per screen, cut with every delivery.
History: Current state, cut with each delivery.
Format: Parquet or JSONL.
Delivered to: Your S3 bucket, your GCS bucket, or a time-limited download link, with a manifest and a schema.
Method: How each measure is produced and how to add rows up: the measurement methodology.
On the network: Venue categories, Cities and states, Hardware.

What buyers do with it

The join key for every other dataset in the catalog.
Coverage maps and venue mix by market.
OpenOOH venue types for planning tools that already use them.

The table

Read from the export registry each time this site is built.

`dim_screen`

Snapshot, from Current state

Grain: One row per screen_id.
Delivery: One file per delivery, as Parquet or JSONL.
Basis: Declared by the source.
Definition: Version 3.

Column	Type	What it holds
`screen_id`	string	Trillboards screen id (24-character hex); joins dim_screen.screen_id.
`in_screen_registry`	integer	1 when our screen registry holds the screen; 0 = one of our screen ids the registry no longer holds, so every registry attribute is NULL.
`latitude`	double	Latitude of the screen's one stored point: its site for a fixed screen, where it last synced for a vehicle (location_basis). Unit: degrees. Null: No stored coordinate (a (0, 0) placeholder is NULL too), or not in the registry.
`longitude`	double	Longitude of the same point. Unit: degrees. Null: As latitude.
`geohash6`	string	Geohash-6 cell of the stored point. Null: No stored coordinate, or not in the registry.
`country`	string	Country of the screen's registered location. Null: Unresolved, or not in the registry.
`state`	string	State or province of the registered location. Null: Unresolved, or not in the registry.
`postal_code`	string	Postal code of the registered location. Null: Unresolved, or not in the registry.
`dma_code`	string	Nielsen DMA code. Null: Outside the US, unresolved, or not in the registry.
`dma_name`	string	DMA name. Null: As dma_code.
`venue_category`	string	Registered venue category (transit = a vehicle). Null: Not classified, or not in the registry.
`openooh_venue_type_id`	integer	OpenOOH venue taxonomy id. Null: Unclassified (the 0 placeholder), or not in the registry.
`environment_type`	string	Registered environment type of the screen (e.g. indoor, outdoor). Null: Not classified, or not in the registry.
`placement_type`	string	How the screen is placed in the venue. Null: Not classified, or not in the registry.
`place_name`	string	Name of the place the screen is in. Null: No place name, or not in the registry.
`timezone`	string	IANA timezone of the screen. Null: No registered timezone, or not in the registry.
`is_mobile`	integer	1 for a vehicle-mounted screen (venue_category transit). Null: Not in the registry.
`location_basis`	string	What the coordinate is: fixed_site, or mobile_last_known for a vehicle. Null: No coordinate.
`last_heartbeat_at`	timestamp	The device's last heartbeat our registry holds, UTC, as of the delivery. Null: Not in the registry.
`first_seen`	date	First UTC day in the delivery window on which any of the delivery's ClickHouse-held datasets holds a row of the screen.
`last_seen`	date	Last such UTC day.
`active_days`	integer	Distinct UTC days in the window with such a row. Unit: days.
`has_camera`	integer	1 when the window holds a camera row of the screen: a face- or person-backed audience window, a device inference row or a demographic reading.
`has_radio`	integer	1 when the window holds a radio row of the screen: a radio exposure window (any source), a cross-screen transition or a movement edge.
`has_plays_in_window`	integer	1 when the window holds a play of the screen (a report carrying the billing key, or a per-play audience row).

Request a sample

Tell us the markets and the weeks you want. The sample is cut from production by the same export that makes the full delivery.

Request a sample

All datasets · Next: Raw event streams