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+qxMcl6efgDy/vYgc88T2VmhYRfl9pEFtQR1q7wC27Wlre2D92WTNMd0gSXWKxBaodmFBWIqZ9QEzZaWAQXs9tMv15
nJfy1951U+qRh4E6pLgGNp9X6HCBGdEldnwKyNdnxJvN0JIouPDDXyWRhgUs8RN7wZgf9isza+xR/Ywjd2zwS+HXW8Gj1t7EzGUl
6Si3f8fIF1Vt4fmOEhQm0fnl/8ZHvfVBO/V2St4RrC3cZReccwOiG70Bs2RlqAPDxI9z5emlpKflbXdspDKk5mRL/z8IBmvgbgr7
sXa7iMSPprTcWQdU8upBTiP1pVWikAlTd4Z/6bLkxxLnEJTESY80wbO8cS34jiJnB7cO33tuklPP2dl7+pptjBpl6c6hDCt/mY28
6LJSbJR2zpGaE1TJjqKB3LYt636J4GybdD2Jyceh5lm1gaBIQJZpBZQkHbT2CZZ0R1D1RPQak8dP9CbWLjbxERr9HvUI98jP5nx+
QM0fGOBKgQDYEItQKSyv44UWgkqMggGtIQdxcrv7A4zbHRmZXKeGgqtdYVW1NGXtFoQnivxE4w+rey7eEsibsUkowGujtgYO9gHV
z+k8IfC6YNg73GGsEXePceZ/WjWDh8IIrtNbxDRQwbE7G36/KiYvt+K0WIdleavrn8V5QdfFc5yhGKvlyHqYH/gK+4HVDuxcLYXH
QFXCQRRYIRCTC+GoVC1HRIhgOO9gVGlVddQ0eij40bOn3y/VEAgdg3iRcP9+llDgNXFBR8EunZzD2hrkDfnhCYPd0KqurbYah3Gs
CK80w6WExjLBYRq/V7w6VI1TctzZIix29OYC2uTswOEhA2kZkOnoaM9PCQ5O+f8s0Wsh0Gv8gOkcAytdDE6kY3DjgAC06DqvwY+I
cl23qZ3vcZJEAotdXVXxyf444k+Ml0fXP4VGmR4Xz3iMakaT1o4bycZoU3/yNRNUYfQQwQK9GIi9enjhYQDu2ZODFb+TOYbUI65B
ihBe+rBSGc7rn9XL/ruR6F0ysMHtrcixTMoKfi9aGTBEnTA090ANj3MM606Wb6bj5VdNEW41tRwWzIVmdRDvYnvLxu2bYplWmwcG
9apeh5rxm0h/f3dQRrxuN2o1+xa11aGroepl5Uiy+FsSOPq9m1DfCtmIZkbonOwhzrvVAq2s8CQY3AK6cScIL9I4pOkl3fXjp5n0
wayj7c0Bu8ULKrZYiTbIDBh+SWDzwE9jkf24BF945JP6fAx2ftlgi4/QCvdkklT063b1YH+Qs+tL3yBOGD5nx97ZVvsjC8zO5tqE
l6DXfkA0CMC0ypjbVCnzZDMsW0/qVGUG9dhFSpg1IYs+fE4n5eN7u7VDfkn7frzjZ7dUbUSOEXt+SaYO2dBH+8DQDTdRhFKOd435
/rtp26mrZFLVFo7fsCFWZARIweKN65fsx03y0A2Ga9DDTG8Iert+yB/pVn9udemLrbiMAMMhz18PkMKgfPSEoyu/IKQt28yxkabH
fNvmohhqbTRcPWFy0y5ol7d+a3OEKPT2ArxSBiXeBaUjE5VNyn2f7YRZkNF4xN3LWRbqqK9of3tUW4E5WWUouQwMQqeS4Fcc3LsB
lFx20e6W4AgqeZXipr9sAfkVH5EWPkxFe9E5DDu/aHssHoo+Eh4QkzF7BLbXrLoCj+Cooe4xbV93z4zPrEqaNrt4AUoawadGfACA
JAsVTTzF9E/vCrdzKJAmMP/S5WhSfLagLnzqwhLNUW+1aDemrDoOOMCPgqhCF55BSPFr3mnEgTkr6sK3h/2yT910Ig5xRxxBpfJv
iR76PDX2tHD9R8GDk6ZFXqxY5Os8Go6ieHO//nEhnkeOQ3YFyePSZRHYWw7YesUkgDtlbFjD6n/7e5EgCN5mTQtMy37J+LfYt35Q
e0Gtoz/UFtNqzyZNmoUZYd19panDx7VGvKtttmZ3lctb+9yhUeM4bxjxqI/byHpmAXUrLqKIfwmnvPhCMvSTY8bH5MBKuE3ZNm5v
Xa/8OVprSFfuXY4WqtnRJl7HvrYMvlpCVoTUmsiMimrLdoq3bZ5EV6mPZTTuB8DpFeATQGMphr6dylWkwL+J6lRv8IMOdavBkgjY
V2QMUF4Bdc507S7piYgXjdhaxjdjfY2lkeENNMa8vhRXnxzUV+QgQRZvHF/KjalF1H0aBfrmIYdVFyXv656oDlDPHWcGiSPKHmo7
QDnKu9fRCKLRYBbT1CnlaY177nB75SEZur/usJ8SuhrE4QT4eKp9rX7bzynpJwZelGKlV42JzMUBnD0AgzROlEkLybnIR38lVMxN
xB3loV50gp2DPCLkL7B1cYCrtx8z0XaAeqbFYEa/jsBrfTfPNbG0BoterGC6tcfGzA/SsTNWWtQs+HyepaW3XuI/89RzWVuCELNX
x/mYZ6BAFcd8KOzliqk2LRK7IY8xGzkchEZcsAVJmlha9zJ6KWG1EDqPZZlXsSyGwBIk0IhA0bnD//UuhJ9rL0Z1fpox/pbHcqn8
ykvqZHgQ6wragZdF0XkU1IEzsQ166VPViVM2y7AHLpfOdBdkLT1jsBYSneGHGxRL/AxPfHmb6EaLQO7wA7kldfPsBLDRqqjfmWJ1
OlDfuzrR7wnFj6Mg0VnO3p5bpL1v8u2nOmBvKrVmJZNjSNFLJOXICGXM8Td6L9vy49k8oSs5L3DBwQQJ7uQi4Ih4Xn4rlN2BH+ha
iKbH5n5fIzoL/YLl4EK7Rtj2XcWIxhlsaB+XvZ5PI2Vnbl5p+fMm4jMNQmZ7aXAAMRRgoXkZu5mBxmmHmCI/O14GdUvrsuReJwHr
l2Czw/Vkbp1i1hEIyV7Tmii9h1eww1x7Z/99w7/WSRcF1pVX4pYqtMXuu4TjjpQ/8dihzoDfs9hPooC48TalGsIqT+xFj3P0Z+Jz
hyMCB++LZmx/cvUGLDIS0dEsyR5IpfqnckHna9TlsyS7rRqpBbsTgw/e/TDJ6lXiB9OnnlFHtFT554fL0HeT3AT7sbkIrbvaCYEg
JGSDvo3zsVSLj8y+FUVwbgRt/tbs8svFmyRZlhov0ULprTeNdTqnw45LzG/CCDEbtYRS3ZxtftofAehxCIV1Go1ZqUf6EXB7hJVN
/BJpXO+IEJb1bIBUSeZ4Qwta5ZDv+kRzzoYmPFThHuiaIy0+oOqVD/2G5e0dejNVTu3NFENAwkhUMKnXtKKx1F09DsM1tfwOWPYF
A+p8HufrC8gI6vFfM0K67sQyboPRu3/8xV+4RDVcn6NbKfV2npduW6cBCWch6hu6MO+J8JI+PmkzzbHylIqhevtcmhykTPAHLh81
Wk0roCkSJT5Ruk7NOiG1mxtmIeu1y7COk0hyIfTJu/Zd+yU+pSGdIMtB2R1YHtWHctFXAEpMkYMdfnQa8CjNGzEcpMwJDwjK5nT4
cHL8TfNVE0Yxai/FPfh1EzY//fVXS1YZKNa2BPeFMxR/x/V601T3r7ZqmQcname/OmRkiE7PX5tmEgezgmgwsts7JspRXxPGxdbn
7k6RG5/YwKxiRyKgfXfjDBQpYiGEgNzRobRfoKzuEhJnp/FPr1aj0Fidy8Ln9Len+DiwBeN/2AgQNGpw39Zy5fa81wfQJJk7fYxt
Ox9Q3ptVeWksTzqu/VTwEJBswk0bOp6Wz0E/ghYFM0PvWn8dfkaniRhBh8eFI24F/P38rpAF/lM/+BOVG26mjJgET/MfU/k5KdK8
X8RS7U0wYvpBgSFpWY+ncyKsqE8pl51BUtz2/7DtMbRS+vjNWqs7zm6kceqQuQUMaS+3ZPRHcokPr6iP0NBeG1dhgpJRIXEGslQP
YAzvn9xg+iqZ6kuaNFXA697cTSmhprak4X8KwMhQRX6xnY0h3YFdj8Kqmc8PwGmRBCYbuBojnWstrX+MKzhgD7W3EXueDg9s8/zs
DDXBK/0eqDceX3+fcYyuw/yiTSXTjOCRMd/ZW+F/mXsI9T3A3QuX1CA8h/ClKKWeZik9kCSPpUzxWbjSfKlHR1pknZ55hKdnhQRa
Q+ufmEPEZlhbvRmFBmeBO2zFnTOM1PIe9kUSo7h6NKj8g3y4sTEsro4Qm2DIiXgH1eySw2EaDQ0Pr+sSpID4JmeSWHaz4/aCpLjW
43CI0CYLBPHnYaXlGkFl9FBDVDJBeaeUI5lpsDzs/R2ZVuqkUGjbA0R0xGvpBykTIreHKFJ6pZSuOtH+go9Np+1JqqoNFz0GFA77
Ebb8co+pOUDyK0eSTpm8ddlwg34ndjUQUaidhKCxJZMFaLjr5Fghm3Z4kNl1oRxLCdaDLj05YUSa2Ap2xOAwVEj+7a+pZ1FTD8T+
jAvMhNiNaFhGpxAX9MU+1a+KoYWZfovwFLhj2GeI30i+E8ffwHM/Rn7w7OE92K1nn7tJIfk9a6AsuKQwRHztvK1GIHTV6V3cz73O
ImoKzsfCCNYEQvHVfGz1kvmFkI3oZLtAeHyBREHk1t/A2b3eO3RPU5ic+SfuxyJwBLberND+OrIBbjmIRMqJ/MCuASWdshcGeiEd
9BRH+THftR7nlAdAKVAtoyGXWoJYSd88UP2IHdcw1AKKT0rhCejDWOXKwdFNnnd3I+txrM2bZ2PLvnhefB3eaNPPX8+e4//hwpHQ
dgKIQoCW/xpcBuPZm4jC1kpkwbTWnipcvDlFjy3HBXyaoyZEM5r7P6jmJkdU+7gVig6T/gkDqJ4qEEnhOS7rVToAJM95sJ+UDAqI
oxQ3fNkb3mxgKqmc0KF3gbkIu3KwTn3v7hdu1DGBEVAl4V/rvLaOBd8CbqvD55kANsOVfNYmnDcrbzUho5iBDDjfKWRYG1qf1SdZ
FDFA2KLOD8aOfbjYkiNWsXRrRG5Ucne0prx75vz+q/EKM/gzqzvh0mcPzbWUto1IB5C/DW0MKrtlSkqVtVuTqw==