Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Import and wrangle Budget Revenue data #18

Open
andkov opened this issue Sep 1, 2022 · 1 comment
Open

Import and wrangle Budget Revenue data #18

andkov opened this issue Sep 1, 2022 · 1 comment
Assignees
@andkov @velgaks
Labels
data wrangling

Comments

@andkov
Copy link
Contributor

andkov commented Sep 1, 2022 •
edited by velgaks

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
andkov added a commit that referenced this issue Sep 1, 2022
@andkov
kick off #18
7232cbe
andkov added a commit that referenced this issue Sep 1, 2022
@andkov
Update ellis-budget.R
e6dba70 
#18
velgaks added a commit that referenced this issue Sep 5, 2022
@velgaks
#18
0bdc972 
played a little with data: left values only for lowest admin levels, put tax types into columns - so one observation - one adm unit income on certain quarter and year
velgaks added a commit that referenced this issue Sep 9, 2022
@velgaks
#18
678b4ff
Tytser added a commit that referenced this issue Sep 19, 2022
@Tytser
Create ellis-budget-serhii.R
22fe83c 
#18 added visualizations with breakdown by rada and tax group
velgaks added a commit that referenced this issue Sep 20, 2022
@velgaks
#18
9294e39 
cleaned,
fixed data for second test hromada - seems working fine,
fixed big error in data preparation - check lines 121-125
velgaks added a commit that referenced this issue Sep 21, 2022
@velgaks
#18
60e03c6 
tried a few variants of hromadas amalgamation
velgaks added a commit that referenced this issue Sep 26, 2022
@velgaks
Create ellis-budget-hatsko-2020.R
dca5531 
#18
@velgaks
Copy link
Collaborator

velgaks commented Oct 2, 2022

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

velgaks added a commit that referenced this issue Oct 16, 2022
@velgaks
#18
3665cc0 
#18 created stable budget data for 2020-2022
velgaks added a commit that referenced this issue Oct 16, 2022
@velgaks
#18
98eb6ea 
#18 code for making stable budget data 2020-2022
velgaks added a commit that referenced this issue Oct 20, 2022
@velgaks
#18
6ebbb97 
#18
velgaks added a commit that referenced this issue Oct 20, 2022
@velgaks
#18
263de8b 
#18
velgaks added a commit that referenced this issue Oct 25, 2022
@velgaks
#18
a8f732f 
#18 finalised dataset for hromadas budget revenue with metadata
velgaks added a commit that referenced this issue Oct 25, 2022
@velgaks
#18
8636d78 
#18
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@andkov andkov

@velgaks velgaks

Labels
data wrangling
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@andkov @velgaks