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+9ZyiNARQtJgLY0JT2LZdXX2zvy8GMbUIMt/GFor96kqh5M/HWYhCYfH3fhlj15RjXP17PMVK17crDp+0qwLjvhVyG
tJlqsH9RXNHe0qLZ11ar7TlNqWgit7uITfS/+SYx07eNH91DXLZoaEhielgVvs1jyGRzSECkcBU7jJ5JqYY98nyLaltuwsVJ1An6
TXsn69jyPyds0hYuxPxWeKzBHh4Emby7rjkvo7jOb0vTpESBZbVCdQKKVWouzyE+ZsSe41V6nM3LnQec92i4zv+6x5ZngvOQbSCQ
eiErzQ3JL2gPAJQcTfkjLybzeJ4xGlJ4O5m+tiCiIf4sf+Zvf02NgRlifwoZNcliPpfNAnTXGQT7HPP29a7I8j4K6e9xcm6oQAaH
6BC17IimQs+Y8SWXjv8L+bI50cghnDKBz8d309XVeiZwPug47drc+oeJOgkN1qQKMlxbQprxyAoyY+wodF9TwpmOxmH4wulET00J
LKQJHwG9YJU+WeX2+fvdIbHP5/LjZ5El0I1Nc6btvMGI2WeAoU82A/rz3X9y/NfHgKxZjqK1ttolHs/E4IfE40i3Dd9tI6l/CHG6
YckmuHhlZMlg0HDqRG+cZUGKRUjqw7WPUXSi5MqYj9dl7rz+vkXyYjGiYpBecSpduZYuHWRgsv3MQhxVvu8Qrd4dhH4tgNBZt7Z7
vdEN/WzEFGkdjm6raRwRrf+EqNxpPTDXT/XEFXAFbqphN/Ji0+ql+iIThBioCqERuFkYIpGUpA4pqLhOYQ+DiSZh23OXR5PrzmXH
9pltPjfSBR7OKKkleg8iNBQ1Rk5B00fzV3sTTkhndEN+keiU73C8NSVlTzpv56h75V8WCKhhhLnhObThNSCASj0TzwmOAy41RfMn
eWYLT36jhO21nDf+qu8piXhjOMwliYxhZabD0CLVvjpjMYvFe4k51jLvFJxdwXHIHL/b3+g+TjDSQ3XNj45YmqudJjpty8nE76eL
1RPTP8JO4NyUlvku2ADcWX36NOgVawBY4zf3hg9p25x6xnFeLnmep7FqkE85PZZO22UmeLCgSqTGBQ0nd2nLD+3abNpdP1o8Z1RW
wNrhxfnZ6uFJciDgbWjWsT7MmakCbyr9idxqmqcrDGaBF3jKmgWMHhipQPm8KMM5JuSNphQjJXkVRXXmfI1iY3FUeQlrrqLXGOn9
kLvphudWCDMSS59VsYTyV0JP5Ocaya3uKMJf4tOh/o337ZObCW0PGTx8oJohJmBxg2gG2/QYhs1Mbs7OqHoQNeDh7S+17p1w6KmH
DofGwRBbuCxWuhKE+QLE9glMl3xSeBJIG3vD+N8vl1Q0ZNOx9+WyUbgAWsG95wD3NQwX6AmoR/BFPTfYtv0ALq+uTJiBGJJTlADC
iUqkH7f9eC3sVmQAVhGj89huBmjG1loSP8lQqp+scYOSGF/mMw+6ByTk9DzEd3Kp9mGCPJ4ByqXtpAMI5OuA70PYcd+qrWOfCoLW
JsZoAbP5dsqLFHacQFXbNuI3FtpDRJJVdtGMPxp/VY/p4dIlGoNSWdxjrjd6PEp9tnXDdq5hgdRgVxsmN1QwSEavPAtrjV4r+Hi0
xQLYNWlY83mdnC1bTM6JklFqOv62bQKyuqrJqDURm3x53mOGHisY2vMKd+l61z8zSNOx8qxTaS7NBgLFce2VXI3MGXYLbwcRv0ly
nTE3VJtOMJHuP7df9f6ilHJuPmI794byIhlubNNd8DczYuvrp6RJBVPsBHESLEkBQLkILeHs9og3VK+sE+STmG2jhqWgzS8iByVu
EYFcMaJQnSmpDs79Ye1QF/X2cR2T7xem3kZ7YuRrhvYqCtv63WeaTn4jMoQnuN9hCXVB6ca/I8uJeBVLMHsiPRnyfzKwHEDZb32l
bH0chl9IEbskjr18j86eDaN/1Ws7cd+6s2/ymFVA2sp9tbSPY39rd/HriBib5eu5JxVkxPMPvhS080TSK4bENwqLpAan7DcCr0Sw
f5dL8snnQNXAyo9ugcHuaLcl2wtfSZeX+RtDVfw0Kdd62XH48krWXFgfxlS1gBMYqDFtAa5bBMv9dkttInqej679v7v3lIswmjaG
1v3zm50NW4n8BH9OBKb99nJ+c9CwQiNreBA/vY37SouHSR/Ndgu1jcPLu+Wynfpb17vX6WF/aUDTRooLBKCD29P/KZqPe6iGd09r
pmLnZGtTfHY0u/ErF/N12nJkV+/5Je/06E3Ka4HNj6pRk8P1k5TU9LK/VLlmtScgrAAxSX9Yg0gX6goQoaXCaPjTofN4UJDzc4Ff
YloQeeGKbas0Td31dtnPSYE9f9J5ie1sPxLqRgyfvZfD2q//EEpOL+ueCTqJup7rsSpJy4sUvyg+PsXbFKcXT2ihwMOkkgPrUGpr
6Q58gDlMODaYY6rOepg+qsfO0GI1C3czbZXlD3M6hr1zRmjWZ+L4iy8Kykd+YhZCKYo01Alpqg0eqSvpEAWD06S+WyHzkQNniUsv
V4RVuYGmxmUnPPaCv0j+DyJFxY6fJmrMPmgm+tomjkiRZKtluhGFRHR97pFmUQD3FvL44GDJCTSBcUvDxCEIL8ZAQEoy4xmiI6Dz
J89UK3M2NWTbw8cfge5r5+01TlS0/VRqAuIhx2gU8Rgma8mr7gAnkwgsGpu1l1ny3G6FbKdn1eSLaBzAJx+cBqlkHgAYNQ/jh0X3
1o6ShqHb3XJjW0fzRPqi9TJ7STWOpyPG2rgn8KEY1N+1NWKEZlPCDhgtXfXk1OrBIwd9V2MDuglYryCDyrQkHU/3lNNF8rts8WRL
/9QDC7oVVdHgmuc9WV5Scwdn+nHI+qQWfOULoQz7mSxyGDubwuiJB95/K6DZXZ2biOECOyA9kS+rUWtQUoBP7CHJlaE7u+fdCOxT
Le2BgTYnm9pjnMvGd6QYHdu2sAcm9D2RHQJ5Kr5nIXEovPH8/y7vo9WhqIZEB0RZdOdnVG27+f5e0p4R2LbBP5V9XRtks0q9G3vq
h83g761qhF8b/Ok6Gc/hRqZ5iiOgxnGZFvltD0r22M41KODgREkoPZFUl5/+4NINeIUX5XelGb0YpTqneKjUzkYCgnJog/UFek3b
EWBhdr0S+ITXRF7rx2y0Q6MbNAZG+rqEPzXLxKSoffHgYDZUESy7fH/UBget7GlYDl72EiNdkr5kXR3lfYZJSv88mHE596qhrxYR
CVbjG2e+seVHeCZZdGZsvzJCO1kbEt1n3eeijR3kJV9ERfEPesMV8qDrbcOkfFG5Kjw6YetMgIGS5qhKfm8IJOfGukevVJFT5kwZ
If4jCM9kPe4gBFfUAMvSoOWLGar3+seTTxYQGiM3AMPQiFsCYbduQ/wIkLRw7+d5ibdsOxT4IqLlWkj4fMnmB8R0C3KaVArCrICX
ninkTT54zsHgX6keQz3QRnNvVP/QeVx7lVLtgB4CJ5mCA/gf/B2b1f4Jnl20RqScoybg/B14h0kNVwLaAWG1aJ5kzFwTJiMWblqQ
4Mb4mRMYgkIvPKdz2F5LVzNZuBYkwW8oeBPA3kV3d1G/heEp+NZa2bb29CR7LUUrmt70dhNI3kB5TtvmXa0nAMg53yQssN2Wm6DV
Xt8z3eXvS7rEUq1ZfSVVWZlYUPcjTOsdhXmaEaBYoisWfihEm/F3CCJISJHLak5QuchaBOXpd2YbBKgqNWDoR5FvqonSChuvOTuc
EcUnPB46g4Fc5+6MYz2Ms0lgc29eDB5iR5QXcHlNO1x+AMEUamqQYjan4DSzwrRuhafJnyjiXpfghRIluUhhYKEAHZ8vDI8z6yg+
12wxEC+acdCuGNl32q+WbecXcbQnU2pqbpgqRCta6F3OU2ZuqCyuvU45RWVvZsf53hHY9dOsIzQAaFtMY/gijPuMXu8tQV7jiBH1
L9o+EtqWjhKCuMoSn2zysESihBfQBv2zzM6DbwcO7ePYGf+0uniiOGZ9WX0AUeXuvTGZ27odX+gxHgRy2zT5Bf9kQfKdLZepSIo0
AtinXiJfiakivcK9J0/dulIo9nYbeyw56UngsdZDEAyXK7IomeaNuLg/onA26VSZnWh5kpzfUkW55pq6P2w0Io3eFbgT0eCdKXgR
geiiFI+v+EYNFXhBo+7I/3H/LJZ0wId16Y2WpDed9C0LjeFF6uesIUcqESZhWJ8r6PvohoBUXwYPusWXPrSHH6y7btFb4S1H3L0p
k7XRXjmfXhnyVJZ/JqDLLIb3np6rChBK/3YIiHWOcS10bw/FklTxMbbZMPDB8soyEcvjE0c176Gaeev37CynZd8Lib7TkTAb2rGe
8fufQCQ7QuFvlxRYXI1Dc91WGuHdbS+XVVUZvAUhd7J/OK+7ltqOVQqKfpw8jNHwsXGikN7x0c8ANwjM+4iEvjvbEPQ20RK7OsYx
VXAy45GRj35yNCidibr4eKfQldMFU3MloNgSOm8TXuO5GSnGPKSysGy0rF5E3vlGdxY+8uPFk4uZjQ4Njo1EjVxDaV9PehGRPU1M
50sFvtV5FWJSw6IkIIn/5kfE57BpcS8xnPIHa9626NSBxopm4aPkkqtAwkI3DHy9iz4Dtz+e60ULmsxlepY0MJQe86MUCQGSWqdq
nmVtO9PJshfmwyA26XwwQXq5ZFm0A0SrOuYVA5UgMCMrrJ12HdJpta6ND69REy79Ytm/8G798qja314GDX7eRtusqZYYth0/IOv6
Z9joZhr6WLE2EAzAhALYLUre4uigQiy6/SyYqGB5GQt9pIV4SybdoI6QMg+K0QIIOSN0nMEdDkw1Jlcc77svdp9pK3iBXSlC6K2J
ZFdPsPwr5p5Y9q63JJxLzcENPlpUmPxf5+CRrglzMbA=