FHIR Analytics View -> Table

{
  "name": "patient_identifiers",
  "resource": "Patient",
  "constants": [{ "name": "pi", "value": 3.14 }],
  "where": ["gender = 'female'", "birthDate > '1970'"],
  "select": [
    { "alias": "id", "path": "id" },
    { "alias": "pi_approx", "path": "%pi" },
    {
      "forEach": "identifier",
      "select": [
        { "alias": "system", "path": "system" },
        { "alias": "value", "path": "value" },
        {
          "from": "type",
          "select": [
            { "alias": "ident_type_text", "path": "text" },
            {
              "forEach": "coding",
              "select": [
                { "alias": "ident_type_system", "path": "system" },
                { "alias": "ident_type_code", "path": "code" }
              ]
            }
          ]
        }
      ]
    }
  ]
}