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

Natural Gas Consumption by ZIP Code - 2010

uedp-fegmEnvironment14 columns
2010 Natural Gas consumption in therms and GJ, by ZIP code, building type, and utility company.
View on NYC Open Data↗

Quality

C75.2 / 100

From a 500-row sample across 10 columns.

completeness94/ 25% weight
consistency65/ 20% weight
accuracy97/ 20% weight
timeliness9/ 15% weight
usability90/ 20% weight
  • · No obvious temporal column — limits time-series joins
  • · Has coordinates — directly mappable, and joinable to other NYC datasets

Related datasets

  • DSNY Litter Basket Inventory0.36
    joins on:@computed_region_sbqj_enih:@computed_region_yeji_bk3q:@computed_region_f5dn_yrer+2
  • DSNY Special Waste Drop-off Sites0.32
    joins on:@computed_region_sbqj_enih:@computed_region_yeji_bk3q:@computed_region_f5dn_yrer+2
  • Forestry Tree Points0.30
    joins on:@computed_region_sbqj_enih:@computed_region_yeji_bk3q:@computed_region_f5dn_yrer+2
  • Electronics Drop Off Locations in NYC0.30

Geography

Mappable — Socrata point column `zip_code`.

Open on the map →

Sample rows

zip_codebuilding_type_service_class_consumption_therms__consumption_gj_utility_data_source
{"human_address":"{\"address\": \"\", \"city\": \"\", \"state\": \"\", \"zip\": \"10300\"}"}Commercial47050National Grid
{"human_address":"{\"address\": \"\", \"city\": \"\", \"state\": \"\", \"zip\": \"10335\"}"}Commercial64768National Grid
{"human_address":"{\"address\": \"\", \"city\": \"\", \"state\": \"\", \"zip\": \"10360\"}"}Large residential337623562

Columns

5 queryable · 4 profiled

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

FieldTypeDescriptionNullValues
zip_codecoordinate———
building_type_service_classcategorical—0%CommercialResidentialSmall residentialof 7
_consumption_therms_integer—1%32408610352199283731
_consumption_gj_integer—1%2191872307
utility_data_sourcecategorical—

Query this from your own app

GET /api/datasets/uedp-fegm
GET /api/datasets/uedp-fegm/quality
GET /api/datasets/uedp-fegm/related
GET /api/columns?dataset=uedp-fegm
joins on
:@computed_region_sbqj_enih
:@computed_region_yeji_bk3q
:@computed_region_f5dn_yrer
+2
  • Food Scrap Drop-Off Locations in NYC0.30
    joins on:@computed_region_sbqj_enih:@computed_region_yeji_bk3q:@computed_region_f5dn_yrer+2
  • NYCDEP Citywide Catch Basins0.29
    joins on:@computed_region_sbqj_enih:@computed_region_yeji_bk3q:@computed_region_f5dn_yrer+1
  • New York City Climate Projections: Extreme Events and Sea Level Rise0.29
  • 1995 Street Tree Census0.29
    joins on:@computed_region_sbqj_enih:@computed_region_yeji_bk3q:@computed_region_f5dn_yrer+2
    • National Grid
    {"human_address":"{\"address\": \"\", \"city\": \"\", \"state\": \"\", \"zip\": \"11200\"}"}Commercial321253389National Grid
    {"human_address":"{\"address\": \"\", \"city\": \"\", \"state\": \"\", \"zip\": \"11200\"}"}Institutional3605380National Grid
    {"human_address":"{\"address\": \"\", \"city\": \"\", \"state\": \"\", \"zip\": \"11200\"}"}Small residential3960418National Grid
    {"human_address":"{\"address\": \"\", \"city\": \"\", \"state\": \"\", \"zip\": \"11254\"}"}Small residential1896200National Grid
    {"human_address":"{\"address\": \"\", \"city\": \"\", \"state\": \"\", \"zip\": \"11274\"}"}Commercial8364882National Grid
    {"human_address":"{\"address\": \"\", \"city\": \"\", \"state\": \"\", \"zip\": \"11279\"}"}Commercial2579272National Grid
    {"human_address":"{\"address\": \"\", \"city\": \"\", \"state\": \"\", \"zip\": \"11279\"}"}Large residential30132National Grid
    0%
    ConEdNational Gridof 2