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+bABXAik7ogU62e5hE42+xIqYSuHC+HpYiT+CX7RddaYNB2e8dcfMOjep0CFt1P5cF1TNe1nh75Lkhjq+IngQPheDu
Zvd92amdbI8eZIHLFe1rpAPLDqvxhQg8HrJkxS3o2Qffel8qnzOlYDIiM6ovscmBp1LJpduCCPygPCsCPn78QQkOV5jTeMSClh93
rHAYaLrgS3KdGDqFMAylAbE4yKHLQS9HXI5/K7a0X1o9g9ALGK8sv0RzUshOkyLloNtlssxHuFzBQfCd144vTt171mg+8bBqS+IO
4Qq3+sEGGcfbWBOd8GyyL0N+2WFm6wNgV1yEArdGp8Pv1YuQOMKTlTUUcp+FGcXarladRYBzzGU02B1Govi+1cXCsoTZOxUxOzbx
kg7LKtTQzgPN0LFkr5tCSAbjjegVkUuvabXcI0Gc1obN2Ot7lxWC+uH1jra2wr7OKxqY0jqsKlqt30ylW39fmF8eYFXO+6Abc52L
4jUO4vCA/AflT4YBHATA1Nrv92pnpVM+tEDQPMMjnTS7Edg4kg+2HWMImtHXCxJAHoBM5pFtd3mocWLYH6dBG/HzVWPHcSgUfQS3
vLi/gvMWg65T149ne06ttoRVTfeGlHypC4gm8khFEmV9xpvNddOJwxrHg+kFm+kCkh5HkFNPGmkyKrzp8KBu4nzo287p9BxVXA+e
M+YbxOYbz3pHn4qxLIiDByMjE7X+h4UhCa2qA5J/+qzaqvkl9nI+i9Kv2b18FOuWog6lRFXWrgUFnj4bmTLYNnmn+aNa7IhYHdkX
iiKHOVMCvT8jPm2m/K6RWjsuMzgTRdN1shmQsBmYS9+9YcCdYEDr6qA7YEnmipDNfvyKUPKsm4GIEWOqYR01fmbfAtxhPUf+e/yh
OoRCHoGe+Y5Z3/lEx5/mGnwd4Jwi2G/tYLOOZXzGFsFQ+wcRj4V73gF1KnVAqWQmS+wJijYtvaUc9hNDtGlhjDQliGAqHDFbk9pd
btRXdv4nXazegvi64S7Z48mJ4lkroqRBS9Wl+E8/FLOzjL5fMpkJjUb16TNPDlSBpTHmrcC+JtkbEhxOUKiRyCFW2AM9mR/S73Z0
2JOAPtYKs/WU89KsAj2qUEehwakBAOY9RIIMrvvyafpq57WBKseK+LoX7lW/ctX4RqY6OQtz6jfZ+kUdQuhubpn9pxTb5lXEnQMU
prn/RtFSgYLZj0v65uxQPcJAUYQk6Ba4pThnwy/L8ADATy2sXjaHWuCmiHd1X8FVs4GBHi1o/5IkOOP+U5ltKXzIE4pso3qiiNjr
cXg2t1JwZjFTX89HYf1QxZaXOztj3YW/ECKC9RLBmbL8RdiLT5ymo1dL38rSGUK9onGl2tGsc1CcDv1xbXYy9g4x1zTnpchqR254
BIh4qf4LnAxwEjo6jMsu3JfRjXdTOQVk6urOQMhusWqo/U6X60EGEivpBgWBWE+Asgbk0BzIMQSsIYQtpxfDv1Q193Vtuna20ONt
TnYtB2VeO/kSO043CoCHHSOh7vnkc/CRZp3EqZPWMojaTychxnnHyF8cd/VOGYpgSdku3WsHYlch/aWyYq8GfRnZo6dYfTULji0c
vgj3SSP5KTctfXvsDtr20YWgz5QMjCL19JvbKkrsqAHN4PYXA9S9X9R21L2wr1XvqSv4V328dK/hzoSrQTn34IlwU2cm7D4l3Ki0
2E8BrtlvA+y9h4DBhU6JLP9QAiQPe/aI8zIsYdz87Ovn2tcuXc7fx9LrZ5Fg9KLYKMFPWwAP4v6jy7uBNSkXXCzadRSr+SX19XW9
BEaEREzhghIMw+B5Dgxda1W9urnU61jsizLw9dYZxh0pvwX/CcsDNzZ8Mr69FL10JG8G8wsF8WH02h2d0bpLRHHUQiBaZnuIBDHZ
YQP1zpLVNHtvAv8+Drl+nS+Nayq/+Pj3I7z+X/tX3CoXW/eFHgQNJY5J9yQFBA7v2q5Z8PovzMggpIne13ClCrUdXtmFgQ7PDPpn
JxWGtaBvwHhPRN5PsteeojTHQ1NPLg+hroDWaXVfeZWG+I83CmnNtpAGWLCWmFDppO9X26FqjUzdVJxzG4fMklW8v4KDPNHxt+Qh
d3NbZL35XfYOsq50J4xJtfv7DAyiZa169fpk/8agnhJqRmjtLJFyMEReVnb1YaUy6axUU1a275q5g+UDmNosgdOujFl91eMHsYCd
y7IFx1oBb1ul3P3ru+Bnw053H7Pb29qoo6EWXqsLuG2UydJ5e5m+sMg7lJ3IuzDikAbPjmOL8g/GSiaNlsnyczV/Btd6QLNwUmNS
iFx9ZuP3YTSXV+VQHmTW7Po6G3cg7adyaRpmmQSqqX1R011N4a23EBYCxLZuH01zi6DWqYg7VVepWPS8Begza6O7qdCnH9JDJ2NE
I+9nSDbmru/90YbPqFOEtxxX4N6mX2lEmXz9Mw4tAPb4GugwYIkzD2Pm33s/8cCkri7WnRbSamH0gbaC2tr7tY41/G0ToMd1chpQ
xa9MQTTSrZjU69H4g3bH54tEqh9ahKVsZoxvuGTc/6KyChi+y7L2tHHnbwArYCKgPFwu8u0q+jvT+Mn09JlJe8H4d1Bg5mVyPVNf
AVfMUzOtLQwp18TluVnj1MsL/BgfqVk+BBU0u9kzQlrPqXbOhDiWumJ/Pdx7iSYUMgRliZ4HPZurfwiGvU5q/j5eKEt0cjsdi6ko
qm8F8cSCvfDhbmeEc70affw8/bbRJdvl6swK8ZZh5+ICO/j9pekpEWwqL/oWq5f2ANAYNWn+WLXqGxxlSQGteB99SOOiheWkXduE
CrvL6qwHhSXME/SYeotcFW3FWlBVsqmfILz4yVaG7nRoBSmMVj+koOEYY8gYwgP7KwHXMcYoM/Ct6YuVq7PRS8IdU/EyFoe035St
piMSsPp8hIz+C/CKuPvnx82KPKR9UzHgTPFFesjW3zKVlOYmqLc5jDGQCtAIoVfKlitanWicGSe3NU8hIhqNWTV5By+nDuszZo3O
EiJGc/xj7MzRe3dhWKb9e6fmjUKjDd7t+XNiwoE26kyBxyjVutMeOOg8cI0nvWJpJHHbTwMrAnc1QlD3I8BkCyCPk3kaT+NjoT8r
/e8V1ZwTy796s8KBER26bG358fe78Mn42svPSd/e+dOLDZiOScAjmJkWJEdI8m/CsINWKKqZwAAvU82pDz9uAjG1J/8cM2fFHKcn
K1y4PqDiqaD+0nI48B4vR9kUPWNr6ovMo7/QEWmlWMZtDQ22oGsgTgJETL6hDirAfmnNXU6fpty1/6z/V3f2nyDQYWCCvD9TkTnI
GSzaySdCSkbUQzYT2DjyTXPY+cctAdWvDEv2Ed/3Y7mLS07UVV67nvi/4hRmqKeOuzEo27D2iCbdEAQn1oR/xWnJLBFZ40lFMoAr
voMVUlmgPIbO5c//LJzPPIr//n9EnQau0zn9VWqbfpRfgGT+ZfADCKfn3r1jS5tHWWdRgZ/t+P4pGB60CHsDebnRaqY6n76M2wjV
M79xshzJxYc2c7EFnz6TvMtJYoVXC71NNJHuboV8YtN5zQz48Ta79QYvfoyGX/L2aOBv5Llp7ACsK+GPfLjJz+U86Si2fI6JFa0P
dvCW6m0FN5XcnWpV5Q0i/4bKB/g/9/vMdWirlA5tZdgokUCNCpqk7j1NicQqKoYfDsndyCHHIfXYqjeMhscCx0CukRwognEU7PXm
rLNsXTppHSR/duRdv+rqdryV2sb75Qf1hClfg7+9Hp3/k1bjQ5Dy2vHcBVv5kYFdGnLB1eb9x0WJtRLj5lRmaHJqo09nGM6JhJZf
Xhg6Ldm1PnO1aEdpuYHZnyZMfOwq7Zq6ty5V5vciMX/MXRWnO+0XacCs40Jyyeie8jptGNzr7qnZmRr/8j88iIbQTSOBxXgUja+E
EMw8mkXnGuYBdAUWZGBTN0AxtILEYJY7F/zDZKWG2z9+DVuLn3vSQWm+xlzbg1RD3Yz4Z4IXPNlM3Mcxk4f0W4bHlpixieBts1Lh
dDh/A3id1MUvgHCPPVcBX7eKi0GAneQL5lQzJmYB9SrwvOqTDtaaeWuqyPWPPETbNvyFHdtPhaoC4/ISWVkI80cUh5NM17bNsKQ6
JqUqWhZAw50RA4nXcYfgYxTpRpgFbUHX50JZRgn7ZWkZ3skm7wA9mZRHAEwb0P4tbxLtBhNWGkVjlGEzFFkngZXTdnDIQRA9b0/u
22BEB5/eQPeTyFtPJE5wmr/LGREUqKbNKhY4Mki3YEq/lSbhNSZMS+cBuu40Gt3Gzds4Wp96VHzW/X1gf+XqVt1N4cwFc7rCwAR1
hTfQLh3Ez7FnSGycw89mqPfo1VIvR3AVa8AMptwtp8pqyQTGq5AkSAlznQpa3k/jS6R8waGfc+XFBzj30yC2dHbNh81Rl0C0i4R8
RE3c2lUl8DABM8OgRnOhZJpdTCeMxwnaOAIWY3H/kuWm8BR5q7EBewaLhLllPN3eFtff4p5wU1dZhlSJ3ucwksQN1493AcYy1j0p
NdQKqTgyMjhDUwqtWSRwlB4eONJNHfT6y2p9FWGjK6/MPFrsZKnkoyEF6gZ9fnYzEM64pCLkGG4F4FOGCLeZDDdH8y4d7xipXzgA
XFn/hZn9cPnA3uKscTfFORHeoai5nbvnx2YOr7vNcYBlvXJDTHI9COnNKze/Wh5gm/3ayssIc3PlanuF2nj8UbzyVCNH0lXHNKX+
AE0VS/L6HbJIvAvIBtihLS90oogflnUoRNc7XR1jeYCMTBWHyWs9sV9U9oa3x1Auj/hCGtOLrcOMLPceXYT9ZBpLEq2LiTZr6O8p
sOueaZqR46GJl2h7motpqPqilDbmEyeaJ0l+yF2ZCss=