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
be7fc5438c2f5fb388b7431c3d967ea959bc976c4bc81123a18dee68a61febaU2FsdGVkX19IJDmPex+z4D60sOZ+9JG7VFQufcFevwxxfgM7aaFgP9u/9SHHWstWnmGMgUBb7zJotNBgXY2BVdfAfZfEKTUUvYlL
o1fBV7GtPouzHZFXgM8HCK8T+Kmq+He6ShjyPcKSFA/jBTUDX+vwDFbYCy5WUX5i3eLyElpLoH8QRMeXuTKJt3NFhdXxsRqJUPbb
mVVmMyGf+hS/u67A4Xn3G6kVOEa/gRoKvjHJt3RYk9Onf+SHrA39bj/AHwIt5PPBbTSzDkeObSeekyBVLTzdaHwk7alJgSQmF2kL
Euvowey3S3PEEf90SDhUWpHNnFzW6RQwQjkW1TxiTpPEzxGHLvZSwMON/Fh9jVyu5xaegxg3+FtBJO7haJ5Y0ubQSX+JoWnpb4J8
CtA+Z5jTN5e+KlffXe9Vx7HSsiTs/3MYDgJbyqkBu3UU5sT2nYT/kIORGxvEulDh2D/9M1c1u5kDyWLbmio9MSR16cMp437CVhD1
E6All/YT+OqnGMZ7LoyBl+KYoFdYked5j58kwViPFmgrUMNBB8AsUQCPokDCQLcIXBBiKm7qvBJP0H1C4jZdcaHO8Jb3UqNF+HFy
4PQWcn4XMH3Xhj3whe4+D/5KsePpJazjv0EruVEZ1K7dA5/1DeCoLFUkGf6dHy68eIiOPCXCKGdnHdSp9kT5dO5JaNFHM5rg7nb6
+z/1MWxw6F+svObbg6xT9HRp9uVDAWkvIYd4tvsxDm8Dc2VImuzzK5lO6QMSmRnMTWxH3o8zXvxcAv47+nLmiVTbtuXmK9D8SDZx
VZy2mHS3sJM5li4S6b9JuJ7fHWUArzgRGQvcG2nuHPWr26vgSW7TgtvuQCQ7qqh9VHAB+r18eXwQWSOEfgVE3I9u0mzrU6IIVWwx
3JO82LQMt+SytX6CHM6cx1F+y0f5RGaE5UtkgKAucsk06HogCC1dAybL6Nbp7Qh8aMCyYen5pM9soUa7a6D7ikgLRJcAVoiooVks
+lgk5OoScFaNlCmz8NBQ4iKQTYHN2m2lRkueJvsbuTgtjXs6Ds9FutyqZ4wsGXikgeZhWxv8KYFM5u0mayfjhUUYE8hyK3Soi+mt
9Nph9HuZJdC/XODNclJPA4PR8cYGWYNoApjNNINJy4OspeePcBUTmJq5JopGJPCXR4LRdQzSHqFaASMzqtBguZMJT816AA8DI+JT
zpJ0btQI2uq6zZspAyq7uPJOv3giMBUUjb5P2Hr+thpIL2QvLHdsbTdMQDQ7irxVLUqi+ws50NNNe2x+oKI6onMs2G1qM3Jea3tV
d9fKDZGcFLcWns8JS7Hm3idcIHJUEb8NU8FIppCuy1Memj8sCuXgIZNZt9kBXD3IqcSMMVjR5ox2ILQkduwPifNMguodNUzV5kI6
H8B4NfABBsWg2A0BzxIEZxMJmGTy88lwO4KFRssiRZEySpLboG4bfVeRifDNc4jUf8xEixfOVuPHvwtfyUKG0DgDdLyNPCX+J8NG
X47xpvQZBtrG9v1XKpbphQ+rPeHGrsR417A439lxDyKX6l/FCsGx+Aam6/T1gglSIt2oErq+LjVLrWEohGdu3DFGjAoOQeuZXPEw
wvcXwsBr+tiUE8dk6LesKt+ynBDrSsoWTHSWPw022rgAHikoPrxXO804AYUt4e1TwX7WfZFTS6L0m8L9SWTQOczUYBE+lDTMl3ns
X7GegoHdQLBROopLbIOQ+09qsFwaKzrBK+9IBa0nmoe5yKjVeYYqaL+k3vFeIi6bvLBQXhlhysu1Vqt8F77tWmT5PquoWsBrgURI
2V5+z3trqYzQlAvMgzUo562G7hYMzWVm679MrkcJFoDr89cMy6Y9uiaNwQo2cHJw+kVZXAXUMYgwf97QIODN/PBDhnwoKOfxJ0bW
0eRZWBV84NHkNw/pmB7OCDmbP1nAyMrqZnt1CxacxUDPCcvWxo4MoSIHdp2JKcYrZbOhf8wdn3Bg/xhypPL8fl7RpUkyUfI7Rmvw
jfQchQqGAdZ2FkCkgladCOA7LmCx+xrABjCyIrJ3UveYHWxY/d/XjqcAqXRuDPPO2SOZoJMydF+aiX0FqSBHOrJfGoJZ3SpXHyQG
zKnQB0PbMlNNKV/uFSc6JzSlNqQIgTx2sxH/645+jET3LeQWFJ0EW4Knfk3m1LfW9bgdfkKD48yX8a8en6wRSVTIW4s+QCuO8unv
KKLLoE+uNNKR9kd6LxAqmmgQy9H3KuAb73dEESAr3IxjnCoxl9+NcHpisFLsA8R0my2G01jkfUkFQl+dDbZURid+sD+WqMxTIhjO
dlVpsdpQyC6Q9eiT37l8g1MO6TzZ28VrDWuByGtnENC5Wk+OoAOodDVlEW2RLASINnjob3kwVTRBf1l2InAQDUo8aXd+EnuV5h3f
UwbHSayyqE+AaXh+nzKogbGI3N+M+vH8doXSGpby8qGBOvE4EMQkUo/cFMswLdJ9AL4CQ4enfotoQYNcOZsevH+NGUuhiNyrsoot
P2yhgUTM9L1qkvh0rHfEroUL3P2iVZTne53lSW7TGro/TnvBfnrVXGrneeFhZuNE2ZdyWbXUVeQ4qD8lqFNJLcA2P7owUlubtxp1
m7jfbVcddMZJPkNL0VFJNZVx9Tn4AcdEl4eygOzOq6ziQj/5dIxIkgKRIUpaCV+NN6rTsMB+kUP5Bb8D4B9PfLPxsEklYwLGOQEW
m3lOV6jgaujXPDNuoYjfcf6MUDdU2BVsopwEHBxcZSO7mKbgN5EVYeNsnjfIKUC4xQgY0SOzxyAR7KP3ixySS8lfCk9BObRtwpgh
JBbW1B4DmwRmz7duJhAM5jiPVfONm9vhxNMmAdwiwnhWCep+oFJ4rD2BjGCtKcd7wLr+TJ7he0er6EOVo9I5qBzqkxS+XFrl3/Z5
UK884yoyKYf0g2/blDQEInjIxbDsn1IGiGyZ/5FyTN01FD9epO9oTFBGZxgGSoTpEK24ynQYdoAZd+2OQKEil1s9Ibo6lMsZgcQf
g4nXolK8ejF73CJ8NpscaKSh9iRWfu3oIvvOWwu+X85DXi/h4wVNcmms1NFugJdcvVKNY4chY9gqAkzIbwt5Q0wKPoWUwBJ0RCpk
5+MC+P8vfbTQ3x96NGypj1TKNFe7+VvJCngEfo168H3nzOYiLvPvjIH7w6aFYs87/1bkYfnHy5PQZArGK8FSCmBE0OL0Oh3G6Nvx
cWAw5bSflrLn4NXTdoTJI0+68ryVsX78WgtFZe6tW5d+5vc+IWSVhlfnHX20KdTXPLeYujZXeE4Rib56/5sXxZ2fP5oBPbdN6Lwk
Ir+IcFruaa6jFD3ZixDLL5yIm+qeQ5Uh+nAEM1InWCm1AOp0UpjzslxVVVc570p1G4PTBCP5B3iBsrEyWnu5fqYELYa6qT+2jBCp
iXhjVno1jRmqs1QYZvV4b7pUBKrrv2n7g8863gL75Kam2xylautt4nNH28BrYsNV9Z6wz1XFEXsWtN/68sudEm0l9a8C0VejA2x+
W2Di0vwduhlK+QLwwtfaFvLKNa1DZAAiHn/xB1jtBY9MsK22MXVC82AdZsB9LbazxufNKzJ5Xyogejfz3d6UeonQDAbBCvOmP64U
kYLIDhZAe8gLHVelH7GgvF29rtXsPIKv3OKmG5IrSNehjxMM+RpVHVFhMFvx1A3LV7fRrRICdgtDjrYx0m54N5xO4LSj6gyYbPHk
V+54N/8VhRY5T3RuTu5f5CdbDQxI1sK2nU4rKMxvS3iIVf8t7XYdHUpCX+ed3/LVf7zcJP3u8RMv0vyQS30FC5klm9xSlbvUlS6s
7DP9zb2eil7d7qNVSajmIWb7Nu5N06kJHb9wbyc5q9BipX0XdxnpNYPZDWeuK0Z0/Ztcw4HnEFCyrAbtcGai8qwMl539v0WzEcce
KRHLSFG0bbL+kEiuGzJK8985zLbsjmwiu/rZGFyICtrU3oGlOMiRRC3lVgRC50svNo7aLD8ipmF8/caFFjniLRgvgARL8PqbKxoj
hkltN4n2naRgdeUFquUi4HSjqJNJchoD43p5YdPadyH2Bf3hX73iY2wCCHbQgLppeFnN9nbn7itP8zq5fS4vL0rO8uWDA4SKd4DS
/CQCTJFvyB8EKCFWUFV9C6Ry1nNOvnunHgLqjzNwPq2QRkyv6U3gApmeNyQwiA8y3XTRxAq2WNu1fIblfD2ORxRjDYq78o9Bfk72
GEJQv97yGuXlVO/0HPQGc7KxsdQQgCWwjcRauz+uknHLgIgQ9QnC/fnwv87dy8Vz+1SSsuFkJlDVd+6c8j2TUN7t6sSmSS0ZeHjW
s8AhjvCl98d8e7/Z+yHfv8JEA1i52syp/P7kr374ZgPyKMkggmyuEJOGIH74M8uAMxnR2pw7gpd8TLUbKtVsqeW6gudGe1Yo0Xw/
VlwB58394C5ecn3ZNKwYEljivGCH17O6pUkyXweQ2n8d5XAm3Q9hpgc1K+CYe6EJSmE/B1mvXYly3eN+oYH2eajK1WWkVgZVX7fE
2F/gsWdUvxY9Ay4NoMG8o+QiuBC9JaikmteKDrg3/K9NZ7xR4SXcxu7w1r4EH+WDKU92qD4/0eOkstWuTitqOLPdsugaCd5CF8CB
Emt8TsSuZCxUmWHitJNstA/quWUS33tG1HlS6XFb2RAFJn748Q4Qdcuj/MAXzOuEA55eW7Btyk50u5j5SWoyYIsZnTzvtosbMq8R
f724AClI2BBRxAl9Ul0xImC0uepOrn/TyM3cOKOXZdg8n7o2FA6NTahGXVe/WabmxoXFP/wkQalggMs=