Jump to content

User:Johshh

From Wikidata
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-1 Dieser Benutzer beherrscht Deutsch auf grundlegendem Niveau.
la-1 Hic usor simplici lingua Latina conferre potest.
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 Denna användare har ingen kunskap om åarjelsaemien (eller förstår det med avsevärd 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).
mul-0 This user has no knowledge of multiple languages (or understands it with considerable difficulty).
Users by language

stuff to do

[edit]

how to tag Category:[name]organizations. And you should use category combines topics (P971)

IDs

[edit]

WIKIDATA SPARQL QUARY Liste over norske nettsider

WIKIDATA SPARQL QUARY Wikinews

Liste over norske aviser

Liste over norske tidskrifter

Liste over norske barnebøker

Liste over norske litterært verk

Liste over norske podcaster

Liste over norske skoler

Liste over de beste rasene

Liste over dei mest kjente snekkerene

Liste over bøker

Openlibrary

Bøker som ikkje har Openlibrary ID

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!