Home
Microdata Catalog
Citations
Login
Login
Home
/
Central Data Catalog
/
COL_2016-2018_IPMC_V01_M
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
22744
Downloads
474
Study Description
Data Dictionary
Downloads
Get Microdata
Data files
agruppa_baseline_NOPII
agruppa_corabastos
agruppa_customers_NOPII
agruppa_fu6_NOPII
agruppa_fu12_NOPII
agruppa_hf_NOPII
agruppa_sales_revised
agruppa_shops_NOPII
agruppa_dates
Data file: agruppa_fu6_NOPII
6 month follow-up data on 1791 firms
Corresponding questionnaire - FU6 Survey
Cases:
1791
Variables:
614
Variables
pb_chontos_kg
Purchase price per kilogram of tomato chonto semi
qb_chontos
3013-4) How much tomato chonto semi did you purchase the last time?
qb_unit_chontos
3013-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
3013-5) How much did you pay for the tomato chonto semi the last time?
ps_chontos
3013-6) Yesterday, what was the sale price of tomato chonto semi?
ps_unit_chontos
3013-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
3013-7) Yesterday, how much tomato chonto semi did you sell?
qs_unit_chontos
3013-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
3013-8) Could I see a tomato chonto semi?
firm_chontos
3013-8-1) Is the tomato chonto semi firm to the touch?
color_chontos
3013-8-2) Does the tomato chonto semi have the right color?
def_chontos
3013-8-3) Is the tomato chonto semi faulty?
form_chontos
3013-8-4) Is the shape of the tomato chonto semi appropriate?
sold_chontos6
3013-9) Have you sold tomato chonto semi in the last six months?
sold_chontog
3014) Did you sell tomato chonto grueso yesterday?
daysb_chontog
3014-1) When was the last time you purchased tomato chonto grueso, not consideri
buy_chontog
3014-2) Where did you purchase tomato chonto grueso the last time?
buy_chontog_oth
3014-2-1) Where did you purchase tomato chonto grueso the last time (other)?
pb_chontog
3014-3) What was the purchase price of tomato chonto grueso the last time?
pb_unit_chontog
3014-3-1) Measurement unit for the purchase price of tomato chonto grueso
pb_chontog_kg
Purchase price per kilogram of tomato chonto grueso
qb_chontog
3014-4) How much tomato chonto grueso did you purchase the last time?
qb_unit_chontog
3014-4-1) Measurement unit for the purchased quantity of tomato chonto grueso
qb_chontog_kg
Purchased quantity (kilograms) of tomato chonto grueso the last time
paid_total_chontog
3014-5) How much did you pay for the tomato chonto grueso the last time?
ps_chontog
3014-6) Yesterday, what was the sale price of tomato chonto grueso?
ps_unit_chontog
3014-6-1) Measurement unit for the sale price of tomato chonto grueso
ps_chontog_kg
Sale price per kilogram of tomato chonto grueso
qs_chontog
3014-7) Yesterday, how much tomato chonto grueso did you sell?
qs_unit_chontog
3014-7-1) Measurement unit for the sold quantity of tomato chonto grueso
qs_chontog_kg
Sold quantity (kilograms) of tomato chonto grueso yesterday
see_chontog
3014-8) Could I see a tomato chonto grueso?
firm_chontog
3014-8-1) Is the tomato chonto grueso firm to the touch?
color_chontog
3014-8-2) Does the tomato chonto grueso have the right color?
def_chontog
3014-8-3) Is the tomato chonto grueso faulty?
form_chontog
3014-8-4) Is the shape of the tomato chonto grueso appropriate?
sold_chontog6
3014-9) Have you sold tomato chonto grueso in the last six months?
sold_yuca
3015) Did you sell yuca yesterday?
daysb_yuca
3015-1) When was the last time you purchased yuca, not considering today?
buy_yuca
3015-2) Where did you purchase yuca the last time?
buy_yuca_oth
3015-2-1) Where did you purchase yuca the last time (other)?
pb_yuca
3015-3) What was the purchase price of yuca the last time?
pb_unit_yuca
3015-3-1) Measurement unit for the purchase price of yuca
pb_yuca_kg
Purchase price per kilogram of yuca
qb_yuca
3015-4) How much yuca did you purchase the last time?
qb_unit_yuca
3015-4-1) Measurement unit for the purchased quantity of yuca
qb_yuca_kg
Purchased quantity (kilograms) of yuca the last time
paid_total_yuca
3015-5) How much did you pay for the yuca the last time?
ps_yuca
3015-6) Yesterday, what was the sale price of yuca?
ps_unit_yuca
3015-6-1) Measurement unit for the sale price of yuca
ps_yuca_kg
Sale price per kilogram of yuca
qs_yuca
3015-7) Yesterday, how much yuca did you sell?
qs_unit_yuca
3015-7-1) Measurement unit for the sold quantity of yuca
qs_yuca_kg
Sold quantity (kilograms) of yuca yesterday
see_yuca
3015-8) Could I see a yuca?
firm_yuca
3015-8-1) Is the yuca firm to the touch?
color_yuca
3015-8-2) Does the yuca have the right color?
def_yuca
3015-8-3) Is the yuca faulty?
form_yuca
3015-8-4) Is the shape of the yuca appropriate?
sold_yuca6
3015-9) Have you sold yuca in the last six months?
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)?
prod_first
4001-18) During the past week, which was the product that you sold the most from
prod_sec
4001-19) During the past week, which was the product that you sold the most from
prod_third
4001-20) During the past week, which was the product that you sold the most from
percent_fv
4002) During the past week, what percentage of your total sales corresponded to
changed_hours
4003) During the past six months, have you changed the business hours?
open
4003-1) During last week, was the business open every day, including Saturday an
open_mon
4003-1-1) During the past week, which days was your business open? (Monday)
open_tue
4003-1-2) During the past week, which days was your business open? (Tuesday)
open_wed
4003-1-3) During the past week, which days was your business open? (Wednesday)
open_thu
4003-1-4) During the past week, which days was your business open? (Thursday)
open_fri
4003-1-5) During the past week, which days was your business open? (Friday)
open_sat
4003-1-6) During the past week, which days was your business open? (Saturday)
open_sun
4003-1-7) During the past week, which days was your business open? (Sunday)
open_same_h
4003-2) During the past week, the business opened and closed at the same hours?
close_lunch
4003-3) During the past week, was the business close during lunch time?
open_mor
4003-4) 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-6) During the past week, at what time did the business open?
close_mor_lunch
4003-7) During the past week, at what time did the business close before lunch t
open_aft_lunch
4003-8) During the past week, at what time did the business open after lunch tim
close_aft_lunch
4003-9) During the past week, at what time did the business close?
open_mor_mon
4003-10) During the past week, at what time did the business open on Monday?
close_aft_mon
4003-11) During the past week, at what time did the business close on Monday?
open_mor_tue
4003-12) During the past week, at what time did the business open on Tuesday?
close_aft_tue
4003-13) During the past week, at what time did the business close on Tuesday?
open_mor_wed
4003-14) During the past week, at what time did the business open on Wednesday?
close_aft_wed
4003-15) During the past week, at what time did the business close on Wednesday?
open_mor_thu
4003-16) During the past week, at what time did the business open on Thursday?
close_aft_thu
4003-17) During the past week, at what time did the business close on Thursday?
open_mor_fri
4003-18) During the past week, at what time did the business open on Friday?
close_aft_fri
4003-19) During the past week, at what time did the business close on Friday?
open_mor_sat
4003-20) During the past week, at what time did the business open on Saturday?
close_aft_sat
4003-21) During the past week, at what time did the business close on Saturday?
open_mor_sun
4003-22) During the past week, at what time did the business open on Sunday?
close_aft_sun
4003-23) During the past week, at what time did the business close on Sunday?
open_mon_mor_lunch
4003-24) During the past week, at what time did the business open on Monday?
close_mon_mor_lunch
4003-25) During the past week, at what time did the business close on Monday bef
open_mon_aft_lunch
4003-26) During the past week, at what time did the business open on Monday afte
close_mon_aft_lunch
4003-27) During the past week, at what time did the business close on Monday?
open_tue_mor_lunch
4003-28) During the past week, at what time did the business open on Tuesday?
close_tue_mor_lunch
4003-29) During the past week, at what time did the business close on Tuesday be
open_tue_aft_lunch
4003-30) During the past week, at what time did the business open on Tuesday aft
close_tue_aft_lunch
4003-31) During the past week, at what time did the business close on Tuesday?
open_wed_mor_lunch
4003-32) During the past week, at what time did the business open on Wednesday?
close_wed_mor_lunch
4003-33) During the past week, at what time did the business close on Wednesday
open_wed_aft_lunch
4003-34) During the past week, at what time did the business open on Wednesday a
close_wed_aft_lunch
4003-35) During the past week, at what time did the business close on Wednesday?
open_thu_mor_lunch
4003-36) During the past week, at what time did the business open on Thursday?
close_thu_mor_lunch
4003-37) During the past week, at what time did the business close on Thursday b
open_thu_aft_lunch
4003-38) During the past week, at what time did the business open on Thursday af
close_thu_aft_lunch
4003-39) During the past week, at what time did the business close on Thursday?
open_fri_mor_lunch
4003-40) During the past week, at what time did the business open on Friday?
close_fri_mor_lunch
4003-41) During the past week, at what time did the business close on Friday bef
open_fri_aft_lunch
4003-42) During the past week, at what time did the business open on Friday afte
close_fri_aft_lunch
4003-43) During the past week, at what time did the business close on Friday?
open_sat_mor_lunch
4003-44) During the past week, at what time did the business open on Saturday?
close_sat_mor_lunch
4003-45) During the past week, at what time did the business close on Saturday b
open_sat_aft_lunch
4003-46) During the past week, at what time did the business open on Saturday af
close_sat_aft_lunch
4003-47) During the past week, at what time did the business close on Saturday?
open_sun_mor_lunch
4003-48) During the past week, at what time did the business open on Sunday?
close_sun_mor_lunch
4003-49) During the past week, at what time did the business close on Sunday bef
open_sun_aft_lunch
4003-50) During the past week, at what time did the business open on Sunday afte
close_sun_aft_lunch
4003-51) 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?
customers
4015) Do you think the number of customers has increased during the past six mon
cust_time
4015-1) Is the increase in customers explained by the following?: It's a normal
cust_prices
4015-2) Is the increase in customers explained by the following?: I've been able
cust_quality
4015-3) Is the increase in customers explained by the following?: I've been able
cust_service
4015-4) Is the increase in customers explained..
cust_lookc
4015-5) Is the increase in customers explained by the following?: I've had more
cust_oth
4015-6) Is the increase in customers explained by other reasons?
robbed_in
4016) During the past six months, have you suffered any robberies or security in
times_robbed_in
4016-1) How many times did these kind of incidents occur during the past six mon
robbed_out
4017) During the past six months, have you suffered any robberies or security in
times_robbed_out
4017-1) How many times did these kind of incidents occur during the past six mon
sec_percep
* 4018) On a scale from 1 to 4, where 1 is..
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?
how_record_p
5001-2) How do you take these records of the purchase prices?
record_q
5002) Do you keep records of the purchased quantities of each product?
freq_record_q
5002-1) How frequently do you keep records of the purchased quantities?
how_record_q
5002-2) How do you take these records of the purchased quantities?
record_psell
5003) Do you keep records of the sale price of each product?
freq_record_psell
5003-1) How frequently do you keep records of the sale prices?
how_record_psell
5003-2) How do you take these records of the sale prices?
record_qsell
5004) Do you keep records of the sold quantities of each product?
freq_record_qsell
5004-1) How frequently do you keep records of the sold quantities?
how_record_qsell
5004-2) How do you take these records of the sold quantities?
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?
sales_yest
5007) Approximately, how much money did you received from sales yesterday?
range_sales_yest
5007-1) Within these ranges, how much money did you received from sales yesterda
sales_week
5008) Approximately, how much money did you received from sales the past week?
range_sales_week
5008-1) Within these ranges, how much money did you received from sales the past
sales_mth
5009) Approximately, how much money did you received from sales the past month?
range_sales_mth
5009-1) Within these ranges, how much money did you received from sales the past
profits_yest
5010) Approximately, how much were the profits of the business yesterday?
range_profits_yest
5010-1) Within these ranges, how much were the profits of the business yesterday
profits_week
5011) Approximately, how much were the profits of the business the past week?
range_profits_week
5011-1) Within these ranges, how much were the profits of the business the past
profits_mth
5012) Approximately, how much were the profits of the business the past month?
range_profits_mth
5012-1) Within these ranges, how much were the profits of the business the past
waste
5013) During the past week, how much did you pay for fruits and vegetables that
decide_spent
5014) Which of these options describes best the way you decide how much money to
decide_spent_oth
5014-1) Which of these options describes best the way you decide how much money
reinvest
5015) Do you use part of your profits to reinvest in the growth of the business?
reinvest_how
5015-1) How do you reinvest the profits in the growth of the business?
reinvest_how_oth
5015-1-1) How do you reinvest the profits in the growth of the business? (other)
sepmoney_hb
5016) Do you keep money for business expenses and money for household expenses i
sepmoney_bigpur
5017) Do you keep money saved for a big purchase and the money for regular busin
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_minutes
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
purch_agruppa
6011) During the past week, did you purchase any fruits or vegetables from Agrup
daysp_agruppa
6011-1) During the past week, how many days did you purchase from Agruppa?
reason_ag1
6011-2) What is the most important reason for you to use Agruppa?
reason_ag2
6011-3) What is the second most important reason for you to use Agruppa?
reason_ag3
6011-4) What is the third most important reason for you to use Agruppa?
reason_ag_oth
6011-4-1) What is the most important reason for you to use Agruppa (other)?
purch_bef_ag
6012) Have you previously purchased fruits and vegetables from Agruppa, but stop
reason_stag1
6012-1) What is the most important reason for you to have stopped using Agruppa?
reason_stag2
6012-2) What is the second most important reason for you to have stopped using A
reason_stag_oth
6012-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?
Total: 614
<
1
2
3
>
Back to Catalog