Skip to content
This repository has been archived by the owner on May 8, 2024. It is now read-only.

Party existance #478

Open
BobBorges opened this issue Feb 22, 2024 · 9 comments
Open

Party existance #478

BobBorges opened this issue Feb 22, 2024 · 9 comments

Comments

@BobBorges
Copy link
Collaborator

We need to formalize information on political parties.

  • When a party existed (start/end date) under a particular name
  • A party's successor (i.e. another named party that split [concurrent existence], or is descended directly from)

This will help us with #375 #235 #234 #231 #191

I've taken a first crack at this based on the info that's already in the corpus metadata and wikidata, but I think it needs expert eyes @fredrik1984 (pls tag Lotta).

https://docs.google.com/spreadsheets/d/1_kFX_PMWkGxexjw2Ios6XH_OqjHWb7ITEFjSeV7bVLc/edit?usp=sharing

In the linked doc, you find

  • party_id : a wiki id for a given party, unless there isn't one, then the ID has the format X001, X002, etc
  • party : the official(ish) name
  • inception : date of party's inception -- blank if unknown, year-only dates default to -01-01
  • dissolved : date when party ceased to exist -- blank if unknown, year-only dates default to -01-01, still-existing parties have "Current" as value
  • successor : party_id of ancestor or diverging party (should be in the the sheet too). Multiple successors in list form, e.g. ["X001", "Q1234"]
@MansMeg
Copy link
Collaborator

MansMeg commented Feb 22, 2024

Was this the structure you described @ninpnin ? I think you had an idea of two csvs. One static with party (node) and then a successor file. I think that makes more sense.

@BobBorges
Copy link
Collaborator Author

Per the discussion we just had, this is a merged csv for convenience -- V's structure is the one that will be committed to the corpus.

Should there also be some criteria to decide whether a change is just a name change or if one party becomes another? I think it's a reasonable distinction form the data perspective, but no idea how/if that could be determined practically.

@MansMeg
Copy link
Collaborator

MansMeg commented Feb 22, 2024

I think any real change (e.g. name change) should be a new node. Then, we can add information on the edges (ie the succeeded_by csv file) on whether it is a name change or not (eg a "type" column). Although this might be the next step.

@salgo60
Copy link
Contributor

salgo60 commented Feb 23, 2024

I think any real change (e.g. name change) should be a new node. Then, we can add information on the edges (ie the succeeded_by csv file) on whether it is a name change or not (eg a "type" column). Although this might be the next step.

in wikidata we have used 2 approaches for name changes... the major problem is that wikidata doesnt have core functionality for name changes in the kernel

  1. add qualifiers for start end eg. Q10512441#P2561
image
  1. create new objects for the new names and use "said to be the same as" (P460) example bondeförbundet Q110472693 / centerpartiet Q110832 this works better when we use wikipedia <-> wikidata templates --> we get the correct names in the article but writing Sparql is a nightmare....

@ljo
Copy link
Collaborator

ljo commented Mar 1, 2024

Just a quick note on the vildediscussion, today and last week, and its presence in the spreadsheet. We need to have the vilde information connected to each mp somewhere, since we do not want to end up with unknowns, lumped together vildes or holes in affiliations. But I will check the spreadsheet and the actual contents before I say something more on this. Maybe it is sufficient already. We should also add the QA and signoff columns to some sheets just to warm up regarding the true false was_parliament_party column addition.

@fredrik1984
Copy link
Collaborator

Absolutely, "vilde" will be a party metadata tag. However, exactly what we will name it in the MP database is not yet decided.

@MansMeg
Copy link
Collaborator

MansMeg commented Mar 1, 2024

I think we would use the standard by the Riksdag, at least in Swedish (partilös?).

@salgo60
Copy link
Contributor

salgo60 commented Mar 6, 2024

"Vilde" from a historical perspective

You can check how "vilde" was used in early 1900 I did a SPARQL query that compared the data in wikidata based on the book Tvåkammar-riksdagen 1867–1970 and picture we have scanned in wikicommons from SPA like book "Porträttbok: Riksdagsmän 1894" see GITHUB issue Porträttbook about "vilde" #139

#title: First/Sec chamber members pictures "vilde" how they are presented in "Porträttbooks"
#defaultView:ImageGrid
SELECT DISTINCT ?SWERIK ?file ?wd ?name ?image (CONCAT(?party," ", COALESCE(?timevilde, "")) AS ?vilde) (concat("Book published ",str(year(?booktime))) AS ?bookPublished)
WITH 
{ SELECT distinct ?wd ?name ?itemDescription ?party ?timevilde ?startvilde ?endvilde ?SWERIK  WHERE
  { 
    SERVICE <https://query.wikidata.org/sparql> 
    {
      VALUES ?position { wd:Q81531912 wd:Q33071890 }
      ?wd wdt:P31 wd:Q5;
          wdt:P39 ?position.
      ?wd rdfs:label ?name. FILTER(lang(?name)="sv")
      OPTIONAL {?wd wdt:P12192 ?SWERIK}
      {
       ?wd p:P102 ?PartyWD. 
       ?PartyWD ps:P102 ?p
       OPTIONAL {?PartyWD pq:P580 ?startvilde}
       OPTIONAL {?PartyWD pq:P582 ?endvilde}
       BIND (concat(str(year(?startvilde))," - ", str(year(?endvilde))) AS ?timevilde)
       ?p rdfs:label ?party.
       FILTER(LANG(?party) ="sv").
       FILTER(CONTAINS(?party, 'vilde'))
        SERVICE wikibase:label { bd:serviceParam wikibase:language "sv,en". }
       #FILTER (?wd = wd:Q5555629)
      }
    }
  }
} AS %Wikidataitems

WHERE 
{  INCLUDE %Wikidataitems .
  ?file wdt:P180 ?wd.
  VALUES ?booksP1433 { 
                       wd:Q116445396 # 1894
                       wd:Q110380539 # 1897 
                       wd:Q110380456 # 1900
                       wd:Q110375618 # 1903
                       wd:Q110376088 # 1906 
                       wd:Q116313186 # 1909
                     }
  
   SERVICE <https://query.wikidata.org/sparql> 
    {
      ?booksP1433 wdt:P585 ?booktime
    }
  FILTER (!BOUND(?startvilde) || ?startvilde <= ?booktime)
  #FILTER (?startvilde <= ?booktime)
  FILTER (!BOUND(?endvilde) || ?endvilde >= ?booktime)
  #FILTER (?endvilde >= ?booktime)
  ?file wdt:P1433 ?booksP1433.
  ?file schema:contentUrl ?url. 
  bind(iri(concat("http://commons.wikimedia.org/wiki/Special:FilePath/", wikibase:decodeUri(substr(str(?url),53)))) AS ?image)
} 
order by ?name ?startvilde

Boken Tvåkammar-riksdagen 1867–1970

Använder exempelvis

image image

.....


Marked problematic parties with P5008 = Q120143028 = "Välfärden analyserad - parti"

image image

@salgo60
Copy link
Contributor

salgo60 commented Mar 6, 2024

I guess you have party unknown and opolitisk like Q5973510 =. SWERIK i-NF7MCicvARd9vxeawxGy59 = SBL 10191

image

opolitisk

modelled in WD Q4961261#P102

image image

a bad pattern used I think is done in wikidata with Elsa Widding Q98545439#P102 - sv

image image image

Einzelbewerber - Q1309957

image

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

5 participants