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/a0xALWKejrb3pYF/pRguXtwmn+xOoigcJC+Um8lXiLniyBb+Ky7g9YrikRJgHMwaledVL5rDkoXURUL7xiDLDfn7I
lRJdGol7Z7MxO1Qhw+GbT1/wjGvpPRZbAZhNO49bYCuxZpLXpGGbrgiy67RmoH34s3lVTrJxOb2/o/SX5ONmy7cJgBKZSHDUlhw2
EMGXalWDrmnQxg5jmQZl60qryA1jwQyiNdz2Rf9K9/oRke7kmCwckEzsBUae72ROMSQHuvmFzKNpTNVTIUnW8MZRVvBeb1lNE7Vi
A6VfeNCojs84ZnAIc6gEeA8+xqFsTdwa6/oAXnfoqOwBhBmriQ1Jo/zqHPPQcfd9VGHsF73JEtTx+lNHVcf/3GdDJm35FjeOvD4D
Aq3+Syau33Px6EF9lyFjyZ+4jv/1re+ID8F1PljmrkmfolTDInYj8hz9TJAs62s/pGMOMSOLUwakTVxUCTbpMMTIzGYj8c3VCQhA
f5NyZ/O3gZG/K8brRmPgrORozXbmbTgiAA2++aWc74fLGeZqfkQM+0S1gZuzpm5Ylfttie9kV921vaPOfIu+GW2hW6+DhWdVsN1a
SlZge0TuHGzZwKhCYgwuDBJ8uJ9uGIExNF38KpfPwHU8p5ag+/EItMX9fJpZeeaLyVg6YABD9fQyaAuoTN2hkKUg6yNn4h13CY5G
CdwVP5gESbiZkqMLEHBzqQVkuAw3/IBA4ZoQT8GUGD5M12Z5BrTrZYq4jEMJdr0Ppm6tfa/Jn+7yPhWzMMLIqXUpKWJneDRiqSYK
xyxhgj3sbnlK2mn5EsTs4XZ9JXe/fd7J+or8ToFZC1k/O4opFNMAMKJEpbKFEWWWBuRAxe/lIRroGPQ/JsE/tpXJKtIYNgrQH01t
/OOfe5erNuS4iO9oQXYzQcSLfR9OQV2NnwGNmpa+79J2AFUNv3GQaOf32WoDPEqGNqDLJ0tsFW4Ipkh+ggcXLG9AHLnFt7TAZELy
SmE3HFSaFOKyDHcmSIHF7TupeFqu4UzqMFnPxiGxrsZ3c3k0VxY2RTwlKE7lCtmile1psnOGog3yyvnk5RwOZk5T/oL5wASseDpu
DymGlcexXaj+p1Pldi/NwO7aloxK4eI4JKLmLiRzv2hs2vFK86yZmF9cQcIeZiPIMwWpRLVneLX08iirQx8eohUbg5y6dm+dGHHQ
r8Gn4D2TP4cKTjvsB7IDfLO0FhAEk93kMO7mzPRBtTZrdLfRSBuJLxAiII9T3E/So8xOpLpePCCstOctfk9+o72bX+GU7ki4f1rb
R3iKdABUhXxtMJTQ9O+oBlmgaLMbKQ0oU95TwPfaEHSrylPl998SyH1UaQQbJABOrWQ7XAi+aKmi6TlrSFwOiCRk6LhleTnCVai8
V3sRdnu7CuxMEEUsvml8zFgZW5h81AJh+ntS8cJbK8FcT6i4TMg1FbUYCBPy4GTOakCZ6xkW12XiTHc1VcUotCgJxXEohNLyYMBn
G8iqvWz1V9pu5oCzrqZuQfjhnKBr1EhCw5EeAmI+K768fpKK9eQyRNkS4IaJ5u7whwtMsxizOrZ/h4cTw6373eSHMJ+EiChi1brZ
EeFXxlfEz5/AErYv/7R8WFf6k6Wzh/ps4rrGnKZzqH0hnR31AD52ZkQa76BkRe9+/7k/ZX0v4636GZ1i+5+MbsKAf0dUP63BZjtR
rhvIa4VbfE8dpYmJ7PJ5Qn/QybRwZNwj1V7OBwAgbPlsd53VH4SNFsJm0sr86YhzWMJZY1y/aNkW7hDs3+GCc9v/akiqGbabULi3
Mv8OKF9Wa5D8y9wjDZmremEuJo81yj9pqWTV0S1DME9OwkwCSth0fhxDONCgd6d/0C55d5J178CaOiBp0fUJIo9trdpftrlWOLUq
7VqI69rnl3RPlKWguRAjRXmGh6B/h2mPKrmFlNvvqiJb50eLtiCzmP3ZRCJUq1rMkC7UlAOG6Rru6P8q+r487fCzgviDC4PjmJvF
IBhdCi4G0w4ppH38YOgnYPtZDkoN5lNbkLkdxUVxf7vEOKezz7w8xVIsioW+58Ojgl+FoPR3HigI8rZEpLFMYxax0825Y2WgopFD
DF9NVqZE7HsOxl9Gva75k9bI2jpTaTOeXf2UMXUEpmM1aZnst/lWYPZI71hppCUk2mL1V0X6jpA6pshbKk/W5AKM4xYcw7Wfgavv
tfNGJ8twX3MdGaYR4dITMcDq419YXJnP2F5r8LU8li/QkUOLcKapc14VT32wKzONl3BlNk540ZfgDGI5bAD+4LZTAXoEqihQYph8
yjdQoGbe/eGtTHVQTC8RSZxfUwuvqzfkC2wjXu8reBALGOmCKGHsfz5RJ6hL+vVhtq0/YHMvWpj8GFtaAofUFDO8VhnHzatY/1sG
A2vppdfo8EjOBKxUoKNS/ZeGIxP0quWUiVhjfZZT19Fmqi6dBMHVkVaHokkskGy4G1mKBrsO5FdziRL0NoICVvBcj5V/DfntHRkh
HXLCwlpkipRM5TM4AKRiHmSrRfjFtdyCfKQykqj9cM5E9s9Tt4v2WR2Q5TtdBzye4B7dVbZTvbgVacxaaq9cH9ZCMJXSaCPHEQzn
iJd5yodkjebM1slgKl3e1kUgI99wYj3Qv/eiMcb/wGJAjUsqkekgB0jH//mQCXKfLarhafCVUAylWo/dn5an15InhdvcaF3tqKTF
xfaVXrZwbZTf+bK9JAC/yPU4Ool+SCX1hk8IpS4OS1LUV4metDGNC/rVeJewA0kVazFwhhWdby4eTrbHZ83aFcDRm20nHnP7HDh3
TVdXwNSwqyR8PKUJkTlzz0p+jZpTf/vcrw+zgL0a/kBClPIp3Cq2vb2tZn8AJ1+Gku+PP1OdypAU1xKRE3bOGADQEpgFbvH8C3HT
dJZKTjpVRgqjcULQIFuduNas4CfcbJafigtHGv8ygRL78fei7C3j+qQ/3k2E0P29UeZNkEFtEAcX9a0sUfQM+SSNz054kPbsyNao
hlIuI3PuHqGRkRGQbM7m2yvNIRBrLN2sTFaKZEfHNT00c1NG1J4/O5YT4p8yDROdlB0fhEmNFBUceFCASzyk8M722vnWgw1+DEMI
4fUk9NNjqCCcyuPOtXKNcEeo50eBQXiOlXslsNKdodqt5trx/RsGhQqUf1hQ1N3L18Afo6pX3Wu8R1vsWPwcznU/LjsCO/BVSKum
QgUU/nzV5GXZESjU/x0vDESlbEDXmDw/fYGznuBZLTqrFExQJaqHXmW2EzqKIpISBwf2tIQEFCqjUXS65VPeafUYy2JPAdeq5dPK
QSIikQjMUHgVVlaq2W3dW8d5r6AHAv6osn2BEAqM5Ux8dWNwzexafpeQShgQjYjk7ooJnMWtShTlWqP1mBH7JFAtK7xidGPmDKRD
ju1Dlf6Ewh/Am1L/0ogipdtZJAH8eR5Ni3TQr71+5huQjp//8ok6VxHudgT2cFmPPiGywUGpQdTmFm7HIOuDla3EVNMDWjsOCC+h
19pcPoINaIGYNJ86iVdvFxOEEWZqWSU8mzOjR2Mj6/YKzsAWLKZWtvOLhL2sBNhAji8bzqUPptRpS73SbjTasl3zXiHQ5rOtQh34
lwoW3wA2mdDroPi1lIxNmKM9kL0UovSS5gftaVSwiTwnUtdPZGq6puAOYk5eDaLQiPlkgbBISNIaWx5/k4MXF+/0hpBLT/l+4v8L
okL2+B9NVRTm3fn8gpqf6cT9pm5bWB9huw494RsSyF6aJSdt8iUklNGrbSyszXuXGMzfHs8+YAT4yst+3Gn+X7Nvuewj2ylZJMCK
pq2kEZsKiJr0vyXWb3ACwAi4rPHZ2PiwgJ/l5Nrqfd373wbPxSFa0uBFWYykVaDRtW852NpiWfTEJOM3WGld/DHryKOw7opnHTfa
gipPglAIXzOvmunhAht08gFwnPoVBk72Yh6J7Xx+eGkwCtQ06M+DPPxaos25BWYHTnx4UKUEabKfDck2VvGBAtYj7VGB4cYziXux
H4cVsjxvsVKpb2IlkRolzXBzfaQlfDWMZv9D7jrD5N0uFFsWHROesOmIkcHFlUzpheVZ1wJi7+aRh6T1FqZxYz3T1e2d7efQEZeZ
vG/OpECrNgGNASTD0RtpK7EqtdfNtLy5jnU80Awhg6Kl8063CDS5vHKGC/2+92YrxqUfCyHhNV0VK+GtELE/yqHBFTTWKwSSN7r3
lyEAZOkvpbMsDSL0WUHQA5GuwGS68WX8yxWM6AiJ2uJ9rQbHjo3NIJFF/cS8oHViUP9cEGZ0nmszhAgMaxF6LsWAJnPgOHwhLrXZ
e8zBhrVTu/+IFJq1xicG9o/st7TRbM6BARUubu4nqeLsNGux19W1CvsHtXTEFuifY13aoROMrB6hfyx0/P8JxWOHIeALrOcRYXoY
RSL9n9uc7xb4UEznOZqxV0GnWlPXh2WgGY6wwsCYLEtAqAHSL33qIWSLOh2IF6JwrK25qPMVxVZCDEfmcwd6VIqDJgmXHCXpvkOX
tn0FhICTICt0LGFw+0OP6fjrAj+bXA99wgC0ldYEl5uEN3Nmr9BH7uIVJvnMMjEimFxGEmDCcub4gqJP0UHRexyKL6U05kXp3HuS
keNRJam4WO4XrG+2plbLqs0R085y4zbimgEZOzq51Np6iwcGn9sgW1md+A16LglyqFtf0PPjaOppspCPmKC61dX/5BJpm1H8jxkl
ZrMfR8i4bzWdhSb8wK33kgolBERKtYdxl03fLH8nn3Rg98kgEgtNQJ7y/xTsQ5RTuYXLBK8qr/3yRSU=