INSERT INTO elections (id, name, counting_method, election_id, location, domain_id, category, number_of_seats,
                       election_date, nomination_date, political_groups)
VALUES (1, 'Gemeenteraad 2026', 'CSO', 'Juinen_2024', 'Juinen', '0000', 'Municipal', 29, '2024-11-30', '2024-11-01', '[
         {
           "number": 1,
           "name": "Lijst Hekking",
           "candidates": [
             {
               "number": 1,
               "initials": "T.",
               "first_name": "Tjolk",
               "last_name": "Hekking",
               "locality": "Juinen",
               "gender": "Male"
             },
             {
               "number": 2,
               "initials": "H.",
               "first_name": "Henny",
               "last_name": "Hekking",
               "locality": "Juinen",
               "gender": "Female"
             },
             {
               "number": 3,
               "initials": "W.",
               "first_name": "Hans",
               "last_name_prefix": "van der",
               "last_name": "Vaart",
               "locality": "Juinen",
               "gender": "Male"
             },
             {
               "number": 4,
               "initials": "T.H.",
               "first_name": "Tjolkse Hendrika",
               "last_name": "Hekking",
               "locality": "Juinen",
               "gender": "Female"
             },
             {
               "number": 5,
               "initials": "H.",
               "first_name": "Hendrik",
               "last_name": "Hekking",
               "locality": "Juinen",
               "gender": "Male"
             },
             {
               "number": 6,
               "initials": "F.",
               "first_name": "Frank",
               "last_name_prefix": "van",
               "last_name": "Putten",
               "locality": "Juinen",
               "gender": null
             },
             {
               "number": 7,
               "initials": "C.",
               "first_name": "Carla",
               "last_name_prefix": "van",
               "last_name": "Putten",
               "locality": "Juinen",
               "gender": "Female"
             },
             {
               "number": 8,
               "initials": "I.",
               "first_name": "Ijt",
               "last_name": "Haargrens",
               "locality": "Juinen",
               "gender": "Male"
             }
           ]
         },
         {
           "number": 2,
           "name": "De Tegenpartij",
           "candidates": [
             {
               "number": 1,
               "initials": "F.",
               "first_name": "Frederik",
               "last_name": "Jacobse",
               "locality": "Den Haag",
               "gender": "Male"
             },
             {
               "number": 2,
               "initials": "T.J.",
               "first_name": "Tedje Johannes",
               "last_name_prefix": "van",
               "last_name": "Es",
               "locality": "Den Haag",
               "gender": "Male"
             },
             {
               "number": 3,
               "initials": "K.",
               "first_name": "Karel",
               "last_name_prefix": "van",
               "last_name": "Es",
               "locality": "Den Haag",
               "gender": "Male"
             },
             {
               "number": 4,
               "initials": "T.",
               "first_name": "Tilly",
               "last_name_prefix": "van",
               "last_name": "Yvonne",
               "locality": "Den Haag",
               "gender": "Female"
             },
             {
               "number": 5,
               "initials": "W.",
               "first_name": "Willy",
               "last_name_prefix": "van",
               "last_name": "Yvonne",
               "locality": "Den Haag",
               "gender": "Female"
             },
             {
               "number": 6,
               "initials": "F.",
               "first_name": "Henkie",
               "last_name_prefix": "de",
               "last_name": "Knip",
               "locality": "Den Haag",
               "gender": null
             }
           ]
         },
         {
           "number": 3,
           "name": "Juinen vooruit",
           "candidates": [
             {
               "number": 1,
               "initials": "L.",
               "first_name": "Lidewij",
               "last_name": "Oud",
               "locality": "Juinen",
               "gender": "Female"
             },
             {
               "number": 2,
               "initials": "J.",
               "first_name": "Johan",
               "last_name": "Oud",
               "locality": "Juinen",
               "gender": "Male"
             },
             {
               "number": 3,
               "initials": "M.",
               "first_name": "Marijke",
               "last_name": "Oud",
               "locality": "Juinen",
               "gender": "Female"
             },
             {
               "number": 4,
               "initials": "A.",
               "first_name": "Arie",
               "last_name": "Jansen",
               "locality": "Juinen",
               "gender": "Male"
             },
             {
               "number": 5,
               "initials": "H.",
               "first_name": "Henk",
               "last_name_prefix": "van der",
               "last_name": "Weijden",
               "locality": "Juinen",
               "gender": "Male"
             },
             {
               "number": 6,
               "initials": "B.",
               "first_name": "Berta",
               "last_name_prefix": "van der",
               "last_name": "Weijden",
               "locality": "Juinen",
               "gender": "Female"
             },
             {
               "number": 7,
               "initials": "K.",
               "first_name": "Klaas",
               "last_name": "Oud",
               "locality": "Juinen",
               "gender": "Male"
             },
             {
               "number": 8,
               "initials": "S.",
               "first_name": "Sophie",
               "last_name": "Bakker",
               "locality": "Juinen",
               "gender": "Female"
             },
             {
               "number": 9,
               "initials": "J.",
               "first_name": "Johan",
               "last_name_prefix": "de",
               "last_name": "Vries",
               "locality": "Juinen",
               "gender": "Male"
             },
             {
               "number": 10,
               "initials": "M.",
               "first_name": "Marijke",
               "last_name_prefix": "van den",
               "last_name": "Berg",
               "locality": "Juinen",
               "gender": "Female"
             },
             {
               "number": 11,
               "initials": "R.",
               "first_name": "Rolf",
               "last_name_prefix": "de",
               "last_name": "Jong",
               "locality": "Juinen",
               "gender": "Male"
             },
             {
               "number": 12,
               "initials": "K.",
               "first_name": "Karin",
               "last_name": "Kok",
               "locality": "Juinen",
               "gender": "Female"
             },
             {
               "number": 13,
               "initials": "G.",
               "first_name": "Gert",
               "last_name": "Smit",
               "locality": "Juinen",
               "gender": "Male"
             },
             {
               "number": 14,
               "initials": "E.",
               "first_name": "Eva",
               "last_name": "Koster",
               "locality": "Juinen",
               "gender": "Female"
             },
             {
               "number": 15,
               "initials": "L.",
               "first_name": "Leon",
               "last_name": "Hofman",
               "locality": "Juinen",
               "gender": "Male"
             },
             {
               "number": 16,
               "initials": "S.",
               "first_name": "Sophie",
               "last_name": "Visser",
               "locality": "Juinen",
               "gender": "Female"
             },
             {
               "number": 17,
               "initials": "D.",
               "first_name": "Dirk",
               "last_name": "Bakker",
               "locality": "Juinen",
               "gender": "Male"
             },
             {
               "number": 18,
               "initials": "P.",
               "first_name": "Piet",
               "last_name": "Jansen",
               "locality": "Juinen",
               "gender": "Male"
             },
             {
               "number": 19,
               "initials": "A.",
               "first_name": "Annelies",
               "last_name_prefix": "van",
               "last_name": "Loon",
               "locality": "Juinen",
               "gender": "Female"
             },
             {
               "number": 20,
               "initials": "T.J.",
               "first_name": "Tessa",
               "last_name": "Jansen",
               "locality": "Juinen",
               "gender": "Female"
             },
             {
               "number": 21,
               "initials": "H.J.",
               "first_name": "Hans",
               "last_name": "Jansen",
               "locality": "Juinen",
               "gender": "Male"
             },
             {
               "number": 22,
               "initials": "W.J.",
               "first_name": "Willem",
               "last_name": "Janssen",
               "locality": "Juinen",
               "gender": "Male"
             },
             {
               "number": 23,
               "initials": "B.",
               "first_name": "Bert",
               "last_name": "Meyer",
               "locality": "Juinen",
               "gender": "Male"
             },
             {
               "number": 24,
               "initials": "M.M.",
               "first_name": "Mieke",
               "last_name": "Meyer",
               "locality": "Juinen",
               "gender": "Female"
             },
             {
               "number": 25,
               "initials": "J.V.",
               "first_name": "Jan",
               "last_name_prefix": "van",
               "last_name": "Dijk",
               "locality": "Juinen",
               "gender": "Male"
             },
             {
               "number": 26,
               "initials": "S.D.",
               "first_name": "Suzan",
               "last_name_prefix": "de",
               "last_name": "Wit",
               "locality": "Juinen",
               "gender": "Female"
             },
             {
               "number": 27,
               "initials": "K.V.",
               "first_name": "Koen",
               "last_name_prefix": "van der",
               "last_name": "Meer",
               "locality": "Juinen",
               "gender": "Male"
             },
             {
               "number": 28,
               "initials": "L.S.",
               "first_name": "Laura",
               "last_name": "Smit",
               "locality": "Juinen",
               "gender": "Female"
             },
             {
               "number": 29,
               "initials": "F.K.",
               "first_name": "Frank",
               "last_name": "Kool",
               "locality": "Juinen",
               "gender": "Male"
             },
             {
               "number": 30,
               "initials": "C.R.",
               "first_name": "Claudia",
               "last_name": "Reinders",
               "locality": "Juinen",
               "gender": "Female"
             }
           ]
         },
         {
           "number": 4,
           "name": "",
           "candidates": [
             {
               "number": 1,
               "initials": "T.",
               "first_name": "Tinus",
               "last_name": "Bakker",
               "locality": "Juinen",
               "gender": "Male"
             },
             {
               "number": 2,
               "initials": "D.",
               "last_name": "Po",
               "locality": "Juinen",
               "gender": "X"
             },
             {
               "number": 3,
               "initials": "W.",
               "first_name": "Willem",
               "last_name_prefix": "de",
               "last_name": "Vries",
               "locality": "Juinen",
               "gender": "Male"
             },
             {
               "number": 4,
               "initials": "K.",
               "first_name": "Klaas",
               "last_name": "Kloosterboer",
               "locality": "Juinen",
               "gender": "Male"
             },
             {
               "number": 5,
               "initials": "L.",
               "first_name": "Liesbeth",
               "last_name": "Jansen",
               "locality": "Juinen",
               "gender": "Female"
             },
             {
               "number": 6,
               "initials": "H.",
               "first_name": "Henk",
               "last_name_prefix": "van den",
               "last_name": "Berg",
               "locality": "Juinen",
               "gender": "Male"
             },
             {
               "number": 7,
               "initials": "A.",
               "first_name": "Adelbert",
               "last_name_prefix": "van",
               "last_name": "Doorn",
               "locality": "Juinen",
               "gender": "Male"
             },
             {
               "number": 8,
               "initials": "M.",
               "first_name": "Margriet",
               "last_name_prefix": "van der",
               "last_name": "Linden",
               "locality": "Juinen",
               "gender": "Female"
             },
             {
               "number": 9,
               "initials": "P.",
               "first_name": "Paul",
               "last_name": "Veldkamp",
               "locality": "Juinen",
               "gender": "Male"
             },
             {
               "number": 10,
               "initials": "S.",
               "first_name": "Sophie",
               "last_name_prefix": "de",
               "last_name": "Groot",
               "locality": "Juinen",
               "gender": "Female"
             },
             {
               "number": 11,
               "initials": "R.",
               "first_name": "Rik",
               "last_name_prefix": "de",
               "last_name": "Ruiter",
               "locality": "Juinen",
               "gender": "Male"
             },
             {
               "number": 12,
               "initials": "N.",
               "first_name": "Nico",
               "last_name": "Ruiter",
               "locality": "Juinen",
               "gender": "Male"
             },
             {
               "number": 13,
               "initials": "G.",
               "first_name": "Gerard",
               "last_name": "Bogaert",
               "locality": "Juinen",
               "gender": "Male"
             },
             {
               "number": 14,
               "initials": "J.",
               "first_name": "Jan",
               "last_name": "Stevens",
               "locality": "Juinen",
               "gender": "Male"
             },
             {
               "number": 15,
               "initials": "E.",
               "first_name": "Els",
               "last_name": "Groot",
               "locality": "Juinen",
               "gender": "Female"
             },
             {
               "number": 16,
               "initials": "B.",
               "first_name": "Bart",
               "last_name": "Smit",
               "locality": "Juinen",
               "gender": "Male"
             },
             {
               "number": 17,
               "initials": "F.",
               "first_name": "Frits",
               "last_name": "Veldman",
               "locality": "Juinen",
               "gender": "Male"
             },
             {
               "number": 18,
               "initials": "T.J.",
               "first_name": "Tessa",
               "last_name": "Jansen",
               "locality": "Juinen",
               "gender": "Female"
             },
             {
               "number": 19,
               "initials": "W.J.",
               "first_name": "Willem",
               "last_name": "Jansen",
               "locality": "Juinen",
               "gender": "Male"
             },
             {
               "number": 20,
               "initials": "L.J.",
               "first_name": "Loes",
               "last_name": "Jansen",
               "locality": "Juinen",
               "gender": "Female"
             },
             {
               "number": 21,
               "initials": "A.V.",
               "first_name": "Aart",
               "last_name_prefix": "van der",
               "last_name": "Meer",
               "locality": "Juinen",
               "gender": "Male"
             },
             {
               "number": 22,
               "initials": "R.D.",
               "first_name": "Ria",
               "last_name_prefix": "de",
               "last_name": "Vries",
               "locality": "Juinen",
               "gender": "Female"
             },
             {
               "number": 23,
               "initials": "J.D.",
               "first_name": "Joris",
               "last_name_prefix": "de",
               "last_name": "Vries",
               "locality": "Juinen",
               "gender": "Male"
             },
             {
               "number": 24,
               "initials": "H.M.",
               "first_name": "Hanneke",
               "last_name": "Muller",
               "locality": "Juinen",
               "gender": "Female"
             },
             {
               "number": 25,
               "initials": "P.D.",
               "first_name": "Pieter",
               "last_name_prefix": "de",
               "last_name": "Graaf",
               "locality": "Juinen",
               "gender": "Male"
             },
             {
               "number": 26,
               "initials": "K.M.",
               "first_name": "Karin",
               "last_name": "Meyer",
               "locality": "Juinen",
               "gender": "Female"
             },
             {
               "number": 27,
               "initials": "D.K.",
               "first_name": "Daan",
               "last_name": "Kool",
               "locality": "Juinen",
               "gender": "Male"
             },
             {
               "number": 28,
               "initials": "M.B.",
               "first_name": "Marcel",
               "last_name": "Bakker",
               "locality": "Juinen",
               "gender": "Male"
             },
             {
               "number": 29,
               "initials": "S.V.",
               "first_name": "Sander",
               "last_name": "Veldman",
               "locality": "Juinen",
               "gender": "Male"
             },
             {
               "number": 30,
               "initials": "T.S.",
               "first_name": "Tineke",
               "last_name": "Smit",
               "locality": "Juinen",
               "gender": "Female"
             },
             {
               "number": 31,
               "initials": "C.",
               "first_name": "Carl",
               "last_name": "Schmidt",
               "locality": "Juinen",
               "gender": "Male"
             },
             {
               "number": 32,
               "initials": "E.V.",
               "first_name": "Elisabeth",
               "last_name": "Vermeer",
               "locality": "Juinen",
               "gender": "Female"
             },
             {
               "number": 33,
               "initials": "B.S.",
               "first_name": "Bram",
               "last_name": "Snel",
               "locality": "Juinen",
               "gender": "Male"
             },
             {
               "number": 34,
               "initials": "M.W.",
               "first_name": "Mieke",
               "last_name": "Willems",
               "locality": "Juinen",
               "gender": "Female"
             },
             {
               "number": 35,
               "initials": "H.B.",
               "first_name": "Hans",
               "last_name": "Brouwer",
               "locality": "Juinen",
               "gender": "Male"
             },
             {
               "number": 36,
               "initials": "G.D.",
               "first_name": "Gerda",
               "last_name": "Dekker",
               "locality": "Juinen",
               "gender": "Female"
             },
             {
               "number": 37,
               "initials": "R.V.",
               "first_name": "Rik",
               "last_name_prefix": "van der",
               "last_name": "Laan",
               "locality": "Juinen",
               "gender": "Male"
             },
             {
               "number": 38,
               "initials": "L.B.",
               "first_name": "Linda",
               "last_name": "Bakker",
               "locality": "Juinen",
               "gender": "Female"
             },
             {
               "number": 39,
               "initials": "P.J.",
               "first_name": "Piet",
               "last_name": "Jansen",
               "locality": "Juinen",
               "gender": "Male"
             },
             {
               "number": 40,
               "initials": "M.L.",
               "first_name": "Marten",
               "last_name": "Lange",
               "locality": "Juinen",
               "gender": "Male"
             },
             {
               "number": 41,
               "initials": "T.K.",
               "first_name": "Tessa",
               "last_name": "Kramer",
               "locality": "Juinen",
               "gender": "Female"
             },
             {
               "number": 42,
               "initials": "A.S.",
               "first_name": "Albert",
               "last_name": "Schouten",
               "locality": "Juinen",
               "gender": "Male"
             },
             {
               "number": 43,
               "initials": "F.W.",
               "first_name": "Franka",
               "last_name": "Willems",
               "locality": "Juinen",
               "gender": "Female"
             },
             {
               "number": 44,
               "initials": "J.K.",
               "first_name": "Joris",
               "last_name": "Kool",
               "locality": "Juinen",
               "gender": "Male"
             },
             {
               "number": 45,
               "initials": "G.B.",
               "first_name": "Gerben",
               "last_name": "Bos",
               "locality": "Juinen",
               "gender": "Male"
             },
             {
               "number": 46,
               "initials": "K.P.",
               "first_name": "Kirsten",
               "last_name": "Peters",
               "locality": "Juinen",
               "gender": "Female"
             },
             {
               "number": 47,
               "initials": "B.M.",
               "first_name": "Bert",
               "last_name": "Molenaar",
               "locality": "Juinen",
               "gender": "Male"
             },
             {
               "number": 48,
               "initials": "H.D.",
               "first_name": "Hendrik",
               "last_name": "Dijkstra",
               "locality": "Juinen",
               "gender": "Male"
             },
             {
               "number": 49,
               "initials": "L.V.",
               "first_name": "Laura",
               "last_name_prefix": "van",
               "last_name": "Leeuwen",
               "locality": "Juinen",
               "gender": "Female"
             },
             {
               "number": 50,
               "initials": "P.N.",
               "first_name": "Paul",
               "last_name": "Nijhuis",
               "locality": "Juinen",
               "gender": "Male"
             }
           ]
         }
       ]');

INSERT INTO committee_sessions (id, number, election_id, status, location, start_date_time)
VALUES (1, 1, 1, 'data_entry_in_progress', '', NULL);

INSERT INTO polling_stations (id, committee_session_id, id_prev_session, name, number, number_of_voters, polling_station_type, address,
                              postal_code, locality)
VALUES (4, 1, NULL, 'Studio The Rules', 1, NULL, 'FixedLocation', 'Gerontoplein 1', '1337 YQ', 'Juinen'),
       (5, 1, NULL, 'Buurtcentrum de Mattenklopper', 2, 1000, 'Special', 'Complexiteitslaan 2b', '1337 QY',
        'Juinen'),
       (6, 1, NULL, 'Positivo Zaal', 3, NULL, NULL, 'Kerkweg 3', '1337 QA', 'Juinen');
