Skip to content

Instantly share code, notes, and snippets.

@carlaiau

carlaiau/gist:44aaff6a4329bf807850a1a310dfb3ec

Last active January 14, 2021 00:32
Show Gist options
  • Save carlaiau/44aaff6a4329bf807850a1a310dfb3ec to your computer and use it in GitHub Desktop.
Save carlaiau/44aaff6a4329bf807850a1a310dfb3ec to your computer and use it in GitHub Desktop.
Download ZIP
#1971 Test 2.0
Raw
gistfile1.json
{
"status": "success",
"count": 13,
"type": "TariffRate",
"results": [
{
"tariffRateId": 18274059,
"tariffId": 3358751,
"rateGroupName": "Consumption",
"rateName": "Energy Surcharge",
"fromDateTime": "2020-05-11T00:00:00-07:00",
"toDateTime": null,
"chargeType": "CONSUMPTION_BASED",
"chargePeriod": "MONTHLY",
"applicabilityKey": "hasCAEnergySurchargeExemption",
"rateBands": [
{
"tariffRateBandId": 12196936,
"tariffRateId": 18274059,
"rateSequenceNumber": 1,
"hasConsumptionLimit": false,
"hasDemandLimit": false,
"hasPropertyLimit": false,
"applicabilityValue": "false",
"rateAmount": 0.000300,
"rateUnit": "COST_PER_UNIT",
"isCredit": false,
"prevUpperLimit": null
}
]
},
{
"tariffRateId": 18716715,
"tariffId": 3358751,
"rateGroupName": "Consumption",
"rateName": "Energy Charge",
"fromDateTime": "2020-05-11T00:00:00-07:00",
"toDateTime": null,
"chargeType": "CONSUMPTION_BASED",
"chargePeriod": "MONTHLY",
"applicabilityKey": "renewableOption101199",
"rateBands": [
{
"tariffRateBandId": 12833766,
"tariffRateId": 18716715,
"rateSequenceNumber": 1,
"hasConsumptionLimit": false,
"hasDemandLimit": false,
"hasPropertyLimit": false,
"applicabilityValue": "36% Renewable",
"rateAmount": 0.069920,
"rateUnit": "COST_PER_UNIT",
"isCredit": false,
"prevUpperLimit": null
}
]
},
{
"tariffRateId": 18679500,
"tariffId": 3358751,
"rateGroupName": "Consumption",
"rateName": "Utility Retained Generation - Summer - Baseline Region 5",
"fromDateTime": "2020-05-11T00:00:00-07:00",
"toDateTime": null,
"season": {
"seasonId": 276,
"lseId": 1228,
"seasonGroupId": 1,
"seasonName": "Summer",
"seasonFromMonth": 6,
"seasonFromDay": 1,
"seasonToMonth": 9,
"seasonToDay": 30
},
"chargeType": "CONSUMPTION_BASED",
"chargePeriod": "MONTHLY",
"variableLimitKey": "consumptionTiersCaliforniaWithMedicalAllowanceSCE",
"rateBands": [
{
"tariffRateBandId": 12776718,
"tariffRateId": 18679500,
"rateSequenceNumber": 1,
"hasConsumptionLimit": true,
"consumptionUpperLimit": 17.2,
"hasDemandLimit": false,
"hasPropertyLimit": true,
"propertyUpperLimit": 1.000000,
"rateAmount": 0.00087928704,
"rateUnit": "COST_PER_UNIT",
"isCredit": false,
"prevUpperLimit": null
},
{
"tariffRateBandId": 12776719,
"tariffRateId": 18679500,
"rateSequenceNumber": 2,
"hasConsumptionLimit": true,
"consumptionUpperLimit": 17.2,
"hasDemandLimit": false,
"hasPropertyLimit": true,
"propertyUpperLimit": 4.000000,
"rateAmount": 0.00087928704,
"rateUnit": "COST_PER_UNIT",
"isCredit": false,
"prevUpperLimit": null
},
{
"tariffRateBandId": 12776720,
"tariffRateId": 18679500,
"rateSequenceNumber": 3,
"hasConsumptionLimit": true,
"hasDemandLimit": false,
"hasPropertyLimit": true,
"rateAmount": 0.00087928704,
"rateUnit": "COST_PER_UNIT",
"isCredit": false,
"prevUpperLimit": null
}
]
},
{
"tariffRateId": 18679501,
"tariffId": 3358751,
"rateGroupName": "Consumption",
"rateName": "Utility Retained Generation - Winter - Baseline Region 5",
"fromDateTime": "2020-05-11T00:00:00-07:00",
"toDateTime": null,
"season": {
"seasonId": 277,
"lseId": 1228,
"seasonGroupId": 1,
"seasonName": "Winter",
"seasonFromMonth": 10,
"seasonFromDay": 1,
"seasonToMonth": 5,
"seasonToDay": 31
},
"chargeType": "CONSUMPTION_BASED",
"chargePeriod": "MONTHLY",
"variableLimitKey": "consumptionTiersCaliforniaWithMedicalAllowanceSCE",
"rateBands": [
{
"tariffRateBandId": 12776721,
"tariffRateId": 18679501,
"rateSequenceNumber": 1,
"hasConsumptionLimit": true,
"consumptionUpperLimit": 18.7,
"hasDemandLimit": false,
"hasPropertyLimit": true,
"propertyUpperLimit": 1.000000,
"rateAmount": 0.00087928704,
"rateUnit": "COST_PER_UNIT",
"isCredit": false,
"prevUpperLimit": null
},
{
"tariffRateBandId": 12776722,
"tariffRateId": 18679501,
"rateSequenceNumber": 2,
"hasConsumptionLimit": true,
"consumptionUpperLimit": 18.7,
"hasDemandLimit": false,
"hasPropertyLimit": true,
"propertyUpperLimit": 4.000000,
"rateAmount": 0.00087928704,
"rateUnit": "COST_PER_UNIT",
"isCredit": false,
"prevUpperLimit": null
},
{
"tariffRateBandId": 12776723,
"tariffRateId": 18679501,
"rateSequenceNumber": 3,
"hasConsumptionLimit": true,
"hasDemandLimit": false,
"hasPropertyLimit": true,
"rateAmount": 0.00087928704,
"rateUnit": "COST_PER_UNIT",
"isCredit": false,
"prevUpperLimit": null
}
]
},
{
"tariffRateId": 17021357,
"tariffId": 3358751,
"rateGroupName": "Quantity Based",
"rateName": "PTR Credit",
"fromDateTime": "2020-05-11T00:00:00-07:00",
"toDateTime": null,
"chargeType": "QUANTITY",
"chargePeriod": "MONTHLY",
"quantityKey": "peakTimeRebateConsumption",
"applicabilityKey": "hasPeakTimeRebateforSCE",
"rateBands": [
{
"tariffRateBandId": 10233191,
"tariffRateId": 17021357,
"rateSequenceNumber": 3,
"hasConsumptionLimit": false,
"hasDemandLimit": false,
"hasPropertyLimit": false,
"applicabilityValue": "None",
"rateAmount": 0.000000,
"rateUnit": "COST_PER_UNIT",
"isCredit": false,
"prevUpperLimit": null
}
]
},
{
"tariffRateId": 18729964,
"tariffId": 3358751,
"rateGroupName": "Consumption",
"rateName": "Consumption",
"fromDateTime": "2020-06-01T00:00:00-07:00",
"toDateTime": null,
"chargeType": "CONSUMPTION_BASED",
"chargePeriod": "MONTHLY",
"applicabilityKey": "vintageYearCRS",
"rateBands": [
{
"tariffRateBandId": 12849400,
"tariffRateId": 18729964,
"rateSequenceNumber": 12,
"hasConsumptionLimit": false,
"hasDemandLimit": false,
"hasPropertyLimit": false,
"applicabilityValue": "2019 Vintage",
"rateAmount": 0.023380,
"rateUnit": "COST_PER_UNIT",
"isCredit": false,
"prevUpperLimit": null
}
]
},
{
"tariffRateId": 18813601,
"tariffId": 3358751,
"rateGroupName": "Fixed",
"rateName": "Basic Charge",
"fromDateTime": "2020-10-01T00:00:00-07:00",
"toDateTime": null,
"chargeType": "FIXED_PRICE",
"chargePeriod": "DAILY",
"applicabilityKey": "residentialType",
"rateBands": [
{
"tariffRateBandId": 12958998,
"tariffRateId": 18813601,
"rateSequenceNumber": 1,
"hasConsumptionLimit": false,
"hasDemandLimit": false,
"hasPropertyLimit": false,
"applicabilityValue": "Single-Family Residence",
"rateAmount": 0.031000,
"rateUnit": "COST_PER_UNIT",
"isCredit": false,
"prevUpperLimit": null
}
]
},
{
"tariffRateId": 18813644,
"tariffId": 3358751,
"rateGroupName": "Fixed",
"rateName": "California Climate Credit",
"fromDateTime": "2020-10-01T00:00:00-07:00",
"toDateTime": null,
"chargeType": "FIXED_PRICE",
"chargePeriod": "DAILY",
"variableRateKey": "californiaClimateCreditSCE",
"rateBands": [
{
"tariffRateBandId": 12959116,
"tariffRateId": 18813644,
"rateSequenceNumber": 1,
"hasConsumptionLimit": false,
"hasDemandLimit": false,
"hasPropertyLimit": false,
"rateAmount": 0.000000,
"rateUnit": "COST_PER_UNIT",
"isCredit": false,
"prevUpperLimit": null
}
]
},
{
"tariffRateId": 18813608,
"tariffId": 3358751,
"rateGroupName": "Consumption",
"rateName": "Consumption Summer",
"fromDateTime": "2020-10-01T00:00:00-07:00",
"toDateTime": null,
"season": {
"seasonId": 276,
"lseId": 1228,
"seasonGroupId": 1,
"seasonName": "Summer",
"seasonFromMonth": 6,
"seasonFromDay": 1,
"seasonToMonth": 9,
"seasonToDay": 30
},
"chargeType": "CONSUMPTION_BASED",
"chargePeriod": "MONTHLY",
"variableLimitKey": "consumptionTiersCaliforniaWithMedicalAllowanceSCE",
"rateBands": [
{
"tariffRateBandId": 12959008,
"tariffRateId": 18813608,
"rateSequenceNumber": 1,
"hasConsumptionLimit": true,
"consumptionUpperLimit": 17.2,
"hasDemandLimit": false,
"hasPropertyLimit": true,
"propertyUpperLimit": 1.000000,
"rateAmount": 0.100870,
"rateUnit": "COST_PER_UNIT",
"isCredit": false,
"prevUpperLimit": null
},
{
"tariffRateBandId": 12959009,
"tariffRateId": 18813608,
"rateSequenceNumber": 2,
"hasConsumptionLimit": true,
"consumptionUpperLimit": 17.2,
"hasDemandLimit": false,
"hasPropertyLimit": true,
"propertyUpperLimit": 4.000000,
"rateAmount": 0.152290,
"rateUnit": "COST_PER_UNIT",
"isCredit": false,
"prevUpperLimit": null
},
{
"tariffRateBandId": 12959010,
"tariffRateId": 18813608,
"rateSequenceNumber": 3,
"hasConsumptionLimit": true,
"hasDemandLimit": false,
"hasPropertyLimit": true,
"rateAmount": 0.359973,
"rateUnit": "COST_PER_UNIT",
"isCredit": false,
"prevUpperLimit": null
}
]
},
{
"tariffRateId": 18813609,
"tariffId": 3358751,
"rateGroupName": "Consumption",
"rateName": "Consumption Winter",
"fromDateTime": "2020-10-01T00:00:00-07:00",
"toDateTime": null,
"season": {
"seasonId": 277,
"lseId": 1228,
"seasonGroupId": 1,
"seasonName": "Winter",
"seasonFromMonth": 10,
"seasonFromDay": 1,
"seasonToMonth": 5,
"seasonToDay": 31
},
"chargeType": "CONSUMPTION_BASED",
"chargePeriod": "MONTHLY",
"variableLimitKey": "consumptionTiersCaliforniaWithMedicalAllowanceSCE",
"rateBands": [
{
"tariffRateBandId": 12959011,
"tariffRateId": 18813609,
"rateSequenceNumber": 1,
"hasConsumptionLimit": true,
"consumptionUpperLimit": 18.7,
"hasDemandLimit": false,
"hasPropertyLimit": true,
"propertyUpperLimit": 1.000000,
"rateAmount": 0.100870,
"rateUnit": "COST_PER_UNIT",
"isCredit": false,
"prevUpperLimit": null
},
{
"tariffRateBandId": 12959012,
"tariffRateId": 18813609,
"rateSequenceNumber": 2,
"hasConsumptionLimit": true,
"consumptionUpperLimit": 18.7,
"hasDemandLimit": false,
"hasPropertyLimit": true,
"propertyUpperLimit": 4.000000,
"rateAmount": 0.162290,
"rateUnit": "COST_PER_UNIT",
"isCredit": false,
"prevUpperLimit": null
},
{
"tariffRateBandId": 12959013,
"tariffRateId": 18813609,
"rateSequenceNumber": 3,
"hasConsumptionLimit": true,
"hasDemandLimit": false,
"hasPropertyLimit": true,
"rateAmount": 0.369973,
"rateUnit": "COST_PER_UNIT",
"isCredit": false,
"prevUpperLimit": null
}
]
},
{
"tariffRateId": 18813604,
"tariffId": 3358751,
"rateGroupName": "Consumption",
"rateName": "Consumption",
"fromDateTime": "2020-10-01T00:00:00-07:00",
"toDateTime": null,
"chargeType": "CONSUMPTION_BASED",
"chargePeriod": "HOURLY",
"rateBands": [
{
"tariffRateBandId": 12959004,
"tariffRateId": 18813604,
"rateSequenceNumber": 1,
"hasConsumptionLimit": false,
"hasDemandLimit": false,
"hasPropertyLimit": false,
"rateAmount": 0.012730,
"rateUnit": "COST_PER_UNIT",
"isCredit": false,
"prevUpperLimit": null
}
]
},
{
"tariffRateId": 18813607,
"tariffId": 3358751,
"rateGroupName": "Consumption",
"rateName": "DWR Bond Charge",
"fromDateTime": "2020-10-01T00:00:00-07:00",
"toDateTime": null,
"chargeType": "CONSUMPTION_BASED",
"chargePeriod": "HOURLY",
"applicabilityKey": "hasMedicalBaselineExemption",
"rateBands": [
{
"tariffRateBandId": 12959007,
"tariffRateId": 18813607,
"rateSequenceNumber": 1,
"hasConsumptionLimit": false,
"hasDemandLimit": false,
"hasPropertyLimit": false,
"applicabilityValue": "false",
"rateAmount": 0.005800,
"rateUnit": "COST_PER_UNIT",
"isCredit": false,
"prevUpperLimit": null
}
]
},
{
"tariffRateId": 18813646,
"tariffId": 3358751,
"rateGroupName": "Minimum",
"rateName": "Minimum Charge",
"fromDateTime": "2020-10-01T00:00:00-07:00",
"toDateTime": null,
"chargeType": "MINIMUM",
"chargePeriod": "DAILY",
"applicabilityKey": "residentialType",
"rateBands": [
{
"tariffRateBandId": 12959118,
"tariffRateId": 18813646,
"rateSequenceNumber": 1,
"hasConsumptionLimit": false,
"hasDemandLimit": false,
"hasPropertyLimit": false,
"applicabilityValue": "Single-Family Residence",
"rateAmount": 0.346000,
"rateUnit": "COST_PER_UNIT",
"isCredit": false,
"prevUpperLimit": null
}
]
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment