{"columns":[{"alerts":[{"code":"high_skew","level":"info","message":"skew=-3.94"},{"code":"outliers","level":"warn","message":"8.9% rows beyond 1.5 IQR"}],"column":"median_household_income","extras":{"histogram":{"counts":[126,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2201],"edges":[-666666666.0,-649993749.325,-633320832.65,-616647915.975,-599974999.3,-583302082.625,-566629165.95,-549956249.275,-533283332.6,-516610415.92499995,-499937499.25,-483264582.575,-466591665.9,-449918749.225,-433245832.54999995,-416572915.875,-399899999.2,-383227082.525,-366554165.84999996,-349881249.175,-333208332.5,-316535415.825,-299862499.15,-283189582.47499996,-266516665.79999995,-249843749.125,-233170832.45,-216497915.77499998,-199824999.09999996,-183152082.42499995,-166479165.75,-149806249.075,-133133332.39999998,-116460415.72500002,-99787499.04999995,-83114582.375,-66441665.69999993,-49768749.024999976,-33095832.350000024,-16422915.674999952,250001.0]},"sample":[-666666666.0,29206.0,20640.0,22850.0,55396.0,-666666666.0,29844.0,57905.0,44792.0,34604.0,23987.0,56128.0,28592.0,-666666666.0,40575.0,17410.0,84042.0,37168.0,70357.0,47035.0,33950.0,33412.0,55648.0,39756.0,55804.0,52734.0,88534.0,27165.0,86549.0,39419.0,73152.0,53304.0,21551.0,72198.0,45425.0,43504.0,50993.0,44845.0,57241.0,61552.0,37361.0,101142.0,67917.0,70543.0,95435.0,121617.0,118529.0,-666666666.0,40239.0,37898.0,27674.0,69960.0,64727.0,73438.0,24823.0,66563.0,15000.0,21250.0,36398.0,35431.0,42174.0,63341.0,31107.0,62712.0,35493.0,51629.0,39524.0,40938.0,39023.0,33218.0,42037.0,42188.0,32672.0,72091.0,48162.0,38569.0,71849.0,88438.0,60536.0,40089.0,99960.0,82451.0,-666666666.0,129109.0,193158.0,169313.0,148542.0,-666666666.0,22943.0,103971.0,136307.0,214275.0,135474.0,160694.0,90074.0,218393.0,63352.0,-666666666.0,52775.0,71375.0,59145.0,114552.0,58643.0,55250.0,122344.0,87667.0,96411.0,-666666666.0,62637.0,66083.0,68304.0,123107.0,191083.0,95855.0,149643.0,175833.0,62519.0,48594.0,79022.0,65417.0,51875.0,56111.0,87981.0,121771.0,89573.0,95735.0,85466.0,65433.0,45918.0,58000.0,82784.0,100750.0,58407.0,55214.0,110938.0,42902.0,82726.0,88200.0,37183.0,68611.0,30194.0,81116.0,25083.0,55774.0,57750.0,42429.0,41250.0,45296.0,-666666666.0,67264.0,28952.0,38047.0,51768.0,64531.0,47279.0,48075.0,77302.0,49427.0,96870.0,54276.0,98482.0,63626.0,45625.0,62656.0,97250.0,95506.0,65500.0,-666666666.0,88456.0,53301.0,41156.0,51860.0,101875.0,101250.0,151250.0,139947.0,98729.0,35333.0,63672.0,66875.0,92098.0,205184.0,118343.0,30078.0,34091.0,83750.0,163269.0,120841.0,68994.0,79236.0,88661.0,155804.0,36984.0,71944.0,130372.0,77500.0,79148.0,80633.0,148693.0,87052.0,108227.0,117237.0,92394.0,115669.0,113676.0,142907.0,70662.0,-666666666.0,129028.0,91625.0,90917.0,90522.0,-666666666.0,71218.0,70250.0,106923.0,88958.0,86455.0,75335.0,58859.0,75370.0,77153.0,77214.0,102431.0,70954.0,71607.0,72632.0,70380.0,93803.0,91378.0,73450.0,58542.0,72863.0,52539.0,74219.0,60947.0,70826.0,97679.0,85234.0,89744.0,90000.0,23657.0,60919.0,-666666666.0,66985.0,80467.0,69932.0,41657.0,62241.0,62273.0,64167.0,80147.0,114153.0,57313.0,33190.0,57055.0,46615.0,119293.0,46860.0,74485.0,250001.0,35625.0,52305.0,90222.0,68382.0,246250.0,153838.0,100096.0,141731.0,202632.0,96912.0,139577.0,119250.0,250001.0,97242.0,91157.0,190685.0,169293.0,160111.0,198750.0,198000.0,82500.0,176667.0,54735.0,145488.0,100991.0,157969.0,80132.0,140883.0,115574.0,91045.0,244250.0,141363.0,146563.0,159712.0,104146.0,163500.0,31068.0,37990.0,171250.0,36696.0,146918.0,45221.0,70150.0,48161.0,69800.0,92132.0,22743.0,75954.0,59413.0,22207.0,89756.0,56705.0,53900.0,61570.0,58924.0,86769.0,45036.0,-666666666.0,42446.0,35647.0,64761.0,85952.0,65743.0,112969.0,67417.0,44498.0,72200.0,125114.0,78018.0,53417.0,86582.0,53468.0,82176.0,24125.0,79342.0,79865.0,111923.0,102375.0,89500.0,113891.0,94881.0,-666666666.0,99265.0,76118.0,112083.0,88224.0,97465.0,94300.0,106458.0,97500.0,115735.0,109042.0,64464.0,64635.0,76979.0,103800.0,94632.0,-666666666.0,79643.0,84643.0,81441.0,110417.0,85571.0,75114.0,70417.0,99630.0,-666666666.0,84375.0,-666666666.0,72000.0,96032.0,92426.0,51359.0,83816.0,54986.0,84835.0,70452.0,100044.0,79075.0,60398.0,51520.0,84242.0,54750.0,85455.0,97946.0,57784.0,88893.0,52653.0,44700.0,67267.0,56062.0,70451.0,67381.0,55068.0,65538.0,77014.0,80513.0,84233.0,108598.0,73333.0,118375.0,115000.0,127000.0,75917.0,70938.0,97250.0,149904.0,94583.0,90938.0,127420.0,-666666666.0,120764.0,99611.0,-666666666.0,92313.0,121667.0,110882.0,-666666666.0,117500.0,114764.0,60840.0,68566.0,116125.0,101168.0,108616.0,100199.0,117568.0,102581.0,98194.0,104840.0,98750.0,74474.0,-666666666.0,89107.0,57675.0,56388.0,157845.0,110875.0,54637.0,67038.0,70729.0,113826.0,33727.0,116607.0,109000.0,69621.0,46645.0,47271.0,118220.0,112790.0,61229.0,-666666666.0,137429.0,115313.0,87687.0,94643.0,60354.0,55257.0,95856.0,91787.0,112824.0,-666666666.0,132337.0,83828.0,105348.0,91421.0,128750.0,71303.0,116900.0,113214.0,94250.0,117828.0,109959.0,138698.0,119196.0,64452.0,63558.0,79333.0,33203.0,88155.0,59732.0,120893.0,90171.0,78031.0,83098.0,84137.0,123679.0,111077.0,129712.0,130272.0,41993.0,153750.0,94464.0,113220.0,59452.0,79938.0,-666666666.0,87837.0,100479.0]},"kind":"numeric","n":2327,"n_null":0,"n_unique":2106,"null_rate":0.0,"stats":{"iqr":49117.0,"kurtosis":13.525498352986538,"max":250001.0,"mean":-36017397.460249245,"median":76833.0,"min":-666666666.0,"n_outliers":208,"outlier_rate":0.0893854748603352,"q1":53242.5,"q3":102359.5,"skew":-3.9402407245008018,"std":150923371.87655655,"zero_rate":0.0}},{"alerts":[{"code":"near_unique","level":"info","message":"100.0% of rows are unique strings"}],"column":"NAME","extras":{"language_counts":{},"language_sample_size":2327,"length_histogram":{"counts":[7,0,0,0,0,104,0,0,0,0,785,0,0,0,0,447,0,0,0,0,200,0,0,0,0,378,0,0,0,0,190,0,0,0,0,82,0,0,0,134],"edges":[38.0,38.2,38.4,38.6,38.8,39.0,39.2,39.4,39.6,39.8,40.0,40.2,40.4,40.6,40.8,41.0,41.2,41.4,41.6,41.8,42.0,42.2,42.4,42.6,42.8,43.0,43.2,43.4,43.6,43.8,44.0,44.2,44.4,44.6,44.8,45.0,45.2,45.4,45.6,45.8,46.0]},"near_unique":true,"sample":["Census Tract 4; Bronx County; New York","Census Tract 399.01; Queens County; New York","Census Tract 779.08; Queens County; New York","Census Tract 613.02; Queens County; New York","Census Tract 780; Kings County; New York","Census Tract 156.02; Richmond County; New York","Census Tract 848; Kings County; New York","Census Tract 1008.04; Queens County; New York","Census Tract 618; Queens County; New York","Census Tract 145; Bronx County; New York","Census Tract 219; New York County; New York","Census Tract 70.01; New York County; New York","Census Tract 326; Kings County; New York","Census Tract 39; Bronx County; New York","Census Tract 359; Kings County; New York","Census Tract 90.01; Kings County; New York","Census Tract 293.02; Bronx County; New York","Census Tract 659; Queens County; New York","Census Tract 273.02; Richmond County; New York","Census Tract 682; Kings County; New York","Census Tract 397; Kings County; New York","Census Tract 165; Bronx County; New York","Census Tract 34; Kings County; New York","Census Tract 324; Bronx County; New York","Census Tract 186; Queens County; New York","Census Tract 439; Queens County; New York","Census Tract 119; New York County; New York","Census Tract 112; Kings County; New York","Census Tract 248; Bronx County; New York","Census Tract 147; Richmond County; New York","Census Tract 69; Queens County; New York","Census Tract 96; Queens County; New York","Census Tract 51; Bronx County; New York","Census Tract 638; Kings County; New York","Census Tract 542; Kings County; New York","Census Tract 852; Kings County; New York","Census Tract 1479; Queens County; New York","Census Tract 29.01; New York County; New York","Census Tract 908; Kings County; New York","Census Tract 72; New York County; New York","Census Tract 590; Queens County; New York","Census Tract 1291.04; Queens County; New York","Census Tract 342; Kings County; New York","Census Tract 1291.02; Queens County; New York","Census Tract 64; Richmond County; New York","Census Tract 170.12; Richmond County; New York","Census Tract 506; Kings County; New York","Census Tract 656; Kings County; New York","Census Tract 47; Kings County; New York","Census Tract 919; Queens County; New York"],"top_values":[],"top_words":[["new",2637],["york",2637],["census",2327],["tract",2327],["county;",2327],["kings",805],["queens",725],["bronx",361],["richmond",126],["39;",5],["75;",5],["77;",5],["138;",5],["247;",5],["251;",5],["279;",5],["33;",4],["37;",4],["38;",4],["40.01;",4],["43;",4],["54;",4],["64;",4],["67;",4],["71;",4]],"vocab_skipped":null,"word_histogram":{"counts":[2017,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,310],"edges":[7.0,7.033333333333333,7.066666666666666,7.1,7.133333333333334,7.166666666666667,7.2,7.233333333333333,7.266666666666667,7.3,7.333333333333333,7.366666666666666,7.4,7.433333333333334,7.466666666666667,7.5,7.533333333333333,7.566666666666666,7.6,7.633333333333333,7.666666666666667,7.7,7.733333333333333,7.766666666666667,7.8,7.833333333333333,7.866666666666667,7.9,7.933333333333334,7.966666666666667,8.0]}},"kind":"text","n":2327,"n_null":0,"n_unique":2327,"null_rate":0.0,"stats":{"allcaps_rate":0.0,"boilerplate_rate":0.0,"duplicate_rate":0.0,"emoji_rate":0.0,"len_max":46,"len_mean":41.64890416845724,"len_median":41.0,"len_min":38,"len_p95":46.0,"n_duplicates":0,"n_empty":0,"one_word_rate":0.0,"readability_flesch_mean":91.45078392857144,"url_rate":0.0,"vocab_size":1539,"word_mean":7.133218736570692,"word_median":7.0}},{"alerts":[{"code":"constant","level":"info","message":"only one distinct value"}],"column":"state","extras":{"histogram":{"counts":[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2327,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0],"edges":[35.5,35.525,35.55,35.575,35.6,35.625,35.65,35.675,35.7,35.725,35.75,35.775,35.8,35.825,35.85,35.875,35.9,35.925,35.95,35.975,36.0,36.025,36.05,36.075,36.1,36.125,36.15,36.175,36.2,36.225,36.25,36.275,36.3,36.325,36.35,36.375,36.4,36.425,36.45,36.475,36.5]},"sample":[36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0]},"kind":"numeric","n":2327,"n_null":0,"n_unique":1,"null_rate":0.0,"stats":{"iqr":0.0,"kurtosis":0.0,"max":36.0,"mean":36.0,"median":36.0,"min":36.0,"n_outliers":0,"outlier_rate":0.0,"q1":36.0,"q3":36.0,"skew":0.0,"std":0.0,"zero_rate":0.0}},{"alerts":[],"column":"county","extras":{"histogram":{"counts":[361,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,805,0,0,0,0,0,0,310,0,0,0,0,0,0,0,0,0,725,126],"edges":[5.0,7.0,9.0,11.0,13.0,15.0,17.0,19.0,21.0,23.0,25.0,27.0,29.0,31.0,33.0,35.0,37.0,39.0,41.0,43.0,45.0,47.0,49.0,51.0,53.0,55.0,57.0,59.0,61.0,63.0,65.0,67.0,69.0,71.0,73.0,75.0,77.0,79.0,81.0,83.0,85.0]},"sample":[5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,61.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,81.0,85.0,85.0,85.0,85.0,85.0,85.0,85.0,85.0,85.0,85.0,85.0,85.0,85.0,85.0,85.0,85.0,85.0,85.0,85.0,85.0,85.0,85.0,85.0,85.0]},"kind":"numeric","n":2327,"n_null":0,"n_unique":5,"null_rate":0.0,"stats":{"iqr":34.0,"kurtosis":-0.45308132091770315,"max":85.0,"mean":55.0,"median":47.0,"min":5.0,"n_outliers":0,"outlier_rate":0.0,"q1":47.0,"q3":81.0,"skew":-0.7200183402511814,"std":25.969424445276346,"zero_rate":0.0}},{"alerts":[{"code":"high_skew","level":"info","message":"skew=+10.14"}],"column":"tract","extras":{"histogram":{"counts":[982,617,329,197,145,37,17,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3],"edges":[100.0,24850.0,49600.0,74350.0,99100.0,123850.0,148600.0,173350.0,198100.0,222850.0,247600.0,272350.0,297100.0,321850.0,346600.0,371350.0,396100.0,420850.0,445600.0,470350.0,495100.0,519850.0,544600.0,569350.0,594100.0,618850.0,643600.0,668350.0,693100.0,717850.0,742600.0,767350.0,792100.0,816850.0,841600.0,866350.0,891100.0,915850.0,940600.0,965350.0,990100.0]},"sample":[2400.0,2702.0,3900.0,5100.0,6301.0,6302.0,6800.0,7000.0,7100.0,7900.0,8600.0,9800.0,11502.0,11702.0,12901.0,13100.0,13800.0,15500.0,15800.0,17901.0,18102.0,19500.0,20601.0,21501.0,21800.0,22200.0,22403.0,22702.0,22800.0,23501.0,23600.0,23702.0,23703.0,23800.0,24100.0,24501.0,24700.0,25100.0,25700.0,26100.0,26300.0,27402.0,28100.0,28500.0,29500.0,31000.0,31200.0,31900.0,32400.0,33201.0,33601.0,33802.0,34000.0,34400.0,35900.0,36800.0,36902.0,37100.0,37400.0,37900.0,38700.0,38800.0,39300.0,39400.0,39700.0,39800.0,39901.0,40302.0,40303.0,40304.0,40501.0,41500.0,42000.0,42200.0,42902.0,43102.0,43400.0,43503.0,43600.0,44200.0,44400.0,48401.0,50400.0,51601.0,301.0,502.0,1300.0,1801.0,2901.0,3400.0,3900.0,4100.0,4400.0,4900.0,6600.0,6700.0,7200.0,8600.0,9202.0,9402.0,10802.0,12100.0,12600.0,14000.0,14300.0,15200.0,16000.0,17500.0,18000.0,18200.0,18800.0,19900.0,20300.0,20400.0,20500.0,20700.0,21200.0,22200.0,22600.0,23500.0,25000.0,25100.0,25300.0,26700.0,26900.0,27300.0,27500.0,27900.0,28600.0,28800.0,29400.0,29500.0,29600.0,29800.0,30100.0,30700.0,31100.0,31500.0,32600.0,32700.0,34000.0,34100.0,34300.0,34500.0,34800.0,35101.0,35102.0,35701.0,35702.0,35900.0,36001.0,36002.0,36200.0,36501.0,36502.0,36600.0,37700.0,37900.0,39100.0,39200.0,40400.0,40900.0,41402.0,41900.0,42100.0,42300.0,44400.0,44902.0,45400.0,48200.0,49100.0,49302.0,49500.0,49900.0,50300.0,50401.0,50804.0,50900.0,51601.0,51602.0,51800.0,51900.0,52000.0,52500.0,54500.0,54800.0,54900.0,55100.0,55800.0,56600.0,56800.0,56900.0,58000.0,58400.0,59100.0,59402.0,59403.0,59800.0,61200.0,62000.0,62800.0,63600.0,64600.0,64800.0,65600.0,66000.0,66200.0,66600.0,67400.0,68000.0,69602.0,70000.0,70602.0,72800.0,73200.0,74600.0,74800.0,77400.0,77600.0,79002.0,79202.0,79400.0,79801.0,80000.0,80600.0,81000.0,81400.0,82800.0,83200.0,83600.0,86000.0,86200.0,86600.0,86800.0,87200.0,87800.0,95800.0,96800.0,97400.0,99400.0,102200.0,105801.0,107001.0,107003.0,109800.0,111800.0,112600.0,114201.0,114202.0,117201.0,117202.0,118600.0,120200.0,120801.0,120802.0,122000.0,1402.0,1501.0,1600.0,1800.0,2100.0,2601.0,2800.0,3001.0,3002.0,3700.0,4002.0,4100.0,4900.0,6000.0,6200.0,7200.0,7500.0,9901.0,10100.0,10200.0,10602.0,10801.0,10803.0,11201.0,11202.0,11300.0,11402.0,12102.0,12700.0,12902.0,13201.0,13202.0,13400.0,13501.0,13900.0,14801.0,15301.0,15502.0,15801.0,16002.0,16900.0,17200.0,17401.0,17500.0,18200.0,18300.0,18600.0,20000.0,20600.0,20701.0,20800.0,20901.0,21100.0,21303.0,21900.0,22000.0,22200.0,22301.0,22700.0,22900.0,23300.0,23900.0,24000.0,24700.0,25100.0,25500.0,25700.0,26900.0,28100.0,28300.0,30900.0,200.0,702.0,2200.0,3302.0,3600.0,3900.0,4001.0,4300.0,5200.0,5400.0,6100.0,6501.0,8300.0,8800.0,9100.0,9900.0,10200.0,10300.0,10600.0,10800.0,11100.0,11300.0,11500.0,12100.0,12301.0,14000.0,14400.0,14900.0,15300.0,15802.0,16400.0,17101.0,17200.0,18000.0,18101.0,18800.0,19400.0,20600.0,20800.0,21601.0,21900.0,22001.0,22900.0,23502.0,25100.0,25500.0,26501.0,27200.0,27500.0,28802.0,29300.0,29400.0,30906.0,32700.0,33403.0,35700.0,36700.0,36800.0,38400.0,39902.0,40502.0,44601.0,44602.0,46000.0,46200.0,46300.0,46901.0,47100.0,47300.0,48400.0,50000.0,50201.0,50400.0,50800.0,51100.0,51200.0,53401.0,55500.0,56600.0,59200.0,59400.0,60000.0,60300.0,61200.0,62400.0,63200.0,63700.0,64102.0,64500.0,65000.0,65703.0,66404.0,66701.0,67100.0,67900.0,68700.0,69500.0,69701.0,70700.0,71304.0,73700.0,77902.0,77903.0,77904.0,78800.0,79200.0,79300.0,84601.0,84902.0,85900.0,89201.0,93401.0,94202.0,94203.0,94500.0,97300.0,99200.0,99701.0,99703.0,99801.0,99802.0,100803.0,100804.0,101700.0,103201.0,107202.0,109300.0,113300.0,113900.0,115100.0,115900.0,116700.0,121500.0,122300.0,124700.0,128300.0,129102.0,134702.0,136700.0,138501.0,139900.0,141700.0,143500.0,144100.0,152901.0,152902.0,155103.0,155104.0,157102.0,700.0,1700.0,2002.0,2700.0,3600.0,4001.0,4700.0,5901.0,8100.0,11401.0,12804.0,12805.0,13302.0,14605.0,14608.0,17300.0,17701.0,18703.0,19700.0,20701.0,21300.0,22602.0,23100.0,27704.0]},"kind":"numeric","n":2327,"n_null":0,"n_unique":1530,"null_rate":0.0,"stats":{"iqr":42700.5,"kurtosis":189.8244540472232,"max":990100.0,"mean":42251.91233347658,"median":30100.0,"min":100.0,"n_outliers":63,"outlier_rate":0.027073485174043833,"q1":15200.0,"q3":57900.5,"skew":10.142969354101233,"std":48265.21868531455,"zero_rate":0.0}},{"alerts":[],"column":"county_name","extras":{"singletons":0,"top_values":[["Brooklyn (Kings)",805],["Queens",725],["Bronx",361],["Manhattan (New York)",310],["Staten Island (Richmond)",126]]},"kind":"categorical","n":2327,"n_null":0,"n_unique":5,"null_rate":0.0,"stats":{"cardinality":5,"entropy":2.086227277518357,"entropy_ratio":0.8984891832404314,"top_rate":0.34593897722389344,"top_value":"Brooklyn (Kings)"}}],"insights":{"errors":[],"insights":[{"confidence":"high","critiques":[],"evidence_keys":["row_count","column_count","median_household_income.stats.min","median_household_income.stats.mean","median_household_income.stats.median","median_household_income.stats.skew","median_household_income.alerts","county_name.top_values","county_name.stats.top_rate","state.alerts","tract.stats.skew"],"featured_charts":[{"caption":"Look for an extreme negative tail caused by sentinel codes (e.g. -666666666) that distort the mean \u2014 filter these before interpreting the distribution.","column":"median_household_income","kind":"histogram"},{"caption":"Shows tract counts per borough; Brooklyn dominates while Staten Island has the fewest, which matters when aggregating income by area.","column":"county_name","kind":"bar"},{"caption":"Share of census tracts across the five NYC boroughs at a glance.","column":"county_name","kind":"donut"},{"caption":"Tract numbers are highly skewed (skew \u2248 10) \u2014 useful as IDs but confirm they aren't being treated as a quantitative measure.","column":"tract","kind":"histogram"}],"model":"anthropic:claude-opus-4-7","narrative":"This dataset contains 2,327 New York City census tracts with median household income, geographic identifiers (state, county, tract), and tract names. The headline issue is median_household_income: it has a minimum of -666,666,666 and a mean of about -36 million, indicating sentinel/missing-value codes that must be filtered before any analysis \u2014 the median of $76,833 is the more trustworthy central value. County coverage is uneven, with Brooklyn (Kings) holding 34.6% of tracts and Staten Island only 126, so per-borough comparisons should be normalized. The state column is constant (36 = New York) and can be dropped.","scope":"dataset","target":"__global__"},{"confidence":"high","critiques":[],"evidence_keys":["min","max","mean","median","std","q1","q3","iqr","skew","kurtosis","n_outliers","outlier_rate","null_rate"],"model":"anthropic:claude-opus-4-7","narrative":"Likely U.S. median household income in dollars, with median 76833 and IQR spanning 53242.5 to 102359.5. The minimum of -666666666 is a sentinel null code that is poisoning the mean (-36017397.46) and standard deviation (150923371.88), and 208 rows (8.94%) flag as outliers. Skew of -3.94 and kurtosis of 13.53 are entirely artifacts of that sentinel.","role":"feature","scope":"column","target":"median_household_income","treatment":"Replace -666666666 with NaN, then optionally cap at the 250001 top-code before modelling."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.len_min","stats.len_max","stats.len_mean","stats.word_mean","top_words","alerts"],"model":"anthropic:claude-opus-4-7","narrative":"This column holds fully-qualified Census tract names for New York City, with every one of the 2327 rows unique and non-null. Lengths cluster tightly between 38 and 46 characters and every record contains the words 'new', 'york', 'census', 'tract', and 'county;', confirming a rigid template; the borough token (Kings 805, Queens 725, Bronx 361, Richmond 126) is the only meaningful variation. It is effectively a row identifier, not a feature.","role":"identifier","scope":"column","target":"NAME","treatment":"Drop from modelling; optionally parse the borough token out as a categorical feature."},{"confidence":"high","critiques":[],"evidence_keys":["alerts","n","n_unique","null_rate","stats.min","stats.max","stats.std"],"model":"anthropic:claude-opus-4-7","narrative":"The column 'state' is numeric but holds the single value 36 across all 2327 rows, with zero variance and no nulls. It carries no information for modelling and likely encodes a fixed jurisdiction or processing-state code captured during a single-state extract.","role":"metadata","scope":"column","target":"state","treatment":"Drop; constant column with no predictive signal."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.min","stats.q1","stats.median","stats.q3","stats.max","stats.mean","stats.std","stats.skew"],"model":"anthropic:claude-opus-4-7","narrative":"Despite being typed as numeric, `county` has only 5 unique values across 2327 rows (5, ?, 47, 81, 85 implied by the quartiles) with no nulls \u2014 these are almost certainly FIPS-style county codes rather than a measured quantity. The distribution is left-skewed (skew -0.72) with the median at 47 and Q1 also at 47, meaning at least a quarter of rows share that single code. Treating mean (55.0) or std (25.97) as meaningful would be misleading given the categorical nature.","role":"feature","scope":"column","target":"county","treatment":"Cast to categorical and one-hot encode before modelling."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.min","stats.max","stats.median","stats.q1","stats.q3","stats.skew","stats.kurtosis","stats.n_outliers","stats.outlier_rate"],"model":"anthropic:claude-opus-4-7","narrative":"Almost certainly U.S. Census tract codes stored as integers, with 1530 distinct values across 2327 rows and no nulls. The distribution is severely right-skewed (skew 10.14, kurtosis 189.82) with a max of 990100 sitting far above the q3 of 57900.5 and median of 30100, producing 63 outliers (2.7%); this is an artifact of tract numbering conventions, not a true numeric magnitude.","role":"identifier","scope":"column","target":"tract","treatment":"Treat as a categorical geographic key (zero-pad and join with state/county FIPS); do not use as a numeric 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 column lists the NYC borough/county for each record, with all 5 expected values present across 2327 rows and no nulls. Distribution roughly tracks borough population: Brooklyn (Kings) leads at 805 (top_rate 0.346), followed by Queens (725), Bronx (361), Manhattan (310), and Staten Island (126). Entropy ratio of 0.898 indicates the categories are fairly evenly spread rather than dominated by one value.","role":"feature","scope":"column","target":"county_name","treatment":"one-hot encode as a low-cardinality categorical feature."}],"providers":["anthropic:claude-opus-4-7"],"total_usage":{"completion_tokens":2298,"prompt_tokens":6774,"total_tokens":9072}},"language_counts":{},"meta":{"generated_at":"2026-05-01T17:10:42+00:00","mode":"full","row_count":2327,"sampled_rows":2327,"seed":42,"source":"/home/coolhand/html/datavis/data_trove/data/urban/nyc_housing/nyc_median_income_by_tract.csv"},"notes":[],"saturn_version":"0.2.0","schema":{"NAME":"text","county":"numeric","county_name":"categorical","median_household_income":"numeric","state":"numeric","tract":"numeric"}}