{"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":"near_unique","level":"info","message":"100.0% of rows are unique strings"}],"column":"county_name","extras":{"language_counts":{},"language_sample_size":3222,"length_histogram":{"counts":[26,72,121,190,264,407,420,363,320,240,231,152,139,165,41,28,16,10,5,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","Cheatham County, Tennessee","Piute County, Utah","Lamb County, Texas","Martin County, Minnesota","Sheridan County, Wyoming","Chickasaw County, Mississippi","Rockingham County, Virginia","Liberty County, Texas","Clark County, Arkansas","Moore County, North Carolina","Lancaster County, Nebraska","Chase County, Kansas","DeKalb County, Alabama","Linn County, Kansas","Washington County, Idaho","Saguache County, Colorado","Pecos County, Texas","Patillas Municipio, Puerto Rico","Ogemaw County, Michigan","Washington County, Kansas","Greene County, Arkansas","Toombs County, Georgia","Alachua County, Florida","Cambria County, Pennsylvania","Jefferson County, Tennessee","Hunterdon County, New Jersey","DuPage County, Illinois","Baca County, Colorado","Lincoln County, Wyoming","Scioto County, Ohio","Blaine County, Oklahoma","Greene County, Alabama","Iosco County, Michigan","Vernon Parish, Louisiana","Bolivar County, Mississippi","Mineral County, West Virginia","Silver Bow County, Montana","Lincoln County, Mississippi","Knox County, Nebraska","Hood County, Texas","Spokane County, Washington","Decatur County, Kansas","San Juan County, Washington","La Crosse County, Wisconsin","Aguas Buenas Municipio, Puerto Rico","Bienville Parish, Louisiana","Lapeer County, Michigan","Upson County, Georgia","Essex County, Virginia"],"top_values":[],"top_words":[["county,",2999],["texas",256],["virginia",189],["georgia",159],["north",155],["carolina",147],["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],["municipio,",78],["puerto",78],["rico",78]],"vocab_skipped":null,"word_histogram":{"counts":[2492,0,0,0,0,0,0,667,0,0,0,0,0,0,0,57,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":3222,"n_null":0,"n_unique":3222,"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.324022346368714,"len_median":24.0,"len_min":16,"len_p95":31.0,"n_duplicates":0,"n_empty":0,"one_word_rate":0.0,"readability_flesch_mean":10.283900000000026,"url_rate":0.0,"vocab_size":1990,"word_mean":3.2482929857231535,"word_median":3.0}},{"alerts":[{"code":"high_skew","level":"info","message":"skew=-56.74"},{"code":"outliers","level":"warn","message":"5.8% rows beyond 1.5 IQR"}],"column":"median_household_income","extras":{"histogram":{"counts":[1,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,3221],"edges":[-666666666.0,-649995737.775,-633324809.55,-616653881.325,-599982953.1,-583312024.875,-566641096.65,-549970168.425,-533299240.2,-516628311.975,-499957383.75,-483286455.525,-466615527.3,-449944599.07500005,-433273670.85,-416602742.625,-399931814.4,-383260886.175,-366589957.95,-349919029.725,-333248101.5,-316577173.27500004,-299906245.05,-283235316.825,-266564388.60000002,-249893460.375,-233222532.15000004,-216551603.925,-199880675.7,-183209747.47500002,-166538819.25,-149867891.02500004,-133196962.80000001,-116526034.57500005,-99855106.35000002,-83184178.125,-66513249.899999976,-49842321.67500007,-33171393.450000048,-16500465.225000024,170463.0]},"sample":[56149.0,48557.0,47359.0,41206.0,47420.0,73218.0,38208.0,100662.0,62344.0,95711.0,77647.0,67266.0,53592.0,47403.0,48071.0,52780.0,68598.0,54879.0,43440.0,42063.0,122488.0,61149.0,64772.0,91043.0,82837.0,61108.0,97037.0,85097.0,66813.0,45776.0,65703.0,87169.0,34578.0,40685.0,56349.0,82748.0,49631.0,87199.0,54864.0,85019.0,89182.0,60118.0,54759.0,70331.0,62164.0,65579.0,47668.0,70612.0,67543.0,49933.0,43386.0,77894.0,44852.0,70105.0,49729.0,38007.0,69096.0,38255.0,66171.0,43556.0,43264.0,92571.0,47463.0,84516.0,55222.0,131660.0,60469.0,51929.0,61292.0,82056.0,57374.0,47796.0,55149.0,54752.0,51262.0,33960.0,54861.0,60825.0,50605.0,40727.0,41801.0,53599.0,48740.0,49847.0,40757.0,87813.0,55891.0,69433.0,81794.0,37358.0,67347.0,50046.0,78304.0,71274.0,60784.0,57223.0,89993.0,44847.0,55514.0,63860.0,54074.0,103678.0,61738.0,76912.0,52219.0,75686.0,58173.0,60060.0,66016.0,56823.0,70609.0,66168.0,71947.0,91105.0,64750.0,84727.0,65743.0,68041.0,63638.0,60441.0,61188.0,80701.0,60016.0,74193.0,61261.0,68718.0,66197.0,65926.0,56495.0,71122.0,67651.0,55826.0,52730.0,49779.0,52750.0,59665.0,67997.0,47071.0,74500.0,58750.0,63125.0,70385.0,71250.0,51513.0,54894.0,61827.0,54531.0,56327.0,53365.0,65372.0,61404.0,50943.0,59432.0,57771.0,51471.0,33658.0,73900.0,42190.0,41180.0,58641.0,47024.0,34254.0,59797.0,49627.0,45330.0,80782.0,66492.0,63074.0,30856.0,61381.0,37001.0,48125.0,47068.0,56547.0,44922.0,50843.0,116009.0,115724.0,106417.0,69744.0,70383.0,66619.0,55528.0,75182.0,58408.0,53852.0,58594.0,52638.0,65484.0,61347.0,92620.0,50377.0,62865.0,62498.0,65531.0,57223.0,62173.0,116308.0,61970.0,62112.0,71937.0,92890.0,72472.0,73234.0,78338.0,67600.0,68919.0,79113.0,65278.0,71504.0,66313.0,75060.0,66162.0,34866.0,42680.0,55211.0,31544.0,59748.0,45649.0,33115.0,47069.0,38399.0,51190.0,42298.0,54220.0,51578.0,37403.0,55970.0,41867.0,52306.0,65070.0,47848.0,55153.0,54042.0,39125.0,53363.0,62615.0,42541.0,53083.0,55396.0,54621.0,54467.0,43536.0,58507.0,66780.0,47378.0,68168.0,58321.0,68025.0,54875.0,60994.0,57656.0,47110.0,59725.0,72035.0,53760.0,65139.0,54494.0,53151.0,66000.0,61786.0,71104.0,53609.0,89671.0,87755.0,71297.0,77049.0,76551.0,55247.0,99668.0,73378.0,92620.0,65855.0,41714.0,58725.0,54625.0,58033.0,65882.0,91806.0,65054.0,83734.0,75056.0,61316.0,122498.0,49176.0,40476.0,71193.0,53732.0,83828.0,79120.0,43206.0,58473.0,46370.0,62628.0,65508.0,43724.0,60941.0,75672.0,74538.0,59401.0,60465.0,53103.0,79709.0,95938.0,66797.0,78071.0,83813.0,80556.0,62219.0,61490.0,61250.0,62254.0,82969.0,81243.0,54056.0,72987.0,67272.0,55106.0,71440.0,70412.0,65331.0,62899.0,104496.0,50967.0,59053.0,71757.0,58669.0,53600.0,74349.0,44799.0,53734.0,60213.0,60600.0,51657.0,95740.0,56440.0,45462.0,69345.0,70926.0,63098.0,61316.0,50774.0,61011.0,59386.0,107826.0,70087.0,56982.0,59457.0,55579.0,71808.0,57585.0,72532.0,74973.0,57357.0,62910.0,57925.0,96319.0,81260.0,46326.0,60033.0,44521.0,56088.0,71328.0,40157.0,39099.0,55569.0,59850.0,61955.0,44821.0,64438.0,70379.0,75048.0,76806.0,56734.0,70256.0,66875.0,68847.0,51783.0,70935.0,56002.0,55455.0,47098.0,51544.0,42357.0,44317.0,57677.0,57445.0,69954.0,70417.0,73556.0,80151.0,91972.0,63906.0,40230.0,113255.0,63352.0,68491.0,55902.0,73299.0,58125.0,80013.0,67243.0,45455.0,68553.0,66713.0,58530.0,64241.0,48497.0,59041.0,65575.0,57315.0,62667.0,121303.0,47061.0,78872.0,52813.0,42694.0,57250.0,70771.0,50769.0,61748.0,35061.0,59171.0,88048.0,66972.0,62964.0,73633.0,65473.0,49113.0,107475.0,92359.0,66275.0,51823.0,91680.0,79398.0,41619.0,76594.0,54438.0,79054.0,54693.0,87309.0,44088.0,128036.0,47541.0,53921.0,113179.0,41442.0,128708.0,64430.0,56243.0,46930.0,57154.0,59606.0,87758.0,63724.0,82850.0,116340.0,68172.0,58218.0,76745.0,84500.0,73619.0,51963.0,50985.0,46409.0,52458.0,41299.0,49663.0,52776.0,57000.0,64238.0,69721.0,58049.0,66395.0,64630.0,63455.0,68731.0,66451.0,66111.0,78705.0,55822.0,57519.0,101639.0,64031.0,54375.0,68898.0,85960.0,23077.0,22407.0,25483.0,21560.0,25940.0,18844.0,16506.0,23193.0,21306.0,20133.0,20778.0,17062.0,19827.0]},"kind":"numeric","n":3222,"n_null":0,"n_unique":3099,"null_rate":0.0,"stats":{"iqr":18561.5,"kurtosis":3216.9855744804277,"max":170463.0,"mean":-144603.29733085042,"median":60458.5,"min":-666666666.0,"n_outliers":188,"outlier_rate":0.05834885164494103,"q1":51814.75,"q3":70376.25,"skew":-56.736039686210425,"std":11745920.843247589,"zero_rate":0.0}}],"insights":{"errors":[],"insights":[{"confidence":"high","critiques":[],"evidence_keys":["row_count","column_count","median_household_income.stats.min","median_household_income.stats.max","median_household_income.stats.mean","median_household_income.stats.median","median_household_income.stats.skew","median_household_income.stats.n_outliers","median_household_income.stats.outlier_rate","fips.stats.min","fips.stats.max","county_name.top_words"],"featured_charts":[{"caption":"Look for the long left tail caused by sentinel values like -666,666,666 that distort the mean.","column":"median_household_income","kind":"histogram"},{"caption":"FIPS codes spread evenly from 1,001 to 72,153, confirming national county coverage with no outliers.","column":"fips","kind":"histogram"},{"caption":"County name lengths cluster tightly around 24 characters, reflecting the consistent 'X County, State' format.","column":"county_name","kind":"length"}],"model":"anthropic:claude-opus-4-7","narrative":"This dataset contains 3,222 rows covering U.S. counties, with three columns: a county name, a FIPS code, and median household income. The income column is the headline issue \u2014 it has a minimum of -666,666,666 and a mean of roughly -144,603 against a median of 60,458, indicating a sentinel value (likely a missing-data placeholder) that is dragging the distribution into nonsense. About 5.8% of records (188 rows) are flagged as outliers and skew is extreme (-56.7), so any analysis should filter these sentinels before computing summary stats. County names are essentially unique row labels, while FIPS codes look clean and well-distributed across the expected national range.","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 is a FIPS county/area code\u2014every one of the 3222 rows is unique with no nulls, and the values span 1001 to 72153, the canonical FIPS range covering U.S. states and territories. The distribution is nearly symmetric (skew 0.157, kurtosis -0.631) with no outliers, consistent with a structured geographic identifier rather than a measured quantity. Treat it as a key, not a numeric feature.","role":"identifier","scope":"column","target":"fips","treatment":"Use as a categorical join key on county-level data; do not feed as a numeric feature."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","top_words","len_mean","len_max","vocab_size"],"model":"anthropic:claude-opus-4-7","narrative":"This column holds full US county identifiers (e.g., 'X County, <State>'), with all 3222 rows unique and zero nulls. The token 'county,' appears 2999 times, suggesting ~223 rows use a different suffix (likely 'Parish' in Louisiana, 'Borough'/'Census Area' in Alaska, or independent cities). State-name frequencies match expected US distribution, with Texas (256) leading.","role":"identifier","scope":"column","target":"county_name","treatment":"Use as a join key after splitting into county and state components; do not treat as a feature."},{"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.std","stats.n_outliers","stats.outlier_rate"],"model":"anthropic:claude-opus-4-7","narrative":"County-level median household income in dollars, with 3099 distinct values across 3222 rows and no nulls. The minimum of -666666666 is a clear sentinel for missing data, dragging the mean to -144603 even though the median is 60458.5 and Q1-Q3 sit between 51814.75 and 70376.25. This sentinel produces the extreme skew (-56.74) and kurtosis (3216.99), and 188 outliers (5.83%) are flagged.","role":"feature","scope":"column","target":"median_household_income","treatment":"Replace the -666666666 sentinel with null, then consider a log or robust scaler before modelling."}],"providers":["anthropic:claude-opus-4-7"],"total_usage":{"completion_tokens":1434,"prompt_tokens":3888,"total_tokens":5322}},"language_counts":{},"meta":{"generated_at":"2026-05-01T16:55:05+00:00","mode":"full","row_count":3222,"sampled_rows":3222,"seed":42,"source":"/home/coolhand/html/datavis/data_trove/cache/median_income.parquet"},"notes":[],"saturn_version":"0.2.0","schema":{"county_name":"text","fips":"numeric","median_household_income":"numeric"}}