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
be7fc5438c2f5fb388b7431c3d967ea959bc976c4bc81123a18dee68a61febaU2FsdGVkX19qxPp3xzck50zcP8yi9ypJLs3fTZfuF2vHSM0Or+JgC4+CIUp8DflbKf1vAuFrGaPE1r48ElYh4dx8xW+/XALC3pUN
qf6zLlPeOUEQZ0lvDgvKl1AFI9KI1Jy3fSbNpXYFJw666qytbKhpE2EFFwN+ey/nSiBU/jSBM/gppxzCkVXtin4kaF14qwwTUZGU
7HH7VThXPigw+XwWCQypMKCKI7v8Lo7TlO+KDuM0k5UNUnyD/Gvej/DZxwCdfqSmTDAHONg6YhcCLXaF9ncb/zosDDkKagqFpJRk
6rECYlowQJTgnFTNcHxoNljiofs2K2WFOM3NUkSeyrRMd7tNoPGxaraQmkvCiyE02w2MO4t71r+RGcHP34ae98pXchTR9fLQYQRn
x6h/a9RrPEWOFpiY8ACUp/LIOjzRwsgTrmkOi7YAdumUEPniA3ez+7Kx3dybIyX6sOYKkGJM3r+/INf2HAt1ytj/aFnPgFktMzmH
jiJYA2+zj9iMweD3Q5i5Pn9CYzEtQ884qvBEpfxkMjMNR3zfzQtuT/uHe6jnEBAp8YslD/hkp7J9xM2/4+kry8x7yIwxa/TY4EOX
xoLzKmq9KbZOdu1I6oNKSPzkBPB9zzehD+zaQkZ2yd4J/j3mM0Xz7dXES9kIEnddQqHMdyvFKaPiNxYIZBrhf/MWpw4WZe+wYeeu
no5K0zCvHL/i3YwYM+zpKZGij/frpGKvC9/e9MkYB/GW/iNaVS726nXOgenr5N2O/BGDOK73j3gwENMI6xoUW7rSWx+wNtKItGXC
ipy6ziffv9TkTtsg93SHkgUuEZ2phEOXYxGwsYXclHcS7dHvL6PB9aij5KIQYAdVILmPua4GJPP7wiD0HByCv9MF/vz/unFet0hx
CpYs/uEOE2XQDQeaeyihvwIjkiLcccnpf2ukrW3b64iXuwG3siex9d0nk4yG1ur8WWvjEZEi3KkrxxXJgJQGsvsSzwj9FSeSxkdh
tQUgC+rCV8UQ0SnQp1kkHnRN55Ld2hkk8j65Lk3For1TewAsWm7oVRPCJRRQhY5qbIfvZ1lzNfUzrc0yiYhvzCd7Me6ddf6gyuWx
3NKDIUY30b6muzTxrsRv3huhTNhvTeNunmycQBiGk+iJbfsaqq9Xgaxj830de/Rfup5ljoakxOgzLz6PHU9BRJgPDbV2XspIQtPn
n3PQfyxPlB6JZpldavmhN1vwU7fWFpQzUnJpuEF9FR9ZXn82E6oNaDiEfUpSMrZRcWIpSzMnQBaHQXA8A+6u0t33RpHmBE0YTwbt
BtSXrZKAvr7VyIirKWDRXDOAeAfObUQSzgCvWY8f/lyR+8mv5vDyB09yhQo9VaVnwetRr5GHOemwV8kmOL8lfptRUpwpYLrRIyOQ
+4s9eg4XKsDGdevMA3OytH/cwya8svlaNKSAOiNDyDylKMjEOtuzIxSDo3oQLCre0Z8IoBVSMPDvL6kI+6hy3mTfLkSudTvSLxKb
G9JcRUfUpdAGYg2/7sDXXOMnTDPwm43oOShtUS7/a94LU81AG67EhEXm1SQjFimHaEMdvCXXkiGLTty9Do7XDJggTfeeEgb0vUW+
USyPlAx2csCQqNUwOZheaND1jNeas/CSHkk4XgIbyr4FHK6QKahrKC0AWGEWH+UYujL9Jl4Y95O9fqiH1C7H8/yXIEuFrh8us3sE
woeNvYP8EFgJ9AMHxgpRuXSqsnWlhEoUe8bsDgBN0gBVWjEBuEPJ3+N6Lb+PFV3tSOAcarywspQwf6bHLRdCzdW0cELsBY+lfjRF
yoWRvhE9wipDCAThkM9zGOWikscKdcd1qBrJ3Zxlp01+2iqHMqFIsxm6m0RCXPFWGcRLQpobTxk/zu4eg7r90i0+JkiWJswRRzhS
wGl1/P1U8QVAL6qSmhNsxjiWtKiOJZL3byOoFyOw+l2LMku+IqfHDClN8dFTSjK6NiFVagdjpnmaPByWf9K4pgkrjtwZ+u7PwUqy
bQtFkQoUMYV/RyWuy/lTyfmakyVP76RrPpzwF/eKV7vpdqKyqoqlYnpjBnTHms6yFRA1cQRvvV0Q34VweO+BTeB9T5xqjRJsQwfe
MmTm6Dz4tVxNy7lIBYFKnnpgfGzFE5Z0GlbF8oSyiJ9RGo5fWuPRisnjDOTGXFwcw4xeScy2czeipqU9jVueQPaphsY+eKIl0Q4J
/q6vEOl3/R6A8l9YK3nxt1OQA2f8s5VNM0yJ5lkiIUxFpyH2m1nW7qA0SZAF2O5sG7hj43PRnY/n0Oas7P/nahzttufvCbUgkjMC
U8vnDBe/OZML9hl7iFlQvPfI8UqAUm270y+fiSv7vOceUOYKN8NAKC/XNV0FPnv2BTh2DjWmkzsrhrB8L1lTxBgAAjndflENABC9
Xw1Q8uNEAYst/24AbdIwOkxUoEq1ivWhevWd5Pm1+JCILAcIgzMM/wCJwrhSZvm4FfvvIsnhCokc41s2FoKpY5heEMBENZIrbrvb
cCveOBF/c5orrd4pLY07p+/q6Wmsqt6MXU7GKK7njVcJo92KKBhs29WT/P+f+qK7NVszoGbqIp245IXlJSSS98hucKoyh4vrbBAz
NG3nlFL7bUhpw39p3qXKFEHV5Ws53+OAQhNXdydSlvSZ1y8+MHuO50J9lI3hYHnLgIt2nNVRcOLA/Ora4eO+evvw3BuYTh3S29ka
FYseM9wGIcfKDW3vOqori9c0eX17M0kYfPdWV3MrfrBDjaY5tSvtSrFW8Pmh2VTre9d2CkGB8t5EolF4Zw/FkvtpiRUU5nTVuiEY
iIDiHnlUOujTTcgkI1hRwfuyxmAA/TsJ0L1NIH9VjcBaDxOSx1j3XIe0MwKFJynyfEvqaQs6K8Bgph3q3G/oewBo4VIOfo92LXro
LB/lRoez52VpxpB3Q4hJREFCA5lSewjAHjvMUlJETBkuaTE1Azg+2qEFbUHkzgfHDU7TuxjiBCfPBBL85MYfGeG17oDKNRvGwpDC
mfOqmo2GrgfNO3lyZgyypAcKDYVQi/IYD8RlG5onM8Eh7jXAiIAScjSUwAcQugoZ6ejZHz6WM1zYqAj9mnTMxsN3JJ6RZAg/Iu+e
rOghxGEayTywVRsBmZ86oixDPjj0cBo+97jmN0FmN1lKQ9RsTWoM8En4yZZgKvKx4512/lUPnIoopOzbtbZrJkx1i5/EnR5g8OHZ
Z+ek1pTwKEGCAZnVCWicohEEj/6AQJ0chi5eVNRMWGYGPbuzkhYpB4YBTto7NYTcxijTV/QgMuXT2KhgSXS9YT+XFqLYDmNjfha5
Y0a0G1UeJVTdf0uUyjN2XxgopK2qjEFj3XOEaZpnkZ74tKEii3l2BiJcUUB9PoFYJLg39J5bdHDydYmB8wf2NWjgkjKTqImFm1VM
dR/L5R/rjEZV/j5Fr7tXCVJVEXNaqmNytCFNG8gHkVSrAs7YWZdQ8YnzRqutCAC3B2ZPB0QghExkePFTct84e7UJ3vxz2o0vMr0d
j9RdWd5lyAo1+kvOjC1MBI8SvaS5T8VAyUa+sfxa2IPW/RR0As+hIcOVykPzeIEJfQXusdM2m6hDjJG8D+2P+bOJS0AH6Z5S8ZHZ
ojzokBlrMNkqvYRY8RMDurKDJUuiKfWEvHhyTF1VZLS9C6Jeq1f5roazin2hwAAFuZSNeoqkrvoccsB5/9+urUfYuieSGx17Bfph
rxkb11j8MuvQx28wXusiL3VHYL+/6dWsUPv1/MQW0cs4IlMGhtbue0F1meBdTSwC5IjN5XH17vseTNL0i7w3lyexS5KTq28zNpBl
Xegikr/X6ZooLZd3BjGHXJWjx1ccEfhMq62ffX70Mc2SWvRkIGoyx7PDrK+61rNEkTdeU/AffhgHB7b24oFWP/3ATYENjMZrgfqG
/27Ia1vlMmJoeV/RVzbtYLNXxoGPAJnPGObIwogM4NTsp0amZ9hBkmA1FnNLERfnQWgBntw5n/YEdqeWYoeZtKqB8kT1f7nNrugG
XHMK4hbpIXHB2ZBqrzNk0nh//oVpPrU3Jiv/4aH8UFhitWPgXAjd7s/tsaIRs7+PAovWCOO/haQOjGOAREUY0mzUQqDSj/dkbC64
58lwmOeynrXzYYOvcZXwAJljrSZnP/PtNqVtEzfsGFPuPKSJkWzB6SfMziW6RcBiyShBMcEQQNzMq224r6YuVKnnmMdPNkfbfrRu
tLKNinZoeucMtEUwWirBmP6C6zPIC6c443ZM0qjvNDW8qGwQSvyvnfuW6UQQ0wDwYF/gkFqXhy5bt5brW1S43Xs+Mx2TVLgHRrLf
fc77KcoJIrp8ye7BgpdhVqlra5hC4MPCYX1fGsPwMW3qrPp6Lap0DqWOEFy7dYQQ1r50mlLhlWc4ULIN34jrPzEe3M/Ehfu6UUCp
kCL1UU+fXOCGtf31WN7TEyKr75MAa+JkgdXWHN3sv0s/KTbFCZBImDZ9use88vENlVMCDIuVc4dVLIT4LVAEbmA5l1tSpNOPxgWn
05Vopk8nz2bXeTCo4bmSQ+3AqNsvmx+5H2KGKeYKPWkr/5wkKwUC4a2NIqcQTHryYJs+vvptJHKz3BcuvZCD+2TL+9VwvbO08iGj
95b8OFMruJxwImn07Z/lm015MveBJohL8WdrbTOdNvVXcF4+O4FbAGNg3Xo/S+NFUkcie/25ezZgwhMC+kURa03qvOfmC8l1feLq
jt7MsKld3O/gjXTgQ9mED6i57hJ9DA7GOQ/TzAbNyyMUM7vT1uOgQEgqqoNJJsa93AoyjID94kimQss=