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
be7fc5438c2f5fb388b7431c3d967ea959bc976c4bc81123a18dee68a61febaU2FsdGVkX19JER1ZTmpVURucm48eKPvEKCGWACagJ5TI4d068qfAKm4mVhMXZlXMzu1a4Aa3gVD3lPp3yhb9S+mdD69/MMkFc4bE
EnP1DyL7tq8z91naY0qtBt1liVmoCyLX74iqCX7DUi79slfGPx4zWYAg6QBcTQeLpeHMmrOq9Sgt+PMgVGz+7Rgxi6HfHPdde9VH
MZwyvyHWwfEKK5Wtyf5rkiqvOXlI7WQCJ3sMPwEUDT7gA90QvIrD56YLzR0WJ3TUABlvylbOX10XrNKlUxDNsPECeFFBkUYi96sJ
MKO3+8+GJ4P9L+jHCo87NhA4KRgOpUjyF+i2dnNVNkyQiRa34wS7OV8uyaGIgYvbIM/+DW8KzJnTAHeUUmX3uVGoZSxOsAdrLPGN
c5Vi7Dk93CyDQTa2oopIRCjudbIv/B0H80B3yWfXRoGWWT116H1RP9EseDs5FVsX1Esw4Y55xS9cX7pG37xcC8jEEd2OEMbaBy8M
rSkkJRAN6dJcRet5J+nHhw0mQQU3gcV1oj5UOEXp7D/FZo41coefNF/xbI6LzJbEBm+JO3ozGeH2JZz/GFyBRDoGas64Q0+DNJB4
bveVDRmMO6BHlYfBPS34zqUz/v5bva1hwjsX1Vt0Ygkc8GlsgYAxMtTpTigqDy0VZ0IQpiA13AxadQaXli25Zw/jRDpAmZsHfhMD
9f8cbfnDrjeTYtxS/V0QorYGUgQ3UEYfNbVZNg+rSVUJ5S6n+1hwOLK4/CWBqxAyUB/eJmUYqz9Sa25rg1/e+de1btfHf6j7u4ar
iGbYw+XUHm3znsPVv6Tgoe/PYJOezDInlP7eeLASkJJTdUWwjKjjw1Rn8OGhGYwKiAqxUFeL1GoPkYpu3Dt/PuCfjCm4C1DSx5YG
3jpdBsnktiAl9Br27vi2c5PlBRuTNhhDM6Gn4DVZBpse+yq5TqAFlS4bA5Pgf3DVdkx9XUYYNEMTA6eXjCX4xWZgOQlCdW2sKoC2
+V4lsaPvykdwzal+ve7S/CtXZsj2dMBnf3aX0L/7mcm0WJ38xtfdCgNA87N/P+Com8/cpMlQ5jUZ14qNEAHHMxZhPRrW2GThiXos
y8YzUYq+tJQTKNkTEglfR8hr+Dw3WFV+0BeT90XQWRv96PxQZzBFCBKcivm9GtVz3sLoFhGGjZHi8PpnBz0RCaFtUBBLFqU6daK5
IA1r/mVV//BNkskQEMnc8Zo3RXZrjgEZ3VRlTm3PBiWqR+H4nm6sWya5rmy40g0N6QSJI7bjlQk+A5fd8sC9TjMLSS0jgRB0Wjx2
1KVj5V4y77Tuy2VOLOmH1jYDhFPaXqDCy/d1D5xtO66ziW7rawQyPEpOEn63NYpcDBf6DYEkDum6BMVHOgtPleLLqi4W3r9PNtJt
hM5fKWqurXfDPHI971FVS8fdJrufJmAOhkX3728Oh2mTGLH/6sQ879YFFClx1vBeZOJgxDNc4H+mBA2qM0Uc+qdx+PSS6k/+30+S
qnNlF0Zu2fs26sA8QBSNclQVo9Rud7pONReG6m8KbDPqhhthFOALRSGbKYrx8BU3l9w2kgHw9L/9wwAp6Wb4QgkbnMgKs7fq+prY
teVbhtOTSWPatB6myLz46nW0GYkRdKZ9mnWIncHNLu75foN6BSQaeOeMoJ/XUTrQ+P+0kB5XC66ADs9R8XL6XP9o4H1PJ2VDreSh
LcTNooCoXfxgD+x+JuoE9v3tLkRhg91NIQ286F1cGNATVt5p+L3ti7TJ/HtRiiAyOTCba3f8zmKlmSniiKjWZdrwO93nU5wc2yFI
L9bIixQ9EhRSxFSWHDBMxSRQoHH2AZl8LeHnlI8EJQ2h8DpayGXT642EGiy440XOAeCF4jzjDnmUwK08MAfkcl8KJfJ0Y3rk9d7d
uIEc42W+2bj7Iyt4JYdVmLw3py2uSWgbM9gh9r2tKl+XMi531/lrSYqADFy8cRgPoU3IszL0EmbnH4LboMdAFYV1vGv3jQ+QWMQJ
Mb1IJQ/pr16VtwwXx1ipUPk5fl8sf9AyjERKCJ/y/Cn5ej8uoiPH7dc13Kawn4A70OrT++XKR8w+cnWA+0iVhMVaaz9qplg1Tx+d
HGM/YuNJSqFQVbxsc5zLx3iTiZhtXaEAa8+u9e8D2MIOT6qRMZA945mrg2/5YbulOjjuucaLuFpxPx7cLT0RHPa87Izs19vKWXKa
KIU283W+2wOnsF650rxO0dDzuX+rB6MXJMGm+jlvgcalX1hXRzy50dpi9Tw/RTfkLR9rc+LYbgOieozeIqYAelLuuBotyNwCmF7d
iSZLMxoPof4gLo/MGAk7wTSYUNh8LYb0o+hryMbcKyRFSCvISqdQ5odCbA06I6kF3rpmsX5+VcFSy4oxBALDEm5qAVhfl5d7552J
kFfjTvUPqP5PfTEJcsC30wVrinPzCVjjdkNHf9gzwrdd7biB63jLO/IP/F2iXHsH4yf3sqViyJrba6yiZBvt2N8OYXeqDCcdnSz+
1ufWS0mEBW5/fbGondqpFwB5rXN9auFhFVIzZGH1HH555zsP3e8khUpguKE4naY93wJYWzcOg36uqG7eZNsB4IFDVtbdnrfazjh9
cpwSESuUYAT6zp4qFMBTotXWI3XrXxPK+MWViZTuP25hG6MIdrqqdSQm7d8PB7xh8RAkAdoU7dBUCgrYIuZ0yhYQjJnEu1Agw+y2
wh4nWiAsYi2PxyTKH6Cvn5E/8oaK7w5G4Hc3BobvRqTIC1C2ij47cfhNFUctNdP3FgCXHPlYBpFpmswTOAR+1vGWGEgebjhnpSkJ
VqGJ8kg4OZmAm0hsGxBsT9odnAf8k+gHSjYuWJUHn3SCT6y/efF8UnBWaAHSY6Hy01EVwskSHw7LQHzfJT2P382cRw9Veni0wCFu
Ty+5X6fCYT4uc/12POLFjqBJuk2IYvypaoLmD9UC2L+hroCgZj0QmAlEtevZxhjmhf4DrRzG4QcsvAJCJN3RkY+DIseiB742iLBj
dXAB/eXATVRJU0DSpvGbEQTA6VctJoGk/uVAh68ZtVDzrE6gFO/qufM18BvGdNSgV0qkVlIegnHkhzrqzigGtg8jPAFuWH8cXGgz
pCof1vx3Bng+TFDZETJzfNfHikBYBO+K4f5tAg8mIiWPsaEDKemhQbg3MOc0pySjUZlzYDHCNMk0YkaDAP3mu67gtYGRFj6bUH4B
zPffNgm2XMZs4nUzr5a57KhoZu0u9KCbJsQiFnX/s5VNNa//FAoq+efYIJSrqhAN6Ep+SMChGuEO2FklJY3kUPBwqwtkcj7B2Vk5
1skKyjANUrXHz0/OpGjR5nxt2OyiEXHrOcdIzhpsDFk/PDcRzpddvG1spEf+AfX3FZnAepPtSiyhTfd/skycLKgT7FWkPP4YVrR/
jHXgro3H78N7gjzWWxldW1SrVnVq/cQ0QFgJHW5cTBfQgMIm4xYMhhhILFng7aG+DIwCqiF6rkInJjnOd8EPfYhzWq7MpxRNiPFZ
psWQgruDpFd4MnzStQfFPJv2aecNwvm4HKS1Uk6wEJ00C+uhPfCJUm1NNzSnq+lmn2s8QIIoEG9+pB5YX08tAIWZJKGl2+BRUpI8
O1dj0Dv4xobzYkSTLR4r6bAE6ZTDqoaomWuHTuR6P625IO4RHgDjwd2V0CV2BIQD7b+o6B4hjbdOb8ex1INcqk5+Jmghez98j4OB
cG9TyJ2iUy+L7i9sYESzCmw1Wn1xlc/Cd8o+QhZzLgwmVVZuxBgrEPBfu8XpTmPkWz00Lx/IqsUl9jP5xF7gOyRwNAQqgeW6j+SH
6/GQhRDFJkM6xXP/lT5dXfNGDz+OzUV9hEUHNN9CO8fuWleM90mCRs3xL6odgnlpZA1G9rDYLYujcXd8NufU5q0xyyj2uAlaso4N
E2jQMi0txQf/cmF3VB/YytQ+FbfjTSRr+P5bQeJHpeNwIOkLuPPjpVNNowq+b+KVuEtRYy+IIB6bzqLFbub10vn3JNtluL4t2e/4
Aqm8CieZ0jBakcoqPP1iYJnPwKhZnL78fNMGZGAUzEnn0+cHgLCgfnQRMKNishoE+Kj24ms3dhTK/Av4vPd3jwS1sCXZ9sUdtil8
b6xq/lU88LjH10619PSYCDwDHLf3rBs6fnIqdA/RTghvAv+iAXUk0h0w8bsKb4a8edTVBQP//qOQZpsliPb0CsUXEteojffmSs3L
IBvmo468tWLWry1R8oR2P8X3oQZXoPlLul0RBQ1QHTyP1h4sN45YYPiGYeOfgwkSfOUJAOcflS8z6u+rBqE4s0MfB3P3IoXI2U/a
e89PeoqM9/YIz5nxne4Sbuzz8i7UUNVidNJ/MxXo6EMPxnmg7iuep2kqDguO3dQqN/UGr1BiUkQR01Nv+l3Nyy+3g+shaIASmgt0
Q1ltGG7F6MzSVqnRZM/CD9DcAU0162sjtmecEHA4/1kl4gwyg4OndPB7VKa5s3KqKT7UW2RagTgM+Xi+NIaoFrQPJHagKcycK2DF
d3x36/eIL54FhR5nqzerkGJQ1YxY0FK8H6jenzUrxOYCC4HUQ8STuronGD3odjQbPXoXdlyUnQ40eQBWYQKT3Ppr8ahag16zZq6U
ZUNo5pshILS0PXiIr7p1lb2mt4+guwpRA3GaGIsWYkdxsb3Cp1kv5oSxAzhJxFfoom40ovWhjeGmJbg4o3dcvS+zCEW68r9cvF14
L4mSitkFec+QzudkXA52t544OA/l+sepAlWiFqH3BCtFOGcG5uxKlZjpRiXCXqJSrA9GqcGTFih9KuY=