Bureau of Labor Statistics

A direct pull of U. S.

When to use it

  • Showing a 10-year trend of unemployment and labor force around a deal location.
  • Tracking inflation (CPI) over an underwriting horizon.
  • Underwriting a market by job mix - which sectors are the dominant employers in a county.
  • Quantifying recent employment momentum (3-metric YoY panel) to support rent-growth assumptions.

How it works

  1. 1
    Drop a Bureau of Labor Statistics action into an automation (or click the BLS ribbon button for ad-hoc).
  2. 2
    Pick the category: Employment, Industry Breakout, or Employment Growth (CPI is configured via the BLS form on the ribbon).
  3. 3
    Bind an Address range (cell with the address) and an Output range.
  4. 4
    Choose Always use latest year or pin a year; for Employment Growth, set Number of years (the YoY window).
  5. 5
    Optionally toggle Print charts (Employment Growth only) and Apply formatting.
  6. 6
    The action geocodes the address, resolves the county/MSA, hits the BLS public API, formats a table, and (for Employment Growth) inserts a line chart.

Tips & shortcuts

  • Use Always use latest year in automations. The latest year provider walks the requested BLS series back until it finds a year with published data, so saved deals keep refreshing without manual updates.
  • The ad-hoc Employment dialog lets you change Area type (state, MSA, county, etc.), measures, seasonal-adjustment, and yearly vs monthly. The automation form is intentionally simpler - it always pulls all 4 measures, Seasonally Adjusted, Yearly Average.
  • Industry Breakout uses QCEW CSV (not the JSON BLS series API), so it requires the address to resolve to a U.S. county. International addresses won't work.
  • Employment Growth charts are line charts with circular markers. The chart name embeds the automation ID so re-runs update the chart in place instead of stacking new ones.