Array
(
[sql] =>
SELECT t1.*,
ROUND((val_presence*0.5) + (val_upfreq*0.25) + (val_machine_readable*0.25), 2) as c_index
FROM (
SELECT t0.main_category, t0.subcategory, t0.country, t0.country_name, t0.id_main_category, t0.sub_sort_ord,
COALESCE(dr.n_indicators,0) n_indicators ,
COALESCE(dr.presence, 0) presence,
COALESCE(dr.val_presence, 0) val_presence,
COALESCE(dr.val_upfreq, 0) val_upfreq,
COALESCE(dr.val_machine_readable, 0) val_machine_readable
FROM (
SELECT dgm.main_category, dgm.subcategory, dgm.country, cn.country_name, id_main_category, dgm.sub_sort_ord
FROM dgm
INNER JOIN country cn ON cn.abbr = dgm.country
WHERE dgm.rev_last = 1
AND visible_subcategory = 1
GROUP BY id_main_category, main_category, subcategory, country
ORDER BY id_main_category, main_category, subcategory, country)
t0
LEFT JOIN data_rank dr
ON dr.main_category = t0.main_category
AND dr.subcategory = t0.subcategory
AND dr.country = t0.country
AND year=?
) t1
ORDER BY id_main_category, sub_sort_ord, main_category, subcategory, country_name
[params] => Array
(
[0] => 2020
)
[errno] => SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #6 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'dguptake.dgm.sub_sort_ord' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
)
Array
(
[sql] =>
SELECT t1.*,
ROUND((val_presence*0.5) + (val_upfreq*0.25) + (val_machine_readable*0.25), 2) as c_index
FROM (
SELECT t0.main_category, t0.subcategory, t0.country, t0.country_name, t0.id_main_category, t0.sub_sort_ord,
COALESCE(dr.n_indicators,0) n_indicators ,
COALESCE(dr.presence, 0) presence,
COALESCE(dr.val_presence, 0) val_presence,
COALESCE(dr.val_upfreq, 0) val_upfreq,
COALESCE(dr.val_machine_readable, 0) val_machine_readable
FROM (
SELECT dgm.main_category, dgm.subcategory, dgm.country, cn.country_name, id_main_category, dgm.sub_sort_ord
FROM dgm
INNER JOIN country cn ON cn.abbr = dgm.country
WHERE dgm.rev_last = 1
AND visible_subcategory = 1
GROUP BY id_main_category, main_category, subcategory, country
ORDER BY id_main_category, main_category, subcategory, country)
t0
LEFT JOIN data_rank dr
ON dr.main_category = t0.main_category
AND dr.subcategory = t0.subcategory
AND dr.country = t0.country
AND year=?
) t1
ORDER BY id_main_category, sub_sort_ord, main_category, subcategory, country_name
[params] => Array
(
[0] => 2020
)
[errno] => SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #6 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'dguptake.dgm.sub_sort_ord' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
)
Digital Government MetaMonitor
Country: United Kingdom
Country summary
eID Citizens use GOV.UK Verify to prove their identity online. Business owners can use their eID for a limited number of digital services. The eID system doesn’t include a digital proxy service.
ePayment GOV.UK Pay is a free service, available to public sector organisations to take online card payments.
Messaging GOV.UK Notify is the service used by the public sector to communicate with citizens via email and text message.
Transparency The United Kingdom currently has no measures in place to offer insights in personal data or ongoing affairs.
General Digital Services No systematic measurement of digital form submission nor user satisfaction has been found.
The Digital Government MetaMonitor indicates a high level of completeness of data on eID uptake. Improvements can be made with regards to update frequency. Equally as complete are the publicly available data on ePayment in the United Kingdom. A significantly lower level of data completeness is recorded in the categories Messaging, Transparency, and General Digital Services. While a small amount of data on the uptake of GOV.UK Notify is publicly available, improvements are suggested in the areas of user satisfaction, general form submission, and transparency.
Country Statistics
Source: Eurostat 2020
Indicator
Value
Number of businesses
2,580,040
Population over 15 years old
54,533,504
Total users
57,113,544
Number of central/federal government organisations