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
be7fc5438c2f5fb388b7431c3d967ea959bc976c4bc81123a18dee68a61febaU2FsdGVkX191kgMPquoFH+f3XOC4mtJiA6BY6HlTWMhN5dWkhxxV107lTl26NCAXkw/WEBByFIKnlq4e9xoNRuKj7gKKnzvKu8NR
KjHNSD1EhqyCT0BPawaGJ+p7xJZaMNmC+ww87qsjoqNaZ1DgPM3pXC7UO34HwzLyS7YGvE0NJJFYW8bEOT5gujHP83RZTLgHe+Yy
gAqbGmP88KNp87ahGKRjOSM5zhum7gbYMelNCZEAHK7bI2dde4Sth/h35x0p8a4xEpahttxbHU8mfYnKGZ4x/U4uOInqXPAGq75v
ZfsojZHxwHUK7huNitF1Zfh2qUbHV1waXPxMwofkAvQp7oV3R27tM4mPlNZeezSKu8JcdEgSpSisJCLuamFvXjA6CwJle1elbwft
arp8mBABVldCDGCAfZpuuh/harfewK1MJHm7TSm6nCa5dg+hyEkSU57sRc8lMlCBuX4wa5AAsvPHPxMBtfO8wCfCcJ4bdbvXE4sW
qvh1w/XtBoaRsppYlSTAPeD255NgtwL85XhbJKMf7tV9FHtIPwuoUal7rpdHtTtrQ7OLypNVsmB719Nd4JzeuFV/EXlB1r7/aaBY
5WRatwv3eJt6FRTN7JlRKzDxLXhAg8JQC79KW0Tv0oCDVSkPSeJqBceJ6YEDMCzAVbV00xUVgSebXR9J3zKRQOArS0aVKy4g+vWK
CkEWbV5pVhQUcU21Fd1bGc3B9uqohJRtx7tpXRx5HMPgTJ3V8SbfzFK+QBt6dty4sm3OFWn8cJt769dZx9Zc8v8F6nV9YFaOwQON
iZOqgrt2ClwyJCQM2kNKiSgIi8cy23j3z7njHMVoxPJzof7OM3bm1YyVJ9av1DpMnEAnJI3yH8YroI8iFtNBsWRs67/TwYDjf7lJ
u02fq5thB55UgC0If0EJ/rex9hSzwkauVc/19+EjsEJjQr9eBDTQphqqAzijlWrtCrNk5tDnLS2pen37isqSEO73Nyf+GGc57evN
qCmansretY2zu0sI95AY2bsteFF4Z5dZ0sPI4Xwz6CaWu4exqVLM22KLNskgbVonfmfEq0freLLIjJCQNYlc3eOBTi8aYBQlsxiL
2YbcUDlJNJpKs0UBNs/CQRCaLB4/JtHoD6xd9QQkX3AXVk9ThlLucinVjnLKT7GnHQ8dXJS9OVo/EkTLCa6O8FqsxSCmlxN2ndPf
07bi5nYRTyW0D2AOTFR1heO3K2HLMtv83BM/clC7QEDua2NIvpFAHd9Csu+M3ZXfZ4EbNNcp2jMlIgDIcAVoGjubqdSna1CPnW0g
mWF6b8T9zxpYEawO6edU1P0Q0sz52OiuSB8uddiztiaNvZZ4A6JSNTbqsrTtQEQ0+ewST00askJni6HPedcGLMGXIM/UPucBCRBY
AhsdR1GP3Ct3yrVbLzm0YKSND/10nNxWFtSJSnatIyJzdKuVojJKWXFvQUr3LlTQkTbwJBXxHwcpyfB0N2zhlC9IwtftNlLUN/Ot
bVt/RFZ2zSt8RO0h2tAfiue5R5JS+AKJLJa1pfdmHlV9q6G8zktjerW925D8P4IQcCrGnQPJlaXQmMwINvk5UIKb/gwV9ea0Sk3F
XdZxULiS0Ysy1iUM1Z0UxOSmJuBVPeC2nwIOIhJi8/D/jfukX9zpRlpF4BZ4gotmnI0rYVTDziSDooYFucAZ5GiIxBNnGmrOvE9I
qdNn8tQLjt9J9Wqo/mnUkEqppn22SADrTuHrjpZGRD86yUnr9EUGzJQi60eLLjXh1x4HPqDzxdSTkA1RJ7dF2lY83JUo9Pa32G8S
9pnN2TIhylusiScnr2u2GfhybnXkx2I6jb/jclJ3BNy9pg5F4j2M9z4+No28XRZ8coF8OqG6SlG70c61YY1vz1X0Z2LNww8hHIWd
DwCSv/5NojMLNabS1rwnuVYEOLYVBPai6+dNMtGQ12EAvA8HXkhlTsUha4hDquG5vUlmkYHqWHCD8d9Y/IhDL1JeGJ3b6CfZUgN8
9TczLdB1mFatoMTsy/f2r1AqWSK7ZSgydY0RlnFEdsqkCZX3qX6gB7HQLmt+fxjRGVt9YoSTj+t3scgRGNIBry2ylSk9HHCttM/0
Hb+YtATFUUcrxyqZYMstj15nkJH2xNpxP1dzYBRje5qW2ol/OyBvRYrnRM1dv7XOz7IyQyuKvkTmH5XeWRTM70fqc7N5vBCJhenI
+MvRjTd2Azr9Q6yHT1Te/V6qIgNo0oN+7HUUr2RYghUQJ7hMPTAOovdd1zKlFkeL8kFD38kWs/4bRPmeslRr3wrXztzK2eQZV29v
gIlF++vnwm6euU9U9ikqI4Ee3cojrvz7BeGI2vsbTROZwg8cRf48g6YBkQrrE1WZ7nIyfZ4/1TNJp0kCy/ib1TNbnwdLmaZrB6oM
oOHu9iS59pCv+CRqGFGMeW1bXbjJuF7xLrDxJjHZeH1UILweKieVuEgHYU3SXeZZpL9RoJ3gupTk2NDmuiieCKZtIBeZNtpw5aPV
6XcOB+0bOgm0fJc9ojd+mL4RxHQzxrnsU8PaZJ3ixP66w7EpBb3kxbxAeluYoLEOm8UA/ggaPUO6Cg/GNTUHyhEVqMNUTpZ7BuQk
PHr5U8ph829Cxmih3wlhd4f+hpNaw0aDLmhpc6CpvCJmyX1Qj7+0Nb2J9xpenpn87/K73ZEMRjMG3qMm2Hha3ACkjy+5HVGW1azh
mEb90fK/GJQ0rvvcTUJmq8/S/xxg9iB1G5x3IOYKTpmU1zBjlCbNvDjmB4+AcEum3vNfWy6v0UI3S6FMy74kPllZBvd37PC9Ber6
lUyvtrQBTXKogiQJH7mslWtVpo4uSOFRXEzxHMgbcxSeP79zRbjIS2x+E2yBg85CHZhYm0iVMGfh24hCHmAZTYGxYv6d175f+Lr5
vgHGRZhG5f/rejej0o15meq87KgVOrIjhTmcttbv69ubtAJIVDKcDDJvU5KOPfnAtyeXtTJeiDMrUy5uhcCIt7cevH/gBDSLnwl6
hwwAnbWQ7Mp1wB0wHv+K/cJM8aeGRlHVCEp3Oq5cUmBPO6fkjbJOATn1Ppulv6qY08TW8PzlfYvbN1cl71ToOmNg3INE82p4slqp
afgQwGD1kWeMBgS/FPcNt6SYrtEw4rB2C+obIuoL70QIDlqyQWxcbZ0A+nyALPQQpdoJPZ5b7Lxe55T67SMlATyzzX5n5cHEXyux
gRnH/CFTOXtXsYufwA6yUW2DFuTCz/5gbsSBTeLgg4pWTbrx/RZc8U8mOnDPT34qUnYSq7YuQkvB73VdiUkY837ofsX/fnR0VGKz
hbyGbl4CZTgeATweyM34+0mIurKjgU/s8gAe9l3Z54LqR0cBKTrU/7Ub12U6irKrccY+/3cUP3gnUz3TzmVWoGxONUFpiALHPGby
epjpR5ZuuLvf+TtIRlpB1eTK9GZ1Hw479Nkwedl7bSq6bcR8gMD2m7Lvi3BiT5VWvOoUKY8mNAsOsOKPwBbNJefQPMApwxWiNKCS
lM2rlzz9GYDIGphcBgnpFBb4fJACkE7tqf9hj1LSwCUDd/Z/8xmrpJg/tHQ/JIX3EDITQ7+NWPfJoTWruTfKAQnn+X82XouBu/tP
HQGPFoycR7L68ziqsvN6Dnl5Suo9JxQsXKgroeR93sXKGOShsqi1Q5VXdKU9uZY0YSisOy/bTxu/vrHz7+Zh/sTUudj0/ND53cBW
2/AvWBWull04Q+9gN5W9nUt/p+UYNfZFEBLu887lxrAS4BFW3+/JvUuEIfN1G4rLvyb9FjKcF5mTrvF+oE/MW7pWwFwkCIFqOdy6
+thD+4TbNQQdL3sOJumkttBEvmFOeXX8zJdxEZFnSXCAcRd5X2l8Wzu295dTCY5MCIPE854XXWM1EO52Q75WdO1cAhadadlqgLjT
6XdLB+gPu3yl4JgJrkKa/xMD0DInQWybozq/rDaQEploGlUDP2vJdB2nkKqu9X8WJ7R2hODBNTdI7aPF98wkiXveK7hP0CfmokQn
QFAchsm+v+guyXOkEfjogxEhdfzbFpFRRYUJipQC003xWJ5OU8dKpQXjkgORagJMTPp60Rj6f6Dr4RdG2BuKTOh3+J0aAQv9IWiS
nPnXH38RpLq8XSZKH/SEgAcbuOHuPaQVdfeeUBA4fcCoPr+u+F9yYmXuCYTcq60OQ+tx6qyAYERXuVOg1/MySqR/J/zVGAfRH4Yr
M/KLB2iEV2F1MBkDXXXFaYk3AHEQokMHg8BQEU77iH+QkefW3KnoHkjgIExkRj1yk1NkLYErYIHLN3FwugHyEwmaCq1cqpq1DE1e
EZVc25oXp557ZuN4U15tRR7apdL5oDtNZyiDsG2Hh126s0mmXws1E3NZ6MmnxVvl+nsUbGTrh2+qQR3JICnVbS6apocslAbRqX3b
GGI1bfULYT45mJ9cYI4kvEHtLC4PoVdgLgA5hoc5EurqXhxP68iIi5OX39PjuFn6hsdmpmy1qHuz04nWYCQyaMhc9yuR6Gy28NWW
qrutCz0S9Z0Z0FZhZOd8FMYOAD/CYsaPyFzyOTxUb2jhPLOhNaKoacxP2aZpUzYaBweyZuWWc9dpmHN5XVOLqcWHJA6bmOMRnl1t
XJeTnSsWkEANJh5bcFOCopASk22K2pq06EtWqqh3xb0X265pVJwIf/WLIzTg8gIRO/Dh4jQAyOrTKeSYUyvEFbqdl4myGKHfS4Ao
vF1BpGiqEGZF84fbcmeztGxNXczZcfM6QopJeUQfVCyDdhCfJoHoerw0+aOpxHyo/IjMLvAJJRq7iv0=