AQL Result Set work area
- Thomas Beale
- Pieter Bos
- Pablo Pazos
Owned by Thomas Beale
Existing Result sets (and openEHR RM JSON serializations)
- Ocean (XML, see Ocean Informatics EHR Service Interface#DataStructures)
- Marand (JSON, see below)
- DIPS (JSON, see below)
- All the LiU-EEE-specific schemas are at https://github.com/LiU-IMT/EEE/tree/master/src/main/xsd
- Our experimental result format for queries of XML data (originally intended for openEHR AQL queries) in that directory is at https://github.com/LiU-IMT/EEE/blob/master/src/main/xsd/xml-result-v1.xsd It was inspired by SPARQL's result set at http://www.w3.org/TR/rdf-sparql-XMLres/
- ...but agreeing on a JSON-format is probably more urgent than for XML.
- The JSON format for SPARQL might be a useful input for thought though, see http://www.w3.org/TR/2013/REC-sparql11-results-json-20130321/ The "head" and "bindings" stuff using vairables from the query might be interesting. The SPARQL response looks a bit more like the Marand than the DIPS version. I am not sure that using terms like "rows" and "columns" (like in the DIPS-version) is the best for tree-shaped NoSQL data (even though they are logically some kind of rows).
- Archie (has RM serialization in JSON & XML)
- Code24 (see below)
- CaboLabs (see below)
Marand Ehrscape result set
{
"meta": {
"href": "http://thinkehr2:8082/rest/v1/query/?aql=select%20%20%20%20%20a_a/data%5Bat0002%5D/events%5Bat0003%5D/data%5Bat0001%5D/items%5Bat0004%5D/value%20as%20Temperature,%20%20%20%20%20a_b/data%5Bat0001%5D/events%5Bat0006%5D/data%5Bat0003%5D/items%5Bat0004%5D/value%20as%20Blood_Pressure_Systolic,%20%20%20%20%20a_b/data%5Bat0001%5D/events%5Bat0006%5D/data%5Bat0003%5D/items%5Bat0005%5D/value%20as%20Diastolic%20from%20EHR%20e%20contains%20COMPOSITION%20a%20contains%20(%20%20%20%20%20OBSERVATION%20a_a%5BopenEHR-EHR-OBSERVATION.body_temperature.v1%5D%20and%20%20%20%20%20OBSERVATION%20a_b%5BopenEHR-EHR-OBSERVATION.blood_pressure.v1%5D)%20offset%200%20limit%20100"
},
"aql": "select a_a/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value as Temperature, a_b/data[at0001]/events[at0006]/data[at0003]/items[at0004]/value as Blood_Pressure_Systolic, a_b/data[at0001]/events[at0006]/data[at0003]/items[at0005]/value as Diastolic from EHR e contains COMPOSITION a contains ( OBSERVATION a_a[openEHR-EHR-OBSERVATION.body_temperature.v1] and OBSERVATION a_b[openEHR-EHR-OBSERVATION.blood_pressure.v1]) offset 0 limit 100",
"executedAql": "select a_a/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value as Temperature, a_b/data[at0001]/events[at0006]/data[at0003]/items[at0004]/value as Blood_Pressure_Systolic, a_b/data[at0001]/events[at0006]/data[at0003]/items[at0005]/value as Diastolic from EHR e contains COMPOSITION a contains ( OBSERVATION a_a[openEHR-EHR-OBSERVATION.body_temperature.v1] and OBSERVATION a_b[openEHR-EHR-OBSERVATION.blood_pressure.v1]) offset 0 limit 100",
"resultSet": [
{
"Temperature": {
"@class": "DV_QUANTITY",
"magnitude": 37.1,
"units": "°C",
"precision": 1
},
"Blood_Pressure_Systolic": {
"@class": "DV_QUANTITY",
"magnitude": 120,
"units": "mm[Hg]"
},
"Diastolic": {
"@class": "DV_QUANTITY",
"magnitude": 90,
"units": "mm[Hg]"
}
},
{
...
There is some meta-data at the beginning:
- href: href of the call
- aql: the AQL client sent
- executedAql: AQL the server executed - this will have potential parameters replaced
Resultset is a simple array of rows with one object per column. Columns names are taken from AQL select aliases, if none is present then just 0-based column index prefixed by a hash-sign (#) is used instead, i.e.: #0 for first column, etc.
JSON format used here for the RM is also used for other operations. Here is an example where we select an Observation rather than simple DATA_VALUEs:
"Measurement": {
"@class": "OBSERVATION",
"name": {
"@class": "DV_TEXT",
"value": "Body temperature"
},
"archetype_details": {
"@class": "ARCHETYPED",
"archetype_id": {
"@class": "ARCHETYPE_ID",
"value": "openEHR-EHR-OBSERVATION.body_temperature.v1"
...
Attribute names are snake-case (like defined in MagicDraw). We also add attribute @class to every object to define the exact class used for the object. Class names are all upper case and also snake-case.
DIPS Arena EHR ResultSet
Below it the resultset from DIPS Arena EHR Server. The query used is the same as in the Marand example above.
Arena EHR Server supports both JSON and XML on the query resource. The JSON is shown below and a XML examples is here: Arena EHR Server API
ResultSet as JSON
{
"@class": "RESULTSET",
"@schemaversion": "0.1.0",
"@type": "raw",
"@created": "2016-06-17T14:18:00.422+02:00",
"@generator": "DIPS.OpenEhr.ResultSets.Serialization.Json.ResultSetJsonWriter (5.0.0.0)",
"name": null,
"correlationid": "00000000-0000-0000-0000-000000000000",
"totalResults": 31,
"columns": [
{
"name": "Temperature",
"path": "/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value"
},
{
"name": "Blood_Pressure_Systolic",
"path": "/data[at0001]/events[at0006]/data[at0003]/items[at0004]/value"
},
{
"name": "Diastolic",
"path": "/data[at0001]/events[at0006]/data[at0003]/items[at0005]/value"
}
],
"rows": [
[
{
"@class": "DV_QUANTITY",
"magnitude": 37.0,
"units": "Cel"
},
{
"@class": "DV_QUANTITY",
"magnitude": 120.0,
"units": "mm[Hg]"
},
{
"@class": "DV_QUANTITY",
"magnitude": 80.0,
"units": "mm[Hg]"
}
],
Archie
Archie can serialize RM Objects to XML using the standard openEHR RM XSD, or it can be used to serialize to JSON. The format we have now is very similar that the one Marand uses: snake_cased attribute names, type names as the same notation as the RM specs.
The code to serialize to this format or parse it to RM Objects is present in Archie starting from version 0.2.1
"data" : {
"@type" : "HISTORY",
"name" : {
"@type" : "DV_TEXT",
"value" : "history"
},
"archetype_node_id" : "id2",
"events" : [ {
"@type" : "POINT_EVENT",
"name" : {
"@type" : "DV_TEXT",
"value" : "any event"
},
"archetype_node_id" : "id7",
"time" : {
"@type" : "DV_DATE_TIME",
"magnitude" : 1466427403,
"value" : "2016-06-20T14:56:43.702+02:00"
},
"data" : {
"@type" : "ITEM_TREE",
"name" : {
"type" : "DV_TEXT"
},
"archetype_node_id" : "id4",
"items" : [ {
"@type" : "ELEMENT",
"name" : {
"@type" : "DV_TEXT",
"value" : "Systolic"
},
"archetype_node_id" : "id5",
"value" : {
"@type" : "DV_QUANTITY",
"magnitude" : 120.0,
"precision" : 0,
"units" : "mm[Hg]"
},
"path" : "/data[id2]/event[id7]/data[id4]/item[id5]"
}, {
"@type" : "ELEMENT",
"name" : {
"@type" : "DV_TEXT",
"value" : "Diastolic"
},
"archetype_node_id" : "id6",
"value" : {
"@type" : "DV_QUANTITY",
"magnitude" : 80.0,
"precision" : 0,
"units" : "mm[Hg]"
},
"path" : "/data[id2]/event[id7]/data[id4]/item[id6]"
},
Code24
Code24 does not have yet implemented AQL, but most probably it will be ready in Q3/Q4 2016. Intention is to follow the same JSON as Marand's example above. The current RESTApi that we have at this time is published at http://rest.base24.nl/docs
CaboLabs
We do XML to JSON automatically. Our result sets have different forms, one oriented to COMPOSITIONS one oriented to DATATYPES.
COMPOSITIONS
composition output
{
"list": {
"@xmlns:xsi": "http://www.w3.org/2001/XMLSchema-instance",
"@xmlns": "http://schemas.openehr.org/v1",
"version": {
"@xsi:type": "ORIGINAL_VERSION",
"contribution": {
"id": {
"@xsi:type": "HIER_OBJECT_ID",
"value": "71da6483-9e69-43dc-82a9-dc5926a41c7d"
},
"namespace": "EHR::COMMON",
"type": "CONTRIBUTION"
},
"commit_audit": {
"system_id": "CABOLABS_EHR",
"committer": {
"@xsi:type": "PARTY_IDENTIFIED",
"external_ref": {
"id": {
"@xsi:type": "HIER_OBJECT_ID",
"value": "cc193f71-f5fe-438a-87f9-81ecb302eede"
},
"namespace": "DEMOGRAPHIC",
"type": "PERSON"
},
"name": "Dr. House"
},
"time_committed": {
"value": "20160502T174526,000-0400"
},
"change_type": {
"value": "creation",
"defining_code": {
"terminology_id": {
"value": "openehr"
},
"code_string": 249
}
}
},
"uid": {
"value": "e02b938e-ffca-446e-9562-ed609b0a67ad::EMR::1"
},
"data": {
"@xmlns:xsi": "http://www.w3.org/2001/XMLSchema-instance",
"@archetype_node_id": "openEHR-EHR-COMPOSITION.signos.v1",
"@xsi:type": "COMPOSITION",
"name": {
"value": "Signos vitales"
},
"uid": {
"@xsi:type": "HIER_OBJECT_ID",
"value": "6ee98578-06e7-486b-a903-2a2fea21b1e9"
},
"archetype_details": {
"archetype_id": {
"value": "openEHR-EHR-COMPOSITION.signos.v1"
},
"template_id": {
"value": "Signos"
},
"rm_version": "1.0.2"
},
"language": {
"terminology_id": {
"value": "ISO_639-1"
},
"code_string": "es"
},
"territory": {
"terminology_id": {
"value": "ISO_3166-1"
},
"code_string": "UY"
},
"category": {
"value": "event",
"defining_code": {
"terminology_id": {
"value": "openehr"
},
"code_string": 443
}
},
"composer": {
"@xsi:type": "PARTY_IDENTIFIED",
"external_ref": {
"id": {
"@xsi:type": "HIER_OBJECT_ID",
"value": "cc193f71-f5fe-438a-87f9-81ecb302eede"
},
"namespace": "DEMOGRAPHIC",
"type": "PERSON"
},
"name": "Dr. House"
},
"context": {
"start_time": {
"value": "20160502T174526,000-0400"
},
"setting": {
"value": "Hospital Montevideo",
"defining_code": {
"terminology_id": {
"value": "openehr"
},
"code_string": 229
}
}
},
"content": [
{
"@archetype_node_id": "openEHR-EHR-OBSERVATION.blood_pressure.v1",
"@xsi:type": "OBSERVATION",
"name": {
"value": "Blood Pressure"
},
"language": {
"terminology_id": {
"value": "ISO_639-1"
},
"code_string": "es"
},
"encoding": {
"terminology_id": {
"value": "Unicode"
},
"code_string": "UTF-8"
},
"subject": {
"@xsi:type": "PARTY_SELF"
},
"protocol": {
"@archetype_node_id": "at0011",
"@xsi:type": "ITEM_TREE",
"name": {
"value": "Tree"
}
},
"data": {
"@archetype_node_id": "at0001",
"@xsi:type": "HISTORY",
"name": {
"value": "history"
},
"origin": {
"@xsi:type": "DV_DATE_TIME",
"value": "20160502T174526,000-0400"
},
"events": {
"@archetype_node_id": "at0006",
"@xsi:type": "POINT_EVENT",
"name": {
"value": "any event"
},
"time": {
"@xsi:type": "DV_DATE_TIME",
"value": "20160502T174526,000-0400"
},
"data": {
"@archetype_node_id": "at0003",
"@xsi:type": "ITEM_TREE",
"name": {
"value": "blood pressure"
},
"items": [
{
"@archetype_node_id": "at0005",
"@xsi:type": "ELEMENT",
"name": {
"value": "Diastolic"
},
"value": {
"@xsi:type": "DV_QUANTITY",
"magnitude": 92,
"units": "mm[Hg]"
}
},
{
"@archetype_node_id": "at0004",
"@xsi:type": "ELEMENT",
"name": {
"value": "Systolic"
},
"value": {
"@xsi:type": "DV_QUANTITY",
"magnitude": 180,
"units": "mm[Hg]"
}
}
]
},
"state": {
"@archetype_node_id": "at0007",
"@xsi:type": "ITEM_TREE",
"name": {
"value": "state structure"
}
}
}
}
},
{
"@archetype_node_id": "openEHR-EHR-OBSERVATION.body_temperature.v1",
"@xsi:type": "OBSERVATION",
"name": {
"value": "Body temperature"
},
"language": {
"terminology_id": {
"value": "ISO_639-1"
},
"code_string": "es"
},
"encoding": {
"terminology_id": {
"value": "Unicode"
},
"code_string": "UTF-8"
},
"subject": {
"@xsi:type": "PARTY_SELF"
},
"protocol": {
"@archetype_node_id": "at0020",
"@xsi:type": "ITEM_TREE",
"name": {
"value": "Protocol"
}
},
"data": {
"@archetype_node_id": "at0002",
"@xsi:type": "HISTORY",
"name": {
"value": "History"
},
"origin": {
"@xsi:type": "DV_DATE_TIME",
"value": "20160502T174526,000-0400"
},
"events": {
"@archetype_node_id": "at0003",
"@xsi:type": "POINT_EVENT",
"name": {
"value": "Any event"
},
"time": {
"@xsi:type": "DV_DATE_TIME",
"value": "20160502T174526,000-0400"
},
"data": {
"@archetype_node_id": "at0001",
"@xsi:type": "ITEM_TREE",
"name": {
"value": "Tree"
},
"items": {
"@archetype_node_id": "at0004",
"@xsi:type": "ELEMENT",
"name": {
"value": "Temperature"
},
"value": {
"@xsi:type": "DV_QUANTITY",
"magnitude": 39,
"units": "°C"
}
}
},
"state": {
"@archetype_node_id": "at0029",
"@xsi:type": "ITEM_TREE",
"name": {
"value": "State"
}
}
}
}
},
{
"@archetype_node_id": "openEHR-EHR-OBSERVATION.pulse.v1",
"@xsi:type": "OBSERVATION",
"name": {
"value": "Pulso"
},
"language": {
"terminology_id": {
"value": "ISO_639-1"
},
"code_string": "es"
},
"encoding": {
"terminology_id": {
"value": "Unicode"
},
"code_string": "UTF-8"
},
"subject": {
"@xsi:type": "PARTY_SELF"
},
"protocol": {
"@archetype_node_id": "at0010",
"@xsi:type": "ITEM_TREE",
"name": {
"value": "*List(en)"
}
},
"data": {
"@archetype_node_id": "at0002",
"@xsi:type": "HISTORY",
"name": {
"value": "*history(en)"
},
"origin": {
"@xsi:type": "DV_DATE_TIME",
"value": "20160502T174526,000-0400"
},
"events": {
"@archetype_node_id": "at0003",
"@xsi:type": "POINT_EVENT",
"name": {
"value": "*Any event(en)"
},
"time": {
"@xsi:type": "DV_DATE_TIME",
"value": "20160502T174526,000-0400"
},
"data": {
"@archetype_node_id": "at0001",
"@xsi:type": "ITEM_TREE",
"name": {
"value": "*structure(en)"
},
"items": {
"@archetype_node_id": "at0004",
"@xsi:type": "ELEMENT",
"name": {
"@xsi:type": "DV_CODED_TEXT",
"value": "Frecuencia cardiaca",
"defining_code": {
"terminology_id": {
"value": "local"
},
"code_string": "at1027"
}
},
"value": {
"@xsi:type": "DV_QUANTITY",
"magnitude": 65,
"units": "/min"
}
}
},
"state": {
"@archetype_node_id": "at0012",
"@xsi:type": "ITEM_TREE",
"name": {
"value": "*List(en)"
}
}
}
}
},
{
"@archetype_node_id": "openEHR-EHR-OBSERVATION.respiration.v1",
"@xsi:type": "OBSERVATION",
"name": {
"value": "Respirations"
},
"language": {
"terminology_id": {
"value": "ISO_639-1"
},
"code_string": "es"
},
"encoding": {
"terminology_id": {
"value": "Unicode"
},
"code_string": "UTF-8"
},
"subject": {
"@xsi:type": "PARTY_SELF"
},
"data": {
"@archetype_node_id": "at0001",
"@xsi:type": "HISTORY",
"name": {
"value": "history"
},
"origin": {
"@xsi:type": "DV_DATE_TIME",
"value": "20160502T174526,000-0400"
},
"events": {
"@archetype_node_id": "at0002",
"@xsi:type": "POINT_EVENT",
"name": {
"value": "Any event"
},
"time": {
"@xsi:type": "DV_DATE_TIME",
"value": "20160502T174526,000-0400"
},
"data": {
"@archetype_node_id": "at0003",
"@xsi:type": "ITEM_TREE",
"name": {
"value": "List"
},
"items": {
"@archetype_node_id": "at0004",
"@xsi:type": "ELEMENT",
"name": {
"value": "Rate"
},
"value": {
"@xsi:type": "DV_QUANTITY",
"magnitude": 66,
"units": "/min"
}
}
},
"state": {
"@archetype_node_id": "at0022",
"@xsi:type": "ITEM_TREE",
"name": {
"value": "List"
}
}
}
}
},
{
"@archetype_node_id": "openEHR-EHR-OBSERVATION.body_weight.v1",
"@xsi:type": "OBSERVATION",
"name": {
"value": "Peso corporal"
},
"language": {
"terminology_id": {
"value": "ISO_639-1"
},
"code_string": "es"
},
"encoding": {
"terminology_id": {
"value": "Unicode"
},
"code_string": "UTF-8"
},
"subject": {
"@xsi:type": "PARTY_SELF"
},
"protocol": {
"@archetype_node_id": "at0015",
"@xsi:type": "ITEM_TREE",
"name": {
"value": "*protocol structure(en)"
}
},
"data": {
"@archetype_node_id": "at0002",
"@xsi:type": "HISTORY",
"name": {
"value": "*history(en)"
},
"origin": {
"@xsi:type": "DV_DATE_TIME",
"value": "20160502T174526,000-0400"
},
"events": {
"@archetype_node_id": "at0003",
"@xsi:type": "POINT_EVENT",
"name": {
"value": "Cualquier evento."
},
"time": {
"@xsi:type": "DV_DATE_TIME",
"value": "20160502T174526,000-0400"
},
"data": {
"@archetype_node_id": "at0001",
"@xsi:type": "ITEM_TREE",
"name": {
"value": "*Simple(en)"
},
"items": {
"@archetype_node_id": "at0004",
"@xsi:type": "ELEMENT",
"name": {
"value": "Peso"
},
"value": {
"@xsi:type": "DV_QUANTITY",
"magnitude": 48,
"units": "kg"
}
}
},
"state": {
"@archetype_node_id": "at0008",
"@xsi:type": "ITEM_TREE",
"name": {
"value": "*state structure(en)"
}
}
}
}
},
{
"@archetype_node_id": "openEHR-EHR-OBSERVATION.height.v1",
"@xsi:type": "OBSERVATION",
"name": {
"value": "Height/Length"
},
"language": {
"terminology_id": {
"value": "ISO_639-1"
},
"code_string": "es"
},
"encoding": {
"terminology_id": {
"value": "Unicode"
},
"code_string": "UTF-8"
},
"subject": {
"@xsi:type": "PARTY_SELF"
},
"protocol": {
"@archetype_node_id": "at0007",
"@xsi:type": "ITEM_TREE",
"name": {
"value": "List"
}
},
"data": {
"@archetype_node_id": "at0001",
"@xsi:type": "HISTORY",
"name": {
"value": "history"
},
"origin": {
"@xsi:type": "DV_DATE_TIME",
"value": "20160502T174526,000-0400"
},
"events": {
"@archetype_node_id": "at0002",
"@xsi:type": "POINT_EVENT",
"name": {
"value": "Any event"
},
"time": {
"@xsi:type": "DV_DATE_TIME",
"value": "20160502T174526,000-0400"
},
"data": {
"@archetype_node_id": "at0003",
"@xsi:type": "ITEM_TREE",
"name": {
"value": "Simple"
},
"items": {
"@archetype_node_id": "at0004",
"@xsi:type": "ELEMENT",
"name": {
"value": "Height/Length"
},
"value": {
"@xsi:type": "DV_QUANTITY",
"magnitude": 194,
"units": "cm"
}
}
},
"state": {
"@archetype_node_id": "at0013",
"@xsi:type": "ITEM_TREE",
"name": {
"value": "Tree"
}
}
}
}
}
]
},
"lifecycle_state": {
"value": "completed",
"defining_code": {
"terminology_id": {
"value": "openehr"
},
"code_string": 532
}
}
}
}
}
DATATYPES (the result set can be not grouped, grouped by path (good for charting), grouped by composition (good for table display))
not grouped
[
{
"archetypeId": "openEHR-EHR-OBSERVATION.blood_pressure.v1",
"archetypePath": "/data[at0001]/events[at0006]/data[at0003]/items[at0005]/value",
"magnitude": 69,
"owner": {
"uid": "123123123-..."
},
"path": "/content[archetype_id=openEHR-EHR-OBSERVATION.blood_pressure.v1]/data[at0001]/events[at0006]/data[at0003]/items[at0005]/value",
"templateId": "Signos",
"units": "mm[Hg]"
},
{
"archetypeId": "openEHR-EHR-OBSERVATION.blood_pressure.v1",
"archetypePath": "/data[at0001]/events[at0006]/data[at0003]/items[at0004]/value",
"magnitude": 107,
"owner": {
"uid": "123123123-..."
},
"path": "/content[archetype_id=openEHR-EHR-OBSERVATION.blood_pressure.v1]/data[at0001]/events[at0006]/data[at0003]/items[at0004]/value",
"templateId": "Signos",
"units": "mm[Hg]"
},
{
"archetypeId": "openEHR-EHR-OBSERVATION.body_temperature.v1",
"archetypePath": "/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value",
"magnitude": 38,
"owner": {
"uid": "123123123-..."
},
"path": "/content[archetype_id=openEHR-EHR-OBSERVATION.body_temperature.v1]/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value",
"templateId": "Signos",
"units": "°C"
},
...
]
grouped by path
{
"openEHR-EHR-OBSERVATION.blood_pressure.v1/data[at0001]/events[at0006]/data[at0003]/items[at0004]/value": {
"type": "DV_QUANTITY",
"name": "Sistólica",
"serie": [
{
"magnitude": 140,
"units": "mm[Hg]",
"date": "2016-04-23 03:12:20"
},
{
"magnitude": 121,
"units": "mm[Hg]",
"date": "2016-04-30 06:58:05"
},
{
"magnitude": 180,
"units": "mm[Hg]",
"date": "2016-05-02 21:45:26"
},
{
"magnitude": 107,
"units": "mm[Hg]",
"date": "2016-05-23 22:52:34"
}
]
},
"openEHR-EHR-OBSERVATION.blood_pressure.v1/data[at0001]/events[at0006]/data[at0003]/items[at0005]/value": {
"type": "DV_QUANTITY",
"name": "Diastólica",
"serie": [
{
"magnitude": 76,
"units": "mm[Hg]",
"date": "2016-04-23 03:12:20"
},
{
"magnitude": 54,
"units": "mm[Hg]",
"date": "2016-04-30 06:58:05"
},
{
"magnitude": 92,
"units": "mm[Hg]",
"date": "2016-05-02 21:45:26"
},
{
"magnitude": 69,
"units": "mm[Hg]",
"date": "2016-05-23 22:52:34"
}
]
},
"openEHR-EHR-OBSERVATION.body_temperature.v1/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value": {
"type": "DV_QUANTITY",
"name": "Temperature",
"serie": [
{
"magnitude": 36,
"units": "°C",
"date": "2016-04-23 03:12:20"
},
{
"magnitude": 39,
"units": "°C",
"date": "2016-04-30 06:58:05"
},
{
"magnitude": 39,
"units": "°C",
"date": "2016-05-02 21:45:26"
},
{
"magnitude": 38,
"units": "°C",
"date": "2016-05-23 22:52:34"
}
]
},
"openEHR-EHR-OBSERVATION.body_weight.v1/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value": {
"type": "DV_QUANTITY",
"name": "Peso",
"serie": [
{
"magnitude": 81,
"units": "kg",
"date": "2016-04-23 03:12:20"
},
{
"magnitude": 75,
"units": "kg",
"date": "2016-04-30 06:58:05"
},
{
"magnitude": 48,
"units": "kg",
"date": "2016-05-02 21:45:26"
},
{
"magnitude": 44,
"units": "kg",
"date": "2016-05-23 22:52:34"
}
]
},
"openEHR-EHR-OBSERVATION.respiration.v1/data[at0001]/events[at0002]/data[at0003]/items[at0004]/value": {
"type": "DV_QUANTITY",
"name": "Rate",
"serie": [
{
"magnitude": 50,
"units": "/min",
"date": "2016-04-23 03:12:20"
},
{
"magnitude": 41,
"units": "/min",
"date": "2016-04-30 06:58:05"
},
{
"magnitude": 66,
"units": "/min",
"date": "2016-05-02 21:45:26"
},
{
"magnitude": 61,
"units": "/min",
"date": "2016-05-23 22:52:34"
}
]
},
"openEHR-EHR-OBSERVATION.pulse.v1/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value": {
"type": "DV_QUANTITY",
"name": "Frecuencia",
"serie": [
{
"magnitude": 91,
"units": "/min",
"date": "2016-04-23 03:12:20"
},
{
"magnitude": 47,
"units": "/min",
"date": "2016-04-30 06:58:05"
},
{
"magnitude": 65,
"units": "/min",
"date": "2016-05-02 21:45:26"
},
{
"magnitude": 42,
"units": "/min",
"date": "2016-05-23 22:52:34"
}
]
}
}
.jpg?version=1&modificationDate=1466682572208&cacheVersion=1&api=v2&width=510&height=250)
grouped by composition
[
{
"openEHR-EHR-OBSERVATION.blood_pressure.v1/data[at0001]/events[at0006]/data[at0003]/items[at0004]/value": {
"type": "DV_QUANTITY",
"name": "Sistólica",
"attrs": [
"magnitude",
"units"
]
},
"openEHR-EHR-OBSERVATION.blood_pressure.v1/data[at0001]/events[at0006]/data[at0003]/items[at0005]/value": {
"type": "DV_QUANTITY",
"name": "Diastólica",
"attrs": [
"magnitude",
"units"
]
},
"openEHR-EHR-OBSERVATION.body_temperature.v1/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value": {
"type": "DV_QUANTITY",
"name": "Temperature",
"attrs": [
"magnitude",
"units"
]
},
"openEHR-EHR-OBSERVATION.body_weight.v1/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value": {
"type": "DV_QUANTITY",
"name": "Peso",
"attrs": [
"magnitude",
"units"
]
},
"openEHR-EHR-OBSERVATION.respiration.v1/data[at0001]/events[at0002]/data[at0003]/items[at0004]/value": {
"type": "DV_QUANTITY",
"name": "Rate",
"attrs": [
"magnitude",
"units"
]
},
"openEHR-EHR-OBSERVATION.pulse.v1/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value": {
"type": "DV_QUANTITY",
"name": "Frecuencia",
"attrs": [
"magnitude",
"units"
]
}
},
{
"73c9fa14-a5e3-45d2-bf08-7e3a97ef3de4": {
"date": "2016-04-23 03:12:20",
"cols": [
{
"type": "DV_QUANTITY",
"path": "openEHR-EHR-OBSERVATION.blood_pressure.v1/data[at0001]/events[at0006]/data[at0003]/items[at0004]/value",
"magnitude": 140,
"units": "mm[Hg]"
},
{
"type": "DV_QUANTITY",
"path": "openEHR-EHR-OBSERVATION.blood_pressure.v1/data[at0001]/events[at0006]/data[at0003]/items[at0005]/value",
"magnitude": 76,
"units": "mm[Hg]"
},
{
"type": "DV_QUANTITY",
"path": "openEHR-EHR-OBSERVATION.body_temperature.v1/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value",
"magnitude": 36,
"units": "°C"
},
{
"type": "DV_QUANTITY",
"path": "openEHR-EHR-OBSERVATION.body_weight.v1/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value",
"magnitude": 81,
"units": "kg"
},
{
"type": "DV_QUANTITY",
"path": "openEHR-EHR-OBSERVATION.respiration.v1/data[at0001]/events[at0002]/data[at0003]/items[at0004]/value",
"magnitude": 50,
"units": "/min"
},
{
"type": "DV_QUANTITY",
"path": "openEHR-EHR-OBSERVATION.pulse.v1/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value",
"magnitude": 91,
"units": "/min"
}
]
},
"58c55bd6-e4b5-47dd-b96e-0dff42a0270e": {
"date": "2016-04-30 06:58:05",
"cols": [
{
"type": "DV_QUANTITY",
"path": "openEHR-EHR-OBSERVATION.blood_pressure.v1/data[at0001]/events[at0006]/data[at0003]/items[at0004]/value",
"magnitude": 121,
"units": "mm[Hg]"
},
{
"type": "DV_QUANTITY",
"path": "openEHR-EHR-OBSERVATION.blood_pressure.v1/data[at0001]/events[at0006]/data[at0003]/items[at0005]/value",
"magnitude": 54,
"units": "mm[Hg]"
},
{
"type": "DV_QUANTITY",
"path": "openEHR-EHR-OBSERVATION.body_temperature.v1/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value",
"magnitude": 39,
"units": "°C"
},
{
"type": "DV_QUANTITY",
"path": "openEHR-EHR-OBSERVATION.body_weight.v1/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value",
"magnitude": 75,
"units": "kg"
},
{
"type": "DV_QUANTITY",
"path": "openEHR-EHR-OBSERVATION.respiration.v1/data[at0001]/events[at0002]/data[at0003]/items[at0004]/value",
"magnitude": 41,
"units": "/min"
},
{
"type": "DV_QUANTITY",
"path": "openEHR-EHR-OBSERVATION.pulse.v1/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value",
"magnitude": 47,
"units": "/min"
}
]
},
"6ee98578-06e7-486b-a903-2a2fea21b1e9": {
"date": "2016-05-02 21:45:26",
"cols": [
{
"type": "DV_QUANTITY",
"path": "openEHR-EHR-OBSERVATION.blood_pressure.v1/data[at0001]/events[at0006]/data[at0003]/items[at0004]/value",
"magnitude": 180,
"units": "mm[Hg]"
},
{
"type": "DV_QUANTITY",
"path": "openEHR-EHR-OBSERVATION.blood_pressure.v1/data[at0001]/events[at0006]/data[at0003]/items[at0005]/value",
"magnitude": 92,
"units": "mm[Hg]"
},
{
"type": "DV_QUANTITY",
"path": "openEHR-EHR-OBSERVATION.body_temperature.v1/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value",
"magnitude": 39,
"units": "°C"
},
{
"type": "DV_QUANTITY",
"path": "openEHR-EHR-OBSERVATION.body_weight.v1/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value",
"magnitude": 48,
"units": "kg"
},
{
"type": "DV_QUANTITY",
"path": "openEHR-EHR-OBSERVATION.respiration.v1/data[at0001]/events[at0002]/data[at0003]/items[at0004]/value",
"magnitude": 66,
"units": "/min"
},
{
"type": "DV_QUANTITY",
"path": "openEHR-EHR-OBSERVATION.pulse.v1/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value",
"magnitude": 65,
"units": "/min"
}
]
},
"a51fcc18-5dcd-4711-ad4b-969fa1407894": {
"date": "2016-05-23 22:52:34",
"cols": [
{
"type": "DV_QUANTITY",
"path": "openEHR-EHR-OBSERVATION.blood_pressure.v1/data[at0001]/events[at0006]/data[at0003]/items[at0004]/value",
"magnitude": 107,
"units": "mm[Hg]"
},
{
"type": "DV_QUANTITY",
"path": "openEHR-EHR-OBSERVATION.blood_pressure.v1/data[at0001]/events[at0006]/data[at0003]/items[at0005]/value",
"magnitude": 69,
"units": "mm[Hg]"
},
{
"type": "DV_QUANTITY",
"path": "openEHR-EHR-OBSERVATION.body_temperature.v1/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value",
"magnitude": 38,
"units": "°C"
},
{
"type": "DV_QUANTITY",
"path": "openEHR-EHR-OBSERVATION.body_weight.v1/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value",
"magnitude": 44,
"units": "kg"
},
{
"type": "DV_QUANTITY",
"path": "openEHR-EHR-OBSERVATION.respiration.v1/data[at0001]/events[at0002]/data[at0003]/items[at0004]/value",
"magnitude": 61,
"units": "/min"
},
{
"type": "DV_QUANTITY",
"path": "openEHR-EHR-OBSERVATION.pulse.v1/data[at0002]/events[at0003]/data[at0001]/items[at0004]/value",
"magnitude": 42,
"units": "/min"
}
]
}
}
]
JSON Specifics
Proposed Standard