LOCK TABLES poc_legacy.general_practitioners WRITE;

INSERT INTO poc_legacy.general_practitioners
  (id,  gp_name,                    address_1,  address_2,  address_3,  address_4,  postcode)
VALUES

(1,	'Goff Carolyn D.',	'Hamilton Practice',	'5544 Ante Street',	'Hamilton',	'Lanarkshire',	'N06 5LP'),
(2,	'Cash Claire F.',	'Northmapton Practice',	'616-9384 Mauris Rd.',	'Northampton',	'Northamptonshire',	'ZY9 2KM'),
(3,	'Spencer Hyacinth A.',	'Port Glasgow Practice',	'4872 Cubilia St.',	'Port Glasgow',	'Renfrewshire',	'TQ3J 4JG'),
(4,	'Bailey Demetrius B.',	'Newport Practice',	'Ap #491-7493 Donec Ave',	'Newport',	'Hampshire',	'JB48 4EL'),
(5,	'Guthrie Indigo D.',	'Edinburgh Practice',	'7673 Luctus St.',	'Edinburgh',	'Midlothian',	'OS65 6FU'),
(6,	'Hudson Inez G.',	'Taunton Practice',	'611-682 Sed Road',	'Taunton',	'Somerset',	'Y92 1WA'),
(7,	'Joseph May N.',	'Aulderan Practice',	'Ap #806-2884 Enim St.',	'Auldearn',	'Nairnshire',	'V4F 9GJ'),
(8,	'Calderon Mollie Y.',	'Scalloway Practice',	'549-6333 Magna Street',	'Scalloway',	'Shetland',	'KF3 8IO'),
(9,	'Mcclain Ocean Q.',	'Hamilton Practice',	'5544 Ante Street',	'Hamilton',	'Lanarkshire',	'N06 5LP'),
(10,	'KEY Dawn A.',	'Northmapton Practice',	'616-9384 Mauris Rd.',	'Northampton',	'Northamptonshire',	'ZY9 2KM'),
(11,	'Boyer Isaac Q.',	'Port Glasgow Practice',	'4872 Cubilia St.',	'Port Glasgow',	'Renfrewshire',	'TQ3J 4JG'),
(12,	'Hobbs Neil S.',	'Newport Practice',	'Ap #491-7493 Donec Ave',	'Newport',	'Hampshire',	'JB48 4EL'),
(13,	'Sullivan Bruno Z.',	'Edinburgh Practice',	'7673 Luctus St.',	'Edinburgh',	'Midlothian',	'OS65 6FU'),
(14,	'Roach Solomon H.',	'Taunton Practice',	'611-682 Sed Road',	'Taunton',	'Somerset',	'Y92 1WA'),
(15,	'Cooke Kelsey T.',	'Aulderan Practice',	'Ap #806-2884 Enim St.',	'Auldearn',	'Nairnshire',	'V4F 9GJ'),
(16,	'Howard Megan D.',	'Scalloway Practice',	'549-6333 Magna Street',	'Scalloway',	'Shetland',	'KF3 8IO'),
(17,	'Hampton Hamish H.',	'Hamilton Practice',	'5544 Ante Street',	'Hamilton',	'Lanarkshire',	'N06 5LP'),
(18,	'Valenzuela Jesse M.',	'Northmapton Practice',	'616-9384 Mauris Rd.',	'Northampton',	'Northamptonshire',	'ZY9 2KM'),
(19,	'Joseph Cameron J.',	'Port Glasgow Practice',	'4872 Cubilia St.',	'Port Glasgow',	'Renfrewshire',	'TQ3J 4JG'),
(20,	'Garrett Illana I.',	'Newport Practice',	'Ap #491-7493 Donec Ave',	'Newport',	'Hampshire',	'JB48 4EL'),
(21,	'Morris Lucian X.',	'Edinburgh Practice',	'7673 Luctus St.',	'Edinburgh',	'Midlothian',	'OS65 6FU'),
(22,	'Moran August H.',	'Taunton Practice',	'611-682 Sed Road',	'Taunton',	'Somerset',	'Y92 1WA'),
(23,	'Church Rebecca N.',	'Aulderan Practice',	'Ap #806-2884 Enim St.',	'Auldearn',	'Nairnshire',	'V4F 9GJ'),
(24,	'Reynolds Moana A.',	'Scalloway Practice',	'549-6333 Magna Street',	'Scalloway',	'Shetland',	'KF3 8IO'),
(25,	'Butler Keaton I.',	'Hamilton Practice',	'5544 Ante Street',	'Hamilton',	'Lanarkshire',	'N06 5LP'),
(26,	'Caldwell Constance B.',	'Northmapton Practice',	'616-9384 Mauris Rd.',	'Northampton',	'Northamptonshire',	'ZY9 2KM'),
(27,	'Blackburn Eve O.',	'Port Glasgow Practice',	'4872 Cubilia St.',	'Port Glasgow',	'Renfrewshire',	'TQ3J 4JG'),
(28,	'Long Inga C.',	'Newport Practice',	'Ap #491-7493 Donec Ave',	'Newport',	'Hampshire',	'JB48 4EL'),
(29,	'Briggs Kenneth M.',	'Edinburgh Practice',	'7673 Luctus St.',	'Edinburgh',	'Midlothian',	'OS65 6FU'),
(30,	'Blackburn Wang R.',	'Taunton Practice',	'611-682 Sed Road',	'Taunton',	'Somerset',	'Y92 1WA'),
(31,	'Marquez Pandora C.',	'Aulderan Practice',	'Ap #806-2884 Enim St.',	'Auldearn',	'Nairnshire',	'V4F 9GJ'),
(32,	'Ellison Rhiannon B.',	'Scalloway Practice',	'549-6333 Magna Street',	'Scalloway',	'Shetland',	'KF3 8IO'),
(33,	'Osborne Bo T.',	'Hamilton Practice',	'5544 Ante Street',	'Hamilton',	'Lanarkshire',	'N06 5LP'),
(34,	'Richmond Daniel E.',	'Northmapton Practice',	'616-9384 Mauris Rd.',	'Northampton',	'Northamptonshire',	'ZY9 2KM'),
(35,	'Waters Martina P.',	'Port Glasgow Practice',	'4872 Cubilia St.',	'Port Glasgow',	'Renfrewshire',	'TQ3J 4JG'),
(36,	'Cherry Calista Y.',	'Newport Practice',	'Ap #491-7493 Donec Ave',	'Newport',	'Hampshire',	'JB48 4EL'),
(37,	'Faulkner Cassady Q.',	'Edinburgh Practice',	'7673 Luctus St.',	'Edinburgh',	'Midlothian',	'OS65 6FU'),
(38,	'Garrett Cullen J.',	'Taunton Practice',	'611-682 Sed Road',	'Taunton',	'Somerset',	'Y92 1WA'),
(39,	'Simpson Grant Y.',	'Aulderan Practice',	'Ap #806-2884 Enim St.',	'Auldearn',	'Nairnshire',	'V4F 9GJ'),
(40,	'Bernard Kieran O.',	'Scalloway Practice',	'549-6333 Magna Street',	'Scalloway',	'Shetland',	'KF3 8IO'),
(41,	'Slater Dane R.',	'Hamilton Practice',	'5544 Ante Street',	'Hamilton',	'Lanarkshire',	'N06 5LP'),
(42,	'Cohen Amity G.',	'Northmapton Practice',	'616-9384 Mauris Rd.',	'Northampton',	'Northamptonshire',	'ZY9 2KM'),
(43,	'Patel Josephine K.',	'Port Glasgow Practice',	'4872 Cubilia St.',	'Port Glasgow',	'Renfrewshire',	'TQ3J 4JG'),
(44,	'Young Brian W.',	'Newport Practice',	'Ap #491-7493 Donec Ave',	'Newport',	'Hampshire',	'JB48 4EL'),
(45,	'Spence Kay Z.',	'Edinburgh Practice',	'7673 Luctus St.',	'Edinburgh',	'Midlothian',	'OS65 6FU'),
(46,	'Guzman Kimberley M.',	'Taunton Practice',	'611-682 Sed Road',	'Taunton',	'Somerset',	'Y92 1WA'),
(47,	'May Solomon V.',	'Aulderan Practice',	'Ap #806-2884 Enim St.',	'Auldearn',	'Nairnshire',	'V4F 9GJ'),
(48,	'Finley Carson Q.',	'Scalloway Practice',	'549-6333 Magna Street',	'Scalloway',	'Shetland',	'KF3 8IO'),
(49,	'Carver Rhiannon A.',	'Hamilton Practice',	'5544 Ante Street',	'Hamilton',	'Lanarkshire',	'N06 5LP'),
(50,	'Horn Ramona D.',	'Northmapton Practice',	'616-9384 Mauris Rd.',	'Northampton',	'Northamptonshire',	'ZY9 2KM'),
(51,	'Hawkins Sonya T.',	'Port Glasgow Practice',	'4872 Cubilia St.',	'Port Glasgow',	'Renfrewshire',	'TQ3J 4JG'),
(52,	'Greer Belle W.',	'Newport Practice',	'Ap #491-7493 Donec Ave',	'Newport',	'Hampshire',	'JB48 4EL'),
(53,	'Reed Melyssa H.',	'Edinburgh Practice',	'7673 Luctus St.',	'Edinburgh',	'Midlothian',	'OS65 6FU'),
(54,	'Trujillo Dieter M.',	'Taunton Practice',	'611-682 Sed Road',	'Taunton',	'Somerset',	'Y92 1WA'),
(55,	'George Isadora Y.',	'Aulderan Practice',	'Ap #806-2884 Enim St.',	'Auldearn',	'Nairnshire',	'V4F 9GJ'),
(56,	'Strickland Ferdinand B. ',	'Scalloway Practice',	'549-6333 Magna Street',	'Scalloway',	'Shetland',	'KF3 8IO'),
(57,	'Joseph Kenyon U.',	'Hamilton Practice',	'5544 Ante Street',	'Hamilton',	'Lanarkshire',	'N06 5LP'),
(58,	'Mcintyre Barbara Y.',	'Northmapton Practice',	'616-9384 Mauris Rd.',	'Northampton',	'Northamptonshire',	'ZY9 2KM'),
(59,	'Oconnor Kevin Y.',	'Port Glasgow Practice',	'4872 Cubilia St.',	'Port Glasgow',	'Renfrewshire',	'TQ3J 4JG'),
(60,	'Floyd Desirae R.',	'Newport Practice',	'Ap #491-7493 Donec Ave',	'Newport',	'Hampshire',	'JB48 4EL'),
(61,	'Massey Armand T.',	'Edinburgh Practice',	'7673 Luctus St.',	'Edinburgh',	'Midlothian',	'OS65 6FU'),
(62,	'Daniels Yvonne C.',	'Taunton Practice',	'611-682 Sed Road',	'Taunton',	'Somerset',	'Y92 1WA'),
(63,	'Guerra Dai C.',	'Aulderan Practice',	'Ap #806-2884 Enim St.',	'Auldearn',	'Nairnshire',	'V4F 9GJ'),
(64,	'Dotson Merrill T.',	'Scalloway Practice',	'549-6333 Magna Street',	'Scalloway',	'Shetland',	'KF3 8IO'),
(65,	'Gordon Quin P.',	'Hamilton Practice',	'5544 Ante Street',	'Hamilton',	'Lanarkshire',	'N06 5LP'),
(66,	'Bird Darrel L.',	'Northmapton Practice',	'616-9384 Mauris Rd.',	'Northampton',	'Northamptonshire',	'ZY9 2KM'),
(67,	'Webster Uta A.',	'Port Glasgow Practice',	'4872 Cubilia St.',	'Port Glasgow',	'Renfrewshire',	'TQ3J 4JG'),
(68,	'Hooper Tate K.',	'Newport Practice',	'Ap #491-7493 Donec Ave',	'Newport',	'Hampshire',	'JB48 4EL'),
(69,	'Parsons Melissa A.',	'Edinburgh Practice',	'7673 Luctus St.',	'Edinburgh',	'Midlothian',	'OS65 6FU'),
(70,	'Schultz Kane E.',	'Taunton Practice',	'611-682 Sed Road',	'Taunton',	'Somerset',	'Y92 1WA'),
(71,	'Ortiz Whitney X.',	'Aulderan Practice',	'Ap #806-2884 Enim St.',	'Auldearn',	'Nairnshire',	'V4F 9GJ'),
(72,	'Horn Bevis E.',	'Scalloway Practice',	'549-6333 Magna Street',	'Scalloway',	'Shetland',	'KF3 8IO'),
(73,	'Jacobson Amir O.',	'Hamilton Practice',	'5544 Ante Street',	'Hamilton',	'Lanarkshire',	'N06 5LP'),
(74,	'Craig Keane W.',	'Northmapton Practice',	'616-9384 Mauris Rd.',	'Northampton',	'Northamptonshire',	'ZY9 2KM'),
(75,	'Oneal Jackson C.',	'Port Glasgow Practice',	'4872 Cubilia St.',	'Port Glasgow',	'Renfrewshire',	'TQ3J 4JG'),
(76,	'Richardson Brett F.',	'Newport Practice',	'Ap #491-7493 Donec Ave',	'Newport',	'Hampshire',	'JB48 4EL'),
(77,	'Solis Ariana C.',	'Edinburgh Practice',	'7673 Luctus St.',	'Edinburgh',	'Midlothian',	'OS65 6FU'),
(78,	'Frederick Nash E.',	'Taunton Practice',	'611-682 Sed Road',	'Taunton',	'Somerset',	'Y92 1WA'),
(79,	'Ferguson Keaton Y.',	'Aulderan Practice',	'Ap #806-2884 Enim St.',	'Auldearn',	'Nairnshire',	'V4F 9GJ'),
(80,	'Jacobson Lyle N.',	'Scalloway Practice',	'549-6333 Magna Street',	'Scalloway',	'Shetland',	'KF3 8IO'),
(81,	'Reed Remedios H.',	'Hamilton Practice',	'5544 Ante Street',	'Hamilton',	'Lanarkshire',	'N06 5LP'),
(82,	'Kim Charles Q.',	'Northmapton Practice',	'616-9384 Mauris Rd.',	'Northampton',	'Northamptonshire',	'ZY9 2KM'),
(83,	'Lott Ferdinand V.',	'Port Glasgow Practice',	'4872 Cubilia St.',	'Port Glasgow',	'Renfrewshire',	'TQ3J 4JG'),
(84,	'Forbes Merritt P.',	'Newport Practice',	'Ap #491-7493 Donec Ave',	'Newport',	'Hampshire',	'JB48 4EL'),
(85,	'Combs Susan J.',	'Edinburgh Practice',	'7673 Luctus St.',	'Edinburgh',	'Midlothian',	'OS65 6FU'),
(86,	'Slater Yael U.',	'Taunton Practice',	'611-682 Sed Road',	'Taunton',	'Somerset',	'Y92 1WA'),
(87,	'Pierce Ulric Q.',	'Aulderan Practice',	'Ap #806-2884 Enim St.',	'Auldearn',	'Nairnshire',	'V4F 9GJ'),
(88,	'Hickman Mikayla F.',	'Scalloway Practice',	'549-6333 Magna Street',	'Scalloway',	'Shetland',	'KF3 8IO'),
(89,	'Guy Victoria I.',	'Hamilton Practice',	'5544 Ante Street',	'Hamilton',	'Lanarkshire',	'N06 5LP'),
(90,	'Higgins Quintessa N.',	'Northmapton Practice',	'616-9384 Mauris Rd.',	'Northampton',	'Northamptonshire',	'ZY9 2KM'),
(91,	'Bernard Frances Z.',	'Port Glasgow Practice',	'4872 Cubilia St.',	'Port Glasgow',	'Renfrewshire',	'TQ3J 4JG'),
(92,	'Ortiz Ezra A.',	'Newport Practice',	'Ap #491-7493 Donec Ave',	'Newport',	'Hampshire',	'JB48 4EL'),
(93,	'Slater Kibo B.',	'Edinburgh Practice',	'7673 Luctus St.',	'Edinburgh',	'Midlothian',	'OS65 6FU'),
(94,	'Best Sylvia U.',	'Taunton Practice',	'611-682 Sed Road',	'Taunton',	'Somerset',	'Y92 1WA'),
(95,	'Gilbert Nichole P.',	'Aulderan Practice',	'Ap #806-2884 Enim St.',	'Auldearn',	'Nairnshire',	'V4F 9GJ'),
(96,	'Cortez Anjolie Q.',	'Scalloway Practice',	'549-6333 Magna Street',	'Scalloway',	'Shetland',	'KF3 8IO'),
(97,	'Mccray Trevor I.',	'Hamilton Practice',	'5544 Ante Street',	'Hamilton',	'Lanarkshire',	'N06 5LP'),
(98,	'Sweet Illiana H.',	'Northmapton Practice',	'616-9384 Mauris Rd.',	'Northampton',	'Northamptonshire',	'ZY9 2KM'),
(99,	'Boone Aretha M.',	'Port Glasgow Practice',	'4872 Cubilia St.',	'Port Glasgow',	'Renfrewshire',	'TQ3J 4JG');

UNLOCK TABLES;