Исходный код вики Уровень участия в рабочей силе в странах СНГ в 2022 году
Скрыть последних авторов
| author | version | line-number | content |
|---|---|---|---|
 |
1.1 | 1 | = Выявленные тенденции = |
| 2 | |||
| 3 | В 2022 году численность рабочей силы в СНГ (здесь и далее без учёта Таджикистана, Туркменистана, Узбекистана и Украины) {{semQuery query=" | ||
| 4 | PREFIX xsd: <http://www.w3.org/2001/XMLSchema> | ||
| 5 | select ?res | ||
| |
2.1 | 6 | from <http://purl.cisstat.org/data/manpowerY> |
| |
1.1 | 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> . | ||
| |
2.1 | 12 | ?URI <http://purl.cisstat.org/cis/vocabs#Country> ?country . |
| |
1.1 | 13 | { |
| |
2.1 | 14 | ?URI <http://purl.cisstat.org/cis/vocabs#PeriodYears> <http://purl.cisstat.org/cis/vocabs/period/1.0#Y2022>. |
| 15 | ?URI <http://purl.cisstat.org/cis/vocabs/measure#countWorkForce> ?valueCurr . | ||
| |
1.1 | 16 | } |
| 17 | union | ||
| 18 | { | ||
| |
2.1 | 19 | ?URI <http://purl.cisstat.org/cis/vocabs#PeriodYears> <http://purl.cisstat.org/cis/vocabs/period/1.0#Y2021>. |
| 20 | ?URI <http://purl.cisstat.org/cis/vocabs/measure#countWorkForce> ?valuePrev . | ||
| |
1.1 | 21 | } |
| 22 | FILTER( | ||
| |
2.1 | 23 | (?country != <http://purl.cisstat.org/cis/vocabs/country/1.0#Ukraine>) && |
| 24 | (?country != <http://purl.cisstat.org/cis/vocabs/country/1.0#Uzbekistan>) && | ||
| 25 | (?country != <http://purl.cisstat.org/cis/vocabs/country/1.0#Turkmenistan>) && | ||
| 26 | (?country != <http://purl.cisstat.org/cis/vocabs/country/1.0#Tajikistan>) | ||
| |
1.1 | 27 | ) |
| 28 | } | ||
| 29 | } | ||
| 30 | BIND( | ||
| 31 | CONCAT( | ||
| 32 | 'составила '@ru, | ||
| 33 | STR(ROUND(ABS(?vCurr/1000.00))), | ||
| 34 | ' тыс. чел. '@ru, | ||
| 35 | IF( | ||
| 36 | ?val>0, | ||
| 37 | 'увеличившись на '@ru, | ||
| 38 | 'уменьшившись на '@ru | ||
| 39 | ), | ||
| 40 | STR(ROUND(ABS(?val)*10000.00/?vPrev)/100.00), | ||
| 41 | '% к предыдущему году'@ru | ||
| 42 | ) as ?res | ||
| 43 | ) | ||
| 44 | } | ||
| 45 | " header="" links="false" mode="FIELD"/}}, в том числе по странам: {{semQuery query=" | ||
| 46 | PREFIX xsd: <http://www.w3.org/2001/XMLSchema> | ||
| 47 | select (GROUP_CONCAT(?res; separator=', ') as ?res2) | ||
| |
2.1 | 48 | FROM <http://purl.cisstat.org/data/manpowerY> |
| 49 | FROM <http://purl.cisstat.org/cis/vocabs/country/1.0#> | ||
| |
1.1 | 50 | WHERE { |
| 51 | { | ||
| 52 | select ?country ?countryLabel (sum(?valueCurr) as ?vCurr) (sum(?valuePrev) as ?vPrev) ((sum(?valueCurr) - sum(?valuePrev))*100/sum(?valuePrev) as ?val) | ||
| 53 | WHERE { | ||
| 54 | ?URI <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://purl.org/linked-data/cube#Observation> . | ||
| |
2.1 | 55 | ?URI <http://purl.cisstat.org/cis/vocabs#Country> ?country . |
| |
1.1 | 56 | ?country <http://www.w3.org/2000/01/rdf-schema#label> ?countryLabel |
| 57 | { | ||
| |
2.1 | 58 | ?URI <http://purl.cisstat.org/cis/vocabs#PeriodYears> <http://purl.cisstat.org/cis/vocabs/period/1.0#Y2022>. |
| 59 | ?URI <http://purl.cisstat.org/cis/vocabs/measure#countWorkForce> ?valueCurr . | ||
| |
1.1 | 60 | } |
| 61 | union | ||
| 62 | { | ||
| |
2.1 | 63 | ?URI <http://purl.cisstat.org/cis/vocabs#PeriodYears> <http://purl.cisstat.org/cis/vocabs/period/1.0#Y2021>. |
| 64 | ?URI <http://purl.cisstat.org/cis/vocabs/measure#countWorkForce> ?valuePrev . | ||
| |
1.1 | 65 | } |
| 66 | FILTER(lang(?countryLabel) = 'ru') | ||
| 67 | FILTER( | ||
| |
2.1 | 68 | (?country != <http://purl.cisstat.org/cis/vocabs/country/1.0#Ukraine>) && |
| 69 | (?country != <http://purl.cisstat.org/cis/vocabs/country/1.0#Uzbekistan>) && | ||
| 70 | (?country != <http://purl.cisstat.org/cis/vocabs/country/1.0#Turkmenistan>) && | ||
| 71 | (?country != <http://purl.cisstat.org/cis/vocabs/country/1.0#Tajikistan>) | ||
| |
1.1 | 72 | ) |
| 73 | } | ||
| 74 | GROUP BY ?country ?countryLabel | ||
| 75 | ORDER BY (?val) | ||
| 76 | } | ||
| 77 | BIND( | ||
| 78 | CONCAT( | ||
| 79 | ?countryLabel, | ||
| 80 | ' (', | ||
| 81 | IF( | ||
| 82 | ?val>0, | ||
| 83 | '+', | ||
| 84 | '-' | ||
| 85 | ), | ||
| 86 | STR(ROUND(ABS(?val)*100)/100.00), | ||
| 87 | '%)' | ||
| 88 | ) as ?res | ||
| 89 | ) | ||
| 90 | } | ||
| 91 | " header="" links="false" mode="FIELD"/}}. | ||
| 92 | |||
| 93 | ---- | ||
| 94 | |||
| 95 | В СНГ численность рабочей силы по возрастным когортам имела следующую динамику к предыдущему году: {{semQuery query=" | ||
| 96 | PREFIX xsd: <http://www.w3.org/2001/XMLSchema> | ||
| 97 | select ?Возраст ?Состояние | ||
| |
2.1 | 98 | FROM <http://purl.cisstat.org/data/manpowerA> |
| 99 | FROM <http://purl.cisstat.org/cis/vocabs/age/1.0#> | ||
| |
1.1 | 100 | WHERE { |
| 101 | { | ||
| 102 | select ?age ?ageLabel (sum(?valueCurr) as ?vCurr) (sum(?valuePrev) as ?vPrev) (sum(?valueCurr) - sum(?valuePrev) as ?val) | ||
| 103 | WHERE { | ||
| 104 | ?URI <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://purl.org/linked-data/cube#Observation> . | ||
| |
2.1 | 105 | ?URI <http://purl.cisstat.org/cis/vocabs#Country> ?country . |
| 106 | ?URI <http://purl.cisstat.org/cis/vocabs#Age> ?age. | ||
| |
1.1 | 107 | ?age <http://www.w3.org/2000/01/rdf-schema#label> ?ageLabel. |
| 108 | { | ||
| |
2.1 | 109 | ?URI <http://purl.cisstat.org/cis/vocabs#PeriodYears> <http://purl.cisstat.org/cis/vocabs/period/1.0#Y2022>. |
| 110 | ?URI <http://purl.cisstat.org/cis/vocabs/measure#countWorkForce> ?valueCurr . | ||
| |
1.1 | 111 | } |
| 112 | union | ||
| 113 | { | ||
| |
2.1 | 114 | ?URI <http://purl.cisstat.org/cis/vocabs#PeriodYears> <http://purl.cisstat.org/cis/vocabs/period/1.0#Y2021>. |
| 115 | ?URI <http://purl.cisstat.org/cis/vocabs/measure#countWorkForce> ?valuePrev . | ||
| |
1.1 | 116 | } |
| 117 | FILTER (lang(?ageLabel) = 'ru') | ||
| 118 | FILTER( | ||
| |
2.1 | 119 | (?country != <http://purl.cisstat.org/cis/vocabs/country/1.0#Ukraine>) && |
| 120 | (?country != <http://purl.cisstat.org/cis/vocabs/country/1.0#Uzbekistan>) && | ||
| 121 | (?country != <http://purl.cisstat.org/cis/vocabs/country/1.0#Turkmenistan>) && | ||
| 122 | (?country != <http://purl.cisstat.org/cis/vocabs/country/1.0#Tajikistan>) | ||
| |
1.1 | 123 | ) |
| 124 | } | ||
| 125 | GROUP BY ?age ?ageLabel | ||
| 126 | ORDER BY ?age | ||
| 127 | } | ||
| 128 | BIND( | ||
| 129 | CONCAT( | ||
| 130 | STR(?ageLabel) | ||
| 131 | ) as ?Возраст | ||
| 132 | ) | ||
| 133 | BIND( | ||
| 134 | CONCAT( | ||
| 135 | IF( | ||
| 136 | ROUND(?val)=0, | ||
| 137 | ' не изменилась '@ru, | ||
| 138 | IF(?val>0, | ||
| 139 | ' увеличилась на '@ru, | ||
| 140 | ' сократилась на '@ru | ||
| 141 | ) | ||
| 142 | ), | ||
| 143 | IF( | ||
| 144 | ROUND(?val)=0, | ||
| 145 | ''@ru, | ||
| 146 | CONCAT (STR(ROUND(ABS(?val)/?vPrev*10000.00)/100.00), '% '@ru) | ||
| 147 | ), | ||
| 148 | 'и составила '@ru, | ||
| 149 | STR(ROUND(?vCurr/1000.00)), | ||
| 150 | ' тыс. чел.'@ru | ||
| 151 | ) as ?Состояние | ||
| 152 | ) | ||
| 153 | } | ||
| 154 | " header="Возраст,Состояние" links="false" mode="TABLE"/}} | ||
| 155 | |||
| 156 | ---- | ||
| 157 | |||
| 158 | Уровень участия населения в рабочей силе СНГ {{semQuery query=" | ||
| 159 | PREFIX xsd: <http://www.w3.org/2001/XMLSchema> | ||
| 160 | select ?res | ||
| |
2.1 | 161 | FROM <http://purl.cisstat.org/data/notWorkForceY> |
| 162 | FROM <http://purl.cisstat.org/data/manpowerY> | ||
| |
1.1 | 163 | WHERE { |
| 164 | { | ||
| 165 | select (sum(?countNotWorkForce) as ?sumNotWorkForce) (sum(?countWorkForce) as ?sumWorkForce) | ||
| 166 | WHERE { | ||
| 167 | ?URI <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://purl.org/linked-data/cube#Observation> . | ||
| |
2.1 | 168 | ?URI <http://purl.cisstat.org/cis/vocabs#Country> ?country . |
| |
1.1 | 169 | { |
| |
2.1 | 170 | ?URI <http://purl.cisstat.org/cis/vocabs#PeriodYears> <http://purl.cisstat.org/cis/vocabs/period/1.0#Y2022>. |
| 171 | ?URI <http://purl.cisstat.org/cis/vocabs/measure#countNotWorkForce> ?countNotWorkForce . | ||
| |
1.1 | 172 | } |
| 173 | union | ||
| 174 | { | ||
| |
2.1 | 175 | ?URI <http://purl.cisstat.org/cis/vocabs#PeriodYears> <http://purl.cisstat.org/cis/vocabs/period/1.0#Y2022>. |
| 176 | ?URI <http://purl.cisstat.org/cis/vocabs/measure#countWorkForce> ?countWorkForce . | ||
| |
1.1 | 177 | } |
| 178 | FILTER( | ||
| |
2.1 | 179 | (?country != <http://purl.cisstat.org/cis/vocabs/country/1.0#Ukraine>) && |
| 180 | (?country != <http://purl.cisstat.org/cis/vocabs/country/1.0#Uzbekistan>) && | ||
| 181 | (?country != <http://purl.cisstat.org/cis/vocabs/country/1.0#Turkmenistan>) && | ||
| 182 | (?country != <http://purl.cisstat.org/cis/vocabs/country/1.0#Tajikistan>) | ||
| |
1.1 | 183 | ) |
| 184 | } | ||
| 185 | } | ||
| 186 | BIND( | ||
| 187 | CONCAT( | ||
| 188 | 'составил '@ru, | ||
| 189 | STR(ROUND(ABS(1/(1 + ?sumNotWorkForce/?sumWorkForce))*10000.00)/100.00), | ||
| 190 | '% '@ru | ||
| 191 | ) as ?res | ||
| 192 | ) | ||
| 193 | } | ||
| 194 | " header="" links="false" mode="FIELD"/}}, в том числе по странам: {{semQuery query=" | ||
| 195 | PREFIX xsd: <http://www.w3.org/2001/XMLSchema> | ||
| 196 | select (GROUP_CONCAT(?res; separator=', ') as ?res2) | ||
| |
2.1 | 197 | FROM <http://purl.cisstat.org/data/lvlManpowerY> |
| 198 | FROM <http://purl.cisstat.org/cis/vocabs/country/1.0#> | ||
| |
1.1 | 199 | WHERE { |
| 200 | { | ||
| 201 | select DISTINCT ?country ?countryLabel (?valueCurr as ?vCurr) | ||
| 202 | WHERE { | ||
| 203 | ?URI <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://purl.org/linked-data/cube#Observation> . | ||
| |
2.1 | 204 | ?URI <http://purl.cisstat.org/cis/vocabs#Country> ?country . |
| |
1.1 | 205 | ?country <http://www.w3.org/2000/01/rdf-schema#label> ?countryLabel |
| 206 | { | ||
| |
2.1 | 207 | ?URI <http://purl.cisstat.org/cis/vocabs#PeriodYears> <http://purl.cisstat.org/cis/vocabs/period/1.0#Y2022>. |
| 208 | ?URI <http://purl.cisstat.org/cis/vocabs/measure#percentLvlWorkForce> ?valueCurr . | ||
| |
1.1 | 209 | } |
| 210 | FILTER(lang(?countryLabel) = 'ru') | ||
| 211 | FILTER( | ||
| |
2.1 | 212 | (?country != <http://purl.cisstat.org/cis/vocabs/country/1.0#Ukraine>) && |
| 213 | (?country != <http://purl.cisstat.org/cis/vocabs/country/1.0#Uzbekistan>) && | ||
| 214 | (?country != <http://purl.cisstat.org/cis/vocabs/country/1.0#Turkmenistan>) && | ||
| 215 | (?country != <http://purl.cisstat.org/cis/vocabs/country/1.0#Tajikistan>) | ||
| |
1.1 | 216 | ) |
| 217 | } | ||
| 218 | ORDER BY ?valueCurr | ||
| 219 | } | ||
| 220 | BIND( | ||
| 221 | CONCAT( | ||
| 222 | ?countryLabel, | ||
| 223 | ' ', | ||
| 224 | STR(ROUND(ABS(?vCurr)*100)/100.00), | ||
| 225 | '%' | ||
| 226 | ) as ?res | ||
| 227 | ) | ||
| 228 | } | ||
| 229 | " header="" links="false" mode="FIELD"/}} | ||
| 230 | |||
| 231 | ---- | ||
| 232 | |||
| 233 | Уровень участия мужчин в рабочей силе СНГ {{semQuery query=" | ||
| 234 | PREFIX xsd: <http://www.w3.org/2001/XMLSchema> | ||
| 235 | select ?res | ||
| |
2.1 | 236 | FROM <http://purl.cisstat.org/data/notWorkForceGY> |
| 237 | FROM <http://purl.cisstat.org/data/manpowerS> | ||
| |
1.1 | 238 | WHERE { |
| 239 | { | ||
| 240 | select (sum(?countNotWorkForce) as ?sumNotWorkForce) (sum(?countWorkForce) as ?sumWorkForce) | ||
| 241 | WHERE { | ||
| 242 | ?URI <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://purl.org/linked-data/cube#Observation> . | ||
| |
2.1 | 243 | ?URI <http://purl.cisstat.org/cis/vocabs#Country> ?country . |
| 244 | ?URI <http://purl.cisstat.org/cis/vocabs#Sex> <http://purl.cisstat.org/cis/vocabs/sex/1.0#MLE>. | ||
| |
1.1 | 245 | { |
| |
2.1 | 246 | ?URI <http://purl.cisstat.org/cis/vocabs#PeriodYears> <http://purl.cisstat.org/cis/vocabs/period/1.0#Y2022>. |
| 247 | ?URI <http://purl.cisstat.org/cis/vocabs/measure#countNotWorkForce> ?countNotWorkForce . | ||
| |
1.1 | 248 | } |
| 249 | union | ||
| 250 | { | ||
| |
2.1 | 251 | ?URI <http://purl.cisstat.org/cis/vocabs#PeriodYears> <http://purl.cisstat.org/cis/vocabs/period/1.0#Y2022>. |
| 252 | ?URI <http://purl.cisstat.org/cis/vocabs/measure#countWorkForce> ?countWorkForce . | ||
| |
1.1 | 253 | } |
| 254 | FILTER( | ||
| |
2.1 | 255 | (?country != <http://purl.cisstat.org/cis/vocabs/country/1.0#Ukraine>) && |
| 256 | (?country != <http://purl.cisstat.org/cis/vocabs/country/1.0#Uzbekistan>) && | ||
| 257 | (?country != <http://purl.cisstat.org/cis/vocabs/country/1.0#Turkmenistan>) && | ||
| 258 | (?country != <http://purl.cisstat.org/cis/vocabs/country/1.0#Tajikistan>) | ||
| |
1.1 | 259 | ) |
| 260 | } | ||
| 261 | } | ||
| 262 | BIND( | ||
| 263 | CONCAT( | ||
| 264 | 'составил '@ru, | ||
| 265 | STR(ROUND(ABS(1/(1 + ?sumNotWorkForce/?sumWorkForce))*10000.00)/100.00), | ||
| 266 | '% '@ru | ||
| 267 | ) as ?res | ||
| 268 | ) | ||
| 269 | } | ||
| 270 | " header="" links="false" mode="FIELD"/}}, в том числе по странам: {{semQuery query=" | ||
| 271 | PREFIX xsd: <http://www.w3.org/2001/XMLSchema> | ||
| 272 | select (GROUP_CONCAT(?res; separator=', ') as ?res2) | ||
| |
2.1 | 273 | FROM <http://purl.cisstat.org/data/lvlManpowerS> |
| 274 | FROM <http://purl.cisstat.org/cis/vocabs/country/1.0#> | ||
| 275 | FROM <http://purl.cisstat.org/cis/vocabs/sex/1.0#> | ||
| |
1.1 | 276 | WHERE { |
| 277 | { | ||
| 278 | select DISTINCT ?country ?countryLabel (?valueCurr as ?vCurr) | ||
| 279 | WHERE { | ||
| 280 | ?URI <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://purl.org/linked-data/cube#Observation> . | ||
| |
2.1 | 281 | ?URI <http://purl.cisstat.org/cis/vocabs#Country> ?country . |
| |
1.1 | 282 | ?country <http://www.w3.org/2000/01/rdf-schema#label> ?countryLabel . |
| |
2.1 | 283 | ?URI <http://purl.cisstat.org/cis/vocabs#Sex> <http://purl.cisstat.org/cis/vocabs/sex/1.0#MLE>. |
| |
1.1 | 284 | { |
| |
2.1 | 285 | ?URI <http://purl.cisstat.org/cis/vocabs#PeriodYears> <http://purl.cisstat.org/cis/vocabs/period/1.0#Y2022>. |
| 286 | ?URI <http://purl.cisstat.org/cis/vocabs/measure#percentLvlWorkForce> ?valueCurr . | ||
| |
1.1 | 287 | } |
| 288 | FILTER(lang(?countryLabel) = 'ru') | ||
| 289 | FILTER( | ||
| |
2.1 | 290 | (?country != <http://purl.cisstat.org/cis/vocabs/country/1.0#Ukraine>) && |
| 291 | (?country != <http://purl.cisstat.org/cis/vocabs/country/1.0#Uzbekistan>) && | ||
| 292 | (?country != <http://purl.cisstat.org/cis/vocabs/country/1.0#Turkmenistan>) && | ||
| 293 | (?country != <http://purl.cisstat.org/cis/vocabs/country/1.0#Tajikistan>) | ||
| |
1.1 | 294 | ) |
| 295 | } | ||
| 296 | ORDER BY ?valueCurr | ||
| 297 | } | ||
| 298 | BIND( | ||
| 299 | CONCAT( | ||
| 300 | ?countryLabel, | ||
| 301 | ' '@ru, | ||
| 302 | STR(ROUND(ABS(?vCurr)*100)/100.00), | ||
| 303 | '%' | ||
| 304 | ) as ?res | ||
| 305 | ) | ||
| 306 | } | ||
| 307 | " header="" links="false" mode="FIELD"/}}; уровень участия женщин в рабочей силе {{semQuery query=" | ||
| 308 | PREFIX xsd: <http://www.w3.org/2001/XMLSchema> | ||
| 309 | select ?res | ||
| |
2.1 | 310 | FROM <http://purl.cisstat.org/data/notWorkForceGY> |
| 311 | FROM <http://purl.cisstat.org/data/manpowerS> | ||
| |
1.1 | 312 | WHERE { |
| 313 | { | ||
| 314 | select (sum(?countNotWorkForce) as ?sumNotWorkForce) (sum(?countWorkForce) as ?sumWorkForce) | ||
| 315 | WHERE { | ||
| 316 | ?URI <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://purl.org/linked-data/cube#Observation> . | ||
| |
2.1 | 317 | ?URI <http://purl.cisstat.org/cis/vocabs#Country> ?country . |
| 318 | ?URI <http://purl.cisstat.org/cis/vocabs#Sex> <http://purl.cisstat.org/cis/vocabs/sex/1.0#FMLE>. | ||
| |
1.1 | 319 | { |
| |
2.1 | 320 | ?URI <http://purl.cisstat.org/cis/vocabs#PeriodYears> <http://purl.cisstat.org/cis/vocabs/period/1.0#Y2022>. |
| 321 | ?URI <http://purl.cisstat.org/cis/vocabs/measure#countNotWorkForce> ?countNotWorkForce . | ||
| |
1.1 | 322 | } |
| 323 | union | ||
| 324 | { | ||
| |
2.1 | 325 | ?URI <http://purl.cisstat.org/cis/vocabs#PeriodYears> <http://purl.cisstat.org/cis/vocabs/period/1.0#Y2022>. |
| 326 | ?URI <http://purl.cisstat.org/cis/vocabs/measure#countWorkForce> ?countWorkForce . | ||
| |
1.1 | 327 | } |
| 328 | FILTER( | ||
| |
2.1 | 329 | (?country != <http://purl.cisstat.org/cis/vocabs/country/1.0#Ukraine>) && |
| 330 | (?country != <http://purl.cisstat.org/cis/vocabs/country/1.0#Uzbekistan>) && | ||
| 331 | (?country != <http://purl.cisstat.org/cis/vocabs/country/1.0#Turkmenistan>) && | ||
| 332 | (?country != <http://purl.cisstat.org/cis/vocabs/country/1.0#Tajikistan>) | ||
| |
1.1 | 333 | ) |
| 334 | } | ||
| 335 | } | ||
| 336 | BIND( | ||
| 337 | CONCAT( | ||
| 338 | 'составил '@ru, | ||
| 339 | STR(ROUND(ABS(1/(1 + ?sumNotWorkForce/?sumWorkForce))*10000.00)/100.00), | ||
| 340 | '% '@ru | ||
| 341 | ) as ?res | ||
| 342 | ) | ||
| 343 | } | ||
| 344 | " header="" links="false" mode="FIELD"/}}, в том числе по странам: {{semQuery query=" | ||
| 345 | PREFIX xsd: <http://www.w3.org/2001/XMLSchema> | ||
| 346 | select (GROUP_CONCAT(?res; separator=', ') as ?res2) | ||
| |
2.1 | 347 | FROM <http://purl.cisstat.org/data/lvlManpowerS> |
| 348 | FROM <http://purl.cisstat.org/cis/vocabs/country/1.0#> | ||
| 349 | FROM <http://purl.cisstat.org/cis/vocabs/sex/1.0#> | ||
| |
1.1 | 350 | WHERE { |
| 351 | { | ||
| 352 | select DISTINCT ?country ?countryLabel (?valueCurr as ?vCurr) | ||
| 353 | WHERE { | ||
| 354 | ?URI <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://purl.org/linked-data/cube#Observation> . | ||
| |
2.1 | 355 | ?URI <http://purl.cisstat.org/cis/vocabs#Country> ?country . |
| |
1.1 | 356 | ?country <http://www.w3.org/2000/01/rdf-schema#label> ?countryLabel . |
| |
2.1 | 357 | ?URI <http://purl.cisstat.org/cis/vocabs#Sex> <http://purl.cisstat.org/cis/vocabs/sex/1.0#FMLE>. |
| |
1.1 | 358 | { |
| |
2.1 | 359 | ?URI <http://purl.cisstat.org/cis/vocabs#PeriodYears> <http://purl.cisstat.org/cis/vocabs/period/1.0#Y2022>. |
| 360 | ?URI <http://purl.cisstat.org/cis/vocabs/measure#percentLvlWorkForce> ?valueCurr . | ||
| |
1.1 | 361 | } |
| 362 | FILTER(lang(?countryLabel) = 'ru') | ||
| 363 | FILTER( | ||
| |
2.1 | 364 | (?country != <http://purl.cisstat.org/cis/vocabs/country/1.0#Ukraine>) && |
| 365 | (?country != <http://purl.cisstat.org/cis/vocabs/country/1.0#Uzbekistan>) && | ||
| 366 | (?country != <http://purl.cisstat.org/cis/vocabs/country/1.0#Turkmenistan>) && | ||
| 367 | (?country != <http://purl.cisstat.org/cis/vocabs/country/1.0#Tajikistan>) | ||
| |
1.1 | 368 | ) |
| 369 | } | ||
| 370 | ORDER BY ?valueCurr | ||
| 371 | } | ||
| 372 | BIND( | ||
| 373 | CONCAT( | ||
| 374 | ?countryLabel, | ||
| 375 | ' '@ru, | ||
| 376 | STR(ROUND(ABS(?vCurr)*100)/100.00), | ||
| 377 | '%' | ||
| 378 | ) as ?res | ||
| 379 | ) | ||
| 380 | } | ||
| 381 | " header="" links="false" mode="FIELD"/}} | ||
| 382 | |||
| 383 | ---- | ||
| 384 | |||
| 385 | Уровень участия молодёжи (лиц в возрасте 15-29 лет) в рабочей силе СНГ {{semQuery query=" | ||
| 386 | PREFIX xsd: <http://www.w3.org/2001/XMLSchema> | ||
| 387 | select ?res | ||
| |
2.1 | 388 | FROM <http://purl.cisstat.org/data/notWorkForceAY> |
| 389 | FROM <http://purl.cisstat.org/data/manpowerA> | ||
| |
1.1 | 390 | WHERE { |
| 391 | { | ||
| 392 | select (sum(?countNotWorkForce) as ?sumNotWorkForce) (sum(?countWorkForce) as ?sumWorkForce) | ||
| 393 | WHERE { | ||
| 394 | ?URI <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://purl.org/linked-data/cube#Observation> . | ||
| |
2.1 | 395 | ?URI <http://purl.cisstat.org/cis/vocabs#Country> ?country . |
| |
1.1 | 396 | { |
| |
2.1 | 397 | ?URI <http://purl.cisstat.org/cis/vocabs#Age> <http://purl.cisstat.org/cis/vocabs/age/1.0#AGE15-29>. |
| 398 | ?URI <http://purl.cisstat.org/cis/vocabs#PeriodYears> <http://purl.cisstat.org/cis/vocabs/period/1.0#Y2022>. | ||
| 399 | ?URI <http://purl.cisstat.org/cis/vocabs/measure#countNotWorkForce> ?countNotWorkForce . | ||
| |
1.1 | 400 | } |
| 401 | union | ||
| 402 | { | ||
| |
2.1 | 403 | ?URI <http://purl.cisstat.org/cis/vocabs#PeriodYears> <http://purl.cisstat.org/cis/vocabs/period/1.0#Y2022>. |
| 404 | ?URI <http://purl.cisstat.org/cis/vocabs/measure#countWorkForce> ?countWorkForce . | ||
| 405 | ?URI <http://purl.cisstat.org/cis/vocabs#Age> <http://purl.cisstat.org/cis/vocabs/age/1.0#AGE15-24> . | ||
| |
1.1 | 406 | } |
| 407 | union | ||
| 408 | { | ||
| |
2.1 | 409 | ?URI <http://purl.cisstat.org/cis/vocabs#PeriodYears> <http://purl.cisstat.org/cis/vocabs/period/1.0#Y2022>. |
| 410 | ?URI <http://purl.cisstat.org/cis/vocabs/measure#countWorkForce> ?countWorkForce . | ||
| 411 | ?URI <http://purl.cisstat.org/cis/vocabs#Age> <http://purl.cisstat.org/cis/vocabs/age/1.0#AGE25-29> . | ||
| |
1.1 | 412 | } |
| 413 | FILTER( | ||
| |
2.1 | 414 | (?country != <http://purl.cisstat.org/cis/vocabs/country/1.0#Ukraine>) && |
| 415 | (?country != <http://purl.cisstat.org/cis/vocabs/country/1.0#Uzbekistan>) && | ||
| 416 | (?country != <http://purl.cisstat.org/cis/vocabs/country/1.0#Turkmenistan>) && | ||
| 417 | (?country != <http://purl.cisstat.org/cis/vocabs/country/1.0#Tajikistan>) | ||
| |
1.1 | 418 | ) |
| 419 | } | ||
| 420 | } | ||
| 421 | BIND( | ||
| 422 | CONCAT( | ||
| 423 | 'составил '@ru, | ||
| 424 | STR(ROUND(ABS(1/(1 + ?sumNotWorkForce/?sumWorkForce))*10000.00)/100.00), | ||
| 425 | '% '@ru | ||
| 426 | ) as ?res | ||
| 427 | ) | ||
| 428 | } | ||
| 429 | " header="" links="false" mode="FIELD"/}}, в том числе по странам: {{semQuery query=" | ||
| 430 | PREFIX xsd: <http://www.w3.org/2001/XMLSchema> | ||
| 431 | select (GROUP_CONCAT(?res; separator=', ') as ?res2) | ||
| |
2.1 | 432 | FROM <http://purl.cisstat.org/data/lvlManpowerA> |
| 433 | FROM <http://purl.cisstat.org/cis/vocabs/country/1.0#> | ||
| 434 | FROM <http://purl.cisstat.org/cis/vocabs/age/1.0#> | ||
| |
1.1 | 435 | WHERE { |
| 436 | { | ||
| 437 | select DISTINCT ?country ?countryLabel (?valueCurr as ?vCurr) | ||
| 438 | WHERE { | ||
| 439 | ?URI <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://purl.org/linked-data/cube#Observation> . | ||
| |
2.1 | 440 | ?URI <http://purl.cisstat.org/cis/vocabs#Country> ?country . |
| |
1.1 | 441 | ?country <http://www.w3.org/2000/01/rdf-schema#label> ?countryLabel . |
| |
2.1 | 442 | ?URI <http://purl.cisstat.org/cis/vocabs#Age> <http://purl.cisstat.org/cis/vocabs/age/1.0#AGE15-29>. |
| |
1.1 | 443 | { |
| |
2.1 | 444 | ?URI <http://purl.cisstat.org/cis/vocabs#PeriodYears> <http://purl.cisstat.org/cis/vocabs/period/1.0#Y2022>. |
| 445 | ?URI <http://purl.cisstat.org/cis/vocabs/measure#percentLvlWorkForce> ?valueCurr . | ||
| |
1.1 | 446 | } |
| 447 | FILTER(lang(?countryLabel) = 'ru' && | ||
| |
2.1 | 448 | (?country != <http://purl.cisstat.org/cis/vocabs/country/1.0#Ukraine>) && |
| 449 | (?country != <http://purl.cisstat.org/cis/vocabs/country/1.0#Tajikistan>) && | ||
| 450 | (?country != <http://purl.cisstat.org/cis/vocabs/country/1.0#Uzbekistan>) | ||
| |
1.1 | 451 | ) |
| 452 | } | ||
| 453 | ORDER BY ?valueCurr | ||
| 454 | } | ||
| 455 | BIND( | ||
| 456 | CONCAT( | ||
| 457 | ?countryLabel, | ||
| 458 | ' '@ru, | ||
| 459 | STR(ROUND(ABS(?vCurr)*100)/100.00), | ||
| 460 | '%' | ||
| 461 | ) as ?res | ||
| 462 | ) | ||
| 463 | } | ||
| 464 | " header="" links="false" mode="FIELD"/}} | ||
| 465 | |||
| 466 | ---- | ||
| 467 | |||
| 468 | = Экспертное мнение = | ||
| 469 | |||
| 470 | {{velocity}} | ||
| 471 | #set ($section = $xwiki.getDocument('.Экспертное мнение по уровню участия в рабочей силе 2022 года.WebHome')) | ||
| 472 | $section.display('expertise') | ||
| 473 | {{/velocity}} | ||
| 474 | |||
| 475 | = Таблицы и графики = | ||
| 476 | |||
| 477 | **Таблица 1. Численность рабочей силы, всего, по годам. ** | ||
| |
2.1 | 478 | {{html clean="false"}}<iframe style="border:none;" src="/QBOLAPBrowser/#dataset=http://purl.cisstat.org/data/manpowerY&lang=ru&col=0&row=1&exp=1&hideDataset=true" title="Численность рабочей силы, всего, по годам." width="100%" height="800px" role="presentation" allowfullscreen></iframe>{{/html}} |
| |
1.1 | 479 | **Таблица 2. Численность рабочей силы, по возрасту. ** |
| |
2.1 | 480 | {{html clean="false"}}<iframe style="border:none;" src="/QBOLAPBrowser/#dataset=http://purl.cisstat.org/data/manpowerA&lang=ru&col=1&row=2&exp=1&hideDataset=true" title="Численность рабочей силы, по возрасту." width="100%" height="800px" role="presentation" allowfullscreen></iframe>{{/html}} |
| |
1.1 | 481 | **Таблица 3. Численность рабочей силы, по полу. ** |
| |
2.1 | 482 | {{html clean="false"}}<iframe style="border:none;" src="/QBOLAPBrowser/#dataset=http://purl.cisstat.org/data/manpowerS&lang=ru&col=0&row=2&exp=1&hideDataset=true" title="Численность рабочей силы, по полу." width="100%" height="800px" role="presentation" allowfullscreen></iframe>{{/html}} |
| |
1.1 | 483 | **Таблица 4. Уровень участия в рабочей силе, по возрасту. ** |
| |
2.1 | 484 | {{html clean="false"}}<iframe style="border:none;" src="/QBOLAPBrowser/#dataset=http://purl.cisstat.org/data/lvlManpowerA&lang=ru&col=1&row=2&exp=1&hideDataset=true" title="Численность рабочей силы, по полу." width="100%" height="500px" role="presentation" allowfullscreen></iframe>{{/html}} |
| |
1.1 | 485 | **Таблица 5. Уровень участия в рабочей силе, по полу. ** |
| |
2.1 | 486 | {{html clean="false"}}<iframe style="border:none;" src="/QBOLAPBrowser/#dataset=http://purl.cisstat.org/data/lvlManpowerS&lang=ru&col=0&row=2&exp=1&hideDataset=true" title="Численность рабочей силы, по полу." width="100%" height="800px" role="presentation" allowfullscreen></iframe>{{/html}} |