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/kx6ixDGyvFxasr5h+2rDQ/wuUF8Ig5duXRKmdSCCvKh4SdOC/VjF9u3X9H8UFxFsIsS3Hl+0K7V0yq2K6IQK0RqTX
+ZyxBtdSVt7MEKrC/VHEjNSN4741yXee1WcYnS4yl3ZtlYjsjpNbyZDUZ9d4WDtpUOtTkn8KxwpOj1GcKn0WmkM14mC3sybsySJA
QavHaMoz0IHE+rIz/0WR73f6fFwlze/pq/CuQUxD1dOCcdnjoaZe+piE2QqwoVJKD0YFQES/L81ctxxVeovNDLYdIvEt/COAOROO
uv+/pC1IKP6zsUh2IEJ9SiOdqQ3tw/LYP0VXM1xHQqKE6ymgOszmL7sEbL8TeBJXG/oBON0OFpmSeTKnL20TwxidD25WloQK/IgA
IOoiI4wBWFXdHzL3mI7Z/IJ9xHPKnXLG9uhwvq1Pv3CaRLIbQfkU6EvYfuWfvdNLMIblRUXa0Xc0qW8T+s0suhRwG5ACJ4YYRoNa
W80c1p7eSMe+UHqc66vo750mKCuo/BuFtIWe7J/XlwhdlqMuDtwnAS8hzqKpuCzRNoW7gZ2oOKsOEqA5XS3tlr4gW9/uiS8oMkmk
371uA85nQ2MCyR5Kmj+rNeoMSbxMG7rhBPlwcoITGqvHG/JXHaBvnINqC9VzpFd1hgtunmHoBpw3Y4CmtiTipKJKiZn80ouCW00X
ogQLXDafs1+Ca3o5ZqPdUVnZn+QI/HGExCh6BvqwOIFwA/a6Q7Y5hdJbFXVLWvzZS61ne4zE5u0S0ICFbB7dWRTNLX75XB3uTr9K
9ROIYSyWfsznsYd/CaW8XRFju0XBX9N96/2tCJzx3TmKFfXeq9JV/WGaubC/F4wO71siqAFMa76GhHHebObHgF8OwPqcRavVRXJc
nyi2lN5ld6Jz8IAepSTzPuoKS6BTQ7cP1fd1plIuWltS6j84IN7SwxwGpOibnEeZ9k5y4ihMmPSoMA0CJ4GdCqaHIE8bLIUSWfT4
FYp/TlUe7z7yOFeaBqyEDcW04yCXcuakxsxUveUL2wSZ7hJYww1CZWBXE1HtfH2dv4xrjmCh8HZzYc501W9LfBeZ9iAakxEf8AK9
4uZMbU13XvbYIZRUWeSFY4anb2BjlJQs28Z2+OgOId/ohS4J94Xgu3NiiwBIMOnhruAw1FZeXB2PYHMMAoPYGXqoq5WTu3ueEg+v
x9b5nX241FthDEVp9fUeuejJwG8O1MMrokefgm6W+6Ma5U8q1QB/TuqaNdk4/4JW3yZW5xBoCpzf3W77razaCbCNtvfrqxNjwpax
mBnlVe68EX84TTDu4T5g2tEKVfBH2KWmqQYMVv3gQB0efY5Kog1Jf/nxLLVL80BSknk3+h5fr4SZlEiMi3Kng+ab4xVrXgnKxOrr
xAh/ktTYxV09gb+95sOnUIVpfG7MrKjZ87lw1shLmJg/LkSdEpCkGrU0s12VOg4UU3D7ifYY1G+sxYmMsZcfdPmToiFa2dE17fzA
xYeIOZXxDBD2nx/okYgbYlmfLjVE9iOGckqWJxVLb0nr+RtRaKJ+smd8isr0jmlXYlSJeKCUM2FfNderUYCP4HVAmZ0/jTjbl+Fx
m1xn3iJnYVymduZERjnlV6oi4DgeiZ14MZFw35go8/PZtnqGeD7M+zSKGZ/iOrNPAOYkVUaJLYZ4OkbjTGv5O1ZIynsHYHVT35Yl
Rla7aVDNbHzrlvi3lEgZE12cHIQgHbTUlKzprNS8XsyL2Z4jLTdyYdcD3I17ndE39KInMM+UtJPIvYno2B3zjecLkvTx4Hl0Mkq+
zI4Hf5TxtosGRlbU+dF9E2JLJL7mVgOnv1AlyTi280exI9Mvw0aQzNWQL3Oi/4mbrzIjajwO1jnhUutqW5qBsUOz6aKJvm/G2DfM
Y7zbs7DdDoYwXpwKj94h/ONZULKJ+zj2wntSUYxBqb164SD3qg/toCrN9gHwnXkazgje8la6bHscNfqydQJI9Sz0WOQqccpDTFwr
p6lnjyQxgDlr+/2v18ok/eHwXj1ktO3aQY4dyNZU/t8hZwUOXJEu8g9RyHpwb8yzuxCeXYx8rxrsyeFZ+Wv68OcKe0iQUsLpg2Uu
0DNS06Btjr5Xo3SDYM7G9A5pL9Qzm0sfiO6l32f3pGB/7keYRfSXaivkB0SVvXOPsEIAuKFXnebkr7R0epxU4nEvmr4szkwk94s4
D4oMat/cfLAADSqvSdCJ5x6qx4E97FD17pu5E+SgDkVbdMfAcRmKd3f0OD6rebaY5/pszfILAtnExbKqSi1E2SnVrcpV0omY8gFw
5hh/A6khX1mjYIJr0ioq9KjAc4npnKNJobhXQN2+n1o3d1iixVVl7tHvVzXMD7HPZ2Wosz3uAGo672n4uq3yC4iCN2EBCZehShS3
QfaWGGLPc+/oyQyDQLBsMGtovgFWHD9JRYe0DL+ARp/NnHabuRAd0BfswGMdaMIxHOP6SqWXfafGjt1TOepMAHaJBbwvRYJs2Aon
5xJAxcM21EaMXsdxVTy8qydgfPedTlEyP0C4tz8ev1olyGMvTIfAeocTK7tIpk5oqsExUW7dmoaw+9kRnqNEu9qEWMpmFLByQQIc
iG+pbMB7kmWnfJAQeQTEy62gFUoRLjAPNaQ4p34F8yAKlM58I0hesoowCVCfnI50FtJXRS5Z7/SvzmTo0X3v26RJ23UMroMhyr3x
y7B02QVXfrPYHCaj0gJrEaV8l3es5xN+QPCR3kqRCV4kC0qQCqr+dGOSzGzXkH5dCAIV2FmNhVTf9goMARNhLciCrmZpTTdNHW/9
G5M38ivuw2UaKFBxYK0zcN310jX+DXAvHdWPmqTWUIARETYClAhq/WmPHyFl8JQixOVquKgagsxinfYrZx6pGWJXIpi0I55PWtjE
+3A9lVdcmWxYns6xPSGm7tghVVPfwB0uWVmhlsDx53Tz/V2yjqLPWJFvZ5ocerJdlQ8/6WHC3cfYmaIJCW5E9OpFO9WB7qcK71OP
nD+jsVYkQZEimCY6UIHzwYiib2PomHy6f2k/tUGm4DUS2O4aItVCrHzuuHAFmb+jokeakWm4SrcUTfDMSpUff2TD5ebgEYzrAZc6
rGqirkfeuXZEEP5/7QKORbYeg44TRwNOzS6W2IdCp8FdUSVmVessw7aj5e5VQPMhjeamkDxxdjVZBhwYDVK7RpPqsFzpak0Zd1RU
AAG9gbg5R7f6hhBn18OOfyLxh7HVJQAkAODh6AvqEfb3Q16Y5ZzX+OKnWxoEW6WtBh3kBMkxpmq280NU2SDIEjIrhPD3hcgJgnNg
j0ZxyPK9Gu5a5p5pgR6a4qBqhCbXFP905CEEmdDPSqkZVy8PhTKkZYzZQNvOQF1XhKRBA5Nw/MME6zOp371duHVQmrL5huF1gAKa
vL3uPP/qMQaZ0DsZheqlrJAU5BwwSgONPd2/v5aExEn27RRXAGQanBZVEWitF5N3NQ++EW2Z8HcffrAVyRFIM75wzOMGvFNj2jSW
J1gu/0/vEy9/ZuJLNy1UA8jotCSpptnHMQ9PgZ5AevXyGzXm1+7L8TeM3/EVC8sWV2GjOVD0WDsbL46gTP3DCwjLtkULi3WsjEKk
3RvYksHLbhPg1FlwRXHCzRrRM5EAeDCwCwe7sOxMxxjLWd4NFZJoSDc25YIhrO3RFnO+RxUbI0lbU+qQO5Ys8MaBD/EYWoYNt2R3
+moF6A6/J2EWBGMiealsvrR1g6hbmIAYG+na+R09KaUCrtt/WRN33XGM2bxohwXW1ldTrZOziPfqLPKDUOMrz9aMcYEz3n/zR9+M
yJGRULQ0hYcxGvvWV96vlgB1caT92HBt9QhDGORWkIALaK0XDibgpPVjcvTcurM1aUf4d6HXOSCBj8Z3oaingKXylPMHHHghR9u/
CVdsLjJWxYrSIuo321dyXQUsS1xUTqUbB3Sq1N7y6RApS1UXvu9UYTQs8MNoxX8V6gQmETmz5XinajxhMoAxMQNFgEnPHcnwTVZW
jnBo/LOml9HF5OaUAIMfDBfFbipIsNGxeeFdYHFPPpjPF2isr+0F46YoSbaE8etv+ygY4NQoFHNaMP9JIDgEGjBlEQDad/MGrHNo
CgZzaHag72eJ1Eq2r3v8ACCjwDQciz53hxGrnqn5j0OwwpOGSurCisgclTj+4d4uLUagfNL8e+UXNb1X0oEUYF5OKh02AjowQVFP
LljFJLSeTnIw3dOlHu7DRpfZn9PlBcc+1AfB55DgS8y86sddPOdqqbAWI9GpxLmYIycEEcVYWLp2Zk3ZHkKCZvVIwKVXRNplr9He
U0ZqvtJIEiMTs2oYd+a0dcgi6B6uT2BCLWBXw14jfab8/mtS3utcB0kqLPFRVTnr5n5ID8o1OkdTLPxEsgT0nZmEQzxri/Xi4no9
6s5KO/PfjnivFoUVa0OPIMqYc9Fe0sEyjR244X0RWEaK3US82atR1+1DkcsJjuMmUJj8xIEvOFl9mdIDrZPngUYms/c2V3IZDUNt
406nw98nVfnV1qMICTcETl3g+vHSD0oVKviCrkD25xJHvNK9u9VNQorcPXk79XEMD5PSUHY7afu+vqaZf5C0KA/OFM85hKWLqAxC
QzW3esqeRw1F9sPLUn2h9ueMJO6dX4BQRQK70P1imta0gfFV4RKJonIjLGKGAzmRNSVDkkZxFRJeHInk6FTC/gPYN3GzzuwFQ5h6
Cv85rl6wDwNtyu+LFfpjUPNXnulFoYV22A/oBfefFw4XW7O3KwBV4/gLVKVE00hofDPD8UDNL9fy5Vo=