english_regions: 5

This data as json

id	name	geographic_code	country_id
5	London	E12000007	2

Links from other tables

186 rows from english_region_id in english_region_general_election_party_performances
222 rows from english_region_id in constituency_areas