Исходный код вики Занятость в неформальном секторе СНГ в 2022 году
Последние авторы
| author | version | line-number | content |
|---|---|---|---|
| 1 | = Выявленные тенденции = | ||
| 2 | |||
| 3 | В 2022 г. численность занятых в неформальном секторе экономики в СНГ (здесь и далее без учёта Украины, Узбекистана, Туркменистана, Таджикистана, Азербайджана и Казахстана) {{semQuery query=" | ||
| 4 | PREFIX xsd: <http://www.w3.org/2001/XMLSchema> | ||
| 5 | select ?res | ||
| 6 | from <http://purl.semanticpro.org/data/employedPopulationNonFormalY> | ||
| 7 | WHERE { | ||
| 8 | { | ||
| 9 | select (sum(?valueCurr) as ?vCurr) (sum(?valuePrev) as ?vPrev) (sum(?valueCurr) - sum(?valuePrev) as ?val) | ||
| 10 | WHERE { | ||
| 11 | ?URI <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://purl.org/linked-data/cube#Observation> . | ||
| 12 | ?URI <http://purl.semanticpro.org/cis/vocabs#Country> ?country . | ||
| 13 | { | ||
| 14 | ?URI <http://purl.semanticpro.org/cis/vocabs#PeriodYears> <http://purl.semanticpro.org/cis/vocabs/period/1.0#Y2022>. | ||
| 15 | ?URI <http://purl.semanticpro.org/cis/vocabs/measure#countEmployedPopulation> ?valueCurr . | ||
| 16 | } | ||
| 17 | union | ||
| 18 | { | ||
| 19 | ?URI <http://purl.semanticpro.org/cis/vocabs#PeriodYears> <http://purl.semanticpro.org/cis/vocabs/period/1.0#Y2021>. | ||
| 20 | ?URI <http://purl.semanticpro.org/cis/vocabs/measure#countEmployedPopulation> ?valuePrev . | ||
| 21 | } | ||
| 22 | FILTER( | ||
| 23 | (?country != <http://purl.semanticpro.org/cis/vocabs/country/1.0#Ukraine>) && | ||
| 24 | (?country != <http://purl.semanticpro.org/cis/vocabs/country/1.0#Uzbekistan>) && | ||
| 25 | (?country != <http://purl.semanticpro.org/cis/vocabs/country/1.0#Turkmenistan>) && | ||
| 26 | (?country != <http://purl.semanticpro.org/cis/vocabs/country/1.0#Tajikistan>) && | ||
| 27 | (?country != <http://purl.semanticpro.org/cis/vocabs/country/1.0#Azerbaijan>) && | ||
| 28 | (?country != <http://purl.semanticpro.org/cis/vocabs/country/1.0#Kazakhstan>) | ||
| 29 | ) | ||
| 30 | } | ||
| 31 | } | ||
| 32 | BIND( | ||
| 33 | CONCAT( | ||
| 34 | 'составила '@ru, | ||
| 35 | STR(ROUND(ABS(?vCurr/1000.00))), | ||
| 36 | ' тыс. чел., '@ru, | ||
| 37 | IF( | ||
| 38 | ?val>0, | ||
| 39 | 'увеличившись к предыдущему году на '@ru, | ||
| 40 | 'сократившись к предыдущему году на '@ru | ||
| 41 | ), | ||
| 42 | STR(ROUND(ABS(?val/1000.00))), | ||
| 43 | ' тыс. чел. или на '@ru, | ||
| 44 | STR(ROUND(ABS(?val)*10000.00/?vPrev)/100.00), | ||
| 45 | '%.'@ru | ||
| 46 | ) as ?res | ||
| 47 | ) | ||
| 48 | } | ||
| 49 | " header="" links="false" mode="FIELD"/}} По странам значение этого показателя составило: {{semQuery query=" | ||
| 50 | PREFIX xsd: <http://www.w3.org/2001/XMLSchema> | ||
| 51 | select (GROUP_CONCAT(?res; separator=', ') as ?res2) | ||
| 52 | FROM <http://purl.semanticpro.org/data/employedPopulationNonFormalY> | ||
| 53 | FROM <http://purl.semanticpro.org/cis/vocabs/country/1.0#> | ||
| 54 | WHERE { | ||
| 55 | { | ||
| 56 | select ?country ?countryLabel (sum(?valueCurr) as ?vCurr) (sum(?valuePrev) as ?vPrev) ((sum(?valueCurr) - sum(?valuePrev))*100/sum(?valuePrev) as ?val) | ||
| 57 | WHERE { | ||
| 58 | ?URI <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://purl.org/linked-data/cube#Observation> . | ||
| 59 | ?URI <http://purl.semanticpro.org/cis/vocabs#Country> ?country . | ||
| 60 | ?country <http://www.w3.org/2000/01/rdf-schema#label> ?countryLabel | ||
| 61 | { | ||
| 62 | ?URI <http://purl.semanticpro.org/cis/vocabs#PeriodYears> <http://purl.semanticpro.org/cis/vocabs/period/1.0#Y2022>. | ||
| 63 | ?URI <http://purl.semanticpro.org/cis/vocabs/measure#countEmployedPopulation> ?valueCurr . | ||
| 64 | } | ||
| 65 | union | ||
| 66 | { | ||
| 67 | ?URI <http://purl.semanticpro.org/cis/vocabs#PeriodYears> <http://purl.semanticpro.org/cis/vocabs/period/1.0#Y2021>. | ||
| 68 | ?URI <http://purl.semanticpro.org/cis/vocabs/measure#countEmployedPopulation> ?valuePrev . | ||
| 69 | } | ||
| 70 | FILTER(lang(?countryLabel) = 'ru') | ||
| 71 | FILTER( | ||
| 72 | (?country != <http://purl.semanticpro.org/cis/vocabs/country/1.0#Ukraine>) && | ||
| 73 | (?country != <http://purl.semanticpro.org/cis/vocabs/country/1.0#Uzbekistan>) && | ||
| 74 | (?country != <http://purl.semanticpro.org/cis/vocabs/country/1.0#Turkmenistan>) && | ||
| 75 | (?country != <http://purl.semanticpro.org/cis/vocabs/country/1.0#Tajikistan>) && | ||
| 76 | (?country != <http://purl.semanticpro.org/cis/vocabs/country/1.0#Azerbaijan>) && | ||
| 77 | (?country != <http://purl.semanticpro.org/cis/vocabs/country/1.0#Kazakhstan>) | ||
| 78 | ) | ||
| 79 | } | ||
| 80 | GROUP BY ?country ?countryLabel | ||
| 81 | ORDER BY DESC(?vCurr) | ||
| 82 | } | ||
| 83 | BIND( | ||
| 84 | CONCAT( | ||
| 85 | ?countryLabel, | ||
| 86 | ' '@ru, | ||
| 87 | STR(ROUND(ABS(?vCurr/1000.00))), | ||
| 88 | ' тыс. чел.'@ru, | ||
| 89 | ' (', | ||
| 90 | IF( | ||
| 91 | ?val>0, | ||
| 92 | '+', | ||
| 93 | '-' | ||
| 94 | ), | ||
| 95 | STR(ROUND(ABS(?vCurr-?vPrev)/1000.00)), | ||
| 96 | ' тыс. чел. или '@ru, | ||
| 97 | IF( | ||
| 98 | ?val>0, | ||
| 99 | '+', | ||
| 100 | '-' | ||
| 101 | ), | ||
| 102 | STR(ROUND(ABS(?val)*100)/100.00), | ||
| 103 | '%)' | ||
| 104 | ) as ?res | ||
| 105 | ) | ||
| 106 | } | ||
| 107 | " header="" links="false" mode="FIELD"/}}. | ||
| 108 | |||
| 109 | ---- | ||
| 110 | |||
| 111 | = Экспертное мнение = | ||
| 112 | |||
| 113 | {{velocity}} | ||
| 114 | #set ($section = $xwiki.getDocument('.Экспертное мнение по занятости в неформальном секторе СНГ в 2022 году.WebHome')) | ||
| 115 | $section.display('expertise') | ||
| 116 | {{/velocity}} | ||
| 117 | |||
| 118 | = Таблицы и графики = | ||
| 119 | |||
| 120 | **Таблица 1. Численность занятого населения в неформальном секторе, всего, по годам. ** | ||
| 121 | {{html clean="false"}}<iframe style="border:none;" src="/QBOLAPBrowser/#dataset=http://purl.semanticpro.org/data/employedPopulationNonFormalY&lang=ru&col=0&row=1&exp=1&hideDataset=true" title="Численность занятого населения в неформальном секторе, всего, по годам." width="100%" height="800px" role="presentation" allowfullscreen></iframe>{{/html}} |