Name: Airport (SFO) Monthly Utility Usage And Revenue
Creator: US Government
License: http://opendatacommons.org/licenses/pddl/1.0/

About this Dataset

Airport (SFO) Monthly Utility Usage And Revenue

San Francisco International Airport Report on Monthly utility usage and revenues by utility type and meter number
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:42.860593
Tags: airport, sfo, utility-consumption, utility-usage

Tables

Table 1

@usgov.city_of_san_francisco_airport_sfo_monthly_utility_usag_78b2cde5.table_1

12.82 MB
287,344 rows
35 columns

CREATE TABLE table_1 (
  "readperiod" BIGINT,
  "utilitytypeabbrev" VARCHAR,
  "utilitydescription" VARCHAR,
  "meterreadingid" BIGINT,
  "meterid" BIGINT,
  "meternumber" VARCHAR,
  "meterserialnumber" VARCHAR,
  "servicelocation" VARCHAR,
  "meterlocation" VARCHAR,
  "agrmtid" DOUBLE,
  "agrmtnumber" VARCHAR,
  "agreementtitle" VARCHAR,
  "provid" DOUBLE,
  "provassnstart" DOUBLE,
  "provassnend" DOUBLE,
  "previousreading" DOUBLE,
  "meterreading" DOUBLE,
  "baseusage" DOUBLE,
  "multifactor" BIGINT,
  "totalusage" DOUBLE,
  "adjustment" DOUBLE,
  "netusage" DOUBLE,
  "previoususage" DOUBLE,
  "usagepctchange" DOUBLE,
  "totaldemand" DOUBLE,
  "previousdemand" DOUBLE,
  "demandpctchange" DOUBLE,
  "percentuse" DOUBLE,
  "pctbaseamount" DOUBLE,
  "pctfueladjustmentamount" BIGINT,
  "pctsalestaxamount" DOUBLE,
  "pcttotalamount" DOUBLE,
  "isparent" VARCHAR,
  "ischild" VARCHAR,
  "parentmeter" DOUBLE
);