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+D8jgmK9VqkEk1SbvrZDGDcT03+dl6YE+AXR9CfzKb0oFoQzpgNicNSbmhjak+YuLS+5M8yp20cfrLC49brZwjWlnJ
U0fauO/8daixW1wkhdt7tUowST7QTO9qEsKz+4gXaa+O00dssId1I2Tr/10Y62I8WLwIbdfL3c2s/j+YN6m9wIX68Z8fXP9IpyEl
KwBY5s+Axovj3fm4pHI3mRIJpQsYLmtGceTmeVoUcPBEbg405/65mRDpThmtN0Rpl+rXIo3Kuw6MXJqob9lF5qmtaM+zXiapUOsh
b3bDNDRx+XfZVLZ20yKjocXC6gzop/DKxVd06XaCpwBwujfbz3ZI8b3yqjbIMnL8RpXj82NUzU0YgFKCPAXN9p3M2fT0GA93eufG
bucREwHU6kgFt3M0SD1BHnOVx8TqkReOCZAZQsBODCDUJwcxoMXic/SfHiVEehqE9cztOgfN82/EtMfc0jtpPNF7eSEGq51U+xXi
iM5+CWGcsOlniZbUNI+kh2jn0v71aWZQPcM+cbQGWINC+MGkoRnHU9/gxDZAX54adDAH6fURD4Oi/edg0x5oq4i60ocsUq53IENJ
e6LiyQSAnbAFMbTT/khG3eMFSgfWXJ/77/jgQt2/EiqaO+lvzUoyBmqznohSYyFGx98uytg8z6x6Qw0ezGUDcK9QHymJgincDV3R
mF0I0C6TnuIRLl5S7lvXKA1krMAmgGnLoX/VEHaxlq1t713T6OENnVwi4rRR8MR+M5v/KW7w0ll7JompEj7q1g/Bu4KT4A9BZWKF
gbCbo2AOJ7ixE7GI+ZSeDxWz4xkRNnUpLAgcdLbBlMbrYA/MDp5XhS+W2EBBVYaBo3+MGkYjc18KXWKW1WSSTSGhziwOQ2506xUb
A6m3rO0mo9TlETkd5/DF5CnVPMyz2VQp35wX0muE3H/vLupAGK6aixQ6ztwyZqKBSj0iwXA6xRuv8j4NHnuKdwcWJgG5mfvxkR08
1vrxMBRbdSClLnQpZYrqEF0lsPDxHv1m6BNev+KPD4udXbfCMWksyBuEJEBWVlAl02tqk498JCxEAbT+MSR1/iB4nbKW0bg6Jx/j
+9cxA+ppCj+MZT2CV7/3Np7MUTapjhS7fUr8ZZWhgPU+KBYJg+UihFRjQeyJLWpEde1omoqP+FuMErvd/R8UIGLvgOr6rRp4bU77
0aV2NlBlBUDHougcPaenHR9vO6qv2zA5UipwkGjMj452De5ey5FJdGUElf7L4nVeR7DJfIUswgcOQPZxUgMxpTEeQV85d62HzGjg
YyOo4CReM+bc6B/RjgmCXApktUWulqw98u3oWmzBV55nV9yJ9w+mPYL57rdQ+JpjwjiBDDV146Vbp0oA1B40kqQz6v6HAdS6tW1J
AvXGrWLB3RlIvid1ayxZME8YEVBYlKs0hnB7WRuEWbGEJpb4nXaPesaJHHmOGc+HszV55H6Y1W+PlyJvZAj8LdK/ss3c+drwYF6z
I4f9vjjA8C1mcDfXe8arqvWZJW/5eCZ+dNDF/RjEBTQqWSiJ7EC1NGEA3AywMLk+2ehcnc2/cTFxGn4FYr6lgnxRSu9cbCi472BB
tTS6Wbftl2htMbc85F+SAMDWCAJdU0kXxb8FW+iARljogPqtvhtQ+AGhfM75iA97/bh3czCuELpGexhFt9NI7G5utt+ughbmSE6x
uYqg5dPyMODJ2Nq0Ot0YhICaaigZwrtl1n4Rinj4Q8qGtWzjRYmL28EctN1j/RbMjnOPToFZ1RcZiKCS46p6+6/SIc8fVnwZ0A55
8empl3GwsiD1fleo+K9JT/omPE5OLbLQZp8aYme4aYOnBfxop2UcT3cIMqFzFkUB+u9R5Sb4Q8S/hNhuh1S2U7//cjF4RlCH9ixA
4HDBf7duj0gNil5LSaI1RKVGzU9VJYr9JKlBgflz9sc7pwlQd+DR4g7btIelep0RK1oHJbBUFmGGpgY8BzriXjTwLJJTmjZfhYvs
zJRSohP3XYrugrWfAJ5xmZG0DQoMcT1cC9TCYKh06iohtgb1NLDxBNZPhzKials0wzw7a+/3PoqTdYKBJrCVw3ySVBAWgOnS/mxq
hoX4QBdcaxI06htNzD6Y2hvAwXILCtdw1uO95HIWTUjM4R8reMaGd6Th+mg/lIU821AOIfaJjru8NccpfWPXb2WzikhQm5BJP4HE
H1M6YdFbwHWECUP5vg9oATPByVRXtFmZtA0+nIlTT7RE2/mibnWbOFw+/lRaLqmszwcN9n4bdSS7o3CWBOPt8tgWQAG0OFQPv44W
5HEwluaLomeMgHOSi4h36xywgob0w1hRNfGIBTExUbXVQjQlc/JTwevD+ZtlMw/Itl1iMm4LEmkcL5tuQW5SreJihEE/TCbkZb6G
ogXwQeEFcU3j/sR6xw2GdsMgQAg0STUquxRA8uL7NrPP8TALBdrmi+T1FYzFeiPL5OGjzn9kJbzeboxaoTOKl1pjx1bRgQtk1eN3
TCdcScwRR48AD0MEQ2zNyovswyMIlabyr/TMqsafgiQSkY0jpj1PX7MRZClzXWvZq7sRr+52R+gxNcBzcszlDPmr/qO7R3vhJu3l
5+A0vwLpUte7sLA+Q3wwo7gOreltZwdB642zS7WKX1CYgE7IpaJg5FnLmcM8/9mVhqnURfeF1/iUmEdpIGUiQt/sNt8yt2UOux6O
zkFMbAcvqVwgtZOZXVRQApmngh3PfAgOlj8m7gi/0uBkUGFzg2Jl0mRds/lOR7MLluo4b6ZwjmkpBXFApv21t6Tiq+b79naZ0RFo
/nwLOUs0/O8hOMHOtfgON7d0rpoVe+TAZfnT4+0l5eSy/5vU92XMyPbb0cr3tbdmVcjPeITiOB86UBAm4MiFkPQAMMQMJO88RJOD
5RQ2EQHw2M3Vj6HuWLqK2usmf/7T6lx5HmnZVRP2khgmbg3tv04bF657MOMmLKnzg+YKamDQvVF41r6FJB4tkjtF0IlZHiBJPgSM
wQz+I8G4y/Da5QIRFLQCzhkbUAZ8aufOIKIqgFgVhLtDyefsUhUQLa8fPo/YeqzrZ7jkphy1JXRgO03a1ygNyco9j1S8Rn2VqYgx
DfoOtfNkwbblLjn9ySTc3U1JF6Hqw5uegbPHkHe5nTRxrvb9GJyf1/MzU+CMJdX/Lhg/O63H5lu/c1M8qurC2W7F3ZlMnrhhCh6L
EPQu01625KAtmRYnLo/rWsx3Lr2dauR6jcApTZ2RSGoBYkc0f2F70MliYA7AT8dn+oJTuLx9k0EnNzDS6tNy+1Ax5diaxAU4auE0
G8kyrHmDMRW5P7ayMTGiX1XbndSGz3puF0mNGzH5o/LjJZNAtpwci+WzCRrvhEBO8QezX1CELaA/mdK50u91R5iliG6TajHkHZKa
Mo9HsKVKxZL5Fu7k5WqI6+7FyKIF/sZZmlRj+X/BTHk0YSwn/p2s2jZk34BZo3O2hvaBQOQA2ihtNQ2+5YTueoZUD3QboYKIBxdy
DufMBBPxXncShrf6Aw9T3u8r9Vrz30wJGf3Ljb1Qi3WrTD+lurEXL2WpqLP08g00HKWpHGZYOCRC7Oo+fRZoBO/5caxSEH8cB4c0
5O7yAIfEzZVbX665MRxKlcHEhVCB5+rajdikBWTRXUrvNG+9kNriLtq7pikPa/U4ChAsVE7MA+6A44w2SeF6F49utdTFqT03ds1+
TrhOl/t/1lIlYCHDPzLIwVpZS92l6bkpzXk2+4wJi1TLGCidJGJtzPdPy73f9gK5bvs2+5TC+qirkYuqTO/CDXFPXUvCx1daVehC
Nw+BhT0uMKZiyH6SG/ybyCdaDa4fwMtIDHLWzTxQOwnQnOSnqOQyrsFm7nKsY6IAztASIF2xoYbDVqk5X7AZW65rxF51ldcXRNbd
cZw+aZ38HTLmhFbvNEsoQ8/OmBnTpE0XRMJ4vAAJxI3l9lrqV8heJWEwX2QAVbwUyeuK8O5eP/sjjBPpRKSynqcQ0BFSKwS0gkFN
QEljNY+0Uvoe9XAT0sNwrwuABCXbSj/4an1p/3Qrf8KLvf7+38WV9NHZl7SD92XrxGZXT2jWYIwlQzJYXWcM7PH8IkVWZm6hCYa2
7/ptVCjqHZmveXiv9rgU7l2Jabhugkrp+1PuZ07wWuYD45cMO4bE5AdLjD8jQ4ALuAr84OzsYqnxEANK1+nqjBmheDN6OlqUvj8I
jEfa/SCOZYT+JpdVhm1Q/I3IrEBJhnBpblt6rovLLsMb81y7UAz9uw8JH+NpuvtXzvKotxq/WB57R8I0kZVO+DltgUit9l7rp3+7
pvHRjaXtTo68NSTSiiGug9SJHIqHflXQlCdAmjqYpA6IIz/qNA1UxAbPt3fUoVfzpC8NIVe71crPTVn1qt5qoUo9F7C9dvnQNH2l
RIKdL2Xp7kgSf1T/f4ja3zhEnUYDTkls83/pp4dUQdlAqT8DIsRHSbnmnO8ngfFhOSuBGsEUJQQLf330K/pdysMsVYqQdlc7TSBL
vx1mn6UIN0mMnfb9nBPz4d5Vbdh5jcbTQhoEh1kAq7wLyIUr2D23Qh2RCmPAnpNKpPF2ZA5w3v6hz0LfngLp3LB31MYM5eH7YaeF
qg0CaMj9a2oyQbp7sZ3eSe2O/zTaqAjFvigUHY0YNFJ+YTm/R69diJG7UcNAGGgUrqos4Gps0KeNQn6xYkzQZoSyEw//TS97GoAj
msd5948aJiPrjZh4t9vNmdYREBpMSau23MQxaZUjL6JfqN+O3Pn3KlIeCsqHeuywVnrctB8AU2Xt1s8=