Using the Lottery section of the Culture website and searching for Stoke on Trent reveals around 18 years of data which reveals 1223 projects totalling £117,872,724.
Now I thought it would be best to ask a range of questions against this data including:
- Which organisations got what amounts?
- Which types of projects were successful?
- Who funded the projects?
- What was the pattern of funding over time?
- What are the key phrases that repeat in the project descriptions?
The charts below show some of the data in visual form using Google Charts (it's quick and simple once I completed a little analysis). I also used a few extra tools up my sleeve to link Company names in the list to Companies house to get a sense of the types of company formations involved (Limited by Shares, CiC etc). I've also ran the project descriptions through a little analysis to get a sense of keywords that get repeated in the project titles, I looked for Named Entities rather than the usual word frequency (the type you see in Wordles). This analysis reveals a little more about the meaning of the high frequency words/phrases in the text .
It's up for grabs what we learn from this data, for me the named entities has been insightful however there's more analysis to be done, what can you find? How can we use data like this to move forward?
Here's the link to full data.
Funding over time:
(There were approx 961 awards given to groups with no formal structure recognised in Companies house although company names may have changed, but NOT 961 individual groups, just awards, some groups were awarded more than once. Data to be further analysed)