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+WjKJBo7szal3qUEy8b71UH/4edjC4tzbqa5vifRGR+umvETL8B8IX+1ffRf5Kqn7Pje/bWqt7irvopM6nTHUMhi70
xCGLzVbA+7O1wtDN/9MvpC0qbdVSntgsaxt57hN9WNeqjKHJLXgfGwUlERPfXtlL61AAL19Mi7sK7DqQskbpngVHBvXp0UlgqYGv
ddIA5lKwVUOxIBc/MAqzQyz7WSkM7y4C5rOQjJB+ydoNsHkvBXJiz/9UiegCOkCUmoo5CgAhhAwl0n24o/Go6TpFUGIYhfgrQcZw
Vcy92eT8AuY9TRZLYlOyDuAz/7u/kKmxMK5apF7bG2RFSZC+cAjr+Nu8hQWGQBev3Enc4tgHXd0H5753Zq+zbPBKQBfMxRPLOBzI
0euPTwQ7y8OcmIEgLLKv9IQ8plzhoKPy+X6NZxKnybksE64nMQ54AeaGisdqKKgcYAmo044aXOzR0ExtIhvCmRj9goqCnoXVVeDp
1bkxd5JnNZbHYl0TadIuH4hwc8I6nMWuZNOcN6FECdt7vSI1WzG0H5YZLdrOBOkOBE/Y/ygfQ7m8RxhYrbpl2U3hFgxCqoGElB8e
OPvzCH2LKQNE6ITs9ZpaULekSciF0ROzZ4vxBF1aIdyR1MkxAjTp90JVcU1qr6wz5gdLMmBd7uwA+GPQfuCY9eJuQbnshTSMYZVP
I3hsNIWJ6m3uLsJF9yWfdlI5mraX+6bhb7aGZOM8hIUiq8TIOQhaN6VWwBBxeulehnJi0U6Cbw+WNmz7DbO/EGoLI4W71e2KbxoG
WvzbgKQ+6YxcTxqwjiZ9FGYtUVPvujZ4atiMnfDexDDxr2EVJYFonYOHFXSDM5JJsdCG9GafnG7ZnVKewxtENhKAXfGCcX0MHQEf
IvmzO77PZJRJx2Lc5DdxvEAuYlzQNgmHa0dO/CLGjEpQCsH4vPLpqTQzbwa958EMUCqAGeykgi+B6TzkebQlFsfRYXmlD3ydofmB
cTM+Wk1xbDUONzHZDitRCPlrxRvlOyljK3mtZxx7sRBa8Pmc4Rl4sySo//7ApD3zbI8wdtPgQs8PpwfG5lMAtVSHpcHlptMBpQuE
OtwGq1RtRk4CXKEs3Jh+38twJ3F6/GfRrPzriqX5slcJNi1pMvJdpSNj8vQqdKneBRsLwX9zPdkuGRxwgz9H0cAFDJCtS+Xiu9LY
kWBMFAkP84ZOp8X/PdJK6j/Km9k2diEXmDuv+Jl0GJn3qru6g7c5BJlanfaNwFrMYMJBDOjbVj5AkWw5xpXiWSilb3q2cKAATIw9
ITMdeMpdhM/+edfBpYp9cWinsks8CHmb8xCLa/MuJ0GfxiXGSafPN4dvD5n7uAbD5CqpNGudwYIWYpSki3gPc9bU/cx64VSshR2a
F9LH08Pn4vbd99TDqXS+jtlF5pWkhoPmX/F44HflPCloLuIYnhLu7bMUZOa/AU9p36NzoKFh+Pbb2bovJ3EGZA84938cHMcvccx7
A+MVj6yno5dDunlLNX8uVJnzV282G/YDfyQ5UjAkofWpZJyRfN1Qb/+WUokXW2TkOyNzi3diXsVj41oOrJvg2Jh7JgJzu11NYOLl
xpFSUwpyan0ucb0ZxAntgJNQZuhqUUNd8gYjNgwB/QKQBJAuk8Xv0M/xTxfnsmMFCWMJO2NvQL+r2tUW5CmlgrmbKyHBznjRCARS
bd3gGJpH+1ZOSgPNigX5UNUIy4pIfLkaB6e+WG+E5VeMGz/+UIW9bsXHC11c4IObyeEgIIczkpM/Gp5G0b6cPuiX8CnLXX2pBcOI
GKHK7ZtRpkwmqNG75OY0/+qeJOv/SakfgyeaILAIkm8V5E3Oy/dKWpCNWd+gquClhRyNZV+K6REmrR1C8/kfQ+CvxcP0LkcVKAcF
Xi0sM8uW4ObXYiG8FDpcb1tpFHJd4313sz3Ms3sFtbLaM6JPcjcGuD2J/5F4Gy4k1mxCb0Xm22KM4S+y26h/k/SVvI0WLtrqeXrk
VHsS6yvFMxZRVBKuG22EA+hH3BawWqg642w6Da/T3BG/YCkeiYZedGA9QlqTKPSjSQDtSBkQaf/ealkGCuJA+mKGt8rtIqQC+trG
wkxaYhJIOR8nyVpDXtXCuEWfSRZqMPnJiVtnoIvx7D4XbwUEAOdcSN9vQ7ca3ChZccHZdFDCesdoHMpV1YFv0mn0dCHqjLsdNQi9
gl2z2qMV2STWX6loivRmwfXc6FLylS6asgNXXaqpTveINmqW3eAClTesQ4uEByip1tctc5AnnwT28/BxelfG4AEdF/I7kVcKSByO
cTrlcOpIjWS1WltDJwyF7P1iDEQ4i/Y22wnXjpSNWQP/cUKdQ+kNkTHoUeaVrdKqZd6STQv8pZJ/ZQiVkKYIzL9izbJVPCa8uieW
u9Uwaes62Wh3qchRroI4jDwFPtFeqzH9dd+4PoFMqyL8NcBH9gU+RBMy3WXy0+HEm5/P3G/n7iVh14xAD1jDgjsqxMukeFGKSIQ4
yZ0YeK0pmuxrMVbHKmrGU9en2omw0n2Shf57rhQiFSfzZPx0dEdkkB8MSrtRE5Zi/l2p3TUMufT/Z0QM+oW3XtHwHQT85kADvJag
nIwxVe7T18FR/UxCe335aa1U5PJJ8utIEGkQBOp12Q7xxJhJZicJaqMYs8iU+TCrUj2ILBBVndX/EJveQKciT0qPsvy04lDN+FXj
u2gW2fokDEZWSM2hRzhsMgleD5yrSkaywqzk54R8CkYGK8rMfZZDoDyufKP/QnDRsjPL7zKrpiGTiLVWMsKv9KH24F9Atqggx7Fb
xX6hxkCozwrR5OlAgSNG1+zwi8RtI3Af0PAjF8qGPfwGohEJB02xK3a9dP+4mYKBf+Z8mwbQb3r2GixAQkqBow4y0e4NwlzVx6lI
elCmFy26sfM8RzPcZRmkQdVdpqxWyR6yi3rONsEoL65Y+/C8t+TQza70bpGd+XCo0JJnijLJQnUJiv3emBT4y5/dvH/RG/JOavzW
zyWxHw7/6/NBkHsuGgJT6P5wsGm/DY89RMlqRO7/fsqZnjBg8w2vk8S+tNnEGh9eOffp+jZimzenZRmmcRwC6vOWIZqbz1+oc2Ws
hs2PXAX4bl5pQJ/ZUbW/pTJUmjI44UGhIwDIOe514QmDfsrp+VkSmhpjwAGluyuc0p4Zne1bjZ3s36Bb1oQIi2Vua9JFXMLtfxTS
7wnAJOL82/7VH/F8zrYVRu+v4AhND4Q7W3OZV3/hUou8zUQ7iSdhIQD6RHmxESzsuC5/RtcpPBytNr3WKXdEcKuC6L/9NtYKwb93
+SylymXIJ041j6I0LN+PYEDtYwhmtRLNv7yx06By/c4ERgMkyZKZp8M0mSOblc2rEtGnyDx5y0M+z7zxeYIsDQOQDnzx0UNDPqyZ
GfJmQKtjrBvfym1MNKjLthdwvxKNvwNHnwyID6ru2QUA934xM3ecwEnxuEszkMw8mHIPECEXsCy1eRnQISTT8DTJK1GTaJvK2gl+
H3Lvv65MvpB9G0pPl6ZWgHMx/jJSEf0L6HW62qX7Iu8zqw6KdNzFpOT5hVtntFCCsQH12pOHdJgYu5sIXJvK+kc7n0Te1edEeTId
jy9aaptLuUKAtUYPvaxr4UQazCKcCDbg4hu0jkc4oVXetgVpqjfobbFzWogvhOmByd4EGEzkgGHiW57j4dNjhbYywS+/ee0vrPIS
6fBkQnwSVxuZzSmuaTG9ujvD4jNCuF16M/mQFe1z0FTZD7vLLRFUwH4cRjH1gBXF0ibUCBjSR5oaoUuJrQzo4v9mN0SjKXwXx0Lr
QF6RbiRt7Nsq9ThVsEUyFPJoTCvw43SW3l5rsdIIe4YpXwfqTBgwtgD2BnpgwxsWJwntZdZxqX4mv4k71YVCBz5csheH0CcxyQL8
A0qamK6jJm5+zkJbdZ+7lvny9ABsjpCYP/yhHcMmhM1/q0mHndpLXs+RHDA8JSm4X/TLKyA8ZVs6g0EaVrNV95igayMUIu9nq/Ia
P41w29M45KO2Edp+PhdnUYsY+4aThlcWz9A0N2UNtrLcW3YfxMda1g+hHATQBpt23n8XuS32dEOozBrma2YdsqLFlLAdw0s8FNUf
tM1xSYua0HV1ujRGVExbd84XFvKH4Nq5Ry+tXBd4OyHXlLL3kWIKRHj7q/a6F/uhjIPIPmh2dITP8fu82Rr7sudA7M9Dj5Cc3uZ9
GJ4rQbaS8Kp5/JBZm3uLi078+P69ITz/mqgVHJVbu4PoK/wX5NHm207HMhp82BYJJe7bIldUzvfgd9ULQShIeW5UO+xS1bDCMS3b
mcKl6rdY+r0e9FO3QN4t1YZgGOK52FpzjpdNLaDcApkZLfDm4E92IR5xD636gkdlmeQpDaMlZyoJwV8CC2NhXfyHR8/KKGSqqHxk
pg6q09M4SOVIgVUHfr68Gyn1j1/YinvQ+w5//GFFQ6Ur79rcWzSTw6lyu7rP4BsFKa+l7/0t3c1wgDvpNP3F7AGxOWdUi8LNyQNh
wxWbZphIe4C04voXXdfHI+wD1eaee39T9ofuz6jKf2sCifmLP7ops/Xm25W9DSs/dkvyn+xzUfkrYy3bmheuXTRFyAfOgP1XN3G3
XHKUVdd2Of1r5oDIxs3TD3irRnHHsZXG/20WlGpfhKlfYa/YEY1YeuDwgNoAYwnEqUCg/9pECn7PHuBkVSgdmbaL908RURdbpyFN
l2eDFRZeSZsKebEH5oktBqgakYDQRWVHznJ6J1/zLb6NjvlaWiV923pjPgRrF/kEUDEySjRNfV/M2QU=