-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathreport
177 lines (166 loc) · 172 KB
/
report
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
Resource: CarePlan
All Columns: ['abatementDateTime', 'activity', 'address', 'addresses', 'authoredOn', 'billablePeriod', 'birthDate', 'careTeam', 'category', 'claim', 'class', 'clinicalStatus', 'code', 'communication', 'component', 'contained', 'created', 'diagnosis', 'dosageInstruction', 'effectiveDateTime', 'encounter', 'extension', 'gender', 'id', 'identifier', 'insurance', 'insurer', 'intent', 'issued', 'item', 'managingOrganization', 'maritalStatus', 'medicationCodeableConcept', 'multipleBirthBoolean', 'name', 'occurrenceDateTime', 'onsetDateTime', 'outcome', 'participant', 'patient', 'payment', 'performedPeriod', 'period', 'prescription', 'primarySource', 'priority', 'procedure', 'provider', 'reasonCode', 'reasonReference', 'recordedDate', 'referral', 'requester', 'resourceType', 'result', 'serviceProvider', 'status', 'subject', 'supportingInfo', 'telecom', 'text', 'total', 'type', 'use', 'vaccineCode', 'valueCodeableConcept', 'valueQuantity', 'verificationStatus']
Non-Null Columns: ['activity', 'addresses', 'careTeam', 'category', 'encounter', 'id', 'period', 'text']
DataFrame with Non-Null Columns for CarePlan:
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------+-------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------+------------------------------------+------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|activity |addresses |careTeam |category |encounter |id |period |text |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------+-------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------+------------------------------------+------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|[{{{[{385949008, Dressing change management, http://snomed.info/sct}], Dressing change management}, {Queen Elizabeth Hospital}, completed}}, {{{[{439830001, Behavior to prevent infection, http://snomed.info/sct}], Behavior to prevent infection}, {Queen Elizabeth Hospital}, completed}}] |[{urn:uuid:f28c617a-40dd-4901-3add-1637dba5b3c2}]|[{NULL, urn:uuid:25c19955-2824-6655-8457-dad4d44335bc, NULL, NULL}]|[{[{225358003, Wound care, http://snomed.info/sct}], Wound care}] |{urn:uuid:e3ba0c81-2fa0-aa88-1cca-9d3610d96d6d}|6423d2e4-03b3-5e83-847a-d142fc1c5de1|{2018-12-11T05:16:00-05:00, 2018-11-15T04:49:43-05:00}|{<div xmlns="http://www.w3.org/1999/xhtml">Care Plan for Wound care.<br/>Activities: <ul><li>Wound care</li><li>Wound care</li></ul><br/>Care plan is meant to treat Laceration of forearm.</div>, generated} |
|[{{{[{409524006, Airborne precautions (procedure), http://snomed.info/sct}], Airborne precautions (procedure)}, {Queen Elizabeth Hospital}, completed}}, {{{[{409526008, Personal protective equipment (physical object), http://snomed.info/sct}], Personal protective equipment (physical object)}, {Queen Elizabeth Hospital}, completed}}]|[{urn:uuid:b81954ff-53a2-1dd1-d12d-24b0b6dd13b0}]|[{NULL, urn:uuid:2903ef08-df03-8e0c-3e75-c27fc932a32f, NULL, NULL}]|[{[{736376001, Infectious disease care plan (record artifact), http://snomed.info/sct}], Infectious disease care plan (record artifact)}]|{urn:uuid:eba0f573-2988-e3b1-9ba0-29fc5d32ccd4}|f9a69b81-3ed1-e3da-4057-099463b5a96f|{2020-03-14T07:15:22-04:00, 2020-03-14T06:01:33-04:00}|{<div xmlns="http://www.w3.org/1999/xhtml">Care Plan for Infectious disease care plan (record artifact).<br/>Activities: <ul><li>Infectious disease care plan (record artifact)</li><li>Infectious disease care plan (record artifact)</li></ul><br/>Care plan is meant to treat Suspected COVID-19.</div>, generated}|
|[{{{[{409524006, Airborne precautions (procedure), http://snomed.info/sct}], Airborne precautions (procedure)}, {Queen Elizabeth Hospital}, completed}}, {{{[{361235007, Isolation of infected patient (procedure), http://snomed.info/sct}], Isolation of infected patient (procedure)}, {Queen Elizabeth Hospital}, completed}}] |[{urn:uuid:d27fd20c-6848-0a1e-8284-baa94346ec0f}]|[{NULL, urn:uuid:f279f479-a90b-5583-7aa2-141b8e883993, NULL, NULL}]|[{[{736376001, Infectious disease care plan (record artifact), http://snomed.info/sct}], Infectious disease care plan (record artifact)}]|{urn:uuid:eba0f573-2988-e3b1-9ba0-29fc5d32ccd4}|f3a3acf0-7acf-8f1c-d832-9f0e3b7244ca|{2020-04-12T19:15:22-04:00, 2020-03-14T07:15:22-04:00}|{<div xmlns="http://www.w3.org/1999/xhtml">Care Plan for Infectious disease care plan (record artifact).<br/>Activities: <ul><li>Infectious disease care plan (record artifact)</li><li>Infectious disease care plan (record artifact)</li></ul><br/>Care plan is meant to treat COVID-19.</div>, generated} |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------+-------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------+------------------------------------+------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
Resource: CareTeam
All Columns: ['abatementDateTime', 'activity', 'address', 'addresses', 'authoredOn', 'billablePeriod', 'birthDate', 'careTeam', 'category', 'claim', 'class', 'clinicalStatus', 'code', 'communication', 'component', 'contained', 'created', 'diagnosis', 'dosageInstruction', 'effectiveDateTime', 'encounter', 'extension', 'gender', 'id', 'identifier', 'insurance', 'insurer', 'intent', 'issued', 'item', 'managingOrganization', 'maritalStatus', 'medicationCodeableConcept', 'multipleBirthBoolean', 'name', 'occurrenceDateTime', 'onsetDateTime', 'outcome', 'participant', 'patient', 'payment', 'performedPeriod', 'period', 'prescription', 'primarySource', 'priority', 'procedure', 'provider', 'reasonCode', 'reasonReference', 'recordedDate', 'referral', 'requester', 'resourceType', 'result', 'serviceProvider', 'status', 'subject', 'supportingInfo', 'telecom', 'text', 'total', 'type', 'use', 'vaccineCode', 'valueCodeableConcept', 'valueQuantity', 'verificationStatus']
Non-Null Columns: ['encounter', 'id', 'participant', 'period', 'reasonCode']
DataFrame with Non-Null Columns for CareTeam:
+-----------------------------------------------+------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------------------+---------------------------------------------------------------------------------------+
|encounter |id |participant |period |reasonCode |
+-----------------------------------------------+------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------------------+---------------------------------------------------------------------------------------+
|{urn:uuid:e3ba0c81-2fa0-aa88-1cca-9d3610d96d6d}|25c19955-2824-6655-8457-dad4d44335bc|[{NULL, {Mr. Aaron697 Stanton715, urn:uuid:72ac5e72-4a1d-0693-3ef9-7f47f8911a60}, NULL, [{[{116154003, Patient, http://snomed.info/sct}], Patient}], NULL}, {NULL, {Dr. Quinton758 Kemmer137, Practitioner?identifier=http://hl7.org/fhir/sid/us-npi|9999999279}, NULL, [{[{223366009, Healthcare professional (occupation), http://snomed.info/sct}], Healthcare professional (occupation)}], NULL}, {NULL, {Queen Elizabeth Hospital, Organization?identifier=https://github.com/synthetichealth/synthea|d40954e4-890c-3eb9-9c4f-2ffe9fd17dba}, NULL, [{[{224891009, Healthcare services (qualifier value), http://snomed.info/sct}], Healthcare services (qualifier value)}], NULL}]|{2018-12-11T05:16:00-05:00, 2018-11-15T04:49:43-05:00}|[{[{283371005, Laceration of forearm, http://snomed.info/sct}], Laceration of forearm}]|
|{urn:uuid:eba0f573-2988-e3b1-9ba0-29fc5d32ccd4}|2903ef08-df03-8e0c-3e75-c27fc932a32f|[{NULL, {Mr. Aaron697 Stanton715, urn:uuid:72ac5e72-4a1d-0693-3ef9-7f47f8911a60}, NULL, [{[{116154003, Patient, http://snomed.info/sct}], Patient}], NULL}, {NULL, {Dr. Whitney250 Wyman904, Practitioner?identifier=http://hl7.org/fhir/sid/us-npi|9999999969}, NULL, [{[{223366009, Healthcare professional (occupation), http://snomed.info/sct}], Healthcare professional (occupation)}], NULL}, {NULL, {Queen Elizabeth Hospital, Organization?identifier=https://github.com/synthetichealth/synthea|d40954e4-890c-3eb9-9c4f-2ffe9fd17dba}, NULL, [{[{224891009, Healthcare services (qualifier value), http://snomed.info/sct}], Healthcare services (qualifier value)}], NULL}] |{2020-03-14T07:15:22-04:00, 2020-03-14T06:01:33-04:00}|[{[{840544004, Suspected COVID-19, http://snomed.info/sct}], Suspected COVID-19}] |
|{urn:uuid:eba0f573-2988-e3b1-9ba0-29fc5d32ccd4}|f279f479-a90b-5583-7aa2-141b8e883993|[{NULL, {Mr. Aaron697 Stanton715, urn:uuid:72ac5e72-4a1d-0693-3ef9-7f47f8911a60}, NULL, [{[{116154003, Patient, http://snomed.info/sct}], Patient}], NULL}, {NULL, {Dr. Whitney250 Wyman904, Practitioner?identifier=http://hl7.org/fhir/sid/us-npi|9999999969}, NULL, [{[{223366009, Healthcare professional (occupation), http://snomed.info/sct}], Healthcare professional (occupation)}], NULL}, {NULL, {Queen Elizabeth Hospital, Organization?identifier=https://github.com/synthetichealth/synthea|d40954e4-890c-3eb9-9c4f-2ffe9fd17dba}, NULL, [{[{224891009, Healthcare services (qualifier value), http://snomed.info/sct}], Healthcare services (qualifier value)}], NULL}] |{2020-04-12T19:15:22-04:00, 2020-03-14T07:15:22-04:00}|[{[{840539006, COVID-19, http://snomed.info/sct}], COVID-19}] |
+-----------------------------------------------+------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------------------+---------------------------------------------------------------------------------------+
Resource: Claim
All Columns: ['abatementDateTime', 'activity', 'address', 'addresses', 'authoredOn', 'billablePeriod', 'birthDate', 'careTeam', 'category', 'claim', 'class', 'clinicalStatus', 'code', 'communication', 'component', 'contained', 'created', 'diagnosis', 'dosageInstruction', 'effectiveDateTime', 'encounter', 'extension', 'gender', 'id', 'identifier', 'insurance', 'insurer', 'intent', 'issued', 'item', 'managingOrganization', 'maritalStatus', 'medicationCodeableConcept', 'multipleBirthBoolean', 'name', 'occurrenceDateTime', 'onsetDateTime', 'outcome', 'participant', 'patient', 'payment', 'performedPeriod', 'period', 'prescription', 'primarySource', 'priority', 'procedure', 'provider', 'reasonCode', 'reasonReference', 'recordedDate', 'referral', 'requester', 'resourceType', 'result', 'serviceProvider', 'status', 'subject', 'supportingInfo', 'telecom', 'text', 'total', 'type', 'use', 'vaccineCode', 'valueCodeableConcept', 'valueQuantity', 'verificationStatus']
Non-Null Columns: ['billablePeriod', 'created', 'diagnosis', 'id', 'item', 'patient', 'prescription', 'procedure', 'provider', 'supportingInfo', 'total', 'type']
DataFrame with Non-Null Columns for Claim:
+------------------------------------------------------+-------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------------------------+-----------------------------------------------+------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------+-------------------------------------------------------------------------------------------------+
|billablePeriod |created |diagnosis |id |item |patient |prescription |procedure |provider |supportingInfo |total |type |
+------------------------------------------------------+-------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------------------------+-----------------------------------------------+------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------+-------------------------------------------------------------------------------------------------+
|{2013-01-18T05:04:43-05:00, 2013-01-18T04:49:43-05:00}|2013-01-18T05:04:43-05:00|NULL |f33e48e6-3bee-d623-daca-c94074083d1f|[{NULL, NULL, NULL, [{urn:uuid:c515ad7d-f4ca-4ae1-60d9-5e6b6c9ea03d}], NULL, NULL, NULL, NULL, {[{162673000, General examination of patient (procedure), http://snomed.info/sct}], General examination of patient (procedure)}, 1, NULL}, {NULL, NULL, NULL, NULL, [1], NULL, {USD, 136.0}, NULL, {[{140, Influenza, seasonal, injectable, preservative free, http://hl7.org/fhir/sid/cvx}], Influenza, seasonal, injectable, preservative free}, 2, NULL}, {NULL, NULL, NULL, NULL, [2], NULL, {USD, 136.0}, NULL, {[{113, Td (adult) preservative free, http://hl7.org/fhir/sid/cvx}], Td (adult) preservative free}, 3, NULL}, {NULL, NULL, NULL, NULL, NULL, NULL, {USD, 704.29}, [1], {[{430193006, Medication Reconciliation (procedure), http://snomed.info/sct}], Medication Reconciliation (procedure)}, 4, NULL}] |{Aaron697 Stanton715, urn:uuid:72ac5e72-4a1d-0693-3ef9-7f47f8911a60}|NULL |[{{urn:uuid:93912fa8-a853-9b48-b022-3ef3f168d7a2}, 1}]|{Central Queens Health Centre, Organization?identifier=https://github.com/synthetichealth/synthea|d3b4abc3-41bc-3ad8-9bab-f0c1ab8aacbd}|[{{[{info, http://terminology.hl7.org/CodeSystem/claiminformationcategory}]}, 1, {urn:uuid:e0fdb1f3-fe95-c34d-33c7-9e82c6313d66}}, {{[{info, http://terminology.hl7.org/CodeSystem/claiminformationcategory}]}, 2, {urn:uuid:39dd3e30-998f-cc47-759f-facc12518d1b}}]|{"value":125.0,"currency":"USD"}|{"coding":[{"system":"http://terminology.hl7.org/CodeSystem/claim-type","code":"institutional"}]}|
|{2016-01-22T05:04:43-05:00, 2016-01-22T04:49:43-05:00}|2016-01-22T05:04:43-05:00|NULL |4a932041-7626-8cbf-6090-5148d344fb28|[{NULL, NULL, NULL, [{urn:uuid:9967925a-1592-669e-85de-a84c5e12b724}], NULL, NULL, NULL, NULL, {[{162673000, General examination of patient (procedure), http://snomed.info/sct}], General examination of patient (procedure)}, 1, NULL}, {NULL, NULL, NULL, NULL, [1], NULL, {USD, 136.0}, NULL, {[{140, Influenza, seasonal, injectable, preservative free, http://hl7.org/fhir/sid/cvx}], Influenza, seasonal, injectable, preservative free}, 2, NULL}] |{Aaron697 Stanton715, urn:uuid:72ac5e72-4a1d-0693-3ef9-7f47f8911a60}|NULL |NULL |{Central Queens Health Centre, Organization?identifier=https://github.com/synthetichealth/synthea|d3b4abc3-41bc-3ad8-9bab-f0c1ab8aacbd}|[{{[{info, http://terminology.hl7.org/CodeSystem/claiminformationcategory}]}, 1, {urn:uuid:286689a1-2d0b-9d28-1243-b6961ac5bb70}}] |{"value":125.0,"currency":"USD"}|{"coding":[{"system":"http://terminology.hl7.org/CodeSystem/claim-type","code":"institutional"}]}|
|{2018-11-15T05:49:43-05:00, 2018-11-15T04:49:43-05:00}|2018-11-15T05:49:43-05:00|NULL |c2f9c59d-011b-2ed6-e2d8-0ef3ffca8a5f|[{NULL, NULL, NULL, [{urn:uuid:e3ba0c81-2fa0-aa88-1cca-9d3610d96d6d}], NULL, NULL, NULL, NULL, {[{50849002, Emergency room admission (procedure), http://snomed.info/sct}], Emergency room admission (procedure)}, 1, NULL}] |{NULL, urn:uuid:72ac5e72-4a1d-0693-3ef9-7f47f8911a60} |{urn:uuid:d52b1df7-ecbf-d8c0-acb9-8b9e0c458951}|NULL |{Queen Elizabeth Hospital, Organization?identifier=https://github.com/synthetichealth/synthea|d40954e4-890c-3eb9-9c4f-2ffe9fd17dba} |NULL |{"value":6.37,"currency":"USD"} |{"coding":[{"system":"http://terminology.hl7.org/CodeSystem/claim-type","code":"pharmacy"}]} |
|{2018-11-15T05:49:43-05:00, 2018-11-15T04:49:43-05:00}|2018-11-15T05:49:43-05:00|[{{urn:uuid:f28c617a-40dd-4901-3add-1637dba5b3c2}, 1, NULL}] |2ba5c308-e4a8-ae48-b16d-fcfd949a6883|[{NULL, NULL, NULL, [{urn:uuid:e3ba0c81-2fa0-aa88-1cca-9d3610d96d6d}], NULL, NULL, NULL, NULL, {[{50849002, Emergency room admission (procedure), http://snomed.info/sct}], Emergency room admission (procedure)}, 1, NULL}, {NULL, NULL, [1], NULL, NULL, NULL, NULL, NULL, {[{283371005, Laceration of forearm, http://snomed.info/sct}], Laceration of forearm}, 2, NULL}, {NULL, NULL, NULL, NULL, NULL, NULL, {USD, 12845.63}, [1], {[{288086009, Suture open wound, http://snomed.info/sct}], Suture open wound}, 3, NULL}] |{Aaron697 Stanton715, urn:uuid:72ac5e72-4a1d-0693-3ef9-7f47f8911a60}|NULL |[{{urn:uuid:fcb70e85-a33e-1eea-5043-6e583e5eb02d}, 1}]|{Queen Elizabeth Hospital, Organization?identifier=https://github.com/synthetichealth/synthea|d40954e4-890c-3eb9-9c4f-2ffe9fd17dba} |NULL |{"value":125.0,"currency":"USD"}|{"coding":[{"system":"http://terminology.hl7.org/CodeSystem/claim-type","code":"institutional"}]}|
|{2019-01-25T05:04:43-05:00, 2019-01-25T04:49:43-05:00}|2019-01-25T05:04:43-05:00|NULL |93afe0c6-de34-ec38-0346-7b464dd2bda0|[{NULL, NULL, NULL, [{urn:uuid:9f9c2423-aa6c-c928-a38e-b0efd2d6b6c6}], NULL, NULL, NULL, NULL, {[{162673000, General examination of patient (procedure), http://snomed.info/sct}], General examination of patient (procedure)}, 1, NULL}, {NULL, NULL, NULL, NULL, [1], NULL, {USD, 136.0}, NULL, {[{140, Influenza, seasonal, injectable, preservative free, http://hl7.org/fhir/sid/cvx}], Influenza, seasonal, injectable, preservative free}, 2, NULL}] |{Aaron697 Stanton715, urn:uuid:72ac5e72-4a1d-0693-3ef9-7f47f8911a60}|NULL |NULL |{Central Queens Health Centre, Organization?identifier=https://github.com/synthetichealth/synthea|d3b4abc3-41bc-3ad8-9bab-f0c1ab8aacbd}|[{{[{info, http://terminology.hl7.org/CodeSystem/claiminformationcategory}]}, 1, {urn:uuid:74881a15-1bf5-86b5-126b-a7f4b96a1e2f}}] |{"value":125.0,"currency":"USD"}|{"coding":[{"system":"http://terminology.hl7.org/CodeSystem/claim-type","code":"institutional"}]}|
|{2019-04-06T01:04:43-04:00, 2019-04-06T00:49:43-04:00}|2019-04-06T01:04:43-04:00|[{{urn:uuid:21342b68-3691-34b6-6907-3db6605e26b8}, 1, NULL}] |b8fbb450-058f-aaf1-dec0-0a9a216d09d9|[{NULL, NULL, NULL, [{urn:uuid:68e07371-1e5b-8140-2a9a-91eb1b096df6}], NULL, NULL, NULL, NULL, {[{185345009, Encounter for symptom, http://snomed.info/sct}], Encounter for symptom}, 1, NULL}, {NULL, NULL, [1], NULL, NULL, NULL, NULL, NULL, {[{444814009, Viral sinusitis (disorder), http://snomed.info/sct}], Viral sinusitis (disorder)}, 2, NULL}] |{Aaron697 Stanton715, urn:uuid:72ac5e72-4a1d-0693-3ef9-7f47f8911a60}|NULL |NULL |{Queen Elizabeth Hospital, Organization?identifier=https://github.com/synthetichealth/synthea|d40954e4-890c-3eb9-9c4f-2ffe9fd17dba} |NULL |{"value":75.0,"currency":"USD"} |{"coding":[{"system":"http://terminology.hl7.org/CodeSystem/claim-type","code":"institutional"}]}|
|{2020-03-14T07:15:22-04:00, 2020-03-14T05:49:43-04:00}|2020-03-14T07:15:22-04:00|[{{urn:uuid:8fab10ec-dac2-4c6f-d493-a657620511c8}, 1, NULL}, {{urn:uuid:e0f39f3e-89bb-9fac-e3b0-a52d04540bd8}, 2, NULL}, {{urn:uuid:fd983be3-2818-a190-4936-358cac2649fd}, 3, NULL}, {{urn:uuid:722026e8-fb6d-4150-981d-bc3d524a7db9}, 4, NULL}, {{urn:uuid:be90f10a-d414-d5b3-71ce-4fede87c7537}, 5, NULL}, {{urn:uuid:b81954ff-53a2-1dd1-d12d-24b0b6dd13b0}, 6, NULL}, {{urn:uuid:d27fd20c-6848-0a1e-8284-baa94346ec0f}, 7, NULL}]|6e197383-1fb9-d998-57ff-12a9d0a7ad19|[{NULL, NULL, NULL, [{urn:uuid:eba0f573-2988-e3b1-9ba0-29fc5d32ccd4}], NULL, NULL, NULL, NULL, {[{185345009, Encounter for symptom (procedure), http://snomed.info/sct}], Encounter for symptom (procedure)}, 1, NULL}, {NULL, NULL, [1], NULL, NULL, NULL, NULL, NULL, {[{49727002, Cough (finding), http://snomed.info/sct}], Cough (finding)}, 2, NULL}, {NULL, NULL, [2], NULL, NULL, NULL, NULL, NULL, {[{267036007, Dyspnea (finding), http://snomed.info/sct}], Dyspnea (finding)}, 3, NULL}, {NULL, NULL, [3], NULL, NULL, NULL, NULL, NULL, {[{56018004, Wheezing (finding), http://snomed.info/sct}], Wheezing (finding)}, 4, NULL}, {NULL, NULL, [4], NULL, NULL, NULL, NULL, NULL, {[{386661006, Fever (finding), http://snomed.info/sct}], Fever (finding)}, 5, NULL}, {NULL, NULL, [5], NULL, NULL, NULL, NULL, NULL, {[{36955009, Loss of taste (finding), http://snomed.info/sct}], Loss of taste (finding)}, 6, NULL}, {NULL, NULL, [6], NULL, NULL, NULL, NULL, NULL, {[{840544004, Suspected COVID-19, http://snomed.info/sct}], Suspected COVID-19}, 7, NULL}, {NULL, NULL, NULL, NULL, NULL, NULL, {USD, 1.97}, [1], {[{261352009, Face mask (physical object), http://snomed.info/sct}], Face mask (physical object)}, 8, NULL}, {NULL, NULL, [7], NULL, NULL, NULL, NULL, NULL, {[{840539006, COVID-19, http://snomed.info/sct}], COVID-19}, 9, NULL}]|{Aaron697 Stanton715, urn:uuid:72ac5e72-4a1d-0693-3ef9-7f47f8911a60}|NULL |[{{urn:uuid:6ed6c5dd-6e06-4af4-fe51-772f3d947d7f}, 1}]|{Queen Elizabeth Hospital, Organization?identifier=https://github.com/synthetichealth/synthea|d40954e4-890c-3eb9-9c4f-2ffe9fd17dba} |NULL |{"value":75.0,"currency":"USD"} |{"coding":[{"system":"http://terminology.hl7.org/CodeSystem/claim-type","code":"institutional"}]}|
+------------------------------------------------------+-------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------------------------+-----------------------------------------------+------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------+-------------------------------------------------------------------------------------------------+
Resource: Condition
All Columns: ['abatementDateTime', 'activity', 'address', 'addresses', 'authoredOn', 'billablePeriod', 'birthDate', 'careTeam', 'category', 'claim', 'class', 'clinicalStatus', 'code', 'communication', 'component', 'contained', 'created', 'diagnosis', 'dosageInstruction', 'effectiveDateTime', 'encounter', 'extension', 'gender', 'id', 'identifier', 'insurance', 'insurer', 'intent', 'issued', 'item', 'managingOrganization', 'maritalStatus', 'medicationCodeableConcept', 'multipleBirthBoolean', 'name', 'occurrenceDateTime', 'onsetDateTime', 'outcome', 'participant', 'patient', 'payment', 'performedPeriod', 'period', 'prescription', 'primarySource', 'priority', 'procedure', 'provider', 'reasonCode', 'reasonReference', 'recordedDate', 'referral', 'requester', 'resourceType', 'result', 'serviceProvider', 'status', 'subject', 'supportingInfo', 'telecom', 'text', 'total', 'type', 'use', 'vaccineCode', 'valueCodeableConcept', 'valueQuantity', 'verificationStatus']
Non-Null Columns: ['abatementDateTime', 'code', 'encounter', 'id', 'onsetDateTime', 'recordedDate']
DataFrame with Non-Null Columns for Condition:
+-------------------------+-----------------------------------------------------------------------------------------------+-----------------------------------------------+------------------------------------+-------------------------+-------------------------+
|abatementDateTime |code |encounter |id |onsetDateTime |recordedDate |
+-------------------------+-----------------------------------------------------------------------------------------------+-----------------------------------------------+------------------------------------+-------------------------+-------------------------+
|2018-12-11T05:16:00-05:00|{[{283371005, Laceration of forearm, http://snomed.info/sct}], Laceration of forearm} |{urn:uuid:e3ba0c81-2fa0-aa88-1cca-9d3610d96d6d}|f28c617a-40dd-4901-3add-1637dba5b3c2|2018-11-15T04:49:43-05:00|2018-11-15T04:49:43-05:00|
|2019-04-14T00:49:43-04:00|{[{444814009, Viral sinusitis (disorder), http://snomed.info/sct}], Viral sinusitis (disorder)}|{urn:uuid:68e07371-1e5b-8140-2a9a-91eb1b096df6}|21342b68-3691-34b6-6907-3db6605e26b8|2019-04-06T00:49:43-04:00|2019-04-06T00:49:43-04:00|
|2020-04-12T19:15:22-04:00|{[{49727002, Cough (finding), http://snomed.info/sct}], Cough (finding)} |{urn:uuid:eba0f573-2988-e3b1-9ba0-29fc5d32ccd4}|8fab10ec-dac2-4c6f-d493-a657620511c8|2020-03-14T05:49:43-04:00|2020-03-14T05:49:43-04:00|
|2020-04-12T19:15:22-04:00|{[{267036007, Dyspnea (finding), http://snomed.info/sct}], Dyspnea (finding)} |{urn:uuid:eba0f573-2988-e3b1-9ba0-29fc5d32ccd4}|e0f39f3e-89bb-9fac-e3b0-a52d04540bd8|2020-03-14T05:49:43-04:00|2020-03-14T05:49:43-04:00|
|2020-04-12T19:15:22-04:00|{[{56018004, Wheezing (finding), http://snomed.info/sct}], Wheezing (finding)} |{urn:uuid:eba0f573-2988-e3b1-9ba0-29fc5d32ccd4}|fd983be3-2818-a190-4936-358cac2649fd|2020-03-14T05:49:43-04:00|2020-03-14T05:49:43-04:00|
|2020-04-12T19:15:22-04:00|{[{386661006, Fever (finding), http://snomed.info/sct}], Fever (finding)} |{urn:uuid:eba0f573-2988-e3b1-9ba0-29fc5d32ccd4}|722026e8-fb6d-4150-981d-bc3d524a7db9|2020-03-14T05:49:43-04:00|2020-03-14T05:49:43-04:00|
|2020-04-12T19:15:22-04:00|{[{36955009, Loss of taste (finding), http://snomed.info/sct}], Loss of taste (finding)} |{urn:uuid:eba0f573-2988-e3b1-9ba0-29fc5d32ccd4}|be90f10a-d414-d5b3-71ce-4fede87c7537|2020-03-14T05:49:43-04:00|2020-03-14T05:49:43-04:00|
|2020-03-14T07:15:22-04:00|{[{840544004, Suspected COVID-19, http://snomed.info/sct}], Suspected COVID-19} |{urn:uuid:eba0f573-2988-e3b1-9ba0-29fc5d32ccd4}|b81954ff-53a2-1dd1-d12d-24b0b6dd13b0|2020-03-14T05:49:43-04:00|2020-03-14T05:49:43-04:00|
|2020-04-12T19:15:22-04:00|{[{840539006, COVID-19, http://snomed.info/sct}], COVID-19} |{urn:uuid:eba0f573-2988-e3b1-9ba0-29fc5d32ccd4}|d27fd20c-6848-0a1e-8284-baa94346ec0f|2020-03-14T07:15:22-04:00|2020-03-14T07:15:22-04:00|
+-------------------------+-----------------------------------------------------------------------------------------------+-----------------------------------------------+------------------------------------+-------------------------+-------------------------+
Resource: DiagnosticReport
All Columns: ['abatementDateTime', 'activity', 'address', 'addresses', 'authoredOn', 'billablePeriod', 'birthDate', 'careTeam', 'category', 'claim', 'class', 'clinicalStatus', 'code', 'communication', 'component', 'contained', 'created', 'diagnosis', 'dosageInstruction', 'effectiveDateTime', 'encounter', 'extension', 'gender', 'id', 'identifier', 'insurance', 'insurer', 'intent', 'issued', 'item', 'managingOrganization', 'maritalStatus', 'medicationCodeableConcept', 'multipleBirthBoolean', 'name', 'occurrenceDateTime', 'onsetDateTime', 'outcome', 'participant', 'patient', 'payment', 'performedPeriod', 'period', 'prescription', 'primarySource', 'priority', 'procedure', 'provider', 'reasonCode', 'reasonReference', 'recordedDate', 'referral', 'requester', 'resourceType', 'result', 'serviceProvider', 'status', 'subject', 'supportingInfo', 'telecom', 'text', 'total', 'type', 'use', 'vaccineCode', 'valueCodeableConcept', 'valueQuantity', 'verificationStatus']
Non-Null Columns: ['code', 'effectiveDateTime', 'encounter', 'id', 'issued', 'result']
DataFrame with Non-Null Columns for DiagnosticReport:
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------+-----------------------------------------------+------------------------------------+-----------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|code |effectiveDateTime |encounter |id |issued |result |
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------+-----------------------------------------------+------------------------------------+-----------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|{[{57698-3, Lipid Panel, http://loinc.org}], Lipid Panel} |2013-01-18T04:49:43-05:00|{urn:uuid:c515ad7d-f4ca-4ae1-60d9-5e6b6c9ea03d}|ef06f848-4511-1206-0bdf-abcb3f86170b|2013-01-18T04:49:43.140-05:00|[{Total Cholesterol, urn:uuid:49a26773-135e-cbc2-1cb7-928ad99976b8}, {Triglycerides, urn:uuid:89d1acbd-bcac-c8f3-cdbb-13b49e170aaa}, {Low Density Lipoprotein Cholesterol, urn:uuid:cb4b7c43-4b76-def5-cc12-804488fe88fb}, {High Density Lipoprotein Cholesterol, urn:uuid:fa6290cf-e10b-13ea-68b0-0df315af5961}] |
|{[{57698-3, Lipid Panel, http://loinc.org}], Lipid Panel} |2016-01-22T04:49:43-05:00|{urn:uuid:9967925a-1592-669e-85de-a84c5e12b724}|5a4a15cf-2b69-ab5e-a463-8dc0a78ec4cb|2016-01-22T04:49:43.140-05:00|[{Total Cholesterol, urn:uuid:2c292fba-7749-45df-ce7d-9714ee9a3d61}, {Triglycerides, urn:uuid:b9442567-8cf1-cd98-671b-39708cb8c1cf}, {Low Density Lipoprotein Cholesterol, urn:uuid:05cab52c-f779-5cd0-e001-62e0e5ac5d41}, {High Density Lipoprotein Cholesterol, urn:uuid:52c1a1dd-bad7-5b76-b15f-e1c7ade793ea}] |
|{[{58410-2, Complete blood count (hemogram) panel - Blood by Automated count, http://loinc.org}], Complete blood count (hemogram) panel - Blood by Automated count} |2016-01-22T04:49:43-05:00|{urn:uuid:9967925a-1592-669e-85de-a84c5e12b724}|a0cfe016-22c4-81f4-f6d5-51d3d2c1d876|2016-01-22T04:49:43.140-05:00|[{Leukocytes [#/volume] in Blood by Automated count, urn:uuid:ab40046b-e2f3-89bb-f6c0-d16783fb9ed9}, {Erythrocytes [#/volume] in Blood by Automated count, urn:uuid:9c9f0c33-fc36-5bd3-07a1-c44f40e3b75b}, {Hemoglobin [Mass/volume] in Blood, urn:uuid:4474f094-88dc-cdfc-a850-a20faf2f349d}, {Hematocrit [Volume Fraction] of Blood by Automated count, urn:uuid:af54e7c3-33e6-f4bf-05cc-2c35a9fd5f96}, {MCV [Entitic volume] by Automated count, urn:uuid:589736da-2228-cd75-06f3-5e7606882123}, {MCH [Entitic mass] by Automated count, urn:uuid:f409af35-c479-130c-fa4e-1e233728ee73}, {MCHC [Mass/volume] by Automated count, urn:uuid:e79a2d00-db72-1b0b-ad6c-ece60f9597a4}, {Erythrocyte distribution width [Entitic volume] by Automated count, urn:uuid:3211eb0c-21f4-fed2-e084-92ad1dc8dcae}, {Platelets [#/volume] in Blood by Automated count, urn:uuid:3611bfe1-ffdf-9526-59c5-f2e373e4ec80}, {Platelet distribution width [Entitic volume] in Blood by Automated count, urn:uuid:9aec981a-2e69-ffed-9741-80e1b39c3268}, {Platelet mean volume [Entitic volume] in Blood by Automated count, urn:uuid:60fec1ec-d3a8-d235-f729-07a57d8f15b7}]|
|{[{57698-3, Lipid Panel, http://loinc.org}], Lipid Panel} |2019-01-25T04:49:43-05:00|{urn:uuid:9f9c2423-aa6c-c928-a38e-b0efd2d6b6c6}|162b39de-2364-afaf-209b-3da82d9bd304|2019-01-25T04:49:43.140-05:00|[{Total Cholesterol, urn:uuid:d740f2d4-3e84-ed72-f418-6ef6c6e26acc}, {Triglycerides, urn:uuid:0e7adfd2-eb69-3505-6bea-ff456ffb28ce}, {Low Density Lipoprotein Cholesterol, urn:uuid:76db46f2-bd02-b6bf-e9a1-6105dc4f67ed}, {High Density Lipoprotein Cholesterol, urn:uuid:70025675-2212-2c57-63ac-a4b8f225ed5e}] |
|{[{80381-7, Influenza virus A and B Ag panel - Nasopharynx by Rapid immunoassay, http://loinc.org}], Influenza virus A and B Ag panel - Nasopharynx by Rapid immunoassay}|2020-03-14T06:01:33-04:00|{urn:uuid:eba0f573-2988-e3b1-9ba0-29fc5d32ccd4}|9394b82f-76d6-8a9a-b037-febd601c0cb1|2020-03-14T06:01:33.140-04:00|[{Influenza virus A Ag [Presence] in Nasopharynx by Rapid immunoassay, urn:uuid:9a6348e9-c755-f13f-4ae6-bda421c9446b}, {Influenza virus B Ag [Presence] in Nasopharynx by Rapid immunoassay, urn:uuid:4cfbc9b2-7501-6589-afe0-dd5b5f9e8e1a}] |
|{[{94531-1, SARS-CoV-2 RNA Pnl Resp NAA+probe, http://loinc.org}], SARS-CoV-2 RNA Pnl Resp NAA+probe} |2020-03-14T07:15:22-04:00|{urn:uuid:eba0f573-2988-e3b1-9ba0-29fc5d32ccd4}|2d2113e7-39cd-8b99-6035-3339a8bc8195|2020-03-14T07:15:22.140-04:00|[{SARS-CoV-2 RNA Pnl Resp NAA+probe, urn:uuid:b4bf82c2-2fe4-3ddb-8168-edae1f6dbfc1}] |
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------+-----------------------------------------------+------------------------------------+-----------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
Resource: Encounter
All Columns: ['abatementDateTime', 'activity', 'address', 'addresses', 'authoredOn', 'billablePeriod', 'birthDate', 'careTeam', 'category', 'claim', 'class', 'clinicalStatus', 'code', 'communication', 'component', 'contained', 'created', 'diagnosis', 'dosageInstruction', 'effectiveDateTime', 'encounter', 'extension', 'gender', 'id', 'identifier', 'insurance', 'insurer', 'intent', 'issued', 'item', 'managingOrganization', 'maritalStatus', 'medicationCodeableConcept', 'multipleBirthBoolean', 'name', 'occurrenceDateTime', 'onsetDateTime', 'outcome', 'participant', 'patient', 'payment', 'performedPeriod', 'period', 'prescription', 'primarySource', 'priority', 'procedure', 'provider', 'reasonCode', 'reasonReference', 'recordedDate', 'referral', 'requester', 'resourceType', 'result', 'serviceProvider', 'status', 'subject', 'supportingInfo', 'telecom', 'text', 'total', 'type', 'use', 'vaccineCode', 'valueCodeableConcept', 'valueQuantity', 'verificationStatus']
Non-Null Columns: ['class', 'id', 'participant', 'period', 'reasonCode', 'serviceProvider', 'type']
DataFrame with Non-Null Columns for Encounter:
+--------------------------------------------------------+------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------------------+---------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|class |id |participant |period |reasonCode |serviceProvider |type |
+--------------------------------------------------------+------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------------------+---------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|{AMB, http://terminology.hl7.org/CodeSystem/v3-ActCode} |c515ad7d-f4ca-4ae1-60d9-5e6b6c9ea03d|[{{Dr. Houston994 Schiller186, Practitioner?identifier=http://hl7.org/fhir/sid/us-npi|9999999469}, NULL, {2013-01-18T05:04:43-05:00, 2013-01-18T04:49:43-05:00}, NULL, [{[{PPRF, primary performer, http://terminology.hl7.org/CodeSystem/v3-ParticipationType}], primary performer}]}]|{2013-01-18T05:04:43-05:00, 2013-01-18T04:49:43-05:00}|NULL |{Central Queens Health Centre, Organization?identifier=https://github.com/synthetichealth/synthea|d3b4abc3-41bc-3ad8-9bab-f0c1ab8aacbd}|[{"coding":[{"system":"http://snomed.info/sct","code":"162673000","display":"General examination of patient (procedure)"}],"text":"General examination of patient (procedure)"}]|
|{AMB, http://terminology.hl7.org/CodeSystem/v3-ActCode} |9967925a-1592-669e-85de-a84c5e12b724|[{{Dr. Houston994 Schiller186, Practitioner?identifier=http://hl7.org/fhir/sid/us-npi|9999999469}, NULL, {2016-01-22T05:04:43-05:00, 2016-01-22T04:49:43-05:00}, NULL, [{[{PPRF, primary performer, http://terminology.hl7.org/CodeSystem/v3-ParticipationType}], primary performer}]}]|{2016-01-22T05:04:43-05:00, 2016-01-22T04:49:43-05:00}|NULL |{Central Queens Health Centre, Organization?identifier=https://github.com/synthetichealth/synthea|d3b4abc3-41bc-3ad8-9bab-f0c1ab8aacbd}|[{"coding":[{"system":"http://snomed.info/sct","code":"162673000","display":"General examination of patient (procedure)"}],"text":"General examination of patient (procedure)"}]|
|{EMER, http://terminology.hl7.org/CodeSystem/v3-ActCode}|e3ba0c81-2fa0-aa88-1cca-9d3610d96d6d|[{{Dr. Quinton758 Kemmer137, Practitioner?identifier=http://hl7.org/fhir/sid/us-npi|9999999279}, NULL, {2018-11-15T05:49:43-05:00, 2018-11-15T04:49:43-05:00}, NULL, [{[{PPRF, primary performer, http://terminology.hl7.org/CodeSystem/v3-ParticipationType}], primary performer}]}] |{2018-11-15T05:49:43-05:00, 2018-11-15T04:49:43-05:00}|NULL |{Queen Elizabeth Hospital, Organization?identifier=https://github.com/synthetichealth/synthea|d40954e4-890c-3eb9-9c4f-2ffe9fd17dba} |[{"coding":[{"system":"http://snomed.info/sct","code":"50849002","display":"Emergency room admission (procedure)"}],"text":"Emergency room admission (procedure)"}] |
|{AMB, http://terminology.hl7.org/CodeSystem/v3-ActCode} |9f9c2423-aa6c-c928-a38e-b0efd2d6b6c6|[{{Dr. Houston994 Schiller186, Practitioner?identifier=http://hl7.org/fhir/sid/us-npi|9999999469}, NULL, {2019-01-25T05:04:43-05:00, 2019-01-25T04:49:43-05:00}, NULL, [{[{PPRF, primary performer, http://terminology.hl7.org/CodeSystem/v3-ParticipationType}], primary performer}]}]|{2019-01-25T05:04:43-05:00, 2019-01-25T04:49:43-05:00}|NULL |{Central Queens Health Centre, Organization?identifier=https://github.com/synthetichealth/synthea|d3b4abc3-41bc-3ad8-9bab-f0c1ab8aacbd}|[{"coding":[{"system":"http://snomed.info/sct","code":"162673000","display":"General examination of patient (procedure)"}],"text":"General examination of patient (procedure)"}]|
|{AMB, http://terminology.hl7.org/CodeSystem/v3-ActCode} |68e07371-1e5b-8140-2a9a-91eb1b096df6|[{{Dr. Whitney250 Wyman904, Practitioner?identifier=http://hl7.org/fhir/sid/us-npi|9999999969}, NULL, {2019-04-06T01:04:43-04:00, 2019-04-06T00:49:43-04:00}, NULL, [{[{PPRF, primary performer, http://terminology.hl7.org/CodeSystem/v3-ParticipationType}], primary performer}]}] |{2019-04-06T01:04:43-04:00, 2019-04-06T00:49:43-04:00}|[{[{444814009, Viral sinusitis (disorder), http://snomed.info/sct}], NULL}]|{Queen Elizabeth Hospital, Organization?identifier=https://github.com/synthetichealth/synthea|d40954e4-890c-3eb9-9c4f-2ffe9fd17dba} |[{"coding":[{"system":"http://snomed.info/sct","code":"185345009","display":"Encounter for symptom"}],"text":"Encounter for symptom"}] |
|{AMB, http://terminology.hl7.org/CodeSystem/v3-ActCode} |eba0f573-2988-e3b1-9ba0-29fc5d32ccd4|[{{Dr. Whitney250 Wyman904, Practitioner?identifier=http://hl7.org/fhir/sid/us-npi|9999999969}, NULL, {2020-03-14T07:15:22-04:00, 2020-03-14T05:49:43-04:00}, NULL, [{[{PPRF, primary performer, http://terminology.hl7.org/CodeSystem/v3-ParticipationType}], primary performer}]}] |{2020-03-14T07:15:22-04:00, 2020-03-14T05:49:43-04:00}|NULL |{Queen Elizabeth Hospital, Organization?identifier=https://github.com/synthetichealth/synthea|d40954e4-890c-3eb9-9c4f-2ffe9fd17dba} |[{"coding":[{"system":"http://snomed.info/sct","code":"185345009","display":"Encounter for symptom (procedure)"}],"text":"Encounter for symptom (procedure)"}] |
+--------------------------------------------------------+------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------------------+---------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
Resource: ExplanationOfBenefit
All Columns: ['abatementDateTime', 'activity', 'address', 'addresses', 'authoredOn', 'billablePeriod', 'birthDate', 'careTeam', 'category', 'claim', 'class', 'clinicalStatus', 'code', 'communication', 'component', 'contained', 'created', 'diagnosis', 'dosageInstruction', 'effectiveDateTime', 'encounter', 'extension', 'gender', 'id', 'identifier', 'insurance', 'insurer', 'intent', 'issued', 'item', 'managingOrganization', 'maritalStatus', 'medicationCodeableConcept', 'multipleBirthBoolean', 'name', 'occurrenceDateTime', 'onsetDateTime', 'outcome', 'participant', 'patient', 'payment', 'performedPeriod', 'period', 'prescription', 'primarySource', 'priority', 'procedure', 'provider', 'reasonCode', 'reasonReference', 'recordedDate', 'referral', 'requester', 'resourceType', 'result', 'serviceProvider', 'status', 'subject', 'supportingInfo', 'telecom', 'text', 'total', 'type', 'use', 'vaccineCode', 'valueCodeableConcept', 'valueQuantity', 'verificationStatus']
Non-Null Columns: ['billablePeriod', 'careTeam', 'claim', 'contained', 'created', 'diagnosis', 'id', 'identifier', 'item', 'payment', 'provider', 'total']
DataFrame with Non-Null Columns for ExplanationOfBenefit:
+------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------+-------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|billablePeriod |careTeam |claim |contained |created |diagnosis |id |identifier |item |payment |provider |total |
+------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------+-------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|{2014-01-18T05:04:43-05:00, 2013-01-18T05:04:43-05:00}|[{{Practitioner?identifier=http://hl7.org/fhir/sid/us-npi|9999999469}, NULL, {[{primary, Primary Care Practitioner, http://terminology.hl7.org/CodeSystem/claimcareteamrole}]}, 1}]|{urn:uuid:f33e48e6-3bee-d623-daca-c94074083d1f}|[{NULL, referral, order, NULL, [{Practitioner?identifier=http://hl7.org/fhir/sid/us-npi|9999999469}], {Practitioner?identifier=http://hl7.org/fhir/sid/us-npi|9999999469}, ServiceRequest, completed, {urn:uuid:72ac5e72-4a1d-0693-3ef9-7f47f8911a60}, NULL}, {{urn:uuid:72ac5e72-4a1d-0693-3ef9-7f47f8911a60}, coverage, NULL, [{NO_INSURANCE}], NULL, NULL, Coverage, active, NULL, {NO_INSURANCE}}]|2013-01-18T05:04:43-05:00|NULL |0d71e047-9cd2-ec44-4629-9b9ff78dc2c9|[{https://bluebutton.cms.gov/resources/variables/clm_id, NULL, f33e48e6-3bee-d623-daca-c94074083d1f}, {https://bluebutton.cms.gov/resources/identifier/claim-group, NULL, 99999999999}]|[{NULL, {[{1, Medical care, https://bluebutton.cms.gov/resources/variables/line_cms_type_srvc_cd}]}, NULL, [{urn:uuid:c515ad7d-f4ca-4ae1-60d9-5e6b6c9ea03d}], NULL, {[{19, Off Campus-Outpatient Hospital, http://terminology.hl7.org/CodeSystem/ex-serviceplace}]}, NULL, NULL, {[{162673000, General examination of patient (procedure), http://snomed.info/sct}], General examination of patient (procedure)}, 1, {2013-01-18T05:04:43-05:00, 2013-01-18T04:49:43-05:00}}, {[{{USD, 27.200000000000003}, {[{https://bluebutton.cms.gov/resources/variables/line_coinsrnc_amt, Line Beneficiary Coinsurance Amount, https://bluebutton.cms.gov/resources/codesystem/adjudication}]}}, {{USD, 108.80000000000001}, {[{https://bluebutton.cms.gov/resources/variables/line_prvdr_pmt_amt, Line Provider Payment Amount, https://bluebutton.cms.gov/resources/codesystem/adjudication}]}}, {{USD, 136.0}, {[{https://bluebutton.cms.gov/resources/variables/line_sbmtd_chrg_amt, Line Submitted Charge Amount, https://bluebutton.cms.gov/resources/codesystem/adjudication}]}}, {{USD, 136.0}, {[{https://bluebutton.cms.gov/resources/variables/line_alowd_chrg_amt, Line Allowed Charge Amount, https://bluebutton.cms.gov/resources/codesystem/adjudication}]}}, {{USD, 0.0}, {[{https://bluebutton.cms.gov/resources/variables/line_bene_ptb_ddctbl_amt, Line Beneficiary Part B Deductible Amount, https://bluebutton.cms.gov/resources/codesystem/adjudication}]}}, {NULL, {[{https://bluebutton.cms.gov/resources/variables/line_prcsg_ind_cd, Line Processing Indicator Code, https://bluebutton.cms.gov/resources/codesystem/adjudication}]}}], {[{1, Medical care, https://bluebutton.cms.gov/resources/variables/line_cms_type_srvc_cd}]}, NULL, NULL, [1], {[{19, Off Campus-Outpatient Hospital, http://terminology.hl7.org/CodeSystem/ex-serviceplace}]}, {USD, 136.0}, NULL, {[{140, Influenza, seasonal, injectable, preservative free, http://hl7.org/fhir/sid/cvx}], Influenza, seasonal, injectable, preservative free}, 2, {2013-01-18T05:04:43-05:00, 2013-01-18T04:49:43-05:00}}, {[{{USD, 27.200000000000003}, {[{https://bluebutton.cms.gov/resources/variables/line_coinsrnc_amt, Line Beneficiary Coinsurance Amount, https://bluebutton.cms.gov/resources/codesystem/adjudication}]}}, {{USD, 108.80000000000001}, {[{https://bluebutton.cms.gov/resources/variables/line_prvdr_pmt_amt, Line Provider Payment Amount, https://bluebutton.cms.gov/resources/codesystem/adjudication}]}}, {{USD, 136.0}, {[{https://bluebutton.cms.gov/resources/variables/line_sbmtd_chrg_amt, Line Submitted Charge Amount, https://bluebutton.cms.gov/resources/codesystem/adjudication}]}}, {{USD, 136.0}, {[{https://bluebutton.cms.gov/resources/variables/line_alowd_chrg_amt, Line Allowed Charge Amount, https://bluebutton.cms.gov/resources/codesystem/adjudication}]}}, {{USD, 0.0}, {[{https://bluebutton.cms.gov/resources/variables/line_bene_ptb_ddctbl_amt, Line Beneficiary Part B Deductible Amount, https://bluebutton.cms.gov/resources/codesystem/adjudication}]}}, {NULL, {[{https://bluebutton.cms.gov/resources/variables/line_prcsg_ind_cd, Line Processing Indicator Code, https://bluebutton.cms.gov/resources/codesystem/adjudication}]}}], {[{1, Medical care, https://bluebutton.cms.gov/resources/variables/line_cms_type_srvc_cd}]}, NULL, NULL, [2], {[{19, Off Campus-Outpatient Hospital, http://terminology.hl7.org/CodeSystem/ex-serviceplace}]}, {USD, 136.0}, NULL, {[{113, Td (adult) preservative free, http://hl7.org/fhir/sid/cvx}], Td (adult) preservative free}, 3, {2013-01-18T05:04:43-05:00, 2013-01-18T04:49:43-05:00}}, {[{{USD, 140.858}, {[{https://bluebutton.cms.gov/resources/variables/line_coinsrnc_amt, Line Beneficiary Coinsurance Amount, https://bluebutton.cms.gov/resources/codesystem/adjudication}]}}, {{USD, 563.432}, {[{https://bluebutton.cms.gov/resources/variables/line_prvdr_pmt_amt, Line Provider Payment Amount, https://bluebutton.cms.gov/resources/codesystem/adjudication}]}}, {{USD, 704.29}, {[{https://bluebutton.cms.gov/resources/variables/line_sbmtd_chrg_amt, Line Submitted Charge Amount, https://bluebutton.cms.gov/resources/codesystem/adjudication}]}}, {{USD, 704.29}, {[{https://bluebutton.cms.gov/resources/variables/line_alowd_chrg_amt, Line Allowed Charge Amount, https://bluebutton.cms.gov/resources/codesystem/adjudication}]}}, {{USD, 0.0}, {[{https://bluebutton.cms.gov/resources/variables/line_bene_ptb_ddctbl_amt, Line Beneficiary Part B Deductible Amount, https://bluebutton.cms.gov/resources/codesystem/adjudication}]}}, {NULL, {[{https://bluebutton.cms.gov/resources/variables/line_prcsg_ind_cd, Line Processing Indicator Code, https://bluebutton.cms.gov/resources/codesystem/adjudication}]}}], {[{1, Medical care, https://bluebutton.cms.gov/resources/variables/line_cms_type_srvc_cd}]}, NULL, NULL, NULL, {[{19, Off Campus-Outpatient Hospital, http://terminology.hl7.org/CodeSystem/ex-serviceplace}]}, {USD, 704.29}, NULL, {[{430193006, Medication Reconciliation (procedure), http://snomed.info/sct}], Medication Reconciliation (procedure)}, 4, {2013-01-18T05:04:43-05:00, 2013-01-18T04:49:43-05:00}}]|{{USD, 781.032}} |{NULL, Practitioner?identifier=http://hl7.org/fhir/sid/us-npi|9999999469}|[{"category":{"coding":[{"system":"http://terminology.hl7.org/CodeSystem/adjudication","code":"submitted","display":"Submitted Amount"}],"text":"Submitted Amount"},"amount":{"value":125.0,"currency":"USD"}}]|
|{2017-01-22T05:04:43-05:00, 2016-01-22T05:04:43-05:00}|[{{Practitioner?identifier=http://hl7.org/fhir/sid/us-npi|9999999469}, NULL, {[{primary, Primary Care Practitioner, http://terminology.hl7.org/CodeSystem/claimcareteamrole}]}, 1}]|{urn:uuid:4a932041-7626-8cbf-6090-5148d344fb28}|[{NULL, referral, order, NULL, [{Practitioner?identifier=http://hl7.org/fhir/sid/us-npi|9999999469}], {Practitioner?identifier=http://hl7.org/fhir/sid/us-npi|9999999469}, ServiceRequest, completed, {urn:uuid:72ac5e72-4a1d-0693-3ef9-7f47f8911a60}, NULL}, {{urn:uuid:72ac5e72-4a1d-0693-3ef9-7f47f8911a60}, coverage, NULL, [{NO_INSURANCE}], NULL, NULL, Coverage, active, NULL, {NO_INSURANCE}}]|2016-01-22T05:04:43-05:00|NULL |a4ff3f74-375c-6a13-2055-94b340b5eab5|[{https://bluebutton.cms.gov/resources/variables/clm_id, NULL, 4a932041-7626-8cbf-6090-5148d344fb28}, {https://bluebutton.cms.gov/resources/identifier/claim-group, NULL, 99999999999}]|[{NULL, {[{1, Medical care, https://bluebutton.cms.gov/resources/variables/line_cms_type_srvc_cd}]}, NULL, [{urn:uuid:9967925a-1592-669e-85de-a84c5e12b724}], NULL, {[{19, Off Campus-Outpatient Hospital, http://terminology.hl7.org/CodeSystem/ex-serviceplace}]}, NULL, NULL, {[{162673000, General examination of patient (procedure), http://snomed.info/sct}], General examination of patient (procedure)}, 1, {2016-01-22T05:04:43-05:00, 2016-01-22T04:49:43-05:00}}, {[{{USD, 27.200000000000003}, {[{https://bluebutton.cms.gov/resources/variables/line_coinsrnc_amt, Line Beneficiary Coinsurance Amount, https://bluebutton.cms.gov/resources/codesystem/adjudication}]}}, {{USD, 108.80000000000001}, {[{https://bluebutton.cms.gov/resources/variables/line_prvdr_pmt_amt, Line Provider Payment Amount, https://bluebutton.cms.gov/resources/codesystem/adjudication}]}}, {{USD, 136.0}, {[{https://bluebutton.cms.gov/resources/variables/line_sbmtd_chrg_amt, Line Submitted Charge Amount, https://bluebutton.cms.gov/resources/codesystem/adjudication}]}}, {{USD, 136.0}, {[{https://bluebutton.cms.gov/resources/variables/line_alowd_chrg_amt, Line Allowed Charge Amount, https://bluebutton.cms.gov/resources/codesystem/adjudication}]}}, {{USD, 0.0}, {[{https://bluebutton.cms.gov/resources/variables/line_bene_ptb_ddctbl_amt, Line Beneficiary Part B Deductible Amount, https://bluebutton.cms.gov/resources/codesystem/adjudication}]}}, {NULL, {[{https://bluebutton.cms.gov/resources/variables/line_prcsg_ind_cd, Line Processing Indicator Code, https://bluebutton.cms.gov/resources/codesystem/adjudication}]}}], {[{1, Medical care, https://bluebutton.cms.gov/resources/variables/line_cms_type_srvc_cd}]}, NULL, NULL, [1], {[{19, Off Campus-Outpatient Hospital, http://terminology.hl7.org/CodeSystem/ex-serviceplace}]}, {USD, 136.0}, NULL, {[{140, Influenza, seasonal, injectable, preservative free, http://hl7.org/fhir/sid/cvx}], Influenza, seasonal, injectable, preservative free}, 2, {2016-01-22T05:04:43-05:00, 2016-01-22T04:49:43-05:00}}] |{{USD, 108.80000000000001}}|{NULL, Practitioner?identifier=http://hl7.org/fhir/sid/us-npi|9999999469}|[{"category":{"coding":[{"system":"http://terminology.hl7.org/CodeSystem/adjudication","code":"submitted","display":"Submitted Amount"}],"text":"Submitted Amount"},"amount":{"value":125.0,"currency":"USD"}}]|
|{2019-11-15T05:49:43-05:00, 2018-11-15T05:49:43-05:00}|[{{Practitioner?identifier=http://hl7.org/fhir/sid/us-npi|9999999279}, NULL, {[{primary, Primary Care Practitioner, http://terminology.hl7.org/CodeSystem/claimcareteamrole}]}, 1}]|{urn:uuid:2ba5c308-e4a8-ae48-b16d-fcfd949a6883}|[{NULL, referral, order, NULL, [{Practitioner?identifier=http://hl7.org/fhir/sid/us-npi|9999999279}], {Practitioner?identifier=http://hl7.org/fhir/sid/us-npi|9999999279}, ServiceRequest, completed, {urn:uuid:72ac5e72-4a1d-0693-3ef9-7f47f8911a60}, NULL}, {{urn:uuid:72ac5e72-4a1d-0693-3ef9-7f47f8911a60}, coverage, NULL, [{NO_INSURANCE}], NULL, NULL, Coverage, active, NULL, {NO_INSURANCE}}]|2018-11-15T05:49:43-05:00|[{{urn:uuid:f28c617a-40dd-4901-3add-1637dba5b3c2}, 1, [{[{principal, http://terminology.hl7.org/CodeSystem/ex-diagnosistype}]}]}] |130fbfcf-c4e8-95ee-7208-99f234b81ff3|[{https://bluebutton.cms.gov/resources/variables/clm_id, NULL, 2ba5c308-e4a8-ae48-b16d-fcfd949a6883}, {https://bluebutton.cms.gov/resources/identifier/claim-group, NULL, 99999999999}]|[{NULL, {[{1, Medical care, https://bluebutton.cms.gov/resources/variables/line_cms_type_srvc_cd}]}, NULL, [{urn:uuid:e3ba0c81-2fa0-aa88-1cca-9d3610d96d6d}], NULL, {[{20, Urgent Care Facility, http://terminology.hl7.org/CodeSystem/ex-serviceplace}]}, NULL, NULL, {[{50849002, Emergency room admission (procedure), http://snomed.info/sct}], Emergency room admission (procedure)}, 1, {2018-11-15T05:49:43-05:00, 2018-11-15T04:49:43-05:00}}, {NULL, {[{1, Medical care, https://bluebutton.cms.gov/resources/variables/line_cms_type_srvc_cd}]}, [1], NULL, NULL, {[{20, Urgent Care Facility, http://terminology.hl7.org/CodeSystem/ex-serviceplace}]}, NULL, NULL, {[{283371005, Laceration of forearm, http://snomed.info/sct}], Laceration of forearm}, 2, {2018-11-15T05:49:43-05:00, 2018-11-15T04:49:43-05:00}}, {[{{USD, 2569.126}, {[{https://bluebutton.cms.gov/resources/variables/line_coinsrnc_amt, Line Beneficiary Coinsurance Amount, https://bluebutton.cms.gov/resources/codesystem/adjudication}]}}, {{USD, 10276.504}, {[{https://bluebutton.cms.gov/resources/variables/line_prvdr_pmt_amt, Line Provider Payment Amount, https://bluebutton.cms.gov/resources/codesystem/adjudication}]}}, {{USD, 12845.63}, {[{https://bluebutton.cms.gov/resources/variables/line_sbmtd_chrg_amt, Line Submitted Charge Amount, https://bluebutton.cms.gov/resources/codesystem/adjudication}]}}, {{USD, 12845.63}, {[{https://bluebutton.cms.gov/resources/variables/line_alowd_chrg_amt, Line Allowed Charge Amount, https://bluebutton.cms.gov/resources/codesystem/adjudication}]}}, {{USD, 0.0}, {[{https://bluebutton.cms.gov/resources/variables/line_bene_ptb_ddctbl_amt, Line Beneficiary Part B Deductible Amount, https://bluebutton.cms.gov/resources/codesystem/adjudication}]}}, {NULL, {[{https://bluebutton.cms.gov/resources/variables/line_prcsg_ind_cd, Line Processing Indicator Code, https://bluebutton.cms.gov/resources/codesystem/adjudication}]}}], {[{1, Medical care, https://bluebutton.cms.gov/resources/variables/line_cms_type_srvc_cd}]}, NULL, NULL, NULL, {[{20, Urgent Care Facility, http://terminology.hl7.org/CodeSystem/ex-serviceplace}]}, {USD, 12845.63}, NULL, {[{288086009, Suture open wound, http://snomed.info/sct}], Suture open wound}, 3, {2018-11-15T05:49:43-05:00, 2018-11-15T04:49:43-05:00}}] |{{USD, 10276.504}} |{NULL, Practitioner?identifier=http://hl7.org/fhir/sid/us-npi|9999999279}|[{"category":{"coding":[{"system":"http://terminology.hl7.org/CodeSystem/adjudication","code":"submitted","display":"Submitted Amount"}],"text":"Submitted Amount"},"amount":{"value":125.0,"currency":"USD"}}]|
|{2020-01-25T05:04:43-05:00, 2019-01-25T05:04:43-05:00}|[{{Practitioner?identifier=http://hl7.org/fhir/sid/us-npi|9999999469}, NULL, {[{primary, Primary Care Practitioner, http://terminology.hl7.org/CodeSystem/claimcareteamrole}]}, 1}]|{urn:uuid:93afe0c6-de34-ec38-0346-7b464dd2bda0}|[{NULL, referral, order, NULL, [{Practitioner?identifier=http://hl7.org/fhir/sid/us-npi|9999999469}], {Practitioner?identifier=http://hl7.org/fhir/sid/us-npi|9999999469}, ServiceRequest, completed, {urn:uuid:72ac5e72-4a1d-0693-3ef9-7f47f8911a60}, NULL}, {{urn:uuid:72ac5e72-4a1d-0693-3ef9-7f47f8911a60}, coverage, NULL, [{NO_INSURANCE}], NULL, NULL, Coverage, active, NULL, {NO_INSURANCE}}]|2019-01-25T05:04:43-05:00|NULL |bafc4a70-ed60-54a7-f077-9b72b507bfdc|[{https://bluebutton.cms.gov/resources/variables/clm_id, NULL, 93afe0c6-de34-ec38-0346-7b464dd2bda0}, {https://bluebutton.cms.gov/resources/identifier/claim-group, NULL, 99999999999}]|[{NULL, {[{1, Medical care, https://bluebutton.cms.gov/resources/variables/line_cms_type_srvc_cd}]}, NULL, [{urn:uuid:9f9c2423-aa6c-c928-a38e-b0efd2d6b6c6}], NULL, {[{19, Off Campus-Outpatient Hospital, http://terminology.hl7.org/CodeSystem/ex-serviceplace}]}, NULL, NULL, {[{162673000, General examination of patient (procedure), http://snomed.info/sct}], General examination of patient (procedure)}, 1, {2019-01-25T05:04:43-05:00, 2019-01-25T04:49:43-05:00}}, {[{{USD, 27.200000000000003}, {[{https://bluebutton.cms.gov/resources/variables/line_coinsrnc_amt, Line Beneficiary Coinsurance Amount, https://bluebutton.cms.gov/resources/codesystem/adjudication}]}}, {{USD, 108.80000000000001}, {[{https://bluebutton.cms.gov/resources/variables/line_prvdr_pmt_amt, Line Provider Payment Amount, https://bluebutton.cms.gov/resources/codesystem/adjudication}]}}, {{USD, 136.0}, {[{https://bluebutton.cms.gov/resources/variables/line_sbmtd_chrg_amt, Line Submitted Charge Amount, https://bluebutton.cms.gov/resources/codesystem/adjudication}]}}, {{USD, 136.0}, {[{https://bluebutton.cms.gov/resources/variables/line_alowd_chrg_amt, Line Allowed Charge Amount, https://bluebutton.cms.gov/resources/codesystem/adjudication}]}}, {{USD, 0.0}, {[{https://bluebutton.cms.gov/resources/variables/line_bene_ptb_ddctbl_amt, Line Beneficiary Part B Deductible Amount, https://bluebutton.cms.gov/resources/codesystem/adjudication}]}}, {NULL, {[{https://bluebutton.cms.gov/resources/variables/line_prcsg_ind_cd, Line Processing Indicator Code, https://bluebutton.cms.gov/resources/codesystem/adjudication}]}}], {[{1, Medical care, https://bluebutton.cms.gov/resources/variables/line_cms_type_srvc_cd}]}, NULL, NULL, [1], {[{19, Off Campus-Outpatient Hospital, http://terminology.hl7.org/CodeSystem/ex-serviceplace}]}, {USD, 136.0}, NULL, {[{140, Influenza, seasonal, injectable, preservative free, http://hl7.org/fhir/sid/cvx}], Influenza, seasonal, injectable, preservative free}, 2, {2019-01-25T05:04:43-05:00, 2019-01-25T04:49:43-05:00}}] |{{USD, 108.80000000000001}}|{NULL, Practitioner?identifier=http://hl7.org/fhir/sid/us-npi|9999999469}|[{"category":{"coding":[{"system":"http://terminology.hl7.org/CodeSystem/adjudication","code":"submitted","display":"Submitted Amount"}],"text":"Submitted Amount"},"amount":{"value":125.0,"currency":"USD"}}]|
|{2020-04-06T01:04:43-04:00, 2019-04-06T01:04:43-04:00}|[{{Practitioner?identifier=http://hl7.org/fhir/sid/us-npi|9999999969}, NULL, {[{primary, Primary Care Practitioner, http://terminology.hl7.org/CodeSystem/claimcareteamrole}]}, 1}]|{urn:uuid:b8fbb450-058f-aaf1-dec0-0a9a216d09d9}|[{NULL, referral, order, NULL, [{Practitioner?identifier=http://hl7.org/fhir/sid/us-npi|9999999969}], {Practitioner?identifier=http://hl7.org/fhir/sid/us-npi|9999999969}, ServiceRequest, completed, {urn:uuid:72ac5e72-4a1d-0693-3ef9-7f47f8911a60}, NULL}, {{urn:uuid:72ac5e72-4a1d-0693-3ef9-7f47f8911a60}, coverage, NULL, [{NO_INSURANCE}], NULL, NULL, Coverage, active, NULL, {NO_INSURANCE}}]|2019-04-06T01:04:43-04:00|[{{urn:uuid:21342b68-3691-34b6-6907-3db6605e26b8}, 1, [{[{principal, http://terminology.hl7.org/CodeSystem/ex-diagnosistype}]}]}] |a8668318-0ff5-9011-16f4-b5d084d570a2|[{https://bluebutton.cms.gov/resources/variables/clm_id, NULL, b8fbb450-058f-aaf1-dec0-0a9a216d09d9}, {https://bluebutton.cms.gov/resources/identifier/claim-group, NULL, 99999999999}]|[{NULL, {[{1, Medical care, https://bluebutton.cms.gov/resources/variables/line_cms_type_srvc_cd}]}, NULL, [{urn:uuid:68e07371-1e5b-8140-2a9a-91eb1b096df6}], NULL, {[{21, Inpatient Hospital, http://terminology.hl7.org/CodeSystem/ex-serviceplace}]}, NULL, NULL, {[{185345009, Encounter for symptom, http://snomed.info/sct}], Encounter for symptom}, 1, {2019-04-06T01:04:43-04:00, 2019-04-06T00:49:43-04:00}}, {NULL, {[{1, Medical care, https://bluebutton.cms.gov/resources/variables/line_cms_type_srvc_cd}]}, [1], NULL, NULL, {[{21, Inpatient Hospital, http://terminology.hl7.org/CodeSystem/ex-serviceplace}]}, NULL, NULL, {[{444814009, Viral sinusitis (disorder), http://snomed.info/sct}], Viral sinusitis (disorder)}, 2, {2019-04-06T01:04:43-04:00, 2019-04-06T00:49:43-04:00}}] |{{USD, 0.0}} |{NULL, Practitioner?identifier=http://hl7.org/fhir/sid/us-npi|9999999969}|[{"category":{"coding":[{"system":"http://terminology.hl7.org/CodeSystem/adjudication","code":"submitted","display":"Submitted Amount"}],"text":"Submitted Amount"},"amount":{"value":75.0,"currency":"USD"}}] |
|{2021-03-14T07:15:22-04:00, 2020-03-14T07:15:22-04:00}|[{{Practitioner?identifier=http://hl7.org/fhir/sid/us-npi|9999999969}, NULL, {[{primary, Primary Care Practitioner, http://terminology.hl7.org/CodeSystem/claimcareteamrole}]}, 1}]|{urn:uuid:6e197383-1fb9-d998-57ff-12a9d0a7ad19}|[{NULL, referral, order, NULL, [{Practitioner?identifier=http://hl7.org/fhir/sid/us-npi|9999999969}], {Practitioner?identifier=http://hl7.org/fhir/sid/us-npi|9999999969}, ServiceRequest, completed, {urn:uuid:72ac5e72-4a1d-0693-3ef9-7f47f8911a60}, NULL}, {{urn:uuid:72ac5e72-4a1d-0693-3ef9-7f47f8911a60}, coverage, NULL, [{NO_INSURANCE}], NULL, NULL, Coverage, active, NULL, {NO_INSURANCE}}]|2020-03-14T07:15:22-04:00|[{{urn:uuid:8fab10ec-dac2-4c6f-d493-a657620511c8}, 1, [{[{principal, http://terminology.hl7.org/CodeSystem/ex-diagnosistype}]}]}, {{urn:uuid:e0f39f3e-89bb-9fac-e3b0-a52d04540bd8}, 2, [{[{principal, http://terminology.hl7.org/CodeSystem/ex-diagnosistype}]}]}, {{urn:uuid:fd983be3-2818-a190-4936-358cac2649fd}, 3, [{[{principal, http://terminology.hl7.org/CodeSystem/ex-diagnosistype}]}]}, {{urn:uuid:722026e8-fb6d-4150-981d-bc3d524a7db9}, 4, [{[{principal, http://terminology.hl7.org/CodeSystem/ex-diagnosistype}]}]}, {{urn:uuid:be90f10a-d414-d5b3-71ce-4fede87c7537}, 5, [{[{principal, http://terminology.hl7.org/CodeSystem/ex-diagnosistype}]}]}, {{urn:uuid:b81954ff-53a2-1dd1-d12d-24b0b6dd13b0}, 6, [{[{principal, http://terminology.hl7.org/CodeSystem/ex-diagnosistype}]}]}, {{urn:uuid:d27fd20c-6848-0a1e-8284-baa94346ec0f}, 7, [{[{principal, http://terminology.hl7.org/CodeSystem/ex-diagnosistype}]}]}]|7029ff8d-f06b-a448-8351-a7a93a79d482|[{https://bluebutton.cms.gov/resources/variables/clm_id, NULL, 6e197383-1fb9-d998-57ff-12a9d0a7ad19}, {https://bluebutton.cms.gov/resources/identifier/claim-group, NULL, 99999999999}]|[{NULL, {[{1, Medical care, https://bluebutton.cms.gov/resources/variables/line_cms_type_srvc_cd}]}, NULL, [{urn:uuid:eba0f573-2988-e3b1-9ba0-29fc5d32ccd4}], NULL, {[{21, Inpatient Hospital, http://terminology.hl7.org/CodeSystem/ex-serviceplace}]}, NULL, NULL, {[{185345009, Encounter for symptom (procedure), http://snomed.info/sct}], Encounter for symptom (procedure)}, 1, {2020-03-14T07:15:22-04:00, 2020-03-14T05:49:43-04:00}}, {NULL, {[{1, Medical care, https://bluebutton.cms.gov/resources/variables/line_cms_type_srvc_cd}]}, [1], NULL, NULL, {[{21, Inpatient Hospital, http://terminology.hl7.org/CodeSystem/ex-serviceplace}]}, NULL, NULL, {[{49727002, Cough (finding), http://snomed.info/sct}], Cough (finding)}, 2, {2020-03-14T07:15:22-04:00, 2020-03-14T05:49:43-04:00}}, {NULL, {[{1, Medical care, https://bluebutton.cms.gov/resources/variables/line_cms_type_srvc_cd}]}, [2], NULL, NULL, {[{21, Inpatient Hospital, http://terminology.hl7.org/CodeSystem/ex-serviceplace}]}, NULL, NULL, {[{267036007, Dyspnea (finding), http://snomed.info/sct}], Dyspnea (finding)}, 3, {2020-03-14T07:15:22-04:00, 2020-03-14T05:49:43-04:00}}, {NULL, {[{1, Medical care, https://bluebutton.cms.gov/resources/variables/line_cms_type_srvc_cd}]}, [3], NULL, NULL, {[{21, Inpatient Hospital, http://terminology.hl7.org/CodeSystem/ex-serviceplace}]}, NULL, NULL, {[{56018004, Wheezing (finding), http://snomed.info/sct}], Wheezing (finding)}, 4, {2020-03-14T07:15:22-04:00, 2020-03-14T05:49:43-04:00}}, {NULL, {[{1, Medical care, https://bluebutton.cms.gov/resources/variables/line_cms_type_srvc_cd}]}, [4], NULL, NULL, {[{21, Inpatient Hospital, http://terminology.hl7.org/CodeSystem/ex-serviceplace}]}, NULL, NULL, {[{386661006, Fever (finding), http://snomed.info/sct}], Fever (finding)}, 5, {2020-03-14T07:15:22-04:00, 2020-03-14T05:49:43-04:00}}, {NULL, {[{1, Medical care, https://bluebutton.cms.gov/resources/variables/line_cms_type_srvc_cd}]}, [5], NULL, NULL, {[{21, Inpatient Hospital, http://terminology.hl7.org/CodeSystem/ex-serviceplace}]}, NULL, NULL, {[{36955009, Loss of taste (finding), http://snomed.info/sct}], Loss of taste (finding)}, 6, {2020-03-14T07:15:22-04:00, 2020-03-14T05:49:43-04:00}}, {NULL, {[{1, Medical care, https://bluebutton.cms.gov/resources/variables/line_cms_type_srvc_cd}]}, [6], NULL, NULL, {[{21, Inpatient Hospital, http://terminology.hl7.org/CodeSystem/ex-serviceplace}]}, NULL, NULL, {[{840544004, Suspected COVID-19, http://snomed.info/sct}], Suspected COVID-19}, 7, {2020-03-14T07:15:22-04:00, 2020-03-14T05:49:43-04:00}}, {[{{USD, 0.394}, {[{https://bluebutton.cms.gov/resources/variables/line_coinsrnc_amt, Line Beneficiary Coinsurance Amount, https://bluebutton.cms.gov/resources/codesystem/adjudication}]}}, {{USD, 1.576}, {[{https://bluebutton.cms.gov/resources/variables/line_prvdr_pmt_amt, Line Provider Payment Amount, https://bluebutton.cms.gov/resources/codesystem/adjudication}]}}, {{USD, 1.97}, {[{https://bluebutton.cms.gov/resources/variables/line_sbmtd_chrg_amt, Line Submitted Charge Amount, https://bluebutton.cms.gov/resources/codesystem/adjudication}]}}, {{USD, 1.97}, {[{https://bluebutton.cms.gov/resources/variables/line_alowd_chrg_amt, Line Allowed Charge Amount, https://bluebutton.cms.gov/resources/codesystem/adjudication}]}}, {{USD, 0.0}, {[{https://bluebutton.cms.gov/resources/variables/line_bene_ptb_ddctbl_amt, Line Beneficiary Part B Deductible Amount, https://bluebutton.cms.gov/resources/codesystem/adjudication}]}}, {NULL, {[{https://bluebutton.cms.gov/resources/variables/line_prcsg_ind_cd, Line Processing Indicator Code, https://bluebutton.cms.gov/resources/codesystem/adjudication}]}}], {[{1, Medical care, https://bluebutton.cms.gov/resources/variables/line_cms_type_srvc_cd}]}, NULL, NULL, NULL, {[{21, Inpatient Hospital, http://terminology.hl7.org/CodeSystem/ex-serviceplace}]}, {USD, 1.97}, NULL, {[{261352009, Face mask (physical object), http://snomed.info/sct}], Face mask (physical object)}, 8, {2020-03-14T07:15:22-04:00, 2020-03-14T05:49:43-04:00}}, {NULL, {[{1, Medical care, https://bluebutton.cms.gov/resources/variables/line_cms_type_srvc_cd}]}, [7], NULL, NULL, {[{21, Inpatient Hospital, http://terminology.hl7.org/CodeSystem/ex-serviceplace}]}, NULL, NULL, {[{840539006, COVID-19, http://snomed.info/sct}], COVID-19}, 9, {2020-03-14T07:15:22-04:00, 2020-03-14T05:49:43-04:00}}] |{{USD, 1.576}} |{NULL, Practitioner?identifier=http://hl7.org/fhir/sid/us-npi|9999999969}|[{"category":{"coding":[{"system":"http://terminology.hl7.org/CodeSystem/adjudication","code":"submitted","display":"Submitted Amount"}],"text":"Submitted Amount"},"amount":{"value":75.0,"currency":"USD"}}] |
+------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------+-------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
Resource: Immunization
All Columns: ['abatementDateTime', 'activity', 'address', 'addresses', 'authoredOn', 'billablePeriod', 'birthDate', 'careTeam', 'category', 'claim', 'class', 'clinicalStatus', 'code', 'communication', 'component', 'contained', 'created', 'diagnosis', 'dosageInstruction', 'effectiveDateTime', 'encounter', 'extension', 'gender', 'id', 'identifier', 'insurance', 'insurer', 'intent', 'issued', 'item', 'managingOrganization', 'maritalStatus', 'medicationCodeableConcept', 'multipleBirthBoolean', 'name', 'occurrenceDateTime', 'onsetDateTime', 'outcome', 'participant', 'patient', 'payment', 'performedPeriod', 'period', 'prescription', 'primarySource', 'priority', 'procedure', 'provider', 'reasonCode', 'reasonReference', 'recordedDate', 'referral', 'requester', 'resourceType', 'result', 'serviceProvider', 'status', 'subject', 'supportingInfo', 'telecom', 'text', 'total', 'type', 'use', 'vaccineCode', 'valueCodeableConcept', 'valueQuantity', 'verificationStatus']
Non-Null Columns: ['encounter', 'id', 'occurrenceDateTime', 'vaccineCode']
DataFrame with Non-Null Columns for Immunization:
+-----------------------------------------------+------------------------------------+-------------------------+----------------------------------------------------------------------------------------------------------------------------------------------+
|encounter |id |occurrenceDateTime |vaccineCode |
+-----------------------------------------------+------------------------------------+-------------------------+----------------------------------------------------------------------------------------------------------------------------------------------+
|{urn:uuid:c515ad7d-f4ca-4ae1-60d9-5e6b6c9ea03d}|e0fdb1f3-fe95-c34d-33c7-9e82c6313d66|2013-01-18T04:49:43-05:00|{[{140, Influenza, seasonal, injectable, preservative free, http://hl7.org/fhir/sid/cvx}], Influenza, seasonal, injectable, preservative free}|
|{urn:uuid:c515ad7d-f4ca-4ae1-60d9-5e6b6c9ea03d}|39dd3e30-998f-cc47-759f-facc12518d1b|2013-01-18T04:49:43-05:00|{[{113, Td (adult) preservative free, http://hl7.org/fhir/sid/cvx}], Td (adult) preservative free} |
|{urn:uuid:9967925a-1592-669e-85de-a84c5e12b724}|286689a1-2d0b-9d28-1243-b6961ac5bb70|2016-01-22T04:49:43-05:00|{[{140, Influenza, seasonal, injectable, preservative free, http://hl7.org/fhir/sid/cvx}], Influenza, seasonal, injectable, preservative free}|
|{urn:uuid:9f9c2423-aa6c-c928-a38e-b0efd2d6b6c6}|74881a15-1bf5-86b5-126b-a7f4b96a1e2f|2019-01-25T04:49:43-05:00|{[{140, Influenza, seasonal, injectable, preservative free, http://hl7.org/fhir/sid/cvx}], Influenza, seasonal, injectable, preservative free}|
+-----------------------------------------------+------------------------------------+-------------------------+----------------------------------------------------------------------------------------------------------------------------------------------+
Resource: MedicationRequest
All Columns: ['abatementDateTime', 'activity', 'address', 'addresses', 'authoredOn', 'billablePeriod', 'birthDate', 'careTeam', 'category', 'claim', 'class', 'clinicalStatus', 'code', 'communication', 'component', 'contained', 'created', 'diagnosis', 'dosageInstruction', 'effectiveDateTime', 'encounter', 'extension', 'gender', 'id', 'identifier', 'insurance', 'insurer', 'intent', 'issued', 'item', 'managingOrganization', 'maritalStatus', 'medicationCodeableConcept', 'multipleBirthBoolean', 'name', 'occurrenceDateTime', 'onsetDateTime', 'outcome', 'participant', 'patient', 'payment', 'performedPeriod', 'period', 'prescription', 'primarySource', 'priority', 'procedure', 'provider', 'reasonCode', 'reasonReference', 'recordedDate', 'referral', 'requester', 'resourceType', 'result', 'serviceProvider', 'status', 'subject', 'supportingInfo', 'telecom', 'text', 'total', 'type', 'use', 'vaccineCode', 'valueCodeableConcept', 'valueQuantity', 'verificationStatus']
Non-Null Columns: []
DataFrame with Non-Null Columns for MedicationRequest:
++
||
++
||
++
Resource: Observation
All Columns: ['abatementDateTime', 'activity', 'address', 'addresses', 'authoredOn', 'billablePeriod', 'birthDate', 'careTeam', 'category', 'claim', 'class', 'clinicalStatus', 'code', 'communication', 'component', 'contained', 'created', 'diagnosis', 'dosageInstruction', 'effectiveDateTime', 'encounter', 'extension', 'gender', 'id', 'identifier', 'insurance', 'insurer', 'intent', 'issued', 'item', 'managingOrganization', 'maritalStatus', 'medicationCodeableConcept', 'multipleBirthBoolean', 'name', 'occurrenceDateTime', 'onsetDateTime', 'outcome', 'participant', 'patient', 'payment', 'performedPeriod', 'period', 'prescription', 'primarySource', 'priority', 'procedure', 'provider', 'reasonCode', 'reasonReference', 'recordedDate', 'referral', 'requester', 'resourceType', 'result', 'serviceProvider', 'status', 'subject', 'supportingInfo', 'telecom', 'text', 'total', 'type', 'use', 'vaccineCode', 'valueCodeableConcept', 'valueQuantity', 'verificationStatus']
Non-Null Columns: ['category', 'code', 'component', 'effectiveDateTime', 'encounter', 'id', 'issued', 'valueCodeableConcept', 'valueQuantity']
DataFrame with Non-Null Columns for Observation:
+--------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------+-----------------------------------------------+------------------------------------+-----------------------------+-------------------------------------------------------------------+--------------------------------------------------+
|category |code |component |effectiveDateTime |encounter |id |issued |valueCodeableConcept |valueQuantity |
+--------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------+-----------------------------------------------+------------------------------------+-----------------------------+-------------------------------------------------------------------+--------------------------------------------------+
|[{[{vital-signs, vital-signs, http://terminology.hl7.org/CodeSystem/observation-category}], NULL}]|{[{8302-2, Body Height, http://loinc.org}], Body Height} |NULL |2013-01-18T04:49:43-05:00|{urn:uuid:c515ad7d-f4ca-4ae1-60d9-5e6b6c9ea03d}|0b35532b-c0ee-fb37-26ee-828696445d07|2013-01-18T04:49:43.140-05:00|NULL |{cm, http://unitsofmeasure.org, cm, 167.2} |
|[{[{vital-signs, vital-signs, http://terminology.hl7.org/CodeSystem/observation-category}], NULL}]|{[{72514-3, Pain severity - 0-10 verbal numeric rating [Score] - Reported, http://loinc.org}], Pain severity - 0-10 verbal numeric rating [Score] - Reported}|NULL |2013-01-18T04:49:43-05:00|{urn:uuid:c515ad7d-f4ca-4ae1-60d9-5e6b6c9ea03d}|b388acd6-dda5-7b3a-d2bf-5f548bb4a587|2013-01-18T04:49:43.140-05:00|NULL |{{score}, http://unitsofmeasure.org, {score}, 2.0}|
|[{[{vital-signs, vital-signs, http://terminology.hl7.org/CodeSystem/observation-category}], NULL}]|{[{29463-7, Body Weight, http://loinc.org}], Body Weight} |NULL |2013-01-18T04:49:43-05:00|{urn:uuid:c515ad7d-f4ca-4ae1-60d9-5e6b6c9ea03d}|d5d57135-e689-b5fc-337e-77e22e731312|2013-01-18T04:49:43.140-05:00|NULL |{kg, http://unitsofmeasure.org, kg, 69.6} |
|[{[{vital-signs, vital-signs, http://terminology.hl7.org/CodeSystem/observation-category}], NULL}]|{[{39156-5, Body Mass Index, http://loinc.org}], Body Mass Index} |NULL |2013-01-18T04:49:43-05:00|{urn:uuid:c515ad7d-f4ca-4ae1-60d9-5e6b6c9ea03d}|547564ba-c490-77a2-2f99-565a36da5ad0|2013-01-18T04:49:43.140-05:00|NULL |{kg/m2, http://unitsofmeasure.org, kg/m2, 24.9} |
|[{[{vital-signs, vital-signs, http://terminology.hl7.org/CodeSystem/observation-category}], NULL}]|{[{85354-9, Blood Pressure, http://loinc.org}], Blood Pressure} |[{{[{8462-4, Diastolic Blood Pressure, http://loinc.org}], Diastolic Blood Pressure}, {mm[Hg], http://unitsofmeasure.org, mm[Hg], 82}}, {{[{8480-6, Systolic Blood Pressure, http://loinc.org}], Systolic Blood Pressure}, {mm[Hg], http://unitsofmeasure.org, mm[Hg], 123}}]|2013-01-18T04:49:43-05:00|{urn:uuid:c515ad7d-f4ca-4ae1-60d9-5e6b6c9ea03d}|8bf77029-5857-026b-a02c-96bcdc129457|2013-01-18T04:49:43.140-05:00|NULL |NULL |
|[{[{vital-signs, vital-signs, http://terminology.hl7.org/CodeSystem/observation-category}], NULL}]|{[{8867-4, Heart rate, http://loinc.org}], Heart rate} |NULL |2013-01-18T04:49:43-05:00|{urn:uuid:c515ad7d-f4ca-4ae1-60d9-5e6b6c9ea03d}|71a30c67-ca68-6ff1-76a1-68d1bfd2c696|2013-01-18T04:49:43.140-05:00|NULL |{/min, http://unitsofmeasure.org, /min, 94.0} |
|[{[{vital-signs, vital-signs, http://terminology.hl7.org/CodeSystem/observation-category}], NULL}]|{[{9279-1, Respiratory rate, http://loinc.org}], Respiratory rate} |NULL |2013-01-18T04:49:43-05:00|{urn:uuid:c515ad7d-f4ca-4ae1-60d9-5e6b6c9ea03d}|73a6179b-f2a1-62af-714c-bd5b9cb3def4|2013-01-18T04:49:43.140-05:00|NULL |{/min, http://unitsofmeasure.org, /min, 12.0} |
|[{[{laboratory, laboratory, http://terminology.hl7.org/CodeSystem/observation-category}], NULL}] |{[{2093-3, Total Cholesterol, http://loinc.org}], Total Cholesterol} |NULL |2013-01-18T04:49:43-05:00|{urn:uuid:c515ad7d-f4ca-4ae1-60d9-5e6b6c9ea03d}|49a26773-135e-cbc2-1cb7-928ad99976b8|2013-01-18T04:49:43.140-05:00|NULL |{mg/dL, http://unitsofmeasure.org, mg/dL, 191.4} |
|[{[{laboratory, laboratory, http://terminology.hl7.org/CodeSystem/observation-category}], NULL}] |{[{2571-8, Triglycerides, http://loinc.org}], Triglycerides} |NULL |2013-01-18T04:49:43-05:00|{urn:uuid:c515ad7d-f4ca-4ae1-60d9-5e6b6c9ea03d}|89d1acbd-bcac-c8f3-cdbb-13b49e170aaa|2013-01-18T04:49:43.140-05:00|NULL |{mg/dL, http://unitsofmeasure.org, mg/dL, 130.86} |
|[{[{laboratory, laboratory, http://terminology.hl7.org/CodeSystem/observation-category}], NULL}] |{[{18262-6, Low Density Lipoprotein Cholesterol, http://loinc.org}], Low Density Lipoprotein Cholesterol} |NULL |2013-01-18T04:49:43-05:00|{urn:uuid:c515ad7d-f4ca-4ae1-60d9-5e6b6c9ea03d}|cb4b7c43-4b76-def5-cc12-804488fe88fb|2013-01-18T04:49:43.140-05:00|NULL |{mg/dL, http://unitsofmeasure.org, mg/dL, 89.86} |
|[{[{laboratory, laboratory, http://terminology.hl7.org/CodeSystem/observation-category}], NULL}] |{[{2085-9, High Density Lipoprotein Cholesterol, http://loinc.org}], High Density Lipoprotein Cholesterol} |NULL |2013-01-18T04:49:43-05:00|{urn:uuid:c515ad7d-f4ca-4ae1-60d9-5e6b6c9ea03d}|fa6290cf-e10b-13ea-68b0-0df315af5961|2013-01-18T04:49:43.140-05:00|NULL |{mg/dL, http://unitsofmeasure.org, mg/dL, 75.37} |
|[{[{survey, survey, http://terminology.hl7.org/CodeSystem/observation-category}], NULL}] |{[{72166-2, Tobacco smoking status NHIS, http://loinc.org}], Tobacco smoking status NHIS} |NULL |2013-01-18T04:49:43-05:00|{urn:uuid:c515ad7d-f4ca-4ae1-60d9-5e6b6c9ea03d}|35cb9a93-6455-ae2b-0641-3a34cc8b4386|2013-01-18T04:49:43.140-05:00|{[{266919005, Never smoker, http://snomed.info/sct}], Never smoker}|NULL |
|[{[{vital-signs, vital-signs, http://terminology.hl7.org/CodeSystem/observation-category}], NULL}]|{[{8302-2, Body Height, http://loinc.org}], Body Height} |NULL |2016-01-22T04:49:43-05:00|{urn:uuid:9967925a-1592-669e-85de-a84c5e12b724}|39416000-70a4-06bb-3754-cd0547555d58|2016-01-22T04:49:43.140-05:00|NULL |{cm, http://unitsofmeasure.org, cm, 167.2} |
|[{[{vital-signs, vital-signs, http://terminology.hl7.org/CodeSystem/observation-category}], NULL}]|{[{72514-3, Pain severity - 0-10 verbal numeric rating [Score] - Reported, http://loinc.org}], Pain severity - 0-10 verbal numeric rating [Score] - Reported}|NULL |2016-01-22T04:49:43-05:00|{urn:uuid:9967925a-1592-669e-85de-a84c5e12b724}|a43941b2-6b86-767d-85ef-1e9e7e7db743|2016-01-22T04:49:43.140-05:00|NULL |{{score}, http://unitsofmeasure.org, {score}, 3.0}|
|[{[{vital-signs, vital-signs, http://terminology.hl7.org/CodeSystem/observation-category}], NULL}]|{[{29463-7, Body Weight, http://loinc.org}], Body Weight} |NULL |2016-01-22T04:49:43-05:00|{urn:uuid:9967925a-1592-669e-85de-a84c5e12b724}|aeb6874d-8b62-8d62-510b-7ef250e09655|2016-01-22T04:49:43.140-05:00|NULL |{kg, http://unitsofmeasure.org, kg, 74.6} |
|[{[{vital-signs, vital-signs, http://terminology.hl7.org/CodeSystem/observation-category}], NULL}]|{[{39156-5, Body Mass Index, http://loinc.org}], Body Mass Index} |NULL |2016-01-22T04:49:43-05:00|{urn:uuid:9967925a-1592-669e-85de-a84c5e12b724}|c6b8e128-f736-2608-d9c4-1e17976856bb|2016-01-22T04:49:43.140-05:00|NULL |{kg/m2, http://unitsofmeasure.org, kg/m2, 26.69} |
|[{[{vital-signs, vital-signs, http://terminology.hl7.org/CodeSystem/observation-category}], NULL}]|{[{85354-9, Blood Pressure, http://loinc.org}], Blood Pressure} |[{{[{8462-4, Diastolic Blood Pressure, http://loinc.org}], Diastolic Blood Pressure}, {mm[Hg], http://unitsofmeasure.org, mm[Hg], 81}}, {{[{8480-6, Systolic Blood Pressure, http://loinc.org}], Systolic Blood Pressure}, {mm[Hg], http://unitsofmeasure.org, mm[Hg], 110}}]|2016-01-22T04:49:43-05:00|{urn:uuid:9967925a-1592-669e-85de-a84c5e12b724}|cac26665-e898-47f3-7cab-5ad51a2ba8bf|2016-01-22T04:49:43.140-05:00|NULL |NULL |
|[{[{vital-signs, vital-signs, http://terminology.hl7.org/CodeSystem/observation-category}], NULL}]|{[{8867-4, Heart rate, http://loinc.org}], Heart rate} |NULL |2016-01-22T04:49:43-05:00|{urn:uuid:9967925a-1592-669e-85de-a84c5e12b724}|4a2b2c8b-3def-a98e-3f80-b6513b5d0c6d|2016-01-22T04:49:43.140-05:00|NULL |{/min, http://unitsofmeasure.org, /min, 72.0} |
|[{[{vital-signs, vital-signs, http://terminology.hl7.org/CodeSystem/observation-category}], NULL}]|{[{9279-1, Respiratory rate, http://loinc.org}], Respiratory rate} |NULL |2016-01-22T04:49:43-05:00|{urn:uuid:9967925a-1592-669e-85de-a84c5e12b724}|a95e444f-9f00-ce6f-ef94-cf0dac43e37a|2016-01-22T04:49:43.140-05:00|NULL |{/min, http://unitsofmeasure.org, /min, 15.0} |
|[{[{laboratory, laboratory, http://terminology.hl7.org/CodeSystem/observation-category}], NULL}] |{[{2093-3, Total Cholesterol, http://loinc.org}], Total Cholesterol} |NULL |2016-01-22T04:49:43-05:00|{urn:uuid:9967925a-1592-669e-85de-a84c5e12b724}|2c292fba-7749-45df-ce7d-9714ee9a3d61|2016-01-22T04:49:43.140-05:00|NULL |{mg/dL, http://unitsofmeasure.org, mg/dL, 163.34} |
+--------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------+-----------------------------------------------+------------------------------------+-----------------------------+-------------------------------------------------------------------+--------------------------------------------------+
only showing top 20 rows
Resource: Patient
All Columns: ['abatementDateTime', 'activity', 'address', 'addresses', 'authoredOn', 'billablePeriod', 'birthDate', 'careTeam', 'category', 'claim', 'class', 'clinicalStatus', 'code', 'communication', 'component', 'contained', 'created', 'diagnosis', 'dosageInstruction', 'effectiveDateTime', 'encounter', 'extension', 'gender', 'id', 'identifier', 'insurance', 'insurer', 'intent', 'issued', 'item', 'managingOrganization', 'maritalStatus', 'medicationCodeableConcept', 'multipleBirthBoolean', 'name', 'occurrenceDateTime', 'onsetDateTime', 'outcome', 'participant', 'patient', 'payment', 'performedPeriod', 'period', 'prescription', 'primarySource', 'priority', 'procedure', 'provider', 'reasonCode', 'reasonReference', 'recordedDate', 'referral', 'requester', 'resourceType', 'result', 'serviceProvider', 'status', 'subject', 'supportingInfo', 'telecom', 'text', 'total', 'type', 'use', 'vaccineCode', 'valueCodeableConcept', 'valueQuantity', 'verificationStatus']
Non-Null Columns: []
DataFrame with Non-Null Columns for Patient:
++
||
++
||
++
Resource: Procedure
All Columns: ['abatementDateTime', 'activity', 'address', 'addresses', 'authoredOn', 'billablePeriod', 'birthDate', 'careTeam', 'category', 'claim', 'class', 'clinicalStatus', 'code', 'communication', 'component', 'contained', 'created', 'diagnosis', 'dosageInstruction', 'effectiveDateTime', 'encounter', 'extension', 'gender', 'id', 'identifier', 'insurance', 'insurer', 'intent', 'issued', 'item', 'managingOrganization', 'maritalStatus', 'medicationCodeableConcept', 'multipleBirthBoolean', 'name', 'occurrenceDateTime', 'onsetDateTime', 'outcome', 'participant', 'patient', 'payment', 'performedPeriod', 'period', 'prescription', 'primarySource', 'priority', 'procedure', 'provider', 'reasonCode', 'reasonReference', 'recordedDate', 'referral', 'requester', 'resourceType', 'result', 'serviceProvider', 'status', 'subject', 'supportingInfo', 'telecom', 'text', 'total', 'type', 'use', 'vaccineCode', 'valueCodeableConcept', 'valueQuantity', 'verificationStatus']
Non-Null Columns: ['code', 'encounter', 'id', 'performedPeriod', 'reasonReference']
DataFrame with Non-Null Columns for Procedure:
+---------------------------------------------------------------------------------------------------------------------+-----------------------------------------------+------------------------------------+------------------------------------------------------+------------------------------------------------------------------------+
|code |encounter |id |performedPeriod |reasonReference |
+---------------------------------------------------------------------------------------------------------------------+-----------------------------------------------+------------------------------------+------------------------------------------------------+------------------------------------------------------------------------+
|{[{430193006, Medication Reconciliation (procedure), http://snomed.info/sct}], Medication Reconciliation (procedure)}|{urn:uuid:c515ad7d-f4ca-4ae1-60d9-5e6b6c9ea03d}|93912fa8-a853-9b48-b022-3ef3f168d7a2|{2013-01-18T05:04:43-05:00, 2013-01-18T04:49:43-05:00}|NULL |
|{[{288086009, Suture open wound, http://snomed.info/sct}], Suture open wound} |{urn:uuid:e3ba0c81-2fa0-aa88-1cca-9d3610d96d6d}|fcb70e85-a33e-1eea-5043-6e583e5eb02d|{2018-11-15T05:16:00-05:00, 2018-11-15T04:49:43-05:00}|[{Laceration of forearm, urn:uuid:f28c617a-40dd-4901-3add-1637dba5b3c2}]|
|{[{261352009, Face mask (physical object), http://snomed.info/sct}], Face mask (physical object)} |{urn:uuid:eba0f573-2988-e3b1-9ba0-29fc5d32ccd4}|6ed6c5dd-6e06-4af4-fe51-772f3d947d7f|{2020-03-14T06:01:33-04:00, 2020-03-14T05:49:43-04:00}|[{Suspected COVID-19, urn:uuid:b81954ff-53a2-1dd1-d12d-24b0b6dd13b0}] |
+---------------------------------------------------------------------------------------------------------------------+-----------------------------------------------+------------------------------------+------------------------------------------------------+------------------------------------------------------------------------+