usaid-gov/baseline-survey-for-an-impact-evaluation-of-the-6mm5-xsxs

  • access to services
  • agriculture
  • crop productivity
  • farm inputs
  • farming practices
  • + 8

Query the Data Delivery Network

Query the DDN

The easiest way to query any data on Splitgraph is via the "Data Delivery Network" (DDN). The DDN is a single endpoint that speaks the PostgreSQL wire procotol. Any Splitgraph user can connect to it at data.splitgraph.com:5432 and query any version of over 40,000 datasets that are hosted or proxied by Splitgraph.

For example, you can query the baseline_survey_for_an_impact_evaluation_of_the table in this repository, by referencing it like:

"usaid-gov/baseline-survey-for-an-impact-evaluation-of-the-6mm5-xsxs:latest"."baseline_survey_for_an_impact_evaluation_of_the"

or in a full query, like:

SELECT 
    ":id", -- Socrata column ID
    "employment_3_payment_period_3", -- How often did household member 4 receive payment for this work? (Day: 1, Week: 2, Month: 3, In Total: 4)
    "employment_2_number_of_months_10", -- For how many months did housedhold member 13 do this work (Missing: -99)
    "household_type", -- Type of house (select from options)? (Mud Wall Tukul: 1, Stone Wall: 2, Stone And Wood Wall: 3, Bamboo Wall: 4, Wooden Wall: 5, Concrete Wall: 6, Other (Specify): 7)
    "employment_3_last_12_months_7", -- During the last 12 months, did household member 8 do any additional paid or unpaid work? (Yes: 1, No: 2)
    "employment_4_payment_value_10", -- How much did household member 11 get paid for this other work in total? (Missing: -99)
    "employment_2_hours_per_day_12", -- How many hours per day did household member 13 do this work on the days per month per month he she worked? (Missing: -99)
    "employment_3_payment_value_11", -- How much cash or in-kind payment did household member 12 get for this work? (Missing: -99)
    "employment_2_number_of_days", -- How many days per month per month was household member 1 employed in this work? (Missing: -99)
    "household_type_other", -- Type of house (other)? (Missing: -99)
    "employment_3_last_12_months", -- During the last 12 months, did household member 1 do any additional paid or unpaid work? (Yes: 1, No: 2)
    "local_gov_office_travel_time", -- How long does is or would it take you to get to a local government office (hours)? (Missing: -99)
    "employment_3_by_code_last_9", -- Please describe household member 10 s additional work during the last 12 months. (Cultivators: 11, Farmers: 12, Cattle Sheep Goat Rearing (Livestock): 13, Fishing: 14, Lumbering: 15, Agricultural Laborers: 16, Hunters: 17, Dairying: 18, Other Agriculture: 10, Stone Cutters And Carvers (Masons).: 21, Brick Producers, Bricklayers, Carrying Mud And Other Constructions Workers.: 22, Tobacco Preparers (Saud Makers) And Tobacco Product Makers: 23, Charcoal Producers: 24, Tailors, Dress Makers, Sewers, Upholsterers, Spinners, Weavers, Knitters, Dyers And Related Workers: 25, Cobbler; Shoe Makers And Leather Goods Makers.: 26, Carpenters, Cabinet And Related Wood Workers.: 27, Blacksmith; Goldsmith.: 28, Brewers (Production Of Local Brew): 29, Other: Miners, Quarrymen, Well Drillers; Wood Paper Preparation; Chemical Processors And Related Workers; Tool Makers And Machine Tool Operators; Machinery Fitters, Machine Assemblers And Precision Instrument Makers, Jewellery And Precious Metal Workers And Metal Engravers (Except Printing); Glass Formers, Potters And Related Workers; Paper And Paper Board Products Makers; Printing And Related Workers; Other Production And Related Workers: 20, Servants; Waiters: 31, Sweepers, Cleaners; Building Caretakers.: 32, Barbers, Beauticians; Hair Dressers: 33, Launderers (Dhobi) Dry-Cleaners And Pressers.: 34, Petty Traders; Small Shop-Owners ( 10 Employees): 35, Big Shop Owner ( 10 Employees): 36, Transport Workers; Drivers; Tractor Owner; Auto Owner.: 37, Bicycle Motorcycle Auto Mechanics.: 38, Priest Religious Workers Imam: 39, Other: Hotel And Restaurant Keepers; Money Lenders, Electrical Workers.: 30, Teacher Lecturer Headmaster: 41, Health Professional; Doctor; Nurse, Midwife, Community Health Worker.: 42, Other: Scientific, And Technical Persons, Poets, Authors, Journalists And Related Workers; Sculptors, Painters, Photographers And Related Creative Artists, Composers And Performing Artists: 40, Boma Administrator Chief: 51, Clerk Administrative: Private: 52, Clerk Administrative: Government: 53, Other: Elected And Legislative Officials; Working Proprietors.: 50, Housewife: 61, Student: 62, Work Completed As Part Of Project Led By Ngo Or International Organisation.: 63, Unemployed: 64, Other: Anything That Is Not Classified Under Divisions 1-5 (Including Military Without Other Occupation Speciality And Police Officers): 60)
    "employment_3_by_code_last_11", -- Please describe household member 12 s additional work during the last 12 months. (Cultivators: 11, Farmers: 12, Cattle Sheep Goat Rearing (Livestock): 13, Fishing: 14, Lumbering: 15, Agricultural Laborers: 16, Hunters: 17, Dairying: 18, Other Agriculture: 10, Stone Cutters And Carvers (Masons).: 21, Brick Producers, Bricklayers, Carrying Mud And Other Constructions Workers.: 22, Tobacco Preparers (Saud Makers) And Tobacco Product Makers: 23, Charcoal Producers: 24, Tailors, Dress Makers, Sewers, Upholsterers, Spinners, Weavers, Knitters, Dyers And Related Workers: 25, Cobbler; Shoe Makers And Leather Goods Makers.: 26, Carpenters, Cabinet And Related Wood Workers.: 27, Blacksmith; Goldsmith.: 28, Brewers (Production Of Local Brew): 29, Other: Miners, Quarrymen, Well Drillers; Wood Paper Preparation; Chemical Processors And Related Workers; Tool Makers And Machine Tool Operators; Machinery Fitters, Machine Assemblers And Precision Instrument Makers, Jewellery And Precious Metal Workers And Metal Engravers (Except Printing); Glass Formers, Potters And Related Workers; Paper And Paper Board Products Makers; Printing And Related Workers; Other Production And Related Workers: 20, Servants; Waiters: 31, Sweepers, Cleaners; Building Caretakers.: 32, Barbers, Beauticians; Hair Dressers: 33, Launderers (Dhobi) Dry-Cleaners And Pressers.: 34, Petty Traders; Small Shop-Owners ( 10 Employees): 35, Big Shop Owner ( 10 Employees): 36, Transport Workers; Drivers; Tractor Owner; Auto Owner.: 37, Bicycle Motorcycle Auto Mechanics.: 38, Priest Religious Workers Imam: 39, Other: Hotel And Restaurant Keepers; Money Lenders, Electrical Workers.: 30, Teacher Lecturer Headmaster: 41, Health Professional; Doctor; Nurse, Midwife, Community Health Worker.: 42, Other: Scientific, And Technical Persons, Poets, Authors, Journalists And Related Workers; Sculptors, Painters, Photographers And Related Creative Artists, Composers And Performing Artists: 40, Boma Administrator Chief: 51, Clerk Administrative: Private: 52, Clerk Administrative: Government: 53, Other: Elected And Legislative Officials; Working Proprietors.: 50, Housewife: 61, Student: 62, Work Completed As Part Of Project Led By Ngo Or International Organisation.: 63, Unemployed: 64, Other: Anything That Is Not Classified Under Divisions 1-5 (Including Military Without Other Occupation Speciality And Police Officers): 60)
    "employment_4_payment_value_1", -- How much did household member 2 get paid for this other work in total? (Missing: -99)
    "travel_to_firewood_source",
    "employment_2_location_hh_11", -- Where did household member 12 perform this work? (This Village: 1, Other Village In This Boma: 2, Other Boma: 3, Other Payam: 4, Local Town: 5, Other Town: 6, Abroad: 7)
    "employment_3_by_code_last_6", -- Please describe household member 7 s additional work during the last 12 months. (Cultivators: 11, Farmers: 12, Cattle Sheep Goat Rearing (Livestock): 13, Fishing: 14, Lumbering: 15, Agricultural Laborers: 16, Hunters: 17, Dairying: 18, Other Agriculture: 10, Stone Cutters And Carvers (Masons).: 21, Brick Producers, Bricklayers, Carrying Mud And Other Constructions Workers.: 22, Tobacco Preparers (Saud Makers) And Tobacco Product Makers: 23, Charcoal Producers: 24, Tailors, Dress Makers, Sewers, Upholsterers, Spinners, Weavers, Knitters, Dyers And Related Workers: 25, Cobbler; Shoe Makers And Leather Goods Makers.: 26, Carpenters, Cabinet And Related Wood Workers.: 27, Blacksmith; Goldsmith.: 28, Brewers (Production Of Local Brew): 29, Other: Miners, Quarrymen, Well Drillers; Wood Paper Preparation; Chemical Processors And Related Workers; Tool Makers And Machine Tool Operators; Machinery Fitters, Machine Assemblers And Precision Instrument Makers, Jewellery And Precious Metal Workers And Metal Engravers (Except Printing); Glass Formers, Potters And Related Workers; Paper And Paper Board Products Makers; Printing And Related Workers; Other Production And Related Workers: 20, Servants; Waiters: 31, Sweepers, Cleaners; Building Caretakers.: 32, Barbers, Beauticians; Hair Dressers: 33, Launderers (Dhobi) Dry-Cleaners And Pressers.: 34, Petty Traders; Small Shop-Owners ( 10 Employees): 35, Big Shop Owner ( 10 Employees): 36, Transport Workers; Drivers; Tractor Owner; Auto Owner.: 37, Bicycle Motorcycle Auto Mechanics.: 38, Priest Religious Workers Imam: 39, Other: Hotel And Restaurant Keepers; Money Lenders, Electrical Workers.: 30, Teacher Lecturer Headmaster: 41, Health Professional; Doctor; Nurse, Midwife, Community Health Worker.: 42, Other: Scientific, And Technical Persons, Poets, Authors, Journalists And Related Workers; Sculptors, Painters, Photographers And Related Creative Artists, Composers And Performing Artists: 40, Boma Administrator Chief: 51, Clerk Administrative: Private: 52, Clerk Administrative: Government: 53, Other: Elected And Legislative Officials; Working Proprietors.: 50, Housewife: 61, Student: 62, Work Completed As Part Of Project Led By Ngo Or International Organisation.: 63, Unemployed: 64, Other: Anything That Is Not Classified Under Divisions 1-5 (Including Military Without Other Occupation Speciality And Police Officers): 60)
    "bank_travel_time_1", -- How long does is or would it take you to get to a bank (hours)? (Missing: -99)
    "employment_2_payment_period_3", -- How often did household member 4 receive payment for this work? (Day: 1, Week: 2, Month: 3, In Total: 4)
    "employment_3_by_code_last_10", -- Please describe household member 11 s additional work during the last 12 months. (Cultivators: 11, Farmers: 12, Cattle Sheep Goat Rearing (Livestock): 13, Fishing: 14, Lumbering: 15, Agricultural Laborers: 16, Hunters: 17, Dairying: 18, Other Agriculture: 10, Stone Cutters And Carvers (Masons).: 21, Brick Producers, Bricklayers, Carrying Mud And Other Constructions Workers.: 22, Tobacco Preparers (Saud Makers) And Tobacco Product Makers: 23, Charcoal Producers: 24, Tailors, Dress Makers, Sewers, Upholsterers, Spinners, Weavers, Knitters, Dyers And Related Workers: 25, Cobbler; Shoe Makers And Leather Goods Makers.: 26, Carpenters, Cabinet And Related Wood Workers.: 27, Blacksmith; Goldsmith.: 28, Brewers (Production Of Local Brew): 29, Other: Miners, Quarrymen, Well Drillers; Wood Paper Preparation; Chemical Processors And Related Workers; Tool Makers And Machine Tool Operators; Machinery Fitters, Machine Assemblers And Precision Instrument Makers, Jewellery And Precious Metal Workers And Metal Engravers (Except Printing); Glass Formers, Potters And Related Workers; Paper And Paper Board Products Makers; Printing And Related Workers; Other Production And Related Workers: 20, Servants; Waiters: 31, Sweepers, Cleaners; Building Caretakers.: 32, Barbers, Beauticians; Hair Dressers: 33, Launderers (Dhobi) Dry-Cleaners And Pressers.: 34, Petty Traders; Small Shop-Owners ( 10 Employees): 35, Big Shop Owner ( 10 Employees): 36, Transport Workers; Drivers; Tractor Owner; Auto Owner.: 37, Bicycle Motorcycle Auto Mechanics.: 38, Priest Religious Workers Imam: 39, Other: Hotel And Restaurant Keepers; Money Lenders, Electrical Workers.: 30, Teacher Lecturer Headmaster: 41, Health Professional; Doctor; Nurse, Midwife, Community Health Worker.: 42, Other: Scientific, And Technical Persons, Poets, Authors, Journalists And Related Workers; Sculptors, Painters, Photographers And Related Creative Artists, Composers And Performing Artists: 40, Boma Administrator Chief: 51, Clerk Administrative: Private: 52, Clerk Administrative: Government: 53, Other: Elected And Legislative Officials; Working Proprietors.: 50, Housewife: 61, Student: 62, Work Completed As Part Of Project Led By Ngo Or International Organisation.: 63, Unemployed: 64, Other: Anything That Is Not Classified Under Divisions 1-5 (Including Military Without Other Occupation Speciality And Police Officers): 60)
    "employment_3_location_hh_8", -- Where did household member 9 perform this work? (Own Farm: 1, Communally Farmed Land: 2, Own Business: 3, Private Individual: 4, Government: 5, Public Work: 6, Private Firm: 7, Ngo: 8, Other (Specify): 9)
    "employment_2_payment_period_12", -- How often did household member 13 receive payment for this work? (Day: 1, Week: 2, Month: 3, In Total: 4)
    "employment_4_last_12_months_8", -- During the last 12 months, did household member 9 do any additional paid or unpaid work? (Yes: 1, No: 2)
    "service_travel_time_2",
    "employment_4_payment_value_9", -- How much did household member 10 get paid for this other work in total? (Missing: -99)
    "employment_3_payment_period_1", -- How often did household member 2 receive payment for this work? (Day: 1, Week: 2, Month: 3, In Total: 4)
    "cooking_fuel_type", -- What is the main kind of fuel you use for cooking? (Firewood: 1, Charcoal: 2, Electricity: 3, Kerosene Gas: 4, Cow Dung: 5, Biogas: 6)
    "employment_3_type_of_payment_11", -- What type of payment did household member 12 get for this work? (Cash: 1, In-Kind: 2, No Pay: 3)
    "employment_3_last_12_months_10", -- During the last 12 months, did household member 11 do any additional paid or unpaid work? (Yes: 1, No: 2)
    "employment_3_number_of_months_6", -- For how many months did housedhold member 7 do this work (Missing: -99)
    "employment_2_type_of_payment_8", -- What type of payment did household member 9 get for this work? (Cash: 1, In-Kind: 2, No Pay: 3)
    "employment_3_location_hh_6", -- Where did household member 7 perform this work? (Own Farm: 1, Communally Farmed Land: 2, Own Business: 3, Private Individual: 4, Government: 5, Public Work: 6, Private Firm: 7, Ngo: 8, Other (Specify): 9)
    "lighting_source_other_2", -- What is the main source of lighting in your house (other category 2)? (Missing: -99)
    "employment_3_number_of_days_1", -- How many days per month per month was household member 2 employed in this work? (Missing: -99)
    "main_road_travel_time_1", -- How long does is or would it take you to get to a main road (hours)? (Missing: -99)
    "employment_4_last_12_months_2", -- During the last 12 months, did household member 3 do any additional paid or unpaid work? (Yes: 1, No: 2)
    "employment_3_location_hh_7", -- Where did household member 8 perform this work? (Own Farm: 1, Communally Farmed Land: 2, Own Business: 3, Private Individual: 4, Government: 5, Public Work: 6, Private Firm: 7, Ngo: 8, Other (Specify): 9)
    "employment_2_number_of_months_4", -- For how many months did housedhold member 7 do this work (Missing: -99)
    "employment_2_number_of_days_10", -- How many days per month per month was household member 11 employed in this work? (Missing: -99)
    "employment_2_location_hh_10", -- Where did household member 11 perform this work? (This Village: 1, Other Village In This Boma: 2, Other Boma: 3, Other Payam: 4, Local Town: 5, Other Town: 6, Abroad: 7)
    "employment_2_hours_per_day_11", -- How many hours per day did household member 12 do this work on the days per month per month he she worked? (Missing: -99)
    "employment_2_payment_period_5", -- How often did household member 6 receive payment for this work? (Day: 1, Week: 2, Month: 3, In Total: 4)
    "employment_3_location_hh_4", -- Where did household member 5 perform this work? (Own Farm: 1, Communally Farmed Land: 2, Own Business: 3, Private Individual: 4, Government: 5, Public Work: 6, Private Firm: 7, Ngo: 8, Other (Specify): 9)
    "farming_problem_type_4", -- Please tell us what these were in order of importance (code) (Poor Quality Soil: 1, Pest And Disease: 2, Marketing Problems: 3, Poor Infrastructure: 4, High Cost Of Inputs: 5, Lack Of Availablity Of Inputs: 6, Labor Shortages: 7, Lack Of Goodpost-Harvest Storage: 8, Drought Lack Of Rain: 9, Wild Life Problems: 10, Floods Heavy Rain: 11, Security: 12, Low Seed Germination Rate: 13, Fire: 14)
    "employment_2_location_hh_4", -- Where did household member 5 perform this work? (This Village: 1, Other Village In This Boma: 2, Other Boma: 3, Other Payam: 4, Local Town: 5, Other Town: 6, Abroad: 7)
    "employment_3_hours_per_day_9", -- How many hours per day did household member 10 do this work on the days per month per month he she worked? (Missing: -99)
    "employment_2_hours_per_day_3", -- How many hours per day did household member 4 do this work on the days per month per month he she worked? (Missing: -99)
    "employment_2_number_of_months_1", -- For how many months did housedhold member 4 do this work (Missing: -99)
    "firewood_travel_time_1",
    "irrigation_used", -- During the last year (12 months), did you use irrigation on any of the locations you farmed? (Yes: 1, No: 2)
    "employment_3_payment_value_2", -- How much cash or in-kind payment did household member 3 get for this work? (Missing: -99)
    "employment_3_by_employer_4", -- Who is household member 5 s employer for this work? (Own Farm: 1, Communally Farmed Land: 2, Own Business: 3, Private Individual: 4, Government: 5, Public Work: 6, Private Firm: 7, Ngo: 8, Other (Specify): 9)
    "employment_3_payment_value", -- How much cash or in-kind payment did household member 1 get for this work? (Missing: -99)
    "employment_3_last_12_months_11", -- During the last 12 months, did household member 12 do any additional paid or unpaid work? (Yes: 1, No: 2)
    "employment_2_location_hh_7", -- Where did household member 8 perform this work? (This Village: 1, Other Village In This Boma: 2, Other Boma: 3, Other Payam: 4, Local Town: 5, Other Town: 6, Abroad: 7)
    "employment_2_type_of_payment_4", -- What type of payment did household member 5 get for this work? (Cash: 1, In-Kind: 2, No Pay: 3)
    "employment_4_last_12_months_6", -- During the last 12 months, did household member 7 do any additional paid or unpaid work? (Yes: 1, No: 2)
    "employment_4_last_12_months_7", -- During the last 12 months, did household member 8 do any additional paid or unpaid work? (Yes: 1, No: 2)
    "toilet_type", -- What kind of toilet does your household have (select from options)? (Flush Toilet: 1, Pit Toilet Latrine: 2, Bucket Toilet: 3, No Facility Bush Field: 4, Other (Specify): 5)
    "petrol_station_travel_time", -- How long does is or would it take you to get to a petrol station (hours)? (Missing: -99)
    "employment_4_payment_value_2", -- How much did household member 3 get paid for this other work in total? (Missing: -99)
    "police_station_travel_mode", -- How do you ususally travel to a police station or how would you travel there if you needed to travel code 1? (Foot: 1, Bicycle: 2, Motorcycle: 3, Car: 4, Bus: 5, Other: 6)
    "employment_3_number_of_days_8", -- How many days per month per month was household member 9 employed in this work? (Missing: -99)
    "employment_2_type_of_payment_3", -- What type of payment did household member 4 get for this work? (Cash: 1, In-Kind: 2, No Pay: 3)
    "post_office_travel_mode_2", -- How do you ususally travel to a post office or how would you travel there if you needed to travel code 2? (Foot: 1, Bicycle: 2, Motorcycle: 3, Car: 4, Bus: 5, Other: 6)
    "employment_3_number_of_months_12", -- For how many months did housedhold member 13 do this work (Missing: -99)
    "employment_3_payment_period_7", -- How often did household member 8 receive payment for this work? (Day: 1, Week: 2, Month: 3, In Total: 4)
    "cultivation_2_start", -- When did the second season start (month)? (Missing: -99)
    "employment_3_by_employer_9", -- Who is household member 10 s employer for this work? (Own Farm: 1, Communally Farmed Land: 2, Own Business: 3, Private Individual: 4, Government: 5, Public Work: 6, Private Firm: 7, Ngo: 8, Other (Specify): 9)
    "employment_4_last_12_months_10", -- During the last 12 months, did household member 11 do any additional paid or unpaid work? (Yes: 1, No: 2)
    "employment_2_number_of_months_8", -- For how many months did housedhold member 11 do this work (Missing: -99)
    "employment_3_type_of_payment_2", -- What type of payment did household member 3 get for this work? (Cash: 1, In-Kind: 2, No Pay: 3)
    "employment_3_payment_value_9", -- How much cash or in-kind payment did household member 10 get for this work? (Missing: -99)
    "employment_3_location_hh_9", -- Where did household member 10 perform this work? (Own Farm: 1, Communally Farmed Land: 2, Own Business: 3, Private Individual: 4, Government: 5, Public Work: 6, Private Firm: 7, Ngo: 8, Other (Specify): 9)
    "cultivation_1_end", -- When was the first season end (month)? (Missing: -99)
    "employment_2_location_hh_6", -- Where did household member 7 perform this work? (This Village: 1, Other Village In This Boma: 2, Other Boma: 3, Other Payam: 4, Local Town: 5, Other Town: 6, Abroad: 7)
    "irrigation_method_other", -- What method of irrigation was used (other)? (Missing: -99)
    "employment_3_by_code_last", -- Please describe household member 1 s additional work during the last 12 months. (Cultivators: 11, Farmers: 12, Cattle Sheep Goat Rearing (Livestock): 13, Fishing: 14, Lumbering: 15, Agricultural Laborers: 16, Hunters: 17, Dairying: 18, Other Agriculture: 10, Stone Cutters And Carvers (Masons).: 21, Brick Producers, Bricklayers, Carrying Mud And Other Constructions Workers.: 22, Tobacco Preparers (Saud Makers) And Tobacco Product Makers: 23, Charcoal Producers: 24, Tailors, Dress Makers, Sewers, Upholsterers, Spinners, Weavers, Knitters, Dyers And Related Workers: 25, Cobbler; Shoe Makers And Leather Goods Makers.: 26, Carpenters, Cabinet And Related Wood Workers.: 27, Blacksmith; Goldsmith.: 28, Brewers (Production Of Local Brew): 29, Other: Miners, Quarrymen, Well Drillers; Wood Paper Preparation; Chemical Processors And Related Workers; Tool Makers And Machine Tool Operators; Machinery Fitters, Machine Assemblers And Precision Instrument Makers, Jewellery And Precious Metal Workers And Metal Engravers (Except Printing); Glass Formers, Potters And Related Workers; Paper And Paper Board Products Makers; Printing And Related Workers; Other Production And Related Workers: 20, Servants; Waiters: 31, Sweepers, Cleaners; Building Caretakers.: 32, Barbers, Beauticians; Hair Dressers: 33, Launderers (Dhobi) Dry-Cleaners And Pressers.: 34, Petty Traders; Small Shop-Owners ( 10 Employees): 35, Big Shop Owner ( 10 Employees): 36, Transport Workers; Drivers; Tractor Owner; Auto Owner.: 37, Bicycle Motorcycle Auto Mechanics.: 38, Priest Religious Workers Imam: 39, Other: Hotel And Restaurant Keepers; Money Lenders, Electrical Workers.: 30, Teacher Lecturer Headmaster: 41, Health Professional; Doctor; Nurse, Midwife, Community Health Worker.: 42, Other: Scientific, And Technical Persons, Poets, Authors, Journalists And Related Workers; Sculptors, Painters, Photographers And Related Creative Artists, Composers And Performing Artists: 40, Boma Administrator Chief: 51, Clerk Administrative: Private: 52, Clerk Administrative: Government: 53, Other: Elected And Legislative Officials; Working Proprietors.: 50, Housewife: 61, Student: 62, Work Completed As Part Of Project Led By Ngo Or International Organisation.: 63, Unemployed: 64, Other: Anything That Is Not Classified Under Divisions 1-5 (Including Military Without Other Occupation Speciality And Police Officers): 60)
    "local_gov_office_travel_mode", -- How do you ususally travel to a local government office or how would you travel there if you needed to travel code 1? (Foot: 1, Bicycle: 2, Motorcycle: 3, Car: 4, Bus: 5, Other: 6)
    "employment_3_by_employer_12", -- Who is household member 13 s employer for this work? (Own Farm: 1, Communally Farmed Land: 2, Own Business: 3, Private Individual: 4, Government: 5, Public Work: 6, Private Firm: 7, Ngo: 8, Other (Specify): 9)
    "employment_2_number_of_days_9", -- How many days per month per month was household member 10 employed in this work? (Missing: -99)
    "employment_3_number_of_months_8", -- For how many months did housedhold member 9 do this work (Missing: -99)
    "employment_3_hours_per_day_7", -- How many hours per day did household member 8 do this work on the days per month per month he she worked? (Missing: -99)
    "bank_travel_mode_1", -- How do you ususally travel to a bank or how would you travel there if you needed to travel code 1? (FootMissing: 1)
    "employment_3_number_of_days_6", -- How many days per month per month was household member 7 employed in this work? (Missing: -99)
    "employment_2_payment_value_2", -- How much cash or in-kind payment did household member 3 get for this work? (Missing: -99)
    "employment_4_payment_value_6", -- How much did household member 7 get paid for this other work in total? (Missing: -99)
    "employment_3_payment_value_4", -- How much cash or in-kind payment did household member 5 get for this work? (Missing: -99)
    "employment_2_type_of_payment_2", -- What type of payment did household member 3 get for this work? (Cash: 1, In-Kind: 2, No Pay: 3)
    "lighting_source", -- What is the main source of lighting in your house (select from options)? (Electric: 1, Kerosene Gas: 2, Solar: 3, Biogas: 4, Firewood: 5, Grass: 6, Torch: 7, Candle: 8, Battery-Lit Light Bulbs: 9, No Lighting: 10, Other (Specify): 11)
    "employment_4_payment_value_4", -- How much did household member 5 get paid for this other work in total? (Missing: -99)
    "employment_3_by_employer_2", -- Who is household member 3 s employer for this work? (Own Farm: 1, Communally Farmed Land: 2, Own Business: 3, Private Individual: 4, Government: 5, Public Work: 6, Private Firm: 7, Ngo: 8, Other (Specify): 9)
    "employment_3_number_of_months_10", -- For how many months did housedhold member 11 do this work (Missing: -99)
    "employment_2_number_of_days_1", -- How many days per month per month was household member 2 employed in this work? (Missing: -99)
    "employment_3_number_of_days_2", -- How many days per month per month was household member 3 employed in this work? (Missing: -99)
    "employment_2_number_of_months_3", -- For how many months did housedhold member 6 do this work (Missing: -99)
    "employment_2_hours_per_day_2", -- How many hours per day did household member 3 do this work on the days per month per month he she worked? (Missing: -99)
    "shop_travel_time_2", -- How long does is or would it take you to get to a shop food market (minutes)? (Missing: -99)
    "employment_2_payment_period_11", -- How often did household member 12 receive payment for this work? (Day: 1, Week: 2, Month: 3, In Total: 4)
    "roof_material", -- Type of roof material (select from options)? (Tile: 1, Wood: 2, Corugated Metal: 3, Plastic Sheeting: 4, Thatched Sticks: 5, Cow Dung Mud: 6, Other (Specify): 7)
    "agr_ext_cntr_travel_mode", -- How do you ususally travel to a agriculture extension center or how would you travel there if you needed to travel code 1? (Foot: 1, Bicycle: 2, Motorcycle: 3, Car: 4, Bus: 5, Other: 6)
    "employment_3_location_hh_12", -- Where did household member 13 perform this work? (Own Farm: 1, Communally Farmed Land: 2, Own Business: 3, Private Individual: 4, Government: 5, Public Work: 6, Private Firm: 7, Ngo: 8, Other (Specify): 9)
    "feeder_road_travel_time_1", -- How long does is or would it take you to get to a feeder road (hours)? (Missing: -99)
    "livestock_ext_cntr_travel_3", -- How long does is or would it take you to get to a livestock extension center (minutes)? (Missing: -99)
    "employment_3_number_of_days_3", -- How many days per month per month was household member 4 employed in this work? (Missing: -99)
    "employment_3_type_of_payment_12", -- What type of payment did household member 13 get for this work? (Cash: 1, In-Kind: 2, No Pay: 3)
    "livestock_ext_cntr_travel_2", -- How long does is or would it take you to get to a livestock extension center (hours)? (Missing: -99)
    "employment_2_payment_value_1", -- How much cash or in-kind payment did household member 2 get for this work? (Missing: -99)
    "employment_4_payment_value_8", -- How much did household member 9 get paid for this other work in total? (Missing: -99)
    "employment_2_number_of_months_9", -- For how many months did housedhold member 12 do this work (Missing: -99)
    "farming_problem_type_6", -- Please tell us what these were in order of importance (code) (Poor Quality Soil: 1, Pest And Disease: 2, Marketing Problems: 3, Poor Infrastructure: 4, High Cost Of Inputs: 5, Lack Of Availablity Of Inputs: 6, Labor Shortages: 7, Lack Of Goodpost-Harvest Storage: 8, Drought Lack Of Rain: 9, Wild Life Problems: 10, Floods Heavy Rain: 11, Security: 12, Low Seed Germination Rate: 13, Fire: 14)
    "feddans_cultivated", -- During the last year (12 months) how many feddans of individual land were cultivated by your household? (Missing: -99)
    "bank_travel_mode_2", -- How do you ususally travel to a bank or how would you travel there if you needed to travel code 1? (Bicycle: 2, Foot: 1, Bicycle: 2, Motorcycle: 3, Car: 4, Bus: 5, Other: 6)
    "employment_3_location_hh_10", -- Where did household member 11 perform this work? (Own Farm: 1, Communally Farmed Land: 2, Own Business: 3, Private Individual: 4, Government: 5, Public Work: 6, Private Firm: 7, Ngo: 8, Other (Specify): 9)
    "employment_3_by_code_last_4", -- Please describe household member 5 s additional work during the last 12 months. (Cultivators: 11, Farmers: 12, Cattle Sheep Goat Rearing (Livestock): 13, Fishing: 14, Lumbering: 15, Agricultural Laborers: 16, Hunters: 17, Dairying: 18, Other Agriculture: 10, Stone Cutters And Carvers (Masons).: 21, Brick Producers, Bricklayers, Carrying Mud And Other Constructions Workers.: 22, Tobacco Preparers (Saud Makers) And Tobacco Product Makers: 23, Charcoal Producers: 24, Tailors, Dress Makers, Sewers, Upholsterers, Spinners, Weavers, Knitters, Dyers And Related Workers: 25, Cobbler; Shoe Makers And Leather Goods Makers.: 26, Carpenters, Cabinet And Related Wood Workers.: 27, Blacksmith; Goldsmith.: 28, Brewers (Production Of Local Brew): 29, Other: Miners, Quarrymen, Well Drillers; Wood Paper Preparation; Chemical Processors And Related Workers; Tool Makers And Machine Tool Operators; Machinery Fitters, Machine Assemblers And Precision Instrument Makers, Jewellery And Precious Metal Workers And Metal Engravers (Except Printing); Glass Formers, Potters And Related Workers; Paper And Paper Board Products Makers; Printing And Related Workers; Other Production And Related Workers: 20, Servants; Waiters: 31, Sweepers, Cleaners; Building Caretakers.: 32, Barbers, Beauticians; Hair Dressers: 33, Launderers (Dhobi) Dry-Cleaners And Pressers.: 34, Petty Traders; Small Shop-Owners ( 10 Employees): 35, Big Shop Owner ( 10 Employees): 36, Transport Workers; Drivers; Tractor Owner; Auto Owner.: 37, Bicycle Motorcycle Auto Mechanics.: 38, Priest Religious Workers Imam: 39, Other: Hotel And Restaurant Keepers; Money Lenders, Electrical Workers.: 30, Teacher Lecturer Headmaster: 41, Health Professional; Doctor; Nurse, Midwife, Community Health Worker.: 42, Other: Scientific, And Technical Persons, Poets, Authors, Journalists And Related Workers; Sculptors, Painters, Photographers And Related Creative Artists, Composers And Performing Artists: 40, Boma Administrator Chief: 51, Clerk Administrative: Private: 52, Clerk Administrative: Government: 53, Other: Elected And Legislative Officials; Working Proprietors.: 50, Housewife: 61, Student: 62, Work Completed As Part Of Project Led By Ngo Or International Organisation.: 63, Unemployed: 64, Other: Anything That Is Not Classified Under Divisions 1-5 (Including Military Without Other Occupation Speciality And Police Officers): 60)
    "employment_3_type_of_payment_4", -- What type of payment did household member 5 get for this work? (Cash: 1, In-Kind: 2, No Pay: 3)
    "bus_station_travel_mode_1", -- How do you ususally travel to a bus station bus stop or how would you travel there if you needed to travel code 1? (Foot: 1, Bicycle: 2, Motorcycle: 3, Car: 4, Bus: 5, Other: 6)
    "petrol_station_travel_time_1", -- How long does is or would it take you to get to a petrol station (minutes)? (Missing: -99)
    "employment_2_payment_period_1", -- How often did household member 2 receive payment for this work? (Day: 1, Week: 2, Month: 3, In Total: 4)
    "employment_2_number_of_days_3", -- How many days per month per month was household member 4 employed in this work? (Missing: -99)
    "employment_3_by_code_last_8", -- Please describe household member 9 s additional work during the last 12 months. (Cultivators: 11, Farmers: 12, Cattle Sheep Goat Rearing (Livestock): 13, Fishing: 14, Lumbering: 15, Agricultural Laborers: 16, Hunters: 17, Dairying: 18, Other Agriculture: 10, Stone Cutters And Carvers (Masons).: 21, Brick Producers, Bricklayers, Carrying Mud And Other Constructions Workers.: 22, Tobacco Preparers (Saud Makers) And Tobacco Product Makers: 23, Charcoal Producers: 24, Tailors, Dress Makers, Sewers, Upholsterers, Spinners, Weavers, Knitters, Dyers And Related Workers: 25, Cobbler; Shoe Makers And Leather Goods Makers.: 26, Carpenters, Cabinet And Related Wood Workers.: 27, Blacksmith; Goldsmith.: 28, Brewers (Production Of Local Brew): 29, Other: Miners, Quarrymen, Well Drillers; Wood Paper Preparation; Chemical Processors And Related Workers; Tool Makers And Machine Tool Operators; Machinery Fitters, Machine Assemblers And Precision Instrument Makers, Jewellery And Precious Metal Workers And Metal Engravers (Except Printing); Glass Formers, Potters And Related Workers; Paper And Paper Board Products Makers; Printing And Related Workers; Other Production And Related Workers: 20, Servants; Waiters: 31, Sweepers, Cleaners; Building Caretakers.: 32, Barbers, Beauticians; Hair Dressers: 33, Launderers (Dhobi) Dry-Cleaners And Pressers.: 34, Petty Traders; Small Shop-Owners ( 10 Employees): 35, Big Shop Owner ( 10 Employees): 36, Transport Workers; Drivers; Tractor Owner; Auto Owner.: 37, Bicycle Motorcycle Auto Mechanics.: 38, Priest Religious Workers Imam: 39, Other: Hotel And Restaurant Keepers; Money Lenders, Electrical Workers.: 30, Teacher Lecturer Headmaster: 41, Health Professional; Doctor; Nurse, Midwife, Community Health Worker.: 42, Other: Scientific, And Technical Persons, Poets, Authors, Journalists And Related Workers; Sculptors, Painters, Photographers And Related Creative Artists, Composers And Performing Artists: 40, Boma Administrator Chief: 51, Clerk Administrative: Private: 52, Clerk Administrative: Government: 53, Other: Elected And Legislative Officials; Working Proprietors.: 50, Housewife: 61, Student: 62, Work Completed As Part Of Project Led By Ngo Or International Organisation.: 63, Unemployed: 64, Other: Anything That Is Not Classified Under Divisions 1-5 (Including Military Without Other Occupation Speciality And Police Officers): 60)
    "hospital_travel_time_2", -- How long does is or would it take you to get to a hospital health unit (minutes)? (Missing: -99)
    "drinking_water_source", -- What is the main source of drinking water for your household (select from options)? (Piped Into Home Plot: 1, Public Tap: 2, Borehole: 3, Well: 4, River Stream: 5, Pond Lake Dam: 6, Other (Specify): 7)
    "cultivation_2_locations_amt", -- How many locations did you cultivate during this season? (Missing: -99)
    "bus_station_travel_time_2", -- How long does is or would it take you to get to a bus station bus stop (minutes)? (Missing: -99)
    "hospital_travel_mode_1", -- How do you ususally travel to a hospital health unit or how would you travel there if you needed to travel code 1? (Foot: 1, Bicycle: 2, Motorcycle: 3, Car: 4, Bus: 5, Other: 6)
    "employment_3_payment_value_7", -- How much cash or in-kind payment did household member 8 get for this work? (Missing: -99)
    "employment_2_hours_per_day_6", -- How many hours per day did household member 7 do this work on the days per month per month he she worked? (Missing: -99)
    "employment_2_payment_period", -- How often did household member 1 receive payment for this work? (Day: 1, Week: 2, Month: 3, In Total: 4)
    "employment_3_by_employer_11", -- Who is household member 12 s employer for this work? (Own Farm: 1, Communally Farmed Land: 2, Own Business: 3, Private Individual: 4, Government: 5, Public Work: 6, Private Firm: 7, Ngo: 8, Other (Specify): 9)
    "employment_3_number_of_months_5", -- For how many months did housedhold member 6 do this work (Missing: -99)
    "employment_2_payment_period_10", -- How often did household member 11 receive payment for this work? (Day: 1, Week: 2, Month: 3, In Total: 4)
    "drugstore_travel_time_1", -- How long does is or would it take you to get to a drug store (hours)? (Missing: -99)
    "employment_3_number_of_days_9", -- How many days per month per month was household member 10 employed in this work? (Missing: -99)
    "employment_3_hours_per_day_12", -- How many hours per day did household member 13 do this work on the days per month per month he she worked? (Missing: -99)
    "employment_2_hours_per_day", -- How many hours per day did household member 1 do this work on the days per month per month he she worked? (Missing: -99)
    "irrigation_method", -- What method of irrigation was used? (Private Tubewell: 1, Public Tubewell: 2, Drainage Water: 3, Natural River: 4, Tank: 5, Farm Pond: 6, Checkdam: 7, Borehole: 8, Other (Specify): 9)
    "employment_3_number_of_months_7", -- For how many months did housedhold member 8 do this work (Missing: -99)
    "employment_3_last_12_months_4", -- During the last 12 months, did household member 5 do any additional paid or unpaid work? (Yes: 1, No: 2)
    "employment_3_payment_value_8", -- How much cash or in-kind payment did household member 9 get for this work? (Missing: -99)
    "employment_3_type_of_payment_10", -- What type of payment did household member 11 get for this work? (Cash: 1, In-Kind: 2, No Pay: 3)
    "employment_2_type_of_payment_9", -- What type of payment did household member 10 get for this work? (Cash: 1, In-Kind: 2, No Pay: 3)
    "cultivation_1_locations_amt", -- How many locations did you cultivate during this season? (Missing: -99)
    "employment_2_type_of_payment_7", -- What type of payment did household member 8 get for this work? (Cash: 1, In-Kind: 2, No Pay: 3)
    "bank_travel_time_2", -- How long does is or would it take you to get to a bank (minutes)? (Missing: -99)
    "employment_4_payment_value_12", -- How much did household member 13 get paid for this other work in total? (Missing: -99)
    "employment_3_location_hh", -- Where did household member 1 perform this work? (Own Farm: 1, Communally Farmed Land: 2, Own Business: 3, Private Individual: 4, Government: 5, Public Work: 6, Private Firm: 7, Ngo: 8, Other (Specify): 9)
    "employment_3_payment_period_11", -- How often did household member 12 receive payment for this work? (Day: 1, Week: 2, Month: 3, In Total: 4)
    "employment_3_payment_period_12", -- How often did household member 13 receive payment for this work? (Day: 1, Week: 2, Month: 3, In Total: 4)
    "employment_3_number_of_months_11", -- For how many months did housedhold member 12 do this work (Missing: -99)
    "floor_material_other", -- Type of floor material (other)? (Missing: -99)
    "employment_2_payment_period_4", -- How often did household member 5 receive payment for this work? (Day: 1, Week: 2, Month: 3, In Total: 4)
    "employment_4_payment_value_3", -- How much did household member 4 get paid for this other work in total? (Missing: -99)
    "cultivation_4_locations_amt", -- How many locations did you cultivate during this season? (Missing: -99)
    "employment_2_location_hh_3", -- Where did household member 4 perform this work? (This Village: 1, Other Village In This Boma: 2, Other Boma: 3, Other Payam: 4, Local Town: 5, Other Town: 6, Abroad: 7)
    "service_travel_time_1",
    "employment_2_number_of_days_11", -- How many days per month per month was household member 12 employed in this work? (Missing: -99)
    "post_office_travel_time_1", -- How long does is or would it take you to get to a post office (hours)? (Missing: -99)
    "employment_3_number_of_months_4", -- For how many months did housedhold member 5 do this work (Missing: -99)
    "police_station_travel_time_1", -- How long does is or would it take you to get to a police station (minutes)? (Missing: -99)
    "employment_3_payment_value_5", -- How much cash or in-kind payment did household member 6 get for this work? (Missing: -99)
    "petrol_station_travel_mode", -- How do you ususally travel to a petrol station or how would you travel there if you needed to travel code 1? (Foot: 1, Bicycle: 2, Motorcycle: 3, Car: 4, Bus: 5, Other: 6)
    "employment_2_payment_value_8", -- How much cash or in-kind payment did household member 9 get for this work? (Missing: -99)
    "school_travel_mode_2", -- How do you ususally travel to a childrens school or how would you travel there if you needed to travel code 2? (Foot: 1, Bicycle: 2, Motorcycle: 3, Car: 4, Bus: 5, Other: 6)
    "employment_4_last_12_months_1", -- During the last 12 months, did household member 2 do any additional paid or unpaid work? (Yes: 1, No: 2)
    "employment_2_type_of_payment_12", -- What type of payment did household member 13 get for this work? (Cash: 1, In-Kind: 2, No Pay: 3)
    "employment_2_payment_period_8", -- How often did household member 9 receive payment for this work? (Day: 1, Week: 2, Month: 3, In Total: 4)
    "hospital_travel_mode_2", -- How do you ususally travel to a hospital health unit or how would you travel there if you needed to travel code 2? (Foot: 1, Bicycle: 2, Motorcycle: 3, Car: 4, Bus: 5, Other: 6)
    "rooms_amount", -- How many rooms are on your compound (excluding bathrooms and kitchen)? (Missing: -99)
    "employment_3_by_code_last_3", -- Please describe household member 4 s additional work during the last 12 months. (Cultivators: 11, Farmers: 12, Cattle Sheep Goat Rearing (Livestock): 13, Fishing: 14, Lumbering: 15, Agricultural Laborers: 16, Hunters: 17, Dairying: 18, Other Agriculture: 10, Stone Cutters And Carvers (Masons).: 21, Brick Producers, Bricklayers, Carrying Mud And Other Constructions Workers.: 22, Tobacco Preparers (Saud Makers) And Tobacco Product Makers: 23, Charcoal Producers: 24, Tailors, Dress Makers, Sewers, Upholsterers, Spinners, Weavers, Knitters, Dyers And Related Workers: 25, Cobbler; Shoe Makers And Leather Goods Makers.: 26, Carpenters, Cabinet And Related Wood Workers.: 27, Blacksmith; Goldsmith.: 28, Brewers (Production Of Local Brew): 29, Other: Miners, Quarrymen, Well Drillers; Wood Paper Preparation; Chemical Processors And Related Workers; Tool Makers And Machine Tool Operators; Machinery Fitters, Machine Assemblers And Precision Instrument Makers, Jewellery And Precious Metal Workers And Metal Engravers (Except Printing); Glass Formers, Potters And Related Workers; Paper And Paper Board Products Makers; Printing And Related Workers; Other Production And Related Workers: 20, Servants; Waiters: 31, Sweepers, Cleaners; Building Caretakers.: 32, Barbers, Beauticians; Hair Dressers: 33, Launderers (Dhobi) Dry-Cleaners And Pressers.: 34, Petty Traders; Small Shop-Owners ( 10 Employees): 35, Big Shop Owner ( 10 Employees): 36, Transport Workers; Drivers; Tractor Owner; Auto Owner.: 37, Bicycle Motorcycle Auto Mechanics.: 38, Priest Religious Workers Imam: 39, Other: Hotel And Restaurant Keepers; Money Lenders, Electrical Workers.: 30, Teacher Lecturer Headmaster: 41, Health Professional; Doctor; Nurse, Midwife, Community Health Worker.: 42, Other: Scientific, And Technical Persons, Poets, Authors, Journalists And Related Workers; Sculptors, Painters, Photographers And Related Creative Artists, Composers And Performing Artists: 40, Boma Administrator Chief: 51, Clerk Administrative: Private: 52, Clerk Administrative: Government: 53, Other: Elected And Legislative Officials; Working Proprietors.: 50, Housewife: 61, Student: 62, Work Completed As Part Of Project Led By Ngo Or International Organisation.: 63, Unemployed: 64, Other: Anything That Is Not Classified Under Divisions 1-5 (Including Military Without Other Occupation Speciality And Police Officers): 60)
    "service_travel_mode_1",
    "employment_3_by_employer", -- Who is household member 1 s employer for this work? (Own Farm: 1, Communally Farmed Land: 2, Own Business: 3, Private Individual: 4, Government: 5, Public Work: 6, Private Firm: 7, Ngo: 8, Other (Specify): 9)
    "employment_3_payment_period_10", -- How often did household member 11 receive payment for this work? (Day: 1, Week: 2, Month: 3, In Total: 4)
    "post_office_travel_time_2", -- How long does is or would it take you to get to a post office (minutes)? (Missing: -99)
    "employment_2_location_hh_5", -- Where did household member 6 perform this work? (This Village: 1, Other Village In This Boma: 2, Other Boma: 3, Other Payam: 4, Local Town: 5, Other Town: 6, Abroad: 7)
    "employment_2_payment_value_12", -- How much cash or in-kind payment did household member 13 get for this work? (Missing: -99)
    "employment_3_last_12_months_3", -- During the last 12 months, did household member 4 do any additional paid or unpaid work? (Yes: 1, No: 2)
    "employment_3_last_12_months_5", -- During the last 12 months, did household member 6 do any additional paid or unpaid work? (Yes: 1, No: 2)
    "employment_3_number_of_days_7", -- How many days per month per month was household member 8 employed in this work? (Missing: -99)
    "travel_to_firewood_source_1",
    "seasons_cultivated", -- During the last year (12 months), for how many seasons did you cultivate your individual land? (Missing: -99)
    "farming_problem_type_5", -- Please tell us what these were in order of importance (code) (Poor Quality Soil: 1, Pest And Disease: 2, Marketing Problems: 3, Poor Infrastructure: 4, High Cost Of Inputs: 5, Lack Of Availablity Of Inputs: 6, Labor Shortages: 7, Lack Of Goodpost-Harvest Storage: 8, Drought Lack Of Rain: 9, Wild Life Problems: 10, Floods Heavy Rain: 11, Security: 12, Low Seed Germination Rate: 13, Fire: 14)
    "employment_2_location_hh_8", -- Where did household member 9 perform this work? (This Village: 1, Other Village In This Boma: 2, Other Boma: 3, Other Payam: 4, Local Town: 5, Other Town: 6, Abroad: 7)
    "agr_ext_cntr_travel_mode_1", -- How do you ususally travel to a agriculture extension center or how would you travel there if you needed to travel code 2? (Foot: 1, Bicycle: 2, Motorcycle: 3, Car: 4, Bus: 5, Other: 6)
    "employment_3_payment_period_6", -- How often did household member 7 receive payment for this work? (Day: 1, Week: 2, Month: 3, In Total: 4)
    "service_travel_mode_2",
    "police_station_travel_time", -- How long does is or would it take you to get to a police station (hours)? (Missing: -99)
    "employment_2_number_of_months_2", -- For how many months did housedhold member 5 do this work (Missing: -99)
    "employment_4_payment_value", -- How much did household member 1 get paid for this other work in total? (Missing: -99)
    "employment_2_hours_per_day_8", -- How many hours per day did household member 9 do this work on the days per month per month he she worked? (Missing: -99)
    "employment_3_type_of_payment_7", -- What type of payment did household member 8 get for this work? (Cash: 1, In-Kind: 2, No Pay: 3)
    "employment_3_number_of_months", -- For how many months did housedhold member 1 do this work (Missing: -99)
    "employment_3_type_of_payment_8", -- What type of payment did household member 9 get for this work? (Cash: 1, In-Kind: 2, No Pay: 3)
    "firewood_travel_time_2",
    "employment_3_hours_per_day_6", -- How many hours per day did household member 7 do this work on the days per month per month he she worked? (Missing: -99)
    "employment_3_hours_per_day_5", -- How many hours per day did household member 6 do this work on the days per month per month he she worked? (Missing: -99)
    "employment_2_payment_value_3", -- How much cash or in-kind payment did household member 4 get for this work? (Missing: -99)
    "employment_3_payment_value_10", -- How much cash or in-kind payment did household member 11 get for this work? (Missing: -99)
    "employment_3_number_of_months_9", -- For how many months did housedhold member 10 do this work (Missing: -99)
    "employment_4_last_12_months_11", -- During the last 12 months, did household member 12 do any additional paid or unpaid work? (Yes: 1, No: 2)
    "drinking_water_source_other", -- What is the main source of drinking water for your household (other)? (Missing: -99)
    "employment_3_payment_value_1", -- How much cash or in-kind payment did household member 2 get for this work? (Missing: -99)
    "school_travel_time_1", -- How long does is or would it take you to get to a childrens school (hours)? (Missing: -99)
    "employment_3_type_of_payment_6", -- What type of payment did household member 7 get for this work? (Cash: 1, In-Kind: 2, No Pay: 3)
    "employment_3_payment_period_5", -- How often did household member 6 receive payment for this work? (Day: 1, Week: 2, Month: 3, In Total: 4)
    "cultivation_1_start", -- When did the first season start (month)? (Missing: -99)
    "drugstore_travel_time_2", -- How long does is or would it take you to get to a drug store (minutes)? (Missing: -99)
    "employment_2_type_of_payment", -- What type of payment did household member 1 get for this work? (Cash: 1, In-Kind: 2, No Pay: 3)
    "employment_2_number_of_days_7", -- How many days per month per month was household member 8 employed in this work? (Missing: -99)
    "employment_2_type_of_payment_11", -- What type of payment did household member 12 get for this work? (Cash: 1, In-Kind: 2, No Pay: 3)
    "employment_2_location_hh_12", -- Where did household member 13 perform this work? (This Village: 1, Other Village In This Boma: 2, Other Boma: 3, Other Payam: 4, Local Town: 5, Other Town: 6, Abroad: 7)
    "police_station_travel_mode_1", -- How do you ususally travel to a police station or how would you travel there if you needed to travel code 2? (Foot: 1, Bicycle: 2, Motorcycle: 3, Car: 4, Bus: 5, Other: 6)
    "employment_2_payment_value", -- How much cash or in-kind payment did household member 1 get for this work? (Missing: -99)
    "employment_3_number_of_months_2", -- For how many months did housedhold member 3 do this work (Missing: -99)
    "shop_travel_time_1", -- How long does is or would it take you to get to a shop food market (hours)? (Missing: -99)
    "employment_2_type_of_payment_6", -- What type of payment did household member 7 get for this work? (Cash: 1, In-Kind: 2, No Pay: 3)
    "employment_3_last_12_months_8", -- During the last 12 months, did household member 9 do any additional paid or unpaid work? (Yes: 1, No: 2)
    "shop_travel_mode_1", -- How do you ususally travel to a shop food market or how would you travel there if you needed to travel code 1? (Foot: 1, Bicycle: 2, Motorcycle: 3, Car: 4, Bus: 5, Other: 6)
    "employment_3_hours_per_day_2", -- How many hours per day did household member 3 do this work on the days per month per month he she worked? (Missing: -99)
    "employment_3_last_12_months_1", -- During the last 12 months, did household member 2 do any additional paid or unpaid work? (Yes: 1, No: 2)
    "main_road_travel_mode_1", -- How do you ususally travel to a main road or how would you travel there if you needed to travel code 1? (Foot: 1, Bicycle: 2, Motorcycle: 3, Car: 4, Bus: 5, Other: 6)
    "employment_3_number_of_days_4", -- How many days per month per month was household member 5 employed in this work? (Missing: -99)
    "employment_3_number_of_days_12", -- How many days per month per month was household member 13 employed in this work? (Missing: -99)
    "employment_2_number_of_days_8", -- How many days per month per month was household member 9 employed in this work? (Missing: -99)
    "petrol_station_travel_mode_1", -- How do you ususally travel to a petrol station or how would you travel there if you needed to travel code 2? (Foot: 1, Bicycle: 2, Motorcycle: 3, Car: 4, Bus: 5, Other: 6)
    "employment_2_payment_value_7", -- How much cash or in-kind payment did household member 8 get for this work? (Missing: -99)
    "employment_2_hours_per_day_10", -- How many hours per day did household member 11 do this work on the days per month per month he she worked? (Missing: -99)
    "employment_3_payment_period_2", -- How often did household member 3 receive payment for this work? (Day: 1, Week: 2, Month: 3, In Total: 4)
    "employment_4_last_12_months_12", -- During the last 12 months, did household member 13 do any additional paid or unpaid work? (Yes: 1, No: 2)
    "floor_material", -- Type of floor material (select from options)? (Earth Mud: 1, Concrete Flag Stone Cement: 2, Tile Bricks: 3, Wood: 4, Other: 5)
    "employment_3_payment_period", -- How often did household member 1 receive payment for this work? (Day: 1, Week: 2, Month: 3, In Total: 4)
    "employment_3_payment_value_6", -- How much cash or in-kind payment did household member 7 get for this work? (Missing: -99)
    "employment_2_payment_value_11", -- How much cash or in-kind payment did household member 12 get for this work? (Missing: -99)
    "roof_material_other", -- Type of roof material (other)? (Missing: -99)
    "employment_3_number_of_days_5", -- How many days per month per month was household member 6 employed in this work? (Missing: -99)
    "employment_2_payment_value_4", -- How much cash or in-kind payment did household member 5 get for this work? (Missing: -99)
    "employment_3_hours_per_day", -- How many hours per day did household member 1 do this work on the days per month per month he she worked? (Missing: -99)
    "employment_3_number_of_months_3", -- For how many months did housedhold member 4 do this work (Missing: -99)
    "employment_3_type_of_payment", -- What type of payment did household member 1 get for this work? (Cash: 1, In-Kind: 2, No Pay: 3)
    "employment_4_payment_value_7", -- How much did household member 8 get paid for this other work in total? (Missing: -99)
    "cultivation_3_start", -- When did the third season start (month)? (Missing: -99)
    "post_office_travel_mode_1", -- How do you ususally travel to a post office or how would you travel there if you needed to travel code 1? (Foot: 1, Bicycle: 2, Motorcycle: 3, Car: 4, Bus: 5, Other: 6)
    "employment_4_last_12_months_4", -- During the last 12 months, did household member 5 do any additional paid or unpaid work? (Yes: 1, No: 2)
    "individual_farm_land", -- Does your household have any land available for individual farming? (Yes: 1, No: 2)
    "feeder_road_travel_mode_1", -- How do you ususally travel to a feeder road or how would you travel there if you needed to travel code 1? (Foot: 1, Bicycle: 2, Motorcycle: 3, Car: 4, Bus: 5, Other: 6)
    "employment_3_hours_per_day_11", -- How many hours per day did household member 12 do this work on the days per month per month he she worked? (Missing: -99)
    "employment_3_location_hh_11", -- Where did household member 12 perform this work? (Own Farm: 1, Communally Farmed Land: 2, Own Business: 3, Private Individual: 4, Government: 5, Public Work: 6, Private Firm: 7, Ngo: 8, Other (Specify): 9)
    "employment_4_last_12_months", -- During the last 12 months, did household member 1 do any additional paid or unpaid work? (Yes: 1, No: 2)
    "employment_2_type_of_payment_5", -- What type of payment did household member 6 get for this work? (Cash: 1, In-Kind: 2, No Pay: 3)
    "main_road_travel_time_2", -- How long does is or would it take you to get to a main road (minutes)? (Missing: -99)
    "employment_3_by_code_last_12", -- Please describe household member 13 s additional work during the last 12 months. (Cultivators: 11, Farmers: 12, Cattle Sheep Goat Rearing (Livestock): 13, Fishing: 14, Lumbering: 15, Agricultural Laborers: 16, Hunters: 17, Dairying: 18, Other Agriculture: 10, Stone Cutters And Carvers (Masons).: 21, Brick Producers, Bricklayers, Carrying Mud And Other Constructions Workers.: 22, Tobacco Preparers (Saud Makers) And Tobacco Product Makers: 23, Charcoal Producers: 24, Tailors, Dress Makers, Sewers, Upholsterers, Spinners, Weavers, Knitters, Dyers And Related Workers: 25, Cobbler; Shoe Makers And Leather Goods Makers.: 26, Carpenters, Cabinet And Related Wood Workers.: 27, Blacksmith; Goldsmith.: 28, Brewers (Production Of Local Brew): 29, Other: Miners, Quarrymen, Well Drillers; Wood Paper Preparation; Chemical Processors And Related Workers; Tool Makers And Machine Tool Operators; Machinery Fitters, Machine Assemblers And Precision Instrument Makers, Jewellery And Precious Metal Workers And Metal Engravers (Except Printing); Glass Formers, Potters And Related Workers; Paper And Paper Board Products Makers; Printing And Related Workers; Other Production And Related Workers: 20, Servants; Waiters: 31, Sweepers, Cleaners; Building Caretakers.: 32, Barbers, Beauticians; Hair Dressers: 33, Launderers (Dhobi) Dry-Cleaners And Pressers.: 34, Petty Traders; Small Shop-Owners ( 10 Employees): 35, Big Shop Owner ( 10 Employees): 36, Transport Workers; Drivers; Tractor Owner; Auto Owner.: 37, Bicycle Motorcycle Auto Mechanics.: 38, Priest Religious Workers Imam: 39, Other: Hotel And Restaurant Keepers; Money Lenders, Electrical Workers.: 30, Teacher Lecturer Headmaster: 41, Health Professional; Doctor; Nurse, Midwife, Community Health Worker.: 42, Other: Scientific, And Technical Persons, Poets, Authors, Journalists And Related Workers; Sculptors, Painters, Photographers And Related Creative Artists, Composers And Performing Artists: 40, Boma Administrator Chief: 51, Clerk Administrative: Private: 52, Clerk Administrative: Government: 53, Other: Elected And Legislative Officials; Working Proprietors.: 50, Housewife: 61, Student: 62, Work Completed As Part Of Project Led By Ngo Or International Organisation.: 63, Unemployed: 64, Other: Anything That Is Not Classified Under Divisions 1-5 (Including Military Without Other Occupation Speciality And Police Officers): 60)
    "bus_station_travel_mode_2", -- How do you ususally travel to a bus station bus stop or how would you travel there if you needed to travel code 2? (Foot: 1, Bicycle: 2, Motorcycle: 3, Car: 4, Bus: 5, Other: 6)
    "employment_2_type_of_payment_1", -- What type of payment did household member 2 get for this work? (Cash: 1, In-Kind: 2, No Pay: 3)
    "feddens_cultivated_communally", -- During the last year (12 months) how many feddans of communally farmed land did your household help cultivate? (Missing: -99)
    "employment_3_payment_period_8", -- How often did household member 9 receive payment for this work? (Day: 1, Week: 2, Month: 3, In Total: 4)
    "employment_2_payment_period_2", -- How often did household member 3 receive payment for this work? (Day: 1, Week: 2, Month: 3, In Total: 4)
    "employment_3_number_of_days", -- How many days per month per month was household member 1 employed in this work? (Missing: -99)
    "employment_3_number_of_months_1", -- For how many months did housedhold member 2 do this work (Missing: -99)
    "employment_2_number_of_days_2", -- How many days per month per month was household member 3 employed in this work? (Missing: -99)
    "employment_2_payment_period_7", -- How often did household member 8 receive payment for this work? (Day: 1, Week: 2, Month: 3, In Total: 4)
    "hospital_travel_time_1", -- How long does is or would it take you to get to a hospital health unit (hours)? (Missing: -99)
    "agr_ext_cntr_travel_time", -- How long does is or would it take you to get to a agriculture extension center (hours)? (Missing: -99)
    "employment_3_by_code_last_2", -- Please describe household member 3 s additional work during the last 12 months. (Cultivators: 11, Farmers: 12, Cattle Sheep Goat Rearing (Livestock): 13, Fishing: 14, Lumbering: 15, Agricultural Laborers: 16, Hunters: 17, Dairying: 18, Other Agriculture: 10, Stone Cutters And Carvers (Masons).: 21, Brick Producers, Bricklayers, Carrying Mud And Other Constructions Workers.: 22, Tobacco Preparers (Saud Makers) And Tobacco Product Makers: 23, Charcoal Producers: 24, Tailors, Dress Makers, Sewers, Upholsterers, Spinners, Weavers, Knitters, Dyers And Related Workers: 25, Cobbler; Shoe Makers And Leather Goods Makers.: 26, Carpenters, Cabinet And Related Wood Workers.: 27, Blacksmith; Goldsmith.: 28, Brewers (Production Of Local Brew): 29, Other: Miners, Quarrymen, Well Drillers; Wood Paper Preparation; Chemical Processors And Related Workers; Tool Makers And Machine Tool Operators; Machinery Fitters, Machine Assemblers And Precision Instrument Makers, Jewellery And Precious Metal Workers And Metal Engravers (Except Printing); Glass Formers, Potters And Related Workers; Paper And Paper Board Products Makers; Printing And Related Workers; Other Production And Related Workers: 20, Servants; Waiters: 31, Sweepers, Cleaners; Building Caretakers.: 32, Barbers, Beauticians; Hair Dressers: 33, Launderers (Dhobi) Dry-Cleaners And Pressers.: 34, Petty Traders; Small Shop-Owners ( 10 Employees): 35, Big Shop Owner ( 10 Employees): 36, Transport Workers; Drivers; Tractor Owner; Auto Owner.: 37, Bicycle Motorcycle Auto Mechanics.: 38, Priest Religious Workers Imam: 39, Other: Hotel And Restaurant Keepers; Money Lenders, Electrical Workers.: 30, Teacher Lecturer Headmaster: 41, Health Professional; Doctor; Nurse, Midwife, Community Health Worker.: 42, Other: Scientific, And Technical Persons, Poets, Authors, Journalists And Related Workers; Sculptors, Painters, Photographers And Related Creative Artists, Composers And Performing Artists: 40, Boma Administrator Chief: 51, Clerk Administrative: Private: 52, Clerk Administrative: Government: 53, Other: Elected And Legislative Officials; Working Proprietors.: 50, Housewife: 61, Student: 62, Work Completed As Part Of Project Led By Ngo Or International Organisation.: 63, Unemployed: 64, Other: Anything That Is Not Classified Under Divisions 1-5 (Including Military Without Other Occupation Speciality And Police Officers): 60)
    "farming_problem", -- Did your household experience any farming problems in the last year (12 months)? (Yes: 1, No: 2)
    "employment_3_number_of_days_11", -- How many days per month per month was household member 12 employed in this work? (Missing: -99)
    "cultivation_3_end", -- When was the third season end (month)? (Missing: -99)
    "employment_3_hours_per_day_10", -- How many hours per day did household member 11 do this work on the days per month per month he she worked? (Missing: -99)
    "livestock_ext_cntr_travel", -- How do you ususally travel to a livestock extension center or how would you travel there if you needed to travel code 1? (Foot: 1, Bicycle: 2, Motorcycle: 3, Car: 4, Bus: 5, Other: 6)
    "employment_2_hours_per_day_7", -- How many hours per day did household member 8 do this work on the days per month per month he she worked? (Missing: -99)
    "toilet_type_other", -- What kind of toilet does your household have (other)? (Missing: -99)
    "employment_2_number_of_months_5", -- For how many months did housedhold member 8 do this work (Missing: -99)
    "feeder_road_travel_time_2", -- How long does is or would it take you to get to a feeder road (minutes)? (Missing: -99)
    "employment_2_payment_period_9", -- How often did household member 10 receive payment for this work? (Day: 1, Week: 2, Month: 3, In Total: 4)
    "employment_3_by_code_last_1", -- Please describe household member 2 s additional work during the last 12 months. (Cultivators: 11, Farmers: 12, Cattle Sheep Goat Rearing (Livestock): 13, Fishing: 14, Lumbering: 15, Agricultural Laborers: 16, Hunters: 17, Dairying: 18, Other Agriculture: 10, Stone Cutters And Carvers (Masons).: 21, Brick Producers, Bricklayers, Carrying Mud And Other Constructions Workers.: 22, Tobacco Preparers (Saud Makers) And Tobacco Product Makers: 23, Charcoal Producers: 24, Tailors, Dress Makers, Sewers, Upholsterers, Spinners, Weavers, Knitters, Dyers And Related Workers: 25, Cobbler; Shoe Makers And Leather Goods Makers.: 26, Carpenters, Cabinet And Related Wood Workers.: 27, Blacksmith; Goldsmith.: 28, Brewers (Production Of Local Brew): 29, Other: Miners, Quarrymen, Well Drillers; Wood Paper Preparation; Chemical Processors And Related Workers; Tool Makers And Machine Tool Operators; Machinery Fitters, Machine Assemblers And Precision Instrument Makers, Jewellery And Precious Metal Workers And Metal Engravers (Except Printing); Glass Formers, Potters And Related Workers; Paper And Paper Board Products Makers; Printing And Related Workers; Other Production And Related Workers: 20, Servants; Waiters: 31, Sweepers, Cleaners; Building Caretakers.: 32, Barbers, Beauticians; Hair Dressers: 33, Launderers (Dhobi) Dry-Cleaners And Pressers.: 34, Petty Traders; Small Shop-Owners ( 10 Employees): 35, Big Shop Owner ( 10 Employees): 36, Transport Workers; Drivers; Tractor Owner; Auto Owner.: 37, Bicycle Motorcycle Auto Mechanics.: 38, Priest Religious Workers Imam: 39, Other: Hotel And Restaurant Keepers; Money Lenders, Electrical Workers.: 30, Teacher Lecturer Headmaster: 41, Health Professional; Doctor; Nurse, Midwife, Community Health Worker.: 42, Other: Scientific, And Technical Persons, Poets, Authors, Journalists And Related Workers; Sculptors, Painters, Photographers And Related Creative Artists, Composers And Performing Artists: 40, Boma Administrator Chief: 51, Clerk Administrative: Private: 52, Clerk Administrative: Government: 53, Other: Elected And Legislative Officials; Working Proprietors.: 50, Housewife: 61, Student: 62, Work Completed As Part Of Project Led By Ngo Or International Organisation.: 63, Unemployed: 64, Other: Anything That Is Not Classified Under Divisions 1-5 (Including Military Without Other Occupation Speciality And Police Officers): 60)
    "employment_2_location_hh", -- Where did household member 1 perform this work? (This Village: 1, Other Village In This Boma: 2, Other Boma: 3, Other Payam: 4, Local Town: 5, Other Town: 6, Abroad: 7)
    "livestock_ext_cntr_travel_1", -- How do you ususally travel to a livestock extension center or how would you travel there if you needed to travel code 2? (Foot: 1, Bicycle: 2, Motorcycle: 3, Car: 4, Bus: 5, Other: 6)
    "employment_2_type_of_payment_10", -- What type of payment did household member 11 get for this work? (Cash: 1, In-Kind: 2, No Pay: 3)
    "employment_2_hours_per_day_1", -- How many hours per day did household member 2 do this work on the days per month per month he she worked? (Missing: -99)
    "employment_3_by_employer_6", -- Who is household member 7 s employer for this work? (Own Farm: 1, Communally Farmed Land: 2, Own Business: 3, Private Individual: 4, Government: 5, Public Work: 6, Private Firm: 7, Ngo: 8, Other (Specify): 9)
    "employment_3_location_hh_1", -- Where did household member 2 perform this work? (Own Farm: 1, Communally Farmed Land: 2, Own Business: 3, Private Individual: 4, Government: 5, Public Work: 6, Private Firm: 7, Ngo: 8, Other (Specify): 9)
    "communal_farming", -- During the last year (12 months), has your household helped farm any communal land? (Yes: 1, No: 2)
    "employment_2_hours_per_day_5", -- How many hours per day did household member 6 do this work on the days per month per month he she worked? (Missing: -99)
    "employment_2_payment_value_6", -- How much cash or in-kind payment did household member 7 get for this work? (Missing: -99)
    "employment_2_payment_period_6", -- How often did household member 7 receive payment for this work? (Day: 1, Week: 2, Month: 3, In Total: 4)
    "shared_toilet", -- Is this toilet shared with other households? (Yes: 1, No: 2)
    "employment_3_by_code_last_5", -- Please describe household member 6 s additional work during the last 12 months. (Cultivators: 11, Farmers: 12, Cattle Sheep Goat Rearing (Livestock): 13, Fishing: 14, Lumbering: 15, Agricultural Laborers: 16, Hunters: 17, Dairying: 18, Other Agriculture: 10, Stone Cutters And Carvers (Masons).: 21, Brick Producers, Bricklayers, Carrying Mud And Other Constructions Workers.: 22, Tobacco Preparers (Saud Makers) And Tobacco Product Makers: 23, Charcoal Producers: 24, Tailors, Dress Makers, Sewers, Upholsterers, Spinners, Weavers, Knitters, Dyers And Related Workers: 25, Cobbler; Shoe Makers And Leather Goods Makers.: 26, Carpenters, Cabinet And Related Wood Workers.: 27, Blacksmith; Goldsmith.: 28, Brewers (Production Of Local Brew): 29, Other: Miners, Quarrymen, Well Drillers; Wood Paper Preparation; Chemical Processors And Related Workers; Tool Makers And Machine Tool Operators; Machinery Fitters, Machine Assemblers And Precision Instrument Makers, Jewellery And Precious Metal Workers And Metal Engravers (Except Printing); Glass Formers, Potters And Related Workers; Paper And Paper Board Products Makers; Printing And Related Workers; Other Production And Related Workers: 20, Servants; Waiters: 31, Sweepers, Cleaners; Building Caretakers.: 32, Barbers, Beauticians; Hair Dressers: 33, Launderers (Dhobi) Dry-Cleaners And Pressers.: 34, Petty Traders; Small Shop-Owners ( 10 Employees): 35, Big Shop Owner ( 10 Employees): 36, Transport Workers; Drivers; Tractor Owner; Auto Owner.: 37, Bicycle Motorcycle Auto Mechanics.: 38, Priest Religious Workers Imam: 39, Other: Hotel And Restaurant Keepers; Money Lenders, Electrical Workers.: 30, Teacher Lecturer Headmaster: 41, Health Professional; Doctor; Nurse, Midwife, Community Health Worker.: 42, Other: Scientific, And Technical Persons, Poets, Authors, Journalists And Related Workers; Sculptors, Painters, Photographers And Related Creative Artists, Composers And Performing Artists: 40, Boma Administrator Chief: 51, Clerk Administrative: Private: 52, Clerk Administrative: Government: 53, Other: Elected And Legislative Officials; Working Proprietors.: 50, Housewife: 61, Student: 62, Work Completed As Part Of Project Led By Ngo Or International Organisation.: 63, Unemployed: 64, Other: Anything That Is Not Classified Under Divisions 1-5 (Including Military Without Other Occupation Speciality And Police Officers): 60)
    "survey_number",
    "employment_3_hours_per_day_8", -- How many hours per day did household member 9 do this work on the days per month per month he she worked? (Missing: -99)
    "employment_3_last_12_months_12", -- During the last 12 months, did household member 13 do any additional paid or unpaid work? (Yes: 1, No: 2)
    "main_road_travel_mode_2", -- How do you ususally travel to a main road or how would you travel there if you needed to travel code 2? (Foot: 1, Bicycle: 2, Motorcycle: 3, Car: 4, Bus: 5, Other: 6)
    "employment_2_payment_value_9", -- How much cash or in-kind payment did household member 10 get for this work? (Missing: -99)
    "local_gov_office_travel_time_1", -- How long does is or would it take you to get to a local government office (minutes)? (Missing: -99)
    "employment_3_type_of_payment_9", -- What type of payment did household member 10 get for this work? (Cash: 1, In-Kind: 2, No Pay: 3)
    "employment_2_number_of_days_6", -- How many days per month per month was household member 7 employed in this work? (Missing: -99)
    "employment_3_payment_value_12", -- How much cash or in-kind payment did household member 13 get for this work? (Missing: -99)
    "employment_3_location_hh_3", -- Where did household member 4 perform this work? (Own Farm: 1, Communally Farmed Land: 2, Own Business: 3, Private Individual: 4, Government: 5, Public Work: 6, Private Firm: 7, Ngo: 8, Other (Specify): 9)
    "employment_2_number_of_months_6", -- For how many months did housedhold member 9 do this work (Missing: -99)
    "employment_3_payment_value_3", -- How much cash or in-kind payment did household member 4 get for this work? (Missing: -99)
    "employment_4_last_12_months_5", -- During the last 12 months, did household member 6 do any additional paid or unpaid work? (Yes: 1, No: 2)
    "employment_2_number_of_months_7", -- For how many months did housedhold member 10 do this work (Missing: -99)
    "drugstore_travel_mode_2", -- How do you ususally travel to a drug store or how would you travel there if you needed to travel code 2? (Foot: 1, Bicycle: 2, Motorcycle: 3, Car: 4, Bus: 5, Other: 6)
    "employment_3_hours_per_day_4", -- How many hours per day did household member 5 do this work on the days per month per month he she worked? (Missing: -99)
    "employment_3_hours_per_day_1", -- How many hours per day did household member 2 do this work on the days per month per month he she worked? (Missing: -99)
    "cultivation_2_end", -- When was the second season end (month)? (Missing: -99)
    "farming_problem_type_1", -- Please tell us what these were in order of importance (code) (Poor Quality Soil: 1, Pest And Disease: 2, Marketing Problems: 3, Poor Infrastructure: 4, High Cost Of Inputs: 5, Lack Of Availablity Of Inputs: 6, Labor Shortages: 7, Lack Of Goodpost-Harvest Storage: 8, Drought Lack Of Rain: 9, Wild Life Problems: 10, Floods Heavy Rain: 11, Security: 12, Low Seed Germination Rate: 13, Fire: 14)
    "feeder_road_travel_mode_2", -- How do you ususally travel to a feeder road or how would you travel there if you needed to travel code 2? (Foot: 1, Bicycle: 2, Motorcycle: 3, Car: 4, Bus: 5, Other: 6)
    "employment_3_by_code_last_7", -- Please describe household member 8 s additional work during the last 12 months. (Cultivators: 11, Farmers: 12, Cattle Sheep Goat Rearing (Livestock): 13, Fishing: 14, Lumbering: 15, Agricultural Laborers: 16, Hunters: 17, Dairying: 18, Other Agriculture: 10, Stone Cutters And Carvers (Masons).: 21, Brick Producers, Bricklayers, Carrying Mud And Other Constructions Workers.: 22, Tobacco Preparers (Saud Makers) And Tobacco Product Makers: 23, Charcoal Producers: 24, Tailors, Dress Makers, Sewers, Upholsterers, Spinners, Weavers, Knitters, Dyers And Related Workers: 25, Cobbler; Shoe Makers And Leather Goods Makers.: 26, Carpenters, Cabinet And Related Wood Workers.: 27, Blacksmith; Goldsmith.: 28, Brewers (Production Of Local Brew): 29, Other: Miners, Quarrymen, Well Drillers; Wood Paper Preparation; Chemical Processors And Related Workers; Tool Makers And Machine Tool Operators; Machinery Fitters, Machine Assemblers And Precision Instrument Makers, Jewellery And Precious Metal Workers And Metal Engravers (Except Printing); Glass Formers, Potters And Related Workers; Paper And Paper Board Products Makers; Printing And Related Workers; Other Production And Related Workers: 20, Servants; Waiters: 31, Sweepers, Cleaners; Building Caretakers.: 32, Barbers, Beauticians; Hair Dressers: 33, Launderers (Dhobi) Dry-Cleaners And Pressers.: 34, Petty Traders; Small Shop-Owners ( 10 Employees): 35, Big Shop Owner ( 10 Employees): 36, Transport Workers; Drivers; Tractor Owner; Auto Owner.: 37, Bicycle Motorcycle Auto Mechanics.: 38, Priest Religious Workers Imam: 39, Other: Hotel And Restaurant Keepers; Money Lenders, Electrical Workers.: 30, Teacher Lecturer Headmaster: 41, Health Professional; Doctor; Nurse, Midwife, Community Health Worker.: 42, Other: Scientific, And Technical Persons, Poets, Authors, Journalists And Related Workers; Sculptors, Painters, Photographers And Related Creative Artists, Composers And Performing Artists: 40, Boma Administrator Chief: 51, Clerk Administrative: Private: 52, Clerk Administrative: Government: 53, Other: Elected And Legislative Officials; Working Proprietors.: 50, Housewife: 61, Student: 62, Work Completed As Part Of Project Led By Ngo Or International Organisation.: 63, Unemployed: 64, Other: Anything That Is Not Classified Under Divisions 1-5 (Including Military Without Other Occupation Speciality And Police Officers): 60)
    "employment_4_last_12_months_3", -- During the last 12 months, did household member 4 do any additional paid or unpaid work? (Yes: 1, No: 2)
    "employment_3_number_of_days_10", -- How many days per month per month was household member 11 employed in this work? (Missing: -99)
    "employment_4_last_12_months_9", -- During the last 12 months, did household member 10 do any additional paid or unpaid work? (Yes: 1, No: 2)
    "employment_2_location_hh_9", -- Where did household member 10 perform this work? (This Village: 1, Other Village In This Boma: 2, Other Boma: 3, Other Payam: 4, Local Town: 5, Other Town: 6, Abroad: 7)
    "employment_3_type_of_payment_1", -- What type of payment did household member 2 get for this work? (Cash: 1, In-Kind: 2, No Pay: 3)
    "school_travel_time_2", -- How long does is or would it take you to get to a childrens school (minutes)? (Missing: -99)
    "employment_3_by_employer_10", -- Who is household member 11 s employer for this work? (Own Farm: 1, Communally Farmed Land: 2, Own Business: 3, Private Individual: 4, Government: 5, Public Work: 6, Private Firm: 7, Ngo: 8, Other (Specify): 9)
    "drugstore_travel_mode_1", -- How do you ususally travel to a drug store or how would you travel there if you needed to travel code 1? (Foot: 1, Bicycle: 2, Motorcycle: 3, Car: 4, Bus: 5, Other: 6)
    "employment_2_number_of_months", -- For how many months did housedhold member 3 do this work (Missing: -99)
    "shop_travel_mode_2", -- How do you ususally travel to a shop food market or how would you travel there if you needed to travel code 2? (Foot: 1, Bicycle: 2, Motorcycle: 3, Car: 4, Bus: 5, Other: 6)
    "employment_3_last_12_months_6", -- During the last 12 months, did household member 7 do any additional paid or unpaid work? (Yes: 1, No: 2)
    "employment_3_hours_per_day_3", -- How many hours per day did household member 4 do this work on the days per month per month he she worked? (Missing: -99)
    "employment_2_number_of_days_4", -- How many days per month per month was household member 5 employed in this work? (Missing: -99)
    "school_travel_mode_1", -- How do you ususally travel to a childrens school or how would you travel there if you needed to travel code 1? (Foot: 1, Bicycle: 2, Motorcycle: 3, Car: 4, Bus: 5, Other: 6)
    "farming_problem_type_3", -- Please tell us what these were in order of importance (code) (Poor Quality Soil: 1, Pest And Disease: 2, Marketing Problems: 3, Poor Infrastructure: 4, High Cost Of Inputs: 5, Lack Of Availablity Of Inputs: 6, Labor Shortages: 7, Lack Of Goodpost-Harvest Storage: 8, Drought Lack Of Rain: 9, Wild Life Problems: 10, Floods Heavy Rain: 11, Security: 12, Low Seed Germination Rate: 13, Fire: 14)
    "employment_2_payment_value_10", -- How much cash or in-kind payment did household member 11 get for this work? (Missing: -99)
    "employment_4_payment_value_5", -- How much did household member 6 get paid for this other work in total? (Missing: -99)
    "employment_2_location_hh_1", -- Where did household member 2 perform this work? (This Village: 1, Other Village In This Boma: 2, Other Boma: 3, Other Payam: 4, Local Town: 5, Other Town: 6, Abroad: 7)
    "employment_3_payment_period_9", -- How often did household member 10 receive payment for this work? (Day: 1, Week: 2, Month: 3, In Total: 4)
    "employment_2_location_hh_2", -- Where did household member 3 perform this work? (This Village: 1, Other Village In This Boma: 2, Other Boma: 3, Other Payam: 4, Local Town: 5, Other Town: 6, Abroad: 7)
    "employment_2_number_of_days_5", -- How many days per month per month was household member 6 employed in this work? (Missing: -99)
    "employment_3_type_of_payment_5", -- What type of payment did household member 6 get for this work? (Cash: 1, In-Kind: 2, No Pay: 3)
    "crop_cultivation", -- During the last year (12 months) did your household cultivate any crop? (Yes: 1, No: 2)
    "employment_2_number_of_days_12", -- How many days per month per month was household member 13 employed in this work? (Missing: -99)
    "employment_3_type_of_payment_3", -- What type of payment did household member 4 get for this work? (Cash: 1, In-Kind: 2, No Pay: 3)
    "employment_3_last_12_months_9", -- During the last 12 months, did household member 10 do any additional paid or unpaid work? (Yes: 1, No: 2)
    "employment_3_by_employer_5", -- Who is household member 6 s employer for this work? (Own Farm: 1, Communally Farmed Land: 2, Own Business: 3, Private Individual: 4, Government: 5, Public Work: 6, Private Firm: 7, Ngo: 8, Other (Specify): 9)
    "local_gov_office_travel_mode_1", -- How do you ususally travel to a local government office or how would you travel there if you needed to travel code 2? (Foot: 1, Bicycle: 2, Motorcycle: 3, Car: 4, Bus: 5, Other: 6)
    "employment_3_by_employer_7", -- Who is household member 8 s employer for this work? (Own Farm: 1, Communally Farmed Land: 2, Own Business: 3, Private Individual: 4, Government: 5, Public Work: 6, Private Firm: 7, Ngo: 8, Other (Specify): 9)
    "employment_2_payment_value_5", -- How much cash or in-kind payment did household member 6 get for this work? (Missing: -99)
    "employment_3_by_employer_1", -- Who is household member 2 s employer for this work? (Own Farm: 1, Communally Farmed Land: 2, Own Business: 3, Private Individual: 4, Government: 5, Public Work: 6, Private Firm: 7, Ngo: 8, Other (Specify): 9)
    "employment_3_location_hh_5", -- Where did household member 6 perform this work? (Own Farm: 1, Communally Farmed Land: 2, Own Business: 3, Private Individual: 4, Government: 5, Public Work: 6, Private Firm: 7, Ngo: 8, Other (Specify): 9)
    "employment_3_last_12_months_2", -- During the last 12 months, did household member 3 do any additional paid or unpaid work? (Yes: 1, No: 2)
    "employment_3_location_hh_2", -- Where did household member 3 perform this work? (Own Farm: 1, Communally Farmed Land: 2, Own Business: 3, Private Individual: 4, Government: 5, Public Work: 6, Private Firm: 7, Ngo: 8, Other (Specify): 9)
    "employment_4_payment_value_11", -- How much did household member 12 get paid for this other work in total? (Missing: -99)
    "farming_problem_type_2", -- Please tell us what these were in order of importance (code) (Poor Quality Soil: 1, Pest And Disease: 2, Marketing Problems: 3, Poor Infrastructure: 4, High Cost Of Inputs: 5, Lack Of Availablity Of Inputs: 6, Labor Shortages: 7, Lack Of Goodpost-Harvest Storage: 8, Drought Lack Of Rain: 9, Wild Life Problems: 10, Floods Heavy Rain: 11, Security: 12, Low Seed Germination Rate: 13, Fire: 14)
    "lighting_source_other_1", -- What is the main source of lighting in your house (other category 1)? (Missing: -99)
    "employment_3_by_employer_8", -- Who is household member 9 s employer for this work? (Own Farm: 1, Communally Farmed Land: 2, Own Business: 3, Private Individual: 4, Government: 5, Public Work: 6, Private Firm: 7, Ngo: 8, Other (Specify): 9)
    "employment_2_hours_per_day_9", -- How many hours per day did household member 10 do this work on the days per month per month he she worked? (Missing: -99)
    "employment_3_payment_period_4", -- How often did household member 5 receive payment for this work? (Day: 1, Week: 2, Month: 3, In Total: 4)
    "employment_2_hours_per_day_4", -- How many hours per day did household member 5 do this work on the days per month per month he she worked? (Missing: -99)
    "employment_3_by_employer_3", -- Who is household member 4 s employer for this work? (Own Farm: 1, Communally Farmed Land: 2, Own Business: 3, Private Individual: 4, Government: 5, Public Work: 6, Private Firm: 7, Ngo: 8, Other (Specify): 9)
    "agr_ext_cntr_travel_time_1", -- How long does is or would it take you to get to a agriculture extension center (minutes)? (Missing: -99)
    "bus_station_travel_time_1" -- How long does is or would it take you to get to a bus station bus stop (hours)? (Missing: -99)
FROM
    "usaid-gov/baseline-survey-for-an-impact-evaluation-of-the-6mm5-xsxs:latest"."baseline_survey_for_an_impact_evaluation_of_the"
LIMIT 100;

Connecting to the DDN is easy. All you need is an existing SQL client that can connect to Postgres. As long as you have a SQL client ready, you'll be able to query usaid-gov/baseline-survey-for-an-impact-evaluation-of-the-6mm5-xsxs with SQL in under 60 seconds.

This repository is an "external" repository. That means it's hosted elsewhere, in this case at data.usaid.gov. When you queryusaid-gov/baseline-survey-for-an-impact-evaluation-of-the-6mm5-xsxs:latest on the DDN, we "mount" the repository using the socrata mount handler. The mount handler proxies your SQL query to the upstream data source, translating it from SQL to the relevant language (in this case SoQL).

We also cache query responses on the DDN, but we run the DDN on multiple nodes so a CACHE_HIT is only guaranteed for subsequent queries that land on the same node.

Query Your Local Engine

Install Splitgraph Locally
bash -c "$(curl -sL https://github.com/splitgraph/splitgraph/releases/latest/download/install.sh)"
 

Splitgraph Cloud is built around Splitgraph Core (GitHub), which includes a local Splitgraph Engine packaged as a Docker image. Splitgraph Cloud is basically a scaled-up version of that local Engine. When you query the Data Delivery Network or the REST API, we mount the relevant datasets in an Engine on our servers and execute your query on it.

It's possible to run this engine locally. You'll need a Mac, Windows or Linux system to install sgr, and a Docker installation to run the engine. You don't need to know how to actually use Docker; sgrcan manage the image, container and volume for you.

There are a few ways to ingest data into the local engine.

For external repositories (like this repository), the Splitgraph Engine can "mount" upstream data sources by using sgr mount. This feature is built around Postgres Foreign Data Wrappers (FDW). You can write custom "mount handlers" for any upstream data source. For an example, we blogged about making a custom mount handler for HackerNews stories.

For hosted datasets, where the author has pushed Splitgraph Images to the repository, you can "clone" and/or "checkout" the data using sgr cloneand sgr checkout.

Mounting Data

This repository is an external repository. It's not hosted by Splitgraph. It is hosted by data.usaid.gov, and Splitgraph indexes it. This means it is not an actual Splitgraph image, so you cannot use sgr clone to get the data. Instead, you can use the socrata adapter with the sgr mount command. Then, if you want, you can import the data and turn it into a Splitgraph image that others can clone.

First, install Splitgraph if you haven't already.

Mount the table with sgr mount

sgr mount socrata \
  "usaid-gov/baseline-survey-for-an-impact-evaluation-of-the-6mm5-xsxs" \
  --handler-options '{
    "domain": "data.usaid.gov",
    "tables": {
        "baseline_survey_for_an_impact_evaluation_of_the": "6mm5-xsxs"
    }
}'

That's it! Now you can query the data in the mounted table like any other Postgres table.

Query the data with your existing tools

Once you've loaded the data into your local Splitgraph engine, you can query it with any of your existing tools. As far as they're concerned, usaid-gov/baseline-survey-for-an-impact-evaluation-of-the-6mm5-xsxs is just another Postgres schema.

Related Documentation: