Government Housing Expenditure Hungary by Kaggle | Finance and Economics

About this Dataset

Government Housing Expenditure Hungary

Financing Social Inclusion, 1990-2023

About this dataset

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!

More Datasets

For more datasets, click here.

Featured Notebooks

🚨 Your notebook can be here! 🚨!

How to use the dataset

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

Research Ideas

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

Acknowledgements

If you use this dataset in your research, please credit the original authors.
Data Source

License

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.

Columns

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)

Acknowledgements

If you use this dataset in your research, please credit the original authors.
If you use this dataset in your research, please credit .

Tables

Lakaskiadasok Values Wide

@kaggle.thedevastator_government_housing_expenditure_hungary.lakaskiadasok_values_wide

171.71 KB
91 rows
115 columns


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
);

Price Deflator

@kaggle.thedevastator_government_housing_expenditure_hungary.price_deflator

4.48 KB
37 rows
3 columns


CREATE TABLE price_deflator (
  "year" BIGINT,
  "price_deflator" BIGINT,
  "source" VARCHAR
);