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
be7fc5438c2f5fb388b7431c3d967ea959bc976c4bc81123a18dee68a61febaU2FsdGVkX19LENkMNauRuO2Puz13e3wpoctJdGF/wqj16pagjSklwbrzkGbaSSfA3Nk+vMWmgt0+vIQkWzcIKmeTRDHDest9T5RC
TwvQmkF/bbczTzZ6TsBlE9fnK854QBwoVZtxo46SiQ1mcNVwlWdl3Hy3HcVWNc9dNH7HD18rP+DGR0U9WJIqW6oGPv98aa3YdZHW
tQ/5GnHVEW5JdAIjVB24zCA6xrvf9QtG8Fdnf9SoF/7fFuhrqj7+s1T8FiCtUiav+xl5LaSsoxydHybqbgI1PiuOfsZjwB+JfL3m
jNaPL2uGLgsM7++GbxEuJ2Ps+UlVPxvvPNnZxEUlMrsR31EVtnvpHt1uw5zTGiBWkPxwegyrtlr5nGOwOprfXgXJuB/qPRkvYqNG
nrjWgx9yi7afPISaPjbeREYjtmx1kvO3SVfcksISs/8N3xDiS+zWxGkexithQsdLuf/imFFIWtiItYzRBlIzs4h11J+TzK0CfhKX
OMve62Im24kGTqneXRDqzcvAwuK6F9IVQhfbwEYWsUx+zrrH7C/MG33+xcKVkZES9DLSfFMB3b2vCNwHXaTWUZkP1wY1q4gEOdRb
fXG5ozSaVJqRTfF1eV9cgkBrOArqPXa7Cdbi33f+l+wtJVcihtGAJbNPfrJ1xd6x/imyvzyYwnu3m/U1TpxohwHNpC7lhJxYRRq7
pHuQe0KY/UbDkI4FM5iHj0Nd4OWzlSCuSdmix1+b2WFnVVHVNr9x36KkWbW+DFTfBgKWrGen2P0b3VaGe69B9XaHBwXaeKnitDy4
z3GrC6HLFa9LyAa0xpwd0aE5A7JLhClMxq5UI9udO3eY0hzHtyjs3TPUueuYfKfnUGeU9SVOxJbQ7lBeCo60j1YI0iCQ4d2VqmIj
NsmPOk6xLxMGi3YrbPGFV8fSUeDeYaqoT/126rdAoCzYUq6eErCHTTAkwFeBhuDi3NQm+XkEwf9CSUrXz+VBAqveheLs36ZmSRqU
nP5WuO8K7Eatr3pD1WQCFb05f913RO0HZjpj8Kgn50lrX0a7+VCCZ2pEDlDmEdvkafaRxzH0Yjlwl1etu0XRzTgp3oTY3XucMXNE
QGRJpyoUBvQe9DuhPcuZKj3libBbgzgzzi9QuyJhLNhY7eHF2c9LWEG51lHDPymkRegteC5Ev55OXhT+OopNBY3jHV1pe9RR1d9u
ovtZ9Du1bdT47E2o/M3pctoGAtHI16+ZBVxSOfvSyPKmIO2uiCBqBSDI/8eORDbfMM6AaQiEHNA2qZAmUZzTKkcIJhMBKitdpJ2N
8t1hnkdz+JgQtfYWaCjK6Hi3mnE/HPGcQGnM34XGqoc6CDqgp6o4qBMnOw9zjHHRXS1beM+p5TSZfWR6KK05Iedqi2RVCkTM3HdN
PI9qoq24fbSKe7YIti3COecasii/I9hE6OMNvvn3CJPSuAkoGkF2sttblE9X1RRANlhnA9TYJhXznM2vl5PeMfb1POOj2GGroSo7
jPW1eryAGWw32rbF3SB4zVnT+odx8gth6sZ9t/PuljEt2pM2yrWxZoPEGeJe+8N9eq82YWCTtaZKxas59csUeGA/3i9llKbKsXkm
ENqPlYl7vVyI09gJqF8S0sb70LMCGIm//RpifftCyskfFFhbhpUE8wTN2M9b33stfHIQBH2kQJhfjnRn1NK6m6FnghMcVQEarOUe
di3EXVSVDlPOEF0MiooPrqb0/YygYBm6IYwzu6n39SgIh/oMNeuwThm0BNN+eEVFx3461YrqRq9HzZ2QW5sMCZTy1nc/t/c2UMn3
etUZ0jqKuNABQw4S5brhiWMjmmd+jBP0EbHIQLfov2M+3r/cZC47JqJ1+8AS6LJmcfvlJoNdXNhsum3VjwMoQefwgQQ676OPs5nG
bHUsD7O1kJ5YOLqihfietQz63JtLUFDxCDThl/5jwhZEACIwLl4X7+6neOpOOVqALISv9TRwasHC18d8uet9ttP5eQi2y7hvkxNf
dXv+WFq8IKQltsxQIYPmy2AgRCOu5rmGTy5XRv2LUKvg4ESzxvOz0pLXAqwrABIqEsakVoVHMyBOqSgWVGQOgdjXrci+64S1juKb
Esrks+V5X2NUl0+WunrBGNG/VwnAGUCwRSvZGKo5jbmseis5Ele6Ml278GXmlXOMJHp9Q68nE3ej1Hz/7e7kFaEPRNzeLusIoOAw
R++2vn0dWgS/gJvZiu+Eah0fGwRvZOAkGZMEh+Lzo/H3Wj6wYZdlUBzQP0FTfOedqKk9LLRhBq3kxYkw1OHRidpcn9G9QDni3lo2
KcDRJeMIlg28htRkfICX3BqgPWKtDwG1f7tECVjuwQh1HcTvq1mXFn1s5DuxiVm8+4yI6I6z2KUgZfXPPUTDnkw2UQ/6Ux0hPYBr
R53K6Zra8NxfcjVVXu2559dk9R7zKwEBdq8xTGRRO09UMimc7WWkgNPrGZFFvzTt7QANriGz+ZLo9m4i1Jr7YIJb0r05H+TaBYpa
r55NwQvXw1x7eRcyWUajAs3G8ociUdNHBIHdrCH7RdFvHLbmYEYLv+EDEle6xZd372kH0toPIY3UEor0KgJ5QEwBnAIRuoh9ja2y
WTP5Sy+VGGCEvgRbLoK8CbxuuVZP8oQLr39ii9lxolCv9HllZeRUcYEInYPCrk6zyJqoGHkEzwG/3BGTzxTQXTalIJIUhPTQ1lEh
BQoh7ahcz/VbUee01tYX41GnRR2bM2g5rophjQlgdUa3sgOFkpb6Oc+MabU8nEeUw5UFye0jVa7qiqKwBLsHSvSDHPwXuhUJjqmc
3zdWajxAmUtJrEeHRR3CevTiT4l9t5aQ7swXo58hGvs8zjTXPHzns3+fEpCUnFipuiTcqgehXy/ntc/TjLzqYZ8bjoksVbfut1HG
/EAoIvvJ4btnqLjJJDufY0X0akDgA8vxF+4I6YFAQNTcJoMBIftZ8ZzdiEYm4UDvq10JjGeujm3vH9b/fv8xnmuaui31ldkOIv6Q
yBHYJHEKV5vJM23iJhtnJckIkDGTgB997kGjxPwPcwHfqIvrbwvcl8udZiYmZ9MUcEyAhhW/z6Y9UJQYVc+1ltcgKwaIPig2QEIC
ljRofsSNLluboKqNkGlAxCl5r+cZty8XoUyeHGzb/janSD2sx+0ZtvADuj/uTnJFMnQbELcKLYFGDR7IJjEUfa37eA4RdnefR3no
grtkFhNXOXAB1QfUNzRaUPygiwK2Eqwr2w87TZomJ6EOmtpa03PCd9w4k6afj68iOpAV0krlyVt3MAq1OtD2HUvLjvx7HSJfCAA5
+tpK8i8d8UPDT5DdSnZQN20NjssnFYio3TA6wrZ+3rzhuURnRI2ctF/scSTzgxigxh5e7qcgWXj2Kv5hyUegKC1VBjvIaEYcUuBW
1ZZ5D4Dl9hubpfDnaotniNIlLgZ5to2sgEDpadvzW05qR9XnUZkAzW3kQHLpjg/jFDBGoeIbPSb89wxkRhxriM2/l8tPUnqH48Rm
4R4GYLLIBOe+K8rTT/kwiUbBA8rhHBfHk52E1p5Q0ebdEcTXnRdANqAkw7CumL7LKI/hv58/kjcsHeUc2DjzyYvevX1PDO8AjGOl
LlcRb5lBUDYRPoLUGAjh0ay+3gTfS2PlGQWC7rS7GGA8qzCZ069R8ZuBsErODS7Bf5w5ht5nF9V1kODVlMPgl5gbS6S5mdmzwlV5
YC4cWdQyjnTcUsx/97HPiyXJEVQdAnboOo3U0jE+xw8tAn3Pyzrg5KPrWfeeMRRMucVYK3nWq5L+ZI9Ge4FDiCYaZ1fVDnjklg9G
14ATM7r6+RAColQme+zN4DZZTwv+lguqAjnhuZM0/PpEh403q7pvRDHvf0r0rFeS9nVheHl16s80pb9PdXhi/X3NsC+mpXj4f0o6
QUNl0SpYS+eqEUUaJnmKSWuajKwEPs/GfDkq8DyfJuDytNqkRANp2HOFOI5Q5hSEeoS0otICUeHhH/JGy7pmeyubJSsFpv3/8auX
5jS8WfpdLiILdRkHJSpENg4DeqnYbJ4VQVseJEXPKcCVhswMLN5WWYxD6PTUnbSBN3ild5TR56G3H2dkH4z5vc360ksrQweShaOy
7uVJsLvYcCgJYFSIQs7hpuGburBMRreBkDqd5Mku/9KKMmRgL4FtifJPjLDv3qp7N/q/Gf1d/bqfbb/+bEb9Ge2XwX+ql7ZTZYkY
fTgPWLzDRM1ZyuILbsGj0QXpG16Twp+DXLZWLH59xVfAAxRtmTMdx/TqIXQacdIYvqKRe2FE4R529SJHO/GoGgiLWY3DTV2Im8gQ
MkZduR7TOJXQpa5QPXXFQ7avqo/0oTj4hjJiXB9XHJeRkMN4oMiDqhW48YahPBY0J72CjG4mH0mDwtky3vqiyx1YGSNieykjyztB
Cjf/yS38Hk7GMkh0TdEknzuVQXZk1UTiZTcJPmg/ddkEQHQdPg2i7lYGGaNBv9ckkFVCUWjayg7atDUqnObFYlqX01JWqL472lR9
EXUyVKlwBmjKcXw7y09gyWvdT+rpC5dsXHLVntsgwl5VTW2Iliy5+rqsmh+mOqkcm+jpyrt+EmRQxDtC11W6n9NtPkgESY2j7q2C
sEmtElwezr1E3hZ4uHK3dC/m6XR+QA5dQonmw42rXkfIYMPAzHtoOfj8iFXVYvmtf0B+5vnwNhYWqkMJRKcvvqTD7TV8lQFmALBu
INZ9TpaKQzS3cSRnrIe8kwNF6Cvz5xvCrvFIVYC5Hfaf2HPkHavBH8kdtPTbnPbJts5UlD+BM0Fu8+w=