The UN Social Cohesion and Reconciliation Index for Eastern Ukraine (USE) is an analytical tool designed to improve the understanding of societal dynamics in government-controlled areas (GCA) of Donetsk and Luhansk oblasts, and neighboring Dnipropetrovsk, Kharkiv and Zaporizhzhia oblasts. This helps to identify strategic entry points for policies and programs that contribute to strengthening social cohesion.
USE is based on the Social Cohesion and Reconciliation (SCORE) Index methodology, originally developed in Cyprus by the Centre for Sustainable Peace and Democratic Development (SeeD) and UNDP. The SCORE Index has since been implemented across several countries in Europe and elsewhere to assist international and national stakeholders in the design of evidence-based solutions that can contribute to strengthening social cohesion and reconciliation efforts.
USE is jointly implemented by three UN entities – UNDP, UNICEF, and IOM. The first USE wave was conducted in 2017 and was funded by the UN, with a major contribution from the EU.
No post data.
Query | Affected | Num. rows | Took (ms) | Actions |
---|---|---|---|---|
SELECT `Country`.`id`, `Country`.`weight`, `Country`.`name`, `Country`.`url_param`, `Country`.`title`, `Country`.`code`, `Country`.`show_pages`, `Country`.`keywords`, `Country`.`description`, `Country`.`parent_id`, `Country`.`default_lang`, `Country`.`in_menu`, `Country`.`map_colour`, `Country`.`doc_dir`, `Country`.`analysis`, `Country`.`data_translations`, `Country`.`created`, `Country`.`modified`, `Country`.`shapefile`, `Country`.`svg_map`, `Country`.`base_map_colour`, `Country`.`is_published`, `Country`.`is_deleted`, `Country`.`hide_explore`, `Country`.`hide_panels`, `Country`.`logos` FROM `score-1`.`countries` AS `Country` WHERE `Country`.`url_param` = 'use' LIMIT 1 | 1 | 1 | 3 | maybe slow |
SELECT `Year`.`id`, `Year`.`country_id`, `Year`.`data_stream_id`, `Year`.`related_datasets`, `Year`.`map_id`, `Year`.`language_id`, `Year`.`year`, `Year`.`created`, `Year`.`modified`, `Year`.`is_published` FROM `score-1`.`years` AS `Year` WHERE `Year`.`country_id` = (33) | 5 | 5 | 0 | |
SELECT `CountryLanguage`.`id`, `CountryLanguage`.`country_id`, `CountryLanguage`.`language_id` FROM `score-1`.`countries_languages` AS `CountryLanguage` WHERE `CountryLanguage`.`country_id` = (33) | 3 | 3 | 0 | |
SELECT `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`datasets` AS `Dataset` WHERE `Dataset`.`country` = (33) ORDER BY `Dataset`.`year` DESC | 57 | 57 | 1 | |
SELECT `Language`.`id`, `Language`.`language`, `Language`.`name`, `Language`.`code`, `Language`.`created`, `Language`.`modified`, `CountriesLanguage`.`id`, `CountriesLanguage`.`country_id`, `CountriesLanguage`.`language_id` FROM `score-1`.`languages` AS `Language` JOIN `score-1`.`countries_languages` AS `CountriesLanguage` ON (`CountriesLanguage`.`country_id` = 33 AND `CountriesLanguage`.`language_id` = `Language`.`id`) | 3 | 3 | 0 | |
SELECT `CountryLanguage`.`id`, `CountryLanguage`.`country_id`, `CountryLanguage`.`language_id`, `Language`.`id`, `Language`.`language`, `Language`.`name`, `Language`.`code`, `Language`.`created`, `Language`.`modified` FROM `score-1`.`countries_languages` AS `CountryLanguage` LEFT JOIN `score-1`.`languages` AS `Language` ON (`CountryLanguage`.`language_id` = `Language`.`id`) WHERE `CountryLanguage`.`country_id` = 33 | 3 | 3 | 0 | |
SELECT `Country`.`url_param`, `Country`.`name`, `Country`.`id` FROM `score-1`.`countries` AS `Country` WHERE `Country`.`in_menu` = '1' AND `Country`.`is_published` = '1' ORDER BY `Country`.`weight` ASC | 9 | 9 | 0 | |
SELECT Country.id,Country.keywords,Country.description,Country.name,Country.title,Country.logos,Country.data_translations,Country.show_pages,Country.parent_id,Country.svg_map, `Country`.`id` FROM `score-1`.`countries` AS `Country` WHERE ((`Country`.`id` IS NULL) OR (`Country`.`url_param` = 'use')) LIMIT 1 | 1 | 1 | 1 | |
SELECT `Year`.`id`, `Year`.`country_id`, `Year`.`data_stream_id`, `Year`.`related_datasets`, `Year`.`map_id`, `Year`.`language_id`, `Year`.`year`, `Year`.`created`, `Year`.`modified`, `Year`.`is_published` FROM `score-1`.`years` AS `Year` WHERE `Year`.`country_id` = (33) | 5 | 5 | 0 | |
SELECT `CountryLanguage`.`id`, `CountryLanguage`.`country_id`, `CountryLanguage`.`language_id` FROM `score-1`.`countries_languages` AS `CountryLanguage` WHERE `CountryLanguage`.`country_id` = (33) | 3 | 3 | 0 | |
SELECT `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`datasets` AS `Dataset` WHERE `Dataset`.`country` = (33) ORDER BY `Dataset`.`year` DESC | 57 | 57 | 0 | |
SELECT `Language`.`id`, `Language`.`language`, `Language`.`name`, `Language`.`code`, `Language`.`created`, `Language`.`modified`, `CountriesLanguage`.`id`, `CountriesLanguage`.`country_id`, `CountriesLanguage`.`language_id` FROM `score-1`.`languages` AS `Language` JOIN `score-1`.`countries_languages` AS `CountriesLanguage` ON (`CountriesLanguage`.`country_id` = 33 AND `CountriesLanguage`.`language_id` = `Language`.`id`) | 3 | 3 | 0 | |
SELECT `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards`, `Source`.`id`, `Source`.`url`, `Source`.`html`, `Source`.`source`, `Source`.`name`, `Source`.`type`, (url) AS `Source__source_path` FROM `score-1`.`datasets` AS `Dataset` LEFT JOIN `score-1`.`sources` AS `Source` ON (`Dataset`.`source_id` = `Source`.`id`) WHERE `country` = 33 AND `Source`.`type` = 'data_translations' ORDER BY `Source`.`id` DESC LIMIT 1 | 1 | 1 | 3 | maybe slow |
SELECT `Country`.`id`, `Country`.`name`, `Country`.`url_param`, `Country`.`parent_id` FROM `score-1`.`countries` AS `Country` WHERE `Country`.`parent_id` = 33 | 2 | 2 | 0 | |
SELECT `Country`.`id`, `Country`.`weight`, `Country`.`name`, `Country`.`url_param`, `Country`.`title`, `Country`.`code`, `Country`.`show_pages`, `Country`.`keywords`, `Country`.`description`, `Country`.`parent_id`, `Country`.`default_lang`, `Country`.`in_menu`, `Country`.`map_colour`, `Country`.`doc_dir`, `Country`.`analysis`, `Country`.`data_translations`, `Country`.`created`, `Country`.`modified`, `Country`.`shapefile`, `Country`.`svg_map`, `Country`.`base_map_colour`, `Country`.`is_published`, `Country`.`is_deleted`, `Country`.`hide_explore`, `Country`.`hide_panels`, `Country`.`logos` FROM `score-1`.`countries` AS `Country` WHERE `Country`.`url_param` = 'use' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Year`.`id`, `Year`.`country_id`, `Year`.`data_stream_id`, `Year`.`related_datasets`, `Year`.`map_id`, `Year`.`language_id`, `Year`.`year`, `Year`.`created`, `Year`.`modified`, `Year`.`is_published` FROM `score-1`.`years` AS `Year` WHERE `Year`.`country_id` = (33) | 5 | 5 | 0 | |
SELECT `CountryLanguage`.`id`, `CountryLanguage`.`country_id`, `CountryLanguage`.`language_id` FROM `score-1`.`countries_languages` AS `CountryLanguage` WHERE `CountryLanguage`.`country_id` = (33) | 3 | 3 | 0 | |
SELECT `Dataset`.`id`, `Dataset`.`settings`, `Dataset`.`source_id`, `Dataset`.`map_id`, `Dataset`.`country`, `Dataset`.`country_name`, `Dataset`.`year`, `Dataset`.`year_id`, `Dataset`.`data_stream`, `Dataset`.`data_stream_name`, `Dataset`.`lang`, `Dataset`.`region`, `Dataset`.`dimension`, `Dataset`.`indicator`, `Dataset`.`subindicator`, `Dataset`.`of`, `Dataset`.`towards` FROM `score-1`.`datasets` AS `Dataset` WHERE `Dataset`.`country` = (33) ORDER BY `Dataset`.`year` DESC | 57 | 57 | 0 | |
SELECT `Language`.`id`, `Language`.`language`, `Language`.`name`, `Language`.`code`, `Language`.`created`, `Language`.`modified`, `CountriesLanguage`.`id`, `CountriesLanguage`.`country_id`, `CountriesLanguage`.`language_id` FROM `score-1`.`languages` AS `Language` JOIN `score-1`.`countries_languages` AS `CountriesLanguage` ON (`CountriesLanguage`.`country_id` = 33 AND `CountriesLanguage`.`language_id` = `Language`.`id`) | 3 | 3 | 0 | |
SELECT `SimplePage`.`id`, `SimplePage`.`country_id`, `SimplePage`.`code`, `SimplePage`.`title`, `SimplePage`.`key`, `SimplePage`.`content`, `SimplePage`.`created`, `SimplePage`.`modified`, `SimplePage`.`is_active`, `SimplePage`.`keywords`, `SimplePage`.`description`, (`I18n__contentTranslation`.`content`) AS `SimplePage__i18n_contentTranslation`, (`I18n__titleTranslation`.`content`) AS `SimplePage__i18n_titleTranslation`, (`I18n__keywordsTranslation`.`content`) AS `SimplePage__i18n_keywordsTranslation`, (`I18n__descriptionTranslation`.`content`) AS `SimplePage__i18n_descriptionTranslation`, `Country`.`id`, `Country`.`weight`, `Country`.`name`, `Country`.`url_param`, `Country`.`title`, `Country`.`code`, `Country`.`show_pages`, `Country`.`keywords`, `Country`.`description`, `Country`.`parent_id`, `Country`.`default_lang`, `Country`.`in_menu`, `Country`.`map_colour`, `Country`.`doc_dir`, `Country`.`analysis`, `Country`.`data_translations`, `Country`.`created`, `Country`.`modified`, `Country`.`shapefile`, `Country`.`svg_map`, `Country`.`base_map_colour`, `Country`.`is_published`, `Country`.`is_deleted`, `Country`.`hide_explore`, `Country`.`hide_panels`, `Country`.`logos` FROM `score-1`.`simple_pages` AS `SimplePage` LEFT JOIN `score-1`.`countries` AS `Country` ON (`SimplePage`.`country_id` = `Country`.`id`) INNER JOIN `score-1`.`i18n` AS `I18n__contentTranslation` ON (`SimplePage`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'SimplePage' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'en') INNER JOIN `score-1`.`i18n` AS `I18n__titleTranslation` ON (`SimplePage`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'SimplePage' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'en') INNER JOIN `score-1`.`i18n` AS `I18n__keywordsTranslation` ON (`SimplePage`.`id` = `I18n__keywordsTranslation`.`foreign_key` AND `I18n__keywordsTranslation`.`model` = 'SimplePage' AND `I18n__keywordsTranslation`.`field` = 'keywords' AND `I18n__keywordsTranslation`.`locale` = 'en') INNER JOIN `score-1`.`i18n` AS `I18n__descriptionTranslation` ON (`SimplePage`.`id` = `I18n__descriptionTranslation`.`foreign_key` AND `I18n__descriptionTranslation`.`model` = 'SimplePage' AND `I18n__descriptionTranslation`.`field` = 'description' AND `I18n__descriptionTranslation`.`locale` = 'en') WHERE `SimplePage`.`code` = 'about' AND `SimplePage`.`country_id` = 33 LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `contentTranslation`.`id`, `contentTranslation`.`locale`, `contentTranslation`.`model`, `contentTranslation`.`foreign_key`, `contentTranslation`.`field`, `contentTranslation`.`content` FROM `score-1`.`i18n` AS `contentTranslation` WHERE `model` = 'SimplePage' AND `field` = 'content' AND `contentTranslation`.`foreign_key` = (45) | 3 | 3 | 0 | |
SELECT `titleTranslation`.`id`, `titleTranslation`.`locale`, `titleTranslation`.`model`, `titleTranslation`.`foreign_key`, `titleTranslation`.`field`, `titleTranslation`.`content` FROM `score-1`.`i18n` AS `titleTranslation` WHERE `model` = 'SimplePage' AND `field` = 'title' AND `titleTranslation`.`foreign_key` = (45) | 3 | 3 | 0 | |
SELECT `keywordsTranslation`.`id`, `keywordsTranslation`.`locale`, `keywordsTranslation`.`model`, `keywordsTranslation`.`foreign_key`, `keywordsTranslation`.`field`, `keywordsTranslation`.`content` FROM `score-1`.`i18n` AS `keywordsTranslation` WHERE `model` = 'SimplePage' AND `field` = 'keywords' AND `keywordsTranslation`.`foreign_key` = (45) | 3 | 3 | 0 | |
SELECT `descriptionTranslation`.`id`, `descriptionTranslation`.`locale`, `descriptionTranslation`.`model`, `descriptionTranslation`.`foreign_key`, `descriptionTranslation`.`field`, `descriptionTranslation`.`content` FROM `score-1`.`i18n` AS `descriptionTranslation` WHERE `model` = 'SimplePage' AND `field` = 'description' AND `descriptionTranslation`.`foreign_key` = (45) | 3 | 3 | 0 |
Peak Memory Use 10.11 MB
Message | Memory use |
---|---|
Component initialization | 1.59 MB |
Controller action start | 3.49 MB |
Controller render start | 3.77 MB |
View render complete | 4.15 MB |
Total Request Time: 107 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 3.65 | |
Event: Controller.initialize | 33.81 | |
Event: Controller.startup | 0.45 | |
Controller action | 10.92 | |
Event: Controller.beforeRender | 19.19 | |
» Processing toolbar data | 19.08 | |
Rendering View | 2.94 | |
» Event: View.beforeRender | 0.03 | |
» Rendering APP/View/SimplePages/view.ctp | 0.08 | |
» Event: View.afterRender | 0.02 | |
» Event: View.beforeLayout | 0.01 | |
» Rendering APP/View/Layouts/app.ctp | 2.22 | |
Event: View.afterLayout | 0.00 |
Constant | Value |
---|---|
DB_HOST | localhost |
DB_NAME | score-1 |
DB_USER | root |
DB_PASS | e5503e0127d4cedda7681f04fb26f1f6 |
Constant | Value |
---|---|
APP | /srv/users/score/apps/score-1/public/app/ |
APP_DIR | app |
APPLIBS | /srv/users/score/apps/score-1/public/app/Lib/ |
CACHE | /srv/users/score/apps/score-1/public/app/tmp/cache/ |
CAKE | /srv/users/score/apps/score-1/public/lib/Cake/ |
CAKE_CORE_INCLUDE_PATH | /srv/users/score/apps/score-1/public/lib |
CORE_PATH | /srv/users/score/apps/score-1/public/lib/ |
CAKE_VERSION | 2.5.3 |
CSS | /srv/users/score/apps/score-1/public/app/webroot/css/ |
CSS_URL | css/ |
DS | / |
FULL_BASE_URL | https://scr1.scoreforpeace.org |
IMAGES | /srv/users/score/apps/score-1/public/app/webroot/img/ |
IMAGES_URL | img/ |
JS | /srv/users/score/apps/score-1/public/app/webroot/js/ |
JS_URL | js/ |
LOGS | /srv/users/score/apps/score-1/public/app/tmp/logs/ |
ROOT | /srv/users/score/apps/score-1/public |
TESTS | /srv/users/score/apps/score-1/public/app/Test/ |
TMP | /srv/users/score/apps/score-1/public/app/tmp/ |
VENDORS | /srv/users/score/apps/score-1/public/vendors/ |
WEBROOT_DIR | webroot |
WWW_ROOT | /srv/users/score/apps/score-1/public/app/webroot/ |
Environment Variable | Value |
---|---|
Php Version | 5.6.40 |
Tmp | /srv/users/score/tmp/score-1 |
Temp | /srv/users/score/tmp/score-1 |
Tmpdir | /srv/users/score/tmp/score-1 |
Path | /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin |
User | score |
Home | /srv/users/score |
Fcgi Role | RESPONDER |
Redirect Redirect Https | on |
Redirect Redirect Script Url | /en/use/about |
Redirect Redirect Script Uri | https://scr1.scoreforpeace.org/en/use/about |
Redirect Redirect Status | 200 |
Redirect Https | on |
Redirect Script Url | /en/use/about |
Redirect Script Uri | https://scr1.scoreforpeace.org/en/use/about |
Redirect Status | 200 |
Https | on |
Script Url | /en/use/about |
Script Uri | https://scr1.scoreforpeace.org/en/use/about |
Http Host | scr1.scoreforpeace.org |
Http X Forwarded For | 3.144.37.178 |
Http X Forwarded Ssl | on |
Http X Forwarded Proto | https |
Http Connection | close |
Http Accept | */* |
Http User Agent | Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
Http Accept Encoding | gzip, br, zstd, deflate |
Ld Library Path | /opt/sp/apache/lib:/opt/sp/apache/lib |
Server Signature | |
Server Software | Apache/2.4.62 (Unix) OpenSSL/1.1.1 |
Server Name | scr1.scoreforpeace.org |
Server Addr | 127.0.0.1 |
Server Port | 443 |
Remote Addr | 3.144.37.178 |
Document Root | /srv/users/score/apps/score-1/public |
Request Scheme | https |
Context Prefix | |
Context Document Root | /srv/users/score/apps/score-1/public |
Server Admin | webmaster@ |
Script Filename | /srv/users/score/apps/score-1/public/app/webroot/index.php |
Remote Port | 19404 |
Redirect Url | /app/webroot/en/use/about |
Redirect Query String | url=en/use/about |
Gateway Interface | CGI/1.1 |
Server Protocol | HTTP/1.0 |
Request Method | GET |
Query String | url=en/use/about |
Request Uri | /en/use/about |
Script Name | /app/webroot/index.php |
Php Self | /app/webroot/index.php |
Request Time Float | 1735482073.2007 |
Request Time | 1735482073 |
Argc | 1 |