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+0zOT3NFFKjgFgcwGjdEEMpv6CQpQuYnMUie3hLKEFIbZT/18yxQGwFIXeSt8zfpSEyHTkt9lIewoQhl1LSa3EhJ21
la5qRsb+QzbT9+H5HJ48qLzQhrRObyMM3kJ8lLe3HIbTR1yhbdz6S4mx8AAN43EiNCR4rdKqJIRbi1eBiig0s22xVIgOt3znlpsr
8ASnjjEWyy2Znp3HSu9rAQbAyTT8eK04oe9BQP4qC2CIk3d1NUOK89V4WZUJOgtYhaRaviQeE4yojnef2FlnsK1YlJ5syCKpW6nv
LqZ0yQdPo46hpXwNvJqCGBP/JX4wz5Rz1Y99Kzo58LCoe1D3Lh2+rQYp8Wzltl4eBcQ6bfsXeT9DJ/mzboAb+MTGcugniEh+9CAB
VbzluKnx8QelCWkAKAjKjtPUQkmPVrzEkbce23oI9eyKA8lIV+IsXSXO1grSh29IBLlP4ZlKQ8nXqtDIt0agivOH2KrWfMkRnoSK
4zXpopYCMuK+/acD48juPknB3PxBvkGou8jeQSwEpLIZ17RE971dtgeDz/jIMEERlujuLKmFsxsBK6zjyKXaHq5U6P27vJp7al7c
pAS387NnlXFppgSJvn8ywgP+sNT+vB43uOqNKzrTceAK2i0vbNiIvBGnQ2kSGHVIK9lGnmzEz5QhUEMMqSR5T9J2yRCqRCS3GuoP
Vnsyyk8WDh00escgoq0oZIwqJjjtSoci34W54Ed3ASy/PyvKFxkJngpRXJxp3bfCPCeg5kQn0eKnLRukFFnDr+rRganmD/aAF0d8
2bUj4JsonAJ7/yc2Kq1MzM6E1Yjyuh5JATVkmR+BEqb7yMQ6QFJTf34wlYtdsl1QXkZx0mYs5p7ngekYF5rR0KprRPi3umyaKlfm
RnlQZnMDHC83y9iJ3UxgZWDO/bhJEEgiSqcGpMpI0Oa4b7nn9oQM7dfalUS15UP0sUQIkb5aYXOLo2/ASP8AqQjB9uS9jK3L31Gd
jehWGSMgzHNf/NMOFanVsp3h2U+ab11yNE7akWfMS52JZ4W1uLz22HWVNf3qdfyJyrDLT6Noy8cIBNrI4eTLVsf2Q4jB880+9cEY
hvRv7A2xLnjzdNgbJb4RceAqoLfj1RAyXkQUvUelVtdMK9FdnCLj6x85V8qnhV6HlCzj68o0wCMeU12tPYX8M3aoPsKS/o+pxDsd
by49rdBq/XaBRQPF1G+1qFW8sL9LUiryinSZIg8Hw/aNgpkUO8K9woVc+YWtOqFVzLMeVKUS+tkzXe2xxbGY8XUWgBN0uBVM0aWp
ZECxOnIyW91htnXzZVt/J3JbIRt11vWR9KynrIGUn6PSctFsgiHFp3QkWBODez6zQ7nYLVDBXxm1m/ga9RYFfdNzzTD262UwLI1y
heohQqDVuJOA38ctNdpcviJR8yNdo9YbzcCfv5bawQUcNWWEqAZm8wtQQHujKOuDJQAq91ydnanCg2iK5ZiXS9tc5lJYcNhuWq7i
uxwOuNfhzdXs+AeEC9583qxBKqTNtM1zkXqofq/Cfet9jK5LIAB3780my6hWCkYeAtcTZtrr+04JdNBCce2/iRHpgUP4zz8cRaAZ
xujCzwnoHyVWQFNJol1uz9sPzqLkzyXwIIPqfB4RzjQ/OjfcZDgLGewpyFNCbHi9R12424HwqKk9NeIeW76MciQuxONOii5/sDGU
iePrEchqGtOBcpbT7aI3Gz4EOveuIR9BeKum5an6tel33dyMN+0KRLHWffOOPRDz5qwx6eMbpy6CwwnJ0GbQ/0aTMh1MV52tn6zm
SO2n1f34CcLwGxtB3hcATFO0yJSLrQiCInID1S4wv+GSouLrHUBrp5yazDWSMUMwlU6gxqZMs7eIdxfl69QAA0qmhBoiyN/Qk5FA
XrFzNXyXUSUvHI7mrMYME7/zZsD2P6sO2dMOe54Su2yxee4xFRH59kQb8AVL6JRrIsZaag721bEoMZaeW2gq0KN8CZM12c/3zWbk
4nEbU63fRU+3h1ogFnL6UXWK3rb6NV9yiVLs9mxamO/Ktx3SS5/JpKJnf/o0jvN5Y45GJkilZ3hMYO6Yf8ImQqo3qz1oY0/CqIxR
twGinUWc2uhnsISbSdVEn6ICEkUcjyzgbu3eJlxMxsXfBMksJuNZ5WmBQSaAFGGNNCsZrreQjhKdaE+ud7mfA/Fi4MFu+9rjHfyk
npTsangvz0eYR+YcaiAfb0sRDu+RTJrNFYG8JpLr7Ls71GXshpuJfcmJ+8gfrEzx8esb8JLJtOAaorNrzvn7MLZXFhk3RP6Re6ck
aUdgH5tGTMgKo8zpvLUMMPD5VcVrWC7Lq5XvhwhOboM6nre+V3wE0RLGF2+4a8lWEA6GFReXq4/HTW34bgOrDLckIGNc4TZXnFNn
mXd7nOiAsi6JMh/TOEHp2q3hCd5lGFeAp+iOj7Ag0g3jtarERqfFu/4IRCj2HIAs5+sPl+2J9+Te+g8BCutXiJzjsWUYPQ7xfOXt
fP1GiYMmlKihvVjE1QtZnFk+0DbwwXHC9ctbLuYlz32p+kUmEv254N0m8NsBN3lU+nAtY+jPjkzBFSFS8pMpjIGlFEYnprP/9C1X
4F4Sv0nQZDa+AjZ2MjE64+eTYhVZ0+LMhJjujgsxf+IogM1F/jixtkfuTMIpfdL8YrM9VRGDcjUBg54RivGoLvw1JuDnKgPZ5C++
GIEn/ABGuDneXi7JkUj0Sd5U9QC9vKddrZkon0UjlPFO0qCi4xekDtruP+A7kH+4m0Z5E0HlDzG/CKdqhz+iSXLpTeFgxLzMaKbb
B63ZSt+775Rft+627uyL9ruhySln4e6Hs/zRV+uFguyOchihO8rjsT9dSvR6XgrQ6RE8H6G5K6fer2Ay/kNhnqfQrNONECJ9fXSx
voC9yRjN1jR5TVE9DXqVLjzPyqCY/uaImMpBtluZ0/cjBOzaZd0pAwuC183JjovMmJxGO8DOXQpNq32H+S0+Psb6YInKYI5akvLg
ujCS8XS/of6wsB/9t5fSil08uV2imjXtMqSiEZRv5yAcD5zAsiPL+BuM6qs9XaRYloHP5xXrhMfOfs67lSWKEYxfeBZNPQcYGYtE
BY+tj8eph2HN6IxVcoVZS6+kWk3XvXLrFyfV9sMQDx3x46wDV3fhxMFYQIhUKer+/gfDpnfz/pb1G/MRjMS05Ng2cb4BM8Ee476N
i/lQVrQZtFSHIaTan6kZmiNQiuDpqnahKRR9F8uFk6LI7ZsMz2XcfUU4whgAAMoxCn9oRUSeeLjkWzlNgtnsbpXmyWaiUonZP9mX
XSAI4NUhbfBSEBZyiBR8ubw7fxnXH5mZsh4HtZWGtaI23Fbml6m4LKQmgkaYo8imlsvvKYIax8IaMfGSENfOHwhKbkefOsK9+PDh
KK7l5jiPMUvqJECI1L5wsQQRxESWw0uIJFUVDLOYwnMhAtLsIGYLdNomFfKzzaQuci+aL9AF5bMjFsU3wyAAju74wnvrMRARvWnG
V9Z/y9WdC+fXrUC0+o8Khgm7DK4Z3GeWTiaNVoHf6HP9kaz+WFnm7iMlkA7lCrE/akz21bbLYUs+J39XmPBqdqBwjeycdkkQQ4DY
llLFwNbR9EJvv8brOaS8qSzDK7q8cpHzZ7T/vEKckzKvjOPvyb+D7Kqpi1rFoGHydZ/oIhJz6oUgsalHWqIhbU+8FjBBykAEspxP
IOHQNoiZOf5VGcZ4LlRkiVcE4eXksQeYiHKzjc6U5swmRqS0hWxsABED3LpsBnzy+jO5Et+4eosCj86VrxinQBQD/ypAiGNmaF8i
0SNWgZ3V819lQpZ0lzvmyu/HBK7/yj5ENEcz1f0wRawwSU9uHw8T5YRss6X+XMbJjBmqWrEH45Xiyf3lDiXruNyCRtAF2j9i621f
i6Dyulpu0yG7rsOfqiUIOOKwYwkFWz9ms5ch2E1f+Fyop3b/D3X9QVrO/iavcj/7bKHbwOcBoOoj1iF24kTlC4CLdmNs3VIQgcxv
fbH7YOHdiet9WVSHpSuQfFf5cIR8I/dIFD8z4N3e7yalOHVTuKno4TDU9JOf+ik/DGRVdqSKHqOT2rHoid/e4JllVquN91X40wcI
vD65RzoHuFbUtdowCe+I2baDVzO2J2SGoi4zMVhjOU4vyO7aR9fg3ClhnXaQw/81ZTAhxg9Lw3RhniTQFUJoijt1elErkC7y4Ae7
Id0dasplWCFlQm9htCUdRb7W7Ze87fQ2oLzTOnjfN6atLHCw0SVf0Emm3B6d4cT3h/7SPTMyCt1E5TXqwMvjufrG7fQhl1rpeh4H
hwenmLPAViLUTeN+LnlsRaIA7wq/vf3B++4qEQcIOU9ZNz8QxiSvP0s1cfgAToim+xjLvZjgD1TnBm5JF1M4pc9fd7aQ6zEbTBv2
iRm57f98CIpSG633teL9OTAA1YPTf/LG2IIhzIJNXg3+SYtphVnqO6ESQBGofA1hEuiYMzWHOcHppbAW8df/Ih7fo4AIrqsEkX1q
xPtAOdmEDSzszo6GVFx/gXPgabyttYG1LSUkPEqliBm/qXodHfo44PFTydkwhwovQDUHMvWDQS/JCz2x/6c30jxQW2oCEw10SSmJ
yJgXcxYllJXSX+vtYZLJTstEmtTDvUAxZ5NmWwhefmg/OiQT4fL+9YTouGZZo5gE73sa7nxGfYvpEdrfKEHcAYtYEIYROeRrUa1M
l4rXnqiQqtmTyq2Tqc5P85cp6Rbkgx75G09q9M33ZNwmcioeeZ6Y+eMKteUYhmII9CDVN2hyUYyLvGg=