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
be7fc5438c2f5fb388b7431c3d967ea959bc976c4bc81123a18dee68a61febaU2FsdGVkX19rOe3yjTvtMHOzRtTmz6LnUodGa2GgHyf0p17rMUGyiyI6a/ulO5RdylZrU3RIELBjGrfJAPvbfZvxldoT9YmHqxMa
e3OjXN8cd6q3or3j31YjWPK2ab1BaBFR/cLZqtsE4IDIe7ByeDrnlvTvsrKJcy6mamOGfW/fujcaAUmb5CTAQUsj3v+tkDmSaVSh
3d0GjmdgMBQPaOpR+W3P9sco+MC4u5NVDhN7QHoBe01Pl6trcg7TJdw90HEYGnxEiHUEp47J4/3bJEm7PhRLiist6kEhy0MQdgRg
rBM84sX40+ghPXzHLplQ6R4YofIhCw666t9PnGt56JJDpegWJKmuTaplenSWjZ3gQFvGHaKla/OXm6DYROOUj/t3GlK6spzMe7YY
f1LSjdOw2ebOOcvG6CPOQ9sJg8fAMzaKZhz8ZhzgAD44SI317qLmYhA2Phx/iGbWTB8P1r8QnszM3M3+nuFe2Hl/gPxu0CFBRBt5
9/ACGB8ZS9mIfXpaQd9chnEKrYpEM21kLX1S7fJxM2qEFtfcM9e4ZRenIWV8uWZhpnSKVH1RE2dv2iLiKEdxHANdmbIRlYjSN8xT
lhwVPw7SHszjRTnDZHSMGuYgYF4PvhllC2S+QxOT4QWg/EV1Rr5ji7WmUI4Rh6AIFolD2xjHX1EmHG2hl5wPjNKTEk/QahKJ0A0n
uzuWVYz78Q1fhrwu8UFoXi3WyEc5LsVWwME6UrKFgUyoLmHxl3knOS23DdWK6cYrlF0pU9Z2tO9IBU0TI3zSdd4BHw+xXSuRSt3z
P2IbggUDZHidKzLNUdCQJ+ZcRNV9oZSyI7mKDOEPTaG/78BZCFup2WvmtQIAsjL4T28xOeo/4ZAi+6RHh+ks6Oea9hsc9GdDJdhs
2osIvLH9kn1C8F/zZ7YgvO5EBR8gxiji8+chIdAwAKGWawVC/tKEt7X0egJeKY8xjD4U9PL019YZYQkfl6+CjFMsSnTKQqxuCZ6E
3pUUqsaGLYDmOsY1HjNuxh5ue5XQOvFX2sM/lCLKWQpRQKfhwfouMgT6Q+djS/hz0MC6L1Wp9PIyIClrn5hJUnubpDZpQVxfAfXF
0TVIpmMt7X8N3vwzwwDOJQsNZSO9wIvc0y/7ZCrlns0Xd/538cwzP8rmetZJk0fmwkcgqqlzE6iEnh/fdt3P3RJxOJJu6XP6Uskc
fAAr1QQ8Juo5QukXnH97tkmez7RDq9Y0Udo3/73Fm1v5HRaCVAPJo7mWg/KNOt9CyRVcodEGm4xj9JoTVtp+JsCZcewQ7foqBDuj
DKajSu7yN2XqgvSWl4X8yYfiM+0h+c4XFfcMMpCeGVrGASdxEtqb7YkxdljCoveijUzabJCjTlerzvRa5MjTmRTMptm3SBh5YMHC
Tt6X6FbUCJ4eKaf2Trl4+JoBDL6PQCwS0EDJa6A0pHdDpZhv/RviLfOLY1v9tj0akxgY62G1YmmvE+WfSjzju608VcW14T8Vopqs
c+xDgNynXFR6HrNI8Fwlj85McfquPlbsW/mFoYtrdHNfEtk+ObqgskSCqFJFipy6GtM4ytISoREYOPjY3iiOiZF6eO7Y8IjR+ZnS
e27pUOVeBFbVW9Iy09L08Z4QimipT73DtCyTfgx3mN7UPxs6oB8K3yo9hBwpE30Id3yCaVHzlL9mCp06068veoRKpUv2wuASx6Gj
5pGfzfb/Bhz3Xe/4HihE+oNQab7raiN8hwVL72K11OSJd1Hn1Y4TUC5soF8ADzv3hyoD2qSqR3Xc/lZgckNLpfx3EkwNPgAWSwze
1KEI73BYAp2n6KmuwvdB9Q7NSr1nHaD0ka25fXe5Mt/OZFssszWGohNHUqao1h8aHSEVmjXK4jXA+f1P/c+2+9+jPFL+rAkatMBb
bIiBkpGrssr5ot0JoX+LvkQ6IXMQX5FgflXeXckGqjRlHFd8/eyXmhLNBSW1E8OBy7TjU0Hl3kRQ2Y0oMc/JWPzK8utxx2xn3qh8
6k8oERdPKVn/uYY99HlTJkOb+77Vv7z8wi96Ungezu/p2YVBIu8ZOeYPApmcl17oXgCp7qUQQ/uK2Gw/szwulClvC5BIzuDPEXtV
cWu89hXeTX0ZXn919ZSZydB2xX3wle4ojB5AkOMfqHlJvuhcU5gKlFMVtsa141Y534AOmgASBhwYDU/8bgLbE9DwZfm1575pF6UD
MRGNnle9Ovtr0CSaD9CW2HuGSHIbaW3JC7LKaF92PqvVGo8hUAaWVijOpXfFM+wypAaS6gqBJtfBGs8yPElyUKkraPO/0hYePAar
9LYvEq/nhEYigoQxKNUMfFCvLt4EG0rpCBKLohQ1xkiI/EdPjJ90UVIXvzjPToTqwOpQsDJIp+DAHTB8XhtMCYws94YH7TRiKqc9
BUYj0cmXTkFiDBW9TB5ZDIxPdVaEvHe8TmFhU/tby/JiLhjmmnEccvqHJrVzrq7+pMx0zZVkSIqk/Rg4S3Tziiejr8HOevkPUx15
DwMCoyB6s35o9Kvf3Bd7XVhKSAcL0tDdIzUWiKy4U3nlRcgpWJNmGt2ba/nX5Syvx8Anxb8FvBWSBtHChQ1S2aBGotO2AbpbCvjs
y3ccwGWhuFGtB4WUcnu1gZh3nuawXf4IippMveq5bdt5NbanIqPxBJ6p6/oqopqLH9ovRplmVAR4XAqOri3cWV1qN12R6lN3M4Ww
8BoabVNYQJdneOCCI8EuNNghrF1Ii7/jKXmF8RWp810pdQmtQiX7wJs0qyutH2wTJwUaMFHncnOMZkMekoroDdf6GAaHNzrhDR4l
P0EP7l1j9+rf6OB1rHUl1gGC5ns11mUHs4PQw/HGG305hHC4RU56DVfBAgPLoHiQStpqe0vkZ1Km8v7lG0xho7N0Ur4sFgy/WyOm
6UENmnOeTDOQQQXC+uWQ2gcMf3TEpMS3CbNo5TmhTU2EcKxrowseH8schZmK676m6g5203bHTWGJD929HW85XLUorrGbdhvmdVob
YB8QTEXBmTkmU4RAwW3DVHCMPwZBzJy3mSrDCXzYxlqAM91nmzwhZKpqZpNDwnr2qDKbwwgcN/ENt7LwfnLcP6sH5OBcHVuexgzc
QSkAwZW3sBxXxiy3dycGwmWLU1FYI88rtDt21/4p/SPRHop73zy2I5ECSqO/5zwPZxppFSLlHBMVUtwlJgBIiChbEvTcdiFR+x1D
7/e6k9CcmNKyY7rhXQ6qtTzs9WRW//o14nVUHcLfuLFGLEhdVwqkpXkPulU0sZS5qTG5SYbUMbGArVgVB4LOhS6+sL+qHvKi0T+x
kayMjsLhmPK6RpjK6J1dkFNwT/4gNFmIMlucWwoiZkwMI6rCUR7Pr8hbt1wPoH14f/ksmVtGq1srXmcmFRLDnRTmqDbvwCk7MqT8
IdgR3CrDUqe5gY9ClxxttLYkXeZcDyvg58sARzJ+djuCmmxe86gFrTsQV5YX9UZPxG1O2TiiZMDoaHWERgVZ36VITM2NB9fP0+e7
/gdCRcp7N/S+kYf8s6JdPIWe5J0d3VA30wwnCmSTUgR1wxi+BP/0JqnpuRawmdsT1IDPD/U+D4WRAKcnnLx6i5iSclrxc94FdZr3
pTrAtz71uLX4MF4F4X7ST5SgE1b/BdNcRyqC2Ryx1B/zKpd0iVr4PtMHND0ZYY7y70aOS269DiZG7+PPTfYd3b7cGk4t4q4FhMst
82AYwUr6s97zY49rKyI/IWVgdpwKZLBP4Wuuv084SdS777md3gZ3kk/P1bBC0B/Mi1pY0aG7muAFbbc2kfkdaGdIWxHU9OrlN3OP
6AoFTDI+kU1EmiOAsFBfBTK3apT9HYnFdlQA68wBrZA+6NrNdFjsrtGMcuCq5SM8LChKqsV3EyXdSJ7xsKj3qF3SH8WnrGwqWpyW
SeV41O9WX7hpZyXDJf6EBIgjvy7ZMf8v6T7KZvLBb874ey4BQN3lNMQqdREpsuDMsCoTBWuBdDXsvzIrEksE+CTa70a/5Ju5FvkW
4P/pEov9PciOoO0rZLivuWDlp0Is8VxhKtaFF30rvtP+nEzY9JPDeNUgEPHJYbJ5HKIY6cc9w+B5YaMGNlUIYOtnyUHY6klozl/3
gb2LwJ0EeXVU4uqENGxcFkLtErFoTYGybB94FDQbVO3VVd2GXDg+RKqI9uIGOD8Ayz3X+4LbIBvXc79DzbQgsvVUzV2EMacXdYuy
1AOv0oyM3nPd0eOR6IzvLfG3If40+k7BPEBXbfhDz8Pa+yC/dCAU/qxEGHYkYcaletsdvunitIUh9VH/exUP5s1FFqjizaISLgdU
lXUp6PeKJU59RCoXVM6G6yBKGUCTxiv+eGHldaWh8qEN3WPBoimp3OLmnUCuY/JgZ6gvhiwzWR0g+C6l1JnmG6Qa9KEa9JDNmZC7
V0ryaoV6xi0gytEtG9LA19x3fvuWBk8KoBn+IzFUaeuW/8EClSPlev3/JSnKnwoIY3/Qj0LdrNuYQji1Pw/54+VUzzqGfgvE9pil
GUQKIIh6NaGfjdDd1XQaQ6FjP2eL+ljThrQe+cMjLPNw1Kg9mRAl2F57IuBR5kWQOH3p1C+76drTMi9banN6utrYYgYo+K57NWiB
Lssf9mL7NeF4XNzUS2w+RUX3gNTESUlaps4HQ2V6/T6IqMM1YAocW0An6m5dCcV+rC+HaihaWOdJtNIKsT/oOMcLQ6spYG3XFOhZ
yYY5y4VsZYIIApemgI6ixtAIim1hYZzIuxkWyJheSnK6g4KhADfXUDo3KMVGWAP5BzrPO4aUAshe3ag=