{"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/Town","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/Parish","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":"Telephone 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","Meets criteria for birthing friendly designation","Hospital Type","Hospital Ownership","State","Emergency Services","Count of MORT Measures Worse","Count of READM Measures Better"],"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%, with Critical Access and Psychiatric making up most of the remainder.","column":"Hospital Type","kind":"donut"},{"caption":"Voluntary non-profit Private leads at ~42%; useful for segmenting quality outcomes by ownership model.","column":"Hospital Ownership","kind":"bar"},{"caption":"Hospital counts by state \u2014 TX, CA, and FL top the list; helpful for normalizing any state-level comparisons.","column":"State","kind":"bar"},{"caption":"83% of facilities offer emergency services, a quick sanity check on facility mix before quality analysis.","column":"Emergency Services","kind":"donut"}],"model":"anthropic:claude-opus-4-7","narrative":"This dataset is a CMS hospital directory covering 5,421 U.S. hospitals across 56 state/territory codes, with 38 columns mixing facility identifiers (Facility ID, Name, Address, Phone), location fields, and a battery of CMS quality-measure summaries (Mortality, Readmission, Safety, Patient Experience, Timely & Effective care). Two things are worth a closer look first: the Hospital overall rating is 'Not Available' for 47% of facilities, and the 'Meets criteria for birthing friendly designation' field is 58% null with only 'Y' as a value, so any rating- or designation-based analysis will be heavily gated by missingness. Beyond that, the mix is dominated by Acute Care Hospitals (3,120) and Voluntary non-profit \u2013 Private ownership (2,291 / ~42%), with Texas, California, and Florida holding the largest state shares. The 'Count of \u2026 Measures Worse/Better' fields are highly skewed toward 0, suggesting most hospitals look 'no different than national average' on CMS comparisons \u2014 a useful framing before drilling into outliers.","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":"Facility ID is a fixed-width 6-character single-token code, unique across all 5421 rows with zero nulls or duplicates. Every value is one word in all caps with length exactly 6, and the sampled tokens (e.g., 010001, 010005) are zero-padded numeric strings consistent with a primary facility identifier.","role":"identifier","scope":"column","target":"Facility ID","treatment":"Treat as primary key; left-join on this id and exclude from modelling features."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.allcaps_rate","stats.duplicate_rate","stats.n_duplicates","stats.len_mean","stats.len_median","stats.word_mean","top_words"],"model":"anthropic:claude-opus-4-7","narrative":"This column holds names of healthcare facilities, dominated by terms like 'hospital' (2740), 'center' (1579), and 'medical' (1444), with a typical length of 4 words / 28 characters. Values are near-unique (5286 distinct out of 5421) yet 135 duplicates remain, suggesting either multi-site chains or repeated reporting rows for the same facility. Nearly everything is uppercase (99.3% allcaps rate), which will trip case-sensitive joins.","role":"identifier","scope":"column","target":"Facility Name","treatment":"Normalize case and whitespace before using as a join key on facility."},{"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, with 5387 unique values across 5421 rows (near-unique) and no nulls. 99.2% are all-caps and the top tokens are 'street', 'st', 'avenue', 'drive', 'road', confirming postal-style entries averaging 3.75 words and 19 characters. 34 duplicates exist but no boilerplate, URLs, or emoji.","role":"identifier","scope":"column","target":"Address","treatment":"Drop or geocode/parse into structured components before modelling; do not feed raw."},{"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_mean","stats.len_max","top_values","top_words"],"model":"anthropic:claude-opus-4-7","narrative":"This is a US city/town name field, almost entirely uppercased (allcaps_rate 0.994) and dominated by single-word entries (one_word_rate 0.771, word_mean 1.24). Of 5421 rows there are 3049 unique values with a 0.438 duplicate rate, led by CHICAGO (34), HOUSTON (31), and COLUMBUS (23). 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/Town","treatment":"Normalize case and standardize against a city gazetteer (ideally with state) before grouping or joining."},{"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":"US state codes covering 56 distinct values across 5,421 rows with no nulls \u2014 likely all 50 states plus territories/DC. Distribution is broad and near-uniform (entropy ratio 0.917), with TX leading at only 8.5% and CA, FL, IL, OH following. The 56 cardinality is worth noting since it exceeds the standard 50 states.","role":"feature","scope":"column","target":"State","treatment":"one-hot or target-encode for modelling; optionally group rare territories."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.min","stats.max","stats.q1","stats.q3","stats.mean","stats.std"],"model":"anthropic:claude-opus-4-7","narrative":"This is a US ZIP code field stored as a numeric column, with 4721 unique values across 5421 rows and no nulls. The range (603 to 99929) and broad IQR (32771-76104) are consistent with national ZIP coverage, and leading-zero ZIPs (e.g., the min of 603) have already been corrupted by numeric storage. Treating the mean (53780) or std (27064) as meaningful is misleading since ZIPs are categorical identifiers, not quantities.","role":"identifier","scope":"column","target":"ZIP Code","treatment":"Cast to zero-padded 5-character strings and treat as a categorical/geographic key rather than a numeric feature."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.allcaps_rate","stats.one_word_rate","stats.duplicate_rate","stats.len_mean","stats.vocab_size","top_values","top_words"],"model":"anthropic:claude-opus-4-7","narrative":"This column holds U.S. county or parish names, stored uppercase and almost always as a single token (one_word_rate 0.87, allcaps_rate 1.0). With 1,555 uniques across 5,421 rows and a 71.3% duplicate rate, common counties repeat heavily \u2014 LOS ANGELES (88), JEFFERSON and COOK (59 each) lead. Note that vocab_size (1591) exceeds n_unique (1555), implying multi-word names like SAN/LOS/ST. variants contribute extra tokens.","role":"feature","scope":"column","target":"County/Parish","treatment":"Normalize casing and join to a state column before using as a categorical geographic feature."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.len_min","stats.len_max","stats.len_mean","stats.word_mean","stats.duplicate_rate","stats.n_duplicates","top_words","alerts"],"model":"anthropic:claude-opus-4-7","narrative":"This column holds US-style telephone numbers, every value exactly 14 characters long with a mean of 2 words, consistent with a `(NPA) NNN-NNNN` format. Of 5421 rows, 5383 are unique and 38 duplicates appear (0.7%), with no nulls; the most common tokens are area codes like (406), (605), and (402). The near-unique cardinality and rigid length make this an identifier rather than a feature.","role":"identifier","scope":"column","target":"Telephone Number","treatment":"Drop for modelling; retain as a contact identifier or parse out the area code if geography is useful."},{"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":"Categorical classifier of hospital facilities across 8 types, with no nulls in 5421 rows. Acute Care Hospitals dominate at 57.6% (3120 records), followed by Critical Access (1375) and Psychiatric (626); the long tail is sparse, with only 4 Long-term facilities. Entropy ratio of 0.55 confirms the distribution is heavily concentrated in the top category.","role":"feature","scope":"column","target":"Hospital Type","treatment":"One-hot encode, optionally collapsing the four rarest types 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":"Categorical descriptor of hospital ownership type across 5421 records, with 12 distinct categories and no nulls. Distribution is dominated by 'Voluntary non-profit - Private' at 42.26% of rows, followed by 'Proprietary' at 1067 and a long tail down to 'Government - Federal' at 44. Entropy ratio of 0.72 indicates moderate concentration but reasonable spread across the taxonomy.","role":"feature","scope":"column","target":"Hospital Ownership","treatment":"One-hot or target-encode for modelling; consider collapsing rare tiers like 'Physician' and 'Government - Federal'."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.top_rate","stats.top_value","top_values","stats.entropy_ratio"],"model":"anthropic:claude-opus-4-7","narrative":"Binary Yes/No flag indicating whether emergency services were involved or available, with no nulls across 5421 rows. The distribution is imbalanced: 'Yes' accounts for 83.1% (4505) versus 916 'No' responses, giving an entropy ratio of 0.655.","role":"feature","scope":"column","target":"Emergency Services","treatment":"Encode as a binary 0/1 indicator; be mindful of class imbalance if used as a target."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.cardinality","stats.entropy","stats.top_rate","stats.top_value","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"This appears to be a binary flag indicating whether a hospital meets criteria for a 'birthing friendly' designation, but it functions as a presence indicator only. Of 5421 rows, 58.24% are null and the remaining 2264 are all 'Y' \u2014 there are no 'N' values, giving cardinality 1 and zero entropy. Nulls effectively mean 'not designated' rather than missing data.","role":"feature","scope":"column","target":"Meets criteria for birthing friendly designation","treatment":"Recode nulls as 'N' to form a usable binary indicator, or drop since it carries the same information as the null mask."},{"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 the CMS-style 1-5 hospital star rating stored as a string, with a sixth bucket 'Not Available' for unrated facilities. The striking issue is that 'Not Available' dominates at 47.1% of 5,421 rows, outnumbering every actual rating; among rated hospitals, 3 stars (937) is most common and 1 star (229) least. Entropy ratio of 0.83 across 6 categories confirms the distribution is spread but heavily anchored by missingness-as-category.","role":"label","scope":"column","target":"Hospital overall rating","treatment":"Recode 'Not Available' to NaN and treat the remainder as an ordinal 1-5 scale."},{"confidence":"high","critiques":[],"evidence_keys":["null_rate","n_unique","top_value","top_rate","entropy_ratio","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"Footnote codes attached to the Hospital overall rating, with only 7 distinct values across 5,421 rows. Over half the column is null (null_rate 0.527), and among populated rows code '16' dominates at 65.4% followed by '19', so the field carries low information (entropy_ratio 0.41). One compound entry '16, 23' appears twice, indicating values can be multi-coded.","role":"metadata","scope":"column","target":"Hospital overall rating footnote","treatment":"Keep as a categorical flag alongside the rating; split the rare compound codes if you need per-footnote analysis."},{"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 is a binary categorical field indicating the count of measures in a mortality (MORT) group, holding only the value '7' (84.1% of rows) or 'Not Available' (the remaining 863 rows). Despite being labeled a count, it functions as a presence flag: when data exists, the count is always 7. No nulls are recorded, since missingness is encoded as the literal string 'Not Available'.","role":"feature","scope":"column","target":"MORT Group Measure Count","treatment":"Recode to a boolean availability flag ('7' vs 'Not Available') 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":"Likely the count of facility mortality (MORT) measures reported per hospital, stored as strings 1-7 alongside a 'Not Available' sentinel. The dominant value is 'Not Available' at 32.8% (1777/5421), which makes the column nominally categorical with 8 levels even though 7 of them are integers. Entropy ratio of 0.92 indicates the non-null counts are spread fairly evenly across 1-7.","role":"feature","scope":"column","target":"Count of Facility MORT Measures","treatment":"Replace 'Not Available' with NaN, cast remaining values to integer, and optionally add a missingness indicator."},{"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":"Categorical count of mortality measures on which a hospital performed better than the national rate, encoded as small integers stored as strings (0\u20137) plus a 'Not Available' sentinel. The distribution is heavily concentrated at 0 (57.8% of 5421 rows) with another 1777 rows marked 'Not Available', leaving only ~10% of hospitals showing any 'better' measure. Entropy ratio of 0.458 confirms the skew, and the sentinel string blocks direct numeric use.","role":"feature","scope":"column","target":"Count of MORT Measures Better","treatment":"Replace 'Not Available' with NaN, cast remaining values to int, and consider binarising (any-better vs none) given the skew."},{"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 counts how many mortality (MORT) measures a hospital scored 'No Different' on, encoded as a small integer 0-7 but stored as strings alongside a 'Not Available' sentinel. Cardinality is just 9 with high entropy ratio (0.885), meaning values are spread fairly evenly across the integers \u2014 except 'Not Available' dominates at 32.8% (1777/5421) and '0' is rare at only 12 rows. Analysts should note the heavy missing-as-string encoding and the near-empty '0' bucket.","role":"feature","scope":"column","target":"Count of MORT Measures No Different","treatment":"Recode 'Not Available' to null and cast remaining values to integer 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 column counts how many mortality (MORT) measures a hospital scored worse than the national average, encoded as small integers 0-5 with a 'Not Available' sentinel mixed in. Roughly 60% of 5421 rows are '0' and another 1777 are 'Not Available', leaving only 378 hospitals flagged on any MORT measure and just 1 hospital at the maximum of 5. The mixed string/integer encoding is the main gotcha.","role":"feature","scope":"column","target":"Count of MORT Measures Worse","treatment":"Replace 'Not Available' with NaN and cast to integer before modelling."},{"confidence":"high","critiques":[],"evidence_keys":["n_unique","null_rate","min","max","q1","q3","kurtosis","stats"],"model":"anthropic:claude-opus-4-7","narrative":"This appears to be a footnote code attached to MORT (mortality) group records, stored as a small numeric category with only 4 distinct values ranging from 5 to 23. Two-thirds of rows are null (null_rate 0.672), suggesting the footnote applies only to a minority of records. The strongly negative kurtosis (-1.96) and bimodal-looking quartiles (Q1=5, Q3=19) confirm these are discrete codes rather than a continuous measurement.","role":"metadata","scope":"column","target":"MORT Group Footnote","treatment":"Cast to categorical and treat nulls as 'no footnote' rather than imputing numerically."},{"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":"Binary categorical with only two values across 5421 rows: the literal string \"8\" (84.1%) and \"Not Available\" (15.9%). Despite the name suggesting a count, it functions as a flag indicating either a fixed measure count of 8 or missing data encoded as text.","role":"feature","scope":"column","target":"Safety Group Measure Count","treatment":"Recode \"Not Available\" to null and binarize, or drop given near-constant value."},{"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-8 plus 'Not Available'). The dominant value is 'Not Available' at 38.1% (2,065 of 5,421 rows), making missingness encoded as a string rather than null. Among reported counts, 7 is most common (733), and the distribution across 1-8 is uneven rather than monotonic.","role":"feature","scope":"column","target":"Count of Facility Safety Measures","treatment":"Recode 'Not Available' to null and cast remaining values 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 small-integer count (0-6) of safety measures rated 'Better', stored as strings alongside a 'Not Available' sentinel. The sentinel dominates at 38.1% (2065/5421) of rows, and the distribution is heavily right-skewed: 0 and 1 cover 2600 rows while 5 and 6 appear only 14 and 3 times. Cardinality is 8 with entropy ratio 0.70, so most signal sits in the lower bins.","role":"feature","scope":"column","target":"Count of Safety Measures Better","treatment":"Recode 'Not Available' to missing, cast remaining values to integer, and consider binning the sparse 4-6 tail."},{"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-8) of safety measures rated 'no different', stored as strings alongside a 'Not Available' sentinel. The sentinel dominates at 38.1% of 5421 rows (2065), making it the modal value ahead of any actual count. Among real values, 5, 2, 4, and 1 cluster between 509-656 occurrences while 0 and 8 are rare (20 and 10).","role":"feature","scope":"column","target":"Count of Safety Measures No Different","treatment":"Cast numeric levels to int and treat 'Not Available' as an explicit missing indicator 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 is a low-cardinality count column (5 distinct values) recording how many safety measures got worse, taking integer values 0-3 plus a 'Not Available' sentinel. Most rows (54.3%) are 0 and another 2065 are 'Not Available', leaving only 415 rows with any worsening measures (1-3). The mix of numeric strings and a textual missing-marker means it isn't cleanly numeric as stored.","role":"feature","scope":"column","target":"Count of Safety Measures Worse","treatment":"Recode 'Not Available' to NaN and cast to integer before modelling."},{"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 column tied to a 'Safety Group' classification, encoded numerically but with only 4 distinct values ranging from 5 to 23. 61.8% of rows are null, suggesting footnotes apply only to a minority of records. The bimodal-looking distribution (median 5, q3 19, kurtosis -1.81) indicates these are categorical flags rather than a true measurement.","role":"metadata","scope":"column","target":"Safety Group Footnote","treatment":"Cast to categorical and treat nulls as 'no footnote' rather than imputing numerically."},{"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":"A categorical column with only two distinct values: the count '11' covers 84.1% of 5421 rows, with the remaining 863 rows marked 'Not Available'. Functionally this is a binary availability flag rather than a true count, since '11' is the only numeric value present. The mixing of a numeric string with a sentinel 'Not Available' is the main surprise.","role":"metadata","scope":"column","target":"READM Group Measure Count","treatment":"Recode to a binary available/not-available 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 readmission (READM) measures available per facility, stored as strings rather than integers. With 12 distinct values and entropy ratio 0.965, the values are spread fairly evenly across small integers, but the modal value is the literal string \"Not Available\" at 21.2% (1150 of 5421 rows), which masks missingness as a category. Numeric values like \"11\", \"8\", \"6\", and \"9\" dominate the rest.","role":"feature","scope":"column","target":"Count of Facility READM Measures","treatment":"Replace \"Not Available\" with null and cast 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":"Counts how many readmission measures a hospital scored 'better than national rate' on, encoded as small integers 0-5 with 'Not Available' as a seventh category. The distribution is heavily concentrated at 0 (61.5% of 5421 rows) and ties off rapidly: only 28 rows hit 3, 10 hit 4, and 3 hit 5. Notably, 'Not Available' (1150 rows) is the second most common value, larger than every nonzero count combined.","role":"feature","scope":"column","target":"Count of READM Measures Better","treatment":"Cast numeric levels to int and treat 'Not Available' as an explicit missing-category flag 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 column counts how many readmission (READM) measures at a hospital scored 'No Different' than the national rate, encoded as integers 1-9+ alongside a 'Not Available' sentinel. With 13 unique values and entropy ratio 0.92, the distribution is fairly flat across counts 1-9 (each ~370-500 rows), but 'Not Available' is the single largest bucket at 21.2% (1,150 of 5,421). That missingness-as-string is the main surprise and would corrupt any numeric aggregation if not handled.","role":"feature","scope":"column","target":"Count of READM Measures No Different","treatment":"Cast to integer with 'Not Available' converted to NaN 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 appears to be a hospital-level count of readmission measures performing worse than the national rate, stored as a categorical/string field with values 0-7 plus a 'Not Available' sentinel. The distribution is heavily concentrated at '0' (55.1% of 5421 rows) with another 1150 rows marked 'Not Available', leaving genuine non-zero counts as a long tail that thins to just 1-2 hospitals at values 5, 6, and 7. The mixing of numeric strings with 'Not Available' is the main gotcha.","role":"feature","scope":"column","target":"Count of READM Measures Worse","treatment":"Replace 'Not Available' with NaN and cast remaining values to integer before modelling."},{"confidence":"high","critiques":[],"evidence_keys":["n_unique","null_rate","stats.min","stats.max","stats.median","stats.q1","stats.q3","stats.skew"],"model":"anthropic:claude-opus-4-7","narrative":"Likely a footnote/flag code attached to a hospital readmission group metric, encoded as a small integer rather than a true numeric quantity. Only 3 distinct values appear (min 5, max 22, median 19) and 78.79% of rows are null, so the column is sparse and categorical in nature. The non-null distribution is concentrated at the higher codes, with q1=5 and q3=19 indicating a bimodal split between two code clusters.","role":"metadata","scope":"column","target":"READM Group Footnote","treatment":"Cast to categorical footnote code 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","stats.entropy_ratio","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"A binary categorical with only two values: the string \"8\" covering 84.08% of 5,421 rows and \"Not Available\" for the remaining 863. This looks like a measure-count field that is fixed at 8 when reported, otherwise marked as missing via a sentinel rather than a true null (null_rate is 0.0). Entropy ratio of 0.63 reflects that imbalance.","role":"metadata","scope":"column","target":"Pt Exp Group Measure Count","treatment":"Convert \"Not Available\" to a true null and treat as a binary missingness indicator; the column carries little signal otherwise."},{"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":"This column is a binary categorical indicator with only two distinct values across all 5,421 rows: the literal string \"8\" (58.2%) and \"Not Available\" (41.8%). Despite being labeled as a count, it never varies numerically \u2014 every reporting facility either has exactly 8 measures or none reported, making this effectively a presence/absence flag with high entropy ratio (0.98). The 41.8% \"Not Available\" rate is a substantial missingness signal masquerading as a category.","role":"feature","scope":"column","target":"Count of Facility Pt Exp Measures","treatment":"Recode as a binary available/not-available flag 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"],"model":"anthropic:claude-opus-4-7","narrative":"This appears to be a footnote code attached to a 'Pt Exp Group' (patient experience group) measure, stored as a numeric but functioning as a categorical flag. Only 3 distinct values appear (min 5, median 5, max 22) and 58.18% of rows are null, indicating footnotes are applied sparingly to a minority of records. The bimodal-looking spread (Q1=5, Q3=19, kurtosis -1.66) confirms this is a small set of discrete codes rather than a true numeric measurement.","role":"metadata","scope":"column","target":"Pt Exp Group Footnote","treatment":"Cast to categorical footnote code and treat nulls as 'no footnote' rather than missing."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.cardinality","stats.top_value","stats.top_rate","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"Binary categorical column with only two values: '12' (84.1% of rows) and 'Not Available' (the remaining 863 rows). The literal '12' suggests this captures a count of measures per TE group, but it is stored as a string and effectively constant when present. The 'Not Available' sentinel functions as the only real source of variation.","role":"feature","scope":"column","target":"TE Group Measure Count","treatment":"Convert to a boolean is_available flag; drop the constant '12' value."},{"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 TE (timely & effective care) measures available per record, but it's stored as strings mixing numeric values (\"4\" through \"12\") with the sentinel \"Not Available\". The most common value is \"Not Available\" at 17.1% (928 of 5421), making missingness the modal category despite a reported null_rate of 0. Entropy ratio of 0.93 across 13 categories shows the non-null counts are spread fairly evenly, with \"10\" and \"11\" the dominant numeric values.","role":"feature","scope":"column","target":"Count of Facility TE Measures","treatment":"Recode \"Not Available\" to null and cast remaining values to integer before modelling."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.min","stats.max","stats.q1","stats.q3","stats.iqr","stats.median","stats.skew","stats.mean","stats.n_outliers","stats.outlier_rate"],"model":"anthropic:claude-opus-4-7","narrative":"This appears to be a footnote reference code for a 'TE Group', stored numerically but functioning as a categorical pointer with only 3 distinct values across 5421 rows. It is overwhelmingly empty (82.88% null) and heavily concentrated at 19 (both q1 and q3 equal 19, iqr=0), producing a strong left skew (-2.43) and 133 outliers (14.33%) at the low end down to 5. The numeric stats like mean=17.58 are misleading given the column is effectively a small code set.","role":"metadata","scope":"column","target":"TE Group Footnote","treatment":"Cast to categorical and treat nulls as 'no footnote'; do not use as a numeric feature."}],"providers":["anthropic:claude-opus-4-7"],"total_usage":{"completion_tokens":10935,"prompt_tokens":42663,"total_tokens":53598}},"language_counts":{},"meta":{"generated_at":"2026-05-01T18:06:00+00:00","mode":"full","row_count":5421,"sampled_rows":5421,"seed":42,"source":"/home/coolhand/datasets/us-inequality-atlas/healthcare/cms_hospitals_2025.csv"},"notes":[],"saturn_version":"0.2.0","schema":{"Address":"text","City/Town":"text","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","County/Parish":"text","Emergency Services":"categorical","Facility ID":"text","Facility Name":"text","Hospital Ownership":"categorical","Hospital Type":"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","State":"categorical","TE Group Footnote":"numeric","TE Group Measure Count":"categorical","Telephone Number":"text","ZIP Code":"numeric"}}