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+Lk8HkscGkILxMvNDK58gUvVNxofcZMhOLNCwzbpaf+JE12pa8oU0R/gumpMqCwXq5LQh/I3VLvtVQYQRBr9YwMgaQ
CF8U2ecCclKuU9Xluqr7/EjZXJwQ+F6/Mm5sXyQWS/NyAjjroiKQGtD0B66tXqX/AODr1thMG+1rCkcpRKRRenDR45Vdwu7sOCdP
Mm+iuVKi4gg0cM+KKvdoDR/6FWQjbCoyWJ6eMjchwGfc69DoGJMEaMi/zf0cs+t034RNwDf4retlAPDzgFqCBcdcvaXkxdnGV8Sm
gxts8GCEcaDbF5UIK2qzBek6MAfP6NYgQ4AeadUGiiGGj0E3PgcHZCt5qhIKciJU+0dvovekScJWZudoXowIwtRIS/QTBm5JuZ9L
Od3GVaBHH/XGvrG4u8mZS+LaRY9WZjs9a/uIuhwYzJkT6CJTndzo2FaxOY2wgZcnYFFCriSCb7PANSwusOP13gtW/9VXHfmGazCP
qYq1vdZ1B/Y6vnm70NdUg57IqDgy5G22xlOi8/O4iWwS8hElD5N59RGDjpOAZidd363ke7xh1b7s/VACnH8ELiYxpkgKdKhS73lI
+QodahYEsTzM0WPVmcC7pOkxDueZDni1G4fDgg5r5Af6e20DkVBEwZXEaiTcP7V+goA+291uIrXGYe2JCeg0vmWvRCMHJBbifGTg
FGyfh6VluL4gKewjO2r53PO1MjRP0fwC1rbaWQx/rTf/XWmMATon+mfzZOt15vbv7H21WyY7Btc36X/EyKMch6bHJYcCPqsy5gaZ
RFY5lIAsnS85zCH02tBDZAORIp3eGJPr1G6VyKRDxhQYD4ZfR7aHcO7Qy4igkp5yrmB80PwXFLHLKWIgzpSvFXgoBhME6E4T313h
QexPFf0OXDE3OMSXlg70p6n/poWc49clW5gBOcFzf6VJir+Y9JTKR8I2hQ01/gABciyt0MnvmMhiyK8iW0gpJUcsUNivn/C9p2NE
qqrPTzThlSTDT7/6pecJG4h0PjO9uzJsxyzhvjpYWhetJ4strKgoeCEgXH32tc8pzogiBrUax7YvtC+gfh5+u85/VZDPS3IFe8jS
Ge/Wa8+sWZG6/mTzM7Zwn1bVJCi6ucrfXwPepn4np3g8N0AloI7P6IisL9DiXmown6Wunwi55hDW9MML1ObqrGKFJQU8GDbGY6ot
BiJ1HA5QFrA38TMcam/GWOvSsHXSdbKvLMWuFwaa2BYb1QheeHGzzSyM0z4N40z508rpzYOuKR+tekNEfpigTLpNjzcxj9o6lcep
mRwUhLPVxkjAAT9h3/DN9PQHA7OSjHQ0FWaVZzeoGZZQQn9g/T+erQT7fDBj4+w2sr2h1m3Q2L0gVa850qGrdLJuyzH9YPirozMd
ZIXhI6xBmauFhR2t54TP9/QfxXYZ2MLDJHP3/XURAII3A7sk6lXTZZCXed7ZWJDGxsHuawh3bW0BSPpUAOe79Ecq0ljEMJuAuM3p
Q48bEnUBm9TDa68pAGVPyblLI0DYpbJfN+ukfonKxd047hbTLywOpsrX0RQ8fP8O8ogRDPlaLyCHP8QkyUQ0eDY7JwBO8SD0/1FP
np1yk7hoE3rV0Bm00t/x30PMkkFH2LCihm0Ag+2U2TVMlKaxP7zrjKkuw0BmS4ATPnClexxhjLPn77NB4VXtZ+3dclviQU4NA54i
2r/cWBkPUATcMyUwcn5CJal5e4Jq888SVBpp+QMsmRylh99jt5KmioIZ7xPyc+ahXUTcnhaFojlsQMpPHlO9pwrHDq2rfvi5ioWw
0AXlKVarJwr6Q3hOv+60I8HdD9m2fUhEDkuYJ5UeI2QSSZpX3CTcm/byZoUCB/DyfkJInVS5K6bw20r/JH/J/hA/BDBgbwY4fVvq
tBJhS3iH7PrvxuzkGtj1ucSgU8trUBrPfiWSVU0egHzPvFuby32YG9LDoytUzSr1ED88jP0Iq0+H8IeZCkEuL/zXC4l+bmFSZ7C+
BU3GpenPSmBFFal9AGNQWaHAEIx08iDQ1srvV0lkxmy/Mua9yfLy3gXf1VP16VIrYsQYZ2lfo1dzgjNQxwDMhLvdJWpdgEE13voU
I7ouXHo+r2ozYM2OH8LjS1JnI78gHeFrqifR4Ae+oa31An3H75CBAxBHZudDDlwCVlid6/JmvsXPmq2Q7IrLVwIJeyYO75YTcS9G
nxwGi7zVpWpqO4S/IJNVciK41qGZwV2J8k6fmnJSxXuyrDQQVWeYLD0JJ5n51KQzL6WOZFVfGCm4q6pe/tZro0oCKdJHqLJ+oV3h
EwEd4e7HTvTgFwGKB+SSueW8QBBFp5RAF65zFhQyZ6WQ/9vebDSa+gWcEJIBtKcap8nQay1iZ7US6NBeDsUfJnrAb07pv2FtpRCd
VlbCdSZMpoOUhmKmQsmmGGAxPyjCYkHh497CINovH7ncBXbgJ+AheJ4M0NkS6hUPlF2hcfmVI5znMXtUAGfaKBu4qIWk3nBbe2r4
nbeyQoLCvm8SZ98/2B4B96aE21m5hlk4V7MkrtSiysF1CUOoCsqYulTbXsV0xosc0x2ppnPGXuVBPbBZJ1em78hPQwvstlnDJcgD
PJax8143Tk9LFSJaEcq04CMeSuF5hvt75p/2iLoqUQHPB6FO6NTeHHyJ3+4kyHvdk7IZ514hqNSRCrLlTxiU7zwS13Sjma413r7n
S9ry9AD2CgsLWqNKp47tw4SrifgPaSBu0bRPOds6LnO0XI+8fBsAOSOFrZcW0Jdp6cPgQ5XPcSq5YW01ivLI9meSESmVwU3BFcTk
yxEcLDWH1ZWuzhC7UP0PeJBWMpYWa+oiEA7670egtHN1zokUSV6TUxak1cPY0/hfKWUmwkL2tSK4auoofxIwHrH+QZQjPUNSvw6u
Vo0TohfUGHWi23+G1A1P8MaSAizDu6gU9u/GxLwOYYHIZIBorkJq+M9fcJAGPC13J5RC2hr7RK5o3IDJxka4jqceUxrMwCaemDDw
H+b3bTQ/AYuLZQ8GHQoNkZ8mEyfUzJ+qrEuZ7sj8uFWS26TZjpkY2g6XFHcr0qwFWYA8Rt6kRw2d7koWGLhq7JbsqNfD3nuhdYGW
uYhX+vUuDiWXkJ1G4rCGUQH9jdJ50azW4pH8TZ24H7QNIYOTc/p3k6ErQwSZchCO2bvuqXQ80tHdptCMN9pFpb+a4G+niHjLJ+lQ
Kg86wvpZfw6lQZvVmpjou0VK9f807WJP1nzwZtaG5ypJxfsrazffucXvOlFVkOpqseBmYrY1VPH2otR38qG/hQ96l6jzKJRyfVhg
doJS4bqqXqgbPz3rz5yYXAuosNQf0uUl9f9SXK5HcIQ0HRA25Aq/8zPKl1B8JrLXOP0qw0Jl7w9J/t7hd162wEruuw0IH10iO4D6
Yy0g0Q6I855vfUCf5txat8nirSdZNz5b9K9EUDdApFMUrFHyrg0RnAFoCinqLMUOfJwAK1jKt3lmxc6gbQTmoh/7L4Y9GQjM+oT6
pQ2ARDk4CKs7TGgicILFZt3cPc4bFUeIUq3OCPY3/mtHFb/93OwaG6wv2QkYm9RdPbYj1F8dQZo8jtoh+vRhIOYz+tJCxjmDTBJK
E/Flv5Ml3JuiEQZAeMBvCVZfp9LAOiQJlOk/HIkSO3/P9Gokczw2+IK5QzCgVCscFYYfcvInxvvsZWuwwDrgesAQXfsJrr6wtmar
arZkWsK4HMUBIVGoC6RboKVHHtojGFqrLM2bdcU/PROKDIdG84pSAgiH244+wbe7wxoCxcVqy5H2qdjX1PyxrPoGHyeP2AFZGW6Z
9tgpIugkER3WNPOk4ft9GPhu+kvyJsoP4J1JeI5A5tEKw+Eion1/mRmFDFQIXJiA+EpiIBuwLzUuWFld9PSq7YtqQK8R/N3jcuAO
vw4W/9vNByc+55/KYEK2U1z3po2Nd7bwUl4uwJAixcVDCtOm8xXnaKmct69inuUSsntT+15hA1xJR7CCUbBAh+4RS0MtHE66emBO
lLKFUPuA1k/c2wLWfee7cmc2FLNwNCIxkRo3lJr/v6ki5/Wq+1ozlNb3n+Y/46SNt6MET9MOd3T1laFn/AQQt49xM7UVYQ0LB8q4
z5BeZJTuUDqvJDrx+uimvJUAiIaaw7NyzVQ9V55SZLgL3kdGGmbA9+ucB9txGaXkdWGpidApjXHyDiTJaKnyRcQZ4Jgj1lOiZXw4
7ciWC2pKOLCxSuvALhVXR4FsRY8L2N8Zaog28rFXhBzgcyN97FLYr3qbA1W/RPxk+vmdcKG4kRDrZcv1JJNLJM4PTHAQpCladMQ0
IBWQYrxitqIaIdraydcs847/O6T7zF1eZBIM2pPe4dag3CQ2C9Oy/s+hUDaptJqXi78oSjFelSAhBiAy+0F3YZeQR5L0uK/pSyge
bABfxdD8Gt8ASFBOkSx7PsdVPmyMeT0QDhBjqRYeYEBZc9Xu70V+mdNl48sBJeqvtPZBLELAvWMTgtMTW27rDQPNkbsKVvPD2+3N
XlszSkB7jn3f3cBy0D+CHqqq7f3iuXeqOb5FS6HFEVb2mVO4idt4lkDiPnweFqSZSA2vWmlMNpSGa8ByPms3WRtTecuuM+KAf7nt
ppicQjFj5a6alUFw8p/N4x3BKpU9dxO03IvffSb06pxIRqoB+Jh3XgJA7lGTYi1X5G/SD4oMHVfdpFXUuChlSZqf7cW1Nc9Ki3qB
d+Y+fnD8wzMrU0xFFqgeCTVkmI8HuHkLczU3U+cICXVD18qq3T0/qScec3iZJqIpLl8DTUk7953RhgB0rEFFM7gH9LJvSvyXuxc/
hlCKa3c6JHtPb4FFCemH17lVBIhW4aRBz/NIERCl3ZSKH17uauN1qXGh7E72nUKvG6PIymY+JnDX+jahBMed0A==