Government Housing Expenditure Hungary
Financing Social Inclusion, 1990-2023
@kaggle.thedevastator_government_housing_expenditure_hungary
Financing Social Inclusion, 1990-2023
@kaggle.thedevastator_government_housing_expenditure_hungary
By [source]
This dataset provides a detailed overview of the public expenditures on housing in Hungary since 1990, in order to better illustrate how the government has been tackling housing poverty through their resources. The sources of this data include the Budget Acts, Closing Accounts Acts and other public sources, allowing researchers and others to examine how much money is being used to reduce housing poverty and increase access to competitive housing. This data includes considerable information about each expenditure such as the name and code of each expenditure, its source, financial groupings and purpose (including who it benefits), as well as the amount of money spent in both Hungarian Forint currency (HUF_MIO_CP) and 2021 prices (HUF_MIO_2021P). Furthermore, this data also outlines whether or not a particular expenditure is part of any official national Housing Strategy or not. With all this valuable insight at hand, we can easily see where our money is going - so researchers, policy makers and private citizens alike can use this openly available data for a more informed decision making!
For more datasets, click here.
- 🚨 Your notebook can be here! 🚨!
This dataset provides a comprehensive overview of public expenditures on housing in Hungary from 1990 to 2023. It compiles publicly available data from the Budget Acts, Closing Accounts Acts and other sources. This dataset can be used to explore the relationships between government spending on housing, societal change, and public welfare initiatives.
In order to use this dataset effectively it is important to understand what information each of the columns provide. The Y column identifies the year of expenditure while HUF_MIO_CP and HUF_MIO_2021P provide the amount spent both in millions of Hungarian Forints (HUF) at current prices and 2021 prices respectively. OUTTURN indicates the actual amount spent on housing while PLANNED shows how much money was budgeted for spending in that year (and hence how much was over or underspent). NAME gives an indication of what type of expenditure is being reported while CODE helps identify more specific expenses within wider categories such as infrastructure development or residential construction.
SOURCE identifies where the data has been sourced from, with NAME_HU providing further detail when available in Hungarian language sources such as budget documents or reports from local government authorities etc. GROUP_AR_HU describes which group have benefitted most from particular investments, for example 'Low Income Households', 'Social Housing Providers' etc., with similar detail also given by BENEFITORIES showing who specifically has benefitted either directly (end-users) or indirectly (construction companies etc.). GROUP_FIN provides information concerning which funds are being drawn upon when making expenditure decisions - whether it be regional grants etc., with SOURCE providing further context into these funding decisions if necessary indicating whether they relate to Europe Union regulations etc.. YR indicates which calendar year a particular contribution relates to - so that patterns may be studied - whilst CP & FP indicate how much money has been spent directly out government coffers (Central/Local respectively).
Finally HS-YESNO refers to whether this contribution is part of an ongoing housing strategy i:e: planned medium-term interventions aimed at meeting society's long term goals such as meeting social needs or enhancing community cohesion via urban renewal projects etc., whilst HS-SINCE & HS-UNTIL help map out longer term trends – suggesting any recent changes/developments occurring within a particular sector – allowing us greater temporal awareness and understanding when making judgements as to why certain outcomes are prevalent today over others by looking back upon historical data collected previously yet held within this source document
- It can be used to create a visualization of public housing spending in Hungary over the years, showing changes in trends as well as identifying key areas for future investment and expenditure.
- It can be used to identify locations in Hungary that have higher levels of housing poverty and focus efforts on these areas by using predictive analytics to suggest potential policies or programs that target these specific areas.
- Researchers could use this dataset to better understand how public funds are allocated towards reducing housing poverty in Hungary, ultimately helping them inform governments and companies seeking direction on how best to allocate social inclusion initiatives towards underprivileged groups or communities within the country
If you use this dataset in your research, please credit the original authors.
Data Source
License: CC0 1.0 Universal (CC0 1.0) - Public Domain Dedication
No Copyright - You can copy, modify, distribute and perform the work, even for commercial purposes, all without asking permission. See Other Information.
File: lakastamogatasok_values.csv
| Column name | Description |
|---|---|
| Y | Year of the expenditure (Integer) |
| HUF_MIO_CP | Amount of money (in millions of Hungarian Forints) spent by Central Government (Integer) |
| HUF_MIO_2021P | Amount of money (in millions of Hungarian Forints) spent in 2021 (Integer) |
| OUTTURN | Actual amount of money spent (Integer) |
| PLANNED | Planned amount of money to be spent (Integer) |
| NAME | Name of the expenditure (String) |
| CODE | Code associated with the expenditure (String) |
| SOURCE | Source of the expenditure (String) |
File: lakaskiadasok_values_long.csv
| Column name | Description |
|---|---|
| NAME_HU | Name of the housing expenditure in Hungarian. (String) |
| GROUP_AR_HU | Classification of the expenditure according to legal coding in Hungarian. (String) |
| BENEF_HU | Beneficiaries of the expenditure in Hungarian. (String) |
| GROUP_FIN_HU | Financial group of the expenditure in Hungarian. (String) |
| HS_YESNO | Whether the expenditure is included in the national housing strategy. (Boolean) |
| HS_SINCE | Year since the expenditure has been part of the national housing strategy. (Integer) |
| HS_UNTIL | Year until the expenditure has been part of the national housing strategy. (Integer) |
| SOURCE_HU | Source of the expenditure in Hungarian. (String) |
| NAME_EN | Name of the housing expenditure in English. (String) |
| GROUP_AR_EN | Classification of the expenditure according to legal coding in English. (String) |
| BENEF_EN | Beneficiaries of the expenditure in English. (String) |
| GROUP_FIN_EN | Financial group of the expenditure in English. (String) |
| SOURCE_EN | Source of the expenditure in English. (String) |
| YEAR | Year of the expenditure. (Integer) |
| CP | Central Budget Expenditure (in millions of Hungarian Forints). (Integer) |
| FP | Local Budget Expenditure (in millions of Hungarian Forints). (Integer) |
If you use this dataset in your research, please credit the original authors.
If you use this dataset in your research, please credit .
CREATE TABLE lakaskiadasok_values_wide (
"name_hu" VARCHAR,
"group_ar_hu" VARCHAR,
"benef_hu" VARCHAR,
"group_fin_hu" VARCHAR,
"hs_yesno" VARCHAR,
"hs_since" VARCHAR,
"hs_until" VARCHAR,
"source_hu" DOUBLE,
"name_en" DOUBLE,
"group_ar_en" DOUBLE,
"benef_en" DOUBLE,
"group_fin_en" DOUBLE,
"source_en" DOUBLE,
"cp_1990" DOUBLE,
"cp_1991" DOUBLE,
"cp_1992" DOUBLE,
"cp_1993" DOUBLE,
"cp_1994" DOUBLE,
"cp_1995" DOUBLE,
"cp_1996" DOUBLE,
"cp_1997" DOUBLE,
"cp_1998" DOUBLE,
"cp_1999" DOUBLE,
"cp_2000" VARCHAR,
"cp_2001" VARCHAR,
"cp_2002" VARCHAR,
"cp_2003" VARCHAR,
"cp_2004" VARCHAR,
"cp_2005" VARCHAR,
"cp_2006" VARCHAR,
"cp_2007" VARCHAR,
"cp_2008" VARCHAR,
"cp_2009" VARCHAR,
"cp_2010" VARCHAR,
"cp_2011" VARCHAR,
"cp_2012" VARCHAR,
"cp_2013" VARCHAR,
"cp_2014" VARCHAR,
"cp_2015" VARCHAR,
"cp_2016" VARCHAR,
"cp_2017" VARCHAR,
"cp_2018" VARCHAR,
"cp_2019" VARCHAR,
"cp_2020" VARCHAR,
"cp_2021p" VARCHAR,
"cp_2022p" VARCHAR,
"cp_2023p" VARCHAR,
"fp_1990" VARCHAR,
"fp_1991" VARCHAR,
"fp_1992" VARCHAR,
"fp_1993" VARCHAR,
"fp_1994" VARCHAR,
"fp_1995" VARCHAR,
"fp_1996" VARCHAR,
"fp_1997" VARCHAR,
"fp_1998" VARCHAR,
"fp_1999" VARCHAR,
"fp_2000" VARCHAR,
"fp_2001" VARCHAR,
"fp_2002" VARCHAR,
"fp_2003" VARCHAR,
"fp_2004" VARCHAR,
"fp_2005" VARCHAR,
"fp_2006" VARCHAR,
"fp_2007" VARCHAR,
"fp_2008" VARCHAR,
"fp_2009" VARCHAR,
"fp_2010" VARCHAR,
"fp_2011" VARCHAR,
"fp_2012" VARCHAR,
"fp_2013" VARCHAR,
"fp_2014" VARCHAR,
"fp_2015" VARCHAR,
"fp_2016" VARCHAR,
"fp_2017" VARCHAR,
"fp_2018" VARCHAR,
"fp_2019" VARCHAR,
"fp_2020" VARCHAR,
"fp_2021p" VARCHAR,
"fp_2022p" VARCHAR,
"fp_2023p" VARCHAR,
"s_1990" VARCHAR,
"s_1991" VARCHAR,
"s_1992" VARCHAR,
"s_1993" VARCHAR,
"s_1994" VARCHAR,
"s_1995" VARCHAR,
"s_1996" VARCHAR,
"s_1997" VARCHAR,
"s_1998" VARCHAR,
"s_1999" VARCHAR,
"s_2000" VARCHAR,
"s_2001" VARCHAR,
"s_2002" VARCHAR,
"s_2003" VARCHAR,
"s_2004" VARCHAR,
"s_2005" VARCHAR,
"s_2006" VARCHAR,
"s_2007" VARCHAR,
"s_2008" VARCHAR
);CREATE TABLE price_deflator (
"year" BIGINT,
"price_deflator" BIGINT,
"source" VARCHAR
);Anyone who has the link will be able to view this.