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+6sO9ZSsTPwUzjRCdAaqDJCFNNW8m8P08GVnlfPPlkh4zt/1PtQdcxXH26oZtkhBuZ/sWlW0NO6Ig7h36vyXDT58CE
0YE0ChvCyAqCPaGmqZceppro58x6nkju5lKPXutp96TgHmx0ccVem5aFRvbr4vtaqvWhI7stdRpx7XXJzhGypIkeDtxGGbFXCVe/
yKZ+DHE8gc3P9o6vsMbcm9+jCHxz3HlobT0H5C/b6pYHcVIsm9BmBG1k8B+hL8NNXYFlbTZujm5opjOmkOr1h4zsAQOHroIDcqIL
1MRRLUtE2wo8svyw7b7dEULXri6cok6HtZR0mB80AHAbd4s0Ar8lQHrrt6L5w3jAaQKpA6z5r/0AulWOHqyI2BenljGhh3wi4rlu
BSyiL3/CrKTKq1+ZmVW8Dpmz/JOIdt+oENZv4kUhav3Nz/Ahac1pza8B8SGM4o0ZMnaRi5zRzSeX72pYYPRgBpHrTAA8lI15XDBC
832/BW+yHvtn4C7aLdZdEnGiyXW0EqV4Jdxj8fPmVxlX6Dkoav5CL1vfC5kas8qpGzX+O6/snmeLU86YKYS855keVcJimaAI+NOp
VShL7YKVD5E7bfQk8S2BUkCWQCMHkyeazhxbmYuBQMikbU3Ajx1C2HtDt3Y+TLp5U1bMsjwfekbTej2k09ytk5o677XFgO4SHUWI
CWo9kfrOHqzNnJv3PDnt0JgnO0lyY1r1EN3PGisVW0JlQVaBJqzWxejT1LwnoNFJDEBI4Lspv8aZY73iiWV1mUtnmw0B2ydNvizx
W099SSQNLCoi/iuho8cT0URUCD+lGSWEYPuPY1K1v8kRfbTSixFiCaqFFu8eQ8sPmYdA86+X3nhGGvENhDI1f/SaiTr7xNHBAVpZ
wwOA03WTcRbjH/C31k/gu4SeWnUY7uOjRAWVn6ZXi7gxId+EkgoCSX+8mJS5AOxcOTnPLD4w1wnMTClKOLw0NEWeECheTbCuowqd
9S6S0OMjOxcgktRMK/G2wAQIhFS5OgKG74hzF5BLQXoWqUVtvIJR9Yf3yAx7oeUrzqYfqYKJBiY/9xKkYqz8YRbJzDdngoo4OdDK
onWl30XI13F4fbTGq8mf39GlEA3rP3ZgOJYjVZWu05rehPK12QNdpd7/E5AMYiRwpYsg/gWk7ZivYDmpVBTdf4iNl3ra2SvqCQkg
Ke2INev2hNYWj+NfMtOUuKS1KBB8BbT+kGHoyiCmUOx3SKCFbe3UUMUkjjn7i10rIi3WGOb/fH0h826mErJe/i4kbizYDshMql8P
0wg778mSaBI+jNL77tAmdTX05r2cFSPZ4Cu4zzwMeaZ6EUbAXPSTFEaPEiNlD9PVGThZUwISL00p5NSFeVRQ6yi7mLjanfIbUzwZ
rLEEFT6W8DQrbi7iffA0SkfOz7BxvnGuzQXQ/aG907vbBFqdXoQ/tnW8aS4Thhet0Jv5RMflWy/xsfNpIlbzr+LHXT8t4p5UQAcs
lEWbcYnOnLIuK0zkYUcXM5BM92PsT7USoCgPw6euK+OvgBSKirS6nN1ym6/sGkOa7J+vQM+ItV8Sy34xNmbdlFfCor+CbnuDWNV/
/gVB04PUzLcC6rGnw2uX05Bf9IqSXlZ16vqVrD91/7ueDdQ84raM/VMaVMy7tfS7RX8Noa9RIbZYQEDocSrpI6hSxEtqvz+cac33
pEieKUfXROO4f4KAJe+CQxTc7GYcJmkP/TAUbAfqVA0gPYYEMPZ8V7tKbdhiE8YRTDgpa4tdW2V2oaG3M6OlTpM42jxZGKnWSUTm
5kHcm70CQt6kMn1YXbQEfQbPzOlWc0vsH4XabzhU0usLRMJoiZxoR5aaPgcCgsCokQsYOJrIsWnizNYVuDqM8gBSAv6tWVk4jrS8
4Uy/1Kf5v3KcVhX6vMuJGLMRgpI1HV3NgA36fv7/VOfkOy/M5bxqhOkqqwdFBoIb1zy0FAj+o2Hg9SZD1lzE3IHIucGt19I3MNrD
nu9aAV3Ge7qZ1VWe0QYmg1DeVHzYmNqNZCRy6eoG8ZxSgPh/MWsnPprETcQFYx91ysjDdpt3rjwDCcONpTnqV074eFMM76ceEzuL
ouR/u72PLgZl9YwFk2XDj18D7G778tf0FDNtLV4DOOXFDns5Zcbu33Qs7J7AZQIlDn+UMyoOhe7Mx+/8YJc+DoeI3uRmvJFO33za
UoGVM5cttygDlb5lbQYQXPujuvm4B1fbpVa8CqlVyVV/6xfmvCF9NxuFATb0HnbmjX31R3jfWNx9P7+19J8KDVx+Ed7LaRbfdIZZ
essHO9wFosta+rlMELBnJutbMaoP2kqVtWqb+i74Nl9w3VStFWqY6d0krH/EoLdoTRe4aRXTNfRBqao2bN7uMcVFEiQYmAqtAVy/
ipA4jnMCLglrLWsyPAslBHSfG0Vn47LItrT+x94oiaeaTKsbSnc7vySYMpgjWMS+uIBs2L5v/yDIwLgaSKlV1if4kr7omRfwG9qS
ESchAmU90XwgmyaNp48WK+SkTadpUuSJ8FHdSBQXH+DG/WLX9UVzBKOmfB7d2tIJZ9Y3UBBFY5OhWs8hj9i2lBRNaw2p8PvPYC6a
5frUvNl8PvX+mMe/JpkowbFEnrYgmUm9NUFSlqwt7jasyO3XvlyIx89VU+pWZ5yrbtSIqw3Xyh4tzPHR5Wy8H7w9vFWzQzZyZTg9
yZsFxaE6SYyAFCFyQIRWSgVCNYFzcODfLzreLfSoRURaUhbiSsaZ1/VRSljx0/TyYis/1qxe5Md/v8NOIqWwU+7ejPtt2U54LDK+
UOnRxPu9CrJ9iRUQp3J6AgaM6SZvrIt0Jif2F8BK2oBAEM13syaTgRwjCdTjioSA7flkD2GUOKzRMj0DpgePvpLF9ggLtsUeEwSv
Uf8gAMv9UmyA8NNxQ6coP7dHAjetlqtuNG9YJM9UhhSQxXQe16wCeTqz9qbBp6pNivplOXpcH+h5b8FUPeCUdbndvZ9Z5P9LKVQn
dgz/O8abSMleYJxod4CYvRoa5YMlBgBGG79Ikd5LJFpfphAw56VnfkyU5ESm/H6243MmZxZYlK/0ldvA1WXhmsEuQ3GVdIla+5Pw
gn4yjBXTS46hKZG7UxqKl8/SVM8YnDVju7Mhcn+V6zVl8AfJ4zKA1QbFrf7KKhFVKXJHwKpCiaQX0utYy/FIcaZPppIcYk+tLNo8
QINvUvTAZBR1LiuInHxGFfMoVi7eI9TBKD+kGMMcy5JimtUHZ9DkoDinx+vWwTL5AQug0h4BkxJFt08K+iwTtBVEQvXiIdvRUov2
hKMTqV0vHJgTYopBJPaTgbg8ZSqMpluVwiHspHJxGjosDk+1XaEzNRwGrCek/D6BGCR9+Hhjcvmd2jx4BoQ4Z5QarKkU6B7WIS1u
igYiBINRbyyO1Xi5GH/Q/awYsIrCBE7oSstOIij5pFip1baQ0UMyEtgK7qjX2eksjie0p9qhYdnkEzTPwW6Gsqcue8FcRMDwA6DO
28iLlIYfdVS3HEmUwtbLmQbFJke+dxG2MfV6CfClSjEUZ9V+tWDenB/Ic76pmookdbDMUmfslhhvKoNf0jlTs6C6KMX4rLyW/d/L
n8XZjKuclYIXDCSgeUVdlQY5Sbi8VuEZyIykqfQqgdvFTNpCK+XH9q1SVtulr9W3akZSXaiewfvi190PN+LkZe+WQy/5wegi6N9H
Si8yxtmQMgL9NtjY59ZF3Z91o76dssec+MTvSXGRENxfCa+76CmcuStEE+qj/BrJevT+wiQje4kJpvV7EPPytS3CoNvNe9nQrK3v
0Wp/TdKEts8fs+8Eb4r+sQ/ysGoAknq2yCpLZRunK57kzPV5DtVJtuhFFzuTnsLXLz8uzBRdH+z/zRsMch829iGWj7U4c3DDQSIY
xOdf4B1H1BnHpw8LuOpZhPkpQEvP4dxKH2Lj0LoF+9nZC1ruyIvZFEUL/0gBYufroaGLGKZe3Jk7hEjGbN05CF0lgEhaxmqf8Y6c
t5oqsBRFMuzGmA0vLXv6A1iR+zsuElpJ6b/zXoqZk7lmc9GKdUxjmPf5PKUkeC3jEmXVXN+c6/sW/uWLH4IEXBAc8Rl67g5TsoKK
TWh1sC36yEzsqeoE8JtfPyoZRXoc2gpDj4FeY2dLoGYa1NXKGYZ9+eTIMF09rhSC7JOS7fhAjd6gtNa2JEg1BOyn74ME45U0fVJ9
dascoOoSwWdgvjX0IL7oqYSFyPUvDJryY1SzXsm8GPl4jZ2+ngTueDBPnrEjeJykriAtD836hZHavq8cg+6JKLiG+QJs4FI9a3OD
OS+luc0MsBIvKGCQkVVjLFurJ15xwlG7Wynps1ku4EnshfbWBUdIsXfujXC8jd4xWCJe6DZrQv/q9K/wRnAjVSldc8BoE5DMWVc4
Sd4cEWBhFtRv3MjtoSQBHQhlPPF4gEda6DrAE8hRnUVcWtJxuNbb1Tvx751lguzps3L7vK6gZoF2N9bvPztceII+UUWWXWDAniL4
PvUjtN/DOJDPB8UHTq7bLDn3nvliwhN6NgDUwjT5k5f6K3x0PwFSMkxvkDamBJl0YqYuMqS+CNTwrRHZFkP8nmeNCl9hlmf6vu7Q
2RE6wpn43v9BBEsLUv8gNf3+YNN5rnA/dhB9toA6S5BoMxR/7Oe+OfwrxShD4cgMBYGOEPbeA3E7zdudKeTaKCtuSUOUwOf0XPjN
9vT/Qh0WM99gHfksuU2BL/6giQmSKbHQTm7Z5iefpm22IRlW/n50Db5/z2Kt+KVmnUqDenAcw5cmlRs=