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+W8bp5vydFquEK7SylAxxmj9Y3jlgmW+NjiDvF06/oTggrxm9CYfeeYUZL13ScecoumEojzc/UUt6VtJWSQtANr1x2
1kxiGpQkPDNXLcBfi/HB7Dawbdt53J2ZudjWljy9Mn8SkGWToP1Y5oy4csLjbOZNoYNC2h1Ibu4QV0Hd/wrj3Qdtc36if8KmIhmx
0DKAQp0p22+IaZ/uLwUBWH25wEM0wJgSLQ/NI1vf3geRABiWsYob7X2iByjotLTA9MnvrscFU4bhwHxH8P/h9MrjROm8kQtEGtCr
PuGmpVm+fWr8Seevy18cXzgonCsSaQja0JMk6ZI2gW+hBmQ6N31nVV4UBn/GH6CXRRdV5fdzpyuc7bhjIZt9PFjx6aer6WrCR/FB
s02h7AMOu8GPa+TX9V836gU0hxaf/XVEnTigWnnwIYtrcpUDi2+04l/N5r8UBJE1L1qjyHEMGU6zvY8XevQzXhPUwxHOM9jMCYDt
t3x8xttlW2gyIaB8Akc80TqynnTQYsCGGcNm1h/p4d8RQ79QQPI/Ysj7ap+a8FPnSfxb/td5qBV2l7vWLRArXsZv81ySn/OL4TS8
wuSXWGKGMfKQ18vqM396XkskiBCdUKE55afAxM28DBHOxFIh5PBybr7mH8AHovwhwSpaCNbsR0tGcggMe2LqSvLyWjlNh8Pb5yWG
IWMnplNdCccsv77tQbwjhLUf+8oZcm8ENFh/NCTqH+gDg9/+XrUO8+71bUs15E2bRyGzvtapf9rUCz9k5YsQ2HtHuD5OQCrJlHKh
TFGsir+k3lJciRtJNgszunBckrEYvOuNOv5hU3hoRf7FtrQEjYii9w7ChL5m42mzfwTCVMmXTPzaCae1/rxl2aSET4pOxBvWlMMd
Bmo07MLFRRPRNGMNhu+92gXYgpETsq8t/ahSYoB5oN0lf3AsA/znbJSuqVk/ZmXcEHgW1KIzcrx691e0TkAXOhY9bE/Ms3GlCHsS
XT+LfEoAuQ82i7iiQ4IfK34iFHtdMR+dV7YTReFzHB6yH5tTXeR2nH9zzI+L8v2mWMKeoyCFya6/bJrkWhe7/wcpRipi1jvUGYyg
WIxIXduWhIautgMSVT2vj4v+xLKeXvsidxy7nzJMUSky0FVexq+4Ol6gHUPVDjEJCdz/Kt+tISIB6ObyQZCUWOL9bCnq/SrTiCvu
KIDaNpt1bLWkjWHOBJgxmLhi7DYL0+wEAfjfjN5VPHYNP/CKpG/dGIgxLrzQuF5b6w4OAhKh/G2pPmn5QQBUUsxok2PD5htSWKEc
xL4W0xktaujeSZWneXvjWPq799giNabsUSyu5SBbSXZsxwxuue4wM1HlYSJXf+oqFloY91yEztcNSw4lUZdyRQ5YUKjTQnaBNgt8
9l4/r/wwSPRL+aHxN5ehjn73K9ct1+CNNCBclgp0/t0b4pQqVmDN7UH1pm+r5ekCS21/IVe8nh49EnIfoK0KiQn74z3vB7kqGAMY
6RO8Tj+KQX0prnyTXLi5CJbXVRnGkb3Na43Eu8ZUA30EFvy/Gf/2yeD7+ES8e6/fWlvif6I3JbORgux/QPz9gbV1AI1bUgL5RflA
2meUThGxlHfMwZAGKlTUFRgfkABrMEjVFlwCDEXpOl/d5npydxw0WfcH8+Zca2U7m2WRpilRBkGhEd33BhR85m9/uT1SrBUZtH+Z
gNXQfg4zBDP9WuNdMgC/Qahzue+XXEmHCa1/fzBIQ1dacf9yKAARZrrqe12Tyi+xve42x7P3+bpmA8LCdnklxU6JNjJnitTQ+MOF
5YX70O/0CSfufUm8k6Ax9lgMD34sdDpxuIJV98WbQLELIVEuufa2aMijCbgtzfN/SAhilpd57tpXKXmrfsheiqctQUv1MRUvzxXF
hpJeqzUDgjoCjPv4s6ZROEdf2fy1622y7Wt0HShjyQRO10VNnUmb0En4eLIrFGoOTnQUifZ4pDQ+OMQ8lDX55PLX553X/iQYJpTV
rbwpkTe7PAiILFbv0bdYARE99LF6JEASGK4rfhXSgpsv0g8QSMq0kui4G45QGC0brPPHM1K8QgFJyBSuW5dOTNwEVG0pjRMNnB5X
yfETqoVqyLE7qgDEd/mNyCZFf9Dbk44zhILLh28mDHhRbMFofpQm+YaaPU77g3hsRjmbDOUVDouWRqv3PvenMQZKEo9yW51vUM5D
j+B6/8l4hl3HgKR9nA1d+NF5w3Vc/X+56TlNoI90sFGHDttcgYjaSUhkl3RsqrDqlNhHGgIzcVIpiyV5PCOOK114cVT8CJj64CzX
mUWmSL0F36fbZ7pNsbDsw/OqMrY8TFyBrT5aUDkSJHwkUcdg1Quz5lF31vHGJINodzQJoM+qeK5MJotAP0GcpwiNvsEeP3cdqa4v
DZ69Wc1RnloxHG+z0b771c4gRJ0wXpsL+LAPEZEheQv7SMU1dBPS6Vntlz30OFu6jhDMv4LDjCgTBOs7aqN+gAVcId4U1RA8yD5Z
bnYfyp8tmOdW1CZD0tOxaCJWSpQyNA/USaVuOoguLfMaXimMWkjom4JJTIGLrX4aiOGlHzMyMp5ptlaxFfU8es3lMV5tF2Q2euSt
CTNmQOMCVyRYjT0fws8M1L59u6a+Hk6Gmx6jNC+SXEAYzPrEYBFpebaiL2tqhrb1ZcWrPoWSLMl9C+Yf2mPGEArkX/c1LTpJ7Fkm
lMMruNn09pLTFuKr2rrprY2DQ5Xl2YwpU7tedTx81A43qvPwNI480PsCJp+GCT05pOLbX+BgeCxeGWM4q8l0sGbtgXZFiCAFIDaO
KX+4MSbTNsTuwxOE91cPu0B6OQ0YF3MFIN7umFW9CIriGyM0zS+xSkiiBON4w1aspJ03LlZqBj5ZWrz56JAknhV6yIEuLcVJ2fYJ
Sov2FIeXuLza1wCYckp2HXKt0vkd/4847Px7r113DmHosby9YQL0NJcJ3m9PZNS/Gb846ZFTRe/vVzfbUwppe+8ZgzYyNnJJDbF6
sdCyC3Ztle4ECbBqXrRK8PRQRWFKJ7iWjYbuVx5pg9fK4u3VxM1Vsy0vWSVSr7J+HX8rJ6+I8Uk38qyCeuVbjk5ReV4e/EzArsy0
+7+UWPDhEBYog0v9/CLeD/9nGp5klIB2gFG8QgG0bj8sHcq7Lhssg5CLu9ZXZ5ehkm7UCD7NBhpR1Byjc504QrqWaWozaxOvvzdS
fWtONnHMah+EX3+Vuc/wupdkPSqe8jPOmlQ1OSItM/zdvzqI8QRZsvgI5ytwlY3sjZlub61tYaviAbhrIG1IAWjZ2ZBh+r5M8WKy
+4g2O5+SaoMoPm0l8MVk2cIeJcelrhi5SLlUC/WS1s/yweQyyBC1QD8VUa8pnFZiG9mTsKTshOGuJwPog0xrZaPnac2pKeDjy+Il
dzm725s33ZErID0ZHIKquIBDyuo2I5s71nLkFWnZiAU9qZtm0EXAkSwRqytkUha+wHrAnZlqV2p+7icLLzXdjf96wTzv0afgMJ2b
FbCWguZ4zLhQVLZQ2s3NzH3o3bCmhc/UBiKJCHjUasgeeUvv5ORRjm5w0Ee3rzqkrJg7oXmrJbLYZLlcS46sio7Xn6KvWehNK/Wi
lL/f/xYLgsTz4dX0MLROgP68DLg2+pbibeQuxDaDz7Eenjmf4eefYToYKCDB2IZzQWU4J2EL5Fj0W14f6vi9/N8ghkqsSBfrO1LE
X4g1qOkUdXxPawZWPuYp9CxY3s5Ej/y03dXg+WEPKTOviiMDoTI2ICo0N0IOczUymhpa+H6Cv5M7rD5Fn2lS62prEkP4bAPP10KX
JxdJY27zlZ/Hds6fKm7oUIgXxKelY8ImJIsnEdYR6wRc4gh1EvvF69Gq3mQ02lRcs+piRGAVuwa1uHoYPKeQcROTpbVwT32TGH93
2Jx+vQ9CYOjetVgxqirpXz0VF/S/jdQ6qpCa0HqE8NRKDif1ZlXXxQvx/Paa1sIYa+vRwpVpVQnxHbJFjHTgrLvV83v96NikCGj0
qhHmQJfbivspetQrzFdKyTyMpej86xBYYXywPcr0RWsym8Jqc4NWYzEl43oKwxxxZwHwSMCi2BJKBAoK0uqdx0A0qf34WPZEK2QO
ye6vevxmYEeCZ2NJmkpkfQZcjByXMgV4AIsgTFJqXp2wP+0lbg7f0DwrQS6J2UjFrUEs+imwo4EmQhCuLMacu6G52SqE1P3UBeFv
5jN/L7UZqu+RgYtl2DE5NMBppuRkfYhnHbE5E/iFP3wB+bv1+drDGi24nNOAAERuL1wFW550GfaNsduAuZJ++re9wpMwLa+MIsN/
ABZSSVLpqCb1OXYfgqBJcesTBIUCHNJM3EGlCp6CWLa0tlHFPwDn+VRgcpZcHudblWL/069uFVsTG3SGSRJFD/w2qf2o8v32kHf6
3R1DfLmg0TCACRJmG2uBp0Dy22NrA5T2siGQihLcMZNLHLB+JDCRD1qPJDavo0z2KRVEjB5wFttULmmocH1MBMNaegkpj8wtmGLb
UEQiUKrhplqR2tmH68qbJNjdgiDOrhzQmwV0KpglIrKUqGzcaQCPHOPP00pLFaIVvP57RPG2stF0Naqupjn0mYSjkyN5UnuRgzBl
Jx5S5KNTwERD8EZZpxv0f0O/qMHgWBXo4Lsr93NZbaGvqX10SARYjo2UzFAUqixw2A+S16afCOTUVi4fdHeQ1VV3YozlDYLNAPkC
e3I+FyFdfNz5lfYfLfdnhf8cnJ9E7Nqny0hiHSp5V/N0ACDc7ak3/hHkwOkMSS+Cr6LsDyWFesIcBwU=