-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `hogares`
--

-- --------------------------------------------------------

--
-- Table structure for table `hogares_acogida_documentos`
--

CREATE TABLE `hogares_acogida_documentos` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `hogares_nna_id` varchar(50) NOT NULL,
  `titulo_documentos` text NOT NULL,
  `documento` text NOT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `hogares_area_psicologica`
--

CREATE TABLE `hogares_area_psicologica` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `hogares_nna_id` varchar(50) NOT NULL,
  `evaluacion_psicologica_adjunto` varchar(200) NOT NULL,
  `diagnostico` text NOT NULL,
  `derivacion_terapia_id` smallint NOT NULL,
  `fecha_terapia` date DEFAULT NULL,
  `terapia` longtext,
  `seguimiento_id` smallint DEFAULT NULL,
  `coordinacion_interinstitucional` longtext,
  `vulneroderechos_id` smallint DEFAULT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `hogares_area_psicologica_documentos`
--

CREATE TABLE `hogares_area_psicologica_documentos` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `hogares_nna_id` varchar(50) NOT NULL,
  `titulo_documentos` text NOT NULL,
  `documento` text NOT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `hogares_area_psicologica_seguimiento`
--

CREATE TABLE `hogares_area_psicologica_seguimiento` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `hogares_nna_id` varchar(50) NOT NULL,
  `fecha_seguimiento` date NOT NULL,
  `seguimiento` longtext NOT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `hogares_area_social`
--

CREATE TABLE `hogares_area_social` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `hogares_nna_id` varchar(50) NOT NULL,
  `evaluacion_social_adjunto` varchar(200) NOT NULL,
  `evaluacion_texto` longtext,
  `coordinacion_interinstitucional` longtext,
  `proyecto_vida_id` smallint NOT NULL,
  `proyecto_vida_adjunto` varchar(200) DEFAULT NULL,
  `vulneroderechos_id` smallint NOT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `hogares_area_social_documentos`
--

CREATE TABLE `hogares_area_social_documentos` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `hogares_nna_id` varchar(50) NOT NULL,
  `titulo_documentos` text NOT NULL,
  `documento` text NOT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `hogares_area_social_seguimiento`
--

CREATE TABLE `hogares_area_social_seguimiento` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `hogares_nna_id` varchar(50) NOT NULL,
  `fecha_seguimiento` date NOT NULL,
  `seguimiento` longtext NOT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `hogares_bienes_nna`
--

CREATE TABLE `hogares_bienes_nna` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `hogares_nna_id` varchar(50) NOT NULL,
  `herencia_id` smallint NOT NULL,
  `detalle_herencia` longtext,
  `donacion_id` smallint NOT NULL,
  `detalles_donacion` longtext,
  `comentarios_herencia` longtext,
  `adjuntos` text,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `hogares_bienes_nna_documentos`
--

CREATE TABLE `hogares_bienes_nna_documentos` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `hogares_nna_id` varchar(50) NOT NULL,
  `titulo_documentos` text NOT NULL,
  `documento` text NOT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `hogares_caracteristicas_acogida`
--

CREATE TABLE `hogares_caracteristicas_acogida` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `hogares_nna_id` varchar(50) NOT NULL,
  `referido_por_id` smallint NOT NULL,
  `se_informo_nna_id` smallint NOT NULL,
  `orden_internacion_id` smallint NOT NULL,
  `numero_resolucion` varchar(75) DEFAULT NULL,
  `bienes` text NOT NULL,
  `adjuntos` text,
  `comentarios` text NOT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `hogares_caracteristicas_acogida_documentos`
--

CREATE TABLE `hogares_caracteristicas_acogida_documentos` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `hogares_nna_id` varchar(50) NOT NULL,
  `titulo_documentos` text NOT NULL,
  `documento` text NOT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `hogares_catalogs`
--

CREATE TABLE `hogares_catalogs` (
  `id` int NOT NULL,
  `code` varchar(50) NOT NULL,
  `description` varchar(512) NOT NULL,
  `catalog_code_dep` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `hogares_catalogs`
--

INSERT INTO `hogares_catalogs` (`id`, `code`, `description`, `catalog_code_dep`) VALUES
(1, 'CATALOGS', 'Catalogos generales', '0');

-- --------------------------------------------------------

--
-- Table structure for table `hogares_catalog_items`
--

CREATE TABLE `hogares_catalog_items` (
  `id` int NOT NULL,
  `catalogs_id` int NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `value` int NOT NULL,
  `label` varchar(250) NOT NULL,
  `lang` varchar(5) NOT NULL,
  `catalog_code` varchar(50) NOT NULL,
  `catalog_code_dep` varchar(50) NOT NULL,
  `catalog_id_dep` int NOT NULL,
  `description` varchar(512) NOT NULL,
  `svg_image` varchar(150) DEFAULT NULL,
  `status` varchar(2) NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `hogares_catalog_items`
--

INSERT INTO `hogares_catalog_items` (`id`, `catalogs_id`, `users_sid`, `value`, `label`, `lang`, `catalog_code`, `catalog_code_dep`, `catalog_id_dep`, `description`, `svg_image`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'GENERAL', 'es', 'GENERAL', '0', 0, 'Anuncio de empleos', NULL, 'A', '2020-06-06 15:09:12', '2020-06-06 15:09:12'),
(2, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'NIÑAS Y NIÑOS ADOLESCENTES', 'es', 'TIPOPOBLACION', '0', 0, 'NIÑAS Y NIÑOS ADOLESCENTES', NULL, 'A', '2021-01-31 10:38:33', '2021-01-31 10:44:15'),
(3, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'NIÑAS Y NIÑOS', 'es', 'TIPOPOBLACION', '0', 0, 'NIÑAS Y NIÑOS', NULL, 'A', '2021-01-31 10:40:55', '2021-01-31 10:40:55'),
(6, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 'NIÑOS ADOLESCENTES', 'es', 'TIPOPOBLACION', '0', 0, 'NIÑOS ADOLESCENTES', NULL, 'A', '2021-01-31 10:47:33', '2021-01-31 10:47:33'),
(7, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 4, 'NIÑAS ADOLESCENTES', 'es', 'TIPOPOBLACION', '0', 0, 'NIÑAS ADOLESCENTES', NULL, 'A', '2021-01-31 10:47:40', '2021-01-31 10:48:12'),
(8, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, '0-6', 'es', 'EDADESPOBLACION', '0', 0, '0-6', NULL, 'A', '2021-01-31 10:51:00', '2021-01-31 10:51:00'),
(9, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, '7-18', 'es', 'EDADESPOBLACION', '0', 0, '7-18', NULL, 'A', '2021-01-31 10:51:08', '2021-01-31 10:51:08'),
(10, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'BUENA', 'es', 'INFRAESTRUCTURA', '0', 0, 'BUENA', NULL, 'A', '2021-01-31 10:51:27', '2021-01-31 10:51:27'),
(11, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'EXCELENTE', 'es', 'INFRAESTRUCTURA', '0', 0, 'EXCELENTE', NULL, 'A', '2021-01-31 10:51:47', '2021-01-31 10:51:47'),
(12, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 'REGULAR', 'es', 'INFRAESTRUCTURA', '0', 0, 'REGULAR', NULL, 'A', '2021-01-31 10:51:55', '2021-01-31 10:51:55'),
(13, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 4, 'MALA', 'es', 'INFRAESTRUCTURA', '0', 0, 'MALA', NULL, 'A', '2021-01-31 10:52:06', '2021-01-31 10:52:06'),
(14, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 5, 'PESIMA', 'es', 'INFRAESTRUCTURA', '0', 0, 'PESIMA', NULL, 'A', '2021-01-31 10:52:13', '2021-01-31 10:52:13'),
(15, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'GOBIERNO DEPARTAMENTAL', 'es', 'TERRENOPERTENECE', '0', 0, 'GOBIERNO DEPARTAMENTAL', NULL, 'A', '2021-01-31 10:52:31', '2021-01-31 10:52:31'),
(16, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'GOBIERNO MUNICIPAL', 'es', 'TERRENOPERTENECE', '0', 0, 'GOBIERNO MUNICIPAL', NULL, 'A', '2021-01-31 10:52:40', '2021-01-31 10:52:40'),
(17, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 'IGLESIA', 'es', 'TERRENOPERTENECE', '0', 0, 'IGLESIA', NULL, 'A', '2021-01-31 10:52:47', '2021-01-31 10:52:47'),
(18, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'DIRECTOS', 'es', 'TIPOADMINISTRACION', '0', 0, 'DIRECTOS', NULL, 'A', '2021-01-31 10:53:04', '2021-01-31 10:53:04'),
(19, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'DELEGADOS', 'es', 'TIPOADMINISTRACION', '0', 0, 'DELEGADOS', NULL, 'A', '2021-01-31 10:53:10', '2021-01-31 10:53:10'),
(20, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'EN PROCESO', 'es', 'ACREDITACION', '0', 0, 'EN PROCESO', NULL, 'A', '2021-01-31 10:53:33', '2021-01-31 10:53:33'),
(21, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'ACREDITADOS', 'es', 'ACREDITACION', '0', 0, 'ACREDITADOS', NULL, 'A', '2021-01-31 10:53:41', '2021-01-31 10:53:41'),
(22, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 'NO ACREDITADOS', 'es', 'ACREDITACION', '0', 0, 'NO ACREDITADOS', NULL, 'A', '2021-01-31 10:53:47', '2021-01-31 10:53:47'),
(23, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'SI', 'es', 'SINO', '0', 0, 'SI', NULL, 'A', '2021-02-01 23:37:00', '2021-02-01 23:37:00'),
(24, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'NO', 'es', 'SINO', '0', 0, 'NO', NULL, 'A', '2021-02-01 23:37:07', '2021-02-01 23:37:07'),
(25, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'FEMENINO', 'es', 'SEXO', '0', 0, 'FEMENINO', NULL, 'A', '2021-02-01 23:47:18', '2021-02-01 23:47:18'),
(26, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'MASCULINO', 'es', 'SEXO', '0', 0, 'MASCULINO', NULL, 'A', '2021-02-01 23:47:25', '2021-02-01 23:47:25'),
(27, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'EN PROCESO', 'es', 'ESTADOSITUACIONLEGAL', '0', 0, 'EN PROCESO', NULL, 'A', '2021-02-04 09:33:46', '2021-02-04 09:33:46'),
(28, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'CULMINADO', 'es', 'ESTADOSITUACIONLEGAL', '0', 0, 'CULMINADO', NULL, 'A', '2021-02-04 09:33:53', '2021-02-04 09:33:53'),
(29, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 'APELACION', 'es', 'ESTADOSITUACIONLEGAL', '0', 0, 'APELACION', NULL, 'A', '2021-02-04 09:34:01', '2021-02-04 09:34:01'),
(30, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'ACOGIMIENTO', 'es', 'SITUACIONLEGALUNO', '0', 0, 'ACOGIMIENTO', NULL, 'A', '2021-02-04 09:35:15', '2021-02-04 09:35:15'),
(31, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'FILIACIÓN JUDICIAL', 'es', 'SITUACIONLEGALUNO', '0', 0, 'FILIACIÓN JUDICIAL', NULL, 'A', '2021-02-04 09:35:24', '2021-02-04 09:35:24'),
(32, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 'EN PROCESO DE EXTINCIÓN DE AUTORIDAD PATERNA Y/O MATERNA', 'es', 'SITUACIONLEGALUNO', '0', 0, 'EN PROCESO DE EXTINCIÓN DE AUTORIDAD PATERNA Y/O MATERNA', NULL, 'A', '2021-02-04 09:35:34', '2021-02-04 09:35:34'),
(33, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 4, 'EN PROCESO DE SUSPENSION DE AUTORIDAD TOTAL', 'es', 'SITUACIONLEGALUNO', '0', 0, 'EN PROCESO DE SUSPENSION DE AUTORIDAD TOTAL', NULL, 'A', '2021-02-04 09:35:47', '2021-02-04 09:35:47'),
(34, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 5, 'EN PROCESO DE SUSPENSION DE AUTORIDAD PARCIAL', 'es', 'SITUACIONLEGALUNO', '0', 0, 'EN PROCESO DE SUSPENSION DE AUTORIDAD PARCIAL', NULL, 'A', '2021-02-04 09:36:01', '2021-02-04 09:36:01'),
(35, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 6, 'EN PROCESO DE REINSERCIÓN FAMILIAR', 'es', 'SITUACIONLEGALUNO', '0', 0, 'EN PROCESO DE REINSERCIÓN FAMILIAR', NULL, 'A', '2021-02-04 09:36:10', '2021-02-04 09:36:10'),
(36, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 7, 'ORFANDAD ABSOLUTA', 'es', 'SITUACIONLEGALUNO', '0', 0, 'ORFANDAD ABSOLUTA', NULL, 'A', '2021-02-04 09:36:16', '2021-02-04 09:36:16'),
(37, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'ADOPCION NACIONAL', 'es', 'SITUACIONLEGALDOS', '0', 0, 'ADOPCION NACIONAL', NULL, 'A', '2021-02-04 09:36:29', '2021-02-04 09:36:29'),
(38, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'ADOPCION INTERNACIONAL', 'es', 'SITUACIONLEGALDOS', '0', 0, 'ADOPCION INTERNACIONAL', NULL, 'A', '2021-02-04 09:36:36', '2021-02-04 09:36:36'),
(39, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 'GUARDA', 'es', 'SITUACIONLEGALDOS', '0', 0, 'GUARDA', NULL, 'A', '2021-02-04 09:36:45', '2021-02-04 09:36:45'),
(40, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 4, 'TUTELA', 'es', 'SITUACIONLEGALDOS', '0', 0, 'TUTELA', NULL, 'A', '2021-02-04 09:36:56', '2021-02-04 09:36:56'),
(41, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'ASISTENCIA FAMILIAR', 'es', 'SITUACIONLEGALTRES', '0', 0, 'ASISTENCIA FAMILIAR', NULL, 'A', '2021-02-04 09:41:35', '2021-02-04 09:41:35'),
(42, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'ACOGIMIENTO CIRCUNSTANCIAL', 'es', 'SITUACIONLEGALTRES', '0', 0, 'ACOGIMIENTO CIRCUNSTANCIAL', NULL, 'A', '2021-02-04 09:41:52', '2021-02-04 09:41:52'),
(43, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'ABANDONO', 'es', 'MOTIVOACOGIDA', '0', 0, 'ABANDONO', NULL, 'A', '2021-02-07 21:38:02', '2021-02-07 21:38:02'),
(44, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'SITUACION DE RIESGO', 'es', 'MOTIVOACOGIDA', '0', 0, 'SITUACION DE RIESGO', NULL, 'A', '2021-02-07 21:38:18', '2021-02-07 21:38:18'),
(45, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 'MALTRATO FISICO Y PSICOLOGICO', 'es', 'MOTIVOACOGIDA', '0', 0, 'MALTRATO FISICO Y PSICOLOGICO', NULL, 'X', '2021-02-07 21:38:26', '2021-02-07 21:38:45'),
(46, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'NINGUNO', 'es', 'MALTRATOTIPO', '0', 0, 'NINGUNO', NULL, 'A', '2021-02-07 21:38:55', '2021-02-07 21:38:55'),
(47, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'MALTRATO FISICO Y PSICOLOGICO', 'es', 'MALTRATOTIPO', '0', 0, 'MALTRATO FISICO Y PSICOLOGICO', NULL, 'A', '2021-02-07 21:39:05', '2021-02-07 21:39:05'),
(48, 1, '05f6481f-c7f3-4cdf-8d07-a99d76ad3fb2', 3, 'MALTRATO POR NEGLIGENCIA', 'es', 'MALTRATOTIPO', '0', 0, 'MALTRATO POR NEGLIGENCIA', NULL, 'A', '2021-02-07 21:39:11', '2021-07-30 09:21:09'),
(49, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'SI', 'es', 'SINONOCORRESPONDE', '0', 0, 'SI', NULL, 'A', '2021-02-07 21:47:18', '2021-02-07 21:47:18'),
(50, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'NO', 'es', 'SINONOCORRESPONDE', '0', 0, 'NO', NULL, 'A', '2021-02-07 21:47:24', '2021-02-07 21:47:24'),
(51, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 'NO CORRESPONDE', 'es', 'SINONOCORRESPONDE', '0', 0, 'NO CORRESPONDE', NULL, 'A', '2021-02-07 21:47:37', '2021-02-07 21:47:37'),
(52, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'POLICIA', 'es', 'REFERIDOPOR', '0', 0, 'POLICIA', NULL, 'A', '2021-02-07 21:55:19', '2021-02-07 21:55:19'),
(53, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'FUNCIONARIO PUBLICO', 'es', 'REFERIDOPOR', '0', 0, 'FUNCIONARIO PUBLICO', NULL, 'A', '2021-02-07 21:55:29', '2021-02-07 21:55:29'),
(54, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 'VECINO', 'es', 'REFERIDOPOR', '0', 0, 'VECINO', NULL, 'A', '2021-02-07 21:55:35', '2021-02-07 21:55:35'),
(55, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 4, 'ESTABLECIMIENTO DE SALUD', 'es', 'REFERIDOPOR', '0', 0, 'ESTABLECIMIENTO DE SALUD', NULL, 'A', '2021-02-07 21:55:46', '2021-02-07 21:55:46'),
(56, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'NO QUISIERON', 'es', 'MOTIVONOPARTICIPACION', '0', 0, 'NO QUISIERON', NULL, 'A', '2021-02-07 22:29:08', '2021-02-07 22:29:08'),
(57, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'SON LOS INFRACTORES', 'es', 'MOTIVONOPARTICIPACION', '0', 0, 'SON LOS INFRACTORES', NULL, 'A', '2021-02-07 22:29:14', '2021-02-07 22:29:14'),
(58, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 'PADRES AUSENTES', 'es', 'MOTIVONOPARTICIPACION', '0', 0, 'PADRES AUSENTES', NULL, 'A', '2021-02-07 22:29:20', '2021-02-07 22:29:20'),
(59, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 4, 'FALLECIMIENTO DE LOS PADRES', 'es', 'MOTIVONOPARTICIPACION', '0', 0, 'FALLECIMIENTO DE LOS PADRES', NULL, 'A', '2021-02-07 22:29:27', '2021-02-07 22:29:27'),
(60, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 5, 'PADRES DISCAPACITADOS', 'es', 'MOTIVONOPARTICIPACION', '0', 0, 'PADRES DISCAPACITADOS', NULL, 'A', '2021-02-07 22:29:35', '2021-02-07 22:29:35'),
(61, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'FAMILIA DE ORIGEN', 'es', 'ANTESACOGIDAVIVIACON', '0', 0, 'FAMILIA DE ORIGEN', NULL, 'A', '2021-02-07 22:30:39', '2021-02-07 22:30:39'),
(62, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'FAMILIA AMPLIADA', 'es', 'ANTESACOGIDAVIVIACON', '0', 0, 'FAMILIA AMPLIADA', NULL, 'A', '2021-02-07 22:30:48', '2021-02-07 22:30:48'),
(63, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 'REFERENTE AFECTIVO', 'es', 'ANTESACOGIDAVIVIACON', '0', 0, 'REFERENTE AFECTIVO', NULL, 'A', '2021-02-07 22:30:54', '2021-02-07 22:30:54'),
(64, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 4, 'SITUACION DE CALLE', 'es', 'ANTESACOGIDAVIVIACON', '0', 0, 'SITUACION DE CALLE', NULL, 'A', '2021-02-07 22:31:00', '2021-02-07 22:31:00'),
(65, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 5, 'DESCONOCIDA', 'es', 'ANTESACOGIDAVIVIACON', '0', 0, 'DESCONOCIDA', NULL, 'A', '2021-02-07 22:31:05', '2021-02-07 22:31:05'),
(66, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'ABUSO', 'es', 'TIPODEDESPROTECCION', '0', 0, 'ABUSO', NULL, 'A', '2021-02-08 00:00:28', '2021-02-08 00:00:41'),
(67, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'ACCESO CARNAL', 'es', 'SITUACIONDEDESPROTECCION', '0', 0, 'ACCESO CARNAL', NULL, 'A', '2021-02-08 00:00:48', '2021-02-08 00:00:48'),
(68, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'BUENO', 'es', 'DESEMPENOESCOLAR', '0', 0, 'BUENO', NULL, 'A', '2021-02-08 04:43:32', '2021-02-08 04:43:32'),
(69, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'REGULAR', 'es', 'DESEMPENOESCOLAR', '0', 0, 'REGULAR', NULL, 'A', '2021-02-08 04:43:39', '2021-02-08 04:43:39'),
(70, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 'NECESITA APOYO', 'es', 'DESEMPENOESCOLAR', '0', 0, 'NECESITA APOYO', NULL, 'A', '2021-02-08 04:43:50', '2021-02-08 04:43:50'),
(71, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'REGULAR', 'es', 'ASISTENCIAESCOLAR', '0', 0, 'REGULAR', NULL, 'A', '2021-02-08 04:44:02', '2021-02-08 04:44:02'),
(72, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'FALTA CON FRECUENCIA', 'es', 'ASISTENCIAESCOLAR', '0', 0, 'FALTA CON FRECUENCIA', NULL, 'A', '2021-02-08 04:44:15', '2021-02-08 04:44:15'),
(73, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 'NO ASISTE', 'es', 'ASISTENCIAESCOLAR', '0', 0, 'NO ASISTE', NULL, 'A', '2021-02-08 04:44:22', '2021-02-08 04:44:22'),
(74, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'ADOPCION', 'es', 'MOTIVOSALIDA', '0', 0, 'ADOPCION', NULL, 'A', '2021-02-08 05:13:53', '2021-02-08 05:13:53'),
(75, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'GUARDA', 'es', 'MOTIVOSALIDA', '0', 0, 'GUARDA', NULL, 'A', '2021-02-08 05:14:02', '2021-02-08 05:14:02'),
(76, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 'TUTELA', 'es', 'MOTIVOSALIDA', '0', 0, 'TUTELA', NULL, 'A', '2021-02-08 05:14:09', '2021-02-08 05:14:09'),
(77, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 4, 'REINTEGRACION', 'es', 'MOTIVOSALIDA', '0', 0, 'REINTEGRACION', NULL, 'A', '2021-02-08 05:14:16', '2021-02-08 05:14:16'),
(78, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 5, 'SE DESCONOCE', 'es', 'MOTIVOSALIDA', '0', 0, 'SE DESCONOCE', NULL, 'A', '2021-02-08 05:14:24', '2021-02-08 05:14:24'),
(79, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'PATERNA', 'es', 'LINEAPATERNAMATERNA', '0', 0, 'PATERNA', NULL, 'A', '2021-02-08 05:31:45', '2021-02-08 05:31:45'),
(80, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'MATERNA', 'es', 'LINEAPATERNAMATERNA', '0', 0, 'MATERNA', NULL, 'A', '2021-02-08 05:31:51', '2021-02-08 05:31:51'),
(81, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'SOLTERO(A)', 'es', 'ESTADOCIVIL', '0', 0, 'SOLTERO(A)', NULL, 'A', '2021-02-08 05:32:02', '2021-02-08 05:32:26'),
(82, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'CASADO(A)', 'es', 'ESTADOCIVIL', '0', 0, 'CASADO(A)', NULL, 'A', '2021-02-08 05:32:07', '2021-02-08 05:32:34'),
(83, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 'VIUDO(A)', 'es', 'ESTADOCIVIL', '0', 0, 'VIUDO(A)', NULL, 'A', '2021-02-08 05:32:15', '2021-02-08 05:32:43'),
(84, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 4, 'DIVORCIADO(A)', 'es', 'ESTADOCIVIL', '0', 0, 'DIVORCIADO(A)', NULL, 'A', '2021-02-08 05:32:55', '2021-02-08 05:32:55'),
(85, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'LE INTERESA MANTENER CONTACTO', 'es', 'OPINIONDELNNA', '0', 0, 'LE INTERESA MANTENER CONTACTO', NULL, 'A', '2021-02-08 05:33:21', '2021-02-08 05:33:21'),
(86, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'NO LE INTERESA MANTENER CONTACTO', 'es', 'OPINIONDELNNA', '0', 0, 'NO LE INTERESA MANTENER CONTACTO', NULL, 'A', '2021-02-08 05:33:27', '2021-02-08 05:33:27'),
(87, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'CADA DIA', 'es', 'FRECUENCIADECONTACTO', '0', 0, 'CADA DIA', NULL, 'A', '2021-02-08 05:33:37', '2021-02-08 05:33:37'),
(88, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'MAS DE DOS VECES POR SEMANA', 'es', 'FRECUENCIADECONTACTO', '0', 0, 'MAS DE DOS VECES POR SEMANA', NULL, 'A', '2021-02-08 05:33:52', '2021-02-08 05:33:52'),
(89, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 'UNA VEZ POR SEMANA', 'es', 'FRECUENCIADECONTACTO', '0', 0, 'UNA VEZ POR SEMANA', NULL, 'A', '2021-02-08 05:34:05', '2021-02-08 05:34:05'),
(90, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 4, 'UNA VEZ CADA QUINCE DIAS', 'es', 'FRECUENCIADECONTACTO', '0', 0, 'UNA VEZ CADA QUINCE DIAS', NULL, 'A', '2021-02-08 05:34:14', '2021-02-08 05:34:14'),
(91, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 5, 'UNA VEZ AL MES', 'es', 'FRECUENCIADECONTACTO', '0', 0, 'UNA VEZ AL MES', NULL, 'A', '2021-02-08 05:34:28', '2021-02-08 05:34:28'),
(92, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 6, 'DE MANERA VIRTUAL', 'es', 'FRECUENCIADECONTACTO', '0', 0, 'DE MANERA VIRTUAL', NULL, 'A', '2021-02-08 05:34:42', '2021-02-08 05:34:42'),
(93, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'ABUELO(A)', 'es', 'TIPOREFERENTEAFECTIVO', '0', 0, 'ABUELO(A)', NULL, 'A', '2021-02-08 05:35:04', '2021-03-22 09:11:19'),
(94, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'MUY BAJO', 'es', 'NIVELPUNTUACION', '0', 0, 'MUY BAJO', NULL, 'A', '2021-02-12 06:45:25', '2021-02-12 06:45:25'),
(95, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'BAJO', 'es', 'NIVELPUNTUACION', '0', 0, 'BAJO', NULL, 'A', '2021-02-12 06:45:31', '2021-02-12 06:45:31'),
(96, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 'MEDIO', 'es', 'NIVELPUNTUACION', '0', 0, 'MEDIO', NULL, 'A', '2021-02-12 06:45:39', '2021-02-12 06:45:39'),
(97, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 4, 'ALTO', 'es', 'NIVELPUNTUACION', '0', 0, 'ALTO', NULL, 'A', '2021-02-12 06:45:45', '2021-02-12 06:45:45'),
(98, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'PRESENCIAL', 'es', 'DETALLESFRECUENCIACONTACTO', '0', 0, 'PRESENCIAl', NULL, 'A', '2021-02-12 08:31:54', '2021-02-12 08:31:54'),
(99, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'ONLINE', 'es', 'DETALLESFRECUENCIACONTACTO', '0', 0, 'ONLINE', NULL, 'A', '2021-02-12 08:32:00', '2021-02-12 08:32:00'),
(100, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'MONOPARENTAL', 'es', 'TIPODEFAMILIA', '0', 0, 'MONOPARENTAL', NULL, 'A', '2021-02-12 19:29:36', '2021-02-12 19:29:36'),
(101, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'AMPLIADA', 'es', 'TIPODEFAMILIA', '0', 0, 'AMPLIADA', NULL, 'A', '2021-02-12 19:29:44', '2021-02-12 19:29:44'),
(102, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 'AGLUTINADA', 'es', 'TIPODEFAMILIA', '0', 0, 'AGLUTINADA', NULL, 'A', '2021-02-12 19:29:51', '2021-02-12 19:29:51'),
(103, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 4, 'MULTIPROBLEMATICA', 'es', 'TIPODEFAMILIA', '0', 0, 'MULTIPROBLEMATICA', NULL, 'A', '2021-02-12 19:30:10', '2021-02-12 19:30:10'),
(104, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 5, 'RECONSTITUIDA', 'es', 'TIPODEFAMILIA', '0', 0, 'RECONSTITUIDA', NULL, 'A', '2021-02-12 19:30:21', '2021-02-12 19:30:21'),
(105, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 6, 'NUCLEAR', 'es', 'TIPODEFAMILIA', '0', 0, 'NUCLEAR', NULL, 'A', '2021-02-12 19:30:28', '2021-02-12 19:30:28'),
(106, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 7, 'OTROS', 'es', 'TIPODEFAMILIA', '0', 0, 'OTROS', NULL, 'A', '2021-02-12 19:30:33', '2021-02-12 19:30:33'),
(107, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, '1. CONDICIONES ADECUADAS PORQUE CUENTA CON 4 SERVICIOS BASICOS', 'es', 'CONDICIONESVIDASOCIOECONOMICAS', '0', 0, '1. CONDICIONES ADECUADAS PORQUE CUENTA CON 4 SERVICIOS BASICOS', NULL, 'A', '2021-02-13 10:03:48', '2021-02-13 10:04:33'),
(108, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, '2. CONDICIONES MEDIANAMENTE ADECUADAS PORQUE CUENTA CON 2 SERVICIOS BASICOS', 'es', 'CONDICIONESVIDASOCIOECONOMICAS', '0', 0, '2. CONDICIONES MEDIANAMENTE ADECUADAS PORQUE CUENTA CON 2 SERVICIOS BASICOS', NULL, 'A', '2021-02-13 10:03:55', '2021-02-13 10:04:43'),
(109, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, '3. CON CONDICIONES INFERIORES PORQUE SOLO CUENTA CON 1 SERVICIO BASICO', 'es', 'CONDICIONESVIDASOCIOECONOMICAS', '0', 0, '3. CON CONDICIONES INFERIORES PORQUE SOLO CUENTA CON 1 SERVICIO BASICO', NULL, 'A', '2021-02-13 10:04:02', '2021-02-13 10:04:55'),
(110, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 4, '4. NO VIVE CON CONDICIONES ADECUADAS, PORQUE NO CUENTA CON NINGUN SERVICIO BASICO', 'es', 'CONDICIONESVIDASOCIOECONOMICAS', '0', 0, '4. NO VIVE CON CONDICIONES ADECUADAS, PORQUE NO CUENTA CON NINGUN SERVICIO BASICO', NULL, 'A', '2021-02-13 10:04:13', '2021-02-13 10:05:04'),
(111, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, '1. VIVE EN LUGAR SEGURO Y NO TIENE RIESGO DE PERDER LA RESIDENCIA', 'es', 'ESTABILIDADVIVIENDA', '0', 0, '1. VIVE EN LUGAR SEGURO Y NO TIENE RIESGO DE PERDER LA RESIDENCIA', NULL, 'A', '2021-02-13 10:05:25', '2021-02-13 10:05:25'),
(112, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, '2. VIVE EN UN LUGAR ESTABLE, PERO TIENE CIERTO RIESGO DE PERDER LA VIVIENDA', 'es', 'ESTABILIDADVIVIENDA', '0', 0, '2. VIVE EN UN LUGAR ESTABLE, PERO TIENE CIERTO RIESGO DE PERDER LA VIVIENDA', NULL, 'A', '2021-02-13 10:05:34', '2021-02-13 10:05:34'),
(113, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, '3. VIVE EN UN LUGAR INESTABLE CON RIESGO DE PERDER LA VIVIENDA', 'es', 'ESTABILIDADVIVIENDA', '0', 0, '3. VIVE EN UN LUGAR INESTABLE CON RIESGO DE PERDER LA VIVIENDA', NULL, 'A', '2021-02-13 10:05:45', '2021-02-13 10:05:45'),
(114, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 4, '4. NO TIENE VIVIENDA O VIVE EN UN REFUGIO', 'es', 'ESTABILIDADVIVIENDA', '0', 0, '4. NO TIENE VIVIENDA O VIVE EN UN REFUGIO', NULL, 'A', '2021-02-13 10:05:55', '2021-02-13 10:05:55'),
(115, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, '1.  ES SUFICIENTE Y ESTABLE', 'es', 'INGRESOECONOMICO', '0', 0, '1.  ES SUFICIENTE Y ESTABLE', NULL, 'A', '2021-02-13 10:06:14', '2021-02-13 10:06:14'),
(116, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, '2. ES SUFICIENTE PERO NO ESTABLE', 'es', 'INGRESOECONOMICO', '0', 0, '2. ES SUFICIENTE PERO NO ESTABLE', NULL, 'A', '2021-02-13 10:06:32', '2021-02-13 10:06:32'),
(117, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, '3.  ES ESTABLE PERO NO SUFICIENTE', 'es', 'INGRESOECONOMICO', '0', 0, '3.  ES ESTABLE PERO NO SUFICIENTE', NULL, 'A', '2021-02-13 10:06:40', '2021-02-13 10:06:40'),
(118, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 4, '4. NO ES ESTABLE NI SUFICIENTE', 'es', 'INGRESOECONOMICO', '0', 0, '4. NO ES ESTABLE NI SUFICIENTE', NULL, 'A', '2021-02-13 10:06:50', '2021-02-13 10:06:50'),
(119, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, '0 A 500', 'es', 'CANTIDADINGRESO', '0', 0, '0 A 500', NULL, 'A', '2021-02-13 10:07:10', '2021-02-13 10:07:10'),
(120, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, '501 A 1000', 'es', 'CANTIDADINGRESO', '0', 0, '501 A 1000', NULL, 'A', '2021-02-13 10:07:16', '2021-02-13 10:07:16'),
(121, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, '1001 A 2000', 'es', 'CANTIDADINGRESO', '0', 0, '1001 A 2000', NULL, 'A', '2021-02-13 10:07:22', '2021-02-13 10:07:22'),
(122, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 4, 'MAS DE 2000', 'es', 'CANTIDADINGRESO', '0', 0, 'MAS DE 2000', NULL, 'A', '2021-02-13 10:07:27', '2021-02-13 10:07:27'),
(123, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, '1. ALQUILADA', 'es', 'TIPOVIVIENDA', '0', 0, '1. ALQUILADA', NULL, 'A', '2021-02-13 10:07:48', '2021-02-13 10:07:48'),
(124, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, '2. NO TIENE CASA', 'es', 'TIPOVIVIENDA', '0', 0, '2.  NO TIENE CASA', NULL, 'A', '2021-02-13 10:07:59', '2021-02-13 10:07:59'),
(125, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, '3. TIENE CASA PROPIA Y SIN DEUDA', 'es', 'TIPOVIVIENDA', '0', 0, '3. TIENE CASA PROPIA Y SIN DEUDA', NULL, 'A', '2021-02-13 10:08:08', '2021-02-13 10:08:08'),
(126, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 4, '4. TIENE CASA PROPIA CON DEUDA', 'es', 'TIPOVIVIENDA', '0', 0, '4. TIENE CASA PROPIA CON DEUDA', NULL, 'A', '2021-02-13 10:08:19', '2021-02-13 10:08:19'),
(127, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 5, '5. EXCENTO DE ALQUILER', 'es', 'TIPOVIVIENDA', '0', 0, '5. EXCENTO DE ALQUILER', NULL, 'A', '2021-02-13 10:08:31', '2021-02-13 10:08:31'),
(128, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 6, '6. COMPARTE ALQUILER', 'es', 'TIPOVIVIENDA', '0', 0, '6. COMPARTE ALQUILER', NULL, 'A', '2021-02-13 10:08:42', '2021-02-13 10:08:42'),
(129, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 7, '7. VIVE EN ASENTAMIENTO', 'es', 'TIPOVIVIENDA', '0', 0, '7. VIVE EN ASENTAMIENTO', NULL, 'A', '2021-02-13 10:08:51', '2021-02-13 10:08:51'),
(130, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 8, '8. ANTICRETICO.', 'es', 'TIPOVIVIENDA', '0', 0, '8. ANTICRETICO.', NULL, 'A', '2021-02-13 10:09:00', '2021-02-13 10:09:00'),
(131, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'DNA', 'es', 'RESPONSABLESEGUIMIENTO', '0', 0, 'DNA', NULL, 'A', '2021-02-13 11:14:48', '2021-02-13 11:14:48'),
(132, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'CENTRO DE ACOGIDA', 'es', 'RESPONSABLESEGUIMIENTO', '0', 0, 'CENTRO DE ACOGIDA', NULL, 'A', '2021-02-13 11:14:56', '2021-02-13 11:14:56'),
(133, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 'DNA Y CENTRO DE ACOGIDA', 'es', 'RESPONSABLESEGUIMIENTO', '0', 0, 'DNA Y CENTRO DE ACOGIDA', NULL, 'A', '2021-02-13 11:15:02', '2021-03-30 14:29:03'),
(134, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'TIO(A)', 'es', 'TIPOREFERENTEAFECTIVO', '0', 0, 'TIO(A)', NULL, 'A', '2021-03-22 09:11:31', '2021-03-22 09:11:31'),
(135, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 'NO FAMILIAR', 'es', 'TIPOREFERENTEAFECTIVO', '0', 0, 'NO FAMILIAR', NULL, 'A', '2021-03-22 09:12:27', '2021-03-22 09:12:27'),
(136, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 'NINGUNA', 'es', 'LINEAPATERNAMATERNA', '0', 0, 'NINGUNA', NULL, 'A', '2021-03-22 09:13:01', '2021-03-22 09:13:01'),
(137, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 4, 'PRIMO(A)', 'es', 'TIPOREFERENTEAFECTIVO', '0', 0, 'PRIMO(A)', NULL, 'A', '2021-03-22 09:13:38', '2021-03-22 09:13:38'),
(138, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 5, 'CUÑADO(A)', 'es', 'TIPOREFERENTEAFECTIVO', '0', 0, 'CUÑADO(A)', NULL, 'A', '2021-03-22 09:13:48', '2021-03-22 09:13:48'),
(139, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'CASTELLANO', 'es', 'IDIOMAS', '0', 0, 'Castellano', NULL, 'A', '2021-03-28 22:08:27', '2021-03-28 22:08:27'),
(140, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'AYMARA', 'es', 'IDIOMAS', '0', 0, 'aymara', NULL, 'A', '2021-03-28 22:08:40', '2021-03-28 22:08:40'),
(141, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 'ARAONA', 'es', 'IDIOMAS', '0', 0, 'araona', NULL, 'A', '2021-03-28 22:08:47', '2021-03-28 22:08:47'),
(142, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 4, 'BAURE', 'es', 'IDIOMAS', '0', 0, 'baure', NULL, 'A', '2021-03-28 22:08:55', '2021-03-28 22:08:55'),
(143, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 5, 'BÉSIRO', 'es', 'IDIOMAS', '0', 0, 'bésiro', NULL, 'A', '2021-03-28 22:09:02', '2021-03-28 22:09:02'),
(144, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 6, 'CANICHANA', 'es', 'IDIOMAS', '0', 0, 'canichana', NULL, 'A', '2021-03-28 22:09:08', '2021-03-28 22:09:08'),
(145, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 7, 'CAVINEÑO', 'es', 'IDIOMAS', '0', 0, 'cavineño', NULL, 'A', '2021-03-28 22:09:15', '2021-03-28 22:09:15'),
(146, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 8, 'CAYUBABA', 'es', 'IDIOMAS', '0', 0, 'cayubaba', NULL, 'A', '2021-03-28 22:09:20', '2021-03-28 22:09:20'),
(147, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 9, 'CHÁCOBO', 'es', 'IDIOMAS', '0', 0, 'chácobo', NULL, 'A', '2021-03-28 22:09:26', '2021-03-28 22:09:26'),
(148, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 10, 'CHIMÁN', 'es', 'IDIOMAS', '0', 0, 'chimán', NULL, 'A', '2021-03-28 22:09:30', '2021-03-28 22:09:30'),
(149, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 11, 'ESE EJJA', 'es', 'IDIOMAS', '0', 0, 'ese ejja', NULL, 'A', '2021-03-28 22:09:39', '2021-03-28 22:09:39'),
(150, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 12, 'GUARANÍ', 'es', 'IDIOMAS', '0', 0, 'guaraní', NULL, 'A', '2021-03-28 22:09:43', '2021-03-28 22:09:43'),
(151, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 13, 'GUARASU’WE', 'es', 'IDIOMAS', '0', 0, 'guarasu’we', NULL, 'A', '2021-03-28 22:09:48', '2021-03-28 22:09:48'),
(152, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 14, 'GUARAYU', 'es', 'IDIOMAS', '0', 0, 'guarayu', NULL, 'A', '2021-03-28 22:09:52', '2021-03-28 22:09:52'),
(153, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 15, 'ITONAMA', 'es', 'IDIOMAS', '0', 0, 'itonama', NULL, 'A', '2021-03-28 22:09:57', '2021-03-28 22:09:57'),
(154, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 16, 'LECO', 'es', 'IDIOMAS', '0', 0, 'leco', NULL, 'A', '2021-03-28 22:10:01', '2021-03-28 22:10:01'),
(155, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 17, 'MACHAJUYAI-KALLAWAYA', 'es', 'IDIOMAS', '0', 0, 'machajuyai-kallawaya', NULL, 'A', '2021-03-28 22:10:09', '2021-03-28 22:10:09'),
(156, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 18, 'MACHINERI', 'es', 'IDIOMAS', '0', 0, 'machineri', NULL, 'A', '2021-03-28 22:10:14', '2021-03-28 22:10:14'),
(157, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 19, 'MAROPA', 'es', 'IDIOMAS', '0', 0, 'maropa', NULL, 'A', '2021-03-28 22:10:20', '2021-03-28 22:10:20'),
(158, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 20, 'MOJEÑO-TRINITARIO', 'es', 'IDIOMAS', '0', 0, 'mojeño-trinitario', NULL, 'A', '2021-03-28 22:10:26', '2021-03-28 22:10:26'),
(159, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 21, 'MOJEÑO-IGNACIANO', 'es', 'IDIOMAS', '0', 0, 'mojeño-ignaciano', NULL, 'A', '2021-03-28 22:10:32', '2021-03-28 22:10:32'),
(160, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 22, 'MORÉ', 'es', 'IDIOMAS', '0', 0, 'moré', NULL, 'A', '2021-03-28 22:10:39', '2021-03-28 22:10:39'),
(161, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 23, 'MOSETÉN', 'es', 'IDIOMAS', '0', 0, 'mosetén', NULL, 'A', '2021-03-28 22:10:43', '2021-03-28 22:10:43'),
(162, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 24, 'MOVIMA', 'es', 'IDIOMAS', '0', 0, 'movima', NULL, 'A', '2021-03-28 22:10:48', '2021-03-28 22:10:48'),
(163, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 25, 'PACAWARA', 'es', 'IDIOMAS', '0', 0, 'pacawara', NULL, 'A', '2021-03-28 22:10:54', '2021-03-28 22:10:54'),
(164, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 26, 'PUQUINA', 'es', 'IDIOMAS', '0', 0, 'puquina', NULL, 'A', '2021-03-28 22:10:59', '2021-03-28 22:10:59'),
(165, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 27, 'QUECHUA', 'es', 'IDIOMAS', '0', 0, 'quechua', NULL, 'A', '2021-03-28 22:11:05', '2021-03-28 22:11:05'),
(166, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 28, 'SIRIONÓ', 'es', 'IDIOMAS', '0', 0, 'sirionó', NULL, 'A', '2021-03-28 22:11:09', '2021-03-28 22:11:09'),
(167, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 29, 'TACANA', 'es', 'IDIOMAS', '0', 0, 'tacana', NULL, 'A', '2021-03-28 22:11:14', '2021-03-28 22:11:14'),
(168, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 30, 'TAPIETE', 'es', 'IDIOMAS', '0', 0, 'tapiete', NULL, 'A', '2021-03-28 22:11:18', '2021-03-28 22:11:18'),
(169, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 31, 'TOROMONA', 'es', 'IDIOMAS', '0', 0, 'toromona', NULL, 'A', '2021-03-28 22:11:23', '2021-03-28 22:11:23'),
(170, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 32, 'URU-CHIPAYA', 'es', 'IDIOMAS', '0', 0, 'uru-chipaya', NULL, 'A', '2021-03-28 22:11:29', '2021-03-28 22:11:29'),
(171, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 33, 'WEENHAYEK', 'es', 'IDIOMAS', '0', 0, 'weenhayek', NULL, 'A', '2021-03-28 22:11:32', '2021-03-28 22:11:32'),
(172, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 34, 'YAMINAWA', 'es', 'IDIOMAS', '0', 0, 'yaminawa', NULL, 'A', '2021-03-28 22:11:38', '2021-03-28 22:11:38'),
(173, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 35, 'YUKI', 'es', 'IDIOMAS', '0', 0, 'yuki', NULL, 'A', '2021-03-28 22:11:42', '2021-03-28 22:11:42'),
(174, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 36, 'YURACARÉ', 'es', 'IDIOMAS', '0', 0, 'yuracaré', NULL, 'A', '2021-03-28 22:11:47', '2021-03-28 22:11:47'),
(175, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 37, 'ZAMUCO', 'es', 'IDIOMAS', '0', 0, 'zamuco', NULL, 'A', '2021-03-28 22:11:53', '2021-03-28 22:11:53'),
(176, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'ASISTENCIA FAMILIAR', 'es', 'TIPOLOGIA', '0', 0, 'ASISTENCIA FAMILIAR', NULL, 'A', '2021-03-29 06:26:21', '2021-03-29 06:26:21'),
(177, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'SUSPENSION DE LA AUTORIDAD MATERNA, PATERNA O DE AMBOS', 'es', 'TIPOLOGIA', '0', 0, 'SUSPENSION DE LA AUTORIDAD MATERNA, PATERNA O DE AMBOS', NULL, 'A', '2021-03-29 06:26:29', '2021-03-29 06:26:29'),
(178, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 'EXTINCION DE LA AUTORIDAD MATERNA, PATERNA O DE AMBOS', 'es', 'TIPOLOGIA', '0', 0, 'EXTINCION DE LA AUTORIDAD MATERNA, PATERNA O DE AMBOS', NULL, 'A', '2021-03-29 06:26:44', '2021-03-29 06:26:44'),
(179, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 4, 'EXTINCION DE LA AUTORIDAD MATERNA, PATERNA O DE AMBOS POR RENUNCIA PARA ADOPCION', 'es', 'TIPOLOGIA', '0', 0, 'EXTINCION DE LA AUTORIDAD MATERNA, PATERNA O DE AMBOS POR RENUNCIA PARA ADOPCION', NULL, 'A', '2021-03-29 06:26:50', '2021-05-15 19:45:23'),
(180, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 5, 'GUARDA', 'es', 'TIPOLOGIA', '0', 0, 'GUARDA', NULL, 'A', '2021-03-29 06:26:57', '2021-03-29 06:26:57'),
(181, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 6, 'TUTELA', 'es', 'TIPOLOGIA', '0', 0, 'TUTELA', NULL, 'A', '2021-03-29 06:27:02', '2021-03-29 06:27:02'),
(182, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 7, 'ABANDONO DE NNA', 'es', 'TIPOLOGIA', '0', 0, 'ABANDONO DE NNA', NULL, 'A', '2021-03-29 06:27:08', '2021-03-29 06:27:08'),
(183, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 8, 'EXTRAVIO', 'es', 'TIPOLOGIA', '0', 0, 'EXTRAVIO', NULL, 'A', '2021-03-29 06:27:14', '2021-03-29 06:27:14'),
(184, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 9, 'IMPOSIBILIDAD DE DEBERES POR CAUSA AJENA', 'es', 'TIPOLOGIA', '0', 0, 'IMPOSIBILIDAD DE DEBERES POR CAUSA AJENA', NULL, 'A', '2021-03-29 06:27:19', '2021-03-29 06:27:19'),
(185, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 10, 'ORFANDAD ABSOLUTA', 'es', 'TIPOLOGIA', '0', 0, 'ORFANDAD ABSOLUTA', NULL, 'A', '2021-03-29 06:27:26', '2021-03-29 06:27:26'),
(186, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 11, 'ACOGIMIENTO CIRCUNSTANCIAL', 'es', 'TIPOLOGIA', '0', 0, 'ACOGIMIENTO CIRCUNSTANCIAL', NULL, 'A', '2021-03-29 06:27:32', '2021-03-29 06:27:32'),
(187, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 12, 'AUSENCIA DE RECONOCIMIENTO DE FILIACION', 'es', 'TIPOLOGIA', '0', 0, 'AUSENCIA DE RECONOCIMIENTO DE FILIACION', NULL, 'A', '2021-03-29 06:27:40', '2021-03-29 06:27:40'),
(188, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 13, 'FILIACION JUDICIAL', 'es', 'TIPOLOGIA', '0', 0, 'FILIACION JUDICIAL', NULL, 'A', '2021-03-29 06:27:45', '2021-03-29 06:27:45'),
(189, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 14, 'NACIONALIDAD', 'es', 'TIPOLOGIA', '0', 0, 'NACIONALIDAD', NULL, 'A', '2021-03-29 06:27:50', '2021-03-29 06:27:50'),
(190, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 15, 'VIOLENCIA FISICA', 'es', 'TIPOLOGIA', '0', 0, 'VIOLENCIA FISICA', NULL, 'A', '2021-03-29 06:27:55', '2021-03-29 06:27:55'),
(191, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 16, 'VIOLENCIA PSICOLOGICA', 'es', 'TIPOLOGIA', '0', 0, 'VIOLENCIA PSICOLOGICA', NULL, 'A', '2021-03-29 06:28:00', '2021-03-29 06:28:00'),
(192, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 17, 'VIOLENCIA EN EL SISTEMA EDUCATIVO (PARES Y NO PARES, BULLING,CIBERBULLING, ETC, NO EXCLUYENTE EN OTRAS TIPOLOGIAS)', 'es', 'TIPOLOGIA', '0', 0, 'VIOLENCIA EN EL SISTEMA EDUCATIVO (PARES Y NO PARES, BULLING,CIBERBULLING, ETC, NO EXCLUYENTE EN OTRAS TIPOLOGIAS)', NULL, 'A', '2021-03-29 06:28:07', '2021-03-29 06:28:07'),
(193, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 18, 'SOMETIMIENTO A CASTIGO', 'es', 'TIPOLOGIA', '0', 0, 'SOMETIMIENTO A CASTIGO', NULL, 'A', '2021-03-29 06:28:12', '2021-03-29 06:28:12'),
(194, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 19, 'ABANDONO EMOCIONAL O PSICO-AFECTIVO', 'es', 'TIPOLOGIA', '0', 0, 'ABANDONO EMOCIONAL O PSICO-AFECTIVO', NULL, 'A', '2021-03-29 06:28:17', '2021-03-29 06:28:17'),
(195, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 20, 'FALTA DE PROVISION ADECUADA Y OPORTUNA', 'es', 'TIPOLOGIA', '0', 0, 'FALTA DE PROVISION ADECUADA Y OPORTUNA', NULL, 'A', '2021-03-29 06:28:24', '2021-03-29 06:28:24'),
(196, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 21, 'UTILIZACION DE NNA EN CONFLICTOS FAMILIARES', 'es', 'TIPOLOGIA', '0', 0, 'UTILIZACION DE NNA EN CONFLICTOS FAMILIARES', NULL, 'A', '2021-03-29 06:28:30', '2021-03-29 06:28:30'),
(197, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 22, 'UTILIZACION DE NNA EN MEDIDAS DE HECHO', 'es', 'TIPOLOGIA', '0', 0, 'UTILIZACION DE NNA EN MEDIDAS DE HECHO', NULL, 'A', '2021-03-29 06:28:34', '2021-03-29 06:28:34'),
(198, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 23, 'INDUCCION A NNA AL CONSUMO DE SUBSTANCIAS DANIÑAS A SU SALUD', 'es', 'TIPOLOGIA', '0', 0, 'INDUCCION A NNA AL CONSUMO DE SUBSTANCIAS DANIÑAS A SU SALUD', NULL, 'A', '2021-03-29 06:28:39', '2021-03-29 06:28:39'),
(199, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 24, 'TRASLADO Y RETENCION ARBITRARIA DE NNA', 'es', 'TIPOLOGIA', '0', 0, 'TRASLADO Y RETENCION ARBITRARIA DE NNA', NULL, 'A', '2021-03-29 06:28:44', '2021-03-29 06:28:44'),
(200, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 25, 'RESTITUCION NACIONAL E INTERNACIONAL DE NNA', 'es', 'TIPOLOGIA', '0', 0, 'RESTITUCION NACIONAL E INTERNACIONAL DE NNA', NULL, 'A', '2021-03-29 06:28:49', '2021-03-29 06:28:49'),
(201, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 26, 'EXIGENCIA DE ACTIVIDADES EN LA FAMILIA QUE PONGAN EN RIESGO A NNA', 'es', 'TIPOLOGIA', '0', 0, 'EXIGENCIA DE ACTIVIDADES EN LA FAMILIA QUE PONGAN EN RIESGO A NNA', NULL, 'A', '2021-03-29 06:28:53', '2021-03-29 06:28:53'),
(202, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 27, 'VULNERACION A LA LIBERTAD', 'es', 'TIPOLOGIA', '0', 0, 'VULNERACION A LA LIBERTAD', NULL, 'A', '2021-03-29 06:28:59', '2021-03-29 06:28:59'),
(203, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 28, 'VULNERACION A LA PRIVACIDAD E INTIMIDAD FAMILIAR', 'es', 'TIPOLOGIA', '0', 0, 'VULNERACION A LA PRIVACIDAD E INTIMIDAD FAMILIAR', NULL, 'A', '2021-03-29 06:29:04', '2021-03-29 06:29:04'),
(204, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 29, 'VULNERACION A LA IMAGEN Y CONFIDENCIALIDAD', 'es', 'TIPOLOGIA', '0', 0, 'VULNERACION A LA IMAGEN Y CONFIDENCIALIDAD', NULL, 'A', '2021-03-29 06:29:10', '2021-03-29 06:29:10'),
(205, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 30, 'RESTITUCION NACIONAL E INTERNACIONAL DE NNA', 'es', 'TIPOLOGIA', '0', 0, 'RESTITUCION NACIONAL E INTERNACIONAL DE NNA', NULL, 'A', '2021-03-29 06:29:15', '2021-03-29 06:29:15'),
(206, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 31, 'EXIGENCIA DE ACTIVIDADES EN LA FAMILIA QUE PONGAN EN RIESGO A NNA', 'es', 'TIPOLOGIA', '0', 0, 'EXIGENCIA DE ACTIVIDADES EN LA FAMILIA QUE PONGAN EN RIESGO A NNA', NULL, 'A', '2021-03-29 06:29:20', '2021-03-29 06:29:20'),
(207, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 32, 'VULNERACION A LA LIBERTAD', 'es', 'TIPOLOGIA', '0', 0, 'VULNERACION A LA LIBERTAD', NULL, 'A', '2021-03-29 06:29:25', '2021-03-29 06:29:25'),
(208, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 33, 'VULNERACION A LA PRIVACIDAD E INTIMIDAD FAMILIAR', 'es', 'TIPOLOGIA', '0', 0, 'VULNERACION A LA PRIVACIDAD E INTIMIDAD FAMILIAR', NULL, 'A', '2021-03-29 06:29:30', '2021-03-29 06:29:30'),
(209, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 34, 'VULNERACION A LA IMAGEN Y CONFIDENCIALIDAD', 'es', 'TIPOLOGIA', '0', 0, 'VULNERACION A LA IMAGEN Y CONFIDENCIALIDAD', NULL, 'A', '2021-03-29 06:29:36', '2021-03-29 06:29:36'),
(210, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 35, 'PROTECCION CONTRA LA VIOLENCIA SEXUAL (SEXUALIZACION PRECOZ O HIPERSEXUALIZACION)', 'es', 'TIPOLOGIA', '0', 0, 'PROTECCION CONTRA LA VIOLENCIA SEXUAL (SEXUALIZACION PRECOZ O HIPERSEXUALIZACION)', NULL, 'A', '2021-03-29 06:29:41', '2021-03-29 06:29:41'),
(211, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 36, 'TRABAJOS PROHIBIDOS Y ATENTATORIOS', 'es', 'TIPOLOGIA', '0', 0, 'TRABAJOS PROHIBIDOS Y ATENTATORIOS', NULL, 'A', '2021-03-29 06:29:46', '2021-03-29 06:29:46'),
(212, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 37, 'EXPLOTACION LABORAL', 'es', 'TIPOLOGIA', '0', 0, 'EXPLOTACION LABORAL', NULL, 'A', '2021-03-29 06:29:51', '2021-03-29 06:29:51'),
(213, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 38, 'PROTECCION LABORAL', 'es', 'TIPOLOGIA', '0', 0, 'PROTECCION LABORAL', NULL, 'A', '2021-03-29 06:29:56', '2021-03-29 06:29:56'),
(214, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 39, 'INFRACCION AL DERECHO DE PROTECCION EN RELACION EL TRABAJO', 'es', 'TIPOLOGIA', '0', 0, 'INFRACCION AL DERECHO DE PROTECCION EN RELACION EL TRABAJO', NULL, 'A', '2021-03-29 06:30:01', '2021-03-29 06:30:01'),
(215, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 40, 'EXPULSION', 'es', 'TIPOLOGIA', '0', 0, 'EXPULSION', NULL, 'A', '2021-03-29 06:30:05', '2021-03-29 06:30:05'),
(216, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 41, 'RESTRICCION A LA EDUCACION', 'es', 'TIPOLOGIA', '0', 0, 'RESTRICCION A LA EDUCACION', NULL, 'A', '2021-03-29 06:30:12', '2021-03-29 06:30:12'),
(217, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 42, 'RESTRICCION A LA SALUD', 'es', 'TIPOLOGIA', '0', 0, 'RESTRICCION A LA SALUD', NULL, 'A', '2021-03-29 06:30:17', '2021-03-29 06:30:17'),
(218, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 43, 'ADOLESCENTE CON RESPONSABILIDAD PENAL', 'es', 'TIPOLOGIA', '0', 0, 'ADOLESCENTE CON RESPONSABILIDAD PENAL', NULL, 'A', '2021-03-29 06:30:22', '2021-03-29 06:30:22'),
(219, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 44, 'RESTRICCION A LIBERTAD DE EXPRESION A LA LIBRE PARTICIPACION Y A LA POSIBILIDAD DE INTERPONER PETICION', 'es', 'TIPOLOGIA', '0', 0, 'RESTRICCION A LIBERTAD DE EXPRESION A LA LIBRE PARTICIPACION Y A LA POSIBILIDAD DE INTERPONER PETICION', NULL, 'A', '2021-03-29 06:30:27', '2021-03-29 06:30:27'),
(220, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 45, 'VULNERACION DE LOS DERECHOS Y GARANTIAS DE LOS NNA, CON MADRE O PADRE PRIVADOS DE LIBERTAD', 'es', 'TIPOLOGIA', '0', 0, 'VULNERACION DE LOS DERECHOS Y GARANTIAS DE LOS NNA, CON MADRE O PADRE PRIVADOS DE LIBERTAD', NULL, 'A', '2021-03-29 06:30:33', '2021-03-29 06:30:33'),
(221, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 46, 'RESTRICCION DE LOS DERECHOS DE LOS NNA EN SITUACION DE DISCAPACIDAD', 'es', 'TIPOLOGIA', '0', 0, 'RESTRICCION DE LOS DERECHOS DE LOS NNA EN SITUACION DE DISCAPACIDAD', NULL, 'A', '2021-03-29 06:30:45', '2021-03-29 06:30:45'),
(222, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 47, 'RESTRICCION AL DERECHO A LA RECREACION, ESPARCIMIENTO, DEPORTE Y JUEGO', 'es', 'TIPOLOGIA', '0', 0, 'RESTRICCION AL DERECHO A LA RECREACION, ESPARCIMIENTO, DEPORTE Y JUEGO', NULL, 'A', '2021-03-29 06:30:50', '2021-03-29 06:30:50'),
(223, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 48, 'CONDUCTA AGRESIVAS', 'es', 'TIPOLOGIA', '0', 0, 'CONDUCTA AGRESIVAS', NULL, 'A', '2021-03-29 06:30:55', '2021-03-29 06:30:55'),
(224, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 49, 'CONSUMO DE ALCOHOL', 'es', 'TIPOLOGIA', '0', 0, 'CONSUMO DE ALCOHOL', NULL, 'A', '2021-03-29 06:31:01', '2021-03-29 06:31:01'),
(225, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 50, 'CONSUMO DE DROGAS', 'es', 'TIPOLOGIA', '0', 0, 'CONSUMO DE DROGAS', NULL, 'A', '2021-03-29 06:31:06', '2021-03-29 06:31:06'),
(226, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 51, 'PARTICIPACION EN PANDILLAS', 'es', 'TIPOLOGIA', '0', 0, 'PARTICIPACION EN PANDILLAS', NULL, 'A', '2021-03-29 06:31:11', '2021-03-29 06:31:11'),
(227, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 52, 'INTENTO DE SUICIDIO', 'es', 'TIPOLOGIA', '0', 0, 'INTENTO DE SUICIDIO', NULL, 'A', '2021-03-29 06:31:16', '2021-03-29 06:31:16'),
(228, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 53, 'ABANDONO DE HOGAR', 'es', 'TIPOLOGIA', '0', 0, 'ABANDONO DE HOGAR', NULL, 'A', '2021-03-29 06:31:21', '2021-03-29 06:31:21'),
(229, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 54, 'ABANDONO ESCOLAR', 'es', 'TIPOLOGIA', '0', 0, 'ABANDONO ESCOLAR', NULL, 'A', '2021-03-29 06:31:26', '2021-03-29 06:31:26'),
(230, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 55, 'SEXTING', 'es', 'TIPOLOGIA', '0', 0, 'SEXTING', NULL, 'A', '2021-03-29 06:31:31', '2021-03-29 06:31:31'),
(231, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 56, 'ORIENTACION Y/O APOYO INTEGRAL', 'es', 'TIPOLOGIA', '0', 0, 'ORIENTACION Y/O APOYO INTEGRAL', NULL, 'A', '2021-03-29 06:31:36', '2021-03-29 06:31:36'),
(232, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 57, 'VIOLACION INFANTE O NNA', 'es', 'TIPOLOGIA', '0', 0, 'VIOLACION INFANTE O NNA', NULL, 'A', '2021-03-29 06:31:41', '2021-03-29 06:31:41'),
(233, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 58, 'ABUSO SEXUAL', 'es', 'TIPOLOGIA', '0', 0, 'ABUSO SEXUAL', NULL, 'A', '2021-03-29 06:31:45', '2021-03-29 06:31:45'),
(234, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 59, 'ESTUPRO', 'es', 'TIPOLOGIA', '0', 0, 'ESTUPRO', NULL, 'A', '2021-03-29 06:31:50', '2021-03-29 06:31:50'),
(235, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 60, 'RAPTO', 'es', 'TIPOLOGIA', '0', 0, 'RAPTO', NULL, 'A', '2021-03-29 06:31:55', '2021-03-29 06:31:55'),
(236, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 61, 'CORRUPCION DE NNA', 'es', 'TIPOLOGIA', '0', 0, 'CORRUPCION DE NNA', NULL, 'A', '2021-03-29 06:31:59', '2021-03-29 06:31:59'),
(237, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 62, 'CORRUPCION AGRAVADA', 'es', 'TIPOLOGIA', '0', 0, 'CORRUPCION AGRAVADA', NULL, 'A', '2021-03-29 06:32:03', '2021-03-29 06:32:03'),
(238, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 63, 'PADECIMIENTO SEXUALES', 'es', 'TIPOLOGIA', '0', 0, 'PADECIMIENTO SEXUALES', NULL, 'A', '2021-03-29 06:32:08', '2021-03-29 06:32:08'),
(239, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 64, 'ACOSO SEXUAL', 'es', 'TIPOLOGIA', '0', 0, 'ACOSO SEXUAL', NULL, 'A', '2021-03-29 06:32:12', '2021-03-29 06:32:12'),
(240, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 65, 'PROXENITISMO', 'es', 'TIPOLOGIA', '0', 0, 'PROXENITISMO', NULL, 'A', '2021-03-29 06:32:17', '2021-03-29 06:32:17'),
(241, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 66, 'VIOLENCIA SEXUAL COMERCIAL', 'es', 'TIPOLOGIA', '0', 0, 'VIOLENCIA SEXUAL COMERCIAL', NULL, 'A', '2021-03-29 06:32:22', '2021-03-29 06:32:22'),
(242, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 67, 'HOMICIDIO', 'es', 'TIPOLOGIA', '0', 0, 'HOMICIDIO', NULL, 'A', '2021-03-29 06:32:26', '2021-03-29 06:32:26'),
(243, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 68, 'HOMICIDIO EN PRACTICAS DEPORTIVAS', 'es', 'TIPOLOGIA', '0', 0, 'HOMICIDIO EN PRACTICAS DEPORTIVAS', NULL, 'A', '2021-03-29 06:32:31', '2021-03-29 06:32:31'),
(244, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 69, 'ASESINATO', 'es', 'TIPOLOGIA', '0', 0, 'ASESINATO', NULL, 'A', '2021-03-29 06:32:35', '2021-03-29 06:32:35'),
(245, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 70, 'HOMICIDIO SUICIDIO', 'es', 'TIPOLOGIA', '0', 0, 'HOMICIDIO SUICIDIO', NULL, 'A', '2021-03-29 06:32:39', '2021-03-29 06:32:39'),
(246, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 71, 'INFANTICIDIO', 'es', 'TIPOLOGIA', '0', 0, 'INFANTICIDIO', NULL, 'A', '2021-03-29 06:32:44', '2021-03-29 06:32:44'),
(247, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 72, 'ABORTO', 'es', 'TIPOLOGIA', '0', 0, 'ABORTO', NULL, 'A', '2021-03-29 06:32:48', '2021-03-29 06:32:48'),
(248, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 73, 'HOMICIDIO EN RIÑA O A CONSECUENCIA DE AGRESION', 'es', 'TIPOLOGIA', '0', 0, 'HOMICIDIO EN RIÑA O A CONSECUENCIA DE AGRESION', NULL, 'A', '2021-03-29 06:32:54', '2021-03-29 06:32:54'),
(249, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 74, 'ABORTO SEGUIDO DE LESION O MUERTE', 'es', 'TIPOLOGIA', '0', 0, 'ABORTO SEGUIDO DE LESION O MUERTE', NULL, 'A', '2021-03-29 06:33:00', '2021-03-29 06:33:00'),
(250, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 75, 'HOMICIDIO Y LESIONES GRAVES Y GRAVISIMAS EN ACCIDENTE DE TRANSITO', 'es', 'TIPOLOGIA', '0', 0, 'HOMICIDIO Y LESIONES GRAVES Y GRAVISIMAS EN ACCIDENTE DE TRANSITO', NULL, 'A', '2021-03-29 06:33:05', '2021-03-29 06:33:05'),
(251, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 76, 'ABORTO HONORIS CAUSA', 'es', 'TIPOLOGIA', '0', 0, 'ABORTO HONORIS CAUSA', NULL, 'A', '2021-03-29 06:33:10', '2021-03-29 06:33:10'),
(252, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'SI', 'es', 'SINOENPROCESO', '0', 0, 'SI', NULL, 'A', '2021-03-29 07:20:50', '2021-03-29 07:20:50'),
(253, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'NO', 'es', 'SINOENPROCESO', '0', 0, 'NO', NULL, 'A', '2021-03-29 07:20:54', '2021-03-29 07:20:54'),
(254, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 'EN PROCESO', 'es', 'SINOENPROCESO', '0', 0, 'EN PROCESO', NULL, 'A', '2021-03-29 07:21:03', '2021-03-29 07:21:03'),
(255, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'INICIO', 'es', 'TERAPIA', '0', 0, 'INICIO', NULL, 'A', '2021-03-29 08:18:18', '2021-03-29 08:18:18'),
(256, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'PROCESO', 'es', 'TERAPIA', '0', 0, 'PROCESO', NULL, 'A', '2021-03-29 08:18:23', '2021-03-29 08:18:23'),
(257, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 'CONCLUSION', 'es', 'TERAPIA', '0', 0, 'CONCLUSION', NULL, 'A', '2021-03-29 08:18:30', '2021-03-29 08:18:30'),
(258, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 6, 'OTROS', 'es', 'MOTIVOSALIDA', '0', 0, 'OTROS', NULL, 'A', '2021-03-29 10:25:56', '2021-03-29 10:25:56'),
(259, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 4, 'SE DESCONOCE', 'es', 'SINONOCORRESPONDE', '0', 0, 'SE DESCONOCE', NULL, 'A', '2021-03-29 10:29:36', '2021-03-29 10:29:36'),
(260, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 6, 'PADRE', 'es', 'TIPOREFERENTEAFECTIVO', '0', 0, 'PADRE', NULL, 'A', '2021-03-29 10:39:56', '2021-03-29 10:39:56'),
(261, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 7, 'MADRE', 'es', 'TIPOREFERENTEAFECTIVO', '0', 0, 'MADRE', NULL, 'A', '2021-03-29 10:40:02', '2021-03-29 10:40:02'),
(262, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 'AMBOS', 'es', 'DETALLESFRECUENCIACONTACTO', '0', 0, 'AMBOS', NULL, 'A', '2021-03-29 10:44:10', '2021-03-29 10:44:10'),
(263, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'POSTGRADO', 'es', 'NIVELDEEDUCACION', '0', 0, 'POSTGRADO', NULL, 'A', '2021-03-29 10:54:33', '2021-03-29 10:54:33'),
(264, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'PREGRADO', 'es', 'NIVELDEEDUCACION', '0', 0, 'PREGRADO', NULL, 'A', '2021-03-29 10:54:40', '2021-03-29 10:54:40'),
(265, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 'SECUNDARIA', 'es', 'NIVELDEEDUCACION', '0', 0, 'SECUNDARIA', NULL, 'A', '2021-03-29 10:54:58', '2021-03-29 10:55:07'),
(266, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 4, 'PRIMARIA', 'es', 'NIVELDEEDUCACION', '0', 0, 'PRIMARIA', NULL, 'A', '2021-03-29 10:55:13', '2021-03-29 10:55:13'),
(267, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 5, 'SIN ESTUDIOS', 'es', 'NIVELDEEDUCACION', '0', 0, 'SIN ESTUDIOS', NULL, 'A', '2021-03-29 10:55:20', '2021-03-29 10:55:20'),
(268, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 9, '9. VIVIENDA CEDIDA', 'es', 'TIPOVIVIENDA', '0', 0, '9. VIVIENDA CEDIDA', NULL, 'A', '2021-03-29 11:01:18', '2021-03-29 11:08:13'),
(269, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 5, '5. NO CUENTA CON INGRESOS', 'es', 'INGRESOECONOMICO', '0', 0, '5. NO CUENTA CON INGRESOS', NULL, 'A', '2021-03-29 11:01:41', '2021-03-29 11:01:41');
INSERT INTO `hogares_catalog_items` (`id`, `catalogs_id`, `users_sid`, `value`, `label`, `lang`, `catalog_code`, `catalog_code_dep`, `catalog_id_dep`, `description`, `svg_image`, `status`, `created_at`, `updated_at`) VALUES
(270, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 4, 'SEDEGES', 'es', 'RESPONSABLESEGUIMIENTO', '0', 0, 'SEDEGES', NULL, 'A', '2021-03-29 11:02:00', '2021-03-29 11:02:00'),
(271, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 5, 'OTRA INSTITUCION', 'es', 'RESPONSABLESEGUIMIENTO', '0', 0, 'OTRA INSTITUCION', NULL, 'A', '2021-03-29 11:02:17', '2021-03-29 11:02:17'),
(272, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 6, 'NINGUNA', 'es', 'RESPONSABLESEGUIMIENTO', '0', 0, 'NINGUNA', NULL, 'A', '2021-03-29 11:02:25', '2021-03-29 11:02:25'),
(273, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, '6-12', 'es', 'EDADESPOBLACION', '0', 0, '6-12', NULL, 'A', '2021-03-30 13:57:51', '2021-03-30 13:57:51'),
(274, 1, '5ce0949f-b4ed-4925-8a99-5ed8ab2f6e9a', 1, 'DISTRITO 1', 'es', 'DISTRITO', '0', 0, 'Distrito 1', NULL, 'A', '2021-04-29 08:51:57', '2021-04-29 08:51:57'),
(275, 1, '5ce0949f-b4ed-4925-8a99-5ed8ab2f6e9a', 2, 'DISTRITO 2', 'es', 'DISTRITO', '0', 0, 'DISTRITO 2', NULL, 'A', '2021-04-29 08:52:06', '2021-04-29 08:52:06'),
(276, 1, '5ce0949f-b4ed-4925-8a99-5ed8ab2f6e9a', 3, 'DISTRITO 3', 'es', 'DISTRITO', '0', 0, 'DISTRITO 3', NULL, 'A', '2021-04-29 10:41:15', '2021-04-29 10:41:15'),
(277, 1, '5ce0949f-b4ed-4925-8a99-5ed8ab2f6e9a', 4, 'DISTRITO 4', 'es', 'DISTRITO', '0', 0, 'DISTRITO 4', NULL, 'A', '2021-04-29 10:41:21', '2021-04-29 10:41:21'),
(278, 1, '5ce0949f-b4ed-4925-8a99-5ed8ab2f6e9a', 5, 'DISTRITO 5', 'es', 'DISTRITO', '0', 0, 'DISTRITO 5', NULL, 'A', '2021-04-29 10:41:32', '2021-04-29 10:41:32'),
(279, 1, '5ce0949f-b4ed-4925-8a99-5ed8ab2f6e9a', 6, 'DISTRITO 6', 'es', 'DISTRITO', '0', 0, 'DISTRITO 6', NULL, 'A', '2021-04-29 10:41:37', '2021-04-29 10:41:37'),
(280, 1, '5ce0949f-b4ed-4925-8a99-5ed8ab2f6e9a', 7, 'DISTRITO 7', 'es', 'DISTRITO', '0', 0, 'DISTRITO 7', NULL, 'A', '2021-04-29 10:41:43', '2021-04-29 10:41:43'),
(281, 1, '5ce0949f-b4ed-4925-8a99-5ed8ab2f6e9a', 8, 'DISTRITO 8', 'es', 'DISTRITO', '0', 0, 'DISTRITO 8', NULL, 'A', '2021-04-29 10:41:47', '2021-04-29 10:41:47'),
(282, 1, '5ce0949f-b4ed-4925-8a99-5ed8ab2f6e9a', 9, 'DISTRITO 9', 'es', 'DISTRITO', '0', 0, 'DISTRITO 9', NULL, 'A', '2021-04-29 10:41:52', '2021-04-29 10:41:52'),
(283, 1, '5ce0949f-b4ed-4925-8a99-5ed8ab2f6e9a', 10, 'DISTRITO 10', 'es', 'DISTRITO', '0', 0, 'DISTRITO 10', NULL, 'A', '2021-04-29 10:41:57', '2021-04-29 10:41:57'),
(284, 1, '5ce0949f-b4ed-4925-8a99-5ed8ab2f6e9a', 11, 'DISTRITO 11', 'es', 'DISTRITO', '0', 0, 'DISTRITO 11', NULL, 'A', '2021-04-29 10:42:02', '2021-04-29 10:42:02'),
(285, 1, '5ce0949f-b4ed-4925-8a99-5ed8ab2f6e9a', 12, 'DISTRITO 12', 'es', 'DISTRITO', '0', 0, 'DISTRITO 12', NULL, 'A', '2021-04-29 10:42:08', '2021-04-29 10:42:08'),
(286, 1, '5ce0949f-b4ed-4925-8a99-5ed8ab2f6e9a', 13, 'DISTRITO 13', 'es', 'DISTRITO', '0', 0, 'DISTRITO 13', NULL, 'A', '2021-04-29 10:42:13', '2021-04-29 10:42:13'),
(287, 1, '5ce0949f-b4ed-4925-8a99-5ed8ab2f6e9a', 14, 'DISTRITO 14', 'es', 'DISTRITO', '0', 0, 'DISTRITO 14', NULL, 'A', '2021-04-29 10:42:20', '2021-04-29 10:42:20'),
(288, 1, '05f6481f-c7f3-4cdf-8d07-a99d76ad3fb2', 3, 'NO BINARIO', 'es', 'SEXO', '0', 0, 'NO BINARIO', NULL, 'A', '2021-07-30 09:26:05', '2021-07-30 09:26:05');

-- --------------------------------------------------------

--
-- Table structure for table `hogares_centro`
--

CREATE TABLE `hogares_centro` (
  `relative` varchar(50) NOT NULL COMMENT 'unique',
  `users_sid` varchar(50) NOT NULL,
  `nombre_centro` varchar(100) NOT NULL,
  `responsable` varchar(100) NOT NULL,
  `departamento_id` int DEFAULT NULL,
  `provincia_id` int DEFAULT NULL,
  `municipio_id` int DEFAULT NULL,
  `comunidad_zona` text NOT NULL,
  `distrito` tinytext,
  `telefono` varchar(75) DEFAULT NULL,
  `celular` varchar(75) DEFAULT NULL,
  `capacidad_atencion` smallint NOT NULL,
  `tipo_poblacion_id` smallint NOT NULL DEFAULT '1',
  `poblacion_actual` smallint NOT NULL,
  `edades_poblacion_id` smallint NOT NULL DEFAULT '1',
  `financiamiento` text NOT NULL,
  `infraestructura_id` smallint NOT NULL DEFAULT '1',
  `terreno_pertenece_id` smallint NOT NULL DEFAULT '1',
  `servicios` varchar(100) NOT NULL,
  `tipo_administracion_id` smallint NOT NULL DEFAULT '1',
  `personal_del_centro` tinyint DEFAULT NULL,
  `acreditacion_id` smallint NOT NULL DEFAULT '1',
  `ubicacion_latitud` decimal(10,8) DEFAULT NULL,
  `ubicacion_longitud` decimal(10,8) DEFAULT NULL,
  `status` enum('A','X') NOT NULL COMMENT 'Status',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hogares_centro`
--

INSERT INTO `hogares_centro` (`relative`, `users_sid`, `nombre_centro`, `responsable`, `departamento_id`, `provincia_id`, `municipio_id`, `comunidad_zona`, `distrito`, `telefono`, `celular`, `capacidad_atencion`, `tipo_poblacion_id`, `poblacion_actual`, `edades_poblacion_id`, `financiamiento`, `infraestructura_id`, `terreno_pertenece_id`, `servicios`, `tipo_administracion_id`, `personal_del_centro`, `acreditacion_id`, `ubicacion_latitud`, `ubicacion_longitud`, `status`, `created_at`, `updated_at`) VALUES
('5173842c-314a-4dc0-8461-4f383409fdcd', '05f6481f-c7f3-4cdf-8d07-a99d76ad3fb2', 'Casa Esperanza Caranavi', 'Martha Maconde Flores', 2, NULL, 244, 'Villa esperanza', 'Sin distrito', '591-2-824-3663', '591-2-824-3663', 50, 2, 48, 3, 'Donaciones, Holanda', 3, 2, 'Ninguno', 1, 6, 2, NULL, NULL, 'A', '2021-09-13 11:44:00', '2021-09-13 11:44:00');

-- --------------------------------------------------------

--
-- Table structure for table `hogares_departamento`
--

CREATE TABLE `hogares_departamento` (
  `id` int NOT NULL,
  `departamento` varchar(50) NOT NULL,
  `latitud` double(10,8) NOT NULL DEFAULT '0.00000000',
  `longitud` double(10,8) NOT NULL DEFAULT '0.00000000',
  `poblacion` decimal(10,2) NOT NULL,
  `municipios` int NOT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hogares_departamento`
--

INSERT INTO `hogares_departamento` (`id`, `departamento`, `latitud`, `longitud`, `poblacion`, `municipios`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Chuquisaca', -65.26016998, -19.04652023, '576153.00', 29, 'A', '2021-01-31 15:16:37', '2021-01-31 15:16:37'),
(2, 'La Paz', -68.13469102, -16.49361010, '2706351.00', 87, 'A', '2021-01-31 15:16:37', '2021-01-31 15:16:37'),
(3, 'Cochabamba', -66.15877535, -17.38146043, '1758143.00', 47, 'A', '2021-01-31 15:16:37', '2021-01-31 15:16:37'),
(4, 'Oruro', -67.11207277, -17.96775852, '494178.00', 35, 'A', '2021-01-31 15:16:37', '2021-01-31 15:16:37'),
(5, 'Potosi', -65.75422853, -19.58058552, '823517.00', 40, 'A', '2021-01-31 15:16:37', '2021-01-31 15:16:37'),
(6, 'Tarija', -64.73290519, -21.53161591, '482196.00', 11, 'A', '2021-01-31 15:16:37', '2021-01-31 15:16:37'),
(7, 'Santa Cruz', -63.17891679, -17.78428323, '2655084.00', 56, 'A', '2021-01-31 15:16:37', '2021-01-31 15:16:37'),
(8, 'Beni', -64.90184886, -14.83578613, '421196.00', 19, 'A', '2021-01-31 15:16:37', '2021-01-31 15:16:37'),
(9, 'Pando', -68.76112658, -11.02481286, '110436.00', 15, 'A', '2021-01-31 15:16:37', '2021-01-31 15:16:37'),
(32, 'Bolivia', 0.00000000, 0.00000000, '0.00', 9, 'A', '2021-01-31 15:16:37', '2021-01-31 15:16:37');

-- --------------------------------------------------------

--
-- Table structure for table `hogares_desinstitucionalizacion`
--

CREATE TABLE `hogares_desinstitucionalizacion` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `hogares_nna_id` varchar(50) NOT NULL,
  `fecha_egreso` date NOT NULL,
  `motivo_salida_id` smallint NOT NULL,
  `fecha_reingreso` date DEFAULT NULL,
  `motivo_reingreso` text,
  `fecha_transferencia` date DEFAULT NULL,
  `motivo_transferencia` text,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hogares_desinstitucionalizacion`
--

INSERT INTO `hogares_desinstitucionalizacion` (`relative`, `users_sid`, `hogares_nna_id`, `fecha_egreso`, `motivo_salida_id`, `fecha_reingreso`, `motivo_reingreso`, `fecha_transferencia`, `motivo_transferencia`, `status`, `created_at`, `updated_at`) VALUES
('eeb6346a-01d9-4721-96f5-82ca8b73489f', '05f6481f-c7f3-4cdf-8d07-a99d76ad3fb2', '78a113f0-75bc-4cc6-a2bb-100578fede2c', '2021-09-13', 1, NULL, NULL, NULL, NULL, 'A', '2021-09-13 13:58:37', '2021-09-13 13:58:37');

-- --------------------------------------------------------

--
-- Table structure for table `hogares_documentacion_acogida`
--

CREATE TABLE `hogares_documentacion_acogida` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `hogares_nna_id` varchar(50) NOT NULL,
  `documentos_investigacion_id` smallint NOT NULL,
  `documentos_investigacion_adjunto` text,
  `informacion_trabajador_social_id` smallint NOT NULL,
  `informacion_trabajador_social_adjunto` text,
  `informacion_caso_psicologo_id` smallint NOT NULL,
  `informacion_caso_psicologo_adjunto` text,
  `informe_legal_id` smallint NOT NULL,
  `informe_legal_adjunto` text,
  `informe_medico_id` smallint NOT NULL,
  `informe_medico_adjunto` text,
  `otros_documentos_adjuntos` text,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `hogares_educacion`
--

CREATE TABLE `hogares_educacion` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `hogares_nna_id` varchar(50) NOT NULL,
  `nivel_grado_momento_acogida` varchar(200) NOT NULL,
  `motivo_no_inscrito` varchar(200) DEFAULT NULL,
  `grado_academico` varchar(200) DEFAULT NULL,
  `nombre_unidad_educativa` varchar(200) DEFAULT NULL,
  `desempeno_escolar_id` smallint NOT NULL,
  `asistencia_escolar_id` smallint NOT NULL,
  `nna_discapacidad_asiste_institucion_especializada_id` smallint NOT NULL,
  `desfase_educativo` varchar(200) DEFAULT NULL,
  `deserto_educacion_formal_id` smallint NOT NULL,
  `fecha_deserto` date DEFAULT NULL,
  `motivo_deserto` text,
  `acciones_por_desercion` mediumtext,
  `regreso_escuela_id` smallint DEFAULT NULL,
  `fecha_regreso` date DEFAULT NULL,
  `transferencia_unidad_educativa` text,
  `nombre_director_unidad_educativa` varchar(200) DEFAULT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `hogares_familia_oara`
--

CREATE TABLE `hogares_familia_oara` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `hogares_nna_id` varchar(50) NOT NULL,
  `tipo_referente_afectivo_id` smallint NOT NULL,
  `nombres_y_apellidos` varchar(200) NOT NULL,
  `documento_identidad` varchar(50) NOT NULL,
  `fotografia` varchar(200) DEFAULT NULL,
  `linea_paterna_materna_id` smallint NOT NULL,
  `lugar_nacimiento` text NOT NULL,
  `fecha_nacimiento` date NOT NULL,
  `ocupacion` varchar(200) NOT NULL,
  `estado_civil_id` tinyint NOT NULL,
  `numero_telefonico` varchar(200) NOT NULL,
  `direccion` varchar(200) NOT NULL,
  `estado_salud` text NOT NULL,
  `enfermedades_actuales_que_presenta` text,
  `propiedades_que_cuenta` text,
  `opinion_del_nna_id` tinyint NOT NULL,
  `frecuencia_contacto_id` tinyint NOT NULL,
  `antecedentes_consumo_alcohol_id` smallint NOT NULL,
  `antecedentes_denuncias_id` smallint NOT NULL,
  `antecedentes_penales_judiciales_policiales` longtext,
  `considera_posibilidades_revinculacion_id` smallint NOT NULL,
  `adjuntos` text,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hogares_familia_oara`
--

INSERT INTO `hogares_familia_oara` (`relative`, `users_sid`, `hogares_nna_id`, `tipo_referente_afectivo_id`, `nombres_y_apellidos`, `documento_identidad`, `fotografia`, `linea_paterna_materna_id`, `lugar_nacimiento`, `fecha_nacimiento`, `ocupacion`, `estado_civil_id`, `numero_telefonico`, `direccion`, `estado_salud`, `enfermedades_actuales_que_presenta`, `propiedades_que_cuenta`, `opinion_del_nna_id`, `frecuencia_contacto_id`, `antecedentes_consumo_alcohol_id`, `antecedentes_denuncias_id`, `antecedentes_penales_judiciales_policiales`, `considera_posibilidades_revinculacion_id`, `adjuntos`, `status`, `created_at`, `updated_at`) VALUES
('c461bb34-1431-46f6-bd12-cf3f350305d1', '05f6481f-c7f3-4cdf-8d07-a99d76ad3fb2', '78a113f0-75bc-4cc6-a2bb-100578fede2c', 3, 'Fulano Cabrera', '0', NULL, 3, 'Desconocido', '1956-05-01', 'Jubilado', 1, '0', 'Sin direccion conocida', 'Se desconoce', 'Ninguna conocida', 'Se desconoce', 2, 5, 1, 1, 'Ninguno conocido', 2, NULL, 'A', '2021-09-13 12:06:52', '2021-09-13 12:06:52'),
('d9fded32-e334-4927-89e2-ede679414ae5', '05f6481f-c7f3-4cdf-8d07-a99d76ad3fb2', '78a113f0-75bc-4cc6-a2bb-100578fede2c', 3, 'Luisa Aparicio', '0', NULL, 2, 'San Borja - Beni', '1951-10-25', 'Jubilada', 4, '0', 'Rurrenabaque bolivia', 'Buen estado de salud', 'Hipertension arterial', '1 terreno', 1, 2, 2, 2, NULL, 1, NULL, 'A', '2021-09-13 12:04:41', '2021-09-13 12:04:41');

-- --------------------------------------------------------

--
-- Table structure for table `hogares_familia_oara_area_psicologica`
--

CREATE TABLE `hogares_familia_oara_area_psicologica` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `hogares_nna_id` varchar(50) NOT NULL,
  `hogares_familia_oara_id` varchar(50) NOT NULL,
  `estructura_dinamica_familiar_id` smallint NOT NULL,
  `estructura_dinamica_familiar_adjunto` text,
  `cuenta_con_ipif_id` smallint NOT NULL,
  `nivel_puntuacion_id` smallint NOT NULL,
  `nivel_puntuacion_adjunto` text,
  `ficha_seguimiento_familiar_id` smallint NOT NULL,
  `ficha_seguimiento_familiar_fecha` date DEFAULT NULL,
  `ficha_seguimiento_familiar_adjunto` varchar(200) DEFAULT NULL,
  `informe_desarrollo_familiar_id` smallint NOT NULL,
  `informe_desarrollo_familiar_adjunto` text,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `hogares_familia_oara_area_social`
--

CREATE TABLE `hogares_familia_oara_area_social` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `hogares_nna_id` varchar(50) NOT NULL,
  `hogares_familia_oara_id` varchar(50) NOT NULL COMMENT 'related to familia_oara',
  `evaluacion_diagnostica` longtext NOT NULL,
  `evaluacion_documento_adjunto` varchar(200) NOT NULL,
  `coordinacion_interinstitucional` text,
  `coordinacion_interno_equipo_id` smallint NOT NULL,
  `coordinacion` text,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `hogares_familia_oara_area_social_seguimiento`
--

CREATE TABLE `hogares_familia_oara_area_social_seguimiento` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `hogares_nna_id` varchar(50) NOT NULL,
  `hogares_familia_oara_id` varchar(50) NOT NULL,
  `fecha_seguimiento` date NOT NULL,
  `seguimiento_social` longtext NOT NULL,
  `documento_adjunto` varchar(200) NOT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `hogares_familia_oara_documentos`
--

CREATE TABLE `hogares_familia_oara_documentos` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `hogares_nna_id` varchar(50) NOT NULL,
  `titulo_documentos` text NOT NULL,
  `documento` text NOT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `hogares_momento_acogida`
--

CREATE TABLE `hogares_momento_acogida` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `hogares_nna_id` varchar(50) NOT NULL,
  `participacion_familia_id` smallint NOT NULL,
  `motivo_no_participacion_id` smallint DEFAULT NULL,
  `antes_acogida_vivia_id` smallint NOT NULL,
  `plan_adaptacion_id` smallint NOT NULL,
  `plan_adaptacion_adjunto` text,
  `comentarios` text NOT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `hogares_motivo_acogida`
--

CREATE TABLE `hogares_motivo_acogida` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `hogares_nna_id` varchar(50) NOT NULL COMMENT 'related to hogares_nna',
  `motivo_acogida_id` smallint NOT NULL,
  `maltrato_tipo_id` smallint DEFAULT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `hogares_municipio`
--

CREATE TABLE `hogares_municipio` (
  `id` int NOT NULL,
  `id_departamento` int NOT NULL COMMENT 'Related to hogares_departamento',
  `codine` int NOT NULL,
  `municipio` varchar(200) NOT NULL,
  `latitud` float(10,6) NOT NULL DEFAULT '0.000000',
  `longitud` float(10,6) NOT NULL DEFAULT '0.000000',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hogares_municipio`
--

INSERT INTO `hogares_municipio` (`id`, `id_departamento`, `codine`, `municipio`, `latitud`, `longitud`, `status`, `created_at`, `updated_at`) VALUES
(1, 7, 70303, 'San Rafael', -60.674530, -16.786976, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(2, 7, 70707, 'Boyuibe', -63.280655, -20.445309, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(3, 7, 70902, 'Pampa Grande', -64.111168, -18.091076, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(4, 7, 70901, 'Samaipata', -63.877090, -18.179049, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(5, 7, 70903, 'Mairana', -63.958736, -18.121410, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(6, 7, 70802, 'Trigal', -64.149498, -18.305166, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(7, 7, 70803, 'Moro Moro', -64.323509, -18.366177, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(8, 7, 71302, 'Saipina', -64.583878, -18.093935, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(9, 7, 70904, 'Quirusillas', -63.947651, -18.334814, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(10, 7, 70102, 'Cotoca', -62.996338, -17.754164, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(11, 7, 70805, 'Pucara', -64.185989, -18.715040, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(12, 7, 70105, 'El Torno', -63.381733, -17.992167, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(13, 7, 70101, 'Santa Cruz de la Sierra', -63.178917, -17.784283, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(14, 7, 70804, 'Postrer Valle', -63.841324, -18.492668, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(15, 7, 70104, 'La Guardia', -63.329445, -17.893316, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(16, 2, 21602, 'Curva', -68.999245, -15.131128, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(17, 5, 50901, 'Colcha\"K\" (V.Martin)', -67.660149, -20.740225, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(18, 4, 41503, 'Carangas', -68.624298, -18.939205, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(19, 4, 41501, 'La Rivera', -68.639977, -19.004913, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(20, 4, 41502, 'Todos Santos', -68.720566, -19.014885, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(21, 2, 20101, 'Nuestra Señora de La Paz', -68.134689, -16.493610, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(22, 2, 20604, 'Quiabaya', -68.703178, -15.632848, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(23, 2, 20502, 'Ayata', -68.834702, -15.459249, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(24, 2, 20601, 'Sorata', -68.649391, -15.773249, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(25, 2, 20603, 'Tacacoma', -68.645241, -15.589397, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(26, 2, 20501, 'Chuma', -68.898521, -15.479623, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(27, 2, 20605, 'Combaya', -68.754761, -15.805272, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(28, 2, 20503, 'Aucapata', -68.718925, -15.479418, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(29, 2, 20606, 'Tipuani', -68.020798, -15.565077, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(30, 2, 20102, 'Palca', -67.952812, -16.560944, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(31, 2, 21303, 'Ayo Ayo', -68.003632, -17.091387, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(32, 2, 20902, 'Sapahaqui', -67.949631, -16.888535, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(33, 2, 21103, 'Yanacachi', -67.735260, -16.390541, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(34, 2, 20103, 'Mecapaca', -68.027664, -16.665693, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(35, 2, 21401, 'Coroico', -67.727539, -16.188183, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(36, 2, 21002, 'Quime', -67.217918, -16.981409, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(37, 2, 20904, 'Malla', -67.450584, -17.040112, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(38, 2, 21003, 'Cajuata', -67.172646, -16.699017, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(39, 2, 20903, 'Yaco', -67.410690, -17.157969, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(40, 2, 21102, 'Irupana', -67.454643, -16.465799, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(41, 2, 21005, 'Ichoca', -67.187477, -17.139833, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(42, 2, 20901, 'Luribay', -67.661240, -17.062511, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(43, 2, 21402, 'Coripata', -67.606880, -16.314489, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(44, 2, 20905, 'Cairoma', -67.539986, -16.903465, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(45, 2, 21101, 'Chulumani', -67.525734, -16.409357, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(46, 2, 21006, 'Licoma (Villa Libertad)', -67.202087, -16.805689, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(47, 3, 30901, 'Quillacollo', -66.279785, -17.395483, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(48, 3, 30101, 'Cochabamba', -66.158775, -17.381460, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(49, 3, 31001, 'Sacaba', -66.039124, -17.402121, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(50, 3, 30905, 'Colcapirhua', -66.241264, -17.389566, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(51, 3, 30903, 'Tiquipaya', -66.219582, -17.338125, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(52, 3, 30502, 'Vacas', -65.580254, -17.575329, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(53, 3, 30403, 'Arbieto', -66.015305, -17.581741, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(54, 3, 30601, 'Arque', -66.401756, -17.821321, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(55, 3, 30701, 'Capinota', -66.263039, -17.716009, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(56, 3, 30703, 'Sicaya', -66.333817, -17.800568, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(57, 3, 30501, 'Arani', -65.770401, -17.572769, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(58, 3, 31405, 'Cuchumuela (V. G.Villarroel)', -65.795715, -17.665836, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(59, 3, 31404, 'Tacachi', -65.801247, -17.641932, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(60, 3, 31401, 'Punata', -65.838486, -17.546137, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(61, 3, 31402, 'Villa Rivero', -65.812843, -17.616304, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(62, 3, 31303, 'Alalay', -65.699219, -17.701445, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(63, 3, 30401, 'Tarata', -66.024193, -17.613014, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(64, 3, 30902, 'Sipe Sipe', -66.354225, -17.454195, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(65, 3, 30702, 'Santibañez', -66.248009, -17.550365, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(66, 3, 30404, 'Sacabamba', -65.776497, -17.811745, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(67, 3, 30402, 'Anzaldo', -65.935699, -17.783426, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(68, 3, 30802, 'Toko', -65.929062, -17.625429, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(69, 3, 30801, 'Cliza', -65.934013, -17.591633, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(70, 4, 40701, 'Villa Huanuni', -66.839951, -18.287806, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(71, 3, 30602, 'Tacopaya', -66.534660, -17.837402, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(72, 5, 51301, 'Arampampa', -66.079597, -17.874903, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(73, 3, 31403, 'San Benito', -65.894409, -17.522699, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(74, 5, 51302, 'Acasio', -66.057411, -18.024063, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(75, 5, 50502, 'Toro Toro', -65.761330, -18.133562, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(76, 3, 31501, 'Bolivar', -66.537041, -17.970074, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(77, 5, 50702, 'Caripuyo', -66.472900, -18.232225, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(78, 5, 50203, 'Llallagua', -66.583473, -18.423079, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(79, 5, 50701, 'Sacaca', -66.383598, -18.068274, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(80, 3, 31302, 'Vila Vila', -65.631775, -17.981653, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(81, 2, 21202, 'Laja', -68.385521, -16.536533, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(82, 2, 20104, 'Achocalla', -68.166733, -16.574501, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(83, 4, 41301, 'San Pedro de Totora', -68.146080, -17.793673, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(84, 2, 21302, 'Umala', -68.021431, -17.373318, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(85, 2, 21305, 'Patacamaya', -67.928108, -17.240944, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(86, 2, 20302, 'Caquiaviri', -68.607002, -17.023273, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(87, 2, 20307, 'Nazacara de Pacajes', -68.764397, -16.937332, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(88, 2, 20308, 'Santiago de Callapa', -68.355644, -17.479589, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(89, 2, 21306, 'Colquencha', -68.248756, -16.931292, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(90, 2, 20306, 'Waldo Ballivian', -68.186256, -17.082819, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(91, 2, 20304, 'Comanche', -68.427650, -16.956760, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(92, 2, 21304, 'Calamarca', -68.119034, -16.909779, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(93, 4, 41101, 'Eucaliptus', -67.508492, -17.596838, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(94, 2, 21301, 'Sica Sica', -67.740906, -17.333672, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(95, 2, 21802, 'Papel Pampa', -67.769661, -17.819349, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(96, 4, 40302, 'Choquecota', -67.895523, -18.098375, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(97, 2, 21801, 'San Pedro de Curahuara', -68.050049, -17.654491, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(98, 4, 41601, 'Santiago de Huayllamarca', -67.945839, -17.840994, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(99, 2, 20301, 'Coro Coro', -68.453094, -17.178162, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(100, 2, 21803, 'Chacarilla', -68.215912, -17.583826, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(101, 2, 21307, 'Collana', -68.284233, -16.904684, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(102, 4, 40301, 'Corque', -67.681877, -18.351017, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(103, 4, 40602, 'Pazña', -66.921486, -18.599319, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(104, 4, 41001, 'Toledo', -67.406998, -18.181803, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(105, 4, 40103, 'El Choro', -67.115623, -18.357340, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(106, 4, 40601, 'Poopó', -66.968521, -18.380396, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(107, 4, 40702, 'Machacamarca', -67.021133, -18.172474, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(108, 4, 40502, 'Escara', -68.170464, -18.859575, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(109, 4, 40505, 'Esmeralda', -68.281273, -18.843588, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(110, 4, 40903, 'Chipaya', -68.088905, -19.041870, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(111, 4, 40801, 'Salinas de Garci Mendoza', -67.676338, -19.638428, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(112, 4, 40504, 'Yunguyo del Litoral', -68.320747, -18.853422, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(113, 4, 40503, 'Cruz de Machacamarca', -68.311775, -18.771482, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(114, 4, 40603, 'Antequera (Bolivar)', -66.825836, -18.471123, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(115, 4, 41201, 'Santiago de Andamarca', -67.508324, -18.778790, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(116, 4, 40802, 'Pampa Aullagas', -67.062073, -19.197092, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(117, 4, 41202, 'Belén de Andamarca', -67.641457, -18.817236, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(118, 4, 40501, 'Huachacalla', -68.262260, -18.793457, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(119, 4, 41401, 'Santiago de Huari', -66.777016, -19.012180, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(120, 4, 40202, 'Santuario de Quillacas', -66.942413, -19.233170, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(121, 4, 40201, 'Challapata', -66.774696, -18.900820, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(122, 5, 50201, 'Uncía', -66.568390, -18.466473, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(123, 5, 50202, 'Chayanta', -66.442177, -18.461201, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(124, 5, 50501, 'San Pedro de Buena Vista', -65.980141, -18.270111, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(125, 1, 10702, 'San Lucas', -65.133568, -20.101980, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(126, 5, 50302, 'Chaqui', -65.561111, -19.588312, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(127, 5, 50303, 'Tacobamba', -65.556473, -19.207012, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(128, 5, 50402, 'Ravelo', -65.511604, -18.806561, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(129, 5, 51201, 'Uyuni (Thola Pampa)', -66.823410, -20.460392, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(130, 5, 50403, 'Pocoata', -66.161697, -18.699707, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(131, 5, 50401, 'Colquechaca', -66.002174, -18.697067, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(132, 5, 50102, 'Tinquipaya', -65.820648, -19.221975, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(133, 5, 50104, 'Belén de Urmiri', -66.064285, -19.385654, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(134, 5, 50404, 'Ocuri', -65.795708, -18.841711, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(135, 5, 50101, 'Potosí', -65.754227, -19.580585, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(136, 5, 50103, 'Yocalla', -65.905502, -19.391342, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(137, 1, 10102, 'Yotala', -65.264381, -19.162085, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(138, 1, 10602, 'Yamparñez', -65.118103, -19.189121, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(139, 5, 50601, 'Cotagaita', -65.658485, -20.815552, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(140, 5, 51102, 'Caiza \"D\"', -65.654427, -20.007278, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(141, 5, 50602, 'Vitichi', -65.492897, -20.207605, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(142, 5, 51202, 'Tomave', -66.531471, -20.065035, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(143, 5, 51203, 'Porco', -65.988762, -19.798197, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(144, 5, 50802, 'Atocha', -66.219398, -20.932224, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(145, 6, 60502, 'Tomayapo (El Puente)', -65.206055, -21.231388, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(146, 1, 10701, 'Camargo', -65.210045, -20.640629, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(147, 1, 10901, 'Villa Abecia', -65.231010, -20.973969, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(148, 1, 10903, 'Las Carretas', -65.207184, -21.211126, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(149, 1, 10703, 'Incahuasi', -64.867332, -20.783701, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(150, 6, 60501, 'Villa San Lorenzo', -64.748856, -21.415304, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(151, 6, 60101, 'Tarija', -64.732903, -21.531616, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(152, 6, 60401, 'Uriondo', -64.663200, -21.697224, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(153, 5, 51601, 'San Agustín', -67.678314, -21.154865, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(154, 3, 30904, 'Vinto', -66.316452, -17.382402, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(155, 3, 30803, 'Tolata', -65.962601, -17.533909, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(156, 2, 20105, 'El Alto', -68.173393, -16.494680, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(157, 1, 10801, 'Villa Serrano', -64.323265, -19.123215, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(158, 1, 10601, 'Tarabuco', -64.915421, -19.181147, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(159, 1, 10401, 'Padilla', -64.301971, -19.307310, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(160, 1, 10502, 'San Pablo de Huacareta', -64.002739, -20.366776, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(161, 1, 10501, 'Monteagudo', -63.954765, -19.799892, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(162, 1, 10304, 'Icla (R.Mujia)', -64.793114, -19.363430, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(163, 1, 10301, 'Zudañez', -64.698898, -19.119781, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(164, 1, 10402, 'Tomina', -64.460602, -19.185425, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(165, 1, 10201, 'Villa Azurduy', -64.413589, -20.105652, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(166, 1, 10202, 'Tarvita (Villa Arias)', -64.483604, -19.926035, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(167, 7, 70704, 'Cuevo', -63.519657, -20.454203, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(168, 7, 70706, 'Camiri', -63.521580, -20.040155, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(169, 1, 11002, 'Huacaya', -63.664650, -20.743664, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(170, 7, 70701, 'Lagunillas', -63.674343, -19.650385, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(171, 1, 11001, 'Villa Vaca Guzmán (Muyupampa)', -63.748669, -19.893232, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(172, 1, 10405, 'El Villar', -64.309608, -19.628836, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(173, 1, 10403, 'Sopachuy', -64.474731, -19.487019, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(174, 1, 10404, 'Villa Alcalá', -64.389297, -19.366278, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(175, 3, 31203, 'Pocona', -65.419952, -17.675211, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(176, 3, 31601, 'Tiraque', -65.723633, -17.427383, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(177, 3, 31002, 'Colomi', -65.867577, -17.337830, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(178, 2, 20802, 'Guaqui', -68.836601, -16.598438, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(179, 2, 21203, 'Batallas', -68.531631, -16.299580, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(180, 2, 21201, 'Pucarani', -68.477478, -16.399271, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(181, 2, 20403, 'Puerto Carabuco', -69.063873, -15.758209, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(182, 2, 20202, 'Ancoraimes', -68.906967, -15.897133, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(183, 7, 70501, 'San Jose de Chiquitos', -60.741215, -17.845451, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(184, 7, 70502, 'Pailón', -62.717297, -17.660110, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(185, 7, 70103, 'Porongo (Ayacucho)', -63.308601, -17.852028, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(186, 7, 70201, 'Warnes', -63.164391, -17.509081, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(187, 2, 21204, 'Puerto Perez', -68.601044, -16.284859, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(188, 7, 71001, 'Montero', -63.256760, -17.341230, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(189, 2, 21703, 'Tito Yupanki', -68.954704, -16.188883, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(190, 2, 20201, 'Achacachi', -68.685280, -16.043287, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(191, 9, 90101, 'Cobija', -68.761124, -11.024813, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(192, 9, 90503, 'Santos Mercado', -66.212234, -10.494559, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(193, 7, 70301, 'San Ignacio de Velasco', -60.961941, -16.375376, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(194, 7, 71201, 'San Matías', -58.401066, -16.361483, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(195, 5, 51003, 'San Antonio de Esmoraca', -66.516830, -21.948069, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(196, 5, 51001, 'San Pablo de Lipez', -66.615952, -21.686037, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(197, 5, 50902, 'San Pedro de Quemes', -68.048775, -20.746504, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(198, 5, 51401, 'Llica', -68.248138, -19.851910, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(199, 4, 40902, 'Coipasa', -68.277710, -19.277662, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(200, 4, 40901, 'Sabaya', -68.372673, -19.015705, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(201, 4, 40401, 'Curahuara de Carangas', -68.410049, -17.842346, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(202, 2, 20305, 'Charaña', -69.446114, -17.593935, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(203, 2, 20303, 'Calacoto', -68.636368, -17.283192, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(204, 3, 30203, 'Omereque', -64.908379, -18.108286, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(205, 1, 10103, 'Poroma', -65.425041, -18.537912, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(206, 1, 10101, 'Sucre', -65.260170, -19.046520, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(207, 3, 31301, 'Mizque', -65.342834, -17.943033, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(208, 1, 10303, 'Villa Mojocoya', -64.617897, -18.763365, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(209, 7, 70705, 'Gutiérrez', -63.529610, -19.422655, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(210, 2, 20401, 'Puerto Acosta', -69.252205, -15.532981, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(211, 4, 40402, 'Turco', -68.193565, -18.180721, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(212, 3, 31201, 'Totora', -65.191162, -17.736504, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(213, 2, 20402, 'Mocomoco', -68.996391, -15.455732, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(214, 2, 20804, 'Desaguadero', -69.035324, -16.566492, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(215, 6, 60402, 'Yunchara', -65.229561, -21.821598, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(216, 6, 60202, 'Bermejo', -64.342461, -22.733068, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(217, 9, 90302, 'San Lorenzo', -66.979218, -11.888293, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(218, 9, 90301, 'Puerto Gonzales Moreno', -66.167046, -11.086631, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(219, 8, 80101, 'Trinidad', -64.901848, -14.835786, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(220, 8, 80201, 'Riberalta', -66.071503, -11.001756, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(221, 8, 80402, 'Exaltacion', -65.250404, -13.320076, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(222, 8, 80303, 'Santa Rosa', -66.791832, -14.079259, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(223, 8, 80301, 'Reyes', -67.336182, -14.296329, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(224, 8, 80202, 'Guayaramerín', -65.354652, -10.816499, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(225, 9, 90501, 'Nuevo Manoa (Nueva Esperanza)', -65.338570, -10.059200, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(226, 9, 90103, 'Bolpebra (Mukden)', -69.567314, -10.944688, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(227, 9, 90102, 'Porvenir', -68.687714, -11.237475, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(228, 9, 90203, 'Filadelfia', -68.762558, -11.347234, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(229, 9, 90201, 'Puerto Rico', -67.556198, -11.104636, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(230, 9, 90402, 'Ingavi (Humaita)', -66.449196, -10.816280, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(231, 9, 90502, 'Villa Nueva (Loma Alta)', -65.965149, -10.788186, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(232, 6, 60303, 'Villamontes', -63.474854, -21.260201, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(233, 9, 90104, 'Bella Flor', -67.791534, -11.124079, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(234, 9, 90401, 'Santa Rosa del Abuná', -67.447609, -10.619876, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(235, 8, 80703, 'Puerto Siles', -65.002258, -12.799330, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(236, 8, 80701, 'San Joaquín', -64.667854, -13.041123, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(237, 8, 80801, 'Magdalena', -64.054504, -13.262423, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(238, 8, 80702, 'San Ramón', -64.616821, -13.265578, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(239, 7, 71301, 'Comarapa', -64.526924, -17.915489, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(240, 3, 31205, 'Puerto Villarroel', -64.793327, -16.838793, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(241, 2, 21001, 'Inquisivi', -67.138329, -16.907745, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(242, 3, 31204, 'Chimore', -65.150917, -16.994429, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(243, 8, 80401, 'Santa Ana de Yacuma', -65.427345, -13.744248, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(244, 2, 22001, 'Caranavi', -67.566330, -15.833387, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(245, 3, 31003, 'Villa Tunari', -65.419601, -16.973047, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(246, 2, 21502, 'San Buenaventura', -67.536591, -14.438160, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(247, 8, 80304, 'Rurrenabaque', -67.528435, -14.441736, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(248, 8, 80302, 'San Borja', -66.747108, -14.858182, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(249, 2, 20701, 'Apolo', -68.418037, -14.717411, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(250, 7, 70401, 'Buena Vista', -63.659924, -17.459307, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(251, 7, 70403, 'Yapacaní', -63.883595, -17.401445, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(252, 7, 70602, 'Santa Rosa del Sara', -63.598709, -17.108944, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(253, 7, 70202, 'Okinawa Uno', -62.891872, -17.218294, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(254, 7, 71002, 'General Saavedra', -63.213223, -17.226377, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(255, 7, 71104, 'San Julián', -62.617943, -16.911787, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(256, 7, 71102, 'San Javier', -62.504379, -16.274157, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(257, 7, 70302, 'San Miguel de Velasco', -60.967068, -16.697680, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(258, 7, 70503, 'Robore', -59.756886, -18.332348, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(259, 8, 80102, 'San Javier', -64.880943, -14.599989, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(260, 7, 71503, 'El Puente', -62.910873, -16.328627, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(261, 8, 80602, 'San Andrés', -64.666183, -15.022869, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(262, 7, 71501, 'Ascención de Guarayos', -63.189964, -15.891756, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(263, 7, 71502, 'Urubicha', -63.083725, -15.628366, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(264, 8, 80501, 'San Ignacio', -65.637566, -14.996354, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(265, 8, 80601, 'Loreto', -64.760254, -15.193695, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(266, 3, 30202, 'Pasorapa', -64.674904, -18.321609, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(267, 3, 30301, 'Independencia', -66.817673, -17.083939, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(268, 3, 31101, 'Tapacarí', -66.616447, -17.521160, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(269, 2, 21004, 'Colquiri', -67.128677, -17.387684, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(270, 2, 21105, 'La Asunta', -67.194626, -16.124336, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(271, 3, 30302, 'Morochata', -66.531898, -17.234619, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(272, 5, 50801, 'Tupiza', -65.720024, -21.441338, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(273, 5, 51501, 'Villazón', -65.596535, -22.090181, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(274, 1, 10902, 'Culpina', -64.943382, -20.823511, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(275, 6, 60601, 'Entre Rios (La Moreta)', -64.171417, -21.526585, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(276, 5, 50301, 'Betanzos', -65.452866, -19.552891, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(277, 5, 51101, 'Puna', -65.506439, -19.795408, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(278, 6, 60302, 'Caraparí', -63.742386, -21.827824, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(279, 5, 51002, 'Mojinete', -66.241142, -21.765251, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(280, 1, 11003, 'Machareti', -63.361191, -20.814573, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(281, 9, 90202, 'San Pedro (Conquista)', -66.184525, -10.825059, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(282, 2, 21902, 'Catacora', -69.483261, -17.161013, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(283, 2, 21901, 'Santiago de Machaca', -69.193283, -17.066647, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(284, 2, 20702, 'Pelechuco', -69.070213, -14.820213, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(285, 6, 60201, 'Padcaya', -64.709145, -21.882231, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(286, 2, 21601, 'Charazani (Gral.Perez)', -68.994644, -15.177297, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(287, 6, 60301, 'Yacuiba', -63.677479, -22.012815, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(288, 7, 70702, 'Charagua', -63.198105, -19.790934, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(289, 7, 70801, 'Vallegrande', -64.105652, -18.488668, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(290, 7, 70703, 'Cabezas', -63.300095, -18.789459, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(291, 1, 10302, 'Presto', -64.936974, -18.930182, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(292, 3, 30201, 'Aiquile', -65.180077, -18.201712, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(293, 8, 80803, 'Huacaraje', -63.880199, -13.592809, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(294, 8, 80802, 'Baures', -63.695850, -13.655432, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(295, 7, 71402, 'Puerto Quijarro', -57.716282, -19.005688, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(296, 9, 90303, 'El Sena', -67.245789, -11.482950, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(297, 2, 21501, 'Ixiamas', -68.125137, -13.767800, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(298, 3, 31206, 'Entre Rios (Bulo Bulo)', -64.348381, -17.260000, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(299, 3, 31202, 'Pojo', -64.865646, -17.757582, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(300, 7, 70603, 'Colpa Belgica', -63.226501, -17.567177, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(301, 7, 70601, 'Portachuelo', -63.394318, -17.353106, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(302, 7, 71005, 'San Pedro', -63.480972, -16.826298, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(303, 7, 71003, 'Mineros', -63.231327, -17.118755, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(304, 7, 71004, 'Fernandez Alonso', -63.231392, -17.006203, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(305, 7, 71105, 'San Antonio de Lomerio', -61.809708, -16.768524, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(306, 7, 71103, 'San Ramón', -62.500076, -16.613611, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(307, 7, 71101, 'Concepción', -62.024639, -16.134516, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(308, 7, 71106, 'Cuatro Canadas', -62.557224, -17.266747, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(309, 2, 20607, 'Mapiri', -68.226822, -15.310308, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(310, 2, 20602, 'Guanay', -67.882629, -15.495947, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(311, 2, 20608, 'Teoponte', -67.817528, -15.495701, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(312, 2, 21104, 'Palos Blancos', -67.247986, -15.584800, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(313, 2, 20805, 'San Andrés de Machaca', -68.968605, -16.953402, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(314, 2, 20806, 'Jesús de Machaca', -68.807243, -16.744249, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(315, 2, 20801, 'Viacha', -68.301559, -16.653688, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(316, 4, 40101, 'Oruro', -67.112076, -17.967758, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(317, 4, 40102, 'Caracollo', -67.212708, -17.643246, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(318, 4, 40104, 'Paria', -67.021721, -17.817316, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(319, 7, 70404, 'San Juan', -63.849339, -17.291374, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(320, 7, 70402, 'San Carlos', -63.731564, -17.405582, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(321, 7, 71403, 'Carmen Rivero Torrez', -58.623997, -18.828262, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(322, 7, 71401, 'Puerto Suarez', -57.797626, -18.964560, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(323, 2, 21702, 'San Pedro de Tiquina', -68.853943, -16.221504, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(324, 2, 20807, 'Taraco', -68.859024, -16.456743, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(325, 2, 20803, 'Tiahuanacu', -68.681145, -16.552942, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(326, 5, 51402, 'Tahua', -67.692963, -19.889769, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(327, 2, 21701, 'Copacabana', -69.086937, -16.165466, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(328, 2, 20204, 'Huarina', -68.601593, -16.190739, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(329, 5, 51103, 'Ckochas', -65.274818, -19.637529, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(330, 2, 22002, 'Alto Beni', -67.449715, -15.545243, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(331, 3, 31602, 'Shinahota', -65.245338, -16.993587, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(332, 1, 10704, 'Villa Charcas', -64.886391, -20.724697, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(333, 5, 50204, 'Chuquihuta', -66.367989, -18.591984, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(334, 2, 20404, 'Humanata', -69.127098, -15.463802, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(335, 2, 20206, 'Huatajata', -68.696953, -16.210442, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(336, 2, 20203, 'Chua Cocani', -68.748863, -16.193457, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(337, 2, 20205, 'Santiago de Huata', -68.816620, -16.056849, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(338, 4, 40402, 'Turco', -67.941711, -18.012669, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(339, 3, 30303, 'Cocapata', -66.630066, -16.838026, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(340, 2, 20405, 'Escoma', -69.127090, -15.463802, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(341, 0, 32, 'BOLIVIA', 0.000000, 0.000000, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(342, 1, 1, 'Chuquisaca', 0.000000, 0.000000, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(343, 2, 2, 'La Paz', 0.000000, 0.000000, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(344, 3, 3, 'Cochabamba', 0.000000, 0.000000, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(345, 4, 4, 'Oruro', 0.000000, 0.000000, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(346, 5, 5, 'Potosi', 0.000000, 0.000000, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(347, 6, 6, 'Tarija', 0.000000, 0.000000, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(348, 7, 7, 'Santa Cruz', 0.000000, 0.000000, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(349, 8, 8, 'Beni', 0.000000, 0.000000, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30'),
(350, 9, 9, 'Pando', 0.000000, 0.000000, 'A', '2021-01-31 15:17:30', '2021-01-31 15:17:30');

-- --------------------------------------------------------

--
-- Table structure for table `hogares_nna`
--

CREATE TABLE `hogares_nna` (
  `relative` varchar(50) NOT NULL COMMENT 'unique',
  `users_sid` varchar(50) NOT NULL,
  `hogares_centro_id` varchar(50) NOT NULL COMMENT 'Related to centros',
  `nombres` varchar(100) NOT NULL,
  `nombre_convencional_id` smallint NOT NULL COMMENT 'SINO',
  `apellidos` varchar(100) DEFAULT NULL,
  `apellido_convencional_id` smallint NOT NULL COMMENT 'SINO',
  `sexo_id` smallint NOT NULL,
  `fecha_nacimiento` date NOT NULL,
  `fecha_nacimiento_convencional_id` smallint NOT NULL COMMENT 'SINO',
  `idioma_id` smallint DEFAULT NULL,
  `tipologia_id` smallint DEFAULT NULL,
  `fecha_ingreso` date NOT NULL,
  `hermanos_biologicos_dentro` tinyint DEFAULT '0',
  `hermanos_biologicos_fuera` tinyint DEFAULT '0',
  `hermanos_otro_centro` tinyint DEFAULT '0',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hogares_nna`
--

INSERT INTO `hogares_nna` (`relative`, `users_sid`, `hogares_centro_id`, `nombres`, `nombre_convencional_id`, `apellidos`, `apellido_convencional_id`, `sexo_id`, `fecha_nacimiento`, `fecha_nacimiento_convencional_id`, `idioma_id`, `tipologia_id`, `fecha_ingreso`, `hermanos_biologicos_dentro`, `hermanos_biologicos_fuera`, `hermanos_otro_centro`, `status`, `created_at`, `updated_at`) VALUES
('78a113f0-75bc-4cc6-a2bb-100578fede2c', '05f6481f-c7f3-4cdf-8d07-a99d76ad3fb2', '5173842c-314a-4dc0-8461-4f383409fdcd', 'GRECIA', 2, 'CABRERA', 2, 1, '2007-09-13', 1, 1, 7, '2021-06-02', 0, 0, 0, 'A', '2021-09-13 11:51:19', '2021-09-13 11:51:19');

-- --------------------------------------------------------

--
-- Table structure for table `hogares_nna_bonos`
--

CREATE TABLE `hogares_nna_bonos` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `hogares_nna_id` varchar(50) NOT NULL,
  `fecha_bono` date NOT NULL,
  `nombre_botno` varchar(200) NOT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `hogares_nna_fotografias`
--

CREATE TABLE `hogares_nna_fotografias` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `hogares_nna_id` varchar(50) NOT NULL,
  `fotografia` text NOT NULL,
  `perfil_id` smallint NOT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hogares_nna_fotografias`
--

INSERT INTO `hogares_nna_fotografias` (`relative`, `users_sid`, `hogares_nna_id`, `fotografia`, `perfil_id`, `status`, `created_at`, `updated_at`) VALUES
('81d815c8-9755-4ec9-b556-1c163d6be8f0', '05f6481f-c7f3-4cdf-8d07-a99d76ad3fb2', '78a113f0-75bc-4cc6-a2bb-100578fede2c', '1631549066-53637433666-78a113f0-75bc-4cc6-a2bb-100578fede2c.jpeg', 1, 'A', '2021-09-13 12:04:01', '2021-09-13 12:04:01');

-- --------------------------------------------------------

--
-- Table structure for table `hogares_nna_lugar_nacimiento`
--

CREATE TABLE `hogares_nna_lugar_nacimiento` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `hogares_nna_id` varchar(50) NOT NULL COMMENT 'related to hogares_nna',
  `pais_id` smallint DEFAULT NULL,
  `departamento_id` smallint NOT NULL,
  `provincia_id` smallint DEFAULT NULL,
  `municipio_id` smallint NOT NULL,
  `comunidad_zona` text,
  `distrito_id` smallint DEFAULT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `hogares_nna_lugar_procedencia_familia_oara`
--

CREATE TABLE `hogares_nna_lugar_procedencia_familia_oara` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `hogares_nna_id` varchar(50) NOT NULL COMMENT 'related to hogares_nna',
  `pais_id` smallint NOT NULL,
  `departamento_id` smallint DEFAULT NULL,
  `provincia_id` smallint DEFAULT NULL,
  `municipio_id` smallint DEFAULT NULL,
  `comunidad_zona` text,
  `distrito` text,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `hogares_nna_lugar_residencia_acogida`
--

CREATE TABLE `hogares_nna_lugar_residencia_acogida` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `hogares_nna_id` varchar(50) NOT NULL COMMENT 'related to hogares_nna',
  `pais_id` smallint NOT NULL,
  `departamento_id` smallint DEFAULT NULL,
  `provincia_id` smallint DEFAULT NULL,
  `municipio_id` smallint DEFAULT NULL,
  `comunidad_zona` text,
  `distrito` text,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `hogares_reintegracion_familiar`
--

CREATE TABLE `hogares_reintegracion_familiar` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `hogares_nna_id` varchar(50) NOT NULL,
  `hogares_familia_oara_id_1` varchar(50) NOT NULL COMMENT 'Familia OARA',
  `hogares_familia_oara_id_2` varchar(50) NOT NULL COMMENT 'Familia OARA',
  `detalles_frecuencia_contacto_id` smallint NOT NULL,
  `cuenta_orden_judicial_visitas_id` smallint NOT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hogares_reintegracion_familiar`
--

INSERT INTO `hogares_reintegracion_familiar` (`relative`, `users_sid`, `hogares_nna_id`, `hogares_familia_oara_id_1`, `hogares_familia_oara_id_2`, `detalles_frecuencia_contacto_id`, `cuenta_orden_judicial_visitas_id`, `status`, `created_at`, `updated_at`) VALUES
('28c2912e-1eda-475d-8ef6-61db95dd4b64', '05f6481f-c7f3-4cdf-8d07-a99d76ad3fb2', '78a113f0-75bc-4cc6-a2bb-100578fede2c', 'c461bb34-1431-46f6-bd12-cf3f350305d1', 'd9fded32-e334-4927-89e2-ede679414ae5', 3, 2, 'A', '2021-09-13 12:08:27', '2021-09-13 12:08:27');

-- --------------------------------------------------------

--
-- Table structure for table `hogares_reintegracion_familiar_area_social`
--

CREATE TABLE `hogares_reintegracion_familiar_area_social` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `hogares_nna_id` varchar(50) NOT NULL,
  `hogares_reintegracion_id` varchar(50) NOT NULL,
  `evaluacion_diagnostica` longtext NOT NULL,
  `evaluacion_documento_adjunto` text,
  `seguimiento_social` text NOT NULL,
  `coordinacion_interinstitucional` longtext NOT NULL,
  `familia_oara_tiene_diagnostico_id` smallint NOT NULL,
  `tipo_familia_id` smallint NOT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `hogares_reintegracion_familiar_desarrollo_socioeconomico`
--

CREATE TABLE `hogares_reintegracion_familiar_desarrollo_socioeconomico` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `hogares_nna_id` varchar(50) NOT NULL,
  `hogares_reintegracion_id` varchar(50) NOT NULL,
  `ocupacion_referente` text NOT NULL,
  `condiciones_vida_socioeconomicas_id` smallint NOT NULL,
  `estabilidad_vivienda_id` smallint NOT NULL,
  `ingreso_economico_id` smallint NOT NULL,
  `cantidad_ingreso_id` smallint NOT NULL,
  `fuentes_de_ingreso` text NOT NULL,
  `otras_fuentes_de_ingreso` text,
  `tipo_vivienda_id` smallint NOT NULL,
  `notas_sobre_vvienda` text,
  `vivienda_latitud` decimal(10,6) DEFAULT NULL,
  `vivienda_longitud` decimal(10,6) DEFAULT NULL,
  `croquis` text,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `hogares_reintegracion_familiar_educacion_referente`
--

CREATE TABLE `hogares_reintegracion_familiar_educacion_referente` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `hogares_nna_id` varchar(50) NOT NULL,
  `hogares_reintegracion_id` varchar(50) NOT NULL,
  `alfabetizado_id` smallint NOT NULL,
  `niveleducacionformal_id` smallint NOT NULL,
  `status` enum('A','X') NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `hogares_reintegracion_familiar_evaluacion_psicologica_del_nna`
--

CREATE TABLE `hogares_reintegracion_familiar_evaluacion_psicologica_del_nna` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `hogares_nna_id` varchar(50) NOT NULL,
  `hogares_reintegracion_id` varchar(50) NOT NULL,
  `deseo_vinculacion_id` smallint NOT NULL,
  `deseo_reintegracion_id` smallint NOT NULL,
  `archivo_adjunto` varchar(200) DEFAULT NULL,
  `conslusion_diagnostico` longtext NOT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `hogares_reintegracion_familiar_participacion_infantil`
--

CREATE TABLE `hogares_reintegracion_familiar_participacion_infantil` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `hogares_nna_id` varchar(50) NOT NULL,
  `hogares_reintegracion_id` varchar(50) NOT NULL,
  `participa_actividades_con_familiar_id` smallint NOT NULL,
  `detalles_de_participacion` longtext NOT NULL,
  `status` enum('A','X') NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `hogares_reintegracion_familiar_reinsercion_familiar`
--

CREATE TABLE `hogares_reintegracion_familiar_reinsercion_familiar` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `hogares_nna_id` varchar(50) NOT NULL,
  `hogares_reintegracion_id` varchar(50) NOT NULL,
  `fecha_salida` date NOT NULL,
  `evaluacion_dinamica_familiar` longtext NOT NULL,
  `familia_necesita_apoyo_id` smallint NOT NULL,
  `tipo_apoyo_necesita` longtext,
  `fortalecido_vinculo_emocional_id` smallint NOT NULL,
  `fecha_seguimiento` date NOT NULL,
  `se_coordino_dna_realizar_seguimiento_id` smallint DEFAULT NULL,
  `quien_realiza_seguimientos` varchar(200) DEFAULT NULL,
  `frecuencia_seguimientos` text,
  `acciones_realizadas_para_fortalecer` mediumtext,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `hogares_reintegracion_familiar_seguimiento`
--

CREATE TABLE `hogares_reintegracion_familiar_seguimiento` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `hogares_nna_id` varchar(50) NOT NULL,
  `hogares_reintegracion_id` varchar(50) NOT NULL,
  `post_reintegro_id` smallint NOT NULL,
  `responsable_seguimiento_id` smallint NOT NULL,
  `comentarios` longtext NOT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Stand-in structure for view `hogares_reintegracion_familia_oara_1`
-- (See below for the actual view)
--
CREATE TABLE `hogares_reintegracion_familia_oara_1` (
`hogares_familia_oara_id_1` varchar(50)
,`hogares_nna_id` varchar(50)
,`hogares_reintegracion_id` varchar(50)
,`nombres_y_apellidos` varchar(200)
,`relative` varchar(50)
,`status` enum('A','X')
);

-- --------------------------------------------------------

--
-- Stand-in structure for view `hogares_reintegracion_familia_oara_2`
-- (See below for the actual view)
--
CREATE TABLE `hogares_reintegracion_familia_oara_2` (
`hogares_familia_oara_id_2` varchar(50)
,`hogares_nna_id` varchar(50)
,`hogares_reintegracion_id` varchar(50)
,`nombres_y_apellidos` varchar(200)
,`relative` varchar(50)
,`status` enum('A','X')
);

-- --------------------------------------------------------

--
-- Stand-in structure for view `hogares_reintegracion_reintegrantes`
-- (See below for the actual view)
--
CREATE TABLE `hogares_reintegracion_reintegrantes` (
`hogares_nna_id` varchar(50)
,`hogares_reintegracion_id` varchar(50)
,`juntos` varchar(403)
,`nna` varchar(50)
,`primer_oara` varchar(200)
,`segundo_oara` varchar(200)
,`status` enum('A','X')
);

-- --------------------------------------------------------

--
-- Table structure for table `hogares_salud`
--

CREATE TABLE `hogares_salud` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `hogares_nna_id` varchar(50) NOT NULL,
  `fecha_revision_medica` date NOT NULL,
  `estado_nutricional` text NOT NULL,
  `estatura` decimal(6,2) NOT NULL,
  `imc` varchar(50) NOT NULL,
  `presenta_enfermedad` text NOT NULL,
  `tipo_de_enfermedad` text,
  `recibe_tratamiento` text,
  `vih_sida_id` smallint NOT NULL,
  `vih_tratamiento_id` smallint DEFAULT NULL,
  `discapacidad_id` smallint NOT NULL,
  `carnet_discapacitado_id` smallint DEFAULT NULL,
  `nivel_discapacidad` decimal(10,2) DEFAULT NULL,
  `tipo_discapacidad` text,
  `detalles_discapacidad` text,
  `recibe_atencion_discapacidad_id` smallint NOT NULL,
  `tipo_apoyo_discapacidad` text,
  `apoyo_brindado_por_discapacidad` text,
  `vacunacion` text,
  `medicacion_que_recibe` text,
  `antecedentes_salud` mediumtext,
  `antecedentes_psiquiatrico` mediumtext,
  `notas_salud_general` longtext,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `hogares_salud_documentos`
--

CREATE TABLE `hogares_salud_documentos` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `hogares_nna_id` varchar(50) NOT NULL,
  `titulo_documentos` text NOT NULL,
  `documento` text NOT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `hogares_situacion_legal_1`
--

CREATE TABLE `hogares_situacion_legal_1` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `hogares_nna_id` varchar(50) NOT NULL,
  `situacion_legal_uno_id` smallint NOT NULL,
  `fecha_inicio` date NOT NULL,
  `nro_resolucion` varchar(75) DEFAULT NULL,
  `fecha_resolucion` date DEFAULT NULL,
  `nro_nurej` varchar(100) DEFAULT NULL,
  `publicacion_edictos_sentencias` text,
  `estado_situacion_legal_id` smallint NOT NULL,
  `adjuntos` text,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hogares_situacion_legal_1`
--

INSERT INTO `hogares_situacion_legal_1` (`relative`, `users_sid`, `hogares_nna_id`, `situacion_legal_uno_id`, `fecha_inicio`, `nro_resolucion`, `fecha_resolucion`, `nro_nurej`, `publicacion_edictos_sentencias`, `estado_situacion_legal_id`, `adjuntos`, `status`, `created_at`, `updated_at`) VALUES
('fb66bbfa-d6da-4d8d-8357-8342f83fe347', '05f6481f-c7f3-4cdf-8d07-a99d76ad3fb2', '78a113f0-75bc-4cc6-a2bb-100578fede2c', 7, '2021-09-01', 'R2021-0012', '2021-09-02', 'NUREJ-0012', 'Edicto N~12', 1, NULL, 'A', '2021-09-13 11:59:08', '2021-09-13 11:59:08');

-- --------------------------------------------------------

--
-- Table structure for table `hogares_situacion_legal_2`
--

CREATE TABLE `hogares_situacion_legal_2` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `hogares_nna_id` varchar(50) NOT NULL,
  `situacion_legal_dos_id` smallint NOT NULL,
  `fecha_inicio` date NOT NULL,
  `estado_situacion_legal_id` smallint NOT NULL,
  `adjuntos` text,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `hogares_situacion_legal_3`
--

CREATE TABLE `hogares_situacion_legal_3` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `hogares_nna_id` varchar(50) NOT NULL,
  `situacion_legal_tres_id` smallint NOT NULL,
  `fecha_inicio` date NOT NULL,
  `estado_situacion_legal_id` smallint NOT NULL,
  `adjuntos` text,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `hogares_situacion_legal_documentos`
--

CREATE TABLE `hogares_situacion_legal_documentos` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `hogares_nna_id` varchar(50) NOT NULL,
  `titulo_documentos` text NOT NULL,
  `documento` text NOT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `hogares_vulneracion_derechos_en_el_centro`
--

CREATE TABLE `hogares_vulneracion_derechos_en_el_centro` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `hogares_nna_id` varchar(50) NOT NULL,
  `sufrio_alguna_desproteccion_id` smallint NOT NULL,
  `tipo_desproteccion_id` smallint DEFAULT NULL,
  `situacion_desproteccion_id` smallint NOT NULL,
  `violencia_abuso_nna_confirmado_id` smallint NOT NULL,
  `factores_riesgo` text,
  `acciones_realizadas` text,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `hogares_vulneracion_derechos_en_el_centro_documentos`
--

CREATE TABLE `hogares_vulneracion_derechos_en_el_centro_documentos` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `hogares_nna_id` varchar(50) NOT NULL,
  `titulo_documentos` text NOT NULL,
  `documento` text NOT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `watchdog`
--

CREATE TABLE `watchdog` (
  `id` int NOT NULL COMMENT 'Primary Key: Unique watchdog event ID.',
  `users_sid` varchar(50) DEFAULT NULL COMMENT 'The users.uid of the user who triggered the event.',
  `type` varchar(64) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'Type of log message, for example "user" or "page not found."',
  `message` longtext NOT NULL COMMENT 'Text of log message to be passed into the t() function.',
  `variables` longblob COMMENT 'Serialized array of variables that match the message string and that is passed into the t() function.',
  `severity` tinyint UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The severity level of the event. ranges from 0 (Emergency) to 7 (Debug)',
  `link` text COMMENT 'Link to view the result of the event.',
  `location` text NOT NULL COMMENT 'URL of the origin of the event.',
  `referer` text COMMENT 'URL of referring page.',
  `hostname` varchar(128) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'Hostname of the user who triggered the event.',
  `created_at` datetime DEFAULT NULL COMMENT 'When the user were created',
  `updated_at` datetime DEFAULT NULL COMMENT 'When the user were updated'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Table that contains logs of all system events.';

-- --------------------------------------------------------

--
-- Structure for view `hogares_reintegracion_familia_oara_1`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `hogares_reintegracion_familia_oara_1`  AS SELECT `hogares_familia_oara`.`relative` AS `relative`, `hogares_familia_oara`.`nombres_y_apellidos` AS `nombres_y_apellidos`, `hogares_reintegracion_familiar`.`hogares_familia_oara_id_1` AS `hogares_familia_oara_id_1`, `hogares_reintegracion_familiar`.`hogares_nna_id` AS `hogares_nna_id`, `hogares_reintegracion_familiar`.`relative` AS `hogares_reintegracion_id`, `hogares_familia_oara`.`status` AS `status` FROM (`hogares_familia_oara` join `hogares_reintegracion_familiar`) WHERE (`hogares_reintegracion_familiar`.`hogares_familia_oara_id_1` = `hogares_familia_oara`.`relative`)  ;

-- --------------------------------------------------------

--
-- Structure for view `hogares_reintegracion_familia_oara_2`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `hogares_reintegracion_familia_oara_2`  AS SELECT `hogares_familia_oara`.`relative` AS `relative`, `hogares_familia_oara`.`nombres_y_apellidos` AS `nombres_y_apellidos`, `hogares_reintegracion_familiar`.`hogares_familia_oara_id_2` AS `hogares_familia_oara_id_2`, `hogares_reintegracion_familiar`.`hogares_nna_id` AS `hogares_nna_id`, `hogares_reintegracion_familiar`.`relative` AS `hogares_reintegracion_id`, `hogares_familia_oara`.`status` AS `status` FROM (`hogares_familia_oara` join `hogares_reintegracion_familiar`) WHERE (`hogares_reintegracion_familiar`.`hogares_familia_oara_id_2` = `hogares_familia_oara`.`relative`)  ;

-- --------------------------------------------------------

--
-- Structure for view `hogares_reintegracion_reintegrantes`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `hogares_reintegracion_reintegrantes`  AS SELECT DISTINCT `a`.`hogares_nna_id` AS `nna`, `a`.`hogares_nna_id` AS `hogares_nna_id`, `a`.`hogares_reintegracion_id` AS `hogares_reintegracion_id`, `a`.`nombres_y_apellidos` AS `primer_oara`, `b`.`nombres_y_apellidos` AS `segundo_oara`, `a`.`status` AS `status`, concat(`a`.`nombres_y_apellidos`,' y ',`b`.`nombres_y_apellidos`) AS `juntos` FROM (`hogares_reintegracion_familia_oara_1` `a` join `hogares_reintegracion_familia_oara_2` `b`) WHERE (`a`.`hogares_nna_id` = `b`.`hogares_nna_id`)  ;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `hogares_acogida_documentos`
--
ALTER TABLE `hogares_acogida_documentos`
  ADD UNIQUE KEY `hogares_documentacion_acogida_documentos.relative` (`relative`) USING BTREE;

--
-- Indexes for table `hogares_area_psicologica`
--
ALTER TABLE `hogares_area_psicologica`
  ADD UNIQUE KEY `hogares_area_psicologica.relative` (`relative`);

--
-- Indexes for table `hogares_area_psicologica_documentos`
--
ALTER TABLE `hogares_area_psicologica_documentos`
  ADD UNIQUE KEY `hogares_situacion_legal_documentos.relative` (`relative`);

--
-- Indexes for table `hogares_area_psicologica_seguimiento`
--
ALTER TABLE `hogares_area_psicologica_seguimiento`
  ADD UNIQUE KEY `hogares_area_psicologica_seguimiento.relative` (`relative`);

--
-- Indexes for table `hogares_area_social`
--
ALTER TABLE `hogares_area_social`
  ADD UNIQUE KEY `hogares_area_social.relative` (`relative`);

--
-- Indexes for table `hogares_area_social_documentos`
--
ALTER TABLE `hogares_area_social_documentos`
  ADD UNIQUE KEY `hogares_situacion_legal_documentos.relative` (`relative`);

--
-- Indexes for table `hogares_area_social_seguimiento`
--
ALTER TABLE `hogares_area_social_seguimiento`
  ADD UNIQUE KEY `hogares_area_social_seguimiento.relative` (`relative`);

--
-- Indexes for table `hogares_bienes_nna`
--
ALTER TABLE `hogares_bienes_nna`
  ADD UNIQUE KEY `hogares_bienes_nna.relative` (`relative`);

--
-- Indexes for table `hogares_bienes_nna_documentos`
--
ALTER TABLE `hogares_bienes_nna_documentos`
  ADD UNIQUE KEY `hogares_bienes_nna.relative` (`relative`) USING BTREE;

--
-- Indexes for table `hogares_caracteristicas_acogida`
--
ALTER TABLE `hogares_caracteristicas_acogida`
  ADD UNIQUE KEY `hogares_caracteristicas_acogida.relative` (`relative`);

--
-- Indexes for table `hogares_caracteristicas_acogida_documentos`
--
ALTER TABLE `hogares_caracteristicas_acogida_documentos`
  ADD UNIQUE KEY `hogares_caracteristicas_acogida_documentos.relative` (`relative`) USING BTREE;

--
-- Indexes for table `hogares_catalogs`
--
ALTER TABLE `hogares_catalogs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `hogares_catalog_items`
--
ALTER TABLE `hogares_catalog_items`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `hogares_centro`
--
ALTER TABLE `hogares_centro`
  ADD UNIQUE KEY `hogares_centro.relative` (`relative`);

--
-- Indexes for table `hogares_departamento`
--
ALTER TABLE `hogares_departamento`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `hogares_desinstitucionalizacion`
--
ALTER TABLE `hogares_desinstitucionalizacion`
  ADD UNIQUE KEY `hogares_desinstitucionalizacion.relative` (`relative`);

--
-- Indexes for table `hogares_documentacion_acogida`
--
ALTER TABLE `hogares_documentacion_acogida`
  ADD UNIQUE KEY `hogares_documentacion_acogida.relative` (`relative`);

--
-- Indexes for table `hogares_educacion`
--
ALTER TABLE `hogares_educacion`
  ADD UNIQUE KEY `hogares_educacion.relative` (`relative`);

--
-- Indexes for table `hogares_familia_oara`
--
ALTER TABLE `hogares_familia_oara`
  ADD UNIQUE KEY `hogares_familia_oara.relative` (`relative`);

--
-- Indexes for table `hogares_familia_oara_area_psicologica`
--
ALTER TABLE `hogares_familia_oara_area_psicologica`
  ADD UNIQUE KEY `hogares_familia_oara_area_psicologica.relative` (`relative`);

--
-- Indexes for table `hogares_familia_oara_area_social`
--
ALTER TABLE `hogares_familia_oara_area_social`
  ADD UNIQUE KEY `hogares_familia_oara_area_social.relative` (`relative`);

--
-- Indexes for table `hogares_familia_oara_area_social_seguimiento`
--
ALTER TABLE `hogares_familia_oara_area_social_seguimiento`
  ADD UNIQUE KEY `hogares_familia_oara_area_social_seguimiento.relative` (`relative`);

--
-- Indexes for table `hogares_familia_oara_documentos`
--
ALTER TABLE `hogares_familia_oara_documentos`
  ADD UNIQUE KEY `hogares_bienes_nna.relative` (`relative`) USING BTREE;

--
-- Indexes for table `hogares_momento_acogida`
--
ALTER TABLE `hogares_momento_acogida`
  ADD UNIQUE KEY `hogares_momento_acogida.relative` (`relative`);

--
-- Indexes for table `hogares_motivo_acogida`
--
ALTER TABLE `hogares_motivo_acogida`
  ADD UNIQUE KEY `hogares_motivo_acogida.relative` (`relative`);

--
-- Indexes for table `hogares_municipio`
--
ALTER TABLE `hogares_municipio`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `hogares_nna`
--
ALTER TABLE `hogares_nna`
  ADD UNIQUE KEY `hogares_nna.relative` (`relative`);

--
-- Indexes for table `hogares_nna_bonos`
--
ALTER TABLE `hogares_nna_bonos`
  ADD UNIQUE KEY `hogares_nna_bonos.relative` (`relative`);

--
-- Indexes for table `hogares_nna_fotografias`
--
ALTER TABLE `hogares_nna_fotografias`
  ADD UNIQUE KEY `hogares_nna_fotografias.relative` (`relative`);

--
-- Indexes for table `hogares_nna_lugar_nacimiento`
--
ALTER TABLE `hogares_nna_lugar_nacimiento`
  ADD UNIQUE KEY `hogares_nna_lugar_nacimiento.relative` (`relative`);

--
-- Indexes for table `hogares_nna_lugar_procedencia_familia_oara`
--
ALTER TABLE `hogares_nna_lugar_procedencia_familia_oara`
  ADD UNIQUE KEY `hogares_nna_lugar_procedencia_familia_oara.relative` (`relative`) USING BTREE;

--
-- Indexes for table `hogares_nna_lugar_residencia_acogida`
--
ALTER TABLE `hogares_nna_lugar_residencia_acogida`
  ADD UNIQUE KEY `hogares_nna_lugar_residencia_acogida.relative` (`relative`) USING BTREE;

--
-- Indexes for table `hogares_reintegracion_familiar`
--
ALTER TABLE `hogares_reintegracion_familiar`
  ADD UNIQUE KEY `hogares_reintegracion_familiar.relative` (`relative`);

--
-- Indexes for table `hogares_reintegracion_familiar_area_social`
--
ALTER TABLE `hogares_reintegracion_familiar_area_social`
  ADD UNIQUE KEY `hogares_reintegracion_familiar_area_social.relative` (`relative`);

--
-- Indexes for table `hogares_reintegracion_familiar_desarrollo_socioeconomico`
--
ALTER TABLE `hogares_reintegracion_familiar_desarrollo_socioeconomico`
  ADD UNIQUE KEY `hogares_reintegracion_familiar_desarrollo_socioeconomico.relativ` (`relative`);

--
-- Indexes for table `hogares_reintegracion_familiar_educacion_referente`
--
ALTER TABLE `hogares_reintegracion_familiar_educacion_referente`
  ADD UNIQUE KEY `hogares_reintegracion_familiar_educacion_referente.relative` (`relative`);

--
-- Indexes for table `hogares_reintegracion_familiar_evaluacion_psicologica_del_nna`
--
ALTER TABLE `hogares_reintegracion_familiar_evaluacion_psicologica_del_nna`
  ADD UNIQUE KEY `hogares_reintegracion_familiar_evaluacion_psicologica.relative` (`relative`);

--
-- Indexes for table `hogares_reintegracion_familiar_participacion_infantil`
--
ALTER TABLE `hogares_reintegracion_familiar_participacion_infantil`
  ADD UNIQUE KEY `hogares_reintegracion_familiar_participacion_infantil.relative` (`relative`);

--
-- Indexes for table `hogares_reintegracion_familiar_reinsercion_familiar`
--
ALTER TABLE `hogares_reintegracion_familiar_reinsercion_familiar`
  ADD UNIQUE KEY `hogares_reintegracion_familiar_reinsercion_familiar.relative` (`relative`);

--
-- Indexes for table `hogares_reintegracion_familiar_seguimiento`
--
ALTER TABLE `hogares_reintegracion_familiar_seguimiento`
  ADD UNIQUE KEY `hogares_reintegracion_familiar_seguimiento.relative` (`relative`);

--
-- Indexes for table `hogares_salud`
--
ALTER TABLE `hogares_salud`
  ADD UNIQUE KEY `hogares_salud.relative` (`relative`);

--
-- Indexes for table `hogares_salud_documentos`
--
ALTER TABLE `hogares_salud_documentos`
  ADD UNIQUE KEY `hogares_salud.relative` (`relative`) USING BTREE;

--
-- Indexes for table `hogares_situacion_legal_1`
--
ALTER TABLE `hogares_situacion_legal_1`
  ADD UNIQUE KEY `hogares_situacion_legal_1.relative` (`relative`);

--
-- Indexes for table `hogares_situacion_legal_2`
--
ALTER TABLE `hogares_situacion_legal_2`
  ADD UNIQUE KEY `hogares_situacion_legal_2.relative` (`relative`) USING BTREE;

--
-- Indexes for table `hogares_situacion_legal_3`
--
ALTER TABLE `hogares_situacion_legal_3`
  ADD UNIQUE KEY `hogares_situacion_legal_3.relative` (`relative`) USING BTREE;

--
-- Indexes for table `hogares_situacion_legal_documentos`
--
ALTER TABLE `hogares_situacion_legal_documentos`
  ADD UNIQUE KEY `hogares_situacion_legal_documentos.relative` (`relative`);

--
-- Indexes for table `hogares_vulneracion_derechos_en_el_centro`
--
ALTER TABLE `hogares_vulneracion_derechos_en_el_centro`
  ADD UNIQUE KEY `hogares_vulneracion_derechos_en_el_centro.relative` (`relative`);

--
-- Indexes for table `hogares_vulneracion_derechos_en_el_centro_documentos`
--
ALTER TABLE `hogares_vulneracion_derechos_en_el_centro_documentos`
  ADD UNIQUE KEY `hogares_vulneracion_derechos_en_el_centro_documentos.relative` (`relative`) USING BTREE;

--
-- Indexes for table `watchdog`
--
ALTER TABLE `watchdog`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `hogares_catalog_items`
--
ALTER TABLE `hogares_catalog_items`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=289;

--
-- AUTO_INCREMENT for table `hogares_departamento`
--
ALTER TABLE `hogares_departamento`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;

--
-- AUTO_INCREMENT for table `hogares_municipio`
--
ALTER TABLE `hogares_municipio`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=351;

--
-- AUTO_INCREMENT for table `watchdog`
--
ALTER TABLE `watchdog`
  MODIFY `id` int NOT NULL AUTO_INCREMENT COMMENT 'Primary Key: Unique watchdog event ID.';
COMMIT;

