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

22031

Downloads

474

Data file: agruppa_fu12_NOPII

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

Cases:	1791
Variables:	497

Variables

open_wed_mor_lunch

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

close_wed_mor_lunch

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

open_wed_aft_lunch

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

close_wed_aft_lunch

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

open_thu_mor_lunch

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

close_thu_mor_lunch

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

open_thu_aft_lunch

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

close_thu_aft_lunch

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

open_fri_mor_lunch

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

close_fri_mor_lunch

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

open_fri_aft_lunch

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

close_fri_aft_lunch

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

open_sat_mor_lunch

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

close_sat_mor_lunch

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

open_sat_aft_lunch

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

close_sat_aft_lunch

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

open_sun_mor_lunch

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

close_sun_mor_lunch

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

open_sun_aft_lunch

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

close_sun_aft_lunch

4003-50) 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

employees

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

paid

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

not_paid

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

talk_vend

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

relation_vend

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

market_bprices

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

market_sprices

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

add_amount

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

add_percentage

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

price_lower_comp

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

same_price

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

otherway_setp

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

amount_added

4010) Approximately, how much amount do you add?

percentage_added

4011) Approximately, how much percentage did you add?

freq_price_set

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

charge_price

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

day_sales

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

markup

4015) Is the markup level for all the products the same? Or, do you have a diffe

markup_det

4015-1) How do you determine the markup for each product?

chargepotato

4016) If the price of potato pastusa was $500 at Corabastos, how much would you

chargepotato_othsup

4017) If the price of potato pastusa was $500 at Corabastos but you were able to

customers

4018) Do you think the number of customers has increased during the past six mon

cust_time

4018-1) Is the increase in customers explained by the following?: It's a normal

cust_prices

4018-2) Is the increase in customers explained by the following?: I've been able

cust_quality

4018-3) Is the increase in customers explained by the following?: I've been able

cust_service

4018-4) Is the increase in

cust_lookc

4018-5) Is the increase in customers explained by the following?: I've had more

cust_oth

4018-6) Is the increase in customers explained by other reasons?

robbed_in

4019) During the past six months, have you suffered any robberies or security in

times_robbed_in

4019-1) How many times did these kind of incidents occur during the past six mon

robbed_out

4020) During the past six months, have you suffered any robberies or security in

times_robbed_out

4020-1) How many times did these kind of incidents occur during the past six mon

sec_percep

4021) On a scale from 1 to 4...

record_p

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

freq_record_p

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

record_q

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

record_psell

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

record_qsell

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

record_sales

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

freq_record_sales

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

how_record_sales

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

how_record_sales_oth

5005-2-1) How do you take these records of the money received by sales (other)?

weekly_sales

5007) Approximately, how much money did you receive from sales the past week?

weekly_sales_best

5008) Approximately, how much money did you receive from sales the best week of

weekly_sales_worst

5009) Approximately, how much money did you receive from sales the worst week of

weekly_sales_avg

Average of best week and worst week

sales_yest

5010) Approximately, how much money did you receive from sales yesterday?

sales_yest_best

5011) Approximately, how much money did you receive from sales the best day of t

sales_yest_worst

5012) Approximately, how much money did you receive from sales the worst day of

sales_yest_avg

5010), (ii) Best day of the past week You just gave me three answers on daily sa

weekly_sales_estimate

5014) Which of the following 3 options is closest to the average value of the we

sales_week

Approximately, how much money did you received by sales the past week (according

sales_mth

5015) Approximately, how much money did you received from sales the past month?

range_sales_mth

5015-1) Within these ranges, how much money did you received from sales the past

profits_yest

5016) Approximately, how much were the profits of the business yesterday?

range_profits_yest

5016-1) Within these ranges, how much were the profits of the business yesterday

profits_week

5017) Approximately, how much were the profits of the business the past week?

range_profits_week

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

profits_mth

5018) Approximately, how much were the profits of the business the past month?

range_profits_mth

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

waste

5019) During the past week, how much did you pay for fruits and vegetables that

dayscorab

6001) During the past week, how many days did you (or another employee) go to Co

buy_veggies_oth

6001-1) Where was the main place/way you purchased the products instead of Corab

daysother

6001-2) During the past week, how many days did you (or another employee) go to

aprods_corab

6002) Out of the N days that you went to Corabastos the past week, how many did

otherf_corab

6003) Out of the N days that you went to Corabastos the past week, how many did

otherp_corab

6004) Out of the N days that you went to Corabastos the past week, how many did

wake_corab

6005) At what time do you usually wake up when you are going to Corabastos (or t

timetocorab_min

6006) How much time do you spend going to Corabastos/other place?

timeatcorab_min

6007) How much time do you spend purchasing the products at Corabastos/other pla

timefromcorab_min

6008) How much time do you spend coming back from Corabastos/other place?

timeback

6009) At what time do you usually arrive to your business from Corabastos (or th

costs_corab

6010) Approximately, how much money did you spend in transportation, exit fee or

smartphone

6011) Do you have a smartphone (e.g. Android, iPhone) capable of downloading app

smartphone_wsapp

6011-1) Do you use Whatsapp?

purch_agruppa

6012) During the past week, did you purchase any fruits or vegetables from Agrup

daysp_agruppa

6012-1) During the past week, how many days did you purchase from Agruppa?

howp_agruppa

6012-2) Which of the following is the main way you order from Agruppa?

howp_agruppa_o

6012-2-1) Which of the following is the main way you order from Agruppa (other)?

reason_ag1

6012-3) What is the most important reason for you to use Agruppa?

reason_ag2

6012-4) What is the second most important reason for you to use Agruppa?

reason_ag3

6012-5) What is the third most important reason for you to use Agruppa?

reason_ag_oth

6012-5-1) What is the most important reason for you to use Agruppa (other)?

month_agruppa

6012-6) How long have you been using Agruppa?

variety_changeag

6012-7) Since the day you became a client, do you think the variety of products

quality_changeag

6012-8) Since the day you became a client, do you think the quality of the produ

price_changeag

6012-9) Since the day you became a client, do you think the price of the product

purch_bef_ag

6013) Have you previously purchased fruits and vegetables from Agruppa, but stop

reason_stag1

6013-1) What is the most important reason for you to have stopped using Agruppa?

reason_stag2

6013-2) What is the second most important reason for you to have stopped using A

reason_stag_oth

6013-2-1) What is the most important reason for you to have stopped using Agrupp

inc_mth

7001) Approximately, how much was your household's income the past month?

range_inc_mth

7001-1) Within these ranges, how much was your household's income the past month

satisfied

7002) Do you feel satisfied with the life you have?

satisfied_work

7003) Do you feel satisfied with your job?

stress_work

7004) Do you feel more stressed the days you go to purchase the products, relati

freq_stress

7005) How frequently do you feel that your work is stressful?

freq_stress_wk

7006) In the last two weeks, how frequently have you felt that your work has bee

tired_work

7007) Do you feel more tired the days you go to purchase the products, relative

freq_tired_wk

7008) In the last two weeks, how frequently did you feel tired?

freq_upset_wk

7009) In the last two weeks, how frequently did you feel upset for any unexpecte

freq_time_wk

7010) In the last two weeks, how frequently did you feel that time was not enoug

freq_notime

7011) How frequently do you feel that your work forces you to spent less time wi

tspent_1

7012) What is the first thing that occupies most of your time?

tspent_2

7013) What is the second thing that occupies most of your time?

tspent_3

7014) What is the third thing that occupies most of your time?

other_work

7015) During the past six months, have you started to search for other employmen

time_nofv

8001) How long ago did the business stop selling fruits and vegetables (months)?

reason_nofv

8002) Why did the business stop selling fruits and vegetables?

av_carrot

8003) Is there carrot?

psav_carrot

8003-1) What is today's sale price of carrot?

psav_unit_carrot

8003-1-1) Measurement unit for the sale price of carrot

psav_carrot_kg

Sale price per kilogram of carrot

av_cebca

8004) Is there onion cabezona?

psav_cebca

8004-1) What is today's sale price of onion cabezona?

psav_unit_cebca

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

psav_cebca_kg

Sale price per kilogram of onion cabezona

av_cebla

8005) Is there onion larga?

psav_cebla

8005-1) What is today's sale price of onion larga?

psav_unit_cebla

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

psav_cebla_kg

Sale price per kilogram of onion larga

av_platpri

8006) Is there plantain primera?

psav_platpri

8006-1) What is today's sale price of plantain primera?

psav_unit_platpri

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

psav_platpri_kg

Sale price per kilogram of plantain primera

av_platseg

8007) Is there plantain segunda?

psav_platseg

8007-1) What is today's sale price of plantain segunda?

psav_unit_platseg

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

psav_platseg_kg

Sale price per kilogram of plantain segunda

av_platpic

8008) Is there plantain pica?

psav_platpic

8008-1) What is today's sale price of plantain pica?

psav_unit_platpic

8008-1-1) Measurement unit for the sale price of plantain pica

psav_platpic_kg

Sale price per kilogram of plantain pica

av_pastusag

8009) Is there potato pastusa gruesa?

psav_pastusag

8009-1) What is today's sale price of potato pastusa gruesa?

psav_unit_pastusag

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

psav_pastusag_kg

Sale price per kilogram of potato pastusa gruesa

av_pastusap

8010) Is there potato pastusa pareja?

psav_pastusap

8010-1) What is today's sale price of potato pastusa pareja?

psav_unit_pastusap

8010-1-1) Measurement unit for the sale price of potato pastusa pareja

psav_pastusap_kg

Sale price per kilogram of potato pastusa pareja

av_superiorg

8011) Is there potato superior gruesa?

psav_superiorg

8011-1) What is today's sale price of potato superior gruesa?

psav_unit_superiorg

8011-1-1) Measurement unit for the sale price of potato superior gruesa

psav_superiorg_kg

Sale price per kilogram of potato superior gruesa

av_superiorp

8012) Is there potato superior pareja?

psav_superiorp

8012-1) What is today's sale price of potato superior pareja?

psav_unit_superiorp

8012-1-1) Measurement unit for the sale price of potato superior pareja

psav_superiorp_kg

Sale price per kilogram of potato superior pareja

av_supremag

8013) Is there potato suprema gruesa?

psav_supremag

8013-1) What is today's sale price of potato suprema gruesa?

psav_unit_supremag

8013-1-1) Measurement unit for the sale price of potato suprema gruesa

psav_supremag_kg

Sale price per kilogram of potato suprema gruesa

av_supremap

8014) Is there potato suprema pareja?

psav_supremap

8014-1) What is today's sale price of potato suprema pareja?

psav_unit_supremap

8014-1-1) Measurement unit for the sale price of potato suprema pareja

psav_supremap_kg

Sale price per kilogram of potato suprema pareja

av_chontos

8015) Is there tomato chonto semi?

psav_chontos

8015-1) What is today's sale price of tomato chonto semi?

psav_unit_chontos

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

psav_chontos_kg

Sale price per kilogram of tomato chonto semi

av_chontog

8016) Is there tomato chonto grueso?

psav_chontog

8016-1) What is today's sale price of tomato chonto grueso?

psav_unit_chontog

8016-1-1) Measurement unit for the sale price of tomato chonto grueso

psav_chontog_kg

Sale price per kilogram of tomato chonto grueso

av_yuca

8017) Is there yuca?

psav_yuca

8017-1) What is today's sale price of yuca?

psav_unit_yuca

8017-1-1) Measurement unit for the sale price of yuca

psav_yuca_kg

Sale price per kilogram of yuca

survstatus

8019) Enumerator: What is the survey status?

survstatus_ne

8019-1) Enumerator: Please explain the non-existing firm status

survstatus_ref

8019-2) Enumerator: Which is the main reason why the vendor refuses to participa

survstatus_ref_ag

8019-2-2) Enumerator: Why is the vendor not satisfied with Agruppa?

datesurv

Date and time of the survey

week

Week of the survey

formdef_version

XLSForm version

Total: 497

<1 2

Back to Catalog