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/ql5nJc1MPOAyKpQPabSl6IUeyzojJKoLEjReWhLyBDEtLy5EaBAHj1Lbeffh0cu2yVq/vZ4yigAT0F3jP8vevLwH/
OnxUImrPTvwEnHsZSf+2YLIFxutm6jFuXxT9HRVm414s97yh74UJBRXRynC3e2UiWQYKffZfy1JjTG2bh8vQ446klc8R9FUT0FI7
Vyu37JbQB13w5UWi+UUt5PJBsib734wQTX9osTwxu+vSrSdKQn1o+XunWZC3hdfGyCRkq0MKcYtvYsgn0OoRcH9yRtvNPJEuXDA9
BMn3oWjw2DHcVHbvYsJukxt0jn3og1+GhALAKFZfutB/A/e0xuqZQ6d7v3S+k7atWetiMVaj7w6fFglis71OvcI+2SNWieNXWhj0
l40zNY/XSyIThI7WRawDkz01u4zHl3UVLIdQA9bpGVxucK6vdj+W7uUUTcdSFGQne889sU1LjqOcbzw4ZdfsqKIC7HOaqkaeJOsY
U19/zlC1ReVuXaa27sRoiMikQZjMXxovyuQczmmzmnkA4dES939kQ3W/GwEvVWRq8FK5g7iKQrCQITwVulTz6R1C4prkJaFeNb5M
T4kC/MJWS9PaMhlVK1LbtLfE2c9CuVTj90ZgTh0WvNyO5xy4/oeCxvfwKnziHqe6kibti5Y51uzvusCetGBuIjXJZ008hs3HkF2n
8fGR6qFM0ptm3dnCG7usfYmoDV6a8pANyvSSNLUg8WgIa6HAMp5cYMvC8NbipJn9WxIuCwmq7vee5b89cxtFD5w34mXacD3oGkJv
wk6wQmiuwBr5ZYfe9F/J3Dx6T82uURrIK+HsraA/Qo83I7sibk/b3wowgzMzX5zjmAfc+GUl5yIN8h8PA1boGUaP4jmF08xt7UvD
GSQvQa6CiNnvhV+I++owDRm3itfpJKEVdsfwOsuHdaT4vRnHBqw2au5qJDfK/l26RWn+bcF5LkrjbO5EVAR0skG+23py+zFDNoZa
2/cJwYeHhUnDV4dKtyh0yEbWtdzKVMNZcWtIKg9HE8pjWOsXGxQtv18wiXReiFOZpF1mPMv4pxNrfEHsF5Hjbopt38gi+/7I6YJx
tljp5lG9ZXYM3S7vWx89WFrFf5+3xFdl5aJr4DR1T2g82plgIXDUzUSuUa9+4qgGpFYiUPvnIPbmBrU2AESBwGNe4utJnGM5txzr
7G1iiRFORhNIfTqmD9JfJZlXuPGLDvuwKbmd6U0ydJhkJBbm38f8VOA89VL7OV6rWCq1F1HV8GG2RVqFLlJS6n+1KQq68Gv2nx5G
CX5pAD4nKI6EeO5vocZ+nCIwEzk9TQnCDdH0qw8+ZsDLtmShst1iyUQo6ZaCiaOOAqlGDHgby+DO0E64kViyqMZZ7I5Vlc1KQ/Qb
AAYXLXF5JRKnwL0t2HZ9Q6dVWtsdNCxyum7jQVGTn9etowtd+z04l4BtvwnIC7+b6RUphzME0+snDt2+4DU1tJD8VibYspJJHB8d
BAeySbpi9kwh/2aHW30cVcU/SZJqS/mGSQ59XMt2N0Sl94v869JglAFo9sXNBEh/MzNatqtQfbiQMtkPxYjxhjMGB0sXwzgGTBSD
7ZZS02l7Zc/yRmBgsWjMrwyPwz2znsSbfAWa/ij3t8RG4racSOMhJxnYocXpfO8MPV0dSeUjRzjXFgjzNqpdoUTNjrz08O3gS+IE
v3qHq8/ThQmHRjaPEmfvSMYvYYxOqHxBU1U3hCmqG46v3msnIPDuqLxyDs+zkzBSZJDBbxmP/zLzghF4SuSWUHuQqTvUisw4qWIt
3BQRhkMoZVMU3383GaZ0RbxxEb23Kas6uQIxVec4RYet8kPkT4j8EHq9/UcOysor1+IP91Q5K0Dcy6CkD/MfOm5dxXroUImbvleu
1WJENGUFqbpy+1F1dZfcspp6zpFqjPsjG+K/GSyf5xO7AzhV++BilmL2ADrlc9lheT6jE8BAbHTLzVaNyxHyJ6JSLG44OZl+xmRf
sm658vNCAv3oA/t0fxL+IMh+9YspxyxtT3v3w4mOM7PYjWIgdvdzZNvS1PgRe8vbNNyKGG5RLOVmF332YF9m2TwAHqIw95v+ARcb
XvM2cPAJ45L45+4TQKsGXEsku9BSA2hqIS2TT0IyqsvYR3at0DND82MnSrZ/qK5LPMKTHpti+z902JrwacMBWj/RUjBMye1+DpsD
54jdjUeqgtz/OnLrpOOnslVushz+fvNMm37/kebTVTdUbCIUnK/Ykx9kvxeEtyLEsWe2MUaxTdhBmrEFxgVMVzGy64UdVelrYD1G
RMd3s4sJLZ6I7jZyv22mAWi/h+AQDjNwairwBZjuJTzPTnXI9pxeUGpvcmaRhw0oQ/QPy03T+BhEKDjVIM1xpCfuReik4StFLGHp
sUEJgQI+m5dhbtW/di00/QDTvr7BQ8raJHiSyu3zhLB1JOaAQzYEiy2YTaCvADDNlwgislYDA2r5qnso2o/DXTcwyhwyyqINHXKS
Ec75u8PZdo92uIX44+nVxJsyoTbPif966Ra640IwWqM7d8Fpyk0tTw/GZSeNQiGGNdd273VF9ywXyRhh3N39XoXBMG9kVCOKimU0
HWjwqa5bkkFm7/aLnqymNl4elzt2jGzp/YOyOxJcOFTR8dxNc3Ls0gFlZxIuvhAaCkD+GpRKU8tBQg88CJlHfbij4qgPUNmUAeh0
aRqsyFklCT1bdzZSITEJfSK284PLtLi6hbHabmjMcM3ieKokuCcXzw3y1h4q4gmo501GIZP4znPv7hd3DPagIYApiMF2EN+jnV+X
90OMD3c1wSdNoAs6OwkHaPXCwRgbCp8J2HuEsckVRgNxyDowYCaTA0fzhGLmWsQbTHkyZiF3b20Uh/xgekn1uAS1BjCByS2pYaIC
M1C4KQTeGXOwsTdhqkfHh1UXyVc729J8dtLQMuJ2lQjwTJOdiRHPxjf2PrbTQdRUokGquuH9+rEavZM42gQw4nI2avAtO3pFicYa
ammGIkXiijO2e+kmuVaoBlF79sVD+9WmK1Y5tXjCxJlR9s7XkhfjSOP+vRdWxxrVxX/zEPbv+2lCzab92pu7aaqA26AbuTaeR03u
/YSuCXv3MLDUdT22Yb16dcNFh4lrm9BxTFXi8Sj18NB9raHIY31l5hQIGU/q+LhxW99YR8ct0ipcsl437erAGZa1QlZUjaF2y1Za
+tNevAHNV6nEcEzgGhEPFVYQyxNJpwQglCpcNazqN+ExZjhJXfkafyPNDmLtjONUlw4m/0M/dkMGxgRn+6tty5XltrZxyvRjJuig
DIyHN4qXHzChvUvBZzl7JIb/wctKDCREFWEK+SB93bVihX79+VBPO7X22UUid9GmpRPZ0lERKRNT7DLRO5y9vOfoYL4ZI31L6GhV
+ol84sWS0K2F3vEjGHcyYHdW2Jk7/t0CltndLTbPuBe4oNOVqX8HtX16aXS0t9/GAz2bmUugwAomPue5kW4R4oCiFZDOKiRlxA5k
TgQRphOJqgL9U6+EK2XCoY8zGAwOC0EiD1x8IySMZuD7vEf+BhKbKRQllTE8WMBaA6IZO/em1x8defjh9u6so9E7GuFpoXvOJvqI
YQhyuHTcVBy1bQ/OQjNjw+TF13A4csx8oK+oWBwZ4pnnOvrivs12uU5ifIeBn2fZpQB6xjejjJZI/TVWF/3nLDulxbbraCV527GU
fTYIYGdEMJ9oa7K4tdsz7KkfINUfps/D0dyw+bmOt4oZ9aXKLdJW9wrgRyp7DYGhgSucR+ZbM1aZKLz2hI7cUmcpaB2Vl2ozG16l
ifFUGfD8ZH55xDe+hwyJXRq3+UCQk5Zo4EHaNz6/AAgQdH8qTqweDr62Qmv4Wej28VIwLUFCmCsF2jqb+yRox2+azHehW19whOCH
MjSc+oqvhBdlhneW7YMlglaFEB+8MyBHBsO6d7yx9sou4RoplAiyH/VPz3Tp4XYRBUG+Kc84P7zMVJP6GkeZ87Nz3xp3kKTrwhFP
P6gFwUMsL7K0UhJ0SGi8CR9PN9iYTmxBqWf+DVRMMVj9o9wBi0uHQOox6i0qbtjRjoOQlk9ao0R+Yfo4qeEgtI/4bQFEQGOO1jkd
vKzvdIhE8i1DsNaNmA73VaVwlkOcofdpnvGY44XUZDTsSygML2bdfrU6o7e8ylGbap8TPtJbKgjK/sLXLudK+vAU+7UL1kfFfMJ7
wXpOu1nTmSe0cNy9bhy+TwmUcbsUSa4KjTcs/+2IYwV5iYmsKib0BMZFRat9IicTPkGCKUK3XHWyr7mFE1ZNYkxOIzqL0OfkeY2I
gt+bBj8Hhf71i4loOl+IXq23REJtJGT+2J/haHCU3cSmV7NvMNy8lMY2eC1FSYscfAxVfqY9R35nLgWhgMNSwslcLSJ1cs8SGrxY
yYBDuiFidDIYUj1zKNeW7v2wnQUf9tpQIksRtuH5Ya5qSfZ45c366PJ2lAMA2YGdeRv8cLxTectADQSCxO6PXVSHH+QtXJTJ97oS
yn99bBkEfC7jlXPXRPrbGO+IfFe+/mMHjFBbgPwf7FFi87Wx+k2WU867nGYoYQLoSJ2FrqNPWKY7ZA5S6XqvQKgy6wj9FEKfwGF2
QOV4rw30uH4YkFYvHFLwql+t9YcsrY5eAadTgxoVILnFt4NCBLWsFFOu0YwtMcteexIChxUMXWnU6Hk9utqTHBNuqWKFmbDyf9jj
BTrWSPyIgpnlBZVZzN292/g5v1aEqqUFiyvQBQCqa3OpZE0YpIT4zknvOr3w6TjgvySBFZItNHjnjIk=