{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "268e8bcb",
   "metadata": {},
   "source": [
    "Check SPA for pictures of people related to Johan Emanuel Wikström\n",
    "* this [Notebook](https://github.com/salgo60/spa2Commons/blob/main/Notebook/SPA%20Johan%20Emanuel%20Wikström.ipynb) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "e51f45a1",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Last run:  2021-10-23 02:52:04.812209\n"
     ]
    }
   ],
   "source": [
    "from datetime import datetime\n",
    "start_time  = datetime.now()\n",
    "print(\"Last run: \", start_time)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "76115073",
   "metadata": {},
   "outputs": [],
   "source": [
    "import urllib3, json\n",
    "import pandas as pd \n",
    "http = urllib3.PoolManager() \n",
    "\n",
    "url= \"https://portrattarkiv.se/endpoints/search.php\" "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "24f21a07",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 28 entries, 0 to 27\n",
      "Data columns (total 5 columns):\n",
      " #   Column     Non-Null Count  Dtype \n",
      "---  ------     --------------  ----- \n",
      " 0   search     28 non-null     object\n",
      " 1   item       28 non-null     object\n",
      " 2   itemLabel  28 non-null     object\n",
      " 3   born       28 non-null     object\n",
      " 4   year       28 non-null     object\n",
      "dtypes: object(5)\n",
      "memory usage: 1.2+ KB\n"
     ]
    }
   ],
   "source": [
    "from IPython.display import HTML, Image\n",
    "import sys\n",
    "from SPARQLWrapper import SPARQLWrapper, JSON\n",
    "\n",
    "endpoint_url = \"https://query.wikidata.org/sparql\"\n",
    "\n",
    "queryJohan = \"\"\"PREFIX gas: <http://www.bigdata.com/rdf/gas#>\n",
    "\n",
    "SELECT distinct (CONCAT (?itemLabel,\" \",str(year(?born))) AS ?search) ?item ?itemLabel ?born  \n",
    " (str(year(?born)) AS ?year) {\n",
    "  SERVICE gas:service {\n",
    "    gas:program gas:gasClass \"com.bigdata.rdf.graph.analytics.SSSP\" ;\n",
    "                gas:in wd:Q20720200 ;\n",
    "                gas:traversalDirection \"Undirected\" ;\n",
    "                gas:out ?item ;\n",
    "                gas:out1 ?depth ;\n",
    "                gas:maxIterations 4 ;\n",
    "                gas:linkType wdt:P40 .\n",
    "  }\n",
    "  ?item wdt:P27 wd:Q34\n",
    "  OPTIONAL { ?item wdt:P569 ?born }\n",
    "  OPTIONAL { ?item wdt:P40 ?linkTo }\n",
    "  OPTIONAL { ?item wdt:P18 ?pic }\n",
    "  SERVICE wikibase:label {bd:serviceParam wikibase:language \"sv,en\" }\n",
    "  FILTER ( YEAR(?born) < 1880) # born before 1880\n",
    "\n",
    "} group by ?item ?itemLabel ?born\n",
    "order by ?itemLabel \"\"\"\n",
    "\n",
    "def get_sparql_dataframe(endpoint_url, query):\n",
    "    \"\"\"\n",
    "    Helper function to convert SPARQL results into a Pandas data frame.\n",
    "    \"\"\"\n",
    "    user_agent = \"salgo60/%s.%s\" % (sys.version_info[0], sys.version_info[1])\n",
    " \n",
    "    sparql = SPARQLWrapper(endpoint_url, agent=user_agent)\n",
    "    sparql.setQuery(query)\n",
    "    sparql.setReturnFormat(JSON)\n",
    "    result = sparql.query()\n",
    "\n",
    "    processed_results = json.load(result.response)\n",
    "    cols = processed_results['head']['vars']\n",
    "\n",
    "    out = []\n",
    "    for row in processed_results['results']['bindings']:\n",
    "        item = []\n",
    "        for c in cols:\n",
    "            item.append(row.get(c, {}).get('value'))\n",
    "        out.append(item)\n",
    "\n",
    "    return pd.DataFrame(out, columns=cols)\n",
    "\n",
    "#SPAdf = get_sparql_dataframe(endpoint_url, query)\n",
    "SPAdf = get_sparql_dataframe(endpoint_url, queryJohan)\n",
    "\n",
    "SPAdf.info()   "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "a87ff865",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      " Johanna Näslund 1838 http://www.wikidata.org/entity/Q108264383\n",
      "\t\t 15.370123 Anders   Almquist  -  1838 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAA3smg \t\n",
      "\t\t 15.2288265 Gustaf   Askergren  -  1838 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAA4JPA \t\n",
      "\t\t 15.2288265 Oskar   Appelberg  -  1838 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAA38hA \t\n",
      "\t\t 15.065046 Hanna   Ouchterlony  -  1838 https://portrattarkiv.se/details/vfWYdYT6EoAAAAAAAAAvQg \t\n",
      "\t\t 14.95533 Alexander   Roth  -  1838 https://portrattarkiv.se/details/9Y5iReTPHdAAAAAAAAAkGw \t\n",
      "\t\t 14.79955 Ernst   Schoug  -  1838 https://portrattarkiv.se/details/YB0QHyfj0hAAAAAAAABkpA \t\n",
      "\t\t 14.737883 Carl   Frisk  -  1838 https://portrattarkiv.se/details/IQojCnw0WmAAAAAAAAA1zg \t\n",
      "\t\t 14.72971 Johan   Hafström  -  1838 https://portrattarkiv.se/details/j6S8rJvx9lAAAAAAAAAFoA \t\n",
      "\t\t 14.724401 Christian   Bratt  -  1838 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAA3pCQ \t\n",
      "\t\t 14.085737 Nils   Ödman  -  1838 https://portrattarkiv.se/details/ai4MrcHN22AAAAAAAAADKQ \t\n",
      "\n",
      " Anton Julius Winblad I 1828 http://www.wikidata.org/entity/Q20667111\n",
      "\t\t 22.189232 Julius   Mankell  -  1828 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABL0Cw \t\n",
      "\t\t 21.96016 Julius   Mankell  -  1828 https://portrattarkiv.se/details/seuNpYu6DKAAAAAAAABigw \t\n",
      "\t\t 19.646513 Julius   Mankell  -  1828 https://portrattarkiv.se/details/I_2wtd5VefAAAAAAAAASVQ \t\n",
      "\t\t 19.490383 Julius   Mankell  -  1828 https://portrattarkiv.se/details/I_2wtd5VefAAAAAAAAASWQ \t\n",
      "\t\t 19.4891 Julius   Mankell  -  1828 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABGctQ \t\n",
      "\t\t 19.455729 julius   Mankell  -  1828 https://portrattarkiv.se/details/I_2wtd5VefAAAAAAAAASVw \t\n",
      "\t\t 19.24873 Malcolm   Lilliehöök  -  1828 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABK5RA \t\n",
      "\t\t 19.079506 Julius   Mankell  -  1828 https://portrattarkiv.se/details/I_2wtd5VefAAAAAAAAASWg \t\n",
      "\t\t 19.054022 Julius   Mankell  -  1828 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAB2V3w \t\n",
      "\t\t 18.751703 Malcolm   Lilliehöök  -  1828 https://portrattarkiv.se/details/rkIpfGqHXrAAAAAAAADfsw \t\n",
      "\n",
      " Anton Wahlberg 1878 http://www.wikidata.org/entity/Q20652937\n",
      "\t\t 30.38875 Anton   Wahlberg  -  1878 https://portrattarkiv.se/details/ciLMGSqrYjAAAAAAAAALDA \t\n",
      "\t\t 27.166838 Anton   Wahlberg  -  1878 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABGqqQ \t\n",
      "\t\t 20.75063 Nils   Wahlberg  -  1878 https://portrattarkiv.se/details/ciLMGSqrYjAAAAAAAAAL4g \t\n",
      "\t\t 19.717001 Carl   Wahlberg  -  1878 https://portrattarkiv.se/details/ciLMGSqrYjAAAAAAAAAMeg \t\n",
      "\t\t 19.368877 Erik   Wahlberg  -  1878 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABHfWQ \t\n",
      "\t\t 19.274412 Alrik   Wahlberg  -  1878 https://portrattarkiv.se/details/ciLMGSqrYjAAAAAAAAALFg \t\n",
      "\t\t 19.203976 Erik   Wahlberg  -  1878 https://portrattarkiv.se/details/ciLMGSqrYjAAAAAAAABhkg \t\n",
      "\t\t 18.888935 Carl   Wahlberg  -  1878 https://portrattarkiv.se/details/ciLMGSqrYjAAAAAAAAAMew \t\n",
      "\t\t 18.844551 Erik   Wahlberg  -  1878 https://portrattarkiv.se/details/ciLMGSqrYjAAAAAAAAAMWQ \t\n",
      "\t\t 18.669342 Nils   Wahlberg  -  1878 https://portrattarkiv.se/details/ciLMGSqrYjAAAAAAAAAL4Q \t\n",
      "\n",
      " Antonette Kristina Winblad II 1854 http://www.wikidata.org/entity/Q84323221\n",
      "\t\t 16.717922 Klara Kristina   Lind-Söderblom  -  1854 https://portrattarkiv.se/details/rkIpfGqHXrAAAAAAAAHuzw \t\n",
      "\t\t 16.512701 Kristina   Fredrikson  -  1854 https://portrattarkiv.se/details/IQojCnw0WmAAAAAAAABTSQ \t\n",
      "\t\t 15.33651 Erik   Rosengren  -  1854 https://portrattarkiv.se/details/9Y5iReTPHdAAAAAAAAAgwA \t\n",
      "\t\t 15.226885 Woldemar   von Rosen  -  1854 https://portrattarkiv.se/details/9Y5iReTPHdAAAAAAAAAeDw \t\n",
      "\t\t 15.180637 J P   Hedberg  -  1854 https://portrattarkiv.se/details/j6S8rJvx9lAAAAAAAAAyTw \t\n",
      "\t\t 15.156429 Sven   Palme  -  1854 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABNVCg \t\n",
      "\t\t 15.151636 Oskar   Brattlund  -  1854 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAB4pkA \t\n",
      "\t\t 15.138969 Charlotta   Öberg  -  1854 https://portrattarkiv.se/details/ai4MrcHN22AAAAAAAAAAog \t\n",
      "\t\t 15.138697 Charlotta   Öberg  -  1854 https://portrattarkiv.se/details/ai4MrcHN22AAAAAAAAAAow \t\n",
      "\t\t 15.112734 Charlotta   Öberg  -  1854 https://portrattarkiv.se/details/ai4MrcHN22AAAAAAAAAAoQ \t\n",
      "\n",
      " Brita Christina Öknaberg 1799 http://www.wikidata.org/entity/Q86513219\n",
      "\t\t 18.746346 Nils   Almlöf  -  1799 https://portrattarkiv.se/details/seuNpYu6DKAAAAAAAABhRQ \t\n",
      "\t\t 18.458027 Per   Bylund  -  1799 https://portrattarkiv.se/details/4e1scVvZ-EAAAAAAAAATjA \t\n",
      "\t\t 15.630488 Carl   Rylander  -  1799 https://portrattarkiv.se/details/9Y5iReTPHdAAAAAAAABB7Q \t\n",
      "\t\t 15.605705 Carl   Adlercreutz  -  1799 https://portrattarkiv.se/details/5TJc-sPXaKAAAAAAAABaBg \t\n",
      "\t\t 15.40665 Nils   Almlöf  -  1799 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAA3spg \t\n",
      "\t\t 15.308294 Nils   Almlöf  -  1799 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABKEaQ \t\n",
      "\t\t 15.240092 Nils   Almlöf  -  1799 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABKEag \t\n",
      "\t\t 15.21402 Nils   Almlöf  -  1799 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAA4G6Q \t\n",
      "\t\t 15.19764 Axel   Ehrenpohl  -  1799 https://portrattarkiv.se/details/TR3yO_GV8eAAAAAAAACALg \t\n",
      "\t\t 15.195276 Carl   Adlercreutz  -  1799 https://portrattarkiv.se/details/5TJc-sPXaKAAAAAAAABaBQ \t\n",
      "\n",
      " Carl Gustaf Näslund 1825 http://www.wikidata.org/entity/Q20664308\n",
      "\t\t 34.278454 Carl Gustaf   Näslund  -  1825 https://portrattarkiv.se/details/wbbNj8LLWMAAAAAAAACBfQ \t\n",
      "\t\t 21.753017 Carl   Kruse  -  1825 https://portrattarkiv.se/details/0piq-fX0h5AAAAAAAABHmw \t\n",
      "\t\t 21.1704 Carl   Strandberg  -  1825 https://portrattarkiv.se/details/seuNpYu6DKAAAAAAAABlQQ \t\n",
      "\t\t 21.0987 Carl   DeLaGardie  -  1825 https://portrattarkiv.se/details/_P7S9YzQCjAAAAAAAAAqdA \t\n",
      "\t\t 21.032475 Carl   DeLaGardie  -  1825 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABLXhA \t\n",
      "\t\t 20.938564 Carl   DeLaGardie  -  1825 https://portrattarkiv.se/details/_P7S9YzQCjAAAAAAAAAqsA \t\n",
      "\t\t 20.879755 Gustaf   Fris  -  1825 https://portrattarkiv.se/details/IQojCnw0WmAAAAAAAAA0wQ \t\n",
      "\t\t 20.79259 Carl   DeLaGardie  -  1825 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABLXgw \t\n",
      "\t\t 20.054157 Carl   Norén  -  1825 https://portrattarkiv.se/details/wbbNj8LLWMAAAAAAAABEmg \t\n",
      "\t\t 19.137804 Gustaf   Fris  -  1825 https://portrattarkiv.se/details/IQojCnw0WmAAAAAAAAA0wg \t\n",
      "\n",
      " Catharina Maria Martinell 1773 http://www.wikidata.org/entity/Q63302217\n",
      "\t\t 20.35833 Elsa Maria   Munch  -  1773 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAACbjsA \t\n",
      "\t\t 17.499 Carl   Crælius  -  1773 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABTEpA \t\n",
      "\t\t 16.952057 Gustaf   Trolle-Bonde  -  1773 https://portrattarkiv.se/details/NhqpvvI9tpAAAAAAAAAyYg \t\n",
      "\t\t 16.69432 A G   Mörner  -  1773 https://portrattarkiv.se/details/5TJc-sPXaKAAAAAAAAAm9Q \t\n",
      "\t\t 16.655075 Gustaf   Stiernstam  -  1773 https://portrattarkiv.se/details/YB0QHyfj0hAAAAAAAADNNQ \t\n",
      "\t\t 16.515675 Gustaf   Trolle-Bonde  -  1773 https://portrattarkiv.se/details/5TJc-sPXaKAAAAAAAAAnpg \t\n",
      "\t\t 16.36406 Maria   Ehrenström  -  1773 https://portrattarkiv.se/details/TR3yO_GV8eAAAAAAAACEew \t\n",
      "\t\t 16.359188 Maria   Ehrenström  -  1773 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABWCKg \t\n",
      "\t\t 16.285982 Olof   von Feilitzen  -  1773 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABLd7A \t\n",
      "\t\t 16.133175 Niclas   Vong  -  1773 https://portrattarkiv.se/details/88fEYD5OMjAAAAAAAAAHjA \t\n",
      "\n",
      " Elsa Maria Elisabet Näslund 1829 http://www.wikidata.org/entity/Q25905894\n",
      "\t\t 19.038773 Carl   Wallstersson  -  1829 https://portrattarkiv.se/details/ciLMGSqrYjAAAAAAAABTuQ \t\n",
      "\t\t 16.096191 Robert   Nobel  -  1829 https://portrattarkiv.se/details/seuNpYu6DKAAAAAAAABg7w \t\n",
      "\t\t 15.671937    Farup-Staaff  -  1829 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABOlNQ \t\n",
      "\t\t 15.659228 Erica   Farup-Staaff  -  1829 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABOlxw \t\n",
      "\t\t 15.343634 Nils   Djurklou  -  1829 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAB2_Ew \t\n",
      "\t\t 15.125151 François   Westerdahl  -  1829 https://portrattarkiv.se/details/ciLMGSqrYjAAAAAAAABTgg \t\n",
      "\t\t 15.085899 Fredrik   Hazelius  -  1829 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABKqjg \t\n",
      "\t\t 15.07152 Adolf   Magnét  -  1829 https://portrattarkiv.se/details/I_2wtd5VefAAAAAAAAADhQ \t\n",
      "\t\t 14.382444 Carl   Hedstrand  -  1829 https://portrattarkiv.se/details/j6S8rJvx9lAAAAAAAAA93Q \t\n",
      "\t\t 14.251584 Axel   Janson  -  1829 https://portrattarkiv.se/details/Di4a42b6X_AAAAAAAABh0Q \t\n",
      "\n",
      " Erik Johan Örbom 1724 http://www.wikidata.org/entity/Q34850319\n",
      "\t\t 22.820534 Erik   af Sotberg  -  1724 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABh12A \t\n",
      "\t\t 21.545029 Erik   Lidbeck  -  1724 https://portrattarkiv.se/details/WQknIBFpuuAAAAAAAAN7jQ \t\n",
      "\t\t 20.653145 Johan   Wrangel  -  1724 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABKlJw \t\n",
      "\t\t 20.642357 Johan   Wrangel  -  1724 https://portrattarkiv.se/details/ciLMGSqrYjAAAAAAAABhqA \t\n",
      "\t\t 19.982222 Johan   Kuylenstierna  -  1724 https://portrattarkiv.se/details/mLh5P0pzYFAAAAAAAAAvYA \t\n",
      "\t\t 18.77584 F   Wagenfelt  -  1724 https://portrattarkiv.se/details/s04jCnobu5AAAAAAAAAEKQ \t\n",
      "\t\t 18.674234 B   Ferrner  -  1724 https://portrattarkiv.se/details/5TJc-sPXaKAAAAAAAAAnZA \t\n",
      "\t\t 18.63219 Eric   Lidbeck  -  1724 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABzpTg \t\n",
      "\t\t 18.47138 Ulrica   Strömfelt  -  1724 https://portrattarkiv.se/details/YB0QHyfj0hAAAAAAAADliQ \t\n",
      "\t\t 18.286026 Johan   Wahlbom  -  1724 https://portrattarkiv.se/details/WQknIBFpuuAAAAAAAAN1Gg \t\n",
      "\n",
      " Frideborg Winblad 1869 http://www.wikidata.org/entity/Q5503563\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\t\t 21.263405 Frideborg   Danell-Beckman  -  1869 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAACZp6A \t\n",
      "\t\t 16.903456 Hedvig   Skarstedt  -  1869 https://portrattarkiv.se/details/YB0QHyfj0hAAAAAAAACnPQ \t\n",
      "\t\t 16.520412 Hedvig   Skarstedt  -  1869 https://portrattarkiv.se/details/YB0QHyfj0hAAAAAAAACnPg \t\n",
      "\t\t 14.765091 John   Tjerneld  -  1869 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABNq3w \t\n",
      "\t\t 14.738942 John   Tjerneld  -  1869 https://portrattarkiv.se/details/NhqpvvI9tpAAAAAAAAA1dg \t\n",
      "\t\t 10.175696 Ewert   Jonsson  -  1869 https://portrattarkiv.se/details/Di4a42b6X_AAAAAAAACIAw \t\n",
      "\t\t 9.577807 Elisabet   Tingvall  -  1869 https://portrattarkiv.se/details/NhqpvvI9tpAAAAAAAAAbDA \t\n",
      "\t\t 9.564344 Erik Natanael   Söderberg  -  1869 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAACd0Fw \t\n",
      "\t\t 9.562848 Theodor   Andersson  -  1869 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAA5x3g \t\n",
      "\t\t 9.523809 Dagny   Bergling  -  1869 https://portrattarkiv.se/details/TNQaWo324IAAAAAAAAC-9g \t\n",
      "\n",
      " Helena Gustafsdotter Ruuth 1729 http://www.wikidata.org/entity/Q81086857\n",
      "\t\t 19.19508 Katarina   af-Ryssland  -  1729 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAB5W2Q \t\n",
      "\t\t 18.987228 J   Björnstjerna  -  1729 https://portrattarkiv.se/details/TNQaWo324IAAAAAAAADveg \t\n",
      "\t\t 18.222078 Gustaf Filip   Creutz  -  1729 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAB5rww \t\n",
      "\t\t 17.909615 J   Björnstjerna  -  1729 https://portrattarkiv.se/details/5TJc-sPXaKAAAAAAAAAnUw \t\n",
      "\t\t 17.865646 P   Lilliehorn  -  1729 https://portrattarkiv.se/details/rkIpfGqHXrAAAAAAAADYNA \t\n",
      "\t\t 17.202557 P   Lilliehorn  -  1729 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABLJhQ \t\n",
      "\t\t 17.164675 Johan   Munthe  -  1729 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAB2VmA \t\n",
      "\t\t 16.245804 Carl   DeLaval  -  1729 https://portrattarkiv.se/details/_P7S9YzQCjAAAAAAAAAr4A \t\n",
      "\t\t 16.245804 Carl   DeLaval  -  1729 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABLYaQ \t\n",
      "\t\t 15.811052 Johan   Beck-Friis  -  1729 https://portrattarkiv.se/details/TNQaWo324IAAAAAAAACf_A \t\n",
      "\n",
      " Israel Israelsson Näslund 1796 http://www.wikidata.org/entity/Q20816949\n",
      "\t\t 20.007923 Israel   Tauvon  -  1796 https://portrattarkiv.se/details/NhqpvvI9tpAAAAAAAAA3eQ \t\n",
      "\t\t 19.733505 Israel   Tauvon  -  1796 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABTEnA \t\n",
      "\t\t 15.6869 Olof   Fåhræus  -  1796 https://portrattarkiv.se/details/IQojCnw0WmAAAAAAAABKvA \t\n",
      "\t\t 15.424386 Axel   Belfrage  -  1796 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABKjEg \t\n",
      "\t\t 15.392511 Bernhard   von Beskow  -  1796 https://portrattarkiv.se/details/5TJc-sPXaKAAAAAAAAAntA \t\n",
      "\t\t 15.258127 Olof   Fåhraeus  -  1796 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABZLeQ \t\n",
      "\t\t 15.182649 Carl   Zamore  -  1796 https://portrattarkiv.se/details/gLW7tk5fn-AAAAAAAAABpA \t\n",
      "\t\t 15.182649 Axel   Lewenhaupt  -  1796 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABLEdA \t\n",
      "\t\t 15.137927 Franz   Berwald  -  1796 https://portrattarkiv.se/details/seuNpYu6DKAAAAAAAABh-Q \t\n",
      "\t\t 15.129234 Axel   Lewenhaupt  -  1796 https://portrattarkiv.se/details/rkIpfGqHXrAAAAAAAADfHQ \t\n",
      "\n",
      " Israel Israelsson Näslund IV 1823 http://www.wikidata.org/entity/Q81559062\n",
      "\t\t 19.856012 Lars   Wadner  -  1823 https://portrattarkiv.se/details/ciLMGSqrYjAAAAAAAABmwQ \t\n",
      "\t\t 19.663342 Lars   Wadner  -  1823 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABNoAw \t\n",
      "\t\t 14.887347 Johan   Borelius  -  1823 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABlZbQ \t\n",
      "\t\t 13.188627 Lars   Olsson  -  1823 https://portrattarkiv.se/details/vfWYdYT6EoAAAAAAAAAV7w \t\n",
      "\t\t 13.052517 Hanna   Lindberg  -  1823 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAB4fgA \t\n",
      "\t\t 13.045225 Herman   Hofberg  -  1823 https://portrattarkiv.se/details/j6S8rJvx9lAAAAAAAACyfA \t\n",
      "\t\t 12.967298 Alfred   Forsström  -  1823 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABKnmQ \t\n",
      "\t\t 12.949592 Herman   Hofberg  -  1823 https://portrattarkiv.se/details/seuNpYu6DKAAAAAAAABiiA \t\n",
      "\t\t 12.949098 Anders   Hedenström  -  1823 https://portrattarkiv.se/details/j6S8rJvx9lAAAAAAAAA1cA \t\n",
      "\t\t 12.921954 Per   Ahlberg  -  1823 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABHQuQ \t\n",
      "\n",
      " Johan Christopher Ruuth I 1767 http://www.wikidata.org/entity/Q50346736\n",
      "\t\t 19.898056 Johan   Aminoff  -  1767 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABKgSw \t\n",
      "\t\t 19.119518 Johan   Aminoff  -  1767 https://portrattarkiv.se/details/28K7pO-SRrAAAAAAAAClRQ \t\n",
      "\t\t 17.703604 Nils   Sjöborg  -  1767 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAB2WsQ \t\n",
      "\t\t 17.000698 Carl   Deleen  -  1767 https://portrattarkiv.se/details/4e1scVvZ-EAAAAAAAAAQKQ \t\n",
      "\t\t 16.824226 Lars   Camin  -  1767 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAA7PCA \t\n",
      "\t\t 16.633839 V   Faxe  -  1767 https://portrattarkiv.se/details/IQojCnw0WmAAAAAAAABKyQ \t\n",
      "\t\t 16.626871 V   Faxe  -  1767 https://portrattarkiv.se/details/5TJc-sPXaKAAAAAAAAAm8Q \t\n",
      "\t\t 16.444212 Wilhelm   Faxe  -  1767 https://portrattarkiv.se/details/IQojCnw0WmAAAAAAAABSDA \t\n",
      "\t\t 16.264847 Corfitz   Beck-Friis  -  1767 https://portrattarkiv.se/details/TNQaWo324IAAAAAAAADruw \t\n",
      "\t\t 16.242386 Benjamin Carl Henrik   Höijer  -  1767 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAB5r2w \t\n",
      "\n",
      " Johan Christopher Ruuth II 1823 http://www.wikidata.org/entity/Q50349249\n",
      "\t\t 27.377632 Johan   Ruuth  -  1823 https://portrattarkiv.se/details/9Y5iReTPHdAAAAAAAAArsw \t\n",
      "\t\t 17.410984 Johan   Holm  -  1823 https://portrattarkiv.se/details/mLh5P0pzYFAAAAAAAAAnkQ \t\n",
      "\t\t 17.241077 Johan   Arnqvist  -  1823 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABKiZQ \t\n",
      "\t\t 17.241077 Johan   Arnqvist  -  1823 https://portrattarkiv.se/details/28K7pO-SRrAAAAAAAACi1Q \t\n",
      "\t\t 17.241077 Johan   Arnqvist  -  1823 https://portrattarkiv.se/details/28K7pO-SRrAAAAAAAACjCA \t\n",
      "\t\t 17.215744 Johan   Hasselgren  -  1823 https://portrattarkiv.se/details/j6S8rJvx9lAAAAAAAAArzA \t\n",
      "\t\t 17.179375 Johan   Arnqvist  -  1823 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABKiZA \t\n",
      "\t\t 17.179375 Johan   Arnqvist  -  1823 https://portrattarkiv.se/details/28K7pO-SRrAAAAAAAACi9A \t\n",
      "\t\t 17.148874 Johan   Arnqvist  -  1823 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABKiZg \t\n",
      "\t\t 16.985954 Johan   Settergren  -  1823 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABMLHw \t\n",
      "\n",
      " Johan Israel Näslund 1822 http://www.wikidata.org/entity/Q42418078\n",
      "\t\t 25.683128 Johan   Næslund  -  1822 https://portrattarkiv.se/details/wbbNj8LLWMAAAAAAAABdMQ \t\n",
      "\t\t 17.9423 Johan Tycho   Ekström  -  1822 https://portrattarkiv.se/details/TR3yO_GV8eAAAAAAAAB3uA \t\n",
      "\t\t 17.612627 Johan Erik   Nyström  -  1822 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAACcZ2Q \t\n",
      "\t\t 17.602156 Karl Johan   Runer  -  1822 https://portrattarkiv.se/details/9Y5iReTPHdAAAAAAAAArRg \t\n",
      "\t\t 17.559504 Johan   Enander  -  1822 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABLcVQ \t\n",
      "\t\t 17.559504 Johan   Enander  -  1822 https://portrattarkiv.se/details/TR3yO_GV8eAAAAAAAAB_Ww \t\n",
      "\t\t 17.55915 Johan   Enander  -  1822 https://portrattarkiv.se/details/TR3yO_GV8eAAAAAAAAB_Qw \t\n",
      "\t\t 17.550432 Karl Johan   Runer  -  1822 https://portrattarkiv.se/details/9Y5iReTPHdAAAAAAAAArRw \t\n",
      "\t\t 17.496826 Johan   Waldau  -  1822 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABMS1Q \t\n",
      "\t\t 17.422798 Johan   Enander  -  1822 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABLcVg \t\n",
      "\n",
      " Johan Olof Ruuth 1819 http://www.wikidata.org/entity/Q55804865\n",
      "\t\t 19.212486 Olof   Rylander  -  1819 https://portrattarkiv.se/details/9Y5iReTPHdAAAAAAAACdBA \t\n",
      "\t\t 19.15879 Olof   Larsson  -  1819 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAACb2mg \t\n",
      "\t\t 18.985676 Olof   Berger  -  1819 https://portrattarkiv.se/details/TNQaWo324IAAAAAAAADrxw \t\n",
      "\t\t 18.021896 Olof   Lindberg  -  1819 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABUDhQ \t\n",
      "\t\t 17.960869 Olof   von Porat  -  1819 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABMAtw \t\n",
      "\t\t 17.79941 Johan   Swartz  -  1819 https://portrattarkiv.se/details/YB0QHyfj0hAAAAAAAABc1w \t\n",
      "\t\t 17.729343 Johan   Pfannenstiel  -  1819 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABL9EA \t\n",
      "\t\t 17.597113 Johan   Brogren  -  1819 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAA3Kyw \t\n",
      "\t\t 17.406342 Johan   Stenfelt  -  1819 https://portrattarkiv.se/details/mLh5P0pzYFAAAAAAAAA2OQ \t\n",
      "\t\t 17.373821 Olof   Ljungberg  -  1819 https://portrattarkiv.se/details/rkIpfGqHXrAAAAAAAAB7jA \t\n",
      "\n",
      " Johanna Gustava Ruuth 1800 http://www.wikidata.org/entity/Q42418464\n",
      "\t\t 19.890453 Adolf   von Bahr  -  1800 https://portrattarkiv.se/details/4e1scVvZ-EAAAAAAAAAedg \t\n",
      "\t\t 16.743702 Per   Petersson  -  1800 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABZsTQ \t\n",
      "\t\t 14.940725 Lorenz   Mörtengren  -  1800 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABld4w \t\n",
      "\t\t 14.843468 Jonas   Bagge  -  1800 https://portrattarkiv.se/details/TNQaWo324IAAAAAAAADbSQ \t\n",
      "\t\t 14.735172 Jonas   Bagge  -  1800 https://portrattarkiv.se/details/WQknIBFpuuAAAAAAAANg1Q \t\n",
      "\t\t 14.150821 Magnus   Stenbock  -  1800 https://portrattarkiv.se/details/YB0QHyfj0hAAAAAAAADj7A \t\n",
      "\t\t 14.138518 Magnus   Stenbock  -  1800 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABNqkA \t\n",
      "\t\t 13.673463 Lars Levi   Laestadius  -  1800 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAB4v9w \t\n",
      "\t\t 13.643673 Pehr   Wieselgren  -  1800 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAB4wAA \t\n",
      "\t\t 13.553955 Carl   von Platen  -  1800 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABL9kg \t\n",
      "\n",
      " Johanna Winblad 1859 http://www.wikidata.org/entity/Q25936344\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\t\t 17.810986 Johanna   Johansson  -  1859 https://portrattarkiv.se/details/4e1scVvZ-EAAAAAAAAAgXw \t\n",
      "\t\t 17.702826 Johanna   Johansson  -  1859 https://portrattarkiv.se/details/Di4a42b6X_AAAAAAAAAoPQ \t\n",
      "\t\t 17.427217 Johanna   Magnell-Edén  -  1859 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAACZrgw \t\n",
      "\t\t 17.360882 Johanna   Andersson  -  1859 https://portrattarkiv.se/details/28K7pO-SRrAAAAAAAAC4Gw \t\n",
      "\t\t 17.08999 Johanna   Wetterström  -  1859 https://portrattarkiv.se/details/ciLMGSqrYjAAAAAAAABt9w \t\n",
      "\t\t 16.894451 Johanna   Åkerblom  -  1859 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAACZtHA \t\n",
      "\t\t 16.8323 Johanna   Mårtensson  -  1859 https://portrattarkiv.se/details/I_2wtd5VefAAAAAAAAA1yg \t\n",
      "\t\t 16.404465 Johanna   Olsson  -  1859 https://portrattarkiv.se/details/vfWYdYT6EoAAAAAAAAA_3A \t\n",
      "\t\t 16.177128 Johanna   Nilsson  -  1859 https://portrattarkiv.se/details/wbbNj8LLWMAAAAAAAAAVZg \t\n",
      "\t\t 15.3229065 Johanna   Svensson  -  1859 https://portrattarkiv.se/details/YB0QHyfj0hAAAAAAAAAPNA \t\n",
      "\n",
      " John Edward Winblad 1856 http://www.wikidata.org/entity/Q20720200\n",
      "\t\t 20.22488 Edward   Johnsson  -  1856 https://portrattarkiv.se/details/Di4a42b6X_AAAAAAAABANw \t\n",
      "\t\t 19.887737 Edward   Holmström  -  1856 https://portrattarkiv.se/details/j6S8rJvx9lAAAAAAAABuwA \t\n",
      "\t\t 19.691093 Edward   Holmer  -  1856 https://portrattarkiv.se/details/j6S8rJvx9lAAAAAAAABnzw \t\n",
      "\t\t 18.259617 Edvard   Holmer  -  1856 https://portrattarkiv.se/details/mLh5P0pzYFAAAAAAAAAnvA \t\n",
      "\t\t 16.85317 John   Stenbeck  -  1856 https://portrattarkiv.se/details/4e1scVvZ-EAAAAAAAAAoUg \t\n",
      "\t\t 16.767553 David   Holmer  -  1856 https://portrattarkiv.se/details/j6S8rJvx9lAAAAAAAABqeQ \t\n",
      "\t\t 16.624302 John   Johnsson  -  1856 https://portrattarkiv.se/details/Di4a42b6X_AAAAAAAABCxQ \t\n",
      "\t\t 16.55336 Edward   Holmer  -  1856 https://portrattarkiv.se/details/j6S8rJvx9lAAAAAAAABn0A \t\n",
      "\t\t 16.395288 John   Johnson  -  1856 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABhBkw \t\n",
      "\t\t 16.36679 John   Theorin  -  1856 https://portrattarkiv.se/details/mLh5P0pzYFAAAAAAAAA5Vw \t\n",
      "\n",
      " Jonas Kempe 1861 http://www.wikidata.org/entity/Q84110482\n",
      "\t\t 23.670956 J   Kempe  -  1861 https://portrattarkiv.se/details/0piq-fX0h5AAAAAAAAAaMw \t\n",
      "\t\t 23.02036 Berta   Kempe  -  1861 https://portrattarkiv.se/details/mLh5P0pzYFAAAAAAAAA_kQ \t\n",
      "\t\t 18.85961 Jonas   Larsson  -  1861 https://portrattarkiv.se/details/rkIpfGqHXrAAAAAAAAAhAQ \t\n",
      "\t\t 18.47467 Jonas   Broman  -  1861 https://portrattarkiv.se/details/TNQaWo324IAAAAAAAACc7g \t\n",
      "\t\t 18.18298 Jonas   Jungner  -  1861 https://portrattarkiv.se/details/Di4a42b6X_AAAAAAAAB3TQ \t\n",
      "\t\t 17.553959 Jonas   Hellström  -  1861 https://portrattarkiv.se/details/4e1scVvZ-EAAAAAAAAAiqA \t\n",
      "\t\t 17.43957 Jonas   Holmdahl  -  1861 https://portrattarkiv.se/details/j6S8rJvx9lAAAAAAAABmzg \t\n",
      "\t\t 17.365358 Jonas   Petersson  -  1861 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAA63vw \t\n",
      "\t\t 17.201023 Jonas   Jungner  -  1861 https://portrattarkiv.se/details/Di4a42b6X_AAAAAAAAB3TA \t\n",
      "\t\t 17.036274 Jonas   Jungner  -  1861 https://portrattarkiv.se/details/Di4a42b6X_AAAAAAAAB4Wg \t\n",
      "\n",
      " Lars Magnus Winblad 1797 http://www.wikidata.org/entity/Q42403307\n",
      "\t\t 18.986588 Adam   Forselles-af  -  1797 https://portrattarkiv.se/details/4e1scVvZ-EAAAAAAAAANrw \t\n",
      "\t\t 18.464298 Carl   Armfelt  -  1797 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABNqWw \t\n",
      "\t\t 15.9865675 Sebastian   Tham  -  1797 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAB4vsg \t\n",
      "\t\t 15.971597 Albrecht   Ihre  -  1797 https://portrattarkiv.se/details/5TJc-sPXaKAAAAAAAAAnrw \t\n",
      "\t\t 15.968737 Albrecht   Ihre  -  1797 https://portrattarkiv.se/details/nGoaRo7IPMAAAAAAAAAKTg \t\n",
      "\t\t 15.928043 Albrecht   Ihre  -  1797 https://portrattarkiv.se/details/nGoaRo7IPMAAAAAAAAAKRg \t\n",
      "\t\t 15.899393 Nils   Ekermann  -  1797 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABLceg \t\n",
      "\t\t 15.6649885 Anders   Sandberg  -  1797 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABfAfQ \t\n",
      "\t\t 15.622599 Hedvig   Ekenmark  -  1797 https://portrattarkiv.se/details/VaM-WW8ntnAAAAAAAAAA1A \t\n",
      "\t\t 15.593185 Carl   Armfelt  -  1797 https://portrattarkiv.se/details/28K7pO-SRrAAAAAAAAC0aQ \t\n",
      "\n",
      " Lars Öknaberg 1755 http://www.wikidata.org/entity/Q36423395\n",
      "\t\t 17.199963 A L   Stjerneld  -  1755 https://portrattarkiv.se/details/YB0QHyfj0hAAAAAAAADRvA \t\n",
      "\t\t 17.190296 A L   Stjerneld  -  1755 https://portrattarkiv.se/details/5TJc-sPXaKAAAAAAAAAm-Q \t\n",
      "\t\t 17.138025 Johan   Granschoug  -  1755 https://portrattarkiv.se/details/1ha4xkDj-uAAAAAAAABbag \t\n",
      "\t\t 17.116945 J   Tengström  -  1755 https://portrattarkiv.se/details/5TJc-sPXaKAAAAAAAAAnVg \t\n",
      "\t\t 17.071896 J   Tengström  -  1755 https://portrattarkiv.se/details/NhqpvvI9tpAAAAAAAAAybQ \t\n",
      "\t\t 16.875435 Olof   Wallquist  -  1755 https://portrattarkiv.se/details/ciLMGSqrYjAAAAAAAABisA \t\n",
      "\t\t 16.825176 Olof   Wallquist  -  1755 https://portrattarkiv.se/details/5TJc-sPXaKAAAAAAAAAnBQ \t\n",
      "\t\t 16.825176 Olof   Vallqvist  -  1755 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAB5WpQ \t\n",
      "\t\t 16.764675 Johan   Granschoug  -  1755 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABehkg \t\n",
      "\t\t 16.577353 Wendla   Molenaer  -  1755 https://portrattarkiv.se/details/I_2wtd5VefAAAAAAAAAlGA \t\n",
      "\n",
      " Lars Öknaberg 1758 http://www.wikidata.org/entity/Q36423395\n",
      "\t\t 17.442522 C   Dahl  -  1758 https://portrattarkiv.se/details/_P7S9YzQCjAAAAAAAAAsSA \t\n",
      "\t\t 17.43571 Mathias   Rosenblad  -  1758 https://portrattarkiv.se/details/5TJc-sPXaKAAAAAAAAAnAg \t\n",
      "\t\t 17.319675 Mathias   Rosenblad  -  1758 https://portrattarkiv.se/details/9Y5iReTPHdAAAAAAAABDlw \t\n",
      "\t\t 17.213085 C   Dahl  -  1758 https://portrattarkiv.se/details/5TJc-sPXaKAAAAAAAAAnTQ \t\n",
      "\t\t 17.19536 Bengt   Geijer  -  1758 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAB2TTg \t\n",
      "\t\t 17.13391 Carl   Ridderborg  -  1758 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABMB1g \t\n",
      "\t\t 17.059198 Carl   Lilliehorn  -  1758 https://portrattarkiv.se/details/WQknIBFpuuAAAAAAAANfOA \t\n",
      "\t\t 16.964848 Johan   Pettersson  -  1758 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAACZXgw \t\n",
      "\t\t 16.95485 Georg   von Döbeln  -  1758 https://portrattarkiv.se/details/4e1scVvZ-EAAAAAAAAAQLA \t\n",
      "\t\t 16.76066 Georg   von Döbeln  -  1758 https://portrattarkiv.se/details/_P7S9YzQCjAAAAAAAAArJQ \t\n",
      "\n",
      " Margareta Kristina Höglund 1819 http://www.wikidata.org/entity/Q65633978\n",
      "\t\t 19.423403 Kristina   Rundgren-Mank  -  1819 https://portrattarkiv.se/details/9Y5iReTPHdAAAAAAAAApQA \t\n",
      "\t\t 16.940891 Alida   Leffler  -  1819 https://portrattarkiv.se/details/4e1scVvZ-EAAAAAAAAAqkg \t\n",
      "\t\t 16.111555 Margareta   Rosengren  -  1819 https://portrattarkiv.se/details/seuNpYu6DKAAAAAAAABodw \t\n",
      "\t\t 15.563383 John   Lenning  -  1819 https://portrattarkiv.se/details/WQknIBFpuuAAAAAAAANj5g \t\n",
      "\t\t 14.033589 Karl   Nylander  -  1819 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABTGLQ \t\n",
      "\t\t 13.935304 Karl   Nylander  -  1819 https://portrattarkiv.se/details/wbbNj8LLWMAAAAAAAAB8FA \t\n",
      "\t\t 13.744431 Lars   Lindgren  -  1819 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABK3mg \t\n",
      "\t\t 13.593612 Frans   Wong  -  1819 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABKg6Q \t\n",
      "\t\t 13.577033 Claes   Kafle  -  1819 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABhkRw \t\n",
      "\t\t 13.5690565 Sten   Lewenhaupt  -  1819 https://portrattarkiv.se/details/rkIpfGqHXrAAAAAAAAD0Og \t\n",
      "\n",
      " Maria Elizabeth Winblad 1865 http://www.wikidata.org/entity/Q56879583\n",
      "\t\t 23.536898 Hjalmar   Winblad  -  1865 https://portrattarkiv.se/details/ciLMGSqrYjAAAAAAAABNpQ \t\n",
      "\t\t 20.223223 Hjalmar   Winblad  -  1865 https://portrattarkiv.se/details/ciLMGSqrYjAAAAAAAABNpg \t\n",
      "\t\t 19.012434 Per   Dalén  -  1865 https://portrattarkiv.se/details/_P7S9YzQCjAAAAAAAAAiQg \t\n",
      "\t\t 14.412067 Maria   Aspman  -  1865 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAACYySQ \t\n",
      "\t\t 14.412067 Maria   Cervin  -  1865 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAACaG5g \t\n",
      "\t\t 14.332171 Maria   Östlund  -  1865 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAB4phQ \t\n",
      "\t\t 14.222836 Maria   Cederberg  -  1865 https://portrattarkiv.se/details/AUBJHcnv_WAAAAAAAAA4yg \t\n",
      "\t\t 14.196777 Maria   Wennström  -  1865 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAACaJmg \t\n",
      "\t\t 14.186588 Maria   Åkesson-Cederberg  -  1865 https://portrattarkiv.se/details/xnPIH5lXePAAAAAAAAAWwA \t\n",
      "\t\t 14.126545 Maria   Wahlström  -  1865 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAACaJdw \t\n",
      "\n",
      " Olof Emanuel Näslund 1829 http://www.wikidata.org/entity/Q20725516\n",
      "\t\t 17.909824 Olof   Wadström  -  1829 https://portrattarkiv.se/details/ciLMGSqrYjAAAAAAAABcig \t\n",
      "\t\t 17.8219 Olof   Wadström  -  1829 https://portrattarkiv.se/details/ciLMGSqrYjAAAAAAAABciw \t\n",
      "\t\t 17.519726 Graf Olof   Andersson  -  1829 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAB4wJg \t\n",
      "\t\t 17.390501 Olof   Möllenhoff  -  1829 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAB4qWQ \t\n",
      "\t\t 17.173458 Olof   Tomander  -  1829 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABUERw \t\n",
      "\t\t 16.970993 Olof   Amilon  -  1829 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAA2gYA \t\n",
      "\t\t 16.743034 Olof   Tomander  -  1829 https://portrattarkiv.se/details/NhqpvvI9tpAAAAAAAAAcVg \t\n",
      "\t\t 16.539392 Olof   Möllenhoff  -  1829 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAB4qVA \t\n",
      "\t\t 16.097424 Olof   Andersson  -  1829 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAA5TnQ \t\n",
      "\t\t 16.000452 Johan   Stecksén  -  1829 https://portrattarkiv.se/details/mLh5P0pzYFAAAAAAAAA1-Q \t\n",
      "\n",
      " Per Olof Bernhard Wahlberg 1852 http://www.wikidata.org/entity/Q25916690\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\t\t 19.596542 Per   Magnusson  -  1852 https://portrattarkiv.se/details/I_2wtd5VefAAAAAAAAAH4g \t\n",
      "\t\t 19.256989 Per   Wistrand  -  1852 https://portrattarkiv.se/details/ciLMGSqrYjAAAAAAAABStA \t\n",
      "\t\t 19.222755 Per   Eriksson  -  1852 https://portrattarkiv.se/details/TR3yO_GV8eAAAAAAAAAq4w \t\n",
      "\t\t 19.170305 P   Hillström  -  1852 https://portrattarkiv.se/details/j6S8rJvx9lAAAAAAAABWlg \t\n",
      "\t\t 18.680765 Bernhard   Ericsson  -  1852 https://portrattarkiv.se/details/TR3yO_GV8eAAAAAAAAAarQ \t\n",
      "\t\t 17.37483 INGRID   Ersdotter  -  1852 https://portrattarkiv.se/details/4e1scVvZ-EAAAAAAAAATog \t\n",
      "\t\t 16.733227 Per   Lilliecreutz  -  1852 https://portrattarkiv.se/details/rkIpfGqHXrAAAAAAAADifw \t\n",
      "\t\t 16.70972 Carl   Spånberg  -  1852 https://portrattarkiv.se/details/mLh5P0pzYFAAAAAAAAA1wg \t\n",
      "\t\t 16.671888 Per   Lilliecreutz  -  1852 https://portrattarkiv.se/details/rkIpfGqHXrAAAAAAAADfmQ \t\n",
      "\t\t 16.66492 Axel   Carlström  -  1852 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAA7TWw \t\n"
     ]
    }
   ],
   "source": [
    "SPAdetail = \"https://portrattarkiv.se/details/\"\n",
    "for index, row  in SPAdf.iterrows():\n",
    "    print(\"\\n\",row[\"search\"],row[\"item\"])\n",
    "    encoded_body = json.dumps({\n",
    "        \"limit\": \"10\",\n",
    "        \"from\": \"0\",\n",
    "        \"birthyear\":row[\"year\"],\n",
    "        \"all\":row[\"search\"]\n",
    "    })\n",
    "    \n",
    "    r = http.request('POST', url,\n",
    "                 headers={'Content-Type': 'application/json'},\n",
    "                 body=encoded_body)\n",
    "\n",
    "    if r.status != 200:\n",
    "        print(r.status)\n",
    "        continue\n",
    "    \n",
    "    data = json.loads(r.data.decode('utf-8'),) \n",
    "    urls = []\n",
    "\n",
    "\n",
    "    for h in data[\"hits\"][\"hits\"]:\n",
    "        id = h[\"_id\"]\n",
    "#        print(h)\n",
    "        source = h[\"_source\"]\n",
    "        try:\n",
    "#            print(id)\n",
    "#           urlPicture = urlbasePic + id\n",
    "#            urls.append(urlPicture)\n",
    "            score = h[\"_score\"]\n",
    "            FirstName = source[\"FirstName\"]\n",
    "            LastName = source[\"LastName\"]\n",
    "            BirthYear = source[\"BirthYear\"]\n",
    "            print(\"\\t\\t\",score,FirstName, \" \", LastName, \" - \", BirthYear,SPAdetail+id, \"\\t\", )\n",
    "        except:\n",
    "            print(\"Error\")\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "56d36934",
   "metadata": {},
   "outputs": [],
   "source": [
    "from IPython.display import HTML, Image\n",
    "\n",
    "def _src_from_data(data):\n",
    "    \"\"\"Base64 encodes image bytes for inclusion in an HTML img element\"\"\"\n",
    "    img_obj = Image(data=data)\n",
    "    for bundle in img_obj._repr_mimebundle_():\n",
    "        for mimetype, b64value in bundle.items():\n",
    "            if mimetype.startswith('image/'):\n",
    "                return f'data:{mimetype};base64,{b64value}'\n",
    "\n",
    "def gallery(images, row_height='auto'):\n",
    "    \"\"\"Shows a set of images in a gallery that flexes with the width of the notebook.\n",
    "    \n",
    "    Parameters\n",
    "    ----------\n",
    "    images: list of str or bytes\n",
    "        URLs or bytes of images to display\n",
    "\n",
    "    row_height: str\n",
    "        CSS height value to assign to all images. Set to 'auto' by default to show images\n",
    "        with their native dimensions. Set to a value like '250px' to make all rows\n",
    "        in the gallery equal height.\n",
    "    \"\"\"\n",
    "    figures = []\n",
    "    for image in images:\n",
    "        if isinstance(image, bytes):\n",
    "            src = _src_from_data(image)\n",
    "            caption = ''\n",
    "        else:\n",
    "            src = image\n",
    "            caption = f'<figcaption style=\"font-size: 0.6em\">{image}</figcaption>'\n",
    "        figures.append(f'''\n",
    "            <figure style=\"margin: 5px !important;\">\n",
    "              <img src=\"{src}\" style=\"height: {row_height}\">\n",
    "              {caption}\n",
    "            </figure>\n",
    "        ''')\n",
    "    return HTML(data=f'''\n",
    "        <div style=\"display: flex; flex-flow: row wrap; text-align: center;\">\n",
    "        {''.join(figures)}\n",
    "        </div>\n",
    "    ''')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "id": "c6eddc26",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      " Johanna Näslund 1838 http://www.wikidata.org/entity/Q108264383\n",
      "\n",
      " Anton Julius Winblad I 1828 http://www.wikidata.org/entity/Q20667111\n",
      "\n",
      " Anton Wahlberg 1878 http://www.wikidata.org/entity/Q20652937\n",
      "\n",
      " Antonette Kristina Winblad II 1854 http://www.wikidata.org/entity/Q84323221\n",
      "\n",
      " Brita Christina Öknaberg 1799 http://www.wikidata.org/entity/Q86513219\n",
      "\n",
      " Carl Gustaf Näslund 1825 http://www.wikidata.org/entity/Q20664308\n",
      "\n",
      " Catharina Maria Martinell 1773 http://www.wikidata.org/entity/Q63302217\n",
      "\n",
      " Elsa Maria Elisabet Näslund 1829 http://www.wikidata.org/entity/Q25905894\n",
      "\n",
      " Erik Johan Örbom 1724 http://www.wikidata.org/entity/Q34850319\n",
      "\n",
      " Frideborg Winblad 1869 http://www.wikidata.org/entity/Q5503563\n",
      "\n",
      " Helena Gustafsdotter Ruuth 1729 http://www.wikidata.org/entity/Q81086857\n",
      "\n",
      " Israel Israelsson Näslund 1796 http://www.wikidata.org/entity/Q20816949\n",
      "\n",
      " Israel Israelsson Näslund IV 1823 http://www.wikidata.org/entity/Q81559062\n",
      "\n",
      " Johan Christopher Ruuth I 1767 http://www.wikidata.org/entity/Q50346736\n",
      "\n",
      " Johan Christopher Ruuth II 1823 http://www.wikidata.org/entity/Q50349249\n",
      "\n",
      " Johan Israel Näslund 1822 http://www.wikidata.org/entity/Q42418078\n",
      "\n",
      " Johan Olof Ruuth 1819 http://www.wikidata.org/entity/Q55804865\n",
      "\n",
      " Johanna Gustava Ruuth 1800 http://www.wikidata.org/entity/Q42418464\n",
      "\n",
      " Johanna Winblad 1859 http://www.wikidata.org/entity/Q25936344\n",
      "\n",
      " John Edward Winblad 1856 http://www.wikidata.org/entity/Q20720200\n",
      "\n",
      " Jonas Kempe 1861 http://www.wikidata.org/entity/Q84110482\n",
      "\n",
      " Lars Magnus Winblad 1797 http://www.wikidata.org/entity/Q42403307\n",
      "\n",
      " Lars Öknaberg 1755 http://www.wikidata.org/entity/Q36423395\n",
      "\n",
      " Lars Öknaberg 1758 http://www.wikidata.org/entity/Q36423395\n",
      "\n",
      " Margareta Kristina Höglund 1819 http://www.wikidata.org/entity/Q65633978\n",
      "\n",
      " Maria Elizabeth Winblad 1865 http://www.wikidata.org/entity/Q56879583\n",
      "\n",
      " Olof Emanuel Näslund 1829 http://www.wikidata.org/entity/Q20725516\n",
      "\n",
      " Per Olof Bernhard Wahlberg 1852 http://www.wikidata.org/entity/Q25916690\n"
     ]
    }
   ],
   "source": [
    "urlbasePic = \"https://portrattarkiv.se/endpoints/file.php?id=\"\n",
    "for index, row  in SPAdf.iterrows():\n",
    "    print(\"\\n\",row[\"search\"],row[\"item\"])\n",
    "    encoded_body = json.dumps({\n",
    "        \"limit\": \"10\",\n",
    "        \"from\": \"0\",\n",
    "        \"birthyear\":row[\"year\"],\n",
    "        \"all\":row[\"search\"]\n",
    "    })\n",
    "    \n",
    "    r = http.request('POST', url,\n",
    "                 headers={'Content-Type': 'application/json'},\n",
    "                 body=encoded_body)\n",
    "\n",
    "    if r.status != 200:\n",
    "        print(r.status)\n",
    "        continue\n",
    "    \n",
    "    data = json.loads(r.data.decode('utf-8'),) \n",
    "    urls = []\n",
    "    for h in data[\"hits\"][\"hits\"]:\n",
    "        id = h[\"_id\"]\n",
    "        source = h[\"_source\"]\n",
    "        urlPicture = urlbasePic + id\n",
    "        urls.append(urlPicture)\n",
    "    #print(urls)\n",
    "    #gallery(urls, row_height='200px')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "id": "c49e79ea",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "        <div style=\"display: flex; flex-flow: row wrap; text-align: center;\">\n",
       "        \n",
       "            <figure style=\"margin: 5px !important;\">\n",
       "              <img src=\"https://portrattarkiv.se/endpoints/file.php?id=I_2wtd5VefAAAAAAAAAH4g\" style=\"height: 100px\">\n",
       "              <figcaption style=\"font-size: 0.6em\">https://portrattarkiv.se/endpoints/file.php?id=I_2wtd5VefAAAAAAAAAH4g</figcaption>\n",
       "            </figure>\n",
       "        \n",
       "            <figure style=\"margin: 5px !important;\">\n",
       "              <img src=\"https://portrattarkiv.se/endpoints/file.php?id=ciLMGSqrYjAAAAAAAABStA\" style=\"height: 100px\">\n",
       "              <figcaption style=\"font-size: 0.6em\">https://portrattarkiv.se/endpoints/file.php?id=ciLMGSqrYjAAAAAAAABStA</figcaption>\n",
       "            </figure>\n",
       "        \n",
       "            <figure style=\"margin: 5px !important;\">\n",
       "              <img src=\"https://portrattarkiv.se/endpoints/file.php?id=TR3yO_GV8eAAAAAAAAAq4w\" style=\"height: 100px\">\n",
       "              <figcaption style=\"font-size: 0.6em\">https://portrattarkiv.se/endpoints/file.php?id=TR3yO_GV8eAAAAAAAAAq4w</figcaption>\n",
       "            </figure>\n",
       "        \n",
       "            <figure style=\"margin: 5px !important;\">\n",
       "              <img src=\"https://portrattarkiv.se/endpoints/file.php?id=j6S8rJvx9lAAAAAAAABWlg\" style=\"height: 100px\">\n",
       "              <figcaption style=\"font-size: 0.6em\">https://portrattarkiv.se/endpoints/file.php?id=j6S8rJvx9lAAAAAAAABWlg</figcaption>\n",
       "            </figure>\n",
       "        \n",
       "            <figure style=\"margin: 5px !important;\">\n",
       "              <img src=\"https://portrattarkiv.se/endpoints/file.php?id=TR3yO_GV8eAAAAAAAAAarQ\" style=\"height: 100px\">\n",
       "              <figcaption style=\"font-size: 0.6em\">https://portrattarkiv.se/endpoints/file.php?id=TR3yO_GV8eAAAAAAAAAarQ</figcaption>\n",
       "            </figure>\n",
       "        \n",
       "            <figure style=\"margin: 5px !important;\">\n",
       "              <img src=\"https://portrattarkiv.se/endpoints/file.php?id=4e1scVvZ-EAAAAAAAAATog\" style=\"height: 100px\">\n",
       "              <figcaption style=\"font-size: 0.6em\">https://portrattarkiv.se/endpoints/file.php?id=4e1scVvZ-EAAAAAAAAATog</figcaption>\n",
       "            </figure>\n",
       "        \n",
       "            <figure style=\"margin: 5px !important;\">\n",
       "              <img src=\"https://portrattarkiv.se/endpoints/file.php?id=rkIpfGqHXrAAAAAAAADifw\" style=\"height: 100px\">\n",
       "              <figcaption style=\"font-size: 0.6em\">https://portrattarkiv.se/endpoints/file.php?id=rkIpfGqHXrAAAAAAAADifw</figcaption>\n",
       "            </figure>\n",
       "        \n",
       "            <figure style=\"margin: 5px !important;\">\n",
       "              <img src=\"https://portrattarkiv.se/endpoints/file.php?id=mLh5P0pzYFAAAAAAAAA1wg\" style=\"height: 100px\">\n",
       "              <figcaption style=\"font-size: 0.6em\">https://portrattarkiv.se/endpoints/file.php?id=mLh5P0pzYFAAAAAAAAA1wg</figcaption>\n",
       "            </figure>\n",
       "        \n",
       "            <figure style=\"margin: 5px !important;\">\n",
       "              <img src=\"https://portrattarkiv.se/endpoints/file.php?id=rkIpfGqHXrAAAAAAAADfmQ\" style=\"height: 100px\">\n",
       "              <figcaption style=\"font-size: 0.6em\">https://portrattarkiv.se/endpoints/file.php?id=rkIpfGqHXrAAAAAAAADfmQ</figcaption>\n",
       "            </figure>\n",
       "        \n",
       "            <figure style=\"margin: 5px !important;\">\n",
       "              <img src=\"https://portrattarkiv.se/endpoints/file.php?id=sj9PGLAlnmUAAAAAAA7TWw\" style=\"height: 100px\">\n",
       "              <figcaption style=\"font-size: 0.6em\">https://portrattarkiv.se/endpoints/file.php?id=sj9PGLAlnmUAAAAAAA7TWw</figcaption>\n",
       "            </figure>\n",
       "        \n",
       "        </div>\n",
       "    "
      ],
      "text/plain": [
       "<IPython.core.display.HTML object>"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gallery(urls, row_height='100px')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "afa4c8df",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "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.9.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}