"usaid-gov/feed-the-future-northern-kenya-interim-survey-in-r3z6-2jv8:latest"."feed_the_future_northern_kenya_interim_survey_in"

SELECT
    ":id", -- Socrata column ID
    "secworkmin", -- This is the number of minutes a respondent reported secondary work activities (activities D through M in G6(A)) in the prior 24 hours.
    "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 (radio, cookware)
    "weai_wt", -- Individual sampling weight for primary female decisionmakers
    "survey", -- These data were collected in the 2015 Interim Zone of Influence Survey.
    "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, pigeons, or other birds
    "own_n", -- This variable is a recode of G301A_N. It indicates that the household owns the ITEM . ITEM Means of transportation (bicycle, motorcycle, car)
    "creditaccess", -- This variable indicates the number of sources of credit that the household has taken
    "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
    "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 (cattle, camels, donkeys)
    "own_c", -- This variable is a recode of G301A_C. It indicates that the household owns the ITEM . ITEM Small livestock (goats, pigs, sheep)
    "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
    "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
    "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 (pieces plots)
    "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
    "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
    "knowsofgrp_l", -- This variable is a recode of G404_L. 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
    "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, pigeons, or other birds
    "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: tractor-drawn plough, power tiller, treadle pump)
    "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 (goats, pigs, sheep)
    "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, or are not active members of a known group are coded as 0. GROUP Trade and business association
    "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 (3) or input into most or all decisions (4). Those who have no input or input into very few decisions (1) are coded as a zero. Those who do not participate in an activity (G2.01 2), report that not decision was made (99), refuse (99) are coded as missing. ACTIVITY Food crop farming: These are crops that are grown primarily for household food consumption
    "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 (including SACCOs merry-go-rounds VSLAs)
    "own_b", -- This variable is a recode of G301A_B. It indicates that the household owns the ITEM . ITEM Large livestock (cattle, camels, donkeys)
    "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 assets. It indicates that the individual has the right to purchase, sale, or transfer at least two assets or that the individual has the right to purchase, sale, or transfer one asset as long as that asset is not chicken or non-mechanized farm equipment.
    "own_l", -- This variable is a recode of G301A_L. It indicates that the household owns the ITEM . ITEM Cell phone
    "partactagr", -- This variable is number of agriculture activities listed in Module G2 in which the individual directly participates.
    "creditselfjointanydec_c", -- This variable is a recode of creditselfjointborrow_c, creditselfjointuse_c, c, and c. This variable indicates that the individual has been involved in decisionmaking on the credit taken from SOURCE . SOURCE Formal lender (bank financial institution)
    "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: tractor-drawn plough, power tiller, treadle pump)
    "own_a", -- This variable is a recode of G301A_A. It indicates that the household owns the ITEM . ITEM Agricultural land (pieces plots)
    "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.
    "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 (pieces plots, residential or commercial land)
    "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 (goats, pigs, sheep)
    "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, or are not active members of a known group are coded as 0. GROUP Civic groups (improving community) or charitable group (helping others)
    "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 they could make a decision if they indicated to a small extent (2), medium extent (3), or to a high extent (4). ACTIVITY Major household expenditures (such as a large appliance for the house like a refrigerator)
    "stratum", -- Administrative variable for identifying the strata of sampling designs. Unstratified samples have a constant value of 1.
    "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 (cattle, camels, donkeys)
    "own_sum", -- This variable is the sum of all listed items that someone in the household owns.
    "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
    "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 (goats, pigs, sheep)
    "idcode", -- Woman s ID code
    "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 Youth group
    "own_j", -- This variable is a recode of G301A_J. It indicates that the household owns the ITEM . ITEM Large consumer durables (refrigerator, TV, sofa)
    "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 they could make a decision if they indicated to a small extent (2), medium extent (3), or to a high extent (4). ACTIVITY Minor household expenditures (such as food for daily consumption or other household needs)
    "own_i", -- This variable is a recode of G301A_I. It indicates that the household owns the ITEM . ITEM House or other structures
    "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
    "creditselfjointanydec_d", -- This variable is a recode of creditselfjointborrow_d, creditselfjointuse_d, d, and d. This variable indicates that the individual has been involved in decisionmaking on the credit taken from SOURCE . SOURCE Friends or relatives
    "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. ACTIVITY Fishing or fishpond culture
    "urbrur", -- Location type (urban rural)
    "primeworkmin", -- This is the number of minutes a respondent reported primary work activities (activities D through M in G6(A)) in the prior 24 hours.
    "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 (solar panels used for recharging, sewing machine, brewing equipment, fryers)
    "country", -- These data were collected in the Feed the Future Zone of Influence in Kenya.
    "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.
    "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 (pieces plots)
    "own_h", -- This variable is a recode of G301A_H. It indicates that the household owns the ITEM . ITEM Nonfarm business equipment (solar panels used for recharging, sewing machine, brewing equipment, fryers)
    "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 (goats, pigs, sheep)
    "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 (cattle, camels, donkeys)
    "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 (including burial societies)
    "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: tractor-drawn plough, power tiller, treadle pump)
    "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, or are not active members of a known group are coded as 0. GROUP Credit or microfinance group (including SACCOs merry-go-rounds VSLAs)
    "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
    "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. ACTIVITY Wage and salary employment: This could be work that is paid for in cash or in-kind, including both agriculture and other wage work
    "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
    "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: hand tools, ox plough)
    "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 they could make a decision if they indicated to a small extent (2), medium extent (3), or to a high extent (4). ACTIVITY Your own (singular) wage or salary employment
    "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, pigeons, or other birds
    "own_g", -- This variable is a recode of G301A_G. It indicates that the household owns the ITEM . ITEM Farm equipment (mechanized: tractor-drawn plough, power tiller, treadle pump)
    "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. ACTIVITY Cash crop farming: These are crops that are grown primarily for sale in market
    "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: tractor-drawn plough, power tiller, treadle pump)
    "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. ACTIVITY Food crop farming: These are crops that are grown primarily for household food consumption
    "ownagr_sum", -- This variable is the sum of all agriculture items, A-G, that someone in the household owns.
    "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 they could make a decision if they indicated to a small extent (2), medium extent (3), or to a high extent (4). ACTIVITY The types of crops to grow
    "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
    "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 (3) or input into most or all decisions (4). Those who have no input or input into very few decisions (1) are coded as a zero. Those who do not participate in an activity (G2.01 2), report that not decision was made (99), refuse (99) are coded as missing. ACTIVITY Livestock raising
    "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, or are not active members of a known group are coded as 0. GROUP Forest users group
    "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.
    "own_k", -- This variable is a recode of G301A_K. It indicates that the household owns the ITEM . ITEM Small consumer durables (radio, cookware)
    "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
    "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-10 rating in G6.02.
    "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 community) or charitable group (helping others)
    "groupmember_l", -- This variable is a recode of G405_L. 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, or are not active members of a known group are coded as 0. GROUP Other women s group
    "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 they could make a decision if they indicated to a small extent (2), medium extent (3), or to a high extent (4). ACTIVITY Livestock raising
    "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, pigeons, or other birds
    "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 (bicycle, motorcycle, car)
    "partact", -- This variable is number of activities listed in Module G2 in which the individual directly participates.
    "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 (3) or input into most or all decisions (4). Those who have no input or input into very few decisions (1) are coded as a zero. Those who do not participate in an activity (G2.01 2), report that not decision was made (99), refuse (99) are coded as missing. ACTIVITY Cash crop farming: These are crops that are grown primarily for sale in market
    "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 (3) or input into most or all decisions (4). Those who have no input or input into very few decisions (1) are coded as a zero. Those who do not participate in an activity (G2.01 2), report that not decision was made (99), refuse (99) are coded as missing. ACTIVITY Non-farm economic activities: This would include things like running a small business, self-employment, buy-and-sell
    "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 (3) or input into most or all decisions (4). Those who have no input or input into very few decisions (1) are coded as a zero. Those who do not participate in an activity (G2.01 2), report that not decision was made (99), refuse (99) are coded as missing. ACTIVITY Wage and salary employment: This could be work that is paid for in cash or in-kind, including both agriculture and other wage work
    "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 they could make a decision if they indicated to a small extent (2), medium extent (3), or to a high extent (4). ACTIVITY Taking crops to the market (or not)
    "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 she can make decisions. Missing values on individual variables are treated as zero during summation, and individuals only have a missing value on this measure when all summed values are missing.
    "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
    "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
    "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: hand tools, ox plough)
    "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 (pieces plots)
    "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: hand tools, ox plough)
    "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.
    "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_sum measure. This is the same as saying: empowered if owns AT LEAST one asset and that asset is not a small asset. Inadequate if lives in a household that owns no assets.
    "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 decisionmaking power to purchase, sale, or transfer the asset.
    "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
    "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)
    "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.
    "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
    "knowsofgrp_m", -- This variable is a recode of G404_M. 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 organization
    "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, or are not active members of a known group are coded as 0. GROUP Mutual help or insurance group (including burial societies)
    "totalworkmin", -- This is the total number of minutes spent working (primary (secondary 2)). Because both primary and secondary activities are considered (with secondary activities weighted by half), it is possible to have 24 hours (1440 minutes).
    "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: hand tools, ox plough)
    "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 Education group
    "own_e", -- This variable is a recode of G301A_E. It indicates that the household owns the ITEM . ITEM Fish pond or fishing equipment
    "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: hand tools, ox plough)
    "today", -- Survey Date
    "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.
    "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. ACTIVITY Non-farm economic activities: This would include things like running a small business, self-employment, buy-and-sell
    "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 (3) or input into most or all decisions (4). Those who have no input or input into very few decisions (1) are coded as a zero. Those who do not participate in an activity (G2.01 2), report that not decision was made (99), refuse (99) are coded as missing. ACTIVITY Fishing or fishpond culture
    "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 (3) or input into most or all decisions (4). Those who have no input or input into very few decisions (1) are coded as a zero. Those who do not participate in an activity (G2.01 2), report that not decision was made (99), refuse (99) are coded as missing. ACTIVITY Fishing or fishpond culture
    "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 feels can make decisions regarding incomes.
    "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 related to minor household expenses.
    "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 (cattle, camels, donkeys)
    "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-rounds
    "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, or are not active members of a known group are coded as 0. GROUP Local government
    "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, or are not active members of a known group are coded as 0. GROUP Relgious group
    "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 (3) or input into most or all decisions (4). Those who have no input or input into very few decisions (1) are coded as a zero. Those who do not participate in an activity (G2.01 2), report that not decision was made (99), refuse (99) are coded as missing. ACTIVITY Cash crop farming: These are crops that are grown primarily for sale in market
    "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, pigeons, or other birds
    "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
    "creditselfjointanydec_e", -- This variable is a recode of creditselfjointborrow_e, creditselfjointuse_e, e, and 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 SACCOs merry-go-rounds
    "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 (goats, pigs, sheep)
    "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 (3) or input into most or all decisions (4). Those who have no input or input into very few decisions (1) are coded as a zero. Those who do not participate in an activity (G2.01 2), report that not decision was made (99), refuse (99) are coded as missing. ACTIVITY Wage and salary employment: This could be work that is paid for in cash or in-kind, including both agriculture and other wage work
    "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 fisheries producer s group (including marketing groups)
    "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 (cattle, camels, donkeys)
    "cluster", -- Cluster number
    "creditselfjointanydec_b", -- This variable is a recode of creditselfjointborrow_b, creditselfjointuse_b, b, and b. This variable indicates that the individual has been involved in decisionmaking on the credit taken from SOURCE . SOURCE Informal lender
    "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 (pieces plots, residential or commercial land)
    "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.
    "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 (3) or input into most or all decisions (4). Those who have no input or input into very few decisions (1) are coded as a zero. Those who do not participate in an activity (G2.01 2), report that not decision was made (99), refuse (99) are coded as missing. ACTIVITY Non-farm economic activities: This would include things like running a small business, self-employment, buy-and-sell
    "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)
    "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 (goats, pigs, sheep)
    "groupmember_m", -- This variable is a recode of G405_M. 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, or are not active members of a known group are coded as 0. GROUP Any other group or organization
    "own_f", -- This variable is a recode of G301A_F. It indicates that the household owns the ITEM . ITEM Farm equipment (non-mechanized: hand tools, ox plough)
    "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, or are not active members of a known group are coded as 0. GROUP Youth group
    "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, or are not active members of a known group are coded as 0. GROUP Agricultural livestock fisheries producer s group (including marketing groups)
    "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 (cattle, camels, donkeys)
    "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)
    "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: tractor-drawn plough, power tiller, treadle pump)
    "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 (3) or input into most or all decisions (4). Those who have no input or input into very few decisions (1) are coded as a zero. Those who do not participate in an activity (G2.01 2), report that not decision was made (99), refuse (99) are coded as missing. ACTIVITY Livestock raising
    "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, or are not active members of a known group are coded as 0. GROUP Education group
    "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: hand tools, ox plough)
    "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_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 (refrigerator, TV, sofa)
    "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
    "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_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
    "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, or are not active members of a known group are coded as 0. GROUP Water users group
    "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
    "own_d", -- This variable is a recode of G301A_D. It indicates that the household owns the ITEM . ITEM Chickens, ducks, turkeys, pigeons, or other birds
    "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
    "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: tractor-drawn plough, power tiller, treadle pump)
    "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)
    "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)
    "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 (pieces plots)
    "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 woman feels that they could make a decision (G5.02) regarding ACTIVITY . The woman is counted as feeling they could make a decision if they indicated to a small extent (2), medium extent (3), or to a high extent (4). Women who do not make a decision. ACTIVITY Getting inputs for agricultural production
    "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
    "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 (3) or input into most or all decisions (4). Those who have no input or input into very few decisions (1) are coded as a zero. Those who do not participate in an activity (G2.01 2), report that not decision was made (99), refuse (99) are coded as missing. ACTIVITY Food crop farming: These are crops that are grown primarily for household food consumption
    "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. ACTIVITY Livestock raising
    "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 (pieces plots)
    "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 (pieces plots)
    "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. This is based on the variable feelinputdecagr_sum.
    "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
    "zoi", -- This variable indicates that a record is included in the Feed the Future Zone of Influence. The ZOI includes the counties of Marsabit, Garissa, Isiolo, Wajir, and Turkana.
    "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, pigeons, or other birds
    "pbs_id", -- Administrative variable for identifying households
    "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)
FROM
    "usaid-gov/feed-the-future-northern-kenya-interim-survey-in-r3z6-2jv8:latest"."feed_the_future_northern_kenya_interim_survey_in"
LIMIT 100;

sgr mount socrata \
  "usaid-gov/feed-the-future-northern-kenya-interim-survey-in-r3z6-2jv8" \
  --handler-options '{
    "domain": "data.usaid.gov",
    "tables": {
        "feed_the_future_northern_kenya_interim_survey_in": "r3z6-2jv8"
    }
}'