HLa01

Adding council Websites into Wikidata while making them accessible for other Bots.

hu-1	Ez a szerkesztő alapszinten beszéli a magyar nyelvet.

en-2	This user has intermediate knowledge of English.

de-2	Dieser Benutzer beherrscht Deutsch auf fortgeschrittenem Niveau.

fr-1	Cet utilisateur dispose de connaissances de base en français.

Helpful reading

Help:Ranking

Wikidata:WikiProject Municipalities of Germany/Taxonomy

User:Aeroid

rathaus (Q543654) (Valderrobres town hall (Q5754700))

Märkischer Kreis (District council) (Q28654743)

Hello, what's the use of this item? it is not linked from anywhere, and both descriptions (German, English) have errors. Holger1959 (talk) 17:09, 5 February 2017 (UTC)

@Holger1959:

Usage

I'm aiming for the automated collection of council data like the data Märkischer_Kreis#Politics_and_administration. HLa01 (talk)

Description Errors

On the Website of the council heading "Kreistagsinformationssystem" i concluded it's an district council. On the other hand on Märkischer Kreis (Q5937) it's name is rural district council. HLa01 (talk) 02:58, 30 March 2017 (UTC)

Queries

https://www.wikidata.org/wiki/Wikidata:Database_reports/Constraint_violations/P991

subclass of (P279) representative assembly (Q2532278)

The following query uses these:

Items: representative assembly (Q2532278)

Properties: subclass of (P279)  
```
select ?item ?Label
where 
{
  ?item wdt:P279 wd:Q2532278 .
	SERVICE wikibase:label { bd:serviceParam wikibase:language "en,de,hu" . ?item rdfs:label ?Label }
}
```

Try it!

city council (Q3154693)

The following query uses these:

Items: city council (Q3154693)   , municipal council (Q701632)

Properties: instance of (P31)   , applies to jurisdiction (P1001)   , official website (P856)  
```
#Councils P1001
SELECT ?item ?placeLabel ?LabelEN ?LabelDE ?Label (SAMPLE(?Website) AS ?Website)
WHERE
{
	?item wdt:P31 wd:Q3154693 . #or wd:Q701632
	OPTIONAL{?item wdt:P1001 ?place .}
    OPTIONAL{?place rdfs:label ?placeLabel .}
    OPTIONAL{?item wdt:P856 ?Website .}
	SERVICE wikibase:label { bd:serviceParam wikibase:language "hu". ?item rdfs:label ?LabelHU } .
	SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . ?item rdfs:label ?LabelEN } .
	SERVICE wikibase:label { bd:serviceParam wikibase:language "de" . ?item rdfs:label ?LabelDE } .
	SERVICE wikibase:label { bd:serviceParam wikibase:language "fr,ar,be,bg,bn,ca,cs,da,de,el,en,es,et,fa,fi,he,hi,hu,hy,id,it,ja,jv,ko,nb,nl,eo,pa,pl,pt,ro,ru,sh,sk,sr,sv,sw,te,th,tr,uk,yue,vec,vi,zh" 
 . ?item rdfs:label ?Label }
}
GROUP BY ?item ?placeLabel ?LabelEN ?LabelDE ?Label
limit 500
```

Try it!

The following query uses these:

Items: language (Q315)

Properties: instance of (P31)  
```
#Languages
select ?l ?Label
where 
{
  ?l wdt:P31 wd:Q315 .
	SERVICE wikibase:label { bd:serviceParam wikibase:language "en,hu,de" . ?l rdfs:label ?Label }
}
```

Try it!

representative assembly (Q2532278)

council (Q4358176), representative assembly (Q2532278), "District council"(missing)

The following query uses these:

Items: representative assembly (Q2532278)

Properties: subclass of (P279)  
```
select ?item ?Label
where 
{
  ?l wdt:P279 wd:Q2532278 .
	SERVICE wikibase:label { bd:serviceParam wikibase:language "en,de,hu" . ?l rdfs:label ?Label }
}
```

Try it!

Councils in Bergen, Norway (yearly)

The following query uses these:

Items: city council (Q3154693)   , Bergen (Q26793)

Properties: instance of (P31)   , part of (P361)   , inception (P571)   , applies to jurisdiction (P1001)   , official website (P856)   , number of seats (P1342)  
```
#Councils in Bergen, Norway P1001
SELECT ?item ?inception ?place ?LabelEN ?LabelDE ?Label (SAMPLE(?Website) AS ?Website) (COUNT(?Website) AS ?nWebsites) (SAMPLE(?nSeats) AS ?nSeats)
WHERE
{
	?item wdt:P31 wd:Q3154693 .
    ?item wdt:P361 wd:Q26793 .
    ?item wdt:P571 ?inception .
	OPTIONAL{?item wdt:P1001 ?place .}
    #OPTIONAL{?place rdfs:label ?placeLabel .}
    OPTIONAL{?item wdt:P856 ?Website .}
    OPTIONAL{?item wdt:P1342 ?nSeats .}
	SERVICE wikibase:label { bd:serviceParam wikibase:language "hu". ?item rdfs:label ?LabelHU } .
	SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . ?item rdfs:label ?LabelEN } .
	SERVICE wikibase:label { bd:serviceParam wikibase:language "de" . ?item rdfs:label ?LabelDE } .
	SERVICE wikibase:label { bd:serviceParam wikibase:language "fr,ar,be,bg,bn,ca,cs,da,de,el,en,es,et,fa,fi,he,hi,hu,hy,id,it,ja,jv,ko,nb,nl,eo,pa,pl,pt,ro,ru,sh,sk,sr,sv,sw,te,th,tr,uk,yue,vec,vi,zh" 
 . ?item rdfs:label ?Label }
}
GROUP BY ?item ?inception ?place ?LabelEN ?LabelDE ?Label
order by ?inception
```

Try it!

municipal election (Q152450)

https://en.wikipedia.org/wiki/Category:Local_and_municipal_elections

The following query uses these:

Items: municipal election (Q152450)

Properties: instance of (P31)   , start time (P580)   , applies to jurisdiction (P1001)   , official website (P856)   , number of seats (P1342)  
```
#municipal election
SELECT ?item ?start ?place ?LabelEN ?LabelDE ?Label #(SAMPLE(?Website) AS ?Website) (COUNT(?Website) AS ?nWebsites) (SAMPLE(?nSeats) AS ?nSeats)
WHERE
{
	?item wdt:P31 wd:Q152450 .
    OPTIONAL{?item wdt:P580 ?start .}
	#OPTIONAL{?item wdt:P1001 ?place .}
    #OPTIONAL{?place rdfs:label ?placeLabel .}
    OPTIONAL{?item wdt:P856 ?Website .}
    OPTIONAL{?item wdt:P1342 ?nSeats .}
	SERVICE wikibase:label { bd:serviceParam wikibase:language "hu". ?item rdfs:label ?LabelHU } .
	SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . ?item rdfs:label ?LabelEN } .
	SERVICE wikibase:label { bd:serviceParam wikibase:language "de" . ?item rdfs:label ?LabelDE } .
	SERVICE wikibase:label { bd:serviceParam wikibase:language "fr,ar,be,bg,bn,ca,cs,da,de,el,en,es,et,fa,fi,he,hi,hu,hy,id,it,ja,jv,ko,nb,nl,eo,pa,pl,pt,ro,ru,sh,sk,sr,sv,sw,te,th,tr,uk,yue,vec,vi,zh" 
 . ?item rdfs:label ?Label }
}
```

Try it!

public election (Q40231)

public election (Q40231) -> municipal election (Q152450)

list of public election (Q40231)

The following query uses these:

Items: public election (Q40231)

Properties: instance of (P31)   , start time (P580)   , applies to jurisdiction (P1001)   , official website (P856)   , number of seats (P1342)  
```
#municipal election
SELECT ?item ?start ?place ?LabelEN ?LabelDE ?Label #(SAMPLE(?Website) AS ?Website) (COUNT(?Website) AS ?nWebsites) (SAMPLE(?nSeats) AS ?nSeats)
WHERE
{
	?item wdt:P31 wd:Q40231 .
    OPTIONAL{?item wdt:P580 ?start .}
	#OPTIONAL{?item wdt:P1001 ?place .}
    #OPTIONAL{?place rdfs:label ?placeLabel .}
    OPTIONAL{?item wdt:P856 ?Website .}
    OPTIONAL{?item wdt:P1342 ?nSeats .}
	SERVICE wikibase:label { bd:serviceParam wikibase:language "hu". ?item rdfs:label ?LabelHU } .
	SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . ?item rdfs:label ?LabelEN } .
	SERVICE wikibase:label { bd:serviceParam wikibase:language "de" . ?item rdfs:label ?LabelDE } .
	SERVICE wikibase:label { bd:serviceParam wikibase:language "fr,ar,be,bg,bn,ca,cs,da,de,el,en,es,et,fa,fi,he,hi,hu,hy,id,it,ja,jv,ko,nb,nl,eo,pa,pl,pt,ro,ru,sh,sk,sr,sv,sw,te,th,tr,uk,yue,vec,vi,zh" 
 . ?item rdfs:label ?Label }
}
```

Try it!

subclass of (P279)(aka typs) public election (Q40231)

The following query uses these:

Items: public election (Q40231)

Properties: subclass of (P279)   , country (P17)   , start time (P580)   , applies to jurisdiction (P1001)  
```
#election types
SELECT ?item ?start ?country ?countryLabel ?place ?placeLabel ?LabelEN ?LabelDE ?Label
WHERE
{
	?item wdt:P279 wd:Q40231 .
    OPTIONAL{?item wdt:P17 ?country .}
    OPTIONAL{?item wdt:P580 ?start .}
	OPTIONAL{?item wdt:P1001 ?place .}
    #OPTIONAL{?place rdfs:label ?placeLabel .}
	SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . ?item rdfs:label ?LabelEN . ?country rdfs:label ?countryLabel . ?place rdfs:label ?placeLabel } .
	SERVICE wikibase:label { bd:serviceParam wikibase:language "de" . ?item rdfs:label ?LabelDE } .
	SERVICE wikibase:label { bd:serviceParam wikibase:language "fr,ar,be,bg,bn,ca,cs,da,de,el,en,es,et,fa,fi,he,hi,hu,hy,id,it,ja,jv,ko,nb,nl,eo,pa,pl,pt,ro,ru,sh,sk,sr,sv,sw,te,th,tr,uk,yue,vec,vi,zh" 
 . ?item rdfs:label ?Label }
}
ORDER BY ?countryLabel ?placeLabel ?item
```

Try it!

legislature (Q11204)

https://en.wikipedia.org/wiki/Legislature (Infobox [chambers [form of election])
Category:Legislature stubs (Q8586964) (TODO)
parliament (Q35749) <-> council (Q4358176) <-> city council (Q3154693) <-> municipal election (Q152450) (TODO show / maybe wrong items?...)

The following query uses these:

Items: legislature (Q11204)   , electoral system (Q182985)   , democracy (Q7174)

Properties: subclass of (P279)   , part of (P361)  
```
#parliament legislature
SELECT ?item ?LabelEN ?LabelDE ?Label
WHERE
{
	?item wdt:P279 wd:Q11204 .
	?item wdt:P279 wd:Q182985 .
	?item wdt:P361 wd:Q7174 .
	SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . ?item rdfs:label ?LabelEN } .
	SERVICE wikibase:label { bd:serviceParam wikibase:language "de" . ?item rdfs:label ?LabelDE } .
	SERVICE wikibase:label { bd:serviceParam wikibase:language "fr,ar,be,bg,bn,ca,cs,da,de,el,en,es,et,fa,fi,he,hi,hu,hy,id,it,ja,jv,ko,nb,nl,eo,pa,pl,pt,ro,ru,sh,sk,sr,sv,sw,te,th,tr,uk,yue,vec,vi,zh" 
 . ?item rdfs:label ?Label }
}
```

Try it!

unicameralism (Q140247)

The following query uses these:

Items: unicameralism (Q140247)

Properties: instance of (P31)   , applies to jurisdiction (P1001)   , country (P17)  
```
#unicameral parliament legislature
#unicameral parliament legislature
SELECT ?item ?applies_jurisdiction ?LabelEN ?LabelDE ?Label
(GROUP_CONCAT(?applies_jurisdictionLabel; separator=", ") as ?applies_jurisdictionLabels)
(GROUP_CONCAT(?countryLabel; separator=", ") as ?countryLabels)
WHERE
{
	?item wdt:P31 wd:Q140247 .
    OPTIONAL{?item wdt:P1001 ?applies_jurisdiction .}
    OPTIONAL{?item wdt:P17 ?country .}
	SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . ?item rdfs:label ?LabelEN } .
	SERVICE wikibase:label { bd:serviceParam wikibase:language "de" . ?item rdfs:label ?LabelDE } .
	SERVICE wikibase:label { bd:serviceParam wikibase:language "fr,ar,be,bg,bn,ca,cs,da,de,el,en,es,et,fa,fi,he,hi,hu,hy,id,it,ja,jv,ko,nb,nl,eo,pa,pl,pt,ro,ru,sh,sk,sr,sv,sw,te,th,tr,uk,yue,vec,vi,zh" 
 . ?item rdfs:label ?Label . ?applies_jurisdiction rdfs:label ?applies_jurisdictionLabel . ?country rdfs:label ?countryLabel }
}
GROUP BY ?item ?applies_jurisdiction ?LabelEN ?LabelDE ?Label
ORDER BY ?countryLabels ?item 
#LIMIT 100
```