('2021-MAY-23','Guinea',3,86),('2021-MAY-23','Guinea Bissau',1,16),('2021-MAY-23','Guyana',17,721),('2021-MAY-23','Haiti',22,602),('2021-MAY-23','Holy See',0,0),('2021-MAY-23','Honduras',152,5902),('2021-MAY-23','Hungary',59,956),('2021-MAY-23','Iceland',0,9),('2021-MAY-23','India',25119,600435),('2021-MAY-23','Indonesia',1267,55320),('2021-MAY-23','Iran',848,54159),('2021-MAY-23','Iraq',167,29651),('2021-MAY-23','Ireland',0,2301),('2021-MAY-23','Isle Of Man',0,2),('2021-MAY-23','Israel',9,97),('2021-MAY-23','Italy',479,12444),('2021-MAY-23','Jamaica',40,373),('2021-MAY-23','Japan',510,13499),('2021-MAY-23','Jersey',0,34),('2021-MAY-23','Jordan',62,3484),('2021-MAY-23','Kazakhstan',265,9874),('2021-MAY-23','Kenya',123,2846),('2021-MAY-23','Kosovo',5,71),('2021-MAY-23','Kuwait',25,10766),('2021-MAY-23','Kyrgyzstan',47,3494),('2021-MAY-23','Laos',0,42),('2021-MAY-23','Latvia',43,1218),('2021-MAY-23','Lebanon',27,818),('2021-MAY-23','Lesotho',0,82),('2021-MAY-23','Liberia',5,245),('2021-MAY-23','Libya',19,1599),('2021-MAY-23','Liechtenstein',1,4),('2021-MAY-23','Lithuania',31,1183),('2021-MAY-23','Luxembourg',0,224),('2021-MAY-23','Madagascar',23,263),('2021-MAY-23','Malawi',2,95),('2021-MAY-23','Malaysia',530,40693),('2021-MAY-23','Maldives',12,2351),('2021-MAY-23','Mali',4,52),('2021-MAY-23','Malta',0,11),('2021-MAY-23','Marshall Islands',0,0),('2021-MAY-23','Mauritania',7,256),('2021-MAY-23','Mauritius',0,222),('2021-MAY-23','Mexico',1347,20789),('2021-MAY-23','Micronesia (Federated States Of)',0,0),('2021-MAY-23','Moldova',20,344),('2021-MAY-23','Monaco',0,17),('2021-MAY-23','Mongolia',62,11904),('2021-MAY-23','Montenegro',9,144),('2021-MAY-23','Montserrat',0,0),('2021-MAY-23','Morocco',33,2464),('2021-MAY-23','Mozambique',4,424),('2021-MAY-23','Myanmar',19,1286),('2021-MAY-23','Namibia',83,6382),('2021-MAY-23','Nepal',514,20348),('2021-MAY-23','Netherlands',33,9165),('2021-MAY-23','New Caledonia',0,0),('2021-MAY-23','New Zealand',0,383),('2021-MAY-23','Nicaragua',1,181),('2021-MAY-23','Niger',0,7),('2021-MAY-23','Nigeria',0,329),('2021-MAY-23','North Macedonia',13,118),('2021-MAY-23','Northern Mariana Islands',0,0),('2021-MAY-23','Norway',5,1262),('2021-MAY-23','Oman',89,9539),('2021-MAY-23','Pakistan',400,8559),('2021-MAY-23','Palestine',16,1507),('2021-MAY-23','Panama',42,5367),('2021-MAY-23','Papua New Guinea',1,355),('2021-MAY-23','Paraguay',949,17486),('2021-MAY-23','Peru',2164,19253),('2021-MAY-23','Philippines',890,46161),('2021-MAY-23','Poland',414,2280),('2021-MAY-23','Portugal',11,5038),('2021-MAY-23','Puerto Rico',11,355),('2021-MAY-23','Qatar',8,932),('2021-MAY-23','Romania',983,824),('2021-MAY-23','Russia',3014,95971),('2021-MAY-23','Rwanda',10,1128),('2021-MAY-23','Saint Kitts And Nevis',0,109),('2021-MAY-23','Saint Lucia',0,46),('2021-MAY-23','Saint Vincent And The Grenadines',0,71),('2021-MAY-23','San Marino',0,0),('2021-MAY-23','Sao Tome And Principe',0,5),('2021-MAY-23','Saudi Arabia',116,8251),('2021-MAY-23','Senegal',8,318),('2021-MAY-23','Serbia',45,1213),('2021-MAY-23','Seychelles',1,1176),('2021-MAY-23','Sierra Leone',3,187),('2021-MAY-23','Singapore',1,80),('2021-MAY-23','Sint Maarten',2,38),('2021-MAY-23','Slovakia',27,1228),('2021-MAY-23','Slovenia',14,1035),('2021-MAY-23','Solomon Islands',0,0),('2021-MAY-23','Somalia',4,116),('2021-MAY-23','South Africa',791,50518),('2021-MAY-23','South Korea',14,3636),('2021-MAY-23','South Sudan',0,0),('2021-MAY-23','Spain',281,34244),('2021-MAY-23','Sri Lanka',394,18305),('2021-MAY-23','Sudan',22,199),('2021-MAY-23','Suriname',57,1813),('2021-MAY-23','Sweden',17,4403),('2021-MAY-23','Switzerland',22,2361),('2021-MAY-23','Syria',17,155),('2021-MAY-23','Taiwan',166,1615),('2021-MAY-23','Tajikistan',0,0),('2021-MAY-23','Thailand',197,19378),('2021-MAY-23','Timor Leste',2,601),('2021-MAY-23','Togo',1,88),('2021-MAY-23','Trinidad And Tobago',93,2313),('2021-MAY-23','Tunisia',540,13474),('2021-MAY-23','Turkey',557,42467),('2021-MAY-23','Turks And Caicos Islands',0,2),('2021-MAY-23','Uganda',40,7315),('2021-MAY-23','Ukraine',477,8926),('2021-MAY-23','United Arab Emirates',27,14915),('2021-MAY-23','United Kingdom',64,56527),('2021-MAY-23','United Republic Of Tanzania',0,0),('2021-MAY-23','United States Of America',2141,99397),('2021-MAY-23','United States Virgin Islands',0,111),('2021-MAY-23','Uruguay',355,21978),('2021-MAY-23','Uzbekistan',12,1849),('2021-MAY-23','Vanuatu',0,0),('2021-MAY-23','Venezuela',121,10972),('2021-MAY-23','Vietnam',6,3495),('2021-MAY-23','Wallis And Futuna',0,0),('2021-MAY-23','Western Sahara',0,0),('2021-MAY-23','Yemen',20,75),('2021-MAY-23','Zambia',81,11468),('2021-MAY-23','Zimbabwe',26,770);
/*!40000 ALTER TABLE `FT` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `GROUPBYOPERATOR`
--

DROP TABLE IF EXISTS `GROUPBYOPERATOR`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `GROUPBYOPERATOR` (
                                   `groupbyoperator_id` varchar(255) NOT NULL,
                                   `groupbyoperator_name` varchar(255) NOT NULL,
                                   `groupbyoperator_synonyms` varchar(1000) DEFAULT NULL,
                                   PRIMARY KEY (`groupbyoperator_id`),
                                   UNIQUE KEY `groupbyoperator_name` (`groupbyoperator_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `GROUPBYOPERATOR`
--

LOCK TABLES `GROUPBYOPERATOR` WRITE;
/*!40000 ALTER TABLE `GROUPBYOPERATOR` DISABLE KEYS */;
/*!40000 ALTER TABLE `GROUPBYOPERATOR` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `GROUPBYOPERATOR_OF_MEASURE`
--

DROP TABLE IF EXISTS `GROUPBYOPERATOR_OF_MEASURE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `GROUPBYOPERATOR_OF_MEASURE` (
                                              `groupbyoperator_id` varchar(255) NOT NULL,
                                              `measure_id` varchar(255) NOT NULL,
                                              PRIMARY KEY (`groupbyoperator_id`,`measure_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `GROUPBYOPERATOR_OF_MEASURE`
--

LOCK TABLES `GROUPBYOPERATOR_OF_MEASURE` WRITE;
/*!40000 ALTER TABLE `GROUPBYOPERATOR_OF_MEASURE` DISABLE KEYS */;
/*!40000 ALTER TABLE `GROUPBYOPERATOR_OF_MEASURE` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `HIERARCHY`
--

DROP TABLE IF EXISTS `HIERARCHY`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `HIERARCHY` (
                             `hierarchy_id` varchar(255) NOT NULL,
                             `hierarchy_name` varchar(255) NOT NULL,
                             `hierarchy_synonyms` varchar(1000) DEFAULT NULL,
                             PRIMARY KEY (`hierarchy_id`),
                             UNIQUE KEY `hierarchy_name` (`hierarchy_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `HIERARCHY`
--

LOCK TABLES `HIERARCHY` WRITE;
/*!40000 ALTER TABLE `HIERARCHY` DISABLE KEYS */;
INSERT INTO `HIERARCHY` VALUES ('DT_SPACE','DT_SPACE',NULL),('DT_TIME','DT_TIME',NULL);
/*!40000 ALTER TABLE `HIERARCHY` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `HIERARCHY_IN_FACT`
--

DROP TABLE IF EXISTS `HIERARCHY_IN_FACT`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `HIERARCHY_IN_FACT` (
                                     `fact_id` varchar(255) NOT NULL,
                                     `hierarchy_id` varchar(255) NOT NULL,
                                     PRIMARY KEY (`fact_id`,`hierarchy_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `HIERARCHY_IN_FACT`
--

LOCK TABLES `HIERARCHY_IN_FACT` WRITE;
/*!40000 ALTER TABLE `HIERARCHY_IN_FACT` DISABLE KEYS */;
INSERT INTO `HIERARCHY_IN_FACT` VALUES ('FT','DT_SPACE'),('FT','DT_TIME');
/*!40000 ALTER TABLE `HIERARCHY_IN_FACT` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `LANGUAGE_OPERATOR`
--

DROP TABLE IF EXISTS `LANGUAGE_OPERATOR`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `LANGUAGE_OPERATOR` (
                                     `language_operator_id` varchar(255) NOT NULL,
                                     `language_operator_name` varchar(255) NOT NULL,
                                     `language_operator_synonyms` varchar(1000) DEFAULT NULL,
                                     `language_operator_type` varchar(255) DEFAULT NULL,
                                     PRIMARY KEY (`language_operator_id`),
                                     UNIQUE KEY `language_operator_name` (`language_operator_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `LANGUAGE_OPERATOR`
--

LOCK TABLES `LANGUAGE_OPERATOR` WRITE;
/*!40000 ALTER TABLE `LANGUAGE_OPERATOR` DISABLE KEYS */;
/*!40000 ALTER TABLE `LANGUAGE_OPERATOR` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `LANGUAGE_PREDICATE`
--

DROP TABLE IF EXISTS `LANGUAGE_PREDICATE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `LANGUAGE_PREDICATE` (
                                      `language_predicate_id` varchar(255) NOT NULL,
                                      `language_predicate_name` varchar(255) NOT NULL,
                                      `language_predicate_synonyms` varchar(1000) DEFAULT NULL,
                                      `language_predicate_type` varchar(255) DEFAULT NULL,
                                      PRIMARY KEY (`language_predicate_id`),
                                      UNIQUE KEY `language_predicate_name` (`language_predicate_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `LANGUAGE_PREDICATE`
--

LOCK TABLES `LANGUAGE_PREDICATE` WRITE;
/*!40000 ALTER TABLE `LANGUAGE_PREDICATE` DISABLE KEYS */;
/*!40000 ALTER TABLE `LANGUAGE_PREDICATE` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `LEVEL`
--

DROP TABLE IF EXISTS `LEVEL`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `LEVEL` (
                         `level_id` varchar(255) NOT NULL,
                         `level_type` varchar(255) NOT NULL,
                         `level_description` varchar(200) DEFAULT NULL,
                         `level_name` varchar(255) NOT NULL,
                         `cardinality` int(11) DEFAULT NULL,
                         `hierarchy_id` varchar(255) NOT NULL,
                         `level_synonyms` varchar(1000) DEFAULT NULL,
                         `column_id` varchar(255) NOT NULL,
                         `MIN` double DEFAULT NULL,
                         `MAX` double DEFAULT NULL,
                         `AVG` double DEFAULT NULL,
                         `isDescriptive` int(11) DEFAULT '0',
                         `mindate` date DEFAULT NULL,
                         `maxdate` date DEFAULT NULL,
                         PRIMARY KEY (`level_id`),
                         UNIQUE KEY `level_name` (`level_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `LEVEL`
--

LOCK TABLES `LEVEL` WRITE;
/*!40000 ALTER TABLE `LEVEL` DISABLE KEYS */;
INSERT INTO `LEVEL` VALUES ('DT_SPACE_all_DT_SPACE','NULL',NULL,'all_DT_SPACE',NULL,'DT_SPACE',NULL,'DT_SPACE_all_DT_SPACE',NULL,NULL,NULL,0,NULL,NULL),('DT_SPACE_CONTINENT','VARCHAR',NULL,'CONTINENT',5,'DT_SPACE',NULL,'DT_SPACE_CONTINENT',NULL,NULL,NULL,0,NULL,NULL),('DT_SPACE_COUNTRY','VARCHAR',NULL,'COUNTRY',214,'DT_SPACE',NULL,'DT_SPACE_COUNTRY',NULL,NULL,NULL,0,NULL,NULL),('DT_SPACE_POPULATION','VARCHAR',NULL,'POPULATION',214,'DT_SPACE',NULL,'DT_SPACE_POPULATION',NULL,NULL,NULL,0,NULL,NULL),('DT_TIME_all_DT_TIME','NULL',NULL,'all_DT_TIME',NULL,'DT_TIME',NULL,'DT_TIME_all_DT_TIME',NULL,NULL,NULL,0,NULL,NULL),('DT_TIME_MONTH','VARCHAR',NULL,'MONTH',18,'DT_TIME',NULL,'DT_TIME_MONTH',NULL,NULL,NULL,0,NULL,NULL),('DT_TIME_WEEK','VARCHAR',NULL,'WEEK',77,'DT_TIME',NULL,'DT_TIME_WEEK',NULL,NULL,NULL,0,NULL,NULL),('DT_TIME_YEAR','VARCHAR',NULL,'YEAR',2,'DT_TIME',NULL,'DT_TIME_YEAR',NULL,NULL,NULL,0,NULL,NULL);
/*!40000 ALTER TABLE `LEVEL` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `MEASURE`
--

DROP TABLE IF EXISTS `MEASURE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `MEASURE` (
                           `measure_id` varchar(255) NOT NULL,
                           `measure_name` varchar(255) NOT NULL,
                           `fact_id` varchar(255) NOT NULL,
                           `measure_synonyms` varchar(1000) DEFAULT NULL,
                           `column_id` varchar(255) NOT NULL,
                           PRIMARY KEY (`measure_id`),
                           UNIQUE KEY `measure_name` (`measure_name`,`fact_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `MEASURE`
--

LOCK TABLES `MEASURE` WRITE;
/*!40000 ALTER TABLE `MEASURE` DISABLE KEYS */;
INSERT INTO `MEASURE` VALUES ('CASES','CASES','FT',NULL,'FT_CASES'),('DEATHS','DEATHS','FT',NULL,'FT_DEATHS');
/*!40000 ALTER TABLE `MEASURE` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `MEMBER`
--

DROP TABLE IF EXISTS `MEMBER`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `MEMBER` (
                          `member_id` varchar(255) NOT NULL,
                          `member_name` varchar(255) NOT NULL,
                          `level_id` varchar(255) NOT NULL,
                          `member_synonyms` varchar(1000) DEFAULT NULL,
                          PRIMARY KEY (`member_id`),
                          UNIQUE KEY `member_name` (`member_name`,`level_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `MEMBER`
--

LOCK TABLES `MEMBER` WRITE;
/*!40000 ALTER TABLE `MEMBER` DISABLE KEYS */;
INSERT INTO `MEMBER` VALUES ('0','Afghanistan','DT_SPACE_COUNTRY',NULL),('1','Albania','DT_SPACE_COUNTRY',NULL),('10','Australia','DT_SPACE_COUNTRY',NULL),('100','Japan','DT_SPACE_COUNTRY',NULL),('101','Jersey','DT_SPACE_COUNTRY',NULL),('102','Jordan','DT_SPACE_COUNTRY',NULL),('103','Kazakhstan','DT_SPACE_COUNTRY',NULL),('104','Kenya','DT_SPACE_COUNTRY',NULL),('105','Kosovo','DT_SPACE_COUNTRY',NULL),('106','Kuwait','DT_SPACE_COUNTRY',NULL),('107','Kyrgyzstan','DT_SPACE_COUNTRY',NULL),('108','Laos','DT_SPACE_COUNTRY',NULL),('109','Latvia','DT_SPACE_COUNTRY',NULL),('11','Austria','DT_SPACE_COUNTRY',NULL),('110','Lebanon','DT_SPACE_COUNTRY',NULL),('111','Lesotho','DT_SPACE_COUNTRY',NULL),('112','Liberia','DT_SPACE_COUNTRY',NULL),('113','Libya','DT_SPACE_COUNTRY',NULL),('114','Liechtenstein','DT_SPACE_COUNTRY',NULL),('115','Lithuania','DT_SPACE_COUNTRY',NULL),('116','Luxembourg','DT_SPACE_COUNTRY',NULL),('117','Madagascar','DT_SPACE_COUNTRY',NULL),('118','Malawi','DT_SPACE_COUNTRY',NULL),('119','Malaysia','DT_SPACE_COUNTRY',NULL),('12','Azerbaijan','DT_SPACE_COUNTRY',NULL),('120','Maldives','DT_SPACE_COUNTRY',NULL),('121','Mali','DT_SPACE_COUNTRY',NULL),('122','Malta','DT_SPACE_COUNTRY',NULL),('123','Marshall Islands','DT_SPACE_COUNTRY',NULL),('124','Mauritania','DT_SPACE_COUNTRY',NULL),('125','Mauritius','DT_SPACE_COUNTRY',NULL),('126','Mexico','DT_SPACE_COUNTRY',NULL),('127','Micronesia (Federated States Of)','DT_SPACE_COUNTRY',NULL),('128','Moldova','DT_SPACE_COUNTRY',NULL),('129','Monaco','DT_SPACE_COUNTRY',NULL),('13','Bahamas','DT_SPACE_COUNTRY',NULL),('130','Mongolia','DT_SPACE_COUNTRY',NULL),('131','Montenegro','DT_SPACE_COUNTRY',NULL),('132','Montserrat','DT_SPACE_COUNTRY',NULL),('133','Morocco','DT_SPACE_COUNTRY',NULL),('134','Mozambique','DT_SPACE_COUNTRY',NULL),('135','Myanmar','DT_SPACE_COUNTRY',NULL),('136','Namibia','DT_SPACE_COUNTRY',NULL),('137','Nepal','DT_SPACE_COUNTRY',NULL),('138','Netherlands','DT_SPACE_COUNTRY',NULL),('139','New Caledonia','DT_SPACE_COUNTRY',NULL),('14','Bahrain','DT_SPACE_COUNTRY',NULL),('140','New Zealand','DT_SPACE_COUNTRY',NULL),('141','Nicaragua','DT_SPACE_COUNTRY',NULL),('142','Niger','DT_SPACE_COUNTRY',NULL),('143','Nigeria','DT_SPACE_COUNTRY',NULL),('144','North Macedonia','DT_SPACE_COUNTRY',NULL),('145','Northern Mariana Islands','DT_SPACE_COUNTRY',NULL),('146','Norway','DT_SPACE_COUNTRY',NULL),('147','Oman','DT_SPACE_COUNTRY',NULL),('148','Pakistan','DT_SPACE_COUNTRY',NULL),('149','Palestine','DT_SPACE_COUNTRY',NULL),('15','Bangladesh','DT_SPACE_COUNTRY',NULL),('150','Panama','DT_SPACE_COUNTRY',NULL),('151','Papua New Guinea','DT_SPACE_COUNTRY',NULL),('152','Paraguay','DT_SPACE_COUNTRY',NULL),('153','Peru','DT_SPACE_COUNTRY',NULL),('154','Philippines','DT_SPACE_COUNTRY',NULL),('155','Poland','DT_SPACE_COUNTRY',NULL),('156','Portugal','DT_SPACE_COUNTRY',NULL),('157','Puerto Rico','DT_SPACE_COUNTRY',NULL),('158','Qatar','DT_SPACE_COUNTRY',NULL),('159','Romania','DT_SPACE_COUNTRY',NULL),('16','Barbados','DT_SPACE_COUNTRY',NULL),('160','Russia','DT_SPACE_COUNTRY',NULL),('161','Rwanda','DT_SPACE_COUNTRY',NULL),('162','Saint Kitts And Nevis','DT_SPACE_COUNTRY',NULL),('163','Saint Lucia','DT_SPACE_COUNTRY',NULL),('164','Saint Vincent And The Grenadines','DT_SPACE_COUNTRY',NULL),('165','San Marino','DT_SPACE_COUNTRY',NULL),('166','Sao Tome And Principe','DT_SPACE_COUNTRY',NULL),('167','Saudi Arabia','DT_SPACE_COUNTRY',NULL),('168','Senegal','DT_SPACE_COUNTRY',NULL),('169','Serbia','DT_SPACE_COUNTRY',NULL),('17','Belarus','DT_SPACE_COUNTRY',NULL),('170','Seychelles','DT_SPACE_COUNTRY',NULL),('171','Sierra Leone','DT_SPACE_COUNTRY',NULL),('172','Singapore','DT_SPACE_COUNTRY',NULL),('173','Sint Maarten','DT_SPACE_COUNTRY',NULL),('174','Slovakia','DT_SPACE_COUNTRY',NULL),('175','Slovenia','DT_SPACE_COUNTRY',NULL),('176','Solomon Islands','DT_SPACE_COUNTRY',NULL),('177','Somalia','DT_SPACE_COUNTRY',NULL),('178','South Africa','DT_SPACE_COUNTRY',NULL),('179','South Korea','DT_SPACE_COUNTRY',NULL),('18','Belgium','DT_SPACE_COUNTRY',NULL),('180','South Sudan','DT_SPACE_COUNTRY',NULL),('181','Spain','DT_SPACE_COUNTRY',NULL),('182','Sri Lanka','DT_SPACE_COUNTRY',NULL),('183','Sudan','DT_SPACE_COUNTRY',NULL),('184','Suriname','DT_SPACE_COUNTRY',NULL),('185','Sweden','DT_SPACE_COUNTRY',NULL),('186','Switzerland','DT_SPACE_COUNTRY',NULL),('187','Syria','DT_SPACE_COUNTRY',NULL),('188','Taiwan','DT_SPACE_COUNTRY',NULL),('189','Tajikistan','DT_SPACE_COUNTRY',NULL),('19','Belize','DT_SPACE_COUNTRY',NULL),('190','Thailand','DT_SPACE_COUNTRY',NULL),('191','Timor Leste','DT_SPACE_COUNTRY',NULL),('192','Togo','DT_SPACE_COUNTRY',NULL),('193','Trinidad And Tobago','DT_SPACE_COUNTRY',NULL),('194','Tunisia','DT_SPACE_COUNTRY',NULL),('195','Turkey','DT_SPACE_COUNTRY',NULL),('196','Turks And Caicos Islands','DT_SPACE_COUNTRY',NULL),('197','Uganda','DT_SPACE_COUNTRY',NULL),('198','Ukraine','DT_SPACE_COUNTRY',NULL),('199','United Arab Emirates','DT_SPACE_COUNTRY',NULL),('2','Algeria','DT_SPACE_COUNTRY',NULL),('20','Benin','DT_SPACE_COUNTRY',NULL),('200','United Kingdom','DT_SPACE_COUNTRY',NULL),('201','United Republic Of Tanzania','DT_SPACE_COUNTRY',NULL),('202','United States Of America','DT_SPACE_COUNTRY',NULL),('203','United States Virgin Islands','DT_SPACE_COUNTRY',NULL),('204','Uruguay','DT_SPACE_COUNTRY',NULL),('205','Uzbekistan','DT_SPACE_COUNTRY',NULL),('206','Vanuatu','DT_SPACE_COUNTRY',NULL),('207','Venezuela','DT_SPACE_COUNTRY',NULL),('208','Vietnam','DT_SPACE_COUNTRY',NULL),('209','Wallis And Futuna','DT_SPACE_COUNTRY',NULL),('21','Bermuda','DT_SPACE_COUNTRY',NULL),('210','Western Sahara','DT_SPACE_COUNTRY',NULL),('211','Yemen','DT_SPACE_COUNTRY',NULL),('212','Zambia','DT_SPACE_COUNTRY',NULL),('213','Zimbabwe','DT_SPACE_COUNTRY',NULL),('214','America','DT_SPACE_CONTINENT',NULL),('215','Oceania','DT_SPACE_CONTINENT',NULL),('216','Europe','DT_SPACE_CONTINENT',NULL),('217','Africa','DT_SPACE_CONTINENT',NULL),('218','Asia','DT_SPACE_CONTINENT',NULL),('219','38928341','DT_SPACE_POPULATION',NULL),('22','Bhutan','DT_SPACE_COUNTRY',NULL),('220','32866268','DT_SPACE_POPULATION',NULL),('221','97928','DT_SPACE_POPULATION',NULL),('222','397621','DT_SPACE_POPULATION',NULL),('223','12123198','DT_SPACE_POPULATION',NULL),('224','3280815','DT_SPACE_POPULATION',NULL),('225','65720','DT_SPACE_POPULATION',NULL),('226','26378275','DT_SPACE_POPULATION',NULL),('227','888005','DT_SPACE_POPULATION',NULL),('228','1328976','DT_SPACE_POPULATION',NULL),('229','2225728','DT_SPACE_POPULATION',NULL),('23','Bolivia','DT_SPACE_COUNTRY',NULL),('230','3989175','DT_SPACE_POPULATION',NULL),('231','83166711','DT_SPACE_POPULATION',NULL),('232','9904608','DT_SPACE_POPULATION',NULL),('233','40222503','DT_SPACE_POPULATION',NULL),('234','4964440','DT_SPACE_POPULATION',NULL),('235','2961161','DT_SPACE_POPULATION',NULL),('236','126476458','DT_SPACE_POPULATION',NULL),('237','1907675','DT_SPACE_POPULATION',NULL),('238','2794090','DT_SPACE_POPULATION',NULL),('239','2076255','DT_SPACE_POPULATION',NULL),('24','Bonaire, Saint Eustatius And Saba','DT_SPACE_COUNTRY',NULL),('240','5106622','DT_SPACE_POPULATION',NULL),('241','8947027','DT_SPACE_POPULATION',NULL),('242','7132530','DT_SPACE_POPULATION',NULL),('243','145934460','DT_SPACE_POPULATION',NULL),('244','16743930','DT_SPACE_POPULATION',NULL),('245','5457873','DT_SPACE_POPULATION',NULL),('246','47332614','DT_SPACE_POPULATION',NULL),('247','1399491','DT_SPACE_POPULATION',NULL),('248','14862927','DT_SPACE_POPULATION',NULL),('249','20903278','DT_SPACE_POPULATION',NULL),('25','Bosnia And Herzegovina','DT_SPACE_COUNTRY',NULL),('250','5518092','DT_SPACE_POPULATION',NULL),('251','6486201','DT_SPACE_POPULATION',NULL),('252','2416664','DT_SPACE_POPULATION',NULL),('253','112519','DT_SPACE_POPULATION',NULL),('254','64468','DT_SPACE_POPULATION',NULL),('255','786559','DT_SPACE_POPULATION',NULL),('256','10203140','DT_SPACE_POPULATION',NULL),('257','7275556','DT_SPACE_POPULATION',NULL),('258','36910558','DT_SPACE_POPULATION',NULL),('259','17407585','DT_SPACE_POPULATION',NULL),('26','Botswana','DT_SPACE_COUNTRY',NULL),('260','32971846','DT_SPACE_POPULATION',NULL),('261','219161','DT_SPACE_POPULATION',NULL),('262','7976985','DT_SPACE_POPULATION',NULL),('263','686878','DT_SPACE_POPULATION',NULL),('264','51269183','DT_SPACE_POPULATION',NULL),('265','23816775','DT_SPACE_POPULATION',NULL),('266','3473727','DT_SPACE_POPULATION',NULL),('267','76177','DT_SPACE_POPULATION',NULL),('268','15002','DT_SPACE_POPULATION',NULL),('269','26221','DT_SPACE_POPULATION',NULL),('27','Brazil','DT_SPACE_COUNTRY',NULL),('270','1439323774','DT_SPACE_POPULATION',NULL),('271','10693939','DT_SPACE_POPULATION',NULL),('272','102334403','DT_SPACE_POPULATION',NULL),('273','1402985','DT_SPACE_POPULATION',NULL),('274','3483','DT_SPACE_POPULATION',NULL),('275','5525292','DT_SPACE_POPULATION',NULL),('276','10718565','DT_SPACE_POPULATION',NULL),('277','56772','DT_SPACE_POPULATION',NULL),('278','11402533','DT_SPACE_POPULATION',NULL),('279','273523621','DT_SPACE_POPULATION',NULL),('28','British Virgin Islands','DT_SPACE_COUNTRY',NULL),('280','107796','DT_SPACE_POPULATION',NULL),('281','4270563','DT_SPACE_POPULATION',NULL),('282','6524191','DT_SPACE_POPULATION',NULL),('283','6825442','DT_SPACE_POPULATION',NULL),('284','540542','DT_SPACE_POPULATION',NULL),('285','4033963','DT_SPACE_POPULATION',NULL),('286','54409794','DT_SPACE_POPULATION',NULL),('287','2540916','DT_SPACE_POPULATION',NULL),('288','37958138','DT_SPACE_POPULATION',NULL),('289','2860840','DT_SPACE_POPULATION',NULL),('29','Brunei Darussalam','DT_SPACE_COUNTRY',NULL),('290','98340','DT_SPACE_POPULATION',NULL),('291','42882','DT_SPACE_POPULATION',NULL),('292','59308690','DT_SPACE_POPULATION',NULL),('293','11193729','DT_SPACE_POPULATION',NULL),('294','69799978','DT_SPACE_POPULATION',NULL),('295','43733759','DT_SPACE_POPULATION',NULL),('296','104423','DT_SPACE_POPULATION',NULL),('297','45195777','DT_SPACE_POPULATION',NULL),('298','10139175','DT_SPACE_POPULATION',NULL),('299','287371','DT_SPACE_POPULATION',NULL),('3','Andorra','DT_SPACE_COUNTRY',NULL),('30','Bulgaria','DT_SPACE_COUNTRY',NULL),('300','9449321','DT_SPACE_POPULATION',NULL),('301','50882884','DT_SPACE_POPULATION',NULL),('302','869595','DT_SPACE_POPULATION',NULL),('303','10847904','DT_SPACE_POPULATION',NULL),('304','17643060','DT_SPACE_POPULATION',NULL),('305','168783','DT_SPACE_POPULATION',NULL),('306','1967998','DT_SPACE_POPULATION',NULL),('307','809','DT_SPACE_POPULATION',NULL),('308','4649660','DT_SPACE_POPULATION',NULL),('309','3278292','DT_SPACE_POPULATION',NULL),('31','Burkina Faso','DT_SPACE_COUNTRY',NULL),('310','285491','DT_SPACE_POPULATION',NULL),('311','4314768','DT_SPACE_POPULATION',NULL),('312','19328838','DT_SPACE_POPULATION',NULL),('313','5850343','DT_SPACE_POPULATION',NULL),('314','8278737','DT_SPACE_POPULATION',NULL),('315','11818618','DT_SPACE_POPULATION',NULL),('316','33469199','DT_SPACE_POPULATION',NULL),('317','97338583','DT_SPACE_POPULATION',NULL),('318','597330','DT_SPACE_POPULATION',NULL),('319','2845955','DT_SPACE_POPULATION',NULL),('32','Burundi','DT_SPACE_COUNTRY',NULL),('320','393248','DT_SPACE_POPULATION',NULL),('321','1701583','DT_SPACE_POPULATION',NULL),('322','11673029','DT_SPACE_POPULATION',NULL),('323','212559409','DT_SPACE_POPULATION',NULL),('324','6951482','DT_SPACE_POPULATION',NULL),('325','16718971','DT_SPACE_POPULATION',NULL),('326','37742157','DT_SPACE_POPULATION',NULL),('327','555988','DT_SPACE_POPULATION',NULL),('328','4829764','DT_SPACE_POPULATION',NULL),('329','16425859','DT_SPACE_POPULATION',NULL),('33','Cambodia','DT_SPACE_COUNTRY',NULL),('330','5094114','DT_SPACE_POPULATION',NULL),('331','3546427','DT_SPACE_POPULATION',NULL),('332','48865','DT_SPACE_POPULATION',NULL),('333','896444','DT_SPACE_POPULATION',NULL),('334','31072945','DT_SPACE_POPULATION',NULL),('335','9769526','DT_SPACE_POPULATION',NULL),('336','5057677','DT_SPACE_POPULATION',NULL),('337','38747','DT_SPACE_POPULATION',NULL),('338','20250834','DT_SPACE_POPULATION',NULL),('339','1271767','DT_SPACE_POPULATION',NULL),('34','Cameroon','DT_SPACE_COUNTRY',NULL),('340','621873','DT_SPACE_POPULATION',NULL),('341','4999','DT_SPACE_POPULATION',NULL),('342','31255435','DT_SPACE_POPULATION',NULL),('343','57557','DT_SPACE_POPULATION',NULL),('344','220892331','DT_SPACE_POPULATION',NULL),('345','10295909','DT_SPACE_POPULATION',NULL),('346','34453','DT_SPACE_POPULATION',NULL),('347','34813867','DT_SPACE_POPULATION',NULL),('348','6926705','DT_SPACE_POPULATION',NULL),('349','21413250','DT_SPACE_POPULATION',NULL),('35','Canada','DT_SPACE_COUNTRY',NULL),('350','10327589','DT_SPACE_POPULATION',NULL),('351','59734213','DT_SPACE_POPULATION',NULL),('352','331002647','DT_SPACE_POPULATION',NULL),('353','25499881','DT_SPACE_POPULATION',NULL),('354','8901064','DT_SPACE_POPULATION',NULL),('355','164689383','DT_SPACE_POPULATION',NULL),('356','11522440','DT_SPACE_POPULATION',NULL),('357','2351625','DT_SPACE_POPULATION',NULL),('358','437483','DT_SPACE_POPULATION',NULL),('359','4058165','DT_SPACE_POPULATION',NULL),('36','Cape Verde','DT_SPACE_COUNTRY',NULL),('360','17915567','DT_SPACE_POPULATION',NULL),('361','364134','DT_SPACE_POPULATION',NULL),('362','18776707','DT_SPACE_POPULATION',NULL),('363','53771300','DT_SPACE_POPULATION',NULL),('364','2142252','DT_SPACE_POPULATION',NULL),('365','6871287','DT_SPACE_POPULATION',NULL),('366','626108','DT_SPACE_POPULATION',NULL),('367','514564','DT_SPACE_POPULATION',NULL),('368','59194','DT_SPACE_POPULATION',NULL),('369','128932753','DT_SPACE_POPULATION',NULL),('37','Cayman Islands','DT_SPACE_COUNTRY',NULL),('370','115021','DT_SPACE_POPULATION',NULL),('371','39244','DT_SPACE_POPULATION',NULL),('372','206139587','DT_SPACE_POPULATION',NULL),('373','5101416','DT_SPACE_POPULATION',NULL),('374','183629','DT_SPACE_POPULATION',NULL),('375','2095861','DT_SPACE_POPULATION',NULL),('376','586634','DT_SPACE_POPULATION',NULL),('377','17500657','DT_SPACE_POPULATION',NULL),('378','83154997','DT_SPACE_POPULATION',NULL),('379','45741000','DT_SPACE_POPULATION',NULL),('38','Central African Republic','DT_SPACE_COUNTRY',NULL),('380','307150','DT_SPACE_POPULATION',NULL),('381','29825968','DT_SPACE_POPULATION',NULL),('382','43851043','DT_SPACE_POPULATION',NULL),('383','106766','DT_SPACE_POPULATION',NULL),('384','11890781','DT_SPACE_POPULATION',NULL),('385','26545864','DT_SPACE_POPULATION',NULL),('386','19116209','DT_SPACE_POPULATION',NULL),('387','11326616','DT_SPACE_POPULATION',NULL),('388','89561404','DT_SPACE_POPULATION',NULL),('389','5822763','DT_SPACE_POPULATION',NULL),('39','Chad','DT_SPACE_COUNTRY',NULL),('390','988002','DT_SPACE_POPULATION',NULL),('391','114963583','DT_SPACE_POPULATION',NULL),('392','13132792','DT_SPACE_POPULATION',NULL),('393','85032','DT_SPACE_POPULATION',NULL),('394','8655541','DT_SPACE_POPULATION',NULL),('395','1795666','DT_SPACE_POPULATION',NULL),('396','6624554','DT_SPACE_POPULATION',NULL),('397','109581085','DT_SPACE_POPULATION',NULL),('398','2881060','DT_SPACE_POPULATION',NULL),('399','110947','DT_SPACE_POPULATION',NULL),('4','Angola','DT_SPACE_COUNTRY',NULL),('40','Chile','DT_SPACE_COUNTRY',NULL),('400','43849269','DT_SPACE_POPULATION',NULL),('401','8606033','DT_SPACE_POPULATION',NULL),('402','1318442','DT_SPACE_POPULATION',NULL),('403','9890400','DT_SPACE_POPULATION',NULL),('404','28435943','DT_SPACE_POPULATION',NULL),('405','2963234','DT_SPACE_POPULATION',NULL),('406','62273','DT_SPACE_POPULATION',NULL),('407','771612','DT_SPACE_POPULATION',NULL),('408','30237','DT_SPACE_POPULATION',NULL),('409','164100','DT_SPACE_POPULATION',NULL),('41','China','DT_SPACE_COUNTRY',NULL),('410','71991','DT_SPACE_POPULATION',NULL),('411','1160164','DT_SPACE_POPULATION',NULL),('412','67320216','DT_SPACE_POPULATION',NULL),('413','280904','DT_SPACE_POPULATION',NULL),('414','33691','DT_SPACE_POPULATION',NULL),('415','1380004385','DT_SPACE_POPULATION',NULL),('416','83992953','DT_SPACE_POPULATION',NULL),('417','59641488','DT_SPACE_POPULATION',NULL),('418','27691019','DT_SPACE_POPULATION',NULL),('419','19129955','DT_SPACE_POPULATION',NULL),('42','Colombia','DT_SPACE_COUNTRY',NULL),('420','32365998','DT_SPACE_POPULATION',NULL),('421','29136808','DT_SPACE_POPULATION',NULL),('422','4822233','DT_SPACE_POPULATION',NULL),('423','24206636','DT_SPACE_POPULATION',NULL),('424','5367580','DT_SPACE_POPULATION',NULL),('425','12952209','DT_SPACE_POPULATION',NULL),('426','53192','DT_SPACE_POPULATION',NULL),('427','15893219','DT_SPACE_POPULATION',NULL),('428','9537642','DT_SPACE_POPULATION',NULL),('429','38718','DT_SPACE_POPULATION',NULL),('43','Comoros','DT_SPACE_COUNTRY',NULL),('430','68059863','DT_SPACE_POPULATION',NULL),('431','11246','DT_SPACE_POPULATION',NULL),('432','18383956','DT_SPACE_POPULATION',NULL),('433','2020-AGO-33','DT_TIME_WEEK',NULL),('434','2020-AGO-34','DT_TIME_WEEK',NULL),('435','2020-AGO-35','DT_TIME_WEEK',NULL),('436','2020-AGO-36','DT_TIME_WEEK',NULL),('437','2020-AGO-37','DT_TIME_WEEK',NULL),('438','2020-APR-15','DT_TIME_WEEK',NULL),('439','2020-APR-16','DT_TIME_WEEK',NULL),('44','Congo','DT_SPACE_COUNTRY',NULL),('440','2020-APR-17','DT_TIME_WEEK',NULL),('441','2020-APR-18','DT_TIME_WEEK',NULL),('442','2020-DEC-50','DT_TIME_WEEK',NULL),('443','2020-DEC-51','DT_TIME_WEEK',NULL),('444','2020-DEC-52','DT_TIME_WEEK',NULL),('445','2020-DEC-53','DT_TIME_WEEK',NULL),('446','2020-FEB-06','DT_TIME_WEEK',NULL),('447','2020-FEB-07','DT_TIME_WEEK',NULL),('448','2020-FEB-08','DT_TIME_WEEK',NULL),('449','2020-FEB-09','DT_TIME_WEEK',NULL),('45','Costa Rica','DT_SPACE_COUNTRY',NULL),('450','2020-JAN-01','DT_TIME_WEEK',NULL),('451','2020-JAN-02','DT_TIME_WEEK',NULL),('452','2020-JAN-03','DT_TIME_WEEK',NULL),('453','2020-JAN-04','DT_TIME_WEEK',NULL),('454','2020-JAN-05','DT_TIME_WEEK',NULL),('455','2020-JUL-28','DT_TIME_WEEK',NULL),('456','2020-JUL-29','DT_TIME_WEEK',NULL),('457','2020-JUL-30','DT_TIME_WEEK',NULL),('458','2020-JUL-31','DT_TIME_WEEK',NULL),('459','2020-JUL-32','DT_TIME_WEEK',NULL),('46','Cote Divoire','DT_SPACE_COUNTRY',NULL),('460','2020-JUN-24','DT_TIME_WEEK',NULL),('461','2020-JUN-25','DT_TIME_WEEK',NULL),('462','2020-JUN-26','DT_TIME_WEEK',NULL),('463','2020-JUN-27','DT_TIME_WEEK',NULL),('464','2020-MAR-10','DT_TIME_WEEK',NULL),('465','2020-MAR-11','DT_TIME_WEEK',NULL),('466','2020-MAR-12','DT_TIME_WEEK',NULL),('467','2020-MAR-13','DT_TIME_WEEK',NULL),('468','2020-MAR-14','DT_TIME_WEEK',NULL),('469','2020-MAY-19','DT_TIME_WEEK',NULL),('47','Croatia','DT_SPACE_COUNTRY',NULL),('470','2020-MAY-20','DT_TIME_WEEK',NULL),('471','2020-MAY-21','DT_TIME_WEEK',NULL),('472','2020-MAY-22','DT_TIME_WEEK',NULL),('473','2020-MAY-23','DT_TIME_WEEK',NULL),('474','2020-NOV-46','DT_TIME_WEEK',NULL),('475','2020-NOV-47','DT_TIME_WEEK',NULL),('476','2020-NOV-48','DT_TIME_WEEK',NULL),('477','2020-NOV-49','DT_TIME_WEEK',NULL),('478','2020-OCT-42','DT_TIME_WEEK',NULL),('479','2020-OCT-43','DT_TIME_WEEK',NULL),('48','Cuba','DT_SPACE_COUNTRY',NULL),('480','2020-OCT-44','DT_TIME_WEEK',NULL),('481','2020-OCT-45','DT_TIME_WEEK',NULL),('482','2020-SEP-38','DT_TIME_WEEK',NULL),('483','2020-SEP-39','DT_TIME_WEEK',NULL),('484','2020-SEP-40','DT_TIME_WEEK',NULL),('485','2020-SEP-41','DT_TIME_WEEK',NULL),('486','2021-APR-15','DT_TIME_WEEK',NULL),('487','2021-APR-16','DT_TIME_WEEK',NULL),('488','2021-APR-17','DT_TIME_WEEK',NULL),('489','2021-APR-18','DT_TIME_WEEK',NULL),('49','Curaçao','DT_SPACE_COUNTRY',NULL),('490','2021-FEB-06','DT_TIME_WEEK',NULL),('491','2021-FEB-07','DT_TIME_WEEK',NULL),('492','2021-FEB-08','DT_TIME_WEEK',NULL),('493','2021-FEB-09','DT_TIME_WEEK',NULL),('494','2021-JAN-01','DT_TIME_WEEK',NULL),('495','2021-JAN-02','DT_TIME_WEEK',NULL),('496','2021-JAN-03','DT_TIME_WEEK',NULL),('497','2021-JAN-04','DT_TIME_WEEK',NULL),('498','2021-JAN-05','DT_TIME_WEEK',NULL),('499','2021-JUN-24','DT_TIME_WEEK',NULL),('5','Anguilla','DT_SPACE_COUNTRY',NULL),('50','Cyprus','DT_SPACE_COUNTRY',NULL),('500','2021-MAR-10','DT_TIME_WEEK',NULL),('501','2021-MAR-11','DT_TIME_WEEK',NULL),('502','2021-MAR-12','DT_TIME_WEEK',NULL),('503','2021-MAR-13','DT_TIME_WEEK',NULL),('504','2021-MAR-14','DT_TIME_WEEK',NULL),('505','2021-MAY-19','DT_TIME_WEEK',NULL),('506','2021-MAY-20','DT_TIME_WEEK',NULL),('507','2021-MAY-21','DT_TIME_WEEK',NULL),('508','2021-MAY-22','DT_TIME_WEEK',NULL),('509','2021-MAY-23','DT_TIME_WEEK',NULL),('51','Czechia','DT_SPACE_COUNTRY',NULL),('510','2021','DT_TIME_YEAR',NULL),('511','2020','DT_TIME_YEAR',NULL),('512','2020-APR','DT_TIME_MONTH',NULL),('513','2020-JAN','DT_TIME_MONTH',NULL),('514','2021-FEB','DT_TIME_MONTH',NULL),('515','2020-JUN','DT_TIME_MONTH',NULL),('516','2020-MAR','DT_TIME_MONTH',NULL),('517','2020-SEP','DT_TIME_MONTH',NULL),('518','2021-JAN','DT_TIME_MONTH',NULL),('519','2021-JUN','DT_TIME_MONTH',NULL),('52','Democratic Republic Of The Congo','DT_SPACE_COUNTRY',NULL),('520','2021-MAR','DT_TIME_MONTH',NULL),('521','2020-FEB','DT_TIME_MONTH',NULL),('522','2020-NOV','DT_TIME_MONTH',NULL),('523','2020-OCT','DT_TIME_MONTH',NULL),('524','2021-APR','DT_TIME_MONTH',NULL),('525','2021-MAY','DT_TIME_MONTH',NULL),('526','2020-JUL','DT_TIME_MONTH',NULL),('527','2020-AGO','DT_TIME_MONTH',NULL),('528','2020-DEC','DT_TIME_MONTH',NULL),('529','2020-MAY','DT_TIME_MONTH',NULL),('53','Denmark','DT_SPACE_COUNTRY',NULL),('54','Djibouti','DT_SPACE_COUNTRY',NULL),('55','Dominica','DT_SPACE_COUNTRY',NULL),('56','Dominican Republic','DT_SPACE_COUNTRY',NULL),('57','Ecuador','DT_SPACE_COUNTRY',NULL),('58','Egypt','DT_SPACE_COUNTRY',NULL),('59','El Salvador','DT_SPACE_COUNTRY',NULL),('6','Antigua And Barbuda','DT_SPACE_COUNTRY',NULL),('60','Equatorial Guinea','DT_SPACE_COUNTRY',NULL),('61','Eritrea','DT_SPACE_COUNTRY',NULL),('62','Estonia','DT_SPACE_COUNTRY',NULL),('63','Eswatini','DT_SPACE_COUNTRY',NULL),('64','Ethiopia','DT_SPACE_COUNTRY',NULL),('65','Falkland Islands (Malvinas)','DT_SPACE_COUNTRY',NULL),('66','Faroe Islands','DT_SPACE_COUNTRY',NULL),('67','Fiji','DT_SPACE_COUNTRY',NULL),('68','Finland','DT_SPACE_COUNTRY',NULL),('69','France','DT_SPACE_COUNTRY',NULL),('7','Argentina','DT_SPACE_COUNTRY',NULL),('70','French Polynesia','DT_SPACE_COUNTRY',NULL),('71','Gabon','DT_SPACE_COUNTRY',NULL),('72','Gambia','DT_SPACE_COUNTRY',NULL),('73','Georgia','DT_SPACE_COUNTRY',NULL),('74','Germany','DT_SPACE_COUNTRY',NULL),('75','Ghana','DT_SPACE_COUNTRY',NULL),('76','Gibraltar','DT_SPACE_COUNTRY',NULL),('77','Greece','DT_SPACE_COUNTRY',NULL),('78','Greenland','DT_SPACE_COUNTRY',NULL),('79','Grenada','DT_SPACE_COUNTRY',NULL),('8','Armenia','DT_SPACE_COUNTRY',NULL),('80','Guam','DT_SPACE_COUNTRY',NULL),('81','Guatemala','DT_SPACE_COUNTRY',NULL),('82','Guernsey','DT_SPACE_COUNTRY',NULL),('83','Guinea','DT_SPACE_COUNTRY',NULL),('84','Guinea Bissau','DT_SPACE_COUNTRY',NULL),('85','Guyana','DT_SPACE_COUNTRY',NULL),('86','Haiti','DT_SPACE_COUNTRY',NULL),('87','Holy See','DT_SPACE_COUNTRY',NULL),('88','Honduras','DT_SPACE_COUNTRY',NULL),('89','Hungary','DT_SPACE_COUNTRY',NULL),('9','Aruba','DT_SPACE_COUNTRY',NULL),('90','Iceland','DT_SPACE_COUNTRY',NULL),('91','India','DT_SPACE_COUNTRY',NULL),('92','Indonesia','DT_SPACE_COUNTRY',NULL),('93','Iran','DT_SPACE_COUNTRY',NULL),('94','Iraq','DT_SPACE_COUNTRY',NULL),('95','Ireland','DT_SPACE_COUNTRY',NULL),('96','Isle Of Man','DT_SPACE_COUNTRY',NULL),('97','Israel','DT_SPACE_COUNTRY',NULL),('98','Italy','DT_SPACE_COUNTRY',NULL),('99','Jamaica','DT_SPACE_COUNTRY',NULL);
/*!40000 ALTER TABLE `MEMBER` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `OLAPSESSION`
--

DROP TABLE IF EXISTS `OLAPSESSION`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `OLAPSESSION` (
                               `TIMESTAMP` int(11) DEFAULT NULL,
                               `session_id` varchar(255) DEFAULT NULL,
                               `annotation_id` varchar(255) DEFAULT NULL,
                               `value_en` varchar(1000) DEFAULT NULL,
                               `value_ita` varchar(1000) DEFAULT NULL,
                               `LIMIT` mediumtext,
                               `fullquery_serialized` blob,
                               `fullquery_tree` varchar(1000) DEFAULT NULL,
                               `olapoperator_serialized` blob
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `OLAPSESSION`
--

LOCK TABLES `OLAPSESSION` WRITE;
/*!40000 ALTER TABLE `OLAPSESSION` DISABLE KEYS */;
/*!40000 ALTER TABLE `OLAPSESSION` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `QUERIES`
--

DROP TABLE IF EXISTS `QUERIES`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `QUERIES` (
                           `query` varchar(1000) DEFAULT NULL,
                           `mc` varchar(255) DEFAULT NULL,
                           `gc` varchar(255) DEFAULT NULL,
                           `sc` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `QUERIES`
--

LOCK TABLES `QUERIES` WRITE;
/*!40000 ALTER TABLE `QUERIES` DISABLE KEYS */;
/*!40000 ALTER TABLE `QUERIES` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `RELATIONSHIP`
--

DROP TABLE IF EXISTS `RELATIONSHIP`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `RELATIONSHIP` (
                                `relationship_id` varchar(255) NOT NULL,
                                `table1` varchar(255) NOT NULL,
                                `table2` varchar(255) NOT NULL,
                                PRIMARY KEY (`relationship_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `RELATIONSHIP`
--

LOCK TABLES `RELATIONSHIP` WRITE;
/*!40000 ALTER TABLE `RELATIONSHIP` DISABLE KEYS */;
INSERT INTO `RELATIONSHIP` VALUES ('FT_DT_SPACE','FT','DT_SPACE'),('FT_DT_TIME','FT','DT_TIME');
/*!40000 ALTER TABLE `RELATIONSHIP` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `SYNONYM`
--

DROP TABLE IF EXISTS `SYNONYM`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `SYNONYM` (
                           `synonym_id` varchar(255) NOT NULL,
                           `table_name` varchar(255) NOT NULL,
                           `reference_id` varchar(255) NOT NULL,
                           `TERM` varchar(255) NOT NULL,
                           PRIMARY KEY (`synonym_id`),
                           UNIQUE KEY `TERM` (`TERM`,`reference_id`,`table_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `SYNONYM`
--

LOCK TABLES `SYNONYM` WRITE;
/*!40000 ALTER TABLE `SYNONYM` DISABLE KEYS */;
INSERT INTO `SYNONYM` VALUES ('839','MEMBER','298','10139175'),('797','MEMBER','256','10203140'),('813','MEMBER','272','102334403'),('886','MEMBER','345','10295909'),('891','MEMBER','350','10327589'),('837','MEMBER','296','104423'),('924','MEMBER','383','106766'),('812','MEMBER','271','10693939'),('817','MEMBER','276','10718565'),('821','MEMBER','280','107796'),('844','MEMBER','303','10847904'),('938','MEMBER','397','109581085'),('940','MEMBER','399','110947'),('834','MEMBER','293','11193729'),('972','MEMBER','431','11246'),('794','MEMBER','253','112519'),('928','MEMBER','387','11326616'),('819','MEMBER','278','11402533'),('932','MEMBER','391','114963583'),('911','MEMBER','370','115021'),('897','MEMBER','356','11522440'),('952','MEMBER','411','1160164'),('863','MEMBER','322','11673029'),('856','MEMBER','315','11818618'),('925','MEMBER','384','11890781'),('764','MEMBER','223','12123198'),('777','MEMBER','236','126476458'),('880','MEMBER','339','1271767'),('910','MEMBER','369','128932753'),('966','MEMBER','425','12952209'),('933','MEMBER','392','13132792'),('943','MEMBER','402','1318442'),('769','MEMBER','228','1328976'),('956','MEMBER','415','1380004385'),('788','MEMBER','247','1399491'),('814','MEMBER','273','1402985'),('811','MEMBER','270','1439323774'),('784','MEMBER','243','145934460'),('789','MEMBER','248','14862927'),('809','MEMBER','268','15002'),('968','MEMBER','427','15893219'),('950','MEMBER','409','164100'),('870','MEMBER','329','16425859'),('896','MEMBER','355','164689383'),('866','MEMBER','325','16718971'),('785','MEMBER','244','16743930'),('846','MEMBER','305','168783'),('862','MEMBER','321','1701583'),('800','MEMBER','259','17407585'),('918','MEMBER','377','17500657'),('845','MEMBER','304','17643060'),('901','MEMBER','360','17915567'),('936','MEMBER','395','1795666'),('915','MEMBER','374','183629'),('973','MEMBER','432','18383956'),('903','MEMBER','362','18776707'),('778','MEMBER','237','1907675'),('927','MEMBER','386','19116209'),('960','MEMBER','419','19129955'),('853','MEMBER','312','19328838'),('847','MEMBER','306','1967998'),('1052','MEMBER','511','2020'),('1068','MEMBER','527','2020-AGO'),('974','MEMBER','433','2020-AGO-33'),('975','MEMBER','434','2020-AGO-34'),('976','MEMBER','435','2020-AGO-35'),('977','MEMBER','436','2020-AGO-36'),('978','MEMBER','437','2020-AGO-37'),('1053','MEMBER','512','2020-APR'),('979','MEMBER','438','2020-APR-15'),('980','MEMBER','439','2020-APR-16'),('981','MEMBER','440','2020-APR-17'),('982','MEMBER','441','2020-APR-18'),('1069','MEMBER','528','2020-DEC'),('983','MEMBER','442','2020-DEC-50'),('984','MEMBER','443','2020-DEC-51'),('985','MEMBER','444','2020-DEC-52'),('986','MEMBER','445','2020-DEC-53'),('1062','MEMBER','521','2020-FEB'),('987','MEMBER','446','2020-FEB-06'),('988','MEMBER','447','2020-FEB-07'),('989','MEMBER','448','2020-FEB-08'),('990','MEMBER','449','2020-FEB-09'),('1054','MEMBER','513','2020-JAN'),('991','MEMBER','450','2020-JAN-01'),('992','MEMBER','451','2020-JAN-02'),('993','MEMBER','452','2020-JAN-03'),('994','MEMBER','453','2020-JAN-04'),('995','MEMBER','454','2020-JAN-05'),('1067','MEMBER','526','2020-JUL'),('996','MEMBER','455','2020-JUL-28'),('997','MEMBER','456','2020-JUL-29'),('998','MEMBER','457','2020-JUL-30'),('999','MEMBER','458','2020-JUL-31'),('1000','MEMBER','459','2020-JUL-32'),('1056','MEMBER','515','2020-JUN'),('1001','MEMBER','460','2020-JUN-24'),('1002','MEMBER','461','2020-JUN-25'),('1003','MEMBER','462','2020-JUN-26'),('1004','MEMBER','463','2020-JUN-27'),('1057','MEMBER','516','2020-MAR'),('1005','MEMBER','464','2020-MAR-10'),('1006','MEMBER','465','2020-MAR-11'),('1007','MEMBER','466','2020-MAR-12'),('1008','MEMBER','467','2020-MAR-13'),('1009','MEMBER','468','2020-MAR-14'),('1070','MEMBER','529','2020-MAY'),('1010','MEMBER','469','2020-MAY-19'),('1011','MEMBER','470','2020-MAY-20'),('1012','MEMBER','471','2020-MAY-21'),('1013','MEMBER','472','2020-MAY-22'),('1014','MEMBER','473','2020-MAY-23'),('1063','MEMBER','522','2020-NOV'),('1015','MEMBER','474','2020-NOV-46'),('1016','MEMBER','475','2020-NOV-47'),('1017','MEMBER','476','2020-NOV-48'),('1018','MEMBER','477','2020-NOV-49'),('1064','MEMBER','523','2020-OCT'),('1019','MEMBER','478','2020-OCT-42'),('1020','MEMBER','479','2020-OCT-43'),('1021','MEMBER','480','2020-OCT-44'),('1022','MEMBER','481','2020-OCT-45'),('1058','MEMBER','517','2020-SEP'),('1023','MEMBER','482','2020-SEP-38'),('1024','MEMBER','483','2020-SEP-39'),('1025','MEMBER','484','2020-SEP-40'),('1026','MEMBER','485','2020-SEP-41'),('1051','MEMBER','510','2021'),('1065','MEMBER','524','2021-APR'),('1027','MEMBER','486','2021-APR-15'),('1028','MEMBER','487','2021-APR-16'),('1029','MEMBER','488','2021-APR-17'),('1030','MEMBER','489','2021-APR-18'),('1055','MEMBER','514','2021-FEB'),('1031','MEMBER','490','2021-FEB-06'),('1032','MEMBER','491','2021-FEB-07'),('1033','MEMBER','492','2021-FEB-08'),('1034','MEMBER','493','2021-FEB-09'),('1059','MEMBER','518','2021-JAN'),('1035','MEMBER','494','2021-JAN-01'),('1036','MEMBER','495','2021-JAN-02'),('1037','MEMBER','496','2021-JAN-03'),('1038','MEMBER','497','2021-JAN-04'),('1039','MEMBER','498','2021-JAN-05'),('1060','MEMBER','519','2021-JUN'),('1040','MEMBER','499','2021-JUN-24'),('1061','MEMBER','520','2021-MAR'),('1041','MEMBER','500','2021-MAR-10'),('1042','MEMBER','501','2021-MAR-11'),('1043','MEMBER','502','2021-MAR-12'),('1044','MEMBER','503','2021-MAR-13'),('1045','MEMBER','504','2021-MAR-14'),('1066','MEMBER','525','2021-MAY'),('1046','MEMBER','505','2021-MAY-19'),('1047','MEMBER','506','2021-MAY-20'),('1048','MEMBER','507','2021-MAY-21'),('1049','MEMBER','508','2021-MAY-22'),('1050','MEMBER','509','2021-MAY-23'),('879','MEMBER','338','20250834'),('913','MEMBER','372','206139587'),('780','MEMBER','239','2076255'),('790','MEMBER','249','20903278'),('916','MEMBER','375','2095861'),('864','MEMBER','323','212559409'),('890','MEMBER','349','21413250'),('905','MEMBER','364','2142252'),('802','MEMBER','261','219161'),('885','MEMBER','344','220892331'),('770','MEMBER','229','2225728'),('898','MEMBER','357','2351625'),('806','MEMBER','265','23816775'),('793','MEMBER','252','2416664'),('964','MEMBER','423','24206636'),('828','MEMBER','287','2540916'),('894','MEMBER','353','25499881'),('810','MEMBER','269','26221'),('767','MEMBER','226','26378275'),('926','MEMBER','385','26545864'),('820','MEMBER','279','273523621'),('959','MEMBER','418','27691019'),('779','MEMBER','238','2794090'),('954','MEMBER','413','280904'),('945','MEMBER','404','28435943'),('860','MEMBER','319','2845955'),('851','MEMBER','310','285491'),('830','MEMBER','289','2860840'),('840','MEMBER','299','287371'),('939','MEMBER','398','2881060'),('962','MEMBER','421','29136808'),('776','MEMBER','235','2961161'),('946','MEMBER','405','2963234'),('922','MEMBER','381','29825968'),('949','MEMBER','408','30237'),('921','MEMBER','380','307150'),('875','MEMBER','334','31072945'),('883','MEMBER','342','31255435'),('961','MEMBER','420','32365998'),('850','MEMBER','309','3278292'),('765','MEMBER','224','3280815'),('761','MEMBER','220','32866268'),('801','MEMBER','260','32971846'),('893','MEMBER','352','331002647'),('857','MEMBER','316','33469199'),('955','MEMBER','414','33691'),('887','MEMBER','346','34453'),('807','MEMBER','266','3473727'),('888','MEMBER','347','34813867'),('815','MEMBER','274','3483'),('872','MEMBER','331','3546427'),('902','MEMBER','361','364134'),('799','MEMBER','258','36910558'),('867','MEMBER','326','37742157'),('829','MEMBER','288','37958138'),('970','MEMBER','429','38718'),('878','MEMBER','337','38747'),('760','MEMBER','219','38928341'),('912','MEMBER','371','39244'),('861','MEMBER','320','393248'),('763','MEMBER','222','397621'),('771','MEMBER','230','3989175'),('774','MEMBER','233','40222503'),('826','MEMBER','285','4033963'),('900','MEMBER','359','4058165'),('822','MEMBER','281','4270563'),('832','MEMBER','291','42882'),('852','MEMBER','311','4314768'),('836','MEMBER','295','43733759'),('899','MEMBER','358','437483'),('941','MEMBER','400','43849269'),('923','MEMBER','382','43851043'),('838','MEMBER','297','45195777'),('920','MEMBER','379','45741000'),('849','MEMBER','308','4649660'),('787','MEMBER','246','47332614'),('963','MEMBER','422','4822233'),('869','MEMBER','328','4829764'),('873','MEMBER','332','48865'),('775','MEMBER','234','4964440'),('882','MEMBER','341','4999'),('877','MEMBER','336','5057677'),('842','MEMBER','301','50882884'),('871','MEMBER','330','5094114'),('914','MEMBER','373','5101416'),('781','MEMBER','240','5106622'),('805','MEMBER','264','51269183'),('908','MEMBER','367','514564'),('967','MEMBER','426','53192'),('965','MEMBER','424','5367580'),('904','MEMBER','363','53771300'),('825','MEMBER','284','540542'),('827','MEMBER','286','54409794'),('786','MEMBER','245','5457873'),('791','MEMBER','250','5518092'),('816','MEMBER','275','5525292'),('868','MEMBER','327','555988'),('818','MEMBER','277','56772'),('884','MEMBER','343','57557'),('930','MEMBER','389','5822763'),('854','MEMBER','313','5850343'),('917','MEMBER','376','586634'),('909','MEMBER','368','59194'),('833','MEMBER','292','59308690'),('958','MEMBER','417','59641488'),('859','MEMBER','318','597330'),('892','MEMBER','351','59734213'),('881','MEMBER','340','621873'),('947','MEMBER','406','62273'),('907','MEMBER','366','626108'),('795','MEMBER','254','64468'),('792','MEMBER','251','6486201'),('823','MEMBER','282','6524191'),('766','MEMBER','225','65720'),('937','MEMBER','396','6624554'),('953','MEMBER','412','67320216'),('971','MEMBER','430','68059863'),('824','MEMBER','283','6825442'),('804','MEMBER','263','686878'),('906','MEMBER','365','6871287'),('889','MEMBER','348','6926705'),('865','MEMBER','324','6951482'),('835','MEMBER','294','69799978'),('783','MEMBER','242','7132530'),('951','MEMBER','410','71991'),('798','MEMBER','257','7275556'),('808','MEMBER','267','76177'),('948','MEMBER','407','771612'),('796','MEMBER','255','786559'),('803','MEMBER','262','7976985'),('848','MEMBER','307','809'),('855','MEMBER','314','8278737'),('919','MEMBER','378','83154997'),('772','MEMBER','231','83166711'),('957','MEMBER','416','83992953'),('934','MEMBER','393','85032'),('942','MEMBER','401','8606033'),('935','MEMBER','394','8655541'),('843','MEMBER','302','869595'),('768','MEMBER','227','888005'),('895','MEMBER','354','8901064'),('782','MEMBER','241','8947027'),('929','MEMBER','388','89561404'),('874','MEMBER','333','896444'),('841','MEMBER','300','9449321'),('969','MEMBER','428','9537642'),('858','MEMBER','317','97338583'),('876','MEMBER','335','9769526'),('762','MEMBER','221','97928'),('831','MEMBER','290','98340'),('931','MEMBER','390','988002'),('944','MEMBER','403','9890400'),('773','MEMBER','232','9904608'),('541','MEMBER','0','Afghanistan'),('758','MEMBER','217','Africa'),('542','MEMBER','1','Albania'),('543','MEMBER','2','Algeria'),('532','LEVEL','DT_SPACE_all_DT_SPACE','all_DT_SPACE'),('536','LEVEL','DT_TIME_all_DT_TIME','all_DT_TIME'),('755','MEMBER','214','America'),('544','MEMBER','3','Andorra'),('545','MEMBER','4','Angola'),('546','MEMBER','5','Anguilla'),('547','MEMBER','6','Antigua And Barbuda'),('548','MEMBER','7','Argentina'),('549','MEMBER','8','Armenia'),('550','MEMBER','9','Aruba'),('759','MEMBER','218','Asia'),('551','MEMBER','10','Australia'),('552','MEMBER','11','Austria'),('553','MEMBER','12','Azerbaijan'),('554','MEMBER','13','Bahamas'),('555','MEMBER','14','Bahrain'),('556','MEMBER','15','Bangladesh'),('557','MEMBER','16','Barbados'),('558','MEMBER','17','Belarus'),('559','MEMBER','18','Belgium'),('560','MEMBER','19','Belize'),('561','MEMBER','20','Benin'),('562','MEMBER','21','Bermuda'),('563','MEMBER','22','Bhutan'),('564','MEMBER','23','Bolivia'),('565','MEMBER','24','Bonaire, Saint Eustatius And Saba'),('566','MEMBER','25','Bosnia And Herzegovina'),('567','MEMBER','26','Botswana'),('568','MEMBER','27','Brazil'),('569','MEMBER','28','British Virgin Islands'),('570','MEMBER','29','Brunei Darussalam'),('571','MEMBER','30','Bulgaria'),('572','MEMBER','31','Burkina Faso'),('573','MEMBER','32','Burundi'),('574','MEMBER','33','Cambodia'),('575','MEMBER','34','Cameroon'),('576','MEMBER','35','Canada'),('577','MEMBER','36','Cape Verde'),('531','MEASURE','CASES','CASES'),('578','MEMBER','37','Cayman Islands'),('579','MEMBER','38','Central African Republic'),('580','MEMBER','39','Chad'),('581','MEMBER','40','Chile'),('582','MEMBER','41','China'),('583','MEMBER','42','Colombia'),('584','MEMBER','43','Comoros'),('585','MEMBER','44','Congo'),('534','LEVEL','DT_SPACE_CONTINENT','CONTINENT'),('586','MEMBER','45','Costa Rica'),('587','MEMBER','46','Cote Divoire'),('533','LEVEL','DT_SPACE_COUNTRY','COUNTRY'),('588','MEMBER','47','Croatia'),('589','MEMBER','48','Cuba'),('590','MEMBER','49','Curaçao'),('591','MEMBER','50','Cyprus'),('592','MEMBER','51','Czechia'),('530','MEASURE','DEATHS','DEATHS'),('593','MEMBER','52','Democratic Republic Of The Congo'),('594','MEMBER','53','Denmark'),('595','MEMBER','54','Djibouti'),('596','MEMBER','55','Dominica'),('597','MEMBER','56','Dominican Republic'),('598','MEMBER','57','Ecuador'),('599','MEMBER','58','Egypt'),('600','MEMBER','59','El Salvador'),('601','MEMBER','60','Equatorial Guinea'),('602','MEMBER','61','Eritrea'),('603','MEMBER','62','Estonia'),('604','MEMBER','63','Eswatini'),('605','MEMBER','64','Ethiopia'),('757','MEMBER','216','Europe'),('606','MEMBER','65','Falkland Islands (Malvinas)'),('607','MEMBER','66','Faroe Islands'),('608','MEMBER','67','Fiji'),('609','MEMBER','68','Finland'),('610','MEMBER','69','France'),('611','MEMBER','70','French Polynesia'),('540','FACT','FT','FT'),('612','MEMBER','71','Gabon'),('613','MEMBER','72','Gambia'),('614','MEMBER','73','Georgia'),('615','MEMBER','74','Germany'),('616','MEMBER','75','Ghana'),('617','MEMBER','76','Gibraltar'),('618','MEMBER','77','Greece'),('619','MEMBER','78','Greenland'),('620','MEMBER','79','Grenada'),('621','MEMBER','80','Guam'),('622','MEMBER','81','Guatemala'),('623','MEMBER','82','Guernsey'),('624','MEMBER','83','Guinea'),('625','MEMBER','84','Guinea Bissau'),('626','MEMBER','85','Guyana'),('627','MEMBER','86','Haiti'),('628','MEMBER','87','Holy See'),('629','MEMBER','88','Honduras'),('630','MEMBER','89','Hungary'),('631','MEMBER','90','Iceland'),('632','MEMBER','91','India'),('633','MEMBER','92','Indonesia'),('634','MEMBER','93','Iran'),('635','MEMBER','94','Iraq'),('636','MEMBER','95','Ireland'),('637','MEMBER','96','Isle Of Man'),('638','MEMBER','97','Israel'),('639','MEMBER','98','Italy'),('640','MEMBER','99','Jamaica'),('641','MEMBER','100','Japan'),('642','MEMBER','101','Jersey'),('643','MEMBER','102','Jordan'),('644','MEMBER','103','Kazakhstan'),('645','MEMBER','104','Kenya'),('646','MEMBER','105','Kosovo'),('647','MEMBER','106','Kuwait'),('648','MEMBER','107','Kyrgyzstan'),('649','MEMBER','108','Laos'),('650','MEMBER','109','Latvia'),('651','MEMBER','110','Lebanon'),('652','MEMBER','111','Lesotho'),('653','MEMBER','112','Liberia'),('654','MEMBER','113','Libya'),('655','MEMBER','114','Liechtenstein'),('656','MEMBER','115','Lithuania'),('657','MEMBER','116','Luxembourg'),('658','MEMBER','117','Madagascar'),('659','MEMBER','118','Malawi'),('660','MEMBER','119','Malaysia'),('661','MEMBER','120','Maldives'),('662','MEMBER','121','Mali'),('663','MEMBER','122','Malta'),('664','MEMBER','123','Marshall Islands'),('665','MEMBER','124','Mauritania'),('666','MEMBER','125','Mauritius'),('667','MEMBER','126','Mexico'),('668','MEMBER','127','Micronesia (Federated States Of)'),('669','MEMBER','128','Moldova'),('670','MEMBER','129','Monaco'),('671','MEMBER','130','Mongolia'),('672','MEMBER','131','Montenegro'),('539','LEVEL','DT_TIME_MONTH','MONTH'),('673','MEMBER','132','Montserrat'),('674','MEMBER','133','Morocco'),('675','MEMBER','134','Mozambique'),('676','MEMBER','135','Myanmar'),('677','MEMBER','136','Namibia'),('678','MEMBER','137','Nepal'),('679','MEMBER','138','Netherlands'),('680','MEMBER','139','New Caledonia'),('681','MEMBER','140','New Zealand'),('682','MEMBER','141','Nicaragua'),('683','MEMBER','142','Niger'),('684','MEMBER','143','Nigeria'),('685','MEMBER','144','North Macedonia'),('686','MEMBER','145','Northern Mariana Islands'),('687','MEMBER','146','Norway'),('756','MEMBER','215','Oceania'),('688','MEMBER','147','Oman'),('689','MEMBER','148','Pakistan'),('690','MEMBER','149','Palestine'),('691','MEMBER','150','Panama'),('692','MEMBER','151','Papua New Guinea'),('693','MEMBER','152','Paraguay'),('694','MEMBER','153','Peru'),('695','MEMBER','154','Philippines'),('696','MEMBER','155','Poland'),('535','LEVEL','DT_SPACE_POPULATION','POPULATION'),('697','MEMBER','156','Portugal'),('698','MEMBER','157','Puerto Rico'),('699','MEMBER','158','Qatar'),('700','MEMBER','159','Romania'),('701','MEMBER','160','Russia'),('702','MEMBER','161','Rwanda'),('703','MEMBER','162','Saint Kitts And Nevis'),('704','MEMBER','163','Saint Lucia'),('705','MEMBER','164','Saint Vincent And The Grenadines'),('706','MEMBER','165','San Marino'),('707','MEMBER','166','Sao Tome And Principe'),('708','MEMBER','167','Saudi Arabia'),('709','MEMBER','168','Senegal'),('710','MEMBER','169','Serbia'),('711','MEMBER','170','Seychelles'),('712','MEMBER','171','Sierra Leone'),('713','MEMBER','172','Singapore'),('714','MEMBER','173','Sint Maarten'),('715','MEMBER','174','Slovakia'),('716','MEMBER','175','Slovenia'),('717','MEMBER','176','Solomon Islands'),('718','MEMBER','177','Somalia'),('719','MEMBER','178','South Africa'),('720','MEMBER','179','South Korea'),('721','MEMBER','180','South Sudan'),('722','MEMBER','181','Spain'),('723','MEMBER','182','Sri Lanka'),('724','MEMBER','183','Sudan'),('725','MEMBER','184','Suriname'),('726','MEMBER','185','Sweden'),('727','MEMBER','186','Switzerland'),('728','MEMBER','187','Syria'),('729','MEMBER','188','Taiwan'),('730','MEMBER','189','Tajikistan'),('731','MEMBER','190','Thailand'),('732','MEMBER','191','Timor Leste'),('733','MEMBER','192','Togo'),('734','MEMBER','193','Trinidad And Tobago'),('735','MEMBER','194','Tunisia'),('736','MEMBER','195','Turkey'),('737','MEMBER','196','Turks And Caicos Islands'),('738','MEMBER','197','Uganda'),('739','MEMBER','198','Ukraine'),('740','MEMBER','199','United Arab Emirates'),('741','MEMBER','200','United Kingdom'),('742','MEMBER','201','United Republic Of Tanzania'),('743','MEMBER','202','United States Of America'),('744','MEMBER','203','United States Virgin Islands'),('745','MEMBER','204','Uruguay'),('746','MEMBER','205','Uzbekistan'),('747','MEMBER','206','Vanuatu'),('748','MEMBER','207','Venezuela'),('749','MEMBER','208','Vietnam'),('750','MEMBER','209','Wallis And Futuna'),('537','LEVEL','DT_TIME_WEEK','WEEK'),('751','MEMBER','210','Western Sahara'),('538','LEVEL','DT_TIME_YEAR','YEAR'),('752','MEMBER','211','Yemen'),('753','MEMBER','212','Zambia'),('754','MEMBER','213','Zimbabwe');
/*!40000 ALTER TABLE `SYNONYM` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `TABLE`
--

DROP TABLE IF EXISTS `TABLE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `TABLE` (
                         `table_id` varchar(255) NOT NULL,
                         `table_name` varchar(255) NOT NULL,
                         `table_type` varchar(255) NOT NULL,
                         `fact_id` varchar(255) DEFAULT NULL,
                         `hierarchy_id` varchar(255) DEFAULT NULL,
                         PRIMARY KEY (`table_id`),
                         UNIQUE KEY `table_name` (`table_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `TABLE`
--

LOCK TABLES `TABLE` WRITE;
/*!40000 ALTER TABLE `TABLE` DISABLE KEYS */;
INSERT INTO `TABLE` VALUES ('DT_SPACE','DT_SPACE','DT',NULL,'DT_SPACE'),('DT_TIME','DT_TIME','DT',NULL,'DT_TIME'),('FT','FT','FT','FT',NULL);
/*!40000 ALTER TABLE `TABLE` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2022-01-19 15:11:25
