<commit_before>INSERT INTO gpconnect.patientsummary
  (id, html, provider)
VALUES (
  1,
  "<h5>Warnings</h5>
<table class=\"table table-bordered table-striped table-hover\">
	<tr>
		<th>Date</th>
		<th>Details</th>
	</tr>
	<tr><td>23 Feb 2005</td><td>Loses temper easily</td></tr>
</table>

<h5>Key Indicators</h5>
<table class=\"table table-bordered table-striped table-hover\">
	<tr>
		<th>Date</th>
		<th>Indicator</th>
	</tr>
	<tr><td>20 Feb 2015</td><td>Has an end of life care plan</td></tr>
	<tr><td>13 Jan 1999</td><td>Asthmatic</td></tr>
</table>

<h5>Active Problems & Summary Items</h5>
<table class=\"table table-bordered table-striped table-hover\">
	<tr>
		<th>Start Date</th>
		<th>Entry</th>
		<th>Significance</th>
		<th>Details</th>
	</tr>
	<tr><td>23 Feb 2005</td><td>Type II diabetes mellitus</td><td>Major</td><td></td></tr>
	<tr><td>10 Apr 2000</td><td>Low back pain</td><td>Minor</td><td></td></tr>
	<tr><td>13 Jan 1999</td><td>Asthma</td><td>Major</td><td></td></tr>
</table>

<h5>Current Medication Issues</h5>
<table class=\"table table-bordered table-striped table-hover\">
	<tr>
		<th>Start date</th>
		<th>Drug</th>
		<th>Scheduled end</th>
		<th>Days duration</th>
		<th>Details</th>
	</tr>
	<tr>
		<td>10 Apr 2016</td>
		<td>Paracetemol 500mg tablets - 32 tablet - take 1 or 2 4 times/day</td>
		<td>14 Apr 2016</td>
		<td>4</td>
		<td></td>
	</tr>
	<tr>
		<td>08 Apr 2016</td>
		<td>Metformin 500mg tablets - 42 tablet - take one 3 times/day</td>
		<td>22 Apr 2016</td>
		<td>14</td>
		<td>Repeat issue</td>
	</tr>
</table>

<h5>Current Repeat Templates</h5>
<table class=\"table table-bordered table-striped table-hover\">
	<tr>
		<th>Start date</th>
		<th>Drug</th>
		<th>Type</th>
		<th>Last issued</th>
		<th>Review date</th>
		<th>Number issued</th>
		<th>Max issues</th>		
		<th>Details</th>
	</tr>
	<tr>
		<td>01 Mar 2016</td>
		<td>Metformin 500mg tablets - 42 tablet - take one 3 times/day</td>
		<td>Repeat</td>
		<td>08 Apr 2016</td>
		<td>30 Sep 2016</td>
		<td>2</td>
		<td>12</td>
		<td></td>
	</tr>
</table>

<h5>Current Allergies and Sensitivities</h5>
<table class=\"table table-bordered table-striped table-hover\">
	<tr>
		<th>Start date</th>
		<th>Details</th>
	</tr>
	<tr>
		<td>10 Mar 2016</td>
		<td>PENICILLIN VK</td>
	</tr>
	<tr>
		<td>29 Mar 2016</td>
		<td>Nurofen Express 256mg caplets (Reckitt Benckiser Healthcare (UK) Ltd)</td>
	</tr>
	<tr>
		<td>29 Mar 2016</td>
		<td>Nut allergy</td>
	</tr>
</table>

<h5>Current Recalls</h5>
<table class=\"table table-bordered table-striped table-hover\">
	<tr>
		<th>Recall date</th>
		<th>Details</th>
	</tr>
	<tr>
		<td>29 Jan 2017</td>
		<td>Asthma monitoring</td>
	</tr>
	<tr>
		<td>10 Sep 2016</td>
		<td>Influenza Vaccination</td>
	</tr>	
</table>

<h5>Last 3 Encounters</h5>
<table class=\"table table-bordered table-striped table-hover\">
	<tr>
		<th>10 Dec 2014 - 12:17</td>
		<th><NAME> - Dr Johnson and Partners (J12345)</td>
	</tr>
	<tr>
		<td></td>
		<td>History: Family history of diabetes mellitus type II.<br>Came to nurse last week with Polyuria Very worried that he is diabetic - confirmed on blood tests. Very amenable to change of lifestyle; no other symptoms at present.<br>Examination: O/E - Diastolic BP reading 98 mmHg. , O/E - Systolic BP reading 152 mmHg.<br>Diagnosis: Type II diabetes mellitus.<br>Procedure: Wants to avoid tabs for the moment - watch TChol as well as HbA1c. Review 1/12.<br>Metformin 500mg tablets - 168 tablets - take one three times a day - Patient has read up on metformin and is keen to start.<br></td>
	</tr>
	<tr>
		<th>01 Jan 2015 - 15:47</td>
		<th><NAME> - Dr Johnson and Partners (J12345)</td>
	</tr>
	<tr>
		<td></td>
		<td>Type II diabetic dietary review.<br>Haemoglobin A1c level - IFCC standardised 20.5 mmol/mol.<br>Insulin isophane biphasic porcine 30/70 100units/ml suspension for injection 10ml vials - 5 vials - use as directed.</td>
	</tr>
	<tr>
		<th>04 Jul 2015 - 12:10</td>
		<th><NAME> - Dr Johnson and Partners (J12345)</td>
	</tr>
	<tr>
		<td></td>
		<td>Contact method: Telephone<br>Care plan created: Diabetes management plan.<br>Haemoglobin A1c level - IFCC standardised 23.5 mmol/mol.</td>
	</tr>
</table>

<h5>Recent Investigations (last 3 months)</h5>
<table  class=\"table table-bordered table-striped table-hover\">
	<tr>
		<th>12 Mar 2016</td>
		<th>Full blood count</td>
	</tr>
	<tr>
		<td></td>
		<td>
			Result indicator: Borderline<br>
			Follow-up action: Make an appointment to see doctor<br>
			No filing comments given.<br>
			<br>
			Date Analysed: 12/03/12<br>
			Time Analysed: 11:22<br>
			Large unstained cell: 0.20 10*9/L<br>
			report 7:nhs003 no errors: 0.427 L/L<br>
			<br>
			<table class=\"innertable\">
				<tr><td>Full blood count</td><td></td><td></td></tr>
				<tr><td>Haemoglobin concentration</td><td></td><td>15.4 g/dL [13 - 17]</td></tr>
				<tr><td>Total white blood count</td><td>Above range</td><td>13.1 10^9/L [4 - 11]</td></tr>
				<tr><td>Platelet count - observation</td><td></td><td>244 10^9/L [150 - 400]</td></tr>
				<tr><td>Neutrophil count</td><td>Above range</td><td>8.5 10^9/L [2 - 7.5]</td></tr>
				<tr><td>Lymphocyte count</td><td></td><td>2.8 10^9/L [1.5 - 4]</td></tr>
				<tr><td>Monocyte count - observation</td><td>Above range</td><td>1.1 10^9/L [0.2 - 1]</td></tr>
				<tr><td>Eosinophil count - observation</td><td>Above range</td><td>0.6 10^9/L [0 - 0.5]</td></tr>
				<tr><td>Basophil count</td><td></td><td>0.1 10^9/L [0 - 0.1]</td></tr>
				<tr><td>Red blood cell count</td><td>Above range</td><td>5.75 10^12/L [4.5 - 5.5]</td></tr>
				<tr><td>Packed cell volume</td><td></td><td>0.465  [0.4 - 0.5]</td></tr>
				<tr><td>Mean cell volume</td><td></td><td>80.9 fL [80 - 100]</td></tr>
				<tr><td>Mean cell haemoglobin level</td><td>Below range</td><td>26.8 pg [27 - 32]</td></tr>
				<tr><td>Mean cell haemoglobin concentration</td><td></td><td>33.1 g/dL [32 - 36]</td></tr>
			</table>
		</td>
	</tr>
	<tr>
		<th>23 Jan 2016</td>
		<th>Serum TSH level</td>
	</tr>
	<tr>
		<td></td>
		<td>
			Result indicator: Normal<br>
			No further action required.<br>
			No filing comments given.<br>
			<br>
			Clinical Information: Clinical Details: THYROXINE<br>
			<br>
			<table class=\"innertable\">
				<tr><td>Serum TSH level</td><td></td><td>1.5 miu/L [0.2 - 4]<br>TSH level is consistent with optimum replacement<br>NB above comment applies only to patients on T4 for<br>treatment of primary hypothyroidism.<br>Treatment target in CA Thyroid is TSH <0.10 mU/L</td></tr>
			</table>
		</td>
	</tr>
</table>
",
  "TPP"
);<commit_msg>Modified column width for dates<commit_after>INSERT INTO gpconnect.patientsummary
  (id, html, provider)
VALUES (
  1,
  "<h5>Warnings</h5>
<table class=\"table table-bordered table-striped table-hover\">
	<tr>
		<th width=\"120px\">Date</th>
		<th>Details</th>
	</tr>
	<tr><td width=\"120px\">23 Feb 2005</td><td>Loses temper easily</td></tr>
</table>

<h5>Key Indicators</h5>
<table class=\"table table-bordered table-striped table-hover\">
	<tr>
		<th width=\"120px\">Date</th>
		<th>Indicator</th>
	</tr>
	<tr><td width=\"120px\">20 Feb 2015</td><td>Has an end of life care plan</td></tr>
	<tr><td width=\"120px\">13 Jan 1999</td><td>Asthmatic</td></tr>
</table>

<h5>Active Problems & Summary Items</h5>
<table class=\"table table-bordered table-striped table-hover\">
	<tr>
		<th width=\"120px\">Start Date</th>
		<th>Entry</th>
		<th>Significance</th>
		<th>Details</th>
	</tr>
	<tr><td width=\"120px\">23 Feb 2005</td><td>Type II diabetes mellitus</td><td>Major</td><td></td></tr>
	<tr><td width=\"120px\">10 Apr 2000</td><td>Low back pain</td><td>Minor</td><td></td></tr>
	<tr><td width=\"120px\">13 Jan 1999</td><td>Asthma</td><td>Major</td><td></td></tr>
</table>

<h5>Current Medication Issues</h5>
<table class=\"table table-bordered table-striped table-hover\">
	<tr>
		<th width=\"120px\">Start date</th>
		<th>Drug</th>
		<th width=\"120px\">Scheduled end</th>
		<th>Days duration</th>
		<th>Details</th>
	</tr>
	<tr>
		<td width=\"120px\">10 Apr 2016</td>
		<td>Paracetemol 500mg tablets - 32 tablet - take 1 or 2 4 times/day</td>
		<td width=\"120px\">14 Apr 2016</td>
		<td>4</td>
		<td></td>
	</tr>
	<tr>
		<td width=\"120px\">08 Apr 2016</td>
		<td>Metformin 500mg tablets - 42 tablet - take one 3 times/day</td>
		<td width=\"120px\">22 Apr 2016</td>
		<td>14</td>
		<td>Repeat issue</td>
	</tr>
</table>

<h5>Current Repeat Templates</h5>
<table class=\"table table-bordered table-striped table-hover\">
	<tr>
		<th width=\"120px\">Start date</th>
		<th>Drug</th>
		<th>Type</th>
		<th width=\"120px\">Last issued</th>
		<th width=\"120px\">Review date</th>
		<th>Number issued</th>
		<th>Max issues</th>		
		<th>Details</th>
	</tr>
	<tr>
		<td width=\"120px\">01 Mar 2016</td>
		<td>Metformin 500mg tablets - 42 tablet - take one 3 times/day</td>
		<td>Repeat</td>
		<td width=\"120px\">08 Apr 2016</td>
		<td width=\"120px\">30 Sep 2016</td>
		<td>2</td>
		<td>12</td>
		<td></td>
	</tr>
</table>

<h5>Current Allergies and Sensitivities</h5>
<table class=\"table table-bordered table-striped table-hover\">
	<tr>
		<th width=\"120px\">Start date</th>
		<th>Details</th>
	</tr>
	<tr>
		<td width=\"120px\">10 Mar 2016</td>
		<td>PENICILLIN VK</td>
	</tr>
	<tr>
		<td width=\"120px\">29 Mar 2016</td>
		<td>Nurofen Express 256mg caplets (Reckitt Benckiser Healthcare (UK) Ltd)</td>
	</tr>
	<tr>
		<td width=\"120px\">29 Mar 2016</td>
		<td>Nut allergy</td>
	</tr>
</table>

<h5>Current Recalls</h5>
<table class=\"table table-bordered table-striped table-hover\">
	<tr>
		<th width=\"120px\">Recall date</th>
		<th>Details</th>
	</tr>
	<tr>
		<td width=\"120px\">29 Jan 2017</td>
		<td>Asthma monitoring</td>
	</tr>
	<tr>
		<td width=\"120px\">10 Sep 2016</td>
		<td>Influenza Vaccination</td>
	</tr>	
</table>

<h5>Last 3 Encounters</h5>
<table class=\"table table-bordered table-striped table-hover\">
	<tr>
		<th width=\"150px\">10 Dec 2014 - 12:17</td>
		<th><NAME> - Dr Johnson and Partners (J12345)</td>
	</tr>
	<tr>
		<td></td>
		<td>History: Family history of diabetes mellitus type II.<br>Came to nurse last week with Polyuria Very worried that he is diabetic - confirmed on blood tests. Very amenable to change of lifestyle; no other symptoms at present.<br>Examination: O/E - Diastolic BP reading 98 mmHg. , O/E - Systolic BP reading 152 mmHg.<br>Diagnosis: Type II diabetes mellitus.<br>Procedure: Wants to avoid tabs for the moment - watch TChol as well as HbA1c. Review 1/12.<br>Metformin 500mg tablets - 168 tablets - take one three times a day - Patient has read up on metformin and is keen to start.<br></td>
	</tr>
	<tr>
		<th width=\"150px\">01 Jan 2015 - 15:47</td>
		<th><NAME> - Dr Johnson and Partners (J12345)</td>
	</tr>
	<tr>
		<td width=\"150px\"></td>
		<td>Type II diabetic dietary review.<br>Haemoglobin A1c level - IFCC standardised 20.5 mmol/mol.<br>Insulin isophane biphasic porcine 30/70 100units/ml suspension for injection 10ml vials - 5 vials - use as directed.</td>
	</tr>
	<tr>
		<th width=\"150px\">04 Jul 2015 - 12:10</td>
		<th><NAME> - Dr Johnson and Partners (J12345)</td>
	</tr>
	<tr>
		<td width=\"150px\"></td>
		<td>Contact method: Telephone<br>Care plan created: Diabetes management plan.<br>Haemoglobin A1c level - IFCC standardised 23.5 mmol/mol.</td>
	</tr>
</table>

<h5>Recent Investigations (last 3 months)</h5>
<table  class=\"table table-bordered table-striped table-hover\">
	<tr>
		<th width=\"120px\">12 Mar 2016</td>
		<th>Full blood count</td>
	</tr>
	<tr>
		<td width=\"120px\"></td>
		<td>
			Result indicator: Borderline<br>
			Follow-up action: Make an appointment to see doctor<br>
			No filing comments given.<br>
			<br>
			Date Analysed: 12/03/12<br>
			Time Analysed: 11:22<br>
			Large unstained cell: 0.20 10*9/L<br>
			report 7:nhs003 no errors: 0.427 L/L<br>
			<br>
			<table class=\"innertable\">
				<tr><td>Full blood count</td><td></td><td></td></tr>
				<tr><td>Haemoglobin concentration</td><td></td><td>15.4 g/dL [13 - 17]</td></tr>
				<tr><td>Total white blood count</td><td>Above range</td><td>13.1 10^9/L [4 - 11]</td></tr>
				<tr><td>Platelet count - observation</td><td></td><td>244 10^9/L [150 - 400]</td></tr>
				<tr><td>Neutrophil count</td><td>Above range</td><td>8.5 10^9/L [2 - 7.5]</td></tr>
				<tr><td>Lymphocyte count</td><td></td><td>2.8 10^9/L [1.5 - 4]</td></tr>
				<tr><td>Monocyte count - observation</td><td>Above range</td><td>1.1 10^9/L [0.2 - 1]</td></tr>
				<tr><td>Eosinophil count - observation</td><td>Above range</td><td>0.6 10^9/L [0 - 0.5]</td></tr>
				<tr><td>Basophil count</td><td></td><td>0.1 10^9/L [0 - 0.1]</td></tr>
				<tr><td>Red blood cell count</td><td>Above range</td><td>5.75 10^12/L [4.5 - 5.5]</td></tr>
				<tr><td>Packed cell volume</td><td></td><td>0.465  [0.4 - 0.5]</td></tr>
				<tr><td>Mean cell volume</td><td></td><td>80.9 fL [80 - 100]</td></tr>
				<tr><td>Mean cell haemoglobin level</td><td>Below range</td><td>26.8 pg [27 - 32]</td></tr>
				<tr><td>Mean cell haemoglobin concentration</td><td></td><td>33.1 g/dL [32 - 36]</td></tr>
			</table>
		</td>
	</tr>
	<tr>
		<th width=\"120px\">23 Jan 2016</td>
		<th>Serum TSH level</td>
	</tr>
	<tr>
		<td width=\"120px\"></td>
		<td>
			Result indicator: Normal<br>
			No further action required.<br>
			No filing comments given.<br>
			<br>
			Clinical Information: Clinical Details: THYROXINE<br>
			<br>
			<table class=\"innertable\">
				<tr><td>Serum TSH level</td><td></td><td>1.5 miu/L [0.2 - 4]<br>TSH level is consistent with optimum replacement<br>NB above comment applies only to patients on T4 for<br>treatment of primary hypothyroidism.<br>Treatment target in CA Thyroid is TSH <0.10 mU/L</td></tr>
			</table>
		</td>
	</tr>
</table>
",
  "TPP"
);
{'fraction_non_alphanumeric': 0.21106587174640104, 'fraction_numerical': 0.06478115457321507, 'mean_word_length': 3.700956937799043, 'pattern_counts': {'":': 0, '<': 877, '<?xml version=': 0, '>': 875, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '6892862', 'n_tokens_mistral': 6691, 'n_tokens_neox': 5593, 'n_words': 1345}