Updating and organizing contact data for public bodies in Sweden

[mattiasaxell]

If even one of the many data sources is published as open data, or even on a website that could be scraped, it might be worth the effort to automate the data collection like I did recently for Brazilian data, in order to have a partially updated data set. Additionally, when and if someone has the time and energy to support the data owners in opening up, that would be awesome as well. Anyway, if we need to further discuss the Swedish data,

Hi @augusto-herrmann opening a new issue here about public bodies for Sweden. Currently data can be officially fetched from national authorities registry (unfortunately not open data) and automatically fetch open data from distributions for municipalities and regions.

Maybe the publishers could be open to collaborate on an open source specification which I suggested in #78 and use the EU core vocabulary to release their data. Additionally it would be great to connect it to Wikidata which I suggest to @salgo60 who asked if we could do such a connection for authorities available at the Swedish platform for FOI requests.

Another important aspect is that, from a legal perspective, are authorities nestled within authorities in Sweden and they are currently not seen in the official data sets linked to above. I do not know how to get that data other than working with the authorities to organizing that data as well and getting it into a specification to help Swedish and international authorities organize and publish this data as truthfully and correctly as possible.

[salgo60]

@mattiasaxell

1. cant you take the public bodies from Wikidata ? Some examples what you want then we can help you easier
   some examples Swedish municipalties , Swedish government agency .... video
   1. FYI Wikidata data is CC-0 so its just to use
      1. longer list with phone number, email
2. My suggestion is to create a Wikidata Property Proposal for handlingar.se - I started here link
   1. questions: do we have a regexp for values e.g. compare [a-z0-9]+(-[a-z0-9]+)* used by What_Do_They_Know_organisation_ID

[Ainali]

Currently data can be officially fetched from national authorities registry (unfortunately not open data)

That data is without copyright. I wrote to them and asked if any of the exceptions were applicable and their 'verksjurist' confirmed, after a longer detailed argumentation of each of the exceptions I proposed, that:

Sammanfattningsvis blir min bedömning att myndighetsregistret är en allmän handling som, oavsett vilken bedömning som görs enligt beskrivningen ovan, inte omfattas av upphovsrätt. Detta svar är avstämt med SCB:s chefsjurist.

So I have imported a lot of it to Wikidata already.

[salgo60]

FYI: @mattiasaxell status "Sveriges Kommuner och Regioner (SKR)" dataset

Kontaktuppgifter till kommunerna

2020 did I email the person responsible for the dataset about the license and this was just a test see email answer feels like they are not so interested in sharing this data...

My question was

[salgo60]

@mattiasaxell I used OpenRefine and matched your file with Wikidata see new file with extra fields

• See comments / potential errors
  • version 1 of matched file / raw csv file
  • video
  • Handlingar.se was mentioned on Wikidata weekly but we need your feedback to step forward

[augusto-herrmann]

@mattiasaxell @salgo60 I did some maintenance recently in data/se.csv in order to make it pass data package and schema validation. You might or might not want to take that into consideration if you're going to do a PR.

[mattiasaxell]

Thanks @salgo60! And @augusto-herrmann - thanks, nice of you! Can we harmonize this with the #78 mentioned in #119 and #34?

A proposal from me is to do the following:

• Collaboration between developers of Connect with relevant FOI sites #34 (FragDenStaat & Alaveteli), @Ainali, @augusto-herrmann (any relevant authorities too if possible).

• Pilot an update of data e.g. Sweden https://github.com/okfn/publicbodies/blob/master/data/se.csv and data model according to https://joinup.ec.europa.eu/collection/semantic-interoperability-community-semic/solution/e-government-core-vocabularies

• add relevant additional fields from Wikidata via govdirectory project @Ainali.

• Update data model and enable Wikidata connection for other countries after pilot

[augusto-herrmann]

Hi @mattiasaxell. I found this list of public bodies in Sweden on the website handligar.se. The API page has a link to a CSV file with a list of all authorities.