[
  {
    "phenotype_id": "PH478",
    "phenotype_version_id": 1519,
    "name": "Upper Respiratory Tract Infection",
    "definition": "This was an indication–prescription descriptive cross-sectional study using data from The Health Improvement Network (THIN), a computerized database of consultation data from 570 general practices that use the Vision practice software system, covering 3.8 million active patients (resulting in 68 million patient–years of data). The population covered has similar demographic characteristics to the national UK population,and the recording of consultations and prescriptions is comparable to national levels. Data are validated to ensure that they meet quality standards12 and data quality compliance dates are included to show when practices meet recording standards: practice data were only included in our analyses after the later of the acceptable mortality reporting date or the acceptable computer usage date, resulting in 537 practices being included in our study.\n\n\nDiagnosis and prescribing data at the individual (anonymized) patient level were linked to determine the condition for which the antimicrobial was prescribed. For each clinical syndrome a list of search terms (keywords and synonyms) was produced and used to search the descriptions in the Read code dictionary. In the resulting Read code list, code stems were searched to include all codes containing the specified sequence of characters. This list was then pruned by two medical epidemiologists (J. I. H. and G. E. S.) to decide on the codes to be included for each condition and were checked by A. C. H., A. P. J. and D. M. F. Code lists were constructed for specificity rather than sensitivity (e.g. tonsillitis, but not influenza, was included in the sore throat list) and codes were excluded if they were likely to contain a significant number of consultations for which the relevant SMAC/PHLS recommendation was likely to be inappropriate: for example, those sore throats that were recorded as ‘bacterial’ or ‘streptococcal’ were excluded fromthe sore throat code list, and the UTI code list did not include chronic or recurring infections, kidney infections or conditions related to pregnancy (the code lists are available in Table S1, available as Supplementary data at JACOnline). The drug code list included all antibiotics in Chapter 5.1 of the British National Formulary, excluding antituberculosis drugs and antileprotic drugs. A prescription was linked to a consultation if both occurred on the same date. An episode of acute infection was defined as a newly recorded diagnosis that was not preceded by a consultation for the same diagnosis reported in the previous 14 days.\n\n\nStata v12 survival analysis commands were used to obtain overall incidence rates for each clinical condition in total and those cases prescribed an antibiotic. Yearly changes were assessed by calculating CIs reflecting the average change in percentiles year on year within practices, thereby removing the effect of between-practice variation. Variation by practice was illustrated by a funnel plot, which allowed an inspection of random variation according to practice size and was presented as a range from the 10th percentile to the 90th percentile (TNPR) or IQR to exclude outlying practices that might be atypical. The variation in the proportion of patients prescribed antibiotics was analysed by age group (0–4, 5–14, 15–24, 25–54, 55–64, 65–74, 75–84 and 85–94 years) and, for the cough/cold indicator, by socioeconomic status, using quintiles of increasing deprivation provided in the THIN database (derived from Townsend scores based on patients’ postcodes). For UTI, only women aged 16–74 years were included, and for trimethoprim and nitrofurantoin prescriptions the course length was calculated by dividing the ‘quantity prescribed’ field by the ‘calculated daily dosage’ field. The protocol for this work was approved by the THIN Scientific Review Committee (SRC ref 12-002). No patient-identifiable data were used and no new information was collected for this project.\n\n\n\n\n\n\n\n\n",
    "implementation": "",
    "publications": [
      {
        "doi": null,
        "details": "Jeremy I Hawker, Sue Smith, Gillian E Smith, Roger Morbey, Alan P Johnson, Douglas M Fleming, Laura Shallcross, Andrew C Hayward, Trends in antibiotic prescribing in primary care for clinical syndromes subject to national recommendations to reduce antibiotic resistance, UK 1995–2011: analysis of a large database of primary care consultations. J Antimicrob Chemother, 69(3423-3430), 2014."
      }
    ],
    "validation": "",
    "citation_requirements": "",
    "created": "2021-10-06T16:21:13.947964Z",
    "author": "Jeremy I Hawker, Sue Smith, Gillian E Smith, Roger Morbey, Alan P Johnson, Douglas M Fleming, Laura Shallcross, Andrew C Hayward",
    "collections": [
      {
        "name": "ClinicalCodes Repository",
        "value": 25
      },
      {
        "name": "Phenotype Library",
        "value": 18
      }
    ],
    "tags": null,
    "organisation": null,
    "world_access": 1,
    "updated": "2021-10-26T20:19:01.466374Z",
    "sex": [
      {
        "name": "Female",
        "value": "2"
      }
    ],
    "type": [
      {
        "name": "Disease or syndrome",
        "value": "2"
      }
    ],
    "ontology": null,
    "phenoflowid": "",
    "data_sources": [
      {
        "name": "The Health Improvement Network (THIN)",
        "value": 14,
        "uid": "",
        "url": "",
        "datasource_id": 14
      }
    ],
    "coding_system": [
      {
        "name": "Read codes v2",
        "value": 5
      }
    ],
    "event_date_range": "1995 - 2011",
    "concept_information": [
      {
        "concept_id": 1837,
        "concept_version_id": 5516,
        "concept_name": "Upper Respiratory Tract Infection - Primary Care",
        "coding_system": {
          "id": 5,
          "name": "Read codes v2",
          "description": "Read codes v2"
        },
        "phenotype_id": "PH478",
        "phenotype_version_id": 1519,
        "phenotype_name": "Upper Respiratory Tract Infection",
        "code_attribute_header": [
          "Category",
          "Coding System (Read)",
          "Entity type"
        ],
        "codes": [
          {
            "code": "16L..00",
            "description": "Influenza-like symptoms",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "1J72.00",
            "description": "Suspected swine influenza",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H0...00",
            "description": "Acute respiratory infections",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H00..00",
            "description": "Acute nasopharyngitis",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H00..11",
            "description": "Common cold",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H00..12",
            "description": "Coryza - acute",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H00..13",
            "description": "Febrile cold",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H00..14",
            "description": "Nasal catarrh - acute",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H00..15",
            "description": "Pyrexial cold",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H00..16",
            "description": "Rhinitis - acute",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H023z00",
            "description": "Acute bacterial pharyngitis NOS",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H024.00",
            "description": "Acute viral pharyngitis",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H02z.00",
            "description": "Acute pharyngitis NOS",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H03..00",
            "description": "Acute tonsillitis",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H03..11",
            "description": "Throat infection - tonsillitis",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H036.00",
            "description": "Acute viral tonsillitis",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H03z.00",
            "description": "Acute tonsillitis NOS",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H04..00",
            "description": "Acute laryngitis and tracheitis",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H040.00",
            "description": "Acute laryngitis",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H040w00",
            "description": "Acute viral laryngitis unspecified",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H040z00",
            "description": "Acute laryngitis NOS",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H041.00",
            "description": "Acute tracheitis",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H041000",
            "description": "Acute tracheitis without obstruction",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H041100",
            "description": "Acute tracheitis with obstruction",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H041z00",
            "description": "Acute tracheitis NOS",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H042.00",
            "description": "Acute laryngotracheitis",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H042000",
            "description": "Acute laryngotracheitis without obstruction",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H042100",
            "description": "Acute laryngotracheitis with obstruction",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H042.11",
            "description": "Laryngotracheitis",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H042z00",
            "description": "Acute laryngotracheitis NOS",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H04z.00",
            "description": "Acute laryngitis and tracheitis NOS",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H05..00",
            "description": "Other acute upper respiratory infections",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H050.00",
            "description": "Acute laryngopharyngitis",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H051.00",
            "description": "Acute upper respiratory tract infection",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H052.00",
            "description": "Pharyngotracheitis",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H054.00",
            "description": "Recurrent upper respiratory tract infection",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H055.00",
            "description": "Pharyngolaryngitis",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H05y.00",
            "description": "Other upper respiratory infections of multiple sites",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H05z.00",
            "description": "Upper respiratory infection NOS",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H05z.11",
            "description": "Upper respiratory tract infection NOS",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H05z.12",
            "description": "Viral upper respiratory tract infection NOS",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H06z111",
            "description": "Respiratory tract infection",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H0z..00",
            "description": "Acute respiratory infection NOS",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H27..00",
            "description": "Influenza",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H271.00",
            "description": "Influenza with other respiratory manifestation",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H271000",
            "description": "Influenza with laryngitis",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H271100",
            "description": "Influenza with pharyngitis",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H271z00",
            "description": "Influenza with respiratory manifestations NOS",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H27yz00",
            "description": "Influenza with other manifestations NOS",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H27z.00",
            "description": "Influenza NOS",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H27z.11",
            "description": "Flu like illness",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H27z.12",
            "description": "Influenza like illness",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H29..00",
            "description": "Avian influenza",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H2A..",
            "description": "Influenza A (H1N1) swine flu",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "H5yy.11",
            "description": "Respiratory infection NOS",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "Hyu0.00",
            "description": "[X]Acute upper respiratory infections",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          },
          {
            "code": "Hyu0300",
            "description": "[X]Other acute upper respiratory infections/multiple sites",
            "attributes": {
              "Category": "diagnostic",
              "Coding System (Read)": "Read",
              "Entity type": "res20: URTI"
            }
          }
        ]
      }
    ],
    "status": 2,
    "doi": "https://doi.org/10.48533/cj6q-ah89",
    "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": 1519,
        "version_name": "Upper Respiratory Tract Infection",
        "version_date": "2021-10-26T20:19:01.700870Z",
        "is_published": true,
        "is_latest": true
      }
    ]
  }
]