FHIR2Dataset
FHIR2Dataset copied to clipboard
arkhn
Query FHIR apis with SQL, for analytics and ML.
## Description When not git-cloning but installing using pip install (e.g. in requirements.txt: `fhir2dataset @ git+https://github.com/arkhn/FHIR2Dataset`) or using poetry (`poetry add git+https://github.com/arkhn/FHIR2Dataset`), the installation works fine, however, when trying to...
Example ```sql SELECT Patient.identifier.value as identifier, Patient.name.family as last_name, ```
## Description We should support a query to extract: - PATIENT - Identifier - First name - Last name - birthdate - gender - code postal - CONDITION - **where**...
As reported in https://github.com/arkhn/FHIR2Dataset/issues/65, and solved in corresponding features, we wanted to keep link between 2 fhirpaths with a common root. The solution we came up with heavily depends on...
## Description When I run in G colab ```python import fhir2dataset as query sql_query = "SELECT p.name.family, p.address.city FROM Patient AS p WHERE p.birthdate=1944 AND p.gender = 'female'" query.sql(sql_query) ```...
default view : lists but user can choose view for every item (column, list, first...) --------- ``` SELECT patient.id, UNNEST_COLUMN(patient.address, 3) from patient; ``` ``` id | address_0 | address_1...
default view : lists but user can choose view for every item (column, list, first...) --------- ``` SELECT patient.id, UNNEST_ROW(patient.address) from patient; ``` ``` id | address robert | 2...
We could, for example, parallelise what can be parallelised
