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+X9DFDMP75iHq00FGi/5Po4XvTMfXxa6BPb05vsNB0f5myjvRe1Z8djJj1/jW8c8GcqqgvIagwARlj+2RmW9ZZ84aL
dBmOKSPtfJ3+ByRTk7mZ6Gybh2ojrdTDLfjX4Ffd6hsaykPgxndLW2Y6cQqYhH0mw9lhsa7x51yN2pnRmwV1nMC+dVzY1HUPBgkc
ar6vRKqioK+JdyPg/IDY0oPK0QE+vpujo5Q8sayVrqNIldfMC/1fFGcfF/Y9AxAYoXuq14+KU7mo/cIsgaidIoDn6g4yP+CNYbMg
AGggCzHHftz6ST7pf9A1bTJIaHml+FrO1K+mSm7Xu2Q6J7LAt1V6W4uLM5kw+6SKzrdY+esPMDTca4tzgVRUCO28mf1hZenWH4o9
f0x2f/68QH706L3C/S/hfSJv/+1o8nLMfyWfmHDR23Hb4xTFzGhHQQY+vZjyCW0vmhAEMgoLa8ngOorKF7OWyrnU1SepTGRFJcOG
IDxz38tj3yPnw0CjT2BsmSKAyZhv4sRTazPELciCRdoaglauWO83cAIJN2uG+vCpfzePluDavCJOHK9Ky/orTqPpT1yUSUJ2/eQy
0miGeuUrAoaBFItFH6NEvodOwptOsQ3025eV4WE8IsF2sZcvbpjIys7b+0HJ+oGjy2ki5UAYGPz09NLwaaFDCBPLMbzOuDVw6FDV
0wPjAMa6akWGauPQgcncmIjv4/MvDrmck65PBYbggwy1qoWta4gDaO87LwfjxGZXVzWCCGRKLzjTiautxZAlzNGESpf1doAunUos
keexuLtcd3TDA826lw6hz1LH4Z2aiGYlboGgD9Oixuj7hwNJVPG0Qpp9a4RP9xiwBy0PBbTNOk0pMDd6wQpkBK5xJvWbPVK9lz5o
1M+/2y4QDjHNmciJC33Tam6gOF/FH0Fy/fU/gPobFVWid+5Oz3lxzLY8GzBAnfvq0t6HsRoE2gSxTRTmiutRBv8bqo1Nr0yO6ScM
kFgS1m+wo9Ts9ATXJLgheYGIlMguHIP74oDt+rzuot1CkP4xhcMryoeC5xVq8cD+oAnPpkiFseCXsPgCxSLpBcAHMX+uDEailq1o
ebSPLMNndE6FICMPfjt4/cAJDfypS/Tm4Qu7DkOOCtH1Cfby70dNvlLFcRLj0Ua7R/fn0xk+55C4fzBZj/buv8gJRWNcEjF1RJYY
Jl8QGPsVLsIySJ0aDUc3MgRuOg2MnIpj0L4DooY68/fWhwqie5TLpW8en1TIbWJoSSe0qUS0ym/ICYGTVnbfK8dgtZ4YYqIM2T+p
DCS9TP5xw5F7QW6qKYHritOaRpZxxiS3z6wSgwiyNH6NzJhT7JJYIEq5nNcsIUfJlcCjKGozdSs+P9BzbCPI4qPcvyZ8uPD26vrV
b5bmxV5K0FSZbQARBmN+HQ4RktBiySaojG26RQPE0cZfvLRNAPNZUPyyV/XHjKLQq5/+HakctmDzDts67f1DqdjqqJdwXs+45wt/
KYLrFBCMd3l31R3xcLVxbz5CHkj3t6eSKS/3SMp+C3Wykugub/id6qrAYiMTIijepJSgfFX5A7UOYfrksV8+Tgb8kDJN/SeeLpsd
XHgKr2FDrzprc1hlBMWr7oWIcxRZzVEAjBmBRm+38jD7eqDZQPk3c+hCsLpAng60lh3G/rMWel3rTEDtB3XBP//bS5N4qAX7U9Wm
rYAnlnf/hCFoIxKIcbYLNB4dPmLjxFXECZDElV1h/lLhN24Y7EPCa3hjGGy3qyRlAozIh+tXGqTWr/yF3wWsBoAqxmrsbYnqyFmW
OfRlTFytmrpsoKE0VgmcuJ/fgCwa9okMhPlEZ+5OrsWYWk2ZKi+dyVxE3j22Y4Bnte+1fJRpBYbjWPBobsMtbq2/54Z4mFG1//mN
6kCwlTYFFsHGAX66ypcsSODEIkZoWp0JzPEyMVDChdTbaYAEiErUJrHjIhgdscdDp1SeXEDKKqsTAT8rO7EXUPBoi4Zs0c7ybg5F
3Alj0gno3VdwDJbBJ0GSUfC8xbNepVy5W7JuRHWvd9wao6HBTvMXNr4U6Pg3Y5VRcGXLepFJqpOaGBisiQWsyxyOTwZuInzPE5iN
EKolzjqcmHOupBuzNo5/dRyBrShAYMQ5nMyzrnY3VBfNlEYawTAKLssvhb+ivnu6CDybTsDFUhEUf7d/bLQszc4Y460H8d6xlw88
aivxn85vL14C+EhKHiV1EXU5S78gz9gqCcVJdf8RFbxY7YdWPPk3aYN9rmw8x5tz+2F4Cgt/EbjykWL5YzNnAD2uS5FrwUe70oX0
RJPq2TpVIwchLNhrUS1KtMQMuAhp2PdhtxRce7tHh2Q646lRsLnB/wvfQb36sAIhza99gBFDQJQAGP7MikfuVIewgeSCx2qPnwmm
6ST7gC27tQ4YImWlorRvuOCng6vn1dmkbJTLWcgA5D6aPzbN2Pge5vBj+OrzQfkSgptfoRji0DuJEk5L4unLPnPS63EG1or/8lz5
ExMPm6VTEOkIj+KLE3S+N34gpJOcNwQCskWRTf+THvgjgVlztcfSjfA+Vf9M4tfqPD2WqXqtKvtR6BaqM4W46YdqSbjz9O7hJDy1
WNeldKKJ9MBJKxgbC3ZXvJrHSxvD/43l15Pwcej3vY5jmkgWp1IYjp79Mjv2OmvA/mtnWrmbtpJ7fyVoaYKlZrZTQRkyHVX61Isp
uhmjFDB/UWGbideFNKmPPAh9xDH500e3+D+6g8hELG59ySzhA1CDEPEe34IJg4vX39BxdpVYQIW1eeJwYtI8ptFJXim4G4653zDJ
QUZaNEcgzc8H9EwjWqIfkIFkpfik1PjqkPb9V6EBqwuCIdwdH8Dd8jP/TE28+3CDBz3AW+cpJmcAIA2qR7sCXHlZb2gaJoFXOja8
ZD8KX3BugivDnx+3476ovqN1wNVTMkNkgWm1T/tbJfcorXvEYRcAkcrrP6BsgHsOBugJNL9FXAL3g20b7kuwK+Bo7cTYuHaxLDnO
IpLU//EzT/0hfUGIaPwbdEyvHXKbNGAzl/QVuwefDFyr5rtDNL6z9sdAZQDTRH/9k8fErANWIwD5ZxY2ziE+EtSRgAaMJf33s0U1
yMGqKvKLvqoQObXwcdqb8rds8MPQTErZm7EBvLurRSurBanXA/SSA13xWLtxTbSOF7oBa4q2SDiSKJCtzlKg+WOvA0j7RyShnl6w
xanayMqhVSyTF7/G0Cr3Dv+U3BrZf9P6EKo9TWWWnFjhD8W0HIMNZj9qGxSHBt1C0mZlckagRoVLUbsKxZcOlbZZAdmedpR4CmEJ
Z62pjJJFL+AuCWI0W3pKRT04Ez0BzVq4hY/zvabJ1sDyHwcRyT654MU/Ha7/uYivnIl1Y7UJzcSdoYLSso8DzQjpVFWwXpHfh060
vmMJ+3e4bjx+7JkhWHXCikW5NGdl8DMmPC1E2n08ghoPoMX9H9ufl9O7E8PuFcqCwCzq/LKI1ltv/WKkNTdJ+lunsWjoRuAMedus
b6zgTI/WTzESWtyXXv92L5HKiOV9uJblCI/7ShfJ3CfqcXDtlGuVCqUF57B7dQhCrUcW8dLqV3Gsy03Ixj1DAI/hIaeL+2stxG4f
qNjgcKdrE9kVfA5pegKAG+KUaw6NrtohPfj2C/r0WWYCxryhAnjSCTNHk7KReqp2/DslGRWA743k1o6sdLfxX5z/dtQLHWdnpk9x
hbbYGtnOC5Vb7Go5FKmwpRmFdI2EL2SN3Bnzq2sDkHGcGogN5eGILQodEiEdL/ojFcLd6InOKS6SprcH5AbeWamexWsoFRJVv6rn
ABgcoOd4GuDyZB7FvNWBTUwWAXiQQo6SdLF2feV2o64oooCPLcMJr6YpsiSdKCqgov6l1CASuYWcHx9qbJ6pR0SACjpxADU45Dai
cJhHkUH1pyj5B0Dhd9G5iUIKXRTj2srHejY4rT8hCDxTcEannDD7TVDCRG4SW9eLFQWyWa4Xqc7kYpXG6zSsEQTIJMx1XRSK4Zs6
4/ejJOXYq3k20km0q82oEcTPtBkeXYEHPl7xcpMQIq4ke7QCfsgqiW9wvmdZPdobvjaZLSkckpfa5c0wIC7FVszuWt5GObugNNQi
K4ocKcXc7QezOvUthKdHpzUeA8qRMvYqI9179rAURQourBr82UnfGi5x/gWaOTXNhpFAwRUM5DbNnM3F/b07NOJHvObo/+Eiy1a2
xZIF9V8TqDsaLwb0vartmKD35PkD6f8wd/m70rB+ZoFQnoYD4IgYBeu7gZkgcnjmgnz6fmPnmgZlsAanxk+EifV+vAfXso/U4dUE
XGmGgr4WOjOD3i0LCWKWLcmt9w1W1bxsy46W4vn3784l6ML6plNrM0bBPvw24qwHi9T+YT7w9wcofT6nhTUOGmmdFbiGAycMMMmb
PmeIcie9MQ+EvTAV8o3SqrrQYLxuRP1oh0xg1Q3iGS2n3HyYqLdSdEJw0ZyPwFFjYVnVw+4M6rbemFTC6HaNAiHy7WY7nrkRBOps
eEn9oDFZSciOncBVx6MgfK01m1nFUY8NOLkfXn3T67HyX7kUs4XCB3mmMi+FpC6ux0DjhXPR26xvJOlDP5Yp+2uC4EEeF7rlc+v/
yT2OvMHoXK5s/r5WBCGIitXXLFvcXNWhFlDxyejXlTwckphBl3NLYQHHXWPAaOX49qHKWK3VD+bvbXiBeNcdVb8PeRHtUus3TipQ
bTYPA3vNfXl4TqObSv9ls22VLTeANeRYOHiupgUfy/cGw5lTI6MWjEmzjc4VdXNgq431wYC3pgYmmdo=