Skip to main content

Table 1 Number of true and false matches made between image and Patient Management System records within each practice by each rule when compared to manual matching after step 1. True positive and false positive rates provided in brackets

From: Novel linkage approach to join community-acquired and national data

Practice (number of patients)

Match step

True positive (rate)

True negative

False positive (rate)

False negative

Number of images

Practice #1 (2,339)

      
 

1

18,699 (0.859)

4,890

0

(0)

3,079

26,668

 

2

19,338 (0.888)

4,881

0

(0)

2,449

26,668

 

3

20,696 (0.95)

4,881

0

(0)

1,091

26,668

 

4

20,735 (0.951)

4,866

0

(0)

1,067

26,668

 

5

21,495 (0.986)

4,823

43 (0.009)

307

26,668

 

6

21,547 (0.988)

4,788

78 (0.016)

255

26,668

Practice #2 (309)

      
 

1

1,003 (0.836)

803

0

(0)

197

2,003

 

2

1,043 (0.869)

803

0

(0)

157

2,003

 

3

1,133 (0.944)

803

0

(0)

67

2,003

 

4

1,133 (0.944)

803

0

(0)

67

2,003

 

5

1,155 (0.963)

803

0

(0)

45

2,003

 

6

1,185 (0.988)

803

0

(0)

15

2,003

Practice #3 (133)

      
 

1

247 (0.911)

5

0

(0)

24

276

 

2

249 (0.919)

5

0

(0)

22

276

 

3

263

(0.97)

5

0

(0)

8

276

 

4

263

(0.97)

5

0

(0)

8

276

 

5

266 (0.982)

5

0

(0)

5

276

 

6

269

(0.993)

5

0

(0)

2

276

  1. Match steps:
  2. 1. Exact forename, surname and DOB
  3. 2. Exact forename and surname, DOB error tolerated
  4. 3. Exact DOB, Soundex forename and surname
  5. 4. Soundex match on forename and surname with DOB error tolerated
  6. 5. Exact DOB and surname, LCS forename < 6
  7. 6. Exact DOB and forename, LCS surname < 6
  8. True positive rate = true positive / (true positive + false negative)
  9. False positive rate = false positive / (false positive + true negative)