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

22761

Downloads

474

Data file: agruppa_fu12_NOPII

12 month follow-up data on 1791 firms
Corresponding questionnaire - FU12 Survey

Cases:	1791
Variables:	497

Variables

id1

1001) Enumerator: What is the business ID1?

enumeratorid

ID of enumerator

business_photo

1004) Enumerator: Use the following information to validate that you are in the

block

1006) Enumerator: What is the business block?

pair

Pair according to random assignment

treat

Treatment variable according to random assignment

bstatus

1011) Enumerator: The business status is...

fruitsveg

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

consent

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

business_owner

1014) Are you the business owner?

decides_prices

1015) Are you the person that decides the prices of the fruits and vegetables/pr

person_in_charge

1016) Are you the business manager?

decides_sales

1017) Are you the person that decides which fruits and vegetables/products are s

knowpb_fv

1018) Do you know the purchase prices of the fruits and vegetables sold in the b

knowpb_prod

1019) Do you know the purchase prices of the products sold in the business?

knowpb_present

1019-2) Is the person with knowledge on the purchase prices present?

knowpb_talk

1019-2-1) Can we talk to the person with knowledge on the purchase prices?

sex

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

age

2003) What is your age?

socio_status

2004) What is the socioeconomic stratum of your dwelling?

sisben_mfa

2005-1) Are you beneficiary of the program Ma¡s Familias en Acción?

sisben_ja

2005-2) Are you beneficiary of the program Jóvenes en Acción?

sisben_prinf

2005-3) Are you beneficiary of the program Primera Infancia?

sisben_regsub

2005-4) Are you beneficiary of the program Regimen Subsidiado?

sisben_acces

2005-5) Are you beneficiary...

sisben_ppsam

2005-6) Are you beneficiary...

sisben_beps

2005-7) Are you beneficiary...

sisben_benef

2006) Are you beneficiary of SISBEN?

sisben_score

2006-1) What is your SISBEN score?

sisben_level

2006-1-1) What is your SISBEN level?

sold_banana

3001-1) Did you sell banana yesterday?

sold_bean

3001-2) Did you sell bean yesterday?

sold_coriander

3001-3) Did you sell coriander yesterday?

sold_hbean

3001-4) Did you sell green bean yesterday?

sold_guava

3001-5) Did you sell guava yesterday?

sold_lemon

3001-6) Did you sell lemon yesterday?

sold_lulo

3001-7) Did you sell lulo yesterday?

sold_orange

3001-8) Did you sell orange yesterday?

sold_pfruit

3001-9) Did you sell passion fruit yesterday?

sold_platpic

3001-10) Did you sell plantain pica yesterday?

sold_platseg

3001-11) Did you sell pantain segunda yesterday?

sold_superiorp

3001-12) Did you sell potato superior pareja yesterday?

sold_pastusap

3001-13) Did you sell potato pastusa pareja yesterday?

sold_superiorg

3001-14) Did you sell potato superior gruesa yesterday?

sold_supremag

3001-15) Did you sell potato suprema gruesa yesterday?

sold_supremap

3001-16) Did you sell potato suprema pareja yesterday?

sold_tangerine

3001-17) Did you sell tangerine yesterday?

sold_chontog

3001-18) Did you sell tomato chonto grueso yesterday?

sold_ttomato

3001-19) Did you sell tree tomato yesterday?

total_prods

Total number of Agruppa products sold yesterday

percent_fv

3002) During the past week, what percentage of your total sales corresponded to

share_fv

3003) What percentage of your total sales of fruits and vegetables yesterday cor

otherprod_1

3004-1) Which other fruits and vegetables did you sell, besides these N products

otherprod_2

3004-2) Which other fruits and vegetables did you sell, besides these N products

sold_carrot

3005) Did you sell carrot yesterday?

daysb_carrot

3005-1) When was the last time you purchased carrot, not considering today?

buy_carrot

3005-2) Where did you purchase carrot the last time?

buy_carrot_oth

3005-2-1) Where did you purchase carrot the last time (other)?

pb_carrot

3005-3) What was the purchase price of carrot the last time?

pb_unit_carrot

3005-3-1) Measurement unit for the purchase price of carrot

pb_carrot_kg

Purchase price per kilogram of carrot

qb_carrot

3005-4) How much carrot did you purchase the last time?

qb_unit_carrot

3005-4-1) Measurement unit for the purchased quantity of carrot

qb_carrot_kg

Purchased quantity (kilograms) of carrot the last time

paid_total_carrot

3005-5) How much did you pay for the carrot the last time?

ps_carrot

3005-6) Yesterday, what was the sale price of carrot?

ps_unit_carrot

3005-6-1) Measurement unit for the sale price of carrot

ps_carrot_kg

Sale price per kilogram of carrot

qs_carrot

3005-7) Yesterday, how much carrot did you sell?

qs_unit_carrot

3005-7-1) Measurement unit for the sold quantity of carrot

qs_carrot_kg

Sold quantity (kilograms) of carrot yesterday

see_carrot

3005-8) Could I see a carrot?

firm_carrot

3005-8-1) Is the carrot firm to the touch?

color_carrot

3005-8-2) Does the carrot have the right color?

def_carrot

3005-8-3) Is the carrot faulty?

form_carrot

3005-8-4) Is the shape of the carrot appropriate?

sold_cebca

3006) Did you sell onion cabezona yesterday?

daysb_cebca

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

buy_cebca

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

buy_cebca_oth

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

pb_cebca

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

pb_unit_cebca

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

pb_cebca_kg

Purchase price per kilogram of onion cabezona

qb_cebca

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

qb_unit_cebca

3006-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

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

ps_cebca

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

ps_unit_cebca

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

ps_cebca_kg

Sale price per kilogram of onion cabezona

qs_cebca

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

qs_unit_cebca

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

qs_cebca_kg

Sold quantity (kilograms) of onion cabezona yesterday

see_cebca

3006-8) Could I see a onion cabezona?

firm_cebca

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

color_cebca

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

def_cebca

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

form_cebca

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

sold_cebla

3007) Did you sell onion larga yesterday?

daysb_cebla

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

buy_cebla

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

buy_cebla_oth

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

pb_cebla

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

pb_unit_cebla

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

pb_cebla_kg

Purchase price per kilogram of onion larga

qb_cebla

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

qb_unit_cebla

3007-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

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

ps_cebla

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

ps_unit_cebla

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

ps_cebla_kg

Sale price per kilogram of onion larga

qs_cebla

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

qs_unit_cebla

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

qs_cebla_kg

Sold quantity (kilograms) of onion larga yesterday

see_cebla

3007-8) Could I see a onion larga?

firm_cebla

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

color_cebla

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

def_cebla

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

form_cebla

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

sold_pea

3008) Did you sell pea yesterday?

daysb_pea

3008-1) When was the last time you purchased pea, not considering today?

buy_pea

3008-2) Where did you purchase pea the last time?

buy_pea_oth

3008-2-1) Where did you purchase pea the last time (other)?

pb_pea

3008-3) What was the purchase price of pea the last time?

pb_unit_pea

3008-3-1) Measurement unit for the purchase price of pea

pb_pea_kg

Purchase price per kilogram of pea

qb_pea

3008-4) How much pea did you purchase the last time?

qb_unit_pea

3008-4-1) Measurement unit for the purchased quantity of pea

qb_pea_type

3008-4-2) Did you buy the pea with or without their shell?

qb_pea_kg

Purchased quantity (kilograms) of pea the last time

paid_total_pea

3008-5) How much did you pay for the pea the last time?

ps_pea

3008-6) Yesterday, what was the sale price of pea?

ps_unit_pea

3008-6-1) Measurement unit for the sale price of pea

ps_pea_kg

Sale price per kilogram of pea

qs_pea

3008-7) Yesterday, how much pea did you sell?

qs_unit_pea

3008-7-1) Measurement unit for the sold quantity of pea

qs_pea_type

3008-7-2) Did you sell the pea with or without their shell?

qs_pea_kg

Sold quantity (kilograms) of pea yesterday

see_pea

3008-8) Could I see a pea?

firm_pea

3008-8-1) Is the pea firm to the touch?

color_pea

3008-8-2) Does the pea have the right color?

def_pea

3008-8-3) Is the pea faulty?

form_pea

3008-8-4) Is the shape of the pea appropriate?

sold_platpri

3009) Did you sell plantain primera yesterday?

daysb_platpri

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

buy_platpri

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

buy_platpri_oth

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

pb_platpri

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

pb_unit_platpri

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

pb_platpri_kg

Purchase price per kilogram of plantain primera

qb_platpri

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

qb_unit_platpri

3009-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

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

ps_platpri

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

ps_unit_platpri

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

ps_platpri_kg

Sale price per kilogram of plantain primera

qs_platpri

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

qs_unit_platpri

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

qs_platpri_kg

Sold quantity (kilograms) of plantain primera yesterday

see_platpri

3009-8) Could I see a plantain primera?

firm_platpri

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

color_platpri

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

def_platpri

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

form_platpri

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

sold_pastusag

3010) Did you sell potato pastusa gruesa yesterday?

daysb_pastusag

3010-1) When was the last time you purchased potato pastusa gruesa, not consider

buy_pastusag

3010-2) Where did you purchase potato pastusa gruesa the last time?

buy_pastusag_oth

3010-2-1) Where did you purchase potato pastusa gruesa the last time (other)?

pb_pastusag

3010-3) What was the purchase price of potato pastusa gruesa the last time?

pb_unit_pastusag

3010-3-1) Measurement unit for the purchase price of potato pastusa gruesa

pb_pastusag_kg

Purchase price per kilogram of potato pastusa gruesa

qb_pastusag

3010-4) How much potato pastusa gruesa did you purchase the last time?

qb_unit_pastusag

3010-4-1) Measurement unit for the purchased quantity of potato pastusa gruesa

qb_pastusag_kg

Purchased quantity (kilograms) of potato pastusa gruesa the last time

paid_total_pastusag

3010-5) How much did you pay for the potato pastusa gruesa the last time?

ps_pastusag

3010-6) Yesterday, what was the sale price of potato pastusa gruesa?

ps_unit_pastusag

3010-6-1) Measurement unit for the sale price of potato pastusa gruesa

ps_pastusag_kg

Sale price per kilogram of potato pastusa gruesa

qs_pastusag

3010-7) Yesterday, how much potato pastusa gruesa did you sell?

qs_unit_pastusag

3010-7-1) Measurement unit for the sold quantity of potato pastusa gruesa

qs_pastusag_kg

Sold quantity (kilograms) of potato pastusa gruesa yesterday

see_pastusag

3010-8) Could I see a potato pastusa gruesa?

firm_pastusag

3010-8-1) Is the potato pastusa gruesa firm to the touch?

color_pastusag

3010-8-2) Does the potato pastusa gruesa have the right color?

def_pastusag

3010-8-3) Is the potato pastusa gruesa faulty?

form_pastusag

3010-8-4) Is the shape of the potato pastusa gruesa appropriate?

sold_chontos

3011) Did you sell tomato chonto semi yesterday?

daysb_chontos

3011-1) When was the last time you purchased tomato chonto semi, not considering

buy_chontos

3011-2) Where did you purchase tomato chonto semi the last time?

buy_chontos_oth

3011-2-1) Where did you purchase tomato chonto semi the last time (other)?

pb_chontos

3011-3) What was the purchase price of tomato chonto semi the last time?

pb_unit_chontos

3011-3-1) Measurement unit for the purchase price of tomato chonto semi

pb_chontos_kg

Purchase price per kilogram of tomato chonto semi

qb_chontos

3011-4) How much tomato chonto semi did you purchase the last time?

qb_unit_chontos

3011-4-1) Measurement unit for the purchased quantity of tomato chonto semi

qb_chontos_kg

Purchased quantity (kilograms) of tomato chonto semi the last time

paid_total_chontos

3011-5) How much did you pay for the tomato chonto semi the last time?

ps_chontos

3011-6) Yesterday, what was the sale price of tomato chonto semi?

ps_unit_chontos

3011-6-1) Measurement unit for the sale price of tomato chonto semi

ps_chontos_kg

Sale price per kilogram of tomato chonto semi

qs_chontos

3011-7) Yesterday, how much tomato chonto semi did you sell?

qs_unit_chontos

3011-7-1) Measurement unit for the sold quantity of tomato chonto semi

qs_chontos_kg

Sold quantity (kilograms) of tomato chonto semi yesterday

see_chontos

3011-8) Could I see a tomato chonto semi?

firm_chontos

3011-8-1) Is the tomato chonto semi firm to the touch?

color_chontos

3011-8-2) Does the tomato chonto semi have the right color?

def_chontos

3011-8-3) Is the tomato chonto semi faulty?

form_chontos

3011-8-4) Is the shape of the tomato chonto semi appropriate?

sold_yuca

3012) Did you sell yuca yesterday?

daysb_yuca

3012-1) When was the last time you purchased yuca, not considering today?

buy_yuca

3012-2) Where did you purchase yuca the last time?

buy_yuca_oth

3012-2-1) Where did you purchase yuca the last time (other)?

pb_yuca

3012-3) What was the purchase price of yuca the last time?

pb_unit_yuca

3012-3-1) Measurement unit for the purchase price of yuca

pb_yuca_kg

Purchase price per kilogram of yuca

qb_yuca

3012-4) How much yuca did you purchase the last time?

qb_unit_yuca

3012-4-1) Measurement unit for the purchased quantity of yuca

qb_yuca_kg

Purchased quantity (kilograms) of yuca the last time

paid_total_yuca

3012-5) How much did you pay for the yuca the last time?

ps_yuca

3012-6) Yesterday, what was the sale price of yuca?

ps_unit_yuca

3012-6-1) Measurement unit for the sale price of yuca

ps_yuca_kg

Sale price per kilogram of yuca

qs_yuca

3012-7) Yesterday, how much yuca did you sell?

qs_unit_yuca

3012-7-1) Measurement unit for the sold quantity of yuca

qs_yuca_kg

Sold quantity (kilograms) of yuca yesterday

see_yuca

3012-8) Could I see a yuca?

firm_yuca

3012-8-1) Is the yuca firm to the touch?

color_yuca

3012-8-2) Does the yuca have the right color?

def_yuca

3012-8-3) Is the yuca faulty?

form_yuca

3012-8-4) Is the shape of the yuca appropriate?

salescebca_low

3013) You told me you sold onion cabezona yesterday at (sale price in 3006-6).

elastcebca_low

3013-1) Remember that at a price of (sale price in 3006-6) you sold ________ (q

salescebca_high

3014) You told me you sold onion cabezona yesterday at (sale price in 3006-6).

elastcebca_high

3014-1) Remember that at a price of (sale price in 3006-6) you sold ________ (q

celasticitypotato_low

If you decrease the price of potato, you...(3015)

celasticitypotato_high

If you decrease the price of potato, you...(3016)

dif_elasticity

3017) Are your customers more price sensitive for some fruits and vegetables tha

prod_elasticity

3017-1) Which is the product that your customers would react the most if you cha

comp_d1jb

3018) Do you believe stores like D1 or Justo y Bueno represent some competition

hcomp_d1jb

3018-1) Which is the main way you compete with these shops (D1 and Justo y Bueno

other_prods

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

cat_grains

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

cat_cons

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

cat_dairy

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

cat_sweets

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

cat_finalprod

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

cat_eggs

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

cat_meat

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

cat_snack

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

cat_dried_f

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

cat_bread

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

cat_spices

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

cat_soda

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

cat_alcohol

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

cat_hhclean

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

cat_persclean

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

cat_mins

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

cat_oth

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

cat_oth_det

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

open

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

open_mon

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

open_tue

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

open_wed

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

open_thu

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

open_fri

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

open_sat

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

open_sun

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

changed_hours

4003) During the past six months, have you changed the business hours?

open_same_h

4003-1) During the past week, the business opened and closed at the same hours?

close_lunch

4003-2) During the past week, was the business close during lunch time?

open_mor

4003-3) During the past week, at what time did the business open?

close_aft

4003-4) During the past week, at what time did the business close?

open_mor_lunch

4003-5) During the past week, at what time did the business open?

close_mor_lunch

4003-6) During the past week, at what time did the business close before lunch t

open_aft_lunch

4003-7) During the past week, at what time did the business open after lunch tim

close_aft_lunch

4003-8) During the past week, at what time did the business close?

open_mor_mon

4003-9) During the past week, at what time did the business open on Monday?

close_aft_mon

4003-10) During the past week, at what time did the business close on Monday?

open_mor_tue

4003-11) During the past week, at what time did the business open on Tuesday?

close_aft_tue

4003-12) During the past week, at what time did the business close on Tuesday?

open_mor_wed

4003-13) During the past week, at what time did the business open on Wednesday?

close_aft_wed

4003-14) During the past week, at what time did the business close on Wednesday?

open_mor_thu

4003-15) During the past week, at what time did the business open on Thursday?

close_aft_thu

4003-16) During the past week, at what time did the business close on Thursday?

open_mor_fri

4003-17) During the past week, at what time did the business open on Friday?

close_aft_fri

4003-18) During the past week, at what time did the business close on Friday?

open_mor_sat

4003-19) During the past week, at what time did the business open on Saturday?

close_aft_sat

4003-20) During the past week, at what time did the business close on Saturday?

open_mor_sun

4003-21) During the past week, at what time did the business open on Sunday?

close_aft_sun

4003-22) During the past week, at what time did the business close on Sunday?

open_mon_mor_lunch

4003-23) During the past week, at what time did the business open on Monday?

close_mon_mor_lunch

4003-24) During the past week, at what time did the business close on Monday bef

open_mon_aft_lunch

4003-25) During the past week, at what time did the business open on Monday afte

close_mon_aft_lunch

4003-26) During the past week, at what time did the business close on Monday?

open_tue_mor_lunch

4003-27) During the past week, at what time did the business open on Tuesday?

close_tue_mor_lunch

4003-28) During the past week, at what time did the business close on Tuesday be

open_tue_aft_lunch

4003-29) During the past week, at what time did the business open on Tuesday aft

close_tue_aft_lunch

4003-30) During the past week, at what time did the business close on Tuesday?

Total: 497

1 2 >

Back to Catalog