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/j7+Wuk9wh9xGK6w+3tiwj1hKaQxCTv/aCPs1KpytfrAN5orSxmKqrm0LbnHEhDZRajhLTfE5muFh9Txv0jbCfGz/h
X9QxJxgGOU4P8ttcyPlA3G0v5xtNXJvJ4CblbsM31Oo1uJmT+sUBJcnGEpHqyL0jO61RbES7ZG7wpfr7bdWHCL0TqRDTq7dl+UF+
Y9nZisLmYUkUEdbKI5iUQbAXEj2tZUIWfi/tVH2h2IDBrtjlcE1e6XekbFLLLJxkAJlxgBD3BhvcDfgtNm1F/7SVs1VZApSo5AJz
YxNPtgjgLeVfLPoGP4A6k1dYjEvN7AULGnWenHGXKJcCbvcrTE0TrlT+8WsSBdEhngoUXqMiIzP8oGQYHCB39XvOr6g5ko3HYiVP
P6QdvQuYxYPM+Ga+X3yqAqmNVm/S83HKcBrDCcPIT9vtgr6XfZIQK3B0mIoOyjZ5SitNC66Q8V18R6x1WbZBXgT1qugwB6yCpmxT
IMHH638N5jxIjKiSTQQBtW+jW3SNMkn/xV/3cWler7tleT/75UTH4y/56KQbiU10mmYQwj/C3x02L35f+S5pyNnH1hpRpz4hYsWK
7a5RqNw3o35m/KEtNU9PvINZHpUQNghEDyjIwnxe79uios5JX1w/w3ecgPfEKsTqGom6YKbcJovjsAa3fjHxmj6gCvpvrhzV1woZ
hAowQEDqnh11SP0a4/+vj7PEhAdc6j6Pgw/xhJkfgx5XQK94L89ka+CTtZoc2rMOWKiWJ4D/yyFzY1q4IZVcKed+tWvf/mK/V6qX
sASDV2qFLr/xijWojNUaO/vOy4cSHfigYa5M0ofc5TeJa3v6AuFHyvwKjzMKNWMB7P/PLNRIBW/aWg0tRfmgOKlzsM6zUeIKxWST
vQgXPqY7qEfNMV/IJ5yGiS2hCPorkjiHYX71NnFJckAvvdBsY+X68Q/HQHinUQz34ldJs15HmfBiALJ7TCNlUBKrV0c37PVNlTBH
7tSCLYN5IyfBtamwNVDCPC0dt8lU+y9H14N8mi125gnvTr0Grxmeibv81uTDEHg3Y82OxZ3F1cww58UMWqq1Ic23UzpkwVk5MreT
kHXejMzYIjrctwnxBNhKtIx3cwOlPuBG0L93WYRmUK0CZUO2oQwWOXBc1YgIjPgh7IbyeXKbprsPBoaHG+ZgZCsvSgwfdxSqoJD1
C83YRpFEmcLi22D7OolLODPyeIZeymTdKwmrDrICl5EhArukf3qDrGLlIN5U99sl0Ha0m7VRfdjbTjQ+vfSONJP2djc/21CtdEcM
q84hjQrZ/E6U6tZgSLlj7DSPa4ltKRhjJO69MgLFs8+t9rTFQqlCmMUmg2L3+Ns1uYMjD0ZqYbQMuNEl14vR4UuQoSPwoBZmSz//
ImKjvWRX5DIVcLAA7R9uaVIGd4G7N2oxncOE/qx5pulzI/ObPZxC494TSb9M8nKw9Ps2upoT7XpIypqgzZfQHnfgaCv7M+cdT5GF
c59/At2Lu82DPClPx4AJbqwMeeempslmhXpo7cUOxKKYL/m8JyQGfrZC2qDWwDFIhrtlurgW9SlWpRRKfUeH0gYobixHqFhqTRw4
FeHxA7MwxONQZpYFuiYc5qUhC/Xperr59fL/LKjI84YwCAFYctSGUtIJyW9xmSu+FKs8zOiDiQfqycLDRyGfIVd7vVXofIBfy3CY
ct55+OEogEWl1WL8daKQsUAJiDGpe/KeRmBuZYzaOsxFZe2ZU0+FxNEoRDPGuJHl75IbKM/A6Yz4ScfyzrvhkDYQUovZ6DW4rTBj
pVwH15Y4+M2sxTenibzC2qcHzMCCF3SMIETNUgguqJ6KRoSc3t8bt/3T1VMOITLNnjuJOWSL7OZFBNsYXNwuRiwjijP+reLb61mh
mraskdKbMsHBW4jS+HC4smg61iRWBr9U4/MbkjQHNP8Utj4zj0AMgr3Du2gYAUg8Ig5a9PUFHsdA/hzuRpec/MtaX0ZytSyr6VLf
9W/WZaPF65udM7j1+G2AghR4EfkeSOjgB8O8CJGH4V3VzXYPsiYc9POBG6q7RH2yb0YIrRDDdYqMTyOjI/CV8whSVNMxdDRJhhNf
cWYI6gGR59F3K486TjqgOHg+0Qnlmxz7G4OI+D2GNlqUKpz0w/qZdCiCJ34K1y36yLRly7+/csfbrFcAuQP7rbIZJhAc4CDnyipw
+L/E3Iz8eNYcA2YGuCzmCphJUPUzBq5yxf6Iq2MoMXGHi3qF/qbg8zw0w69AH1Zzd2xMUljmVcJNdnv0krmtgOGyx6xrIkhu5d/r
KG4DNGMZH+UqVMwyB/3TMkG5sjyHNy2ApmWpg7gPCSbQS6zchQogb8FoGBwDF7t7XHfRrvxIxOm8VJ0/ow4Glx1+hx6Oy7WD64q2
Mt5m9otOaAsda7m7HZftl8zJTzDeMfTTEOQgCeXhJ/8JpTElFhu9zKALoY0xBHl8YSq8CXo8aosIolqkJBd4t2sSiJf9RBFZGNtJ
9YF7si6exHXmixkxbYXVlVRGh5OUTmPie5v0OA04mqTz0iXcnHbUsq4orUHQk/Lg7f11ZbtTV4XLvOJ4mpz/BPvgf5pZqWaIVWsP
T5syRY3C8EKZU/Gt1UnY55SeW/v0voRaGz1XUHcRCwuvLZK6EsnBpb18PCboMz0LuHuoCY9ZyBPN7YZBFLsBt6kQMX6bJhvCjbzd
cIAkH04mjQwRTAtNEl5hnTvcS1N3KWKDkJStJfJ+6y3MKARUmaznd5d/H1vU8RjMJwux8FHBZ8/00eZfCqmV7YkilgzZOj8PAAzb
muDFQjOR9WAb95axkjscjbbLUjbh76eNjuuvXKrldtqAFz3DCS7NbLJdutBk71OKDrvdZxL0FRfkS8MRtEjejT5IhuKkHWjQXB7j
OpJ12GcWpJBNkvaSPbyTKcmJ1oYP5jbnONuk8/C+bwXHFTwaMx/Vv7oUN6X6Fo6dNJRZ5jyQS8a7me5WxkLfVyCtuSfxzp1qV1Aw
ZMRkCiS4dD4eIeN7q5OZL3ZEf7zkXe+JfAsc0Nicvty4hT5tkraLBmzTXR03/lZuBJ+ygfshjh4ryAhtjUiBmp5fRTTNwm/TfVbW
lncy+6sp9XkvvC86SZDoBaJAVFq/3wiYAbX457FkPIpcf/uzd/kG/kR+UhUytAr1XhoHZBrMdVqnhJjhCypCGaR1L/YZRvB+kGsp
lRBZFshMco10PVXaLxNNNLKLIAL/CFEOL6B3ZRfHVK3IEQcpKFVtEv0XMs3thv5rX0c6K6lxyGoJguJOykAhds27k/QVaCLygJTs
+4qyL+P5DTrobnOkTedTr8fAartEhU6RW7YyAulWyhbrZ2Vq1BmK3JIf4zcznfMvmEcByuBTSTByTnaaxWrLyluVupSpiHUL59i9
8ybjLDv2NRbrxXFxLgymnhxhiALvBIvrV4vOWPxO2BcJlngMAEeo0RecJlXgYjlNy3RsQZFYTXv2Gke30MuObPQ6Yo1XF1jdCDi+
OuEnqqaE7e9jmvxt/XKZlKHMApOdyuWSe2GEE1u7B9NsQKC1NPpNQ2PKnROP31JS+Ao5BrXRSCHj9vggYzMdvFISfp6MG/DjI5zf
aPqR3zk5uRi3ArGZJjHlHH5jTc9F7UBk/Hugx107ruAh6ikN3mrHB10LECMN7AFlMwc0HF/vIKK/RPyAIDma23ms/JkBphUccssr
5bU9K7ED5Ll6tUbB0UI7G2FIbwMNCxSTIBQvnB0C66HNilwXZy8Ss5KFoPBWIilVRAaiMGEgbC+KllrvUaY7+HL0D5/jWffgWpG8
noymnRXUQovJZbKWh/7A+Vz5GHlIH0TqncweNMGtNJcWFaAUZitbJH5zwKBQlkr4SBzvE6jg3yUj15Ax0+fktK/FEw9OgiOWEQd/
+o+DIO42IZd4Dc4SwTnlY0G3xMv81UvukyM/DC129A4vWh2+7r1VQGPCayzKIGADAXbVd1QB1ue//f6R7WJTeY7XoWLO5Fkmz/ac
YxGyLIhnP99LFi5PjeWRMwKR3V1vpXUv0QsimakUs7BBhtmlSvmvn0GwRdSoOn0Axgsey8lxP3qlCYWQWFGUty51G5EJuNFjsxZv
AAJZb2gtplKYvgDqs6+qg66k4spYDe0Z6S2dtWpLmTkWrDUPXISfBsFf2ePPlxPZTAQMNgX772NiEdzrEVN38cYwKX5gdcYh6OeQ
dl0d1G11HKod25jpfjPVdOoUkvMVceLpD9Q3BfafBr4l8MYA733+9aGeIB9CFH1usJVfZC/anKufONAV4myfERHi/zp/sAjDJZHs
MLPEo3/RZ7ziuL7pdSh1UzvryNBu2t5obdMrNuDEafo0jahFNhW251sKTG0EGEzxfkqTNZsCljXmTHkbBpfGcOXwgWbZ7GFktp8T
1Rv05RWXs0vIGDsGTwmzogufqBHwJB/knqaOgupNdcZIsKJrx417Hi7pys70SnOLnXQw4wxVhDxJVjiz979pIFDu72sk9RKphDYd
bD5ZmFYXpzK3vMmGwLfAadfnaAaCs9REG/PJtW5OY6Auosemry64SrAGufd6VgeS6PzWFjMjyeFVeN8ERLiROfraSaJj6yG3CzoY
NzsHcceTwr/UyTcbF5vCWd/mAtSiAJc2IOor5xChwDmAKn4rGAq5hv5nWmBa2Qovpgz93sI16qWNo/IUf2suBjwLV+jwAr15dTSX
Sqr7Txis5yV8aZmqcFGXiTA5ZVbnmpSOEWLtv2b1Xiod7Je2tWDboEeXwszl6aPJO1cBXIevIBDWhzY=