{"columns":[{"alerts":[{"code":"high_skew","level":"info","message":"skew=-3.62"},{"code":"outliers","level":"warn","message":"12.4% rows beyond 1.5 IQR"}],"column":"median_gross_rent","extras":{"histogram":{"counts":[145,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,2182],"edges":[-666666666.0,-649999911.825,-633333157.65,-616666403.475,-599999649.3,-583332895.125,-566666140.95,-549999386.775,-533332632.6,-516665878.42499995,-499999124.25,-483332370.075,-466665615.9,-449998861.725,-433332107.54999995,-416665353.375,-399998599.2,-383331845.025,-366665090.84999996,-349998336.675,-333331582.5,-316664828.325,-299998074.15,-283331319.97499996,-266664565.79999995,-249997811.625,-233331057.45,-216664303.27499998,-199997549.09999996,-183330794.92499995,-166664040.75,-149997286.575,-133330532.39999998,-116663778.22500002,-99997024.04999995,-83330269.875,-66663515.69999993,-49996761.524999976,-33330007.350000024,-16663253.174999952,3501.0]},"sample":[-666666666.0,1148.0,806.0,627.0,1599.0,-666666666.0,1753.0,1826.0,1267.0,796.0,715.0,1722.0,1228.0,-666666666.0,1150.0,1111.0,1700.0,1089.0,1858.0,1674.0,1232.0,1403.0,1444.0,1338.0,1414.0,1610.0,1733.0,1504.0,1842.0,1466.0,1677.0,1574.0,1566.0,1828.0,1369.0,1350.0,1549.0,1310.0,1613.0,1713.0,1502.0,2102.0,1346.0,1709.0,1835.0,2268.0,2063.0,-666666666.0,1126.0,1555.0,1011.0,1632.0,1637.0,2038.0,1203.0,1850.0,907.0,1039.0,1201.0,1442.0,1637.0,1725.0,1453.0,1498.0,833.0,1244.0,1419.0,1587.0,1588.0,1593.0,1566.0,1648.0,1375.0,1561.0,1549.0,1616.0,1625.0,-666666666.0,1223.0,1467.0,1735.0,1629.0,-666666666.0,1794.0,2659.0,2242.0,3501.0,-666666666.0,709.0,1682.0,2805.0,3029.0,1750.0,2692.0,1785.0,2937.0,1733.0,-666666666.0,1559.0,1747.0,1482.0,2745.0,1682.0,1531.0,2287.0,1903.0,1804.0,-666666666.0,1563.0,1629.0,1939.0,2584.0,2894.0,2198.0,2698.0,2545.0,1515.0,1491.0,1679.0,2580.0,1425.0,1772.0,2039.0,2229.0,2344.0,1947.0,1967.0,1847.0,1720.0,1560.0,1845.0,2500.0,1725.0,1702.0,1651.0,896.0,1769.0,2155.0,705.0,1626.0,667.0,1527.0,1140.0,1738.0,2145.0,1489.0,1296.0,1423.0,-666666666.0,1405.0,1416.0,1418.0,1650.0,1348.0,1164.0,1600.0,1748.0,1652.0,2159.0,1580.0,1590.0,2033.0,1395.0,1363.0,2414.0,2651.0,1776.0,-666666666.0,2140.0,1570.0,1223.0,1454.0,2641.0,2598.0,2489.0,2871.0,1928.0,2170.0,1647.0,1705.0,1856.0,3501.0,1463.0,1339.0,496.0,1784.0,3310.0,2502.0,1470.0,1719.0,1440.0,2611.0,1722.0,1786.0,2530.0,1649.0,1514.0,1752.0,1761.0,2457.0,1640.0,-666666666.0,1395.0,2393.0,-666666666.0,3501.0,1893.0,-666666666.0,1663.0,1655.0,1548.0,1484.0,-666666666.0,1766.0,1595.0,1447.0,1304.0,1589.0,1794.0,1489.0,1965.0,1662.0,1806.0,1657.0,1705.0,1723.0,1401.0,1718.0,1625.0,1456.0,1610.0,1495.0,1849.0,1350.0,1717.0,1425.0,1898.0,1765.0,1881.0,1836.0,1820.0,834.0,1070.0,-666666666.0,2096.0,1522.0,1505.0,1715.0,1559.0,1227.0,1702.0,1661.0,1655.0,2126.0,1491.0,1307.0,1107.0,3367.0,1260.0,1968.0,3501.0,957.0,1174.0,2271.0,1703.0,2970.0,3090.0,1641.0,2810.0,2847.0,3076.0,3213.0,2321.0,3501.0,3280.0,-666666666.0,3413.0,2628.0,3136.0,3448.0,3501.0,2750.0,3154.0,1354.0,2410.0,2135.0,2459.0,2785.0,2357.0,1661.0,1992.0,2652.0,3024.0,3177.0,2410.0,1869.0,3249.0,1183.0,1011.0,2264.0,985.0,2650.0,841.0,1560.0,1314.0,2163.0,1913.0,823.0,1487.0,1596.0,708.0,2076.0,1624.0,1483.0,2065.0,1880.0,2067.0,1474.0,-666666666.0,1278.0,1324.0,1512.0,2100.0,1300.0,2261.0,1486.0,1372.0,1853.0,2543.0,1678.0,1881.0,1719.0,2066.0,1795.0,564.0,1867.0,1815.0,2116.0,2080.0,2132.0,2113.0,1918.0,-666666666.0,1946.0,2005.0,2051.0,1897.0,2237.0,2173.0,2074.0,2063.0,2596.0,1878.0,1598.0,2006.0,2148.0,1689.0,1872.0,-666666666.0,1625.0,1869.0,1790.0,1885.0,1993.0,1790.0,1741.0,2081.0,-666666666.0,1767.0,-666666666.0,1827.0,1657.0,1930.0,1939.0,1875.0,1679.0,2234.0,1485.0,2032.0,1847.0,1971.0,1178.0,1837.0,1851.0,1781.0,1735.0,1698.0,1797.0,1600.0,1684.0,1603.0,1880.0,1935.0,1719.0,1778.0,1894.0,1727.0,1577.0,1776.0,1765.0,1279.0,2049.0,-666666666.0,1506.0,1696.0,1433.0,2080.0,-666666666.0,1092.0,2016.0,1943.0,-666666666.0,-666666666.0,2141.0,-666666666.0,2293.0,1453.0,1977.0,-666666666.0,2108.0,2574.0,1688.0,2004.0,2000.0,1929.0,2073.0,1912.0,2185.0,1892.0,1744.0,1911.0,1739.0,1631.0,-666666666.0,1646.0,1573.0,1461.0,2125.0,1748.0,1103.0,1002.0,2415.0,2185.0,1348.0,2773.0,2433.0,1702.0,1306.0,961.0,1732.0,2154.0,1659.0,-666666666.0,3250.0,1878.0,1922.0,2227.0,1771.0,1822.0,2060.0,1991.0,2250.0,-666666666.0,2672.0,2139.0,2319.0,2933.0,-666666666.0,2641.0,2632.0,2552.0,2000.0,3329.0,1967.0,2383.0,2275.0,1377.0,1799.0,1526.0,1941.0,1985.0,-666666666.0,1671.0,1697.0,925.0,602.0,1934.0,1872.0,1927.0,2131.0,1196.0,521.0,2031.0,2122.0,1238.0,1446.0,1547.0,-666666666.0,2064.0,1643.0]},"kind":"numeric","n":2327,"n_null":0,"n_unique":1232,"null_rate":0.0,"stats":{"iqr":607.5,"kurtosis":11.11472865733957,"max":3501.0,"mean":-41539608.81908036,"median":1735.0,"min":-666666666.0,"n_outliers":289,"outlier_rate":0.12419424151267727,"q1":1441.5,"q3":2049.0,"skew":-3.6214263291052573,"std":161182638.66716465,"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":["median_gross_rent.stats.min","median_gross_rent.stats.mean","median_gross_rent.stats.median","median_gross_rent.stats.q1","median_gross_rent.stats.q3","median_gross_rent.alerts","county_name.top_values","county_name.stats.top_rate","county_name.stats.cardinality","state.stats.min","state.stats.max","row_count"],"featured_charts":[{"caption":"Distribution of census tracts across the five NYC boroughs, with Brooklyn leading.","column":"county_name","kind":"bar"},{"caption":"Rent distribution \u2014 expect to see extreme negative sentinel values that need filtering before the real $1,400\u2013$2,000 range becomes visible.","column":"median_gross_rent","kind":"histogram"},{"caption":"Share of tracts per borough; Brooklyn and Queens together account for over 65%.","column":"county_name","kind":"donut"},{"caption":"Tract ID distribution is highly skewed (skew \u2248 10) due to a few very large tract numbers.","column":"tract","kind":"histogram"},{"caption":"Tract name lengths cluster tightly between 38 and 46 characters, confirming a uniform naming format.","column":"NAME","kind":"length"}],"model":"anthropic:claude-opus-4-7","narrative":"This dataset contains 2,327 New York City census tracts with median gross rent values across the five boroughs. The most important issue to investigate is median_gross_rent: it has a minimum of -666,666,666 and a mean of about -41.5 million, indicating sentinel values for missing data that must be filtered before any analysis \u2014 once cleaned, the median rent of $1,735 and IQR of $1,441\u2013$2,049 are the realistic figures. The county_name field is well-distributed across five boroughs, with Brooklyn (Kings) the largest at 805 tracts (34.6%) and Staten Island the smallest at 126. Note that 'state' is constant (all 36, New York) and can be ignored, and 'NAME' is a unique tract label rather than an analytical field.","scope":"dataset","target":"__global__"},{"confidence":"high","critiques":[],"evidence_keys":["stats.min","stats.max","stats.mean","stats.median","stats.q1","stats.q3","stats.std","stats.skew","stats.kurtosis","stats.outlier_rate","stats.n_outliers","alerts"],"model":"anthropic:claude-opus-4-7","narrative":"Median gross rent per geography, with a typical value around $1,735 (IQR $1,441.5\u2013$2,049). The column is contaminated by sentinel values: the min of -666666666 drags the mean to -41539608.82 and inflates std to 1.6e8, producing skew of -3.62 and 12.4% flagged outliers. Once sentinels are removed, the real distribution looks tight and plausible for US rents capped near $3,501.","role":"feature","scope":"column","target":"median_gross_rent","treatment":"Replace -666666666 sentinel with null, then consider winsorizing or log-transforming 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 names of New York City census tracts, one per row (e.g. 'Census Tract ...; Kings County; New York'). Every one of the 2327 values is unique with zero nulls and tightly bounded length (38-46 chars, mean 41.6 words\u22487), and the top words confirm the five NYC boroughs: Kings (805), Queens (725), Bronx (361), Richmond (126), with Manhattan/New York making up the remainder. It is effectively a row identifier rather than a modelling feature.","role":"identifier","scope":"column","target":"NAME","treatment":"Drop from modelling; retain as a join key or parse out the borough/tract components if geography is needed."},{"confidence":"high","critiques":[],"evidence_keys":["alerts","n","n_unique","null_rate","stats.min","stats.max","stats.mean","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 zero nulls. This is a constant field carrying no information for modelling, likely a leftover state code from an upstream filter or partition.","role":"metadata","scope":"column","target":"state","treatment":"Drop; constant column provides no signal."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.min","stats.max","stats.mean","stats.median","stats.q1","stats.q3","stats.std","stats.skew"],"model":"anthropic:claude-opus-4-7","narrative":"This column holds numeric county codes (likely FIPS-style identifiers), with only 5 unique values across 2327 rows and no nulls. Despite being labelled numeric, the values 5, 47, 81, 85 etc. are categorical labels \u2014 the reported mean of 55.0 and std of 25.97 are not meaningful. The distribution is concentrated in the upper end (median 47, Q3 81), giving a negative skew of -0.72.","role":"identifier","scope":"column","target":"county","treatment":"Cast to categorical and one-hot or target-encode; do not treat as a continuous feature."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.min","stats.max","stats.median","stats.skew","stats.kurtosis","stats.n_outliers","stats.outlier_rate"],"model":"anthropic:claude-opus-4-7","narrative":"This is almost certainly a U.S. Census tract code rather than a true numeric measurement, with 1530 unique values across 2327 rows and no nulls. The distribution is severely right-skewed (skew 10.14, kurtosis 189.8) with a max of 990100 sitting far above the median of 30100, which is expected behavior for tract identifiers and triggered the high_skew alert. The 63 flagged outliers (2.7%) reflect tract-numbering conventions, not data errors.","role":"identifier","scope":"column","target":"tract","treatment":"Cast to string and treat as a categorical/geographic key; do not use as a continuous numeric feature."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.cardinality","stats.top_rate","stats.top_value","stats.entropy_ratio","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"This column records NYC borough/county names across 2327 rows with no nulls and only 5 distinct values, matching the five boroughs of New York City. Distribution is uneven but balanced enough to be informative: Brooklyn (Kings) leads at 805 (top_rate 0.346), followed by Queens (725), Bronx (361), Manhattan (310), and Staten Island (126), giving high entropy_ratio of 0.898. Notably, three of the five labels embed parenthetical legal county names (e.g., 'Brooklyn (Kings)'), which will need normalization if joining to standard county tables.","role":"feature","scope":"column","target":"county_name","treatment":"One-hot or target-encode after stripping the parenthetical county aliases for clean joins."}],"providers":["anthropic:claude-opus-4-7"],"total_usage":{"completion_tokens":2398,"prompt_tokens":6779,"total_tokens":9177}},"language_counts":{},"meta":{"generated_at":"2026-05-01T17:09:55+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_rent_by_tract.csv"},"notes":[],"saturn_version":"0.2.0","schema":{"NAME":"text","county":"numeric","county_name":"categorical","median_gross_rent":"numeric","state":"numeric","tract":"numeric"}}