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/UV/ECVU51hE4TqJr+3bg29+ALk/3Un4JP8247VZ8o0qlgoB7u1Vg8/SGTZbF7VEI/jfAnW6ipC9660d8MCdsA4Z/X
qEumkFdufFaibswWTTG79LRGee+a2wwVWoQj44yNPw68jukPVIbLrnCDTDC/sFWhBtVLvWArsSIxioSnvAtQvWbMhAulDIK1H7ZE
NrxxPclVsroN3Ky/hY/T75NIVk4Mc2XadPDM4ym61Iym2J6zKvYbqnBuxxpN+4JUmOvVHkojpptEKF8Esf0F6xbWvKpKbrIlggM1
yOmm2mcFtwtMDoHx6I49YefP0Jj2ay5ScYqVhp5+JkDvyeGpkU+Vn0IVpv6+ikkmBa0cQxrwXhqYebiquakqdraSuVt7gWsILOZ9
gqcvaD7tcsUm0BmGujfiiaeKqgrlZhBYNvN7NoK7NU16JC1m/j/WB5PDZmcIR3FOgQ4rV8Um8gE6Xu9x0xl1xzS3b5wxqcxDlJfk
srm8icynpn6EetlU8/RfNYX06+hQKIg+BFpOggrHmMhItsyyhKumfotziJoB0oyQxl0Hn8rb3txr73K3ZoOKFKoThVidOGJkBZlC
Nbe2DbgphlOK3Fx2C5qZH/bcux+fLvXd4XOrPKWEcWInqTnIS01iPnr+UBvmnbZflOXhMrCxkHrJ8CavDtkZxeyARjvsjnEWQr/8
o4e+C9xqiN9g0KVJHH0bXq6c1LoMBj2Dkg7SiPeybJ65ZK/4RjCbdSY2Mc8bXruEzD/CsJQ6G9+MdjzO95LxE8lF4I+tR0P8qiW7
vMKzA6S/vedSCkHYFg1TnFKiyNpOxSpOzVcOTYjPcWZQNCxpaSU996iV8DyUvmsrvjnUNGCSpQJxDBkHJsISUAgo2Rv9gpUVuww6
zoGhK3qnaMfniSuk+DpAbyr7Om3DswTiqFQP/4h9kGalw5462FVHmtomUC+Llwnhd1qEladzzXnBiXA/Y1L1LZxkdJDfzGebQyr8
glCsBSVbAd0elVG9vVLHSLhcMOB53/sZpzy+TPZpYn3hiiFtYyCD/pkVQMtvmg6yzqGG9PUUkv8fYCgqZa1UuakVa9T5Fdtt2mN8
CtL/0iO54oscGKB/QFEA/VHKqdHy+hYt5CDn1ozHUq1Rd8tE+A4aCKuRKDQeDS1ypUPq0gmGTfDCqbNyVEM+D5+uBksBz2gVHHD1
UrFj6CKnIzTnAwuBB4g6KmMHtuMLqxf0uKI/OeGjsPji0T37F5kKtE0G9czjDVUduhQGe4SAmDCs51Nj8tQFI0NpbBtICLsrIXBU
iGHuttXrnkTWesLPESDdYSOy8d2BDbF8Q9VGJQKP0X5ihpP5aaePCjlEXQPYQ+dAxGGzHKmdSAa5W4tMSIJ0u5WoS2rfkaMDsohc
TW0LANmDsXWJZRVQrtwyGJqhZAu6bXNFGnDDFO7rxCqppOk3I/cJ81ZPM1l54EpzePMAk640GmHfPyzLtrtExiDxMsOFMzMK3W50
1cahRUUVEqMbgF5whg5lJ9XjpHdrPJ7cNqlDDRQ28wTv4w1RAupK1Qpq7GiWzoXP5GCTUeETzONGWvmgMbCyrEzpxf6g+eOyR5U8
JW051pJfDir4zQB6w0lk24e+ofUiCyvOZll/zHvEF7URE9kvRcVqc3N9pKBYpS+tl26Rw/V9bmXErexNDhRFwXk53pq87igMSjyC
4M+tFupMkM+QFI+p14qWq2sVM4+QsSIjwseKYtdUtq0+PWs9OBlZEjDkUwQ3QXcbQj4+o/Gdz0oEV/x3E2GuFAFCLSJqB7oTl49H
J78uXM6dSXgAznc7DV6ZnCRlgRtNEznjQwpqEUEBTtt4ZHNTqYtsTWvF756u6yU3mRh/JQzu8XmaPPYaCJwl1Xi998pqUphN0OFt
RuAhFPPX9DJk0JvqBY3KaTwWuux60KJIKinjml4kKlr3OjVFgwe5RsWBGl9t/W4kCnEK5QykYQ1m1+QIO+0Bl0ZtdyPsVPSjPXxb
bciZn2ZgbyC3r0jIw50JQwUq6PVJ/v9k+HfGrqjx+YmbX+ptp27hWdafe1F5TUhP+cw4xNdhl5WrtrmxFot6BxaiEKTac8sF+F9Z
zW6Bq99dy3kcZcRV4JKOkYTE9Ng46H+De82N3fuvFnJTJM60WYg+sbxKDtHj/B8MSUgo/7SirR9ZSN0UWyfPYcNYBnoevUZx7d3y
dZaL5IkTtkDQEW2dVFeoZXek8MwGf6C4puThsnGfKUkVgIS84defmSqwFCN/BhYiJzMxcJjRjJiESFQ8fUqIH7qGtnjTzmBMb553
LN0WHEZeCvjhMZEHHuYWS2CNwy/oQzKEaanttgFY8RCOWsuZFSbB51ZGLGPZuc5C8YalomvyN+N31K+in04IitMvkvihBCV+mawx
pUYieRrm5SDjvxaQFpBrpYm0mOdZ1G0QK03if+c7LwMFuPyPNgLVfyQuuyKRFbzbMHX4L11gDiWLoIDA/ZqlpZSuxglNoNNt8xC0
Nb7Lm/80PITblfA48txxoGe5uKfN5VeOALkxh4IYrgpcj1G3/XOvQXt9CfHWL8IRraokLMfKn7R4EngPjITdE0YEZfKstC0uIxqL
dY9R4bir3OYKvF2zVsY+U68g6hV3gcBqO9KhB2hmJ0tPkjxXzlMzcPV9XdryEWHKDwz9398KvcGgQvwlko1a0qFgWHh3GOgZrRa8
OfQ+rpMXa/3epiJDUJ9Yi5+Dl6dpBIKDvSxyqGKKmDFAyFQPMaPVWhn/SpaaUI63tFfiEzmTxGbP6QTsHGM1Gaba3oLPhBW/GuMa
vKXeF2J5Hx71fy9OPVOHzyXSlX/72jo8wjvR8esemDTjPh4+gMrSOV4oS/gdPBrarVtr2TOTb4GiRuLK0Btc1A1fxgvr0R5ypZnb
3jch7eHURrTqL+ZQEjig3zODOX+N8UKnVdWTSggrIsbLgZGCBnr4Ip/a4NRj1xfefKaxNZlPsX44K81j93bpc1MCxY2KKYeaGDqs
8+OmidBR4gm9U45aZuQV5rx8d2bAwmwlVEaicQPvuzOcIh42jvcevfzr7m5ZlVeuR39cJ9grdzDHabftcOba/rOkb62jWoFHwrAR
NsNFhjQuYWlCyMrsxOnVNDf/rmHxkUOYePzX4fYa0Lm06A0csDtNQb1wqA1tViwWg4LGJWUUZgG68a8waKBfRzGvoJSiMixNogDu
Q/j+u2OXB1u4YOQyakx4x1S6cgrcOPp4YFhtfeBAB10bXUbT7MNhJf/QjC3dU8BMjdPIfoXosstRYF5TbPXDNYyw69TpKf8UYtHJ
Y10n+laIGliX2tqGPwCGz20EboHGBJAlYFbf+L1o+GEOu32Qv8VCmjlwm1mJFzBl6Aa/dBzvAm/3WhspSjUtZCczramw9+OaHLYl
Xtg9T9TBu9wJysU0zQYsoSaygy+wudu5uf7bylMWqwzlb20qFemP6sn3sOz62uGH+b6wzTZnCWjj9qKfbu6ngMARWGAyA5U4+s6a
tNj4osON4XinGA7Bfw1CitZOEu16CxN4GwcAc6iZGtG81G7iPB3CpWQBZIoCfJ2zSBPI9DYaNedtKviHTnYqD1zqpUJ44X4tFv4Y
eKwEL+4WdgQX46yOTQbtoKNXhbSDVNZWyRHfOk8K4fFs4fdeB8V6O86+cyrYHaFV7fs7ccHGe9hFq7s0eIj3QR7h20ATzsjegQnt
Xsyy7zT03I4JgOMwrp8ysSMRWSxADNNGttssCHIlXZ/l2wSAi8CEW5pWV0u9Ena00vCoydtNSbUGV6Enz6SfC+WqzIAFAoYbPcVS
5D9dkve/NLtOkxI3g+oyOy5xbL+VuUCizrB8KF+b6jMiqkg2nBS+wB2JUdNvY4FXzbyTsSddvYXvq4CdSHax1+kSADLj5Nj080i3
gv1iQHMF0/N1tPPGUEFJcI6c9mmmD26o9iVtp6soEwNOifbSd7h0UUArz6+AOPP/0RyqHrYpin3WU2kKCJLdzEYDV/L58zYOia3+
/ksPjqrpbtl6xWaxjFXE5m2iB6OxT+A8wBgoegZpD6m6BoJocJgJRB/kpnmrDRkttKbCuX5a+84/t2CfriFHackXJL1BJfKUEhWk
hhOJn7YnF6HWdQsKmadr0It3/AvWFeU/RyC9FdnervtHrqFHEFy8Vyho+jABtUTof/GS00kBNAQEePdEvot6xH1izEj+0n0wdDsp
uZ4YJXPFIm51vzv96ywQk9GOD9aJ/lDTK0TBr014pEULfDsn9od62m3ahumaLHrvrt/r5uV+oo9xlL1cYPOw3WYqeyN9sjGsh1Bg
g1F8muvSdWrk0DuwEm6igaek5+25GojkQoYTx/zbvVTkJGHYJgaNYnaLYl8qAnWMdR9fHjSDoH6qYsOJXOKShn85OTF6qwjYnc6o
Ze/PLUvOUTXYTsKj810Ea4BSnzH8X7Ae1zqEXl607ZlR0GE/4vkawAZZSjGVjUkCIV+5ULJ2P/tt9I6oq+2EyaclrbPL+BmI6W4m
gfiPSP0mtxYEJ8T75gDWVdOgQHKjdQE/UIJxHuxacD3e1Gvvy6Wtsbda0nAWaS4AmQ/RsJ5wr+qhnBxe2NTLVnUwOdByvHD7ShqO
l4/nu9a36vdWDeO7PkWfwWc7/Wemi0H+fpNQCUmXcL1jMh+B3lgCLSRlIk5E0Pd5B1t2lHdVAmlLTJMM/TdGQJd6r4QIDzF2Wajl
eCfKXDUOInjqUvMbP0Jpnucwa1yDzXW6Qc6KaqRjG35TtXjMQefhUU3AmVknO8RDaSht/VKW5v4Rh6A=