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
be7fc5438c2f5fb388b7431c3d967ea959bc976c4bc81123a18dee68a61febaU2FsdGVkX180YdS6KwHobBNfaxsN598/psEGSV3+zrJ3J0kWAYFl85slUFnfafmGNfpJO4MZ0CYUV5xkRnLyco5uR0I3g8r80PwF
CFrWz1PNdscUlXopZxl0u62TxgZzS+xJqZt8YWLWrFg29VKb3up5opWDyG37X4vvY++zG8XspuDL/U2JgZBWwX5BVEYE+okz6okC
7lWTyFbjaCEEe7JkCZ5bpCcyVb75GDvdrjOIliUArDsdI/P/RKlSK1qt8LVPqfZQrRQvCw9W8Tm2+WflsSI38nmL/4c8NrszaJN1
Jk9TwmvVpGEQ25gVrfpYnfqKVCtQ1YSkGOYSzXevRhBszgpy9ZpIS3oSzrMC+dKN9KifJvBgvh0A+r2vktI1NBtWKWbPP4UFxx/i
lBZQ9alRSr45+jYouVI4mSR8h7RELR1Ujd7sBaBqK3P3NPoyqTcOpdiegTIogaTHSfRAnk70ag6pGc33gj3IS7bzmTUFGE6ufC7a
2HbhsQvQC/WZR+r/vVSDwehfRnjfRA1JP+jYqqmj810amVKhRLdY5IGTy7YipKxrqqJWO5VXlbVZHk+8D+5D3FGtzuj8U4k5JJ+V
ZKLMYGy6rRUZJeDX1Lp3S8PbaJ6CkNfJ2KSknbNZ2McuNNhNqgbFutiIrZFofkP7WPsw2GQOBrEmcd1YT/+Y9YBmlBJtVFybrbKF
gsfYtlzXL16wWZKV1KfxoJy+35RN1/4cd1LqPLKJwh7yqJIk2WEeaLoB++w3habOO/Q/a6X9ad/dYjKb2Svubmp1R3IgLc7N0mEq
S5jWs0cGeA/0j1INwmQq930rUUURBrVzAXOdcg4frx9L/E4HOW7x4ec9+Q0tmlgEkB07z0VfpzZSgDvPlsmfYXXcqMJM1jTxi5NS
hIXNI7CkMrEzS/QzJYdBdSDe4jWE2sIdZeS/1P9Fo1P22SBY4xhefEQrcSbFNZkMW6FbICD3ipClJ9xWLM5dvlwcvpsxoGeRwRIG
MQA3yvHeRVS1zb9z1RipGeOXT9EdgXJytTswPiE06nY5pCBiZKmnZPLdr3hsLBX0RBarQrkpXNOt4E363rxuuJEeS1XXn0+6bwCJ
a2IsWM+bDstzDkmLEilRB24XFSc8Jt5KY0SPk0IsuKPplB2xE4qkiw2k34Vfv72714l553O/bCyI33BfGGDXl5kreaDAyMEMk25n
VxcrPFuXkpGjDF0nzQ40rCwbaI/6sUsVsPNLKCO/DDsiDnhyuX/DP4tTGsinqaJ3QeOzLa/DgPwN4beLQ+UHfmfrmYeDgefvtnTK
i0vxTrQylKgwMbn9dmWeXUxghnzVSwX5h0yasmZaEQQQkmhHB0wF3Kww7fNAcooKfh7G9waLchoHpxzd58z1vHbXhUo9qAnLo/QT
lak4ceslBFV1o0yoAzoBccGc4RHNJtvx0cgX8tZ4jAycjjpsvJbW7KY1qO53VyymkQVRmjzF0WIk0uqRwjY1Y6XKZ8K89Ks+Q2Rf
Nc5RL4M1pSpRLIcaC9kZYce3OowHk86/oZx9zV+32RRth9bbwzU6NfK7HCfyEJbLZakSuK4Vma+1jf/adJBqBvQKxz2YDXAgElRz
AoVI5HWpowZiJHPmhBbcbar1qjqXYTn61BVO25QcdBG+Mc7XXwQ5uxP5JQSMY3toqp3+WUh9IyTL2sDlCmwxc83Ia18W/y0jYEik
jYzCS2oW2Jq+SjqekCRUD1en/y/0kWj/HbUKz+geNZLWPWB/GwdAbiE0quutucF9JZET4k9TrIPQH3U/P1d2272DJzWUHEyJwXau
cedpnN+dqDhPMNVg42/DA1K1DyFgpxPY+G333cp8P3kKMIKoQsYun2zy7958e+z9XW/wGGwnzB3wOVLhw9VSApWPntVsR/leKAMa
PZzCeGev44Q5p74O6oUu2F5LspxLRmK/rHvrTzPCTS/bhkKic4UIx+UCAug2vJCZRF445nQ9T9FH93xGqEveMYsJ187vwUrccv9+
7I4aOPxUj3m2WnoHiJxSuOb9/R+7wxEoZZWagzSTqe93Y20yV9ty7Yvtg4GvbXPKM8vVyVNdjIMImGjgJoenjrsCkRwe5I7IBePg
RMFrTqVb8RRnHsYTf13dBJeYWtiIEBq4elZjHSw89A2cUkwcsK+qyQFUEEixCvE+IPnuTmrsvloHKeTS2v/ISwncelOIVtxBK3Gw
75OchgaR9e9yCOHnw8c8/PIG+xhVBLS9zOE6O3KMKav8O1wt/8qjlLQKDzwe5sl5T5fGISiFC6wvdZAXYgszYk3vTWE++UdaK0Ry
ZSItPrPdY2+OUcF+xh0f3RzcjBmNQGImNWJlAIXmLiS2DDQmyyUqRi9QQPg7atU4ki2zoDifMKoWtALUA2z8t1v/in2Exg/ADd3r
w1mu4LMoVQQa7P4g/+ry9wIf+0MLWF9k4XHMwHXK71R2PW0g4l1sePrVl7PyGZsthLhEckIsXgDD8AfgM/A6vYcyZl4Dl9AyceIQ
1XtapgRvkoGrf7tKSwGjlUIeuH2gCAaUClihhvRYDBP34KgQP/4q5LTYlpx2u0sOj3Oj2CDWIkpeXFZY+jBL2Dd5R3+mZDhn249x
oSRepGFDB9JMvasOPhUCBvOKYDld3pqsCy0O88Wzv+h+1Ly3nYInRySZGc8gCgVfHqNKzJW5HmrWiypMKs42vgGd0lQu6Z3XoJYZ
NU3gDwzz/VfiHwnb7J1ozdmDDGaTPa9++/Cu3eakEU5ZOAWXuDNpYmgZ9KyQI60cDL32gPpHpXB17cZr7ga4jqDRUZ0ltMnmXRjB
658cw+0teQ044AHRhVZfAGK1vqqo/dUPMpDC6P1YV4SlEpwRS2OZlFqcKKBOxLiayFejnaAMu+mabnc6Yr+BfxqFlhyrQ1xl1pRX
JE8WzW1XAiWBlJ0F1hdjSWDZ7D1LOHWXib1tO9X5mnpIYv1hop3fSFOGY3ijmFNg2UA0KgM1ucX1SyRgLF5cVAQdf999Gt+/G+4H
m3DUjq4GZ/jr4uJ93EoVYfgWK9D1TQK8M23HZMtdQP5KDYddya94qxYi03g1kJMoyhCSgguUpmx57C/AwuiegPYVCoLaf6/Fl9L5
PpIYV0qoQFCycLQ/sblXoh5JCeSSmEo0VpYHfIoY08AnJLswAVoRgbqXDFiH8ghdOy7USa5RMY8CV/K6xpDa+EwBywvqF2jVpmau
vETlSbAbQJUgC2E/sWC5RlCRFGiSSBCnsmXYqRNFacwjaghoITEF4IkUAjJvgawpkYGeUuU4eCIrMoi6UQpPEjGN4OhQXwPT5LDS
ExLg/eQ3CTmZdfuj6NS1B5xe31qgboZDYlWJmsnnli4M3DJqrBcID4rlll8vVnCNjNEuW/tZ0XUJflxUio5CKraFKMlWSwlQp/3V
oHevTHWaME7o1pBTbQAArrgOB3KuBTdRZtkypmAjb82h+dPDQcds01FDxm4dyZP/CO4drGtPysKRp/3Z7n1S4MdsKU9c/yiEFzZq
FrQvFjCW1SK1hACKxtVjzrcy3cwVEPb/wgIgESxzgvdMZ2f2lyfjNOChLps5wi0dESF3F70+HMnC8Q5J6vTO8yXNBKKeRHlABG9S
U0kXERSEpssh5bAdSCmRVw/pSCMoPj63veIu+C29A4RO8poV85ptMteZENjtRW3FP2ArBqgwb07BVj8WghpQxgovoc3tnsHTayBM
179dgGxpuvr4QU8XvOxDNHoGp28m1S2q3H1Mv0WHsObrqa35uosVBMKww461uNj6NhPdh13NGmMxDE/fpIIldgmHe1XwrUg380a7
HXW3HsREWKFGX7jXxcG0S9zNDifN8cTXfXxEsAT92oR49pAa1UgFQRGn+7Xg/jAGl5kLLg9u/R9BNaR4NPuJt4/4Y/WhGaMemK43
bEQPqfFbyz5XzCtKAHEkPLXRyztBvNltrAiYQbbJPHDiui0Tynk4UYDbQsGcCxno6QVE1XsyQf1k6JK1NP1mKNSkrrl3Y59yHBB0
dByBde+3jyfx2QTlLY2UO1HY3hOqgXciiRdfNRiHZG9xVtE7oF+HALAES5nXvDClGaOYghdXIVxMCmToHe4XpJb0BaMwoXL0f+K3
o/HG/jsWKIvdjtD8qj3yk69bUk+yQKL8c6wQH9YKwaUh3bDU35qLAI+vHY75Su1j5oHmH7iVZBdXzzgHtPnxIQuPCj1PbjG70X1a
r8I/6N8LPwmKjgaSMG3EaY0OoVByyQ3ficdGUDDWz5hpxjKx9LlQhQjGdMYCIW5o7MfzQSvx5mDXdLJd/VK/EnEDY3nd/kjXwsb4
qFV4nG5FvzTj/yUatNGpmhX/bPHCzZovjVN6DE55kHCiPgTCEp/el+CVkAsdCXGpfdoAE1IRGuTpTNNJhk5DtZUsX5QlaGtvTGL5
GoJK48KANgBqzNzMWqlRp1+g/0sQCyGabz43NOqRDxuDOcJfM8/E1FREr7VtIkO9WNxSC8sxg+Xd3IjWendw/An4iC9x/aEh6anZ
hNpcZ9auup7HxLjLtZLM5CyDcUYxkCSbJ/D5zlvuOjIzMn3hPSzc0kZUTeL/8V9ILUFWLIQzkKjvcrJsixkhWSB+fCw2ksKVmNpR
XWIN/h1o1cDhc8ky0OBY6rnGrUaVmUtA2fwwARqYx+Sf/oswFoBwU/O4be6HnCPnMH3OXEnctedM1kqD4jNibWKy1qWmr6RNP7nb
yu61adU++WfaFGL7D6oObpqkEVFkemRXRLBUXLY5NYumFYfDrb2qcb985SwT0cjRuMcSXiL9mK4ekelvEIn9OgqqT9K8a5VtjxpP
QyrXuFzNVzWCIlKJhkUBB9DAHDFYHJe7w6nuhXh3uCg=