Authors: Giulia Renda
Part of: wikidata
Source: SPARQL endpoint
Export
{'sparql_endpoint': 'https://query.wikidata.org/sparql', 'template_mode': 'statistics', 'title': 'Through the Prism of Diversity', 'color_code': ['#3aeeb2', '#5549b6'], 'section_name': 'wikidata', 'subtitle': 'Discover the Intriguing Links: Human Origins, Eye Colours, and Feline Companions Unveiled!', 'curator': 'Giulia Renda', 'description': 'Come join us on an exciting journey that combines data visualizations and storytelling, revealing the captivating connections between human origins, eye colours, and the special bonds we form with our beloved feline pals. This data story takes you deep into the realms of human history, genetic diversity, and the irresistible charm of our mysterious furry companions. Get ready to be amazed!', 'dynamic_elements': [{'position': 0, 'operations': [], 'type': 'count', 'count_query': 'SELECT (COUNT(*) AS ?count)\r\nWHERE {\r\n ?item wdt:P31 wd:Q5 .\r\n}', 'count_label': 'Number of humans in Wikidata', 'extra_queries': [], 'map_filters': []}, {'position': 1, 'operations': [], 'type': 'text', 'text': '<p>With a staggering count of more that 10 millions individuals, the vast and diverse realm of humanity comes to life within the expansive realm of Wikidata. This digital repository of knowledge encapsulates a wealth of information about people from all walks of life, spanning cultures, eras, and continents.</p>', 'extra_queries': [], 'map_filters': []}, {'position': 2, 'operations': [], 'type': 'map', 'map_title': 'Continents Revealed: Mapping Birthplaces of some Individuals', 'map_points_query': 'SELECT DISTINCT ?point ?pointLabel ?personLabel ?lat ?long\r\nWHERE {\r\n SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }\r\n ?person wdt:P31 wd:Q5;\r\n wdt:P19 ?point .\r\n \r\n ?point wdt:P31 wd:Q5107 .\r\n ?point p:P625 ?statement.\r\n ?statement psv:P625 ?node.\r\n ?node wikibase:geoLatitude ?lat.\r\n ?node wikibase:geoLongitude ?long.\r\n}', 'extra_queries': [], 'map_filters': []}, {'position': 3, 'operations': [], 'type': 'chart', 'chart_type': 'barchart', 'chart_title': 'Eye Candy: the Kaleidoscope of common eye colours', 'chart_query': 'SELECT ?label (COUNT(?human) AS ?count)\r\nWHERE\r\n{\r\n ?human wdt:P31 wd:Q5.\r\n ?human wdt:P1340 ?eyeColor.\r\n ?eyeColor rdfs:label ?label .\r\n FILTER(lang(?label) = "en")\r\n\r\n}\r\nGROUP BY ?label\r\nORDER BY DESC(?count)\r\nLIMIT 10', 'chart_series': 'Humans per colour', 'chart_legend': {'x': 'colour', 'y': 'n. of humans'}, 'extra_queries': [], 'map_filters': []}, {'position': 4, 'operations': [], 'type': 'text', 'text': '<p>From rich chocolate browns to sparkling emeralds, and from oceanic blues to mysterious hazels, behold the mesmerising kaleidoscope of eye colours that captivate our hearts. Each slice of the chart gives you a sneak peek into the abundance of people rocking those fabulous eye hues, letting you see the relative popularity at a glance.</p>', 'extra_queries': [], 'map_filters': []}, {'position': 5, 'operations': [], 'type': 'text', 'text': "<h2>Paws and Companions: Exploring the Pet Owners among Wikidata's Human Tapestry</h2>", 'extra_queries': [], 'map_filters': []}, {'position': 6, 'operations': [], 'type': 'count', 'count_query': 'SELECT (COUNT(DISTINCT ?human) AS ?count)\r\nWHERE \r\n{\r\n ?cat wdt:P31 wd:Q146.\r\n ?human wdt:P31 wd:Q5 .\r\n ?human wdt:P1429|wdt:P1830 ?cat .\r\n SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }\r\n} ', 'count_label': 'Known Cat Owners', 'extra_queries': [], 'map_filters': []}, {'position': 7, 'operations': [], 'type': 'text', 'text': "<p> Let's take a closer look at these incredible duos.</p>", 'extra_queries': [], 'map_filters': []}, {'position': 8, 'operations': [], 'type': 'table', 'table_title': 'Purrfect Pals: Cat Owners and Their Furry Friends', 'table_query': 'SELECT DISTINCT ?human ?humanLabel ?cat ?catLabel ?birthDate ?birthPlace ?birthPlaceLabel ?breed ?breedLabel ?pic\r\nWHERE \r\n{\r\n ?cat wdt:P31 wd:Q146.\r\n ?human wdt:P31 wd:Q5 .\r\n ?human wdt:P1429|wdt:P1830 ?cat .\r\n OPTIONAL { ?cat wdt:P569 ?birthDate . }\r\n OPTIONAL { ?cat wdt:P19 ?birthPlace . }\r\n OPTIONAL { ?cat wdt:P4743 ?breed . }\r\n OPTIONAL { ?cat wdt:P18 ?pic . }\r\n SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }\r\n}', 'extra_queries': [], 'map_filters': []}, {'position': 9, 'operations': [], 'type': 'text', 'text': '<p>Each entry unveils a unique story of love, devotion, and the extraordinary bonds forged between humans and their beloved pets.</p>', 'extra_queries': [], 'map_filters': []}, {'position': 10, 'operations': [], 'type': 'text', 'text': "<p>Building upon the cool cats listed in the table, we've got a whole lot more to uncover about their intriguing characteristics. Want to know about similar breeds, hair colours, or even the reasons behind their goodbyes? Just pick a cat's name from the table, and get ready to be blown away by the awesome info that's waiting for you. Let the adventure begin!</p>", 'extra_queries': [], 'map_filters': []}, {'position': 11, 'operations': [], 'type': 'textsearch', 'textsearch_userinput': '', 'textsearch_title': 'Find your cat', 'textsearch_query': "SELECT DISTINCT ?cat ?catLabel ?deathCause ?deathCauseLabel\r\nWHERE {\r\n ?cat wdt:P31 wd:Q146;\r\n rdfs:label ?catLabel .\r\n?cat wdt:P509 ?deathCause .\r\n ?deathCause rdfs:label ?deathCauseLabel .\r\n FILTER (lang(?deathCauseLabel) = 'en')\r\nFILTER regex(str(?catLabel), <<searchterm>>, 'i')\r\nFILTER (lang(?catLabel) = 'en')\r\n}", 'textsearch': {'breed': ['same breed'], 'cat': ['same breed', 'same colour'], 'deathCause': ['same death'], 'hairColour': ['same colour']}, 'extra_queries': [], 'map_filters': []}, {'position': 12, 'operations': [], 'type': 'action', 'action_title': 'same breed', 'action_query': 'SELECT ?cat ?catLabel ?owner ?ownerLabel WHERE { \r\n?cat wdt:P4743 <<item>> .\r\n?owner wdt:P1429|wdt:P1830 ?cat .\r\nSERVICE wikibase:label {\r\n bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en"\r\n }}', 'extra_queries': [], 'map_filters': []}, {'position': 13, 'operations': [], 'type': 'action', 'action_title': 'same breed', 'action_query': 'SELECT ?cat ?catLabel ?owner ?ownerLabel WHERE { \r\n<<item> wdt:P4743 ?breed .\r\n?cat wdt:P4743 ?breed .\r\n?owner wdt:P1429|wdt:P1830 ?cat .\r\nSERVICE wikibase:label {\r\n bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en"\r\n }}', 'extra_queries': [], 'map_filters': []}, {'position': 14, 'operations': [], 'type': 'action', 'action_title': 'same colour', 'action_query': 'SELECT ?cat ?catLabel ?owner ?ownerLabel WHERE { \r\n<<item>> wdt:P1884|wdt:P462 ?hairColour .\r\n?cat wdt:P1884|wdt:P462 ?hairColour .\r\n?owner wdt:P1429|wdt:P1830 ?cat .\r\nSERVICE wikibase:label {\r\n bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en"\r\n }}', 'extra_queries': [], 'map_filters': []}, {'position': 15, 'operations': [], 'type': 'action', 'action_title': 'same death', 'action_query': 'SELECT ?cat ?catLabel ?owner ?ownerLabel WHERE { \r\n?cat wdt:P509 <<item>> .\r\n?owner wdt:P1429|wdt:P1830 ?cat .\r\nSERVICE wikibase:label {\r\n bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en"\r\n }}', 'extra_queries': [], 'map_filters': []}, {'position': 16, 'operations': [], 'type': 'chart', 'chart_type': 'linechart', 'chart_title': '', 'chart_query': '', 'chart_series': '', 'chart_legend': {'x': '', 'y': ''}, 'extra_queries': [], 'map_filters': []}]}
Come join us on an exciting journey that combines data visualizations and storytelling, revealing the captivating connections between human origins, eye colours, and the special bonds we form with our beloved feline pals. This data story takes you deep into the realms of human history, genetic diversity, and the irresistible charm of our mysterious furry companions. Get ready to be amazed!