Query the Data Delivery Network
Query the DDNThe 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 protocol. 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-jyag-5ia6:latest"."baseline_survey_for_an_impact_evaluation_of_the"or in a full query, like:
SELECT
":id", -- Socrata column ID
"info_two_wheeled_tractor", -- During the last 12 months did you receive information on, or discuss using a two wheeled tractor with anyone? (Yes: 1, No: 2)
"info_row_planting", -- During the last 12 months did you receive information on, or discuss planting seed in rows with anyone? (Yes: 1, No: 2)
"info_broadcast_seed", -- During the last 12 months did you receive information on, or discuss broadcasting seed with anyone? (Yes: 1, No: 2)
"info_hybrid_seed", -- During the last 12 months did you receive information on, or discuss using hybrid seed with anyone? (Yes: 1, No: 2)
"info_non_opv_seed", -- During the last 12 months did you receive information on, or discuss using improved, non-opv seed with anyone? (Yes: 1, No: 2)
"consumed_quanity_other_5", -- How was the quantity measured? (Missing: CHECK CODEING)
"consumed_quanity_other_1", -- How was the quantity measured? (Missing: CHECK CODEING)
"consumed_quanity_other", -- How was the quantity measured? (Missing: CHECK CODEING)
"consumed_equipment_tools_6", -- How was the quantity of equipment tools (incl for agricultur, which was received as gift, measured? (Tonnes: 1, Kilograms: 2, Bag Sack 50Kg: 3, Bag Sack 90Kg: 4, Bag Sack 100Kg: 5, Bunch Big 30Kg: 6, Bunch Small 10Kg: 7, Basin: 8, Other (Specify): 9)
"consumed_medical_received_2", -- How was the quantity of medical expenses health care, which was received as gift, measured? (Tonnes: 1, Kilograms: 2, Bag Sack 50Kg: 3, Bag Sack 90Kg: 4, Bag Sack 100Kg: 5, Bunch Big 30Kg: 6, Bunch Small 10Kg: 7, Basin: 8, Other (Specify): 9)
"consumed_cooking_lighting_7", -- How was the quantity of cooking lighting (wood, paraffin, et, which was received as gift, measured? (Tonnes: 1, Kilograms: 2, Bag Sack 50Kg: 3, Bag Sack 90Kg: 4, Bag Sack 100Kg: 5, Bunch Big 30Kg: 6, Bunch Small 10Kg: 7, Basin: 8, Other (Specify): 9)
"consumed_alcohol_tobacco_7", -- How was the quantity of alcohol tobacco, which was received as gift, measured? (Tonnes: 1, Kilograms: 2, Bag Sack 50Kg: 3, Bag Sack 90Kg: 4, Bag Sack 100Kg: 5, Bunch Big 30Kg: 6, Bunch Small 10Kg: 7, Basin: 8, Other (Specify): 9)
"consumed_sugar_salt_received_2", -- How was the quantity of sugar salt, which was received as gift, measured? (Tonnes: 1, Kilograms: 2, Bag Sack 50Kg: 3, Bag Sack 90Kg: 4, Bag Sack 100Kg: 5, Bunch Big 30Kg: 6, Bunch Small 10Kg: 7, Basin: 8, Other (Specify): 9)
"consumed_oil_fat_butter_4", -- How was the quantity of oil, fat, butter, which was received as gift, measured? (Tonnes: 1, Kilograms: 2, Bag Sack 50Kg: 3, Bag Sack 90Kg: 4, Bag Sack 100Kg: 5, Bunch Big 30Kg: 6, Bunch Small 10Kg: 7, Basin: 8, Other (Specify): 9)
"consumed_eggs_poultry_received_2", -- How was the quantity of eggs poultry, which was received as gift, measured? (Tonnes: 1, Kilograms: 2, Bag Sack 50Kg: 3, Bag Sack 90Kg: 4, Bag Sack 100Kg: 5, Bunch Big 30Kg: 6, Bunch Small 10Kg: 7, Basin: 8, Other (Specify): 9)
"consumed_fruits_vegetables_6", -- How was the quantity of fruits and vegetables, which was received as gift, measured? (Tonnes: 1, Kilograms: 2, Bag Sack 50Kg: 3, Bag Sack 90Kg: 4, Bag Sack 100Kg: 5, Bunch Big 30Kg: 6, Bunch Small 10Kg: 7, Basin: 8, Other (Specify): 9)
"consumed_drinks_received_1", -- In the last 30 days what was the quantity of drinks - soda tea received as gift? (Missing: -99)
"consumed_fruits_vegetables_5", -- In the last 30 days what was the quantity of fruits and vegetables received as gift? (Missing: -99)
"consumed_medical_received_1", -- What was the value of the medical expenses health care received as gift? (SSP) (: -99, : -99)
"consumed_household_items_5", -- In the last 30 days did you receive any household items (soap, batteries, etc) as a as gift? (Yes: 1, No: 2)
"consumed_millet_received", -- In the last 30 days did you receive any millet as a as gift? (Yes: 1, No: 2)
"consumed_fish_received_as", -- In the last 30 days did you receive any fish as a as gift? (Yes: 1, No: 2)
"consumed_bread_received_as", -- In the last 30 days did you receive any bread as a as gift? (Yes: 1, No: 2)
"consumed_beans_received_as", -- In the last 30 days did you receive any beans as a as gift? (Yes: 1, No: 2)
"consumed_sorghum_received", -- In the last 30 days did you receive any sorghum as a as gift? (Yes: 1, No: 2)
"consumed_remittances_gifts_4", -- In the last 12 months did you receive any remittances gifts as a gift or for free? (Yes: 1, No: 2)
"consumed_household_items_4", -- What was the quantity of household items (soap, batteries, etc) purchased or bartered? (Missing: -99)
"consumed_drinks_quantity", -- What was the quantity of drinks - soda tea purchased or bartered? (Missing: -99)
"consumed_millet_quantity", -- What was the quantity of millet purchased or bartered? (Missing: -99)
"consumed_sugar_salt_quantity", -- What was the quantity of sugar salt purchased or bartered? (Missing: -99)
"consumed_meat_quantity", -- What was the quantity of meat purchased or bartered? (Missing: -99)
"consumed_fish_quantity", -- What was the quantity of fish purchased or bartered? (Missing: -99)
"consumed_fruits_vegetables_3", -- What was the quantity of fruits and vegetables purchased or bartered? (Missing: -99)
"consumed_beans_quantity", -- What was the quantity of beans purchased or bartered? (Missing: -99)
"consumed_sorghum_quantity", -- What was the quantity of sorghum purchased or bartered? (Missing: -99)
"consumed_dowry_value", -- In the last 12 months what was the value of in-kind payments made for dowry? (Missing: -99)
"consumed_celebrations_3", -- In the last 12 months what was the value of in-kind payments made for celebrations social events (weddings,? (Missing: -99)
"consumed_debt_repayment_value", -- In the last 12 months what was the value of in-kind payments made for debt repayment? (Missing: -99)
"consumed_equipment_tools_3", -- In the last 12 months what was the value of in-kind payments made for equipment tools (incl for agricultur? (Missing: -99)
"consumed_clothing_shoes_value", -- In the last 12 months what was the value of in-kind payments made for clothing shoes (not including school u? (Missing: -99)
"consumed_cooking_lighting_3", -- In the last 30 days did you purchase or barter any cooking lighting (wood, paraffin, et? (Yes: 1, No: 2)
"consumed_household_items_3", -- In the last 30 days did you purchase or barter any household items (soap, batteries, etc)? (Yes: 1, No: 2)
"consumed_oil_fat_butter", -- In the last 30 days did you purchase or barter any oil, fat, butter? (Yes: 1, No: 2)
"consumed_fish_purchased", -- In the last 30 days did you purchase or barter any fish? (Yes: 1, No: 2)
"consumed_beans_purchased", -- In the last 30 days did you purchase or barter any beans? (Yes: 1, No: 2)
"consumed_maize_purchased", -- In the last 30 days did you purchase or barter any maize? (Yes: 1, No: 2)
"consumed_celebrations_2", -- In the last 12 months how much did you spend on celebrations social events (weddings,? (Missing: -99)
"consumed_debt_repayment_spent", -- In the last 12 months how much did you spend on debt repayment? (Missing: -99)
"consumed_equipment_tools_2", -- In the last 12 months how much did you spend on equipment tools (incl for agricultur? (Missing: -99)
"consumed_clothing_shoes_spent", -- In the last 12 months how much did you spend on clothing shoes (not including school u? (Missing: -99)
"consumed_education_spent", -- In the last 12 months how much did you spend on education (books, fees, uniform)? (Missing: -99)
"consumed_transport_fuel_amt", -- What was the quantity of transport fuel consumed from own production? (Missing: -99)
"consumed_oil_fat_butter_amt", -- What was the quantity of oil, fat, butter consumed from own production? (Missing: -99)
"consumed_eggs_poultry_amt", -- What was the quantity of eggs poultry consumed from own production? (Missing: -99)
"consumed_meat_amt_from_own", -- What was the quantity of meat consumed from own production? (Missing: -99)
"consumed_fruits_vegetables_1", -- What was the quantity of fruits and vegetables consumed from own production? (Missing: -99)
"consumed_rice_amt_from_own", -- What was the quantity of rice consumed from own production? (Missing: -99)
"consumed_bread_amt_from_own", -- What was the quantity of bread consumed from own production? (Missing: -99)
"consumed_beans_amt_from_own", -- What was the quantity of beans consumed from own production? (Missing: -99)
"consumed_maize_amt_from_own", -- What was the quantity of maize consumed from own production? (Missing: -99)
"consumed_remittances_gifts_1", -- Did you pay for these remittances gifts in cash or in kind? (Yes: 1, No: 2)
"consumed_medical_cash_kind", -- Did you pay for this medical expenses health care in cash or in kind? (Yes: 1, No: 2)
"consumed_cooking_lighting_1", -- In the last 30 days did you consume any cooking lighting (wood, paraffin, etc.) from own production? (Yes: 1, No: 2)
"consumed_household_items_1", -- In the last 30 days did you consume any household items (soap, batteries, etc.) from own production? (Yes: 1, No: 2)
"consumed_drinks_own_production", -- In the last 30 days did you consume any drinks - soda tea from own production? (Yes: 1, No: 2)
"consumed_millet_own_production", -- In the last 30 days did you consume any millet from own production? (Yes: 1, No: 2)
"consumed_oil_fat_butter_own", -- In the last 30 days did you consume any oil, butter, fat from own production? (Yes: 1, No: 2)
"consumed_maize_own_production", -- In the last 30 days did you consume any maize from own production? (Yes: 1, No: 2)
"consumed_debt_repayment", -- In the past 12 months did your HH consume debt repayment? (Yes: 1, No: 2)
"consumed_construction", -- In the past 12 months did your HH consume construction house repair? (Yes: 1, No: 2)
"consumed_transport_fuel", -- In the past 30 days did your HH consume transport fuel? (Yes: 1, No: 2)
"survey_number",
"engage_in_planting_method", -- Who is the primary person to engage in method of planting (rows, broadcast, number of seeds per hole)? (Hh Head: 1, Spouse: 2, Male Adults (Age 15 ): 3, Female Adults (Age 15 ): 4, Male Children Age 0-15: 5, Female Children Age 0-15: 6, Other (Specify): 7)
"engage_in_crops_primary", -- Who is the primary person to engage in choice of crops to plant? (Hh Head: 1, Spouse: 2, Male Adults (Age 15 ): 3, Female Adults (Age 15 ): 4, Male Children Age 0-15: 5, Female Children Age 0-15: 6, Other (Specify): 7)
"decisions_on_written_records_1", -- Who is the secondary decision-maker on keeping written records of farming activities? (Hh Head: 1, Spouse: 2, Male Adults (Age 15 ): 3, Female Adults (Age 15 ): 4, Male Children Age 0-15: 5, Female Children Age 0-15: 6, Other (Specify): 7)
"decisions_on_plowing_secondary", -- Who is the secondary decision-maker on plowing? (Hh Head: 1, Spouse: 2, Male Adults (Age 15 ): 3, Female Adults (Age 15 ): 4, Male Children Age 0-15: 5, Female Children Age 0-15: 6, Other (Specify): 7)
"decisions_on_crop_storage_1", -- Who is the secondary decision-maker on how to store crops after harvest? (Hh Head: 1, Spouse: 2, Male Adults (Age 15 ): 3, Female Adults (Age 15 ): 4, Male Children Age 0-15: 5, Female Children Age 0-15: 6, Other (Specify): 7)
"decisions_on_fertilizer_1", -- Who is the secondary decision-maker on whether to use fertilizer? (Hh Head: 1, Spouse: 2, Male Adults (Age 15 ): 3, Female Adults (Age 15 ): 4, Male Children Age 0-15: 5, Female Children Age 0-15: 6, Other (Specify): 7)
"decisions_on_timing_secondary", -- Who is the secondary decision-maker on timing of planting and harvesting? (Hh Head: 1, Spouse: 2, Male Adults (Age 15 ): 3, Female Adults (Age 15 ): 4, Male Children Age 0-15: 5, Female Children Age 0-15: 6, Other (Specify): 7)
"decisions_on_weeding_primary", -- Who is the primary decision-maker on weeding ? (Hh Head: 1, Spouse: 2, Male Adults (Age 15 ): 3, Female Adults (Age 15 ): 4, Male Children Age 0-15: 5, Female Children Age 0-15: 6, Other (Specify): 7)
"decisions_on_seed_type_primary", -- Who is the primary decision-maker on type of seeds to use? (Hh Head: 1, Spouse: 2, Male Adults (Age 15 ): 3, Female Adults (Age 15 ): 4, Male Children Age 0-15: 5, Female Children Age 0-15: 6, Other (Specify): 7)
"info_ox_plow_training",
"info_fertilizer_training_1",
"info_broadcast_seed_training_1",
"info_bank_training_location",
"info_commodity_buyer_training",
"info_farther_markets_training",
"info_local_market_training",
"info_two_wheeled_tractor_4",
"info_ox_plow_training_location",
"info_fertilizer_training",
"info_fertilizer_source_3", -- Did you receive information on, or discuss applying fertilizer with anyone else? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"info_hire_labor_source_2", -- Did you receive information on, or discuss hiring labor with anyone else? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"info_improved_storage_source_1", -- Did you receive information on, or discuss using improved storage with anyone else? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"info_row_planting_source_1", -- Did you receive information on, or discuss planting seed in rows with anyone else? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"info_broadcast_seed_source_1", -- Did you receive information on, or discuss broadcasting seed with anyone else? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"info_hybrid_seed_source_2", -- Did you receive information on, or discuss using hybrid seed with anyone else? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"info_local_market_source", -- From whom did you receive information on selling farm products in the local market with anyone? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"info_planting_multiple_seeds_1", -- From whom did you receive information on planting multiple seeds per hole with anyone? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"info_broadcast_seed_source", -- From whom did you receive information on broadcasting seed with anyone? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"info_bank", -- During the last 12 months did you receive information on, or discuss keeping farm income in a bank with anyone? (Yes: 1, No: 2)
"info_farther_markets", -- During the last 12 months did you receive information on, or discuss selling farm products in farther markets with anyone? (Yes: 1, No: 2)
"info_harvested_seed", -- During the last 12 months did you receive information on, or discuss using harvested seed with anyone? (Yes: 1, No: 2)
"consumed_quanity_other_3", -- How was the quantity measured? (Missing: CHECK CODEING)
"consumed_construction_received_2", -- How was the quantity of construction house repair, which was received as gift, measured? (Tonnes: 1, Kilograms: 2, Bag Sack 50Kg: 3, Bag Sack 90Kg: 4, Bag Sack 100Kg: 5, Bunch Big 30Kg: 6, Bunch Small 10Kg: 7, Basin: 8, Other (Specify): 9)
"consumed_meat_received_as_2", -- How was the quantity of meat, which was received as gift, measured? (Tonnes: 1, Kilograms: 2, Bag Sack 50Kg: 3, Bag Sack 90Kg: 4, Bag Sack 100Kg: 5, Bunch Big 30Kg: 6, Bunch Small 10Kg: 7, Basin: 8, Other (Specify): 9)
"consumed_beans_received_as_2", -- How was the quantity of beans, which was received as gift, measured? (Tonnes: 1, Kilograms: 2, Bag Sack 50Kg: 3, Bag Sack 90Kg: 4, Bag Sack 100Kg: 5, Bunch Big 30Kg: 6, Bunch Small 10Kg: 7, Basin: 8, Other (Specify): 9)
"consumed_maize_received_as_2", -- How was the quantity of maize, which was received as gift, measured? (Tonnes: 1, Kilograms: 2, Bag Sack 50Kg: 3, Bag Sack 90Kg: 4, Bag Sack 100Kg: 5, Bunch Big 30Kg: 6, Bunch Small 10Kg: 7, Basin: 8, Other (Specify): 9)
"consumed_cooking_lighting_6", -- In the last 30 days what was the quantity of cooking lighting (wood, paraffin, et received as gift? (Missing: -99)
"consumed_millet_received_1", -- In the last 30 days what was the quantity of millet received as gift? (Missing: -99)
"consumed_dairy_received_as_1", -- In the last 30 days what was the quantity of milk and dairy products received as gift? (Missing: -99)
"consumed_oil_fat_butter_3", -- In the last 30 days what was the quantity of oil, fat, butter received as gift? (Missing: -99)
"consumed_beans_received_as_1", -- In the last 30 days what was the quantity of beans received as gift? (Missing: -99)
"consumed_dairy_received_as", -- In the last 30 days did you receive any milk and dairy products as a as gift? (Yes: 1, No: 2)
"consumed_oil_fat_butter_2", -- In the last 30 days did you receive any oil, fat, butter as a as gift? (Yes: 1, No: 2)
"consumed_celebrations_4", -- In the last 12 months did you receive any celebrations social events (weddings, as a gift or for free? (Yes: 1, No: 2)
"consumed_equipment_tools_4", -- In the last 12 months did you receive any equipment tools (incl for agricultur as a gift or for free? (Yes: 1, No: 2)
"consumed_cooking_lighting_4", -- What was the quantity of cooking lighting (wood, paraffin, et purchased or bartered? (Missing: -99)
"consumed_alcohol_tobacco_4", -- What was the quantity of alcohol tobacco purchased or bartered? (Missing: -99)
"consumed_dairy_quantity", -- What was the quantity of milk and dairy products purchased or bartered? (Missing: -99)
"consumed_rice_quantity", -- What was the quantity of rice purchased or bartered? (Missing: -99)
"consumed_bread_quantity", -- What was the quantity of bread purchased or bartered? (Missing: -99)
"consumed_maize_quantity", -- What was the quantity of maize purchased or bartered? (Missing: -99)
"consumed_medical_value", -- In the last 12 months what was the value of in-kind payments made for medical expenses health care? (Missing: -99)
"consumed_transport_fuel_1", -- In the last 30 days did you purchase or barter any transport fuel? (Yes: 1, No: 2)
"consumed_millet_purchased", -- In the last 30 days did you purchase or barter any millet? (Yes: 1, No: 2)
"consumed_meat_purchased", -- In the last 30 days did you purchase or barter any meat? (Yes: 1, No: 2)
"consumed_dowry_spent", -- In the last 12 months how much did you spend on dowry? (Missing: -99)
"consumed_cooking_lighting_2", -- What was the quantity of cooking lighting (wood, paraffin, et consumed from own production? (Missing: -99)
"consumed_drinks_amt_from", -- What was the quantity of drinks - soda tea consumed from own production? (Missing: -99)
"decisions_on_crop_sales_1", -- Who is the secondary decision-maker on where to sell crops ? (Hh Head: 1, Spouse: 2, Male Adults (Age 15 ): 3, Female Adults (Age 15 ): 4, Male Children Age 0-15: 5, Female Children Age 0-15: 6, Other (Specify): 7)
"decisions_on_harvesting_1", -- Who is the secondary decision-maker on harvesting? (Hh Head: 1, Spouse: 2, Male Adults (Age 15 ): 3, Female Adults (Age 15 ): 4, Male Children Age 0-15: 5, Female Children Age 0-15: 6, Other (Specify): 7)
"decisions_on_local_market_1", -- Who is the secondary decision-maker on taking farm products to the local market? (Hh Head: 1, Spouse: 2, Male Adults (Age 15 ): 3, Female Adults (Age 15 ): 4, Male Children Age 0-15: 5, Female Children Age 0-15: 6, Other (Specify): 7)
"decisions_on_farther_market_1", -- Who is the secondary decision-maker on taking farm products to farther market? (Hh Head: 1, Spouse: 2, Male Adults (Age 15 ): 3, Female Adults (Age 15 ): 4, Male Children Age 0-15: 5, Female Children Age 0-15: 6, Other (Specify): 7)
"engage_in_fertilizer_primary", -- Who is the primary person to engage in whether to use fertilizer? (Hh Head: 1, Spouse: 2, Male Adults (Age 15 ): 3, Female Adults (Age 15 ): 4, Male Children Age 0-15: 5, Female Children Age 0-15: 6, Other (Specify): 7)
"engage_in_crop_sales_primary", -- Who is the primary person to engage in where to sell crops ? (Hh Head: 1, Spouse: 2, Male Adults (Age 15 ): 3, Female Adults (Age 15 ): 4, Male Children Age 0-15: 5, Female Children Age 0-15: 6, Other (Specify): 7)
"engage_in_plowing_primary", -- Who is the primary person to engage in plowing? (Hh Head: 1, Spouse: 2, Male Adults (Age 15 ): 3, Female Adults (Age 15 ): 4, Male Children Age 0-15: 5, Female Children Age 0-15: 6, Other (Specify): 7)
"engage_in_planting_primary", -- Who is the primary person to engage in planting? (Hh Head: 1, Spouse: 2, Male Adults (Age 15 ): 3, Female Adults (Age 15 ): 4, Male Children Age 0-15: 5, Female Children Age 0-15: 6, Other (Specify): 7)
"consumed_millet_amt_from", -- What was the quantity of millet consumed from own production? (Missing: -99)
"consumed_fish_amt_from_own", -- What was the quantity of fish consumed from own production? (Missing: -99)
"consumed_sorghum_amt_from", -- What was the quantity of sorghum consumed from own production? (Missing: -99)
"consumed_dowry_cash_kind", -- Did you pay for this dowry in cash or in kind? (Yes: 1, No: 2)
"consumed_equipment_tools_1", -- Did you pay for this equipment tools (including for agriculture) in cash or in kind? (Yes: 1, No: 2)
"consumed_transport_fuel_own", -- In the last 30 days did you consume any transport fuel from own production? (Yes: 1, No: 2)
"consumed_fruits_vegetables", -- In the last 30 days did you consume any fruits and vegetables from own production? (Yes: 1, No: 2)
"consumed_beans_own_production", -- In the last 30 days did you consume any beans from own production? (Yes: 1, No: 2)
"consumed_remittances_gifts", -- In the past 12 months did your HH consume remittances gifts? (Yes: 1, No: 2)
"consumed_equipment_tools", -- In the past 12 months did your HH consume equipment tools (incl for agricultur? (Yes: 1, No: 2)
"consumed_medical", -- In the past 12 months did your HH consume medical expenses health care? (Yes: 1, No: 2)
"consumed_millet", -- In the past 30 days did your HH consume millet? (Yes: 1, No: 2)
"consumed_sugar_salt", -- In the past 30 days did your HH consume sugar salt? (Yes: 1, No: 2)
"consumed_sorghum_received_1", -- In the last 30 days what was the quantity of sorghum received as gift? (Missing: -99)
"consumed_dowry_received_as_1", -- How was the quantity of dowry, which was received as gift, measured? (Tonnes: 1, Kilograms: 2, Bag Sack 50Kg: 3, Bag Sack 90Kg: 4, Bag Sack 100Kg: 5, Bunch Big 30Kg: 6, Bunch Small 10Kg: 7, Basin: 8, Other (Specify): 9)
"info_commodity_buyer", -- During the last 12 months did you receive information on, or discuss selling to a commodity buyer with anyone? (Yes: 1, No: 2)
"consumed_medical_received", -- In the last 12 months did you receive any medical expenses health care as a gift or for free? (Yes: 1, No: 2)
"info_written_records_training",
"consumed_sugar_salt_received_1", -- In the last 30 days what was the quantity of sugar salt received as gift? (Missing: -99)
"info_improved_storage_training",
"decisions_on_shelling_primary", -- Who is the primary decision-maker on shelling? (Hh Head: 1, Spouse: 2, Male Adults (Age 15 ): 3, Female Adults (Age 15 ): 4, Male Children Age 0-15: 5, Female Children Age 0-15: 6, Other (Specify): 7)
"consumed_remittances_gifts_3", -- In the last 12 months what was the value of in-kind payments made for remittances gifts? (Missing: -99)
"info_planting_multiple_seeds_4",
"consumed_dowry", -- In the past 12 months did your HH consume dowry? (Yes: 1, No: 2)
"info_planting_one_seed_per_3", -- Did you receive information on, or discuss planting one seed per hole with anyone else? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"consumed_meat_received_as", -- In the last 30 days did you receive any meat as a as gift? (Yes: 1, No: 2)
"consumed_bread_own_production", -- In the last 30 days did you consume any bread from own production? (Yes: 1, No: 2)
"consumed_rice_received_as", -- In the last 30 days did you receive any rice as a as gift? (Yes: 1, No: 2)
"consumed_alcohol_tobacco_1", -- In the last 30 days did you consume any alcohol tobacco from own production? (Yes: 1, No: 2)
"decisions_on_harvesting", -- Who is the primary decision-maker on harvesting? (Hh Head: 1, Spouse: 2, Male Adults (Age 15 ): 3, Female Adults (Age 15 ): 4, Male Children Age 0-15: 5, Female Children Age 0-15: 6, Other (Specify): 7)
"consumed_debt_repayment_cash", -- Did you pay for this debt repayment in cash or in kind? (Yes: 1, No: 2)
"info_opv_seed", -- During the last 12 months did you receive information on, or discuss using improved, opv seed with anyone? (Yes: 1, No: 2)
"engage_in_timing_primary", -- Who is the primary person to engage in timing of planting and harvesting? (Hh Head: 1, Spouse: 2, Male Adults (Age 15 ): 3, Female Adults (Age 15 ): 4, Male Children Age 0-15: 5, Female Children Age 0-15: 6, Other (Specify): 7)
"consumed_quanity_other_4", -- How was the quantity measured? (Missing: CHECK CODEING)
"consumed_transport_fuel_3", -- In the last 30 days did you receive any transport fuel as a as gift? (Yes: 1, No: 2)
"info_fertilizer_source_1", -- From whom did you receive information on applying fertilizer with anyone? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"info_local_market", -- During the last 12 months did you receive information on, or discuss selling farm products in the local market with anyone? (Yes: 1, No: 2)
"consumed_millet_received_2", -- How was the quantity of millet, which was received as gift, measured? (Tonnes: 1, Kilograms: 2, Bag Sack 50Kg: 3, Bag Sack 90Kg: 4, Bag Sack 100Kg: 5, Bunch Big 30Kg: 6, Bunch Small 10Kg: 7, Basin: 8, Other (Specify): 9)
"consumed_education_received_2", -- How was the quantity of education (books, fees, uniform), which was received as gift, measured? (Tonnes: 1, Kilograms: 2, Bag Sack 50Kg: 3, Bag Sack 90Kg: 4, Bag Sack 100Kg: 5, Bunch Big 30Kg: 6, Bunch Small 10Kg: 7, Basin: 8, Other (Specify): 9)
"consumed_eggs_poultry_received_1", -- In the last 30 days what was the quantity of eggs poultry received as gift? (Missing: -99)
"info_fertilizer", -- During the last 12 months did you receive information on, or discuss applying fertilizer with anyone? (Yes: 1, No: 2)
"consumed_dairy", -- In the past 30 days did your HH consume milk and dairy products? (Yes: 1, No: 2)
"info_non_opv_seed_training_1",
"info_written_records", -- During the last 12 months did you receive information on, or discuss keeping written records of farming activities with anyone? (Yes: 1, No: 2)
"info_bank_source_3", -- Did you receive information on, or discuss keeping farm income in a bank with anyone else? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"consumed_alcohol_tobacco_3", -- In the last 30 days did you purchase or barter any alcohol tobacco? (Yes: 1, No: 2)
"consumed_rice_purchased", -- In the last 30 days did you purchase or barter any rice? (Yes: 1, No: 2)
"consumed_celebrations", -- In the past 12 months did your HH consume celebrations social events (weddings,? (Yes: 1, No: 2)
"decisions_on_weeding_secondary", -- Who is the secondary decision-maker on weeding ? (Hh Head: 1, Spouse: 2, Male Adults (Age 15 ): 3, Female Adults (Age 15 ): 4, Male Children Age 0-15: 5, Female Children Age 0-15: 6, Other (Specify): 7)
"info_source_other_2", -- Other source of information (specify) (Missing: -99)
"info_farther_markets_training_1",
"consumed_construction_cash", -- Did you pay for this construction house repair in cash or in kind? (Yes: 1, No: 2)
"consumed_drinks_received_2", -- How was the quantity of drinks - soda tea, which was received as gift, measured? (Tonnes: 1, Kilograms: 2, Bag Sack 50Kg: 3, Bag Sack 90Kg: 4, Bag Sack 100Kg: 5, Bunch Big 30Kg: 6, Bunch Small 10Kg: 7, Basin: 8, Other (Specify): 9)
"info_training_institution", -- Other instituion for training (specify) (Missing: -99)
"decisions_on_buying_supplies", -- Who is the primary decision-maker on buying farm supplies (seeds, etc)? (Hh Head: 1, Spouse: 2, Male Adults (Age 15 ): 3, Female Adults (Age 15 ): 4, Male Children Age 0-15: 5, Female Children Age 0-15: 6, Other (Specify): 7)
"consumed_education_received", -- In the last 12 months did you receive any education (books, fees, uniform) as a gift or for free? (Yes: 1, No: 2)
"decisions_on_crops_primary", -- Who is the primary decision-maker on choice of crops to plant? (Hh Head: 1, Spouse: 2, Male Adults (Age 15 ): 3, Female Adults (Age 15 ): 4, Male Children Age 0-15: 5, Female Children Age 0-15: 6, Other (Specify): 7)
"engage_in_seed_type_primary", -- Who is the primary person to engage in type of seeds to use? (Hh Head: 1, Spouse: 2, Male Adults (Age 15 ): 3, Female Adults (Age 15 ): 4, Male Children Age 0-15: 5, Female Children Age 0-15: 6, Other (Specify): 7)
"consumed_clothing_shoes_cash", -- Did you pay for this clothing shoes (not including school uniform) in cash or in kind? (Yes: 1, No: 2)
"info_hire_labor_training",
"consumed_education_value", -- In the last 12 months what was the value of in-kind payments made for education (books, fees, uniform)? (Missing: -99)
"consumed_clothing_shoes_2", -- What was the value of the clothing shoes (not including school u received as gift? (SSP) (Missing: -99)
"consumed_sugar_salt_purchased", -- In the last 30 days did you purchase or barter any sugar salt? (Yes: 1, No: 2)
"consumed_meat_own_production", -- In the last 30 days did you consume any meat from own production? (Yes: 1, No: 2)
"consumed_meat_received_as_1", -- In the last 30 days what was the quantity of meat received as gift? (Missing: -99)
"consumed_education", -- In the past 12 months did your HH consume education (books, fees, uniform)? (Yes: 1, No: 2)
"decisions_on_shelling", -- Who is the secondary decision-maker on shelling? (Hh Head: 1, Spouse: 2, Male Adults (Age 15 ): 3, Female Adults (Age 15 ): 4, Male Children Age 0-15: 5, Female Children Age 0-15: 6, Other (Specify): 7)
"consumed_dowry_received_as", -- In the last 12 months did you receive any dowry as a gift or for free? (Yes: 1, No: 2)
"consumed_debt_repayment_2", -- How was the quantity of debt repayment, which was received as gift, measured? (Tonnes: 1, Kilograms: 2, Bag Sack 50Kg: 3, Bag Sack 90Kg: 4, Bag Sack 100Kg: 5, Bunch Big 30Kg: 6, Bunch Small 10Kg: 7, Basin: 8, Other (Specify): 9)
"info_hybrid_seed_training",
"info_hybrid_seed_training_1",
"info_opv_seed_training",
"consumed_fish_received_as_1", -- In the last 30 days what was the quantity of fish received as gift? (Missing: -99)
"info_hire_labor", -- During the last 12 months did you receive information on, or discuss hiring labor with anyone? (Yes: 1, No: 2)
"consumed_education_cash_kind", -- Did you pay for this education (books, fees, uniform) in cash or in kind? (Yes: 1, No: 2)
"consumed_bread_received_as_1", -- In the last 30 days what was the quantity of bread received as gift? (Missing: -99)
"consumed_eggs_poultry_received", -- In the last 30 days did you receive any eggs poultry as a as gift? (Yes: 1, No: 2)
"decisions_on_planting_method_1", -- Who is the secondary decision-maker on method of planting (rows, broadcast, number of seeds per hole)? (Hh Head: 1, Spouse: 2, Male Adults (Age 15 ): 3, Female Adults (Age 15 ): 4, Male Children Age 0-15: 5, Female Children Age 0-15: 6, Other (Specify): 7)
"info_non_opv_seed_source_2", -- Did you receive information on, or discuss using improved, non-opv seed with anyone else? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"info_written_records_source_1", -- Did you receive information on, or discuss keeping written records of farming activities with anyone else? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"consumed_eggs_poultry_own", -- In the last 30 days did you consume any eggs poultry from own production? (Yes: 1, No: 2)
"consumed_sorghum_purchased", -- In the last 30 days did you purchase or barter any sorghum? (Yes: 1, No: 2)
"consumed_sugar_salt_received", -- In the last 30 days did you receive any sugar salt as a as gift? (Yes: 1, No: 2)
"decisions_on_planting", -- Who is the secondary decision-maker on planting? (Hh Head: 1, Spouse: 2, Male Adults (Age 15 ): 3, Female Adults (Age 15 ): 4, Male Children Age 0-15: 5, Female Children Age 0-15: 6, Other (Specify): 7)
"consumed_fruits_vegetables_4", -- In the last 30 days did you receive any fruits and vegetables as a as gift? (Yes: 1, No: 2)
"consumed_cooking_lighting", -- In the past 30 days did your HH consume cooking lighting (wood, paraffin, et? (Yes: 1, No: 2)
"info_written_records_training_1",
"consumed_transport_fuel_2", -- What was the quantity of transport fuel purchased or bartered? (Missing: -99)
"consumed_clothing_shoes", -- In the past 12 months did your HH consume clothing shoes (not including school u? (Yes: 1, No: 2)
"info_planting_one_seed_per", -- During the last 12 months did you receive information on, or discuss planting one seed per hole with anyone? (Yes: 1, No: 2)
"consumed_clothing_shoes_3", -- How was the quantity of clothing shoes (not including school u, which was received as gift, measured? (Tonnes: 1, Kilograms: 2, Bag Sack 50Kg: 3, Bag Sack 90Kg: 4, Bag Sack 100Kg: 5, Bunch Big 30Kg: 6, Bunch Small 10Kg: 7, Basin: 8, Other (Specify): 9)
"consumed_bread_purchased", -- In the last 30 days did you purchase or barter any bread? (Yes: 1, No: 2)
"consumed_rice_received_as_2", -- How was the quantity of rice, which was received as gift, measured? (Tonnes: 1, Kilograms: 2, Bag Sack 50Kg: 3, Bag Sack 90Kg: 4, Bag Sack 100Kg: 5, Bunch Big 30Kg: 6, Bunch Small 10Kg: 7, Basin: 8, Other (Specify): 9)
"consumed_household_items_6", -- In the last 30 days what was the quantity of household items (soap, batteries, etc) received as gift? (Missing: -99)
"consumed_maize_received_as_1", -- In the last 30 days what was the quantity of maize received as gift? (Missing: -99)
"consumed_sugar_salt_own", -- In the last 30 days did you consume any sugar salt from own production? (Yes: 1, No: 2)
"info_bank_source_1", -- From whom did you receive information on keeping farm income in a bank with anyone? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"consumed_remittances_gifts_5", -- How was the quantity of remittances gifts, which was received as gift, measured? (Tonnes: 1, Kilograms: 2, Bag Sack 50Kg: 3, Bag Sack 90Kg: 4, Bag Sack 100Kg: 5, Bunch Big 30Kg: 6, Bunch Small 10Kg: 7, Basin: 8, Other (Specify): 9)
"consumed_alcohol_tobacco_6", -- In the last 30 days what was the quantity of alcohol tobacco received as gift? (Missing: -99)
"consumed_transport_fuel_4", -- How was the quantity of transport fuel, which was received as gift, measured? (Tonnes: 1, Kilograms: 2, Bag Sack 50Kg: 3, Bag Sack 90Kg: 4, Bag Sack 100Kg: 5, Bunch Big 30Kg: 6, Bunch Small 10Kg: 7, Basin: 8, Other (Specify): 9)
"consumed_debt_repayment_1", -- In the last 12 months did you receive any debt repayment as a gift or for free? (Yes: 1, No: 2)
"consumed_fish_own_production", -- In the last 30 days did you consume any fish from own production? (Yes: 1, No: 2)
"consumed_alcohol_tobacco_5", -- In the last 30 days did you receive any alcohol tobacco as a as gift? (Yes: 1, No: 2)
"info_row_planting_training_1",
"info_ox_plow", -- During the last 12 months did you receive information on, or discuss using an ox plow with anyone? (Yes: 1, No: 2)
"consumed_sugar_salt_amt_from", -- What was the quantity of sugar salt consumed from own production? (Missing: -99)
"consumed_remittances_gifts_2", -- In the last 12 months how much did you spend on remittances gifts? (Missing: -99)
"info_opv_seed_source_1", -- From whom did you receive information on using improved, opv seed with anyone? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"consumed_cooking_lighting_5", -- In the last 30 days did you receive any cooking lighting (wood, paraffin, et as a as gift? (Yes: 1, No: 2)
"info_improved_storage", -- During the last 12 months did you receive information on, or discuss using improved storage with anyone? (Yes: 1, No: 2)
"consumed_alcohol_tobacco", -- In the past 30 days did your HH consume alcohol tobacco? (Yes: 1, No: 2)
"consumed_celebrations_5", -- How was the quantity of celebrations social events (weddings,, which was received as gift, measured? (Tonnes: 1, Kilograms: 2, Bag Sack 50Kg: 3, Bag Sack 90Kg: 4, Bag Sack 100Kg: 5, Bunch Big 30Kg: 6, Bunch Small 10Kg: 7, Basin: 8, Other (Specify): 9)
"consumed_dairy_amt_from_own", -- What was the quantity of milk and dairy products consumed from own production? (Missing: -99)
"consumed_drinks", -- In the past 30 days did your HH consume drinks - soda tea? (Yes: 1, No: 2)
"info_opv_seed_training_1",
"consumed_construction_received", -- In the last 12 months did you receive any construction house repair as a gift or for free? (Yes: 1, No: 2)
"consumed_household_items", -- In the past 30 days did your HH consume household items (soap, batteries, etc)? (Yes: 1, No: 2)
"consumed_celebrations_1", -- Did you pay for these celebrations social events (weddings, funerals, etc.) in cash or in kind? (Yes: 1, No: 2)
"decisions_on_buying_supplies_1", -- Who is the secondary decision-maker on buying farm supplies (seeds, etc)? (Hh Head: 1, Spouse: 2, Male Adults (Age 15 ): 3, Female Adults (Age 15 ): 4, Male Children Age 0-15: 5, Female Children Age 0-15: 6, Other (Specify): 7)
"info_planting_multiple_seeds_5",
"info_ox_plow_source_1", -- From whom did you receive information on using an ox plow with anyone? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"consumed_dairy_own_production", -- In the last 30 days did you consume any milk and dairy products from own production? (Yes: 1, No: 2)
"decisions_on_seed_type", -- Who is the secondary decision-maker on type of seeds to use? (Hh Head: 1, Spouse: 2, Male Adults (Age 15 ): 3, Female Adults (Age 15 ): 4, Male Children Age 0-15: 5, Female Children Age 0-15: 6, Other (Specify): 7)
"consumed_sorghum_received_2", -- How was the quantity of sorghum, which was received as gift, measured? (Tonnes: 1, Kilograms: 2, Bag Sack 50Kg: 3, Bag Sack 90Kg: 4, Bag Sack 100Kg: 5, Bunch Big 30Kg: 6, Bunch Small 10Kg: 7, Basin: 8, Other (Specify): 9)
"info_planting_one_seed_per_4",
"info_harvested_seed_source", -- From whom did you receive information on using harvested seed with anyone? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"consumed_fruits_vegetables_2", -- In the last 30 days did you purchase or barter any fruits and vegetables? (Yes: 1, No: 2)
"info_improved_storage_source", -- From whom did you receive information on using improved storage with anyone? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"info_broadcast_seed_training",
"consumed_eggs_poultry", -- In the last 30 days did you purchase or barter any eggs poultry? (Yes: 1, No: 2)
"consumed_maize_received_as", -- In the last 30 days did you receive any maize as a as gift? (Yes: 1, No: 2)
"consumed_sorghum_own", -- In the last 30 days did you consume any sorghum from own production? (Yes: 1, No: 2)
"info_non_opv_seed_source", -- From whom did you receive information on using improved, non-opv seed? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"consumed_eggs_poultry_quantity", -- What was the quantity of eggs poultry purchased or bartered? (Missing: -99)
"decisions_on_farther_market", -- Who is the primary decision-maker on taking farm products to farther market? (Hh Head: 1, Spouse: 2, Male Adults (Age 15 ): 3, Female Adults (Age 15 ): 4, Male Children Age 0-15: 5, Female Children Age 0-15: 6, Other (Specify): 7)
"consumed_rice_received_as_1", -- In the last 30 days what was the quantity of rice received as gift? (Missing: -99)
"info_harvested_seed_training",
"consumed_drinks_received", -- In the last 30 days did you receive any drinks - soda tea as a as gift? (Yes: 1, No: 2)
"info_hire_labor_source_1", -- From whom did you receive information on hiring labor with anyone? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"info_farther_markets_source_2", -- Did you receive information on, or discuss selling farm products in farther markets with anyone else? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"consumed_rice_own_production", -- In the last 30 days did you consume any rice from own production? (Yes: 1, No: 2)
"consumed_household_items_2", -- What was the quantity of household items (soap, batteries, etc) consumed from own production? (Missing: -99)
"info_ox_plow_source_3", -- Did you receive information on, or discuss using an ox plow with anyone else? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"consumed_clothing_shoes_1", -- In the last 12 months did you receive any clothing shoes (not including school u as a gift or for free? (Yes: 1, No: 2)
"consumed_drinks_purchased", -- In the last 30 days did you purchase or barter any drinks - soda tea? (Yes: 1, No: 2)
"decisions_on_local_market", -- Who is the primary decision-maker on taking farm products to the local market? (Hh Head: 1, Spouse: 2, Male Adults (Age 15 ): 3, Female Adults (Age 15 ): 4, Male Children Age 0-15: 5, Female Children Age 0-15: 6, Other (Specify): 7)
"consumed_dairy_purchased", -- In the last 30 days did you purchase or barter any milk and dairy products? (Yes: 1, No: 2)
"info_hire_labor_training_1",
"consumed_construction_spent", -- In the last 12 months how much did you spend on construction house repair? (Missing: -99)
"info_planting_multiple_seeds", -- During the last 12 months did you receive information on, or discuss planting multiple seeds per hole with anyone? (Yes: 1, No: 2)
"info_row_planting_source_2", -- Did you receive information on, or discuss planting seed in rows with anyone else? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"info_hybrid_seed_source_1", -- From whom did you receive information on using hybrid seed with anyone? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"info_two_wheeled_tractor_1", -- From whom did you receive information on using a two wheeled tractor with anyone? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"info_farther_markets_source_1", -- Did you receive information on, or discuss selling farm products in farther markets with anyone else? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"consumed_fish_received_as_2", -- How was the quantity of fish, which was received as gift, measured? (Tonnes: 1, Kilograms: 2, Bag Sack 50Kg: 3, Bag Sack 90Kg: 4, Bag Sack 100Kg: 5, Bunch Big 30Kg: 6, Bunch Small 10Kg: 7, Basin: 8, Other (Specify): 9)
"info_written_records_source", -- From whom did you receive information on keeping written records of farming activities with anyone? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"consumed_alcohol_tobacco_2", -- What was the quantity of alcohol tobacco consumed from own production? (Missing: -99)
"consumed_construction_value", -- In the last 12 months what was the value of in-kind payments made for construction house repair? (Missing: -99)
"info_opv_seed_source_3", -- Did you receive information on, or discuss using improved, opv seed with anyone else? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"consumed_oil_fat_butter_1", -- What was the quantity of oil, fat, butter purchased or bartered? (Missing: -99)
"consumed_education_received_1", -- What was the value of the education (books, fees, uniform) received as gift? (SSP) (Missing: -99)
"info_commodity_buyer_source_1", -- Did you receive information on, or discuss selling to a commodity buyer with anyone else? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"consumed_construction_received_1", -- What was the value of the construction house repair received as gift? (SSP) (Missing: -99)
"info_two_wheeled_tractor_3", -- Did you receive information on, or discuss using a two wheeled tractor with anyone else? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"info_opv_seed_source_2", -- Did you receive information on, or discuss using improved, opv seed with anyone else? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"info_farther_markets_source", -- From whom did you receive information on selling farm products in farther markets with anyone? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"consumed_dairy_received_as_2", -- How was the quantity of milk and dairy products, which was received as gift, measured? (Tonnes: 1, Kilograms: 2, Bag Sack 50Kg: 3, Bag Sack 90Kg: 4, Bag Sack 100Kg: 5, Bunch Big 30Kg: 6, Bunch Small 10Kg: 7, Basin: 8, Other (Specify): 9)
"info_two_wheeled_tractor_2", -- Did you receive information on, or discuss using a two wheeled tractor with anyone else? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"info_improved_storage_source_2", -- Did you receive information on, or discuss using improved storage with anyone else? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"engage_in_crop_storage_primary", -- Who is the primary person to engage in how to store crops after harvest? (Hh Head: 1, Spouse: 2, Male Adults (Age 15 ): 3, Female Adults (Age 15 ): 4, Male Children Age 0-15: 5, Female Children Age 0-15: 6, Other (Specify): 7)
"consumed_quanity_other_2", -- How was the quantity measured? (Missing: CHECK CODEING)
"decisions_on_crop_storage", -- Who is the primary decision-maker on how to store crops after harvest? (Hh Head: 1, Spouse: 2, Male Adults (Age 15 ): 3, Female Adults (Age 15 ): 4, Male Children Age 0-15: 5, Female Children Age 0-15: 6, Other (Specify): 7)
"consumed_bread_received_as_2", -- How was the quantity of bread, which was received as gift, measured? (Tonnes: 1, Kilograms: 2, Bag Sack 50Kg: 3, Bag Sack 90Kg: 4, Bag Sack 100Kg: 5, Bunch Big 30Kg: 6, Bunch Small 10Kg: 7, Basin: 8, Other (Specify): 9)
"info_row_planting_training",
"consumed_household_items_7", -- How was the quantity of household items (soap, batteries, etc), which was received as gift, measured? (Tonnes: 1, Kilograms: 2, Bag Sack 50Kg: 3, Bag Sack 90Kg: 4, Bag Sack 100Kg: 5, Bunch Big 30Kg: 6, Bunch Small 10Kg: 7, Basin: 8, Other (Specify): 9)
"decisions_on_planting_primary", -- Who is the primary decision-maker on planting? (Hh Head: 1, Spouse: 2, Male Adults (Age 15 ): 3, Female Adults (Age 15 ): 4, Male Children Age 0-15: 5, Female Children Age 0-15: 6, Other (Specify): 7)
"consumed_medical_spent", -- In the last 12 months how much did you spend on medical expenses health care? (Missing: -99)
"decisions_on_crop_sales", -- Who is the primary decision-maker on where to sell crops ? (Hh Head: 1, Spouse: 2, Male Adults (Age 15 ): 3, Female Adults (Age 15 ): 4, Male Children Age 0-15: 5, Female Children Age 0-15: 6, Other (Specify): 7)
"info_planting_multiple_seeds_3", -- Did you receive information on, or discuss planting multiple seeds per hole with anyone else? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"info_improved_storage_training_1",
"info_local_market_source_1", -- Did you receive information on, or discuss selling farm products in the local market with anyone else? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"consumed_equipment_tools_5", -- What was the value of the equipment tools (incl for agricultur received as gift? (SSP) (Missing: -99)
"decisions_on_crops_secondary", -- Who is the secondary decision-maker on choice of crops to plant? (Hh Head: 1, Spouse: 2, Male Adults (Age 15 ): 3, Female Adults (Age 15 ): 4, Male Children Age 0-15: 5, Female Children Age 0-15: 6, Other (Specify): 7)
"decisions_on_written_records", -- Who is the primary decision-maker on keeping written records of farming activities? (Hh Head: 1, Spouse: 2, Male Adults (Age 15 ): 3, Female Adults (Age 15 ): 4, Male Children Age 0-15: 5, Female Children Age 0-15: 6, Other (Specify): 7)
"decisions_on_plowing_primary", -- Who is the primary decision-maker on plowing? (Hh Head: 1, Spouse: 2, Male Adults (Age 15 ): 3, Female Adults (Age 15 ): 4, Male Children Age 0-15: 5, Female Children Age 0-15: 6, Other (Specify): 7)
"decisions_on_fertilizer", -- Who is the primary decision-maker on whether to use fertilizer? (Hh Head: 1, Spouse: 2, Male Adults (Age 15 ): 3, Female Adults (Age 15 ): 4, Male Children Age 0-15: 5, Female Children Age 0-15: 6, Other (Specify): 7)
"decisions_on_timing_primary", -- Who is the primary decision-maker on timing of planting and harvesting? (Hh Head: 1, Spouse: 2, Male Adults (Age 15 ): 3, Female Adults (Age 15 ): 4, Male Children Age 0-15: 5, Female Children Age 0-15: 6, Other (Specify): 7)
"decisions_on_planting_method", -- Who is the primary decision-maker on method of planting (rows, broadcast, number of seeds per hole)? (Hh Head: 1, Spouse: 2, Male Adults (Age 15 ): 3, Female Adults (Age 15 ): 4, Male Children Age 0-15: 5, Female Children Age 0-15: 6, Other (Specify): 7)
"info_source_other_1", -- Other source of information (specify) (Missing: -99)
"info_bank_training_institution",
"info_commodity_buyer_training_1",
"info_local_market_training_1",
"info_two_wheeled_tractor_5",
"info_planting_one_seed_per_5",
"info_harvested_seed_training_1",
"info_non_opv_seed_training",
"info_written_records_source_2", -- Did you receive information on, or discuss keeping written records of farming activities with anyone else? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"info_hire_labor_source_3", -- Did you receive information on, or discuss hiring labor with anyone else? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"info_commodity_buyer_source_2", -- Did you receive information on, or discuss selling to a commodity buyer with anyone else? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"info_local_market_source_2", -- Did you receive information on, or discuss selling farm products in the local market with anyone else? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"info_broadcast_seed_source_2", -- Did you receive information on, or discuss broadcasting seed with anyone else? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"info_harvested_seed_source_2", -- Did you receive information on, or discuss using harvested seed with anyone else? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"info_hybrid_seed_source_3", -- Did you receive information on, or discuss using hybrid seed with anyone else? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"info_bank_source_2", -- Did you receive information on, or discuss keeping farm income in a bank with anyone else? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"info_ox_plow_source_2", -- Did you receive information on, or discuss using an ox plow with anyone else? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"info_fertilizer_source_2", -- Did you receive information on, or discuss applying fertilizer with anyone else? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"info_planting_multiple_seeds_2", -- Did you receive information on, or discuss planting multiple seeds per hole with anyone else? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"info_planting_one_seed_per_2", -- Did you receive information on, or discuss planting one seed per hole with anyone else? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"info_harvested_seed_source_1", -- Did you receive information on, or discuss using harvested seed with anyone else? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"info_non_opv_seed_source_1", -- Did you receive information on, or discuss using improved, non-opv seed with anyone else? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"info_commodity_buyer_source", -- From whom did you receive information on selling to a commodity buyer with anyone? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"info_planting_one_seed_per_1", -- From whom did you receive information on planting one seed per hole with anyone? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
"info_row_planting_source" -- From whom did you receive information on planting seed in rows with anyone? (Training: 1, Farmer In Same Boma, Fbo Member: 2, Farmer In Same Boma, Not Fbo Member: 3, Farmer In Other Boma, Fbo Member: 4, Farmer In Other Boma, Not Fbo Member: 5, Govt Extension Officer: 6, Ngo Extension Officer: 7, Radio Tv Newspaper: 8, Agrodealer: 9, Other (Specify): 10)
FROM
"usaid-gov/baseline-survey-for-an-impact-evaluation-of-the-jyag-5ia6: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-jyag-5ia6 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-jyag-5ia6: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)"Read the installation docs.
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-jyag-5ia6" \
--handler-options '{
"domain": "data.usaid.gov",
"tables": {
"baseline_survey_for_an_impact_evaluation_of_the": "jyag-5ia6"
}
}'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-jyag-5ia6 is just another Postgres schema.