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
be7fc5438c2f5fb388b7431c3d967ea959bc976c4bc81123a18dee68a61febaU2FsdGVkX191LE2FK348w5o34EIcu+uCIUpDkr4EM7RGUJZ4D6+cunTomPFA0kR8HXH1mJzUUI7zfxPMrKopR/NVN9DEo7h0ke4a
I1k+SheyP97m0+0mtj0JI13LnsPgiPEIOkLQ1MnCF+Qj5YUuRJoPYRcNviEGXLvbZfoOmmRh0Ryaqi7pB6p5xoY4PmFmQPySwAWd
UwyxHI7d9OLd3iqYTF4BPAHDTtpq0LMwyfCnHs3+PyuHSY/3PjxySQG/GJfnEDw4SZoMQmHe6jBSC8lwJG0SYjdms1VYdTcC4zrt
3Rk/56ZdLCkHg9MWd2F63mEpSS9J56eHAuoeM/t3oIbF6y3rZf68WiPI7QJq4EqdCGpR2NZ67gWLK5zozKs/pzRGLzNJpB2WsGtI
k1Ov5ssKuUK+hQyF3BGEts5Ta3s3RtrbcmHi28rwyHD6m8VMaS6CJF+IY3kv1++YlD1b6G9FiRnhVAFSIEk4OvCPeYJqURhmLS2S
zDesCWbIXyO9ZGX6iLWlSbrrABN56f68/IZ/pQf+rWu4giVg5EMRglG/tgTVSftYv4W7vnpFUwPYBxW/h59odBTMJ6KZuGuooCQ6
QRUqwymEUjK11IVAeXBKvyuR7LwBFOyCNXJTaE9KFuVNlzxs3GxH6/PhGxIWr7ga8y2dCANRfGijBirH9KPMAo/Z3h6+3ogBM8E3
UQkzaTFN/1ECA0lVRhhUD23AA0HF/WYkYipxA6I+EjBzRYoSiBOg5TZgtchdBigF17QboWBI1MFiUcvVsok6QJM69rFPcms3a/nz
PjZhX3ZfcfN4Rj/hjFjAp7P4OUQSiG/4cXm6Ze4c5IWadPJT+f4E1xNI11/gvuJa0gStuHsIZKqTYWqUXdOGNyyZwvLhRS3YVaPm
nsSOLpg4H7Y5KE8IUW5mfI+Oc/jpdf+p8V8qGWKVj3BEIzA6EdquwKMIcZJfcKrSLVvX8VVCXIKwTfYyBMjxHFHLC5Lo39zQ1UP3
bcQvAdmSwWRqxgVg2d4MUPgTvYC3OT2TqJJK5iI+iBCVVWASmlCW6fPOKBm8+PE8A0rtLu5Isrs3XCTEP4Y4oA5ygZV+dPcMxGhT
9YpDsaH3a0Upnyhq1iwD+LRVMetygL6yAN/jLGhV3wTJRDGQklwnRWLgBZ7e98IhHfF3YZ0ng85qwwt1vKOkgzva9ORVITZ6/Nj3
mKfu3w1z7CI3ocYXKv5Q/jcWO16NAGipYgr2i2Ym3S8SSh7EcrQG3p2jN7F28BMTLtpcnmVGLA3iuLgCcBXNtadCmTYCT9T3nWJu
VubkruvtPx9vKz4gDHNDsoSL7UPV3XI3E4MfXTwRI553T+9yRGk+qDxWlPi8qQ8Cbe1VH9O5esr/yDjqtjen+ypwU0ioIGBjwOAV
OJbFbRxU4+DxRarukRdZ398DjTvvva83NBheJija+1OPGZXxQ7xgF04dxeW8NV9HyLPiFQk+IYktavY9uArtpg/S5mM/+Xa6y4Kz
tJx2i9e8Tqdp2SOyQPhvxyXByttYUEmAO5qdTkmxRd+EoWznz2SDkqaixVWinf/Z2Q6hYXwWNritSQrbC8H7wUnuqWSYIPehJJTI
a07FVYpOkqYDKUM0QdEaA46N8NbHFKqlvqqZAsfdG9gjHJcZLMU8/szXauJP3A64xCa9m1LHpajeASUyt1HQDnJ1E6R06KVDpj5D
yrSMxU+//f9R3yKmO8fv7XdLAGM0NcvYTXaoDRVKvc774C81oqJFrqaAMOrBnM6D2UbqKRFMqsEXwRvEJ7hbpwuUGqUavvmja9af
YBUOugJuZBbfMeC9M7Os0eRz5qVT0vGLmISb9AntAKFEQ7VcmnJAQJnPj+65TmTTSivlKP3cCqQIS7+KNbg67Xq9YshSunAwEJ4o
BdpCJu+PJxsekmf9HUrSbvr1d4bKQ4ty+AOllMB2jdJZoE/pO4JgMgRFqpNIww1n23VZOjczvUCT2n+3HYOw4T17iFG6bFifmS9R
NNKbrWvsW4xfLzKSBPM+6D9DGAVyGsWN4pNPsrEwvotDKaV6wcYH0Gn/ibVyWOZc1Lyhqk2lRQPXp/SgW9ktsvPLHSIvKIbbsX3t
sJd5pIiShMlb3hvOtmjru+c/aB7xmzrellnr7SD7QRCCqYKGNohP5tb+qJkx7/px1qhHBH/wnyh46WktiTgsUT0lo3RQyIAkSNYw
AlGDsCU6SCIhL6iozJC7/7cSKgqXhLP/TIn9G7xxMvotpaj/cHMMkSmO1vZGijjiUMecL4sVvyf+/3sK+pXD0p/dCCze9sPASCbA
1WLeHAPBeKLqlHHYIFHweHR0s6C2E74zhLWMaAH0pOTnL+kMfGA9z3BCHRTTyPL5PhHK16dZOhnJalyBj6aiyB9qbvU7rs5piNnd
ivt2Jsf/hmfk1ulnXvPGaEJNJb8japRQBoMQDI68uH6WxBrLfbzW+VjqII9c7neCn1SqrlZbjIIedYNS0oJZcLNK4l5W0ncCunbi
ycaGsZzDR93TYC9uov9eQyn7nfEZzJy83VKMlTi0HhFsko2mqH1qRiRQVCnCkwkpBi6dxJmC+gFUe75ex2eBd3F+vYYdRIznii+W
o4gdLzFrI0WD+E4Iask1t3EYqulL6arwSHgEY5NXad/RQwkf/cPULkNHBS8w1B6795edbSE6GqC8KE+YqDhxzQu+3ZD7dc/LNrUr
IfmPsb5u8PxGzB1F9yFhCycVxqYddZLLIyqE1RAZ9dOgoTKhuRqSq+pflAO9Zm8rNo5i/kyYlI40LzkHfqYLG4JMpgXkDsSi2Ser
KQ+GScXCyO0+kN/ujXatZQ1wgLRpm69GodEYIz/uPOm8bphJcnStLeBNAG3OpcS5weZyPlRUFkNFOmU/zOnwiCR+/72eiyLSt0cD
ZDqf2M2rDNdDJ5OLq8vaA+3GO0GkYX4VySB+9z8+2+YhiaqoFmF3Oz0m4+BZ0z30oMcbbAkCOFDnT4ozRyrAVV99ZGHPHXsmep8E
FsAL3/thmm2EXgwnWH6ACgN/QaHI8yA9gJOoZXrUriaPuUwxe8F2izZzmXCgCdy624FJkwWaKqys85cKTwBmvav8ZaeZWP65OqNQ
8MLo8OkHDtO6l2f4yHHx8GNNTP3B3d+DzpfYJqiit0pqz4x3XP9tjN0Z6FXRh4/SWy1D15ags+l6wvPY3f3WEp4tZax4FP7w8ziD
CJN1XIHiky4MsZqAxZLX8jaIjPB6WdvHnTXYDnPrQM014b7wn6EONU9beV83ez4O1Bx8uIhmYbW3d9GQMA32Tv1HZU4EIwX+bh9C
WEtjqfcF0uF6f1CPscpaidd8dQrp8+qDI5e2WWf/+EJI1AaPnpY5q+fgIM0uXMNI9rB60rCoe1i3hPT3JlD5DpSiawa2xCcrPTkX
Xzkbbf0fi7m5+dseGg9cfGnnmI1y5N1rJEE4r0tfeWxfoOUfFCQnruIVbJI1VGiYWl/5N0PUVdv8hmRb8KhUR9WrVhWzUCRWmLqV
DB5H2rF/ptGoc2DuqGJ1mxx6MxcNNWD508OprDHd86fIN4/FGIAg4KV8wPm7wxBVx85vb95sFhP3j6Ocb3WvY7Rgg3QgET/SetZr
ujGb8wBSqw5wXAnhqMUBDUGL2Mb9BiL153AHWjv2jJ7fChnyYwdeSuySwpUunxh+QOtmI0R/ecZfNbIgAY5Jc1pJnCD6zxEQ6Bls
umW665Mrgm8zPqd2Enqx3CccaxOmgq1qx6riLwhnIyr5b8eLYqtfiJRSh+nZEuZwB9AGvEvxvWG4ZENJO+6ZO80rwDVSzNc+xPnu
qS8ATL0g3pKhIbCwgCPC0YcP6zfQjRNqSyztx8/iQ6AW5gK71W4ceFrPFFs/9MEz4tWb3h+ffyH0KXtVYLt9XyVnq9h94y5F2MZ1
9REvhulA+RR/od+29BCNSZL1iL9NdT6nNKkZx0M1fDAGDpZ35AtvrK5LkBcH7bJEfB+Gl8BXxWjOn4NSW5uzZcsSOs0EQKMUzuAC
ZW6YaXVDwxGTcj9bkndVm5V9JDAlOD5c+qv/PNSeWOiGbhSuANvbk6KS3nDg78ppUVPbUwbiRq+Yy8EcpOTKk3Fccms6wOEtHAiS
LFChTMpaghfDZ75VnYw42zhIW1jTsG7+KQvafI0QVoy5RCOkpNU4JKaOA8y/CGTex1WbvWewPAzv0tORCz8LC1DirhpBvVr7uHHc
mYaHnrvUi1T8WpLnJA26foUEoKle7j5Ar4HdlaZi5XkEkHO7m3l+zKP4J3gDnn+J4WIX2Z6HAn3lv32HeakJWBtoavdJ2x/tT8am
aGmsS2sS6BQGebWvTtssFzcu1MLM3SwKMcubTdoyisgtPlUsXlhr8OUONjdyWls/qrWajzqRoXFIE1yWpcYteRAa4SXMGA1VAt4E
hbtpTQGLkXvWJmQqKbavJQwZh9muKa+k9mxFL8KDZs5zNG1tpz0Q5DKLHwcu3VeqiiyqKrSz4y6mjZCzbgDdY+dAduDPnY/LSUAg
ghNzJd3I7hZu3Rgr6ZC1VqlVBrWXhgA9hqzDpRMTH4e7cG4LDupzUNYwMAnVeOZXOyZAj8GlEWgYs5RGykcWTzcPs3ALP6Lazaah
MDbK84WJwQPbeL3GDKQm5MqISvc1h+yfbiY/Gex9GSMlJ6TkpSfvnQVcsUio5tQ1aTM+2u3dvIUaByvV0gGvIt362/K37BRixrpg
15ocv0pzaWi6ytMmQeGr05WcQd+WYRwcxwGn69f7OT3nYQ0SwZ4WPm7bjlD9ROjdSAywYyE/bu2v1CY=