🦆 community notices

🎲 a game about quality for data

Author

Affiliation

✒️ Joe Leach

🏛️ LB Tower Hamlets

📝 in this game we’ll begin to forge a data contract; a brilliant way of achieving consensus in data management (see Andrew Jones 2024; Joe Leach 2024).

📜 a data contract is “an api for data” and we’re going to craft one for the sleepy village of Lower Hamlets, so their community notice board has postings are high quality and friction free!

1 🔰 setup

🏏 You are a member of the Lower Hamlets Village Green Preservation Society. the society’s mission is to maintain harmony amongst villagers, and to ensure the community notice board supports mutual aid. the society sets information standards upfront, helping prevent the kind of quality issues that might lead to squabbles later.

Preserving the old ways from being abused.
Protecting the new ways for me and for you.
What more can we do?
We are the Village Green Preservation Society (see The Kinks 1968)

1.1 ✨ quality

🤭 sometimes the villagers make mistakes in the notices. your role is to set expectations of a reliable notice, so you can catch mistakes before they are published, avoiding the potential for confusion and disharmony in the village!

💡 think about what a good clear noticeboard dataset looks like; use this to check incoming notices against the “big six” dimensions of quality expectations (see Askham et al. 2013):

Completeness: missing values
Uniqueness: duplications
Timeliness: unpunctuality
Validity: extremities
Accuracy: imprecisions
Consistency: inconsistencies

CUTVAC a handy mnemonic for remembering the dama dimensions of quality showing a picture of some scissors and a vacuum cleaner

2 🏁 let’s go

👱🏻‍♀️👩🏻‍🦰👩🏻👧🏽👧🏾 assemble the society to assess the schema; everyone has a part to play.

   [DATE] TEXT,      -- 1. date of notice
   [NAME] TEXT,      -- 2. name of sender
   [UPRN] INTEGER,   -- 3. standard location id
   [ADDRESS] TEXT,   -- 4. human readable location
   [D.O.B] TEXT,     -- 5. date of birth
   [CATEGORY] TEXT,  -- 6. category (service offered, service required, item for sale, general announcement)
   [NOTICE] TEXT     -- 7. text of notice

…and here is what an example notice might look like “on the record”

[
  {
    "DATE": "2025-01-30",
    "NAME": "Worzel Gummidge",
    "UPRN": "6733852",
    "ADDRESS": "THE GREEN, LOWER HAMLETS, LH1 1LH",
    "D.O.B": "2001-01-01",
    "CATEGORY": ["Service offered"],
    "NOTICE": "To all villagers of Lower Hamlets, I respectfully offer scarecrow services so you can keep your prize pumpkins, your tasty turnips, and your beautiful blackcurrants safe from our feathered friends."
  }
]

3 🎭gameplay

to play you roll two dice, one with seven sides (D7) and one with six (D6); the value of this roll determines the field and dimension you play.

along with your fellow villagers, decide how best to set expectations of the six quality dimensions on the seven datafields.

flowchart LR

    D7{🎲 D7}
    D6Q{🎲 D6}
    p{play}

    subgraph field
    dda[date]
    dna[name]
    dup[uprn]
    dad[address]
    ddo[d.o.b]
    dcl[category]
    dno[notice]
    end

    D7 .->|1| dda
    D7 .->|2| dna
    D7 .->|3| dup
    D7 .->|4| dad
    D7 .->|5| ddo
    D7 .->|6| dcl
    D7 .->|7| dno

    dda .-> D6Q
    dna .-> D6Q
    dup .-> D6Q
    dad .-> D6Q
    ddo .-> D6Q
    dcl .-> D6Q
    dno .-> D6Q

    subgraph "quality dimension"
    qc[completeness]
    qu[uniqueness]
    qt[timeliness]
    qv[validity]
    qa[accuracy]
    qco[consistency]
    end

    D6Q .->|1| qc
    D6Q .->|2| qu
    D6Q .->|3| qt
    D6Q .->|4| qv
    D6Q .->|5| qa
    D6Q .->|6| qco

    qc .-> p
    qu .-> p
    qt .-> p
    qv .-> p
    qa .-> p
    qco .-> p

4 🃏make your move

🎲 roll the dice!

D7: -; -
D6: -; -

jot down your solutions below.

Caution

when viewed online, the form fields on this page are transient and will disappear on reload, but you can download them as a csv at the end.

a paper version is available too:

https://joelbth.codeberg.page/community-notices/index.pdf