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
be7fc5438c2f5fb388b7431c3d967ea959bc976c4bc81123a18dee68a61febaU2FsdGVkX18kBSke8dxDB09+AWMRW/FtXMESHIxCgNAMOmL2+o/FcYCyOLpHH4uDPRSC0oS1sgdhFPimeZRAAS4pDt+XqjLPtii6
DO1hj/ZKF0/vUn2eps5mb7f8S8ErBw/m3c3EwiWlLD72cR3sRJ2QkjDJnPs8oMgI+H1/ZgQrQCFwgny2IoAguyGe5fOwbg58jGpc
3vb9tMDYNCXsF6D1RSwuQ4JCW3nhpbMAU6Gnx7NNOpSstr0VTsBO6rWAcCQn2DG0XuaLjJ2hr5THPTUKszHzqyk76lDpmirxK9wP
xumA5V36ekU4+eWtP6ZNr4P6oRbfpYBI3AqltAcUpH5WMF+Dcr8K8mm5Fex633PjE730tjdBGZ0qt0fhxVHNP0TDJ7WcViSrc0aI
T+bulYF3dmz83lbBeBZkUt6QzfuShOtohKSN42NzcjPh9VRMalDn5c3DIlsHQ0BZ/iMTGEPsZVG15zxOA2NW6B70Df+3uk1HUblu
O3VwEsSPAWhY5RYMMl/bhJPCB6cddpuhsa1B+Zcb+1SC+9i8vZmhmU1JPZNqA9mwjLS8uxXBjcU4F6rleFiAcGeQ6yL/g2f1thPs
z1zGwj0UqLjDLaYmvFSKm3HegEVN6BVWBsz3vNuKXs8bGaZTMbyu1GDXmEo3a49ADUqoh3QTxO4vwc6oGJfn45s0wA8YCPSDhi9j
4M5kzqt920slHgtjOUmETq/DNFzPDjEK2UP0Fm0t2ACKZ6UkaUhZFo/LjD4iY3i7QONdFSS28FsQJBQVdMhdlwaaOTLMiKWvQjdQ
rU1lGl7HqH6dw12UmYfPaz5jC644bmEyEHDPcEzJQUy7BhVQ6uNR8xfvQq9UfAh1bUjOTgJVnZ1xSsl2Z+SgooHUM8njZbDAAdxr
wWYTxjOcNHTLRTwJdFOUARiteauHsZu5RlX0GwZ45C3bGpuHvpG9i4g1/HklkAv6nTXhUvc0dbqecFSqSGRaJB/Vkn7Mw2+shL4w
BxVJsaSB/AIhOCkyOfUe6g14hf3HVP/XKCzrKIM3ZVuhAy0aHnXvugbseEh/r+bnzHmBiPWfX02PpEZMkQQEkZqowt5xw8952uGB
CeAiY9paBE2grXxsqeqLniLTi4WygID7bRp6znIilF1sEyYSG2NjuIZIOVfQScRo0wnmWz9EdGp1nNp8YHX8LtsajYsxSieZQ8zL
U+XmKOuW9LNRKZvZ/v7dy7OFF1/yaTwKwOU/tMQPCEcVBDdD9w31al1kjYx0h40n0eKaA9lKrnvLSY7lWOF7lrQKWiMfssBya1CU
0ubl4t7LrsNH51cKgGabEWoO5gWM86d13vytKKlpVDWJ+mepTHnZk3W2wJVXWdVi7Q4cmcwETWZJNe1DndS8zCIF+KrSLw9P2t0h
OoDfem9PqxhPfXIALix3poBGIdWcqpCnZpNM4jQ/pi0iO/EgHn0dLOks4//Uv6woN2KjJNu19BjurLDdMG6PchEUarf3MbIl2uYh
4xwEU17NkHBNQymu8pAh2Xg5d7tSBR95makd5QuHAN/+8rRAz1+gEwG/leRAVlDRp9y/S9hllWzPRJd+APC2xC+Dog91dcyWj3ne
75iyEzisEM/sId7dCQZS8lbV2oKn36CmSKogE0NhLIvP42oi1qMn3QH262WIycnwqjPkeDq9io7xjCMoUTdl2fNvK5AN3u5irowv
SXsOd0kmriMot2V6MrwoE8ThICEuZKVUcnN33t2J4o7yLdfI3mAx+AadrlfxXa9k9ZBKOgKRdUR0oaSMiuWb7l1HtC8MiACm8a5n
j6fzMIQmlB2mD0xkxi8w7WohCZPXCjCLN0IJkfpIvXk59SRLUFCUK0a49ng0a3nwsNohEfoSwkRvrPfjEVr3/ltTqak/6u3UHK8M
9ULJ3OQaGKj9foCAYSF8uv6O4Cmz4g1GjnX9NqNObeloPu9bFALbxjtthH1PXTFp1/RXneEliprOEzrnYFtMwRnRgrgHNJ+NwptL
z6hAFYNh+i6TIQMljsXzplIMjg1e8HRfg0Vz4KUOtNr/c0oeNpQXmgC6vr9wMMabm/W9KXMtQd5az+elPqVVvhmU1j5LqmeqjlS9
yUJfSexFWZtWLuVActjuRzIisNxr53h3DPP45aIZOKu/U7AwfAT0xwH5REtkprPdGmKgwSya1fn/4bAxRaux7SxNudHHIWfBikpP
VFBxBixRJlqJo/5/o8rOrwEUpdg2sHQ6nICjRE5d9/89yNLbhdT63/GrNMxPPEBHZSa5pIQ+ZA1Srzqr80HRz0kGg11Hgs4F9ze5
fgCUrJa8lV2hszchLsB+d5hZYVtB6Q66/2SIr05MnAJ+73xdLb40SUImBrZoYKHdCY0BQIdUQGGBDOCamHVMpLTYHcmwFZU3DgcV
136WFstcK0OoF84KHrz88QJNcVO03YG+B/iPa+l3Bn7DdKTihMqME3UWFVvKSe8GU9WYW+xk+4ScJ3b3CPOGZ5uWCZ6KKyhhzpyi
KJCaz1kbYPZUbHk5kQpT4qbP6PVxx0s0fj82sqATatMwdVCW4XCfreB9LXjaI6iq5AdrS19b40yYdz4Ydi1AiosaSXuV5TNBN4RX
Y3KZZJ+XscBkwJVW4gNK9mUucql3KB8B5iahkpwn5/S22qVynvFcXwlt4jByfl8D+/pfibOh5cY6uHZr3ZuTpYgf9ox1Yu/lLmIF
rx4fA+VANfSciTkrYjqqvnleqOL115BTXqvbDrLqPI/soNq6PhL2jawnS0UhAwCSGF/TpPdmucsA4sKqO8kOhgv+kNfiP2zdNsOe
I1s6RDSzTOg7VudDyjSYDwHNuDy/wsw0yVhNyNlb2n1Iiu2uKxtuwp6gUbF5TrHTQ+RGIwqVSvNDXaQ6TvkV+TeVRQi0F/ImGWi8
wpjCInF3YE/B9iAzdCFgHG/7xoU1VXpLyCdacHnFPIVhrLfYJiE78bvmnt4JFp0rt2lZhvvjvxjBWKAtkHA6ifUF3oeVMo3Qsv86
q9hDPy8fcUJYsklq31EiWma0BVaaxf+uFtRc+LOpsrXlXyUmuJvDzYe8MxiEuim52PgHTRWiG6X8NFmiLOwYxzTRUjCIVo/UTs4v
yftxkxgEegkR6rsA2GT7DYMIJAS9KOJ6d9nzd6BmXW9/1Bz7z9Mvz6dJZF7W3LG6IXjd7KswdHO4wJraTMeK0gd/GkT5p3oatZKi
+OTJYZMojcp6iaZLMCs4vhYqukepOwIbnBxOEqfL3h08Fz0GHr3c6d95uJ8ut95UwU/mzsuZ0DWUqTPbjBi3GRrgb9StbuisvfSJ
hNcS2MhHkdxH+Uxj7WXlGLznbc9jWM7RK0DJTeDVmlHGXKlPAELUd4rJiKDAn23dShZgu2KcIwCqbOnCLUNvgNt2nzoK2MnCxxkD
Ac/5POvYk5k/aTzTD6JXoyff6PD8gTKPF/uAqnVJ52VV9C8hBL5fdeSblhtISJaIwPVAFgRdt3ToQU/mUt1N/UfG2V0X1PsgDNfh
WPEIgQduc7av8zBpAHVjGpjdWNGfwseYZwbczi084Wf9NbZG3SYP1zvlGbwsQZe4GeZqgwyfxmU1r7Z7HKbTJD3JvG9qdpwr3bw/
pO+EdhqSUttez94XzctwfiQCNH3WpOqqZA8VH5z/Vc9IoJWIwoxA1f7XfPTZhrv/kYrjhdw2NEy4RxY/8pm5gv5UKTvTpC+XnH/h
cgZQTr6GAPgNoGkqZ80q/oZUyS8CD6fQfyDlpc/dFZwjlko/ElYZjllKHAz+JPdm0Td2bfG1bRQfRiyHX0qpz7G4Cojek0u1mhAE
w8MMCu3b0pL9A/RVV/S7SB60KNgXsOandXIgk3IGqSN0gCQnnUgK+sXxSMoX1ow1BchAxlXNPjnVV0PkPpWO30hejeSmqGVEI1xp
GzNkrLEAv+wO6x6+sXXwUADo/7IKMf97665Nh+B5kDqs901QkuCEcrkW2VakupC149WBehpLnAh490PPwu7kDrlHveLvH03zHZG9
iO167tx2MSScDqDrGZhaOPyTSRaLgJXezkoJbVySMM11nxqUyRTIaU33S37xhJEheWfFEb8eCJB2O5Cdsu/9n9H8xWWXD/rovmSs
zExW6Qd0jFSy4LM+jpMLMmkmQGE1ed4tmfPJj1xWX1jSUEdfL8FmLQ5jv4rTJxCIWBRBqMah0P388qrdAtQx4j3wqgG+7qrPPx2v
ppbwnQpzc/69skw6sG492/jHUJ4KzP7p1gvN+OFelS+xkVBO3RH2aEIf90RHCe0YGqLtHu2XcM0MQkK3p1mSG+pgJXuRA1lc43Hc
vV5Xm2StSoXTPUqjjhHGDjW8/p9m4xPJXcyVdaVn+J0ax/swuOEY+gWH6eBjy8S05ndOV9JmiUHunl+MB2M+VtC+Ydu6bL8JbPMr
bLDgbUoIdbs/YfB+LWG/vjdUdMy7Lz6a8rTUT0WOOYBbRWAWELpCT3lrkA/0YIBlr+J10t1O7Zx695vlGhc0pEWuQD0csYY/5naL
gEf6r1lsAseb2W48mGqIdKYemK9NiGGiuNgdKxZxNWODrdZNVbdbkKWXN0ipj6Kvnkym0QfyvBICpB9EMXut8A/O++o3f9PaEdVq
Qz55ymo7SEebznewSuWhlbLp8GDJWedTRcTg72lQVVINjsLu3wLO0gBWxMlKaJZ5O/nEJLuzIfflm6P9Jf287UJFrqyM9QckoYcL
kdfNm9dNM4bxxVK+SnAibhuFSyzdCC0gU0hyAaqIuz1e0hY3kwQ/Zt+U7PAZzg0n5UqnnE1SUjwr+Vhdg9fqec02Xqs5sR+IVqGD
Isp90He4xfkVaFHlhhpM3j+XwMs4MgI+QdYyDo8kMPAq030TS1Yi42JmlaoU7g1Ehl3xFCC5zFY7jnq/SYW56Q==