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/b38ILBeYYjrjjcJeywWwVQPnsPlOAvR/uCG6xFOJHwILOPz4Llrkr7yGQE2miaEi3E3H1zdrSCvv4TRmEJnrTeArb
Yvn1SZ5Opb+qqEd9w+v7w3tR4MiPBv/NnPWeU15RYp/fokAJPJiocK+5otMtTpuI9KqSudD5oeJ1R7VkOtbA2kg4IcUa/JtlrzLK
s27uIvT0+VQvgNmDg0vcHSwmfV5ZLTFquUJAS3GhmdxDsn/qkDS8N/yQ2hnN2QmurLcXn2xgIzTI2M4pY4UCYfjWuD5rK30ZJZ7z
L5kbzZRWRWUF6bUVx/IXaOmb+MdKdYOUagGERAgbFGXxoPJLzE+8gBBILPFbjOv4s+0QyfoyYOtHdDnC8XK0vbS3hWgEzLg0ovyX
EblV41FTWU8qF6MUBID+JcjDKNAjXfwjyMzhT4y/eORS+bOiUvR2UlTr9pLVLPso6huvRdvlEEUpVKh+w9y9m4V3VDH4H7UibH4d
gfisoqY8n470FLWN4cwed2h/iV2d6ry0pWUWMujJK3/1nr3cf526mb9LE3+xHS+2MdBHDNHO2H7deYwSA37zeEJVeTWA/tpIJNp7
g+FreRoCQ4WLp6RdXZUffWB7zOtAgKejeImHxQCJOvM3p02XG/f1mpUviLkKLmZsRGeQZC0Nxh6UhSdiZUhtCZhWggfmGUo/b8T8
PIX7ADWJHcA05xJXHOmpZhp7vEGdkWjbhnVPEKeocL3NPcUHWKJ1FXNDKX5sUw36CbKmxtVy/qMxIorvT4A8QSczWchdmS8LBXhA
fZ8WHzS64CQwEx4zQLj1ZzLb1JYQy+27XnHffPWWwVczbi2yujgcN1MotN/E3zPcD1udGmb13J1QSvIYgeG1nuQLnmL6NuECka74
tSFdXzBxxJYgf5yeX+G0zzkdGv0c7aoCMZnLWGtYhFHQbCE6EEg83vT8pS6JmRK94fXntfb+1TT6T11wVoKDb7UyoiMNXCZtrAiX
mNzsLmUzFH5tLtVcPGfsh5a1c0OVfD9jZkYzMnTpffkHGtnbLVW8FA6YtIrIlibZSDqju7A/J/ams5d5VyZFzcreNqGTFmulO5H0
YBfLCCl0AD87IIxkM2Vzt8G/aDWxI/fsD3xIqkqP12h138e2jVXBJVxaw9dsKIF4ycGAeAMrA2RzJ+SOFsPwZWIi0KiKqc5I0Hvc
c0OwbhvjigEC/CEFMrtvB+JYvab2C+OX1TT7byLBG1LaZt+BIA4yBdPjNPDDNig0NYHvgtdUOzp2GOJXBR0a8zYzWLTOFz82XrEB
A6MUMk4KpD1vGrYE2zGZQWSx+Yv17f6IcBMTY3lJ6wna3qtkr3WLTevt21C2hD2w/EnT6AT0BKro5McH9udY0tYax8C3D9plSREE
RYR5sGjJPI7BIFXYB4quCnPhchSuinUCI8iI9oeygcgNXP38AEVgYevrfGCQypTnHbJ5WLINH/1d1MvoX0svMlRCtlK2F2kcE+Uy
C1+HJsxE+2bK6b1wr2TJfVmGfuzS1CoRssZDT4Xnr/XND/TjBA4hguqmEmFYb8EKomvdWqUR/ygDCAiEIHyXX6lgKDXyGvg2JYvm
/lGQ7AsytdE09wAmMgj5vyvZJ0+vTWtaa0HG6z5LDJQxUcPMXdL+5voRseCVUnIEG6YwsTu07dd6LYE+dGFPATG+4TArmUvBKvrp
QLl7JEWllA4Ire4zXzdg2wizdefreQaBd+tXe/WHwtp3dFaKynKI53B09FHtrHOPbXFg4RBceRf8SmWB3YOVZoKoR8mAbYUEJ4n2
KLlhU1ujeYBEZ4Xkqvod6OoQanDRkzk/j9i93oZIq+aoT4Lb+HfQHmGHyCUdtbSc++SOV3oYfgnSFsaYhPvoeraY7cH0PSLnzieS
Xa5ayqu4SBO6Wrh9U7qND69SJpjiHNGcns2B96ziy88EdHxK1otgS2ohYpgJwgUJ4efwZbZW1PrMD8WMwA2n3ppZ1ZUdsRN4CI+p
B08iefg2hOxbhhCoMy3mCVbR2QpGYZql2KR8gVkNq/Uv7JVKBdcTtB4WViq8lZGMQQvJMH0EuEaVOzRZz5fgYBWb2gGQoXSVJBlp
bjqt3us8SGryY44oCnOe3e8JNxyZL5mUHowj5p+gUTJLGWm3OTlmBtgilvA096iosgrkBTpNGIb3J5pvfPkCFV6mw3m80ewCHBgS
1dwvypQO+OU8d9jLtKGTCyhZYTgyJWl0NHjZE4qqupFozvTd+a8uWBh77hISOMe4W4sjuk0603VVWZKea0O3gjVywCJY/J/PfwKu
JFF0rIYtcNFMPglLOngMeCHTvm4wDRn/9vI9qRbW/j6kXULA0hIo9sH5YUu6bVwQoN1wXo6fQXSXehvEcUnnTRUVHWNEevIc+nKR
BWVu3y7DbOdL0kK9yWFtsWQSH0hdJXDOxsUDOEH/HXLpYKRVNYiGTQKvy4s/K7F4UxvuenNb+y8iWJoMPnAQdl2ao2MTfZc4+CF6
31ontnqUjjNuqoBnteAWERxTTGo6O41UWsuQEQmLZkHxrgEDT076yscZfGow7fCDbleH1fcVAD+U3fVVVkpT+C9Er9IBsqhXdpvb
DSJAYtrBt6VMeiRQn+wbQBXrug2APDe48tEURyQ/INm5kCiGUBryhUo8Cf7Of9IcmjuMd5enuEDLKWlgc7ZmsIR/s5W3k5n/yfAH
fSatjSv8zrVKjhIroMvOhvFyJVChWnAnKD6RMjv0R7FDez/uKjPlsYdzmjvbJIkybxfKI0FnSTIIOf24cTPBgSoTgrZvCVL0hnFj
SQJ7fukB/hvK4hrtX10BEhvUlAIFGM2S9EeIYeySkGLBzOZYcTpyONCMJ9t2lGeNhzXjraM024r7/Hn07X3nDZEqVW2fWQ5C4dVA
D7XPsWMi587gIjd755MwhA6Nkl2/IxGC4l0KOUdOMNT3x1N26jmWtpNJT+KLKXmtBHiCotYaS6rXppBBRROkoYIDiT7czjiLp+Iy
7GzICSMV4n/Pvz/Re7RG4IGpUAFBektlAnszBzWIkTLpD2dQt0p5MaxQv+8IfVlSkrdFN8dYaoGRiHCoiXnKQjl76oEs26QN5S6k
2KRfJoi3bk3PKkKoHPUeYhExA+T3oqWQyJqTl41A7QXRztF3gMueUpZSJjKAmpXN77kCK0v0x6YvJZEgUhW6KivvokCXrWFmLekH
bE5RmhP75Tq6abWCSYv1egyPKvY7qQK9iNz3Fh+dRlIL7V4LnKFdOmpWfs86xRIsV/NEWpxxsU31XWp20myrlZ/wsAwJQnXwOk5k
IRT024FOpttf01XjPF0XaPAbkH9/M5bNH4xgeh45ZCAfzwA7NixAKejnyVZzeQt2zTV3/sVCR5CSC/siQBbgZ6GYYzH21jPkOqLd
ygfMOgCRdUWuukk51WqSoaXFQfyleHQRtp4rjXnlikKZ/M9slfXdeVAUWFI/IbKll/uUn8lHKr7QuzUZoV29lb4gA9l7yP9ChflR
V/8FG7ji87TTPJaSHeMemTcWvXgUszDUVDHjp5brHWnqT29vi65x/+Da8ra7Z1WftLwoyGRm/efotmogVLVuV/WZQRhY1MuSBsI5
0Ptl1HD/SODb/fpqZCVEgW5bWn4G0es2OuJgWGH92gKgJOf0jSKFT7hrl2nrAzjqLwlNHB+4jxOtcL/2LaK2xcyFHfI7RT8QFkOe
yeFK1ZVrlzDdJaxh2frkJS4qUUO6A0S8o9myntauOKth5AmdYls34RZwg2qAa/YCsKzxT61KGUolP3BQrmjFn6qxHf8J+H16PDD7
BiQm3hSlt8vi06RtJtLgWWeac9q6TJtHnHkOucvbzacjLXidWh8fXYUHmy/IGFm1KkFSFxyQTGFmAe64Fnj8XAZzRw9/8QbOypun
+YsvdCi1/KVZ+iH/7zcf8u1po92rNc0trE3BmuBZ5w+719Rho6IQ6GSLVoBnlj5KXw6X/39SueXXYXs5uOnpfDZ8wBQyGwrFTNGx
aOMpOBhxnb0Vn39lWwuW+3OIwtec5PggtdJJjYxROZxk6Kz6BCZJNHolJnDoLqt8Pu0FsMGLR/ANmbxLdxbV30pnIXqV1TA4DMMW
CNCB2Tp2LKFuxbeqE6ZRR33KCJjqB38Hcp7G61XRqiucYjswjEoWPbn980jPHxMdZZLK5jShJFnV95YxPjwXl3qCxYHr+/b7693D
++ZxQIJAPpI6eoKdVgKC2OhXOOLEMRb7vATwS0cO0mgkZL/GTxIBTWgckC0QDPy+ga616xWfryomPgnUG9RG7uMHLdelUaaLdUvK
BPM7M44mADK1kENQsb2TSSv/DO+Q+e6yhSQPwh4UWQMta0BJO8KivXuugkQNDGtxkffuQYchANuS6WQP3UG6gLahp/D3gXsJYSSA
JZRtK5xL6ZD3jbivzqIFoFe4P/tSR/yNDASphruPZcPBzzjoVD9l7x3OME3eIHTiFA5I46B90AA1cqdhQl7ViHrxGgv3TGPVbhpv
PbaLW1ewGCATHMPhrVvo851eV/9rDC0nBtm+hQM8AM5LlzRmDWchDbUQsPgIAM5glxXHKNme/0CU/4Z/nPgoehteDJi+EYzUvli5
AF7hehr1lfAW+Ht7Rps/JBC3imly7rCSG2uX6Z4N7QKF7+mTYY0nObyRLHGgd6U7YB/SCgNzdxbpObny6nbgsS+fujvgcten5R7b
aRhQ1GqFp41OEHXg+1R605/Sqva2HBiUi27VaXE2TbwUTR79TGwwjJs4G4oj/ZPgJsfWoVKhiOBZ7Ns=