Live Pipeline/North American Rail Network/REST + SQL Access

Every Rail
Data Source.
One Engine.

We've aggregated every major railroad data source — STB, FRA, AAR, all Class I carriers, and beyond — into a unified, normalized data lake. Connect your pipeline. Skip the wrangling.

See Demo View Schema Docs

railcore — query.sql

-- Loaded carloads by corridor, last 90 days SELECT origin_state, destination_state, commodity_desc, COUNT(*) AS car_count, SUM(revenue_tons) AS total_tons, AVG(dwell_origin_hrs) AS avg_dwell_hrs FROM railcore.rail_movements WHERE load_status = 'LOADED' AND reporting_date >= CURRENT_DATE - 90 GROUP BY 1, 2, 3 ORDER BY car_count DESC;

STB Carload WaybillFRA Safety DataAAR Traffic StatisticsClass I EDI FeedsIntermodal ReportingSTB Rate CasesPHMSA HazmatEIA Fuel IndicesTIGER/Line GISFRA Equipment RegistryBLS Freight IndicesPort Authority DataBNSF ReportingUnion PacificCSXNorfolk SouthernCanadian NationalCPKCSTB Carload WaybillFRA Safety DataAAR Traffic StatisticsClass I EDI FeedsIntermodal ReportingSTB Rate CasesPHMSA HazmatEIA Fuel IndicesTIGER/Line GISFRA Equipment RegistryBLS Freight IndicesPort Authority DataBNSF ReportingUnion PacificCSXNorfolk SouthernCanadian NationalCPKC

47+

Integrated Data Sources

2B+

Annual Waybill Records

99.9%

Pipeline Uptime SLA

6hr

Max Refresh Latency

How It Works

We Source It. You Query It.

Continuous Ingestion

Automated pipelines pull from every authorized source on defined schedules — STB waybill samples, FRA safety filings, AAR weekly traffic reports, and carrier EDI feeds — with full auditability and run history.

Normalization & Enrichment

Raw data is parsed, deduplicated, and resolved against a canonical schema. SPLC codes are joined to metro areas, STCC classes are labeled, and all records are time-zone aligned before landing.

Unified Data Lake

All sources converge into a versioned, queryable data lake with full historical depth. Cross-source joins work out of the box — no bespoke ETL required on your end.

Connect & Consume

Access via REST API, SQL endpoint, or bulk export. Native connectors for Snowflake, Databricks, and BigQuery. You bring the model — we deliver the data on a schedule you can rely on.

Data Coverage

Every Source. One Connection.

We've established access, built the parsers, and maintain the refresh logic across the full landscape of U.S. and North American rail data. Your team inherits the integration work — not the burden of maintaining it.

STB Carload Waybill Sample

FRA Safety Data

AAR Traffic Statistics

Class I Carrier Reports

BNSF Public Reporting

Union Pacific

CSX

Norfolk Southern

Canadian National

Canadian Pacific Kansas City

FRA Equipment Registry

STB Rate Cases

PHMSA Hazmat Incidents

BLS Freight Price Indices

EIA Fuel Data

Port Authority EDI

TIGER/Line Rail GIS

FRA Inspection Reports

Intermodal Statistics

NOAA Weather Correlation

+ 27 additional sources

Use Cases

Built for Operations at Scale

Fleet & Asset Optimization

Track car utilization, dwell times, and fleet velocity across the network. Identify bottlenecks and reposition assets before they cascade into service failures.

Supply Chain Visibility

Gain full visibility into inbound and outbound rail movements. Correlate commodity flows with carrier performance to proactively manage rail-dependent supply chains.

Rate & Contract Analytics

Benchmark freight rates against STB-reported actuals. Enter carrier contract negotiations anchored to real market data, not estimates.

Risk & Compliance

Monitor FRA safety trends, incident patterns, and infrastructure risk. Correlate safety data with your operational footprint to stay ahead of exposure.

Market Intelligence

Track commodity traffic trends, carrier market share, and O-D pair shifts over time. Surface the signals in aggregate carload data before your competitors do.

AI & Predictive Modeling

Feed structured, clean rail data directly into your forecasting and ML pipelines. We eliminate the data prep work — your models start with production-ready inputs on day one.

Schema & Access

Clean Schema. Full Lineage. No Surprises.

Every table follows a rigorous, versioned schema. Full data dictionaries, field-level lineage documentation, and changelog history are included with every dataset your team accesses.

Versioned schema — breaking changes are never silent

Full data dictionary — every field defined, sourced, and typed

Field-level lineage — know exactly where every value originated

REST + SQL endpoints — integrate in hours, not weeks

Native warehouse connectors — Snowflake, Databricks, BigQuery

railcore.rail_movements — schema

-- Table: railcore.rail_movements -- Source: STB Waybill Sample + Carrier EDI -- Grain: One row per car movement -- Refresh: 6-hour cadence waybill_id VARCHAR -- PK reporting_date DATE scac_code CHAR(4) -- carrier carrier_name VARCHAR -- enriched origin_splc CHAR(9) origin_state CHAR(2) origin_msa VARCHAR -- enriched destination_splc CHAR(9) destination_state CHAR(2) destination_msa VARCHAR -- enriched commodity_stcc CHAR(7) commodity_desc VARCHAR car_type VARCHAR load_status VARCHAR -- LOADED | EMPTY revenue_tons NUMERIC car_miles NUMERIC rate_per_ton NUMERIC dwell_origin_hrs NUMERIC dwell_dest_hrs NUMERIC hazmat_flag BOOLEAN intermodal_flag BOOLEAN _ingested_at TIMESTAMP _source_version VARCHAR

Delivery Options

REST API

SQL Endpoint

Snowflake

Databricks

BigQuery

Bulk Export

Get Started

Stop Building Pipelines to Rail Data. Start Using It.

We own the sourcing, normalization, and delivery infrastructure. Your team connects to a single, stable endpoint and gets to work from day one.

View Schema Docs