(NOTE)**Status**: Approved [[ https://www.wikidata.org/wiki/Property:P7574 | Property:P7574 ]] and > [[ https://w.wiki/CLa | 2500 connected ]]
* mix and match created for less easy to match people see [[ https://tools.wmflabs.org/mix-n-match/#/catalog/3049 | catalog=3049 ]]
{F31133253}
**Next step:**
[X] check [[ https://sv.wikipedia.org/w/index.php?title=Special:L%C3%A4nkar_hit/Mall:Dramaten&limit=50000 | template Dramaten ]] used > 700 ggr if we can move it to Wikidata
[X] [[ https://tools.wmflabs.org/pltools/harvesttemplates/?property=7574 | pltools/harvesttemplates/?property=7574 ]] done
[X] use [[ https://www.wikidata.org/wiki/Wikidata:Tools/OpenRefine | OpenRefine ]] matching
[X] pages linking e.g.
[] [[ http://petscan.wmflabs.org/?psid=13843540 | "Dramatens elevskola" and dont have P7574 ]]
[] [[ http://petscan.wmflabs.org/?psid=13845019 | "Dramaten" ]]
[X] Create a mix-and-match catalogue for difficult matches see [[ https://tools.wmflabs.org/mix-n-match/#/catalog/3049 | catalog=3049 ]] i.e. this list will just contain not matched items (maybe wrong decision)
* [[ https://tools.wmflabs.org/wikidata-todo/sparql_rc.php?sparql=SELECT+%3Fq+WHERE+%7B+%3Fq+wdt%3AP7574+%5B%5D+%7D&start=last+week&end= | Changes last week related to this WIkidata property ]]
* [[ https://tools.wmflabs.org/mix-n-match/mobile_game.html?catalog=3049 | Mobile interface ]]
{F31208166}
[X] add all [[ https://www.dramaten.se/medverkande/skadespelare/ | current working at Dramaten ]]
[] [[ https://w.wiki/CNx | potential duplicates ]]
* [[ https://www.wikidata.org/wiki/Wikidata:Database_reports/Constraint_violations/P7574 | Wikidata:Database reports/Constraint violations/P7574 ]]
[X] Add regexp for Wikidata [[ https://regex101.com/r/zDngh6/1 | regex101.com ]]
----
* [[ https://w.wiki/CLT | list connected items ]]
* [[ https://w.wiki/CP4 | map birth death ]]
{F31111173}
* what other properties exist on objects with Property 7574 [[ https://w.wiki/CLa | swedish ]] / [[ https://w.wiki/CLd | english ]]
* [[ https://w.wiki/CLg | places named after a person with Property 7574 ]]
{F31101205}
* [[ https://tinyurl.com/DramatenNorra | People identified at Dramaten and connected to Wikidata buried at "Norra Begravningsplatsen" ]]
{F31111061,width=800}
* [[ http://www.histropedia.com/showcase/wikidata-viewer.html?q=SELECT%20?person%20?personLabel%20%0A(SAMPLE(?birth_date)%20AS%20?birth_date)%20%0A(SAMPLE(?birth_date_precision)%20AS%20?birth_date_precision)%20%0A(SAMPLE(?death_date)%20AS%20?death_date)%20%0A(SAMPLE(?death_date_precision)%20AS%20?death_date_precision)%20%0A(SAMPLE(?image)%20AS%20?image)%20%0A(COUNT(?article)%20AS%20?rank)%20%0A?Dramaten%0A?SKBL%0A?article%20%0AWHERE%20%7B%0A%20%20%20?person%20wdt:P31%20wd:Q5%20.%0A%20%20%20?person%20wdt:P570%20?death%20.%0A%20%20%20?person%20wdt:P21%20wd:Q6581072%20.%0A%20%20%20?person%20wdt:P7574%20?dramatenid%20.%0A%20%20%20OPTIONAL%20%7B?person%20wdt:P4963%20?SKBLID%7D%0A%0A%20%20OPTIONAL%20%7B%20?person%20wdt:P18%20?image.%20%7D%20%20%0A%20%20BIND%20(URI(CONCAT(%22https://www.dramaten.se/Medverkande/Rollboken/%22,?dramatenid))%20AS%20?Dramaten)%0A%20%20BIND(IF(BOUND(?SKBLID),%20%22Kvinnor%20i%20SKBL%22,%22kvinnor%20som%20saknas%20i%20SKBL%22)%20AS%20?SKBL)%0A%0A%20%20?person%20p:P569/psv:P569%20?birth_date_node%20.%20%0A%20%20?birth_date_node%20wikibase:timeValue%20?birth_date%20.%20%23this%20is%20now%20the%20actual%20birth%20date%0A%20%20?birth_date_node%20wikibase:timePrecision%20?birth_date_precision%20.%0A%0A%20%20OPTIONAL%20%7B%20%0A%20%20%20%20?person%20p:P570/psv:P570%20?death_date_node.%20%0A%20%20%20%20?death_date_node%20wikibase:timeValue%20?death_date%20.%20%23this%20is%20now%20the%20actual%20birth%20date%0A%20%20%20%20?death_date_node%20wikibase:timePrecision%20?death_date_precision%20.%0A%20%20%7D%0ASERVICE%20wikibase:label%20%7B%20bd:serviceParam%20wikibase:language%20%22sv,en%22.%20%7D%0A%0A%7D%0AGROUP%20BY%20?person%20?personLabel%20?SKBL%20?SKBLurl%20?article%20?Dramaten%0AORDER%20BY%20DESC(?rank)&md=true&g=person&l=Dramaten&t=personLabel&s=birth_date&sp=birth_date_precision&e=death_date&ep=death_date_precision&i=image&r=rank&c=SKBL&f=SKBL&v=t | Timeline with women connected to Dramaten but has no article in SKBL ]]
{F31111811,width=800}
* SPARQL [[ https://w.wiki/CSr | list of latest people connected with Dramaten that has passed away ]]
* **Dramaten**
** [[ https://w.wiki/CM8 | and Spotify ]]
*** Spotify feels like they need better classify things like
**** "[[ https://open.spotify.com/episode/1WjQ57BnRHYggkxZvEHzGO | Dramaten poden: Samtal om Hjalmar Söderberg ]]"
**** "[[ https://open.spotify.com/episode/0mTNifFWo5lSuhXxO6IFg6 | 01. Krister Henriksson läser Doktor Glas av Hjalmar Söderberg i 16 delar ]]"
** [[ https://w.wiki/CM7 | and SVT Öppet Archive ]]
** [[ https://w.wiki/CM9 | SBL ]]
** [[ https://w.wiki/CMA | SKBL ]]
** [[ https://w.wiki/CME | Litteraturbanken ]]
** [[ https://w.wiki/CPD | Musikverket ]]
** [[ https://w.wiki/Cb8 | Levande musikarv/ Swedish musical heritage ]]
*** [[ https://w.wiki/Ceh | not Dramaten but Levande musikarv ]]
** [[ https://w.wiki/Ci5 | Norwegian Nationaltheatret ]]
** [[ https://w.wiki/Cnd | LIBRISXL ]]
____
**Task: **Request a [[ https://www.wikidata.org/wiki/Wikidata:Property_proposal/Swedish_Royal_Theater | property for the Swedish Royal Dramatic Theatre database ]] that contains: person playing a role, the role and the play
- Person: e.g. [[ https://www.dramaten.se/Medverkande/Rollboken/Person/3611/ | Person/3611/ ]] = Margaretha Krook = [[ https://www.wikidata.org/wiki/Q1799576 | WD:Q1799576 ]]
- fictional character e.g. [[ https://www.dramaten.se/Medverkande/Rollboken/?category=roles&query=Bettsy+Trotwood | ?category=roles&query=Bettsy+Trotwood ]] Betsey Trotwood = [[ https://www.wikidata.org/wiki/Q3639127 | WD:Q3639127 ]]
- play e.g. [[ https://www.dramaten.se/Medverkande/Rollboken/Play/598/ | Rollboken/Play/598/ ]] = David Copperfield = [[ https://www.wikidata.org/wiki/Q189811 | WD:Q189811 ]]
With the SVT Öppna Arkiv property we also have the TV production i.e.
* sv:WIkipedia [[ https://sv.wikipedia.org/wiki/Den_inbillade_sjuke_(film) | Den_inbillade_sjuke_(film) ]]
* Wikidata [[ https://www.wikidata.org/wiki/Q64548047 | Q64548047 ]]
* SVT Öppna Arkiv {T225394}
* SMDB-identitet [[ http://smdb.kb.se/catalog/id/001708555 | 001708555 ]]
* IMDb-identifikationskod [[ https://tools.wmflabs.org/wikidata-externalid-url/?p=345&url_prefix=https://www.imdb.com/&id=tt0095367 | tt0095367 ]]
* dramaten.se [[ https://www.dramaten.se/medverkande/rollboken/Play/1337 | rollboken Play 1337 ]]
{F29469406,width=800}