**Status:** No action closed see [[ https://www.wikidata.org/wiki/Wikidata:Property_proposal/SVTplay_identifier | Wikidata:Property_proposal/SVTplay_identifier ]]
SVT Öppet Archive is closing down end januari 2021. The new platform SVTplay miss structure for artists etc... we need to sit down with SVT and find out if we can do something together
/Magnus Sälgö salgo60@msn.com 0705937579
* we have a new Wikidata property ready for creation see [[ https://www.wikidata.org/wiki/Wikidata:Property_proposal/SVTplay_identifier | SVTplay_identifier ]]
==> we need to
[] clean sv:Wikipedia from links directions [[ 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 ]] = [[ 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 | 424 links ]] and one [[ https://sv.wikipedia.org/wiki/Mall:SVT%C3%96ppetArkiv | template ]] used on [[ https://sv.wikipedia.org/wiki/Kategori:SVT%C3%96ppetArkiv | 125 pages ]]
[] see if we can have a better solution doing [[ https://forum.jobtechdev.se/t/har-ni-input-till-varens-meetups/263/3 | co-creation Wikidata/Wikipedia with SVT ]]. I will try to speak with [[ https://www.linkedin.com/in/andersjofelt | Anders Jöfelt ]] --> we better connect SVT and Wikidata/Wikipedia example Wikidata query latest person [[ https://w.wiki/JDY | passed away represented in SVT Öppet Archive ]]
[] One possibility is having SVT 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 --> easier [[ https://wikidata.reconci.link/ | Wikidata reconciliation ]] and also possibility for SVT to link Wikipedia [[ http://minancestry.blogspot.com/2017/08/moma-links-wikidata-and-wikipedia.html | compare MOMA ]]
[] set up synch SVT <-> WD compare [[ https://github.com/salgo60/open-data-examples/blob/master/Nobel%20API.ipynb | Nobelprize ]]
[] Open 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 ]]
[] SVT [[ https://www.youtube.com/watch?v=mmQl6VGvX-c | vision of knowledge graphs ]] and external links
{F33963592,width=800}
* 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,width=800}
* looks this API had **6451 numbers** of participants that we could have as objects in Wikidata eg. Ulla Rohde is Wikidata [[ https://w.wiki/rcc | Q16596183 ]]
{F33963612,width=900}
[] 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}