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
be7fc5438c2f5fb388b7431c3d967ea959bc976c4bc81123a18dee68a61febaU2FsdGVkX197IkHvbi0q8KtOGlwPf2ZzUv5Bcx8AtOUspLGS7HGi7QCMmvGc5k/UyLlZ6Oo24za4YtlX0tArhSIO8B0s3yzghhlC
GxUMkScFhIKzX470L/o5V0B7p9ywT53axa95oPLZF5nXt6WVmNV6MUDnIXR53+DNqqvPi6R+foxllUl+NFYPGUHoM455nArMdO11
03pB641B7fvjsZBYC6lVBhV72DeddNmIUGBAhd18RD8hsSFSY0tR1WJvzaYbdkgG7DGLe4vq1LQh7xhRqcOxzhZNbVb+DC0u4m67
KRsU98DFySPpC3P4yqFecHsqTCN5xIhJaOvBYOD7+q82+jj2jOi/DirMH4LfOxS6gPiBsWE1hjDjPZAw6YZAOMWlL/zYwLkYuk1M
viV/ys0pvoJxz6I4wGZdFgUZCbZauHTHXnpeAmgjJWfSriPXShiiA93o8gcA5XM3hf7D17WV1IRmEf2GcNwDd9XhQxq9n9I1p4HD
u15TbpVLR+X+IaRRFJtTDnXC/5Rh+0KnpWztFNmv0GeYjC3nxmSt5g83UBp+XMDCZYXVKllX9RJlPlQ2WEbkyK7bMh3fJaWYB3rH
ESht8k6Vky5ADSkdjcxXni2OHZRlM/+ZKsPXlmQIcaOywelj90F+ImKTJygnDzafcKAAw9N2cXBZDsTg65eCboBEyo3yvROLJDoI
LS9AVlEL/85uPtDWaPI1BfF6bQoIa2dKjohUFIg8QmwWMPN1mwtr6WdJVvNGtWNEHeeccPV7GOShCGIGlLPPA29c8yfVJFpsipOm
eLNtshfmr8KiUCXuD5PgkMxv8BOgXeeBfEzOIJEiLbp/EU9Wy5suR2o/ZZWqfAq+48VhX+B52vj9xzveB5PjBgYMvtoLicx7SQ1b
DYtITV3QlKXDbDdLSBG8+zZgaNLlhwghzRnpDseHr6YxSHij/ACWZzPjtC3km6ShuTzm/OPk/+3uYOk9mweEIdzz1pCxA0J7xz0U
ofrk9Q+ckU8XDy/86CYZpla3xYLK0BSg4AGB+K60D/2lH+9yaQ8MJqJNXNl9LL3amJBnvn+YCuurI9fJM0XXU1Pf7ysAiFTK4WHw
fMtogENIQjFoMKPzyssy4FUB5ioVAt8/EfQpvbmjB7RhgjoIbTKXnOzGz89sF73Bszn4zbP7kKD/XO/g7aQ5vG8ZETyZWIiO7fTV
2BO31PZwrSSHtisAzUK0m+6M134GeC1Q3KsGeVW6pviviJssryKkeVwadp08rLBy9TNl1GQIzS0DPrIOPlk92iW2bQmykokFO5Ac
4uNaiXX+9VEEtnq7PuV0CNStA6RVc6J6JPI6dBtCjJJ2uNu2GAuRbFgrjvg4f0ZVPc9sPD3k/Hk8bQI+vztMuBtU+tw/ED5gjBQK
B37CNiQU8sUb+yzT8mw9qVqkACBrtIzKGhvIidKRZ+VAbZsIR9+cHnylxDG1X9DJXrqvQRQxsls/E7bMHjXRBwguvc4A+MywIu48
FSi0GbRkskg45EJPei+i+LcGLrekzjRem9o/FqM2snlfiKwYhb3yqmDN9+ADou1F3OQQqZb0wG1nnpkya2m4hMA/iZnTrosWmsaZ
lrboxUJdCSIOO1pZNQZuytlJOA77vQ7O+NPQyZlQDOo8nuFnN7m5eySZNxdyy7eqmJWwUlGF2gl717fQEAII2n/Lek1qh7Vg3BqF
ecoWykHxf1RYAs00sdehpMcdXO8AgPTtNJFaadQt9BXg+18yBpVM3AolrmTnfmKz+9B9i0KyLSMOKRBXWY1qtuoauXA+/edykog7
z5jBtYoB1cQmvRpbQG0ypy3Xxb9861ZEsJX+XufwGefjb6qyY7i3h9LXMbpahVZiYrFomkdJuc1fn+pUcWZ4DZAyBciGPx0AIpUQ
wOCRMdgckwncnQlakH+vWOG7Hy6xlZI1Vjfoh7AANoHIq/2eUgb5hXnMJGwU15nBvYCUBxxqtE2TbEZ7JK7/WwAc+SD53/B4XM1T
iqFJLWiLgrjfSQVDmih+FjMVyySCNt3bMR65Ps3VPqeonNsHsQDSFvL61LRSJMz5tkjXVMbEWfVZjuJV3n47LMau+/UTU31r0hTk
VG48ofIpu6nqXdis5J3SEl6pHbbomaEK7hLZPKiBTW+Ka2FlYHUwv0if+7nC8PYhUPS1P0on8I0MWY+r4s6Ayig/R8f1/GrdGU7b
RJ1o5gTTK7P8YyHdvDAern5bsQtO76hojrM5t9Lcm5Ji+QaGrhH2z1tdQ6vxBPk0sAvzvbcG07I9A3eoMFAypK+PVCm0XoMeOwrB
8AqV7ANpT9O4+kcD2F5UnCKgnKwFQDnUvJa9uS5NorMKiGgfFvfuYA+ELb4UZFLgqT6mcv/2bJQz/qbOyRJe9WCrYDINU6O1zsgU
/5K/OIjrKZM4RKZINysxGh3V8zNps1O3JC7WgenYzRZoqep3h7qj/J/7W656l3YjCD8mG2JFCxOQQ3HkCVqMsK1BnrQhOHGvz6bq
AKrClTKEYWjfKfBSQ2WdZ6PyIRa4urRG2gtqKJyqrzBX24LnqcjcXev50XX0b6pfhDjQj9uXMD22Bsy/Uhv2fBZKb3MtuEmRDLO9
8tEBv6qFL1bJFQen98TG4/nNr8ZnMJ0tZqSBvk/CXrSjqT4VSgHeHCwCnhdTF0NAdcZFNAVeodCNqjtGq1hOt79S1BsDmqb2Af57
NNUAGUWO4oTqG0Pytjms24ppGm8gzZlIrcJcGewbTHiWn6hLzapWKaiP5U9JeJgN2G944lCTTcAUq6RvMviK/yYXJj1MKy+yrVB2
MRsf55Q5Txu+KaIqHBPy0Uq1NxaMVexVdBHvjGMrHpwMjIEHS+mxtZs/aBI5AJwEPy/OStPe92aiwWTtx9YxXM1fo2wAuJs96wPR
wKg8o6yqcm/iyU82bHeqi+mIU0jLOn4XxpavK/vn3QTOYzIW9/+AfK+RkodQSKC4P8qUJZTapDMpywzn2rkgqs/r55QWDp4T6unq
BfpKdcyOq/GQZqcv8xxhlGr+Ivpluex9UX/F1pcBKCEEz+ekW21BcL1Y1DKpq7c931SyB3QjeVWTr8K9ofcdgtHY/MgnA77OxtR4
Oxr/2h++ETkCEOxptgOgEoTNpeHm9NaabggHCKAv44ov7SPfLsb/6u1UpaL2Xy7EwCbZILoCvUti5sITsv4N2cjYHrME1JXyuTNU
fRbQAIG7zdafX0yp5GZYIgWskWqydu62P1WcuVnKawhuKSKp09ZTIf52MfjvohJrAIYa8vBGJY1e+cQPe1Rb/yEUk7gyWJKYEHiP
VJYmj4KzQ4h5Z7PEqBQ8BCNs5AAV/tjRESV3DmTwqWTC1xewWBHeFBZEFFa3xbtJ3Azl58jxYHewrTCZ+A15zWEHN1dFtjPUsztO
Qw6oiMlTNm6K1S1Ts79HDcVL7OfZNWgNrsWlXS9PbfCGCQIgV8oApBNLJ/rosLt+d9LYGelgvhiL9r/Kqu+4KlB+Ueqbn9BSD/x/
hw5wBS//ovkoc3WhwGYNfYKkwz+actm+ikk1REj6RvA2NchwzTHxaGmgCVIzQCE94LHjWKoX/YXfaWaPwiR1e0Tf0e2FLulJU0m8
0/HVX0w/I+dzoHat7g5kPFZx9g8TwnC0pddcwFE6nP8sqc3uz4rqXpjYLWB/NltTAz6vS+t+D7pP53XN1s+0DGxIOkLX8IKjrtnX
Owhq5x3tbfeGgvhH+N9CveepQM7/rMDcq868ho363/4RoJPlZBH8O6CIwMeV8s6KgZ295kw87HJdJ7E920rB4mIxzi2VIuR88gEe
vyTloeN5o80F6jXklFDEhcCo9Ha2nprb9GzZQRc9h7nNxDE9BEFF9sotL0RohJyAePKMZn58R6MiUmzuc8qAAQYKZQB6/TV9Wzd4
qKThkm1Q2SmtGvNaHAGaJ/PsegiPiAX2rIl9AkaVkPo5X3olbEwqo18bN6iF1ZKPyut9W9JALXNGBIYt5k1wHhhu+UTQ9xTzoJlU
Usup4cwEyWO8sfQULeiTkhQ0eTWiI3ZO9SClp50vJyG+8xK0l3eFlLwTZriPdEr507pS4rHQ8b7Ut6sifmGIu44YcRxztfQt6fk7
fl/AGNaRyw4eS6Kyucz69xbCbmeRE7RKXIjhK+T/Qv8oNdAd3D0K79GUrSBlun7ZUT/ye8w3Kh04uGZqRCWvI+f39NXRYQMzXyo0
mN7EMX3rxI6NyIuvEhis+lCUlJVmPoh2WW/s6r2KRCzz1HXHTgblNy4bb/mUXMeCoRiTdpd4WIHRhFfJEs3C0nE/eK99Jv01BcWf
Uyi+DbQp+DBI9qgbHt1z5gNI8BVKmtjdaNTePb+dV42RNnOBKFmJd4j5+5ZBbg2EluE+awc+p8GxwpEUTMUXy5x8JCnEOQDPwpNY
2ZwrZZA1S/IZ/CXRbSQSxp0gvcHiPCMHt4p3AFTEP8kTwzCoQjFSp3qOnhkxGDJSwtCd+KrXYSe0AovqwvTE1p7Aj35UGOQHT6ei
pdRdhM7nF4LV132ibt3h5EZmFJFlyh0AYJVncOycmc1wqxF9dmM/lUDD2NHx+3RDFaTM+Q5vRD6XjJm8mnsWu6C1VxG4TAhPAZ32
ke8C8fNXky8Hff+TdEP9ecVnm58fatIwTtRYzvUeJDodSVwTywg+lU4sX4mNW20MM+LBo/eKJJUmhhN1fKD47hdhNvMBuivTrFM5
e97E3E5f4D3nO/7pgevsjrykcPSVQcQ9nOZ33cz3420LiLVtyuEu4dj3X+kDcpnbwnxW8MtKIee5x/PmHqif5PrnvZp+ZN8t20Wb
AhOKU6JrKBGuUvoc+8W0K1zgvvSrpMihTozS1t4ifSY=