website
website copied to clipboard
govdirectory
Alternative approach to topics
The feature
Base topics on field of work (P101) instead of COFOG classification (P9798). I suggest that we create 10 queries that roughly correspond to the top level COFOG classes since that at least seems to be an established way of dividing public organizations.
- [ ] General Public Services
- [ ] Defense
- [ ] Public order and safety
- [ ] Economic affairs
- [x] Environmental protection - https://w.wiki/6QBY
- [ ] Housing and community amenities
- [ ] Health
- [x] Recreation, culture, and religion - https://w.wiki/6VWs
- [ ] Education
- [ ] Social protection
Why?
The topics we have are solid in the sense that they are based on official data on the COFOG classification. The downside is that we have only found a data source for Sweden which means that we are kind of stuck for now.
Examples and inspiration
Here is an example query (which, of course, can be polished) getting organizations broadly working with the environment. It proves that we can get the right organizations and that it is highly flexible. When building this, we can combine that with our already made queries for the organizations, like we do on the statistics page: {{- $orgs := query (join "" "generators/" $country ".rq") -}}.
From today's experiment, of trying to find the intersections between areas and orgs:
Long query link
https://query.wikidata.org/#SELECT%20DISTINCT%20%3Forg%20WHERE%20%7B%0A%20%20VALUES%20%3Forg%20%7B%0A%20%20wd%3AQ384242%0Awd%3AQ731427%0Awd%3AQ741421%0Awd%3AQ750632%0Awd%3AQ783911%0Awd%3AQ836916%0Awd%3AQ909090%0Awd%3AQ953058%0Awd%3AQ1472511%0Awd%3AQ1480245%0Awd%3AQ1670860%0Awd%3AQ1724971%0Awd%3AQ1757535%0Awd%3AQ2445509%0Awd%3AQ2872821%0Awd%3AQ3266836%0Awd%3AQ3357871%0Awd%3AQ3359282%0Awd%3AQ3364776%0Awd%3AQ3371373%0Awd%3AQ3375451%0Awd%3AQ3406485%0Awd%3AQ3430725%0Awd%3AQ3814567%0Awd%3AQ4184946%0Awd%3AQ4411912%0Awd%3AQ4577772%0Awd%3AQ4579704%0Awd%3AQ5185227%0Awd%3AQ5251219%0Awd%3AQ5495902%0Awd%3AQ6744411%0Awd%3AQ6973641%0Awd%3AQ7216254%0Awd%3AQ7654686%0Awd%3AQ7654779%0Awd%3AQ7654780%0Awd%3AQ7654827%0Awd%3AQ10405300%0Awd%3AQ10416948%0Awd%3AQ10422213%0Awd%3AQ10431242%0Awd%3AQ10433405%0Awd%3AQ10436166%0Awd%3AQ10475766%0Awd%3AQ10497349%0Awd%3AQ10498137%0Awd%3AQ10503899%0Awd%3AQ10548698%0Awd%3AQ10571982%0Awd%3AQ10609173%0Awd%3AQ10650489%0Awd%3AQ10669278%0Awd%3AQ10669859%0Awd%3AQ10677662%0Awd%3AQ10677682%0Awd%3AQ10677718%0Awd%3AQ10677716%0Awd%3AQ10677726%0Awd%3AQ10677737%0Awd%3AQ10677795%0Awd%3AQ10685405%0Awd%3AQ10701016%0Awd%3AQ18386866%0Awd%3AQ22269242%0Awd%3AQ22269305%0Awd%3AQ22276465%0Awd%3AQ22294590%0Awd%3AQ25349864%0Awd%3AQ25386980%0Awd%3AQ26236697%0Awd%3AQ26236702%0Awd%3AQ26236700%0Awd%3AQ28746121%0Awd%3AQ28752352%0Awd%3AQ28792244%0Awd%3AQ28792253%0Awd%3AQ28797491%0Awd%3AQ28797492%0Awd%3AQ28797497%0Awd%3AQ28797500%0Awd%3AQ28804178%0Awd%3AQ28804179%0Awd%3AQ28804182%0Awd%3AQ33075406%0Awd%3AQ33075484%0Awd%3AQ33075523%0Awd%3AQ33075625%0Awd%3AQ33075659%0Awd%3AQ56302089%0Awd%3AQ60942149%0Awd%3AQ80207132%0Awd%3AQ80207140%0Awd%3AQ80207147%0Awd%3AQ80224507%0Awd%3AQ80224509%0Awd%3AQ80224512%0Awd%3AQ101113144%0Awd%3AQ106052713%0Awd%3AQ198678%0Awd%3AQ474816%0Awd%3AQ845497%0Awd%3AQ891249%0Awd%3AQ1172261%0Awd%3AQ1331110%0Awd%3AQ1677108%0Awd%3AQ1782920%0Awd%3AQ1788830%0Awd%3AQ2858096%0Awd%3AQ2983328%0Awd%3AQ3370919%0Awd%3AQ3563936%0Awd%3AQ4355568%0Awd%3AQ4931380%0Awd%3AQ5449671%0Awd%3AQ6971047%0Awd%3AQ6972528%0Awd%3AQ6972720%0Awd%3AQ7061065%0Awd%3AQ7395171%0Awd%3AQ7654606%0Awd%3AQ7654818%0Awd%3AQ10416979%0Awd%3AQ10432198%0Awd%3AQ10480779%0Awd%3AQ10482004%0Awd%3AQ10484099%0Awd%3AQ10484100%0Awd%3AQ10489099%0Awd%3AQ10493897%0Awd%3AQ10507703%0Awd%3AQ10512316%0Awd%3AQ10512455%0Awd%3AQ10512917%0Awd%3AQ10516522%0Awd%3AQ10517578%0Awd%3AQ10520566%0Awd%3AQ10526699%0Awd%3AQ10526700%0Awd%3AQ10526701%0Awd%3AQ10526865%0Awd%3AQ10531831%0Awd%3AQ10536076%0Awd%3AQ10542135%0Awd%3AQ10542874%0Awd%3AQ10543166%0Awd%3AQ10543167%0Awd%3AQ10543164%0Awd%3AQ10543165%0Awd%3AQ10547348%0Awd%3AQ10562812%0Awd%3AQ10569896%0Awd%3AQ10570645%0Awd%3AQ10570852%0Awd%3AQ10571252%0Awd%3AQ10579266%0Awd%3AQ10588915%0Awd%3AQ10591753%0Awd%3AQ10593934%0Awd%3AQ10602829%0Awd%3AQ10602970%0Awd%3AQ10603347%0Awd%3AQ10604763%0Awd%3AQ10621662%0Awd%3AQ10651551%0Awd%3AQ10658527%0Awd%3AQ10658525%0Awd%3AQ10658535%0Awd%3AQ10658655%0Awd%3AQ10669780%0Awd%3AQ10670001%0Awd%3AQ10670401%0Awd%3AQ10673315%0Awd%3AQ10677733%0Awd%3AQ10680671%0Awd%3AQ10683855%0Awd%3AQ10687953%0Awd%3AQ10688816%0Awd%3AQ10688835%0Awd%3AQ10701323%0Awd%3AQ10708427%0Awd%3AQ10709206%0Awd%3AQ10710259%0Awd%3AQ10712935%0Awd%3AQ10717357%0Awd%3AQ10717670%0Awd%3AQ10718192%0Awd%3AQ10723797%0Awd%3AQ10726549%0Awd%3AQ10727496%0Awd%3AQ10728135%0Awd%3AQ11995938%0Awd%3AQ15209927%0Awd%3AQ18291386%0Awd%3AQ18335025%0Awd%3AQ26253184%0Awd%3AQ60970301%0Awd%3AQ80207128%0Awd%3AQ80207153%0Awd%3AQ3372219%0Awd%3AQ3440237%0Awd%3AQ4585222%0Awd%3AQ6305559%0Awd%3AQ10536054%0Awd%3AQ10536052%0Awd%3AQ10591748%0Awd%3AQ10623228%0Awd%3AQ10670160%0Awd%3AQ10670482%0Awd%3AQ10677686%0Awd%3AQ10728611%0Awd%3AQ18290844%0Awd%3AQ18292430%0Awd%3AQ30256613%0Awd%3AQ47011663%0Awd%3AQ185246%0Awd%3AQ218506%0Awd%3AQ219564%0Awd%3AQ221645%0Awd%3AQ371522%0Awd%3AQ502824%0Awd%3AQ502842%0Awd%3AQ537526%0Awd%3AQ631844%0Awd%3AQ782600%0Awd%3AQ842858%0Awd%3AQ854280%0Awd%3AQ895355%0Awd%3AQ977781%0Awd%3AQ1144565%0Awd%3AQ1163548%0Awd%3AQ1274511%0Awd%3AQ1312762%0Awd%3AQ1420103%0Awd%3AQ1439258%0Awd%3AQ1464114%0Awd%3AQ1546159%0Awd%3AQ1558323%0Awd%3AQ1622088%0Awd%3AQ1751928%0Awd%3AQ1782926%0Awd%3AQ1796144%0Awd%3AQ1858061%0Awd%3AQ1879124%0Awd%3AQ1940803%0Awd%3AQ1972721%0Awd%3AQ2002420%0Awd%3AQ2292839%0Awd%3AQ2324548%0Awd%3AQ2509723%0Awd%3AQ2976522%0Awd%3AQ3110979%0Awd%3AQ3355352%0Awd%3AQ4356728%0Awd%3AQ4356777%0Awd%3AQ5625923%0Awd%3AQ6971056%0Awd%3AQ6971083%0Awd%3AQ7654721%0Awd%3AQ7894643%0Awd%3AQ8437714%0Awd%3AQ10405389%0Awd%3AQ10413037%0Awd%3AQ10494944%0Awd%3AQ10497831%0Awd%3AQ10518645%0Awd%3AQ10536053%0Awd%3AQ10544771%0Awd%3AQ10547725%0Awd%3AQ10551862%0Awd%3AQ10591749%0Awd%3AQ10591754%0Awd%3AQ10591752%0Awd%3AQ10591756%0Awd%3AQ10605067%0Awd%3AQ10605070%0Awd%3AQ10605071%0Awd%3AQ10605072%0Awd%3AQ10635976%0Awd%3AQ10660879%0Awd%3AQ10674565%0Awd%3AQ10677666%0Awd%3AQ10677678%0Awd%3AQ10677676%0Awd%3AQ10677691%0Awd%3AQ10677695%0Awd%3AQ10677698%0Awd%3AQ10677697%0Awd%3AQ10677702%0Awd%3AQ10677700%0Awd%3AQ10677721%0Awd%3AQ10690203%0Awd%3AQ10690573%0Awd%3AQ10709560%0Awd%3AQ10709720%0Awd%3AQ10728612%0Awd%3AQ15278226%0Awd%3AQ15295883%0Awd%3AQ15694964%0Awd%3AQ17518896%0Awd%3AQ18449197%0Awd%3AQ31885102%0Awd%3AQ65195567%0Awd%3AQ80207100%0Awd%3AQ80207104%0Awd%3AQ80207105%0Awd%3AQ80207112%0Awd%3AQ80207119%0Awd%3AQ80207116%0Awd%3AQ80207121%0Awd%3AQ80207124%0Awd%3AQ80207143%0Awd%3AQ80207145%0Awd%3AQ80207151%0Awd%3AQ80224515%0Awd%3AQ109010%0Awd%3AQ113673%0Awd%3AQ113679%0Awd%3AQ113692%0Awd%3AQ113730%0Awd%3AQ117091%0Awd%3AQ117728%0Awd%3AQ123855%0Awd%3AQ125222%0Awd%3AQ132334%0Awd%3AQ145835%0Awd%3AQ149539%0Awd%3AQ177019%0Awd%3AQ179180%0Awd%3AQ182007%0Awd%3AQ186230%0Awd%3AQ186662%0Awd%3AQ201813%0Awd%3AQ209634%0Awd%3AQ214048%0Awd%3AQ216915%0Awd%3AQ220881%0Awd%3AQ221990%0Awd%3AQ239332%0Awd%3AQ240574%0Awd%3AQ249378%0Awd%3AQ254799%0Awd%3AQ255025%0Awd%3AQ255206%0Awd%3AQ266401%0Awd%3AQ267030%0Awd%3AQ267462%0Awd%3AQ271079%0Awd%3AQ271107%0Awd%3AQ271153%0Awd%3AQ271340%0Awd%3AQ280562%0Awd%3AQ285894%0Awd%3AQ287484%0Awd%3AQ293928%0Awd%3AQ293970%0Awd%3AQ297936%0Awd%3AQ298003%0Awd%3AQ301259%0Awd%3AQ306789%0Awd%3AQ307370%0Awd%3AQ307569%0Awd%3AQ307603%0Awd%3AQ338752%0Awd%3AQ374794%0Awd%3AQ376003%0Awd%3AQ382808%0Awd%3AQ389040%0Awd%3AQ427422%0Awd%3AQ427991%0Awd%3AQ428749%0Awd%3AQ430780%0Awd%3AQ431271%0Awd%3AQ487502%0Awd%3AQ487648%0Awd%3AQ492575%0Awd%3AQ492614%0Awd%3AQ493066%0Awd%3AQ493815%0Awd%3AQ493841%0Awd%3AQ493855%0Awd%3AQ498447%0Awd%3AQ498453%0Awd%3AQ498470%0Awd%3AQ498477%0Awd%3AQ498857%0Awd%3AQ499359%0Awd%3AQ499380%0Awd%3AQ499385%0Awd%3AQ499393%0Awd%3AQ499404%0Awd%3AQ499410%0Awd%3AQ499415%0Awd%3AQ499421%0Awd%3AQ499425%0Awd%3AQ499435%0Awd%3AQ499441%0Awd%3AQ499460%0Awd%3AQ499464%0Awd%3AQ499474%0Awd%3AQ500071%0Awd%3AQ500125%0Awd%3AQ500153%0Awd%3AQ500217%0Awd%3AQ501205%0Awd%3AQ501420%0Awd%3AQ501424%0Awd%3AQ501432%0Awd%3AQ501438%0Awd%3AQ501442%0Awd%3AQ501448%0Awd%3AQ501452%0Awd%3AQ501459%0Awd%3AQ501463%0Awd%3AQ501470%0Awd%3AQ501479%0Awd%3AQ501487%0Awd%3AQ501494%0Awd%3AQ501526%0Awd%3AQ501532%0Awd%3AQ501540%0Awd%3AQ501545%0Awd%3AQ501551%0Awd%3AQ502298%0Awd%3AQ503102%0Awd%3AQ503111%0Awd%3AQ503122%0Awd%3AQ503127%0Awd%3AQ503132%0Awd%3AQ503144%0Awd%3AQ503148%0Awd%3AQ503162%0Awd%3AQ503167%0Awd%3AQ503173%0Awd%3AQ503180%0Awd%3AQ503184%0Awd%3AQ503188%0Awd%3AQ503193%0Awd%3AQ503198%0Awd%3AQ503204%0Awd%3AQ503209%0Awd%3AQ503214%0Awd%3AQ503361%0Awd%3AQ503746%0Awd%3AQ504219%0Awd%3AQ504227%0Awd%3AQ504235%0Awd%3AQ504239%0Awd%3AQ504244%0Awd%3AQ504249%0Awd%3AQ504257%0Awd%3AQ504261%0Awd%3AQ504266%0Awd%3AQ504465%0Awd%3AQ504505%0Awd%3AQ504594%0Awd%3AQ504601%0Awd%3AQ504609%0Awd%3AQ504614%0Awd%3AQ504619%0Awd%3AQ504626%0Awd%3AQ504630%0Awd%3AQ504676%0Awd%3AQ504689%0Awd%3AQ504692%0Awd%3AQ504983%0Awd%3AQ504988%0Awd%3AQ504994%0Awd%3AQ505006%0Awd%3AQ505013%0Awd%3AQ505018%0Awd%3AQ505046%0Awd%3AQ505052%0Awd%3AQ505057%0Awd%3AQ505064%0Awd%3AQ505071%0Awd%3AQ505076%0Awd%3AQ505085%0Awd%3AQ505090%0Awd%3AQ505096%0Awd%3AQ505102%0Awd%3AQ505109%0Awd%3AQ505239%0Awd%3AQ505246%0Awd%3AQ505259%0Awd%3AQ505936%0Awd%3AQ506250%0Awd%3AQ507656%0Awd%3AQ507670%0Awd%3AQ507684%0Awd%3AQ507709%0Awd%3AQ508125%0Awd%3AQ508140%0Awd%3AQ508153%0Awd%3AQ508168%0Awd%3AQ508180%0Awd%3AQ509452%0Awd%3AQ509469%0Awd%3AQ509476%0Awd%3AQ509488%0Awd%3AQ509501%0Awd%3AQ509514%0Awd%3AQ509546%0Awd%3AQ509568%0Awd%3AQ509609%0Awd%3AQ509634%0Awd%3AQ509651%0Awd%3AQ509997%0Awd%3AQ510010%0Awd%3AQ510135%0Awd%3AQ510198%0Awd%3AQ510223%0Awd%3AQ510233%0Awd%3AQ510310%0Awd%3AQ510364%0Awd%3AQ511228%0Awd%3AQ511241%0Awd%3AQ511253%0Awd%3AQ511270%0Awd%3AQ511281%0Awd%3AQ511297%0Awd%3AQ511310%0Awd%3AQ511326%0Awd%3AQ511338%0Awd%3AQ511365%0Awd%3AQ511394%0Awd%3AQ511407%0Awd%3AQ511426%0Awd%3AQ511438%0Awd%3AQ512002%0Awd%3AQ512035%0Awd%3AQ512048%0Awd%3AQ513370%0Awd%3AQ513421%0Awd%3AQ514707%0Awd%3AQ514722%0Awd%3AQ514739%0Awd%3AQ514756%0Awd%3AQ514770%0Awd%3AQ514805%0Awd%3AQ514815%0Awd%3AQ514830%0Awd%3AQ514858%0Awd%3AQ515235%0Awd%3AQ515250%0Awd%3AQ515266%0Awd%3AQ515282%0Awd%3AQ515299%0Awd%3AQ515318%0Awd%3AQ515326%0Awd%3AQ515342%0Awd%3AQ515358%0Awd%3AQ515373%0Awd%3AQ515409%0Awd%3AQ515477%0Awd%3AQ515491%0Awd%3AQ515505%0Awd%3AQ515519%0Awd%3AQ515551%0Awd%3AQ515680%0Awd%3AQ515699%0Awd%3AQ515706%0Awd%3AQ515861%0Awd%3AQ515969%0Awd%3AQ516080%0Awd%3AQ516308%0Awd%3AQ564652%0Awd%3AQ605329%0Awd%3AQ776570%0Awd%3AQ845930%0Awd%3AQ946647%0Awd%3AQ948462%0Awd%3AQ972564%0Awd%3AQ1128384%0Awd%3AQ1130264%0Awd%3AQ1345439%0Awd%3AQ1428725%0Awd%3AQ1592140%0Awd%3AQ1774229%0Awd%3AQ1780908%0Awd%3AQ2611987%0Awd%3AQ2611994%0Awd%3AQ2612011%0Awd%3AQ2642771%0Awd%3AQ2777887%0Awd%3AQ2841849%0Awd%3AQ2841853%0Awd%3AQ2982160%0Awd%3AQ3120654%0Awd%3AQ3231208%0Awd%3AQ3231325%0Awd%3AQ3231382%0Awd%3AQ3231587%0Awd%3AQ3231675%0Awd%3AQ3231752%0Awd%3AQ3231840%0Awd%3AQ3231915%0Awd%3AQ3232003%0Awd%3AQ3232072%0Awd%3AQ3232214%0Awd%3AQ3232292%0Awd%3AQ3232501%0Awd%3AQ3232565%0Awd%3AQ3233188%0Awd%3AQ3233375%0Awd%3AQ3233447%0Awd%3AQ3233521%0Awd%3AQ3434606%0Awd%3AQ4294535%0Awd%3AQ4374091%0Awd%3AQ5369875%0Awd%3AQ5369872%0Awd%3AQ5369873%0Awd%3AQ5369876%0Awd%3AQ106341986%0Awd%3AQ107157415%0Awd%3AQ108058370%0Awd%3AQ108058371%0Awd%3AQ108058375%0Awd%3AQ108059419%0Awd%3AQ108059417%0Awd%3AQ108059435%0Awd%3AQ108059436%0Awd%3AQ108059437%0Awd%3AQ114566702%0Awd%3AQ114772420%0Awd%3AQ116024923%0Awd%3AQ116035262%0Awd%3AQ120633743%0Awd%3AQ27982%0Awd%3AQ28532%0Awd%3AQ29963%0Awd%3AQ34078%0Awd%3AQ34550%0Awd%3AQ37399%0Awd%3AQ37404%0Awd%3AQ37462%0Awd%3AQ42009%0Awd%3AQ47018%0Awd%3AQ47019%0Awd%3AQ47169%0Awd%3AQ52502%0Awd%3AQ59093%0Awd%3AQ59858%0Awd%3AQ62464%0Awd%3AQ62469%0Awd%3AQ5369877%0Awd%3AQ7654775%0Awd%3AQ8100253%0Awd%3AQ9149608%0Awd%3AQ10444871%0Awd%3AQ10655165%0Awd%3AQ10655176%0Awd%3AQ10685886%0Awd%3AQ10685995%0Awd%3AQ10685998%0Awd%3AQ10685999%0Awd%3AQ10685997%0Awd%3AQ10686002%0Awd%3AQ10686003%0Awd%3AQ10686001%0Awd%3AQ10686007%0Awd%3AQ10686004%0Awd%3AQ10686005%0Awd%3AQ10686010%0Awd%3AQ10686011%0Awd%3AQ10686008%0Awd%3AQ10686009%0Awd%3AQ10686014%0Awd%3AQ10686015%0Awd%3AQ10686012%0Awd%3AQ10686018%0Awd%3AQ10686019%0Awd%3AQ10686016%0Awd%3AQ10686017%0Awd%3AQ10686023%0Awd%3AQ10686020%0Awd%3AQ10686021%0Awd%3AQ10686026%0Awd%3AQ10686027%0Awd%3AQ10686024%0Awd%3AQ10686025%0Awd%3AQ10686028%0Awd%3AQ11285861%0Awd%3AQ15734586%0Awd%3AQ16891010%0Awd%3AQ17049339%0Awd%3AQ17561300%0Awd%3AQ17642365%0Awd%3AQ17642675%0Awd%3AQ17642830%0Awd%3AQ17643006%0Awd%3AQ17643116%0Awd%3AQ17643696%0Awd%3AQ18333491%0Awd%3AQ18333494%0Awd%3AQ18333495%0Awd%3AQ18333492%0Awd%3AQ18333498%0Awd%3AQ18333497%0Awd%3AQ18333503%0Awd%3AQ18333500%0Awd%3AQ18333501%0Awd%3AQ18333511%0Awd%3AQ18333508%0Awd%3AQ18333509%0Awd%3AQ18333514%0Awd%3AQ18333518%0Awd%3AQ18333519%0Awd%3AQ18333516%0Awd%3AQ18333523%0Awd%3AQ18333521%0Awd%3AQ18333526%0Awd%3AQ18333527%0Awd%3AQ18333524%0Awd%3AQ18333530%0Awd%3AQ18333529%0Awd%3AQ18333534%0Awd%3AQ18333532%0Awd%3AQ18333539%0Awd%3AQ18333536%0Awd%3AQ18333537%0Awd%3AQ18333543%0Awd%3AQ18333540%0Awd%3AQ18333541%0Awd%3AQ18333545%0Awd%3AQ18449202%0Awd%3AQ18449201%0Awd%3AQ18449207%0Awd%3AQ18449210%0Awd%3AQ18449209%0Awd%3AQ18449212%0Awd%3AQ18747057%0Awd%3AQ19978223%0Awd%3AQ27588313%0Awd%3AQ27588337%0Awd%3AQ27588394%0Awd%3AQ29042839%0Awd%3AQ60970996%0Awd%3AQ64868083%0Awd%3AQ97143442%0Awd%3AQ97143443%0Awd%3AQ97143441%0Awd%3AQ97143444%0Awd%3AQ99228758%0Awd%3AQ101070007%0Awd%3AQ10475844%0A%20%20%7D%0A%20%20%0A%20%20VALUES%20%3Farea%20%7B%0A%20%20%20%20%20wd%3AQ219416%0Awd%3AQ832237%0Awd%3AQ43619%0Awd%3AQ125928%0Awd%3AQ7937%0Awd%3AQ7942%0Awd%3AQ186568%0Awd%3AQ1531731%0Awd%3AQ11548048%0Awd%3AQ117424688%0Awd%3AQ898653%0Awd%3AQ116458452%0Awd%3AQ3230%0Awd%3AQ4421%0Awd%3AQ8514%0Awd%3AQ37813%0Awd%3AQ52105%0Awd%3AQ188460%0Awd%3AQ192355%0Awd%3AQ386426%0Awd%3AQ1138571%0Awd%3AQ952151%0Awd%3AQ13861074%0Awd%3AQ17076830%0Awd%3AQ56063389%0Awd%3AQ65080796%0Awd%3AQ66371845%0Awd%3AQ12705%0Awd%3AQ185035%0Awd%3AQ655870%0Awd%3AQ1344240%0Awd%3AQ1509111%0Awd%3AQ1962383%0Awd%3AQ2751054%0Awd%3AQ3104554%0Awd%3AQ5333882%0Awd%3AQ20113959%0Awd%3AQ76737185%0Awd%3AQ104693783%0Awd%3AQ295754%0Awd%3AQ1428108%0Awd%3AQ26857940%0Awd%3AQ55693915%0Awd%3AQ59351530%0Awd%3AQ5377037%0Awd%3AQ7113626%0Awd%3AQ7649547%0Awd%3AQ17022385%0Awd%3AQ104596535%0Awd%3AQ108304680%0Awd%3AQ111317919%0Awd%3AQ132580%0Awd%3AQ288142%0Awd%3AQ474722%0Awd%3AQ628403%0Awd%3AQ994042%0Awd%3AQ5413422%0Awd%3AQ6753176%0Awd%3AQ7294372%0Awd%3AQ7315837%0Awd%3AQ7846181%0Awd%3AQ22661680%0Awd%3AQ65246763%0Awd%3AQ109984809%0Awd%3AQ110350758%0Awd%3AQ111326284%0Awd%3AQ116168217%0Awd%3AQ23200%0Awd%3AQ377829%0Awd%3AQ532497%0Awd%3AQ1639168%0Awd%3AQ1771431%0Awd%3AQ2383046%0Awd%3AQ2411280%0Awd%3AQ2429868%0Awd%3AQ2979132%0Awd%3AQ2979135%0Awd%3AQ2979136%0Awd%3AQ2979138%0Awd%3AQ2979142%0Awd%3AQ2979143%0Awd%3AQ2979145%0Awd%3AQ2979146%0Awd%3AQ2979148%0Awd%3AQ2979149%0Awd%3AQ2979151%0Awd%3AQ2979152%0Awd%3AQ2979153%0Awd%3AQ2979155%0Awd%3AQ2979156%0Awd%3AQ2979159%0Awd%3AQ2979161%0Awd%3AQ2979163%0Awd%3AQ2979165%0Awd%3AQ2979166%0Awd%3AQ2979168%0Awd%3AQ2979169%0Awd%3AQ2979172%0Awd%3AQ2979175%0Awd%3AQ2979176%0Awd%3AQ2979180%0Awd%3AQ2979181%0Awd%3AQ2979183%0Awd%3AQ2979184%0Awd%3AQ2979187%0Awd%3AQ2979188%0Awd%3AQ2979189%0Awd%3AQ2979191%0Awd%3AQ2979193%0Awd%3AQ2979195%0Awd%3AQ2979196%0Awd%3AQ2979198%0Awd%3AQ2979199%0Awd%3AQ2979202%0Awd%3AQ2979204%0Awd%3AQ2979205%0Awd%3AQ2979207%0Awd%3AQ2979209%0Awd%3AQ2979210%0Awd%3AQ2979211%0Awd%3AQ2979213%0Awd%3AQ2979215%0Awd%3AQ2979216%0Awd%3AQ2979217%0Awd%3AQ2979218%0Awd%3AQ3680726%0Awd%3AQ4223616%0Awd%3AQ4223617%0Awd%3AQ5133554%0Awd%3AQ5476831%0Awd%3AQ5772606%0Awd%3AQ5772608%0Awd%3AQ6116160%0Awd%3AQ10726724%0Awd%3AQ12045925%0Awd%3AQ16023922%0Awd%3AQ16481073%0Awd%3AQ16540405%0Awd%3AQ16540409%0Awd%3AQ16540413%0Awd%3AQ17176372%0Awd%3AQ17354331%0Awd%3AQ18398345%0Awd%3AQ19544142%0Awd%3AQ19703898%0Awd%3AQ21027474%0Awd%3AQ22969167%0Awd%3AQ23056321%0Awd%3AQ23793233%0Awd%3AQ28496049%0Awd%3AQ30753771%0Awd%3AQ30753789%0Awd%3AQ48749417%0Awd%3AQ48756017%0Awd%3AQ53416626%0Awd%3AQ56307584%0Awd%3AQ60743411%0Awd%3AQ64632101%0Awd%3AQ64853043%0Awd%3AQ97166686%0Awd%3AQ97166698%0Awd%3AQ97166709%0Awd%3AQ97166723%0Awd%3AQ97166737%0Awd%3AQ97166744%0Awd%3AQ97166756%0Awd%3AQ97166774%0Awd%3AQ23190%0Awd%3AQ135712%0Awd%3AQ185005%0Awd%3AQ193372%0Awd%3AQ729130%0Awd%3AQ946376%0Awd%3AQ1049930%0Awd%3AQ1318388%0Awd%3AQ1330709%0Awd%3AQ1852115%0Awd%3AQ2979258%0Awd%3AQ4071772%0Awd%3AQ4318435%0Awd%3AQ5772669%0Awd%3AQ9776261%0Awd%3AQ10582207%0Awd%3AQ10899248%0Awd%3AQ11548050%0Awd%3AQ13542674%0Awd%3AQ15720660%0Awd%3AQ15853657%0Awd%3AQ18625814%0Awd%3AQ19347392%0Awd%3AQ25378276%0Awd%3AQ38554945%0Awd%3AQ41073808%0Awd%3AQ46997958%0Awd%3AQ96199401%0Awd%3AQ107353656%0Awd%3AQ109018616%0Awd%3AQ110740038%0Awd%3AQ112159149%0Awd%3AQ115958789%0Awd%3AQ122933063%0Awd%3AQ5133480%0Awd%3AQ5133486%0Awd%3AQ12624525%0Awd%3AQ17072637%0Awd%3AQ56310580%0Awd%3AQ116471631%0Awd%3AQ116478403%0Awd%3AQ116478604%0Awd%3AQ116478710%0Awd%3AQ116478848%0Awd%3AQ120999124%0Awd%3AQ2639987%0Awd%3AQ9284853%0Awd%3AQ47338901%0Awd%3AQ116621785%0Awd%3AQ120273237%0Awd%3AQ120736213%0Awd%3AQ2072995%0Awd%3AQ2956049%0Awd%3AQ3738986%0Awd%3AQ5133467%0Awd%3AQ5133470%0Awd%3AQ5133473%0Awd%3AQ5133474%0Awd%3AQ5133476%0Awd%3AQ5133479%0Awd%3AQ5133485%0Awd%3AQ5133487%0Awd%3AQ5133490%0Awd%3AQ5133491%0Awd%3AQ5133493%0Awd%3AQ5133500%0Awd%3AQ5133502%0Awd%3AQ5251686%0Awd%3AQ7888355%0Awd%3AQ16958766%0Awd%3AQ18347955%0Awd%3AQ20056111%0Awd%3AQ27095116%0Awd%3AQ41073913%0Awd%3AQ59753564%0Awd%3AQ60760913%0Awd%3AQ65064496%0Awd%3AQ65067165%0Awd%3AQ83601539%0Awd%3AQ101421920%0Awd%3AQ106818608%0Awd%3AQ111465229%0Awd%3AQ111550147%0Awd%3AQ113686300%0Awd%3AQ114131564%0Awd%3AQ115299495%0Awd%3AQ116457071%0Awd%3AQ116478753%0Awd%3AQ117829020%0Awd%3AQ118640114%0Awd%3AQ131201%0Awd%3AQ594912%0Awd%3AQ3196463%0Awd%3AQ3569631%0Awd%3AQ5172498%0Awd%3AQ1094124%0Awd%3AQ1295972%0Awd%3AQ1972054%0Awd%3AQ2895105%0Awd%3AQ2979186%0Awd%3AQ3523878%0Awd%3AQ3680730%0Awd%3AQ4223568%0Awd%3AQ4445068%0Awd%3AQ5133550%0Awd%3AQ6764294%0Awd%3AQ8346922%0Awd%3AQ8351633%0Awd%3AQ9008429%0Awd%3AQ9053198%0Awd%3AQ10855354%0Awd%3AQ11704143%0Awd%3AQ11914003%0Awd%3AQ11914110%0Awd%3AQ11914115%0Awd%3AQ11938253%0Awd%3AQ11949928%0Awd%3AQ12245147%0Awd%3AQ14212031%0Awd%3AQ21086259%0Awd%3AQ21086282%0Awd%3AQ23807321%0Awd%3AQ30325011%0Awd%3AQ47137733%0Awd%3AQ55658197%0Awd%3AQ56196714%0Awd%3AQ72869285%0Awd%3AQ76763331%0Awd%3AQ105703592%0Awd%3AQ117350121%0Awd%3AQ117350130%0Awd%3AQ118368731%0Awd%3AQ118905815%0Awd%3AQ120372819%0Awd%3AQ120401011%0Awd%3AQ120450548%0Awd%3AQ120483999%0Awd%3AQ120550851%0Awd%3AQ120664010%0Awd%3AQ120665397%0Awd%3AQ121910589%0Awd%3AQ116457207%0Awd%3AQ5001522%0Awd%3AQ28499116%0Awd%3AQ115821599%0Awd%3AQ121141276%0Awd%3AQ122789801%0Awd%3AQ55826%0Awd%3AQ1346260%0Awd%3AQ3040178%0Awd%3AQ4599196%0Awd%3AQ5044049%0Awd%3AQ20673277%0Awd%3AQ22683784%0Awd%3AQ25060463%0Awd%3AQ96376913%0Awd%3AQ115898220%0Awd%3AQ117213734%0Awd%3AQ120170619%0Awd%3AQ120170813%0Awd%3AQ121031373%0Awd%3AQ121159438%0Awd%3AQ121912285%0Awd%3AQ84030626%0Awd%3AQ103824308%0Awd%3AQ105967733%0Awd%3AQ106366874%0Awd%3AQ111343678%0Awd%3AQ117813887%0Awd%3AQ117844861%0Awd%3AQ121460912%0Awd%3AQ116447963%0Awd%3AQ116878959%0Awd%3AQ117304857%0Awd%3AQ117823104%0Awd%3AQ118602111%0Awd%3AQ119521576%0Awd%3AQ121116028%0Awd%3AQ523256%0Awd%3AQ613856%0Awd%3AQ786773%0Awd%3AQ846574%0Awd%3AQ903758%0Awd%3AQ1853339%0Awd%3AQ5603535%0Awd%3AQ7649683%0Awd%3AQ58966125%0Awd%3AQ105974623%0Awd%3AQ114048594%0Awd%3AQ118121339%0Awd%3AQ121072817%0Awd%3AQ10478842%0Awd%3AQ23656850%0Awd%3AQ30589121%0Awd%3AQ50358332%0Awd%3AQ66309937%0Awd%3AQ97166784%0Awd%3AQ97166794%0Awd%3AQ97166804%0Awd%3AQ97166821%0Awd%3AQ97166832%0Awd%3AQ97166839%0Awd%3AQ97166853%0Awd%3AQ97166865%0Awd%3AQ97166878%0Awd%3AQ97166887%0Awd%3AQ97166898%0Awd%3AQ97166907%0Awd%3AQ97166917%0Awd%3AQ97166929%0Awd%3AQ97166939%0Awd%3AQ97166953%0Awd%3AQ97166961%0Awd%3AQ97166971%0Awd%3AQ97166983%0Awd%3AQ97166996%0Awd%3AQ97177001%0Awd%3AQ97177010%0Awd%3AQ97177018%0Awd%3AQ97177027%0Awd%3AQ97177036%0Awd%3AQ97274232%0Awd%3AQ97276565%0Awd%3AQ97366950%0Awd%3AQ97368870%0Awd%3AQ113458389%0Awd%3AQ115169221%0Awd%3AQ117734928%0Awd%3AQ117734993%0Awd%3AQ117821640%0Awd%3AQ117821739%0Awd%3AQ117821816%0Awd%3AQ117821841%0Awd%3AQ117821869%0Awd%3AQ117821891%0Awd%3AQ117821901%0Awd%3AQ120972377%0Awd%3AQ121856589%0Awd%3AQ260607%0Awd%3AQ855711%0Awd%3AQ1234938%0Awd%3AQ1410590%0Awd%3AQ1774427%0Awd%3AQ4381750%0Awd%3AQ5333592%0Awd%3AQ5347223%0Awd%3AQ5347364%0Awd%3AQ5347366%0Awd%3AQ5347371%0Awd%3AQ6025269%0Awd%3AQ15278684%0Awd%3AQ17001404%0Awd%3AQ100893302%0Awd%3AQ104878720%0Awd%3AQ104880841%0Awd%3AQ104880851%0Awd%3AQ105633214%0Awd%3AQ105633720%0Awd%3AQ105974436%0Awd%3AQ105974518%0Awd%3AQ106600471%0Awd%3AQ108576083%0Awd%3AQ113505163%0Awd%3AQ114836085%0Awd%3AQ647389%0Awd%3AQ3055453%0Awd%3AQ3055463%0Awd%3AQ3055482%0Awd%3AQ4566423%0Awd%3AQ4568232%0Awd%3AQ4571740%0Awd%3AQ4574279%0Awd%3AQ4574796%0Awd%3AQ4575282%0Awd%3AQ4575846%0Awd%3AQ4576365%0Awd%3AQ4576923%0Awd%3AQ4577419%0Awd%3AQ4577923%0Awd%3AQ4578444%0Awd%3AQ4578999%0Awd%3AQ4579549%0Awd%3AQ4580137%0Awd%3AQ4581396%0Awd%3AQ4582026%0Awd%3AQ4583372%0Awd%3AQ4584119%0Awd%3AQ4584867%0Awd%3AQ4585592%0Awd%3AQ4586461%0Awd%3AQ4587291%0Awd%3AQ4588108%0Awd%3AQ4588979%0Awd%3AQ4589901%0Awd%3AQ4590891%0Awd%3AQ4591908%0Awd%3AQ4593055%0Awd%3AQ4594205%0Awd%3AQ4595402%0Awd%3AQ4598086%0Awd%3AQ4599387%0Awd%3AQ4600749%0Awd%3AQ4602139%0Awd%3AQ4603570%0Awd%3AQ4605245%0Awd%3AQ4609824%0Awd%3AQ4612415%0Awd%3AQ4615457%0Awd%3AQ4623243%0Awd%3AQ4627586%0Awd%3AQ4630284%0Awd%3AQ4630333%0Awd%3AQ5381046%0Awd%3AQ5381047%0Awd%3AQ5381048%0Awd%3AQ5381049%0Awd%3AQ5381051%0Awd%3AQ5381052%0Awd%3AQ5381053%0Awd%3AQ5381054%0Awd%3AQ5381055%0Awd%3AQ5381056%0Awd%3AQ5381057%0Awd%3AQ5381058%0Awd%3AQ5381059%0Awd%3AQ5381060%0Awd%3AQ5381061%0Awd%3AQ5381062%0Awd%3AQ5381063%0Awd%3AQ5381064%0Awd%3AQ5381065%0Awd%3AQ5381066%0Awd%3AQ5381068%0Awd%3AQ5381069%0Awd%3AQ5381071%0Awd%3AQ5381072%0Awd%3AQ5381074%0Awd%3AQ5381075%0Awd%3AQ5381077%0Awd%3AQ5381078%0Awd%3AQ5381079%0Awd%3AQ5381080%0Awd%3AQ5381081%0Awd%3AQ5381082%0Awd%3AQ5381083%0Awd%3AQ5381084%0Awd%3AQ5381085%0Awd%3AQ5381086%0Awd%3AQ6645935%0Awd%3AQ10328304%0Awd%3AQ10856252%0Awd%3AQ11463395%0Awd%3AQ16820590%0Awd%3AQ16820600%0Awd%3AQ16820653%0Awd%3AQ16820820%0Awd%3AQ16934607%0Awd%3AQ17119225%0Awd%3AQ18148989%0Awd%3AQ18208243%0Awd%3AQ18208356%0Awd%3AQ28221077%0Awd%3AQ28223831%0Awd%3AQ67322565%0Awd%3AQ67322567%0Awd%3AQ67322569%0Awd%3AQ67322571%0Awd%3AQ67322572%0Awd%3AQ85732687%0Awd%3AQ85737787%0Awd%3AQ86674909%0Awd%3AQ97280074%0Awd%3AQ109315520%0Awd%3AQ111458091%0Awd%3AQ120931630%0Awd%3AQ120931652%0Awd%3AQ3115646%0Awd%3AQ5133464%0Awd%3AQ5381236%0Awd%3AQ5741818%0Awd%3AQ21707860%0Awd%3AQ29966545%0Awd%3AQ48727357%0Awd%3AQ63438000%0Awd%3AQ82529147%0Awd%3AQ85766769%0Awd%3AQ96375114%0Awd%3AQ102133023%0Awd%3AQ106564039%0A%20%20%7D%0A%20%20%0A%20%20%3Forg%20wdt%3AP101%20%3Farea%20.%0A%7D
It works rather well performance wise.
Open questions:
- Does it work across all agencies in Govdirectory(as the current UI assumes)
- Are a curated set of topics enough or do we need "live" discovery queries like the ones above? (and if so do it still work across all agencies in Govdirectory?)
- What categories do we want initially given that we will no longer be bound to COFOG?
- What categories do we want initially given that we will no longer be bound to COFOG?
As there probably already have been quite a lot of thinking to come up with the COFOG categories, I suggest that we keep them, at least at a top level.
And what about the items that are not supported by COFOG?
As all UN countries are reporting data for all their agencies in those categories, I think the number of unsupported will be almost negligible, as they have already been successfully mapped once.