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
be7fc5438c2f5fb388b7431c3d967ea959bc976c4bc81123a18dee68a61febaU2FsdGVkX19nz0Ff7l9yKBcHg0Ul2GHndk0J2OGSGgwpd//cWvJqLkp02mrvTQCvOqjP6gRV1/vcRNm63B5/sGp910A1rs4CFTPM
jrZ3xPHa/Q3lL/CHBB0RVpEGWOkd3CHvl9V6FFpP2pFoS3y1ViXa9kCLjhAP589ht73LPaVqx3mjrrXGm9jlyfx3Xq8Sa1EHgryD
kKkgX0LIlzKMTy9HrFZaYie1RX+ELLv6IpRrGMxR8vA43mOgmbX0cTZHEV7hH4sfqVxFftJU6SRvFH+nqikjA8wXnbxdkFcWK+yr
75Ehk9IQLvmheO6OsmLccxoDLs+VsD55YwfqpXl+aEE9+B+E2EQgw9XBLYzs16t/K0UobEm9KaKya3Ze0Ei9cfsCL9Dlw6ek//H7
77gdyvl35+fePeL2qrhvobldFbOylBCoqal2m3ZDFSnPMCA+T4MdcLwjCYzO4keaOG4E/KVgg86gSeWDNX9f9c0bzva1jzHBK3Cv
KoA7H1XT4HIVuMPWMuxMm6vVpHUy84DOwjNO3I9SyPNnIMYQYdOMUriJl3hAlgGIF4cWBoaZjNQTd1ZoPgwJmM0gWh5gHB0AuUqS
91B8D9Cf1Q2sd0rl/0embc/tpMzAxIqDaKAnrReHK9mLXK2imi0LJ9RoHmufU9+jcudkVSZnm/usOSzCLJqaHzV0ziQn+M6rqzdJ
PInmOWMow1E9+UG2AcPjenT098JbOD1AbK9jWBIwLp0Bi7KnTiEKNF4qEre65Fc7sey81wx1cLjC9JqOafxQT0uOcm58dro/G5yV
O5s11PKo8tnGz49WStkkRkJcr0AxwBFZBARxfYwc6J0l2nYwBR3vn40wX6KC6BQQpGaNGLwfAwzgpqNs8bsYfujToEle0R0K83zE
rOFb34p2v2uvLceEPhsqRhRwPFCnj9wMaj1WatYukee0dSKwUCyd1QqN9xbRXXSQafeQF332d2+7Njvwh3yhiroZiONBCYYU+ZJI
mgXjcHvI2c6SYuCArVWIAu6beikJwRML86a5lzVDksc9gho1ViUjxJv5ge4xqnmepnxiq8kEmV/VhG1f8VqjOyyvNO9eS+89/GS/
2dbEkj+5fpGA1iyeb/vjy0FTEMHqBAAMo8ulFFC+c8WcVOpznpxjt3hdhumOaAkzxxv+QUI0Qo6ve8x0QTeX0O3av21vMttbK/kQ
1JZVU3GXHs4rYvEaIpfk0iO38XN8L9a8vKH3058osoweY4YHUBI8Xan/BDvQHoSRfUPwkqeuXfapswQA/Qw56epsyNPOQJrfe+2w
2BhRswoQtz0hAkD8grYRwnZkc6DM13aKVVPQblo0B83BG8TK53uwfdZpduZmg59aEhvGwScpUnGd41R2kH4VYOPxFzzX6Q+CsbmC
0amibamo9y4/rgzUy4mMK1atGWc1wlK99G9yD6+MXuyUhu0T6zFkXmM5pE0z+cM5VOxSXx4eSYZLDZw5UhEvmTV36UxaghI0+cTc
J3SWBVbtIdnaYF5A/4KTpGIi7XqL3x85IZwW8UYpyTF+0AvtKZhtqKVkLaN9CFLtmxKFMGrN88rvRHr/+m/7syT4D4olUC1+5+ft
BEopsQlWmKv48uFD/O6ICOGTE8lTM/ziRl0HGZ3vZqtA1J+euMhTzh5Bzmz4KlPG+tcl6lXcBUXtQP920LRRkTgdGoXbEFnDvgGN
iO8nCYXiaQnX3hbaG5Syn0OdlfeXZ1LffUjK/fy+MZCuQPO3xUp/oriRs6g/OSEVPGqrApIlQj6A3tUy91oLmkMn06NKo4pHozf6
tGWoeGIZfrzUZ7dof5zBwOs0rZktyTDCIxfIpQffO3uq8+Db36LQPwZ31tvmCI43EMFkCo8eKPr9m4dob/kMCaZQLQc96iZvFuEq
rTp8NTTTF5E+XgdCyMDuyQYSZvu12h9D+6SgMZNUu/WWTZEM7IJv+b2W1VP/l0rxkZlChyicwa+PrfqBdjhQ8+Za3hxMblPb09r8
Ax5FFrxf9MnH5F4ZN9Nbwq1MNzZK2AK2YfMQ1BRRglK3jRnh18MfUuyJMEI1qme48PoK+7rp4oY0VJB+gLNei60A1y+2U6bhFf3o
PPoqnibHWMHZwSVxvu1aErSag/LaBZ1X2+orgk3oQVD37knBPJ8gHKBr3JhlYR+bmcIT7I2hWWsHBV+2TSr4GwPuz2dCq2tUasu4
U9UiRNCo8OdwCS7VpE0pgT+y15ZlsLNCns1br3KaiqKVT/M5kWkSYP/Vc/K3GsNy6a1ch87hi3QAwTo2uQk+l5gBJ5G0odK9lYP8
k+c9gWGS/L2PGBxnShyShDEEX257nrUnGUHZn2bNvjPtcAnZV09XDmKwDxAelGhaR/yet87bwFJqnacd2fSNcaNpRCOuen4TTpC1
KlhksSFIu6PV/bnCbrQ6a1SzrfSi/oGw+S+31IjYTI8OE0Oev/juY8bRoBOprAzAgOFyQCZU+G4FihndLvJE83Bu3VxW8Xcpi9W5
a86jW5bwb9IrqNd468IOZ8waV6JTeQWhDvuwucpbiIJjaN+qvlZx0NEm5tHnYTYHPdYWG97yXVW7AVi8hrX7Ni9+GhlyfYAsu4Hd
7BD1aRFBUAq8hdSiZveTUDLRJ1Xw5J6Zv5TqY2LEayKlHHzpDevLwfNeVFRWN1bqIqMF+V7Rg3MGhEeQziNyTC0rfgqi+KEDaXpJ
yAbxBLSL9H5TJ4o7vBdx4bmmv9Np9pHaBYGwBnLPPuOuHzFJdFDWZ03p0RtxyZStJ/r/77EbH7W3TgqMgJSma2o+/FemNrckfuGF
9YvCn1mPF6EYowLnFbfdufoSxJdUXAD/1Ko6jhou1U4ICRRKnbjdJXJ4c7Zr8nlEwLGi7EnKHiI1HkYAjV0cR169ljnrjSoSi6hY
BhOfbb9R13+QS/SGd2TQKKWeAC3Nop9inngw4O7NUPXYx61b62xLz46FkSEPNMq3FcvjmDUrS/koyXeGdmnQTJ8q+ng0HpEfMQcg
QA2LKFtfbuoBvjwwVVMQRefHi3q0otc3sxmu34TmMJzczcU2dxI/xIYGfzH7Dr+m4RbqVzTNGOL/mQA7VQf61W46nMB99CyUnSMc
BNiRg6nc0abJ0mn4e4IPOTT7g/sCajYkxf/pgpQR0STgfnvw71rQ3ya6ixsOoC9H4S1s0g4TtIpV/uPinymfuSBohfLfQs/bX9FP
AuS1W9+yhMywY+SsnF+GtzE2qEBRlTUT89F0IdHsrJOJ5w0BWvNjR4PE2+hD8E0n2H8jgEZ36u1zbxSlIeQPJhkOkG3iVJltHLeY
QkrZhV5HCo4HaBecXkQ8tnoJ7pMBYX6sQkbx+M5OCiihunGThO5eY1D0UXoFh49qbiyJtQmgN2H0YAW98J+DzvHJRz1YECVuR1XY
92/c8cm9WKQrSXcjtlAo+GSRNPJvjd5T9xFZF3ipS53GmpCUgfoX5J6tGGf62IWyHORJ2lbmuFLVHKn2ZRgYT+LsR/ADWrbnyE8y
hzot7b9nv0RqN1hY2m9+LdB01Y3Al0skz8gjy2IZXwTtCNetLHKdDdxQQw44QXyPyUU9D784uGAgBUEztOBF91/1l/x5lttvVAge
47mC5Ql1ajrP+MhaXsra+H50PpAGX/KCD+S7z4va/zMdcuDKGWC5enGNgIislFNMNDDj/QEsfP9kljArctcChMz3sattwQJimYSw
b3IbWjoKEDgKvZrDHeAxb3mQD9WA9ORnw7oqtmXjnL2NukDCkl6Rvhfw3A/xRYoPJbaxN0Nbzjh/vzYf90ZSvtXnFkoB6A7aGCfz
kJfd28RkZc+YKD2c8opqFLlT3K18v45uaU9y3ai5UtB9yMqoPxtzLCnN51aLTbZzvuHo3MRuSwyia6jiw86n0/jqsXz40GCw+zHu
4skwPpggZgGMtvhm/D+6tAUSX9REYsFIqdVMh2+45mlw4noQkvyPumenzcel98dVEZEVMvnr9PxpIctGcAyCLTVgLWczWz19ns3V
yTZxJkFMNBMci7ukS0KzkNYKE19eVpAqtrc5OR5Z5zjTcvc2tVKF8xAdDBlClO66ZDV4Jogc0reKNvmFHSrIwfH8H6Y2CGBkAliF
zUqpGLKmOPZvTXDevyn8Fkf5ytrAjtpe4FJnDXH0sjVVxAirMhw8kC//SxbzsEK5RF9Z+ovu4PWGpcOu+0Voiuq5EL76rpHOAwZF
Xhyc739nuTnfztWfBzXo12ddbPRTppgwr6uydRAa+8nFVPodxAUwVAGxzfRrXnQaOXm/YAhFvwfpVZHohju46MszCowYCwKaggZQ
apUvdjEkDYLZy4JC91k6yb7Ei5kt1rfR6HhTCIzBe+Xby6QHlJ8bF2ZUkW+L7X+RfPCKB7rEdQdw3Zjr4erd27qji2HyvYhotXa9
e/ACUFKOJzKRjT3xl5Xcgm5GqPDwLHohO7r/DvLyXGHafmScdodPEQKmn6ayR74hF/nXHq0ggQ+xmjSyUPRHyITvuapIzkR20D1V
zRuR83JKW0TtM4ZX06uC5ieN0V01E2bIwmkOK3T/W9gLyeSjYXIZTVil6ekBhXxV9BAWLbSIhFzL/ZMl3HAQ+0zrHkYeNFvmmM/V
iyLWZPGEV+AbISh42xiFCEvs+mqibMlotwP1I/LXFam3zWBydNM2HlWyRq1ePA6kfo7rpGLxkMVmm+KtL3dF41CC7XnUmoEgzDkJ
1RzUzK3OI0haPU/2mXRo6Vrzwz5vz11CrwlGLEs5xT2OJgaY5B5myRxENU5z5I54z+HVkfs2vHVq5Ac=