AndreaBozzo/ceres-open-data-index huggingface dataset:
Mayor's Crowdfunding Programme - Social Impacts

Since 2014 the GLA’s Regeneration Unit have been developing and delivering an innovative and pioneering new tool to support local investment in London’s communities: The Mayor’s Crowdfunding Programme. The initiative explores the potential for the GLA to pledge to civic crowdfunding projects as ‘one of the crowd’, enabling London’s citizens to deliver and manage spaces and places that suit local needs and identities.This study, commissioned by the Regeneration Unit and undertaken by the GLA’s Opinion Research team, attends to the ‘softer’ social impacts of regeneration interventions that can be easily overlooked in traditional evaluative research for policy. Significantly, the report deals only and entirely with non-financial benefits of civic crowdfunding, attending to a gap in research previously identified by Nesta (2015). Through a period of qualitative research, specifically semi-structured interviews and non-participant observation, with a sample of 7 project groups, insight and understanding has been gathered on the experiences of those who embark on delivering a project as part of the Mayor’s Crowdfunding Programme.Technical Details Results and findings are based on in depth qualitative research with 7 project groups funded in Rounds 1 or 2 of the Mayor’s Crowdfunding Programme. Research was undertaken on projects’ sites throughout May of 2016. All data collection was undertaken with the same template, by the same researcher. All data was thematically coded into one data-set. Participants were self-selecting, from the pool of funded projects. The research does not claim to speak for all project experiences, or experiences outside of the Mayor’s Crowdfunding Programme

Organization: Greater London Authority
Clean Air Consultation – July 2016

On his election in 2016, the Mayor committed to a large scale consultation on a range of actions to address poor air quality in London. Measures under consideration include implementing the Ultra Low Emission Zone (ULEZ) in 2019 rather than 2020, expanding the boundaries of the ULEZ, and introducing an Emissions Surcharge on the most polluting vehicles driving in central London from 2017. In addition the Mayor has committed to cleaning up London bus fleets, using air quality alerts, and exploring options for a diesel scrappage scheme.This report and associated data sets out the results from the Stage 1 consultation, which will inform Transport for London’s further consultation in the Autumn. Technical Details Talk London Clean Air Survey – approximately 15,000 responses. Fieldwork from 5-29 July 2016. TNS Research Clean Air Survey – Identical questionnaire to Talk London Clean Air survey. 1,000 sample, representative of the London population by age, gender, ethnicity, plus boosted sample of 650 Londoners in Inner London. Fieldwork from 7-29 July 2016. TNS T-Charge Poll – A survey of 1,000 Londoners, representative of the London population by age, gender, ethnicity was commissioned to understand Londoners’ perceptions of a potential charge on the most polluting vehicles. Fieldwork 9-14 June 2016. A number of Londoners responded to the consultation outside the survey and discussions on Talk London, for example by writing to/emailing TfL and the Mayor. These have been collated, read, included in qualitative analysis slides in the consultation report.

Tags: air-quality
Organization: Greater London Authority
London Elections Results 2016, Wards, Boroughs, Constituency

The results for the Mayoral and Assembly elections down to constituency level are available (including turnout and spoils etc).Please note that due to boundary changes, 2016 ward data is not comparable with previous years' data. More info on the 2016 elections can be found on the London Elects website.

Tags: assembly, elections, map, mayor, mayoral, poll, vote, votes
Organization: Greater London Authority
Underemployed and overemployed workers

From the ONS’ Annual Population Survey, this data covers the aggregate number of workers expressing a desire to work more and less hours, how many hours they wish to change by, whether they work full-time or part-time, whether they would prefer to change jobs, or take on a new one to make up their ideal number of hours per week, over and underemployment broken down by respondents’ age and occupation.

Organization: Greater London Authority
Skills for London's economy

As London looks ahead to a skills devolution deal, the capital has ambitions to create an adult skills system that is more responsive to the needs of the local economy. This work reflects on the area based review which will shape the future of the Further Education sector in London. Analysis by GLA Economics sets out what drives London’s economy, and what this means for future skills needs.In this series of papers we analyse the demand for jobs and skills to inform the Government’s area reviews of post-16 education and training, covering four London sub-regions (working papers 76-79). Thanks to London’s excellent transport links, the job opportunities available to learners are wider than a particular sub-region. The 2011 Census shows that less than half of all workers in London (48%) live in the same sub-regional area as their place of work. This calls for a broader, pan-London view (working paper 75).https://www.london.gov.uk/business-and-economy-publications/skills-londons-economy

Tags: Qualifications, Sectors, employment, further-education, jobs, occupation, skills
Organization: Greater London Authority
LLAQM bespoke borough by borough 2013 air quality modelling and data

The new bespoke borough packages provide a set of maps, data and graphs in order to facilitate the usability of LAEI 2013 data.Modelling and emission data from the LAEI 2013 has been used for NOx, NO2, PM10 and PM2.5.All boroughs can download the following files: Excel Tools LLAQM Source Apportionment, providing emissions split by source at a chosen location (1km2 resolution) - 14/04/16 Update: Please note that the Source Apportionment tool has been updated (v1.1 - providing a breakdown of emissions at Borough level as well). Borough table showing population and percentage of population within areas where NO2 concentrations are greater than 40µg/m3 Greater London Concentration Maps (PDF and JPEG) - Greater London maps showing NO2, NOx, and PMs concentrations for 2013, 2020, 2025 and 2030 - 11/07/16 Update: Please note that maps for future years have now been uploaded. Separately, each borough package includes the following for 2013 and 2020 (PDF and JPEG): NO2_AnnualMean_Conc1 - Borough maps showing NO2 concentrations NO2_AnnualMean_Conc2 - Borough maps showing NO2 concentrations with a basemap NO2_AnnualMean_exc - Borough map showing areas where NO2 concentrations are greater than 40µg/m3 and 60µg/m3 NOx_AnnualMean_Conc1 - Borough maps showing NOx concentrations NOx_AnnualMean_Conc2 - Borough maps showing NOx concentrations with a basemap PM10_AnnualMean_Conc1 - Borough maps showing PM10 concentrations PM10_AnnualMean_Conc2 - Borough maps showing PM10 concentrations with a basemap PM10d_NoDOver50_Conc1 - Borough maps showing PM10 daily mean concentrations over 50µg/m3 PM10d_NoDOver50_Conc2 - Borough maps showing PM10 daily mean concentrations over 50µg/m3 PM2.5_AnnualMean_Conc1 - Borough maps showing PM2.5 concentrations PM2.5_AnnualMean_Conc2 - Borough maps showing PM2.5 concentrations with a basemap Borough dashboard emission summary (table and graph) by source type for all years, for NOx, PM and CO2 - 22/03/16 Update: Please note that the dashboards have been updated to correct an error in PM10 2030 totals for the "Other" emissions category. 11/07/16 Update: Please note that maps for 2020 have now been included in the borough packages.

Tags: NO2, NOx, PM10, PM10d, PM25, emissions
Organization: Greater London Authority
Estimating births using GP registration data

A technical note and subsequent Update on the use of General Practitioner (GP) registration data to estimate the number of live births occurring in London.The technical note presents analysis into the relationships between GP registration and birth estimates data, which indicates that GP registrations can be used to predict birth estimates with a good level of accuracy at local auhtority level.Using the approach outlined in the note, a strong indication of births can be obtained up to eleven months ahead of the release of official data. The note presents birth estimates for the year to mid-2015 based on analysis of GP registration data and explores the likely accuracy of such estimates.Intelligence Unit Update 04-2016 compares the birth predictions made in the technical note with subsequently released official estimates. The accuracy of the results is compared with that obtained from standard projection methodologies employed by the GLA and ONS. The Update presents estimates of births for the year to mid-2016 based upon recent GP registration data obtained by the GLA.**Update February 2023**Estimates of recent births using an updated version of this approach are now available here The code used to produce these estimates is available on GitHub.

Tags: ONS, births, estimates, nhs, population projections, technical
Organization: Greater London Authority
London Office of Data Analytics

The GLA and Nesta are working together to run a pilot to demonstrate that performing data analytics on datasets sourced from multiple local authorities and public sector bodies can help reform public services in the capital. If successful, the pilot will pave the way to create a permanent London Office of Data Analytics.As well as regular blogs, we will publish reports here as they are produced over the next few months.

Tags: Data Science, LODA
Organization: Greater London Authority
London Assembly Constituency Profiles 2016

The London Assembly Constituency Profiles provide a summary of demographic and related data for each Greater London Assembly constituency. The profiles are designed to provide an overview of each area by combining data on a range of themes. Each constituency is compared to equivalent statistics for Greater London.The constituency profiles are formatted to show the most recent data for each indicator plus a comparison with a figure aproximately 4 and 8 years ago, to compare the change over the last two Mayoral terms.

Organization: Greater London Authority
Monthly Mix-Adjusted Average House Prices, London

This page is no longer being updated. Please use the UK House Price Index instead.Mix-adjusted house prices, by new/pre-owned dwellings, type of buyer (first time buyer) and region, from February 2002 for London and UK, and average mix-adjusted prices by UK region, and long term Annual House Price Index data since 1969 for London.The ONS House Price Index is mix-adjusted to allow for differences between houses sold (for example type, number of rooms, location) in different months within a year. House prices are modelled using a combination of characteristics to produce a model containing around 100,000 cells (one such cell could be first-time buyer, old dwelling, one bedroom flat purchased in London). Each month estimated prices for all cells are produced by the model and then combined with their appropriate weight to produce mix-adjusted average prices. The index values are based on growth rates in the mix-adjusted average house prices and are annually chain linked.The weights used for mix-adjustment change at the start of each calendar year (i.e. in January). The mix-adjusted prices are therefore not comparable between calendar years, although they are comparable within each calendar year. If you wish to calculate change between years, you should use the mix-adjusted house price index, available in Table 33.The data published in these tables are based on a sub-sample of RMS data. These results will therefore differ from results produced using full sample data. For further information please contact the ONS using the contact details below. House prices, mortgage advances and incomes have been rounded to the nearest £1,000. Data taken from Table 2 and Table 9 of the monthly ONS release.Download from ONS website

Tags: house-prices-index, series, time
Organization: Greater London Authority
Internet and Computer use, London

Stati stics of how many adults access the internet and use different types of technology covering: home internet access how people connect to the web how often people use the web/computers whether people use mobile devices whether people buy goods over the web whether people carried out specified activities over the internet For more information see the ONS website and the UKDS website.

Tags: access, broadband, computer, email, information, internet, laptop, mobile, portable, smartphones, social-networking, tablet, technology
Organization: Greater London Authority
Ask Boris social media monitoring

Monthly Tweetreach reports monitoring the online metrics for the Mayor of London's 'Ask Boris' Twitter sessions. Each report is generated against the search term, hashtag #askboris and is run from the day before the session starts to the end of the day the session takes place. Data includes:Reach: The number of unique Twitter accounts that received tweets about the sessionExposure: The number of impressions generated by tweets in the reportActivity: Total number of tweets, contributors, time period and volumeType: Number ot tweets, retweet and repliesTimeline: A full list of tweetsNotes: A full description of Tweetreach analytics and descriptors is available on www.tweetreach.com or in the article Understanding the TweetReach snapshot report Please note that due to limitations with the listening tool not all tweets from Ask Boris sessions are captured in the reports.

Tags: consultation, public-engagement, social-media, tweetreach, twitter
Organization: Greater London Authority
London Atmospheric Emissions Inventory (LAEI) 2010

The LAEI 2010 has since been superseded. Click here for the full list of releases. Estimates of eight key and six subisdary pollutants are included for the base year 2010 and projected forward to 2012, 2015, and 2020. The LAEI area covers the 32 London Boroughs and the City of London and up to the M25 motorway.Due to the size of the LAEI database this dataset has been zipped and needs to be downloaded in five parts.Due to the size of this database we recommend working on a local drive rather than over a network.

Tags: air-pollution, laei, nitrogen-dioxide, particulate-matter
Organization: Greater London Authority
Air quality summary statistics

Data for London air quality monitoring sites showing whether annual monitoring objectives were met for different species of pollutant. Data for 2016 includes the first two months of the year only so this is an indicative outlook. This data was accessed using the London Air API.For some species, all monitoring sites taking measurements have met the monitoring objectives over the last decade. Note that the total number of sites measuring a given species changes from year to year. Here all sites are grouped together regardless of their type (e.g. roadside, suburban, industrial) or geographic location.For other species, 60-100% of the monitoring sites taking measurements have met annual objectives over the last decade. All reportable sites are now compliant with the PM10 objective.The percentage of sites meeting annual nitrogen dioxide monitoring objectives has shown relatively little change but there have been improvements in recent years. The percentage of sites meeting annual monitoring objectives for ozone has fluctuated widely in the past but in recent years has increased.

Organization: Greater London Authority
GLA Survey Results: Private Hire Vehicle Regulations

Complementing Transport for London’s own consultation on changes to regulations for Private Hire Vehicles, over 850 Talk London members participated in a survey to understand their views of the proposed changes.Fieldwork took place between October and November 2015. Results were shared with TfL’s Taxi & Private Hire Team, TfL’s Customer Research & Insight Team, and the Mayor’s Transport team, in advance of decisions on which proposals to take forward for approval by TfL’s Board. More information on the proposals taken forward can be found here.

Organization: Greater London Authority
Create your own mapping templates - Excel Add-In

With this add in it is possible to create map templates from GIS files in KML format, and create choropleths with them.Providing you have access to KML format map boundary files, it is possible to create your own quick and easy choropleth maps in Excel. The KML format files can be converted from 'shape' files. Many shape files are available to download for free from the web, including from Ordnance Survey and the London Datastore. Standard mapping packages such as QGIS (free to download) and ArcGIS can convert the files to KML format.A sample of a KML file (London wards) can be downloaded from this page, so that users can easily test the tool out.Macros must be enabled for the tool to function.When creating the map using the Excel tool, the 'unique ID' should normally be the area code, the 'Name' should be the area name and then if required and there is additional data in the KML file, further 'data' fields can be added. These columns will appear below and to the right of the map. If not, data can be added later on next to the codes and names.In the add-in version of the tool the final control, 'Scale (% window)' should not normally be changed. With the default value 0.5, the height of the map is set to be half the total size of the user's Excel window.To run a choropleth, select the menu option 'Run Choropleth' to get this form.To specify the colour ramp for the choropleth, the user needs to enter the number of boxes into which the range is to be divided, and the colours for the high and low ends of the range, which is done by selecting coloured option boxes as appropriate. If wished, hit the 'Swap' button to change which colours are for the different ends of the range. Then hit the 'Choropleth' button.The default options for the colours of the ends of the choropleth colour range are saved in the add in, but different values can be selected but setting up a column range of up to twelve cells, anywhere in Excel, filled with the option colours wanted. Then use the 'Colour range' control to select this range, and hit apply, having selected high or low values as wished. The button 'Copy' sets up a sheet 'ColourRamp' in the active workbook with the default colours, which can just be extended or deleted with just a few cells, so saving the user time.The add-in was developed entirely within the Excel VBA IDE by Tim Lund. He is kindly distributing the tool for free on the Datastore but suggests that users who find the tool useful make a donation to the Shelter charity. It is not intended to keep the actively maintained, but if any users or developers would like to add more features, email the author. AcknowledgmentsCalculation of Excel freeform shapes from latitudes and longitudes is done using calculations from the Ordnance Survey.

Tags: excel, mapping
Organization: Greater London Authority
Annual London Survey 2015

London is changing; with an expanding service-led economy, increasing wealth, consumption and leisure time for many of its residents and a growing multiplicity of tastes and preferences across a growing population. From November 3rd to December 1st, 4000 Londoners took part in Talk London’s Annual London Survey (ALS) to share their views on what makes London a great place to live, and what aspects of life in the capital could do with some improvement. The London Survey aims to address three key questions: To what extent are Londoners satisfied with their quality of life, and what drives this satisfaction? What do Londoners think are the most important drivers of a successful place to live and work? What does the balance of satisfaction and rank of different aspects of London life mean for experience and enjoyment of the city, and how can this be improved? Technical Details Results are based on interviews with 3861 London residents aged 18+ Interviews were carried out online via the Talk London community between 3rd November and 1st December 2015. Participants were self-selecting, and outreach undertaken via a number of known databases. This achieved a non-representative sample of Londoners. The data was weighted by age, gender and ethnicity to reflect the London population according to ONS data. Robustness was maintained through achieving a minimum quota of responses from each demographic group. This is the second London Survey conducted through Talk London for City Hall.

Tags: als2015, opinion, priorities, residents, satisfaction, survey
Organization: Greater London Authority
Unemployment Rate, Region

Unemployment numbers and rates for those aged 16 or over. The unemployed population consists of those people out of work, who are actively looking for work and are available to start immediately.Unemployed numbers and rates also shown for equalities groups, by age, sex, ethnic group, and disability.The data are taken from the Labour Force Survey and Annual Population Survey, produced by the Office for National Statistics.The data are produced monthly on a rolling quarterly basis. The month shown is the month the quarter ends on.The International Labour Organization defines unemployed people as: without a job, want a job, have actively sought work in the last 4 weeks and are available to start work in the next 2 weeks, or, out of work, have found a job and are waiting to start it in the next 2 weeks.The figures in this dataset are adjusted to compensate for seasonal variations in employment (seasonally adjusted).Data by equalities groups has a longer time lag and is only available quarterly from the Annual Population Survey, which is not seasonally adjusted. Useful links Click here for Regional labour market statistics from the Office for National Statistics.Click here for Labour market statistics from the Office for National Statistics.See here for GLA Economics' Labour Market Analysis.See here for Economic Inactivity statistics.See here for Employment rates. This dataset is one of the Greater London Authority's measures of Economic Fairness. Click here to find out more.

Tags: bame, disability, economic-activity, economic-fairness, employment, employment-status, gender, sex, unemployment, youth
Organization: Greater London Authority