Key.xls

	A	B	C	E	F	G	H	I	J	P	Q	R
1	Appendix 4: Data Key
2										Data	No. Obs.
3	EjecProg									Ejec 1994	258	83%
4		Municipal spending by source, across sectors (in thousands of Bs.)								Ejec 1995	245	79%
5		Variable								Ejec 1996	246	79%
6		TotG	General Total, All Sectors (1994-1996)							Prog 1995	292	94%
7		TotI	Total, Internal Resources (1994-5)							Prog 1996	284	92%
8		TGN	Treasury (1994-5)
9		RRPP	Own Resources (1994-5)
10		PP	Decentralized Funds (1994-5)				_E	Expenditures
11		ACom	Community Contribution (1994-5)				_P	Budgeted (1995 only)
12		Otro	Other (1994-5)
13		Tran	Transfers (Budgeted 1996 only)
14		TotE	Total, External Resources (1994-5)
15		Cred	External Credit (1994-5)
16		Dona	Donations (1994-5)					[Tran = TGN + ACom]
17
18		Municipal spending, sectoral detail
19		Sectors	Code	Sources		Code
20	1	Educacion y Cultura	Ed	Total General		TotG
21	2	Urbanismo y Vivienda	UV	Total Interno		TotI
22	3	Energia	En	TGN		TGN
23	4	Saneamiento Basico	SB	Recursos Propios		RRPP
24	5	Transportes	Tr	Participacion Popular		PP		_E	Expenditures
25	6	Agropecuario	Ag	Aporte Comunitario		ACom		_P	Budgeted
26	7	Salud y Seguridad Social	Sa	Otros		Otro
27	8	Multisectorial	Mu	Transferencias		Tran
28	9	Industria y Turismo	IT	Total Externo		TotE
29	10	Comunicaciones	Co	Credito		Cred
30	11	Hidrocarburos	HC	Donaciones		Dona
31	12	Recursos Hidricos	RH
32
33	*	DMA No	Municipality Number in Alphabetical Order by Department and then Municipality Name
34	Base 95
35		Variable	Definition	(CNPV June 3, 1992)
36		Dept	Department
37		No	Municipality Number
38		Name	Municipality Name
39		No.Dept	Department Number
40		Pobl	Population
41		Indig	Number of Indigenous Communities
42		CCamp	Number of Peasant/Campesino Communities
43		JVec	Number of (Urban) Neighborhood Councils [Juntas Vecinales]
44		OTBSoli	Number of GRO's [OTB's] that Applied to Register with the Central Government
45		OTBRegi	Number of Grass-Roots Organizations [OTB's] Registered
46		CV	Vigilance Committee Operating [0,1]
47		EdifEsc	Number of School Buildings
48		TotAulas	Number of Classrooms
49		EstEsc	Number of Schools
50		TotBanco	Number of School Desks
51		TotMatri	Number of Students Registered
52		TotDoc	Number of Teachers
53	*	Stprdoc	Student/Teacher ratio [=totmatri/totdoc]
54		FIS	FIS Project Currently Being Implemented [0,1]
55		Ed.Alfa	Literacy Rate (%)	Education
56		Ed.Asis	Attendance Rate
57	*	Ed.Asis2	Square of Att Rate
58		NI.Nunca	Never Attended
59		NI.Basic	Basic [Grades 1-5]
60		NI.Inter	Primary	[Grades 6-8]
61		NI.Medio	Secondary	[Grades 6-8]
62		NI.Tecni	Technical Training
63		NI.Norma	Teacher Training School			Educational Attainment Rates
64		NI.Univ	University			Educational Attainment Rates
65		NI.Otro	Other
66		NI.Igno	Unknown
67	*	NI.More	Above Basic [=NI.Inter -- NI.Otro]
68	*	NI.IM	NI.Inter + NI.Medio
69	*	NI.High	NI.Tecni + Norma + Univ
70	*	NI.High2	Square of Ni.High
71	*	NI.Low	NI.Nunca + NI.Basic
72	*	NI.Low2	Square of NI.Low
73		Sa.Asis	Attendance	Health Care
74	*	Sa.Asis2	Square of Att Rate	Health Care
75		Agua.DV	Internal Plumbing
76		Agua.FV	External Plumbing
77	*	Agua.Dom	Plumbing [=Agua.DV+FV]		Water
78		Agua.FT	Public Standpipes
79		Agua.NR	None
80		Alca.Pub	Public Sewerage	Sewerage
81	*	Alca.Pr	Private Sewerage
82		Alca.CS	Septic Tank
83		Alca.Otr	Other
84		Alca.Sin	None
85		NBI	Unsatisfied Basic Needs
86	JPFBase
87		Pob.Urb	Urban Population
88		Pob.Rur	Rural Population
89		Hom.Tot	Male Population
90		Hom.Urb	Urban Male Population
91		Hom.Rur	Rural Male Population
92		Muj.Tot	Female Population
93		Muj.Urb	Urban Female Population
94		Muj.Rur	Rural Female Population
95	Pp'95
96		Nuc.Esc	Schooling Nucleus Present [0,1]
97		Fort.Pao	Received Institutional Strengthening in Budget Preparation [0,1]
98		Fort.Ins	Institution that Carried Out Strengthening
99		Oficial	Mayor's Party Belongs to National Governing Coalition [0,1]
100		Marg93	Electoral Margin Between Winner and Runner-Up, Mayoral Race (%)