This Might Be Useful

Календарь латвийских именин

База именин для латвийских имен. Формат довольно простой и грубый, но использовать можно. Поле `date` это дата в формате [m]mdd, `name` - это имя в латышском написании, а `simplename` - упрощенная версия имени, в которой длинные буквы продублированны, а смягченные заменены на их твердые аналоги. Дамп c MySQL 5.0 сервера.

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