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
be7fc5438c2f5fb388b7431c3d967ea959bc976c4bc81123a18dee68a61febaU2FsdGVkX18u0dYFCTZ0zCv1caayk4ZwhRAWUMMBebO8r+asd4oTB2O4L58ZfqYSG+lRoFM1qG9ljviJqnCmiHlDHwsnv3scRnUr
CHmsbNodYUvYwC+Z+SjhyxptHby+nswrOA2NUAcN+HMEMp9B/sKrjLPLwESdXi/kW16TEVWEpbsvEUdARqd8CDDL3h7RzdORn/vZ
/1WbXFzvU1RCzFtyK2ozorSvaTw5ZjzBHHvW4iKi6FwP97H3+bH0o5qoNispi/LI7dPLoZw+vSlcCDjAUnSvRYDVnpV9okf1dfhb
iNAvxCp02C4zyyGL0stalwmCSV2b6HGTMXraIuKBvKDwE7Q6jBECuzMoA53c4odhyGr+G4NKlwtzeYyAiiG1T9enEV/nB61prnmA
nkj8wQVleGNpqjrZaLHoP0JcRToSB6honP1o1TkDckW4HTvmHlfMrJjCzvho5K6Fw4KKEhZBICkmRAReIcyX5a1zlbSwonYgnH5O
DE9US0sHnbA9aOhMJb8WtB53bC52+dIVkf8iwM0uTWyNkvU4GLCYpzVAeu8e6PPYHxhDrUksd0wFBpJBiyIGl5pzB0mAgHRMoQ8p
IO/gIcXnNYgNncWQvRgeuJK+7z4QA0fhI806atqwEDIrc7L9C8QByNgmTUevgWOc0LXK7mTNwVG9UVs5HhwRSmTfPIUCJg54KUjC
qUTA1TPEymkDioH9CHEK7Fi2lCtm3wOd+enM2JOWGc20Pg7JQMokJ69O6QY94N4NUDy+dkv7Y6ThSR+QjTlZwsCLTIjXxO3Gq2HN
1jTOZgsV58rnaznj9nElwv1xBzy1WC5NZ56WuSsgnwr3+YpeYsw8ARANLeL5W1doDKjoFamZB65ZAM4mNAFnVi03iWeU34SYcJRb
PPXs788xUDnUqIjXq3+OtyD08jYG9J278NQZ0sYSTIpJK3cD/2uv2nbnMntKV7BO4B7CgZFl7VgS2ZS0mxY83NJOgL+ebk450FWv
PrxueUHQT4onoIHaN/0JUlG/w25NakEXHBAU+euKaWkQUR1O9XcBjwCqJajqY+UGCByOtuJdvWll17FafY4zhJjtr9gLWNZ4YRJB
WFThqwpJbC09IgztOK7RgwylUmQs5MdzFeAGuj4uZB4cHgxd5KwT9pCiEewdnZas4oYdzBwH1IypEZNbS0jsjsli2R0wQQyvgctm
mqTLYolhlsbcVb1nuI0jcXsVT6MOnvEH2Rul39+IZTHM0BXX84KbvUQt4bfBj3pC0WvHUCRtdnmHTB/PL+P3EzCJPJvUUdQCLNve
0f9AmyJ6kiTzysgEgNzGys0R9b58oUvIUi7OCINRPqC8t3cHiRM968mtPrS/LpJVM78Utshs6FOib9kOKCLQUSREnf5KXSTZlAmO
Yc6Rrd30K7GboTSm0hugTlAtb9h/rA2UFQ3eqVcS0G7QN2WEm7gcRgqA1MC0tr1Vy2XfARXynkTKHWqKS1vCbV3ppo8a40kiRnkM
actGXBUSmEhbsZjX1e3j1KsTkM+OdLZf2QkB5qEvGJWgLgwYVk1gxJwV8UQHP6kByjRGvZI7v/XU2SSyeqDopV5rRms5DB9ffiKw
/JJua+U7bLb3/B72NK92pq5iuqdtfyOjB76D7C6Z8F0s03DjJcS6qwAIftfJ2AYM2nlkBCjlqWJDt0ayaCy83QeQnQX+CqkoT3nT
ozx/LuMA/ZiE9OfaKEwZ5IrGdhCC7BvPo5oljLDzBbx6aFndEcLpeq94ZporfX4G44JKfuQJNn4HA+LEHCoQHj3sy+/DO9XriX1U
sbL7n1PlL9muM5lDx6TDs8u9F+s/iFNlE2aJl/Q8s6vjWv4stoNv6it9WHkXDW+I9WRSESi+8Y/fd2LAnFoafiQMxPACHRtmTUcZ
dHQAoA2YV2e5CMgW2DH8iDZS/kHf6B9hQwtaTmtiieHoMb5sLIR6R1A0iX+BJoAGa1/lNHgK3XKWDFFV8PWoi440w8pAJHIrX1uE
5YMcxp9rAk9WV3fiqSR5HCEJE2HIxGhxV60ZwIEn/0vv37ByXyqRL+ekXO/cR+Oh3QFCHII0cod2AXGAy4dsDmdb1LilLHL3pLtr
8+8cqFMFSLVP7R1kfIKC3uUbyvesJFTy9lfMIRYcTzL8Xd1sPERq1TZB9jKag+Rw6XjNRz1Cvbmqwy6drriyNw3naD/GbJDjZxs9
34TnBb+df1Hr76NZaqeUNIS/is2dy76qfSOd7cQ0vLuiaRk4b797yRfmeg1BvFxChssjhuP770hK43E4W7cyJbe7M5kod3VhMkWr
0LCCg6RqmdNySmm7apxQjtoSVEDB03Mb5EKoWHICu7yuRbkRcEsFnoTPel+17g4xKod/3eaXgJGgit2Tcr20vo/PXqfv8hR3tTI1
UE4CcZ0OXyzP7zF+Nx53eMoV4ukQ2jqB7boOYTmAXnD4gm6mis9t64F3vKFUgU7a+kX9WWaHs6I63vrct2qhnchnv2r9h3lKhO2r
fI5W8MTXvFIhEqeUpAZ6U5eD465EpMvGBaM9FI1a6xY9MjrFhoI5aVRdTDFIdBuYggWGYP+QcbaXBaA6K1rv++agN3Ff7U32aeL1
f5OZRkQI//srZpgnIc4CPcZRMOyKHz6GdEI4SCVE/UU2id2KVWlJ245bEPuVZOVRCEontoytcdDQNpigBNC9KaMi3GHLk7YCBsA4
YkMTjS2IQwvcRZe6JUGxdEdjH7Pq4KcttxWBvpbLrIb7q1zfvG4Uk6tmS3SKQpXHQIg00Xt0XtBpuw/O2G/0Uez0zzvCcuoMki81
ZIhZiZrGcu9vAPjNq6zRKV/lcdVWPu8dcmsfpqvrxUW/X4Yo8bEWIaFcShcibbcXXzFjFSy6uC6X5b9n2yA77xuRAjw4qg8FTTfA
c73QJK6hOk6KN4KFmjCZr4TvD2CNy6JSzmzF+RQGxTvYeX+DjaR0S0S09F3H3mD6MAZVVQDSdqNOJvn42K4rlKuesZi/cOdTMAeA
w9mirM187L+FttYhn1ajKvR4XS5zQrYpTihILzUgpwotWCGR/YMM0oo9o0zkFFLEa/WExtGr8okofouoqiiayCSG+bZtY1LQEjVK
IQuNnZMqVWD7xYB5aDNszFD598VHSiy5y8Dotoepm8MaCFyu6ZZjq4oSLSKRF64NI9dhf9hgQJhJoJ4CPHl/cc9zR/xuvY+aeJxl
3AhcmEzsw7K0QJOzjeEBItYeN4712q5E+hbBLxKCovmBRLdLtsu5EXmsTSdmYkIZcfDHgLksYwl85uPwBiwO73fqz95/g/quWFbZ
ef6vIwATF+uY3gJ6tpltVMeSLgjIeOYavsUvA0xYquxMxsCy5BkPU1O2/rtsmpwj8P6494URNa1Gzw9jx7r5mCCDe9/tiWHZW4Jk
Xd0Ton6Hmw36dvXdFV1gK3OJzz0TXEv4rM+WCkj+jW4wJuwfpvORMpeIFzhg2SRiBZZBu8bwgKw2W5YZGVbAKnxKJFYFfzzNmGQT
mUkCfXMculEZXyN4VSXRFyyhYelXFrS1Qv4xXFBnQz2JACwZ49ASNnR1R/OWmM6LDenui5eu0yl8LB8CIubROwAbt/QxKWbcZwS1
hw7E8XzfABlz2Uk+1sexIppYJ19qcCihcB0Dpuw8ze4eQNYkjPUckBcT3r20p0duU8mOvQPngCcpLmNMHogmLoHP5rz8zSFxgTlI
xqmk+Zg4BuhIhTzttf9LOQJ5ZixEHDTKf7KQaS3AZFawwFRoTm/LGowyP57RsEKu3YopSTmz5+Q/43Lo8V2XHab9AYv6bL1i9gIn
u2PEZcOwSvngL5WthUWGd5F/V/26ytWzwTABN5NnhWydhMO0oJO9twzkj08OsSiLsYL/ShSyiUDiNfUvavI0EMm77pGiBBB9qa+1
FcksK8VukW7ifNDuan+e4Edl/0x8/i6YcZWtHx+wyCPjRoYKSPtm4N46jbyynmt2E8h7BcKSDApYrHCv96GIv0qeYu0DEU0OYcJf
QxpphNf4yUukvjuXpA7tm3dyyDv+aRcsM1cNKeytaF2n1+YgN0zySz5Ex7NUhHyvWPDMn3tXLeGg14/Jr1vdAwB4pCN2qeHSif2H
H8NNPbDuan0MDtaykt03NMJ7R+FRLUjFMpeT5I/wKOQJiulG2LUHVRAmuu2phPdJFJf60kN0eOk8K9Wi5CXD/Umy56Be3SuW7czD
aCzPvX8WSaXXt8/qDtq+QHVrMmiISV/yEkSTCKtaKELk6j0NVrwzm1seHnSY2LlDgfPmgawepoRjNtmj9LVkERUOU3tDwoAbMhYu
7jViunB9FeGFI7Zaip9o6CFk5TgrZgN/CiujdCXG1sWOFZ7+ZsfurUCjDKfPpur1L41dhos1GLHZR3G5/89/M3TeLnUHgBlxg5h+
0IH5Mv42WKqxPONAseT7JvUXAFCiNgD0rkEpEOfT1HFugp0k/pY8ZqHjqQpEDeAolFaOmvUiUw64PLNDDeslFSwdSCmjkvDiVliU
3iNE0RQIokq4BiqeGBR2vo0M2y3VpykOWtGsfhB9ZOWekHk/5EKK8eoctXIlOFYnOPH0o+s1BOyaC2K6FPzV1dv8lLp6EaA+f5UT
B1obkytRbnPfh7atEWMmfmLKGWd+uie8snA2neSd5HShbOEEexyDCY3ESbdnpVBszEVFU8354DZf5Dh8gfaSCQSpHBUTHsfGtQIx
Y0dMohvfV6KJt8Dem/xNCh+hA1RHayaYEprl8YooiOn33GC72AhgFi2FlnPdNOmFLZspEfwQS+l0kBI=