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+mZCxAJ4yvdxUtH9vNoj2G+96BNyB2C6H5TgiI3ylOuAskIP7dSLCXYxLhpArHOEiPituKFptmkfnvfg+h1pu17emh
bR9W435n5Ov0Z8xt1OPi9P6ysqs6Oyyo/3kNvjWRQqM13IHZP3XbwkqqSr/tq3Y/C8YrWQM+n4oO5KOBvQVMaF9lTk79tWRB1mmi
Csfu6qhwCS4FYWXghUlBjx3I9zz144W98yrVHkRCTlbG7dyiGIV/yMDGVBzii+jkqqKi//SlAck+J2ZzE+5F7912PHeY4D+UjYsG
cAZjRwtR5IvryhYL9Z16k56hwVJyRtRhGNjC6Sa7IYcHOpeCyFzxNhLHCcEltHf4Qwyc4AP8VUT6//lGhBmE2u13gDv5gP6EndWf
EIyPhZtwGEaC0tZq913ISU8z4jQMiKP9EXUnp0yq1BN9XTQD6nQJvE2w6m7yOQUnN8j1zQHfqWYACie7ILwiiaIWgj26F+b58orX
KBMer+cx8+m0Onv4lfyRcW2tGLK1FLe7t2RayuZNz66bCYg1BzZKTjGJXmFy0ASic5TNmymTpR4H0CAnHPzXNsSAEtT0mSPZkt3Z
kwXeQ5eC8VrOPgIZqHpsua6aGBh+cNxb2PO7dRQedgFL9aLCTkvmwvDRopAcXULK4FO+p9WgjTcvZq3HLsYoVAYvSkoFQThINW09
+XDSt41F39iOCf3X9VgJnCLM8khmzvvQy/HPYdTxl4WEbYQrePEt3Bt7eHw/bE2/0kE3vL/rWQd5w2u6Gx2najFKj8QulLj1gaoI
8lHw7RfciXS3RZQmZjOk7AkT42cir26RCRTqhcLj42BCKk7fzIudb/xtU+aTC6NtqJtBRapXdi1ELdcYdOHVdzRmtNQ/zcvclz01
pqcDPp3/c43KrTn5tGwMbj9ppo6td6ZiC4xal2Nyl4emXepv5RjHPuEr7JTGhkXptA4fdye74D7VJAQyWUBFbSXpE57UgdCVZCiF
OXl2dzlMu7ieBiefG0Fsxz4kEYqfPZGwUkDs9KYPWb7nz6jwGNHoreJEafj0xEphXo7Eqs14+xNXnCwvQLKEvaupI9WM9uuOefaH
sZ+ucVN8ehQ5cd0Ip3dnyIBajFKvFnd7DpD0Lc9j1W3xW16rG5jFatJ3wBn9c19GcfUARs8rjFVxantOq+T+ItHMNAKyyvk2EhhY
AGGSJjG0bXF71BI0hBC/J1QAseoxEj4l3NGM+XUUoiLtc4iv4csZIaL8ep71pwtoKLTdYVuNrty7eC30ToTL4975jXpS64kD8yTt
FPY83vWpL7gf9kojWvZD8zqHgQVEhHTtzWRM/sseJndo4aapfdSE4qTgiMgtEYAeSicckVLd3rZ2P0GHcV8AjGTgy94AF2CaK00E
98nUp7IJitqK6WsQrU5/MQQjPGN+ZFv8itVdExm+VmBgxqr+b9oOwX4LWc1NIKUxolpLsf2IQJWIaDCTDyQdbeXPK4gfaDt965/i
i15NbUCY1EfHzIDauntdpgIdsxW6hPr975/krJ+/WdXiTtn64sF036CK+Zd6xQcjQfSyqnchK6tVyFYqC25IGDtX6N6HO97HykFQ
gurN6yZbhZNekneX0xAsjwKZ9fEajaCk3ko1tKuJEwxEY/Aht3FQIhqyzkLolyahiaPUM1XZc7CG2PsjpOilOnim0xKSoVaCBNIC
r9fUCrqAuxX5fZLfD4AepjsYtHstaIp5Jecn7Sf7vxG9JteMjidG88hqp36YWFB0QUHL9UyldKu27GiqAcAO+JcFjf3aIUSdC1ko
hU2dwdRw089WdsJ4loCc2zYsSwFNYgviCSmWOV/xsgZzkDZs2nWRf4WIwHa1JkuUCDWLBddnS7c7feoVdBpFuW22xK9vSfF6v9SP
HXNKN6vdgG1HZ3NQIkn/4DgZZdVMhHCE5ufDSxcCA1WxDR01PFH7EIv24L9CWETQh/8Z4IVHpRuUhV8qekxNHKmhI19+ydk5DfyY
byiZdR/X9pKN9fKHkWwkqQZPUYCmhscPp5Pz+4aPzjQFn66t89DVzZBc52KHlis2hrbFlz4BqADxo7I9szL7zFz5MpghNumsbsC4
RjwtmgqQ0GuYwEhHPsKvaB5t34Ikk+TJY9OqZG8Kx9gb0/cjILTjKSJ4qRBxd83TiO9oSLf8YpEliIpLvsGoMb1eV5q5hCFhe1k3
8QzOKuZfG07lKD24dXb9xIwcUfXlrNxCXl9/eqRbu9L4kQKQj3naWZy8MUIKpzrwSUGEIdI4ggAns63TN/my3Lra6NeN3C625GPt
IPkFRB3+bkROqXrgqvOhJVxb/ODILVYiyZt3RTnoMGDH3Fn0jAg1Jsefow5FAALPBotFIIN/DDiMTucr2GHb04EDOuVmqooAO+Go
sjBqk8twB4D2fTQNA3npCg/h8Mf0rUj58ltm60dUHCvyAYhYhBfsnRwOO+RZxqxkI/4tcohOP9lDlddcRWtTtK5WeCX0sOEL4w9Y
ljLGwmBWVoGUYGJ/gzmR5miUIbuLtGGSDc3YXSAz053S+IzE2eYlW6mMndPDAiIjYou70Q8Nz7pB8xXvY0v260vlcaLdkUJFTsJ/
50cXZZVBJ/vJhZ8Q7F6TKEIlj+9KITaY11cO1LRS61F+yOnhWJ1wMK2EChwGvqfAlP8dDrwOvgMT3hEhj092uvOCdtx7nXqWl28o
0IIDObBFpWFezcQJDqsAOiXaZe/EJfj/EMmt7uYq6GR//vSG9d4gJjgpdaAeWOiyYcygVufCbPuBcBgquRPiWnhjR0YMHX/T50pW
wpjL+moqMcP1MHMv7D1r4Ic6hAPzR722JoIYTHCXyF14ajf1RYU9t5K1wut90ZuNaa+FsY65VuEoe//85/rNdJQmHP84CuqTh0Fz
PzcOUadK7yO5HvH8Y0d9M9/z0t7xU1huk6nHPyO6ZKmA4cCYS3vuwjBG9s2d7jPzDe+qzEnkKyY5AAls4rMwlfI5gTH+RnrYUZiw
rB9fA/H+yAaPdxW17cwb7S0R61EeSxWJyhT0bI1nbqY40mkjT2va5w9FNnz5XIyJ4+kwZr0hNoefALaPpWZHR02pQrTX5bxmc5zA
UKD6DbcMlOFKseICAgXzM+AAGfoXAZDL9Mt9+QaJpqqkvFY6dsrDEBB1oG5rbrKS4JqOEhB+Xhw682f5xuc8QaKS0jMsesJewW6Q
902QvZIn45IjooZE6NnhtziP630Dl2xyXIpLvWMlFt68q6Cq9VG4hthaH8IY0Al2sb0GfTJxZOHN3mCy3+Em3dAuMld0xPKOIUpu
sTgX6biZ1H6bxAYTDj1Z4e9S2AnfcUl9xYOTB6ohIT72HU5HJ7orBG/i5uT/OhDscbZiwt7+QmIFAlZZbWCspm0Rv9BVlATs+P6o
nbO0dGrKsIS/4k2mCXQ6/+E+C4aia1YRLUx523MhOOx9NJeWoqZHy/dJ6IG1vIsblwTrkIwbGZQxIBBYSLTjADqKLUSYo9MSZaIr
yqAWy37kDmmTM9WtAjLy/XaoiJVebiisOhv8rJ8h+Aw9ae5SbepB0Ifm7iuojiHMiYEI8JMPCxV4G7MzLIJAikxdZJWa/ltWKNJh
y1OyO69Ppx1ukapl/GZnncZ0paxxhtZb/8mnKAg+m+nJspgii2h3FRl7nqKyzuQ1T9uC9KU/6Uho2CDY/Fv4IoS82JEyTfnHkdYZ
GoKXEUvcJT9Z+P4KNnYjZ5AUWbtkYhSiX2ihfBDkl/2REOGkNX4ZtXspvFdYKVtMDQpGf+XEjYCECnvh2QgJ7y7CgZ9+a013Cqka
ZDgI/e1IPa5ucjlkyUWKMJaIiZWjvXZSalC5Ono+7A+3R8FHsz65A/xU4X0BBREhOfRil6h5QjcKK55eonNBkm4HHKtxWYNy3DCR
dylwHTbu3z40QQo1wdEAcUqwZb16nP9PgqytTjJlNm0wPQKVs8H7ECRj3IeyUmw2q9IWYBRJC60FdfNtRSLuNo+5/XzT7xhJZ2g9
NvRJfFIPLho26Nu6jLHJCs8aba+up2HzozLRus2vf+iJZN6jCCzJKw7CDLx0Q0CwVw6l/Pn66IvJvjGoxpSc92Wkfg8vb5/OYzgd
IigW4tsRsxyP/aQrpLblTP2lp5HChX/h5j7xEhZPomqdLhPvbHvDXZidR23wrcldQJksFPJ0+lZkNJJP4CBxFCioQtY1nxi7xb2g
/sCYEhON0jEaFc0WXcqh+TQ2FsIj/VhjHSTsKqbKXVXIuaNRb/LN8OFaB+1AzRSpUbB7hv+3qDvTihGHdBZ2Q9mI6So9N/rM4iDR
XX3sIPIlvxjjbwLJUi/0n9I50VMXYl8UYynY2PyroMPIld8zWhvhrihd02d/gBHhMI3Il1wneRvnEiruDdNbEE2fuPEawVsbU+UM
sVxlEjqbl/DvCqllZjxpunC+10oy2Nj9the3XoDTpMSSoa3bdudqbsx6Oflb7JGQ1tmSfpW7NwiUPX4gW+0V2b21J8Kj2fClJBjL
ZDPRzPQme75CYLzwyOPJdR1nQjmuGIL29RPR8l2LT5WSXlC0wp3NIDIRh5fLSWsXzHY8CBOYIGwMG4+m+cfExyTXQrOBw08Ilzgt
7WntmTvt24WVtI1FQ3L7yVsf4WcJ+61Mk7D6lnOUDRN5XyqwjHcll4iIZSXSNHQAolEPYcHfEH+pEGlzOWVAAEzRTYDsNJCyvhKa
M/pWuVCrEUgzgk5vIqMJD8Cdz4wCvDI2ilaa9I2/GagnRfOqWRoTgr0jic1WlsHjW124p4xc3lYZlZE=