Johshh

Babel user information

nb-5	Denne brukeren behersker norsk bokmål på profesjonelt nivå.

nn-5	Denne brukaren meistrar nynorsk på eit profesjonelt nivå.

en-4	This user has near native speaker knowledge of English.

da-3	Denne bruger har et avanceret kendskab til dansk.

sv-2	Den här användaren har medelgoda kunskaper i svenska.

de-0	Dieser Benutzer beherrscht Deutsch nicht (oder versteht es nur mit beträchtlichen Schwierigkeiten).

he-0	משתמש זה אינו מבין עברית (או מבין אותה בקשיים ניכרים).

is-0	Þessi notandi talar ekki íslensku (á erfitt með að skilja hana eða kýs að tala hana ekki).

nrn-0	This user has no knowledge of Norn (or understands it with considerable difficulty).

se-0	Dát geavaheaddji máhttá davvisámegiela hui veaháš dahje ii máhte dan ollege.

sma-0	Den här användaren förstår inte åarjelsaemien (eller förstår det bara med stor svårighet).

smj-0	This user has no knowledge of julevsámegiella (or understands it with considerable difficulty).

smn-0	Taat kevttee máttá uáli jo uccáá teikkâ ij määti ollágin anarâškielâ.

sms-0	This user has no knowledge of nuõrttsääʹmǩiõll (or understands it with considerable difficulty).

fkv-0	This user has no knowledge of kvääni (or understands it with considerable difficulty).

stuff to do

how to tag Category:[name]organizations

Category:Linguistics organizations (Q9233045)

IDs

https://w.wiki/B7oK

IDs

Forklaringstekst
ID	Overskriftstekst	nummer	API
nyheter	https://www.nrk.no/nyheter/1.16668508	1.16668508	https://www.nrk.no/serum/api/content/json/1.16668508
i	https://www.aftenposten.no/i/zEpklq	zEpklq
i	https://www.vg.no/i/0QR0M0	0QR0M0

proff.no purehelp regnskapstall

Forklaringstekst
Overskriftstekst	Overskriftstekst	Wikidata property
Driftsinntekter	25050000	???
Driftsresultat	-239k	operating income (P3362)
Sum egenkapital	15608000	???

SELECT ?item ?itemLabel (MAX(?members) AS ?latestMembers) (MAX(?time) AS ?latestTime) (MAX(?vedtekter) AS ?latestVedtekter) (MAX(?vedtektertime) AS ?latestVedtekterTime) WHERE {
  ?item wdt:P31 wd:Q43229; wdt:P17 wd:Q20.
  MINUS { ?item wdt:P576 ?itemLabel. }
  OPTIONAL { ?item p:P2124 ?statement. ?statement ps:P2124 ?members; pq:P585 ?time. }
  OPTIONAL { ?item p:P6378 ?statement2. ?statement2 ps:P6378 ?vedtekter; pq:P585 ?vedtektertime. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,nb". }
}
GROUP BY ?item ?itemLabel

Try it!

SELECT ?item ?itemLabel ?youtubeHandel ?youtubeChannel WHERE {
  ?item wdt:P11245 ?youtubeHandel.
  ?item wdt:P2397 ?youtubeChannel.
  ?item wdt:P17 wd:Q20.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],nb". }
}

Try it!

Show all members of parlament that dose not have twitter account.

SELECT ?item ?itemLabel ?party ?partyLabel ?gender WHERE {
   ?item p:P39 ?statement.
   ?statement ps:P39 wd:Q9045502.
   ?statement pq:P2937 wd:Q108535431
   MINUS {
   ?item wdt:P2002 ?username . # select best only
   ?item p:P2002 ?ts . ?ts ps:P2002 ?username . optional { ?ts pq:P3744 ?followers . }
   optional {   ?ts prov:wasDerivedFrom [ pr:P813 ?date ] . }
   }                       .        
   ?item wdt:P102 ?party.
   ?party rdfs:label ?partyLabel.
   FILTER (lang(?partyLabel) = 'en')
   ?item wdt:P21 ?gender.
   SERVICE wikibase:label { bd:serviceParam wikibase:language '[AUTO_LANGUAGE],en'. }
 }

Try it!

Show all members of World Economic Forum

SELECT ?item ?itemLabel ?party ?partyLabel ?image WHERE {
   ?item wdt:P27  wd:Q20  .
   ?item wdt:P10347 ?username . # select best only
   optional { ?item wdt:P102 ?party . }
   optional { ?item wdt:P18 ?image . }
   SERVICE wikibase:label { bd:serviceParam wikibase:language '[AUTO_LANGUAGE],en'. }
 }

Try it!

List every church in norway,map "Stolen from https://no.wikipedia.org/wiki/Mal:Kart_over_norske_fyr"

#title:Liste over kirker i Norge
#defaultView:Map
SELECT DISTINCT ?id ?idLabel ?loc ?incept ?sentry ?send WHERE {
  ?id wdt:P31 wd:Q16970;
  wdt:P17 wd:Q20.
  OPTIONAL { ?id wdt:P625 ?loc. }
  OPTIONAL { ?id wdt:P729 ?sentry. }
  OPTIONAL { ?id wdt:P730 ?send. }
  OPTIONAL { ?id wdt:P571 ?incept. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],nb". } # Helps get the label in your language, if not, then en language
}
ORDER BY ASC(?loc)

Liste over kirker i Norge

SELECT ?periodical ?periodicalLabel ?inceptionDate
WHERE
{
  ?periodical wdt:P31/wdt:P279* wd:Q1002697; # Instances of periodicals or their subclasses
  #?periodical wdt:P279* wd:Q11032 ;
              wdt:P17 wd:Q20;            # Located in Norway
              wdt:P571 ?inceptionDate.      # Inception date of the periodical
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],no". }
}
ORDER BY ?inceptionDate

Try it!