<commit_before>{
  "domains": [
    "icds-dashboard-qa",
    "icds-cas"
  ],
  "server_environment": [
    "softlayer",
    "icds-new"
  ],
  "config": {
    "table_id": "static-infrastructure_form_v2",
    "display_name": "Forms - Infrastructure V2 (Static)",
    "referenced_doc_type": "XFormInstance",
    "description": "",
    "base_item_expression": {},
    "configured_filter": {
      "operator": "eq",
      "expression": {
        "type": "property_name",
        "property_name": "xmlns"
      },
      "type": "boolean_expression",
      "property_value": "http://openrosa.org/formdesigner/BEB94AFD-E063-46CC-AA75-BECD3C0FC20C"
    },
    "configured_indicators": [
      {
        "display_name": "AWC ID",
        "transform": {},
        "datatype": "string",
        "expression": {
          "type": "named",
          "name": "user_location_id"
        },
        "is_primary_key": false,
        "is_nullable": true,
        "column_id": "awc_id",
        "create_index": true,
        "type": "expression"
      },
      {
        "display_name": "Supervisor ID",
        "transform": {},
        "datatype": "string",
        "expression": {
          "type": "ancestor_location",
          "location_id": {
            "type": "named",
            "name": "user_location_id"
          },
          "location_type": "supervisor",
          "location_property": "_id"
        },
        "is_primary_key": false,
        "is_nullable": true,
        "column_id": "supervisor_id",
        "create_index": true,
        "type": "expression"
      },
      {
        "display_name": "Block ID",
        "transform": {},
        "datatype": "string",
        "expression": {
          "type": "ancestor_location",
          "location_id": {
            "type": "named",
            "name": "user_location_id"
          },
          "location_type": "block",
          "location_property": "_id"
        },
        "is_primary_key": false,
        "is_nullable": true,
        "column_id": "block_id",
        "type": "expression"
      },
      {
        "display_name": "District ID",
        "transform": {},
        "datatype": "string",
        "expression": {
          "type": "ancestor_location",
          "location_id": {
            "type": "named",
            "name": "user_location_id"
          },
          "location_type": "district",
          "location_property": "_id"
        },
        "is_primary_key": false,
        "is_nullable": true,
        "column_id": "district_id",
        "type": "expression"
      },
      {
        "display_name": "State ID",
        "transform": {},
        "datatype": "string",
        "expression": {
          "type": "ancestor_location",
          "location_id": {
            "type": "named",
            "name": "user_location_id"
          },
          "location_type": "state",
          "location_property": "_id"
        },
        "is_primary_key": false,
        "is_nullable": true,
        "column_id": "state_id",
        "type": "expression"
      },
      {
        "column_id": "timeend",
        "datatype": "datetime",
        "type": "expression",
        "expression": {
          "type": "root_doc",
          "expression": {
            "datatype": "date",
            "type": "property_path",
            "property_path": [
              "form",
              "meta",
              "timeEnd"
            ]
          }
        }
      },
      {
        "column_id": "received_on",
        "datatype": "datetime",
        "type": "expression",
        "expression": {
          "datatype": "datetime",<commit_msg>Clean up location column definitions<commit_after>{
  "domains": [
    "icds-dashboard-qa",
    "icds-cas"
  ],
  "server_environment": [
    "softlayer",
    "icds-new"
  ],
  "config": {
    "table_id": "static-infrastructure_form_v2",
    "display_name": "Forms - Infrastructure V2 (Static)",
    "referenced_doc_type": "XFormInstance",
    "description": "",
    "base_item_expression": {},
    "configured_filter": {
      "operator": "eq",
      "expression": {
        "type": "property_name",
        "property_name": "xmlns"
      },
      "type": "boolean_expression",
      "property_value": "http://openrosa.org/formdesigner/BEB94AFD-E063-46CC-AA75-BECD3C0FC20C"
    },
    "configured_indicators": [
      {
        "column_id": "awc_id",
        "datatype": "string",
        "type": "expression",
        "expression": {
          "type": "named",
          "name": "user_location_id"
        },
        "create_index": true
      },
      {
        "column_id": "supervisor_id",
        "datatype": "string",
        "type": "expression",
        "expression": {
          "type": "ancestor_location",
          "location_id": {
            "type": "named",
            "name": "user_location_id"
          },
          "location_type": "supervisor",
          "location_property": "_id"
        },
        "create_index": true
      },
      {
        "column_id": "block_id",
        "datatype": "string",
        "type": "expression",
        "expression": {
          "type": "ancestor_location",
          "location_id": {
            "type": "named",
            "name": "user_location_id"
          },
          "location_type": "block",
          "location_property": "_id"
        }
      },
      {
        "column_id": "district_id",
        "datatype": "string",
        "type": "expression",
        "expression": {
          "type": "ancestor_location",
          "location_id": {
            "type": "named",
            "name": "user_location_id"
          },
          "location_type": "district",
          "location_property": "_id"
        }
      },
      {
        "column_id": "state_id",
        "datatype": "string",
        "type": "expression",
        "expression": {
          "type": "ancestor_location",
          "location_id": {
            "type": "named",
            "name": "user_location_id"
          },
          "location_type": "state",
          "location_property": "_id"
        }
      },
      {
        "column_id": "timeend",
        "datatype": "datetime",
        "type": "expression",
        "expression": {
          "type": "root_doc",
          "expression": {
            "datatype": "date",
            "type": "property_path",
            "property_path": [
              "form",
              "meta",
              "timeEnd"
            ]
          }
        }
      },
      {
        "column_id": "received_on",
        "datatype": "datetime",
        "type": "expression",
        "expression": {
          "datatype": "datetime",
{'fraction_non_alphanumeric': 0.1656590084643289, 'fraction_numerical': 0.004534461910519952, 'mean_word_length': 1.6854707792207793, 'pattern_counts': {'":': 176, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 2}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '3522098', 'n_tokens_mistral': 2041, 'n_tokens_neox': 2024, 'n_words': 335}