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/OvdcPVWi59DujF3/z7w3/9zYgfrB9f1DVboEXZEzV3S4mfcUOarwM4MmpdlBTRKbhnv7J+mj8tPuEFB/fx1hwiKOF
1nxY3eGM21uU7uROnm4JAdu6OqUpG+rVlWxVnQ2Rx31z/aFG5eIB3LllVUiGIcLgZ0x95zX/W4tPFw9Q9GEH6EQE5OgqWAQshCbR
gdyB5X/7ZjMEITk9BTYC29fiZ24J1Ht60/0VjMLX0bvHYXr5800lOEHf7v5sRJQIUtCNel1zdc5l8/maoOYbqx1msJbbUq3iI1fd
1B+ybQBuLXP6fXyoJsUHIAt1pYkaaD0OR0bByBhghVEl1n9U2E/ndZKmGT35/I5Y1z0OwZg716oYDHBgZmJiZ1bUSQhbE4v3A5x7
y73ZGn14sF5Yo96DdZ2sAEKMO+aco+iIp/upMNI4n7DLtu2QMifWSlME7V/dquzdOG59mDWV1ZGf56Pp1sJGzWB2ft7SPt6lNsYp
lukSFILz+B1Ryq7Yah+DGch8nDSn/qzHFsS7EGI72uJ16uqvPcxFS/zAqUkyGcOiiCU170l8GbaIeYvxivG1v33PU2cBpOMfIScn
apKjG43R+CezsMRvhcyXKxYkC3WehEkTJ+EexnjCzMZZtYi/6BdYfNSJW4/S+PJ4Rm5vHsj6K6TrnTx0K3F5bB6xqOOx3buDXogX
4HekFiHKss/V2BMcxaVAqcBmR502+0ECnUYfzIKvMARCe/cRoFkwWf3D/ONZjKAaJEWx21s87zr/SPyWpr2vthmZUhTubGxBqE6G
D33vzEGAemjAaXh2cYvm2AuMA7wbeW2DfVjF7c18HPVTxsw7eFsSHaAtkZ1So6oZxPIKu2lJIaojpj3nIAgYmsjjwKvK1zI8ZtBi
ev5G8XsAXRkZxi2oDeDbA2O2863oVWG/E6h86gn7WpWV14LO9yK0UbrpXLKvjjXikgmhsLBu2iJ36JC0irLePfZaGAkDtYxlMVFD
kAn2miIhejMsgJGA+8APekBGyhe5RqtqMhdXrGFNZ9iqhtG5OfDGSzHT6GDfxRQmhz/RkgZ8UykISpySbJ+7vdj5AxBg9a1uHYhI
Inn3HV7/GYaJt6iRRItdVARFmjX55O7X5CbapcpL66TDwVdnbVAnXmJFBvtAUXpMMW9BAaeKxYBMGNvTCBV2plyWDUAhJh7n1c8V
ycA9yvOSYC0Ej1ebtnkKEiiVQ+wt2jrmQgCW04wwchImFeo7h9uk23Zk8YGZzEIbGW+zXIy8VMr2vZLW9wDb4TsFhVFb2oxBgPQ9
P+98io8iP88hu5+Yd+EzKk9RWJSo3/pYfM5s8h8urpbCt4w7rv9w87sS3uMaXNgIKVWwzKTOyGr5uN60FexPkphunBI6CklyBJNI
ZgJuT7fItaD4Bc3DBQhiWwiqYLD71JVp5pLC+dr5saz1xQxBWUTvejuCs4VVuEvsKhSIwAa61+YgI7MPuSyngOvq9yPLRzO5Y8X5
zAUComq296yxpFruIMH35e7CUOlvf11+K/jpkCpR/9caC87mMEGN0rbcB14r8YgFNjmLiF5Bsjvbk0qyarIg2cA+QN7w+P61HTE+
5LV+XMMkNXqa5vqafRvLXap0qkcuG+bioBv1iFsiyDNnkWelP2RaGm9/KsptlC8/mhFbdWtHU/yv68P2TxT8VffKzHMFxUiGzeaM
WT/5xQ8mbeKEu1Qg3hnodX2IA26cNvJV6+6aaCpQZQd19RRJMqx/j/nUazBke2Otafnk2V6TpuuJkNxB2vCO+I30mOnRebr9NLT1
6jyFsGwYMsuJ22FR2PEnBpnQgH6OTOzGO3O5ecIvl+1tTAWnvMBkhfMt8dkRyCzriq0appSCTBC9VDo7eLPwKP1Un+MMpULNzX2h
F9ruswlJmzE3dcVMgeh1M+lKmzfYT3FrwBxhTSdGt2FSQjh/GYqdMS3lx4Yp5eYJ6Xi7KpxgbV8Kfo1CzIQnJF3ICmDfPskpIaAF
8H8ubh9/86um5VEa1z5unWPZflzQ9R/XWvs/0w9POaZMTOIEmwZhmTGpozFiywYGwE2kc2zCgIRpLWhIBoHYiEJAhMnY7aXPXDGr
SIfPgNHCOlMfcmba+ZGy6ldDsRfrxuNbea27qoon3EQjntofLqLCcsf7SSu7c2JRwqSi+7gMde65J61svo8nTfKMqbdGHAApQEeT
IRvUsYNRwfnxsSFlUqBRyDvwTsf7HDH6gOI+M/Ri3JN3d/VHx3lLLAoWJUATVgV5We3HgLVqii47twEJ+w0zNy2IQAsb8mnURa8d
mLPkG1+nx1gjd5bl7/fESgXXs1Ljq+mTtMGYzsZXMTtnEmHGcCak+dqGzGwuLB0z/s/Ixh1HTfkHVgM0MuaEUSb7r02ide24elU3
BkYRuOD64Zh5e+wNVmf4UzNCQiooVrOV89ZoOQ/3MZo1yYL/X3bcP1p0o7gn6VZUVtvp5qhjCKb+TLWBBTjkp70VwXYiHmAN26Cq
FAo3FcAgKNzS/IhtvlGxtrkITI8E7peYX5hip795KRJu30j/64MD/DltF3m839gm0pfgJk+TXwGd3XTMcItvdpS7YJjqKE4cYdJK
4Ia7xKGINlTlSfeBJosukyJR9pRqYNzJNLCAe5gAR8Dk5G9iXkT2tHIXhJgPg5R95GSQn37RA+7Tduv8xBzMgho0mIJRr6IeKwdj
E5wcLAS776XOze4YWdCS0V5roWJvpzrKtSJPOAgBK8eQ01cmoNaZJy/K8yhm+o6+D8BlcUGVh1mikuyIPLP3EeNndm3zdhDstLO9
Bz7qEEwiiEN7U8ieUfuQIjRmwiArQoisddCI0S4K4Eel7ZrHP4d1kHz4bmkv9y+tMc2dxU9TXyXTX50AUCSVVN7f0L3oWrUlP75o
ZIFa/ns2KKF+KCAe33EB4GCkrRRhGWvUEQ84cH/tRXhZ0nT5F2SBEx1SRvJkNX8E/FHU9tjLL/vku2nLhQoRZkCaKH5HGoFr9C0Q
Rvub+g14dtrPnh/197G7v4lhT5ComAxuB7yrasPml9wcy3XjjZnrbOBCV0jIBAoCw7SBWLcC+akP2LCbWf5LKKxA6yJ52TkddVJg
prFbIkddB5AR+xtP5JIYZnf3zNLQPU6AB1dCMTniytvfJMobK3PJ0R3td7LsmKFB0WTfikhbbMtDxYlZ6Sa3rdGk/4H8i5AfZ1cY
FlBryvpXOWiWGffOJSFcLhv5Kd9WqNlwi7A1GFmMDTQe19HvqZM3Cb8J76wgs8X9re84qlUlQplRCmt89ND5OIFUICMIj046ds/F
dvYpH/BcuO11mF4sl34f+9ID03gy1DPo0XurEpAcW8PZmCFweQZrSlO1jA/gqMUxZjneNt0+etCgRrT4RjnO6jvTIpkM1cl6Pccx
t8hkPT8tVWpeqEVa5wnxjTyAlfP/8KwQFzc4EiFkjqLA2WCHo4E0REslOLVjlY5G7e9tUO/NFIZ+33T8prNaBj3bTJDJnuZemyop
ZGZKheMb1zkZKT2EmVAi2PEVEO+Fgt3mBw0y29uhMw1sLMsUkbWjTGFoq4jaiviQ4TChs61P6PwvD2Jv16X9L2ZCMwT8rsojymVe
mjARPvC5jEX2xEHAcqh+mONX+JQjyW4Er8euipcxMax5AfA8iDwIjsacj7bSpJ+zsW8uWW1+HqM4CYBKVyrWAw9KdVdZm64//KVz
MuEmRpbfkPhAkaGwwUqTmlgh181QxvOXAJt5zRHwfsAdKrpn0qM/nolQumR/Qq4+4GZEq/KneUbf6YfKmwQp2dfZfRAy9kLyloom
ql1I6PHVNUvxFTrx2sDXFCIJA8vEL5oPvGPka3EzDoPY1OLUuIMWNk8Iow0FKRg3+u5ifGYpaCPXvXEfPdvuOq4KXH+3SIGzwwp3
WRzPXhn4v6nyCUBDRt84ponRs25PaVzcaxDKlDngbc0gEkOvr4JmSy93LPqL6Syo4jjhC+AbIiMGRB66obQkXNr6gotjGUFh/oTm
iPr71fvkxYRB8bNRpsK27kYVe2Zkc3B8MFTAdt5XT4Da3GHrOvVM/zfcAspxNB2m1bm9eoaKV626GvcYquSgebvNxD+1CMuGCi/J
PnLrm8Ov1RoifP4wksQI809EmqRp773QcgKetyAjeDDzQQb0bTpNwd9fRWr3sg52rs2GjpcD3CvtRnag4SRFAr++LKdmMM4GO+yt
jrw4/FebnK1dz+b6dBbi+6G9clmE0Uw2VEsQKkmDWD046/b5B/WDg4PmKAdmEqCMJoklnqPWW7ycuDajd3SAmJFtoktHQJqAP80K
vTUZd7pJ4qz6C+5d0TvMIHZkvxodiyKjBEPEy7l2L+abZbMrlm0Q0TPU6oHzoxOG6lKPJFhmIJlEJjlwU8oTRb67QzU0qpb6PavC
g5gR2GlZFaGGEKaEwUa6yIYOkVIxTp27QoH1KoFG75B1mEMZmmyvrF6wuxKhlYDTtBG5GXp5Cwkxjqm4CoOwdks4qQqMHBdIM5eM
kK1VzcWJvlGJoTok16IUMiHm80udCttXoAV+RJ5XBJNz3ZbZOWBFz+woHrXR0tj6GFEk+s7HLh5KHpFoI2cMHNU5eiglcnfhr5I8
nccXwfjdLUUzJgTBEy6uyxdVSQqlyerwNdw7oNiuv2l88hyE+0clgTF6W1cdF3dAPZAg1MWvliir/QDhk9SDAzlb/io//2tyfGoC
IAdvd3AzdDLUNonFiDrf9/GfhmSJ/tT2Ehej9jUlu08mlklGVzjfYEo1+RxXDb0/DibaVoIKbYVcu6CNuWHnkYW6b8RdL/vMI6U3
CDeWLiPJaLtEiKXXxme3zl93eryZsa6/kpCLFcb52C4=