Bouzinac

Babel user information

en-5	This user has professional knowledge of English.

fr-N	Cet utilisateur a pour langue maternelle le français.

de-2	Dieser Benutzer beherrscht Deutsch auf fortgeschrittenem Niveau.

es-0	Esta persona no tiene ningún conocimiento del español (o lo entiende con mucha dificultad).

it-1	Questo utente può contribuire con un livello elementare in italiano.

br-0	Ne oar an implijer-mañ tamm Brezhoneg ebet (pe en deus mil boan o kompren anezhañ).

nb-0	Denne brukeren har lite eller ingen kjennskap til norsk (bokmål) (eller har svært vanskelig for å forstå det).

HarvestEdit

https://tools.wmflabs.org/pltools/harvesttemplates/share.php?action=savenew&siteid=ceb&project=wikipedia&namespace=0&property=131&template=geobox&parameter=region&addprefix=&removeprefix=&category=Mga%20tugpahanan%20sa%20Tinipong%20Bansa&depth=2&set=1&offset=0&limit=10000&wikisyntax=0&

Geographical-GPS lookupsEdit

Recherches géographiques

Data qualityEdit

Requêtes de data quality

History stuffsEdit

User:Bouzinac/Histoire

CountriesEdit

User:Bouzinac/Pays

BordersEdit

Frontières

AmbassadesEdit

https://w.wiki/Qa8 : liste
https://w.wiki/QaC : la même liste filtrée sur un pays

StreetsEdit

User:Bouzinac/Rues

Train, buses and subwaysEdit

User:Bouzinac/Trains

AirportsEdit

Essais nucléairesEdit

SELECT ?essai_nucl_aire ?essai_nucl_aireLabel ?date ?op_rateur ?op_rateurLabel ?tnt ?equivalent_nergie_kT ?partie_de ?partie_deLabel WHERE {
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  ?essai_nucl_aire (wdt:P31 /(wdt:P279*)) wd:Q210112.
  MINUS { ?essai_nucl_aire (wdt:P31/(wdt:P279*)) wd:Q98391050. }
  OPTIONAL { ?essai_nucl_aire wdt:P585 ?date. }
  OPTIONAL { ?essai_nucl_aire wdt:P137 ?op_rateur. }
  OPTIONAL { ?essai_nucl_aire wdt:P2145 ?tnt. }
  OPTIONAL {
    ?essai_nucl_aire p:P2145 ?yield_statement.
    ?yield_statement rdf:type wikibase:BestRank;
      (psn:P2145/wikibase:quantityAmount) ?joule.
    BIND((?joule / 4184000000 ) / "1000.0"^^xsd:decimal AS ?equivalent_nergie_kT)
 }
  OPTIONAL { ?essai_nucl_aire wdt:P361 ?partie_de.  }
 }

Try it!

==>à finir https://w.wiki/avZ (france) ==>résultat final ? https://w.wiki/bXH

dates et processus temporelsEdit

SELECT ?item ?start ?start_prc ?end ?end_prc ?nature_de_l__l_ment ?nature_de_l__l_mentLabel WHERE {
  VALUES ?start_prc {
    9 
    10 
    11 
  }
  ?item (p:P580/psv:P580) _:b12.
  _:b12 wikibase:timePrecision ?start_prc;
    wikibase:timeValue ?start.
  VALUES ?end_prc {
    9 
    10 
    11 
  }
  ?item (p:P582/psv:P582) _:b13.
  _:b13 wikibase:timePrecision ?end_prc;
    wikibase:timeValue ?end.
  MINUS { ?item p:P585 _:b14. }
  FILTER((YEAR(?start)) = (YEAR(?end)))
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
  OPTIONAL { ?item wdt:P31 ?nature_de_l__l_ment. }
}
LIMIT 1000

Try it!

éclipsesEdit

SELECT ?_clipse ?_clipseLabel ?date WHERE {
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  ?_clipse wdt:P31/wdt:P279* wd:Q141022.
  ?_clipse wdt:P585 ?date. 
}
order by asc(?date)

Try it!

saros solairesEdit

SELECT ?item ?itemLabel ?corps ?rang ?date_de_d_but ?date_de_fin
WHERE
{
?item  wdt:P31/wdt:P279* wd:Q220397 .
?item  p:P31 [ pq:P376 ?qualifier ].
?item  p:P31 [ pq:P376 ?corps ].
?item  p:P31 [ pq:P1545 ?rang].

     OPTIONAL { ?item wdt:P580 ?date_de_d_but. }
  OPTIONAL { ?item wdt:P582 ?date_de_fin. }
     SERVICE wikibase:label { bd:serviceParam wikibase:language "fr,en". }
}
ORDER BY xsd:integer(?rang)

Try it!

air catastrophesEdit

SELECT ?accidents ?accidentsLabel ?date ?operateurLabel ?flight_num (sample(?perpetrateurLabel) as ?perpetrateur)  (max(?victime) as ?victimes) (sample(?ASN_ids) as ?ASN_ids ) WHERE {
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
  VALUES ?what {
    wd:Q744913
    wd:Q898712
    wd:Q3149875
    wd:Q15931405
    wd:Q1863435
    wd:Q3002150
    wd:Q12051532
    wd:Q104776655
  }
  ?accidents (wdt:P31/wdt:P279) ?what.  
  OPTIONAL { ?accidents wdt:P585 ?date. }
  OPTIONAL { ?accidents wdt:P137 ?operateur. } 
  OPTIONAL { ?accidents wdt:P8031 ?perpetrateur. } 
  OPTIONAL { ?accidents wdt:P1590|wdt:P1120 ?victime. } 
  OPTIONAL { ?accidents wdt:P1755|wdt:P1760 ?ASN_ids. } 
  OPTIONAL { ?accidents wdt:P3090 ?flight_num. }    
} 
group by ?accidents ?accidentsLabel ?flight_num ?date ?operateurLabel
order by ?victimes ?date

Try it!

banknotesEdit

SELECT ?item ?itemLabel ?valeur_faciale WHERE {
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,fr". }
  OPTIONAL { ?item wdt:P3934 ?valeur_faciale. }
} order by ?valeur_faciale