DLSU–Angelo King Institute
St. La Salle Hall,
2401 Taft Avenue
1004 Manila

Angelo King International Center
Corner Arellano Avenue and Estrada Street
1004 Manila

Trunkline:
+63–2–5244611 loc. 287
Directline:
+63–2–5245333
Telefax:
+63–2–524–5347

Email:AKI@dlsu.edu.ph

DATABANK ADMINISTRATION PROJECT

Project Description and Rationale
The De La Salle University Angelo King Institute for Economic and Business Studies (DLSU-AKIEBS) Data Administration Project is tasked to procure available datasets from online sources, those distributed by statistical bodies, and other forms of datasets, for the institute’s compendium. These datasets are made available only to all DLSU students and faculty for their respective research purposes. The project also seeks to convert acquired datasets into Stata data formats and other usable formats.

Project Coordinator
Christopher James R. Cabuay, MS
Assistant Professorial Lecturer, School of Economics
Technical Project Coordinator, Angelo King Institute for Economic and Business Studies
De La Salle University, Manila, Philippines
christopher.cabuay@dlsu.edu.ph

List of Available Datasets (* not suitable for econometric analysis)
Family Income and Expenditure Survey (FIES)
Labor Force Survey (LFS)
Annual Poverty Indicators Survey (APIS)
National Demographic and Health Survey (NDHS)
Global Entrepreneurship Monitor (GEM)
Community-Based Monitoring System (CBMS)
Household Energy Consumption Survey (HECS)
Philippine Statistical Yearbook (PSY)*
Compendium of Philippine Environmental Statistics (CPES)*
Annual Survey of Philippine Business and Industry (ASPBI)*

Annual Poverty Indicators Survey (APIS)

Source Institution

Philippine Statistical Authority (PSA)

Description

  • conducted during years of the LFS wherein the PSA does not conduct FIES
  • includes demographic, income and expenditure variables.

Dataset Structure

cross section; household level

Questionnaires Available

  • 2008 Annual Poverty Indicators Survey
  • 2013 Annual Poverty Indicators Survey

Publications Available

  • 2008
  • 2010
  • 2011
  • 2013

Annual Poverty Indicators Survey (APIS)

PUFs (Stata .dta file) Available

  • APIS2008
  • APIS2010
  • APIS2011
  • APIS2013 

Sample Variable List

*=  Available only in 2010
**= Available only in 2013
***= Available only in 2013

Format
variable name: variable representation; specification/description/measurement

I.D. variables

reg: Region; index values 1 up to 17 representing each region in the Philippines

Demographic variables

fsize1: Family Size; number of members in the household

c06_status_1: Household Head Marital Status of household 1; index values 1 to 5 (i.e.,  1 = Single , 2 = Married, 3 = Widowed, 4 = Divorced/Separated, 5= Unknown)

c04_sex_1: Sex of household 1; index values 1 to 2 (such that 1 = male and 2 = female)

c16_cls_wkr_1: Class of Worker of household 1; index values 0 to 6 (i.e., 0 = worked for private household, 1 = worked for private establishment, 2 = worked for government/government corporation, 3 = self-employed without any employee, 4 = employer in own family-operated farm or business)

**ppensss01_01:SSS Member of household 1;  index values 1 to 2 (such that 1 = Yes and 2 = No)

** ppengsis02_01: GSIS of household 1; index values 1 to 2 (such that 1= Yes and 2 = No)

**pphealth03_01: Philhealth Member of household 1; index values 1 to 2 (such that 1 = Yes and 2 = No)

Income variables

wages: Income from Salaries and Wages; income positive real numbers

othin:Other Sources of Income; amount of income the household receives from other sources; positive real numbers



Annual Poverty Indicators Survey (APIS)

Sample Variable List

Income variables

totinc: total family income; family income positive real numbers

conab:Cash Reciepts, Support, etc. from Abroad; income that the household receives from abroad; positive real numbers

condo:Cash Reciepts, Support, etc. from Domestic Source; income that the household receives domestically ; positive real numbers

Wealth variables

fuel: Fuel, Light and Water; the amount of the household spends for fuel, light, and water; positive real numbers

trcom: Transportation and Communication; the amount of the household spends for transportation and communication; positive real numbers

cloth: Clothing, Footwear and Other Wear; the amount of the household spends for clothing; positive real numbers

rcrtn: Recreation; the amount of the household spends for recreational activities; positive real numbers

gftot: Gifts and Contributions to others; the amount of the household spends for gifts; positive real numbers

**t_housing_water: Housing and water (Total); the amount of the household spends for housing and water; positive real numbers

**t_transport: Transportation (Total);  the amount of the household spends on  transportation; positive real numbers

**t_furnishing: Furnishings, Household Equipment & Routine Household Maintenance; the amount of the household spends  on household equipment and maintenance; positive real numbers

**t_cloth: Clothing, Footwear and Other Wear (Total); the amount of the household spends on  clothing; positive real numbers

**t_alcohol: Alcoholic Beverages (Total); the amount of the household spends on  alcohol; positive real numbers


Family Income and Expenditure Survey (FIES)

Source Institution

PSA

Description

  • conducted every three years (2003, 2009, 2012 etc)
  • includes mainly income and expenditure variables with demographic variables about the household head


Family Income and Expenditure Survey (FIES)

Dataset Structure

cross section; household level

Questionnaires Available

  • 2003 Family Income and Expenditure Survey (First Visit – July 2003)
  • 2006 Family Income and Expenditure Survey (First Visit – July 2006)
  • 2009 Family Income and Expenditure Survey (First Visit – July 2009)
  • 2012 Family Income and Expenditure Survey (First Visit – July 2012)

Publications Available

  • Volume I 2003 Final Report Family Income and Expenditure Survey ISSN 0119 – 5336
  • FIES06tables, data_dictionary (2006)
  • Technical_Notes(2006)
  • Data_dictionary (2009)
  • Technical_Notes(2009) 
  • Tables for FIES 2009

PUFs (Stata .dta file) Available

  • FIES2003
  • FIES2006
  • FIES 2009
  • FIES2012  

Sample Variable List

Format
variable name: variable representation; specification/description/measurement

I.D. variables

regn; Region; index values 1 up to 17 representing each region in the Philippines

Demographic variables

fsize: Family Size; number of members in the household

z2031_h_ms: Household Head Marital Status of household 1; index values 1 to 5 (such that 1 = Single, 2 = Married, 3 = Widowed, 4 = Divorced/Separated, 5= Unknown)

z2011_h_sex: Sex of household head; index values 1 to 2 (such that 1= male and 2 = female)

z2021_h_age: Age of household head; age positive real numbers


Family Income and Expenditure Survey (FIES)

Sample Variable List

Demographic variables

z2041_h_educ: Household head educational attainment; index values 0 to 78 (i.e.,  0 = no grade completed, 1 = elementary undergraduate, 2 = elementary graduate, 3 = high school undergraduate)

z2051_h_has_job: Household head job/business indicator

Income variables

totex: Total Family Expenditure; total family expenses positive real numbers

food:Total Food Expenditure; the total amount of food that the family spends for consumption; positive real numbers

totex: Total family expenditure; total family expenditure positive real numbers

ctexp:Total Family Expenditure in Cash; Family’s expenditure that is cash on hand; positive real numbers

toinc:Total Family Income; the overall income of the family ; positive real numbers

Wealth variables

b5182_n_motor: Household’s number of motorcycles; the amount of motorcycles that the family owns; positive real numbers

b5021_toilet: Household Toilet Facility; the number of toilet facility; positive real numbers

b5151_w_phone: Household Telephone;  number of telephone that the household has; positive real numbers

b5141_w_car: Household vehicle;  number of vehicles that the household owns; positive real numbers

b5061_w_tvt: Household Television Set; the number of television that the household owns; positive real numbers


Labor Force Survey (LFS)

Source Institution

PSA

Description

  • conducted quarterly
  • includes mostly labor and demographic variables such as wage, occupation and education

Dataset Structure

quarterly cross section; household level with member-level variables

Questionnaires Available

questionnaire available in PSA website

Publications Available

N/A

PUFs (Stata .dta file) Available

  • LFS2007Q3
  • LFS2007Q4
  • LFS2008Q3
  • LFS2008Q4
  • LFS2009Q3
  • LFS2009Q4
  • LFS2010Q3
  • LFS2010Q4
  • LFS2011Q3
  • LFS2011Q4
  • LFS2012Q3
  • LFS2012Q4

Sample Variable List

Format
variable name: variable representation; specification/description/measurement

I.D. variables

reg: Region; index values 1 up to 17 representing each region in the Philippines

Demographic variables

c09_grd_01: Highest grade completed; the highest grade completed by the household head; index values 0-99 (such that 0 = No grade completed, 1 = elementary undergraduate, 2 =
elementary graduate, 3 = high school undergraduate, 4 = high school graduate. 5 = college undergraduate; 60 = college graduate, 99 = not reported)

c08_ms_01: Marital Status; index values 1 to 5 (such that 1 = Single, 2 = Married, 3 = Widowed, 4 = Divorced/Separated, 5= Unknown)

c04_sex_1: Sex; index values 1 to 2 (such that 1= male and 2 = female)

c05_rel_01: Relationship to the household head of household 1; index values 0 to 6 (such that 1 = head, 2 = wife/spouse, 3 = son/daughter, 4 = brothers/sisters, 5 = son/daughter in law,6 = grandchildren, 7 = father/mother, 8 = other relative, 9 = boarder, 10 = domestic helper, 11 = non relative)


Labor Force Survey (LFS)

Sample Variable List

Industry variables

j01_usoc_01: Usual Occupation; index values 1 to 93 (i.e., 1 = Armed Forces, 2 = Non-Gainful Occupations, 31 = Physical Science and Engineering Associate Professionals, 41 = Office Clerks)

c16_proc_01: Primary Occupation; index values 1 to 93 (i.e., 1 = Armed Forces, 2 = Non-Gainful Occupations, 31 = Physical Science and Engineering Associate Professionals, 41 = Office Clerks)
c18_pkb_01: Kind of Business of primary occupation; index values 1 to 93 (i.e., 1 = Growing of Crops, 2 = Farming Animals, 3 = Agricultural and Animal Husbandry Service, 4 = Hunting, Trapping and Game Propagation)

c19pclas_01: Class of Worker of primary occupation; index values 0 to 6 (i.e., 0 = worked for private household, 1 = worked for private establishment, 2 = worked for government/government corporation, 3 = self-employed without any employee, 4 = employer in own family-operated farm or business)

c27_pbsc_01:Basic Pay per Day (Primary Occupation); amount of income the person receives from his/her primary occupation; positive real numbers

j02_otoc_01: Other Occupation; index values 1 to 93 (i.e., 1 = Armed Forces, 2 = Non-Gainful Occupations, 31 = Physical Science and Engineering Associate Professionals, 41 = Office Clerk)

j03_okb_01: Kind of Business of primary occupation; index values 1 to 93 (i.e., 1 = Growing of Crops, 2 = Farming Animals, 3 = Agricultural and Animal Husbandry Service, 4 = Hunting, Trapping and Game Propagation)

j04_ocls_01: Class of Worker of primary occupation; index values 0 to 6 (i.e., 0 = worked for private household, 1 = worked for private establishment, 2 = worked for government/government corporation, 3 = self-employed without any employee, 4 = employer in own family-operated farm or business)

 

Merged FIES and LFS

Source Institution

PSA

Description

  • conducted every three years
  • includes mainly income and expenditure variables with demographic variables about the household head
  • also contains member-specific information available in the LFS

Dataset Structure:

cross section; household level, individual-level

Questionnaires Available

FIES and LFS questionnaires separately


Merged FIES and LFS

Publications Available

FIES and LFS publications separately

PUFs (Stata .dta file) Available

  • 2009
  • 2012

Sample Variable List

Format
variable name: variable representation; specification/description/measurement

I.D. variables

regn: Region; index values 1 up to 17 representing each region in the Philippines

Demographic variables

fsize: Family Size; number of members in the household

z2031_h_ms: Household Head Marital Status of household 1; index values 1 to 5 (such that 1 = Single, 2 = Married, 3 = Widowed, 4 = Divorced/Separated, 5= Unknown)

z2011_h_sex: Sex of household head; index values 1 to 2 (such that 1= male and 2 = female)

z2021_h_age: Age of household head; age positive real numbers

z2041_h_educ: Household head educational attainment; index values 0 to 78 (i.e.,  0 = no grade completed, 1 = elementary undergraduate, 2 = elementary graduate, 3 = high school undergraduate)

z2051_h_has_job: Household head job/business indicator

c09_grd_01: Highest grade completed; the highest grade completed by the household head; index values 0-99 (such that 0 = No grade completed, 1 = elementary undergraduate, 2 =
elementary graduate, 3 = high school undergraduate, 4 = high school graduate. 5 = college undergraduate; 60 = college graduate, 99 = not reported)

c08_ms_01: Marital Status; index values 1 to 5 (such that 1 = Single, 2 = Married, 3 = Widowed, 4 = Divorced/Separated, 5= Unknown)

c04_sex_1: Sex; index values 1 to 2 (such that 1= male and 2 = female)


Merged FIES and LFS


Sample Variable List

Demographic variables

c05_rel_01: Relationship to the household head of household 1; index values 0 to 6 (such that 1 = head, 2 = wife/spouse, 3 = son/daughter, 4 = brothers/sisters, 5 = son/daughter in law,6 = grandchildren, 7 = father/mother, 8 = other relative, 9 = boarder, 10 = domestic helper, 11 = non relative)

Income variables

Totex: Total Family Expenditure; total family expenses positive real numbers

food:Total Food Expenditure; the total amount of food that the family spends for consumption; positive real numbers

totex: Total family expenditure; total family expenditure positive real numbers

ctexp: Total Family Expenditure in Cash; Family’s expenditure that is cash on hand; positive real numbers

toinc:Total Family Income; the overall income of the family ; positive real numbers

Wealth variables

b5182_n_motor: Household’s number of motorcycles; the amount of motorcycles that the family owns; positive real numbers

b5021_toilet: Household Toilet Facility; the number of toilet facility; positive real numbers

b5151_w_phone: Household Telephone;  number of telephone that the household has; positive real numbers

b5141_w_car: Household vehicle;  number of vehicles that the household owns; positive real numbers

b5061_w_tvt: Household Television Set;  the number of television that the household owns; positive real numbers

Industry variables

j01_usoc_01: Usual Occupation; index values 1 to 93 (i.e., 1 = Armed Forces, 2 = Non-Gainful Occupations, 31 = Physical Science and Engineering Associate Professionals, 41 = Office Clerks)


Merged FIES and LFS

Sample Variable List

Industry variables

c16_proc_01: Primary Occupation; index values 1 to 93 (i.e., 1 = Armed Forces, 2 = Non-Gainful Occupations, 31 = Physical Science and Engineering Associate Professionals, 41 = Office Clerks)

c18_pkb_01: Kind of Business of primary occupation; index values 1 to 93 (i.e., 1 = Growing of Crops, 2 = Farming Animals, 3 = Agricultural and Animal Husbandry Service, 4 = Hunting, Trapping and Game Propagation)
c19pclas_01: Class of Worker of primary occupation; index values 0 to 6 (i.e., 0 = worked for private household, 1 = worked for private establishment, 2 = worked for government/government corporation, 3 = self-employed without any employee, 4 = employer in own family-operated farm or business)

c27_pbsc_01:Basic Pay per Day (Primary Occupation); amount of income the person receives from his/her primary occupation; positive real numbers

j02_otoc_01: Other Occupation; index values 1 to 93 (i.e., 1 = Armed Forces, 2 = Non-Gainful Occupations, 31 = Physical Science and Engineering Associate Professionals, 41 = Office Clerk)

j03_okb_01: Kind of Business of primary occupation; index values 1 to 93 (i.e., 1 = Growing of Crops, 2 = Farming Animals, 3 = Agricultural and Animal Husbandry Service, 4 = Hunting, Trapping and Game Propagation)

j04_ocls_01: Class of Worker of primary occupation; index values 0 to 6 (i.e., 0 = worked for private household, 1 = worked for private establishment, 2 = worked for government/government corporation, 3 = self-employed without any employee, 4 = employer in own family-operated farm or business)


Global Entrepreneurship Monitor (GEM)

Source Institution

PSA

Description

  • includes two individual-level, cross-sectional datasets: the Adult Population Survey (APS) which is a survey of entrepreneurs, and the National Experts Survey (NES) which is a survey of national experts on the state of entrepreneurship
  • APS includes perception variables as well as business variables NES is comprised mostly of perceptions and outlook variables National-level information is  also available

Dataset Structure

cross section; individual level/national level

Questionnaires Available

  • GEM Adult Population Survey Questionnaire
  • GEM National Experts Survey Questionnaire

 

Global Entrepreneurship Monitor (GEM)

Publications Available

The national report is available at the GEM website.

PUFs (Stata .dta file) Available

  • PUF not available.
  • 2013 and 2014 Philippine data since these are the only years when the Philippines participated in the survey

Sample Variable List

Format
variable name; variable representation; specification/description/measurement;

Nascent entrepreneurs variable

BSTART: Starting a new business (self-employed); index values -2 to 1 (such that 0 = No, 1 = Yes, -1 = Don’t know, and -2 = Refused)

BJOBST: Starting a new business (employer); index values -2 to 1 (such that 0 = No, 1 = Yes, -1 = Don’t know, and -2 = Refused)

SUACTS: Done activity that would help launch a business; index values -2 to 1 (such that 0 = No, 1 = Yes, -1 = Don’t know, and -2 = Refused)

SUPREP: Months involved in starting a business; positive real numbers and index values -2 to-1 (such that -1 = Don’t know, and -2 = Refused)

Owner-managers variables

OWNMGE; Income from Salaries and Wages; index values -2 to 1 (such that 0 = No, 1 = Yes, -1 = Don’t know, and -2 = Refused)

OMOWN:Business Ownership; Personally own all, part, or none of the business; index values -3 to 3 (such that 1 = All, 2 = Part, 3 = None, -1 = Don’t know, -2 = Refused, and -3 = Not applicable)

OMEXPORT:Proportion of customers live outside the country; index values -2 to 7 (such that 1 = More than 90%, 2 = 76 to 90%, 3 = 51 to 75%, 4 = 26 to 50%, 5 = 11 to 25%, 6 = 10% or less, 7 = None, -1 = Don’t know, and -2 = Refused)

OMRSTART:First owners and managers; the respondent started the business or did not; index values -2 to 2 (such that 1 = Yes, 2 = No, -1 = Don’t know, and -2 = Refused)

OMYINT:Use internet to sell products; index values -2 to 2 (such that 1 = Yes, 2 = No, -1 = Don’t know, and -2 = Refused)


Global Entrepreneurship Monitor (GEM)

Sample Variable List

Potential entrepreneurs and discontinuers variables

FUREASON: Reason for starting a business; index values -2 to 5 (such that 1 = Take advantage of business opportunity, or, 2 = No better choices for work, 3 = Combination of both of the above, 4 = Have a job but seek better opportunities, 5 =  Other (SPECIFY), -1 = Don’t know, and -2 = Refused)

DISCENT: Discontinued or quit a business;  index values -2 to 2 (such that 1 = Yes, 2 = No, -1 = Don’t know, and -2 = Refused)
EXBUSCON: Business activities continued after quitting;  index values -2 to 2 (such that 1 = Yes, 2 = No, -1 = Don’t know, and -2 = Refused)

EXREASON: Reason for quitting;  index numbers -2 to 9 (i.e., 1 = An opportunity to sell the business, 2 = The business was not profitable, 3 = Problems getting finance, 4 = Another job or business opportunity, -1 = Don’t know, and -2 = Refused)

Informal investors variables

BUSANG: Provided funds to a new business;  index values -2 to 2 (such that 1 = Yes, 2 = No, -1 = Don’t know, and -2 = Refused)

BAFUND: Total of money provided; personally provided business start-ups in the past three years, not counting any investments in publicly traded stocks or mutual funds; positive real numbers and index values if there is no positive recorded value (such that -1 = Don’t know, -2 = Refused, and -3 = Haven’t provided funds)

BAREL: Relationship to the person that received your most recent personal investment; index values -2 to 6 (i.e., 1 = Close family member, such as a spouse, brother, child, parent, or grandchild, 2 = Some other relative, kin, or blood relation, 3 = A work colleague,  -1 = Don’t know, -2 = Refused, and -3 = Haven’t provided funds)

Employment variables

OCCUFULL: Employed by others in full-time work;  index values -2 to 2 (such that 1 = Yes, 2 = No, -1 = Don’t know, and -2 = Refused)

OCCUPART: Employed by others in part-time work;  index values -2 to 2 such that 1 = Yes, 2 = No, -1 = Don’t know, and -2 = Refused)

OCCUPRBS: Employed in a private business;  index values -2 to 2 (such that 1 = Yes, 2 = No, -1 = Don’t know, and -2 = Refused)

 

Global Entrepreneurship Monitor (GEM)

Sample Variable List

Employment variables

OCCUGOV: Employed by the government;  index values -2 to 2 (such that 1 = Yes, 2 = No, -1 = Don’t know, and -2 = Refused)

OCCUSEEK: Seeking employment;  index values -2 to 2 (such that 1 = Yes, 2 = No, -1 = Don’t know, and -2 = Refused)

OCCUSELFMO: Months Seeking employment; positive real numbers and  index values   if there is no positive recorded value (such that -1 = Don’t know and -2 = Refused)

Demographic variables

Gender: Gender; index values -2 to 2 (such that 1 = Male, 2 = Female, -1 = Don’t know, and -2 = Refused)

Age: Age; positive real numbers and index values -2 to-1 (such that -1 = Don’t know and -2 = Refused)

HHSIZE: Household size; positive real numbers and index values -2 to-1 (such that -1 = Don’t know and -2 = Refused)

 

Household Energy Consumption Survey (HECS)

Source Institution

PSA

Description

  • dataset on the energy usage and consumption on specific items

Dataset Structure

cross section; individual level

Questionnaires Available

HECS_2004_ questionnaire.pdf

Publications Available

N/A

PUFs (Stata .dta file) Available

HECS2004.dta

Sample Variable List

Format
variable name; variable representation; specification/description/measurement;

Demographic variables

Reg: Region; index values 1 up to 17 representing each region in the Philippines

Electricity variables

a05avcn: Average monthly consumption of electricity;  positive real numbers

a06ameb: Average monthly electric bill; positive real numbers


Household Energy Consumption Survey (HECS)

Sample Variable List

Petroleum variables

b07lpgsize: LPG tank size; positive real numbers from 0.1-99.9

b08aref: Payment for refilling; positive real numbers

b08btrnp: Payment for transport; positive real numbers

b23bkrsn: Buy kerosene; Type of kerosene do they buy; index variables 1 to 5 (such that 1 = Kerosene agent/dealer (pick up) , 2 = Kerosene agent/dealer (for delivery), 3 = Sari-sari store, 4 = Kerosene peddler, and 5 = Others)

Transport variables

c4vtype_01: Type of vehicle; The vehicle that household 1 uses; index variables 1 to 5 (such that 1 = Automobile , 2 = Utility vehicles, 3 = Motorcycle/tricycle, 4 = Motorboat, and 5 = Others)

c4fuse_01: Type of fuel used; The fuel that household 1 uses; index variables 1 to 4 (such that 1 = Regular gasoline , 2 = Premium gasoline, 3 = Diesel, and 4 = Others)

Renewable energy variables

d06obfw: How fuelwood was obtained; index variables 1 to 4 (such that 1 = Purchase only , 2 = Self-collected/gathered, 3 = Both, and 4 = Others)

 

National Demographic and Health Survey (NDHS) Household level

Source Institution

PSA

Description

A household-level cross-sectional survey that contains individual-specific characteristics, and contains variations for children and women.

  • includes health-related variables such as nutrition and disease indicators

Dataset Structure

cross section; individual level

Questionnaires Available

N/A

Publications Available

N/A

PUFs (Stata .dta file) Available

NDHS 2013 - household PHIR61

Sample Variable List

Format
variable name: variable representation; specification/description/measurement;

Women height/weight/hemoglobin variables

ha1_1: Woman’s age in years; positive real numbers


National Demographic and Health Survey (NDHS) Household level

Sample Variable List

Women height/weight/hemoglobin variables

ha2_1: Woman's weight in kilograms; positive real numbers

ha3_1: Woman's height in centimeters; positive real numbers

ha35_1: Smoking (cigarettes in last 24 hours); positive real numbers and index values if there is no positive recorded value (such that 0 = Doesn’t smoke, 80 = 80+, 94 = Smokes pipes, cigars, etc., and 99 = Missing)

ha53_1: Hemoglobin level (g/dl); positive real numbers; positive numbers and index values if there is no positive recorded value (such that 994 = Not present, 995 = Refused, 996 = Other, and 999 = Missing)

ha63_1: Result of measurement - HIV; index values 1 to 9 (such that 1 = Blood taken, 2 = Not present, 3 = Refused, 4 = Sample not tested/lost/damaged, insufficient, 5 = Not enough DBS to complete protocol, 6 = Other, and 9 = Missing)

Healthcare utilization variables

qh201: Any member of household sick or injured in the last 30 days; index values 1 to 9 (such that 1 = Yes, 2 = No, and 9 = Missing)

qh202: Number of sick/injured members in the last 30 days; positive real numbers

qh206: Any member of household visited health facility in the last 30 days; index values 1 to 9 (such that 1 = Yes, 2 = No, and 9 = Missing)

qh207: Number of members visited health facility in the last 30 days; positive real numbers

qh220: Any member of household confined in medical facility in the last 12 months; index values 1 to 9 (such that 1 = Yes, 2 = No, and 9 = Missing)

qh221: Number of members confined in health facility in the last 30 days; positive real numbers



National Demographic and Health Survey (NDHS) Household level

Sample Variable List

Non-communicable diseases variables

qh301: Things does to keep healthy; index values A to Z (i.e., A = Avoid too much fat/fatty food, B = Avoid excess intake of salt and salty food, C = Avoid excessive intake of/ drink moderately alcoholic beverages, and D = Avoid Smoking)
c16_cls_wkr_

qh304:Ever screened/examined for cancer; index values 1 to 9 (such that 1 = Yes, 2 = No, and 9 = Missing)
qh305: Part of body screened; index values A to Z (i.e., A = Blood, B = Bone, C = Breast, and D = Cervix)

Infectious diseases variables

qh405a:Ever had symptoms: cough for 2 weeks or longer; index values 1 to 9 (such that 1 = Yes, 2 = No, and 9 = Missing)

qh405b:Ever had symptoms: fever for 2 weeks or longer; index values 1 to 9 (such that 1 = Yes, 2 = No, and 9 = Missing)

qh405c:Ever had symptoms: chest pain for 2 weeks or longer; index values 1 to 9 (such that 1 = Yes, 2 = No, and 9 = Missing)

qh405d:Ever had symptoms: coughing up blood for 2 weeks or longer; index values 1 to 9 (such that 1 = Yes, 2 = No, and 9 = Missing)

qh405e: Ever had symptoms: sweating at night for 2 weeks or longer

 

National Demographic and Health Survey (NDHS) Person Level

Source Institution

PSA

Description

  • includes variables on health, nutrition and disease indicators

Dataset Structure

cross section; individual level

Questionnaires Available

N/A

Publications Available

N/A

PUFs (Stata .dta file) Available

NDHS 2013 - persons child5 allchild PHIR61

Sample Variable List

Format
variable name: variable representation; specification/description/measurement;

 



National Demographic and Health Survey (NDHS) Person Level

Sample Variable List

Maternity variables

m1: Number of tetanus injections before birth; positive real numbers and index values if there is no positive recorded value (such that 0 = received no injection, 7 = 7+, 8 = Don’t know, and 9 = Missing)

m1a: Number of tetanus injections before pregnancy; positive real numbers and index values if there is no positive recorded value (such that 0 = received no injection, 7 = 7+, 8 = Don’t know, and 9 = Missing)

m10; Wanted pregnancy when became pregnant; index values 1 to 9 (such that 1 = Yes, 2 = No, and 9 = Missing)

m17: Delivery by caesarean section; index values 1 to 9 (such that 1 = Yes, 2 = No, 9 = Missing)

Child's health and vaccinations variables

h2: Received BCG ; received Bacillus Calmette-Guérin vaccine for tuberculosis; index values 0 to 9 (such that 0 = No, 1 = Vaccination date on card, 2 = Reported by mother, 3 = Vaccination marked on card, 8 = Don’t know, and 9 = Missing)

h3: Received DPT 1; received 1st diphtheria, tetanus, and pertussis vaccine; index values 0 to 9 (such that 0 = No, 1 = Vaccination date on card, 2 = Reported by mother, 3 = Vaccination marked on card, 8 = Don’t know, and 9 = Missing)

h4: Received POLIO 1; received 1st polio vaccine; index values 1 to 9 (such that 1 = Yes, 2 = No, 8 = Cannot Remember, and 9 = Missing)

h9: Received MEASLES; received 1st measles vaccine; index values 1 to 9 (such that 1 = Yes, 2 = No, and 9 = Missing)

Reproduction and birth history variables

b0: Child is twin; the number of the set of twins; index values 1 to 5 (such that 0 = Single birth, 1 = 1st of multiple, 2 = 2nd of multiple, 3 = 3rd of multiple, 4 = 4th of multiple, and 5 = 5th  of multiple2)

b4: Sex of child; index values 1 to 2 (such that 1 = Yes, 2 = No)

b5: Child is alive; index values 0 to 1 (such that 0 = No, 1 = Yes)

b9: Child lives with whom; index values 0 to 9 (such that 0 = Respondent, 1 = Father, 2 = Other relative, 3 = Someone else, 4 = Lives elsewhere, and 9 = Missing)


National Demographic and Health Survey (NDHS) Person Level

Sample Variable List

Reproduction and birth history variables

b10: Completeness of information; All information of the child is complete.; index values 1 to 8 (such that 1 = Month and year- information complete, 2 = Month and age - year imputed , 3 = Year and age – month imputed, 4 = Year and age – month , 5 = Year – age/month imputed, 6= Age – year/month imputed , 7= Month – age/year imputed, and 8= None – all imputed)

 

National Demographic and Health Survey (NDHS)  Women Level

Source Institution

PSA

Description

  • includes variables on women’s health such as nutrition, contraception, indications of disease and others.

Dataset Structure:

cross section; individual level

Questionnaires Available

N/A

Publications Available

N/A

PUFs (Stata .dta file) Available

NDHS 2013 - woman PHIR61

Sample Variable List

Format
variable name: variable representation; specification/description/measurement;

Contraception knowledge and use variables

v312: Current contraceptive method; index values 1 to 9 (such that 1 = Yes, 2 = No, and 9 = Missing)

v313: Current contraceptive method; index values (1 to 9 such that 1 = Yes, 2 = No, and 9 = Missing)

v323: Brand of pill used; index values 1 to 9 (such that 1 = Yes, 2 = No, and 9 = Missing)

v323a: Brand of condom used; index values 1 to 9 (such that 1 = Yes, 2 = No, and 9 = Missing)

Fertility preferences variables

v602: Fertility preference; index values A to Y (i.e., A =  vaginal bleeding,  B = Headache, C = Dizziness, and D = Blurred Vision)

v621: Husband's desire for children; index values 1 to 9 (such that 1 = Yes, 2 = No, 8 = Cannot Remember, and 9 = Missing)

v627: Ideal number of boys; index values 1 to 9 (such that 1 = Yes, 2 = No, 8 = Cannot Remember, and 9 = Missing)


National Demographic and Health Survey (NDHS)  Women Level

Sample Variable List

Fertility preferences variables

v628: Ideal number of girls; index values 1 to 9 (such that 1 = Yes, 2 = No, 8 = Cannot Remember, and 9 = Missing)

v629: Ideal number of either sex; index values 1 to 9 (such that 1 = Yes, 2 = No, 8 = Cannot Remember, and 9 = Missing)

Domestic violence variables

d103a: Ever been humiliated by husband/partner; index values 0 to 9 (such that 0 = Never, 1 = Often, 2 = Sometimes, 3 = Yes, but not in the last 12 months, 4 = Yes, but frequency in last 12 months, and 9 = Missing)

d103b:Ever been threatened with harm by husband/partner; index values 0 to 9 (such that 0 = Never, 1 = Often, 2 = Sometimes, 3 = Yes, but not in the last 12 months, 4 = Yes, but frequency in last 12 months, and 9 = Missing)

d103c:Ever been insulted or made to feel bad by husband/partner; index values 0 to 9 (such that 0 = Never, 1 = Often, 2 = Sometimes, 3 = Yes, but not in the last 12 months, 4 = Yes, but frequency in last 12 months, and 9 = Missing)

d103d: Ever refused respondent to engage in work by husband/partner; index values 0 to 9 (such that 0 = Never, 1 = Often, 2 = Sometimes, 3 = Yes, but not in the last 12 months, 4 = Yes, but frequency in last 12 months, and 9 = Missing)

d103e: Ever controlled respondent's money/property or forced respondent to work by husband/partner; index values 0 to 9 (such that 0 = Never, 1 = Often, 2 = Sometimes, 3 = Yes, but not in the last 12 months, 4 = Yes, but frequency in last 12 months, and 9 = Missing)

d103f:Ever destroyed respondent's property by husband/partner; index values 0 to 9 (such that 0 = Never, 1 = Often, 2 = Sometimes, 3 = Yes, but not in the last 12 months, 4 = Yes, but frequency in last 12 months, and 9 = Missing)

 

Philippine Statistical Yearbook (PSY)

Source Institution

PSA

Description

  • compilation of various statistical indicators of the Philippines
  • not to be used for regression analysis but may be used for review of literature or landscaping
  • includes several indicators such as population, housing, labor, health, education, agriculture, trade, industry etc.

Philippine Statistical Yearbook (PSY)


Dataset Structure

 

Questionnaires Available

N/A

Publications Available

  • 2011
  • 2013

PUFs (Stata .dta file) Available

N/A                   

Sample Variable List

Format
variable name; variable representation; specification/description/measurement;

Population variables

Population; Population of the Philippines; positive real numbers

Population Regional distribution; Population of each region in the Philippines; positive real numbers

Ten most populous cities; Tope ten cities with the highest population; positive real numbers

Registered Filipino emigrants; Number of Male and Female emigrants in the Philippines; positive real numbers

Human development index; positive real numbers

Income variables

Average family income (pesos); positive real numbers

Average family expenditure (pesos); positive real numbers

Poverty Threshold (annual per capita); positive real numbers

Poverty Incidence (% among families); positive real numbers

Poverty Incidence (% among populations); positive real numbers

Economic Accounts variables

Gross national income (millions of pesos); shows the GNI in current prices and at constant 2000 prices; positive real numbers

Gross domestic product by industrial origin; shows the contribution of each industrial origin to the GDP; positive real numbers


Philippine Statistical Yearbook (PSY)

Sample Variable List

Population variables

Expenditures on gross domestic product (at constant 2000 prices, (million pesos); shows the GDP spend on Household final consumption expenditures,  General government consumption, Gross domestic capital formation, and etc.

Per capita household final; shows prices and at constant 2000 prices; positive real numbers

Environment and natural resources variables

Land classification (in hectares); shows the how large of each type of land such as forest land, Alienable, and disposable; positive real numbers

Area reforested (in hectares); shows the how large the are reforested; positive real numbers

Forest disturbance (in hectares); shows the how large the forest disturbance;  positive real numbers

Production of forest products (100 cu m); shows the how large the forest products harvested;  positive real numbers

Value of mineral production; positive real numbers

Agriculture variables

Production of agricultural crops(thousand metric tons); shows how many cereals, major crops, and other crops were produced;  positive real numbers

Value of production of agricultural crops(millions of pesos); shows the value of cereals, major crops, and other crops that were produced;  positive real numbers

Fish production ('000 m.t.); shows how many commercial fishing, municipal fishing, and aquaculture were produced; positive real numbers

Value of fishing production (million pesos); shows the value of commercial fishing, municipal fishing, and aquaculture were produced;  positive real numbers

Livestock and poultry (thousand metric tons); shows how many livestock(liveweight), poultry(liveweight), and egg were produced; positive real numbers


Philippine Statistical Yearbook (PSY)

Sample Variable List

Agriculture variables

Value of livestock and poultry (million pesos); shows the value of livestock(liveweight), poultry(liveweight), and egg were produced;  positive real numbers

Industry variables

Index of value of production of key manufacturing; shows the value of food, beverages, tobacco, furniture, and etc. that were produced;  positive real numbers

Amount of approved investments (million pesos); shows the approved investments by local and foreign investors; positive real numbers

Trade variables

External Trade (million US dollars); shows exports, imports, and the balance of trade; positive real numbers

Total exports (million US pesos); shows the products that the Philippines export i.e. coconut products, copra, coconut oil, and others; positive real numbers

Tourism variables

Total exports (million US pesos); positive real numbers

Total visitor receipts (million US $); positive real numbers

Vital, health and nutrition statistics variables

Number of registered marriages; positive real numbers

Number of registered live births; positive real numbers

Number of registered deaths; positive real numbers

Bed capacity of government and private hospitals; positive real
numbers

Number of hospitals ; positive real numbers

Education and manpower development variables

Number of private schools;  number of pre-school, elementary, and secondary; positive real numbers


Philippine Statistical Yearbook (PSY)

Sample Variable List

Education and manpower development variables

Enrollment in public and private schools; number of pre-school, elementary, secondary, and higher education; positive real numbers

Number of graduates; number of higher education and technical and vocational; positive real numbers

Labor and employment variables

Total labor force (1,000 persons); shows employed and unemployed individuals; positive real numbers  

Unemployment rate (percent); all regions; positive real numbers

Processed overseas Filipino workers; land-based and sea-based Filipino workers; positive real numbers

Deployed overseas Filipino workers; land-based and sea-based Filipino workers; positive real numbers

Number of strikes/notices filed; positive real numbers

Actual strikes; positive real numbers

Social services variables

Number of institutions/centers involved in the distribution of social services; positive real numbers

Amount of Claims paid by the Government Service Insurance System (million pesos) ; positive real numbers

Amount of benefits paid by the Social Security System (million pesos); positive real numbers

Rail transport; number of passengers and gross revenues; positive real numbers

Total number of registered motor vehicles; positive real numbers

Total number of newly-registered; positive real numbers

Energy and water resources variables

Energy consumption (MTOE); positive real numbers

Coal production (@10,000 Btu/lb.); positive real numbers

Coal consumption (metric tons); positive real numbers


Philippine Statistical Yearbook (PSY)

Sample Variable List

Energy and water resources variables

Total crude oil supply (thousand barrels,MB); positive real numbers

Power generation (gigawatt hours); positive real numbers

Public administration variables

National Government Revenue (million pesos); Tax Revenues and Non tax revenue; positive real numbers

Sectoral Allocation of Expenditures (million pesos); shows the contribution of social services, economic services, defense, and etc. ; positive real numbers

Outstanding government domestic securities (million pesos); positive real numbers

Government personnel by region; positive real numbers

Banking and finance variables

Broad money (million pesos); positive real numbers

Overseas Filipino remittances; positive real numbers

Total assets and liabilities of the Central Bank (billion pesos) ; positive real numbers

Total assets and liabilities of universal and commercial banks (billion pesos) ; positive real numbers

Total number of closed banks; positive real numbers

Total number of merged banks; positive real numbers

Public order, safety, and justice variables

Index crime and Non-index crime; positive real numbers
Number of policemen; positive real numbers

Number of firemen; positive real numbers

Number of raids on drug incidents; positive real numbers

Number of persons arrested on drug incidents; positive real numbers

Inflow & Outflow of Cases; positive real numbers


Philippine Statistical Yearbook (PSY

Sample Variable List

Public administration variables

Total population affected by major natural disasters; positive real numbers

Science and technology variables

Total patents granted; total local applicants and foreign applicants

Total trademarks registered; local inventors and foreign inventors