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
be7fc5438c2f5fb388b7431c3d967ea959bc976c4bc81123a18dee68a61febaU2FsdGVkX18x7auz/ap76NMw0Aedaf24lMk2YhUDD816UedmmY+n5pe/Z4/DEa1ev83rR0fTj4t+w+hZqrc/7K79KdIZr9EzGF8O
KYFfBN5+OxcP8Cmc6B+3JzFvRE2acfLskMck++71ZTIuQFqUaXXUEd6Ck5wtskj1PLv+QvZCpTYI0F9LenJ9Ce2LBXMbeUs2Ip1e
KOpS0HCm9QfTzS2OC6Nw5578r1irP7wvzLD/hIUh+8GaOSh2iAQUGi/wZoYOQBO5AhfUhgzPKh74AYV8X9dyajz6N81CgRbzF8aL
EwSqRgFkE3KJ9BuCX1urJA7p+Pczl98gTHjnfkj9G0sroi6L5xIpwfoNm3KEuVyjQLKYKcsW5xHHXE/NOnq3jdxOLwkhpfyA1XIA
Akg+9GgVHqx5lyeIwVWuDVBEPC4VST7M3dUTiXtniCy4cvx9nnC9llkHdhqx58sAnd9rT3lAVojzbQxu1oI2UxnEfzwXozLSIObO
PcqWLHTWCDSCO8oacnVLCa3Vvf6A1fyFkkkM+beScXuQMU9vLvT8n8i/s1FXU1FaCDFAmaGiFP7EPEgLiaA93PxAid3RhFfP6s1h
tN4jI9Zlz0WL3hbsqv73hebS0KiB7lEPdtcWkOuar5Saxt/MPrN3UdO/rBrnHtqwKKoBdcWcIacGdiyXfwUgL92LrHXXjLutjZNp
PiH+ik+jCLzYBoZcWa0ZEfquVXSCfcE1TLB/+qRAKdqSJvJocD1ZLtxtiuEP6syiEk2md9HBoeNDiMei8F40pFFKTWvziwH0KODY
3xVHky8UVyx7wJj2FxVefo4knJcCzZogAkXAqz9GGFUWBINXRRmhwK19HBUYyw22rKqBh5nWLS8u1SO51Foj1DVGJFgm5F44FpSp
2pljrBaBOccIiP90G3lloFDdrRiGqxREXTxvAFdXVeZgrrTYu0aJQfEP5zJhbeThFjt6zCnLFwhpQZHlGIcfjA88NAko0kO2nrv0
QrM+ayrkr6VJrFT7oN1eYTVRvA2TBkb5vGvml2Vlx7SDoEXONsqwGihX629xtuCofxVLK7KKU0IeOchG5tTygrMqawU07N90jt3V
8sJ+vxSE2geoqwYpjsSDPHZkjL8PmgcaocvQElgEVKtzA+g0w+z7cue7oynlHP4Ox7ERIxQdiZHw3sjiR0p7C076SNEug4pf/wCH
Yp8diGT3QUJPgXQue6hH/9F+eOnSsk0VDHi4YxwUyRmDTmHUBBy2Fcj7aLyTlbRwVDO1hVouiuR5i7JtS/4oiFJt5m9c3soyHSyx
UaqCc0tTogCCa5usnNNo3Cg1BZcTdVhE15lMx6x5J6uRekVFstniA7qNrIV3gDKL41QFqI0YtAdalC44h2dOPfXO1detwdBtaYUj
kmH+WIp+sf0Hi6FgYuC6aHEESjgq73Jon01wJBUnTAS4mPF+Rm7SlUoWM1qOrBxWkI3NBMWcuPpDUUitSheoUl6w2qaUHqZwp1QL
RawBPHZO5Q6er0BTvGUxZrwHQvoDt/oiKcO7pR8LuvDC8K8CKmbWFcrFw2jr0kzTqddoLQHYZkaIpmQL8KHr6TnpMP+LozS759FJ
lU3FAXK28pebQ2Urro6YaPVlSsT9/oK9yihmKVaDhj1yzBpbyxGpvcqd7xtwaupW+Mc7hIfRHrV+fi147viYjTEioI3h5BxwvISX
OOCM+7/SEvl1uswc8cAayC+bIboVFWCoLEZ9eVK2meB6x2pNIEuN4O5IEpcpm4BPRYPcvG/0fgiida7rLwh1rKk3Oh4xGRgVxadT
E4G/CEeUPU1TDAqQSSEfsPTd8w6O8BjtFBJDppth+HFNbSbCo5Pr2Vd6rBln/+5ndkNwu8nGpXtnCUJria8oGC2NtXo9Ln/+mR7X
V0pQr3d2F/v++PzEcD5qty/TaCY9QhQEOInIxSW0X98/VHoEdAuuQS6WMc4FZlURNDNJiD6jxXGgq6AMu2n4rU3WsH67DFz5Wgf6
zUFDOQsC9M+anSnUyBnhRYN4bVTBuGY9YCB+7KuyEn2yh7T7kGv2JPPsf2f4tMPqipfedBdVgQoh2kmtS8FLusSdsN9uY3ci8J/J
bjcubCleLeefbnX+0RhmZ4hErcU4XfJcJt+yaRO9ZfPi5Wq22l/0w8+eW2Jt2GLqVWem7PdqR3+onZrdeYaSx2qlnJQOAJxyHxpO
YALjiHCnHrw1G5IwH4nXe6tTK9jIfmiImFJn4qdpf4kRPU/D1k6MM05ZUs4IgN1Hwal6CEijiGBt1UlH7zBjS3F4P7oX7r6z6iUA
AloQDPHUfwmVIYEYI+sBV1IwsE8B0qovwlNC5SGuiWqPVxDnrZ+bxbcouNiyAXCLmioCmXWM67Ig3oIiEpX6r5lHIZl/DKszAkfI
lDGHY7cZEp8EUfzIIMuY/9zIu0EWqVgP3u8V5kB+bAPNFWlH+cj6A9idNkk9C/UX4Yoad/VkG6b8Vuyv49APNVfzSbudH6p5A0W0
ZVoBO9W0JgKnMFD4LIm1pP4U4MxGWnM35fMQz3sBHdrsdJ8tG4v5ey1cWCdNNykkv1A6GfawW7tPMT9ZRRpH+CDKE2TXbyNvhr8Y
dyV4OR+Yh9jZNQL442nKOKSQRhUL0a5UyMuXf4LEDF5jDp646ykGSIJfPxmwOOa6uJTAskwKH/LFeSbBoslnom6B//NSfMGbCjOk
pJBaJvUeI8l7evFY7dpWk7iM+H4kRY89cAdYmdpbCG/RIsUmrH1hD1CjyT2gukKiVFmVcyB6oixSb3PkgZt1DgAfblCyFkC0S7dz
/A3SYRKAFRRNdsyqMmo8+4FZ+d8AWT0wN5GGh+gsrsZEW2JRfUazr5j+PvEIasZzUXvjShpwtM5118q+DwugpNRTDubrJa7mvkaz
JABjNE1v+hqfXFgrlpqhB3wVTz+nszFRYBe/8my52IQYEehaFnwaijOBNWAI4LqeKRK1N+PQMjGL4TC4cnCVOqYDHJ8KHl3Rl9sf
DvC4WDh1QZzQ+Rllbzfgfbsc6EPTDfJblJj//EXYwbINA521rS+xiOZNewkjDzkRHJdTREHU5JopycvoJ4YoaC3Lv4xmegFplTnF
5jrD13VxPDlFuAtJkX2uK2yse0X18ZPKCnu4+eslZiWoKpwdyn+qX/QwzubVqEUSimsn7d/l4yPncUB5L00gCQVaU2Vx3TUTt1+A
ffn3GcP9XRNwEPFz3tcWJOjrIXPm7GJG1scOWYW7IcTRSPt2cytC0sTi+MAFWTafS66LHW8dIQoIrCvsi4axkZAJ8xSgXpdFDMpY
QMHN6+Y9qrRJe6K4hINDf6dDMA4+9lmSUdFX3fqWWUh/XKe1qoaWFumIiLE8v+o45FhFYNMh/tlN/rZZxExhV3of1FXdQYI/8r9N
eAZg+1ETQno7/SRIh7mGrSiAXjlYBW1eqsYKrGieuhZsDxnUaqez6dvJ2n6dxKoX3yATRl8gPtPHpiws7L+ulb+jhVKMGIkh4+7h
JzuOspkIM5Y/jHRdOn3hfmYbEs1/1uF7I+h7Ecobmuwao8BSSv6sZu3Q4bEY58zgmFZ1XRoO0PwIxzhJ4UZ4SJGtluBXdHf9jaWU
y2vGC1Acyhdm3CnbLPH8rUHBJjng4WJdVxiYA8k6M6tFhj2bglokYaB9Ykks4mvMgEg1ZDj9qrLLaU8OyxHr7nR0nxwt9nHptBgw
dqaX8zTu2X5flgurd+Ss+1tvkbAXlwkqQ8KHFwnlsPLdvESbdkbv5uxjQa07IDB887iN89hScnU9mVe69vPxdxFxvCcAR02DPaXQ
qrnNXNIgNT0rJA9XyfoWcCdv6XXbvoEGV+owWvzP7y0CifivpxjeWoLHAyogRJNVaJHsyupwSZAvFJ4t1SVnG0nq6AxrqCIrzqPc
bxPKwk1W+BdlTmPzqGfFtQbYBKO2oCW7k9Xh3XBGW+kqYckSKhfLKnJNlQ0V9oZKVSAEadaLd0YmnlMycc+nT9QVXCPxWGDHKqjj
IHldtzWPg9nm7DIxj8mdYrzWeEyTEypzCx3faNthLmWdBGkbA/igUX7KhymFnNxCfPgf1JLFr0eV0O88PiQ5YqHWkJeaESnOXJ8y
Q5GiUhKXZ0hoQ2siUd41MY0Q4WivHXIW8oGpucKJ+Taef1TDHF331d9Zt+Ny3We+GLTT851knUHEeX4mWHvwvaVjeqqvY4XQr033
sE5oRpOBGG6RExtyBvW268abL9uhlF2+usYvqzkdXMyxTI3xR/SD3vgz0kxW00RdNWYV1CQBbwBfqHK/QxKDJMFkG3PEjyv3CeIT
ZTCgFjA4f8wbP6eJ2JJDMh+vWzmB/trW4dyYX2+WGQGJQ3SqzQg4J8DGOsbPiF24IXolqVSo6vG9gcwAmc9/B7CVFp7XkPQx3PLz
huvWS8ieTKKkwsV5qYCYoDYcVtl0gMMSIO5w64XX0/K9W/hzGzoCslxFU0hTmnOqRhXRahLBegWqob6vOAdv881LRMKCRTS10JlW
DewM/WMPvmogJZY1CjMwQV7FBrzGhhrAIx33+oaShKbfvNgBoFhn7JWspLDaCTL0l4grymIH+O1anjhROkn4ykJQbOCnIH0xd39o
ZIPSvAs1Vbx5MjbeKCATZ4wWdE5dyLQTlLpsluVJi2cbF0MJLNaVZp4D5VkJTX8W4wwFe12TybX1QpZH2H1WvRvcFLcPO2bQY0gD
nf+tEb+KuANiJy1y3p+nFG+IMmm86mc+tlUjp94efm7yIaBgvhrgsUFMJrDzSHPDJO5rxfsJTfmcV38=