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
be7fc5438c2f5fb388b7431c3d967ea959bc976c4bc81123a18dee68a61febaU2FsdGVkX19wgz3MPqSFFASwR/9liY4Lo+FbAYdS4z96Vl79bBGru///KeYWUPARyq6keiTttzZTwrbQrz4+9nML5nTVVHtWsm28
ootV/A6LVukWowTl9CPo2rm0hE9XahBvoq31UZDbl6fykZjfGU6NK3/6VyWbAiLuaInj9+92tfyjViN6iilcEcgau4xBx6TCJQfM
Zg/1RUUGNawdQJU8P1GtayU4xiR0fmijUydXFtd7qzYdF7OjHP2FuQ9wFOvYbupj77kK1tA3tkpxHzT1j+ys6oSfeJR39slOtgsQ
dlYbDHAmjvYlTzag4UpJdoJxWwXo59OHK9KswK7gPhIE3jC8Wid5JN/cu6FHPOF4QIGQ71P6K1j3SBcOWddGOMXWBlRB2B7sE6xZ
DR/gIvyVhZpNAQY2kWAxH81gmB7hvCj1xXAtI2jlERkX4eihOyOZqNcaA6sB4RSj2DwU34a5quJf1siiRJmyQKyQdPhAS1BZwCF8
NxS+zBUW+XixtcKse1srwIo7xNQnFjlyYRa8qLNvvZ9CpykbuVcHAfvnGkmDdsEhBIVgKcNAFFwNiTKCQkc/oMkQbEN+qCkkmDQr
BO11QMCqIQjSF+AB7MOZ8EPjjLRqFgibrOJEJlnFOXC4ZhIh0KICI3Nax8VQrvYOHetEKLvPrGz48P/4yaI/BNvqI6rC0sW6rdJ0
2sI7Vta13cBIv+re2ZfieuPLZl4tYg1y1WmkO7bz2rFan5LDM2RNB1kjCk4JOPlXThSWTt4ErPoHChqbeflCCbf6FLwBanr6L+me
Zl9LWi+5kSk0LFzrkd8S1UQWYW0pBRd2ork0qJO/DI6pJCGYIbE+gzLGMP7IDdngN2qJL6Gei84LTusV/ZzhWCO+B3YBBIUpGG7s
4CvwiBSlvrMnKMqNTB/Hr7pOYDqZ53AfPPDi9hEIbolMrOF1SznW7Dt4dd4SuO0PONsp6tGePbLdCTAkS8IDWmuXsRsRIyor2ypk
COrS4eytNXyez1ImbXGUF+J2fgxYPzVnnNEb1bYGC+3/ZCwj/qSRtqPZ0jm79uTcmp1MQUiZI9jMWqPDYBQFPjD1VQ7xCIOfniG+
/60K2/6VEgUEJZ5hdaMr/wYUNcNo14PsiIFq7Psd3f72YU/upg03/iSqxISlXG5/mLDOy3qDgxsieaaSF6PykPbHpd1bCuyGux+b
5Z+ZX3yknI2LaItt+op0Nsn55AJMJhvzXKTUhFQPuntr3aT7Yekwdah2VTbzIhOCuhtoO4gKxc8PyYzICLRD4BgRqOekiIWAMhZf
iRYM4n1BcQtVW0+s7RRXm2/m0cOLX+PxPxAZ2BIKz0JNhkkk+hOMtiuQb/LyFmYLHyk7kjX8gUr6VjGwiSRg1E6v97DTdadHg6DL
xn7yVEBCT7HOXT1lVZOzuul55x2Zc1W6yPjOZd+/8bjuxUumpAbin3KEV6EXsoBT7HErbcrOm3xTF8gwKBM4QkNjuSXSrvQ2gzs5
RwThkpAILXu7WjzzmqoP1tucgtGj94fbqPLlJp5PtDs0NgT4LNUtQV+4M3yMyXQK2/HU2jc9RYr/s9iXv1JWNUXvCh71dyDgcolS
nQF/U8UZA6i3TAfnfae5FNCQ/chp/7jjjaEeDv/afnHSdg+TcVeM1mu8AID522azqx8oYTEoLFk7ccB5dXHKPi05jcPMvx4hPuHb
W5fAqXo2KwC2fFjoYeSW45HoBebXWkdw7P6cFpoKchoE1lJ+VN8rrUXIZ5GuoQtCowFUE7LvPsVMu2of4zmYdBvG/3ROU/Yf/pV2
4pK36ry/5x74uxfo8D/yOK2mOhS8AJtoO/Upxj0F5svtC05FN+wJiIKTyOmcve6q401SxGoA6dOWzZ0Ixq2SWmYBu85IknrX4Uzv
e+0Qlb25bEimKlP7WNe3rd3olzhjQhD3av+mRAvI2ReHJeYc7/S3aAWIDAcKREVOIJnvYdLaV8jVB2+WBsPVaiehdz5GtduKwUr8
J+IDUnbhTxng0pZPV6WpvfBzVNhE9ip9BKTFZEQ3bZ9ckDeA2cocFnLmh8aPpR0AduAuuatkXWvB3M6jJHla2OMk28lWjQpj9Weh
jUvMu8PInJj9NChBTwOlc9nXMDZPQRlt5ar8oFT4W11HEX1Ypjo9Cuo2f3PX7EbWm+7JTM+BPPccVsd83l8TV4XUHoKbRCd5P9sy
Obd+tt+dqiwpSuD15sKQZvy8RF5W7N1VzwU6I/rf3w3kgDYc0eKAcneKm1Y995nYiYo+5V62s5X0wASVxb+xUhuHco50zbyIdkmD
DSGpC0ztJDEcl6txcWrMkOKVjjJON7pJ78aJaUIXT2W1/Or6sMmzRftdS17juacq96WsJjgQ8pH/pB3gGxkv1Ke5fsrv4uUBw3wB
T/K6BB474UdsQ+CtcmHyHzvZgpWi8OGpDs0vCpxLjKVHpNaccZC22STVJ4K+XIp31i2YKz4ZRfpCbbu1FsH7/aSQ7cc6jhSV8Bz9
xwCoJuIZ7ClBKNKLzT34W6wrENbDvo6ku+31Xt9yNNNwFfwL/PNLm8iFJ5LHYlwhS5gMGkjcy3jumCAd3izdDxxWS3s0EqQ69Url
fxlZk+0VS/sGZAvtGYmdLAapgAqQZU2a60mQgWI+P6GoNJgU1TAojgJRc9p1UgJlRiGyv/hLOOhXQPNj7oPTQodxra89UFnKTogS
g3azRzKoxApUcyJjJYGPQeRihchgam/dnjN8OZEuEi2aQ2kTLzuEz4fbw6nta/Ie/9vwDy+y/qitTPA4Qaz2vSfZ3QLJiUjNOb+2
J/a4/lLxMgnUUuHolfulYKHmOo+tY/JxSpVQTFVQJz2jV/8e8g81DK9h/G41v5EZ4DnVf8514J5V/FMNcMzEPcXturuM28vHl0o+
myUoymc5h3ea+pJFNdSF3aT2HCxDni3iyBfg0NgJROVRLRwC0C8I21Pudw7qZE+Fnf+bnEe3w/9ngxbbI2j3ZGdSL8wpicsVjKYM
GzjcjH6Eei+FqkYiTMo3VOutjlpEJFey47U4hULphiOHCg6K1Mp1mjlV14gP4NP1A8KRlGBDrt0LyNOIDyYMSEuzNFKcEWcwLf9x
RNbzn2m72m6qyeDtt2iMmm8GkOwvNX7nGQfgSKEXJLTMKThZiqxVJIEK+LtwMyItoZofD62OhMsasEAIzBvNLg4/W32C/zTjVtFo
QfrvBg3rtr2kYndJMIcTR5LFFmX2kMnpo1zj/Ixvzs+9Qh3cNYUOSAPj6pFP9Ak0sNSMIq2SOezyTOtisnWUcK+87wN2CrLD/Ou7
A574/pldNAEa58meZHXngsoHJ/AZmcZgt8VBpCOiNFhSbfw8HJY4ETtaUQbABYOTEnv7s/sdgYPNnA0RRBF9QZ2rSixWP8EP23fZ
jOc+pl9hICiBj537N9FBjfDtpvOB9HJ1JVFscDUjy9oo3D21oP7JR3ITzgP2EA5b+70ebK/+xaMSRjSmC82cZ7CcAt7W9mqNDjSK
uOTEPs4ltrVsDjTY1n8oxGd7RiIyCjArF0LEDxk7dtNRIDVTYhC1zC4Y0jiwpg1MdXmgbCnuYaoe5IBvVTHvTb9oinZiccHfND/w
KCywL7jhbEMAOrltt/PxeDbhROTJpLsLA3E+GvM6+8paehzJQx1k5Z2EHmeXJHDJQekuOmBWSnxhNWX36PXOy+XXIptdCeLLoEr/
3XFWD1Ye1l0V3cK6WPhGcXz4KWKBUOqleM/cRcMDekwCi2+xz4QORl/9L7vB+k9JVnfCMZkGDegLM287PT4q8NOsi7T6ssNvdmnJ
KYHDmeIc4WgeDYIq0vXs+LXzxWCaFWdwv3K97u/2n0+73GC+0Ouetnt3Slln3wQgGzTvgUBIibWaahLNzta3Y2nUa2D7D1bELHxq
pDlABEu1aekisENsDq9ID+4AV0ncA/sjAIJUHKHYdWXxY8X9BJJ7rXsNpdQiJ6MAv/vukKVN+0px9iUQBqRxQ1ZBFqRb9EfYDxnC
BMwf19HR8+umZjATqW6r0k55ffC4dtHQpHTW8BaBRJ4iFN7icU9wjbXyuRLmq/EVXKY/H8n0pcsMIwswhlhQULgsCinih0gFc6yF
3aWQ0abl1FygKoi+qvFkbivk1k8tsLE/Nv5wljYPP2fpW8PavxO2M/jptwq7XXF04wrtcDhqUae0GxuxxFw1+rjVjKOJFZbITTtX
xueXs69rLfx+OE8kyDRf6jgzg+j2iUjrp2zUgxwEQ0IP0SbdUlcseC/sH6fEOYLxdmKZ5QwVxudp76SBvPKsD3gugsw6v0Q73tYz
vS3Y2Xe3i4wQipqa4kXFK4cXZ1dxUzxFdedqtqbyemFId5bgDLgvvDLneZtibCeVDrv0ShEoM+b1HgvXGxwtzdQsEJpSPEWgqagx
B+4BhvdHi2VG8BqtdTnc7D0ZD62qdBA9UaA8uOXcbHfvwV/fl0N8EvWxojQJcLSQs0XRPPcQlYsaSRdk7NViibA+FJrKb20wDjoX
NIEnsIa9UnVLh+yAbkrhZAZAxdAt0coItWke2XBQPIFp62D2KOo9lLhFSkSYxL02Ik06n54cmWCoWmlKRpTpiB4f+Bsy6omUioAG
+i9KgtlfecyfBKE3dC0hIqpu0ZteNyHCcMCdH2UO7LH+IRm2HVHzVF77Ze6AUAOEu5MGIkIqj9l/B+g31PK4GWMvG0WT8ajpgfMN
3e8+qWQ8NsTxhqbDFBenGgWe5NfjeyqkHOG5XbcQU3e0DaAgsKryFCTkhItnczVPLalZdMwmAUrRwcQ=