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+zxFIBP2i/eqTFGew6GZxPgWlYpus8vPgztpnSggnU2El7MPGqhpGfnI8IHN2dT32TovCjuBCR6Dc5qYxjJdUsEzli
lV6009yUlNtZk+pKoe+aoyVoV4F8Ur2VpMNcwkOpirMawJq41Xp02B8/m+4ifOSXI75PaX0+X/+WfTYKZ8oTrOM+bHfsjurvaeuN
v4S6re6CzptCkoKGh2I91/RuPZKbBTy3aMSC3yXuZnP+4mDJspxRkaJxdsqxYMvKRwAX/5rqSbzaxNvZUcICvqGWt7qLAIs/ZuSx
0xZsAIYyUFLTI9tp++tyuxKyY4aXkUQhH8AxVxPUjNT5Ftj/hj7RjSmLkjNlT6V7TUAml7LGiEcCB5KNyNAJsITxTHBEbi7ST4uY
XkVx2UXSirDbg9uPigN8Ct4lW5MamL1i4PRFR47szIeP/u/2JYNIPzqjQuHCDOyU7hWaeF0bgTrW3V9uz/ZshctlPKwa17y4FVCT
qbZUPoIJnZ1hDmn4JFwcmnKJmmpuEd+dr5UFE/vyIUCcjNeXbq61Ohk/iO3bjPUEtBO2d7MkD8rlJsjYd/7nfXt1KAA4myYC9nMs
y5kzBei3DnFxIsUdiajyISQz8ASt/PxcSpiLcQnv1PkY4izdthy6RLOM4EaPAXLyww9lezmOKJHWpSuyja96dvauTmY6ThylgXl2
BraAquGikJbVtuXBHUrRgYhB4EvRchHgApHHcOnhZuN6Glwl38M+g0cPb4FRdD+VcNgbgPGi4P59bk9G+PHiyseNiKPbjeGia6Wd
s5Ro6Y8/OsPtwKLWNN0hAfu4rwE1vbC9PBd/ZXiUOGh3dANgwP+l2DN6xa4E8bm9E/VH3U7WDTffHuMeJtLX12DzJcq2IcQPCnqt
lTz59uWJTUwJLx32aDOSJbQYO3tE7ayjYhRBnB35Pcn9IZkneT5x/3jl1dk5mDGD9ZgmnGyz9W0naia1fypRT8lCHA1tI5g9n1fK
v1eeEJgBlyrouqXGN7iAj8jMNF4KhOUZtG0r4DPxqMcW0cuLJjBpY4S6N9m2xwu8nTmkSzR2/GzyJ+M74QlyzsFFAoh2lTvRus9W
AlJcxL87HgpBXkIds5Vww/JIE2sNwmR5SkHmwMs4sq5+IOdJgllzOi2p6+lR5X5gzLlt6agT6n06LwCvKty08X0zHqgQKhS4RIoR
8HL5Aem/g1T4ivyGl2tCcKwIBDgwFrJgsa23sSju6Abg/6h9BvhS8IMZAzKEKKlL6t0v8wsmFS5I7bX2ewfbPuRtdUDBuRjaDZYB
0HwtilkejNXd5EIXNbKemB964Bw5hclgxShyJ8bpCWmpNscAmz29hOgN6p3lTTN9t8mFkm97OpHweVNX6ASIJpuRutLqunG/mG+X
eJzXEwCQUjyydRomZx+4IffWZemI18s/hb/uPt/SZ0zlsBSWY5ktoZNu2rkNmyJ8Oh1MHTqby2TRsCAkmyik9LHZbOl3wV7Rlk3W
y5oubj3FQ8CL30wmAQ4g6Kxlf8rsy9+5nQ4WDa/5jwsUjBRishZziH9tDvWeyVK4y4G3PSfncsIU00ksdTO6qmKeGBkecWUC4oal
ltHeaoallZ9CWyftENxfLqyJ7aiq8dxwFxPDIwABLLz9Tkgd/ClSPN0W4ahiByP+ioLabE5+g6PBt6B522MCUEDQ/YYwUkk9RnQW
4PUCV0ilOOkN6UtRxbmFhBsYzA4z9nn9q+7jXPseRuYpUAB9YTqIaXRasEK+TILc9QNKaFjs3UXAMqdtGmLekqFtUjkJEcimFIGa
4YO4dLnFMz9xYaCBpbpDGUk6m3fuGPociDpUNxp7Cg88PXobHuQmsUMlXc9PjceOoTb1XDPaf/ISFI6jlC1oC6wx98DB41ZVouU/
yRzV6xsFWVEInNxJ2/afOQTq/QzWptSBD+nSF9zar6m8XfYLCmK7wwFRwv9F9fAyEu1CHDR0xsnkcTjh772zqaV+ogLB9N17s/iF
VI1f5XhOoPC7mS/uqnMajj6UqxvwOtrrEC/aDAjCoQzzXwXsrgcuu93mIc+hzTL4EWEahkLNPin1sMA3iZVRR//Uml6xW1M1O720
43ab2tWTjoA2ZdFN0pVaXT77BKSpOYj0aTwQASqBNTBnypyiAfJbPk7ySVPDCHz0B+3b+fxCPQDl1+cv9SxMsHttRi8FTWl+Ll2A
fgV25avDk5qLouwndEINpAYtHlXBiJxD59jjxtxtOnsxMihoAWtyrJ9NJQ4Xh9vCJVBv24jTBcNjOfhzMqF2eMSrKf07PasUpxHS
KEZeb9d6GDzwYJa/Dnqp7BD5Wvm3pTbr7XfFQqnaj4B6fnKgc3Dvo3g8M40mkCXgOw4BWLsjIrLxsKFU1BC8Nug2sT+GJL51JTlF
VBs9MYtBpuRfWhvyvbEnI4G7g+hz+ALrO15mXbqseQiBxS53yrOFy4AXLiLRIpvR09m4PG78lm0NCTMVkmCs1j+3/9ME0DbR2qTt
Rl8I1FB8RzOMhURkuokboRZt4aAiAL0nwzVWOC0e19oG0UcYIqxwes75YNb5MvTWr2cOatE80Cvm0cLv9BzW6CWNFncpC4+V2oDU
bKQh4aB+lVUs9pfAcFRYWXn5ikbkXrqTC8sOR//1bgKk0OZbra0dhPfHGa1x0vzog99iS8bB8nKCt2Gc1ZyAJ+jdr2LV5GDnrVEe
6jW7ThArT1gqafkMKBlEfu8gapCFlmh7vM4zCJmQZZx4ruOkT33AZlPCvGk50sYFaoXj1556cW5YDNEVShoZkfzCES/UJ40rkTuc
QUpoA84eHeNVo7S0b6qg8F8rLKbAxpzqZ8wSwlcPwr2N99g6Sa7gFLIt5Fyr2BhnzDwHrnP1Ief2Ii/OjoSVqCcJkfMpVCghTspX
BDuXNVXxAVLGQyh+cdacdHOaU5evmMP6MJyFfYW+x/ethiPxlcpjQpy5X8QlyzvDz/ofcshCOZGni6RrKRcfRkSib8lQj2V1pHvL
HrgeRxPKEVFPrd9rQzkjCK6O4VVEJAJ2Fe+lVJ8PM8iRfNuYAkqTzmPPh1x/+rokheX7GzDq0BNRfSaSOMHxT92mOCtLnc0wOywK
GXihm4IMmn83PlcFMM0pchBcMHkEPXjc/A9T58c9JGwcVn1dodXdpOui0dq9ptd4QVPb/vWGh4OAVke2qF6fVivP+uvR/qJQtXiD
p3+mx+xc9pk98Q4QXGw5LS/reRORJSPr7bP2ntOqQO8o4/kp8PDngYkOE+5migtiH9+EdVXlCelPBV/5Zr47hPj3nY6LP2wvrOj4
mrgzttmvBax60Mf/SSblZU1j+AKqxK1THhskXuJal4B2pB/BUELQvw7XNF1jvm01jz3+DPdGqX4bu6ZVEpgBJP5yyvh8NSrO5D5M
TB0yYVWF16hsyf7bax8DgxrDcPwPRGG9jLwONhmNXrvW/sGywpsDZ5j7v6UuIBS41Yp152LsvXwL8t36ThIHzTvfIXWXwNfENl2a
GEWd4hPVtIGtuf80FF/r/AQ9xEAfpVo1uE05dN0l/fGcs9wUtfZavauFvHtNP9TcxMW11Zlb0cFv5DX+F8xTm4DcQg3/BTsrtRYe
4/LQWbSGjbmiTno/jzyf+ivRvop+yjS+X3HMzLNmF81Fbf2F6DEfIcPMZXXZW+Sw4+ja91/cOy3hYYIG2QqLDbiCYJ2iya410HEd
a7a60o3+aJE2RdEbUANKz+p35b5O4cWn1oco3hgUWjMWQ5p1slR8bbJBNz2utUmpcIIZn2MLOG25ShmscJRZ+OUq9BzGuhgZ6thH
LVYWfcEjeNMTDIgn5ItTzg+czY2ft/IS5dew0RzIy4hzICrKfl1EynncUkICEffHslG4oZg+6EyZSwnkKUfuouzwTjSIAcWVU9C/
xobERd4ypSoWqtwZ6o7r05LSY9oNk8QOx82GrsWFHt6kDg1O5xnTjAWifXg1upc8vChe9ivdrML7KommQbyepHruYTc8WaPevz4S
WXeT/CBZLtnYA+OG2Fam9FItXBiuBMszTGR7589AkvYeOWp4cHiDxzIMl0bPxFXyd04G7vTOaIJXWpk9K7Dj+v3bW3AjVf8b/89y
lzSDoTCnF3cUWBuikZnJbeIRY5LVZNLC0boSiV1zOfYyKRv/Fs08w+jGxnBHtTe5Q8r+p0rVcwfMM7DAB2Y3vSkMIZSrZobJe72+
qFJxVgFXPzHuYErpGp/1RCgjM78Dev32uUoi4+hO7FA1VTUxIhV/eci7tChweXRNYfsOuzCTbyeTzo72MFD0zO1zW7FrOw3sZmpq
fe7Sb8FwToNcsRlmzv/PgsUd04h+71HXfMAKX+MtRV8TGCjtuMD8CLvWJaTbFnAaml4tyyn8LTlyFS6L2IYCb8W6zJ6o88tMSjPJ
0s6fJl13IaXYoPt9K0iTadRjS9TptOvCPgaGMniddPqYnQCfEKXVIn8ls7SapoEiH4l6DgN8ZQlItP581/lAkT2MhsrJzHeIdeGt
052rJM12VDjL3WcI3enL3fd6xQjTy0wkxGZyg/p0TZX6uCeD9keuYN/qBFqyyNKfDh8QmMbkFRtjg6cTNuP/xIjg+3JWlrOEl+Bn
VtulJ04xiBNw2qkqj44WqQHj8LKnxbVOE5Bl3i+Xr1XctD8OaynuWwJz32eS6eM2KTg0psKBEb72nW+G5AfDMi7EFGNMrH2josUp
B6ian/qgh9JW6Z0qfoLPwMq/b/Z0DMixKxo7i1xq93DzDhqCup1OdJ05iKSUmstRcsslZAWX5xPmJGw=