Календарь латвийских именин
База именин для латвийских имен. Формат довольно простой и грубый, но использовать можно. Поле `date` это дата в формате [m]mdd, `name` - это имя в латышском написании, а `simplename` - упрощенная версия имени, в которой длинные буквы продублированны, а смягченные заменены на их твердые аналоги. Дамп c MySQL 5.0 сервера.
SQL:
-
--
-
-- Table structure for table `angel_days`
-
--
-
-
CREATE TABLE `angel_days` (
-
`angel_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
-
`date` int(4) NOT NULL,
-
`name` varchar(80) NOT NULL,
-
`simplename` varchar(255) NOT NULL,
-
PRIMARY KEY (`angel_id`),
-
UNIQUE KEY `date` (`date`,`simplename`),
-
KEY `name` (`name`)
-
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=954 ;
-
-
--
-
-- Dumping data for table `angel_days`
-
--
-
-
INSERT INTO `angel_days` (`angel_id`, `date`, `name`, `simplename`) VALUES
-
(1, 101, 'Solvita', 'solvita'),
-
(2, 101, 'Laimnesis', 'laimnesis'),
-
(3, 101, 'Solvija', 'solvija'),
-
(4, 102, 'Indulis', 'indulis'),
-
(5, 102, 'Iva', 'iva'),
-
(6, 102, 'Ivis', 'ivis'),
-
(7, 102, 'Ivo', 'ivo'),
-
(8, 103, 'Ringolds', 'ringolds'),
-
(9, 103, 'Miervalda', 'miervalda'),
-
(10, 103, 'Miervaldis', 'miervaldis'),
-
(11, 104, 'Spodra', 'spodra'),
-
(12, 104, 'Ilva', 'ilva'),
-
(13, 105, 'Sīmanis', 'siimanis'),
-
(14, 105, 'Zintis', 'zintis'),
-
(15, 106, 'Spulga', 'spulga'),
-
(16, 106, 'Arnita', 'arnita'),
-
(17, 107, 'Rota', 'rota'),
-
(18, 107, 'Juliāns', 'juliaans'),
-
(19, 107, 'Zigmārs', 'zigmaars'),
-
(20, 107, 'Digmārs', 'digmaars'),
-
(21, 108, 'Ivanda', 'ivanda'),
-
(22, 108, 'Gatis', 'gatis'),
-
(23, 109, 'Aksels', 'aksels'),
-
(24, 109, 'Alta', 'alta'),
-
(25, 109, 'Kaspars', 'kaspars'),
-
(26, 110, 'Tatjana', 'tatjana'),
-
(27, 110, 'Dorisa', 'dorisa'),
-
(28, 111, 'Smaida', 'smaida'),
-
(29, 111, 'Franciska', 'franciska'),
-
(30, 112, 'Reina', 'reina'),
-
(31, 112, 'Reinholds', 'reinholds'),
-
(32, 112, 'Reinis', 'reinis'),
-
(33, 112, 'Renāts', 'renaats'),
-
(34, 113, 'Harijs', 'harijs'),
-
(35, 113, 'Aira', 'aira'),
-
(36, 113, 'Ērijs', 'eerijs'),
-
(37, 113, 'Ēris', 'eeris'),
-
(38, 114, 'Roberta', 'roberta'),
-
(39, 114, 'Roberts', 'roberts'),
-
(40, 114, 'Raitis', 'raitis'),
-
(41, 114, 'Raits', 'raits'),
-
(42, 115, 'Fēlikss', 'feelikss'),
-
(43, 115, 'Felicita', 'felicita'),
-
(44, 116, 'Lida', 'lida'),
-
(45, 116, 'Lidija', 'lidija'),
-
(46, 117, 'Tenis', 'tenis'),
-
(47, 117, 'Dravis', 'dravis'),
-
(48, 118, 'Antis', 'antis'),
-
(49, 118, 'Antons', 'antons'),
-
(50, 119, 'Alnis', 'alnis'),
-
(51, 119, 'Andulis', 'andulis'),
-
(52, 120, 'Aļģirds', 'aljgjirds'),
-
(53, 120, 'Orests', 'orests'),
-
(54, 120, 'Oļģerts', 'oljgjerts'),
-
(55, 120, 'Aļģis', 'aljgjis'),
-
(56, 121, 'Agne', 'agne'),
-
(57, 121, 'Agnese', 'agnese'),
-
(58, 121, 'Agnija', 'agnija'),
-
(59, 122, 'Austris', 'austris'),
-
(60, 123, 'Strauta', 'strauta'),
-
(61, 123, 'Grieta', 'grieta'),
-
(62, 124, 'Krišs', 'krishs'),
-
(63, 124, 'Eglons', 'eglons'),
-
(64, 124, 'Ksenija', 'ksenija'),
-
(65, 125, 'Sigurds', 'sigurds'),
-
(66, 125, 'Zigurds', 'zigurds'),
-
(67, 126, 'Agneta', 'agneta'),
-
(68, 126, 'Agnis', 'agnis'),
-
(69, 126, 'Ansis', 'ansis'),
-
(70, 127, 'Ildze', 'ildze'),
-
(71, 127, 'Ilze', 'ilze'),
-
(72, 127, 'Izolde', 'izolde'),
-
(73, 128, 'Spodris', 'spodris'),
-
(74, 128, 'Kārlis', 'kaarlis'),
-
(75, 129, 'Valērijs', 'valeerijs'),
-
(76, 129, 'Aivars', 'aivars'),
-
(77, 130, 'Tīna', 'tiina'),
-
(78, 130, 'Valentīna', 'valentiina'),
-
(79, 130, 'Pārsla', 'paarsla'),
-
(80, 131, 'Tekla', 'tekla'),
-
(81, 131, 'Violeta', 'violeta'),
-
(82, 201, 'Indars', 'indars'),
-
(83, 201, 'Indra', 'indra'),
-
(84, 201, 'Brigita', 'brigita'),
-
(85, 201, 'Indris', 'indris'),
-
(86, 202, 'Spīdola', 'spiidola'),
-
(87, 202, 'Sonora', 'sonora'),
-
(88, 203, 'Vida', 'vida'),
-
(89, 203, 'Ida', 'ida'),
-
(90, 203, 'Aīda', 'aiida'),
-
(91, 204, 'Veronika', 'veronika'),
-
(92, 204, 'Daila', 'daila'),
-
(93, 205, 'Selga', 'selga'),
-
(94, 205, 'Silga', 'silga'),
-
(95, 205, 'Sinilga', 'sinilga'),
-
(96, 205, 'Agate', 'agate'),
-
(97, 206, 'Dace', 'dace'),
-
(98, 206, 'Dārta', 'daarta'),
-
(99, 206, 'Dora', 'dora'),
-
(100, 207, 'Ričards', 'richards'),
-
(101, 207, 'Rihards', 'rihards'),
-
(102, 207, 'Nelda', 'nelda'),
-
(103, 208, 'Aldona', 'aldona'),
-
(104, 209, 'Simona', 'simona'),
-
(105, 209, 'Apolonija', 'apolonija'),
-
(106, 210, 'Paula', 'paula'),
-
(107, 210, 'Paulīne', 'pauliine'),
-
(108, 211, 'Laima', 'laima'),
-
(109, 211, 'Laimdota', 'laimdota'),
-
(110, 212, 'Līna', 'liina'),
-
(111, 212, 'Karlīna', 'karliina'),
-
(112, 213, 'Malda', 'malda'),
-
(113, 213, 'Melita', 'melita'),
-
(114, 214, 'Valentīns', 'valentiins'),
-
(115, 215, 'Olafs', 'olafs'),
-
(116, 215, 'Aloizs', 'aloizs'),
-
(117, 215, 'Alvils', 'alvils'),
-
(118, 215, 'Olavs', 'olavs'),
-
(119, 216, 'Jūlija', 'juulija'),
-
(120, 216, 'Dģuljeta', 'dgjuljeta'),
-
(121, 217, 'Konstance', 'konstance'),
-
(122, 217, 'Donats', 'donats'),
-
(123, 218, 'Kintija', 'kintija'),
-
(124, 218, 'Kora', 'kora'),
-
(125, 219, 'Zane', 'zane'),
-
(126, 219, 'Zuzanna', 'zuzanna'),
-
(127, 220, 'Smuidra', 'smuidra'),
-
(128, 220, 'Vitauts', 'vitauts'),
-
(129, 220, 'Smuidris', 'smuidris'),
-
(130, 221, 'Eleonora', 'eleonora'),
-
(131, 221, 'Ariadne', 'ariadne'),
-
(132, 222, 'Rigonda', 'rigonda'),
-
(133, 222, 'Adrians', 'adrians'),
-
(134, 222, 'Ērija', 'eerija'),
-
(135, 223, 'Haralds', 'haralds'),
-
(136, 223, 'Almants', 'almants'),
-
(137, 224, 'Diāna', 'diaana'),
-
(138, 224, 'Dina', 'dina'),
-
(139, 224, 'Dins', 'dins'),
-
(140, 225, 'Alma', 'alma'),
-
(141, 225, 'Annemarija', 'annemarija'),
-
(142, 226, 'Mētra', 'meetra'),
-
(143, 226, 'Evelīna', 'eveliina'),
-
(144, 226, 'Aurēlija', 'aureelija'),
-
(145, 227, 'Līva', 'liiva'),
-
(146, 227, 'Līvija', 'liivija'),
-
(147, 227, 'Andra', 'andra'),
-
(148, 228, 'Skaidrīte', 'skaidriite'),
-
(149, 228, 'Justs', 'justs'),
-
(150, 228, 'Skaidra', 'skaidra'),
-
(151, 301, 'Ilgvars', 'ilgvars'),
-
(152, 301, 'Ivars', 'ivars'),
-
(153, 302, 'Luīze', 'luiize'),
-
(154, 302, 'Laila', 'laila'),
-
(155, 302, 'Lavīze', 'laviize'),
-
(156, 303, 'Tālavs', 'taalavs'),
-
(157, 303, 'Tālis', 'taalis'),
-
(158, 303, 'Marts', 'marts'),
-
(159, 304, 'Alise', 'alise'),
-
(160, 304, 'Auce', 'auce'),
-
(161, 305, 'Aurora', 'aurora'),
-
(162, 305, 'Austra', 'austra'),
-
(163, 306, 'Vents', 'vents'),
-
(164, 306, 'Centis', 'centis'),
-
(165, 306, 'Gotfrīds', 'gotfriids'),
-
(166, 307, 'Ella', 'ella'),
-
(167, 307, 'Elmīra', 'elmiira'),
-
(168, 308, 'Marga', 'marga'),
-
(169, 308, 'Margita', 'margita'),
-
(170, 308, 'Dagmāra', 'dagmaara'),
-
(171, 309, 'Ēvalds', 'evalds'),
-
(172, 310, 'Silvija', 'silvija'),
-
(173, 310, 'Liliāna', 'liliaana'),
-
(174, 310, 'Laimrota', 'laimrota'),
-
(175, 311, 'Konstantīns', 'konstantiins'),
-
(176, 311, 'Agita', 'agita'),
-
(177, 312, 'Aija', 'aija'),
-
(178, 312, 'Aiva', 'aiva'),
-
(179, 312, 'Aivis', 'aivis'),
-
(180, 313, 'Ernests', 'ernests'),
-
(181, 313, 'Balvis', 'balvis'),
-
(182, 314, 'Matilde', 'matilde'),
-
(183, 314, 'Ulrika', 'ulrika'),
-
(184, 315, 'Imalda', 'imalda'),
-
(185, 315, 'Amalda', 'amalda'),
-
(186, 315, 'Amilda', 'amilda'),
-
(187, 316, 'Guntris', 'guntris'),
-
(188, 316, 'Guntars', 'guntars'),
-
(189, 316, 'Guntis', 'guntis'),
-
(190, 317, 'Ģertrūde', 'gertruude'),
-
(191, 317, 'Gerda', 'gerda'),
-
(192, 317, 'Gertrūde', 'gertruude'),
-
(193, 318, 'Ilona', 'ilona'),
-
(194, 318, 'Adelīna', 'adeliina'),
-
(195, 319, 'Jāzeps', 'jaazeps'),
-
(196, 320, 'Made', 'made'),
-
(197, 320, 'Irbe', 'irbe'),
-
(198, 321, 'Una', 'una'),
-
(199, 321, 'Unigunde', 'unigunde'),
-
(200, 321, 'Dzelme', 'dzelme'),
-
(201, 321, 'Benedikts', 'benedikts'),
-
(202, 322, 'Tamāra', 'tamaara'),
-
(203, 322, 'Dziedra', 'dziedra'),
-
(204, 323, 'Mirdza', 'mirdza'),
-
(205, 323, 'žanete', 'zhanete'),
-
(206, 323, 'žanna', 'zhanna'),
-
(207, 324, 'Kazimirs', 'kazimirs'),
-
(208, 324, 'Izidors', 'izidors'),
-
(209, 325, 'Māra', 'maara'),
-
(210, 325, 'Marita', 'marita'),
-
(211, 325, 'Mārīte', 'maariite'),
-
(212, 326, 'Eiģenija', 'eigjenija'),
-
(213, 326, 'ženija', 'zhenija'),
-
(214, 327, 'Tālrīts', 'taalriits'),
-
(215, 327, 'Gustavs', 'gustavs'),
-
(216, 327, 'Gusts', 'gusts'),
-
(217, 328, 'Ginta', 'ginta'),
-
(218, 328, 'Gunda', 'gunda'),
-
(219, 328, 'Gunta', 'gunta'),
-
(220, 329, 'Agija', 'agija'),
-
(221, 329, 'Aldonis', 'aldonis'),
-
(222, 330, 'Nanija', 'nanija'),
-
(223, 330, 'Ilgmārs', 'ilgmaars'),
-
(224, 330, 'Igmārs', 'igmaars'),
-
(225, 331, 'Gvido', 'gvido'),
-
(226, 331, 'Atvars', 'atvars'),
-
(227, 401, 'Dagne', 'dagne'),
-
(228, 401, 'Dagnis', 'dagnis'),
-
(229, 402, 'Imgarde', 'imgarde'),
-
(230, 402, 'Irmgarde', 'irmgarde'),
-
(231, 403, 'Daira', 'daira'),
-
(232, 403, 'Dairis', 'dairis'),
-
(233,
