Add ”Ej biograferade ersättare” to wikidata

[MansMeg]

We should also check these people if they are added in wikidata.

[salgo60]

I extracted the page 551 file see Register över ej biografierade ersättare band 1 02 s 551 looks its better to use the data from "inside the book" as then we get party, electoral district, occupation and birth year ....

• tested a Open refine reconciliation with Wikidata just using the names-> test1

Example

Wikidata	Register page 551	Inside book
		name	electoral district	party	born	occupation	substition	comment
Q117378461	Ahlinder, Lars-Erik, 2:495	Ahlinder, Lars-Erik	Örebro läns valkrets	m	1926	ingenjör.	Ersättare 1984/85 (16.11-18.12.1984)	has signed G802256 = WD Q98008664 --> he is Q117378461
Q5544145	Ahlquist, Bengt, 1:523	Ahlquist, Bengt	Uppsala läns valkrets	fp	1943	informatör	Ersättare 1992/93 (8.3-12.4.1993) och 1993/94 {7.2-31.3.1994)
	Allgulander, Swante, 2:498	Allgulander, Swante	Västerbottens läns valkrets	m	1931	överläkare	Ersättare 1981/82 (12.2-14.3.1982) och 1985/86 (7.5-6.6.1986)
Q107419934	Andersson, Elisabeth, 2:495				1961	lågstadielärare.
saknas men finns på wiki lista	Andersson, Ingela, 1:519	Andersson, Ingela		vpk	1957	Ersättare 1983/84 (26.3-25.5.1984).
Q98415201	Andersson, Krister, 2:496	Andersson, Krister		s	1959	ombudsman	Ersättare 1985/86 (8.5-6.6.1986) och 1987/88 (9.11-20.12.1987)
	Andreasson, Åke, 2:494	Andreasson, Åke		c	1927	lantbrukare	Ersättare 1980/81 (23.4-23.5.1981).
Q3540867	Arnholm, Maria, 1:521	Arnholm, Maria		fp	1958	politisk assistent	Ersättare 1987/88 (16.10-15.11.1987)
Q98556988	Axelsson, Josef, 2:494	Axelsson, Josef		m	1921	kontorist	Ersättare 1977/78 (17.4-3.6.1978) och 1978/79 (20.1-23.2.1979)
Q4937165	Backberger, Barbro, 1:519	Backberger, Barbro		vpk	1932	författare	Ersättare 1974 (23.3-22.4.1974) och 1976/77 (10.1-11.4.1977)
Q110056640	Bengtsson, Carl-Olof, 1:525	Bengtsson, Carl-Olof		s	1947	inspektör
	Bengtsson, Eva, 2:493	Bengtsson, Eva		m p	1928	fru	Ersättare 1990/91 (15.5-14.6.1991)
	Bengtsson, Torsten, 1:526	Bengtsson, Torsten		m	1929	lantmästare	Ersättare 1975/76 (30.10-13.12.1975) och 1976/77 (4.10-10.11.1976).
Q104214628	Berglund, Märtha, 2:495	Berglund, Märtha		s	1943	postmästare	Ersättare 1990/91 (12.11-11.12.1990)
Q4938501	Berglund, Nilsson, Mona, 2:494	Berglund Nilsson,Mona		s	1942	undersköter­ska	RL 1994/95-. Ersättare 1989/90 (16.10-23.11.1989)
Q98271301	Bernal, Loui, 1:524
	Björinge, Jan, 1:521
	Blom, Erik, 1:527
Q98937885/a>	Bodén, Lennart, 2:497
Q117378928	Bolin, Ingrid, 2:496
Q98271096	Bouvin, Ulla, 1:523
Q117467164	Brandoné, Anna, 1:526
	Brorsson, Anita, 2:498
	Budd, Birgitta, 2:496
	Burman, Ingrid, 1:523
	Carlsson, Sivert, 1:525
	Carlsson, Ulla-Britt, 2:495
	Cedell, Silwa, 1:526
	Corshammar-Bojerud, Anna, 1:526
	Dahlstrand, Göran, 1:519
	Danielsson, Sigrid, 2:495
	Davidsson, Inga, 2:496
	Duvskog, Ethel, 1:526
	Edin, Erik, 1:519
	Edvardsson, Berit, 2:498
	Egervärn, Erik, 2:498
	Eliasson, Lennart, 2:496
	Elm, Gunnar, 1:525
	Eriksson, Billy, 1:519
	Eriksson, Bror, 1:523
	von Essen, Anne-Marie, 2:493
	Fredriksson, Conny, 1:525
	Fritzson, Tore, 2:493
	Fägersten, Ingrid, 2:495
	Garstedt, Inge, 1:526
	Genitz, Stig, 2:495
	Gillberg, My, 1:527
	Glansén, Barbro, 2:494
	Granath, Elisabeth, 2:495
	Gunnarsson, Alvar, 1:525
	Gunnarsson, Britta, 1:521
	Gustavsson, Inger, 2:494
	Gylling, Kersti, 1:520
	Hagberg, Michael, 1:524
	Hamilton, Carl-Hugo, 2:496
	Hansson, Birgit, 1:524
	Hartelius, Ingeborg, 1:526
	Hasselgren, Arne, 2:494
	Hedberg, Gertrud, 1:520
	Hedlund, Margareta, 2:498
	Heinemann, Kerstin, 2:496
	Hulth, Anna-Britta, 1:524
	Häggström, Nils, 2:498
	Häll, Christer, 1:524
	Harneman, Lars, 2:494
	Högström, Kenth, 2:497
	Högström, Tomas, 2:496
	Ihrfors, Carl-Johan, 1:520
	Jarlbäck, Nina, 1:524
	Jensfelt, Cecilia, 1:520
	Johansson, John, 1:525
	Jonback, Margareta, 2:496
	Jonsson, Margit, 2:497
	Karlén, Ingvar, 1:523
	Karlsson, Georg, 1:525
	Karlsson, Lars-Olof, 2:495
	Karlsson, Ronny, 1:525
	Klang, Bengt A, 2:495
	Krogvig, Bo, 2:497
	Kung, Andres, 1:526
	Källman, Birgitta, 1:525
	Larsson, Anna-Kerstin, 1:526
	Larsson, Berit, 2:494
	Larsson, Ulla-Britta, 2:497
	Ledin, Bo-Gunnar, 2:498
	Lindblad, Göran, 2:494
	Lindforss, Hans, 2:497
	Lindgren, Anna, 1:524
	Ljunggren, Anders, 1:525
	Lorentzen, Margareta, 2:493
	Lundberg, Kristina, 2:498
	Lundblad, Lena, 1:524
	Lundqvist, Marianne, 1:522
	Löfgren, Ulf, 1:527
	Löfstedt, Marianne, 2:498
	Mahl Karlsson, Gerd, 1:525
	Mattisson, Thor, 2:494
	Mohlin-Erbeus, Berit, 1:526
	Modigh, Mait, 1:520
	Morfidiakis, Emmanuel, 1:526
	Nilsson, Karin, 2: 498
	Nilsson, Lennart, 2:498
	Niva, Vivi, 2:498
	Norberg, Elvy, 2:495
	Norberg, Gunvor, 2:497
	Nordin, Anders, 1:520
	Nygren, Carin, 1:524
	Nylund, Bengt, 2:497
	Ohlsson, Thommy, 2:495
	Olsson, Birger, 2:497
	Olsson, Dick, 1:526
	Olsson, Lars, 1:525
	Petersson, Lars, 1:526
	Pärssinen, Raimo, 2:497
	Ramsell, Siv, 2:497
	Raud, Christina, 2:495
	Rignell, John 2:494
	Ringholm, Bo, 1:521
	Rosengren, Bibi, 1:524
	Salén, Sven H, 1:522
	Salzman, Tomas, 2:496
	Sandberg, Inga, 1:523
	Sandholm, Conny, 1:524
	Sidén, Anita, 2:494
	Sivertun, Ulf, 1:522
	Skansen-Thomasson, Sonia, 2:495
	Skoglund, Sven 2:493
	Strand, Melker, 2:494
	Stråkander, Anna, 1:524
	Svegland, Stina, 2:494
	Svensson, Lilian, 1:527
	Svensson, Rune, 1:527
	Svensson, Åke, 1:525
	Söderpalm-Berndes, Sten, 2:496
	Thomé, Karin, 1:522
	Thoresson, Arne, 2:496
	Thörner, Brivio, 1:525
	Torgerson, Susann, 1:524
	Wadensten, Margit, 2:493
	Waidelich, Tommy, 1:522
	Vallin, Staffan, 1:527
	Wallin, Gunvor, 2:494
	Wallin, Mariana, 2:496
	Weibull, Jörgen, 2:494
	Weinehall, Lars, 2:498
	Wermelin, Anita, 2:497
	Wernebrink, Kalevi, 1:526
	Wernerdal, Bengt, 2:494
	Viitamäki-Carlsson, Seija, 2:497
	Viitanen, Olavi, 2:496
	Vöss-Schrader, Ulla, 1:523
	Örtendahl, Per Anders, 2:494
	Östergren, Karin, 2:497

[salgo60]

@MansMeg we have a WIkidata chat tomorrow 14:00 local time were I will speak with people working more with the Swedish PMs than me how we do this in the best way

• I guess you are "just" happy if you get a Qnumber for each from me....
• I think we should have a source that is that chapter in the book so we can find them with a query ...
• and as said earlier a persistant unique identifier to your data objects would be nice so that we can say same as "Värlfärden analyseras"
  • as I mentioned before I did a try "same as" Riksarkivet archives #104 and those archives should also have same as a person in "Värlfärden analyseras"
  • the process to create Wikidata properties is slow and sometimes never happen because everyone seems t have an opinion
    • a workaround can be that I use a Wikibase were I have my own instance and can add same as and have SPARQL federation with WIkidata...

[MansMeg]

Hi!

1. Yes. Since we work in an iterative step, that is currently our main priority. Because then we will add this to our quality unit test to check that they are included in our database. Although, I'm not sure how we extract the people and import them into our database. But that is probably something we are going to look into in the next couple of weeks.
2. That sounds like a good idea. Referring to the pages in the Enkammarbook is what I would do.
3. Yes. I should file this as an issue. We will probably do this when we release version 1.0 of the corpus. There is still quite some back-and-forth going on now.

[salgo60]

Please close this if you agree its delivered

• #115 Create a file with "ersättare" from the book --> then upload to WIkidata

[MansMeg]

Does this mean that you have added all the ersättare in wikidata now?

[salgo60]

I guess so see 115#issuecomment-1568012110 that was done June 4

SPARQL with ref books pages for substitutes

• SPARQL find all people in Volume 1 and page 519-527 - substitute

• SPARQL find all people in Volume 2 and page 493-498 - substitute

On my TODO list 2023 sep

• walkthrough people in WD that we have as active in First and second chamber and dont have the book "Två kammar Riksdagen" as a source P1433 - is about 340

• did today Q5813810 / diff

[MansMeg]

Yes! Excellent!

[salgo60]

cc: @MansMeg @Lottabrorsson

We marked some people P1214 "no value" --> we think they should be part of Riksdagens Öppna data or have GUID P8388, let me know if you take an action on that

• SPARQL list Riksdagens person-id P1214 = "no value" = https://w.wiki/7TwF

---

• 2019 I meet the people from Riksdagen and we spoke about adding WIkidata id (or Welfare state analytic identifier to the data) no action in this so far but lesson learned is normally it makes sense pointing on each other
  • see my Riksdagens "skuggbacklog" issue #63