Facts and Dimensions All Data Trial PAYG

Ever increasing no of tables of statistics and reference data sourced from open data. All processed and collated and updated live from sources all over the world.

To add another dataset, simply ask and we will add it.

One stop shop for cross analysing any and all open data instantly. No need to spend hours/days pulling data out of excel files and APIs etc. Just query.

7000+ tables of data, growing every day.

20billion+ rows of aggregated data, growing every day

Data includes:

1. Open finance stats
2. Open health stats
3. Open population stats
4. Data dictionaries
5. Open Police and justice stats
6. Open weather stats
7. Open economic data
8. Embassies
9. Organisation codes
10. Open energy stats
11. Open crime stats
12. Open survey stats
13. Open Life expectancy stats
14. Open deprivation stats
15. Open education stats
16. Open transport stats
17. Open pharmacy stats
18. Open mortality stats
19. Wide array of open NHS stats
20. Open healthcare spend stats
21. Open census stats
22. Open covid stats
23. Open workforce stats
24. Open business stats
25. Open employment stats
26. Open politics stats
27. Open shipping stats

See whole catalogue in table Release_Details.All_Available_Tables and on our website

To add more, just point us to the source data, so long as it is open data, we will add it.

Snowflake Semantic views capture the metadata required for consistent and accurate AI-powered analytics, such as synonyms, sample values and verified queries.

<p><br/></p>

# Semantic View Example Questions:

Semantic view: Understanding_SQL_Joins

What dimension table(s) do I join to AandE_Attendance.fact_Age_Type_1_2_ECDS and what columns do I join on?

We are adding more and more semantic views. Each one contains verified queries. Open one up to see the recommended questions.

原始信息汇总

数据集概述

该数据集详情页面提供了关于“Facts and Dimensions Ltd: Facts and Dimensions All Data Trial + PAYG”的详细信息。以下是数据集的关键信息概述：

数据集名称

• Facts and Dimensions Ltd: Facts and Dimensions All Data Trial + PAYG

数据集描述

• 该数据集提供了关于Facts and Dimensions Ltd的所有数据试用和即付即用（PAYG）的信息。

数据集相关资源

• 数据集详情页面包含了一些相关资源，如favicon图标，具体包括：
  • 16x16像素的favicon图标
  • 32x32像素的favicon图标
  • 48x48像素的favicon图标
  • 96x96像素的favicon图标
  • 144x144像素的favicon图标

页面样式

• 页面包含了一些样式设置，用于控制页面的布局和外观，具体包括：
  • 页面主体的边距和填充设置
  • 页面宽度和最小高度的设置

搜集汇总

背景与挑战

背景概述

该数据集整合了全球各类开放数据，包含7000多个实时更新的数据表和200亿行聚合数据，覆盖金融、健康、经济等27个领域。支持直接查询分析，并提供语义视图辅助AI驱动的数据分析。