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
be7fc5438c2f5fb388b7431c3d967ea959bc976c4bc81123a18dee68a61febaU2FsdGVkX195t9IRSIfIHwvap0YyaIifPMXyzeoqYE7h1bHmd+Utt8QiufEz5soMOmhXCinQT9CP0M8QNGtA47mu7TU/pJ8rlYv5
pdPuFkhi1AwtUIaYmET4cW9RJdawi7BkVIOSpeVAu9kvTIs//hgWcqpnVM5n2X9gn0CKypGpNlMykP9SNiXX4RykfFWz4U3z4mDA
lQEjxKtyFMKHfIFFXPwrZZrtF5hpV3Rj21eHFwlqVGHOGZUlfV6OGtGrDk78fMryzmUg8lOQ6kT3+jbuJOYsE4RRJ2tjnb9+gsm+
6ZMm569bvB+6i9voinFNFohYrlvus/s+vi6sEFYPl/xa/U0qpJArBqkA8+JfZ9xB2uWbgxInWXsfvcnnl/V01cKrRiXJRzhVRJON
/4vC2oWS15pYh+DjVi+9XAH4p07oXxtmKiL+qUKGB7A9jUAkKpQz4VJgzor4MDDj7nHwq3CCzF8/gxAwQT1BjlpAoKov+iNlX6Ez
pL/cIlCeZ33IchSikb1SsiKlovnTGJ8h0L79+yLd5zyIQdPQWDin/dKCQy6luq56qoBsJhDJcTNfTHX1Ltu3uVWKSOzRf2AB9Gi0
35mCIfev1aG5ZvWngJ6OR5GiEf5Y2Czoo3Y081UpbOCsWD83/Y9Ap/DFTbcMGanNaB6Y7XIkacrV+Iu1O843PWcbsQMRxkKEkAIu
wmWVB1KwOgu6Cx/bQRvKgpBKakqy+yu1bFgEpE+DSNs4xgMDNmWoUadXP+om3LVG9z+cKSFWsvMhalHl8wo7YBqbPygIkKDSjcJJ
Grb6ASwQq8WhPvbic9Tsz0Sa9emtyRbVlYBhiodmL54RtxM8TJq3t7ww11y0uq/LmfqAJqZ/Hn0Zgy2IhlApUyhhOi9zuSR7AJD+
PWIbcl3HtUaipRccn8vKNl1BTNlrC6A3mHCsZnK1OeC9c0M4wopH+pvIb3b9vay5xen6cZn0tQIPfw2fpusHQAbSBzOgb+qoERzM
WHZLRfcBdLa79dVPm35jT3pRreluZJ2QdWjcpzWGbT0ZrHSiG9lck9acTyEmW5sAzNiH0OJn90MuML9LgTZeyu0todTz7vc+wjtO
PHaphlhl98Pnps73Jpx9S7npqW1BSbNyu/ET1gRRwoTC6KrQk43nxocnpnrHbfWzR+7iaA8ees7jDh6kemjW3RNIx8+6f4W/wCsI
sEhiY8iCkDEZ1xiIMriz3PAGtgGU+vGmrJdCxucGVaXraIUKTjniP497LK14Sk29KTAuwAjb51x9oiaCjrIuqSzDfFgiqJDBBbPI
a26q5LUZLSkd10pqtL/LKFA67vIyMvl6ejEbomB9eZz4Moomf84jFUpdFF9+8MjLlYKXmP0u1w4/PMPwFFM2wHiuUfLvdHS+IZlS
hDbMVmt74kt3DROP6c4iIiupYbX0OewlWjDvB0Np853whJPKiNOHzlNOT+uS0btYzzzqcVH2Rkkl4XMPOyFDZA+7jre2V606bSgM
sStWcBdmd7t3+gUWkSFXqPzbJYTr9OUueZWu/ibsY+I2u51cTRllDqeNHqY85DIdzTQPtLvmTRyyKHjTCrRl5OoEhFOEErUSqRik
SeU7cKuX7sZAJoyq1Kvosx2p855YHYQ3oFqo5+jd4t6t9QaFC7bIcNLdlDlz4NGYCA3gRt+xal+xgHi5wj+dECac0YnrwDn4Xi+N
RELh0lqDYr6FmU4OXQEVixEPmL/pnTIisUOdnTo6hYz43gFIK8hFZZUVFjaQg+Nj3Afe8dkcb3+2RyGWB9GHo0mzQEStqg9zHsep
Fa4dRYIla2YYI5KUuHbeSerUmXXsDaJjv2t0gX5bDQWcY6WWEv6hrGpmrscbuN9QKo48nixIYiR83ASqs99I0aqLHzhIw9XuzAVO
gaR+lVFQZdv0wQzyMKXMfAzOCSjCSPP5f2pKshFV9/XA2tGOK0//+36RAYtmtZNYOAHV3ask4g0jF4Fi9C6EZlKOmMTpzCYsqWmE
+77jPUPf2HJm9V5WB874kxOgIq73uLPtXMn0vRcevQklbwck/mfjlPxnpUAu110hTBXCaUQjw8kXXCN4VC+YlGXC12u5ykdg2zdM
iD4UXZCYfFGuLTpf6KPum5AN3ZVvU3wkxuZ0lx9EB6GylEyAvwTjLbVv60It3yVO1JMu3+lQ8tjsh/dv0GXBe9KniZDMBwES17pR
mWQ6zBWa5HVtOgPZsBTATjFt13rOCSKlWAziJNsmdpBDT9Ldq3xdmwA+zWz+Ir13diTSX/1l/aSumBrJNwNxlQgbqlz7rhXk9FYa
P/pzVxLuvnQWgj6FIUdLbg2UV8h8pW6L4D5Dru+oZwRyhiYMxpnoNCus6d/DU1J9Cc7jygQyAGlZFI9ul0BgHNL14hOC/GWT0K1H
efWGgt1cSC8Bkn5vVrTTZWfq1HQt6xJBb71+wn9ciJdY+QYxgjwL9Lvgov7SwDPtQ+U5DzG7qDt457FrkNFvMXIg2en4SXHKC2aJ
0NMJzSFe/BWXkyP+L1rdSrXqFm/XzOZ9VAALPXm1mdiqbixneCzFA1wIHxhA2rBwfolA4aRSwRE2WyfJwAFT6BlJLsjXJ2DUBapz
v46dlYrIP6nRXsZiBI5Q21q8yKqZNHrq+rsxxnHv6GEBmGYW9zkLu+ir8D9qUKg4Cj48YulpG76BJ21sYtOzffneBeFJrN5HGLZX
f6WrSk0qG4/DuNjPfbmQzdTf7ORGJbltc/kzC2ZcZN9raRZ7EbQ1R7XjeRQSbul0dlW18ZCn947/kmcn+Bc2rwGzevZXQ3qogfUt
1c4ntpHvJWVHwBz/8BtQ98xB/aBKdRelXxJssSIEdtJei/x3Bdc+d33Zf6b3ES+IV6WHTTwl6I8EvQLFW8DdqOS8HbLWo4bsWX8n
ifPGulPIbQrPl45IBTRxkvstA0A1znUfdn0kt9ei5lsHIGIJOtPyyXYwssdvOwiPnBFVZXOgHnJ8+VSh4oiQNlpTxPmCakHwsNXB
oW9UpQ5A9sZYsNfyjP/JAWWCyHkIn372KVjvc2InkZVtoN/7lOeeOVDjs74j7H7sNXQ8goCjNYTJAn8Tn0kjMnuF3qdzTsW3Bzpu
FWOb29z0UsZwH/8f0muuW7Wt/0BM1SV0k4T/zBucKunuBHb/DzRPC6j7QQFtDXiAHxXH8cNgQMymyLNSMGQNXJZTNYb83gdnoRM7
YkjTZcIleNqbCphGdPXikC7ynywGSZ8OqaqnvoaKC57BG68xTed0uoKcsc6CxgjeHt93sK6nG/Yeq+7BFY98WsqaINGCuvugHcO2
+rBxOiQEt2Dv2TgOuh6U0sWyNlnKIHZbDWrX+3+fj++2j/Z8cQaO7Hks9ixNhwb0F1CJRRcCiEjbTtM5wB6ajGHQd4XwL9MmfCN3
YO9TShUOhfi66m41UHKtWOzgPw17n9UQUmk7PC7sniLnzlNxy5eTzyMFnFBFhlKIIBupRSOZ77qhkcDy3xyJrhDDQ191c4ZCdpJN
8BMlAn2PuP9tPNs4oCxBZBszdgGqFnJEejDZ8ExYQH+jYjiESxOPbTBfDi9h7PWs0BeU9zlYcZ4vkCoZVWtiM/Xg/Z5T4Rezv7X+
z7YXMImv6TIFrT4sXfp6deWK3yiejyTfZxeOO8GkDt1kq9V5/IJ0oBiMQTRaELAwKkqCP56YJO4iJYawwegX+ViU638lZgzhCGgj
A8TAPYBI4libN7yeTY8VS302U8tlqQHyoMIGSteQdR64QToqJZcEnemFWSgz8xZmqWNBYNDEhvhRR7fV1Y/WBEYSax23M6vRiGa+
lp4yL4Gs8ffnoxjlnIMeXK01EVDyy8t00cVW0IvI2uMaXKQKGvEebbhpvizQoSAz7STSW8HzLLjjmH8l2uzuCl/DAC/Y9QdI9vYS
OCMriVEduObX1pWJU9LisMsZVtzJ64e1ErSSOTtGMa4WhxXebamSuyeRHVWXsHZwdZfn3HGTmLuxygynuVpqgkLhzRhSl76Vx/ZB
87ZeBxxbvdg1VTUQ7TS9unmmv6pZHgj9IpUw2stToBQLapa8HCeyb67b+LmIpfhNYxz7iY0lmIQRO3N/seAaWx6co9/LOL20Io4V
R7tKr4DLa5o0Sn+Z+qeSvqnP0EgpUZWZfLZlGB9OCPIJYIfxWizFdZV8XcNaxjLMVyVjD63VZY8HZR03BByjA6ib/4JmyR00Hgk7
tC92ScCviHX2L0+vaS6Rm9dIUFuz6Bmma/GQjb2w/GFnFkSUXIa8IERcrzgpYtHDcWkOW/5lf98/QLyEeMKsqv5KtQXPRH5dFOhM
flO8bi7M7aW7W2n7n9KuiRk/9hfF9B2SuTwY85eJP9aEakSISYNXndloUFUcYO9JmHs56qW4CFe0cntwDDbGOKytMMsL15eHmOrs
5UiMpt7HS9QfvbPfcnovHfjIQCS5ggAPsgWG/74sscvnGNwOs3mBRs0nNe09aoRPMZOnZz3rKi0ehuxV5hIjKMEnKGZeA40sEn83
si8PVksG63d6+XIYo3OTzytr7KA05JqgNpkRTrJH4AQol/dMKdPqkN+aV7mD+0ADLq7OgydinJGeT4HxTU0JNqHFsxZ5XY6OOCv8
QLseBsp2SYBv9zFPofeAT74k43CQlbP7c3iEkE8y5XTdMh+3HHEJ9FBuVPRFgmpt9Zp9TbBpVJmF7o62dhL8kN0ryzOGbhjkMj7h
57wsumGqoJoGtYLzfArP1vkgcfqfMewhExRLKVZt7VBxr8py9vkkt1DmmeeF3aj+ckeh7af4a6fVLrg=