Replication Data for the article: Oscar Gelderblom and Tim van der Valk, Coping with financial fragility: Dutch households in the Great Depression doi:10.34934/DVN/SHRQFN Social Sciences and Digital Humanities Archive – SODHA 2022-10-27 1 Gelderblom, Oscar; Van der Valk, Tim, 2022, "Replication Data for the article: Oscar Gelderblom and Tim van der Valk, Coping with financial fragility: Dutch households in the Great Depression", https://doi.org/10.34934/DVN/SHRQFN, Social Sciences and Digital Humanities Archive – SODHA, V1, UNF:6:CIyuADd5B6uGbHi4UFg1vA== [fileUNF] Replication Data for the article: Oscar Gelderblom and Tim van der Valk, Coping with financial fragility: Dutch households in the Great Depression doi:10.34934/DVN/SHRQFN Gelderblom, Oscar Van der Valk, Tim Social Sciences and Digital Humanities Archive – SODHA Gelderblom, Oscar Gelderblom, Oscar 2022-10-21 2022-10-27 Arts and Humanities Social Sciences Arts and Humanities Social Sciences Household finance Great Depression The Netherlands Consumption and consumer behaviour Economic conditions and indicators Income, property and investment/saving History In the article we analyze the financial behavior of Dutch households during the Great Depression with household level data on income and expenditure from contemporary budget surveys. The data we use consists of published budget surveys from the Netherlands, Amsterdam, The Hague, and Utrecht (1932-1937). The data are available on paper but we have created Excel files that contain a large part but not all of the data published on paper in the 1930s. We have exported the Excel Files in CSV format to R, which we then used to create the tables in our paper, to execute a regression analysis, and to perform additional analyses for the paper’s appendix. Budget surveys Netherlands Households <a rel="license" href="http://creativecommons.org/licenses/by/4.0/"><img alt="Creative Commons License" style="border-width:0" src="https://i.creativecommons.org/l/by/4.0/88x31.png" /></a><br />This work is licensed under a <a rel="license" href="http://creativecommons.org/licenses/by/4.0/">Creative Commons Attribution 4.0 International License</a> (CC-BY). Amsterdam1934.tab 78 29 text/tab-separated-values UNF:6:d+dAInU5g2vi96SZXagxnQ== DH1932.tab 90 38 text/tab-separated-values UNF:6:H/MsVdWKyImC2xfesD+WbA== DH1935.tab 129 29 text/tab-separated-values UNF:6:Ye7nqajudug85Z4HU4JBUg== income_distribution.tab 9 3 text/tab-separated-values UNF:6:0WrbdL2nS7frsn4hEMSAhQ== Gezinsnummer 53.26981940718083 88.0 . 186.0 89.58974358974355 78.0 7.0 0.0 UNF:6:i6E/+KbeEgxJp6T+CxZ5fw== Gezinsinfo UNF:6:W6cAr2F2L9twr2VnquyAWQ== Verbruikseenheden 3.897948717948718 3.625 0.0 1.9 . 78.0 7.85 1.6113327217533753 UNF:6:zuBL//a79miPaUYMwHFBsw== #Weeks . 78.0 0.5903260526902476 10.0 13.0 13.0 0.0 12.833333333333334 UNF:6:NjPwQtIXJikzki8RN0uCtg== Werkloosheidssteun 61.0 180.625 41.160359062757934 78.0 260.0 180.07051282051282 . 0.0 UNF:6:fBVg2gWXz0uxDTXSRv5UDg== Andere steun 1.466025641025641 0.0 78.0 5.2082009107374825 39.0 0.0 0.0 . UNF:6:/Xb+tcW45W9/eH48PlWp+Q== Brandstoffentoeslag 0.0 5.0 8.0 . 1.680231181467843 78.0 13.0 8.538461538461537 UNF:6:twL6KtbIpN6gLnp1sOLObg== Man 0.0 145.5 13.084358974358974 0.0 78.0 0.0 34.21026471574595 . UNF:6:fWqHe4clio/WDN/QHgBAYA== Vrouw 0.0 109.5 0.0 . 0.0 1.4288461538461543 12.397532010446668 78.0 UNF:6:xSnlarn+05aJbafgNHfI3A== Kinderen 36.23349723154488 0.0 148.75 . 20.44653846153846 0.0 78.0 0.0 UNF:6:Qw4PRRGTc2/0nmJuysm26Q== Geleend of uitbeleening 11.181116623659797 3.8037820512820515 78.0 72.5 . 0.0 0.0 0.0 UNF:6:yTvoTMmf188ArMUmZN5apQ== Onderhuur 0.0 0.0 78.0 . 5.27607774175062 39.0 0.8589743589743595 0.0 UNF:6:g4xjX7tlnkxsuSSjWJr0MQ== Invaliditeits- of weezenrente, Pensioen e.d. 0.0 50.5 0.0 9.141893909856655 2.0706410256410264 0.0 78.0 . UNF:6:iSPeCXiyGiQezz8bO+ghZw== Overige 0.0 0.0 2.293538461538462 0.0 . 51.501 8.476014645912453 78.0 UNF:6:bpIVxOll0/H0+nKN/MK0jQ== Diverse voorwerpen 0.0 0.0 78.0 1.55 4.961615384615384 7.819910238350828 39.01 . UNF:6:FBS54a7isRN08byMuCHL5Q== Schoolvoeding 0.0 0.0 39.0 9.245039980214482 3.903846153846154 0.0 . 78.0 UNF:6:o1o3uw6rwSzqTr6SrIeZ+Q== Schoolkleding 2.036794871794872 21.63 0.0 0.0 0.0 . 78.0 5.519123658460277 UNF:6:BSgjTCdFXlGTnvKte5PYXQ== Totaal 131.08 . 400.35 237.76 244.97923076923078 78.0 61.515668662211894 0.0 UNF:6:fjLKxBEsFtWm+LfU+iJpPw== Food 78.0 235.43 . 44.59 98.15 101.66897435897435 0.0 40.454350081206854 UNF:6:hOW4Z3HgzYGKKbjGsn1gUg== Clothing 78.0 7.868337399438456 6.63 0.0 31.655 0.195 8.822371794871795 . UNF:6:DzJDYBOxSnFWkKaydbpyCA== Footwear 3.1706153846153846 0.0 17.875 2.6 3.436730616540862 78.0 . 0.0 UNF:6:W6S8XveWWsr+Eo8gCrgEPA== Rent . 18.23150038880252 78.0 75.99641025641026 76.85 117.0 0.0 36.4 UNF:6:ZUshaQamcM6jQ0TLbtAaGw== Gas/El/Fuel 7.434964494622489 41.015 0.0 25.01628205128205 . 7.345 78.0 24.96 UNF:6:NSnjY47s+fBd7l/NgzF3LQ== Funeral/Health . 78.0 6.746141025641026 4.694475547722575 29.445 0.0 0.0 6.7275 UNF:6:KcWjmznqxeJpqdYjsABJOQ== Insurance 13.75 2.966064085929056 78.0 1.6036153846153844 0.0 . 0.0 0.0 UNF:6:ynBCd5+hT+KOexxuVW2bXw== Other . 6.18000000000004 78.0 94.705 19.760000000000048 16.875349475790706 24.63969230769231 0.0 UNF:6:3MPtUa/z9mKGHaZzdynv6A== Total 64.77411202311035 137.41 435.89 235.5275 0.0 247.66685897435897 78.0 . UNF:6:L7YyOMnPZ8b7Vwwsg2B2Eg== Saldo 36.22 13.940294969870127 0.1799999999999925 0.0 -2.6876282051282065 . -68.99 78.0 UNF:6:RCG5sxEgCNtrlGj1i7Rv9g== % 9.40253325585374E-4 -0.010787812809035605 0.05425920239972569 0.0 . 0.109924127465857 -0.256020401575311 78.0 UNF:6:M3dQ7d8qhkDeEdPjYY9Ebw== Volgnummer . 90.0 90.0 45.5 45.5 1.0 0.0 26.124700955226263 UNF:6:ymXpIfnr/AbY1G3IeP/8hQ== Beroep UNF:6:dNVoqcww78qseS+1WJ0p/w== #gezin . 4.0 0.0 13.0 90.0 2.121055493025673 4.466666666666665 2.0 UNF:6:n37F5Ucz+oNKQ5qwtCeEKA== #kinderen 11.0 2.1314188506963196 0.0 90.0 0.0 . 2.4555555555555557 2.0 UNF:6:HGY+o29Kre8AmczKk6ctSg== Groep UNF:6:sR4yUNkFqn8NvbxphqvJuA== #weken 0.0 90.0 13.0 . 3.900590563180533 10.766666666666667 13.0 1.0 UNF:6:B/RvHPZn4DU2uCPG6Qvoqg== Dag_werkloos 6.455555555555556 90.0 31.0 0.0 0.0 . 9.150626074376476 0.0 UNF:6:tgv+eNIHLTZDXofO09GsbA== Maand_werkloos 12.0 6.0 0.0 5.888888888888889 90.0 3.790717356570291 . 0.0 UNF:6:mR3NLNW12mmqJ3rdtys23Q== Jaar_werkloos 0.0 0.0 1931.0 1933.0 . 1845.6222222222223 400.26753911778906 90.0 UNF:6:ii4DjW6b/29XYjPEJZDJ9A== info_duur UNF:6:SFRAKT+YNWQbZkCY5Qhf9g== Man_loon 0.0 . 0.0 119.0 90.0 9.394555555555556 0.0 24.1558648593591 UNF:6:9wbE3QWgPbUOL3xI83BWnw== Vrouw_loon 1.5705555555555557 0.0 39.7 0.0 0.0 6.869256106971913 90.0 . UNF:6:nhMoz8q/MyaUkhSU5uT8ZQ== Zoonloon 52.45 . 7.274605004056488 0.0 0.0 0.0 1.1661111111111115 90.0 UNF:6:sEPRi6b68gQhupUVVJhKpg== Dochter_loon 2.313890368881162 . 0.0 90.0 20.0 0.0 0.36111111111111144 0.0 UNF:6:HvfuqKeCxMUwOSSO/vpIrg== Weekbedrag_Steun 90.0 0.0 . 22.5 18.5 18.507555555555555 6.0 2.8564971521121754 UNF:6:i+QeMQEhAVjnhUsvm8it6A== info_steun UNF:6:720Z/qI7fW/1ejfgw+aXTw== Totaal_Steun . 80.42289745468167 15.0 90.0 0.0 297.75 217.77499999999998 193.3117777777778 UNF:6:l57E/uVUircrsoqqrky8Ig== Ouderdomsrente 60.0 0.6666666666666674 0.0 0.0 0.0 . 90.0 6.324555320336751 UNF:6:cTn5hsaEawHVn4xIfCH5ZA== Dividend 0.0 90.0 0.0 2.5318888888888895 24.38 0.0 . 5.0919482363284265 UNF:6:Vkn9HljEqveeG1G5dNPE6A== Restitutie 0.0 0.0 10.5 . 1.2816772718642881 90.0 0.0 0.3 UNF:6:4uzexcS0QQmVJs+lRe6IPQ== Kerst uitkering 0.7444444444444448 90.0 0.0 17.0 . 0.0 2.6923157865732783 0.0 UNF:6:e+u9ePyHNDu/CMqJVyDn/w== Overig inkomen 18.411060088857074 118.0 0.0 0.0 . 90.0 4.323 0.0 UNF:6:501PD23TVOOHCZV9RVygfg== Omschrijving UNF:6:sfN/5Bp1NxU75EMErg1QOw== Voeding 2.1710555555555557 90.0 0.0 21.545 . 0.0 0.0 4.255092553321059 UNF:6:LzwRkOwnJ18CZ7i10xUp3g== Kleding 8.685211866646624 0.0 33.2 90.0 0.0 . 0.0 5.333999999999999 UNF:6:IfMXu2iwdG/OpFV1rAJe1A== Schoeisel 0.0 90.0 0.0 . 19.05 3.919045916913504 1.9073333333333333 0.0 UNF:6:z2LcHhqRwHWN8le4ryrFHg== Huisraad 0.0 90.0 24.12 0.8179999999999998 . 0.0 3.29096181426059 0.0 UNF:6:9yo+e8gGsE4P2I96m5zZrw== Rookwaren 0.0 0.40354886369962434 . 0.0 0.06999999999999998 0.0 90.0 3.08 UNF:6:0vGoQJwpakhQTuB93ROYLQ== Overig . 3.9993099108216805 0.0 90.0 0.0 20.15 1.5978888888888887 0.0 UNF:6:jT/UqJg4SH6YTdA9gRqRcg== Voedsel 0.3740212529094641 . 0.0 0.0 0.0 90.0 1.95 0.10411111111111113 UNF:6:3R+aFbabrZE7gEpqzjDaGA== Brandstof . 1.021259754246169 8.37 0.0 0.0 0.0 0.16244444444444436 90.0 UNF:6:F+XHSLpP9AWXUarAxTwB+g== Lening 1 45.0 2.696 0.0 0.0 90.0 0.0 7.6330965928321355 . UNF:6:VRozsSE2+juNeLUNFIpCTw== Totaal 219.14944444444444 90.23627069602387 245.97 . 0.0 15.0 382.01 90.0 UNF:6:etLTXqMpi8Bvw8oZKluA2A== Uitgaven 91.10316965889622 0.0 . 90.0 243.485 221.2048888888889 375.5 15.19 UNF:6:d+mi8kiXAjEUXQYKIFoi8w== Saldo -153.85 . 17.13 0.0 -7.211166666666666 21.718256572925366 -1.22 90.0 UNF:6:ClGm+UzQkcvqVFp66lqZlA== chksm 0.0 90.0 20.305963389892035 5.155722222222223 -1.0 158.0 0.0 . UNF:6:fEpkcoPs7y91rKBvmQzFNg== Opmerkingen UNF:6:AstDtZJ7nnc2yXexZAdirg== Leningv2 4.5 0.0 0.0 90.0 0.6941185502475443 . 0.13833333333333325 0.0 UNF:6:2tv8CvMR/gUiGk5D8i8Vsg== ID . 1.0 129.0 129.0 65.0 37.383151285037485 65.0 0.0 UNF:6:u7AH8o6NqL0GN86UCjtFOg== Gezinsnr_Bron 0.0 63.0 129.0 22.0 16.27619013498176 24.403100775193796 . 1.0 UNF:6:DwUZwyhJjaJIXs0s8foC9A== Deelname(weken) 2.0 11.573643410852714 13.0 2.836082227845446 0.0 13.0 129.0 . UNF:6:ZZwel+F/RwV1kGqxiROL4g== Beroep van het gezinshoofd UNF:6:mhchfszJ9W2A/81+nhAwVw== Status UNF:6:vlOGsFu8vkG3+BpLJhfdiw== Gezinshoofden gender...6 UNF:6:8cXd0BWgoYgBwTQOnCIHFQ== Gezinshoofden gender...7 UNF:6:Fz+XDNA730qI/DKOHredRw== Jongens 129.0 0.0 . 1.2820503503276293 0.0 1.0 1.6201550387596897 5.0 UNF:6:euG8QvbqnTeihjUh1fWQ6A== Meisjes 0.0 1.5891472868217054 9.0 129.0 0.0 1.4340306128007214 . 2.0 UNF:6:o7THciwgSfb7ReNqgzU+kQ== 15 of ouder 0.0 0.5962373948418126 . 0.2713178294573644 0.0 3.0 129.0 0.0 UNF:6:jaU8dA/gGGBieN/70fesUg== maand UNF:6:yOl5cp9ZbVT3V60BZWp2mw== maand2 3.708017580843563 0.0 7.0 12.0 . 6.550387596899225 0.0 129.0 UNF:6:GznrD8KsPGurSTdJZOOFxw== Jaar 1929.0 1935.0 . 0.0 129.0 1932.9612403100775 1.1551724761317694 1933.0 UNF:6:APQSO1/1t/ZTUMJvPeRhVg== Duur(maand) NaN NaN . NaN NaN NaN 129.0 0.0 UNF:6:MRn86w6tHQgE25D7DIejOA== steunbedrag per week bij aanvang onderzoek . 129.0 21.0 15.001937984496124 4.75 15.25 2.972119161242367 0.0 UNF:6:2L59uRYL1K9nQTJ4baPVag== Ontvangsten 11.41 3.3243093373288746 16.53 17.14565891472868 0.0 33.835 . 129.0 UNF:6:MikpwdHpaONhDCCQL01sIw== Loon 0.4576280690827462 0.2945736434108527 0.0 1.0 . 129.0 0.0 0.0 UNF:6:yg2Qr8dhN6wXtPwHqacjNA== Geschenken (o.a. familie, ook in natura) . 129.0 0.0 0.4083966095570272 1.0 0.2093023255813954 0.0 0.0 UNF:6:cefBCEEWkMBa5Wqfu8JW7g== Renten etc. 129.0 . 0.0 0.25574787730142756 0.06976744186046506 0.0 0.0 1.0 UNF:6:PSdmRBM5997orX1QRpzy2Q== Verhuur_kamer 0.0 1.0 0.1740143894967826 0.0 0.0 . 129.0 0.031007751937984447 UNF:6:GyXG7HMgvGKP+w+6hfmyVA== Kerk 129.0 0.0 0.21141137018112463 0.0 1.0 0.046511627906976695 . 0.0 UNF:6:XzrNCGwqSDjdNje1YqAQFA== Toeslag Werkverschaffing 1.0 0.0 . 0.0 129.0 0.3557732598202134 0.0 0.1472868217054264 UNF:6:Uzk1SqJoUiA4fx5Id3AEVA== Overig 0.0 0.0 0.19377422329196195 0.03875968992248062 . 129.0 0.0 1.0 UNF:6:XAjLnzZMBzFTlh0kc3JZ9Q== Waarde van schenkingen in natura 129.0 0.0 . 1.0744784528390086 0.0 6.07 0.5 0.8474031007751938 UNF:6:iONYkuMPcWG1EHqv9aX54Q== Uitgaven 0.0 17.167403100775193 . 10.19 129.0 3.2063263941176214 16.575 28.925 UNF:6:BtdrojJD6JB9nFO/txk59A== Leverancierskrediet 129.0 1.0 0.0 0.34785472107870613 . 0.0 0.13953488372093026 0.0 UNF:6:g+Ebhr/tGyjBgmaAFKn72A== Leningen 0.3478547210787064 129.0 0.0 0.0 1.0 0.13953488372093026 0.0 . UNF:6:wi63DwmSIP/MwvVA9jgpvg== Saldo -0.035 0.7439776147538613 . -0.06810852713178292 0.0 129.0 4.91 -3.715 UNF:6:rNKLNzF6e1l1lkdmGA4VgQ== Bijzonderheden UNF:6:3wcOj4tXuiNMUEmkdA+pYw== range UNF:6:+Sw2fdE4BW3QhfP+3Y++gA== N UNF:6:fzs/7b9txnoYbCVcXC/Sfg== share 0.0 0.1599176946730176 0.0341331946602562 0.463494001040048 . 0.11111111111111106 9.0 1.61145173896662E-4 UNF:6:LQrehpDd4KvD5myguVfb1w== Document.dcf application/octet-stream export_data.R type/x-r-syntax hhbudget.csv text/csv hhbudgetprimary.csv text/csv howitsmade.html text/html howitsmade.log text/plain howitsmade.Rmd application/octet-stream howitsmade.tex application/x-tex land.csv text/csv NL598.csv text/csv NL700.csv text/csv Publish Document.dcf application/octet-stream .Rhistory application/octet-stream savings.csv text/csv shapefile598.csv text/csv shapefile598.dbf application/dbf shapefile598.shp application/shp shapefile598.shx application/shx shapefile700.dbf application/dbf shapefile700.shp application/shp shapefile700.shx application/shx unemployment.csv text/csv