1. Turkish Citizenship Database
2.  
3. Who would have imagined that backwards ideologies, cronyism and rising religious extremism in Turkey would lead to a crumbling and vulnerable technical infrastructure?
4.  
5. This leak contains the following information for 49,611,709 Turkish citizens: (IN CLEARTEXT)
6.  
7. National Identifier (TC Kimlik No)
8. First Name
9. Last Name
10. Mother's First Name
11. Father's First Name
12. Gender
13. City of Birth
14. Date of Birth
15. ID Registration City and District
16. Full Address
17. Lesson to learn for Turkey:
18.  
19. Bit shifting isn't encryption.
20. Index your database. We had to fix your sloppy DB work.
21. Putting a hardcoded password on the UI hardly does anything for security.
22. Do something about Erdogan! He is destroying your country beyond recognition.
23. 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.
24.  
25. Let's take a look at the data:
26.  
27. mernis=# SELECT * FROM citizen WHERE last = 'ERDOGAN' AND \
28.                                      first = 'RECEP TAYYIP' AND \
29.                                      date_of_birth LIKE '%/%/1954';
30. -[ RECORD 1 ]------------+-------------------------
31. uid                      | 33693950
32. national_identifier      | 17291716060
33. first                    | RECEP TAYYIP
34. last                     | ERDOGAN
35. mother_first             | TENZILE
36. father_first             | AHMET
37. gender                   | E
38. birth_city               | ISTANBUL
39. date_of_birth            | 26/2/1954
40. id_registration_city     | RIZE
41. id_registration_district | GUNEYSU
42. address_city             | ANKARA
43. address_district         | KECIOREN
44. address_neighborhood     | KAVACIK SUBAYEVLERI MAH.
45. street_address           | KUSADASI SOKAK
46. door_or_entrance_number  | 26
47. misc                     |
48. mernis=# SELECT * FROM citizen WHERE last = 'DAVUTOGLU' AND \
49.                                      first = 'AHMET' AND \
50.                                      address_city = 'ISTANBUL' AND \
51.                                      date_of_birth LIKE '%/1959';
52. -[ RECORD 1 ]------------+------------------
53. uid                      | 12409622
54. national_identifier      | 51541376338
55. first                    | AHMET
56. last                     | DAVUTOGLU
57. mother_first             | MEMNUNE
58. father_first             | MEHMET DURAN
59. gender                   | E
60. birth_city               | TASKENT
61. date_of_birth            | 26/2/1959
62. id_registration_city     | KONYA
63. id_registration_district | TASKENT
64. address_city             | ISTANBUL
65. address_district         | BAHCELIEVLER
66. address_neighborhood     | BAHCELIEVLER MAH.
67. street_address           | ISMAILPASA SOKAK
68. door_or_entrance_number  | 25
69. misc                     |
70. mernis=# SELECT * FROM citizen WHERE last = 'GUL' AND \
71.                                      first = 'ABDULLAH' AND \
72.                                      mother_first = 'ADVIYE';
73. -[ RECORD 1 ]------------+--------------------
74. uid                      | 47612408
75. national_identifier      | 21353291242
76. first                    | ABDULLAH
77. last                     | GUL
78. mother_first             | ADVIYE
79. father_first             | AHMET HAMDI
80. gender                   | E
81. birth_city               | KAYSERI
82. date_of_birth            | 29/10/1950
83. id_registration_city     | KAYSERI
84. id_registration_district | KOCASINAN
85. address_city             | ANKARA
86. address_district         | CANKAYA
87. address_neighborhood     | CANKAYA MAH.
88. street_address           | SEHIT ERSAN CADDESI
89. door_or_entrance_number  | 3
90. misc                     |
91. Download
92.  
93. mernis.sql.tar.gz (1.5GB compressed - 6.6GB uncompressed)
94.  
95. Torrent | Magnet URL
96. 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
97.  
98. SHA512(mernis.sql): b1f61764c44117ae9d11e3a825b34b042e973797b94b29a5b4b65cfc009ea5b49
99. be7fc5438c2f5fb388b7431c3d967ea959bc976c4bc81123a18dee68a61feba