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
be7fc5438c2f5fb388b7431c3d967ea959bc976c4bc81123a18dee68a61febaU2FsdGVkX18AN5gcF2Mq+Tlgm1OtosSqRsvvDYHiOr7WuI6qSH8S0/VKIfPKTWURlI4ybAFPxMWXja26yML+7triyOYF1NyF5nJw
U8EHTB/xpJPxX5ZOYYJgHE9zmrURHREEXxvKmrsn97q63uZY5ririGQ0FzuAZD5bT1Hk7TQekJ06NUmWHXQ1BkYvhaN6WHZK3rDr
AfcFQJjDKx62ziAXwa2JHragc7E/pFUpguMBF2noL1xDPiI9SAPCX+N8GZUUfm1a0PDro9jV800LFJs1pxLGFeHoonXIEuEri/zX
5tpfBJMoUQSKwgK6hkZjTWVagzXByIrBnH0upp0fGIRftzSH7MqEJmHwVtVqyDv9Gu4ApqX4D0Pw5NTbVXK8lMa/b2BKC4j4q25A
F0ch8MYet2tHE6B6aD1EWqdRd3F60WAi7w/sH2K8kNNvbbko9D3hzsKrHg3KUYoH+xwQb165xUkUO/mshcbMsi3DWkKF8T7b9uGH
YiuNJjAONkYTiaHc6kJ0hlFCF2pr75V8orGMZ/cNNP2H8uciHR2f1SvfZTBIA7ZCweNHz3ryxOj6b+B6Mfcrql/aYZ6TfYH4odsh
INMuaL8Kz9+VHUTEi8AiXaH1F1l1cZomB0EfVotI/EnNf16gkVNk5pdrKGy5/ldhHXOR4VGhdEETQTlsMS3w2LXfbcgHgOeK13gW
FcBt3485RnfHiUBxErl5i0/0Y3Xb8JTFdYEBsce2ZEM4t0egO+H3p5yiFxxANqKxf9iJiXCY2gn/fPjgfvOFRAZQcdm1opIgwvlo
n/slgFxiVpSrTKAs0ea1nc0ylD7vsU14GQp6urFrNtz7HedLeD4X4TQzQYalKNR7WNUSmUU6IhDhixeKs6kxLy/7fWFUIIFktZPH
gVl4Y9Lf1SzFDUbV4z0M3ZpBHxHBTTQkHsC+ULFTSM/oiLe94xuOZwL6lvttdxLh0iGlo0gMs1naF8CqCtCmydL6xyYn47Qctl//
zT+iykpqFoy1jMfE2LXbmd2YT7mISLAAWig5OaOoDb+ViGST/L8fHPgEvK+ody0YsudkgGZXOicrdKaFffeN2THBmk3GhFX00eWq
9uGVCzWXqbKt2OfHG+ShcE0IZYjqvfe68dp4oELzE7ZDKu8tHdbbM0moRmi+gDZ9UJIOz/61PBQ0KTQ0WqyEnnQGCawVcj43ee41
GMqSxlfeLerUyvYnvBk2myCq7jpiTUM35cDvAg63YZIzQHjzm/2cbd1/DkuXtZxRt7iBeOm5a/FAKD1PjpQUTUKZIw/QEs9FLB1K
nEVZk8vZak1XRE9T4TeHitqOmFQBOel7fu1abSPnW0Ocr6GVtAyR3p0VDP3GJm3Hc9v129/u/gYb4UZ99jsdlRxbeuu9WK5/zopa
03/zoc9aFhk1ubxdKrHdW5pM/lcWoTRKO653TPYinTgJuIC7zrW57+c9e/Si7Vzc1f9PP4LssJhQbee9AV+e8YXYg8vc/sY0XBNr
MEjo+lhoPjSZfQ7iaJor81lT3X6lOzZvxAefKaKYJSLbzA8vxqra6wvKDymGoLQGpsrIwVVz9FvOvAOYzC1TChS5afAPBDmxix2o
PZINoBEt7HGDXqcisOK8VIc8DuRmCSVJSNZZyGqplAldRdW3z4cD+9+5v5Ln4GKbOSxyLljQlcljMbeWKJxlIKhSolXu3KFlt3tz
pTn72bv4QeFkH9bP2anwx/ZI/0W8aavoxIU0NwXsep5a9eWTDKFTlTpHXbcBurDadSeyE3uKrMCmDXnRaLujKqHXnRTez2XwrhM7
kVVDAaEAotqMM4PYnIybt3YeYGGPcLW1qJD/cAStep9j8ByP4dedQgPYYNYX8qC+D5iM/Y1hu9MxUsFD0Fe3w1oRVGYJKKvfKiUU
wrPBy+rhG/AtNa0M0sjCdRxv8zgjkUJlcoobn3/pByalZVZ7xBQWFFMB0dglMsRYMSozSGG2BW3bPq/JwKakqPh8qJXE6HlkJpyq
MMzODR4RgnPwcTAWsA9QgyApDnnm3r9lPgyzZJAZN6j2UB4OqusAq6zGTQ8vhg/CxAI0NRQFvsLKp6+m1OcSL1TIksNL/8ywhbwF
a9+5IOU2jm4tKe8UKcLUcnsC3P5hmGt8sHxYf9Yexe+iIZtGLSQA6sEPqDmNPBLZMn45rIqWmiyhgsjxvcbQmN784P95hQf7BxGo
MRdfZtlSpaOyr0U0BkCMObEanA40XXJSKQ3Fa3RsG5+bcacHcWAQ5kuugZcoKctA2vLWjtWQ6zUi87xniPQoTzzb1ugtjyXmCKKL
z7K8Yg/TCEbfe5NylJ62sm3mcGZH0bswdWmdWsVuLEh3TepedQr6P0aExCxgfPLFp0qpGG88Bqi2D14/YG7UOI3hPayMf5JYWXpK
G+BR4CLjko72aUUr0CzuMrPMhy337vdNqV3NlFHDHn0q6fb++K9zSqMaVypx3xmUHn5WjtkWOMhlbDeos8JIt7nY44S+3MFGHuNQ
KJgTa594GQCNEIie93RcpM3wBJ26Ab8El/j83nQnjqsbX+2dgyaRrt4mh4G8epb3/wncHPQx+B6KD+m1f8DHN9f6NoSmCoBX0L3H
W9TaELUHbSdr5lQV2/06IFwQcNywUQHDj3GCUuBWoV7AHdFzxPMQ7pCRW1BQzJGcIJLW1atzQAf1cfLK1mXIktYuFuKta1ve6Z7k
TY7m7O+aY3zJG1A1XErKil9vb9nBlsLjxknwaHaMCAj0hftdO+7i/3mCN+isJNABAiXpXvP+/1GiQa9UtSMTuwfH4utXT3QHW3sU
xs6RkrxdgCfcy6Xq098lHv+pgXKh+qHhc+q2YQ8geWLlmh6B/BaFenhnMkjnFcC0oEKzJ4UnCY596XtMpJn6AAFNIMnpC++x6MHa
e/yjE70O8uSs+zLDCa8aQhDZdHM6BP9u/ri+yh8OCwV5cwzJd7EcoJ6llNCETtcu2g2XQxfUvyXq7HUlvt2T9wdNjJipFoECvlxY
/fQfmYRSWL/rr9kvoftkDw6es6jrWjs/vbAZq4u7bz5FPd42XIMXwMgo9TaLFrw81MB4q8CDNjokhjX8NFSydgUa1JFnj5tqy2mO
cZdzcbXfC12Y+PQEx+3Mzr8ZetbyTQ9UIkRKvZDwjfmOu4GvmGDLwXp1VQeXLolemH/MJwhdRId76mUn/o7u1VgUE9xcQ3labuMe
IBV/a8vd6CM3DojVOfaLBJ5sNJMG2WsNZCVOcXT3rSr7LuRwofuCQr9t8OX7Z7niAMgHIOVKIV8LaLMann+lYnG0IPoCpYErq77z
rhCtqJm9lQK1/HDKh0mfkP3vj4lamr4BoMvzGPs7cjQ9lyTQgM2gwebA4fIrgqSHhObATiHn9O7fb/6wrsmrCvWtqMlk7zCZwEex
9fCvNYpaMoljjuIKD7Ra23m95lsdbDWh42UGzTfmkHOlo/Zd+/pDwpt4sH6Je6iT9/y1CgHt7EU9wFhRFaSkGwGtxt4TVCqTM7nk
w9TI2RSaOSYqffn/qnlGLmnqIHGElfI2/yPw2IXqhnlE7+6qSvVkHyz8Zg0PSxGsDHZNjBP+9cY2mEcWxkDsujPyjGI/JEvJp4Iy
Q36eoLEFB3Hka/J0xPrClvuWhaJjKbqdVxQDAYxIV3gblcHYHP2Zp/Hscy+L3reIaGehNqihDuHQZww1Y9YhnZa+0fOdDFCDBMvZ
Z9q5j9/T9Ja4ETpckwBY0c2t740y6GJJsU3I89h/w5GACudcENKvJBzy6i4E4xg9eYS7jJVwZH4rE+jnyvTOSoWH4sMUl1O3F+DO
3VOM3yXs9sWXdVbUYiNDkqVm8Tmy9CXyDokOAs54FkX0URTA4UcLAjJVN6ztMmKGMUAeUO+SNOO+c3jiMd2dJ7aiyNM8U2qN+4W7
qSEZeqK+QeIw1rpPDLsiwM9hvujdyfUWBl/VB0QE0hw2f+I+tI5okkNNCWBhl6zzVy8wMxodvJLu+9beRcO0zpBue16bkCGFhXAO
ej5SfMvnHCAp91jX1XHwXP8pbEh3K0dnHLIXO/WM+oVaK1sCsVH/knmqgNRpydazxKCOE65jvqiBcKXJjobReBxY2csPtRPrxFJF
6+Xs+zcXnZOHZ1MuDtJ+dT7KqFGYaDd9YVvFX/Me4pDtITE7eeWtAqLuk8LUAw3+KJdvk7rEl95Fd54K94EyEFrFYMMPk2tYMsXT
HIE1gPL1I8ejJVlw30oha9AOse0X5EvxKxDSwwPQGqhZXMmfatEAHTsTm2gRNMQa8goEsC6TvEh+UDvSKTENua/6xm3mTHtYWNPC
Wsmiz2W18ez+w7yfdYyTgqT5iEZUMe8xoHlytBFugWL8YaprOwmaVeevwaNVP2n4/CaWrF8upm/k1hKCKXO5MhcUkbzB6R5hv5yI
qdMIQGBtXG7hebrOaB/Uvu5soAfS1geTx8rufVCHB+XUMjg746DbQzoxXgw6kuS4CaTxblOBwDnhTEmlSIUrmw31PH7x5LkxSX7D
pwymfx1hZq6QU7liKEi5yc643vs0aV1NE4cr2GKejgMNVgJUuQBmO02R79UsSPlm1HPCns9aXQeO/iCWnOYLmTN+vIOJZI/3Z0n+
mhZVU9eKKmVqfLLC7B7tgZLGJNMg0V+fV6EQuq8p8iJRhKruXpwvci8FiougmybAyl4/oFyo3MLyEqQiVDkHZMy4LcK4/Mre0AZD
U0BylK78dtBdY0fzHIMVnG7YL1qOj0indECSDwmM4n2G6LoEGz2sMnVk6NVtb9l3EgTiJhcQoAY2SuE=