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+SiyuLMcYu/huN88FiWIidLRf0MU6fdCImnVgrVCT1bL6tYhiFjGXrm51VPvXFFHACAxmrLGJFmvsc+nk0vHd5mogK
J1sz6TKQdHrMes3zke9t66Y5xkekbHWEPGd4dIHgkjp3YLSmhr3D1Zp21sSCenXXegiKXvDdzlp1UrY9Z2v02E07s49GhrXXs7Mn
g6cMnAoZs2pIVAQHxbAhcSB/R+Q76nycDiP39IBVlHCY3JTfS3TEPIBcnmenlr8x0jHCI+NKFqz0Y9mJ7IJWfmmKEXljxobedUWF
a4tRVTCfFa+Qmy99v3mNlmd6TCTLrSBeNwNAjEoKmAH7y/b0dQpQlApzr8tRllulFgUAttnR1kIqyivE9RqNdXvvIZcGy5WnfFhR
09hu+EEQQ6xeSQhY6f4ItB81C2f4wGojOmKmorPCItV+CymN+XBWnQXb3hZJNd5wMIBUcklKawR2xUkZ4llDpzOR3u3yByQAg6w3
GcEMkf8oZ9TMh3dcsv0NjBJqjafDj4z+ktx8Ie63B7aWe9i5PGcZhCkIGo45M0ORwXRvQ7VNZNVbP+HF3G1mjIi2fhe7CsztVfxG
rdhrmNzAy4iBJEsbYBCkAmHX12R9Qug82iVipu9LRwk4wlbB/PobFwLwhbEikQNtCxondnjg7G7ULCbW0fZaQuSAH0jZfUAgJ6Rn
KGzkkJyp1f++tyeAJZdMGH2J/ufJJs+BvpomHDVJlCOSxwRg6aGW9QzXEikXWRU/xj/JMUl8zczXEVXrv5NhUN4KKQ+f5LUQSWJl
ZhPMF3REeMX2XXgpUxr8bc4TGaDLNF4mM9JqJ/dga2ocZr9vdjnGlzpGlwulEtY+WtLwhg4cUqpKCxuHokTuDjdfQZNb6DRIi2MQ
83weot8xFtI6enVO7rjDyfWC7iMGAPUEkzSoIxD4pqD0TCZkci9jQ/ZFIs1X+nlIVn8K+3s3/0fkbnTTtIq8heASgPZRg8ZNEam0
zd55uiPBXqkXXNscuJMrEBcGHR8jRhtESgDQFLX//R7TRM6c6nHHkfBcTucLaGMe4TGXnwxEHu1wf3oWZH9iTzO1iq/lJ27+ubOK
zqqBwnbKCltHA9VWgwGXWHrcp03yOHii9NHyQYj0ZgwkGIB4CqH/MntnbM4ck/0iy+ZnJlqdnvnKd8aE1wlew8USeRxaYDJjxmvb
dad++oPfOTcqGCXdTR1eaI/lWw0+HHw0FZOLgxEf1s3HPUtst7msgMSLggHYH5r7vwZdpikTWpNI0Vnp6yRk80YFZEBkfJVYPA5A
7okxVX4j3JjesprYLh/YNkili+48ISl5nrSq8gJO702DfwNK4a9Mk0nHMrOddT8E0luW83uPPRMFCJGjTmY4hWOXB6k8rFC/Pecv
MhRr4JDmr26Ou9o0i4pOy2XW0JU2tE1+GeHLVl0SsscV3XOAT7a0LC7iMfQk3yw0CMpzisYxUhyqXxGAw/cZGX+mrWMVVivC+1gX
ElyqxCBN79QSarNV61rjH94DPcQeorJQLv5Beebj8aAJ5zx9arJ88JTc/rSG1k7GWJH5mbemGJSJ1pANpqgLxNu50ZJo6FCD3zbk
pv1JPdPTVSYt3JeK+X0zYF+DOQUDGzPJVlvSoRh0EydT38hFah0aDr6VGZXUEMxMoN23I49TbAgNLfsg9kgXDBp8znmYOJD1PqAy
iayGOGJi238Z0mQoADyZ0+KPNAGgjQfXm6A15rwlrrkRelP9HcJF1qNmSL75Svp5Z83zUVs4B6ZmutEm/GAKgXq9HcBtJlFB5DPy
6/E4izGto6CP/z78pOByPMJaquxzYwuc/2UwjBzGyr2ny1vQDdaI5Oo6/hMjemhbN/HLdlNnQvjY2fAB2KlZyBEJ7fe+YPMeqJI1
4F1p1Z6drKZZ+VX4WxEBT7YtW2gn636GUsqylYBvmPK0jwOBs+8oPLY1SIAQH+EXsN5ay2ibl5GuJ3+/8K4AH7/+9PRe/YMu5B3T
gYhCtQIi+tuvtlPN+8iwgmGzgwf1R3eAxZfgelFp4Z4+3v4stDJQIfyOpxH2XRQczv8j4Q1PVHfDdWaHlHE+PMChZvK9LFpU7417
1KOSn9pab1VM5seZ7xXBUOXTBisF8lSfrgCO300pDRHnwHpNS4PFVhQqywjLZjVseimQMknv/JhS1qHoqMWIs2098l5bY8Xx3r7t
nni7CkfTze3ytpMUVsDN5M8T1+hmWmmCpv066NULGWbogKHJPUd0RGp24DYyY/mWj1xLsSlEP29ZIioDv0lGatEN6duw5acDANvD
U+r2YtBQxyFaKpqp4H4tuzrGkBrsoXfApQSaZkx7yvMKBFEQkevVy+j0akJyePAV+8O16TRtx9YdM4jmmlxIFaSqJx8XUjVKqIVg
k0Pw+XXBqfD8XZYZYqUbO7WWL6u+vkrtgBvmOi44jXHDc9T/9bxYtKpdiFOv/EiGFjry9wxHPwtSCkZ6cGPkZX9TwFY3FVr8q5C1
vIcd8WFNpGQx9K1VpufulhvzoMm9i5c+kGyyhIcyk8hU3gv4hkPDwro8eMqFEB7thR3ls5TQPo1/FifAGjrt60t7Hhp4N62qQM6+
bVeQm58PwuB9gAPt9bM51gQbqr6AzVdERqd65WdBfDwr286BcrACC0zK8/oAQZP21jYX+ERJxfWxNnPVe6s1k/lgLYNvnMWmYkMc
cp/9EnxhEU2+mk0czVgFxeuwtxJSPrmATShpYfTHl5vGxmLcs0vAVvRTfRq8/1nSjB8972O6QL6NqBTY0RhOAxk7dxlfbfOTxRj6
JC5JC117s5IJq/NzAHfWFM/5/evhEBpOtlLbq2bYFX7d4A7c0m7Wfln0nXCGGGjmvSscqr9Ib3gTaP4dIII4g4LYyLSVhnE11uQL
6Y7lRkAQerDJyCq3QGKPcywCsIUwjPSdqzpRqe8gpgJRfKBHHiLe/e0uE/w91GtLH8DdckLKp/FhNWNfXuqpWi+jJ+EfAlnTNGMT
y0bXFkI5V6Lwy4dS8cqJask/YPKA6MaeSXS+4P154uzPPRLhV94VxJ8VvMbVJgv4MTXKsOiRN7ufU0WvkTIIsbF0Mc0GyRtTiFSp
UZOYigOfFHrB698PQ0pDHcq0ja13wQaHHy5/JCYWoxMNhLujn/FhsKV08DFWUHjsUD0L5LUp5HPlhy+VWuWmVB47PDjfglCYKSzq
yfTQupDMQvgWP6BQbYc6Rpq6toFmUuyGYL2OP7FiFftTIKxAkPDrF/3OmK02P/WsCJHWeYQF6lnQdgDbGhob2eHKjjE4AdzAF/MQ
Bkyu+IGWD723hd+635xbzRAgwCFwaRf9NRglayxbSuHGDEJJGHsEuy0lu6jGKMWcMJHv7/o3qSeUgUo+Sn7ZJ3SdiUrrrfe3zoS0
OJYniF+VfTljVF2mKAVOdST65g0pBfxqoLl0LQVSKuO+2iQQVI4W/kHylMeICuEBa/GvHl+9KXco7js31UQsBsS5wzCxSeopZl/K
0GkYYVtKyQaIYzJC4CzlMoID83ui5Errk3YLgO+dff/jHsJajeF3LH4bXL3LDUrtedWUwZQJNkZcgNv13Yl9fD2CgsJvH7tgfEGs
NM1Vooz5bqjFlWcFfz2521ZzSbevZ2UI8XpJMVMEHhwjxyypTJz5WOm7OVBkRnCDVtFS5jD7v+FC9jzuYOayNDanKUJbjfSbMNJi
kBMAPClZapIRgwrRR9UId+WUcqU8VS3ngvnxEXcf28HiBFEMRyQo24ylHh0pAvPUyuIK3By9wz9OrVADFu3t0uWJomCmkW+s/GUw
v8DxQ1GVF8RB58bsyytnz/DBgyPXujZbvKUZVWi+DsS1N48fYP3W0Dj3q/167/77y2VclbHf0X6GIQd+b5scJKZcp+rtQ0v2w2Ju
sIgbAOxBfrmX4AsBiZ0Q4cUoab9hBCJHGTVzB4O9VjQIWxpmnwk1WzESvUa6A4Ny6CNrDq9LydTowPlvhpdkesBGAMVKXhKCKLlK
QyL0WCZ0S1T/VpE3ZLLXWkBN7FTFg5n/YE3pEIxRJK60gxDtvPmWFhYa/sFI+OAu0WctbVpchYUdwflPVNRAysojkLjMEDMbqY1e
KkefY9bRatpYmwLjcYVLtxNSkM2o3Plt8dpKosstAtwgIx1ieN5vOU6KMl84njigDQzPpm04tIBsLso4T1V6JKF5suDC4Uh14TPy
jVPXe9E6y00bnlcKDnbVdpPTkCmIIK/4o1Jz4GloxG9aOSxEIkc/nyz72YBdy3poDu3Vo2Sqoj4Df9ccDD6V04O2Jbexaek4kYex
VXWrEFOosoB1b6JaUJ5IJbEPfoHuXriPIpS4jOx/fNoNkRyRNO/rOUSJmWI5jdruuHc28edCS8G9CWY/HnzlmZRr5jpY17NXeryx
95PQDMISlApTY4VRCdWq+2EXlX/CnZ494W0teCRT9droPpRmBthS3HNdcHfZZV4Hus6nVURzcSNpFtFPUn6WrXBaUj5nv1IQJMq1
eqXcAFzr+uW63juowjxGr8ZObVeytkrVCVJ723jP45rwgGoWk/ze0/SMLnBUnC9YBL7Yifaz92l8Yyd3x71F4bQsDR134+uKklSG
m4dTJoImJu7sHZcdZDrtn1sUK15FHEhiJKtFNOxhL1fqU1eKrsNJYZ5LgnF2Io6Rv4RcZ9JFaKSErYxsjZHLaQwTQpIxVNxGvp7W
DfvX6PUo5uIB99Ng/rJkdyZnqb4u0D6R5fMDzzs6theQFcEK/lHxb56NlUFTjLgyTNHDLaQuqzM+WEo=