{"columns":[{"alerts":[{"code":"long_tail","level":"info","message":"1000 singleton categories"}],"column":"unique_key","extras":{"singletons":1000,"top_values":[["67519092",1],["67525266",1],["67525239",1],["67521094",1],["67519046",1],["67519060",1],["67524218",1],["67524221",1],["67520253",1],["67519078",1],["67522157",1],["67521098",1],["67524234",1],["67523183",1],["67519091",1],["67524231",1],["67520104",1],["67521095",1],["67522127",1],["67523186",1]]},"kind":"categorical","n":1000,"n_null":0,"n_unique":1000,"null_rate":0.0,"stats":{"cardinality":1000,"entropy":9.965784284662087,"entropy_ratio":1.0,"top_rate":0.001,"top_value":"67519092"}},{"alerts":[{"code":"long_tail","level":"info","message":"889 singleton categories"}],"column":"created_date","extras":{"singletons":889,"top_values":[["2026-01-17T23:49:56.000",9],["2026-01-17T23:43:55.000",4],["2026-01-18T01:11:10.000",3],["2026-01-17T23:04:06.000",3],["2026-01-18T01:25:57.000",2],["2026-01-18T01:25:16.000",2],["2026-01-18T01:18:23.000",2],["2026-01-18T01:12:27.000",2],["2026-01-18T01:08:57.000",2],["2026-01-18T01:07:55.000",2],["2026-01-18T01:04:36.000",2],["2026-01-18T01:02:54.000",2],["2026-01-18T00:53:20.000",2],["2026-01-18T00:47:20.000",2],["2026-01-18T00:38:56.000",2],["2026-01-18T00:35:43.000",2],["2026-01-18T00:35:09.000",2],["2026-01-18T00:31:54.000",2],["2026-01-18T00:28:06.000",2],["2026-01-18T00:26:25.000",2]]},"kind":"categorical","n":1000,"n_null":0,"n_unique":939,"null_rate":0.0,"stats":{"cardinality":939,"entropy":9.82774518464478,"entropy_ratio":0.9952165820525608,"top_rate":0.009,"top_value":"2026-01-17T23:49:56.000"}},{"alerts":[],"column":"agency","extras":{"singletons":0,"top_values":[["NYPD",880],["HPD",74],["DOHMH",13],["DOT",11],["TLC",6],["DSNY",6],["DHS",2],["OOS",2],["DCWP",2],["DPR",2],["DEP",2]]},"kind":"categorical","n":1000,"n_null":0,"n_unique":11,"null_rate":0.0,"stats":{"cardinality":11,"entropy":0.771509173554346,"entropy_ratio":0.22301616525614423,"top_rate":0.88,"top_value":"NYPD"}},{"alerts":[],"column":"agency_name","extras":{"singletons":0,"top_values":[["New York City Police Department",880],["Department of Housing Preservation and Development",74],["Department of Health and Mental Hygiene",13],["Department of Transportation",11],["Taxi and Limousine Commission",6],["Department of Sanitation",6],["Department of Homeless Services",2],["Office of the Sheriff",2],["Department of Consumer and Worker Protection",2],["Department of Parks and Recreation",2],["Department of Environmental Protection",2]]},"kind":"categorical","n":1000,"n_null":0,"n_unique":11,"null_rate":0.0,"stats":{"cardinality":11,"entropy":0.771509173554346,"entropy_ratio":0.22301616525614423,"top_rate":0.88,"top_value":"New York City Police Department"}},{"alerts":[],"column":"complaint_type","extras":{"singletons":16,"top_values":[["Noise - Residential",393],["Illegal Parking",197],["Noise - Commercial",148],["Blocked Driveway",55],["HEAT/HOT WATER",49],["Noise - Street/Sidewalk",44],["Noise - Vehicle",17],["UNSANITARY CONDITION",12],["Street Condition",7],["Non-Emergency Police Matter",7],["Smoking or Vaping",5],["Abandoned Vehicle",5],["Animal-Abuse",5],["Rodent",4],["Encampment",4],["Taxi Complaint",3],["Dirty Condition",3],["PAINT/PLASTER",3],["GENERAL",3],["Drinking",2]]},"kind":"categorical","n":1000,"n_null":0,"n_unique":45,"null_rate":0.0,"stats":{"cardinality":45,"entropy":2.93524705925224,"entropy_ratio":0.5344729743798008,"top_rate":0.393,"top_value":"Noise - Residential"}},{"alerts":[],"column":"descriptor","extras":{"singletons":34,"top_values":[["Loud Music/Party",427],["Banging/Pounding",114],["Blocked Hydrant",79],["No Access",45],["Posted Parking Sign Violation",42],["Loud Talking",36],["ENTIRE BUILDING",35],["Blocked Sidewalk",21],["Commercial Overnight Parking",20],["APARTMENT ONLY",14],["Car/Truck Music",13],["Double Parked Blocking Traffic",13],["Loud Television",10],["Partial Access",10],["PESTS",10],["Blocked Crosswalk",9],["Pothole",6],["Allowed in Smoke Free Area",5],["With License Plate",5],["No Shelter",5]]},"kind":"categorical","n":1000,"n_null":0,"n_unique":71,"null_rate":0.0,"stats":{"cardinality":71,"entropy":3.539925891192192,"entropy_ratio":0.5756213747334228,"top_rate":0.427,"top_value":"Loud Music/Party"}},{"alerts":[],"column":"location_type","extras":{"singletons":5,"top_values":[["Residential Building/House",396],["Street/Sidewalk",324],["Club/Bar/Restaurant",91],["RESIDENTIAL BUILDING",74],["Store/Commercial",60],["Street",8],["Residential Building",7],["Sidewalk",5],["3+ Family Apartment Building",3],["House and Store",3],["3+ Family Apt. Building",2],["Business",2],["Subway",2],["Other",2],["Park/Playground",2],["1-2 Family Mixed Use Building",1],["Restaurant/Bar/Deli/Bakery",1],["Bridge",1],["Taxi",1],["1-2 Family Dwelling",1]]},"kind":"categorical","n":1000,"n_null":14,"n_unique":20,"null_rate":0.014,"stats":{"cardinality":20,"entropy":2.237300003243585,"entropy_ratio":0.517662477052824,"top_rate":0.40162271805273836,"top_value":"Residential Building/House"}},{"alerts":[],"column":"incident_zip","extras":{"singletons":22,"top_values":[["10011",42],["11421",35],["11385",29],["10463",22],["10031",22],["11368",21],["10456",20],["10009",19],["10462",17],["10002",16],["11206",15],["11212",15],["11226",14],["11375",14],["10012",14],["11373",14],["10461",13],["10452",12],["10468",12],["10034",12]]},"kind":"categorical","n":1000,"n_null":3,"n_unique":146,"null_rate":0.003,"stats":{"cardinality":146,"entropy":6.695652526436562,"entropy_ratio":0.93126785940373,"top_rate":0.04212637913741224,"top_value":"10011"}},{"alerts":[{"code":"long_tail","level":"info","message":"664 singleton categories"}],"column":"incident_address","extras":{"singletons":664,"top_values":[["126 WEST 13 STREET",31],["60 EAST   93 STREET",13],["71 LENOX AVENUE",8],["105 MACDOUGAL STREET",8],["1465 WASHINGTON AVENUE",8],["2918 BRUCKNER BOULEVARD",7],["190 AVENUE OF THE AMERICAS",5],["235 COURT STREET",5],["74-03 85 DRIVE",5],["85 TOMPKINS AVENUE",5],["1365 5 AVENUE",4],["112-17 NORTHERN BOULEVARD",4],["182 NAGLE AVENUE",4],["108-26 159 STREET",4],["402 ONDERDONK AVENUE",4],["465 SENECA AVENUE",3],["2140 MATTHEWS AVENUE",3],["28-10 JACKSON AVENUE",3],["62-11 108 STREET",3],["499 MYRTLE AVENUE",3]]},"kind":"categorical","n":1000,"n_null":5,"n_unique":776,"null_rate":0.005,"stats":{"cardinality":776,"entropy":9.320981485925913,"entropy_ratio":0.9709443865953198,"top_rate":0.031155778894472363,"top_value":"126 WEST 13 STREET"}},{"alerts":[{"code":"long_tail","level":"info","message":"371 singleton categories"}],"column":"street_name","extras":{"singletons":371,"top_values":[["WEST 13 STREET",31],["EAST   93 STREET",13],["JAMAICA AVENUE",11],["WASHINGTON AVENUE",11],["LENOX AVENUE",10],["MACDOUGAL STREET",10],["BROADWAY",9],["BRUCKNER BOULEVARD",8],["BROOKLYN AVENUE",7],["NORTHERN BOULEVARD",7],["76 STREET",7],["COURT STREET",6],["EAST 74 STREET",6],["GRAND STREET",5],["BUSHWICK AVENUE",5],["EAST 3 STREET",5],["SENECA AVENUE",5],["111 AVENUE",5],["AVENUE OF THE AMERICAS",5],["AMSTERDAM AVENUE",5]]},"kind":"categorical","n":1000,"n_null":5,"n_unique":569,"null_rate":0.005,"stats":{"cardinality":569,"entropy":8.741657607343535,"entropy_ratio":0.9551339100521746,"top_rate":0.031155778894472363,"top_value":"WEST 13 STREET"}},{"alerts":[{"code":"long_tail","level":"info","message":"324 singleton categories"}],"column":"cross_street_1","extras":{"singletons":324,"top_values":[["AVENUE OF THE AMERICAS",35],["BLEECKER STREET",11],["AMSTERDAM AVENUE",11],["WEST 113 STREET",8],["HIMROD STREET",8],["112 STREET",8],["ST PAULS PLACE",8],["DEXTER COURT",8],["EAST TREMONT AVENUE",7],["BROADWAY",7],["BEND",6],["107 AVENUE",6],["80 STREET",6],["AVENUE B",6],["3 AVENUE",6],["EAST 182 STREET",5],["5 AVENUE",5],["4 AVENUE",5],["VANDAM STREET",5],["DEAD END",5]]},"kind":"categorical","n":1000,"n_null":80,"n_unique":511,"null_rate":0.08,"stats":{"cardinality":511,"entropy":8.573963091892232,"entropy_ratio":0.952961215240614,"top_rate":0.03804347826086957,"top_value":"AVENUE OF THE AMERICAS"}},{"alerts":[{"code":"long_tail","level":"info","message":"321 singleton categories"}],"column":"cross_street_2","extras":{"singletons":321,"top_values":[["7 AVENUE",36],["BROADWAY",19],["MINETTA LANE",10],["DEAD END",10],["109 AVENUE",9],["EAST 171 STREET",9],["WEST 114 STREET",8],["HARMAN STREET",8],["75 STREET",8],["EDISON AVENUE",7],["112 PLACE",7],["BEND",7],["AVENUE D",6],["DITMAS AVENUE",6],["EAST 174 STREET",6],["10 AVENUE",6],["3 AVENUE",6],["1 AVENUE",6],["EAST 170 STREET",6],["BALTIC STREET",6]]},"kind":"categorical","n":1000,"n_null":79,"n_unique":504,"null_rate":0.079,"stats":{"cardinality":504,"entropy":8.511207967076718,"entropy_ratio":0.9480831654582635,"top_rate":0.03908794788273615,"top_value":"7 AVENUE"}},{"alerts":[{"code":"long_tail","level":"info","message":"319 singleton categories"}],"column":"intersection_street_1","extras":{"singletons":319,"top_values":[["AVENUE OF THE AMERICAS",35],["BLEECKER STREET",11],["AMSTERDAM AVENUE",11],["WEST 113 STREET",8],["HIMROD STREET",8],["112 STREET",8],["ST PAULS PLACE",8],["DEXTER COURT",8],["EAST TREMONT AVENUE",7],["BROADWAY",7],["BEND",6],["5 AVENUE",6],["107 AVENUE",6],["80 STREET",6],["AVENUE B",6],["3 AVENUE",6],["EAST 182 STREET",5],["4 AVENUE",5],["VANDAM STREET",5],["DEAD END",5]]},"kind":"categorical","n":1000,"n_null":85,"n_unique":506,"null_rate":0.085,"stats":{"cardinality":506,"entropy":8.557901103274466,"entropy_ratio":0.9526780835491903,"top_rate":0.03825136612021858,"top_value":"AVENUE OF THE AMERICAS"}},{"alerts":[{"code":"long_tail","level":"info","message":"316 singleton categories"}],"column":"intersection_street_2","extras":{"singletons":316,"top_values":[["7 AVENUE",36],["BROADWAY",19],["MINETTA LANE",10],["DEAD END",10],["109 AVENUE",9],["EAST 171 STREET",9],["WEST 114 STREET",8],["HARMAN STREET",8],["75 STREET",8],["EDISON AVENUE",7],["112 PLACE",7],["BEND",7],["AVENUE D",6],["DITMAS AVENUE",6],["EAST 174 STREET",6],["10 AVENUE",6],["3 AVENUE",6],["1 AVENUE",6],["EAST 170 STREET",6],["BALTIC STREET",6]]},"kind":"categorical","n":1000,"n_null":84,"n_unique":499,"null_rate":0.084,"stats":{"cardinality":499,"entropy":8.49512951839745,"entropy_ratio":0.9478107871985503,"top_rate":0.039301310043668124,"top_value":"7 AVENUE"}},{"alerts":[{"code":"imbalance","level":"warn","message":"top value is 97.2% of rows"}],"column":"address_type","extras":{"singletons":0,"top_values":[["ADDRESS",970],["INTERSECTION",19],["BLOCKFACE",7],["PLACE",2]]},"kind":"categorical","n":1000,"n_null":2,"n_unique":4,"null_rate":0.002,"stats":{"cardinality":4,"entropy":0.21685610937324587,"entropy_ratio":0.10842805468662293,"top_rate":0.9719438877755511,"top_value":"ADDRESS"}},{"alerts":[],"column":"city","extras":{"singletons":3,"top_values":[["BROOKLYN",250],["NEW YORK",249],["BRONX",198],["WOODHAVEN",35],["JAMAICA",29],["RIDGEWOOD",29],["CORONA",20],["ASTORIA",14],["ELMHURST",14],["FOREST HILLS",11],["STATEN ISLAND",11],["SOUTH OZONE PARK",11],["OZONE PARK",9],["SOUTH RICHMOND HILL",9],["REGO PARK",9],["JACKSON HEIGHTS",9],["RICHMOND HILL",7],["COLLEGE POINT",6],["QUEENS",6],["WOODSIDE",6]]},"kind":"categorical","n":1000,"n_null":21,"n_unique":36,"null_rate":0.021,"stats":{"cardinality":36,"entropy":3.2823257748907886,"entropy_ratio":0.6348884701373968,"top_rate":0.2553626149131767,"top_value":"BROOKLYN"}},{"alerts":[{"code":"long_tail","level":"info","message":"335 singleton categories"}],"column":"landmark","extras":{"singletons":335,"top_values":[["WEST 13 STREET",31],["JAMAICA AVENUE",11],["WASHINGTON AVENUE",11],["LENOX AVENUE",10],["MAC DOUGAL STREET",10],["BRUCKNER BOULEVARD",8],["BROADWAY",8],["BROOKLYN AVENUE",7],["NORTHERN BOULEVARD",7],["76 STREET",7],["COURT STREET",6],["EAST 74 STREET",6],["GRAND STREET",5],["BUSHWICK AVENUE",5],["EAST 3 STREET",5],["SENECA AVENUE",5],["111 AVENUE",5],["AVENUE OF THE AMERICAS",5],["MYRTLE AVENUE",5],["90 STREET",5]]},"kind":"categorical","n":1000,"n_null":105,"n_unique":515,"null_rate":0.105,"stats":{"cardinality":515,"entropy":8.60303215680372,"entropy_ratio":0.9549980931997792,"top_rate":0.034636871508379886,"top_value":"WEST 13 STREET"}},{"alerts":[],"column":"status","extras":{"singletons":0,"top_values":[["Closed",610],["In Progress",305],["Open",85]]},"kind":"categorical","n":1000,"n_null":0,"n_unique":3,"null_rate":0.0,"stats":{"cardinality":3,"entropy":1.2597971843984048,"entropy_ratio":0.7948435271025015,"top_rate":0.61,"top_value":"Closed"}},{"alerts":[],"column":"community_board","extras":{"singletons":7,"top_values":[["02 MANHATTAN",56],["09 QUEENS",48],["03 MANHATTAN",38],["05 QUEENS",38],["12 QUEENS",30],["03 BRONX",29],["12 MANHATTAN",29],["10 MANHATTAN",28],["08 BRONX",28],["09 MANHATTAN",28],["17 BROOKLYN",27],["10 QUEENS",27],["03 QUEENS",25],["01 BROOKLYN",24],["06 QUEENS",24],["11 BROOKLYN",23],["04 BROOKLYN",22],["09 BRONX",21],["04 QUEENS",20],["10 BRONX",20]]},"kind":"categorical","n":1000,"n_null":0,"n_unique":65,"null_rate":0.0,"stats":{"cardinality":65,"entropy":5.6103285186107605,"entropy_ratio":0.9315818450134661,"top_rate":0.056,"top_value":"02 MANHATTAN"}},{"alerts":[],"column":"council_district","extras":{"singletons":0,"top_values":[["03",56],["32",48],["02",39],["34",38],["13",36],["10",36],["07",33],["16",32],["09",32],["28",30],["01",28],["11",26],["30",25],["21",25],["17",24],["14",24],["47",24],["41",23],["35",22],["18",22]]},"kind":"categorical","n":1000,"n_null":9,"n_unique":51,"null_rate":0.009,"stats":{"cardinality":51,"entropy":5.411857563455405,"entropy_ratio":0.954064132569874,"top_rate":0.056508577194752774,"top_value":"03"}},{"alerts":[],"column":"police_precinct","extras":{"singletons":6,"top_values":[["Precinct 6",50],["Precinct 102",48],["Precinct 104",38],["Precinct 42",29],["Precinct 50",28],["Precinct 67",27],["Precinct 106",27],["Precinct 30",26],["Precinct 110",24],["Precinct 112",24],["Precinct 62",23],["Precinct 115",23],["Precinct 83",22],["Precinct 43",21],["Precinct 9",20],["Precinct 103",20],["Precinct 45",20],["Precinct 49",19],["Precinct 34",19],["Precinct 32",18]]},"kind":"categorical","n":1000,"n_null":0,"n_unique":76,"null_rate":0.0,"stats":{"cardinality":76,"entropy":5.846690931820852,"entropy_ratio":0.9357808520090226,"top_rate":0.05,"top_value":"Precinct 6"}},{"alerts":[{"code":"long_tail","level":"info","message":"606 singleton categories"}],"column":"bbl","extras":{"singletons":606,"top_values":[["1006080026",31],["3045950215",13],["1018230033",8],["1005420048",8],["2029020036",8],["2054190122",7],["4017067501",7],["1005040011",5],["3003960004",5],["4088380065",5],["3017400001",5],["1016180001",4],["1022170047",4],["4101460051",4],["1021700112",4],["4034270030",4],["4034300001",3],["2043230014",3],["2039437501",3],["2024090096",3]]},"kind":"categorical","n":1000,"n_null":55,"n_unique":719,"null_rate":0.055,"stats":{"cardinality":719,"entropy":9.18915491560141,"entropy_ratio":0.968314240007701,"top_rate":0.0328042328042328,"top_value":"1006080026"}},{"alerts":[],"column":"borough","extras":{"singletons":0,"top_values":[["QUEENS",274],["MANHATTAN",258],["BROOKLYN",254],["BRONX",203],["STATEN ISLAND",11]]},"kind":"categorical","n":1000,"n_null":0,"n_unique":5,"null_rate":0.0,"stats":{"cardinality":5,"entropy":2.056784012597972,"entropy_ratio":0.8858086592460769,"top_rate":0.274,"top_value":"QUEENS"}},{"alerts":[{"code":"long_tail","level":"info","message":"643 singleton categories"}],"column":"x_coordinate_state_plane","extras":{"singletons":643,"top_values":[["984721",31],["1004501",13],["997870",8],["984032",8],["1010885",8],["1031969",7],["983238",5],["985877",5],["1020825",5],["999077",5],["998703",4],["1023829",4],["1005224",4],["1041463",4],["1008285",4],["1008323",3],["995971",3],["1022177",3],["1007992",3],["1001276",3]]},"kind":"categorical","n":1000,"n_null":7,"n_unique":763,"null_rate":0.007,"stats":{"cardinality":763,"entropy":9.292358834150663,"entropy_ratio":0.9704266876899408,"top_rate":0.03121852970795569,"top_value":"984721"}},{"alerts":[{"code":"long_tail","level":"info","message":"651 singleton categories"}],"column":"y_coordinate_state_plane","extras":{"singletons":651,"top_values":[["207809",31],["180649",13],["230926",8],["205111",8],["244212",8],["242900",7],["203929",5],["189205",5],["191901",5],["193110",5],["230311",4],["215511",4],["253267",4],["192497",4],["197077",4],["196526",3],["250862",3],["240061",3],["211978",3],["207649",3]]},"kind":"categorical","n":1000,"n_null":7,"n_unique":768,"null_rate":0.007,"stats":{"cardinality":768,"entropy":9.303949745534679,"entropy_ratio":0.9706819139704163,"top_rate":0.03121852970795569,"top_value":"207809"}},{"alerts":[],"column":"open_data_channel_type","extras":{"singletons":0,"top_values":[["ONLINE",466],["MOBILE",288],["PHONE",236],["UNKNOWN",10]]},"kind":"categorical","n":1000,"n_null":0,"n_unique":4,"null_rate":0.0,"stats":{"cardinality":4,"entropy":1.5886121002395381,"entropy_ratio":0.7943060501197691,"top_rate":0.466,"top_value":"ONLINE"}},{"alerts":[{"code":"imbalance","level":"warn","message":"top value is 99.9% of rows"}],"column":"park_facility_name","extras":{"singletons":1,"top_values":[["Unspecified",999],["Flushing Meadows Corona Park",1]]},"kind":"categorical","n":1000,"n_null":0,"n_unique":2,"null_rate":0.0,"stats":{"cardinality":2,"entropy":0.011407757737461138,"entropy_ratio":0.011407757737461138,"top_rate":0.999,"top_value":"Unspecified"}},{"alerts":[],"column":"park_borough","extras":{"singletons":0,"top_values":[["QUEENS",274],["MANHATTAN",258],["BROOKLYN",254],["BRONX",203],["STATEN ISLAND",11]]},"kind":"categorical","n":1000,"n_null":0,"n_unique":5,"null_rate":0.0,"stats":{"cardinality":5,"entropy":2.056784012597972,"entropy_ratio":0.8858086592460769,"top_rate":0.274,"top_value":"QUEENS"}},{"alerts":[{"code":"long_tail","level":"info","message":"655 singleton categories"}],"column":"latitude","extras":{"singletons":655,"top_values":[["40.73706433046593",31],["40.662493333971206",13],["40.800504000346805",8],["40.72965899371875",8],["40.83694066292417",8],["40.83325085108711",7],["40.726414636772915",5],["40.68600063896156",5],["40.693325110944265",5],["40.696706691928384",5],["40.79881467021513",4],["40.75811580959723",4],["40.861809211135316",4],["40.694851633900804",4],["40.70757495380374",4],["40.7060624863299",3],["40.85515165955753",3],["40.82555561649529",3],["40.74849081688869",3],["40.73652935637317",3]]},"kind":"categorical","n":1000,"n_null":7,"n_unique":770,"null_rate":0.007,"stats":{"cardinality":770,"entropy":9.30797794291635,"entropy_ratio":0.9707221767113454,"top_rate":0.03121852970795569,"top_value":"40.73706433046593"}},{"alerts":[{"code":"long_tail","level":"info","message":"655 singleton categories"}],"column":"longitude","extras":{"singletons":655,"top_values":[["-73.99830041620608",31],["-73.9270067970956",13],["-73.95080595870716",8],["-74.00078655646078",8],["-73.90374441298103",8],["-73.82755893872277",7],["-74.00365117608368",5],["-73.994133534454",5],["-73.86810717317749",5],["-73.94652977407227",5],["-73.94779857268328",4],["-73.85713563386481",4],["-73.92417422718809",4],["-73.79367980321378",4],["-73.91330906170826",4],["-73.91317397090971",3],["-73.86289896839915",3],["-73.91421404014056",3],["-73.93855184851218",3],["-73.85143729064244",3]]},"kind":"categorical","n":1000,"n_null":7,"n_unique":770,"null_rate":0.007,"stats":{"cardinality":770,"entropy":9.30797794291635,"entropy_ratio":0.9707221767113454,"top_rate":0.03121852970795569,"top_value":"-73.99830041620608"}},{"alerts":[{"code":"skipped","level":"info","message":"no profiler for kind=unknown"}],"column":"location","extras":{},"kind":"unknown","n":1000,"n_null":0,"n_unique":null,"null_rate":0.0,"stats":{}},{"alerts":[],"column":":@computed_region_f5dn_yrer","extras":{"singletons":5,"top_values":[["57",56],["46",48],["70",38],["54",37],["41",30],["34",29],["47",29],["18",28],["48",28],["37",28],["61",27],["62",27],["65",25],["36",24],["1",23],["42",22],["58",21],["40",21],["66",20],["43",20]]},"kind":"categorical","n":1000,"n_null":7,"n_unique":62,"null_rate":0.007,"stats":{"cardinality":62,"entropy":5.590582040128799,"entropy_ratio":0.9389314272988003,"top_rate":0.05639476334340383,"top_value":"57"}},{"alerts":[],"column":":@computed_region_yeji_bk3q","extras":{"singletons":0,"top_values":[["3",269],["4",266],["2",254],["5",193],["1",11]]},"kind":"categorical","n":1000,"n_null":7,"n_unique":5,"null_rate":0.007,"stats":{"cardinality":5,"entropy":2.053885184659362,"entropy_ratio":0.8845602020070295,"top_rate":0.27089627391742194,"top_value":"3"}},{"alerts":[],"column":":@computed_region_sbqj_enih","extras":{"singletons":5,"top_values":[["3",50],["60",48],["62",37],["25",29],["33",28],["40",27],["64",27],["19",26],["68",23],["37",23],["73",23],["53",22],["26",21],["70",21],["61",20],["28",20],["32",19],["5",19],["22",19],["20",18]]},"kind":"categorical","n":1000,"n_null":7,"n_unique":75,"null_rate":0.007,"stats":{"cardinality":75,"entropy":5.845781454873528,"entropy_ratio":0.9385056373198336,"top_rate":0.050352467270896276,"top_value":"3"}},{"alerts":[],"column":":@computed_region_92fq_4b7q","extras":{"singletons":1,"top_values":[["10",64],["34",54],["30",40],["36",36],["32",36],["12",35],["39",35],["46",34],["23",33],["42",28],["50",27],["21",27],["43",27],["40",25],["28",25],["48",24],["45",23],["29",22],["17",22],["35",21]]},"kind":"categorical","n":1000,"n_null":7,"n_unique":51,"null_rate":0.007,"stats":{"cardinality":51,"entropy":5.375734622574111,"entropy_ratio":0.9476959675075658,"top_rate":0.06445115810674723,"top_value":"10"}},{"alerts":[{"code":"long_tail","level":"info","message":"27 singleton categories"},{"code":"null_rate","level":"warn","message":"88.2% null"}],"column":"descriptor_2","extras":{"singletons":27,"top_values":[["NO HEAT",33],["NO HEAT AND NO HOT WATER",10],["N/A",9],["NO HOT WATER",7],["Cannabis Smoking or Vaping",5],["ROACHES",4],["Unsafe Driving - Non-Passenger",3],["Dog",3],["OTHER",3],["Not Cleaned by Property Owner",2],["Parked In Front Of Fire Hydrant",2],["Operating Improperly",2],["AT WALL OR CEILING",2],["FLIES",2],["BROKEN OR MISSING",2],["MISSING OR INADEQUATE CANS/LID",2],["Loose or Improperly Stored Garbage or Food",1],["Droppings",1],["Fare/Tip Complaint",1],["Waste",1]]},"kind":"categorical","n":1000,"n_null":882,"n_unique":43,"null_rate":0.882,"stats":{"cardinality":43,"entropy":4.376376953293927,"entropy_ratio":0.8065174021414276,"top_rate":0.2796610169491525,"top_value":"NO HEAT"}},{"alerts":[{"code":"null_rate","level":"warn","message":"30.7% null"}],"column":"resolution_description","extras":{"singletons":2,"top_values":[["The New York City Police Department responded to the complaint and their investigation determined that no criminal violation existed. The condition was corrected without the need to issue a summons or effect an arrest. If the problem persists, please contact 311 to create another complaint. If possible, provide contact information so responding officers may reach out to you for more details. If necessary, your complaint may be referred to your local precinct's special operations units (Quality of Life, etc.). Thank you for your attention to this matter. We count on New Yorkers like yourself to maintain a safe City, so please let us know if you see other conditions that require our attention.",245],["The New York City Police Department responded to the complaint and with the information available observed no evidence of a criminal violation at that time. If the problem persists, please contact 311 to create another complaint. If possible, provide contact information so responding officers may reach out to you for more details. If necessary, your complaint may be referred to your local precinct's special operations units (Quality of Life, etc.). We count on New Yorkers like yourself to maintain a safe City, so please let us know if you see other conditions that require our attention.",161],["The New York City Police Department responded to the complaint and their investigation determined that a violation of law occurred. Police issued a summons in response to the complaint. Thank you for attention to this matter. We count on New Yorkers like yourself to maintain a safe City, so please let us know if you see other conditions that require our attention.",68],["The New York City Police Department responded to the complaint but officers were unable to gain entry into the premises. If the problem persists, please contact 311 to create another complaint and ensure that contact information (e.g., buzzer number, phone number, etc.) is available to assist the responding officers in gaining entry to properly investigate the complaint.  We count on New Yorkers like yourself to maintain a safe City, so please let us know if you see other conditions that require our attention.",50],["The following complaint conditions are still open. HPD has already attempted to notify the property owner that the condition exists; the tenant should provide access for the owner to make the repair.  HPD may attempt to contact the tenant by phone to verify the correction of the condition or an HPD Inspector may attempt to conduct an inspection.",44],["The New York City Police Department responded to the complaint and their investigation determined that police action was not necessary. If the problem persists, please contact 311 to create another complaint. If possible, provide contact information so responding officers may reach out to you for more details. We count on New Yorkers like yourself to maintain a safe City, so please let us know if you see other conditions that require our attention.",40],["The New York City Police Department responded to the complaint and observed no criminal violation upon their arrival. If the problem persists, please contact 311 to create another complaint. If possible, provide contact information so responding officers may reach out to you for more details. We count on New Yorkers like yourself to maintain a safe City, so please let us know if you see other conditions that require our attention.",31],["This complaint is a duplicate of a building-wide condition already reported by another tenant.  The original complaint is still open, and HPD may only need to confirm that the condition exists by inspecting one apartment.  If we cannot contact the tenant from the original complaint or get access to that apartment, HPD may attempt to contact the person who filed this complaint to verify the correction of the condition or may conduct an inspection of your unit. You can check HPDONLINE to see if a",29],["The Department of Transportation referred this complaint to the appropriate Maintenance Unit for repair.",6],["Your complaint has been received but does not fall under the jurisdiction of the New York City Police Department.  Please contact your local precinct for more information, including which City agency your request was referred to. We count on New Yorkers like yourself to maintain a safe City, so please let us know if you see other conditions that require our attention.",5],["The Police Department reviewed your complaint and provided additional information below.",4],["The New York City Police Department responded to the complaint and a report was prepared as part of their investigation. Thank you for attention to this matter. We count on New Yorkers like yourself to maintain a safe City, so please let us know if you see other conditions that require our attention.",3],["The Department of Health and Mental Hygiene has sent official written notification to the Owner/Landlord warning them of potential violations and instructing them to correct the situation. If the situation persists 21 days after your initial complaint, please make a new complaint.",3],["The New York City Police Department responded to the complaint and observed an encampment at the noted location. The complaint has been referred to the Department of Homeless Services (DHS) for further action. DHS will inspect the condition and update your service request with more information. Thank you for attention to this matter. We count on New Yorkers like yourself to maintain a safe City, so please let us know if you see other conditions that require our attention.",2],["Your complaint has been received by the New York City Police Department and assigned to a unit at your local precinct. The responding officers will conduct an assessment of the complaint and may contact you for further information, if you left contact information. Our team is committed to resolving this matter promptly, and we appreciate your contribution to maintaining the well-being of our community.",1],["The New York City Police Department responded to the complaint and their investigation determined another specific tow is required. Please contact the local precinct for more information. Thank you for attention to this matter. We count on New Yorkers like yourself to maintain a safe City, so please let us know if you see other conditions that require our attention.",1]]},"kind":"categorical","n":1000,"n_null":307,"n_unique":16,"null_rate":0.307,"stats":{"cardinality":16,"entropy":2.777148720917645,"entropy_ratio":0.6942871802294113,"top_rate":0.35353535353535354,"top_value":"The New York City Police Department responded to the complaint and their investigation determined that no criminal violation existed. The condition was corrected without the need to issue a summons or effect an arrest. If the problem persists, please contact 311 to create another complaint. If possible, provide contact information so responding officers may reach out to you for more details. If necessary, your complaint may be referred to your local precinct's special operations units (Quality of Life, etc.). Thank you for your attention to this matter. We count on New Yorkers like yourself to maintain a safe City, so please let us know if you see other conditions that require our attention."}},{"alerts":[{"code":"long_tail","level":"info","message":"548 singleton categories"},{"code":"null_rate","level":"warn","message":"30.6% null"}],"column":"resolution_action_updated_date","extras":{"singletons":548,"top_values":[["2026-01-17T00:00:00.000",74],["2026-01-18T02:03:44.000",2],["2026-01-18T02:04:03.000",2],["2026-01-18T02:01:54.000",2],["2026-01-18T01:35:08.000",2],["2026-01-18T01:41:49.000",2],["2026-01-18T01:26:35.000",2],["2026-01-18T01:32:28.000",2],["2026-01-18T01:25:53.000",2],["2026-01-18T01:54:39.000",2],["2026-01-18T01:19:59.000",2],["2026-01-18T01:09:47.000",2],["2026-01-18T01:00:57.000",2],["2026-01-18T01:04:36.000",2],["2026-01-18T00:58:56.000",2],["2026-01-18T01:07:50.000",2],["2026-01-18T01:27:34.000",2],["2026-01-18T00:46:07.000",2],["2026-01-18T00:55:02.000",2],["2026-01-18T00:40:32.000",2]]},"kind":"categorical","n":1000,"n_null":306,"n_unique":585,"null_rate":0.306,"stats":{"cardinality":585,"entropy":8.672942358260476,"entropy_ratio":0.9435015325672922,"top_rate":0.10662824207492795,"top_value":"2026-01-17T00:00:00.000"}},{"alerts":[{"code":"long_tail","level":"info","message":"561 singleton categories"},{"code":"null_rate","level":"warn","message":"39.0% null"}],"column":"closed_date","extras":{"singletons":561,"top_values":[["2026-01-18T00:41:26.000",3],["2026-01-18T02:02:35.000",2],["2026-01-18T02:03:41.000",2],["2026-01-18T01:41:47.000",2],["2026-01-18T01:26:28.000",2],["2026-01-18T01:45:29.000",2],["2026-01-18T01:54:33.000",2],["2026-01-18T01:07:46.000",2],["2026-01-18T01:27:29.000",2],["2026-01-18T00:46:04.000",2],["2026-01-18T00:40:28.000",2],["2026-01-18T00:55:27.000",2],["2026-01-18T00:41:08.000",2],["2026-01-18T00:20:14.000",2],["2026-01-18T00:37:27.000",2],["2026-01-18T00:22:36.000",2],["2026-01-18T00:36:52.000",2],["2026-01-18T00:17:49.000",2],["2026-01-18T00:28:52.000",2],["2026-01-18T00:20:55.000",2]]},"kind":"categorical","n":1000,"n_null":390,"n_unique":585,"null_rate":0.39,"stats":{"cardinality":585,"entropy":9.169460698840144,"entropy_ratio":0.9975161675012485,"top_rate":0.004918032786885246,"top_value":"2026-01-18T00:41:26.000"}},{"alerts":[{"code":"long_tail","level":"info","message":"6 singleton categories"},{"code":"null_rate","level":"warn","message":"99.4% null"}],"column":"taxi_pick_up_location","extras":{"singletons":6,"top_values":[["55 LITTLE WEST 12 STREET, MANHATTAN (NEW YORK), NY, 10014",1],["JOHN F KENNEDY AIRPORT, QUEENS (JAMAICA) ,NY, 11430",1],["11 WATER STREET, BROOKLYN, NY, 11201",1],["9 AVENUE AND WEST 43 STREET, MANHATTAN, NY, 10036",1],["30 AVENUE AND 33 STREET, QUEENS, NY, 11102",1],["30-08 33 STREET, QUEENS (ASTORIA), NY, 11102",1]]},"kind":"categorical","n":1000,"n_null":994,"n_unique":6,"null_rate":0.994,"stats":{"cardinality":6,"entropy":2.584962500721156,"entropy_ratio":1.0,"top_rate":0.16666666666666666,"top_value":"55 LITTLE WEST 12 STREET, MANHATTAN (NEW YORK), NY, 10014"}},{"alerts":[{"code":"null_rate","level":"warn","message":"96.5% null"}],"column":"vehicle_type","extras":{"singletons":1,"top_values":[["Car",27],["Other",4],["SUV",3],["Van",1]]},"kind":"categorical","n":1000,"n_null":965,"n_unique":4,"null_rate":0.965,"stats":{"cardinality":4,"entropy":1.0968015866427632,"entropy_ratio":0.5484007933213816,"top_rate":0.7714285714285715,"top_value":"Car"}},{"alerts":[{"code":"null_rate","level":"warn","message":"99.0% null"},{"code":"imbalance","level":"warn","message":"top value is 100.0% of rows"}],"column":"facility_type","extras":{"singletons":0,"top_values":[["N/A",10]]},"kind":"categorical","n":1000,"n_null":990,"n_unique":1,"null_rate":0.99,"stats":{"cardinality":1,"entropy":-0.0,"entropy_ratio":0.0,"top_rate":1.0,"top_value":"N/A"}},{"alerts":[{"code":"long_tail","level":"info","message":"1 singleton categories"},{"code":"null_rate","level":"warn","message":"99.9% null"},{"code":"imbalance","level":"warn","message":"top value is 100.0% of rows"}],"column":"taxi_company_borough","extras":{"singletons":1,"top_values":[["BROOKLYN",1]]},"kind":"categorical","n":1000,"n_null":999,"n_unique":1,"null_rate":0.999,"stats":{"cardinality":1,"entropy":-0.0,"entropy_ratio":0.0,"top_rate":1.0,"top_value":"BROOKLYN"}},{"alerts":[{"code":"null_rate","level":"warn","message":"99.7% null"}],"column":"bridge_highway_name","extras":{"singletons":1,"top_values":[["E",2],["Kosciuszko Br - BQE",1]]},"kind":"categorical","n":1000,"n_null":997,"n_unique":2,"null_rate":0.997,"stats":{"cardinality":2,"entropy":0.9182958340544896,"entropy_ratio":0.9182958340544896,"top_rate":0.6666666666666666,"top_value":"E"}},{"alerts":[{"code":"null_rate","level":"warn","message":"99.7% null"}],"column":"bridge_highway_direction","extras":{"singletons":1,"top_values":[["C E Local Downtown & Brooklyn",2],["Queens Bound",1]]},"kind":"categorical","n":1000,"n_null":997,"n_unique":2,"null_rate":0.997,"stats":{"cardinality":2,"entropy":0.9182958340544896,"entropy_ratio":0.9182958340544896,"top_rate":0.6666666666666666,"top_value":"C E Local Downtown & Brooklyn"}},{"alerts":[{"code":"long_tail","level":"info","message":"1 singleton categories"},{"code":"null_rate","level":"warn","message":"99.9% null"},{"code":"imbalance","level":"warn","message":"top value is 100.0% of rows"}],"column":"road_ramp","extras":{"singletons":1,"top_values":[["Ramp",1]]},"kind":"categorical","n":1000,"n_null":999,"n_unique":1,"null_rate":0.999,"stats":{"cardinality":1,"entropy":-0.0,"entropy_ratio":0.0,"top_rate":1.0,"top_value":"Ramp"}},{"alerts":[{"code":"null_rate","level":"warn","message":"99.7% null"}],"column":"bridge_highway_segment","extras":{"singletons":1,"top_values":[["Platform",2],["Ramp",1]]},"kind":"categorical","n":1000,"n_null":997,"n_unique":2,"null_rate":0.997,"stats":{"cardinality":2,"entropy":0.9182958340544896,"entropy_ratio":0.9182958340544896,"top_rate":0.6666666666666666,"top_value":"Platform"}}],"insights":{"errors":[],"insights":[{"confidence":"high","critiques":[],"evidence_keys":["complaint_type.top_value","complaint_type.top_rate","agency.top_value","agency.top_rate","status.top_values","borough.top_values","open_data_channel_type.top_values","descriptor.top_value","road_ramp.null_rate","taxi_company_borough.null_rate"],"featured_charts":[{"caption":"Look for the steep drop-off after 'Noise - Residential' (39.3%) and 'Illegal Parking' (19.7%) \u2014 a small number of complaint types dominate the dataset.","column":"complaint_type","kind":"bar"},{"caption":"With 61% closed, 30.5% in progress, and 8.5% open, check whether specific agencies or complaint types are driving the backlog.","column":"status","kind":"donut"},{"caption":"Queens, Manhattan, and Brooklyn each account for roughly a quarter of complaints, while Staten Island is a clear outlier at just 1.1%.","column":"borough","kind":"bar"},{"caption":"Online (46.6%) and Mobile (28.8%) together dominate submission channels \u2014 look at whether channel type correlates with complaint category.","column":"open_data_channel_type","kind":"donut"},{"caption":"'Loud Music/Party' at 42.7% dwarfs all other descriptors \u2014 confirm whether this single descriptor is inflating the noise complaint count.","column":"descriptor","kind":"bar"}],"model":"anthropic:default","narrative":"This dataset is a sample of 1,000 NYC 311 service requests, capturing complaints logged across the five boroughs with details on complaint type, location, agency, and resolution status. The dominant signal is complaint type: 'Noise - Residential' alone accounts for 39.3% of records, followed by 'Illegal Parking' (19.7%) and 'Noise - Commercial' (14.8%), pointing to a dataset heavily skewed toward NYPD-handled quality-of-life complaints (NYPD handles 88% of cases). A second area worth examining is resolution status \u2014 61% of complaints are closed, 30.5% are still in progress, and 8.5% remain open, which raises questions about agency workload and response time. Many specialty columns (road_ramp, taxi_company_borough, bridge_highway fields) are nearly entirely null (99%+), indicating they apply only to rare complaint subtypes and can largely be ignored.","scope":"dataset","target":"__global__"},{"confidence":"high","critiques":[],"evidence_keys":["null_rate","top_value","top_rate","n_unique","n","entropy_ratio","alerts"],"model":"anthropic:default","narrative":"This column is a timestamp recording when a resolution action was last updated, stored as a categorical string in ISO 8601 format. The 30.6% null rate is a significant concern, indicating roughly one-third of records have no update date logged. Strikingly, one value \u2014 '2026-01-17T00:00:00.000' \u2014 accounts for 10.7% of all non-null records (74 occurrences) with a midnight-exactly timestamp, suggesting a bulk update or default-date assignment rather than genuine event timestamps. All remaining top values appear only twice, confirming a severe long-tail distribution (entropy ratio 0.94) consistent with mostly unique timestamps.","role":"timestamp","scope":"column","target":"resolution_action_updated_date","treatment":"Parse to datetime, flag the 74 midnight '2026-01-17' records as probable synthetic/default dates, and impute or exclude nulls (30.6%) before any time-based feature engineering."},{"confidence":"high","critiques":[],"evidence_keys":["null_rate","n_unique","entropy_ratio","top_value","top_values","n"],"model":"anthropic:default","narrative":"This column is a ticket or record closure timestamp, stored as a string rather than a parsed datetime type, with second-level precision. Two signals demand attention: 39% of rows are null, indicating a large share of records that have not yet been closed (open items); and with 585 unique values across 1,000 rows and an entropy ratio of 0.998, timestamps are nearly all distinct, which is expected for event times but confirms the column carries no categorical signal. All top values cluster on 2026-01-18, suggesting the snapshot or batch was captured on that single date.","role":"timestamp","scope":"column","target":"closed_date","treatment":"Parse to datetime, use nulls as an 'is_open' binary flag, and engineer elapsed-time features (e.g. days-to-close) rather than using raw values."},{"confidence":"high","critiques":[],"evidence_keys":["null_rate","n_unique","top_value","top_rate","entropy_ratio","alerts","top_values"],"model":"anthropic:default","narrative":"This column is a secondary complaint descriptor, likely a sub-category or detail field attached to a service request or complaint record (consistent with NYC 311-style data). It is almost entirely empty \u2014 null_rate is 0.882, meaning only 118 of 1,000 rows carry a value. Among the 43 unique non-null values, 'NO HEAT' dominates at 27.97% of non-null entries (33 occurrences), but the spread across housing, noise, sanitation, and transportation categories (e.g., 'Cannabis Smoking or Vaping', 'Unsafe Driving - Non-Passenger') signals this field is populated inconsistently across complaint types, not a uniform taxonomy. The high entropy_ratio of 0.807 confirms the long-tail alert: values are broadly dispersed despite the sparse fill rate.","role":"label","scope":"column","target":"descriptor_2","treatment":"Filter to non-null rows before use; group rare categories (below a frequency threshold) into 'OTHER' and one-hot encode or target-encode the remainder."},{"confidence":"high","critiques":[],"evidence_keys":["top_value","top_rate","n_unique","entropy","n"],"model":"anthropic:default","narrative":"This column captures the named park facility associated with each record, but it is almost entirely uninformative: 999 of 1000 rows (99.9%) carry the placeholder value 'Unspecified', with only a single record attributed to Flushing Meadows Corona Park. The near-zero entropy (0.011) confirms the column is maximally imbalanced and conveys virtually no discriminative signal. This is likely a poorly populated administrative field rather than a reliable feature.","role":"label","scope":"column","target":"park_facility_name","treatment":"Drop from modelling; if facility-level analysis is ever needed, this field requires back-filling from a source system before use."},{"confidence":"high","critiques":[],"evidence_keys":["top_value","top_rate","cardinality","entropy_ratio","top_values","null_rate"],"model":"anthropic:default","narrative":"This column classifies the type of geographic address entry, with four categories: ADDRESS, INTERSECTION, BLOCKFACE, and PLACE. It is severely imbalanced \u2014 'ADDRESS' dominates at 97.2% of valid records (970/1000), while the remaining three types collectively account for only 28 records. The entropy ratio of 0.108 confirms near-minimal informational diversity, meaning this field will contribute little discriminative power in most models without special handling.","role":"label","scope":"column","target":"address_type","treatment":"One-hot encode with caution; minority classes (INTERSECTION=19, BLOCKFACE=7, PLACE=2) may need oversampling or collapsing into an 'OTHER' bucket before modelling."},{"confidence":"high","critiques":[],"evidence_keys":["n_unique","null_rate","top_value","top_rate","cardinality","alerts"],"model":"anthropic:default","narrative":"This column contains standardized resolution outcome descriptions from NYC 311 service requests, drawn from a fixed vocabulary of only 16 distinct boilerplate phrases. Despite being a text column, it behaves as a low-cardinality categorical: the top value (NYPD 'no criminal violation, condition corrected') accounts for 35.4% of non-null rows. A 30.7% null rate is flagged as an alert, likely reflecting complaints that have not yet been resolved or closed.","role":"label","scope":"column","target":"resolution_description","treatment":"Encode as ordinal or one-hot categorical (16 levels); treat nulls as a distinct 'unresolved' category rather than imputing."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","entropy_ratio","top_value","top_rate","alerts"],"model":"anthropic:default","narrative":"This column is a creation timestamp, stored as a categorical string in ISO-8601 millisecond format (e.g., '2026-01-17T23:49:56.000'). With 939 unique values out of 1000 rows and an entropy ratio of 0.995, it behaves almost like a unique identifier. The long-tail alert and the fact that the most frequent value appears only 9 times (0.9% of rows) suggest occasional duplicate timestamps \u2014 likely batch inserts or rapid successive record creation within the same second.","role":"timestamp","scope":"column","target":"created_date","treatment":"Parse to datetime, then engineer time-based features (hour, day-of-week, recency); do not use raw string for modelling."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","cardinality","entropy_ratio","top_rate","top_values"],"model":"anthropic:default","narrative":"This column is a unique row identifier, likely a primary key or transaction/record ID \u2014 every one of the 1000 rows has a distinct value, giving it perfect cardinality and a maximum entropy ratio of 1.0. Values appear to be numeric strings in a narrow range (~67519046\u201367525266), suggesting sequential or near-sequential ID assignment. There is nothing analytically surprising here beyond the expected long-tail alert, which is a trivial consequence of full uniqueness. The null rate is 0.0.","role":"identifier","scope":"column","target":"unique_key","treatment":"Drop before modelling; retain only for row tracing or joins."},{"confidence":"high","critiques":[],"evidence_keys":["n_unique","entropy_ratio","top_value","top_rate","alerts","null_rate"],"model":"anthropic:default","narrative":"This column contains free-text street addresses of incident locations, likely from a New York City incident or complaints dataset given recognizable street names (Lenox Avenue, Avenue of the Americas, Bruckner Boulevard). With 776 unique values across 1,000 rows and an entropy ratio of 0.97, the distribution is highly dispersed \u2014 a classic long-tail pattern. Notably, '126 WEST 13 STREET' appears 31 times (3.1% of rows), a disproportionate spike that may indicate a shelter, institution, or high-incident venue worth investigating. Inconsistent spacing in values like '60 EAST   93 STREET' suggests formatting irregularities that will need normalization.","role":"feature","scope":"column","target":"incident_address","treatment":"Normalize whitespace and casing, then geocode or extract street/borough components for spatial modelling."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","top_value","top_rate","entropy_ratio","alerts","top_values"],"model":"anthropic:default","narrative":"This column contains street names, almost certainly from a New York City dataset given entries like 'WEST 13 STREET', 'LENOX AVENUE', 'BRUCKNER BOULEVARD', and 'JAMAICA AVENUE'. With 569 unique values across 1,000 rows and an entropy ratio of 0.955, the distribution is highly spread \u2014 the top value 'WEST 13 STREET' appears only 31 times (3.1% of rows), confirming the long-tail alert. The near-zero null rate (0.5%) is clean, but the high cardinality and long tail mean most street names are rare, which limits direct one-hot encoding utility.","role":"feature","scope":"column","target":"street_name","treatment":"Frequency-encode or embed as a categorical feature; avoid one-hot encoding due to 569-level cardinality and long-tail distribution."},{"confidence":"high","critiques":[],"evidence_keys":["cardinality","top_value","top_rate","entropy_ratio","alerts","n","n_unique","null_rate"],"model":"anthropic:default","narrative":"This column contains geographic latitude coordinates stored as strings, with all top values clustering tightly around 40.6\u201340.8\u00b0N \u2014 consistent with New York City's latitude range. Despite being numeric in nature, it was ingested as categorical, yielding 770 unique values across 1,000 rows (entropy ratio 0.97), which is near-unique. The long-tail alert and the top value ('40.73706433046593') appearing 31 times (3.1% of rows) suggests either a default/fallback coordinate or a high-traffic location being logged repeatedly.","role":"feature","scope":"column","target":"latitude","treatment":"Cast to float64, pair with a longitude column for geospatial features, and investigate the 31-row duplicate coordinate for data quality issues before modelling."},{"confidence":"high","critiques":[],"evidence_keys":["top_value","top_rate","n_unique","n","entropy_ratio","alerts","null_rate","top_values"],"model":"anthropic:default","narrative":"This column contains geographic longitude values, stored as strings (hence the categorical classification), representing locations clustered tightly around -73.8 to -74.0 \u2014 consistent with New York City. Despite 1,000 rows, there are 770 unique values, yet the top value '-73.99830041620608' appears 31 times (3.1% of rows), which is surprisingly high given the near-continuous nature of coordinate data and flags a long-tail concentration. Entropy ratio of 0.97 confirms very high diversity overall, but the repeated exact coordinate values suggest either data binning, snapping to a fixed point, or duplicated records at specific locations.","role":"feature","scope":"column","target":"longitude","treatment":"Parse to float, verify duplicate coordinates for data quality issues, then use directly as a numeric geospatial feature or pair with latitude for distance/clustering models."},{"confidence":"high","critiques":[],"evidence_keys":["column","kind","n","n_unique","entropy_ratio","top_value","top_rate","alerts","null_rate"],"model":"anthropic:default","narrative":"This column contains X-coordinates in a State Plane coordinate system, stored as categorical strings rather than numerics \u2014 values like '984721' and '1004501' are typical State Plane Easting values in feet. With 763 unique values out of 1000 rows (entropy ratio 0.97) and a long-tail alert, the distribution is nearly unique per record, which is expected for spatial point coordinates. The top value '984721' appearing 31 times (3.1% of rows) is surprisingly frequent for a coordinate and may indicate a default, imputed, or snapped location worth investigating.","role":"feature","scope":"column","target":"x_coordinate_state_plane","treatment":"Cast to numeric, pair with Y-coordinate for spatial analysis, and investigate the 31 rows sharing coordinate '984721' for potential data quality issues."},{"confidence":"high","critiques":[],"evidence_keys":["column","kind","n","n_unique","entropy_ratio","top_value","top_rate","alerts"],"model":"anthropic:default","narrative":"This column represents Y-coordinates in a State Plane coordinate system, likely a geographic reference for spatial data (e.g., NYC or similar municipal dataset). Despite being numeric in nature, it is stored as a categorical type, which is unexpected and likely a data pipeline issue. With 768 unique values out of 1000 rows (entropy ratio 0.97) and a long-tail alert, the distribution is highly dispersed, though the top value '207809' appears 31 times \u2014 a modest but notable cluster suggesting a frequently referenced location. The near-unique cardinality makes this unsuitable for direct use as a categorical feature.","role":"feature","scope":"column","target":"y_coordinate_state_plane","treatment":"Cast to numeric, then use as a spatial coordinate feature or pair with x-coordinate for geospatial analysis."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","top_value","top_rate","entropy_ratio","alerts"],"model":"anthropic:default","narrative":"This column contains New York City Borough-Block-Lot (BBL) codes, a standard 10-digit property identifier encoding borough (leading digit 1\u20135), block, and lot numbers. With 719 unique values across 1,000 rows and an entropy ratio of 0.97, it is near-unique, but the top value '1006080026' appears 31 times (3.3% of non-null rows), indicating repeated records tied to a single property \u2014 flagged as a long tail. The 5.5% null rate and clustering of repeats suggest this may be a foreign key referencing a property registry rather than a row-level unique identifier.","role":"foreign_key","scope":"column","target":"bbl","treatment":"Left-join on this BBL to enrich with property-level attributes from a NYC PLUTO or similar property reference table."},{"confidence":"high","critiques":[],"evidence_keys":["column","n_unique","entropy_ratio","top_value","top_rate","alerts","null_rate","top_values"],"model":"anthropic:default","narrative":"This column contains the secondary cross-street name associated with a location record, likely from a NYC incident or address dataset. With 504 unique values across 1,000 rows and an entropy ratio of 0.948, the distribution is nearly flat \u2014 a strong long-tail signal where most street names appear very rarely. The top value '7 AVENUE' appears only 36 times (3.9% of non-null rows), and 'DEAD END' appearing 10 times is a notable data-quality flag indicating unresolved or terminus locations.","role":"feature","scope":"column","target":"cross_street_2","treatment":"Standardize street name abbreviations, flag 'DEAD END' as a sentinel value, and consider encoding via frequency bucketing or embedding rather than one-hot due to high cardinality."},{"confidence":"high","critiques":[],"evidence_keys":["n_unique","null_rate","entropy_ratio","top_value","top_rate","alerts","top_values"],"model":"anthropic:default","narrative":"This column captures the first cross street in a NYC street-address intersection, most likely from a traffic incident, 311, or similar geospatial events dataset. With 511 unique values across 1,000 rows and an entropy ratio of 0.953, the distribution is nearly flat \u2014 a strong long-tail signal \u2014 meaning the vast majority of street names appear only once or twice. The top value 'AVENUE OF THE AMERICAS' appears just 35 times (3.8% of rows), and the 8% null rate suggests some records lack cross-street data entirely.","role":"feature","scope":"column","target":"cross_street_1","treatment":"Normalize street name strings (abbreviations, casing), then use as a categorical geographic feature or join to a street reference table; high cardinality warrants frequency encoding or embedding rather than one-hot encoding."},{"confidence":"high","critiques":[],"evidence_keys":["column","n_unique","n","entropy_ratio","top_value","top_rate","null_rate","top_values","alerts"],"model":"anthropic:default","narrative":"This column captures the secondary (cross) street name at an intersection, likely from a New York City incident or traffic dataset. With 499 unique values across 1,000 rows and an entropy ratio of 0.948, the distribution is nearly flat \u2014 a strong long-tail pattern where '7 AVENUE' is the modal value at only 3.9% frequency. The presence of 'DEAD END' (10 occurrences) as a top value is notable, indicating it is used as a literal street descriptor rather than a true street name, which may require cleaning. An 8.4% null rate suggests some incidents occurred at non-intersection locations (e.g., mid-block).","role":"feature","scope":"column","target":"intersection_street_2","treatment":"Standardize 'DEAD END' and similar non-street tokens, impute or flag nulls, then encode as a categorical feature or use for geospatial joining."},{"confidence":"high","critiques":[],"evidence_keys":["n_unique","null_rate","entropy_ratio","top_value","top_rate","alerts","top_values"],"model":"anthropic:default","narrative":"This column captures the name of the first cross-street at an intersection, consistent with NYC street-incident or infrastructure data. With 506 unique values across 1,000 rows (entropy ratio 0.95), the distribution is nearly flat \u2014 a long-tail alert confirms that the vast majority of street names appear only once or twice, while even the top value ('AVENUE OF THE AMERICAS') accounts for just 3.8% of non-null records. An 8.5% null rate suggests intersections are not always fully recorded, which may indicate missing location data rather than true absence of a street.","role":"feature","scope":"column","target":"intersection_street_1","treatment":"Standardize street name strings (abbreviations, spacing), then encode as a high-cardinality categorical using target encoding or embedding before modelling; impute or flag nulls separately."},{"confidence":"high","critiques":[],"evidence_keys":["n_unique","null_rate","top_value","top_rate","entropy_ratio","alerts","cardinality"],"model":"anthropic:default","narrative":"This column contains street or landmark names, likely representing the nearest notable street or geographic reference point for each record in a New York City\u2013area dataset. With 515 unique values across 1,000 rows (51.5% uniqueness) and a 10.5% null rate, coverage is incomplete. The distribution is heavily long-tailed: the top value 'WEST 13 STREET' appears only 31 times (3.46%), and the entropy ratio of 0.955 indicates near-maximum disorder, meaning most landmark names are rare or unique \u2014 making this column unsuitable as a reliable grouping key without significant consolidation.","role":"label","scope":"column","target":"landmark","treatment":"Impute or flag nulls (10.5%), then either group by street type/prefix for coarser features or embed as a high-cardinality categorical; avoid one-hot encoding given 515 levels."},{"confidence":"low","critiques":[],"evidence_keys":["alerts","n","null_rate","n_unique","stats","kind"],"model":"anthropic:default","narrative":"This column is named 'location' and contains 1,000 non-null values with a null rate of 0.0, but the profiler skipped it entirely, yielding no stats, no uniqueness count, and no type inference. Without distribution, cardinality, or sample values, it is impossible to determine whether this is a structured geographic field (e.g., city, coordinates, country code) or free-text. The 'skipped' alert is the dominant signal and warrants direct inspection of raw values before any downstream use.","role":"other","scope":"column","target":"location","treatment":"Manually inspect raw values to determine structure (free-text, categorical, coordinate, etc.) before deciding on encoding or embedding strategy."},{"confidence":"high","critiques":[],"evidence_keys":["top_value","top_rate","cardinality","entropy_ratio","n","top_values","null_rate"],"model":"anthropic:default","narrative":"This column identifies the New York City municipal agency associated with each record, with 11 distinct agency codes and no nulls across 1,000 rows. The distribution is severely skewed: NYPD alone accounts for 88% of all records (880 of 1,000), while the remaining 10 agencies collectively cover only 120 rows \u2014 several (DHS, OOS, DCWP, DPR) appear just twice each. The low entropy ratio of 0.223 confirms this near-monolithic concentration, which could bias any agency-level analysis or model trained on this sample.","role":"label","scope":"column","target":"agency","treatment":"One-hot encode for modelling, but note severe class imbalance \u2014 consider oversampling or stratified splitting to ensure minority agencies are represented."},{"confidence":"high","critiques":[],"evidence_keys":["top_value","top_rate","cardinality","null_rate","entropy_ratio","top_values"],"model":"anthropic:default","narrative":"This column identifies the New York City municipal agency responsible for each record, with 11 distinct agencies across 1,000 rows and no nulls. It is severely dominated by the New York City Police Department, which accounts for 88% of all records (880 of 1,000), producing a very low entropy ratio of 0.223. The remaining 10 agencies collectively cover only 120 records, with several (e.g., Department of Homeless Services, Office of the Sheriff) appearing just twice. This extreme class imbalance will distort any agency-level aggregation or model that uses this column as a feature.","role":"label","scope":"column","target":"agency_name","treatment":"One-hot encode with caution given severe class imbalance; consider grouping rare agencies (\u22646 occurrences) into an 'Other' category before modelling."},{"confidence":"high","critiques":[],"evidence_keys":["n_unique","null_rate","top_values","entropy_ratio","top_rate"],"model":"anthropic:default","narrative":"This column represents the five New York City boroughs, functioning as a geographic label with complete coverage (null_rate 0.0) across all 1,000 rows. Four boroughs \u2014 Queens (274), Manhattan (258), Brooklyn (254), and Bronx (203) \u2014 are distributed with reasonable balance, but Staten Island is strikingly underrepresented at just 11 occurrences (~1.1%), compared to 20% expected under uniform distribution. The high entropy_ratio of 0.886 reflects the near-even spread among the four dominant boroughs, masking Staten Island's severe underrepresentation.","role":"label","scope":"column","target":"borough","treatment":"One-hot encode or target-encode for modelling; note Staten Island's class imbalance (n=11) may require stratified sampling or grouping."},{"confidence":"high","critiques":[],"evidence_keys":["n_unique","null_rate","top_rate","top_value","entropy_ratio","top_values"],"model":"anthropic:default","narrative":"This column represents NYC Community Board designations, combining a numeric district ID with a borough name (e.g., '02 MANHATTAN'). With 65 unique values across 1,000 rows and zero nulls, coverage is complete. The distribution is notably flat \u2014 entropy ratio of 0.93 indicates near-uniform spread, with the most frequent value ('02 MANHATTAN') appearing only 5.6% of the time, suggesting no single board dominates the dataset. Manhattan and Queens boards appear disproportionately among the top 10, which may reflect a geographic sampling bias worth investigating.","role":"label","scope":"column","target":"community_board","treatment":"One-hot encode or target-encode for modelling; consider grouping by borough prefix to reduce cardinality from 65 to 5."},{"confidence":"high","critiques":[],"evidence_keys":["top_value","top_rate","cardinality","n_unique","null_rate","entropy_ratio","top_values"],"model":"anthropic:default","narrative":"This column contains the categorized type of civic complaint (likely NYC 311 service requests), with 45 distinct complaint categories across 1,000 records and zero nulls. The distribution is heavily skewed: 'Noise - Residential' alone accounts for 39.3% of all records, and the top three noise-related categories together represent roughly 60% of the dataset. The entropy ratio of 0.53 indicates moderate concentration \u2014 far from uniform \u2014 with a long tail of rare complaint types below the top 10.","role":"label","scope":"column","target":"complaint_type","treatment":"One-hot encode or target-encode for modelling; consider grouping rare categories (below ~7 occurrences) into an 'Other' bucket to reduce noise."},{"confidence":"high","critiques":[],"evidence_keys":["top_value","top_rate","cardinality","entropy_ratio","null_rate","n","top_values"],"model":"anthropic:default","narrative":"This column contains descriptive sub-type labels for service requests or complaints \u2014 likely from a system such as NYC 311 \u2014 further specifying the nature of each complaint beyond a top-level category. 'Loud Music/Party' dominates with 42.7% of all 1,000 records, creating notable class imbalance; the top two values alone account for 54.1% of rows. With 71 unique values, entropy ratio of 0.576, and zero nulls, the column is moderately concentrated but still covers a meaningful range of complaint types including noise, parking, and building issues.","role":"label","scope":"column","target":"descriptor","treatment":"One-hot encode for modelling, but consider grouping rare categories (below ~1% frequency) into an 'Other' bucket to manage the 71-level cardinality."},{"confidence":"high","critiques":[],"evidence_keys":["top_values","top_rate","cardinality","null_rate","n"],"model":"anthropic:default","narrative":"This column captures the channel through which a report or request was submitted, with four distinct values: ONLINE, MOBILE, PHONE, and UNKNOWN. ONLINE dominates at 46.6% of records, followed by MOBILE (28.8%) and PHONE (23.6%), leaving only 10 records (1%) tagged as UNKNOWN. The near-uniform distribution across the three known channels is notable, and the UNKNOWN category \u2014 while small \u2014 may warrant imputation or flagging depending on downstream use.","role":"feature","scope":"column","target":"open_data_channel_type","treatment":"One-hot encode or ordinal-map the 3 known channels; consider grouping or flagging the 10 UNKNOWN values before modelling."},{"confidence":"high","critiques":[],"evidence_keys":["n_unique","null_rate","top_values","entropy_ratio","top_rate"],"model":"anthropic:default","narrative":"This column encodes the five NYC borough names associated with park locations, making it a low-cardinality geographic label with zero nulls across 1,000 rows. Four boroughs (Queens, Manhattan, Brooklyn, Bronx) are nearly evenly distributed (203\u2013274 records each), but Staten Island is severely underrepresented at just 11 occurrences (1.1%), which would surprise an analyst expecting proportional borough coverage. Entropy ratio of 0.886 reflects the near-uniform spread across four classes, masking the sharp imbalance on the fifth.","role":"label","scope":"column","target":"park_borough","treatment":"One-hot encode for modelling; note the severe class imbalance for STATEN ISLAND (11 of 1000) and consider stratified sampling or weighting."},{"confidence":"high","critiques":[],"evidence_keys":["n_unique","null_rate","top_rate","top_value","entropy_ratio","top_values"],"model":"anthropic:default","narrative":"This column represents the police precinct assignment for each record, with 76 distinct precinct labels across 1,000 rows and zero nulls. The distribution is remarkably flat: the most common value, 'Precinct 6', appears only 50 times (5% of rows), and entropy ratio is 0.936 \u2014 nearly as uniform as a perfectly even distribution across all 76 precincts. No dominant precinct stands out, suggesting either a geographically broad dataset or deliberate sampling across jurisdictions.","role":"label","scope":"column","target":"police_precinct","treatment":"One-hot encode or target-encode for modelling; high cardinality (76 levels) warrants regularised encoding rather than naive dummies."},{"confidence":"high","critiques":[],"evidence_keys":["n_unique","top_value","top_rate","null_rate","top_values","n"],"model":"anthropic:default","narrative":"This column is a workflow/lifecycle status field with exactly 3 states: Closed, In Progress, and Open. 'Closed' dominates at 61% (610/1000), while 'Open' is surprisingly rare at only 8.5% (85/1000), suggesting the dataset skews heavily toward resolved records \u2014 possibly a historical or archived snapshot rather than a live operational view. No nulls and perfect coverage across all 1000 rows.","role":"label","scope":"column","target":"status","treatment":"One-hot encode or ordinal-encode (Open\u2192In Progress\u2192Closed) depending on whether a natural progression is to be modelled; consider class imbalance if used as a target."},{"confidence":"high","critiques":[],"evidence_keys":["n_unique","entropy_ratio","top_value","top_rate","null_rate","top_values"],"model":"anthropic:default","narrative":"This column contains US ZIP codes associated with incidents, all values appearing to be New York City ZIP codes (10xxx and 11xxx series, consistent with Manhattan, Queens, and the Bronx). With 146 unique values across 1,000 rows and a high entropy ratio of 0.931, the distribution is remarkably spread \u2014 the most frequent ZIP '10011' appears only 42 times (4.2%), indicating incidents are distributed broadly across many neighbourhoods rather than concentrated in a few. Null rate is negligible at 0.3%.","role":"feature","scope":"column","target":"incident_zip","treatment":"Encode as geographic feature; consider grouping by borough or joining to a ZIP-code reference table for lat/lon or demographic enrichment."},{"confidence":"high","critiques":[],"evidence_keys":["column","n_unique","entropy_ratio","top_value","top_rate","null_rate","n"],"model":"anthropic:default","narrative":"This column is a Socrata-generated computed region identifier, typically encoding a geographic zone or district (e.g., census tract, neighbourhood, or administrative boundary) as an opaque integer-like label. With 51 unique values across 1,000 rows and an entropy ratio of 0.948, the distribution is near-uniform \u2014 no single region dominates heavily, though region '10' leads with 6.4% of records (64 occurrences). The null rate of 0.7% is negligible, suggesting reliable spatial assignment.","role":"foreign_key","scope":"column","target":":@computed_region_92fq_4b7q","treatment":"Left-join on this computed region ID to a Socrata boundary dataset to retrieve human-readable geographic names; do not treat the numeric strings as ordinal or cardinal values."},{"confidence":"high","critiques":[],"evidence_keys":["column","n_unique","entropy_ratio","top_rate","top_value","null_rate","n"],"model":"anthropic:default","narrative":"This column is a Socrata-generated computed region identifier, assigning each row to one of 62 geographic zones (e.g., neighborhood, district, or census tract polygons). With an entropy ratio of 0.939 and 62 unique integer-like codes across 1,000 rows, values are distributed fairly evenly \u2014 the most frequent region ('57') accounts for only 5.6% of rows, suggesting no strong spatial concentration. The null rate is negligible at 0.7%. The numeric-looking codes are categorical labels, not ordinal or continuous values.","role":"foreign_key","scope":"column","target":":@computed_region_f5dn_yrer","treatment":"Treat as a categorical geographic key; left-join to a region lookup table or one-hot encode for spatial feature engineering."},{"confidence":"high","critiques":[],"evidence_keys":["column","n_unique","entropy_ratio","top_rate","top_value","null_rate","n"],"model":"anthropic:default","narrative":"This column is a Socrata computed region identifier, automatically generated by the platform to assign rows to pre-defined geographic boundary zones (e.g., neighbourhoods, council districts, or census tracts). With 75 distinct integer-like codes across 1,000 rows and an entropy ratio of 0.94, the distribution is remarkably flat \u2014 no single zone dominates, with even the top value '3' appearing in only 5% of rows. The near-uniform spread across 75 regions and very low null rate (0.7%) suggest broad geographic coverage with no strong spatial concentration.","role":"foreign_key","scope":"column","target":":@computed_region_sbqj_enih","treatment":"Left-join on this region code to a geographic boundaries table to enrich with spatial attributes; do not treat as a numeric feature."},{"confidence":"high","critiques":[],"evidence_keys":["column","n_unique","top_values","null_rate","top_rate"],"model":"anthropic:default","narrative":"This column is a Socrata-generated computed region identifier (geo-zone lookup key), indicated by the ':@computed_region_' prefix \u2014 it maps each row to one of 5 predefined geographic regions. Values are nearly uniformly distributed across zones 2\u20134 (~254\u2013269 rows each), but zone '1' is a stark outlier with only 11 occurrences (~1.1% of rows), which may signal a very small or edge-case geographic area. Null rate is negligible at 0.7%.","role":"foreign_key","scope":"column","target":":@computed_region_yeji_bk3q","treatment":"Use as a categorical grouping key or left-join to a region lookup table; investigate zone '1' underrepresentation before using as a stratification variable."},{"confidence":"high","critiques":[],"evidence_keys":["n_unique","entropy_ratio","top_value","top_rate","null_rate","n"],"model":"anthropic:default","narrative":"This column represents a council district code \u2014 a zero-padded numeric string identifier (e.g., '03', '32') used to assign records to geographic administrative units. With 51 distinct values across 1,000 rows and an entropy ratio of 0.954, the distribution is remarkably flat and near-uniform, meaning no single district dominates heavily; the most frequent value '03' appears only 56 times (5.65% of rows). This near-maximum entropy is unusual for a district field and suggests either broad geographic coverage or deliberate sampling across all districts. Null rate is negligible at 0.9%.","role":"label","scope":"column","target":"council_district","treatment":"Use as a categorical grouping variable; one-hot or target-encode for modelling, or retain as-is for geographic aggregation and joins."},{"confidence":"high","critiques":[],"evidence_keys":["top_values","n_unique","cardinality","top_rate","top_value","null_rate"],"model":"anthropic:default","narrative":"This column encodes the type of location where an incident or event occurred, with 20 distinct values across 1,000 rows. The dominant category is 'Residential Building/House' at 40.2% (396 occurrences), followed by 'Street/Sidewalk' at 324. A significant data quality issue is immediately apparent: the same real-world concept appears under multiple inconsistent labels \u2014 'Residential Building/House' (396), 'RESIDENTIAL BUILDING' (74), and 'Residential Building' (7) are clearly duplicates, as are 'Street/Sidewalk' (324), 'Street' (8), and 'Sidewalk' (5) \u2014 meaning true cardinality is substantially lower than 20 and category frequencies are understated.","role":"label","scope":"column","target":"location_type","treatment":"Normalize case and consolidate synonymous labels (e.g. merge 'RESIDENTIAL BUILDING', 'Residential Building', 'Residential Building/House') before encoding as a categorical feature."},{"confidence":"high","critiques":[],"evidence_keys":["top_values","n_unique","null_rate","top_rate","top_value","entropy_ratio","n"],"model":"anthropic:default","narrative":"This column contains NYC neighborhood and borough city names, almost certainly a mailing-address city field from a dataset heavily concentrated in New York City. The top three values alone \u2014 BROOKLYN (250), NEW YORK (249), and BRONX (198) \u2014 account for roughly 70% of the 1,000 rows, while the remaining 33 values (e.g., WOODHAVEN, JAMAICA, RIDGEWOOD) are clearly Queens and Brooklyn sub-neighborhoods used as postal city names. The distribution is notably skewed (top_rate 0.255) but the entropy_ratio of 0.635 across 36 unique values suggests moderate spread beyond the top cluster; the 2.1% null rate is minor.","role":"feature","scope":"column","target":"city","treatment":"One-hot encode or target-encode for modelling; consider grouping sub-neighbourhood postal cities (e.g., WOODHAVEN, JAMAICA) into borough-level categories to reduce sparsity."}],"providers":["anthropic:default"],"total_usage":{"completion_tokens":10153,"prompt_tokens":39472,"total_tokens":49625}},"language_counts":{},"meta":{"generated_at":"2026-06-21T23:19:33+00:00","mode":"full","row_count":1000,"sampled_rows":1000,"seed":42,"source":"/home/coolhand/html/datavis/data_trove/cache/wild/nyc_311_sample.json"},"notes":[],"saturn_version":"0.2.0","schema":{":@computed_region_92fq_4b7q":"categorical",":@computed_region_f5dn_yrer":"categorical",":@computed_region_sbqj_enih":"categorical",":@computed_region_yeji_bk3q":"categorical","address_type":"categorical","agency":"categorical","agency_name":"categorical","bbl":"categorical","borough":"categorical","bridge_highway_direction":"categorical","bridge_highway_name":"categorical","bridge_highway_segment":"categorical","city":"categorical","closed_date":"categorical","community_board":"categorical","complaint_type":"categorical","council_district":"categorical","created_date":"categorical","cross_street_1":"categorical","cross_street_2":"categorical","descriptor":"categorical","descriptor_2":"categorical","facility_type":"categorical","incident_address":"categorical","incident_zip":"categorical","intersection_street_1":"categorical","intersection_street_2":"categorical","landmark":"categorical","latitude":"categorical","location":"unknown","location_type":"categorical","longitude":"categorical","open_data_channel_type":"categorical","park_borough":"categorical","park_facility_name":"categorical","police_precinct":"categorical","resolution_action_updated_date":"categorical","resolution_description":"categorical","road_ramp":"categorical","status":"categorical","street_name":"categorical","taxi_company_borough":"categorical","taxi_pick_up_location":"categorical","unique_key":"categorical","vehicle_type":"categorical","x_coordinate_state_plane":"categorical","y_coordinate_state_plane":"categorical"}}