{"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=+13.38"},{"code":"outliers","level":"warn","message":"14.1% rows beyond 1.5 IQR"}],"column":"total_pop","extras":{"histogram":{"counts":[2942,137,56,39,13,9,7,3,3,4,3,0,2,0,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":[47.0,246711.4,493375.8,740040.2,986704.6,1233369.0,1480033.4,1726697.8,1973362.2,2220026.6,2466691.0,2713355.4,2960019.8,3206684.1999999997,3453348.6,3700013.0,3946677.4,4193341.8,4440006.2,4686670.6,4933335.0,5179999.399999999,5426663.8,5673328.2,5919992.6,6166657.0,6413321.399999999,6659985.8,6906650.2,7153314.6,7399979.0,7646643.399999999,7893307.8,8139972.2,8386636.6,8633301.0,8879965.4,9126629.799999999,9373294.2,9619958.6,9866623.0]},"sample":[56784.0,12929.0,31750.0,18946.0,56945.0,89637.0,10241.0,5016.0,2329.0,31370.0,7652.0,144017.0,210649.0,41437.0,21219.0,24624.0,17821.0,45434.0,22675.0,7778.0,1654106.0,25220.0,279730.0,422849.0,769518.0,2854.0,439325.0,215593.0,13392.0,4234.0,18174.0,9312.0,3515.0,4449.0,30172.0,693511.0,6749.0,356521.0,20344.0,17501.0,329254.0,9782.0,24046.0,1927396.0,186232.0,971845.0,10850.0,1454485.0,159187.0,42985.0,16123.0,156181.0,72494.0,123732.0,42239.0,8236.0,18370.0,16814.0,288174.0,23308.0,2798.0,153471.0,19875.0,27151.0,10257.0,252422.0,2819.0,25906.0,44698.0,76325.0,14757.0,8072.0,58442.0,21469.0,11074.0,10104.0,19622.0,21943.0,194852.0,7655.0,10079.0,68165.0,27167.0,28388.0,8758.0,47.0,4440.0,47770.0,24178.0,2566.0,24317.0,10436.0,5180534.0,10318.0,6161.0,31665.0,52287.0,52686.0,14416.0,27426.0,11238.0,690483.0,281571.0,81355.0,23047.0,78981.0,35428.0,126304.0,45608.0,12362.0,34569.0,19697.0,15097.0,63237.0,3624.0,24679.0,14142.0,20389.0,11308.0,16925.0,16260.0,12202.0,9910.0,33169.0,10098.0,92357.0,97986.0,5809.0,11974.0,22163.0,7675.0,14210.0,2577.0,38460.0,2775.0,28712.0,33789.0,2400.0,5632.0,2511.0,1747.0,13114.0,29324.0,30967.0,15637.0,2509.0,4614.0,65035.0,5024.0,515205.0,5872.0,3508.0,5420.0,166625.0,12664.0,23667.0,82055.0,15582.0,9161.0,8659.0,26022.0,29777.0,92039.0,18604.0,27564.0,57023.0,8461.0,134138.0,5501.0,96357.0,47619.0,19115.0,20529.0,42666.0,12110.0,66063.0,569274.0,271096.0,258939.0,126877.0,70351.0,459639.0,7839.0,62233.0,33637.0,36432.0,403025.0,64436.0,96102.0,171459.0,1265417.0,20538.0,25057.0,67601.0,75034.0,1770251.0,45679.0,106919.0,30016.0,12204.0,5565.0,20775.0,38561.0,20840.0,46847.0,6046.0,25056.0,34079.0,6318.0,13798.0,14387.0,9422.0,49328.0,12560.0,17494.0,201371.0,6739.0,55489.0,69464.0,27362.0,34438.0,23619.0,33623.0,10072.0,55733.0,24654.0,22431.0,27568.0,22626.0,10548.0,80492.0,11689.0,4148.0,12374.0,8633.0,15904.0,10293.0,10786.0,61404.0,22845.0,37548.0,55762.0,1957.0,6922.0,10531.0,1510.0,8617.0,11231.0,105125.0,4893.0,5324.0,8231.0,12489.0,7447.0,8235.0,8208.0,649.0,7077.0,3330.0,4033.0,2826.0,14035.0,4991.0,20712.0,52924.0,7483.0,50277.0,75910.0,29606.0,301419.0,63728.0,108970.0,71343.0,3591.0,46759.0,125655.0,48957.0,210420.0,393572.0,117308.0,159298.0,157890.0,17751.0,1514839.0,26452.0,29499.0,138693.0,85522.0,224718.0,10465.0,48228.0,167837.0,48482.0,226685.0,115358.0,4042.0,62428.0,87299.0,60018.0,13008.0,19242.0,18393.0,2904.0,2116.0,2312.0,5253.0,13948.0,9652.0,2929.0,11221.0,2122.0,51959.0,156187.0,163872.0,14229.0,43478.0,307539.0,60236.0,107729.0,34741.0,18725.0,35200.0,60717.0,12719.0,59029.0,288241.0,27853.0,25567.0,54738.0,11995.0,15355.0,13358.0,10658.0,16260.0,418915.0,110603.0,7395.0,23640.0,339300.0,26643.0,26178.0,1407.0,64960.0,120928.0,639266.0,153728.0,75010.0,64186.0,125197.0,154914.0,85001.0,141239.0,369767.0,69608.0,5701.0,37946.0,82352.0,181488.0,43110.0,23983.0,20642.0,135005.0,523755.0,18072.0,15295.0,8659.0,394581.0,325826.0,3348.0,34410.0,37701.0,2713.0,3911.0,2073.0,28305.0,1318.0,21951.0,13643.0,134767.0,61030.0,49438.0,23503.0,8052.0,11552.0,4965.0,19864.0,45538.0,8598.0,1848.0,30148.0,96113.0,362173.0,13766.0,3206.0,1075700.0,20245.0,5215.0,18187.0,21389.0,6995.0,61674.0,30826.0,116.0,578.0,51837.0,19937.0,21430.0,57520.0,21137.0,9717.0,46887.0,764.0,109869.0,9874.0,2095938.0,862.0,11030.0,44601.0,11236.0,12352.0,44285.0,13776.0,9609.0,11823.0,21374.0,30167.0,49517.0,45559.0,28971.0,14600.0,51409.0,54491.0,8427.0,38193.0,17776.0,20843.0,37982.0,11104.0,8442.0,11862.0,36002.0,25523.0,151789.0,33811.0,28103.0,153544.0,5464.0,23700.0,130075.0,77289.0,32490.0,91700.0,224604.0,91679.0,22165.0,78904.0,2240808.0,10907.0,41758.0,17924.0,12068.0,122448.0,22117.0,20340.0,59036.0,6063.0,13928.0,23609.0,5202.0,15816.0,13263.0,44868.0,4515.0,18918.0,19863.0,25488.0,119009.0,45448.0,37263.0,189152.0,13909.0,17724.0,404861.0,4535.0,2230.0,30791.0,8773.0,46828.0,22978.0,1186.0,11614.0,50428.0,27726.0,8752.0,35044.0,23549.0,5354.0,15893.0,8199.0,33818.0]},"kind":"numeric","n":3222,"n_null":0,"n_unique":3141,"null_rate":0.0,"stats":{"iqr":54579.25,"kurtosis":298.6885711287173,"max":9866623.0,"mean":102232.27063935444,"median":25328.0,"min":47.0,"n_outliers":453,"outlier_rate":0.14059590316573556,"q1":10610.75,"q3":65190.0,"skew":13.377003395066907,"std":326933.68680908735,"zero_rate":0.0}},{"alerts":[{"code":"high_skew","level":"info","message":"skew=+17.81"},{"code":"outliers","level":"warn","message":"11.4% rows beyond 1.5 IQR"}],"column":"uninsured_pop","extras":{"histogram":{"counts":[3022,124,32,16,7,5,5,2,0,1,2,1,0,0,0,1,1,0,0,0,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1],"edges":[0.0,522.875,1045.75,1568.625,2091.5,2614.375,3137.25,3660.125,4183.0,4705.875,5228.75,5751.625,6274.5,6797.375,7320.25,7843.125,8366.0,8888.875,9411.75,9934.625,10457.5,10980.375,11503.25,12026.125,12549.0,13071.875,13594.75,14117.625,14640.5,15163.375,15686.25,16209.125,16732.0,17254.875,17777.75,18300.625,18823.5,19346.375,19869.25,20392.125,20915.0]},"sample":[17.0,43.0,126.0,13.0,0.0,42.0,2.0,7.0,6.0,33.0,81.0,301.0,309.0,15.0,22.0,38.0,39.0,48.0,8.0,23.0,1138.0,50.0,797.0,372.0,440.0,0.0,457.0,63.0,4.0,0.0,0.0,16.0,0.0,2.0,20.0,1394.0,18.0,208.0,18.0,26.0,462.0,72.0,8.0,3821.0,271.0,1941.0,26.0,2020.0,148.0,32.0,23.0,233.0,246.0,34.0,71.0,0.0,86.0,51.0,909.0,13.0,0.0,139.0,14.0,0.0,9.0,407.0,0.0,49.0,33.0,249.0,18.0,52.0,576.0,26.0,10.0,25.0,36.0,11.0,323.0,0.0,30.0,0.0,0.0,56.0,17.0,0.0,0.0,134.0,2.0,0.0,24.0,18.0,5669.0,29.0,13.0,21.0,26.0,226.0,4.0,0.0,14.0,443.0,289.0,26.0,54.0,49.0,111.0,187.0,342.0,0.0,13.0,0.0,8.0,0.0,13.0,13.0,18.0,2.0,0.0,26.0,11.0,2.0,6.0,15.0,0.0,110.0,129.0,0.0,7.0,19.0,21.0,13.0,0.0,64.0,0.0,3.0,131.0,0.0,27.0,0.0,5.0,43.0,28.0,108.0,123.0,6.0,14.0,20.0,0.0,744.0,67.0,11.0,11.0,482.0,92.0,12.0,1.0,52.0,0.0,17.0,7.0,63.0,67.0,7.0,27.0,62.0,37.0,167.0,0.0,37.0,71.0,28.0,0.0,26.0,1.0,176.0,563.0,228.0,227.0,44.0,32.0,349.0,0.0,51.0,34.0,0.0,246.0,87.0,94.0,151.0,709.0,12.0,6.0,26.0,94.0,1624.0,226.0,24.0,87.0,42.0,13.0,16.0,34.0,116.0,84.0,3.0,16.0,54.0,8.0,12.0,8.0,12.0,112.0,4.0,0.0,657.0,0.0,79.0,28.0,56.0,50.0,8.0,36.0,89.0,195.0,53.0,19.0,60.0,59.0,25.0,26.0,68.0,3.0,85.0,58.0,31.0,12.0,16.0,6.0,4.0,43.0,68.0,3.0,79.0,14.0,4.0,0.0,63.0,154.0,7.0,40.0,120.0,34.0,0.0,0.0,0.0,3.0,38.0,11.0,0.0,0.0,54.0,35.0,20.0,197.0,15.0,84.0,37.0,55.0,202.0,15.0,135.0,190.0,6.0,125.0,231.0,132.0,52.0,302.0,140.0,24.0,62.0,15.0,1359.0,20.0,17.0,148.0,65.0,177.0,0.0,8.0,422.0,118.0,391.0,104.0,0.0,35.0,217.0,337.0,28.0,0.0,2.0,20.0,19.0,6.0,5.0,304.0,27.0,2.0,171.0,7.0,375.0,96.0,149.0,97.0,1294.0,671.0,48.0,227.0,83.0,33.0,15.0,120.0,35.0,71.0,459.0,31.0,154.0,44.0,32.0,80.0,28.0,38.0,2.0,344.0,120.0,0.0,24.0,435.0,0.0,15.0,0.0,112.0,221.0,374.0,319.0,86.0,84.0,132.0,709.0,109.0,533.0,306.0,133.0,4.0,53.0,93.0,215.0,7.0,35.0,30.0,70.0,904.0,46.0,37.0,0.0,554.0,529.0,30.0,35.0,5.0,32.0,0.0,0.0,56.0,0.0,40.0,60.0,278.0,47.0,10.0,8.0,15.0,0.0,0.0,11.0,324.0,36.0,0.0,55.0,519.0,1000.0,3.0,0.0,1875.0,80.0,13.0,10.0,300.0,0.0,225.0,130.0,0.0,0.0,265.0,23.0,25.0,250.0,97.0,147.0,136.0,0.0,267.0,0.0,8728.0,0.0,150.0,172.0,63.0,0.0,126.0,35.0,22.0,25.0,27.0,7.0,30.0,0.0,31.0,19.0,76.0,23.0,0.0,9.0,0.0,7.0,0.0,0.0,0.0,63.0,0.0,70.0,352.0,0.0,0.0,175.0,0.0,0.0,162.0,49.0,13.0,226.0,225.0,221.0,18.0,52.0,1618.0,19.0,11.0,33.0,22.0,122.0,23.0,0.0,102.0,0.0,0.0,10.0,0.0,11.0,11.0,39.0,0.0,100.0,48.0,6.0,215.0,221.0,8.0,262.0,12.0,23.0,288.0,18.0,3.0,0.0,20.0,0.0,0.0,0.0,0.0,58.0,0.0,0.0,52.0,0.0,0.0,11.0,0.0,0.0]},"kind":"numeric","n":3222,"n_null":0,"n_unique":584,"null_rate":0.0,"stats":{"iqr":113.0,"kurtosis":462.86639500115115,"max":20915.0,"mean":159.94506517690874,"median":36.0,"min":0.0,"n_outliers":368,"outlier_rate":0.11421477343265053,"q1":7.0,"q3":120.0,"skew":17.811405035086793,"std":627.162840070579,"zero_rate":0.17225325884543763}},{"alerts":[{"code":"high_skew","level":"info","message":"skew=+4.10"},{"code":"outliers","level":"warn","message":"7.1% rows beyond 1.5 IQR"}],"column":"uninsured_rate","extras":{"histogram":{"counts":[1403,704,403,213,158,101,65,43,27,23,9,15,14,5,7,7,5,2,4,1,1,1,2,2,1,0,0,1,0,1,0,1,1,0,1,0,0,0,0,1],"edges":[0.0,0.0925,0.185,0.27749999999999997,0.37,0.4625,0.5549999999999999,0.6475,0.74,0.8325,0.925,1.0175,1.1099999999999999,1.2025,1.295,1.3875,1.48,1.5725,1.665,1.7575,1.85,1.9425,2.035,2.1275,2.2199999999999998,2.3125,2.405,2.4975,2.59,2.6825,2.775,2.8675,2.96,3.0524999999999998,3.145,3.2375,3.33,3.4225,3.515,3.6075,3.7]},"sample":[0.03,0.33,0.4,0.07,0.0,0.05,0.02,0.14,0.26,0.11,1.06,0.21,0.15,0.04,0.1,0.15,0.22,0.11,0.04,0.3,0.07,0.2,0.28,0.09,0.06,0.0,0.1,0.03,0.03,0.0,0.0,0.17,0.0,0.04,0.07,0.2,0.27,0.06,0.09,0.15,0.14,0.74,0.03,0.2,0.15,0.2,0.24,0.14,0.09,0.07,0.14,0.15,0.34,0.03,0.17,0.0,0.47,0.3,0.32,0.06,0.0,0.09,0.07,0.0,0.09,0.16,0.0,0.19,0.07,0.33,0.12,0.64,0.99,0.12,0.09,0.25,0.18,0.05,0.17,0.0,0.3,0.0,0.0,0.2,0.19,0.0,0.0,0.28,0.01,0.0,0.1,0.17,0.11,0.28,0.21,0.07,0.05,0.43,0.03,0.0,0.12,0.06,0.1,0.03,0.23,0.06,0.31,0.15,0.75,0.0,0.04,0.0,0.05,0.0,0.36,0.05,0.13,0.01,0.0,0.15,0.07,0.02,0.06,0.05,0.0,0.12,0.13,0.0,0.06,0.09,0.27,0.09,0.0,0.17,0.0,0.01,0.39,0.0,0.48,0.0,0.29,0.33,0.1,0.35,0.79,0.24,0.3,0.03,0.0,0.14,1.14,0.31,0.2,0.29,0.73,0.05,0.0,0.33,0.0,0.2,0.03,0.21,0.07,0.04,0.1,0.11,0.44,0.12,0.0,0.04,0.15,0.15,0.0,0.06,0.01,0.27,0.1,0.08,0.09,0.03,0.05,0.08,0.0,0.08,0.1,0.0,0.06,0.14,0.1,0.09,0.06,0.06,0.02,0.04,0.13,0.09,0.49,0.02,0.29,0.34,0.23,0.08,0.09,0.56,0.18,0.05,0.06,0.16,0.13,0.09,0.06,0.13,0.23,0.03,0.0,0.33,0.0,0.14,0.04,0.2,0.15,0.03,0.11,0.88,0.35,0.21,0.08,0.22,0.26,0.24,0.03,0.58,0.07,0.69,0.67,0.19,0.12,0.15,0.01,0.02,0.11,0.12,0.15,1.14,0.13,0.26,0.0,0.56,0.15,0.14,0.75,1.46,0.27,0.0,0.0,0.0,0.46,0.54,0.33,0.0,0.0,0.38,0.7,0.1,0.37,0.2,0.17,0.05,0.19,0.07,0.02,0.12,0.27,0.17,0.27,0.18,0.27,0.02,0.08,0.12,0.02,0.04,0.08,0.09,0.08,0.06,0.11,0.08,0.08,0.0,0.02,0.25,0.24,0.17,0.09,0.0,0.06,0.25,0.56,0.22,0.0,0.01,0.69,0.9,0.26,0.1,2.18,0.28,0.07,1.52,0.33,0.72,0.06,0.09,0.68,2.98,0.22,0.08,0.21,0.24,0.18,0.04,0.2,0.28,0.12,0.16,0.11,0.6,0.08,0.27,0.52,0.21,0.36,0.01,0.08,0.11,0.0,0.1,0.13,0.0,0.06,0.0,0.17,0.18,0.06,0.21,0.11,0.13,0.11,0.46,0.13,0.38,0.08,0.19,0.07,0.14,0.11,0.12,0.02,0.15,0.15,0.05,0.17,0.25,0.24,0.0,0.14,0.16,0.9,0.1,0.01,1.18,0.0,0.0,0.2,0.0,0.18,0.44,0.21,0.08,0.02,0.03,0.19,0.0,0.0,0.06,0.71,0.42,0.0,0.18,0.54,0.28,0.02,0.0,0.17,0.4,0.25,0.05,1.4,0.0,0.36,0.42,0.0,0.0,0.51,0.12,0.12,0.43,0.46,1.51,0.29,0.0,0.24,0.0,0.42,0.0,1.36,0.39,0.56,0.0,0.28,0.25,0.23,0.21,0.13,0.02,0.06,0.0,0.11,0.13,0.15,0.04,0.0,0.02,0.0,0.03,0.0,0.0,0.0,0.53,0.0,0.27,0.23,0.0,0.0,0.11,0.0,0.0,0.12,0.06,0.04,0.25,0.1,0.24,0.08,0.07,0.07,0.17,0.03,0.18,0.18,0.1,0.1,0.0,0.17,0.0,0.0,0.04,0.0,0.07,0.08,0.09,0.0,0.53,0.24,0.02,0.18,0.49,0.02,0.14,0.09,0.13,0.07,0.4,0.13,0.0,0.23,0.0,0.0,0.0,0.0,0.12,0.0,0.0,0.15,0.0,0.0,0.07,0.0,0.0]},"kind":"numeric","n":3222,"n_null":0,"n_unique":152,"null_rate":0.0,"stats":{"iqr":0.21,"kurtosis":27.70323429627395,"max":3.7,"mean":0.2001800124146493,"median":0.12,"min":0.0,"n_outliers":230,"outlier_rate":0.07138423339540657,"q1":0.04,"q3":0.25,"skew":4.09534498139569,"std":0.2828642780760536,"zero_rate":0.17535692116697704}},{"alerts":[{"code":"high_skew","level":"info","message":"skew=+2.10"}],"column":"poverty_rate","extras":{"histogram":{"counts":[7,34,106,246,320,354,393,364,306,262,192,149,123,91,52,44,34,23,18,14,6,8,3,8,5,9,4,11,7,8,2,6,5,5,1,0,0,0,1,1],"edges":[1.6,3.218,4.836,6.453999999999999,8.072,9.69,11.307999999999998,12.925999999999998,14.543999999999999,16.162,17.78,19.398,21.016,22.634,24.252,25.87,27.488,29.105999999999998,30.724,32.342,33.96,35.577999999999996,37.196,38.814,40.431999999999995,42.05,43.668,45.286,46.903999999999996,48.522,50.14,51.757999999999996,53.376,54.994,56.611999999999995,58.23,59.848,61.465999999999994,63.083999999999996,64.702,66.32]},"sample":[15.88,14.86,16.62,25.01,22.03,10.92,26.76,9.58,11.55,6.9,18.48,16.88,16.01,13.53,19.99,14.12,13.55,17.56,20.95,26.57,9.15,14.29,18.52,12.32,12.88,12.58,9.0,17.42,8.15,27.07,11.78,6.62,22.53,24.19,15.03,9.21,20.6,11.45,11.69,6.8,9.68,14.04,18.18,12.42,10.49,14.34,26.42,13.68,11.43,15.66,22.45,10.52,22.85,9.26,14.41,27.51,13.18,26.49,13.98,19.93,25.73,7.19,23.55,9.64,21.25,4.6,15.53,19.8,13.56,8.14,13.35,21.86,15.36,16.14,20.32,26.22,15.26,16.03,20.72,28.96,31.34,19.18,22.44,18.15,21.82,14.89,14.58,10.39,6.93,22.14,14.74,18.13,13.38,9.75,14.17,13.38,5.98,22.96,13.45,12.53,13.34,6.65,16.08,11.51,16.37,9.37,13.21,14.14,10.83,12.76,8.91,7.21,12.07,6.06,9.47,6.56,11.83,7.8,13.34,13.02,16.98,5.94,12.21,7.69,14.49,11.33,19.63,8.54,11.89,7.49,13.17,12.79,15.24,20.9,13.61,15.29,11.87,9.93,4.11,7.89,8.79,7.92,10.63,16.9,14.96,10.92,10.12,22.73,7.61,13.66,10.49,7.32,9.93,16.84,23.13,26.29,10.58,26.1,20.28,16.82,21.06,34.04,16.12,22.48,23.83,9.28,13.7,17.17,40.28,16.55,29.7,24.03,26.83,18.05,19.64,14.95,5.83,6.16,7.14,10.97,11.96,15.77,10.25,8.34,16.47,13.25,16.25,23.61,11.08,12.92,7.7,17.07,10.67,11.01,14.15,20.19,16.14,3.78,12.23,11.22,8.58,4.94,8.51,8.71,9.09,10.11,12.36,10.34,8.94,9.63,10.39,8.79,14.02,27.05,23.56,18.38,31.78,19.64,24.85,32.2,22.33,22.82,16.74,23.2,15.76,16.32,28.68,12.32,29.13,14.92,14.52,19.62,9.44,12.06,22.47,15.81,12.34,20.58,17.62,12.99,15.57,16.41,16.57,20.19,10.25,12.19,7.49,14.76,9.27,11.85,5.23,20.37,16.33,12.33,5.43,12.97,10.79,11.1,10.03,6.27,8.68,11.32,10.83,7.97,10.4,9.24,8.0,9.0,11.61,7.47,13.03,7.74,17.77,17.81,17.05,17.54,15.11,12.97,13.01,17.13,11.47,11.59,15.75,6.49,14.12,24.42,9.08,16.95,8.41,5.87,21.09,13.93,22.04,12.43,11.38,29.91,15.99,9.27,11.7,13.32,11.01,15.28,10.72,6.62,10.21,10.28,13.39,6.86,10.85,15.78,13.71,11.74,8.71,10.6,15.43,8.95,13.5,16.08,8.46,10.58,9.42,15.34,5.17,19.07,14.15,12.84,16.04,14.7,11.01,20.84,18.78,14.62,12.52,13.72,7.58,14.87,12.13,12.68,12.99,12.5,11.69,9.86,10.37,13.2,5.63,17.04,13.75,15.31,16.2,9.0,12.35,10.91,11.95,10.84,12.22,11.59,7.77,10.36,20.32,16.97,18.72,17.82,10.92,19.98,27.78,16.68,16.83,14.42,29.6,12.48,10.55,14.52,7.32,23.83,7.44,8.49,7.98,26.01,8.6,12.64,13.92,17.56,13.38,19.71,20.99,14.85,15.63,12.29,5.9,11.94,11.94,7.53,8.79,16.51,6.32,7.45,14.11,12.66,12.66,9.98,8.87,14.5,2.59,7.96,12.54,10.24,11.31,23.44,13.48,9.51,16.37,14.74,4.17,17.31,11.02,6.38,22.35,16.2,13.62,18.39,12.63,37.19,15.68,8.56,11.74,11.81,10.37,12.56,15.24,5.4,7.33,13.25,12.93,9.76,8.02,25.98,10.86,13.04,6.84,16.74,12.99,19.32,5.38,19.91,17.21,8.82,17.32,10.0,13.46,17.53,22.21,17.36,19.47,9.43,16.09,6.84,8.45,11.64,18.85,10.99,8.63,10.94,11.04,19.18,18.77,16.35,21.08,17.83,20.29,16.64,8.23,10.98,9.8,12.78,12.71,14.69,11.78,11.58,9.56,6.91,13.56,13.24,4.95,16.08,18.34,8.68,8.07,42.15,45.61,23.52,47.36,37.12,55.97,52.81,39.12,45.35,52.02,48.49,54.07,43.67]},"kind":"numeric","n":3222,"n_null":0,"n_unique":1719,"null_rate":0.0,"stats":{"iqr":7.75,"kurtosis":6.890992451669181,"max":66.32,"mean":15.100406579764124,"median":13.55,"min":1.6,"n_outliers":137,"outlier_rate":0.04252017380509,"q1":10.16,"q3":17.91,"skew":2.0959367375026883,"std":7.705602319057618,"zero_rate":0.0}},{"alerts":[],"column":"rural","extras":{"singletons":0,"top_values":[["True",2212],["False",1010]]},"kind":"categorical","n":3222,"n_null":0,"n_unique":2,"null_rate":0.0,"stats":{"cardinality":2,"entropy":0.8971383342699701,"entropy_ratio":0.8971383342699701,"top_rate":0.686530105524519,"top_value":"True"}},{"alerts":[],"column":"rural_category","extras":{"singletons":0,"top_values":[["Rural",2212],["Urban/Suburban",1010]]},"kind":"categorical","n":3222,"n_null":0,"n_unique":2,"null_rate":0.0,"stats":{"cardinality":2,"entropy":0.8971383342699701,"entropy_ratio":0.8971383342699701,"top_rate":0.686530105524519,"top_value":"Rural"}},{"alerts":[],"column":"hospital_closure_risk_score","extras":{"histogram":{"counts":[929,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1790,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,503],"edges":[0.0,1.25,2.5,3.75,5.0,6.25,7.5,8.75,10.0,11.25,12.5,13.75,15.0,16.25,17.5,18.75,20.0,21.25,22.5,23.75,25.0,26.25,27.5,28.75,30.0,31.25,32.5,33.75,35.0,36.25,37.5,38.75,40.0,41.25,42.5,43.75,45.0,46.25,47.5,48.75,50.0]},"sample":[0.0,25.0,25.0,50.0,25.0,0.0,50.0,25.0,25.0,25.0,25.0,0.0,0.0,25.0,25.0,25.0,25.0,25.0,50.0,50.0,0.0,25.0,0.0,0.0,0.0,25.0,0.0,0.0,25.0,50.0,25.0,25.0,50.0,50.0,25.0,0.0,50.0,0.0,25.0,25.0,0.0,25.0,25.0,0.0,0.0,0.0,50.0,0.0,0.0,25.0,50.0,0.0,25.0,0.0,25.0,50.0,25.0,50.0,0.0,25.0,50.0,0.0,50.0,25.0,50.0,0.0,25.0,25.0,25.0,0.0,25.0,50.0,0.0,25.0,50.0,50.0,25.0,25.0,25.0,50.0,50.0,0.0,50.0,25.0,50.0,25.0,25.0,25.0,25.0,50.0,25.0,25.0,0.0,25.0,25.0,25.0,0.0,25.0,25.0,25.0,25.0,0.0,0.0,0.0,25.0,0.0,25.0,0.0,25.0,25.0,25.0,25.0,25.0,0.0,25.0,25.0,25.0,25.0,25.0,25.0,25.0,25.0,25.0,25.0,25.0,0.0,0.0,25.0,25.0,25.0,25.0,25.0,25.0,50.0,25.0,25.0,25.0,25.0,25.0,25.0,25.0,25.0,25.0,25.0,25.0,25.0,25.0,25.0,25.0,0.0,25.0,25.0,25.0,0.0,50.0,50.0,0.0,50.0,50.0,25.0,50.0,50.0,0.0,50.0,50.0,0.0,25.0,0.0,50.0,0.0,50.0,50.0,50.0,25.0,25.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,25.0,0.0,25.0,25.0,0.0,25.0,0.0,0.0,0.0,25.0,25.0,0.0,0.0,25.0,25.0,0.0,25.0,25.0,25.0,25.0,25.0,25.0,25.0,25.0,25.0,25.0,25.0,25.0,25.0,25.0,25.0,50.0,50.0,0.0,50.0,0.0,25.0,50.0,50.0,50.0,25.0,50.0,0.0,25.0,50.0,25.0,50.0,25.0,0.0,25.0,25.0,25.0,50.0,25.0,25.0,50.0,0.0,25.0,25.0,0.0,25.0,50.0,25.0,25.0,25.0,25.0,0.0,25.0,25.0,50.0,25.0,25.0,25.0,25.0,25.0,25.0,25.0,25.0,25.0,25.0,25.0,25.0,0.0,25.0,0.0,0.0,25.0,0.0,0.0,0.0,0.0,25.0,25.0,0.0,25.0,0.0,0.0,0.0,0.0,0.0,25.0,0.0,25.0,50.0,0.0,0.0,0.0,25.0,25.0,0.0,50.0,0.0,0.0,50.0,0.0,0.0,0.0,25.0,25.0,25.0,25.0,25.0,25.0,25.0,25.0,25.0,25.0,25.0,25.0,0.0,0.0,0.0,25.0,25.0,0.0,0.0,0.0,25.0,25.0,25.0,0.0,25.0,0.0,0.0,25.0,25.0,0.0,50.0,25.0,25.0,25.0,25.0,0.0,0.0,25.0,25.0,0.0,25.0,25.0,25.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,25.0,25.0,0.0,0.0,50.0,25.0,25.0,0.0,0.0,25.0,50.0,25.0,0.0,0.0,50.0,25.0,25.0,25.0,25.0,50.0,25.0,25.0,25.0,50.0,0.0,0.0,0.0,25.0,25.0,25.0,50.0,25.0,0.0,25.0,25.0,25.0,0.0,0.0,25.0,25.0,0.0,25.0,25.0,25.0,25.0,25.0,0.0,25.0,25.0,25.0,0.0,25.0,25.0,25.0,25.0,25.0,0.0,25.0,0.0,25.0,0.0,25.0,50.0,25.0,25.0,25.0,25.0,50.0,25.0,25.0,25.0,25.0,0.0,25.0,25.0,25.0,0.0,0.0,25.0,25.0,25.0,50.0,25.0,25.0,25.0,25.0,25.0,25.0,0.0,25.0,25.0,0.0,25.0,25.0,0.0,0.0,50.0,0.0,0.0,0.0,25.0,0.0,0.0,25.0,25.0,25.0,25.0,0.0,25.0,25.0,0.0,25.0,50.0,25.0,50.0,25.0,25.0,25.0,25.0,25.0,25.0,25.0,0.0,25.0,25.0,0.0,25.0,25.0,0.0,25.0,25.0,25.0,25.0,50.0,50.0,50.0,50.0,25.0,50.0,50.0,50.0,50.0,50.0,50.0,50.0,50.0]},"kind":"numeric","n":3222,"n_null":0,"n_unique":3,"null_rate":0.0,"stats":{"iqr":25.0,"kurtosis":-0.6948719768000422,"max":50.0,"mean":21.69459962756052,"median":25.0,"min":0.0,"n_outliers":0,"outlier_rate":0.0,"q1":0.0,"q3":25.0,"skew":0.14140182496893314,"std":16.338144134248562,"zero_rate":0.2883302296710118}},{"alerts":[],"column":"risk_category","extras":{"singletons":0,"top_values":[["Low",2719],["Moderate",503]]},"kind":"categorical","n":3222,"n_null":0,"n_unique":2,"null_rate":0.0,"stats":{"cardinality":2,"entropy":0.6249319443727691,"entropy_ratio":0.6249319443727691,"top_rate":0.8438857852265673,"top_value":"Low"}}],"insights":{"errors":[],"insights":[{"confidence":"high","critiques":[],"evidence_keys":["row_count","column_count","total_pop.stats.median","total_pop.stats.max","uninsured_pop.stats.median","uninsured_pop.stats.max","uninsured_rate.stats.max","uninsured_rate.stats.median","hospital_closure_risk_score.n_unique","hospital_closure_risk_score.stats.zero_rate","risk_category.top_value","risk_category.top_rate","rural_category.top_value","rural_category.top_rate","poverty_rate.stats.median","poverty_rate.stats.max"],"featured_charts":[{"caption":"Look for the heavy right tail \u2014 most counties cluster near low uninsured rates, but extreme outliers signal counties with severe coverage gaps.","column":"uninsured_rate","kind":"histogram"},{"caption":"Notice how overwhelmingly 'Low' dominates \u2014 only about 16% of counties carry Moderate hospital closure risk.","column":"risk_category","kind":"donut"},{"caption":"Nearly 7 in 10 counties are Rural, which sets important context for interpreting healthcare access shortfalls across the dataset.","column":"rural_category","kind":"donut"},{"caption":"The distribution is right-skewed with a median near 13.6% \u2014 watch for the tail of counties exceeding 40\u201366% poverty rates.","column":"poverty_rate","kind":"histogram"},{"caption":"With only 3 unique values (0, 25, 50), this chart reveals that nearly 29% of counties score zero, suggesting a coarse or binary underlying measure.","column":"hospital_closure_risk_score","kind":"bar"}],"model":"anthropic:default","narrative":"This dataset covers healthcare access indicators for 3,222 U.S. counties, combining population size, uninsured rates, poverty rates, and hospital closure risk scores. The most striking pattern is the extreme skew in both total population and uninsured population \u2014 the median county has just 25,328 residents and 36 uninsured individuals, yet outliers push the max to nearly 10 million people and over 20,000 uninsured, meaning a small number of large counties dominate the raw counts. Two things warrant a closer look: first, 84% of counties are rated 'Low' hospital closure risk, but nearly 29% score exactly zero on the closure risk score, suggesting the scoring may be coarser than it appears (only 3 unique values exist); second, 69% of counties are classified as Rural, yet uninsured rates range from 0% to 370% of expected norms with heavy right skew, pointing to pockets of severe coverage gaps worth isolating geographically.","scope":"dataset","target":"__global__"},{"confidence":"high","critiques":[],"evidence_keys":["skew","kurtosis","median","mean","max","min","std","n_outliers","outlier_rate"],"model":"anthropic:default","narrative":"This column represents total population counts across geographic units (likely counties, census tracts, or similar administrative areas). The distribution is severely right-skewed (skew=13.38, kurtosis=298.69): the median is 25,328 while the mean is 102,232, indicating a long tail driven by a small number of very large population centers \u2014 the maximum of 9,866,623 is roughly 390\u00d7 the median. With 453 outliers (14.1% of rows) and a standard deviation of 326,934, raw values will distort any distance- or variance-sensitive model.","role":"feature","scope":"column","target":"total_pop","treatment":"Log-transform (log1p) before modelling to compress the extreme right tail."},{"confidence":"high","critiques":[],"evidence_keys":["skew","kurtosis","median","mean","max","zero_rate","outlier_rate","n_outliers","q1","q3","iqr"],"model":"anthropic:default","narrative":"This column represents the count of uninsured individuals in a population unit (likely a census tract, zip code, or similar geographic subdivision). The distribution is extremely right-skewed (skew=17.81, kurtosis=462.87): the median is just 36 while the mean is 159.95 and the max reaches 20,915, indicating a small number of very large geographic units dominate the tail. Notably, 17.2% of rows have a zero value and 11.4% are flagged as outliers (368 rows), suggesting a mix of very small or fully-insured areas alongside a few densely populated uninsured concentrations.","role":"feature","scope":"column","target":"uninsured_pop","treatment":"Log-transform (e.g., log1p) before regression or clustering to reduce skew; consider normalizing by total population to produce an uninsured rate."},{"confidence":"medium","critiques":[],"evidence_keys":["stats.skew","stats.kurtosis","stats.max","stats.median","stats.mean","stats.zero_rate","stats.n_outliers","stats.outlier_rate","n_unique","n","alerts"],"model":"anthropic:default","narrative":"This column represents an uninsured rate, likely a proportion or percentage of a population lacking insurance coverage (e.g., health, auto, or similar) at some geographic or demographic unit level. With only 152 unique values across 3,222 rows, the data appears discretized or rounded. The distribution is severely right-skewed (skew 4.10, kurtosis 27.70) with a median of 0.12 but a mean of 0.20 and a max of 3.7 \u2014 the max value exceeding 1.0 is surprising if this is a true rate/proportion, suggesting either a percentage-scale mix, a non-standard encoding, or genuine outliers among the 230 flagged cases (7.1% of rows). The 17.5% zero rate also warrants investigation as it may indicate missing data coded as zero or genuinely uninsured-free units.","role":"feature","scope":"column","target":"uninsured_rate","treatment":"Investigate values > 1.0 for scale inconsistency, recode zeros if they represent missingness, then log-transform or apply a bounded transformation before modelling."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","duplicate_rate","top_words","len_mean","word_mean","alerts"],"model":"anthropic:default","narrative":"This column contains fully-qualified county name strings, almost certainly formatted as '<County Name> County, <State>' \u2014 evidenced by the word 'county,' appearing in 2,999 of 3,222 rows and a mean string length of ~24 characters with a mean word count of ~3.25. Every row is unique (n_unique = 3,222, duplicate_rate = 0.0), triggering the near-unique alert, which is expected for a geographic identifier combining county and state. The state distribution skews toward Texas (256), Virginia (189), and Georgia (159), suggesting those states are overrepresented in the dataset.","role":"label","scope":"column","target":"county_name","treatment":"Parse into county and state components for join or groupby operations; do not treat as a free-text feature."},{"confidence":"high","critiques":[],"evidence_keys":["skew","kurtosis","median","mean","max","n_outliers","outlier_rate","null_rate","n","n_unique"],"model":"anthropic:default","narrative":"This column represents a poverty rate measure (likely percentage of population below a poverty threshold) across 3,222 records with no nulls and a reasonable 1,719 unique values. The distribution is heavily right-skewed (skew = 2.10, kurtosis = 6.89), with a median of 13.55% but a mean pulled up to 15.10% by a long upper tail reaching 66.32% \u2014 more than 4\u00d7 the median. There are 137 flagged outliers (4.25% of rows), concentrated in that upper tail, which likely represent unusually deprived geographic units or communities and warrant special attention in any model.","role":"feature","scope":"column","target":"poverty_rate","treatment":"Log-transform or apply a Box-Cox transformation before regression to reduce skew; inspect the 137 outliers above the upper fence for data quality or genuine extreme cases."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","min","max","skew","kurtosis","zero_rate"],"model":"anthropic:default","narrative":"This column contains US FIPS (Federal Information Processing Standard) county codes, which are 4\u20135 digit numeric identifiers assigned to every US county. Every one of the 3,222 rows has a unique FIPS code with no nulls, matching almost exactly the ~3,143 US counties plus territories (the max of 72153 indicates Puerto Rico territory codes are included). Despite being stored as a numeric type, FIPS codes are categorical identifiers \u2014 arithmetic on them is meaningless \u2014 and the near-uniform distribution (low skew of 0.157, kurtosis of -0.63) simply reflects the sequential geographic assignment of codes.","role":"identifier","scope":"column","target":"fips","treatment":"Cast to string/categorical and use as a geographic join key; do not use as a numeric feature."},{"confidence":"high","critiques":[],"evidence_keys":["n_unique","min","max","median","q1","q3","zero_rate","skew","n_outliers","n"],"model":"anthropic:default","narrative":"This column purports to be a continuous risk score but contains only 3 unique values across 3,222 rows \u2014 almost certainly 0, 25, and 50, matching the min, Q1/median, and max exactly. This makes it a de-facto ordinal categorical variable (low/medium/high) despite its numeric framing. Notably, 28.8% of records are zero, and the near-symmetric distribution (skew 0.14) with no outliers further confirms a discrete tier structure rather than a true continuous score.","role":"feature","scope":"column","target":"hospital_closure_risk_score","treatment":"Treat as ordinal categorical with three levels (0/25/50); one-hot encode or ordinal-encode before modelling rather than using raw numeric values."},{"confidence":"high","critiques":[],"evidence_keys":["n_unique","top_value","top_rate","top_values","null_rate","cardinality"],"model":"anthropic:default","narrative":"This column is a binary risk classification label with exactly two categories: 'Low' and 'Moderate'. The distribution is heavily skewed \u2014 'Low' accounts for 84.4% of all 3,222 rows (2,719 records), leaving only 503 'Moderate' cases. The complete absence of higher risk tiers (e.g., 'High', 'Critical') is notable and may indicate data filtering, a low-risk population, or an incomplete taxonomy. With zero nulls and only two values, the column is clean but class-imbalanced.","role":"label","scope":"column","target":"risk_category","treatment":"Encode as binary (0/1) and apply class-imbalance handling (e.g., SMOTE or class weights) before modelling."},{"confidence":"high","critiques":[],"evidence_keys":["n_unique","top_value","top_rate","top_values","null_rate","entropy_ratio"],"model":"anthropic:default","narrative":"This column is a binary flag indicating whether a record is associated with a rural location, stored as string 'True'/'False' rather than a native boolean. The dominant class is 'True' (2,212 of 3,222 rows, ~68.7%), meaning the dataset is notably skewed toward rural records \u2014 analysts should account for this class imbalance in any comparative or predictive analysis.","role":"feature","scope":"column","target":"rural","treatment":"Cast to boolean, then use as a binary feature or stratification variable; monitor class imbalance (~2:1 rural vs. non-rural) during modelling."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","top_value","top_rate","top_values","entropy_ratio"],"model":"anthropic:default","narrative":"This column is a binary geographic classification indicating whether a record is from a Rural or Urban/Suburban setting. Across 3,222 records with no nulls, 'Rural' dominates at 68.7% (2,212 records) versus 'Urban/Suburban' at 31.3% (1,010 records), representing a meaningful class imbalance. The entropy ratio of 0.897 confirms the distribution is moderately skewed but not extreme. Analysts should be aware this imbalance could bias models trained without stratification or reweighting.","role":"label","scope":"column","target":"rural_category","treatment":"One-hot or binary encode; consider stratified sampling or class weighting to address 69/31 imbalance."}],"providers":["anthropic:default"],"total_usage":{"completion_tokens":3282,"prompt_tokens":8514,"total_tokens":11796}},"language_counts":{},"meta":{"generated_at":"2026-06-22T00:10:44+00:00","mode":"full","row_count":3222,"sampled_rows":3222,"seed":42,"source":"/home/coolhand/html/datavis/data_trove/data/healthcare/healthcare_desert_merged.csv"},"notes":[],"saturn_version":"0.2.0","schema":{"county_name":"text","fips":"numeric","hospital_closure_risk_score":"numeric","poverty_rate":"numeric","risk_category":"categorical","rural":"boolean","rural_category":"categorical","total_pop":"numeric","uninsured_pop":"numeric","uninsured_rate":"numeric"}}
