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
be7fc5438c2f5fb388b7431c3d967ea959bc976c4bc81123a18dee68a61febaU2FsdGVkX18tTM2U/Hlt/RN7Z7GvjEYa98sLycqebpv20vJcMXYyDDEyJdBmc+FRfqU1DaPA23f4J/s7qbLZ/l/wBvCZbW6Xmtc6
A62XYGubxU8acYUMRtlwKFKR09PkVyGoRfHM7XuaNwWGHkly4tdttBI/nk8suix3ArKg+09d8/VNbABQqlFWZXUNgs7FnJH11nf2
kSt/1DmyCZOYmkuqhLQfXCWjvuQkoURNDdhU6NF5Ij/IU2NhsRPHWB6drCISBK/71nAZeZ7lWBwMP8dHi+JU1kxd2MHES045g8LG
lEjRkpfskyhiQRbFvX4IY+8jUuxz8x90LYp5K0AuCLKH+FaEQqRxkTvGJSEHf8L8rcHobuQNPHatR9jXHvtYLVwDezlChVlx+byP
zeazRcM97FU/BlLDIh27/8DgXvn7y2uSXji4043Ml4L4DeZ4IWPfeeKHrw2ZS7xr5GOfkH1San2cZoz1DfzDJypa+cnfzOa9dpPU
yi3ufH0xrrL5qi0zOYQBHClPQay4T4TfdJ6/THIPFuiMXhWjbzFyspPjXsQx4PjOwc15moKIzLPphkaOmtXPbHvFUKXJR0jBkgTP
gzGuOicXD+PmHe00+pK/eS3Qxr9zSKP+H+J19VtpRot30eQMG1V7p1EpQ+6kFX8yZXL/lf2ibVUklMN6aAASqzQJ20rZlP5Fo9l7
f/+y4NdqC4BxlktxEL3kOj0E0euj6jdY4qEHn/CwCd3l11+6LFCsvLky38bu3N2posIKpl1lDwYRgbr8I18OOVDcNhR1Y/5CwYBU
vrHoqdbmgjPjEju8xxvLF34PWu26+0Aiq18xwx5WOt39tDtoo7flaXVahx/h7lcJndrWDbu2pfVK0qf5OroVMFqNcPOg0dzm8YuU
xFFCwO8b5FsLY7Pd7wV+UUUjGMJNyjJTKbi9TeJNIr0nWBqQ8Xk01YDnp4zf+8WwU1BJ3W5yAv7AhQRSLI7PTUtzrN8P3VbR4cVH
izq8mGunt+A+cfGCNkSJ2/8DrMW3xSiRskJss1iHeQSjLjbcgvodvuMPZW5omMz1C89RXjxAwBPXiVzGwx6ew1JPkHEbZHytWfna
lr3PIhWktCa1SI0LC6VLzJiSJ3i95bHXumuT/DzQHCvfysupuptzrsg2hZgHKLZeyeTDmvscqmy7qWEYH2c+kIdRFdUPcDnNMvZK
Oot64nyv4zWPQR98fhvzcp93qMEXdSZYefnQgIemsZeWUMCN9IV4QaOTebwYxhstUMznDtPO/7jfo//zUAuAd19wpOGu0SuG9o8O
8VHNPfrKBQ+0Duxz+Ch7ogSMYXaDYCp/BPz9G0T0ec14lbFphy3jTwxD9KjxPSp+r3jIsQRnONTh5mh3zs9J6bAdVO5NenoIkp3B
cITAIJxz+k01JDRwtJnkGg1LUa4ZKGE1+/H23pwfe3psMe/X+KhIRfFXCPIjJYUeJOQD9CkVsGAuoH4VSdwMVuOy7y7FOO6wy+PH
5SKap/1ttDaHxd6+lTWQ/pebSf9WJGyEsca/IUPlFOs0WkJQuBfmVkg2gOvbwkOe5xrDPL4msxLuJeN5Mjx0sNfnyWZT3WQr7bUm
uHSV8DA2hxKMsgJLkWAUqvvXw3m04sT93Nn63MBD+5tUockUJlKXHLXzbCMNKVpkcn6XqrloucJHuJVPPkT3IGkq89g40+Srcwie
u4VuRd00v0YLuqFUKNDpoa7NunnpdAuf5bAI3jZEEE0sOk1rAQH9inHFdW+j0fVMJ9/kPDeHe4ILIxlwJ9VFW2P0pUhyt7b/i3Dj
ZmMDuUT88gW3OrSFUg5bz22RB/vQqg9lGHOPybDhvlqMNJC94DAxCucf9zCud7CRS4rzGu5gHmhh/GRUBpeESHNWsrU1wLlj7HWV
qm3/7u16DJB7BmeZtfWtrcxEAldHmtytY26COT24Me0WdWPj+cFH49d1Qt3N/L7VMIrrWRjSiJw4CGFZhZJriz4jfTKENMhyXzam
H+RIdz87UdfAjWG9FCvvHZRCTwu0V9OD0HJd36m3NyWELKo20Krs6dKd5MMcBQ0G6FXthdLD18qv00eM32ugpRcZKgmT7NBa0jW5
KtYv4WZZQr/N8Z6P0X18bP9CK8DHeTEWWIPdYmPeVZ9czb+XtSGN5r/bzvsYRmPFThiArj9/3CQwEWf5YSZ/wBsBO5kH3TyxFFgz
xwdAqEpZAtEW8BGxymeMycOY6M8EJjUccEr3gB/WZu+zzBzFn4TGdPQRtrNxVhKIC+eDcrD5MXQ07ra1hZWEa/DwAEZAyX6iI7KV
ky/28YgU5SN5oUE7VPQeZgyH5RmXdhg9GjzPXiZ+e97y/EPce7MR02Qjep3N9WhlM8lNVEktf4dGtgQ008m+yZnTseVorMoJnxfV
cPm6SJGNQV9vB4b2iYbFgL2xPpPWHFvRY/u3sg2+h/epcXpAcCW7LtIYcmreFGxmaYHk3kGd1jbA99mmHBiqUVOKit9Rm+8DH2n2
mxyzEfs7P9WdIFkHFiS5bKj6guBif9eGRyTDVJK4VfoZFwcl8Eqgh62hZ3M+/VM9+zqPB3uRRQJIB8ipMToQPz1veXKDaq6gwvFx
pUAdWdz6c+YgM/ngLSym0bZnCAGYh/p6b3dQUDis4q6380QAOnFjA/6zgFz3bHfgz3D+wt0XnRsFLtpwkh7hQmjNDEPGgfEL/T5t
UklgTwejW/xvnMGAuDtWSOZlA1Q+I5ddKljT17k7eqhbZZifItMQP9hVqKRokmdGmJGFUzSP/8bVagaMfbFz4TsdWurF/rZvYG4R
tKP1IXuKX10IWWOFdaOqLvGuwYC0TbYNALPsYMRaghF1rOQQpr+07xs/0dIeekMOWVDFCzpVm6ULPH73HB7ch96QLpHfZOff87ZL
1sdiNzpe6y4bG1lob1j83u1wvgaZj+ET61rdFZD+zUsJ3Wx0zyOLdgqYj/KxlRAYcQcWRfM9szydr57SJr7cxn9dHrBjRJJayVHz
rFgy6uZ6ZowCzwGD7WJ74r84yDSQFvNzkmS0mxJ6HS64/O/eGcOuJyMtfiwEeQ0MqTdLlRmvP9Y8LyuhvYb1xippQP9jZkehXY83
L0s6CQjKLiemin0QIEmocnlzVusy4Nj3Eva6EQnKSOUL2JcuElUETA7/X03eBTTgkO10KDVFj8Yv260/vcAoJ/7r8+6vj8GOj+km
rlavfJkeNvXFwcxm31McvSpKxSv/b7yKeVoTxxlZCe7aZTcD7WjOVDpUm6ySJ407aF/JVtPv0GddfXjdTTX/V6Q+eRMdB1HcPvfb
T/9TPG9iuc4+1GPGOC+NPURqS4jwLUquTjpnzXahDTVVpRqoC1QYbvDF3vbWROstz2oljwp24ToidSiO8jTd0mpu5lnDVXlfyv5X
/w6h1mKhOzYBY8PcIgLKz4yhdlxD2rs2YIx++ffiygn0GcaRrg38cRYm34zy/tOpsZwm24lvRPRWvFfI7pjT5U+VDQducMruVrHV
kYdYBr+IgBQllurV3r1qBIFd0IEf/Jf4lRoDIK5l+Xmox2w90Qj0vlSilgOfI/r4CH7AxX3As6X1u3qCCJgm3usC54uUxHdvIKnD
/8AryPMV4qN3+0eeBtuXoyQG+wsd1Sy2er5J7ArrTArh5myNeAF3ZxLM9+tsm8RNn+a4jIBmCHibfqDELXJtlgns+5GzBsXEcX6J
OrAsfgw1ICbOkx5RPVSu5mrMAuZovjmxlTKz9kCOf89DQBbL64Vc9i8hxn9XrHvzF4nwPkgdohtzjAHDotZ9TYBk3FJdtX5Z3VXA
VoWPWA69aaXQV9tA+LUjHRWflJL5+Q1r207736YKnyhEecWNec8s3zhat5RHewVWYMFV8FCdquOC3qXHvg00p4WNkBiAw0nCoWIY
GzOVunuLSQhC5FlgB4j7oRX9YwkfwexzKk0fTUVsidLFTmKBY+5roMHJ1th3N+y8DR3x2HFH0+z+zJB4+wQjlPtu5zXl7aaCAlSE
M+nLeA+n/88XOrHlyLd897qfNtv6xoIDstoShYDTFK674nGatnLB0/3Jw51rskeKu3j4vIfiz9qxXjXKn7mjL9i27x1ifyOweaAj
bbWzRuCX+1soGqKCrTOm3qiz/2fG8sJoJ9uCEx68XhAvNipLefyy0tqJ9zX61lujAs7lzsUc8GcZtwQHlosFuyXI5wPsCPS4G9HD
nXNJRYes44+BS2XhIf7Jw0UynC25VIt242eZInXmL4RYTjmNSaCXED5MuY1qZkXEiuO7mBGv5HdMa+AN7mTaVHlyUuui8dMYo3pe
eKKcL70/B8OiKazI88g3I+UkWtrElSlULbG5+nYc04H5h98cuWxArxMbQwbe2/w7vRFlp7MpdXHIm6QO9+FCrc612NIPX8aZmd0O
X+jFdulSKh/E+CfSF6cjPlY2ydw1Si2qBg35ys/4P6X+agQRWhXjs57tLNSWXqrfcRRmFebWtAPbLZ3mDuUKjDJ/BtgSZoTzijx3
irk0D5CfIcH9Ei4Ci0cpPrMTbcYl7kZmKF1Ho8AJnXGwkEyRBHci7cUolr78YOow9Vt8NFDx252d+aGgY9yCjfdRHVMzIZvOU7WT
AlGyLL4vFvyI3W9PaltkSr/Tzuayux4XeI4TsRmjxkDQcHn+olhij4vHsRS1MdG2A5jaYC2UGiR8W+V1uocULIO6KqHRXR2e7xfJ
5Q2te61m5aW7UDu/Ui0DjiifnXCItaOt5vmIWE1TgOc0Nk+T91zt2JiRv2wSB8XJQhgTg2DER7lCTnw=