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/WemPzBWY5UEVW2PvX6wFtBOL/XmDyH6ZCrvcl2DmA/6RmTC7SEjm3Qfv7ZhelHfzvHdQA3W2PuO6Ar7S4MrPbSmeI
lc4Pkk9+W2nujlyN3hlXGQgcF1FcDT1kiv8XuQo78TxkPCaQ/OJl6CQXDzgLFUvUHohiJqzcnQVnNxxuRM/HaPKB9Zs4zdD3wN5z
q5s8I+NhL9nBzNKyrGCT4C2e40bZEMeSOCZF4ZvhD728yVscyM0ZTGj8MdWckUfsRmginbV8SqpbPSzjbTu1q8S7P0AUQjQ/AZaI
zRjJBlagCFRnLPAAa7DGVffIw3DU2tA040Es+sAN3FIyLV12sEFy6W/JpgmVrBeGq/ppvBN1jI5zVw61VXQbgST9h1JHd399o1mh
nLfNNVrSMUB/cIFC2uGDR83XXlVNfrA7OHbN8wwIucsm3a/Ns32unGcN3gzZfFtTh/Nj2Qe88IZes6x2Kp5qChFW4cehpGB6P0He
JrhsR0JXWj8IP1o+ODdySqcevIZKhcZxwSHFPeL1CrDEi96Y00bPHwGSWOLcwWiwdSkXITCoDd8hNwNLeG1BAz1dFCu6FL90lVOm
m5Boeh+baYWY/vPoLLwVg3V2CO57CXoLP635ajntspMnLPWFTQXzyN7FQkQ6kr8UtRpj903sPfBgkKzpByyAv/5+SIq6DLh+nOsQ
1te8dqNy0gmn7I5C9lPutOOwzI2cme347Ynlgopbu7WVUnllgPTOPnaKvsGu7klr1ub4pOz/kySqc07lnTehttGbN3w/ZCG+7ADD
3BMRV1BkH5tY8vWbm3VnTtyx5PWYCWniWhN+SZ76PGyhJl0TlGtTcrXmJ7/aRFY/QJvvJIeN+oX9s+6frY/8VkcYDeEpJyaVWJbW
zM9sQqSq/VGAoS+ptZnllz4NCxSCQhZSDB1FfZZ1OE7bTw7AFzEOMZ3kZ7fjUc7Hm+SGLSsSzVImopmenTztGOeKU9QKsRiqiNPQ
5SL0is1Wn31jya2WamoMDnk7JPXU/aA04eUZVmo7CsnX6lbFavQ00L3D+YXktGy9ndr0Hr7QNMUcqQaTSnBTM3olDGPIaoPcG5QO
hSo61+EV8G3zskcYWEQKpzt4y3bgzkhnTFYICq/y3xm/ubnow5dRnE+ZdoiIoA49XTdEQwhjePLRDG39UjJGi1boIuMKpI0iIZPy
NOo2YUsCIUXByWsMD3ArqbeXGE/US4wYJSa0gCvRwmmtlBP3DeHBLiGyqAv833vffc2kEMVasMzZrRjlecftPWueqwt6pCngYiZt
ahrjBwOsW6E6vXYADSY+tY4fsWNxm9EiViF6d/y8RfN5aO57yQdi1mayIyX8ZLHZuA47MX9SD/d6ISAjquBdB/hM1uC3Rl5LF5/H
9jAnnEu+zk2c/nTpgSOZYqHP0x4g2VK+9/hVFd5rW7REwtS82zEweJWMASXRFSjEtF04VpkvYcUVItpUIJnczPq5yFu49rdGu8gg
0TI/YrpUPPuWGUrS4QN4L36LIRAEFQoOEYSlnb1B6UFCmgdWjY73edku+/80DYg1wqn37RW/Y6h8/iW9lz6rIyUlify1KYF35Qbw
B0w1zlOkGZ1Bcdr70guGpwMsegx/pvMSzFOviDvsAPkTM6VFVgcGcrYgEVo/NnymjNcXAN9xtSnMfeJNXtGHJd2LYbgx40Dgy8Hu
DPKrTeeqj57fusG+FQhBTApOGObxLaFvIxgVqc6OhOyYCzHC/NfPjLWu9t4xqTxFNLL5IXJmGhEDzcDrcOwXP8O5jDlJelTzeRZ8
Onxi2YXv6fyBBHtHHBVPqvs/Yymio7HnXNLs4ejTB9zhYBnpyFluphU7GaICwx0/tfurd1WKd7/nceS5FSf8WFP4s7b5uqm08yfa
pxbZi033RvDYmmdze2y7LOMHznx8m9nRRUQQtv71IrEcjswm24C/dAtr+HW6G/FBl6dFp6l85egTdEdFy5UJvAg27b0iw1xBB8Zo
Cvb7M8uv0xp8NpWctijsVwJ/2FkYrfyIsaIlWSBGEfIycobNo7h3WS8mksqnnitTFGOrHDvK6st0JtjDWEce96VFXIxyZBNl6XUb
O+RVL7OeQxNHEG1jhz2Qf7/VGV21RHmCKr19h9lC8pPZM02+gWYl3dsSjUqVMSB/5Ud3qEdPHNE4zNHW2MXi0aRq01KyrZ1576N5
v4FWQsbaOv2qtyAEnFBLUCg1vmnvC0eI2NuwDV+SpV1zZmz3Bl01VQEsRNACGIxBQZWdqkwpGz6wpssDyFR7KGbdviF+edlxErV5
11hilSzmAtsdTfyxCumebhjF9R37zcS0nCkCLuqQICs8pXxa+qHOzh/oB/XdPrRjXbl0MWe09hyvckEnKhZH+OuAvOS/YSK0cQHB
psG/LodvpxxPkPpzdXaMailg6T3FSRclNdQ/eIhdV/skp6wpgUAFj26w1VaSx2slx8yHpdoAlPtauv8Sv+Y4aOLSrTAuLrQdbmzy
Hqh7QLLjQfBmUgPlVYtvl0s8pagdjr0Iosziyg1WaqWKIdhZd3UNTukcx38xZoU4LW//cMWimxDPq5OWfffkZ1lmUYYogaLVMj5H
WfRefAG0oJ8Bvh1yVU45mK7yRiuW76XIN6BWSTxNsMb9m5ghaCZJPdRdt9XxjqVw2FXy2JpnP7aJ/1n9o4tnY5FxXc6L7xYU9X36
udtF4vBqWN86SSLAiPVuRr19bi5JuANLPxfoECb4ZRCOiu+4gn6aYWhQm1EL4Tbq5OiAF3UN1SaHleh9wctJioc0FiFG+1ZMMjYg
fiIkVh89fOdCwslH4I0dNYtcAq6mbudU6/O0veAyIqYE/gltCFkNNpOQYysJbyIs2N2wJ5p2PosyyLvi+9rMHUQaBi3ktDv4fTJN
QgHiTnxAtNqbWr5iFHw2DtYTISJN9+mXWkoldF687Z5YdAnAlrh5Xrf9iB8ko5N4lmQyhrKa1BEE21tODDFeZGSV7Izw1EWgME2w
O7HdevItaOpXafoS8kIPZOM/uqihBN7j9rvIt1njnA2+B/rOArVPF2FXljOmsQUcgYXeOTX/yOcdx+JR/g4UJnEjG+FMOrxaCB47
UqUZszkLRRIe7QHYvgpAT9UuOz1s11eiEsaIt6rJj8vgZgF+AemLFAHXoAi2I/GgwofJzqpKdNGKsTnqCDjRq9z8bdGT0nEmrAqR
P5uiPgYAFwHLu+nQxG4oMhyl8icRpAMuSrsxnoavrIoFps6thT10sk21AoKwVEbtp78UeSbVzr9kTn5zjecw2fnLTcEX6FnvWCH/
4paD0xsJLy6wjJIIX5MvSePxfGjOFEDhFuQJh2vafU1yl+bu8UuLNqW4WNqTA0tfPMwqDSvvXIUanG2nxxEvskhXek4VkvbdFWud
02ZVgOHfeVRZkfOmMypUoSebsH+CxnfpcPFWpuS+puAY5mfGrI0p962Au3eA8LSJALSl+e429jyS72lb8gQkwdK0KAfBhCIBx7VG
H+c6WzewbpDvXiq3npfxr4gbZku1xvjpH+vjw75LvfdvOLTCkRsqmgHK2CTM+DYkJwW459tHRDwhIbo6NpUFt/WnPabgtYNVghVR
9fpeFz5Bx13DRGj4r0IkES0FXGZzP1rPEtnmnWeimTQAW9nTeH8QBV16eYRlF9NHJIo6NGlSZst7zon4x1lVo+dlVEBXIULum3B0
15P2iXTAKO6SUvzRLq6s+ZjQqCpQwKksuwyZpTqo+wEtA8cPP6oZfRThPpgy1NAlboJ2UksbGN3Fq1W4AvCPktcgcceqXO8WDOa3
0cVl2XT1wijwXlclEv+7vjFA5HN9LgE3KhJSEOK7OyH47s3q8E40ElxZtcJjnjkJW7WKkZfvPBqsadfqJbkkOBsjSKBexc5pUXLU
Hl7TanXYtyr8YIFq0Pm8IghlUyNuggp3aAE4ESgPHblTvoeu3U79f3SgDfHynDtN1Ek+ebweI6ZvIbykJ87dSnmd49lz6KRwus56
OyKjqgBJpmJGakzflZjuYE8kCb6LUhUqBe2DxAM2NHyrc3FP5FvIAUDaXqdvMv8elAnUDJ7cGlGkGPWv46xKfPSKvHq/6HayHulN
J7rqNRwNtNs9x7hagZlEDbc4ylAAbtquJt3RDRzF3kHzRN2dNJmeSQFlYQ8GIAui6LEli7h8rH0BF496sKx4socg/7g6ODwkkyHW
621HzHG9DvkES2JhJ1M9n1Da7ufqRUIo0E5KIEb7RUfL6jHQ3lhzgRJ9iLkCocO59oW6ncsUN7AsEiuelhyLit1z5MOyx8409wjR
huM4P5Lj0cQdQmyhRYBZzdV5PxiYgJXK3AdyC1J7RsVDr/cShQNlHYUbVmPj2Wa3gwlcDhUxD8sN0OUjeYqb2xJPC1g3abPkjx3B
meyTX98QiLDS2xrRqb+jq476jzeVJz6ZDseQrVX0tpuRyG7z8eFAe1+BG3sXjoUGgtu68tVxqSQMuioVNBD3VyzRBYp5/bwnv68T
rTUbTlPYP2u3ViXaTNw/xdosoI1xM5R6eP2gnRBvXcck2mMsHkmf4yCyHKsCbNHbD+tlyfb+7VDA0QHpLAUD9+QJakiSqJc+TFOq
fSB3iznGWbpx4/IYM07He3SgCoI3AF+c3So/I1iSXdHdnzUcXkaZrnJ7xtxacwpUORWPAL+2jkeKUiK3o0iATG1q1VVFfmNHLH8v
2xjkPgiFRD/xTQ4yYBA92ju4WBv4a9MEcmjO+5NzvDq3wsGCcTGIyBi12FT7kqtOEJ1v3pSVaVLKKNk=