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+9q6mm65MTKjKYCg9CB10yR6uDJG1Poy2JuvzvUafm9aOpaqQyY6OWQPA72V3Yl0bVgxuJR5QK7ho2aRxrVrDtRCJ3
Zdl93PsXcCpevynqSylL/ji6XMYmfzx44KRDITfvVhwO+ivVSPcmyc3XzVJh2TdHXvsNc1DcmxvxTYsDzND5vLW68irU/esJKHnX
JUG2YfzVjwKPOZCevaaUM8QCzCWOmTL4A+ZcKJw1TQEPJn63yl4owbaROUCWDH0UfIdn+gHC3lYw+2xQIWdJoYxLeVAuvC9tcBbX
ibVdweVUVDllpYQphU+SN5p1ByzTpiUzA6aCJsGY1NJIf6cxpBpLME8QNrXBzX0n/2ZYRIPVn7EMXTIXAXfI2xH9H06k8RHdsggZ
Kpe/q3RuaRXEnYFpV5/sVR2iE7lNfirqPX9YI7q4I70GDNfmIk/5oskiXJxQPmSro4xND3UqSED0bZFoTM+diVi9dGyx0dHOH2ox
BVPCKfi1c4K9GELY9qR0DD8EutUR2akVL7RrAHAAPM2NQ0xXi2zVj+jUR04Rv7Pqwq5OQEOlLcEMOaRi3j90R0GpLyFxTO0NgpO1
HRkVJDyydizBTxfHzQandAfOEPYBkdmfv5An8pbs0qsf6pzbyzB2YjnXwDuYw/0zEb8kFdZj72jTK9iXnLoj8582diYZ5xMKOZUR
FJE2qm6ZeYioDhcFBqSw5Wde8n49rJ+OxS5Ocm3+HdsDICno6wHo8KaUC7iKkRt7ZJoY1gs7rJrplgydYR3paB+77Oy7146E5TQU
pBfdUi4Xg5KJojndg3YNT6YGLTaRlVRhHYaRqSj124KPd7B8Bo6XelLDhwZP+2qLDwgQQYdXtBegbaeQ1DBq+ca/t821NVpQoXAJ
/efUFtAD2Le9W4f29/0UNCK26TX2IYKhmwDb6iVloGny9cbStF5vZ4XjHxy3RHoukiwDdpnP8NNIxdVx5MmEDfYRG8cRWJYIsvT+
KABuTNuZKRfa39+91tM8bi4Zd66hkFpxXoxYdfo+QEB12NAHRqMwUuHZV6C0/f8TPSkUv1pNDL0/3/3+M85gqfCnsPD7WeO2k63I
aFIiUKWBKKikBHiGdcxrP0rhO99Nw0jsPveciN1o17e7EHQpjGelFO8Xi1nmMP0pDNQ3GKPqAT1hUqVCWPx9BvfPFu/TOuw7g9lL
3wsITISsS/OBNmfoKEj0W+yMQPjWXh98i+J2YDq1Ad5s4YeZKFskygj/6jivWuRuOjKF5V60b06Go+oH3Y1eKDfAET5EzTVfGmuN
avloFEKqqK7m/XTIpRohAlSmujJBmFU526lsvUGxV1g0wJADP8vtTbAOlatx2I7m9AEFVBnmwE2DFoT6qO84kJmNwNa8695MyTmz
O/TYe7HU+yJ1++jUhk06E9Ry67DLTd2YvL7Pz+Xj6tsppJbHPdy4EVf1dSz4DtREckbFnC/2pcaLDkI8k67psLR3UZlpk+kHDgs7
35xjuNxyqwUVfWayClyOozYktyk4QbTx46uUtvoy8FL8TQ2Mk27GlPEFn7G2iD2ydAK5m+1sG3koCOnlWTLqgdNM2bSUzncNbjp7
s/hp0GtL+04qi9yAbxor5v0jpLYOxGfN3PubE86D9hyChPDRMRrEwSfTmkaUHqrYKiA7H7uJVF3+jXkAPGB2BNK7H45fwNoleFKZ
s51bnp973iK108TzkZpD7rz2XbbouwxssUdoNGTWeZLQYY5njvjjkBv1WoUhLy+nfqBfFpuFHqEs+WNKck4IGYBfRqJJc7BerVRE
AwV64MpG44JdfWLr5DnJ2fvlbIrYdZxhroErGN0Y8zobdEP48DyqSSgZxK326MS9+0oRLtP2mR4v+A0t3H0GxC9JJSB6HsmYrEno
D5LNUrj2QaYWc5MnEtopgpYzadQ+ec8GYcIpQmtx7PnsFouxUYFAQh2kQyQHsP/VeBOlCAHd6FEZVr/saT5qtjOtMiERbEtDfjyM
OZRD5l33oEvFus+/pOmx/HB2spjyKDpsln/DMcnNm1jvcER/hrmOgrTVEJ5+/7YzbAvaySiA5rIoZBi0d3fkuwiQf3NMUUAVlaNo
y60fpnRcoSK22ngbsW2txjpUynE+I7lKoMTXmwaID0Hgu/H/xyqoa6CkMsWhyqXXp5kWIEw9gicCgLRHWKk2qpbEDZINvaERSvq1
qYwfYmpPqvPCeqq0dBMTIMtGuJiyer974NG/u6MWxVm+bWUs0BH3vLch8Ne0h3sSFP9JforP0itDDQj2ZCnSxEQUGUmd/Wu6/hig
QvH7QYVWjF105/pbcD6yfBYLskC1q4g3kFs4BrSI5E4862u6/G/sMkk1aIbmDMMNMD0EISO21NQziP1B0UIinw9pC98wyuP5aiZd
bY6IOtIK0YaL1jk592L/zMjTSPPks0gWq9HxyxBsjfhYmwNlVFZ7nL9LpO4dgoQSLy7BWjQPgKlUz41Ztbx9agU6aYLdFd0dNy1+
7TynMEQyJYh2wKfPXoHUK0jxQz8t8awq/GKCrCeG5+0Pq66sMPyNQCznNH3RzRMv5IAF7o3NCqK42ZMs28o5A3dmJBJPnlbgSlIM
ShCYGrA9BAK+NYi9FfAiRKqewz2x5uzVowgOPxEvjTkI+dYUshLQhC91nn6hMdYdqvRKQBTsrkTDBd9McDyO2xYeDXp3kWl09yDT
l1GxlhIL92/xk7+u5uKwp+bCK9KbbFsuY/RSbIiE/YtP59zgsZGa8kppffow/0vZwDqtYcQtORVzWW53YE4WNsRkbcJduVai+FoA
YY7mtT8WsneaAFQomArhSMLU0tbXqGQ5kOn+q8+67crzK4UrrzA25U7Jq4cIxl7UTMSY2vk01kypk/Ux2wFDExjWPZs4a/ROJAwo
7rSTd/Rijta7EeW132xH0Y9/TwmVSneGT9fz7ByF2W8HaXhSUX33STrLiUp4HuXo7f1XUB2dLJ8sQUkgb13IDZkUTOW7zKpAne1O
MUMz0oop83z54Ve4Foxn0sA3ZD/zm/iG0lUm2J8Vxv/jfHdSsfskVNQtjzbqJDaoej0inW9+UuFSD3fvsF5oiwQEgaf1QQwOILRI
aHOc6+XI+LL+njl3YTqNtyD5BXpOCyyeat6+RtnIaNhX80tX9J0FC8pSy7wrWPuhP4pGlN4YyyBzKsWO0O+INivWUzYzqRCWU9BE
rhr802SHAxZtgMuJipTY/yYd+NgWMt/9XDsnoj7Q5J68uYrZBHinmV20orYpTpetUfCNd09TPY7wK5l85qZeOXgLxApSlO2jezC9
U4iumAXqBDqxtVvg7TfAvg2JWqATgPr8IP23ZM2UILoTDwpnx2vgkRaGlkb75M00OnA8hLx28XWAKE9fwdmu5G7lRQ96J9tqmKTs
nKGIwrdkT5fLPN2qYxBWMJTfo0YPSt+bHiR25JZavgu5kIfni1rLAqrhK14lvz7qkKAyDmRpHh0e/snubOToKCMXfvi/kcUZwM/w
dkdgwid+UAqqlIJzBqc4O4CPlTHRd5Xqo87N9HbV6OXoL3z/ePyM3KucXGsn+yqJKL8afpjSFbpaPzf23cfelNLVHiac1cb/wmyE
LErN4PfUvw2XPcu04fPI/23BjXofAYeqMIm0gTlpabn6wh4bbQbP7pSX0VEnsjk1mYQzfEl+K4HXjpL05q/dcYnGqsNoCbuAmoEc
hiMh1tk4ydSmqP+7bzfEfV/tBdgi1UMvLXU4faTUi33wZyROiLaPprm4H8WI7umcT9dPq6aZ7rFPY93hWEdkRhBDYAgLjpCYbwjT
qw58qaYfrgRtvcrwsbHTNWly/tZJAkYvtD+QEIkVlYjc2duzuGljDVVOC8f28il3xgyF+G7pqCSLKmjmeo4cqeyYnmmK1d4Yvys/
xbYtJhbSUMyeFYSC9+zJHE8YfoDY86buGLlS9qX5bKQo8wgSs9+AL6NRanwdTDGPKqjHaS2G4r9tI32RLpI0MT/aw9w4LqmTVuwa
W54G5CSRHlTgOb4A9FYiREC6tYmd9lBhV9tL7Yo6iiwULk69APko2N9iW+LeI8sOKkK3+JJ46nm53WPb9ct8vSe7wiv6sFlw1AX3
PsUUQ1Jr38zcP8jO9b0H8IqUTxifkPBZEy+ZCLPAWe8n7XpvAeqcuiDlrINnaJdpZLrSOPIUuXloeqimjBWYwwJ2f+93jEiOH4aa
YSrOgSZZh25YhE9yyIm4J01oskqHMvpPqCJ+jcpMQNuOPeLILpwZN426ZZgJydjJ6nA5GNfVAdNovgPRZRb9BtkiH1LpZdIE2nMB
xxlk/WcI8sF/QUzcj9HcrKUJ1jf7CbJAv9j/Ut7ySVCP7rQfibfFJ5OXXaVQa1tHCk8ekGmGeeQFRp5P3EwBfRB9I0yCX1l8YY/9
5JLDk8K5N87H5Uzr+QcIKpjgtqdIuHbYnbLcudPCwaraDvUJrhlq6xNK43VS5smNYLCqf5JJtJfVF/hWWjP1t8sylwag7Czw7qse
4wquKSGff19S0blk/VNkjCLVMUcAnlyB9PbigpAUQ/6DI1IQuvJt+WZ56z5R3ZzHf0SeXm7/HYdk+bWn/DDo8/75z4T2LeaPaizv
16JKKTj55X8IQkrzHzYX8J4gL90x+vaWO1qTxThcPXWweeaxs1MwEkZLoPqH1TTzM8JVj3kDEDZk3SeKPMRYByL44Xsp1qkWJ55W
t1dVn14abZogOJi1ApZQ3YnsWW7qK0wlWUGoBv4Qee9K+kTjoKNwlgD/Gp23u1atNYDoEOSAjpAXvwGu68hO8FCZYEd55EJEfiIa
aUNb6SK/WC3VVW1JANhN/YExjAIWcy30SNaK18WIQXw=