US Open Data Studio
US Open Data Studio pulls keyless US federal series from the BLS public API and the USGS earthquake API and joins them into one flat table per run: CPI-U, core CPI and PPI, unemployment and participation rates, wages, nonfarm employment, or M4.5+ earthquake counts. It costs $0.02 per joined pull, or $0.01 for a raw extract of one to five series, and delivers CSV, JSON or XLSX from public domain data.
from $0.02 per joined pull, $20.00 per 1,000 · Updated Nov 2026, version 0.1.7
Key facts
- Price
- from $0.02 per joined pull, $20.00 per 1,000
- Pricing model
- Pay per event
- Output
- JSON, CSV, Excel, XML, RSS via Apify datasets
- Access
- Apify Console, REST API, Python and JS clients
- Version
- Updated Nov 2026, version 0.1.7
- Usage
- 96.5% successful runs (30 days)
- Actor
subimpact/us-open-data-studio
Who it is for
- Analysts building a US macro table without Census or FRED keys
- Economists comparing prices, wages and employment by year
- Journalists and researchers needing cited federal series
- Data teams teaching a model US labour and price history
Use cases
Inflation, core inflation and PPI
T1 joins CPI-U, core CPI and PPI using annual means, so a single table shows headline and underlying price pressure next to producer prices. Because the three series share a year key, divergences between consumer and producer inflation are visible without any manual alignment, which is the chart most price commentary needs first.
Labour market in four columns
T2 returns the unemployment rate, employment level, labour force and participation rate together. Having the level and the rate in the same row matters: a falling unemployment rate can mean hiring or people leaving the labour force, and the participation column tells you which. The run summary records the year range so a truncated series is obvious.
Real wages from two series
T6 pairs CPI-U with average hourly earnings, which is the setup for a real wage view: deflate the earnings series by the price index and you have purchasing power over time. T3 gives average hourly and weekly earnings with total nonfarm employment when you want the nominal picture first, with customAgg set to mean to collapse duplicate periods.
Earthquakes alongside the economy
T4 counts USGS M4.5 and above earthquakes by year and joins them into the same table shape as the economic presets. That makes an unusual but legitimate combined dataset for insurance or catastrophe research, where the hazard series and the economic backdrop need to sit on one year axis rather than two separate downloads.
Raw BLS series when you know the id
In extract mode, datasetIds takes one to five BLS series ids such as CUUR0000SA0 or LNS14000000, or the word earthquakes, and returns each as its own file with a manifest and attribution, no join and no reshape. BLS series ids are documented by the agency, so this is the route when your pipeline already knows exactly which series it wants.
Output fields
| Field | Type | Description |
|---|---|---|
mode | any | |
preset | any | |
rows | any | |
format | any | |
files | any | |
year_range | any | |
run_url | any |
Sample output
From one of our own test runs on 20 Nov 2026, trimmed. Personal data is redacted.
2 rows, first 3 shown
[
{
"year": 2015,
"cpi_u_annual_mean": 237.017,
"cpi_core_annual_mean": 242.2465,
"ppi_annual_mean": 190.441667
},
{
"year": 2016,
"cpi_u_annual_mean": 240.007167,
"cpi_core_annual_mean": 247.602333,
"ppi_annual_mean": 185.375
}
]Input
| Field | Type | Required | Description | Default |
|---|---|---|---|---|
mode | string | No | studio = value layer (presets, joins, AI-ready package). extract = raw data pull of 1-5 BLS series by ID (cheaper per-pull event). | studio |
datasetIds | array | No | For mode=extract: list of BLS series ids (e.g. CUUR0000SA0, LNS14000000) or 'earthquakes' to pull raw (1-5). Leave empty to use studio mode. | - |
preset | string | No | Join bundle. T1 = Inflation & Prices by Year. T2 = Labour Market by Year. T3 = Wages & Earnings by Year. T4 = Earthquakes by Year. T5 = Employment by Year. T6 = Prices & Wages by Year. custom = bring your own BLS series ids. | T1 |
customDatasets | array | No | For preset=custom: list of BLS series ids to join (2-6). Leave empty to use a preset. | - |
customKey | array | No | For preset=custom: key parts to join on. Use 'year' (auto-extracted from BLS year fields) or raw field names. All datasets must share these keys. | ["year"] |
customJoinType | string | No | inner keeps only keys present in every dataset; left keeps all keys from the first dataset. | inner |
customParams | string | No | For preset=custom: JSON object of extra API params applied to every dataset, e.g. {"startyear": 2015, "endyear": 2024}. | - |
customAgg | string | No | none = keep raw rows (last value per key). sum = aggregate numeric values per key. mean = average numeric values per key. | none |
format | string | No | File format delivered to the key-value store (dataset records are always JSON). | json |
webhookUrl | string | No | POST the result file to this URL after the run (3 retries with backoff). Leave empty to skip. | - |
aiReady | boolean | No | Also emit JSON Schema + data dictionary + sample rows for LLM/RAG ingestion. | true |
includeAttribution | boolean | No | Attach source/licence metadata sidecar to every output (public domain, US federal data). | true |
Example input
{
"mode": "studio",
"preset": "T1"
}Pricing
| Event | What it means | Price | Lowest tier |
|---|---|---|---|
joined-pull | One cross-dataset join delivered as flat CSV/JSON/XLSX (studio mode). | $0.02 | $0.02 |
extract-pull | One raw dataset pull (1-5 datasets by ID, no join). | $0.01 | $0.01 |
$20.00 for 1,000 joined pull units at the listed price.
Prices from the Apify Store on 20 November 2026. Apify shows the final price before each run.
How it compares with other Apify actors
Price per 1,000 joins at Apify Store list prices. Every row is a live listing on the Store, read on 20 Nov 2026, so a buyer can check each number at the source.
| Actor | Price per 1,000 joins (Free plan) | Higher plans (Gold) | Start fee per run | Platform usage | Users | Rating | Last build |
|---|---|---|---|---|---|---|---|
| US Open Data Studio — Gov Data Joins This API | $20.00 | $20.00 | None | Included | 2 | No reviews yet | 18 Nov 2026 |
| BLS Unemployment Scraper | Charges per result item, one observation row per series and period. | None | Included | 3 | No reviews yet | 30 Sep 2026 | |
| EIA State Electricity Generation & Consumption API | Charges per result item, one energy record per row, with a start charge. | $0.0001 | Included | 2 | No reviews yet | 12 Oct 2026 | |
Where BLS Unemployment Scraper is stronger
Where BLS Unemployment Scraper is stronger
- Focused on one API, so series IDs go straight in with start and end year
- Returns period names and footnotes alongside each observation
- No preset or join options to choose before a run
Where this API is stronger
- Joins two agencies' datasets on a shared key into one flat table
- Six presets cover inflation, labour, wages, earthquakes, employment and prices
- Delivers CSV, JSON or XLSX with the covered year range recorded
Where EIA State Electricity Generation & Consumption API is stronger
Where EIA State Electricity Generation & Consumption API is stronger
- Covers state level energy generation and consumption with year range filters
- Filters narrow by producer type and energy source
- Returns year over year change alongside each record
Where this API is stronger
- Combines BLS and USGS series instead of one agency's data
- Preset joins run without choosing datasets or a join key
- Output is written in three file formats with attribution included
The closest actors here wrap a single government API or a set of city permit feeds, so none of them merges datasets on a shared key. Teams that only need one series will find those single source actors simpler to run. Buyers who want BLS and USGS measures combined into flat, AI ready files are the audience this studio actor is built for.
Prices are Apify Store list prices, checked 20 Nov 2026. Platform usage 'Paid separately' means Apify bills compute on top of the event price. Check each listing before you buy.
How to run it
- Leave mode at studio and pick a preset, T1 for inflation and prices, T2 for labour or T6 for prices with wages.
- Set format to csv for a spreadsheet, json for a pipeline, or xlsx for a briefing pack.
- Optional: set customParams to pass year bounds such as startyear and endyear when you want a shorter window.
- Run in the Apify Console and check the summary record for rows, format, files and the year range.
- Download the joined file and its verification, attribution and AI-ready sidecars from the key-value store.
cURL
curl -X POST "https://api.apify.com/v2/acts/subimpact~us-open-data-studio/run-sync-get-dataset-items?token=$APIFY_TOKEN" \
-H "Content-Type: application/json" \
-d '{"mode":"studio","preset":"T1"}'Python
from apify_client import ApifyClient
client = ApifyClient("<YOUR_APIFY_TOKEN>")
run = client.actor("subimpact/us-open-data-studio").call(run_input={"mode":"studio","preset":"T1"})
for item in client.dataset(run["default_dataset_id"]).iterate_items():
print(item)JavaScript
import { ApifyClient } from 'apify-client';
const client = new ApifyClient({ token: '<YOUR_APIFY_TOKEN>' });
const run = await client.actor('subimpact/us-open-data-studio').call({"mode":"studio","preset":"T1"});
const { items } = await client.dataset(run.defaultDatasetId).listItems();
console.log(items);n8n
Use the Apify node (Run an Actor).
Actor ID: subimpact/us-open-data-studio
Input JSON: paste the example input above.Limits
- Only BLS and USGS sources are covered; Census, FRED, BEA and EIA need API keys and are not included.
- Whether a series is seasonally adjusted depends on the underlying BLS series id, not on a run setting.
- Presets cover six bundles, so other indicators need extract mode or a custom join.
- Earthquake rows come from USGS counts and cover magnitude 4.5 and above only.
Questions people ask
What does a studio or extract pull cost?
$0.02 per joined pull for one cross-dataset join delivered as a flat file, and $0.01 for a raw extract pull of one to five series by ID. US federal data is public domain, so the charge covers the join, the reshape and the sidecar files.
Do I need a BLS or Census API key?
No. The Actor uses the BLS public API v2 and the USGS FDSN event API, both of which are keyless, plus year parameters in customParams rather than a registered key. Census, FRED, BEA and EIA are not used because they require keys.
Why not data.gov?
The US has no national CKAN datastore: data.gov's CKAN API is dead and returns 404, and the major statistical APIs behind it need keys. This studio uses the keyless federal APIs that actually respond, which is why the preset list is built on BLS and USGS series.
What do the six presets join?
T1 CPI-U, core CPI and PPI. T2 unemployment rate, employment level, labour force and participation rate. T3 average hourly and weekly earnings with total nonfarm employment. T4 USGS M4.5+ earthquake counts. T5 total nonfarm and private-sector employment. T6 CPI-U with average hourly earnings.
Are the series seasonally adjusted?
The Actor returns the series as published by the source, so whether a series is seasonally adjusted depends on the BLS series id behind the preset. When you need a specific variant, use extract mode with the exact series id rather than relying on the preset.
What can I do with a custom join?
Give two to six BLS series ids, choose key columns in customKey where year is auto-extracted, pick inner or left, optionally sum or average duplicates, and pass API parameters such as startyear and endyear as JSON. Filters and aggregation happen in the run, not in a spreadsheet afterwards.
Is there an attribution requirement?
US federal data is public domain, so there is no attribution requirement to satisfy. Each run still writes a sidecar recording the sources and series used, which is useful documentation when a table is handed to someone else.
Need a data source that is not here?
We build and run scrapers for sites that have no public API. Tell us the site, the fields and how often you need them.