IHSN Survey Catalog
  • Home
  • Microdata Catalog
  • Citations
  • Login
    Login
    Home / Central Data Catalog / EGY_2011_MMIE_V01_M_V01_A_PUF
central

Macroinsurance for Microenterprises: A Randomized Experiment in Post-Revolution Egypt 2011

Egypt, Arab Rep., 2011 - 2012
Get Microdata
Reference ID
EGY_2011_MMIE_v01_M_v01_A_PUF
Producer(s)
Matthew Groh, David McKenzie, Tara Vishwanath
Metadata
DDI/XML JSON
Created on
Dec 22, 2014
Last modified
Mar 29, 2019
Page views
28982
Downloads
1537
  • Study Description
  • Data Dictionary
  • Downloads
  • Get Microdata
  • Related Publications
  • Data files
  • MacroinsuranceforMicroentrepreneurs
  • MarketResearch

Data file: MacroinsuranceforMicroentrepreneurs

Business Owner Questionnaire - Baseline
Section 1: Enterprise owner background
Section 2: Business information
Section 3: Finance
Section 4: Attitudes towards risk
Section 5: Assets and inventory
Section 6: Income
Section 7: Other finance
Section 8: Discounting and saving
Section 9: Expectations
Section 10: Financial literacy
Section 11: Obstacles to business
Section 12: Consumption information
Section 13: Tracking information
Section 14: Games

Business Owner Questionnaire - Follow-up
Section 1: Enterprise owner background
Section 2: Business information
Section 3: Wage employment
Section 4: Loans
Section 5: Epp and economic outlook
Section 6: Assets
Section 7: Inventory
Section 8: Discount rate
Section 9: Business profits
Section 10: Investment proclivity
Section 11: Obstacles to business
Section 12: Discount rate
Section 13: Consumption information

Cases: 2972
Variables: 682

Variables

b_1102_18
Judgment on "Corruption" problem severity
b_1101_19
"Illegal competition":problem for the growth of the enterprise
b_1102_19
Judgment on "Illegal competition" problem severity
b_1101_20
"Legal system/conflict resolution":problem for the growth of the enterprise
b_1102_20
Judgment on "Legal system/conflict resolution" problem severity
b_1101_21
"Smuggling/dumping":problem for the growth of the enterprise
b_1102_21
Judgment on "Smuggling/dumping" problem severity
b_1201_1
Amount spent last week on "Drinks" (L.E)
b_1201_2
Amount spent last week on "Vegetables and fruits" (L.E)
b_1201_3
Amount spent last week on "Meat/Chickens/Fish" (L.E)
b_1201_4
Amount spent last week on "Bread" (L.E)
b_1201_5
Amount spent last week on "Carbohydrates" (L.E)
b_1201_6
Amount spent last week on "Legumes" (L.E)
b_1201_7
Amount spent last week on "Eggs/Milk/Cheese" (L.E)
b_1201_8
Amount spent last week on "Cigarettes and Shisha" (L.E)
b_1201_9
Amount spent last week on "Other food and drink" (L.E)
b_1201_10
Total amount spent last week (L.E)
b_1202_1
Amount spent last month on "Rent" (L.E)
b_1202_2
Amount spent last month on "Water" (L.E)
b_1202_3
Amount spent last month on "Electricity" (L.E)
b_1202_4
Amount spent last month on "Gas" (L.E)
b_1202_5
Amount spent last month on "Non-Durable Goods" (L.E)
b_1202_6
Amount spent last month on "Transport" (L.E)
b_1202_7
Amount spent last month on "Maintenance and Fuel" (L.E)
b_1202_8
Amount spent last month on "Communication" (L.E)
b_1202_9
Amount spent last month on "Leisure Activities" (L.E)
b_1202_10
Amount spent last month on "Hair Cuts" (L.E)
b_1202_11
Amount spent last month on "Monthly Installment" (L.E)
b_1202_12
Amount spent last month on "Loan" (L.E)
b_1202_13
Total amount spent last month (L.E)
b_1203_1
Amount spent last year on "Clothing, Textiles, Bedding" (L.E)
b_1203_2
Amount spent last year on "Footwear" (L.E)
b_1203_3
Amount spent last year on "Funerals, Weddings, Ceremonies" (L.E)
b_1203_4
Amount spent last year on "Electronic" (L.E)
b_1203_5
Amount spent last year on "Furnishings" (L.E)
b_1203_6
Amount spent last year on "Appliances" (L.E)
b_1203_7
Amount spent last year on "Vehicles" (L.E)
b_1203_8
Amount spent last year on "Health" (L.E)
b_1203_9
Amount spent last year on "Education" (L.E)
b_1203_10
Amount spent last year on "Household Renewal" (L.E)
b_1203_11
Total amount spent last year (L.E)
b_1204
In which step of the ladder of standard of living
b_1205_1
Household own "Electricity"
b_1205_2
Household own "Natural Gas"
b_1205_3
Household own "Water"
b_1205_4
Household own "Refrigerator"
b_1205_5
Household own "Freezer"
b_1205_6
Household own "Television"
b_1205_7
Household own "Satellite Dish"
b_1205_8
Household own "Computer"
b_1205_9
Household own "DVD player"
b_1205_10
Household own "Mobile Telephone"
b_1205_11
Household own "Automatic Washing Machine"
b_1205_12
Household own "Dishwasher"
b_1205_13
Household own "Sewing Machine"
b_1205_14
Household own "Fan"
b_1205_15
Household own "Air Conditioning"
b_1205_16
Household own "Toilet with flush"
b_1205_17
Household own "Stove/ Oven"
b_1205_18
Household own "Water Heater"
b_1205_19
Household own "Motorcycle"
b_1205_20
Household own "Car, Van or Truck"
b_1206
Having an "E-mail" address
b_1207
Period for checking the e-mail address
b_1301
Any plans to relocate this business in the next year
b_1401
Selected business
b_1402
Head or Tail
b_1403
Total payout (L.E)
b_1404
Selected bag
b_1405
Selected color
b_1406
Pulled color
b_1407
Money paid or not
b_1408
Total payout of both games (L.E)
b_1409H
End hours
b_1409M
End minutes
m_GOV
Governorate
m_DAY
Day of interview
m_MONTH
Month of interview
m_YEAR
Year of interview
m_INTERV
Interviewer
m_RESULT
Result
m_VISITS
Total number of visits
m_ASYACC
Easy access to client
m_OEDIT
Office editor
m_CODER
Coder
m_KEYER
Keyer
m_100
Respondent agreement to be interviewed
m_101
Who supplied the information
m_102
Enterprise owner still running the business till now
m_103
What the enterprise owner currently do
m_201
Old business still the main business
m_202TEXT
Nature of main current business (Text)
m_202CODE
Nature of main current business (Code)
m_202SEC
Nature of main current business (Sector)
m_202A
Number of business you own or jointly own
m_203
Started a business since March 2012 and closed down permanently
m_204
Reason for closing the business
m_205
Closed / Sold the main business you worked in March 2012
m_206
Main reason for closing your main business
m_207
Main activity you engaged in now after closing / selling the business
m_208
Opened a new business since March 2012
m_209TEXT
Nature of new business (Text)
m_209CODE
Nature of new business (Code)
m_209SEC
Nature of new business (Sector)
m_210
New business owned by yourself or Jointly owned
m_211
Month of starting the new business
m_213_1
Total hours you personally spent working in your business(es) last week
m_213_2
Total days you personally spent working in your business(es) last week
m_213A
Operating your main business in different location since March 2012
m_214
Expanding your main business or your other business since March 2012
m_215
How did you expand your main business or your other business
m_216
Introducing new product/ service since March 2012
m_217
Name of new service/ product (Code)
m_218
Name of main service/ product (Code)
m_219_1
Current price for selling this main product/ service (L.E)
m_219_2
Unit of scale for selling this main product/ service
m_220_1
Price you were selling this main product/ service in march 2012 (L.E)
m_220_2
Unit of scale for selling this main product/ service in march 2012 (L.E)
m_221_1
Your business(es) expenses on "Benzene" in typical month (L.E)
m_221_2
Your business(es) expenses on "Natural Gas" in typical month (L.E)
m_221_3
Your business(es) expenses on "LPG" in typical month (L.E)
m_222_1
Hired new "Full time workers" since march 2012
m_222_2
Hired new "Part time workers" since march 2012
m_223_1
Number of male employees
m_223_2
Number of female employees
m_223_3
Number of employees related to you
m_301
Currently employed in a job in which you receive wages
m_302
Kind of Institution you work in
m_303TEXT
Institution description (Text)
m_303CODE
Institution description (Code)
m_303SEC
Institution description (Sector)
m_304
No. of workers in the institution where you are employed including "project owne
m_305_1
Total working hours last week as a wage worker
m_305_2
Total working days last week as a wage worker
m_306
Amount of earned money from this work last month (L.E)
m_307
In this job, you supervise other employees
m_308
Number of workers under your control
m_309
Any other family member work in the same institution you work in
m_310
You left your business activity to do wage work
m_311
Main two reasons for leaving your business activity for wage work
m_311_A
Order of option "A" if exist
m_311_B
Order of option "B" if exist
m_311_C
Order of option "C" if exist
m_311_D
Order of option "D" if exist
m_311_E
Order of option "E" if exist
m_311_F
Order of option "F" if exist
m_311_G
Order of option "G" if exist
m_311_H
Order of option "H" if exist
m_311_I
Order of option "I" if exist
m_311_J
Order of option "J" if exist
m_311_X
Order of option "X" if exist
m_312
Intend to reenter self-employment or your business activity within the next year
m_313
Intend to start the business in the same activity or different activity
m_314
Looking for a wage job, or another opportunity to enter self-employment
m_315
Duration to find work as you think
m_316TEXT
Sector you intend to look for work or engage in self-employment (Text)
m_316CODE
Sector you intend to look for work or engage in self-employment (Code)
m_316SEC
Sector you intend to look for work or engage in self-employment (Sector)
m_401_1
Renewed a loan with ABA since march 2012
m_401_2
Loan taken with another microfinance organization since march 2012
m_401_3
Loan taken from family and friends since march 2012
m_401_4
Loan taken from a bank since march 2012
m_401_5
Loan taken from another source since march 2012
m_402
Total amount you currently owe to ABA
m_403A
Initial value of the loan (L.E)
m_403B
Monthly installment of the loan (L.E)
m_403C
Duration of the loan (Months)
m_403D
Amount of the loan you have spent
m_404_1
Amount you spent from the loan of ABA on equipments for business
m_404_2
Amount you spent from the loan of ABA on raw materials for business
m_404_3
Amount you spent from the loan of ABA on education
m_404_4
Amount you spent from the loan of ABA on household needs
m_404_5
Amount you spent from the loan of ABA on wedding expenses
m_404_6
Amount you spent from the loan of ABA on other
m_404_7
Total amount you spent from the loan of ABA on all previous
m_404A_1
Amount from the loan of ABA you plan to spend on equipments for business
m_404A_2
Amount from the loan of ABA you plan to spend on raw materials for business
m_404A_3
Amount from the loan of ABA you plan to spend on education
m_404A_4
Amount from the loan of ABA you plan to spend on household needs
m_404A_5
Amount from the loan of ABA you plan to spend on wedding expenses
m_404A_6
Amount from the loan of ABA you plan to spend on other
m_404A_7
Total amount from the loan of ABA you plan to spend on all previous
m_405_1
"ABA wouldnt let me renew": importance of this factor in not renewing a loan wit
m_405_2
"No need for another loan": importance of this factor in not renewing a loan wit
m_405_3
"Interest rates were too high": importance of this factor in not renewing a loan
m_405_4
"Another lender offered a better deal": importance of this factor in not renewin
m_405_5
"Concerned about ability to repay": importance of this factor in not renewing a
m_405_6
"Waiting to see what happens in Egypts economy": importance of this factor in no
m_405_7
"Other": importance of this factor in not renewing a loan with ABA
m_406
Plan on taking a new loan with ABA during next 6 months
m_407_1
Experienced the feeling of "I continuously have struggled to repay my loan on ti
m_407_2
Experienced the feeling of "I sometimes have had to miss at least one meal per m
m_407_3
Experienced the feeling of "The sacrifices i have to make in order to have enoug
m_407_4
Experienced the feeling of "I often worry about how i will come up with money to
m_408
Total amount you currently owe to all lenders not including ABA
m_501
Heard about the EPP offered to some ABA clients by their loan officers that help
m_502
Your loan officer give you the opportunity to participate in the EPP
m_503
You understand the EPP
m_504
Feel any pressure to join the EPP
m_505
Intend to renew your loan if you didn't join the EPP
m_506
You join the EPP
m_507
Reason for joining the EPP
m_508
Feel more comfortable when making investment decisions with the EPP
m_509
Amount you paid to join the EPP
m_510
Intend to renew your loan if you didn't have the opportunity to purchase the EPP
m_511
Percentage that the EPP will payout from 0 to 100
m_512
Reason for not joining the EPP
m_513_1
In what scenario will the EPP payout "Low sales for your business and normal eco
m_513_2
In what scenario will the EPP payout "Depreciation of Egyptian pound to 7 L.E"
m_513_3
In what scenario will the EPP payout "Stock market suspension of 5 days or more"
m_513_4
In what scenario will the EPP payout "Increase in price of benzene 80 to over 2L
m_513_5
In what scenario will the EPP payout "Tourism below 50% of its pre-revolution le
m_513_6
In what scenario will the EPP payout "Increase in the price of subsidized LPG cy
m_514_1
Feeling more/ less confident about "Your business future" compared to march 2012
m_514_2
Feeling more/ less confident about "The economic situation in Egypt" compared to
m_514_3
Feeling more/ less confident about "The political situation in Egypt" compared t
m_515_1
Likelihood of suspension of the stock
m_515_2
Likelihood of higher inflation than anytime in the last 5 years
m_515_3
Likelihood of increasing in price of benzene 80 to over 2L.E/Litre
m_515_4
Likelihood of increasing in price of benzene 90 to over 4L.E/Litre
m_515_5
Likelihood of increasing in price of subsidized LPG cylinder to 30L.E/Cylinder
m_515_6
Likelihood of curfew for 14 hours or more a day
m_516
Likelihood that at least one of the above events will happen during next year
m_601_1
Invest in "New tools and utensils" since March 2012
m_601_1VA
Amount invested in "New tools and utensils" since March 2012
m_601_2
Invest in "New machinery and equipment" since March 2012
m_601_2VA
Amount invested in "New machinery and equipment" since March 2012
m_601_3
Invest in "New furniture" since March 2012
m_601_3VA
Amount invested in "New furniture" since March 2012
m_601_4
Invest in "New vehicles" since March 2012
m_601_4VA
Amount invested in "New vehicles" since March 2012
m_601_5
Invest in "New business site (including land and buildings)" since March 2012
m_601_5VA
Amount invested in "New business site (including land and buildings)" since Marc
m_601_6
Invest in "Other assets" since March 2012
m_601_6VA
Amount invested in "Other assets" since March 2012
m_602_1
Sold any "Tools and utensils" since March 2012
m_602_1VA
Value you sold the "Tools and utensils" since March 2012
m_602_2
Sold any "Machinery and equipment" since March 2012
m_602_2VA
Value you sold the "Machinery and equipment" since March 2012
m_602_3
Sold any "Furniture" since March 2012
m_602_3VA
Value you sold the "Furniture" since March 2012
m_602_4
Sold any "Vehicles" since March 2012
m_602_4VA
Value you sold the "Vehicles" since March 2012
m_602_5
Sold any "Business site (including land and buildings)" since March 2012
m_602_5VA
Value you sold the "Business site (including land and buildings)" since March 20
m_602_6
Sold any "Other assets" since March 2012
m_602_6VA
Value you sold the "Other assets" since March 2012
m_604_1
Own savings: Source you financed the purchase of new assets
m_604_1P
Percentage of own savings as a source in purchasing new assets
m_604_2
Investment by members of household: Source you financed the purchase of new ass
m_604_2P
Percentage of investment by members of household as a source in purchasing new a
m_604_3
Investment by other relatives and friends: Source you financed the purchase of
m_604_3P
Percentage of investment by other relatives and friends as a source in purchasin
m_604_4
Money gifted by parents/ family members/ friends: Source you financed the purch
m_604_4P
Percentage of money gifted by parents/ family members/ friends as a source in pu
m_604_5
Remittances from abroad: Source you financed the purchase of new assets
m_604_5P
Percentage of remittances from abroad as a source in purchasing new assets
m_604_6
Sale of household assets: Source you financed the purchase of new assets
m_604_6P
Percentage of sale of household assets as a source in purchasing new assets
m_604_7
Loans from ABA: Source you financed the purchase of new assets
m_604_7P
Percentage of loans from ABA as a source in purchasing new assets
m_604_8
Loans from any other source: Source you financed the purchase of new assets
m_604_8P
Percentage of loans from any other source as a source in purchasing new assets
m_604_9
Cash received from gamaee'as: Source you financed the purchase of new assets
m_604_9P
Percentage of cash received from gamaee'as as a source in purchasing new assets
m_604_10
Money from sale of asset or equipment of the business: Source you financed the
m_604_10P
Percentage of money from sale of asset or equipment of the business as a source
m_604_11
Profits of this business: Source you financed the purchase of new assets
m_604_11P
Percentage of profits of this business as a source in purchasing new assets
m_604_12P
Total of all sources you financed the purchase of new assets
m_605
Currently delay investing in any machinery or equipment until the economic and p
m_701
Currently hold inventory (products for sale,raw materials, products in productio
m_702
Value of your inventory (products for sale,raw materials, products in production
m_703
Value of the goods/ things you have on hand to sell at the beginning of the day
m_704
Amount you currently have for your enterprise (include cash held at home for bus
m_705
Currently delaying expanding your inventory until the economic and political ins
m_801
Preferring 500L.E after six months or 475L.E after five months
m_801NO
Lowest acceptable amount (L.E)
m_901_1
Revenue of your enterprise in september 2012 before paying any expenses (L.E)
m_901_2
Revenue of your enterprise in augest 2012 before paying any expenses (L.E)
m_901_3
Revenue of your enterprise in july 2012 before paying any expenses (L.E)
m_902_1
Percent of profit from your revenue in september 2012
m_902_2
Percent of profit from your revenue in augest 2012
m_902_3
Percent of profit from your revenue in july 2012
m_903_1
Profit of business (including expenses,wages) but not including income you paid
m_903_2
Profit of business (including expenses,wages) but not including income you paid
m_903_3
Profit of business (including expenses,wages) but not including income you paid
m_904
Percent of monthly profit re-invested in business
m_905
Earning income from anywhere else apart from your enterprise
m_906_1
Amount (L.E) earned in september 2012 (Excluding profits from your business whic
m_906_2
Amount (L.E) earned in augest 2012 (Excluding profits from your business which w
m_906_3
Amount (L.E) earned in july 2012 (Excluding profits from your business which we
m_907
Total household income (L.E) in september 2012
m_1001_1
Investing 25L.E today for a 1% chance of making of 800L.E profit
m_1001_2
Investing 25L.E today for a 5% chance of making of 800L.E profit
m_1001_3
Investing 25L.E today for a 25% chance of making of 800L.E profit
m_1001_4
Investing 25L.E today for a 50% chance of making of 800L.E profit
m_1001_5
Investing 25L.E today for a 90% chance of making of 800L.E profit
m_1101_1
"Labor regulations":problem for the growth of the enterprise
m_1102_1
Judgment on "Labor regulations" severity as a problem
Total: 682
<123>
Back to Catalog
IHSN Survey Catalog

© IHSN Survey Catalog, All Rights Reserved.