Exemplo n.º 1
0
 def columns(self):
     columns = self.get_columns_by_loc_level
     agg_columns = [
         DatabaseColumn(
             'num_children_0_6mo_enrolled_for_services',
             SumWhen(whens=[[
                 "age_tranche = '0' OR age_tranche = '6'", 'valid_in_month'
             ]],
                     alias='num_children_0_6mo_enrolled_for_services'),
             slug='num_children_0_6mo_enrolled_for_services'),
         DatabaseColumn(
             'num_children_6mo3yr_enrolled_for_services',
             SumWhen(whens=[[
                 "age_tranche = '12' OR age_tranche = '24' OR age_tranche = '36'",
                 'valid_in_month'
             ]],
                     alias='num_children_6mo3yr_enrolled_for_services'),
             slug='num_children_6mo3yr_enrolled_for_services'),
         DatabaseColumn(
             'num_children_3yr6yr_enrolled_for_services',
             SumWhen(whens=[[
                 "age_tranche = '48' OR age_tranche = '60' OR age_tranche = '72'",
                 'valid_in_month'
             ]],
                     alias='num_children_3yr6yr_enrolled_for_services'),
             slug='num_children_3yr6yr_enrolled_for_services'),
     ]
     return columns + agg_columns
Exemplo n.º 2
0
 def _get_form_duration_column(self, meta, slug_suffix, filters):
     slug = '%s%s' % (meta['slug'], slug_suffix)
     when = "xmlns = '%s'" % meta['xmlns']
     dur_col = SumWhen(whens={when: 'duration'},
                       else_=0,
                       filters=filters,
                       alias='%s_sum' % slug)
     count_col = SumWhen(whens={when: 1},
                         else_=0,
                         filters=filters,
                         alias='%s_count' % slug)
     return AggregateColumn(slug,
                            mean_seconds, [dur_col, count_col],
                            sortable=False)
Exemplo n.º 3
0
 def _get_form_sum_column(self, meta, slug_suffix, filters):
     slug = '%s%s' % (meta['slug'], slug_suffix)
     agg_col = SumWhen(whens={"xmlns = '%s'" % meta['xmlns']: 1},
                       else_=0,
                       filters=filters,
                       alias=slug)
     return DatabaseColumn(slug, agg_col, sortable=False)
 def get_columns(self, filters):
     return [
         DatabaseColumn('month', SimpleColumn('month')),
         AggregateColumn(
             'Percent of pregnant women who are anemic in given month',
             lambda x, y, z: ((x or 0) + (y or 0)) * 100 / float(z or 1), [
                 SumWhen(
                     whens=[["ccs_status = 'pregnant'", 'anemic_moderate']],
                     alias='anemic_moderate'),
                 SumWhen(
                     whens=[["ccs_status = 'pregnant'", 'anemic_severe']],
                     alias='anemic_severe'),
                 SumColumn('pregnant', alias='pregnant')
             ],
             slug='severe_anemic'),
         AggregateColumn(
             'Percent tetanus complete',
             percent_num,
             [SumColumn('tetanus_complete'),
              AliasColumn('pregnant')],
             slug='tetanus_complete'),
         AggregateColumn(
             'Percent women ANC 1 recieved by deliveryy',
             percent_num, [
                 SumColumn('anc1_received_at_delivery'),
                 SumColumn('delivered_in_month', alias='delivered_in_month')
             ],
             slug='anc_1'),
         AggregateColumn('Percent women ANC 2 received by delivery',
                         percent_num, [
                             SumColumn('anc2_received_at_delivery'),
                             AliasColumn('delivered_in_month')
                         ],
                         slug='anc_2'),
         AggregateColumn('Percent women ANC 3 received by delivery',
                         percent_num, [
                             SumColumn('anc3_received_at_delivery'),
                             AliasColumn('delivered_in_month')
                         ],
                         slug='anc_3'),
         AggregateColumn('Percent women ANC 4 received by delivery',
                         percent_num, [
                             SumColumn('anc4_received_at_delivery'),
                             AliasColumn('delivered_in_month')
                         ],
                         slug='anc_4'),
         AggregateColumn('Percent women Resting during pregnancy',
                         percent_num, [
                             SumColumn('resting_during_pregnancy'),
                             AliasColumn('pregnant')
                         ],
                         slug='resting'),
         AggregateColumn('Percent eating extra meal during pregnancy',
                         percent_num,
                         [SumColumn('extra_meal'),
                          AliasColumn('pregnant')],
                         slug='extra_meal'),
         AggregateColumn(
             'Percent trimester 3 women Counselled on immediate EBF during home visit',
             percent_num,
             [SumColumn('counsel_immediate_bf'),
              SumColumn('trimester_3')],
             slug='trimester')
     ]
Exemplo n.º 5
0
 def columns(self):
     columns = self.get_columns_by_loc_level
     agg_columns = [
         AggregateColumn(
             'Weighing efficiency (in month)',
             percent,
             [
                 SumWhen(
                     whens={"age_tranche != :age_72": 'nutrition_status_weighed'}, else_=0,
                     alias='nutrition_status_weighed'
                 ),
                 SumWhen(
                     whens={"age_tranche != :age_72": 'wer_eligible'}, else_=0,
                     alias='wer_eligible'
                 )
             ],
             slug='percent_weight_efficiency'
         ),
         AggregateColumn(
             'Height measurement efficiency (in month)',
             percent,
             [
                 SumWhen(
                     whens={"age_tranche != :age_72": 'height_measured_in_month'}, else_=0,
                     alias='height_measured_in_month_efficiency'
                 ),
                 SumWhen(
                     whens={"age_tranche != :age_72": 'height_eligible'}, else_=0,
                     alias='height_eligible',
                 )
             ],
             slug='height_measurement'
         ),
         DatabaseColumn(
             'Total number of unweighed children (0-5 Years)',
             SumWhen(
                 whens={"age_tranche != :age_72": 'nutrition_status_unweighed'}, else_=0,
                 alias='nutrition_status_unweighed'
             ),
             slug='total_number_unweighed'
         ),
         AggregateColumn(
             'Percentage of severely underweight children',
             percent,
             [
                 SumWhen(
                     whens={"age_tranche != :age_72": 'nutrition_status_severely_underweight'}, else_=0,
                     alias='nutrition_status_severely_underweight'
                 ),
                 AliasColumn('nutrition_status_weighed'),
             ],
             slug='percent_severe_underweight'
         ),
         AggregateColumn(
             'Percentage of moderately underweight children',
             percent,
             [
                 SumWhen(
                     whens={"age_tranche != :age_72": 'nutrition_status_moderately_underweight'}, else_=0,
                     alias='nutrition_status_moderately_underweight'
                 ),
                 AliasColumn('nutrition_status_weighed'),
             ],
             slug='percent_moderate_underweight'
         ),
         AggregateColumn(
             'Percentage of normal weight-for-age children',
             percent,
             [
                 SumWhen(
                     whens={"age_tranche != :age_72": 'nutrition_status_normal'}, else_=0,
                     alias='nutrition_status_normal'
                 ),
                 AliasColumn('nutrition_status_weighed'),
             ],
             slug='percent_normal_weight'
         ),
         AggregateColumn(
             'Percentage of children with severe wasting',
             percent,
             [
                 SumWhen(
                     whens={get_age_condition(self.beta): wasting_severe_column(self.beta)},
                     alias='wasting_severe'
                 ),
                 SumWhen(
                     whens={get_age_condition(self.beta): wfh_recorded_in_month_column(self.beta)},
                     alias='weighed_and_height_measured_in_month'
                 ),
             ],
             slug='percent_severe_wasting'
         ),
         AggregateColumn(
             'Percentage of children with moderate wasting',
             percent,
             [
                 SumWhen(
                     whens={get_age_condition(self.beta): wasting_moderate_column(self.beta)},
                     alias='wasting_moderate'
                 ),
                 AliasColumn('weighed_and_height_measured_in_month')
             ],
             slug='percent_moderate_wasting'
         ),
         AggregateColumn(
             'Percentage of children with normal weight-for-height',
             percent,
             [
                 SumWhen(
                     whens={get_age_condition(self.beta): wasting_normal_column(self.beta)},
                     alias='wasting_normal'
                 ),
                 AliasColumn('weighed_and_height_measured_in_month')
             ],
             slug='percent_normal_wasting'
         ),
         AggregateColumn(
             'Percentage of children with severe stunting',
             percent,
             [
                 SumWhen(
                     whens={get_age_condition(self.beta): stunting_severe_column(self.beta)},
                     alias='stunting_severe'
                 ),
                 SumWhen(
                     whens={get_age_condition(self.beta): hfa_recorded_in_month_column(self.beta)},
                     alias='height_measured_in_month'
                 ),
             ],
             slug='percent_severe_stunting'
         ),
         AggregateColumn(
             'Percentage of children with moderate stunting',
             percent,
             [
                 SumWhen(
                     whens={get_age_condition(self.beta): stunting_moderate_column(self.beta)},
                     alias='stunting_moderate'
                 ),
                 AliasColumn('height_measured_in_month')
             ],
             slug='percent_moderate_stunting'
         ),
         AggregateColumn(
             'Percentage of children with normal height-for-age',
             percent,
             [
                 SumWhen(
                     whens={get_age_condition(self.beta): stunting_normal_column(self.beta)},
                     alias='stunting_normal'
                 ),
                 AliasColumn('height_measured_in_month')
             ],
             slug='percent_normal_stunting'
         ),
         AggregateColumn(
             'Percent of newborns with low birth weight',
             percent,
             [
                 SumColumn('low_birth_weight_in_month'),
                 SumColumn('weighed_and_born_in_month')
             ],
             slug='newborn_low_birth_weight'
         ),
         AggregateColumn(
             'Percentage of children with completed 1 year immunizations',
             lambda x, y, z: '%.2f%%' % (((x or 0) + (y or 0)) * 100 / float(z or 1)),
             [
                 SumColumn('fully_immunized_on_time'),
                 SumColumn('fully_immunized_late'),
                 SumColumn('fully_immunized_eligible')
             ],
             slug='percent_completed_1year_immunizations'
         ),
         AggregateColumn(
             'Percentage of children breastfed at birth',
             percent,
             [
                 SumColumn('bf_at_birth'),
                 SumColumn('born_in_month')
             ],
             slug='percent_breastfed_at_birth'
         ),
         AggregateColumn(
             'Percentage of children exclusively breastfeeding',
             percent,
             [
                 SumColumn('ebf_in_month'),
                 SumColumn('ebf_eligible')
             ],
             slug='percent_ebf'
         ),
         AggregateColumn(
             'Percentage of children initiated complementary feeding (in the past 30 days)',
             percent,
             [
                 SumColumn('cf_initiation_in_month'),
                 SumColumn('cf_initiation_eligible')
             ],
             slug='percent_initiated_on_cf'
         ),
         AggregateColumn(
             'Percentage of children initiated appropriate complementary feeding',
             percent,
             [
                 SumColumn('cf_in_month'),
                 SumColumn('cf_eligible')
             ],
             slug='percent_appropriate_cf'
         ),
         AggregateColumn(
             'Percentage of children receiving complementary feeding with adequate diet diversity',
             percent,
             [
                 SumColumn('cf_diet_diversity'),
                 AliasColumn('cf_eligible')
             ],
             slug='percent_cf_diet_diversity'
         ),
         AggregateColumn(
             'Percentage of children receiving complementary feeding with adequate diet quanity',
             percent,
             [
                 SumColumn('cf_diet_quantity'),
                 AliasColumn('cf_eligible')
             ],
             slug='percent_cf_diet_quanity'
         ),
         AggregateColumn(
             "Percentage of children receiving complementary feeding "
             "with appropriate handwashing before feeding",
             percent,
             [
                 SumColumn('cf_handwashing'),
                 AliasColumn('cf_eligible')
             ],
             slug='percent_cf_handwashing_before_feeding'
         ),
     ]
     return columns + agg_columns
 def get_columns(self, filters):
     return [
         DatabaseColumn('month', SimpleColumn('month')),
         AggregateColumn(
             '% Weighing efficiency (Children <5 weighed)',
             percent_num, [
                 SumWhen(whens={
                     "age_tranche != :age_72":
                     'nutrition_status_weighed'
                 },
                         alias='nutrition_status_weighed'),
                 SumWhen(whens={"age_tranche != :age_72": 'wer_eligible'},
                         alias='wer_eligible')
             ],
             slug='status_weighed'),
         AggregateColumn(
             '% Height measurement efficiency (Children <5 measured)',
             percent_num, [
                 SumWhen(whens={
                     "age_tranche != :age_72":
                     'height_measured_in_month'
                 },
                         alias='height_measured_in_month_less_5'),
                 SumWhen(
                     whens={"age_tranche != :age_72": 'height_eligible'},
                     alias='height_eligible')
             ],
             slug='status_height_efficiency'),
         DatabaseColumn(
             'Total number Unweighed',
             SumWhen(whens={
                 "age_tranche != :age_72": 'nutrition_status_unweighed'
             },
                     alias='nutrition_status_unweighed')),
         AggregateColumn(
             'Percent Children severely underweight (weight for age)',
             percent_num, [
                 SumWhen(whens={
                     "age_tranche != :age_72":
                     'nutrition_status_severely_underweight'
                 },
                         alias='nutrition_status_severely_underweight'),
                 AliasColumn('nutrition_status_weighed')
             ],
             slug='severely_underweight'),
         AggregateColumn(
             'Percent Children moderately underweight (weight for age)',
             percent_num, [
                 SumWhen(whens={
                     "age_tranche != :age_72":
                     'nutrition_status_moderately_underweight'
                 },
                         alias='nutrition_status_moderately_underweight'),
                 AliasColumn('nutrition_status_weighed')
             ],
             slug='moderately_underweight'),
         AggregateColumn(
             'Percent Children normal (weight for age)',
             percent_num, [
                 SumWhen(whens={
                     "age_tranche != :age_72": 'nutrition_status_normal'
                 },
                         alias='nutrition_status_normal'),
                 AliasColumn('nutrition_status_weighed')
             ],
             slug='status_normal'),
         AggregateColumn(
             'Percent children with severe acute malnutrition (weight-for-height)',
             percent_num, [
                 SumWhen(whens={
                     get_age_condition(self.beta):
                     wasting_severe_column(self.beta)
                 },
                         alias='wasting_severe'),
                 SumWhen(whens={
                     get_age_condition(self.beta):
                     wfh_recorded_in_month_column(self.beta)
                 },
                         alias='weighed_and_height_measured_in_month')
             ],
             slug='wasting_severe'),
         AggregateColumn(
             'Percent children with moderate acute malnutrition (weight-for-height)',
             percent_num, [
                 SumWhen(whens={
                     get_age_condition(self.beta):
                     wasting_moderate_column(self.beta)
                 },
                         alias='wasting_moderate'),
                 AliasColumn('weighed_and_height_measured_in_month')
             ],
             slug='wasting_moderate'),
         AggregateColumn(
             'Percent children normal (weight-for-height)',
             percent_num, [
                 SumWhen(whens={
                     get_age_condition(self.beta):
                     wasting_normal_column(self.beta)
                 },
                         alias='wasting_normal'),
                 AliasColumn('weighed_and_height_measured_in_month')
             ],
             slug='wasting_normal'),
         AggregateColumn(
             'Percent children with severe stunting (height for age)',
             percent_num, [
                 SumWhen(whens={
                     get_age_condition(self.beta):
                     stunting_severe_column(self.beta)
                 },
                         alias='zscore_grading_hfa_severe'),
                 SumWhen(whens={
                     get_age_condition(self.beta):
                     hfa_recorded_in_month_column(self.beta)
                 },
                         alias='height_measured_in_month')
             ],
             slug='stunting_severe'),
         AggregateColumn(
             'Percent children with moderate stunting (height for age)',
             percent_num, [
                 SumWhen(whens={
                     get_age_condition(self.beta):
                     stunting_moderate_column(self.beta)
                 },
                         alias='zscore_grading_hfa_moderate'),
                 AliasColumn('height_measured_in_month')
             ],
             slug='stunting_moderate'),
         AggregateColumn('Percent children with normal (height for age)',
                         percent_num, [
                             SumWhen(whens={
                                 get_age_condition(self.beta):
                                 stunting_normal_column(self.beta)
                             },
                                     alias='zscore_grading_hfa_normal'),
                             AliasColumn('height_measured_in_month')
                         ],
                         slug='stunting_normal'),
         AggregateColumn(
             'Percent children immunized with 1st year immunizations',
             lambda x, y, z: ((x or 0) + (y or 0)) * 100 / float(z or 1), [
                 SumColumn('fully_immunized_on_time'),
                 SumColumn('fully_immunized_late'),
                 SumColumn('fully_immunized_eligible')
             ],
             slug='fully_immunized'),
         AggregateColumn(
             'Percent Children breastfed at birth',
             percent_num,
             [SumColumn('bf_at_birth'),
              SumColumn('born_in_month')],
             slug='breastfed_at_birth'),
         AggregateColumn(
             'Percent Children exclusively breastfed',
             percent_num,
             [SumColumn('ebf_in_month'),
              SumColumn('ebf_eligible')],
             slug='exclusively_breastfed'),
         AggregateColumn(
             'Percent Children initiated appropriate complementary feeding',
             percent_num, [
                 SumColumn('cf_initiation_in_month'),
                 SumColumn('cf_initiation_eligible')
             ],
             slug='cf_initiation'),
         AggregateColumn(
             'Perecent children complementary feeding',
             percent_num,
             [SumColumn('cf_in_month'),
              SumColumn('cf_eligible')],
             slug='complementary_feeding'),
         AggregateColumn(
             'Percentage of children consuming atleast 4 food groups',
             percent_num,
             [SumColumn('cf_diet_diversity'),
              AliasColumn('cf_eligible')],
             slug='diet_diversity'),
         AggregateColumn(
             'Percentage of children consuming adequate food',
             percent_num,
             [SumColumn('cf_diet_quantity'),
              AliasColumn('cf_eligible')],
             slug='diet_quantity'),
         AggregateColumn(
             'Percentage of children whose mothers handwash before feeding',
             percent_num,
             [SumColumn('cf_handwashing'),
              AliasColumn('cf_eligible')],
             slug='handwashing'),
         DatabaseColumn(
             'Children (0 - 28 Days) Seeking Services',
             SumWhen(whens={'age_tranche = :age_0': 'valid_in_month'},
                     alias='zero'),
             slug='zero'),
         DatabaseColumn(
             'Children (28 Days - 6 mo) Seeking Services',
             SumWhen(whens={'age_tranche = :age_6': 'valid_in_month'},
                     alias='one'),
             slug='one'),
         DatabaseColumn(
             'Children (6 mo - 1 year) Seeking Services',
             SumWhen(whens={'age_tranche = :age_12': 'valid_in_month'},
                     alias='two'),
             slug='two'),
         DatabaseColumn(
             'Children (1 year - 3 years) Seeking Services',
             SumWhen(whens={
                 'age_tranche = :age_24 OR age_tranche = :age_36':
                 'valid_in_month'
             },
                     alias='three'),
             slug='three'),
         DatabaseColumn(
             'Children (3 years - 6 years) Seeking Services',
             SumWhen(whens={
                 'age_tranche = :age_48 OR age_tranche = :age_60 OR age_tranche = :age_72':
                 'valid_in_month'
             },
                     alias='four'),
             slug='four'),
         AggregateColumn(
             'Percent of children born in month with low birth weight',
             percent_num, [
                 SumColumn('low_birth_weight_in_month'),
                 SumColumn('weighed_and_born_in_month')
             ],
             slug='low_birth_weight')
     ]
Exemplo n.º 7
0
 def sql_column(self):
     return SumWhen(self.key, whens=self.whens, else_=0, alias=self.alias).sql_column
Exemplo n.º 8
0
    def columns(self):
        columns = self.get_columns_by_loc_level
        agg_columns = [
            AggregateColumn(
                'Weighing efficiency (in month)',
                percent, [
                    SumWhen(whens={
                        "age_tranche != :age_72":
                        'nutrition_status_weighed'
                    },
                            else_=0,
                            alias='nutrition_status_weighed'),
                    SumWhen(whens={"age_tranche != :age_72": 'wer_eligible'},
                            else_=0,
                            alias='wer_eligible')
                ],
                slug='percent_weight_efficiency'),
            AggregateColumn(
                'Height measurement efficiency (in month)',
                percent, [
                    SumWhen(whens={
                        "age_tranche != :age_72":
                        'height_measured_in_month'
                    },
                            else_=0,
                            alias='height_measured_in_month_efficiency'),
                    SumWhen(
                        whens={"age_tranche != :age_72": 'height_eligible'},
                        else_=0,
                        alias='height_eligible',
                    )
                ],
                slug='height_measurement'),
            DatabaseColumn('Total number of unweighed children (0-5 Years)',
                           SumWhen(whens={
                               "age_tranche != :age_72":
                               'nutrition_status_unweighed'
                           },
                                   else_=0,
                                   alias='nutrition_status_unweighed'),
                           slug='total_number_unweighed'),
            AggregateColumn(
                'Percentage of severely underweight children',
                percent, [
                    SumWhen(whens={
                        "age_tranche != :age_72":
                        'nutrition_status_severely_underweight'
                    },
                            else_=0,
                            alias='nutrition_status_severely_underweight'),
                    AliasColumn('nutrition_status_weighed'),
                ],
                slug='percent_severe_underweight'),
            AggregateColumn(
                'Percentage of moderately underweight children',
                percent, [
                    SumWhen(whens={
                        "age_tranche != :age_72":
                        'nutrition_status_moderately_underweight'
                    },
                            else_=0,
                            alias='nutrition_status_moderately_underweight'),
                    AliasColumn('nutrition_status_weighed'),
                ],
                slug='percent_moderate_underweight'),
            AggregateColumn(
                'Percentage of normal weight-for-age children',
                percent, [
                    SumWhen(whens={
                        "age_tranche != :age_72": 'nutrition_status_normal'
                    },
                            else_=0,
                            alias='nutrition_status_normal'),
                    AliasColumn('nutrition_status_weighed'),
                ],
                slug='percent_normal_weight'),
            AggregateColumn(
                'Percentage of children with severe wasting',
                percent, [
                    SumWhen(whens={
                        get_age_condition(self.beta):
                        wasting_severe_column(self.beta)
                    },
                            alias='wasting_severe'),
                    SumWhen(whens={
                        get_age_condition(self.beta):
                        wfh_recorded_in_month_column(self.beta)
                    },
                            alias='weighed_and_height_measured_in_month'),
                ],
                slug='percent_severe_wasting'),
            AggregateColumn(
                'Percentage of children with moderate wasting',
                percent, [
                    SumWhen(whens={
                        get_age_condition(self.beta):
                        wasting_moderate_column(self.beta)
                    },
                            alias='wasting_moderate'),
                    AliasColumn('weighed_and_height_measured_in_month')
                ],
                slug='percent_moderate_wasting'),
            AggregateColumn(
                'Percentage of children with normal weight-for-height',
                percent, [
                    SumWhen(whens={
                        get_age_condition(self.beta):
                        wasting_normal_column(self.beta)
                    },
                            alias='wasting_normal'),
                    AliasColumn('weighed_and_height_measured_in_month')
                ],
                slug='percent_normal_wasting'),
            AggregateColumn('Percentage of children with severe stunting',
                            percent, [
                                SumWhen(whens={
                                    get_age_condition(self.beta):
                                    stunting_severe_column(self.beta)
                                },
                                        alias='stunting_severe'),
                                SumWhen(whens={
                                    get_age_condition(self.beta):
                                    hfa_recorded_in_month_column(self.beta)
                                },
                                        alias='height_measured_in_month'),
                            ],
                            slug='percent_severe_stunting'),
            AggregateColumn('Percentage of children with moderate stunting',
                            percent, [
                                SumWhen(whens={
                                    get_age_condition(self.beta):
                                    stunting_moderate_column(self.beta)
                                },
                                        alias='stunting_moderate'),
                                AliasColumn('height_measured_in_month')
                            ],
                            slug='percent_moderate_stunting'),
            AggregateColumn(
                'Percentage of children with normal height-for-age',
                percent, [
                    SumWhen(whens={
                        get_age_condition(self.beta):
                        stunting_normal_column(self.beta)
                    },
                            alias='stunting_normal'),
                    AliasColumn('height_measured_in_month')
                ],
                slug='percent_normal_stunting'),
            AggregateColumn('Percent of newborns with low birth weight',
                            percent, [
                                SumColumn('low_birth_weight_in_month',
                                          alias='low_birth_weight_in_month'),
                                SumColumn('weighed_and_born_in_month',
                                          alias='weighed_and_born_in_month')
                            ],
                            slug='newborn_low_birth_weight'),
            AggregateColumn(
                'Percentage of children with completed 1 year immunizations',
                lambda x, y, z: '%.2f%%' % ((
                    (x or 0) + (y or 0)) * 100 / float(z or 1)), [
                        SumColumn('fully_immunized_on_time',
                                  alias='fully_immunized_on_time'),
                        SumColumn('fully_immunized_late',
                                  alias='fully_immunized_late'),
                        SumColumn('fully_immunized_eligible',
                                  alias='fully_immunized_eligible')
                    ],
                slug='percent_completed_1year_immunizations'),
            AggregateColumn(
                'Percentage of children breastfed at birth',
                percent, [
                    SumColumn('bf_at_birth', alias='bf_at_birth'),
                    SumColumn('born_in_month', alias='born_in_month')
                ],
                slug='percent_breastfed_at_birth'),
            AggregateColumn(
                'Percentage of children exclusively breastfeeding',
                percent, [
                    SumColumn('ebf_in_month', alias='ebf_in_month'),
                    SumColumn('ebf_eligible', alias='ebf_eligible')
                ],
                slug='percent_ebf'),
            AggregateColumn(
                'Percentage of children initiated complementary feeding (in the past 30 days)',
                percent, [
                    SumColumn('cf_initiation_in_month',
                              alias='cf_initiation_in_month'),
                    SumColumn('cf_initiation_eligible',
                              alias='cf_initiation_eligible')
                ],
                slug='percent_initiated_on_cf'),
            AggregateColumn(
                'Percentage of children initiated appropriate complementary feeding',
                percent, [
                    SumColumn('cf_in_month', alias='cf_in_month'),
                    SumColumn('cf_eligible', alias='cf_eligible')
                ],
                slug='percent_appropriate_cf'),
            AggregateColumn(
                'Percentage of children receiving complementary feeding with adequate diet diversity',
                percent, [
                    SumColumn('cf_diet_diversity', alias='cf_diet_diversity'),
                    AliasColumn('cf_eligible')
                ],
                slug='percent_cf_diet_diversity'),
            AggregateColumn(
                'Percentage of children receiving complementary feeding with adequate diet quantity',
                percent, [
                    SumColumn('cf_diet_quantity', alias='cf_diet_quantity'),
                    AliasColumn('cf_eligible')
                ],
                slug='percent_cf_diet_quanity'),
            AggregateColumn(
                "Percentage of children receiving complementary feeding "
                "with appropriate handwashing before feeding",
                percent, [
                    SumColumn('cf_handwashing', alias='cf_handwashing'),
                    AliasColumn('cf_eligible')
                ],
                slug='percent_cf_handwashing_before_feeding'),
        ]
        agg_columns.insert(
            0,
            DatabaseColumn('Total no. of children weighed',
                           AliasColumn('nutrition_status_weighed'),
                           slug='nutrition_status_weighed'))
        agg_columns.insert(
            1,
            DatabaseColumn('Total no. of children eligible to be weighed',
                           AliasColumn('wer_eligible'),
                           slug='wer_eligible'))

        agg_columns.insert(
            3,
            DatabaseColumn('Total no. of children whose height was measured',
                           AliasColumn('height_measured_in_month_efficiency'),
                           slug='height_measured_in_month_efficiency'))
        agg_columns.insert(
            4,
            DatabaseColumn(
                'Total no. of children  eligible for measuring height',
                AliasColumn('height_eligible'),
                slug='height_eligible'))

        agg_columns.insert(
            7,
            DatabaseColumn(
                'No. of severely underweight children',
                AliasColumn('nutrition_status_severely_underweight'),
                slug='nutrition_status_severely_underweight'))
        agg_columns.insert(
            8,
            DatabaseColumn('Total No. of children weighed',
                           AliasColumn('nutrition_status_weighed'),
                           slug='nutrition_status_weighed'))

        agg_columns.insert(
            10,
            DatabaseColumn(
                'No. of moderately underweight children ',
                AliasColumn('nutrition_status_moderately_underweight'),
                slug='nutrition_status_moderately_underweight'))
        agg_columns.insert(
            11,
            DatabaseColumn('Total No. of children weighed',
                           AliasColumn('nutrition_status_weighed'),
                           slug='nutrition_status_weighed'))

        agg_columns.insert(
            13,
            DatabaseColumn('No. of  children with normal weight for age',
                           AliasColumn('nutrition_status_normal'),
                           slug='nutrition_status_normal'))
        agg_columns.insert(
            14,
            DatabaseColumn('Total No. of children weighed',
                           AliasColumn('nutrition_status_weighed'),
                           slug='nutrition_status_weighed'))

        agg_columns.insert(
            16,
            DatabaseColumn('No. of Children with severe wasting',
                           AliasColumn('wasting_severe'),
                           slug='wasting_severe'))
        agg_columns.insert(
            17,
            DatabaseColumn(
                'Total number of children whose height and weight is measured',
                AliasColumn('weighed_and_height_measured_in_month'),
                slug='weighed_and_height_measured_in_month'))

        agg_columns.insert(
            19,
            DatabaseColumn('No. of moderately wasted children',
                           AliasColumn('wasting_moderate'),
                           slug='wasting_moderate'))
        agg_columns.insert(
            20,
            DatabaseColumn(
                'Total number of children whose height and weight is measured',
                AliasColumn('weighed_and_height_measured_in_month'),
                slug='weighed_and_height_measured_in_month'))

        agg_columns.insert(
            22,
            DatabaseColumn('No. of children with normal weight-for-height',
                           AliasColumn('wasting_normal'),
                           slug='wasting_normal'))
        agg_columns.insert(
            23,
            DatabaseColumn(
                'Total no. of children  whose height and weight is measured',
                AliasColumn('weighed_and_height_measured_in_month'),
                slug='weighed_and_height_measured_in_month'))

        agg_columns.insert(
            25,
            DatabaseColumn('No. of severely stunted children',
                           AliasColumn('stunting_severe'),
                           slug='stunting_severe'))
        agg_columns.insert(
            26,
            DatabaseColumn(
                'Total no. of children whose height has been measured',
                AliasColumn('height_measured_in_month'),
                slug='height_measured_in_month'))

        agg_columns.insert(
            28,
            DatabaseColumn('No. of moderately stunted children',
                           AliasColumn('stunting_moderate'),
                           slug='stunting_moderate'))
        agg_columns.insert(
            29,
            DatabaseColumn(
                'Total no. of children whose height has been measured',
                AliasColumn('height_measured_in_month'),
                slug='height_measured_in_month'))

        agg_columns.insert(
            31,
            DatabaseColumn('No. of children with normal height for age',
                           AliasColumn('stunting_normal'),
                           slug='stunting_normal'))
        agg_columns.insert(
            32,
            DatabaseColumn(
                'Total no. of children whose height has been measured',
                AliasColumn('height_measured_in_month'),
                slug='height_measured_in_month'))

        agg_columns.insert(
            34,
            DatabaseColumn('No. of newborns with low birth weight',
                           AliasColumn('low_birth_weight_in_month'),
                           slug='low_birth_weight_in_month'))
        agg_columns.insert(
            35,
            DatabaseColumn(
                'Total no. of children born and weighed in the current month',
                AliasColumn('weighed_and_born_in_month'),
                slug='weighed_and_born_in_month'))

        agg_columns.insert(
            37,
            AggregateColumn('No. of children completed 1 year immunization',
                            lambda x, y: ((x or 0) + (y or 0)), [
                                AliasColumn('fully_immunized_on_time'),
                                AliasColumn('fully_immunized_late')
                            ],
                            slug='num_immun_children'))
        agg_columns.insert(
            38,
            DatabaseColumn('Total no. of children from age >12 months',
                           AliasColumn('fully_immunized_eligible'),
                           slug='fully_immunized_eligible'))

        agg_columns.insert(
            40,
            DatabaseColumn('No. of children breastfed at birth',
                           AliasColumn('bf_at_birth'),
                           slug='bf_at_birth'))
        agg_columns.insert(
            41,
            DatabaseColumn(
                'Total no. of children enrolled in ICDS-CAS system and born in last month',
                AliasColumn('born_in_month'),
                slug='born_in_month'))

        agg_columns.insert(
            43,
            DatabaseColumn('No. of children exclusively breastfed',
                           AliasColumn('ebf_in_month'),
                           slug='ebf_in_month'))
        agg_columns.insert(
            44,
            DatabaseColumn(
                'Total number of children (0-6 months) of age enrolled in ICDS-CAS system',
                AliasColumn('ebf_eligible'),
                slug='ebf_eligible'))

        agg_columns.insert(
            46,
            DatabaseColumn(
                'No. of children initiated complementary feeding (in the past 30 days)',
                AliasColumn('cf_initiation_in_month'),
                slug='cf_initiation_in_month'))
        agg_columns.insert(
            47,
            DatabaseColumn(
                'Total no. of children (6-8 ) months of age enrolled with ICDS-CAS',
                AliasColumn('cf_initiation_eligible'),
                slug='cf_initiation_eligible'))

        agg_columns.insert(
            49,
            DatabaseColumn(
                'No. of children initiated appropriate complementary feeding',
                AliasColumn('cf_in_month'),
                slug='cf_in_month'))
        agg_columns.insert(
            50,
            DatabaseColumn(
                'No.of children (6-24) months of age enrolled with ICDS-CAS',
                AliasColumn('cf_eligible'),
                slug='cf_eligible'))

        agg_columns.insert(
            52,
            DatabaseColumn(
                'No.of children receiving complementary feeding with adequate diet diversity',
                AliasColumn('cf_diet_diversity'),
                slug='cf_diet_diversity'))
        agg_columns.insert(
            53,
            DatabaseColumn(
                'Total number of children (6 months - 2 yrs) of age enrolled with ICDS-CAS',
                AliasColumn('cf_eligible'),
                slug='cf_eligible'))

        agg_columns.insert(
            55,
            DatabaseColumn(
                'No. of children initiated complementary feeding with adequate diet quantity',
                AliasColumn('cf_diet_quantity'),
                slug='cf_diet_quantity'))
        agg_columns.insert(
            56,
            DatabaseColumn(
                'No.of children (6-24) months of age enrolled with ICDS-CAS',
                AliasColumn('cf_eligible'),
                slug='cf_eligible'))

        agg_columns.insert(
            58,
            DatabaseColumn(
                'Total Number of children receiving complementary feeding '
                'with appropriate handwashing before feeding',
                AliasColumn('cf_handwashing'),
                slug='cf_handwashing'))
        agg_columns.insert(
            59,
            DatabaseColumn(
                'No.of children (6-24) months of age enrolled with ICDS-CAS',
                AliasColumn('cf_eligible'),
                slug='cf_eligible'))
        return columns + agg_columns