Home / Central Data Catalog / EGY_2004_ICS_V01_M_WB
central

Investment Climate Survey 2004

Egypt, Arab Rep., 2004
Get Microdata
Reference ID
EGY_2004_ICS_v01_M_WB
Producer(s)
World Bank
Metadata
DDI/XML JSON
Created on
Sep 29, 2011
Last modified
Mar 29, 2019
Page views
18418
Downloads
347

Data file: Egypt, Arab Rep

The file contains the cleaned, raw database. Text of questions can be found in "Productivity and the Investment Climate Private Enterprise Survey" in "Questionnaires" folder.

Cases: 977
Variables: 438

Variables

idstd
WEB STD FIRMID
unitid
code
respjob
respondent's job
city1
city
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)
keyer
data entry
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
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 2004 that were sold domestically
q9a2
percentage of the establishment's sales in 2004 that were exported directly
q9a2p
percentage of the establishment's sales in 2003 that were exported directly
q9a3
percentage of the establishment's sales in 2004 that were exported indirectly (t
q9b1
percentage of the establishment's domestic sales in 2004 that were sold to the g
q9b2
percentage of the establishment's domestic sales in 2004 that were sold to state
q9b3
percentage of the establishment's domestic sales in 2004 that were sold to multi
q9b4
percentage of the establishment's domestic sales in 2004 that were sold to a dis
q9b5
percentage of the establishment's domestic sales in 2004 that were sold to the p
q9b6
percentage of the establishment's domestic sales in 2004 that were sold to large
q9b7
percentage of the establishment's domestic sales in 2004 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 2004 that it took from the time exports arrived in the
q10b
the longest number of days in 2004 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 2004 that it took from the time imports arrived in the
q12b
the longest number of days in 2004 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 as an obstacle to operation and growth of the firm
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 smuggling or dumping as an obstacle to operation and growth of the
q15b21
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 2003
q16a2
the establishment's average capacity utilization over 2004
q16b
number of hours per week the establishment normally operates in 2004
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 developed an important new product line in 2003 or 2004?
q18_2
has the establishment upgraded an existing product line in 2003 or 2004?
q18_3
has the establishment discontinued at least one product (not production) line in
q18_4
has the establishment agreed to a new joint venture with foreign partner in 2003
q18_5
has the establishment obtained a new licensing agreement in 2003 or 2004?
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?
q22a
has the establishment acquired new technology over 2003 and 2004 that either sub
q22b1
the most important way by which the establishment acquired the new technology
q22b2
the second most important way by which the establishment acquired the new techno
q23a1
number of times the establishment experienced power outages or surges from the
q23b1
number of hours the power outages or surges from the public grid lasted on ave
q23c1
total losses (as a percentage of sales) resulting from power outages or surges
q23a2
number of times the establishment experienced insufficient water supply for pro
q23b2
number of hours the insufficient water supply for production lasted on average
q23c2
total losses (as a percentage of sales) resulting from insufficient water suppl
q24a
does the establishment own or share a generator?
q24b
percentage of electricity coming from the firm's own or shared generator
q24c
the generator's original cost in egyptian pounds
q24cy
year of acquisition of the generator
q25_1
percentage of the establishment's water supply coming from public sources
q25_2
percentage of the establishment's water supply coming from its own well or a sha
q25_3
percentage of the establishment's water supply purchased from private vendors
q26a
does the establishment use its own transport for its shipments?
q26b
percentage of the establishment's shipments using its own transport
q27
main transport mode used when shipping products and/or inputs and supplies
q27a_1
percentage of the value of domestic shipments lost while in transit due to break
q27a_2
percentage of the value of international shipments lost while in transit due to
q28_1
does the establishment regularly use e-mail in its interactions with clients and
q28_2
does the establishment regularly use a website in its interactions with clients
q29a
does the establishment own or lease the majority of its land?
q29b
the way by which the firm acquired the land
q29c
is there an ownership title for the land?
q29d
is the ownership title recorded in the land register?
q29e1
did a land dispute take place recently?
q29e2
the duration of land dispute in months
q29f
the way by which the dispute ended
q29g
the way by which the land was rented
q30
does the establishment own or lease the majority of the buildings?
q31
percentage of the establishment's inputs bought on credit during 2004
q32y
last year of new investment
q32_1a
the contribution of internal funds or retained earnings in the establishment's
q32_1b
the contribution of internal funds or retained earnings in the establishment's
q32_2a
the contribution of domestic commercial banks (loan, overdraft) in the establi
q32_2b
the contribution of domestic commercial banks (loan, overdraft) in the establi
q32_3a
the contribution of international commercial banks in the establishment's work
q32_3b
the contribution of international commercial banks in the establishment's new
q32_4a
the contribution of leasing arrangement in the establishment's working capital
q32_4b
the contribution of leasing arrangement in the establishment's new investments
q32_5a
the contribution of special development financing/ or public financing (governm
q32_5b
the contribution of special development financing/ or public financing (governm
q32_6a
the contribution of trade credit (supplier or customer credit) in the establis
q32_6b
the contribution of trade credit (supplier or customer credit) in the establis
q32_7a
the contribution of credit cards in the establishment's working capital in 200
q32_7b
the contribution of credit cards in the establishment's new investments
q32_8a
the contribution of equity, sale of stock in the establishment's working capit
q32_8b
the contribution of equity, sale of stock in the establishment's new investmen
q32_9a
the contribution of family, friends in the establishment's working capital in
q32_9b
the contribution of family, friends in the establishment's new investments
q32_10a
the contribution of informal sources (e.g. money lender) in the establishment'
q32_10b
the contribution of informal sources (e.g. money lender) in the establishment'
q32_11a
the contribution of other sources of financing in the establishment's working
q32_11b
the contribution of other sources of financing in the establishment's new inve
q33
was a gift or informal payment expected in dealings with bank officials?
q34
does the establishment have an overdraft facility or line of credit?
q34a
percentage of overdraft or credit line not currently used
q34b
the annual interest rate of the overdraft or line of credit in 2004
q35a
does the establishment currently have a loan from a financial institution?
q35b
year of approving the loan
q35c
was the loan in a foreign currency?
q35d
did the loan require collateral or a deposit?
q35e1
were land and buildings used as collateral?
q35e2
were immoveable plant, machinery used as collateral?
q35e3
were moveable machinery and equipment (including vehicles) used as collateral?
q35e4
were other tangible assets (e.g. accounts receivable, inventory) used as colla
q35e5
were personal assets of the owner/manager (e.g. house) used as collateral?
q35e6
were other assets used as collateral?
q35f
the approximate value of the collateral required as a percentage of the loan val
q35g
the loan's annual rate of interest in 2004
q35h
the total duration of the loan in months
q35i1
was the main use of this loan to buy/ update/ or replace machinery and equipmen
q35i2
was the main use of this loan to buy other fixed assets (land, buildings, and v
q35i3
was the main use of this loan to buy inputs, supplies, goods to resell ?
q35i4
was the main use of this loan to pay earlier loans ?
q35i5
was the main use of this loan other uses ?
q36
the reason for not having a loan currently
q37a1
the principal reason for not applying for a loan
q37a2
the second reason for not applying for a loan
q37a3
the third reason for not applying for a loan
q37b
the principal reason mentioned when rejecting the application for a loan
q38
share of the firm's total borrowing denominated in foreign currency
q39a1
does the establishment have a checking account?
q39a2
does the establishment have a saving account?
q39b
does the establishment have property and casualty insurance on the majority of i
q40
does the establishment have its annual financial statement checked and certified
q41_1
percentage of the establishment's sales in 2004 that was pre paid (paid before d
q41_2
percentage of the establishment's sales in 2004 that was paid at delivery
q41_3
percentage of the establishment's sales in 2004 that was sold on credit (or with
q42a1
percentage of the firm's total sales to public sector in 2004 that were not paid
q42a2
percentage of the firm's total sales to private sector in 2004 that were not pai
q42b
percentage of the total sales that are never repaid
q42c
number of months it typically takes to resolve an overdue payment with customers
q43a
percentage of the establishment's disputes over overdue payments with customers
q43b
average number of months the court cases took to resolve disputes over overdue p
q43c
were the decisions of the court on disputes over overdue payments enforced?
q44a1
the total time (calendar days) taken for commercial registration
q44a2
did the firm have to present gifts or unofficial payments to finish commercial r
q44b1
the total time (calendar days) taken for industrial registration
q44b2
did the firm have to present gifts or unofficial payments to finish industrial r
q45
did the firm hire an outside company to help complete the commercial or industri
q46a1
first main reason that affects the decision of changing number of employees in t
q46a2
second main reason that affects the decision of changing number of employees in
q46b
number of workers to be fired if there are no restrictions affecting the firm's
q46c
number of workers to be hired if there are no restrictions affecting the firm's
q47a
are establishments in the same sector required to make gifts or informal payment
q47b1
cost of gifts and informal payments to public officials as a total value in egyp
q47b2
cost of gifts and informal payments to public officials as a percentage of total
q48a1
the actual delay (in months) experienced till receiving a mainline telephone co
q48b1
the actual delay (in months) experienced for receiving a mainline telephone con
q48c1
was a gift or informal payment asked for or expected to obtain a mainline telep
q48a2
the actual delay (in months) experienced till receiving an electrical connectio
q48b2
the actual delay (in months) experienced for receiving an electrical connection
q48c2
was a gift or informal payment asked for or expected to obtain an elecrical con
q48a3
the actual delay (in months) experienced till receiving a water connection
q48b3
the actual delay (in months) experienced for receiving a water connection (the
q48c3
was a gift or informal payment asked for or expected to obtain a water connecti
q48a4
the actual delay (in months) experienced till receiving a construction permit
q48b4
the actual delay (in months) experienced for receiving a construction permit (
q48c4
was a gift or informal payment asked for or expected to obtain a construction p
q48a5
the actual delay (in months) experienced till receiving an import license
q48b5
the actual delay (in months) experienced for receiving an import license (the
q48c5
was a gift or informal payment asked for or expected to obtain an import licens
q48a6
the actual delay (in months) experienced till receiving main operating license
q48b6
the actual delay (in months) experienced for receiving main operating license
q48c6
was a gift or informal payment asked for or expected to obtain main operating l
q48a7
the actual delay (in months) experienced till receiving an import card
q48b7
the actual delay (in months) experienced for receiving an import card (the fir
q48c7
was a gift or informal payment asked for or expected to obtain an import card ?
q48a8
the actual delay (in months) experienced till receiving municipal permits
q48b8
the actual delay (in months) experienced for receiving municipal permits (the
q48c8
was a gift or informal payment asked for or expected to obtain municipal permit
q48a9
the actual delay (in months) experienced till receiving industrial security lic
q48b9
the actual delay (in months) experienced for receiving industrial security lice
q48c9
was a gift or informal payment asked for or expected to obtain industrial secur
q48a10
the actual delay (in months) experienced till receiving environmental approval
q48b10
the actual delay (in months) experienced for receiving environmental approval
q48c10
was a gift or informal payment asked for or expected to obtain environmental ap
q49a
percentage of total sales reported for tax purposes
q49b
percentage of total workforce reported for purposes of labor regulation and soci
q50a1
number of times the establishment was inspected by tax inspectorate in 2004
q50a1_03
number of times the establishment was inspected by tax inspectorate in 2003
q50b1
was a gift or informal payment asked for or expected at the interactions with t
q50a2
number of times the establishment was inspected by labor and social security i
q50b2
was a gift or informal payment asked for or expected at the interactions with l
q50a3
number of times the establishment was inspected by fire and building security
q50b3
was a gift or informal payment asked for or expected at the interactions with f
q50a4
number of times the establishment was inspected by sanitation/ epidemiology in
q50b4
was a gift or informal payment asked for or expected at the interactions with s
q50a5
number of times the establishment was inspected by police in 2004
q50b5
was a gift or informal payment asked for or expected at the interactions with p
q50a6
number of times the establishment was inspected by environmental authorities i
q50b6
was a gift or informal payment asked for or expected at the interactions with e
q50a7
number of times the establishment was inspected by state office dealing with co
q50b7
was a gift or informal payment asked for or expected at the interactions with s
q50a8
number of times the establishment was inspected by customs clearance in 2004
q50b8
was a gift or informal payment asked for or expected at the interactions with c
q50a9
number of times the establishment was inspected by other agencies in 2004
q50b9
was a gift or informal payment asked for or expected at the interactions with o
q51a
is a gift or informal payment expected to secure the contract, when performing b
q51b
the typical value of the gift or informal payment (made to the government offici
q52
the total number of full-time paid employees when the firm started its operation
q53a1
the average number of permanent workers in 2002
q53b1
the average number of permanent workers in 2003
q53c1
the average number of permanent workers in 2004
q53c2
the average number of permanent professionals in 2004
q53c3
the average number of permanent skilled production workers in 2004
q53c4
the average number of permanent unskilled production workers in 2004
q53c5
the average number of permanent non- production workers in 2004
q53d1
the total number of female permanent workers in 2004
q53d2
the number of female permanent professionals in 2004
q53d3
the number of female permanent skilled production workers in 2004
q53d4
the number of female permanent unskilled production workers in 2004
q53d5
the number of female permanent non- production workers in 2004
q53e1
the total number of part-time workers in 2004
q53f1
the total compensation and salaries of all permanent workers
q53f2
the total compensation and salaries of permanent professionals
q53f3
the total compensation and salaries of permanent skilled production workers
q53f4
the total compensation and salaries of permanent unskilled production workers
q53f5
the total compensation and salaries of permanent non- production workers
Total: 438
Back to Catalog