Import and wrangle Budget Revenue data

kse-ua / KSE-Loc-Data-Hub

Building a Comprehensive Repository of Hromada-Level Data in Ukraine to Facilitate Research and Informed Policy Decisions. This repository supports the collection and accessibility of critical data at the hromada level in Ukraine for research and policy development.

https://kse.ua/kse-impact/center-for-sociological-research-decentralization-and-regional-development/

MIT License

10 stars 4 forks source link

Import and wrangle Budget Revenue data #18

Open andkov opened 2 years ago

andkov commented 2 years ago

Data tables have been provisioned by @velgaks and placed in the shared folder data-private/raw. The names of the file follow the pattern "revenue-NN.xlsx"

Use ./manipulation/ellis-budget.R to organize the code for wrangling this data into analysis-ready form.

Source: BOOST-analysis from OpenBudget. Data comes from the Ministry of Finance

velgaks commented 1 year ago

Potential tasks for budget data for Mar-Jul 2020-2021 ('budget_data_2021_2022_for_map.csv'):

[ ] Compare amount and share of own revenue and transferts (in general, by region, by oblasts, etc.)
[ ] Compare amount and share of particular revenues in own revenue (in general, by region, by oblasts, etc.)
[ ] Look in detail at the personal income tax for army personnel, its influence on amount of own revenue