{"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","descriptor","agency","borough","status","open_data_channel_type","city","location_type","address_type","road_ramp","taxi_company_borough","facility_type"],"featured_charts":[{"caption":"Noise and parking complaints dominate; check how steeply the long tail drops after the top three categories.","column":"complaint_type","kind":"bar"},{"caption":"NYPD handles 88% of tickets \u2014 see how thin the slice is for every other agency.","column":"agency","kind":"donut"},{"caption":"Queens, Manhattan, Brooklyn and Bronx are roughly balanced while Staten Island is barely represented.","column":"borough","kind":"bar"},{"caption":"Closed vs. In Progress vs. Open \u2014 useful for gauging the open backlog in this snapshot.","column":"status","kind":"donut"},{"caption":"Compare intake channels to see how reporting has shifted toward online and mobile over phone.","column":"open_data_channel_type","kind":"bar"}],"model":"anthropic:claude-opus-4-7","narrative":"This is a 1,000-row sample of NYC 311 service requests with 47 columns covering complaint metadata, location, agency routing, and resolution status. The bulk of activity is noise and parking complaints routed to NYPD (88% of all tickets), with 'Noise - Residential' alone accounting for 393 of 1,000 rows and 'Loud Music/Party' the dominant descriptor at 427. Geographically the load is spread across Queens, Manhattan, Brooklyn and the Bronx fairly evenly, while Staten Island barely registers (11 rows). Worth a closer look: the resolution funnel \u2014 61% of tickets are Closed but 30.5% are still In Progress \u2014 and the channel mix, where ONLINE (466) now outpaces MOBILE and PHONE combined-ish. Note that many specialty fields (road_ramp, taxi_*, bridge_highway_*, facility_type) are >99% null and should be ignored for analysis.","scope":"dataset","target":"__global__"},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.cardinality","stats.entropy_ratio","stats.top_rate","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"This column is a unique row identifier: all 1000 values are distinct (n_unique=1000, entropy_ratio=1.0) with no nulls and a top_rate of just 0.001. Sample values like '67519092' are 8-digit numeric strings, consistent with a primary key from a source system. There is no predictive signal here; the long_tail alert simply reflects perfect uniqueness.","role":"identifier","scope":"column","target":"unique_key","treatment":"Drop from modelling; retain only as a join key or row reference."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.entropy_ratio","stats.top_rate","stats.top_value","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"This is a record creation timestamp stored as an ISO-8601 string, with 939 unique values across 1000 rows and no nulls. Entropy ratio of 0.995 confirms it is essentially a per-row timestamp; the most frequent value appears only 9 times (0.9%). All visible top values fall within a narrow window on 2026-01-17 to 2026-01-18, suggesting the sample covers only a short ingestion period rather than a broad history.","role":"timestamp","scope":"column","target":"created_date","treatment":"Parse to datetime and derive features (hour, day, delta) rather than using as a categorical."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.top_value","stats.top_rate","stats.entropy_ratio","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"This is the responding NYC agency code for each record, with 11 distinct values and no nulls. The distribution is severely concentrated: NYPD accounts for 880 of 1000 rows (top_rate 0.88), followed by HPD at 74, leaving the remaining 9 agencies with at most 13 rows each. Entropy ratio of 0.22 confirms the column carries little information beyond 'NYPD vs. not'.","role":"feature","scope":"column","target":"agency","treatment":"Collapse rare agencies into an 'Other' bucket before encoding."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.top_value","stats.top_rate","stats.entropy_ratio","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"This column names the NYC agency handling each record, with 11 distinct agencies and no nulls. The distribution is heavily concentrated: the New York City Police Department accounts for 880 of 1000 rows (88%), and entropy ratio is just 0.22, meaning the field carries little information beyond 'NYPD or not'. Secondary agencies like Housing Preservation and Development (74) and Health and Mental Hygiene (13) trail far behind.","role":"feature","scope":"column","target":"agency_name","treatment":"Collapse rare agencies into an 'Other' bucket or binarize as NYPD vs non-NYPD before modelling."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.top_value","stats.top_rate","stats.entropy_ratio","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"This is a categorical complaint-type label, almost certainly from a 311-style service request feed, with 45 distinct categories across 1000 rows and no nulls. The distribution is heavily concentrated: \"Noise - Residential\" alone accounts for 39.3% of records, and the top three values (all noise or parking complaints) cover roughly 74% of the column. Casing is inconsistent across categories (e.g., \"HEAT/HOT WATER\" and \"UNSANITARY CONDITION\" in upper case versus title-cased noise variants), which suggests the source merges multiple agency taxonomies.","role":"label","scope":"column","target":"complaint_type","treatment":"Normalise casing and group the long tail before one-hot or target encoding."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.cardinality","stats.entropy","stats.entropy_ratio","stats.top_rate","stats.top_value","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"Categorical descriptor field enumerating specific complaint subtypes (e.g., 'Loud Music/Party', 'Blocked Hydrant', 'Posted Parking Sign Violation'), likely a secondary classification under a parent complaint type. Distribution is heavily skewed: 'Loud Music/Party' alone covers 42.7% of 1000 rows, and the top 3 values account for the majority, leaving 71 distinct categories with a long thin tail. Note the inconsistent casing ('ENTIRE BUILDING', 'APARTMENT ONLY' vs. title-case entries), suggesting upstream data-entry from multiple systems.","role":"feature","scope":"column","target":"descriptor","treatment":"Normalize casing, then group rare levels into 'Other' before one-hot or target encoding."},{"confidence":"high","critiques":[],"evidence_keys":["n_unique","null_rate","stats.top_value","stats.top_rate","stats.entropy_ratio","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"Categorical location descriptor with 20 distinct values and only 1.4% nulls; 'Residential Building/House' dominates at 40.2% followed by 'Street/Sidewalk' at 32.4%. The vocabulary is inconsistent: 'RESIDENTIAL BUILDING' (74), 'Residential Building' (7), and 'Residential Building/House' (396) are clearly the same concept stored three ways, and 'Street' (8) overlaps with 'Street/Sidewalk' (324). Entropy ratio of 0.52 confirms heavy concentration in the top two buckets.","role":"feature","scope":"column","target":"location_type","treatment":"Normalize casing and merge synonym variants (e.g., collapse the three 'Residential Building' forms) before encoding."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.cardinality","stats.entropy_ratio","stats.top_rate","stats.top_value","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"Holds NYC ZIP codes tied to incidents, with 146 distinct values across 1000 rows and only 0.3% missing. Distribution is diffuse \u2014 entropy ratio 0.93 and the top ZIP '10011' captures just 4.2% \u2014 so no single neighborhood dominates. The top 10 ZIPs span Manhattan, Brooklyn, Queens, and the Bronx, indicating broad five-borough coverage.","role":"feature","scope":"column","target":"incident_zip","treatment":"Treat as categorical; group by borough or target-encode before modelling rather than one-hot across 146 levels."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.entropy_ratio","stats.top_value","stats.top_rate","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"Street addresses for incident locations, with 776 unique values across 1000 rows and only 0.5% nulls. Entropy ratio of 0.97 confirms a long tail \u2014 most addresses appear once \u2014 but a few hotspots stand out, notably '126 WEST 13 STREET' with 31 occurrences (3.1% of rows), far above the next most frequent. Note inconsistent whitespace formatting (e.g., '60 EAST   93 STREET') suggesting unnormalized input.","role":"metadata","scope":"column","target":"incident_address","treatment":"Normalize whitespace/casing and geocode rather than using raw strings as a feature."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.cardinality","stats.entropy_ratio","stats.top_rate","stats.top_value","top_values","alerts"],"model":"anthropic:claude-opus-4-7","narrative":"Street name field, almost certainly a NYC address component given entries like WEST 13 STREET, JAMAICA AVENUE, and BRUCKNER BOULEVARD. Extremely high-cardinality (569 unique across 1000 rows, entropy ratio 0.955) with a long tail and no dominant value \u2014 the top entry only covers 3.1% of rows. Watch for inconsistent whitespace (e.g. \"EAST   93 STREET\" has multiple spaces) which will fragment otherwise-equal values.","role":"metadata","scope":"column","target":"street_name","treatment":"Normalise whitespace and casing, then either group by borough/zip or drop for modelling \u2014 too high-cardinality to one-hot."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.cardinality","stats.entropy_ratio","stats.top_rate","stats.top_value","top_values","alerts"],"model":"anthropic:claude-opus-4-7","narrative":"This column captures the name of one cross street, almost certainly part of a NYC location reference (entries like 'AVENUE OF THE AMERICAS', 'BLEECKER STREET', and 'BROADWAY' are giveaways). Cardinality is extreme: 511 unique values across 1000 rows with entropy ratio 0.95, and the most common street accounts for only 3.8% of rows. 8% of values are null, and the long tail alert means most streets appear only once or twice.","role":"metadata","scope":"column","target":"cross_street_1","treatment":"Standardize casing and group rare streets into an 'OTHER' bucket before any encoding; do not one-hot raw."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.cardinality","stats.entropy_ratio","stats.top_rate","stats.top_value","top_values","alerts"],"model":"anthropic:claude-opus-4-7","narrative":"Free-form NYC street names serving as the second cross street in a location pair, with 504 distinct values across 921 non-null rows and a 7.9% null rate. Distribution is long-tailed and high-entropy (entropy ratio 0.948); the most common value '7 AVENUE' covers only 3.9%, and 'DEAD END' appearing 10 times suggests non-street sentinel values mixed in.","role":"feature","scope":"column","target":"cross_street_2","treatment":"Treat as high-cardinality categorical: hash or target-encode rather than one-hot, and normalise sentinels like 'DEAD END' before modelling."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.cardinality","stats.entropy_ratio","stats.top_rate","stats.top_value","top_values","alerts"],"model":"anthropic:claude-opus-4-7","narrative":"Street-name field, almost certainly the first cross street of an NYC intersection given values like AVENUE OF THE AMERICAS, BROADWAY, and AMSTERDAM AVENUE. Cardinality is extreme: 506 distinct names across 1000 rows with entropy ratio 0.95, and the most frequent value covers only 3.8% of records. Null rate is 8.5%, and the long tail means most names appear only once or twice.","role":"metadata","scope":"column","target":"intersection_street_1","treatment":"Group rare streets into an 'OTHER' bucket or geocode to borough/zone before using as a feature."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.cardinality","stats.entropy_ratio","stats.top_rate","stats.top_value","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"This is the second street name of an intersection, almost certainly NYC street geography given entries like '7 AVENUE', 'BROADWAY', and 'EAST 171 STREET'. Cardinality is extreme (499 unique values across 1000 rows, entropy ratio 0.95) with no dominant value \u2014 the top entry '7 AVENUE' covers only 3.9% and 8.4% of rows are null. Notably, 'DEAD END' appears 10 times as a sentinel rather than a real street, which will distort any join on street name.","role":"feature","scope":"column","target":"intersection_street_2","treatment":"Treat as high-cardinality location text: normalize sentinels like 'DEAD END' and target-encode or geocode rather than one-hot."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.top_value","stats.top_rate","stats.entropy_ratio","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"Categorical descriptor of how a location is specified, with four values: ADDRESS, INTERSECTION, BLOCKFACE, and PLACE. The distribution is severely imbalanced \u2014 ADDRESS accounts for 97.2% of 1000 rows, leaving only 28 non-ADDRESS records and an entropy ratio of 0.108. Null rate is negligible at 0.2%.","role":"feature","scope":"column","target":"address_type","treatment":"Collapse to a binary ADDRESS-vs-other flag or drop, since the minority levels carry little signal."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.cardinality","stats.entropy_ratio","stats.top_rate","stats.top_value","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"This is a NYC-centric city field with 36 distinct uppercase values and a 2.1% null rate. The distribution is dominated by Brooklyn (25.5%), New York, and Bronx, which together account for roughly 70% of the 1000 rows; entropy ratio of 0.63 reflects this concentration on a few boroughs while the long tail covers Queens neighborhoods like Woodhaven, Jamaica, and Astoria. Note the values mix borough names with neighborhood names rather than a consistent geographic level.","role":"feature","scope":"column","target":"city","treatment":"Group rare neighborhoods into an 'other' bucket and one-hot or target-encode the top categories."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.cardinality","stats.entropy_ratio","stats.top_rate","stats.top_value","top_values","alerts"],"model":"anthropic:claude-opus-4-7","narrative":"This column holds NYC street names used as landmark references, with 515 unique values across 895 non-null rows and a 10.5% null rate. The distribution is extremely flat (entropy ratio 0.955) \u2014 the most common value, 'WEST 13 STREET', accounts for only 3.5% of records, and a long tail alert is raised. No single landmark dominates, so this behaves more like a high-cardinality location descriptor than a categorical feature.","role":"metadata","scope":"column","target":"landmark","treatment":"Treat as high-cardinality text; group rare values or geocode rather than one-hot encode."},{"confidence":"high","critiques":[],"evidence_keys":["n_unique","null_rate","top_value","top_rate","top_values","entropy_ratio"],"model":"anthropic:claude-opus-4-7","narrative":"This is a ticket/case lifecycle status field with three states: Closed, In Progress, and Open. The distribution is heavily weighted toward Closed (610 of 1000, 61%), with Open being notably rare at just 85 records, suggesting most cases reach resolution. No nulls and clean cardinality of 3 make this a tidy categorical signal.","role":"feature","scope":"column","target":"status","treatment":"One-hot or ordinal encode (Open < In Progress < Closed) before modelling."},{"confidence":"high","critiques":[],"evidence_keys":["cardinality","entropy_ratio","top_rate","top_value","top_values","null_rate","n_unique"],"model":"anthropic:claude-opus-4-7","narrative":"This column encodes NYC community board identifiers as a numeric prefix plus borough name (e.g., '02 MANHATTAN'), with 65 distinct values across 1000 rows and no nulls. The distribution is fairly flat \u2014 entropy ratio is 0.93 and the top value accounts for only 5.6% \u2014 suggesting wide geographic coverage rather than concentration in one district. Manhattan and Queens boards dominate the top of the leaderboard, with '02 MANHATTAN' (56) and '09 QUEENS' (48) leading.","role":"metadata","scope":"column","target":"community_board","treatment":"Split into borough and board-number components, then one-hot or target-encode for modelling."},{"confidence":"high","critiques":[],"evidence_keys":["n_unique","null_rate","stats.entropy_ratio","stats.top_rate","stats.top_value","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"Categorical codes representing council districts, stored as zero-padded two-digit strings across 51 distinct values with a 0.9% null rate. The distribution is nearly uniform (entropy ratio 0.954), with the top district '03' accounting for only 5.65% of rows, suggesting broad geographic coverage rather than concentration. No single district dominates, which is consistent with a city/region-wide sample.","role":"feature","scope":"column","target":"council_district","treatment":"One-hot or target-encode for modelling; impute the small null share with an explicit 'unknown' category."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.cardinality","stats.entropy_ratio","stats.top_rate","stats.top_value","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"This is a categorical column tagging each record with one of 76 NYPD-style police precincts, with no nulls across 1000 rows. The distribution is remarkably flat \u2014 entropy ratio 0.9358 and the modal value 'Precinct 6' covering just 5% \u2014 meaning no precinct dominates and counts decay slowly from 50 down to the mid-20s among the top 10.","role":"feature","scope":"column","target":"police_precinct","treatment":"Treat as a high-cardinality categorical: target- or frequency-encode rather than one-hot before modelling."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.cardinality","stats.entropy_ratio","stats.top_rate","stats.top_value","top_values","alerts"],"model":"anthropic:claude-opus-4-7","narrative":"This is the NYC BBL (Borough-Block-Lot) parcel identifier, stored as a 10-digit string where the leading digit encodes the borough (1-5). Cardinality is very high (719 unique across 945 non-null rows, entropy ratio 0.968), but a long tail is flagged: one parcel '1006080026' accounts for 31 rows (3.3%) and several others recur 5-13 times, so rows are not one-per-parcel. Null rate is 5.5%.","role":"foreign_key","scope":"column","target":"bbl","treatment":"Treat as a parcel key for left-joining to PLUTO/property tables; do not one-hot encode."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.cardinality","stats.entropy_ratio","stats.top_rate","stats.top_value","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"This column lists one of the five NYC boroughs for each of the 1000 rows, with no nulls and only 5 unique values. The distribution is fairly even across QUEENS (274), MANHATTAN (258), BROOKLYN (254), and BRONX (203), but STATEN ISLAND is sharply underrepresented at just 11 rows. High entropy ratio (0.886) confirms the top four categories are well balanced.","role":"feature","scope":"column","target":"borough","treatment":"One-hot encode; consider grouping or monitoring STATEN ISLAND given its low support."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.cardinality","stats.entropy_ratio","stats.top_value","stats.top_rate","top_values","alerts"],"model":"anthropic:claude-opus-4-7","narrative":"This column holds X-coordinates in a state plane projection, stored as strings rather than numbers. With 763 unique values across 993 non-null rows and entropy ratio 0.97, it is near-unique; the most frequent value '984721' appears only 31 times (3.1%). The long_tail alert is consistent with a near-continuous spatial measurement that has been categorically encoded.","role":"feature","scope":"column","target":"x_coordinate_state_plane","treatment":"Cast to numeric and pair with the Y-coordinate as a 2D spatial feature."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.entropy_ratio","stats.top_rate","stats.top_value","top_values","alerts"],"model":"anthropic:claude-opus-4-7","narrative":"Column holds State Plane y-coordinates (northings) stored as strings rather than numerics, with 768 unique values across 1000 rows and a 0.7% null rate. Entropy ratio of 0.97 and a top_rate of just 3.1% confirm a near-uniform long tail typical of geographic coordinates, though the modal value '207809' repeating 31 times suggests a default or geocoder fallback location worth investigating.","role":"feature","scope":"column","target":"y_coordinate_state_plane","treatment":"Cast to numeric and treat as a continuous spatial coordinate; inspect the repeated 207809 value for geocoding artifacts."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.cardinality","stats.entropy_ratio","stats.top_rate","stats.top_value","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"Categorical channel indicating how a record was opened, with 4 distinct values and no nulls across 1000 rows. ONLINE leads at 466, followed by MOBILE (288) and PHONE (236), while UNKNOWN appears only 10 times. Distribution is fairly balanced (entropy ratio 0.79) with no dominant single class beyond 46.6%.","role":"feature","scope":"column","target":"open_data_channel_type","treatment":"one-hot encode; consider folding UNKNOWN into a missing/other bucket."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.top_rate","stats.top_value","stats.entropy_ratio","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"This column nominally records a park facility name but is effectively a constant: 999 of 1000 rows are \"Unspecified\" and only one row names \"Flushing Meadows Corona Park\". Entropy ratio is 0.011, confirming there is virtually no information content here. The column adds no discriminative signal as-is.","role":"metadata","scope":"column","target":"park_facility_name","treatment":"Drop; single dominant value carries no signal."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.cardinality","stats.entropy_ratio","stats.top_rate","stats.top_value","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"Categorical column listing the NYC borough associated with a park, with all five boroughs present and no nulls across 1000 rows. Distribution is fairly balanced (entropy ratio 0.8858) among Queens (274), Manhattan (258), Brooklyn (254), and Bronx (203), but Staten Island is severely under-represented at just 11 records.","role":"feature","scope":"column","target":"park_borough","treatment":"One-hot encode; consider grouping or stratifying given the Staten Island sparsity."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.entropy_ratio","stats.top_rate","stats.top_value","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"Latitude values stored as strings, with 770 unique points across 1000 rows clustered around 40.6-40.8 (NYC range). Entropy ratio of 0.97 and top_rate of just 0.031 confirm a long tail of near-unique coordinates, though the modal value 40.73706433046593 repeating 31 times suggests some snapped or default-pinned locations. Null rate is low at 0.7%.","role":"feature","scope":"column","target":"latitude","treatment":"cast to float and pair with longitude for geospatial features rather than treating as categorical."},{"confidence":"high","critiques":[],"evidence_keys":["column","kind","n","n_unique","null_rate","stats.entropy_ratio","stats.top_rate","stats.top_value","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"Geographic longitude coordinates, almost certainly NYC-area given the -73.8 to -74.0 range. The column was profiled as categorical despite being continuous numeric: 770 unique values across 1000 rows with entropy ratio 0.97 and a top value repeating only 31 times (3.1%). Null rate is low at 0.7%.","role":"feature","scope":"column","target":"longitude","treatment":"Cast to float and pair with latitude as a geospatial feature rather than treating as categorical."},{"confidence":"low","critiques":[],"evidence_keys":["alerts","column","kind","n","null_rate"],"model":"anthropic:claude-opus-4-7","narrative":"The column is named \"location\" but saturn skipped profiling, so no type, cardinality, or value statistics are available. The only confirmed facts are 1000 rows with a 0.0 null rate; uniqueness and content remain unknown.","role":"other","scope":"column","target":"location","treatment":"Re-profile or manually inspect before use; saturn skipped this column."},{"confidence":"high","critiques":[],"evidence_keys":["column","n_unique","null_rate","stats.entropy_ratio","stats.top_rate","stats.top_value","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"This is a Socrata-style computed region column (`:@computed_region_f5dn_yrer`), almost certainly a numeric region/zone code attached automatically by a spatial join. It has 62 unique values across 1000 rows with a near-uniform spread (entropy ratio 0.94, top value '57' at only 5.6%) and a 0.7% null rate. No single region dominates, suggesting the underlying records are well-distributed across the joined geography.","role":"metadata","scope":"column","target":":@computed_region_f5dn_yrer","treatment":"Treat as a categorical region code; one-hot or target-encode if used as a feature, otherwise drop as join artifact."},{"confidence":"high","critiques":[],"evidence_keys":["column","n_unique","null_rate","stats.cardinality","stats.entropy_ratio","stats.top_rate","stats.top_value","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"This is a Socrata-style computed region column (`:@computed_region_yeji_bk3q`), almost certainly a spatial-join lookup mapping each row to one of 5 region codes. The distribution is fairly balanced across codes 2-5 (193-269 each) but code 1 appears only 11 times, and 0.7% of rows are null. Entropy ratio 0.88 confirms near-uniform spread except for the sparse '1' bucket.","role":"metadata","scope":"column","target":":@computed_region_yeji_bk3q","treatment":"Treat as a categorical region key; one-hot encode or drop if the spatial join isn't relevant."},{"confidence":"high","critiques":[],"evidence_keys":["column","kind","n_unique","null_rate","stats.cardinality","stats.entropy_ratio","stats.top_rate","stats.top_value","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"This is a Socrata-style computed region column (`:@computed_region_sbqj_enih`), holding a small integer code that geocodes each row into one of 75 regions. The distribution is nearly uniform across categories \u2014 entropy ratio is 0.94 and the top value '3' covers only 5.0% of rows \u2014 so no single region dominates. Nulls are negligible at 0.7%.","role":"foreign_key","scope":"column","target":":@computed_region_sbqj_enih","treatment":"Treat as a categorical region id; left-join to the corresponding Socrata boundary lookup or one-hot encode for modelling."},{"confidence":"high","critiques":[],"evidence_keys":["column","n_unique","null_rate","stats.entropy_ratio","stats.top_rate","stats.top_value","stats.cardinality","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"This is a Socrata-style computed region column (`:@computed_region_92fq_4b7q`) holding 51 distinct integer codes, almost certainly a spatial join key (e.g., a precinct, district, or zone id) appended by the platform. Distribution is fairly flat \u2014 entropy ratio 0.9477 and the top value '10' covers only 6.4% of rows \u2014 with very few nulls (0.7%). No single region dominates, suggesting broad geographic coverage rather than a hot spot.","role":"foreign_key","scope":"column","target":":@computed_region_92fq_4b7q","treatment":"Treat as a categorical region id; left-join to the region lookup or one-hot encode if used as a feature."},{"confidence":"high","critiques":[],"evidence_keys":["null_rate","n_unique","stats.top_value","stats.top_rate","stats.entropy_ratio","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"Secondary complaint descriptor that further qualifies a primary complaint type, with values like 'NO HEAT', 'NO HEAT AND NO HOT WATER', and 'ROACHES'. It is null 88.2% of the time, so only 118 rows carry a value, and among those 'NO HEAT' alone covers 27.97%. Cardinality is 43 with entropy ratio 0.807, indicating a long tail across the populated rows and a mix of casing conventions ('ROACHES' vs 'Cannabis Smoking or Vaping') that suggests inconsistent upstream sources.","role":"feature","scope":"column","target":"descriptor_2","treatment":"Normalize casing and treat missing as its own category before one-hot or target encoding."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.cardinality","stats.entropy_ratio","stats.top_rate","stats.top_value","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"This is the canned 311 resolution narrative attached to each complaint, describing the agency's disposition (NYPD found no violation, summons issued, HPD inspection pending, etc.). Cardinality is just 16 templates over 1000 rows, with the top NYPD 'no criminal violation' boilerplate covering 35.4% and 30.7% of rows null \u2014 likely complaints still open. Entropy ratio of 0.69 shows the distribution is skewed toward a few NYPD templates, with DOT and HPD templates appearing only in the long tail.","role":"label","scope":"column","target":"resolution_description","treatment":"Map the 16 templates to a categorical disposition code (e.g., 'no_violation', 'summons_issued', 'no_entry', 'pending') rather than treating as free text."},{"confidence":"high","critiques":[],"evidence_keys":["null_rate","n_unique","stats.top_value","stats.top_rate","stats.entropy_ratio","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"ISO-8601 timestamps recording when a resolution action was last updated, stored as strings rather than a native datetime. 30.6% of rows are null, and a single midnight value '2026-01-17T00:00:00.000' accounts for 74 of the non-null entries (top_rate 10.66%) while the remaining values are millisecond-precise and nearly all unique (585 distinct over 694 non-null, entropy_ratio 0.94). The mix of one date-only spike with otherwise sub-second timestamps suggests two ingestion paths or a backfill default colliding with live event logging.","role":"timestamp","scope":"column","target":"resolution_action_updated_date","treatment":"Parse to datetime, treat the 2026-01-17 midnight spike as a sentinel/backfill, and derive recency or duration features rather than using raw values."},{"confidence":"high","critiques":[],"evidence_keys":["null_rate","n_unique","stats.cardinality","stats.entropy_ratio","stats.top_rate","stats.top_value","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"This is a closure timestamp captured at second-level precision, stored as strings rather than parsed datetimes. 39% of rows are null, consistent with records that have not yet been closed, and among the 610 populated rows there are 585 unique values with the most common appearing only 3 times (top_rate 0.0049, entropy_ratio 0.998). All visible top values cluster on 2026-01-18, suggesting the populated closures concentrate in a narrow window.","role":"timestamp","scope":"column","target":"closed_date","treatment":"Parse to datetime, treat nulls as 'still open', and derive duration features rather than using raw values."},{"confidence":"high","critiques":[],"evidence_keys":["null_rate","n","n_unique","stats.cardinality","stats.entropy_ratio","stats.top_rate","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"Free-text taxi pickup addresses (street, borough, state, ZIP) for NYC trips. The column is almost entirely empty at a 99.4% null rate, leaving only 6 non-null rows that are all unique, so cardinality equals the populated count and entropy is maximal (entropy_ratio 1.0). With so little signal, this column carries effectively no analytical value as-is.","role":"free_text","scope":"column","target":"taxi_pick_up_location","treatment":"Drop the column or geocode the rare populated addresses if pickup location is needed."},{"confidence":"high","critiques":[],"evidence_keys":["null_rate","n","n_unique","stats.top_value","stats.top_rate","stats.entropy_ratio","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"Categorical vehicle classification with just 4 levels (Car, Other, SUV, Van), but it is almost entirely missing \u2014 96.5% null, leaving only 35 populated rows out of 1000. Among those present, Car dominates at 77.1%, giving an entropy ratio of 0.55. With so few observations, the distribution is unreliable as a feature.","role":"feature","scope":"column","target":"vehicle_type","treatment":"Drop or treat missingness as its own category; too sparse to model directly."},{"confidence":"high","critiques":[],"evidence_keys":["null_rate","stats.cardinality","stats.entropy","stats.top_value","stats.top_rate","top_values","n"],"model":"anthropic:claude-opus-4-7","narrative":"This column is a categorical facility_type field that is effectively empty: 99% of the 1000 rows are null, and the only 10 non-null values are all the placeholder 'N/A'. With cardinality of 1 and entropy of 0, it carries no information.","role":"metadata","scope":"column","target":"facility_type","treatment":"Drop the column; it is 99% null with a single placeholder value."},{"confidence":"high","critiques":[],"evidence_keys":["null_rate","stats.cardinality","stats.entropy","stats.top_value","stats.top_rate","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"Categorical column intended to record the borough of a taxi company, but it is effectively empty: 99.9% of rows are null and the single non-null value is 'BROOKLYN'. With cardinality 1 and entropy 0, the column carries no information as-is.","role":"metadata","scope":"column","target":"taxi_company_borough","treatment":"Drop; near-entirely null with only one observed level."},{"confidence":"high","critiques":[],"evidence_keys":["null_rate","n_unique","top_values","stats.top_value","stats.top_rate","n"],"model":"anthropic:claude-opus-4-7","narrative":"A categorical field flagging bridge or highway names, but it's effectively empty: 99.7% null with only 3 non-null records across 1000 rows. The two distinct values observed ('E' and 'Kosciuszko Br - BQE') are inconsistent in form, suggesting either a free-text field or an abbreviation code mixed with full names.","role":"metadata","scope":"column","target":"bridge_highway_name","treatment":"Drop; null rate of 99.7% leaves no usable signal."},{"confidence":"high","critiques":[],"evidence_keys":["null_rate","n_unique","top_values","stats.top_value","stats.top_rate","n"],"model":"anthropic:claude-opus-4-7","narrative":"This is a near-empty categorical field describing bridge or highway direction, with a 99.7% null rate leaving only 3 non-null observations across 2 distinct values ('C E Local Downtown & Brooklyn' and 'Queens Bound'). The values resemble transit route/direction labels rather than simple compass directions, suggesting inconsistent coding. With only 3 populated rows out of 1000, no reliable distribution can be inferred.","role":"metadata","scope":"column","target":"bridge_highway_direction","treatment":"Drop; null rate of 0.997 leaves too little signal to use."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.cardinality","stats.entropy","stats.top_value","stats.top_rate","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"This column is a binary-style flag indicating whether a road segment is a ramp, but it carries virtually no information here. With a null_rate of 0.999 and only 1 non-null value (\"Ramp\") across 1000 rows, cardinality is 1 and entropy is 0.","role":"metadata","scope":"column","target":"road_ramp","treatment":"Drop; effectively constant with 99.9% nulls."},{"confidence":"high","critiques":[],"evidence_keys":["null_rate","n","n_unique","top_values","stats.top_value","stats.top_rate","stats.cardinality"],"model":"anthropic:claude-opus-4-7","narrative":"A categorical flag describing a bridge/highway segment type, with only two observed values ('Platform' and 'Ramp'). It is almost entirely missing \u2014 99.7% null, leaving just 3 non-null rows out of 1000 \u2014 so the apparent top_rate of 0.667 reflects 2 observations and is not meaningful.","role":"metadata","scope":"column","target":"bridge_highway_segment","treatment":"Drop or treat as a rare-event indicator; too sparse (3/1000 populated) to model directly."}],"providers":["anthropic:claude-opus-4-7"],"total_usage":{"completion_tokens":13164,"prompt_tokens":56091,"total_tokens":69255}},"language_counts":{},"meta":{"generated_at":"2026-05-01T18:06:31+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"}}