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 feed_the_future_malawi_interim_survey_in_the_zone table in this repository, by referencing it like:
"datahub-usaid-gov/feed-the-future-malawi-interim-survey-in-the-zone-75qt-x4hk:latest"."feed_the_future_malawi_interim_survey_in_the_zone"or in a full query, like:
SELECT
":id", -- Socrata column ID
"selfjointgive_g", -- This variable is a recode of G304_G. It indicates that the individual can decide to give away the ITEM either individually or jointly with others individuals. ITEM Farm equipment (mechanized: Country-specific examples)
"leisuretime", -- This variable is the indicator for sufficient leisure time. The variables identifies women who are not dissatisfied with their leisure time as adequate, and women who are dissatisfied as inadequate. Satisfaction defined as a score of 5 or higher on the 1-
"totalworkmin", -- This is the number of minutes spent working, primeworkmin 0.5 secworkmin.
"selfjointrightanyagr_sum", -- This variable is a recode of selfjointrightany_a, selfjointrightany_b, selfjointrightany_c, selfjointrightany_d, selfjointrightany_e, selfjointrightany_f, and selfjointrightany_g. This variable is the number of assets in which the individual has the decis
"selfjointrightany_g", -- This variable is a recode of selfjointsell_g, selfjointgive_g, selfjointrent_g, and selfjointbuy_g. It means that the respondent has AT LEAST ONE right over the ITEM . ITEM Farm equipment (mechanized: Country-specific examples)
"inputdec_c", -- This variable is a recode of G202_C. The variable indicates that an individual has decisionmaking ability over ACTIVITY . It is coded as 1 if the individual if the individual has input into some decisions (2) or input into most or all decisions (3). Tho
"partact_f", -- This variable is a recode of G201_F. It is coded as 1 if the individual participated in the ACTIVITY within the past 12 months. It is coded 0 otherwise. Those who do not know, refuse, or have missing data are treated as missing on this recoded measure.
"partact_a", -- This variable is a recode of G201_A. It is coded as 1 if the individual participated in the ACTIVITY within the past 12 months. It is coded 0 otherwise. Those who do not know, refuse, or have missing data are treated as missing on this recoded measure.
"secworkmin", -- This is the number (in minutes) of secondary work activities.
"primeworkmin", -- This is the number (in minutes) of primary work activities.
"knowsofgrp_e", -- This variable is a recode of G404_E. The variable indicates that the respondent knows of this type of group in their community. Women who respond No or indicate that they do not know are coded as a 0 on this measure. GROUP Mutual help or insurance group
"selfjointbuy_f", -- This variable is a recode of G306_F. It indicates that the individual can decide to buy additional ITEM s either individually or jointly with others individuals. ITEM Farm equipment (non-mechanized: Country-specific examples)
"creditselfjointuse_d", -- This variable is a recode of G309_D. The variable indicates the individual contributes to the decisions about how to use the cash and or in-kind resources from SOURCE SOURCE Friends or relatives
"groupmember_f", -- This variable is a recode of G405_F. This variable indicates that the respondent is an active member of the community group. Those who do not have this type of group in their community, don t know whether this type of group exists within their community,
"knowsofgrp_d", -- This variable is a recode of G404_D. The variable indicates that the respondent knows of this type of group in their community. Women who respond No or indicate that they do not know are coded as a 0 on this measure. GROUP Credit or microfinance group (
"knowsofgrp_f", -- This variable is a recode of G404_F. The variable indicates that the respondent knows of this type of group in their community. Women who respond No or indicate that they do not know are coded as a 0 on this measure. GROUP Trade and business association
"selfjointown_j", -- This variable is a recode of G302_J. It indicates that the individual owns most of the ITEM either solely or jointly with others individuals. ITEM Large consumer durables (Country-specific examples)
"feelinputdecagr", -- This is the indicator value for the input into productive decisions. It indicates adequate achieve if there are AT LEAST TWO domains in which an individual has some input in decisions, makes the decision, or feels he she could make it if he she wanted. Th
"incomedec_b", -- This variable is a recode of G203_B. The variable indicates that an individual has decisionmaking ability over income generated from ACTIVITY . It is coded as 1 if the individual if the individual has input into some decisions (2) or input into most or a
"feelmakedec_a", -- This variable is a recode of G501_A, G502_A. The variable represents whether the woman makes decisions or feels that she could make decisions regarding ACTIVITY . It is coded as 1 if the woman is the sole person who makes decisions (G5.01) or if the woma
"selfjointbuy_e", -- This variable is a recode of G306_E. It indicates that the individual can decide to buy additional ITEM s either individually or jointly with others individuals. ITEM Fish pond or fishing equipment
"groupmember_e", -- This variable is a recode of G405_E. This variable indicates that the respondent is an active member of the community group. Those who do not have this type of group in their community, don t know whether this type of group exists within their community,
"selfjointrent_a", -- This variable is a recode of G305_A. It indicates that the individual can decide to rent the ITEM either individually or jointly with others individuals. ITEM Agricultural land (Country-specific examples)
"jown_count", -- This variable is the indicator for asset ownership. An individual is adequate if he she owns at leas two small assets (chicken, farming equipment non-mechanized, and small consumer durables) or one large asset. This measure is based on the selfjointown_s
"selfjointsell_g", -- This variable is a recode of G303_G. It indicates that the individual can decide to sell the ITEM either individually or jointly with others individuals. ITEM Farm equipment (mechanized: Country-specific examples)
"creditselfjointborrow_e", -- This variable is a recode of G308_E. The variable indicates that the individual contributed to the decision to take the credit from SOURCE . SOURCE Group based micro-finance or lending including VSLAs SACCOs merry-go-rounds
"own_k", -- This variable is a recode of G301A_K. It indicates that the household owns the ITEM . ITEM Small consumer durables (Country-specific examples)
"own_m", -- This variable is a recode of G301A_M. It indicates that the household owns the ITEM . ITEM Other land not used for agricultural purposes (Country-specific examples)
"own_b", -- This variable is a recode of G301A_B. It indicates that the household owns the ITEM . ITEM Large livestock (Country-specific examples)
"incomedec_c", -- This variable is a recode of G203_C. The variable indicates that an individual has decisionmaking ability over income generated from ACTIVITY . It is coded as 1 if the individual if the individual has input into some decisions (2) or input into most or a
"subgroup3", -- The 7-district FTF FEEDBACK ZOI which will include district level data from rural areas only of Michinji, Lilongwe, Dedza, Mangochi, Ntcheu, Balaka, Machinga.
"creditselfjointborrow_d", -- This variable is a recode of G308_D. The variable indicates that the individual contributed to the decision to take the credit from SOURCE . SOURCE Friends or relatives
"creditaccess", -- This variable indicates the number of sources of credit that the household has taken
"groupmember_c", -- This variable is a recode of G405_C. This variable indicates that the respondent is an active member of the community group. Those who do not have this type of group in their community, don t know whether this type of group exists within their community,
"knowsofgrp_j", -- This variable is a recode of G404_J. The variable indicates that the respondent knows of this type of group in their community. Women who respond No or indicate that they do not know are coded as a 0 on this measure. GROUP Other women s group
"selfjointrent_d", -- This variable is a recode of G305_D. It indicates that the individual can decide to rent the ITEM either individually or jointly with others individuals. ITEM Chickens, ducks, turkeys, and pigeons
"incomedec_e", -- This variable is a recode of G203_E. The variable indicates that an individual has decisionmaking ability over income generated from ACTIVITY . It is coded as 1 if the individual if the individual has input into some decisions (2) or input into most or a
"speakpublic_g401", -- This variable is a recode of G401. The variable indicates that the individual is comfortable or can speak with some difficulty in public to help decide on infrastructure
"groupmember_h", -- This variable is a recode of G405_H. This variable indicates that the respondent is an active member of the community group. Those who do not have this type of group in their community, don t know whether this type of group exists within their community,
"speakpublic_g403", -- This variable is a recode of G403. The variable indicates that the individual is comfortable or can speak with some difficulty in public to protest misbehavior of authorities.
"partact", -- This variable is number of activities listed in Module G2 in which the individual directly participates.
"knowsofgrp_h", -- This variable is a recode of G404_H. The variable indicates that the respondent knows of this type of group in their community. Women who respond No or indicate that they do not know are coded as a 0 on this measure. GROUP Local government
"selfjointsell_a", -- This variable is a recode of G303_A. It indicates that the individual can decide to sell the ITEM either individually or jointly with others individuals. ITEM Agricultural land (Country-specific examples)
"selfjointgive_d", -- This variable is a recode of G304_D. It indicates that the individual can decide to give away the ITEM either individually or jointly with others individuals. ITEM Chickens, ducks, turkeys, and pigeons
"project", -- Identifies whether the record is used to report on Feed the Future (FTF), Food for Peace (FFP), Catholic Relief Services (CRS), or Project Concern International (PCI) programming. Due to coordinated survey collection, the same record may be used to evalu
"selfjointsell_d", -- This variable is a recode of G303_D. It indicates that the individual can decide to sell the ITEM either individually or jointly with others individuals. ITEM Chickens, ducks, turkeys, and pigeons
"feelmakedec_c", -- This variable is a recode of G501_C, G502_C. It is coded as 1 if the individual is the sole person who makes decisions (G5.01) or if the individual feels that they could make a decision (G5.02) regarding ACTIVITY . The individual is counted as feeling th
"country", -- These data were collected in Malawi
"inputdec_f", -- This variable is a recode of G202_F. The variable indicates that an individual has decisionmaking ability over ACTIVITY . It is coded as 1 if the individual if the individual has input into some decisions (2) or input into most or all decisions (3). Tho
"groupmember_d", -- This variable is a recode of G405_D. This variable indicates that the respondent is an active member of the community group. Those who do not have this type of group in their community, don t know whether this type of group exists within their community,
"feelmakedec_g", -- This variable is a recode of G501_G, G502_G. It is coded as 1 if the individual is the sole person who makes decisions (G5.01) or if the individual feels that they could make a decision (G5.02) regarding ACTIVITY . The individual is counted as feeling th
"creditselfjointuse_b", -- This variable is a recode of G309_B. The variable indicates the individual contributes to the decisions about how to use the cash and or in-kind resources from SOURCE SOURCE Informal lender
"groupmember_i", -- This variable is a recode of G405_I. This variable indicates that the respondent is an active member of the community group. Those who do not have this type of group in their community, don t know whether this type of group exists within their community,
"survey", -- Two surveys were administered. This variable identifies whether the survey was the Interim Feed the Future survey or the Baseline Food for Peace survey.
"creditselfjointborrow_a", -- This variable is a recode of G308_A. The variable indicates that the individual contributed to the decision to take the credit from SOURCE . SOURCE Non-governmental organization (NGO)
"partact_b", -- This variable is a recode of G201_B. It is coded as 1 if the individual participated in the ACTIVITY within the past 12 months. It is coded 0 otherwise. Those who do not know, refuse, or have missing data are treated as missing on this recoded measure.
"strata3", -- Stratification for subgroup 3
"own_c", -- This variable is a recode of G301A_C. It indicates that the household owns the ITEM . ITEM Small livestock (Country-specific examples)
"creditaccess_a", -- This variable is a recode of G307_A. The variable indicates that someone in the household has taken loans or borrowed cash and or in-kind resources from SOURCE SOURCE Non-governmental organization (NGO)
"selfjointown_h", -- This variable is a recode of G302_H. It indicates that the individual owns most of the ITEM either solely or jointly with others individuals. ITEM Nonfarm business equipment (Country-specific examples)
"cluster", -- Cluster number
"feelinputdecagr_sum", -- This variable is the sum variables feelmakedec_a, feelmakedec_b, feelmakedec_c, feelmakedec_d, inputdec_a, inputdec_b, inputdec_c, inputdec_f. It shows the number of agricultural domains in which the individual has some input in decisions or feels that s
"selfjointgive_c", -- This variable is a recode of G304_C. It indicates that the individual can decide to give away the ITEM either individually or jointly with others individuals. ITEM Small livestock (Country-specific examples)
"own_e", -- This variable is a recode of G301A_E. It indicates that the household owns the ITEM . ITEM Fish pond or fishing equipment
"own_g", -- This variable is a recode of G301A_G. It indicates that the household owns the ITEM . ITEM Farm equipment (mechanized: Country-specific examples)
"selfjointown_e", -- This variable is a recode of G302_E. It indicates that the individual owns most of the ITEM either solely or jointly with others individuals. ITEM Fish pond or fishing equipment
"groupmember_any", -- This variable is the indicator for group member. It identifies women who are an active member of at least 1 community group as adequate. Women who are not a member of at least one community group are considered inadequate.
"selfjointgive_e", -- This variable is a recode of G304_E. It indicates that the individual can decide to give away the ITEM either individually or jointly with others individuals. ITEM Fish pond or fishing equipment
"partact_e", -- This variable is a recode of G201_E. It is coded as 1 if the individual participated in the ACTIVITY within the past 12 months. It is coded 0 otherwise. Those who do not know, refuse, or have missing data are treated as missing on this recoded measure.
"feelmakedec_b", -- This variable is a recode of G501_B, G502_B. It is coded as 1 if the individual is the sole person who makes decisions (G5.01) or if the individual feels that they could make a decision (G5.02) regarding ACTIVITY . The individual is counted as feeling th
"urbrur", -- Location type (urban rural)
"selfjointrightany_f", -- This variable is a recode of selfjointsell_f, selfjointgive_f, selfjointrent_f, and selfjointbuy_f. It means that the respondent has AT LEAST ONE right over the ITEM . ITEM Farm equipment (non-mechanized: Country-specific examples)
"weai_wt3", -- Individual sampling weight for primary female decisionmakers. This weight should be used for analyzing subgroup 3.
"creditselfjointanydec_a", -- This variable is a recode of creditselfjointborrow_a and creditselfjointuse_a. This variable indicates that the individual has been involved in decisionmaking on the credit taken from SOURCE . SOURCE Non-governmental organization (NGO)
"creditselfjointuse_a", -- This variable is a recode of G309_A. The variable indicates the individual contributes to the decisions about how to use the cash and or in-kind resources from SOURCE SOURCE Non-governmental organization (NGO)
"own_l", -- This variable is a recode of G301A_L. It indicates that the household owns the ITEM . ITEM Cell phone
"pbs_id", -- Administrative variable for identifying households
"own_j", -- This variable is a recode of G301A_J. It indicates that the household owns the ITEM . ITEM Large consumer durables (Country-specific examples)
"inputdec_a", -- This variable is a recode of G202_A. The variable indicates that an individual has decisionmaking ability over ACTIVITY . It is coded as 1 if the individual if the individual has input into some decisions (2) or input into most or all decisions (3). Tho
"knowsofgrp_c", -- This variable is a recode of G404_C. The variable indicates that the respondent knows of this type of group in their community. Women who respond No or indicate that they do not know are coded as a 0 on this measure. GROUP Forest users group
"ghht", -- Derived gendered household type
"creditselfjointanydec_b", -- This variable is a recode of creditselfjointborrow_b, creditselfjointuse_b. This variable indicates that the individual has been involved in decisionmaking on the credit taken from SOURCE . SOURCE Informal lender
"selfjointown_c", -- This variable is a recode of G302_C. It indicates that the individual owns most of the ITEM either solely or jointly with others individuals. ITEM Small livestock (Country-specific examples)
"selfjointown_m", -- This variable is a recode of G302_M. It indicates that the individual owns most of the ITEM either solely or jointly with others individuals. ITEM Other land not used for agricultural purposes (Country-specific examples)
"selfjointrightany_e", -- This variable is a recode of selfjointsell_e, selfjointgive_e, selfjointrent_e, and selfjointbuy_e. It means that the respondent has AT LEAST ONE right over the ITEM . ITEM Fish pond or fishing equipment
"creditselfjointanydec_d", -- This variable is a recode of creditselfjointborrow_d, creditselfjointuse_d. This variable indicates that the individual has been involved in decisionmaking on the credit taken from SOURCE . SOURCE Friends or relatives
"idcode", -- Woman s ID code
"incomedec_d", -- This variable is a recode of G203_D. The variable indicates that an individual has decisionmaking ability over income generated from ACTIVITY . It is coded as 1 if the individual if the individual has input into some decisions (2) or input into most or a
"selfjointgive_b", -- This variable is a recode of G304_B. It indicates that the individual can decide to give away the ITEM either individually or jointly with others individuals. ITEM Large livestock (Country-specific examples)
"knowsofgrp_i", -- This variable is a recode of G404_I. The variable indicates that the respondent knows of this type of group in their community. Women who respond No or indicate that they do not know are coded as a 0 on this measure. GROUP Religious group
"incomedec_f", -- This variable is a recode of G203_F. The variable indicates that an individual has decisionmaking ability over income generated from ACTIVITY . It is coded as 1 if the individual if the individual has input into some decisions (2) or input into most or a
"own_a", -- This variable is a recode of G301A_A. It indicates that the household owns the ITEM . ITEM Agricultural land (Country-specific examples)
"jrightanyagr", -- This variable is a recode of selfjointrightany_a, selfjointrightany_b, selfjointrightany_c, selfjointrightany_d, selfjointrightany_e, selfjointrightany_f, and selfjointrightany_g. This variable is the indicator for the purchase, sale, or transfer of asset
"incdec_count", -- This is the indicator for the control over income. It is a recode of incomedec_sum and indicates that the individual has some input into decisions made about incomes or feels that he she can make a decision about finances as long as the decision is not
"selfjointbuy_c", -- This variable is a recode of G306_C. It indicates that the individual can decide to buy additional ITEM s either individually or jointly with others individuals. ITEM Small livestock (Country-specific examples)
"selfjointrightany_a", -- This variable is a recode of selfjointsell_a, selfjointgive_a, selfjointrent_a, and selfjointbuy_a. It means that the respondent has AT LEAST ONE right over the ITEM . ITEM Agricultural land (Country-specific examples)
"selfjointown_g", -- This variable is a recode of G302_G. It indicates that the individual owns most of the ITEM either solely or jointly with others individuals. ITEM Farm equipment (mechanized: Country-specific examples)
"selfjointown_k", -- This variable is a recode of G302_K. It indicates that the individual owns most of the ITEM either solely or jointly with others individuals. ITEM Small consumer durables (Country-specific examples)
"selfjointown_d", -- This variable is a recode of G302_D. It indicates that the individual owns most of the ITEM either solely or jointly with others individuals. ITEM Chickens, ducks, turkeys, and pigeons
"selfjointrightany_b", -- This variable is a recode of selfjointsell_b, selfjointgive_b, selfjointrent_b, and selfjointbuy_b. It means that the respondent has AT LEAST ONE right over the ITEM . ITEM Large livestock (Country-specific examples)
"groupmember_b", -- This variable is a recode of G405_B. This variable indicates that the respondent is an active member of the community group. Those who do not have this type of group in their community, don t know whether this type of group exists within their community,
"selfjointown_f", -- This variable is a recode of G302_F. It indicates that the individual owns most of the ITEM either solely or jointly with others individuals. ITEM Farm equipment (non-mechanized: Country-specific examples)
"creditaccess_e", -- This variable is a recode of G307_E. The variable indicates that someone in the household has taken loans or borrowed cash and or in-kind resources from SOURCE SOURCE Group based micro-finance or lending including VSLAs SACCOs merry-go-rounds
"own_i", -- This variable is a recode of G301A_I. It indicates that the household owns the ITEM . ITEM House or other structures
"selfjointrent_g", -- This variable is a recode of G305_G. It indicates that the individual can decide to rent the ITEM either individually or jointly with others individuals. ITEM Farm equipment (mechanized: Country-specific examples)
"own_h", -- This variable is a recode of G301A_H. It indicates that the household owns the ITEM . ITEM Nonfarm business equipment (Country-specific examples)
"selfjointbuy_a", -- This variable is a recode of G306_A. It indicates that the individual can decide to buy additional ITEM s either individually or jointly with others individuals. ITEM Agricultural land (Country-specific examples)
"creditselfjointborrow_b", -- This variable is a recode of G308_B. The variable indicates that the individual contributed to the decision to take the credit from SOURCE . SOURCE Informal lender
"creditaccess_b", -- This variable is a recode of G307_B. The variable indicates that someone in the household has taken loans or borrowed cash and or in-kind resources from SOURCE SOURCE Informal lender
"zoi", -- Was the data collected by Westat or ICF?
"inputdec_e", -- This variable is a recode of G202_E. The variable indicates that an individual has decisionmaking ability over ACTIVITY . It is coded as 1 if the individual if the individual has input into some decisions (2) or input into most or all decisions (3). Tho
"npoor_z105", -- This variable is the indicator for a suitable workload. It identifies women whose combined total of primary and secondary work time is less than or equal to 10.5 hours. Women who work more than 10.5 hours in the prior day are considered inadequate.
"selfjointown_n", -- This variable is a recode of G302_N. It indicates that the individual owns most of the ITEM either solely or jointly with others individuals. ITEM Means of transportation (Country-specific examples)
"creditselfjointuse_e", -- This variable is a recode of G309_E. The variable indicates the individual contributes to the decisions about how to use the cash and or in-kind resources from SOURCE SOURCE Group based micro-finance or lending including VSLAs SACCOs merry-go-rou
"selfjointsell_b", -- This variable is a recode of G303_B. It indicates that the individual can decide to sell the ITEM either individually or jointly with others individuals. ITEM Large livestock (Country-specific examples)
"groupmember_k", -- This variable is a recode of G405_K. This variable indicates that the respondent is an active member of the community group. Those who do not have this type of group in their community, don t know whether this type of group exists within their community,
"selfjointrent_f", -- This variable is a recode of G305_F. It indicates that the individual can decide to rent the ITEM either individually or jointly with others individuals. ITEM Farm equipment (non-mechanized: Country-specific examples)
"inputdec_b", -- This variable is a recode of G202_B. The variable indicates that an individual has decisionmaking ability over ACTIVITY . It is coded as 1 if the individual if the individual has input into some decisions (2) or input into most or all decisions (3). Tho
"own_f", -- This variable is a recode of G301A_F. It indicates that the household owns the ITEM . ITEM Farm equipment (non-mechanized: Country-specific examples)
"creditselfjointanydec_e", -- This variable is a recode of creditselfjointborrow_e, creditselfjointuse_e. This variable indicates that the individual has been involved in decisionmaking on the credit taken from SOURCE . SOURCE Group based micro-finance or lending including VSLAs
"selfjointown_b", -- This variable is a recode of G302_B. It indicates that the individual owns most of the ITEM either solely or jointly with others individuals. ITEM Large livestock (Country-specific examples)
"selfjointsell_e", -- This variable is a recode of G303_E. It indicates that the individual can decide to sell the ITEM either individually or jointly with others individuals. ITEM Fish pond or fishing equipment
"today", -- The day of interview as a string variable, MM-DD-YYYY
"selfjointrent_b", -- This variable is a recode of G305_B. It indicates that the individual can decide to rent the ITEM either individually or jointly with others individuals. ITEM Large livestock (Country-specific examples)
"own_sum", -- This variable is the sum of all listed items that someone in the household owns.
"selfjointbuy_g", -- This variable is a recode of G306_G. It indicates that the individual can decide to buy additional ITEM s either individually or jointly with others individuals. ITEM Farm equipment (mechanized: Country-specific examples)
"selfjointgive_a", -- This variable is a recode of G304_A. It indicates that the individual can decide to give away the ITEM either individually or jointly with others individuals. ITEM Agricultural land (Country-specific examples)
"inputdec_d", -- This variable is a recode of G202_D. The variable indicates that an individual has decisionmaking ability over ACTIVITY . It is coded as 1 if the individual if the individual has input into some decisions (2) or input into most or all decisions (3). Tho
"groupmember_g", -- This variable is a recode of G405_G. This variable indicates that the respondent is an active member of the community group. Those who do not have this type of group in their community, don t know whether this type of group exists within their community,
"knowsofgrp_b", -- This variable is a recode of G404_B. The variable indicates that the respondent knows of this type of group in their community. Women who respond No or indicate that they do not know are coded as a 0 on this measure. GROUP Water users group
"creditaccess_d", -- This variable is a recode of G307_D. The variable indicates that someone in the household has taken loans or borrowed cash and or in-kind resources from SOURCE SOURCE Friends or relatives
"incomedec_a", -- This variable is a recode of G203_A. The variable indicates that an individual has decisionmaking ability over income generated from ACTIVITY . It is coded as 1 if the individual if the individual has input into some decisions (2) or input into most or a
"selfjointown_l", -- This variable is a recode of G302_L. It indicates that the individual owns most of the ITEM either solely or jointly with others individuals. ITEM Cell phone
"speakpublic_any", -- This is the speaking in public indicator. The variable indicates that the individual is comfortable speaking in public in at least one context.
"selfjointrent_e", -- This variable is a recode of G305_E. It indicates that the individual can decide to rent the ITEM either individually or jointly with others individuals. ITEM Fish pond or fishing equipment
"own_d", -- This variable is a recode of G301A_D. It indicates that the household owns the ITEM . ITEM Chickens, ducks, turkeys, and pigeons
"selfjointown_a", -- This variable is a recode of G302_A. It indicates that the individual owns most of the ITEM either solely or jointly with others individuals. ITEM Agricultural land (Country-specific examples)
"feelmakedec_d", -- This variable is a recode of G501_D, G502_D. It is coded as 1 if the individual is the sole person who makes decisions (G5.01) or if the individual feels that they could make a decision (G5.02) regarding ACTIVITY . The individual is counted as feeling th
"partact_d", -- This variable is a recode of G201_D. It is coded as 1 if the individual participated in the ACTIVITY within the past 12 months. It is coded 0 otherwise. Those who do not know, refuse, or have missing data are treated as missing on this recoded measure.
"weaisample", -- This variable indicates whether a record is included in the WEAI. The measure identifies records where all WEAI indicators have a non-missing value.
"feelmakedec_f", -- This variable is a recode of G501_F, G502_F. It is coded as 1 if the individual is the sole person who makes decisions (G5.01) or if the individual feels that they could make a decision (G5.02) regarding ACTIVITY . The individual is counted as feeling th
"creditselfjointborrow_c", -- This variable is a recode of G308_C. The variable indicates that the individual contributed to the decision to take the credit from SOURCE . SOURCE Formal lender (bank financial institution)
"selfjointown_i", -- This variable is a recode of G302_I. It indicates that the individual owns most of the ITEM either solely or jointly with others individuals. ITEM House or other structures
"partactagr", -- This variable is number of agriculture activities listed in Module G2 in which the individual directly participates.
"groupmember_j", -- This variable is a recode of G405_J. This variable indicates that the respondent is an active member of the community group. Those who do not have this type of group in their community, don t know whether this type of group exists within their community,
"creditselfjointuse_c", -- This variable is a recode of G309_C. The variable indicates the individual contributes to the decisions about how to use the cash and or in-kind resources from SOURCE SOURCE Formal lender (bank financial institution)
"selfjointrightany_d", -- This variable is a recode of selfjointsell_d, selfjointgive_d, selfjointrent_d, and selfjointbuy_d. It means that the respondent has AT LEAST ONE right over the ITEM . ITEM Chickens, ducks, turkeys, and pigeons
"partact_c", -- This variable is a recode of G201_C. It is coded as 1 if the individual participated in the ACTIVITY within the past 12 months. It is coded 0 otherwise. Those who do not know, refuse, or have missing data are treated as missing on this recoded measure.
"knowsofgrp_g", -- This variable is a recode of G404_G. The variable indicates that the respondent knows of this type of group in their community. Women who respond No or indicate that they do not know are coded as a 0 on this measure. GROUP Civic groups (improving commun
"selfjointown_sum", -- This variable is a recode of the selfjointown_ variables. The variables are summed to indicate the number of assets that the individual owns individually and jointly.
"own_n", -- This variable is a recode of G301A_N. It indicates that the household owns the ITEM . ITEM Means of transportation (Country-specific examples)
"selfjointsell_c", -- This variable is a recode of G303_C. It indicates that the individual can decide to sell the ITEM either individually or jointly with others individuals. ITEM Small livestock (Country-specific examples)
"selfjointrightany_c", -- This variable is a recode of selfjointsell_c, selfjointgive_c, selfjointrent_c, and selfjointbuy_c. It means that the respondent has AT LEAST ONE right over the ITEM . ITEM Small livestock (Country-specific examples)
"feelmakedec_e", -- This variable is a recode of G501_E, G502_E. It is coded as 1 if the individual is the sole person who makes decisions (G5.01) or if the individual feels that they could make a decision (G5.02) regarding ACTIVITY . The individual is counted as feeling th
"selfjointgive_f", -- This variable is a recode of G304_F. It indicates that the individual can decide to give away the ITEM either individually or jointly with others individuals. ITEM Farm equipment (non-mechanized: Country-specific examples)
"creditselfjointanydec_c", -- This variable is a recode of creditselfjointborrow_c, creditselfjointuse_c. This variable indicates that the individual has been involved in decisionmaking on the credit taken from SOURCE . SOURCE Formal lender (bank financial institution)
"selfjointbuy_d", -- This variable is a recode of G306_D. It indicates that the individual can decide to buy additional ITEM s either individually or jointly with others individuals. ITEM Chickens, ducks, turkeys, and pigeons
"credjanydec_any", -- This is the indicator for access to and decisions on credit. The individual is adequate if he she makes decisions regarding at least one source of credit and if he she has at least one source of credit.
"knowsofgrp_k", -- This variable is a recode of G404_K. The variable indicates that the respondent knows of this type of group in their community. Women who respond No or indicate that they do not know are coded as a 0 on this measure. GROUP Any other group or organizatio
"knowsofgrp_a", -- This variable is a recode of G404_A. The variable indicates that the respondent knows of this type of group in their community. Women who respond No or indicate that they do not know are coded as a 0 on this measure. GROUP Agricultural livestock fisheri
"incomedec_sum", -- This variable is the sum variables incomedec_a, incomedec_b, incomedec_c, incomedec_d, incomedec_e, incomedec_f, feelmakedec_e, feelmakedec_f, feelmakedec_g. It shows the number of domains in which the individual has some input in income decisions or fee
"ownagr_sum", -- This variable is the sum of all agriculture items, A-G, that someone in the household owns.
"selfjointbuy_b", -- This variable is a recode of G306_B. It indicates that the individual can decide to buy additional ITEM s either individually or jointly with others individuals. ITEM Large livestock (Country-specific examples)
"creditaccess_c", -- This variable is a recode of G307_C. The variable indicates that someone in the household has taken loans or borrowed cash and or in-kind resources from SOURCE SOURCE Formal lender (bank financial institution)
"groupmember_a", -- This variable is a recode of G405_A. This variable indicates that the respondent is an active member of the community group. Those who do not have this type of group in their community, don t know whether this type of group exists within their community,
"selfjointsell_f", -- This variable is a recode of G303_F. It indicates that the individual can decide to sell the ITEM either individually or jointly with others individuals. ITEM Farm equipment (non-mechanized: Country-specific examples)
"selfjointrent_c", -- This variable is a recode of G305_C. It indicates that the individual can decide to rent the ITEM either individually or jointly with others individuals. ITEM Small livestock (Country-specific examples)
"speakpublic_g402" -- This variable is a recode of G402. The variable indicates that the individual is comfortable or can speak with some difficulty in public to ensure proper payment of wages for public works.
FROM
"datahub-usaid-gov/feed-the-future-malawi-interim-survey-in-the-zone-75qt-x4hk:latest"."feed_the_future_malawi_interim_survey_in_the_zone"
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 datahub-usaid-gov/feed-the-future-malawi-interim-survey-in-the-zone-75qt-x4hk 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 datahub-usaid-gov/feed-the-future-malawi-interim-survey-in-the-zone-75qt-x4hk: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 datahub-usaid-gov/feed-the-future-malawi-interim-survey-in-the-zone-75qt-x4hkCheckout 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 datahub-usaid-gov/feed-the-future-malawi-interim-survey-in-the-zone-75qt-x4hk:latestThis will download all the objects for the latest tag of datahub-usaid-gov/feed-the-future-malawi-interim-survey-in-the-zone-75qt-x4hk 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 datahub-usaid-gov/feed-the-future-malawi-interim-survey-in-the-zone-75qt-x4hk: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 datahub-usaid-gov/feed-the-future-malawi-interim-survey-in-the-zone-75qt-x4hk: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, datahub-usaid-gov/feed-the-future-malawi-interim-survey-in-the-zone-75qt-x4hk is just another Postgres schema.