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