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/FEr7/0CJlpqSWbbNBr3Q+2XomNMs5Ui/8SpG8FSS40fJopfKZlppJJrDMoOhyZIyCyvOU8H+N9Trm63fL6PJdFqaJ
BrZ74s+yRJ+To4D5JMhvGkpttl2mnu1f5djZsxP8hAjRZ+azNtN2fJVdZpBrDEohuBqsnTc7rhPNpWvTuiQHfhgutjxBUEu8cmgQ
iOa25SRpw/h+nuMmRKnscrEL8QTKOqvS+6rAegjHuVbeKzZVlu8VoRaXILtVQ5OqkrQRY2V63vBx4WteBtZwCys4LCcFOT3n2icV
RSd79Dyy87Id2lGEngoWEMKhuhn7Ii1widiN3d7yqE3unaBSiQc4Ba0VQ1OJ6JK+6xRGxdsHjI4pG0wtqiSFicMYKbIZ1d9IeGww
ggt+CUmMnNhIk8mY9usLI1TFJESasShuDaDXQN6cGdHUWKOxtnZaPF2PzeBHKJbqazpmxqfkV2cbMTd0NwT0PRA2KinMndvjK0n1
fssY5ufWZhOZm8KMTpxXO6k4fe8LxMC6ZA/g+JcqgBY0YsLK1beF2Hmn+6Ka1VE3f1dQndQSjn3uZB7YNv7GxPu/m7P+yDFaKrhI
vP7A7lbdJLWipBSzwWGp0Ef2efTugXaKYC6fR9C1bGBkdVXa6mizkaqGDh8T9hjCiDXz+b6AS0zTNi+scXXR2kq7XKbiWG1UALcL
X8iwqmIozUNnK+APbxmrGx0kf0+cH7cvshwyMyHo5j2NTTD6ktCkSqlKWgtS6O0LwZrODhkhrMNfCzEuLWzNRJNHfVBCJnG9irKi
y833Vo/6ZKRAEjYMqH5/UVzEQ81CZgxvyXz9PfUIn2Vu3sMRW2Np7jDLt+oiQadHnF+Hn71Py8OxUnu1EAwBCJkflDawTduZbvHK
jVYLrFVhTfoEz/cvASj+PpjnGaYqcNnV66pkdOi1mHmt9enrhIQhUQS8Fk27RUnH+z354+gHU3mpxNJLtd+gWasqx7Y1C67HE5FB
khnVf4uGtkAoMP8QDE3KYZlpaMt97nlKLJ3mZkPJ96x4ORk+yLKz8LImF334bh+pxskO71A1c3j6fk+sEzYb0kqUY/IT61jfVUU9
pIgZazsDi2PD4x9uj+K0uvDOFGKq9iApVudZwJvsCWMcuQYPO4yBiSGJVTjOHNNB56QJFhJzTUCYWdX3afbpZyQEhiGBzvmgHGau
313apIT/p0O1LEq8XNQaBejRKgMsEmgEQPByDF3tMbW9pVfSp3q+cv+TWQYb9vbVrf8mwhmV7Ny4ncXYe3WgoRR2nozjuZSj4eFg
o0yWwzhhsmRE40o8402hnp90UnZQJv/cqEoNjYb4AbrRvZeYu9Y7xO0Cx4UGCGU6iRNQiPD4l+xEtrHjPrGOBUh8nHqzANW10aMN
cZbp2X3UoG0xU5KAKRfyrB0vpk4USXmB/nuKUXPf61b7Y+D9sjk21frDCshmicHLOMCDFP+AY8KVft5SkPUdGgSSY8ClsjjeyeyF
wnKBlW0PJn5iEk1PnVAN01TqXmCuXxTyJH/sdYN8zXUuT5Br6nXMx81S7lZ/QMGfOtIvG4rlnStsfEkrC17nkHhFOq1CCyuchJQM
wxagAfjmqMpzJKwTqebFwEnLrRrGnB7nLEgGQmEWR3vmLDe28a1UuIAXmmMXJge5yAkLqrBrbKr2+j7IVKbdkL4dvfWwmJAs83BU
rBTK73vym9JNDYOxvOrRYl6h200vbhfyKcKBAp/er1//Tg0EydDI0cL3lO2JG1y7OxGuXPlHHuWWGDKnmC0ZnUsc6u2UedE3etCS
Xk+5s0noxGFRPC44z9Tb8a9XRwQ19yMi2y4WQXddGZ6S2Qv+lyg34krFaVIh5T862avjcJ6m5N6AU0dWezvw8QwCafhgJxZlNZhz
UJ5EysEH1pAFcCPd5tJXlyLuu3e0Linwram91PhogvWNrBGi2565COZ1Nbdp6rfqeUdFVVDNv8zXqhF6UMAuEVibuqALfsZI7jw8
a4gelRG2IP4x31G0Dk9u7Uwf2sktyybznD4d4l/WkpEHvLXP0kUI86csn3sgtp/1obGGtP9M4u2EowIW+rHQaXT2uTJYtbRU3VzK
QX+w86aN/3YP3AZzry3NsUnEzkpYJfZdfZG9KTiiOMRjzJYkx7+49M/BdDhEe9klpywtNVSkB2bpVyhXDp9zVcnmmKQ3OE1/4VEM
Wk0deMxT1lnYFsmlft2zYn4+d1yYloHUVruOROMhtpsxib8WLTltvqqMStUGWuONgsYHuedmPPSIt8XVe9nmEhqiQPT7bNgy9ymC
rWu1zq6y4zVcc8cmmn5CwsIKIUUYtbqOoeX2DK+RE8axz/u+YO6rHsg49kevUlYm/UEgSz64nqTAUhyWkpkJopzWVR4SLhRaaXMq
vdOPbA2XRjRPbTqMTK90b4cnII1gl4dcsO2QbftMQOqO1xzQ2E3sFla2a3k6WXRwfaz/IQcLgyjQCB8WJ9caujmk/eta90fHzZaT
2r70qDp/yQ3n0/K4LMlv1BeSgeM13oaI0CWJBlyGY17p0f8UG7aZyNYY5IY0htWQyvV2PcbDkqbye7VAgM+l/mxwUfOXJzuhHDZI
pV/EDH81qDoE/E4ggZewcK1XpGvg223oNgjS60VThlesoAtWvcLapL10x1hW6uRThc85lnF0u5azY3mEjsyfOxgHTFQOOKqsBHQg
BSQjfkT5gvLJfWBvjNr57ZjhIUcVe59QtgeRJ33f9vM8qAhQD2BdYmT/cbAH9MHCj8Th/m/dJuyblXF3hQIgUNtHn297Y1HJGity
KcRw50+l5Ig8Vw0+8Wu7OVORIpPg8izDIqdG84j6ynGPJdtdXN9OlmB6dtZxYzcwbTmZ+aM5viy6BOUEr2wnpyUVlNImo4+/Jg71
OtxaGESXWyqNiMbMm77TBIb7N+jRolq/BD+lE+VWrXpleI6QNH0rmxHAGVkaAYKj+iYA+ytiW+p76UiHF4OegwrfgMcSVkgf87zH
t8ryjWvxxSoegmDe9a1pFVrzEJGq+rAx6KfDkd/wr8FlqOf1oWDQ5wnJTEXCxcH1Fxx7g8YImntaoVXxsrKV8dKH9DSPjKkRmIQp
dU5prJLSizRlD48EzgyQf7nv1StlaXN9d8du/06pee6MWV4GX/TwvedKcbkk4JawvNZToUPLe7qIs0tLp7YabiLzuZ2eb0HWSuyC
1oUxnYNXm/Abt8z5AeIvTAT1epKh6Mk4RDH29C864a3cuT45gCNN5oOOJd2yfZ1RFXj+lHa7lawtzSSxz0HnVn8hkAQekPti4q8A
WDCism23hkbDXrzep0AAdnLyjo+XG3sDXzJMY1sUEvjHMpHp/IFVqY6FB5L/1WJR59Gtk7T2NsStaKARz/GRc3v9cVKvkQd+7FwL
qrjAmSW6cdZAGAtRZImgqi6eBpvWkZ+TQRCocLqccWHBFAjf59ZJhpjgI7EjQIbYI9GyXlAZZKmaRaXWnvMizg82qTiKnOlxdOjS
S6dykbwwDmPeGC0FAUSdgL+5RomyRvUZDjyDU0zKuXrzl+Ne9mqRfPGFrCXI/O0tcEDNkjQFrjTYdEvKaSJ9qQC1ER7EsoevnBme
GVesgWLj4EnzlDyC/b4eqSUYgfjWxjSzGvHXGgqtixWbZBUH8KTZQZchFjmEeClbFidP+KjeuUvxbKEUGPTJmS12stx/bZTz1O/G
gHY7EiTHi8Re1cRq7XlaUFTNCqP5C1OiWM02Ze9qNSdwXHZesBeBDvss4k879UXpluAnP66X6pPQ7W9qXr3odviyTSAhmZBFn0iK
xu8DXh1BGHG0LTbXh9TsQ+TGV5mFOeGujDozfOCJD1nQWgemg0AweSWGJotLd+tw9v6QDYHQ63DEKMQy+OvRf+N052mmxPr06vB0
9k2/5QTI3srgVpq9HQNXFp81axd+mgkOhAvt19PYzttaeu+VyPwsGUm7Wkb7SDnlw5tQi+TuZcFMN5BBmcpTzk6ufoFZv7gOzfyc
KjySUxaIfg6FmE7N8pmOtdRLSaw2NVxqHD3yPtCfS0tPi7/DSt/nxNvAigExXFTH2V1IyXk5Yf0vo0XiNsGxNofRWgMNCbpNPEC5
VFgCOBkFMgAO3+IbFEAwHmB9QQYapFlxKS0veV1PobplKQi2BG2tLQI2ggkgdNwplEbuQmuVTClcGXJIb/lZev1W+euDqUoPJsoC
Np21IHHAjDlwLOxPGb0vnWwoYI+/ytkFgtBIifokkxkSyl/D7gvSecg3w56um4WLTRqxfGiJAYvcuuWbmtcyQwZnLuBWmrl4bvc1
QKg7JaH/zx7sy55lVneO5w5SXc3WPwaNljP+zIo2QztfOHkJ6lkq5EWnmDRWUZUyQuA7Ze7YYuuUaGAIooXcpyjusK+t9Qjq3Dvr
pgEiANxr5t26hr4fxyBJMuOUOe+Jlc7NvFNwp7FxQWnkKrpmn99GntJrB6ifXimUoFhPFEXySvb9j4lqduKget4ozQdLejdL0LJ3
J082O66WEd0vM9i/SNGrr7ghFcqz6+d1gSRXITbslYagF/7pz2yJQ4yn51zv2e7cvLtLOeedrI5SuRBmboJA+3yrAmnWgDgv8ij8
aALomXHh7S4p4buS58U8UXxg+a7F8vF6ysvl7WbJOxYLCQWOIyWQe2ELhUDPXWlYRHdeXgoEwBSWEL1j+7hE9ckngPZuAMI4AwvI
D4dYhfxEhBZnMOZzQtYNBTFF7f/7EUQysKp0wB/d0fM2ef1/elzq4N74TiDF6a6Ldxpu6VneumT9zYFSPz13C69/2AwQuRgQJSKg
89wpYACaTco899duqfQXHf5iNdixThxBl3YCZI4uBsI=