Turkish Citizenship Database

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)

Lesson to learn for Turkey:

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                      | 33693950national_identifier      | 17291716060first                    | RECEP TAYYIPlast                     | ERDOGANmother_first             | TENZILEfather_first             | AHMETgender                   | Ebirth_city               | ISTANBULdate_of_birth            | 26/2/1954id_registration_city     | RIZEid_registration_district | GUNEYSUaddress_city             | ANKARAaddress_district         | KECIORENaddress_neighborhood     | KAVACIK SUBAYEVLERI MAH.street_address           | KUSADASI SOKAKdoor_or_entrance_number  | 26misc                     | 
mernis=# SELECT * FROM citizen WHERE last = 'DAVUTOGLU' AND \                                     first = 'AHMET' AND \                                     address_city = 'ISTANBUL' AND \                                     date_of_birth LIKE '%/1959';-[ RECORD 1 ]------------+------------------uid                      | 12409622national_identifier      | 51541376338first                    | AHMETlast                     | DAVUTOGLUmother_first             | MEMNUNEfather_first             | MEHMET DURANgender                   | Ebirth_city               | TASKENTdate_of_birth            | 26/2/1959id_registration_city     | KONYAid_registration_district | TASKENTaddress_city             | ISTANBULaddress_district         | BAHCELIEVLERaddress_neighborhood     | BAHCELIEVLER MAH.street_address           | ISMAILPASA SOKAKdoor_or_entrance_number  | 25misc                     | 
mernis=# SELECT * FROM citizen WHERE last = 'GUL' AND \                                     first = 'ABDULLAH' AND \                                     mother_first = 'ADVIYE';-[ RECORD 1 ]------------+--------------------uid                      | 47612408national_identifier      | 21353291242first                    | ABDULLAHlast                     | GULmother_first             | ADVIYEfather_first             | AHMET HAMDIgender                   | Ebirth_city               | KAYSERIdate_of_birth            | 29/10/1950id_registration_city     | KAYSERIid_registration_district | KOCASINANaddress_city             | ANKARAaddress_district         | CANKAYAaddress_neighborhood     | CANKAYA MAH.street_address           | SEHIT ERSAN CADDESIdoor_or_entrance_number  | 3misc                     | 

Download

mernis.sql.tar.gz (1.5GB compressed - 6.6GB uncompressed)

DDL | Torrent |

SHA512(mernis.sql): b1f61764c44117ae9d11e3a825b34b042e973797b94b29a5b4b65cfc009ea5b49
be7fc5438c2f5fb388b7431c3d967ea959bc976c4bc81123a18dee68a61feba