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
be7fc5438c2f5fb388b7431c3d967ea959bc976c4bc81123a18dee68a61febaU2FsdGVkX19vhplmHDYLuHLeCO0jJBDECjn9c6OaIELLVXT6ojlQpzm/u1kL07SBZz4j7tPR+zGYqJbe0RdyRc8PU1HbTWd8kzjX
37GUPFMwLvAcigMAkDplYrEPIcm9R4h5ldFk8FRvPwDYvO6ujvEhE5qfDz30JMArfer1FaJu+SiKFWiGaZLjTwmcAQE9NSqqqeSZ
kUdMZsvoaskzG4zcTGrh/xAnjMhDBkSR/pi/oJb0nWiMDV8s7+F0UXh0+WBBA7NTmWd7225b9jjdJL8ECHYidQKolLL4WljE6Q/L
He6uOY8eDq8RDWKOkVI9AIjHdDAVvk3WVrKoNaYaezVcIF/GtTXET3TC1MWyMPh+uZNeCTUydOlYCtwlypRTMADpymnt7KGM8kxO
0GRHIHzzMhqpNBKp50tpH6mZygwn+h95HpaobRD4xMc8pXSs73tiuzD+9eeFlu2/yrWUkI+7R/N83bTh5PTi1LLJzDzo44Q+YtLE
S9ZylYYeiw0NLB3fhMoBXzEU99eG+6JFWy1snvUFq0FpGLWiOezEgRWqwDvD8Itk8bW4ficee7IefsECOoClA2dIBaRN2ygyZbn7
4vUbP0Pl4CnzRgO+FcTzY9EKgu+9w5fXBfy4r74kRnNMEsBiIkQRr8LEQYtjr/xPGJPY93eiaMCJ0n1sAaEgLyiW7jT/rDSTYcXu
AJTmNvC4aKLKy8hA/TOhyz/WGlLiFzIdPFtAwnEV1ZScGSOy+UYHax8gYaVMYX0PTWrm0nJCgc2yTHFpOvF39orzxoVx2WBSbz8V
8Nluvstooqu1KxT9EjXkyaqfSbCCXDkVNgUQ0BSnRgsXPKYMVJNhXpw7J4Gms0tXE8S5h4TOSzQ4cn/EHGWzET2Fh08zH6Ub2x+P
cfPxmTUzDyzwSewYoYaUMWEt+sUFDZO1hDMkW1COpAdY1QWEwwTAT7Z0ym1swJaVHaxb5NNS4X/iojVxWp/TFVdXOxWkEP+QyUbr
WblM6BnpoFe0Y9ZLnUwE3x71NGUa77o/zeswxmPtUlUMO1NLlfWPc5M7ew6TcrHuXLXxLaYezqfeGIYmO0zMOg/tVEtNfM+VU3tD
KIXtvk0SE+8vN+GntGyMyNGv9xbcMo4gbuN/lAyaf+LYmR+Smy2xnlkfzNtL50+QWv7rpNeMyCGxSa0PTU8IOQqmpvMBIGvc7xvD
agPd51Lyv/UkRSvKEVJePITlctj23Q6mHcT+BYoKsWIZKKYz48a/6NF1c8cRZXhm6xUokecI5+DkvXI3GbC7BFPoZuwc2/98rsEC
WggW4uJghVozRvUladE+uglXc8zLHuhR8WUKQqj/a0irM3ODLRn2vU4reeziRYs+MAZFyQ1UxKUxG8UR+TfKexG/jIegK5X+1ZU9
YlrYcGYG4Pjq8cF5Fyj2c57ruTeUsi/bnsfBpIu3m2jLF0RwXOgAJ+IjT2bSJLX02Wmk8XHki4BQiuzxxtty/oNWk6r9Ej4t9xio
RFJmmi7oJQEndX3KMTRUKcwankSG/MgzJxJ5z0dXZU1hMqoZfFsO/vfx7eRagfWrdq+AmUZua245lBU09Jksiy0HZJHLt0KjBXjR
Mgb94Hm73Y9YYchotfWPhqx5gVhkCcqs01Vh4T7O6PzIXBP0cO2Chf8qo/KvUTj8xoIyXaRHv5qZpUkmcF7DCrqU3PiHN5Gx7HjI
13WJ2IfIbwe9LKx2EqTWNUlZZ0Ryoj3+sJ6SEzZbi+HtkjDGTSlj8N2wdNOg+2I3gcQXtruhN6tnjoBP/lTBMOBOhxgCT9/ccBv8
ilV35OcnCianE9BjYlJe2bMRGwPI+T/Bl1AKd6cNulCxci2dPWxQx7ffqCdRu1Jwd/XUu6LbD56jgodUm7pjTfpJ9jT5Mb1f4wk5
OzoXNTKb5NVPW6d38Q0RrHcyrYKhrURoRMk5pb/ZFhanhtK/6k30h0wG++i65tIPg6gcXKANrBxcLOGafwxE8yKW1NTSgJCnkrd9
wzZgtDdVr919FMcI6TpcSiQx0Cn41D1FOEnBzdTABGyYsIVNaAOU6iHfeLzCaIXnL0X35JnAVu4zHg01WFoYfYQmHk5lRaPRKPsR
DwMxNYJkZDMEX1CzzW24us1sCSCjLFPiIhh9dbCKI+Z1j3YJBSjW3YWLC7CYzFK3xwkT4++any08d6DBrmWRvwY0MngnLkC7m82h
cppShpBZQKXNxEi0QCb35d3qno9lsX7k1v+hR/mNeSAtnE9iC9SE2XLTTc72g+67NRITn/hfUiEm9PtFlGakxhdf3B0Bge63yGID
HXQVZQTm2JqkpiqF3gSKRfMCGUa6nGJW7cPjve6me4IJcBf2LpxLSkVVikeM5HN8jDu517vbh/rTpkiO/mXBH0wI7hX2U4r91MPt
h49iOWL+v9xAZroDIxSBzQHnzP0gOMbSditFHBMngo2UDuRGx5fqKwvYklaa+K/UJgRCaGkNaY7RcRipKdPlh1OD0g1udvqG0Y/k
fqbYBx9GBbIpC1NpYPtc4qA15uGsq/X2N52U0Z9sQYJN/YL5vrG8R++BSJROka5XjENhnFSqzy9gk2WBsX1g7QeufpIBmAqhKiIg
A7fJCAbDM02edsgXLyrw2mlesMAmlsBplv/9V6JrVEX4tk9hHSYl9Or92Q5yt/ygE1jATyPLDx/VVWYSnVfyIntA5JMj9LNZG1xg
urp9FE+b5cHOG1SgvvCLqIc0ATpWigK6U5xIavYTDZOvsV8gqC3G8yzRHiiNUIoXpE46RnFoaQPn/sZBtoerhM8NE/75fy6Lhcb4
a/308gzl7zktCP63BjblT9doyitUtx2OR5W/b6ENeTVuEQtwE+vecy9enQQGcS6zhkMjbNh40MT+VoEvuBr9MUSgNtI/nJN6P9Ho
d6jNNtJPWwSdBYfPGeRuxY7nbeJGfA+voqdsreNKTJ2JhqqLP+PNFDV6nH6KBm9PQ1Yq4yr3KPkLrpzC2MKXfFJPq2ywYWy9o/Tu
bY074AkZdD/vEF3smR0zMuUBGuEzjyYKUwLSbZOBPKbRjRxaQ57HqDPCaklAVPNomt4WXIc45RUgI37ag8e83pcB6qNn9rfD1Gw7
DulFvmkN+5GQK3PMmWv9Y2ydzl6ie9+fqTSZXpoYmnbkqBiD4xcTWctfVXwuuNAf7mJ08DHDmesXzC9yL+Fe6DPNBtkRGWQPqCES
pgmEAE2QYsF03b6erLzha0hir89Cki/jyl94SuydCUkPVdLogAvJmsuP6vrLHvsfxPoUDe7YlX/tJOQjkFCjGbK1LKUlrl4sP6iB
2+7Yn/S98ZrbtjUNB++kDkBdmtZxMryLsvPY/5rf8YHMIRNv6eLPjYKQJMqSjbS5ceeDsISMGM7PNVxFt9aAU77/YpZBKNVbMnJr
aVaTKW6lpsh2jJ04jI7OBGL8hFInPpfEEhYh+dvJceZzTqmJhDTf+dCrSv9EAkgZ6Uo+O++GzE2bIU4S2uldfkA+1GoI+z9FiV53
yh1/S41LfbCAUBDB8WuOSrTGzECV861sJOaTCCzoZ2HemmDr/Sdklh90arBgGVXQBUMdAQ6prwmqgv4XiDv1CS4P9wdkEHEtMSUB
FnEjV13SOww6lAJGRlIssWhLQlrkvjEE4HTTInmf9L4vfTk+yDxYWHG/VZpFc2JNkvyOzYAxrh7aWU1QomKmnWvAF1s9kHCSCRRI
4vp2gf+aBpun1Z0zQ4YZ2sjMofyV9idgFjc7RfFmyypSXY8c0wvANBn1EAqYPJgQPntVGJtgjV2O0ccQ5CLFCFpzRq2sz9EJrwlm
MXDSUb89By6xzkFLm2aASEqrDRhCjsyTbkXw0VzvNT3zTHGeX9tPoG22SUtcMYAJIsR2YscQ8gvGFodFG9zY2P95+CO2jU/b0lpG
ZEvUE9/vjuqCRiIXt52tppf6yI8yWgRbSBNuG2NIszjEnU4+kNQpV6Hi+X0bt6GqHLtTRZkkbZlDF5lSxt0tUL7BMiIYmhs7Kx+O
u1Xu1XF2fMQZpM5zcN28u70BOxA3Is5G0KeX2u7+MyB/JhnONhny4055pEm4x8VH13prrN9xRobckBv3kgrl0/dnvJdW0W3INRQL
pl+KNhOQGr80Rs5Mce3oJ1Rh8AZzVoGiPa5N0Q+i5XexEDqYyykxGGuqLw0Glk8gqaEO7swRbT9e+GCtCvl+ydOPp5d9qvrUixrj
TcsLiTUXoI4jP50D1IVrBlDSbn9r4HA+BLP21o0+vRBS4VNLKoEEU0QkKFFiA8xc4HgZE6IGyVaWREqWHN4yU3sTw6it/+mtfEZn
nVK8F4bvO29keBnCEfBNtpKWgTMy2upnVD9jt5cac5NvAJC2uMmbaQglmAbdkykpcnRs8tlJ4sdlIKsrArCw5z7Hop5QB0IRcF6J
AtkHQ8gfWRJIRWUmJ3yU+K0i6YEhzk+MwaPiiEmqkBw2KuefXj5j9SQyHeBvdjHmqpa1muniTrME5pn4hDJvgkKQo5kt8+zP7SyU
kilzpvbEGIce59oSqBpguzJgtjzZhmvWpNyMJ9B9TYDlCA6O9rDfy4wuMHEQCWzhnvSlLVpI/nibqSOv7xXIgjQKIUSZNQcpST4t
8THG8DfuabyCZHdOYk8LTsFk93pBFCt1TM0heiiCr0an0ArrcFH+8iYp9s5AWHR3KIh+kIFgE6lui+LPSDW9Ep1cYkQ8h1W9giIw
BOt/4GhD/GVj26iJKo3eYLfSqoSPoFzkA/uwoA3WN+uEtbibXhHKMVYpymrsEnqiafsRR4hTecPYDbw=