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+xp9gq1PmikNH6XrDfxtJKSqy+wph+ck4v3xzvWqOnxZiGtZDAQCEs89oh66RYU4O2IqgUEGeS4TN0T/2hercGpmJh
zfI5OMT/TDZkB7Lueecxle/KZLAJgzCkrXoCqZsnonVCwIsyPeHsL65Uq2rnMfJDJBIsaAnQH0OzF8qY0kqPNcnRkOkDWEY5Zezv
xh6CsOuHrcHjhOeQfFoxPropxTeYo4KV9JFv1fHNmCO+kul+cJL+FndcFonHusbLmFg/k2LGrJ58ywLze4S4iESbkdngTz9l3IV6
e8IRXoF2wJwoeYPDOUKC0f014GOdytJWHUJ9l1nvev6tJ1ZijNJsk01OhWvSipfplqtoxwYtij1IS86WpYMpg4wpPENwwtGrvZPX
qv9TDrPbrAcqupA3azVlEfANSJB+jK2H0yUUMTjz3kukcZowIqJ4q1nzDLsbqth0DWgpNOO0xhpUP9M+qXs1lL+EVqbvgEz33hn8
08JcK7evAExAATVr5c8j3kSszaEHCwYX4xrSSsMOy/jG/f/N0eE7Jv99lDotvMixDjCGSalI29SDbAxEl7tYjxyRX51FG12P/RmX
YCqFNZBGFywfpRV66Ol/uRyRtUPfsScjYrr1gQ3i1SM3d0TslgoeKQS+Ct7dgbEOKMofdpapsVM8w28/1uzTouSINloa0+sVY6nS
9or9hB+ezplTQP4aYpc5CwFuXCKLMq/hNfquDztWjsTtaHau0yZOQlj7LG+/8ige8c9wfysoCJAcLVKpkgiFgpAXA5QvDsH2sdx0
bIJ3TJH77qM/dQhcO0MMPZmuarhXfcHbW7C47iXGFyKPfpE06uosHbCkJgnyHkYulUUUQb/roMqMU/9ktLbJPUXK6hdrjzxxkOhR
N8DY4jumgvax+NxAlvT3wPfGkvM+Nj2/eAStE+TYm512Z5Y1J7YYreL4A67QXVgnl6P3TDFK5uCRK9bDMi1MMDuU7KEPM9LoCCHY
iZKcCrPEqdJMrKXaAAFIh6719d4vKEMhDgAcUvvcW8e4GCla3KAa79Gp+cIF46L0T5wXyQG6yq4Sdh3Xg3GHqpaIpZDxdZWpJexC
orgJz7MD7HmdtNgow5tcnWfARRoAGp+msRAZDCnVA5/n/U+4LvF3aI+R7OU3ERLZYEXRyoIL9UU38elnrJ/AxaJpV/eZfY6/9ybs
QCS33/0huyCbz5tcVIsqGylw7kon83a4pUSh2nz01wzvQzTnvxipfVXyrNSlkBPAOdghzGITKNld5EmXc+ZQ88XHQM/xUSvsjA5r
fqN3Thtc1eSLQYvVZR2AVo6AqcrIv2fnzVj7s+15/TxjENbKT+zMbUqJqKi1BGSWVSbsJQNMKMYbzABBtg+GFpEH0skFyIVs5yHv
ixZNUWALFK0PetAdQFYcaoc1UNOQxyEsbbk2Ijs2DJYxbtIbMeVuHovfF5PgAyl/BsZZFIEd0Kwu0npH4Ba2n+F5bD1ILAnLTU06
f+LHDGK28bYfmBR9LE3IFdHsWqkyNACo81SGdcKtUEgDzgzWg/lhbN6cxDw06+Jz/6K6C+IgG1sR3BSWnFd7cLNS7yKD00LFt3Mf
fo931QDarhWB0Lem7CMH97cAOpiuXt0bMAs3Ztl2dCXJHS2JRurxc8WpymGkEwZ57aRmEprHOHWa9j0lcN85lFIlCTtDykLELxva
mgty8f2pcyrdyTBff//UAxlk35CVrrAlF1ZrDm/aS4IY3B3zHYXREIyf6WfEJZse23LVfQ3+I4G4kfhk9Yj0xp2ESvTw/jJfi4xm
K/9OaZHbOQuRjttrsNjimHVo1hWzsi16enQHx1EaGf1h1K0KTvDnmA0hTAGyRADV8EAB27rO1KGpYZsblhD6hZjmjCSHjW9LiREl
rcUBSM01a7FR1olHg5rdRqR0lk/AfoIt5FlYTsdivSV2jD5yB+0iBCYAJokTgSxF2kgsSBDOuB4RaOza6eO+y5MOjcFu4Uod4HqC
n6Zyzep43MCEjmZ7XnnBrJg0fbnbIzZN5rpdFAp7sXQbq1WOUzo5RMhIPju6kJyqktzIBsacm9ocBNqyZiCStFN0WQrEHC21MzQk
6QAVYVTS0LjZ8fk6j9OYzok6XTCKN6fdgwfWyXHpD2vk8vRErNnlza65UIWRjvJ44WkI0L+KhBU7qmnWDittuuAIjnsh7Tq+RnAd
B29TY3UWJN3l+SPAlCeVWTB++f4WOsnaNk5nEvxeyYcko+HrwpaokXFQIfU2RK2QNlDIDrDRvlqstvPgus0LkHWlL0WXg5cvZL+H
fngkQ9mvvemLtdT8GcaiFbKvIEn+34jU4TaDgg1p8Q306UCYyt+o7CObmALEy7YaxtjIPTOzxPMFjCTn+vjNeSGXAHNElGIdfFGV
ioKO9pBcvTVhJSoReihMrwyWkgh2I4UAIDlu4u2ZQ4wqdusYyU/3JZ8SfP6u0ixj4q4/jqew7OaE0D4o2pn2jgMqDdB7xjpXFhlb
h5qEy5GrvI8YHqBRP9jXzVhn8tt+pGvkgiF9XLj3RmnfaqrqpSCAAzGrreGy4KlZXMIOi++DBAYbjIRqP1cT3Xpq/+eRGJZqnfLs
CVgoHm2mI4debm8F/0XoB2gam1L65QM4xEI6YwvOWfE9tQux9Be5lUHlDeTMCkeDeUaG3Wjw63PVu7oXp1Js8n+hJYNXI/bi2wu2
2WPNlknUh0FLpntWPB1zyVRyUWeu6oCFUUve15MPVCH9fNsXbdbyuC5TPilgVAPlYERnkgVst6+9vsOHW7gjwE4+ui8+z/jYS9lL
4TujkCEwSXYskQVYfpxMcvi5gLIldcEz99Sho7b/DtGIxXDfYFZiXM/xSiyyUEhj/iQKvTP1TqL6EfxNR5Q+db+UkiEUmhE9CQEO
sw3hgajB737bqPDU4qnOTin3YAhRED4/GT+Mv0ArqyEOEqDX54BPaZJjDs4EaxPoHmXqxwN1SWHfRc3BE1Z3x0rHgRhoNDW5bPAg
6/Nhqp+1RX50TZ7vyieN2HUnBQQFA8AASueRs/6c+Ww5IR8BeThLZ3KFFKg6kc7qMxXiLk6PjY/aO0zvFl174HIwqloPb29qgSZG
KXfxY60Es3xl16OQDizF/SrgrfK9OMMzo9WQ+LkrFDftkhYEYJZtCdZFB7IDPfh76dS3qE5UDdUxQ3B1lv1HAexSbdVyNm1Qh16f
iGl+RoYG14uudvtBAtvgYKPSU713jrgmbx5STnXu7rYig+njeN34g/W18dpNUs3dkMk4RRpIcy7Ai8cC3Dk8by+vnVCfui3AsmgK
rNcfUaxxDvzIa7AWjuQDXEW8WK8C6Tn1kRaArLra9NhfqODsS7YXPM12iI5KjjPtRQHuP7xJSuiSFYDD7aYFadSHn7owLuxgtHGY
k9u4soBGDVN2KesC6UrrHRq7hOJXgQu9Z4RYy/pqO72tYtpExhhwfSIiCWVs2H5SGxdNLpMn3+NH5OCNUeBJNlCO9Zpmy0y5CJJn
3r91BCCmzWUjf2kjH6vNxnWVTGdnutmHLH1gSOlG8UDyGBRslKhImHRN25pNfFI8HU5b3xoTgJMm9YPM6tifaTuXrr+ko+OFxGoF
gM4qheDdEoJpDm4U1KLoyOxbDvFclX3i6YHV3XVZOohuTfoAgjTj8klYr5UJxqYfxwt2AKo8g7D4MLOGzlYUngBCPSScQrdIPDjq
FtN032c8vDIh+devRshyYExnarONopcAEtdk85wNmSsmTY4hSWF0dCT4xdUaPWBX/gmrjGBl1mV7GrgzRzJrECrrF6RRnoHZSx/e
+oqOmwdZgX4wwdoVuhHzSwDO8KUD0T9oQzzxaRFKM7RiWY0V9ZIOxME/iCwaeOsOMZ/zmP5pG3RnTKw1y5Jq1YfK2JPAp7qaEJhD
taPPJEnZxH+eVuQBJPZzhO+Zsgix4qKofZiw6xELw6bvs7h5nzVhRuuXkTp3I3kFflXA+ykpBTJ+OaIDofKq+V0v6Pp0VrTRx9zp
kuwTL23YilJ0b+SIpxXN4Iz3eUP6HJqtyc9mX1EZiX45QkvpykKAtcAsKMwvmc/prTI6+sqvp6jWC6L9+ZymjqSV6Fd4RfV0TYbf
Ubsdbf7AQA7Zxw0mbQQ/s8LCB6IR08wUbQzacuzV+2sTcCEKBo2LB5ZcnMgt2ju2TGc6wONBuJ9NMjuUWsZCcOP6pa7dYhneU+vX
OBwtOSVGGjsKQQU4/27eOidQCDg0m++wbXZhPEvNyb8UWfG0N8gLYUSYk8Z4oL96vM3IR0DhPzpZqEe4cm+k3Zj3vXH22ncuow+n
YibQ1QsUUYnn0WO2ObcT6CeUysVBASJcQkmnVGsQYJOK+D8kq0RhsHTEwMPe1VPfV982WoVatAmwUYsPVdz3cyLnTk6LxA7mgFmL
+FVLkcNqAgOO4DPapMmVmqGfsvucVd2pJM7bcv2uM1wu+3tK9YNwoao6Rx0jk/Pge27pEVaBnNs0F12JQp8CRgITOyqICOq1wjHT
00OU7HOwLRrpmsZEasfY6gYrBGkWMBRqq8fBCa+wyF49X8jg9Qfhgykze/zN6ZPyQyUxJuVrQoT7Xf9Ui+l5WbkecEFMz7NulmON
e7oKLqFu+z8TgKWZth4Wc6JUMKVYGiXVtBv0/gQGSHpqmTKnxqdApwy89o5x2IIadKhIh2wnLo/gKUKibZkaamzmXiieVIhLnRUD
xfOfWz1khZurMYdg1D4NpqI26ExxQKZnQG5Eykb0cYo44XLH6DKIJR7oUfFXcfN4k/bAbfozn+jGiUg=