Facts and Dimensions All Data (Addl T&Cs Required)

# Contents

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.

This version includes data that requires addl data provider T&Cs to be accepted for ICD10 and SNOMED.

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.

# AI Semantic Views

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

## Semantic View Example Questions:

Semantic view: Understanding_SQL_JoinsWhat 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.