{"columns":[{"alerts":[{"code":"near_unique","level":"info","message":"100.0% of rows are unique strings"}],"column":"NAME","extras":{"language_counts":{},"language_sample_size":3144,"length_histogram":{"counts":[26,72,121,190,264,407,420,363,320,240,230,142,126,133,35,23,12,6,2,0,1,1,0,1,1,0,2,0,1,1,0,0,0,0,2,1,0,0,0,1],"edges":[16.0,17.075,18.15,19.225,20.3,21.375,22.45,23.525,24.6,25.674999999999997,26.75,27.825,28.9,29.975,31.049999999999997,32.125,33.2,34.275,35.349999999999994,36.425,37.5,38.575,39.65,40.724999999999994,41.8,42.875,43.95,45.025,46.099999999999994,47.175,48.25,49.324999999999996,50.4,51.475,52.55,53.625,54.699999999999996,55.775,56.85,57.925,59.0]},"near_unique":true,"sample":["Bibb County, Alabama","Day County, South Dakota","Sabine County, Texas","Fayette County, Texas","Chisago County, Minnesota","Dane County, Wisconsin","Ramsey County, Minnesota","Bath County, Virginia","Freestone County, Texas","Carroll County, Arkansas","Carteret County, North Carolina","Cedar County, Nebraska","Taylor County, Iowa","Dallas County, Alabama","Gove County, Kansas","Lemhi County, Idaho","Phillips County, Colorado","Jackson County, Texas","Big Horn County, Wyoming","Ionia County, Michigan","Reno County, Kansas","Fulton County, Arkansas","Spalding County, Georgia","South Central Connecticut Planning Region, Connecticut","Texas County, Oklahoma","Oglala Lakota County, South Dakota","Thurston County, Nebraska","Calhoun County, Illinois","Yolo County, California","Calumet County, Wisconsin","Erie County, Ohio","Lake County, Ohio","Greene County, Alabama","Antrim County, Michigan","Lincoln Parish, Louisiana","Polk County, Minnesota","Staunton city, Virginia","Cascade County, Montana","Chickasaw County, Mississippi","Cass County, Nebraska","Comanche County, Texas","Wise County, Virginia","Worth County, Iowa","Tazewell County, Virginia","Grant County, West Virginia","Green County, Wisconsin","Robertson County, Kentucky","Calhoun County, Michigan","Taylor County, Georgia","Box Elder County, Utah"],"top_values":[],"top_words":[["county,",2999],["texas",256],["virginia",189],["georgia",159],["north",155],["carolina",146],["new",131],["dakota",121],["kentucky",120],["missouri",115],["south",113],["kansas",105],["illinois",102],["iowa",101],["tennessee",95],["indiana",93],["nebraska",93],["ohio",91],["minnesota",87],["mississippi",84],["michigan",83],["oklahoma",78],["arkansas",76],["wisconsin",72],["washington",70]],"vocab_skipped":null,"word_histogram":{"counts":[2492,0,0,0,0,0,0,606,0,0,0,0,0,0,0,40,0,0,0,0,0,0,5,0,0,0,0,0,0,1],"edges":[3.0,3.1333333333333333,3.2666666666666666,3.4,3.533333333333333,3.6666666666666665,3.8,3.9333333333333336,4.066666666666666,4.2,4.333333333333333,4.466666666666667,4.6,4.733333333333333,4.866666666666667,5.0,5.133333333333333,5.266666666666667,5.4,5.533333333333333,5.666666666666666,5.8,5.933333333333334,6.066666666666666,6.2,6.333333333333334,6.466666666666667,6.6,6.733333333333333,6.866666666666667,7.0]}},"kind":"text","n":3144,"n_null":0,"n_unique":3144,"null_rate":0.0,"stats":{"allcaps_rate":0.0,"boilerplate_rate":0.0,"duplicate_rate":0.0,"emoji_rate":0.0,"len_max":59,"len_mean":24.164758269720103,"len_median":24.0,"len_min":16,"len_p95":30.84999999999991,"n_duplicates":0,"n_empty":0,"one_word_rate":0.0,"readability_flesch_mean":6.826000000000029,"url_rate":0.0,"vocab_size":1910,"word_mean":3.224236641221374,"word_median":3.0}},{"alerts":[{"code":"high_skew","level":"info","message":"skew=+13.14"},{"code":"outliers","level":"warn","message":"14.3% rows beyond 1.5 IQR"}],"column":"B23025_002E","extras":{"histogram":{"counts":[2867,135,52,41,14,10,5,5,4,2,3,0,1,1,0,0,0,1,1,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1],"edges":[36.0,131056.15,262076.3,393096.44999999995,524116.6,655136.75,786156.8999999999,917177.0499999999,1048197.2,1179217.3499999999,1310237.5,1441257.65,1572277.7999999998,1703297.95,1834318.0999999999,1965338.25,2096358.4,2227378.55,2358398.6999999997,2489418.85,2620439.0,2751459.15,2882479.3,3013499.4499999997,3144519.5999999996,3275539.75,3406559.9,3537580.05,3668600.1999999997,3799620.3499999996,3930640.5,4061660.65,4192680.8,4323700.95,4454721.1,4585741.25,4716761.399999999,4847781.55,4978801.7,5109821.85,5240842.0]},"sample":[26546.0,5492.0,14005.0,4036.0,14525.0,8905.0,25598.0,27363.0,10242.0,842.0,50405.0,2668.0,4277.0,85563.0,1808.0,3717.0,60755.0,4331.0,3023.0,199455.0,5692.0,16920.0,5240842.0,137001.0,1156633.0,139676.0,422158.0,258395.0,22727.0,36560.0,8171.0,6296.0,1520.0,186545.0,9314.0,2152.0,14539.0,2674.0,335292.0,436.0,5655.0,2996.0,149787.0,306513.0,109570.0,4691.0,5740.0,17217.0,7850.0,37916.0,67621.0,6412.0,45058.0,742370.0,485326.0,30279.0,7175.0,15928.0,23209.0,39470.0,26922.0,155714.0,146789.0,148467.0,14352.0,37515.0,1940.0,32968.0,10094.0,10563.0,7805.0,504118.0,14709.0,4175.0,6537.0,3092.0,3520.0,2988.0,10149.0,56590.0,2651.0,30176.0,1568.0,698.0,22520.0,10004.0,32500.0,1090.0,3064.0,4090.0,96264.0,1071.0,84138.0,34647.0,7161.0,7508.0,8568.0,9960.0,88770.0,136721.0,6746.0,7921.0,131014.0,10626.0,42485.0,4236.0,8177.0,43570.0,19272.0,18459.0,22147.0,75034.0,9662.0,12668.0,17244.0,11418.0,7785.0,14946.0,13746.0,17896.0,7093.0,10016.0,53568.0,5697.0,3603.0,4806.0,17201.0,20712.0,4979.0,47569.0,91173.0,5945.0,12029.0,11185.0,5954.0,3649.0,6762.0,1180.0,1404.0,956.0,20354.0,1376.0,1247.0,2287.0,6553.0,803.0,1440.0,17605.0,17665.0,2723.0,14408.0,5214.0,2416.0,30675.0,4553.0,3345.0,28708.0,268532.0,1772.0,3405.0,4043.0,20545.0,4939.0,5700.0,2005.0,8367.0,7232.0,3715.0,3422.0,3272.0,4562.0,12840.0,14178.0,24845.0,3133.0,13346.0,13717.0,3146.0,10285.0,19980.0,13772.0,13657.0,20236.0,19974.0,23632.0,16808.0,90903.0,151328.0,74982.0,67776.0,82172.0,11223.0,64051.0,189600.0,6486.0,21116.0,150992.0,835.0,102703.0,33047.0,30088.0,3389.0,83358.0,693106.0,2159.0,12456.0,159621.0,5052.0,8616.0,79382.0,13866.0,2967.0,32580.0,11793.0,11131.0,10191.0,20490.0,17401.0,20141.0,90021.0,19815.0,11438.0,146353.0,4897.0,4093.0,11920.0,5934.0,2851.0,6689.0,7798.0,7606.0,3713.0,206.0,29135.0,9941.0,24581.0,5536.0,10797.0,139675.0,2891.0,2814.0,16876.0,4053.0,1674.0,16515.0,16133.0,6881.0,4566.0,3660.0,6787.0,3169.0,19959.0,14519.0,29390.0,2156.0,4894.0,26892.0,17983.0,17081.0,4731.0,5576.0,4373.0,8057.0,1999.0,2215.0,5463.0,877.0,5345.0,3039.0,723.0,32201.0,4167.0,1737.0,3486.0,8430.0,1147.0,107081.0,1801.0,368.0,18500.0,446417.0,406796.0,462495.0,1715.0,33354.0,29547.0,71410.0,75828.0,3731.0,5372.0,31617.0,20380.0,30338.0,22573.0,1360477.0,12611.0,394251.0,57662.0,18990.0,86096.0,81403.0,37164.0,86730.0,4643.0,6739.0,32242.0,36508.0,12014.0,20068.0,23128.0,112595.0,633754.0,47203.0,19475.0,8943.0,70023.0,46705.0,6221.0,56605.0,1061.0,431.0,42246.0,868.0,6867.0,4554.0,1384.0,440.0,17251.0,25676.0,45608.0,21367.0,49669.0,86024.0,29984.0,22547.0,99319.0,22295.0,19724.0,187930.0,28540.0,157719.0,32429.0,16969.0,2062.0,1455.0,4571.0,14928.0,6580.0,27885.0,405835.0,20331.0,12857.0,48796.0,9165.0,18533.0,9967.0,50013.0,46545.0,3324.0,10907.0,42900.0,52214.0,31838.0,356988.0,60874.0,137541.0,58602.0,78598.0,15007.0,19332.0,21070.0,163459.0,18574.0,43524.0,68315.0,34555.0,17864.0,17480.0,98585.0,6674.0,151720.0,149335.0,2718.0,2747.0,1573.0,10608.0,3069.0,734.0,37763.0,2241.0,68049.0,415789.0,7625.0,30939.0,2427.0,10946.0,3445.0,8716.0,112944.0,14085.0,7949.0,6610.0,66727.0,284.0,8021.0,3123.0,3596.0,522842.0,8114.0,79446.0,177978.0,469.0,1261.0,9670.0,3367.0,15849.0,22504.0,2117.0,39.0,161613.0,2606.0,22936.0,11616.0,315187.0,40613.0,13216.0,4521.0,400.0,4602.0,1618.0,1179.0,114887.0,5241.0,118758.0,6058.0,69288.0,270.0,636.0,5946.0,12869.0,23510.0,38503.0,338510.0,6838.0,196944.0,7730.0,14220.0,7871.0,47222.0,11991.0,59476.0,37209.0,9638.0,3601.0,15631.0,8219.0,8344.0,83690.0,20771.0,132221.0,2349.0,13682.0,73149.0,6529.0,15427.0,49680.0,46258.0,45932.0,139740.0,28030.0,117553.0,10207.0,3125.0,2548.0,29868.0,12451.0,19881.0,3836.0,3164.0,10151.0,5447.0,29651.0,55260.0,48833.0,12851.0,9405.0,41572.0,50112.0,3703.0,23250.0,38982.0,6341.0,8255.0,8360.0,20477.0,62849.0,26881.0,5312.0,3493.0,15480.0]},"kind":"numeric","n":3144,"n_null":0,"n_unique":3028,"null_rate":0.0,"stats":{"iqr":27868.0,"kurtosis":288.5713634905983,"max":5240842.0,"mean":53782.946882951655,"median":11698.0,"min":36.0,"n_outliers":449,"outlier_rate":0.1428117048346056,"q1":4721.75,"q3":32589.75,"skew":13.137533107620813,"std":176262.59205072882,"zero_rate":0.0}},{"alerts":[{"code":"high_skew","level":"info","message":"skew=+8.01"},{"code":"outliers","level":"warn","message":"13.0% rows beyond 1.5 IQR"}],"column":"B21001_002E","extras":{"histogram":{"counts":[2534,271,116,68,49,30,18,20,7,3,4,6,0,6,2,1,0,1,1,0,0,0,1,2,0,1,0,0,0,0,0,1,0,0,0,0,0,1,0,1],"edges":[0.0,6104.0,12208.0,18312.0,24416.0,30520.0,36624.0,42728.0,48832.0,54936.0,61040.0,67144.0,73248.0,79352.0,85456.0,91560.0,97664.0,103768.0,109872.0,115976.0,122080.0,128184.0,134288.0,140392.0,146496.0,152600.0,158704.0,164808.0,170912.0,177016.0,183120.0,189224.0,195328.0,201432.0,207536.0,213640.0,219744.0,225848.0,231952.0,238056.0,244160.0]},"sample":[3227.0,519.0,1184.0,457.0,1960.0,1031.0,5728.0,3194.0,1267.0,174.0,10934.0,424.0,470.0,14100.0,202.0,318.0,5692.0,847.0,699.0,25779.0,1275.0,4000.0,230282.0,8624.0,112052.0,16832.0,20300.0,18669.0,5201.0,5232.0,649.0,1109.0,163.0,12548.0,1212.0,436.0,2380.0,716.0,33858.0,76.0,562.0,417.0,19946.0,28398.0,17956.0,992.0,1499.0,2521.0,1352.0,9524.0,14595.0,1300.0,5848.0,70761.0,72273.0,18317.0,1607.0,2698.0,4223.0,3468.0,6250.0,21455.0,15356.0,15716.0,1587.0,6091.0,140.0,5550.0,1083.0,2216.0,1310.0,39776.0,1654.0,414.0,974.0,381.0,484.0,582.0,888.0,7175.0,190.0,4696.0,384.0,155.0,2537.0,2433.0,3689.0,69.0,272.0,467.0,12964.0,221.0,13999.0,4233.0,1284.0,887.0,1263.0,915.0,8022.0,17514.0,942.0,1077.0,23588.0,1455.0,3735.0,452.0,1066.0,4603.0,2625.0,1028.0,3335.0,5719.0,1084.0,1431.0,2832.0,1448.0,939.0,1714.0,1697.0,2045.0,810.0,1355.0,5164.0,640.0,402.0,552.0,1905.0,2868.0,671.0,6375.0,10416.0,803.0,1249.0,1143.0,769.0,370.0,888.0,165.0,237.0,178.0,1746.0,125.0,114.0,329.0,1151.0,143.0,119.0,1643.0,2182.0,349.0,1707.0,482.0,285.0,3030.0,677.0,529.0,3726.0,28473.0,311.0,512.0,535.0,3335.0,688.0,690.0,382.0,1054.0,975.0,307.0,352.0,224.0,476.0,1354.0,1493.0,1820.0,399.0,1062.0,1684.0,467.0,1221.0,1997.0,1967.0,1105.0,2821.0,3254.0,4626.0,1731.0,16942.0,16201.0,8855.0,6774.0,7372.0,1908.0,8156.0,22192.0,1346.0,2885.0,11338.0,280.0,10218.0,4930.0,4287.0,917.0,10494.0,48275.0,780.0,2094.0,11790.0,1331.0,2346.0,9628.0,1229.0,343.0,4717.0,937.0,1199.0,1000.0,3499.0,2337.0,2293.0,7872.0,2064.0,1263.0,12404.0,544.0,555.0,901.0,393.0,301.0,781.0,947.0,810.0,830.0,27.0,3018.0,1232.0,3489.0,360.0,864.0,13907.0,409.0,757.0,2965.0,656.0,267.0,2519.0,2147.0,861.0,499.0,711.0,735.0,678.0,3178.0,1899.0,5660.0,311.0,793.0,3994.0,2852.0,3176.0,700.0,484.0,835.0,2267.0,246.0,506.0,517.0,159.0,640.0,370.0,171.0,2734.0,537.0,222.0,432.0,1152.0,182.0,18063.0,226.0,51.0,7057.0,17928.0,11099.0,22600.0,248.0,1851.0,7558.0,11376.0,9388.0,1388.0,1140.0,6193.0,3098.0,3543.0,3095.0,33841.0,1727.0,31359.0,6372.0,2747.0,8755.0,7267.0,3760.0,9395.0,767.0,969.0,6956.0,4385.0,3090.0,2782.0,6301.0,14475.0,47522.0,9257.0,2341.0,1486.0,7913.0,5828.0,695.0,10315.0,126.0,61.0,4433.0,92.0,515.0,432.0,225.0,27.0,1561.0,2779.0,7015.0,2364.0,4952.0,15077.0,4025.0,2733.0,9835.0,1980.0,2940.0,21951.0,4468.0,21708.0,4707.0,2919.0,381.0,205.0,846.0,2578.0,1725.0,4552.0,49268.0,3068.0,1955.0,7062.0,1611.0,3110.0,1054.0,4798.0,12474.0,450.0,1523.0,6074.0,7510.0,4631.0,30322.0,9731.0,17521.0,7952.0,10902.0,2519.0,3347.0,2994.0,19168.0,2627.0,6261.0,8725.0,5045.0,2909.0,2326.0,13102.0,1080.0,21991.0,17586.0,451.0,215.0,219.0,1227.0,299.0,65.0,2784.0,246.0,9632.0,26782.0,1348.0,4589.0,292.0,1893.0,698.0,1244.0,29129.0,1630.0,955.0,1215.0,10529.0,34.0,1239.0,212.0,522.0,42505.0,1312.0,5165.0,21385.0,23.0,137.0,1163.0,492.0,1656.0,3297.0,302.0,1.0,13021.0,244.0,4462.0,1381.0,33437.0,4543.0,1869.0,822.0,89.0,529.0,215.0,124.0,10841.0,384.0,4941.0,786.0,3627.0,21.0,85.0,597.0,1081.0,1553.0,3797.0,14944.0,1229.0,25892.0,1280.0,2226.0,1054.0,6716.0,1697.0,7212.0,9223.0,1568.0,852.0,2598.0,1143.0,1769.0,19956.0,2893.0,28497.0,286.0,1494.0,18316.0,1548.0,1316.0,8628.0,3962.0,4960.0,31176.0,7470.0,13011.0,1528.0,586.0,383.0,4704.0,1928.0,2631.0,972.0,544.0,1459.0,804.0,2557.0,5917.0,4601.0,2153.0,1540.0,5608.0,3946.0,433.0,3152.0,4230.0,1214.0,1013.0,1366.0,2517.0,6151.0,3571.0,787.0,685.0,651.0]},"kind":"numeric","n":3144,"n_null":0,"n_unique":2424,"null_rate":0.0,"stats":{"iqr":3793.0,"kurtosis":100.02206986933047,"max":244160.0,"mean":5419.467875318066,"median":1547.5,"min":0.0,"n_outliers":408,"outlier_rate":0.1297709923664122,"q1":634.75,"q3":4427.75,"skew":8.014443478280167,"std":13105.415315535329,"zero_rate":0.0003180661577608143}},{"alerts":[{"code":"high_skew","level":"info","message":"skew=+13.17"},{"code":"outliers","level":"warn","message":"14.0% rows beyond 1.5 IQR"}],"column":"B01003_001E","extras":{"histogram":{"counts":[2863,137,57,37,14,10,7,3,3,4,3,0,1,1,0,0,0,1,0,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1],"edges":[50.0,248466.0,496882.0,745298.0,993714.0,1242130.0,1490546.0,1738962.0,1987378.0,2235794.0,2484210.0,2732626.0,2981042.0,3229458.0,3477874.0,3726290.0,3974706.0,4223122.0,4471538.0,4719954.0,4968370.0,5216786.0,5465202.0,5713618.0,5962034.0,6210450.0,6458866.0,6707282.0,6955698.0,7204114.0,7452530.0,7700946.0,7949362.0,8197778.0,8446194.0,8694610.0,8943026.0,9191442.0,9439858.0,9688274.0,9936690.0]},"sample":[57270.0,13205.0,32011.0,10153.0,32997.0,22179.0,58849.0,64978.0,23655.0,2079.0,108661.0,5355.0,9483.0,204374.0,4773.0,10234.0,124611.0,12183.0,7243.0,398322.0,15900.0,40577.0,9936690.0,260485.0,2429487.0,281712.0,754250.0,552063.0,54993.0,81705.0,16460.0,13509.0,3496.0,328658.0,19564.0,4885.0,26457.0,6896.0,580519.0,794.0,11442.0,6454.0,280293.0,570567.0,240668.0,13753.0,16737.0,43746.0,18070.0,102339.0,160986.0,14458.0,82044.0,1494805.0,959918.0,131832.0,21421.0,33732.0,44995.0,79829.0,55105.0,296266.0,268567.0,296312.0,27355.0,85038.0,3707.0,65314.0,22907.0,25436.0,19020.0,957977.0,30178.0,9487.0,15591.0,8704.0,9225.0,7508.0,20171.0,113298.0,6365.0,67415.0,5121.0,1635.0,45665.0,24880.0,68065.0,2354.0,8839.0,9610.0,202163.0,2605.0,173396.0,65583.0,15594.0,15467.0,18729.0,19714.0,171284.0,265512.0,14776.0,15716.0,256791.0,21042.0,82371.0,8709.0,16468.0,80170.0,39684.0,40364.0,45113.0,140065.0,19768.0,25226.0,36942.0,24403.0,15328.0,31032.0,28133.0,34259.0,14046.0,18479.0,98812.0,10790.0,6969.0,10026.0,33487.0,40049.0,10285.0,93543.0,174315.0,12107.0,22534.0,20050.0,12897.0,7799.0,14405.0,2570.0,3389.0,1977.0,39012.0,2771.0,2430.0,5457.0,13274.0,1528.0,2752.0,32182.0,34312.0,5829.0,31448.0,10219.0,4960.0,61881.0,9441.0,6702.0,54160.0,522700.0,3561.0,6922.0,8667.0,48242.0,12365.0,12635.0,7378.0,26589.0,15731.0,10468.0,11647.0,11298.0,10313.0,26056.0,36648.0,57674.0,8895.0,30210.0,32277.0,10028.0,25438.0,41986.0,36761.0,27377.0,40729.0,36868.0,50656.0,33320.0,167035.0,273829.0,154645.0,128763.0,153931.0,23662.0,134011.0,405280.0,14597.0,45698.0,282540.0,2088.0,194302.0,66376.0,66901.0,9261.0,175947.0,1272264.0,5862.0,25221.0,296183.0,13083.0,23556.0,160257.0,25880.0,5611.0,66558.0,20893.0,21251.0,18826.0,45054.0,34023.0,40082.0,162307.0,37396.0,21460.0,268651.0,9569.0,12683.0,30688.0,13193.0,9044.0,15553.0,18598.0,18323.0,13672.0,1206.0,67152.0,24362.0,56351.0,13888.0,25299.0,253085.0,6219.0,8452.0,39960.0,9538.0,3772.0,36060.0,32858.0,15173.0,12305.0,8668.0,13374.0,8688.0,44843.0,31877.0,53726.0,4698.0,10356.0,56202.0,35729.0,39265.0,9469.0,13090.0,9435.0,20157.0,4233.0,5018.0,10778.0,1767.0,10566.0,5557.0,1778.0,62575.0,8303.0,3366.0,7019.0,15995.0,2553.0,191272.0,3410.0,771.0,51698.0,853374.0,712029.0,860147.0,4160.0,73103.0,67850.0,149460.0,154481.0,11506.0,16453.0,76613.0,47459.0,58204.0,48067.0,2679620.0,26690.0,756406.0,112288.0,40148.0,160943.0,159447.0,78725.0,171779.0,10989.0,17818.0,68353.0,76754.0,28868.0,50827.0,52612.0,219042.0,1115403.0,100759.0,39131.0,19538.0,144403.0,117573.0,14130.0,117480.0,2190.0,839.0,72927.0,1849.0,14081.0,9648.0,3025.0,837.0,32989.0,52522.0,97666.0,42602.0,95455.0,167567.0,62657.0,46098.0,182347.0,42321.0,40367.0,374199.0,59639.0,295060.0,72076.0,40791.0,5531.0,3272.0,13409.0,33734.0,19159.0,66606.0,795822.0,46004.0,30472.0,95870.0,23592.0,43140.0,20411.0,95615.0,111322.0,7496.0,24659.0,87600.0,107674.0,65538.0,645163.0,133263.0,261269.0,128417.0,156084.0,35781.0,44123.0,44326.0,325396.0,40459.0,91340.0,143201.0,73802.0,38540.0,42908.0,204592.0,14145.0,295934.0,282987.0,7018.0,5247.0,3906.0,19966.0,6196.0,1319.0,65801.0,4363.0,135951.0,709786.0,18642.0,70399.0,6726.0,24996.0,8253.0,19032.0,222305.0,30670.0,17620.0,16065.0,133282.0,686.0,18404.0,6781.0,7808.0,914870.0,17812.0,162300.0,350801.0,1068.0,2847.0,20595.0,8588.0,39060.0,45376.0,4316.0,96.0,311509.0,5619.0,51432.0,25080.0,629989.0,84761.0,28569.0,11627.0,764.0,9858.0,3134.0,2414.0,234667.0,11816.0,267282.0,12795.0,134428.0,638.0,1764.0,14524.0,28816.0,42524.0,74032.0,666021.0,15965.0,366019.0,14882.0,28057.0,15532.0,92007.0,24906.0,110513.0,78818.0,17845.0,8537.0,33841.0,21536.0,18003.0,157606.0,40800.0,249377.0,5680.0,24242.0,137217.0,12479.0,28103.0,110621.0,96692.0,99145.0,275411.0,66053.0,226523.0,22349.0,7847.0,7444.0,58043.0,26957.0,42224.0,11985.0,8336.0,23875.0,14431.0,52361.0,104027.0,85932.0,26695.0,19512.0,81242.0,91745.0,7363.0,45128.0,70281.0,14066.0,17256.0,18057.0,40848.0,117741.0,51822.0,11690.0,7258.0,23346.0]},"kind":"numeric","n":3144,"n_null":0,"n_unique":3080,"null_rate":0.0,"stats":{"iqr":57244.0,"kurtosis":289.7610515191645,"max":9936690.0,"mean":105310.93924936387,"median":25784.5,"min":50.0,"n_outliers":440,"outlier_rate":0.13994910941475827,"q1":10835.75,"q3":68079.75,"skew":13.17458460267928,"std":333792.4323915976,"zero_rate":0.0}},{"alerts":[],"column":"state","extras":{"histogram":{"counts":[97,0,90,58,0,73,3,1,226,0,49,102,92,204,120,64,40,14,170,82,115,149,17,10,54,62,153,88,77,103,0,5,112,95,283,14,133,39,55,95],"edges":[1.0,2.375,3.75,5.125,6.5,7.875,9.25,10.625,12.0,13.375,14.75,16.125,17.5,18.875,20.25,21.625,23.0,24.375,25.75,27.125,28.5,29.875,31.25,32.625,34.0,35.375,36.75,38.125,39.5,40.875,42.25,43.625,45.0,46.375,47.75,49.125,50.5,51.875,53.25,54.625,56.0]},"sample":[1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,2.0,2.0,2.0,4.0,4.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,8.0,8.0,8.0,8.0,8.0,8.0,8.0,8.0,8.0,8.0,8.0,8.0,9.0,10.0,10.0,12.0,12.0,12.0,12.0,12.0,12.0,12.0,12.0,12.0,12.0,12.0,12.0,12.0,13.0,13.0,13.0,13.0,13.0,13.0,13.0,13.0,13.0,13.0,13.0,13.0,13.0,13.0,13.0,13.0,13.0,13.0,13.0,13.0,13.0,13.0,13.0,13.0,13.0,13.0,13.0,13.0,13.0,13.0,13.0,13.0,15.0,16.0,16.0,17.0,17.0,17.0,17.0,17.0,17.0,17.0,17.0,17.0,17.0,17.0,18.0,18.0,18.0,18.0,18.0,18.0,18.0,18.0,18.0,18.0,18.0,18.0,18.0,18.0,18.0,18.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,20.0,20.0,20.0,20.0,20.0,20.0,20.0,20.0,20.0,20.0,20.0,20.0,20.0,20.0,20.0,20.0,20.0,20.0,20.0,20.0,20.0,20.0,20.0,20.0,20.0,20.0,21.0,21.0,21.0,21.0,21.0,21.0,21.0,21.0,21.0,21.0,21.0,21.0,22.0,22.0,22.0,22.0,22.0,22.0,22.0,22.0,22.0,23.0,23.0,23.0,24.0,24.0,24.0,24.0,25.0,25.0,26.0,26.0,26.0,26.0,26.0,26.0,26.0,26.0,26.0,26.0,26.0,26.0,26.0,26.0,26.0,26.0,26.0,26.0,26.0,27.0,27.0,27.0,27.0,27.0,27.0,27.0,27.0,27.0,27.0,27.0,27.0,27.0,27.0,28.0,28.0,28.0,28.0,28.0,28.0,28.0,28.0,28.0,28.0,28.0,28.0,28.0,29.0,29.0,29.0,29.0,29.0,29.0,29.0,29.0,29.0,29.0,29.0,29.0,29.0,29.0,29.0,29.0,29.0,29.0,29.0,29.0,29.0,29.0,30.0,30.0,30.0,30.0,30.0,30.0,31.0,31.0,31.0,31.0,31.0,31.0,31.0,31.0,31.0,31.0,31.0,31.0,31.0,31.0,32.0,34.0,34.0,34.0,35.0,35.0,35.0,35.0,35.0,35.0,35.0,35.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,36.0,37.0,37.0,37.0,37.0,37.0,37.0,37.0,37.0,37.0,37.0,37.0,37.0,37.0,37.0,37.0,37.0,37.0,38.0,38.0,38.0,38.0,38.0,38.0,38.0,38.0,38.0,39.0,39.0,39.0,39.0,39.0,39.0,39.0,39.0,39.0,39.0,39.0,39.0,40.0,40.0,40.0,40.0,40.0,40.0,40.0,40.0,40.0,40.0,40.0,40.0,40.0,40.0,40.0,40.0,41.0,41.0,41.0,41.0,41.0,41.0,42.0,42.0,42.0,42.0,42.0,42.0,42.0,42.0,42.0,42.0,42.0,42.0,42.0,42.0,42.0,42.0,45.0,45.0,45.0,45.0,46.0,46.0,46.0,46.0,46.0,46.0,46.0,46.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,47.0,48.0,48.0,48.0,48.0,48.0,48.0,48.0,48.0,48.0,48.0,48.0,48.0,48.0,48.0,48.0,48.0,48.0,48.0,48.0,48.0,48.0,48.0,48.0,48.0,48.0,48.0,48.0,48.0,48.0,48.0,48.0,48.0,49.0,49.0,49.0,49.0,49.0,49.0,49.0,49.0,51.0,51.0,51.0,51.0,51.0,51.0,51.0,51.0,51.0,51.0,51.0,51.0,51.0,51.0,51.0,51.0,51.0,51.0,51.0,51.0,51.0,51.0,53.0,53.0,53.0,53.0,53.0,53.0,54.0,54.0,54.0,54.0,54.0,54.0,54.0,54.0,54.0,54.0,55.0,55.0,55.0,55.0,55.0,55.0,55.0,55.0,55.0,55.0,55.0,55.0,55.0,55.0,55.0,55.0,56.0,56.0,56.0]},"kind":"numeric","n":3144,"n_null":0,"n_unique":51,"null_rate":0.0,"stats":{"iqr":27.0,"kurtosis":-1.0988668415494098,"max":56.0,"mean":30.264312977099237,"median":29.0,"min":1.0,"n_outliers":0,"outlier_rate":0.0,"q1":18.0,"q3":45.0,"skew":-0.08127955680964753,"std":15.15266836395141,"zero_rate":0.0}},{"alerts":[{"code":"high_skew","level":"info","message":"skew=+2.84"},{"code":"outliers","level":"warn","message":"5.6% rows beyond 1.5 IQR"}],"column":"county","extras":{"histogram":{"counts":[512,408,399,335,341,271,225,165,140,71,45,25,22,23,22,13,11,10,11,10,11,10,11,10,7,2,1,2,3,3,2,2,5,2,3,2,3,1,2,3],"edges":[1.0,21.975,42.95,63.925000000000004,84.9,105.875,126.85000000000001,147.82500000000002,168.8,189.775,210.75,231.72500000000002,252.70000000000002,273.675,294.65000000000003,315.625,336.6,357.57500000000005,378.55,399.52500000000003,420.5,441.475,462.45000000000005,483.425,504.40000000000003,525.375,546.35,567.325,588.3000000000001,609.2750000000001,630.25,651.225,672.2,693.1750000000001,714.1500000000001,735.125,756.1,777.075,798.0500000000001,819.0250000000001,840.0]},"sample":[33.0,41.0,59.0,85.0,109.0,111.0,113.0,127.0,133.0,100.0,170.0,290.0,11.0,27.0,13.0,17.0,45.0,49.0,101.0,119.0,141.0,5.0,37.0,41.0,65.0,79.0,81.0,99.0,109.0,115.0,3.0,7.0,9.0,13.0,15.0,27.0,39.0,55.0,59.0,79.0,105.0,109.0,180.0,3.0,5.0,13.0,29.0,39.0,41.0,55.0,61.0,65.0,87.0,99.0,103.0,119.0,123.0,129.0,29.0,31.0,39.0,51.0,57.0,63.0,85.0,95.0,101.0,103.0,107.0,111.0,133.0,135.0,143.0,155.0,163.0,165.0,167.0,197.0,211.0,217.0,243.0,255.0,259.0,265.0,275.0,291.0,295.0,307.0,315.0,317.0,1.0,23.0,55.0,1.0,15.0,23.0,33.0,41.0,113.0,119.0,149.0,159.0,163.0,173.0,5.0,7.0,45.0,59.0,61.0,87.0,93.0,105.0,117.0,129.0,133.0,143.0,159.0,169.0,175.0,183.0,5.0,31.0,61.0,81.0,93.0,107.0,125.0,127.0,137.0,155.0,163.0,175.0,183.0,191.0,197.0,3.0,11.0,17.0,19.0,25.0,37.0,39.0,65.0,77.0,85.0,101.0,109.0,111.0,121.0,123.0,125.0,131.0,147.0,155.0,159.0,167.0,169.0,173.0,183.0,197.0,205.0,19.0,31.0,33.0,63.0,95.0,103.0,131.0,153.0,159.0,169.0,217.0,235.0,1.0,25.0,47.0,53.0,65.0,67.0,95.0,119.0,121.0,13.0,23.0,25.0,11.0,17.0,21.0,43.0,3.0,15.0,9.0,25.0,49.0,53.0,59.0,65.0,83.0,93.0,103.0,117.0,119.0,121.0,125.0,131.0,137.0,139.0,141.0,143.0,147.0,15.0,31.0,35.0,39.0,45.0,55.0,61.0,97.0,99.0,109.0,147.0,157.0,163.0,173.0,5.0,11.0,13.0,21.0,23.0,25.0,31.0,41.0,55.0,67.0,91.0,109.0,147.0,1.0,47.0,75.0,85.0,91.0,93.0,103.0,105.0,107.0,121.0,133.0,137.0,151.0,153.0,161.0,167.0,169.0,171.0,173.0,213.0,219.0,225.0,1.0,3.0,23.0,53.0,71.0,101.0,13.0,15.0,41.0,59.0,69.0,79.0,101.0,125.0,127.0,131.0,133.0,153.0,181.0,183.0,23.0,13.0,17.0,23.0,23.0,25.0,35.0,43.0,49.0,51.0,53.0,61.0,33.0,37.0,39.0,47.0,49.0,55.0,69.0,73.0,83.0,93.0,105.0,1.0,5.0,15.0,31.0,37.0,39.0,47.0,93.0,101.0,119.0,125.0,145.0,149.0,151.0,155.0,173.0,191.0,1.0,7.0,35.0,47.0,53.0,61.0,63.0,87.0,89.0,5.0,7.0,51.0,55.0,57.0,83.0,91.0,103.0,107.0,123.0,151.0,167.0,27.0,37.0,41.0,55.0,59.0,63.0,81.0,91.0,101.0,109.0,113.0,115.0,131.0,133.0,137.0,153.0,3.0,19.0,25.0,31.0,53.0,71.0,5.0,17.0,21.0,41.0,51.0,55.0,59.0,61.0,65.0,79.0,83.0,97.0,107.0,111.0,115.0,119.0,7.0,17.0,63.0,91.0,9.0,15.0,31.0,35.0,57.0,69.0,83.0,91.0,9.0,37.0,49.0,59.0,67.0,81.0,83.0,85.0,125.0,131.0,139.0,153.0,179.0,33.0,35.0,75.0,83.0,121.0,133.0,135.0,167.0,173.0,191.0,233.0,237.0,249.0,259.0,267.0,301.0,303.0,305.0,325.0,331.0,339.0,361.0,363.0,387.0,393.0,399.0,417.0,421.0,423.0,445.0,479.0,487.0,5.0,9.0,31.0,37.0,39.0,43.0,45.0,49.0,25.0,41.0,43.0,53.0,63.0,69.0,75.0,85.0,95.0,101.0,115.0,155.0,169.0,175.0,179.0,187.0,550.0,595.0,600.0,650.0,735.0,840.0,15.0,21.0,25.0,35.0,45.0,73.0,9.0,17.0,21.0,37.0,57.0,69.0,89.0,95.0,97.0,103.0,15.0,39.0,55.0,57.0,67.0,71.0,89.0,91.0,95.0,97.0,99.0,103.0,113.0,115.0,117.0,135.0,3.0,11.0,39.0]},"kind":"numeric","n":3144,"n_null":0,"n_unique":329,"null_rate":0.0,"stats":{"iqr":98.5,"kurtosis":11.377292380587615,"max":840.0,"mean":103.87404580152672,"median":79.0,"min":1.0,"n_outliers":176,"outlier_rate":0.05597964376590331,"q1":35.0,"q3":133.5,"skew":2.8407148144652545,"std":107.56652873641787,"zero_rate":0.0}},{"alerts":[],"column":"fips","extras":{"histogram":{"counts":[97,0,80,68,0,73,3,6,221,0,49,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":[1033.0,1041.0,1059.0,1085.0,1109.0,1111.0,1113.0,1127.0,1133.0,2100.0,2170.0,2290.0,4011.0,4027.0,5013.0,5017.0,5045.0,5049.0,5101.0,5119.0,5141.0,6005.0,6037.0,6041.0,6065.0,6079.0,6081.0,6099.0,6109.0,6115.0,8003.0,8007.0,8009.0,8013.0,8015.0,8027.0,8039.0,8055.0,8059.0,8079.0,8105.0,8109.0,9180.0,10003.0,10005.0,12013.0,12029.0,12039.0,12041.0,12055.0,12061.0,12065.0,12087.0,12099.0,12103.0,12119.0,12123.0,12129.0,13029.0,13031.0,13039.0,13051.0,13057.0,13063.0,13085.0,13095.0,13101.0,13103.0,13107.0,13111.0,13133.0,13135.0,13143.0,13155.0,13163.0,13165.0,13167.0,13197.0,13211.0,13217.0,13243.0,13255.0,13259.0,13265.0,13275.0,13291.0,13295.0,13307.0,13315.0,13317.0,15001.0,16023.0,16055.0,17001.0,17015.0,17023.0,17033.0,17041.0,17113.0,17119.0,17149.0,17159.0,17163.0,17173.0,18005.0,18007.0,18045.0,18059.0,18061.0,18087.0,18093.0,18105.0,18117.0,18129.0,18133.0,18143.0,18159.0,18169.0,18175.0,18183.0,19005.0,19031.0,19061.0,19081.0,19093.0,19107.0,19125.0,19127.0,19137.0,19155.0,19163.0,19175.0,19183.0,19191.0,19197.0,20003.0,20011.0,20017.0,20019.0,20025.0,20037.0,20039.0,20065.0,20077.0,20085.0,20101.0,20109.0,20111.0,20121.0,20123.0,20125.0,20131.0,20147.0,20155.0,20159.0,20167.0,20169.0,20173.0,20183.0,20197.0,20205.0,21019.0,21031.0,21033.0,21063.0,21095.0,21103.0,21131.0,21153.0,21159.0,21169.0,21217.0,21235.0,22001.0,22025.0,22047.0,22053.0,22065.0,22067.0,22095.0,22119.0,22121.0,23013.0,23023.0,23025.0,24011.0,24017.0,24021.0,24043.0,25003.0,25015.0,26009.0,26025.0,26049.0,26053.0,26059.0,26065.0,26083.0,26093.0,26103.0,26117.0,26119.0,26121.0,26125.0,26131.0,26137.0,26139.0,26141.0,26143.0,26147.0,27015.0,27031.0,27035.0,27039.0,27045.0,27055.0,27061.0,27097.0,27099.0,27109.0,27147.0,27157.0,27163.0,27173.0,28005.0,28011.0,28013.0,28021.0,28023.0,28025.0,28031.0,28041.0,28055.0,28067.0,28091.0,28109.0,28147.0,29001.0,29047.0,29075.0,29085.0,29091.0,29093.0,29103.0,29105.0,29107.0,29121.0,29133.0,29137.0,29151.0,29153.0,29161.0,29167.0,29169.0,29171.0,29173.0,29213.0,29219.0,29225.0,30001.0,30003.0,30023.0,30053.0,30071.0,30101.0,31013.0,31015.0,31041.0,31059.0,31069.0,31079.0,31101.0,31125.0,31127.0,31131.0,31133.0,31153.0,31181.0,31183.0,32023.0,34013.0,34017.0,34023.0,35023.0,35025.0,35035.0,35043.0,35049.0,35051.0,35053.0,35061.0,36033.0,36037.0,36039.0,36047.0,36049.0,36055.0,36069.0,36073.0,36083.0,36093.0,36105.0,37001.0,37005.0,37015.0,37031.0,37037.0,37039.0,37047.0,37093.0,37101.0,37119.0,37125.0,37145.0,37149.0,37151.0,37155.0,37173.0,37191.0,38001.0,38007.0,38035.0,38047.0,38053.0,38061.0,38063.0,38087.0,38089.0,39005.0,39007.0,39051.0,39055.0,39057.0,39083.0,39091.0,39103.0,39107.0,39123.0,39151.0,39167.0,40027.0,40037.0,40041.0,40055.0,40059.0,40063.0,40081.0,40091.0,40101.0,40109.0,40113.0,40115.0,40131.0,40133.0,40137.0,40153.0,41003.0,41019.0,41025.0,41031.0,41053.0,41071.0,42005.0,42017.0,42021.0,42041.0,42051.0,42055.0,42059.0,42061.0,42065.0,42079.0,42083.0,42097.0,42107.0,42111.0,42115.0,42119.0,45007.0,45017.0,45063.0,45091.0,46009.0,46015.0,46031.0,46035.0,46057.0,46069.0,46083.0,46091.0,47009.0,47037.0,47049.0,47059.0,47067.0,47081.0,47083.0,47085.0,47125.0,47131.0,47139.0,47153.0,47179.0,48033.0,48035.0,48075.0,48083.0,48121.0,48133.0,48135.0,48167.0,48173.0,48191.0,48233.0,48237.0,48249.0,48259.0,48267.0,48301.0,48303.0,48305.0,48325.0,48331.0,48339.0,48361.0,48363.0,48387.0,48393.0,48399.0,48417.0,48421.0,48423.0,48445.0,48479.0,48487.0,49005.0,49009.0,49031.0,49037.0,49039.0,49043.0,49045.0,49049.0,51025.0,51041.0,51043.0,51053.0,51063.0,51069.0,51075.0,51085.0,51095.0,51101.0,51115.0,51155.0,51169.0,51175.0,51179.0,51187.0,51550.0,51595.0,51600.0,51650.0,51735.0,51840.0,53015.0,53021.0,53025.0,53035.0,53045.0,53073.0,54009.0,54017.0,54021.0,54037.0,54057.0,54069.0,54089.0,54095.0,54097.0,54103.0,55015.0,55039.0,55055.0,55057.0,55067.0,55071.0,55089.0,55091.0,55095.0,55097.0,55099.0,55103.0,55113.0,55115.0,55117.0,55135.0,56003.0,56011.0,56039.0]},"kind":"numeric","n":3144,"n_null":0,"n_unique":3144,"null_rate":0.0,"stats":{"iqr":26905.0,"kurtosis":-1.0987926546522766,"max":56045.0,"mean":30368.18702290076,"median":29174.0,"min":1001.0,"n_outliers":0,"outlier_rate":0.0,"q1":18174.5,"q3":45079.5,"skew":-0.07923478215841098,"std":15170.427483552843,"zero_rate":0.0}}],"insights":{"errors":[],"insights":[{"confidence":"high","critiques":[],"evidence_keys":["row_count","column_count","columns.B01003_001E.stats","columns.B21001_002E.stats","columns.B23025_002E.stats","columns.state.n_unique","columns.NAME.top_words"],"featured_charts":[{"caption":"Total county population is heavily right-skewed (median 25,784 vs max 9.9M); view on a log scale to see the bulk of counties.","column":"B01003_001E","kind":"histogram"},{"caption":"Male veteran counts span 0 to 244,160 with skew of 8.0 \u2014 most counties sit under 4,500 veterans.","column":"B21001_002E","kind":"histogram"},{"caption":"Civilian labor force mirrors total population's long tail, with 449 outlier counties driven by major metros.","column":"B23025_002E","kind":"histogram"},{"caption":"Counts of counties per state code (51 values) show which states contribute the most rows.","column":"state","kind":"bar"},{"caption":"County name lengths cluster tightly around 24 characters \u2014 useful as a sanity check on the label field.","column":"NAME","kind":"length"}],"model":"anthropic:claude-opus-4-7","narrative":"This dataset covers 3,144 U.S. counties from the 2022 American Community Survey, with each row identified by FIPS, state, county code, and name, plus three Census table values: total population (B01003_001E), male veteran population (B21001_002E), and civilian labor force (B23025_002E). All three demographic measures are extremely right-skewed (skew of 13.2, 8.0, and 13.1) with hundreds of outlier counties \u2014 for example, total population ranges from 50 up to 9.94 million while the median is just 25,784. About 13-14% of counties register as outliers on each measure, reflecting the handful of very large metro counties dominating the tails. Start by looking at population and labor-force distributions on a log scale, and use the state field (51 unique values) to see how counties cluster geographically.","scope":"dataset","target":"__global__"},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","top_words","stats.len_min","stats.len_max","stats.len_median","stats.duplicate_rate","stats.word_mean"],"model":"anthropic:claude-opus-4-7","narrative":"This column holds full US county names with state suffix (e.g. 'X County, Texas'), as evidenced by 'county,' appearing in 2999 of 3144 rows and the next most common tokens being state names like Texas (256), Virginia (189), and Georgia (159). All 3144 values are unique with zero nulls or duplicates, and lengths cluster tightly between 16 and 59 characters (median 24). The 145 rows lacking the 'county,' token likely correspond to Louisiana parishes, Alaska boroughs, or independent cities, which is worth confirming.","role":"identifier","scope":"column","target":"NAME","treatment":"Use as a join key after parsing into separate county and state fields."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.min","stats.median","stats.max","stats.mean","stats.skew","stats.kurtosis","stats.outlier_rate","stats.zero_rate"],"model":"anthropic:claude-opus-4-7","narrative":"This is the ACS variable B23025_002E, the count of people aged 16+ in the labor force, reported per row (likely one row per US county given n=3144). The distribution is extremely right-skewed (skew 13.14, kurtosis 288.57) with a median of 11,698 but a max of 5,240,842, and 14.3% of rows flagged as outliers \u2014 consistent with a few massive metros dwarfing thousands of small counties. No nulls or zeros, and 3028/3144 values are unique.","role":"feature","scope":"column","target":"B23025_002E","treatment":"Log-transform before modelling to tame the heavy right tail."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.min","stats.max","stats.mean","stats.median","stats.skew","stats.kurtosis","stats.n_outliers","stats.outlier_rate","stats.zero_rate"],"model":"anthropic:claude-opus-4-7","narrative":"This is the ACS variable B21001_002E, a count of civilian veteran-eligible population per geographic unit (likely county, given n=3144). Values span 0 to 244,160 with a median of 1,547.5 but a mean of 5,419, and skew of 8.01 with kurtosis above 100 indicate a heavy right tail driven by 408 outlier rows (~13%). Near-zero null and zero rates confirm the count is populated nearly everywhere.","role":"feature","scope":"column","target":"B21001_002E","treatment":"log-transform or normalize per-capita before modelling to tame the heavy right tail."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.min","stats.max","stats.mean","stats.median","stats.skew","stats.kurtosis","stats.n_outliers","stats.outlier_rate","stats.zero_rate","stats.q1","stats.q3"],"model":"anthropic:claude-opus-4-7","narrative":"This is the ACS table B01003_001E, total population, reported for 3,144 rows \u2014 consistent with US counties. Values span 50 to 9,936,690 with median 25,784.5 versus mean 105,310.94, and skew of 13.17 with kurtosis 289.76 confirms an extreme long right tail (440 outliers, 14.0%). No nulls or zeros, and 3,080 of 3,144 values are unique.","role":"feature","scope":"column","target":"B01003_001E","treatment":"log-transform before regression to tame the 13x skew."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.min","stats.max","stats.iqr","stats.skew","stats.kurtosis"],"model":"anthropic:claude-opus-4-7","narrative":"This column holds 51 distinct integer codes ranging from 1 to 56 across 3144 rows with no nulls, matching the FIPS state code scheme (50 states plus DC, with gaps explaining why the max is 56). The near-uniform spread (IQR 27, skew -0.08, kurtosis -1.10) is consistent with a categorical identifier rather than a true numeric quantity. Row count of 3144 also aligns with US county-level data keyed by state.","role":"foreign_key","scope":"column","target":"state","treatment":"Treat as categorical FIPS code; left-join to a state lookup rather than using as a numeric feature."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.min","stats.max","stats.skew","stats.kurtosis","stats.n_outliers","stats.outlier_rate"],"model":"anthropic:claude-opus-4-7","narrative":"This column is named 'county' and contains integer codes ranging from 1 to 840 across 3144 rows with only 329 unique values, consistent with FIPS-style county numbers that repeat across states. The distribution is heavily right-skewed (skew 2.84, kurtosis 11.38) with 176 outliers (5.6%) above the upper fence, which is expected when a handful of states use higher county numbers. Despite being stored as numeric, the values are categorical identifiers, not measurements.","role":"identifier","scope":"column","target":"county","treatment":"Treat as a categorical code (likely county FIPS); do not model as a numeric feature."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.min","stats.max","stats.skew","stats.kurtosis"],"model":"anthropic:claude-opus-4-7","narrative":"This is the U.S. county FIPS code: a 3144-row column with 3144 unique integer values, no nulls, ranging from 1001 to 56045. The distribution is uniform-like (skew -0.08, kurtosis -1.10) which is exactly what you'd expect from state-prefixed county identifiers, not a measured quantity. Treat it as a key, not a numeric feature.","role":"identifier","scope":"column","target":"fips","treatment":"Left-join on this id to county-level reference tables; do not feed as a numeric feature."}],"providers":["anthropic:claude-opus-4-7"],"total_usage":{"completion_tokens":2722,"prompt_tokens":7823,"total_tokens":10545}},"language_counts":{},"meta":{"generated_at":"2026-05-01T17:02:24+00:00","mode":"full","row_count":3144,"sampled_rows":3144,"seed":42,"source":"/home/coolhand/html/datavis/data_trove/demographic/veterans/cache/acs_2022_county.parquet"},"notes":[],"saturn_version":"0.2.0","schema":{"B01003_001E":"numeric","B21001_002E":"numeric","B23025_002E":"numeric","NAME":"text","county":"numeric","fips":"numeric","state":"numeric"}}