User:Johshh

From Wikidata
Jump to navigation Jump to search
Babel user information
nb-5 Denne brukeren behersker norsk bokmålprofesjonelt 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).
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).
Users by language

stuff to do

[edit]

how to tag Category:[name]organizations

IDs

[edit]

https://w.wiki/B7oK

https://w.wiki/B7oK

IDs

[edit]
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!