PG&E Gas System Daily Balance

Long format, one row per gas_day and field, named exactly as PG&E names it; fields have come and gone over the years. value is numeric and value_text keeps a non-numeric cell. The unit column says MMcf/d on every flow and stock alike: inventories are MMcf. The newest gas day is PG&E's plan for today, not a settled day, and the three before it are still restated; PG&E's forecast for the next days is pge_cgt.plan_snapshots. Fields, as PG&E labels them: Demand_Sys = Total system demand (demand, MMcf/d); System_Demand = On-system demand (demand, MMcf/d); Core = Core demand (demand, MMcf/d); NonCore_Elec_Gen = Noncore electric generation (demand, MMcf/d); NonCore_Industrial = Noncore industrial (demand, MMcf/d); Core_Forecast = Core demand, PG&E's forecast for the day (demand, MMcf/d); NonCore_Elec_Gen_Forecast = Noncore electric generation, PG&E's forecast for the day (demand, MMcf/d); NonCore_Industrial_Forecast = Noncore industrial, PG&E's forecast for the day (demand, MMcf/d); KRS_SoCal = Off-system: to SoCalGas (Kern River Station) (demand, MMcf/d); SwGas = Off-system: Southwest Gas (demand, MMcf/d); Kj_out = Off-system: to Kern River (High Desert Lateral) (demand, MMcf/d); SoCalOut = Off-system: to SoCalGas (demand, MMcf/d, legacy); F_Luaf = Transmission shrinkage (demand, MMcf/d); Supply_Sys = Total system supply (supply, MMcf/d); PgtNW = Gas Transmission Northwest (Malin) (supply, MMcf/d); Ruby = Ruby (Malin) (supply, MMcf/d); Epng = El Paso Natural Gas (supply, MMcf/d); Tw = Transwestern (supply, MMcf/d); Krgt = Kern River (Daggett) (supply, MMcf/d); Kj_In = Kern River (High Desert Lateral) (supply, MMcf/d); Southern_Trails = Southern Trails (supply, MMcf/d); SoCal_KRS = From SoCalGas (Kern River Station) (supply, MMcf/d); Calif = California production (supply, MMcf/d); Ruby_Sch = Ruby, scheduled (supply, MMcf/d, legacy); PGE_Stor_Inv = PG&E total gas in storage (storage, MMcf); PGE_Working_Gas_in_Storage = PG&E working gas in storage (storage, MMcf); PGE_Base_Gas_in_Storage = PG&E base gas in storage (storage, MMcf); IMB_Data_6pts = Imbalance gas in storage (storage, MMcf); Net_Injection = PG&E storage injection (core, market center, balancing) (storage, MMcf/d); Net_Withdrawa = PG&E storage withdrawal (core, market center, balancing) (storage, MMcf/d); Injection = PG&E storage injection, core and market center (storage, MMcf/d); Withdrawal = PG&E storage withdrawal, core and market center (storage, MMcf/d); Bal_Injection = Pipeline balancing injection (storage, MMcf/d); Bal_Withdrawal = Pipeline balancing withdrawal (storage, MMcf/d); WG_Net_Inj = Wild Goose net injection (storage, MMcf/d); WG_Net_Wd = Wild Goose net withdrawal (storage, MMcf/d); WildG_Out = Wild Goose gross injection (storage, MMcf/d); WildG_in = Wild Goose gross withdrawal (storage, MMcf/d); Lodi_Net_Inj = Lodi net injection (storage, MMcf/d); Lodi_Net_Wd = Lodi net withdrawal (storage, MMcf/d); Lodi_Out = Lodi gross injection (storage, MMcf/d); Lodi_In = Lodi gross withdrawal (storage, MMcf/d); CVGS_Inj_Phys = Central Valley Storage injection (storage, MMcf/d); CVGS_WD_Phys = Central Valley Storage withdrawal (storage, MMcf/d); CVGS_Inj_Sched = Central Valley Storage injection, scheduled (storage, MMcf/d); CVGS_WD_Sched = Central Valley Storage withdrawal, scheduled (storage, MMcf/d); GillRanch_Inj = Gill Ranch injection (storage, MMcf/d); GillRanch_WD = Gill Ranch withdrawal (storage, MMcf/d); GRS_LLC_Inj = Gill Ranch Storage LLC injection (storage, MMcf/d); GRS_LLC_WD = Gill Ranch Storage LLC withdrawal (storage, MMcf/d); Inv_Begin = Beginning system inventory (linepack, MMcf); Inv_End = Ending system inventory (linepack, MMcf); MaxInventory = System inventory upper limit (linepack, MMcf); MinInventory = System inventory lower limit (linepack, MMcf); Inv_Target = System inventory target (linepack, MMcf); Cust_Imbal = Total customer imbalance (balancing, MMcf/d); Redwood_Phys_Cap = Redwood path capacity (capacity, MMcf/d); Phys_PGT_NW = Capacity from Gas Transmission Northwest (capacity, MMcf/d); Ruby_Phys_Cap = Capacity from Ruby (capacity, MMcf/d); Topock_Phys_Cap = Baja path capacity, Topock (capacity, MMcf/d); Baja_HinkleyNorth_Capacity = Baja path capacity, Hinkley (capacity, MMcf/d); Baja_KN_Capacity = Baja path capacity, Kettleman (capacity, MMcf/d); El_Paso_Phys = Capacity from El Paso Natural Gas (capacity, MMcf/d); TW_Phys_Cap = Capacity from Transwestern (capacity, MMcf/d); From_KRGT_Kj_Phys = Capacity from Kern River (High Desert Lateral) (capacity, MMcf/d); KRGT_Daggett_Phys = Capacity from Kern River (Daggett) (capacity, MMcf/d); Phys_From_SoCal = Capacity from SoCalGas (capacity, MMcf/d); Phys_To_SoCal = Capacity to SoCalGas (capacity, MMcf/d); To_KRGT_Kj_Phys = Capacity to Kern River (High Desert Lateral) (capacity, MMcf/d); Phys_From_EPNG = Physical capacity from El Paso (legacy field) (capacity, MMcf/d, legacy); Phys_From_KRP = Physical capacity from Kern River (legacy field) (capacity, MMcf/d, legacy); Phys_From_TW = Physical capacity from Transwestern (legacy field) (capacity, MMcf/d, legacy); Phys_Baja_HinkleyNorth = Physical Baja capacity, Hinkley (legacy field) (capacity, MMcf/d, legacy); MeanTemp = Composite temperature (weather, °F). Published by PG&E.

Query contract

Preserve one canonical row per (gas_day, field) before aggregating.

Analysis rules

Read with FINAL: one row per (gas_day, field).Filter field by its exact PG&E name; fields are not additive across categories (inventory is a stock, receipts and demand are flows).

Interpretation

These are PG&E's own settled operations for its system only, not California-wide gas demand; SoCalGas is a separate system.Published by PG&E; attribute it to PG&E whenever it is reported.

Download

Query it in SQL, download it, or read it with an API key. Download data

MCP

Connect an MCP client and load the contract with describe_data before calling query_data.CAISO MCPAPI reference

HTTP endpoint

POST /api/v1/datasets/pge_cgt_daily_operations/query

Full history

Delivered to Snowflake, Databricks or your own storage on a schedule by Data services.

More coverage

Request data coverage

Complete

99.8%

Gap days

20

Days with data

10,451