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