logo
OpenSAFELY documentation
How-to guides
Initializing search
    GitHub
    GitHub
    • Introduction
      • Our philosophy
      • Security
      • Access policies
      • Technical architecture
      • Contributing
    • Getting Started guide
      • Analysis workflow
      • Federated analytics
      • GitHub repositories
        • Overview
        • GitHub and Git
        • Running OpenSAFELY in GitHub Codespaces
        • Python
        • Docker
        • OpenSAFELY CLI
        • macOS
        • Linux
        • Introduction to codelists
        • Building a codelist
        • Adding codelists to a project
        • Keeping codelists up to date
        • Overview
        • The project pipeline
        • 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
          • Overview
          • Working with dates
          • Working with codelists
          • Dummy data and expectations
          • Variable reference
          • Measures
          • Create inclusion/exclusion flowcharts
          • Programming tricks
      • 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
        • How to use dummy data in an ehrQL dataset definition
        • How to use dummy data in an ehrQL measures definition
      • 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
        • Using the measures framework
    • 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
      • Plan S and OpenSAFELY
      • Updating the documentation
    • Bennett Institute Open Manifesto
    • Platform News

    How-to guides

    The how-to guides provide practical steps for working with ehrQL in your project.

    • Using ehrQL to answer specific questions
    • Resolving ehrQL errors
    • How to use dummy data in an ehrQL dataset definition
    • How to use dummy data in an ehrQL measures definition
    Previous
    Tidying up
    Next
    Using ehrQL to answer specific questions
    © 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