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

DOHMH Indoor Environmental Complaints

9jgj-bmctHealth19 columns
Indoor Environmental Complaints This data is largely received via complaints to 311; Each record represents a single complaint; This data can be used to help determine if the DOHMH has received an environmental complaint from a particular address; The listing of a particular address does not indicate that a condition or violation was found, only that a complaint was made to DOHMH
View on NYC Open Data↗

Quality

A91.0 / 100

From a 500-row sample across 19 columns.

completeness85/ 25% weight
consistency76/ 20% weight
accuracy97/ 20% weight
timeliness100/ 15% weight
usability100/ 20% weight
  • · Has coordinates — directly mappable, and joinable to other NYC datasets

Related datasets

  • NYC Cooling Tower Registrations0.39
    joins oncouncil_districtcensus_tractlatitude+4
  • NYC Cooling Tower System Inspection Results0.38
    joins oncouncil_districtcensus_tractlatitude+4
  • DOHMH School Cafeteria Inspections (2020-Present)0.36
    joins onlatitudebinbbl+2
  • Recognized Shop Healthy Stores0.36
    joins oncouncil_districtcensus_tractlatitude+5

Geography

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

Open on the map →

Sample rows

complaint_numberincident_addressincident_address_1incident_address_2incident_address_3incident_address_4complaint_statusdate_receiveddeletedcomplaint_type_311descriptor_1_311
T-11-05-25-041716MARKS PL16 MARKS PL10003Manhattan05-Close2011-05-25T00:00:00.000No——
T-10-07-08-0117—

Columns

19 queryable · 19 profiled

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

FieldTypeDescriptionNullValues
complaint_numbertextunique complaint number that is automatically assigned.0%T-10-07-01-0002T-10-07-01-0003T-10-07-01-0004
incident_addresstextaddress number where the condition was reported1%6773066-06
incident_address_1textstreet name where the condition was reported0%BROADWAYLEVERETT AVENUE70 STREET
incident_address_2textaddress number and street name where the condition was reported0%677 LEVERETT AVENUE

Query this from your own app

GET /api/datasets/9jgj-bmct
GET /api/datasets/9jgj-bmct/quality
GET /api/datasets/9jgj-bmct/related
GET /api/columns?dataset=9jgj-bmct
  • NYC Pool Inspections0.35
    joins oncouncil_districtcensus_tractcommunity_board+3
  • Self-Reported Drinking Water Tank Inspection Results0.35
    joins oncouncil_districtcensus_tractlatitude+5
  • NYC Farmers Markets0.35
    joins onlatitudelongitude
  • Rodent Inspection0.33
    joins oncouncil_districtcensus_tractlatitude+5
    • —
    —
    —
    —
    05-Close
    2010-07-08T10:28:35.000
    No
    —
    —
    T-10-08-21-0329———10472Bronx05-Close2010-08-21T12:06:48.000NoAsbestosN/A
    T-10-10-12-0139———11232Brooklyn05-Close2010-10-12T14:20:24.000NoIndoor Air QualityDust from Construction
    T-10-11-16-0263———11234Brooklyn05-Close2010-11-16T06:18:16.000NoIndoor Air QualityOther (Explain Below)
    T-10-12-20-0319———10022Manhattan05-Close2010-12-20T18:54:29.000NoIndoor Air QualityOther (Explain Below)
    T-11-01-24-0356225Vatic St.225 Vatic St.10014Manhattan05-Close2011-01-24T00:00:00.000No——
    T-11-01-28-0431—ANONANON11203Brooklyn05-Close2011-01-28T10:41:51.000NoIndoor Air QualityVentilation
    T-11-02-11-0183———11213Brooklyn05-Close2011-02-11T08:36:27.000NoIndoor Air QualityDust from Construction
    T-11-04-07-0095101Thompkins Ave101 Thompkins Ave10304Staten Island05-Close2011-04-07T10:06:41.000NoAsbestosN/A
    66-06 70 STREET
    541 WEST 142 STREET
    incident_address_3textzip code where the condition was reported0%100251003111226
    incident_address_4categoricalborough where the condition was reported0%ManhattanBrooklynQueensof 5
    complaint_type_311categoricaltype of complaint that is assigned by 311. asbestos, indoor air quality, indoor sewage, mold4%Indoor Air QualityAsbestosIndoor Sewageof 10
    descriptor_1_311categoricalfurther description of the complaint that is assigned by 311 chemical vapors/gases/odors; dry cleaning vapors (PERC); dust from construction; N/A (not applicable); other; public complaint-community location; sewage leak; sewage odor; unsanitary condition; ventilation; workplace - 10 or less staff4%Chemical Vapors/Gases/Od…VentilationOther (Explain Below)of 16
    complaint_statuscategoricalcurrent status of the complaint as assigned by the program. Close - case is closed; Action taken - some action was taken to address the reported condition such as an inpsection or letter; Assigned - the complaint has been assigned to an inspector for follow up; To Be Assigned - case has been reviewed by supervisor and will be assigned for follow up;0%05-Close02-To Be Assigned04-Action Takenof 5
    date_receiveddatetimedate and time that the complaint was received0%2012-03-30T00:00:00.0002010-10-22T00:00:00.0002018-03-12T00:00:00.000
    deletedcategorical—0%NoYesof 2
    latitudefloat—1%40.55471640.71444540.823974
    longitudefloat—1%-74.169599-73.885081-73.95055
    community_boardinteger—1%317
    council_districtinteger—1%324
    census_tractinteger—1%2291701268
    bininteger—2%507458645337341061845
    bblinteger—2%505609002040304875021020740007
    ntatext—1%Upper West SideMidtown-Midtown SouthCrown Heights North