{"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":"facility_id","extras":{"language_counts":{},"language_sample_size":5000,"length_histogram":{"counts":[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5421,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0],"edges":[5.5,5.525,5.55,5.575,5.6,5.625,5.65,5.675,5.7,5.725,5.75,5.775,5.8,5.825,5.85,5.875,5.9,5.925,5.95,5.975,6.0,6.025,6.05,6.075,6.1,6.125,6.15,6.175,6.2,6.225,6.25,6.275,6.3,6.325,6.35,6.375,6.4,6.425,6.45,6.475,6.5]},"near_unique":true,"sample":["010012","390272","450855","444002","220019","521300","230021","454152","444026","030152","330140","264034","144035","010036","150157","100236","050357","450209","670041","194105","154059","031305","090003","050464","370022","394056","281334","100276","050104","521315","351310","670285","360012","191301","180056","224028","501310","260006","23012F","264005","440193","494032","143302","494022","520021","521356","171326","191307","074008","453318"],"top_values":[],"top_words":[["010001",1],["010005",1],["010006",1],["010007",1],["010008",1],["010011",1],["010012",1],["010016",1],["010018",1],["010019",1],["010021",1],["010022",1],["010023",1],["010024",1],["010029",1],["010033",1],["010034",1],["010035",1],["010036",1],["010039",1],["010040",1],["010044",1],["010045",1],["010046",1],["010049",1]],"vocab_skipped":null,"word_histogram":{"counts":[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5421,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":5421,"n_null":0,"n_unique":5421,"null_rate":0.0,"stats":{"allcaps_rate":1.0,"boilerplate_rate":0.0,"duplicate_rate":0.0,"emoji_rate":0.0,"len_max":6,"len_mean":6.0,"len_median":6.0,"len_min":6,"len_p95":6.0,"n_duplicates":0,"n_empty":0,"one_word_rate":1.0,"readability_flesch_mean":121.22000000000004,"url_rate":0.0,"vocab_size":5421,"word_mean":1.0,"word_median":1.0}},{"alerts":[{"code":"near_unique","level":"info","message":"97.5% of rows are unique strings"},{"code":"allcaps","level":"info","message":"99.3% rows are all-caps"}],"column":"facility_name","extras":{"language_counts":{},"language_sample_size":5000,"length_histogram":{"counts":[2,1,1,11,12,43,91,178,93,258,424,526,572,258,548,525,460,160,308,232,170,149,47,105,82,79,55,7,4,2,1,3,4,1,2,1,2,0,3,1],"edges":[3.0,4.775,6.55,8.325,10.1,11.875,13.649999999999999,15.424999999999999,17.2,18.975,20.75,22.525,24.299999999999997,26.075,27.849999999999998,29.625,31.4,33.175,34.95,36.725,38.5,40.275,42.05,43.824999999999996,45.599999999999994,47.375,49.15,50.925,52.699999999999996,54.474999999999994,56.25,58.025,59.8,61.574999999999996,63.349999999999994,65.125,66.9,68.675,70.45,72.225,74.0]},"near_unique":true,"sample":["DEKALB REGIONAL MEDICAL CENTER","VALLEY FORGE MEDICAL CENTER","HARLINGEN MEDICAL CENTER","MOCCASIN BEND MENTAL HEALTH INSTITUTE","UMASS MEMORIAL HEALTH - HARRINGTON HOSPITAL","ASPIRUS EAGLE RIVER HOSPITAL","LAKELAND HOSPITAL, ST JOSEPH","CANYON CREEK BEHAVIORAL HEALTH","ERLANGER BEHAVIORAL HOSPITAL, LLC","EXCEPTIONAL COMMUNITY HOSPITAL - MARICOPA","ST JOSEPH'S HOSPITAL HEALTH CENTER","SOUTHEAST BEHAVIORAL HOSPITAL","LINDEN OAKS AT EDWARD","ANDALUSIA HEALTH","ASCENSION ST VINCENT CARMEL","HCA FLORIDA FAWCETT HOSPITAL","GOLETA VALLEY COTTAGE HOSPITAL","NORTHWEST TEXAS HOSPITAL","ASCENSION SETON WILLIAMSON","APOLLO BEHAVIORAL HEALTH HOSPITAL, L L C","SYCAMORE SPRINGS","HOPI HEALTH CARE CENTER","HOWARD UNIVERSITY HOSPITAL CORP","DOCTORS MEDICAL CENTER","JACKSON COUNTY MEMORIAL HOSPITAL AUTHORITY","TOWER BEHAVIORAL HEALTH","BOONE COUNTY HEALTH CENTER","BROWARD HEALTH CORAL SPRINGS","SAINT FRANCIS MEDICAL CENTER","MAYO CLINIC HEALTH SYSTEM-NORTHLAND","SAKAKAWEA MEDICAL CENTER - CAH","ELITE HOSPITAL KINGWOOD","MOUNT CARMEL ST ANN'S","UNION GENERAL HOSPITAL","DEACONESS HENDERSON HOSPITAL","DR JOHN C CORRIGAN MENTAL HEALTH CENTER","NEWPORT COMMUNITY HOSPITAL","MOSAIC LIFE CARE AT ST JOSEPH","BATTLE CREEK VA MEDICAL CENTER","SOUTHEAST MISSOURI MENTAL HLTH CTR","VANDERBILT WILSON COUNTY HOSPITAL","THE PAVILION AT WILLIAMSBURG PLACE","SHRINERS HOSPITAL FOR CHILDREN","POPLAR SPRINGS HOSPITAL","FROEDTERT SOUTH INC.","BELLIN HEALTH OCONTO HOSPITAL","LOGAN COUNTY HOSPITAL","DEQUINCY MEMORIAL HOSPITAL","NATCHAUG HOSPITAL","NEXUS CHILDRENS HOSPITAL DALLAS"],"top_values":[],"top_words":[["hospital",2740],["center",1579],["medical",1444],["health",856],["memorial",490],["regional",393],["county",341],["st",291],["community",265],["-",256],["of",239],["behavioral",232],["inc",165],["valley",150],["healthcare",141],["system",134],["va",134],["general",125],["university",118],["&",98],["mercy",91],["and",90],["the",86],["llc",86],["hospital,",84]],"vocab_skipped":null,"word_histogram":{"counts":[10,0,391,0,0,1766,0,0,1745,0,882,0,0,376,0,0,149,0,0,59,0,31,0,0,8,0,0,1,0,3],"edges":[1.0,1.3666666666666667,1.7333333333333334,2.0999999999999996,2.466666666666667,2.833333333333333,3.1999999999999997,3.5666666666666664,3.933333333333333,4.3,4.666666666666666,5.033333333333333,5.3999999999999995,5.766666666666667,6.133333333333333,6.5,6.866666666666666,7.2333333333333325,7.6,7.966666666666666,8.333333333333332,8.7,9.066666666666666,9.433333333333334,9.799999999999999,10.166666666666666,10.533333333333333,10.899999999999999,11.266666666666666,11.633333333333333,12.0]}},"kind":"text","n":5421,"n_null":0,"n_unique":5286,"null_rate":0.0,"stats":{"allcaps_rate":0.9931746910164176,"boilerplate_rate":0.0,"duplicate_rate":0.024903154399557276,"emoji_rate":0.0,"len_max":74,"len_mean":29.20605054418004,"len_median":28.0,"len_min":3,"len_p95":45.0,"n_duplicates":135,"n_empty":0,"one_word_rate":0.0018446781036709095,"readability_flesch_mean":6.842264285714307,"url_rate":0.0,"vocab_size":3942,"word_mean":3.9950193691200884,"word_median":4.0}},{"alerts":[{"code":"near_unique","level":"info","message":"99.4% of rows are unique strings"},{"code":"allcaps","level":"info","message":"99.2% rows are all-caps"}],"column":"address","extras":{"language_counts":{},"language_sample_size":5000,"length_histogram":{"counts":[3,8,32,66,115,227,288,380,481,502,541,510,413,691,257,218,151,121,73,72,52,47,34,27,15,12,34,12,8,7,6,3,2,3,0,3,2,0,0,5],"edges":[7.0,8.075,9.15,10.225,11.3,12.375,13.45,14.524999999999999,15.6,16.674999999999997,17.75,18.825,19.9,20.975,22.049999999999997,23.125,24.2,25.275,26.349999999999998,27.425,28.5,29.575,30.65,31.724999999999998,32.8,33.875,34.95,36.025,37.099999999999994,38.175,39.25,40.324999999999996,41.4,42.475,43.55,44.625,45.699999999999996,46.775,47.85,48.925,50.0]},"near_unique":true,"sample":["200 MED CENTER DRIVE","1033 WEST GERMANTOWN PIKE","5501 SOUTH EXPRESSWAY 77","100 MOCCASIN BEND ROAD","100 SOUTH STREET","201 HOSPITAL ROAD","1234 NAPIER AVENUE","1201 CANYON CREEK DR","804 NORTH HOLTZCLAW AVENUE","19060 NORTH JOHN WAYNE PARKWAY","301 PROSPECT AVENUE","639 SOUTH SILVER SPRINGS ROAD","852 S WEST STREET","849 SOUTH THREE NOTCH STREET","13500 N MERIDIAN ST","21298 OLEAN BLVD","351 S PATTERSON AVE","1501 S  COULTER ST","201 SETON PARKWAY","9938 AIRLINE HWY","833 PARK EAST BLVD","HIGHWAY 264, MILEPOST 388","2041 GEORGIA AVE NW","1441 FLORIDA AVENUE","1200 EAST PECAN ST","201 WELLNESS WAY","P O BOX 151, 723 WEST FAIRVIEW ST","3000 CORAL HILLS DR","3630 EAST IMPERIAL HIGHWAY","1222 E WOODLAND AVE","510 8TH AVENUE NE","23330 HIGHWAY 59 N","500 SOUTH CLEVELAND AVENUE","901 JAMES AVE","1305 N ELM ST","49 HILLSIDE STREET","714 WEST PINE STREET","5325 FARAON STREET","5500 ARMSTRONG RD.","1010 WEST COLUMBIA STREET","1411 BADDOUR PARKWAY","5483 MOORETOWN ROAD","2211 NORTH OAK PARK AVE","350 POPLAR DRIVE  PO BOX 3060","6308 EIGHTH AVE","820 ARBUTUS AVE","211 CHERRY AVENUE","110 WEST 4TH STREET","189 STORRS RD","9525 GREENVILLE AVENUE"],"top_values":[],"top_words":[["street",1036],["st",606],["avenue",580],["drive",511],["road",507],["ave",405],["north",315],["east",297],["west",294],["south",290],["n",269],["w",254],["s",221],["rd",217],["e",210],["blvd",207],["highway",174],["hospital",171],["main",161],["dr",159],["box",157],["medical",120],["100",118],["boulevard",117],["parkway",94]],"vocab_skipped":null,"word_histogram":{"counts":[43,0,2359,0,2419,0,349,0,109,0,67,0,47,0,22,0,2,0,2,0,1,0,0,0,0,0,0,0,0,1],"edges":[2.0,2.5,3.0,3.5,4.0,4.5,5.0,5.5,6.0,6.5,7.0,7.5,8.0,8.5,9.0,9.5,10.0,10.5,11.0,11.5,12.0,12.5,13.0,13.5,14.0,14.5,15.0,15.5,16.0,16.5,17.0]}},"kind":"text","n":5421,"n_null":0,"n_unique":5387,"null_rate":0.0,"stats":{"allcaps_rate":0.9920678841542151,"boilerplate_rate":0.0,"duplicate_rate":0.006271905552481092,"emoji_rate":0.0,"len_max":50,"len_mean":19.371702637889687,"len_median":19.0,"len_min":7,"len_p95":29.0,"n_duplicates":34,"n_empty":0,"one_word_rate":0.0,"readability_flesch_mean":79.26806071428572,"url_rate":0.0,"vocab_size":4996,"word_mean":3.7542888765910347,"word_median":4.0}},{"alerts":[{"code":"one_word","level":"warn","message":"77.1% rows are a single word"},{"code":"allcaps","level":"info","message":"99.4% rows are all-caps"},{"code":"short_text","level":"info","message":"95th-percentile length under 20 chars"},{"code":"duplicates","level":"warn","message":"43.8% duplicate strings"}],"column":"city","extras":{"language_counts":{},"language_sample_size":5000,"length_histogram":{"counts":[10,122,0,332,0,761,0,895,0,737,0,694,0,705,0,446,0,295,0,191,98,0,50,0,54,0,15,0,6,0,3,0,6,0,0,0,0,0,0,1],"edges":[3.0,3.525,4.05,4.575,5.1,5.625,6.15,6.675000000000001,7.2,7.7250000000000005,8.25,8.775,9.3,9.825,10.350000000000001,10.875,11.4,11.925,12.450000000000001,12.975,13.5,14.025,14.55,15.075000000000001,15.600000000000001,16.125,16.65,17.175,17.700000000000003,18.225,18.75,19.275000000000002,19.8,20.325,20.85,21.375,21.900000000000002,22.425,22.95,23.475,24.0]},"near_unique":false,"sample":["FORT PAYNE","NORRISTOWN","HARLINGEN","CHATTANOOGA","SOUTHBRIDGE","EAGLE RIVER","ST JOSEPH","TEMPLE","CHATTANOOGA","MARICOPA","SYRACUSE","CAPE GIRARDEAU","NAPERVILLE","ANDALUSIA","CARMEL","PORT CHARLOTTE","SANTA BARBARA","AMARILLO","ROUND ROCK","BATON ROUGE","LAFAYETTE","POLACCA","WASHINGTON","MODESTO","ALTUS","READING","ALBION","CORAL SPRINGS","LYNWOOD","BARRON","HAZEN","KINGWOOD","WESTERVILLE","FARMERVILLE","HENDERSON","FALL RIVER","NEWPORT","SAINT JOSEPH","BATTLE CREEK","FARMINGTON","LEBANON","WILLIAMSBURG","CHICAGO","PETERSBURG","KENOSHA","OCONTO","OAKLEY","DEQUINCY","MANSFIELD CENTER","DALLAS"],"top_values":[["CHICAGO",34],["HOUSTON",31],["COLUMBUS",23],["PHILADELPHIA",23],["PHOENIX",22],["DALLAS",20],["LOS ANGELES",19],["OKLAHOMA CITY",19],["JACKSON",18],["SPRINGFIELD",18],["COLUMBIA",18],["WASHINGTON",17],["BALTIMORE",17],["SAN ANTONIO",17],["GREENVILLE",16],["NEW YORK",16],["AUSTIN",16],["INDIANAPOLIS",15],["LAS VEGAS",15],["JACKSONVILLE",14]],"top_words":[["city",159],["san",79],["fort",63],["new",63],["lake",48],["saint",47],["falls",47],["springs",43],["chicago",36],["west",34],["beach",34],["houston",32],["park",28],["mount",24],["york",23],["columbus",23],["philadelphia",23],["phoenix",22],["rock",22],["los",22],["santa",22],["las",22],["columbia",21],["bay",20],["angeles",20]],"vocab_skipped":null,"word_histogram":{"counts":[4179,0,0,0,0,0,0,0,0,0,1178,0,0,0,0,0,0,0,0,0,63,0,0,0,0,0,0,0,0,1],"edges":[1.0,1.1,1.2,1.3,1.4,1.5,1.6,1.7000000000000002,1.8,1.9,2.0,2.1,2.2,2.3,2.4000000000000004,2.5,2.6,2.7,2.8,2.9000000000000004,3.0,3.1,3.2,3.3000000000000003,3.4000000000000004,3.5,3.6,3.7,3.8000000000000003,3.9000000000000004,4.0]}},"kind":"text","n":5421,"n_null":0,"n_unique":3049,"null_rate":0.0,"stats":{"allcaps_rate":0.9942814978786202,"boilerplate_rate":0.0,"duplicate_rate":0.4375576461907397,"emoji_rate":0.0,"len_max":24,"len_mean":8.610957387935805,"len_median":8.0,"len_min":3,"len_p95":13.0,"n_duplicates":2372,"n_empty":0,"one_word_rate":0.770890979524073,"readability_flesch_mean":18.287800000000026,"url_rate":0.0,"vocab_size":2890,"word_mean":1.2410994281497878,"word_median":1.0}},{"alerts":[],"column":"state","extras":{"singletons":2,"top_values":[["TX",462],["CA",378],["FL",221],["IL",194],["OH",194],["NY",191],["PA",187],["LA",160],["GA",149],["IN",149],["MI",147],["WI",142],["KS",139],["MN",136],["OK",135],["TN",123],["MO",121],["NC",120],["IA",118],["AZ",106]]},"kind":"categorical","n":5421,"n_null":0,"n_unique":56,"null_rate":0.0,"stats":{"cardinality":56,"entropy":5.327577117259363,"entropy_ratio":0.9173844527779867,"top_rate":0.08522412838959602,"top_value":"TX"}},{"alerts":[],"column":"zip_code","extras":{"histogram":{"counts":[161,73,92,57,90,101,81,108,79,81,82,191,171,168,151,180,87,154,174,180,98,160,175,147,140,120,133,145,205,191,236,204,103,132,106,72,140,146,159,148],"edges":[603.0,3086.15,5569.3,8052.450000000001,10535.6,13018.75,15501.900000000001,17985.05,20468.2,22951.350000000002,25434.5,27917.65,30400.800000000003,32883.95,35367.1,37850.25,40333.4,42816.55,45299.700000000004,47782.85,50266.0,52749.15,55232.3,57715.450000000004,60198.600000000006,62681.75,65164.9,67648.05,70131.2,72614.35,75097.5,77580.65000000001,80063.8,82546.95,85030.1,87513.25,89996.40000000001,92479.55,94962.7,97445.85,99929.0]},"sample":[35205.0,36207.0,35611.0,35211.0,35653.0,35404.0,35401.0,36526.0,99686.0,99929.0,99615.0,99762.0,85364.0,85020.0,86503.0,85713.0,85297.0,85286.0,85643.0,85008.0,85302.0,72205.0,72833.0,71742.0,72019.0,93301.0,94115.0,91325.0,93940.0,92835.0,94110.0,93065.0,95065.0,93906.0,93703.0,91801.0,90404.0,92307.0,95482.0,94705.0,94304.0,94533.0,92543.0,93105.0,92310.0,94305.0,92270.0,92870.0,92562.0,92395.0,95065.0,90301.0,96001.0,95932.0,93561.0,94121.0,96130.0,96101.0,93555.0,95032.0,92225.0,93636.0,94304.0,90026.0,80631.0,80601.0,81401.0,81004.0,80913.0,81501.0,80138.0,80528.0,81036.0,81073.0,80807.0,81201.0,81212.0,80534.0,6105.0,6320.0,6504.0,6010.0,6856.0,19901.0,20037.0,34102.0,32720.0,32778.0,33308.0,33064.0,32086.0,33606.0,33430.0,33317.0,32216.0,32542.0,33024.0,32405.0,32561.0,33401.0,32425.0,32340.0,32216.0,34471.0,30115.0,31082.0,31768.0,31314.0,31064.0,31635.0,31730.0,31917.0,30906.0,96859.0,96743.0,83687.0,83672.0,83338.0,61801.0,60625.0,60631.0,61554.0,62702.0,60461.0,62946.0,60123.0,60540.0,61103.0,62274.0,62363.0,62863.0,60970.0,60169.0,62906.0,60451.0,47501.0,47274.0,47747.0,46260.0,47303.0,46227.0,46032.0,46804.0,46256.0,46037.0,46506.0,46996.0,47167.0,46218.0,47404.0,46383.0,47905.0,50208.0,52803.0,50314.0,51301.0,52205.0,51555.0,50273.0,50025.0,51455.0,51445.0,51041.0,52040.0,51012.0,52722.0,66622.0,67530.0,67037.0,67107.0,67547.0,67578.0,67045.0,67855.0,67735.0,67205.0,40202.0,40324.0,40503.0,40456.0,42135.0,41041.0,70403.0,70115.0,70648.0,70810.0,70508.0,70427.0,71360.0,71270.0,70445.0,70071.0,71346.0,4736.0,4401.0,4441.0,4462.0,4268.0,20774.0,21215.0,20832.0,20814.0,21225.0,20678.0,21133.0,21014.0,21401.0,1752.0,1199.0,2120.0,1757.0,1440.0,2111.0,2130.0,2540.0,1655.0,1247.0,2115.0,2780.0,2720.0,49221.0,48341.0,48060.0,48033.0,48858.0,49601.0,49770.0,49519.0,48382.0,49829.0,49548.0,49008.0,48176.0,55746.0,55805.0,56201.0,55350.0,55337.0,55125.0,56557.0,56183.0,56296.0,55723.0,56716.0,56240.0,56081.0,56215.0,56425.0,38732.0,39301.0,38635.0,38967.0,38771.0,39474.0,39735.0,38646.0,39503.0,63110.0,64128.0,65201.0,63552.0,64067.0,64085.0,63670.0,64850.0,65548.0,63043.0,63139.0,59101.0,59804.0,59313.0,59422.0,59218.0,59522.0,59034.0,59601.0,69337.0,68787.0,69022.0,89015.0,89191.0,89445.0,89447.0,89052.0,3561.0,8901.0,8861.0,8818.0,7481.0,88240.0,88435.0,88061.0,10456.0,11229.0,11554.0,11355.0,11201.0,12534.0,13421.0,10548.0,10010.0,14092.0,11237.0,11787.0,14611.0,13753.0,13642.0,14103.0,11427.0,10032.0,14209.0,28144.0,28302.0,28359.0,28233.0,27288.0,28472.0,28655.0,28210.0,28112.0,28215.0,27344.0,28722.0,28640.0,27610.0,27530.0,27617.0,58506.0,58237.0,58270.0,58045.0,58301.0,58601.0,43701.0,43050.0,45601.0,44077.0,45013.0,43725.0,44906.0,44122.0,45817.0,43351.0,43138.0,43160.0,43567.0,73801.0,74361.0,73505.0,73104.0,74133.0,73134.0,73034.0,73162.0,73075.0,73438.0,73086.0,74030.0,74462.0,74501.0,97225.0,97030.0,97601.0,97216.0,97222.0,97124.0,97828.0,97720.0,15132.0,17011.0,16544.0,17901.0,15401.0,16652.0,18960.0,15801.0,15215.0,18764.0,17201.0,15317.0,15213.0,18201.0,16146.0,19403.0,19403.0,16154.0,17403.0,15601.0,15552.0,16354.0,15224.0,18507.0,907.0,717.0,737.0,612.0,682.0,956.0,698.0,683.0,2908.0,29203.0,29325.0,29108.0,29220.0,29615.0,57313.0,57028.0,57428.0,57567.0,57070.0,57625.0,57078.0,37232.0,38118.0,38583.0,37075.0,38012.0,37869.0,38008.0,77802.0,75390.0,78539.0,78840.0,77030.0,75092.0,76903.0,77090.0,78041.0,79339.0,76132.0,78332.0,75013.0,77494.0,79035.0,77434.0,77864.0,76550.0,77665.0,79778.0,79081.0,76365.0,77833.0,78717.0,75401.0,79408.0,79902.0,76123.0,78626.0,84532.0,5819.0,22801.0,22939.0,24014.0,23116.0,23970.0,22033.0,20190.0,24060.0,23225.0,24651.0,23229.0,99362.0,98807.0,98026.0,98225.0,98520.0,98405.0,99205.0,99347.0,98586.0,98126.0,24970.0,26330.0,25704.0,25701.0,26416.0,25136.0,54868.0,53143.0,53215.0,53578.0,53215.0,54313.0,54521.0,53934.0,54403.0,82801.0,82501.0,82001.0,82410.0,82834.0,82225.0,82901.0,78746.0,78664.0,75032.0,78240.0,77070.0,77338.0]},"kind":"numeric","n":5421,"n_null":0,"n_unique":4721,"null_rate":0.0,"stats":{"iqr":43333.0,"kurtosis":-0.9878615036105209,"max":99929.0,"mean":53780.46135399373,"median":55066.0,"min":603.0,"n_outliers":0,"outlier_rate":0.0,"q1":32771.0,"q3":76104.0,"skew":-0.16455568645460977,"std":27064.44599423976,"zero_rate":0.0}},{"alerts":[{"code":"one_word","level":"warn","message":"87.3% 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"},{"code":"duplicates","level":"warn","message":"71.3% duplicate strings"}],"column":"county_name","extras":{"language_counts":{},"language_sample_size":5000,"length_histogram":{"counts":[36,472,0,659,0,1008,0,956,0,834,575,0,430,0,195,0,101,0,40,0,75,18,0,2,0,5,0,3,0,5,4,0,1,0,0,0,1,0,0,1],"edges":[3.0,3.55,4.1,4.65,5.2,5.75,6.300000000000001,6.8500000000000005,7.4,7.95,8.5,9.05,9.600000000000001,10.15,10.700000000000001,11.25,11.8,12.350000000000001,12.9,13.450000000000001,14.0,14.55,15.100000000000001,15.65,16.200000000000003,16.75,17.3,17.85,18.400000000000002,18.950000000000003,19.5,20.05,20.6,21.150000000000002,21.700000000000003,22.25,22.8,23.35,23.900000000000002,24.450000000000003,25.0]},"near_unique":false,"sample":["DE KALB","MONTGOMERY","CAMERON","HAMILTON","WORCESTER","VILAS","BERRIEN","BELL","HAMILTON","PINAL","ONONDAGA","CAPE GIRARDEAU","DU PAGE","COVINGTON","HAMILTON","CHARLOTTE","SANTA BARBARA","POTTER","WILLIAMSON","E. BATON ROUGE","TIPPECANOE","NAVAJO","THE DISTRICT","STANISLAUS","JACKSON","BERKS","BOONE","BROWARD","LOS ANGELES","BARRON","MERCER","HARRIS","FRANKLIN","UNION","HENDERSON","BRISTOL","PEND OREILLE","BUCHANAN","CALHOUN","ST. FRANCOIS","WILSON","JAMES CITY","COOK","PETERSBURG CITY","KENOSHA","OCONTO","LOGAN","CALCASIEU","TOLLAND","DALLAS"],"top_values":[["LOS ANGELES",88],["JEFFERSON",59],["COOK",59],["MONTGOMERY",55],["MARICOPA",53],["WASHINGTON",52],["HARRIS",48],["ORANGE",46],["FRANKLIN",42],["CLARK",38],["WAYNE",37],["MARION",35],["JACKSON",33],["DALLAS",33],["LAKE",33],["MADISON",30],["SUFFOLK",30],["TARRANT",30],["HAMILTON",29],["LINCOLN",28]],"top_words":[["san",103],["los",89],["angeles",88],["st.",83],["city",63],["jefferson",60],["cook",59],["montgomery",55],["maricopa",53],["washington",52],["lake",49],["harris",48],["orange",46],["franklin",43],["clark",41],["new",37],["wayne",37],["marion",35],["jackson",33],["dallas",33],["suffolk",31],["madison",30],["tarrant",30],["santa",29],["hamilton",29]],"vocab_skipped":null,"word_histogram":{"counts":[4734,0,0,0,0,0,0,0,0,0,642,0,0,0,0,0,0,0,0,0,43,0,0,0,0,0,0,0,0,2],"edges":[1.0,1.1,1.2,1.3,1.4,1.5,1.6,1.7000000000000002,1.8,1.9,2.0,2.1,2.2,2.3,2.4000000000000004,2.5,2.6,2.7,2.8,2.9000000000000004,3.0,3.1,3.2,3.3000000000000003,3.4000000000000004,3.5,3.6,3.7,3.8000000000000003,3.9000000000000004,4.0]}},"kind":"text","n":5421,"n_null":0,"n_unique":1555,"null_rate":0.0,"stats":{"allcaps_rate":1.0,"boilerplate_rate":0.0,"duplicate_rate":0.7131525548791736,"emoji_rate":0.0,"len_max":25,"len_mean":7.3399741745065485,"len_median":7.0,"len_min":3,"len_p95":11.0,"n_duplicates":3866,"n_empty":0,"one_word_rate":0.8732706142778085,"readability_flesch_mean":34.438475000000025,"url_rate":0.0,"vocab_size":1591,"word_mean":1.1353993728094447,"word_median":1.0}},{"alerts":[{"code":"near_unique","level":"info","message":"99.3% of rows are unique strings"},{"code":"allcaps","level":"info","message":"100.0% rows are all-caps"},{"code":"short_text","level":"info","message":"95th-percentile length under 20 chars"}],"column":"phone_number","extras":{"language_counts":{},"language_sample_size":5000,"length_histogram":{"counts":[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5421,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0],"edges":[13.5,13.525,13.55,13.575,13.6,13.625,13.65,13.675,13.7,13.725,13.75,13.775,13.8,13.825,13.85,13.875,13.9,13.925,13.95,13.975,14.0,14.025,14.05,14.075,14.1,14.125,14.15,14.175,14.2,14.225,14.25,14.275,14.3,14.325,14.35,14.375,14.4,14.425,14.45,14.475,14.5]},"near_unique":true,"sample":["(256) 845-3150","(610) 539-8500","(956) 365-1000","(423) 785-2271","(508) 765-9771","(715) 479-7411","(269) 983-8300","(512) 569-3261","(877) 249-2737","(910) 988-9080","(315) 448-5111","(601) 630-5669","(630) 305-5500","(334) 222-8466","(317) 582-7000","(941) 629-1181","(805) 967-3411","(806) 354-1110","(512) 324-0000","(225) 663-2881","(765) 743-4400","(928) 737-6000","(202) 745-6100","(209) 578-1211","(580) 379-5500","(484) 659-2300","(402) 395-2191","(954) 344-3121","(310) 900-8900","(715) 537-3186","(701) 748-2225","(832) 777-6165","(614) 546-4034","(318) 368-9751","(270) 827-7700","(508) 235-7600","(509) 447-2441","(816) 271-6000","(269) 966-5600","(573) 218-6792","(615) 444-2250","(757) 941-6400","(773) 622-5400","(804) 733-6874","(262) 656-2368","(920) 835-1101","(785) 672-3211","(337) 786-1200","(860) 456-1311","(945) 258-7900"],"top_values":[],"top_words":[["(406)",63],["(605)",62],["(402)",61],["(318)",59],["(787)",59],["(620)",56],["(304)",54],["(601)",53],["(785)",50],["(208)",48],["(715)",48],["(701)",47],["(918)",47],["(580)",46],["(218)",45],["(662)",43],["(618)",42],["(419)",42],["(509)",42],["(405)",41],["(870)",40],["(812)",39],["(970)",38],["(270)",38],["(207)",38]],"vocab_skipped":null,"word_histogram":{"counts":[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5421,0,0,0,0,0,0,0,0,0,0,0,0,0,0],"edges":[1.5,1.5333333333333334,1.5666666666666667,1.6,1.6333333333333333,1.6666666666666667,1.7,1.7333333333333334,1.7666666666666666,1.8,1.8333333333333333,1.8666666666666667,1.9,1.9333333333333333,1.9666666666666668,2.0,2.033333333333333,2.0666666666666664,2.1,2.1333333333333333,2.1666666666666665,2.2,2.2333333333333334,2.2666666666666666,2.3,2.3333333333333335,2.3666666666666667,2.4,2.4333333333333336,2.466666666666667,2.5]}},"kind":"text","n":5421,"n_null":0,"n_unique":5383,"null_rate":0.0,"stats":{"allcaps_rate":1.0,"boilerplate_rate":0.0,"duplicate_rate":0.007009776793949456,"emoji_rate":0.0,"len_max":14,"len_mean":14.0,"len_median":14.0,"len_min":14,"len_p95":14.0,"n_duplicates":38,"n_empty":0,"one_word_rate":0.0,"readability_flesch_mean":120.205,"url_rate":0.0,"vocab_size":5550,"word_mean":2.0,"word_median":2.0}},{"alerts":[],"column":"hospital_type","extras":{"singletons":0,"top_values":[["Acute Care Hospitals",3120],["Critical Access Hospitals",1375],["Psychiatric",626],["Acute Care - Veterans Administration",132],["Childrens",94],["Rural Emergency Hospital",38],["Acute Care - Department of Defense",32],["Long-term",4]]},"kind":"categorical","n":5421,"n_null":0,"n_unique":8,"null_rate":0.0,"stats":{"cardinality":8,"entropy":1.653834738654723,"entropy_ratio":0.551278246218241,"top_rate":0.5755395683453237,"top_value":"Acute Care Hospitals"}},{"alerts":[],"column":"hospital_ownership","extras":{"singletons":0,"top_values":[["Voluntary non-profit - Private",2291],["Proprietary",1067],["Government - Hospital District or Authority",521],["Government - Local",400],["Voluntary non-profit - Other",361],["Voluntary non-profit - Church",275],["Government - State",210],["Veterans Health Administration",132],["Physician",74],["Government - Federal",44],["Department of Defense",32],["Tribal",14]]},"kind":"categorical","n":5421,"n_null":0,"n_unique":12,"null_rate":0.0,"stats":{"cardinality":12,"entropy":2.586443681709749,"entropy_ratio":0.7214702193368707,"top_rate":0.42261575355100534,"top_value":"Voluntary non-profit - Private"}},{"alerts":[],"column":"emergency_services","extras":{"singletons":0,"top_values":[["Yes",4505],["No",916]]},"kind":"categorical","n":5421,"n_null":0,"n_unique":2,"null_rate":0.0,"stats":{"cardinality":2,"entropy":0.655348920620185,"entropy_ratio":0.655348920620185,"top_rate":0.8310274857037447,"top_value":"Yes"}},{"alerts":[{"code":"null_rate","level":"warn","message":"58.2% null"},{"code":"imbalance","level":"warn","message":"top value is 100.0% of rows"}],"column":"Meets criteria for birthing friendly designation","extras":{"singletons":0,"top_values":[["Y",2264]]},"kind":"categorical","n":5421,"n_null":3157,"n_unique":1,"null_rate":0.5823648773289061,"stats":{"cardinality":1,"entropy":-0.0,"entropy_ratio":0.0,"top_rate":1.0,"top_value":"Y"}},{"alerts":[],"column":"Hospital overall rating","extras":{"singletons":0,"top_values":[["Not Available",2552],["3",937],["4",765],["2",649],["5",289],["1",229]]},"kind":"categorical","n":5421,"n_null":0,"n_unique":6,"null_rate":0.0,"stats":{"cardinality":6,"entropy":2.1330046936311993,"entropy_ratio":0.8251588535756827,"top_rate":0.4707618520568161,"top_value":"Not Available"}},{"alerts":[{"code":"null_rate","level":"warn","message":"52.7% null"}],"column":"Hospital overall rating footnote","extras":{"singletons":0,"top_values":[["16",1676],["19",795],["5",47],["22",32],["17",7],["23",5],["16, 23",2]]},"kind":"categorical","n":5421,"n_null":2857,"n_unique":7,"null_rate":0.5270245342187788,"stats":{"cardinality":7,"entropy":1.158301775665419,"entropy_ratio":0.4125954173320062,"top_rate":0.6536661466458659,"top_value":"16"}},{"alerts":[],"column":"MORT Group Measure Count","extras":{"singletons":0,"top_values":[["7",4558],["Not Available",863]]},"kind":"categorical","n":5421,"n_null":0,"n_unique":2,"null_rate":0.0,"stats":{"cardinality":2,"entropy":0.6323819858538499,"entropy_ratio":0.6323819858538499,"top_rate":0.8408042796532005,"top_value":"7"}},{"alerts":[],"column":"Count of Facility MORT Measures","extras":{"singletons":0,"top_values":[["Not Available",1777],["7",850],["6",587],["1",495],["5",455],["3",444],["2",420],["4",393]]},"kind":"categorical","n":5421,"n_null":0,"n_unique":8,"null_rate":0.0,"stats":{"cardinality":8,"entropy":2.765227535507629,"entropy_ratio":0.9217425118358763,"top_rate":0.3277992990223206,"top_value":"Not Available"}},{"alerts":[],"column":"Count of MORT Measures Better","extras":{"singletons":1,"top_values":[["0",3136],["Not Available",1777],["1",297],["2",133],["3",53],["4",15],["5",7],["7",2],["6",1]]},"kind":"categorical","n":5421,"n_null":0,"n_unique":9,"null_rate":0.0,"stats":{"cardinality":9,"entropy":1.452731017640336,"entropy_ratio":0.45828561148271496,"top_rate":0.5784910533111972,"top_value":"0"}},{"alerts":[],"column":"Count of MORT Measures No Different","extras":{"singletons":0,"top_values":[["Not Available",1777],["6",672],["5",541],["1",513],["3",509],["4",503],["2",472],["7",422],["0",12]]},"kind":"categorical","n":5421,"n_null":0,"n_unique":9,"null_rate":0.0,"stats":{"cardinality":9,"entropy":2.80612361623737,"entropy_ratio":0.8852334408418455,"top_rate":0.3277992990223206,"top_value":"Not Available"}},{"alerts":[],"column":"Count of MORT Measures Worse","extras":{"singletons":1,"top_values":[["0",3266],["Not Available",1777],["1",310],["2",57],["3",7],["4",3],["5",1]]},"kind":"categorical","n":5421,"n_null":0,"n_unique":7,"null_rate":0.0,"stats":{"cardinality":7,"entropy":1.2937313740767302,"entropy_ratio":0.46083641363326844,"top_rate":0.602471868658919,"top_value":"0"}},{"alerts":[{"code":"null_rate","level":"warn","message":"67.2% null"}],"column":"MORT Group Footnote","extras":{"histogram":{"counts":[950,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,795,0,0,0,0,0,32,0,1],"edges":[5.0,5.45,5.9,6.35,6.8,7.25,7.7,8.15,8.6,9.05,9.5,9.95,10.4,10.850000000000001,11.3,11.75,12.2,12.65,13.1,13.55,14.0,14.450000000000001,14.9,15.35,15.8,16.25,16.700000000000003,17.15,17.6,18.05,18.5,18.950000000000003,19.4,19.85,20.3,20.75,21.2,21.650000000000002,22.1,22.55,23.0]},"sample":[5.0,5.0,5.0,5.0,19.0,19.0,19.0,22.0,22.0,5.0,5.0,5.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,5.0,5.0,5.0,22.0,5.0,22.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,22.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,5.0,19.0,19.0,19.0,19.0,5.0,19.0,19.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,22.0,5.0,5.0,19.0,19.0,19.0,5.0,5.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,19.0,5.0,5.0,5.0,5.0,19.0,5.0,5.0,5.0,5.0,5.0,19.0,22.0,19.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,22.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,5.0,22.0,19.0,19.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,5.0,19.0,5.0,5.0,5.0,5.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,19.0,19.0,19.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,5.0,19.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,19.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,5.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,19.0,22.0,5.0,5.0,19.0,22.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,5.0,5.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,5.0,5.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0]},"kind":"numeric","n":5421,"n_null":3643,"n_unique":4,"null_rate":0.6720162331673123,"stats":{"iqr":14.0,"kurtosis":-1.9589845239958674,"max":23.0,"mean":11.575928008998876,"median":5.0,"min":5.0,"n_outliers":0,"outlier_rate":0.0,"q1":5.0,"q3":19.0,"skew":0.1487728825347418,"std":7.057375987928832,"zero_rate":0.0}},{"alerts":[],"column":"Safety Group Measure Count","extras":{"singletons":0,"top_values":[["8",4558],["Not Available",863]]},"kind":"categorical","n":5421,"n_null":0,"n_unique":2,"null_rate":0.0,"stats":{"cardinality":2,"entropy":0.6323819858538499,"entropy_ratio":0.6323819858538499,"top_rate":0.8408042796532005,"top_value":"8"}},{"alerts":[],"column":"Count of Facility Safety Measures","extras":{"singletons":0,"top_values":[["Not Available",2065],["7",733],["2",519],["6",460],["8",453],["1",443],["3",290],["5",235],["4",223]]},"kind":"categorical","n":5421,"n_null":0,"n_unique":9,"null_rate":0.0,"stats":{"cardinality":9,"entropy":2.7529139767955053,"entropy_ratio":0.8684476684915046,"top_rate":0.3809260284080428,"top_value":"Not Available"}},{"alerts":[],"column":"Count of Safety Measures Better","extras":{"singletons":0,"top_values":[["Not Available",2065],["0",1548],["1",1052],["2",430],["3",216],["4",93],["5",14],["6",3]]},"kind":"categorical","n":5421,"n_null":0,"n_unique":8,"null_rate":0.0,"stats":{"cardinality":8,"entropy":2.109849637683265,"entropy_ratio":0.7032832125610883,"top_rate":0.3809260284080428,"top_value":"Not Available"}},{"alerts":[],"column":"Count of Safety Measures No Different","extras":{"singletons":0,"top_values":[["Not Available",2065],["5",656],["2",551],["4",527],["1",509],["6",482],["3",434],["7",167],["0",20],["8",10]]},"kind":"categorical","n":5421,"n_null":0,"n_unique":10,"null_rate":0.0,"stats":{"cardinality":10,"entropy":2.6850224324500602,"entropy_ratio":0.8082722911981339,"top_rate":0.3809260284080428,"top_value":"Not Available"}},{"alerts":[],"column":"Count of Safety Measures Worse","extras":{"singletons":0,"top_values":[["0",2941],["Not Available",2065],["1",365],["2",44],["3",6]]},"kind":"categorical","n":5421,"n_null":0,"n_unique":5,"null_rate":0.0,"stats":{"cardinality":5,"entropy":1.3383754544026025,"entropy_ratio":0.5764069341120263,"top_rate":0.5425198302896145,"top_value":"0"}},{"alerts":[{"code":"null_rate","level":"warn","message":"61.8% null"}],"column":"Safety Group Footnote","extras":{"histogram":{"counts":[1238,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,795,0,0,0,0,0,32,0,6],"edges":[5.0,5.45,5.9,6.35,6.8,7.25,7.7,8.15,8.6,9.05,9.5,9.95,10.4,10.850000000000001,11.3,11.75,12.2,12.65,13.1,13.55,14.0,14.450000000000001,14.9,15.35,15.8,16.25,16.700000000000003,17.15,17.6,18.05,18.5,18.950000000000003,19.4,19.85,20.3,20.75,21.2,21.650000000000002,22.1,22.55,23.0]},"sample":[5.0,5.0,5.0,19.0,19.0,19.0,19.0,5.0,5.0,5.0,5.0,19.0,5.0,5.0,5.0,5.0,19.0,19.0,5.0,5.0,19.0,5.0,5.0,5.0,19.0,5.0,19.0,19.0,19.0,22.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,19.0,19.0,19.0,19.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,22.0,22.0,5.0,5.0,5.0,19.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,23.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,5.0,5.0,19.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,19.0,19.0,5.0,5.0,5.0,23.0,19.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,5.0,22.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,5.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,5.0,5.0,5.0,5.0,19.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,19.0,19.0,5.0,19.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,19.0,5.0,5.0,5.0,5.0,19.0]},"kind":"numeric","n":5421,"n_null":3350,"n_unique":4,"null_rate":0.6179671647297547,"stats":{"iqr":14.0,"kurtosis":-1.8085148418036356,"max":23.0,"mean":10.68903911154032,"median":5.0,"min":5.0,"n_outliers":0,"outlier_rate":0.0,"q1":5.0,"q3":19.0,"skew":0.41157757766574504,"std":6.9499154128183065,"zero_rate":0.0}},{"alerts":[],"column":"READM Group Measure Count","extras":{"singletons":0,"top_values":[["11",4558],["Not Available",863]]},"kind":"categorical","n":5421,"n_null":0,"n_unique":2,"null_rate":0.0,"stats":{"cardinality":2,"entropy":0.6323819858538499,"entropy_ratio":0.6323819858538499,"top_rate":0.8408042796532005,"top_value":"11"}},{"alerts":[],"column":"Count of Facility READM Measures","extras":{"singletons":0,"top_values":[["Not Available",1150],["11",498],["8",466],["6",438],["9",425],["3",375],["2",374],["7",358],["5",347],["4",335],["10",333],["1",322]]},"kind":"categorical","n":5421,"n_null":0,"n_unique":12,"null_rate":0.0,"stats":{"cardinality":12,"entropy":3.459333273364676,"entropy_ratio":0.964956613261308,"top_rate":0.21213798192215458,"top_value":"Not Available"}},{"alerts":[],"column":"Count of READM Measures Better","extras":{"singletons":0,"top_values":[["0",3332],["Not Available",1150],["1",737],["2",161],["3",28],["4",10],["5",3]]},"kind":"categorical","n":5421,"n_null":0,"n_unique":7,"null_rate":0.0,"stats":{"cardinality":7,"entropy":1.5101656831569286,"entropy_ratio":0.5379318700643941,"top_rate":0.614646744143147,"top_value":"0"}},{"alerts":[],"column":"Count of READM Measures No Different","extras":{"singletons":0,"top_values":[["Not Available",1150],["7",497],["8",491],["6",480],["2",428],["3",428],["5",426],["9",418],["4",398],["1",372],["10",249],["11",81],["0",3]]},"kind":"categorical","n":5421,"n_null":0,"n_unique":13,"null_rate":0.0,"stats":{"cardinality":13,"entropy":3.4084981497672193,"entropy_ratio":0.9211062493620275,"top_rate":0.21213798192215458,"top_value":"Not Available"}},{"alerts":[],"column":"Count of READM Measures Worse","extras":{"singletons":1,"top_values":[["0",2988],["Not Available",1150],["1",839],["2",308],["3",105],["4",26],["6",2],["5",2],["7",1]]},"kind":"categorical","n":5421,"n_null":0,"n_unique":9,"null_rate":0.0,"stats":{"cardinality":9,"entropy":1.7577702953100889,"entropy_ratio":0.5545147896276112,"top_rate":0.5511898173768678,"top_value":"0"}},{"alerts":[{"code":"null_rate","level":"warn","message":"78.8% null"}],"column":"READM Group Footnote","extras":{"histogram":{"counts":[323,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,795,0,0,0,0,32],"edges":[5.0,5.515151515151516,6.03030303030303,6.545454545454545,7.0606060606060606,7.575757575757576,8.09090909090909,8.606060606060606,9.121212121212121,9.636363636363637,10.151515151515152,10.666666666666666,11.181818181818182,11.696969696969697,12.212121212121211,12.727272727272727,13.242424242424242,13.757575757575758,14.272727272727273,14.787878787878787,15.303030303030303,15.818181818181818,16.333333333333332,16.848484848484848,17.363636363636363,17.87878787878788,18.393939393939394,18.909090909090907,19.424242424242422,19.939393939393938,20.454545454545453,20.96969696969697,21.484848484848484,22.0]},"sample":[19.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,22.0,5.0,5.0,19.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,19.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,22.0,22.0,22.0,19.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,22.0,22.0,19.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,22.0,5.0,5.0,19.0,19.0,19.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,22.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,5.0,19.0,19.0,19.0,19.0,19.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,5.0,19.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,19.0,19.0,22.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,22.0,22.0,19.0,19.0,19.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,22.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,22.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,5.0,19.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,19.0,19.0,19.0,19.0,22.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,5.0,19.0,5.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,5.0,19.0,5.0,5.0,5.0,19.0,19.0]},"kind":"numeric","n":5421,"n_null":4271,"n_unique":3,"null_rate":0.7878620180778454,"stats":{"iqr":14.0,"kurtosis":-1.0507201406108824,"max":22.0,"mean":15.151304347826088,"median":19.0,"min":5.0,"n_outliers":0,"outlier_rate":0.0,"q1":5.0,"q3":19.0,"skew":-0.9527757122430544,"std":6.365818823848694,"zero_rate":0.0}},{"alerts":[],"column":"Pt Exp Group Measure Count","extras":{"singletons":0,"top_values":[["8",4558],["Not Available",863]]},"kind":"categorical","n":5421,"n_null":0,"n_unique":2,"null_rate":0.0,"stats":{"cardinality":2,"entropy":0.6323819858538499,"entropy_ratio":0.6323819858538499,"top_rate":0.8408042796532005,"top_value":"8"}},{"alerts":[],"column":"Count of Facility Pt Exp Measures","extras":{"singletons":0,"top_values":[["8",3154],["Not Available",2267]]},"kind":"categorical","n":5421,"n_null":0,"n_unique":2,"null_rate":0.0,"stats":{"cardinality":2,"entropy":0.9806006367667868,"entropy_ratio":0.9806006367667868,"top_rate":0.5818114738978049,"top_value":"8"}},{"alerts":[{"code":"null_rate","level":"warn","message":"58.2% null"}],"column":"Pt Exp Group Footnote","extras":{"histogram":{"counts":[1440,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,795,0,0,0,0,0,0,32],"edges":[5.0,5.425,5.85,6.275,6.7,7.125,7.55,7.975,8.4,8.825,9.25,9.675,10.1,10.524999999999999,10.95,11.375,11.8,12.225,12.649999999999999,13.075,13.5,13.924999999999999,14.35,14.775,15.2,15.625,16.049999999999997,16.475,16.9,17.325,17.75,18.174999999999997,18.6,19.025,19.45,19.875,20.299999999999997,20.725,21.15,21.575,22.0]},"sample":[5.0,5.0,5.0,19.0,19.0,19.0,22.0,5.0,5.0,5.0,5.0,19.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,5.0,19.0,19.0,5.0,22.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,22.0,22.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,22.0,22.0,19.0,5.0,5.0,5.0,19.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,5.0,5.0,5.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,19.0,5.0,5.0,19.0,19.0,19.0,19.0,5.0,5.0,19.0,19.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,5.0,5.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,22.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,22.0,5.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,5.0,5.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,5.0,19.0,19.0,5.0,5.0,19.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,5.0,19.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,22.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,19.0,19.0,19.0,19.0,5.0,22.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0]},"kind":"numeric","n":5421,"n_null":3154,"n_unique":3,"null_rate":0.5818114738978049,"stats":{"iqr":14.0,"kurtosis":-1.657793675431545,"max":22.0,"mean":10.149536832818702,"median":5.0,"min":5.0,"n_outliers":0,"outlier_rate":0.0,"q1":5.0,"q3":19.0,"skew":0.5710092657208102,"std":6.805594079425214,"zero_rate":0.0}},{"alerts":[],"column":"TE Group Measure Count","extras":{"singletons":0,"top_values":[["12",4558],["Not Available",863]]},"kind":"categorical","n":5421,"n_null":0,"n_unique":2,"null_rate":0.0,"stats":{"cardinality":2,"entropy":0.6323819858538499,"entropy_ratio":0.6323819858538499,"top_rate":0.8408042796532005,"top_value":"12"}},{"alerts":[],"column":"Count of Facility TE Measures","extras":{"singletons":0,"top_values":[["Not Available",928],["10",759],["11",724],["9",543],["8",391],["5",351],["12",347],["6",337],["7",284],["4",272],["3",269],["2",163],["1",53]]},"kind":"categorical","n":5421,"n_null":0,"n_unique":13,"null_rate":0.0,"stats":{"cardinality":13,"entropy":3.4575003734451135,"entropy_ratio":0.9343485198515763,"top_rate":0.17118612802066038,"top_value":"Not Available"}},{"alerts":[{"code":"null_rate","level":"warn","message":"82.9% null"},{"code":"high_skew","level":"info","message":"skew=-2.43"},{"code":"outliers","level":"warn","message":"14.3% rows beyond 1.5 IQR"}],"column":"TE Group Footnote","extras":{"histogram":{"counts":[101,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,795,0,0,0,0,32],"edges":[5.0,5.566666666666666,6.133333333333333,6.7,7.266666666666667,7.833333333333333,8.4,8.966666666666667,9.533333333333333,10.1,10.666666666666666,11.233333333333334,11.8,12.366666666666667,12.933333333333334,13.5,14.066666666666666,14.633333333333333,15.2,15.766666666666666,16.333333333333332,16.9,17.46666666666667,18.03333333333333,18.6,19.166666666666664,19.733333333333334,20.299999999999997,20.866666666666667,21.433333333333334,22.0]},"sample":[19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,22.0,22.0,19.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,22.0,5.0,5.0,19.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,22.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,22.0,19.0,5.0,19.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,22.0,22.0,22.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,19.0,19.0,19.0,19.0,22.0,19.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,19.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,19.0,19.0,19.0,22.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,19.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,22.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,19.0,19.0,19.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,22.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,22.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,22.0,5.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,19.0,5.0,5.0,19.0,19.0,5.0,5.0,5.0,5.0,5.0]},"kind":"numeric","n":5421,"n_null":4493,"n_unique":3,"null_rate":0.8288138719793396,"stats":{"iqr":0.0,"kurtosis":4.1200181358251085,"max":22.0,"mean":17.579741379310345,"median":19.0,"min":5.0,"n_outliers":133,"outlier_rate":0.14331896551724138,"q1":19.0,"q3":19.0,"skew":-2.4296440896545377,"std":4.43241214094497,"zero_rate":0.0}}],"insights":{"errors":[],"insights":[{"confidence":"high","critiques":[],"evidence_keys":["row_count","column_count","Hospital overall rating.top_values","Hospital overall rating.top_rate","hospital_type.top_values","hospital_ownership.top_values","state.top_values","Meets criteria for birthing friendly designation.null_rate","Meets criteria for birthing friendly designation.top_value","MORT Group Footnote.null_rate","READM Group Footnote.null_rate","Safety Group Footnote.null_rate","Pt Exp Group Footnote.null_rate","emergency_services.top_values"],"featured_charts":[{"caption":"Distribution of CMS star ratings \u2014 note that 'Not Available' is the single largest bucket (~47%).","column":"Hospital overall rating","kind":"bar"},{"caption":"Acute Care Hospitals dominate at ~58%, followed by Critical Access and Psychiatric facilities.","column":"hospital_type","kind":"donut"},{"caption":"Voluntary non-profit \u2013 Private hospitals make up ~42% of the dataset, with Proprietary a distant second.","column":"hospital_ownership","kind":"bar"},{"caption":"Geographic spread across 56 states/territories; Texas and California top the list.","column":"state","kind":"bar"},{"caption":"About 83% of facilities report providing emergency services \u2014 useful as a quick filter.","column":"emergency_services","kind":"donut"}],"model":"anthropic:claude-opus-4-7","narrative":"This dataset catalogs 5,421 U.S. hospitals with 38 columns covering location (city, county, state, ZIP), facility identity, ownership and type, and CMS quality-measure rollups (mortality, readmission, safety, patient experience, timely & effective care). The most interesting structural story is the quality-rating coverage: 'Hospital overall rating' is 'Not Available' for 47% of hospitals, and the various footnote columns are null for 53\u201383% of rows, so any analysis of star ratings has to handle a large missing slice. On the categorical side, the mix is dominated by Acute Care Hospitals (~58%) and Voluntary non-profit \u2013 Private ownership (~42%), with Texas and California leading state counts. The 'Meets criteria for birthing friendly designation' field only ever takes the value 'Y' (58% null, no 'N'), so it is effectively a flag rather than a comparator.","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.allcaps_rate","stats.duplicate_rate","stats.vocab_size","top_words"],"model":"anthropic:claude-opus-4-7","narrative":"This is a facility identifier: every one of the 5421 rows holds a unique 6-character, single-token, all-caps code with no nulls or duplicates. The samples are zero-padded numeric strings (e.g. 010001, 010005), suggesting a fixed-width registry code rather than free text.","role":"identifier","scope":"column","target":"facility_id","treatment":"Use as a primary key for joins; do not feed into models."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","top_words","stats.allcaps_rate","stats.n_duplicates","stats.duplicate_rate","stats.word_mean","stats.len_mean","alerts"],"model":"anthropic:claude-opus-4-7","narrative":"This column holds healthcare facility names \u2014 'hospital', 'center', 'medical', and 'health' dominate the top words, with typical entries around 4 words and 29 characters. It is near-unique (5286 distinct values across 5421 rows) yet still shows 135 duplicates (2.5%), suggesting either shared facility names across locations or genuine repeats. Notably, 99.3% of values are all-caps, which is a formatting quirk worth normalising.","role":"identifier","scope":"column","target":"facility_name","treatment":"Lowercase and normalise whitespace, then treat as a high-cardinality entity key rather than a model feature."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.allcaps_rate","stats.duplicate_rate","stats.n_duplicates","stats.len_mean","stats.word_mean","top_words"],"model":"anthropic:claude-opus-4-7","narrative":"Free-text street addresses: 5,387 unique values out of 5,421 rows (34 duplicates) with no nulls, averaging 3.75 words and 19 characters. Top tokens are street/road/avenue and cardinal directions, consistent with US-style mailing addresses. Notably 99.2% of values are ALLCAPS, suggesting upstream normalization rather than user free-form entry.","role":"identifier","scope":"column","target":"address","treatment":"Drop or hash for modelling; parse into components if geocoding is needed."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.allcaps_rate","stats.one_word_rate","stats.duplicate_rate","stats.len_mean","stats.len_max","stats.word_median","top_values","top_words"],"model":"anthropic:claude-opus-4-7","narrative":"This is a US city name field, stored almost entirely in uppercase (allcaps_rate 0.994) and dominated by single-word entries (one_word_rate 0.771, word_median 1). With 3049 unique values across 5421 rows and a 0.438 duplicate_rate, common metros like CHICAGO (34), HOUSTON (31), and COLUMBUS (23) recur but the long tail is heavy. Lengths are short and tight (len_mean 8.6, len_max 24), and there are no nulls or empties.","role":"feature","scope":"column","target":"city","treatment":"Normalize case and pair with state/country before using as a categorical or geocoding key."},{"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 column holds US state codes (top values TX, CA, FL, IL, OH), with 56 distinct values across 5421 rows and no nulls. Cardinality slightly exceeds the 50 states, suggesting territories or DC are mixed in. Distribution is fairly even \u2014 entropy ratio 0.917 and the top state TX accounts for only 8.5% \u2014 so no single state dominates.","role":"feature","scope":"column","target":"state","treatment":"One-hot or target-encode for modelling; verify the 6 extra codes beyond 50 states."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.min","stats.max","stats.mean","stats.std"],"model":"anthropic:claude-opus-4-7","narrative":"This is almost certainly a US ZIP code field, stored numerically with values spanning 603 to 99929 across 5421 rows and 4721 unique values. The numeric framing is misleading: the mean of 53780 and std of 27064 reflect ZIP geography, not a continuous quantity, and leading-zero ZIPs (e.g. New England) have likely been truncated given the minimum of 603. No nulls or statistical outliers are reported.","role":"identifier","scope":"column","target":"zip_code","treatment":"Cast to zero-padded 5-character strings and treat as a categorical/geographic key, not a numeric feature."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.allcaps_rate","stats.one_word_rate","stats.word_mean","stats.duplicate_rate","stats.len_median","stats.len_max","top_values","top_words"],"model":"anthropic:claude-opus-4-7","narrative":"This is a US county name field, stored entirely in uppercase (allcaps_rate 1.0) and mostly single-token (one_word_rate 0.87, word_mean 1.14). Across 5421 rows there are 1555 distinct values with a 71.3% duplicate_rate, led by LOS ANGELES (88), JEFFERSON (59), and COOK (59) \u2014 consistent with common US county names recurring across states. No nulls or empties, and lengths are short and tight (median 7, max 25).","role":"feature","scope":"column","target":"county_name","treatment":"Normalize case and pair with a state column before joining or grouping, since county names repeat across states."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.len_min","stats.len_max","stats.word_mean","stats.duplicate_rate","stats.n_duplicates","top_words"],"model":"anthropic:claude-opus-4-7","narrative":"Formatted US phone numbers, every value exactly 14 characters and 2 \"words\" (area code in parentheses plus the rest), with top tokens like (406), (605), (402) confirming the (XXX) prefix pattern. Of 5421 rows, 5383 are unique with 38 duplicates (0.7%) and zero nulls, so the column is near-unique but not a clean key. The allcaps flag is an artifact of digits/punctuation and can be ignored.","role":"identifier","scope":"column","target":"phone_number","treatment":"Drop or hash for PII; do not use as a model feature."},{"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":"Categorical classifier of hospital facility type across 8 distinct values with no nulls. Acute Care Hospitals dominate at 57.6% (3120 of 5421), followed by Critical Access Hospitals (1375) and Psychiatric (626); the long tail is sparse, with Long-term appearing only 4 times. Entropy ratio of 0.55 confirms the distribution is heavily concentrated on the top category.","role":"feature","scope":"column","target":"hospital_type","treatment":"One-hot encode and consider collapsing the four rarest types (<3% each) into an 'Other' bucket."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.top_value","stats.top_rate","stats.entropy_ratio","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"This column classifies each of 5,421 hospitals by ownership type across 12 categories with no nulls. Voluntary non-profit - Private dominates at 2,291 rows (42.3% top_rate), followed by Proprietary at 1,067, with a long tail down to Physician (74) and Government - Federal (44). Entropy ratio of 0.72 confirms a moderately skewed but usable distribution.","role":"feature","scope":"column","target":"hospital_ownership","treatment":"One-hot or target-encode; consider grouping rare classes (Physician, Government - Federal) into an 'Other' bucket."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.cardinality","stats.top_rate","stats.top_value","stats.entropy_ratio","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"A binary Yes/No flag indicating whether emergency services are present, with no missing values across 5421 rows. The split is heavily skewed toward 'Yes' at 83.1% (4505 vs 916), giving an entropy ratio of 0.66.","role":"feature","scope":"column","target":"emergency_services","treatment":"Encode as 0/1; consider class imbalance if used as a predictor or target."},{"confidence":"high","critiques":[],"evidence_keys":["n_unique","null_rate","stats.cardinality","stats.top_rate","stats.top_value","stats.entropy","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"This is a binary flag indicating whether a facility meets criteria for a 'birthing friendly' designation, but every non-null value is 'Y' (2264 rows, top_rate 1.0, cardinality 1). The remaining 58.24% of rows are null, so the column effectively encodes presence/absence of the designation rather than a Y/N contrast. Entropy is 0.0, meaning it carries no information beyond the null pattern itself.","role":"feature","scope":"column","target":"Meets criteria for birthing friendly designation","treatment":"Recode as a boolean (designated vs. not) from the null mask, or drop as near-constant."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.top_value","stats.top_rate","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"This is the CMS-style hospital overall star rating, encoded as strings 1-5 with a 'Not Available' sentinel covering 47.1% of 5,421 rows. The remaining ratings concentrate around 3 (937) and 4 (765), with extremes 5 (289) and 1 (229) much rarer. The dominant 'Not Available' bucket is the headline surprise \u2014 nearly half of hospitals have no rating at all.","role":"label","scope":"column","target":"Hospital overall rating","treatment":"Recode 'Not Available' as missing and treat the remainder as an ordinal 1-5 scale."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.top_value","stats.top_rate","stats.entropy","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"Footnote codes that qualify the Hospital overall rating, with only 7 distinct values across 5421 rows. Over half the column (52.7%) is null, and among the populated rows code '16' dominates at 65.4% followed by '19' at ~31%, leaving the other codes as long-tail rarities. One compound entry ('16, 23') hints that multiple footnotes can be concatenated in a single cell.","role":"metadata","scope":"column","target":"Hospital overall rating footnote","treatment":"Treat as categorical metadata; split compound codes and either one-hot encode or drop given the high null rate."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.top_value","stats.top_rate","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"Binary categorical column where 84.1% of the 5421 rows hold the literal string \"7\" and the remaining 863 rows are \"Not Available\". This looks like a fixed mortality-group measure count (always 7 when reported) with explicit missingness encoded as a sentinel string rather than null, so null_rate is 0 despite real absence.","role":"feature","scope":"column","target":"MORT Group Measure Count","treatment":"Recode \"Not Available\" to null and convert to a binary availability flag, since the numeric value carries no variance."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.top_value","stats.top_rate","stats.entropy_ratio","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"Counts of facility mortality measures stored as strings, with 8 distinct values across 5421 rows and no nulls. The dominant category is 'Not Available' at 32.8% (1777 rows), while the remaining values are integers 1-7, with '7' the most common numeric level at 850. High entropy ratio (0.92) indicates the non-missing counts are spread fairly evenly across 1-7.","role":"feature","scope":"column","target":"Count of Facility MORT Measures","treatment":"Recode 'Not Available' as missing, cast remaining values to integer, then treat as ordinal."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.top_value","stats.top_rate","stats.entropy_ratio","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"Counts the number of mortality measures where a hospital scored 'better than national average', stored as strings 0-7 plus 'Not Available'. The distribution is heavily concentrated at 0 (57.8% of 5421 rows) with another 1777 rows literally encoded as 'Not Available', leaving only ~10% of facilities recording one or more better-than-average measures. Cardinality is just 9 with entropy ratio 0.46, so the signal is sparse and dominated by zeros and missingness sentinels.","role":"feature","scope":"column","target":"Count of MORT Measures Better","treatment":"Recode 'Not Available' to NaN, cast remaining values to integer, and consider binarising (any-better vs none) given the heavy zero mass."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.top_value","stats.top_rate","stats.entropy_ratio","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"This column appears to be a count (0-7) of mortality measures rated 'no different than national rate' per facility, but it's stored categorically with 'Not Available' as the dominant value at 32.8% of 5421 rows. Among numeric values, the distribution is fairly even across 1-7 (422-672 each), while '0' is rare at only 12 occurrences. The high entropy ratio (0.885) confirms the non-null values spread broadly across the 8 numeric buckets.","role":"feature","scope":"column","target":"Count of MORT Measures No Different","treatment":"Coerce numeric strings to integers and treat 'Not Available' as an explicit missing-indicator before modelling."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.top_value","stats.top_rate","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"A small-integer count (0-5) of mortality measures on which a hospital performed worse than the national benchmark, stored as strings alongside a 'Not Available' sentinel. The distribution is heavily concentrated: 60.2% are '0' and another 1,777 rows (about a third) are 'Not Available', leaving only 378 hospitals with one or more worse measures. The long tail is extreme \u2014 just 11 rows have 3 or more, and a single row reports 5.","role":"feature","scope":"column","target":"Count of MORT Measures Worse","treatment":"Cast to integer with 'Not Available' mapped to NaN (or a missing flag), then consider binning to 0/1+ given the sparse tail."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.min","stats.max","stats.median","stats.q1","stats.q3","stats.kurtosis","stats.skew"],"model":"anthropic:claude-opus-4-7","narrative":"Despite being typed numeric, this column behaves like a categorical footnote code: only 4 distinct values appear across 5421 rows, ranging discretely from 5 to 23 with a median of 5 and IQR spanning 5 to 19. Two-thirds of rows (null_rate 0.672) are empty, consistent with footnotes attached only to flagged MORT group records. The bimodal-looking spread (kurtosis -1.96, near-zero skew) reinforces that these are reference codes, not measurements.","role":"metadata","scope":"column","target":"MORT Group Footnote","treatment":"Cast to categorical footnote code and join to a footnote lookup rather than treating as a numeric feature."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.top_value","stats.top_rate","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"This is a categorical column with only two values: \"8\" (84.1% of 5421 rows) and \"Not Available\" (the remaining 863 rows). Despite the name suggesting a count, the field is effectively a flag indicating whether the safety group has the standard 8 measures or no data at all. The complete absence of any other counts is unusual for a 'count' field.","role":"feature","scope":"column","target":"Safety Group Measure Count","treatment":"Recode as a binary available/missing indicator before modelling."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.top_value","stats.top_rate","stats.entropy_ratio","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"This column reports the count of facility safety measures, stored as a categorical with 9 distinct values (1\u20138 plus 'Not Available'). The dominant value is 'Not Available' at 38.1% of 5421 rows, which means missingness is encoded as a string rather than a null (null_rate is 0.0). Among reported counts, '7' (733) and '2' (519) lead, while '4' (223) is the rarest, giving a fairly even spread (entropy_ratio 0.868).","role":"feature","scope":"column","target":"Count of Facility Safety Measures","treatment":"Recode 'Not Available' as null and cast remaining values to integer before modelling."},{"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 categorical column counting how many safety measures improved, with values 0-6 stored as strings alongside a 'Not Available' sentinel. 'Not Available' dominates at 38.1% (2065 of 5421), effectively acting as a hidden null, and the remaining counts decay sharply from 1548 zeros down to just 3 sixes. Entropy ratio of 0.70 across 8 categories reflects this concentration in the low end.","role":"feature","scope":"column","target":"Count of Safety Measures Better","treatment":"Recode 'Not Available' to null and cast remaining levels to integer before modelling."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.top_value","stats.top_rate","stats.entropy_ratio","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"This is a low-cardinality count field (10 distinct values) capturing how many safety measures were rated 'No Different', with integer values 0-8 stored as strings alongside a 'Not Available' sentinel. The dominant surprise is that 38.1% of rows (2065/5421) are 'Not Available', making missingness the modal outcome despite a 0% null rate. Among reported counts, the distribution is fairly even across 1-6 (434-656 each), with 0 (20) and 8 (10) being rare extremes.","role":"feature","scope":"column","target":"Count of Safety Measures No Different","treatment":"Cast numeric strings to int and recode 'Not Available' as an explicit missing indicator before modelling."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.top_value","stats.top_rate","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"This is a low-cardinality count of safety measures rated 'worse', taking only 5 distinct values across 5421 rows with no nulls. Most facilities (54.3%) report 0, and a substantial 2065 rows carry the literal string 'Not Available' rather than a numeric value, mixing missingness into the value domain. Actual counts above 0 are rare (365 ones, 44 twos, 6 threes), giving a heavy zero-and-missing skew.","role":"feature","scope":"column","target":"Count of Safety Measures Worse","treatment":"Recode 'Not Available' to NaN, cast remainder to integer, and treat as a low-count ordinal or binary (>0) feature."},{"confidence":"high","critiques":[],"evidence_keys":["n_unique","null_rate","stats.min","stats.max","stats.median","stats.q1","stats.q3","stats.kurtosis"],"model":"anthropic:claude-opus-4-7","narrative":"This appears to be a footnote code attached to safety group records, stored numerically but acting as a categorical flag with only 4 distinct values ranging from 5 to 23. The column is sparsely populated, with 61.8% nulls, suggesting footnotes apply only to a minority of rows. The bimodal-leaning distribution (median 5, Q3 19, kurtosis -1.81) reinforces that these are discrete code categories rather than a true measurement.","role":"metadata","scope":"column","target":"Safety Group Footnote","treatment":"Cast to categorical and treat nulls as 'no footnote' before any modelling."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.top_value","stats.top_rate","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"A binary categorical field that records the count of measures in a readmission group, but stored as strings: 84.08% of 5421 rows are \"11\" and the remaining 863 rows are \"Not Available\". With only 2 distinct values and no nulls, this acts as a presence flag rather than a true count.","role":"feature","scope":"column","target":"READM Group Measure Count","treatment":"Recode to a boolean availability flag since the numeric value is constant when present."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.top_value","stats.top_rate","stats.entropy_ratio","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"This column appears to be the count of hospital readmission (READM) measures reported per facility, stored as strings rather than integers. Values range across 12 categories from \"2\" through \"11\" plus a sizeable \"Not Available\" bucket that dominates at 21.2% (1,150 of 5,421 rows). Distribution across the numeric levels is fairly even (entropy ratio 0.965), with no nulls but the string \"Not Available\" effectively acting as missingness.","role":"feature","scope":"column","target":"Count of Facility READM Measures","treatment":"Recode \"Not Available\" to NaN and cast remaining values to integer before modelling."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.cardinality","stats.top_rate","stats.top_value","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"This column counts how many readmission measures a provider scored 'better' on, stored as strings ranging from '0' to '5' alongside a 'Not Available' sentinel. The distribution is heavily concentrated at '0' (61.5%, 3332 of 5421 rows), and 'Not Available' is the second most common value at 1150 rows, exceeding any nonzero count. Only 41 rows score 3 or higher, so meaningful positive signal is rare.","role":"feature","scope":"column","target":"Count of READM Measures Better","treatment":"Cast numerics to int, encode 'Not Available' as a missing flag, and consider collapsing the long tail (3-5) into a single bucket."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.top_value","stats.top_rate","stats.entropy_ratio","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"This is a count of hospital readmission measures where performance was 'no different' than national, stored as strings ranging '1'\u2013'9' (plus likely higher) alongside a 'Not Available' sentinel. The sentinel dominates at 21.2% (1150 of 5421), and the 13 distinct values are spread fairly evenly (entropy ratio 0.92), with numeric counts each landing in the 370\u2013500 range.","role":"feature","scope":"column","target":"Count of READM Measures No Different","treatment":"Cast to integer after replacing 'Not Available' with NaN, then treat as ordinal numeric."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.top_value","stats.top_rate","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"This appears to be a count of readmission measures rated 'worse' per hospital, stored as a categorical/string column with 9 distinct values ranging from '0' to '7' plus 'Not Available'. The distribution is heavily concentrated at zero (55.1% of 5,421 rows) and 'Not Available' accounts for 1,150 rows, which is a substantial missing-data signal masquerading as a category. Higher counts are rare, with only 31 rows at 4 or above.","role":"feature","scope":"column","target":"Count of READM Measures Worse","treatment":"Cast numeric levels to integer, recode 'Not Available' as null, then treat as ordinal or count feature."},{"confidence":"high","critiques":[],"evidence_keys":["n_unique","null_rate","stats.min","stats.q1","stats.q3","stats.max","stats.mean"],"model":"anthropic:claude-opus-4-7","narrative":"This appears to be a footnote/flag code attached to a readmission metric, encoded numerically with only 3 distinct values (5, 19, and 22 based on the quartiles and max). The column is overwhelmingly empty at a 78.79% null rate, meaning footnotes apply to a small minority of records. Despite being stored as numeric, the values are categorical codes \u2014 the mean of 15.15 and std of 6.37 have no real interpretive meaning.","role":"metadata","scope":"column","target":"READM Group Footnote","treatment":"Cast to categorical footnote codes and treat nulls as 'no footnote' rather than imputing."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.top_value","stats.top_rate","stats.entropy_ratio","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"Binary categorical with only two values: \"8\" (84.1% of 5421 rows) and \"Not Available\" (the remaining 863). The literal string \"Not Available\" stands in for missing data, so the column is effectively a constant of 8 with a 15.9% missingness flag rather than a true feature. Entropy ratio of 0.63 confirms the low information content.","role":"metadata","scope":"column","target":"Pt Exp Group Measure Count","treatment":"Recode \"Not Available\" to null and drop, or keep only as a binary missingness indicator."},{"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 column reports the count of facility patient experience measures, but it is effectively binary: every one of the 5421 rows is either the literal string \"8\" (58.2%) or \"Not Available\" (41.8%). The high entropy ratio of 0.98 reflects that near 50/50 split rather than any real numeric variation. The surprise is that a supposed count has only one non-null numeric level, so it carries no granularity beyond a presence/absence flag.","role":"feature","scope":"column","target":"Count of Facility Pt Exp Measures","treatment":"Recode as a binary has_measures flag (8 vs Not Available) rather than treating as a numeric count."},{"confidence":"high","critiques":[],"evidence_keys":["n_unique","null_rate","stats.min","stats.max","stats.median","stats.q1","stats.q3","stats.kurtosis","n"],"model":"anthropic:claude-opus-4-7","narrative":"This is a footnote code attached to a 'Pt Exp Group' (likely patient experience group) metric, encoded numerically but with only 3 distinct values (5, ~19, 22) across 5421 rows. It is null 58.18% of the time, which is expected for footnote columns that flag exceptions on a minority of rows. The bimodal-looking spread (median 5, Q3 19, max 22) and negative kurtosis (-1.66) confirm it behaves as a sparse categorical flag rather than a continuous measure.","role":"metadata","scope":"column","target":"Pt Exp Group Footnote","treatment":"Cast to categorical footnote codes and treat nulls as 'no footnote' rather than imputing numerically."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.top_value","stats.top_rate","top_values","stats.cardinality"],"model":"anthropic:claude-opus-4-7","narrative":"A binary categorical field where 84.1% of the 5421 rows take the literal string \"12\" and the remaining 863 rows are \"Not Available\". Despite the name suggesting a count, it is stored as a string with only 2 distinct values and no nulls, so \"Not Available\" is functioning as an in-band missing marker rather than a true category.","role":"metadata","scope":"column","target":"TE Group Measure Count","treatment":"Recode \"Not Available\" to null and collapse to a boolean indicator, since the only real value is 12."},{"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 column reports the count of Facility TE (Timely & Effective) Measures per row, stored as strings with 13 distinct values across 5,421 records. The most common value is the sentinel \"Not Available\" at 17.1% (928 rows), with numeric counts ranging at least from 4 to 12 mixed in as text. Entropy ratio of 0.93 indicates the non-null values are spread fairly evenly across the count buckets.","role":"feature","scope":"column","target":"Count of Facility TE Measures","treatment":"Coerce to integer with \"Not Available\" mapped to NaN, then treat as an ordinal/numeric feature."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.min","stats.max","stats.median","stats.q1","stats.q3","stats.iqr","stats.skew","stats.n_outliers","stats.outlier_rate"],"model":"anthropic:claude-opus-4-7","narrative":"This appears to be a footnote code column for a 'TE Group' classification, stored numerically but functioning as a categorical reference (only 3 unique values across 5421 rows). It is mostly empty (82.88% null), and among populated rows the value 19 dominates so heavily that q1, median, and q3 all equal 19, producing a zero IQR and a strong negative skew of -2.43. The 133 flagged outliers (14.3%) are simply the minority codes (down to 5) being measured against a degenerate distribution.","role":"metadata","scope":"column","target":"TE Group Footnote","treatment":"Cast to categorical footnote code and exclude from numeric modelling."}],"providers":["anthropic:claude-opus-4-7"],"total_usage":{"completion_tokens":10947,"prompt_tokens":42618,"total_tokens":53565}},"language_counts":{},"meta":{"generated_at":"2026-05-01T17:51:44+00:00","mode":"full","row_count":5421,"sampled_rows":5421,"seed":42,"source":"/home/coolhand/html/datavis/data_trove/cache/cms/cms_hospitals_20260121.parquet"},"notes":[],"saturn_version":"0.2.0","schema":{"Count of Facility MORT Measures":"categorical","Count of Facility Pt Exp Measures":"categorical","Count of Facility READM Measures":"categorical","Count of Facility Safety Measures":"categorical","Count of Facility TE Measures":"categorical","Count of MORT Measures Better":"categorical","Count of MORT Measures No Different":"categorical","Count of MORT Measures Worse":"categorical","Count of READM Measures Better":"categorical","Count of READM Measures No Different":"categorical","Count of READM Measures Worse":"categorical","Count of Safety Measures Better":"categorical","Count of Safety Measures No Different":"categorical","Count of Safety Measures Worse":"categorical","Hospital overall rating":"categorical","Hospital overall rating footnote":"categorical","MORT Group Footnote":"numeric","MORT Group Measure Count":"categorical","Meets criteria for birthing friendly designation":"categorical","Pt Exp Group Footnote":"numeric","Pt Exp Group Measure Count":"categorical","READM Group Footnote":"numeric","READM Group Measure Count":"categorical","Safety Group Footnote":"numeric","Safety Group Measure Count":"categorical","TE Group Footnote":"numeric","TE Group Measure Count":"categorical","address":"text","city":"text","county_name":"text","emergency_services":"categorical","facility_id":"text","facility_name":"text","hospital_ownership":"categorical","hospital_type":"categorical","phone_number":"text","state":"categorical","zip_code":"numeric"}}