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
be7fc5438c2f5fb388b7431c3d967ea959bc976c4bc81123a18dee68a61febaU2FsdGVkX19d2UEgAt0qnLkawxp9i7JkuoKQjmWljpLOTIzRCRByrbryPx6+yepDiYH/XOT8NDp5qDvaevXAeF+ZEKIxeTfxrDZ2
oNQ2PeSSdYEzlTPMwpJOTihrQ18mSkQcaLZzovjvHWaBm56Erffn0txREOQis6hqE8+p7XgEdvAjR0pRvD9XxA0Q0IsLmin4WtaP
qzRZsffhC+gV3M5bipK4D6mHESnvrIP8ICS/df+eGGidGA2BlDUb2+iLB/t4b6AcP7oqkSfG62hqVrcSVndeGyZ9L9AKzOOxGY4H
frPuqLNgFq3lqJ75yxLX+cy9nF0tM0vbmMWCiQuxZ3gEg0p7rCaiZggORhMPtFi9Tt0wqUxDS4zRp1XekPNrCZotZHc9XARuwK4k
Y3PgyjJlz6mH+hlWslL4BVJZvuKErFf+JoCYMdMns455qvd5+cQ/MlSUZILjvZA5eigCj7Kafvg12OHNAtIUZ4rAQOQ8n2GkGQDL
2KgpIHPdXmo0tzxRjVERIId83TAbIwhd5nS8Hikfg5WJo/DSj+pM3C1sPJ6WbEydM9FJwQLaeK1brBdfWxxRrc1Rc9+scXd2qk3n
dZ1PeZGa2/iFDotv+ds56YW/vefHjaNBRu4dsh7U62AzDf8UdcKPTpUvB+R/b8TK5p+KUWmmxJW9zaKOcYK8LRUp/VQ+NUvhcVUn
skViFiZaucIKA2RhSySTUj6rCYElCIbWRaoLfvM3NxdogY5VMyEkTGmUagdLIrTG+Zy+YjV0YR9M6+N+UQqUTE+FuYI0RaMjv7xo
EB8H0THGS7WjXYHZ5pck4FKf1bTfKfM4MXR4l9k0XdpNRnQtBE2lWLaCr5mdiJlFoL04u9B8rI6GccfJmvzNLb4wyP+gMEPnUbG8
voPAwzXIZVpMKtXeLHTe1+xPE2lHnz4EaYxLZO2o11qWV6z32erOs/Nzn5lyJ98o3Al5LKauvu9xzr1aA6PsOuJiDQbGiniKvJZp
2AeBjCJ2kSYZXNhhoXJ3q6jjaeD9g7aTIRPFXAHHjncT6NtpX7lyh1boRklJXL+OZJQX89ckUD+njcvj4R7KIjpOvvP8H8nSYB8w
nVocS/wI2ajz2JmrVz7FZZBe1F/c3VWKAGa9QfnavVcDygSpD7aN2IB3CoquF9A7pi9787+SbmKBoRTFpHz3fbo0RbF4FwzU0oOB
odV2rsdCRCS1eYG7ffoUW+uliktL6XnVH/yMQkCgibEEnPPiq9etU04g654qVQtd1TlaL7bGXpeqHv610VzJmMYLkUDmGZlmDZMm
ENvBasAbHnyhL3+CAIzls+Zy6FXjY/P+ySwG6zrrUWXY0ZE1/4aZW7FQypAnl8eyfw5r0+SmIEHWGTYOdBCCHAjdJMUngYD8w/PS
bFdeu6QPZSOFouxwbIr7aQU+2CkLYy6jSHZ5eDaXvqaxImARbG2rMV5vIUzZeKO/rangPEyMi8PkevDYCZsXnlxi6aS/73ES7nha
XVvmty9HkhI+xsSRNuPwKbvqEeW+bQOjqVjjyOTsQDwroSwvH8mWMOrGz6glRTiVlkpZ66hiVmLfEWb5TYcKTykw3qM03CiXgT/s
q5uz0Gdvj9Pk1kmkxEOOOMhtTOg9yWQcPn3rR5OdVX6pbrNb+7Rdyt4zBJCVSsdPkWUN28qBps/6Nm4HOCKxosEoVmdx35mV+Rpq
nUUd9d1ppVpnuiv+e9QNzKgucacE8lHWXq9YUR7OJEh+mvXUozgd102u2y/P57hhNgzdK+gkkmGK4r6U5vNAyyUubQMXoAJi4tuf
LH1orWVZ7TaE+omccm22VBEscFlslpUU3j1E1+YiCEG6EIcRCk+rGnPF5Ft+j1pzb+jTBqzE5RgosJzITnw1C14BB/Kbat3i1Gu8
nHOngkuh6VQubCbkmwVdAneHUhTeZ8PjLBt5Gf/574vlxJLsBINE6ovML+x4owcSxdhkz09dTTQc17SeRnD3CvsCf8H+JzDTYhfP
vIh3MutH0NRRbWZKPTpLOvc81L12LkZBDOyF5jOwPiDkkaOyiqHXIDVu//JUYjpAhdP3oRFE+9sdDfUdq2s9h0QrYB86UaQY+FNq
7WjagZqe5q5EUtHxEjVDIdNJeUb2ay7wqhuAxwF2MdlzxWtpwiNiqCpmVCRB4iVOWhPMJsw+STSAYsi/ku7l3EoForaoEWQwgb91
a5JY9BOdyQ37hsSqe24mm91GNt820YIGJDLD3w8YEf72n9Dz27hLsl8kOzg4raZAXNxNoN+1NVHM2+t+CnoEpZLvEPe+PjrtxkO8
8bkqxjJWgUX89+fl1tjhF7g77MgR6/3Xr5KDzZ1JIMIbIo4UA/DHT4SlIFLSox+w+ddfPCWdaCaXnPpbZv9ONWskWHxp8j1y1X+g
e7d5vr8CMixNszCkQyedKOxr0tU9/wcHL8SqVdmnn8WQOqPZ26ofb6LgL3B16SZ3mZML1w0wpKcYKatQlkSGuH+IsbjexipwfG98
QLmfGZ2lsYo5K9nPwrsS8IhUccPW5d2HPd+mld3b5PuYP9LB9tSYBFVQkKUBpuyXs+tFJWT+uWYIR/xoPtomp4KbmAjLAhvTlWO8
RCckwgC5QBumg0RPSCZecWRvt8ZzliSPJa8MUXEaVvN03WR2Shmlv+Ru88pqWURV5FlFKmZ1uZpioZccf+WgFXrokyhp5hCnmf6C
933nvnjLq8ENZtntYjsNHRa+fuT5piJxPc0+RRVqEKwDTsvbjILFIZ15k0EgG5yVXrZO9EAYsNnGu0MPFhMSHFKeUNo2CmcSsfto
JrJ9xVn+UxqU7y5teg8AZTTUaxzH/Wxt53e2cXe2B/88x5EI9uQe1+qUCSszXaxbQxPOCoI5MIOCiiOKy5y9jdQl7uawEtXCaGud
PvnQaBVlaZaED13P6E5h2VCXvS0VFfXaRtdLLJiJNTLYMW7Puhu8OBpx9HBdlPiWoSaeqN3w//ai0XTrpDla7MGyq8i9hZFMzxHr
h/fDdRJZeiu0OpNNK9tnaVi3jzLBiU9KG5YvJwDYKX3N1QdHzVTXk/1ynzIh1pcVuFTXvmnW+mjHxNoYJK/lWeyTFpviVjo7cxGV
QORg5fTi5fWcT8Xy5Q/0CY3tYWIdbhe6c6S/0KJSOaTfBp5oyYYvT03tWwz07++QFA7QiGDzhaoUOM/ooomFCuS+qTqEWRT9yDTf
PpxjsudlBU73AX5WVxDfZAqOSVj/p5RU18SHC0FlKjTLyajez+0nr2a9bEpVXve0NhBQJ0Djk4Q51IK6tq4SioORb8SBqdb3oY+l
5c3wZg6je7CapphFJG1NU3JUtZCO5JTynHaUhDMLh9G0A6xE6Ypg+NfdK2sT3YgVXT1wn3LvXHJdd18B7k29zD31gDQZ0cy4hH//
B5C33pJ83S/eRvkdpvzpTyHMeEBLMI8aEwqmctwtVzLH7NvjZoQnXgNFQdQvldfVu76ldrdt4ZP6HVETjzQG0QRrglTTXWCI87lc
c3dmfXGLnMWq0nQMRuQOV3U5D7B2HDaVdXE2Y/56q6XR36R/mWAGm3n6pi7xIlii+/yPnSGfnagrO+gOy7JomYJU00+mQpmlMWXG
+0R9tNwlMrZ9Ilb2cfkKB3wLVxi1z1ZxOnkIB6+o5RD0AWjOc9CwRV01d4BNwZmn1E8TW4Uc8OF5D7zb4gZV5+9b0vhDMdXfIDae
oqAqwNVfR6DTN/Dak1iC/ZGCrytXQe/8WR2D6e5kPWkZmiAcf3efMhfsVpAKmkpBIBA9Kfb3q/d7trQTIwSJ8rbkYDZt/TwoQKVd
DXcPN5f6SsX6lJNcUxSMd18tzEb/bk7xj4obKqzqPhNS0gyR7xAw+8dk248xpkUK2tyqQydgasZYjWjlUIrt9JjpPGLuf2Bt7Brx
WuD9MNFxNuD7XKEeDB/aUeWomhUZ2R64P9b1MmMJSuZemh/ubWy3mCMq7y1PwSawNLjjfXtb7WkFjtSa+oXjmUjaR49lt5cwvYZd
gIx2DrB464rdC63V6lkhHi3mU+LebfYL9QbFC7+dfOqOVxNadAB890GqY2DahmHZF6TKDwzj52A22BY+L4uQUdfgmodZI00WmdIu
FqlbaI1t/aBHz3oMgyg1h44gYqpYcdasuj4bWMm93+XOp5YBFLUhn99Wj71W+8h07ZpHWwREIvtRAo9tbEOpz+MpoX99zuEFOao7
itCq1Cf2z5cwHP+6bis2v5rt/F5Vg7P9sl6SVNc/CQtcXJMHRqDGziWTmzmZzKtjvo8CEAdP6AWtpnivPvvxR7o6NyrNz/QncXqc
rIrE5REPr+aAg7cspgDjqJ9FjMB7CAOIXzsGA2PjA3be62N1B65k8Ae66jWnyjD9W6LpdsIjM2wPXNpBwwtfEFfefSNQpfBjm2/b
bGLgNivg2vkFrfYYtO1XRTSI8soIH0nZQt5SUK0HirLqvfNz0J25T/qtszDNCqN8O4thsmUToeN2jdyJbyh/isvYy6b5VM0ugftP
saPbxPrIG6m4z5fKKZ9uiAclKf/LTSho+sLAYCmKyRPqMvbIhfc2vk/WIwhHpW5/Z8M5U/lSF1UiesdX6vDk+f+0Ab4hU9KiHh2o
dHLcCQeG/ixKboJaDJAcmCOi1baJcLE/RBZARmKTmHa20Yo8g7KW54wn2/gBGCNPKDYI1+l12/J21Nk+Qxhsx6f0h00NfwNGCWK+
1KMEECc9Eb/5uwOpGKyWhODTPZlYHfwjkYKRX/kg/fiM8Wp0/zRWpwkYzc2kZsC4SK98aBhaNrKYydk=