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+a3A8BtbCHfTgUpgHd3oNBlkNV/rOzSiWLKFTgIfA4wCMfUthZC9P0sU1pdzjPfdv2vXcJT3wGnUb3yqCn2jaZi4Tz
uMpmMbUMfOcHaTkj6CKE2/K+TcUvLbqrIYzXz4MDiT+SC1VbgJgWtN63+xAuTPvotL8KjNQmVMMZsY3RM4eRSuYgfqrkU7tBhQEi
f3Y6sj1IrO+5kdyUCcC8MIfuJZrCt4cR3e4jJoJPVat1drS5IGMSqJ6qgo4GQLhR7vEmZX7dp6ZkLXQBKrR/Mj6Tr3x3MVYRmUkm
cC40X7BWVu373ADLs2UhICTlKRSEwuozyuLWfezUZ6nFfLGVhUbD+BU9RVUW4N/i2erKVvbqtRc3lEmQOiKECq9mzBymzJQUlDEq
XbqnCKkafQHfgmQtDBcXWVVtJhFCaKmTVoQmV5V8ZoJZYVPm9JRsYve0TnQC+GvES4Kyu8deTEuUvUmhp7iMaQdhOVmy6YqDVYtN
d2l6xdB8APTBnKCq2MR3Z5eNXkKDCjoRZrWl3zuOH8GN7qZt7cxZB6RA5MUjtW9BGSJPDrf/kL2cxFnWwzSEA2J4jOQjrxqz2v0T
X8d074Ce37kwoo6/sXXoPVfFxNxckuToMh57k6gv02bn2x8T1RGa8ZbiXUoFq48y6eNxzlTkGEvnnB06JpEKEX5v6lJfujA0fS/K
s+CDQTxEPZEEgqj8YOYsjWA/YRwqGMbrqvPw7xe/cAZontcg6sj/PRuj7KUFkx1X0aXJl9ZYNUfp9SRBmqh5aRQJlH10M/ffUhml
VD8cwPrkPfef/2bxqXtaDwIZ5zQ2h9iFwKFFKVsx/dwI7fO2EF1dtEbBtbhzYak36OWJ7Umbd8xFUyydonLYKBFkkbfQiel2YYVE
iiZWUxbFhgOOfoLunFfRutcol0OdXJyO3eg5yzNllAPqQDSvK5nSsUkZNRxUvHdF70VERGQ3nhG8eCdCA9G15rHtwMdoqmwN6V3X
Uxd7g5KKwYmXCCRwr3Wv7RHt4S9EJGyVjfk3tb7AfuI02tFjGjQI0vk6KFC6ZWpojjSFr+YUirMrlBWGzgacg02WIcTzykGUrmi0
oqc6WZq3lsj2WRRp6hQiPnPBEzYWX97WXD5renv5Kf5IgdRma2kXaEGLGKc8jcd0ft2psaIU2nvSO9mN8OkHmlEGHgnh2Gqiub4i
9Kg3M7pVmgkAsmD+UBdt5RaW10WYSA+x0Q8IvtC4KGeGeEx3BvgbAk4yzP3cnTjce2Aez7RACi1wT37VJMYsOJsw5DF06B+he+fC
VJC46+U22GuCFVh27+BGvaneLHhUxX5Sh5a2Qu/L58hTCzC4T5V8yILlf7Cot1pAjvlMNuKi0yOM1x5F51qUEvrU9rMq98Z9tLnr
EwwmB2WVt3eCvqOp+hBRwNQ3LYPjl+JRvMnVEXq3gKi1QPxcZbQX9+wq/tz++adJfQRERWlf6SFm5cIddkfRBr9XUjVCJInL53I7
AA/QKZqZIlgYFSJFvQ1OOYuc5g9oPUP8eb6rY2hapnRS28Ujl2QdsZm8vXcfk/ZDdAKNvYlmUNYQ33j8r2sJpQFkMbjiuTvhQPww
IA/MXvlE0f+9hTpVn8NLY7oYhFfOS0gNkufMv65pJMz/N+3j4i89OAys8N/Aj5Y5tsnLnfwl67G1VJJFW8WOeED9JNxC3Z9wyjGz
DrLC8slcdxfH5azO01D9tWGY7BLryWetLdruuEMROtfutW4XE94g7b4l03t4ZrMCOBXO+woDn0Jd/cUAMZNNlfSmSGJ9zZy4YJAM
8FtVvecQKx+7WrmiyaHl/+B5uoqoObj4cZvcp+GjYwQKT/N6FNrfXNK1Us+R7/9I3LfrSi5d5XGA+tBJn06cw1mgl0+5zNi5VhNn
pzPxLuLryiLIt79dMcvE8mJ+qP3Z0scrqgfvkgnAGXjFAYOn/9Q01rNdL9S06XwRAIE5CQZihatDxOvPAp7vNgVFw6BJWl90Lvxq
xFTgHhsFQ0ELscSJWcVXBkQ8JRJWmI/o5dk9X56VENMWSdo8T44f6Sr2jGdab6n4WvcJiiB5J1ZUw9TJW/MmoWqqtuju1IsJCTsU
MzYhPB/vku+bDILMlzCGcXBXLo5ekI899V3yNhZDmKc/m/JAZfNVBLVOR9I7Fdoyg/iaBwGA6sUKRHXnEZB/Cz7iRjRd1GZwr6As
18Y3qMgsbujWQjqVi3oIzs3hxBH38Q8vY8MtK+X1KjA5NEj9eVMnAH2jbOZn4EIVFWlpM03dL9W1H+lGqaHwW4/Bjqu9Ea/J6U7F
sxCZE3CvD3OQvsxKU7bwMBMsw9SK8sT+mhGyGDWk28DdTR4oH3IDYI44pkAOdKL3F70GIsL3U5xB84vCqGMxI5jnHE2H1uXaMjAz
vOJ0C2ArgpUchyN6XpJoDfl3jfX4v2gxAdyLeLnjnAWIAdZ4ksUtyDNBcO6tVP3o4sv/KgDAwQJTj6aEqN1pszsM54ZuUMRhyNii
+Pprt1j7YHS6BibmJu9cTDOtCL+LhUz5qz3ChOhHyDDMP7vy2YFP+3i1fCyHknkceuiORvxoloBtYt+1K/1gPR8Xy3jTKdwkWSr7
XSOUo1tYh2GY8t79UVBaLHj3SyJHMgEnNkHAFiJVjXeMrsmIWqDPw0uZYdAFRGbDXBsys8C6lVauvY25VnNzETlJRv1qBkZwcF1C
ExwPws3WfEIclU5ymGD2sE1ICGeohTKHIY4QQRBOkALELiyCSOyRYXOdDIKkeC38/9co/ctQBMgyBSelLSV0eeWjHHObnzwXtXbq
WGzkB9QXiAf+MucaZnT0gVuBmKhosA2vXCAguidSi17euGmzE4n9hCmt6VdMPXFGJlICSPIvUicLpheIen1409+Zi5zY3kZgW/6y
+KHhPuoS6IUIMwKGcypxEMojzE7OBp9eccYvDEQqeIrW7Y+6felYTiQ2eZwtd0JHrX1NmmdakFFnGK1HufZQrZIJjLB5PT3E/qLZ
c2H2Zz6hG82bXZk7/TgKXm9EfS4TRGc2PRul+ZCEi7pfxQS3TCUZuU9UbNy1EZLylN/GJ2Won+vj/y5IeW8KjtQonjM1BKtXChAI
KqT8EPaQJGiy/I2lLmGKJIT1yXwKwA2/ylaXnST43ce0esUOqW74uEj5dJtXj9wUWNahGgxnhgz/e0iZxYREKXkHovd3cNgNVlsV
UG/Xh9v543xOzNa1ctZwgDi11Q4ia+OPLGHIKLNqG9UPqePQWfp4TkN4IVndxzhH5o68HotMbDI/Vzvh0XR6EX1OKBV/+ldx7VAX
/pIt9hwOPC3pE7UhGvc8RWYejdZ0IxJV+lIsqmHLFUSbM4aIiIvuDJG+myDczFGfsrR96J0jv84StwwszpYMHFWYdKUyXBcK9mK5
p+8yICwAaDOPrhGYNTySOMQv0GTaZKbYNCw/fNNTJ3OSC70a2bM6A+5kDXBhRM5KW6auvzDDDiUcvjw0M1OAq991apAI8Z5MwYSJ
HhqCbcq9+Kz9HrQgw2EGKht9at2hWy3Kon48BQ5o3GtFdcvIHIFz+O5j4XSZoPd8ODGenXrDOwbA91lQjnIx0UdmdjAJCVGM91Fj
T6zsRDSRWv8209rJmjWTAZevG9/Ed4LfvgPphB6EJrDFyOnP2RNWuJtWCCQQMo2cSYsjUjA3PGVoVQS4Gcpa1flBMHEULdWupY1X
eyKjfj67NQHxZEnjCVqxN6zwOF3t4qTFMArYu/GUF9D1WxtVvUAtfvN0MYFjZTLmNPWp90AFiy/3klkUp3mDsod4E7zGH0Nl3j6+
3/eqiTKXWGanDxcX3n4r/+hwEznqRZAt/ksH4sF9Q0MEB4ofSrnLkaVuMm7MmtaGv28w7xK2RuXRdfAgzk4ABsockX4vKr68MlwS
Yh4VZVTpe1/okSOxl+IgGrrBcU4W3hjCboy0wzi4tlQH1y1GP6/p4RSKGj4dx/Io1D/pFtnq71B5ND2ueRc9T7cVOBeDtj92HKJ2
/y8g5FycTNd9jwdjqu6he8i/DqNehcf9ralkyVfiy+O7h7VyjO6baXut7C1nY2yPa/h1QZBLi6DfRXtRsouGaLA7EHdIUswKPmOL
iRR2Ehu1dhy07tuft+gu1VFzeNp50cj48Bc527n0vKCm2y4e9Euyyni4uhQtGm6GXVw79HxdkWLVUOTk5CRGae0AhZhUFFaPLxe8
SDuTTx/8eXf37xo0BJl0ZvF+RJCywilEdRxq3TRjoW0GKloKMO/r4kRlSAoN+W097AndNQ83LtnqtxaE51eMTtXq2k/vkap3EKD6
K3w4WM2oTRE95oT1CTw7IZwaxWx5IlJkmvHz/5JuUlLAXjoxWDrcdRir+Hl2X2g0OjGJhZPvZlJ6cw4YeZUssFVjXzBwGfWAb6iN
Z3CmYNLDgWJ0hE01iNuVjgs1/i3vmnueT5lxwM15QNr7x39+XKi3I7667Sb81JxibXe33KnSwy2/dE04AtUr+XNs5mVUnXxwzfN6
ZgLwx9fXTjMisackXXS1VNFO2ZnskMP6KW3nbQt22BtXYk65W0PGUwzAlH3pAwcPP8syNfW5bRNwbT+fWYAr3BSLn5Z1me+RnmIn
veJV3ajCxVQ+oEbsWTgTZKFXPhO6/TsUhDAu/EuQ8SWmto2kc2YITMYhxGPuBcdOCd5lKSTa0bC/V3+ZK7Bh+EEsE1rMM/I2DevE
QBTArBZarf855rHJ4eooRe0LzCIlx4iLcLpJKwgwh/6XI4DIc+gQRqxOwExF9jjzdhCBJUobt9X2uFMud1ZRCjE7N66Ebadh8SAr
9hkPGUk2ICGzjn6YV+JFPRFsTJ2n0fS3E7LaR2rompQ=