Status: SVT Öppet Archive is closing date end januari. The new platform SVTplay miss structure for artists etc...
==> we need to
[] clean sv:Wikipedia from links [[ https://sv.wikipedia.org/w/index.php?title=Special:L%C3%A4nks%C3%B6kning&limit=500&offset=0&target=https%3A%2F%2Fwww.oppetarkiv.se%2F | SVT Öppen data ]]
[] see if we can have a better solution. I will try to speak with [[ https://www.linkedin.com/in/andersjofelt | Anders Jöfelt ]] --> we better connect SVT and WIkidata/WIkipedia
[] One possibility is that start having programs in Wikidata see [[ http://minancestry.blogspot.com/2020/12/svt-play.html | POC ]]
[] get CC-0 program info from SVT see [[ https://www.wikidata.org/wiki/Wikidata:Licensing | Wikidata:Licensing ]]
[] get SVT add [[ https://www.youtube.com/watch?v=m_9_23jXPoE | Wikidata ]] unique artists numbers i,e, Qnumber
[] set up synch
[] Questions:
[] is the SVTPlay programid persistent? should we have a Wikidata property for it see [[ https://www.wikidata.org/wiki/Wikidata:Property_proposal/SVTplay_identifier | Wikidata:Property proposal/SVTplay identifier ]]
* 2021 we had >[[ https://pageviews.toolforge.org/massviews/?platform=all-access&agent=user&source=category&range=this-year&subjectpage=0&subcategories=1&sort=views&direction=1&view=list&target=https://sv.wikipedia.org/wiki/Kategori:TV-program_i_SVT | 22 million page views on Wikipedia articles ]] about Swedish programs
{F33946821,width=800}
[] Looks like we miss a SVTplay API with a license statement see [[ https://www.wikidata.org/wiki/Wikidata:Licensing | Wikidata:Licensing ]]
[] did a [[ https://github.com/salgo60/open-data-examples/blob/master/SVTplay.ipynb | Notebook test on an unofficial API ]]
{F33946860}
[] We will try to add a property for SVTplay see [[ https://www.wikidata.org/wiki/Wikidata:Property_proposal/SVTplay_identifier | Wikidata:Property proposal/SVTplay identifier ]]
{F33946786,width=700}
* small test see if we can change approach and instead of linking "categories in SVT Öppet archive" have all programs and artists in Wikidata see [[ https://minancestry.blogspot.com/2020/12/svt-play.html | blog ]]
* below "Här är ditt liv med Tumba", 11 januari 1980 [[ https://www.oppetarkiv.se/video/1161666/har-ar-ditt-liv | 1161666 ]] SVTPlay [[ https://www.svtplay.se/video/13978128/har-ar-ditt-liv-oppet-arkiv/har-ar-ditt-liv-sven-tumba-sasong-1-sven-tumba | 13978128 ]], Wikidata [[ https://www.wikidata.org/wiki/Q104180941?uselang=sv | Q104180941 ]]
{F33945947,width=700}
[] create a Entity Schema SVT Play [[ https://www.wikidata.org/wiki/EntitySchema:E279 | EntitySchema:E279 ]]
[] delete when SVT Öppet Archive is closed down....
[] template [[ https://sv.wikipedia.org/wiki/Mall:SVT%C3%96ppetArkiv | SVTÖppetArkiv ]]
[] property [[ https://www.wikidata.org/wiki/Property:P6817 | 6819 ]]
[] can we create a new Property for SVT play see proposal [[ https://www.wikidata.org/wiki/Wikidata:Property_proposal/SVTplay_identifier | Wikidata:Property_proposal/SVTplay_identifier ]]
[] can we use SVT API data what is the license? test [[ https://github.com/salgo60/open-data-examples/blob/master/SVTplay.ipynb | Notebook ]]
* see test [[ http://minancestry.blogspot.com/2020/12/svt-play.html | LillBabs ]]
* SPARQL
* [[ https://w.wiki/qYA | programs in Wikidata ]] from Swedish SVT
* [[https://w.wiki/qcG| number of cast members ]]
[] try to check with Sebastian Suarez-Golborne 0709206995 if an API or other solution is available and the license of the metadata
[] check status [[ https://api.svt.se/contento/graphql | api.svt.se contento/graphql ]]
[x] Property [[ https://www.wikidata.org/wiki/Property:P6817 | created P6817 ]]
[X] connect items
* started > 1900 connected
[X] speak with SVT how we can do this better and what the impact is of the move to SVTPlay? see [[ https://youtu.be/q7O5eO68z9A | video ]] / min [[ https://youtu.be/ixiyF-Kz-00 | vision med mycket mera Länkade data ]] / [[ https://towardsdatascience.com/movie-recommendations-powered-by-knowledge-graphs-and-neo4j-33603a212ad0 | Netflix knowledge graphs ]] / [[ https://youtu.be/9c2HAwnVA9k?t=2756 | video Google/Netflix ]] and content engineering
[X] today [[ https://www.youtube.com/watch?v=m_9_23jXPoE | Wikidata ]] links the landing pages for people what is the plan? WIll you support **Linked data** ? [[ http://wikimedia.fi/2016/04/15/yle-3-wikidata/ | Compare Yle ]]
* Wikidata property SVT Öppet Archive has connected > 1900 people
* sv:Wikipedia has > [[ https://sv.wikipedia.org/w/index.php?title=Special:L%C3%A4nks%C3%B6kning&limit=5000&offset=0&target=http%3A%2F%2Fwww.oppetarkiv.se | 490 links SV T Öppet archive ]] compare links [[ https://sv.wikipedia.org/w/index.php?title=Special:L%C3%A4nks%C3%B6kning&limit=5000&offset=0&target=http%3A%2F%2Fwww.svtplay.se | SVT Play ]] = 434
* number viewers this year for articles using [[ https://sv.wikipedia.org/wiki/Mall:SVT%C3%96ppetArkiv | template SVT Öppet Archive ]] > [[ https://pageviews.toolforge.org/massviews/?platform=all-access&agent=user&source=category&range=this-year&subjectpage=0&subcategories=0&sort=views&direction=1&view=list&target=https://sv.wikipedia.org/wiki/Kategori:SVT%25C3%2596ppetArkiv | 2.5 million views ]]
* en:Wikipedia has > [[ https://en.wikipedia.org/w/index.php?title=Special:LinkSearch&limit=500&offset=0&target=http%3A%2F%2Fwww.oppetarkiv.se | 100 external links SVT Öppet archive ]]
{F33941424,width=800}
{F29670738,width=120, layout=right,float}
Wikidata queries
* what is connected: https://w.wiki/8cU > ~~750 1100 1770~~ 1927
* same [[ https://w.wiki/5LG | but with image and link sv:Wikipedia ]]
* [[ https://w.wiki/5M4 | same on a map ]]
* not [[ https://w.wiki/8cZ | connected Swedish actors ]]
* [[ https://w.wiki/JDY | latest passed away ]]
* [[https://w.wiki/5M3 | SVT Öppet arkiv and SvenskFilm ]] -> it will be very easy for Svensk Film to link SVT Öppet Archive. They use Wikidata today for checking deah dates [[ https://minancestry.blogspot.com/2018/05/svensk-filmdatabas.html | see blogpost ]]
* [[ https://w.wiki/5L$ | SVT Öppet arkiv and IMDB ]]
* [[https://w.wiki/5Ly| SVT Öppet arkiv and Svenska Akademin]]
* [[https://w.wiki/5LN|SVT Öppet arkiv and sv:Wikipedia]]
* [[https://w.wiki/5LP|SVT Öppet arkiv and en:Wikipedia]]
* [[ https://w.wiki/5Lv | SVT Öppet arkiv and Svenskt Kvinnobiografiskt lexikon ]]
* [[ https://w.wiki/5Lw| SVT Öppet arkiv and Svenskt Biografiskt lexikon ]]
* [[https://w.wiki/GDb| SVT Öppet arkiv and Litteraturbanken]]
* [[ https://w.wiki/GCf | Locations on mars/moon named after a person ]] in SVT Öppet archive
Present the result
* [[ http://histropedia.com/showcase/wikidata-viewer.html?q=SELECT%20?personItem%20?person%20?personDescription%20%20?date%20?Country_of_citizenship%20?Occupation%20%20?Gender%20?image%20?rank%20?Cause_of_death%20?Ethnic_group%20?Education%20(CONCAT(?person,%27%20(%27,?personDescription,%27)%27)%20as%20?title)%0A%20?SVT%0AWHERE%20%7B%0A%7B%0ASELECT%20?personItem%20?date%20?countryItem%20?occupationItem%20?genderItem%20?causeOfDeathItem%20?ethnicGroupItem%20?educatedAtItem%20?SVT%0A(SAMPLE(?image)%20as%20?image)%0A(COUNT(?article)%20as%20?rank)%20%0AWHERE%20%7B%09%0A?personItem%20wdt:P569%20?date%20.%0AOPTIONAL%20%7B?personItem%20wdt:P18%20?image%20%7D%0A?personItem%20wdt:P21%20?genderItem%20.%0AOPTIONAL%20%7B?personItem%20wdt:P106%20?occupationItem%20%7D%0AOPTIONAL%20%7B?personItem%20wdt:P27%20?countryItem%20%7D%0AOPTIONAL%20%7B%20?personItem%20wdt:P509%20?causeOfDeathItem%20%7D%0AOPTIONAL%20%7B%20?personItem%20wdt:P172%20?ethnicGroupItem%20%7D%0AOPTIONAL%20%7B%20?personItem%20wdt:P69%20?educatedAtItem%20%7D%0AOPTIONAL%20%7B%20?article%20schema:about%20?personItem%20%7D%0A?personItem%20wdt:P6817%20?SVTID.%0ABIND(URI(CONCAT(%22https://www.oppetarkiv.se/etikett/%22,%20?SVTID))%20AS%20?SVT)%0A%0A%7D%20GROUP%20BY%20?personItem%20?date%20?countryItem%20?occupationItem%20?genderItem%20?causeOfDeathItem%20?ethnicGroupItem%20?educatedAtItem%20?SVT%0A%7D%0ASERVICE%20wikibase:label%20%7B%0Abd:serviceParam%20wikibase:language%20%27sv%27,%27en%27.%0A?personItem%20schema:description%20?personDescription%20.%0A?personItem%20rdfs:label%20?person%20.%0A?countryItem%20rdfs:label%20?Country_of_citizenship%20.%0A?occupationItem%20rdfs:label%20?Occupation%20.%0A?genderItem%20rdfs:label%20?Gender%20.%0A?causeOfDeathItem%20rdfs:label%20?Cause_of_death%20.%0A?ethnicGroupItem%20rdfs:label%20?Ethnic_group%20.%0A?educatedAtItem%20rdfs:label%20?Education%20.%0A%7D%0A%7D%20%20ORDER%20BY%20DESC(?rank)&md=true&g=personItem&l=SVT&t=title&s=date&i=image&c=Country_of_citizenship,Gender&f=Occupation,Gender,Education,Cause_of_death,Ethnic_group&v=t | Timeline ]]
* [[ https://w.wiki/5M4 | Map born/died ]]
* [[ https://w.wiki/GDf | graves location SVT ]] connected people
{F31535476}
{F29654852,width=1000}
{F29654855,width=1000}
Example Evert Taube [[ https://www.wikidata.org/wiki/Q455625 | Q455625 ]] were we have added SVT Öppet Arkiv
{F29652569,width=1200}
===Example people matched
{F29652332,width=1200}
* other [[ https://w.wiki/5Bn | properties on those objects ]]
{F29611307,width=1200}
* [[ https://w.wiki/4xi | actors connected to a Swedish TV program ]]
* actors [[ https://w.wiki/5Bp | connected that miss a SVT link ]]
* [[ https://w.wiki/JDT |a ctors connected to a program with P6817 who miss P6817 ]]
Template created in sv:Wikipedia [[ https://sv.wikipedia.org/wiki/Mall:SVT%C3%96ppetArkiv | Mall:SVTÖppetArkiv ]]
* used on pages [[ https://sv.wikipedia.org/w/index.php?title=Special:L%C3%A4nkar_hit/Mall:SVT%C3%96ppetArkiv&limit=500 | Mall:SVTÖppetARkiv Länkar hit ]]
{F29652658,width=500}
{F29415156,width=900}
== Misc SVT ==
* Creating a [[ https://www.svtplay.se/klipp/25284951 | new domain model ]] 23 jan 2020 video tech meetup
* [[ https://www.svtplay.se/klipp/25284951/stockholm-video-tech-meetup---graphql-and-http3 | SVT Interaktiv Stockholm Video Tech Meetup! ]] - GraphQL and HTTP/3 21 jan 2020
{F33945794,width=700}