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
be7fc5438c2f5fb388b7431c3d967ea959bc976c4bc81123a18dee68a61febaU2FsdGVkX19jKvPR9vRb2JY5qOstj4YCoS86L6SC3D9G5sLiJb5GleDaldvnCI1JnZRlONRecfQrCHGrnnq6KHdfhvYwpeerOP3P
gSEjVnVTSSdNIvtjFqJAtVduuEEBvdsT2MNlXlFsAeBaxpqh7krY1JLa8OGIdH2c/1j607iMCj3iTfKqFLGiQNNPlSMRZ+oQJW0u
6wbnjbn+oUmtHJJ8Lz0GjFxgIWrCYynTq/JP9teYqJMMTycKickLEwkoZ+E+NlS8Q2IstXwIzsN59ROX2Ze6G4acZM6FYJcgCQBN
W2QqJNXTGoM0RkC7BhtgpyauC9ArGf8kwy1ldNrOB+pOGGuMpaxPc3rlqB/MIZsSKQ+HFkDGtvbsXBUxdSBEh76wT9gxUrnYifCo
75EaWIdvbKDcrzpLDxRxhBLPE7dpFjWRRXn/a5U/BF9mpigVfm3FpWSwISpUPxdsL3UWVf36AtozFINqKDqt3Rig+gnoZpSaC8Xn
Bl3BdCt1PlRdBcaHWSRyaWHqpRzYCnbT4L5PE4EF8ucVkmqvM2ig6cYQ3b+oCeh76UgN1t/AsbpdK25yJFR5JWBxcfZ1ka5l5/NF
KwP1tIXVM57HwQ4pgqDuq+5fxPiuiHebgdKDsKGx9DejM1U9X76lL0UIOXJ6auXDfo0+m3CZ5V+w+YICKvmunoi3JiA09kydwv4w
EIY2yXeU+89ThBllF/aFnpf7+AUg9VkN6g9XWLOY0/twvHEm9sfodrM3fsDqzZWFI/i2RH6cPl3Qty0zzsnhWKjssbp9Tgu1rPbx
O73TP9so+qTCBfK6lT0/dyCrl9lRX/SAsX83C0Ru/CnGKVtOg6i8/2e+c9PrRIQcNc+4WPNEVuRQx0eD52rBhakLad+qHUwbXpGS
iZJvQuEkAz9Tt8hD1US+eIq0yuNophPrJW1l5nDgyY/HWFKyGyAp5ngjKgKYzkpEyDyvtAsJnU9XXzXR32p/PC/Zo8qNN3MYLHxG
fJqlNjzn88JsxbdFL/ZbU/uCpomtCPbFa/HfgQ2h1x/uXD7GzINhVPkWtrYRCdNBgkOTul7zwocx5odG2gFPSeis9pgPl7PxCzqd
1iWTJ4xIjwJRFeebFKqI/ARNuUmJgWP3Kdi9gKeAgZR15+hNQziSIgO5w4Ih4XGpDoIEBdKjWEkBcsABX/19OSwxBO7qYlpPBOMN
on3rdCNWpyc9f00VqimeOabvnufwurrq55izgJNNdeD4NTJhfeHFKlOnCupBdhRUsMIlYxCEVo5+fxnlsRwipHr+Jt1X15SkG2qD
Gm+LpCJfgcyNa+F3AbJ/VGMQgWjw+Aw5PZRHKtqKvfcYY2M80Ia9Den1KvmzieuDYe5gQ9KK/4PY51UthfKJtDtnQ0ciF0VwroxE
SZ1KhWqrvNCDlEXKHfvhZi9rdp2LtmcHsb7WjsfL8FIIghErDyhdPh27IwTXoayuArks1lZzSWgG1zgc5ME/2Zaj7X1lvDrW5JHU
9YIADq4H0uIze5LP6EKFqclH2wgdk+34VlbOfrIpylVuKnaW681iqjjnmxFvrUsvrausAI23KAakMaKMp1u8s2q+vt0FDWG7CXzo
MAu2qptBLSkt5gWiXkEeYcZxQ06g70UAP+MR0EjhX0IhjCwszsRX4Wvp8FxwlJT4G77MQ8oZ4yU8Ibn3jjNZlX3yErRSTF++d5Lk
AYBzIGgls5Yv2HiCVorCW6WQRChgCzJK1J0wIKNNSKnbJAEXYW/9OjWTai9H7JngSzNW3APQiKZauXe4Le56T8C+dfsUDK2nCkDN
oOGdw1SOAOmTeAWYhZjkuOFp0v87qRfsv+vBiydaAOV39zaZ4lyYxORJyWkqJdpUf2chUnJM3oeLbZRODVudVD+1Jy2vIBWGAZ8p
oLwOS7tuxJ4V/YsbDXibKy3MJ9Cuk/xaWSLsHqS1QshiEQdj4FaAtALnqp+sK+sY6E+ERwzlZzJa5mS8WTR4hdi9mgOqy2hbXO6U
/0okFyY/rZXm5U9H0AMxjtgCmOxZPiE8NOqDfMQb70cwv2O4Du2QbUPlLeL7Dcaivr/FMWTk0+/Jst2Av+HeKggulquvuVIl3Tuo
CKzrCyNtsiRORz4qumtfo277j59YBDe9caQhzyyoj99KMbW+XAPPUW++0wAsrrUe+5quHH1Gzva8osqooxRWNRWyQ9DgH0Oak+mk
u1gpf/b36hN42aHRjQe3/UhHOoqT7e/JseNxIVKcLAH3tgf9hPCyogLkvGg0/YGHwzoj8d8M8CVPZM987wojmOrHCGqVRPffG5kt
9ilFfPl5M6G4doWe6l9DyNgsc8XUFBq8v3/Jm+xYXtl6lfmoJFHZdhxcQ4+ZsQwZ+dEcxI5P7ybjDPtHXg8XosUJorUtfhp+cz9x
BT3yfxtHGkek1fXF8Z5AA5h7ye7i5o/XLTBgipJ+cH5kYQyOleOiEfXeBSKZPo8UhqMOalpmqRt5PYUmCIMDd75OYrNj2ZvHnL8M
K+GZY3LibGjJvy+5Q1HZVfrVjkMwZwkq4uk7rG9LUfBybV40XqjyiXNw/4OxZ8pM6xZp2ZOTccG3/cMyYAHyFrZKyyogJ/Rew8AY
6+ZyhdRWSo8YD5teLRIpgQLAgyTKe2naVI6wn77g7947/NiemSEBvtSpcLamGGdWCgOuHsvX0Y0eDT3wzVW/PwBdnSC8eO8uFpy5
ExEKWogbdoZVt8d1Xm7vxN0SkJHPWGRIQTXHsuXuj4lRv11sf3ip7ZmHdU21G7jjgklGK9AMg51usW2lVHFcB3cU6AwAi1Z0YnAz
/zzbkoJdtLRxdgIqDkGxvU3y+suuPi/jXSs+wmyDTMk9N65kehzx60iisUJAtaKDe5LJG0aSNs88KkAJsiV0+M6CF0eSwMV9aSL9
ZuxrGCtVF/OTm+gfSC1Ue1rS/afaNgSWR8Okioj2T2ipARTIvwPwciZ/aQZ/pm25xNdZKucn7d6D86YxnWXntwiQoVcQx1LB/iuz
bez13y5vQT9OSPkVOieaOl5PPkl7yMempsxkFzyUwt4r9QH77C54TDfb3QNFM9x9hQLha3mYDVVGm+l/sPOVek4oeB/gPRUXyQQm
xfyOko4ytj9iLhplJAj+GVPElRwHQpLFDfjmGojTfVtoaea8BitWYlg67G2tPbBdkqg1JC1IlzS7yuKb4HQUOqtwUuSH63+B7Aml
O1gdzchPanAdroS3Ep4hpVl7o9jUr0f1Y9Q2lZNeswW9JQvmGn7ZKcKARhM0fgTPFbUMX7aI1fdsVkg9f9oBEWTBvqNVfnOCP9wk
1MBe37uOICndkJ1L4jMcA4tLTsvuWNGroeVbCgD6lAtrv1lqi4xx6quNFeQ80Rc3nfpQ1VQR6/AJ7RJ2J7DTyGJs1QjD5YGZuY7k
9YONFbbtWBrgfWZDr8omelGgc7Q+ChRH+CKWioOT6kfTzN9O0j2w9Ahy1au1CoSnxjZuUBzYBhC46uD3aq59kqsb+Hb1mPTZalK2
w4myE0RxzpnXM9kqOcSL9KUKecI7DxpWb3cC4wuHmJoO8bgOV0NsQ4KxKTBAcX4NlNPKA4g9Qv40egzaF0ReeNEyyl7/T8d0yZH+
NpuxUJt9PLxtzGJlZEKjL9hhFu68MXusUSHd7QS89EY29gB75wxU9kAuriqTsLjeVpStQRq2ltNoB8gI0pqGAv2IHmjsAOT9ui10
ElG6gJa3FXZQLCwZTbfXOYoCqlGQNtnaR51kntHuvPUK8psGlQOla7tDtNgubJfudTdHvwTBnlxn2cE+dyMZskRPYZfvgcr5RxO0
sQxVYLygSPG1GeHie34q9gqRqozahUJR8fxaoHlTbcdP8hHsGk7XgLIGKIP2EPOc9mNMbuTeDGVDyG256EFK9DnUxOZe2egRJf+o
NnF9mllI6muMxluq+LF2Z5am+ayGLBQWJxln2eWKp2TXQVOe/4e6dqiHj1IC0j2skBFDWibRZ2/QA8r747ZWl6dbDlSObPtHRAlF
hPelvGciKL30jKF8wTGQR9mMA5grUOkFnrHzb88IMKkHKYFPqOvh0+8/+xxJ4ql7QRkgWSfEF4e/KXN+an7+N6RrFxk7KhrFSDdz
S+GuefxISvzWq0Tx/joVPXNCYM5tlDB94kPJm3Ck5l5omVj690gYKAKJ3qW/Uj1oS2frB6VIYwocsrSbq8JZRvTEK2TFjQWPm4Nj
3eWCiramiUpAFOFsMZaNeqE5qNmxtlx7TFaV1Ky9NPBDYxY3CZLVI8Da/lOyfvF8Tw6mo/hfD8PcY2R1VcKgf7AfgfNAM9vJfnd5
QOAhKhiATq1TGQy0Gf+XDW8ZYqcDVR6Y+hZl6JtwNxsGVvVv/GcYI+u3uooDDcqXGIgn6mOoO7gjt3o28zHg/sM07kw5v2X12Pmj
Nr2PC++khziGKAVOzVPnPDXn3rVItmTLJ67ZtA2JGnbeyfr/H+UT8dTiNGnY8sAQqYOup18wEfGW8M5P9VeaYd5sfU3JH5mU1mXx
BOWQbzGaRNhMmeeFs6qPOyE8E2MispAGyiTyJp8Dp4pKRdJJDCxGPLm1MDzR/DYe7RSgwI0NIKTXP8StpBk3J/hP8VPn51ryL0XY
fA8ks1pviZ3n+I/tUsXkH4XR3ajsr3FngxLXsZslbQa4b01M5d7IM4saplCR7QjHP1JLfy0YR5exGhu8RCO1KPDm4Azel5T+xqHr
rTv+LBcVLgx4CPmljx2USaXI44SLb8KFhjR16BX6Vay6kZQAEDKBjrICLkErXJv8gb7FI9Gp2DPlNAI=