INSERT INTO elections (id, name, counting_method, election_id, location, domain_id, category, number_of_seats, election_date, nomination_date, political_groups)
VALUES (4, 'Test Election < 19 seats', 'CSO', 'TestLocation_2026', 'Test Location', '0000', 'Municipal', 15, '2026-03-18', '2026-02-02',
        '[
          {
            "number": 1,
            "name": "Political Group A",
            "candidates": [
              {
                "number": 1,
                "initials": "L.",
                "first_name": "Lidewij",
                "last_name": "Oud",
                "locality": "Test Location",
                "gender": "Female"
              },
              {
                "number": 2,
                "initials": "J.",
                "first_name": "Johan",
                "last_name": "Oud",
                "locality": "Test Location",
                "gender": "Male"
              },
              {
                "number": 3,
                "initials": "M.",
                "first_name": "Marijke",
                "last_name": "Oud",
                "locality": "Test Location",
                "gender": "Female"
              },
              {
                "number": 4,
                "initials": "A.",
                "first_name": "Arie",
                "last_name": "Jansen",
                "locality": "Test Location",
                "gender": "Male"
              },
              {
                "number": 5,
                "initials": "H.",
                "first_name": "Henk",
                "last_name_prefix": "van der",
                "last_name": "Weijden",
                "locality": "Test Location",
                "gender": "Male"
              },
              {
                "number": 6,
                "initials": "B.",
                "first_name": "Berta",
                "last_name_prefix": "van der",
                "last_name": "Weijden",
                "locality": "Test Location",
                "gender": "Female"
              },
              {
                "number": 7,
                "initials": "K.",
                "first_name": "Klaas",
                "last_name": "Oud",
                "locality": "Test Location",
                "gender": "Male"
              },
              {
                "number": 8,
                "initials": "S.",
                "first_name": "Sophie",
                "last_name": "Bakker",
                "locality": "Test Location",
                "gender": "Female"
              },
              {
                "number": 9,
                "initials": "J.",
                "first_name": "Johan",
                "last_name_prefix": "de",
                "last_name": "Vries",
                "locality": "Test Location",
                "gender": "Male"
              },
              {
                "number": 10,
                "initials": "M.",
                "first_name": "Marijke",
                "last_name_prefix": "van den",
                "last_name": "Berg",
                "locality": "Test Location",
                "gender": "Female"
              },
              {
                "number": 11,
                "initials": "R.",
                "first_name": "Rolf",
                "last_name_prefix": "de",
                "last_name": "Jong",
                "locality": "Test Location",
                "gender": "Male"
              },
              {
                "number": 12,
                "initials": "K.",
                "first_name": "Karin",
                "last_name": "Kok",
                "locality": "Test Location",
                "gender": "Female"
              }
            ]
          },
          {
            "number": 2,
            "name": "Political Group B",
            "candidates": [
              {
                "number": 1,
                "initials": "T.",
                "first_name": "Tinus",
                "last_name": "Bakker",
                "locality": "Test Location",
                "gender": "Male"
              },
              {
                "number": 2,
                "initials": "D.",
                "last_name": "Po",
                "locality": "Test Location",
                "gender": "X"
              },
              {
                "number": 3,
                "initials": "W.",
                "first_name": "Willem",
                "last_name_prefix": "de",
                "last_name": "Vries",
                "locality": "Test Location",
                "gender": "Male"
              },
              {
                "number": 4,
                "initials": "K.",
                "first_name": "Klaas",
                "last_name": "Kloosterboer",
                "locality": "Test Location",
                "gender": "Male"
              },
              {
                "number": 5,
                "initials": "L.",
                "first_name": "Liesbeth",
                "last_name": "Jansen",
                "locality": "Test Location",
                "gender": "Female"
              },
              {
                "number": 6,
                "initials": "H.",
                "first_name": "Henk",
                "last_name_prefix": "van den",
                "last_name": "Berg",
                "locality": "Test Location",
                "gender": "Male"
              }
            ]
          }, {
            "number": 3,
            "name": "Political Group C",
            "candidates": [
              {
                "number": 1,
                "initials": "A.",
                "first_name": "Adelbert",
                "last_name_prefix": "van",
                "last_name": "Doorn",
                "locality": "Test Location",
                "gender": "Male"
              },
              {
                "number": 2,
                "initials": "M.",
                "first_name": "Margriet",
                "last_name_prefix": "van der",
                "last_name": "Linden",
                "locality": "Test Location",
                "gender": "Female"
              },
              {
                "number": 3,
                "initials": "P.",
                "first_name": "Paul",
                "last_name": "Veldkamp",
                "locality": "Test Location",
                "gender": "Male"
              },
              {
                "number": 4,
                "initials": "S.",
                "first_name": "Sophie",
                "last_name_prefix": "de",
                "last_name": "Groot",
                "locality": "Test Location",
                "gender": "Female"
              },
              {
                "number": 5,
                "initials": "R.",
                "first_name": "Rik",
                "last_name_prefix": "de",
                "last_name": "Ruiter",
                "locality": "Test Location",
                "gender": "Male"
              },
              {
                "number": 6,
                "initials": "N.",
                "first_name": "Nico",
                "last_name": "Ruiter",
                "locality": "Test Location",
                "gender": "Male"
              }
            ]
          }, {
            "number": 4,
            "name": "Political Group D",
            "candidates": [
              {
                "number": 1,
                "initials": "G.",
                "first_name": "Gerard",
                "last_name": "Bogaert",
                "locality": "Test Location",
                "gender": "Male"
              },
              {
                "number": 2,
                "initials": "J.",
                "first_name": "Jan",
                "last_name": "Stevens",
                "locality": "Test Location",
                "gender": "Male"
              },
              {
                "number": 3,
                "initials": "E.",
                "first_name": "Els",
                "last_name": "Groot",
                "locality": "Test Location",
                "gender": "Female"
              },
              {
                "number": 4,
                "initials": "B.",
                "first_name": "Bart",
                "last_name": "Smit",
                "locality": "Test Location",
                "gender": "Male"
              },
              {
                "number": 5,
                "initials": "F.",
                "first_name": "Frits",
                "last_name": "Veldman",
                "locality": "Test Location",
                "gender": "Male"
              }
            ]
          }, {
            "number": 5,
            "name": "Political Group E",
            "candidates": [
              {
                "number": 1,
                "initials": "G.",
                "first_name": "Gert",
                "last_name": "Smit",
                "locality": "Test Location",
                "gender": "Male"
              },
              {
                "number": 2,
                "initials": "E.",
                "first_name": "Eva",
                "last_name": "Koster",
                "locality": "Test Location",
                "gender": "Female"
              },
              {
                "number": 3,
                "initials": "L.",
                "first_name": "Leon",
                "last_name": "Hofman",
                "locality": "Test Location",
                "gender": "Male"
              },
              {
                "number": 4,
                "initials": "S.",
                "first_name": "Sophie",
                "last_name": "Visser",
                "locality": "Test Location",
                "gender": "Female"
              }
            ]
          }, {
            "number": 6,
            "name": "Political Group F",
            "candidates": [
              {
                "number": 1,
                "initials": "D.",
                "first_name": "Dirk",
                "last_name": "Bakker",
                "locality": "Test Location",
                "gender": "Male"
              },
              {
                "number": 2,
                "initials": "P.",
                "first_name": "Piet",
                "last_name": "Jansen",
                "locality": "Test Location",
                "gender": "Male"
              },
              {
                "number": 3,
                "initials": "A.",
                "first_name": "Annelies",
                "last_name_prefix": "van",
                "last_name": "Loon",
                "locality": "Test Location",
                "gender": "Female"
              },
              {
                "number": 4,
                "initials": "T.J.",
                "first_name": "Tessa",
                "last_name": "Jansen",
                "locality": "Test Location",
                "gender": "Female"
              }
            ]
          }, {
            "number": 7,
            "name": "Political Group G",
            "candidates": [
              {
                "number": 1,
                "initials": "T.",
                "first_name": "Tjolk",
                "last_name": "Hekking",
                "locality": "Test Location",
                "gender": "Male"
              },
              {
                "number": 2,
                "initials": "H.",
                "first_name": "Henny",
                "last_name": "Hekking",
                "locality": "Test Location",
                "gender": "Female"
              },
              {
                "number": 3,
                "initials": "W.",
                "first_name": "Hans",
                "last_name_prefix": "van der",
                "last_name": "Vaart",
                "locality": "Test Location",
                "gender": "Male"
              },
              {
                "number": 4,
                "initials": "T.H.",
                "first_name": "Tjolkse Hendrika",
                "last_name": "Hekking",
                "locality": "Test Location",
                "gender": "Female"
              }
            ]
          }, {
            "number": 8,
            "name": "Political Group H",
            "candidates": [
              {
                "number": 1,
                "initials": "F.",
                "first_name": "Frederik",
                "last_name": "Jacobse",
                "locality": "Test Location",
                "gender": "Male"
              },
              {
                "number": 2,
                "initials": "T.J.",
                "first_name": "Tedje Johannes",
                "last_name_prefix": "van",
                "last_name": "Es",
                "locality": "Test Location",
                "gender": "Male"
              },
              {
                "number": 3,
                "initials": "K.",
                "first_name": "Karel",
                "last_name_prefix": "van",
                "last_name": "Es",
                "locality": "Test Location",
                "gender": "Male"
              }
            ]
          }
        ]');

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

INSERT INTO polling_stations (id, committee_session_id, id_prev_session, name, number, number_of_voters, polling_station_type, address,
                              postal_code, locality)
VALUES (7, 4, NULL, 'Testgebouw', 40, NULL, 'FixedLocation', 'Testweg 3', '1234 QA', 'Klein Dorp');
