Demographic distribution queries

[AndyRae]

Is this the right issue type?

• Yes, I'm planning work for this project team.

Summary

#31

It would also be good to the get the demographic distro returned:

{
                "file_name": "demographics.distribution",
                "file_data": "QklPQkFOSwlDT0RFCURFU0NSSVBUSU9OCUNPVU5UCU1JTglRMQlNRURJQU4JTUVBTglRMwlNQVgJQUxURVJOQVRJVkVTCURBVEFTRVQJT01PUAlPTU9QX0RFU0NSCUNBVEVHT1JZClJRLUNDLWU4Njc5Y2IzLTMzNGItNGZhZC04YTI3LTU1Y2Y1NzVlZjg3NwlTRVgJU2V4CTEyMzcwCQkJCQkJCV5NYWxlfDYyODBeRmVtYWxlfDYwOTBeCXBlcnNvbl90NAlOQQlOQQlEZW1vZ3JhcGhpYwpSUS1DQy1lODY3OWNiMy0zMzRiLTRmYWQtOGEyNy01NWNmNTc1ZWY4NzcJR0VOT01JQ1MJR2Vub21pY3MgZGF0YQkxMjM2MAkJCQkJCQleTm98MTIzNTleCXBlcnNvbl90NAlOQQlOQQlEZW1vZ3JhcGhpYwpSUS1DQy1lODY3OWNiMy0zMzRiLTRmYWQtOGEyNy01NWNmNTc1ZWY4NzcJQUdFCUFnZSBpbiB5ZWFycwkxMjM2MAkJCQkwCQkJCXBlcnNvbl90NAlOQQlOQQlEZW1vZ3JhcGhpYwo\u003d",
                "file_size": 0.0,
                "file_type": "BCOS",
                "file_sensitive": false,
                "file_reference": ""
}

This unwraps to:

BIOBANK CODE DESCRIPTION COUNT MIN Q1 MEDIAN MEAN Q3 MAX ALTERNATIVES DATASET OMOP OMOP_DESCR CATEGORY
RQ-CC-e8679cb3-334b-4fad-8a27-55cf575ef877 SEX Sex 12370 ^Male|6280^Female|6090^ person_t4 NA NA Demographic
RQ-CC-e8679cb3-334b-4fad-8a27-55cf575ef877 GENOMICS Genomics data 12360 ^No|12359^ person_t4 NA NA Demographic
RQ-CC-e8679cb3-334b-4fad-8a27-55cf575ef877 AGE Age in years 12360 0person_t4 NA NA Demographic

Originally posted by @thomgiles in #31

Acceptance Criteria

• Demographic distribution responses are returned

Tasks

• Understand how this works
• Be able to run these queries on demand
  • Access
  • Documented approach
• Refactor Distribution query solving so that Demographics and other distribution query handling shares code where possible
• Fix Demographics Distribution Query response content
• Add Demographics response file to Generic Distribution queries per Disto Query payload not correct: #31 ??

Confirm creation

• This issue is ready