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
be7fc5438c2f5fb388b7431c3d967ea959bc976c4bc81123a18dee68a61febaU2FsdGVkX18FNDDmS92rQqMBjXah6gX5tZpDo5Zli9LHsPSr5MWdRE+7bQqC4y19bfU3Dg5zEYdWFfJTKDdM0QHCXr3NtsPg2olO
lctMQERnFm8/7fJf0cb1GWgzIpYsw7Cg4mqgT2s3bycMZRsxDJ+SVfZAEQFIl63cOTz1ZaQ4Rosx33cvGQZkxKXCmB/CGlCQfj+7
Cs8dmO94qOUkYJLftDRlNiCHOWRapDsSYRMRGWAOy5W56IsfT4uFyzT9pauS+FwA+BkAlfP1NwS15OQy3Hm/RL+jjX4lcOPsZW6m
8Ub0+CXIDmxpdSSsRz4j4vHtMEt5BcfE25zgH2O0qkAwvi9WT45Q9AehU3DV0vYB/imtXPd/6i6qTIOxGLJaDXwKaAPxBN6Iu0AX
+K0vkW4nBj77ma0Zs5ChSkBmkuQmB/LR3WHp43WEpYzlz4RQfXMewMD5BpapxSqMpiNALoQkK64WEYdMczWstB4id792l65g5AGs
55IDGMYrnusSaETQj2iGN9L83qfURQnlx7hFS7R+fMwfgTsRZgQSB49ykCOursJuR3MOfIudYmgXLyJqJsA6lfaaMCel/uYV+9OV
7i/Fb5nSYkZ5R3bVHJjr4ufOQbDA4aaJm5Pr3Hw/PTO5Bqo2vCE2rCGEzQ2ZgXhUX+GoyunrdKPLODFkNM3h7InM07c9PLyevSkP
ekzAsKQWRauBftRtnFi/7BNhbeA+jOlwDXC5jQnA6ViXInZWHKiJMk52MBpNMZqVjK/e8/+W1aajQ7JoX0Aa74Dmq7yimecgL0Lg
ikL3kJvbkIv/EoBasxEOaKfR9LbDzm7q28Sh0q/6TYR0JbJ1YtKOhQaV/d2ZMzR2snj2V/LELB2czSXKB/ORO4a0qKn9aMx4LuV8
14UsEYzrMT5KbFwDAUeMyfUvhMpP0dCs4WzH45Lb93d+5kaNNf2SoKsbLE7HgDMVDFEhZDd9toAgkeV/iWGvcPkxzB0MWA0JzMH/
yOkueclUuX4UQxYZkEFAdz2RlJ2sF915f0jI+CeU+DXJe7r0rw/5TBOHrkd2Iub5jMdgiick2ChDfCP7nO5aO/Xtn9AeLJbnMYj0
mkXP0hU4wsq1MZeFpRiFJ2RrdWOns+gVXDNYOCOfYoPkk7nsknShBQ/rxSB20P5Chv85mwfDN8GOYVrvvJMomKkqEvQeXd/N6fr+
5pLS5Us5ojB1pj824NiXUx3gx3GEL5lpZK3z1bZPWl4tFEtPjhyLT/E0Fk6ECXzSOMnjOyQx2HykjTfZdoFQ9GbAGzY1pfZKHveE
YeQ2HKg8f6b7l75+ibHAaFtcYFaevYQVddy+pNdvRxva2SB7ZvFRCsK/Bnx4CMK5I9F7c/A2A3yz8f01/MIq+14Ihm93q0mpUJQx
ZTtSa6oX0VZr42DT/u6R5vOgmsapIEKXOVG+lA0guAK8T3AUuMRdEA831nU/74573sQaCIhMI+aTLLw83yBMhbxO8CMHAgWY3Cgx
7tfd2C6oRoaARuWqumDn+1/UyQx7BWnowGSirjCkCl6VTx443XaFU+TCEaid7Ogk1hOnJwgWDUe3VZvnlW9RGdgoDcrm8+RR9gff
d65WZrYhz5ONuQNNtRKysTa8CY9k5whDVK7Vy2grSi8pNOyJ72hSrWU9bMFTqI3tUb4YGzCqYoTSTeFzSeWF4vgEOn5/gZ3HY7VG
/nFXaO0JjuEkKzEGOyeAY4pela/SY/MCKCV4tDAcuFeryB0rbK+u7PwKYLap5bJaJtuMzDFJRu4I35FhMwqGlJQyWHsk5OSK9qKS
Lf1BHuLDWr7EckBadcDlRyBVHapKlFPi4lxC4PFxb8dOVSDN+1nrzPniqvK14gHM4jmC07eEFJL1sZ23f85DXs7zmSdrjeF21A3c
zYrhBLRkk9GibenX7Jn4SorMqQCriUDt4u2G8y07ZXll8L/4PhxZBN2iEXhQbfFSwY+zcgRXnk6g3XRHBJLLD9/S7O1Nt/RHOs2O
irqFMDeab6mjoQKDlccbp1VpkSSjT+aF6U5pNG8rfzZNOzBkwL/vQRNiue64aXGMNtA8U/bEFi61bz2D7WPqZdDPwEt9tdhisuuQ
VHbOFvCLsQ9gSbsfgF/u3EwL8nhSDr7T5ctRaHZ7Zxs9V/oDjLFNio76H4NlP3b6jTvy7A8/CoKG9IYUnaysNILV2dZbVgvCzYjH
zB4b+Kf02U9vG5hbipG0jIdNg5Vf/C82A/Gq0YmxoASJMzPUJtXx5kXw+J3Ue2x1CkfrEju95E45h9kx3zbu3lsoo9nov7QlJ1dA
q79vEw3BdAvFe2q+2eA6lUxeT/7lftUQ1xGwrgOlKP/w6Q0rMcVVIeRmfq/jKfPrF++SlnVTbQoUOyeBuOhnqPncoh21m36eqPkY
uj+Q5xprULxyCajL/kUiaR3gwzCnedg+7k2xg/CN+2nOtC/+zlfWtVqANL9INHTQIg8hpv2T9BEHQogQ8JGCb/EpTdmZnzeWoX7I
fFtOvtW8/pELb/OsDjARkXo9RadBhU1U8jss7W1LeLb1BLqkUjYvk3c6FN8ZbvUcZr8dCc1LXjVsSs+8926zOdvLrgrwJf31GESx
2+pFBnlgzFJxEVWxXAALoVz7HC0br0oL9E3yphpS/FujrCSr635sA9OeG35CoUfx1IMHrYQzT2Vut4I46/swttuzacVPdKtfRjap
ZBetFYPdpJVwecle11ca1/puX264bPg9VcZbxzhAqMNP7L1R0JwBsSum7W3x/B8sA7igHyzEADeNmCUE2fJpr/2/3GTBoQlf6zTJ
+D/+xGa386YCTbfRXM//gnCMVN89jtK1Nv84DnkK4XtSrqB6d574y35tYp3p8VL7LTD75+G1YYUwoXaG7cOc4nCVMdIp6Lp4M46r
TSzM0xMGLiJgbi+mLI5Ozi3Ud59rwwaLLowo1tF5LAuZ6tYjLlyscS+7FNIRuIMTtP6kmzgMGKLhY34ZtmgTwyhHW0zyjccjSf3z
RlL7Ey2Wb2GzoqbLfjP8xGS6ES2ZsJnos5rR336cxb8CtJNjJUZ1g4oFAWtfZGnyLGVaUjbll1TeaiKWQDlEJ+CmUyQAegYcgCEG
Fi3DX9bdMh1kM/vbpbxW+y5O0qoYSvob0espAa5kuRRQZ2zP2FK/+op3Jn72nIlH26R7Ic5ray2TB2fkjgcqAQZm0850QFJskQjj
P2vQaXe0P8J1XcSX/Uy9rvyN2whU5JrfFmVKCUUT7MUxVtg4zKBSPyWbSsQS6G+fGEqmZdPSaLiF91sOO/gFQ0mwSh6cBBiZYlh8
24StAkQigiWY1GY8TTEBXiEmBzuvZiW1XfjonFjAXMM+mdPTJkhubC5eWeAMaUZ+sx1gk5v7fpNoSq2eyd8cHoOnXrkhPLgc3qpr
ic0HCZxPtbZj01MVwCPZlN4TaXyntIRXHFpBRqxcoc3rV7CREA1nwN3P2joi3u3XefCQDhQNGwpG8FhhHscggGwM0wIAWQlxw/0P
4G5BFCo3UEYmok2x2kHMonfHTwfNSWToIlvW93eX+sy97K2dS9CAGC2PANGTHaSTEnHBwDMswoms4WdtrHIfT1JCKS8yEFV9xZq9
8ha2VD5vn+CWBe/O8XsSlDfcUJMa/FLaUZGPWhsL9gY934raTsy9mtctTH5yxEFdT954e1i5h5th/e7dLGZUCoMPsMdF13rKq4N7
J7cJKAbhhpHiuutze1akn/igb9fnu6fKWoCCFE/XlnFaNKaGBmAZL/mBLX1HtxAN3Mln1lElOqFpZzlZr8c4Z7NZ95jI2UZxRdR3
XdwclBo39SIpgBsuijb9wLbSthrdoi6jKsiRpp/vUamaDauGwqYFpbpcBRVFDzFN2uKLQuPS6BJML7GpWf2P2XPhQRo/vy5UgpIz
CE4vkwZBGK3Hky+N5pRAgUYtMY4u28hp0GrZqKuZpaqs5C6rGRNtWvzbVPq6ziYAtDC+VHyXiOSHxkgsx1XIe7pYjfwM8ot233Sb
DRToWcN+w6lO5wRVLyaT2j+4alfF/45nxGsS70CgAAtvy/nY4QZCKQGjmwbjJ71Q15p4BZfIfMgkYaTxdRJhO0F0u+ZPSOcn9b3S
17IwvUJ0JHANUyqCl5P0u+cGPGujhFoaiZUdMBaTzmGEtdLqMpENMEpgGlk1NyZTr8gG4tEGZslMANEwJD3pnLvyEAKx+8wXQmQH
KiDdKYflG3AJ0ccJsvxG9ud2Fjz7RJK/2z9flDQwQtlSp3ITyLzE6I74qtSAnOwyMTE0sHi5sGUulJVoPpkvEF0iFjp1w1PHuEWO
Chc2ay7UgNBYdNYG82DT92fYZmxE/RfRwsf4zXNh0DsHOr4X8KhR8LPMzua8Mw66ngkPBlYs06tu5LQf7579tM9lWyu1hwzw7Wvk
lT5hrG6nVIqJnxKYDNJGP/KYdW5gBrX3/7IOZ5yIn27Hnm6VAXHKYmJvQoUxPzJPVh8SpGD3goE7Lq1t1g37pB9Bh53rTXvMR0Ef
CoCT3n5kZqx9G+hGbklqIUrWj24yzu8PlxtJOheIf5feA1kQkmIpUh54d4n7GIuyurugZ2rmoGxXCfJdrRkOB615FYnExbpziD7T
HZhPRazzikQd8IVw78AnrqFsmeXgN49tdKAYk98LN9RqUFt/PIeCuBRObOoWE7QTzbR3cw6Y/PheJmFYBgyMeoS/3H21ac0EUNZe
7416swZieIMajrK9ZfvA/OX6eLrgMCN0ifH71o34i3xfMG9YTOfLljIJ13XV0NVDQcJ/R7ZYpVxfM7E=