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/lIwFPLHZEPXmWbRQChNOIkjAqqlpOuqtfX/gwP3eax8Y2cgoPXhKyyAcI46LRHIarmfYEA7KIK74di/hf/IKRExQu
95lBOAASoRz9+CRyNgtS4Z5WBLlINOcHFgGoASzM4buCgd2SKgwiHQYnU2Kx+iCZ+BcWkaBTEVLUWXHvk5Hwz3GywoupTh2jM/zK
BuBD9Ar8qr640j/6Bv0Sit7tvJZH2X8ZZtdexpKOMrQ8/t/OIE03xhLN6/86IdVR8iMVuMwRw2cqoKII5xHVg1gz0gAStd16HI7W
ZPGPiBkwCsu09AdWXThKsmzKntdWRjslKlMhm5vzd60EeagzBjGKzhDf9B2HVt12ID02FKj9VOK70SvThJeUyqnOVoo4xcpg5pCj
p0W+Mx5KXj5kPCvWm57Dav6xq8a75q8l+X2bXQZcqtYo+MiGYGWNVLo4mdWSZYgJmCnGwIJcUWeeKCeFtvf4PvD2a06J/pWY3rkk
Win42GOrAqeT1ru6MAgDmIuvJBdXpEstX2Dr/p0+Iz649VupkFObbs3RhCHPVMWyjWHOu2NoxCSvPAbxpm9dVH4Fz7lhCd5am6qV
BroU5myo+132hSBzkBKtUs6P7hCY/PdeDbSl0Nb8RyastrWlFY4WP/Sgr3pbnNTjU3i1O4MX/qG2v9T/x2ipGwXdI27NOtObjMFb
hAV/mo1k4n3mLLXjtBRDMtVCccwh/eb3KiD7f3mzvLRZ/R40ifTiW/R/qSfTibIQoZvlhoQDuxrU72ToTvfslxNL0VLRAnibzSLP
ePRuREtjsLyg9wyDq5pYYyO5tiir7QYHzaE/OEmzudGlWXb4n6f1ELGeiqIY7vd/GDfPhXMHj+C40f05ZRd4FhYAvFmE0jUqyr4F
Bv1CJAwJWOrxU5EzHLSOmV1OYtUR11DRuDvawib4mbMuuTc2eGyBydItG2qQMyWEGUG2gBk4XvxZ0FJa9+Bx2mEn6WtcfJgkw/E5
VtCAeieMf3RJwrqVDNvRM2WYlKR8EWAjfEhjj9xYWWeNqLWspuT/Swga1dkZTBTVfn9w1kpcY+/QdQq12KFm+BjyoFDyw1ue5zjr
ZuWweVucOqgQzngM6luPut8G2YSk6z8Lhlfwt7j5ThHlYhKGOTpUE5DQhKD0GJ3jBSRPUfTA9X7oLwXWdjfvsVriP3F5ESTrgY+q
iYKMSgfSNtYZ82nzOMzaCDxtdeKEq1J9I1F/urzodpqFN5gJ5Rg7BoKn1TEW7bAMEP2UiCYgjWNUIsXGy+mQIz+FYgGUGua/VlGG
TuyZFuVHJaF6z5e8H+XvD7SF6jmaEnI3VQTLBXFYBHR3ylRrUHhiC5ucFQqJnGFvvpiVkjrttFL/cxnOk889KzNCP9cGBSM6laM3
WfJ/xodRQcL6qfMdtJW9au0uSakiw7+J5QoEmFwFLhjPMhGovZ/SYp4WL0CeHyzApiVZwG7OlyeqCvCRETDTc9w/9a9lyiNZBA7V
VayNJUwgW25t8gnH804y5DJKI/Psbtbx8cD6iVQTajX5XTms0T5r9NZd1JuJj2wb16E7TurkxS+0uIs1GpVB8ZB3iP6zOaXZo0k6
9p86g4ii+319vvDp9TjC8luGOUa0Qs/Deq7ZRdZOFsD1VUidrXvlQ5y7qC98NIZyjDXHQSBq/htJcH0X92eGMJwh3VsmIJO6yswB
mzgZ90YtoG2+4P/U80yKhzCi7VKbx++7fHoULFxt/3Ioy6xq23JWNfQ/D2JUkaNsIJQqpmc1VMFat6a9dGEdIFS6qIobsBhTBfq6
RqBFNq7jnv/M3dU9EHx+e4g8+m8vB9e/FhzNolvvSPdPlgknV2pxtcL6G+Baqdfxd9WvwYg4q4RyHNVUzQF+CEL8KEC2O5OZ6zMK
galO4CRfneOeCkX1AHrdF+NxP8VpJ9xaR1i9tSBGRI1DQ56HwLHfqZX5OorFpp2ET4J1OSoMXrPTvZxM0ZjNdwKV3pbSv/YfUPP+
Zd5t5Ie7B2CvGxJOIfeN5Ike5NYCCAIVVh/vbL4u/HqeAariYLfZVIue+Ja77dafvxFa5dLgfDXTUI25zrUbDj5Em3ANWB0idUek
gs+8wtRctCw5RVMpT0O5rlexzB9TADMiy+d7KSqkJJG5D0SnVqJckogByjKTQ/EF/Mb9tA0LlqpMXe+YlGaxPxz6RrsEV+k0YHiy
92JNkv0LU7oDaPsBOPPd/ZIfYAbLcAP5rs/DG9PZxOXnZovalCZmd5opGhj5DQgPrmaXwnsnjqmIihgNdDRFeLFPZAtp70Fjfmtk
UbNmOBM/To9NY2zFmcjKNwWgGYiueQzLVNa4Nz6r758Dv77sDeJaklEsoouXMVpi/T283un1422o4vqk5fDD6XZolB8rUT4vDO2D
9WmPBVcr+O/KHBfcbJcJyiga9WtxYqxbeRPGzR3gNyYdxxaGapBNMqkwU1MqDOIS/6IPGD1kqff1yP6zBTh2mLI2WaXOUOAgNdlF
YvpXNEMZyPQrEf4doCFSq66ldQsDX9DugeTu7FUbY49g4RrPGECR7SNza5KWY5yX/ypowXpgr9DpqVBpCrLd4XZEzighxi7e5DTX
bYhZvkk9PCAQL4fpNGUIbrVzkO8lwpsOLjBwczlwRdqxYXAMMBL9v5k1n66dOBcrFlNBGKWcVatO1DA/aeORQRYLPH13KJKIQTVN
b1KgpibsGpd3yHORMIQe85fBS/7UgMDkW4W1nQjK823OWZH4wz5gBSzSyzIXht2TlriUVpW9i2I9fqXcte5tiztP4/lM6ynfoM5Q
tpSdQRSyh+KBxCZEeBe4SxQDKZrjQTCZsYYWrBjuKtShIJ+NAP8wozV6gf54g4Jack6RsU4AB3co7WVmmq82rMJYs9VdeJoJAT/j
QYq+X7YkJXvAVUZCOml/fjIdFR3wnwsgc8mr/xcTp1TetrhugD1HMtHJeKZXmD20oTgHusV3cL/UqOGPuBYSWxmYeU09kLr/HtZM
FsWLI9cZabIQTh6aV2L0mYz3g9TCTZ9/N1WseEN8/IVZPSir0y6staBWyaLSGEtEcKSjwPOVedwIwPAJ/uY5t6mCYcBhapd04Won
vWkNBDd/pZokGXtNVMdWYTmCoU7xsQXpar1AtEcGHxss8IOpVp13vp3iQsT/ikgw9DIFwiQJvxIy7XmHoeJ82oaXWaJbnEXfoe8O
vSSDn1/1EieYrZgDhorDhzC85XMN/a42oiDMt6xV4SZV69x8jliQ+Oz+7kDgqngHMIBobU4U9/ILvIpCOkddFQQ0Ko7FKs/hT0C5
Lqt/m9BSvLsfD9x/FRrB9MFv5eHW5w2oVO0osgJDjBLHD5cA10ur7S+U73xuH2mdiKpTC48ct51cy+EQ0+RHSMp49sguzcZ6JLbi
NTr4YMJ6z3YDUkDXQdV5d1G/jCSDgS2hyDsqhR3etnHmzoYSswwLmI5qnxCikD8rMuV7diaeB58uLIBPpUcvI2eVK9LzTfR75QgK
I3gvHxKepCRaMH4F7/OpknF6kdRY8TGo2YnEId8wgyh4al2dxsAJ2wh7TOuL4UKHdESymhLsHBEvWUbamxU+Ol8APMYXYrERbE+w
FkcRuiGcIOqo4qnA9owClcEDJ8eD8FWJPgF+H/7RtbkvyIRnZkyF2qBsP2PoyYz4lnQH7aVUWkwrjgDtfhI7RNlBiRJeeqFVDcSs
7cps94dRxESNTXFEmSOrYhLS4wnxdbYIYm2I0GS4aBkQ0a2zIKVelxa1F2v1xcreLAcZ0TiT1wWSVQZ86r0PBGoliX5ojtdnv3lB
8tP4T7XDMl7SYcF1Ejqe/rTKelY8ZCrXlmINURS23NGYR6/LQvDQZDuDv034QNNuC1zeUu/N+e0oDVwqFc6eJFuGDsUJAJ6DF241
gap5XVLy10hZWlUnxYlIrkzSjfJdITMWj7irtzv76n84bft4JJDegdQgR0kFdyXOy6+CdLl3NSn/OA57yNmIye4mUL27VvdIEKS6
TRaYoYNXLIW3TGZzjAogsXCuP5OVHRfDItUAhAjU7mZ8/rKWAG5jEZr9YCex6mkDVlsP5xDNGgwTFNoHP6S65OqlO0UzqMuKvnln
sRC9XdJCyYB4j8/CZffcVo88XrSKsilWiYGgVmkOTWgfmCTZ5U7MnzCZiFTndWp4UD4BfcaHT+U9DB82wOaWgyLA6jblv/g+AAPu
F62R8CqdQa1yIl5pN6b9uvBfn/NsN3AUyIWdwh5h58gTyC0PofH9DICl1dLnkDIUtTc1jmKIMU+8c4LXtJ5KCtRhOW/+dKh1MloO
37RpupOBxYPU/yxiJQglvWFI6Rsoak5qHbrc1jkfUbRJxr9SSIW4DYtlDDUKO6u04p7DF2+t5APYWCVOe5K7eDRqvgC3ix6ebHDm
L5klTctzL/ec78u4flCMoc6xTmGqiBh6USz2RBLyXiY8zoG8DCwFOY4CVMBF+2vTa2rwwfS8ydyQs6ocFO6J+rW3iNfyGqIYrejD
ENfK4z5PfnLGezsUsDrB1h8DEGjQALFx02CR8/HDX7SbewNLoHpSXQxSKbGG0p5+1WaRHXP5vrjkHUIXjoF9g9ftweXochQCmz16
QkJOInbCFx4tYOZjgGfkUWWeHCMCPZGYEiIhB0HzVlmIMRoPcK55hNRkJYUTImOhF//FVehvW6tPUIzLCyyAF+Z8+3OXDcyn0dd0
29idNuO+wyiNI1iaOG/uYAWzJISGgc3NarUgemxzgWw3baLUWsxKb7ETCu1j7rp0Vv9PlfRCslPEIF7hybUztG/hU8ANeexpQ3Lj
ysKdgb6cAWxWtqGWMOC24XPHDSrINlhxDz1qFA5gILc=