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: 2019 Fuel Oil Sales

psr5-vz6yEnvironment15 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

C72.2 / 100

From a 350-row sample across 15 columns.

completeness100/ 25% weight
consistency50/ 20% weight
accuracy89/ 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: 2018 Fuel Oil Sales0.82
    joins onzip_codetotal_biodiesel_blended_with_1total_4_fuel_oil_without+3
  • Office of Climate and Sustainability: 2017 Fuel Oil Sales0.81
    joins onzip_codetotal_biodiesel_blended_with_1total_4_fuel_oil_without+3
  • Natural Gas Consumption by ZIP Code - 20100.29
    joins onzip_code
  • New York City Climate Projections: Extreme Events and Sea Level Rise0.26
  • New York City Climate Projections: Temperature and Precipitation

Geography

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

Sample rows

zip_code_2_fuel_oil_with_0_biodiesel_2_fuel_oil_with_2_biodiesel_2_fuel_oil_with_5_biodiesel_2_fuel_oil_with_6_biodiesel_2_fuel_oil_with_10_biodiesel_2_fuel_oil_with_17_biodieseltotal_2_fuel_oil_withouttotal_biodiesel_blended_withtotal_biodiesel_blended_with_1_4_fuel_oil_with_2_biodiesel_4_fuel_oil_with_5_biodiesel
100000425.706863674.58984758203.54324770110849879.1037341908.743884.56

Columns

15 queryable · 15 profiled

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

FieldTypeDescriptionNullValues
zip_codeinteger—0%112371122010197
_2_fuel_oil_with_0_biodieselfloat—0%04740.8304
_2_fuel_oil_with_2_biodieselfloat—0%012713.0725750469.41144
_2_fuel_oil_with_5_biodieselfloat—0%080122.21656145392.8109
_2_fuel_oil_with_6_biodiesel

Query this from your own app

GET /api/datasets/psr5-vz6y
GET /api/datasets/psr5-vz6y/quality
GET /api/datasets/psr5-vz6y/related
GET /api/columns?dataset=psr5-vz6y
0.23
  • DSNY Special Waste Drop-off Sites0.23
  • NYCDEP Citywide Catch Basins0.23
  • DSNY Litter Basket Inventory0.23
    • 0
    0
    100010104897.47811276470.1181466960.7375300411452744753.584159861.75708384.8728233.95679878615.3
    100021025.444135.18597114240.5072819264.8591228196.195421140772.48281332.57308346.871900.23266931878
    100030109173.6697799006.7671997289.21388278.168822846575.635176447.61741284.0411745.99101334085.9
    1000403759.13678528112.6537972218.856290098276.700075813.9525469.297764.03364924453
    1000502177.91462454587.301363541.3264470057321.139492985.4014449.63544.412696228350
    1000601309.0217222231.4590712706.382630034346.727081900.148769.48542.16783428233.1
    1000706571.536687131992.825937860.7492205541172021.42499944.6944348.971444.39313446449
    10008096.0183290316.823765692545.909249002503.235234155.52656.1600
    10009045325.15648224641.3068890712.41972300581591172573.53982481.84310213.051018.29562353027.2

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

    float
    —
    0%
    010396.83289751311.818
    _2_fuel_oil_with_10_biodieselfloat—0%0135948.971607.4
    _2_fuel_oil_with_17_biodieselinteger—0%03270239737
    total_2_fuel_oil_withoutfloat—0%0499041.71433021181.044
    total_biodiesel_blended_withfloat—0%0110.1838766.90
    total_biodiesel_blended_with_1float—0%090353.07338547.78
    _4_fuel_oil_with_2_biodieselfloat—0%00.42823291457228.437174
    _4_fuel_oil_with_5_biodieselfloat—0%02720111004
    _4_fuel_oil_with_6_biodieselfloat—0%067356.2580812916.31152
    total_4_fuel_oil_withoutfloat—0%027416.4781958455.81698
    total_biodiesel_blended_with_2float—0%06916.105723716.995564