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/F736y6lCKHCghZBQU8e3et900g6cYwB/Tt61nivvujpwFhYh3ye4gYRqrVNpRm8d6uUaDFsEn5WYZWmIFUpGau1tW
ZXmLfuuES8Mh6TguSBL2H177ZTODqwY/4KMO3W9wCGWpwnXFLuFE3ZbvufCdH/pYUWJtfy/9b4XwKwWOl/xgLdZvAhpgX1Q5PkD6
RBqT21nNl9AIbfYegWxCPEE5OzgetvJX++vv8Dt7undYBUPO78ddXKW5j9U2nLcZ7IMSUQfqM6Vs92QKlfuQmzdAhbcMtdKHSZOZ
4wsu3qV9vPiGOYTjEgk3uA8aTqx8eIpesKZLR2Rz1NJDqttlUxgOuFMwYOpkCcWw7SRENGTNmo6W3kRdtlWlS/m2lt5YkfZlNBY0
0qxMXwIMMtFZJSgBxgLQ2odtnBUgbRaNBQ+zu8+vHWvo6eNhSC5qzXb046ylPZ3wA3p2zQ32Wt9Vw1jGMPO2lyUJGG1+Ak05jM21
g86v/zROqfONW+A5NpsCnx3OeUjTCQh65hNvJEJsQ/9OrYyV/AmxF20Gzk1V0jg7KLHZdPFTEPVbirCd+ikaMay+o5KbubdzXRgZ
clU0un/5rZ2Q/69CWrGHsyjnTMwZDtpDsCJZh5QtJj+QHK0FfkG/SgbML3oATvDjdoYeSl+ckfhU7/0RFu7ODprEf0dFJ4ut+8KE
X5Idw7eaYDmzM9gfj90pN0WEjn4Spv9FdIR8VRGiMBVYqb/CE470b032NOVeDe3HApTYRRAYBBZFLledsAUn1fMeHmbgAfBWXXIb
MmHwoDnFZexF91t4lcojTnmFEI9toPVksI5iItFKl0F2qyucqo6f48VfKV3n7yQJziJyVlfcqXCZwtRL2hL9zWVqXfn+zQW5AOXQ
1crIY7u2Ty1V5/088Mxbg4Eulr07+d3Qt3fmJ5TjXYS6B1/0dDSQA/QbAduR0mt4gYlsyt1qgk7LgIBBe67+B1C8AwX1Fng9OuDT
SZddyBbg6GXGBgETQQv4QYRyrGAhhPSQX0am+85BpKcpfpiQbC7LiSIexkdhj72Cok/ZavOO/chHllYsDkeXCsdF9VUZizAXrfMo
FLob98DrLceEq5ni2LhAly6LrNUwwNcYkQomT5eJMtQgy3LX9d0vzLtjW6+dUuH/N4GfEhQtknchNTxd1Z+/6GFSVQ4rkRtTBVUk
n8s50wjEb4MVNLcRTewwKbj+4adpYR1Xx9PL3PieJVOrDoGY3ARh7atHd9LHPVJUfhskSTWBrx7n+IhYMluF+lMShPoHGnGG/msm
KWGVxr9XPZpz9Jp+8NqJM80l/xBpoP/5IYoCVQCEpxHoz9xcKpd5JZIocUC/dP1g6k6/Q5B+LrxgPmMwnM2xyoln+Y+zLYiQNlXg
6BgZdN5rZWz0qdZXZPieWrht6T4iFIcQmgr/9qYxsnYPMK9GjsGQTpGfDXo2iKLQmFA0/uqSwpXk4ZE+vZHZUBZylKJ6NEalyElY
0occH5lQ1DbhFGDwpHwPqrO2bmK5PrHVUuVFOS6SxtWjR0+qygoXuq2dz7AGDaLmKMiX6vl2B/u8CYpCx1yRv8jG45kEG2mkpc/8
eaVb4BEzDgbj5AjXSD9w5s983/FFtNOWXbCowmRgybbODBUio5ygPcSMIRaIaNe5lwUYHPikd7ylSc8lfc1u0ee7k5R8Js20Iiuc
V9CEwozH12LSTXs0D039TKHQHD1ZoHncodv+bb0YwT0ostffNopkIMFsD8+VQzc2DGtG8xOGlwUNROHHDJfbIRcVdaPYg9KKwJi5
VZvRXjYQv5K0+g7gz8n8x/nD2JhCrrA6xKyaPBsZPIby3lvAse/CdeHu8h+wa+GEcyG62E61xG+3kQ7RqSfsQui/iaSXf/pgxLLv
S5PbB3Kco1rKZ/Bhx3dy62S0ewzB9MEHboVfJQnb+2MulWeCE0IO3m7+JvYHqVkC5CXVVrCGCitmxOO84Sf7RsNCnSCWFTTRE77L
KmE0ym+RCBgrzALJpivzRAB4n5149OG1YBlfXi0vc0CbGpgVLHokiwkXZ6H4B2fpPyEREQHenGCb+2Ap6x3j9BUBi3930NtwffQa
L8Gb7+m386WevFUUgsrueG8YCJ13COXifmZ956ZBXhO5hyHmHvtu27565e/MB804C8I29maUMod6ZH5FNEFZzOJvvaKjI+D6wiaP
jeg/d79h5Ghp+HsS1Vrrk/2vrsiV994RIWx7WKsoZFU3vaBs86A2mgxIMTS267IaA5jF9hRfTMSkVgBtE85iinIhHbUK7k91jrPg
vqCVNYP3JzrWZRyg8YmQXj2/wOHsqCrJD5L6dOoS66anOhDOl1ad7zIO4p4hkDMbXmlRjylvt3qOhMEHzLwz+8TiCWVIySMQ03Cp
zg9ENOqXsf20nWAfyRGlYNI0ipQgAl8b97qhpb6chI0tebUNx4M4PYVPBIols+3+hYsOu6v60lsrl42xnB3Zn/9iY8f88vt2nfGC
SV2T2TQM7sqmMQGIcplDmIPlL4VfQBSklpAtOJa/Y5pwV1zeuSNClyASdzkTPN8XuHSWXVmvNDhrD0umN8K3DxNculwsFng+EyFQ
CaPjDCqpLiCzPwMg+UgX0mfqOnmoFlS+Ei1b81Q1gXD1Jlhk3IyjWBSO2eS2rFDOfWPtiB8fBET3gbMMOzkpyZxMXFIv/twpduQ7
0QWTE53X+d+6rNGL1d1RQUJybFClWK58eEfKzebCixUfn+dWwPBjLYOq8JmR96ZEsxr7VgJ6n075ckb9KBBk7s/EC72YRrFCOjSt
yEj/KV1L7reYT0Y3515CeH7WNuG8TNgwb796pzGiVIxqWULvklfQWurGWrDf9Vapnun9BBxSt1R+J5o+MudvtFm8uidZ8J1bhNW9
KWnreUTgeSlXrOIrz5HUnGQgIgjw64h+4wMtkTkPiuFXTq3v7XCQA0cU544OYoZcpp1ndP2+oiPCLHTqk5faoQvm8VEBFF3Rq6xt
/Vfwr3z7CU2L16ABAP8BXFraqa6ZPRqoZJCrl/5ogBKl9dLXMyqvsJLU7WG12orwytWNvbuFcUEIXjVcYGr0I4uR/ROWYfX5B5x+
++t2ffg/qT1WQyhLY1PKHqitYFecXdh7sVmxPT1IxG4+06BoZljHXd+vM2eRdDjVWVhfFrgdOPW0RA2Ny8aqrS8CIyjq/onv8Inx
3Crf1ei+xWN3uGmAAwEvPpMbo00uwqEFhoUrkDDwfheb+LpZKE7kO13PsJNbUvvq5RMEH4jenzvqXkvS5uTXOkZSw86cax8I4Wm5
wJp+1DiGMKf8QrzV+eB1C31sYEvZj7fRMKTFEJynGSphiY7jZYLwTrqVbuO2piT6oi/TiVRg1anv07ouFUvSIBiiN+SfGZ9t4AhE
Sosq1d5UN/PtkMGzlIIJRvlL9SWm8MGFNWweo7FFz5fvm1P9NGwkpZ0aLdeB/q5suAsAIHUpGoCcgwNG8myWf3lKiiSN9sfuuZWd
3ypaoFKLscrgFsfuY3VtX0khG/lmb/o64k1ZvAg2DwFOUPpSVZRX5HgTEIyquy+cR5oaVCW+rZK31SuwfEYJtQLeeJ+7BqU826Wy
JnbpWdhJA6e+XxSyiw3yjV9j9EYYRTXiuQCI7uEqidRASM48kRkPyPU+kRMJZ82cG80mzssqyu0FQeHTpSGWS2WOV7hJgfbwfRbN
EzSb0JaiRbenO5uSHqajrEwGu+FTOKSNop9cHGTnhWhKjYDRyHHBvVJ2KsXQ7iCQLnXzjyORb9q1pTTuEIpjJ8C/iqwkP83TyW/c
0g6SjCc3+quKCXuJjUfG01T+V/itYYSWjtUCBs3e7cW5rmm+KA5dp0OYFyYHwELt4dR1c4O1lUHDuftAjlfjVANBLBKlBqaLEy2H
PzxOfBDFbR/BTzMhFgA9lyLviP9XGUe3BrQbFtgkIQeiHAhmgt9L2b53DVdcdJgqrXZYwPxyucnJJE+RkeyULGijLsEaRbR//AcW
5mRUqAXasKb2s5fzdrTz6+bocUqxZs6fa5YfQ3uBD9OVolk/ykgqK6OE1EZPUwFf/BQhWAZL6yWfYVwJwZvmsF1mkyizaf6vVIcD
cOv7K7BW4qsfW7/wL++2N58yJhcl2LrjY2jUCyxL9kE4qxwBaQY6NJUFudqjMHEfj2X1YMK8CiGww0DY3o75OW+S/Dl29KY4Siac
uoP1Bt2VEpo/hMWZu9I/D/wpw0QSyQeC+4OGx7FcRI5rNGnSvNytroUtEykHh76tOlgJJUauF1GZlbJ8YuoQs5JpqPSjJYT63881
qdGsMlQ4zq6NO/vZwO5qYeEdcwSQ2mGti3BXoZ2y8KQKyJMrNcrmlPsQkLFK5HbGU7/pVn25HrHe1pFTq500t0xxz4tKAq5V+gup
EsqEftLTyLn8C5anpopFEzAekIghHhkFXUELccdxtU2Zfhrix/78P2ORWJWc1spfkwywPg1F89E00RFlQHk5izms4daxtok0ylYA
Lmo775S0aEasYLLgR93rsMbiXRyOKSYnewUun5tiSED5oNtq9+UsktwNenI3YpEPL/XWWsU937z+OAW9Hro4bX6jLpNZQJ5Zs6uj
JBgD8EzhiQwLMFi4RE6qNYziLzuXn+brWzo+k5qsbjplJ8jVFVJbi5dSI1zf0DpBIft0whGUds0txlXDhxAWtJULGE6ZdA75Jf4U
PGKm0Q2iPWkVnvt5njb2FmZXvcR2WRk3zgcwi+M6H3ZyVyuhixTfIdU3IlRpt/gvJfWRFk9GtNUsHWU=