Data for Shortening Supply Chains: Experimental Evidence from Fruit and Vegetable Vendors in Bogota 2016-2018

Colombia, 2016 - 2018

Get Microdata

Reference ID

COL_2016-2018_IPMC_v01_M

Producer(s)

David McKenzie

Metadata

DDI/XML JSON

Created on

Jan 16, 2021

Last modified

Jan 16, 2021

Page views

21446

Downloads

463

Data file: agruppa_baseline_NOPII

Baseline data on 2685 firms
Corresponding questionnaire - Baseline Survey

Cases:	2685
Variables:	630

Variables

id1

1001) Enumerator: What is the business ID1?

enumeratorid

ID of Enumerator

census

1004) Enumerator: Is this business from the original Agruppa census?

block

1006) Enumerator: What is the business block?

safeblock

Block identified as not safe during data collection. These blocks are not consid

pair

Pair according to random assignment

treat

Treatment variable according to random assignment

nid

Nearest neighbor business

mt_to_nid

Distance (in meters) to nearest neighbor business

dist_corab_mt

Distance (in meters) to Corabastos

dist_corab_mt2

Distance (in meters) from center of the block to Corabastos

bstatus

1011) Enumerator: The business status is...

btype

1012) Enumerator: This business is a...

fruitsveg

1013) Enumerator: Does the business sell fruits and vegetables?

consent1

1014) Enumerator: Does the person give consent to answer the preliminary questio

agruppa_prods

1015) Does your business sell at least one of the following products? Onion cabe

business_owner

1016) Are you the business owner?

business_owner_rel

1016-1) What is your relationship with the business owner?

business_owner_rel_oth

1016-1-1) What is your relationship with the business owner? (other)

decides_prices

1017) Are you the person that decides the prices of the fruits and vegetables so

decides_prices_present

1017-2) Is the person that decides the prices of the fruits and vegetables prese

decides_prices_talk

1017-3) Can we talk to the person that decides the prices of the fruits and vege

person_in_charge

1018) Are you the business manager?

decides_hours

1019) Who is in charge of deciding the business hours?

decides_sales

1020) Who is in charge of deciding which fruits and vegetables are sold?

shopper

1021) Who is usually in charge of purchasing the fruits and vegetables?

shopper_last

1022) Who purchased the fruits and vegetables the last time, not considering tod

decides_purch

1023) Who is in charge of deciding which fruits and vegetables are purchased?

consent2

1024) Enumerator: Does the person give consent to participate in the survey?

sex

2001) Enumerator: What is the respondent's sex?

age

2003) What is your age?

location_h

2007) Your household is located...

neighborhood_h

2007-2) What is the neighborhood where your household is located?

educ_level

2008) What is the highest education level you have achieved and certified?

2009) How many people live in your household (not including you)?

hh_child

2009-1) How many of these N people are less than 18 years old?

hh_child_own

2009-1-1) How many of these N children are yours?

income_main

2010) Is this business the main source of income for your household?

income_oth

2010-1) Does your household have other source(s) of income besides this business

range_inc_mth

2011) Within these ranges, how much was your household's income the past month?

inc_mth

2011-1) Approximately, how much was your household's income the past month?

cebca

3001) During the past week, did you sell onion cabezona?

cebla

3002) During the past week, did you sell onion larga?

platpri

3003) During the past week, did you sell plantain primera?

platseg

3004) During the past week, did you sell plantain segunda?

platpic

3005) During the past week, did you sell plantain pica?

pastusa

3006) During the past week, did you sell potato pastusa (gruesa or pareja)?

superior

3007) During the past week, did you sell potato superior (gruesa or pareja)?

suprema

3008) During the past week, did you sell potato suprema (gruesa or pareja)?

chonto

3009) During the past week, did you sell tomato chonto (semi or grueso)?

largavida

3010) During the past week, did you sell tomato largavida (semi or grueso)?

other_prods

3011) During the past week, did you sell other products besides fruits and veget

cat_grains

3011-1) During the past week, did you sell grains?

cat_cons

3011-2) During the past week, did you sell conserves?

cat_dairy

3011-3) During the past week, did you sell dairy?

cat_sweets

3011-4) During the past week, did you sell sweets?

cat_finalprod

3011-5) During the past week, did you sell finished products?

cat_eggs

3011-6) During the past week, did you sell eggs?

cat_meat

3011-7) During the past week, did you sell meat?

cat_snack

3011-8) During the past week, did you sell snacks?

cat_dried_f

3011-9) During the past week, did you sell dried fruits?

cat_bread

3011-10) During the past week, did you sell bread?

cat_spices

3011-11) During the past week, did you sell spices?

cat_soda

3011-12) During the past week, did you sell soda?

cat_alcohol

3011-13) During the past week, did you sell alcohol?

cat_hhclean

3011-14) During the past week, did you sell house cleaning products?

cat_persclean

3011-15) During the past week, did you sell personal care products?

cat_mins

3011-16) During the past week, did you sell airtime?

cat_oth

3011-17) During the past week, did you sell other products?

cat_oth_det

3011-17-1) During the past week, did you sell other products (other)?

prod_first

3011-18) During the past week, which was the product that you sold the most from

prod_sec

3011-19) During the past week, which was the product that you sold the most from

prod_third

3011-20) During the past week, which was the product that you sold the most from

yearsworked

3012) How long have you been working in this business for?

yearsworked_range

3012-1) Within these ranges, how long have you been working in this business for

yearsbusiness

3013) How long has this business existed?

yearsbusiness_range

3013-1) Within these ranges, how long has this business existed?

chambercommerce

3014) Is this business registered in the Chamber of Commerce?

dian

3015) Is this business registered in the DIAN (National Department of Taxes and

open

3016) During the past week, was the business open every day, including Saturday

open_mon

3016-1) During the past week, which days was your business open? (Monday)

open_tue

3016-2) During the past week, which days was your business open? (Tuesday)

open_wed

3016-3) During the past week, which days was your business open? (Wednesday)

open_thu

3016-4) During the past week, which days was your business open? (Thursday)

open_fri

3016-5) During the past week, which days was your business open? (Friday)

open_sat

3016-6) During the past week, which days was your business open? (Saturday)

open_sun

3016-7) During the past week, which days was your business open? (Sunday)

open_same_h

3017) During the past week, the business opened and closed at the same hours?

close_lunch

3018) During the past week, was the business close during lunch time?

open_mor

3019) During the past week, at what time did the business open?

close_aft

3020) During the past week, at what time did the business close?

open_mor_lunch

3021) During the past week, at what time did the business open?

close_mor_lunch

3022) During the past week, at what time did the business close before lunch tim

open_aft_lunch

3023) During the past week, at what time did the business open after lunch time?

close_aft_lunch

3024) During the past week, at what time did the business close?

open_mor_mon

3025) During the past week, at what time did the business open on Monday?

close_aft_mon

3026) During the past week, at what time did the business close on Monday?

open_mor_tue

3027) During the past week, at what time did the business open on Tuesday?

close_aft_tue

3028) During the past week, at what time did the business close on Tuesday?

open_mor_wed

3029) During the past week, at what time did the business open on Wednesday?

close_aft_wed

3030) During the past week, at what time did the business close on Wednesday?

open_mor_thu

3031) During the past week, at what time did the business open on Thursday?

close_aft_thu

3032) During the past week, at what time did the business close on Thursday?

open_mor_fri

3033) During the past week, at what time did the business open on Friday?

close_aft_fri

3034) During the past week, at what time did the business close on Friday?

open_mor_sat

3035) During the past week, at what time did the business open on Saturday?

close_aft_sat

3036) During the past week, at what time did the business close on Saturday?

open_mor_sun

3037) During the past week, at what time did the business open on Sunday?

close_aft_sun

3038) During the past week, at what time did the business close on Sunday?

open_mon_mor_lunch

3039) During the past week, at what time did the business open on Monday?

close_mon_mor_lunch

3040) During the past week, at what time did the business close on Monday before

open_mon_aft_lunch

3041) During the past week, at what time did the business open on Monday after l

close_mon_aft_lunch

3042) During the past week, at what time did the business close on Monday?

open_tue_mor_lunch

3043) During the past week, at what time did the business open on Tuesday?

close_tue_mor_lunch

3044) During the past week, at what time did the business close on Tuesday befor

open_tue_aft_lunch

3045) During the past week, at what time did the business open on Tuesday after

close_tue_aft_lunch

3046) During the past week, at what time did the business close on Tuesday?

open_wed_mor_lunch

3047) During the past week, at what time did the business open on Wednesday?

close_wed_mor_lunch

3048) During the past week, at what time did the business close on Wednesday bef

open_wed_aft_lunch

3049) During the past week, at what time did the business open on Wednesday afte

close_wed_aft_lunch

3050) During the past week, at what time did the business close on Wednesday?

open_thu_mor_lunch

3051) During the past week, at what time did the business open on Thursday?

close_thu_mor_lunch

3052) During the past week, at what time did the business close on Thursday befo

open_thu_aft_lunch

3053) During the past week, at what time did the business open on Thursday after

close_thu_aft_lunch

3054) During the past week, at what time did the business close on Thursday?

open_fri_mor_lunch

3055) During the past week, at what time did the business open on Friday?

close_fri_mor_lunch

3056) During the past week, at what time did the business close on Friday before

open_fri_aft_lunch

3057) During the past week, at what time did the business open on Friday after l

close_fri_aft_lunch

3058) During the past week, at what time did the business close on Friday?

open_sat_mor_lunch

3059) During the past week, at what time did the business open on Saturday?

close_sat_mor_lunch

3060) During the past week, at what time did the business close on Saturday befo

open_sat_aft_lunch

3061) During the past week, at what time did the business open on Saturday after

close_sat_aft_lunch

3062) During the past week, at what time did the business close on Saturday?

open_sun_mor_lunch

3063) During the past week, at what time did the business open on Sunday?

close_sun_mor_lunch

3064) During the past week, at what time did the business close on Sunday before

open_sun_aft_lunch

3065) During the past week, at what time did the business open on Sunday after l

close_sun_aft_lunch

3066) During the past week, at what time did the business close on Sunday?

hours_open_week

Number of hours the business was open during the week

shopbefore

3067) Do you always purchase the fruits and vegetables before coming to the busi

transport

3067-1)On the days you don't go to purchase..

transport_oth

3067-1-1) On the days you don't go to purchase..

transp_minutes

3067-2) How much time do you spend coming from your home to the business?

transport_dir

3068) Let's suppose that instead of going to shop before, you would go directly

transpdir_minutes

3068-1) How much time do you think would take you to go from your home to the bu

time_saved

3069) If you could save time in activities such as transportation or going to pu

open_more_mor

3069-1) How would you change the business hours?: by opening the business early

open_more_night

3069-2) How would you change the business hours?: by closing the business later

open_more_mor_purc

3069-2) How would you change the business hours?: by opening earlier the days yo

no_close_lunch

3069-2) How would you change the business hours?: by stop closing during lunch

employees

3070) During the past week, did anybody else work with you in the business?

paid

3070-1) How many of these employees were paid?

not_paid

3070-2) How many of these employees were unpaid?

talk_vend

3071) During the past week, with how many vendors similar to you did you talk?

relation_vend

3072) Overall, with how many vendors similar to you do you have some kind of rel

market_bprices

3073) Do you know at which price does the nearest shop purchase the fruits and v

market_sprices

3074) Do you know at which price does the nearest shop sell the fruits and veget

add_amount

3075-1) When deciding the sale price of the fruits and vegetables/products, do y

add_percentage

3075-2) When deciding the sale price of the fruits and vegetables/products, do y

price_lower_comp

3075-3) When deciding the sale price of the fruits and vegetables/products, do y

same_price

3075-4) When deciding the sale price of the fruits and vegetables/products, do y

otherway_setp

3075-5) Do you have other way to decide the sale price of the fruits and vegetab

otherway_setp_det

Please specify the way used by the vendor to set the prices

amount_added

3076) Approximately, how much amount do you add?

percentage_added

3077) Approximately, how much percentage did you add?

freq_price_set

3078) How frequently do you change the sale price of your products?

charge_price

3079) Which of these options describes best the way you generally decide the sal

day_sales

3080) Generally, what day of the week do you sell the most?

advertising

3081) During the past six months, have you made any kind of advertisement?

flyer

3081-1) Which kind of advertisement have you made?: flyers

ad_com_event

3081-2) Which kind of advertisement have you made?: paying advertisement in publ

yell_pgs

3081-3) Which kind of advertisement have you made?: yellow pages

diaries

3081-4) Which kind of advertisement have you made?: newspapers

billboard

3081-5) Which kind of advertisement have you made?: billboards

ad_calls

3081-6) Which kind of advertisement have you made?: telemarketing

ad_calendar

3081-7) Which kind of advertisement have you made?: calendars

changed_ad

3081-8) Which kind of advertisement have you made?: a new sign for your business

ad_oth

3081-9) Which kind of advertisement have you made?: other kind of advertisement

ad_oth_det

3081-9-1) Which kind of advertisement have you made?: (other)

record_p

4001) Do you keep records of the purchase price of each product?

freq_record_p

4001-1) How frequently do you keep records of the purchase prices?

how_record_p

4001-2) How do you take these records of the purchase prices?

record_q

4002) Do you keep records of the purchased quantities of each product?

freq_record_q

4002-1) How frequently do you keep records of the purchased quantities?

how_record_q

4002-2) How do you take these records of the purchased quantities?

record_psell

4003) Do you keep records of the sale price of each product?

freq_record_psell

4003-1) How frequently do you keep records of the sale prices?

how_record_psell

4003-2) How do you take these records of the sale prices?

record_qsell

4004) Do you keep records of the sold quantities of each product?

freq_record_qsell

4004-1) How frequently do you keep records of the sold quantities?

how_record_qsell

4004-2) How do you take these records of the sold quantities?

record_sales

4005) Do you keep records on the money that you receive by sales?

freq_record_sales

4005-1) How frequently do you keep records on the money received by sales?

how_record_sales

4005-2) How do you take these records of the money received by sales?

notes_record

4006) Enumerator: Provide comments if the vendor shows you some notes, notebook

range_sales_yest

4007) Within these ranges, how much money did you received from sales yesterday?

sales_yest

4007-1) Approximately, how much money did you received from sales yesterday?

range_sales_week

4008) Within these ranges, how much money did you received from sales the past w

sales_week

4008-1) Approximately, how much money did you received from sales the past week?

range_sales_mth

4009) Within these ranges, how much money did you received from sales the past m

sales_mth

4009-1) Approximately, how much money did you received from sales the past month

had_profit_week

4010) Did your business had profits the past week?

range_profits_week

4010-1) Within these ranges, how much were the profits of the business the past

profits_week

4010-1-1) Approximately, how much were the profits of the business the past week

had_profit_mth

4011) Did your business had profits the past month?

range_profits_mth

4011-1) Within these ranges, how much were the profits of the business the past

profits_mth

4011-1-1) Approximately, how much were the profits of the business the past mont

total_expenses

4012) Approximately, how much were the business expenses the past month?

buy_tosell

4013) How much were the costs during the past month regarding the purchase of th

services

4014) How much were the costs during the past month regarding the public service

gas

4015) How much were the costs during the past month regarding transportation?

salaries

4016) How much were the costs during the past month regarding wages?

rent

4017) How much were the costs during the past month regarding shop rent?

tax_chamber

4018) How much were the costs during the past month regarding business taxes?

rent_equip

4019) How much were the costs during the past month regarding machinery leasing?

serv_phone

4020) How much were the costs during the past month regarding phone service?

total_exp

4021) How much was the sum of all the costs?

sold_cebca

5001) Did you sell onion cabezona yesterday?

daysb_cebca

5001-1) When was the last time you purchased onion cabezona, not considering tod

buy_cebca

5001-2) Where did you purchase onion cabezona the last time?

buy_cebca_oth

5001-2-1) Where did you purchase onion cabezona the last time (other)?

pb_cebca

5001-3) What was the purchase price of onion cabezona the last time?

pb_unit_cebca

5001-3-1) Measurement unit for the purchase price of onion cabezona

pb_cebca_kg

Purchase price per kilogram of onion cabezona

qb_cebca

5001-4) How much onion cabezona did you purchase the last time?

qb_unit_cebca

5001-4-1) Measurement unit for the purchased quantity of onion cabezona

qb_cebca_kg

Purchased quantity (kilograms) of onion cabezona the last time

paid_total_cebca

5001-5) How much did you pay for the onion cabezona the last time?

ps_cebca

5001-6) Yesterday, what was the sale price of onion cabezona?

ps_unit_cebca

5001-6-1) Measurement unit for the sale price of onion cabezona

ps_cebca_kg

Sale price per kilogram of onion cabezona

qs_cebca

5001-7) Yesterday, how much onion cabezona did you sell?

qs_unit_cebca

5001-7-1) Measurement unit for the sold quantity of onion cabezona

qs_cebca_kg

Sold quantity (kilograms) of onion cabezona yesterday

see_cebca

5001-8) Could I see a onion cabezona?

firm_cebca

5001-8-1) Is the onion cabezona firm to the touch?

color_cebca

5001-8-2) Does the onion cabezona have the right color?

def_cebca

5001-8-3) Is the onion cabezona faulty?

form_cebca

5001-8-4) Is the shape of the onion cabezona appropriate?

sold_cebla

5002) Did you sell onion larga yesterday?

daysb_cebla

5002-1) When was the last time you purchased onion larga, not considering today?

buy_cebla

5002-2) Where did you purchase onion larga the last time?

buy_cebla_oth

5002-2-1) Where did you purchase onion larga the last time (other)?

pb_cebla

5002-3) What was the purchase price of onion larga the last time?

pb_unit_cebla

5002-3-1) Measurement unit for the purchase price of onion larga

pb_cebla_kg

Purchase price per kilogram of onion larga

qb_cebla

5002-4) How much onion larga did you purchase the last time?

qb_unit_cebla

5002-4-1) Measurement unit for the purchased quantity of onion larga

qb_cebla_kg

Purchased quantity (kilograms) of onion larga the last time

paid_total_cebla

5002-5) How much did you pay for the onion larga the last time?

ps_cebla

5002-6) Yesterday, what was the sale price of onion larga?

ps_unit_cebla

5002-6-1) Measurement unit for the sale price of onion larga

ps_cebla_kg

Sale price per kilogram of onion larga

qs_cebla

5002-7) Yesterday, how much onion larga did you sell?

qs_unit_cebla

5002-7-1) Measurement unit for the sold quantity of onion larga

qs_cebla_kg

Sold quantity (kilograms) of onion larga yesterday

see_cebla

5002-8) Could I see a onion larga?

firm_cebla

5002-8-1) Is the onion larga firm to the touch?

color_cebla

5002-8-2) Does the onion larga have the right color?

def_cebla

5002-8-3) Is the onion larga faulty?

form_cebla

5002-8-4) Is the shape of the onion larga appropriate?

sold_platpri

5003) Did you sell plantain primera yesterday?

daysb_platpri

5003-1) When was the last time you purchased plantain primera, not considering t

buy_platpri

5003-2) Where did you purchase plantain primera the last time?

buy_platpri_oth

5003-2-1) Where did you purchase plantain primera the last time (other)?

pb_platpri

5003-3) What was the purchase price of plantain primera the last time?

pb_unit_platpri

5003-3-1) Measurement unit for the purchase price of plantain primera

pb_platpri_kg

Purchase price per kilogram of plantain primera

qb_platpri

5003-4) How much plantain primera did you purchase the last time?

qb_unit_platpri

5003-4-1) Measurement unit for the purchased quantity of plantain primera

qb_platpri_kg

Purchased quantity (kilograms) of plantain primera the last time

paid_total_platpri

5003-5) How much did you pay for the plantain primera the last time?

ps_platpri

5003-6) Yesterday, what was the sale price of plantain primera?

ps_unit_platpri

5003-6-1) Measurement unit for the sale price of plantain primera

ps_platpri_kg

Sale price per kilogram of plantain primera

qs_platpri

5003-7) Yesterday, how much plantain primera did you sell?

qs_unit_platpri

5003-7-1) Measurement unit for the sold quantity of plantain primera

qs_platpri_kg

Sold quantity (kilograms) of plantain primera yesterday

see_platpri

5003-8) Could I see a plantain primera?

firm_platpri

5003-8-1) Is the plantain primera firm to the touch?

color_platpri

5003-8-2) Does the plantain primera have the right color?

def_platpri

5003-8-3) Is the plantain primera faulty?

form_platpri

5003-8-4) Is the shape of the plantain primera appropriate?

sold_platseg

5004) Did you sell plantain segunda yesterday?

daysb_platseg

5004-1) When was the last time you purchased plantain segunda, not considering t

buy_platseg

5004-2) Where did you purchase plantain segunda the last time?

buy_platseg_oth

5004-2-1) Where did you purchase plantain segunda the last time (other)?

pb_platseg

5004-3) What was the purchase price of plantain segunda the last time?

pb_unit_platseg

5004-3-1) Measurement unit for the purchase price of plantain segunda

pb_platseg_kg

Purchase price per kilogram of plantain segunda

qb_platseg

5004-4) How much plantain segunda did you purchase the last time?

qb_unit_platseg

5004-4-1) Measurement unit for the purchased quantity of plantain segunda

qb_platseg_kg

Purchased quantity (kilograms) of plantain segunda the last time

paid_total_platseg

5004-5) How much did you pay for the plantain segunda the last time?

ps_platseg

5004-6) Yesterday, what was the sale price of plantain segunda?

ps_unit_platseg

5004-6-1) Measurement unit for the sale price of plantain segunda

ps_platseg_kg

Sale price per kilogram of plantain segunda

qs_platseg

5004-7) Yesterday, how much plantain segunda did you sell?

qs_unit_platseg

5004-7-1) Measurement unit for the sold quantity of plantain segunda

qs_platseg_kg

Sold quantity (kilograms) of plantain segunda yesterday

see_platseg

5004-8) Could I see a plantain segunda?

Total: 630

1 2 3 >

Back to Catalog