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/WdCximEWZ/6DQImGWSEH83F9SyhKii6spWOa89DmaTdPgBk3nE5orjvWair8rD9SSiHpxEmwfXbk3g/z1+1SVmsoV
GufkzDbd26/zem8SymvZqjipicCSOEGIj5/+Ms2Wg8+30bmhHLleZzVSRdSdJk6spt1DSOu6d1BPk/A+i4tKRk1uXUTw+GcJmIp8
s5ihEK+GrYyDAhegXZfvaoVPKU9RX+3uwJFmzTVpx6sgWiGIq8hnhHDKbGeRH86ynp4Rf9/B2U8pRFaHrL+eClFW1qFWqRDOT14U
KO0nqhvqAQZc5xQWvlEXt9UzEsvUbtFH15L9yud1lMjjI8Se2v1QS4c/0Lpfs0A+fRTiQU7p5gsMzXqGiDEJLdwcmWIPf5vbjKyB
rE6cxcr1b87y5VXM2LMRT5VMT2OUdl4aV5WSmlte3APMkrjXCIk7MHQqQUdr70Vxekhf/eSoL2gL2xVzWxx50pgQjM2mL1CMFnHY
+S5zNiikq0k6LFm9iSvHHC+0++7gxFD0IG9BygRDVVIbw9TEGoGyZqCTm9MmQf1gRD/2CJ9YzwhSNcgqKTEkCT8+pkp9g6P2Pv1b
GJ4QiDNkclI4O0rSstPP/A1M00IrK4IV/E68Ib0QHMCXlFmgkPwPgCVHaHL36DMb56uiFFUfD/ziYNPsygC2Tnf4uLrzzglMP8D0
MZLhzu30wbd6oRXft32/m+CcwwcXFtTjJDEhY6e0PZoAJ3397qn+MBv71uDCHD0lr09WjfqpnpEu5bqYlE+jwPKyHWPV4y03qKRz
heA7Uh3gt/INSjMgGID8PrRLv0K8N8KEn4dK8Bvpa9AGdPrlRO9d2PT7SvZ20Ev5uRlaryPrgUv2k0NQ3e87vwO7jW0cxLE9P0BK
5gklxC6YUxhGbRUEXLIXH3J7K8cb0+NsB/UyEvh/MVitQCn5JJnfJ4/DerPs5D4vxqvFOxJ4QmEUAepzm8zpG0PGpRWPCqg6RjhE
a5LsCLT45A0SugPWw8gUtwWgTcf6k5qSj5tdNUCQ3OPD7REatSSSUPmIu1afxDWKne0m73bIU3UuedSF5Yhfskwr3J2rqADgnQgv
h68tfKd/J3DKv9ZSc4mi8Y3Fy4ROEA09fEMnztag1zMZMUzXbdm/6SeKkUKRkJJFsFapzDYmhAqdVC0JEBa5I4kn35a3bGmSyxEV
hDhOv40sE1ZMEafXR3t8YXscA7LM/ch1oRSOkqkSEQzFZkeIITsfEbKTmJNJbngTRSImHQivYlvs48//nKtMj+4kvV9Ig/UEIE99
Q3QDGpVKU89YWSpwAmBaPDkWfFmkIUhz+NiXDxNmP24rC3s24wDfaTiJpspODoBPC8TtD3qyW/LDph/wuXMUFU21QF76l6W+i4k6
jRVwq300CZD/cP1XS/TNcNTnoxaCKXM60clV+Ci1AGivYPvd5+vENDI7a+Tjc5aBVALrrgJQGmf8Nz3yC6JYEvs2Qsjn6kuHq77I
XyUTYmMnSKQc8+uTwN33yNK37000xxxgJthlAvPxuXtXoCLLGC2ajppobZned8CoewvX1lbakvZl0uWuzpodE8xRJsBylA2m16f4
BT/x9IhnZ2VgKgYDcquRpvwjpBXNZJ2Dqe2Mx65FkPiyTUp7MHfD9OP7FGfnTem4SmllDpkeTzQMkJaPID+btoPEQiBCPqI0+far
JTckqq2DV5331w6j8D+kRK+iHXtWwrleZXD+TBE0a3NpEJbRf8e48UkB+0ZAFKvqAAvDJkMCsBwjW4PlguKqBIXKXZJA3taCENp6
BEQ4uz9aD+PgH9qCOJ61yYD/YuWBIUHDASydMgOswaDTXk4a7b2tGt0gGmVBN2/FS787BACOt7U59XSQGN1E5CAfps+0iGXRpkIH
tUfTMFG2fR9qk/mYRyLTiURiXJ2lXc0JopdT1fZBc+DOhVTVKXYd8HLPcb0xBaMlnYdh2GQzhK2+AJdgtBK8Hto8yvdZ4llc4DIL
La8YOl41DAIBTnw6/1ng1A3/WAQgQlTzewSY5Io08As5HlwITuLwdu3B6kGQo426snlKqiByYPH9m7rB2kZOaBqK+Ny5ssiWTjEt
M2BvXz52qaIJNQIW/z2tAAMUvW4UF53BmvphWCT5TL9L+nlTmPYYFkLPE/7gJ+BkbrNbIhD2q9YEF6f/Uno7oDZ/L4z6JMTgRLy3
AjncyJx3OYzpBOpGBiDSEv+9vel7onNPoJlBT8GYlUevyMeROqc/BGmiHmuraZhFpgJBddCmLdSwKlRn2uTVQL70mWuhtHttZ8T7
jQZLQimyC8CH4bEXLL1DT0yK/uTx7984xa2GCd4/A3hMwDlLBkTswyynSmbfPGL0Sod1/ZjQRIHAuUAZwbDiUol19A4rqa9nzv24
LQwAgts16ix+YuV0rBKJPTBjvM55sIfAB7zjZyVo6YDR2IGW+0NswqF9Inowd+dlP/NzYqogAg9iCP3ZSuUv+1Cu6mkqhFEw0FP1
7DDYHG9IkJd87XAHgDkFDh5wAkJK39QDpeBwE67XlZ9F6W2+dytid+4HXMaLz5L4ngaVhgOPL/SyOMEynZUjYpUNyjiXV4F+TbsI
Lhu9bd9GoFJHjIgUw7sBL7e0tM01EhtJJEfskBAzUHFyWR/5BZefWw/ZghJOdC/Gn3hDvDXUHGp8q7gvKiM0nsDmbmb0eX1Y9Ln7
zN9xLgGk1krmXHyTUN1zLXtuJNwJgVuG7jZyGMxq2ETrTwTTcrskD4CsvZ+r5Acqqnjat+dvxqGuINS+CN58knQXrqaDES7TPoDJ
/9yu6le3Pf5nm1Pn8372ZZzzGPZ/1+hNjgHKP5zMFQkIeYxc64l90yJEQbJNqVVBEQKIDac0HrcsnOCmX3BXN8nZU/t+OrFjllW/
MFmecHKul8QCz0OxNreShjapHAnXt7F7NJDBL211EAXhHJVacIAKbtmn/XghUasWUnSRC+IyGD1tWkMPIfmUKTJlnL8E6dz2Pk6o
yIKLHeiYrVc5QH+cbFvbONtS55bf7z3ct5jAaNI9884gYFGL8SpKDj1cwJZuVh+jC0PKeANDQpmTjQpamOl8FOQblw9ixXtEg3eY
KM4Hq7wuIfKlsvTTPNTMeiEE2Z+g/tUfyKhdIMOvvLxUUeJui1dbMU+7RbwlFPlzJ9lwbx+bYBsWjIkFtWAYx0au/LAejo7UVwbh
NAeQuUJt1mqSQl2e0Usr/j55dhJ+3FnW19h+mUS3PoFRkpZHLcrFOUcJxEYvgE452VRhH+nCXqhjqOFexBcsuElYQTGP4UheiFMJ
t5eRAq/4NqDTA1QG2fTcB5OSTxGIBKI+oXNma8+XHq1726jhb/nyXIAZMeXvOd9hy1OdJWNFGPwxiDWmcjTeYwePdWXr/1u44GCB
zIDOGPxrhUKERA9wore7yNaKzZUEiNz19bnHQyfu7MfZJmhMPUwBwzkvbsElqS2WR6X+ZDrkjpmE4p78cosZ8xXzM3OVKMPBKLcC
pJ7hqJA6RooyE60FdMqYRJJmgd8UnD3kLesMRb0hi0bNzKdHAXSesPJ1ywCKgym4nIeKdHdF9XmGPjhcqIdSZjfVNolS1Heci1Lw
mMEt3NXN1ccmoX4LkEY2sZ5op2ZFxvQcs84YGCh3H9YD4uRB7O/bXP3fpsoripqdNukRtsfLdMWq8NEtjIAqxggKqLZTFomlIzc6
Dfsq1cQw90VR90/79AHXA4itxsG0wRbdIRUVYGLdpErRHdomPQN+EwWjVrVM9FUFluQmVuNCN4ScGV4Hm7TXK35ZzARq4saELbc0
gDT4hkg2aJt4WxePfSVZuLB7/RtIFoxWzxDY1V/l1XMWshsxXydzFC1euejvqWxWRGM2acICjBdont+NaDB1OtXpCi3b4wbUI6Jo
uo5ER64HbKP0s9+ISVYKAr5P8LsiKhp0mf3JzdBn8DKVm7osiVO0GyY7dASAWKcE3LxnO3pmfvX10yGklOuN31eojheckl0GKXkg
A40C8Ai3vlamhSBKv6Xnk/hY20URixdg+RrIAiWtaDFSjJZtjv+H3wWV4wKcIS1Znm+dEkdffGP8cyc20RH058u9ziiAOjy7X9A5
CA1LsB+n58WtpjeDfq6ObgQpuoDJXNHhyhEUrGjfhP7FGEvnch0TtIizMxa3SxCulEJfyUjMrlORBrH//v9oAnj+9Q/e4ThSOULF
GfkRWkhtPO/ptJT6fMlLisVy5dovD9OBVvq13h/Dja6FW4Jrj0erX/NPBoDU34tuIz9CIdC279I1P16wzfa4sjcXRpuRE978r02+
MD/9eR7TynJqVCeRJOyOUqOPLvkkPNDzgKWPO3WIbhbjGRtDl0GYfW3O92rZ0sX/wsm4qBKLtJ9aCn/n2eLLYntDOUAq27KaaTDS
/WToz1IFFFZxZC4dgm714PWWHRTvcy8zfw+7ahlsmiRPgHGI2b+I9LAyl3saddrEJCD6c7tHwtIq8pfbXnC+nsVBryWEuvGE4/o/
7q1WNEICAD3y0SacZ1nRSYk/JbjOCQV566s2kgxtdPiXQ0LeGm3uLOCLpPGsbogNJKUpq+DnyjljlEGeS3SgTfLdI1LQ4N2wxMfq
SB6B/jQkabCkTKCw9sjPLFHQM0QSwMDI6sxzdznHjgrXr80O3RKVCNJbA7RAL5DClm8w4bINAa73SB9NcPIVD/Y7jKRDUJBUsu1A
v6KnYN8hXRuHhYwetZYPTnUgODV+0lgpWFCrTcq7KQ2c4+oFUTcHGaIuAsMMCHXVVdv88m4b/pcsu2Y=