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

Office of Climate and Sustainability: 2018 Fuel Oil Sales

ae3f-9i8xEnvironment21 columns
NYC Fuel Oil Deliveries - Companies that deliver heating oil and biodiesel to buildings in New York City are required by Local Law 43 of 2010 to disclose the amount in gallons of each fuel oil grade delivered to buildings by zip code (non-wholesale only) on an annual basis. The Local Law also requires minimum biodiesel content and limits sulfur levels in fuel oil. This dataset details the amount of fuel oil delivered to each NYC Zip Code and offers a breakdown of the biodiesel blend.
View on NYC Open Data↗

Quality

C73.3 / 100

From a 349-row sample across 21 columns.

completeness100/ 25% weight
consistency50/ 20% weight
accuracy94/ 20% weight
timeliness10/ 15% weight
usability90/ 20% weight
  • · No obvious temporal column — limits time-series joins
  • · Has geographic keys — joinable to other NYC datasets

Related datasets

  • Office of Climate and Sustainability: 2017 Fuel Oil Sales0.94
    joins ontotal_4_fuel_oil_with_2total_2_fuel_oil_with_10total_4_fuel_oil_with_5+16
  • Office of Climate and Sustainability: 2019 Fuel Oil Sales0.82
    joins ontotal_2_fuel_oil_withoutzip_codetotal_biodiesel_blended_with_1+3
  • Natural Gas Consumption by ZIP Code - 20100.26
    joins onzip_code
  • New York City Climate Projections: Extreme Events and Sea Level Rise0.24

Geography

Has zip codes (`zip_code`) — joinable, but needs boundary shapes to draw.

Sample rows

zip_codetotal_2_fuel_oil_with_0total_2_fuel_oil_with_2total_2_fuel_oil_with_5total_2_fuel_oil_with_6total_2_fuel_oil_with_10total_2_fuel_oil_with_14total_2_fuel_oil_with_20total_2_fuel_oil_withouttotal_biodiesel_blended_withtotal_4_fuel_oil_with_0total_4_fuel_oil_with_2
10000024997.3512254.6360631.94023134.200113028.757989.380

Columns

21 queryable · 21 profiled

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

FieldTypeDescriptionNullValues
zip_codeinteger—0%112201019710098
total_2_fuel_oil_with_0categorical—0%025574.301300.70of 14
total_2_fuel_oil_with_2float—0%010.1212.69
total_2_fuel_oil_with_5float—0%01868.236056.07
total_2_fuel_oil_with_6

Query this from your own app

GET /api/datasets/ae3f-9i8x
GET /api/datasets/ae3f-9i8x/quality
GET /api/datasets/ae3f-9i8x/related
GET /api/columns?dataset=ae3f-9i8x
  • Local Law 84 Monthly Data (Calendar Year)0.24
  • Historic Land Use Data0.22
  • Current Reservoir Levels0.22
  • Forestry Tree Points0.22
    • 0
    100010133550.522493316.01933985.7725690.801038.103164.003404022.03186723.1770617.000
    10002065542.15835227.15282582.65209905.009990.3010014.001328842.1484419.1000
    100030125915.372709482.22773850.9490212.508211.2038737.703544068.09202341.8300
    1000406176.99171463.376522.76000175075.059088.0700
    1000502803.4945833.394637.9800050648.842626.0200
    1000602522.9829737.976261.1100036609.041913.0300
    10007020717.16357825.7334048.2005364.000396855.6021099.4800
    10008024461.70291352.5045985.70000343983.8917816.0000
    10009062661.391300933.68260926.66058804.8029818.801616993.3996151.9400

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

    float
    —
    0%
    0438768.22510.03
    total_2_fuel_oil_with_10float—0%05000.002237.40
    total_2_fuel_oil_with_14float—0%01523.2010946.60
    total_2_fuel_oil_with_20float—0%0215.30256.70
    total_2_fuel_oil_withoutfloat—0%0114.611008.66
    total_biodiesel_blended_withfloat—0%0172105.073318.17
    total_4_fuel_oil_with_0float—0%0116921.0057765.00
    total_4_fuel_oil_with_2categorical—0%027842.0039436.30of 9
    total_4_fuel_oil_with_5float—0%02000.00227965.00
    total_4_fuel_oil_with_6float—0%086272.5011701.00
    total_4_fuel_oil_with_10categorical—0%05100.00of 2
    total_4_fuel_oil_withoutfloat—0%01900.006650.29
    total_biodiesel_blended_with_1float—0%0100.00350.02
    total_6_fuel_oil_with_0categorical—0%041427.00of 2
    total_6_fuel_oil_with_5categorical—0%024506.00249491.60of 5
    total_6_fuel_oil_withoutcategorical—0%023280.7041427.00of 6
    total_biodiesel_blended_with_2categorical—0%01225.3012474.58of 5