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
be7fc5438c2f5fb388b7431c3d967ea959bc976c4bc81123a18dee68a61febaU2FsdGVkX19d5guJw5B8i/qkl3PTZRyChaXeflxdhE8siQeJcursSiiZ515SWf8ODfziKwzFuatZ+lFjCgWFIUIrmd4rIbyLXThC
4hTALqo0T8rUXrKMy1QDgXxucsaajtqpN7xJ5PR3nzVxTLcNkbDUtDGZvRc4TsySw4Fxxjvo9cRpwI+kqf4D/M9YqGo1GHCR1/lb
XNC2dvXucZtK75mU4xRRcZJ5tPX3kc7erzhk+6z3oat+hyW77eQZaS69+k5l4c8TTzA4xB0S6NG8CiQ/t/MhBqWRyi3obpxRczr6
i4D00dkZbStaCBAYJmGf0M7W9brxMHex2Octhm3RloRzRMa1iLaQ/Urdvls+YY00WLMw5q4ryai7X35t9faj5EBZu5hu14CQl4WG
YS3wDkuPyrrnU9S5s1MgiCiJJsgdCsVRe3Y/R9cyygO6F1+ZHK2o/YOP+azgIk3m1X98Jd+A2L2GP8812exsLnRIAp3y55/1kk2v
q7y1M7bFIoPD7v/EwM/JlQetncaT4/f1hCBuEuGt1ydCCiSQnKKTY9NZ0vFwTB6FciQyaEuSdeU55owWmMz3+rLUhKKvIgjHQUw1
5hk/aRHjwUEeeDejOMpfkN2V2xPj8e/xapxtN+7pjP+sJNZsXFyZB+tZ9346ZA6mvp2ed5oSmcCgLSKVj4pG/h5c27JLUB7jkKpm
VGNXtWEUpOumc6VLpoGA1A2nCCKnfqXBeUvVZuB60M0DEbXxv2JVrWe8Si6PNkaKfA7rd3cElZ/i1BYYj3mlFXuIuTBItSWKpobe
hp4iQGmCd7dho4QHet5DUMsTMtGmaMOjUvXQoNxaapQBwX2sR7BhpsNYR+tFE8KxVobaxXnzEEMLM66bxvHqfe/uikpvp2IYOBFg
K5vjlKjeeCFFR/XdL6MR5GorzQoVe+sDsxMPLmwH0sHshydiytx5nE9hhCnHIn1r89c9SRAg0rxy9YOGALh4iLztn7KY4yNFE+q1
Hdli6IW5z/hw4dBv7u8zrzfSlNoHbDx6gxcDYwrUn7BseSH2CfjatC388O5xnjWq2R5nxw6VJBj2YgBJIa/Gxbabdo9imO9IMTw2
l/iCB6WwywnOVtGKZqRufPFF0dF5TFf6bVNH2bpGcp0u12s7li3G/2cGGvbzxYkXhhI+iZVaHcfzYTxLllUtshP5yFy96oPCTcja
/SFYpNzPvvbAMdq5xTXyUfLV9tPO6To7DC7d1ICaE+gp7p37qKhuQ9MZPwzlQUmifNl++/b7vqpYZPykdwyz+0c+TSHUqsgB/jTa
4CWanJmu4TvWecqBhX9VYQQy4r5umBB2mZdkV8aJ4WhboY/oy5BZx7PBHG07ZQMh9gvXjMxIlIG9qtXiSAe+QTh9PWszsS6AlRIV
Am/M5Df8lSMbK+9soeOfOFURh8t9qJyw1+PHp6R2OcuOzBGqjzlks1CYyKytTMox994YY6UFuMkGOO9QUZt4xN6hIyr028MkNeky
72YTaHMEBCKsTdHeeYpkl3gJ8kCCzbCMi4J8wKQwhaEEujxuWOofJ8KOS26F1pJAq0Ftdju4KbeqGUQjALAcU+Jgvb+pppdkDWw0
V8P+X5WzYQIgsvEICNP/KHXzIGHa0hb/W0mz2d8T9gpbQNGcIDohFvKRW+L9oBa6B1HqmF392sNW8Vc2E7URHxygq+uUmSQAOj2k
aXDVviT5lP5wYYVvXrbEtfs/R6mNt5ddiyu5nO8UBwPgAnxd/mRfHLhp5LhEwfIzcmTP+HJnPnpDj0daa1TwQA28Fcg8z9/wiSMq
TSmjQ09TdZDUKxjjITFkTMNibIdhJk9NxAUGxHLVHYbO6hHMN3Lb00IATNUYzMihxWsE/EvPOyeao0shdxHuw+jnn92e8VhVsF0t
K8iVsFKJmefd1SoL23Pj2wbZAemf3Uz7TugfYzEnzoBwZXvatBpE4AhHrMhbog1Dg1fJIXhRAtQsfN1J8PnVSe7/+HtI2PY8ecif
8trKkaD3T8MMNa08QIZOH42P8YhCeMgj2Pm1k4v/C7SXptAwAfH2yg7Ns+NxX2O4F4EUPJ9lz8UWJPRoDyxincUYdspweFis3GqQ
zCeMQYlfDkU5f478TXxGq4kOE2NtfvKN9gvSPXAzTq0LnQcO3PiG039qKMK35aLSObXjmfaGR+E6fa8Pd7RlzeolZL9tTIyU7x9Q
ml4aYQqjcZIIfsPkfQHnf+cIvBhsIMXmrW4FhmGKxWR2xC3lvMH1a5JSK0LHvTtZZQyu70+fRP/ZNqJCrC8/EQiO3denK56F4Dak
GUeg+gueMGuZHnhXydDyMSPQMTxUtFiq982h+oCoT9hogfveLOmcBwueOFfwaDljjmgaQFyvPU/w8h0LVqbLEHDDZfTztOYTSjaR
6CZoRK3k4drn35V6YSuBU9NwcXPARjE6gEuCW3S5ZCULy2EDpJGp4TQypYhtQZ5GazsukHvYSt1of8Fo/Aq9xVxgX+gNZDkhqu0H
gkt6a0MrSfZJFajg80S39EDb3fGS0GYYoQ4cCLR+Dyfli+8sdjrBzFXqa0gkAW5wdHcVAV0prmfimShbRGjuJDKn66TaZ8zia3Jn
QZFnUd9zeQti9JTA5M3gl7CQvEZxloPrs+G1i+Mc03kZ1spj+B40+3Na+9JAO2gZ7rqCXVr23AU0pB9VvFU7SmfBpcC/5xQV0X5w
wwOXKutWY7tQ+ijetS7A+z2l3KQsNp6aSq4rXipeJZItURKXbi7rQUYgLVMEbn3gkcETfgY06XDqNMnpHPNoExZdtJMXYFzWCCzc
JXJeuZNQ2YuolE0HJWQJIRl057db4foTeBdetWKkQXoN4fPH6gfl/DvrnAd5JVVvO0jYF60Vj2xO9m6H1+PlgD/N9rXAxYlvTb5v
sipvRNAoB0OaaXci5KowXd8i4qC619z3wU2B8BG6TfA+d1ZpmpglVmy882+EAeBlVEXdJk5/RemdtqpEGNxdxE8l9iZ4bDlh4A1z
rtOrig56iwFng/5Cah3xavhKI1j9FeecdnlXKRBkkqlGUIgfqq8qZygWeAB2w36xhzcjHwjoHK3QrjQga7CzRS+WrskEktd3S3n9
JinmfFZ6f7ocbNaPY6VUGMlibOpzVMRZ/9PI9qhdkXrBhoojIiui4OvwSv7NLsW31txdLW/zoEQqCi+GsJsOWcS6fyJXwXu7Rgu2
Qod7RFv9MtVW8BRFJ3vibAnNbYzFXXSwgD3I9+1RdQD+00DnEKjQVqgns5aRXuWRpSmAQDlQu3tB+r+rWqKQlSOVy9/DBQqklFKd
z80ZZEgzVW/51U7PqIIGNHwRctHbuR+bA3ILPJzy0lGt/mnv90XtVmqbXw208oAgPjURI5Il+dDbI/pKYA8C7dexp3LcykcKkwFu
bMrR7wg2EUSorRAQp77Wp9cSp7VKECmhcTpu/XrBrwFAPoOKgg92yzzhUwqM2KKP31Fs9EpSACsFRi4+SxCEubXa7Acqcz91CrCQ
6w8O7og8HrfKYf4tIGO7kmYaz15Ab6tqRkkU0HwAI6oRhVVD7W4wLXapCApDjDGLVuL3i9jWufHavdyVpuXhnSQI+N9TwxtX8NEy
JkxpSY21PymvXCVcZB/ivVvsxV3nWbmyaQIyq1YLTVDW6mqUnM3FjkTLiCyKOhfiYZ1WYhyxp0tEEZIxB2N+mykHhm/oO+YilXLz
/zzMGuxGnSN9AAFrKielCR13anFrQHuVqJoe4xI94UJkML1mv/XfZ6a6NDNJOc9TtYr9ol2jXPadmDrdgvZZIrTRka4HOI8sJVmh
Yyt1GqCZ8BrqRNSBE2gXnq29UzeyC3pQMiKeXNzoZuWhwozTYHEVNfooQoy3cfhtcT6X/plCaitx7+FQApkCOkEpS5Rb8ImCk2t2
FATvRFkXf6iXzbIR20Ia+KsgxMcMjO3Ap5ttVlqtu+FZ70TPA0dPF24/u6KuHVTtz1D2RWNyR9Zqoa2PRz0AG2P3ptx8jzu0dNZS
RVw4cchNF6aj5BPATj0EIZPNekR9oWkeA0FQdy1jTiEFsTpvtBh5pAtCyMX2OSHMJPU0bY3uwlWrkLoKXBkJznNjIBfaZrnaibGO
xkLj4aTaDq1P0PYEjjhjiP7MTJHAyPVKKsLwNCEFwxE0e/zZjqvjIf2NroU59lERkD9HRZu+RFxwzMU1P8mZJZNln3C34lnigkU1
771cxZ0isGAEYrwchL3AOVnDSbtrqTBg6O2dC0mwCK/JWpoyKoKxzP7WTvNUVnQyrF0M5UIyGAz7Zi+SITxev0ZqhwmhfbdrwVQq
0vFvQWPWhMWG7SF/wJ21iOYkrOZ2USForYiwciUM5dcyPelIkbrdYMkOl4ulJuYCJ4lUkB/x50/VA0u2+aSbbND6ICt1m8OcPBQW
N+wxoQjk3/ma3ee5TrFOnOQhzU6p29snkpS6DSJP6LCEQmJ4A+pKZ9bPlFiIb6FeTvl66CcL5POVSeuhCtvBFVQC0HYcfC66gkLq
bodmr5owD7YeW1n/YAmEZZUg/DCBu7qp1uc2RaLfcyuvLZSKIvIS/kaMceP8nwW3KcwK+IT9/8zGIouOvuW40UbOpnpHgznUj3go
1Y4kHao12bRQC9d+yNqrtPqRY3hsuPSS9y/DKne0ZwlUe7kq2dLWeMWBGF4FhZ1Xf320le41p5Bp7hzB2NvOmgg98Q+SFqtrqaBc
NHrC6A49nE4b+06Qc4kV7I0X/qlCyOm+RycfiIpos/iJnoBPe/TTmSnIowW9rP7A8LemgG0w7GTe/8c=