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
be7fc5438c2f5fb388b7431c3d967ea959bc976c4bc81123a18dee68a61febaU2FsdGVkX18fm8Lrz+XwfMHZUpMfrSzRGcE7v3vDxEMPwbHmoD5YR59v9CTvv5/V+nXhLrojIJsCuTj9q46RxoxVvnsejwvaJnvE
GdEiRqVMS1sj9jG5PY/rwnEQGZDsH8lY03j08B16NIeZlTFFC46Z28CjXfOp8/Mor4ZI7BRSuoZ92S+HxpMDaGjPmG0JJ9aUqjSY
O/29HLrBnrCGLUAp9V8RRIa9iXXKDuJbyxZikSZch0m8su4bm4AALLl6reYwonJgm9zMBy5RcY5HNlB8g9TmN5uEOaFoFr1PUo+P
osUgMEZhJXabhrq6guZyeFQIJqTWVE1n5ZjQbV619r5ugzJURscNazg/6q+ktDK2T9TMjqSEBMa+f1tJm9KXrRPLtetTxUnR6v1Z
2IxVOwMGm/3l4ugKOAOlAO15//2MzGXylF9xEa+WU18RtCoBnyl6z1A3BBRUQfR6hFE4ReS7zkpM7dRvZ+evhOkeRPjO8+W1bDzL
s60cIWgj4+twCzsV6YX6297PyVchVjptDXC829CAJ5wV01vJ6lOt4uQBr+6CNr60YOEaLPMnYP+pES9oKegxduih2Ge7hqpjT4HA
yhrVpTGMMYvATRBr9C7BIhdcDx78slW47rizhN+igEcDezscsSHqAdqv8y+Gc8qJ4/U6ZHlkktT7pl1SF+sIvkN/7OUGvIGAdVzL
19XrrvHMZc21U/EPTiBBwy0cZ9RLD0iDucLWBiXLmv1GQlY+x9gzbrqGTUqhSKKnVb/82YwhlLx4SEWOr4IcD3SYYvFHZAFwd0y1
/B10baYZ5sqPwvMJPUJAilpQBIkACZQyEaIIvIIEn1P77PLZX4Z4c7Bbzrz1n3Yr8bu5bwiR+X+lRkpkr7AhWYaYk5ZPg7tHsKrI
j/dPy8jaZP9+DEs3XIf7gzM04fvKFX2JFNdYixoxr/9Ni8aW+NfHbWAsZg7xQVABQgF6EZNECOZGRvNT6FtG1X4Osc5I6aSvmIaz
Uylz5/Aj4vltw81K8ANcX4FXbeqgIAkXP3bz5X/xMdiTD1FBismyS72ow04a9cE8qOEda/4Xy70g0FvnMtsSyEpvQo+I8gLn9Qq7
PVRb6L0seC1BwYzX5XHDsqvBm8nbcFgfek12IgI6F98nz0JvG5ndHoqLGskX+dhrp1EA3qr0FAdhN9wbHt35DbDtNE766HWyIGQe
XODWiNdWZyVTrssrtg1qnMBrr3vlz7L7lECiDKA4ik5BsoRQg2ByMGX9KhlwPI1Q0awpAyk69M8W5gxSWr6JEyz0dwzspba+VqKJ
Tb+jA+2ORr9csN1vpNgRT6hkafCAy/gGgPF6iSYJLmc3jfJCM+CJi3jkSvPu84gKY026xw1WfAgd2GcRbdzkOsSk1MPTKhfHrOZe
DKPOW9Tg5CWQHiVAotwqG8IUeVjXvfQGkrQ4N4DAaqC4purSZKGPN+cWhL+vZob67LPsNGy3QUw1jo9Y8Tm+woC3bzNbEmhCYylS
sre3I0RxS7Q6lmJ0FidReNHqvcwr0Jx/QX6Bdxv7HwIE6DcTfla8Lf5GEtlBEFIZYZYJeHPTCAtAvImNyOO2yVnjbsW7taONCHY5
ly6Os0rsnG5vztLEwpL8dv/SJgir7VcjzJYKD7W52ftWxcnCyRgoBWvEHGuVC2/ndaz8+arRrtpgJwLTJHeJrCKyYfE/arqClxVI
96DO12/OFc5cgvwYIl2eZU0OkcYjeMlQ/NUPGXWQGQfcRRsCxNFTB8l5RofjjuTi7vPRDhPQx1ZsAIQ08/QlP+ZtLbdbFT6DsWqg
MpevggboxjnRj/SzAYc1vHdg6xq0dnRr8W/orKE9FY20sIWATvQRBkOEgYlhJhwe2jDattLDXTYUfNaYHlsGxY+NG0McPJpvVbG0
Q2LPs6PXk+fYf1S4mkeIV893U6mO/UZsPmuLuisb5me8iM5XACd3XkI5bh3IfMxPb6qN/j/FIe8SKOof72lU1D8m52eK+bM1P32j
vnq++R3PaOMPz31xap6kjNLBHLA+UeCUSmKTH3JcVnE+vboadNa2Wa2v3ohSEucGnvWcIPCk5NwLpDejbqhsRod21G4dZzCS6J7M
GvVcYz9zrkQLvcZh2HqJgbIXCBumqX579wuK9Kj/tNWNia1GlA7h5GOZ41w30zNnOzooTBwsi0YfRHXCD2M0hUfmJvvYTYrJN+4O
6EO/9nA7eSfvqjVQ2xMBAomgFk6InIDvPZ00P7EN4a6BA6Z2YLIzLx3gK7D/iwoFsiPENEbwjm2YRKwN4Ej22Qk5OGe8dLvkCKX9
X73+E6qXRu/irD+BpCaKvlfgr+Nigh1gO5OcUOiK1myGXr7Jsw2bTBzsf3CyxzJrLAw2oyPETE7I6A3buuegw0t6L/2VIm5vc/4+
V4Y2ITQECTzxd152kbfBL6Fp80KDRCrwQbGxvRVpsmwC4txHpCOaKhNRAzCdbgGM6ITnQw1Kq0jV0o47c7YouItRlJ7vtWb4MzEq
VcvMim8tpdHcsqmvuaGXj1y5B+gjadpj6jFB4H+c+56smvfWC0DsJwJ43z+0ZgPAgXn0DgcibSWkWT/cBYH32TkQhbyDu8MpZbr/
ya6IAP2rjTOfMhPqEbvM8OSNBbBkqkJtMHJvVqWwtalYcvelPkk3FvsYv7PaXhYkhW9nIcQ37Ns98fH3SwUjXR18wjf3R9i1Fy71
GUjmD+D1FjthGVrw5yOk31+EYOM7enJZgtCsEui2p/P11ukwk7SgR3FSbUvty2BUq9O2Eu9ELXnnkHHTBEX3rVuvc6NdJflRshQy
peTRZgsMJ1y3gY5PKV+yXj3ewQfkNSNDIBFDuXfkBl7Q8e2PbPG4tUnb5yjclxAwTAcKVvE45wuhtNNVEo76MmQkUHRj3kvwlEWf
7oEri270xqmPWDIeagql/yaeQ7fcvH9VuYKEZDC2tH9aXMg7ETHewIS5morNEIusLN9cB2RyCgtd7jztQkxmPGaPJlnSwc+uxfbK
WlU3SfAC4O6GOrsHO6pGkc+xtvuE3AL9qfk7fAhMwgLJ+nPiHezXYO9nqXKLEzT0IhB0D7Pyc3OaIxiPh9XmSUQHiG5fQRcrp5zv
V1B8uttwpEau+42FnheYamIr+VBocBnzp0pCsoT1pQvdxHhOE0UEbvN5BLoSQd2ouX+zfV0YUhMcPaJpJBIUnCZvJL6LAdSL2Knn
MmtFmXUlMAVmjq17RugdiLGA0rxkkfaRqYZbopWQoZmCSFXyO6dc/F3z/QAC2bk1GLR/PxMRcZVjkxGNVkv+qsuHx7VxuWrc4Rzu
/k7AxeLN6SISDzD8JQmjYqzN6qh47X+L4P2n0VVhalHZJaOqrDt6s+AEs0gBaLkYIdNPPhg7NloS8L27o3dnfmEmVAXfd1+jFTal
Y0ckM0IbnR1GewU1zOmod1D0a+NgTvHSZQ61vnKKAxlGa7BIcnjgFbnSackOLjOAEG7ecN6nFrDlguxUB6Xob3Q9jmbPQTn2BvvX
k32LhRXoARUo086Ag/AE2VfmBTQHI3ktjWvJ40fASpKyrimZDIykzilLfHjKpBbuHkuA0hDT/h6rt3rwyKGO2Bh3ZDidKPPZGk7q
HyEBIWYsXYVdCJ6u5hrR5lrv8E5PNW4EpS7y0bvm9T6zvB3wYkocPliGvx+G/8Ho1O0M9TTI9ROHHLABAyxA0cQY2ko1/kCh8koG
6NqBeaKfVui6LDiCQyIWnDWKEwxJwP8FIOra2nXH7uPTbUO7y+OIkxYlg+30pjJFdF/b6eHdCXaHZRd2pwFmE/KOLgcMwIIiCKL4
ckRRl6NLexkd0ngP/waf/nbYAp3Z3+Rh/rhvFnYcKracV/qf7ooV319Q1W7SZWaCZpjKSfG2PJ4H9io386Cr3CYnpSKSU/bvCwwD
gmXYNex5U05/UhB+1YFTZ66PEqj4YLEN7J2kW2XGrAt2MOS2g7EkbE2jkMqtP+WPacP35GaeG2onp0RU2YY3j/ztcut8NP6Nbk2k
GSbXyU3LnP6zo2hGUYchKstqTp6IyAov8/m116V36K0NLVeDlQI9XaEkAwt6x782NcmMr2iIkRsb3peGQnv5ZFe7XicVHASVjcCv
VXc4nSXUdQibMLbm/TzRPPqPkgPQcoAeE85nACxwWYMKUCTENApzODOoSYqvGWu4c607cc1bG1PocD1xxFgIqCmijRAnQNXq4BEr
JZgWA8X0urZj6eVLHfjhvgqHi7XiwoKyRw3udkNkdpiTlPvgyOnZ0ScbW1yrKMQL+TQVyqEKWt+zCKfuEdIudCy/bu1bECIr09Fj
4kZv1u+ejek1wu7KbfOfvyKiRHKdb9HVwcevgfIpH/T7QvE2LErnIRng7FrpM8LAtV8mmCvH9wCbF+nXcASlB8CSPNipEAEVda84
L1uQR6704+E8UYMthXJSx2KA0K1jkwVXjqhPIPJhPi0dSDRwKKXjTTPjpLrDjd7zX4McxnHonAPuZcg7QdoJC2XdwGwmaTcf3Eps
XJc0na3MRwaSLkGqgnKP7/VFVTCNHALYVaUnao14bYYJbqMBc8/zcSuBj32anfqY5Z8s/DUkALKIrkWvSywV1IwMlBwIgiL3K8d3
AVqDslEHHORQjQytfVl/9SLNoVpxxuGb4XLdBCaHpfVvAFUWaI1ftCJ5134pBKa0FavfxXfX+6uAgLB4YCRaZDgFtaFvu04kRZhX
fE4rPSFPXSlOZI6Q/KGWa6GevmYDgKas29dH7PiYFbGX6bJHMMJDgmn3pIfvLKDkunD8ERCcJAuWM28=