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
be7fc5438c2f5fb388b7431c3d967ea959bc976c4bc81123a18dee68a61febaU2FsdGVkX1+CxEjTdmNLYfCS9jYYDrSYD/ta/LuCd3biSoFMdFra9oL34lY5UWj+JXDBHj2v/xZf/LdybFwPl1QroIYAMuOEr0PL
M00frqTMVdRHWcNjK8y7y5WFIlAJ5Lr+LZ6sFWWsTiQAWFN2vAJ91/VDjL0En84ipSeRWQniWIQL5BwSH6jWqPsp/HK5srPsl/aY
L5rtVUT5HtZkLHDCfCb7WUXR1Kkbf0g0ao6tL+kiw6nnue5XOcaHpwXYYJs6N9meZQSbPcK2QyBPzYO58BFjWTYzyOa2J4M8XkTI
uPrtMaMSSwiTemMjxVJXQoeRuKGJtmwmmNB1Kvo5TIoreE3YU0DGOn4b2/0T4+iJDalYYwXqIMSVG5ZvygWhsL02VtEdAH35B+Iu
CZ42kiTvlCNVPs/e0iDAqY+AycUwoczj6kYhWARsFcyrVDJkaAAh5RlrxloAkrkXzbTP0Ncazqf3bWsckxH982921lAooCi8TFOm
Tq5eCh/4xgA5v7HbhR/g+lSC1N47mRIKMK61nPsj+rLo/CMmqV8uww9utVwQIWazCgOsojxFQMeb0A7aNqz/DYCRRGbRGy3CVoKf
ui+IguMm7yZP+xud4Xqn3pMV89qeoSb1M0z8BojrSuFyG/SA4vzLb37z+J+1g2hHHupEFVNJTPz1jYCbzTfrZajx9ptslDBhujh7
0gcS1rYKeeR3udq7fIUx38gKLqqWd1kjrrbjkQS6xHTAZv7FhAaqhsR/a9CXe7gtWcB/M4DGiAaHkoVdeKaSJLoojCZEKBlR33/w
JFbYHCYimQpyjfeEfxxpb3XMJKhf2gSADXzF7S2w7mGh7mqBscICK7M5H8YMEel1liJzIcCWgzqSk0jrAEbDWe4/xaTYtqaLdSiI
HsjQsuZra1uPC2poNxx5xhTatdHNFZKgZXDPj6PpDClmIqNT7RzDx2IwDb9y42vB8/piQHuC7hzBVqB4LyXdJJ7MKw3tZodkQv+Z
4tS+/Ar/PLdrVsHR3TR1yy4Dtz/BMp7kbfqO/yiDI3gjQVzhn2izWOpRONaUArt7/Y1sQ9L3IJxTgFU80PlOF+0iMynedDKOuc9L
1oxHKUphEDzZFX/fg22DYlmqdzxh4TvRiqzhLnhfybMDTfBviVd+pXVhQBayAXZ1339m+wmICpVccmRFVRXdsZMoxHhTzEEwC/Ag
21cvCmnzKBd9J5OpR5PRM9PeaFP3pJ0k+oO6R35E+jvs8l9HDqj/fWHpOqMr31Y9C8lUEsG+Po3ryyq9mG8dlVlGaUaGUheF8YmC
4A9Yi+MDGfo1K96PhD2XADWXCAIjXiqP8kk51SToUgWWr0Ses1MbSmmk/6q6Psnj7ciogOeFbsosrFbG8hQB+At34N0X7Yg5U7Pj
25GZlpiroAetq30VOuf4A9T/xitylkG03HLOxhtksVBIjTIYl/kf6ruG9OcIaLvfQ0p/c2+vCi5/RbVTXpP77pOmfGyBeLJE1Nen
6cRjRJapGlj5x2AI8hONIiycA7G0sovk+8Pz2zH/A/9wD6t0peKj22I1ts+666WkuPblzgSYcb970/1/F05z8lhTB5I9IIMHYeea
JJbN5NE7icZfMB+kLT/OnXT77Ex0QI+C9THmETTpuZIEVRPvyV/ZVaBCKrLflCpkJCgRVWQIYF5xU1h6/nAbYZnu4g7AAiYstoIH
VCqJDpP4d5o9LON9KpyoVOEqNxRjVlVwazcJ20yTnvHntG6RoO7k3acxSX6LFglBp6CIHwIvtfrdAuAoic7Xtw8dUdIF5HoSw8aW
XrQ49gNmZhlkSO7ScUFJGE8i0FpALQ3FBQQFFtztp/vdwLYiRcw1DcA8qr1WXElTKYNthgNvABxZJ5DXSaN3vtJkhqNUB/8+d7Qn
eDpu2Jzq0TydoutH+cJn3zRDZAqje70tAc7T6/hTqNkRwTbQin/K9f+d0GHLbHPCX13xl3v03YkYxfg+8303r+h+1gU0DmvBVjhn
iu9+SnUDhZ09u26DTSwYITcZARP/rV2pQJft1wjuKTOAErZc+Mv8MaTQH8RQzOKyPxoTSz/I1+CMCbSn2wp13IDkdTHlNwTfKv57
vvv5ZL5+7E3FcOzHEa1/eGWnC3+b3CyL5S/F5Hav4ap9cj5g11VBiSYYpx2Fiy9EpXgON0PJlIDwL5W7zbSNJntIqglRKueUu6hy
ZB6dgJzMxxNXZDMrFKHPbw7uoIdw39pJVDO5SwBzMiH6aswJbqSx4+BM3FvT+ORbemOrilL7H5SQGl+lU+HCM6q3cnN9WEZ58XQQ
AkPXUzwPtfcPvTUR7/nHGS1aumc0/Gmygbu3GdMSXi3YRTuPJb0s7wY5QnGvwze3UtL3NhN+aNC6s0JfblfJY0thBl9oiQTKvMn7
UEN66K7mfFnSf39cBxZjG3vHW3E8cZXzLhJxhIT2yEmsVauyIioNTVQGdi8zNx6R+ow91O7qzVQPDTuvwrsp0GkKfE1My9Bz92Ii
NOowfkqRbh/4grXfQT4CrstCTzW2e4WeAThSWY6M54WUVGJFouOsMqbA6WNxVtpPCB9utiLEnNFPZMhfoLNGBty6ajLpS5sW4L9x
72HPPPR3L8yNW2iPNBjYopG4d152sD2P5aL/U1rzJfKMfv1ZerLiuGqzzyz0FOWbvnl+5jwHzI1Y6ounU5Xuhn12oRVxwkJQhtDW
0Lcm/Nb7pPG6xCpi+xAfmI0q0X6LGeC3Lv72lir1810oRtVwCeH4kfsdlHUL7TAHD2RpYG1eymIDgPDLIOZvx8PsFDADaj7p4MbB
ZelW2C/a6I4inhHQZLvmmu9WA/KUozKQL2LU5lFwKx21EPWDvDuogoho3ONMeGKd3PeyLMuetBAZjiD9afDIAwIXMuRwlcYC4Uus
TCKZ2lrPHtcjVp4W5lvWVQNY+RHVffyXJCIhNP1MHRX1qv3R5NJTInsmoyECcfDC9qrP9RXCl0WzZbtXyWs/XoxWRcwqwPjmevL0
l16iil0k4XZjDcBqc+4esX83I4SXS1HvBQr77L3YWQp18pKvsr3Ji0R0k8dA63bnY4ZGThTRLLawCe5PRK9MsXEKVvciPNgZyFru
ps8edxRvJv0xCF/MF4VUIkCKivebXMlyr9A7dScivBrPNnG2wRvIuyzly1RxMvcgdicnJulS+ywtNyVq8xbS5A2mckpcrMJhYY1A
g6lFcJ0WSSad3Q+1ebWMbHiG542ofZrpnGlnoQsjUmKVS3Gpav0f40Gxpv8avnE/jd+nG6gWXGYM6G37qoGhVuNl/HWU2c1MfUB9
i/NY130HPuts07TRAMW15Hxke5CaReKXUzic3uVoPjyStJfcnk2BJBUD1b9gze/GZ3AmvJ5FmtRHZMDsOBkzATyxw7cm2UZuwOtC
qGrwaQTbBU0ei0F0qAMeCt+XQ/iDPWfn0kNf36KUeuqo1AGNEWyGAAJNR445HPl0nZW4Qz8wh2ezB6KaDp2y5RI0+606GIlpBVbL
vAVOWSSZu+/yuEx/76HHbkD5N8aORvuS0u+qKnTjEJJm8i/tYD82/XhWo5nR/ELnsXwgqXXyHN2kd8b6Wjz6TJlaz08IuxNayN/t
UDvLQLiJ6ZqRHuuHUE4aZSyRmnOc89TCfr+mOe8ITy0CpPostfBe0wzzJ2ZENZRfgP8bdIoG6CrLhbTax1jsjaGJm7bF0eZjiH/r
HfUKQDreIwabo5dkj3IcpBVB3AxYUi8DuXyr2fzMMge2JG8RHRvlF7emmKAhJ3fCjvBXSzMoG/I2eTrFfSB32CQ4zk1QrPDBcocu
QODyozTc9JUhfRL4rCzi58l2uVwNB0mI+AU3T9qvCbTohDGVZ1qjVFWqIZ1rU0auOx7DNXykzFBy71BI5nYpqK/2Aetgmuh/NY1t
eXxN/XnPyc2Pdthsr+vFHvOP8oU/Ns+1d9gqwVd7bDjfpYTtWS0088aBF1dpi9M5EI9Lg+zOwDo4gFt8rxHb8og8z4XRlf0QdX00
gpIdIz7tXCnp4j2H8+WHP11Uk97Pg0ve9tyCvfqk4RmWLT50Gle4LyVivLyGQ/Ms1XHLSXE3HJFmirxp8/9L5Qrl6/TQa5tKDf4F
8RuAtmcHtL3IIH/mnR4yiohoIUYXa0arxMc+9pyEu1v9A8cE23AbUPPNLPcJLZtRMGtZWs91m4xPYuLEPJP9jhrscTLJkhVrV4gb
t7pMyrxG9GLYe9RdIJcJIuOVm75UpEbTDLTjVXLOU7CghqK5GnoDIkIoQK77hM877Rw1segN7a/Q4fjLsDy/O4tQcPgGqyUZz+hf
3kzg1nmJjhG5cjyjJI8c4CyT/A2mCWxgcjqkvhBsBoj/qGTf/WlceI7G/8SAqFWFS8GJVObDL5bT+hKl8uCHyXKW2v/4FmaeCGf5
V2DzFplzBakItMKCxIdXX7LZeo54rWHcmFvPX4Lvs4RucKmcUQODImuotqv8YgBj23AaexM+bMPuXCeTGk8imSC4qFQSofWE3U3f
72IdpgHf6IkbIvfDZ/gOiU8+JP1nAbc5FU4ouhfUAz/YNRIHXLPbln3ce6GueAOgpk8PK5QAn5ofPyuLObGrLm1JW6pZCYBOxN7w
541cKPCgkROQ9TIzAtN0l5WM6yaiGB0ORVJo+nmChSfTVRyxIZOuAWk58B6ZpB04lHuAFE1eHk1Snqjlrn7g/vJF5gt/U8F20KQ1
CTDimucyTzy6ANw7RQCpmSj9m6edkR+pzlzGkHmEVwF986eyW1UpTs8fsPU5Kc1lAlZwTBZFupJi4WI7jtQvzvAJaYXYI/jZIfwe
z9Rywvue9E95eq/dg0xReGPgwlz3Hx1zJqWIOau89a4=