The files below are the raw data that powers our data visualisation tool. We have provided these .csv format files as an accessible alternative for those who are unable to make use of the data visualisation.
Please download and analyse in your preferred assistive technology.
Flood risk tool Flood Defences by Region.csv
This dataset provides a summary of flood defences by region in England created by the NAO. The locations and conditions of flood defences were provided by the Environment Agency which we then matched to regions.
Flood risk tool Flood Defences by Upper Tier Local Authority.csv
This dataset provides a summary of flood defences by local authority in England created by the NAO. The locations and conditions of flood defences were provided by the Environment Agency which we then matched to local authorities.
Flood risk tool Flood Spend by Region.csv
This dataset shows capital spend on flood defences broken down by government spend and local levy funding, split by region in England. Funding data was provided by the Environment Agency and was current as of October 2020.
Flood risk tool Flood Spend by Upper Tier Local Authority.csv
This dataset shows capital spend on flood defences broken down by government spend and local levy funding, split by local authority in England. Funding data was provided by the Environment Agency as was current and of October 2020.
Flood risk tool Homes Better Protected by Region.csv
This dataset shows the number of homes better protected by the completion of a capital project, spilt by region in England. This data was provided by the Environment Agency as shows homes better protected up to April 2020.
Flood risk tool Homes Better Protected by Upper Tier Local Authority.csv
This dataset shows the number of homes better protected by the completion of a capital project, spilt by local authority in England. This data was provided by the Environment Agency as shows homes better protected up to April 2020.
Flood risk tool Properties at Risk by Constituency.csv
This dataset shows the number of homes at risk of flooding by constituency in England. The thresholds used are inclusive, so the number of properties at >0.1% annual risk also includes the number at >1% annual risk. The Environment Agency publishes the latest figures on gov.uk and provided the historic figures used in this dataset. The Environment Agency have adjusted the figures for 2016 to take account of a change to the methodology it uses to assess flood risk made in 2018.
Flood risk tool Properties at Risk by Lower Tier Local Authority.csv
This dataset shows the number of homes at risk of flooding by lower tier local authority in England. The thresholds used are inclusive, so the number of properties at >0.1% annual risk also includes the number at >1% annual risk. The Environment Agency publishes the latest figures on gov.uk and provided the historic figures used in this dataset. The Environment Agency have adjusted the figures for 2016 to take account of a change to the methodology it uses to assess flood risk made in 2018.
Flood risk tool Properties at Risk by Upper Tier Local Authority.csv
This dataset shows the number of homes at risk of flooding by upper tier local authority in England. The NAO has grouped the London boroughs in this dataset, to see figures for the individual boroughs see the lower tier dataset. The thresholds used are inclusive, so the number of properties at >0.1% annual risk also includes the number at >1% annual risk. The Environment Agency publishes the latest figures on gov.uk and provided the historic figures used in this dataset. The Environment Agency have adjusted the figures for 2016 to take account of a change to the methodology it uses to assess flood risk made in 2018.