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