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
be7fc5438c2f5fb388b7431c3d967ea959bc976c4bc81123a18dee68a61febaU2FsdGVkX19XrxPQ+4gN7OXOUSUsbQ/GiP93iMhBxcDhAqNcgqVUzHzlO8IG579oGG2aTDlsrwFGcRFgvbdT0fpa6/ncTCiS/xHK
88YEG7oWHpwjdXjxGnIVQiEvtCgChdZN6Uqae8H8hCgIH+bHNBbRAQnS3lPnNXyuspA9UpZSc2dsJ8irNMMgRgjuZyG6CepN8IFL
jmWVqVD9Txt9URHs4gyKgoPwb8lDNgo10ZCstoPn0RB52vlLNNlE3KQd8w6i/HV7AfKPiSbHPB4ybYL6Cw+4SWBeCC36GHHcD0ro
4UBK+uH2t2wb8XMVlKacSj5Xht5AQGa4oIwNHRDGcm0SBQn907AST2ICaG5Uwn7LqmVBrrisI7WFPwDy1uPc7gRmGB4f79VZEF7f
fzVU+0qwu0TSgdAA/e6/iq0Co9mgDhzO/WR6ndd3EgBi94PXW1Oj85RQn5JTOhjiTbvAFCy5iNlEk/495NeQb1mZSskco6eJHq4x
9Q/v3OClxxgSUvD2QZXBGQWmo01fmk4Cvd92Ef9U6o7tuKSqA8WJ/S9W4NHtA+jvRM11oLEIB0blflv/aUYGrpiQl1/qBGkvkTtV
BRRIkFhGP7R25KaxnVGl9RiNyDjrai36XwGzGphovhwL1+dUalVKHKn0AB0WrY0tqu1AzNoB7UzTPX2ZIV++CFILSqKWZJSemthr
hzePnmwQM5ySLQUJJNHJvP7njhjP3GTaREloTR7gjB15x3ec2HLnR8xeL8+L7DN2x6Fqrlbjd4jOaeua1e6khFR+gvLvgo9mfNQv
rqCsBQ2MmB+ZeARHWWG45eYs1Eq93TjxmlmR84wk1u4trXuC5ajGXtmjxFfFlpB/gIWwn7qTItsosNPqzqNDtIvZZhBfFeaGdVw7
2tGpM/+JAD3JjTgCP7FbcD9D+TJRsRWMXQ0LDBy8JMtnETVhNbLoJMYsrfB5s2hgklrif5FQ1/by4ainQ0G6S4RXFvniJpaefeJy
XUVSU7ckQSQNJGzOcCcEx1+UFQEylsKosAAHQpNyjju5HVxcg09BJwxFEKVkIGKr9j/aXzh1EktEUOsDsMF41k/q6MpG5PoYhIwq
16ZOuIkUFfGSk1Y7B+cjFRh/sWSlCQ1DaUm/te3D0xpZemeAlwxejINmeSy2qNQ+7c2JaN0bCFMxS1Q755vSXlPtAtUm5h1ckS0g
HkHF5E27O5pQaCsbjxlb1vbxN/sNJ1bazTaX6CiXIdIRn8InKexTBe/Pu/t5tuxE2hPWzKR5w+5pn1ZGGo2VCQZGxLCYUahIf8cz
4Vit7nhd/DOyMI3NpV0MBn+Px4gsSJPVkM+NUz3AdGbEDs1r0do4pDkCNe4IM1FGgegAwj3ixxKG9Nf0qKgpNYnFDndUXIyGSDsr
PRa6bK5inFDRC60WQikNGaZ5E2oDOjYTB4XnXw7eAauMCZYUG2VM4IcvWoMw8lCburTmOdxqEWlhTN+FxjC3QksCT7/5I//7HNH6
LTIO8YIky+hI0CQMs7jQUNY0w+qYn9iBONFfWOnu0bISqWxyvPmMO4yyM2vhNj+ABLLjDMjUk4grliFnpy5l1B1bPhh9G/DQzjMe
mwzo1E4ygDERYSu86xqnZsZ0eczV+SV2eLo0LX69Somhjx/5rh8dq+erpJVj2G06+uYlR9ThvhG8ndtxNEQK201Q5ajvGm/llVwc
rgOphMdDLwHPbIFeBtLGcHuuWENDq8nXaOvseoOgwtfF+FhlbngofhoHLPWtqzYZFP88dITxw/XYtNxe6XnrFqEMomuqcrBjwOWN
6rUs8MOyZr76IPp3HGjnq6Jzb1PuGRHfnmwbCWexfpa4qnhuh6fi8Qqc8jMwStd2RYLUUFBamzPvGI6mpjE6fzupxZQsf1AC+j04
0O3U2NfQ3O+wUzm6zKl/WXGdOIKXcMViylAhKp3lpz+OmGBAmh98iliGVYEscHY++G4KKqASdawcTMFcIHEBwhFv50VDpHs9hTlE
5m1qm/2ugZtfv65VR9mddvRuh4vrUluoWozd1LcKOyY2uwvLl5W4GRsLH+mvunUG0JhvhydXW8lNbTGu4s4QJzLKudN2JhxePrdO
W0KT3Nk7kOvmINP7DeDZ/295oz+fU0RIc3LbdxQqWXCx9QStXnKRRi4O9TLlXLkHh3u5aRzrRRsAgvtXVmdnyu2WSmBxIDM3eQi5
ZdJPTtLpESSZqVu6sWR8Ap3wFWQgcstaloD77hQ1T5Z/nmrUH2dwQMfy/iDKLEE2b5TK26hTTv/ROiqX0Urxwayw2+L4eG1pnrjB
p1e43lpyNyz/1kCY1l21k0jNWAdxkzLj7rQaWuHi8+P5ub9IKv/Y6Mb3QfCHQpu9KCaMHIE5WtOwQCINFpqyOb/djfO2aquYIy3E
n+gzaveX1X1yykjOWKrGHg0nj+GFSYzoRbRDyFc1ojzJQreYzI60JqvastKUIduDCQNouzhkPHl5bcXSytS8vpjRB94gDOIoxtrq
Q6FMk9S8MkslFPt29ztqPr1gBkEzRTTl9C2gZMNL+8ADwRgfJO8YQM9KbOVbjVMdNu9p/U1vXzYS9lS5+zHzqIHAkzRW68jibrFU
dqk65fAWeoTMftLO6p5bHL12LFdocDmpbbkpUocH3OfejDst+SMPcsf3qbsMcYG3zTykaoVqPxviliq/5HtigFndQpENP1n32bwo
KuqglRMG9vwIUHXf8LWoFxQc0/UUIrlW921IwWYY4cwiCgxD/yL2AzIczbgVuYcE0V/DKAGgxw1H+QryD8ZCA/gd/n1plL1Wl3a4
Vn0NyltCoqDJItBDKwxuVdNzUHuyL69G2z084OrnU3r9W7J2ETUhcZ2gS/L2G6C5RkS7Xw5Rb0UUrJv5dixJtkzY90YXSDtiH3A0
YWe0qFVslKdCR4l+4aqFr5syRUyGBy0GxPaX+qHWGxDwW2XkBiAvi9a4Sjow5j0RoJfXn71LrPMq2yOho7dxt6EVvBtNwhlR4Ls8
+0IsvO4am82ZMlIVotZlq2ATAogjhxnjgjW9dT9gGtjsRuVk4Z/pvHqafZTt8fPQJDvoh3tRMrrZtI++JsPuZOhGTEnLDJ2xwxvF
g95E/RHhGuW1O7hXtqgJk9R8xXI+EQn8m5hi/gixqnVOHXd/eMwT2zOB2HKhYo1U9GXx8M6MIjA8BSGWyrvD+RfgGfk4nDdZM1EE
qFHxzyU57y4LzPzMLGUjd85oS0bjDhJkcuo7VhiRyAFUmEa/Zk8nNonFHu1QOaH+gmD4yf8BW6858HHKicyXIXxJxTlk0DM9Wbzt
ltSI8l6gAc17TrpVYgWG7IaovgItw3CYFUcRhPc11uueTX2m5PlKrqeC3KBlimW1x0OtPpHtjHB38PMFHsDDaM7F46zjLa87wrx/
m++E2RcfelLMdvb6Fz2h7tyNfpaZaY0f34SyS12hNgv7uZxBDXueVfy8uzUd7MWoHRkiqFqk1xvUTYH/vpjyJnvGzYtHEwwZckUS
RerE2/Q08DwtpPp7hVNhlD1n1NtrBcMRBY6yrc9UMOJDYXhiI6yYq46aXnFJ99Viwg0bRF2oytpThN6vFOv7LCU/zFAfrR9bEmSP
Oc3qqYfHe6/1OiVeXAsuFy8PvsDHcvAK6tryWSF1Ak5IF/Oe1VYGe2WqUH16GTLQkpbZ7AxBzIO3KqbhkO5ocnQLe7LFEa/+cm49
mjTxoU8+usbNI3JssTM1gcW8uoF+xP91nFE7sKhRigcuxcj3Vjkde4tVJqo/LhkV1XmRjqpXTEVAO9h1/mIEnk1nIHGUpxjkEtHH
kKoJr59OAFXDdEODyHCJeCJx8g1z2mvko3SmKphVobYKh3O/AunwSlWV/8RqNxIpXf4Tdtz/aGOcQZv6QIGN8lI587nweGeB6j2u
wV4m33BV6OJ+iaHaV2M3yH9eU4IfB2BAY+pLNbI0z2+v0wTPw6yhmnuecipZgzariEUJEvsoGWBMdXzgEwl4dH0nCTp/nfnDqKQj
m0dnuQOS6loW9Pe/degos4BNMXrorM0/Un3xkJk2z6DffMDQLQ/vgS8fYaKw8MSzJP/SiaCJ63NTLknlj5n/TzG6UNqF0SFaSkxv
3t0Py/Ec4h8fjdZz6ZMph68kam3qUUZpjKlasGo5c/XwBQBRduR+H3V5FixJpUNR+37lfWlXxFh+KoQGgM/Io89jz5TEqriHq7ag
y0wTIsA82vOncjjORpJTyhOVQRCyLTJe6gN30tFjBpi9RU7ragR5aLqcZsgYdi62/bymleXttBC+Q7qLSfwqwl1qTHfe/nOF4hyE
vSqODOtus9bORTCMzcfKBM6k0Z8rMw8J7HmLnkLA5y+XB2ulMHx/YXZxehrQUNEVQICaFc1w5XBaXu4T9oFqQt7mLIeKjesvFjzN
wMCYuPVxzLmA9Y3ymkyUUE2xTHo0rdDCN8sz+THT3BJ14/nI3b+i/qiMWb3ThpEdv27J4ys6fVNdKeB+6+Lp5nmJkN52+Ede+ICV
DYjFrf675m6VdhoTLn/LEa4O8WD3mlRNEAU+VvAzenkCCIRI0jETah5WpK+jMmk7WloTAl+nKAippnpo9/GH4hmLAEnXP8vmOcDX
Umi16PiThvTUCWRAqsiEygw8ggFaMhbbH4peCkKNgNB8l+Q/4+cAa/C5wCN9mS6fC07vgTPZT8geN84EGvU276dJNbPmg0j4O9Bx
vebq6gy29Khp7x0J5wHoAsfeSpmVLEfnJE+t6v8snOVSaCiQK6XY6c4UbBmSpHDKFGg8MzwmE0zajgyX761GC/MmVsk78I5Z4FjR