LOCK TABLES poc_legacy.patients WRITE;

INSERT INTO poc_legacy.patients
  (id,    title,   first_name,   last_name,       address_1,                              address_2,            address_3,            postcode,   phone,              date_of_birth,       gender,    nhs_number,  pas_number,   department_id, gp_id)
VALUE
  (1,     'Mr',    'Ivor',       'Cox',           '6948 Et St.',                          'Halesowen',          'Worcestershire',     'VX27 5DV', '(011981) 32362',   DATE('1944-06-06'),  'Male',    9999999000,  352541,       1,             1),
  (2,     'Mr',    'Ivor',       'Cox',           'Ap #126-6226 Mi. St.',                 'Oakham',             'Rutland',            'XM9 4RF',  '(0112) 740 5408',  DATE('1944-06-06'),  'Male',    9999999001,  623454,       1,             2),
  (3,     'Mr',    'Aengus',     'O''Sullivan',   '22',                                   'Douglas Road',       'Cork',               'CK',       '0800 1111',        DATE('1937-09-28'),  'Male',    9999999002,  346574,       3,             3),
  (4,     'Ms',    'Emma',       'Gallagher',     '40',                                   'High Street',        'Dublin',             'D8',       '07624 647524',     DATE('1980-02-03'),  'Female',  9999999003,  332546,       1,             4),
  (5,     'Mr',    'Philip',     'O''Connor',     '60',                                   'SandyMill Road',     'Galway',             'GW',       '0964 934 2028',    DATE('1958-05-14'),  'Male',    9999999004,  345267,       3,             5),
  (6,     'Mr',    'Rashad',     'Hill',          '288-6235 Odio. Street',                'Stockton-on-Tees',   'Durham',             'GF7 2OE',  '0909 764 2554',    DATE('1952-02-19'),  'Male',    9999999005,  798311,       3,             6),
  (7,     'Mrs',   'Ezra',       'Gordon',        'P.O. Box 711, 8725 Purus Rd.',         'Grangemouth',        'Stirlingshire',      'B4 8MW',   '070 6691 5178',    DATE('1958-06-24'),  'Male',    9999999006,  595941,       4,             7),
  (8,     'Mrs',   'Blair',      'Wells',         '783-2544 Cursus, Ave',                 'Lerwick',            'Shetland',           'H2 6HJ',   '(01141) 56013',    DATE('1969-01-31'),  'Female',  9999999007,  841652,       4,             8),
  (9,     'Mr',    'Cian',       'Magee',         '50',                                   'High Hill',          'Cork',               'CK',       '(026) 5155 5992',  DATE('1938-06-26'),  'Male',    9999999008,  685412,       4,             9),
  (10,    'Mrs',   'Nora',       'Kelly',         '80',                                   'Low Street',         'Dublin',             'D8',       '(016977) 0472',    DATE('1981-06-05'),  'Female',  9999999009,  584849,       2,             10),
  (11,    'Ms',    'Briana',     'Nolan',         '40',                                   'High Hill',          'Dublin',             'D8',       '(01970) 784490',   DATE('1971-06-25'),  'Female',  9999999010,  556631,       1,             11),
  (12,    'Mr',    'Hilda',      'Aguirre',       '9460 Sit Av.',                         'Marlborough',        'Wiltshire',          'V15 5FL',  '(0101) 279 8943',  DATE('1986-12-10'),  'Female',  9999999011,  645154,       1,             12),
  (13,    'Mr',    'Cameron',    'Monroe',        'P.O. Box 785, 1144 Erat. Rd.',         'Ludlow',             'Shropshire',         'GI1 8ZR',  '076 5024 5403',    DATE('1946-10-04'),  'Female',  9999999012,  984313,       2,             13),
  (14,    'Mr',    'Kuame',      'Thompson',      'P.O. Box 649, 8307 Sit Rd.',           'Cawdor',             'Nairnshire',         'GL74 9RY', '0800 252 0881',    DATE('1973-03-14'),  'Female',  9999999013,  416166,       3,             14),
  (15,    'Mr',    'Stewart',    'Lynch',         'Ap #540-9476 Nec Avenue',              'Alva',               'Stirlingshire',      'W9J 7NB',  '056 5661 0225',    DATE('1949-10-12'),  'Female',  9999999014,  641515,       3,             15),
  (16,    'Mr',    'Hashim',     'Booth',         'P.O. Box 301, 6944 Sapien, St.',       'Bradford',           'Yorkshire',          'WZ8 4PM',  '0353 893 7620',    DATE('1992-11-08'),  'Female',  9999999015,  949461,       3,             16),
  (17,    'Mrs',   'Gregory',    'Dillard',       'Ap #728-3451 Dapibus St.',             'Forfar',             'Angus',              'R12 7RK',  '(025) 5608 1829',  DATE('1975-12-27'),  'Female',  9999999016,  994512,       4,             17),
  (18,    'Ms',    'Marian',     'Kelly',         '91',                                   'Douglas Road',       'Dublin',             'D8',       '(0113) 310 6232',  DATE('1970-07-14'),  'Female',  9999999017,  684135,       1,             18),
  (19,    'Mr',    'John',       'Flanagan',      '94',                                   'High Hill',          'Galway',             'GW',       '0800 970 8555',    DATE('1984-07-06'),  'Male',    9999999018,  943513,       5,             19),
  (20,    'Mrs',   'Rachel',     'Walsh',         '34',                                   'Summer Hill',        'Dublin',             'D8',       '(01326) 24257',    DATE('1944-12-19'),  'Female',  9999999019,  684351,       1,             20),
  (21,    'Mr',    'Lysandra',   'Nash',          'P.O. Box 691, 4675 Dictum Rd.',        'Stevenage',          'Hertfordshire',      'AI2 8YN',  '0800 1111',        DATE('1986-08-01'),  'Male',    9999999020,  913513,       1,             21),
  (22,    'Mrs',   'Murphy',     'Baird',         '810-6061 Ridiculus Avenue',            'Whitburn',           'West Lothian',       'SL2 2II',  '0800 320 3878',    DATE('1983-06-12'),  'Male',    9999999021,  984511,       1,             22),
  (23,    'Mrs',   'Orli',       'Robertson',     'Ap #886-8741 Mauris Street',           'Brighton',           'Sussex',             'H31 1VR',  '0819 258 9104',    DATE('1990-01-11'),  'Female',  9999999022,  986413,       2,             23),
  (24,    'Ms',    'Jill',       'Maguire',       '40',                                   'SandyMill Road',     'Dublin',             'D8',       '0845 46 42',       DATE('1962-05-13'),  'Female',  9999999023,  651144,       1,             24),
  (25,    'Mr',    'Aengus',     'O''Connor',     '26',                                   'High Street',        'Limerick',           'LK',       '(016977) 1616',    DATE('1938-02-19'),  'Male',    9999999024,  984354,       4,             25),
  (26,    'Ms',    'Mary',       'Smith',         '2',                                    'Summer Hill',        'Dublin',             'D8',       '0800 517 2480',    DATE('1988-12-30'),  'Female',  9999999025,  643133,       2,             26),
  (27,    'Mr',    'Gabriel',    'Pickett',       '511-1090 Sapien. St.',                 'Balfour',            'Orkney',             'QZ9L 5AT', '0800 1111',        DATE('1979-10-16'),  'Female',  9999999026,  843513,       4,             27),
  (28,    'Mr',    'Ryder',      'Guy',           'P.O. Box 442, 1830 Torquent St.',      'Armadale',           'West Lothian',       'T90 9LX',  '0800 1111',        DATE('1992-04-13'),  'Male',    9999999027,  894351,       4,             28),
  (29,    'Ms',    'Emma',       'Gallagher',     '39',                                   'Douglas Road',       'Dublin',             'D8',       '0845 46 41',       DATE('1948-09-08'),  'Female',  9999999028,  986413,       1,             29),
  (30,    'Mrs',   'Jill',       'Moynihan',      '45',                                   'Talbot Road',        'Dublin',             'D8',       '0845 46 45',       DATE('1960-02-05'),  'Female',  9999999029,  213513,       2,             30),
  (31,    'Ms',    'Mary',       'Kelly',         '45',                                   'SeaView Road',       'Dublin',             'D8',       '(01375) 543488',   DATE('1948-12-05'),  'Female',  9999999030,  984313,       2,             31),
  (32,    'Mrs',   'Malachi',    'Patel',         '5544 Ante, Street',                    'Hamilton',           'Lanarkshire',        'N06 5LP',  '0800 1111',        DATE('1961-02-04'),  'Male',    9999999031,  897454,       1,             32),
  (33,    'Mr',    'Tara',       'Booker',        '616-9384 Mauris Rd.',                  'Northampton',        'Northamptonshire',   'ZY9 2KM',  '(013047) 21772',   DATE('1944-02-20'),  'Male',    9999999032,  987684,       2,             33),
  (34,    'Mrs',   'Deborah',    'Wyatt',         '4872 Cubilia St.',                     'Port Glasgow',       'Renfrewshire',       'TQ3J 4JG', '(016977) 0130',    DATE('1965-10-16'),  'Female',  9999999033,  987677,       3,             34),
  (35,    'Mrs',   'Doris',      'Santana',       'Ap #491-7493 Donec Ave',               'Newport',            'Hampshire',          'JB48 4EL', '(01774) 13491',    DATE('1933-05-29'),  'Female',  9999999034,  955888,       3,             35),
  (36,    'Mr',    'Hadley',     'Peterson',      '7673 Luctus St.',                      'Edinburgh',          'Midlothian',         'OS65 6FU', '0800 1111',        DATE('1980-12-05'),  'Female',  9999999035,  561538,       3,             36),
  (37,    'Mrs',   'Desiree',    'Mercer',        '611-682 Sed Road',                     'Taunton',            'Somerset',           'Y92 1WA',  '(020) 1287 4390',  DATE('1933-10-20'),  'Male',    9999999036,  684337,       4,             37),
  (38,    'Mr',    'Cassandra',  'Workman',       'Ap #806-2884 Enim St.',                'Auldearn',           'Nairnshire',         'V4F 9GJ',  '(0112) 758 9967',  DATE('1948-03-05'),  'Male',    9999999037,  845412,       4,             38),
  (39,    'Mrs',   'Bryar',      'Hendricks',     '549-6333 Magna Street',                'Scalloway',          'Shetland',           'KF3 8IO',  '056 6233 3741',    DATE('1976-08-17'),  'Female',  9999999038,  815182,       4,             39),
  (40,    'Mr',    'Faolan',     'Whelan',        '57',                                   'Mallow View',        'Cork',               'CK',       '076 9753 9230',    DATE('1928-12-14'),  'Male',    9999999039,  845216,       4,             40),
  (41,    'Mrs',   'Maria',      'Kelly',         '48',                                   'Douglas Road',       'Dublin',             'D8',       '0800 1111',        DATE('1968-03-14'),  'Female',  9999999040,  396641,       5,             41),
  (42,    'Mrs',   'Rachel',     'Smith',         '45',                                   'Douglas Road',       'Dublin',             'D8',       '0500 070749',      DATE('1974-09-18'),  'Female',  9999999041,  843311,       1,             42),
  (43,    'Mr',    'Cian',       'McGowan',       '27',                                   'Talbot Road',        'Cork',               'CK',       '0845 46 49',       DATE('1982-06-18'),  'Male',    9999999042,  845141,       3,             43),
  (44,    'Mrs',   'Karly',      'Pennington',    '7444 Eget Rd.',                        'Tillicoultry',       'Clackmannanshire',   'XH8 5GC',  '(016977) 1873',    DATE('1974-02-20'),  'Female',  9999999043,  843135,       3,             44),
  (45,    'Mr',    'Ali',        'Savage',        'P.O. Box 162, 6180 Dui. St.',          'Wick',               'Caithness',          'OE7 0XY',  '(016977) 9167',    DATE('1945-03-15'),  'Male',    9999999044,  984331,       3,             45),
  (46,    'Mr',    'McKenzie',   'Pace',          'P.O. Box 296, 2896 Placerat Road',     'Swindon',            'Wiltshire',          'H5B 9VT',  '07662 731734',     DATE('1966-11-27'),  'Female',  9999999045,  986431,       3,             46),
  (47,    'Mr',    'Eoghan',     'Murphy',        '38',                                   'Douglas Road',       'Cork',               'CK',       '07304 240742',     DATE('1953-09-14'),  'Male',    9999999046,  345484,       4,             47),
  (48,    'Ms',    'Zoe',        'Callaghan',     '20',                                   'SeaView Road',       'Dublin',             'D8',       '0334 839 2867',    DATE('1922-11-15'),  'Female',  9999999047,  329974,       1,             48),
  (49,    'Mrs',   'Jonah',      'Mccall',        'Ap #188-3148 Vel St.',                 'Abergele',           'Denbighshire',       'CV25 8ET', '0800 803158',      DATE('1992-09-05'),  'Male',    9999999048,  641314,       4,             49),
  (50,    'Mr',    'Carol',      'Griffith',      'Ap #420-1668 Interdum Ave',            'Kilmarnock',         'Ayrshire',           'ZO2U 6IY', '055 8108 4579',    DATE('1927-07-03'),  'Male',    9999999049,  684318,       4,             50),
  (51,    'Mrs',   'Avram',      'Miller',        'Ap #804-4028 Phasellus Rd.',           'Ely',                'Cambridgeshire',     'GU67 5CN', '0845 46 47',       DATE('1974-01-25'),  'Female',  9999999050,  343941,       5,             51),
  (52,    'Mr',    'Yael',       'Mcfadden',      '3250 Eu, Ave',                         'Crewe',              'Cheshire',           'E4U 1RG',  '0800 1111',        DATE('1946-01-14'),  'Female',  9999999051,  841531,       1,             52),
  (53,    'Ms',    'Fiona',      'O''Brien',      '95',                                   'SeaView Road',       'Dublin',             'D8',       '(01768) 59771',    DATE('1925-03-11'),  'Female',  9999999052,  686413,       2,             53),
  (54,    'Mr',    'Donal',      'Smith',         '39',                                   'Mallow View',        'Cork',               'CK',       '0500 717497',      DATE('1948-04-05'),  'Male',    9999999053,  843511,       3,             54),
  (55,    'Mrs',   'Jill',       'O''Brien',      '52',                                   'Talbot Road',        'Dublin',             'D8',       '0321 837 1197',    DATE('1957-11-14'),  'Female',  9999999054,  684138,       2,             55),
  (56,    'Mrs',   'Xandra',     'Summers',       'Ap #201-1423 Pretium Road',            'Hemel Hempstead',    'Hertfordshire',      'DC05 9IQ', '0845 46 47',       DATE('1947-04-22'),  'Female',  9999999055,  684311,       3,             56),
  (57,    'Mrs',   'Hasad',      'Everett',       '241-8659 Metus Avenue',                'Wigtown',            'Wigtownshire',       'A0Y 3OZ',  '(019194) 78089',   DATE('1973-07-31'),  'Male',    9999999056,  941344,       4,             57),
  (58,    'Mr',    'Roary',      'Nixon',         'P.O. Box 652, 2912 Non, Street',       'Tullibody',          'Clackmannanshire',   'ZG4 7RA',  '(016516) 39348',   DATE('1952-03-27'),  'Female',  9999999057,  864613,       4,             58),
  (59,    'Mr',    'Unity',      'Lawrence',      'Ap #801-9623 Risus Ave',               'Corby',              'Northamptonshire',   'WL46 6RW', '076 5167 2508',    DATE('1955-05-30'),  'Male',    9999999058,  846513,       4,             59),
  (60,    'Mr',    'Aretha',     'Hobbs',         '2092 Nullam Avenue',                   'Milton Keynes',      'Buckinghamshire',    'P4S 6GM',  '(0115) 011 9130',  DATE('1922-12-29'),  'Male',    9999999059,  313515,       4,             60),
  (61,    'Mrs',   'Aubrey',     'Gallegos',      '2262 Aliquet. Street',                 'Appleby',            'Westmorland',        'V2 2IP',   '07624 328862',     DATE('1928-03-17'),  'Male',    9999999060,  941347,       5,             61),
  (62,    'Mr',    'Aaron',      'Christian',     '3868 Cras St.',                        'Weston-super-Mare',  'Somerset',           'A3 9HD',   '(01331) 241623',   DATE('1947-01-27'),  'Male',    9999999061,  897431,       1,             62),
  (63,    'Mrs',   'Charissa',   'Spence',        'P.O. Box 357, 2465 Et, St.',           'Roxburgh',           'Roxburghshire',      'S1 0UW',   '(01534) 156770',   DATE('1994-07-30'),  'Female',  9999999062,  865115,       2,             63),
  (64,    'Mr',    'Oscar',      'Hubbard',       'P.O. Box 490, 1037 In Street',         'Cwmbran',            'Monmouthshire',      'HV6 6TC',  '0895 189 1046',    DATE('1969-11-18'),  'Female',  9999999063,  513154,       3,             64),
  (65,    'Mrs',   'Rashad',     'Lindsey',       'Ap #266-6265 Tempor Road',             'Whithorn',           'Wigtownshire',       'M4 2KW',   '07755 838533',     DATE('1954-10-17'),  'Female',  9999999064,  684154,       3,             65),
  (66,    'Mrs',   'Eagan',      'Zamora',        '675-4750 Cursus Rd.',                  'Sutton',             'Surrey',             'VN09 3ZN', '(016977) 7133',    DATE('1947-01-26'),  'Male',    9999999065,  584134,       3,             66),
  (67,    'Ms',    'Emma',       'O''Brien',      '53',                                   'Talbot Road',        'Dublin',             'D8',       '056 3920 1956',    DATE('1989-11-02'),  'Female',  9999999066,  651598,       1,             67),
  (68,    'Mr',    'Jim',        'Murphy',        '28',                                   'Low Street',         'Cork',               'CK',       '0800 669413',      DATE('1935-08-13'),  'Male',    9999999067,  318494,       3,             68),
  (69,    'Mr',    'Luke',       'Smith',         '2',                                    'Rossington St',      'Leeds',              'LS2 8HD',  '(0113) 222 4401',  DATE('1956-09-07'),  'Male',    9999999068,  864318,       4,             69),
  (70,    'Ms',    'Ciara',      'MacAuley',      '60',                                   'SeaView Road',       'Dublin',             'D8',       '(01852) 01318',    DATE('1989-01-02'),  'Female',  9999999069,  651545,       2,             70),
  (71,    'Mr',    'Dante',      'Maddox',        '7305 Est Avenue',                      'Glossop',            'Derbyshire',         'R03 3JH',  '07376 394887',     DATE('1998-02-15'),  'Female',  9999999070,  684315,       5,             71),
  (72,    'Mr',    'Beck',       'Mcdonald',      'P.O. Box 264, 2288 Accumsan Rd.',      'Prestatyn',          'Flintshire',         'A6E 6DM',  '(020) 1301 9581',  DATE('1958-07-03'),  'Male',    9999999071,  896451,       1,             72),
  (73,    'Mr',    'Shellie',    'Cain',          '5742 Facilisi. Av.',                   'Bathgate',           'West Lothian',       'E9 5XL',   '076 2031 1395',    DATE('1956-10-17'),  'Female',  9999999072,  986413,       2,             73),
  (74,    'Mrs',   'Geoffrey',   'Puckett',       'Ap #124-8251 Morbi Road',              'West Ham',           'Essex',              'KC75 7ZB', '055 0916 7547',    DATE('1977-09-12'),  'Male',    9999999073,  684354,       3,             74),
  (75,    'Mr',    'Cade',       'Heath',         '233-6719 Nec, Avenue',                 'Campbeltown',        'Argyllshire',        'X60 3CB',  '(016977) 8525',    DATE('1943-03-08'),  'Male',    9999999074,  986433,       3,             75),
  (76,    'Mrs',   'Sylvester',  'Wong',          '264-7700 Aenean Rd.',                  'Sromness',           'Orkney',             'Y6 2GQ',   '0816 939 6772',    DATE('1939-04-29'),  'Female',  9999999075,  684434,       3,             76),
  (77,    'Mr',    'Tim',        'Madden',        '3',                                    'SeaView Road',       'Galway',             'GW',       '0890 902 2134',    DATE('1998-07-21'),  'Male',    9999999076,  894313,       4,             77),
  (78,    'Mr',    'Faolan',     'Kelly',         '12',                                   'Talbot Road',        'Galway',             'GW',       '0809 641 0596',    DATE('1995-03-16'),  'Male',    9999999077,  864513,       4,             78),
  (79,    'Mr',    'Grace',      'Mcleod',        '6271 Bibendum Av.',                    'Oban',               'Argyllshire',        'YY9L 6SF', '0800 423784',      DATE('1983-02-04'),  'Female',  9999999078,  354681,       4,             79),
  (80,    'Mrs',   'Ivy',        'Nunez',         'P.O. Box 931, 4311 Vel Street',        'Basingstoke',        'Hampshire',          'DR0 8TD',  '(01515) 20694',    DATE('1986-12-30'),  'Male',    9999999079,  861314,       4,             80),
  (81,    'Mrs',   'Kato',       'Shaw',          '2924 Pretium Av.',                     'Camborne',           'Cornwall',           'J1 3AM',   '07624 601614',     DATE('1969-07-19'),  'Male',    9999999080,  684131,       5,             81),
  (82,    'Mr',    'Yvette',     'Melendez',      'Ap #402-2415 Phasellus Road',          'Folkestone',         'Kent',               'A6I 6RG',  '0800 465805',      DATE('1989-12-27'),  'Male',    9999999081,  198445,       1,             82),
  (83,    'Mrs',   'Fredericka', 'Cox',           'Ap #507-9742 Lorem Avenue',            'Windsor',            'Berkshire',          'ST1 5QO',  '055 7327 4627',    DATE('1948-07-27'),  'Male',    9999999082,  986413,       2,             83),
  (84,    'Mr',    'Cillian',    'Walsh',         '75',                                   'Mallow View',        'Galway',             'GW',       '070 6741 6905',    DATE('1955-01-12'),  'Male',    9999999083,  864147,       3,             84),
  (85,    'Mr',    'Tim',        'Smith',         '84',                                   'Douglas Road',       'Galway',             'GW',       '076 5439 2425',    DATE('1975-09-26'),  'Male',    9999999084,  651534,       3,             85),
  (86,    'Mrs',   'Maria',      'McGowan',       '46',                                   'SandyMill Road',     'Dublin',             'D8',       '(016977) 7671',    DATE('1988-10-22'),  'Female',  9999999085,  584135,       2,             86),
  (87,    'Mr',    'Jack',       'Donnelly',      '82',                                   'SandyMill Road',     'Galway',             'GW',       '0301 776 8869',    DATE('1937-03-30'),  'Male',    9999999086,  854144,       5,             87),
  (88,    'Mrs',   'Clio',       'Cooke',         'P.O. Box 624, 2873 Faucibus Ave',      'Folkestone',         'Kent',               'E56 9BB',  '(01027) 44276',    DATE('1964-03-10'),  'Female',  9999999087,  643133,       4,             88),
  (89,    'Mrs',   'Aiko',       'Haney',         '323-4504 Tempus Av.',                  'Bedford',            'Bedfordshire',       'U9K 6GK',  '(012913) 24672',   DATE('1954-07-29'),  'Female',  9999999088,  841351,       4,             89),
  (90,    'Mr',    'Marcia',     'Hicks',         'Ap #545-9425 Donec St.',               'Tiverton',           'Devon',              'TR1 5VH',  '07954 694224',     DATE('1962-05-03'),  'Male',    9999999089,  653518,       4,             90),
  (91,    'Mrs',   'Dante',      'Roth',          'P.O. Box 416, 1038 Nullam Street',     'Laurencekirk',       'Kincardineshire',    'BB1 8NV',  '076 9759 9831',    DATE('1998-03-13'),  'Female',  9999999090,  964154,       5,             91),
  (92,    'Mr',    'Zephr',      'Mccarthy',      '390-7981 Lorem Rd.',                   'Clackmannan',        'Clackmannanshire',   'P3O 4EL',  '(01649) 794806',   DATE('1950-06-25'),  'Female',  9999999091,  684344,       1,             92),
  (93,    'Mrs',   'Cassidy',    'Wood',          'Ap #166-824 Risus. Ave',               'Tewkesbury',         'Gloucestershire',    'JA2 2DM',  '07624 844651',     DATE('1970-02-19'),  'Male',    9999999092,  864313,       2,             93),
  (94,    'Mr',    'James',      'Kelly',         '44',                                   'Mallow View',        'Limerick',           'LK',       '076 2969 2315',    DATE('1995-11-18'),  'Male',    9999999093,  843147,       5,             94),
  (95,    'Ms',    'Marian',     'O''Brien',      '72',                                   'Summer Hill',        'Dublin',             'D8',       '(015144) 77262',   DATE('1936-11-04'),  'Female',  9999999094,  684311,       2,             95),
  (96,    'Mr',    'Shoshana',   'Hewitt',        '1986 Integer Road',                    'Northampton',        'Northamptonshire',   'TC05 0BW', '070 7594 8865',    DATE('1978-06-14'),  'Male',    9999999095,  241843,       3,             96),
  (97,    'Mrs',   'Sade',       'Bowman',        'Ap #163-4448 Nunc. Rd.',               'Bracknell',          'Berkshire',          'L9 5NF',   '07977 658224',     DATE('1954-02-04'),  'Female',  9999999096,  841867,       4,             97),
  (98,    'Mr',    'Alexis',     'Greer',         '741-7482 Cras Street',                 'Kilsyth',            'Stirlingshire',      'LW5 1HC',  '0800 719 4863',    DATE('1941-03-23'),  'Female',  9999999097,  845135,       4,             98),
  (99,    'Mrs',   'Sarah',      'Fuentes',       'Ap #634-1630 Rutrum Road',             'Annan',              'Dumfriesshire',      'KT3 9HI',  '0500 772606',      DATE('1992-11-09'),  'Female',  9999999098,  864177,       4,             99);

UNLOCK TABLES;