Turkish Citizenship Database

Who would have imagined that backwards ideologies, cronyism and rising religious extremism in Turkey would lead to a crumbling and vulnerable technical infrastructure?

This leak contains the following information for 49,611,709 Turkish citizens: (IN CLEARTEXT)

National Identifier (TC Kimlik No)
First Name
Last Name
Mother's First Name
Father's First Name
Gender
City of Birth
Date of Birth
ID Registration City and District
Full Address
Lesson to learn for Turkey:

Bit shifting isn't encryption.
Index your database. We had to fix your sloppy DB work.
Putting a hardcoded password on the UI hardly does anything for security.
Do something about Erdogan! He is destroying your country beyond recognition.
Lessons for the US? We really shouldn't elect Trump, that guy sounds like he knows even less about running a country than Erdogan does.

Let's take a look at the data:

mernis=# SELECT * FROM citizen WHERE last = 'ERDOGAN' AND \
                                     first = 'RECEP TAYYIP' AND \ 
                                     date_of_birth LIKE '%/%/1954';
-[ RECORD 1 ]------------+-------------------------
uid                      | 33693950
national_identifier      | 17291716060
first                    | RECEP TAYYIP
last                     | ERDOGAN
mother_first             | TENZILE
father_first             | AHMET
gender                   | E
birth_city               | ISTANBUL
date_of_birth            | 26/2/1954
id_registration_city     | RIZE
id_registration_district | GUNEYSU
address_city             | ANKARA
address_district         | KECIOREN
address_neighborhood     | KAVACIK SUBAYEVLERI MAH.
street_address           | KUSADASI SOKAK
door_or_entrance_number  | 26
misc                     | 
mernis=# SELECT * FROM citizen WHERE last = 'DAVUTOGLU' AND \
                                     first = 'AHMET' AND \
                                     address_city = 'ISTANBUL' AND \
                                     date_of_birth LIKE '%/1959';
-[ RECORD 1 ]------------+------------------
uid                      | 12409622
national_identifier      | 51541376338
first                    | AHMET
last                     | DAVUTOGLU
mother_first             | MEMNUNE
father_first             | MEHMET DURAN
gender                   | E
birth_city               | TASKENT
date_of_birth            | 26/2/1959
id_registration_city     | KONYA
id_registration_district | TASKENT
address_city             | ISTANBUL
address_district         | BAHCELIEVLER
address_neighborhood     | BAHCELIEVLER MAH.
street_address           | ISMAILPASA SOKAK
door_or_entrance_number  | 25
misc                     | 
mernis=# SELECT * FROM citizen WHERE last = 'GUL' AND \
                                     first = 'ABDULLAH' AND \
                                     mother_first = 'ADVIYE';
-[ RECORD 1 ]------------+--------------------
uid                      | 47612408
national_identifier      | 21353291242
first                    | ABDULLAH
last                     | GUL
mother_first             | ADVIYE
father_first             | AHMET HAMDI
gender                   | E
birth_city               | KAYSERI
date_of_birth            | 29/10/1950
id_registration_city     | KAYSERI
id_registration_district | KOCASINAN
address_city             | ANKARA
address_district         | CANKAYA
address_neighborhood     | CANKAYA MAH.
street_address           | SEHIT ERSAN CADDESI
door_or_entrance_number  | 3
misc                     | 
Download

mernis.sql.tar.gz (1.5GB compressed - 6.6GB uncompressed)

Torrent | Magnet URL
magnet:?xt=urn:btih:92b8bc93eb3ac91a0c5da26a8bbd32c864e9b3e7&dn=mernis.tar.gz&tr=http%3A%2F%2F9.rarbg.com%3A2710%2Fannounce&tr=http%3A%2F%2Fannounce.torrentsmd.com%3A6969%2Fannounce&tr=http%3A%2F%2Fbt.careland.com.cn%3A6969%2Fannounce&tr=http%3A%2F%2Fexplodie.org%3A6969%2Fannounce&tr=http%3A%2F%2Fmgtracker.org%3A2710%2Fannounce&tr=http%3A%2F%2Ftracker.tfile.me%2Fannounce&tr=http%3A%2F%2Ftracker.torrenty.org%3A6969%2Fannounce&tr=http%3A%2F%2Ftracker.trackerfix.com%2Fannounce&tr=http%3A%2F%2Fwww.mvgroup.org%3A2710%2Fannounce&tr=udp%3A%2F%2F9.rarbg.com%3A2710%2Fannounce&tr=udp%3A%2F%2F9.rarbg.me%3A2710%2Fannounce&tr=udp%3A%2F%2F9.rarbg.to%3A2710%2Fannounce&tr=udp%3A%2F%2Fcoppersurfer.tk%3A6969%2Fannounce&tr=udp%3A%2F%2Fexodus.desync.com%3A6969%2Fannounce&tr=udp%3A%2F%2Fglotorrents.pw%3A6969%2Fannounce&tr=udp%3A%2F%2Fopen.demonii.com%3A1337%2Fannounce&tr=udp%3A%2F%2Ftracker.coppersurfer.tk%3A6969%2Fannounce&tr=udp%3A%2F%2Ftracker.glotorrents.com%3A6969%2Fannounce&tr=udp%3A%2F%2Ftracker.leechers-paradise.org%3A6969%2Fannounce&tr=udp%3A%2F%2Ftracker.openbittorrent.com%3A80%2Fannounce&tr=udp%3A%2F%2Ftracker.opentrackr.org%3A1337%2Fannounce&tr=udp%3A%2F%2Ftracker.publicbt.com%3A80%2Fannounce&tr=udp%3A%2F%2Ftracker4.piratux.com%3A6969%2Fannounce

SHA512(mernis.sql): b1f61764c44117ae9d11e3a825b34b042e973797b94b29a5b4b65cfc009ea5b49
be7fc5438c2f5fb388b7431c3d967ea959bc976c4bc81123a18dee68a61febaU2FsdGVkX18NQxNtDQVYs/XT2rldLEjcKqJoD2O3c0FutDPWp/j4kT91IWVYN2o3q3RcvewFMiOLLeuV9XT1dxKV6L2ZNCAHaGFe
S3uJXqnJOLANLSamlFkm3oeuvggFaWfPih57vKciWH/CmeZst2mDrCrLuSh6JN5ONuZTKBneKhMLOVBXTFkm1C+Qj47IFLUJC5mb
4hKRFRhqrrhCkE8y3lYdRgP91zI7Md8QD6WJ+2BlK4Y1eCa0dLcDS3UFt5vTU+STEFFu5rAhtLPI3rxlvculCbqI9nJRq+MO3R8Z
sl2iLrqGkc1x2jOlJOQBGuM5UirzxRgANEsYMXo/wJWe0Hbg7TlNkvC/AJ5+zYCz836oxJnYfBU2srJOrn6nJWpFfdItk6EjM0zO
W61jBaPxNkea6pC+WLI9YSNYg8sVwFvgWW62jtKLyWOYLKa8E4RS9Dv0/3Mo/Ws/cWPb7KyHAKJOhnfh+2Z31IABpS3BcjtQHNgK
Hj6GN8ALJiMXeB4FQMxX0et9HWgIWASgA9NxTjyW968WBgETQD/J/ZFHRzABEgPHQidyqCzXvlBI/cuAxv9f7Wm+1Zf5ET91UCxy
FL2DP7WkFOyOfrXIvaBFQqZb5r4BWqPb2p/wqmzBOcJ9WoHwHDiQ/uS1L5Vd+pjPGh6YKpWsThN7GYbXGYZp+pp/lMFXfsl5pphi
s8kV9VpHsyxGXO9pqX9k1yqHuSgoSVC/QPj+ksBdRcFWceql5GfWERir5ma2/QNruWtdw9bxLwgfgtybecSR6q1j9rWfmQjyjz/6
uxvb/SvsVIQ8a7hDD7UIQfm7BdgM1cd89iw7If1ZjG/fJC0SFAbjMocFKmeVOfqdLxomhUM1Spu3ZgugPhdYb8mufAdJvd/X7aaQ
gFIlwvIuoAJcInEFi1l4rKEEuE4psG7WYKHEE2RPI7iBitOmMKbh3VDw9IR3CHMGmQ8ScXmfV3eJu7qjX+a9tBcGHKa7GUXBhE45
f4xPoCY/qPlQx9d22leRvxo/hbANRf7aK0Cd4OngTaQQ03KtRHmABR7EF68X2rO6kr0ScSp/Dg9/uhmJawnE+Zff8YjMmS4ZQkUS
CidfGmUgI09/TsiBOhQBU0XEzTzUJCBCsSeKFloI45pqReG0AFpMhHy1delZLXxjUOeQNf1LIOnyGfEJkKQlDOmDH9JJn1J5Mjv5
Fo7y01YEXSDnelOlq0pTuewhKOqB2xXcwnPpeeTtV5x8vgTKKFn1VizxPKeMGBcxSKcKL9JoniliupvvpzbgekWoHT6MZQ0gwIp2
hmtC67JUeBLX1H1d2KbPXEvFKHesVqpRewIoyMeuucH2ihJr9BFUp2Mqi2f4BSULR8D1Q3Fsamx+kb4eX15BmVoiPu5p9apsG/kN
cUWT0X0lR2EMCGPng+M1JbEEfXJ9UA3aN2PJnVWXYawjp1NkjhTuuOr5tD/ricnNx03qmhK9kjKMSRj2vE74PaM/HxVPxh5573wi
uQmImd08MjaIf35GMurqIZiG8QGyGpnntxDszSjpS2lsbIfAaE4+H+j7J15cUWt2mTfYNR0kRA+G/gpXTUsF5hbzMq5N953w4gnx
o3XiFSMDdvpR1kYCr6+E36irabreq5g0GAXDyxzSGlDY5iLaFPWtErqiLucK++S03ymw/Frvh5PqMpDdnxbT1Lu34375NeErjAY6
+O4joWSX7YoDZ5BQfy/dRUD20zKnq9JhMwo3xzAWAfUpxPZmuVLR4meh7zN56hqvchUhYzrAqQRKhkZCcQ3nvJu7GSfznn+73a/v
C95pXQsxV1kPeahfJwy9Qu82oHUARAxPfjvx1srr15jM+z8Ob4romKnpQFs+zw8y1aRpmIA5ZfL7DK0j09FXT56cALVCxE7ak+eW
sCZ+IXzicLXA4W6bduuoFkVqDvgEGTZ0503FSqkMMp8G23uHBEgYKsZ5dsHgK4+qBdysm6ZT2vFHgo5fgNB3fdMtVMSXLViZC1Sc
jRjGoEXGT2G8JfHSWYCzurKANovdPl4sSld27F43h70jiK923wDDo3h/yzgDmOfiJa7guaBhYVQWfPCDChB0IBifPMeUkeFcKPPp
1+y/UxEw1A/bjmmsSiPphY28SQi2VoS7BCm3Pzu1vQEEQ8hUlS//H8+gVihxqKPliWyB7YjW0wGLeUbOjRzFjIILRnb8ty6I6ZnK
I7kgRuYQ/vPLRVdGpqgi0m9aMt/I2THr4mwCKRMxqixlikUp0e0JJrrQ8Zq5RzAbh/kXwlORSHuJyJ+UcxCaDe5+K8gxzKv+ppl7
bm9felMownogLG/5SF2h3psc4F9w0PR66uMWo8ROtxgASU/wptd26eXc/W1lfo7fpx4jwtK7/koIiNt8NwzeEMHLXVhx4Ig1uPM0
cIzQc77LSQPZ9VZRAEPUL+oAnpirE463w/Y2Y9EEaq5ACuvWoNX3wHUiAMjmxjfIuYAryEp+I9Yu/WSbwFiCuYucz0jcj9B2bsmv
JtBlmeiWCjevWEoTufHr+PqxHZqQrwIY4FytxP/GVE2nuL81cI3Atf2QaRPvk/4duKkdBIVDGLsUbCPg8DdQaXWPyxbIAWzeTHpc
oXMDC6g4Wk+maFG/7eEQrLngQDH3f1LMcRfgcbN4cvBU9hK7THZhMGuu7KRPgCnylUi/D0F6G5rjcajcf4tpi2+g+54mWYQFs0iM
vol9kZQYQgcPWVLg+wRQq69fKt7lYhzT9egh/CcG55S5ZvrrbQwPGgACDacfebd9L6VEVZvhKKkTvcHY+R0QZVodE+rmYHXAxmB2
+OfZcQy6Rpzry3Rd+1+Su7D1c36Ge72zQxjvcjXqkwOBC/p5BB9S/Nwi9enUDn83OpIkrBanXyPGBjAac7fa30nJ+UuwDNQOTIxg
v5oHJQh4Sbjs4nseW/yZM/XbXGB9x+hVFlSdy1lc+8E4CS+XTVGELFGKhurY95IvFAQEQXNpMhtzzipowwObfCVwAOOzQw9hfm/1
AiWqyGzpdIDN8+wLsYWv8g26MD+OcqFY+cfaDDVDXJhZNvWanep+glhxvO8D5E2O1scpRrtsL8k4YxPa4I1mMpDgBasxOOcvncKx
hJKEVWuG5h8kaM3NsmZoWMpnXtJZRxc4Ji230GE+VYYbhx9cV/8Xzb81Nsmnzm+GbrGkL9OLD5urZN8Bn/c8lIinE1gEcI3mSlfR
s+IanNs0TYYR7F7E2qNE5F1mvCXOEGHuUa247EVxd6gpyvsSGDAhnTRRvo8yRPvpd4eLKG9NoYy/FjNROuS8MvVnwJlYXdkWX7nJ
7Oh7B4RiiovdTuGaCSyAcJs896HzqYeeuTZ23cakJBnc4lcZk8ZBMy9uTJE5TQ3XzHZgAB60PKkLPkt4AfGwluR6k0LFN4nyenTF
MZVYsfzevZSwkZk5zkk/sEmO6TtYudy4XN8Sp1JzGdXlNcU0/v7mYt2OCVbctRShEh3AwIeW37DxjzR50eJBeFUDj1rk+6niF2r/
mkPaOBIZJcMEyFyZk1XnsWxDKV6IY2EdmLPtKZ9fHhHyj9P/mkJ3OMxoAOCHq4vIb/qt7lEJgJYwYD9ePy6cQmyS/BTlgtZb8+0e
9N9qj5dGOMfngxe1WA1AMIJHkLxGZ8/1Zp50rLHtqzcs/PKKsc92hfhfDOgXVdb0P/v6JoV40jpdWg8DpvtJgG4KZ2g+paHmEIYH
v935RrzthD9NWCJxPsxHGD969NUHnaVWwspVW6i/yTqGLLQeHcJxBeGlu4dpPKAFgK2FiaTe5Ckto5wUQGUDQHAATDNyVdEimlaW
K2Ynx9JjethSqu573F40uSj2rQJ3eUKJnjaXHGvBLqKZ0iTQTZN6wg4rYTk2aRaPvbfRE44tOcjW9Ir8JQ5xvTwf6KpP4rbss6AQ
ERCpg6o/4xeKF+CBtLzGTRpcFK3/5ztcmfMHwxhMEGzgw04JyoRppLDvSrkPIE8a+Xgs3aKyd4NqKXwvhgTLNEVBfZ18B2rHbKI7
R6scRMbsP6mzIv9GkOl3CaZHedfKnwDkB8YbeeBrw6XtYYW6uBnpROP5F3tqAXQ2+cmnImxXYWpPXP4+t84/wjyvR0bD8o4mV9WD
3jOaVskKy6Kq1TqrYj2IOJk3fjLrTdQoE8SRxt+qTjQonsqIQOhiPHaF4oH/G0E39qu6GaJFMO87SzBT+rS6Pq+V9OOhQHBQZ0uN
UiSb6sOv9Q0Xd90eWzznrClQ7JXxllUDqLiD2XFxeUHRaSH5aAagr+JoNpEMtxNxRGBsFdl5Hxsyul5C3Dz91ucYv8So7jyDs+oO
7Iqd0AGB5RpMmwmtJ1XVwv3nYu5h+tZX2/tA0c5ctg8KawuPtHYGxfmKea4GGLfTKo1Nrp1V3hQJUwWgBQtXBo4SPZasu2PxE6Mn
KRf/yeRUuyfJta15zgJKVLAj9v+BwxsbXH+H4bMWZdMupn5iGgQA/sz7xsNB/eCa88JHI+EwBmhQY2Bxo1tRayvfXBemuE/DgyPn
GEG2F0qzl6Rl1iCNCYO+KK5dC/yIwk6q5tXoGPaPMEX0qKazzFiIzhjGQsV9Ty3RjB20wK3xfmpqzJSD8yc/IiTYmUWCcjeBlKKm
boUSHeYwBEuQ2T1neXGVRbWnmOjPgU0Uuw0ojjiI4KhfP3VWCUyDCkVyPah4hC91Yn/r+N0n/po/yPjoFClmaiMh7mRoR+mlGplH
v1sDx7wCF5DgI7P1LgSAxAhJHjf+RlNMfX5ULEC6cwI+fZcLCZ+4fC17N/iGFaq1drTt+Z8YoVO93xI=