Home / Central Data Catalog / EGY_2007_ES_V01_M_WB
central

Enterprise Survey 2007

Egypt, Arab Rep., 2006
Get Microdata
Reference ID
EGY_2007_ES_v01_M_WB
Producer(s)
World Bank
Metadata
DDI/XML JSON
Study website Interactive tools
Created on
Sep 29, 2011
Last modified
Mar 29, 2019
Page views
43059
Downloads
667

Data file: Egypt_Services06_idstd

The file contains the cleaned, raw data from services sector businesses. Text of questions can be found in "Productivity and the Investment Climate Private Enterprise Survey - Services Sector" in "Questionnaires" folder.

Cases: 343
Variables: 623

Variables

unitid
code
stutunit
firm's status
respjob
respondent's job
city1
city
partunit
does firm part of large association
branches
does the firm have other factories or branches?
branchno
number of branches or factories
budget
is there a unified balance sheet for the firm and all its establishments?
activity
firm's activity
sector
sector code
indust
percentage of total revenues coming from manufacturing
service
percentage of total revenues coming from services
trade
percentage of total revenues coming from commerce
other
percentage of total revenues coming from other activities
totemp
total number of employees in the firm
kism
kism/markaz
gov
governorate
indcity
is the factory located in an industrial zone?
citycode
name of industrial zone (code)
time1_m
the interview started at:minute:
time1_h
the interview started at:hour:
hday1
the interview started at:day:
hmonth1
the interview started at:month:
hyear1
the interview started at:year:
q1
current legal status of the firm
q1a
the law according to which the firm was established
q1b
in which year firm started its work in egypt?
q2a1
percentage of the firm owned by domestic private sector
q2a2
percentage of the firm owned by arab private sector
q2a3
percentage of the firm owned by foreign private sector
q2b
percentage of the firm owned by government
q2c
percentage of the firm owned by other sectors
q3a
was the firm previously majority owned by the government (the state)?
q3b
year of privatization
q4a
percentage of the firm owned by the single largest shareholder or owner
q4b1
description of the largest shareholder or owner in the firm
q4b2
description of the largest shareholder or owner in the firm
q4b3
description of the largest shareholder or owner in the firm
q4c
is the principal owner (or one of the principal owners) a female?
q5
number of establishments (stores or service outlets)
q6
the year the establishment began operating in egypt
q7a1
percentage of total sales represented by the first product
q7b1
the establishment's first main product
q7a2
percentage of total sales represented by the second product
q7b2
the establishment's second main product
q7a3
percentage of total sales represented by the third product
q7b3
the establishment's third main product
q8
number of competitors facing the firm in the domestic market concerning the majo
q9a1
percentage of the establishment's sales in 2005 that were sold domestically
q9a2
percentage of the establishment's sales in 2005 that were exported directly
q9a2p
percentage of the establishment's sales in 2004 that were exported directly
q9a3
percentage of the establishment's sales in 2005 that were exported indirectly (t
q9b1
percentage of the establishment's domestic sales in 2005 that were sold to the g
q9b2
percentage of the establishment's domestic sales in 2005 that were sold to state
q9b3
percentage of the establishment's domestic sales in 2005 that were sold to multi
q9b4
percentage of the establishment's domestic sales in 2005 that were sold to a dis
q9b5
percentage of the establishment's domestic sales in 2005 that were sold to the p
q9b6
percentage of the establishment's domestic sales in 2005 that were sold to large
q9b7
percentage of the establishment's domestic sales in 2005 that were sold to other
q9c1
the year the establishment first exported
q9c2a1
percentage of the establishment's total direct exports accounted for by the firs
q9c2a2
the first biggest destination (country) of the establishment's direct exports in
q9c2b1
percentage of the establishment's total direct exports accounted for by the seco
q9c2b2
the second biggest destination (country) of the establishment's direct exports i
q9c2c1
percentage of the establishment's total direct exports accounted for by the thir
q9c2c2
the third biggest destination (country) of the establishment's direct exports in
q10a1
major point of exit used in exportation
q10a2
average number of days in 2005 that it took from the time exports arrived in the
q10b
the longest number of days in 2005 that it took from the time exports arrived in
q10c
did the firm have to make an extra informal payment to expedite the clearance pr
q11a
percentage of the establishment's purchases of material inputs and supplies in 2
q11b1
percentage of the establishment's purchases of material inputs and supplies in 2
q11b2
percentage of the establishment's purchases of material inputs and supplies in 2
q11c
percentage of the establishment's purchases of material inputs and supplies in 2
q12a1
major point of entry used in importation
q12a2
average number of days in 2005 that it took from the time imports arrived in the
q12b
the longest number of days in 2005 that it took from the time imports arrived in
q12c
did the firm have to make an extra informal payment to expedite the clearance pr
q13a
number of days of production typically covered by local delivery
q13b
number of days of production typically covered by imported delivery
q14
percentage of purchased material inputs/supplies that are of lower than agreed u
q15a1
severity of "telecommunications" as an obstacle to operation and growth of the f
q15a2
severity of "electricity" as an obstacle to operation and growth of the firm
q15a3
severity of "transportation" as an obstacle to operation and growth of the firm
q15a4
severity of "water" as an obstacle to operation and growth of the firm
q15a5
severity of "access to land" as an obstacle to operation and growth of the firm
q15a6
severity of "price of land" as an obstacle to operation and growth of the firm
q15a7
severity of "regulatory policy uncertainty" as an obstacle to operation and grow
q15a8
severity of "tax rates" as an obstacle to operation and growth of the firm
q15a9
severity of "tax administration" as an obstacle to operation and growth of the f
q15a10
severity of "customs and trade regulations" as an obstacle to operation and grow
q15a11
severity of "labor regulations" as an obstacle to operation and growth of the fi
q15a12
severity of "skills and education of available workers" as an obstacle to operat
q15a13
severity of "business licensing and operating permits" as an obstacle to operati
q15b14
severity of "access to financing" as an obstacle to operation and growth of the
q15b15
severity of "cost of financing" as an obstacle to operation and growth of the fi
q15b16
severity of "macroeconomic uncertainty" as an obstacle to operation and growth o
q15b17
severity of "corruption/smuggling or dumping" as an obstacle to operation and gr
q15b18
severity of "illegal competition" as an obstacle to operation and growth of the
q15b19
severity of "legal system/ conflict resolution" as an obstacle to operation and
q15b20
severity of "other obstacles" to operation and growth of the firm
q15c1
the biggest obstacle for the operation and growth of the establishment
q15c2
the second biggest obstacle for the operation and growth of the establishment
q15c3
the third biggest obstacle for the operation and growth of the establishment
q16a1
the establishment's average capacity utilization over 2004
q16a2
the establishment's average capacity utilization over 2005
q16b
number of hours per week the establishment normally operates in 2005
q17a
the establishment's intentions over the next two years
q17b
percentage of expanding or reducing capacity intended by the firm
q18_1
has the establishment build a new major production activity line in 2004 or 2005
q18_2
has the establishment upgrading an existing product line in the factory in 2004
q18_3
has the establishment stopped a major production line activity for at least one
q18_4
has the establishment agreed to a new joint venture with foreign partner in 2004
q18_5
has the establishment obtained a new licensing agreement 2004 or 2005?
q18_6
has the establishment outsourced a major production activity that was previously
q19
has the establishment received an internationally recognized quality certificati
q20
does the establishment have a department specialized in research and development
q21
does the establishment use technology licensed from a foreign-owned company?
q22a1
number of times the establishment experienced "power outages or surges from the
q22b1
number of hours the "power outages or surges from the public grid" lasted on ave
q22c1
total losses (as a percentage of sales) resulting from "power outages or surges
q22a2
number of times the establishment experienced "insufficient water supply for pro
q22b2
number of hours the "insufficient water supply for production" lasted on average
q22c2
total losses (as a percentage of sales) resulting from "insufficient water suppl
q23a
does the establishment own or share a generator?
q23b
percentage of electricity coming from the firm's own or shared generator
q23c
the generator's original cost in egyptian pounds
q23cy
year of acquisition of the generator
q24_1
percentage of the establishment's water supply coming from public sources
q24_2
percentage of the establishment's water supply coming from its own well or a sha
q24_3
percentage of the establishment's water supply purchased from private vendors
q25a
does the establishment use its own transport for its shipments?
q25b
percentage of the establishment's shipments using its own transport
q26a
main transport mode used when shipping products and/or inputs and supplies
q26b_1
percentage of the value of domestic shipments lost while in transit due to break
q26b_2
percentage of the value of international shipments lost while in transit due to
q26b_3
percentage of the value of domestic shipments lost while in transit due to steal
q26b_4
percentage of the value of international shipments lost while in transit due to
q27_1
does the establishment regularly use e-mail in its interactions with clients and
q27_2
does the establishment regularly use a website in its interactions with clients
q28a
does the establishment own or lease the majority of its land?
q28b
the way by which the firm acquired the land
q28c
is there an ownership title for the land?
q28d
is the ownership title recorded in the land register?
q28e
does the establishment own or lease the majority of the buildings?
q29
percentage of the establishment's inputs bought on credit during 2005
q30y
last year have new investments
q30_1a
the contribution of "internal funds or retained earnings" in the establishment's
q30_1b
the contribution of "internal funds or retained earnings" in the establishment's
q30_2a
the contribution of "domestic commercial banks (loan, overdraft)" in the establi
q30_2b
the contribution of "domestic commercial banks (loan, overdraft)" in the establi
q30_3a
the contribution of "international commercial banks" in the establishment's work
q30_3b
the contribution of "international commercial banks" in the establishment's new
q30_4a
the contribution of "leasing arrangement" in the establishment's working capital
q30_4b
the contribution of "leasing arrangement" in the establishment's new investments
q30_5a
the contribution of "special development financing/ or public financing (governm
q30_5b
the contribution of "special development financing/ or public financing (governm
q30_6a
the contribution of "trade credit (supplier or customer credit)" in the establis
q30_6b
the contribution of "trade credit (supplier or customer credit)" in the establis
q30_7a
the contribution of "credit cards" in the establishment's working capital in 200
q30_7b
the contribution of "credit cards" in the establishment's new investments
q30_8a
the contribution of "equity, sale of stock" in the establishment's working capit
q30_8b
the contribution of "equity, sale of stock" in the establishment's new investmen
q30_9a
the contribution of "family, friends" in the establishment's working capital in
q30_9b
the contribution of "family, friends" in the establishment's new investments
q30_10a
the contribution of "informal sources (e.g. money lender)" in the establishment'
q30_10b
the contribution of "informal sources (e.g. money lender)" in the establishment'
q30_11a
the contribution of "other sources of financing" in the establishment's working
q30_11b
the contribution of "other sources of financing" in the establishment's new inve
q31
was a gift or informal payment expected in dealings with bank officials?
q32
does the establishment have an overdraft facility or line of credit?
q33a
percentage of overdraft or credit line not currently used
q33b
the annual interest rate of the overdraft or line of credit in 2004
q34a
does the establishment currently have a loan from a financial institution?
q34b
overdraft facility or line of credit
q34c
what percent is currently NOT used?
q34d
the annual interest rate of the overdraft or line of credit?
q34e1
were "land and buildings" used as collateral?
q34e2
were "immoveable plant, machinery" used as collateral?
q34e3
were "moveable machinery and equipment (including vehicles)" used as collateral?
q34e4
were "other tangible assets (e.g. accounts receivable, inventory)" used as colla
q34e5
were "personal assets of the owner/manager (e.g. house)" used as collateral?
q34e6
were "other assets" used as collateral?
q34f
the approximate value of the collateral required as a percentage of the loan val
q34g
the loan's annual rate of interest in 2005
q34h
the total duration of the loan in months
q34i1
was the main use of this loan "to buy/ update/ or replace machinery and equipmen
q34i2
was the main use of this loan "to buy other fixed assets (land, buildings, and v
q34i3
was the main use of this loan "to buy inputs, supplies, goods to resell"?
q34i4
was the main use of this loan "to pay earlier loans"?
q34i5
was the main use of this loan "other uses"?
q35a
the reason for not having a loan currently
q35b1
the principal reason for not applying for a loan
q35b2
the second reason for not applying for a loan
q35b3
the third reason for not applying for a loan
q35b
what year was this loan approved?
q36
the principal reason mentioned when rejecting the application for a loan
q37
share of the firm's total borrowing denominated in foreign currency
q38a1
does the establishment have a checking account?
q38a2
does the establishment have a saving account?
q38b
does the establishment have property and casualty insurance on the majority of i
q38c
does the establishment have its annual financial statement checked and certified
q39_1
percentage of the establishment's sales in 2005 that was pre paid (paid before d
q39_2
percentage of the establishment's sales in 2005 that was paid at delivery
q39_3
percentage of the establishment's sales in 2005 that was sold on credit (or with
q40a1
percentage of the firm's total sales to public sector in 2005 that were not paid
q40a2
percentage of the firm's total sales to private sector in 2005 that were not pai
q40b
percentage of the total sales that are never repaid
q41a
do completely agree or agree to some way or disagree in most of times or complet
q41b
number of months it typically takes to resolve an overdue payment with customers
q42a
percentage of the establishment's disputes over overdue payments with customers
q42b1
on average over 2003 and 2004, how many months did those court cases take to res
q42b2
on average over 2003 and 2004, which year did those court cases take to resolve,
q42c
were the decisions of the court on disputes over overdue payments enforced?
q43a
in which year does the firm registed or reregisted?
q43b1
the total time (calendar days) taken for commercial registration
q43b2
did the firm have to present gifts or unofficial payments to finish commercial r
q43c1
the total time (calendar days) taken for industrial registration
q43c2
did the firm have to present gifts or unofficial payments to finish industrial r
q44
did the firm hire an outside company to help complete the commercial or industri
q45a1
first main reason that affects the decision of changing number of employees in t
q45a2
second main reason that affects the decision of changing number of employees in
q45b
number of workers to be fired if there are no restrictions affecting the firm's
q45c
number of workers to be hired if there are no restrictions affecting the firm's
q46a
are establishments in the same sector required to make gifts or informal payment
q46b1
cost of gifts and informal payments to public officials as a total value in egyp
q46b2
cost of gifts and informal payments to public officials as a percentage of total
q47a1
the actual delay (in months) experienced till receiving "a mainline telephone co
q47b1
the actual delay (in months) experienced for receiving "a mainline telephone con
q47c1
was a gift or informal payment asked for or expected to obtain "a mainline telep
q47a2
the actual delay (in months) experienced till receiving "an electrical connectio
q47b2
the actual delay (in months) experienced for receiving "an electrical connection
q47c2
was a gift or informal payment asked for or expected to obtain "an elecrical con
q47a3
the actual delay (in months) experienced till receiving "a water connection"
q47b3
the actual delay (in months) experienced for receiving "a water connection" (the
q47c3
was a gift or informal payment asked for or expected to obtain "a water connecti
q47a4
the actual delay (in months) experienced till receiving "a construction permit"
q47b4
the actual delay (in months) experienced for receiving "a construction permit" (
q47c4
was a gift or informal payment asked for or expected to obtain "a construction p
q47a5
the actual delay (in months) experienced till receiving "an import license"
q47b5
the actual delay (in months) experienced for receiving "an import license" (the
q47c5
was a gift or informal payment asked for or expected to obtain "an import licens
q47a6
the actual delay (in months) experienced till receiving "main operating license"
q47b6
the actual delay (in months) experienced for receiving "main operating license"
q47c6
was a gift or informal payment asked for or expected to obtain "main operating l
q47a7
the actual delay (in months) experienced till receiving "an import card"
q47b7
the actual delay (in months) experienced for receiving "an import card" (the fir
q47c7
was a gift or informal payment asked for or expected to obtain "an import card"?
q47a8
the actual delay (in months) experienced till receiving "municipal permits"
q47b8
the actual delay (in months) experienced for receiving "municipal permits" (the
q47c8
was a gift or informal payment asked for or expected to obtain "municipal permit
q47a9
the actual delay (in months) experienced till receiving "industrial security lic
q47b9
the actual delay (in months) experienced for receiving "industrial security lice
q47c9
was a gift or informal payment asked for or expected to obtain "industrial secur
q47a10
the actual delay (in months) experienced till receiving "environmental approval"
q47b10
the actual delay (in months) experienced for receiving "environmental approval"
q47c10
was a gift or informal payment asked for or expected to obtain "environmental ap
q48a
percentage of total sales reported for tax purposes
q48b
percentage of total workforce reported for purposes of labor regulation and soci
q49a1
number of times the establishment was inspected by "tax inspectorate" in 2005
q49a1_05
number of times the establishment was inspected by "tax inspectorate" in 2004
q49b1
was a gift or informal payment asked for or expected at the interactions with "t
q49a2
number of times the establishment was inspected by "labor and social security" i
q49b2
was a gift or informal payment asked for or expected at the interactions with "l
q49a3
number of times the establishment was inspected by "fire and building security"
q49b3
was a gift or informal payment asked for or expected at the interactions with "f
q49a4
number of times the establishment was inspected by "sanitation/ epidemiology" in
q49b4
was a gift or informal payment asked for or expected at the interactions with "s
q49a5
number of times the establishment was inspected by "police" in 2005
q49b5
was a gift or informal payment asked for or expected at the interactions with "p
q49a6
number of times the establishment was inspected by "environmental authorities" i
q49b6
was a gift or informal payment asked for or expected at the interactions with "e
q49a7
number of times the establishment was inspected by "state office dealing with co
q49b7
was a gift or informal payment asked for or expected at the interactions with "s
q49a8
number of times the establishment was inspected by "customs clearance" in 2005
q49b8
was a gift or informal payment asked for or expected at the interactions with "c
q49a9
number of times the establishment was inspected by "other agencies" in 2005
q49b9
was a gift or informal payment asked for or expected at the interactions with "o
q50a
is a gift or informal payment expected to secure the contract, when performing b
q50b
the typical value of the gift or informal payment (made to the government offici
q51
the total number of full-time paid employees when the firm started its operation
q52a1
the average number of permanent workers in 2003
q52b1
the average number of permanent workers in 2004
q52c1
the average number of permanent workers in 2005
q52c2
the average number of permanent professionals in 2005
q52c3
the average number of permanent skilled production workers in 2005
q52c4
the average number of permanent unskilled production workers in 2005
q52c5
the average number of permanent non- production workers in 2005
q52d1
the total number of female permanent workers in 2005
q52d2
the number of female permanent professionals in 2005
q52d3
the number of female permanent skilled production workers in 2005
q52d4
the number of female permanent unskilled production workers in 2005
q52d5
the number of female permanent non- production workers in 2005
q52e1
the total number of part-time workers in 2005
q52f1
the total compensation and salaries of all permanent workers
q52f2
the total compensation and salaries of permanent professionals
q52f3
the total compensation and salaries of permanent skilled production workers
q52f4
the total compensation and salaries of permanent unskilled production workers
q52f5
the total compensation and salaries of permanent non- production workers
q53a
number of male temporary workers in 2005
Total: 623
Back to Catalog