The project investigates the effects of restructurization of local councils (i.e. "rada", N = 11,250) into amalgamated territorial communities (i.e. "hromada", N = 1,469) and the effect of this tranformation on key macroeconomic and social indicators. Of specific interest is hromadas' resiliance to full-scale russian invasion launched on 2022-02-24.
This repository contains all the materials used to study the factors of resilience of Ukrainian communities in the context of the Russian invasion.
Another goal of the project is to create a repository of data available in Ukraine at the hromada level for further use in research and policy-making.
The project is funded by GIZ within its project "Support to the Decentralisation Reform in Ukraine (UDU U-LEAD with Europe. Phase II) (#81281025)
Source: The Atlas of Administrative and Territorial Division
The repository has the following structure:
-
data-public:
-
data-public/raw: a folder with initial data on hromadas obtained from open sources or through requests to government agencies
-
data-public/derived: a folder with the final data that we received after processing the initial data with scripts (aggregation of data at the hromada level and calculation of new metrics)
-
-
manipulation: all the scripts which are used for data transformation of the raw data (the content of data-public/derived is a product of these scripts)
-
analysis: scripts for data analysis and data presentation within the project
-
scripts: useful functions for data wrangling/analysis
| Name | Role | @ |
|---|---|---|
| Tymofii Brik | Lead Researcher | |
| Andriy Darkovich | Research Assistant | |
| Valentyn Hatsko | Data Analyst | valgat29 |
| Andriy Koval | Reproducible Research | andkov |
| Maryna Rabinovych | Senior Researcher | |
| Myroslava Savisko | Project Manager | splanetina |
| Serhii Tytiuk | Data Analyst | tytser |
| Igor Piddubniy | Data Analyst | ipiddubnyi |
The Kyiv School of Economics (KSE) Institute conducted two surveys of hromadas in 2022 to study the impact of Russia's full-scale invasion on their economic performance and to identify factors of hromada resilience to various types of war-related shocks. The datasets of surveys results are nor available on the repository due to the sensitivity of some data.
Survey #1 |
Survey #2 |
|
|---|---|---|
Lead center |
KSE Agrocenter |
KSE Center for Sociological Research Decentralization |
Target audience |
Local authorities of hromadas |
Local authorities of hromadas |
Survey mode |
Web survey |
Web survey |
Sample size |
477 hromadas |
138 hromadas |
Fieldwork dates |
June-August 2022 |
October-November 2022 |
-
Resilience Survey overview - Results and Key findings of the Resiliance Survey
-
Hromada Dashboard - Dashboard with Data on Territorial Communities
-
Share of military PIT in total community revenues in 2021 and 2022 - Map of change in share of military PIT from VoxUkraine column
-
VoxUkraine. What makes territorial communities resilient – the first lessons after February 24
-
VoxUkraine. «Військовий» ПДФО: як може змінитися система спрямування податку та до чого це призведе
| Data Product Name | Description | Current State / Left To Do | Script |
|---|---|---|---|
| Admininstrative Units | Relationship among multiple administrative levels (settlement, rada, hromada, raion, oblast, region) | ready for analysis at ./data-public/derived/ua-admin-map-2020.csv |
./manipulation/ellis-ua-admin.R |
| Admin History | Composition of hromadas (what radas comprise it) at every point in time when such composition changed, from 2014 to 2020 | push to ./data-public/derived/ | ./manipulation/ellis-rada-hromada.R |
| Population | Population counts at the level of hromada (2021 only) | Add more years (currently only 2021), push to ./data-public/derived/ | ./manipulation/ellis-demography.R |
| Open Budget | Tax revenues of admin units | No clarity yet. Classify hromadas based on complexity of their admin history | ./manipulation/ellis-budget.R |
| Open Budget | Tax revenues of hromadas 2020-2022 | ready for analysis at ./data-public/derived/hromada_budget_2020_2022.xlsx |
./manipulation/ellis-budget-2020-2022.R |
| Geographic | Main spatial features of hromadas: area, coordinates of hromada center, travel time to oblast center, mountain hromadas, distance from hromada centers to the nearest point of the border with Russia, Russia or Belarus, or the EU; hromadas within 30 km of the sea/30 km of the border/30 km of the border with Russia and Belarus; hromadas within 15 km of international roads and national roads | ready for analysis at ./data-public/derived/geography.csv |
./manipulation/ellis-geography.R |
| Geographic | Spatial poligons of hromadas | Demonstate graphing maps (at hromada-raion-oblast level) using a replacable quantifier (e.g. population) | |
| Community Competence | Number of youth centers, youth councils and centers for entrepreneurial support (2021 only) | ready for analysis at ./data-public/derived/community-competence-hromada.csv |
./manipulation/ellis-community-competence.R |
| Health Declarations | Number of declarations with health facilities as of February 2022 | ready for analysis at ./data-public/derived/declarations-hromada.csv |
./manipulation/ellis-health.R |
| OSBB (Homeowners Associations) | Number of homeowners associations in 2015-2020 | ready for analysis at ./data-public/derived/osbb-hromada.csv |
./manipulation/ellis-health.R |
| Passengers | Number of passengers arriving at hromada railway stations in 2021 | push to ./data-public/derived/ | ./manipulation/ellis-osbb.R |
| ZNO (External Independent Examination) | Mean scores of ZNO (standardized test) for main subjects | Add more years (currently only 2021), push to ./data-public/derived/ | ./manipulation/ellis-zno.R |
| War zones | Statuses of the war zone/occupation according to the Ministry of Regional Development | push to ./data-public/derived | ./manipulation/ellis-war-status.R |
| E-dem | Form of electronic participation in hromadas | push to ./data-public/derived | ./manipulation/ellis-edem.R |
| DFRR | Data on cost of the projects financed by the State Regional Development Fund | ready for analysis | ./manipulation/ellis-dfrr.R |
You can contribute using Git or other GUI tools (more convenient option).
Now clone the forked repository to your machine. Go to your GitHub account, open the forked repository, click on the code button and then click the copy to clipboard icon. Open a terminal and run the following git command:
git clone https://github.com/kse-ua/KSE-Loc-Data-Hub.git
where "https://github.com/kse-ua/KSE-Loc-Data-Hub.git" (without the quotation marks) is the url to this repository (your fork of this project). See the previous steps to obtain the url.
For example:
git clone git@github.com:your-name/KSE-Loc-Data-Hub.git
where your-name is your GitHub username. Here you're copying the contents of the KSE-Loc-Data-Hub repository on GitHub to your computer.
Change to the repository directory on your computer (if you are not already there):
cd KSE-Loc-Data-Hub
Now create a branch using the git switch command:
git switch -c your-new-branch-name
For example:
git switch -c add-new-dataset
To make a commit to this project, follow these steps:
-
Make the necessary changes to the dataset, whether it's updating existing data or adding new data.
-
Save the dataset with your changes.
-
If you're adding a completely new dataset to the repository, place the dataset in the appropriate directory within the project.
-
To see the changes, navigate to the project directory in your terminal or command prompt and execute the command
git statusto see the changes. -
Use the following command to add the changes to your branch if you modified an existing dataset:
git add your-dataset-filenameReplace
your-dataset-filenamewith the name of the dataset you modified. -
If you're adding a completely new dataset, use the following command to add all new and modified files:
git add . -
Commit the changes with a descriptive message using the following command:
git commit -m "Add/Update data in your-dataset-filename"Be sure to replace
your-dataset-filenamewith the name of the dataset you worked on.
Push your changes using the command git push:
git push -u origin your-branch-name
replacing your-branch-name with the name of the branch you created earlier.
To submit your changes for review:
Go to your repository on GitHub and locate the "Compare & Pull Request" button. Click on this button to start the process.
Create a pull request, and as part of this request, provide a detailed comment that outlines the changes you've made, their significance, and any context that might be helpful for the reviewers. A clear and informative comment is crucial for a successful review.
After you've submitted your pull request, our team will review the changes you've proposed.
If your changes align with the project's goals and meet the necessary criteria, they will be merged into the main branch.
You will receive a notification email once your changes have been successfully merged into the project.
