{"columns":[{"alerts":[],"column":"fips","extras":{"histogram":{"counts":[97,15,133,59,14,4,226,5,49,189,204,184,39,15,170,196,150,27,21,95,153,155,46,67,51,161,268,29,133,94,95,0,0,0,0,0,0,0,0,78],"edges":[1001.0,2779.8,4558.6,6337.4,8116.2,9895.0,11673.8,13452.6,15231.4,17010.199999999997,18789.0,20567.8,22346.6,24125.399999999998,25904.2,27683.0,29461.8,31240.6,33019.399999999994,34798.2,36577.0,38355.799999999996,40134.6,41913.4,43692.2,45471.0,47249.799999999996,49028.6,50807.4,52586.2,54365.0,56143.799999999996,57922.6,59701.4,61480.2,63259.0,65037.799999999996,66816.59999999999,68595.4,70374.2,72153.0]},"sample":[1033.0,1041.0,1059.0,1087.0,1113.0,1115.0,1131.0,2016.0,2105.0,2110.0,2188.0,4005.0,4015.0,5005.0,5019.0,5023.0,5053.0,5055.0,5111.0,5129.0,6001.0,6015.0,6047.0,6053.0,6077.0,6091.0,6095.0,6113.0,8007.0,8011.0,8015.0,8019.0,8023.0,8025.0,8029.0,8041.0,8055.0,8069.0,8075.0,8093.0,8123.0,8125.0,12007.0,12011.0,12015.0,12031.0,12047.0,12057.0,12061.0,12075.0,12079.0,12085.0,12107.0,12119.0,12121.0,13003.0,13011.0,13017.0,13051.0,13055.0,13061.0,13073.0,13081.0,13085.0,13109.0,13117.0,13125.0,13131.0,13137.0,13157.0,13159.0,13167.0,13179.0,13189.0,13191.0,13193.0,13229.0,13237.0,13245.0,13269.0,13271.0,13285.0,13293.0,13305.0,13319.0,15005.0,16003.0,16011.0,16013.0,16023.0,16053.0,16087.0,17031.0,17035.0,17047.0,17057.0,17063.0,17077.0,17149.0,17157.0,17185.0,17197.0,17201.0,18005.0,18041.0,18043.0,18083.0,18095.0,18099.0,18131.0,18133.0,18147.0,18159.0,18173.0,19003.0,19017.0,19023.0,19027.0,19035.0,19043.0,19047.0,19075.0,19107.0,19125.0,19137.0,19155.0,19169.0,19173.0,19175.0,19183.0,20003.0,20011.0,20023.0,20037.0,20047.0,20051.0,20057.0,20065.0,20069.0,20075.0,20083.0,20085.0,20113.0,20125.0,20133.0,20153.0,20157.0,20161.0,20171.0,20173.0,20181.0,20183.0,20201.0,20209.0,21011.0,21013.0,21029.0,21045.0,21053.0,21077.0,21085.0,21121.0,21151.0,21155.0,21193.0,21209.0,21223.0,21227.0,22035.0,22057.0,22061.0,22083.0,22111.0,22115.0,22127.0,23003.0,24003.0,24021.0,24025.0,25003.0,25011.0,25013.0,26003.0,26015.0,26033.0,26041.0,26049.0,26073.0,26091.0,26121.0,26125.0,26129.0,26137.0,26155.0,26159.0,26163.0,27007.0,27019.0,27021.0,27023.0,27031.0,27039.0,27041.0,27045.0,27049.0,27051.0,27083.0,27103.0,27107.0,27113.0,27129.0,27133.0,27169.0,28005.0,28007.0,28047.0,28063.0,28071.0,28075.0,28083.0,28085.0,28091.0,28095.0,28103.0,28109.0,28117.0,28133.0,28145.0,28163.0,29017.0,29031.0,29067.0,29087.0,29123.0,29153.0,29163.0,29173.0,29181.0,29187.0,29195.0,29201.0,29213.0,29227.0,30005.0,30009.0,30019.0,30021.0,30027.0,30029.0,30065.0,30077.0,30087.0,30089.0,30105.0,31027.0,31045.0,31075.0,31095.0,31105.0,31129.0,31135.0,31151.0,31161.0,31177.0,32007.0,32033.0,33003.0,33005.0,33007.0,34015.0,34033.0,34041.0,35025.0,35059.0,36003.0,36013.0,36057.0,36063.0,36071.0,36075.0,36083.0,36093.0,36097.0,36103.0,37009.0,37017.0,37019.0,37023.0,37025.0,37029.0,37047.0,37057.0,37065.0,37071.0,37089.0,37095.0,37105.0,37109.0,37141.0,37143.0,37149.0,37199.0,38011.0,38023.0,38041.0,38049.0,38053.0,38055.0,38063.0,38071.0,38095.0,39005.0,39045.0,39057.0,39067.0,39075.0,39093.0,39101.0,39109.0,39117.0,39125.0,39127.0,39159.0,39163.0,39167.0,40027.0,40039.0,40049.0,40051.0,40063.0,40095.0,40099.0,40149.0,41001.0,41005.0,41019.0,41025.0,41031.0,41047.0,41057.0,41065.0,41069.0,42005.0,42013.0,42017.0,42027.0,42033.0,42037.0,42051.0,42055.0,42073.0,42075.0,42077.0,42111.0,42113.0,42123.0,44005.0,45013.0,45025.0,45037.0,45039.0,45041.0,45045.0,45049.0,45061.0,45065.0,45079.0,45083.0,46007.0,46011.0,46013.0,46043.0,46045.0,46049.0,46093.0,46119.0,46135.0,47007.0,47009.0,47035.0,47053.0,47057.0,47083.0,47087.0,47137.0,47159.0,48001.0,48009.0,48011.0,48015.0,48021.0,48039.0,48059.0,48081.0,48085.0,48089.0,48119.0,48161.0,48165.0,48175.0,48221.0,48227.0,48261.0,48263.0,48265.0,48285.0,48299.0,48323.0,48341.0,48369.0,48373.0,48393.0,48397.0,48403.0,48439.0,48443.0,48445.0,48465.0,48475.0,48487.0,48499.0,48505.0,49019.0,49023.0,49041.0,50005.0,50011.0,50025.0,51035.0,51043.0,51047.0,51067.0,51081.0,51093.0,51101.0,51105.0,51109.0,51111.0,51115.0,51131.0,51137.0,51167.0,51179.0,51195.0,51197.0,51510.0,51595.0,51600.0,51650.0,51680.0,51730.0,51740.0,51760.0,51800.0,53003.0,53029.0,53033.0,53043.0,53047.0,53055.0,53059.0,54003.0,54009.0,54043.0,54055.0,54071.0,54087.0,54097.0,54105.0,55003.0,55011.0,55033.0,55037.0,55047.0,55053.0,55057.0,55063.0,55081.0,55085.0,55087.0,55099.0,55113.0,55133.0,56017.0,56027.0,56033.0,56035.0,72023.0,72033.0,72049.0,72054.0,72069.0,72081.0,72083.0,72085.0,72087.0,72093.0,72109.0,72147.0,72153.0]},"kind":"numeric","n":3222,"n_null":0,"n_unique":3222,"null_rate":0.0,"stats":{"iqr":27075.0,"kurtosis":-0.6313744123374883,"max":72153.0,"mean":31377.89044072005,"median":30022.0,"min":1001.0,"n_outliers":0,"outlier_rate":0.0,"q1":19029.5,"q3":46104.5,"skew":0.1573655534643171,"std":16299.548257647879,"zero_rate":0.0}},{"alerts":[{"code":"short_text","level":"info","message":"95th-percentile length under 20 chars"},{"code":"duplicates","level":"warn","message":"39.2% duplicate strings"}],"column":"county_name","extras":{"language_counts":{},"language_sample_size":3222,"length_histogram":{"counts":[29,255,465,682,588,493,291,219,67,0,49,23,16,14,8,4,5,2,1,0,1,0,0,2,1,1,1,1,0,0,0,0,0,2,1,0,0,0,0,1],"edges":[10.0,10.9,11.8,12.7,13.6,14.5,15.4,16.3,17.2,18.1,19.0,19.9,20.8,21.700000000000003,22.6,23.5,24.4,25.3,26.2,27.1,28.0,28.900000000000002,29.8,30.7,31.6,32.5,33.400000000000006,34.3,35.2,36.1,37.0,37.900000000000006,38.8,39.7,40.6,41.5,42.4,43.300000000000004,44.2,45.1,46.0]},"near_unique":false,"sample":["Bibb County","Cheatham County","Piute County","Lamb County","Martin County","Sheridan County","Chickasaw County","Rockingham County","Liberty County","Clark County","Moore County","Lancaster County","Chase County","DeKalb County","Linn County","Washington County","Saguache County","Pecos County","Patillas Municipio","Ogemaw County","Washington County","Greene County","Toombs County","Alachua County","Cambria County","Jefferson County","Hunterdon County","DuPage County","Baca County","Lincoln County","Scioto County","Blaine County","Greene County","Iosco County","Vernon Parish","Bolivar County","Mineral County","Silver Bow County","Lincoln County","Knox County","Hood County","Spokane County","Decatur County","San Juan County","La Crosse County","Aguas Buenas Municipio","Bienville Parish","Lapeer County","Upson County","Essex County"],"top_values":[["Washington County",30],["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],["Johnson County",12]],"top_words":[["county",2999],["municipio",78],["parish",64],["city",47],["washington",31],["jefferson",28],["franklin",26],["st.",26],["jackson",24],["lincoln",24],["san",21],["madison",20],["clay",18],["montgomery",18],["lake",18],["union",18],["marion",17],["monroe",17],["borough",17],["wayne",16],["carroll",15],["grant",15],["greene",14],["warren",14],["clark",13]],"vocab_skipped":null,"word_histogram":{"counts":[2987,0,0,0,0,0,0,207,0,0,0,0,0,0,0,23,0,0,0,0,0,0,4,0,0,0,0,0,0,1],"edges":[2.0,2.1333333333333333,2.2666666666666666,2.4,2.533333333333333,2.6666666666666665,2.8,2.9333333333333336,3.0666666666666664,3.2,3.333333333333333,3.466666666666667,3.6,3.7333333333333334,3.8666666666666667,4.0,4.133333333333333,4.266666666666667,4.4,4.533333333333333,4.666666666666666,4.8,4.933333333333334,5.066666666666666,5.2,5.333333333333334,5.466666666666667,5.6,5.733333333333333,5.866666666666667,6.0]}},"kind":"text","n":3222,"n_null":0,"n_unique":1960,"null_rate":0.0,"stats":{"allcaps_rate":0.0,"boilerplate_rate":0.0,"duplicate_rate":0.39168218497827434,"emoji_rate":0.0,"len_max":46,"len_mean":14.172253258845437,"len_median":14.0,"len_min":10,"len_p95":18.0,"n_duplicates":1262,"n_empty":0,"one_word_rate":0.0,"readability_flesch_mean":33.35860000000002,"url_rate":0.0,"vocab_size":1963,"word_mean":2.0834885164494104,"word_median":2.0}},{"alerts":[],"column":"state","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],["PR",78],["OK",77],["AR",75],["WI",72]]},"kind":"categorical","n":3222,"n_null":0,"n_unique":52,"null_rate":0.0,"stats":{"cardinality":52,"entropy":5.314087905454926,"entropy_ratio":0.9322242086945259,"top_rate":0.07883302296710118,"top_value":"TX"}},{"alerts":[{"code":"high_skew","level":"info","message":"skew=+13.51"},{"code":"outliers","level":"warn","message":"13.7% rows beyond 1.5 IQR"}],"column":"total_25_plus","extras":{"histogram":{"counts":[2948,135,53,37,13,10,7,4,2,5,1,1,1,1,0,0,0,2,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1],"edges":[50.0,172790.0,345530.0,518270.0,691010.0,863750.0,1036490.0,1209230.0,1381970.0,1554710.0,1727450.0,1900190.0,2072930.0,2245670.0,2418410.0,2591150.0,2763890.0,2936630.0,3109370.0,3282110.0,3454850.0,3627590.0,3800330.0,3973070.0,4145810.0,4318550.0,4491290.0,4664030.0,4836770.0,5009510.0,5182250.0,5354990.0,5527730.0,5700470.0,5873210.0,6045950.0,6218690.0,6391430.0,6564170.0,6736910.0,6909650.0]},"sample":[40835.0,9148.0,21351.0,11880.0,39868.0,64523.0,7069.0,3861.0,1838.0,22947.0,4230.0,86631.0,165754.0,31982.0,12424.0,18612.0,12609.0,30946.0,15626.0,5734.0,1193888.0,19672.0,168503.0,279734.0,495879.0,2249.0,312706.0,129126.0,10417.0,4265.0,15510.0,7643.0,2617.0,4191.0,22899.0,478864.0,5162.0,239134.0,15042.0,14180.0,215564.0,6666.0,20149.0,1382985.0,157728.0,683191.0,9968.0,1009935.0,125938.0,31811.0,13709.0,123856.0,52656.0,118708.0,31122.0,5468.0,12937.0,11502.0,202409.0,17279.0,1931.0,104791.0,13661.0,19579.0,6975.0,165931.0,1987.0,17685.0,31309.0,52021.0,10251.0,6644.0,37758.0,14705.0,8928.0,8627.0,13247.0,16260.0,135577.0,5518.0,8699.0,46260.0,19052.0,20263.0,6122.0,50.0,3489.0,29380.0,17446.0,1873.0,15020.0,7460.0,3639978.0,7407.0,4338.0,24468.0,35053.0,32045.0,10348.0,21938.0,8048.0,463903.0,193727.0,56069.0,16326.0,55456.0,24166.0,91235.0,30949.0,8696.0,24842.0,14156.0,10978.0,44259.0,2644.0,16513.0,10159.0,14088.0,8270.0,12308.0,10648.0,8580.0,6987.0,22248.0,7219.0,63639.0,51740.0,4110.0,8235.0,15309.0,5228.0,9399.0,1882.0,23276.0,2069.0,17428.0,20445.0,1782.0,3504.0,1514.0,1222.0,8894.0,20064.0,21229.0,10511.0,1854.0,3296.0,35871.0,3399.0,340756.0,3718.0,2641.0,3856.0,106905.0,8467.0,16982.0,58451.0,11052.0,6593.0,5886.0,18029.0,20402.0,57882.0,13358.0,19595.0,37778.0,6012.0,82837.0,4833.0,66341.0,26298.0,13493.0,14883.0,30151.0,9808.0,50230.0,409052.0,186771.0,182063.0,95692.0,54094.0,318443.0,6562.0,44172.0,25632.0,27183.0,280153.0,36064.0,69488.0,121491.0,906930.0,15698.0,18112.0,48507.0,52266.0,1205390.0,28737.0,70801.0,22211.0,8611.0,4502.0,13896.0,27956.0,14574.0,33717.0,4339.0,16191.0,22326.0,4463.0,9696.0,10268.0,6488.0,31020.0,9134.0,11712.0,140048.0,4926.0,32280.0,49448.0,17405.0,23899.0,16676.0,23671.0,6679.0,38640.0,16541.0,17621.0,18512.0,19377.0,7616.0,52784.0,8477.0,3123.0,8667.0,6552.0,12388.0,7423.0,7522.0,47111.0,14738.0,25769.0,38856.0,1400.0,4353.0,8213.0,1180.0,6222.0,8568.0,75750.0,3692.0,5489.0,5134.0,9732.0,5374.0,5583.0,5179.0,445.0,5169.0,2506.0,3020.0,1965.0,9320.0,3595.0,14264.0,34678.0,6727.0,39992.0,54560.0,24511.0,207727.0,45316.0,79264.0,43412.0,2860.0,29967.0,89404.0,34309.0,152567.0,256375.0,80294.0,113385.0,109680.0,13283.0,1067104.0,20539.0,21347.0,111828.0,64552.0,150268.0,7290.0,35890.0,119381.0,34110.0,158986.0,87179.0,3706.0,43222.0,63079.0,43541.0,9828.0,15320.0,13849.0,2027.0,1547.0,1839.0,3755.0,8610.0,7093.0,2207.0,7912.0,1565.0,35796.0,107962.0,113708.0,10528.0,26321.0,218104.0,46136.0,75367.0,24585.0,13005.0,24430.0,43037.0,9053.0,42689.0,188419.0,16660.0,17251.0,37546.0,9361.0,10666.0,9532.0,7460.0,12415.0,300373.0,82360.0,5499.0,17060.0,230076.0,20699.0,18770.0,1101.0,48608.0,87416.0,464065.0,97184.0,59485.0,43527.0,94625.0,110146.0,61794.0,98487.0,255117.0,55224.0,4861.0,28337.0,63786.0,136528.0,30442.0,19108.0,15303.0,92542.0,361179.0,13205.0,11745.0,7986.0,263144.0,223505.0,1797.0,18716.0,25369.0,1894.0,2874.0,1440.0,20199.0,1032.0,16238.0,11441.0,98165.0,47524.0,34441.0,17170.0,5809.0,8770.0,3784.0,14009.0,42436.0,6034.0,1331.0,20958.0,64589.0,245242.0,9723.0,2385.0,711181.0,14013.0,3691.0,13871.0,11665.0,5044.0,45404.0,23829.0,87.0,452.0,38482.0,14057.0,17083.0,33187.0,12547.0,6233.0,36530.0,536.0,72042.0,7611.0,1365169.0,718.0,7356.0,28847.0,7184.0,8703.0,32972.0,7912.0,6970.0,6736.0,13611.0,21985.0,35303.0,34055.0,21867.0,10904.0,35453.0,39873.0,8609.0,27889.0,12367.0,16643.0,27905.0,8799.0,6472.0,9104.0,26211.0,19105.0,101532.0,25997.0,20773.0,119669.0,3819.0,16324.0,92527.0,44182.0,22903.0,65575.0,160905.0,64647.0,16165.0,63659.0,1622636.0,7879.0,29871.0,14820.0,9148.0,85192.0,16252.0,14448.0,42048.0,4653.0,10110.0,16418.0,3848.0,11136.0,9747.0,27990.0,3607.0,13502.0,14912.0,19700.0,77996.0,31206.0,29073.0,130100.0,10709.0,13693.0,289847.0,3308.0,1882.0,22046.0,6184.0,35227.0,16783.0,812.0,8080.0,37711.0,20841.0,6237.0,25698.0,17127.0,3969.0,12024.0,6017.0,25439.0]},"kind":"numeric","n":3222,"n_null":0,"n_unique":3140,"null_rate":0.0,"stats":{"iqr":38789.5,"kurtosis":306.89657753572334,"max":6909650.0,"mean":71074.29702048417,"median":18313.5,"min":50.0,"n_outliers":440,"outlier_rate":0.13656114214773432,"q1":7695.75,"q3":46485.25,"skew":13.514767661961619,"std":226586.32799075427,"zero_rate":0.0}},{"alerts":[],"column":"pct_hs_or_higher","extras":{"histogram":{"counts":[1,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,3,3,3,2,6,7,15,30,30,46,60,88,131,174,189,256,289,360,429,460,389,192,47,9],"edges":[33.33,34.989,36.647999999999996,38.307,39.966,41.625,43.284,44.943,46.602,48.260999999999996,49.92,51.57899999999999,53.238,54.897,56.556,58.215,59.873999999999995,61.533,63.192,64.851,66.50999999999999,68.169,69.828,71.487,73.146,74.805,76.464,78.12299999999999,79.782,81.441,83.1,84.759,86.418,88.077,89.73599999999999,91.395,93.054,94.713,96.372,98.031,99.69]},"sample":[86.38,82.07,80.1,82.72,85.19,87.29,77.71,89.54,94.02,95.44,86.05,91.45,87.78,89.63,89.73,87.91,92.64,87.92,81.79,81.98,89.21,83.2,71.44,73.36,80.23,93.55,88.88,87.88,94.52,83.4,93.04,96.62,88.35,81.03,90.0,94.8,92.91,96.33,91.07,97.56,88.34,84.83,82.13,90.0,91.94,90.72,77.08,89.31,91.44,87.64,80.17,92.41,82.45,92.52,84.31,70.43,79.4,83.74,91.42,73.19,83.22,93.2,82.17,88.0,79.03,93.91,82.18,80.93,80.71,87.8,89.62,76.25,92.2,85.54,82.54,72.61,86.7,87.63,87.58,73.99,75.46,88.25,84.42,85.47,89.38,92.0,94.04,88.42,91.82,90.39,75.29,90.21,88.21,93.41,91.08,89.93,93.98,91.84,91.04,86.04,93.04,91.6,88.54,91.82,85.21,92.37,89.06,89.91,85.77,88.09,90.87,92.53,90.75,94.92,94.02,96.11,93.54,94.66,93.18,90.72,82.53,95.85,93.47,94.1,91.63,90.63,97.05,91.0,92.79,92.32,86.46,89.72,89.21,94.32,87.58,95.34,77.22,93.83,75.34,85.6,92.64,93.83,92.66,90.0,91.03,94.66,95.36,95.83,84.91,89.48,89.67,95.42,93.52,81.36,81.45,78.18,89.37,77.27,80.87,84.57,83.57,79.02,90.75,84.36,79.63,94.28,85.55,88.59,67.72,82.04,88.66,80.13,85.92,87.79,83.91,90.63,93.55,93.27,94.17,93.4,93.69,86.66,93.74,93.13,92.27,92.33,91.0,92.64,91.13,92.14,94.74,88.18,94.34,92.11,88.43,87.78,92.44,96.29,93.89,90.73,97.2,95.75,95.65,91.88,94.48,93.27,92.82,95.09,92.83,95.3,91.37,93.97,93.15,87.54,84.08,89.1,75.86,91.77,84.19,83.19,87.34,82.78,84.91,81.09,86.89,83.49,77.03,77.58,77.04,84.3,91.84,84.76,93.63,88.24,80.94,86.42,91.49,82.17,86.86,87.93,86.37,89.83,94.0,89.11,95.82,96.19,95.21,94.64,95.59,91.12,92.51,89.68,90.65,93.26,94.7,95.64,91.69,92.07,85.28,92.78,90.64,80.53,89.71,95.09,88.9,89.31,95.03,93.76,88.92,93.6,90.18,93.84,76.09,87.55,91.35,89.68,88.78,91.69,89.69,89.78,92.42,91.64,91.91,90.46,87.01,88.17,93.54,84.78,91.95,92.26,85.62,86.55,85.58,87.64,91.57,81.03,85.15,89.82,90.23,86.39,92.76,88.53,89.05,90.43,88.04,90.55,92.72,93.22,94.02,92.72,85.37,89.89,93.88,94.2,88.18,57.58,91.21,89.47,92.83,89.75,89.9,87.99,94.93,80.26,91.76,92.21,88.06,87.28,90.63,84.19,81.91,86.81,89.12,91.38,94.36,91.27,91.23,87.87,85.75,90.7,86.44,91.64,92.44,92.96,94.68,94.81,89.86,91.64,89.84,90.21,91.96,87.51,90.25,90.03,90.76,93.71,94.77,93.64,81.38,83.0,84.09,87.29,90.1,80.92,81.19,85.16,92.2,87.83,88.87,96.2,93.66,91.29,92.59,92.22,95.82,96.22,93.08,78.11,90.43,89.27,87.61,81.0,84.04,81.27,81.53,86.62,84.77,91.17,92.79,87.88,83.08,88.78,92.08,86.04,94.35,84.41,89.19,84.98,60.38,84.46,92.37,81.01,33.33,88.5,89.69,85.32,91.53,64.62,67.94,71.06,81.37,91.79,94.34,86.91,87.06,93.73,75.99,73.54,80.22,78.44,86.09,65.58,94.49,93.57,91.98,93.75,91.91,94.2,83.02,93.71,89.38,89.68,79.7,91.19,93.49,81.75,88.65,78.75,94.25,86.88,89.78,82.94,92.9,80.36,90.14,93.69,76.9,92.23,92.75,90.32,86.43,89.52,88.76,91.18,93.01,95.66,93.79,92.45,86.01,95.8,93.42,90.56,92.51,82.18,86.4,83.13,80.63,87.34,85.84,95.08,91.87,94.08,91.41,91.07,91.81,89.37,96.25,90.92,95.36,94.24,92.89,92.8,96.85,95.1,91.92,96.31,95.86,75.92,77.79,83.25,77.62,80.08,67.13,65.38,80.43,77.33,59.54,79.65,72.28,79.05]},"kind":"numeric","n":3222,"n_null":0,"n_unique":1612,"null_rate":0.0,"stats":{"iqr":7.5674999999999955,"kurtosis":3.7418650474404176,"max":99.69,"mean":88.07803538175047,"median":89.39,"min":33.33,"n_outliers":86,"outlier_rate":0.02669149596523898,"q1":84.9,"q3":92.4675,"skew":-1.3278504891335614,"std":5.969980653624142,"zero_rate":0.0}},{"alerts":[],"column":"pct_bachelors_or_higher","extras":{"histogram":{"counts":[1,0,4,9,32,135,169,317,328,376,345,262,232,189,123,116,118,96,60,68,40,34,34,24,21,19,15,10,11,10,9,6,5,1,0,1,0,0,1,1],"edges":[0.0,1.9717500000000001,3.9435000000000002,5.91525,7.8870000000000005,9.85875,11.8305,13.80225,15.774000000000001,17.74575,19.7175,21.68925,23.661,25.63275,27.6045,29.57625,31.548000000000002,33.51975,35.4915,37.46325,39.435,41.40675,43.3785,45.35025,47.322,49.29375,51.2655,53.23725,55.209,57.18075,59.1525,61.12425,63.096000000000004,65.06775,67.0395,69.01125,70.983,72.95475,74.9265,76.89825,78.87]},"sample":[18.04,17.2,14.83,20.56,16.36,19.33,11.61,15.44,27.53,40.74,15.15,39.59,14.41,18.16,26.45,17.19,18.78,16.56,11.54,14.95,50.94,17.72,14.64,27.07,20.31,23.88,28.2,43.27,39.44,15.5,41.42,55.03,23.65,12.74,24.5,40.18,26.08,50.89,19.72,35.49,30.66,24.44,13.17,34.94,25.13,32.24,9.24,36.25,32.73,16.1,12.95,35.1,13.32,33.69,15.88,11.36,17.12,12.2,36.07,9.47,16.57,37.43,14.09,35.46,16.36,56.2,12.93,15.82,22.94,26.52,18.3,9.5,20.22,18.38,17.81,10.06,17.0,25.6,23.56,16.33,8.05,20.31,15.37,14.12,12.05,34.0,21.3,19.85,44.53,16.23,13.1,17.48,41.28,17.74,13.9,17.69,25.69,35.22,18.06,13.74,18.48,36.08,24.14,34.81,15.42,31.3,18.11,19.43,20.03,14.05,19.43,19.91,24.8,34.49,21.44,34.01,19.36,22.13,21.72,17.17,16.12,26.14,16.36,31.72,18.6,23.43,52.54,15.45,24.08,24.4,15.26,23.72,22.21,30.89,17.88,38.72,19.78,24.35,21.89,19.22,30.52,20.97,31.37,20.12,21.15,17.48,26.43,47.83,19.92,31.75,26.09,23.1,22.54,19.99,14.36,11.67,17.55,12.21,14.0,13.03,13.25,16.71,33.34,12.84,13.22,31.89,13.67,32.93,11.79,18.62,36.57,16.33,17.37,18.73,13.27,21.4,44.13,43.63,38.77,37.96,39.8,28.65,20.71,23.63,22.87,19.7,22.79,30.65,22.48,20.69,49.53,14.57,26.26,19.18,22.22,26.5,31.44,49.76,24.85,19.79,46.4,30.3,28.41,23.29,27.79,19.04,27.51,34.91,21.87,19.66,17.96,27.42,31.8,9.24,16.19,24.8,19.73,45.08,20.43,19.22,19.18,11.27,16.07,13.36,15.94,18.48,17.35,17.69,11.87,11.7,33.63,15.75,21.07,16.1,10.38,15.36,15.76,11.86,15.5,24.99,21.17,23.82,15.64,23.78,31.39,26.02,24.62,27.58,34.89,19.72,19.38,19.44,18.08,19.61,23.3,36.03,26.97,19.27,11.53,26.82,25.85,21.93,21.7,34.3,17.01,13.3,37.54,34.36,20.41,35.17,22.77,35.48,14.6,15.52,24.5,24.29,19.78,27.03,31.56,21.43,35.36,34.24,24.48,39.03,20.79,20.25,32.4,19.76,36.49,24.35,14.53,20.47,17.75,25.0,33.96,14.25,21.01,26.06,28.61,19.59,33.34,22.37,21.81,21.33,17.73,19.39,24.63,22.25,28.59,25.47,17.06,21.9,31.09,41.19,11.68,11.06,27.22,13.46,24.67,16.9,15.41,14.8,39.32,15.44,20.48,35.24,31.05,16.39,22.12,14.6,15.65,17.5,19.58,24.41,39.19,18.9,14.17,21.21,25.01,23.81,22.05,19.98,18.59,23.43,43.31,46.2,19.13,25.46,18.65,22.97,22.04,22.85,32.35,17.23,18.89,18.95,52.11,43.39,12.87,19.88,14.72,23.8,39.3,11.56,14.45,21.26,40.24,25.24,18.36,42.43,32.82,20.59,28.15,22.15,27.38,21.51,27.28,10.34,26.02,18.1,18.54,14.09,11.41,13.92,18.21,16.9,13.11,25.17,25.92,24.13,23.05,31.41,22.87,19.5,54.29,22.17,21.48,17.38,10.4,17.84,31.65,13.82,8.05,27.88,29.77,19.56,31.81,15.82,11.84,18.45,13.19,19.22,43.87,17.88,33.91,29.53,11.03,20.23,11.34,16.64,21.13,11.35,31.72,21.39,22.83,31.51,27.41,40.4,15.9,34.49,26.85,23.85,13.43,29.78,24.81,11.52,25.83,11.1,29.81,29.34,27.3,12.55,43.07,16.27,20.1,66.0,16.47,60.05,27.67,37.98,21.76,21.25,44.12,32.08,23.1,35.36,54.85,23.01,22.64,52.6,26.36,24.32,21.9,8.08,20.57,19.23,13.62,16.65,15.15,20.67,21.0,28.56,22.51,22.43,15.88,16.12,35.85,20.11,27.08,31.56,16.09,26.92,47.17,28.23,20.03,32.13,25.58,28.08,21.75,15.64,18.63,24.22,20.39,17.67,27.4,16.72,10.48,19.94,14.54,27.63]},"kind":"numeric","n":3222,"n_null":0,"n_unique":1982,"null_rate":0.0,"stats":{"iqr":11.2575,"kurtosis":2.305781625546806,"max":78.87,"mean":23.49880819366853,"median":21.07,"min":0.0,"n_outliers":141,"outlier_rate":0.043761638733705775,"q1":16.59,"q3":27.8475,"skew":1.3574894643887674,"std":9.983246668303535,"zero_rate":0.00031036623215394165}}],"insights":{"errors":[],"insights":[{"confidence":"high","critiques":[],"evidence_keys":["row_count","column_count","columns.pct_bachelors_or_higher.stats","columns.pct_hs_or_higher.stats","columns.total_25_plus.stats","columns.state.top_values","columns.county_name.top_values"],"featured_charts":[{"caption":"Shows the wide spread of college attainment across counties, from 0% to nearly 79%.","column":"pct_bachelors_or_higher","kind":"histogram"},{"caption":"Most counties cluster near 88-89% high school completion, with a long left tail of low-attainment counties.","column":"pct_hs_or_higher","kind":"histogram"},{"caption":"Highly skewed population distribution; consider log-scaling to see the bulk of small/medium counties.","column":"total_25_plus","kind":"histogram"},{"caption":"Counties per state \u2014 TX, GA, and VA contribute the highest counts.","column":"state","kind":"bar"}],"model":"anthropic:claude-opus-4-7","narrative":"This dataset contains 3,222 US county-level education records with 6 columns covering county identifiers (county_name, fips, state) and educational attainment metrics (pct_hs_or_higher, pct_bachelors_or_higher, total_25_plus). The bachelor's degree rate averages 23.5% but ranges from 0% to nearly 79%, suggesting wide regional disparities worth investigating. The total_25_plus population column is heavily skewed (skew=13.5) with 440 outliers and a max of nearly 6.9 million, so any analysis using it should consider log transforms or per-capita normalization. State coverage is fairly even across 52 entries, with TX, GA, and VA contributing the most counties.","scope":"dataset","target":"__global__"},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.min","stats.max","stats.skew","stats.kurtosis","stats.n_outliers"],"model":"anthropic:claude-opus-4-7","narrative":"This column holds U.S. FIPS county/state codes: every one of the 3222 rows is unique, no nulls, and values span 1001 to 72153, consistent with state-prefixed county identifiers. The distribution is roughly symmetric (skew 0.16, kurtosis -0.63) with no outliers, which is expected for an enumerated geographic key rather than a measured quantity. Treat the numeric stats as incidental \u2014 these are categorical identifiers, not magnitudes.","role":"identifier","scope":"column","target":"fips","treatment":"Cast to zero-padded string and use as a join key to county/state geographies; do not model as a number."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","stats.duplicate_rate","stats.n_duplicates","stats.len_mean","stats.word_mean","top_values","top_words"],"model":"anthropic:claude-opus-4-7","narrative":"This is a US county-level place-name field: 2-word entries averaging 14 characters, with 'County' appearing 2999 times alongside 'Parish' (64, Louisiana) and 'Municipio' (78, Puerto Rico). Duplication is heavy at 39.2% (1262 rows) because common names like Washington County (30), Jefferson County (25), and Franklin County (24) recur across states \u2014 so this column is not unique on its own. With 1960 distinct values across 3222 rows, it needs a state qualifier to act as a key.","role":"metadata","scope":"column","target":"county_name","treatment":"Concatenate with a state/territory code before using as a join key; do not treat as unique."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.cardinality","stats.entropy_ratio","stats.top_rate","stats.top_value","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"This is a US state code column with 52 distinct values, matching the 50 states plus likely DC and a territory. Distribution is fairly even (entropy ratio 0.93), with TX leading at 254 rows (7.88%) followed by GA, VA, and KY \u2014 consistent with county-level row counts where larger states contribute more records. No nulls.","role":"feature","scope":"column","target":"state","treatment":"one-hot or target-encode for modelling; usable as a join key to state-level reference tables."},{"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":"A heavily right-skewed count of population (or units) aged 25 and over per row, ranging from 50 to 6,909,650 with a median of 18,313.5 but a mean of 71,074.3. Skew of 13.5 and kurtosis of 306.9 indicate a long heavy tail, and 440 rows (13.7%) flag as outliers. No nulls or zeros, and 3,140 of 3,222 values are unique, consistent with geographic aggregates of varying size.","role":"feature","scope":"column","target":"total_25_plus","treatment":"log-transform before any regression or distance-based modelling."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.min","stats.max","stats.mean","stats.median","stats.q1","stats.q3","stats.skew","stats.kurtosis","stats.n_outliers","stats.outlier_rate"],"model":"anthropic:claude-opus-4-7","narrative":"This column reports the percentage of a population with at least a high school education, ranging from 33.33 to 99.69 with a mean of 88.08 and median of 89.39. The distribution is left-skewed (skew -1.33) with heavy tails (kurtosis 3.74), and 86 low-end outliers (2.67%) pull below the bulk concentrated between Q1 84.9 and Q3 92.47. With 1612 unique values across 3222 rows and no nulls, it looks like a clean geographic feature (likely county- or tract-level).","role":"feature","scope":"column","target":"pct_hs_or_higher","treatment":"Use as-is or apply a reflected log/Box-Cox to address the left skew before linear modelling."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.min","stats.max","stats.mean","stats.median","stats.std","stats.skew","stats.kurtosis","stats.q1","stats.q3","stats.n_outliers","stats.outlier_rate","stats.zero_rate"],"model":"anthropic:claude-opus-4-7","narrative":"This column reports the percentage of residents with a bachelor's degree or higher across 3,222 rows, ranging from 0.0 to 78.87 with a median of 21.07 and mean of 23.50. The distribution is right-skewed (skew 1.36, kurtosis 2.31) with 141 high-end outliers (4.4%) reflecting a long tail of highly-educated areas. Near-zero zero_rate (0.0003) and no nulls suggest clean coverage.","role":"feature","scope":"column","target":"pct_bachelors_or_higher","treatment":"Consider a log or sqrt transform to tame the right skew before linear modelling."}],"providers":["anthropic:claude-opus-4-7"],"total_usage":{"completion_tokens":2393,"prompt_tokens":7383,"total_tokens":9776}},"language_counts":{},"meta":{"generated_at":"2026-05-01T17:05:21+00:00","mode":"full","row_count":3222,"sampled_rows":3222,"seed":42,"source":"/home/coolhand/datasets/us-inequality-atlas/education/education_by_county.csv"},"notes":[],"saturn_version":"0.2.0","schema":{"county_name":"text","fips":"numeric","pct_bachelors_or_higher":"numeric","pct_hs_or_higher":"numeric","state":"categorical","total_25_plus":"numeric"}}