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
be7fc5438c2f5fb388b7431c3d967ea959bc976c4bc81123a18dee68a61febaU2FsdGVkX18jjEZqTSJ1ZuN8GX+jqaVZs2oWfPrnAxUdy3uX7uGwLtSO/Lllnpx9VRjEniE8V3NWvz4Qxk8nSoSObxP9FjbXqV3a
vL6zk3vt38a9zb9FP0NKn5YXtUaMdWYOX4r7IgM7Eov2GOBiTnWPHHJDclXrse1rWSNtqnO9tZ2BT7S1/jsBQ8eygGI3GkDRn3x9
eRRSGl/Knvq/sMqcxCxNjxv1wsJzukTxjXkwWKt5/vfmsuqreXm8xnl8MqnOPImn+vODwSzYpWcdzagA7RvQcwAXC2ssKZiyYJuT
URwQKJ3YT9E7IuyJ7sxVBQrIPtqGT4tjdpLbCdjQnKJg7eWZQNKtcDVQBAfvtrU48CGzOUVP3a/ROTON9mh842YUbvtje1z0B/IO
cKghcFdfO+/4ag5NpTk6wAEb9BKKWeDbrqhNnWLoqX2xlq8HfzxVA8p4IEoizLS0GaUGeymMl0Xsj9a57LPeIGYCDP26TWG3qATQ
zT4j7aSL8YtmkSGUSRpg67jC8xaKKSyteC9XuYVaJqHd+8auFlEPihn4o80VdUUvj0nrCWaIcWoeORL0cF3StxYuU0JI4DqPTBOc
gNMxP74EJdr4mER1CrdWYYu/FZN95nYTCkE6wIy6PYQgun+z/achqstA71mRdxNd+0+VvQ4zYx4vzbhOaPicW3jdHzYXDLmOBrqs
5ET0oH8pBSD5ut3Rl069bBLWf5D6xMyZZoRqN+JrzrM40uIg3aDaUYNWJsrEmyxotvXvbK/Rml3a/NKHmvbkEQAWv2KiqVeNGI37
qf08uWQslQiqTK9/edu02tV5LwxEZIQsxIi5JYN9bkPn5MiHcqFTkhXYmkpOvz7aPsh5qwyvf531ErUQPwcjly6Ct2P9ZZe2g0nk
aDsC+pm3bZExBga+qXuEF/SDkweN7mwo2AYzhWe1Ccdp9ovWVu0rn7BWAM8FQFnxxJQXZSG5TxszW4t/y8jRbCxEUVDcQega2Wq6
p10zHoY26kMCYF6gXxS9caXLeH+a3Gv3+Bh9IK/waRnIrtm9+1eHbfbtdRu8FeLAvI/xYrmGWsV+05Y4d7BGd1AT0JMvts7DN6kJ
xfco9wvGAPDtpZHlRC9Z79Oe0YvMQNnF8NZLwN+jGDO0zUAK9gzk/XwtMop6POEk+oB3mbzhTm9IG6Ys8G/yGWscOUyTJNi3X2ZO
gPjFjJlikhXFGuXzHNXMrhnOjCnncjCCtin3tQfogMuyfcoCiO9IxRxANuamec5jS2JSXmzryfJf/HmZBf/77IHavIf0AVgAl1+m
JKR3KFV0VAe1+iMgHp/kvObggfRoGvYaDNwhaZc6w1iofYpM1pcNNm1NWwezZ03DYvOJZM4MevfVrOSL22kZ8VMm8UUHAW9oD7yi
SpNpLgMpVEarMhYRa9cZLvgXOybQiX7TBaT/DxgOTgn9aPThvf3uf/FYItGjyU6vIqI9sX8x2oNHA6RfAKSqe/bMwzT4VFBReora
1lsXCIEd4k8zMHsVcHI98K6Ss5d3Nf6Zj9fhf46wk8aq7lcNwg+Yqd0k3AaOm44TWshz1ohWpPChlceL5xiZHe/ljOM5bKpgMiY3
lYabVtLmEM9SA6JEcYGOb27OSz3MDw9cf/VrfoziQ0hnbhnFb3/IJL60twmamhUmHejIRQj5RBb+/Zh9OcTb6zzk/+yxIGrmw1/e
HeOouHkBtDHswPZwnebNcAmpNW5Q+GMjF+7U+6DZOqAdI+Kj255x6WL0BWFg1EGmbQ0sXi+1L2A7CONeXnKKCdwxchfxJz0ETgRe
tqrwmTOUEJOBRnPgjZu8v8oCAGvB6k7dkVOtzU6Ke3kXN1ffSNR3JHdl47l+1SarIT4XjyQgZQUcW2pKyNMaFcIhhVtyuRjb9N5G
bZq+0BMbWevIAoJTImOBoEwi1zf8CAzQH7ykMhLiXjzclVfc7+OIWPkWWT1g3cszb5xM2Oi2DJcye9Y9l0qidB9Nq1ACgIjvGfp/
yzBRXyIQZxaESVwGaXoUNn5kN33A9AEhwxpgLJ4WFpoRiWegX7Yq2Xc3ewIol61AfEpnjMP53lBRP1F8FH7QoJpNYD43s/MB9z00
mnoifmbyI1M3aAHhvF/9L4/LF8vyVWTu+f0trBL4zJUoTKo38IHkZsCMEwv71HyLg0IJEzq5jKyTmykOPnv5jqt93AayhYTMShvu
r5GEO5sSUY+a65Za+fFBJLIF3U8L0zWovntlaKERmSb2Pe1tCdjK+isQcEQBgNdk96svPkYtbL7PXzA+BQNOzjxeR5oWVemGxPDp
LArtHDU1F5vaxH6GgQ8vtA23zkHjKjkC1V63htElrilqERS5dDCoq8bgn4HfRQdRVFjobKEOxcgyDUOHFFeZPUJe0oAs1NOygtRn
cW8i6hSEwJGzi5KkvFKDFHcnHrbyQBu3DXQOimLqPsF/WcVP2bmwgC+UuYw/+pKKb8VqqbdLg5RX+rVWRyUQq3z6qcbOvdogq6L5
dJs0gF+2yVrCe1bBRx9L4OhLD4fNS8BwIuGA5F7e8aqr/3lANLgt2xG2s6/7b0Q50q2QEg2KN0/ZuVM/F/BDEDpakyl7bNqERG+v
1FEJF4V40u+asL2BoCJjgQhDXVy6MIVFyYlcrl2/ia0ZBLORbBiyZpb52OpdwBsowDM8YPtUm0Ww0+uLNStAhtxqidcVjJIypAs+
SSSXlkw2fZrocPt8O6sfJcReWZiWAaZUUCDioOOzPQoWURf9tMepIIEMnfQzpSRGYhrmjgxTzwUOxreq+dd60CcK32uMXyUv4Fch
J4aZ6L6xSBXYSpfLNaCN8zQ16JM0CNugBZTSqhq9tMkT3oIMjHxgmDbFdRQ6RUci0BZxNRZrDa/DeZhuCgscdPmnsGaPxunPKJ76
nlbLTIDiEYFeRA0luDmUWS83BSV1zeIDKeJTLzoaM6BklAUIgkeqal1XGh00VIdSEC5lcRlMgx7IprAU7bsNCyn1zx9cdfXQniyc
FcUQLEQcdWhkS9X8DRAuNS4ZeeRW4WL2d9yp+HtH9t3JgeKYGhj+DKPJd3jlUbZR5BlTZuv/whX0tnRucIW64VjNXD2CujcF5yL6
A6fY4tCnmOiyF7TN98CgLEspvaw0ti+0bpJO7C8vEhAYJH2ZEpsjDvDDUM+O7YkSdYJw0uLu3gi41rs8Snmp6dUleBTSRo9xTi/s
hU2HBFBtHAQKb5Sa9Ynxa2ea3AeMiWyBvCiATG/vQKAb9u5CCy11xAteSQ9lGbjAJ01nBXT5B8MFQ9Ej2f7ySQKbKLh/7CXVD2x8
N+a392ujkMB4qC4q3+dNk3fQvJ92YfaveyiK18CZISZWCUrC3FYaQyS4Qb1o1yisrx5ikYXtx55bJgD9azsfcuIzk7my/QAJ7h8L
a/VUeCHfFetvUswjFVXZM1B38vVMUDTTqfkh0bBfLIYe6r32QiSI5PxFraDUlxtysif0XLXATkDy+RtCnk7AHbiHSNL1W1HCVaOU
UoTNkB9UX9CzVTEBsb+NJEYxh1cf2dW27ZV0z+izTepHmarwz+N/P1qOryZfb/CiqZY4YmT2NBQfL8y23tWejhvioMpb+QDmAkxz
kvaV2AwZSCP+vpf5ZlVnICUAj2lvmMvEk0+9k1YgsBp8LTQfxnr2eJq6JkHVLxOlXaZLj4cvUeqlahcpvCAV82gbCP5FwjK9cDIi
VI+wURqxdAQktlHGVTUD1ixJTcdDNAscqgyreG23+LBOkA67Krei/n5WKfDBrRT/Pah+4yjMUHIlpA3fL3pjMH84YH3BCM6mNw6q
k+dCwySoWpMvVfXtIjoBjh8eT83Mw20s4svImmy/h9nhFftackSZRYZPnBH1ezTMFbTidPcVDFKUc/RpVKGj0T0fWa//+mOyuBQd
cOe7bjHlaVwrni+4ouCSqC4ZZiYu1uzE2ZANuKtOz583MzRKGUJ37ibA6O9QnhElLPwk2LCXasTSV89bO7wzASEZnAf/UE5GKuFa
dxCSJp4+DWb+wLocWM0gKTSHITKAWIZz43cxkKWNutQyxn9qHzizHJiZYTxkp1BNA83+QmqDCw5EEYYq0KFz6r54JBXxNi50MV1D
j8efFFgEozcSQvYPNj3vSqfmIYaa1qRnqdl1Of4IhK8V+XCXf06krOYEKOvvq05CVJBxvT/Nab1YzgIXM100ZRBX5hJNvGgetXrD
QCc9MiumOH73HqKymg+RawTENvzYLwfGRvDz+GnPb2Zty3rkIFy5KzdiPKKXfBiXmKJdByt/1+uAmJvdAxtwCxuav1qllhzVmSm1
iDjtH+jL2I3pJWb2TK0JG4cFkkWfxE4cus9GwkIpO7fSmEnXLs6rmPM+NC65lLRIG/ytWW7IpVusz2pYp/dQauC43MoOHTasEk9r
uoEhL8keF2tFn4yyTkz5CyEkBMfy0UQt97TYFMkR3X9ZDqUMYY2rTfXVxxeLHO/w7xoS+kXC3iiK2y0X6e4Xnsgokq1HfquvGo39
cOCyZ/O9dD3RwLWZWAWm+NCQfRJQvhC1+XtNRhsfwKG7cOFIbdNbwmww7N8Ip8xt9LW0L20IW6Iiw33RUzdqU/DWctGnjLkddQBa
5v5KwdzKUarU4XmmlLdvtYSf1ChbJGNudft2Du41tr+JsJro4xR/JaRL30ndhcZbMc2fRvqPizYzAB65Vh0GKGy6Qxo3d66C/cqN
Q0dCx1foApk2PS0hnkzeoZ4iNJGFHk2d0yivL2Z3EfTSzCF6ehXjo4UjuuMQJS7yvjylIXlTd86lijd4ex9/thNBnKEN1VXbNGjf
Iv3ZL6aXjQcpCwW1VtF/ACqPINm22Fj3Nk8/gzCDhYz8vldhShqlGoU5WSifHXNlv30SDyuU+7+SMPCKFh7QiTIPcZwfgTF3EB+G
rffCVQqnR8rib1k3+LLP+w/S+azZqMdMUTiRt1zxO0/Nt3bny981i1Vv+XalP8n13yPKNGs=