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-3467-jsvw:latest"."baseline_survey_for_an_impact_evaluation_of_the"or in a full query, like:
SELECT
":id", -- Socrata column ID
"own_electric_fan", -- Does your household own a(n) electric fan? (Yes: 1, No: 2)
"consumed_beans", -- In the past 30 days did your HH consume beans? (Yes: 1, No: 2)
"primary_agr_output_sold_other", -- Specify if other (Missing: -99)
"primary_agr_output_sold_to", -- To whom did you mainly sell barter your agricultural output? Please tell me who your two most important buyers were (Private Households Individuals: 1, Private Trader Enterprise: 2, Cooperative: 3, Ngo: 4, International Organization: 5, Other (Specify): 6)
"earned_from_other_source", -- How much did you earn from other (specify)? (Missing: -99)
"earned_from_livestock_raising", -- How much did you earn from livestock raising and animal products? (Missing: -99)
"earned_from_pensions", -- How much did you earn from pensions? (Missing: -99)
"earned_from_abroad_remittances", -- How much did you earn from cash from from relatives abroad (remittances)? (Missing: -99)
"earned_from_south_sudan", -- How much did you earn from cash from relatives in South Sudan (remittances)? (Missing: -99)
"earned_from_transport_porter", -- How much did you earn from transport i.e. porter pony? (Missing: -99)
"earned_from_rental_animals", -- How much did you earn from rental of animals? (Missing: -99)
"earned_from_handcrafts", -- How much did you earn from handicrafts? (Missing: -99)
"livestock_raised_ox_yr_2",
"livestock_raised_goats_yr_2",
"livestock_raised_pig_yr_2",
"livestock_raised_cow_yr_1",
"livestock_raised_other_animal_2", -- When did you obtain your other animals? (: -99, Purchased: 1, Received For Free From Ngo: 2, Received For Free From Government: 3, Received For Free From Others: 4, Received As Dowry: 5, Offspring From Other Animal: 6, Other (Specify): 7, : -99)
"livestock_raised_ox_yr", -- When did you obtain your ox bull? (: -99, Purchased: 1, Received For Free From Ngo: 2, Received For Free From Government: 3, Received For Free From Others: 4, Received As Dowry: 5, Offspring From Other Animal: 6, Other (Specify): 7, : -99)
"livestock_raised_pig_yr", -- When did you obtain your pigs? (: -99, Purchased: 1, Received For Free From Ngo: 2, Received For Free From Government: 3, Received For Free From Others: 4, Received As Dowry: 5, Offspring From Other Animal: 6, Other (Specify): 7, : -99)
"livestock_raised_cow_yr", -- When did you obtain your cows? (: -99, Purchased: 1, Received For Free From Ngo: 2, Received For Free From Government: 3, Received For Free From Others: 4, Received As Dowry: 5, Offspring From Other Animal: 6, Other (Specify): 7, : -99, : -99)
"livestock_raised_goats_amt", -- How many goats do you have now? (Missing: -99)
"livestock_raised_pig_amt", -- How many pigs do you have now? (Missing: -99)
"livestock_raised_cow", -- During the last 12 months, has any member of your household raised any cows? (Yes: 1, No: 2)
"own_blanket_selling_price", -- If you sold one of your blankets today, how much money could you get for it? (Missing: -99)
"own_glassware_selling_price", -- If you sold one of your glasswares today, how much money could you get for it? (Missing: -99)
"own_bed_selling_price_today", -- If you sold one of your beds today, how much money could you get for it? (Missing: -99)
"own_water_boiler_selling", -- If you sold one of your water boiler electric kettles today, how much money could you get for it? (Missing: -99)
"own_motorbike_selling_price", -- If you sold one of your motorbikes today, how much money could you get for it? (Missing: -99)
"own_thermo_bottle_cost", -- How much did you pay for your thermo bottle? (Missing: -99)
"own_jewellery_cost", -- How much did you pay for your jewellery (gold silver)? (Missing: -99)
"own_shoes_cost", -- How much did you pay for your shoes? (Missing: -99)
"own_glassware_cost", -- How much did you pay for your glassware? (Missing: -99)
"own_water_boiler_cost", -- How much did you pay for your water boiler electric kettle? (Missing: -99)
"own_electric_iron_cost", -- How much did you pay for your electric iron? (Missing: -99)
"own_cell_phone_cost", -- How much did you pay for your cell phone? (Missing: -99)
"own_bicycle_cost", -- How much did you pay for your bicycle? (Missing: -99)
"own_refrigerator_cost", -- How much did you pay for your refrigerator? (Missing: -99)
"own_tv_cost", -- How much did you pay for your tv? (Missing: -99)
"own_radio_cost", -- How much did you pay for your radio? (Missing: -99)
"own_mosquito_net_yr_acquired", -- In what year did you acquire your mosquito net? (Missing: -99)
"own_glassware_yr_acquired", -- In what year did you acquire your glassware? (Missing: -99)
"own_cupboard_yr_acquired", -- In what year did you acquire your cupboard? (Missing: -99)
"own_jerry_can_yr_acquired", -- In what year did you acquire your Jerry can? (Missing: -99)
"own_sewing_machine_yr_acquired", -- In what year did you acquire your sewing machine? (Missing: -99)
"own_charcoal_iron_yr_acquired", -- In what year did you acquire your charcoal iron? (Missing: -99)
"own_cell_phone_yr_acquired", -- In what year did you acquire your cell phone? (Missing: -99)
"own_tv_yr_acquired", -- In what year did you acquire your tv? (Missing: -99)
"own_thermo_bottle_amt", -- How many thermo bottles does your household own? (Missing: -99)
"own_jewellery_amt", -- How many jewellery (gold silver)s does your household own? (Missing: -99)
"own_jerry_can_amt", -- How many Jerry cans does your household own? (Missing: -99)
"own_motorbike_amt", -- How many motorbikes does your household own? (Missing: -99)
"own_tv_amt", -- How many tvs does your household own? (Missing: -99)
"own_radio_amt", -- How many radios does your household own? (Missing: -99)
"own_thermo_bottle", -- Does your household own a(n) thermo bottle? (Yes: 1, No: 2)
"own_jewellery", -- Does your household own a(n) jewellery (gold silver)? (Yes: 1, No: 2)
"own_cupboard", -- Does your household own a(n) cupboard? (Yes: 1, No: 2)
"own_water_boiler", -- Does your household own a(n) water boiler electric kettle? (Yes: 1, No: 2)
"own_electric_iron", -- Does your household own a(n) electric iron? (Yes: 1, No: 2)
"own_radio", -- Does your household own a(n) radio? (Yes: 1, No: 2)
"own_maize_mill_rent_out_total", -- How much did you obtain from leasing out your maize mill in the last 12 months? (Missing: -99)
"own_grinding_mill_rent_out_1", -- How much did you obtain from leasing out your grinding mill in the last 12 months? (Missing: -99)
"own_sprinkler_rent_out_total", -- How much did you obtain from leasing out your sprinkler in the last 12 months? (Missing: -99)
"own_groundnut_decorticator_6", -- How much did you obtain from leasing out your groundnut decorticator in the last 12 months? (Missing: -99)
"own_ox_plow_rent_out_total", -- How much did you obtain from leasing out your ox plow in the last 12 months? (Missing: -99)
"own_sprinkler_rent_out", -- Did you lease rent out any of your sprinklers during the last 12 months? (Yes: 1, No: 2)
"own_groundnut_decorticator_5", -- Did you lease rent out any of your groundnut decorticators during the last 12 months? (Yes: 1, No: 2)
"own_ox_cart_rent_out", -- Did you lease rent out any of your ox carts during the last 12 months? (Yes: 1, No: 2)
"own_rice_winnower_rent_out", -- Did you lease rent out any of your rice winnowers during the last 12 months? (Yes: 1, No: 2)
"own_electrical_water_pump_5", -- Did you lease rent out any of your electrical water pumps during the last 12 months? (Yes: 1, No: 2)
"own_diesel_water_pump_rent", -- Did you lease rent out any of your diesel water pumps during the last 12 months? (Yes: 1, No: 2)
"own_four_wheeled_tractor_5", -- Did you lease rent out any of your four wheeled tractors during the last 12 months? (Yes: 1, No: 2)
"own_rice_mill_selling_price", -- If you sold one of your If you sold one of your rice mills today, how much money could you get for it? (Missing: -99)
"own_maize_mill_selling_price", -- If you sold one of your If you sold one of your maize mills today, how much money could you get for it? (Missing: -99)
"own_thresher_selling_price", -- If you sold one of your If you sold one of your threshers today, how much money could you get for it? (Missing: -99)
"own_ox_plow_selling_price", -- If you sold one of your If you sold one of your ox plows today, how much money could you get for it? (Missing: -99)
"own_four_wheeled_tractor_4", -- If you sold one of your If you sold one of your four wheeled tractors today, how much money could you get for it? (Missing: -99)
"own_grinding_mill_cost", -- How much did you pay for your grinding mill? (Missing: -99)
"own_sprinkler_cost", -- How much did you pay for your sprinkler? (Missing: -99)
"own_groundnut_decorticator_3", -- How much did you pay for your groundnut decorticator? (Missing: -99)
"own_ox_cart_cost", -- How much did you pay for your ox cart? (Missing: -99)
"own_diesel_water_pump_cost", -- How much did you pay for your diesel water pump? (Missing: -99)
"own_ox_plow_cost", -- How much did you pay for your ox plow? (Missing: -99)
"own_four_wheeled_tractor_3", -- How much did you pay for your four wheeled tractor? (Missing: -99)
"own_maize_mill_yr_acquired", -- In what year did you acquire your maize mill? (Missing: -99)
"own_ox_cart_yr_acquired", -- In what year did you acquire your ox cart? (Missing: -99)
"own_motorized_insecticide_2", -- In what year did you acquire your motorized insecticide pump? (Missing: -99)
"own_rice_winnower_yr_acquired", -- In what year did you acquire your rice winnower? (Missing: -99)
"own_grinding_mill_amt", -- How many grinding mills does your household own? (Missing: -99)
"own_motorized_insecticide_1", -- How many motorized insecticide pumps does your household own? (Missing: -99)
"own_machine_plow_amt", -- How many machine plows does your household own? (Missing: -99)
"own_rice_mill", -- Does your household own a rice mill? (Yes: 1, No: 2)
"own_maize_mill", -- Does your household own a maize mill? (Yes: 1, No: 2)
"own_sprinkler", -- Does your household own a sprinkler? (Yes: 1, No: 2)
"own_duster", -- Does your household own a duster? (Yes: 1, No: 2)
"own_ox_cart", -- Does your household own an ox cart? (Yes: 1, No: 2)
"laborers_f_season_3_cost", -- How much did you pay for female workers in total? (season 3) (Missing: -99)
"laborers_f_season_1_cost", -- How much did you pay for female workers in total? (season 1) (Missing: -99)
"laborers_f_season_2_amt", -- How many female workers did you employ? (season 2) (Missing: -99)
"laborers_m_season_1_amt", -- How many male workers did you employ? (season 1) (Missing: -99)
"animals_leased_cost", -- How much did you spend on leasing animals in total in the last 12 months? (Missing: -99)
"animals_leased_amt", -- How many animals did you lease? (Missing: -99)
"used_other", -- Specify other input (use, qualtity, or units) (Missing: -99)
"used_petrol_cost", -- How much did you pay for petrol in total (SSP) in the last 12 months? (Missing: -99)
"used_diesel_cost", -- How much did you pay for diesel in total (SSP) in the last 12 months? (Missing: -99)
"used_pesticides_cost", -- How much did you pay for pesticides and herbicides in total (SSP) in the last 12 months? (Missing: -99)
"used_improved_seed_cost", -- How much did you pay for improved (certified) seeds in total (SSP) in the last 12 months? (Missing: -99)
"used_costs_units", -- What units were other costs (specify) measured in? (Kilograms: 1, Liters: 2, Gallons: 3, Cartloads: 4, Kilowatt Hr: 5, Other (Specify): 6)
"used_diesel_units", -- What units were diesel measured in? (Kilograms: 1, Liters: 2, Gallons: 3, Cartloads: 4, Kilowatt Hr: 5, Other (Specify): 6)
"used_pesticides_units", -- What units were pesticides and herbicides measured in? (Kilograms: 1, Liters: 2, Gallons: 3, Cartloads: 4, Kilowatt Hr: 5, Other (Specify): 6)
"used_opv_seed_units", -- What units were opv seeds measured in? (Kilograms: 1, Liters: 2, Gallons: 3, Cartloads: 4, Kilowatt Hr: 5, Other (Specify): 6)
"used_costs_quantity", -- How much other costs (specify) did you use in the last 12 months? (Missing: -99)
"used_electricity_quantity", -- How much electricity did you use in the last 12 months? (Missing: -99)
"consumed_meat", -- In the past 30 days did your HH consume meat? (Yes: 1, No: 2)
"consumed_fruits_vegetables", -- In the past 30 days did your HH consume fruits and vegetables? (Yes: 1, No: 2)
"consumed_rice", -- In the past 30 days did your HH consume rice? (Yes: 1, No: 2)
"consumed_bread", -- In the past 30 days did your HH consume bread? (Yes: 1, No: 2)
"consumed_sorghum", -- In the past 30 days did your HH consume sorghum? (Yes: 1, No: 2)
"primary_agr_output_sold_to_3", -- To whom did you mainly sell barter your agricultural output? Please tell me who your two most important buyers were (Private Households Individuals: 19, Private Trader Enterprise: 20, Cooperative: 21, Ngo: 22, International Organization: 23, Other (Specify): 24)
"earned_from_other_source_2", -- Other income source 2 (Missing: -99)
"earned_from_other_source_1", -- Other income source 1 (Missing: -99)
"earned_from_sale_of_assets", -- How much did you earn from sale of assets? (Missing: -99)
"earned_from_religious_duties", -- How much did you earn from religious duties? (Missing: -99)
"earned_from_transport_lorry", -- How much did you earn from transport lorry vehicle? (Missing: -99)
"livestock_other_means_of", -- Other way of acquiring animal (specify) (Missing: -99)
"livestock_raised_horses_4",
"livestock_raised_cow_yr_2",
"livestock_raised_ox_yr_1",
"livestock_raised_poultry_3",
"livestock_raised_sheep_yr_1",
"livestock_raised_sheep_yr", -- When did you obtain your sheep? (: -99, Purchased: 1, Received For Free From Ngo: 2, Received For Free From Government: 3, Received For Free From Others: 4, Received As Dowry: 5, Offspring From Other Animal: 6, Other (Specify): 7, : -99)
"livestock_raised_other_animal_1", -- How many other animals do you have now? (Missing: -99)
"livestock_raised_cow_amt", -- How many cows do you have now? (Missing: -99)
"livestock_raised_other_animal", -- During the last 12 months, has any member of your household raised any other animals? (Yes: 1, No: 2)
"livestock_raised_horses", -- During the last 12 months, has any member of your household raised any equine horses donkeys? (Yes: 1, No: 2)
"livestock_raised", -- Has any member of your household raised or owned livestock or poultry during the last twelve months? (Missing: -99)
"own_thermo_bottle_selling", -- If you sold one of your thermo bottles today, how much money could you get for it? (Missing: -99)
"own_cupboard_selling_price", -- If you sold one of your cupboards today, how much money could you get for it? (Missing: -99)
"own_electric_iron_selling", -- If you sold one of your electric irons today, how much money could you get for it? (Missing: -99)
"own_cell_phone_selling_price", -- If you sold one of your cell phones today, how much money could you get for it? (Missing: -99)
"own_tv_selling_price_today", -- If you sold one of your tvs today, how much money could you get for it? (Missing: -99)
"own_blanket_cost", -- How much did you pay for your blanket? (Missing: -99)
"own_cupboard_cost", -- How much did you pay for your cupboard? (Missing: -99)
"own_jerry_can_cost", -- How much did you pay for your Jerry can? (Missing: -99)
"own_electric_fan_cost", -- How much did you pay for your electric fan? (Missing: -99)
"own_car_cost", -- How much did you pay for your car? (Missing: -99)
"own_motorbike_cost", -- How much did you pay for your motorbike? (Missing: -99)
"own_thermo_bottle_yr_acquired", -- In what year did you acquire your thermo bottle? (Missing: -99)
"own_jewellery_yr_acquired", -- In what year did you acquire your jewellery (gold silver)? (Missing: -99)
"own_blanket_yr_acquired", -- In what year did you acquire your blanket? (Missing: -99)
"own_bed_yr_acquired", -- In what year did you acquire your bed? (Missing: -99)
"own_motorbike_yr_acquired", -- In what year did you acquire your motorbike? (Missing: -99)
"own_radio_yr_acquired", -- In what year did you acquire your radio? (Missing: -99)
"own_cupboard_amt", -- How many cupboards does your household own? (Missing: -99)
"own_car_amt", -- How many cars does your household own? (Missing: -99)
"own_bicycle_amt", -- How many bicycles does your household own? (Missing: -99)
"own_shoes", -- Does your household own a(n) shoes? (Yes: 1, No: 2)
"own_charcoal_iron", -- Does your household own a(n) charcoal iron? (Yes: 1, No: 2)
"own_cell_phone", -- Does your household own a(n) cell phone? (Yes: 1, No: 2)
"own_car", -- Does your household own a(n) car? (Yes: 1, No: 2)
"own_tv", -- Does your household own a(n) tv? (Yes: 1, No: 2)
"own_maize_mill_rent_out", -- Did you lease rent out any of your maize mills during the last 12 months? (Yes: 1, No: 2)
"own_groundnut_decorticator_4", -- If you sold one of your If you sold one of your groundnut decorticators today, how much money could you get for it? (Missing: -99)
"own_duster_cost", -- How much did you pay for your duster? (Missing: -99)
"own_sprinkler_amt", -- How many sprinklers does your household own? (Missing: -99)
"own_electrical_water_pump_1", -- How many electrical water pumps does your household own? (Missing: -99)
"own_ox_plow_amt", -- How many ox plows does your household own? (Missing: -99)
"own_four_wheeled_tractor_1", -- How many four wheeled tractors does your household own? (Missing: -99)
"own_two_wheeled_tractor_amt", -- How many two wheeled tractors does your household own? (Missing: -99)
"own_groundnut_decorticator", -- Does your household own a groundnut decorticator? (Yes: 1, No: 2)
"laborers_c_season_2_cost", -- How much did you pay for children workers in total? (season 2) (Missing: -99)
"laborers_f_season_2_cost", -- How much did you pay for female workers in total? (season 2) (Missing: -99)
"laborers_f_season_3_amt", -- How many female workers did you employ? (season 3) (Missing: -99)
"laborers_f_season_1_amt", -- How many female workers did you employ? (season 1) (Missing: -99)
"used_interest_on_agr_loans_2", -- How much did you pay for interest on agric. loans in total (SSP) in the last 12 months? (Missing: -99)
"used_fertilizer_units", -- What units were fertiliser measured in? (Kilograms: 1, Liters: 2, Gallons: 3, Cartloads: 4, Kilowatt Hr: 5, Other (Specify): 6)
"used_interest_on_agr_loans", -- How much interest on agric. loans did you use in the last 12 months? (Missing: -99)
"livestock_raised_horses_2", -- When did you obtain your equine horses donkeys? (: -99, Purchased: 1, Received For Free From Ngo: 2, Received For Free From Government: 3, Received For Free From Others: 4, Received As Dowry: 5, Offspring From Other Animal: 6, Other (Specify): 7, : -99)
"own_diesel_water_pump", -- Does your household own a diesel water pump? (Yes: 1, No: 2)
"own_hand_pump_rent_out", -- Did you lease rent out any of your hand pumps during the last 12 months? (Yes: 1, No: 2)
"own_electrical_water_pump", -- Does your household own a electrical water pump? (Yes: 1, No: 2)
"own_rice_mill_rent_out_total", -- How much did you obtain from leasing out your rice mill in the last 12 months? (Missing: -99)
"own_two_wheeled_tractor_rent", -- Did you lease rent out any of your two wheeled tractors during the last 12 months? (Yes: 1, No: 2)
"own_rice_mill_rent_out", -- Did you lease rent out any of your rice mills during the last 12 months? (Yes: 1, No: 2)
"own_thresher_cost", -- How much did you pay for your thresher? (Missing: -99)
"own_electrical_water_pump_6", -- How much did you obtain from leasing out your electrical water pump in the last 12 months? (Missing: -99)
"livestock_raised_ox", -- During the last 12 months, has any member of your household raised any ox bull? (Yes: 1, No: 2)
"own_machine_plow_cost", -- How much did you pay for your machine plow ? (Missing: -99)
"livestock_raised_sheep_amt", -- How many sheep do you have now? (Missing: -99)
"own_rice_winnower_selling", -- If you sold one of your If you sold one of your rice winnowers today, how much money could you get for it? (Missing: -99)
"own_hand_pump_cost", -- How much did you pay for your hand pump? (Missing: -99)
"own_machine_plow_rent_out_1", -- How much did you obtain from leasing out your machine plow in the last 12 months? (Missing: -99)
"own_ox_cart_amt", -- How many ox carts does your household own? (Missing: -99)
"laborers", -- Did you employ any casual labor in the last year (12 months)? (Yes: 1, No: 2)
"own_ox_cart_rent_out_total", -- How much did you obtain from leasing out your ox cart in the last 12 months? (Missing: -99)
"own_four_wheeled_tractor", -- Does your household own a four wheeled tractor? (Yes: 1, No: 2)
"used_petrol_units", -- What units were petrol measured in? (Kilograms: 1, Liters: 2, Gallons: 3, Cartloads: 4, Kilowatt Hr: 5, Other (Specify): 6)
"own_grinding_mill_selling", -- If you sold one of your If you sold one of your grinding mills today, how much money could you get for it? (Missing: -99)
"own_rice_winnower", -- Does your household own a rice winnower? (Yes: 1, No: 2)
"own_rice_mill_cost", -- How much did you pay for your rice mill? (Missing: -99)
"laborers_c_season_1_amt", -- How many children under 15 did you employ? (season 1) (Missing: -99)
"own_maize_mill_cost", -- How much did you pay for your maize mill? (Missing: -99)
"own_rice_winnower_rent_out_1", -- How much did you obtain from leasing out your rice winnower in the last 12 months? (Missing: -99)
"own_diesel_water_pump_selling", -- If you sold one of your If you sold one of your diesel water pumps today, how much money could you get for it? (Missing: -99)
"own_ox_cart_selling_price", -- If you sold one of your If you sold one of your ox carts today, how much money could you get for it? (Missing: -99)
"own_refrigerator_amt", -- How many refrigerators does your household own? (Missing: -99)
"used_interest_on_agr_loans_1", -- What units were interest on agric. loans measured in? (Kilograms: 1, Liters: 2, Gallons: 3, Cartloads: 4, Kilowatt Hr: 5, Other (Specify): 6)
"livestock_raised_pig_yr_1",
"earned_from_inheritance", -- How much did you earn from income from inheritance? (Missing: -99)
"consumed_eggs_poultry", -- In the past 30 days did your HH consume eggs poultry? (Yes: 1, No: 2)
"used_electricity_units", -- What units were electricity measured in? (Kilograms: 1, Liters: 2, Gallons: 3, Cartloads: 4, Kilowatt Hr: 5, Other (Specify): 6)
"own_mosquito_net_cost", -- How much did you pay for your mosquito net? (Missing: -99)
"own_four_wheeled_tractor_6", -- How much did you obtain from leasing out your four wheeled tractor in the last 12 months? (Missing: -99)
"own_ox_plow_rent_out", -- Did you lease rent out any of your ox plows during the last 12 months? (Yes: 1, No: 2)
"own_four_wheeled_tractor_2", -- In what year did you acquire your four wheeled tractor? (Missing: -99)
"own_two_wheeled_tractor_cost", -- How much did you pay for your two wheeled tractor ? (Missing: -99)
"primary_agr_output_sold_to_2", -- To whom did you mainly sell barter your agricultural output? Please tell me who your two most important buyers were (Private Households Individuals: 13, Private Trader Enterprise: 14, Cooperative: 15, Ngo: 16, International Organization: 17, Other (Specify): 18)
"own_maize_mill_amt", -- How many maize mills does your household own? (Missing: -99)
"own_two_wheeled_tractor_yr", -- In what year did you acquire your two wheeled tractor ? (Missing: -99)
"own_thresher", -- Does your household own a thresher? (Yes: 1, No: 2)
"laborers_m_season_3_amt", -- How many male workers did you employ? (season 3) (Missing: -99)
"used_manure_units", -- What units were manure measured in? (Kilograms: 1, Liters: 2, Gallons: 3, Cartloads: 4, Kilowatt Hr: 5, Other (Specify): 6)
"livestock_raised_cow_yr_3",
"own_electrical_water_pump_4", -- If you sold one of your If you sold one of your electrical water pumps today, how much money could you get for it? (Missing: -99)
"own_ox_plow", -- Does your household own a ox plow? (Yes: 1, No: 2)
"own_rice_mill_amt", -- How many rice mills does your household own? (Missing: -99)
"own_motorized_insecticide", -- Does your household own a motorized insecticide pump? (Yes: 1, No: 2)
"earned_from_rental_farm", -- How much did you earn from rental of farming equipment? (Missing: -99)
"own_car_yr_acquired", -- In what year did you acquire your car? (Missing: -99)
"own_glassware", -- Does your household own a(n) glassware? (Yes: 1, No: 2)
"own_duster_selling_price", -- If you sold one of your If you sold one of your dusters today, how much money could you get for it? (Missing: -99)
"own_rice_winnower_cost", -- How much did you pay for your rice winnower? (Missing: -99)
"own_bed", -- Does your household own a(n) bed? (Yes: 1, No: 2)
"own_motorized_insecticide_5", -- Did you lease rent out any of your motorized insecticide pumps during the last 12 months? (Yes: 1, No: 2)
"own_thresher_yr_acquired", -- In what year did you acquire your thresher? (Missing: -99)
"used_electricity_cost", -- How much did you pay for electricity in total (SSP) in the last 12 months? (Missing: -99)
"own_sewing_machine", -- Does your household own a(n) sewing machine? (Yes: 1, No: 2)
"own_electric_iron_amt", -- How many electric irons does your household own? (Missing: -99)
"own_hand_pump_amt", -- How many hand pumps does your household own? (Missing: -99)
"own_motorized_insecticide_6", -- How much did you obtain from leasing out your motorized insecticide pump in the last 12 months? (Missing: -99)
"laborers_c_season_3_amt", -- How many children under 15 did you employ? (season 3) (Missing: -99)
"own_motorbike", -- Does your household own a(n) motorbike? (Yes: 1, No: 2)
"own_blanket", -- Does your household own a(n) blanket? (Yes: 1, No: 2)
"own_jerry_can", -- Does your household own a(n) Jerry can? (Yes: 1, No: 2)
"own_charcoal_iron_amt", -- How many charcoal irons does your household own? (Missing: -99)
"own_hand_pump", -- Does your household own a hand pump? (Yes: 1, No: 2)
"own_motorized_insecticide_3", -- How much did you pay for your motorized insecticide pump? (Missing: -99)
"own_electric_fan_yr_acquired", -- In what year did you acquire your electric fan? (Missing: -99)
"consumed_maize", -- In the past 30 days did your HH consume maize? (Yes: 1, No: 2)
"own_duster_yr_acquired", -- In what year did you acquire your duster? (Missing: -99)
"primary_agr_output_sold_to_4", -- To whom did you mainly sell barter your agricultural output? Please tell me who your two most important buyers were (Private Households Individuals: 25, Private Trader Enterprise: 26, Cooperative: 27, Ngo: 28, International Organization: 29, Other (Specify): 30)
"own_rice_mill_yr_acquired", -- In what year did you acquire your rice mill? (Missing: -99)
"own_electric_fan_selling", -- If you sold one of your electric fans today, how much money could you get for it? (Missing: -99)
"own_mosquito_net", -- Does your household own a(n) mosquito net? (Yes: 1, No: 2)
"own_grinding_mill", -- Does your household own a grinding mill? (Yes: 1, No: 2)
"livestock_raised_pig", -- During the last 12 months, has any member of your household raised any pigs? (Yes: 1, No: 2)
"own_two_wheeled_tractor_1", -- If you sold one of your If you sold one of your two wheeled tractors today, how much money could you get for it? (Missing: -99)
"own_electrical_water_pump_3", -- How much did you pay for your electrical water pump? (Missing: -99)
"own_machine_plow_rent_out", -- Did you lease rent out any of your machine plows during the last 12 months? (Yes: 1, No: 2)
"own_thresher_rent_out", -- Did you lease rent out any of your threshers during the last 12 months? (Yes: 1, No: 2)
"own_electric_iron_yr_acquired", -- In what year did you acquire your electric iron? (Missing: -99)
"own_duster_rent_out_total", -- How much did you obtain from leasing out your duster in the last 12 months? (Missing: -99)
"animals_leased", -- Did you lease any draft animals during the last 12 months? (Yes: 1, No: 2)
"used_manure_cost", -- How much did you pay for manure in total (SSP) in the last 12 months? (Missing: -99)
"laborers_c_season_3_cost", -- How much did you pay for children workers in total? (season 3) (Missing: -99)
"used_costs_1",
"used_improved_seed_units", -- What units were improved (certified) seeds measured in? (Kilograms: 1, Liters: 2, Gallons: 3, Cartloads: 4, Kilowatt Hr: 5, Other (Specify): 6)
"own_mosquito_net_selling", -- If you sold one of your mosquito nets today, how much money could you get for it? (Missing: -99)
"own_machine_plow", -- Does your household own a machine plow ? (Yes: 1, No: 2)
"own_motorized_insecticide_4", -- If you sold one of your If you sold one of your motorized insecticide pumps today, how much money could you get for it? (Missing: -99)
"livestock_raised_horses_3",
"own_jewellery_selling_price", -- If you sold one of your jewellery (gold silver)s today, how much money could you get for it? (Missing: -99)
"own_thresher_amt", -- How many threshers does your household own? (Missing: -99)
"own_sewing_machine_amt", -- How many sewing machines does your household own? (Missing: -99)
"used_hybrid_seed_units", -- What units were hybrid seeds measured in? (Kilograms: 1, Liters: 2, Gallons: 3, Cartloads: 4, Kilowatt Hr: 5, Other (Specify): 6)
"own_duster_amt", -- How many dusters does your household own? (Missing: -99)
"own_refrigerator_yr_acquired", -- In what year did you acquire your refrigerator? (Missing: -99)
"livestock_raised_poultry", -- During the last 12 months, has any member of your household raised any poultry? (Yes: 1, No: 2)
"own_bed_amt", -- How many beds does your household own? (Missing: -99)
"own_two_wheeled_tractor_rent_1", -- How much did you obtain from leasing out your two wheeled tractor in the last 12 months? (Missing: -99)
"own_rice_winnower_amt", -- How many rice winnowers does your household own? (Missing: -99)
"own_duster_rent_out", -- Did you lease rent out any of your dusters during the last 12 months? (Yes: 1, No: 2)
"own_grinding_mill_rent_out", -- Did you lease rent out any of your grinding mills during the last 12 months? (Yes: 1, No: 2)
"livestock_raised_goats", -- During the last 12 months, has any member of your household raised any goats? (Yes: 1, No: 2)
"own_hand_pump_yr_acquired", -- In what year did you acquire your hand pump? (Missing: -99)
"own_water_boiler_amt", -- How many water boiler electric kettles does your household own? (Missing: -99)
"own_groundnut_decorticator_1", -- How many groundnut decorticators does your household own? (Missing: -99)
"own_diesel_water_pump_amt", -- How many diesel water pumps does your household own? (Missing: -99)
"own_thresher_rent_out_total", -- How much did you obtain from leasing out your thresher in the last 12 months? (Missing: -99)
"own_electric_fan_amt", -- How many electric fans does your household own? (Missing: -99)
"own_groundnut_decorticator_2", -- In what year did you acquire your groundnut decorticator? (Missing: -99)
"livestock_raised_goats_yr_1",
"own_cell_phone_amt", -- How many cell phones does your household own? (Missing: -99)
"own_ox_plow_yr_acquired", -- In what year did you acquire your ox plow? (Missing: -99)
"own_machine_plow_selling", -- If you sold one of your If you sold one of your machine plows today, how much money could you get for it? (Missing: -99)
"own_refrigerator", -- Does your household own a(n) refrigerator? (Yes: 1, No: 2)
"own_diesel_water_pump_rent_1", -- How much did you obtain from leasing out your diesel water pump in the last 12 months? (Missing: -99)
"laborers_m_season_2_cost", -- How much did you pay for male workers in total? (season 2) (Missing: -99)
"primary_agr_output_sold_to_5", -- To whom did you mainly sell barter your agricultural output? Please tell me who your two most important buyers were (Private Households Individuals: 31, Private Trader Enterprise: 32, Cooperative: 33, Ngo: 34, International Organization: 35, Other (Specify): 36)
"own_diesel_water_pump_yr", -- In what year did you acquire your diesel water pump? (Missing: -99)
"livestock_raised_sheep", -- During the last 12 months, has any member of your household raised any sheep? (Yes: 1, No: 2)
"own_electrical_water_pump_2", -- In what year did you acquire your electrical water pump? (Missing: -99)
"livestock_raised_other_animal_4",
"own_refrigerator_selling", -- If you sold one of your refrigerators today, how much money could you get for it? (Missing: -99)
"consumed_fish", -- In the past 30 days did your HH consume fish? (Yes: 1, No: 2)
"own_sewing_machine_selling", -- If you sold one of your sewing machines today, how much money could you get for it? (Missing: -99)
"own_bicycle", -- Does your household own a(n) bicycle? (Yes: 1, No: 2)
"own_machine_plow_yr_acquired", -- In what year did you acquire your machine plow ? (Missing: -99)
"livestock_raised_horses_1", -- How many equine horses donkeys do you have now? (Missing: -99)
"own_two_wheeled_tractor", -- Does your household own a two wheeled tractor ? (Yes: 1, No: 2)
"earned_from_dowry", -- How much did you earn from dowry? (Missing: -99)
"livestock_raised_sheep_yr_2",
"earned_from_gifts_or_charity", -- How much did you earn from gifts charity? (Missing: -99)
"own_radio_selling_price_today", -- If you sold one of your radios today, how much money could you get for it? (Missing: -99)
"livestock_raised_poultry_2", -- When did you obtain your poultry? (: -99, Purchased: 1, Received For Free From Ngo: 2, Received For Free From Government: 3, Received For Free From Others: 4, Received As Dowry: 5, Offspring From Other Animal: 6, Other (Specify): 7, : -99)
"own_sprinkler_selling_price", -- If you sold one of your If you sold one of your sprinklers today, how much money could you get for it? (Missing: -99)
"consumed_oil_fat_butter", -- In the past 30 days did your HH consume oil, fat, butter? (Yes: 1, No: 2)
"livestock_raised_goats_yr", -- When did you obtain your goats? (: -99, Purchased: 1, Received For Free From Ngo: 2, Received For Free From Government: 3, Received For Free From Others: 4, Received As Dowry: 5, Offspring From Other Animal: 6, Other (Specify): 7, : -99)
"livestock_raised_poultry_1", -- How many poultry do you have now? (Missing: -99)
"own_charcoal_iron_cost", -- How much did you pay for your charcoal iron? (Missing: -99)
"own_bicycle_selling_price", -- If you sold one of your bicycles today, how much money could you get for it? (Missing: -99)
"own_hand_pump_selling_price", -- If you sold one of your If you sold one of your hand pumps today, how much money could you get for it? (Missing: -99)
"own_sewing_machine_cost", -- How much did you pay for your sewing machine? (Missing: -99)
"laborers_m_season_1_cost", -- How much did you pay for male workers in total? (season 1) (Missing: -99)
"livestock_raised_poultry_4",
"primary_agr_output_sold_to_1", -- To whom did you mainly sell barter your agricultural output? Please tell me who your two most important buyers were (Private Households Individuals: 7, Private Trader Enterprise: 8, Cooperative: 9, Ngo: 10, International Organization: 11, Other (Specify): 12)
"own_blanket_amt", -- How many blankets does your household own? (Missing: -99)
"used_hybrid_seed_cost", -- How much did you pay for hybrid seeds in total (SSP) in the last 12 months? (Missing: -99)
"own_shoes_selling_price_today", -- If you sold one of your shoess today, how much money could you get for it? (Missing: -99)
"own_mosquito_net_amt", -- How many mosquito nets does your household own? (Missing: -99)
"own_glassware_amt", -- How many glasswares does your household own? (Missing: -99)
"used_opv_seed_cost", -- How much did you pay for opv seeds in total (SSP) in the last 12 months? (Missing: -99)
"survey_number",
"used_fertilizer_cost", -- How much did you pay for fertiliser in total (SSP) in the last 12 months? (Missing: -99)
"animals_leased_time", -- For how many days did you lease the animals? (Missing: -99)
"own_water_boiler_yr_acquired", -- In what year did you acquire your water boiler electric kettle? (Missing: -99)
"livestock_raised_other_animal_3",
"own_bicycle_yr_acquired", -- In what year did you acquire your bicycle? (Missing: -99)
"own_hand_pump_rent_out_total", -- How much did you obtain from leasing out your hand pump in the last 12 months? (Missing: -99)
"own_bed_cost", -- How much did you pay for your bed? (Missing: -99)
"livestock_raised_ox_amt", -- How many ox bull do you have now? (Missing: -99)
"laborers_m_season_2_amt", -- How many male workers did you employ? (season 2) (Missing: -99)
"laborers_c_season_2_amt", -- How many children under 15 did you employ? (season 2) (Missing: -99)
"own_shoes_amt", -- How many shoess does your household own? (Missing: -99)
"own_charcoal_iron_selling", -- If you sold one of your charcoal irons today, how much money could you get for it? (Missing: -99)
"own_car_selling_price_today", -- If you sold one of your cars today, how much money could you get for it? (Missing: -99)
"own_sprinkler_yr_acquired", -- In what year did you acquire your sprinkler? (Missing: -99)
"own_jerry_can_selling_price", -- If you sold one of your Jerry cans today, how much money could you get for it? (Missing: -99)
"laborers_m_season_3_cost", -- How much did you pay for male workers in total? (season 3) (Missing: -99)
"own_shoes_yr_acquired", -- In what year did you acquire your shoes? (Missing: -99)
"laborers_c_season_1_cost", -- How much did you pay for children workers in total? (season 1) (Missing: -99)
"own_grinding_mill_yr_acquired" -- In what year did you acquire your grinding mill? (Missing: -99)
FROM
"usaid-gov/baseline-survey-for-an-impact-evaluation-of-the-3467-jsvw: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-3467-jsvw with SQL in under 60 seconds.
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, 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 (like this repository), where the author has pushed Splitgraph Images to the repository, you can "clone" and/or "checkout" the data using sgr cloneand sgr checkout.
Cloning Data
Because usaid-gov/baseline-survey-for-an-impact-evaluation-of-the-3467-jsvw:latest is a Splitgraph Image, you can clone the data from Spltgraph Cloud to your local engine, where you can query it like any other Postgres database, using any of your existing tools.
First, install Splitgraph if you haven't already.
Clone the metadata with sgr clone
This will be quick, and does not download the actual data.
sgr clone usaid-gov/baseline-survey-for-an-impact-evaluation-of-the-3467-jsvwCheckout the data
Once you've cloned the data, you need to "checkout" the tag that you want. For example, to checkout the latest tag:
sgr checkout usaid-gov/baseline-survey-for-an-impact-evaluation-of-the-3467-jsvw:latestThis will download all the objects for the latest tag of usaid-gov/baseline-survey-for-an-impact-evaluation-of-the-3467-jsvw and load them into the Splitgraph Engine. Depending on your connection speed and the size of the data, you will need to wait for the checkout to complete. Once it's complete, you will be able to query the data like you would any other Postgres database.
Alternatively, use "layered checkout" to avoid downloading all the data
The data in usaid-gov/baseline-survey-for-an-impact-evaluation-of-the-3467-jsvw:latest is 0 bytes. If this is too big to download all at once, or perhaps you only need to query a subset of it, you can use a layered checkout.:
sgr checkout --layered usaid-gov/baseline-survey-for-an-impact-evaluation-of-the-3467-jsvw:latestThis will not download all the data, but it will create a schema comprised of foreign tables, that you can query as you would any other data. Splitgraph will lazily download the required objects as you query the data. In some cases, this might be faster or more efficient than a regular checkout.
Read the layered querying documentation to learn about when and why you might want to use layered queries.
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-3467-jsvw is just another Postgres schema.