Foreman Intelligence gives you direct access to the data behind Foreman through Looker explores. This article lists every explore, what it contains, and which one to reach for. Each explore group then has its own article with a table of every field.

Model: customer_access. Generated from the live Looker model on 2026-09-04. Fields hidden in Looker are not listed.

Contents

1. How to read the dictionary
2. All explores at a glance
3. Which miner explore should I use?
4. Views that appear in many explores
5. Articles in this dictionary

How to read the dictionary

An explore is a starting point for a query in Looker. It defines which tables are joined together and which fields you can pick from. Every dashboard tile and Look in Foreman Intelligence is built on one explore, and when you ask Claude for a chart it picks an explore first too.

An explore is made of one or more views. A view is a set of related fields, usually one table. When you open an explore in Looker the field picker on the left is grouped by view name, and the field tables in this dictionary use the same names, so what you read here matches what you see in Looker.

• Dimensions are attributes you group and filter by: a miner's name, a rack, a timestamp, a Yes / No flag, or a raw reading such as average power for one row.
• Measures aggregate across all the rows you select: a sum, an average, or a count of unique miners. Add a measure and Looker rolls the data up to whatever dimensions you chose.
• Yes / No fields are true or false flags. They are handy as filters: "Is Current Data is Yes" keeps only each miner's latest reading.
• Date fields that show several timeframes (Date, Hour, Week, Month) are one field in Looker with a timeframe picker. Choose the timeframe that matches the grain of your chart.
• Unit variants such as Average Hash Rate (TH) and Average Hash Rate (PH), or Power (W), (kW), and (MW), are the same value at different scales. Pick the one that reads well for your fleet size.
• Current versus Historical in a view name tells you whether the view holds one row per miner as things stand right now, or a time series of how things were.

A few Foreman terms appear throughout. A client is a Foreman account, which for most customers means a site or company. A Pickaxe is the Foreman agent installed on site that talks to the miners and reports back. A dispatch is a curtailment or restore instruction, and a strike price is the power price at which Foreman starts curtailing.

All explores at a glance

Which miner explore should I use?

Five explores hold miner data and they share most of their fields, so the choice comes down to grain and coverage.

One more thing to know: the "online only" explores include a miner in a 5 minute window only if it reported during that window. Averages from those explores are averages of working miners. If you need to know how many miners were not working, use Miner Data (All).

Views that appear in many explores

Several views are joined into most of the miner-related explores so that context is always one click away. They are documented once, in the article that owns them, and linked from everywhere else.

• Miner Data - the 5 minute telemetry view. Appears as Miner Data (Historical) in time-series explores and Miner Data (Current) in snapshot explores. Same fields either way.
• Miner Details (Current) - the miner record as it is now: name, type, expected hash rate, state, Foreman configuration flags.
• Client Power Cost - the power price per MWh in effect for the client at each 5 minute mark.
• Coin Hash Price - the revenue per unit of hash rate at each 5 minute mark, used to value hash rate in dollars.
• Firmware Error Codes - individual firmware error codes reported by miners, one row per code.
• Client Data (Historical) - the client's configuration over time, including curtailment settings and power pricing setup.
• LMPs - locational marginal power prices, also available as its own explore.

Articles in this dictionary

• Data Dictionary: Miners - Hash rate, power, temperature, pool, and issue data for every miner Foreman monitors, at 5 minute, hourly, and daily grain.
• Data Dictionary: Tickets - Every ticket raised in Foreman, its status changes, who handled it, how long it took, and how many were open at any point in time.
• Data Dictionary: Site Map - Hourly snapshots of your site map racks and positions, joined to the miners sitting in each slot.
• Data Dictionary: Curtailment - Dispatch events, strike prices, and the miners affected when Foreman curtails or restores power.
• Data Dictionary: LMPs - Locational marginal prices for power markets around the world, down to 5 minute granularity.
• Data Dictionary: Coins - Coin prices, hash prices, and network statistics such as difficulty and network hash rate, at 5 minute grain.
• Data Dictionary: Pools - Per-worker hash rate reported by the mining pools themselves, so you can compare what the pool saw with what the miner reported.
• Data Dictionary: Weather - Hourly historical weather and 10 day hourly forecasts for any coordinates or US zip code, for correlating site conditions with miner behavior.

To connect Claude to these explores, see How To: Build Foreman Intelligence Dashboards with Claude.