Renewable energy generation
===========================

Daily generation from 80 solar, wind and small-hydro plants in the states where those resources are strongest, with the tariffs they sell at and the outages that cut output. Solar dips in the monsoon while wind and hydro peak, which is why a mixed portfolio smooths supply.

Category: Sports & Energy
Licence: CC0-1.0
Synthetic data generated by DataStride. States and seasonal patterns are real; plants, owners and figures are fictional.
Build: 940aea8e3b2c8169

ren_developers (12 rows)
  developer_id           INTEGER        [key] Developer identifier.
  developer_name         VARCHAR(60)    Owner (fictional).
  ownership              VARCHAR(12)    Private or public sector.

ren_plants (80 rows)
  plant_id               INTEGER        [key] Plant identifier.
  developer_id           INTEGER        -> ren_developers.developer_id Owner.
  technology             VARCHAR(12)    Technology.
  state                  VARCHAR(40)    State.
  capacity_mw            DECIMAL(8,2)   Installed capacity, MW.
  commissioned_on        DATE           Commercial operation date.

ren_tariffs (80 rows)
  plant_id               INTEGER        [key] -> ren_plants.plant_id Plant the tariff applies to.
  buyer                  VARCHAR(30)    Who buys the power.
  tariff_per_kwh         DECIMAL(6,2)   Contracted price, INR per kWh.
  contract_years         INTEGER        Length of the power purchase agreement.

ren_generation (4841 rows)
  reading_id             INTEGER        [key] Reading identifier.
  plant_id               INTEGER        -> ren_plants.plant_id Plant.
  reading_date           DATE           Day of generation.
  generation_mwh         DECIMAL(10,2)  Energy delivered that day, MWh.
  curtailed_mwh          DECIMAL(10,2)  Energy the grid refused, MWh.

ren_outages (400 rows)
  outage_id              INTEGER        [key] Outage identifier.
  plant_id               INTEGER        -> ren_plants.plant_id Plant affected.
  started_on             DATE           Outage start.
  hours                  DECIMAL(8,1)   Duration, hours.
  cause                  VARCHAR(30)    Cause.
