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
be7fc5438c2f5fb388b7431c3d967ea959bc976c4bc81123a18dee68a61febaU2FsdGVkX18lQegq3Mv4qMkvkEY6Z9uMCViiAYSRZnKT9/rnqTxVznBru32bysAeFRCvnEctCpHAIecrIwEaFR36ilAZQwkoEgxV
NU5onfdSYeVn7hBiNq69FnufyYejTrtP/SqrIwND3F7XbkssV8R0SLmziNnxkuY4vI9/MwXzr0NDpW5JfiFm1nHtlOxIkSPGIPlj
1XejIJYERgFClQwBvTYRRK6tJ5ISD25+/GKXrv9y/wuXgyFd+UybR+qYE/8hNrOgMvCl4pv0FsLVh/1H4eIQUvLhecb1JUe3XnlP
+bWoZzTo4aVUbhhK1NGI1XZpmq9XxsQ1UWzlM/57lvCQPSHj5QLycdLB2YjuYJJOUA4+ybtZOWsU0TSC9h04dTuizbGUfyivvE2x
OwsnCGlqObHDm+0LWWMZCt+dmF/+/PybDcHrmLbDOQfzpz7hkQrBzrp6wrIO2lgy7XmqOLveMNdQLe6L5jgz6CzdYz9IqdAqfWL/
qoQJcfU1rTKoGIISDwF2jR1LgKheEf0w9TZoILPhf9X+Dg/G6VSk6VME+gRWvnsS+7xCmLeAwBwe63buxGUmaeggvOdIwIb3kRrX
g9n1JbUAknQGVxCplRSyayyKnS1pnfihCYTxwB35ij1Xry/UQx85xnC7wRUOZ9O3gA4EJBHR3Nu3W7dT65q1jzNYby82tmtrvuaC
OoGBCltL9pip2yEcdoGLJNv6CZ4yB7fZ9kUGj4xY5AIY3ZPrU+ZyfgYFrGOB3LRFM4PA7WDmscFS7+6XgSKCPdy0xXZjiMQqjuAG
+9lVJamVY30uOHgPWcjYPB1KlP4X9xTwbyoQpvvNZ7m1DWitsAcTpoMdALfvVLS+/ZLwyP7fiTdrqeFiDXIjeBHjtBJdgWwRVY9U
IxSBUUSpaAUjj9VTXC6x4KrXYttq+XgDgSrnbhtdv+jpaRbzMrNuq0KQtj3eHD4O2J8J74B+3ZQR80UsHQ8R5k/aoEH4c7yp32HH
CBzehwUt4mbqbr4MoeJTwPL2nEMg3BGjvosGrHrpKmT6BBfbYEGc+5OZT64YMgN2ex+z/3exahJ9clTShIDKpjw29g6f2/sMtK9U
VEJOwpT6E2zNI1uTMZa19M2VgiNmVPuFz3Ct0+cdNCztpZY8ZxGVKjLzGzM7A8RGe9ZS1dy0ZwkMtIu2sAyR7rctabpFv6Xit79a
CBIM+jdngSt7M/pg8Tvp1dcNrbPQ5SFNnBpxD1SftMCe9aXJKHL3ppnPUVP6TtwNc1ZGvIlqDglI1ARd/ouC52Zm/kKndRwCQ1w8
xDozmliOYcQYnlnszrXF4WmFM1cOsiNgGDL3qA2J5IxI4E3ADFpraq47vNO9fHS03pZu5IZhy549fovgBhNSXfy1l+OncC2LQa+Q
HzP+5rK5rZWm6IyWE5LaQ3uMuhDPla0/GNEr1b1QQPRJXUyCb4BKf3cCJe6KJz8nQXajRjwK1A9JWeRjUpyjz2YkNtAbUoPogq+q
RcEcenJeLzJHmKwYIJy+XM9/52J4QQPmxfY2geuLuycxcgh0kwHOy7pfR/UDBlqwHDpDisw2+V3qze9u4BFZTiwOY39HtjWN3PHH
rHR9RecQ4umJT3Mo7seWvcSdvT5CgKmCTpZCHP2etaf+g/0xlWtCLUk6LLbYhCcLARC5W/BvvjjQgpNaQmC9dQLpyGU7AkAgp4Ix
ARCxnaI+VFW1mVHZ4NmXqNWK7l5WG5BXVSRv74GtY7MAbjjUk+MD1nsDUg10rxrPN/ZJi3wileK1/7MfbvRzz4NOxp3Q4N1i2n/0
x51X3z5fWSm2HKJgSYoUqS0Ah5ggD0KOurrLGlI4ehUha/pQLW6fr1GtjbfM4yi1LnxUUs7hFRDAl3AhWqIhK60Dh3KDTnaTco4A
FuTj8MqE7Rj5+SVJJ8Df+eaYUMvWYJyDdmUYhedblDdNWM+1doCXQk0WTN5NHnCVQZfxU2t612tCWE7V5OU7peD3YZ4seQDTLIIl
iwfs5PvW5nlEHJaT332af8+JjVWssN2PHKQ1AIsZ0sJAnbEsN6fnfCBIhd//uihl/UVVHwp7MAyKjD0fWDvSfrPqKxyOwu8UAJ6F
qKlH/FlftWkyZeEuzqR2Ukgrwp9xfIYbpYVnLRRVeQlYO/0MtaW18DVf0qKxNdfXhaV0VNd3Wilj2i/tclnDd8HzllPTpn/qAVhp
Vvzz9awACOj+wzgGbxzmydrH5sQbF5UJguEKoctQBOVeuQZdGgCiZrJm9Y+rekWCbBVvWjVQaGCk+Yqq2pM6qbrpnnN3Dk1+Qdgh
+nfyse1piJQkNFq9Uayy3LjleRscwk/aKGiekgeoxCgucp984IQkKUuAejFQpQWtYxMpyVguSqdempYRrrt/kvVSBjpKDl2Gcw4V
2sm9eBBhBMwxE6gtuVmZr/H3MVzUDfuIxuHglHj0xUwxqVqcCILYno6iHWeBn7c3s24mtxx33VNUOpC0IrVVnnNEutP0kQPQai3s
CGnSfTZNt/QnUq+TgiKBm+/AKH4fbllic1kn6mDOd7+PHivPk5fqB0Ea2t/e2e/+OU6pabzVrob2VaTzgZ+LX1d/AP/WRZctYQzk
huZ+bjXzxmeDOkoo8aAcUQ1iHAw73edUWgCVo78rkAU0E9Xo/6g1snE7b4rXsMULhpEQjlMpu4MElEtZhafWGNMvmD1Mn9fQZ3hP
9C9Jcd4QmqBHA6DCLqHC01zdPM3n0h95oY3KH0KJooSW3kXg4g2UhLcGIs/gHjzTJqBgHqXw2Ol2Mx7pBUU7ngXvt4AIv95fpTwK
HYBjU/emNwRYZPL3E57rvcP8uORZPrxZ5TPW089zfEmu5mLYO9XmKn0W7OCiRyX5Te34KndNgsxjzZbMAs3n31QJatMSyo+qj5kg
ZHcBl1A8hJjoCDRszASn7BqZhhPphrNUHi/vBvw84Oc2X4dXAQF1SeYIYxnfhIoqFUJWte3No9MdoeZ4Gj5IcKY2jdzgyW3g6BOu
xOqPX3Nn7ldG12oFqo5I3YujDT962QTPOAwGlkk3AYaBshRZmJP5Tcxev9RR106YtH7t3KU6/G9o75ClEgRjbLPjPsm9v2yVoRLS
sTZPRk3RSPJWTmFVWq2FwW/7RsSB/lYyEjy0jZZLit8V9DjS1gFTC5wgip4zIJfkPXP2ROn0SZOom6/q/exy9461mxve7pKX5jh8
9+ATQAcslASo2HTEfEDV+QlZJPhGaLe4NaNK9oW/7Aea42VfGSUXPgXqxHAWIn1omUhEbyxFJBczodid2vO30PG/Xc0gsFoHoqRE
lSdkfXJggjkh5gOdXWGHClT6fIGwwuu/0iJ5nZmKxqjD9aUi9FdPaBRBS21vONRe4dI0ld6advCp8G52axwnVvcCKXutjfkkT7re
O2wCODuS8ysHb7J7Hftv1u+WCceivBnnyPV25kFpIPQ0sO+ONEdlUX093rzqdm4KfMIKzxMevJMCH64ROFKI44wXQ8YBuKpxTkjp
GUDzv24EUyp4K/knKfZBHSeAw/BnFXqPE4rgzJ6iX3MkdV7pDWHY5SLBWoOd9dkoI91D1+1tsRBP/iONJpFQO48YFMvw+jIIPoSR
7BNiElsX0fRzeGEnW7FSZU1Bwu125ZV/ITeDFLL+O6GE4AR3Sb+R5rdPtINSWO55dgaeIHnVHke5m+1LB+UPEEHj9TyCFIJ7taIA
mvuVJzq43ZO/aqimNeThvS+H3gDNNwycJgQS+/iHT9Uyx97FnbiR63IRG3bhnO7mTaCNAkv9NWCG1jekknbBCYnsKP6c+sgqGAvP
YiYNe4OI4sVmbx1xrQ1bUmglsMLVNQmzhgEx5ENtDzUBy1SI238hyLd7P19+SRvWluplTTyvj0n8x6QrEPQg6Y6n6UafIrDODu8x
96V4rbXWI4bEb8nA9FV6dg1TyIPZ6tLDF2uxrp+S5oriUGuH6dVkrq49nmXGAI37dBTv1qaj3p4e3jtw4vtGrx+OtJtwy6Xhx6Ay
w/M6Aa2wO4bdFW7xrOkXbuGFR5b7QyxuoX63T8XN40Znyt20El1TayEsPIfJudZayrS8dQ45c2uOFoICLF3SYdHzf95LSZiM2NFP
IP7piNDg16D75rDgZXNnqYJDOsHQw3UWMLvEHRZ8DY3QkoNOb/cok5d+tE/nLg3vcxtXaI74BsgFdsZx0nrblQ5RMLKSjoyS3Tvy
4ATBw/3MLs28XcKe23p04wTBdkk2xl9yI55Kc1ZZZDUqUQWtyIQPSlg1H8QJI4FIOE6dXdP7/ooLZGS/z8ToRpE7onOfTXJLvRaf
bKQHvUPgGSH+W3148+ZzXzOD7RGOodKEdnEmJOEZQP8eO6MJpyjx4W4cGYKyC4RnwyVHfzznj7LsLWZgJrrzd2UdZ/+vDE02zjnA
i6edvAMBPfeAH2aA+YEFabERgxtDrQtcuO5JOtL3aEQUmKdYRXIqDnn0O8+2jVJtdhbJeBdcHPdqBdbxA7j5T9+LogU5rrVigW0T
wyiobXCh3CPRdCOTdtbPvS5/CHcawJcSmaEZiw0U4DIwmvo2snNoRCCBZRp12oa0z+Z4e1KbGq+UP7QVBdBfYrAxWgrGZ46ES393
fOYp0XQ46nT1AvcYQeqw2r8F1r9H+LGRt25BGfHaPbMrXzMKl+J8apg6Vat4Gx9O+V8axTBugjqN3Rq0rMy6m8MaIcfN6GJ06dkz
cTCToVPTsO+EYuhWZrDAoThzKH4lPdi+qi9h6g3VU/HIVsoL5ARR2BGOvsJdJx9KwCjFlMgCfIQnDxUClP9KZeqLiQ91kWlnkZnI
1RuvOUN2GstJ+VoyJvqKf5rrU+UDI95AIIEW4XIL8/k=