UNPKG

11.1 kBapplication/x-sqlView Raw
1LOCK TABLES poc_legacy.general_practitioners WRITE;
2
3INSERT INTO poc_legacy.general_practitioners
4 (id, gp_name, address_1, address_2, address_3, address_4, postcode)
5VALUES
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.', 'Burmantofts Medical Centre', 'Cromwell Mount', 'Leeds', '', 'LS9 7TA'),
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
107UNLOCK TABLES;
\No newline at end of file