{"columns":[{"alerts":[{"code":"near_unique","level":"info","message":"100.0% of rows are unique strings"},{"code":"one_word","level":"warn","message":"100.0% rows are a single word"},{"code":"allcaps","level":"info","message":"100.0% rows are all-caps"},{"code":"short_text","level":"info","message":"95th-percentile length under 20 chars"}],"column":"fips","extras":{"language_counts":{},"language_sample_size":3222,"length_histogram":{"counts":[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3222,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0],"edges":[4.5,4.525,4.55,4.575,4.6,4.625,4.65,4.675,4.7,4.725,4.75,4.775,4.8,4.825,4.85,4.875,4.9,4.925,4.95,4.975,5.0,5.025,5.05,5.075,5.1,5.125,5.15,5.175,5.2,5.225,5.25,5.275,5.3,5.325,5.35,5.375,5.4,5.425,5.45,5.475,5.5]},"near_unique":true,"sample":["01007","47021","49031","48279","27091","56033","28017","51165","48291","05019","37125","31109","20017","01049","20107","16087","08109","48371","72109","26129","20201","05055","13279","12001","42021","47089","34019","17043","08009","56023","39145","40011","01063","26069","22115","28011","54057","30093","28085","31107","48221","53063","20039","53055","55063","72007","22013","26087","13293","51057"],"top_values":[],"top_words":[["01001",1],["01003",1],["01005",1],["01007",1],["01009",1],["01011",1],["01013",1],["01015",1],["01017",1],["01019",1],["01021",1],["01023",1],["01025",1],["01027",1],["01029",1],["01031",1],["01033",1],["01035",1],["01037",1],["01039",1],["01041",1],["01043",1],["01045",1],["01047",1],["01049",1]],"vocab_skipped":null,"word_histogram":{"counts":[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3222,0,0,0,0,0,0,0,0,0,0,0,0,0,0],"edges":[0.5,0.5333333333333333,0.5666666666666667,0.6,0.6333333333333333,0.6666666666666666,0.7,0.7333333333333334,0.7666666666666666,0.8,0.8333333333333333,0.8666666666666667,0.9,0.9333333333333333,0.9666666666666667,1.0,1.0333333333333332,1.0666666666666667,1.1,1.1333333333333333,1.1666666666666665,1.2,1.2333333333333334,1.2666666666666666,1.3,1.3333333333333335,1.3666666666666667,1.4,1.4333333333333333,1.4666666666666668,1.5]}},"kind":"text","n":3222,"n_null":0,"n_unique":3222,"null_rate":0.0,"stats":{"allcaps_rate":1.0,"boilerplate_rate":0.0,"duplicate_rate":0.0,"emoji_rate":0.0,"len_max":5,"len_mean":5.0,"len_median":5.0,"len_min":5,"len_p95":5.0,"n_duplicates":0,"n_empty":0,"one_word_rate":1.0,"readability_flesch_mean":121.22000000000004,"url_rate":0.0,"vocab_size":3222,"word_mean":1.0,"word_median":1.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}}],"insights":{"errors":[],"insights":[{"confidence":"high","critiques":[],"evidence_keys":["row_count","column_count","columns.total_pop.stats.skew","columns.total_pop.stats.median","columns.total_pop.stats.max","columns.total_pop.stats.n_outliers","columns.uninsured_pop.stats.skew","columns.uninsured_pop.stats.zero_rate","columns.uninsured_rate.stats.median","columns.uninsured_rate.stats.max","columns.uninsured_rate.stats.zero_rate","columns.county_name.top_words"],"featured_charts":[{"caption":"Look for the extreme right skew \u2014 most counties are small but a few exceed a million residents.","column":"total_pop","kind":"histogram"},{"caption":"Check the distribution around the 0.12 median and the tail of high-rate outliers up to 3.7.","column":"uninsured_rate","kind":"histogram"},{"caption":"Note how raw uninsured counts concentrate near zero with a long tail driven by populous counties.","column":"uninsured_pop","kind":"histogram"},{"caption":"Top words reveal which states contribute the most counties, led by Texas, Virginia, and Georgia.","column":"county_name","kind":"bar"}],"model":"anthropic:claude-opus-4-7","narrative":"This dataset covers 3,222 U.S. counties (one row per FIPS code) with population totals and uninsured counts and rates. Both total_pop and uninsured_pop are extremely right-skewed (skew 13.4 and 17.8) with hundreds of outliers, indicating a handful of very large counties dominate the raw counts \u2014 analysts should work in per-capita or log space. The uninsured_rate is the more comparable metric: median 0.12 with about 17.5% of counties reporting zero, and a long tail reaching 3.7 that warrants a data-quality check. The county_name field shows Texas, Virginia, and Georgia contributing the most counties, useful context for any state-level rollups.","scope":"dataset","target":"__global__"},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.len_min","stats.len_max","stats.len_mean","stats.one_word_rate","stats.vocab_size","stats.duplicate_rate","top_words"],"model":"anthropic:claude-opus-4-7","narrative":"This column is a 5-character FIPS code identifying U.S. counties, with every one of the 3222 rows holding a unique value (n_unique equals n) and zero nulls. Lengths are uniformly 5 (min, median, max all 5), values are single tokens (one_word_rate 1.0), and the leading samples like 01001, 01003, 01005 match Alabama county FIPS prefixes. It functions as a primary key rather than a feature.","role":"identifier","scope":"column","target":"fips","treatment":"Use as a join key to county-level reference tables; do not feed into a model as a feature."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.len_min","stats.len_mean","stats.len_max","stats.word_mean","stats.duplicate_rate","top_words","alerts"],"model":"anthropic:claude-opus-4-7","narrative":"This column holds U.S. county identifiers, likely formatted as 'County Name County, State' given that 'county,' appears in 2,999 of 3,222 rows and state names like Texas (256), Virginia (189), and Georgia (159) dominate the top tokens. Every one of the 3,222 rows is unique with zero nulls and zero duplicates, consistent with a canonical roster of U.S. counties. String lengths cluster tightly (min 16, median 24, max 59) and average 3.25 words, so formatting is highly regular.","role":"identifier","scope":"column","target":"county_name","treatment":"Use as a join key to state/county references; do not feed raw into a model."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.min","stats.max","stats.mean","stats.median","stats.q1","stats.q3","stats.iqr","stats.std","stats.skew","stats.kurtosis","stats.outlier_rate","stats.n_outliers"],"model":"anthropic:claude-opus-4-7","narrative":"Likely a county- or region-level total population count: 3222 rows with 3141 unique values, no nulls, integer-scale magnitudes from 47 up to 9,866,623. The distribution is extremely right-skewed (skew 13.38, kurtosis 298.69) with median 25,328 far below mean 102,232, and 14.06% of rows flagged as outliers. The std of 326,933 dwarfs the IQR of 54,579, consistent with a few massive metros pulling the tail.","role":"feature","scope":"column","target":"total_pop","treatment":"log-transform before regression to tame the heavy right tail."},{"confidence":"high","critiques":[],"evidence_keys":["n","stats.median","stats.mean","stats.max","stats.skew","stats.kurtosis","stats.zero_rate","stats.outlier_rate"],"model":"anthropic:claude-opus-4-7","narrative":"Counts of uninsured people per record, likely aggregated to a geographic unit (3222 rows hints at US counties). The distribution is brutally right-skewed: median is 36 but the mean is 159.9 and the max hits 20915, with skew 17.8 and kurtosis 462.9. Roughly 17.2% of rows are zero and 11.4% flag as outliers, so a handful of large jurisdictions dominate the totals.","role":"feature","scope":"column","target":"uninsured_pop","treatment":"Apply a log1p transform and consider normalising by population before modelling."},{"confidence":"high","critiques":[],"evidence_keys":["min","max","mean","median","q1","q3","iqr","skew","kurtosis","n_outliers","outlier_rate","zero_rate","null_rate","n_unique"],"model":"anthropic:claude-opus-4-7","narrative":"This looks like a per-record uninsured rate, ranging from 0.0 to 3.7 with a median of 0.12 and IQR of 0.21. The distribution is severely right-skewed (skew 4.10, kurtosis 27.70) with 230 outliers (7.14%) and 17.54% exact zeros, and the max of 3.7 is implausible if this is meant to be a proportion bounded at 1.","role":"feature","scope":"column","target":"uninsured_rate","treatment":"Validate the >1 values against the expected [0,1] range, then log- or logit-transform after winsorising before modelling."}],"providers":["anthropic:claude-opus-4-7"],"total_usage":{"completion_tokens":2213,"prompt_tokens":6424,"total_tokens":8637}},"language_counts":{},"meta":{"generated_at":"2026-05-01T16:57:25+00:00","mode":"full","row_count":3222,"sampled_rows":3222,"seed":42,"source":"/home/coolhand/html/datavis/data_trove/cache/healthcare_data/county_health_rankings_20260121.parquet"},"notes":[],"saturn_version":"0.2.0","schema":{"county_name":"text","fips":"text","total_pop":"numeric","uninsured_pop":"numeric","uninsured_rate":"numeric"}}
