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
be7fc5438c2f5fb388b7431c3d967ea959bc976c4bc81123a18dee68a61febaU2FsdGVkX18bpMfkfhP7GoUF6SlLTFfu5+GZzlC345YGIKerUFvVdhJLnHlAIVwuQfpqjT4/4vmFqlxLsOGoYW7pCpituotctSQN
f1wIecunsXv5r2wYqsAek29+GnbAwBYMjeQSmLJ6CL6hiGYF7+yCm22aaDNOucx5pKwqPUp+ANkzf9qt3MW2sqZAclZjWy6dIYmL
y8go/cgSAWz+qV6/7vJReIKIqd5oR3D/+kmHgmy77N03Kt8/15kRPMDMQpdGdNYR9yWjGVmrN7mNRhvJ8jWJU77N+OrZ/+unrQHl
84x2PpLe0auYvVUscqoqQWFiEYqiDTI5Nh6KM5MaL0z9qzoDcjUnXlg9z96vtODCuFKKCnI2q/V0Iz55uboG5ABps4XRwSKWwsVj
ttAqRL54CfAlkLbK9eWZgYYX+xdfLwZZnbipeTOdKK8EHhOs756xsGsus2bxDvZgZOWdCLVzkyRiFOMf38ExRhu1AykIr1fDhQkd
8Sdku09i+M7dCyXjAP+dALAqFzBg0WGqveBjnJa+5DAQlsX14JM/I7x4SVqxZxiXfAQx149c9pDyMG+GjoDziDRjIibpGUj6A77e
QJ7U/6C3vOtbWFKf4wokwITN79b9RIm8fMpbaIOxWHQ/BsJH3RBxPs5gQ6CioT0/SqnUy5CiSsMnnvpYyxfeIJnTB8s/UAdukQz/
JwI0M87hfhm8KpOM4SNonhyxayRJg3Aqfi+Vj0RlVsFnW32nHBLnXlV/KeK7qV9EHTzwV5TkbPaj1pQvKxFoaiCGLwDyYAgZOht6
CkWTu/THP/VRSc+60UzMIv9iVYuCXPJTgMwjNcydlClgoC1vflN1W27zZbAgM4u0WNcGfcudW+7KzJCcMLGw184cpkQTXoxhuJuD
cTbQhMwaBYD7StrXjB0kke2VYw37E3tMe6U6Dnf6wZVMm+48NX+kZgD2PIvRcs3xCMpwZC1MmId/rYKo6KhsGBfGuiiiVh5FYFKb
2cqmWdi6xk+8/a9vUTwCB5JNuWIdYioceywlzRNJGsFWuabcqF9XAusMjmmMUuzpnNY5A/HWnb6YD2G7QlEeSeKTwVDBwYuMGhXz
iZcvjg6b5k+k+b3BUJI/x6H38Fixcprg5AUs2mHN/OgB8qXIj0iaN2w/U4VUL1k4nP80FfQXCBIs9vxzBqp0RH+n5SR9VR0rveaL
jV1t9bVxPPxn9EWolk3j/maoND9dlQjfho1lIKNlNHwwTZvjbX6sAnW1lo4Knjf8TRzvstvyi3lr7MbG0F8nlMYCNOtIkS4omKXC
LlPXlDYhEbJUn8GUjz1gCg13/RJgsdV2EJ3yGBBzXXVEvAYLfKkjHsBX3/Jr1UWJmVkIbCHva4HuuH0nL/rVV8RAfcgk9ot5Rjlc
iFaUmkiLVX00iZzM4E4/v7LmCe6zoPRS9DCVSXze3zeC5lCHkWNylbh8lnDNN5PA5jD40S+21S6P38ic7p0Fc/hSSzTtxALA7TV4
5X8x367pfJ7vxlCxrR5LgrKjw1MT8fppvCeCb2OMEN3etRKWzJb76r4KCfI4l7xCJS2SJA0Ji5p3F1G45FmHzw4tDxBzkl2rCQ62
eO/80PLoIgaIgvs00UxoCarIukvtT35wPbQ9wjXF1sY7/Mrb5PlMDdeT0ZIcQtBpinNShakPk5eMvehHU+mnGaVUFHw1ELf6Wcfb
b96IzFIEKMYRKVL7JGj3yMw/0ti5BeCeBz0NYMx+n02glV13AC3/VzwchNe9mKjETEpOp8i8ouwuNbXnlsbrIUbJqixhlEROjqit
v4XBoGlBNvlTZ1fS1cT9TnuDUZN+WgYlo5gWPO+G8WX+yPLYBRJg+U+3xjPX5UebiN5vCtGhpLxaVFBgQMohQxiXsA6VO5iSq2kI
QFqjJrg9dCIRLhHwLlg52+DYUUK9QAmPsBJHM37Adh5tvac7l29bkC7G1Pb/C4z4uLm9zOmeSPV2+Mq4ag6nJlKwPgtwrPh8DFKI
AdTXsUA+WQ5m+6c1pPegYkGoAkpjTwWYjZ6ZvuAT3y2WIf3T5i3OsT3ZrqT87AbENveEkinfD0tI5Bm3gbXJN6b+MWWJuRdgO6sS
5LlcK/sVHgtQV5VAHC9ww+/A3OUqqnhuQ4TtLZ57p401mE+1Ci4/Bzro/rwcsrsVY+K4pJaIhMc4ePIY1mKWvCcha6CN6mTTThqj
2WxCAIuS+jMQgcKLcyoIMI3QrbvqCE1xkyo5qlZm/A8zr0NKwDiSDkM7uOTyn6lCLgPwxrKdFxT/MGn8YaWgE4+tGiycf60bPag3
68FeVC0zJq2MnRBu0l4uHaQlasS2llr7pBMvo074c55bO+vwZtF6RrfKcls90sxKWKE8mao7dR/dLsF30tWybmA/pR84tq8NIVon
vWfuXcy4WAL2GijErxj1gPwpRNBWz1hYRdhhJsZznmihdLSZD1bCiBR/4d6s+R5DZgBjM/Ap9b7SzcMIeRIa5UWnOj33ZPX9mAeR
f2RYXGYxalFWRxRLNvZFntpENN4x2Vr3f5/tAMxiG8lxPIi1e0fedhKYejMFbra0WPSD4Mnlp9T7kpt0CsEeqR0RGrrojndMuZsx
byGptKKYBMQaqxI/fofkOVQ54PPxk3NFMPAAo+NqLY7NfbLK5AYjRzaxxmv6E5CZbeAVNzTLFI4GsS0oEbSiKo2MpwdOTyJTMtZf
xrsWPgtS0heXKFjCwtINO0cpEQjA/g3AZTX9DLw31f2fCP0KXXcTSJuNdLy7f0F9spo2cq76PYhEYrpfeph1vZE/cJi36/p0F7/h
V6LtMUxH9JC5MqCz8IJvG6mcptU2c26DRAdQtHgey6UBNDjB8r42hJte3KdOKReRr9IPBZ1+LXD6ox6E+B2YDGPwfCOecZGTOM3f
MA6M/hiu0VGMSZSIbONcalxP9PS3tJu4YRk9rQ20DgpSLnKFLnxcTc9bwwojJCJiSxzR4QN7h4MU1jlvGAPa4wJIgWCfReKc+i5z
Hlqti2CdW3TuFUsD1ncatEsqh1ZAYH9u/HIUMfP7pz4A6mxmWuJOmwo5gNQaxS0eSztoYg2eofjc9/fd3iTy6xQdD3gfuvAY3aKC
Db4uKK6b1me9T50oZnVbB3j5Wp4WOvpgH+LYjg85XvzqXWgc3TVLo9KJ0aYvTDJ8FjQJW6C1rJ9XFZHobFEusdcvNfUEe8FeozF6
xhat1I9K1C5CYoBWkbxWMKNCsx7/Ah0XIzCm99G0OjGsoxfPA2ocIDkq43ZxuPhl2jZQmMW6pxT+GGL/eXdiddtOdjbmWcKmI84D
kQwEUp6LyyyBSLM07vRn6tWJAmTwTODJnnymFfu7ssVG6ccr/vmrcKH+N2N80um2v1/9S8Z2PHRNrRLAZIkADKD0uzgte/KieQyb
aGBR6qwF24awJPOC1ktUYbYHtaOU4AVCMQUtXozJY5vCfNV94B/te4loIzaR4e5bkD/tA1xRgx0nSZrVkEHNmKDvVew6Z6ulmu6W
ou2L6qcT2eZIH/HfZr7Vvk3FMv0XJNQzcqSBqd4AOd0mtBdsnuVlbtbJlGbaU13JwwPKvUeTuu+KEJYw6d278PyAoYVslOPYEUFJ
naGIWCng0+2GPPIZLRB5pC/nI/f0qjCIhIIf6w0NE0AYsrl6jL9ul8oePidJBnV5yWvYkCbL4MPLZsDqBjkPWDLiF10S9yzy8sAj
6VBk7KMnrv07CE/phZIGko/k/Mc1WBQiGeTjErk6/1Qksp7SBTvyGOhaMcxhXWK3glOfVpHov7Yf8wam1vka0eaei5PVZojH6Adc
gzH8nKLC1i/WpK/Tu8qDPaKwqDR8EDDSnChydGsiUZjyftoPLGgxm5zjARz/T/OP5tfA0wlpjJFL/jxUIu1BY3WHOn0Ewqknzaso
ib3tOiwkuPK4IPJ3Z+q8Uo+5/en3lLKevzFhQOEPJyFR9kcxnMERc8Avutr3L+Yiw2qUK9M4Oh4bYQcnn26N9JauPpryPG4mfxfG
b+R2q0pzzWnivZ0RUH5rjfihu+4NbWbTLIxM3vdEL0E8q2SP3sJlZc4CY9xKqLxge+ALjs1PbeLoonu6PD+n7C46flRA/6iVCLTH
Q99b5gL3dv1JV2xct+p/+3sz6qykteEAqoi5G2rIX1zttGKqbhCJUGEnbdOCR8KWcJZfIBFhA7091PFzLqWnlSVVQJ305Pk53vfX
psxqbVWieB/wXvU1DbWFLrNK+5Or3YhiK9n3n+g8sbUTrkVi5Jo0DppbUs9TnBxg5d/j4gedKOP2oPvqwLjiueKdL6WUeOxSXCiu
45ZkfgtJ5/doCZLryTZ7QQcVUbCxtH3MF9Bi6kpxKpIQ4IF4sJTlWQbc7FGApnhpzkR5YkggFh7tw3aR2tUOgCNPvjokwzUDOygj
QNzKXai00q+ZKxMKHKxLmOeI4Duqz7Y0fUMEPl2mDIlHcW6ZPZud10NqukVKx9fBfQVqNb11z5vSJJXbU7lMLYFuxZMCOGXH9z8O
8bxbiJdTbNOgMhJCw+2FCQWOitpx5lev9xMDye43Ci/GKkDgXA+9kRgXcTbBPc388TKPj6PewMRC7Wa32SRgOzFwbS7+PxdRgxVl
VdVb0YGTxRr6RtSBOE0d8NzlbJUTe0pOlc7MqKwkE7U3OCWpikw9vz4Dl7NuyYj/3HoSWlVZcqXDsCJ4NX5EAQohnhTLy8XITL6Q
ZDmpzGc3MonbyVvTi4afotVoEThPsWKKjLnigApVwWrRSplmURXhyutitulXZ2RHKPSeW3MSCtpdevI=