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
be7fc5438c2f5fb388b7431c3d967ea959bc976c4bc81123a18dee68a61febaU2FsdGVkX18OS1hO/Gbj76afOk3KBwDpHucRksiQtxYZg+413j/XRgvFspbnHTPe+DuzPAm2wc/5YPhoQOJOTwHbUAeSfK6w6gqD
5lZq2peQD05Q04Q7pnjCQmjY6xjbvRZ+hjXEvF0AyVZBW3pZ6flnmG31YM3no9WRraQm/WXXcBzlqOb3nfUXk3eLA1hC+6pZjv3D
gx6Lb8UjFfxAPYEMH9rCoW+EbQCWIGOxXzowSQ8WiO5mkLCDKmAW5FLZIaVVRZewWUk1WNO+7aOm1opbctmqLNuWaGcJD67tvWES
Zc4/SbqfKbhhPUbYDrDlBX8h6sXGvoZzRStWzXPFSi/UwJNJ+pNhhVrYsGCV2xzQohZ072ghgJxZ0IcgDFQD+mp+RYwE0V933Ljo
+gGz/x+aLZ2QEOgB3IjNyLChSg8xBfGSwhGzFQC6hlklCGTf+gW/gzDLRdNUMrZ9c2mw4vZvmCM2aRepXVoJ2iQ6acfhUv1p7uJT
DBT1QIrhAt+kb3uBRd77jOhpU/E5EACs6+SQIzvrYAX+UWAwnAgvV565bXfBVsjYcSKj3Nr27l/SaKFUzZRJcenFQvWIUDLoVcZl
63JpJCwREbMP+QUdOniYbPnWdRD3/DhV399oVE0Y+zXcVcWryS3DP6996iBrNIWWfnaPO9RXgj+ZYmivG2hYcjiR9y4Ir0u3IdBh
jb5LPcY5qlgcjvK6tg+OvaDDbh5dZS2S+ku76EkdM9rFC5nwOyAAfMNMos76wEUs0VqdJ6uglMvaqEQi4troPFTNruHIHmVdDJYP
dI9a+t7SazLQ87m2wUSbOj3FXUG9V6k/pbIZYGJlIlfcP0m+V/UoHWO5BSJUmqM9SuFWQo9BTBCwFEmg43kWQtjGV2vtppvB/zHc
rk0giWHDNycOgd/rauGzVmgcv4PzCpNHwNHfMPfkwDQBsZPrCJgojYb6vuYErhyeGGUgW1524IdAVCopuvmCUWA1sWul4phFRf38
GCH8PjGKhP8sR7l5hZBsEHYhgiGvXRPxZnNs+q9wNeGCKRxtd2tpskhEp47q4ERTKTJldCyHEp3qnwOqpsFPY74NDONQ0vXod5Cd
CKJ8e5uSw1emkyWDYOQyiPCjD3E6SwK9OKFiKs2sjVIxJLyPUyn5n0A18DZKfDkqxxnfWCRFo3+M/u84FUpmOSQXLHZrbAizoea5
pS6fmvwWmtURxCZ6z1CI1KFLupBictK5FAiqHQfbtRvcmhneqN9EvEhV+kBaOjh+Cci8sT69OnC6okqK9qKG9uhUBzP9m0ihsY0/
2OyNQah+oPPtiQMB7TwIXFcf026s5o+4j2bYwLx+/mEurAUqXOjyn077+pTfCvIQQLPSyqsIGGdpB31HBKrmrjKvPYqEhR/Dbm1b
/ECJE1FckhG2HA8PrEAC3r3T0Vp/PRGw0C2lTtxIYEoGHTEtQAVsDGYF0oVhCdeWRZcy/1J79nmpMTlgPlIJtlSqYxlUNUICgMux
UWUG9y0z4dFrM+dCJCWDWdgJb3AY7zleJ9vcuLrrnFgmyCr1sE1l4E33TW4Mq50J1p6EaIwklOicGWepTkSruI5AM05HZ+FFlCzT
9VBbL0qar2hB+hB2miqGI87GUZUFeMc4LUQheG4GIEGtYBGLuZaFJiz0HcXo7E0tuzuz2t6K9ykpizoFfmvkMQn8iqZzJz4Gqptg
uehyrSYqfXbflL8dkWfwt3KIq4qn+0w2xqZZtWDs/xmSwQuASiVSYsQGkApm6V2Z3BB6H8s9sUAu5g6jcg3CfSMj1ogjufNXVvTF
wONUf7j8DU8wbUJ4rf3xDjSq3ER2OG9Ox09l3cQ+wSVhQ8bEK6ISGsfordQHndfLp0P39gxJakAzx49UdQhB+gh90LFb0cDzI2zf
cqMBS1vY3KzEupoNaBq2bcNEMYOBUOFQ7qDXwXJO2iCvZCv3FqNbDrGVl+Bsg4eW8NEb7YJamGtSLKf4CIlrAljZKrokdOSLo4Qm
zDFJ7ZLPwlTYjA8loZhR3//rlm8r07OcHpd5qGcf81IpI8SoIRg61TNRU3KylUB+ZWZ7FbNROYE8PUrqd+ewQVGogkddA9k4VxH2
45725bl5TyzrEp3LdSUBpqbgNNnBp8oTMRvDcGOta1XqBJ7v2p0P16oP8NueMmaYT9E4J9mpt9uFx5NZah9YQ7GNIENEC5zprFSV
OwSZzHC+MxuYSztyU8xtIkKckiqJXsx4PlZ3tGUJxJlSlHG4KqJy/uZ/mvZpi3yXfm4gEJXOUNO9wV3256VL6RpiryRo3mMyZfNC
kiHXE6FuyjmYSjntiBXx1X4aqqxfepjKrDZgBZwKSD2Lwj+aKjZimWbGEQRVxdP+IODKsHxaSTRawC22myexbIixDbOwzxCQ2Pvx
Ojt5ZH3yiPHtv2hT4Fmy7jpGyrtmYJlhuHkXBV0MWNGgrok1VVwcxoO6bmZdv8md3B8pB4CMxVaWXmdoT/6RedEBZQgKseq5vL/k
Kl/Ln3Hiz+/X0da5KnfTm/3fhsrywAPDa7DyP0SV2nw2ituXU5zG2lkTg5QT7uEi+FZV9lkWqIdWvdb4QBk3X4Cvmx7gsZUKYj46
UW+fzYfQvkmkwUt4u5g1/vtkBnm0G+SeAI5bv44l7fqLMHhF9bTRugff0w8e8l7cgo0SFWsep3YkqpMBSlCxL+0Q0wklx6qb3qcB
HlHU1IiS0ah2uwTUKqWL8agjqC/PYUHtO6PMh7yGUM9baYzOJdOSw397rIiLbVu1wn9XjLgx/6wHXShFxF9caGvcr60FKMw5dUBa
wEaiPx+15RzkbaWNv1QDTHKWAqeru4S1a4iwxsewDssa1oZiqCrF5uN9Lhwa7zbp6kNaFqL1SLzRDpzjXiNr9PpU/zIuCXgi38cH
I0zdga+7rv5RP8WltFihHC8wrZVRgbsmBSkfSA5TDzgSVKsgCA8NFvT00sPZKTmw8XojFcgEM1yit3u3dfcM5O1P5auZ706AWGRO
HeNbE/+jFbBI0zvakS4255U0Jcqf0S0MXbJUPbzLc0BSGGnyb9XInaScStaXJWXqwGJ5Ezh8RE0nLZtZ9qWJD9u0nVBL0zi05yD6
5eQQxMZ0yK4anl2F9iVC+Ah1Ueaec33cghAUQD0haBAXtHX0kYdiFDL7bvGmyYQqCRwmARwjFgAtV4+PPUK2Yaqe4MTlgS+3OcA6
BG7bBeZ4CwqWYQxkeVNwFRt8ixhYELILfNyivU2e+QK/znEenA9st0etZvVpzyxj/ezSv5blR2EyEscUaIL884EKlBHapZdOmje3
pJcpojIzohiQCSfusWi/8VLCuFD3SfSGsyZ2nxiR2FWAc30SHfZyoTO93U4qci21NhmD8A6E7uzCVtowPp1by5xMibSdg7dVHiZp
5ASd1NxmnZRVKbG1OjH+oglofHHOnG1ZYfN+cM5PigmCm8r5+khwayoTuhj4nTU4yOAc+gifPe+ozbdoAET45TuFGNjd0stSlHTS
7AIYDIpVU5OPYljku0O7ClxEVpNmCU3aywTdCqSybSP1F/aFXFEqEneNqMrI8qHjx+PzYyVGuLGqiUohZr6EPc5FXV7iP3kyz/Ho
buTHFxL4Vp3SzcyXfrLO4ZbH2EWoWFmuV4HZgkK+flMVYKP/AlYR5EN5dVdFkNf4RhanAs6wtCqzrJJZXxU8hiT4CTApVjSRJjtJ
0oDqXgrIHK0W9UNmw28al48lEMZDTOQYXFwlJvpLpsoHpbIRdDdMvTV0T3nXSGM95gkz6KYYwBbD4v6BGZ+nW58IynP0o5xv/k+l
tC923/P2/q70EWOe8VpgdBF9EzUVRFuw4ChfSKNTmak/Qjwpflo2w3wol/3RdT0FQSV1FZzo/6CqlYhhQDjrsed76kcQ/YuynVMk
cOXpJavbQs6JgvXshk7oUluNAjpyTdfnczXDXff0RTdwOONc8t+LSOAUlpOVxMWi5Bx0bQBQt+VewtY8md5w8sjeW+4tiyQ5sa/h
sus41aN3j3x5rl+SI8AYLL5VSM/TRWjpQp6ecJOQnEut2BAPKtRL1qodKpWG0ONzjAegzHV8LIfxO9AkbHgi3OX6KA3+fKXl7Ss2
b0BjL7hF73sOuRXHR0z3Aq69UzRCS6TVWpdrs3jEQcP+1xT/huqYPqpp8WtGcGspz2s6v32ZaZcyLrFnsFXvlSpjy0T43rzNs7ay
9kU+l71EvJP0tHbJytEkieqw5CXpWfY335Jxq1n13XmwBk1jOcSonNXWEZpylSunH20SRhSjm8J3P7iWx9z8vyp9j7hBwLm58A5w
SvEwBAfCOBJohi50xSSN0L7esjew2nXhC9Xk0FuDFDVrfJDDGY2kMcaA3DhwVa2wjPtjiCqjzVvF9d0Fx2BpFtaIFBRXs+qkf+Az
9D+tXLG/XF3cvwQGf3MOP+Ew+EXblsK6dLRIO4ZIuPoF3f8BlCwsAgXcxzZK9KqJFttJMrjfOB76MISU0qFi08109+rssPXMHRm2
07Bdpf7HUcdSO98ZM6QSpPgzu1RnR5+cm72OWVymICvsZ5qY/FF/cbchMiJ3S1dC9D72XosZXDm8dTVq9yfbKBBDLT6u8ISqhacu
2oHROosLOzNjUTcuhJ1MxX1Yb06bjA/dMWDKOnv2I0NU2RSJlHcsPFpDp+cJLfMxls8dGXbpiWLcETtfqGHt+0nAxy90AsclsyFa
aSVEQYdF2BfE8TVgxeHCqCIhSZpCUm1GybjU7ChKzlKZR61PSLxoFjKSS8uycYr5F+ODtB845zlPaH0=