diabetes.sql

FAC analysis Sofeware

CREATE TABLE IDD111 (
  NAME varchar,
  SEX tinyint,
  FHI tinyint,
  FHN tinyint,
  COMA tinyint,
  ICA tinyint,
  TAB tinyint,
  DIS tinyint,
  HEIGHT tinyint,
  CLUS tinyint,
  AGE tinyint,
  SYMP tinyint,
  GLUC tinyint,
  HBAI tinyint,
  INSUL tinyint,
  CPEP tinyint,
  IA tinyint,
  DR tinyint,
  CORT tinyint,
  T4 tinyint,
  TSH tinyint,
  CHOL tinyint,
  TRIG tinyint,
  PH tinyint,
  AGE_O real,
  SYMP_O real,
  GLUC_O real,
  HBAI_O real,
  INSUL_O real,
  CPEP_O real,
  CIA_O real,
  DR_O real,
  CORT_O real,
  T4_O real,
  TSH_O real,
  CHOL_O real,
  TRIG_O real,
  PH_O real
);

INSERT INTO IDD111 VALUES ('Patient 1',1,1,1,1,1,1,1,1,1,1,3,2,1,2,2,1,2,2,2,2,2,1,1,3.8,300.0,754.0,14.7,0.7,0.2,1.0,4.0,15.2,8.7,4.7,218.0,61.0,7.25);
INSERT INTO IDD111 VALUES ('Patient 2',2,2,2,1,1,1,1,3,2,2,2,2,2,2,2,2,3,1,2,1,1,2,2,11.7,10.0,562.0,17.5,1.0,0.44,4.5,34.0,12.6,8.0,2.3,155.0,105.0,7.37);
INSERT INTO IDD111 VALUES ('Patient 3',2,1,1,1,2,1,2,4,1,3,3,1,1,1,2,1,1,1,1,2,2,1,3,16.0,90.0,465.0,14.9,0.5,0.42,0.7,3.0,10.8,7.4,3.4,299.0,68.0,7.45);
INSERT INTO IDD111 VALUES ('Patient 4',2,1,1,1,2,1,1,4,1,3,3,2,2,2,2,2,1,2,2,2,2,2,2,13.2,60.0,598.0,18.1,1.1,0.22,6.5,3.0,25.6,9.3,4.7,270.0,848.0,7.35);
INSERT INTO IDD111 VALUES ('Patient 5',2,2,2,1,2,1,2,2,2,1,2,1,2,2,2,2,2,2,2,2,1,2,3,5.2,8.0,275.0,15.0,0.7,0.21,3.5,4.0,16.0,9.2,3.6,133.0,102.0,7.48);
INSERT INTO IDD111 VALUES ('Patient 6',1,2,2,1,1,1,1,2,2,1,2,1,1,1,1,2,4,1,2,1,1,1,3,5.0,21.0,303.0,13.6,0.1,0.1,1.22,7.0,10.5,9.6,2.0,169.0,59.0,7.4);
INSERT INTO IDD111 VALUES ('Patient 7',2,1,2,1,2,1,2,2,2,2,2,2,1,1,1,1,2,2,2,1,2,2,1,8.2,21.0,816.0,14.3,0.5,0.0,0.51,4.0,21.6,9.7,1.0,195.0,397.0,7.28);
INSERT INTO IDD111 VALUES ('Patient 8',2,1,1,1,2,2,1,4,1,3,2,2,1,2,1,2,2,2,1,1,2,2,1,17.0,21.0,830.0,13.7,0.8,0.11,4.3,4.0,20.8,6.4,2.0,236.0,116.0,7.2);
INSERT INTO IDD111 VALUES ('Patient 9',2,1,2,1,1,2,1,4,2,3,2,2,2,2,1,1,3,1,2,1,1,1,1,16.5,14.0,600.0,17.4,1.0,0.17,0.64,34.0,14.2,9.92,2.4,110.0,100.0,7.2);
INSERT INTO IDD111 VALUES ('Patient 10',1,1,1,1,1,1,2,1,2,1,2,1,2,1,1,2,3,2,1,1,2,2,3,1.1,8.0,297.0,15.0,0.3,0.16,1.5,34.0,18.4,7.0,2.5,186.0,143.0,7.4);
INSERT INTO IDD111 VALUES ('Patient 11',1,1,1,1,2,1,1,4,1,3,2,1,1,1,1,2,2,1,1,1,2,1,3,14.7,10.0,185.0,9.7,0.3,0.1,1.76,4.0,10.8,5.4,1.0,179.0,94.0,7.4);
INSERT INTO IDD111 VALUES ('Patient 12',1,1,1,2,2,1,2,1,2,1,2,1,1,2,2,1,3,2,2,1,2,2,3,1.1,14.0,503.0,10.5,0.9,0.2,0.79,34.0,28.0,7.8,1.9,221.0,263.0,7.4);
INSERT INTO IDD111 VALUES ('Patient 13',2,1,1,1,0,1,1,4,1,3,2,1,2,1,2,1,2,1,2,2,1,1,3,15.5,28.0,290.0,16.7,0.6,0.8,0.93,4.0,14.2,7.8,4.2,148.0,91.0,7.43);
INSERT INTO IDD111 VALUES ('Patient 14',2,1,1,1,2,2,2,2,2,1,2,2,1,1,1,1,2,1,2,2,1,1,3,1.8,21.0,576.0,11.3,0.3,0.09,0.77,4.0,10.6,8.5,11.0,65.0,87.0,7.44);
INSERT INTO IDD111 VALUES ('Patient 15',2,1,1,1,1,1,1,2,1,2,3,2,2,1,1,1,1,1,2,1,1,1,3,7.0,30.0,1107.0,16.4,0.5,0.0,0.73,3.0,12.1,7.8,2.7,158.0,76.0,7.39);
INSERT INTO IDD111 VALUES ('Patient 16',2,2,1,1,1,1,2,1,2,1,2,2,1,2,1,2,1,2,1,1,1,1,2,1.6,14.0,812.0,13.4,1.0,0.0,1.1,3.0,20.8,6.5,2.3,168.0,52.0,7.36);
INSERT INTO IDD111 VALUES ('Patient 17',2,1,2,1,1,2,1,3,1,2,3,1,2,1,1,2,1,2,1,2,1,1,2,12.9,45.0,259.0,15.7,0.6,0.08,1.17,3.0,14.8,5.2,5.2,99.0,80.0,7.3);
INSERT INTO IDD111 VALUES ('Patient 18',1,1,2,2,2,1,1,3,1,2,3,1,2,2,1,1,2,2,1,1,2,2,1,11.0,90.0,329.0,23.3,1.2,0.13,0.76,4.0,19.2,5.7,2.9,233.0,271.0,7.2);
INSERT INTO IDD111 VALUES ('Patient 19',2,1,2,1,1,1,1,3,1,2,3,1,1,2,2,1,2,2,1,2,2,1,3,13.0,42.0,314.0,14.9,0.9,0.38,0.76,4.0,18.8,7.0,3.6,190.0,74.0,7.39);
INSERT INTO IDD111 VALUES ('Patient 20',2,2,2,1,1,1,1,3,1,2,2,1,2,2,2,2,1,1,2,2,2,1,1,10.8,21.0,418.0,21.6,1.0,0.46,1.87,3.0,9.3,9.2,4.9,213.0,94.0,7.2);
INSERT INTO IDD111 VALUES ('Patient 21',2,1,1,2,0,1,1,4,2,1,2,1,2,2,1,2,2,1,1,2,1,1,1,5.0,15.0,510.0,15.2,0.7,0.0,3.0,4.0,13.8,7.2,3.3,157.0,38.0,7.2);
INSERT INTO IDD111 VALUES ('Patient 22',2,1,1,1,1,1,2,2,2,2,3,2,1,1,1,1,1,1,1,2,2,2,2,8.0,30.0,854.0,14.5,0.5,0.12,0.51,3.0,10.4,7.1,4.6,205.0,261.0,7.3);
INSERT INTO IDD111 VALUES ('Patient 23',1,1,2,1,2,1,1,2,1,1,3,2,2,1,1,1,2,2,2,1,2,2,3,5.0,30.0,756.0,21.5,0.2,0.11,0.63,4.0,24.0,9.2,3.2,254.0,248.0,7.4);
INSERT INTO IDD111 VALUES ('Patient 24',1,1,2,1,2,1,2,3,2,2,3,2,2,2,1,1,1,2,1,2,2,1,2,12.6,365.0,1100.0,27.0,1.1,0.0,0.81,3.0,18.2,7.5,4.4,260.0,97.0,7.38);
INSERT INTO IDD111 VALUES ('Patient 25',1,2,1,1,1,1,1,4,1,3,3,1,1,1,2,2,3,1,2,1,1,1,3,13.9,0.0,283.0,12.0,0.5,0.52,3.6,34.0,13.5,12.0,2.0,158.0,69.0,7.4);
INSERT INTO IDD111 VALUES ('Patient 26',1,1,1,2,2,2,1,3,1,3,2,1,1,2,2,1,3,2,2,2,2,2,1,14.0,21.0,502.0,13.0,1.0,0.2,0.49,34.0,15.0,8.4,7.3,348.0,182.0,7.17);
INSERT INTO IDD111 VALUES ('Patient 27',2,1,1,2,1,1,2,1,2,1,2,1,1,2,1,1,3,2,1,2,1,1,2,1.3,14.0,510.0,12.8,1.0,0.1,0.75,34.0,16.4,5.1,3.4,156.0,52.0,7.3);
INSERT INTO IDD111 VALUES ('Patient 28',1,1,1,1,2,2,1,3,1,2,3,1,2,1,1,1,1,2,1,2,1,2,3,10.8,30.0,474.0,15.5,0.5,0.06,0.76,3.0,17.4,6.3,4.9,123.0,109.0,7.39);
INSERT INTO IDD111 VALUES ('Patient 29',2,2,1,1,2,1,1,4,1,3,2,1,1,2,2,2,3,1,2,1,1,2,2,15.9,10.0,346.0,14.3,1.1,0.18,1.2,34.0,12.0,8.5,2.9,131.0,346.0,7.34);
INSERT INTO IDD111 VALUES ('Patient 30',2,1,1,1,2,1,1,2,1,2,3,2,2,1,2,2,3,1,2,2,2,2,3,7.0,0.0,736.0,18.8,0.6,0.3,1.2,34.0,9.0,8.5,3.5,178.0,426.0,7.4);
INSERT INTO IDD111 VALUES ('Patient 31',1,1,1,1,2,2,1,2,2,1,2,2,1,1,1,1,3,1,2,1,1,1,2,5.5,10.0,572.0,11.3,0.5,0.0,0.76,34.0,8.4,9.2,3.2,108.0,44.0,7.35);
INSERT INTO IDD111 VALUES ('Patient 32',2,1,1,1,2,1,2,2,2,1,2,2,1,2,1,1,2,2,2,1,1,1,2,5.7,14.0,762.0,12.6,0.7,0.06,0.78,4.0,15.0,9.1,1.8,142.0,99.0,7.32);
INSERT INTO IDD111 VALUES ('Patient 33',2,1,1,1,2,1,2,3,2,2,2,2,1,1,1,2,1,1,2,1,1,1,2,9.9,21.0,615.0,14.5,0.5,0.07,1.5,3.0,10.0,9.4,3.0,168.0,77.0,7.3);
INSERT INTO IDD111 VALUES ('Patient 34',1,2,2,1,2,2,1,3,2,2,2,2,2,2,1,1,2,1,1,1,2,1,2,10.0,21.0,579.0,15.2,1.0,0.12,0.75,4.0,11.5,5.6,3.0,187.0,55.0,7.3);
INSERT INTO IDD111 VALUES ('Patient 35',1,2,1,1,2,1,1,3,1,2,3,1,1,1,2,2,1,2,2,1,1,1,3,9.6,70.0,291.0,14.8,0.5,0.24,1.13,3.0,23.6,8.5,2.6,158.0,95.0,7.45);
INSERT INTO IDD111 VALUES ('Patient 36',1,1,1,1,2,1,1,3,1,2,2,1,1,1,2,1,3,1,2,2,1,1,2,8.2,21.0,265.0,13.6,0.1,0.37,0.87,34.0,11.4,7.9,3.3,131.0,63.0,7.3);