taxonomy().concept(ferc:RespondentLegalName).label("http://ferc.gov/form/2020-01-01/roles/label/F6Header").text Name of Respondent:

first(list([@ferc:RespondentLegalName @period=$currentDuration])) Duke Energy Kentucky, Inc.
taxonomy().concept(ferc:SubmissionType).label("http://ferc.gov/form/2020-01-01/roles/label/F6Header").text This report is:

(1) if missing({covered @concept=ferc:SubmissionType}) ☐ An Original']]> else if [@concept=ferc:SubmissionType @period=$currentDuration] == "O" ☑ An Original']]> else ☐ An Original']]> An Original

(2) if missing([covered @concept=ferc:SubmissionType @period=$currentDuration]) ☐ A Resubmission']]> else if [@concept=ferc:SubmissionType @period=$currentDuration] == "R" ☑ A Resubmission']]> else ☐ A Resubmission']]> A Resubmission
taxonomy().concept(ferc:ReportDate).label("http://ferc.gov/form/2020-01-01/roles/label/F6Header").text Date of Report:

first(list([@ferc:ReportDate @period=$currentDuration])) 04/26/2019
taxonomy().concept(ferc:ReportYearPeriod).label("http://ferc.gov/form/2020-01-01/roles/label/F6Header").text Year/Period of Report:

End of: first(list([@ferc:ReportYear @period=$currentDuration])) 2018 / first(list([@ferc:ReportPeriod @period=$currentDuration])) Q4
// adding a comment $data2 = list(for $i in range(14) list($i,none,none,none,none,none,none,none,none,none,none) ); $data = if count(list({covered @ferc:StateOfOriginAndProductTypeAxis=*})) > 0 list({covered @ferc:StateOfOriginAndProductTypeAxis=* {list( if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0 first(list({@ferc:OrderNumber @unit=* @period=$currentDuration})) else 0, if exists({@ferc:StateOfOrigin @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @unit@period=$currentDuration}) first(list({@ferc:StateOfOrigin @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @unit @period=$currentDuration})) else none, if exists({@ferc:RefinedProductType @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @unit@period=$currentDuration}) first(list({@ferc:RefinedProductType @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @unit @period=$currentDuration})) else none, if exists({@ferc:NumberOfBarrelsReceivedFromConnectingCarriers @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @unit @period=$currentDuration}) first(list({@ferc:NumberOfBarrelsReceivedFromConnectingCarriers @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @unit @period=$currentDuration})) else none, if exists({@ferc:NumberOfBarrelsReceivedOnGatheringLines @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @unit @period=$currentDuration}) first(list({@ferc:NumberOfBarrelsReceivedOnGatheringLines @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @unit @period=$currentDuration})) else none, if exists({@ferc:NumberOfBarrelsReceivedOnTrunkLines @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @unit @period=$currentDuration}) first(list({@ferc:NumberOfBarrelsReceivedOnTrunkLines @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @unit @period=$currentDuration})) else none, if exists({@ferc:NumberOfBarrelsReceived @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @unit @period=$currentDuration}) first(list({@ferc:NumberOfBarrelsReceived @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @unit @period=$currentDuration})) else none, if exists({@ferc:NumberOfBarrelsDeliveredOutToConnectingCarriers @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @unit @period=$currentDuration}) first(list({@ferc:NumberOfBarrelsDeliveredOutToConnectingCarriers @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @unit @period=$currentDuration})) else none, if exists({@ferc:NumberOfBarrelsDeliveredOutOnGatheringLines @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @unit @period=$currentDuration}) first(list({@ferc:NumberOfBarrelsDeliveredOutOnGatheringLines @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @unit @period=$currentDuration})) else none, if exists({@ferc:NumberOfBarrelsDeliveredOutOnTrunkLines @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @unit @period=$currentDuration}) first(list({@ferc:NumberOfBarrelsDeliveredOutOnTrunkLines @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @unit @period=$currentDuration})) else none, if exists({@ferc:NumberOfBarrelsDeliveredOut @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @unit @period=$currentDuration}) first(list({@ferc:NumberOfBarrelsDeliveredOut @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @unit @period=$currentDuration})) else none )}}) else $data2; $uniqueData = list(for $x in $data if $x == list(0,none,none,none,none,none,none,none,none,none,none) skip else $x ); for $row in $uniqueData.sort // adding a comment $data2 = list(for $i in range(16,30) list($i,none,none,none,none,none,none,none,none,none,none) ); $data = if count(list({covered @ferc:StateOfOriginAndProductTypeAxis=*})) > 0 list({covered @ferc:StateOfOriginAndProductTypeAxis=* {list( if list({@ferc:OrderNumber @unit=* @period=$currentDuration}).length > 0 first(list({@ferc:OrderNumber @unit=* @period=$currentDuration})) else 0, if exists({@ferc:StateOfOrigin @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @unit@period=$currentDuration}) first(list({@ferc:StateOfOrigin @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @unit @period=$currentDuration})) else none, if exists({@ferc:RefinedProductType @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @unit@period=$currentDuration}) first(list({@ferc:RefinedProductType @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @unit @period=$currentDuration})) else none, if exists({@ferc:NumberOfBarrelsReceivedFromConnectingCarriers @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @unit @period=$currentDuration}) first(list({@ferc:NumberOfBarrelsReceivedFromConnectingCarriers @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @unit @period=$currentDuration})) else none, if exists({@ferc:NumberOfBarrelsReceivedOnGatheringLines @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @unit @period=$currentDuration}) first(list({@ferc:NumberOfBarrelsReceivedOnGatheringLines @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @unit @period=$currentDuration})) else none, if exists({@ferc:NumberOfBarrelsReceivedOnTrunkLines @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @unit @period=$currentDuration}) first(list({@ferc:NumberOfBarrelsReceivedOnTrunkLines @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @unit @period=$currentDuration})) else none, if exists({@ferc:NumberOfBarrelsReceived @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @unit @period=$currentDuration}) first(list({@ferc:NumberOfBarrelsReceived @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @unit @period=$currentDuration})) else none, if exists({@ferc:NumberOfBarrelsDeliveredOutToConnectingCarriers @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @unit @period=$currentDuration}) first(list({@ferc:NumberOfBarrelsDeliveredOutToConnectingCarriers @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @unit @period=$currentDuration})) else none, if exists({@ferc:NumberOfBarrelsDeliveredOutOnGatheringLines @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @unit @period=$currentDuration}) first(list({@ferc:NumberOfBarrelsDeliveredOutOnGatheringLines @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @unit @period=$currentDuration})) else none, if exists({@ferc:NumberOfBarrelsDeliveredOutOnTrunkLines @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @unit @period=$currentDuration}) first(list({@ferc:NumberOfBarrelsDeliveredOutOnTrunkLines @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @unit @period=$currentDuration})) else none, if exists({@ferc:NumberOfBarrelsDeliveredOut @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @unit @period=$currentDuration}) first(list({@ferc:NumberOfBarrelsDeliveredOut @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @unit @period=$currentDuration})) else none )}}) else $data2; $uniqueData = list(for $x in $data if $x == list(0,none,none,none,none,none,none,none,none,none,none) skip else $x ); $orders = set(for $x in $uniqueData $x[1]).sort; for $order in $orders for $row in $uniqueData if $row[1] != $order skip else
taxonomy().concept(ferc:ScheduleStatisticsOfOperationsAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F6ScheduleTitle").text Statistics of Operations
taxonomy().concept(ferc:ScheduleStatisticsOfOperationsAbstract).label("http://ferc.gov/form/2020-01-01/roles/label/F6Instructions").text
  1. Give particulars (details) by States of origin for crude oil and for each kind of product received year to date and totals only (i.e., no State detail) for number of barrels of crude oil and of each kind of product delivered out of the pipeline year to date. Classify and list in column (a) by States of origin the refined products transported in the following order: 29111, Gasoline, jet fuels, and other high volatile petroleum fuels, except natural gasoline; 29112, Kerosene; 29113, Distillate fuel oil; 29114, Lubricating and similar oils and derivatives; 29117, Residual fuel oil and other low volatile petroleum fuels; 29112, Products of petroleum refining, n.e.c. - Specify.
  2. In column (b) show all oils received by the respondent from connecting carriers reporting to the Federal Energy Regulatory Commission. In column (c) show all oils originated on respondent’s gathering lines and in column (d) all oils received into respondent’s trunk line, except receipts shown in columns (b) and (c). Any barrels received into a pipeline owned by the respondent, but operated by others, should be reported separately on additional pages (For example 600a- 601a, 600b- 601b, etc.).
  3. Entries in column (e) should be the sum of columns (b), (c), and (d). In column (f) show all oils delivered to connecting carriers reporting to the Federal Energy Regulatory Commission. In column (g) show all oils terminated on the respondent’s gathering lines, and in column (h) all oils delivered out of respondent's pipeline, except deliveries shown under columns (f) and (g).
    Entries in column (i) should be the sum of columns (f), (g), and (h). Any barrels delivered out of a pipeline owned by the respondent, but operated by others, should be reported separately on additional pages (For example 600a- 601a, 600b- 601b, etc.).
  4. Enter actual amount for lines 33a and 33b on an annual basis only. Do not report on a quarterly basis. Estimate if actual figures are not available. Barrel miles as reported on this schedule are the summation, for all segments, of the number of miles associated with each pipeline segment (trunk line only) multiplied by the number of barrels delivered through the segment. For example, 1,000 barrels moved through a 57-mile pipeline segment would be recorded as 57,000 barrel miles. For a crude pipeline with several segments:
    Segments Barrels Miles Barrel-Miles
    A 1,000 57 57,000
    B 5,000 10 50,000
    C 1,000 25 25,000
Number of Barrels Received (Year to Date) Number of Barrels Delivered Out (Year to Date)
ORIGINATED On TERMINATED On
Line No. $headings = filter (taxonomy().concept(ferc:ScheduleStatisticsOfOperationsAbstract).references("http://ferc.gov/form/2020-01-01/roles/reference/columnDetails")) where ($item.part-by-name(ferc-part:Schedule).part-value == "600 - Schedule - Statistics of Operations") $heading = list(for $ref in $headings list($ref.part-by-name(ferc-part:Column).part-value, $ref.part-by-name(ferc-part:ColumnName).part-value, $ref.part-by-name(ferc-part:ElementName).part-value)) $heading_dict = dict(for $row in $heading list("("+$row[1]+")",list($row[2],taxonomy().concept(to-qname($row[3])))) ); for $row in $heading_dict.keys.sort
$heading_dict[$row][2].name.local-name
$heading_dict[$row][1] Nature of Payment
$row (a)
CRUDE OIL
1 $row[2] Alaska $row[3] 21000 $row[4] 100,000 $row[5] 120,000 $row[6] 140,000 $row[7] 920,000 $row[8] 820,000 $row[9] 420,000 $row[10] 220,000 $row[11] 760,000
15 TOTAL first(list([covered @concept=ferc:NumberOfBarrelsReceivedFromConnectingCarriers @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @period = $currentDuration])) 27,666,233 first(list([covered @concept=ferc:NumberOfBarrelsReceivedOnGatheringLines @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @period = $currentDuration])) 81,982,726 first(list([covered @concept=ferc:NumberOfBarrelsReceivedOnTrunkLines @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @period = $currentDuration])) 25,200,177 first(list([covered @concept=ferc:NumberOfBarrelsReceived @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @period = $currentDuration])) 428,165,099 first(list([covered @concept=ferc:NumberOfBarrelsDeliveredOutToConnectingCarriers @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @period = $currentDuration])) 187,091,726 first(list([covered @concept=ferc:NumberOfBarrelsDeliveredOutOnGatheringLines @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @period = $currentDuration])) 109,837,144 first(list([covered @concept=ferc:NumberOfBarrelsDeliveredOutOnTrunkLines @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @period = $currentDuration])) 276,294,299 first(list([covered @concept=ferc:NumberOfBarrelsDeliveredOut @ferc:ProductsAndServicesAxis=ferc:CrudeOilMember @period = $currentDuration])) 385,531,884
PRODUCTS
16 $row[2] Hawaii $row[3] 29111 $row[4] 877,000 $row[5] 446,287 $row[6] 726,122 $row[7] 938,499 $row[8] 552,183 $row[9] 399,166 $row[10] 982,173 $row[11] 168,762
31 TOTAL first(list([covered @concept=ferc:NumberOfBarrelsReceivedFromConnectingCarriers @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @period = $currentDuration])) 827,721,289 first(list([covered @concept=ferc:NumberOfBarrelsReceivedOnGatheringLines @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @period = $currentDuration])) 172,847,188 first(list([covered @concept=ferc:NumberOfBarrelsReceivedOnTrunkLines @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @period = $currentDuration])) 477,177,339 first(list([covered @concept=ferc:NumberOfBarrelsReceived @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @period = $currentDuration])) 857,273,948 first(list([covered @concept=ferc:NumberOfBarrelsDeliveredOutToConnectingCarriers @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @period = $currentDuration])) 726,003,827 first(list([covered @concept=ferc:NumberOfBarrelsDeliveredOutOnGatheringLines @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @period = $currentDuration])) 955,177,837 first(list([covered @concept=ferc:NumberOfBarrelsDeliveredOutOnTrunkLines @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @period = $currentDuration])) 383,576,298 first(list([covered @concept=ferc:NumberOfBarrelsDeliveredOut @ferc:ProductsAndServicesAxis=ferc:OilProductsMember @period = $currentDuration])) 555,999,333
32 GRAND TOTAL first(list([covered @concept=ferc:NumberOfBarrelsReceivedFromConnectingCarriers @period = $currentDuration])) 999,721,877 first(list([covered @concept=ferc:NumberOfBarrelsReceivedOnGatheringLines @period = $currentDuration])) 726,847,922 first(list([covered @concept=ferc:NumberOfBarrelsReceivedOnTrunkLines @period = $currentDuration])) 289,855,339 first(list([covered @concept=ferc:NumberOfBarrelsReceived @period = $currentDuration])) 199,273,948 first(list([covered @concept=ferc:NumberOfBarrelsDeliveredOutToConnectingCarriers @period = $currentDuration])) 928,003,827 first(list([covered @concept=ferc:NumberOfBarrelsDeliveredOutOnGatheringLines @period = $currentDuration])) 654,177,837 first(list([covered @concept=ferc:NumberOfBarrelsDeliveredOutOnTrunkLines @period = $currentDuration])) 123,576,298 first(list([covered @concept=ferc:NumberOfBarrelsDeliveredOut @period = $currentDuration])) 321,999,333
33a Total Number of Barrel-Miles (Trunk Lines Only):
(1) Crude Oil first(list([covered @concept=ferc:NumberOfBarrelMilesOnTrunkLinesOfCrudeOil @period = $currentDuration])) 999,999,999
(2) Products first(list([covered @concept=ferc:NumberOfBarrelMilesOnTrunkLinesOfOilProducts @period = $currentDuration])) 999,999,888
33b Total Number of Barrels of Oil Having Trunk-Line Movement:
(1) Crude Oil first(list([covered @concept=ferc:NumberOfBarrelsOfOilHavingTrunkLineMovementForCrudeOil @period = $currentDuration])) 777,999,999
(2) Products first(list([covered @concept=ferc:NumberOfBarrelsOfOilHavingTrunkLineMovementForOilProducts @period = $currentDuration])) 888,999,999