Coal Inventory and Deliveries to Power Plants
This dataset provides comprehensive records of coal stockpile inventories and delivery events at power plants, including tonnage, delivery method, fuel quality metrics (heat content, sulfur, ash), and burn rates. It enables detailed analysis of fuel security, supply chain logistics, and emissions compliance for energy producers and regulators.
Sample rows
preview · 8 of 105 rows · all 17 columns| plant_idstring | delivery_methodstring | coal_heat_content_btu_per_lbfloat | plant_statestring | plant_namestring | plant_street_addressstring | plant_citystring | plant_postal_codestring | plant_countrystring | inventory_datedate | coal_stockpile_tonnagefloat | coal_delivery_idstring | delivery_datedate | delivery_tonnagefloat | coal_sulfur_content_pctfloat | coal_ash_content_pctfloat | burn_rate_tons_per_dayfloat |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| PLNT001 | barge | 13260 | KY | Paducah River Energy Station | 159 Riverfront Dr | Paducah | 42001 | USA | 2022-02-11 | 320000 | DEL10001 | 2022-02-09 | 97000 | 2.1 | 13.2 | 2100 |
| PLNT002 | rail | 13920 | TX | South Houston Power Plant | 1080 Bay Dr | Houston | 77017 | USA | 2023-03-03 | 1450000 | DEL10002 | 2023-02-28 | 580000 | 3.7 | 22.5 | 5700 |
| PLNT003 | barge | 12550 | OH | Lake Erie Utilities Station | 3201 Harbor Rd | Cleveland | 44102 | USA | 2021-05-13 | 89000 | DEL10003 | 2021-05-10 | 37500 | 1.5 | 11.8 | 1200 |
| PLNT004 | truck | 10210 | AZ | Desert Valley Power Plant | blank | Phoenix | 85034 | USA | 2021-11-20 | 1450 | DEL10004 | 2021-11-18 | 560 | 0.8 | 4.2 | 95 |
| PLNT005 | rail | 13740 | IL | Chicagoland Energy Plant | 1010 Southport Ave | Chicago | 60616 | USA | 2024-01-15 | 2100000 | DEL10005 | 2024-01-13 | 790000 | 4.5 | 27.9 | 6900 |
| PLNT006 | truck | 10190 | HI | Honolulu Utilities Plant | N/A | Honolulu | 96819 | USA | 2023-08-14 | 1100 | DEL10006 | 2023-08-12 | 480 | 0.3 | 3.1 | 40 |
| PLNT007 | truck | 9630 | CA | San Francisco Bay Power | 1800 Wharf St | San Francisco | 94124 | USA | 2022-06-07 | 1200 | DEL10007 | 2022-06-06 | 320 | 0.4 | 5.9 | 35 |
| PLNT008 | rail | 11520 | KS | Kansas Prairie Utilities | 2831 Wheatfield Rd | Wichita | 67213 | USA | 2021-07-14 | 33000 | DEL10008 | 2021-07-12 | 11000 | 1.1 | 7.5 | 1400 |
| PLNT009 | rail | 12300 | MN | Twin Cities Energy Plant | 4157 North Ave | Minneapolis | 55412 | USA | 2022-03-19 | 77000 | DEL10009 | 2022-03-15 | 24000 | 1.3 | 8.9 | 1000 |
| PLNT010 | barge | 10280 | WA | Seattle Port Utilities | N/A | Seattle | 98108 | USA | 2023-04-24 | 1240 | DEL10010 | 2023-04-20 | 900 | 1 | 6 | 90 |
| PLNT011 | rail | 12840 | OH | Ohio Valley Power Station | 7287 Industrial Pkwy | Columbus | 43228 | USA | 2022-09-02 | 125000 | DEL10011 | 2022-08-30 | 58000 | 2.5 | 12.1 | 1800 |
| PLNT012 | barge | 12580 | LA | Baton Rouge Utilities | 4221 River Rd | Baton Rouge | 70805 | USA | 2021-12-04 | 92000 | DEL10012 | 2021-12-01 | 33000 | 2.9 | 9.7 | 1200 |
| PLNT013 | barge | 12640 | MO | St. Louis River Power | 1333 Wharf St | St. Louis | 63103 | USA | 2022-07-05 | 115000 | DEL10013 | 2022-07-02 | 41000 | 2.3 | 11 | 1400 |
| PLNT014 | rail | 11860 | NE | Omaha Plains Energy | 3310 Cornhusker Hwy | Omaha | 68107 | USA | 2021-08-29 | 49000 | DEL10014 | 2021-08-28 | 16000 | 1 | 6.9 | 1200 |
| PLNT015 | rail | 11680 | MI | Detroit Metro Station | 2255 Industrial Ave | Detroit | 48216 | USA | 2023-05-11 | 22000 | DEL10015 | 2023-05-09 | 9000 | 0.7 | 5 | 800 |
| PLNT016 | rail | 12030 | OK | Tulsa Energy Plant | 5500 Riverside Dr | Tulsa | 74105 | USA | 2022-10-10 | 62000 | DEL10016 | 2022-10-09 | 20000 | 1.2 | 8.8 | 1200 |
| PLNT017 | rail | 14100 | PA | Pittsburgh Utilities | 4333 Steel Blvd | Pittsburgh | 15222 | USA | 2021-03-07 | 1640000 | DEL10017 | 2021-03-05 | 530000 | 4.8 | 35.7 | 6600 |
| PLNT018 | truck | 11250 | CO | Denver Mountain Station | 9200 Peak St | Denver | 80216 | USA | 2022-12-22 | 42000 | DEL10018 | 2022-12-21 | 1200 | 0.9 | 5.4 | 200 |
| PLNT019 | barge | 12680 | TN | Riverbend Power Station | 3011 River Rd | Memphis | 38109 | USA | 2021-10-15 | 99000 | DEL10019 | 2021-10-13 | 32000 | 2.4 | 10.9 | 1300 |
| PLNT020 | truck | 11380 | AL | Birmingham Utilities | 2020 Iron St | Birmingham | 35204 | USA | 2022-01-21 | 68000 | DEL10020 | 2022-01-20 | 1800 | 1 | 6.1 | 190 |
What the 105 rows show
from the 105-row sampleTruck (delivery method) stands out: mean coal_
- 12,100median coal_
heat_ content_ btu_ per_ lb - 67,000median coal_
stockpile_ tonnage - 18,100median delivery_
tonnage - 1.6median coal_
sulfur_ content_ pct - 8.8median coal_
ash_ content_ pct - 1,020median burn_
rate_ tons_ per_ day
Median 12,100, from 8,510 to 14,500.
- string 9
- float 6
- date 2
Columns
17 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 9 columns | |||
plant_id | string | Unique identifier for the power plant or generating station | PLNT001 |
plant_name | string | Name of the power plant or generating station | Chicagoland Energy Plant |
plant_street_address | string | Street address of the power plantoptional | 159 Riverfront Dr |
plant_city | string | City where the power plant is locatedoptional | Paducah |
plant_state | string | State or province where the power plant is locatedoptional | KY |
plant_postal_code | string | Postal code of the power plant locationoptional | 42001 |
plant_country | string | Country where the power plant is locatedoptional | USA |
coal_delivery_id | string | Unique identifier for the coal delivery eventunique | DEL10001 |
delivery_method | string | Method of coal delivery (rail, barge, truck)rail · barge · truck | barge |
| Numbers 6 columns | |||
coal_stockpile_tonnage | float | Total coal stockpile inventory in tons at the plant on the inventory date0 or more | 320000 |
delivery_tonnage | float | Amount of coal delivered in tons0 or more | 97000 |
coal_heat_content_btu_per_lb | float | Heat content of delivered coal in British thermal units per pound (Btu/lb)0 or more | 13260 |
coal_sulfur_content_pct | float | Sulfur content of delivered coal as a percentage by weight0 to 100 | 2.1 |
coal_ash_content_pct | float | Ash content of delivered coal as a percentage by weight0 to 100 | 13.2 |
burn_rate_tons_per_day | float | Average daily burn rate of coal at the plant in tons per day0 or more | 2100 |
| Dates and times 2 columns | |||
inventory_date | date | Date of coal inventory measurement | 2022-02-11 |
delivery_date | date | Date when coal delivery was received | 2022-02-09 |
Use it for
An energy dashboard
Coal_
heat_ content_ btu_ per_ lb by delivery_ method and a breakdown of plant_ state. Excel, Power BI or Tableau. Why do the 32 truck rows have a mean coal_
heat_ content_ btu_ per_ lb of 9,884? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Plants105PLNT00113260bargePLNT00213920railPLNT00312550barge
A software demo
Believable plants with plant_
name, plant_ street_ address and plant_ city to fill a screen in front of a buyer.
blueprint · coal-inventory-and-deliveries-to-power-plants
Behind this dataset
Same schema. As many rows as you need.
These 105 rows came out of a blueprint — 17 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.
- Plant name and generating unit ID
- Coal type: bituminous, sub-bituminous, lignite, anthracite
- Inventory level (tons on-site) and days of supply at current burn rate
- Coal deliveries: tonnage, delivery method (unit train, barge, truck)
- Heat content (Btu/lb), typically 8,000-13,000 Btu/lb depending on coal rank
- Sulfur content (%) for SO2 emissions compliance
- Ash content (%) and ash disposal considerations
- Target inventory levels for fuel security (30-60 days supply)
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-inventory-and-deliveries-to-power-plants