Age group data warehouse reconciliation

On this date*

Membership on January 23, 2026 cooked four different ways

  • Membership (method: meta): 1178
  • Membership (method: eagles): 1178
  • Membership (method: mcfly): 1171
  • Membership (method: cher): 1145

Differences

  • Subsequent rejoiners (eagles minus mcfly) = 7
  • Late renewals (mcfly minus cher) = 26

People who rejoined the club after January 23, 2026

NameAGMember
since
Member
until
Last Event
before 23-Jan-26
Last Event
date
Last Event
expired
Hanneke PouwF302025-01-222026-01-23lapsed2026-01-221970-01-01
Katherine RogersF302023-08-072026-12-19lapsed2025-12-191970-01-01
Tracey AllumF502021-11-172026-11-22lapsed2025-11-171970-01-01
Ciara McElligottF552023-11-252026-11-25lapsed2025-11-251970-01-01
Karen FosterF602022-10-272026-10-27lapsed2025-10-271970-01-01
Alessandro PaolucciM302022-06-112026-11-28lapsed2025-11-281970-01-01
Alexandre BernigaudM502011-09-172026-12-17lapsed2024-12-172024-11-27

7 members

Number of rejoiners (should match eagles minus mcfly) : 7

Late renewals after January 23, 2026

NameAGMember
since
Member
until
Last Event
before 23-Jan-26
Last Event
date
Last Event
expired
Billie McCloskyF182025-04-252026-04-25joined2025-04-252025-07-15
Zoe WelzF182025-11-202026-11-20joined2025-11-202026-01-01
Lina AmbrulevičiūtėF352023-05-212027-05-21free renewal2024-05-212025-05-21
Nicola KayeF452006-10-172026-12-25renewal2024-12-042025-12-25
Mairi McInnesF452018-01-102026-04-10free renewal2024-04-102025-04-10
Lindsey ChiswickF452020-07-122026-07-12free renewal2024-07-122025-07-12
Veronique LeroyF552015-03-102027-06-10renewal2024-05-202025-06-10
Joanna ConnF552002-09-172027-06-01free renewal2024-06-012025-06-01
Anne BennettF552007-07-292027-10-29free renewal2024-10-292025-10-29
Rachel BedfordF552017-02-252028-01-11free renewal2024-12-282026-01-11
Helen LaneF602021-11-122026-11-12rejoined2025-10-222025-10-22
Freddie BeresfordM182025-11-192026-11-19joined2025-11-192026-01-01
Sahil ShirazeeM182024-02-252026-05-20joined2024-02-252025-02-25
Alessandro Giorgio CarelliM302023-09-232026-09-23rejoined2025-09-022025-09-02
Derik EvangelistaM352023-12-012026-12-02renewal2024-11-272025-12-01
Hans HoM402009-01-212026-04-21free renewal2025-01-212026-01-21
Frank WomelsdorfM452014-04-172026-07-17rejoined2025-06-262025-06-26
Hugh TorryM452006-06-142026-09-14renewal2024-09-152025-09-14
Rene PetersM452020-10-012026-10-22renewal2024-10-012025-10-01
Karl HamiltonM452012-04-162027-07-16free renewal2024-07-162025-07-16
Gabriel HopkinsM502006-08-092026-11-09rejoined2025-10-192025-10-19
Stefano PardiM502010-07-232026-10-23rejoined2025-10-022025-10-02
Imran AhmedM552006-02-242026-09-29free renewal2024-09-292025-09-29
Andrew RobertsM702010-10-222027-01-22rejoined2026-01-012026-01-01
Robert MaslenM752002-02-252026-09-01rejoined2025-08-112025-08-11
John GibsonM752003-10-142027-01-14rejoined2025-12-242025-12-24

26 members

Number of late renewals (should match mcfly minus cher) : 26

Missing date of birth or gender

NameAGMember
since
Member
until
Last Event
before 23-Jan-26
Last Event
date
Last Event
expired

0 members

Number of people missing date of birth or gender : 0

Missing from the data warehouse

NameAGMember
since
Member
until
Last Event
before 23-Jan-26
Last Event
date
Last Event
expired

0 members

Number of people in the membership database but missing from the dw : 0