Business Registration in Malawi Experimental Data and Replication Files 2011-2015

Malawi, 2011 - 2015

Get Microdata

Reference ID

MWI_2011_BRIEL_v01_M

DOI

https://doi.org/10.48529/gnk7-n020

Producer(s)

David McKenzie

Collection(s)

Impact Evaluation Surveys

Metadata

Documentation in PDF DDI/XML JSON

Created on

Sep 27, 2018

Last modified

May 05, 2021

Page views

283282

Downloads

4367

Data file: BRIE_finalpanel_Allfollowups_SEP2018

Anonymized master panel data

Cases:	15010
Variables:	514

Variables

City

took_br

1= certificate delivered

attendedtrainingday1

Attended Training? Day 1

attendedtrainingday2

Attended Training? Day 2

bankaccountopened

Bank account opened

female

1= Owner is female

owner_age

Owner age

Literate

1= Literate

Higher_education

1= Higher education completed

primary_completed

1= Primary school completed is max education

Seconday_completed

1= Secondary school completed is max education

Manufacturing

1= Business sector is manufacturing

Retail

1= Business sector is retail

Services

1= Business sector is services

firm_age

Age of firm

F_Business_owner

Number of owners - all follow-ups and baseline info-

F_Total_workers2

Number of people working in business -follow-up info-

F_capital

Capital (MWK): Fixed Assets - all follow-ups and baseline info-

own_space

1= Owns space where operates business

netw_anyline

1= Network contacts any sector at baseline

F_paidcitycouncilmktfee

1= Paid city council market fee- all follow-ups and baseline info-

F_benefits_reg

Owner indetifies benefits from registration

F_inspected_municipality

The business ever been inspected by municipality (City Assembly) authorities

F_Asked_for_bribe

1= Has been asked for bribe - all follow-ups and baseline info-

sexuallyHarassed

1= Has been sexually harassed at baseline

innov

# new products introduced past 12 months

F_number_days_workmonth

Number of days worked last month - all follow-ups and baseline info-

num_customers_month

Number of customers at baseline

F_receipt

1= Firm provides formal receipts - all follow-ups and baseline info-

Business_plan

1= Has a business plan at baseline

F_budget

1= Has a budget - all follow-ups and baseline info-

F_financial_records

1= Business keeps financial records - all follow-ups and baseline info-

F_mix_bus_hh

1= Takes business money whenever for HH - all follow-ups and baseline inf

Num_competitors

# of competitors

F_Financial_knowledge

Financial literacy knowledge (0-1)- all follow-ups and baseline info-

owner_started

1= Owner started business

Selfmainprovider

1= Main provider of income to household

Married

1= Married / Living with someone

mother_enterpreneur

1= Mother was entrepreneur

mother_wage_employt

1= Mother in Wage Employment

father_enterpreneur

1= Father was entrepreneur

father_wage_employt

1= Father in Wage Employment

spouse_enterpreneur

1= Spouse is entrepreneur

spouse_wage_employt

1=Spouse in Wage Employment

hh_decision_index

HH decision making index (0-100)

electricity_access

1= Business with access to electricity

lilongwe

1= Lilongwe

F_bank_loan

Bank loan

time_to_nearestbank

Time to nearest bank (minutes)

F_Profit_lastmonth

Profit last month (MWK)

F_Revenue_lastmonth

Revenue last month (MWK)

F_Revenue_lastmonth99

Revenue last month winsorized at 99th percentile (MWK) - all follow-ups a

F_Profit_lastmonth99

Profit last month winsorized at 99th percentile (MWK) - all follow-ups an

usd_Revenue_lastmonth

Revenue last month (US$) at baseline

usd_Profit_lastmonth

Profit last month (US$) at baseline

usd_Revenue_lastmonth99

Revenue last month winsorized at 99th percentile (US$) at baseline

usd_Profit_lastmonth99

Profits last month winsorized at 99th percentile (US$) at baseline

F_Revenue_lastweek

Revenue last week (MWK) - all follow-ups and baseline info-

usd_Revenue_lastweek

Revenue last week (US$) at baseline

F_Profit_lastweek

Profit last week (MWK) - all follow-ups and baseline info-

usd_Profit_lastweek

Profit last week (US$) at baseline

F_Revenue_lastweek99

Revenue last week winsorized at 99th percentile (MWK) - all follow-ups an

F_Profit_lastweek99

Profit last week winsorized at 99th percentile (MWK) - all follow-ups an

usd_Revenue_lastweek99

Revenue last week winsorized at 99th percentile (US$) at baseline

usd_Profit_lastweek99

Profits last week winsorized at 99th percentile (US$) at baseline

missBSRevenue_lastweek

1= Revenue last week var is missing in Baseline

missBSRevenue_lastweek99

1= Revenue last week winsorized var is missing in Baseline

missBSRevenue_lastmonth

1= Revenue last month var is missing in Baseline

missBSRevenue_lastmonth99

1= Revenue last month winsorized var is missing in Baseline

missBSProfit_lastweek

1= Profit last week var is missing in Baseline

missBSProfit_lastweek99

1= Profit last week winsorized var is missing in Baseline

missBSProfit_lastmonth

1= Profit last month var is missing in Baseline

missBSProfit_lastmonth99

1= Profit last month winsorized var is missing in Baseline

F_banksonly_bus_account

1= Has bank account in name of business - all follow-ups and baseline info-

missBSbanksonly_bus_account

1= banksonly_bus_account var is missing in Baseline

F_any_account

1= Has an account - all follow-ups and baseline info-

F_banks_any_account

1= Has a bank account - all follow-ups and baseline info-

missBSbanks_any_account

1= banks_any_account var is missing in Baseline

F_banks_saving

1= Saves at bank - all follow-ups and baseline info-

missBSbanks_saving

1= banks_saving var is missing in Baseline

F_rosca_sacco

1= saves at ROSCA-SACCO - all follow-ups and baseline info-

missBSrosca_sacco

1= rosca-sacco varis missing in Baseline

F_save_home

1= saves at home- all follow-ups and baseline info-

missBSsave_home

1= save_home var is missing in Baseline

F_account_used_only_business

1= Uses any account just for business purposes - all follow-ups and baseline inf

missBSaccount_used_only_business

1= account_used_only_business var is missing in Baseline

F_saved_amount

Saved amount (MWK)- all follow-ups and baseline info-

usd_saved_amount

Saved amount (US$) at baseline

F_saved_amount99

Saved amount winsorized at 99th percentile (MWK) - all follow-ups and bas

usd_saved_amount99

Saved amount winsorized at 99th percentile (U) at baseline

F_saved_amount_bank

Saved amount at bank (MWK) - all follow-ups and baseline info-

usd_saved_amount_bank

Saved amount at bank (US$) at baseline

missBSsaved_amount_bank

1= saved_amount_bank var is missing in Baseline

F_borrowed_in_past

1=Borrowed in the past - all follow-ups and baseline info-

debt_outst_includezero

Debt outstanding amount (MWK) at baseline (includes zeros)

usd_debt_outst_include

Debt outstanding amount (U) at baseline (excludes zeros)

F_assets

Assets (MWK): Fixed Assets + Inventories + Cash - all follow-ups and base

usd_assets

Assets (US$): Fixed Assets + Inventories + Cash at baseline

usd_capital

Capital (US$): Fixed Assets at baseline

F_has_BRC

1= Has BRC - all follow-ups and baseline info-

missBShas_BRC

1= has_BRC var is missing in Baseline

F_has_TPIN

1= Has TPIN - all follow-ups and baseline info-

missBShas_TPIN

1= has_TPIN var is missing in Baseline

F_has_city_council

1= Has city council license - all follow-ups and baseline info-

missBShas_city_council

1= has city council var is missing in Baseline

F_ihst_Profit_lastmonth

Profit last month inverse hyperbolic sine transformation (MWK)- all follo

F_ihst_Revenue_lastmonth

Revenue last month inverse hyperbolic sine transformation (MWK) - all fol

missBSihst_Revenue_lastmonth

1= ihst_Revenue_lastmonth var is missing in Baseline

missBSihst_Profit_lastmonth

1= ihst_Profit_lastmonth var is missing in Baseline

F_amount_recentloan

Amount of a recent loan (MWK) - all follow-ups and baseline info-

usd_amount_recentloan

Amount of a recent loan (US$) at baseline

missBSamount_recentloan

1=amount_recentloan var is missing in Baseline

missBScapital

1= capital var is missing in Baseline

high_capture

1= High capture

missBSmix_bus_hh

1= mix_bus var is missing in Baseline

missBSfinancial_records

1= financial_records var is missing in Baseline

F_confiscation

1= Has received threats to confiscation - all follow-ups and baseline inf

missBSconfiscation

1= confiscation var is missing in Baseline

F_num_customers

Number of customers- all follow-ups and baseline info-

F_tender

1=Participates in Gov't tenders - all follow-ups and baseline info-

missBStender

1= tender var is missing in Baseline

F_advert

1= Advertises - all follow-ups and baseline info-

F_propmaleworkers

Proportion of male workers - all follow-ups and baseline info-

missBSpropmaleworkers

1= propmaleworkers var is missing in Baseline

missBSinspected_municipality

1= inspected_municipality var is missing in Baseline

missBSAsked_for_bribe

1= Asked_for_bribe var is missing in Baseline

F_threats_to_shutdown

1= Has received threats to shutdown - all follow-ups and baseline info-

missBSthreats_to_shutdown

1=threats_to_shutdown var is missing in Baseline

F_sexually_harassed

1= Has been sexually harassed - all follow-ups and baseline info-

missBSsexually_harassed

1= sexuallyharrased var is missing in Baseline

F_other_harassment

1= Has received other harassment - all follow-ups and baseline info-

missBSother_harassment

1= other_harrasment var is missing in Baseline

missBSreceipt

1= receipt var is missing in Baseline

F_other_activity

Other business activity - all follow-ups and baseline info-

F_taxescosts

Taxes costs (MWK)- all follow-ups and baseline info-

missBStaxescosts

1= taxescosts is missing in Baseline

large_size

1= Large firm

F_loan_can_raise

Amount that business can borrow in 2 weeks (MWK) - all follow-ups and bas

usd_loan_can_raise

Amount that business can borrow in 2 weeks (U) at baseline

missBSusd_loan_can_raise

1= usd_loan_can_raise is missing in Baseline

F_insurance

1= Has insurance for business - all follow-ups and baseline info-

missBSinsurance

1= insurance is missing in Baseline

no_inspected_taxes

1= Hasn't been inspected by taxes authorities at baseline

missBSno_inspected_taxes

1= no_inspected_taxes is missing in Baseline

no_inspected_other

1= Hasn't been inspected by other authorities at baseline

missBSno_inspected_other

1=no_inspected_other is missing in Baseline

confident_no_bribe

1= Doesn't feel confident to say no to bribes at baseline

missBSconfident_no_bribe

1= confident_no_bribe is missing in Baseline

F_chamber

1= Belongs to Malawian Chamber of Commerce - all follow-ups and baseline info-

missBSchamber

1= chamber is missing in Baseline

F_export_license

1= Has export license - all follow-ups and baseline info-

missBSexport_license

1= export license is missing in Baseline

F_contact_bank

1= Bank contacted business - all follow-ups and baseline info-

missBScontact_bank

1= contack bank is missing in Baseline

F_changes_location

1= Location of the business has changed - all follow-ups and baseline info-

missBSchanges_location

1= changes location is missing in Baseline

F_t_courts

1= Trust in courts - all follow-ups and baseline info-

missBSt_courts

1= trust in courts is missing in Baseline

F_t_police

1= Trust in police- all follow-ups and baseline info-

missBSt_police

1= trust in police is missing in Baseline

F_t_govern

1= Trust in government- all follow-ups and baseline info-

missBSt_govern

1= trust in government is missing in Baseline

F_t_city_council

1= Trust in city council - all follow-ups and baseline info-

missBSt_city_council

1= trust in city council is missing in Baseline

F_t_tax_aut

1= Trust in tax authorities - all follow-ups and baseline info-

missBSt_tax_aut

1= trust in tax authorities is missing in Baseline

round_fup

Indicates round survey

treat1_BR

Treatment 1: BRC

treat2_BR_TPIN

Treatment 2: BRC + TPIN

treat3_BR_Bank

Treatment 3: BRC + IS + BBA

control

1= control group

treatment

treatment status

strata_1

strata== 1.0000

strata_2

strata== 2.0000

strata_3

strata== 3.0000

strata_4

strata== 4.0000

strata_5

strata== 5.0000

strata_6

strata== 6.0000

strata_7

strata== 7.0000

strata_8

strata== 8.0000

strata_9

strata== 9.0000

strata_10

strata== 10.0000

strata_11

strata== 11.0000

strata_12

strata== 12.0000

strata_13

strata== 13.0000

strata_14

strata== 14.0000

strata_15

strata== 15.0000

strata_16

strata== 16.0000

strata_17

strata== 17.0000

strata_18

strata== 18.0000

strata_19

strata== 19.0000

strata_20

strata== 20.0000

strata_21

strata== 21.0000

strata_22

strata== 22.0000

strata_23

strata== 23.0000

strata_24

strata== 24.0000

strata_25

strata== 25.0000

strata_26

strata== 26.0000

strata_27

strata== 27.0000

strata_28

strata== 28.0000

strata_29

strata== 29.0000

strata_30

strata== 30.0000

strata_31

strata== 31.0000

strata_32

strata== 32.0000

strata_33

strata== 33.0000

strata_34

strata== 34.0000

strata_35

strata== 35.0000

strata_36

strata== 36.0000

strata_37

strata== 37.0000

strata_38

strata== 38.0000

strata_39

strata== 39.0000

strata_40

strata== 40.0000

strata_41

strata== 41.0000

strata_42

strata== 42.0000

strata_43

strata== 43.0000

strata_44

strata== 44.0000

strata_45

strata== 45.0000

strata_46

strata== 46.0000

int_female_BR

Interaction between Treatment 1: BRC * female

int_female_BR_TPIN

Interaction between Treatment 2: BRC + TPIN * female

int_female_BR_Bank

Interaction between Treatment 3: BRCE + IS + BBA * female

int_city_BR

Interaction between Treatment 1: BRC * city

int_city_BR_TPIN

Interaction between Treatment 2: BRC + TPIN * city

int_city_BR_Bank

Interaction between Treatment 3: BRCE + IS + BBA * city

brc_tpin

Firms that accepted and received BRC AND TPIN

reasonBRCnot_combined

reasonBRCnot_combined1

reasonBRCnot_combined==Already registered

reasonBRCnot_combined2

reasonBRCnot_combined==Neeeded to consult spouse

reasonBRCnot_combined3

reasonBRCnot_combined==Failed to locate/closed/moved

reasonBRCnot_combined4

reasonBRCnot_combined==Refusal

reasonBRCnot_combined5

reasonBRCnot_combined==No info on reason

reasonBRCnot_combined6

reasonBRCnot_combined==Accepted registration

freasonBRCnot_combined

reasonBRCnot_combined -followup-

freasonBRCnot_combined1

reasonBRCnot_combined==Already registered -followup-

freasonBRCnot_combined2

reasonBRCnot_combined==Neeeded to consult spouse -followup-

freasonBRCnot_combined3

reasonBRCnot_combined==Failed to locate/closed/moved -followup-

freasonBRCnot_combined4

reasonBRCnot_combined==Refusal -followup-

freasonBRCnot_combined5

reasonBRCnot_combined==No info on reason -followup-

freasonBRCnot_combined6

reasonBRCnot_combined==Accepted registration -followup-

has_BRC

1= Has BRC at baseline

has_TPIN

1= Has TPIN at baseline

has_city_council

1= Has city council license at baseline

Total_workers2

Number of people working in business

Business_owner

Number of owners

Financial_knowledge

Financial Literacy knowledge (0-1)

Revenue_lastmonth

Revenue last month (MWK) at baseline

Revenue_lastweek

Revenue last week (MWK) at baseline

Revenue_lastmonth99

Revenue last month winsorized at 99th percentile (MWK) at baseline

Revenue_lastweek99

Revenue last week winsorized at 99th percentile (MWK) at baseline

ihst_Revenue_lastmonth

Revenue last month inverse hyperbolic sine transformation (MWK)

Profit_lastmonth

Profit last month (MWK) at baseline

Profit_lastweek

Profit last week (MWK) at baseline

Profit_lastmonth99

Profit last month winsorized at 99th percentile (MWK) at baseline

Profit_lastweek99

Profit last week winsorized at 99th percentile (MWK) at baseline

ihst_Profit_lastmonth

Profit last month inverse hyperbolic sine transformation (MWK)

number_days_workmonth

Number of days in a work month at baseline

capital

Capital (MWK): Fixed Assets at baseline

assets

Assets (MWK): Fixed Assets + Inventories + Cash at baseline

propmaleworkers

Proportion of male workers at baseline

borrowed_in_past

Borrowed in the past at baseline

amount_recentloan

Amount recent loan (MWK) at baseline

any_account

Has any account at baseline

banks_any_account

Has bank account at baseline

banksonly_bus_account

Has bank account in name of business at baseline

account_used_only_business

Uses any account just for business purposes at baseline

save_home

1= Saves at home at baseline

rosca_sacco

1= saves at ROSCA_SACCO at baseline

banks_saving

1= Banks savings at baseline

saved_amount

Saved amount (MWK) at baseline

saved_amount99

Saved amount winsorized at 99th percentile (MWK) at baseline

saved_amount_bank

Saved amount at bank (MWK) at baseline

mix_bus_hh

1= Takes business money whenever for HH at baseline

bank_loan

1= Has a bank loan at baseline

benefits_reg

Identifies benefit(s) of business registration at baseline

inspected_municipality

1= Has been inspected by municipality before at baseline

Asked_for_bribe

1= Asked for bribe before at baseline

threats_to_shutdown

1= Has received threats to shutdown at baseline

confiscation

1= Has received threats to confiscation at baseline

sexually_harassed

1= Has been sexually harassed at baseline

other_harassment

1= Has received other harassment at baseline

receipt

1= Provides receipts at baseline

num_customers

Number of customers at baseline

chamber

1= Belongs to Malawian Chamber of Commerce at baseline

export_license

1= Has export license at baseline

tender

1= Tender at baseline

changes_location

1= Location of the business has changed at baseline

loan_can_raise

Amount that business can borrow in 2 weeks (MWK) at baseline

insurance

1= Has insurance for businessat baseline

budget

1= Has written a budget at baseline

financial_records

1= Keeps financial records at baseline

advert

1= Advertises at baseline

other_activity

Other business activity

contact_bank

1= Bank has contacted business at baseline

paidcitycouncilmktfee

1= Business pay city council market fee at baseline

taxescosts

Taxes costs (MWK) at baseline

t_courts

1= Trust in courts at baseline

t_police

1= Trust in police at baseline

t_govern

1= Trust in government at baseline

t_city_council

1= Trust in city council at baseline

Total: 514

1 2 >

Back to Catalog