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+h8at7TO4tj6kL6dJ/TFoeLGGcmjDQQbh2cKH669wRWzybpsMHoMyTurdohPb9AecQjmZuy4joRKVMENuVFQ9vh8c9
JfMqk/OqWYI69JIKfeZjz+9L5PQwDdzgz3m58AmkrkbG1psqji5+7BzsJ3YXCXChgHsxOTTdNnZMmAR84WzGRAr+ww9NB3zEURGu
qbsTIjLqGn++9Y/22d8qN5pmaTYtc9+HxGtZT3sh/NAPUuWjOayUflRWLvElk5WgFrr1WO3723733G4kf2BxdMarpLZS9gEpZeay
grzEr+QN3/PmnhNlcQMvinA4pYFiNpAIHMd+qX6aGCV/MqJlOoJW5yhezb7ClsCaUro/Ob3vzLx4sUWEy5Y/9yB2H/q2AIRo98cR
YVxxdZYUfXooT6sAewuhB7U8J33yQ164qwWxlX6MuaNRpGMW5BlGf5sszPejs5cCFZfTmaZPDdN1NZXMC+i6UCouftgM5TdW03rx
WVkJBUbt6E44gAZrQhwQJWsuaDNf+Fuy//FOet5fasBdvFGF4OTl9xLjg6gIUHa9Prn6+RPGy5AcjDa53sRY22+ZN00K/dPTCItQ
dMfFKxV0q151+Zyp8+OnZLXhpzg/MmHf77ICBCYWwYelhK/4g/1bPwI98BMXtXp5CF+7R7NyhFg8ELU+3rr/8Qk9LREmgreCfN4O
i5E0VIAqZ/vQCKk59Ph0jseID/8F5WrNRYwmgUD0BEERObzdUwwFevshrnusOiTtjDtk2iA41KgfFjP5DpV8pij61/HMJ5vBJZtl
ffe7p8wA+zJm3DHcNH4sRFscKmL5wy8mzFLkpqrqxf6DlcUKbqsIYlMZ3t2NYkR3esz1/49CP7064hs7qP8TC6O46fvVqaB/kpHD
4sY9xi2v9QZC8TQHhDOxDp7gL6MjY5VKDJt47dQma5s5egNADY+5atGnnUKzfybE79Gw8rL+gTvvQ14QAonOdxjxllLdoc84+ayN
6ZO1OTnHkcvo2SfXKewqIqVCPU7QtuqKjhWxKNNxNExRKgVtAS5qWhhujPo8B0h+PghpTDZSrbfmbAApifYLfLh29wB9rmtrHLTK
xJUvWS7pSspJ33M6k5rvpuQRxzJrggL/f3KlbAlTFqH5vDqNwQZn2V670tRH0IxG1LRrlHeKHTUTF8z/zRIVgJcWRKkChmpioCZt
AqhXeellqGT/5tKiZAsGt8wtI5Ws4OSbQP7fmZO4ga4ekKiQN48D73d940WtqBe0AP4rg0exZ68ejnohv/FPnSKaydZoiCUuqYZu
y7qq4uHK5qpxes9Q41BTa8Cz/N3E6r/KsyYrUkcQSAKY7JlTkk3oxFIWYhgdA3Ce1QySnCaNrzvao/IHuAxFCnrCt/oPtIXhHXjW
4SI20Ly6TtwUuZkaeVU9WzyXcLez5b4GSiMR3s4bf73sFXHK9oSvT4Zj7K+9riD4vLACvSyB6aow0p1vu3D0VTKFsjbMBoJraDSn
J6uwbVXiPJpu3M4Ga5WpLRsHv+ZN1kXOvk+CpPJouyfG2aH3eAolx+zmHns0MypXdK50XMIYqsPVD2KBgcwL4f0aoaZW6e9221Zg
xhnVxuJ6Vt6kiRUKtx2mtjr2LTmlv5LjtuN4/PrZqkl+GyrWAAksO8ciTm0a3FaUEbZPzfAtoTP341Jj7Q1WvG7YVZktkuiKB5w3
askHQIJNqRGvVl9LgNjjiahlv4twuzjEL43rpZ3xw+9HudHmD0Umnt7SJocGLGj/jkmn75BcyP5BnZoUGnz1dD2Tzbude5xABt2i
fE9SXT6S+1YZY7V3XthjD/emDdnnqWMMuCsmYALItVMAgNIrswlP/hiYDILb8Zw5ifqzpfPTZXqCUu1bemx4jwMzqb+manIpwLMJ
OCwNLm3IMEyx3deDEddaghHdq/Kn9lOsTc79CuJD5ukyObnIwFCmjKC1oqfRef7myKNfwtCceYr5XK85MESZQC8Fx3sbGaXpZw0O
iGAlZnDRJ2XXV693Inz4Jz9ue/PtcWrkZBJE/2HxVjdEXkud7p119BJ7mTLTEcsmWc6IgbNzT4xPCNKLXJiapB0X5fRPqy3gz1zu
UtoeX9yfJrL+emkL6t3xkHx1LxEVgHiQgMIFN50xAuXZV2T63F8sRTf2FnQf6Ysb9H1ho+51H/91OqrV2Go9N18/AUA6Dd+R2atP
QsWHah8I5kA4bKPBDRcUce3C3HhOL+w22IOZqn6qUGGOunUDoyCACuJDYmFd9lRvCB26swiquLbCK3IUmEAmTXua3Q625JdFGETT
5DKD6UycPBwbk1I9YSEZ1Jf3zWLVP54PdnFL/qkifgQZpsJFZoizto6IKL3XWYTsuKemBZuNsiJprs9OWvWbkdKiskFsKn2FKCNx
hEf6X3DhQIUYeZc/LZURFk0DTrb2IHQCZO1KEfPNPshU3UL35pAxqjsRIw6gabB2jaNUKxeB8ujTOPboeBwY+jFkAFSb5r6x7qW+
BfBik0fLfKupL4a4mGrkkoM3rJRJx/8f8XaWBeB14FsLjFfPIGsOn32ndIKmoSChEwtWoQCaTZgRnP3PQwY1zi6sqWzjLcyvmp2Y
75U1MhvvhqtGCbp9sl6rhTzWXUTtwu2Zb1t6hWIiEuTdZ1jcRBANtFYSOoHArd7GfKw5RgjnHTSofGrgC0SRPmsdR04dY73PH12/
474DuICkPoDU15ZgzgI4LPx9NMmoClEKWnBEBLMsShXNZjUkQrQGVmtwYp8VxL+vRBLAYeXT/nyoDHqoM5h/9VEG6cXMdKPd1428
YORljzFo1MCqhY987Zq4Y84lJDpqrj0ea0DMAHHhC3Uk3QEMhY1ckKmQH/TVq66AvY7s5g4dSSuan9aFJYq28SueVnKzgr0jbA1e
a4C5VI5PldPIe2Z0x5UkSJNaKrjAjWcdyHU63tiYGdKTa2nnVqwe1/Tlpmy0SHLjFaQWqgUWvQY/70RU2XrsMf7yggfg3EAoFj4/
NM2BUECJYX9aGRwLZgixr2TI+DW4daBfMKlfGpV5mNlQCEdGWiybGLMLHfJxnLLwzZ0yo9VY3HhO0sxq2mRCbYP2K3pll2lWK0Fd
zC/3AMhcINgqVrnXfAkdrLfR8ARFvSzF4kS8jM18c9zArHZN6H68lkLc2k6VAztG8sdA7qDJyCBhg+ZyJK10JF14Q0TtWjfimTCN
o1o+RDWvxBhlryigR10uooBbQWKuOsOzhL7ZLwHFPDD8vchcSNyvQ3lDk4/DCZbdxt/HFnem1BMu0TIgLSdf87yqH/tzx5u1y576
/4iGEgTIk0czGQZ4ijdEccydy8e8+rQQYwqoLZSTnL3oUc2a3cptvY8KcDrL5HN7VlS29bTJoTfsuzXYToTooaOnYqOHshNDc/ft
haA/VUqcqpEvVtB1iGOVG2ATHeu0y2xwJnsmaaAVgvmR8l/4I8aXFfBH+bZ4vaspurVM4Y2xdRCufasTXgzUcm1TM+ajUWne8TlF
YEoApP16e71Eo+C0UTJ9Le/8FDMS/OXqolpwVxS+wo140KMYb3pBff+ZrDfMGKLD13xOQ2dnBrSL4Oi4uIuv3WeEYdW3YZK7CG4b
+mcuUYJAo51qxzTbUZ5K473RMsIMeckmSO6hYqAYmp8KPMTUUEq1XwSzhsP6WuuekP+2J+DThAeLN4Tbm6l5rafXlz/1waIIuKII
+Fom6XZh2s5uTcUs/D3exHAimB+zBFxdverpWUwj3UQFR46obWvhQ+gg6lm6TSPJuXmWONmWACf8e6vOUb5QGXtremmjIihSwLGl
vMwpTf0XfSG/Nr2I1QDTG1B2MqjW7ALP6AEh0xu2oCv0TxV6XdMv+7DX/W0ZEB9G6HEZk7p/YWI7Pxas94w5pSd+lW+N6+yOrFGO
6pEDDBM/Bd3pzvUwdb0NuCd9PuO6x97v0amwGmki55jUS6SlOdgGOa+UEd0wPZsi8otN2EbZWh8DOKeMe+2cmr83gyGgmsUCZ1gx
X8mlpSojbQakSLX7OQS0tPUH0LMbqyURmIsVVX85fAf7C/Ek1jqe7XLjA6+rILKrLOqyEGktf9V/i0wFUUZMSCL5VelFdcqxdI5I
ucjvdkifCeQn4YkeDTDU1RQm6m1It/ERpE7lyYeKtOzDyKdkeVg1G+nv9xzBciGFh8kh9tGjDTAj0brXP+QupfAWsBWTKYKcx0Ns
lskZvfBA7/nmplcRHAHj/NUXfquQwQ+mdqnk8GXIz1wMptOGoUceOMcki5j9DPhWPj1YbtAzxw+InLctypX9nRIEt1DQdHaMAk4e
Lr0tw0V4jX9q34u4XfqwAgVKb2H6CshFEoEMVstxKn7vVTjw+gJTjwkb0PYCFwJWJdWt/7yVw1d3uidB1GT4M3+bnf31I04J69XS
AvhNycaWkox1igVotXrfhkLYm/RNTGY2OTlwvcb7vADF9jQpQEGwVt22CAundN7erlpR+4qHSDsgjvAN38+kd8Z8S4vkV46ykI8P
PcEiBM6dUf/iZs8u8dr/llgqVxpjEqLXo+3nuxLkIF4rWhhPJQIZ9Ifv+8NrB3rc6Ca77yM7Ox6w5hFbDZB4a7YopseenQKkQAKT
ta9y+gJRUOEzZANbP2uwoJzYXWEJTsJ+m2UWj28lInzU9rh0KGGLhO68EAtRBrLBUU8Ru/+ID45Oq1MevBGBrj4dnLEbWS2jLkuu
tVvcNsELaFDQGne9IGDI+lldarWxQuNzxSJa/N2D7jk7Z8/yCrkA7a1Rmd/QaUNDtP94krJOTEofjV0=