[
  {
    "phenotype_id": "PH142",
    "phenotype_version_id": 284,
    "name": "Collapsed vertebra",
    "definition": "At the specified date, a patient is defined as having had 'Collapsed vertebra' IF they meet the criteria for any of the following on or before the specified date. The earliest date on which the individual meets any of the following criteria on or before the specified date is defined as the first event date:\n\n\nPrimary care\n\n\n1. 'Collapsed vertebra' diagnosis or history of diagnosis or procedure during a consultation \n\nOR\nSecondary care (ICD10)\n\n\n1. ALL diagnoses of 'Collapsed vertebra' or history of diagnosis during a hospitalization\nOR\nSecondary care (OPCS4)\n\n\n1. ALL procedures for 'Collapsed vertebra' during a hospitalization\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n",
    "implementation": "",
    "publications": [
      {
        "doi": "10.1016/S2589-7500(19)30012-3",
        "details": "Kuan V., Denaxas S., Gonzalez-Izquierdo A. et al. A chronological map of 308 physical and mental health conditions from 4 million individuals in the National Health Service. The Lancet Digital Health - DOI 10.1016/S2589-7500(19)30012-3"
      }
    ],
    "validation": "",
    "citation_requirements": "",
    "created": "2021-10-06T16:04:48.574572Z",
    "author": "Kuan V, Denaxas S, Gonzalez-Izquierdo A, Direk K, Bhatti O, Husain S, Sutaria S, Hingorani M, Nitsch D, Parisinos C, Lumbers T, Mathur R, Sofat R, Casas JP, Wong I, Hemingway H, Hingorani A",
    "collections": [
      {
        "name": "CALIBER",
        "value": 21
      },
      {
        "name": "Phenotype Library",
        "value": 18
      }
    ],
    "tags": null,
    "organisation": null,
    "world_access": 1,
    "updated": "2021-10-06T16:04:48.574603Z",
    "sex": [
      {
        "name": "Both",
        "value": "3"
      }
    ],
    "type": [
      {
        "name": "Disease or syndrome",
        "value": "2"
      }
    ],
    "ontology": null,
    "phenoflowid": "https://kclhi.org/phenoflow/workflows/github.com/phenoflow/Collapsed-vertebra---03840570-2024-11ef-94c0-09c4aef33dd3/blob/read-potential-cases-fhir/Collapsed-vertebra.cwl",
    "data_sources": [
      {
        "name": "CPRD GOLD",
        "value": 5,
        "uid": "a29feafa-7bdd-44e9-b977-c9d26425e67f",
        "url": "https://healthdatagateway.org/en/dataset/694",
        "datasource_id": 694
      },
      {
        "name": "HES Admitted Patient Care data for CPRD GOLD",
        "value": 9,
        "uid": "4bcf64a6-f404-4ef4-ae6e-172512ab5f43",
        "url": "https://healthdatagateway.org/en/dataset/674",
        "datasource_id": 674
      }
    ],
    "coding_system": [
      {
        "name": "ICD10 codes",
        "value": 4
      },
      {
        "name": "Read codes v2",
        "value": 5
      },
      {
        "name": "OPCS4 codes",
        "value": 7
      },
      {
        "name": "Med codes",
        "value": 8
      }
    ],
    "event_date_range": "01/01/1999 - 01/07/2016",
    "concept_information": [
      {
        "concept_id": 1088,
        "concept_version_id": 3315,
        "concept_name": "Collapsed vertebra - Primary care",
        "coding_system": {
          "id": 5,
          "name": "Read codes v2",
          "description": "Read codes v2"
        },
        "phenotype_id": "PH142",
        "phenotype_version_id": 284,
        "phenotype_name": "Collapsed vertebra",
        "code_attribute_header": [
          "Disease",
          "Medcode",
          "Category"
        ],
        "codes": [
          {
            "code": "7J41300",
            "description": "Vertebroplasty of fracture of spine",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "Medcode": "88269.0",
              "Category": "Procedure for Collapsed vertebra"
            }
          },
          {
            "code": "7J41500",
            "description": "Balloon kyphoplasty of fracture of spine",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "Medcode": "90472.0",
              "Category": "Procedure for Collapsed vertebra"
            }
          },
          {
            "code": "7J48M00",
            "description": "Vertebroplasty",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "Medcode": "19376.0",
              "Category": "Procedure for Collapsed vertebra"
            }
          },
          {
            "code": "N331000",
            "description": "Pathological fracture of thoracic vertebra",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "Medcode": "30616.0",
              "Category": "Diagnosis of Collapsed vertebra"
            }
          },
          {
            "code": "N331011",
            "description": "Collapse of thoracic vertebra",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "Medcode": "15837.0",
              "Category": "Diagnosis of Collapsed vertebra"
            }
          },
          {
            "code": "N331100",
            "description": "Pathological fracture of lumbar vertebra",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "Medcode": "30352.0",
              "Category": "Diagnosis of Collapsed vertebra"
            }
          },
          {
            "code": "N331.11",
            "description": "Collapse of spine NOS",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "Medcode": "28575.0",
              "Category": "Diagnosis of Collapsed vertebra"
            }
          },
          {
            "code": "N331111",
            "description": "Collapse of lumbar vertebra",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "Medcode": "23686.0",
              "Category": "Diagnosis of Collapsed vertebra"
            }
          },
          {
            "code": "N331.12",
            "description": "Collapse of vertebra NOS",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "Medcode": "2793.0",
              "Category": "Diagnosis of Collapsed vertebra"
            }
          },
          {
            "code": "N331.14",
            "description": "Osteoporotic vertebral collapse",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "Medcode": "44386.0",
              "Category": "Diagnosis of Collapsed vertebra"
            }
          },
          {
            "code": "N331800",
            "description": "Osteoporosis + pathological fracture lumbar vertebrae",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "Medcode": "17377.0",
              "Category": "Diagnosis of Collapsed vertebra"
            }
          },
          {
            "code": "N331900",
            "description": "Osteoporosis + pathological fracture thoracic vertebrae",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "Medcode": "12673.0",
              "Category": "Diagnosis of Collapsed vertebra"
            }
          },
          {
            "code": "N331A00",
            "description": "Osteoporosis + pathological fracture cervical vertebrae",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "Medcode": "48772.0",
              "Category": "Diagnosis of Collapsed vertebra"
            }
          },
          {
            "code": "N331C00",
            "description": "Pathological fracture of cervical vertebra",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "Medcode": "37945.0",
              "Category": "Diagnosis of Collapsed vertebra"
            }
          },
          {
            "code": "N331D00",
            "description": "Collapsed vertebra NOS",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "Medcode": "38728.0",
              "Category": "Diagnosis of Collapsed vertebra"
            }
          },
          {
            "code": "N331E00",
            "description": "Collapse of cervical vertebra",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "Medcode": "17008.0",
              "Category": "Diagnosis of Collapsed vertebra"
            }
          },
          {
            "code": "N331F00",
            "description": "Collapse of thoracic vertebra",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "Medcode": "9319.0",
              "Category": "Diagnosis of Collapsed vertebra"
            }
          },
          {
            "code": "N331G00",
            "description": "Collapse of lumbar vertebra",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "Medcode": "11543.0",
              "Category": "Diagnosis of Collapsed vertebra"
            }
          },
          {
            "code": "N331H00",
            "description": "Collapse of cervical vertebra due to osteoporosis",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "Medcode": "45736.0",
              "Category": "Diagnosis of Collapsed vertebra"
            }
          },
          {
            "code": "N331J00",
            "description": "Collapse of lumbar vertebra due to osteoporosis",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "Medcode": "5841.0",
              "Category": "Diagnosis of Collapsed vertebra"
            }
          },
          {
            "code": "N331K00",
            "description": "Collapse of thoracic vertebra due to osteoporosis",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "Medcode": "19048.0",
              "Category": "Diagnosis of Collapsed vertebra"
            }
          },
          {
            "code": "N331L00",
            "description": "Collapse of vertebra due to osteoporosis NOS",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "Medcode": "4013.0",
              "Category": "Diagnosis of Collapsed vertebra"
            }
          },
          {
            "code": "Nyu6700",
            "description": "[X]Collapsed vertebra in diseases classified elsewhere",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "Medcode": "73900.0",
              "Category": "Diagnosis of Collapsed vertebra"
            }
          },
          {
            "code": "S100H00",
            "description": "Closed fracture cervical vertebra, wedge",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "Medcode": "53337.0",
              "Category": "Diagnosis of Collapsed vertebra"
            }
          },
          {
            "code": "S102100",
            "description": "Closed fracture thoracic vertebra, wedge",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "Medcode": "28524.0",
              "Category": "Diagnosis of Collapsed vertebra"
            }
          },
          {
            "code": "S104100",
            "description": "Closed fracture lumbar vertebra, wedge",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "Medcode": "8266.0",
              "Category": "Diagnosis of Collapsed vertebra"
            }
          },
          {
            "code": "S106000",
            "description": "Closed compression fracture sacrum",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "Medcode": "72404.0",
              "Category": "Diagnosis of Collapsed vertebra"
            }
          }
        ]
      },
      {
        "concept_id": 1089,
        "concept_version_id": 3317,
        "concept_name": "Collapsed vertebra - Primary care",
        "coding_system": {
          "id": 8,
          "name": "Med codes",
          "description": "Med codes"
        },
        "phenotype_id": "PH142",
        "phenotype_version_id": 284,
        "phenotype_name": "Collapsed vertebra",
        "code_attribute_header": [
          "Disease",
          "ReadcodeDescr",
          "Readcode"
        ],
        "codes": [
          {
            "code": "11543.0",
            "description": "Diagnosis of Collapsed vertebra",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "ReadcodeDescr": "Collapse of lumbar vertebra",
              "Readcode": "N331G00"
            }
          },
          {
            "code": "12673.0",
            "description": "Diagnosis of Collapsed vertebra",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "ReadcodeDescr": "Osteoporosis + pathological fracture thoracic vertebrae",
              "Readcode": "N331900"
            }
          },
          {
            "code": "15837.0",
            "description": "Diagnosis of Collapsed vertebra",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "ReadcodeDescr": "Collapse of thoracic vertebra",
              "Readcode": "N331011"
            }
          },
          {
            "code": "17008.0",
            "description": "Diagnosis of Collapsed vertebra",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "ReadcodeDescr": "Collapse of cervical vertebra",
              "Readcode": "N331E00"
            }
          },
          {
            "code": "17377.0",
            "description": "Diagnosis of Collapsed vertebra",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "ReadcodeDescr": "Osteoporosis + pathological fracture lumbar vertebrae",
              "Readcode": "N331800"
            }
          },
          {
            "code": "19048.0",
            "description": "Diagnosis of Collapsed vertebra",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "ReadcodeDescr": "Collapse of thoracic vertebra due to osteoporosis",
              "Readcode": "N331K00"
            }
          },
          {
            "code": "19376.0",
            "description": "Procedure for Collapsed vertebra",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "ReadcodeDescr": "Vertebroplasty",
              "Readcode": "7J48M00"
            }
          },
          {
            "code": "23686.0",
            "description": "Diagnosis of Collapsed vertebra",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "ReadcodeDescr": "Collapse of lumbar vertebra",
              "Readcode": "N331111"
            }
          },
          {
            "code": "2793.0",
            "description": "Diagnosis of Collapsed vertebra",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "ReadcodeDescr": "Collapse of vertebra NOS",
              "Readcode": "N331.12"
            }
          },
          {
            "code": "28524.0",
            "description": "Diagnosis of Collapsed vertebra",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "ReadcodeDescr": "Closed fracture thoracic vertebra, wedge",
              "Readcode": "S102100"
            }
          },
          {
            "code": "28575.0",
            "description": "Diagnosis of Collapsed vertebra",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "ReadcodeDescr": "Collapse of spine NOS",
              "Readcode": "N331.11"
            }
          },
          {
            "code": "30352.0",
            "description": "Diagnosis of Collapsed vertebra",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "ReadcodeDescr": "Pathological fracture of lumbar vertebra",
              "Readcode": "N331100"
            }
          },
          {
            "code": "30616.0",
            "description": "Diagnosis of Collapsed vertebra",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "ReadcodeDescr": "Pathological fracture of thoracic vertebra",
              "Readcode": "N331000"
            }
          },
          {
            "code": "37945.0",
            "description": "Diagnosis of Collapsed vertebra",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "ReadcodeDescr": "Pathological fracture of cervical vertebra",
              "Readcode": "N331C00"
            }
          },
          {
            "code": "38728.0",
            "description": "Diagnosis of Collapsed vertebra",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "ReadcodeDescr": "Collapsed vertebra NOS",
              "Readcode": "N331D00"
            }
          },
          {
            "code": "4013.0",
            "description": "Diagnosis of Collapsed vertebra",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "ReadcodeDescr": "Collapse of vertebra due to osteoporosis NOS",
              "Readcode": "N331L00"
            }
          },
          {
            "code": "44386.0",
            "description": "Diagnosis of Collapsed vertebra",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "ReadcodeDescr": "Osteoporotic vertebral collapse",
              "Readcode": "N331.14"
            }
          },
          {
            "code": "45736.0",
            "description": "Diagnosis of Collapsed vertebra",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "ReadcodeDescr": "Collapse of cervical vertebra due to osteoporosis",
              "Readcode": "N331H00"
            }
          },
          {
            "code": "48772.0",
            "description": "Diagnosis of Collapsed vertebra",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "ReadcodeDescr": "Osteoporosis + pathological fracture cervical vertebrae",
              "Readcode": "N331A00"
            }
          },
          {
            "code": "53337.0",
            "description": "Diagnosis of Collapsed vertebra",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "ReadcodeDescr": "Closed fracture cervical vertebra, wedge",
              "Readcode": "S100H00"
            }
          },
          {
            "code": "5841.0",
            "description": "Diagnosis of Collapsed vertebra",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "ReadcodeDescr": "Collapse of lumbar vertebra due to osteoporosis",
              "Readcode": "N331J00"
            }
          },
          {
            "code": "72404.0",
            "description": "Diagnosis of Collapsed vertebra",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "ReadcodeDescr": "Closed compression fracture sacrum",
              "Readcode": "S106000"
            }
          },
          {
            "code": "73900.0",
            "description": "Diagnosis of Collapsed vertebra",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "ReadcodeDescr": "[X]Collapsed vertebra in diseases classified elsewhere",
              "Readcode": "Nyu6700"
            }
          },
          {
            "code": "8266.0",
            "description": "Diagnosis of Collapsed vertebra",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "ReadcodeDescr": "Closed fracture lumbar vertebra, wedge",
              "Readcode": "S104100"
            }
          },
          {
            "code": "88269.0",
            "description": "Procedure for Collapsed vertebra",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "ReadcodeDescr": "Vertebroplasty of fracture of spine",
              "Readcode": "7J41300"
            }
          },
          {
            "code": "90472.0",
            "description": "Procedure for Collapsed vertebra",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "ReadcodeDescr": "Balloon kyphoplasty of fracture of spine",
              "Readcode": "7J41500"
            }
          },
          {
            "code": "9319.0",
            "description": "Diagnosis of Collapsed vertebra",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "ReadcodeDescr": "Collapse of thoracic vertebra",
              "Readcode": "N331F00"
            }
          }
        ]
      },
      {
        "concept_id": 1090,
        "concept_version_id": 3319,
        "concept_name": "Collapsed vertebra - Secondary care - Diagnoses",
        "coding_system": {
          "id": 4,
          "name": "ICD10 codes",
          "description": "ICD10 Codes"
        },
        "phenotype_id": "PH142",
        "phenotype_version_id": 284,
        "phenotype_name": "Collapsed vertebra",
        "code_attribute_header": [
          "Disease",
          "Category"
        ],
        "codes": [
          {
            "code": "M48.5",
            "description": "Collapsed vertebra, not elsewhere classified",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "Category": "Diagnosis of Collapsed vertebra"
            }
          },
          {
            "code": "M49.5",
            "description": "Collapsed vertebra in diseases classified elsewhere",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "Category": "Diagnosis of Collapsed vertebra"
            }
          }
        ]
      },
      {
        "concept_id": 1091,
        "concept_version_id": 3321,
        "concept_name": "Collapsed vertebra - Secondary care - Procedures",
        "coding_system": {
          "id": 7,
          "name": "OPCS4 codes",
          "description": "OPCS4 codes"
        },
        "phenotype_id": "PH142",
        "phenotype_version_id": 284,
        "phenotype_name": "Collapsed vertebra",
        "code_attribute_header": [
          "Disease",
          "Category"
        ],
        "codes": [
          {
            "code": "V44",
            "description": "Decompression of fracture of spine",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "Category": "Procedure for Collapsed vertebra"
            }
          },
          {
            "code": "V44.1",
            "description": "Complex decompression of fracture of spine",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "Category": "Procedure for Collapsed vertebra"
            }
          },
          {
            "code": "V44.2",
            "description": "Anterior decompression of fracture of spine",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "Category": "Procedure for Collapsed vertebra"
            }
          },
          {
            "code": "V44.3",
            "description": "Posterior decompression of fracture of spine NEC",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "Category": "Procedure for Collapsed vertebra"
            }
          },
          {
            "code": "V44.4",
            "description": "Vertebroplasty of fracture of spine",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "Category": "Procedure for Collapsed vertebra"
            }
          },
          {
            "code": "V44.5",
            "description": "Balloon kyphoplasty of fracture of spine",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "Category": "Procedure for Collapsed vertebra"
            }
          },
          {
            "code": "V44.8",
            "description": "Other specified decompression of fracture of spine",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "Category": "Procedure for Collapsed vertebra"
            }
          },
          {
            "code": "V44.9",
            "description": "Unspecified decompression of fracture of spine",
            "attributes": {
              "Disease": "Collapsed vertebra",
              "Category": "Procedure for Collapsed vertebra"
            }
          }
        ]
      }
    ],
    "status": 2,
    "doi": "https://doi.org/10.48533/2f28-dd81",
    "is_deleted": null,
    "publish_status": 2,
    "owner": "ieuan.scanlon",
    "template": {
      "id": 1,
      "name": "Clinical-Coded Phenotype",
      "description": "Phenotype definitions that are based on lists of clinical codes, or algorithms using clinical codes.",
      "version_id": 1
    },
    "versions": [
      {
        "version_id": 284,
        "version_name": "Collapsed vertebra",
        "version_date": "2021-10-06T16:04:48.602063Z",
        "is_published": true,
        "is_latest": true
      }
    ]
  }
]