Data·Citizenan agentic layer over NYC Open Data
CatalogExploreAnalyticsMapAsk the agentFindingsGuideStatus
Data from NYC Open Data via the Socrata Discovery API. Quality scores are computed from a sample and are indicative, not authoritative.
← Catalog

Energy Usage From DOE Buildings

mq6n-s45cEnvironment62 columns
Energy data from a select portfolio of City-owned buildings (DOE)
View on NYC Open Data↗

Quality

C73.4 / 100

From a 153-row sample across 60 columns.

completeness100/ 25% weight
consistency53/ 20% weight
accuracy81/ 20% weight
timeliness38/ 15% weight
usability80/ 20% weight
  • · 2 column(s) have uninformative names
  • · No obvious temporal column — limits time-series joins
  • · Has coordinates — directly mappable, and joinable to other NYC datasets

Related datasets

  • Energy and Water Data Disclosure for Local Law 84 2020 (Data for Calendar Year 2019)0.34
    joins oncouncil_districtpostcodecensus_tract+5
  • 2005 Street Tree Census0.31
    joins onbblcensus_tractlongitude+3
  • Energy and Water Data Disclosure for Local Law 84 2021 (Data for Calendar Year 2020)0.31
    joins oncouncil_districtpostcodecensus_tract+5
  • NYC Greenhouse Gas Emissions Inventory0.30
  • Forestry Work Orders0.30

Geography

Mappable — coordinate pair `latitude` / `longitude`.

Open on the map →

Sample rows

building_addressboroughmeasurement_1_2fy_2009_7_1_2008aug_08sep_08oct_08nov_08dec_08jan_09
512 West 212th St [Shorac Kappock School] 1Electricity Demand (KW)144.0068.00148.00158.00166.00180.00168.00166.00166.00
512 West 212th St [Shorac Kappock School]

Columns

62 queryable · 62 profiled

The machine field names SoQL needs, with the publisher's own description of each.

FieldTypeDescriptionNullValues
building_addresstext—0%90 Trinity Pl [High Scho…85-52 85th St [Forest Pa…120 East 184th St [Middl…
boroughcategorical—0%321of 5
measurementcategorical—0%Gas (Therms)Electricity Usage (KWH)Electricity Demand (KW)of 7
_1float—0%0.001.00

Query this from your own app

GET /api/datasets/mq6n-s45c
GET /api/datasets/mq6n-s45c/quality
GET /api/datasets/mq6n-s45c/related
GET /api/columns?dataset=mq6n-s45c
joins onbblcensus_tractlongitude+3
  • 1995 Street Tree Census0.28
    joins oncouncil_districtbbllongitude+3
  • NYCDEP Recreation Area Maps0.28
  • 2015 Street Tree Census - Tree Data0.27
    joins oncouncil_districtbblcensus_tract+4
    • 1
    Electricity Usage (KWH)
    30400.00
    31000.00
    46200.00
    45200.00
    51800.00
    58400.00
    56600.00
    52200.00
    55200.00
    512 West 212th St [Shorac Kappock School] 1Gas (Therms)109.00112.00305.002298.007666.0013710.0016197.0012846.0010322.00
    512 West 212th St [Shorac Kappock School] 1Total Usage (mmBTUs)114.65117.00188.18384.07943.391570.321812.871462.761220.60
    232 East 103rd St [Roberto Clemente School] 1Electricity Demand (KW)123.20150.40150.40124.80136.00144.00144.00144.00142.40
    232 East 103rd St [Roberto Clemente School] 1Electricity Usage (KWH)53920.0058560.0056640.0048640.0054560.0061440.0061600.0060640.0060800.00
    232 East 103rd St [Roberto Clemente School] 1Gas (Therms)0.0060.0013.001041.004676.008096.005772.002498.00288.00
    232 East 103rd St [Roberto Clemente School] 1Total Usage (mmBTUs)184.03205.86194.61270.11653.811019.29787.44456.76236.31
    549 Audubon Ave [George Washington High School?] 1Electricity Demand (KW)576.00552.00700.00708.00584.00676.00676.00636.00660.00
    549 Audubon Ave [George Washington High School?] 1Electricity Usage (KWH)242400.00277600.00236000.00204000.00234000.00298000.00298800.00267200.00257600.00

    Showing 12 of 60 columns. All of them are listed below.

    86.01
    _2float—0%0.00186.0068.00
    fy_2009_7_1_2008float—0%0.00148.00254.00
    aug_08float—0%0.001335.00112.00
    sep_08float—0%0.0097600.00416.00
    oct_08float—0%0.00312.00103.00
    nov_08float—0%0.00168.00182800.00
    dec_08float—0%0.00490.00252.00
    jan_09float—0%0.00392.00142.40
    feb_09float—0%0.00162.00236.00
    mar_09float—0%0.00344.00356.00
    apr_09float—0%0.00384.00316.00
    may_09float—0%0.00404.00160.00
    jun_09float—0%0.00288.00144.00
    fy_2010_7_1_2009float—0%0.00392.0031.00
    aug_09float—0%0.00392.00136.00
    sep_09float—0%0.00400.00162.00
    oct_09float—0%0.00644.00204.00
    nov_09float—0%0.00392.00356.00
    dec_09float—0%0.00392.00276.00
    jan_10float—0%0.00392.00448.00
    feb_10float—0%322800.00368.00156.00
    mar_10float—0%0.00400.00384.00
    apr_10float—0%0.00210.00488.00
    may_10float—0%3.000.00204.00
    jun_10float—0%0.002.00156.00
    fy_2011_7_1_2010float—0%336.00140.000.00
    aug_10float—0%188.00148.80372.00
    sep_10float—0%99.000.00252.00
    oct_10float—0%59040.003155.1064.00
    nov_10float—0%56.006267.27361.56
    dec_10float—0%176.001668.00145.60
    jan_11float—0%56880.00240.00120000.00
    feb_11float—0%0.00296.00224.00
    mar_11float—0%320.00105.00103200.00
    apr_11float—0%0.00339.007245.00
    may_11float—0%0.00156.002931.00
    jun_11float—0%0.003.0082.00
    fy_2012_7_1_2011float—0%0.0058.00660.96
    aug_11float—0%0.0078000.00456.00
    sep_11float—0%34400.000.00113600.00
    oct_11float—0%0.0062.00248.00
    nov_11float—0%260.00220.00124.00
    dec_11float—0%115200.00392.000.00
    jan_12float—0%340.00156.000.00
    feb_12float—0%29.00320.006963.00
    mar_12float—0%0.00128.00356.00
    apr_12float—0%0.00106.00130800.00
    may_12text—100%—
    jun_12text—100%—
    postcodeinteger—0%100061120711385
    latitudefloat—0%40.7087340.70919640.702513
    longitudefloat—0%-74.012332-73.981241-74.000851
    community_boardcategorical—0%591of 17
    council_districtinteger—0%11430
    census_tractinteger—0%13112672
    bininteger—6%100103520138992027459
    bblinteger—6%100051001510011301003038230001
    ntatext—0%Battery Park City-Lower …East New York (Pennsylva…Stuyvesant Heights …