| 1 | LOCK TABLES poc_legacy.patients WRITE;
|
| 2 |
|
| 3 | INSERT INTO poc_legacy.patients
|
| 4 | (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)
|
| 5 | VALUE
|
| 6 | (1, 'Mr', 'Ivor', 'Cox', '6948 Et St.', 'Halesowen', 'Worcestershire', 'VX27 5DV', '(011981) 32362', DATE('1944-06-06'), 'Male', 9999999000, 352541, 1, 1),
|
| 7 | (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),
|
| 8 | (3, 'Mr', 'Aengus', 'O''Sullivan', '22', 'Douglas Road', 'Cork', 'CK', '0800 1111', DATE('1937-09-28'), 'Male', 9999999002, 346574, 3, 3),
|
| 9 | (4, 'Ms', 'Emma', 'Gallagher', '40', 'High Street', 'Dublin', 'D8', '07624 647524', DATE('1980-02-03'), 'Female', 9999999003, 332546, 1, 4),
|
| 10 | (5, 'Mr', 'Philip', 'O''Connor', '60', 'SandyMill Road', 'Galway', 'GW', '0964 934 2028', DATE('1958-05-14'), 'Male', 9999999004, 345267, 3, 5),
|
| 11 | (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),
|
| 12 | (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),
|
| 13 | (8, 'Mrs', 'Blair', 'Wells', '783-2544 Cursus, Ave', 'Lerwick', 'Shetland', 'H2 6HJ', '(01141) 56013', DATE('1969-01-31'), 'Female', 9999999007, 841652, 4, 8),
|
| 14 | (9, 'Mr', 'Cian', 'Magee', '50', 'High Hill', 'Cork', 'CK', '(026) 5155 5992', DATE('1938-06-26'), 'Male', 9999999008, 685412, 4, 9),
|
| 15 | (10, 'Mrs', 'Nora', 'Kelly', '80', 'Low Street', 'Dublin', 'D8', '(016977) 0472', DATE('1981-06-05'), 'Female', 9999999009, 584849, 2, 10),
|
| 16 | (11, 'Ms', 'Briana', 'Nolan', '40', 'High Hill', 'Dublin', 'D8', '(01970) 784490', DATE('1971-06-25'), 'Female', 9999999010, 556631, 1, 11),
|
| 17 | (12, 'Mr', 'Hilda', 'Aguirre', '9460 Sit Av.', 'Marlborough', 'Wiltshire', 'V15 5FL', '(0101) 279 8943', DATE('1986-12-10'), 'Female', 9999999011, 645154, 1, 12),
|
| 18 | (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),
|
| 19 | (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),
|
| 20 | (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),
|
| 21 | (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),
|
| 22 | (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),
|
| 23 | (18, 'Ms', 'Marian', 'Kelly', '91', 'Douglas Road', 'Dublin', 'D8', '(0113) 310 6232', DATE('1970-07-14'), 'Female', 9999999017, 684135, 1, 18),
|
| 24 | (19, 'Mr', 'John', 'Flanagan', '94', 'High Hill', 'Galway', 'GW', '0800 970 8555', DATE('1984-07-06'), 'Male', 9999999018, 943513, 5, 19),
|
| 25 | (20, 'Mrs', 'Rachel', 'Walsh', '34', 'Summer Hill', 'Dublin', 'D8', '(01326) 24257', DATE('1944-12-19'), 'Female', 9999999019, 684351, 1, 20),
|
| 26 | (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),
|
| 27 | (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),
|
| 28 | (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),
|
| 29 | (24, 'Ms', 'Jill', 'Maguire', '40', 'SandyMill Road', 'Dublin', 'D8', '0845 46 42', DATE('1962-05-13'), 'Female', 9999999023, 651144, 1, 24),
|
| 30 | (25, 'Mr', 'Aengus', 'O''Connor', '26', 'High Street', 'Limerick', 'LK', '(016977) 1616', DATE('1938-02-19'), 'Male', 9999999024, 984354, 4, 25),
|
| 31 | (26, 'Ms', 'Mary', 'Smith', '2', 'Summer Hill', 'Dublin', 'D8', '0800 517 2480', DATE('1988-12-30'), 'Female', 9999999025, 643133, 2, 26),
|
| 32 | (27, 'Mr', 'Gabriel', 'Pickett', '511-1090 Sapien. St.', 'Balfour', 'Orkney', 'QZ9L 5AT', '0800 1111', DATE('1979-10-16'), 'Female', 9999999026, 843513, 4, 27),
|
| 33 | (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),
|
| 34 | (29, 'Ms', 'Emma', 'Gallagher', '39', 'Douglas Road', 'Dublin', 'D8', '0845 46 41', DATE('1948-09-08'), 'Female', 9999999028, 986413, 1, 29),
|
| 35 | (30, 'Mrs', 'Jill', 'Moynihan', '45', 'Talbot Road', 'Dublin', 'D8', '0845 46 45', DATE('1960-02-05'), 'Female', 9999999029, 213513, 2, 30),
|
| 36 | (31, 'Ms', 'Mary', 'Kelly', '45', 'SeaView Road', 'Dublin', 'D8', '(01375) 543488', DATE('1948-12-05'), 'Female', 9999999030, 984313, 2, 31),
|
| 37 | (32, 'Mrs', 'Malachi', 'Patel', '5544 Ante, Street', 'Hamilton', 'Lanarkshire', 'N06 5LP', '0800 1111', DATE('1961-02-04'), 'Male', 9999999031, 897454, 1, 32),
|
| 38 | (33, 'Mr', 'Tara', 'Booker', '616-9384 Mauris Rd.', 'Northampton', 'Northamptonshire', 'ZY9 2KM', '(013047) 21772', DATE('1944-02-20'), 'Male', 9999999032, 987684, 2, 33),
|
| 39 | (34, 'Mrs', 'Deborah', 'Wyatt', '4872 Cubilia St.', 'Port Glasgow', 'Renfrewshire', 'TQ3J 4JG', '(016977) 0130', DATE('1965-10-16'), 'Female', 9999999033, 987677, 3, 34),
|
| 40 | (35, 'Mrs', 'Doris', 'Santana', 'Ap #491-7493 Donec Ave', 'Newport', 'Hampshire', 'JB48 4EL', '(01774) 13491', DATE('1933-05-29'), 'Female', 9999999034, 955888, 3, 35),
|
| 41 | (36, 'Mr', 'Hadley', 'Peterson', '7673 Luctus St.', 'Edinburgh', 'Midlothian', 'OS65 6FU', '0800 1111', DATE('1980-12-05'), 'Female', 9999999035, 561538, 3, 36),
|
| 42 | (37, 'Mrs', 'Desiree', 'Mercer', '611-682 Sed Road', 'Taunton', 'Somerset', 'Y92 1WA', '(020) 1287 4390', DATE('1933-10-20'), 'Male', 9999999036, 684337, 4, 37),
|
| 43 | (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),
|
| 44 | (39, 'Mrs', 'Bryar', 'Hendricks', '549-6333 Magna Street', 'Scalloway', 'Shetland', 'KF3 8IO', '056 6233 3741', DATE('1976-08-17'), 'Female', 9999999038, 815182, 4, 39),
|
| 45 | (40, 'Mr', 'Faolan', 'Whelan', '57', 'Mallow View', 'Cork', 'CK', '076 9753 9230', DATE('1928-12-14'), 'Male', 9999999039, 845216, 4, 40),
|
| 46 | (41, 'Mrs', 'Maria', 'Kelly', '48', 'Douglas Road', 'Dublin', 'D8', '0800 1111', DATE('1968-03-14'), 'Female', 9999999040, 396641, 5, 41),
|
| 47 | (42, 'Mrs', 'Rachel', 'Smith', '45', 'Douglas Road', 'Dublin', 'D8', '0500 070749', DATE('1974-09-18'), 'Female', 9999999041, 843311, 1, 42),
|
| 48 | (43, 'Mr', 'Cian', 'McGowan', '27', 'Talbot Road', 'Cork', 'CK', '0845 46 49', DATE('1982-06-18'), 'Male', 9999999042, 845141, 3, 43),
|
| 49 | (44, 'Mrs', 'Karly', 'Pennington', '7444 Eget Rd.', 'Tillicoultry', 'Clackmannanshire', 'XH8 5GC', '(016977) 1873', DATE('1974-02-20'), 'Female', 9999999043, 843135, 3, 44),
|
| 50 | (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),
|
| 51 | (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),
|
| 52 | (47, 'Mr', 'Eoghan', 'Murphy', '38', 'Douglas Road', 'Cork', 'CK', '07304 240742', DATE('1953-09-14'), 'Male', 9999999046, 345484, 4, 47),
|
| 53 | (48, 'Ms', 'Zoe', 'Callaghan', '20', 'SeaView Road', 'Dublin', 'D8', '0334 839 2867', DATE('1922-11-15'), 'Female', 9999999047, 329974, 1, 48),
|
| 54 | (49, 'Mrs', 'Jonah', 'Mccall', 'Ap #188-3148 Vel St.', 'Abergele', 'Denbighshire', 'CV25 8ET', '0800 803158', DATE('1992-09-05'), 'Male', 9999999048, 641314, 4, 49),
|
| 55 | (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),
|
| 56 | (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),
|
| 57 | (52, 'Mr', 'Yael', 'Mcfadden', '3250 Eu, Ave', 'Crewe', 'Cheshire', 'E4U 1RG', '0800 1111', DATE('1946-01-14'), 'Female', 9999999051, 841531, 1, 52),
|
| 58 | (53, 'Ms', 'Fiona', 'O''Brien', '95', 'SeaView Road', 'Dublin', 'D8', '(01768) 59771', DATE('1925-03-11'), 'Female', 9999999052, 686413, 2, 53),
|
| 59 | (54, 'Mr', 'Donal', 'Smith', '39', 'Mallow View', 'Cork', 'CK', '0500 717497', DATE('1948-04-05'), 'Male', 9999999053, 843511, 3, 54),
|
| 60 | (55, 'Mrs', 'Jill', 'O''Brien', '52', 'Talbot Road', 'Dublin', 'D8', '0321 837 1197', DATE('1957-11-14'), 'Female', 9999999054, 684138, 2, 55),
|
| 61 | (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),
|
| 62 | (57, 'Mrs', 'Hasad', 'Everett', '241-8659 Metus Avenue', 'Wigtown', 'Wigtownshire', 'A0Y 3OZ', '(019194) 78089', DATE('1973-07-31'), 'Male', 9999999056, 941344, 4, 57),
|
| 63 | (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),
|
| 64 | (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),
|
| 65 | (60, 'Mr', 'Aretha', 'Hobbs', '2092 Nullam Avenue', 'Milton Keynes', 'Buckinghamshire', 'P4S 6GM', '(0115) 011 9130', DATE('1922-12-29'), 'Male', 9999999059, 313515, 4, 60),
|
| 66 | (61, 'Mrs', 'Aubrey', 'Gallegos', '2262 Aliquet. Street', 'Appleby', 'Westmorland', 'V2 2IP', '07624 328862', DATE('1928-03-17'), 'Male', 9999999060, 941347, 5, 61),
|
| 67 | (62, 'Mr', 'Aaron', 'Christian', '3868 Cras St.', 'Weston-super-Mare', 'Somerset', 'A3 9HD', '(01331) 241623', DATE('1947-01-27'), 'Male', 9999999061, 897431, 1, 62),
|
| 68 | (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),
|
| 69 | (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),
|
| 70 | (65, 'Mrs', 'Rashad', 'Lindsey', 'Ap #266-6265 Tempor Road', 'Whithorn', 'Wigtownshire', 'M4 2KW', '07755 838533', DATE('1954-10-17'), 'Female', 9999999064, 684154, 3, 65),
|
| 71 | (66, 'Mrs', 'Eagan', 'Zamora', '675-4750 Cursus Rd.', 'Sutton', 'Surrey', 'VN09 3ZN', '(016977) 7133', DATE('1947-01-26'), 'Male', 9999999065, 584134, 3, 66),
|
| 72 | (67, 'Ms', 'Emma', 'O''Brien', '53', 'Talbot Road', 'Dublin', 'D8', '056 3920 1956', DATE('1989-11-02'), 'Female', 9999999066, 651598, 1, 67),
|
| 73 | (68, 'Mr', 'Jim', 'Murphy', '28', 'Low Street', 'Cork', 'CK', '0800 669413', DATE('1935-08-13'), 'Male', 9999999067, 318494, 3, 68),
|
| 74 | (69, 'Mr', 'Luke', 'Smith', '2', 'Rossington St', 'Leeds', 'LS2 8HD', '(0113) 222 4401', DATE('1956-09-07'), 'Male', 9999999068, 864318, 4, 69),
|
| 75 | (70, 'Ms', 'Ciara', 'MacAuley', '60', 'SeaView Road', 'Dublin', 'D8', '(01852) 01318', DATE('1989-01-02'), 'Female', 9999999069, 651545, 2, 70),
|
| 76 | (71, 'Mr', 'Dante', 'Maddox', '7305 Est Avenue', 'Glossop', 'Derbyshire', 'R03 3JH', '07376 394887', DATE('1998-02-15'), 'Female', 9999999070, 684315, 5, 71),
|
| 77 | (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),
|
| 78 | (73, 'Mr', 'Shellie', 'Cain', '5742 Facilisi. Av.', 'Bathgate', 'West Lothian', 'E9 5XL', '076 2031 1395', DATE('1956-10-17'), 'Female', 9999999072, 986413, 2, 73),
|
| 79 | (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),
|
| 80 | (75, 'Mr', 'Cade', 'Heath', '233-6719 Nec, Avenue', 'Campbeltown', 'Argyllshire', 'X60 3CB', '(016977) 8525', DATE('1943-03-08'), 'Male', 9999999074, 986433, 3, 75),
|
| 81 | (76, 'Mrs', 'Sylvester', 'Wong', '264-7700 Aenean Rd.', 'Sromness', 'Orkney', 'Y6 2GQ', '0816 939 6772', DATE('1939-04-29'), 'Female', 9999999075, 684434, 3, 76),
|
| 82 | (77, 'Mr', 'Tim', 'Madden', '3', 'SeaView Road', 'Galway', 'GW', '0890 902 2134', DATE('1998-07-21'), 'Male', 9999999076, 894313, 4, 77),
|
| 83 | (78, 'Mr', 'Faolan', 'Kelly', '12', 'Talbot Road', 'Galway', 'GW', '0809 641 0596', DATE('1995-03-16'), 'Male', 9999999077, 864513, 4, 78),
|
| 84 | (79, 'Mr', 'Grace', 'Mcleod', '6271 Bibendum Av.', 'Oban', 'Argyllshire', 'YY9L 6SF', '0800 423784', DATE('1983-02-04'), 'Female', 9999999078, 354681, 4, 79),
|
| 85 | (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),
|
| 86 | (81, 'Mrs', 'Kato', 'Shaw', '2924 Pretium Av.', 'Camborne', 'Cornwall', 'J1 3AM', '07624 601614', DATE('1969-07-19'), 'Male', 9999999080, 684131, 5, 81),
|
| 87 | (82, 'Mr', 'Yvette', 'Melendez', 'Ap #402-2415 Phasellus Road', 'Folkestone', 'Kent', 'A6I 6RG', '0800 465805', DATE('1989-12-27'), 'Male', 9999999081, 198445, 1, 82),
|
| 88 | (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),
|
| 89 | (84, 'Mr', 'Cillian', 'Walsh', '75', 'Mallow View', 'Galway', 'GW', '070 6741 6905', DATE('1955-01-12'), 'Male', 9999999083, 864147, 3, 84),
|
| 90 | (85, 'Mr', 'Tim', 'Smith', '84', 'Douglas Road', 'Galway', 'GW', '076 5439 2425', DATE('1975-09-26'), 'Male', 9999999084, 651534, 3, 85),
|
| 91 | (86, 'Mrs', 'Maria', 'McGowan', '46', 'SandyMill Road', 'Dublin', 'D8', '(016977) 7671', DATE('1988-10-22'), 'Female', 9999999085, 584135, 2, 86),
|
| 92 | (87, 'Mr', 'Jack', 'Donnelly', '82', 'SandyMill Road', 'Galway', 'GW', '0301 776 8869', DATE('1937-03-30'), 'Male', 9999999086, 854144, 5, 87),
|
| 93 | (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),
|
| 94 | (89, 'Mrs', 'Aiko', 'Haney', '323-4504 Tempus Av.', 'Bedford', 'Bedfordshire', 'U9K 6GK', '(012913) 24672', DATE('1954-07-29'), 'Female', 9999999088, 841351, 4, 89),
|
| 95 | (90, 'Mr', 'Marcia', 'Hicks', 'Ap #545-9425 Donec St.', 'Tiverton', 'Devon', 'TR1 5VH', '07954 694224', DATE('1962-05-03'), 'Male', 9999999089, 653518, 4, 90),
|
| 96 | (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),
|
| 97 | (92, 'Mr', 'Zephr', 'Mccarthy', '390-7981 Lorem Rd.', 'Clackmannan', 'Clackmannanshire', 'P3O 4EL', '(01649) 794806', DATE('1950-06-25'), 'Female', 9999999091, 684344, 1, 92),
|
| 98 | (93, 'Mrs', 'Cassidy', 'Wood', 'Ap #166-824 Risus. Ave', 'Tewkesbury', 'Gloucestershire', 'JA2 2DM', '07624 844651', DATE('1970-02-19'), 'Male', 9999999092, 864313, 2, 93),
|
| 99 | (94, 'Mr', 'James', 'Kelly', '44', 'Mallow View', 'Limerick', 'LK', '076 2969 2315', DATE('1995-11-18'), 'Male', 9999999093, 843147, 5, 94),
|
| 100 | (95, 'Ms', 'Marian', 'O''Brien', '72', 'Summer Hill', 'Dublin', 'D8', '(015144) 77262', DATE('1936-11-04'), 'Female', 9999999094, 684311, 2, 95),
|
| 101 | (96, 'Mr', 'Shoshana', 'Hewitt', '1986 Integer Road', 'Northampton', 'Northamptonshire', 'TC05 0BW', '070 7594 8865', DATE('1978-06-14'), 'Male', 9999999095, 241843, 3, 96),
|
| 102 | (97, 'Mrs', 'Sade', 'Bowman', 'Ap #163-4448 Nunc. Rd.', 'Bracknell', 'Berkshire', 'L9 5NF', '07977 658224', DATE('1954-02-04'), 'Female', 9999999096, 841867, 4, 97),
|
| 103 | (98, 'Mr', 'Alexis', 'Greer', '741-7482 Cras Street', 'Kilsyth', 'Stirlingshire', 'LW5 1HC', '0800 719 4863', DATE('1941-03-23'), 'Female', 9999999097, 845135, 4, 98),
|
| 104 | (99, 'Mrs', 'Sarah', 'Fuentes', 'Ap #634-1630 Rutrum Road', 'Annan', 'Dumfriesshire', 'KT3 9HI', '0500 772606', DATE('1992-11-09'), 'Female', 9999999098, 864177, 4, 99);
|
| 105 |
|
| 106 | UNLOCK TABLES; |
| \ | No newline at end of file |