Skip to content

Instantly share code, notes, and snippets.

View salgo60's full-sized avatar
😴

Magnus Sälgö salgo60

😴
42 followers · 19 following
View GitHub Profile
@salgo60
salgo60 / gist:f086090cd3660df2971a2cad5a973d2d
Last active April 26, 2024 10:33
DIGG expert myndigheten granskas efter 4 år av Statskontoret och det är bara kaos... ingen fattar kopplingen med vad dom skall göra med hur saker prioriteras
https://github.com/salgo60/DIGG-skuggbacklog/issues/610
100 myndigheter har under 20 år försökt skapa interoperabilitet mellan sina författningar... inget levererat och Regeringskansliet vet inte ens att dom är ansvariga...
https://github.com/salgo60/LagrummetLight/issues/5
@salgo60
salgo60 / sweriksproj_members.csv
Last active March 7, 2024 11:17
sweriksproj_members see https://github.com/welfare-state-analytics/riksdagen-corpus/issues/484#issuecomment-1980710870
SWERIK author authorLabel orcid githubid www
http://www.wikidata.org/entity/Q116909430 Fredrik Norén 0000-0001-8820-1082 fredrik1984 https://mau.se/personer/fredrik.noren/
http://www.wikidata.org/entity/Q10539524 Jan Teorell 0000-0002-0628-0096 https://www.su.se/english/profiles/jate5800-1.534341
http://www.wikidata.org/entity/Q70220816 Jens Edlund 0000-0001-9327-9482 jensedlund https://www.kth.se/profile/jedlund
http://www.wikidata.org/entity/Q124750643 Johanna Pettersson Fürst 0000-0003-3866-7962 https://www.johannapettersson.se/
http://www.wikidata.org/entity/Q124750694 Josefina Eriksson 0000-0002-6050-1574 https://www.katalog.uu.se/empinfo/?id=N3-971
http://www.wikidata.org/entity/Q116909755 Måns Magnusson 0000-0002-0296-2719 MansMeg https://www.mansmagnusson.com/
http://www.wikidata.org/entity/Q109212996 Pasi Ihalainen 0000-0002-5468-4829 https://www.jyu.fi/en/people/pasi-ihalainen
http://www.wikidata.org/entity/Q6182500 Pelle Snickars 0000-0001-5122-1549 http://pellesnickars.se/
@salgo60
salgo60 / chairs r5ksdagen corpus.html
Created January 22, 2024 13:54
chairs r5ksdagen corpus see https://github.com/welfare-state-analytics/riksdagen-corpus/issues/450
<html>
<head>
<title>Clipboard</title>
<meta charset="utf-8" />
</head>
<body>
<table>
<tr><th>chair_id</th><th>födelsedatum</th><th>dödsdatum</th><th>wd</th><th>wdurl</th><th>parliament_year</th><th>chair_start</th><th>chair_end</th><th>swerik_id</th><th>chamber</th><th>chair_nr</th><th>meta_start</th><th>meta_end</th><th>role</th></tr>
<tr><td><a href="https://www.wikidata.org/wiki/Q5885746">Carl Johansson i Berga</a></td><td>1852-01-14T00:00:00Z</td><td>1917-04-07T00:00:00Z</td><td><a href="https://www.wikidata.org/wiki/Q5885746">Q5885746</a></td><td><a href="https://www.wikidata.org/wiki/Q5885746">https://www.wikidata.org/wiki/Q5885746</a></td><td>1963</td><td></td><td></td><td>i-EZEtDK9JHw3Gk7dkPLEyuw</td><td>ak</td><td>139</td><td></td><td></td><td></td></tr>
<tr><td><a href="https://www.wikidata.org/wiki/Q5886152">Gustav Johansson</a></td><td>1895-03-13T00:00:00Z</td><td>1971-04-09T00:00:00Z</td><td><a href="https://www.wikidata.org/wiki/Q5886152">Q5886152</a></td><td><a href="https://www.wikidata.org/
@salgo60
salgo60 / Wikidata_SPA.py
Created December 11, 2023 18:25
se https://www.facebook.com/permalink.php?story_fbid=pfbid0hMeDBAgxJChT9ecvL1YG12WxTEBDLmeqn8vcubrYYpooPHDxZkZ9KM97tBXbHbaZl&id=100066911568973&__cft__[0]=AZW0QTisXAQupjdGdSDKEmKNqUbfgCtGJGSXEFFegvRdkW_hqHJXWbSyp3zFGUBtovWgqBIEI4xwjTx4tWzhDJVdPiMYsVh2YiKgkq5SMmTw60SScALnapf-eRVismcbdjMcsXV4k8ToLMvoIIJL7VSwiL3jD49wKupmnl4zLqMBmTXbsnYdDQId3u6GgLj8…
# pip install sparqlwrapper
# https://rdflib.github.io/sparqlwrapper/
import sys
from SPARQLWrapper import SPARQLWrapper, JSON
endpoint_url = "https://query.wikidata.org/sparql"
query = """#title: Same as SPA property P4819
SELECT ?person ?personLabel ?SPA ?birth ?death ?birthLocationLabel ?deathLocationLabel
@salgo60
salgo60 / Check anslagstavlor
Created October 26, 2023 10:25
Körde igenom dom url;:ar jag hade till kommunernas anslagstavlor skapade 2022 —> 17 procent fel
# Kommunernas Anslagstavlor
#
import urllib3
import sys
from datetime import datetime
import pandas as pd
http = urllib3.PoolManager()
csv_url = "https://gist.githubusercontent.com/salgo60/3794c5f9eb5e81bb0f1cc9dd164ac1d7/raw/ea579f247971b5e73df9e7af416532a2daed8522/anslagstavla.csv"
@salgo60
salgo60 / anslagstavla.csv
Created October 26, 2023 07:37
Anslagstavlor kommuner skapade 2022 okt
r rLabel oldurl
https://sweopendata.wikibase.cloud/entity/Q241 Härjedalens kommunala Anslagstavla https://www.herjedalen.se/organisation-och-politik/anslagstavla.html
https://sweopendata.wikibase.cloud/entity/Q243 Kavlinge kommuns Digitala Anslagstavla https://www.kavlinge.se/kommun-och-politik/digital-anslagstavla
https://sweopendata.wikibase.cloud/entity/Q244 Jokkmokks kommunala Anslagstavla https://www.jokkmokk.se/kommun-samhalle/kommun-och-Politik/politik-och-delaktighet/anslagstavla/
https://sweopendata.wikibase.cloud/entity/Q245 Hultfreds kommuns Digitala Anslagstavla https://www.hultsfred.se/artikel/anslagstavla/
https://sweopendata.wikibase.cloud/entity/Q247 Götene kommuns Digitala Anslagstavla https://www.gotene.se/anslagstavla
https://sweopendata.wikibase.cloud/entity/Q248 Högsbys kommuns Anslagstavla https://www.hogsby.se/Kommun-och-politik/Anslagstavla-officiell
https://sweopendata.wikibase.cloud/entity/Q249 Torsbys kommuns Anslagstavla https://www.torsby.se/kommunpolitik/overklagabeslutrattssaker
@salgo60
salgo60 / P9495 test länkröta
Last active October 18, 2023 09:23
OK: 31168 not ok 20 procent problem 0.06412722842118763
# P9495
# https://gist.github.com/salgo60/09222815d09c6ed26432e9772acdc62b
#
import urllib3
import sys
from SPARQLWrapper import SPARQLWrapper, JSON
from datetime import datetime
endpoint_url = "https://query.wikidata.org/sparql"
http = urllib3.PoolManager()
@salgo60
salgo60 / Wikidata Svenska Utegym
Last active October 14, 2023 22:39
OK: 1049 not ok 260 procent problem 19.862490450725744
#Utegym check
#
# GITHUB Issue https://github.com/salgo60/ProjectOutdoorGyms/issues/127
#
from datetime import datetime
import urllib3
import sys
from SPARQLWrapper import SPARQLWrapper, JSON
endpoint_url = "https://query.wikidata.org/sparql"
@salgo60
salgo60 / Svenska Utegym Wikidata
Created October 14, 2023 21:49
#Utegym check
#
from datetime import datetime
import urllib3
import sys
from SPARQLWrapper import SPARQLWrapper, JSON
endpoint_url = "https://query.wikidata.org/sparql"
http = urllib3.PoolManager()
@salgo60
salgo60 / SvenskaBadplatser
Last active October 14, 2023 22:48
WIkidata kopplingar - OK: 1348 not ok 359 > 20 procent länkröta på 2 år
#Badplatser check
#
# GITHUB Issue https://github.com/salgo60/Svenskabadplatser/issues/177
#
# https://gist.github.com/salgo60/aaf3f01ceb7668409d3ccc0fc32bc0dd
#
from datetime import datetime
import urllib3
import sys
from SPARQLWrapper import SPARQLWrapper, JSON