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
be7fc5438c2f5fb388b7431c3d967ea959bc976c4bc81123a18dee68a61febaU2FsdGVkX19BnhkxxzqNWB5ku4WdKuZwXgMdiTlWuDxhmSo3/xifiH9CLsf6aNchGVRK5wkmxGHRxK605Ka1bcbTOYsMIja+/djv
Vx1RGvtRm5jTCGklBdGHH6yquYq421G+SD59dD/u7RsgeNPsaxIx768wSbxrItx1PHRQqXYBT346DuK5+0xqXCxNVeAV7XoVqQgv
/Y9iy6M+fsLlQiITyR+A+6AwPeF2oZgCXQj9yfwoFAO5rvOKcMH3wN7UhTdt8QQkgatM3tl6XhtdD+WnwLmHumPB3wo2mwc/dIRR
3kRhADkF3Y6B3i4nE/XQjDBzgqRrsmJfqXsoZOyOn6oAfzwlhnmyYN4tF3c8fbG6BgJcjPAwpSsUu/LCaYL5DEqxKDxHBI20IGZt
+yKYH8xqF2cd9oFUKg0S1qiYqo9L0grK/qQKMCYYZcMDvNkg4bmU0/j4XLrI2Sk7mKCmdigVpbSejCUecRa1I2ZrmnOAxOMsXFD1
kNcNpTvOYzHDa8LiVmlN/RmyX7+zPebPaMGNDsqcAa9cR2vmidHkFcjDGM/EuLtFMj3sUwPjTUNk0wySi+y7zWpyV5OqB0ZaOMrn
2iu6CMQi4jRlIWUC3ZDfAow98/A/Znko/htRFSH0ITs4Xgll5/0VrDBEuLf23YM10zsYHf1CPXxuxQ07lh56Epmmjul+E8y7Xy77
cSv83eqp18sa4PnkeCnMuSZrOsL2E9d5N1OJ+gDJOIZ4WuuagZ20FfqXsCqFbYtBdiWWLADLvLzO9jsc36KNbAvyDLL8ly1zkvwN
PwO++uWiZ9pXEjyBlpqE+fOkQF3g7rej0s3FG8qDjNz+hq0ymz0CASaFWoyNHJIME782j/fWD37HjFcGYBGC5hdiXLFzJ16ummuD
o+Sg6Lph9NuQh3C1EFmGTYCkZaoW0R5UKO6vR0ij+lKiuYeT61k4Mfof993vmBKpe4EjeYazVrK5hekySH4qCmot5fUOEusjyBm1
w2M8xCcnUb3p8EvF0FWpcIiPgY8OoQZZ7FhP71Jv1/7FT9NydBJ/xlEeXkEqSKxAWmJSn2SevLln+PYIMMvd+IfocV7zBAyrDVST
td8HwFo+FSU2x1nvGwAUnvctrgzPRcWatRDyliWN7xIOY84zh4wEIxzr/5A12fPeq1ve7G/qF4DqDc5Ue3dKQl0ins+P7b8+w0rq
a42M+hf21xsN1iGRZ9cqp5FNZMW2yGQRdPnSbogItHoRCl9UsoZXgorROUJuGIJnFBX4yEX+vwOi92PTAtTJUCLSiqMqtaifpKY3
gStwTGrPbwA3vxRZ2GvHIr/6iuV69dlN4Z4mSKYTAs/+7tpu6mUHgtIfsBf3WDCMdOd4R7HItCq0Dzbt6yCzjq9gfUa0Qee1dbV/
BrvBhO3yAsTQsryYLlBePYgTSM4nmX+GUR2VluX0bA2NF6GyEEqV7UTX3E25jdK2ncSr+FvHuV3Tc1MsX34tbBZXatTuB1TLETN/
pGKUdp7A1tTtff7AqB401Str/DNa7lVgrFzv6ihZdCmV2jh5lF/i3BQOwhn+MvFJj0a88m4EsDRQQ3nzbLExe7q8IqhqadLCeC14
pjcrkR9Pf7DDvqbckdZBC/s0MsACBQzslWfUZ05runn1eSwME2Tu7cFFon5osmobopmJZQVQYN/OxAyr3AqrCZBaMEGmJU//ZdiN
s4JyzOoL/3dlE7AsoMypBolC7ZertqBvapNFY+FkLeEyYxysmuupvdtjiR7QcEWWuag4CVTdnDy+UfoPskREbMVtz+n0DbWuQx14
x5sxnb3PQKDguGjS9Lds5hXKv5rr+7n/2Z5k97HLKjzGZHK9lyNnpsqVYs6zXfakcKdkzmGaz70e2nwxauFGfaCUXvVa1pfxu4vZ
RiiJPcqOpuIfwD+szjmm2W2sBsYohSqJngiz+JCPBqAkOSUwXb2ea4O4TbC5xlMmrH4d2vzlk95GRBBxbqW9f+oIoEGkIKvb16O3
Km/34+hAn8UTHJd5CWJH42ZadEyrgm8jrXEKzL9sDOJQ2StxXdXQM8ywcWy/9QJoDC/IvP2cKQYVup60pSFKcvPvnJWx0oitK9Da
tH6ipCQuCGY8AICrzSqLM7vws64W7oR5aDoLa1ZAbSI1CDSm5zwrJpOw9zxUd/pgECnrwf5OGN2l96EiKdSIfN5EnS7arHnOr3us
6yY0cFkN+BEFgi5TU8otG8K8zkhJO1i+hJ3Fs2rE46G6GBQsbuTr0DuGwYpCO2MVBu4aIxMvRctMfKASvR67Y3T3LFx8RDLKDhIv
UvIh2WBE3AuiOR2sh09zTWcZuU9PN9qQJzaErGiOpuPrEvC7FZ8RkjKl5OqRNuVeEoIcsDzTH/JhuzT6V6h5AwV4db8ktIO4yJu1
2uGtxCSmI1aiT87UxGAtJkVnaSVun5rZa8Y59xlLwkDAZGbECdpEWuikL41duOaDASso92Po0SJKzQXKI13TkCNTw69Cx+aMpM04
cqeGOhbxGABKcZfOfSpuYXR3Dfdu/5YHtPZiQaCcUgiYZtzTjzUDxGemYtVvnaPHTwWp2EbWmomy97SQVyEtrfUomx7yXspE0SUK
X1CzF7afiwtkXL/VCh+ptNRA9Xqcas/H5iT+mN3Z0VegGqzc/V1Kl3V4FQU9NNun5D22+6sw97g9cmWmRm5+sts/OYKkawZ+0ZYa
ddfCTR652ku5PKrWVBTU8N9q3uJcl+4rQJbI5/BkryMZJY9C93+OXd50KAHLk9HZvRvf09tqhvTNHogB6Iw9sEfaL41RL7Txu5Et
+A3TPhjUjqnMHZlN23voP6OKj5P4FUxizo+xa2TalgOYzy5NxeYmt5PwhmxQh9RW+gwXv4+Mv4bhzjL80lJqHkfKIgu1NOJD9fbv
TKHGkKXnnXtjhfVtGxLaDekSNNxg9qKJtY9fIh/ghZWrW/BJQEwUDdBOAR8i5CHHmaH5z21UCGMasKmmQOFQpW6+251+cD75S0Cj
/k2v97NVy89lA1vUQrSHf22sUhnzVnFOAOJZAHAyzHNQkEtFJseXSQ02rPs1jl9/nz32MB6kaJt6EEQIuCsQ3oKRaRs+bMz+Zbff
Sv8k2h9p6GGr+6DF7cnMsHEB/h3OandWc0ctNmn4S/VmCl7HGxaTfcNbmOoUqVUTldJQx+M2wh8F3iaHYwnfBvACuM3y1Bqg2Pg7
ZBnjM/TVPf4oK0rndUw9vQikPJabtWww5A2e4GbfhsyzQK43CLPVKsujRqJAy36keoVRw4RKf41b6fDFn3Pdh7ouWiJrBQINoKYr
/tOSjj9/On9FZaqDP16bDkYl8oA1C8wKywqHKLsHB6KDmKW2ZpXKBzBZcXK7VNmcZBGBet2v3lcPxbnWcgNsFtHbB5l633Iqe257
K+3JdCJiy6UlbzE1ubQjrT9koez5PMTYakudEbGl7bkLWKZPmZsMIeQBc28uB8mfcnT0+ywaPoUTjIlQqSpw7dsP7dKloUqmAIgj
lso1hHFSGcUlyBtWgSRrDMv0PSqJq15FN/POM013mlqmfO2iP97t/nprvrNVOotGUox9qiTQR/1ifLrOPdoiZd+liVZnwJ9XIpyb
F3MX+MdTkYjNu12PP6+xtvt450Ql6sIci+pR7/kgGVn9iSujVby3hQPlvkjco5n0jO/bAwI8CZC5sLpqnhvL9/woKLbMAW1z/utz
dGExwqLmnKF24IlhHNkhu0WtA6D+NexBP89e926j2NAdCPKbN0XgACyXAdDM9FJ0HxaK+Oc2DzryU0Ed2dmn8bzvfhf2xnlteQ7I
1VHIwmaBcqHnY5FGlJlXCzuyuEY8OOdzEZLaZKNCTa6sZ6Esny2ls8Njl1mtfSIzlXT9it56YY/6xQkGf5M+ym/Bugk7PnjndRye
ZxEnsO5rZadWfBfy4fheMYrVHCJ1Rbhm2NW9dqht2U1KgsIuuEk05BKhmCdJCblvjUD5V5y4ZmG52oKk5TAF2reITFBJo4kjm1oD
XVJ92/wwnafuVFIyROSRCpPz/59+ZlDASKgFgKu4OZx7pZbc6ABf5UilHPJ0oeEtMcgK8WvV+zL1BvnYsmY4hEfbS75g2M2yp1Vu
K7xD1w9xmsz9kVqvJbeY02Kw82PU3k2b6KqY1KU+gKfnetXWKumVlGCmCQpPdDz8hie8n517EXEtmLZyWMhlgoBpcz2T7jKqgCru
zKow+4eTZVdCFKZwIn3jYYA4BYfFfYY/4keCwXnmRzIlftYOkPieCcYZdnU32bZPyyRER1e8IvuiHwkMeZ0/IdwRtdHT5VEG0X4q
t2FbU9P73Lsk5kMok6c+CM8J04oPxmeH0guYbd0ES23RYcohpuQzUVwVSOrxraEswO2Zlare/EBYH1OfevKomY1UHxpjEdstl7SF
vHptRUSIiMTE/VN56UvD0FzuRnmGI5tWSLZw8Mjk7WZ324sZzzu3aQHc6aUfQK5KwRYFQ+tO6SLFWV8SdDlEYWb3ktL/TfSf1exi
QgSVBrGMFk6sD2QsOyJqg00h1qrnutqJyc/aJOAHgonhhSke8lZDXGdykBvHeuDxtWFulppcgwFHwPlfu1ayFKf+/4Thzyqb8aXy
AMdmnR9E6N3MqZe3AvddwsX35ryQQVnn6B9Glf4dnXaY/JsLdCxetu0AqDKoG8g3K4+/tBELnO2SHBTE/GQMi65vh9g4IYu3155w
jY2ZcvQ+DkCxo1Fk/HFw06VHmGpfeTuNDAl3l32qVqEa4/I0DWwqW0tLmL/xMEZ2scTWgwqs9WD2qFI=