Spreadsheet: 173301d1344511015-creating-panel-data-for-stata-samplepanel
Sheet: samplepanel

Year | Country | Revenue > Taxes > Taxes on income, profits, & capital gains [111] | Revenue > Taxes > Taxes on payroll and workforce [112] | Revenue > Taxes > Taxes on property [113] | Revenue > Taxes > Taxes on goods and services [114] | Revenue > Taxes > Taxes on int'l. trade and transactions [115] | Revenue > Taxes > Other taxes [116] | Revenue > Social contributions > Social security contributions [121] | Revenue > Other revenue [14] | Total outlays > General public services [701] | Total outlays > Defense [702] | Total outlays > Public order and safety [703] | Total outlays > Economic affairs [704] | Total outlays > Environmental protection [705] | Total outlays > Housing and community amenities [706] | Total outlays > Health [707] | Total outlays > Recreation, culture, and religion [708] | Total outlays > Education [709] | Total outlays > Social protection [710]
1995 | 1 | 19518.2 | 4494.92 | 1081.09 | 19762.2 | 93.44 | 0 | 21456 | 12482.9 | 15158.6 | 1745.84 | 2756.84 | 10038.1 | 2118.72 | 2652.24 | 13725.4 | 1726.97 | 10204.1 | 38301.6
1996 | 1 | 21986.8 | 4587.97 | 1107.14 | 21362 | -0.36 | 0 | 22180.9 | 12846.9 | 15774.9 | 1746.52 | 2814.85 | 9905.48 | 2257.43 | 2707.83 | 14102 | 1761.51 | 10396.5 | 39395.9
1997 | 1 | 23845.9 | 4721.11 | 1087.53 | 22570.4 | 0.55 | 0 | 22857.2 | 10513.1 | 15055.4 | 1773.18 | 2937.75 | 9161.81 | 632.65 | 1521.3 | 15458.3 | 1855.01 | 10712.8 | 39451.5
1998 | 1 | 25065.9 | 4873.97 | 1122.65 | 23668.2 | 0.67 | 0 | 23595.2 | 10323.6 | 15807.2 | 1816.77 | 3022.51 | 10261.9 | 677.5 | 1664.77 | 16257 | 1892.85 | 11017.7 | 40655.5
1999 | 1 | 25264.3 | 5045.09 | 1167.12 | 24787.1 | 6.85 | 0 | 24484.5 | 11014.5 | 15962.8 | 1809.11 | 3121.59 | 9847.58 | 1048.05 | 1574.89 | 17127 | 2033.96 | 11408.5 | 42511.7
2000 | 1 | 26052.3 | 5192.94 | 1206.42 | 25427 | -4.84 | 0 | 25159.8 | 11288.5 | 16369.8 | 1930.69 | 3129.94 | 9186.99 | 1104.51 | 1682.29 | 17428.6 | 1941.81 | 11578.6 | 43933.8
2001 | 1 | 30550.4 | 5384.34 | 1258 | 26327.6 | -5.86 | 0 | 25808.4 | 9997.03 | 17112 | 1900.15 | 3208.04 | 11245.8 | 1095.32 | 1609.56 | 14995.3 | 2050.63 | 11825.3 | 44832.2
2002 | 1 | 28927 | 5500.27 | 1205.56 | 27600.5 | -1.46 | 0 | 26312.7 | 10060.4 | 16664 | 1880.12 | 3302.6 | 10557.6 | 1082.65 | 1604.39 | 15699.3 | 2160.24 | 12124.6 | 46675.2
2003 | 1 | 29186.1 | 5616.93 | 1262.59 | 27997.4 | -1.3 | 0 | 27027.1 | 10268.5 | 16135.5 | 2019.82 | 3360.16 | 11234.5 | 1225.6 | 1604.22 | 17122.8 | 2164.63 | 12624.3 | 47978.7
2004 | 1 | 29922.2 | 5721.43 | 1309.15 | 29264.4 | 3.94 | 0 | 28266.1 | 10901.2 | 16481.1 | 2076.39 | 3508.66 | 19956.6 | 1167.97 | 1498.79 | 17804.4 | 2286.91 | 12328.2 | 49064
2005 | 1 | 29751.7 | 5892.12 | 1375.49 | 29989.4 | 1.43 | 0 | 29596.2 | 11234.5 | 17298 | 2149.06 | 3648.95 | 12310.9 | 1252.27 | 1516.07 | 18696.7 | 2386.36 | 12825.3 | 50501.6
2006 | 1 | 31555.9 | 6154.66 | 1509.62 | 30448.7 | 0.07 | 0 | 30953.4 | 11726.3 | 17978.9 | 2081.17 | 3840.87 | 12728.1 | 1272.5 | 1517.91 | 19578.1 | 2481.44 | 13573.9 | 52240.3
2007 | 1 | 34794.7 | 6511.51 | 1571.91 | 31984.5 | -7.66 | 0 | 32384.9 | 12039.3 | 18687.3 | 2323.61 | 3881.01 | 13559.5 | 1255.08 | 1540.26 | 20670.7 | 2929.32 | 14154.8 | 54178.9
2008 | 1 | 37714.4 | 7137.03 | 1534.29 | 33199.4 | -20.65 | 0 | 33955.2 | 11908.8 | 18278.4 | 2822.29 | 4134.93 | 14895.2 | 1251.16 | 1594.67 | 21940.2 | 2845.7 | 15189.4 | 56542.1
2009 | 1 | 33299.4 | 7347.07 | 1511.08 | 33507.7 | 0.07 | 0 | 34517.2 | 12408.8 | 19058 | 2236.64 | 4298.85 | 14963.9 | 1456.86 | 1792.79 | 22711.5 | 2929.16 | 15870.2 | 60042.2
2010 | 1 | 34475 | 7542.45 | 1554.74 | 34265.1 | 0.09 | 0 | 35393.3 | 12934.6 | 19368.6 | 2121.78 | 4325.73 | 16254.8 | 1512.48 | 1945.14 | 23314.2 | 2952.54 | 16306.3 | 62226.2
1995 | 2 | 32858.5 | 23.8 | 4893.9 | 20863.5 | 0 | 161 | 28604.9 | 5547.2 | 26770.5 | 3097.4 | 2961.5 | 8878.2 | 1362.1 | 478.9 | 12724.6 | 1634.3 | 12221.6 | 38206.8
1996 | 2 | 33341.3 | 24.7 | 5401.3 | 22268.9 | 0 | 177.6 | 29026.8 | 5993.2 | 26750 | 2930.5 | 3098.8 | 8911.4 | 1356.2 | 676.3 | 13665.5 | 1746.7 | 12706.2 | 39125.2
1997 | 2 | 35779.4 | 23.3 | 5956.8 | 23504.8 | 0 | 167.8 | 30173.9 | 5858.8 | 26358.2 | 2986.2 | 3272.9 | 9738.9 | 1456.1 | 634.5 | 13521 | 1905.7 | 13043.9 | 40401.3
1998 | 2 | 38430.3 | 24.4 | 6542.6 | 24084.9 | 0 | 176.4 | 31478.1 | 6057.5 | 26090 | 3014.7 | 3373.5 | 10107.9 | 1509.8 | 828.5 | 14164.2 | 2001.4 | 13643.2 | 41089.5
1999 | 2 | 38861.9 | 22.4 | 6691.9 | 26319 | 0 | 198.7 | 32757.5 | 6290.5 | 26324.5 | 2996.5 | 3655.9 | 11344.3 | 1622.7 | 860.3 | 14986.2 | 2168.5 | 13978.6 | 41782.1
2000 | 2 | 41606.1 | 22.4 | 6995.5 | 27401 | 0 | 181.4 | 33799.5 | 6560.4 | 27256.8 | 3028.8 | 3866.2 | 11570.3 | 1867.5 | 924.4 | 15917.4 | 2376.1 | 14207.3 | 42927.6
2001 | 2 | 43316.6 | 23.8 | 7070.8 | 27266.5 | 0 | 188.5 | 35430.1 | 7666.4 | 27153.6 | 3194.2 | 4095.4 | 11290.4 | 1947.8 | 768.9 | 16920.9 | 2475.8 | 14998.7 | 44755.4
2002 | 2 | 44047.4 | 22.3 | 7464.1 | 28712.4 | 0 | 239.7 | 37134.2 | 7674.5 | 27176.7 | 3226.1 | 4661.5 | 11695.1 | 1972.4 | 885 | 17435.5 | 3360.8 | 15871 | 47419.8
2003 | 2 | 44064 | 22 | 7972.4 | 29306.8 | 0 | 235.1 | 37582.7 | 12778.1 | 27376.4 | 3250.8 | 4785.5 | 13875.3 | 1845.1 | 834.8 | 19369.1 | 3410.7 | 16487.4 | 49718.4
2004 | 2 | 46624.7 | 21.5 | 9060.5 | 31743.1 | 0 | 196.8 | 38704.9 | 7526.4 | 27267.4 | 3273 | 4818.77 | 11907.7 | 1954.04 | 1150.53 | 20527 | 3596.12 | 16848 | 52432.8
2005 | 2 | 48920.5 | 19.7 | 9234.6 | 33648.7 | 0 | 189.6 | 39574 | 8832.2 | 27637 | 3343.13 | 5110.81 | 21616.8 | 2010.66 | 1186.04 | 21419.7 | 3821.54 | 17906.2 | 54250.6
2006 | 2 | 50746.6 | 12.4 | 10100.4 | 34870.7 | 0 | 116.9 | 41138.5 | 8355.9 | 26927 | 3287.78 | 5386.83 | 15579.7 | 1902.21 | 1238.65 | 21936.3 | 4009.61 | 18585 | 55898.2
2007 | 2 | 52671.1 | 9.6 | 10453 | 35664.8 | 0 | 63.5 | 43400.8 | 8698.9 | 28682.5 | 3490.09 | 5557.23 | 16852.8 | 1894.22 | 1319.21 | 23274.6 | 4096.45 | 19437.6 | 57739.2
2008 | 2 | 54988.5 | 7.3 | 10646.1 | 36181.7 | 0 | 58.4 | 45899.1 | 9727.1 | 29263 | 3801.14 | 6128.98 | 18642.5 | 2061.72 | 1218.15 | 25532.7 | 4246.83 | 20614.5 | 61667.4
2009 | 2 | 49706.4 | 5.2 | 10141.3 | 35928.7 | 0 | 58.9 | 46799.9 | 9589.7 | 31179.6 | 3565.86 | 6304.77 | 20150.7 | 2148.78 | 1016.9 | 27226.2 | 4497.78 | 21533.6 | 66264.6
2010 | 2 | 53122.8 | 2.3 | 11037.1 | 38265.9 | 0 | 60.3 | 47858 | 11022 | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a