Data File 30 Days Trailing

The data file contains observations of all households that are surveyed and accepted in the trailing 30 days. The first row in the data file contains variable names (column headers). Each row after the first row consists of observation of one household. Each household is uniquely identified by an identity number. Variables in the data file used for the estimation are described below:
  • HH_ ID: This is the unique identifier of a household.
  • COUNTRY: This is the country in which the household is located.
  • STATE: This corresponds to the states of India, in which the household is located.
  • HR: This corresponds to the Homogeneous Region number.
  • TOWN_VILLAGE: This indicates the village number in case of rural regions and town number in case of urban regions.
  • REGION_TYPE: This indicates whether the household is located in a rural region or in an urban region.
  • MONTH_SLOT: This indicates the month in which the household was scheduled for execution.
  • EXECUTION_DATE: This is the date on which the survey was conducted.
  • ORV_DATE: This indicates the date on which validation of the households' data was commenced by the ORV (independent validation) team.
  • SURVEY_STATUS: This is the status of the survey for a household, i.e. it was 'Accepted' by the ORV team.
  • STRATA: The strata as defined in sample design. This is the combination of State and Region Type.
  • FPC_REGION_HR_STATE_TOTAL: This is the number of Homogeneous Regions (surveyed and non-surveyed) in a state.
  • FPC_REGION_TV_HR_TOTAL: This is the number of towns (surveyed and non-surveyed) in the urban region of a state or the number of villages (surveyed and non-surveyed) in the rural region of a state as per Census 2011, depending on whether REGION_TYPE is urban or rural, respectively.
  • FPC_REGION_HH_TV: This is the estimated number of Households (surveyed and non-surveyed) in a town or village (surveyed and non-surveyed) as per Census 2011, depending on whether REGION_TYPE is urban or rural, respectively.
  • HH_WEIGHT_STATE_REGTYPE_ACC: This is the weight assigned to a household for trailing 30 day estimations.
    1. For towns, it is a ratio of estimated number of households in the urban region of a State in the trailing 30 days to the surveyed households of the urban region of the State in the trailing 30 days.
    2. Estimated number of households in urban region of a State in the trailing 30 days is calculated by using the Compounded Annual Growth Rate (CAGR) on the Census 2001-Census 2011 data for the urban households of the State, compounded on a daily basis.
    3. Surveyed households in the urban region of a State on a day are households that are surveyed on the day and are accepted by an independent validation system on the same day.
    4. For villages, it is a ratio of the estimated number of households in the rural region of a State in the trailing 30 days to the surveyed households of the rural region of the State in the trailing 30 days.
    5. Estimated number of households in rural region of a State in the trailing 30 days is calculated by using the Compounded Annual Growth Rate (CAGR) for the rural households of the State, compounded on a daily basis.
    6. Surveyed households in the rural region of a State on a day are households that are surveyed on the day and are accepted by an independent validation system on the same day.
      1. CONSENTI_QUESTION_1_RESPONSE: The household can choose
        between three options-Better, Same, Worse.
      2. CONSENTI_QUESTION_2_RESPONSE: The household can choose
        between three options-Better, Same, Worse.
      3. CONSENTI_QUESTION_3_RESPONSE: The household can choose
        between three options- Good times, Uncertain times, Bad times.
      4. CONSENTI_QUESTION_4_RESPONSE: The household can choose
        between three options-Continuously good times, Uncertain with ups and down, Continuously bad times.
      5. CONSENTI_QUESTION_5_RESPONSE: The household can choose
        between three options-Good time, Same as other time, Bad time.
Dummy Variables
Each response recorded for each of the five questions in the raw data file is assigned a dummy variable. For each question, the response chosen by the household is assigned a value of 1. The other response then receives a value of 0. These are:
  • QUESTION_1_BETTER: The favourable response to question number 1 receives a value of 1 when the household chooses the option-"BETTER". It is denoted as X1.
  • QUESTION_1_WORSE: The unfavourable response to question number 1 receives a value of 1 when the household chooses the option-"WORSE". It is denoted as Y1.
  • QUESTION_2_BETTER: The favourable response to question number 2 receives a value of 1 when the household chooses the option-"BETTER". It is denoted as X2.
  • QUESTION_2_WORSE: The unfavourable response to question number 2 receives a value of 1 when the household chooses the third option-"WORSE". It is denoted as Y2.
  • QUESTION_3_GOOD_TIMES: The favourable response to question number 3 receives a value of 1 when the household chooses the option-"GOOD TIMES". It is denoted as X3.
  • QUESTION_3_BAD_TIMES: The unfavourable response to question number 3 receives a value of 1 when the household chooses the option-"BAD TIMES". It is denoted as Y3.
  • QUESTION_4_CONTINUOUSLY_GOOD_TIMES: The favourable response to question number 4 receives a value of 1 when the household chooses the option-"CONTINUOUSLY GOOD TIMES". It is denoted as X14.
  • QUESTION_4_CONTINUOUSLY_BAD_TIMES: The unfavourable response to question number 4 receives a value of 1 when the household chooses the option-"CONTINUOUSLY BAD TIMES". It is denoted as Y14.
  • QUESTION_5_GOOD_TIME: The favourable response to question number 5 receives a value of 1 when the household chooses the option-"GOOD TIME". It is denoted as X15.
  • QUESTION_5_BAD_TIME: The unfavourable response to question number 5 receives a value of 1 when the household chooses the third option-"BAD TIME". It is denoted as Y15.