Mexican Wealth Distribution 1810-1910

The zip files contain several files with wills from Mexico between 1810 and 1910 collected in order to measure Mexican wealth distribution in its first century of independence. The main file is wills_clean.xlsx, which contains the full collection of wills; in that file, you will find variables for year, state, and wealth, not excluding debts, debts and wealth (net wealth). You can combine this file with the do file cleaningroutine_for_social_tables to produce the detailed social tables. The rest of the files consist of data files with the social tables (for comparison) and xlsx files with the wills from the main file divided by decade to facilitate calculations using the do file inequality_analysis_ routine_clean.do from which you will be able to reproduce the rest of the analysis (unbalanced sample and generalized beta, lognormal, etc.) Note: The calculation programs are .do files; thus, they require stata to be executed. Some of the detailed social tables are dta files, and thus also stata files. You can open them in R and work with them or convert them to any other data format. The wills come from 5 different Mexican archives: Archivo Histórico de Notarias de la Ciudad de México, Archivo General del Estado de Yucatán, Archivo Municipal de Saltillo, Archivo Histórico de la Ciudad de Morelia and, Testamentos del Colegio de Sonora.本压缩包收录了1810年至1910年间的墨西哥遗嘱档案，本数据集旨在测算墨西哥独立建国首百年间的财富分配格局。核心数据文件为wills_clean.xlsx，收录了全部遗嘱样本；该文件包含年份、所属州别、未扣除债务的总资产、债务及净资产等变量。您可将该文件与do文件cleaningroutine_for_social_tables结合使用，以生成精细化社会分层数据表。 其余文件包括用于对照的社会分层数据表文件，以及按十年分组拆分主文件中遗嘱样本的xlsx格式文件，便于借助do文件inequality_analysis_routine_clean.do开展计算；通过该程序可复现全部剩余分析流程，包括非平衡样本分析、广义贝塔分布（generalized beta）、对数正态分布（lognormal）等模型的应用。 注：本数据集的计算程序均为.do格式文件，需依托Stata软件运行。部分精细化社会分层数据表为dta格式文件，同样属于Stata原生数据格式。您可在R语言环境中打开并处理此类文件，或将其转换为任意其他数据格式。 本次收录的遗嘱来自墨西哥5家官方档案馆：墨西哥城历史公证人档案馆（Archivo Histórico de Notarias de la Ciudad de México）、尤卡坦州总档案馆（Archivo General del Estado de Yucatán）、萨尔蒂约市市政档案馆（Archivo Municipal de Saltillo）、莫雷利亚市历史档案馆（Archivo Histórico de la Ciudad de Morelia）以及索诺拉学院遗嘱档案库（Testamentos del Colegio de Sonora）。