Исходный код вики Занятость в СНГ в 2022 г.

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

Содружество стран

  • СНГ
    • Азербайджан
    • Армения
    • Беларусь
    • Казахстан
    • Кыргызстан
    • Молдова
    • Россия
    • Таджикистан
    • Туркменистан
    • Узбекистан
    • Украина

Языки