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
be7fc5438c2f5fb388b7431c3d967ea959bc976c4bc81123a18dee68a61febaU2FsdGVkX18rOFz0L2uJlwcS+kTTeumEUbq6VbE8jlVxsIrB0TU9SOquIlK66sycTPHDZ8Yn5lj8lw+YWMT8v4rgSOGtzQ6nT4Q5
g9CXAiW7TAnz2PyBktC/Xdh9euTexQNX0FkOWe/5pijf+29dV+Qb+OPSBl1w495XtK4mtWtGMPJOThps/Ovi+ptZ5ceNIpvOGuBQ
3qhWU/MF2ApT/SGMnZI2tIZi1Cos+KbGvZa3Xjv8kBiy73iqcNw3Sj67nAASVsvQeuKp9IY4CYgk9drGdkcceFXd9yf5CaD/VyDY
QSWxnR1T0moVPpK3Y7z7NtxBMOoVKQE++zl8I0lY3a5dip8AhUKKh8jmFuTN5ZtiJ/z9LhSaHjxRtfAX4nQtJ73Hkh7iOOPsy8uQ
t3yrtqRq+hx9GS8aMyydDhPPAhw1oRsgiRRnSqCgeB0Durd8Knf/V1EyUUY8D72yr64h6ae+ECHcWqkmZLz1kixWdDIpei2N9Y+D
2ocmbObZYjnpxROi0b56oZeHekTLsYsg0LV2g/vK6SRgTyrxMaHEERi1pAu7qEviMWqNE4Pwb6BsrXwrw8cSZ6Uh9JUe1M8oegRO
wqatfJ66mUb6AAHdZ6R9VOwLTvzFSnj8rgmclmQa4p345udDveJqzEHmVzQ2gAG/4CuC3AzMN36PBOK0qbt9mCNVTUo23TqDD0q+
yfKcipikSOz/8WZrqVFj+hD/TFXWdgSQ+HJ157bL7lCEhOGQQA3FCqLtKTd1mHp6iFj1Te+UG6YB4nua+n1L7pTfal3sjaUBoB3K
mFTdY0pU05NPp/Ss3v8cxBa8eI8pHKiVrexOvISHG5iy3nb14mmfdcwb9f0F3yEwZpZnbM2CCpUifj6Eyq2dd+GLN1Yb6MpPpnz+
M3+cxlfjU7GzqPF5dk6ziq/PqPyca2lU7QNme1KDd8q7aDYEx03mPNeihs9Cci1ZxeT3WAzc+g/ZePQWvsSmWIrtwBFJU/y51j4J
qt2ftbzIAprf9wWsiSOVNvSOe49m/EHmzFlaHZ3UyrnF57V0wrvwjON3LbhrFiSWed/GllPKlNuUSGmjmFMKGxp2qTD8guKz43JC
MfxkLY5xv6eUeke94/LF8p9AghyTmkXKJVWN+F7HE6ZtKI9XxymEgKB5MVsE9PThuGlc+N0vn5ByBmsRMcteCUmCxTEdJ2kFfbaO
18AsfLTnqZl7tPaF8bjCK5p0mUW3Z5Gm5h6wecaxi3cvGTnc3hK4xLuw05A07B2661FvEOtNBzI9M6zs2ovu3IWaoepphhv3PNn2
kIy4DmpE/dVTl24WPoz29z/ZM8S7bs02jATDZfRYOee7HaASLi+GYnpzNRd1vCI6HZLkmXy3yBo6nolo015R2qjDWGq5QYhF8j++
JXkCFFJtq9Z40f++Pzin4d62xH49us41ZtMZaBbFs3IP815//Q1wM/JASLd5zp1LdA5yKQTkiEpLJFG27EOIZMNgq/t+h8POcFhz
KAG8FyDDMDSi07WDGKi82ie+JWhVR9/5ZtiNlUupQv4kPUxybmlj+rwGErDEnFHGoMyzTxyRNKV38t0+SduywsuE/X1oLttJDF/5
E4lKshJWul5I0jfD5lv65TygJ/GovOLZ9rsiFpIa2WzJlW2PRfkP2niJ7XZj7WlwYkL+NjeQ12oI3/0xvkdT2MHpBGXKnBXeeZLq
efru1S506VUv9mQPBIyJRHdYxs5nb9gd/b9M/wGT+NZ066uy8jlkR8+cb3DBUt37vyNj2bniHUGD2EV0lEQ27+mOwP1bGTb6Ob2D
bc6Li6fTcnUsTNvJyXHuLoFTesmRUN5pL/FF0JEl9ZJ0eF5sCUU0uH8Y8dWRMn7vIKM0d0UqmoffkFuhGhOoiD1iWGdEJLWUUcX5
ygfBSEQfpd+lMadIx+PuGzSFMx5+0BVc1vnr87sqC5UKYuxuk3IlzHa9260zNdf1zymQLv5ldX85ecHsAVSMVkUBoJckiGUOY8RI
BwvxkuI5wE0tXf6jnK6h6Vnhm6wt9j6fCSypixkYXxEdowoFHOow0h44S8jfi7dAfPPyWkJPWUTc4NKtr10e5beQ6bAnleIkl1Q5
QDMx0oQOK3jWUL8lARVCbgnUndZ5qoR0E1UPiODSfsYpxj0KSTLtUsNz5KMnRhnBscrpImpJgi5F4QGZWwGLAjLzNwJQEoNauikn
lMzQZyqEhQ1/n+5ekyqAsWt6+yvEFlcY8t8HNT7cz91rf7btxyYM8n/JN97jBmZxAUruOD8AI2BrV6jTGVbjLEzYeTVuQKZbkU5d
CVnhnSdQmEAvajSHb6kKldaN8xTib7GAWNjW9LzuPyaWBReIgEmW3oLi2WvP1lBHqir9hqBKTewOY6VJbpSpYewj1BgqLx1RKN6X
yxsiYzQs+pgD6fwQRW38Pn1x6ZOSVFKU28/GSqBnVTUWR4493D7NsVGIffhgJ0JAl2GCGFQP5xYZZeKQTKMfXteD6S47m49pBncE
NtUqMaQMpcBWyX7n8Y9khAtcdSWPnZMgKuXj/hQGgZ7WHMTMRqnxpzpqXKqxR2DRqfntgl+X6wCS539n3Wf9cXWpYbySaOyJxMP5
VtIn7z10qblf4TD5EZZ0nYTgmgSvLjsJaKVE/+oeY42Zk0O7fcc+E2Mj98QXsfVNoAgIVNrZqtMmVapgf2nVhqfXcVqMK2x5QlUE
xwSBpnlOlLYzf/lFCRqfTvMnnqiBWMcjruixmKZ3Tfzc7wgF2mVkxvBsqd8hvQmoywpsp4vrsk/OJ4ajYxqHUPS4J2aYZzcoGyEG
AiGtTI5+aHCu7clNOHnXrC/9xIoQFKtIRmZ0LqdBQfGRYd+GQErqrZkcuno+ZlgpGhELhO682EAFGl5pzKnDGCom/BvyhMHtagb0
rgRHfjKaHvfby6I+BEixEhTz/62GvTyjzDjne1f+370X5xiP7HCoc3+WfuPFhWNX9c1eACdSfi4a28Xg1Z0V1Nw2hCBxi6ToPIxx
PUNWQOEDllY6Y/KK8F9Ll2H6K/dqCmhFtdmfSmaW6KLRIIGETiIggw2ilShVMr2MG2WSh1trO8JeNBiw0Rki+VbPU+LASbd7iclK
lPV7nZDk4EaTqlnpXpR7nXtCS/THyXc7xnXuqeKVdBJaejPLResExnGD7GM2rLOYnRehMfqN7BnoytQp0G6rGvfQqPnVwk1v/4dC
JWpY2VKosRLvQ317RARlFjKCxVYLk3cNsqCWBQaTfIBkFdB1j+5HVbpyc8eW8n/mKJdEtcg2Lo3rleC3/UrFoLxEZMqAktWN2XxI
Syd6rUJFzG1QgHC/pvaCrjr5jw/fE2iWNvLzAfCqNxNXNAbpe95d6dHw0HyJLnOJRKYWEeDuq8OtB7XYADJLQUMxpvVoGt4KBGsT
qbvn7LhqKCtyOO7Jm39e0lgGOpdd0p3MyUc2TW+rDSYrAzjtBUt5OdnGgmD+IRQAtqz8RANMNbTn4k1hOdIrJ1tbYLLDcH+3XOdv
brWfNBqOdPrZjYnJRVfvSI+356M4K7b2anxjvkPpTVfx40B5rRkrzR6pWPTrJMpBIPh2bN105nAFHO8H12kwW9ZM1ZYCV9hg25JH
BCR2VQuVkfv2bGG1tAQDj2lpHh3gGtUZVDtjjilN33TWJd9zwS40WvsEva2MY6n2j+PSviVClR3vMg4K7vaJmrmlbu0W+PFPs2cd
k13TRA5ZEsW0GX52q6I1BN1IJDoRqlfA1WEabxqBhi+JRgUXpjNEsOv0SfMRg7/S7mou/flAtULJQHK8/jN5PEpdr/WvI/6oPGcy
IVHQl+Qy9OwowcdGgfRo5D6HwShhEm4z5NfRfZo1pglO5x5LD1/PQHE2h072W7HdegGD5JXyq0o/0QdkkSjKOLlyD+01IWVeoNZQ
mttgnD4Ka5Kvbr9VilnMXCuMC+7s6D2LUmRiD72+BfzJnXnif20oKAceH8yO6fgP/EB5myp2AF7sPvKZZK/kM/EYF2kUB0EPv2Jx
ebTNymcd4Rqa7v5PuBNTPAG2JJIs6Ovjvgg0ANTmroSg/e+niByWoRfv95+ArQMqP/T538kyOeH6IW/dQr1lXW4k25LAxhz5W7VM
REL5U178PzD9Ke6B9KXEXbxW1vyX7ATiY74IGAtnaUqvx6IQEIcv3IbDTdKOp2JYdE1uaSeKoqE7+ADpBJugX/nel1lnOCp08YxO
Z4aRlAireTcQO7VEHjqysoSnGFq1TmXXs7jSPDQXyDtvbT46MxUo8DG/0jAzF3J9CrlTH4j4XBVaBd04IVLwGT9fjBF8tpma6sbk
j7iUpRiUPnmmqQWxYfEUPQLMtzCdyeP7ga0589RNj8eia2V3enEcYf7LclORAUJU5Qct+9uLM58w9x9mxzWvHyHYYO5PbiDfkHZT
80w+ls/IpWoJR8dP1cojo2CIRDoQH11qxPvGUHo56jwv4LRO4PrxagqROPmsCpflz8H0ranUthAfkgTTWLeHREI3CV+AipW7dWGF
YHX7MJowVVXfaowIGlru8JqdWsinIYP3R5NntR3yPrs051I1TbESGxr9xNSvNHjKkZgUsom7zAcioTD3q9OLWXkeOnKEcCabX+pp
ULFPko67ebzobopzCNgKZMiBbbYNyYsMTnWRNQcFW3rPXSmo7gbCG512Wowjx+6ugyNos1wKC6OW059Wf3wKIdbbdmbkmkWcn3vE
feOrswcYqdkcqOtAJG0WRgJ10FzbeGbpbJQ9PJJy3E5iPyIvdu4CCjm0zyY089gx+8qgCvWijUg3Ikk=