painting/ShexCreatorHelp.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#  Shex Creation Help\n",
    "\n",
    "This tool will help to generate SheX for a given entity (Example E130.ipynb written by Tom Baker)\n",
    "\n",
    "We would like to know the properties to be used for a given item. There are two ways: making use of Wikidata property suggestion API or checking the current usage of properties by sibling instances. \n",
    "\n",
    "* Obtaining suggestions for a given item\n",
    "\n",
    "Given an item identifier (Q-number) on Wikidata,we would like to know the properties suggested by Wikidata. Wikidata has a suggestions operations for this purpose. \n",
    "\n",
    "But sometimes, it's useful to make use of existing instances of a class and the properties used by these instances. For example, give me the properties used by different instances of painting on Wikidata.\n",
    "\n",
    "* Get properties of instances of a class\n",
    "\n",
    "Given an item identifier (Q-number) on Wikidata, we would like to know the properties used by instances of this item\n",
    "\n",
    "### Acknowledgements\n",
    "Andra Waagmeester, Maarten Daammers"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests\n",
    "\n",
    "baseurl=\"https://www.wikidata.org/w/api.php?action=wbsgetsuggestions&format=json&limit=50&entity=\"\n",
    "\n",
    "def get_property_suggestions(entity):\n",
    "    \"\"\"\n",
    "    Returns string of property suggestion\n",
    "\n",
    "    Parameters:\n",
    "        entity (str): identifier of an identity\n",
    "\n",
    "    Returns:\n",
    "        (list): list of properties\n",
    "\n",
    "    \"\"\"\n",
    "    \n",
    "    propertylist = []\n",
    "    url = baseurl + entity\n",
    "    response = requests.get(url)\n",
    "    if(response.status_code == 200):\n",
    "        results = response.json()\n",
    "        for prop in results[\"search\"]:\n",
    "            propertylist.append(\"wdt:\" + prop[\"id\"])\n",
    "            \n",
    "    return(propertylist)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['wdt:P1476']\n"
     ]
    }
   ],
   "source": [
    "l = get_property_suggestions(\"Q23898\")\n",
    "print(l)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "from urllib.parse import quote\n",
    "def get_currently_used_properties(entityid):\n",
    "    propertylist = []\n",
    "    query = \"\"\"\n",
    "       SELECT DISTINCT ?property\n",
    "       {\n",
    "            hint:Query hint:optimizer \"None\".\n",
    "            {\n",
    "                SELECT ?entity {\n",
    "               ?entity wdt:P31 wd:entityid.\n",
    "              }\n",
    "              LIMIT 1000\n",
    "            }\n",
    "\n",
    "            ?entity ?prop [].\n",
    "                ?property wikibase:directClaim ?prop.\n",
    "       }\"\"\"\n",
    "    baseurl = \"https://query.wikidata.org/sparql?query=\"\n",
    "    formatstr = \"&format=json\"\n",
    "\n",
    "    query = query.replace(\"entityid\", entityid)\n",
    "    url = baseurl+quote(query)+formatstr\n",
    "    response = requests.get(url)\n",
    "    if(response.status_code == 200):\n",
    "        results = response.json()\n",
    "        for prop in results[\"results\"][\"bindings\"]:\n",
    "            propertylist.append(prop[\"property\"][\"value\"].replace(\"http://www.wikidata.org/entity/\",\"wdt:\"))\n",
    "    \n",
    "    return(propertylist)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['wdt:P6372', 'wdt:P4511', 'wdt:P1705', 'wdt:P186', 'wdt:P138', 'wdt:P4178', 'wdt:P4582', 'wdt:P6020', 'wdt:P508', 'wdt:P840', 'wdt:P1669', 'wdt:P1566', 'wdt:P2284', 'wdt:P3219', 'wdt:P1269', 'wdt:P6358', 'wdt:P2441', 'wdt:P88', 'wdt:P646', 'wdt:P528', 'wdt:P2092', 'wdt:P2344', 'wdt:P6405', 'wdt:P6108', 'wdt:P3931', 'wdt:P4380', 'wdt:P675', 'wdt:P109', 'wdt:P1028', 'wdt:P6002', 'wdt:P3893', 'wdt:P859', 'wdt:P1449', 'wdt:P18', 'wdt:P2610', 'wdt:P1071', 'wdt:P135', 'wdt:P4373', 'wdt:P6625', 'wdt:P6375', 'wdt:P3855', 'wdt:P214', 'wdt:P969', 'wdt:P941', 'wdt:P2511', 'wdt:P170', 'wdt:P2386', 'wdt:P551', 'wdt:P1889', 'wdt:P6573', 'wdt:P3504', 'wdt:P1207', 'wdt:P1259', 'wdt:P213', 'wdt:P888', 'wdt:P625', 'wdt:P2014', 'wdt:P131', 'wdt:P1545', 'wdt:P4905', 'wdt:P6058', 'wdt:P973', 'wdt:P4659', 'wdt:P1726', 'wdt:P1679', 'wdt:P6246', 'wdt:P462', 'wdt:P1684', 'wdt:P949', 'wdt:P1296', 'wdt:P156', 'wdt:P989', 'wdt:P189', 'wdt:P1476', 'wdt:P571', 'wdt:P6489', 'wdt:P5008', 'wdt:P5891', 'wdt:P641', 'wdt:P61', 'wdt:P4611', 'wdt:P1375', 'wdt:P6482', 'wdt:P366', 'wdt:P244', 'wdt:P180', 'wdt:P6152', 'wdt:P5905', 'wdt:P3417', 'wdt:P136', 'wdt:P527', 'wdt:P268', 'wdt:P1448', 'wdt:P140', 'wdt:P4712', 'wdt:P6606', 'wdt:P460', 'wdt:P4610', 'wdt:P2634', 'wdt:P4625', 'wdt:P1435', 'wdt:P4692', 'wdt:P350', 'wdt:P2282', 'wdt:P2348', 'wdt:P4839', 'wdt:P7229', 'wdt:P21', 'wdt:P4737', 'wdt:P4673', 'wdt:P349', 'wdt:P3424', 'wdt:P4674', 'wdt:P5816', 'wdt:P6323', 'wdt:P6216', 'wdt:P4969', 'wdt:P1419', 'wdt:P6301', 'wdt:P17', 'wdt:P2581', 'wdt:P5407', 'wdt:P4683', 'wdt:P2242', 'wdt:P227', 'wdt:P2539', 'wdt:P2582', 'wdt:P144', 'wdt:P3272', 'wdt:P6332', 'wdt:P1441', 'wdt:P3827', 'wdt:P4761', 'wdt:P577', 'wdt:P495', 'wdt:P2079', 'wdt:P937', 'wdt:P1639', 'wdt:P6663', 'wdt:P2048', 'wdt:P3293', 'wdt:P381', 'wdt:P4684', 'wdt:P7420', 'wdt:P31', 'wdt:P1695', 'wdt:P2001', 'wdt:P910', 'wdt:P856', 'wdt:P50', 'wdt:P2043', 'wdt:P6610', 'wdt:P805', 'wdt:P921', 'wdt:P179', 'wdt:P1257', 'wdt:P217', 'wdt:P3783', 'wdt:P373', 'wdt:P7457', 'wdt:P269', 'wdt:P3929', 'wdt:P2108', 'wdt:P2888', 'wdt:P5823', 'wdt:P737', 'wdt:P409', 'wdt:P275', 'wdt:P1896', 'wdt:P5499', 'wdt:P195', 'wdt:P361', 'wdt:P825', 'wdt:P1417', 'wdt:P443', 'wdt:P4643', 'wdt:P4701', 'wdt:P576', 'wdt:P127', 'wdt:P347', 'wdt:P608', 'wdt:P4144', 'wdt:P276', 'wdt:P1814', 'wdt:P6595', 'wdt:P6355', 'wdt:P1184', 'wdt:P3634', 'wdt:P740', 'wdt:P2049', 'wdt:P972', 'wdt:P727', 'wdt:P585', 'wdt:P1212', 'wdt:P935', 'wdt:P3222', 'wdt:P2913', 'wdt:P1256', 'wdt:P5070', 'wdt:P1343', 'wdt:P6500', 'wdt:P6576', 'wdt:P793', 'wdt:P691', 'wdt:P2635', 'wdt:P6007', 'wdt:P1299', 'wdt:P481']\n"
     ]
    }
   ],
   "source": [
    "def get_properties(entity):\n",
    "    propertylist = []\n",
    "    try:\n",
    "        propertylist.extend(get_property_suggestions(entity))\n",
    "        propertylist.extend(get_currently_used_properties(entity))\n",
    "    except Exception as e:\n",
    "        print(e)\n",
    "        pass\n",
    "    return list(set(propertylist))\n",
    "\n",
    "print(get_properties(\"Q3305213\"))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Q3305213, wdt:P6606, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P7420, http://wikiba.se/ontology#CommonsMedia\n",
      "Q3305213, wdt:P7457, http://wikiba.se/ontology#CommonsMedia\n",
      "Q3305213, wdt:P6595, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P6610, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P6625, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P6663, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P7229, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P275, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P276, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P361, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P366, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P460, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P462, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P495, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P527, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P551, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P608, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P641, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P737, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P740, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P793, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P805, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P825, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P840, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P859, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P910, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P921, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P937, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P941, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P972, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P1028, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P1071, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P1269, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P1299, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P1343, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P1419, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P1435, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P1441, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P17, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P21, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P31, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P50, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P61, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P88, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P127, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P131, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P135, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P136, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P138, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P140, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P144, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P156, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P170, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P179, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P180, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P186, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P189, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P195, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P443, http://wikiba.se/ontology#CommonsMedia\n",
      "Q3305213, wdt:P989, http://wikiba.se/ontology#CommonsMedia\n",
      "Q3305213, wdt:P18, http://wikiba.se/ontology#CommonsMedia\n",
      "Q3305213, wdt:P109, http://wikiba.se/ontology#CommonsMedia\n",
      "Q3305213, wdt:P269, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P268, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P347, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P349, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P350, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P373, http://wikiba.se/ontology#String\n",
      "Q3305213, wdt:P381, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P409, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P481, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P508, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P528, http://wikiba.se/ontology#String\n",
      "Q3305213, wdt:P646, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P675, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P691, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P727, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P888, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P935, http://wikiba.se/ontology#String\n",
      "Q3305213, wdt:P949, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P969, http://wikiba.se/ontology#String\n",
      "Q3305213, wdt:P1184, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P1207, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P1212, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P1257, http://wikiba.se/ontology#String\n",
      "Q3305213, wdt:P1256, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P1296, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P1375, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P1417, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P1545, http://wikiba.se/ontology#String\n",
      "Q3305213, wdt:P1566, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P213, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P214, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P217, http://wikiba.se/ontology#String\n",
      "Q3305213, wdt:P227, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P244, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P571, http://wikiba.se/ontology#Time\n",
      "Q3305213, wdt:P577, http://wikiba.se/ontology#Time\n",
      "Q3305213, wdt:P576, http://wikiba.se/ontology#Time\n",
      "Q3305213, wdt:P585, http://wikiba.se/ontology#Time\n",
      "Q3305213, wdt:P1449, http://wikiba.se/ontology#Monolingualtext\n",
      "Q3305213, wdt:P1448, http://wikiba.se/ontology#Monolingualtext\n",
      "Q3305213, wdt:P1476, http://wikiba.se/ontology#Monolingualtext\n",
      "Q3305213, wdt:P856, http://wikiba.se/ontology#Url\n",
      "Q3305213, wdt:P973, http://wikiba.se/ontology#Url\n",
      "Q3305213, wdt:P625, http://wikiba.se/ontology#GlobeCoordinate\n",
      "Q3305213, wdt:P1259, http://wikiba.se/ontology#GlobeCoordinate\n",
      "Q3305213, wdt:P1639, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P1889, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P2079, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P2348, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P2634, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P3931, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P4969, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P5008, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P5070, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P5816, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P6216, http://wikiba.se/ontology#WikibaseItem\n",
      "Q3305213, wdt:P1669, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P1679, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P1695, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P1726, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P1814, http://wikiba.se/ontology#String\n",
      "Q3305213, wdt:P2001, http://wikiba.se/ontology#String\n",
      "Q3305213, wdt:P2014, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P2092, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P2108, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P2242, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P2282, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P2344, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P2511, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P2539, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P2581, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P2582, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P3219, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P3222, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P3272, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P3293, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P3417, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P3424, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P3504, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P3634, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P3783, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P3827, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P3855, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P3929, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P4144, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P4178, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P4373, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P4380, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P4582, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P4611, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P4610, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P4625, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P4643, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P4659, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P4673, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P4674, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P4683, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P4684, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P4692, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P4701, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P4712, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P4737, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P4761, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P4839, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P4905, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P5407, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P5499, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P5823, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P5891, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P5905, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P6002, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P6007, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P6020, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P6058, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P6152, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P6246, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P6301, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P6323, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P6332, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P6355, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P6358, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P6372, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P6405, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P6482, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P6489, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P6573, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P6576, http://wikiba.se/ontology#ExternalId\n",
      "Q3305213, wdt:P2043, http://wikiba.se/ontology#Quantity\n",
      "Q3305213, wdt:P2049, http://wikiba.se/ontology#Quantity\n",
      "Q3305213, wdt:P2048, http://wikiba.se/ontology#Quantity\n",
      "Q3305213, wdt:P2284, http://wikiba.se/ontology#Quantity\n",
      "Q3305213, wdt:P2386, http://wikiba.se/ontology#Quantity\n",
      "Q3305213, wdt:P2610, http://wikiba.se/ontology#Quantity\n",
      "Q3305213, wdt:P2635, http://wikiba.se/ontology#Quantity\n",
      "Q3305213, wdt:P4511, http://wikiba.se/ontology#Quantity\n",
      "Q3305213, wdt:P2913, http://wikiba.se/ontology#Time\n",
      "Q3305213, wdt:P3893, http://wikiba.se/ontology#Time\n",
      "Q3305213, wdt:P1684, http://wikiba.se/ontology#Monolingualtext\n",
      "Q3305213, wdt:P1705, http://wikiba.se/ontology#Monolingualtext\n",
      "Q3305213, wdt:P2441, http://wikiba.se/ontology#Monolingualtext\n",
      "Q3305213, wdt:P6375, http://wikiba.se/ontology#Monolingualtext\n",
      "Q3305213, wdt:P1896, http://wikiba.se/ontology#Url\n",
      "Q3305213, wdt:P2888, http://wikiba.se/ontology#Url\n",
      "Q3305213, wdt:P6108, http://wikiba.se/ontology#Url\n",
      "Q3305213, wdt:P6500, http://wikiba.se/ontology#Url\n"
     ]
    }
   ],
   "source": [
    "def get_property_datatype(entityid):\n",
    "    csvresult =[]\n",
    "    propertylist = get_properties(entityid)\n",
    "    propertyliststr = ' '.join(propertylist) \n",
    "    query = \"\"\"\n",
    "    SELECT DISTINCT (\"entityid\" as ?entity) ?property ?datatype\n",
    "    {\n",
    "       VALUES ?prop {propertylist}.\n",
    "       ?property wikibase:directClaim ?prop;\n",
    "            wikibase:propertyType ?datatype.\n",
    "    }\"\"\"\n",
    "    \n",
    "    baseurl = \"https://query.wikidata.org/sparql?query=\"\n",
    "    formatstr = \"&format=json\"\n",
    "\n",
    "    query = query.replace(\"entityid\", entityid)\n",
    "    query = query.replace(\"propertylist\", propertyliststr)\n",
    "    url = baseurl+quote(query)+formatstr\n",
    "    response = requests.get(url)\n",
    "    if(response.status_code == 200):\n",
    "        results = response.json()\n",
    "        for result in results[\"results\"][\"bindings\"]:\n",
    "            csvresult.append(result[\"entity\"][\"value\"]+ \", \" +\n",
    "                   result[\"property\"][\"value\"].replace(\"http://www.wikidata.org/entity/\", \"wdt:\")+ \", \" +\n",
    "                   result[\"datatype\"][\"value\"])\n",
    "    return(csvresult)\n",
    "        \n",
    "print('\\n'.join(get_property_datatype(\"Q3305213\")))"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.9"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}