Confirm datasets (core and third-party, at-launch and future)

[zarino]

• Which datasets did prototyping week respondents say would be most useful?
• Which datasets did Alex W discover in his mapping excercise?
• Which datasets are we actually able to source ourselves?
• Which datasets will third parties need to provide? And are they happy to do it?
• What location identifiers do the datasets contain? Do they lend themselves to being split/combined by constituency? How would we do that?
• Which of these datasets are “killer datasets” we want to launch with? Which could come later?

Lists of potential datasets:

• Alex W’s dataset audit
• NPC’s local needs databank (see "Metadata" section to links to all the source datasets)

[zarino]

Core datasets that lots of other stuff hooks on to:

• Constituencies – GSS code, MapIt ID, name, geometry – https://github.com/mysociety/local-intelligence-hub/pull/19
• MPs – name, TWFY ID, Parliament ID – https://github.com/mysociety/local-intelligence-hub/pull/21

MP data:

• Party (from WikiData?) – https://github.com/mysociety/local-intelligence-hub/pull/21
• External profiles / handles (from WikiData?) – Twitter, Facebook, Wikipedia, TWFY – https://github.com/mysociety/local-intelligence-hub/pull/21
• Date of election – https://github.com/mysociety/local-intelligence-hub/pull/30
• Majority at last general election – https://github.com/mysociety/local-intelligence-hub/pull/30
• Select Committee memberships, (from Parliament?) – https://github.com/mysociety/local-intelligence-hub/issues/36
• APPG memberships, (from Parliament? – https://github.com/mysociety/local-intelligence-hub/issues/37 – note there’s a new list of members every few months). It’d be great to just get all of an MP’s memberships, but if not, here’s a list of climate/environment/energy/nature-adjacent APPGs, with a ⭐️ next to the handful that Alex W from TCC highlighted:
  • Air Pollution ⭐️
  • Climate Change ⭐️
  • Community Energy
  • Cycling and Walking
  • Electric Vehicles
  • Energy Costs
  • Energy Security
  • Environment ⭐️
  • Farming
  • Fisheries
  • Forestry and Tree Planting
  • Fuel Poverty and Energy Efficiency
  • Green New Deal
  • Health and the Natural Environment
  • Marine Energy
  • Microplastics
  • Nature ⭐️
  • Net Zero
  • Parks and Green Spaces
  • Renewable and Sustainable Energy
  • Sustainable Flood and Drought Management
  • Tidy Britain
  • Waterways
  • Wetlands
  • Woods and trees
• Non-parliamentary group memberships:
  • Conservative Environment Network:
    • Their "caucus"
    • Their "Net Zero Champions"
    • Their "Nature Champions"
  • Net Zero Scrutiny Group (backbench Conservative)
  • SERA (Labour):
    • Their "Executive Committee" – seems to only include a couple of MPs?
  • Buglife Species Champions
  • 2019 Friends of the Earth Climate Pledge signatories

Constituency social data:

• TCC MRP opinion polling data
• % of population at each of the standard age brackets (from House of Commons Library) – https://github.com/mysociety/local-intelligence-hub/issues/33
• % of households in fuel poverty (from…??) – https://github.com/mysociety/local-intelligence-hub/pull/48
• % of children living in poverty (from House of Commons Library)
• % of households on universal credit (from House of Commons Library)
• IMD (deprivation) in this constituency – England, Wales, Scotland, and Northern Ireland – https://github.com/mysociety/local-intelligence-hub/issues/38

Constituency environmental data:

• % of households at risk of flooding (from…??)
• Median household energy efficiency in this constituency – England and Wales
• Land use / rural-urban measure in this constituency (House of Commons Library seems to get this from CLC, there’s also the RUC but it only covers England – should ask Alex P for a UK-wide data source) – https://github.com/mysociety/local-intelligence-hub/issues/38
• Access to public green space in this constituency (from ONS) – https://github.com/mysociety/local-intelligence-hub/issues/35

Constituency economic data:

• Year on year change in number of businesses in this constituency (from House of Commons Library)
• Constituency is within an area that has received "levelling up" funds (2021 list available from GOV.UK, 2022 list hasn’t been announced yet)

Constituency political data:

• Estimated 2016 Brexit vote split in this constituency (from House of Commons Library)
• % of eligible voters who turned out at the most recent general election in this constituency (from House of Commons Library)
• Party vote split for the most recent general election in this constituency (from House of Commons Library)
• "Red wall" / "Blue wall" seats, (from…?)

Movement data:

• FoE supporters by constituency
• National Trust supporters by constituency
• Oxfam shops near this constituency
• National Trust properties near this constituency (from their website, or hopefully they can provide a CSV)
• Parish groups and churches near this constituency (CAFOD)
• Community energy projects near this constituency (from Community Energy England)
• More to come…

[ajparsons]

For deprivation, can also create constituency level versions of the composite ranking fairly easily (I've already done the LA level, the maths is simple) https://mysociety.github.io/composite_uk_imd/

Same for Urban-Rural index

[ajparsons]

Alignment between local government control and local MP

[ajparsons]

EPC data rounded up to constituency/LA (could work for both projects)

[zarino]

Notes from team call about this:

• There are definitely APPGs / select committees that are of core interest and might be good to make more accessible, but it’s possible that campaigners might be interested in an MP’s membership of any select committee, often quite tangential to climate stuff, depending on the campaign.
• Writing a scraper for APPG memberships wouldn’t be too hard – they all share the same format. We have code in ParlParse for matching MP names from strings.
• We can re-export our deprivation and rurality data into constituency buckets – will take @ajparsons a few weeks.

Top choices:

1. Age buckets from House of Commons Library (so that we can get an example of a "complex" dataset with multiple buckets per constituency) – https://github.com/mysociety/local-intelligence-hub/issues/33
2. Fuel poverty (as a very topical example of a social issue) – @sequencefree has offered to help source data – https://github.com/mysociety/local-intelligence-hub/issues/34
3. Access to green space (as an example of environmental data) – https://github.com/mysociety/local-intelligence-hub/issues/35
4. Loop back to APPGs and Select Committees after that, for more MP data – https://github.com/mysociety/local-intelligence-hub/issues/36 and https://github.com/mysociety/local-intelligence-hub/issues/37
5. By this point hopefully @ajparsons will have had a chance to re-export deprivation and rurality data into constituency format – https://github.com/mysociety/local-intelligence-hub/issues/38

[zarino]

I’ve created a milestone to track these data import tasks: https://github.com/mysociety/local-intelligence-hub/milestone/5