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
be7fc5438c2f5fb388b7431c3d967ea959bc976c4bc81123a18dee68a61febaU2FsdGVkX199o2DnaeeyA0xEsOIWZqMFo+569EKo/8Rz377Z3BysYHzOqSTequUVn0fdXfqM8i/JyshHzKUBK7AzgkC9V2T4FIBD
bHdmQ0w5UKtVr2FbmJMjAoTTsAARiS0vmPUghBnNg88FOXsRqQkunq9nw7fr1ruaD/m5QUqyce6AdRQf/gRzmphDEZzt2G7APGwa
Qf4XdoyRgy8SCLtxRxJnjSZlmycmqZnV8m3ARGzwCZsFQi6kbAy3MiLYW9SMT6HJVyT1uBClzwx4rgUnW9i5ZXpSzvU8MabyE1LM
c+54+97b4zHbvyt77H9caibvtH6cOuPU3v4MiXjhiGe94hAEGs4xSN4fvCFw1JVbQ1MlubBHFbpIhbcmNIGP8cUoDimNd1cuvD9N
vN0k2qz9f6ul+RTeLoIE+nrpT16dqjG+6z8sjMPZrOsl8hsaHQQpLCFsYaeyiuJzALWenwhnDkLe6P2JvYtaRJCxPgK3MAWXvkts
FSCsyuGHdNSpGzoTqaDbZ96+6gmvM7yqItZWNoixQ7MUj3q81+brsD2X3CvL5Gf9HCF2mGzDjFW47bMNnPl0S7QdRg9K+ej8nMmw
iT/v9T895hnMo0Dq4cysK4Jly5LX3AZRzBDGZfkorMpXceJTryQ+yxFgNFwkE5UF0HO9elmwU9k1x4JrCL4l7BTR64hRAf40wN/y
gssvpx6RcuSVm5PZw+/ogy8fK1uLcOwP5K6SfPRMB566twP6UKFl0E9s9Gm8fWna9X2NEWVrF3tJKrbhyUM6P87fdaJhXAeu3r8N
7Z3M+7NKudeMVu3T0BWN2UoWYAgAe7xzR+daQpvKhodcMOJ6gQHtgCXZcIHxygggjAsZQxkiFggb4l9Ifz+KhDjN9GE/j3Z/DrKy
ZhdzXuAdnWAxlm62I8VcvFd5EuWC76ggsRMmBLGBiwo8rclgN4R9hcSyzropflapRtaDOeKLThfTlI8hv82yspI5yFQVLQYoOIac
8sW/w7N1q3SJZs/XxQTRAhxzVcw24qYtag+3C4GnnyqiSxUI100dSPNolg6PFoBj+pTwH7+C4TuAUDnRTL/Etl3Ir8Ue0FvfIVfb
bbj8b5TiMQEFy9aWBEp0AOjNG2psXQWlZGlMN/suvLUQYs3xN13ys/q5tDqQQItVOU2uA4pZLhcNQOOAUxc7aLMmu37i2UlpyGoQ
OJuL28v0bw2PiFA7Zm+hsdx4uv2qWQTkYUSzF1gqIPN+WEK9K7XfX1P5Qf7xZienO3wYhH1xy9VDbE7Y0brv2Fl6GlzRG7gc+lIt
Fph8FnkVPxTU+U7Rkzr0gpQyehcctaMOW9OfEIu5fZI7LlOWzQnzHuCw5JQaTGaquztYhu51MFpw85w4Eq/VSAVbtKvTUWip+Bl4
I+3su8NHVEDhKUBI3fc3lCQf804vt3zLmCxCrsSTPLxOyR8ZRqkMvaqm5ya/Wg8PAf75fkmh5vdPwTAB1o/6X/ewKUNiF1599KUd
52v+FoJVaCya+kKXCwU/gs+RKjf+5Jl0wXYcMt2wgFtwyMkBV/yvqELPfJFa3Xd1cFIpOylUfEHLTiSutrJLi6Y8WS3KFJhMwcVJ
vEA7TlBlyqKsOCovpDrcU72QZLBC0cPEoT60WMSraGTNPJbp92RJjEA9rSrBKMVp9m8hncO87Ednwz2nhvoBEeDy8TpApwl126xX
Wv7ng+V5ZdBQyuzEp3npk1Zlbw9ivU4l55RSzGUzAapg2iCQdgRbaxuqKbHeMS+Wo+vjONXQZCCeiesH5n8gqsmIWxRvrROL8+lV
X+8m6G4rHrNRgyNabdzX9uVFpMEwg4DXxo/aPQ1dLmjlGli3Qcx4kxSNdClptOQcO4ZY7Zm3T9qA/l2xipOgDw+ZFQZr0RQs09FN
2xEFqRNZN9b37f2dCdGD+ZrowstUPatL0xp8Isuyv0isxkEvMLsYpKLovyfoiYe7iNaNnoY3y1x8V9T8U3FOt32xwWjYgct7NlwA
Hwr7f4RTW4zbkG3cOU2GU2FY5TUmbNPSl+bpBtYMeUD83XCXlG/UWNsNMjxx4d5y26TzqgOZUoXB6cfrUvOx5l28NMQELdJjO3Yp
osmiOqS67Tl23/hQRocIEuzWP4gi6h2w9KfwxXdx9BmXXTaTQHuv1MfvC0+Dsk1ixo60JYse9n5NVTYgPgWohKDjGAQZJvzSfLD9
K6tSOXfCH3iO5JMjuSPN2b0bSCr6YjxtYufYgF6NsyOv6U/oj6HPTksWKYAYQtyzkEUn5V2HTPcsxT1BytZ9vYEc2O8deuyhJS9W
0RSQK+rxQL9c7XxN9ynJGflY65Vr85jnBueTxYf9XIkLmOn5vAojmf8ypPQU7kQaLnOjN22+Ft93FKBN+ki4VmzU7IKrJYDDCLqQ
CbsicmmteYD1Wfki5xOiXi2DED3Ffh8r41hlorgoxFwggTtHc81H2hWeev9saOqB5oariyA1x6LCeD+p+1+Zv6iCNQZyHw+UnSJA
gOpGdkrpYU3PwhiX6uAhuoC2vazyh9ToFogPcPV0zuDVN7pDDXFjzZYvolG/Tvee+lhUjMtUk9G4XecTZd0MgxwHwzC/79wD4jHL
TLeiKM1KzUtmPFyi/PIwbnwkUQ1TyPCJC6ljcaTvPHoTxuXBkl84dQsURdhcWK+ACGtgLJiaWCMsckIlwnpQnxJWY06KtgI1ph5Y
I88eJQswq+8CuVXBr1FNRwNO59gStj35xOc5lJDZ+CvEfnNUy0lN1m1oH8KupoXUKaTyR7GdcRL4G4yeyKHpDa2wurO7HycvcK6n
6skzWHjfDWZHqEZvRZKtRHT8KkybzT07Fm6gqYAyJff4P1E7GB4ZXuu47uEZi/4/JDWjWwqtTBHsRDvlWOAMgvGRqJQlPDtoYRKb
GJnD+XydzbWC6wuix0WJbkYZxFbRWMo2QnohqtzueRLC7Ld0+7NH44nuTQ8mTq7SJV4TvTOFFlCgMG2K7TR7pJ0+ZY6hjfHmfFEG
3jriAWvwgsVpf+ah/X0GrU0EkP/5OjsFFJ9xDhC2f4wP6vqlgpRWQrkp4Dzm+F1Zhd1HZwJotBnbYr2aWG5JOx1+j7eAlRY+C/XZ
MyO0q3npCfgL5RTyp0MpPYcr/0P9kgnJqI56hEz6FdkVa5qmf+r6wHPr3gi9MGMNsUjf1pzI5HHMY5k7yxvkrsfeB+VcVIftEpKJ
2JEwU8oK+CUXsibm7jxxrd89JK/ILVBwri0YlYUdmNbBF4hqmZkFA6KJ9CMvuy/MPB0GYFTIbpjYc8SOR6s5UzSkUemZJ3hpQGnF
LFKS+lPFp94jDkMHrhdSZMnm7+g0gOvlMKmywGSHdQNlIqs0dPVF2oerrqsOO3QKipGpbkDO53GP9ba9XKsoX5Lpz6A30pZwRdLe
+X/0KYhipbeS4irGZRkGJ6+Vpadqt5zsX4e64jYbGTX0MSEfLJ1rntfTjm+B8s1aiYdu7WGun8Il3MaS2dYppDij9meVouwEficP
X+Zaux6VtoUQlMvIzrsFDennmDyjOCyqnkpzApylMS4919zNOaI8uSixqZxgKnahtwA1kCpcoSTrsFPKgMjJYOne1Rn2DtDKK0F4
fvaPDKtn2Pzmb6gMtV8ScaL2/eGxTS0VN8zf/ylUzoLy0LwpDCw3msvtdE745vBBA0Sgq6rbMIT4hFw/DuC+hwaJZiw61vbPOUdm
gMRnOK+5HhGXtwDZu7xwRnYL2IIVZsPMkrCZE05kl/NVfx0I3hl6DhX6FgLNYycNXK/R+aG0YnrtBEBXLUV59RBsYBjGdHIEIfYb
tWV+LuEkWpjN0hjKXoi6ybCkW0ne15PCvJa1u+su4AEiU3PQFlv5wmnBkvNQgUvRN3RT7FTbCcvJsjDZBIS+fv9Zm2cu//50RZUa
t2nZuRWo0mHm/e9/ngs4c+BqMgvPPpH9it3VU3d2BRrJmofBJOFq8o26mdSbVFBG/o2h5KMZoob6OF+OTAzeN2MZNmqGMWFMJOrw
8nsSUTVJe05SUP4ikHDIRN4+H2ffnlhfTToL60LbAUFhTA+arDw5OX9/vrNlM23TFHlY+UeYiDNzeX8tE3QaDx5MiWFOGC40fbET
ms+byaB2booJNn/vcVsx9RwEPf5Cf2zS0GEbt4eB6B82UOpFS+xTfl8UoZprttW1wG/sK5D0tagGUI86NOjwqO4FhvDhgS6iQkSy
2ItPM0VlRkOn8wqRNNS+O1hKtCp5C/ZwLdwN283bpeS7vrQy2w3c6WnRHRm68PwfuPBe/wUhpjjzGZpVTdpPXkyACl9LYOWQIlD9
QeHFBwuI4XpaouQVB9vWGYkHDXLUqMGm0cYEC+ekHxPYLX1n9WeBLCkYMjQfjEL0whhDv1OjeDa+iCJHkg0HRHi5OURuEuF/LFFA
pBvkbV2CWw/mP72PYQG736DD/KTOTa42pqc/zehX2D7ajlsAZWfgyIfvjDV37LMWZmdqXuRlDxdGXKiTZAPzbcbthASc9N/2/wjb
2Go4EmhmC3ZBSJEL2TOXayW3qBXNeJSQprFhuq3LYs7RZ2szgS5xkQwhKlgmoSF4Zk3iDc60HGJ+V4zZhugS4Wh5Ssjg/W254oU8
1B6HXoaQQAuqemJ6a0dYZ8nK1ytSXH3dgUu8izL/ix+eksXmMyidhXBMDosJSfggp3cOkmNVyrIUK1hesUi2NEpct+PdbcybVv8f
8wezfz4oRu7VdiGNBcFDGDE5ywwga4EoHiptr60wPAt7e+P6/Ou73BOl5fi3gKikpEohzlxM1S5FqMU=