Energy
30 columns
100 rows
8 formats

Coal Pricing and Transportation Costs

This dataset provides granular details on coal purchase contracts, including delivered prices, transportation costs, coal quality metrics, and mine origin information. It enables comprehensive analysis of fuel procurement, cost of generation, and supply chain efficiency for energy producers and regulators.

last updated 2 Nov 2025
by GoMask

The brief that made it

Calculating cost of generation for power plants

Sample rows

preview · 8 of 100 rows · all 30 columns

contract_idstring	coal_typestring	coal_quality_moisture_pctfloat	buyer_address_statestring	buyer_namestring	buyer_address_streetstring	buyer_address_citystring	buyer_address_postal_codestring	buyer_address_countrystring	mine_idstring	mine_namestring	mine_address_streetstring	mine_address_citystring	mine_address_statestring	mine_address_postal_codestring	mine_address_countrystring	contract_start_datedate	contract_end_datedate	quantity_tonsfloat	delivered_price_per_tonfloat	delivered_price_per_mmbtufloat	transportation_cost_rail_freightfloat	transportation_cost_demurragefloat	coal_quality_sulfur_content_pctfloat	coal_quality_heat_content_btu_per_lbfloat	coal_quality_ash_content_pctfloat	coal_quality_adjustment_amountfloat	coal_quality_adjustment_reasonstring	generation_unit_idstring	notesstring
CT20240001	bituminous	6.3	IL	Midwest Generation LLC	100 S Power Ave	Springfield	62704	USA	MINE001	Eagle Creek Mine	325 Coal Rd	Carbondale	IL	62901	USA	2023-01-01	2023-12-31	120000.5	57.45	blank	13.25	1.75	1.4	12400	8.9	blank	blank	GU101	Annual supply contract for Springfield Unit 2
CT20240002	lignite	29.5	ND	Great Plains Power	4800 Energy Way	Fargo	58102	USA	MINE002	Northern Lignite	102 Mine Loop	Beulah	ND	58523	USA	2023-03-15	2024-03-14	78000	32.1	blank	9.85	2.3	0.7	8200	16.2	0.45	moisture	GP220	Quality adjustment for above-average moisture
CT20240003	sub-bituminous	13.8	OK	Sunrise Utilities	1501 Solar Dr	Tulsa	74119	USA	MINE003	Red River Coal	88 Red River Rd	McCurtain	OK	74944	USA	2022-07-01	2023-06-30	98000	blank	2.25	11.1	1.5	0.85	10400	10.4	blank	blank	SRU11	Contract extension option available
CT20240004	bituminous	5.5	VA	Atlantic Coast Generation	200 Tidewater Blvd	Norfolk	23510	USA	MINE004	Blue Ridge Coal	910 Appalachian Hwy	Abingdon	VA	24210	USA	2023-04-01	2023-10-31	65000	65.9	blank	15.1	2.7	2.8	13000	7.2	1.1	sulfur	ACG03	Sulfur adjustment due to recent lab results
CT20240005	sub-bituminous	14.7	TX	Lone Star Electric	4300 Star Lane	Dallas	75247	USA	MINE005	Panhandle Mining	77 Panhandle Pkwy	Amarillo	TX	79118	USA	2023-05-01	2024-04-30	115000	blank	2.05	12.7	1.2	0.65	10150	9.3	blank	blank	LSE18	Rail delivery to Dallas West Unit
CT20240006	bituminous	7.1	WV	Appalachian Utility Group	601 Ridge Rd	Charleston	25301	USA	MINE006	Mountain Valley Mine	12 Valley Dr	Princeton	WV	24740	USA	2022-10-01	2023-09-30	90000	59.8	blank	14.2	2.1	1.55	12700	9.8	blank	blank	AUG07	Standard quality, no adjustment
CT20240007	sub-bituminous	15.2	TX	Gulf Coast Power	2500 Bay Shore Dr	Galveston	77550	USA	MINE007	Sabine River Coal	230 Sabine St	Orange	TX	77630	USA	2022-08-01	2023-07-31	102500	blank	2.15	13.9	1.6	0.95	10300	8.7	0.35	ash	GCP09	Minor ash adjustment applied
CT20240008	anthracite	2.2	WA	Pacific Northwest Utility	600 Rainier Ave	Tacoma	98421	USA	MINE008	Cascade Anthracite	170 Cascade Way	Chehalis	WA	98532	USA	2023-01-15	2023-12-14	25000	99.5	blank	22.5	3.6	0.4	14600	6	blank	blank	PNW01	High-grade anthracite for pilot project
CT20240009	bituminous	6.6	AR	Ozark Regional Power	900 Ozark Hwy	Little Rock	72204	USA	MINE009	Ozark Basin Mine	14 Basin Rd	Russellville	AR	72801	USA	2023-02-01	2024-01-31	87000	61.8	blank	10.9	1.9	1.9	12050	11.2	blank	blank	ORP10	Standard contract renewal
CT20240010	sub-bituminous	16.3	IA	Central Energy Cooperative	201 Cooperative Rd	Des Moines	50315	USA	MINE010	Central Plains Mine	445 Plains Ave	Boone	IA	50036	USA	2023-03-01	2023-12-31	67000	blank	1.9	10.5	1.3	0.7	9800	12.2	blank	blank	CEC22	blank
CT20240011	bituminous	7.8	OH	Lake Erie Generating	55 Lakefront Dr	Cleveland	44113	USA	MINE011	Great Lakes Coal	233 Erie Rd	Ashtabula	OH	44004	USA	2022-04-01	2023-03-31	82000	60.15	blank	13.8	2.2	2.2	12200	10.7	0.7	sulfur	LEG12	Contract ended, renewal pending
CT20240012	sub-bituminous	14.9	MN	Northern Lights Power	1100 Aurora Blvd	Minneapolis	55411	USA	MINE012	Aurora Mine	23 Light St	Duluth	MN	55802	USA	2023-05-01	2024-04-30	94000	blank	2.1	13.4	1.5	0.55	9950	9.9	blank	blank	NLP07	Standard contract
CT20240013	bituminous	7.6	CO	Western Grid Electric	7888 Grid St	Denver	80216	USA	MINE013	Front Range Mine	355 Range Rd	Pueblo	CO	81004	USA	2023-02-01	2023-12-31	107000	63.2	blank	14.7	2.8	1.75	12550	9.2	blank	blank	WGE15	Annual supply, no adjustment
CT20240014	bituminous	7.9	GA	Southeast Power Group	4000 Peach St	Atlanta	30303	USA	MINE014	Georgia Coal	156 Southern Rd	Rome	GA	30165	USA	2023-03-01	2023-08-31	61000	62.4	blank	13.1	2	2.3	11900	12.6	0.75	ash	SPG04	Ash adjustment for contract period
CT20240015	bituminous	7.5	IL	Prairie State Power	2000 Prairie Dr	Peoria	61602	USA	MINE015	Prairie Coal Mine	99 Prairie Rd	Springfield	IL	62703	USA	2022-06-01	2023-05-31	95000	60.9	blank	11.6	2.4	1.2	12100	11.9	blank	blank	PSP05	Standard contract
CT20240016	sub-bituminous	15.4	TN	Delta Utility Services	999 Delta Blvd	Memphis	38103	USA	MINE016	River Bend Mine	71 Bend St	Dyersburg	TN	38024	USA	2023-01-01	2023-12-31	81000	blank	2	12.2	1.7	0.9	10080	10.6	blank	blank	DUS16	No adjustments
CT20240017	bituminous	7.2	UT	Rocky Mountain Power	1500 Rockies Rd	Salt Lake City	84104	USA	MINE017	Uintah Basin Mine	500 Uintah Ave	Vernal	UT	84078	USA	2022-09-01	2023-08-31	99000	64.5	blank	16	2.9	1.7	12850	11	0.65	sulfur	RMP22	Sulfur adjustment for summer delivery
CT20240018	bituminous	8.4	WI	Lakeside Energy	123 Lakeside Dr	Madison	53703	USA	MINE018	Badger Coal	700 Badger Rd	Milwaukee	WI	53202	USA	2022-05-01	2023-04-30	82000	59.75	blank	13.2	2	1.9	11980	12.1	blank	blank	LE14	Annual delivery, no adjustment
CT20240019	sub-bituminous	14.1	AZ	Sun Valley Electric	500 Sun Valley Ave	Phoenix	85009	USA	MINE019	Arizona Mining	211 Desert Rd	Flagstaff	AZ	86001	USA	2023-02-01	2024-01-31	108000	blank	1.85	12.4	1.1	0.6	9900	11.7	blank	blank	SVE24	blank
CT20240020	lignite	27.1	ND	Upper Missouri Power	321 Missouri Ave	Bismarck	58501	USA	MINE002	Northern Lignite	102 Mine Loop	Beulah	ND	58523	USA	2023-04-01	2024-03-31	83000	33.45	blank	9.65	2	0.82	8100	18.5	0.3	moisture	UMP17	Moisture adjustment for spring batch

What the 100 rows show

from the 100-row sample

Lignite (coal type) stands out: mean coal_quality_moisture_pct is 25.3, against 9.6 for the rest.

10.6median coal_quality_moisture_pct
3coal quality adjustment reasons
20,250median quantity_tons
59.7median delivered_price_per_ton
1.9median delivered_price_per_mmbtu
8.8median transportation_cost_rail_freight

Mean coal_quality_moisture_pct by coal_type100 rows

coal_quality_moisture_pct100 rows, in bands of 5

Median 10.6, from 1.8 to 30.8.

buyer_address_state100 rows · top 10 of 40 values

30 columns by typefrom the column list below

string 18
float 10
date 2

Columns

30 columns in three groups

blueprint · 30 columns
column	type	description	example
Text 18 columns
`contract_id`	string	Unique identifier for each coal purchase contractunique	CT20240001
`buyer_name`	string	Name of the entity purchasing the coal (e.g., power plant, utility)	Midwest Generation LLC
`buyer_address_street`	string	Street address of the buyeroptional	100 S Power Ave
`buyer_address_city`	string	City of the buyeroptional	Springfield
`buyer_address_state`	string	State or province of the buyeroptional	IL
`buyer_address_postal_code`	string	Postal code of the buyeroptional	62704
`buyer_address_country`	string	Country of the buyeroptional	USA
`mine_id`	string	Unique identifier for the coal mine of origin	MINE001
`mine_name`	string	Name of the coal mine	Eagle Creek Mine
`mine_address_street`	string	Street address of the coal mineoptional	325 Coal Rd
`mine_address_city`	string	City of the coal mineoptional	Carbondale
`mine_address_state`	string	State or province of the coal mineoptional	IL
`mine_address_postal_code`	string	Postal code of the coal mineoptional	62901
`mine_address_country`	string	Country of the coal mineoptional	USA
`coal_type`	string	Type of coal (e.g., bituminous, sub-bituminous, lignite, anthracite)bituminous · sub-bituminous · lignite · anthracite	bituminous
`coal_quality_adjustment_reason`	string	Reason for coal quality adjustment (e.g., sulfur, ash, moisture)3 reasons · optional	moisture
`generation_unit_id`	string	Identifier for the generation unit using the coal (if applicable)optional	GU101
`notes`	string	Additional notes or comments related to the contract or deliveryoptional	Standard contract
Numbers 10 columns
`quantity_tons`	float	Total quantity of coal purchased under the contract (in tons)0 or more	120000.5
`delivered_price_per_ton`	float	Delivered coal price per ton (USD)0 or more · optional	57.45
`delivered_price_per_mmbtu`	float	Delivered coal price per MMBtu (USD)0 or more · optional	2.25
`transportation_cost_rail_freight`	float	Rail freight transportation cost per ton (USD)0 or more · optional	13.25
`transportation_cost_demurrage`	float	Demurrage cost per ton (USD)0 or more · optional	1.75
`coal_quality_sulfur_content_pct`	float	Sulfur content in coal as a percentage0 to 100 · optional	1.4
`coal_quality_heat_content_btu_per_lb`	float	Heat content of coal in BTU per pound0 or more · optional	12400
`coal_quality_ash_content_pct`	float	Ash content in coal as a percentage0 to 100 · optional	8.9
`coal_quality_moisture_pct`	float	Moisture content in coal as a percentage0 to 100 · optional	6.3
`coal_quality_adjustment_amount`	float	Adjustment amount (USD/ton) applied to price due to coal quality deviationsoptional	0.45
Dates and times 2 columns
`contract_start_date`	date	Start date of the coal purchase contract	2023-01-01
`contract_end_date`	date	End date of the coal purchase contract	2023-12-31

Use it for

An energy dashboard
Coal_quality_moisture_pct by coal_type and a breakdown of buyer_address_state. Excel, Power BI or Tableau.
Why do the 10 lignite rows have a mean coal_quality_moisture_pct of 25.3?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
Contracts100
CT202400016.3bitumino…
CT2024000229.5lignite
CT2024000313.8sub-bitu…
A software demo
Believable contracts with buyer_name, buyer_address_street and buyer_address_city to fill a screen in front of a buyer.

This dataset100 rows30 columns

Yours1,000 rows30 columnsbuyer_address_street: UK only

blueprint · coal-pricing-and-transportation-costs

Behind this dataset

Same schema. As many rows as you need.

These 100 rows came out of a blueprint — 30 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with

Contract ID, supplier/mine name, and coal basin (Powder River, Illinois, Appalachian)
Contract price in $/ton or $/MMBtu with heat content adjustment
Transportation cost: rail freight ($/ton-mile), barge, truck
Total delivered cost = mine cost + transportation cost
Quality adjustments: heat content, sulfur, moisture penalties/bonuses
Contract type: spot purchase, term contract (1-5 years)
Force majeure provisions for mine strikes or rail disruptions
Coal switching economics: coal vs. natural gas dispatch decisions

Rows1,000 rows10,000 rows100,000 rows1,000,000 rows

Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports: CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence: yours to use, including commercially
API slug: coal-pricing-and-transportation-costs

What should your data show?

No signup. No card.

Sample rows

What the 100 rows show

Columns

Use it for

An energy dashboard

A root-cause class exercise

A software demo

Make it yours.

Same schema. As many rows as you need.

More in Energy

What should your data show?