 INSERT INTO gpconnect.referrals
   (id, html, provider, lastUpdated)
 VALUES (
-  9000000084,
-  "<div><div><div><div><table><thead><tr><th>Date</th><th>Term</th><th>User/Role</th><th>Where</th><th>By Whom</th><th>Reason</th></tr></thead><tbody><tr><td>14-Jan-2013</td><td><em>Referral to voluntary service</em></td><td>Dr Emis Test</td><td /><td>Dr Emis Test</td><td /></tr><tr><td /><td><table><tbody><tr><td>Reason</td><td /></tr><tr><td>Urgency</td><td /></tr><tr><td>Organisation</td><td /></tr><tr><td>Referred from</td><td>Dr Emis Test</td></tr><tr><td>Snomed code</td><td>2474673014</td></tr><tr><td>Time recorded</td><td>14-Jan-2013 12:09:07</td></tr><tr><td>Person recorded</td><td>Dr Emis Test</td></tr><tr><td>Role of person</td><td>General Medical Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Record element identifier</td><td>4d01e081-e238-4dd7-8c33-038861f96940</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>22230c0a-e7e4-4a8e-bc6c-d982bf5d5ec8</td></tr><tr><td>Extract time</td><td>16-Apr-2013</td></tr></tbody></table></td></tr></tbody></table></div></div><h2>Admissions</h2><div><div><table><thead><tr><th>Date</th><th>Term</th><th>User/Role</th><th>Where</th><th>By Whom</th><th>Reason</th></tr></thead><tbody><tr><td>12-Mar-2013</td><td><em>Discharged from hospital</em></td><td>Dr Emis Test</td><td /><td>Dr Emis Test</td><td /></tr><tr><td /><td><table><tbody><tr><td>Reason</td><td /></tr><tr><td>Urgency</td><td /></tr><tr><td>Organisation</td><td /></tr><tr><td>Referred from</td><td>Dr Emis Test</td></tr><tr><td>Snomed code</td><td>283803018</td></tr><tr><td>Time recorded</td><td>12-Mar-2013 15:22:40</td></tr><tr><td>Person recorded</td><td>Dr Emis Test</td></tr><tr><td>Role of person</td><td>General Medical Practitioner</td></tr><tr><td>Organisation name</td><td>EMISWebCR1 50003</td></tr><tr><td>Organisation id</td><td>A00003</td></tr><tr><td>Record element identifier</td><td>4f66a98e-676e-4906-a449-4eb2f5fe822a</td></tr><tr><td>Source system identity</td><td>EMIS</td></tr><tr><td>Source system type</td><td>GP System</td></tr><tr><td>Extract identifier</td><td>22230c0a-e7e4-4a8e-bc6c-d982bf5d5ec8</td></tr><tr><td>Extract time</td><td>16-Apr-2013</td></tr></tbody></table></td></tr></tbody></table></div></div></div></div>",
+  9000000084, "<div><table><tbody><tr><th>Start date</th><th>From</th><th>To</th><th>Priority</th><th>Details</th></tr><tr><td>03 Oct 2016</td><td>EmisTest at SCI_Service at EMISWebCR1 50004</td><td>SCIGPService at EMISWebCR1</td><td>Routine</td><td>This is confidential<br /></td></tr></tbody></table></div>",
   "EMIS",
   '2016-08-24 12:00:00'
 );

  (id, html, provider, lastUpdated)
VALUES (
  9000000084,
  "<div><div><h2><span>Current Problems</span></h2><div><table><tbody><tr><td>14-Jan-2013</td><td><em>Adverse reaction to aspirin</em></td></tr><tr><td>14-Jan-2013</td><td><em>Lasting power of attorney personal welfare</em></td></tr><tr><td>14-Jan-2013</td><td><em>Blindness and low vision</em></td></tr><tr><td>14-Dec-2012</td><td><em>Blood pH abnormal</em></td></tr><tr><td>08-Jan-2004</td><td><em>Pure hypercholesterolaemia</em></td></tr><tr><td>08-Jan-2004</td><td><em>Chronic obstructive pulmonary disease</em></td></tr><tr><td>Not Known</td><td><em>Asthma</em></td></tr></tbody></table></div></div><div><h2><span>Current Medication</span></h2><div><div>Acute Medication</div><table><tr><td>Co-codamol</td><td>15mg/500mg tablets</td></tr></table><div>Repeat Medication</div><table><tr><td>Salbutamol</td><td>100micrograms/dose inhaler CFC free</td></tr><tr><td>Atorvastatin</td><td>10mg tablets</td></tr><tr><td>Atorvastatin</td><td>10mg tablets</td></tr></table></div></div><div><h2><span>Allergies and Adverse Reactions</span></h2><div><table><tbody><tr><td>14-Jan-2013</td><td><em>Dog allergy</em></td></tr><tr><td>14-Jan-2013</td><td><em>Adverse reaction to aspirin</em></td></tr></tbody></table></div></div><div><h2><span>Recent Tests</span></h2><div><table><tbody><tr><td>23-Jan-2013</td><td><span /></td><td><em>Urine blood test = +</em></td><td>-</td><td>-</td></tr><tr><td>14-Dec-2012</td><td><span /></td><td><em>Sputum inspection</em> : nice</td><td>-</td><td>-</td></tr><tr><td>14-Dec-2012</td><td><span /></td><td><em>Blood pH abnormal</em> : slightly acidic</td><td>-</td><td>-</td></tr><tr><td>19-Jan-2006</td><td><span /></td><td><em>FEV1/FVC percent</em></td><td> 85.000 %</td><td>-</td></tr><tr><td>19-Jan-2006</td><td><span /></td><td><em>Spirometry</em></td><td>-</td><td>-</td></tr><tr><td>19-Jan-2006</td><td><span /></td><td><em>Phlegm examination</em> : BT taken</td><td>-</td><td>-</td></tr><tr><td>19-Jan-2006</td><td><span /></td><td><em>Peak exp. flow rate: PEFR/PFR</em></td><td> 440.000 l/minute</td><td>-</td></tr><tr><td>19-Jan-2006</td><td><span /></td><td><em>Forced expired volume in 1 second</em></td><td> 3.500 litres</td><td>-</td></tr><tr><td>19-Jan-2006</td><td><span /></td><td><em>Forced vital capacity - FVC</em></td><td> 410.000 litres</td><td>-</td></tr><tr><td>17-Jul-2005</td><td><span /></td><td><em>Basophil count</em></td><td> 0.020 10*9/L</td><td>0.000 - 0.10010*9/L</td></tr><tr><td>17-Jul-2005</td><td><span /></td><td><em>Eosinophil count</em></td><td> 0.250 10*9/L</td><td>0.000 - 0.40010*9/L</td></tr><tr><td>17-Jul-2005</td><td><span /></td><td><em>Monocyte count</em></td><td> 0.670 10*9/L</td><td>0.200 - 0.80010*9/L</td></tr><tr><td>17-Jul-2005</td><td><span /></td><td><em>Lymphocyte count</em></td><td> 2.720 10*9/L</td><td>1.500 - 4.00010*9/L</td></tr><tr><td>17-Jul-2005</td><td><span /></td><td><em>Neutrophil count</em></td><td> 4.120 10*9/L</td><td>2.000 - 7.50010*9/L</td></tr><tr><td>17-Jul-2005</td><td><span /></td><td><em>Platelet count</em></td><td> 188.000 10*9/L</td><td>150.000 - 400.00010*9/L</td></tr><tr><td>17-Jul-2005</td><td><span /></td><td><em>Red blood cell distribution width</em></td><td> 14.000 %</td><td>11.000 - 15.000%</td></tr><tr><td>17-Jul-2005</td><td><span /></td><td><em>Mean corpusc. haemoglobin(MCH)</em></td><td> 27.000 pg</td><td>27.000 - 32.000pg</td></tr><tr><td>17-Jul-2005</td><td><span /></td><td><em>Mean corpuscular volume (MCV)</em></td><td> 82.000 fL</td><td>80.000 - 97.000fL</td></tr><tr><td>17-Jul-2005</td><td><span /></td><td><em>Haematocrit</em></td><td> 0.437 1/1</td><td>0.400 - 0.5401/1</td></tr><tr><td>17-Jul-2005</td><td><span /></td><td><em>Haemoglobin estimation</em></td><td> 144.000 g/L</td><td>130.000 - 180.000g/L</td></tr><tr><td>17-Jul-2005</td><td><span /></td><td><em>Red blood cell (RBC) count</em></td><td> 5.350 10*12/L</td><td>4.500 - 6.50010*12/L</td></tr><tr><td>17-Jul-2005</td><td><span /></td><td><em>Total white cell count</em></td><td> 7.800 10*9/L</td><td>4.000 - 11.00010*9/L</td></tr><tr><td>17-Jul-2005</td><td><span /></td><td><em>Plasma fasting glucose level</em></td><td> 4.400 mmol/L</td><td>-</td></tr><tr><td>17-Jul-2005</td><td><span /></td><td><em>Serum creatinine</em></td><td> 78.000 umol/L</td><td>60.000 - 120.000umol/L</td></tr><tr><td>17-Jul-2005</td><td><span /></td><td><em>Serum urea level</em></td><td> 3.700 mmol/L</td><td>2.700 - 7.500mmol/L</td></tr><tr><td>17-Jul-2005</td><td><span /></td><td><em>Serum potassium</em></td><td> 3.900 mmol/L</td><td>3.500 - 5.000mmol/L</td></tr><tr><td>17-Jul-2005</td><td><span /></td><td><em>Serum sodium</em></td><td> 137.000 mmol/L</td><td>132.000 - 144.000mmol/L</td></tr><tr><td>17-Jul-2005</td><td><span /></td><td><em>ALT/SGPT serum level</em></td><td> 29.000 iu/L</td><td>5.000 - 45.000iu/L</td></tr><tr><td>17-Jul-2005</td><td><span /></td><td><em>Serum alkaline phosphatase</em></td><td> 62.000 iu/L</td><td>25.000 - 110.000iu/L</td></tr><tr><td>17-Jul-2005</td><td><span /></td><td><em>Serum total bilirubin level</em></td><td> 11.000 umol/L</td><td>1.000 - 20.000umol/L</td></tr><tr><td>17-Jul-2005</td><td><span /></td><td><em>Serum globulin</em></td><td> 26.000 g/L</td><td>21.000 - 38.000g/L</td></tr><tr><td>17-Jul-2005</td><td><span /></td><td><em>Serum albumin</em></td><td> 44.000 g/L</td><td>33.000 - 49.000g/L</td></tr><tr><td>17-Jul-2005</td><td><span /></td><td><em>Serum total protein</em></td><td> 70.000 g/L</td><td>60.000 - 80.000g/L</td></tr><tr><td>17-Jul-2005</td><td><span /></td><td><em>Serum LDL cholesterol level</em></td><td> 1.900 mmol/L</td><td>-</td></tr><tr><td>17-Jul-2005</td><td><span /></td><td><em>Serum HDL cholesterol level</em></td><td> 1.400 mmol/L</td><td>-</td></tr><tr><td>17-Jul-2005</td><td><span /></td><td><em>Serum triglycerides</em></td><td> 0.600 mmol/L</td><td>-</td></tr><tr><td>17-Jul-2005</td><td><span /></td><td><em>Serum cholesterol</em></td><td> 3.600 mmol/L</td><td>-</td></tr><tr><td>17-Jul-2005</td><td><span /></td><td><em>GFR calculated abbreviated MDRD</em> : Food regurgitation discomfort</td><td>-</td><td>-</td></tr><tr><td>17-Jul-2005</td><td><span /></td><td><em>Serum HDL cholesterol level</em></td><td> 1.400 mmol/l</td><td>-</td></tr><tr><td>17-Jul-2005</td><td><span /></td><td><em>Total cholesterol:HDL ratio</em></td><td> 2.520 </td><td>-</td></tr><tr><td>17-Jul-2005</td><td><span /></td><td><em>Serum cholesterol</em></td><td> 3.600 mmol/l</td><td>-</td></tr><tr><td>22-Oct-2004</td><td><span /></td><td><em>Basophil count</em></td><td> 0.020 10*9/L</td><td>0.000 - 0.10010*9/L</td></tr><tr><td>22-Oct-2004</td><td><span /></td><td><em>Eosinophil count</em></td><td> 0.150 10*9/L</td><td>0.000 - 0.40010*9/L</td></tr><tr><td>22-Oct-2004</td><td><span /></td><td><em>Monocyte count</em></td><td> 0.650 10*9/L</td><td>0.200 - 0.80010*9/L</td></tr><tr><td>22-Oct-2004</td><td><span /></td><td><em>Lymphocyte count</em></td><td> 2.760 10*9/L</td><td>1.500 - 4.00010*9/L</td></tr><tr><td>22-Oct-2004</td><td><span /></td><td><em>Neutrophil count</em></td><td> 2.800 10*9/L</td><td>2.000 - 7.50010*9/L</td></tr><tr><td>22-Oct-2004</td><td><span /></td><td><em>Platelet count</em></td><td> 177.000 10*9/L</td><td>150.000 - 400.00010*9/L</td></tr><tr><td>22-Oct-2004</td><td><span /></td><td><em>Red blood cell distribution width</em></td><td> 14.000 %</td><td>11.000 - 15.000%</td></tr><tr><td>22-Oct-2004</td><td><span /></td><td><em>Mean corpusc. haemoglobin(MCH)</em></td><td> 27.000 pg</td><td>27.000 - 32.000pg</td></tr><tr><td>22-Oct-2004</td><td><span /></td><td><em>Mean corpuscular volume (MCV)</em></td><td> 83.000 fL</td><td>80.000 - 97.000fL</td></tr><tr><td>22-Oct-2004</td><td><span /></td><td><em>Haematocrit</em></td><td> 0.426 1/1</td><td>0.400 - 0.5401/1</td></tr><tr><td>22-Oct-2004</td><td><span /></td><td><em>Haemoglobin estimation</em></td><td> 141.000 g/L</td><td>130.000 - 180.000g/L</td></tr><tr><td>22-Oct-2004</td><td><span /></td><td><em>Red blood cell (RBC) count</em></td><td> 5.140 10*12/L</td><td>4.500 - 6.50010*12/L</td></tr><tr><td>22-Oct-2004</td><td><span /></td><td><em>Total white cell count</em></td><td> 6.400 10*9/L</td><td>4.000 - 11.00010*9/L</td></tr><tr><td>22-Oct-2004</td><td><span /></td><td><em>Serum creatinine</em></td><td> 82.000 umol/L</td><td>60.000 - 120.000umol/L</td></tr><tr><td>22-Oct-2004</td><td><span /></td><td><em>Serum urea level</em></td><td> 4.100 mmol/L</td><td>2.700 - 7.500mmol/L</td></tr><tr><td>22-Oct-2004</td><td><span /></td><td><em>Serum potassium</em></td><td> 4.000 mmol/L</td><td>3.500 - 5.000mmol/L</td></tr><tr><td>22-Oct-2004</td><td><span /></td><td><em>Serum sodium</em></td><td> 138.000 mmol/L</td><td>132.000 - 144.000mmol/L</td></tr><tr><td>22-Oct-2004</td><td><span /></td><td><em>ALT/SGPT serum level</em></td><td> 36.000 iu/L</td><td>5.000 - 45.000iu/L</td></tr><tr><td>22-Oct-2004</td><td><span /></td><td><em>Serum alkaline phosphatase</em></td><td> 57.000 iu/L</td><td>25.000 - 110.000iu/L</td></tr><tr><td>22-Oct-2004</td><td><span>!</span></td><td><em>Serum total bilirubin level</em></td><td> 24.000 umol/L</td><td>1.000 - 20.000umol/L</td></tr><tr><td>22-Oct-2004</td><td><span /></td><td><em>Serum globulin</em></td><td> 28.000 g/L</td><td>21.000 - 38.000g/L</td></tr><tr><td>22-Oct-2004</td><td><span /></td><td><em>Serum albumin</em></td><td> 43.000 g/L</td><td>33.000 - 49.000g/L</td></tr><tr><td>22-Oct-2004</td><td><span /></td><td><em>Serum total protein</em></td><td> 71.000 g/L</td><td>60.000 - 80.000g/L</td></tr><tr><td>22-Oct-2004</td><td><span /></td><td><em>Serum LDL cholesterol level</em></td><td> 1.500 mmol/L</td><td>-</td></tr><tr><td>22-Oct-2004</td><td><span /></td><td><em>Serum HDL cholesterol level</em></td><td> 1.300 mmol/L</td><td>-</td></tr><tr><td>22-Oct-2004</td><td><span /></td><td><em>Serum triglycerides</em></td><td> 0.900 mmol/L</td><td>-</td></tr><tr><td>22-Oct-2004</td><td><span /></td><td><em>Serum cholesterol</em></td><td> 3.200 mmol/L</td><td>-</td></tr><tr><td>22-Oct-2004</td><td><span /></td><td><em>Serum HDL cholesterol level</em></td><td> 1.400 mmol/l</td><td>-</td></tr><tr><td>22-Oct-2004</td><td><span /></td><td><em>Total cholesterol:HDL ratio</em></td><td> 2.420 </td><td>-</td></tr><tr><td>22-Oct-2004</td><td><span /></td><td><em>Serum cholesterol</em></td><td> 3.400 mmol/l</td><td>-</td></tr><tr><td>18-Mar-2004</td><td><span /></td><td><em>Serum creatinine</em></td><td> 81.000 umol/L</td><td>60.000 - 120.000umol/L</td></tr><tr><td>18-Mar-2004</td><td><span /></td><td><em>Serum urea level</em></td><td> 4.100 mmol/L</td><td>2.700 - 7.500mmol/L</td></tr><tr><td>18-Mar-2004</td><td><span /></td><td><em>Serum potassium</em></td><td> 4.300 mmol/L</td><td>3.500 - 5.000mmol/L</td></tr><tr><td>18-Mar-2004</td><td><span /></td><td><em>Serum sodium</em></td><td> 139.000 mmol/L</td><td>132.000 - 144.000mmol/L</td></tr><tr><td>18-Mar-2004</td><td><span /></td><td><em>ALT/SGPT serum level</em></td><td> 44.000 iu/L</td><td>5.000 - 45.000iu/L</td></tr><tr><td>18-Mar-2004</td><td><span /></td><td><em>Serum alkaline phosphatase</em></td><td> 65.000 iu/L</td><td>25.000 - 110.000iu/L</td></tr><tr><td>18-Mar-2004</td><td><span>!</span></td><td><em>Serum total bilirubin level</em></td><td> 24.000 umol/L</td><td>1.000 - 20.000umol/L</td></tr><tr><td>18-Mar-2004</td><td><span /></td><td><em>Serum globulin</em></td><td> 24.000 g/L</td><td>21.000 - 38.000g/L</td></tr><tr><td>18-Mar-2004</td><td><span /></td><td><em>Serum albumin</em></td><td> 45.000 g/L</td><td>33.000 - 49.000g/L</td></tr><tr><td>18-Mar-2004</td><td><span /></td><td><em>Serum total protein</em></td><td> 69.000 g/L</td><td>60.000 - 80.000g/L</td></tr><tr><td>18-Mar-2004</td><td><span /></td><td><em>Serum LDL cholesterol level</em></td><td> 1.600 mmol/L</td><td>-</td></tr><tr><td>18-Mar-2004</td><td><span /></td><td><em>Serum HDL cholesterol level</em></td><td> 1.400 mmol/L</td><td>-</td></tr><tr><td>18-Mar-2004</td><td><span /></td><td><em>Serum triglycerides</em></td><td> 0.800 mmol/L</td><td>-</td></tr><tr><td>18-Mar-2004</td><td><span /></td><td><em>Serum cholesterol</em></td><td> 3.400 mmol/L</td><td>-</td></tr><tr><td>08-Jan-2004</td><td><span /></td><td><em>FEV1/FVC percent</em></td><td> 76.000 %</td><td>-</td></tr><tr><td>08-Jan-2004</td><td><span /></td><td><em>Peak exp. flow rate: PEFR/PFR</em></td><td> 175.000 l/min</td><td>-</td></tr><tr><td>08-Jan-2004</td><td><span /></td><td><em>Forced expired volume in 1 second</em></td><td> 1.700 litres</td><td>-</td></tr><tr><td>08-Jan-2004</td><td><span /></td><td><em>Forced vital capacity - FVC</em></td><td> 225.000 litres</td><td>-</td></tr><tr><td>12-Dec-2003</td><td><span /></td><td><em>Serum creatinine</em></td><td> 84.000 umol/L</td><td>60.000 - 120.000umol/L</td></tr><tr><td>12-Dec-2003</td><td><span /></td><td><em>Serum urea level</em></td><td> 3.600 mmol/L</td><td>2.700 - 7.500mmol/L</td></tr><tr><td>12-Dec-2003</td><td><span /></td><td><em>Serum potassium</em></td><td> 4.300 mmol/L</td><td>3.500 - 5.000mmol/L</td></tr><tr><td>12-Dec-2003</td><td><span /></td><td><em>Serum sodium</em></td><td> 140.000 mmol/L</td><td>132.000 - 144.000mmol/L</td></tr><tr><td>12-Dec-2003</td><td><span /></td><td><em>ALT/SGPT serum level</em></td><td> 31.000 iu/L</td><td>5.000 - 45.000iu/L</td></tr><tr><td>12-Dec-2003</td><td><span /></td><td><em>Serum alkaline phosphatase</em></td><td> 68.000 iu/L</td><td>25.000 - 110.000iu/L</td></tr><tr><td>12-Dec-2003</td><td><span /></td><td><em>Serum total bilirubin level</em></td><td> 16.000 umol/L</td><td>1.000 - 20.000umol/L</td></tr><tr><td>12-Dec-2003</td><td><span /></td><td><em>Serum globulin</em></td><td> 27.000 g/L</td><td>21.000 - 38.000g/L</td></tr><tr><td>12-Dec-2003</td><td><span /></td><td><em>Serum albumin</em></td><td> 48.000 g/L</td><td>33.000 - 49.000g/L</td></tr><tr><td>12-Dec-2003</td><td><span /></td><td><em>Serum total protein</em></td><td> 75.000 g/L</td><td>60.000 - 80.000g/L</td></tr><tr><td>12-Dec-2003</td><td><span /></td><td><em>Serum LDL cholesterol level</em></td><td> 3.600 mmol/L</td><td>-</td></tr><tr><td>12-Dec-2003</td><td><span /></td><td><em>Serum HDL cholesterol level</em></td><td> 1.600 mmol/L</td><td>-</td></tr><tr><td>12-Dec-2003</td><td><span /></td><td><em>Serum triglycerides</em></td><td> 0.900 mmol/L</td><td>-</td></tr><tr><td>12-Dec-2003</td><td><span /></td><td><em>Serum cholesterol</em></td><td> 5.600 mmol/L</td><td>-</td></tr><tr><td>12-Dec-2003</td><td><span /></td><td><em>Basophil count</em></td><td> 0.030 10*9/L</td><td>0.000 - 0.10010*9/L</td></tr><tr><td>12-Dec-2003</td><td><span /></td><td><em>Eosinophil count</em></td><td> 0.140 10*9/L</td><td>0.000 - 0.40010*9/L</td></tr><tr><td>12-Dec-2003</td><td><span /></td><td><em>Monocyte count</em></td><td> 0.560 10*9/L</td><td>0.200 - 0.80010*9/L</td></tr><tr><td>12-Dec-2003</td><td><span /></td><td><em>Lymphocyte count</em></td><td> 2.710 10*9/L</td><td>1.500 - 4.00010*9/L</td></tr><tr><td>12-Dec-2003</td><td><span /></td><td><em>Neutrophil count</em></td><td> 2.570 10*9/L</td><td>2.000 - 7.50010*9/L</td></tr><tr><td>12-Dec-2003</td><td><span /></td><td><em>Platelet count</em></td><td> 237.000 10*9/L</td><td>150.000 - 400.00010*9/L</td></tr><tr><td>12-Dec-2003</td><td><span /></td><td><em>Red blood cell distribution width</em></td><td> 15.000 %</td><td>11.000 - 15.000%</td></tr><tr><td>12-Dec-2003</td><td><span /></td><td><em>Mean corpusc. haemoglobin(MCH)</em></td><td> 27.000 pg</td><td>27.000 - 32.000pg</td></tr><tr><td>12-Dec-2003</td><td><span /></td><td><em>Mean corpuscular volume (MCV)</em></td><td> 85.000 fL</td><td>80.000 - 97.000fL</td></tr><tr><td>12-Dec-2003</td><td><span /></td><td><em>Haematocrit</em></td><td> 0.456 1/1</td><td>0.400 - 0.5401/1</td></tr><tr><td>12-Dec-2003</td><td><span /></td><td><em>Haemoglobin estimation</em></td><td> 145.000 g/L</td><td>130.000 - 180.000g/L</td></tr><tr><td>12-Dec-2003</td><td><span /></td><td><em>Red blood cell (RBC) count</em></td><td> 5.390 10*12/L</td><td>4.500 - 6.50010*12/L</td></tr><tr><td>12-Dec-2003</td><td><span /></td><td><em>Total white cell count</em></td><td> 6.000 10*9/L</td><td>4.000 - 11.00010*9/L</td></tr><tr><td>21-Mar-2003</td><td><span>!</span></td><td><em>Erythrocyte sedimentation rate</em></td><td> 15.000 mm/h</td><td>1.000 - 5.000mm/h</td></tr><tr><td>21-Mar-2003</td><td><span /></td><td><em>Basophil count</em></td><td> 0.060 10*9/L</td><td>0.000 - 0.10010*9/L</td></tr><tr><td>21-Mar-2003</td><td><span /></td><td><em>Eosinophil count</em></td><td> 0.120 10*9/L</td><td>0.000 - 0.40010*9/L</td></tr><tr><td>21-Mar-2003</td><td><span /></td><td><em>Monocyte count</em></td><td> 0.480 10*9/L</td><td>0.200 - 0.80010*9/L</td></tr><tr><td>21-Mar-2003</td><td><span /></td><td><em>Lymphocyte count</em></td><td> 2.610 10*9/L</td><td>1.500 - 4.00010*9/L</td></tr><tr><td>21-Mar-2003</td><td><span /></td><td><em>Neutrophil count</em></td><td> 2.510 10*9/L</td><td>2.000 - 7.50010*9/L</td></tr><tr><td>21-Mar-2003</td><td><span /></td><td><em>Platelet count</em></td><td> 205.000 10*9/L</td><td>150.000 - 400.00010*9/L</td></tr><tr><td>21-Mar-2003</td><td><span /></td><td><em>Red blood cell distribution width</em></td><td> 14.000 %</td><td>11.000 - 15.000%</td></tr><tr><td>21-Mar-2003</td><td><span /></td><td><em>Mean corpusc. haemoglobin(MCH)</em></td><td> 28.000 pg</td><td>27.000 - 32.000pg</td></tr><tr><td>21-Mar-2003</td><td><span /></td><td><em>Mean corpuscular volume (MCV)</em></td><td> 87.000 fL</td><td>80.000 - 97.000fL</td></tr><tr><td>21-Mar-2003</td><td><span /></td><td><em>Haematocrit</em></td><td> 0.457 1/1</td><td>0.400 - 0.5401/1</td></tr><tr><td>21-Mar-2003</td><td><span /></td><td><em>Haemoglobin estimation</em></td><td> 148.000 g/L</td><td>130.000 - 180.000g/L</td></tr><tr><td>21-Mar-2003</td><td><span /></td><td><em>Red blood cell (RBC) count</em></td><td> 5.260 10*12/L</td><td>4.500 - 6.50010*12/L</td></tr><tr><td>21-Mar-2003</td><td><span /></td><td><em>Total white cell count</em></td><td> 5.800 10*9/L</td><td>4.000 - 11.00010*9/L</td></tr><tr><td>21-Mar-2003</td><td><span /></td><td><em>Serum creatinine</em></td><td> 81.000 umol/L</td><td>60.000 - 120.000umol/L</td></tr><tr><td>21-Mar-2003</td><td><span /></td><td><em>Serum urea level</em></td><td> 3.400 mmol/L</td><td>2.700 - 7.500mmol/L</td></tr><tr><td>21-Mar-2003</td><td><span /></td><td><em>Serum potassium</em></td><td> 4.500 mmol/L</td><td>3.500 - 5.000mmol/L</td></tr><tr><td>21-Mar-2003</td><td><span /></td><td><em>Serum sodium</em></td><td> 138.000 mmol/L</td><td>132.000 - 144.000mmol/L</td></tr><tr><td>21-Mar-2003</td><td><span /></td><td><em>ALT/SGPT serum level</em></td><td> 33.000 iu/L</td><td>5.000 - 45.000iu/L</td></tr><tr><td>21-Mar-2003</td><td><span /></td><td><em>Serum alkaline phosphatase</em></td><td> 84.000 iu/L</td><td>25.000 - 110.000iu/L</td></tr><tr><td>21-Mar-2003</td><td><span /></td><td><em>Serum total bilirubin level</em></td><td> 10.000 umol/L</td><td>1.000 - 20.000umol/L</td></tr><tr><td>21-Mar-2003</td><td><span /></td><td><em>Serum globulin</em></td><td> 28.000 g/L</td><td>21.000 - 38.000g/L</td></tr><tr><td>21-Mar-2003</td><td><span /></td><td><em>Serum albumin</em></td><td> 45.000 g/L</td><td>33.000 - 49.000g/L</td></tr><tr><td>21-Mar-2003</td><td><span /></td><td><em>Serum total protein</em></td><td> 73.000 g/L</td><td>60.000 - 80.000g/L</td></tr><tr><td>21-Mar-2003</td><td><span /></td><td><em>Plasma fasting glucose level</em></td><td> 4.800 mmol/L</td><td>-</td></tr><tr><td>21-Mar-2003</td><td><span /></td><td><em>Serum LDL cholesterol level</em></td><td> 3.100 mmol/L</td><td>-</td></tr><tr><td>21-Mar-2003</td><td><span /></td><td><em>Serum HDL cholesterol level</em></td><td> 1.400 mmol/L</td><td>-</td></tr><tr><td>21-Mar-2003</td><td><span /></td><td><em>Serum triglycerides</em></td><td> 0.700 mmol/L</td><td>-</td></tr><tr><td>21-Mar-2003</td><td><span /></td><td><em>Serum cholesterol</em></td><td> 4.800 mmol/L</td><td>-</td></tr><tr><td>21-Mar-2003</td><td><span /></td><td><em>Urine glucose test negative</em></td><td>-</td><td>-</td></tr><tr><td>21-Mar-2003</td><td><span /></td><td><em>Urine protein test negative</em></td><td>-</td><td>-</td></tr><tr><td>21-Mar-2003</td><td><span /></td><td><em>FEV1/FVC percent</em></td><td> 71.000 %</td><td>-</td></tr><tr><td>21-Mar-2003</td><td><span /></td><td><em>Peak exp. flow rate: PEFR/PFR</em></td><td> 463.000 l/minute</td><td>-</td></tr><tr><td>21-Mar-2003</td><td><span /></td><td><em>Forced expired volume in 1 second</em></td><td> 3.120 litres</td><td>-</td></tr><tr><td>21-Mar-2003</td><td><span /></td><td><em>Forced vital capacity - FVC</em></td><td> 3.120 litres</td><td>-</td></tr><tr><td>14-Mar-2003</td><td><span /></td><td><em>Standard chest X-ray normal</em></td><td>-</td><td>-</td></tr></tbody></table></div></div></div>",
  "EMIS",
  '2016-08-24 12:00:00'
);

  (id, html, provider, lastUpdated)
VALUES (
  9000000084,
  "<div><h2>Current Allergies and Sensitivities</h2><table><tbody><tr><th>Start date</th><th>Details</th></tr><tr><td>03 Oct 2016</td><td>This is confidential</td></tr></tbody></table></div>",
  "EMIS",
  '2016-08-24 12:00:00'
);
