-- Okres [data_poczatku, data_konca): poczatek wlacznie, koniec wylacznie.
-- NULL w data_konca oznacza okres otwarty.
-- Data odniesienia do cwiczen: DATE '2026-10-01'.

BEGIN;

INSERT INTO osoba (id, imie, nazwisko, data_urodzenia, id_matki, id_ojca) VALUES
  (33, 'Jan', 'Adamski', DATE '1928-10-14', NULL, NULL),
  (421001, 'Wladyslaw', 'Baranski', DATE '1926-06-24', NULL, NULL),
  (421002, 'Kazimierz', 'Baranski', DATE '1950-07-14', NULL, 33),
  (900009, 'Janina', 'Adamska', DATE '1929-10-14', NULL, NULL),
  (1324, 'Tomasz', 'Czarnecki', DATE '1951-05-03', 900009, 421001),
  (4041, 'Piotr', 'Majewski', DATE '1938-10-14', NULL, NULL),
  (4042, 'Monika', 'Czarnecki', DATE '1940-11-11', NULL, NULL),
  (111, 'Piotr', 'Dabrowski', DATE '1951-04-23', 900009, 33),
  (3350, 'Maryla', 'Malinowska', DATE '1923-03-21', NULL, NULL),
  (3351, 'Leon', 'Ewertowski', DATE '1922-04-23', NULL, NULL),
  (3352, 'Danuta', 'Ewertowska', DATE '1945-05-03', 3350, 3351),
  (3353, 'Marek', 'Ewertowski', DATE '1945-06-24', 3350, 3351),
  (3354, 'Elzbieta', 'Pietrzak', DATE '1940-07-14', NULL, NULL),
  (3355, 'Lech', 'Falkowski', DATE '1930-08-15', NULL, NULL),
  (3356, 'Dariusz', 'Falkowski', DATE '1952-09-01', 3350, 3355),
  (3357, 'Jan', 'Gorski', DATE '1930-10-14', NULL, NULL),
  (3358, 'Dorota', 'Gorska', DATE '1952-11-11', 3350, 3357),
  (3359, 'Michal', 'Gorski', DATE '1952-12-24', 3350, 3357),
  (3361, 'Grzegorz', 'Idzikowski', DATE '1982-02-28', NULL, NULL),
  (3362, 'Barbara', 'Matejko', DATE '1983-03-21', NULL, NULL),
  (3364, 'Magdalena', 'Ewertowska', DATE '1967-05-03', 3354, 3353),
  (3365, 'Piotr', 'Ewertowski', DATE '1967-06-24', 3354, 3353),
  (404003, 'Jadwiga', 'Matejko', DATE '1962-12-24', 4042, 4041),
  (404005, 'Bozena', 'Lewandowska', DATE '1944-02-28', NULL, NULL),
  (8273, 'Grzegorz', 'Brzezinski', DATE '1973-06-24', 404005, 1324),
  (404004, 'Boleslaw', 'Franc', DATE '1942-01-06', NULL, NULL),
  (33500, 'Maryla', 'Malinowska', DATE '1925-09-01', NULL, NULL),
  (33501, 'Leon', 'Ewertowski', DATE '1923-10-14', NULL, NULL),
  (33502, 'Danuta', 'Ewertowska', DATE '1947-11-11', 33500, 33501),
  (33503, 'Marek', 'Ewertowski', DATE '1947-12-24', 33500, 33501),
  (33504, 'Elzbieta', 'Pietrzak', DATE '1948-01-06', NULL, NULL),
  (33505, 'Lech', 'Falkowski', DATE '1945-02-28', NULL, NULL),
  (33506, 'Dariusz', 'Falkowski', DATE '1969-03-21', 33502, 33505),
  (33507, 'Jan', 'Gorski', DATE '1948-04-23', NULL, NULL),
  (33508, 'Dorota', 'Gorska', DATE '1983-05-03', 33502, 33507),
  (33509, 'Michal', 'Gorski', DATE '1985-06-24', 33502, 33507),
  (33511, 'Grzegorz', 'Idzikowski', DATE '1948-08-15', NULL, NULL),
  (33512, 'Barbara', 'Matejko', DATE '1950-09-01', NULL, NULL),
  (33510, 'Joanna', 'Idzikowska', DATE '1972-07-14', 33512, 33511),
  (33513, 'Julia', 'Kaminska', DATE '1994-10-14', 33510, 33506),
  (33514, 'Magdalena', 'Ewertowska', DATE '1980-11-11', 33504, 33503),
  (33515, 'Piotr', 'Ewertowski', DATE '1982-12-24', 33504, 33503),
  (24300, 'Bruno', 'Lesinski', DATE '1952-01-06', 3350, 3355),
  (404006, 'Robert', 'Marciniak', DATE '1945-03-21', NULL, NULL),
  (24301, 'Piotr', 'Nowakowski', DATE '1962-02-28', 3354, 3355),
  (404007, 'Aneta', 'Borkowska', DATE '1952-04-23', NULL, NULL),
  (404008, 'Krzysztof', 'Jankowski', DATE '1951-05-03', NULL, NULL),
  (404009, 'Eleonora', 'Ostrowska', DATE '1950-06-24', NULL, NULL),
  (404010, 'John', 'Smith', DATE '1975-07-14', NULL, NULL),
  (900001, 'Mateusz', 'Nowicki', DATE '1985-02-28', NULL, NULL),
  (404011, 'Renata', 'Ewertowska', DATE '2016-08-15', 33513, 900001),
  (404012, 'Andrzej', 'Pawlowski', DATE '1973-09-01', 404009, 404008),
  (404013, 'Joanna', 'Matejko', DATE '1974-10-14', 404005, 24300),
  (361, 'Aleksander', 'Szymczak', DATE '1930-02-28', NULL, NULL),
  (362, 'Katarzyna', 'Walczak', DATE '1930-03-21', NULL, NULL),
  (363, 'Aleksander', 'Walczak', DATE '1952-04-23', 362, 361),
  (364, 'Katarzyna', 'Sikora', DATE '1930-05-03', NULL, NULL),
  (365, 'Gabriel', 'Wrobel', DATE '1974-06-24', 364, 363),
  (366, 'Michal', 'Jasinski', DATE '1974-07-14', 364, 363),
  (3670, 'Adam', 'Rutkowski', DATE '1974-11-11', 364, 363),
  (421003, 'Boleslaw', 'Rutkowski', DATE '1985-08-15', NULL, NULL),
  (421004, 'Antonina', 'Kulesza', DATE '1986-09-01', NULL, NULL),
  (127, 'Marian', 'Sokolowski', DATE '1930-08-15', NULL, NULL),
  (126, 'Teresa', 'Sokolowska', DATE '1930-07-14', NULL, NULL),
  (125, 'Krzysztof', 'Sokolowski', DATE '1952-06-24', 126, 127),
  (134324, 'Kazimierz', 'Tarnowski', DATE '1977-09-01', NULL, NULL),
  (32432, 'Adolf', 'Kielowski', DATE '1983-09-01', NULL, NULL),
  (231243, 'Milosz', 'Mazur', DATE '1979-04-23', NULL, NULL),
  (128, 'Adam', 'Adamski', DATE '1979-09-01', NULL, NULL),
  (23, 'Michal', 'Jankiewicz', DATE '1976-12-24', NULL, NULL),
  (1515, 'Henryk', 'Urbanowski', DATE '1972-04-23', NULL, NULL),
  (19, 'Marek', 'Urbanowski', DATE '1972-08-15', NULL, NULL),
  (123, 'Ewelina', 'Wojcik', DATE '1974-04-23', NULL, NULL),
  (1, 'Jaroslaw', 'Zawadzki', DATE '1971-02-28', NULL, NULL),
  (1032651, 'Tomasz', 'Domanski', DATE '1973-04-23', NULL, NULL),
  (1068104, 'Alicja', 'Fikalska', DATE '1981-09-01', NULL, NULL),
  (1990106, 'Heloiza', 'Piasecka', DATE '1971-03-21', NULL, NULL),
  (1011321, 'Karolina', 'Zalewska', DATE '1978-10-14', NULL, NULL),
  (101010, 'Tomasz', 'Szymanski', DATE '1983-07-14', NULL, NULL),
  (6, 'Marek', 'Ciesielski', DATE '1976-07-14', NULL, NULL),
  (1234, 'Zofia', 'Podgorska', DATE '1980-11-11', NULL, NULL),
  (1011324, 'Karol', 'Zalewski', DATE '1981-01-06', NULL, NULL),
  (98676, 'Jerzy', 'Borowski', DATE '1978-01-06', NULL, NULL),
  (213432, 'Helena', 'Kaczmarek', DATE '1984-01-06', NULL, NULL),
  (1344441, 'Adam', 'Slowacki', DATE '1983-10-14', NULL, NULL),
  (10, 'Malgorzata', 'Wroblewska', DATE '1980-11-11', NULL, NULL),
  (2, 'Tomasz', 'Kaczmarek', DATE '1972-03-21', NULL, NULL),
  (702, 'Piotr', 'Kowalczyk', DATE '1975-07-14', NULL, NULL),
  (3, 'Michal', 'Kowalczyk', DATE '1973-04-23', NULL, NULL),
  (17, 'Jozef', 'Stasinski', DATE '1970-06-24', NULL, NULL),
  (1093786, 'Dorota', 'Jedlipsa', DATE '1976-11-11', NULL, NULL),
  (4, 'Ryszard', 'Olszewski', DATE '1974-05-03', NULL, NULL),
  (9, 'Eugenia', 'Dolecka', DATE '1979-10-14', NULL, NULL),
  (1211340, 'Jan', 'Sobczak', DATE '1975-01-06', NULL, NULL),
  (703, 'Mariusz', 'Filipowski', DATE '1976-08-15', NULL, NULL),
  (1123244, 'Krzysztof', 'Sokolowski', DATE '1973-09-01', NULL, NULL),
  (3434, 'Milosz', 'Krajek', DATE '1970-03-21', NULL, NULL),
  (5, 'Jerzy', 'Radzik', DATE '1975-06-24', NULL, NULL),
  (174, 'Grzegorz', 'Malinowski', DATE '1974-07-14', NULL, NULL),
  (1039356, 'Konrad', 'Malek', DATE '1980-01-06', NULL, NULL),
  (7, 'Jan', 'Sobczak', DATE '1977-08-15', NULL, NULL),
  (175, 'Mikolaj', 'Kolodziej', DATE '1975-08-15', NULL, NULL),
  (1011328, 'Mikolaj', 'Mazurek', DATE '1985-05-03', NULL, NULL),
  (176, 'Edward', 'Maurer', DATE '1976-09-01', NULL, NULL),
  (7895, 'Boleslaw', 'Michalski', DATE '1977-12-24', NULL, NULL),
  (124321, 'Tomasz', 'Kaczmarek', DATE '1970-02-28', NULL, NULL),
  (34987, 'Wiktor', 'Wasilewski', DATE '1971-08-15', NULL, NULL),
  (174717, 'Marcin', 'Adamski', DATE '1930-10-14', NULL, NULL),
  (100125, 'Stanislawa', 'Burzynska', DATE '1930-10-14', NULL, NULL),
  (102030, 'Bartosz', 'Grzelak', DATE '1952-07-14', 100125, 174717),
  (1000123, 'Pawel', 'Dobrowolski', DATE '1983-08-15', NULL, NULL),
  (8743, 'Maciej', 'Grabowski', DATE '1975-08-15', NULL, NULL),
  (10203040, 'Jozef', 'Bielecki', DATE '1984-05-03', NULL, NULL),
  (100124, 'Adam', 'Ewertowski', DATE '1981-09-01', NULL, NULL),
  (110, 'Karolina', 'Konieczna', DATE '1978-03-21', NULL, NULL),
  (872789, 'Feliks', 'Dudzinski', DATE '1930-06-24', NULL, NULL),
  (102031, 'Marcin', 'Wierzbicki', DATE '1984-08-15', NULL, NULL),
  (109, 'Apoloniusz', 'Adamczyk', DATE '1977-02-28', NULL, NULL),
  (108, 'Stefania', 'Banasik', DATE '1976-01-06', NULL, NULL),
  (1007, 'Jakub', 'Bojarski', DATE '1962-12-24', 4042, 872789),
  (538789, 'Borys', 'Jankiewicz', DATE '1978-02-28', NULL, NULL),
  (107, 'Wojciech', 'Gajda', DATE '1975-12-24', NULL, NULL),
  (100126, 'Joanna', 'Falkowska', DATE '1983-11-11', NULL, NULL),
  (100127, 'Joanna', 'Falkowska', DATE '1984-12-24', NULL, NULL),
  (4880, 'Janusz', 'Adamski', DATE '1951-09-01', 900009, 33),
  (900002, 'Andrzej', 'Gajewski', DATE '1950-03-21', NULL, NULL),
  (12073, 'Tomasz', 'Gorski', DATE '1974-02-28', 3358, 900002),
  (1101, 'Anna', 'Urbanska', DATE '1940-10-14', NULL, NULL),
  (1102, 'Krzysztof', 'Adamski', DATE '1938-11-11', NULL, NULL),
  (1103, 'Monika', 'Urbanska', DATE '1962-12-24', 1101, 1102),
  (1104, 'Jacek', 'Adamski', DATE '1962-01-06', 1101, 1102),
  (1105, 'Janina', 'Miroslawski-Goetz', DATE '1940-02-28', NULL, NULL),
  (1106, 'Jozef', 'Miroslawski-Goetz', DATE '1939-03-21', NULL, NULL),
  (1107, 'Barbara', 'Miroslawski-Goetz', DATE '1962-04-23', 1105, 1106),
  (1108, 'Pawel', 'Miroslawski-Goetz', DATE '1962-05-03', 1105, 1106),
  (1109, 'Urszula', 'Miroslawski-Goetz', DATE '1984-06-24', 1103, 1108),
  (1110, 'Piotr', 'Jankiewicz', DATE '1982-07-14', NULL, NULL),
  (1111, 'Tomasz', 'Jankiewicz', DATE '2006-08-15', 1109, 1110),
  (1112, 'Kamil', 'Adamski', DATE '1982-09-01', NULL, NULL),
  (900003, 'Anna', 'Brzozowska', DATE '1920-04-23', NULL, NULL),
  (900004, 'Jan', 'Brzozowski', DATE '1918-05-03', NULL, NULL),
  (9824, 'Maria', 'Brzozowska', DATE '1942-09-01', 900003, 900004),
  (9901, 'Zofia', 'Brzozowska', DATE '1964-02-28', 9824, NULL),
  (900005, 'Maria', 'Lipinska', DATE '1922-06-24', NULL, NULL),
  (900006, 'Piotr', 'Lipinski', DATE '1920-07-14', NULL, NULL),
  (9823, 'Helena', 'Lipinska', DATE '1944-08-15', 900005, 900006),
  (9902, 'Danuta', 'Lipinska', DATE '1966-03-21', 9823, NULL),
  (900007, 'Zofia', 'Jaworska', DATE '1924-08-15', NULL, NULL),
  (900008, 'Stefan', 'Jaworski', DATE '1922-09-01', NULL, NULL),
  (9822, 'Anna', 'Jaworska', DATE '1946-07-14', 900007, 900008),
  (9903, 'Joanna', 'Jaworska', DATE '1968-04-23', 9822, NULL),
  (9904, 'Piotr', 'Jaworski', DATE '1968-05-03', 9822, NULL),
  (9701, 'Adam', 'Kowalski', DATE '1975-06-24', NULL, NULL),
  (9702, 'Anna', 'Kowalska', DATE '1976-07-14', NULL, NULL),
  (9703, 'Piotr', 'Nowak', DATE '1965-08-15', NULL, NULL),
  (9704, 'Maria', 'Nowak', DATE '1966-09-01', NULL, NULL),
  (9705, 'Tomasz', 'Wolski', DATE '1970-10-14', NULL, NULL),
  (9706, 'Ewa', 'Wolska', DATE '1968-11-11', NULL, NULL),
  (9707, 'Pawel', 'Lis', DATE '1967-12-24', NULL, NULL),
  (9708, 'Jan', 'Krawczyk', DATE '1966-01-06', NULL, NULL),
  (9709, 'Adam', 'Wisniewski', DATE '1970-02-28', NULL, NULL),
  (9710, 'Ewa', 'Wisniewska', DATE '1971-03-21', NULL, NULL),
  (9712, 'Joanna', 'Wisniewska', DATE '1972-05-03', NULL, NULL),
  (900010, 'Patrycja', 'Zielinska', DATE '1980-11-11', NULL, NULL),
  (900011, 'Pawel', 'Zielinski', DATE '1978-12-24', NULL, NULL),
  (900012, 'Julia', 'Zielinska', DATE '2012-02-29', 900010, 900011),
  (900013, 'Michal', 'Zielinski', DATE '2016-09-01', 900010, 900011);

INSERT INTO dowod (nr, id_osoby, data_poczatku, data_konca) VALUES
  ('421999001', 421001, DATE '1962-08-18', DATE '1972-07-02'),
  ('3424', 8273, DATE '1993-11-14', DATE '1995-11-21'),
  ('1', 8273, DATE '2011-10-26', DATE '2013-04-13'),
  ('12345678', 3365, DATE '2007-06-22', DATE '2020-01-25'),
  ('3423244', 404004, DATE '1960-04-11', DATE '1969-09-01'),
  ('4040003', 404004, DATE '1970-09-15', DATE '1979-04-29'),
  ('4040004', 404004, DATE '1997-09-20', DATE '1999-10-03'),
  ('4040005', 404004, DATE '2000-08-28', DATE '2006-10-03'),
  ('4040001', 404003, DATE '1989-10-08', DATE '1990-10-22'),
  ('4040002', 404003, DATE '1990-12-26', DATE '1991-08-25'),
  ('421998', 421003, DATE '2004-06-17', DATE '2005-09-22'),
  ('421997', 421004, DATE '2012-12-13', NULL),
  ('4040006', 404005, DATE '1971-09-06', NULL),
  ('4040007', 404006, DATE '1965-03-10', NULL),
  ('4040008', 404007, DATE '1994-08-16', DATE '2012-02-29'),
  ('4040009', 404008, DATE '2004-09-06', NULL),
  ('4040010', 404009, DATE '1977-03-15', DATE '1984-01-10'),
  ('1101', 1101, DATE '1978-04-24', NULL),
  ('1102', 1102, DATE '1968-03-14', DATE '1968-08-17'),
  ('1103', 1103, DATE '2003-03-16', NULL),
  ('1104', 1104, DATE '1991-06-15', DATE '2003-08-29'),
  ('1105', 1105, DATE '1965-09-30', DATE '1974-06-18'),
  ('1106', 1106, DATE '1971-04-18', DATE '1996-11-01'),
  ('1107', 1107, DATE '1999-11-20', NULL),
  ('1108', 1108, DATE '1999-04-08', DATE '2004-12-16'),
  ('1109', 1109, DATE '2002-07-10', DATE '2003-03-06'),
  ('1110', 1110, DATE '2016-12-18', DATE '2020-11-04'),
  ('1111', 1111, DATE '2024-11-02', DATE '2025-04-01'),
  ('1112', 1112, DATE '2007-12-11', DATE '2010-08-06'),
  ('90001001', 900010, DATE '2003-02-17', DATE '2015-11-22'),
  ('90001101', 900011, DATE '2001-01-12', DATE '2002-12-04'),
  ('90001102', 900011, DATE '2003-10-18', DATE '2007-12-02'),
  ('91000000', 404013, DATE '1998-10-17', DATE '2004-10-30'),
  ('91000001', 1007, DATE '1982-11-20', DATE '2008-04-13'),
  ('91000002', 33509, DATE '2006-11-10', DATE '2021-01-16'),
  ('91000003', 2, DATE '2005-10-06', DATE '2022-06-26'),
  ('91000004', 3365, DATE '2021-03-22', NULL),
  ('91000005', 900001, DATE '2015-11-19', NULL),
  ('91000006', 900003, DATE '1952-05-20', DATE '1968-12-05'),
  ('91000007', 900010, DATE '2022-11-20', DATE '2026-04-28'),
  ('91000008', 421003, DATE '2013-04-05', DATE '2021-03-07'),
  ('91000009', 8273, DATE '2014-08-13', NULL),
  ('91000010', 9706, DATE '1990-08-02', DATE '2021-04-21'),
  ('91000011', 231243, DATE '1999-02-10', DATE '2009-05-17'),
  ('91000012', 9702, DATE '1997-11-16', DATE '2022-03-20'),
  ('91000013', 3, DATE '2010-04-26', NULL),
  ('91000014', 101010, DATE '2009-05-23', DATE '2010-12-26'),
  ('91000015', 9707, DATE '1989-12-13', DATE '1995-08-22'),
  ('91000016', 7, DATE '1998-03-18', DATE '2007-04-26'),
  ('91000017', 900008, DATE '1947-09-30', DATE '2002-01-15'),
  ('91000018', 107, DATE '2001-06-28', NULL),
  ('91000019', 3350, DATE '1948-12-10', NULL),
  ('91000020', 1110, DATE '2022-03-08', NULL),
  ('91000021', 538789, DATE '1997-10-31', NULL),
  ('91000022', 7895, DATE '2008-12-01', DATE '2010-08-12'),
  ('91000023', 900011, DATE '2013-01-16', NULL),
  ('91000024', 102031, DATE '2018-10-10', DATE '2019-06-28'),
  ('91000025', 8743, DATE '2008-02-23', NULL),
  ('91000026', 404010, DATE '2006-10-01', DATE '2008-07-07'),
  ('91000027', 1109, DATE '2007-10-09', DATE '2015-07-03'),
  ('91000028', 1515, DATE '1997-03-05', NULL),
  ('91000029', 702, DATE '1998-08-04', NULL),
  ('91000030', 9703, DATE '1996-10-28', NULL),
  ('91000031', 1211340, DATE '1995-01-22', DATE '2015-04-20'),
  ('91000032', 9904, DATE '1996-12-03', NULL),
  ('91000033', 1112, DATE '2012-08-07', DATE '2023-04-24'),
  ('91000034', 900002, DATE '1974-08-28', DATE '1979-11-20'),
  ('91000035', 34987, DATE '1997-01-13', NULL),
  ('91000036', 1102, DATE '1982-07-14', NULL),
  ('91000037', 3353, DATE '1995-05-04', DATE '1999-04-17'),
  ('91000038', 3434, DATE '1995-01-14', NULL),
  ('91000039', 33501, DATE '1976-12-12', DATE '2022-08-30'),
  ('91000040', 900004, DATE '2011-06-28', DATE '2022-09-02'),
  ('91000041', 127, DATE '1959-07-21', DATE '1980-11-19'),
  ('91000042', 900006, DATE '1948-03-09', DATE '1962-11-17'),
  ('91000043', 1068104, DATE '2009-02-01', NULL),
  ('91000044', 10, DATE '2014-12-06', NULL),
  ('91000045', 404007, DATE '2014-09-19', DATE '2019-05-13'),
  ('91000046', 364, DATE '1979-07-13', NULL),
  ('91000047', 23, DATE '2001-06-08', NULL),
  ('91000048', 9708, DATE '2018-08-03', NULL),
  ('91000049', 1011324, DATE '2002-08-24', DATE '2009-11-20'),
  ('91000050', 3354, DATE '2004-05-09', NULL),
  ('91000051', 175, DATE '1993-11-08', DATE '2014-07-17'),
  ('91000052', 124321, DATE '2000-02-19', DATE '2019-09-25'),
  ('91000053', 362, DATE '1991-09-07', NULL),
  ('91000054', 3357, DATE '1961-04-15', DATE '1978-01-22'),
  ('91000055', 100124, DATE '2017-10-29', DATE '2022-12-31'),
  ('91000056', 361, DATE '1950-02-11', DATE '1962-09-21'),
  ('91000057', 6, DATE '1995-08-28', DATE '1999-02-08'),
  ('91000058', 421001, DATE '2022-12-09', NULL),
  ('91000059', 872789, DATE '1977-01-19', NULL),
  ('91000060', 363, DATE '2011-01-06', NULL),
  ('91000061', 32432, DATE '2002-07-15', NULL),
  ('91000062', 1108, DATE '2006-10-30', DATE '2012-07-18'),
  ('91000063', 134324, DATE '2003-11-27', NULL),
  ('91000064', 404004, DATE '2015-11-27', NULL),
  ('91000065', 900009, DATE '1965-12-13', NULL),
  ('91000066', 1011328, DATE '2010-10-18', DATE '2013-09-25'),
  ('91000067', 24301, DATE '1982-03-10', DATE '1983-06-22'),
  ('91000068', 1344441, DATE '2007-07-14', DATE '2009-08-10'),
  ('91000069', 100127, DATE '2008-06-21', DATE '2010-02-03'),
  ('91000070', 1, DATE '1989-12-11', DATE '2016-06-04'),
  ('91000071', 404009, DATE '1988-01-18', NULL),
  ('91000072', 3352, DATE '1991-05-26', NULL),
  ('91000073', 33511, DATE '1974-03-08', NULL),
  ('91000074', 1105, DATE '1987-09-27', DATE '1995-12-27'),
  ('91000075', 404003, DATE '2017-02-23', NULL),
  ('91000076', 33514, DATE '2014-05-18', NULL),
  ('91000077', 9902, DATE '1984-10-15', NULL),
  ('91000078', 421002, DATE '1985-07-17', DATE '2009-08-24'),
  ('91000079', 33, DATE '1949-05-09', DATE '1979-11-02'),
  ('91000080', 1104, DATE '2012-11-23', DATE '2015-06-27'),
  ('91000081', 24300, DATE '1989-11-02', DATE '2010-10-29'),
  ('91000082', 128, DATE '2001-01-24', NULL),
  ('91000083', 3355, DATE '1971-04-30', DATE '2006-08-10'),
  ('91000084', 1039356, DATE '2000-09-27', DATE '2019-09-17'),
  ('91000085', 33512, DATE '1977-01-02', DATE '2018-07-25'),
  ('91000086', 9701, DATE '2006-01-22', NULL),
  ('91000087', 4, DATE '1997-11-21', NULL),
  ('91000088', 102030, DATE '1988-03-01', NULL),
  ('91000089', 3359, DATE '1990-09-20', DATE '2013-03-14'),
  ('91000090', 404012, DATE '2001-01-09', NULL),
  ('91000091', 33504, DATE '1976-10-05', DATE '2013-02-13'),
  ('91000092', 9, DATE '1997-11-18', NULL),
  ('91000093', 1324, DATE '1990-03-19', DATE '1990-10-24'),
  ('91000094', 3351, DATE '1977-01-28', NULL),
  ('91000095', 213432, DATE '2006-03-22', NULL),
  ('91000096', 33510, DATE '1995-08-29', DATE '2012-07-02'),
  ('91000097', 1011321, DATE '2004-06-22', DATE '2020-07-31'),
  ('91000098', 33503, DATE '1972-05-09', NULL),
  ('91000099', 108, DATE '1995-06-01', DATE '2013-01-23'),
  ('91000100', 361, DATE '1997-07-30', NULL),
  ('91000101', 3670, DATE '2006-10-03', DATE '2023-08-29'),
  ('91000102', 98676, DATE '1996-08-05', DATE '2002-11-26'),
  ('91000103', 7, DATE '2012-10-24', NULL),
  ('91000104', 900003, DATE '2000-04-17', NULL),
  ('91000105', 900006, DATE '1968-01-20', DATE '2023-03-13'),
  ('91000106', 366, DATE '2007-11-13', NULL),
  ('91000107', 900002, DATE '1984-07-21', DATE '1990-01-09'),
  ('91000108', 7895, DATE '2020-02-22', NULL),
  ('91000109', 33505, DATE '2005-04-25', DATE '2006-02-26'),
  ('91000110', 33508, DATE '2025-02-05', DATE '2026-05-11'),
  ('91000111', 3353, DATE '2004-05-10', NULL),
  ('91000112', 1211340, DATE '2019-02-14', NULL),
  ('91000113', 9822, DATE '1966-04-27', DATE '1982-07-01'),
  ('91000114', 900002, DATE '2000-01-10', DATE '2000-11-29'),
  ('91000115', 24301, DATE '1989-02-02', DATE '1991-11-21'),
  ('91000116', 1344441, DATE '2010-03-09', NULL),
  ('91000117', 1105, DATE '2001-03-20', NULL),
  ('91000118', 3357, DATE '1980-07-22', DATE '1988-03-14'),
  ('91000119', 33510, DATE '2014-06-29', DATE '2015-06-07'),
  ('91000120', 9903, DATE '2003-09-26', DATE '2007-09-11'),
  ('91000121', 33510, DATE '2021-08-01', DATE '2024-11-25'),
  ('91000122', 703, DATE '2002-07-06', DATE '2007-04-05'),
  ('91000123', 9707, DATE '2005-06-03', DATE '2008-09-30'),
  ('91000124', 110, DATE '2004-06-01', DATE '2011-01-15'),
  ('91000125', 9903, DATE '2012-04-08', NULL),
  ('91000126', 110, DATE '2011-02-22', DATE '2015-07-11'),
  ('91000127', 404010, DATE '2009-12-21', DATE '2014-07-14'),
  ('91000128', 1104, DATE '2021-11-28', NULL),
  ('91000129', 9707, DATE '2009-06-04', DATE '2009-09-22'),
  ('91000130', 1109, DATE '2024-01-20', NULL),
  ('91000131', 231243, DATE '2009-09-08', NULL),
  ('91000132', 1108, DATE '2022-03-22', DATE '2025-04-07'),
  ('91000133', 33504, DATE '2014-07-16', DATE '2019-05-22'),
  ('91000134', 33, DATE '1991-06-12', DATE '2013-02-11'),
  ('91000135', 1106, DATE '1999-11-04', NULL),
  ('91000136', 9704, DATE '2007-01-15', DATE '2012-10-07'),
  ('91000137', 33502, DATE '1966-02-09', DATE '1994-07-10'),
  ('91000138', 101010, DATE '2016-12-22', NULL),
  ('91000139', 33506, DATE '1989-02-07', DATE '2022-07-18'),
  ('91000140', 127, DATE '2020-05-15', DATE '2022-07-09'),
  ('91000141', 100127, DATE '2015-08-16', DATE '2019-05-20'),
  ('91000142', 174, DATE '2008-03-03', DATE '2017-10-29'),
  ('91000143', 110, DATE '2015-09-28', DATE '2017-04-19'),
  ('91000144', 9707, DATE '2018-11-05', NULL),
  ('91000145', 900002, DATE '2006-05-06', DATE '2025-07-22'),
  ('91000146', 4042, DATE '1975-03-02', NULL),
  ('91000147', 1011328, DATE '2015-06-07', NULL),
  ('91000148', 3357, DATE '2004-05-03', NULL),
  ('91000149', 108, DATE '2019-06-22', NULL);

INSERT INTO adres (id_osoby, data_poczatku, data_konca, ulica, nr_domu, nr_mieszkania, kod_pocztowy, miejscowosc) VALUES
  (33, DATE '1987-09-20', DATE '1994-07-16', 'Milosza', '451', '112', '01-987', 'Warszawa'),
  (421001, DATE '1929-05-05', DATE '1939-10-25', 'Sloneczna', '55', '4', '00-950', 'Warszawa'),
  (421002, DATE '1984-10-20', DATE '2014-05-04', 'Miodowa', '56', '6', '00-950', 'Warszawa'),
  (8273, DATE '1984-12-28', DATE '1985-06-17', 'Polna', '5', '6', '25-001', 'Kielce'),
  (421003, DATE '1992-01-23', DATE '1999-06-02', 'Pogodna', '1', NULL, '40-001', 'Katowice'),
  (421003, DATE '2012-07-28', DATE '2016-06-25', 'Pogodna', '1', NULL, '40-001', 'Katowice'),
  (404003, DATE '1968-06-28', DATE '1987-07-16', 'Mala', '934', '2/13', '00-565', 'Warszawa'),
  (9701, DATE '1985-02-27', NULL, 'Sloneczna', '55', '4', '00-950', 'Warszawa'),
  (9702, DATE '1987-03-18', DATE '1987-06-02', 'Brzozowa', '53', '6', '00-930', 'Warszawa'),
  (9704, DATE '1967-05-01', DATE '1990-01-13', 'Sloneczna', '55', '4', '00-950', 'Warszawa'),
  (9703, DATE '1974-07-22', DATE '1980-09-04', 'Brzozowa', '53', '6', '00-930', 'Warszawa'),
  (9704, DATE '2011-06-13', NULL, 'Sloneczna', '55', '4', '00-950', 'Warszawa'),
  (9703, DATE '1992-04-02', DATE '2003-12-03', 'Brzozowa', '53', '6', '00-930', 'Warszawa'),
  (9705, DATE '1980-11-15', NULL, 'Lipowa', '2', '3', '40-001', 'Katowice'),
  (9706, DATE '1975-08-20', DATE '1979-01-16', 'Lipowa', '2', '3', '40-001', 'Katowice'),
  (9707, DATE '1970-09-06', DATE '1991-10-08', 'Sloneczna', '55', '4', '00-950', 'Warszawa'),
  (9706, DATE '1996-12-30', DATE '1997-08-31', 'Sloneczna', '55', '4', '00-950', 'Warszawa'),
  (9708, DATE '1991-02-17', DATE '2002-07-20', 'Sloneczna', '55', '4', '00-950', 'Warszawa'),
  (8273, DATE '1990-05-09', DATE '1994-03-16', 'Lesna', '12', '4', '01-100', 'Warszawa'),
  (900001, DATE '1989-11-20', DATE '1999-08-05', 'Wiosenna', '8', '2', '02-100', 'Warszawa'),
  (404011, DATE '2017-03-12', DATE '2023-06-16', 'Wiosenna', '8', '2', '02-100', 'Warszawa'),
  (900010, DATE '1986-04-02', DATE '1987-11-15', 'Ogrodowa', '15', '7', '02-200', 'Warszawa'),
  (900010, DATE '1997-06-28', DATE '2004-02-14', 'Morska', '20', '3', '80-001', 'Gdansk'),
  (900011, DATE '1980-04-19', DATE '1999-06-08', 'Ogrodowa', '15', '7', '02-200', 'Warszawa'),
  (900011, DATE '2006-05-17', NULL, 'Morska', '20', '3', '80-001', 'Gdansk'),
  (900012, DATE '2013-01-28', DATE '2013-03-30', 'Ogrodowa', '15', '7', '02-200', 'Warszawa'),
  (900012, DATE '2024-09-17', DATE '2026-01-24', 'Morska', '20', '3', '80-001', 'Gdansk'),
  (900013, DATE '2018-04-16', DATE '2020-09-06', 'Ogrodowa', '15', '7', '02-200', 'Warszawa'),
  (900013, DATE '2023-03-17', DATE '2023-06-27', 'Morska', '20', '3', '80-001', 'Gdansk'),
  (102031, DATE '1995-06-19', DATE '2010-04-03', 'Wiosenna', '27', '8', '25-001', 'Kielce'),
  (421003, DATE '2022-09-20', DATE '2026-01-26', 'Lesna', '90', '39', '40-001', 'Katowice'),
  (1112, DATE '2001-10-30', NULL, 'Wiosenna', '145', NULL, '60-001', 'Poznan'),
  (3350, DATE '1956-03-01', NULL, 'Miodowa', '9', '74', '50-001', 'Wroclaw'),
  (33500, DATE '1932-03-14', DATE '1942-01-13', 'Wiosenna', '55', '2', '25-001', 'Kielce'),
  (100126, DATE '2006-12-16', DATE '2008-02-17', 'Wiosenna', '3', '41', '50-001', 'Wroclaw'),
  (100127, DATE '1996-10-15', DATE '2010-06-21', 'Wiosenna', '33', '6', '90-001', 'Lodz'),
  (9706, DATE '1998-09-07', DATE '2009-10-03', 'Miodowa', '17', NULL, '50-001', 'Wroclaw'),
  (900005, DATE '1962-03-30', DATE '2004-05-29', 'Polna', '80', NULL, '90-001', 'Lodz'),
  (3362, DATE '1996-01-23', NULL, 'Wiosenna', '40', '48', '02-200', 'Warszawa'),
  (10203040, DATE '2009-03-14', NULL, 'Miodowa', '67', '45', '50-001', 'Wroclaw'),
  (1, DATE '1976-03-08', DATE '1990-02-28', 'Polna', '137', '1', '02-200', 'Warszawa'),
  (900001, DATE '2005-03-27', NULL, 'Pogodna', '94', '29', '25-001', 'Kielce'),
  (2, DATE '1984-10-12', NULL, 'Morska', '118', '56', '80-001', 'Gdansk'),
  (1105, DATE '1979-06-11', DATE '2025-03-18', 'Wiosenna', '129', '55', '40-001', 'Katowice'),
  (404006, DATE '2015-01-03', NULL, 'Lipowa', '130', NULL, '90-001', 'Lodz'),
  (33509, DATE '1996-03-15', DATE '2019-07-20', 'Ogrodowa', '74', '70', '60-001', 'Poznan'),
  (366, DATE '1976-10-01', DATE '1991-05-08', 'Brzozowa', '134', '2', '30-001', 'Krakow'),
  (9707, DATE '2006-12-28', NULL, 'Lipowa', '135', '70', '02-200', 'Warszawa'),
  (3434, DATE '1992-03-18', DATE '2001-04-08', 'Brzozowa', '91', '37', '30-001', 'Krakow'),
  (1106, DATE '1969-01-14', DATE '2022-09-28', 'Brzozowa', '145', '14', '02-200', 'Warszawa'),
  (900013, DATE '2024-06-30', DATE '2024-10-21', 'Miodowa', '113', '55', '40-001', 'Katowice'),
  (128, DATE '1983-07-11', NULL, 'Ogrodowa', '56', '7', '30-001', 'Krakow'),
  (702, DATE '1993-07-12', DATE '2020-06-28', 'Wiosenna', '5', NULL, '60-001', 'Poznan'),
  (1103, DATE '1970-12-11', DATE '2019-12-08', 'Morska', '28', '48', '80-001', 'Gdansk'),
  (24301, DATE '1970-07-04', NULL, 'Ogrodowa', '149', '73', '50-001', 'Wroclaw'),
  (404003, DATE '1989-01-24', DATE '2004-07-23', 'Miodowa', '83', '65', '40-001', 'Katowice'),
  (421001, DATE '1972-02-16', NULL, 'Wiosenna', '90', '14', '60-001', 'Poznan'),
  (33506, DATE '1972-07-14', DATE '1985-10-05', 'Polna', '101', '5', '60-001', 'Poznan'),
  (1123244, DATE '2014-09-29', DATE '2015-06-07', 'Lesna', '33', NULL, '50-001', 'Wroclaw'),
  (1211340, DATE '1997-12-22', NULL, 'Wiosenna', '145', '9', '90-001', 'Lodz'),
  (9702, DATE '1990-07-24', DATE '1994-12-04', 'Pogodna', '130', '17', '50-001', 'Wroclaw'),
  (7, DATE '1993-09-27', DATE '1995-12-31', 'Sloneczna', '24', NULL, '30-001', 'Krakow'),
  (24300, DATE '1966-05-04', DATE '1981-04-02', 'Miodowa', '46', '78', '40-001', 'Katowice'),
  (900010, DATE '2005-03-04', NULL, 'Wiosenna', '11', NULL, '90-001', 'Lodz'),
  (872789, DATE '1943-07-30', NULL, 'Wiosenna', '25', '29', '02-200', 'Warszawa'),
  (33511, DATE '1992-06-03', NULL, 'Wiosenna', '95', '47', '30-001', 'Krakow'),
  (174717, DATE '1967-01-08', DATE '1971-05-16', 'Sloneczna', '120', '78', '40-001', 'Katowice'),
  (175, DATE '1977-09-20', DATE '1994-09-22', 'Morska', '51', '53', '30-001', 'Krakow'),
  (1990106, DATE '1980-05-19', NULL, 'Ogrodowa', '82', NULL, '80-001', 'Gdansk'),
  (33507, DATE '1951-11-19', DATE '1953-08-04', 'Wiosenna', '45', '33', '40-001', 'Katowice'),
  (33502, DATE '1952-01-13', DATE '2016-02-26', 'Morska', '12', NULL, '50-001', 'Wroclaw'),
  (900009, DATE '1967-10-18', NULL, 'Sloneczna', '44', '78', '40-001', 'Katowice'),
  (33505, DATE '2001-11-18', NULL, 'Wiosenna', '78', '67', '90-001', 'Lodz'),
  (9710, DATE '1977-05-31', NULL, 'Ogrodowa', '33', '61', '50-001', 'Wroclaw'),
  (33, DATE '2003-11-01', NULL, 'Pogodna', '92', '50', '60-001', 'Poznan'),
  (900002, DATE '2009-12-20', DATE '2018-07-22', 'Brzozowa', '56', '62', '30-001', 'Krakow'),
  (107, DATE '1985-10-30', DATE '2010-02-02', 'Lesna', '72', '9', '60-001', 'Poznan'),
  (34987, DATE '2003-07-28', DATE '2022-03-09', 'Miodowa', '53', NULL, '25-001', 'Kielce'),
  (3352, DATE '1951-02-05', DATE '2002-03-07', 'Pogodna', '78', '59', '25-001', 'Kielce'),
  (365, DATE '1984-01-23', DATE '1992-05-21', 'Morska', '144', NULL, '40-001', 'Katowice'),
  (1109, DATE '2019-09-21', NULL, 'Sloneczna', '99', '67', '60-001', 'Poznan'),
  (1515, DATE '2001-02-14', DATE '2024-07-18', 'Lesna', '99', '19', '80-001', 'Gdansk'),
  (102030, DATE '1968-02-11', DATE '2019-09-23', 'Pogodna', '86', '51', '02-200', 'Warszawa'),
  (109, DATE '1980-05-20', DATE '1980-08-12', 'Ogrodowa', '26', '39', '40-001', 'Katowice'),
  (124321, DATE '1982-08-02', DATE '2007-07-09', 'Sloneczna', '141', NULL, '30-001', 'Krakow'),
  (900007, DATE '1933-11-26', NULL, 'Pogodna', '75', '57', '30-001', 'Krakow'),
  (9709, DATE '1994-09-21', NULL, 'Polna', '82', '78', '25-001', 'Kielce'),
  (1093786, DATE '2001-11-04', DATE '2025-01-26', 'Wiosenna', '32', NULL, '02-200', 'Warszawa'),
  (1234, DATE '1985-02-23', NULL, 'Lipowa', '115', NULL, '02-200', 'Warszawa'),
  (5, DATE '1994-01-03', NULL, 'Lesna', '52', '34', '60-001', 'Poznan'),
  (33501, DATE '1925-09-14', DATE '1971-12-20', 'Sloneczna', '26', NULL, '90-001', 'Lodz'),
  (3356, DATE '1953-11-03', NULL, 'Morska', '56', NULL, '90-001', 'Lodz'),
  (9824, DATE '1958-05-03', DATE '1960-06-04', 'Lesna', '1', '41', '02-200', 'Warszawa'),
  (9708, DATE '2009-07-12', DATE '2021-01-14', 'Pogodna', '16', '45', '90-001', 'Lodz'),
  (9903, DATE '1970-02-16', NULL, 'Ogrodowa', '29', '10', '02-200', 'Warszawa'),
  (9822, DATE '1959-07-23', NULL, 'Lesna', '52', '22', '02-200', 'Warszawa'),
  (33512, DATE '1957-12-14', NULL, 'Sloneczna', '29', '68', '40-001', 'Katowice'),
  (19, DATE '1985-05-02', NULL, 'Miodowa', '138', '57', '40-001', 'Katowice'),
  (9703, DATE '2007-07-08', DATE '2019-05-12', 'Pogodna', '137', '10', '25-001', 'Kielce'),
  (3355, DATE '1931-09-04', NULL, 'Polna', '43', '4', '90-001', 'Lodz'),
  (9904, DATE '1995-09-22', NULL, 'Pogodna', '54', '15', '40-001', 'Katowice'),
  (3357, DATE '2012-01-12', DATE '2023-04-18', 'Pogodna', '15', NULL, '90-001', 'Lodz'),
  (125, DATE '1998-06-30', NULL, 'Polna', '107', '66', '30-001', 'Krakow'),
  (8273, DATE '1998-11-07', DATE '1998-12-30', 'Lipowa', '63', NULL, '40-001', 'Katowice'),
  (23, DATE '1991-01-08', NULL, 'Ogrodowa', '39', '21', '30-001', 'Krakow'),
  (3361, DATE '1998-06-13', NULL, 'Lesna', '145', '33', '02-200', 'Warszawa'),
  (9712, DATE '1975-09-27', DATE '1978-11-23', 'Sloneczna', '138', NULL, '80-001', 'Gdansk'),
  (33513, DATE '1997-12-19', NULL, 'Pogodna', '88', '80', '80-001', 'Gdansk'),
  (123, DATE '1982-08-18', DATE '1998-11-19', 'Brzozowa', '137', '35', '30-001', 'Krakow'),
  (124321, DATE '2012-04-15', DATE '2021-07-02', 'Polna', '54', '64', '25-001', 'Kielce'),
  (127, DATE '1997-09-07', NULL, 'Morska', '116', '32', '60-001', 'Poznan'),
  (33506, DATE '1991-06-28', DATE '2003-08-11', 'Lipowa', '96', '21', '02-200', 'Warszawa'),
  (1007, DATE '1994-03-07', DATE '1995-12-14', 'Polna', '88', '77', '02-200', 'Warszawa'),
  (33500, DATE '1943-06-18', NULL, 'Morska', '57', '35', '02-200', 'Warszawa'),
  (9706, DATE '2013-04-29', NULL, 'Lipowa', '54', '74', '50-001', 'Wroclaw'),
  (362, DATE '1944-06-16', DATE '1988-12-22', 'Pogodna', '96', '61', '80-001', 'Gdansk'),
  (366, DATE '2008-11-15', NULL, 'Sloneczna', '137', '46', '30-001', 'Krakow'),
  (362, DATE '1997-03-12', NULL, 'Sloneczna', '63', '55', '25-001', 'Kielce'),
  (9702, DATE '2001-08-24', NULL, 'Lesna', '65', NULL, '50-001', 'Wroclaw'),
  (8273, DATE '2008-05-22', NULL, 'Lesna', '53', '21', '02-200', 'Warszawa'),
  (1104, DATE '2015-10-31', DATE '2017-08-11', 'Polna', '74', NULL, '02-200', 'Warszawa'),
  (111, DATE '1961-12-15', NULL, 'Pogodna', '17', '67', '25-001', 'Kielce'),
  (33507, DATE '1999-10-16', NULL, 'Brzozowa', '150', NULL, '50-001', 'Wroclaw'),
  (3, DATE '1975-09-25', DATE '2025-06-05', 'Lipowa', '113', NULL, '30-001', 'Krakow'),
  (123, DATE '2003-08-29', NULL, 'Wiosenna', '132', '24', '80-001', 'Gdansk'),
  (1, DATE '2010-02-02', DATE '2021-01-03', 'Brzozowa', '28', '76', '25-001', 'Kielce'),
  (1007, DATE '1999-02-19', NULL, 'Sloneczna', '18', NULL, '90-001', 'Lodz'),
  (9824, DATE '1991-11-29', DATE '2008-08-29', 'Miodowa', '45', '54', '25-001', 'Kielce'),
  (24300, DATE '1986-07-19', NULL, 'Lipowa', '100', '31', '50-001', 'Wroclaw');

INSERT INTO malzenstwo (id_zony, id_meza, data_poczatku, data_konca) VALUES
  (404003, 8273, DATE '2021-01-03', NULL),
  (33504, 33, DATE '1968-05-26', DATE '1969-01-19'),
  (33504, 33, DATE '1998-08-06', DATE '1999-03-08'),
  (4042, 24300, DATE '1975-06-21', DATE '1981-07-28'),
  (3352, 1324, DATE '2021-03-14', NULL),
  (3358, 33511, DATE '1989-09-29', DATE '1996-01-24'),
  (33500, 33501, DATE '2021-06-14', NULL),
  (33502, 33505, DATE '1973-05-05', DATE '1973-11-04'),
  (33504, 33503, DATE '1976-01-14', DATE '1982-07-12'),
  (33510, 33506, DATE '2024-05-09', NULL),
  (33502, 33507, DATE '2023-02-08', NULL),
  (33512, 33511, DATE '2021-01-17', NULL),
  (33514, 33509, DATE '2015-05-02', DATE '2016-09-07'),
  (4042, 404004, DATE '1960-04-14', DATE '1962-12-14'),
  (404007, 404008, DATE '2024-04-18', NULL),
  (3350, 404012, DATE '2006-06-10', DATE '2013-04-26'),
  (3354, 3356, DATE '1988-10-08', DATE '1994-08-03'),
  (9702, 9701, DATE '1999-10-23', DATE '2005-08-28'),
  (9704, 9703, DATE '2018-03-26', DATE '2018-10-08'),
  (9704, 9703, DATE '1989-05-15', DATE '1990-11-10'),
  (9706, 9705, DATE '2013-09-24', DATE '2018-06-30'),
  (9706, 9707, DATE '2001-02-22', DATE '2007-02-10'),
  (9706, 9708, DATE '1994-01-14', DATE '1995-08-15'),
  (9710, 9709, DATE '2007-05-28', DATE '2008-04-20'),
  (9712, 9709, DATE '2017-12-10', DATE '2018-11-09'),
  (9712, 9709, DATE '2009-07-13', DATE '2016-12-14'),
  (900010, 900011, DATE '2020-07-14', NULL),
  (9712, 3355, DATE '1993-12-19', DATE '1995-04-18'),
  (9702, 3670, DATE '2017-12-06', DATE '2019-04-26'),
  (404009, 102030, DATE '2016-12-17', DATE '2018-05-08'),
  (3362, 98676, DATE '2005-09-25', DATE '2010-04-09'),
  (9824, 19, DATE '2016-09-12', DATE '2018-06-27'),
  (10, 404008, DATE '2016-07-22', DATE '2018-08-31'),
  (9901, 33503, DATE '2005-06-29', DATE '2009-12-30'),
  (362, 101010, DATE '2017-10-28', DATE '2019-01-30'),
  (9, 404010, DATE '2008-08-27', DATE '2014-11-18'),
  (1234, 900008, DATE '2016-07-05', DATE '2019-10-31'),
  (33500, 4, DATE '1992-10-11', DATE '1999-05-15'),
  (100127, 366, DATE '2011-11-08', DATE '2016-01-19'),
  (1105, 365, DATE '1995-04-24', DATE '2000-10-05'),
  (33514, 363, DATE '2005-11-09', DATE '2008-12-13'),
  (9822, 33, DATE '1987-06-21', DATE '1989-02-11'),
  (33502, 9904, DATE '1997-04-03', DATE '2004-02-17'),
  (9823, 111, DATE '2002-06-03', DATE '2007-01-22'),
  (1107, 2, DATE '1994-08-05', DATE '1996-09-04'),
  (404005, 421003, DATE '2018-08-23', DATE '2019-08-10'),
  (3364, 102031, DATE '2016-09-27', DATE '2018-08-27'),
  (3362, 3357, DATE '2010-05-18', DATE '2013-01-23'),
  (1103, 361, DATE '2018-12-16', DATE '2019-09-09'),
  (9712, 1123244, DATE '2004-03-07', DATE '2008-07-23'),
  (900003, 1032651, DATE '1992-05-30', DATE '1997-03-29'),
  (33514, 3434, DATE '2019-03-17', DATE '2019-12-16'),
  (1101, 3361, DATE '2006-10-08', DATE '2012-10-27'),
  (33514, 7, DATE '2001-05-03', DATE '2005-05-31'),
  (1234, 3355, DATE '2004-11-05', DATE '2008-10-13'),
  (900005, 421002, DATE '1996-10-31', DATE '2000-10-01'),
  (404005, 404006, DATE '2013-01-24', DATE '2017-07-16'),
  (404013, 1112, DATE '2018-01-26', DATE '2019-03-23'),
  (9903, 900004, DATE '1999-02-23', DATE '2004-07-22'),
  (9710, 404006, DATE '2018-03-06', DATE '2019-03-08'),
  (1107, 23, DATE '2008-01-13', DATE '2015-02-26'),
  (1103, 5, DATE '1994-03-17', DATE '2000-05-09'),
  (3362, 3353, DATE '2017-03-30', DATE '2019-11-06'),
  (1093786, 900008, DATE '1998-12-02', DATE '1999-11-02'),
  (9822, 33505, DATE '1980-03-01', DATE '1980-09-14'),
  (900007, 1032651, DATE '2003-10-14', DATE '2006-06-29'),
  (9712, 900002, DATE '2020-11-19', NULL),
  (364, 9708, DATE '2023-08-08', NULL),
  (33508, 702, DATE '2021-11-29', NULL),
  (110, 3351, DATE '2026-08-07', NULL),
  (1109, 134324, DATE '2020-12-26', NULL),
  (1234, 32432, DATE '2023-06-28', NULL),
  (1990106, 101010, DATE '2020-12-20', NULL),
  (1101, 1211340, DATE '2026-08-26', NULL),
  (404005, 538789, DATE '2021-07-12', NULL),
  (404009, 1106, DATE '2021-01-15', NULL),
  (1105, 5, DATE '2021-02-27', NULL),
  (900005, 98676, DATE '2020-12-15', NULL),
  (1107, 33505, DATE '2021-08-12', NULL),
  (213432, 404010, DATE '2025-09-25', NULL),
  (100126, 4041, DATE '2021-05-27', NULL),
  (9, 1112, DATE '2026-03-28', NULL),
  (9901, 421002, DATE '2023-08-03', NULL),
  (9702, 900006, DATE '2020-10-08', NULL),
  (1011321, 174717, DATE '2024-08-12', NULL),
  (33504, 1344441, DATE '2024-10-06', NULL),
  (3354, 1032651, DATE '2023-03-02', NULL),
  (9706, 9904, DATE '2026-03-04', NULL),
  (1093786, 1011324, DATE '2020-12-29', NULL),
  (9902, 10203040, DATE '2022-05-13', NULL),
  (108, 1102, DATE '2024-08-04', NULL),
  (100125, 9707, DATE '2022-02-04', NULL),
  (123, 900008, DATE '2021-05-11', NULL),
  (3362, 33503, DATE '2024-06-17', NULL),
  (3364, 128, DATE '2022-10-12', NULL),
  (9903, 703, DATE '2021-08-08', NULL),
  (9823, 366, DATE '2021-08-18', NULL);

COMMIT;