f8zEre2T

1-- phpMyAdmin SQL Dump
2-- version 4.4.10
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost:8889
6-- Generation Time: Nov 09, 2016 at 10:04 AM
7-- Server version: 5.5.42
8-- PHP Version: 5.6.10
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13--
14-- Database: `main`
15--
16
17-- --------------------------------------------------------
18
19--
20-- Table structure for table `age`
21--
22
23DROP TABLE IF EXISTS `age`;
24CREATE TABLE `age` (
25  `id` int(10) unsigned NOT NULL,
26  `key` varchar(25) NOT NULL,
27  `value` varchar(255) NOT NULL,
28  `order` int(11) DEFAULT '0'
29) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
30
31--
32-- Dumping data for table `age`
33--
34
35INSERT INTO `age` (`id`, `key`, `value`, `order`) VALUES
36(1, '18-', 'tot 18 jaar', 0),
37(2, '18-24', '18 tot 24 jaar', 0),
38(3, '25-34', '25 tot 34 jaar', 0),
39(4, '35-44', '35 tot 44 jaar', 0),
40(5, '45-54', '45 tot 54 jaar', 0),
41(6, '55-64', '55 tot 64 jaar', 0),
42(7, '65+', '65 of ouder', 0);
43
44-- --------------------------------------------------------
45
46--
47-- Table structure for table `answer`
48--
49
50DROP TABLE IF EXISTS `answer`;
51CREATE TABLE `answer` (
52  `id` int(11) NOT NULL,
53  `questionId` int(11) NOT NULL,
54  `userId` int(10) unsigned NOT NULL,
55  `answer` mediumtext NOT NULL,
56  `upvote` int(11) DEFAULT '0',
57  `downvote` int(11) DEFAULT '0',
58  `shared` int(11) DEFAULT '0',
59  `reported` int(11) DEFAULT '0',
60  `correct` tinyint(1) DEFAULT '0',
61  `dateCreated` datetime NOT NULL
62) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
63
64--
65-- Dumping data for table `answer`
66--
67
68INSERT INTO `answer` (`id`, `questionId`, `userId`, `answer`, `upvote`, `downvote`, `shared`, `reported`, `correct`, `dateCreated`) VALUES
69(1, 1, 1, 'Ik heb echt geen idee... i give up', 2, 1, 12, 1, 1, '2016-11-03 00:00:00');
70
71-- --------------------------------------------------------
72
73--
74-- Table structure for table `answerMedium`
75--
76
77DROP TABLE IF EXISTS `answerMedium`;
78CREATE TABLE `answerMedium` (
79  `id` int(10) unsigned NOT NULL,
80  `answerId` int(10) unsigned NOT NULL,
81  `mediumTypeId` int(10) unsigned NOT NULL,
82  `title` varchar(255) NOT NULL,
83  `url` varchar(255) NOT NULL
84) ENGINE=InnoDB DEFAULT CHARSET=utf8;
85
86-- --------------------------------------------------------
87
88--
89-- Table structure for table `city`
90--
91
92DROP TABLE IF EXISTS `city`;
93CREATE TABLE `city` (
94  `id` int(10) unsigned NOT NULL,
95  `municipalityId` int(10) unsigned NOT NULL,
96  `name` varchar(255) NOT NULL,
97  `img` varchar(255) DEFAULT NULL
98) ENGINE=InnoDB DEFAULT CHARSET=utf8;
99
100--
101-- Dumping data for table `city`
102--
103
104INSERT INTO `city` (`id`, `municipalityId`, `name`, `img`) VALUES
105(1, 1, 'Schoonloo', NULL),
106(2, 1, 'Grolloo', NULL),
107(3, 1, 'Vredenheim', NULL),
108(4, 1, 'Amen', NULL),
109(5, 1, 'Papenvoort', NULL),
110(6, 1, 'Marwijksoord', NULL),
111(7, 1, 'Nooitgedacht', NULL),
112(8, 1, 'Rolde', NULL),
113(9, 1, 'Nijlande', NULL),
114(10, 1, 'Eldersloo', NULL),
115(11, 1, 'Ekehaar', NULL),
116(12, 1, 'Geelbroek', NULL),
117(13, 1, 'Eleveld', NULL),
118(14, 1, 'Deurze', NULL),
119(15, 1, 'Balloo', NULL),
120(16, 1, 'Balloerveld', NULL),
121(17, 1, 'Gieten', NULL),
122(18, 1, 'Gasselte', NULL),
123(19, 1, 'Eext', NULL),
124(20, 1, 'Eexterzandvoort', NULL),
125(21, 1, 'Anderen', NULL),
126(22, 1, 'Gasteren', NULL),
127(23, 1, 'Anloo', NULL),
128(24, 1, 'Annen', NULL),
129(25, 1, 'Schipborg', NULL),
130(26, 1, 'Gieterveen', NULL),
131(27, 1, 'Nieuwediep', NULL),
132(28, 1, 'Gasselternijveen', NULL),
133(29, 1, 'Gasselternijveenschemond', NULL),
134(30, 1, 'Annerveensche Kan', NULL),
135(31, 1, 'Oud Annerveen', NULL),
136(32, 1, 'Spijkerboor (DR)', NULL),
137(33, 1, 'Nieuw Annerveen', NULL),
138(34, 1, 'Eexterveen', NULL),
139(35, 1, 'Eexterveensche Kan', NULL),
140(36, 2, 'Wijk en Aalburg', NULL),
141(37, 2, 'Veen', NULL),
142(38, 2, 'Genderen', NULL),
143(39, 2, 'Eethen', NULL),
144(40, 2, 'Drongelen', NULL),
145(41, 2, 'Meeuwen', NULL),
146(42, 2, 'Babylonienbroek', NULL),
147(43, 3, 'Aalsmeer', NULL),
148(44, 3, 'Kudelstaart', NULL),
149(45, 4, 'Dinxperlo', NULL),
150(46, 4, 'De Heurne', NULL),
151(47, 4, 'Aalten', NULL),
152(48, 4, 'Heurne', NULL),
153(49, 4, 'Bredevoort', NULL),
154(50, 5, 'Abcoude', NULL),
155(51, 5, 'Baambrugge', NULL),
156(52, 6, 'Surhuisterveen', NULL),
157(53, 6, 'Boelenslaan', NULL),
158(54, 6, 'Harkema', NULL),
159(55, 6, 'Surhuizum', NULL),
160(56, 6, 'Augustinusga', NULL),
161(57, 6, 'Buitenpost', NULL),
162(58, 6, 'Twijzel', NULL),
163(59, 6, 'Twijzelerheide', NULL),
164(60, 6, 'Kootstertille', NULL),
165(61, 6, 'Drogeham', NULL),
166(62, 6, 'Stroobos', NULL),
167(63, 6, 'Gerkesklooster', NULL),
168(64, 7, 'Alblasserdam', NULL),
169(65, 8, 'Rhoon', NULL),
170(66, 8, 'Rotterdam Albrandswaard', NULL),
171(67, 8, 'Poortugaal', NULL),
172(68, 9, 'Kaag', NULL),
173(69, 9, 'Roelofarendsveen', NULL),
174(70, 9, 'Oud Ade', NULL),
175(71, 9, 'Rijpwetering', NULL),
176(72, 9, 'Nieuwe Wetering', NULL),
177(73, 9, 'Oude Wetering', NULL),
178(74, 10, 'Alkmaar', NULL),
179(75, 10, 'Oudorp (NH)', NULL),
180(76, 10, 'Koedijk', NULL),
181(77, 11, 'Almelo', NULL),
182(78, 11, 'Aadorp', NULL),
183(79, 11, 'Bornerbroek', NULL),
184(80, 12, 'Almere', NULL),
185(81, 13, 'Alphen aan den Rijn', NULL),
186(82, 13, 'Aarlanderveen', NULL),
187(83, 13, 'Zwammerdam', NULL),
188(84, 14, 'Galder', NULL),
189(85, 14, 'Strijbeek', NULL),
190(86, 14, 'Ulvenhout Ac', NULL),
191(87, 14, 'Bavel Ac', NULL),
192(88, 14, 'Chaam', NULL),
193(89, 14, 'Alphen (NB)', NULL),
194(90, 15, 'Posterholt', NULL),
195(91, 15, 'Montfort', NULL),
196(92, 15, 'Sint Odilienberg', NULL),
197(93, 16, 'Hollum', NULL),
198(94, 16, 'Ballum', NULL),
199(95, 16, 'Nes Ameland', NULL),
200(96, 16, 'Buren (FRL)', NULL),
201(97, 17, 'Amersfoort', NULL),
202(98, 17, 'Hoogland', NULL),
203(99, 17, 'Hooglanderveen', NULL),
204(100, 17, 'Stoutenburg Noord', NULL),
205(101, 18, 'Amstelveen', NULL),
206(102, 19, 'Amsterdam', NULL),
207(103, 19, 'Amsterdam Zuidoost', NULL),
208(104, 20, 'Andijk', NULL),
209(105, 21, 'Anna Paulowna', NULL),
210(106, 21, 'Breezand', NULL),
211(107, 21, 'Wieringerwaard', NULL),
212(108, 22, 'Uddel', NULL),
213(109, 22, 'Apeldoorn', NULL),
214(110, 22, 'Ugchelen', NULL),
215(111, 22, 'Beemte Broekland', NULL),
216(112, 22, 'Wenum Wiesel', NULL),
217(113, 22, 'Hoog Soeren', NULL),
218(114, 22, 'Radio Kootwijk', NULL),
219(115, 22, 'Hoenderloo', NULL),
220(116, 22, 'Beekbergen', NULL),
221(117, 22, 'Lieren', NULL),
222(118, 22, 'Loenen (GLD)', NULL),
223(119, 22, 'Klarenbeek', NULL),
224(120, 23, 'Appingedam', NULL),
225(121, 24, 'Velden', NULL),
226(122, 24, 'Lomm', NULL),
227(123, 24, 'Arcen', NULL),
228(124, 25, 'Arnhem', NULL),
229(125, 26, 'Assen', NULL),
230(126, 26, 'Loon', NULL),
231(127, 26, 'Rhee', NULL),
232(128, 26, 'Ter Aard', NULL),
233(129, 26, 'Zeijerveld', NULL),
234(130, 26, 'Zeijerveen', NULL),
235(131, 26, 'Ubbena', NULL),
236(132, 27, 'Asten', NULL),
237(133, 27, 'Ommel', NULL),
238(134, 27, 'Heusden Gemeente Asten', NULL),
239(135, 28, 'Baarle Nassau', NULL),
240(136, 28, 'Ulicoten', NULL),
241(137, 28, 'Castelre', NULL),
242(138, 29, 'Baarn', NULL),
243(139, 29, 'Lage Vuursche', NULL),
244(140, 30, 'Barendrecht', NULL),
245(141, 31, 'Barneveld', NULL),
246(142, 31, 'Kootwijkerbroek', NULL),
247(143, 31, 'Kootwijk', NULL),
248(144, 31, 'Stroe', NULL),
249(145, 31, 'Voorthuizen', NULL),
250(146, 31, 'Terschuur', NULL),
251(147, 31, 'Zwartebroek', NULL),
252(148, 31, 'Achterveld', NULL),
253(149, 31, 'De Glind', NULL),
254(150, 31, 'Garderen', NULL),
255(151, 32, 'Bedum', NULL),
256(152, 32, 'Noordwolde (GN)', NULL),
257(153, 32, 'Zuidwolde (GN)', NULL),
258(154, 32, 'Onderdendam', NULL),
259(155, 33, 'Spaubeek', NULL),
260(156, 33, 'Beek (LB)', NULL),
261(157, 33, 'Maastricht Airport', NULL),
262(158, 34, 'Zuidoostbeemster', NULL),
263(159, 34, 'Middenbeemster', NULL),
264(160, 34, 'Noordbeemster', NULL),
265(161, 34, 'Westbeemster', NULL),
266(162, 35, 'Reuver', NULL),
267(163, 35, 'Beesel', NULL),
268(164, 36, 'Veelerveen', NULL),
269(165, 36, 'Bellingwolde', NULL),
270(166, 36, 'Oudeschans', NULL),
271(167, 36, 'Blijham', NULL),
272(168, 36, 'Wedde', NULL),
273(169, 36, 'Vriescheloo', NULL),
274(170, 37, 'Bennebroek', NULL),
275(171, 38, 'Berkenwoude', NULL),
276(172, 38, 'Bergambacht', NULL),
277(173, 38, 'Ammerstol', NULL),
278(174, 39, 'Riethoven', NULL),
279(175, 39, 'Westerhoven', NULL),
280(176, 39, 'Bergeijk', NULL),
281(177, 39, 'Luijksgestel', NULL),
282(178, 40, 'Afferden (LB)', NULL),
283(179, 40, 'Siebengewald', NULL),
284(180, 40, 'Bergen (LB)', NULL),
285(181, 40, 'Well (LB)', NULL),
286(182, 40, 'Wellerlooi', NULL),
287(183, 41, 'Bergen (NH)', NULL),
288(184, 41, 'Bergen aan Zee', NULL),
289(185, 41, 'Schoorl', NULL),
290(186, 41, 'Groet', NULL),
291(187, 41, 'Egmond aan Zee', NULL),
292(188, 41, 'Egmond aan de Hoef', NULL),
293(189, 41, 'Egmond Binnen', NULL),
294(190, 42, 'Bergen op Zoom', NULL),
295(191, 42, 'Halsteren', NULL),
296(192, 42, 'Lepelstraat', NULL),
297(193, 43, 'Bergschenhoek', NULL),
298(194, 44, 'Berkel en Rodenrijs', NULL),
299(195, 45, 'Eibergen', NULL),
300(196, 45, 'Beltrum', NULL),
301(197, 45, 'Rekken', NULL),
302(198, 45, 'Neede', NULL),
303(199, 45, 'Rietmolen', NULL),
304(200, 45, 'Ruurlo', NULL),
305(201, 45, 'Borculo', NULL),
306(202, 45, 'Haarlo', NULL),
307(203, 45, 'Geesteren (GLD)', NULL),
308(204, 45, 'Gelselaar', NULL),
309(205, 46, 'Heesch', NULL),
310(206, 46, 'Nistelrode', NULL),
311(207, 46, 'Loosbroek', NULL),
312(208, 46, 'Heeswijk Dinther', NULL),
313(209, 46, 'Vorstenbosch', NULL),
314(210, 47, 'Geervliet', NULL),
315(211, 47, 'Simonshaven', NULL),
316(212, 47, 'Zuidland', NULL),
317(213, 47, 'Abbenbroek', NULL),
318(214, 47, 'Heenvliet', NULL),
319(215, 47, 'Oudenhoorn', NULL),
320(216, 48, 'Best', NULL),
321(217, 49, 'Weurt', NULL),
322(218, 49, 'Beuningen (GLD)', NULL),
323(219, 49, 'Ewijk', NULL),
324(220, 49, 'Winssen', NULL),
325(221, 50, 'Beverwijk', NULL),
326(222, 50, 'Wijk aan Zee', NULL),
327(223, 51, 'Mijnsheerenland', NULL),
328(224, 51, 'Westmaas', NULL),
329(225, 51, 'Heinenoord', NULL),
330(226, 51, 'Puttershoek', NULL),
331(227, 51, 'Maasdam', NULL),
332(228, 52, 'Hapert', NULL),
333(229, 52, 'Hoogeloon', NULL),
334(230, 52, 'Casteren', NULL),
335(231, 52, 'Bladel', NULL),
336(232, 52, 'Netersel', NULL),
337(233, 53, 'Blaricum', NULL),
338(234, 54, 'Bleiswijk', NULL),
339(235, 55, 'Overveen', NULL),
340(236, 55, 'Bloemendaal', NULL),
341(237, 55, 'Aerdenhout', NULL),
342(238, 55, 'Vogelenzang', NULL),
343(239, 56, 'Akkrum', NULL),
344(240, 56, 'Terherne', NULL),
345(241, 56, 'Nes Gemeente Boarnsterhim', NULL),
346(242, 56, 'Aldeboarn', NULL),
347(243, 56, 'Dearsum', NULL),
348(244, 56, 'Sibrandabuorren', NULL),
349(245, 56, 'Grou', NULL),
350(246, 56, 'Warten', NULL),
351(247, 56, 'Warstiens', NULL),
352(248, 56, 'Wergea', NULL),
353(249, 56, 'Eagum', NULL),
354(250, 56, 'Idaerd', NULL),
355(251, 56, 'Reduzum', NULL),
356(252, 56, 'Friens', NULL),
357(253, 56, 'Jirnsum', NULL),
358(254, 56, 'Raerd', NULL),
359(255, 56, 'Poppenwier', NULL),
360(256, 56, 'Tersoal', NULL),
361(257, 57, 'Bodegraven', NULL),
362(258, 57, 'Nieuwerbrug', NULL),
363(259, 58, 'Boekel', NULL),
364(260, 58, 'Venhorst', NULL),
365(261, 59, 'Bolsward', NULL),
366(262, 60, 'Eeserveen', NULL),
367(263, 60, 'Klijndijk', NULL),
368(264, 60, 'Valthe', NULL),
369(265, 60, 'Odoorn', NULL),
370(266, 60, 'Odoornerveen', NULL),
371(267, 60, 'Exloo', NULL),
372(268, 60, 'Valthermond', NULL),
373(269, 60, 'Tweede Valthermond', NULL),
374(270, 60, 'Nieuw Buinen', NULL),
375(271, 60, 'Drouwenermond', NULL),
376(272, 60, 'Buinerveen', NULL),
377(273, 60, 'Drouwenerveen', NULL),
378(274, 60, 'Bronnegerveen', NULL),
379(275, 60, 'Bronneger', NULL),
380(276, 60, 'Buinen', NULL),
381(277, 60, 'Borger', NULL),
382(278, 60, 'Drouwen', NULL),
383(279, 60, 'Westdorp', NULL),
384(280, 60, 'Ellertshaar', NULL),
385(281, 60, 'Ees', NULL),
386(282, 60, 'Eesergroen', NULL),
387(283, 60, 'Zandberg (DR)', NULL),
388(284, 60, 'Tweede Exloermond', NULL),
389(285, 60, 'Eerste Exloermond', NULL),
390(286, 60, 'Exloerveen', NULL),
391(287, 61, 'Borne', NULL),
392(288, 61, 'Zenderen', NULL),
393(289, 61, 'Hertme', NULL),
394(290, 62, 's Gravenpolder', NULL),
395(291, 62, 'Hoedekenskerke', NULL),
396(292, 62, 'Kwadendamme', NULL),
397(293, 62, 'Baarland', NULL),
398(294, 62, 'Oudelande', NULL),
399(295, 62, 'Ellewoutsdijk', NULL),
400(296, 62, 'Driewegen', NULL),
401(297, 62, 'Ovezande', NULL),
402(298, 62, 'Nisse', NULL),
403(299, 62, 's Heer Abtskerke', NULL),
404(300, 62, 'Heinkenszand', NULL),
405(301, 62, 's Heerenhoek', NULL),
406(302, 62, 'Borssele', NULL),
407(303, 62, 'Nieuwdorp Zld', NULL),
408(304, 62, 'Lewedorp', NULL),
409(305, 63, 'Boskoop', NULL),
410(306, 64, 'Oeffelt', NULL),
411(307, 64, 'Rijkevoort', NULL),
412(308, 64, 'Vierlingsbeek', NULL),
413(309, 64, 'Maashees', NULL),
414(310, 64, 'Holthees', NULL),
415(311, 64, 'Overloon', NULL),
416(312, 64, 'Groeningen', NULL),
417(313, 64, 'Vortum Mullem', NULL),
418(314, 64, 'Boxmeer', NULL),
419(315, 64, 'Beugen', NULL),
420(316, 64, 'Sambeek', NULL),
421(317, 65, 'Boxtel', NULL),
422(318, 65, 'Liempde', NULL),
423(319, 66, 'Breda', NULL),
424(320, 66, 'Prinsenbeek', NULL),
425(321, 66, 'Teteringen', NULL),
426(322, 66, 'Ulvenhout', NULL),
427(323, 66, 'Bavel', NULL),
428(324, 67, 'Breukelen (UT)', NULL),
429(325, 67, 'Nieuwer Ter Aa', NULL),
430(326, 67, 'Kockengen', NULL),
431(327, 68, 'Brielle', NULL),
432(328, 68, 'Vierpolders', NULL),
433(329, 68, 'Zwartewaal', NULL),
434(330, 69, 'Drempt', NULL),
435(331, 69, 'Hoog Keppel', NULL),
436(332, 69, 'Laag Keppel', NULL),
437(333, 69, 'Hummelo', NULL),
438(334, 69, 'Zelhem', NULL),
439(335, 69, 'Halle', NULL),
440(336, 69, 'Steenderen', NULL),
441(337, 69, 'Baak', NULL),
442(338, 69, 'Rha', NULL),
443(339, 69, 'Olburgen', NULL),
444(340, 69, 'Bronkhorst', NULL),
445(341, 69, 'Toldijk', NULL),
446(342, 69, 'Vierakker', NULL),
447(343, 69, 'Wichmond', NULL),
448(344, 69, 'Vorden', NULL),
449(345, 69, 'Hengelo (GLD)', NULL),
450(346, 69, 'Keijenborg', NULL),
451(347, 70, 'Eerbeek', NULL),
452(348, 70, 'Hall', NULL),
453(349, 70, 'Brummen', NULL),
454(350, 70, 'Leuvenheim', NULL),
455(351, 70, 'Tonden', NULL),
456(352, 70, 'Empe', NULL),
457(353, 71, 'Brunssum', NULL),
458(354, 72, 'Bunnik', NULL),
459(355, 72, 'Odijk', NULL),
460(356, 72, 'Werkhoven', NULL),
461(357, 73, 'Bunschoten Spakenburg', NULL),
462(358, 73, 'Eemdijk', NULL),
463(359, 74, 'Zoelen', NULL),
464(360, 74, 'Kerk Avezaath Gemeente Buren', NULL),
465(361, 74, 'Kapel Avezaath Gemeente Buren', NULL),
466(362, 74, 'Maurik', NULL),
467(363, 74, 'Rijswijk (GLD)', NULL),
468(364, 74, 'Eck en Wiel', NULL),
469(365, 74, 'Ingen', NULL),
470(366, 74, 'Ommeren', NULL),
471(367, 74, 'Lienden', NULL),
472(368, 74, 'Zoelmond', NULL),
473(369, 74, 'Beusichem', NULL),
474(370, 74, 'Asch', NULL),
475(371, 74, 'Buren (GLD)', NULL),
476(372, 74, 'Erichem', NULL),
477(373, 74, 'Ravenswaaij', NULL),
478(374, 75, 'Bussum', NULL),
479(375, 76, 'Capelle aan den IJssel', NULL),
480(376, 77, 'De Woude', NULL),
481(377, 77, 'Castricum', NULL),
482(378, 77, 'Limmen', NULL),
483(379, 77, 'Akersloot', NULL),
484(380, 78, 'Coevorden', NULL),
485(381, 78, 'Dalen', NULL),
486(382, 78, 'Dalerpeel', NULL),
487(383, 78, 'Wachtum', NULL),
488(384, 78, 'Dalerveen', NULL),
489(385, 78, 'Stieltjeskanaal', NULL),
490(386, 78, 'Sleen', NULL),
491(387, 78, 'Diphoorn', NULL),
492(388, 78, 'Erm', NULL),
493(389, 78, 'Holsloot', NULL),
494(390, 78, 'Noord Sleen', NULL),
495(391, 78, 'T Haantje', NULL),
496(392, 78, 'Schoonoord', NULL),
497(393, 78, 'De Kiel', NULL),
498(394, 78, 'Zweeloo', NULL),
499(395, 78, 'Wezup', NULL),
500(396, 78, 'Wezuperbrug', NULL),
501(397, 78, 'Aalden', NULL),
502(398, 78, 'Meppen', NULL),
503(399, 78, 'Benneveld', NULL),
504(400, 78, 'Oosterhesselen', NULL),
505(401, 78, 'Gees', NULL),
506(402, 78, 'Zwinderen', NULL),
507(403, 78, 'Geesbrug', NULL),
508(404, 78, 'Nieuwlande Coevorden', NULL),
509(405, 79, 'Budel', NULL),
510(406, 79, 'Budel Schoot', NULL),
511(407, 79, 'Budel Dorplein', NULL),
512(408, 79, 'Maarheeze', NULL),
513(409, 79, 'Soerendonk', NULL),
514(410, 79, 'Gastel', NULL),
515(411, 80, 'Numansdorp', NULL),
516(412, 80, 'Klaaswaal', NULL),
517(413, 81, 'Cuijk', NULL),
518(414, 81, 'Katwijk (NB)', NULL),
519(415, 81, 'Vianen (NB)', NULL),
520(416, 81, 'Sint Agatha', NULL),
521(417, 81, 'Beers (NB)', NULL),
522(418, 81, 'Linden', NULL),
523(419, 81, 'Haps', NULL),
524(420, 82, 'Culemborg', NULL),
525(421, 83, 'Nieuwleusen', NULL),
526(422, 83, 'Dalfsen', NULL),
527(423, 83, 'Lemelerveld', NULL),
528(424, 84, 'Roodkerk', NULL),
529(425, 84, 'Damwoude', NULL),
530(426, 84, 'Rinsumageest', NULL),
531(427, 84, 'Sijbrandahuis', NULL),
532(428, 84, 'Broeksterwoude', NULL),
533(429, 84, 'De Valom', NULL),
534(430, 84, 'Wouterswoude', NULL),
535(431, 84, 'Driesum', NULL),
536(432, 84, 'Veenwouden', NULL),
537(433, 84, 'Zwaagwesteinde', NULL),
538(434, 85, 'Westbroek', NULL),
539(435, 85, 'Bilthoven', NULL),
540(436, 85, 'De Bilt', NULL),
541(437, 85, 'Groenekan', NULL),
542(438, 85, 'Maartensdijk', NULL),
543(439, 85, 'Hollandsche Rading', NULL),
544(440, 86, 'Mensingeweer', NULL),
545(441, 86, 'Schouwerzijl', NULL),
546(442, 86, 'Warfhuizen', NULL),
547(443, 86, 'Wehe Den Hoorn', NULL),
548(444, 86, 'Leens', NULL),
549(445, 86, 'Zuurdijk', NULL),
550(446, 86, 'Eenrum', NULL),
551(447, 86, 'Pieterburen', NULL),
552(448, 86, 'Westernieland', NULL),
553(449, 86, 'Ulrum', NULL),
554(450, 86, 'Niekerk De Marne', NULL),
555(451, 86, 'Houwerzijl', NULL),
556(452, 86, 'Zoutkamp', NULL),
557(453, 86, 'Vierhuizen', NULL),
558(454, 86, 'Lauwersoog', NULL),
559(455, 86, 'Kloosterburen', NULL),
560(456, 86, 'Hornhuizen', NULL),
561(457, 87, 'De Hoef', NULL),
562(458, 87, 'Amstelhoek', NULL),
563(459, 87, 'Mijdrecht', NULL),
564(460, 87, 'Vinkeveen', NULL),
565(461, 87, 'Waverveen', NULL),
566(462, 87, 'Wilnis', NULL),
567(463, 88, 'Drogteropslagen', NULL),
568(464, 88, 'Zuidwolde (DR)', NULL),
569(465, 88, 'Veeningen', NULL),
570(466, 88, 'Linde (DR)', NULL),
571(467, 88, 'Kerkenveld', NULL),
572(468, 88, 'Alteveer De Wolden', NULL),
573(469, 88, 'Echten (DR)', NULL),
574(470, 88, 'Eursinge De Wolden', NULL),
575(471, 88, 'De Wijk', NULL),
576(472, 88, 'Koekange', NULL),
577(473, 88, 'Ruinerwold', NULL),
578(474, 88, 'Ruinen', NULL),
579(475, 88, 'Ansen', NULL),
580(476, 89, 'Delft', NULL),
581(477, 90, 'Krewerd', NULL),
582(478, 90, 'Holwierde', NULL),
583(479, 90, 'Bierum', NULL),
584(480, 90, 'Losdorp', NULL),
585(481, 90, 'Godlinze', NULL),
586(482, 90, 'Spijk (GN)', NULL),
587(483, 90, 'Delfzijl', NULL),
588(484, 90, 'Farmsum', NULL),
589(485, 90, 'Meedhuizen', NULL),
590(486, 90, 'Wagenborgen', NULL),
591(487, 90, 'Woldendorp', NULL),
592(488, 90, 'Termunten', NULL),
593(489, 90, 'Termunterzijl', NULL),
594(490, 90, 'Borgsweer', NULL),
595(491, 91, 'Den Helder', NULL),
596(492, 92, 'Deurne', NULL),
597(493, 92, 'Vlierden', NULL),
598(494, 92, 'Liessel', NULL),
599(495, 92, 'Neerkant', NULL),
600(496, 92, 'Helenaveen', NULL),
601(497, 93, 'Deventer', NULL),
602(498, 93, 'Colmschate', NULL),
603(499, 93, 'Diepenveen', NULL),
604(500, 93, 'Schalkhaar', NULL),
605(501, 93, 'Lettele', NULL),
606(502, 93, 'Okkenbroek', NULL),
607(503, 93, 'Bathmen', NULL),
608(504, 94, 'Diemen', NULL),
609(505, 95, 'Deurningen', NULL),
610(506, 95, 'Denekamp', NULL),
611(507, 95, 'Weerselo', NULL),
612(508, 95, 'Rossum (OV)', NULL),
613(509, 95, 'Saasveld', NULL),
614(510, 95, 'Ootmarsum', NULL),
615(511, 95, 'Tilligte', NULL),
616(512, 95, 'Lattrop Breklenkamp', NULL),
617(513, 95, 'Agelo', NULL),
618(514, 95, 'Oud Ootmarsum', NULL),
619(515, 95, 'Nutter', NULL),
620(516, 96, 'Dirksland', NULL),
621(517, 96, 'Melissant', NULL),
622(518, 96, 'Herkingen', NULL),
623(519, 97, 'Doesburg', NULL),
624(520, 98, 'Doetinchem', NULL),
625(521, 98, 'Gaanderen', NULL),
626(522, 98, 'Wehl', NULL),
627(523, 99, 'Dongen', NULL),
628(524, 99, 's Gravenmoer', NULL),
629(525, 100, 'Dokkum', NULL),
630(526, 100, 'Aalzum', NULL),
631(527, 100, 'Wetzens', NULL),
632(528, 100, 'Metslawier', NULL),
633(529, 100, 'Jouswier', NULL),
634(530, 100, 'Oostrum (FRL)', NULL),
635(531, 100, 'Ee', NULL),
636(532, 100, 'Engwierum', NULL),
637(533, 100, 'Anjum', NULL),
638(534, 100, 'Lioessens', NULL),
639(535, 100, 'Morra', NULL),
640(536, 100, 'Paesens', NULL),
641(537, 100, 'Oosternijkerk', NULL),
642(538, 100, 'Niawier', NULL),
643(539, 100, 'Wierum', NULL),
644(540, 100, 'Moddergat', NULL),
645(541, 100, 'Nes Gemeente Dongeradeel', NULL),
646(542, 100, 'Hantumhuizen', NULL),
647(543, 100, 'Ternaard', NULL),
648(544, 100, 'Hantumeruitburen', NULL),
649(545, 100, 'Hantum', NULL),
650(546, 100, 'Hiaure', NULL),
651(547, 100, 'Holwerd', NULL),
652(548, 100, 'Waaxens Gemeente Dongeradeel', NULL),
653(549, 100, 'Brantgum', NULL),
654(550, 100, 'Foudgum', NULL),
655(551, 100, 'Raard', NULL),
656(552, 100, 'Bornwird', NULL),
657(553, 101, 'Dordrecht', NULL),
658(554, 102, 'Venhuizen', NULL),
659(555, 102, 'Hem', NULL),
660(556, 102, 'Wijdenes', NULL),
661(557, 102, 'Oosterleek', NULL),
662(558, 102, 'Hoogkarspel', NULL),
663(559, 102, 'Westwoud', NULL),
664(560, 102, 'Oosterblokker', NULL),
665(561, 102, 'Schellinkhout', NULL),
666(562, 103, 'Zevenberg Hoek Gemeente Drimmelen', NULL),
667(563, 103, 'Terheijden', NULL),
668(564, 103, 'Wagenberg', NULL),
669(565, 103, 'Made', NULL),
670(566, 103, 'Drimmelen', NULL),
671(567, 103, 'Lage Zwaluwe', NULL),
672(568, 103, 'Hooge Zwaluwe', NULL),
673(569, 104, 'Dronten', NULL),
674(570, 104, 'Swifterbant', NULL),
675(571, 104, 'Biddinghuizen', NULL),
676(572, 105, 'Horssen', NULL),
677(573, 105, 'Druten', NULL),
678(574, 105, 'Deest', NULL),
679(575, 105, 'Afferden (GLD)', NULL),
680(576, 105, 'Puiflijk', NULL),
681(577, 106, 'Duiven', NULL),
682(578, 106, 'Groessen', NULL),
683(579, 106, 'Loo (GLD)', NULL),
684(580, 107, 'Echt', NULL),
685(581, 107, 'Koningsbosch', NULL),
686(582, 107, 'Maria Hoop', NULL),
687(583, 107, 'Sint Joost', NULL),
688(584, 107, 'Susteren', NULL),
689(585, 107, 'Roosteren', NULL),
690(586, 107, 'Nieuwstadt', NULL),
691(587, 108, 'Volendam', NULL),
692(588, 108, 'Edam', NULL),
693(589, 108, 'Purmer', NULL),
694(590, 109, 'Ede (GLD)', NULL),
695(591, 109, 'Bennekom', NULL),
696(592, 109, 'Otterlo', NULL),
697(593, 109, 'Harskamp', NULL),
698(594, 109, 'Wekerom', NULL),
699(595, 109, 'Lunteren', NULL),
700(596, 109, 'Ederveen', NULL),
701(597, 109, 'De Klomp', NULL),
702(598, 109, 'Deelen', NULL),
703(599, 109, 'Hoenderloo', NULL),
704(600, 110, 'Eemnes', NULL),
705(601, 111, 'Startenhuizen', NULL),
706(602, 111, 'Eemshaven', NULL),
707(603, 111, 'Uithuizen', NULL),
708(604, 111, 'Uithuizermeeden', NULL),
709(605, 111, 'Roodeschool', NULL),
710(606, 111, 'Oudeschip', NULL),
711(607, 111, 'Oosternieland', NULL),
712(608, 111, 'Oldenzijl', NULL),
713(609, 111, 'Usquert', NULL),
714(610, 111, 'Warffum', NULL),
715(611, 111, 'Kantens', NULL),
716(612, 111, 'Eppenhuizen', NULL),
717(613, 111, 'Zandeweer', NULL),
718(614, 111, 'Rottum (GN)', NULL),
719(615, 111, 'Stitswerd', NULL),
720(616, 112, 'Knegsel', NULL),
721(617, 112, 'Vessem', NULL),
722(618, 112, 'Wintelre', NULL),
723(619, 112, 'Eersel', NULL),
724(620, 112, 'Steensel', NULL),
725(621, 112, 'Duizel', NULL),
726(622, 113, 'Eijsden', NULL),
727(623, 113, 'Gronsveld', NULL),
728(624, 114, 'Eindhoven', NULL),
729(625, 115, 'Elburg', NULL),
730(626, 115, 'T Harde', NULL),
731(627, 115, 'Doornspijk', NULL),
732(628, 116, 'Schoonebeek', NULL),
733(629, 116, 'Zandpol', NULL),
734(630, 116, 'Weiteveen', NULL),
735(631, 116, 'Nieuw Schoonebeek', NULL),
736(632, 116, 'Emmen', NULL),
737(633, 116, 'Nieuw Weerdinge', NULL),
738(634, 116, 'Nieuw Amsterdam', NULL),
739(635, 116, 'Veenoord', NULL),
740(636, 116, 'Emmer Compascuum', NULL),
741(637, 116, 'Barger Compascuum', NULL),
742(638, 116, 'Nieuw Dordrecht', NULL),
743(639, 116, 'Erica', NULL),
744(640, 116, 'Klazienaveen', NULL),
745(641, 116, 'Zwartemeer', NULL),
746(642, 116, 'Roswinkel', NULL),
747(643, 117, 'Enkhuizen', NULL),
748(644, 118, 'Enschede', NULL),
749(645, 119, 'Epe', NULL),
750(646, 119, 'Emst', NULL),
751(647, 119, 'Oene', NULL),
752(648, 119, 'Vaassen', NULL),
753(649, 120, 'Ermelo', NULL),
754(650, 121, 'Etten Leur', NULL),
755(651, 122, 'Marrum', NULL),
756(652, 122, 'Hallum', NULL),
757(653, 122, 'Jannum', NULL),
758(654, 122, 'Burdaard', NULL),
759(655, 122, 'Blije', NULL),
760(656, 122, 'Ferwert', NULL),
761(657, 122, 'Hegebeintum', NULL),
762(658, 122, 'Ginnum', NULL),
763(659, 122, 'Reitsum', NULL),
764(660, 122, 'Lichtaard', NULL),
765(661, 122, 'Jislum', NULL),
766(662, 122, 'Wanswert', NULL),
767(663, 123, 'Franeker', NULL),
768(664, 123, 'Tzum', NULL),
769(665, 123, 'Hitzum', NULL),
770(666, 123, 'Achlum', NULL),
771(667, 123, 'Herbaijum', NULL),
772(668, 123, 'Dongjum', NULL),
773(669, 123, 'Boer', NULL),
774(670, 123, 'Ried', NULL),
775(671, 123, 'Peins', NULL),
776(672, 123, 'Schalsum', NULL),
777(673, 123, 'Zweins', NULL),
778(674, 123, 'Tzummarum', NULL),
779(675, 123, 'Firdgum', NULL),
780(676, 123, 'Klooster Lidlum', NULL),
781(677, 123, 'Oosterbierum', NULL),
782(678, 123, 'Sexbierum', NULL),
783(679, 123, 'Pietersbierum', NULL),
784(680, 124, 'Sloten (FRL)', NULL),
785(681, 124, 'Balk', NULL),
786(682, 124, 'Wijckel', NULL),
787(683, 124, 'Ruigahuizen', NULL),
788(684, 124, 'Sondel', NULL),
789(685, 124, 'Nijemirdum', NULL),
790(686, 124, 'Oudemirdum', NULL),
791(687, 124, 'Harich', NULL),
792(688, 124, 'Rijs', NULL),
793(689, 124, 'Mirns', NULL),
794(690, 124, 'Bakhuizen', NULL),
795(691, 124, 'Elahuizen', NULL),
796(692, 124, 'Oudega Gemeente Gaasterland Sleat', NULL),
797(693, 124, 'Kolderwolde', NULL),
798(694, 125, 'Geertruidenberg', NULL),
799(695, 125, 'Raamsdonksveer', NULL),
800(696, 125, 'Raamsdonk', NULL),
801(697, 126, 'Acquoij', NULL),
802(698, 126, 'Rhenoij', NULL),
803(699, 126, 'Beesd', NULL),
804(700, 126, 'Gellicum', NULL),
805(701, 126, 'Rumpt', NULL),
806(702, 126, 'Enspijk', NULL),
807(703, 126, 'Deil', NULL),
808(704, 126, 'Geldermalsen', NULL),
809(705, 126, 'Meteren', NULL),
810(706, 126, 'Tricht', NULL),
811(707, 126, 'Buurmalsen', NULL),
812(708, 127, 'Geldrop', NULL),
813(709, 127, 'Mierlo', NULL),
814(710, 128, 'Gemert', NULL),
815(711, 128, 'Handel', NULL),
816(712, 128, 'Elsendorp', NULL),
817(713, 128, 'De Mortel', NULL),
818(714, 128, 'Bakel', NULL),
819(715, 128, 'Milheeze', NULL),
820(716, 128, 'De Rips', NULL),
821(717, 129, 'Gennep', NULL),
822(718, 129, 'Ottersum', NULL),
823(719, 129, 'Milsbeek', NULL),
824(720, 129, 'Heijen', NULL),
825(721, 130, 'Giessenburg', NULL),
826(722, 130, 'Schelluinen', NULL),
827(723, 130, 'Hoogblokland', NULL),
828(724, 130, 'Hoornaar', NULL),
829(725, 130, 'Noordeloos', NULL),
830(726, 130, 'Arkel', NULL),
831(727, 131, 'Rijen', NULL),
832(728, 131, 'Molenschot', NULL),
833(729, 131, 'Hulten', NULL),
834(730, 131, 'Gilze', NULL),
835(731, 132, 'Stellendam', NULL),
836(732, 132, 'Goedereede', NULL),
837(733, 132, 'Ouddorp (ZH)', NULL),
838(734, 133, 's Heer Arendskerke', NULL),
839(735, 133, 'Goes', NULL),
840(736, 133, 'Wolphaartsdijk', NULL),
841(737, 133, 's Heer Hendriks Kinderderen', NULL),
842(738, 133, 'Kattendijke', NULL),
843(739, 133, 'Wilhelminadorp', NULL),
844(740, 133, 'Kloetinge', NULL),
845(741, 134, 'Goirle', NULL),
846(742, 134, 'Riel', NULL),
847(743, 135, 'Gorinchem', NULL),
848(744, 135, 'Dalem', NULL),
849(745, 136, 'Gouda', NULL),
850(746, 137, 'Oud Alblas', NULL),
851(747, 137, 'Bleskensgraaf Ca', NULL),
852(748, 137, 'Molenaarsgraaf', NULL),
853(749, 137, 'Brandwijk', NULL),
854(750, 137, 'Ottoland', NULL),
855(751, 137, 'Goudriaan', NULL),
856(752, 137, 'Wijngaarden (ZH)', NULL),
857(753, 138, 'De Rijp', NULL),
858(754, 138, 'Graft', NULL),
859(755, 138, 'Noordeinde (NH)', NULL),
860(756, 138, 'West Graftdijk', NULL),
861(757, 138, 'Oost Graftdijk', NULL),
862(758, 138, 'Starnmeer', NULL),
863(759, 138, 'Markenbinnen', NULL),
864(760, 139, 'Grave', NULL),
865(761, 139, 'Velp (NB)', NULL),
866(762, 139, 'Escharen', NULL),
867(763, 139, 'Gassel', NULL),
868(764, 140, 'Lichtenvoorde', NULL),
869(765, 140, 'Vragender', NULL),
870(766, 140, 'Harreveld', NULL),
871(767, 140, 'Zieuwent', NULL),
872(768, 140, 'Lievelde', NULL),
873(769, 140, 'Groenlo', NULL),
874(770, 140, 'Marienvelde', NULL),
875(771, 141, 'Groesbeek', NULL),
876(772, 141, 'Heilig Landstichting', NULL),
877(773, 141, 'Berg En Dal', NULL),
878(774, 142, 'Groningen', NULL),
879(775, 143, 'Oldekerk', NULL),
880(776, 143, 'Niekerk Grootegast', NULL),
881(777, 143, 'Grootegast', NULL),
882(778, 143, 'Sebaldeburen', NULL),
883(779, 143, 'Doezum', NULL),
884(780, 143, 'Kornhorn', NULL),
885(781, 143, 'Opende', NULL),
886(782, 143, 'Lutjegast', NULL),
887(783, 144, 'Gulpen', NULL),
888(784, 144, 'Ingber', NULL),
889(785, 144, 'Reijmerstok', NULL),
890(786, 144, 'Heijenrath', NULL),
891(787, 144, 'Slenaken', NULL),
892(788, 144, 'Beutenaken', NULL),
893(789, 144, 'Mechelen', NULL),
894(790, 144, 'Epen', NULL),
895(791, 144, 'Wittem', NULL),
896(792, 144, 'Eijs', NULL),
897(793, 144, 'Elkenrade', NULL),
898(794, 144, 'Wijlre', NULL),
899(795, 145, 'Haaksbergen', NULL),
900(796, 146, 'Biezenmortel', NULL),
901(797, 146, 'Haaren', NULL),
902(798, 146, 'Helvoirt', NULL),
903(799, 146, 'Esch', NULL),
904(800, 147, 'Haarlem', NULL),
905(801, 147, 'Spaarndam West', NULL),
906(802, 148, 'Halfweg (NH)', NULL),
907(803, 148, 'Spaarndam', NULL),
908(804, 148, 'Haarlemmerliede', NULL),
909(805, 149, 'Schiphol', NULL),
910(806, 149, 'Luchthaven Schiphol', NULL),
911(807, 149, 'Schiphol Rijk', NULL),
912(808, 149, 'Zwanenburg', NULL),
913(809, 149, 'Badhoevedorp', NULL),
914(810, 149, 'Lijnden', NULL),
915(811, 149, 'Rijsenhout', NULL),
916(812, 149, 'Aalsmeerderbrug', NULL),
917(813, 149, 'Rozenburg (NH)', NULL),
918(814, 149, 'Oude Meer', NULL),
919(815, 149, 'Hoofddorp', NULL),
920(816, 149, 'Zwaanshoek', NULL),
921(817, 149, 'Vijfhuizen', NULL),
922(818, 149, 'Cruquius', NULL),
923(819, 149, 'Boesingheliede', NULL),
924(820, 149, 'Beinsdorp', NULL),
925(821, 149, 'Nieuw Vennep', NULL),
926(822, 149, 'Burgerveen', NULL),
927(823, 149, 'Leimuiderbrug', NULL),
928(824, 149, 'Weteringbrug', NULL),
929(825, 149, 'Abbenes', NULL),
930(826, 149, 'Buitenkaag', NULL),
931(827, 149, 'Lisserbroek', NULL),
932(828, 150, 'Haelen', NULL),
933(829, 150, 'Buggenum', NULL),
934(830, 150, 'Nunhem', NULL),
935(831, 150, 'Horn', NULL),
936(832, 151, 'Oudenbosch', NULL),
937(833, 151, 'Hoeven', NULL),
938(834, 151, 'Bosschenhoofd', NULL),
939(835, 151, 'Oud Gastel', NULL),
940(836, 151, 'Stampersgat', NULL),
941(837, 152, 'Bergentheim', NULL),
942(838, 152, 'Marienberg', NULL),
943(839, 152, 'Sibculo', NULL),
944(840, 152, 'Kloosterhaar', NULL),
945(841, 152, 'Bruchterveld', NULL),
946(842, 152, 'Brucht', NULL),
947(843, 152, 'Dedemsvaart', NULL),
948(844, 152, 'Balkbrug', NULL),
949(845, 152, 'Hardenberg', NULL),
950(846, 152, 'Lutten', NULL),
951(847, 152, 'Slagharen', NULL),
952(848, 152, 'Schuinesloot', NULL),
953(849, 152, 'Loozen', NULL),
954(850, 152, 'Holthone', NULL),
955(851, 152, 'De Krim', NULL),
956(852, 152, 'Gramsbergen', NULL),
957(853, 152, 'Ane', NULL),
958(854, 152, 'Anevelde', NULL),
959(855, 152, 'Den Velde', NULL),
960(856, 152, 'Holtheme', NULL),
961(857, 152, 'Anerveen', NULL),
962(858, 152, 'Radewijk', NULL),
963(859, 152, 'Venebrugge', NULL),
964(860, 152, 'Hoogenweg', NULL),
965(861, 152, 'Rheeze', NULL),
966(862, 152, 'Diffelen', NULL),
967(863, 152, 'Heemserveen', NULL),
968(864, 152, 'Rheezerveen', NULL),
969(865, 152, 'Collendoorn', NULL),
970(866, 153, 'Harderwijk', NULL),
971(867, 153, 'Hierden', NULL),
972(868, 154, 'Hardinxveld Giessendam', NULL),
973(869, 155, 'Noordlaren', NULL),
974(870, 155, 'Haren (GN)', NULL),
975(871, 155, 'Onnen', NULL),
976(872, 155, 'Glimmen', NULL),
977(873, 156, 'Waarland', NULL),
978(874, 156, 'Sint Maarten', NULL),
979(875, 156, 'Dirkshorn', NULL),
980(876, 156, 'Tuitjenhorn', NULL),
981(877, 156, 'Warmenhuizen', NULL),
982(878, 157, 'Wijnaldum', NULL),
983(879, 157, 'Harlingen', NULL),
984(880, 157, 'Midlum', NULL),
985(881, 158, 'Hattem', NULL),
986(882, 159, 'Wessem', NULL),
987(883, 159, 'Heel', NULL),
988(884, 159, 'Beegden', NULL),
989(885, 160, 'Heemskerk', NULL),
990(886, 161, 'Heemstede', NULL),
991(887, 162, 'Heerde', NULL),
992(888, 162, 'Wapenveld', NULL),
993(889, 162, 'Vorchten', NULL),
994(890, 162, 'Veessen', NULL),
995(891, 163, 'Jubbega', NULL),
996(892, 163, 'Hoornsterzwaag', NULL),
997(893, 163, 'Oudehorne', NULL),
998(894, 163, 'Nieuwehorne', NULL),
999(895, 163, 'Bontebok', NULL),
1000(896, 163, 'Heerenveen', NULL),
1001(897, 163, 'Terband', NULL),
1002(898, 163, 'Oudeschoot', NULL),
1003(899, 163, 'Nieuweschoot', NULL),
1004(900, 163, 'Oranjewoud', NULL),
1005(901, 163, 'Mildam', NULL),
1006(902, 163, 'Katlijk', NULL),
1007(903, 163, 'De Knipe', NULL),
1008(904, 163, 'Gersloot', NULL),
1009(905, 163, 'Tjalleberd', NULL),
1010(906, 163, 'Luinjeberd', NULL),
1011(907, 164, 'Heerhugowaard', NULL),
1012(908, 165, 'Heerlen', NULL),
1013(909, 165, 'Hoensbroek', NULL),
1014(910, 166, 'Heeze', NULL),
1015(911, 166, 'Leende', NULL),
1016(912, 166, 'Sterksel', NULL),
1017(913, 167, 'Heiloo', NULL),
1018(914, 168, 'Panningen', NULL),
1019(915, 168, 'Koningslust', NULL),
1020(916, 168, 'Grashoek', NULL),
1021(917, 168, 'Beringe', NULL),
1022(918, 168, 'Egchel', NULL),
1023(919, 168, 'Helden', NULL),
1024(920, 169, 'Nijverdal', NULL),
1025(921, 169, 'Hellendoorn', NULL),
1026(922, 169, 'Haarle Gemeente Hellendoorn', NULL),
1027(923, 169, 'Daarlerveen', NULL),
1028(924, 169, 'Daarle', NULL),
1029(925, 170, 'Hellevoetsluis', NULL),
1030(926, 171, 'Helmond', NULL),
1031(927, 172, 'Hendrik Ido Ambacht', NULL),
1032(928, 173, 'Hengelo (OV)', NULL),
1033(929, 174, 'Minnertsga', NULL),
1034(930, 174, 'Westhoek', NULL),
1035(931, 174, 'Sint Annaparochie', NULL),
1036(932, 174, 'Vrouwenparochie', NULL),
1037(933, 174, 'Oude Bildtzijl', NULL),
1038(934, 174, 'Sint Jacobiparochie', NULL),
1039(935, 175, 'Malden', NULL),
1040(936, 175, 'Heumen', NULL),
1041(937, 175, 'Overasselt', NULL),
1042(938, 175, 'Nederasselt', NULL),
1043(939, 176, 'Drunen', NULL),
1044(940, 176, 'Elshout', NULL),
1045(941, 176, 'Vlijmen', NULL),
1046(942, 176, 'Nieuwkuijk', NULL),
1047(943, 176, 'Haarsteeg', NULL),
1048(944, 176, 'Heusden Gemeente Heusden', NULL),
1049(945, 177, 'Kelpen Oler', NULL),
1050(946, 177, 'Heijthuijsen', NULL),
1051(947, 177, 'Baexem', NULL),
1052(948, 177, 'Grathem', NULL),
1053(949, 178, 'Hillegom', NULL),
1054(950, 179, 'Hilvarenbeek', NULL),
1055(951, 179, 'Biest Houtakker', NULL),
1056(952, 179, 'Esbeek', NULL),
1057(953, 179, 'Diessen', NULL),
1058(954, 179, 'Haghorst', NULL),
1059(955, 180, 'Hilversum', NULL),
1060(956, 181, 'Goor', NULL),
1061(957, 181, 'Markelo', NULL),
1062(958, 181, 'Diepenheim', NULL),
1063(959, 181, 'Delden', NULL),
1064(960, 181, 'Ambt Delden', NULL),
1065(961, 181, 'Hengevelde', NULL),
1066(962, 181, 'Bentelo', NULL),
1067(963, 182, 'Hoogeveen', NULL),
1068(964, 182, 'Nieuweroord', NULL),
1069(965, 182, 'Hollandscheveld', NULL),
1070(966, 182, 'Noordscheschut', NULL),
1071(967, 182, 'Alteveer Hoogeveen', NULL),
1072(968, 182, 'Elim', NULL),
1073(969, 182, 'Nieuwlande', NULL),
1074(970, 182, 'Fluitenberg', NULL),
1075(971, 182, 'Pesse', NULL),
1076(972, 182, 'Stuifzand', NULL),
1077(973, 182, 'Tiendeveen', NULL),
1078(974, 183, 'Hoogezand', NULL),
1079(975, 183, 'Kiel Windeweer', NULL),
1080(976, 183, 'Kropswolde', NULL),
1081(977, 183, 'Foxhol', NULL),
1082(978, 183, 'Westerbroek', NULL),
1083(979, 183, 'Waterhuizen', NULL),
1084(980, 183, 'Sappemeer', NULL),
1085(981, 184, 'Hoorn (NH)', NULL),
1086(982, 184, 'Zwaag', NULL),
1087(983, 184, 'Blokker', NULL),
1088(984, 185, 'Griendtsveen', NULL),
1089(985, 185, 'Broekhuizenvorst', NULL),
1090(986, 185, 'Broekhuizen (LB)', NULL),
1091(987, 185, 'Horst', NULL),
1092(988, 185, 'Melderslo', NULL),
1093(989, 185, 'Hegelsom', NULL),
1094(990, 185, 'Meterik', NULL),
1095(991, 185, 'America', NULL),
1096(992, 185, 'Grubbenvorst', NULL),
1097(993, 185, 'Lottum', NULL),
1098(994, 186, 'Houten', NULL),
1099(995, 186, 't Goij', NULL),
1100(996, 186, 'Schalkwijk', NULL),
1101(997, 186, 'Tull en t Waal', NULL),
1102(998, 187, 'Huizen', NULL),
1103(999, 188, 'Hulst', NULL),
1104(1000, 188, 'Sint Jansteen', NULL),
1105(1001, 188, 'Kapellebrug', NULL),
1106(1002, 188, 'Heikant', NULL),
1107(1003, 188, 'Clinge', NULL),
1108(1004, 188, 'Nieuw Namen', NULL),
1109(1005, 188, 'Graauw', NULL),
1110(1006, 188, 'Vogelwaarde', NULL),
1111(1007, 188, 'Terhole', NULL),
1112(1008, 188, 'Kuitaart', NULL),
1113(1009, 188, 'Hengstdijk', NULL),
1114(1010, 188, 'Lamswaarde', NULL),
1115(1011, 188, 'Kloosterzande', NULL),
1116(1012, 188, 'Walsoorden', NULL),
1117(1013, 188, 'Ossenisse', NULL),
1118(1014, 189, 'Ell', NULL),
1119(1015, 189, 'Haler', NULL),
1120(1016, 189, 'Hunsel', NULL),
1121(1017, 189, 'Ittervoort', NULL),
1122(1018, 189, 'Neeritter', NULL),
1123(1019, 190, 'IJsselstein (UT)', NULL),
1124(1020, 191, 'Hoogmade', NULL),
1125(1021, 191, 'Leimuiden', NULL),
1126(1022, 191, 'Rijnsaterwoude', NULL),
1127(1023, 191, 'Woubrugge', NULL),
1128(1024, 192, 'Kampen', NULL),
1129(1025, 192, 'IJsselmuiden', NULL),
1130(1026, 192, 'Wilsum', NULL),
1131(1027, 192, 's Heerenbroek', NULL),
1132(1028, 192, 'Zalk', NULL),
1133(1029, 192, 'Grafhorst', NULL),
1134(1030, 192, 'Kamperveen', NULL),
1135(1031, 192, 'Mastenbroek', NULL),
1136(1032, 193, 'Kapelle', NULL),
1137(1033, 193, 'Schore', NULL),
1138(1034, 193, 'Wemeldinge', NULL),
1139(1035, 193, 'Kloetinge', NULL),
1140(1036, 194, 'Katwijk (ZH)', NULL),
1141(1037, 194, 'Rijnsburg', NULL),
1142(1038, 194, 'Valkenburg (ZH)', NULL),
1143(1039, 195, 'Kerkrade', NULL),
1144(1040, 195, 'Eijgelshoven', NULL),
1145(1041, 196, 'Kessel (LB)', NULL),
1146(1042, 197, 'Kollum', NULL),
1147(1043, 197, 'Augsbuurt', NULL),
1148(1044, 197, 'Kollumerpomp', NULL),
1149(1045, 197, 'Oudwoude', NULL),
1150(1046, 197, 'Westergeest', NULL),
1151(1047, 197, 'Triemen', NULL),
1152(1048, 197, 'Veenklooster', NULL),
1153(1049, 197, 'Kollumerzwaag', NULL),
1154(1050, 197, 'Zwagerbosch', NULL),
1155(1051, 197, 'Burum', NULL),
1156(1052, 197, 'Warfstermolen', NULL),
1157(1053, 197, 'Munnekezijl', NULL),
1158(1054, 198, 'Nieuw Beijerland', NULL),
1159(1055, 198, 'Piershil', NULL),
1160(1056, 198, 'Goudswaard', NULL),
1161(1057, 198, 'Zuid Beijerland', NULL),
1162(1058, 199, 'Krimpen aan den IJssel', NULL),
1163(1059, 200, 'Aarle Rixtel', NULL),
1164(1060, 200, 'Lieshout', NULL),
1165(1061, 200, 'Mariahout', NULL),
1166(1062, 200, 'Beek en Donk', NULL),
1167(1063, 201, 'Schaijk', NULL),
1168(1064, 201, 'Reek', NULL),
1169(1065, 201, 'Zeeland', NULL),
1170(1066, 202, 'Landgraaf', NULL),
1171(1067, 203, 'Landsmeer', NULL),
1172(1068, 203, 'Den Ilp', NULL),
1173(1069, 203, 'Purmerland', NULL),
1174(1070, 204, 'Broek op Langedijk', NULL),
1175(1071, 204, 'Zuid Scharwoude', NULL),
1176(1072, 204, 'Noord Scharwoude', NULL),
1177(1073, 204, 'Oudkarspel', NULL),
1178(1074, 204, 'Koedijk', NULL),
1179(1075, 204, 'Sint Pancras', NULL),
1180(1076, 205, 'Laren (NH)', NULL),
1181(1077, 206, 'Leek', NULL),
1182(1078, 206, 'Zevenhuizen (GN)', NULL),
1183(1079, 206, 'Midwolde', NULL),
1184(1080, 206, 'Tolbert', NULL),
1185(1081, 206, 'Boerakker Gemeente Leek', NULL),
1186(1082, 206, 'Enumatil', NULL),
1187(1083, 206, 'Lettelbert', NULL),
1188(1084, 206, 'Oostwold Gemeente Leek', NULL),
1189(1085, 207, 'Leerdam', NULL),
1190(1086, 207, 'Schoonrewoerd', NULL),
1191(1087, 207, 'Oosterwijk', NULL),
1192(1088, 207, 'Kedichem', NULL),
1193(1089, 208, 'Leeuwarden', NULL),
1194(1090, 208, 'Lekkum', NULL),
1195(1091, 208, 'Miedum', NULL),
1196(1092, 208, 'Snakkerburen', NULL),
1197(1093, 208, 'Goutum', NULL),
1198(1094, 208, 'Teerns', NULL),
1199(1095, 208, 'Hempens', NULL),
1200(1096, 208, 'Swichum', NULL),
1201(1097, 208, 'Wirdum (FRL)', NULL),
1202(1098, 208, 'Wijtgaard', NULL),
1203(1099, 209, 'Stiens', NULL),
1204(1100, 209, 'Finkum', NULL),
1205(1101, 209, 'Hijum', NULL),
1206(1102, 209, 'Britsum', NULL),
1207(1103, 209, 'Cornjum', NULL),
1208(1104, 209, 'Jelsum', NULL),
1209(1105, 209, 'Oude Leije', NULL),
1210(1106, 210, 'Leiden', NULL),
1211(1107, 211, 'Leiderdorp', NULL),
1212(1108, 212, 'Leidschendam', NULL),
1213(1109, 212, 'Voorburg', NULL),
1214(1110, 213, 'Lelystad', NULL),
1215(1111, 214, 'Delfstrahuizen', NULL),
1216(1112, 214, 'Lemmer', NULL),
1217(1113, 214, 'Eesterga', NULL),
1218(1114, 214, 'Follega', NULL),
1219(1115, 214, 'Oosterzee', NULL),
1220(1116, 214, 'Echten (FRL)', NULL),
1221(1117, 214, 'Bantega', NULL),
1222(1118, 214, 'Echtenerbrug', NULL),
1223(1119, 215, 'Achterveld', NULL),
1224(1120, 215, 'Leusden', NULL),
1225(1121, 215, 'Stoutenburg', NULL),
1226(1122, 216, 'Vrouwenakker', NULL),
1227(1123, 216, 'Noorden', NULL),
1228(1124, 216, 'Zevenhoven', NULL),
1229(1125, 216, 'Nieuwveen', NULL),
1230(1126, 217, 'Streefkerk', NULL),
1231(1127, 217, 'Groot Ammers', NULL),
1232(1128, 217, 'Nieuwpoort', NULL),
1233(1129, 217, 'Langerak (ZH)', NULL),
1234(1130, 217, 'Waal', NULL),
1235(1131, 218, 'Asperen', NULL),
1236(1132, 218, 'Heukelum', NULL),
1237(1133, 218, 'Herwijnen', NULL),
1238(1134, 218, 'Spijk Gemeente Lingewaal', NULL),
1239(1135, 218, 'Vuren', NULL),
1240(1136, 219, 'Bemmel', NULL),
1241(1137, 219, 'Ressen', NULL),
1242(1138, 219, 'Haalderen', NULL),
1243(1139, 219, 'Doornenburg', NULL),
1244(1140, 219, 'Angeren', NULL),
1245(1141, 219, 'Gendt', NULL),
1246(1142, 219, 'Huissen', NULL),
1247(1143, 220, 'Lisse', NULL),
1248(1144, 221, 'Oijen', NULL),
1249(1145, 221, 'Teeffelen', NULL),
1250(1146, 221, 'Lithoijen', NULL),
1251(1147, 221, 'Lith', NULL),
1252(1148, 221, 'Maren Kessel', NULL),
1253(1149, 222, 'Boazum', NULL),
1254(1150, 222, 'Britswert', NULL),
1255(1151, 222, 'Wiuwert', NULL),
1256(1152, 222, 'Rien', NULL),
1257(1153, 222, 'Lijtsewierrum', NULL),
1258(1154, 222, 'Wommels', NULL),
1259(1155, 222, 'Kubaard', NULL),
1260(1156, 222, 'Iens', NULL),
1261(1157, 222, 'Easterein', NULL),
1262(1158, 222, 'Itens', NULL),
1263(1159, 222, 'Reahus', NULL),
1264(1160, 222, 'Hidaard', NULL),
1265(1161, 222, 'Winsum (FRL)', NULL),
1266(1162, 222, 'Huns', NULL),
1267(1163, 222, 'Leons', NULL),
1268(1164, 222, 'Baard', NULL),
1269(1165, 222, 'Easterlittens', NULL),
1270(1166, 222, 'Baaium', NULL),
1271(1167, 222, 'Wjelsrijp', NULL),
1272(1168, 222, 'Spannum', NULL),
1273(1169, 222, 'Hinnaard', NULL),
1274(1170, 222, 'Waaksens Gemeente Littenseradiel', NULL),
1275(1171, 222, 'Easterwierrum', NULL),
1276(1172, 222, 'Mantgum', NULL),
1277(1173, 222, 'Jorwert', NULL),
1278(1174, 222, 'Weidum', NULL),
1279(1175, 222, 'Bears (FRL)', NULL),
1280(1176, 222, 'Jellum', NULL),
1281(1177, 222, 'Hilaard', NULL),
1282(1178, 223, 'Eefde', NULL),
1283(1179, 223, 'Gorssel', NULL),
1284(1180, 223, 'Epse', NULL),
1285(1181, 223, 'Joppe', NULL),
1286(1182, 223, 'Kring Van Dorth', NULL),
1287(1183, 223, 'Harfsen', NULL),
1288(1184, 223, 'Almen', NULL),
1289(1185, 223, 'Lochem', NULL),
1290(1186, 223, 'Barchem', NULL),
1291(1187, 223, 'Laren (GLD)', NULL),
1292(1188, 224, 'Nigtevecht', NULL),
1293(1189, 224, 'Nieuwersluis', NULL),
1294(1190, 224, 'Loenen aan de Vecht', NULL),
1295(1191, 224, 'Vreeland', NULL),
1296(1192, 224, 'Loenersloot', NULL),
1297(1193, 225, 'Kaatsheuvel', NULL),
1298(1194, 225, 'Loon Op Zand', NULL),
1299(1195, 225, 'De Moer', NULL),
1300(1196, 226, 'Benschop', NULL),
1301(1197, 226, 'Lopik', NULL),
1302(1198, 226, 'Lopikerkapel', NULL),
1303(1199, 226, 'Jaarsveld', NULL),
1304(1200, 226, 'Polsbroek', NULL),
1305(1201, 227, 'Oosterwijtwerd', NULL),
1306(1202, 227, 'Leermens', NULL),
1307(1203, 227, 'Eenum', NULL),
1308(1204, 227, 'Zeerijp', NULL),
1309(1205, 227, 'T Zandt (GN)', NULL),
1310(1206, 227, 'Wirdum (GN)', NULL),
1311(1207, 227, 'Garrelsweer', NULL),
1312(1208, 227, 'Loppersum', NULL),
1313(1209, 227, 'Stedum', NULL),
1314(1210, 227, 'Westeremden', NULL),
1315(1211, 227, 'Garsthuizen', NULL),
1316(1212, 227, 'Startenhuizen Gemeente Loppersum', NULL),
1317(1213, 227, 'Zijldijk', NULL),
1318(1214, 227, 'Middelstum', NULL),
1319(1215, 227, 'Huizinge', NULL),
1320(1216, 227, 'Westerwijtwerd', NULL),
1321(1217, 227, 'Toornwerd', NULL),
1322(1218, 228, 'Losser', NULL),
1323(1219, 228, 'Glane', NULL),
1324(1220, 228, 'Overdinkel', NULL),
1325(1221, 228, 'De Lutte', NULL),
1326(1222, 228, 'Beuningen (OV)', NULL),
1327(1223, 229, 'Maarssen', NULL),
1328(1224, 229, 'Oud Zuilen', NULL),
1329(1225, 229, 'Tienhoven (UT)', NULL),
1330(1226, 230, 'Maasbracht', NULL),
1331(1227, 230, 'Linne', NULL),
1332(1228, 230, 'Stevensweert', NULL),
1333(1229, 230, 'Ohe En Laak', NULL),
1334(1230, 231, 'Baarlo (LB)', NULL),
1335(1231, 231, 'Maasbree', NULL),
1336(1232, 232, 'Vinkel', NULL),
1337(1233, 232, 'Geffen', NULL),
1338(1234, 232, 'Nuland', NULL),
1339(1235, 233, 'Hedel', NULL),
1340(1236, 233, 'Ammerzoden', NULL),
1341(1237, 233, 'Well (GLD)', NULL),
1342(1238, 233, 'Hurwenen', NULL),
1343(1239, 233, 'Rossum (GLD)', NULL),
1344(1240, 233, 'Kerkdriel', NULL),
1345(1241, 233, 'Hoenzadriel', NULL),
1346(1242, 233, 'Velddriel', NULL),
1347(1243, 233, 'Alem', NULL),
1348(1244, 233, 'Heerewaarden', NULL),
1349(1245, 234, 'Maassluis', NULL),
1350(1246, 235, 'Maastricht', NULL),
1351(1247, 236, 'Eckelrade', NULL),
1352(1248, 236, 'Noorbeek', NULL),
1353(1249, 236, 'Mheer', NULL),
1354(1250, 236, 'Banholt', NULL),
1355(1251, 236, 'Sint Geertruid', NULL),
1356(1252, 236, 'Cadier En Keer', NULL),
1357(1253, 236, 'Bemelen', NULL),
1358(1254, 236, 'Margraten', NULL),
1359(1255, 236, 'Scheulder', NULL),
1360(1256, 237, 'Boerakker', NULL),
1361(1257, 237, 'Marum', NULL),
1362(1258, 237, 'Nuis', NULL),
1363(1259, 237, 'Niebert', NULL),
1364(1260, 237, 'Jonkersvaart', NULL),
1365(1261, 237, 'De Wilp (GN)', NULL),
1366(1262, 237, 'Noordwijk (GN)', NULL),
1367(1263, 237, 'Lucaswolde', NULL),
1368(1264, 238, 'Medemblik', NULL),
1369(1265, 239, 'Wanssum', NULL),
1370(1266, 239, 'Geijsteren', NULL),
1371(1267, 239, 'Blitterswijck', NULL),
1372(1268, 239, 'Meerlo', NULL),
1373(1269, 239, 'Tienraij', NULL),
1374(1270, 239, 'Swolgen', NULL),
1375(1271, 240, 'Meerssen', NULL),
1376(1272, 240, 'Ulestraten', NULL),
1377(1273, 240, 'Moorveld', NULL),
1378(1274, 240, 'Bunde', NULL),
1379(1275, 240, 'Geulle', NULL),
1380(1276, 241, 'Meijel', NULL),
1381(1277, 242, 'Schingen', NULL),
1382(1278, 242, 'Boksum', NULL),
1383(1279, 242, 'Blessum', NULL),
1384(1280, 242, 'Deinum', NULL),
1385(1281, 242, 'Marssum', NULL),
1386(1282, 242, 'Dronrijp', NULL),
1387(1283, 242, 'Menaldum', NULL),
1388(1284, 242, 'Slappeterp', NULL),
1389(1285, 242, 'Engelum', NULL),
1390(1286, 242, 'Berlikum (FRL)', NULL),
1391(1287, 242, 'Wier', NULL),
1392(1288, 242, 'Beetgum', NULL),
1393(1289, 242, 'Beetgumermolen', NULL),
1394(1290, 243, 'Borgercompagnie', NULL),
1395(1291, 243, 'Tripscompagnie', NULL),
1396(1292, 243, 'Noordbroek', NULL),
1397(1293, 243, 'Zuidbroek', NULL),
1398(1294, 243, 'Muntendam', NULL),
1399(1295, 243, 'Meeden', NULL),
1400(1296, 244, 'Meppel', NULL),
1401(1297, 244, 'Nijeveen', NULL),
1402(1298, 244, 'Rogat', NULL),
1403(1299, 244, 'Broekhuizen (DR)', NULL),
1404(1300, 244, 'De Schiphorst', NULL),
1405(1301, 245, 'Middelburg', NULL),
1406(1302, 245, 'Nieuw en Sint Joosland', NULL),
1407(1303, 245, 'Arnemuiden', NULL),
1408(1304, 246, 'Middelharnis', NULL),
1409(1305, 246, 'Stad Aan Het Haringvliet', NULL),
1410(1306, 246, 'Nieuwe Tonge', NULL),
1411(1307, 246, 'Sommelsdijk', NULL),
1412(1308, 247, 'Den Hoorn (ZH)', NULL),
1413(1309, 247, 'Schipluiden', NULL),
1414(1310, 247, 'Maasland', NULL),
1415(1311, 248, 'Nieuw Balinge', NULL),
1416(1312, 248, 'Beilen', NULL),
1417(1313, 248, 'Hooghalen', NULL),
1418(1314, 248, 'Hijken', NULL),
1419(1315, 248, 'Oranje', NULL),
1420(1316, 248, 'Spier', NULL),
1421(1317, 248, 'Wijster', NULL),
1422(1318, 248, 'Drijber', NULL),
1423(1319, 248, 'Bovensmilde', NULL),
1424(1320, 248, 'Smilde', NULL),
1425(1321, 248, 'Hoogersmilde', NULL),
1426(1322, 248, 'Westerbork', NULL),
1427(1323, 248, 'Zuidveld', NULL),
1428(1324, 248, 'Zwiggelte', NULL),
1429(1325, 248, 'Eursinge', NULL),
1430(1326, 248, 'Bruntinge', NULL),
1431(1327, 248, 'Mantinge', NULL),
1432(1328, 248, 'Balinge', NULL),
1433(1329, 248, 'Garminge', NULL),
1434(1330, 248, 'Witteveen', NULL),
1435(1331, 248, 'Orvelte', NULL),
1436(1332, 248, 'Elp', NULL),
1437(1333, 249, 'Mill', NULL),
1438(1334, 249, 'Langenboom', NULL),
1439(1335, 249, 'Sint Hubert', NULL),
1440(1336, 249, 'Wilbertoord', NULL),
1441(1337, 250, 'Millingen aan den Rijn', NULL),
1442(1338, 251, 'Standdaarbuiten', NULL),
1443(1339, 251, 'Zevenbergen', NULL),
1444(1340, 251, 'Zevenbergschen Hoek', NULL),
1445(1341, 251, 'Langeweg', NULL),
1446(1342, 251, 'Moerdijk', NULL),
1447(1343, 251, 'Klundert', NULL),
1448(1344, 251, 'Fijnaart', NULL),
1449(1345, 251, 'Heijningen', NULL),
1450(1346, 251, 'Oudemolen (NB)', NULL),
1451(1347, 251, 'Willemstad (NB)', NULL),
1452(1348, 252, 'Didam', NULL),
1453(1349, 252, 'Kilder', NULL),
1454(1350, 252, 'Loerbeek', NULL),
1455(1351, 252, 'Beek Montferland', NULL),
1456(1352, 252, 'Zeddam', NULL),
1457(1353, 252, 'Stokkum', NULL),
1458(1354, 252, 'S Heerenberg', NULL),
1459(1355, 252, 'Lengel', NULL),
1460(1356, 252, 'Azewijn', NULL),
1461(1357, 252, 'Vethuizen', NULL),
1462(1358, 252, 'Braamt', NULL),
1463(1359, 252, 'Wijnbergen', NULL),
1464(1360, 253, 'Montfoort', NULL),
1465(1361, 253, 'Linschoten', NULL),
1466(1362, 254, 'Molenhoek (LB)', NULL),
1467(1363, 254, 'Mook', NULL),
1468(1364, 254, 'Plasmolen', NULL),
1469(1365, 254, 'Middelaar', NULL),
1470(1366, 255, 'Moordrecht', NULL),
1471(1367, 256, 'Muiden', NULL),
1472(1368, 256, 'Muiderberg', NULL),
1473(1369, 257, 'Naarden', NULL),
1474(1370, 258, 'Kesteren', NULL),
1475(1371, 258, 'Opheusden', NULL),
1476(1372, 258, 'Ochten', NULL),
1477(1373, 258, 'IJzendoorn', NULL),
1478(1374, 258, 'Echteld', NULL),
1479(1375, 258, 'Dodewaard', NULL),
1480(1376, 259, 'Krimpen aan de Lek', NULL),
1481(1377, 259, 'Lekkerkerk', NULL),
1482(1378, 260, 'Nederweert', NULL),
1483(1379, 260, 'Nederweert Eind', NULL),
1484(1380, 260, 'Ospel', NULL),
1485(1381, 260, 'Leveroij', NULL),
1486(1382, 261, 'Ophemert', NULL),
1487(1383, 261, 'Heesselt', NULL),
1488(1384, 261, 'Varik', NULL),
1489(1385, 261, 'Hellouw', NULL),
1490(1386, 261, 'Haaften', NULL),
1491(1387, 261, 'Tuil', NULL),
1492(1388, 261, 'Waardenburg', NULL),
1493(1389, 261, 'Neerijnen', NULL),
1494(1390, 261, 'Opijnen', NULL),
1495(1391, 261, 'Est', NULL),
1496(1392, 262, 'Winkel', NULL),
1497(1393, 262, 'Lutjewinkel', NULL),
1498(1394, 262, 'Nieuwe Niedorp', NULL),
1499(1395, 262, 'Oude Niedorp', NULL),
1500(1396, 262, 't Veld', NULL),
1501(1397, 262, 'Zijdewind', NULL),
1502(1398, 262, 'Kolhorn', NULL),
1503(1399, 262, 'Barsingerhorn', NULL),
1504(1400, 263, 'Nieuw Lekkerland', NULL),
1505(1401, 263, 'Kinderdijk', NULL),
1506(1402, 264, 'Nieuwegein', NULL),
1507(1403, 265, 'Nieuwerkerk aan den IJssel', NULL),
1508(1404, 266, 'Nieuwkoop', NULL),
1509(1405, 266, 'Noorden', NULL),
1510(1406, 266, 'Woerdense Verlaat', NULL),
1511(1407, 267, 'Hemelum', NULL),
1512(1408, 267, 'Workum', NULL),
1513(1409, 267, 'Hindeloopen', NULL),
1514(1410, 267, 'Stavoren', NULL),
1515(1411, 267, 'Warns', NULL),
1516(1412, 267, 'Molkwerum', NULL),
1517(1413, 267, 'Koudum', NULL),
1518(1414, 267, 'It Heidenskip', NULL),
1519(1415, 267, 'Nijhuizum', NULL),
1520(1416, 268, 'Nijkerk', NULL),
1521(1417, 268, 'Nijkerkerveen', NULL),
1522(1418, 268, 'Hoevelaken', NULL),
1523(1419, 269, 'Nijmegen', NULL),
1524(1420, 269, 'Lent', NULL),
1525(1421, 269, 'Oosterhout Gemeente Nijmegen', NULL),
1526(1422, 269, 'Ressen Gemeente Nijmegen', NULL),
1527(1423, 270, 'Kortgene', NULL),
1528(1424, 270, 'Kats', NULL),
1529(1425, 270, 'Colijnsplaat', NULL),
1530(1426, 270, 'Wissenkerke', NULL),
1531(1427, 270, 'Kamperland', NULL),
1532(1428, 270, 'Geersdijk', NULL),
1533(1429, 271, 'Roden', NULL),
1534(1430, 271, 'Lieveren', NULL),
1535(1431, 271, 'Roderesch', NULL),
1536(1432, 271, 'Alteveer Gemeente Noordenveld', NULL),
1537(1433, 271, 'Steenbergen (DR)', NULL),
1538(1434, 271, 'Nieuw Roden', NULL),
1539(1435, 271, 'Nietap', NULL),
1540(1436, 271, 'Leutingewolde', NULL),
1541(1437, 271, 'Foxwolde', NULL),
1542(1438, 271, 'Roderwolde', NULL),
1543(1439, 271, 'Peize', NULL),
1544(1440, 271, 'Norg', NULL),
1545(1441, 271, 'Langelo (DR)', NULL),
1546(1442, 271, 'Peest', NULL),
1547(1443, 271, 'Zuidvelde', NULL),
1548(1444, 271, 'Huis Ter Heide (DR)', NULL),
1549(1445, 271, 'Westervelde', NULL),
1550(1446, 271, 'Veenhuizen', NULL),
1551(1447, 271, 'Een', NULL),
1552(1448, 271, 'Een West', NULL),
1553(1449, 271, 'Matsloot', NULL),
1554(1450, 272, 'Benningbroek', NULL),
1555(1451, 272, 'Sijbekarspel', NULL),
1556(1452, 272, 'Abbekerk', NULL),
1557(1453, 272, 'Lambertschaag', NULL),
1558(1454, 272, 'Opperdoes', NULL),
1559(1455, 272, 'Twisk', NULL),
1560(1456, 272, 'Oostwoud', NULL),
1561(1457, 272, 'Midwoud', NULL),
1562(1458, 272, 'Hauwert', NULL),
1563(1459, 273, 'Emmeloord', NULL),
1564(1460, 273, 'Ens', NULL),
1565(1461, 273, 'Nagele', NULL),
1566(1462, 273, 'Tollebeek', NULL),
1567(1463, 273, 'Espel', NULL),
1568(1464, 273, 'Creil', NULL),
1569(1465, 273, 'Rutten', NULL),
1570(1466, 273, 'Bant', NULL),
1571(1467, 273, 'Luttelgeest', NULL),
1572(1468, 273, 'Marknesse', NULL),
1573(1469, 273, 'Kraggenburg', NULL),
1574(1470, 274, 'Noordwijk (ZH)', NULL),
1575(1471, 275, 'De Zilk', NULL),
1576(1472, 275, 'Noordwijkerhout', NULL),
1577(1473, 276, 'Nuenen', NULL),
1578(1474, 277, 'Nunspeet', NULL),
1579(1475, 277, 'Elspeet', NULL),
1580(1476, 277, 'Vierhouten', NULL),
1581(1477, 277, 'Hulshorst', NULL),
1582(1478, 278, 'Schimmert', NULL),
1583(1479, 278, 'Hulsberg', NULL),
1584(1480, 278, 'Nuth', NULL),
1585(1481, 278, 'Wijnandsrade', NULL),
1586(1482, 279, 'Hensbroek', NULL),
1587(1483, 279, 'Obdam', NULL),
1588(1484, 280, 'Oegstgeest', NULL),
1589(1485, 281, 'Oost West Middelbeers', NULL),
1590(1486, 281, 'Oirschot', NULL),
1591(1487, 282, 'Heukelom (NB)', NULL),
1592(1488, 282, 'Oisterwijk', NULL),
1593(1489, 282, 'Moergestel', NULL),
1594(1490, 283, 'Noordeinde (GLD)', NULL),
1595(1491, 283, 'Wezep', NULL),
1596(1492, 283, 'Hattemerbroek', NULL),
1597(1493, 283, 'T Loo Gemeente Oldebroek', NULL),
1598(1494, 283, 'Oldebroek', NULL),
1599(1495, 283, 'Oosterwolde (GLD)', NULL),
1600(1496, 284, 'Deurningen', NULL),
1601(1497, 284, 'Oldenzaal', NULL),
1602(1498, 285, 'Olst', NULL),
1603(1499, 285, 'Wesepe', NULL),
1604(1500, 285, 'Wijhe', NULL),
1605(1501, 285, 'Welsum', NULL),
1606(1502, 285, 'Marle', NULL),
1607(1503, 286, 'Beerzerveld', NULL),
1608(1504, 286, 'Ommen', NULL),
1609(1505, 286, 'Vilsteren', NULL),
1610(1506, 286, 'Arrien', NULL),
1611(1507, 286, 'Beerze', NULL),
1612(1508, 286, 'Stegeren', NULL),
1613(1509, 286, 'Witharen', NULL),
1614(1510, 286, 'Vinkenbuurt', NULL),
1615(1511, 286, 'Dalmsholte', NULL),
1616(1512, 286, 'Giethmen', NULL),
1617(1513, 286, 'Lemele', NULL),
1618(1514, 287, 'Merkelbeek', NULL),
1619(1515, 287, 'Schinveld', NULL),
1620(1516, 287, 'Jabeek', NULL),
1621(1517, 287, 'Bingelrade', NULL),
1622(1518, 288, 'Dorst', NULL),
1623(1519, 288, 'Oosterhout (NB)', NULL),
1624(1520, 288, 'Oosteind', NULL),
1625(1521, 288, 'Den Hout (NB)', NULL),
1626(1522, 289, 'Oude Tonge', NULL),
1627(1523, 289, 'Achthuizen', NULL),
1628(1524, 289, 'Ooltgensplaat', NULL),
1629(1525, 289, 'Den Bommel', NULL),
1630(1526, 290, 'Oldeberkoop', NULL),
1631(1527, 290, 'Nijeberkoop', NULL),
1632(1528, 290, 'Makkinga', NULL),
1633(1529, 290, 'Elsloo Fr', NULL),
1634(1530, 290, 'Langedijke', NULL),
1635(1531, 290, 'Appelscha', NULL),
1636(1532, 290, 'Ravenswoud', NULL),
1637(1533, 290, 'Fochteloo', NULL),
1638(1534, 290, 'Oosterwolde (FRL)', NULL),
1639(1535, 290, 'Haule', NULL),
1640(1536, 290, 'Haulerwijk', NULL),
1641(1537, 290, 'Waskemeer', NULL),
1642(1538, 290, 'Donkerbroek', NULL),
1643(1539, 291, 'Oostzaan', NULL),
1644(1540, 292, 'De Weere', NULL),
1645(1541, 292, 'Spanbroek', NULL),
1646(1542, 292, 'Opmeer', NULL),
1647(1543, 292, 'Hoogwoud', NULL),
1648(1544, 292, 'Aartswoud', NULL),
1649(1545, 293, 'Gorredijk', NULL),
1650(1546, 293, 'Jonkerslan', NULL),
1651(1547, 293, 'Langezwaag', NULL),
1652(1548, 293, 'Luxwoude', NULL),
1653(1549, 293, 'Tijnje', NULL),
1654(1550, 293, 'Terwispel', NULL),
1655(1551, 293, 'Lippenhuizen', NULL),
1656(1552, 293, 'Hemrik', NULL),
1657(1553, 293, 'Wijnjewoude', NULL),
1658(1554, 293, 'Bakkeveen', NULL),
1659(1555, 293, 'Beetsterzwaag', NULL),
1660(1556, 293, 'Nij Beets', NULL),
1661(1557, 293, 'Olterterp', NULL),
1662(1558, 293, 'Ureterp', NULL),
1663(1559, 293, 'Siegerswoude', NULL),
1664(1560, 293, 'Frieschepalen', NULL),
1665(1561, 294, 'Oss', NULL),
1666(1562, 294, 'Berghem', NULL),
1667(1563, 294, 'Megen', NULL),
1668(1564, 294, 'Macharen', NULL),
1669(1565, 294, 'Haren (NB)', NULL),
1670(1566, 294, 'Ravenstein', NULL),
1671(1567, 294, 'Herpen', NULL),
1672(1568, 295, 'Oud Beijerland', NULL),
1673(1569, 296, 'Varsseveld', NULL),
1674(1570, 296, 'Westendorp', NULL),
1675(1571, 296, 'Heelweg', NULL),
1676(1572, 296, 'Terborg', NULL),
1677(1573, 296, 'Silvolde', NULL),
1678(1574, 296, 'Sinderen', NULL),
1679(1575, 296, 'Ulft', NULL),
1680(1576, 296, 'Etten (GLD)', NULL),
1681(1577, 296, 'Varsselder En Veldhunten', NULL),
1682(1578, 296, 'Netterden', NULL),
1683(1579, 296, 'Megchelen', NULL),
1684(1580, 296, 'Gendringen', NULL),
1685(1581, 296, 'Voorst Gemeente Gendringen', NULL),
1686(1582, 296, 'Breedenbroek', NULL),
1687(1583, 296, 'Sinderen Gemeente Gendringen', NULL),
1688(1584, 297, 'Duivendrecht', NULL),
1689(1585, 297, 'Ouderkerk Amstel', NULL),
1690(1586, 298, 'Gouderak', NULL),
1691(1587, 298, 'Ouderkerk aan den IJssel', NULL),
1692(1588, 299, 'Oudewater', NULL),
1693(1589, 299, 'Snelrewaard', NULL),
1694(1590, 299, 'Papekop', NULL),
1695(1591, 299, 'Hekendorp', NULL),
1696(1592, 300, 'Elst (GLD)', NULL),
1697(1593, 300, 'Driel', NULL),
1698(1594, 300, 'Heteren', NULL),
1699(1595, 300, 'Randwijk', NULL),
1700(1596, 300, 'Zetten', NULL),
1701(1597, 300, 'Hemmen', NULL),
1702(1598, 300, 'Andelst', NULL),
1703(1599, 300, 'Herveld', NULL),
1704(1600, 300, 'Valburg', NULL),
1705(1601, 300, 'Homoet', NULL),
1706(1602, 300, 'Slijk Ewijk', NULL),
1707(1603, 300, 'Oosterhout (GLD)', NULL),
1708(1604, 301, 'Papendrecht', NULL),
1709(1605, 302, 'Alteveer (GN)', NULL),
1710(1606, 302, 'Nieuwe Pekela', NULL),
1711(1607, 302, 'Oude Pekela', NULL),
1712(1608, 303, 'Nootdorp', NULL),
1713(1609, 303, 'Pijnacker', NULL),
1714(1610, 303, 'Delfgauw', NULL),
1715(1611, 304, 'Purmerend', NULL),
1716(1612, 305, 'Putten', NULL),
1717(1613, 306, 'Laag Zuthem', NULL),
1718(1614, 306, 'Raalte', NULL),
1719(1615, 306, 'Luttenberg', NULL),
1720(1616, 306, 'Marienheem', NULL),
1721(1617, 306, 'Broekland (OV)', NULL),
1722(1618, 306, 'Heeten', NULL),
1723(1619, 306, 'Nieuw Heeten', NULL),
1724(1620, 306, 'Heino', NULL),
1725(1621, 306, 'Lierderholthuis', NULL),
1726(1622, 307, 'Reeuwijk', NULL),
1727(1623, 307, 'Driebruggen', NULL),
1728(1624, 307, 'Waarder', NULL),
1729(1625, 308, 'Finsterwolde', NULL),
1730(1626, 308, 'Beerta', NULL),
1731(1627, 308, 'Nieuw Beerta', NULL),
1732(1628, 308, 'Drieborg', NULL),
1733(1629, 308, 'Oudezijl', NULL),
1734(1630, 308, 'Nieuweschans', NULL),
1735(1631, 309, 'Yerseke', NULL),
1736(1632, 309, 'Rilland', NULL),
1737(1633, 309, 'Krabbendijke', NULL),
1738(1634, 309, 'Waarde', NULL),
1739(1635, 309, 'Oostdijk', NULL),
1740(1636, 309, 'Kruiningen', NULL),
1741(1637, 309, 'Hansweert', NULL),
1742(1638, 310, 'Oosterbeek', NULL),
1743(1639, 310, 'Doorwerth', NULL),
1744(1640, 310, 'Heelsum', NULL),
1745(1641, 310, 'Renkum', NULL),
1746(1642, 310, 'Wolfheze', NULL),
1747(1643, 311, 'Renswoude', NULL),
1748(1644, 312, 'Lage Mierde', NULL),
1749(1645, 312, 'Hooge Mierde', NULL),
1750(1646, 312, 'Hulsel', NULL),
1751(1647, 312, 'Reusel', NULL),
1752(1648, 313, 'Velp (GLD)', NULL),
1753(1649, 313, 'Dieren', NULL),
1754(1650, 313, 'Ellecom', NULL),
1755(1651, 313, 'Spankeren', NULL),
1756(1652, 313, 'Laag Soeren', NULL),
1757(1653, 313, 'Rheden', NULL),
1758(1654, 313, 'De Steeg', NULL),
1759(1655, 314, 'Rhenen', NULL),
1760(1656, 314, 'Elst (UT)', NULL),
1761(1657, 315, 'Ridderkerk', NULL),
1762(1658, 316, 'Pannerden', NULL),
1763(1659, 316, 'Aerdt', NULL),
1764(1660, 316, 'Herwen', NULL),
1765(1661, 316, 'Lobith', NULL),
1766(1662, 316, 'Tolkamer', NULL),
1767(1663, 316, 'Spijk (GLD)', NULL),
1768(1664, 317, 'Hazerswoude Dorp', NULL),
1769(1665, 317, 'Hazerswoude Rijndijk', NULL),
1770(1666, 317, 'Koudekerk aan den Rijn', NULL),
1771(1667, 317, 'Benthuizen', NULL),
1772(1668, 318, 'Holten', NULL),
1773(1669, 318, 'Rijssen', NULL),
1774(1670, 319, 'Rijswijk (ZH)', NULL),
1775(1671, 320, 'Vlodrop', NULL),
1776(1672, 320, 'Melick', NULL),
1777(1673, 320, 'Herkenbosch', NULL),
1778(1674, 321, 'Roermond', NULL),
1779(1675, 321, 'Herten', NULL),
1780(1676, 322, 'Neer', NULL),
1781(1677, 322, 'Roggel', NULL),
1782(1678, 322, 'Heibloem', NULL),
1783(1679, 323, 'Roosendaal', NULL),
1784(1680, 323, 'Nispen', NULL),
1785(1681, 323, 'Wouw', NULL),
1786(1682, 323, 'Wouwse Plantage', NULL),
1787(1683, 323, 'Heerle', NULL),
1788(1684, 323, 'Moerstraten', NULL),
1789(1685, 324, 'Rotterdam', NULL),
1790(1686, 324, 'Hoek Van Holland', NULL),
1791(1687, 324, 'Hoogvliet Rotterdam', NULL),
1792(1688, 324, 'Pernis Rotterdam', NULL),
1793(1689, 324, 'Vondelingenplaat Rotterdam', NULL),
1794(1690, 324, 'Botlek Rotterdam', NULL),
1795(1691, 324, 'Europoort Rotterdam', NULL),
1796(1692, 324, 'Maasvlakte Rotterdam', NULL),
1797(1693, 325, 'Rozenburg (ZH)', NULL),
1798(1694, 326, 'Rozendaal', NULL),
1799(1695, 327, 'Sint Willebrord', NULL),
1800(1696, 327, 'Sprundel', NULL),
1801(1697, 327, 'Rucphen', NULL),
1802(1698, 327, 'Schijf', NULL);
1803INSERT INTO `city` (`id`, `municipalityId`, `name`, `img`) VALUES
1804(1699, 327, 'Zegge', NULL),
1805(1700, 328, 's Gravendeel', NULL),
1806(1701, 329, 'Den Haag', NULL),
1807(1702, 330, 'Den Bosch', NULL),
1808(1703, 330, 'Rosmalen', NULL),
1809(1704, 331, 'Schagen', NULL),
1810(1705, 332, 'Heiligerlee', NULL),
1811(1706, 332, 'Westerlee (GN)', NULL),
1812(1707, 332, 'Scheemda', NULL),
1813(1708, 332, 'Midwolda', NULL),
1814(1709, 332, 'Oostwold Scheemda', NULL),
1815(1710, 332, 'Blauwestad', NULL),
1816(1711, 332, 'T Waar', NULL),
1817(1712, 332, 'Nieuw Scheemda', NULL),
1818(1713, 332, 'Nieuwolda', NULL),
1819(1714, 333, 'Schermerhorn', NULL),
1820(1715, 333, 'Ursem Gemeente Schermer', NULL),
1821(1716, 333, 'Stompetoren', NULL),
1822(1717, 333, 'Oterleek', NULL),
1823(1718, 333, 'Grootschermer', NULL),
1824(1719, 333, 'Driehuizen', NULL),
1825(1720, 333, 'Zuidschermer', NULL),
1826(1721, 334, 'Scherpenzeel (GLD)', NULL),
1827(1722, 335, 'Schiedam', NULL),
1828(1723, 336, 'Schiermonnikoog', NULL),
1829(1724, 337, 'Schijndel', NULL),
1830(1725, 338, 'Puth', NULL),
1831(1726, 338, 'Sweikhuizen', NULL),
1832(1727, 338, 'Schinnen', NULL),
1833(1728, 338, 'Amstenrade', NULL),
1834(1729, 338, 'Oirsbeek', NULL),
1835(1730, 338, 'Doenrade', NULL),
1836(1731, 339, 'Schoonhoven', NULL),
1837(1732, 340, 'Zierikzee', NULL),
1838(1733, 340, 'Ouwerkerk', NULL),
1839(1734, 340, 'Nieuwerkerk', NULL),
1840(1735, 340, 'Oosterland', NULL),
1841(1736, 340, 'Sirjansland', NULL),
1842(1737, 340, 'Bruinisse', NULL),
1843(1738, 340, 'Dreischor', NULL),
1844(1739, 340, 'Zonnemaire', NULL),
1845(1740, 340, 'Noordgouwe', NULL),
1846(1741, 340, 'Brouwershaven', NULL),
1847(1742, 340, 'Kerkwerve', NULL),
1848(1743, 340, 'Scharendijke', NULL),
1849(1744, 340, 'Ellemeet', NULL),
1850(1745, 340, 'Renesse', NULL),
1851(1746, 340, 'Noordwelle', NULL),
1852(1747, 340, 'Serooskerke Schouw', NULL),
1853(1748, 340, 'Burgh Haamstede', NULL),
1854(1749, 341, 'Sevenum', NULL),
1855(1750, 341, 'Kronenberg', NULL),
1856(1751, 341, 'Evertsoord', NULL),
1857(1752, 342, 'Bocholtz', NULL),
1858(1753, 342, 'Baneheide', NULL),
1859(1754, 342, 'Simpelveld', NULL),
1860(1755, 343, 'Landhorst', NULL),
1861(1756, 343, 'Wanroij', NULL),
1862(1757, 343, 'Rijkevoort Walsert', NULL),
1863(1758, 343, 'Oploo', NULL),
1864(1759, 343, 'Westerbeek', NULL),
1865(1760, 343, 'Stevensbeek', NULL),
1866(1761, 343, 'Sint Anthonis', NULL),
1867(1762, 343, 'Ledeacker', NULL),
1868(1763, 344, 'Berlicum (NB)', NULL),
1869(1764, 344, 'Sint Michielsgestel', NULL),
1870(1765, 344, 'Den Dungen', NULL),
1871(1766, 344, 'Gemonde', NULL),
1872(1767, 345, 'Sint Oedenrode', NULL),
1873(1768, 346, 'Born', NULL),
1874(1769, 346, 'Buchten', NULL),
1875(1770, 346, 'Holtum', NULL),
1876(1771, 346, 'Papenhoven', NULL),
1877(1772, 346, 'Obbicht', NULL),
1878(1773, 346, 'Grevenbicht', NULL),
1879(1774, 346, 'Sittard', NULL),
1880(1775, 346, 'Limbricht', NULL),
1881(1776, 346, 'Einighausen', NULL),
1882(1777, 346, 'Guttecoven', NULL),
1883(1778, 346, 'Munstergeleen', NULL),
1884(1779, 346, 'Windraak', NULL),
1885(1780, 346, 'Geleen', NULL),
1886(1781, 347, 'Rottum (FRL)', NULL),
1887(1782, 347, 'Rotstergaast', NULL),
1888(1783, 347, 'Rotsterhaule', NULL),
1889(1784, 347, 'Sintjohannesga', NULL),
1890(1785, 347, 'Oudehaske', NULL),
1891(1786, 347, 'Nijehaske', NULL),
1892(1787, 347, 'Vegelinsoord', NULL),
1893(1788, 347, 'Haskerdijken', NULL),
1894(1789, 347, 'Nieuwebrug', NULL),
1895(1790, 347, 'Joure', NULL),
1896(1791, 347, 'Snikzwaag', NULL),
1897(1792, 347, 'Haskerhorne', NULL),
1898(1793, 347, 'Rohel', NULL),
1899(1794, 347, 'Goingarijp', NULL),
1900(1795, 347, 'Broek (FRL)', NULL),
1901(1796, 347, 'Ouwsterhaule', NULL),
1902(1797, 347, 'Ouwster Nijega', NULL),
1903(1798, 347, 'Oldeouwer', NULL),
1904(1799, 347, 'Doniaga', NULL),
1905(1800, 347, 'Scharsterbrug', NULL),
1906(1801, 347, 'Sint Nicolaasga', NULL),
1907(1802, 347, 'Tjerkgaast', NULL),
1908(1803, 347, 'Idskenhuizen', NULL),
1909(1804, 347, 'Teroele', NULL),
1910(1805, 347, 'Langweer', NULL),
1911(1806, 347, 'Boornzwaag', NULL),
1912(1807, 347, 'Legemeer', NULL),
1913(1808, 347, 'Dijken', NULL),
1914(1809, 347, 'Akmarijp', NULL),
1915(1810, 347, 'Terkaple', NULL),
1916(1811, 348, 'Sliedrecht', NULL),
1917(1812, 349, 'Kolham', NULL),
1918(1813, 349, 'Scharmer', NULL),
1919(1814, 349, 'Harkstede', NULL),
1920(1815, 349, 'Woudbloem', NULL),
1921(1816, 349, 'Froombosch', NULL),
1922(1817, 349, 'Slochteren', NULL),
1923(1818, 349, 'Lageland', NULL),
1924(1819, 349, 'Luddeweer', NULL),
1925(1820, 349, 'Overschild', NULL),
1926(1821, 349, 'Schildwolde', NULL),
1927(1822, 349, 'Hellum', NULL),
1928(1823, 349, 'Siddeburen', NULL),
1929(1824, 349, 'Steendam', NULL),
1930(1825, 349, 'Tjuchem', NULL),
1931(1826, 350, 'Oostburg', NULL),
1932(1827, 350, 'Groede', NULL),
1933(1828, 350, 'Nieuwvliet', NULL),
1934(1829, 350, 'Zuidzande', NULL),
1935(1830, 350, 'Cadzand', NULL),
1936(1831, 350, 'Schoondijke', NULL),
1937(1832, 350, 'Waterlandkerkje', NULL),
1938(1833, 350, 'Breskens', NULL),
1939(1834, 350, 'Hoofdplaat', NULL),
1940(1835, 350, 'IJzendijke', NULL),
1941(1836, 350, 'Biervliet', NULL),
1942(1837, 350, 'Sluis', NULL),
1943(1838, 350, 'Retranchement', NULL),
1944(1839, 350, 'Aardenburg', NULL),
1945(1840, 350, 'Sint Kruis', NULL),
1946(1841, 350, 'Eede Zld', NULL),
1947(1842, 351, 'Goengahuizen', NULL),
1948(1843, 351, 'Drachten', NULL),
1949(1844, 351, 'Kortehemmen', NULL),
1950(1845, 351, 'Boornbergum', NULL),
1951(1846, 351, 'De Wilgen', NULL),
1952(1847, 351, 'Smalle Ee', NULL),
1953(1848, 351, 'De Veenhoop', NULL),
1954(1849, 351, 'Oudega Gemeente Smallingerland', NULL),
1955(1850, 351, 'Nijega', NULL),
1956(1851, 351, 'Opeinde', NULL),
1957(1852, 351, 'De Tike', NULL),
1958(1853, 351, 'Rottevalle', NULL),
1959(1854, 351, 'Drachtstercompagn', NULL),
1960(1855, 351, 'Houtigehage', NULL),
1961(1856, 352, 'Sneek', NULL),
1962(1857, 352, 'Offingawier', NULL),
1963(1858, 352, 'Loenga', NULL),
1964(1859, 352, 'ijsbrechtum', NULL),
1965(1860, 353, 'Soest', NULL),
1966(1861, 353, 'Soesterberg', NULL),
1967(1862, 354, 'Someren', NULL),
1968(1863, 354, 'Lierop', NULL),
1969(1864, 355, 'Son', NULL),
1970(1865, 355, 'Breugel', NULL),
1971(1866, 356, 'Spijkenisse', NULL),
1972(1867, 356, 'Hekelingen', NULL),
1973(1868, 357, 'Stadskanaal', NULL),
1974(1869, 357, 'Musselkanaal', NULL),
1975(1870, 357, 'Mussel', NULL),
1976(1871, 357, 'Vledderveen (GN)', NULL),
1977(1872, 357, 'Onstwedde', NULL),
1978(1873, 357, 'Alteveer (GN)', NULL),
1979(1874, 358, 'Punthorst', NULL),
1980(1875, 358, 'Staphorst', NULL),
1981(1876, 358, 'Rouveen', NULL),
1982(1877, 358, 'IJhorst', NULL),
1983(1878, 359, 'Bovenkarspel', NULL),
1984(1879, 359, 'Grootebroek', NULL),
1985(1880, 359, 'Lutjebroek', NULL),
1986(1881, 360, 'Steenbergen (NB)', NULL),
1987(1882, 360, 'De Heen', NULL),
1988(1883, 360, 'Dinteloord', NULL),
1989(1884, 360, 'Nieuw Vossemeer', NULL),
1990(1885, 360, 'Kruisland', NULL),
1991(1886, 361, 'Wanneperveen', NULL),
1992(1887, 361, 'Belt Schutsloot', NULL),
1993(1888, 361, 'Vollenhove', NULL),
1994(1889, 361, 'Sint Jansklooster', NULL),
1995(1890, 361, 'Steenwijk', NULL),
1996(1891, 361, 'Tuk', NULL),
1997(1892, 361, 'Witte Paarden', NULL),
1998(1893, 361, 'Baars', NULL),
1999(1894, 361, 'De Pol', NULL),
2000(1895, 361, 'Willemsoord', NULL),
2001(1896, 361, 'Marijenkampen', NULL),
2002(1897, 361, 'Steenwijkerwold', NULL),
2003(1898, 361, 'Basse', NULL),
2004(1899, 361, 'Zuidveen', NULL),
2005(1900, 361, 'Onna', NULL),
2006(1901, 361, 'Kallenkote', NULL),
2007(1902, 361, 'De Bult', NULL),
2008(1903, 361, 'Eesveen', NULL),
2009(1904, 361, 'Giethoorn', NULL),
2010(1905, 361, 'Blokzijl', NULL),
2011(1906, 361, 'IJsselham', NULL),
2012(1907, 361, 'Nederland', NULL),
2013(1908, 361, 'Wetering', NULL),
2014(1909, 361, 'Scheerwolde', NULL),
2015(1910, 361, 'Baarlo Ov', NULL),
2016(1911, 361, 'Blankenham', NULL),
2017(1912, 361, 'Kuinre', NULL),
2018(1913, 361, 'Oldemarkt', NULL),
2019(1914, 361, 'Ossenzijl', NULL),
2020(1915, 361, 'Kalenberg', NULL),
2021(1916, 361, 'Paasloo', NULL),
2022(1917, 362, 'Urmond', NULL),
2023(1918, 362, 'Stein (LB)', NULL),
2024(1919, 362, 'Elsloo (LB)', NULL),
2025(1920, 363, 'Strijen', NULL),
2026(1921, 363, 'Strijensas', NULL),
2027(1922, 363, 'Mookhoek', NULL),
2028(1923, 364, 'Swalmen', NULL),
2029(1924, 365, 'Ten Boer', NULL),
2030(1925, 365, 'Ten Post', NULL),
2031(1926, 365, 'Winneweer', NULL),
2032(1927, 365, 'Lellens', NULL),
2033(1928, 365, 'Woltersum', NULL),
2034(1929, 365, 'Sint Annen', NULL),
2035(1930, 365, 'Thesinge', NULL),
2036(1931, 365, 'Garmerwolde', NULL),
2037(1932, 366, 'Ter Aar', NULL),
2038(1933, 367, 'Biervliet', NULL),
2039(1934, 367, 'Terneuzen', NULL),
2040(1935, 367, 'Spui', NULL),
2041(1936, 367, 'Sluiskil', NULL),
2042(1937, 367, 'Hoek', NULL),
2043(1938, 367, 'Zaamslag', NULL),
2044(1939, 367, 'Sas Van Gent', NULL),
2045(1940, 367, 'Philippine', NULL),
2046(1941, 367, 'Westdorpe', NULL),
2047(1942, 367, 'Axel', NULL),
2048(1943, 367, 'Zuiddorpe', NULL),
2049(1944, 367, 'Overslag', NULL),
2050(1945, 367, 'Koewacht', NULL),
2051(1946, 368, 'Terschelling West', NULL),
2052(1947, 368, 'Terschelling Hee', NULL),
2053(1948, 368, 'Terschelling Kaart', NULL),
2054(1949, 368, 'Terschelling Baaid', NULL),
2055(1950, 368, 'Terschelling Kinum', NULL),
2056(1951, 368, 'Terschelling Midld', NULL),
2057(1952, 368, 'Terschelling Serijp', NULL),
2058(1953, 368, 'Terschelling Landr', NULL),
2059(1954, 368, 'Terschelling Formr', NULL),
2060(1955, 368, 'Terschelling Lies', NULL),
2061(1956, 368, 'Terschelling Hoorn', NULL),
2062(1957, 368, 'Terschelling Oosterend', NULL),
2063(1958, 369, 'Den Burg', NULL),
2064(1959, 369, 'Oudeschild', NULL),
2065(1960, 369, 'De Waal', NULL),
2066(1961, 369, 'Oosterend (NH)', NULL),
2067(1962, 369, 'De Cocksdorp', NULL),
2068(1963, 369, 'De Koog', NULL),
2069(1964, 369, 'Den Hoorn Texel', NULL),
2070(1965, 370, 'Sassenheim', NULL),
2071(1966, 370, 'Voorhout', NULL),
2072(1967, 370, 'Warmond', NULL),
2073(1968, 371, 'Sint Philipsland', NULL),
2074(1969, 371, 'Tholen', NULL),
2075(1970, 371, 'Poortvliet', NULL),
2076(1971, 371, 'Scherpenisse', NULL),
2077(1972, 371, 'Sint Maartensdijk', NULL),
2078(1973, 371, 'Stavenisse', NULL),
2079(1974, 371, 'Sint Annaland', NULL),
2080(1975, 371, 'Oud Vossemeer', NULL),
2081(1976, 372, 'Thorn', NULL),
2082(1977, 373, 'Tiel', NULL),
2083(1978, 373, 'Kapel Avezaath Gemeente Tiel', NULL),
2084(1979, 373, 'Wadenoijen', NULL),
2085(1980, 373, 'Kerk Avezaath Gemeente Tiel', NULL),
2086(1981, 373, 'Zennewijnen', NULL),
2087(1982, 374, 'Tilburg', NULL),
2088(1983, 374, 'Berkel Enschot', NULL),
2089(1984, 374, 'Udenhout', NULL),
2090(1985, 375, 'Mariaparochie', NULL),
2091(1986, 375, 'Harbrinkhoek', NULL),
2092(1987, 375, 'Tubbergen', NULL),
2093(1988, 375, 'Vasse', NULL),
2094(1989, 375, 'Hezingen', NULL),
2095(1990, 375, 'Mander', NULL),
2096(1991, 375, 'Manderveen', NULL),
2097(1992, 375, 'Albergen', NULL),
2098(1993, 375, 'Fleringen', NULL),
2099(1994, 375, 'Reutum', NULL),
2100(1995, 375, 'Haarle Gemeente Tubbergen', NULL),
2101(1996, 375, 'Geesteren (OV)', NULL),
2102(1997, 375, 'Langeveen', NULL),
2103(1998, 376, 'Vriezenveen', NULL),
2104(1999, 376, 'Bruinehaar', NULL),
2105(2000, 376, 'Westerhaar Vriezenveensche Wijk', NULL),
2106(2001, 376, 'Vroomshoop', NULL),
2107(2002, 376, 'Den Ham (OV)', NULL),
2108(2003, 377, 'Zuidlaren', NULL),
2109(2004, 377, 'De Groeve', NULL),
2110(2005, 377, 'Zuidlaarderveen', NULL),
2111(2006, 377, 'Midlaren', NULL),
2112(2007, 377, 'Vries', NULL),
2113(2008, 377, 'Tijnaarlo', NULL),
2114(2009, 377, 'Zeegse', NULL),
2115(2010, 377, 'Oudemolen (DR)', NULL),
2116(2011, 377, 'Taarlo', NULL),
2117(2012, 377, 'Zeijen', NULL),
2118(2013, 377, 'De Punt', NULL),
2119(2014, 377, 'IJde', NULL),
2120(2015, 377, 'Winde', NULL),
2121(2016, 377, 'Bunne', NULL),
2122(2017, 377, 'Donderen', NULL),
2123(2018, 377, 'Eelde', NULL),
2124(2019, 377, 'Paterswolde', NULL),
2125(2020, 377, 'Eelderwolde', NULL),
2126(2021, 378, 'Gijtsjerk', NULL),
2127(2022, 378, 'Oentsjerk', NULL),
2128(2023, 378, 'Munein', NULL),
2129(2024, 378, 'Aldtsjerk', NULL),
2130(2025, 378, 'Wijns', NULL),
2131(2026, 378, 'Burgum', NULL),
2132(2027, 378, 'Hurdegarijp', NULL),
2133(2028, 378, 'Tytsjerk', NULL),
2134(2029, 378, 'Ryptsjerk', NULL),
2135(2030, 378, 'Noardburgum', NULL),
2136(2031, 378, 'Jistrum', NULL),
2137(2032, 378, 'Eastermar', NULL),
2138(2033, 378, 'Sumar', NULL),
2139(2034, 378, 'Garijp', NULL),
2140(2035, 378, 'Earnewald', NULL),
2141(2036, 378, 'Suwald', NULL),
2142(2037, 379, 'Berg En Dal', NULL),
2143(2038, 379, 'Beek Ubbergen', NULL),
2144(2039, 379, 'Ubbergen', NULL),
2145(2040, 379, 'Persingen', NULL),
2146(2041, 379, 'Ooij', NULL),
2147(2042, 379, 'Erlecom', NULL),
2148(2043, 379, 'Leuth', NULL),
2149(2044, 379, 'Kekerdom', NULL),
2150(2045, 380, 'Uden', NULL),
2151(2046, 380, 'Volkel', NULL),
2152(2047, 380, 'Odiliapeel', NULL),
2153(2048, 381, 'Uitgeest', NULL),
2154(2049, 382, 'Uithoorn', NULL),
2155(2050, 382, 'De Kwakel', NULL),
2156(2051, 383, 'Urk', NULL),
2157(2052, 384, 'Vleuten', NULL),
2158(2053, 384, 'De Meern', NULL),
2159(2054, 384, 'Haarzuilens', NULL),
2160(2055, 384, 'Utrecht', NULL),
2161(2056, 385, 'Doorn', NULL),
2162(2057, 385, 'Maarn', NULL),
2163(2058, 385, 'Maarsbergen', NULL),
2164(2059, 385, 'Leersum', NULL),
2165(2060, 385, 'Amerongen', NULL),
2166(2061, 385, 'Overberg', NULL),
2167(2062, 385, 'Driebergen Rijsenburg', NULL),
2168(2063, 386, 'Vaals', NULL),
2169(2064, 386, 'Vijlen', NULL),
2170(2065, 386, 'Lemiers', NULL),
2171(2066, 387, 'Valkenburg (LB)', NULL),
2172(2067, 387, 'Schin Op Geul', NULL),
2173(2068, 387, 'Berg En Terblijt', NULL),
2174(2069, 387, 'Walem', NULL),
2175(2070, 388, 'Valkenswaard', NULL),
2176(2071, 389, 'Borgercompagnie', NULL),
2177(2072, 389, 'Veendam', NULL),
2178(2073, 389, 'Wildervank', NULL),
2179(2074, 390, 'Veenendaal', NULL),
2180(2075, 391, 'Veere', NULL),
2181(2076, 391, 'Gapinge', NULL),
2182(2077, 391, 'Serooskerke Walcheren', NULL),
2183(2078, 391, 'Vrouwenpolder', NULL),
2184(2079, 391, 'Oostkapelle', NULL),
2185(2080, 391, 'Domburg', NULL),
2186(2081, 391, 'Westkapelle', NULL),
2187(2082, 391, 'Aagtekerke', NULL),
2188(2083, 391, 'Grijpskerke', NULL),
2189(2084, 391, 'Meliskerke', NULL),
2190(2085, 391, 'Koudekerke', NULL),
2191(2086, 391, 'Biggekerke', NULL),
2192(2087, 391, 'Zoutelande', NULL),
2193(2088, 392, 'Veghel', NULL),
2194(2089, 392, 'Erp', NULL),
2195(2090, 393, 'Veldhoven', NULL),
2196(2091, 394, 'Velsen Noord', NULL),
2197(2092, 394, 'IJmuiden', NULL),
2198(2093, 394, 'Velsen Zuid', NULL),
2199(2094, 394, 'Driehuis (NH)', NULL),
2200(2095, 394, 'Velserbroek', NULL),
2201(2096, 394, 'Santpoort Noord', NULL),
2202(2097, 394, 'Santpoort Zuid', NULL),
2203(2098, 395, 'Venlo', NULL),
2204(2099, 395, 'Tegelen', NULL),
2205(2100, 395, 'Steijl', NULL),
2206(2101, 395, 'Belfeld', NULL),
2207(2102, 396, 'Venray', NULL),
2208(2103, 396, 'Oostrum (LB)', NULL),
2209(2104, 396, 'Oirlo', NULL),
2210(2105, 396, 'Leunen', NULL),
2211(2106, 396, 'Castenraij', NULL),
2212(2107, 396, 'Heide', NULL),
2213(2108, 396, 'IJsselsteijn (LB)', NULL),
2214(2109, 396, 'Veulen', NULL),
2215(2110, 396, 'Merselo', NULL),
2216(2111, 396, 'Vredepeel', NULL),
2217(2112, 396, 'Smakt', NULL),
2218(2113, 397, 'Ossenwaard (UT)', NULL),
2219(2114, 397, 'Everdingen', NULL),
2220(2115, 397, 'Zijderveld', NULL),
2221(2116, 397, 'Hagestein', NULL),
2222(2117, 397, 'Vianen (UT)', NULL),
2223(2118, 398, 'Vlaardingen', NULL),
2224(2119, 399, 'Vlagtwedde', NULL),
2225(2120, 399, 'Bourtange', NULL),
2226(2121, 399, 'Sellingen', NULL),
2227(2122, 399, 'Ter Apel', NULL),
2228(2123, 399, 'Ter Apelkanaal', NULL),
2229(2124, 400, 'Vlieland', NULL),
2230(2125, 401, 'Vlissingen', NULL),
2231(2126, 401, 'Oost Souburg', NULL),
2232(2127, 401, 'Ritthem', NULL),
2233(2128, 402, 'Stolwijk', NULL),
2234(2129, 402, 'Haastrecht', NULL),
2235(2130, 402, 'Vlist', NULL),
2236(2131, 403, 'Ransdaal', NULL),
2237(2132, 403, 'Klimmen', NULL),
2238(2133, 403, 'Voerendaal', NULL),
2239(2134, 404, 'Voorschoten', NULL),
2240(2135, 405, 'Klarenbeek', NULL),
2241(2136, 405, 'Voorst Gemeente Voorst', NULL),
2242(2137, 405, 'Wilp (GLD)', NULL),
2243(2138, 405, 'Twello', NULL),
2244(2139, 405, 'Teuge', NULL),
2245(2140, 405, 'Terwolde', NULL),
2246(2141, 405, 'Nijbroek', NULL),
2247(2142, 405, 'Steenenkamer', NULL),
2248(2143, 406, 'Vught', NULL),
2249(2144, 406, 'Cromvoirt', NULL),
2250(2145, 407, 'Waalre', NULL),
2251(2146, 408, 'Waalwijk', NULL),
2252(2147, 408, 'Sprang Capelle', NULL),
2253(2148, 408, 'Waspik', NULL),
2254(2149, 409, 'Waddinxveen', NULL),
2255(2150, 410, 'Wageningen', NULL),
2256(2151, 411, 'Wassenaar', NULL),
2257(2152, 412, 'Monnickendam', NULL),
2258(2153, 412, 'Katwoude', NULL),
2259(2154, 412, 'Broek in Waterland', NULL),
2260(2155, 412, 'Zuiderwoude', NULL),
2261(2156, 412, 'Uitdam', NULL),
2262(2157, 412, 'Marken', NULL),
2263(2158, 412, 'Ilpendam', NULL),
2264(2159, 412, 'Watergang', NULL),
2265(2160, 412, 'Purmer', NULL),
2266(2161, 413, 'Weert', NULL),
2267(2162, 413, 'Stramproy', NULL),
2268(2163, 414, 'Weesp', NULL),
2269(2164, 415, 'Werkendam', NULL),
2270(2165, 415, 'Sleeuwijk', NULL),
2271(2166, 415, 'Nieuwendijk (NB)', NULL),
2272(2167, 415, 'Dussen', NULL),
2273(2168, 415, 'Hank', NULL),
2274(2169, 416, 'Zwaagdijk', NULL),
2275(2170, 416, 'Wervershoof', NULL),
2276(2171, 417, 'Dreumel', NULL),
2277(2172, 417, 'Alphen (GLD)', NULL),
2278(2173, 417, 'Maasbommel', NULL),
2279(2174, 417, 'Altforst', NULL),
2280(2175, 417, 'Appeltern', NULL),
2281(2176, 417, 'Boven Leeuwen', NULL),
2282(2177, 417, 'Beneden Leeuwen', NULL),
2283(2178, 417, 'Wamel', NULL),
2284(2179, 418, 'Oudendijk (NH)', NULL),
2285(2180, 418, 'Avenhorn', NULL),
2286(2181, 418, 'Scharwoude', NULL),
2287(2182, 418, 'Spierdijk', NULL),
2288(2183, 418, 'Ursem', NULL),
2289(2184, 418, 'Berkhout', NULL),
2290(2185, 418, 'De Goorn', NULL),
2291(2186, 418, 'Zuidermeer', NULL),
2292(2187, 419, 'Havelte', NULL),
2293(2188, 419, 'Darp', NULL),
2294(2189, 419, 'Havelterberg', NULL),
2295(2190, 419, 'Uffelte', NULL),
2296(2191, 419, 'Diever', NULL),
2297(2192, 419, 'Wapse', NULL),
2298(2193, 419, 'Dieverbrug', NULL),
2299(2194, 419, 'Geeuwenbrug', NULL),
2300(2195, 419, 'Wittelte', NULL),
2301(2196, 419, 'Dwingeloo', NULL),
2302(2197, 419, 'Wapserveen', NULL),
2303(2198, 419, 'Vledder', NULL),
2304(2199, 419, 'Frederiksoord', NULL),
2305(2200, 419, 'Nijensleek', NULL),
2306(2201, 419, 'Wilhelminaoord', NULL),
2307(2202, 419, 'Vledderveen (DR)', NULL),
2308(2203, 419, 'Doldersum', NULL),
2309(2204, 419, 'Boschoord', NULL),
2310(2205, 419, 'Zorgvlied', NULL),
2311(2206, 419, 'Wateren', NULL),
2312(2207, 419, 'Oude Willem', NULL),
2313(2208, 420, 'Westervoort', NULL),
2314(2209, 421, 'Wateringen', NULL),
2315(2210, 421, 'Kwintsheul', NULL),
2316(2211, 421, 'Naaldwijk', NULL),
2317(2212, 421, 'Honselersdijk', NULL),
2318(2213, 421, 'Maasdijk', NULL),
2319(2214, 421, 'De Lier', NULL),
2320(2215, 421, 'Monster', NULL),
2321(2216, 421, 'Ter Heijde', NULL),
2322(2217, 421, 'Poeldijk', NULL),
2323(2218, 421, 's Gravenzande', NULL),
2324(2219, 422, 'Oosterstreek', NULL),
2325(2220, 422, 'Zandhuizen', NULL),
2326(2221, 422, 'Noordwolde (FRL)', NULL),
2327(2222, 422, 'Boijl', NULL),
2328(2223, 422, 'Vinkega', NULL),
2329(2224, 422, 'De Hoeve', NULL),
2330(2225, 422, 'Steggerda', NULL),
2331(2226, 422, 'Peperga', NULL),
2332(2227, 422, 'De Blesse', NULL),
2333(2228, 422, 'Blesdijke', NULL),
2334(2229, 422, 'Wolvega', NULL),
2335(2230, 422, 'Oldeholtpade', NULL),
2336(2231, 422, 'Nijeholtpade', NULL),
2337(2232, 422, 'Ter Idzard', NULL),
2338(2233, 422, 'Oldeholtwolde', NULL),
2339(2234, 422, 'Sonnega', NULL),
2340(2235, 422, 'Oldetrijne', NULL),
2341(2236, 422, 'Nijetrijne', NULL),
2342(2237, 422, 'Spanga', NULL),
2343(2238, 422, 'Scherpenzeel (FRL)', NULL),
2344(2239, 422, 'Langelille', NULL),
2345(2240, 422, 'Munnekeburen', NULL),
2346(2241, 422, 'Oldelamer', NULL),
2347(2242, 422, 'Nijelamer', NULL),
2348(2243, 422, 'Nijeholtwolde', NULL),
2349(2244, 422, 'Slijkenburg', NULL),
2350(2245, 423, 'Oostvoorne', NULL),
2351(2246, 423, 'Tinte', NULL),
2352(2247, 423, 'Rockanje', NULL),
2353(2248, 424, 'Zuna', NULL),
2354(2249, 424, 'Notter', NULL),
2355(2250, 424, 'Enter', NULL),
2356(2251, 424, 'Wierden', NULL),
2357(2252, 424, 'Hoge Hexel', NULL),
2358(2253, 425, 'Hippolytushoef', NULL),
2359(2254, 425, 'Westerland', NULL),
2360(2255, 425, 'Den Oever', NULL),
2361(2256, 426, 'Wieringerwerf', NULL),
2362(2257, 426, 'Kreileroord', NULL),
2363(2258, 426, 'Slootdorp', NULL),
2364(2259, 426, 'Middenmeer', NULL),
2365(2260, 427, 'Wijchen', NULL),
2366(2261, 427, 'Niftrik', NULL),
2367(2262, 427, 'Balgoij', NULL),
2368(2263, 427, 'Leur', NULL),
2369(2264, 427, 'Hernen', NULL),
2370(2265, 427, 'Bergharen', NULL),
2371(2266, 427, 'Batenburg', NULL),
2372(2267, 428, 'Loosdrecht', NULL),
2373(2268, 428, 'Kortenhoef', NULL),
2374(2269, 428, 's Graveland', NULL),
2375(2270, 428, 'Ankeveen', NULL),
2376(2271, 428, 'Nederhorst den Berg', NULL),
2377(2272, 428, 'Breukeleveen', NULL),
2378(2273, 429, 'Cothen', NULL),
2379(2274, 429, 'Langbroek', NULL),
2380(2275, 429, 'Wijk bij Duurstede', NULL),
2381(2276, 430, 'Winschoten', NULL),
2382(2277, 431, 'Sauwerd', NULL),
2383(2278, 431, 'Wetsinge', NULL),
2384(2279, 431, 'Adorp', NULL),
2385(2280, 431, 'Ezinge', NULL),
2386(2281, 431, 'Feerwerd', NULL),
2387(2282, 431, 'Garnwerd', NULL),
2388(2283, 431, 'Winsum (GN)', NULL),
2389(2284, 431, 'Baflo', NULL),
2390(2285, 431, 'Tinallinge', NULL),
2391(2286, 431, 'Rasquert', NULL),
2392(2287, 431, 'Den Andel', NULL),
2393(2288, 431, 'Saaxumhuizen', NULL),
2394(2289, 432, 'Winterswijk', NULL),
2395(2290, 432, 'Winterswijk Meddo', NULL),
2396(2291, 432, 'Winterswijk Huppel', NULL),
2397(2292, 432, 'Winterswijk Ratum', NULL),
2398(2293, 432, 'Winterswijk Kotten', NULL),
2399(2294, 432, 'Winterswijk Woold', NULL),
2400(2295, 432, 'Winterswijk Miste', NULL),
2401(2296, 432, 'Winterswijk Henxel', NULL),
2402(2297, 432, 'Winterswijk Brinkh', NULL),
2403(2298, 432, 'Winterswijk Corle', NULL),
2404(2299, 433, 'Hoogerheide', NULL),
2405(2300, 433, 'Woensdrecht', NULL),
2406(2301, 433, 'Huijbergen', NULL),
2407(2302, 433, 'Ossendrecht', NULL),
2408(2303, 433, 'Putte', NULL),
2409(2304, 434, 'Woerden', NULL),
2410(2305, 434, 'Kamerik', NULL),
2411(2306, 434, 'Zegveld', NULL),
2412(2307, 434, 'Harmelen', NULL),
2413(2308, 435, 'Zwaagdijk', NULL),
2414(2309, 435, 'Wognum', NULL),
2415(2310, 435, 'Nibbixwoud', NULL),
2416(2311, 436, 'Wijdewormer', NULL),
2417(2312, 436, 'Spijkerboor (NH)', NULL),
2418(2313, 436, 'Wormer', NULL),
2419(2314, 436, 'Oostknollendam', NULL),
2420(2315, 436, 'Jisp', NULL),
2421(2316, 437, 'Woudenberg', NULL),
2422(2317, 438, 'Andel', NULL),
2423(2318, 438, 'Giessen', NULL),
2424(2319, 438, 'Rijswijk (NB)', NULL),
2425(2320, 438, 'Woudrichem', NULL),
2426(2321, 438, 'Almkerk', NULL),
2427(2322, 438, 'Waardhuizen', NULL),
2428(2323, 438, 'Uitwijk', NULL),
2429(2324, 439, 'Hartwerd', NULL),
2430(2325, 439, 'Burgwerd', NULL),
2431(2326, 439, 'Hichtum', NULL),
2432(2327, 439, 'Schettens', NULL),
2433(2328, 439, 'Longerhouw', NULL),
2434(2329, 439, 'Schraard', NULL),
2435(2330, 439, 'Wons', NULL),
2436(2331, 439, 'Witmarsum', NULL),
2437(2332, 439, 'Pingjum', NULL),
2438(2333, 439, 'Zurich', NULL),
2439(2334, 439, 'Kornwerderzand', NULL),
2440(2335, 439, 'Cornwerd', NULL),
2441(2336, 439, 'Makkum (FR)', NULL),
2442(2337, 439, 'Idsegahuizum', NULL),
2443(2338, 439, 'Piaam', NULL),
2444(2339, 439, 'Gaast', NULL),
2445(2340, 439, 'Allingawier', NULL),
2446(2341, 439, 'Exmorra', NULL),
2447(2342, 439, 'Ferwoude', NULL),
2448(2343, 439, 'Hieslum', NULL),
2449(2344, 439, 'Parrega', NULL),
2450(2345, 439, 'Dedgum', NULL),
2451(2346, 439, 'Tjerkwerd', NULL),
2452(2347, 439, 'Breezanddijk', NULL),
2453(2348, 439, 'Kimswerd', NULL),
2454(2349, 439, 'Arum', NULL),
2455(2350, 439, 'Lollum', NULL),
2456(2351, 440, 'Koufurderrige', NULL),
2457(2352, 440, 'Woudsend', NULL),
2458(2353, 440, 'Smallebrugge', NULL),
2459(2354, 440, 'Indijk', NULL),
2460(2355, 440, 'Ypecolsga', NULL),
2461(2356, 440, 'Gaastmeer', NULL),
2462(2357, 440, 'Idzega', NULL),
2463(2358, 440, 'Sandfirden', NULL),
2464(2359, 440, 'Oudega Gemeente Wymbritseradiel', NULL),
2465(2360, 440, 'Blauwhuis', NULL),
2466(2361, 440, 'Westhem', NULL),
2467(2362, 440, 'Abbega', NULL),
2468(2363, 440, 'Oosthem', NULL),
2469(2364, 440, 'Heeg', NULL),
2470(2365, 440, 'Hommerts', NULL),
2471(2366, 440, 'Jutrijp', NULL),
2472(2367, 440, 'Uitwellingerga', NULL),
2473(2368, 440, 'Oppenhuizen', NULL),
2474(2369, 440, 'Gauw', NULL),
2475(2370, 440, 'Goenga', NULL),
2476(2371, 440, 'Scharnegoutum', NULL),
2477(2372, 440, 'Tirns', NULL),
2478(2373, 440, 'IJlst', NULL),
2479(2374, 440, 'Greonterp', NULL),
2480(2375, 440, 'Nijland', NULL),
2481(2376, 440, 'Tjalhuizum', NULL),
2482(2377, 440, 'Folsgare', NULL),
2483(2378, 440, 'Wolsum', NULL),
2484(2379, 441, 'Zaandam', NULL),
2485(2380, 441, 'Wormerveer', NULL),
2486(2381, 441, 'Westknollendam', NULL),
2487(2382, 441, 'Koog aan de Zaan', NULL),
2488(2383, 441, 'Zaandijk', NULL),
2489(2384, 441, 'Westzaan', NULL),
2490(2385, 441, 'Krommenie', NULL),
2491(2386, 441, 'Assendelft', NULL),
2492(2387, 442, 'Zaltbommel', NULL),
2493(2388, 442, 'Zuilichem', NULL),
2494(2389, 442, 'Brakel', NULL),
2495(2390, 442, 'Poederoijen', NULL),
2496(2391, 442, 'Aalst (GLD)', NULL),
2497(2392, 442, 'Gameren', NULL),
2498(2393, 442, 'Nieuwaal', NULL),
2499(2394, 442, 'Bruchem', NULL),
2500(2395, 442, 'Kerkwijk', NULL),
2501(2396, 442, 'Delwijnen', NULL),
2502(2397, 442, 'Nederhemert', NULL),
2503(2398, 442, 'Bern', NULL),
2504(2399, 443, 'Zandvoort', NULL),
2505(2400, 443, 'Bentveld', NULL),
2506(2401, 444, 'Hei en Boeicop', NULL),
2507(2402, 444, 'Lexmond', NULL),
2508(2403, 444, 'Meerkerk', NULL),
2509(2404, 444, 'Ameide', NULL),
2510(2405, 444, 'Tienhoven (ZH)', NULL),
2511(2406, 444, 'Nieuwland', NULL),
2512(2407, 444, 'Leerbroek', NULL),
2513(2408, 445, 'Kwadijk', NULL),
2514(2409, 445, 'Middelie', NULL),
2515(2410, 445, 'Warder', NULL),
2516(2411, 445, 'Oosthuizen', NULL),
2517(2412, 445, 'Beets (NH)', NULL),
2518(2413, 445, 'Schardam', NULL),
2519(2414, 445, 'Hobrede', NULL),
2520(2415, 446, 'Zeewolde', NULL),
2521(2416, 447, 'Zeist', NULL),
2522(2417, 447, 'Austerlitz', NULL),
2523(2418, 447, 'Huis Ter Heide (UT)', NULL),
2524(2419, 447, 'Den Dolder', NULL),
2525(2420, 447, 'Bosch en Duin', NULL),
2526(2421, 448, 'Zevenaar', NULL),
2527(2422, 448, 'Babberich', NULL),
2528(2423, 448, 'Angerlo', NULL),
2529(2424, 448, 'Giesbeek', NULL),
2530(2425, 448, 'Lathum', NULL),
2531(2426, 449, 'Moerkapelle', NULL),
2532(2427, 449, 'Zevenhuizen (ZH)', NULL),
2533(2428, 450, 'Schagerbrug', NULL),
2534(2429, 450, 'Sint Maartensbrug', NULL),
2535(2430, 450, 'Sint Maartensvlotbrug', NULL),
2536(2431, 450, 'Burgerbrug', NULL),
2537(2432, 450, 'Petten', NULL),
2538(2433, 450, 't Zand (NH)', NULL),
2539(2434, 450, 'Oudesluis', NULL),
2540(2435, 450, 'Callantsoog', NULL),
2541(2436, 451, 'Zoetermeer', NULL),
2542(2437, 452, 'Zoeterwoude', NULL),
2543(2438, 452, 'Gelderswoude', NULL),
2544(2439, 453, 'Zuidhorn', NULL),
2545(2440, 453, 'Noordhorn', NULL),
2546(2441, 453, 'Briltil', NULL),
2547(2442, 453, 'Aduard', NULL),
2548(2443, 453, 'Den Horn', NULL),
2549(2444, 453, 'Den Ham (GN)', NULL),
2550(2445, 453, 'Niezijl', NULL),
2551(2446, 453, 'Grijpskerk', NULL),
2552(2447, 453, 'Pieterzijl', NULL),
2553(2448, 453, 'Visvliet', NULL),
2554(2449, 453, 'Kommerzijl', NULL),
2555(2450, 453, 'Oldehove', NULL),
2556(2451, 453, 'Niehove', NULL),
2557(2452, 453, 'Lauwerzijl', NULL),
2558(2453, 453, 'Saaksum', NULL),
2559(2454, 454, 'Zundert', NULL),
2560(2455, 454, 'Wernhout', NULL),
2561(2456, 454, 'Achtmaal', NULL),
2562(2457, 454, 'Rijsbergen', NULL),
2563(2458, 455, 'Zutphen', NULL),
2564(2459, 455, 'Warnsveld', NULL),
2565(2460, 456, 'Hasselt', NULL),
2566(2461, 456, 'Zwartsluis', NULL),
2567(2462, 456, 'Genemuiden', NULL),
2568(2463, 456, 'Mastenbroek', NULL),
2569(2464, 457, 'Heerjansdam', NULL),
2570(2465, 457, 'Zwijndrecht', NULL),
2571(2466, 458, 'Zwolle', NULL);
2572
2573-- --------------------------------------------------------
2574
2575--
2576-- Table structure for table `education`
2577--
2578
2579DROP TABLE IF EXISTS `education`;
2580CREATE TABLE `education` (
2581  `id` int(10) unsigned NOT NULL,
2582  `key` varchar(25) NOT NULL,
2583  `value` varchar(255) NOT NULL,
2584  `order` int(11) DEFAULT '0'
2585) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
2586
2587--
2588-- Dumping data for table `education`
2589--
2590
2591INSERT INTO `education` (`id`, `key`, `value`, `order`) VALUES
2592(1, 'mavo', 'MAVO/VMBO', 0),
2593(2, 'havo', 'HAVO', 0),
2594(3, 'vwo', 'VWO', 0),
2595(4, 'mbo', 'MBO', 0),
2596(5, 'hbo', 'HBO', 0),
2597(6, 'wo', 'WO', 0);
2598
2599-- --------------------------------------------------------
2600
2601--
2602-- Table structure for table `faq`
2603--
2604
2605DROP TABLE IF EXISTS `faq`;
2606CREATE TABLE `faq` (
2607  `id` int(11) NOT NULL,
2608  `questionId` int(11) NOT NULL,
2609  `category` int(11) NOT NULL DEFAULT '0'
2610) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
2611
2612--
2613-- Dumping data for table `faq`
2614--
2615
2616INSERT INTO `faq` (`id`, `questionId`, `category`) VALUES
2617(1, 1, 3);
2618
2619-- --------------------------------------------------------
2620
2621--
2622-- Table structure for table `favorite`
2623--
2624
2625DROP TABLE IF EXISTS `favorite`;
2626CREATE TABLE `favorite` (
2627  `id` int(11) NOT NULL,
2628  `userId` int(10) unsigned NOT NULL,
2629  `questionId` int(11) NOT NULL,
2630  `dateCreated` datetime DEFAULT NULL
2631) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
2632
2633--
2634-- Dumping data for table `favorite`
2635--
2636
2637INSERT INTO `favorite` (`id`, `userId`, `questionId`, `dateCreated`) VALUES
2638(1, 1, 1, '2016-11-02 00:00:00'),
2639(2, 1, 1, '2016-11-16 00:00:00');
2640
2641-- --------------------------------------------------------
2642
2643--
2644-- Table structure for table `income`
2645--
2646
2647DROP TABLE IF EXISTS `income`;
2648CREATE TABLE `income` (
2649  `id` int(10) unsigned NOT NULL,
2650  `key` varchar(25) NOT NULL,
2651  `value` varchar(255) NOT NULL,
2652  `order` int(11) DEFAULT '0'
2653) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
2654
2655--
2656-- Dumping data for table `income`
2657--
2658
2659INSERT INTO `income` (`id`, `key`, `value`, `order`) VALUES
2660(1, '1500-', 'Minder dan €1500', 0),
2661(2, '1500-2000', '€1500 - €2000', 0),
2662(3, '2000-2500', '€2000 - €2500', 0),
2663(4, '2500-3000', '€2500 - €3000', 0),
2664(5, '3000-3500', '€3000 - €3500', 0),
2665(6, '3500-4000', '€3500 - €4000', 0),
2666(7, '4000-4500', '€4000 - €4500', 0),
2667(8, '4500+', 'Meer dan €4500', 0);
2668
2669-- --------------------------------------------------------
2670
2671--
2672-- Table structure for table `interest`
2673--
2674
2675DROP TABLE IF EXISTS `interest`;
2676CREATE TABLE `interest` (
2677  `id` int(10) unsigned NOT NULL,
2678  `userId` int(11) NOT NULL,
2679  `tagValueId` int(11) NOT NULL,
2680  `points` int(11) NOT NULL,
2681  `hidden` tinyint(1) NOT NULL DEFAULT '1'
2682) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
2683
2684--
2685-- Dumping data for table `interest`
2686--
2687
2688INSERT INTO `interest` (`id`, `userId`, `tagValueId`, `points`, `hidden`) VALUES
2689(1, 1, 12, 0, 1),
2690(2, 1, 4, 14, 1),
2691(3, 1, 17, 0, 1),
2692(4, 1, 21, 0, 1);
2693
2694-- --------------------------------------------------------
2695
2696--
2697-- Table structure for table `maritalStatus`
2698--
2699
2700DROP TABLE IF EXISTS `maritalStatus`;
2701CREATE TABLE `maritalStatus` (
2702  `id` int(10) unsigned NOT NULL,
2703  `key` varchar(25) NOT NULL,
2704  `value` varchar(255) NOT NULL,
2705  `order` int(11) DEFAULT '0'
2706) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
2707
2708--
2709-- Dumping data for table `maritalStatus`
2710--
2711
2712INSERT INTO `maritalStatus` (`id`, `key`, `value`, `order`) VALUES
2713(1, 'ongehuwd', 'Ongehuwd', 0),
2714(2, 'gehuwd', 'Wettig gehuwd', 0),
2715(3, 'partnerschap', 'Partnerschap', 0),
2716(4, 'verweduwdhuwelijk', 'Verweduwd na wettig huwelijk', 0),
2717(5, 'verweduwdpartnerschap', 'Verweduwd na partnerschap', 0),
2718(6, 'gescheidenhuwelijk', 'Gescheiden na wettig huwelijk', 0),
2719(7, 'gescheidenpartnerschap', 'Gescheiden na partnerschap', 0);
2720
2721-- --------------------------------------------------------
2722
2723--
2724-- Table structure for table `mediumType`
2725--
2726
2727DROP TABLE IF EXISTS `mediumType`;
2728CREATE TABLE `mediumType` (
2729  `id` int(10) unsigned NOT NULL,
2730  `key` varchar(25) NOT NULL,
2731  `value` varchar(255) NOT NULL
2732) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
2733
2734--
2735-- Dumping data for table `mediumType`
2736--
2737
2738INSERT INTO `mediumType` (`id`, `key`, `value`) VALUES
2739(1, 'link', 'link'),
2740(2, 'video', 'video'),
2741(3, 'pdf', 'pdf'),
2742(4, '`img`', 'afbeelding');
2743
2744-- --------------------------------------------------------
2745
2746--
2747-- Table structure for table `milestone`
2748--
2749
2750DROP TABLE IF EXISTS `milestone`;
2751CREATE TABLE `milestone` (
2752  `id` int(10) unsigned NOT NULL,
2753  `milestoneTypeId` int(11) DEFAULT NULL,
2754  `userId` int(10) unsigned NOT NULL,
2755  `total` int(11) DEFAULT NULL,
2756  `hidden` tinyint(1) DEFAULT '0',
2757  `dateFirst` datetime DEFAULT NULL,
2758  `dateLast` datetime DEFAULT NULL
2759) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
2760
2761--
2762-- Dumping data for table `milestone`
2763--
2764
2765INSERT INTO `milestone` (`id`, `milestoneTypeId`, `userId`, `total`, `hidden`, `dateFirst`, `dateLast`) VALUES
2766(1, 3, 1, 12, 0, '2016-11-09 00:00:00', '2016-11-03 00:00:00'),
2767(2, 12, 1, 2, 0, '2016-11-08 00:00:00', '2016-11-03 00:00:00');
2768
2769-- --------------------------------------------------------
2770
2771--
2772-- Table structure for table `milestoneType`
2773--
2774
2775DROP TABLE IF EXISTS `milestoneType`;
2776CREATE TABLE `milestoneType` (
2777  `id` int(10) unsigned NOT NULL,
2778  `key` varchar(25) NOT NULL,
2779  `value` varchar(255) NOT NULL,
2780  `reward` int(11) DEFAULT '0',
2781  `hidden` tinyint(1) DEFAULT '0'
2782) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8;
2783
2784--
2785-- Dumping data for table `milestoneType`
2786--
2787
2788INSERT INTO `milestoneType` (`id`, `key`, `value`, `reward`, `hidden`) VALUES
2789(1, 'profile', 'Profiel volledig ingevuld', 10, 0),
2790(2, '5shares', '5x Een pagina gedeeld', 25, 0),
2791(3, '10shares', '10x Een pagina gedeeld', 50, 0),
2792(4, '25shares', '25x Een pagina gedeeld', 100, 0),
2793(5, '3invites', '5 Vrienden uitgenodigd', 25, 0),
2794(6, '10invites', '10 Vrienden uitgenodigd', 50, 0),
2795(7, '25invites', '25 Vrienden uitgenodigd', 100, 0),
2796(8, '5answers', '5 Antwoorden gegeven', 10, 0),
2797(9, '10answers', '10 Antwoorden gegeven', 25, 0),
2798(10, '25answers', '25 Antwoorden gegeven', 50, 0),
2799(11, '50answers', '50 Antwoorden gegeven', 75, 0),
2800(12, '100answers', '100 Antwoorden gegeven', 100, 0),
2801(13, '250answers', '250 Antwoorden gegeven', 250, 0),
2802(14, '5questions', '5 Vragen gesteld', 10, 0),
2803(15, '10questions', '10 Vragen gesteld', 25, 0),
2804(16, '25questions', '25 Vragen gesteld', 50, 0),
2805(17, '50questions', '50 Vragen gesteld', 75, 0),
2806(18, '100questions', '100 Vragen gesteld', 100, 0),
2807(19, '250questions', '250 Vragen gesteld', 250, 0),
2808(20, '10reactions', '10 Reacties geplaatst', 10, 0),
2809(21, '50reactions', '50 Reacties geplaatst', 25, 0),
2810(22, '100reactions', '100 Reacties geplaatst', 50, 0),
2811(23, '5received', 'Gefeliciteerd! U bent 5x gevraagd om een vraag te beantwoorden.', 10, 1),
2812(24, '25received', 'Gefeliciteerd! U bent 25x gevraagd om een vraag te beantwoorden.', 25, 1),
2813(25, '50received', 'Gefeliciteerd! U bent 50x gevraagd om een vraag te beantwoorden.', 50, 1),
2814(26, '500gift', 'Gefeliciteerd! U heeft een bronzen bagde verdient.', 0, 1),
2815(27, '1000gift', 'Gefeliciteerd! U heeft een zilveren bagde verdient.', 0, 1),
2816(28, '5000gift', 'Gefeliciteerd! U heeft een gouden bagde verdient.', 0, 1);
2817
2818-- --------------------------------------------------------
2819
2820--
2821-- Table structure for table `municipality`
2822--
2823
2824DROP TABLE IF EXISTS `municipality`;
2825CREATE TABLE `municipality` (
2826  `id` int(10) unsigned NOT NULL,
2827  `provinceId` int(10) unsigned NOT NULL,
2828  `name` varchar(255) NOT NULL,
2829  `img` varchar(255) DEFAULT NULL,
2830  `pageId` int(11) DEFAULT NULL
2831) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2832
2833--
2834-- Dumping data for table `municipality`
2835--
2836
2837INSERT INTO `municipality` (`id`, `provinceId`, `name`, `img`, `pageId`) VALUES
2838(1, 1, 'Aa en Hunze', NULL, NULL),
2839(2, 2, 'Aalburg', NULL, NULL),
2840(3, 8, 'Aalsmeer', NULL, NULL),
2841(4, 3, 'Aalten', NULL, NULL),
2842(5, 4, 'Abcoude', NULL, NULL),
2843(6, 5, 'Achtkarspelen', NULL, NULL),
2844(7, 6, 'Alblasserdam', NULL, NULL),
2845(8, 6, 'Albrandswaard', NULL, NULL),
2846(9, 6, 'Alkemade', NULL, NULL),
2847(10, 8, 'Alkmaar', NULL, NULL),
2848(11, 11, 'Almelo', NULL, NULL),
2849(12, 12, 'Almere', NULL, NULL),
2850(13, 6, 'Alphen Aan Den Rijn', NULL, NULL),
2851(14, 2, 'Alphen Chaam', NULL, NULL),
2852(15, 7, 'Ambt Montfort', NULL, NULL),
2853(16, 5, 'Ameland', NULL, NULL),
2854(17, 4, 'Amersfoort', NULL, NULL),
2855(18, 8, 'Amstelveen', NULL, NULL),
2856(19, 8, 'Amsterdam', NULL, NULL),
2857(20, 8, 'Andijk', NULL, NULL),
2858(21, 8, 'Anna Paulowna', NULL, NULL),
2859(22, 3, 'Apeldoorn', NULL, NULL),
2860(23, 9, 'Appingedam', NULL, NULL),
2861(24, 7, 'Arcen en Velden', NULL, NULL),
2862(25, 3, 'Arnhem', NULL, NULL),
2863(26, 1, 'Assen', NULL, NULL),
2864(27, 2, 'Asten', NULL, NULL),
2865(28, 2, 'Baarle Nassau', NULL, NULL),
2866(29, 4, 'Baarn', NULL, NULL),
2867(30, 6, 'Barendrecht', NULL, NULL),
2868(31, 3, 'Barneveld', NULL, NULL),
2869(32, 9, 'Bedum', NULL, NULL),
2870(33, 7, 'Beek', NULL, NULL),
2871(34, 8, 'Beemster', NULL, NULL),
2872(35, 7, 'Beesel', NULL, NULL),
2873(36, 9, 'Bellingwedde', NULL, NULL),
2874(37, 8, 'Bennebroek', NULL, NULL),
2875(38, 6, 'Bergambacht', NULL, NULL),
2876(39, 2, 'Bergeijk', NULL, NULL),
2877(40, 7, 'Bergen (LB)', NULL, NULL),
2878(41, 8, 'Bergen (NH)', NULL, NULL),
2879(42, 2, 'Bergen op Zoom', NULL, NULL),
2880(43, 6, 'Bergschenhoek', NULL, NULL),
2881(44, 6, 'Berkel en Rodenrijs', NULL, NULL),
2882(45, 3, 'Berkelland', NULL, NULL),
2883(46, 2, 'Bernheze', NULL, NULL),
2884(47, 6, 'Bernisse', NULL, NULL),
2885(48, 2, 'Best', NULL, NULL),
2886(49, 3, 'Beuningen', NULL, NULL),
2887(50, 8, 'Beverwijk', NULL, NULL),
2888(51, 6, 'Binnenmaas', NULL, NULL),
2889(52, 2, 'Bladel', NULL, NULL),
2890(53, 8, 'Blaricum', NULL, NULL),
2891(54, 6, 'Bleiswijk', NULL, NULL),
2892(55, 8, 'Bloemendaal', NULL, NULL),
2893(56, 5, 'Boarnsterhim', NULL, NULL),
2894(57, 6, 'Bodegraven', NULL, NULL),
2895(58, 2, 'Boekel', NULL, NULL),
2896(59, 5, 'Bolsward', NULL, NULL),
2897(60, 1, 'Borger Odoorn', NULL, NULL),
2898(61, 11, 'Borne', NULL, NULL),
2899(62, 10, 'Borsele', NULL, NULL),
2900(63, 6, 'Boskoop', NULL, NULL),
2901(64, 2, 'Boxmeer', NULL, NULL),
2902(65, 2, 'Boxtel', NULL, NULL),
2903(66, 2, 'Breda', NULL, NULL),
2904(67, 4, 'Breukelen', NULL, NULL),
2905(68, 6, 'Brielle', NULL, NULL),
2906(69, 3, 'Bronckhorst', NULL, NULL),
2907(70, 3, 'Brummen', NULL, NULL),
2908(71, 7, 'Brunssum', NULL, NULL),
2909(72, 4, 'Bunnik', NULL, NULL),
2910(73, 4, 'Bunschoten', NULL, NULL),
2911(74, 3, 'Buren', NULL, NULL),
2912(75, 8, 'Bussum', NULL, NULL),
2913(76, 6, 'Capelle aan den IJssel', NULL, NULL),
2914(77, 8, 'Castricum', NULL, NULL),
2915(78, 1, 'Coevorden', NULL, NULL),
2916(79, 2, 'Cranendonck', NULL, NULL),
2917(80, 6, 'Cromstrijen', NULL, NULL),
2918(81, 2, 'Cuijk', NULL, NULL),
2919(82, 3, 'Culemborg', NULL, NULL),
2920(83, 11, 'Dalfsen', NULL, NULL),
2921(84, 5, 'Dantumadeel', NULL, NULL),
2922(85, 4, 'De Bilt', NULL, NULL),
2923(86, 9, 'De Marne', NULL, NULL),
2924(87, 4, 'De Ronde Venen', NULL, NULL),
2925(88, 1, 'De Wolden', NULL, NULL),
2926(89, 6, 'Delft', NULL, NULL),
2927(90, 9, 'Delfzijl', NULL, NULL),
2928(91, 8, 'Den Helder', NULL, NULL),
2929(92, 2, 'Deurne', NULL, NULL),
2930(93, 11, 'Deventer', NULL, NULL),
2931(94, 8, 'Diemen', NULL, NULL),
2932(95, 11, 'Dinkelland', NULL, NULL),
2933(96, 6, 'Dirksland', NULL, NULL),
2934(97, 3, 'Doesburg', NULL, NULL),
2935(98, 3, 'Doetinchem', NULL, NULL),
2936(99, 2, 'Dongen', NULL, NULL),
2937(100, 5, 'Dongeradeel', NULL, NULL),
2938(101, 6, 'Dordrecht', NULL, NULL),
2939(102, 8, 'Drechterland', NULL, NULL),
2940(103, 2, 'Drimmelen', NULL, NULL),
2941(104, 12, 'Dronten', NULL, NULL),
2942(105, 3, 'Druten', NULL, NULL),
2943(106, 3, 'Duiven', NULL, NULL),
2944(107, 7, 'Echt Susteren', NULL, NULL),
2945(108, 8, 'Edam Volendam', NULL, NULL),
2946(109, 3, 'Ede', NULL, NULL),
2947(110, 4, 'Eemnes', NULL, NULL),
2948(111, 9, 'Eemsmond', NULL, NULL),
2949(112, 2, 'Eersel', NULL, NULL),
2950(113, 7, 'Eijsden', NULL, NULL),
2951(114, 2, 'Eindhoven', NULL, NULL),
2952(115, 3, 'Elburg', NULL, NULL),
2953(116, 1, 'Emmen', NULL, NULL),
2954(117, 8, 'Enkhuizen', NULL, NULL),
2955(118, 11, 'Enschede', NULL, NULL),
2956(119, 3, 'Epe', NULL, NULL),
2957(120, 3, 'Ermelo', NULL, NULL),
2958(121, 2, 'Etten Leur', NULL, NULL),
2959(122, 5, 'Ferwerderadiel', NULL, NULL),
2960(123, 5, 'Franekeradeel', NULL, NULL),
2961(124, 5, 'Gaasterlan Sleat', NULL, NULL),
2962(125, 2, 'Geertruidenberg', NULL, NULL),
2963(126, 3, 'Geldermalsen', NULL, NULL),
2964(127, 2, 'Geldrop Mierlo', NULL, NULL),
2965(128, 2, 'Gemert Bakel', NULL, NULL),
2966(129, 7, 'Gennep', NULL, NULL),
2967(130, 6, 'Giessenlanden', NULL, NULL),
2968(131, 2, 'Gilze en Rijen', NULL, NULL),
2969(132, 6, 'Goedereede', NULL, NULL),
2970(133, 10, 'Goes', NULL, NULL),
2971(134, 2, 'Goirle', NULL, NULL),
2972(135, 6, 'Gorinchem', NULL, NULL),
2973(136, 6, 'Gouda', NULL, NULL),
2974(137, 6, 'Graafstroom', NULL, NULL),
2975(138, 8, 'Graft De Rijp', NULL, NULL),
2976(139, 2, 'Grave', NULL, NULL),
2977(140, 3, 'Groenlo', NULL, NULL),
2978(141, 3, 'Groesbeek', NULL, NULL),
2979(142, 9, 'Groningen', NULL, NULL),
2980(143, 9, 'Grootegast', NULL, NULL),
2981(144, 7, 'Gulpen Wittem', NULL, NULL),
2982(145, 11, 'Haaksbergen', NULL, NULL),
2983(146, 2, 'Haaren', NULL, NULL),
2984(147, 8, 'Haarlem', NULL, NULL),
2985(148, 8, 'Haarlemmerliede en Spaarnwoude', NULL, NULL),
2986(149, 8, 'Haarlemmermeer', NULL, NULL),
2987(150, 7, 'Haelen', NULL, NULL),
2988(151, 2, 'Halderberge', NULL, NULL),
2989(152, 11, 'Hardenberg', NULL, NULL),
2990(153, 3, 'Harderwijk', NULL, NULL),
2991(154, 6, 'Hardinxveld Giessendam', NULL, NULL),
2992(155, 9, 'Haren', NULL, NULL),
2993(156, 8, 'Harenkarpsel', NULL, NULL),
2994(157, 5, 'Harlingen', NULL, NULL),
2995(158, 3, 'Hattem', NULL, NULL),
2996(159, 7, 'Heel', NULL, NULL),
2997(160, 8, 'Heemskerk', NULL, NULL),
2998(161, 8, 'Heemstede', NULL, NULL),
2999(162, 3, 'Heerde', NULL, NULL),
3000(163, 5, 'Heerenveen', NULL, NULL),
3001(164, 8, 'Heerhugowaard', NULL, NULL),
3002(165, 7, 'Heerlen', NULL, NULL),
3003(166, 2, 'Heeze Leende', NULL, NULL),
3004(167, 8, 'Heiloo', NULL, NULL),
3005(168, 7, 'Helden', NULL, NULL),
3006(169, 11, 'Hellendoorn', NULL, NULL),
3007(170, 6, 'Hellevoetsluis', NULL, NULL),
3008(171, 2, 'Helmond', NULL, NULL),
3009(172, 6, 'Hendrik Ido Ambacht', NULL, NULL),
3010(173, 11, 'Hengelo (OV)', NULL, NULL),
3011(174, 5, 'Het Bildt', NULL, NULL),
3012(175, 3, 'Heumen', NULL, NULL),
3013(176, 2, 'Heusden', NULL, NULL),
3014(177, 7, 'Heythuysen', NULL, NULL),
3015(178, 6, 'Hillegom', NULL, NULL),
3016(179, 2, 'Hilvarenbeek', NULL, NULL),
3017(180, 8, 'Hilversum', NULL, NULL),
3018(181, 11, 'Hof Van Twente', NULL, NULL),
3019(182, 1, 'Hoogeveen', NULL, NULL),
3020(183, 9, 'Hoogezand Sappemeer', NULL, NULL),
3021(184, 8, 'Hoorn', NULL, NULL),
3022(185, 7, 'Horst aan de Maas', NULL, NULL),
3023(186, 4, 'Houten', NULL, NULL),
3024(187, 8, 'Huizen', NULL, NULL),
3025(188, 10, 'Hulst', NULL, NULL),
3026(189, 7, 'Hunsel', NULL, NULL),
3027(190, 4, 'IJsselstein', NULL, NULL),
3028(191, 6, 'Jacobswoude', NULL, NULL),
3029(192, 11, 'Kampen', NULL, NULL),
3030(193, 10, 'Kapelle', NULL, NULL),
3031(194, 6, 'Katwijk', NULL, NULL),
3032(195, 7, 'Kerkrade', NULL, NULL),
3033(196, 7, 'Kessel', NULL, NULL),
3034(197, 5, 'Kollumerland en Nieuwkruisland', NULL, NULL),
3035(198, 6, 'Korendijk', NULL, NULL),
3036(199, 6, 'Krimpen aan den IJssel', NULL, NULL),
3037(200, 2, 'Laarbeek', NULL, NULL),
3038(201, 2, 'Landerd', NULL, NULL),
3039(202, 7, 'Landgraaf', NULL, NULL),
3040(203, 8, 'Landsmeer', NULL, NULL),
3041(204, 8, 'Langedijk', NULL, NULL),
3042(205, 8, 'Laren', NULL, NULL),
3043(206, 9, 'Leek', NULL, NULL),
3044(207, 6, 'Leerdam', NULL, NULL),
3045(208, 5, 'Leeuwarden', NULL, NULL),
3046(209, 5, 'Leeuwarderadeel', NULL, NULL),
3047(210, 6, 'Leiden', NULL, NULL),
3048(211, 6, 'Leiderdorp', NULL, NULL),
3049(212, 6, 'Leidschendam Voorburg', NULL, NULL),
3050(213, 12, 'Lelystad', NULL, NULL),
3051(214, 5, 'Lemsterland', NULL, NULL),
3052(215, 4, 'Leusden', NULL, NULL),
3053(216, 6, 'Liemeer', NULL, NULL),
3054(217, 6, 'Liesveld', NULL, NULL),
3055(218, 3, 'Lingewaal', NULL, NULL),
3056(219, 3, 'Lingewaard', NULL, NULL),
3057(220, 6, 'Lisse', NULL, NULL),
3058(221, 2, 'Lith', NULL, NULL),
3059(222, 5, 'Littenseradiel', NULL, NULL),
3060(223, 3, 'Lochem', NULL, NULL),
3061(224, 4, 'Loenen', NULL, NULL),
3062(225, 2, 'Loon Op Zand', NULL, NULL),
3063(226, 4, 'Lopik', NULL, NULL),
3064(227, 9, 'Loppersum', NULL, NULL),
3065(228, 11, 'Losser', NULL, NULL),
3066(229, 4, 'Maarssen', NULL, NULL),
3067(230, 7, 'Maasbracht', NULL, NULL),
3068(231, 7, 'Maasbree', NULL, NULL),
3069(232, 2, 'Maasdonk', NULL, NULL),
3070(233, 3, 'Maasdriel', NULL, NULL),
3071(234, 6, 'Maassluis', NULL, NULL),
3072(235, 7, 'Maastricht', NULL, NULL),
3073(236, 7, 'Margraten', NULL, NULL),
3074(237, 9, 'Marum', NULL, NULL),
3075(238, 8, 'Medemblik', NULL, NULL),
3076(239, 7, 'Meerlo Wanssum', NULL, NULL),
3077(240, 7, 'Meerssen', NULL, NULL),
3078(241, 7, 'Meijel', NULL, NULL),
3079(242, 5, 'Menaldumadeel', NULL, NULL),
3080(243, 9, 'Menterwolde', NULL, NULL),
3081(244, 1, 'Meppel', NULL, NULL),
3082(245, 10, 'Middelburg', NULL, NULL),
3083(246, 6, 'Middelharnis', NULL, NULL),
3084(247, 6, 'Midden Delfland', NULL, NULL),
3085(248, 1, 'Midden Drenthe', NULL, NULL),
3086(249, 2, 'Mill en Sint Hubert', NULL, NULL),
3087(250, 3, 'Millingen aan de Rijn', NULL, NULL),
3088(251, 2, 'Moerdijk', NULL, NULL),
3089(252, 3, 'Montferland', NULL, NULL),
3090(253, 4, 'Montfoort', NULL, NULL),
3091(254, 7, 'Mook en Middelaar', NULL, NULL),
3092(255, 6, 'Moordrecht', NULL, NULL),
3093(256, 8, 'Muiden', NULL, NULL),
3094(257, 8, 'Naarden', NULL, NULL),
3095(258, 3, 'Neder Betuwe', NULL, NULL),
3096(259, 6, 'Nederlek', NULL, NULL),
3097(260, 7, 'Nederweert', NULL, NULL),
3098(261, 3, 'Neerijnen', NULL, NULL),
3099(262, 8, 'Niedorp', NULL, NULL),
3100(263, 6, 'Nieuw Lekkerland', NULL, NULL),
3101(264, 4, 'Nieuwegein', NULL, NULL),
3102(265, 6, 'Nieuwerkerk aan den IJssel', NULL, NULL),
3103(266, 6, 'Nieuwkoop', NULL, NULL),
3104(267, 5, 'Nijefurd', NULL, NULL),
3105(268, 3, 'Nijkerk', NULL, NULL),
3106(269, 3, 'Nijmegen', NULL, NULL),
3107(270, 10, 'Noord Beveland', NULL, NULL),
3108(271, 1, 'Noordenveld', NULL, NULL),
3109(272, 8, 'Noorder Koggenland', NULL, NULL),
3110(273, 12, 'Noordoostpolder', NULL, NULL),
3111(274, 6, 'Noordwijk', NULL, NULL),
3112(275, 6, 'Noordwijkerhout', NULL, NULL),
3113(276, 2, 'Nuenen', NULL, NULL),
3114(277, 3, 'Nunspeet', NULL, NULL),
3115(278, 7, 'Nuth', NULL, NULL),
3116(279, 8, 'Obdam', NULL, NULL),
3117(280, 6, 'Oegstgeest', NULL, NULL),
3118(281, 2, 'Oirschot', NULL, NULL),
3119(282, 2, 'Oisterwijk', NULL, NULL),
3120(283, 3, 'Oldebroek', NULL, NULL),
3121(284, 11, 'Oldenzaal', NULL, NULL),
3122(285, 11, 'Olst Wijhe', NULL, NULL),
3123(286, 11, 'Ommen', NULL, NULL),
3124(287, 7, 'Onderbanken', NULL, NULL),
3125(288, 2, 'Oosterhout', NULL, NULL),
3126(289, 6, 'Oostflakkee', NULL, NULL),
3127(290, 5, 'Ooststellingwerf', NULL, NULL),
3128(291, 8, 'Oostzaan', NULL, NULL),
3129(292, 8, 'Opmeer', NULL, NULL),
3130(293, 5, 'Opsterland', NULL, NULL),
3131(294, 2, 'Oss', NULL, NULL),
3132(295, 6, 'Oud Beijerland', NULL, NULL),
3133(296, 3, 'Oude IJsselstreek', NULL, NULL),
3134(297, 8, 'Ouder Amstel', NULL, NULL),
3135(298, 6, 'Ouderkerk', NULL, NULL),
3136(299, 4, 'Oudewater', NULL, NULL),
3137(300, 3, 'Overbetuwe', NULL, NULL),
3138(301, 6, 'Papendrecht', NULL, NULL),
3139(302, 9, 'Pekela', NULL, NULL),
3140(303, 6, 'Pijnacker Nootdorp', NULL, NULL),
3141(304, 8, 'Purmerend', NULL, NULL),
3142(305, 3, 'Putten', NULL, NULL),
3143(306, 11, 'Raalte', NULL, NULL),
3144(307, 6, 'Reeuwijk', NULL, NULL),
3145(308, 9, 'Reiderland', NULL, NULL),
3146(309, 10, 'Reimerswaal', NULL, NULL),
3147(310, 3, 'Renkum', NULL, NULL),
3148(311, 4, 'Renswoude', NULL, NULL),
3149(312, 2, 'Reusel de Mierden', NULL, NULL),
3150(313, 3, 'Rheden', NULL, NULL),
3151(314, 4, 'Rhenen', NULL, NULL),
3152(315, 6, 'Ridderkerk', NULL, NULL),
3153(316, 3, 'Rijnwaarden', NULL, NULL),
3154(317, 6, 'Rijnwoude', NULL, NULL),
3155(318, 11, 'Rijssen Holten', NULL, NULL),
3156(319, 6, 'Rijswijk', NULL, NULL),
3157(320, 7, 'Roerdalen', NULL, NULL),
3158(321, 7, 'Roermond', NULL, NULL),
3159(322, 7, 'Roggel en Neer', NULL, NULL),
3160(323, 2, 'Roosendaal', NULL, NULL),
3161(324, 6, 'Rotterdam', NULL, NULL),
3162(325, 6, 'Rozenburg', NULL, NULL),
3163(326, 3, 'Rozendaal', NULL, NULL),
3164(327, 2, 'Rucphen', NULL, NULL),
3165(328, 6, 's Gravendeel', NULL, NULL),
3166(329, 6, 's Gravenhage', NULL, NULL),
3167(330, 2, 's Hertogenbosch', NULL, NULL),
3168(331, 8, 'Schagen', NULL, NULL),
3169(332, 9, 'Scheemda', NULL, NULL),
3170(333, 8, 'Schermer', NULL, NULL),
3171(334, 3, 'Scherpenzeel', NULL, NULL),
3172(335, 6, 'Schiedam', NULL, NULL),
3173(336, 5, 'Schiermonnikoog', NULL, NULL),
3174(337, 2, 'Schijndel', NULL, NULL),
3175(338, 7, 'Schinnen', NULL, NULL),
3176(339, 6, 'Schoonhoven', NULL, NULL),
3177(340, 10, 'Schouwen Duiveland', NULL, NULL),
3178(341, 7, 'Sevenum', NULL, NULL),
3179(342, 7, 'Simpelveld', NULL, NULL),
3180(343, 2, 'Sint Anthonis', NULL, NULL),
3181(344, 2, 'Sint Michielsgestel', NULL, NULL),
3182(345, 2, 'Sint Oedenrode', NULL, NULL),
3183(346, 7, 'Sittard Geleen', NULL, NULL),
3184(347, 5, 'Skarsterlan', NULL, NULL),
3185(348, 6, 'Sliedrecht', NULL, NULL),
3186(349, 9, 'Slochteren', NULL, NULL),
3187(350, 10, 'Sluis', NULL, NULL),
3188(351, 5, 'Smallingerland', NULL, NULL),
3189(352, 5, 'Sneek', NULL, NULL),
3190(353, 4, 'Soest', NULL, NULL),
3191(354, 2, 'Someren', NULL, NULL),
3192(355, 2, 'Son en Breugel', NULL, NULL),
3193(356, 6, 'Spijkenisse', NULL, NULL),
3194(357, 9, 'Stadskanaal', NULL, NULL),
3195(358, 11, 'Staphorst', NULL, NULL),
3196(359, 8, 'Stede Broec', NULL, NULL),
3197(360, 2, 'Steenbergen', NULL, NULL),
3198(361, 11, 'Steenwijkerland', NULL, NULL),
3199(362, 7, 'Stein', NULL, NULL),
3200(363, 6, 'Strijen', NULL, NULL),
3201(364, 7, 'Swalmen', NULL, NULL),
3202(365, 9, 'Ten Boer', NULL, NULL),
3203(366, 6, 'Ter Aar', NULL, NULL),
3204(367, 10, 'Terneuzen', NULL, NULL),
3205(368, 5, 'Terschelling', NULL, NULL),
3206(369, 8, 'Texel', NULL, NULL),
3207(370, 6, 'Teylingen', NULL, NULL),
3208(371, 10, 'Tholen', NULL, NULL),
3209(372, 7, 'Thorn', NULL, NULL),
3210(373, 3, 'Tiel', NULL, NULL),
3211(374, 2, 'Tilburg', NULL, NULL),
3212(375, 11, 'Tubbergen', NULL, NULL),
3213(376, 11, 'Twenterand', NULL, NULL),
3214(377, 1, 'Tynaarlo', NULL, NULL),
3215(378, 5, 'Tytsjerksteradiel', NULL, NULL),
3216(379, 3, 'Ubbergen', NULL, NULL),
3217(380, 2, 'Uden', NULL, NULL),
3218(381, 8, 'Uitgeest', NULL, NULL),
3219(382, 8, 'Uithoorn', NULL, NULL),
3220(383, 12, 'Urk', NULL, NULL),
3221(384, 4, 'Utrecht', NULL, NULL),
3222(385, 4, 'Utrechtse Heuvelrug', NULL, NULL),
3223(386, 7, 'Vaals', NULL, NULL),
3224(387, 7, 'Valkenburg aan de Geul', NULL, NULL),
3225(388, 2, 'Valkenswaard', NULL, NULL),
3226(389, 9, 'Veendam', NULL, NULL),
3227(390, 4, 'Veenendaal', NULL, NULL),
3228(391, 10, 'Veere', NULL, NULL),
3229(392, 2, 'Veghel', NULL, NULL),
3230(393, 2, 'Veldhoven', NULL, NULL),
3231(394, 8, 'Velsen', NULL, NULL),
3232(395, 7, 'Venlo', NULL, NULL),
3233(396, 7, 'Venray', NULL, NULL),
3234(397, 4, 'Vianen', NULL, NULL),
3235(398, 6, 'Vlaardingen', NULL, NULL),
3236(399, 9, 'Vlagtwedde', NULL, NULL),
3237(400, 5, 'Vlieland', NULL, NULL),
3238(401, 10, 'Vlissingen', NULL, NULL),
3239(402, 6, 'Vlist', NULL, NULL),
3240(403, 7, 'Voerendaal', NULL, NULL),
3241(404, 6, 'Voorschoten', NULL, NULL),
3242(405, 3, 'Voorst', NULL, NULL),
3243(406, 2, 'Vught', NULL, NULL),
3244(407, 2, 'Waalre', NULL, NULL),
3245(408, 2, 'Waalwijk', NULL, NULL),
3246(409, 6, 'Waddinxveen', NULL, NULL),
3247(410, 3, 'Wageningen', NULL, NULL),
3248(411, 6, 'Wassenaar', NULL, NULL),
3249(412, 8, 'Waterland', NULL, NULL),
3250(413, 7, 'Weert', NULL, NULL),
3251(414, 8, 'Weesp', NULL, NULL),
3252(415, 2, 'Werkendam', NULL, NULL),
3253(416, 8, 'Wervershoof', NULL, NULL),
3254(417, 3, 'West Maas en Waal', NULL, NULL),
3255(418, 8, 'Wester Koggenland', NULL, NULL),
3256(419, 1, 'Westerveld', NULL, NULL),
3257(420, 3, 'Westervoort', NULL, NULL),
3258(421, 6, 'Westland', NULL, NULL),
3259(422, 5, 'Weststellingwerf', NULL, NULL),
3260(423, 6, 'Westvoorne', NULL, NULL),
3261(424, 11, 'Wierden', NULL, NULL),
3262(425, 8, 'Wieringen', NULL, NULL),
3263(426, 8, 'Wieringermeer', NULL, NULL),
3264(427, 3, 'Wijchen', NULL, NULL),
3265(428, 8, 'Wijdemeren', NULL, NULL),
3266(429, 4, 'Wijk bij Duurstede', NULL, NULL),
3267(430, 9, 'Winschoten', NULL, NULL),
3268(431, 9, 'Winsum', NULL, NULL),
3269(432, 3, 'Winterswijk', NULL, NULL),
3270(433, 2, 'Woensdrecht', NULL, NULL),
3271(434, 4, 'Woerden', NULL, NULL),
3272(435, 8, 'Wognum', NULL, NULL),
3273(436, 8, 'Wormerland', NULL, NULL),
3274(437, 4, 'Woudenberg', NULL, NULL),
3275(438, 2, 'Woudrichem', NULL, NULL),
3276(439, 5, 'Wunseradiel', NULL, NULL),
3277(440, 5, 'Wymbritseradiel', NULL, NULL),
3278(441, 8, 'Zaanstad', NULL, NULL),
3279(442, 3, 'Zaltbommel', NULL, NULL),
3280(443, 8, 'Zandvoort', NULL, NULL),
3281(444, 6, 'Zederik', NULL, NULL),
3282(445, 8, 'Zeevang', NULL, NULL),
3283(446, 12, 'Zeewolde', NULL, NULL),
3284(447, 4, 'Zeist', NULL, NULL),
3285(448, 3, 'Zevenaar', NULL, NULL),
3286(449, 6, 'Zevenhuizen Moerkapelle', NULL, NULL),
3287(450, 8, 'Zijpe', NULL, NULL),
3288(451, 6, 'Zoetermeer', NULL, NULL),
3289(452, 6, 'Zoeterwoude', NULL, NULL),
3290(453, 9, 'Zuidhorn', NULL, NULL),
3291(454, 2, 'Zundert', NULL, NULL),
3292(455, 3, 'Zutphen', NULL, NULL),
3293(456, 11, 'Zwartewaterland', NULL, NULL),
3294(457, 6, 'Zwijndrecht', NULL, NULL),
3295(458, 11, 'Zwolle', NULL, NULL);
3296
3297-- --------------------------------------------------------
3298
3299--
3300-- Table structure for table `notification`
3301--
3302
3303DROP TABLE IF EXISTS `notification`;
3304CREATE TABLE `notification` (
3305  `id` int(11) NOT NULL,
3306  `notificationTypeId` int(10) unsigned NOT NULL,
3307  `questionId` int(11) NOT NULL DEFAULT '0',
3308  `answerId` int(11) NOT NULL DEFAULT '0',
3309  `userId` int(10) unsigned NOT NULL,
3310  `status` int(11) DEFAULT '0',
3311  `dateCreated` datetime DEFAULT NULL
3312) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
3313
3314--
3315-- Dumping data for table `notification`
3316--
3317
3318INSERT INTO `notification` (`id`, `notificationTypeId`, `questionId`, `answerId`, `userId`, `status`, `dateCreated`) VALUES
3319(1, 1, 1, 0, 1, 2, '2016-11-02 00:00:00'),
3320(2, 1, 1, 0, 1, 1, '2016-11-09 00:00:00'),
3321(3, 2, 1, 0, 1, 3, '2016-11-01 00:00:00');
3322
3323-- --------------------------------------------------------
3324
3325--
3326-- Table structure for table `notificationType`
3327--
3328
3329DROP TABLE IF EXISTS `notificationType`;
3330CREATE TABLE `notificationType` (
3331  `id` int(10) unsigned NOT NULL,
3332  `key` varchar(25) NOT NULL,
3333  `value` varchar(255) NOT NULL
3334) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
3335
3336--
3337-- Dumping data for table `notificationType`
3338--
3339
3340INSERT INTO `notificationType` (`id`, `key`, `value`) VALUES
3341(1, 'newAnswer', 'heeft uw vraag beantwoord.'),
3342(2, 'newCommentAnswer', 'heeft gereageerd op uw antwoord.'),
3343(3, 'newReplyComment', 'heeft gereageerd op uw reactie.'),
3344(4, 'newRequest', 'heeft u gevraagd om een vraag te beantwoorden.'),
3345(5, 'deletedAnswer', 'Uw antwoord is door de community verwijderd.'),
3346(6, 'deletedComment', 'Uw reactie is door de community verwijderd.'),
3347(7, 'deletedQuestion', 'Uw vraag is door de community verwijderd.'),
3348(8, 'group', 'heeft een vraag gesteld aan');
3349
3350-- --------------------------------------------------------
3351
3352--
3353-- Table structure for table `page`
3354--
3355
3356DROP TABLE IF EXISTS `page`;
3357CREATE TABLE `page` (
3358  `id` int(10) unsigned NOT NULL,
3359  `content` mediumtext,
3360  `data` varchar(255) NOT NULL,
3361  `img` varchar(255) NOT NULL,
3362  `partyId` int(11) unsigned NOT NULL,
3363  `dateUpdated` datetime NOT NULL
3364) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
3365
3366--
3367-- Dumping data for table `page`
3368--
3369
3370INSERT INTO `page` (`id`, `content`, `data`, `img`, `partyId`, `dateUpdated`) VALUES
3371(1, 'hallo dit is een pagina', 'http://wikipedia.nl', 'fotovanpagina.png', 4, '2016-11-09 00:00:00');
3372
3373-- --------------------------------------------------------
3374
3375--
3376-- Table structure for table `party`
3377--
3378
3379DROP TABLE IF EXISTS `party`;
3380CREATE TABLE `party` (
3381  `id` int(11) NOT NULL,
3382  `leader` varchar(255) DEFAULT NULL,
3383  `leaderUrl` varchar(255) DEFAULT NULL,
3384  `established` int(11) DEFAULT NULL,
3385  `members` int(11) DEFAULT NULL,
3386  `seatsFirst` int(11) DEFAULT NULL,
3387  `seatsSecond` int(11) DEFAULT NULL,
3388  `seatsEU` int(11) DEFAULT NULL
3389) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
3390
3391--
3392-- Dumping data for table `party`
3393--
3394
3395INSERT INTO `party` (`id`, `leader`, `leaderUrl`, `established`, `members`, `seatsFirst`, `seatsSecond`, `seatsEU`) VALUES
3396(1, 'Mark Rutte', NULL, 1948, 28436, 13, 40, 3),
3397(2, 'Sybrand Buma', NULL, 1980, 50181, 12, 13, 5),
3398(3, 'Gert-Jan Segers', NULL, 2001, 23398, 3, 5, 1),
3399(4, 'Alexander Pechtold', NULL, 1966, 25349, 10, 12, 4),
3400(5, 'Jesse Klaver', NULL, 1990, 21180, 4, 4, 2),
3401(6, 'Diederik Samsom', NULL, 1946, 46045, 8, 36, 3),
3402(7, 'Marianne Thieme', NULL, 2002, 12131, 2, 2, 1),
3403(8, 'Kees van der Staaij', NULL, 1918, 29928, 2, 3, 1),
3404(9, 'Emile Roemer', NULL, 1971, 41710, 9, 15, 2),
3405(10, 'Jan Roos', NULL, 2014, 1150, 0, 2, 0),
3406(11, 'Norbert Klein', NULL, 2014, 287, 0, 1, 0),
3407(12, 'Henk Krol', NULL, 2009, 6056, 2, 1, 0),
3408(13, 'Ancilla van de Leest', NULL, 2010, 6056, 0, 0, 0),
3409(14, 'Tunahan Kuzu', NULL, 2015, 0, 0, 0, 0);
3410
3411-- --------------------------------------------------------
3412
3413--
3414-- Table structure for table `poll`
3415--
3416
3417DROP TABLE IF EXISTS `poll`;
3418CREATE TABLE `poll` (
3419  `id` int(10) unsigned NOT NULL,
3420  `questionId` int(11) NOT NULL,
3421  `title` varchar(255) NOT NULL,
3422  `dateCreated` datetime NOT NULL
3423) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
3424
3425--
3426-- Dumping data for table `poll`
3427--
3428
3429INSERT INTO `poll` (`id`, `questionId`, `title`, `dateCreated`) VALUES
3430(1, 1, 'Wie heeft al heel veel gedaan vandaag?', '2016-11-06 00:00:00');
3431
3432-- --------------------------------------------------------
3433
3434--
3435-- Table structure for table `pollOption`
3436--
3437
3438DROP TABLE IF EXISTS `pollOption`;
3439CREATE TABLE `pollOption` (
3440  `id` int(10) unsigned NOT NULL,
3441  `pollId` int(10) unsigned NOT NULL,
3442  `value` varchar(255) NOT NULL
3443) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
3444
3445--
3446-- Dumping data for table `pollOption`
3447--
3448
3449INSERT INTO `pollOption` (`id`, `pollId`, `value`) VALUES
3450(1, 1, 'Wietse'),
3451(2, 1, 'Hilda');
3452
3453-- --------------------------------------------------------
3454
3455--
3456-- Table structure for table `pollVote`
3457--
3458
3459DROP TABLE IF EXISTS `pollVote`;
3460CREATE TABLE `pollVote` (
3461  `id` int(10) unsigned NOT NULL,
3462  `userId` int(10) unsigned NOT NULL,
3463  `pollOptionId` int(10) unsigned NOT NULL,
3464  `dateCreated` datetime DEFAULT NULL
3465) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
3466
3467--
3468-- Dumping data for table `pollVote`
3469--
3470
3471INSERT INTO `pollVote` (`id`, `userId`, `pollOptionId`, `dateCreated`) VALUES
3472(1, 1, 1, '2016-11-02 00:00:00'),
3473(2, 1, 1, '2016-11-10 00:00:00'),
3474(3, 1, 2, '2016-11-09 00:00:00');
3475
3476-- --------------------------------------------------------
3477
3478--
3479-- Table structure for table `province`
3480--
3481
3482DROP TABLE IF EXISTS `province`;
3483CREATE TABLE `province` (
3484  `id` int(10) unsigned NOT NULL,
3485  `name` varchar(255) NOT NULL,
3486  `img` varchar(255) DEFAULT NULL,
3487  `pageId` int(11) DEFAULT NULL
3488) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
3489
3490--
3491-- Dumping data for table `province`
3492--
3493
3494INSERT INTO `province` (`id`, `name`, `img`, `pageId`) VALUES
3495(1, 'Drenthe', NULL, NULL),
3496(2, 'Noord Brabant', NULL, NULL),
3497(3, 'Gelderland', NULL, NULL),
3498(4, 'Utrecht', NULL, NULL),
3499(5, 'Friesland', NULL, NULL),
3500(6, 'Zuid Holland', NULL, NULL),
3501(7, 'Limburg', NULL, NULL),
3502(8, 'Noord Holland', NULL, NULL),
3503(9, 'Groningen', NULL, NULL),
3504(10, 'Zeeland', NULL, NULL),
3505(11, 'Overijssel', NULL, NULL),
3506(12, 'Flevoland', NULL, NULL);
3507
3508-- --------------------------------------------------------
3509
3510--
3511-- Table structure for table `question`
3512--
3513
3514DROP TABLE IF EXISTS `question`;
3515CREATE TABLE `question` (
3516  `id` int(11) unsigned NOT NULL,
3517  `userId` int(10) unsigned NOT NULL,
3518  `slug` varchar(255) NOT NULL,
3519  `title` varchar(255) NOT NULL,
3520  `description` mediumtext NOT NULL,
3521  `views` int(11) DEFAULT '0',
3522  `upvoted` int(11) DEFAULT '0',
3523  `shared` int(10) unsigned DEFAULT '0',
3524  `downvoted` int(11) DEFAULT '0',
3525  `reported` int(11) DEFAULT '0',
3526  `dateCreated` datetime NOT NULL,
3527  `lastAnswered` datetime DEFAULT NULL,
3528  `closingDate` datetime DEFAULT NULL
3529) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
3530
3531--
3532-- Dumping data for table `question`
3533--
3534
3535INSERT INTO `question` (`id`, `userId`, `slug`, `title`, `description`, `views`, `upvoted`, `shared`, `downvoted`, `reported`, `dateCreated`, `lastAnswered`, `closingDate`) VALUES
3536(1, 1, 'Wie-wordt-de-nieuwe-president-van-Amerika', 'Wie wordt de nieuwe president van amerika?', 'Trump of Clinton?', 12, 2, 10, 1, 200, '2016-11-03 09:22:22', '2016-11-03 08:20:24', '2016-11-24 11:28:29');
3537
3538-- --------------------------------------------------------
3539
3540--
3541-- Table structure for table `questionInvite`
3542--
3543
3544DROP TABLE IF EXISTS `questionInvite`;
3545CREATE TABLE `questionInvite` (
3546  `id` int(11) NOT NULL,
3547  `from` int(10) unsigned NOT NULL,
3548  `to` int(10) unsigned NOT NULL,
3549  `status` int(11) DEFAULT '0',
3550  `questionId` int(11) NOT NULL
3551) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
3552
3553--
3554-- Dumping data for table `questionInvite`
3555--
3556
3557INSERT INTO `questionInvite` (`id`, `from`, `to`, `status`, `questionId`) VALUES
3558(1, 2, 1, 2, 1);
3559
3560-- --------------------------------------------------------
3561
3562--
3563-- Table structure for table `questionMedium`
3564--
3565
3566DROP TABLE IF EXISTS `questionMedium`;
3567CREATE TABLE `questionMedium` (
3568  `id` int(10) unsigned NOT NULL,
3569  `questionId` int(10) unsigned NOT NULL,
3570  `mediumTypeId` int(10) unsigned NOT NULL,
3571  `title` varchar(255) NOT NULL,
3572  `url` varchar(255) NOT NULL
3573) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
3574
3575--
3576-- Dumping data for table `questionMedium`
3577--
3578
3579INSERT INTO `questionMedium` (`id`, `questionId`, `mediumTypeId`, `title`, `url`) VALUES
3580(1, 1, 2, 'dit is een video of zo', 'http://facebook.com');
3581
3582-- --------------------------------------------------------
3583
3584--
3585-- Table structure for table `reaction`
3586--
3587
3588DROP TABLE IF EXISTS `reaction`;
3589CREATE TABLE `reaction` (
3590  `id` int(10) unsigned NOT NULL,
3591  `answerId` int(11) NOT NULL,
3592  `userId` int(10) unsigned NOT NULL,
3593  `reaction` tinytext,
3594  `reported` int(11) DEFAULT '0',
3595  `upvoted` int(11) DEFAULT '0',
3596  `downvoted` int(11) DEFAULT '0',
3597  `dateCreated` datetime DEFAULT NULL
3598) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
3599
3600--
3601-- Dumping data for table `reaction`
3602--
3603
3604INSERT INTO `reaction` (`id`, `answerId`, `userId`, `reaction`, `reported`, `upvoted`, `downvoted`, `dateCreated`) VALUES
3605(1, 1, 1, 'heyoo', 0, 2, 1, '2016-11-08 00:00:00'),
3606(2, 1, 1, 'nog een reactie', 1, 12, 3, '2016-11-16 00:00:00');
3607
3608-- --------------------------------------------------------
3609
3610--
3611-- Table structure for table `reply`
3612--
3613
3614DROP TABLE IF EXISTS `reply`;
3615CREATE TABLE `reply` (
3616  `id` int(11) NOT NULL,
3617  `reactionId` int(10) unsigned NOT NULL,
3618  `userId` int(10) unsigned NOT NULL,
3619  `reply` tinytext NOT NULL,
3620  `reported` int(11) DEFAULT '0',
3621  `upvoted` int(11) DEFAULT '0',
3622  `downvoted` int(11) DEFAULT '0',
3623  `dateCreated` datetime DEFAULT NULL
3624) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
3625
3626--
3627-- Dumping data for table `reply`
3628--
3629
3630INSERT INTO `reply` (`id`, `reactionId`, `userId`, `reply`, `reported`, `upvoted`, `downvoted`, `dateCreated`) VALUES
3631(1, 2, 1, 'dit is een reply!!', 0, 0, 0, '2016-11-08 00:00:00');
3632
3633-- --------------------------------------------------------
3634
3635--
3636-- Table structure for table `resetList`
3637--
3638
3639DROP TABLE IF EXISTS `resetList`;
3640CREATE TABLE `resetList` (
3641  `id` int(11) NOT NULL,
3642  `emailAddress` varchar(255) NOT NULL,
3643  `hash` varchar(255) NOT NULL,
3644  `dateCreated` datetime DEFAULT NULL
3645) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
3646
3647--
3648-- Dumping data for table `resetList`
3649--
3650
3651INSERT INTO `resetList` (`id`, `emailAddress`, `hash`, `dateCreated`) VALUES
3652(1, 'wietse.l.devries@gmail.com', 'kjhrqwkjh32lkj5hl32kj4h', '2016-11-03 00:00:00');
3653
3654-- --------------------------------------------------------
3655
3656--
3657-- Table structure for table `setting`
3658--
3659
3660DROP TABLE IF EXISTS `setting`;
3661CREATE TABLE `setting` (
3662  `id` int(11) NOT NULL,
3663  `userId` int(10) unsigned NOT NULL,
3664  `settingTypeId` int(10) unsigned NOT NULL,
3665  `value` int(11) NOT NULL DEFAULT '0',
3666  `dateChanged` datetime DEFAULT NULL
3667) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
3668
3669--
3670-- Dumping data for table `setting`
3671--
3672
3673INSERT INTO `setting` (`id`, `userId`, `settingTypeId`, `value`, `dateChanged`) VALUES
3674(1, 1, 2, 1, '2016-11-09 00:00:00'),
3675(2, 1, 3, 1, '2016-11-08 00:00:00');
3676
3677-- --------------------------------------------------------
3678
3679--
3680-- Table structure for table `settingType`
3681--
3682
3683DROP TABLE IF EXISTS `settingType`;
3684CREATE TABLE `settingType` (
3685  `id` int(10) unsigned NOT NULL,
3686  `key` varchar(25) DEFAULT NULL,
3687  `value` varchar(255) DEFAULT NULL,
3688  `hidden` tinyint(1) NOT NULL DEFAULT '0'
3689) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
3690
3691--
3692-- Dumping data for table `settingType`
3693--
3694
3695INSERT INTO `settingType` (`id`, `key`, `value`, `hidden`) VALUES
3696(1, 'email', 'Email notificaties ontvangen', 0),
3697(2, 'desktop', 'Desktop notificaties ontvangen', 0),
3698(3, 'work', 'Geen notificaties ontvangen tussen 09:00 en 17:00 uur', 0),
3699(4, 'digest', 'Periodiek een samenvattingen ontvangen per email', 0),
3700(5, 'layout', 'Open of gesloten weergave van vragen', 1),
3701(6, 'shareFacebook', 'Gebruiker heeft bij laatste actie gedeeld op fb', 1),
3702(7, 'shareTwitter', 'Gebruiker heeft bij laatste actie gedeeld op twitter', 1),
3703(8, 'followPage', 'Wilt u notificaties ontvangen voor nieuwe vragen op deze pagina?', 1);
3704
3705-- --------------------------------------------------------
3706
3707--
3708-- Table structure for table `tag`
3709--
3710
3711DROP TABLE IF EXISTS `tag`;
3712CREATE TABLE `tag` (
3713  `id` int(10) unsigned NOT NULL,
3714  `questionId` int(11) NOT NULL,
3715  `tagValueId` int(11) NOT NULL
3716) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
3717
3718--
3719-- Dumping data for table `tag`
3720--
3721
3722INSERT INTO `tag` (`id`, `questionId`, `tagValueId`) VALUES
3723(1, 1, 2),
3724(2, 1, 18);
3725
3726-- --------------------------------------------------------
3727
3728--
3729-- Table structure for table `tagValue`
3730--
3731
3732DROP TABLE IF EXISTS `tagValue`;
3733CREATE TABLE `tagValue` (
3734  `id` int(10) unsigned NOT NULL,
3735  `key` varchar(255) NOT NULL,
3736  `value` varchar(255) NOT NULL,
3737  `used` int(11) DEFAULT '0',
3738  `userId` int(10) unsigned NOT NULL,
3739  `pageId` int(11) NOT NULL DEFAULT '0',
3740  `dateCreated` datetime DEFAULT NULL
3741) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8;
3742
3743--
3744-- Dumping data for table `tagValue`
3745--
3746
3747INSERT INTO `tagValue` (`id`, `key`, `value`, `used`, `userId`, `pageId`, `dateCreated`) VALUES
3748(1, '', 'Onderwijs', 0, 0, 0, NULL),
3749(2, 'begroting', 'Begroting', 0, 1, 1, NULL),
3750(3, '', 'Defensie', 0, 0, 0, NULL),
3751(4, '', 'Oorlog', 0, 0, 0, NULL),
3752(5, '', 'Vluchtelingen', 0, 0, 0, NULL),
3753(6, '', 'Rijkswaterstaat', 0, 0, 0, NULL),
3754(7, '', 'windmolens', 0, 0, 0, NULL),
3755(8, '', 'Groene energie', 0, 0, 0, NULL),
3756(9, '', 'Onderwijs', 0, 0, 0, NULL),
3757(10, '', 'Syrie', 0, 0, 0, NULL),
3758(11, '', 'ISIS', 0, 0, 0, NULL),
3759(12, '', 'Olie', 0, 0, 0, NULL),
3760(13, '', 'VN (Verenigde naties)', 0, 0, 0, NULL),
3761(14, '', 'Burgermeester', 0, 0, 0, NULL),
3762(15, '', 'Eerste kamer', 0, 0, 0, NULL),
3763(16, '', 'Tweede kamer', 0, 0, 0, NULL),
3764(17, '', 'EU (Europese Unie)', 0, 0, 0, NULL),
3765(18, '', 'Discriminatie', 0, 0, 0, NULL),
3766(19, '', 'Sexisme', 0, 0, 0, NULL),
3767(20, '', 'Verkeer', 0, 0, 0, NULL),
3768(21, '', 'Cultuur', 0, 0, 0, NULL),
3769(22, '', 'Wetenschap', 0, 0, 0, NULL),
3770(23, '', 'Koning', 0, 0, 0, NULL),
3771(24, '', 'Monarchie', 0, 0, 0, NULL),
3772(25, '', 'Willem-Alexander', 0, 0, 0, NULL),
3773(26, '', 'Justitie', 0, 0, 0, NULL),
3774(27, '', 'Politie', 0, 0, 0, NULL),
3775(28, '', 'Zorgverzekering', 0, 0, 0, NULL),
3776(29, '', 'Werkgelegenheid', 0, 0, 0, NULL),
3777(30, '', 'Sociale zaken', 0, 0, 0, NULL),
3778(31, '', 'Infrastructuur', 0, 0, 0, NULL),
3779(32, '', 'Drenthe', 0, 0, 0, NULL),
3780(33, '', 'Noord Brabant', 0, 0, 0, NULL),
3781(34, '', 'Noord Holland', 0, 0, 0, NULL),
3782(35, '', 'Gelderland', 0, 0, 0, NULL),
3783(36, '', 'Utrecht (Provincie)', 0, 0, 0, NULL),
3784(37, '', 'Friesland', 0, 0, 0, NULL),
3785(38, '', 'Zuid Holland', 0, 0, 0, NULL),
3786(39, '', 'Overijssel', 0, 0, 0, NULL),
3787(40, '', 'Flevoland', 0, 0, 0, NULL),
3788(41, '', 'Limburg', 0, 0, 0, NULL),
3789(42, '', 'Groningen (Provincie)', 0, 0, 0, NULL),
3790(43, '', 'Zeeland', 0, 0, 0, NULL),
3791(44, '', 'Ministerie van Algemene Zaken (A)', 0, 0, 0, NULL),
3792(45, '', 'Ministerie van Binnenlandse Zaken en Koninkrijksrelaties (BZK)', 0, 0, 0, NULL),
3793(46, '', 'Ministerie van Buitenlandse Zaken (BuZa)', 0, 0, 0, NULL),
3794(47, '', 'Ministerie van Defensie', 0, 0, 0, NULL),
3795(48, '', 'Ministerie van Economische Zaken (EZ)', 0, 0, 0, NULL),
3796(49, '', 'Ministerie van Financiën', 0, 0, 0, NULL),
3797(50, '', 'Ministerie van Infrastructuur en Milieu (I&M)', 0, 0, 0, NULL),
3798(51, '', 'Ministerie van Onderwijs, Cultuur en Wetenschap (OCW)', 0, 0, 0, NULL),
3799(52, '', 'Ministerie van Sociale Zaken en Werkgelegenheid (SZW)', 0, 0, 0, NULL),
3800(53, '', 'Ministerie van Veiligheid en Justitie (V&J)', 0, 0, 0, NULL),
3801(54, '', 'Ministerie van Volksgezondheid, Welzijn en Sport (VWS)', 0, 0, 0, NULL);
3802
3803-- --------------------------------------------------------
3804
3805--
3806-- Table structure for table `user`
3807--
3808
3809DROP TABLE IF EXISTS `user`;
3810CREATE TABLE `user` (
3811  `id` int(10) unsigned NOT NULL,
3812  `email` varchar(255) NOT NULL,
3813  `password` varchar(255) DEFAULT NULL,
3814  `userName` varchar(255) NOT NULL,
3815  `avatar` varchar(255) DEFAULT NULL,
3816  `firstName` varchar(255) DEFAULT NULL,
3817  `lastName` varchar(255) DEFAULT NULL,
3818  `function` varchar(255) DEFAULT NULL,
3819  `bio` tinytext,
3820  `cityId` int(10) unsigned NOT NULL,
3821  `ageId` int(10) unsigned NOT NULL,
3822  `gender` enum('m','f') DEFAULT NULL,
3823  `educationId` int(10) unsigned NOT NULL,
3824  `incomeId` int(10) unsigned NOT NULL,
3825  `maritalStatusId` int(11) NOT NULL,
3826  `children` enum('y','n') DEFAULT NULL,
3827  `statusId` int(10) unsigned DEFAULT '0',
3828  `verified` int(11) DEFAULT '0',
3829  `dateRegistered` datetime DEFAULT NULL,
3830  `lastLogin` datetime DEFAULT NULL,
3831  `loginCount` int(10) unsigned DEFAULT '0',
3832  `reputation` int(10) unsigned DEFAULT '0'
3833) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
3834
3835--
3836-- Dumping data for table `user`
3837--
3838
3839INSERT INTO `user` (`id`, `email`, `password`, `userName`, `avatar`, `firstName`, `lastName`, `function`, `bio`, `cityId`, `ageId`, `gender`, `educationId`, `incomeId`, `maritalStatusId`, `children`, `statusId`, `verified`, `dateRegistered`, `lastLogin`, `loginCount`, `reputation`) VALUES
3840(1, 'wietse.l.devries@gmail.com', 'password123', 'wietse', 'wietse.png', 'Wietse', 'de Vries', 'Programmeur Burgerzetel.nl', 'ik heet wietse!:P', 1, 3, 'm', 5, 3, 1, 'n', 2, 1, '2016-11-03 18:35:40', '2016-11-03 18:35:44', 2, 1501),
3841(2, 'tijmen@helder.com', 'Passwd123', 't-dawg', 'tijmen.png', 'Tijmen', 'Helder', 'Receptioniste burgerzetel.nl', 'hoi, ik ben tijmen helder en ik rook heel langzaam.', 56, 3, 'm', 5, 3, 2, 'y', 3, 1, '2016-11-17 00:00:00', '2016-11-17 00:00:00', 12, 501);
3842
3843-- --------------------------------------------------------
3844
3845--
3846-- Table structure for table `visit`
3847--
3848
3849DROP TABLE IF EXISTS `visit`;
3850CREATE TABLE `visit` (
3851  `id` int(10) unsigned NOT NULL,
3852  `questionId` int(10) unsigned NOT NULL,
3853  `userId` int(10) unsigned NOT NULL,
3854  `count` int(11) NOT NULL DEFAULT '0' COMMENT 'track which question a user has visited. If more than once, increment ‘count’',
3855  `dateCreated` datetime DEFAULT NULL,
3856  `tagValueId` int(11) NOT NULL
3857) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
3858
3859--
3860-- Dumping data for table `visit`
3861--
3862
3863INSERT INTO `visit` (`id`, `questionId`, `userId`, `count`, `dateCreated`, `tagValueId`) VALUES
3864(1, 1, 1, 23, '2016-11-09 00:00:00', 0),
3865(3, 1, 1, 12, '2016-11-02 00:00:00', 0);
3866
3867--
3868-- Indexes for dumped tables
3869--
3870
3871--
3872-- Indexes for table `age`
3873--
3874ALTER TABLE `age`
3875  ADD PRIMARY KEY (`id`);
3876
3877--
3878-- Indexes for table `answer`
3879--
3880ALTER TABLE `answer`
3881  ADD PRIMARY KEY (`id`),
3882  ADD KEY `fk_answer1_idx` (`questionId`),
3883  ADD KEY `fk_answer2_idx` (`userId`);
3884
3885--
3886-- Indexes for table `answerMedium`
3887--
3888ALTER TABLE `answerMedium`
3889  ADD PRIMARY KEY (`id`),
3890  ADD KEY `fk_answer_medium1_idx` (`answerId`),
3891  ADD KEY `fk_answer_medium2_idx` (`mediumTypeId`);
3892
3893--
3894-- Indexes for table `city`
3895--
3896ALTER TABLE `city`
3897  ADD PRIMARY KEY (`id`),
3898  ADD KEY `fk_city1_idx` (`municipalityId`);
3899
3900--
3901-- Indexes for table `education`
3902--
3903ALTER TABLE `education`
3904  ADD PRIMARY KEY (`id`);
3905
3906--
3907-- Indexes for table `faq`
3908--
3909ALTER TABLE `faq`
3910  ADD PRIMARY KEY (`id`);
3911
3912--
3913-- Indexes for table `favorite`
3914--
3915ALTER TABLE `favorite`
3916  ADD PRIMARY KEY (`id`),
3917  ADD KEY `fk_favorite2_idx` (`userId`);
3918
3919--
3920-- Indexes for table `income`
3921--
3922ALTER TABLE `income`
3923  ADD PRIMARY KEY (`id`);
3924
3925--
3926-- Indexes for table `interest`
3927--
3928ALTER TABLE `interest`
3929  ADD PRIMARY KEY (`id`);
3930
3931--
3932-- Indexes for table `maritalStatus`
3933--
3934ALTER TABLE `maritalStatus`
3935  ADD PRIMARY KEY (`id`);
3936
3937--
3938-- Indexes for table `mediumType`
3939--
3940ALTER TABLE `mediumType`
3941  ADD PRIMARY KEY (`id`);
3942
3943--
3944-- Indexes for table `milestone`
3945--
3946ALTER TABLE `milestone`
3947  ADD PRIMARY KEY (`id`);
3948
3949--
3950-- Indexes for table `milestoneType`
3951--
3952ALTER TABLE `milestoneType`
3953  ADD PRIMARY KEY (`id`);
3954
3955--
3956-- Indexes for table `municipality`
3957--
3958ALTER TABLE `municipality`
3959  ADD PRIMARY KEY (`id`),
3960  ADD KEY `fk_municipality1_idx` (`provinceId`);
3961
3962--
3963-- Indexes for table `notification`
3964--
3965ALTER TABLE `notification`
3966  ADD PRIMARY KEY (`id`),
3967  ADD KEY `fk_notification1_idx` (`notificationTypeId`),
3968  ADD KEY `fk_notification2_idx` (`userId`),
3969  ADD KEY `fk_notification3_idx` (`questionId`),
3970  ADD KEY `fk_notification4_idx` (`answerId`);
3971
3972--
3973-- Indexes for table `notificationType`
3974--
3975ALTER TABLE `notificationType`
3976  ADD PRIMARY KEY (`id`);
3977
3978--
3979-- Indexes for table `page`
3980--
3981ALTER TABLE `page`
3982  ADD PRIMARY KEY (`id`);
3983
3984--
3985-- Indexes for table `party`
3986--
3987ALTER TABLE `party`
3988  ADD PRIMARY KEY (`id`);
3989
3990--
3991-- Indexes for table `poll`
3992--
3993ALTER TABLE `poll`
3994  ADD PRIMARY KEY (`id`),
3995  ADD KEY `fk_poll1_idx` (`questionId`);
3996
3997--
3998-- Indexes for table `pollOption`
3999--
4000ALTER TABLE `pollOption`
4001  ADD PRIMARY KEY (`id`),
4002  ADD KEY `fk_poll_option1_idx` (`pollId`);
4003
4004--
4005-- Indexes for table `pollVote`
4006--
4007ALTER TABLE `pollVote`
4008  ADD PRIMARY KEY (`id`),
4009  ADD KEY `fk_poll_vote1_idx` (`userId`),
4010  ADD KEY `fk_poll_vote3_idx` (`pollOptionId`);
4011
4012--
4013-- Indexes for table `province`
4014--
4015ALTER TABLE `province`
4016  ADD PRIMARY KEY (`id`);
4017
4018--
4019-- Indexes for table `question`
4020--
4021ALTER TABLE `question`
4022  ADD PRIMARY KEY (`id`),
4023  ADD UNIQUE KEY `slug_UNIQUE` (`slug`),
4024  ADD KEY `fk_question1_idx` (`userId`);
4025
4026--
4027-- Indexes for table `questionInvite`
4028--
4029ALTER TABLE `questionInvite`
4030  ADD PRIMARY KEY (`id`),
4031  ADD KEY `fk_question_invite1_idx` (`to`),
4032  ADD KEY `fk_question_invite2_idx` (`from`);
4033
4034--
4035-- Indexes for table `questionMedium`
4036--
4037ALTER TABLE `questionMedium`
4038  ADD PRIMARY KEY (`id`),
4039  ADD KEY `fk_question_medium1_idx` (`questionId`),
4040  ADD KEY `fk_question_medium2_idx` (`mediumTypeId`);
4041
4042--
4043-- Indexes for table `reaction`
4044--
4045ALTER TABLE `reaction`
4046  ADD PRIMARY KEY (`id`),
4047  ADD KEY `fk_reaction1_idx` (`answerId`),
4048  ADD KEY `fk_reaction2_idx` (`userId`);
4049
4050--
4051-- Indexes for table `reply`
4052--
4053ALTER TABLE `reply`
4054  ADD PRIMARY KEY (`id`),
4055  ADD KEY `fk_reply1_idx` (`userId`),
4056  ADD KEY `fk_reply2_idx` (`reactionId`);
4057
4058--
4059-- Indexes for table `resetList`
4060--
4061ALTER TABLE `resetList`
4062  ADD PRIMARY KEY (`id`);
4063
4064--
4065-- Indexes for table `setting`
4066--
4067ALTER TABLE `setting`
4068  ADD PRIMARY KEY (`id`),
4069  ADD KEY `fk_setting1_idx` (`userId`),
4070  ADD KEY `fk_setting2_idx` (`settingTypeId`);
4071
4072--
4073-- Indexes for table `settingType`
4074--
4075ALTER TABLE `settingType`
4076  ADD PRIMARY KEY (`id`);
4077
4078--
4079-- Indexes for table `tag`
4080--
4081ALTER TABLE `tag`
4082  ADD PRIMARY KEY (`id`);
4083
4084--
4085-- Indexes for table `tagValue`
4086--
4087ALTER TABLE `tagValue`
4088  ADD PRIMARY KEY (`id`);
4089
4090--
4091-- Indexes for table `user`
4092--
4093ALTER TABLE `user`
4094  ADD PRIMARY KEY (`id`),
4095  ADD KEY `fk_user1_idx` (`ageId`),
4096  ADD KEY `fk_user2_idx` (`educationId`),
4097  ADD KEY `fk_user3_idx` (`maritalStatusId`),
4098  ADD KEY `fk_user4_idx` (`incomeId`),
4099  ADD KEY `fk_user5_idx` (`cityId`);
4100
4101--
4102-- Indexes for table `visit`
4103--
4104ALTER TABLE `visit`
4105  ADD PRIMARY KEY (`id`);
4106
4107--
4108-- AUTO_INCREMENT for dumped tables
4109--
4110
4111--
4112-- AUTO_INCREMENT for table `age`
4113--
4114ALTER TABLE `age`
4115  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
4116--
4117-- AUTO_INCREMENT for table `answer`
4118--
4119ALTER TABLE `answer`
4120  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
4121--
4122-- AUTO_INCREMENT for table `answerMedium`
4123--
4124ALTER TABLE `answerMedium`
4125  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
4126--
4127-- AUTO_INCREMENT for table `education`
4128--
4129ALTER TABLE `education`
4130  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
4131--
4132-- AUTO_INCREMENT for table `faq`
4133--
4134ALTER TABLE `faq`
4135  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
4136--
4137-- AUTO_INCREMENT for table `favorite`
4138--
4139ALTER TABLE `favorite`
4140  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
4141--
4142-- AUTO_INCREMENT for table `income`
4143--
4144ALTER TABLE `income`
4145  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=9;
4146--
4147-- AUTO_INCREMENT for table `interest`
4148--
4149ALTER TABLE `interest`
4150  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
4151--
4152-- AUTO_INCREMENT for table `maritalStatus`
4153--
4154ALTER TABLE `maritalStatus`
4155  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
4156--
4157-- AUTO_INCREMENT for table `mediumType`
4158--
4159ALTER TABLE `mediumType`
4160  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
4161--
4162-- AUTO_INCREMENT for table `milestone`
4163--
4164ALTER TABLE `milestone`
4165  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
4166--
4167-- AUTO_INCREMENT for table `milestoneType`
4168--
4169ALTER TABLE `milestoneType`
4170  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=29;
4171--
4172-- AUTO_INCREMENT for table `notification`
4173--
4174ALTER TABLE `notification`
4175  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
4176--
4177-- AUTO_INCREMENT for table `notificationType`
4178--
4179ALTER TABLE `notificationType`
4180  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=9;
4181--
4182-- AUTO_INCREMENT for table `page`
4183--
4184ALTER TABLE `page`
4185  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
4186--
4187-- AUTO_INCREMENT for table `party`
4188--
4189ALTER TABLE `party`
4190  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=15;
4191--
4192-- AUTO_INCREMENT for table `poll`
4193--
4194ALTER TABLE `poll`
4195  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
4196--
4197-- AUTO_INCREMENT for table `pollOption`
4198--
4199ALTER TABLE `pollOption`
4200  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
4201--
4202-- AUTO_INCREMENT for table `pollVote`
4203--
4204ALTER TABLE `pollVote`
4205  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
4206--
4207-- AUTO_INCREMENT for table `province`
4208--
4209ALTER TABLE `province`
4210  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=13;
4211--
4212-- AUTO_INCREMENT for table `question`
4213--
4214ALTER TABLE `question`
4215  MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
4216--
4217-- AUTO_INCREMENT for table `questionInvite`
4218--
4219ALTER TABLE `questionInvite`
4220  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
4221--
4222-- AUTO_INCREMENT for table `questionMedium`
4223--
4224ALTER TABLE `questionMedium`
4225  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
4226--
4227-- AUTO_INCREMENT for table `reaction`
4228--
4229ALTER TABLE `reaction`
4230  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
4231--
4232-- AUTO_INCREMENT for table `reply`
4233--
4234ALTER TABLE `reply`
4235  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
4236--
4237-- AUTO_INCREMENT for table `resetList`
4238--
4239ALTER TABLE `resetList`
4240  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
4241--
4242-- AUTO_INCREMENT for table `setting`
4243--
4244ALTER TABLE `setting`
4245  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
4246--
4247-- AUTO_INCREMENT for table `settingType`
4248--
4249ALTER TABLE `settingType`
4250  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=9;
4251--
4252-- AUTO_INCREMENT for table `tag`
4253--
4254ALTER TABLE `tag`
4255  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
4256--
4257-- AUTO_INCREMENT for table `tagValue`
4258--
4259ALTER TABLE `tagValue`
4260  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=55;
4261--
4262-- AUTO_INCREMENT for table `user`
4263--
4264ALTER TABLE `user`
4265  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
4266--
4267-- AUTO_INCREMENT for table `visit`
4268--
4269ALTER TABLE `visit`
4270  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;