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
be7fc5438c2f5fb388b7431c3d967ea959bc976c4bc81123a18dee68a61febaU2FsdGVkX19IXOK9XVb3hmRXyKQvJOHSGRNwaIjMJyxSsqWGDyfQRbHc35IYmX1WGeRcgbWVnJf/Wt1BHqRRwn6J/LZa0tmnvU4X
qmJ9CA8yPy5y4rW/NmL5ESKvwmYSyZd1qLBF3JlztdYvNZe5Ofw+VHC65pGDTq9YVQdczOvuHusVlu9G5jAETM6Kl4BzBvDpP9PC
bYUlhSXyJcvq6+6RbQo36NtlmvLS1FcaodS1z9S+Kqkv8zOZW/3b/kBRTkXzMWCEM/WsPZZZtMCLzNTk8ysSvICjoA00IVFrjSD6
dNLnwC6yE76iDOSnrh/WpvYRg6t3F6D2odTclcPZTwMONbJjSXhv3OMhTpaxWl/0GK8yDqh43ffQcHJAD4+ze/OVzCcLiKAXTUNT
6uEnehFUkwKVNvTdp5A1DuvVdmOqVNn5ZESLS3+2OrvLh5uuHcdQ/PZe4zCPYMf+W2uEBmlVilY3WkCq1gr2cBuLv9wTyeOcnWBm
+4IQvkWzeEbLYiWWPZfsNAGSn1iMfBbCQS1hvVN0UGYkWtaCx+Bxq4oxm89RSqD06KgiagA3MpIQ36L2vY87labYf1kBGwtydT4v
Ji/ahBvnZ22s4KeanB3Fuaz4I4JV0R96tUTDG6UTLThcJImlHy+4zOQRAGYvXr35v14CXBQAiZZDsLvq4nXfbf2j1hdqisaSSiqu
DyMd2BF+U8VnaSBdp3uokoS4/X1WAdlOiNsEg1+4EeBQlrlzbREGjX5sOjkVoH6We1BgvRB7HNyt3uVBgMtxmdxCIggO/wXmwjcJ
koMKCLYnL2a6A0fg3twZvsr5Zqk2yxjan5S9S9AsYGHwn6XY09LdI54EDmS5kW8BqPq9i4CcDnI+iEUhRx/3LVYybUtjK7SKlz8A
8XdIvaCk3iAxtwD13uE8CTpamuTzuBsX7LEXWf1sUoFUojPNk/BdLJ6wz2eqZ2OSDWlmd5aHUz2gHX69jXa1JGjbK5mftM6+xtce
XdEvpuBsR5HEP45nerQK435fbiToSOePTFYt74wYsfQfAbqTLSyUQ4Awjlxeu/D4jR/mw6kWGilQzjiExnf30z1cln2zo2QkBkid
q5wdOTTdsPDGHKxTOCCSQPvrnFWjx8B5BRb3cQBS7isN5OIuTUPhcUMk1BDXCWQC3QajU7N6Q+IaC3Ntt/aiI5zBEc/yUGC47Fgn
RoTKRhraKUugpviUAur8FBTPEbPk9RyAUs1BTs7YEUgXviIRotp97grJ0X0c8ol7VElyd8qBf/Lre8ymKGA00387BnoaGASLEvdG
5kUgqnRmqVpPEFF7jAHniYC+rMJ+201pbCKkkN6hGbjoFyCiUpqcDYS/G81ppX5ZA3OFmlZ0rVpPhF5YZCMxKNqnwyxWKhOLU/oL
cR7bVA2a3aDlfkt0TLhflRXrq2hnU7WPgJVf65ZuKiiAhAK3NlD9iwbfI/MxLmsetEOf1JZYtCMdSH5af/WzpBVaBLJr/hmp4zen
1BWYOOqHg1eGui7YXbq+onzbLKBbc11gcA2TE1PiGP7CvuZZz/RqlLpsubTf3xTcPW6QKSg7qrrmkHR8X7MbUOAmGkz4DVhlxmAR
ML6f1hqQX6NBB0/s+9M/nw3XUshgrLB/xjcAjr4FAz5OekF96fB+0Y5kXMDxFFf6oBxAe2abONyjB3pvS4KW+nT7fwBSkXpWRe1r
4KpFZ9JNAIaYbwnUm6Y6Hc1EvtGB4gHUDPtN+/zAOq9/x2elDptTVCyPclp/URh7V26MvWz9esFQisjM/jNCv4gnuuBZLfTMgMJn
EElhKXbEbe+e9VgpiGVuqzzlFWSmGvKg/+xLiYi1t3EFpKQZ1XGf6hLhgk2dJaMR/u3WVT7ewi0x4K37FiO4KAO85xKCcuogDXr7
ZgnFSjJiFRLY9fCxVRssZreaPud3RsyZNJPD32GlLOjpMMZ30MKWMFoKUx2sc/pTaPW5Dz9TzyPXC1GjUsLjo+BmJC4lMa2gaCJ/
jpr1aeMUdHJYiJ6qdOYODNDdcCtydOXjf0hZ6IPntqwzEnPvmIrvcaaRiGkFQ4vYF0N8I1Qarc8tvv2I5c5iLuPG8wwCMNHlGV2p
Up9iw2MzLjt5eaRYvsMWfSxwx+farhBRZO3cOG91oKD+HDMQz1Zaiv6fBLWkPDzIxaJ2ZsO60xId3U0cfmNuYN2dy3gNzaeOvQlk
4fXDX7MpO/WihpnwchIlPIhkUySn+79JJLWgRmPBGrURxE1SygTI4FSg5GKp7un8H07QyjvaKzspy32TxGgXblDGhOBn3lghr4Wz
joT0LnJZnSMZHz5iiegdA8PajERedB7VsYenr/k+jt9BrwokVxIJvkRxduAWa7T7dyLwGCJYvGtLF6lh2UNGzT3AN/WJwVMleJcr
RTOs8THu703jTFojMC8nU32KDuUkVdH45EUGG9BUUVw0Pf8UL5IaGRqseJAV4h0bMQgkuS3S1mKshtpfLnzrpC2RpM7TO/Sjqas0
gDgvrfSb2joj3zrG9DRZcCZ/QZ331FZBaVEorFdTWUTugfQNnbcfca29UJ9xEVgPVfSikJl43DSWGNHqMJVRBfD/plhTB2vc7yVh
EIIj29uSJGj7C7Y8Pghbwq5ZgeBBvK1pmb54t+zieJbcZYOWpMqGDxzI4dBanIU06AKNMzETVd1FOfdsNZJX+2xGAyKRunEG9znG
5eE+gcuMPgzTzucrnTqpU8hzULWJ9W17BViGt+6PDDyTd1BH428U3zmk7k0e7vnk9xBsv2Jby8xTvc+q1NsDKB22bqlA/D+fRcv9
Lj4wIHMAmLSZG5EHhsRWBxep3TR1dsjPiKJLdC4diZ4rjZgnd0z4+QKeTS0rrj9TpfzIfMmfudfXXjzxEktCjHeVksdzviH75wz2
Wynt9acMns/v+4sAH4/e0GpH+K6Ko5Wk0I5eFMPAzY0V5cm45B7BeYPRkm57qc/foZRWPXNDpbLUFhYorVF8aCRTkeiyIPaLi4Y7
h+PjcPmIh2BQvwuvXKvO2f2bTSYQRliB3cJ5NcGGD90uO3a/RDxtZOh1T3gKKxya1lJxCiJkRXEVdgDK0tPUgTbK/uEhm5dm4S9n
qXrQqlzUm2G4ZbY/iVF+aoTjyqzMus9ujdnqV/Y1wkC8LpPvFpfGjf1UF0z7QrTdlU3X6p1LSXfHRzLDMM5xc8ZNKT9sVjnYlEe7
CG7OUocRQuRWS2ussXHky0/QVNJM2vBiDNYmi1kJA0gauOJpUjwMPq4lk+5cN62m2l73YCiANoTbRA6XOb3ySdQgUf5bNMQceABC
E6BjZYJFZWmPun8nJ/xpA83EeTChn7BjaSA5sVRsoFbX63GdMFCiZ/i/rw8pOSSRMA3MJYm7SFrf5hS/fTbZcsLJyOqzS+ooHv75
T52sURQc7I5Z4dkCcHsgOFAtqs8Ms34u/Z48rfctS4b4ZIWCXNMJACMAp9W1jCg4Xdc8vqo3KrE8ptDy2qEVHFGxAraTGuEx/c6e
ZyOepanKhc9oga5ojPmTO0HXopid43xzRuLaj35lo9ZjRMYQEu8tFPHI9TXya5dLOZNXkBESo+9tQRXMBvvRCmEMRVqlZSg13nTP
T71HkdWe/uiKmuXD9wsG9XLLyim4uuV9zLcjPZYhO/S2Sv0+mMo9YFNH1nyAKPMXCrB4cbemFfYEh/7IxrBE2vqoSPqEVDHnS9MX
X5pyqGpePA5MRBGbbGTuV3FhmSSCdpBDDVGHS4ZLWvLE8FPNPEHmaqtCIuD4psZZrFKhUTMK9qJQ0ocxkymRabr2eLEmwoo6y/m0
fYj2QS8zjAMiq6HAIMybUYR/R/HBHR6IgFrJgHYn5OzV6vz4/MmKcUi7eZEgoU4Vx4l4NSva250MGgcyoD8ljw6JtcUpU1xfhhxS
pmNDsDMyx2yKgBqjsI89NOAfCy3yYgZuT5h651vskSvdT1A+krM8Q6suw6wawi9URx6vnB3Xh78Ik7NDqOz+MJK0SlvSgdHPYcR5
5cdFEoDe/gJyIgxR5r3gN1Rwqz4NvZjL0ut44+QmdL3oCagkaKFQU0n7PF3K7ux1ndKN5sSGDRjmFx7k6HhsVWjh9Pav0iivCEbt
czxuQQSAphpv0LBBra6Fg2R3VrBW0q01y9Icv3jImpy8O37NTr0lgZ+qLEDTDPtcsVhSO8SDtFhTQoh41hS9tEOFVOu6kLkYnLQP
tNFoL7JqmWFyHD6Asje/Cst5ZVae60BJBOoXUQ05V+nJiIK+ODPIqfzeP/dIGlKUKyD/Rp/Tcq9mKkyiCkZLbfVZaEv8HXe6wQZ8
cPOxDfr+zw4aRSKsABnVeFn0m4CplXQcMpjOWjWxNV3lgsHmn9xs3pL+tJ/yfrLHKLeyMEQbhrEf5BdpJg9LuofjODkMDy/aFhie
g3jcrLqmz39+vylkgm2rnzRi8UKKS+gejLwXII1d1YtydfMPD/tnaNsmEZmUSqHjyhLuUje99bAfbpgMiNtH2YwfKe8bdJPCFjyY
dVV/vfFj9FNyLSQM9AMswZY2v2v7bUNq/hRJ+tJLTjlxCwkiHoWaXeX50Gl86zi6T5HwMMAdz1rHncll4h8Nht5HsTYSN2jEr6hw
u5uHqrRg2vol4pNebtkxD0HO7PKGhQvIfYBTaTvTvOkiBQ31jAcO1HCBNzTgioDsymD4ko0HaRJRAnJazwRD8wv7zqdNjmMS3t6g
CSeqxja0o/95RvQ+r9AnFNr1bpEuTVxxMFFBc/EDKi9cC6WrWOIFXHsGS+51jYtYr/ZMljGk591KCjU=