{"columns":[{"alerts":[],"column":"","extras":{"histogram":{"counts":[79,78,79,78,79,78,79,78,79,78,79,78,79,78,79,78,79,78,79,78,79,78,79,78,79,78,79,78,79,78,79,78,79,78,79,78,79,78,79,79],"edges":[0.0,78.5,157.0,235.5,314.0,392.5,471.0,549.5,628.0,706.5,785.0,863.5,942.0,1020.5,1099.0,1177.5,1256.0,1334.5,1413.0,1491.5,1570.0,1648.5,1727.0,1805.5,1884.0,1962.5,2041.0,2119.5,2198.0,2276.5,2355.0,2433.5,2512.0,2590.5,2669.0,2747.5,2826.0,2904.5,2983.0,3061.5,3140.0]},"sample":[16.0,20.0,29.0,42.0,54.0,55.0,56.0,63.0,66.0,76.0,77.0,85.0,96.0,102.0,111.0,118.0,120.0,134.0,136.0,162.0,170.0,182.0,189.0,204.0,206.0,219.0,226.0,227.0,235.0,241.0,243.0,246.0,248.0,249.0,251.0,253.0,259.0,265.0,272.0,273.0,275.0,285.0,298.0,299.0,316.0,319.0,320.0,328.0,335.0,340.0,348.0,351.0,352.0,353.0,365.0,371.0,372.0,373.0,380.0,383.0,385.0,402.0,403.0,404.0,407.0,413.0,416.0,418.0,419.0,429.0,435.0,437.0,438.0,441.0,443.0,454.0,459.0,464.0,469.0,470.0,471.0,486.0,492.0,495.0,507.0,508.0,514.0,515.0,518.0,524.0,531.0,533.0,540.0,543.0,544.0,548.0,564.0,579.0,596.0,597.0,604.0,607.0,612.0,616.0,652.0,655.0,671.0,675.0,677.0,683.0,701.0,720.0,727.0,728.0,741.0,744.0,751.0,756.0,762.0,764.0,769.0,777.0,782.0,783.0,785.0,789.0,792.0,806.0,820.0,831.0,836.0,844.0,852.0,853.0,858.0,867.0,871.0,877.0,882.0,885.0,888.0,890.0,894.0,897.0,898.0,901.0,907.0,908.0,921.0,927.0,931.0,939.0,943.0,944.0,949.0,950.0,951.0,954.0,962.0,966.0,968.0,972.0,973.0,975.0,980.0,987.0,991.0,1003.0,1009.0,1010.0,1025.0,1040.0,1045.0,1059.0,1069.0,1073.0,1077.0,1102.0,1111.0,1114.0,1126.0,1137.0,1139.0,1145.0,1147.0,1160.0,1172.0,1174.0,1184.0,1189.0,1190.0,1198.0,1201.0,1203.0,1214.0,1219.0,1224.0,1236.0,1243.0,1256.0,1257.0,1261.0,1264.0,1272.0,1278.0,1282.0,1289.0,1290.0,1292.0,1294.0,1296.0,1299.0,1301.0,1302.0,1303.0,1304.0,1321.0,1330.0,1331.0,1334.0,1337.0,1342.0,1345.0,1363.0,1364.0,1369.0,1387.0,1393.0,1396.0,1400.0,1404.0,1406.0,1407.0,1412.0,1413.0,1414.0,1417.0,1422.0,1429.0,1435.0,1447.0,1455.0,1456.0,1474.0,1483.0,1507.0,1520.0,1525.0,1529.0,1530.0,1535.0,1537.0,1544.0,1549.0,1551.0,1559.0,1560.0,1564.0,1567.0,1568.0,1569.0,1588.0,1591.0,1595.0,1599.0,1600.0,1609.0,1625.0,1633.0,1648.0,1660.0,1661.0,1674.0,1683.0,1689.0,1693.0,1704.0,1716.0,1717.0,1719.0,1720.0,1730.0,1744.0,1746.0,1758.0,1781.0,1782.0,1785.0,1807.0,1808.0,1814.0,1819.0,1821.0,1822.0,1823.0,1827.0,1844.0,1846.0,1847.0,1848.0,1851.0,1853.0,1855.0,1862.0,1864.0,1869.0,1874.0,1880.0,1890.0,1893.0,1897.0,1905.0,1908.0,1909.0,1913.0,1936.0,1939.0,1949.0,1952.0,1962.0,1963.0,1964.0,1965.0,1967.0,1976.0,1985.0,1990.0,1993.0,2007.0,2013.0,2016.0,2020.0,2033.0,2045.0,2046.0,2068.0,2069.0,2070.0,2071.0,2083.0,2088.0,2094.0,2096.0,2104.0,2118.0,2126.0,2144.0,2149.0,2151.0,2157.0,2160.0,2161.0,2171.0,2176.0,2180.0,2185.0,2187.0,2188.0,2195.0,2197.0,2199.0,2206.0,2208.0,2217.0,2220.0,2223.0,2233.0,2243.0,2246.0,2251.0,2254.0,2264.0,2269.0,2270.0,2272.0,2274.0,2275.0,2283.0,2284.0,2292.0,2297.0,2298.0,2301.0,2302.0,2319.0,2324.0,2347.0,2361.0,2365.0,2367.0,2375.0,2378.0,2389.0,2394.0,2401.0,2406.0,2431.0,2446.0,2452.0,2457.0,2461.0,2467.0,2468.0,2469.0,2490.0,2492.0,2496.0,2503.0,2517.0,2538.0,2539.0,2559.0,2563.0,2582.0,2583.0,2588.0,2590.0,2606.0,2608.0,2617.0,2639.0,2640.0,2647.0,2651.0,2656.0,2673.0,2674.0,2675.0,2684.0,2687.0,2691.0,2702.0,2703.0,2715.0,2718.0,2721.0,2730.0,2732.0,2733.0,2745.0,2761.0,2765.0,2772.0,2778.0,2780.0,2791.0,2794.0,2795.0,2797.0,2798.0,2800.0,2814.0,2817.0,2831.0,2840.0,2845.0,2849.0,2852.0,2855.0,2860.0,2865.0,2868.0,2876.0,2892.0,2902.0,2904.0,2909.0,2910.0,2918.0,2922.0,2923.0,2928.0,2940.0,2951.0,2959.0,2962.0,2964.0,2969.0,2974.0,2995.0,2997.0,2999.0,3002.0,3009.0,3019.0,3025.0,3036.0,3039.0,3042.0,3052.0,3053.0,3061.0,3065.0,3073.0,3079.0,3085.0,3103.0,3104.0,3105.0,3120.0]},"kind":"numeric","n":3141,"n_null":0,"n_unique":3141,"null_rate":0.0,"stats":{"iqr":1570.0,"kurtosis":-1.200000243262638,"max":3140.0,"mean":1570.0,"median":1570.0,"min":0.0,"n_outliers":0,"outlier_rate":0.0,"q1":785.0,"q3":2355.0,"skew":0.0,"std":906.8729238432472,"zero_rate":0.0003183699458771092}},{"alerts":[{"code":"high_skew","level":"info","message":"skew=+11.65"},{"code":"outliers","level":"warn","message":"14.9% rows beyond 1.5 IQR"}],"column":"votes_dem","extras":{"histogram":{"counts":[2844,145,52,28,19,11,15,6,2,3,5,5,1,2,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,1],"edges":[4.0,47348.15,94692.3,142036.45,189380.6,236724.75,284068.9,331413.05,378757.2,426101.35000000003,473445.5,520789.65,568133.8,615477.9500000001,662822.1,710166.25,757510.4,804854.55,852198.7000000001,899542.85,946887.0,994231.15,1041575.3,1088919.45,1136263.6,1183607.75,1230951.9000000001,1278296.05,1325640.2,1372984.35,1420328.5,1467672.6500000001,1515016.8,1562360.95,1609705.1,1657049.25,1704393.4000000001,1751737.55,1799081.7,1846425.85,1893770.0]},"sample":[93003.0,93003.0,5908.0,1234.0,8436.0,4698.0,10350.0,10547.0,1035.0,4913.0,68429.0,9577.0,1939.0,636.0,10474.0,14525.0,1067.0,1735.0,1397.0,1472.0,1472.0,35737.0,38676.0,1893770.0,86650.0,273768.0,219580.0,100120.0,73939.0,170489.0,7234.0,148365.0,278.0,581.0,19530.0,127.0,4048.0,105807.0,1631.0,171.0,91.0,874.0,7487.0,1345.0,260223.0,39329.0,75370.0,22765.0,57114.0,1271.0,852.0,3537.0,515.0,62597.0,23711.0,233327.0,117182.0,9920.0,3955.0,108793.0,6861.0,8812.0,4730.0,2566.0,1023.0,1612.0,697.0,685.0,159416.0,4104.0,2165.0,4851.0,2507.0,1920.0,9127.0,2483.0,2583.0,4469.0,1136.0,3960.0,2267.0,622.0,39602.0,1829.0,48707.0,23206.0,1220.0,5520.0,1678.0,2338.0,3471.0,8279.0,1672.0,1844.0,1893.0,16456.0,1946.0,3051.0,792.0,3070.0,2529.0,1643.0,5469.0,1244.0,255.0,6416.0,1229.0,2117.0,8093.0,4828.0,1617.0,4711.0,419.0,1151.0,168186.0,5499.0,1784.0,35918.0,1476.0,37436.0,817.0,528.0,20568.0,2389.0,1146.0,1412.0,8539.0,2819.0,3720.0,3329.0,3772.0,4798.0,686.0,2048.0,33531.0,2861.0,2113.0,2081.0,2636.0,2563.0,665.0,281.0,6489.0,1959.0,188.0,744.0,1582.0,584.0,257.0,228.0,180.0,214.0,1177.0,1060.0,2557.0,586.0,145.0,160.0,769.0,668.0,273.0,232.0,66716.0,33270.0,132.0,378.0,29346.0,705.0,4749.0,14658.0,69776.0,2031.0,4310.0,785.0,1970.0,3026.0,601.0,1587.0,4958.0,16471.0,3272.0,73540.0,32726.0,5155.0,133833.0,17208.0,5382.0,2247.0,508919.0,197126.0,6665.0,46063.0,2252.0,93808.0,22975.0,29296.0,3098.0,1156.0,7270.0,2925.0,20964.0,4579.0,4344.0,1939.0,2085.0,5281.0,1286.0,36640.0,342976.0,3030.0,2705.0,46276.0,4287.0,44395.0,4873.0,1369.0,8460.0,10982.0,110251.0,2153.0,9446.0,5656.0,2327.0,1295.0,7886.0,2146.0,2116.0,2838.0,893.0,3495.0,2710.0,1617.0,2024.0,837.0,4988.0,4706.0,436.0,724.0,1271.0,12339.0,163723.0,933.0,5561.0,865.0,2630.0,1728.0,8410.0,2523.0,6203.0,3267.0,956.0,3320.0,13087.0,2827.0,5044.0,18358.0,3572.0,2668.0,7851.0,7300.0,2919.0,2475.0,3493.0,2574.0,1187.0,566.0,154.0,154.0,737.0,59.0,5837.0,7021.0,1352.0,8196.0,2371.0,147949.0,2041.0,23024.0,50219.0,17156.0,59105.0,18377.0,298353.0,3490.0,227.0,616.0,3077.0,119.0,381.0,16.0,153.0,572.0,317.0,702.0,470.0,2904.0,210.0,873.0,219.0,30.0,40.0,831.0,550.0,32.0,2663.0,765.0,571.0,70.0,490.0,337.0,62.0,40198.0,10210.0,54472.0,18626.0,192.0,6226.0,6033.0,1445.0,10810.0,9610.0,2210.0,401068.0,3400.0,430.0,12202.0,13123.0,56874.0,174063.0,102915.0,4327.0,473389.0,6852.0,15191.0,15552.0,2564.0,17165.0,28023.0,4286.0,7959.0,64958.0,2157.0,12832.0,2068.0,129922.0,14670.0,411.0,2102.0,222.0,323.0,882.0,961.0,4239.0,2893.0,7969.0,4379.0,2584.0,1341.0,7895.0,3061.0,855.0,871.0,28431.0,221.0,6359.0,13223.0,15741.0,14077.0,30225.0,165861.0,469.0,64287.0,626.0,17322.0,4157.0,11468.0,3437.0,12926.0,3802.0,4630.0,3991.0,7367.0,3642.0,6138.0,3886.0,89048.0,8522.0,340.0,4879.0,571.0,535.0,974.0,334.0,125.0,8076.0,2223.0,12085.0,894.0,4372.0,998.0,4174.0,1823.0,865.0,1967.0,496.0,2425.0,1252.0,1051.0,717.0,31.0,1277.0,253.0,387.0,110000.0,1161.0,776.0,302.0,224.0,34.0,164.0,90.0,314.0,10976.0,3633.0,5.0,27956.0,403.0,881.0,4624.0,2042.0,45744.0,5716.0,1700.0,1148.0,20.0,452.0,103.0,96.0,22128.0,84.0,42297.0,807.0,426.0,6705.0,76.0,31.0,1997.0,1026.0,10251.0,4015.0,24579.0,603.0,4492.0,3047.0,1531.0,12960.0,2516.0,680.0,4884.0,41030.0,371.0,19091.0,6208.0,2830.0,4057.0,6419.0,1347.0,74640.0,5269.0,27879.0,5329.0,76744.0,6445.0,17544.0,17842.0,7839.0,7768.0,60561.0,11872.0,53358.0,2948.0,11875.0,3426.0,666.0,4100.0,5370.0,20167.0,7568.0,42506.0,5645.0,6351.0,37054.0,1783.0,537.0,7675.0,2082.0,6362.0,2724.0,490.0,1324.0]},"kind":"numeric","n":3141,"n_null":0,"n_unique":2688,"null_rate":0.0,"stats":{"iqr":8872.0,"kurtosis":224.35590052967373,"max":1893770.0,"mean":20734.10347023241,"median":3194.0,"min":4.0,"n_outliers":468,"outlier_rate":0.1489971346704871,"q1":1175.0,"q3":10047.0,"skew":11.651875952009002,"std":72003.69590998709,"zero_rate":0.0}},{"alerts":[{"code":"high_skew","level":"info","message":"skew=+5.78"},{"code":"outliers","level":"warn","message":"12.5% rows beyond 1.5 IQR"}],"column":"votes_gop","extras":{"histogram":{"counts":[2260,381,153,100,54,32,27,23,47,13,14,4,8,2,2,2,4,3,1,1,1,2,1,0,1,0,0,0,1,0,1,0,0,0,0,1,0,0,1,1],"edges":[57.0,15562.7,31068.4,46574.100000000006,62079.8,77585.5,93091.20000000001,108596.90000000001,124102.6,139608.30000000002,155114.0,170619.7,186125.40000000002,201631.1,217136.80000000002,232642.5,248148.2,263653.9,279159.60000000003,294665.3,310171.0,325676.7,341182.4,356688.10000000003,372193.80000000005,387699.5,403205.2,418710.9,434216.60000000003,449722.30000000005,465228.0,480733.7,496239.4,511745.10000000003,527250.8,542756.5,558262.2000000001,573767.9,589273.6,604779.3,620285.0]},"sample":[130413.0,130413.0,18110.0,5230.0,27619.0,10282.0,32132.0,30567.0,5819.0,29217.0,91087.0,9210.0,3825.0,1554.0,22798.0,29170.0,3470.0,1229.0,3604.0,5405.0,4600.0,53857.0,42193.0,620285.0,17531.0,163024.0,53731.0,53740.0,72960.0,118764.0,12313.0,109638.0,1716.0,1166.0,14272.0,905.0,11584.0,176506.0,1875.0,628.0,726.0,5293.0,5149.0,1109.0,11553.0,62607.0,46584.0,54377.0,88370.0,2996.0,7476.0,3930.0,2795.0,101888.0,71788.0,238746.0,157216.0,21873.0,14281.0,142763.0,25695.0,14476.0,4491.0,6717.0,2661.0,6457.0,566.0,1724.0,152602.0,6009.0,2552.0,17865.0,5269.0,9622.0,24045.0,13184.0,7285.0,21754.0,2519.0,8304.0,5183.0,1888.0,26901.0,4622.0,24441.0,13463.0,805.0,5275.0,5092.0,6612.0,7288.0,31093.0,9751.0,2569.0,2332.0,7574.0,4755.0,6743.0,2655.0,5193.0,5637.0,3060.0,10940.0,3115.0,2203.0,3340.0,5980.0,7347.0,7255.0,10699.0,3216.0,13101.0,1650.0,2153.0,108608.0,8597.0,3776.0,37081.0,4453.0,35299.0,1583.0,1965.0,38620.0,5780.0,4039.0,5639.0,21503.0,8530.0,11079.0,9382.0,11077.0,12286.0,2118.0,5800.0,38719.0,6572.0,6138.0,4511.0,8206.0,6813.0,2386.0,1822.0,18781.0,6017.0,1172.0,2856.0,5905.0,2601.0,1651.0,1011.0,1204.0,1168.0,3928.0,3250.0,8466.0,1790.0,970.0,1216.0,2824.0,2652.0,1999.0,1832.0,101319.0,35349.0,580.0,2136.0,15520.0,2711.0,10367.0,25050.0,56890.0,5435.0,15277.0,4363.0,4944.0,8660.0,4278.0,4928.0,7697.0,36135.0,5474.0,100292.0,68191.0,6502.0,24267.0,21966.0,6926.0,3390.0,216163.0,157138.0,20025.0,24163.0,10189.0,44792.0,28189.0,31753.0,5403.0,2158.0,14241.0,4019.0,27412.0,10629.0,8344.0,3159.0,3740.0,8505.0,3498.0,35962.0,289127.0,6827.0,7336.0,90456.0,8141.0,45469.0,13446.0,2556.0,8160.0,22287.0,99624.0,4659.0,14041.0,13635.0,5230.0,2974.0,8436.0,4000.0,2800.0,5967.0,2129.0,6019.0,11427.0,6000.0,7212.0,3231.0,13052.0,16721.0,2323.0,2458.0,5895.0,35420.0,114777.0,3343.0,18111.0,3668.0,10435.0,8875.0,4251.0,414.0,5576.0,5423.0,4309.0,13720.0,31204.0,1778.0,18493.0,25607.0,7697.0,7613.0,7671.0,7371.0,15530.0,3374.0,5957.0,3366.0,1259.0,2329.0,1276.0,858.0,1786.0,350.0,3476.0,8511.0,4395.0,12151.0,2851.0,97461.0,2941.0,23142.0,54665.0,36342.0,18373.0,20294.0,193607.0,2560.0,1445.0,3715.0,11319.0,827.0,2717.0,237.0,1380.0,3533.0,2623.0,3610.0,2373.0,4028.0,911.0,3763.0,1302.0,471.0,355.0,2387.0,2519.0,400.0,10518.0,2068.0,3832.0,687.0,1993.0,1770.0,377.0,37674.0,10796.0,47882.0,28237.0,617.0,5251.0,11756.0,3865.0,13175.0,13125.0,7828.0,319571.0,13542.0,1403.0,16194.0,12756.0,58163.0,128871.0,78277.0,11582.0,138550.0,12528.0,22755.0,10816.0,9567.0,29577.0,47506.0,11164.0,18563.0,65346.0,6869.0,36311.0,6359.0,109531.0,31622.0,1892.0,7818.0,1964.0,1482.0,3697.0,3387.0,13613.0,13151.0,15029.0,8926.0,7627.0,4716.0,30893.0,10888.0,4615.0,6329.0,13030.0,632.0,3223.0,26582.0,18333.0,31249.0,46081.0,163873.0,1495.0,60620.0,1680.0,49554.0,10394.0,24920.0,14533.0,35475.0,11159.0,15613.0,11710.0,27347.0,12928.0,10605.0,2197.0,75233.0,5434.0,974.0,6748.0,1565.0,588.0,1627.0,1391.0,543.0,15499.0,8441.0,37385.0,3580.0,11526.0,3626.0,4912.0,5685.0,2180.0,4928.0,2325.0,9525.0,5097.0,4434.0,5034.0,330.0,6325.0,1802.0,3177.0,169175.0,5510.0,6008.0,741.0,1223.0,553.0,891.0,660.0,2973.0,44370.0,15663.0,149.0,65566.0,1546.0,3349.0,12054.0,6340.0,150188.0,25385.0,8222.0,3924.0,524.0,3241.0,1378.0,807.0,58631.0,715.0,12946.0,3166.0,1797.0,16643.0,327.0,537.0,2635.0,6436.0,7160.0,9693.0,89755.0,1548.0,13369.0,4657.0,792.0,22110.0,1421.0,1603.0,8374.0,17802.0,958.0,21284.0,10507.0,5089.0,11875.0,9157.0,2213.0,14254.0,14078.0,33840.0,5129.0,84389.0,5533.0,8604.0,24066.0,11358.0,18482.0,46762.0,13539.0,67192.0,5412.0,17912.0,3844.0,1897.0,7188.0,8400.0,30458.0,13864.0,46620.0,7370.0,6994.0,43447.0,6483.0,1889.0,18687.0,9866.0,21835.0,7583.0,3376.0,15778.0]},"kind":"numeric","n":3141,"n_null":0,"n_unique":2901,"null_rate":0.0,"stats":{"iqr":14889.0,"kurtosis":51.77634161762262,"max":620285.0,"mean":20645.278573702642,"median":7268.0,"min":57.0,"n_outliers":394,"outlier_rate":0.12543775867558102,"q1":3241.0,"q3":18130.0,"skew":5.780493870513177,"std":41627.2284326707,"zero_rate":0.0}},{"alerts":[{"code":"high_skew","level":"info","message":"skew=+8.89"},{"code":"outliers","level":"warn","message":"14.1% rows beyond 1.5 IQR"}],"column":"total_votes","extras":{"histogram":{"counts":[2699,192,77,70,33,20,12,4,7,9,4,5,1,1,1,1,1,0,1,1,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,1],"edges":[64.0,66364.2,132664.4,198964.59999999998,265264.8,331565.0,397865.19999999995,464165.39999999997,530465.6,596765.7999999999,663066.0,729366.2,795666.3999999999,861966.6,928266.7999999999,994567.0,1060867.2,1127167.4,1193467.5999999999,1259767.8,1326068.0,1392368.2,1458668.4,1524968.5999999999,1591268.7999999998,1657569.0,1723869.2,1790169.4,1856469.5999999999,1922769.7999999998,1989070.0,2055370.2,2121670.4,2187970.6,2254270.8,2320571.0,2386871.1999999997,2453171.4,2519471.6,2585771.8,2652072.0]},"sample":[246588.0,246588.0,24661.0,6572.0,36905.0,15213.0,43474.0,42030.0,6931.0,34965.0,163387.0,19136.0,6167.0,2250.0,34968.0,46364.0,4744.0,3004.0,5192.0,7190.0,6389.0,93805.0,87847.0,2652072.0,109941.0,467526.0,287499.0,164224.0,156141.0,307881.0,21058.0,281658.0,2107.0,1892.0,37342.0,1076.0,16661.0,313273.0,3772.0,862.0,853.0,6510.0,13772.0,2707.0,280272.0,105814.0,127827.0,79590.0,151609.0,4355.0,8506.0,7641.0,3375.0,169898.0,100657.0,491520.0,283828.0,32652.0,18675.0,260304.0,33559.0,24151.0,9350.0,9477.0,3757.0,8246.0,1271.0,2443.0,326424.0,10238.0,4782.0,23395.0,7912.0,11764.0,34250.0,16128.0,10077.0,27057.0,3682.0,12524.0,7575.0,2540.0,68320.0,6650.0,74952.0,37589.0,2053.0,10973.0,6879.0,9108.0,10924.0,40425.0,11771.0,4470.0,4276.0,26335.0,7055.0,10247.0,3590.0,8789.0,8505.0,4943.0,17554.0,4525.0,2928.0,10723.0,7952.0,10667.0,18146.0,17195.0,5054.0,18533.0,2133.0,3480.0,293574.0,15215.0,5903.0,78995.0,6209.0,77465.0,2473.0,2583.0,63347.0,8514.0,5402.0,7289.0,31422.0,11896.0,15472.0,13331.0,15483.0,18008.0,2917.0,8189.0,76492.0,9959.0,8559.0,6913.0,11333.0,9902.0,3277.0,2209.0,27051.0,8386.0,1409.0,3831.0,8008.0,3366.0,2011.0,1300.0,1483.0,1448.0,5465.0,4578.0,11623.0,2568.0,1160.0,1435.0,3806.0,3567.0,2378.0,2159.0,180750.0,73648.0,742.0,2677.0,47467.0,3522.0,16039.0,42471.0,136112.0,7774.0,20325.0,5293.0,7212.0,12223.0,4991.0,6740.0,13547.0,54663.0,8869.0,181388.0,105599.0,11852.0,165619.0,39970.0,12710.0,5798.0,767337.0,380972.0,27804.0,72480.0,12905.0,146401.0,55340.0,65999.0,9144.0,3486.0,23272.0,7313.0,51460.0,15848.0,13349.0,5328.0,6088.0,14658.0,5008.0,77114.0,663255.0,10386.0,10597.0,145405.0,13036.0,94198.0,19243.0,4151.0,18059.0,35568.0,228659.0,7355.0,25538.0,20875.0,8125.0,4642.0,17914.0,6671.0,5350.0,9579.0,3279.0,10137.0,14604.0,8021.0,9584.0,4309.0,19127.0,22182.0,2842.0,3316.0,7440.0,50045.0,294063.0,4452.0,24857.0,4664.0,13709.0,10935.0,12831.0,2954.0,11906.0,8790.0,5325.0,17517.0,45465.0,4639.0,24179.0,45048.0,11443.0,10438.0,16151.0,14854.0,18893.0,5909.0,9534.0,6058.0,2621.0,3097.0,1474.0,1056.0,2692.0,441.0,9380.0,15743.0,5885.0,20601.0,5328.0,252087.0,5039.0,46903.0,108737.0,55364.0,79830.0,39454.0,510940.0,6115.0,1769.0,4564.0,15547.0,1002.0,3220.0,263.0,1579.0,4360.0,3082.0,4569.0,2973.0,7259.0,1165.0,4902.0,1582.0,510.0,414.0,3430.0,3242.0,451.0,13956.0,3035.0,4609.0,793.0,2613.0,2172.0,459.0,81982.0,22101.0,105738.0,48375.0,903.0,12633.0,19636.0,5855.0,27350.0,25016.0,10936.0,765421.0,18545.0,1982.0,30124.0,27255.0,120199.0,320164.0,191962.0,16722.0,627021.0,20556.0,39809.0,27941.0,12588.0,48736.0,79633.0,16156.0,27768.0,136654.0,9410.0,51467.0,8842.0,249937.0,48550.0,2393.0,10531.0,2246.0,1896.0,4734.0,4525.0,18948.0,16839.0,24193.0,13924.0,10686.0,6346.0,40834.0,14437.0,5771.0,7573.0,45577.0,937.0,10383.0,42613.0,37030.0,47138.0,79036.0,342572.0,2024.0,130160.0,2398.0,69345.0,14955.0,37728.0,18551.0,50294.0,15572.0,21153.0,16333.0,35730.0,17334.0,17400.0,6195.0,175850.0,14217.0,1407.0,12680.0,2288.0,1175.0,2747.0,1818.0,690.0,25231.0,11621.0,51849.0,4577.0,16363.0,4750.0,9242.0,7762.0,3165.0,7139.0,2926.0,12223.0,6520.0,5667.0,5842.0,365.0,7797.0,2084.0,3635.0,293287.0,6822.0,6935.0,1065.0,1475.0,602.0,1089.0,760.0,3339.0,57270.0,19936.0,159.0,98060.0,1997.0,4283.0,17187.0,8607.0,203083.0,31761.0,10175.0,5147.0,550.0,3765.0,1502.0,933.0,83161.0,808.0,56867.0,4101.0,2299.0,35879.0,465.0,617.0,5385.0,9778.0,20133.0,18905.0,174942.0,2243.0,18641.0,8131.0,2367.0,37124.0,4040.0,2363.0,13930.0,61489.0,1391.0,42737.0,17507.0,8176.0,16794.0,16140.0,3651.0,94724.0,20335.0,65350.0,11144.0,171876.0,12966.0,27832.0,45485.0,20584.0,28260.0,118625.0,27767.0,127497.0,8719.0,31471.0,7678.0,2651.0,11736.0,14563.0,53368.0,22691.0,93678.0,13581.0,14193.0,85892.0,8654.0,2528.0,27868.0,12315.0,29311.0,10816.0,4040.0,17935.0]},"kind":"numeric","n":3141,"n_null":0,"n_unique":2966,"null_rate":0.0,"stats":{"iqr":24929.0,"kurtosis":136.16835619619758,"max":2652072.0,"mean":43636.62304998408,"median":11144.0,"min":64.0,"n_outliers":442,"outlier_rate":0.14071951607768227,"q1":4870.0,"q3":29799.0,"skew":8.894175868800874,"std":114567.96253869879,"zero_rate":0.0}},{"alerts":[],"column":"per_dem","extras":{"histogram":{"counts":[8,16,52,74,116,146,203,226,240,218,200,205,153,147,153,152,106,111,77,78,56,72,45,42,36,36,34,25,30,16,12,12,14,9,6,4,4,4,2,1],"edges":[0.0314465408805,0.0538720253290375,0.076297509777575,0.0987229942261125,0.12114847867465,0.14357396312318751,0.165999447571725,0.1884249320202625,0.2108504164688,0.23327590091733752,0.25570138536587506,0.2781268698144125,0.30055235426295,0.32297783871148755,0.345403323160025,0.3678288076085625,0.39025429205710005,0.4126797765056375,0.435105260954175,0.45753074540271255,0.4799562298512501,0.5023817142997875,0.524807198748325,0.5472326831968626,0.5696581676454,0.5920836520939375,0.6145091365424751,0.6369346209910126,0.65936010543955,0.6817855898880876,0.7042110743366251,0.7266365587851625,0.7490620432337001,0.7714875276822376,0.793913012130775,0.8163384965793126,0.8387639810278501,0.8611894654763875,0.8836149499249251,0.9060404343734626,0.928465918822]},"sample":[0.37715947248,0.37715947248,0.239568549532,0.187766281193,0.228586912343,0.308814829422,0.238073331186,0.250939804901,0.14932910114,0.140511940512,0.418815450434,0.500470317726,0.314415437003,0.282666666667,0.299530999771,0.313281856613,0.224915682968,0.577563249001,0.26906779661,0.204728789986,0.230395993113,0.380971163584,0.440265461541,0.714071865319,0.788150007731,0.585567433683,0.763759178293,0.609655105222,0.473539941463,0.553749663019,0.343527400513,0.526755852843,0.131941148552,0.307082452431,0.523003588453,0.118029739777,0.242962607286,0.337746949147,0.432396606575,0.19837587007,0.106682297773,0.13425499232,0.54363926808,0.496859992612,0.928465918822,0.371680495965,0.589625040093,0.286028395527,0.376719060214,0.291848450057,0.100164589701,0.462897526502,0.152592592593,0.368438710285,0.235562355326,0.474704996745,0.412862719675,0.303809873821,0.211780455154,0.417945940132,0.204445901249,0.364871019834,0.505882352941,0.270760789279,0.272291722119,0.195488721805,0.548387096774,0.280392959476,0.488370953116,0.400859542879,0.452739439565,0.20735199829,0.316860465116,0.163209792588,0.266481751825,0.153955853175,0.256326287586,0.165169826662,0.308527973927,0.316192909614,0.299273927393,0.244881889764,0.579654566745,0.275037593985,0.649842565909,0.61736146213,0.594252313687,0.503052948145,0.243930803896,0.256697408871,0.317740754302,0.204799010513,0.142044006457,0.412527964206,0.442703461179,0.624871843554,0.275832742736,0.297745681663,0.22061281337,0.349300261691,0.297354497354,0.332389237305,0.311552922411,0.274917127072,0.0870901639344,0.598340016786,0.154552313883,0.198462548045,0.445993607407,0.280779296307,0.319944598338,0.254195219338,0.196436943272,0.330747126437,0.572891332339,0.36141965166,0.302219210571,0.454687005507,0.237719439523,0.483263409282,0.330367974121,0.204413472706,0.324687830521,0.280596664318,0.2121436505,0.193716559199,0.271752275476,0.236970410222,0.240434332989,0.249718700773,0.243622037073,0.266437139049,0.235173123072,0.250091586274,0.438359567014,0.28727783914,0.246874634887,0.301027050485,0.232595076326,0.258836598667,0.202929508697,0.127206880942,0.239880226239,0.233603625089,0.133427963094,0.194205168363,0.197552447552,0.173499702911,0.127797115863,0.175384615385,0.12137559002,0.147790055249,0.215370539799,0.231542158148,0.219994837822,0.228193146417,0.125,0.11149825784,0.202049395691,0.18727221755,0.11480235492,0.107457156091,0.369106500692,0.451743428199,0.177897574124,0.141202838999,0.618240040449,0.200170357751,0.296090778727,0.345129617857,0.512636652169,0.261255466941,0.212054120541,0.148309087474,0.273155851359,0.247566063978,0.12041675015,0.235459940653,0.36598508895,0.301318990908,0.368925470741,0.405429245595,0.309908237767,0.434947688154,0.80807757564,0.430522892169,0.423446105429,0.387547430148,0.663227499782,0.517429102401,0.239713710258,0.635527041943,0.174506005424,0.640760650542,0.415160823997,0.443885513417,0.338801399825,0.331612162937,0.312392574768,0.399972651443,0.407384376215,0.288932357395,0.32541763428,0.363926426426,0.342477003942,0.360281075181,0.25678913738,0.475140700781,0.517110312022,0.291738879261,0.255260922903,0.318255905918,0.328858545566,0.471294507314,0.253234942577,0.329800048181,0.468464477546,0.308760683761,0.482163396149,0.29272603671,0.369880178557,0.270946107784,0.2864,0.278974579922,0.440214357486,0.321690900914,0.395514018692,0.296273097401,0.272339127783,0.344776561113,0.185565598466,0.201595810996,0.211185308848,0.194244604317,0.260783186072,0.212153998738,0.153413089374,0.218335343788,0.170833333333,0.246558097712,0.556761646314,0.209568733154,0.22371967655,0.185463121784,0.191844773506,0.158024691358,0.655443846933,0.854096140826,0.520997816227,0.371672354949,0.179530516432,0.189530170691,0.287847795007,0.60939857728,0.208610777948,0.407520866631,0.312155903172,0.255604521939,0.486099931893,0.491450114447,0.154501667284,0.418852597732,0.36637298091,0.424892703863,0.452880579931,0.182757507265,0.10447761194,0.145833333333,0.273774145617,0.133786848073,0.622281449893,0.445975989329,0.229736618522,0.397844764817,0.445007507508,0.586896587289,0.405040682675,0.490885444428,0.4618391164,0.309876454013,0.740385819867,0.465782937091,0.583929619916,0.570727718724,0.128321085359,0.134969325153,0.197915996655,0.11876247505,0.118322981366,0.0608365019011,0.0968967701077,0.13119266055,0.102855288774,0.153644123441,0.158089471914,0.400055104009,0.18025751073,0.178090575275,0.138432364096,0.0588235294118,0.0966183574879,0.242274052478,0.169648365207,0.0709534368071,0.190813986816,0.252059308072,0.123888045129,0.0882723833544,0.187523918867,0.155156537753,0.135076252723,0.490327144983,0.461970046604,0.515160112731,0.385033591731,0.212624584718,0.492836222592,0.307241800774,0.246797608881,0.395246800731,0.38415414135,0.202084857352,0.523983533245,0.183337826908,0.216952573158,0.405059089098,0.481489634929,0.473165334154,0.543668245024,0.536121732426,0.258760913766,0.754981093137,0.333333333333,0.381597126278,0.556601410114,0.203686050207,0.352203709783,0.351901849736,0.265288437732,0.286624891962,0.475346495529,0.229224229543,0.249324810072,0.233883736711,0.519818994387,0.302162718847,0.171750940242,0.199601177476,0.0988423864648,0.170358649789,0.186311787072,0.212375690608,0.223717542749,0.17180355128,0.32939279957,0.314492961793,0.241811716264,0.211314213678,0.193343782142,0.212024658863,0.148154565933,0.115013865047,0.623801478816,0.235859124867,0.612443417124,0.310304367212,0.425087766676,0.298633798634,0.382420669062,0.484163912988,0.231719367589,0.493907498463,0.26105087573,0.249794505732,0.277967235038,0.303965224767,0.185273031103,0.257008788325,0.244156177755,0.218881482532,0.24435192555,0.206185278477,0.210107303565,0.35275862069,0.627280064568,0.506386124538,0.599423225716,0.241648898365,0.384779179811,0.249562937063,0.455319148936,0.354568620313,0.183718371837,0.18115942029,0.32008243827,0.191291627227,0.23308067658,0.195324448329,0.267188168429,0.210105263158,0.451633845488,0.234862148931,0.273301737757,0.275528785544,0.16951469583,0.198396465679,0.192024539877,0.185459678842,0.122731941116,0.0849315068493,0.163780941388,0.121401151631,0.106464924347,0.375059242312,0.17018469657,0.111896178803,0.283568075117,0.15186440678,0.0564784053156,0.15059687787,0.118421052632,0.094040131776,0.191653570805,0.182233146067,0.0314465408805,0.285090760759,0.201802704056,0.205696941396,0.269040553907,0.237248751017,0.225247805085,0.179969144548,0.167076167076,0.223042549058,0.0363636363636,0.12005312085,0.0685752330226,0.102893890675,0.266086266399,0.10396039604,0.743788137232,0.19678127286,0.185297955633,0.186878118119,0.163440860215,0.0502431118314,0.370844939647,0.104929433422,0.509164059008,0.212377677863,0.140497993621,0.268836379848,0.240974196663,0.374738654532,0.646810308407,0.349100312466,0.622772277228,0.287769784173,0.350610193826,0.667273821334,0.266714593817,0.446708940731,0.354601016736,0.346135029354,0.241574371799,0.39770755886,0.368940016434,0.78797348085,0.259109909024,0.426610558531,0.478194544149,0.44650794759,0.49706925806,0.630353549871,0.392261185006,0.380829770696,0.274876150035,0.510524762908,0.427557892462,0.418503964799,0.338112168827,0.37733151155,0.446209950508,0.251225952471,0.349352419905,0.368742704113,0.377885624344,0.33352430479,0.453745810116,0.415654222811,0.447474106954,0.431402226051,0.206031892766,0.212420886076,0.275405482991,0.169062119367,0.217051618846,0.251849112426,0.121287128713,0.0738221354893]},"kind":"numeric","n":3141,"n_null":0,"n_unique":3112,"null_rate":0.0,"stats":{"iqr":0.19287066302099998,"kurtosis":0.6858690372897414,"max":0.928465918822,"mean":0.317636958507273,"median":0.2864,"min":0.0314465408805,"n_outliers":76,"outlier_rate":0.024196115886660298,"q1":0.205370006549,"q3":0.39824066957,"skew":0.94215246392412,"std":0.1529831118295485,"zero_rate":0.0}},{"alerts":[],"column":"per_gop","extras":{"histogram":{"counts":[1,2,5,2,6,11,7,17,17,17,23,32,34,30,43,41,64,71,63,89,78,117,116,147,147,156,165,193,190,215,223,213,187,142,113,74,49,29,9,3],"edges":[0.0412206713478,0.06400833638228,0.08679600141676,0.10958366645123999,0.13237133148572,0.1551589965202,0.17794666155467997,0.20073432658916,0.22352199162363998,0.24630965665811996,0.2690973216926,0.29188498672707996,0.31467265176155995,0.33746031679603994,0.36024798183052,0.38303564686499997,0.40582331189947995,0.42861097693395994,0.45139864196843993,0.47418630700291997,0.49697397203739996,0.51976163707188,0.5425493021063599,0.5653369671408399,0.58812463217532,0.6109122972098,0.6336999622442798,0.6564876272787599,0.6792752923132399,0.70206295734772,0.7248506223822,0.7476382874166798,0.7704259524511599,0.7932136174856399,0.8160012825201199,0.8387889475546,0.8615766125890798,0.8843642776235598,0.9071519426580399,0.9299396076925199,0.952727272727]},"sample":[0.528870018006,0.528870018006,0.734357893029,0.795800365186,0.748380978187,0.67586932229,0.739108432626,0.727266238401,0.839561390853,0.835607035607,0.557492334151,0.48129180602,0.62023674396,0.690666666667,0.651967513155,0.62915192822,0.731450252951,0.409121171771,0.694144838213,0.75173852573,0.719987478479,0.574137839134,0.480300977836,0.233886938213,0.159458254882,0.348695045837,0.186891084839,0.327235970382,0.467269967529,0.385746440995,0.584718396809,0.389259314488,0.81442809682,0.616279069767,0.382196989984,0.841078066914,0.695276393974,0.563425510657,0.497083775186,0.728538283063,0.851113716295,0.813056835637,0.373874528028,0.409678611008,0.0412206713478,0.591670289376,0.364430049989,0.683213971604,0.582880963531,0.68794489093,0.878909005408,0.514330585002,0.828148148148,0.599700997069,0.713194313361,0.485729980469,0.553912933185,0.669882396178,0.764712182062,0.548447200197,0.765666438213,0.599395470167,0.480320855615,0.708768597657,0.708277881288,0.783046325491,0.445318646735,0.705689725747,0.46749626253,0.586931041219,0.533667921372,0.763624706134,0.665950455005,0.817919075145,0.70204379562,0.81746031746,0.722933412722,0.80400635695,0.684139054861,0.663046949856,0.684224422442,0.743307086614,0.39375,0.695037593985,0.326088696766,0.358163292453,0.392109108622,0.480725416932,0.740223869749,0.725955204216,0.667154888319,0.76915275201,0.828391810381,0.574720357942,0.54536950421,0.287602050503,0.673990077959,0.658046257441,0.739554317549,0.590852201616,0.66278659612,0.619057252681,0.623219778968,0.688397790055,0.752390710383,0.31147999627,0.752012072435,0.688759726259,0.399812630883,0.622215760395,0.636327661258,0.706901203259,0.773558368495,0.61867816092,0.369951017461,0.565034505422,0.639674741657,0.469409456295,0.717184731841,0.455676757245,0.640113222806,0.760743321719,0.609657915923,0.678881841673,0.747686042207,0.77363149952,0.684329450703,0.717047747142,0.716067735264,0.703773160303,0.715429826261,0.682252332297,0.726088447035,0.708267187691,0.506183653192,0.659905613013,0.717139852787,0.652538695212,0.724080120004,0.688042819632,0.728104974062,0.824807605251,0.6942811726,0.717505366086,0.831795599716,0.745497259201,0.737387612388,0.772727272727,0.820984584784,0.777692307692,0.811867835469,0.806629834254,0.718755718207,0.709916994321,0.728383377785,0.697040498442,0.836206896552,0.847386759582,0.741986337362,0.743481917578,0.840622371741,0.8485409912,0.560547717842,0.479972300673,0.78167115903,0.797908106089,0.326963996039,0.76973310619,0.646361992643,0.589814226178,0.417964617374,0.699125289426,0.751635916359,0.824296240317,0.685524126456,0.708500368158,0.857142857143,0.73115727003,0.568170074555,0.66105043631,0.617205998421,0.552914194985,0.645754221157,0.548599392508,0.146523043854,0.549562171629,0.544925255704,0.584684373922,0.2817054306,0.412466008001,0.720220112214,0.333374724062,0.789538938396,0.305954194302,0.509378388146,0.481113350202,0.590879265092,0.619047619048,0.611937091784,0.549569260222,0.532685581034,0.670683997981,0.625065547981,0.592905405405,0.61432325887,0.580229226361,0.698482428115,0.466348522966,0.435921327393,0.657327171192,0.692271397565,0.622096901757,0.624501380792,0.48269602327,0.698747596529,0.615755239701,0.45185226203,0.626602564103,0.435688077005,0.633446634942,0.549808129063,0.653173652695,0.643692307692,0.640672124084,0.470916601541,0.599610253335,0.523364485981,0.622925148763,0.649283318085,0.593765413831,0.782456861134,0.748036404438,0.752504173623,0.749825945695,0.682386155696,0.753809395005,0.817382125264,0.741254523522,0.792338709677,0.707763013288,0.390314320401,0.750898472597,0.728607635676,0.786449399657,0.761178787658,0.811614083219,0.331306990881,0.140148950575,0.46833529313,0.616951080774,0.809201877934,0.783239139122,0.686330144067,0.383272256952,0.76483725547,0.56843811046,0.672638294154,0.72935428243,0.474955111139,0.496229971725,0.821997565236,0.570993399898,0.624816446402,0.555628920436,0.480351011064,0.752018082015,0.865671641791,0.8125,0.663447251114,0.793650793651,0.370575692964,0.540621228483,0.74681393373,0.589825736615,0.535097597598,0.386616525247,0.583647549117,0.493401274972,0.502726762739,0.656419333863,0.230151572091,0.514371166422,0.378923161232,0.41864268193,0.816845675523,0.813978965819,0.728050427735,0.825349301397,0.843788819876,0.901140684411,0.873970867638,0.810321100917,0.85107073329,0.790107244474,0.798183652876,0.554897368784,0.781974248927,0.767645858833,0.823008849558,0.923529411765,0.857487922705,0.695918367347,0.776989512647,0.886917960089,0.753654342218,0.681383855025,0.831416793231,0.866330390921,0.762724837352,0.814917127072,0.821350762527,0.459539899002,0.488484683951,0.452836255651,0.583710594315,0.683277962348,0.415657405209,0.598696272153,0.660119555935,0.481718464351,0.524664214902,0.71580102414,0.417510102284,0.730223779995,0.707870837538,0.537578010888,0.46802421574,0.483889217048,0.402515585762,0.407773413488,0.69262049994,0.220965486004,0.60945709282,0.571604411063,0.387101392219,0.760009532888,0.606881976362,0.596561726922,0.691012626888,0.668503313166,0.478185783073,0.729968119022,0.705520041969,0.719181180728,0.438234435078,0.651328527291,0.790639364814,0.74237964106,0.874443455031,0.78164556962,0.780946345585,0.748508287293,0.718439940891,0.780984619039,0.621212747489,0.641051422005,0.713737600599,0.743145288371,0.756550913454,0.754173304703,0.799688095651,0.835732206523,0.285889812844,0.674493062967,0.310411249157,0.62380024875,0.495085066163,0.662925877212,0.583038109216,0.47836075336,0.738636363636,0.465734480639,0.70058381985,0.714600908501,0.695018388499,0.660517387617,0.783407902539,0.70535252714,0.716606730028,0.738098614854,0.716953407212,0.765379233137,0.745817468559,0.609482758621,0.354640839387,0.427824850725,0.382218470845,0.692253020611,0.532176656151,0.684003496503,0.500425531915,0.592282489989,0.765126512651,0.786956521739,0.614284015695,0.726357456329,0.721036085556,0.782171728206,0.704394059769,0.763368421053,0.531486691192,0.732414326205,0.6887835703,0.690292758089,0.794600136705,0.779268591999,0.781748466258,0.782424563261,0.861691201643,0.904109589041,0.811209439528,0.864683301344,0.874002751032,0.576824066529,0.807681031955,0.866330209084,0.695774647887,0.829152542373,0.918604651163,0.818181818182,0.868421052632,0.890386343217,0.774751178628,0.785664125201,0.937106918239,0.668631450133,0.774161241863,0.781928554751,0.701344039099,0.736609736261,0.739539991038,0.799250653317,0.808058968059,0.762385855838,0.952727272727,0.860823373174,0.917443408788,0.864951768489,0.705030002044,0.884900990099,0.227653999683,0.772006827603,0.781644193127,0.463864656206,0.703225806452,0.870340356564,0.489322191272,0.658212313357,0.35563502707,0.512721502248,0.513055755622,0.690147124387,0.717182554584,0.57274627967,0.334600760456,0.595571597888,0.351732673267,0.678374947101,0.601148600144,0.28951519784,0.688713156003,0.498022790556,0.600159936026,0.622431506849,0.707097773014,0.567348203222,0.606135305396,0.150479287192,0.692303909516,0.517827084927,0.460247666906,0.490987688799,0.426731451489,0.309140557632,0.529097504672,0.551787796347,0.653998584572,0.394200210748,0.487593186156,0.527008478631,0.620713384562,0.569158908201,0.500651211253,0.715579026782,0.612474437628,0.576804229898,0.570716534253,0.610991141862,0.497662204573,0.542669906487,0.492778130064,0.505832906441,0.74913334874,0.747231012658,0.670554040477,0.80113682501,0.744942171881,0.701090976331,0.835643564356,0.87973236688]},"kind":"numeric","n":3141,"n_null":0,"n_unique":3112,"null_rate":0.0,"stats":{"iqr":0.20450496731299994,"kurtosis":0.3759828894919437,"max":0.952727272727,"mean":0.6351437494806205,"median":0.665352643757,"min":0.0412206713478,"n_outliers":63,"outlier_rate":0.02005730659025788,"q1":0.545760031627,"q3":0.75026499894,"skew":-0.8192687210228851,"std":0.15613035807354947,"zero_rate":0.0}},{"alerts":[{"code":"one_word","level":"warn","message":"100.0% rows are a single word"},{"code":"allcaps","level":"info","message":"99.2% rows are all-caps"},{"code":"short_text","level":"info","message":"95th-percentile length under 20 chars"}],"column":"diff","extras":{"language_counts":{},"language_sample_size":3141,"length_histogram":{"counts":[2,0,0,0,0,22,0,0,0,0,440,0,0,0,0,0,0,0,0,0,1978,0,0,0,0,651,0,0,0,0,46,0,0,0,0,0,0,0,0,2],"edges":[1.0,1.2,1.4,1.6,1.8,2.0,2.2,2.4000000000000004,2.6,2.8,3.0,3.2,3.4000000000000004,3.6,3.8000000000000003,4.0,4.2,4.4,4.6,4.800000000000001,5.0,5.2,5.4,5.6000000000000005,5.800000000000001,6.0,6.2,6.4,6.6000000000000005,6.800000000000001,7.0,7.2,7.4,7.6000000000000005,7.800000000000001,8.0,8.2,8.4,8.600000000000001,8.8,9.0]},"near_unique":false,"sample":["37,410","653","1,713","862","575","63,321","601","1,326","169","3,658","2,524","2,261","12,126","37,410","1,328","1,765","4,717","3,362","3,473","4,000","1,984","2,207","5,847","3,962","1,287","15,730","263","2,120","5,079","643","19,013","11,391","583","1,002","41,847","1,687","2,525","2,466","9,305","18,096","737","14,070","2,177","286","418","8,342","1,879","3,537","395","9,938"],"top_values":[["37,410",29],["2,466",4],["1,891",4],["627",4],["3,030",4],["542",4],["608",4],["993",3],["4,025",3],["107",3],["159",3],["635",3],["1,042",3],["748",3],["1,540",3],["2,423",3],["708",3],["828",3],["1,941",3],["1,095",3]],"top_words":[["37,410",29],["2,466",4],["1,891",4],["627",4],["3,030",4],["542",4],["608",4],["993",3],["4,025",3],["107",3],["159",3],["635",3],["1,042",3],["748",3],["1,540",3],["2,423",3],["708",3],["828",3],["1,941",3],["1,095",3],["1,301",3],["2,457",3],["1,730",3],["3,165",3],["1,231",3]],"vocab_skipped":null,"word_histogram":{"counts":[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3141,0,0,0,0,0,0,0,0,0,0,0,0,0,0],"edges":[0.5,0.5333333333333333,0.5666666666666667,0.6,0.6333333333333333,0.6666666666666666,0.7,0.7333333333333334,0.7666666666666666,0.8,0.8333333333333333,0.8666666666666667,0.9,0.9333333333333333,0.9666666666666667,1.0,1.0333333333333332,1.0666666666666667,1.1,1.1333333333333333,1.1666666666666665,1.2,1.2333333333333334,1.2666666666666666,1.3,1.3333333333333335,1.3666666666666667,1.4,1.4333333333333333,1.4666666666666668,1.5]}},"kind":"text","n":3141,"n_null":0,"n_unique":2738,"null_rate":0.0,"stats":{"allcaps_rate":0.9923591212989494,"boilerplate_rate":0.0,"duplicate_rate":0.128303088188475,"emoji_rate":0.0,"len_max":9,"len_mean":4.935370900986947,"len_median":5.0,"len_min":1,"len_p95":6.0,"n_duplicates":403,"n_empty":0,"one_word_rate":1.0,"readability_flesch_mean":121.22000000000004,"url_rate":0.0,"vocab_size":2738,"word_mean":1.0,"word_median":1.0}},{"alerts":[{"code":"one_word","level":"warn","message":"100.0% rows are a single word"},{"code":"allcaps","level":"info","message":"100.0% rows are all-caps"},{"code":"short_text","level":"info","message":"95th-percentile length under 20 chars"}],"column":"per_point_diff","extras":{"language_counts":{},"language_sample_size":3141,"length_histogram":{"counts":[327,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,2814],"edges":[5.0,5.025,5.05,5.075,5.1,5.125,5.15,5.175,5.2,5.225,5.25,5.275,5.3,5.325,5.35,5.375,5.4,5.425,5.45,5.475,5.5,5.525,5.55,5.575,5.6,5.625,5.65,5.675,5.7,5.725,5.75,5.775,5.8,5.825,5.85,5.875,5.9,5.925,5.95,5.975,6.0]},"near_unique":false,"sample":["15.17%","23.77%","48.08%","50.06%","1.98%","27.14%","32.12%","22.89%","6.30%","54.61%","3.08%","45.78%","16.85%","15.17%","57.46%","37.50%","45.41%","63.73%","68.38%","29.96%","55.62%","42.51%","59.91%","7.81%","47.56%","32.95%","15.47%","43.64%","24.12%","4.53%","26.95%","43.90%","5.61%","28.74%","72.53%","26.80%","18.75%","47.93%","26.16%","50.62%","69.07%","28.06%","40.97%","4.74%","5.44%","25.51%","21.28%","24.28%","9.45%","27.70%"],"top_values":[["15.17%",31],["26.55%",5],["24.47%",4],["53.98%",4],["15.37%",4],["63.21%",4],["51.98%",3],["36.71%",3],["7.23%",3],["16.78%",3],["9.47%",3],["3.69%",3],["58.32%",3],["50.48%",3],["41.84%",3],["51.45%",3],["11.30%",3],["27.63%",3],["73.67%",3],["64.76%",3]],"top_words":[["15.17%",31],["26.55%",5],["24.47%",4],["53.98%",4],["15.37%",4],["63.21%",4],["51.98%",3],["36.71%",3],["7.23%",3],["16.78%",3],["9.47%",3],["3.69%",3],["58.32%",3],["50.48%",3],["41.84%",3],["51.45%",3],["11.30%",3],["27.63%",3],["73.67%",3],["64.76%",3],["1.50%",3],["67.56%",3],["57.39%",3],["55.63%",3],["41.35%",3]],"vocab_skipped":null,"word_histogram":{"counts":[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3141,0,0,0,0,0,0,0,0,0,0,0,0,0,0],"edges":[0.5,0.5333333333333333,0.5666666666666667,0.6,0.6333333333333333,0.6666666666666666,0.7,0.7333333333333334,0.7666666666666666,0.8,0.8333333333333333,0.8666666666666667,0.9,0.9333333333333333,0.9666666666666667,1.0,1.0333333333333332,1.0666666666666667,1.1,1.1333333333333333,1.1666666666666665,1.2,1.2333333333333334,1.2666666666666666,1.3,1.3333333333333335,1.3666666666666667,1.4,1.4333333333333333,1.4666666666666668,1.5]}},"kind":"text","n":3141,"n_null":0,"n_unique":2555,"null_rate":0.0,"stats":{"allcaps_rate":1.0,"boilerplate_rate":0.0,"duplicate_rate":0.18656478828398598,"emoji_rate":0.0,"len_max":6,"len_mean":5.895893027698185,"len_median":6.0,"len_min":5,"len_p95":6.0,"n_duplicates":586,"n_empty":0,"one_word_rate":1.0,"readability_flesch_mean":121.22000000000004,"url_rate":0.0,"vocab_size":2555,"word_mean":1.0,"word_median":1.0}},{"alerts":[],"column":"state_abbr","extras":{"singletons":1,"top_values":[["TX",254],["GA",159],["VA",133],["KY",120],["MO",115],["KS",105],["IL",102],["NC",100],["IA",99],["TN",95],["NE",93],["IN",92],["OH",88],["MN",87],["MI",83],["MS",82],["OK",77],["AR",75],["WI",72],["AL",67]]},"kind":"categorical","n":3141,"n_null":0,"n_unique":51,"null_rate":0.0,"stats":{"cardinality":51,"entropy":5.27455806845153,"entropy_ratio":0.9298594076547716,"top_rate":0.08086596625278573,"top_value":"TX"}},{"alerts":[{"code":"short_text","level":"info","message":"95th-percentile length under 20 chars"},{"code":"duplicates","level":"warn","message":"41.2% duplicate strings"}],"column":"county_name","extras":{"language_counts":{},"language_sample_size":3141,"length_histogram":{"counts":[29,0,0,0,0,0,0,29,0,255,0,465,0,683,0,585,0,485,0,280,202,0,52,0,40,0,15,0,11,0,6,0,2,0,1,0,0,0,0,1],"edges":[6.0,6.525,7.05,7.575,8.1,8.625,9.15,9.675,10.2,10.725000000000001,11.25,11.775,12.3,12.825,13.350000000000001,13.875,14.4,14.925,15.450000000000001,15.975,16.5,17.025,17.55,18.075000000000003,18.6,19.125,19.65,20.175,20.700000000000003,21.225,21.75,22.275000000000002,22.8,23.325,23.85,24.375,24.900000000000002,25.425,25.95,26.475,27.0]},"near_unique":false,"sample":["Alaska","Day County","San Augustine County","Fisher County","Clay County","Waukesha County","Red Lake County","Charlotte County","Frio County","Franklin County","Merrimack County","Camden County","Vanderburgh County","Alaska","Grant County","Emmet County","Pitkin County","Jackson County","Big Horn County","Iosco County","Rice County","Little River County","Stephens County","Windham County","Tillman County","Pennington County","Tyrrell County","Keokuk County","Yuba County","Vernon County","Fairfield County","Lawrence County","Barbour County","Baraga County","Livingston Parish","Pope County","Orange County","Custer County","Buchanan County","Caldwell County","Concho County","Roanoke County","Allen County","Radford city","Crawford County","Cabell County","Rowan County","Charlevoix County","Terrell County","Cache County"],"top_values":[["Washington County",30],["Alaska",29],["Jefferson County",25],["Franklin County",24],["Jackson County",23],["Lincoln County",23],["Madison County",19],["Clay County",18],["Montgomery County",18],["Marion County",17],["Monroe County",17],["Union County",17],["Wayne County",16],["Greene County",14],["Grant County",14],["Warren County",14],["Carroll County",13],["Lee County",12],["Marshall County",12],["Clark County",12]],"top_words":[["county",3006],["parish",64],["city",43],["washington",31],["alaska",29],["jefferson",28],["franklin",26],["st.",26],["jackson",24],["lincoln",24],["madison",20],["clay",18],["montgomery",18],["union",18],["marion",17],["monroe",17],["lake",17],["san",17],["wayne",16],["carroll",15],["grant",15],["greene",14],["warren",14],["clark",13],["lawrence",12]],"vocab_skipped":null,"word_histogram":{"counts":[29,0,0,0,0,0,0,2925,0,0,0,0,0,0,0,177,0,0,0,0,0,0,8,0,0,0,0,0,0,2],"edges":[1.0,1.1333333333333333,1.2666666666666666,1.4,1.5333333333333332,1.6666666666666665,1.8,1.9333333333333333,2.0666666666666664,2.2,2.333333333333333,2.466666666666667,2.6,2.7333333333333334,2.8666666666666667,3.0,3.1333333333333333,3.2666666666666666,3.4,3.533333333333333,3.6666666666666665,3.8,3.933333333333333,4.066666666666666,4.2,4.333333333333334,4.466666666666667,4.6,4.733333333333333,4.866666666666667,5.0]}},"kind":"text","n":3141,"n_null":0,"n_unique":1848,"null_rate":0.0,"stats":{"allcaps_rate":0.0,"boilerplate_rate":0.0,"duplicate_rate":0.41165234001910217,"emoji_rate":0.0,"len_max":27,"len_mean":13.869149952244507,"len_median":14.0,"len_min":6,"len_p95":17.0,"n_duplicates":1293,"n_empty":0,"one_word_rate":0.009232728430436167,"readability_flesch_mean":38.384400000000014,"url_rate":0.0,"vocab_size":1840,"word_mean":2.0541228907991087,"word_median":2.0}},{"alerts":[],"column":"combined_fips","extras":{"histogram":{"counts":[96,0,80,68,0,72,3,6,221,0,48,102,92,204,120,73,30,15,156,96,115,149,17,24,40,62,153,88,77,103,0,23,94,95,283,14,133,39,55,95],"edges":[1001.0,2377.1,3753.2,5129.299999999999,6505.4,7881.5,9257.599999999999,10633.699999999999,12009.8,13385.9,14762.0,16138.099999999999,17514.199999999997,18890.3,20266.399999999998,21642.5,23018.6,24394.699999999997,25770.8,27146.899999999998,28523.0,29899.1,31275.199999999997,32651.3,34027.399999999994,35403.5,36779.6,38155.7,39531.799999999996,40907.899999999994,42284.0,43660.1,45036.2,46412.299999999996,47788.399999999994,49164.5,50540.6,51916.7,53292.799999999996,54668.899999999994,56045.0]},"sample":[2180.0,2198.0,1001.0,1027.0,1051.0,1053.0,1055.0,1069.0,1075.0,1095.0,1097.0,1113.0,5001.0,5013.0,5031.0,5045.0,5049.0,5077.0,5081.0,5135.0,5149.0,4021.0,6007.0,6037.0,6041.0,6067.0,6081.0,6083.0,6099.0,6111.0,6115.0,8005.0,8009.0,8011.0,8014.0,8017.0,8029.0,8041.0,8055.0,8057.0,8061.0,8081.0,8107.0,8109.0,11001.0,10005.0,12001.0,12017.0,12033.0,12043.0,12059.0,12065.0,12067.0,12069.0,12091.0,12103.0,12105.0,12107.0,12121.0,12127.0,12131.0,13031.0,13033.0,13035.0,13043.0,13055.0,13061.0,13065.0,13067.0,13087.0,13099.0,13103.0,13105.0,13111.0,13115.0,13137.0,13147.0,13157.0,13167.0,13169.0,13171.0,13201.0,13215.0,13221.0,13245.0,13247.0,13259.0,13261.0,13267.0,13279.0,13293.0,13297.0,13311.0,13317.0,13319.0,15007.0,19029.0,19059.0,19093.0,19095.0,19109.0,19115.0,19125.0,19133.0,16007.0,16013.0,16045.0,16053.0,16057.0,16069.0,17017.0,17055.0,17069.0,17071.0,17097.0,17103.0,17123.0,17113.0,17139.0,17143.0,17153.0,17171.0,17179.0,17181.0,17185.0,17193.0,17199.0,18023.0,18051.0,18073.0,18083.0,18099.0,18115.0,18117.0,18127.0,18147.0,18153.0,18165.0,18175.0,18181.0,20003.0,20007.0,20015.0,20021.0,20023.0,20029.0,20041.0,20043.0,20069.0,20081.0,20089.0,20105.0,20115.0,20117.0,20125.0,20127.0,20129.0,20135.0,20151.0,20159.0,20163.0,20171.0,20173.0,20177.0,20187.0,20201.0,20209.0,21023.0,21035.0,21037.0,21067.0,21097.0,21107.0,21135.0,21161.0,21163.0,21171.0,21221.0,21239.0,22005.0,22029.0,22051.0,22055.0,22067.0,22071.0,22097.0,22121.0,22125.0,25017.0,25027.0,24001.0,24017.0,24023.0,24027.0,23001.0,23011.0,23021.0,26013.0,26027.0,26053.0,26055.0,26063.0,26069.0,26085.0,26097.0,26105.0,26119.0,26121.0,26125.0,26129.0,26133.0,26139.0,26143.0,26145.0,26151.0,26153.0,27017.0,27035.0,27037.0,27043.0,27049.0,27059.0,27065.0,27101.0,27103.0,27113.0,27149.0,27161.0,27167.0,29001.0,29009.0,29013.0,29015.0,29025.0,29027.0,29029.0,29035.0,29045.0,29059.0,29071.0,29095.0,29111.0,29113.0,29149.0,29167.0,29215.0,28011.0,28021.0,28029.0,28031.0,28041.0,28045.0,28059.0,28069.0,28073.0,28089.0,28091.0,28099.0,28105.0,28107.0,28109.0,28147.0,28153.0,28161.0,30005.0,30007.0,30025.0,30055.0,30073.0,30103.0,37015.0,37017.0,37043.0,37061.0,37073.0,37081.0,37103.0,37127.0,37129.0,37133.0,37135.0,37155.0,37183.0,37187.0,38011.0,38057.0,38059.0,38065.0,31003.0,31005.0,31017.0,31027.0,31031.0,31033.0,31035.0,31043.0,31077.0,31081.0,31083.0,31085.0,31091.0,31095.0,31099.0,31113.0,31119.0,31127.0,31137.0,31149.0,31169.0,31175.0,31183.0,33013.0,33019.0,34001.0,34009.0,35011.0,35017.0,35035.0,35041.0,35061.0,32510.0,32001.0,32003.0,32007.0,32027.0,36011.0,36021.0,36027.0,36055.0,36067.0,36073.0,36081.0,36107.0,39007.0,39009.0,39053.0,39055.0,39057.0,39059.0,39083.0,39093.0,39105.0,39109.0,39125.0,39153.0,39169.0,40029.0,40039.0,40043.0,40055.0,40061.0,40063.0,40083.0,40087.0,40101.0,40111.0,40115.0,40117.0,40131.0,40135.0,40139.0,40153.0,41003.0,41021.0,41027.0,41033.0,41053.0,42001.0,42007.0,42017.0,42023.0,42043.0,42053.0,42055.0,42059.0,42063.0,42065.0,42081.0,42083.0,42099.0,42109.0,42111.0,42117.0,42119.0,45009.0,45019.0,45067.0,46003.0,46011.0,46015.0,46031.0,46037.0,46059.0,46069.0,46083.0,46093.0,47009.0,47039.0,47051.0,47061.0,47069.0,47081.0,47083.0,47085.0,47127.0,47131.0,47139.0,47153.0,47181.0,48033.0,48035.0,48075.0,48083.0,48121.0,48123.0,48133.0,48137.0,48169.0,48173.0,48191.0,48235.0,48237.0,48251.0,48259.0,48269.0,48303.0,48305.0,48313.0,48325.0,48331.0,48339.0,48361.0,48363.0,48387.0,48393.0,48399.0,48417.0,48421.0,48423.0,48447.0,48479.0,48487.0,48501.0,49005.0,49009.0,49031.0,49037.0,49039.0,49043.0,49045.0,49049.0,51017.0,51023.0,51043.0,51595.0,51061.0,51620.0,51640.0,51075.0,51650.0,51091.0,51095.0,51109.0,51133.0,51145.0,51149.0,51159.0,51760.0,51171.0,51179.0,51790.0,51810.0,50005.0,50027.0,53015.0,53021.0,53025.0,53035.0,53045.0,55009.0,55013.0,55017.0,55023.0,55037.0,55057.0,55069.0,55089.0,55095.0,55101.0,55121.0,55123.0,55139.0,54005.0,54021.0,54033.0,54045.0,54081.0,54083.0,54085.0,56005.0]},"kind":"numeric","n":3141,"n_null":0,"n_unique":3141,"null_rate":0.0,"stats":{"iqr":26902.0,"kurtosis":-1.0978360049404827,"max":56045.0,"mean":30388.58452722063,"median":29177.0,"min":1001.0,"n_outliers":0,"outlier_rate":0.0,"q1":18179.0,"q3":45081.0,"skew":-0.08027041147943022,"std":15162.375609928777,"zero_rate":0.0}}],"insights":{"errors":[],"insights":[{"confidence":"high","critiques":[],"evidence_keys":["per_gop.stats.median","per_dem.stats.median","total_votes.stats.max","total_votes.stats.median","state_abbr.stats.top_value","row_count","per_gop.stats.skew","votes_dem.stats.n_outliers"],"featured_charts":[{"caption":"Look for the strong rightward skew showing most counties voted heavily Republican, with a long left tail of Democratic-leaning counties.","column":"per_gop","kind":"histogram"},{"caption":"Compare against the GOP histogram \u2014 the Democratic distribution clusters below 40%, highlighting how few counties lean Democrat at the county level.","column":"per_dem","kind":"histogram"},{"caption":"Texas dominates with 254 counties; this chart reveals which states contribute the most county-level records and thus the most weight in any aggregation.","column":"state_abbr","kind":"bar"},{"caption":"The extreme right skew (max 2.65M vs median 11,144) shows a handful of populous counties vastly outvote the typical county.","column":"total_votes","kind":"histogram"},{"caption":"Washington County appears 30 times across different states \u2014 check for common county names that could cause confusion in county-level joins or lookups.","column":"county_name","kind":"bar"}],"model":"anthropic:default","narrative":"This dataset captures 2016 US presidential election results at the county level, covering all 3,141 counties across 51 state/territory abbreviations. The most striking pattern is the strong Republican lean in the median county: the median GOP vote share is 66.5% versus 28.6% for Democrats, though total votes are heavily right-skewed \u2014 a small number of large urban counties (max 2.65 million votes) dominate raw vote totals while most counties are small. The per-point difference column shows values ranging widely (e.g., 63% margins appear in the top values), suggesting many counties were not competitive at all. Texas leads with 254 counties, making state-level aggregation worth examining to see which states drive the most records and volume.","scope":"dataset","target":"__global__"},{"confidence":"medium","critiques":[],"evidence_keys":["top_values","allcaps_rate","one_word_rate","n","n_unique","duplicate_rate","len_mean","len_min","len_max","null_rate"],"model":"anthropic:default","narrative":"This column contains formatted numeric values (integers with comma thousand-separators) stored as text, representing some kind of difference or delta metric \u2014 likely a count differential. Despite being classified as text, all 3,141 values are single tokens with a mean length of 4.9 characters and 99.2% 'all-caps' rate (a quirk of how digit strings are scored by the profiler). The dominant value '37,410' appears 29 times \u2014 roughly 7\u00d7 more frequent than any other value \u2014 which is a notable outlier in the frequency distribution and may warrant investigation for data entry repetition or a sentinel/default value.","role":"feature","scope":"column","target":"diff","treatment":"Strip commas, cast to integer, investigate the 29 occurrences of '37,410' as a potential sentinel before modelling."},{"confidence":"high","critiques":[],"evidence_keys":["column","kind","n","n_unique","duplicate_rate","n_duplicates","allcaps_rate","one_word_rate","len_min","len_max","len_mean","top_values"],"model":"anthropic:default","narrative":"This column stores percentage values representing a per-point differential (likely a margin or rate metric), encoded as strings with a '%' suffix rather than as numeric floats \u2014 all 3,141 values are single uppercase tokens between 5 and 6 characters long. The allcaps_rate of 1.0 is a classifier artifact from the '%' symbol, not actual uppercase text. Surprisingly, 18.7% of rows (586) are duplicates, with '15.17%' alone appearing 31 times, suggesting repeated measurements or grouped records sharing the same differential. The column should be numeric but was ingested as text.","role":"feature","scope":"column","target":"per_point_diff","treatment":"Strip '%' suffix and cast to float before modelling; investigate the 31 occurrences of '15.17%' for data quality or grouping issues."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","duplicate_rate","n_duplicates","top_values","top_words"],"model":"anthropic:default","narrative":"This column contains US county (and equivalent) names, covering all 3,141 US counties/county-equivalents with zero nulls \u2014 a near-complete national roster. The 41.2% duplicate rate (1,293 duplicates across 1,848 unique values) is expected and not anomalous: common names like 'Washington County' appear 30 times and 'Jefferson County' 25 times because the same county name exists across multiple states. Notably, 'Alaska' appears 29 times as a bare state name rather than a borough/census area name, which may signal inconsistent formatting for Alaska's county-equivalents. The word 'parish' (64 occurrences) and 'city' (43 occurrences) confirm Louisiana parishes and independent cities are included alongside standard counties.","role":"label","scope":"column","target":"county_name","treatment":"Use as a grouping/join key paired with state to ensure uniqueness; investigate and standardize the 29 'Alaska' bare-state entries before aggregation."},{"confidence":"high","critiques":[],"evidence_keys":["stats.min","stats.max","stats.mean","stats.median","stats.skew","stats.kurtosis","stats.std","stats.iqr","stats.q1","stats.q3","stats.n_outliers","stats.outlier_rate","alerts"],"model":"anthropic:default","narrative":"This column represents the total vote count for records in the dataset, with values ranging from 64 to 2,652,072. The distribution is severely right-skewed (skew = 8.89, kurtosis = 136.17): the median is only 11,144 while the mean is 43,637, indicating a long upper tail driven by 442 outliers (14.1% of rows) far above the IQR ceiling of ~29,799. The spread (std = 114,568) is more than 2.5\u00d7 the mean, confirming that a small number of items attract disproportionately large vote counts.","role":"feature","scope":"column","target":"total_votes","treatment":"Log-transform before modelling to compress the extreme right tail and reduce outlier leverage."},{"confidence":"high","critiques":[],"evidence_keys":["column","n","stats.skew","stats.kurtosis","stats.median","stats.mean","stats.max","stats.min","stats.n_outliers","stats.outlier_rate","alerts"],"model":"anthropic:default","narrative":"This column represents Democratic vote counts at the county level (n=3141 matches the number of U.S. counties), recording raw votes received per county in an election. The distribution is extremely right-skewed (skew=11.65, kurtosis=224.36): the median is only 3,194 but the mean is 20,734 and the max reaches 1,893,770, reflecting the enormous disparity between rural and urban counties. Nearly 15% of rows (468) are flagged as outliers, driven by large metropolitan counties. The min of 4 votes is plausible for the least-populated counties.","role":"feature","scope":"column","target":"votes_dem","treatment":"Log-transform (log1p) before regression or clustering to reduce skew; consider deriving vote share alongside raw count."},{"confidence":"high","critiques":[],"evidence_keys":["column","n","stats.skew","stats.kurtosis","stats.median","stats.mean","stats.max","stats.min","stats.iqr","stats.n_outliers","stats.outlier_rate","alerts"],"model":"anthropic:default","narrative":"This column records the raw count of Republican (GOP) votes per geographic unit, almost certainly at the U.S. county level given n=3141 (matching the ~3,143 U.S. counties). The distribution is extremely right-skewed (skew=5.78, kurtosis=51.78): the median is only 7,268 yet the mean is 20,645 and the max reaches 620,285, reflecting the massive population disparity between rural and urban/suburban counties. A notable 12.5% of rows (394) are flagged as outliers, corresponding to the largest-population counties that dwarf the typical small rural county.","role":"feature","scope":"column","target":"votes_gop","treatment":"Log-transform (log1p) before any regression or distance-based modelling to reduce skew; consider per-capita or vote-share normalisation if comparing across counties."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","min","max","mean","median","skew","kurtosis","n_outliers","zero_rate"],"model":"anthropic:default","narrative":"This column is almost certainly a row index or sequential integer ID, running from 0 to 3140 with every value unique and no nulls. The distribution is perfectly uniform: mean equals median at 1570.0, skew is exactly 0.0, kurtosis is \u20131.2 (consistent with a flat/uniform distribution), and there are zero outliers. The single surprising note is that zero_rate is non-zero (one zero present), which is simply the first index value (0) rather than a missing-data signal.","role":"identifier","scope":"column","target":"","treatment":"Drop before modelling; if row order matters, retain as an explicit sort key only."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","min","max","skew","kurtosis","zero_rate"],"model":"anthropic:default","narrative":"This column contains US county-level FIPS codes, 5-digit numeric identifiers where the first 2 digits encode the state and the last 3 encode the county. The column is perfectly unique across all 3,141 rows with zero nulls \u2014 matching exactly the canonical count of US counties and county-equivalents, confirming this is a complete national county dataset. The near-zero skew (\u22120.08) and platykurtic distribution (kurtosis \u22121.10) indicate values are spread broadly and fairly uniformly across the numeric range, which is expected since FIPS codes are administratively assigned rather than naturally distributed. Despite being stored as numeric, FIPS codes are identifiers and must not be treated as continuous values.","role":"identifier","scope":"column","target":"combined_fips","treatment":"Cast to zero-padded 5-character string and use as a join key; never use as a numeric feature."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.min","stats.max","stats.mean","stats.median","stats.skew","stats.q1","stats.q3"],"model":"anthropic:default","narrative":"This column almost certainly represents the Democratic party vote share (proportion) at the county level \u2014 the 3,141 rows match the number of U.S. counties exactly, and values are bounded between 0.031 and 0.928 with a mean of 0.318 and median of 0.286, consistent with Democratic vote shares skewing below 50% across most counties. The positive skew (0.942) reflects a long right tail of heavily Democratic urban counties pulling the mean above the median, while the bulk of counties are Republican-leaning. Near-uniqueness (3,112 of 3,141 values distinct) and zero null rate confirm clean, continuous proportional data with no structural issues.","role":"numeric_target","scope":"column","target":"per_dem","treatment":"Use directly as a regression target or feature; consider logit-transform (log-odds) to map the bounded [0,1] proportion to an unbounded scale before modelling."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","min","max","mean","median","skew","iqr","n_outliers","outlier_rate","null_rate"],"model":"anthropic:default","narrative":"This column represents the Republican (GOP) vote share as a proportion (0\u20131 scale), almost certainly at the U.S. county level given n=3141, which closely matches the total number of U.S. counties. The distribution is left-skewed (skew = -0.82) with a median of 0.665, indicating most counties lean Republican \u2014 a well-known feature of county-level electoral geography where rural counties are numerous and heavily GOP. The range (0.041 to 0.953) is plausible for partisan vote shares, and 63 outliers (2%) likely correspond to heavily urban or heavily rural counties at the extremes.","role":"numeric_target","scope":"column","target":"per_gop","treatment":"Use directly as a regression target or feature; consider logit-transforming the proportion to unbound it from [0,1] for linear models."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","top_value","top_rate","entropy_ratio","top_values"],"model":"anthropic:default","narrative":"This column contains US state abbreviations covering all 51 values (50 states + DC), with zero nulls across 3,141 rows \u2014 consistent with a county-level dataset where n\u22483,141 matches the known US county count. TX dominates with 254 rows (8.09% of records), aligning exactly with Texas's 254 counties, confirming county-level granularity. The entropy ratio of 0.93 indicates near-uniform distribution across states, which is expected given that state representation is proportional to county count rather than population.","role":"label","scope":"column","target":"state_abbr","treatment":"Use as a grouping/aggregation key for state-level rollups; one-hot encode or target-encode if used as a model feature."}],"providers":["anthropic:default"],"total_usage":{"completion_tokens":3630,"prompt_tokens":11838,"total_tokens":15468}},"language_counts":{},"meta":{"generated_at":"2026-06-21T23:59:28+00:00","mode":"full","row_count":3141,"sampled_rows":3141,"seed":42,"source":"/home/coolhand/html/datavis/data_trove/geographic/election/2016_election.csv"},"notes":[],"saturn_version":"0.2.0","schema":{"":"numeric","combined_fips":"numeric","county_name":"text","diff":"text","per_dem":"numeric","per_gop":"numeric","per_point_diff":"text","state_abbr":"categorical","total_votes":"numeric","votes_dem":"numeric","votes_gop":"numeric"}}