logo
OpenSAFELY documentation
Reference
Initializing search
    GitHub
    GitHub
    • Introduction
      • Our philosophy
      • Security
      • Access policies
      • Technical architecture
      • Contributing
    • Getting Started guide
      • Analysis workflow
      • Federated analytics
      • GitHub repositories
        • Overview
        • Managing Gitpod workspaces
        • GitHub and Git
        • Running OpenSAFELY in GitHub Codespaces
        • Python
        • Docker
        • OpenSAFELY CLI
        • macOS
        • Linux
        • Overview
        • Working with dates
        • Working with codelists
        • Dummy data and expectations
        • Variable reference
        • Measures
        • Create inclusion/exclusion flowcharts
        • Programming tricks
        • Introduction to codelists
        • Building a codelist
        • Adding codelists to a project
        • SNOMED CT codelists
        • Overview
        • The project pipeline
        • The cohortextractor action
        • Scripted actions
        • Reusable actions
      • Jobs site
      • Level 4 server
      • Safe Outputs and requesting release of files from the Level 4 server
        • Overview
        • Create a draft
        • Review process
        • Publishing a report
      • Project completion
      • Adding your pre-print/paper to OpenSAFELY.org
      • Information for system integrators
      • Developing a protocol
      • Using Git effectively
      • Code reviews
      • Case-control studies
      • Writing performant code
    • ehrQL
      • Tutorial
        • Setting up
        • Working with tables
        • Writing a dataset definition
        • Generating a dummy dataset
        • Committing the dataset definition
        • Writing a more complex dataset definition
        • Pushing the commits to GitHub
        • Tidying up
      • How-to guides
        • Using ehrQL to answer specific questions
        • Resolving ehrQL errors
      • Reference
        • Language reference
        • Language features
        • Backends
        • Table schemas
        • Command line interface
      • Explanation
        • ehrQL backend tables
        • ehrQL output formats
        • Using ehrQL in OpenSAFELY projects
        • Running ehrQL
    • Data sources
      • Overview
      • SystmOne primary care
      • EMIS primary care
      • Covid-19 test results
      • Covid-19 therapeutics
      • Emergency attendances
      • High Cost Drugs
      • Hospital admissions
      • In-hospital deaths (covid-19 only)
      • Intensive care admissions (covid-19 only)
      • International Severe Acute Respiratory and emerging Infection Consortium
      • Registered deaths
      • UK Renal Registry
      • How to get help
      • OpenSAFELY co-piloting service
      • Requesting new libraries
      • Requesting study definition variables
      • Plan S and OpenSAFELY
      • Updating the documentation
    • Bennett Institute Open Manifesto
    • Platform News

    Reference

    The reference provides background knowledge for working with ehrQL in your project.

    • Language reference
    • Language features
    • Backends
    • Table schemas
    • Command line interface
    Previous
    Resolving ehrQL errors
    Next
    Language reference
    © University of Oxford for the Bennett Institute for Applied Data Science. This work may be copied freely for non-commercial research and study. If you wish to do any of the other acts restricted by the copyright you should apply in writing to bennett@phc.ox.ac.uk.
    Made with Material for MkDocs