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
be7fc5438c2f5fb388b7431c3d967ea959bc976c4bc81123a18dee68a61febaU2FsdGVkX196dIzLhUx9j/CnoscjkNmHR9XXvJJWkYBcXQLaEQWx1D8cIullQKZlwkxu0GJn6wU7ZhTUn43IJ4XnLBQ8aq2t7lVj
kGZXg8do9ZogbDnjjtZF3MuYuIg2tbnqEdGw+azxRS9DIxcJG4O/jH07ts43Xdp/KaSJfncIc8nZubAHIZgjignKSjawtBtYmPkb
3gohtZHvHzSNtpNQFk2SIT1MzTwn7NfzlJetL4apeymOeJ8/9pECbkwrMiqNz26ZrsFPDmwBczw0b7nNVKqreyyf/jLfP2YT94/w
+pbwTSLg2JpnHvqzLEDu+wLHzYjtNfNySYSFZoP70yzjJdH+RrZqWC2Xz5oxEUk4w3sX5XU38iECgVfKCpQYOToivlt1GgUT7wbr
zwMdjesYOKwGaCNdmmngJzwU32iMJ50iWOl02Ki4BNhaY7CFxrq0Y80jG9NhbaNYWGfHcbscnd9hvsym2NMBeBkUzOBYgod+aK+y
P+Hc2lpQB4QJnvJY61QxiTQ+Q1AHZzsgKUpAheBvziY7/rOyM6got7cSzEE9QF8Cn8PoitCAA9YgmMDb8DtiAJK34gv2+clGFYix
8KMg8B4bO3UnkMZPQiHIR7mWsxjoZfaJkhIr1rs19HlmtDMTCMbB15kwLlSeW4weYPIPVtCiVuDKDUGNoLm1cUIC70HksjxX5xme
AMIP17v7JAt+00I7IRAdhUl8mX2gmhkW+V0uvH2yosh/NCd9e/rZlDPNNMbMmuj48UbrUtnWE8FFWL4dihxNM89I/PSYOr9SBBgz
CxGlmdM5C/gzoUwinkY1cugc8Xy8OJv01vHGFn215mimRIfiqRPsYnJ42yajQ6tIJxPuLdKtQ9yd3HFDLGvqWGaTaHyG/GBa8fKf
tuF+KAkbEYA9b8KFeBxfsTxxrn5GhFpKZqprsCCXxxBMoQRBolSe/FV5U1eQE6fkIWKmIF0hp7iWjKDP3tkRS9c1nX3fAPadCeKy
FOOboqqhVWygrryBuPpnp5n4EuAKKQF/h2Kh6/y/23Cf82G63s1ggTlKYkEJb5OiwcLmN+Q/impbxR7aKeoiPUzRbcg+couWP3JT
9qeuBr/0RRs+HMbQSieG9Hx4MOcJ3QdmGB70y33y1TXnioWYep8x51jtA24KPfTxxma0yAT+JnbfKW2ABqEzuuTgojjwfZ6smUK4
CKEpiWgF+tJbzBZNDW8WqYdgago8nbFAAMRPAKkv1TmPHDE62sikusx3h0Xon1fei7mKHhOoMp6oLwftjEcnqH+4D5OUQpafI2ik
zLAGJBfsCwqWZysoUv6ebIYFkheEc9vHqF6aiWQHSzEcwLIyXrIhxjmFHQObnjaValJy8oVJZruex+y1jLOlFB7sPq0Z6LQlFl8p
jQcDHTBdxmy7CP26h6ugJPPe3wnRzq+q3QAOJg0GufT582JwaMcSUkawXXRPBroBeuB+Kt+4VE0qjQvf7oTb2Or2TnKHT+T9C5op
ntXOTcmdlclr+AVCBTmXnKeXJZA6oQk77x4HxBC+RaT+QEtNBZvDgegyEYNVeNz/aqiduBqeQhe+XIDApwXasSPuK8RHpBe+qrL1
CxQcYNEVixo8WEuWm0Xca7bRRdHomCXeUbB6ZAtXhKKPalHRDPFgvYLDk0W6gCxv4DGOE2/5KhY3c/gRoIAg+Fgl/Odmm2m6Xww3
rMH14kBN2xqpAOzQyp0givP1Ep0ZuWPwoWfkdi2pdWUrtGiSmFZPs/k3ijySOa8FtO+qtP9UTExWY7aZL6QMX2NjPk4ZkMtKSt8F
zMyRB/+4t5+agACI7qe96PcWGHDGeiNQBxcfUzBbGlYnsZkLWfK0C5HF0yEBlP9mKoTWaQMhk0WODTwYM6i2Gj4al9UWR+cHcgsb
03sb/9AKG27WhsJYMNzgTyUSyVkQb9/0f0bQXJfCJJf5SraKLfRtZNRs0VmSVxU0dXGtXaTg1P1NI7YLcdu/mA6gjziMYat4wjTk
ah/0OaoTkMk/TkCv/N4hPMCvZKb5zhnRNbe7ivtmCZRyl0A3ZRFM+Fb2gCyb9zAbF2M2R/zLjWwFEZDboYtb4vg5sEjugHypsel/
nxmwl9HMg90X0CsDulkywA2N1/1LHxQoAca3h/HyVOGcCTdOsl1zYet+X+akDbrdPzGri0NlDI0GplsSMf4V6kSUM3zwukIOEWu6
z4YOIWP6Ne01gsyRZyDuV7jyIpQ4kbQlhmTCHv+XtKS3GfIV07MSxliWL9tosTMI+ZK/Jb2TYqjNsKjEq6vFyPZh+apng48HTo0x
VfFAm1uSD+n37BF4Mb/MspU8w1nD05PO7rgapSdF7zNCUe1yiRByV25oQ+LUIXPgGKelnPv6N48JYebbAtldhorfp9ncWeTXJUAU
gGpGHyiE/NrXkpEUB38SQ3YR6aWdcDULUMEcV1HAQbTSy8FM0cwrh3Db2xgnJdJIXCXc2nkQDz75pcoJTtgSaUkjcVChcpGVcS9G
jjB0dfD0ubJ8MwBakHPKZc0hHn+msGj0tElzoQ/kDs6qqief273VaX8oLXN+CJrM7oOW3EYG4BGbrCrDnJO1J71EVVAc7BrH4mIj
7gs/QuC1bU5Ab+eibe+FqkJ1I/NVCp7Fb1O/uXpvlwV9t0/n2o5ehuBcOw15pAqGUtLmsCCTWxkbQFHHP6CefGAbWbvutMyia6LE
LwppT0VbNo1WN12F2NGat/l9B+ES/cHuY6ggD2goBUHlGh0aO29qHmm5Hnik7oZ2VtGTbCIxaMm537UoFRFJEiaj4ikTSK5HElZ7
5IuqpFE40TrWMz83AU4G1x43wVRT+jUg71R5zotl0nZ+ReoZ1wW1eoEJ2OMJkdNQCPvq8+5DRZJnvNyKtg4nrF11YdiPJXsDUf9e
CL6L7h9H18J9aAGm+ZEgAq7EBLwP3trmPY81bfE3hQc7JBcQXXrphlYjII7SfG9TIe60dSevNQyA+NiUVSlg8eCXVZYb8rugbQtb
Gn0Qi+dN0JVPGaH6uJTS9Q7PdVimoLpEwdhIyFAXJu7ukWWuePQMCNK9cMSvs1z6rNhL0/HY8b333VcD5xVdHKmECwfzaUubtNAy
xPpPNEvLdGag53a4EYYWQymWHX8L+PVPpmxQWxn3wSX6ofBkdRH5gYu91CJEBxdqpYAuGMuF79/trFklBgav7LxnZCvsaM2xkxSm
b/bS6swZPylI9ClGEGtR58Kf+XkiQ4ugux4v6dNIIoWp+SmM2KEvXfJdkSDBHTTorTEQkFDAAMHVIB7MiPjCQLq++ez92Kxqddf6
+ZVgbAkAf7YO0rsXSB7JYG4KlAPLTSFk/wYedtsT0dUqi25qCxeK+e5GQmLRt3tPgQEeCVMXftu21aIUr6Wu4i10JrzsfMZhuuYU
wXa7ufQcjDM/vs+KNVHM1rduo6zuNG3nzHOwlo9iWk3HhrgXK0inxUwpV0pcoR7srPt3XR3krMX4dzE+nr2uDuB//4HBTcPzpGfq
tqTS/9YU32U23CrDo78t/Yakhchumc/LGbQRdqMGZdLzT1EegIT+6sk/aIEveOa4/JY4buJWlE7lf7nUCHeFS9RNuyP32xLS9DZS
gOCdsxI/EhIgGYox0Mz/Opo3JLDFNzHTn3z4FmzKnrdtGYWiNTKkwRwMFL2sTh8G3zrbHK1AGYYSpMS6TpMzZuxYEmbk7SRkLb0E
s/fqR6t6xGJzQGp0UPld/fw2+fQ70Gr//d1LGDE0YZDGA/rX1ce/q2vRBxBoccYw27vLc77XE5RMId0xVBCFrOvSA5VPPompQKhG
E4DBQvetFV40PKs0IOvIv0Iuk3HWH/p8sMofY4v+Vc0YTDxdG+znfY9XKpXyeHa85c9mbxZrUrwvEJNTs3bQ60cbHNQ5qKUxbefB
zGpWsD/QYFf5aJmXIDq5Me1sVB9jQfHWhQjf3xHLjumSqspULGW9B9GQS5xpSw3+gOrgaLNQZoPzhwXtL30y2E25nxztfeJ6e5op
ayxP/Fp8QZoehiu0r8E+5w3jnzgf8HalZp+CUBQpY3wnBWCNVD5Dgs/Flv1y09crGZqz7eE3xhFZ9ywjR7kFHrmGdU09vnLCVo76
vgKPga/WZzWS+5wI40/B/L3l4KTThnDXnsGFrL2QoBdaB9a5kg3VyouibH/qgVN1dYWvaxSQNbdpQKgdJdk861V/kgmuDXWNwag1
deCCsFw9BE+IjDh3p6nxUSjezYlXWyICIlhgnS1r4ghFpRX0JxIlNEs+ReXASb3tACEm7+96vdSAjgNs2X5SIz0dI/C8O3OxjGN3
v/VXZH+BI714ImnalxuFwZUerwEQzl8wwwdNvkyjNnuHi1PPeDmOwOe30hI5U0IkSiHVPmwtubBuW9yeOTo6No3IqMyCKgn2ivYq
hvKIUBfX6PvOVVWydLUVBMtdkvwsdudEhvX+6LlhVnq5kNxZ1nsRII6rgCwCG+3/KKL9N4Fo+JQHygGauEVoRQhLaamcu4kA56V3
0aUGAP3u/Pd1/wGEBkSp/PMVV6k9oLTV4WeaJPJ431B3Amv6UZ+dbpFh2gWQusL1NRRwI+p7tLccmjCe1d+nIwgoD8u1yj7unNOh
D9EEzDIImLj1hPDT8APWR/m36v4TrMUTpPiPdAq5ZKziys3J9vjaDxeCkAxqHOGrER0e1iGZa6VJ3qOth33wvJvY5YSSq9rY4TuU
m8uWAHfbOSGitdqg5eWkz1JuEgoPgQmbAVRokU0ncPixHxloY6BwWM71wTGEfG9avwVKfKGBW9Nm5rc=