THE SPECIFIC FEATURES OF THE OFFICIAL STATISTICS

class: center, middle, inverse, title-slide

# THE SPECIFIC FEATURES OF THE OFFICIAL STATISTICS
## OF CR AND THE TRACE OF PANDEMICS
### Alexander Shemetev
### MEsto
### 2021/11/07 (updated: 2021-11-10)

---

# The research questions are:

What patterns can be analyzed based on Czech statistics considered typical for Czech micro-regions?

What changes in the designs are specific for the Czech Republic in times of pandemics?

---

# Topics:

1) Methodology and data

2) Results and discussion

3) Conclusions

---

background-image: url(data:image/png;base64,#1.jpg)
class: inverse, bottom, inverse
background-size: contain

background-image: url(data:image/png;base64,#1_1.jpg)
class: inverse, bottom, inverse
background-size: contain

# The correlation matrix of the leading indicators available from the official statistics (CR)

---

background-image: url(data:image/png;base64,#2.jpg)
class: inverse, bottom, inverse
background-size: contain

# The scheme for the zones 1-3 of the correlation matrix

---

background-image: url(data:image/png;base64,#3.jpg)
class: inverse, bottom, inverse
background-size: contain

# The death patterns in the Czech Republic [CR] in 2014-2020 (per capita)

---

background-image: url(data:image/png;base64,#4.jpg)
class: inverse, bottom, inverse
background-size: contain

# Developments of deaths per capita in the Czech Republic by the presence of a doctor in a municipality

---

background-image: url(data:image/png;base64,#5.jpg)
class: inverse, bottom, inverse
background-size: contain

# Developments of deaths per capita in the Czech Republic by the quantiles of municipalities in 2014-2020

---

background-image: url(data:image/png;base64,#6.jpg)
class: inverse, bottom, inverse
background-size: contain

# Per capita mortality rate for municipalities with doctors and without doctors

---

background-image: url(data:image/png;base64,#7_1.jpg)
class: inverse, bottom, inverse
background-size: contain

# Developments in movements in the Czech Republic in 2020

(as of January level summed up by means for micro-regions)

---

background-image: url(data:image/png;base64,#7_2.jpg)
class: inverse, bottom, inverse
background-size: contain

# Evolutions in movements in the Czech Republic and new COVID cases per 100 000 in 2020

---

background-image: url(data:image/png;base64,#A.jpg)
class: inverse, bottom, inverse
background-size: contain

# The statistical effect of having doctors in the Czech municipalities for the deaths per capita

---

background-image: url(data:image/png;base64,#B.jpg)
class: inverse, bottom, inverse
background-size: contain

# The statistical effect of pandemics on the mobility in the Czech municipalities to the average mobility changes

---

class: inverse, center, middle

# Appendix to the presentation

---

background-image: url(data:image/png;base64,#8.jpg)
class: inverse, bottom, inverse
background-size: contain

# Data availability

---

# Names of indicators

<div style="border: 1px solid #ddd; padding: 0px; overflow-y: scroll; height:450px; overflow-x: scroll; width:100%; "><table class="table table-striped" style="width: auto !important; margin-left: auto; margin-right: auto;">
 <thead>
  <tr>
   <th style="text-align:left;position: sticky; top:0; background-color: #FFFFFF;"> Column Names </th>
   <th style="text-align:left;position: sticky; top:0; background-color: #FFFFFF;"> English Name </th>
  </tr>
 </thead>
<tbody>
  <tr>
   <td style="text-align:left;"> Obe_kod </td>
   <td style="text-align:left;"> Village code </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Obe_zev </td>
   <td style="text-align:left;"> Village name </td>
  </tr>
  <tr>
   <td style="text-align:left;"> MASnaz </td>
   <td style="text-align:left;"> MAS name by 12.6.2015 </td>
  </tr>
  <tr>
   <td style="text-align:left;"> MASnumb </td>
   <td style="text-align:left;"> MAS queue number by 12.6.2015 </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Okr_kod </td>
   <td style="text-align:left;"> District code </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Okr_zev </td>
   <td style="text-align:left;"> District name </td>
  </tr>
  <tr>
   <td style="text-align:left;"> ORPkod </td>
   <td style="text-align:left;"> SO ORP code </td>
  </tr>
  <tr>
   <td style="text-align:left;"> ORPnaz </td>
   <td style="text-align:left;"> SO ORP name </td>
  </tr>
  <tr>
   <td style="text-align:left;"> POuKod </td>
   <td style="text-align:left;"> SO POÚ code </td>
  </tr>
  <tr>
   <td style="text-align:left;"> PouNaz </td>
   <td style="text-align:left;"> SO POÚ name </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Kra_kod </td>
   <td style="text-align:left;"> County code </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Kra_zev </td>
   <td style="text-align:left;"> County name </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Sta_bce </td>
   <td style="text-align:left;"> Statute of the village </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Poc_bce </td>
   <td style="text-align:left;"> Number of parts of the village </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Cel_aha </td>
   <td style="text-align:left;"> Total area (ha) </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Orn__ha </td>
   <td style="text-align:left;"> Arable land (ha) </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Chm__ha </td>
   <td style="text-align:left;"> Hops (ha) </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Vin__ha </td>
   <td style="text-align:left;"> Vineyard (ha) </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Zah__ha </td>
   <td style="text-align:left;"> Gardens (ha) </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Ovo__ha </td>
   <td style="text-align:left;"> Fruit sets (ha) </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Trv__ha </td>
   <td style="text-align:left;"> Permanent grassland (ha) </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Zem__ha </td>
   <td style="text-align:left;"> Farmland (ha) </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Les__ha </td>
   <td style="text-align:left;"> Forest land (ha) </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Vod__ha </td>
   <td style="text-align:left;"> Water surfaces (ha) </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Zas__ha </td>
   <td style="text-align:left;"> Built - up areas and courtyards (ha) </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Ost__ha </td>
   <td style="text-align:left;"> Other areas (ha) </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Nez__ha </td>
   <td style="text-align:left;"> Non - agricultural land (ha) </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Nobyv </td>
   <td style="text-align:left;"> Population as of 31.12. - total </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Nzeny </td>
   <td style="text-align:left;"> Population as of 31.12. - women </td>
  </tr>
  <tr>
   <td style="text-align:left;"> naroz </td>
   <td style="text-align:left;"> Total live births </td>
  </tr>
  <tr>
   <td style="text-align:left;"> smrt </td>
   <td style="text-align:left;"> Total deaths </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Immig </td>
   <td style="text-align:left;"> Total immigrants </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Emmig </td>
   <td style="text-align:left;"> Total emigrants </td>
  </tr>
  <tr>
   <td style="text-align:left;"> N0_14 </td>
   <td style="text-align:left;"> Total population aged 0-14 </td>
  </tr>
  <tr>
   <td style="text-align:left;"> N15_64 </td>
   <td style="text-align:left;"> Total population aged 15–64 </td>
  </tr>
  <tr>
   <td style="text-align:left;"> N65_ </td>
   <td style="text-align:left;"> Total population aged 65 and over </td>
  </tr>
  <tr>
   <td style="text-align:left;"> RESPodn </td>
   <td style="text-align:left;"> RES - total number of subjects with detected activity </td>
  </tr>
  <tr>
   <td style="text-align:left;"> RESagro </td>
   <td style="text-align:left;"> RES - subjects in CZ-NACE- A Agriculture, forestry, fishing </td>
  </tr>
  <tr>
   <td style="text-align:left;"> RESB_E </td>
   <td style="text-align:left;"> RES - entities in CZ-NACE, subcodes B-E (Mining and Industry total) </td>
  </tr>
  <tr>
   <td style="text-align:left;"> RESB </td>
   <td style="text-align:left;"> RES - subjects in CZ-NACE- B Mining and quarrying </td>
  </tr>
  <tr>
   <td style="text-align:left;"> RESC </td>
   <td style="text-align:left;"> RES - subjects in CZ-NACE- C Manufacturing </td>
  </tr>
  <tr>
   <td style="text-align:left;"> RESD </td>
   <td style="text-align:left;"> RES - subjects in CZ-NACE- D Production and distribution of electricity, gas, heat and air conditioning </td>
  </tr>
  <tr>
   <td style="text-align:left;"> RESE </td>
   <td style="text-align:left;"> RES - subjects in CZ-NACE- E Stock. water; activities related. with waste. water, waste and remediation </td>
  </tr>
  <tr>
   <td style="text-align:left;"> RESF </td>
   <td style="text-align:left;"> RES - subjects in CZ-NACE- F Construction </td>
  </tr>
  <tr>
   <td style="text-align:left;"> RESG </td>
   <td style="text-align:left;"> RES - entities in CZ-NACE- G Wholesale and retail trade; repair and maintenance of motor vehicles </td>
  </tr>
  <tr>
   <td style="text-align:left;"> RESH </td>
   <td style="text-align:left;"> RES - subjects in CZ-NACE- H Transport and storage </td>
  </tr>
  <tr>
   <td style="text-align:left;"> RESI </td>
   <td style="text-align:left;"> RES - subjects in CZ-NACE- I Accommodation, food and beverage service activities </td>
  </tr>
  <tr>
   <td style="text-align:left;"> RESJ </td>
   <td style="text-align:left;"> RES - entities in CZ-NACE- J Information and communication activities </td>
  </tr>
  <tr>
   <td style="text-align:left;"> RESK </td>
   <td style="text-align:left;"> RES - entities in CZ-NACE- K Financial and insurance activities </td>
  </tr>
  <tr>
   <td style="text-align:left;"> RESL </td>
   <td style="text-align:left;"> RES - subjects in CZ-NACE- L Real estate activities </td>
  </tr>
  <tr>
   <td style="text-align:left;"> RESM </td>
   <td style="text-align:left;"> RES - subjects in CZ-NACE- M Professional, scientific and technical activities </td>
  </tr>
  <tr>
   <td style="text-align:left;"> RESN </td>
   <td style="text-align:left;"> RES - entities in CZ-NACE- N Administrative and support service activities </td>
  </tr>
  <tr>
   <td style="text-align:left;"> RESO </td>
   <td style="text-align:left;"> RES - subjects in CZ-NACE- O Public administration and defense; compulsory social security </td>
  </tr>
  <tr>
   <td style="text-align:left;"> RESP </td>
   <td style="text-align:left;"> RES - subjects in CZ-NACE- P Education </td>
  </tr>
  <tr>
   <td style="text-align:left;"> RESQ </td>
   <td style="text-align:left;"> RES - subjects in CZ-NACE- Q Health and social work </td>
  </tr>
  <tr>
   <td style="text-align:left;"> RESR </td>
   <td style="text-align:left;"> RES - subjects in CZ-NACE- R Cultural, entertainment and recreation activities </td>
  </tr>
  <tr>
   <td style="text-align:left;"> RESS </td>
   <td style="text-align:left;"> RES - subjects in CZ-NACE- S Other activities </td>
  </tr>
  <tr>
   <td style="text-align:left;"> REST </td>
   <td style="text-align:left;"> RES - subjects in CZ-NACE- T Activities of households as employers… and activities for own use </td>
  </tr>
  <tr>
   <td style="text-align:left;"> RESU </td>
   <td style="text-align:left;"> RES - subjects in CZ-NACE- U Activities of extraterritorial organizations and bodies </td>
  </tr>
  <tr>
   <td style="text-align:left;"> RESother </td>
   <td style="text-align:left;"> RES - subjects in CZ-NACE- Not classified </td>
  </tr>
  <tr>
   <td style="text-align:left;"> RESGUP </td>
   <td style="text-align:left;"> RES - legal form - National organization </td>
  </tr>
  <tr>
   <td style="text-align:left;"> RESOAO </td>
   <td style="text-align:left;"> RES - legal form - Joint stock companies (from trading companies, total) </td>
  </tr>
  <tr>
   <td style="text-align:left;"> RTrade </td>
   <td style="text-align:left;"> RES - legal form - Trading companies </td>
  </tr>
  <tr>
   <td style="text-align:left;"> RCooper </td>
   <td style="text-align:left;"> RES - legal form - Cooperative organizations </td>
  </tr>
  <tr>
   <td style="text-align:left;"> RESIP </td>
   <td style="text-align:left;"> RES - legal form - Self-employed persons </td>
  </tr>
  <tr>
   <td style="text-align:left;"> RFrelanc </td>
   <td style="text-align:left;"> RES - legal form - Freelance professions </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Rfarmer </td>
   <td style="text-align:left;"> RES - legal form - Agricultural entrepreneurs </td>
  </tr>
  <tr>
   <td style="text-align:left;"> R_others </td>
   <td style="text-align:left;"> RES - legal form - Other </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Unempl </td>
   <td style="text-align:left;"> Number of applicants - total </td>
  </tr>
  <tr>
   <td style="text-align:left;"> UnOZP </td>
   <td style="text-align:left;"> Number of applicants - PWD - total </td>
  </tr>
  <tr>
   <td style="text-align:left;"> UnDo18 </td>
   <td style="text-align:left;"> Number of juvenile applicants (up to 18 years of age) - total </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Un50_ </td>
   <td style="text-align:left;"> Number of applicants aged 50 and over - total </td>
  </tr>
  <tr>
   <td style="text-align:left;"> AgeUn </td>
   <td style="text-align:left;"> Average age of applicants - total </td>
  </tr>
  <tr>
   <td style="text-align:left;"> UnAbsolv </td>
   <td style="text-align:left;"> Number of applicants - graduates - total </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Un12Mes </td>
   <td style="text-align:left;"> Number of applicants - records over 12 months - total </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Nez </td>
   <td style="text-align:left;"> Share of unemployed persons, total </td>
  </tr>
  <tr>
   <td style="text-align:left;"> NezMuz </td>
   <td style="text-align:left;"> Proportion of unemployed persons men </td>
  </tr>
  <tr>
   <td style="text-align:left;"> NezZen </td>
   <td style="text-align:left;"> Proportion of unemployed persons women </td>
  </tr>
  <tr>
   <td style="text-align:left;"> MSNTrid </td>
   <td style="text-align:left;"> Kindergarten - NUMBER OF CLASSES </td>
  </tr>
  <tr>
   <td style="text-align:left;"> ZS1_5Trid </td>
   <td style="text-align:left;"> Elementary school - only the first grade (1st - 5th grade) NUMBER OF CLASSES </td>
  </tr>
  <tr>
   <td style="text-align:left;"> ZS6_9Trid </td>
   <td style="text-align:left;"> Elementary school - only second grade (6th - 9th grade) NUMBER OF CLASSES </td>
  </tr>
  <tr>
   <td style="text-align:left;"> ZS1_9Trid </td>
   <td style="text-align:left;"> Elementary school - first and second grade (1st - 9th grade) NUMBER OF CLASSES </td>
  </tr>
  <tr>
   <td style="text-align:left;"> ZSNTrid </td>
   <td style="text-align:left;"> Elementary school - total NUMBER OF CLASSES </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Ngymn </td>
   <td style="text-align:left;"> Secondary school - grammar schools - NUMBER OF SCHOOLS </td>
  </tr>
  <tr>
   <td style="text-align:left;"> NPTU </td>
   <td style="text-align:left;"> Secondary schools - fields of secondary vocational and practical schools - NUMBER OF SCHOOLS </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Nucilish </td>
   <td style="text-align:left;"> Secondary schools - fields of secondary vocational schools and vocational schools NUMBER OF SCHOOLS </td>
  </tr>
  <tr>
   <td style="text-align:left;"> NZakUmS </td>
   <td style="text-align:left;"> Elementary art schools NUMBER OF SCHOOLS </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Azyl </td>
   <td style="text-align:left;"> Asylum houses - number </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Nocle </td>
   <td style="text-align:left;"> Dormitories - number </td>
  </tr>
  <tr>
   <td style="text-align:left;"> DenStac </td>
   <td style="text-align:left;"> Day hospitals - number </td>
  </tr>
  <tr>
   <td style="text-align:left;"> DomZcet </td>
   <td style="text-align:left;"> Homes for the disabled - number </td>
  </tr>
  <tr>
   <td style="text-align:left;"> DomScet </td>
   <td style="text-align:left;"> Homes for the elderly - number </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Chr_cet </td>
   <td style="text-align:left;"> Sheltered housing - number </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Niz_cet </td>
   <td style="text-align:left;"> Low - threshold facilities for children and young people - number </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Soc_cet </td>
   <td style="text-align:left;"> Social counseling - number </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Sdr_eni </td>
   <td style="text-align:left;"> Combined outpatient facilities </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Det_eni </td>
   <td style="text-align:left;"> Detached workplaces of the association. outpatient. device </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Zdr_ska </td>
   <td style="text-align:left;"> Medical centers </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Det_sek </td>
   <td style="text-align:left;"> Details. workplace of health centers </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Hospit </td>
   <td style="text-align:left;"> Hospital </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Det_ice </td>
   <td style="text-align:left;"> Detached hospital workplace </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Odb_LDN </td>
   <td style="text-align:left;"> Specialized medical institutions (except LDN) </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Det_avu </td>
   <td style="text-align:left;"> Detašov. workplace of professional treatment. of the Institute </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Lec_cne </td>
   <td style="text-align:left;"> Treatment center for long-term patients </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Det_ych </td>
   <td style="text-align:left;"> Detašov. workplace of a hospital for long-term patients </td>
  </tr>
  <tr>
   <td style="text-align:left;"> DoctDos </td>
   <td style="text-align:left;"> Separate practice pract. doctors for adults incl. detail. work. </td>
  </tr>
  <tr>
   <td style="text-align:left;"> DocDeti </td>
   <td style="text-align:left;"> Solitude. practice ord. medicine. for children and adolescents incl. detail. work. </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Stomat </td>
   <td style="text-align:left;"> Solitude. practice ord. medicine. dentist incl. detail. work. </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Gynek </td>
   <td style="text-align:left;"> Solitude. practice ord. medicine. gynecologist incl. detail. work. </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Doctors </td>
   <td style="text-align:left;"> Solitude. specialist doctor's office incl. detail. work. </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Ost_ist </td>
   <td style="text-align:left;"> Other separate devices incl. detail. workplaces </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Zar_ist </td>
   <td style="text-align:left;"> Pharmacy care facilities (pharmacies) incl. detail. workplaces </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Str__pr </td>
   <td style="text-align:left;"> Rescue Center services and fast health. help incl. detail. pr. </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Hro_ely </td>
   <td style="text-align:left;"> Collective accommodation facilities - hotels, motels </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Hro_ony </td>
   <td style="text-align:left;"> Collective accommodation facilities - guesthouses </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Hro_vny </td>
   <td style="text-align:left;"> Collective accommodation facilities - tourist hostels </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Hro_ady </td>
   <td style="text-align:left;"> Collective accommodation facilities - camps, cottage settlements </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Hro_tni </td>
   <td style="text-align:left;"> Collective accommodation establishments - other </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Year </td>
   <td style="text-align:left;"> Year </td>
  </tr>
  <tr>
   <td style="text-align:left;"> MasNo </td>
   <td style="text-align:left;"> MAS name by 20.6.2016 </td>
  </tr>
  <tr>
   <td style="text-align:left;"> RES_All </td>
   <td style="text-align:left;"> MAS queue number by 20.6.2016 </td>
  </tr>
  <tr>
   <td style="text-align:left;"> UnDo19 </td>
   <td style="text-align:left;"> RES - entities in CZ-NACE B to E Mining and Industry total </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Un24Mes </td>
   <td style="text-align:left;"> Number of juvenile applicants (up to 19 years of age) - total </td>
  </tr>
  <tr>
   <td style="text-align:left;"> Poc_kem </td>
   <td style="text-align:left;"> Number of applicants - records over 24 months - total </td>
  </tr>
  <tr>
   <td style="text-align:left;"> MASNaz1 </td>
   <td style="text-align:left;"> MAS name by 29.5.2017 </td>
  </tr>
  <tr>
   <td style="text-align:left;"> MASNo1 </td>
   <td style="text-align:left;"> MAS queue number by 29.5.2017 </td>
  </tr>
  <tr>
   <td style="text-align:left;"> MASNaz2 </td>
   <td style="text-align:left;"> MAS name by 11.6.2018 </td>
  </tr>
  <tr>
   <td style="text-align:left;"> MASNo2 </td>
   <td style="text-align:left;"> MAS queue number by 11.6.2018 </td>
  </tr>
  <tr>
   <td style="text-align:left;"> MatSNDeti </td>
   <td style="text-align:left;"> Kindergarten - NUMBER OF CHILDREN </td>
  </tr>
  <tr>
   <td style="text-align:left;"> ZakSNDeti </td>
   <td style="text-align:left;"> Elementary school - only the first grade (1st - 5th grade) NUMBER OF PUPILS </td>
  </tr>
  <tr>
   <td style="text-align:left;"> PC </td>
   <td style="text-align:left;"> Per Capita </td>
  </tr>
</tbody>
</table></div>