{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "### Final project Part 3: Viz for others (Ian Chapman)\n", "# How much might renewable electricity generation reduce our carbon imprint?" ] }, { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "import pandas as pd\n", "import numpy as np\n", "import bqplot\n", "import ipywidgets" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## I. WA total emissions per sector (bar chart)" ] }, { "cell_type": "code", "execution_count": 2, "metadata": { "scrolled": false }, "outputs": [ { "data": { "text/html": [ "
\n", " | Source | \n", "Sector | \n", "Subsector | \n", "City | \n", "County | \n", "Local Air Authority | \n", "2012 total emissions (MTCO2e) | \n", "2012 biogenic carbon dioxide (MTCO2e) | \n", "2013 total emissions (MTCO2e) | \n", "2013 biogenic carbon dioxide (MTCO2e) | \n", "2014 total emissions (MTCO2e) | \n", "2014 biogenic carbon dioxide (MTCO2e) | \n", "2015 total emissions (MTCO2e) | \n", "2015 biogenic carbon dioxide (MTCO2e) | \n", "2016 total emissions (MTCO2e) | \n", "2016 biogenic carbon dioxide (MTCO2e) | \n", "2017 total emissions (MTCO2e) | \n", "2017 biogenic carbon dioxide (MTCO2e) | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "Agrium Kennewick Fertilizer Operations (KFO) -... | \n", "Chemicals | \n", "Nitric Acid Production | \n", "Kennewick | \n", "Benton | \n", "Benton Clean Air Agency | \n", "146926.0 | \n", "0.0 | \n", "154497.0 | \n", "0.0 | \n", "132249.0 | \n", "0.0 | \n", "155888.0 | \n", "0.0 | \n", "151371.0 | \n", "0.0 | \n", "144290.0 | \n", "0.0 | \n", "
1 | \n", "Air Liquide - Anacortes | \n", "Chemicals | \n", "Hydrogen Production | \n", "Anacortes | \n", "Skagit | \n", "Northwest Clean Air Agency | \n", "63356.0 | \n", "0.0 | \n", "58995.0 | \n", "0.0 | \n", "64110.0 | \n", "0.0 | \n", "64413.0 | \n", "0.0 | \n", "60209.0 | \n", "0.0 | \n", "63461.0 | \n", "0.0 | \n", "
2 | \n", "Alcoa Intalco Works - Ferndale | \n", "Metals | \n", "Aluminum Production | \n", "Ferndale | \n", "Whatcom | \n", "Ecology: Industrial Section | \n", "1146835.0 | \n", "0.0 | \n", "1234637.0 | \n", "0.0 | \n", "1326684.0 | \n", "0.0 | \n", "1195786.0 | \n", "0.0 | \n", "1261364.0 | \n", "0.0 | \n", "1091665.0 | \n", "0.0 | \n", "
3 | \n", "Alcoa Wenatchee Works - Malaga | \n", "Metals | \n", "Aluminum Production | \n", "Malaga | \n", "Chelan | \n", "Ecology: Industrial Section | \n", "306333.0 | \n", "0.0 | \n", "318542.0 | \n", "0.0 | \n", "354692.0 | \n", "0.0 | \n", "331207.0 | \n", "0.0 | \n", "898.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "
4 | \n", "Alon Asphalt Company - Seattle | \n", "Petroleum and Natural Gas Systems | \n", "Other Petroleum and Natural Gas Systems | \n", "Seattle | \n", "King | \n", "Puget Sound Clean Air Agency | \n", "15138.0 | \n", "0.0 | \n", "14336.0 | \n", "0.0 | \n", "16004.0 | \n", "0.0 | \n", "13688.0 | \n", "0.0 | \n", "14096.0 | \n", "0.0 | \n", "14818.0 | \n", "0.0 | \n", "
5 | \n", "Ardagh Glass Inc. - Seattle | \n", "Minerals | \n", "Glass Production | \n", "Seattle | \n", "King | \n", "Puget Sound Clean Air Agency | \n", "76257.0 | \n", "0.0 | \n", "80745.0 | \n", "0.0 | \n", "78044.0 | \n", "0.0 | \n", "76674.0 | \n", "0.0 | \n", "77845.0 | \n", "0.0 | \n", "75338.0 | \n", "0.0 | \n", "
6 | \n", "Ascensus Specialties LLC - Elma | \n", "Chemicals | \n", "Other Chemicals | \n", "Elma | \n", "Grays Harbor | \n", "Olympic Region Clean Air Agency | \n", "16809.0 | \n", "0.0 | \n", "17966.0 | \n", "0.0 | \n", "21231.0 | \n", "0.0 | \n", "17600.0 | \n", "0.0 | \n", "20802.0 | \n", "0.0 | \n", "21310.0 | \n", "0.0 | \n", "
7 | \n", "Ash Grove Cement Company - Seattle | \n", "Minerals | \n", "Cement Production | \n", "Seattle | \n", "King | \n", "Puget Sound Clean Air Agency | \n", "305298.0 | \n", "0.0 | \n", "354808.0 | \n", "0.0 | \n", "522982.0 | \n", "0.0 | \n", "495030.0 | \n", "0.0 | \n", "383836.0 | \n", "0.0 | \n", "355513.0 | \n", "0.0 | \n", "
8 | \n", "Avista Corporation - WA State DOE Reporting - ... | \n", "Petroleum and Natural Gas Systems | \n", "Natural Gas Local Distribution Companies | \n", "Spokane | \n", "Spokane | \n", "Spokane Regional Clean Air Agency | \n", "20992.0 | \n", "0.0 | \n", "16127.0 | \n", "0.0 | \n", "16420.0 | \n", "0.0 | \n", "22858.0 | \n", "0.0 | \n", "21120.0 | \n", "0.0 | \n", "23757.0 | \n", "0.0 | \n", "
9 | \n", "Basic American Foods - Moses Lake | \n", "Food Production | \n", "Potato Products | \n", "Moses Lake | \n", "Grant | \n", "Ecology: Eastern Regional Office | \n", "28205.0 | \n", "0.0 | \n", "28312.0 | \n", "0.0 | \n", "28982.0 | \n", "0.0 | \n", "31063.0 | \n", "0.0 | \n", "28977.0 | \n", "0.0 | \n", "30576.0 | \n", "0.0 | \n", "
10 | \n", "Bio Energy Washington, LLC - Maple Valley | \n", "Power Plants | \n", "Other Power, Heating, or Cooling Plants | \n", "Maple Valley | \n", "King | \n", "Puget Sound Clean Air Agency | \n", "13697.0 | \n", "12800.0 | \n", "28341.0 | \n", "27018.0 | \n", "28302.0 | \n", "27006.0 | \n", "30802.0 | \n", "29306.0 | \n", "29216.0 | \n", "27510.0 | \n", "28391.0 | \n", "26962.0 | \n", "
11 | \n", "Boeing Commercial Airplanes - Everett | \n", "Manufacturing | \n", "Transportation | \n", "Everett | \n", "Snohomish | \n", "Puget Sound Clean Air Agency | \n", "71463.0 | \n", "0.0 | \n", "73643.0 | \n", "0.0 | \n", "73522.0 | \n", "0.0 | \n", "66276.0 | \n", "0.0 | \n", "76191.0 | \n", "0.0 | \n", "80529.0 | \n", "0.0 | \n", "
12 | \n", "Boeing Commercial Airplanes - Fabrication (Fre... | \n", "Manufacturing | \n", "Transportation | \n", "Puyallup | \n", "Pierce | \n", "Puget Sound Clean Air Agency | \n", "22582.0 | \n", "0.0 | \n", "21969.0 | \n", "0.0 | \n", "21442.0 | \n", "0.0 | \n", "20833.0 | \n", "0.0 | \n", "19831.0 | \n", "0.0 | \n", "19893.0 | \n", "0.0 | \n", "
13 | \n", "Boise Cascade Wood Products, LLC. Kettle Fall... | \n", "Wood Products | \n", "Lumber Mills | \n", "Kettle Falls | \n", "Stevens | \n", "Ecology: Eastern Regional Office | \n", "41052.0 | \n", "40173.0 | \n", "56886.0 | \n", "56136.0 | \n", "57413.0 | \n", "56656.0 | \n", "57294.0 | \n", "56539.0 | \n", "53752.0 | \n", "53043.0 | \n", "54397.0 | \n", "53680.0 | \n", "
14 | \n", "Boise Cascade Wood Products, LLC. Kettle Fall... | \n", "Wood Products | \n", "Engineered Wood | \n", "Kettle Falls | \n", "Stevens | \n", "Ecology: Eastern Regional Office | \n", "68360.0 | \n", "64637.0 | \n", "71186.0 | \n", "68156.0 | \n", "71069.0 | \n", "68040.0 | \n", "71151.0 | \n", "68501.0 | \n", "73564.0 | \n", "70714.0 | \n", "70889.0 | \n", "54924.0 | \n", "
15 | \n", "Boise Paper - Wallula | \n", "Pulp and Paper | \n", "Kraft Mills | \n", "Wallula | \n", "Walla Walla | \n", "Ecology: Industrial Section | \n", "925349.0 | \n", "791371.0 | \n", "830754.0 | \n", "727045.0 | \n", "887912.0 | \n", "765685.0 | \n", "855520.0 | \n", "717427.0 | \n", "804657.0 | \n", "645182.0 | \n", "681208.0 | \n", "528740.0 | \n", "
16 | \n", "Bonneville Power Administration - WA Only - st... | \n", "Power Plants | \n", "Use of Electrical Equipment | \n", "Vancouver | \n", "Clark | \n", "Southwest Clean Air Agency | \n", "26927.0 | \n", "0.0 | \n", "42114.0 | \n", "0.0 | \n", "12800.0 | \n", "0.0 | \n", "14245.0 | \n", "0.0 | \n", "17121.0 | \n", "0.0 | \n", "15069.0 | \n", "0.0 | \n", "
17 | \n", "Boulder Park Generating Station - Spokane Valley | \n", "Power Plants | \n", "Other Power, Heating, or Cooling Plants | \n", "Spokane Valley | \n", "Spokane | \n", "Spokane Regional Clean Air Agency | \n", "2700.0 | \n", "0.0 | \n", "10795.0 | \n", "0.0 | \n", "7552.0 | \n", "0.0 | \n", "10952.0 | \n", "0.0 | \n", "9009.0 | \n", "0.0 | \n", "13286.0 | \n", "0.0 | \n", "
18 | \n", "BP Cherry Point Refinery - Blaine | \n", "Refineries | \n", "Petroleum Refineries | \n", "Blaine | \n", "Whatcom | \n", "Northwest Clean Air Agency | \n", "2223518.0 | \n", "0.0 | \n", "2552655.0 | \n", "0.0 | \n", "2301576.0 | \n", "0.0 | \n", "2093437.0 | \n", "0.0 | \n", "2418086.0 | \n", "0.0 | \n", "2131918.0 | \n", "0.0 | \n", "
19 | \n", "Cardinal FG Company - Winlock | \n", "Minerals | \n", "Glass Production | \n", "Winlock | \n", "Lewis | \n", "Southwest Clean Air Agency | \n", "92356.0 | \n", "0.0 | \n", "102904.0 | \n", "0.0 | \n", "102813.0 | \n", "0.0 | \n", "105009.0 | \n", "0.0 | \n", "107291.0 | \n", "0.0 | \n", "107590.0 | \n", "0.0 | \n", "
20 | \n", "Cascade Natural Gas Corporation LDC - statewide | \n", "Petroleum and Natural Gas Systems | \n", "Natural Gas Local Distribution Companies | \n", "Kennewick | \n", "Benton | \n", "Benton Clean Air Agency | \n", "12622.0 | \n", "0.0 | \n", "12940.0 | \n", "0.0 | \n", "13506.0 | \n", "0.0 | \n", "22852.0 | \n", "0.0 | \n", "23616.0 | \n", "0.0 | \n", "26227.0 | \n", "0.0 | \n", "
21 | \n", "Cathcart Landfill - Snohomish | \n", "Waste | \n", "Municipal Landfills | \n", "Snohomish | \n", "Snohomish | \n", "Puget Sound Clean Air Agency | \n", "27653.0 | \n", "0.0 | \n", "23893.0 | \n", "0.0 | \n", "22454.0 | \n", "0.0 | \n", "23520.0 | \n", "0.0 | \n", "17417.0 | \n", "0.0 | \n", "28273.0 | \n", "0.0 | \n", "
22 | \n", "Central Washington University - Ellensburg | \n", "Government | \n", "Education | \n", "Ellensburg | \n", "Kittitas | \n", "Ecology: Central Regional Office | \n", "13358.0 | \n", "0.0 | \n", "13451.0 | \n", "0.0 | \n", "13673.0 | \n", "0.0 | \n", "12838.0 | \n", "0.0 | \n", "12449.0 | \n", "0.0 | \n", "13669.0 | \n", "0.0 | \n", "
23 | \n", "CertainTeed Gypsum - Seattle | \n", "Manufacturing | \n", "Gypsum Manufacturing | \n", "Seattle | \n", "King | \n", "Puget Sound Clean Air Agency | \n", "35650.0 | \n", "0.0 | \n", "35465.0 | \n", "0.0 | \n", "36299.0 | \n", "0.0 | \n", "38141.0 | \n", "0.0 | \n", "47948.0 | \n", "0.0 | \n", "50452.0 | \n", "0.0 | \n", "
24 | \n", "Cheyne Landfill - Zillah | \n", "Waste | \n", "Municipal Landfills | \n", "Zillah | \n", "Yakima | \n", "Yakima Regional Clean Air Agency | \n", "30500.0 | \n", "0.0 | \n", "31807.0 | \n", "0.0 | \n", "33147.0 | \n", "0.0 | \n", "34450.0 | \n", "0.0 | \n", "35837.0 | \n", "0.0 | \n", "37331.0 | \n", "0.0 | \n", "
26 | \n", "City of Tacoma Solid Waste Facility - Tacoma | \n", "Waste | \n", "Municipal Landfills | \n", "Tacoma | \n", "Pierce | \n", "Puget Sound Clean Air Agency | \n", "31986.0 | \n", "0.0 | \n", "26643.0 | \n", "0.0 | \n", "20396.0 | \n", "0.0 | \n", "14812.0 | \n", "0.0 | \n", "14513.0 | \n", "0.0 | \n", "16417.0 | \n", "0.0 | \n", "
27 | \n", "ConAgra Foods Lamb Weston - Connell | \n", "Food Production | \n", "Potato Products | \n", "Connell | \n", "Franklin | \n", "Ecology: Eastern Regional Office | \n", "39714.0 | \n", "0.0 | \n", "39841.0 | \n", "0.0 | \n", "38810.0 | \n", "0.0 | \n", "36801.0 | \n", "0.0 | \n", "37212.0 | \n", "0.0 | \n", "35862.0 | \n", "0.0 | \n", "
28 | \n", "ConAgra Foods Lamb Weston - Quincy | \n", "Food Production | \n", "Potato Products | \n", "Quincy | \n", "Grant | \n", "Ecology: Eastern Regional Office | \n", "39693.0 | \n", "0.0 | \n", "39846.0 | \n", "0.0 | \n", "38324.0 | \n", "0.0 | \n", "37922.0 | \n", "0.0 | \n", "40468.0 | \n", "0.0 | \n", "34928.0 | \n", "0.0 | \n", "
29 | \n", "Cosmo Specialty Fibers Inc - Cosmopolis | \n", "Pulp and Paper | \n", "Sulfite Mills | \n", "Cosmopolis | \n", "Grays Harbor | \n", "Ecology: Industrial Section | \n", "1186972.0 | \n", "1150934.0 | \n", "1105362.0 | \n", "1078626.0 | \n", "1185707.0 | \n", "1152820.0 | \n", "1170393.0 | \n", "1144912.0 | \n", "989316.0 | \n", "963065.0 | \n", "701686.0 | \n", "676644.0 | \n", "
30 | \n", "Cowlitz County Headquarters Landfill - Castle ... | \n", "Waste | \n", "Municipal Landfills | \n", "Castle Rock | \n", "Cowlitz | \n", "Southwest Clean Air Agency | \n", "121597.0 | \n", "659.0 | \n", "129060.0 | \n", "556.0 | \n", "154619.0 | \n", "1205.0 | \n", "190202.0 | \n", "2097.0 | \n", "178854.0 | \n", "7724.0 | \n", "218522.0 | \n", "11096.0 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
152 | \n", "Waste Management Greater Wenatchee Regional La... | \n", "Waste | \n", "Municipal Landfills | \n", "East Wenatchee | \n", "Douglas | \n", "Ecology: Central Regional Office | \n", "36141.0 | \n", "0.0 | \n", "31854.0 | \n", "0.0 | \n", "32740.0 | \n", "0.0 | \n", "31208.0 | \n", "0.0 | \n", "30653.0 | \n", "0.0 | \n", "27951.0 | \n", "0.0 | \n", "
153 | \n", "WestRock CP, LLC - Tacoma | \n", "Pulp and Paper | \n", "Kraft Mills | \n", "Tacoma | \n", "Pierce | \n", "Ecology: Industrial Section | \n", "1082809.0 | \n", "940615.0 | \n", "1039284.0 | \n", "925083.0 | \n", "1173531.0 | \n", "1059608.0 | \n", "1135442.0 | \n", "1011954.0 | \n", "1134873.0 | \n", "1011165.0 | \n", "1124426.0 | \n", "1000676.0 | \n", "
154 | \n", "Weyerhaeuser Raymond Lumber - Raymond | \n", "Wood Products | \n", "Lumber Mills | \n", "Raymond | \n", "Pacific | \n", "Olympic Region Clean Air Agency | \n", "45768.0 | \n", "44790.0 | \n", "47339.0 | \n", "46369.0 | \n", "48445.0 | \n", "47806.0 | \n", "46229.0 | \n", "45632.0 | \n", "46747.0 | \n", "46747.0 | \n", "48561.0 | \n", "47921.0 | \n", "
156 | \n", "Ascent Aviation Group Inc | \n", "Transportation Fuel Supplier | \n", "Transportation Fuel Supplier | \n", "NaN | \n", "(Statewide) | \n", "NaN | \n", "18223.0 | \n", "0.0 | \n", "15728.0 | \n", "0.0 | \n", "44724.0 | \n", "0.0 | \n", "66762.0 | \n", "0.0 | \n", "66269.0 | \n", "0.0 | \n", "45678.0 | \n", "0.0 | \n", "
157 | \n", "Associated Petroleum Products, Inc. | \n", "Transportation Fuel Supplier | \n", "Transportation Fuel Supplier | \n", "NaN | \n", "(Statewide) | \n", "NaN | \n", "1003689.0 | \n", "0.0 | \n", "1054993.0 | \n", "36292.0 | \n", "1325248.0 | \n", "45274.0 | \n", "1686102.0 | \n", "58808.0 | \n", "1990731.0 | \n", "65716.0 | \n", "2330279.0 | \n", "76484.0 | \n", "
158 | \n", "Avfuel Corporation | \n", "Transportation Fuel Supplier | \n", "Transportation Fuel Supplier | \n", "NaN | \n", "(Statewide) | \n", "NaN | \n", "41989.0 | \n", "0.0 | \n", "67999.0 | \n", "0.0 | \n", "83459.0 | \n", "0.0 | \n", "75236.0 | \n", "0.0 | \n", "32347.0 | \n", "0.0 | \n", "103100.0 | \n", "0.0 | \n", "
159 | \n", "BP West Coast Products LLC | \n", "Transportation Fuel Supplier | \n", "Transportation Fuel Supplier | \n", "NaN | \n", "(Statewide) | \n", "NaN | \n", "7291311.0 | \n", "0.0 | \n", "6053769.0 | \n", "0.0 | \n", "5866602.0 | \n", "0.0 | \n", "6092051.0 | \n", "0.0 | \n", "5544958.0 | \n", "0.0 | \n", "4814803.0 | \n", "0.0 | \n", "
160 | \n", "Chevron U.S.A. Inc. | \n", "Transportation Fuel Supplier | \n", "Transportation Fuel Supplier | \n", "NaN | \n", "(Statewide) | \n", "NaN | \n", "2921033.0 | \n", "180260.0 | \n", "3096698.0 | \n", "190620.0 | \n", "3154826.0 | \n", "193502.0 | \n", "3093693.0 | \n", "190217.0 | \n", "3079994.0 | \n", "190121.0 | \n", "3028590.0 | \n", "187837.0 | \n", "
161 | \n", "CHS INC. | \n", "Transportation Fuel Supplier | \n", "Transportation Fuel Supplier | \n", "NaN | \n", "(Statewide) | \n", "NaN | \n", "618830.0 | \n", "29251.0 | \n", "613851.0 | \n", "9449.0 | \n", "691788.0 | \n", "37979.0 | \n", "705927.0 | \n", "0.0 | \n", "713406.0 | \n", "0.0 | \n", "707879.0 | \n", "0.0 | \n", "
162 | \n", "CityServiceValcon LLC | \n", "Transportation Fuel Supplier | \n", "Transportation Fuel Supplier | \n", "NaN | \n", "(Statewide) | \n", "NaN | \n", "174415.0 | \n", "394.0 | \n", "325002.0 | \n", "15275.0 | \n", "358213.0 | \n", "17373.0 | \n", "384845.0 | \n", "19040.0 | \n", "396231.0 | \n", "17935.0 | \n", "396100.0 | \n", "1905.0 | \n", "
167 | \n", "Equilon Enterprises LLC dba Shell Oil Products US | \n", "Transportation Fuel Supplier | \n", "Transportation Fuel Supplier | \n", "NaN | \n", "(Statewide) | \n", "NaN | \n", "3115901.0 | \n", "163141.0 | \n", "3566781.0 | \n", "0.0 | \n", "3813545.0 | \n", "0.0 | \n", "4523704.0 | \n", "0.0 | \n", "5292512.0 | \n", "0.0 | \n", "5985748.0 | \n", "0.0 | \n", "
168 | \n", "ExxonMobil Oil Corporation | \n", "Transportation Fuel Supplier | \n", "Transportation Fuel Supplier | \n", "NaN | \n", "(Statewide) | \n", "NaN | \n", "789950.0 | \n", "47558.0 | \n", "963246.0 | \n", "61463.0 | \n", "859726.0 | \n", "54950.0 | \n", "903301.0 | \n", "58167.0 | \n", "831233.0 | \n", "53419.0 | \n", "867077.0 | \n", "55933.0 | \n", "
171 | \n", "IPC (USA), Inc. | \n", "Transportation Fuel Supplier | \n", "Transportation Fuel Supplier | \n", "NaN | \n", "(Statewide) | \n", "NaN | \n", "198273.0 | \n", "0.0 | \n", "321387.0 | \n", "0.0 | \n", "395591.0 | \n", "0.0 | \n", "33803.0 | \n", "0.0 | \n", "14772.0 | \n", "14.0 | \n", "NaN | \n", "NaN | \n", "
172 | \n", "PetroCard Inc. | \n", "Transportation Fuel Supplier | \n", "Transportation Fuel Supplier | \n", "NaN | \n", "(Statewide) | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "529844.0 | \n", "0.0 | \n", "191708.0 | \n", "7558.0 | \n", "1066990.0 | \n", "34044.0 | \n", "
174 | \n", "Phillips 66 Company | \n", "Transportation Fuel Supplier | \n", "Transportation Fuel Supplier | \n", "NaN | \n", "(Statewide) | \n", "NaN | \n", "4416054.0 | \n", "218663.0 | \n", "4941002.0 | \n", "268520.0 | \n", "5276097.0 | \n", "290281.0 | \n", "5252409.0 | \n", "285529.0 | \n", "4761013.0 | \n", "266360.0 | \n", "3907576.0 | \n", "225513.0 | \n", "
176 | \n", "RPMG, Inc. | \n", "Transportation Fuel Supplier | \n", "Transportation Fuel Supplier | \n", "NaN | \n", "(Statewide) | \n", "NaN | \n", "452188.0 | \n", "452188.0 | \n", "371271.0 | \n", "371271.0 | \n", "338028.0 | \n", "338028.0 | \n", "401017.0 | \n", "401017.0 | \n", "448981.0 | \n", "448981.0 | \n", "97522.0 | \n", "97522.0 | \n", "
177 | \n", "SEI Fuel Services, Inc. | \n", "Transportation Fuel Supplier | \n", "Transportation Fuel Supplier | \n", "NaN | \n", "(Statewide) | \n", "NaN | \n", "381994.0 | \n", "25484.0 | \n", "358202.0 | \n", "23907.0 | \n", "396729.0 | \n", "26479.0 | \n", "312704.0 | \n", "20572.0 | \n", "346741.0 | \n", "20812.0 | \n", "316171.0 | \n", "20344.0 | \n", "
178 | \n", "Sinclair Oil Corporation | \n", "Transportation Fuel Supplier | \n", "Transportation Fuel Supplier | \n", "NaN | \n", "(Statewide) | \n", "NaN | \n", "15653.0 | \n", "0.0 | \n", "21056.0 | \n", "0.0 | \n", "57314.0 | \n", "0.0 | \n", "89794.0 | \n", "0.0 | \n", "122139.0 | \n", "0.0 | \n", "163446.0 | \n", "0.0 | \n", "
179 | \n", "Southern Counties Oil Co Ltd | \n", "Transportation Fuel Supplier | \n", "Transportation Fuel Supplier | \n", "NaN | \n", "(Statewide) | \n", "NaN | \n", "111922.0 | \n", "5812.0 | \n", "119268.0 | \n", "6290.0 | \n", "96845.0 | \n", "4022.0 | \n", "106342.0 | \n", "2231.0 | \n", "97613.0 | \n", "3327.0 | \n", "68529.0 | \n", "1554.0 | \n", "
180 | \n", "Targa Sound Terminal | \n", "Transportation Fuel Supplier | \n", "Transportation Fuel Supplier | \n", "NaN | \n", "(Statewide) | \n", "NaN | \n", "81445.0 | \n", "27441.0 | \n", "19092.0 | \n", "7800.0 | \n", "19757.0 | \n", "6378.0 | \n", "14436.0 | \n", "8114.0 | \n", "17924.0 | \n", "8021.0 | \n", "14527.0 | \n", "3411.0 | \n", "
181 | \n", "Tesoro Refining & Marketing Company LLC | \n", "Transportation Fuel Supplier | \n", "Transportation Fuel Supplier | \n", "NaN | \n", "(Statewide) | \n", "NaN | \n", "6158377.0 | \n", "0.0 | \n", "5740456.0 | \n", "0.0 | \n", "5713367.0 | \n", "0.0 | \n", "5604007.0 | \n", "266252.0 | \n", "5228903.0 | \n", "273546.0 | \n", "5081912.0 | \n", "273012.0 | \n", "
182 | \n", "The Boeing Company | \n", "Transportation Fuel Supplier | \n", "Transportation Fuel Supplier | \n", "NaN | \n", "(Statewide) | \n", "NaN | \n", "107661.0 | \n", "0.0 | \n", "126519.0 | \n", "0.0 | \n", "129491.0 | \n", "0.0 | \n", "118525.0 | \n", "0.0 | \n", "120830.0 | \n", "0.0 | \n", "129232.0 | \n", "0.0 | \n", "
183 | \n", "U.S. Oil & Refining Co. | \n", "Transportation Fuel Supplier | \n", "Transportation Fuel Supplier | \n", "NaN | \n", "(Statewide) | \n", "NaN | \n", "1159448.0 | \n", "0.0 | \n", "1175482.0 | \n", "0.0 | \n", "1310797.0 | \n", "0.0 | \n", "1292825.0 | \n", "0.0 | \n", "1288944.0 | \n", "0.0 | \n", "1177990.0 | \n", "0.0 | \n", "
184 | \n", "United Parcel Service Co | \n", "Transportation Fuel Supplier | \n", "Transportation Fuel Supplier | \n", "NaN | \n", "(Statewide) | \n", "NaN | \n", "62859.0 | \n", "0.0 | \n", "47767.0 | \n", "0.0 | \n", "50987.0 | \n", "0.0 | \n", "50052.0 | \n", "0.0 | \n", "56975.0 | \n", "0.0 | \n", "62975.0 | \n", "0.0 | \n", "
185 | \n", "UPS Fuel Services, Inc. | \n", "Transportation Fuel Supplier | \n", "Transportation Fuel Supplier | \n", "NaN | \n", "(Statewide) | \n", "NaN | \n", "31398.0 | \n", "0.0 | \n", "31599.0 | \n", "0.0 | \n", "32640.0 | \n", "0.0 | \n", "32845.0 | \n", "0.0 | \n", "33450.0 | \n", "0.0 | \n", "34518.0 | \n", "0.0 | \n", "
186 | \n", "Valero Marketing and Supply Company | \n", "Transportation Fuel Supplier | \n", "Transportation Fuel Supplier | \n", "NaN | \n", "(Statewide) | \n", "NaN | \n", "162579.0 | \n", "10502.0 | \n", "126614.0 | \n", "8077.0 | \n", "111391.0 | \n", "7758.0 | \n", "110012.0 | \n", "6829.0 | \n", "33485.0 | \n", "2205.0 | \n", "27291.0 | \n", "1797.0 | \n", "
187 | \n", "Vitol Inc. | \n", "Transportation Fuel Supplier | \n", "Transportation Fuel Supplier | \n", "NaN | \n", "(Statewide) | \n", "NaN | \n", "725057.0 | \n", "42882.0 | \n", "466188.0 | \n", "27546.0 | \n", "14658.0 | \n", "921.0 | \n", "12307.0 | \n", "788.0 | \n", "1551.0 | \n", "104.0 | \n", "98.0 | \n", "7.0 | \n", "
188 | \n", "Western Petroleum Company | \n", "Transportation Fuel Supplier | \n", "Transportation Fuel Supplier | \n", "NaN | \n", "(Statewide) | \n", "NaN | \n", "63500.0 | \n", "457.0 | \n", "19420.0 | \n", "685.0 | \n", "21216.0 | \n", "463.0 | \n", "11132.0 | \n", "48.0 | \n", "19449.0 | \n", "478.0 | \n", "12906.0 | \n", "239.0 | \n", "
189 | \n", "Wilson Oil Inc | \n", "Transportation Fuel Supplier | \n", "Transportation Fuel Supplier | \n", "NaN | \n", "(Statewide) | \n", "NaN | \n", "1232072.0 | \n", "50925.0 | \n", "1197669.0 | \n", "46854.0 | \n", "1193047.0 | \n", "47740.0 | \n", "1157609.0 | \n", "46220.0 | \n", "1207292.0 | \n", "49518.0 | \n", "1251997.0 | \n", "51446.0 | \n", "
190 | \n", "World Fuel Services, Inc. | \n", "Transportation Fuel Supplier | \n", "Transportation Fuel Supplier | \n", "NaN | \n", "(Statewide) | \n", "NaN | \n", "262127.0 | \n", "4796.0 | \n", "235658.0 | \n", "5443.0 | \n", "242219.0 | \n", "5476.0 | \n", "326040.0 | \n", "5479.0 | \n", "401673.0 | \n", "5634.0 | \n", "314725.0 | \n", "3016.0 | \n", "
177 rows × 18 columns
\n", "