{ "cells": [ { "cell_type": "markdown", "id": "88d72ce1", "metadata": {}, "source": [ "#### Check pictures in SPA och söka i SPA med folk kopplade till IFK Göteborg\n", "* [This notebook](https://github.com/salgo60/spa2Commons/blob/main/Notebook/SPA%20IFKDB.ipynb) *\n", "* IFK Göteborg\n", " * [ifkdb.se](https://ifkdb.se)\n", " * Wikidata [property P11905](https://www.wikidata.org/wiki/Property:P11905)\n", " * GITHUB Issue [#12](https://github.com/salgo60/ifkdb/issues/12)\n", " * API SPA https://portrattarkiv.se/endpoints/search.php\n", " * [SPARQL söker fram gubbar i WD födda innan 1920](https://w.wiki/7Ayd)" ] }, { "cell_type": "code", "execution_count": 1, "id": "def08e15", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Last run: 2023-08-05 09:33:38.493497\n" ] } ], "source": [ "from datetime import datetime\n", "start_time = datetime.now()\n", "print(\"Last run: \", start_time)" ] }, { "cell_type": "code", "execution_count": 2, "id": "7d09d161", "metadata": {}, "outputs": [], "source": [ "import urllib3, json\n", "import pandas as pd \n", "http = urllib3.PoolManager() \n", "\n", "url= \"https://portrattarkiv.se/endpoints/search.php\" \n" ] }, { "cell_type": "code", "execution_count": 3, "id": "392f36f1", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "\n", "RangeIndex: 34 entries, 0 to 33\n", "Data columns (total 4 columns):\n", " # Column Non-Null Count Dtype \n", "--- ------ -------------- ----- \n", " 0 search 34 non-null object\n", " 1 item 34 non-null object\n", " 2 itemLabel 34 non-null object\n", " 3 year 34 non-null object\n", "dtypes: object(4)\n", "memory usage: 1.2+ KB\n" ] } ], "source": [ "\n", "\n", "import sys\n", "from SPARQLWrapper import SPARQLWrapper, JSON\n", "\n", "endpoint_url = \"https://query.wikidata.org/sparql\"\n", "\n", "# IFKDB personer födda innan 1920 utan bild - SPA innehåller mest gamla personer\n", "queryIFKDB = \"\"\"SELECT (CONCAT (?itemLabel,\" \",str(year(?birthDate))) AS ?search) ?item ?itemLabel \n", " (str(year(?birthDate)) AS ?year)\n", " WHERE {\n", " ?item wdt:P11905 ?ifkdb. \n", " minus{?item wdt:P19 ?img}\n", " ?item wdt:P569 ?birthDate. \n", " FILTER(xsd:integer(year(?birthDate)) < 1920)\n", " SERVICE wikibase:label { bd:serviceParam wikibase:language \"sv\", \"en\". }\n", "} order by ?itemLabel \"\"\"\n", "\n", "\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, queryNoPicNorra1890)\n", "SPAdf = get_sparql_dataframe(endpoint_url, queryIFKDB)\n", "\n", "SPAdf.info() " ] }, { "cell_type": "code", "execution_count": 4, "id": "f9790064", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
searchitemitemLabelyear
0Algot Bengtsson 1900http://www.wikidata.org/entity/Q121160719Algot Bengtsson1900
1Algot Bergström 1909http://www.wikidata.org/entity/Q121160723Algot Bergström1909
2Algot Carlsson 1901http://www.wikidata.org/entity/Q121160727Algot Carlsson1901
3Arne Göransson 1918http://www.wikidata.org/entity/Q121160739Arne Göransson1918
4Bertil Gren 1918http://www.wikidata.org/entity/Q121160738Bertil Gren1918
5Bror Berg 1917http://www.wikidata.org/entity/Q121160720Bror Berg1917
6Douglas Krook 1897http://www.wikidata.org/entity/Q1252363Douglas Krook1897
7Einar Haak 1901http://www.wikidata.org/entity/Q121160740Einar Haak1901
8Elis Berndtsson 1902http://www.wikidata.org/entity/Q121160724Elis Berndtsson1902
9Emil Davidsson 1883http://www.wikidata.org/entity/Q121160729Emil Davidsson1883
10Erik Dahlström 1889http://www.wikidata.org/entity/Q121160728Erik Dahlström1889
11Erik Eiserman 1892http://www.wikidata.org/entity/Q121160732Erik Eiserman1892
12Franklin Edenholm 1891http://www.wikidata.org/entity/Q121160731Franklin Edenholm1891
13Georg Borg 1913http://www.wikidata.org/entity/Q121160726Georg Borg1913
14Gillis Gillås (Andersson) 1895http://www.wikidata.org/entity/Q121160712Gillis Gillås (Andersson)1895
15Gunnar Arcadius 1891http://www.wikidata.org/entity/Q121160717Gunnar Arcadius1891
16Gunnar Forsberg 1911http://www.wikidata.org/entity/Q121160735Gunnar Forsberg1911
17Gustaf Hermansson 1900http://www.wikidata.org/entity/Q121160746Gustaf Hermansson1900
18Gösta Bohman 1911http://www.wikidata.org/entity/Q121160725Gösta Bohman1911
19Göte Andersson 1919http://www.wikidata.org/entity/Q121160713Göte Andersson1919
20Harry Bergelin 1890http://www.wikidata.org/entity/Q121160721Harry Bergelin1890
21Helge Andersson 1899http://www.wikidata.org/entity/Q121160714Helge Andersson1899
22John Andersson 1914http://www.wikidata.org/entity/Q121160715John Andersson1914
23John Hellström 1898http://www.wikidata.org/entity/Q121160745John Hellström1898
24John Säwström 1886http://www.wikidata.org/entity/Q121052611John Säwström1886
25Karl-Erik Eliasson 1916http://www.wikidata.org/entity/Q121160733Karl-Erik Eliasson1916
26Olof Hjärn 1903http://www.wikidata.org/entity/Q121160747Olof Hjärn1903
27Ove Erickson 1884http://www.wikidata.org/entity/Q121160734Ove Erickson1884
28Per Frise 1893http://www.wikidata.org/entity/Q121160737Per Frise1893
29Torsten Augustsson 1901http://www.wikidata.org/entity/Q121160718Torsten Augustsson1901
30Uno Bergman 1911http://www.wikidata.org/entity/Q121160722Uno Bergman1911
31Vallentin Hultén 1911http://www.wikidata.org/entity/Q121160750Vallentin Hultén1911
32Viktor Hansson 1893http://www.wikidata.org/entity/Q121160742Viktor Hansson1893
33Yngve Hedelin 1909http://www.wikidata.org/entity/Q121160743Yngve Hedelin1909
\n", "
" ], "text/plain": [ " search item \\\n", "0 Algot Bengtsson 1900 http://www.wikidata.org/entity/Q121160719 \n", "1 Algot Bergström 1909 http://www.wikidata.org/entity/Q121160723 \n", "2 Algot Carlsson 1901 http://www.wikidata.org/entity/Q121160727 \n", "3 Arne Göransson 1918 http://www.wikidata.org/entity/Q121160739 \n", "4 Bertil Gren 1918 http://www.wikidata.org/entity/Q121160738 \n", "5 Bror Berg 1917 http://www.wikidata.org/entity/Q121160720 \n", "6 Douglas Krook 1897 http://www.wikidata.org/entity/Q1252363 \n", "7 Einar Haak 1901 http://www.wikidata.org/entity/Q121160740 \n", "8 Elis Berndtsson 1902 http://www.wikidata.org/entity/Q121160724 \n", "9 Emil Davidsson 1883 http://www.wikidata.org/entity/Q121160729 \n", "10 Erik Dahlström 1889 http://www.wikidata.org/entity/Q121160728 \n", "11 Erik Eiserman 1892 http://www.wikidata.org/entity/Q121160732 \n", "12 Franklin Edenholm 1891 http://www.wikidata.org/entity/Q121160731 \n", "13 Georg Borg 1913 http://www.wikidata.org/entity/Q121160726 \n", "14 Gillis Gillås (Andersson) 1895 http://www.wikidata.org/entity/Q121160712 \n", "15 Gunnar Arcadius 1891 http://www.wikidata.org/entity/Q121160717 \n", "16 Gunnar Forsberg 1911 http://www.wikidata.org/entity/Q121160735 \n", "17 Gustaf Hermansson 1900 http://www.wikidata.org/entity/Q121160746 \n", "18 Gösta Bohman 1911 http://www.wikidata.org/entity/Q121160725 \n", "19 Göte Andersson 1919 http://www.wikidata.org/entity/Q121160713 \n", "20 Harry Bergelin 1890 http://www.wikidata.org/entity/Q121160721 \n", "21 Helge Andersson 1899 http://www.wikidata.org/entity/Q121160714 \n", "22 John Andersson 1914 http://www.wikidata.org/entity/Q121160715 \n", "23 John Hellström 1898 http://www.wikidata.org/entity/Q121160745 \n", "24 John Säwström 1886 http://www.wikidata.org/entity/Q121052611 \n", "25 Karl-Erik Eliasson 1916 http://www.wikidata.org/entity/Q121160733 \n", "26 Olof Hjärn 1903 http://www.wikidata.org/entity/Q121160747 \n", "27 Ove Erickson 1884 http://www.wikidata.org/entity/Q121160734 \n", "28 Per Frise 1893 http://www.wikidata.org/entity/Q121160737 \n", "29 Torsten Augustsson 1901 http://www.wikidata.org/entity/Q121160718 \n", "30 Uno Bergman 1911 http://www.wikidata.org/entity/Q121160722 \n", "31 Vallentin Hultén 1911 http://www.wikidata.org/entity/Q121160750 \n", "32 Viktor Hansson 1893 http://www.wikidata.org/entity/Q121160742 \n", "33 Yngve Hedelin 1909 http://www.wikidata.org/entity/Q121160743 \n", "\n", " itemLabel year \n", "0 Algot Bengtsson 1900 \n", "1 Algot Bergström 1909 \n", "2 Algot Carlsson 1901 \n", "3 Arne Göransson 1918 \n", "4 Bertil Gren 1918 \n", "5 Bror Berg 1917 \n", "6 Douglas Krook 1897 \n", "7 Einar Haak 1901 \n", "8 Elis Berndtsson 1902 \n", "9 Emil Davidsson 1883 \n", "10 Erik Dahlström 1889 \n", "11 Erik Eiserman 1892 \n", "12 Franklin Edenholm 1891 \n", "13 Georg Borg 1913 \n", "14 Gillis Gillås (Andersson) 1895 \n", "15 Gunnar Arcadius 1891 \n", "16 Gunnar Forsberg 1911 \n", "17 Gustaf Hermansson 1900 \n", "18 Gösta Bohman 1911 \n", "19 Göte Andersson 1919 \n", "20 Harry Bergelin 1890 \n", "21 Helge Andersson 1899 \n", "22 John Andersson 1914 \n", "23 John Hellström 1898 \n", "24 John Säwström 1886 \n", "25 Karl-Erik Eliasson 1916 \n", "26 Olof Hjärn 1903 \n", "27 Ove Erickson 1884 \n", "28 Per Frise 1893 \n", "29 Torsten Augustsson 1901 \n", "30 Uno Bergman 1911 \n", "31 Vallentin Hultén 1911 \n", "32 Viktor Hansson 1893 \n", "33 Yngve Hedelin 1909 " ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "source": [ " SPAdf" ] }, { "cell_type": "code", "execution_count": 5, "id": "84099f4c", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "\n", " Algot Bengtsson 1900 http://www.wikidata.org/entity/Q121160719\n", "\t\t 15.94536 Algot Fredriksson - 1900 https://portrattarkiv.se/details/IQojCnw0WmAAAAAAAAA9OA \t\n", "\t\t 15.916247 Algot Holmberg - 1900 https://portrattarkiv.se/details/j6S8rJvx9lAAAAAAAACn7g \t\n", "\t\t 15.848149 Algot Andersson - 1900 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAA5cZQ \t\n", "\t\t 15.777628 Algot Bergström - 1900 https://portrattarkiv.se/details/TNQaWo324IAAAAAAAADOgQ \t\n", "\t\t 15.600735 Algot Fredriksson - 1900 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABa5vw \t\n", "\n", " Algot Bergström 1909 http://www.wikidata.org/entity/Q121160723\n", "\t\t 22.018814 Algot Bergström - 1909 https://portrattarkiv.se/details/TNQaWo324IAAAAAAAADOfw \t\n", "\t\t 16.598473 Algot Sjölén - 1909 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABOyaQ \t\n", "\t\t 16.533447 Einar Bergström - 1909 https://portrattarkiv.se/details/TNQaWo324IAAAAAAAADO0Q \t\n", "\t\t 16.48222 Nils Bergström - 1909 https://portrattarkiv.se/details/TNQaWo324IAAAAAAAADSNw \t\n", "\t\t 16.441977 Greta Bergström - 1909 https://portrattarkiv.se/details/TNQaWo324IAAAAAAAADcWQ \t\n", "\n", " Algot Carlsson 1901 http://www.wikidata.org/entity/Q121160727\n", "\t\t 18.198847 Folke Carlsson - 1901 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAA6Rcw \t\n", "\t\t 17.121252 Algot Eriksson - 1901 https://portrattarkiv.se/details/TR3yO_GV8eAAAAAAAAAYRQ \t\n", "\t\t 16.93769 Algot Lagerberg - 1901 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAB6tNQ \t\n", "\t\t 16.76141 Algot Mattsson - 1901 https://portrattarkiv.se/details/I_2wtd5VefAAAAAAAABBXg \t\n", "\t\t 16.705036 Karl Carlsson - 1901 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAA6WGg \t\n", "\n", " Arne Göransson 1918 http://www.wikidata.org/entity/Q121160739\n", "\t\t 17.795439 Harald Göransson - 1918 https://portrattarkiv.se/details/1ha4xkDj-uAAAAAAAABW_w \t\n", "\t\t 16.99049 Karl Göransson - 1918 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABV_Jg \t\n", "\t\t 16.876726 Gunnar Göransson - 1918 https://portrattarkiv.se/details/1ha4xkDj-uAAAAAAAABlMg \t\n", "\t\t 16.586706 Valter Göransson - 1918 https://portrattarkiv.se/details/1ha4xkDj-uAAAAAAAAARuw \t\n", "\t\t 16.403847 Stig Göransson - 1918 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABaycA \t\n", "\n", " Bertil Gren 1918 http://www.wikidata.org/entity/Q121160738\n", "\t\t 16.733541 Kaj Gren - 1918 https://portrattarkiv.se/details/1ha4xkDj-uAAAAAAAAAgJw \t\n", "\t\t 16.47143 Gustav Gren - 1918 https://portrattarkiv.se/details/1ha4xkDj-uAAAAAAAAAgLw \t\n", "\t\t 13.979952 Bertil Weitzman - 1918 https://portrattarkiv.se/details/seuNpYu6DKAAAAAAAABCyQ \t\n", "\t\t 13.904631 Bertil Samuelsson - 1918 https://portrattarkiv.se/details/YB0QHyfj0hAAAAAAAAAh0A \t\n", "\t\t 13.865446 Bertil Wall - 1918 https://portrattarkiv.se/details/ciLMGSqrYjAAAAAAAABp3g \t\n", "\n", " Bror Berg 1917 http://www.wikidata.org/entity/Q121160720\n", "\t\t 14.985437 Aina Berg - 1917 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABWQ3w \t\n", "\t\t 14.945154 Aina Berg - 1917 https://portrattarkiv.se/details/TNQaWo324IAAAAAAAADwfg \t\n", "\t\t 14.883848 Bengt Berg - 1917 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABbwPQ \t\n", "\t\t 14.844801 Anna Berg - 1917 https://portrattarkiv.se/details/TNQaWo324IAAAAAAAACwpg \t\n", "\t\t 14.790617 Bror Lönnqvist - 1917 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABk5eQ \t\n", "\n", " Douglas Krook 1897 http://www.wikidata.org/entity/Q1252363\n", "\t\t 20.313614 Karl Arnold Douglas Larsson - 1897 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAACiN4A \t\n", "\t\t 19.261507 Albert (Abbe) Ragnar Krook - 1897 https://portrattarkiv.se/details/0piq-fX0h5AAAAAAAABkjw \t\n", "\t\t 19.255276 Douglas Olsson - 1897 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAACet2g \t\n", "\t\t 18.229094 Douglas Bondeman - 1897 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAA2JNg \t\n", "\t\t 18.155315 Douglas Wallhäll - 1897 https://portrattarkiv.se/details/ciLMGSqrYjAAAAAAAABicA \t\n", "\n", " Einar Haak 1901 http://www.wikidata.org/entity/Q121160740\n", "\t\t 14.965992 Einar Persson - 1901 https://portrattarkiv.se/details/Dysd0OxEWfAAAAAAAABPGA \t\n", "\t\t 14.874611 Einar Johansson - 1901 https://portrattarkiv.se/details/Di4a42b6X_AAAAAAAAATwQ \t\n", "\t\t 14.869139 Einar Palme - 1901 https://portrattarkiv.se/details/Dysd0OxEWfAAAAAAAAAiDA \t\n", "\t\t 14.767922 Einar Lundqvist - 1901 https://portrattarkiv.se/details/4e1scVvZ-EAAAAAAAAAsGQ \t\n", "\t\t 14.757082 Einar Brenander - 1901 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAA2JiA \t\n", "\n", " Elis Berndtsson 1902 http://www.wikidata.org/entity/Q121160724\n", "\t\t 20.571756 Erland Aloys Ingvar Berndtsson - 1902 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAACiLnw \t\n", "\t\t 19.767632 Ellen Nilsson-Berndtsson - 1902 https://portrattarkiv.se/details/wbbNj8LLWMAAAAAAAAAoEA \t\n", "\t\t 18.013918 Carl Berndtsson - 1902 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABVsXw \t\n", "\t\t 17.495089 Elis Nestor - 1902 https://portrattarkiv.se/details/wbbNj8LLWMAAAAAAAABfvA \t\n", "\t\t 17.312708 Elis Larsson - 1902 https://portrattarkiv.se/details/rkIpfGqHXrAAAAAAAAAWjA \t\n", "\n", " Emil Davidsson 1883 http://www.wikidata.org/entity/Q121160729\n", "\t\t 21.598799 Gideon Davidsson - 1883 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAA79lg \t\n", "\t\t 20.99207 Artur Davidsson - 1883 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAA7-Ag \t\n", "\t\t 19.35135 Anna Davidsson - 1883 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAA79wQ \t\n", "\t\t 18.941233 Artur Davidsson - 1883 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAA79wA \t\n", "\t\t 15.931713 Emil Janson - 1883 https://portrattarkiv.se/details/Di4a42b6X_AAAAAAAABhhg \t\n", "\n", " Erik Dahlström 1889 http://www.wikidata.org/entity/Q121160728\n", "\t\t 23.024359 Anders Dahlström - 1889 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAACd89Q \t\n", "\t\t 21.040703 Helfrid Dahlström-Hasselskog - 1889 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAA79EA \t\n", "\t\t 18.28728 John Dahlström - 1889 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAA71xQ \t\n", "\t\t 17.446196 Elsa Dahlström-Corneliusson - 1889 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAA79FA \t\n", "\t\t 16.830593 Edith Dahlström - 1889 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAA72Bg \t\n", "\n", " Erik Eiserman 1892 http://www.wikidata.org/entity/Q121160732\n", "\t\t 12.966848 Erik Reichenberg - 1892 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABMClQ \t\n", "\t\t 12.910316 Erik Akmar - 1892 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAA2VFw \t\n", "\t\t 12.852396 Erik Weis - 1892 https://portrattarkiv.se/details/ciLMGSqrYjAAAAAAAAAiIA \t\n", "\t\t 12.829575 Erik Engberg - 1892 https://portrattarkiv.se/details/TR3yO_GV8eAAAAAAAAA13A \t\n", "\t\t 12.806941 Erik Renström - 1892 https://portrattarkiv.se/details/9Y5iReTPHdAAAAAAAABCxQ \t\n", "\n", " Franklin Edenholm 1891 http://www.wikidata.org/entity/Q121160731\n", "\t\t 23.636847 Josef Edenholm - 1891 https://portrattarkiv.se/details/TR3yO_GV8eAAAAAAAABmKA \t\n", "\t\t 8.099415 Martin Englund - 1891 https://portrattarkiv.se/details/TR3yO_GV8eAAAAAAAAA7hg \t\n", "\t\t 8.091113 Ester Klasson - 1891 https://portrattarkiv.se/details/0piq-fX0h5AAAAAAAABZ0Q \t\n", "\t\t 8.0904255 John Stenmark - 1891 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAB6uKA \t\n", "\t\t 8.041343 L Berglund - 1891 https://portrattarkiv.se/details/TNQaWo324IAAAAAAAADDfg \t\n", "\n", " Georg Borg 1913 http://www.wikidata.org/entity/Q121160726\n", "\t\t 19.866081 Georg Borg - 1913 https://portrattarkiv.se/details/mLh5P0pzYFAAAAAAAAABjQ \t\n", "\t\t 16.96488 Gustaf Borg - 1913 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABVUkQ \t\n", "\t\t 16.898539 Ulla Borg - 1913 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAA2Alg \t\n", "\t\t 16.65298 Malte Borg - 1913 https://portrattarkiv.se/details/TNQaWo324IAAAAAAAADd2w \t\n", "\t\t 16.024681 Gusten Borg - 1913 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAA2Jww \t\n", "\n", " Gillis Gillås (Andersson) 1895 http://www.wikidata.org/entity/Q121160712\n", "\t\t 19.658737 Gillis Grundberg - 1895 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAACeg1A \t\n", "\t\t 19.408978 Gillis Grundberg - 1895 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABkyFw \t\n", "\t\t 19.353582 Gillis Carlsson - 1895 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABa4jw \t\n", "\t\t 18.966728 Gillis Fahlgren - 1895 https://portrattarkiv.se/details/IQojCnw0WmAAAAAAAAAR4Q \t\n", "\t\t 18.90534 Gillis Grundberg - 1895 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABJ9sA \t\n", "\n", " Gunnar Arcadius 1891 http://www.wikidata.org/entity/Q121160717\n" ] }, { "name": "stdout", "output_type": "stream", "text": [ "\t\t 14.400093 Gunnar Alm - 1891 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAB6rng \t\n", "\t\t 14.330535 Gunnar Karlström - 1891 https://portrattarkiv.se/details/0piq-fX0h5AAAAAAAAAsYQ \t\n", "\t\t 14.240623 Gunnar Alm - 1891 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAA2C1A \t\n", "\t\t 14.125583 Gunnar Wessman - 1891 https://portrattarkiv.se/details/ciLMGSqrYjAAAAAAAAAqfQ \t\n", "\t\t 14.075785 Gunnar Holmgren - 1891 https://portrattarkiv.se/details/j6S8rJvx9lAAAAAAAABpRA \t\n", "\n", " Gunnar Forsberg 1911 http://www.wikidata.org/entity/Q121160735\n", "\t\t 18.6213 Gunnar Eklund - 1911 https://portrattarkiv.se/details/TR3yO_GV8eAAAAAAAABaqw \t\n", "\t\t 17.861698 Sivert Forsberg - 1911 https://portrattarkiv.se/details/IQojCnw0WmAAAAAAAAAfmg \t\n", "\t\t 17.572128 Sivert Forsberg - 1911 https://portrattarkiv.se/details/IQojCnw0WmAAAAAAAAAfmw \t\n", "\t\t 17.253124 Hilding Forsberg - 1911 https://portrattarkiv.se/details/IQojCnw0WmAAAAAAAABEYw \t\n", "\t\t 16.952282 Linus Forsberg - 1911 https://portrattarkiv.se/details/IQojCnw0WmAAAAAAAAAeqA \t\n", "\n", " Gustaf Hermansson 1900 http://www.wikidata.org/entity/Q121160746\n", "\t\t 19.041857 Kurt Hermansson - 1900 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAACZjsA \t\n", "\t\t 18.203106 Tage Hermansson - 1900 https://portrattarkiv.se/details/j6S8rJvx9lAAAAAAAABQXw \t\n", "\t\t 17.341518 Gustav Hermansson - 1900 https://portrattarkiv.se/details/j6S8rJvx9lAAAAAAAACWlw \t\n", "\t\t 17.12155 Helge Hermansson - 1900 https://portrattarkiv.se/details/j6S8rJvx9lAAAAAAAABQpw \t\n", "\t\t 17.114304 Anders Hermansson - 1900 https://portrattarkiv.se/details/j6S8rJvx9lAAAAAAAABRaA \t\n", "\n", " Gösta Bohman 1911 http://www.wikidata.org/entity/Q121160725\n", "\t\t 23.806843 Gösta Bohman - 1911 https://portrattarkiv.se/details/4e1scVvZ-EAAAAAAAAAQ5A \t\n", "\t\t 14.541418 Gösta Johansson - 1911 https://portrattarkiv.se/details/Di4a42b6X_AAAAAAAACSmA \t\n", "\t\t 14.473473 Gösta Morberg - 1911 https://portrattarkiv.se/details/I_2wtd5VefAAAAAAAABDng \t\n", "\t\t 14.3521805 Gösta Fall - 1911 https://portrattarkiv.se/details/IQojCnw0WmAAAAAAAAAWwQ \t\n", "\t\t 14.130252 Gösta Morberg - 1911 https://portrattarkiv.se/details/I_2wtd5VefAAAAAAAABDnw \t\n", "\n", " Göte Andersson 1919 http://www.wikidata.org/entity/Q121160713\n", "\t\t 21.54746 Göte Andersson - 1919 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABVyQQ \t\n", "\t\t 20.951479 Göte Andersson - 1919 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABVTJA \t\n", "\t\t 20.34251 Göte Andersson - 1919 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAA5NIA \t\n", "\t\t 18.986706 Göte Andersson - 1919 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAA5NIQ \t\n", "\t\t 18.291447 Göte Andersson - 1919 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABGTIw \t\n", "\n", " Harry Bergelin 1890 http://www.wikidata.org/entity/Q121160721\n", "\t\t 17.138327 Harry Edelsteen - 1890 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAACZSXQ \t\n", "\t\t 16.573565 Harry Warell - 1890 https://portrattarkiv.se/details/ciLMGSqrYjAAAAAAAAAaoA \t\n", "\t\t 16.552778 Harry Edelsteen - 1890 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABU84g \t\n", "\t\t 16.44257 Harry Kellerman - 1890 https://portrattarkiv.se/details/0piq-fX0h5AAAAAAAABcEQ \t\n", "\t\t 16.243174 Harry Edelsteen - 1890 https://portrattarkiv.se/details/TR3yO_GV8eAAAAAAAACMAg \t\n", "\n", " Helge Andersson 1899 http://www.wikidata.org/entity/Q121160714\n", "\t\t 18.763496 Karl Andersson - 1899 https://portrattarkiv.se/details/lzSYNK3ifoMAAAAAAAY-Hg \t\n", "\t\t 18.604385 Helge Andersson - 1899 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAA5YWg \t\n", "\t\t 18.570494 Helge Andersson - 1899 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAA5YXA \t\n", "\t\t 18.366484 Helge Andersson - 1899 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAA5YWw \t\n", "\t\t 17.768608 Helge Karlsson - 1899 https://portrattarkiv.se/details/seuNpYu6DKAAAAAAAABN7A \t\n", "\n", " John Andersson 1914 http://www.wikidata.org/entity/Q121160715\n", "\t\t 16.871761 John Andersson - 1914 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAA5Oyg \t\n", "\t\t 16.13367 John Andersson - 1914 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAA5Oyw \t\n", "\t\t 15.980929 John Tjäder - 1914 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABzoOQ \t\n", "\t\t 15.44993 John Nilsson - 1914 https://portrattarkiv.se/details/wbbNj8LLWMAAAAAAAAB_nA \t\n", "\t\t 14.804233 Maria Andersson - 1914 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAA4-9w \t\n", "\n", " John Hellström 1898 http://www.wikidata.org/entity/Q121160745\n", "\t\t 19.061966 Ernst Hellström - 1898 https://portrattarkiv.se/details/j6S8rJvx9lAAAAAAAABGxA \t\n", "\t\t 18.885767 Gustaf Hellström - 1898 https://portrattarkiv.se/details/j6S8rJvx9lAAAAAAAABIBw \t\n", "\t\t 18.70954 Gustaf Hellström - 1898 https://portrattarkiv.se/details/j6S8rJvx9lAAAAAAAABIBg \t\n", "\t\t 18.51957 Ernst Hellström - 1898 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAB6srQ \t\n", "\t\t 18.372025 Nils Hellström - 1898 https://portrattarkiv.se/details/mLh5P0pzYFAAAAAAAAAm3g \t\n", "\n", " John Säwström 1886 http://www.wikidata.org/entity/Q121052611\n", "\t\t 14.927121 John Holmberg - 1886 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABe3DA \t\n", "\t\t 14.839275 John Nilsson - 1886 https://portrattarkiv.se/details/wbbNj8LLWMAAAAAAAAAV9g \t\n", "\t\t 14.750408 John Lundberg - 1886 https://portrattarkiv.se/details/rkIpfGqHXrAAAAAAAACMSA \t\n", "\t\t 14.715356 John Nordlander - 1886 https://portrattarkiv.se/details/wbbNj8LLWMAAAAAAAAA91A \t\n", "\t\t 14.694609 John Johansson - 1886 https://portrattarkiv.se/details/Di4a42b6X_AAAAAAAAAnxQ \t\n", "\n", " Karl-Erik Eliasson 1916 http://www.wikidata.org/entity/Q121160733\n", "\t\t 22.143164 Karl Eliasson - 1916 https://portrattarkiv.se/details/TR3yO_GV8eAAAAAAAABIew \t\n", "\t\t 19.270494 Karl Eliasson - 1916 https://portrattarkiv.se/details/TR3yO_GV8eAAAAAAAABIfA \t\n", "\t\t 19.11891 Astrid Eliasson-Johansson - 1916 https://portrattarkiv.se/details/TR3yO_GV8eAAAAAAAACMdg \t\n", "\t\t 19.007114 Astrid Eliasson-Johansson - 1916 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABO1kw \t\n", "\t\t 18.238111 Allan Eliasson - 1916 https://portrattarkiv.se/details/TR3yO_GV8eAAAAAAAACLmA \t\n", "\n", " Olof Hjärn 1903 http://www.wikidata.org/entity/Q121160747\n", "\t\t 13.324562 Olof Lignell - 1903 https://portrattarkiv.se/details/rkIpfGqHXrAAAAAAAAA2AQ \t\n", "\t\t 13.184547 Olof Olsson - 1903 https://portrattarkiv.se/details/vfWYdYT6EoAAAAAAAAAZ9w \t\n", "\t\t 12.992919 Carl-Olof Lindblom - 1903 https://portrattarkiv.se/details/rkIpfGqHXrAAAAAAAABH8Q \t\n", "\t\t 12.977857 Olof Widestrand - 1903 https://portrattarkiv.se/details/ciLMGSqrYjAAAAAAAABAtQ \t\n", "\t\t 12.959416 Olof Ekström - 1903 https://portrattarkiv.se/details/TR3yO_GV8eAAAAAAAABffQ \t\n", "\n", " Ove Erickson 1884 http://www.wikidata.org/entity/Q121160734\n", "\t\t 22.55627 Erik Erickson - 1884 https://portrattarkiv.se/details/TR3yO_GV8eAAAAAAAAANGQ \t\n", "\t\t 21.994297 Erik Erickson - 1884 https://portrattarkiv.se/details/TR3yO_GV8eAAAAAAAAANFw \t\n", "\t\t 21.64361 Erik Erickson - 1884 https://portrattarkiv.se/details/TR3yO_GV8eAAAAAAAAANGg \t\n", "\t\t 19.788597 Martin Erickson - 1884 https://portrattarkiv.se/details/TR3yO_GV8eAAAAAAAABvOw \t\n", "\t\t 19.566301 Erik Erickson - 1884 https://portrattarkiv.se/details/TR3yO_GV8eAAAAAAAAANGA \t\n", "\n", " Per Frise 1893 http://www.wikidata.org/entity/Q121160737\n", "\t\t 30.855822 Olof Frise - 1893 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABJ7-g \t\n", "\t\t 13.582396 Per Gyldner - 1893 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAACZjhA \t\n", "\t\t 13.538353 Per Björk - 1893 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAA1eHw \t\n", "\t\t 13.534752 Per Andersson - 1893 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABVE4g \t\n", "\t\t 13.441532 Per Svensson - 1893 https://portrattarkiv.se/details/YB0QHyfj0hAAAAAAAAAVGA \t\n", "\n", " Torsten Augustsson 1901 http://www.wikidata.org/entity/Q121160718\n", "\t\t 19.668182 David Augustsson - 1901 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAA4I_w \t\n", "\t\t 18.905144 Erik Augustsson - 1901 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAA4I-Q \t\n", "\t\t 18.53637 Carl Augustsson - 1901 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAA4Rcw \t\n", "\t\t 18.481253 John Augustsson - 1901 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAA4I8Q \t\n", "\t\t 17.393127 Josef Augustsson - 1901 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAA4RaA \t\n", "\n", " Uno Bergman 1911 http://www.wikidata.org/entity/Q121160722\n", "\t\t 17.265533 Uno Hedström - 1911 https://portrattarkiv.se/details/j6S8rJvx9lAAAAAAAAA9Aw \t\n", "\t\t 16.775446 Erik Helge Bergman - 1911 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAACgtOA \t\n", "\t\t 16.56599 Erik Bergman - 1911 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAACe0WA \t\n", "\t\t 16.51969 Uno Nilsson - 1911 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABKCeQ \t\n", "\t\t 16.477188 Magnus Bergman - 1911 https://portrattarkiv.se/details/TNQaWo324IAAAAAAAADG-Q \t\n", "\n", " Vallentin Hultén 1911 http://www.wikidata.org/entity/Q121160750\n" ] }, { "name": "stdout", "output_type": "stream", "text": [ "\t\t 20.691498 Vivi-Anne Hultén - 1911 https://portrattarkiv.se/details/j6S8rJvx9lAAAAAAAAC3rQ \t\n", "\t\t 20.691498 Vivi-Anne Hultén - 1911 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABO32A \t\n", "\t\t 20.670408 Gösta Hultén - 1911 https://portrattarkiv.se/details/seuNpYu6DKAAAAAAAAAK2A \t\n", "\t\t 20.375221 Vivi-Anne Hultén - 1911 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAACY1Aw \t\n", "\t\t 20.286041 Gösta Hultén - 1911 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABVCiA \t\n", "\n", " Viktor Hansson 1893 http://www.wikidata.org/entity/Q121160742\n", "\t\t 21.232319 Viktor Andersson-Hansson - 1893 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAABFilg \t\n", "\t\t 16.6777 Viktor Broman - 1893 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAA29rg \t\n", "\t\t 16.512064 Viktor Karlström - 1893 https://portrattarkiv.se/details/0piq-fX0h5AAAAAAAAAr4g \t\n", "\t\t 16.488897 Viktor Jonsson - 1893 https://portrattarkiv.se/details/Di4a42b6X_AAAAAAAABR7A \t\n", "\t\t 16.250143 Helga Hansson - 1893 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAACZfGA \t\n", "\n", " Yngve Hedelin 1909 http://www.wikidata.org/entity/Q121160743\n", "\t\t 21.528488 Elof Hedelin - 1909 https://portrattarkiv.se/details/j6S8rJvx9lAAAAAAAAA1Hw \t\n", "\t\t 16.804615 Yngve Terenius - 1909 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAB6ubg \t\n", "\t\t 16.649242 Yngve Ahlbaum - 1909 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAA1edg \t\n", "\t\t 16.29683 Yngve Linder - 1909 https://portrattarkiv.se/details/rkIpfGqHXrAAAAAAAABPlw \t\n", "\t\t 16.220587 Yngve Ankarcrona - 1909 https://portrattarkiv.se/details/sj9PGLAlnmUAAAAAAA4Qqg \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\": \"5\",\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", " # 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": null, "id": "ccb654b5", "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.13" } }, "nbformat": 4, "nbformat_minor": 5 }