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+NowHuowee/Oln9kGXgE6HxZF9OMAYnoMMw8+f1olZ4qrIyP98pnVzo3NIlVYoK+etWoR80dugn8pAxU117RAzU+J+
l5ICGRyg6LqQJ1VAqMHrLmy3qe9Rz9ai8B1JD9P6CjFFi7cCEWLlwQQojxmI79WL3tFO8D1UfuXzrc6eOOobUXGVHrH+YsnmFMID
98eJ45rX/x4S6ez6ziH+T0QO5yXxyGYznTrTI6jqXoYaTpy6e6HdwjXZH2WFGiLqy62WnZ6EqrP8cWh7uy4058WL651AfRBnndyG
e3nGVz2etaTikxb09MrHiiwrMICeatOT0VyKKIZI3PDhgCIUFRxGIVdYN/zF16Sz9TEvGl5tRsKklQJ4oLgv7vgn7ugltE4sXQSc
ny9mnNETwyMcvQnEVROlzMRsP2vRHyaGM9NQr/uCDL4v6Mu4qyqGbRkZYg6KD9uU/z8LPXhj/B5Nb7hIXTKc7LRg01bqxe4Cd5HZ
wBaSFINIuhpC0wkCh4p39WfhofpZJZpeMlEyiqdP0XLCr90FYjZHFQpmeHMFWTjER/kWdDUeOK2J8gDZb+IzCA++Zj6uWrPbF2p/
WXbVI8PdyHIakqySlSARLpj6mJtyBOScIrYnnVLL99HUy3W0/MAQT7a7eXnkUtvzJWTp963yugT8qUeUbSvyavpa/FalSjpEKBlS
og98pTiXZIIHZ6AeB3hfkEUptEzrKQll3gdf6keYaaq400HV0B6FuNw+GnEuMjmaeUPhU573nNv/uzng0IBewKqCqTcM9pAYfeQC
lIhBoShN7ItsPBIGeMi4HQsgClrm1DvOHJFFNWK80g2dIyexYbtyl4sbTOVSF9OEuPrr2/wxVcwmnSWRQ1eBSz4BfDLU9EPkflms
9Vi972owxgfqzhVMwZhGaNNQE4U4dh0p9dw6aEb3da7misxHP3cT7QjW26zrYDsL0HF6XqtHOc40J+OGjW3zOEeggV8SNADGOp8e
i7r5cchXSFAItGF3kuzYqLZwsWw+9ZWGH4cr2eUHu2acU5CMNLk5u/ePn4BQx5ph+Z4m9DGm7m0XY052UqyEtSitiDlQedWnBJQT
zCqeCBZ/+6XHZPFwfA4IAGq8RJJJGPlvftjRJ7E5i8vhUH1AO8sIbJaPZoPARWPkySKAgmuYRnVwARcnjr09f2ZNIx2PsVQJg387
uPQOPRJMXEb+l1x9cXHhLUdRt5dPwJknwXYIPi9MfvLvzKiaAD1MJusR6liPz2mnudwV2PNI7ndPPx5wmCN4nrm33r84gvWvvsJC
N+YjGn6jZHfev/JDGIStuUeAGjMdlbWxEFPUwiYTGRL2dVN1gaMpU+7/5B2AG+zT9SXYEt/d+LV8+P6S+DAgpny4XWMnQBih9x4d
w5PJSksDXokC1wA+lAmhig49dcIzBKG3fJ2T5JwOjEBL3sxRcMtnFXaqvR0PMKNKGhhJEcVpg5Bl0f+Tlyy/wZtFZgJlLolkF/J4
qvZ+IaRo3BwW5dhk+cxIlJ1ELMOAv0NaZD2iJ9HcSRgX8c5vxSSADE5LLi3bnOypOig5iwLtaAlq2toaP6DpfPizZPGHm6dCqfh7
PGc5nd6FwV7Yq71lIlQep/eYiiUGCMmLS0tlqD7zjQMjK3LNrfLzPE/dTGL0CcUKLYvqORvpY36ASRDtIkCVNWkMiYthBFC5e3sw
j0GoqURzD6HYwkalqZeWFHtG1emNU7FpClYKLdqy+SaO8vVSqNS09H0Oa0RuHwg0l1Ax9RmbPq6umwwPgtkRw8kXeSHhnTRO/0Zf
9lrJmgbydLI0lKsP+63gsD9psIaCpoLXg2pk2ZxFGQV9glIm39i4VE4O4LzlzwZWuc/F0ptKtilLyyg2hxz0hy8UJmyGfWYVnd8V
v1DPElIinu+6j6GXbziFOPvfv6p9NzusBLFysg6DeHbA0P5HbC/TsVaocMUjGfEn/iwtiT3g+I4WkSVCv4uL/7iUK+K1fl1/8pGQ
GCX0wK1oBGCYxztqymL5Y+pQQb2x7H+4zss0spES6JSCUbsWHE7ldGPVfDDOVHmMy0eZQM5yY554XeHdvFoMisqpmNPyP0Rnes3K
bb27ceL1+WfsvbmTiCZza3R1PqhVLoZWqK3PpOj71hopezw2Ne3oyBnx/vvT5Ceb4p1ThKk1gvdSWEJWY9vWOpkCVd+lpq4WCBXq
ju4Ct43fLXP3xbis2vFjERZ6Ur3QJmcYxygU8ASm9s7YhqtNJwr65x226oJ/kXHNlIOy32SkA4iZLgnN8HxwaGTePVjalpjLqGrv
1eA2EGeG8l+hIaRcdqklcz2Pciuf0Odl7zzVRFFgtPXX+A0GHo/61HaDiYdRmpoTyI6nfVJpAKOHQfFV7dts4B8jSU2GXyhH8+x0
rf+iwN3c7F9EKW+BLpdyA+n4IRV5mpt4mF+UiWvbyr1Ukba/LS3VSQzHHMkOqvGu8qaC626aLiwt2rUkbcA1adRR/juYYW/hJBH7
BFcuVzR9umT2+X5/PDXEAYEKnHocq77BcdpAkgAonIwEa8idbVkrRz4V7a0lGTEV5vbCUUU+9kDksvQUOGAS+be5rMHu1mt6r9sg
prembd/xo/3kNaNbGklALkem4h1mnYjfaBgo3ZT3KOhQCMuCicAGmnMV1E8EiWXw552wJak9ypousqAm4McYECy9j0p8ETnuXlFm
pb4XMhnr9vQQAtsOQb9micUNBMD3zd2aRtNZoRd2ctnnMYKlgLFtTCZQbiboIvfig7tPV+Tbbqa2C07/OSyhhacUscLGgeiO4bkw
GsZGxjKeDcN1+mixKnEwfOk4wpwHUplhUFUPYAqEIUMLogTNqKULONcVphx2OrTj5kKoaWi2K5RJ+jYfOtpysXIwrlCGuVrMuE1S
Z9gTwTVkBJ0iZ9qpUq/VYfxWUcvvGWXArsRqoqyx6xT9OLTOK1mP3BXkvzAD2/2FiseZFSH8D1dAoTwPnFXs/LbMikD6vURfFvbk
yxeP7tnI7kmTHED4UPfYu18Y56d8UWYcRG3UkkUf1qC3p8+vtJE0Mto8OWitSo76SSrMYjuiVQ/FWWCf+po0I54vPD6gaay0v9mu
imtiFJj2voP/4Cvfi9zc2M4Ni8LXSv5tivlyA5H0irlQcSRRjP5BZQF3PbXuF/3VpDdIIib2+N9392wvwN0gkMXaBiIJyZ/IaV6m
X3rp0PSDFvbwiNy+DfF0txQkr7cori0S/mIw9XikLqNcCTIkbQLnBc3lIKRPAI1fJBTy3hPeJflM0xskEMAXlpCc/mP3FPmzapeT
l36Emu6s9O7Pyo2Tb+KHwBdn6TbeBmvmqkekwfASaTi2BW8F9CTFXbTq5v0j0JRHyfyInGggObJ+MInXgdEbAKtwjeysR2gnurfT
DIC0CRPKd7b+C7CJLOZ3RPa+TIbBRdUQmvlAiGyRs4ipWM90kAf86eqMiwI9HWh6ESxqWHxLyW4M/dqvLmQr+6xHlvaZZsYOU9Q0
Q7ubE9s/g5c0zAAjp2hTiUFyYHamE9PErU56LyyYQslzLN8AHEaVjUs2tFEuoQIDpaXyN6ypAIy32jGSwl9Ny/FnUlNmmNjkW60S
SsJEFceWauKVWE+p6jmeVbrBErfxAtWTJDi3O0t2olJt9WiI6AA5cpE3lsp7gId9PXGVafXHhaLzBviw2skc7Pw+sJSJen8TWa7s
ewUzZ6kvwub0AvdGUyyQzqQh1t2AahFC4BYe9vqUb2U4+wtdXTIHFoYEfuIZcPkYmXW0Cfg4RDvpqc2nW3PxLunCBb7ODzxRYdK1
ggHVr/CDdtdt8qzvmqFkdSis2lGIG8I/Ofwjv2L6ClDbk52utJY/MpBSU/vENwCScOXb16oLlVVSII8bHphNummRITo/OAIROf0J
9lGAzapFv1nfH9UaZT+JpmndNivQRPNcHUIPI8zE2bn7MuEEs/bdUFW4Dr6sVOBJpNSauQCDbCFlg+bDny4VJqHqyNvzcD+0mjtq
KauSHMG+hYP5cu9TQLCsWtw/Yv9b2KSIiAuzARsmkscysrOudQKtDiTgBSloZLBdQj7pEjFgvW+ZqGDzhPgH53zQSgl2+GYjg9ZA
9zyz4cDbcRIGPsD0OkTJSMorXl+sNYXEEAkZWyTxqtmipQNVwAlfAU3OkvkvFGLCDPS79st6P2DWdkIgpUHnRhgY1M/lvaHWNw0s
HrzG0EKTdc4YHkjY2QdQCvmWo8qDUvD5FPYyrSu35abkhjU13BPpgPo0hWwHed8QelVCiM+HtnQ5J7NOJq17YIYea13Qr+q0Hqo7
h/GbWL+0DO+DNEu5bv17ffwolFozXyNLWBml3IEQii6gS0AVLusmvxudJGF9D2n5mkD5DUySV5rOLRDsEB0Ic9sy3k4dlCc+mWMy
omsJDpJPPPthV447GCpqfQOUsJKgItniCpLEoWrC8GVBAvQo1NPmxB1nqSHl7kvYD1gOtNOPClmZ24TFyzLFsVnXI1jFDqoncIk6
qszFWa2DeWndCOFoeGhGAytpUZN5aOdB8xfWH9NFo2hnxt4tL88RfcyCkHWHs6QqnV5hPvzQBJOgunqXMzRdqUhVrgBEW2Fvukgk
hJPbxHVzbdibeMIvcwDgVuyO5sAxC1X21IXJx44Qm8VNEqb6yRgVLDSdZPRxwhfI+vmaaTWt3siErmOO1YZChrQqhKPIS0vy+10d
+u2jB+dW6JiFcPkdLrGXOLUW8nG2kqWonwOpli2lH0ECWp50aM5MaiXRZRv3hb55ILLXyncdEJ6qF9I0xIS19wxl60xhR8P7fplj
oH0uDDh554EUtI6+6vBVlvGf4aX4LnS/67+h+uDpKsQ=