LinkedData in action a la Sälgö: Spotify

Kod

var endpointUrl = 'https://query.wikidata.org/sparql',
sparqlQuery = "#defaultView:ImageGrid\n" +
"select ?person ?personLabel ?personDescription ?pic ?SPA ?Spotify (SAMPLE(?birth) AS ?birth) {\n" +
"{\n" +
" ?person wdt:P4819 ?SPAid . # SPAid\n" +
" ?person wdt:P1902 ?Spotifyid . # Spotify\n" +
" OPTIONAL {?person wdt:P569 ?birth} .\n" +
" OPTIONAL{ ?person wdt:P18 ?pic .} # If we have an illustration\n" +
" BIND (URI(CONCAT(\"https://porträttarkiv.se/details/\",?SPAid)) AS ?SPA)\n" +
" BIND (URI(CONCAT(\"https://open.spotify.com/artist/\",?Spotifyid)) AS ?Spotify)\n" +
" OPTIONAL { ?article schema:about ?person. }\n" +
"\n" +
" } \n" +
" SERVICE wikibase:label { bd:serviceParam wikibase:language \"sv\",\"en\"}\n" +
" }\n" +
"Group by ?person ?personLabel ?personDescription ?pic ?SPA ?Geni ?SBL ?Spotify \n" +
"Order by DESC(?birth)",
settings = {
headers: { Accept: 'application/sparql-results+json' },
data: { query: sparqlQuery }
};

$.ajax( endpointUrl, settings ).then( function ( data ) {
$( 'body' ).append( ( $('<pre>').text( JSON.stringify( data) ) ) );
console.log( data );
} );

måndag 5 juni 2017

Norra Begravningsplatsen +1900 graves cemetery in Stockholm, Sweden

Swedish Wikipedia with links to Google map and Svenskt Biografiskt Lexikon...

Graves on a map grouped by occupations v.2
Map with birth locations for people buried at Norra Begravningsplatsen

Birth, death buried location

Graves with Men vs. kvinnor marked - shows gender difference
Picture of graves
Map with graves that have no pictures in Wikidata
Graves grouped by timeperiod
Only graves of people with a spotify artist id connected with link to Spotify (lista)
Graves were the person has an object on Wikidata he/she has created

Map with filter per occupation
OBS with more people in the same grave just one is seen...
Map with graves with picture of the gravestone http://tinyurl.com/zwyfbn3

Below filter per occupation on the Northern cemetery Q252312 in Stockholm, Sweden

How to filter

Example of filter on Composer

fredag 3 mars 2017

Artists who passed away 2017 with Spotify Artist ID on Wikipedi

Spotify Artists on Wikipedia that past away 2017 on a Timeline from Histropedia

fredag 30 december 2016

Spotify on a Timeline

Histropedia Timeline - http://www.histropedia.com/

Country of birth coloured by country

Award, genre and country of birth
Genre and country of Birth coloured by country
Artist passed away 2016 another option with Timeline

Artist in music that passed away 2016 with no Spotify link

fredag 23 september 2016

Last year passed away on WIkiTree from Wikipedia

http://tinyurl.com/gruus62

http://tinyurl.com/hurk9dn with WikiTree and Spotify artist id

måndag 9 maj 2016

Select just people with Spotify Artist ID buried on Norra Begravningsplatsen, Stockholm

http://tinyurl.com/ht533hy