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
be7fc5438c2f5fb388b7431c3d967ea959bc976c4bc81123a18dee68a61febaU2FsdGVkX1/VW1weYD7PWY6Ql3ZRi7ETzwfT+p1eiYXPnaq018auccjmgcuHrerVWZsY3TN/KYuQczbJ2j03sjNXRnBPo/nT2MjD
C7M5vDm+PLjxdgDGVegAr6I9IC7oY0+cFNVkWIV8yrOI5VSamGOq0QOJ9+afGX7DollIKA/C/t3bR71+fYBTFCTCURpiuqzvTXDA
lqvjhPREuqgVlTcNlo0fCzUN+Tjv+JKiylLiHTI2wBZeL+Q5VWQiDNch4CUoLIAOgNDCfrLKQieTmtBxz5eTFnGtulmU8BJpxGCW
EkOoAtaMKMoqBvFHnqShRtmUa/4zUEWMKD9nDYuu5ycPyvfcKGZ6Ay+OMhO13NzQdQBsCL1JdXy/bu+mMq5rxRPRRpvR8CWr12l+
3cacJtMgoPxdG55ngoZqNkq9VgbWu+Kjm4gDA6imSoxA0YCsLatjrVVtaXRvrsTvcNakjuvYMCW0YcklMeZ0ydFakzh5jpGnPYRN
I0mK54T2RgLiPr7T5UJwAb7RqcR0A1xMhu+6EJPO2489qSx3VxCalgAdB71ShnspHAY52TzSJGW2AgyrCcJTryvGL2yVdelmDWlb
IdhyGj49kVSy390KVbUsPPzqLM+6TEgTSkOOMaUqQ52nWk2AzJ9jEAD5heab6I5/9TOO/bPcUwTHQyiKHAQ6KKP3Zp3E9GmjUY1I
q73yDCGf5oNO9XorpGeXJPCmbi7Sq6bVtJWBJq+wYttb8uZ0XrgGEGI/MLNazVwc2TnRF9WzCG9as+uodVXGeFFy9XmfwtOTbKQd
6JR90Ir99whRRkokc13Y7Yx5LuSLiZgg2ng/PZs6rfK13UsYBMxjKNxNytlXbMc/bhzkDUSjd0QYze69xrXrRXJQhc+5h8X7SF8h
0qauDvC47NWHC/fYwwLQByCQBvGOA7/oIz6ZEdcPvLbH6Ru/MJ6bceSfT3kMrWnPKLlspqvBzO1ZnZmjUayfpX0ZZgpYu+An0SiS
3KGykq+4dQ0VuYU9QaccjnfoDMUIoqQciByWqMhd+jkFcxer4JM+j44ytf6c5SUCiMfKbOOLJFxZEkRXFBCcgZ4x+RcmwUhw7fFw
Ucr0AynyKCsvMO2poN1K8iJ8vm27hHGJ/Se9twv7UM2XZqUUn00wDzgT9J91TYvpX6+2nwfXqDIfa805pVjkKbW8I8C1LEhuPqzA
Go+MX6i7o/tQr6Pub/tVMAAsxlE3rCGVZIoikw0iR06KQKx9jM+dSifC+Nbm78XCadxJybo03Q+yHMH/tss6zd6g2SBTTdVgGMRW
d1Lv/YMAj4fT7lkmTJmVBBvT+wgw/Q+FcXsKUjq433+B3ZHIvLsA3DlBdh+yjZoHKU87d2BVWtPKb0/A/5IzI/jKXiYhVxkEl8KI
xJJa72C7VqoymJpyb40TcKzqy4hyz8zIBOmO8sM1FQMnN/D/7izb3xJhkTfVI4VDKrp3ejYstDoKuMFCVr7edE4MA7yAQAAohocn
kFEGHbr8kVTeJx3t+kzamIlNTiSCwd86ouGKRHVnTdgZ/5mk30GyVMVFJgKJfqceT/dZyEKgmD2ClhulM+nisEilz9S40V4c5PzY
RcSuMAbeztoQsWY2c+xbaWgQdhFw9iK/M9vG4DzFwNj6SbtNHTpnDT78AgwWSvAwO5AogEKzTgzn8RAzoD1gBB21Pg6ZwwIM8cxI
yaqEHinLb6tsnM3EBbLk/q40ir1I7sLTTDWwaHYLMDyOvJXfk1dkCXrPwjPmboFd0ygFQgUcx+z2RKimDax6ymkHz7/3WUltn4je
0jWvQPmYl3ApyBiwC3yUqrjSL6G79Co9oazXhQmL9IHPXMba2tTtAjB+4WxgrPO4DeDulo21KdmVLAjYeqH7U+LTywUjQgAyO1Yi
q5ed93i+6ZamhXQnlI1Ms5xCGaBVTN9r0xW7cOGIuLQOfGDy2IWFYm/+tdlRBTiq2nSLUc00CbtitOLlgAH5hvKZlXnOJC23rJca
OogJuSFJnddLFGPg/nidfwBobaZ4uaBnEsxgg1fNJmM1UK9nYHOYd+sZuGDmLC5KOjL4YV39XiQ3V16esIBlqHpBjlGLMyjpdUOX
c57EBLnWvUmqa2ygavdQ9iKqpMo1riMK3EHWt8HEuhUFws29V9a1La2L922CpciS9OT+cRLf/CU0LpSvYJH115bApbczn6dT8Oyt
P3ySPJmmSg5IloiVO+6KxYJ4K9fWkX/w/lqbrbvQQHpp92MzA8A1Ga3ck3WHInBY57/ctjB0v8BqFsbpE4AdtQoUYVQxTBrcM4mE
v6ius5oNbqlBdBon40kLXwru7bPWy79H6Nzi1vCj0KZyhQI7WmJdayss+V4Ug4YqI/cqh9oS+YTXe/NJ+jwdbOjReHFmVqBEZviR
Uw01ISF9brp631t47SZ4cj0RRxUMrBTfa+ziZpaM9+KGAPAplIfNsCa7m316E/YdU50avCpLf31L7I7xy27qZ0scnh80vs/h5NKc
5MJnCxR1cluf6o4LGI/jxRvJxG/G8kjKAtVBkn68JybuMIm3O9wEDJKH+WLDvoKGMJK5feRqxZjiFuoxWhP772E5Onbj6nzz4U9J
SyG4ZR3qWgyi0noLK3rvkHFz8w6hIZncEPO6K/2DGHq9zGWDrJWBdmsJ9bx4ZdIf4pkZ1vgWUIqtRDENG60Rr9u+ZofjlVUEM+Ge
DfD+YJb3DYZ9Y5eyYU6MeePdhcOatsqBd0gapuctJpS+oebAVnT2d4YCRpkGD1wy/VEuimptoXz39weP84HpMvIMJBKpGWFh1Iqu
08UZSkDiCsF6Ci9IBg1mmKv8xm9yoTLM7aoC48Ep3+VGLaQpho7p4ac8cWZywEut0/4yFj8oIJORil4dl+GkkYewJ+/w2oHsFalf
LRweF+KFGMvjJIOCOnDVcPuinffk+bwRT9Yh+a7YiwGOlyxc4yCXN36IEZz+vo0Jw481jr3RfVwBx7/230QNxawO5D9/qC+uUHow
8Bx2CcTPFC/xa2gT+LmO762SgK4lCjFxhV/N59oM/HAZ9GZIXQV1On2dXG/bQo9jTEct88uDwzmJdTk4CuBFOqukemTCWt57BpPU
czHlgqC/t6VSotThWDu6Aipl6ax8J31t12KgIYdTCCrPhYp4MR5+EFJkwQm9Agg5Emec5BTkUa9FXmDa4+VWqbTPdw0beflqhlgY
yC1IpONNg409LJ+c/OtvQsZPraNYu06xziokDjnmGnBBTwUxpbOKusQEHbmaheJApYQZwKIEvLbNJnMA1VGl+XrFHFvRlZGY2pXD
wSRMCjsn2CgkodPYov8gkLAVKpm9VNM5xK/llDCRHePArDxnVagyWeSP+6/QbcMz5WOvHhIeF9zyIlwT2Y9EGnp12C+QfWFfkAHA
4vyWLSNJlQSRcPEI/8JKPWOaGS/3o9bm4HN6miO0toVQ8VDHoFS6HVtB0otFAl38hzgj7MHqVTf1hkOZgbTcnuofZodLaYSyHXsC
kJWAVja3L2QTS03VEUV9LaItv2ef3kTPUwoYcJddHTA0Ym80o3MW6IMkRchrLylkfTfKFAVMgGZLATznPwbIcAZOTaf0y3GxMDAe
ZQj5pjtFyfnQCK+8dqYbJ0C29CD9XHsnqi/58WW4LmlTit6BVpzTrWWbrCjmLhX1/zpfI7JYq7AYcRykRubWt3jOmyd+XRidoEEF
i5ecPESOyYI7LUIfQWqFZnCla5PuVp6ysHt28YOcjr3hLlc6T7FcvLCOPjjUyZu7t6ii+fuP0kj2nm4HGruduX8HseWCT25KYVCD
8Dl1U5aLtQGOhvKvKNmHKHM5AYY/Y9ARLfStXmVS+1xbMl5ccreDsgfmqeC1dFL/t0oTGaDM0JF+mTM5m/vdEq1VXwf5Q3Vqxiax
grY6pEqyF+RrHDW/PZIy/i+8BgooEn3KGJoSMWSAU5PopnAv6qR4kGcjnBLehkBMfW98hS+jchOUB6PXq+tma/U2yTVxiNHwFq32
W4DVvVoJeKebgLIcCQpLI1OrTv7CxnDO7H1gBg4SG7WxTSuGh4fz+1zOpzyMIdkWNXcTWNYp6/F6+3QTISF0lNBWDb4mt7z1XT53
Rc/3aR/PTpLxcG4be7M0pLQlafDtL7l2TMhK3E9Bx5Z1qEdcEssygBU8H9qfJ1+marMa7WLsTsPdEcl6iysXDwiuwHdzUTFIWBbE
qpnKd2TMJwenH2WCUKZrOnobni57v2Yj0uOzKCC9roiCwbNLYkf6yB1YUNFQ9Oh2TbnWFq3YhLarC5HsY4wAhWqXbO7Yo53k9eY6
RyS95f8r6XdaoDUYsLo7wp5fYJ9jQ1/AB2VdCl4jVbBzM0L+2w/sQRUbQDvQoRTVTBTUQuhu9j1hIlzuR6rtpRRXM6LqV3+mBl8r
x6dZC1hPWzr1NXI7ezWbR2PsWmiDlX/DMoMWi/omz9+WQ2IBnN4nBNfufb4GUiT+wrO+jfvvqcY2vvZAHQZ4MP52+EexWzqxd4sJ
skutWJ5f6yEd2WDfrPtSqV7CqXqZVnofLXz+GgY+Yt1R69VhFZYfu6010R8D1UaA2EX8TzaFQmxblJ8D66eakIjL5jRmTkW/HsiQ
SDiswEvUXFBxYjL5bPx0OrzbMvCt62kqRSvd1OL8Be1UHMHxh7AJ2B96Yq0lJ7KnewTMCgpP7JFZLi8X6XpW//ft9NkCD6SFiSId
tM5OWTMNw8MDGzvUWlOJ8RbwRL1pQewQo51I4EimHbnlRw70pE8lf8IAPpTB32UFcEx2a492YThCU7M=