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
- 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.
- 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.).
- 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.).
- 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
$row
(a)
|
|
CRUDE OIL |
|
|
|
|
|
|
|
|
|
// 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
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 |
|
|
|
|
|
|
|
|
|
// 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
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
|