NOSQL Утечка данных о гражданах Ирака

[N9XDZ]

Формат базы данных: .accdb
Строк: Контейнер - AGENT: 14550 / Контейнер - FAMILY: 970276 / Контейнер - M: 160688 / Контейнер - PERSON: 6168205 / Контейнер - RC: 128

Спойлер: Поля AGENT

CREATE TABLE `AGENT` (
    `AG_TYPE` VARCHAR(1),
    `AG_NO` VARCHAR(6),
    `RC_NO` VARCHAR(3),
    `AG_NAME` VARCHAR(30),
    `S_DIST` VARCHAR(15),
    `S_AREA` DOUBLE,
    `S_STREET` DOUBLE,
    `S_HOUSE` VARCHAR(5),
    `S_TEL` DOUBLE,
    `H_DIST` VARCHAR(15),
    `H_AREA` DOUBLE,
    `H_STREET` DOUBLE,
    `H_HOUSE` VARCHAR(5),
    `H_TEL` DOUBLE,
    `AGN_FAM1` DOUBLE,
    `AGN_PER1` DOUBLE,
    `AGN_INF1` DOUBLE,
    `AGN_EPER1` DOUBLE,
    `AGN_EINF1` DOUBLE,
    `AGN_FAM2` DOUBLE,
    `AGN_PER2` DOUBLE,
    `AGN_INF2` DOUBLE,
    `AGN_EPER2` DOUBLE,
    `AGN_EINF2` DOUBLE,
    `AGN_FAM3` DOUBLE,
    `AGN_PER3` DOUBLE,
    `AGN_INF3` DOUBLE,
    `AGN_EPER3` DOUBLE,
    `AGN_EINF3` DOUBLE,
    `AGN_FAM4` DOUBLE,
    `AGN_PER4` DOUBLE,
    `AGN_INF4` DOUBLE,
    `AGN_EPER4` DOUBLE,
    `AGN_EINF4` DOUBLE,
    `AGN_FAM5` DOUBLE,
    `AGN_PER5` DOUBLE,
    `AGN_INF5` DOUBLE,
    `AGN_EPER5` DOUBLE,
    `AGN_EINF5` DOUBLE,
    `AGN_FAM6` DOUBLE,
    `AGN_PER6` DOUBLE,
    `AGN_INF6` DOUBLE,
    `AGN_EPER6` DOUBLE,
    `AGN_EINF6` DOUBLE,
    `AGN_FAM7` DOUBLE,
    `AGN_PER7` DOUBLE,
    `AGN_INF7` DOUBLE,
    `AGN_EPER7` DOUBLE,
    `AGN_EINF7` DOUBLE,
    `AGN_FAM8` DOUBLE,
    `AGN_PER8` DOUBLE,
    `AGN_INF8` DOUBLE,
    `AGN_EPER8` DOUBLE,
    `AGN_EINF8` DOUBLE,
    `AGN_FAM9` DOUBLE,
    `AGN_PER9` DOUBLE,
    `AGN_INF9` DOUBLE,
    `AGN_EPER9` DOUBLE,
    `AGN_EINF9` DOUBLE,
    `AGN_FAM10` DOUBLE,
    `AGN_PER10` DOUBLE,
    `AGN_INF10` DOUBLE,
    `AGN_EPER10` DOUBLE,
    `AGN_EINF10` DOUBLE,
    `AGN_FAM11` DOUBLE,
    `AGN_PER11` DOUBLE,
    `AGN_INF11` DOUBLE,
    `AGN_EPER11` DOUBLE,
    `AGN_EINF11` DOUBLE,
    `AGN_FAM12` DOUBLE,
    `AGN_PER12` DOUBLE,
    `AGN_INF12` DOUBLE,
    `AGN_EPER12` DOUBLE,
    `AGN_EINF12` DOUBLE,
    `AGN_FAM13` DOUBLE,
    `AGN_PER13` DOUBLE,
    `AGN_INF13` DOUBLE
) CHARACTER SET 'UTF8';

Спойлер: семпл AGENT

('1','019008','082','ساهره احمد حسين',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,90,596,12,NULL,NULL,89,592,10,NULL,NULL,88,589,13,NULL,NULL,88,589,14,NULL,NULL,90,591,14,NULL,NULL,90,593,14,NULL,NULL,90,596,13,NULL,NULL,90,597,12,NULL,NULL,90,597,13,NULL,NULL,90,597,13,0,0,90,597,12,NULL,NULL,90,599,11,NULL,NULL,89,593,10),
      ('1','019014','082','مكي يحيى محمد','م643ز94',0,0,NULL,0,NULL,0,0,NULL,0,149,812,8,NULL,NULL,148,807,9,NULL,NULL,147,805,9,NULL,NULL,146,801,12,NULL,NULL,147,797,12,NULL,NULL,147,796,11,NULL,NULL,148,799,9,NULL,NULL,148,802,8,NULL,NULL,149,807,9,NULL,NULL,150,815,8,0,0,150,814,9,NULL,NULL,150,815,9,NULL,NULL,148,809,11),
      ('1','020349','082','امنة طه حمودي','م 233 ز 5',0,0,NULL,0,NULL,0,0,NULL,0,130,689,5,NULL,NULL,128,690,8,NULL,NULL,128,691,9,NULL,NULL,129,692,10,NULL,NULL,127,682,9,NULL,NULL,127,682,8,NULL,NULL,127,682,8,NULL,NULL,127,682,9,NULL,NULL,127,682,9,NULL,NULL,128,687,7,0,0,130,688,5,NULL,NULL,130,689,4,NULL,NULL,128,690,7),

Спойлер: Поля FAMILY

CREATE TABLE `FAMILY` (
    `RC_NO` VARCHAR(3),
    `FAM_NO` VARCHAR(6),
    `F_DIST` VARCHAR(15),
    `F_AREA` DOUBLE,
    `F_STREET` DOUBLE,
    `F_HOUSE` VARCHAR(5),
    `FH_FIRST` VARCHAR(10),
    `FH_FATHER` VARCHAR(10),
    `FH_GRAND` VARCHAR(10),
    `F_NO_PER` DOUBLE,
    `F_NO_INF` DOUBLE,
    `FD_AG_NO` VARCHAR(6),
    `FL_AG_NO` VARCHAR(6),
    `ISSUE_DT` VARCHAR(4),
    `TIK_IND` DOUBLE,
    `F_CASE` VARCHAR(1),
    `F_JOB` VARCHAR(1),
    `PRV_RCNO` VARCHAR(3),
    `CUR_RC_TIK` VARCHAR(6),
    `PRV_FDAGNO` VARCHAR(6)
) CHARACTER SET 'UTF8';

Спойлер: семпл FAMILY

('082','175791',NULL,0,0,NULL,'قندية','متنجر','فشاج',3,0,'022215','007383','`;1',1,'0','0','  0','175791',NULL),
      ('082','175792',NULL,0,0,NULL,'عزيز','حسن','صالح',9,0,'022234','007388','`71',1,'0','0','  0','175792',NULL),
      ('082','177288',NULL,0,0,NULL,'فؤاد','عبدالحميد','محمدعلي',7,0,'019014','007619','`71',1,'0','0','  0','177288',NULL),
      ('082','191321',NULL,0,0,NULL,'جمال','عزيز','صالح',7,0,'022214','007390','`71',1,'0','0','  0','191321',NULL),
      ('082','192351',NULL,315,85,'   30','سعد','هويدي','صالح',8,0,'020530','007371','^91',1,'0','

Спойлер: Поля PERSON

CREATE TABLE `PERSON` (
    `RC_NO` VARCHAR(3),
    `FAM_NO` VARCHAR(6),
    `SEQ_NO` VARCHAR(2),
    `P_FIRST` VARCHAR(10),
    `P_FATHER` VARCHAR(10),
    `P_GRAND` VARCHAR(10),
    `P_RELATION` DOUBLE,
    `P_BIRTH` DOUBLE,
    `SS_BR_NO` DOUBLE,
    `SS_LG_NO` VARCHAR(5),
    `SS_PG_NO` DOUBLE,
    `SS_ID_NO` DOUBLE,
    `P_CASE` VARCHAR(1),
    `P_JOB` VARCHAR(1),
    `P_ISUDT` VARCHAR(4),
    `name1` VARCHAR(50)
) CHARACTER SET 'UTF8';

Спойлер: Семпл PERSON

('082','200946','02','انعام','السيد','احمد',2,196800,999,'00011',69,2756,'0','0','^91','انعام السيد احمد'),
      ('082','200946','03','نورا','ابراهيم','محمد',3,198900,999,'00011',69,2756,'0','0','^91','نورا ابراهيم محمد'),
      ('082','200946','04','شيماء','ابراهيم','محمد',3,199200,999,'00011',69,1245,'0','0','^91','شيماء ابراهيم محمد'),
      ('082','200951','01','ناجح','علي','عبدالفتاح',1,193200,999,'00013',21,583,'0','0','^91','ناجح علي عبدالفتاح'),
      ('082','200951','02','رابحة','احمد','عبدالرحمن',2,194600,999,'00013',21,583,'0','0','^91','رابحة احمد عبدالرحمن'),

Скачать:

https://mir.cr/AIEQBGER