Skip to main content

Lifehouse Twenty CRM Mock Data Plan

Date: 2026-05-12 Purpose: Define realistic demo data for Twenty CRM to showcase Lifehouse pilot functionality Status: Ready for seeding


Important Notes

  • All data is fake — names, addresses, emails, phone numbers
  • Do not use real Lifehouse people or Fieldwork data
  • Demographics records are restricted/sensitive demo data
  • All records use fieldworkexternalid with mock- prefix for easy identification

1. Locations (2 areas + 4 streets = 6 total)

Location 1: Central Ward

fieldworkexternalid: mock-location-001
name: Central Ward - Stroud Town Centre
addressnormalised: Stroud Town Centre Area
postcode: GL5 1AA
ward: Central
area: Town Centre
latitude: 51.7450
longitude: -2.2150

Location 2: Uplands Ward

fieldworkexternalid: mock-location-002
name: Uplands Ward - Rodborough
addressnormalised: Rodborough Area
postcode: GL5 3SS
ward: Uplands
area: Rodborough
latitude: 51.7380
longitude: -2.2180

Location 3: High Street

fieldworkexternalid: mock-location-003
name: 12 High Street
addressnormalised: 12 High Street, Stroud
postcode: GL5 1AJ
ward: Central
area: Town Centre
latitude: 51.7455
longitude: -2.2145

Location 4: King Street

fieldworkexternalid: mock-location-004
name: 45 King Street
addressnormalised: 45 King Street, Stroud
postcode: GL5 3BU
ward: Central
area: Town Centre
latitude: 51.7448
longitude: -2.2160

Location 5: Bath Road

fieldworkexternalid: mock-location-005
name: 8 Bath Road
addressnormalised: 8 Bath Road, Rodborough
postcode: GL5 3RJ
ward: Uplands
area: Rodborough
latitude: 51.7375
longitude: -2.2175

Location 6: Walkley Hill

fieldworkexternalid: mock-location-006
name: 22 Walkley Hill
addressnormalised: 22 Walkley Hill, Stroud
postcode: GL5 3PP
ward: Uplands
area: Rodborough
latitude: 51.7390
longitude: -2.2190

2. Households (8 total)

Household 1

fieldworkexternalid: mock-household-001
name: Smith Household
locationidid: mock-location-003
lastcontactat: 2026-05-01T14:30:00Z
contactcount: 2
notes: Friendly household, interested in community resilience

Household 2

fieldworkexternalid: mock-household-002
name: Patel Household
locationidid: mock-location-004
lastcontactat: 2026-05-03T10:15:00Z
contactcount: 1
notes: Older resident, may need support in emergency

Household 3

fieldworkexternalid: mock-household-003
name: Jones Household
locationidid: mock-location-005
lastcontactat: 2026-05-05T16:00:00Z
contactcount: 3
notes: Has tools and equipment to share

Household 4

fieldworkexternalid: mock-household-004
name: Williams Household
locationidid: mock-location-006
lastcontactat: 2026-05-02T11:45:00Z
contactcount: 1
notes: Interested but only consents to contact, not wider sharing

Household 5

fieldworkexternalid: mock-household-005
name: Brown Household
locationidid: mock-location-003
lastcontactat: 2026-04-28T13:20:00Z
contactcount: 2
notes: Vegetable grower, open to sharing skills

Household 6

fieldworkexternalid: mock-household-006
name: Taylor Household
locationidid: mock-location-004
lastcontactat: 2026-05-04T15:10:00Z
contactcount: 1
notes: Has van, can help with transport

Household 7

fieldworkexternalid: mock-household-007
name: Davies Household
locationidid: mock-location-005
lastcontactat: 2026-05-06T09:30:00Z
contactcount: 1
notes: Radio amateur, emergency response experience

Household 8

fieldworkexternalid: mock-household-008
name: Wilson Household
locationidid: mock-location-006
lastcontactat: 2026-05-07T14:00:00Z
contactcount: 2
notes: Conflict mediation skills, community organiser

3. People (12 total)

Person 1: Sarah Smith

fieldworkexternalid: mock-person-001
name: Sarah Smith
phone: +44 7700 900001
householdidid: mock-household-001
fieldworkrole: resident
consentstatus: granted
consentupdatedat: 2026-05-01T14:30:00Z
fieldworknotes: Open to knowing more about community resilience
sourcecreatedat: 2026-05-01T14:30:00Z

Person 2: Rajesh Patel

fieldworkexternalid: mock-person-002
name: Rajesh Patel
phone: +44 7700 900002
householdidid: mock-household-002
fieldworkrole: resident
consentstatus: granted
consentupdatedat: 2026-05-03T10:15:00Z
fieldworknotes: Older resident, may need support in emergency
sourcecreatedat: 2026-05-03T10:15:00Z

Person 3: David Jones

fieldworkexternalid: mock-person-003
name: David Jones
phone: +44 7700 900003
householdidid: mock-household-003
fieldworkrole: resident
consentstatus: granted
consentupdatedat: 2026-05-05T16:00:00Z
fieldworknotes: Has tools and can help with repairs
sourcecreatedat: 2026-05-05T16:00:00Z

Person 4: Emma Williams

fieldworkexternalid: mock-person-004
name: Emma Williams
phone: +44 7700 900004
householdidid: mock-household-004
fieldworkrole: resident
consentstatus: granted
consentupdatedat: 2026-05-02T11:45:00Z
fieldworknotes: Interested but only consents to contact, not wider sharing
sourcecreatedat: 2026-05-02T11:45:00Z

Person 5: Michael Brown

fieldworkexternalid: mock-person-005
name: Michael Brown
phone: +44 7700 900005
householdidid: mock-household-005
fieldworkrole: resident
consentstatus: granted
consentupdatedat: 2026-04-28T13:20:00Z
fieldworknotes: Vegetable grower, open to sharing skills
sourcecreatedat: 2026-04-28T13:20:00Z

Person 6: Lisa Taylor

fieldworkexternalid: mock-person-006
name: Lisa Taylor
phone: +44 7700 900006
householdidid: mock-household-006
fieldworkrole: resident
consentstatus: granted
consentupdatedat: 2026-05-04T15:10:00Z
fieldworknotes: Has van, can help with transport
sourcecreatedat: 2026-05-04T15:10:00Z

Person 7: Tom Davies

fieldworkexternalid: mock-person-007
name: Tom Davies
phone: +44 7700 900007
householdidid: mock-household-007
fieldworkrole: volunteer
consentstatus: granted
consentupdatedat: 2026-05-06T09:30:00Z
fieldworknotes: Radio amateur, emergency response experience
sourcecreatedat: 2026-05-06T09:30:00Z

Person 8: Anna Wilson

fieldworkexternalid: mock-person-008
name: Anna Wilson
phone: +44 7700 900008
householdidid: mock-household-008
fieldworkrole: volunteer
consentstatus: granted
consentupdatedat: 2026-05-07T14:00:00Z
fieldworknotes: Conflict mediation skills, community organiser
sourcecreatedat: 2026-05-07T14:00:00Z

Person 9: Councillor James Green

fieldworkexternalid: mock-person-009
name: Councillor James Green
phone: +44 7700 900009
householdidid: null
fieldworkrole: councillor
consentstatus: granted
consentupdatedat: 2026-04-25T10:00:00Z
fieldworknotes: Parish councillor, needs follow-up on community space
sourcecreatedat: 2026-04-25T10:00:00Z

Person 10: Rev. Mary Clarke

fieldworkexternalid: mock-person-010
name: Rev. Mary Clarke
phone: +44 7700 900010
householdidid: null
fieldworkrole: trustee
consentstatus: granted
consentupdatedat: 2026-04-20T14:30:00Z
fieldworknotes: Faith group leader, community space available
sourcecreatedat: 2026-04-20T14:30:00Z

Person 11: John Harris (Volunteer Coordinator)

fieldworkexternalid: mock-person-011
name: John Harris
phone: +44 7700 900011
householdidid: null
fieldworkrole: staff
consentstatus: granted
consentupdatedat: 2026-04-15T09:00:00Z
fieldworknotes: Lifehouse volunteer coordinator
sourcecreatedat: 2026-04-15T09:00:00Z

Person 12: Sophie Martin

fieldworkexternalid: mock-person-012
name: Sophie Martin
phone: +44 7700 900012
householdidid: mock-household-001
fieldworkrole: resident
consentstatus: not_asked
consentupdatedat: null
fieldworknotes: Resident open to knowing more, consent not yet asked
sourcecreatedat: 2026-05-01T14:30:00Z

4. Companies (4 total)

Company 1: Stroud Community Hub

fieldworkexternalid: mock-company-001
name: Stroud Community Hub
organisationtype: community_group
locationidid: mock-location-003
contactpersonidid: mock-person-010
sourcecreatedat: 2026-04-20T14:30:00Z

Company 2: Rodborough Parish Council

fieldworkexternalid: mock-company-002
name: Rodborough Parish Council
organisationtype: council
locationidid: mock-location-002
contactpersonidid: mock-person-009
sourcecreatedat: 2026-04-25T10:00:00Z

Company 3: St. Laurence Church

fieldworkexternalid: mock-company-003
name: St. Laurence Church
organisationtype: faith_group
locationidid: mock-location-003
contactpersonidid: mock-person-010
sourcecreatedat: 2026-04-20T14:30:00Z

Company 4: Stroud Valleys Resilience Group

fieldworkexternalid: mock-company-004
name: Stroud Valleys Resilience Group
organisationtype: charity
locationidid: mock-location-001
contactpersonidid: mock-person-011
sourcecreatedat: 2026-04-15T09:00:00Z

5. Engagements (8 total)

Engagement 1

fieldworkexternalid: mock-engagement-001
householdidid: mock-household-001
personidid: mock-person-001
volunteeridid: mock-person-011
outcome: engaged
inputsource: telegram_voice
summary: Resident interested in community resilience, wants to know more
extracteddata: {"topics": ["resilience", "community"], "sentiment": "positive"}
requiresfollowup: true
followupnotes: Send info pack about community resilience
engagementdate: 2026-05-01T14:30:00Z
sourcejobid: mock-job-001
sourcecreatedat: 2026-05-01T14:35:00Z

Engagement 2

fieldworkexternalid: mock-engagement-002
householdidid: mock-household-002
personidid: mock-person-002
volunteeridid: mock-person-011
outcome: engaged
inputsource: web_upload
summary: Older resident may need support in emergency, interested in buddy system
extracteddata: {"topics": ["support", "emergency"], "sentiment": "concerned"}
requiresfollowup: true
followupnotes: Connect with volunteer buddy scheme
engagementdate: 2026-05-03T10:15:00Z
sourcejobid: mock-job-002
sourcecreatedat: 2026-05-03T10:20:00Z

Engagement 3

fieldworkexternalid: mock-engagement-003
householdidid: mock-household-003
personidid: mock-person-003
volunteeridid: mock-person-011
outcome: engaged
inputsource: telegram_voice
summary: Has tools and equipment, willing to share with neighbors
extracteddata: {"topics": ["tools", "sharing"], "sentiment": "positive"}
requiresfollowup: false
followupnotes: null
engagementdate: 2026-05-05T16:00:00Z
sourcejobid: mock-job-003
sourcecreatedat: 2026-05-05T16:05:00Z

Engagement 4

fieldworkexternalid: mock-engagement-004
householdidid: mock-household-004
personidid: mock-person-004
volunteeridid: mock-person-011
outcome: engaged
inputsource: web_upload
summary: Interested but only consents to contact, not wider data sharing
extracteddata: {"topics": ["privacy", "consent"], "sentiment": "cautious"}
requiresfollowup: false
followupnotes: null
engagementdate: 2026-05-02T11:45:00Z
sourcejobid: mock-job-004
sourcecreatedat: 2026-05-02T11:50:00Z

Engagement 5

fieldworkexternalid: mock-engagement-005
householdidid: mock-household-005
personidid: mock-person-005
volunteeridid: mock-person-011
outcome: engaged
inputsource: telegram_voice
summary: Vegetable grower, open to sharing growing skills with community
extracteddata: {"topics": ["growing", "skills"], "sentiment": "positive"}
requiresfollowup: true
followupnotes: Invite to community growing workshop
engagementdate: 2026-04-28T13:20:00Z
sourcejobid: mock-job-005
sourcecreatedat: 2026-04-28T13:25:00Z

Engagement 6

fieldworkexternalid: mock-engagement-006
householdidid: mock-household-006
personidid: mock-person-006
volunteeridid: mock-person-011
outcome: engaged
inputsource: web_upload
summary: Has van, can help with transport for community events
extracteddata: {"topics": ["transport", "van"], "sentiment": "helpful"}
requiresfollowup: false
followupnotes: null
engagementdate: 2026-05-04T15:10:00Z
sourcejobid: mock-job-006
sourcecreatedat: 2026-05-04T15:15:00Z

Engagement 7

fieldworkexternalid: mock-engagement-007
householdidid: mock-household-007
personidid: mock-person-007
volunteeridid: mock-person-011
outcome: engaged
inputsource: telegram_voice
summary: Radio amateur with emergency response experience, willing to help
extracteddata: {"topics": ["radio", "emergency"], "sentiment": "committed"}
requiresfollowup: true
followupnotes: Connect with emergency planning group
engagementdate: 2026-05-06T09:30:00Z
sourcejobid: mock-job-007
sourcecreatedat: 2026-05-06T09:35:00Z

Engagement 8

fieldworkexternalid: mock-engagement-008
householdidid: mock-household-008
personidid: mock-person-008
volunteeridid: mock-person-011
outcome: engaged
inputsource: web_upload
summary: Conflict mediation skills, community organiser experience
extracteddata: {"topics": ["mediation", "organising"], "sentiment": "experienced"}
requiresfollowup: false
followupnotes: null
engagementdate: 2026-05-07T14:00:00Z
sourcejobid: mock-job-008
sourcecreatedat: 2026-05-07T14:05:00Z

6. Needs (6 total)

Need 1

fieldworkexternalid: mock-need-001
personidid: mock-person-002
description: May need support in emergency, especially with mobility
category: health
confidence: confirmed
sourcejobid: mock-job-002
sourcecreatedat: 2026-05-03T10:20:00Z

Need 2

fieldworkexternalid: mock-need-002
personidid: mock-person-001
description: Wants to know more about community resilience
category: education
confidence: confirmed
sourcejobid: mock-job-001
sourcecreatedat: 2026-05-01T14:35:00Z

Need 3

fieldworkexternalid: mock-need-003
personidid: mock-person-004
description: Concerned about privacy and data sharing
category: other
confidence: confirmed
sourcejobid: mock-job-004
sourcecreatedat: 2026-05-02T11:50:00Z

Need 4

fieldworkexternalid: mock-need-004
personidid: mock-person-009
description: Parish needs community space for meetings
category: other
confidence: inferred
sourcejobid: mock-job-009
sourcecreatedat: 2026-04-25T10:05:00Z

Need 5

fieldworkexternalid: mock-need-005
personidid: mock-person-005
description: Looking for others interested in community growing
category: isolation
confidence: inferred
sourcejobid: mock-job-005
sourcecreatedat: 2026-04-28T13:25:00Z

Need 6

fieldworkexternalid: mock-need-006
personidid: mock-person-006
description: Wants to contribute transport support but needs coordination
category: transport
confidence: confirmed
sourcejobid: mock-job-006
sourcecreatedat: 2026-05-04T15:15:00Z

7. Offers (6 total)

Offer 1

fieldworkexternalid: mock-offer-001
personidid: mock-person-003
description: Has tools and equipment to share with neighbors
confidence: confirmed
sourcejobid: mock-job-003
sourcecreatedat: 2026-05-05T16:05:00Z

Offer 2

fieldworkexternalid: mock-offer-002
personidid: mock-person-005
description: Can teach vegetable growing skills
confidence: confirmed
sourcejobid: mock-job-005
sourcecreatedat: 2026-04-28T13:25:00Z

Offer 3

fieldworkexternalid: mock-offer-003
personidid: mock-person-006
description: Has van, can help with transport for community events
confidence: confirmed
sourcejobid: mock-job-006
sourcecreatedat: 2026-05-04T15:15:00Z

Offer 4

fieldworkexternalid: mock-offer-004
personidid: mock-person-007
description: Radio amateur, can help with emergency communications
confidence: confirmed
sourcejobid: mock-job-007
sourcecreatedat: 2026-05-06T09:35:00Z

Offer 5

fieldworkexternalid: mock-offer-005
personidid: mock-person-008
description: Conflict mediation and community organising skills
confidence: confirmed
sourcejobid: mock-job-008
sourcecreatedat: 2026-05-07T14:05:00Z

Offer 6

fieldworkexternalid: mock-offer-006
personidid: mock-person-010
description: Church has meeting space available for community use
confidence: confirmed
sourcejobid: mock-job-010
sourcecreatedat: 2026-04-20T14:35:00Z

8. Skills (6 total)

Skill 1

fieldworkexternalid: mock-skill-001
personidid: mock-person-003
description: DIY and tool use
confidence: confirmed
sourcejobid: mock-job-003
sourcecreatedat: 2026-05-05T16:05:00Z

Skill 2

fieldworkexternalid: mock-skill-002
personidid: mock-person-005
description: Vegetable growing and gardening
confidence: confirmed
sourcejobid: mock-job-005
sourcecreatedat: 2026-04-28T13:25:00Z

Skill 3

fieldworkexternalid: mock-skill-003
personidid: mock-person-006
description: Driving and transport logistics
confidence: confirmed
sourcejobid: mock-job-006
sourcecreatedat: 2026-05-04T15:15:00Z

Skill 4

fieldworkexternalid: mock-skill-004
personidid: mock-person-007
description: Radio operation and emergency communications
confidence: confirmed
sourcejobid: mock-job-007
sourcecreatedat: 2026-05-06T09:35:00Z

Skill 5

fieldworkexternalid: mock-skill-005
personidid: mock-person-008
description: Conflict mediation and facilitation
confidence: confirmed
sourcejobid: mock-job-008
sourcecreatedat: 2026-05-07T14:05:00Z

Skill 6

fieldworkexternalid: mock-skill-006
personidid: mock-person-010
description: Community organising and faith leadership
confidence: confirmed
sourcejobid: mock-job-010
sourcecreatedat: 2026-04-20T14:35:00Z

9. ConsentRecords (6 total)

ConsentRecord 1

fieldworkexternalid: mock-consent-001
personidid: mock-person-001
consenttype: gdpr_general
status: granted
changedat: 2026-05-01T14:30:00Z
notes: Consent granted during doorstep contact
sourcecreatedat: 2026-05-01T14:30:00Z

ConsentRecord 2

fieldworkexternalid: mock-consent-002
personidid: mock-person-002
consenttype: gdpr_general
status: granted
changedat: 2026-05-03T10:15:00Z
notes: Consent granted during doorstep contact
sourcecreatedat: 2026-05-03T10:15:00Z

ConsentRecord 3

fieldworkexternalid: mock-consent-003
personidid: mock-person-003
consenttype: gdpr_general
status: granted
changedat: 2026-05-05T16:00:00Z
notes: Consent granted during doorstep contact
sourcecreatedat: 2026-05-05T16:00:00Z

ConsentRecord 4

fieldworkexternalid: mock-consent-004
personidid: mock-person-004
consenttype: gdpr_general
status: granted
changedat: 2026-05-02T11:45:00Z
notes: Consent granted but only for contact, not wider data sharing
sourcecreatedat: 2026-05-02T11:45:00Z

ConsentRecord 5

fieldworkexternalid: mock-consent-005
personidid: mock-person-009
consenttype: gdpr_general
status: granted
changedat: 2026-04-25T10:00:00Z
notes: Councillor consent for professional contact
sourcecreatedat: 2026-04-25T10:00:00Z

ConsentRecord 6

fieldworkexternalid: mock-consent-006
personidid: mock-person-012
consenttype: gdpr_general
status: not_asked
changedat: null
notes: Consent not yet requested
sourcecreatedat: 2026-05-01T14:30:00Z

10. StakeholderRelationships (4 total)

Relationship 1

fieldworkexternalid: mock-relationship-001
personidid: mock-person-010
organisationidid: mock-company-003
role: Faith leader
sourcecreatedat: 2026-04-20T14:30:00Z

Relationship 2

fieldworkexternalid: mock-relationship-002
personidid: mock-person-009
organisationidid: mock-company-002
role: Parish councillor
sourcecreatedat: 2026-04-25T10:00:00Z

Relationship 3

fieldworkexternalid: mock-relationship-003
personidid: mock-person-011
organisationidid: mock-company-004
role: Volunteer coordinator
sourcecreatedat: 2026-04-15T09:00:00Z

Relationship 4

fieldworkexternalid: mock-relationship-004
personidid: mock-person-010
organisationidid: mock-company-001
role: Community hub contact
sourcecreatedat: 2026-04-20T14:30:00Z

11. Demographics (3 total) — RESTRICTED/SENSITIVE

Note: These are demo records only. Access should be restricted to admin roles.

Demographics 1

fieldworkexternalid: mock-demographics-001
personidid: mock-person-002
ageband: 65-74
gender: Male
ethnicity: Asian British
housingtenure: Owner occupied
employmentstatus: Retired
hasdependants: false
disability: true
area: Rodborough
sourcecreatedat: 2026-05-03T10:15:00Z

Demographics 2

fieldworkexternalid: mock-demographics-002
personidid: mock-person-001
ageband: 35-44
gender: Female
ethnicity: White British
housingtenure: Rented private
employmentstatus: Employed full-time
hasdependants: true
disability: false
area: Town Centre
sourcecreatedat: 2026-05-01T14:30:00Z

Demographics 3

fieldworkexternalid: mock-demographics-003
personidid: mock-person-005
ageband: 55-64
gender: Male
ethnicity: White British
housingtenure: Owner occupied
employmentstatus: Self-employed
hasdependants: false
disability: false
area: Town Centre
sourcecreatedat: 2026-04-28T13:20:00Z

12. Tasks (4 total)

Task 1

title: Send info pack to Sarah Smith
duedate: 2026-05-08
status: TODO
assignedto: mock-person-011
notes: Follow-up from engagement mock-engagement-001

Task 2

title: Connect Rajesh Patel with buddy scheme
duedate: 2026-05-10
status: TODO
assignedto: mock-person-011
notes: Follow-up from engagement mock-engagement-002

Task 3

title: Invite Michael Brown to growing workshop
duedate: 2026-05-12
status: TODO
assignedto: mock-person-011
notes: Follow-up from engagement mock-engagement-005

Task 4

title: Connect Tom Davies with emergency planning group
duedate: 2026-05-13
status: TODO
assignedto: mock-person-011
notes: Follow-up from engagement mock-engagement-007

13. Notes (4 total)

Note 1

title: Community resilience interest
body: Sarah Smith expressed strong interest in community resilience. Send info pack and invite to next meeting.
linkedto: mock-person-001

Note 2

title: Older resident support needs
body: Rajesh Patel may need support in emergency, especially with mobility. Connect with volunteer buddy scheme.
linkedto: mock-person-002

Note 3

title: Tools and equipment sharing
body: David Jones has tools and equipment to share. Add to community resources list.
linkedto: mock-person-003

Note 4

title: Parish community space need
body: Councillor Green mentioned parish needs community space for meetings. St. Laurence Church has space available - connect them.
linkedto: mock-person-009

Summary

Total Mock Records: 63

  • 6 Locations
  • 8 Households
  • 12 People
  • 4 Companies
  • 8 Engagements
  • 6 Needs
  • 6 Offers
  • 6 Skills
  • 6 ConsentRecords
  • 4 StakeholderRelationships
  • 3 Demographics (restricted)
  • 4 Tasks
  • 4 Notes

All data is fake and for demo purposes only.