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
be7fc5438c2f5fb388b7431c3d967ea959bc976c4bc81123a18dee68a61febaU2FsdGVkX19YpNhAFXGP3rMq5aRYKboCWapSSGuAem+MkbOCcYz2jNB0MwhuxtwTA8UBIQBaljSOreEQx5BfdubTSJR82JGEBEnX
7veu9hG3wN2KhGtGIh8AZGbPKgTe8ykE5/0QjONqLD7cxGRWMbcQX3d3FlbB9MOXxRX6HpK66yvu92/vaswEkvar060k0KsFoPCq
Ni+5gFXkGNallQYECG+5qkcwsuwJKvxbwR6w5lhQAvDv5C2FCFmC9JfHdT6ByzdnG0S92aC+jRW1T/6vGq+y/aLH02FJ7u1tso3w
rbc4jtQgOTfzoIr5gfPlcKeXttvDMvf7WwuKbjDKizDA2VKm3JMfQgf6vguwR/oQZ4ahmn6y8LYruvDmx4XL23MHdaff/6Vk99FQ
pNkiGXVSdS01jfaLGI0n+7FljzAyXCsbbxhE2xU+BodP1tmZONCsjS12/mXuUZxtLJug9O8+daflI/KNw8VhY4k8ILWmGFfN5aas
AomZP4RHAWVRznp5tUAaCrEURx4OSUqaL1W3Ji2+Ez22fc1j0EhWXUA8uktTFHDqRkGUiFo48YyGY8vhMIXmzP1qnotNvLLtec1/
D+BCJiimeSUEwqENk68os/A3Rh4lxOWU1153XHfIUlPAKOQBSlvTF/ErpCafum0IdTezrhBvHXN9sGMEf5obAEkOMDU0dKQz7lHD
vOl84UEJE2k80NGo8Z8SmmXduhMfkxNQyZ0BXXQB4BUh0VgprOAPL3cvqQ5/UIzOtnJOs785Zov9/VWZb4TBRt4/QZTzfne7YY3K
wx5RWQeyT0oHmxSRhtfqpRbFxN11R3mpN3INR0qWdC3h73UrM+TrPdzi+ZBhUiAY+z5uJuSRGCfLbbnMJQnmRddPWfnMAl9vevVn
9/qe/iuCDhPepwDHD0wChxtOA392wCMswZIFJ209UZM0JrAkM9GeUfdmOt6P/ETgFjj3Z/T7ZmB+8xdgnT5d98//JfQpysU9Q51r
fPeTXrJXmjB8H3dqa7BH0gKHa1FtZ7yjW5ZiCDwmQM12WmLhoRxBX5zjSuWVaaR6pRwyasd6cnjOq80AGil6gSjaP+n5X9hknWek
HSZ9GhcqDeexKsoPOft30/VWMeaGV6o22I9P5j2WH0nMr26sCZKDFn+cSCugw+wRSJA1KyNpjNZjKHZKbfgJWCyip7Opr4yZ5plZ
OwwcnJA8TpeE2TdhbZBgfT16S62fjAihZVZCR/K04kEDQOrLHb7M4LLZL4nNAgMknz7/Q20wd4r6sTovw1ol+ehzrXjjLe0ty8tq
GeN9Hj7m9g7ogo5VdFIAkMLbZ8neyV7mYb3FQPRPefI8uXB2G7RgLV6xGAHKgvcjToaKKeJUEZoWcOYSet8BBDcgXBampORUcnjA
Hyl5Utl6Ueoo2WzD2yQaA41/ic1eTRR7Usx+2lwyeiI0aW9sTUpX9ojsInTSxfaB+vxUdeNrarSUFmCuQlHQfl8d0cFAxp7TU3pY
VEyU6vnYWlB2Fv42UFkXbSpDr0cK90OsloXkMF6RW3sJolxer1z5AQJrKpr6fzuBliJ1HjjO3I4zdtnpYuGkVP+9P2oqv05+KkoK
EpQcPUpo8scsifond9JcjhQ5G6w6eCF+NC9WRL6ISye1c4qdtLRCqPdMMl2SQs1ZzJE7FUyVqO5X8+TDSll8BYHvefL5FsuAqLdA
D0FU9cyqh2g2x9JQ1UrB2/S/qmljtwwS7JWLsv/VpTMX85l2wmpLZO2sY3M1Wqv8vUdN/Zi3xrjxRmkU1E5Px+6wlhYG6F7RNV9V
ZUdzY6Kc0AB0xJyRRWTRwGny9ePN2or8uiO7CMxqh1CWvElh9yrd8OEnvEa6vvY9opM4G3UhjmuTVH0pFz9fwAtrNvT3ZkYF4G5X
c/MsHu+o+2QhdqgaPE1R+b67QOf+iPmPw8K83AmbXjj8739pR4cL/Ds022bwO+PqaMxEmh4SUETI8RbwDhKR/RnYOigA/dx1F1uK
QM8HHTp3Fx5Aruz1USZnxAZpLVsyQIGj+Wo6Q4at0sR9Tbq0OCyB9opCO1oMQFmUCZ3EoyY0AepsiMDPIOoDOHwFy0GhUEX7uGbF
jl0/6Cd15Dj8SZUfieFTDibWcDwx8hHq0YHHw9B7A8Ym4nVhaVkpexsPSVQ0r2RJnRywQSkYbQ8tOXaUm+OTVMLN1xaVX4V7nNVN
s1BUhX/HZ6xk86Djxb5EixeP6q45vEDKGKEX4NBuh3PacCCo0PcQIBQ2bMN9ZLgpxv23ma7vfk0zwIV4ct6YEXjzFkXrA/HwBvii
+5499sX6UvBzXlxC2RKVUWtWpGHBSHljq8Bb+ZC/PY16DtDPTKVR8GfRPtKHlUV0nRm7XjODfRHRZ0Brf9+0J55SANCJopc1n9X0
7YcHx4Og+EYmQyEq5jipj1Gcw6Sjtwqx9i6VsDazgb+Q2GxNF/cQuYO3RoRoqGFfPVCP/PLbdImxMvNfVFma/cioSivdaS1/Jjw8
pttih/8y21ruvaOhJYYjDUGk3wjXUP5p+emlc/7zPtn7WgsKYnyMVGLRjrJHSkNVjJXeM2vUW9W4IHdlDNp4xlSI1iy0HW/2TMJS
upeDrINimZWMrlgN/2u7xMz8S9A2lE8g+mvLymY+BHU0bl4VMb0QJlWbpN3Qqu8pkDJqOW9Y3GZF1zdgAAPCZ8egzIx7JC17somo
tJqxkIlRFnOAyRNF53GhdEzqKcAVYW31074dmeJnHCmxkIZCma5hhej6mYcNh1kS0oN7My417MBgT3Il1sVCK503PI9k4tTLkaZv
6d+EHD0tk8aA4fQXmPKx/+Csq+LlQU76gNaxf85DY4ApYg3+smLm2fD6BGivpRNIchYxP7iLoU6ZW7NPSJjelXPDv/8NLb5yX2Ve
BPxejQbSeRZrfRq0m9h/GXY42EItEfJF0JoZsMTpr8ZJYbhYIYDkFuEsSrFl0wgBiw0Jr7lCsexAAhll5HXuL58e2SPK4RoecZda
1E8/sYQXk1rDgMNcYfC5XfTIdgt8K4A+u1om7nHNsKaYkaSGkdi3CLNw2bVhDrsSQDslsT+NzaCrcdXA752UFZKOf7mrUovbWids
NqgLcLwF4rHN2e5+KRGzpnlJaaG0A/x0eDqJv1y4XrEO0+Sfr6yNllk6/WnAuUEKCGcUb8z1EZfUuvySs1giKBrmpzUh/gCPzZFw
quVOkOd3KGDwKFA5f6IwAFZyWNMpfObSOpCHbTfn3ssEFaI4vF7KWGPbeDWRB2nAOEpm+BKY6R5NwUT/sGzJGUVub7RnKdaRq/EL
pTCQgX6izizLSZqPmo/JV1MZtSfvwzlWIBZRizGqeJBVy2nwIgv1GOHe0IKbZey0P4YNHN+bEjyhNx9zQRHVtwlT0ovfomV+0mUQ
TL3aNZnwTyweWyJH7s9O9hXIRz7EZI+B1NrRwlcfQkSVbkb3C6A1+QEGKqEHYzEWhw/GWFEiKhvV1LGqxPWybFcF/qksaRztUY3l
NGQRbrBU40l5Airxz8dPH6556R373VkMUGun0rS7Ei1Q6VeXlnWPXHH5xHoH7C4dXNGItoqsLKpgn3Zccg+2mWUTX6h7tJtIp4HX
grYCfJxvcpvprDLUch+/2UOH7ttoXFzUnKpiSvv6uAQ4Sekr4/Nh2Iu7E6ClZzzJ/k9oZu1ynzqdrMUFXVUL8YNJghreLxryn+sb
xCzowmo5w2mpJONikMQ34Kx+fvPOTXbk1AnjRxNNRjzEmb5D1QPlpDOJ71Bm0wqyA2Sk5c0QMKF+YfDzNxEgWSUpxeox+fs4yzuk
HGCoDVlYhThc3FcXdcmNfxAJuUtbN6potgxUD1d4z7W+hEvpgCp3i7SoPkYZYDYJ9Wg8v46eUi6jkKS8sQlZcQ0FTGerOFA5hJSj
r6qIZ36oXIye4k5kTeuU2t4D7NRbeYkBPaUw/Nd3QGVNjhdNbhMIPqR4SwpWl5WDSjJi3OtMKqdmO4ZycNqyJAG1pLRzFrHiCyUn
24ETdWjUFSYw+pCtcmfM2AZLwVWm4SYRho2pu/JZ0k33zSHC98rYeKejqBvDoffbmOA79+2eUj76zGWRc7oQOQTBWatGgvwhr3dK
l+8e6pRgHhwmQPYpfwyMzqobC++YKfX1WerZJshyCPp/Svy6gHPWp6aXW7vhajeuLihuugabg5z+W7DEJj4hZYHwcGENWmNr0LpU
M1b8gq9FOCx55uoSEpc3Sz5Cc4ar0OHXU3A6Y8qDuBxYht0rCtomz78SZ+LKyxJu8v9RBPB60ViL/44P+7x9S0+bJZQ20KgYG4Ty
YoXTM57q+v+YhetWqANbzXKAMXRWtWJwuaKJYgKJ8Q9WRgry6PYwAyyO3FVAhoj4HNEiID3wd3C+HiIaoSHduRZabe1MJgRXITtM
JWYHlFAM0REDc405HJkEo+9KYfmszahqDe+TrYBK8JA0IdGhmobIWnW1r50aJfa6QitSTwQoPBOXLNP75oZiBz8cHnheBePWbAca
3E3NbcT+e4vmQ3DNzE/JM6ET/1dCQeS8S4QsE5I9uN049ZgpBR6uo08azbNi1QKQC6nj9G7tS1yc87XndjNqesVBHQkfJ4mAhX8k
xb9oE2vXg5Te3aUuQtiwipotp4y25sQWKzNDsMKtY/EMmoiCd2o5OOyDSOEal2670URzgrHqLyxqOD37RZoTwZSpNOT3aR2hQJ68
Zg4SeuICOOIgN4GhlofGHEKqQzdPRyit2Kq35tpw7i/jZmSR8DZoXvapsqUH/yhel8pWfEeAQob0UYj7+WH2SnZevXj/zFLGX8ra
H0HF42AhLPNvi05QX9vxhhIYZYf421/io18tBX3r5PFMtvN9IlCQm2D8BNdhoWJSdE5MpZNXXTziEVmKJniNUA==