{"columns":[{"alerts":[{"code":"one_word","level":"warn","message":"73.2% rows are a single word"},{"code":"short_text","level":"info","message":"95th-percentile length under 20 chars"},{"code":"duplicates","level":"warn","message":"60.1% duplicate strings"}],"column":"city","extras":{"language_counts":{},"language_sample_size":5000,"length_histogram":{"counts":[239,615,1387,1495,1431,1548,2391,630,455,318,145,137,63,49,32,11,7,5,5,5,10,0,6,1,1,0,1,0,0,0,0,0,0,1,0,0,0,0,0,1],"edges":[3.0,4.15,5.3,6.449999999999999,7.6,8.75,9.899999999999999,11.049999999999999,12.2,13.35,14.5,15.649999999999999,16.799999999999997,17.95,19.099999999999998,20.25,21.4,22.549999999999997,23.7,24.849999999999998,26.0,27.15,28.299999999999997,29.45,30.599999999999998,31.749999999999996,32.9,34.05,35.199999999999996,36.349999999999994,37.5,38.65,39.8,40.949999999999996,42.099999999999994,43.25,44.4,45.55,46.699999999999996,47.849999999999994,49.0]},"near_unique":false,"sample":["Ann Arbor","Forest Park","Fernandina","Gregg","Sheridan","Greenville","Dawson Springs","Higginsville","Houston","Pontiac","Whidbey Island","Madison","Annapolis","Bloomfield","Rockville","San Diego","Pittsburgh","Athens","Denver","Howell","Pawhuska","Rochester","Taunton","Ringtown","Hanover","Savannah","Wynantskill","San Gabriel","Henryville","Greenwood","Pekin","Rensselaer","Springfield","Vermilion","Cleveland","Campbellsville","Fairfield","Lansingburgh","Hardburly","La Crosse","El Paso","Spearfish","Tucson","Rapid City","Minneapolis","Spartanburg","Mobile","Warren","Montebello","St. Petersburg"],"top_values":[["Los Angeles",61],["San Antonio",55],["Honolulu",43],["Pittsburgh",42],["Columbus",41],["Salem",40],["Springfield",40],["El Paso",38],["Houston",34],["Laredo",32],["Orlando",32],["Riverside",30],["Tucson",30],["Chicago",30],["Portland",28],["San Diego",27],["San Francisco",27],["Louisville",27],["Seattle",27],["Lancaster",26]],"top_words":[["city",275],["county",215],["san",192],["st.",152],["new",125],["fort",117],["lake",110],["springs",95],["island",84],["west",80],["los",80],["park",79],["angeles",70],["falls",66],["valley",58],["beach",58],["antonio",55],["east",53],["el",52],["santa",49],["hill",46],["pittsburgh",43],["honolulu",43],["springfield",42],["north",41]],"vocab_skipped":null,"word_histogram":{"counts":[8047,0,0,0,0,0,2717,0,0,0,0,0,197,0,0,0,0,0,25,0,0,0,0,0,2,0,0,0,0,1],"edges":[1.0,1.1666666666666667,1.3333333333333333,1.5,1.6666666666666665,1.8333333333333333,2.0,2.1666666666666665,2.333333333333333,2.5,2.6666666666666665,2.833333333333333,3.0,3.1666666666666665,3.333333333333333,3.5,3.6666666666666665,3.833333333333333,4.0,4.166666666666666,4.333333333333333,4.5,4.666666666666666,4.833333333333333,5.0,5.166666666666666,5.333333333333333,5.5,5.666666666666666,5.833333333333333,6.0]}},"kind":"text","n":10992,"n_null":3,"n_unique":4385,"null_rate":0.0002729257641921397,"stats":{"allcaps_rate":0.000455000455000455,"boilerplate_rate":0.0,"duplicate_rate":0.6009646009646009,"emoji_rate":0.0,"len_max":49,"len_mean":9.042770042770043,"len_median":9.0,"len_min":3,"len_p95":14.0,"n_duplicates":6604,"n_empty":0,"one_word_rate":0.7322777322777323,"readability_flesch_mean":20.487975000000034,"url_rate":9.1000091000091e-05,"vocab_size":3988,"word_mean":1.2911092911092912,"word_median":1.0}},{"alerts":[{"code":"imbalance","level":"warn","message":"top value is 100.0% of rows"}],"column":"country","extras":{"singletons":0,"top_values":[["United States",10992]]},"kind":"categorical","n":10992,"n_null":0,"n_unique":1,"null_rate":0.0,"stats":{"cardinality":1,"entropy":-0.0,"entropy_ratio":0.0,"top_rate":1.0,"top_value":"United States"}},{"alerts":[{"code":"near_unique","level":"info","message":"100.0% of rows are unique strings"}],"column":"description","extras":{"language_counts":{},"language_sample_size":5000,"length_histogram":{"counts":[1623,3145,2473,1528,810,509,303,195,124,71,63,37,27,20,15,12,10,8,6,2,1,2,1,2,0,0,2,0,1,0,0,0,0,0,0,0,1,0,0,1],"edges":[2.0,133.95,265.9,397.84999999999997,529.8,661.75,793.6999999999999,925.6499999999999,1057.6,1189.55,1321.5,1453.4499999999998,1585.3999999999999,1717.35,1849.2999999999997,1981.2499999999998,2113.2,2245.1499999999996,2377.1,2509.0499999999997,2641.0,2772.95,2904.8999999999996,3036.85,3168.7999999999997,3300.7499999999995,3432.7,3564.6499999999996,3696.5999999999995,3828.5499999999997,3960.4999999999995,4092.45,4224.4,4356.349999999999,4488.299999999999,4620.25,4752.2,4884.15,5016.099999999999,5148.049999999999,5280.0]},"near_unique":true,"sample":["Story goes some time in the late 70s a student named Mary (last name never mentioned) who, while working on some lighting fixtures alone one day, fell from the catwalks head first and died upon the stage. Sightings include actors and stagehands seeing a girl up in the catwalks wearing a light pink dress. Also, in the prop room where all the senior thespians spray paint their names on the wall shortly after Mary's death her name appeared in bold red paint above the doorway about seventeen feet from the floor and upside down.","There is also a women whom wears a white dress that sings a lullaby to a small infant she carries with her. She is usually seen at dusk but has also been seen during reenactments of the battle.","Fort Clinch is an old Union Civil War fort that was never finished due to of lack of funding from the government. During construction, the fort was ambushed quite a few times by Confederate troops. Several of the Union men died in the process. One incident included a man who was shot after promising his wife in a letter that he would not die until seeing her again. He is said to haunt the fort today. Re-enactors that volunteer at the fort often see his ghost in the courtyard along with several of his comrades. Perhaps he is searching for his wife? Fort Clinch Experience","Old Caddo Indian museum - Museum off Farmed Market road also known as loop 1845 has been closed down for many years. The museum displayed artifacts that were found in burial sites in East Texas. Several people have seen a little ghost girl standing beside the road or in front of the museum during the night and strange sounds can sometimes be heard while driving down the street in front of the museum late in the evenings. The ghost girl is said to be that of a little Indian girl that was killed from a head injury. Her skeleton was on display in a glass case for many years.","there have been many strange and unusual happening in the building, mostly at night when a lonely deputy is on duty making copies in the office or just simply sitting down and having a cup of coffee, Report seeing people out of the corner of their eye when the building is empty. He shook it off again and went back to his reports when suddenly he turned around and there standing in front of him was an old man wearing a blue bathrobe and blue slippers. He said the old man just looked up at him and turned around and walked out.. The deputy, not realizing what had just happened, followed the man out the door, but when he reached the hallway, there was no one to be found! Another unexplained happening happened around the same time when the Emergency Management Director was sitting in his office early in the morning and was drinking a cup of coffee when suddenly someone slapped the back of his chair and sent him flying up on top of his desk! When he turned around to investigate, he realized that no one was in the room with him, let alone, no one was even in the building at the time of the event!","Update: also known as Devil's Castle - Has since burned down - Reports of footsteps that break into a run, then screams, on the first floor. On the third floor feelings of being pushed accompanied by loud clattering in the hall and items moving, and apparitions. Singing has been heard- Formerly listed as Taylors - TB Asylum then a work release prison, & Travelers Rest - TB hospital/Insane Asylum.","Numerous incidents have been reported over the years at this small cemetery just outside Dawson Springs. Glowing eyes, ghosts of the dead, things appearing and disappearing.","There is the confederate park is across the street it is a state park and has many graves of confederate and union soldiers and you may check it out because it is rumored to be haunted as well.","Most of the times when students are walking alone they feel the presence of some one following them, but only on the third floor. Many students have said they have seen a young girl running down the halls.","This corporate office is haunted by the spirit of women who was brutally murdered by her husband in the purchasing department. Officer Dolinski who is a security officer has spotted her ghost on numerous occasions and is said that people have instantly soiled themselves.","The place is a big Japanese garden and at night you can supposedly hear ghosts whispering at night. Strange howls of winds could also be heard as you go down the path nearing the house.","The fourth floor of the south wing is said to be haunted. When members of the messenger staff have been up their completely alone doors have opened by themselves and strange footsteps have been heard.","several reports of screams and cries being heard from the old bridge. There have been reports of cars seen hanging off of the bridge and then suddenly vanishing. Also, reports of as an old black car that suddenly appears behind your car as you are driving, quickly pulls up close to you, as if it is going to ram you, and then suddenly disappears.","Sacred Heart Academy - There is a statue of Mary with her hands raised in the air.. (You can see it as you drive by, its in the front yard.) The urban legend goes that there were 2 young boys playing by the statue. They were supposed to come home when the streetlights come on but never did. The parents started looking for them and found a bloody message on the base of this statue that said \"Don't let your kids play after dark\". With the fingers of the statue cut off and blood coming out. If you go there today you'll see the fingers cut off and the eyes gouged out.- August 2005 Update: This is believed to be a hoax. a visitor to our site reports the hands of the statue are intact.","Strange presence felt & EVPs recorded.","Formerly posted as \"Old Town Cemetery\" - This was partially paved over with a road. It is said ghosts appear to be crossing that section of the road at night. - February 2004 Correction: The proper name of the \"Old Town Cemetery\" in San Diego is \"El Campo Santo Cemetery.\" Among the numerous other spirits sighted at the location (including the paved portions under the adjacent sidewalk and streets), psychics claim that the site is to this day overseen by the spirit of the gravedigger whose own grave is near the cemetery's SE corner.","Unknown spirits haunt this building. This is mainly on the top floor of it.","The church has a large and fairly old cemetery (est. in the 1850's) on its grounds, these grounds are said to house a very unfriendly spirit. The spirit is said to have a dog like head, lion sized body with the coarse mane like hair, and deep red eyes. I have been told of two incidents when it was sighted and chased people out of the cemetery. On one occasion as the people cleared the fence to get away it hit the fence so hard that it shook, but it did not pursue them after they had left.","Several problems were encountered while building the airport. This is reportedly due to the fact that the airport was built on top of sacred Native American ground. Some employees and visitors have reported hearing or seeing strange things.","Allaire Village - Located in the middle of the park on Allaire Road. It is an old iron fence from the 1900\u2019s. Reports of an apparition of a woman in white has been spotted between the park and the General Store.","There are little people that live around the mountain and it is said that if you go up there and disturb the grave they chase you.","Theta Chi Fraternity House - The house is a old mansion in the historical district of Pontiac. It had a fire that occurred in the attic when the original owners had it(somewhere in the late 1800's early 1900's). Some people died in the fire. The attic was converted into living space for the fraternity. Brothers living in the attic have reported waking up in the middle of the night to see figures standing in there (locked) room, staring with red eyes. The figures would basically just stare with a angered look in there eyes and vanish. Brothers would also hear footsteps around the attic area(hall & stairs)when no one is present. Some have woke up with one of the ghosts face just a foot away from their own face.","It is said that before it was a boys juvenile detention center it was a mental health institution for women! Once a women tried to escape though the air vents but got stuck and was found dead. Now you can hear clanging on the vents and a faint call of the women\u2019s name!","The 4th, 5th, and 6th grade doors open. Things get thrown by invisible hands and reports of red glowing eyes in the basement.","Alpha Theta - Likely due to the untimely deaths of fraternity brothers and their unidentified female \"companions\" due to a boiler explosion and fire in the house many decades ago, specters have been seen and the presence of spirits detected in various parts of the house. Hot spots are primarily in and around the remaining original structure - the house basement.","Supposedly Mary Telfair also haunts this former ladies hospital. Says she roams the halls in a brown dress.","If you go there to take a look at the tombstones you will see a lady in a black dress. She is up on top of the hill by the headstones. If you see her she will look at you then you will turn away and then turn back around and she will be gone!!!","The San Gabriel Civic Auditorium s past is very long and there are many stories of hauntings. Back was being built underground tunnels were built under the length of the building. They were built so that the owner (nicknamed Uncle John) could go from backstage to the foyer. When Uncle John died the tunnels went unused for years and when the depression came those tunnels were used as catacombs to house dead bodies. Once they were filled the catacombs were sealed. In the men s restroom in the front there is a door. When you open that door there is just a brick wall. When a crew tried to breach the wall they got five feet and there was still brick. Why would some one seal a tunnel in more than five feet of brick? No one will ever know unless the try to breach it again. Now to the stories. There is a drop that was preserved because it was the only remaining drop from the original stage. Some times during the Temple City High School musical that drop swings unintentionally. There is no wind and no one ever touched that drop. A psychic was brought in and they said they saw a man swing on the drop. Another story is that there are TV monitors on stage left that broadcast what is being shown on stage. In 2003 and there during the Music Man there was a person seen in the second story window on one of the houses. Many stage crew, tech crew, and actors saw this man on the TV monitor. Also many of the audience saw this man too. The problem with this is that there is no way for a man to be standing in the second story window because there is no ledge or anything for him to stand on. The man was later recognized as Uncle John. There are also stories of a little girl who roams the halls and a old stage manager who roams the halls at night.","In the little shop on the corner of Wyoming and Green Streets, next to I believe Cousins Bar, there is said to have been various sightings of people walking through the storefront, in the kitchen, and in the basement. There was supposedly a mass murder in the building back in the late 1930's. While nobody has actually physically encountered any of them, they are said to be very temperamental and violent.","Supposedly a cheerleader was killed under the gym stage after a game by a football player. She now haunts down there near the furnace.","The theatre at Pekin High School is haunted by Sid, who used to be a stage manager. He would sit upon the catwalks and do the lights. He died of a heart attack in the dressing room.","Drexel Hall Drexel Hall is now restricted and on the list of Indiana's most Endangered Landmarks. Though the rest of the building is in ruins, the chapel is in perfect condition according to my sources. Also, people who enter begin hearing voices in their heads.","Joe supposedly haunts the theatre! He was one of the best actors there one night when he was coming out of the building he was pulled be hind an alley and was murdered! He has haunted the theatre ever since.","An orphanage burned down in the early part of the century and as the story goes, all the children died. If you drive down this road \"if the conditions are right\" you can hear the children crying. Many have claimed to hear the children crying. People have also claimed that there have been banging on their cars and after fleeing quickly causing them to flee in a panic from the area. Once home, if their cars were not clean at the time of the visit, they would find small hand prints on the dust of their cars.","Poole Hospital - Feelings of being watched, and anomalies have shown up on film.","Fine Arts Building -  The Fine Arts building was originally a Catholic Hospital. Some say they have heard babies crying where the nursery was, footsteps heard in the hall when no one was there and art students have witnessed pottery wheels beginning to spin by independently. There are also numerous cold spots through out the building.","seen lights disappear and then light bulb falls. next morning the lights are there again","A number of ghosts have been reported to be seen there by patrons, actors and owners. Ghosts turn off lights and follow the people that lock up the opera house. They have been seen in 1920s-30s clothing.","The school is about to be torn down however years ago a lady was said to have jumped out of one of the upper level windows and killed herself on the ground below.\u00a0 Also if you walk next to the large windows on the side of the building you are supposed to be able to see a little girl in a while night gown hanging in the window.\u00a0 Many people go there at night and claim to see and hear strange things.","2003 - The manager was sitting in a chair behind the bar one day before opening. The bar was empty; He was watching TV for maybe an hour and a half in that one spot when he heard a knock at the door he got up to see who was there. Before he got to the door a large iron industrial fan directly above his chair fell from the ceiling crushing his chair. No one was at the door or anywhere near the bar when he checked.","Traffic noise is a factor but how do you explain sounds of children playing and laughing at two in the morning. There is a section of the cemetery were score of children were buried after they died during a small pox epidemic. You can hear the hoof beats of Calvary soldiers, and just general conversation, but never really understanding the words just recognizing the human voices.","the old Washington high school building. a construction worker fell to his death in an elevator shaft while remodeling the building into the pavilion. footsteps are heard and a feeling of being watched.","Rebuilt after a fire killed occupants who were trapped on the top floor. It is said that the top floor is haunted by the spirits of those who died in the fire.","Many employees have had strange interactions with paranormal activities in both the projection room and the main halls. Shadows of human like figures and balls of floating light have been seen by friends and workes alike. Reason for haunting unknown.","You can hear knocking on doors at 3am, and no body is there, televisions, water faucets turn on by themselves, cold spots and a host of other things. You can feel it the minute you walk in the door! Weird things happened in all the rooms with a 6; like 116, 216.","Hells Gate is an older cemetery located in the heart of Spartanburg, South Carolina. Strange things like having a cell phone give a busy signal, when it was later confirmed that the line that was called was NOT busy. As well, we have seen many odd and unexplained lights within the woods of the graveyard. Trying to take pictures and the flash wouldn't work. Apparitions of children and a whitish mist.","In an old cemetery behind the main branch of the Mobile library, is an oak tree that grew out of the grave of a man named Boyington. He was a black man wrongly accused and executed. His last words were that an oak tree would grow from his grave to prove his innocence. Some say that they hear strange noises coming from around the tree.","Trumbull County Campus - A man who worked there as a custodian. At night they would hear all kind of knocks and tapping noises. After checking everything in the building several times to make sure nothing mechanically was responsible for the noise, they were baffled. We were told that a medium was called in, who in turn told them that the campus had been built on what was formerly the grounds of an old folks home. The campus is haunted by people who passed away there. The noises heard are tapping of canes and walkers.","Whittier Narrows Park - The figure of a Spanish conquistador on horseback can be seen occasionally around the intersection of San Gabriel Blvd and Lincoln Ave. It is said he drowned here looking for his gold buried near the river's beach. Mysterious fogs roll in and out here a lot as well.","The Don CeSar Resort was once the private residence of Thomas Rowe. He had studied in London during his youth and fell in love with a girl named Lucinda. Her parents sent her away however, so when Thomas returned home, he never saw her again. He built the castle to look like the one where they met. His ghost can be seen walking hand-in-hand with a beautiful dark-haired woman along the shore."],"top_values":[],"top_words":[["the",47628],["a",20093],["and",19071],["of",16173],["in",14916],["to",11351],["is",10937],["that",7462],["on",7320],["you",7114],["was",7018],["there",6167],["have",5341],["it",5321],["at",4860],["by",4172],["been",3900],["be",3664],["when",3333],["can",3321],["this",3305],["one",3304],["are",3120],["has",3092],["they",2918]],"vocab_skipped":null,"word_histogram":{"counts":[2857,3930,2129,989,480,252,129,82,52,33,14,18,9,6,2,2,3,1,0,1,0,1,0,0,0,0,1,0,0,1],"edges":[1.0,34.96666666666667,68.93333333333334,102.9,136.86666666666667,170.83333333333334,204.8,238.76666666666668,272.73333333333335,306.70000000000005,340.6666666666667,374.6333333333333,408.6,442.5666666666667,476.53333333333336,510.5,544.4666666666667,578.4333333333334,612.4000000000001,646.3666666666667,680.3333333333334,714.3000000000001,748.2666666666667,782.2333333333333,816.2,850.1666666666667,884.1333333333334,918.1,952.0666666666667,986.0333333333334,1020.0]}},"kind":"text","n":10992,"n_null":0,"n_unique":10987,"null_rate":0.0,"stats":{"allcaps_rate":0.0006368267831149927,"boilerplate_rate":0.00645924308588064,"duplicate_rate":0.0004548762736535662,"emoji_rate":0.0,"len_max":5280,"len_mean":380.03156841339154,"len_median":297.0,"len_min":2,"len_p95":954.0,"n_duplicates":5,"n_empty":0,"one_word_rate":0.0001819505094614265,"readability_flesch_mean":69.67237793212331,"url_rate":0.005094614264919942,"vocab_size":33001,"word_mean":70.33051310043668,"word_median":55.0}},{"alerts":[],"column":"location","extras":{"language_counts":{},"language_sample_size":5000,"length_histogram":{"counts":[9633,1280,57,7,0,0,0,2,2,0,2,0,0,1,0,1,0,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,1],"edges":[2.0,27.35,52.7,78.05000000000001,103.4,128.75,154.10000000000002,179.45000000000002,204.8,230.15,255.5,280.85,306.20000000000005,331.55,356.90000000000003,382.25,407.6,432.95000000000005,458.3,483.65000000000003,509.0,534.35,559.7,585.0500000000001,610.4000000000001,635.75,661.1,686.45,711.8000000000001,737.1500000000001,762.5,787.85,813.2,838.5500000000001,863.9000000000001,889.25,914.6,939.95,965.3000000000001,990.6500000000001,1016.0]},"near_unique":false,"sample":["Huron High School theatre.","Chickamauga Battle Fields","Fort Clinch","Memorial Middle School","The Historic Sheridan Inn","Old Tuberculosis Hospital","Olney Road","Confederate Park","Austin high school","Johnson Controls","Chateau Ste Michelle Winery Manor House","Evergreen Inn hotel","Middleton Tavern","Trowbridge Road","Point Lookout State Park","El Campo Santo Cemetery","Cathedral of Learning","Bethel Assembly of God Church","Denver International Airport","Freewood acres","Pizza Hut","Oakland University","Howland Detention Center","Oakmont Cemetery","Ocean-Born Mary House","Bay Springs Church/Cemetery","New York State Environmentally Preserved Land","Red Cross Mansion","Wyoming and Green Streets","Brewer Middle School","Bradley University Theatre","St. Joseph's College","St. Joseph's College","Maple Grove Cemetery","Mound Elementary School","Spurlington tunnel","Greenfield Hill","Guptills Woods on Pollock Road","Coal Spring","Port Chester High School -Tower","Concordia Cemetery","Black Hills State University","Ott YMCA","Rushmore 9 movie theater","Ascension Place","Hell's Gates","Mobile Christian School","Kent State University","Montebello Parks and Recreation Office","The Don CeSar Beach Resort and Spa"],"top_values":[["Prince Georges county",18],["Cemetery",13],["Cry Baby Bridge",13],["Wal-Mart",12],["Mission Inn",12],["Oviedo",12],["Gravity Hill",11],["Fordham University",11],["University of Vermont",11],["Wentworth Military Academy",11],["Hazard",10],["Main Street",9],["Western Kentucky University",9],["University of Wisconsin",9],["Riverside Cemetery",8],["Michigan State University",8],["Carlisle Barracks",8],["Holiday Inn",8],["Evergreen Cemetery",8],["Salem",8]],"top_words":[["school",1197],["the",960],["cemetery",737],["high",697],["old",584],["university",497],["house",494],["road",415],["of",399],["college",371],["park",342],["state",306],["inn",273],["hotel",265],["bridge",244],["st.",228],["and",223],["hospital",211],["middle",202],["hill",202],["elementary",193],["church",183],["center",167],["county",159],["mansion",148]],"vocab_skipped":null,"word_histogram":{"counts":[10862,113,2,0,1,3,1,1,1,0,1,1,1,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1],"edges":[1.0,7.766666666666667,14.533333333333333,21.3,28.066666666666666,34.833333333333336,41.6,48.36666666666667,55.13333333333333,61.9,68.66666666666667,75.43333333333334,82.2,88.96666666666667,95.73333333333333,102.5,109.26666666666667,116.03333333333333,122.8,129.56666666666666,136.33333333333334,143.1,149.86666666666667,156.63333333333333,163.4,170.16666666666666,176.93333333333334,183.7,190.46666666666667,197.23333333333332,204.0]}},"kind":"text","n":10992,"n_null":3,"n_unique":9903,"null_rate":0.0002729257641921397,"stats":{"allcaps_rate":0.003367003367003367,"boilerplate_rate":0.0,"duplicate_rate":0.09882609882609883,"emoji_rate":0.0,"len_max":1016,"len_mean":19.2985712985713,"len_median":17.0,"len_min":2,"len_p95":34.0,"n_duplicates":1086,"n_empty":0,"one_word_rate":0.06333606333606334,"readability_flesch_mean":45.79444423076926,"url_rate":0.0,"vocab_size":8232,"word_mean":2.9756119756119754,"word_median":3.0}},{"alerts":[],"column":"state","extras":{"singletons":0,"top_values":[["California",1070],["Texas",696],["Pennsylvania",649],["Michigan",529],["Ohio",477],["New York",459],["Illinois",395],["Kentucky",370],["Indiana",351],["Massachusetts",342],["Florida",328],["Missouri",314],["Georgia",289],["Wisconsin",274],["Alabama",224],["Tennessee",221],["Washington",218],["Oklahoma",211],["North Carolina",211],["New Jersey",194]]},"kind":"categorical","n":10992,"n_null":0,"n_unique":51,"null_rate":0.0,"stats":{"cardinality":51,"entropy":5.1940393132746046,"entropy_ratio":0.9156646408094242,"top_rate":0.09734352256186317,"top_value":"California"}},{"alerts":[],"column":"state_abbrev","extras":{"singletons":0,"top_values":[["CA",1070],["TX",696],["PA",649],["MI",529],["OH",477],["NY",459],["IL",395],["KY",370],["IN",351],["MA",342],["FL",328],["MO",314],["GA",289],["WI",274],["AL",224],["TN",221],["WA",218],["OK",211],["NC",211],["NJ",194]]},"kind":"categorical","n":10992,"n_null":0,"n_unique":51,"null_rate":0.0,"stats":{"cardinality":51,"entropy":5.1940393132746046,"entropy_ratio":0.9156646408094242,"top_rate":0.09734352256186317,"top_value":"CA"}},{"alerts":[],"column":"longitude","extras":{"histogram":{"counts":[86,22,10,3,65,1371,436,590,1570,2857,2086,625,0,0,0,0,0,0,0,2,0,0,0,0,1,0,0,0,1,3,0,0,0,0,0,0,2,0,0,1],"edges":[-164.7224104,-156.3869184275,-148.051426455,-139.71593448250002,-131.38044251,-123.0449505375,-114.709458565,-106.37396659250001,-98.03847462,-89.70298264750001,-81.367490675,-73.0319987025,-64.69650673000001,-56.3610147575,-48.02552278500001,-39.6900308125,-31.354538840000004,-23.01904686750001,-14.683554895000015,-6.348062922499992,1.987429050000003,10.322921022499997,18.658412994999992,26.993904967499986,35.32939693999998,43.664888912500004,52.000380885,60.33587285749999,68.67136482999999,77.00685680249998,85.342348775,93.6778407475,102.01333272,110.34882469249999,118.68431666499998,127.01980863749998,135.35530060999997,143.69079258249997,152.02628455500002,160.3617765275,168.6972685]},"sample":[-83.1334217,-82.9564118,-82.56376,-83.06718099999999,-83.693569,-85.5126927,-82.8737597,-83.3058286,-84.39181049999999,-84.28919739999999,-85.6282605,-84.61739779999999,-84.72776549999999,-84.7756364,-83.492317,-89.2284689,-85.5101383,-85.4652751,-82.99369569999999,-85.6212858,-89.6301273,-82.9774671,-77.25531749999999,-76.9591384,-77.3603565,-77.230648,-80.0772199,-76.00197059999999,-77.07042799999999,-79.8496073,-75.88946659999999,-75.9254567,-80.3773478,-80.332286,-77.1562971,-74.8346155,-75.25352819999999,-79.7711625,-79.9268431,-80.01612329999999,-79.90143859999999,-79.985372,-75.910629,-81.575688,-76.2321625,-75.3289496,-75.300893,-75.34358,-122.034156,-118.0889289,-79.14625869999999,-79.7504448,-118.7456568,-121.2845862,-76.6629631,-122.1781527,-73.02015209999999,-71.4914166,-70.8408093,-70.8408093,-119.2981918,-117.3072375,-119.2521246,-71.0765188,-71.10666599999999,-71.02803399999999,-70.9543082,-73.035376,-71.9807958,-70.8720282,-71.6718776,-71.3367669,-71.015349,-71.17140169999999,-70.91763949999999,-70.944278,-70.6675278,-118.4464977,-118.130215,-73.077362,-117.2192837,-72.00718540000001,-122.1878385,-122.1831186,-117.598057,-117.9257189,-118.1109877,-121.8840108,-121.876703,-118.9747667,-117.1815252,-118.3840853,-117.3931011,-117.3280644,-121.6581657,-117.321839,-117.1623501,-122.4084188,-120.6545022,-91.5783934,-92.4172044,-92.2645458,-92.3326179,-122.777723,-92.2109887,-117.913497,-118.2522977,-118.028908,-117.844996,-121.639989,-118.6055177,-120.2622418,-121.8558919,-122.0362485,-118.1632554,-115.5351676,-117.2881241,-118.4904271,-116.2391738,-118.833105,-117.719212,-121.3301885,-118.1903235,-118.2639248,-118.383123,-118.2110747,-121.9830349,-112.1482843,-112.1696443,-112.1145004,-111.905583,-111.9280527,-110.066648,-110.9553994,-110.943344,-76.6084632,-76.3521212,-76.7200591,-75.8373728,-76.797033,-76.8338085,-77.7302402,-76.38743079999999,-77.05525550000002,-76.8690043,-76.3374474,-97.6510812,-97.2698985,-96.3792838,-96.3792838,-97.4190849,-97.55407439999999,-95.14795149999999,-94.998096,-95.89674339999999,-66.6667528,-98.88433099999999,-96.136614,-99.40002919999999,-68.32170839999999,-70.910856,-70.65298059999999,-92.35455499999999,-90.708011,-90.060878,-90.8028602,-86.9736056,-83.6696327,-86.9833325,-86.8211096,-87.23121549999999,-85.71650629999999,-87.04999920000002,-82.10138889999999,-82.68268169999999,-80.6063211,-83.79613599999999,-84.4971906,-84.6198254,-80.613689,-84.77877699999999,-81.3612097,-81.412345,-84.187114,-84.00839719999999,-83.8139029,-74.1321361,-75.0795121,-74.7894047,-74.9188339,-74.9215308,-74.30942859999999,-87.6530082,-75.3721532,-74.2330759,-103.3211637,-96.8024367,-97.0768014,-108.4792374,-85.853202,-104.814518,-110.9481806,-109.464512,-108.7623575,-108.9413738,-106.9651652,-108.2139945,-76.67866939999999,-80.2943919,-84.2932355,-86.3506465,-86.456138,-86.456138,-80.8421901,-83.18437809999999,-80.571494,-76.4036278,-86.1730453,-80.1338196,-81.1106324,-80.343718,-80.61489499999999,-83.61904249999999,-85.8516779,-83.2982825,-81.69119239999999,-82.7303821,-76.0333885,-83.71921619999999,-84.4936508,-84.0654143,-85.5577636,-80.2450923,-85.78432629999999,-88.4535578,-83.1935112,-87.1834378,-84.2381509,-85.7160207,-95.11677689999999,-95.6144971,-95.23334039999999,-95.23334039999999,-95.45386529999999,-95.2557961,-97.2450636,-98.0932445,-97.37404199999999,-97.29286929999999,-74.849251,-78.5091894,-79.0457857,-75.7559138,-78.62154319999999,-73.7095633,-73.583349,-74.3209921,-73.71103,-74.74488699999999,-89.07208899999999,-73.68662239999999,-90.4099336,-88.4885272,-73.5316101,-87.9334118,-91.1105753,-87.7738952,-89.2879241,-77.6305552,-77.51217659999999,-76.1097018,-89.7014685,-72.8602794,-72.88620159999999,-74.25325099999999,-87.8024739,-75.7213921,-76.09842499999999,-73.85085269999999,-88.85561899999999,-87.70371709999999,-87.86327159999999,-90.5777854,-91.5548998,-94.746072,-96.374569,-94.97330749999999,-82.43686249999999,-80.0542344,-80.5655424,-106.602869,-122.202126,-124.0539384,-122.2218295,-122.34614,-117.3352443,-122.4108725,-122.46242,-122.5190526,-122.26628,-89.98268270000001,-89.9793239,-88.8378535,-85.652108,-86.4136985,-86.5050739,-87.4954927,-89.286217,-87.5124349,-87.29293899999999,-91.43459779999999,-90.06347319999999,-88.0967798,-88.0967798,-87.12973439999999,-86.9189835,-90.684401,-89.2092522,-80.6566667,-90.03010080000001,-88.4813471,-89.5996861,-90.3316329,-91.39632089999999,-85.0237727,-89.01874480000001,-88.03293529999999,-85.6669589,-86.84888839999999,-90.66704,-88.2695514,-89.49754589999999,-88.16246989999999,-85.37893900000002,-79.345959,-80.42561239999999,-76.313107,-77.40305699999999,-79.43946,-78.30398799999999,-79.9408098,-76.7020651,-117.4106403,-71.3793768,-71.44533799999999,-71.5516035,-71.252248,-73.2041352,-73.1802563,-117.2307642,-119.6501592,-158.0812864,-157.8587575,-157.8271717,-157.7762165,-157.9246794,-112.0155015,-111.9249559,-111.9826984,-109.9765752,-111.6407335,-96.610044,-97.31709099999999,-98.3732874,-99.09586159999999,-97.75331039999999,-96.19200889999999,-97.3877127,-101.7257041,-97.01451039999999,-84.1107593,-83.3722585,-84.1054937,-85.1389502,-84.7096565,-83.9848512,-84.9685619,-83.468475,-104.6141549,-83.6497765,-84.5508718,-94.807822,-81.088381,-81.0940516,-81.38704159999999,-84.7144127,-84.55053079999999,-83.705761,-83.7118393,-84.4441645,-103.8828184,-95.46126249999999,-102.382456,-95.1669436,-101.3781941,-97.938351,-113.3386399,-104.9326905,-95.28338409999999,-105.2034182,-97.98674729999999,-101.8274338,-97.055612,-97.8246769,-97.85133239999999,-97.7511169,-99.96213329999999,-97.4159457,-97.377318,-96.86458560000001,-106.3905349,-100.088818,-97.36158999999999,-97.0037022,-97.7308918,-102.16275,-98.32529319999999,-95.1742381,-94.3448478,-99.483037,-99.48812199999999,-99.4654905,-82.21325,-82.48602389999999,-83.9170961,-84.34437179999999,-82.6924095,-80.3943067,-80.1161948,-81.4766339,-81.675186,-81.22468870000002,-87.21292,-80.4086663,-80.4086663,-82.68744099999999,-81.3136018,-81.2879213,-81.2370682,-82.6332676,-82.4671717,-90.3884717,-94.37911740000001,-92.43851629999999,-94.35824699999999,-93.2834227,-75.5713887,-101.4298232,-101.4301874,-102.5697005,-102.5697005,-102.4602444,-88.8896922,-88.61081890000001,-89.4382607,-90.1853161,-89.1246917,-90.872034,-73.088205,-71.9240173,-72.9738996,-73.0979851,-72.7509998,-72.5479603,-72.1122491,-72.9532372,-72.6519885,-92.95825119999999,-92.83453329999999,-96.74287629999999,-96.3174635,-92.4655574,-93.97583610000001,-91.67134899999999,-91.6195128,-81.79476369999999,-81.90024770000001,-82.5362603,-81.63573749999999,-79.0278096,-81.88116280000001,-82.23897540000002,-81.1046808,-81.0862882,-71.5440603,-105.4891877,-105.27186,-105.2463001,-104.8263258,-104.8578665,-104.7377414,-104.901069,-107.546421,-105.5191728,-105.0727134,-104.9321084,-105.0740923,-104.9174742,-108.4646697,-106.078811]},"kind":"numeric","n":10992,"n_null":1261,"n_unique":8774,"null_rate":0.11471979621542941,"stats":{"iqr":18.8156386,"kurtosis":15.19649095792974,"max":168.6972685,"mean":-91.99665523689241,"median":-87.23121549999999,"min":-164.7224104,"n_outliers":131,"outlier_rate":0.013462131332853766,"q1":-99.11940285,"q3":-80.30376425,"skew":0.25116204768400363,"std":17.686038010967568,"zero_rate":0.0}},{"alerts":[],"column":"latitude","extras":{"histogram":{"counts":[1,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,91,5,176,509,672,1609,1506,2549,1854,561,164,2,2,0,14,4,10],"edges":[-45.023726,-42.225818135000004,-39.427910270000005,-36.630002405,-33.83209454,-31.034186675,-28.23627881,-25.438370945,-22.64046308,-19.842555215,-17.044647349999998,-14.246739484999999,-11.44883162,-8.650923755,-5.853015889999995,-3.0551080249999956,-0.25720015999999646,2.5407077050000026,5.338615570000002,8.136523435000008,10.934431300000007,13.732339165000006,16.530247030000005,19.328154895000004,22.126062760000003,24.923970625000003,27.72187849,30.519786355000015,33.317694220000014,36.11560208500001,38.91350995000001,41.71141781500001,44.50932568000001,47.30723354500001,50.10514141000001,52.90304927500001,55.70095714000001,58.498865005000006,61.29677287000002,64.09468073500003,66.89258860000001]},"sample":[43.5727986,42.5811627,43.0362674,42.35975200000001,43.012403,42.9123467,42.4538245,42.2939689,42.2002519,42.1597064,42.2774003,45.8520988,45.817377,43.5819086,42.463106,46.3809283,43.8754929,43.0747964,42.6022293,44.759237,44.9591381,42.5293794,40.1330055,41.1360368,39.8847576,39.823306,41.1528693,40.0875236,41.8047541,40.3514348,40.1551479,40.3929657,40.9941408,41.119859,40.3160088,40.1883697,40.0092302,40.4028149,40.3984534,40.4497346,40.4781325,40.436085,40.3615027,35.356312,40.8600874,40.0340798,41.031844,40.037056,37.257479,33.7496524,41.8468001,40.3496579,34.2546424,37.9640038,39.9862469,38.1558144,42.2511401,42.1474595,42.5531918,42.5531918,34.2811033,34.5222587,36.3431198,41.9955015,42.366823,42.39832699999999,42.0293245,42.173468,42.5575588,42.0468724,42.4622692,42.624336,42.512464,42.733118,42.53986039999999,42.5407812,41.9601204,33.9907869,34.017378,42.0940051,33.5528599,42.2549067,37.78268449999999,37.8134565,34.0559781,33.6943229,34.550057,38.0192148,37.658414,36.0727852,34.054253,33.8471175,33.9839038,33.9737055,36.6670504,34.176752,32.7670907,37.7932786,35.6368759,35.3164775,34.753683,34.7427959,34.8411977,45.49342799999999,34.5293443,33.811479,34.7513712,34.1362469,33.98419,40.9466222,34.1954222,37.1229841,37.8743912,37.97620209999999,33.9236865,32.767604,33.411803,34.1312659,33.7133553,35.2017986,33.624022,38.9037726,33.7526356,34.0454836,33.948858,34.038338,37.2223894,33.8675098,33.6529974,34.7489484,33.52667,33.4242399,31.7123203,32.2312392,32.209736,39.3070162,39.5225645,39.2857251,39.6186506,39.2708634,38.9904775,39.6398143,39.4597018,39.0398314,39.3354503,38.0609713,35.1595456,35.4949388,34.0058724,34.0058724,35.8858756,35.4525753,36.3016074,35.9101331,36.1634272,48.01092180000001,36.57865719999999,35.3387819,36.4377816,47.35531779999999,42.535836,43.1443535,31.034294,29.633821,29.960991,29.7907423,33.5587173,37.4738789,33.8162147,33.6041499,33.8147845,33.3583702,33.7556606,39.324358,41.4826819,40.6763746,40.0578067,39.1138109,39.1440636,40.726653,40.412803,41.7128807,39.406654,39.1313473,39.9798777,39.9365496,40.6598189,39.8645716,39.9968603,38.9364011,38.9330131,40.4173639,41.9219162,39.5155637,40.9156697,46.4826789,46.8977528,47.922891,42.9720248,39.936619,41.133345,41.2637952,41.529796,44.7614863,44.6703925,44.78668880000001,43.6465675,34.69714039999999,36.0843344,37.5695232,37.1355456,36.9853543,36.9853543,35.2268495,35.3089224,35.2942139,35.7891485,37.9939031,36.40674,35.3062487,35.5129693,35.546499,37.8777447,37.0551418,36.8086043,35.7296832,37.3890219,35.0861054,35.40835870000001,38.053147,37.1378615,38.2718652,35.58301429999999,38.2704843,36.6820863,38.3764688,37.7952399,38.2211289,37.98803729999999,39.5616302,37.0199234,38.9377658,38.9377658,38.9715686,38.9543439,37.4881777,38.1583957,37.88310600000001,37.7193933,43.8315505,42.1264537,42.6206545,43.3462305,43.0580614,42.7889667,43.2645887,41.4024891,43.420112,43.00725,42.5190863,42.9034173,45.8815531,43.792697,40.8724113,42.5530753,45.4799347,44.2862983,42.9749029,43.2133267,43.1930922,43.9500646,45.179757,40.8036284,40.8090335,40.5031274,43.625896,43.16336,43.045967,41.0778722,44.2592636,43.7500724,42.8874927,41.5238852,41.6626963,42.26365759999999,42.538529,40.93072189999999,38.4195346,38.4987251,39.2837675,35.107248,47.719455,46.3924658,48.3814552,47.61231,47.8264592,47.2507286,47.184464,47.1740135,47.513156,38.5139415,38.512382,42.17532569999999,40.061537,39.75784489999999,39.1599803,37.9845278,37.733613,41.5732765,39.1299011,40.35921099999999,40.2997909,41.7783779,41.7783779,39.04092,38.6760782,40.476174,41.17697990000001,35.1151302,38.9917978,41.3607192,40.707109,41.6066363,39.9102906,40.4297071,42.26889329999999,42.0818356,39.45345570000001,38.6142182,40.42953989999999,39.98398220000001,40.52529690000001,40.1447615,40.6376561,37.7415843,37.1221918,37.001097,38.464625,37.788981,39.020682,37.268654,37.2740582,47.724674,43.5836576,42.9769496,44.2735664,42.819547,44.4731165,43.6077824,38.0683209,39.3110159,21.3209005,21.3026125,21.3417501,21.2705629,21.6498732,41.5102129,40.3881191,41.10968,40.3008324,40.2673136,41.3956342,41.4412492,40.5904193,40.7024732,41.3938949,41.0210248,42.0571646,41.1323187,42.2426999,31.6010788,33.9544387,33.0249361,33.7176884,34.6619837,34.5326709,34.7713817,32.282145,38.2642199,32.8288194,33.9526112,29.284711,32.07715,32.0729232,31.1882866,32.6894422,34.3209328,34.6853046,34.6896868,34.1530612,30.2751212,30.1658207,31.8514043,29.6598536,33.1909283,29.888411,46.8253719,46.884709,32.3337516,48.1125628,26.154729,35.1700342,32.7196554,30.228824,30.2243097,30.277075,31.7495262,25.9395138,27.6539313,32.7362591,31.8994213,31.400975,32.720224,32.7605037,26.2523089,32.0009378,26.2159066,29.8111886,32.7559692,27.506117,27.50979,27.6260407,36.4400229,36.582607,35.9623478,36.0445222,27.4513185,26.0681177,26.0123056,28.333475,28.597584,28.6083129,30.40976,27.280132,27.280132,27.990771,29.8978461,29.8850046,28.3201992,27.7559836,27.9474881,38.2162607,37.6306,37.740128,37.839479,37.1895864,39.7511665,45.3961846,45.3979224,43.0214745,43.0214745,43.0474282,30.3956483,30.3818123,31.2616859,32.3007314,31.6986204,32.346023,41.343417,41.8000437,41.7836824,41.3336597,41.6425139,41.7656928,41.4035625,41.2766033,41.7133645,44.8208615,45.0377549,46.8720698,44.0000651,44.0233848,44.3069335,47.0255217,44.0426092,33.568624,34.4603966,34.8965739,34.5571389,33.5756116,34.9091673,34.3935042,33.9514618,34.3798897,41.6942695,39.8000053,40.0128877,39.9724871,38.8334866,38.8736725,38.8078763,38.880064,40.5218,40.383371,40.5392914,39.4879376,39.6038601,38.8597025,37.1615626,38.5187744]},"kind":"numeric","n":10992,"n_null":1261,"n_unique":8775,"null_rate":0.11471979621542941,"stats":{"iqr":7.197369700000003,"kurtosis":11.383519380042223,"max":66.89258860000001,"mean":38.34279026190525,"median":39.2795837,"min":-45.023726,"n_outliers":124,"outlier_rate":0.012742780803617305,"q1":34.676030499999996,"q3":41.8734002,"skew":-0.9709551319813767,"std":5.259289329662046,"zero_rate":0.0}},{"alerts":[],"column":"city_longitude","extras":{"histogram":{"counts":[2,0,83,14,0,3,13,5,4,0,0,0,2,2,0,0,33,529,249,661,83,245,92,96,260,93,159,530,545,492,447,792,877,1252,912,420,825,649,548,46],"edges":[-164.7238888,-162.30179737,-159.87970594,-157.45761450999998,-155.03552308,-152.61343165,-150.19134022,-147.76924879,-145.34715735999998,-142.92506593,-140.5029745,-138.08088307,-135.65879164,-133.23670020999998,-130.81460878000001,-128.39251735,-125.97042592,-123.54833449,-121.12624306,-118.70415163,-116.28206019999999,-113.85996877,-111.43787734,-109.01578591,-106.59369448,-104.17160304999999,-101.74951161999999,-99.32742019,-96.90532876,-94.48323733,-92.0611459,-89.63905446999999,-87.21696304,-84.79487161,-82.37278017999999,-79.95068875,-77.52859731999999,-75.10650589,-72.68441446,-70.26232302999999,-67.8402316]},"sample":[-83.17466929999999,-83.4192941,-85.00052149999999,-83.0457538,-83.2918744,-85.6680863,-85.6680863,-83.7507315,-84.40134619999999,-84.40134619999999,-88.89402830000002,-85.3731257,-85.513329,-84.6189339,-85.50955859999999,-86.2541768,-85.6489035,-84.41726659999999,-83.1499322,-85.71003929999999,-83.1497751,-83.4468828,-83.0335384,-79.78747539999999,-76.4519078,-75.20411639999999,-77.2310955,-79.8403931,-77.4469263,-80.15144839999999,-76.7310806,-75.8771388,-76.1590963,-75.7271318,-75.1652215,-75.1652215,-79.9958864,-79.9958864,-79.9958864,-79.9958864,-79.9958864,-79.86977069999999,-75.9268747,-75.32295409999999,-76.171054,-75.5476876,-75.3266416,-76.02758589999999,-122.0307963,-122.0307963,-122.0307963,-119.0592705,-78.145012,-76.727745,-118.1503488,-118.4489739,-118.8375937,-121.4252227,-118.5713823,-122.2566367,-117.8653386,-71.0588801,-71.0508911,-118.6439809,-118.6439809,-118.032844,-117.8132571,-70.90364869999999,-71.5745152,-71.0772796,-70.889759,-73.2848762,-73.2848762,-71.30645969999999,-71.5163049,-70.6672621,-121.2160526,-121.2160526,-118.1137535,-117.2296717,-71.4161725,-118.4849365,-118.081733,-122.2711137,-122.2711137,-117.8311428,-118.1164613,-118.3870173,-71.1369959,-120.6545022,-118.3870173,-117.3703235,-117.6708966,-117.3961564,-117.3961564,-117.3961564,-122.4194155,-122.4194155,-92.586828,-93.46657309999999,-92.1101458,-93.239334,-121.3153096,-90.4973286,-90.1906542,-123.0867536,-118.1270146,-118.0353449,-117.9002918,-116.8653421,-117.2730931,-120.2601754,-122.6263728,-121.7405167,-117.9189742,-118.1669736,-121.2721718,-123.8052935,-121.9885719,-117.9379952,-118.3539932,-120.9503435,-120.4579409,-118.2436849,-118.2436849,-118.2436849,-109.9284084,-114.3835698,-112.0740373,-110.2142399,-110.926479,-110.926479,-112.7301882,-114.6276916,-76.4921829,-76.50273949999999,-76.6121893,-76.6121893,-76.7983067,-76.87552819999999,-76.87552819999999,-76.7002462,-76.82942129999999,-76.36189259999999,-77.404384,-97.96392399999999,-96.21860919999999,-99.5723366,-98.39592909999999,-97.2469799,-95.3696909,-97.394753,-97.5164276,-95.9515399,-97.0583681,-95.99277500000001,-95.99277500000001,-98.7075744,-70.45338439999999,-70.1031201,-147.7163888,-93.2890527,-93.08627489999999,-90.0715323,-90.0715323,-90.0715323,-85.8316318,-86.9736056,-87.677251,-85.76135359999999,-86.3376761,-86.61218610000002,-80.8765205,-82.9824019,-84.5120196,-84.5120196,-81.6943605,-82.0881995,-82.0881995,-84.1916069,-84.1768795,-82.51960369999999,-81.3578859,-84.1052256,-81.45484359999999,-80.5575706,-81.0202533,-83.55521200000001,-74.90600529999999,-74.61849,-74.2295891,-75.0393438,-74.4815438,-74.4815438,-74.6829363,-74.790718,-74.26316349999999,-74.26316349999999,-74.5818254,-77.0368707,-100.6301271,-103.5243536,-108.7726205,-105.5911007,-104.6280156,-82.5514869,-86.4808043,-80.8431267,-86.1694143,-83.21253519999999,-84.0968761,-78.6089028,-78.87835849999999,-79.7919754,-85.8649408,-77.4302414,-81.34119419999999,-77.5816353,-84.87328350000001,-83.321848,-83.321848,-80.5495112,-87.4886186,-83.38351349999999,-80.4358963,-77.2210654,-78.6381787,-79.6644747,-78.9711406,-80.23213129999999,-80.9284083,-80.0767266,-85.7584557,-83.4326841,-87.14228949999999,-82.8071054,-83.2077645,-83.2077645,-84.9516234,-85.9491298,-86.1905424,-86.49965460000001,-84.17965029999999,-99.3267702,-97.92977429999999,-94.6557914,-94.70496,-94.6335684,-73.7562317,-78.4941887,-79.0278156,-73.5537257,-75.27123929999999,-78.8783689,-73.76312519999999,-76.4331698,-74.49651,-79.15810189999999,-76.4171585,-76.985557,-72.3592501,-73.13496099999999,-88.41538469999999,-88.16287849999999,-75.48633640000001,-73.7948516,-87.657584,-87.657584,-76.1190929,-87.9064736,-74.1502007,-89.4923422,-89.46262019999999,-87.8606367,-73.69178509999999,-75.232664,-91.3926578,-73.3062302,-73.89874689999999,-93.0529775,-93.63191309999999,-90.5776367,-90.66457179999999,-90.66457179999999,-93.5574376,-91.0432051,-94.9766416,-92.01856509999999,-81.0161994,-77.7388818,-80.1942499,-80.343418,-81.56151349999999,-77.8041609,-81.42789839999999,-106.6055534,-106.6055534,-122.3320708,-122.3320708,-122.2361101,-120.3086667,-88.1361888,-88.1856301,-87.6297982,-86.14805799999999,-85.81749459999999,-84.9291329,-86.0549863,-87.7017175,-87.2003091,-86.158068,-86.05296039999999,-85.2649754,-86.13360329999999,-86.7227195,-85.8499921,-90.67179709999999,-85.37995769999999,-90.64735759999999,-87.95355339999999,-87.14228949999999,-88.35145960000001,-89.5889864,-90.3354061,-85.7466439,-85.7466439,-87.8721602,-85.7702451,-86.25198979999999,-90.4279033,-90.58707919999999,-77.0469214,-86.261937,-81.834939,-81.9742921,-78.280558,-77.4360481,-78.44000989999999,-75.97798499999999,-76.7074571,-114.5644832,-113.795575,-116.5634625,-111.7924237,-72.2781409,-71.4547891,-114.4058752,-73.21207199999999,-73.17983199999999,-72.65649859999999,-72.9726065,-73.1393015,-72.6874023,-115.1398296,-115.1398296,-115.1398296,-119.8138027,-157.8583333,-157.8583333,-158.0000565,-157.9733333,-158.0209227,-112.0155015,-112.0260538,-111.8910474,-96.1350702,-97.1798456,-96.8627994,-99.2552479,-101.7203993,-97.0597019,-84.3879824,-84.3879824,-83.23515499999999,-83.7632366,-84.9877094,-84.2640904,-83.96602089999999,-84.3538128,-84.1468616,-84.5088899,-85.1646726,-81.09983419999999,-81.09983419999999,-84.981754,-83.8471223,-98.32529319999999,-102.8926536,-94.6554874,-94.6554874,-98.7528394,-98.7528394,-100.4370375,-98.49362819999999,-98.49362819999999,-98.15528719999999,-97.9413941,-94.5294639,-109.8343499,-96.5608242,-97.0035982,-105.1983148,-114.0931588,-98.0697249,-97.85223839999999,-97.7430608,-101.4787355,-102.2743489,-97.4974838,-97.39638099999999,-96.46887269999999,-97.3702735,-97.3307658,-97.13000609999999,-95.3698028,-95.3698028,-95.3698028,-95.3698028,-95.55077709999999,-99.1403189,-99.48032409999999,-84.2232612,-86.6933305,-86.8688899,-83.5101638,-85.1380092,-83.492396,-85.34384879999999,-84.6715407,-81.5253491,-82.3878709,-80.2683838,-86.11521839999999,-80.3256056,-80.1917902,-85.8054879,-82.4571776,-82.4571776,-82.4571776,-81.8114715,-81.7328567,-92.74324179999999,-93.21851439999999,-89.51814759999999,-94.56550659999999,-92.3340724,-92.2637823,-89.38562979999999,-94.5785667,-94.5785667,-94.4191177,-94.3546719,-93.2060163,-90.392888,-90.19940419999999,-91.16042069999999,-93.73604979999999,-85.9991369,-75.5668166,-96.50282089999999,-100.8104113,-102.7445233,-96.73110340000001,-103.8593697,-90.1848103,-72.7456519,-73.19517669999999,-72.9492703,-72.9861923,-72.3320051,-72.8684565,-72.5645602,-73.4081575,-72.82791499999999,-72.8230736,-93.53231029999999,-93.0899578,-93.0899578,-92.65242920000001,-93.48065559999999,-79.93105120000001,-81.0348144,-82.1617883,-82.29345850000001,-79.0414261,-79.12143130000001,-82.7073573,-82.0370466,-71.4372796,-71.5351476,-71.3128285,-71.3128285,-71.4128343,-104.1930918,-104.8213634,-104.8213634,-105.1783149,-104.990251,-104.990251,-104.9877597]},"kind":"numeric","n":10992,"n_null":29,"n_unique":5222,"null_rate":0.002638282387190684,"stats":{"iqr":17.987491699999993,"kurtosis":1.3284397638174177,"max":-67.8402316,"mean":-91.90926819065949,"median":-87.0902772,"min":-164.7238888,"n_outliers":128,"outlier_rate":0.011675636230958679,"q1":-98.4933873,"q3":-80.5058956,"skew":-1.155191079637431,"std":16.401246062650177,"zero_rate":0.0}},{"alerts":[],"column":"city_latitude","extras":{"histogram":{"counts":[5,90,1,0,7,106,114,145,256,222,369,569,988,560,666,703,1004,1341,1276,1258,401,387,184,220,59,0,0,0,0,0,2,1,0,1,5,13,1,0,6,3],"edges":[19.5756191,20.758686955,21.94175481,23.124822665,24.30789052,25.490958374999998,26.67402623,27.857094085,29.040161939999997,30.223229794999998,31.40629765,32.589365504999996,33.772433359999994,34.955501215,36.13856907,37.32163692499999,38.50470478,39.687772635,40.87084048999999,42.053908344999996,43.2369762,44.42004405499999,45.603111909999996,46.786179765,47.96924761999999,49.152315474999995,50.33538333,51.518451184999996,52.701519039999994,53.884586895,55.06765474999999,56.25072260499999,57.43379046,58.61685831499999,59.79992616999999,60.982994024999996,62.16606187999999,63.34912973499999,64.53219759,65.71526544499999,66.89833329999999]},"sample":[43.6008515,42.7351196,41.9403263,42.331427,42.0964314,42.9633599,42.9633599,42.6315066,42.245869,42.245869,46.4854993,44.9286137,46.5827512,45.8491796,46.3549984,41.8297694,42.4400357,44.3197591,42.65836609999999,43.1608578,42.6064095,42.6147541,42.6261446,40.3056302,39.727882,40.1030433,39.8309293,40.5395038,41.1370133,41.6414438,40.199814,41.8339653,41.2289714,41.8725781,39.9525839,39.9525839,40.44062479999999,40.44062479999999,40.44062479999999,40.44062479999999,40.44062479999999,40.3359028,40.3356483,40.8958927,40.6306464,40.1767688,41.0881409,40.539306,36.9741171,36.9741171,36.9741171,34.3541659,40.9661614,39.9625984,34.1161196,35.1321877,34.1705609,37.7396513,34.456151,38.1040864,34.0202894,42.3600825,42.3573021,34.1973122,34.1973122,33.9791793,33.88850350000001,41.6376043,42.6112018,42.7762015,42.2418172,42.35646089999999,42.35646089999999,42.18758260000001,42.1398577,41.9584457,37.7974273,37.7974273,34.0165053,33.9424658,42.3834278,34.235822,33.9022367,37.8043637,37.8043637,33.7174708,34.5794343,33.7444613,42.452303,35.6368759,33.7444613,34.1064001,35.6224561,33.9533487,33.9533487,33.9533487,37.7749295,37.7749295,34.5645371,35.4714724,34.8662005,33.2670725,44.0581728,36.0584021,36.382839,44.0520691,34.095287,34.1397292,33.916475,34.9455639,33.6850215,37.1229997,38.9582307,38.5449065,33.8120918,34.0224417,38.6446264,39.445723,37.5482697,33.7742692,33.8529097,40.0031409,34.6391501,34.0522342,34.0522342,34.0522342,31.4481547,35.0263915,33.4483771,31.9042517,32.2217429,32.2217429,33.9697664,32.6926512,38.9784453,39.0320554,39.2903848,39.2903848,39.2673283,39.0045544,39.0045544,39.0839981,39.4695489,38.0890152,39.6886056,34.3689747,34.5381481,36.5736459,34.6035669,35.8419977,35.7478769,35.1392357,35.4675602,35.6266957,36.1156071,36.1539816,36.1539816,35.5261633,43.4925843,43.8570065,64.8377778,30.8463055,31.7607195,29.95106579999999,29.95106579999999,29.95106579999999,33.6598257,33.5587173,34.79981,33.8137125,34.3652297,31.4071111,41.2990487,39.3331197,39.1031182,39.1031182,41.49932,39.6025696,39.6025696,39.7589478,39.0770072,40.06811920000001,41.1536674,40.742551,39.41535200000001,40.9611712,40.9608876,41.6639383,38.9351125,40.0298354,40.41482999999999,39.4020596,40.79676670000001,40.79676670000001,39.97205779999999,40.3284402,40.6975898,40.6975898,40.8931546,38.9071923,46.0869408,46.9139028,43.0249581,41.3113669,44.0997037,35.5950581,36.9685219,35.2270869,37.9989592,37.2662969,36.9486986,35.3062743,35.0526641,36.0726354,37.7030646,34.7540524,35.2451342,35.2626635,38.2009055,36.8431441,36.8431441,34.9854275,36.8656008,37.5531457,35.399308,35.0059914,35.7795897,36.3548586,34.8065528,36.4244396,36.3665216,34.9682097,38.2526647,38.1839705,37.17725009999999,37.8145384,37.3160706,37.3160706,37.650351,37.8403456,36.7533781,36.9886043,37.990079,38.8791783,38.0608445,39.0277832,37.410884,38.9916726,42.6525793,42.0900647,42.63839249999999,42.63396849999999,43.4617021,42.88644679999999,41.8298561,43.0387104,44.988444,42.0545029,43.3228462,42.8679836,41.1034326,40.789142,44.2619309,44.0288803,44.6942291,40.7282239,44.0886059,44.0886059,43.9461707,43.0389025,40.5795317,44.2138617,43.5391486,42.9105722,42.7284117,43.100903,44.5496859,40.7062104,40.9312099,42.55553400000001,42.0307812,41.5236437,42.5005583,42.5005583,41.3580484,41.424473,40.9296034,42.1646477,37.4223414,39.3253786,39.0659304,39.5309169,39.2667418,39.4300996,38.7564882,35.0853336,35.0853336,47.6062095,47.6062095,48.50389,46.3773509,42.1539141,41.9950276,41.8781136,41.44643600000001,41.7214389,40.830603,39.4806055,41.7205889,41.3186482,39.768403,38.8794321,41.4414384,40.486427,41.611143,41.3319904,40.4592076,38.7358933,40.9114271,41.8397865,39.69929459999999,41.6828074,40.6936488,41.6064219,39.9975414,39.9975414,41.98675069999999,38.685614,41.6763545,40.2942106,41.20309109999999,38.8048355,39.9508733,36.77381099999999,37.016222,39.0276078,37.5407246,38.2973519,36.8529263,37.2707022,43.745085,42.8379632,43.5407172,43.8231096,42.933692,42.9956397,42.9360165,44.4758825,43.6106223,44.1511723,43.6106237,44.8078225,44.4654332,36.1699412,36.1699412,36.1699412,39.5296329,21.3069444,21.3069444,21.4389123,21.3972222,21.5010495,41.5102129,41.1107771,40.7607793,41.5446975,40.1466169,40.9066713,40.7007586,41.12821780000001,41.4483432,33.7489954,33.7489954,34.3698266,34.5970402,32.4609764,33.2467807,33.2945651,33.5215013,33.4473361,34.7275,34.257038,32.0835407,32.0835407,34.8033566,34.9331453,26.2159066,31.5942991,31.6035129,31.6035129,33.370663,33.370663,31.4637723,29.4241219,29.4241219,26.1892409,29.8832749,30.2841668,46.435512,32.7965165,28.8052674,48.1130741,46.50992249999999,27.7522487,30.7821302,30.267153,32.2503979,33.1812035,25.9017472,27.8005828,32.0954304,30.3496528,32.7554883,32.0109886,29.7604267,29.7604267,29.7604267,29.7604267,30.7235263,30.0474332,27.5305671,36.2989682,35.6264581,35.9250637,35.714259,35.1136837,36.122311,35.1225727,36.2431964,29.1624801,28.5552719,25.72149,30.7210227,27.4467056,25.7616798,30.1765914,27.950575,27.950575,27.950575,27.5472589,28.0222435,38.9736392,36.6436731,37.3058839,37.1767249,38.9517053,37.948928,36.7797776,39.0997265,39.0997265,39.2461138,37.83920519999999,37.0208865,36.7569994,38.6270025,38.2081045,38.7627893,39.905778,39.6620397,43.7174725,45.8144431,43.27309,43.5445959,44.4908172,32.2987573,41.621488,41.1865478,41.67176480000001,41.6538325,41.5756728,41.2841687,41.3581869,41.11774399999999,41.8540094,41.4570108,44.86196450000001,44.9537029,44.9537029,45.4019062,44.6709766,32.7764749,34.0007104,34.1954001,33.9134577,33.5510021,33.4332236,34.8834489,34.7395701,41.7798226,41.5750676,41.4901024,41.4901024,41.8239891,39.8398269,38.8338816,38.8338816,38.7466555,39.7392358,39.7392358,39.6477653]},"kind":"numeric","n":10992,"n_null":29,"n_unique":5310,"null_rate":0.002638282387190684,"stats":{"iqr":7.109226100000001,"kurtosis":1.4784516858335692,"max":66.89833329999999,"mean":38.3765746205327,"median":39.2833968,"min":19.5756191,"n_outliers":128,"outlier_rate":0.011675636230958679,"q1":34.7377795,"q3":41.8470056,"skew":-0.3249613585827565,"std":5.067071730351871,"zero_rate":0.0}},{"alerts":[{"code":"allcaps","level":"info","message":"100.0% rows are all-caps"}],"column":"location_2","extras":{"language_counts":{},"language_sample_size":5000,"length_histogram":{"counts":[1,8,0,2,0,20,0,104,0,679,0,1007,0,3740,0,1567,0,0,0,1,13,0,54,0,453,0,1807,0,114,0,0,0,0,0,0,0,0,0,0,161],"edges":[22.0,22.525,23.05,23.575,24.1,24.625,25.15,25.675,26.2,26.725,27.25,27.775,28.3,28.825,29.35,29.875,30.4,30.925,31.450000000000003,31.975,32.5,33.025,33.55,34.075,34.6,35.125,35.65,36.175,36.7,37.225,37.75,38.275000000000006,38.8,39.325,39.85,40.375,40.900000000000006,41.425,41.95,42.475,43.0]},"near_unique":false,"sample":["POINT(-83.433713 45.0629087)","POINT(-84.5779283 33.9830727)","POINT(-80.1239712 26.1195078)","POINT(-95.90999810000001 30.0578156)","POINT(-108.390103 44.8377923)","POINT(-82.10835469999999 34.2120049)","POINT(-79.50235669999999 36.1027527)","POINT(-90.3387251 38.5892737)","POINT(-95.2774671 29.7107917)","POINT(-83.279726 42.6192354)","POINT(-122.518458 47.1717649)","POINT(-73.9239496 40.7563454)","POINT(-112.4676356 34.5420178)","POINT(-83.205793 42.541766)","POINT(-77.4002193 39.4543011)","POINT(-121.5639572 36.686397)","POINT(-79.9023718 40.4466602)","POINT(-88.47832509999999 35.8577112)","POINT(139.7589148 35.6723855)","POINT(-75.1189478 39.7098595)","POINT(-96.7756665 34.9701858)","POINT(-85.4652751 43.0747964)","POINT(-71.1238204 42.395749)","POINT(-78.4051669 40.3388332)","POINT(-71.978033 43.412062)","POINT(-84.55053079999999 34.3209328)","POINT(-88.3065288 44.02803660000001)","POINT(-119.331392 35.353561)","POINT(-75.5715699 40.0280292)","POINT(-80.1131566 34.4794831)","POINT(-89.8409817 39.97550469999999)","POINT(-86.91332799999999 38.677875)","POINT(-86.84888839999999 38.6142182)","POINT(-81.4408326 41.3080065)","POINT(-84.5026366 39.1021235)","POINT(-80.83279 35.1885164)","POINT(-72.7895992 41.63367909999999)","POINT(-79.2401093 42.0955527)","POINT(-84.659072 38.987994)","POINT(-89.0454074 42.7024252)","POINT(-106.2662123 31.6769476)","POINT(-88.62868189999999 34.8722125)","POINT(-110.9546735 31.38903939999999)","POINT(-89.6036413 31.0473719)","POINT(-93.27420479999999 44.95853899999999)","POINT(-80.8360014 33.7376294)","POINT(-87.7675697 31.2785544)","POINT(-83.9949268 39.6932514)","POINT(-70.893118 42.522611)","POINT(-82.60730699999999 27.847677)"],"top_values":[["POINT(-76.87552819999999 39.0045544)",20],["POINT(-117.3763701 33.9841225)",12],["POINT(-81.20812029999999 28.669997)",12],["POINT(-73.88569869999999 40.8620404)",11],["POINT(-73.1964637 44.4778528)",11],["POINT(-93.8720852 39.1868282)",11],["POINT(-83.1932284 37.24954)",10],["POINT(-86.456138 36.9853543)",9],["POINT(-84.4821719 42.701848)",8],["POINT(-77.16306689999999 40.2034861)",8],["POINT(-157.7762165 21.2705629)",8],["POINT(-70.9660014 41.9877398)",7],["POINT(-80.244216 36.09985959999999)",7],["POINT(-95.23334039999999 38.9377658)",7],["POINT(-71.4074596 41.8259947)",7],["POINT(-75.3812135 40.6308814)",6],["POINT(-77.2375078 39.8362073)",6],["POINT(-77.8599084 40.7982133)",6],["POINT(-77.0365298 38.8976763)",6],["POINT(-73.4564319 44.6551543)",6]],"top_words":[["point(-76.87552819999999",20],["39.0045544)",20],["point(-117.3763701",12],["33.9841225)",12],["point(-81.20812029999999",12],["28.669997)",12],["point(-73.88569869999999",11],["40.8620404)",11],["point(-73.1964637",11],["44.4778528)",11],["point(-93.8720852",11],["39.1868282)",11],["point(-83.1932284",10],["37.24954)",10],["point(-86.456138",9],["36.9853543)",9],["point(-84.4821719",8],["42.701848)",8],["point(-77.16306689999999",8],["40.2034861)",8],["point(-157.7762165",8],["21.2705629)",8],["point(-70.9660014",7],["41.9877398)",7],["point(-80.244216",7]],"vocab_skipped":null,"word_histogram":{"counts":[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9731,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":10992,"n_null":1261,"n_unique":8776,"null_rate":0.11471979621542941,"stats":{"allcaps_rate":1.0,"boilerplate_rate":0.0,"duplicate_rate":0.09813996506011716,"emoji_rate":0.0,"len_max":43,"len_mean":30.80896105230706,"len_median":29.0,"len_min":22,"len_p95":36.0,"n_duplicates":955,"n_empty":0,"one_word_rate":0.0,"readability_flesch_mean":120.205,"url_rate":0.0,"vocab_size":17549,"word_mean":2.0,"word_median":2.0}},{"alerts":[{"code":"allcaps","level":"info","message":"100.0% rows are all-caps"},{"code":"duplicates","level":"warn","message":"51.6% duplicate strings"}],"column":"city_location","extras":{"language_counts":{},"language_sample_size":5000,"length_histogram":{"counts":[2,0,0,1,0,2,0,45,0,158,0,890,0,4648,0,1988,0,0,0,1,1,0,21,0,238,0,2711,0,116,0,0,0,0,0,0,0,0,0,0,141],"edges":[22.0,22.525,23.05,23.575,24.1,24.625,25.15,25.675,26.2,26.725,27.25,27.775,28.3,28.825,29.35,29.875,30.4,30.925,31.450000000000003,31.975,32.5,33.025,33.55,34.075,34.6,35.125,35.65,36.175,36.7,37.225,37.75,38.275000000000006,38.8,39.325,39.85,40.375,40.900000000000006,41.425,41.95,42.475,43.0]},"near_unique":false,"sample":["POINT(-83.7430378 42.2808256)","POINT(-85.2594586 34.9330742)","POINT(-81.46259189999999 30.6696818)","POINT(-97.69610259999999 26.1906306)","POINT(-106.9561791 44.7971939)","POINT(-82.3940104 34.85261759999999)","POINT(-87.6925074 37.1672684)","POINT(-93.7171621 39.0725121)","POINT(-95.3698028 29.7604267)","POINT(-83.29104679999999 42.6389216)","POINT(-120.3103494 47.4234599)","POINT(-89.4012302 43.0730517)","POINT(-76.4921829 38.9784453)","POINT(-83.2827093 42.5793103)","POINT(-75.7063197 38.6353924)","POINT(-117.1610838 32.715738)","POINT(-79.9958864 40.44062479999999)","POINT(-89.78491269999999 35.423208)","POINT(-104.990251 39.7392358)","POINT(-74.2082671 40.1645785)","POINT(-96.3372309 36.6678426)","POINT(-83.1499322 42.65836609999999)","POINT(-71.0897674 41.900101)","POINT(-78.3908471 40.3359086)","POINT(-71.82228719999999 43.1798323)","POINT(-82.0170596 31.48632539999999)","POINT(-75.1548888 43.5203464)","POINT(-118.1058333 34.09611110000001)","POINT(-80.44868 41.2333896)","POINT(-82.1617883 34.1954001)","POINT(-89.640658 40.5675388)","POINT(-87.15085619999999 40.9367045)","POINT(-89.6501481 39.78172130000001)","POINT(-82.36460679999999 41.4219889)","POINT(-81.6943605 41.49932)","POINT(-85.3419069 37.3433974)","POINT(-72.5441445 42.0027181)","POINT(-73.66956239999999 42.7845222)","POINT(-85.49885479999999 37.2608936)","POINT(-91.23958069999999 43.8013556)","POINT(-106.4850217 31.7618778)","POINT(-103.8593697 44.4908172)","POINT(-110.926479 32.2217429)","POINT(-103.2310149 44.0805434)","POINT(-92.9952153 44.9530215)","POINT(-81.9320482 34.9495672)","POINT(-85.5221667 32.0770977)","POINT(-80.81841659999999 41.2375569)","POINT(-118.1137535 34.0165053)","POINT(-82.6267345 27.7518284)"],"top_values":[["POINT(-118.2436849 34.0522342)",61],["POINT(-98.49362819999999 29.4241219)",55],["POINT(-157.8583333 21.3069444)",44],["POINT(-79.9958864 40.44062479999999)",42],["POINT(-106.4850217 31.7618778)",37],["POINT(-95.3698028 29.7604267)",33],["POINT(-99.48032409999999 27.5305671)",32],["POINT(-81.3792365 28.5383355)",32],["POINT(-110.926479 32.2217429)",30],["POINT(-87.6297982 41.8781136)",30],["POINT(-117.1610838 32.715738)",27],["POINT(-122.4194155 37.7749295)",27],["POINT(-122.3320708 47.6062095)",27],["POINT(-117.3961564 33.9533487)",26],["POINT(-76.6121893 39.2903848)",26],["POINT(-90.0715323 29.95106579999999)",26],["POINT(-85.7584557 38.2526647)",26],["POINT(-104.8213634 38.8338816)",26],["POINT(-111.8910474 40.7607793)",25],["POINT(-122.6764815 45.5230622)",24]],"top_words":[["point(-118.2436849",61],["34.0522342)",61],["point(-98.49362819999999",55],["29.4241219)",55],["point(-157.8583333",44],["21.3069444)",44],["point(-79.9958864",42],["40.44062479999999)",42],["point(-106.4850217",37],["31.7618778)",37],["point(-95.3698028",33],["29.7604267)",33],["point(-99.48032409999999",32],["27.5305671)",32],["point(-81.3792365",32],["28.5383355)",32],["point(-110.926479",30],["32.2217429)",30],["point(-87.6297982",30],["41.8781136)",30],["point(-117.1610838",27],["32.715738)",27],["point(-122.4194155",27],["37.7749295)",27],["point(-122.3320708",27]],"vocab_skipped":null,"word_histogram":{"counts":[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,10963,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":10992,"n_null":29,"n_unique":5311,"null_rate":0.002638282387190684,"stats":{"allcaps_rate":1.0,"boilerplate_rate":0.0,"duplicate_rate":0.5155523123232691,"emoji_rate":0.0,"len_max":43,"len_mean":31.192739213718873,"len_median":29.0,"len_min":22,"len_p95":36.0,"n_duplicates":5652,"n_empty":0,"one_word_rate":0.0,"readability_flesch_mean":120.205,"url_rate":0.0,"vocab_size":10532,"word_mean":2.0,"word_median":2.0}}],"insights":{"errors":[],"insights":[{"confidence":"high","critiques":[],"evidence_keys":["row_count","column_count","country.top_rate","state.top_values","state.entropy_ratio","location.top_words","description.word_mean","description.n_unique","latitude.null_rate","latitude.min","longitude.n_outliers"],"featured_charts":[{"caption":"Shows which states report the most ghost sightings \u2014 California, Texas, and Pennsylvania dominate.","column":"state","kind":"bar"},{"caption":"Distribution of location-name lengths; most are short (median 17 chars) but a long tail goes up to 1,016.","column":"location","kind":"length"},{"caption":"Most sightings cluster in the continental US latitudes, but watch for outliers reaching as far south as -45.","column":"latitude","kind":"histogram"},{"caption":"Longitude spread reveals the east\u2013west footprint of sightings, with a heavy concentration around -87.","column":"longitude","kind":"histogram"},{"caption":"Description lengths are right-skewed: median ~297 characters but reaching up to 5,280 for the most detailed accounts.","column":"description","kind":"length"}],"model":"anthropic:claude-opus-4-7","narrative":"This dataset catalogs 10,992 reported ghost sightings across the United States, with each record describing a location (city, state, latitude/longitude) and a free-text description of the sighting. Every record is in the United States (country has only 1 unique value), and California, Texas, and Pennsylvania lead the state counts \u2014 California alone holds about 9.7% of all sightings. The location column is rich with thematic words like 'school', 'cemetery', 'high', and 'house', hinting at the kinds of places people report hauntings. Worth a closer look: the geographic skew toward a few populous states, and the description field which averages ~70 words per entry and is nearly all unique \u2014 a good candidate for text mining. Note that latitude/longitude have ~11.5% nulls and a handful of outliers (including a min latitude of -45 that falls outside the US).","scope":"dataset","target":"__global__"},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.len_mean","stats.one_word_rate","stats.duplicate_rate","stats.n_duplicates","top_values","top_words"],"model":"anthropic:claude-opus-4-7","narrative":"Short place-name strings (mean 9 characters, 73% one-word) with familiar US city names like Los Angeles, San Antonio, and Houston dominating the top values. Heavy duplication (60%, 6604 rows) is expected for a city field and 4385 uniques suggests broad geographic coverage. Top word frequencies ('city', 'county', 'san', 'st.', 'new', 'fort') confirm conventional US toponymy with no emoji, URLs, or boilerplate noise.","role":"feature","scope":"column","target":"city","treatment":"Treat as a categorical/geographic feature; consider geocoding or grouping rare values before encoding."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","stats.cardinality","stats.top_rate","stats.top_value","stats.entropy","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"This column records country, but every one of the 10,992 rows is \"United States\" \u2014 cardinality is 1 and top_rate is 1.0. It carries zero information (entropy 0.0) and cannot discriminate between records.","role":"metadata","scope":"column","target":"country","treatment":"Drop; constant column with no signal."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.len_mean","stats.len_median","stats.len_max","stats.word_mean","stats.word_median","stats.readability_flesch_mean","stats.vocab_size","stats.duplicate_rate","stats.n_duplicates","stats.boilerplate_rate","stats.url_rate","stats.allcaps_rate","stats.emoji_rate","top_words","alerts"],"model":"anthropic:claude-opus-4-7","narrative":"Free-text descriptions, averaging 70 words (median 55) and reaching up to 5,280 characters, with a Flesch readability of ~69.7 indicating fairly accessible prose. Nearly every row is unique (10,987 of 10,992) with only 5 duplicates and a vocabulary of 33,001 tokens, so this reads as bespoke long-form copy rather than templated text. Boilerplate (0.6%), URLs (0.5%), all-caps (0.06%) and emoji (0%) are all negligible, and the top words are common English stopwords \u2014 consistent with natural English narrative.","role":"free_text","scope":"column","target":"description","treatment":"Tokenize and embed before modelling; do not use as a categorical key."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.len_mean","stats.len_median","stats.word_mean","stats.duplicate_rate","stats.n_duplicates","top_values","top_words"],"model":"anthropic:claude-opus-4-7","narrative":"Short free-text place names averaging 2.98 words and 19.3 characters, with values like 'Prince Georges county', 'Cemetery', 'Cry Baby Bridge', and 'Wal-Mart' \u2014 likely the named site of a story or sighting (probably ghost/folklore lore given top entries). Vocabulary is dominated by 'school', 'cemetery', 'high', 'university', 'house', 'road', suggesting a strong tilt toward institutional and roadside locations. High cardinality (9903 unique of 10992) coexists with a 9.9% duplicate rate and one value ('Prince Georges county') hit 18 times, so most entries are unique strings but a long tail of repeated landmarks exists.","role":"free_text","scope":"column","target":"location","treatment":"Normalise casing/whitespace and geocode or entity-link to extract structured place features 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 US state field with 51 distinct values (likely the 50 states plus DC) across 10,992 rows and no nulls. Distribution is broad with high entropy ratio (0.916); California leads at 9.73% (1,070 rows), followed by Texas (696) and Pennsylvania (649), roughly tracking population except Pennsylvania ranking unusually high above Florida (which doesn't appear in the top 10).","role":"feature","scope":"column","target":"state","treatment":"One-hot or target-encode for modelling; consider grouping low-frequency states."},{"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 US state abbreviation field with 51 distinct values (50 states plus presumably DC) and no nulls across 10,992 rows. Distribution is broadly spread (entropy ratio 0.916) with CA leading at 9.7% (1,070 rows), followed by TX (696) and PA (649), consistent with population-weighted geographic data.","role":"feature","scope":"column","target":"state_abbrev","treatment":"one-hot or target-encode for modelling; safe to use as-is for grouping or joins."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.min","stats.max","stats.q1","stats.q3","stats.median","stats.mean","stats.kurtosis","stats.n_outliers","stats.outlier_rate"],"model":"anthropic:claude-opus-4-7","narrative":"Geographic longitude coordinates, with 8774 unique values across 10992 rows and an 11.47% null rate. Values span -164.72 to 168.70 but cluster tightly between Q1 -99.12 and Q3 -80.30, indicating most records sit in North America despite the global range. Kurtosis of 15.2 confirms heavy tails from the 131 outliers (1.35%) reaching across the Pacific.","role":"feature","scope":"column","target":"longitude","treatment":"Pair with latitude for geospatial features; impute or filter the 11.47% nulls before mapping."},{"confidence":"high","critiques":[],"evidence_keys":["min","max","median","q1","q3","iqr","mean","std","skew","kurtosis","n_outliers","outlier_rate","null_rate","n_unique","n"],"model":"anthropic:claude-opus-4-7","narrative":"Geographic latitude in decimal degrees, ranging from -45.02 to 66.89 with a median of 39.28 and IQR of 7.20, suggesting most observations cluster in the northern mid-latitudes. The distribution is left-skewed (-0.97) with heavy tails (kurtosis 11.38) and 124 outliers (1.27%), consistent with a few southern-hemisphere points dragging the tail. Note the 11.47% null rate, which will need handling before any spatial analysis.","role":"feature","scope":"column","target":"latitude","treatment":"Pair with longitude for geospatial features; impute or drop the ~11% nulls before modelling."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.min","stats.max","stats.mean","stats.median","stats.skew","stats.q1","stats.q3","stats.n_outliers","stats.outlier_rate"],"model":"anthropic:claude-opus-4-7","narrative":"Longitude of a city, with all 10992 values negative (min -164.72, max -67.84), placing every record in the Western Hemisphere and consistent with North American coverage. The distribution is left-skewed (skew -1.16) with median -87.09 pulled east of the mean -91.91, suggesting a concentration in the central/eastern US with a tail reaching toward Alaska or the Pacific. 5222 unique values across 10992 rows indicate many records share the same city, and 128 outliers (1.17%) likely correspond to far-western locations.","role":"feature","scope":"column","target":"city_longitude","treatment":"Use as a geospatial feature alongside latitude; consider clustering or binning rather than treating as a plain scalar."},{"confidence":"high","critiques":[],"evidence_keys":["min","max","mean","median","q1","q3","std","skew","kurtosis","n_outliers","outlier_rate","n_unique","n","null_rate"],"model":"anthropic:claude-opus-4-7","narrative":"This column holds city latitudes in decimal degrees, ranging from 19.58 to 66.90 with a median of 39.28 and an IQR spanning 34.74 to 41.85. Values cluster firmly in the northern mid-latitudes (mean 38.38, std 5.07), with mild left skew (-0.32) and 128 outliers (1.17%) likely representing far-northern locales. Cardinality is moderate (5310 unique of 10992) and nulls are negligible (0.26%).","role":"feature","scope":"column","target":"city_latitude","treatment":"Pair with longitude for geospatial features; avoid treating as a standalone scalar."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.len_min","stats.len_max","stats.word_mean","stats.duplicate_rate","stats.allcaps_rate","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"This column holds WKT geometry strings in the form `POINT(lon lat)`, with 8776 unique values across 10992 rows and an 11.47% null rate. Values are tightly bounded (length 22-43, always two 'words') and 9.81% are duplicates, with the most repeated coordinate appearing 20 times \u2014 suggesting clusters at recurring sites. The 'allcaps' alert is a false positive driven by the literal `POINT` prefix rather than natural language.","role":"feature","scope":"column","target":"location_2","treatment":"Parse into numeric longitude/latitude pair before any geospatial modelling."},{"confidence":"high","critiques":[],"evidence_keys":["stats.allcaps_rate","stats.word_mean","stats.duplicate_rate","stats.n_duplicates","n_unique","n","null_rate","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"Despite the name, city_location stores WKT POINT(longitude latitude) geometry strings, not city names \u2014 every value matches that format (allcaps_rate 1.0, word_mean 2.0). Roughly half the rows are repeats (duplicate_rate 0.516, n_duplicates 5652) with the top coordinate (Los Angeles, 34.05/-118.24) appearing 61 times, suggesting a finite set of city centroids reused across records. Cardinality is still high (5311 unique of 10992) and nulls are negligible (0.26%).","role":"feature","scope":"column","target":"city_location","treatment":"Parse the POINT() strings into numeric lat/long pairs before any geospatial modelling."}],"providers":["anthropic:claude-opus-4-7"],"total_usage":{"completion_tokens":4326,"prompt_tokens":17166,"total_tokens":21492}},"language_counts":{},"meta":{"generated_at":"2026-05-01T18:37:32+00:00","mode":"full","row_count":10992,"sampled_rows":10992,"seed":42,"source":"/home/coolhand/html/datavis/data_trove/data/wild/ghost_sightings.csv"},"notes":[],"saturn_version":"0.2.0","schema":{"city":"text","city_latitude":"numeric","city_location":"text","city_longitude":"numeric","country":"categorical","description":"text","latitude":"numeric","location":"text","location_2":"text","longitude":"numeric","state":"categorical","state_abbrev":"categorical"}}