Intercept Question Codebook
LISTING.INTERCEPT_RESPONSES is intentionally wide because some fields are part of the shared Inhabit Place interview structure, while others come from project-specific questionnaires.
This page maps the published Snowflake columns back to the question text or prompt currently defined in the Inhabit Place dashboard app.
Shared interview questions
Section titled “Shared interview questions”These are the standard interview fields used across the core impressions and insights views.
| Snowflake field | Question or prompt |
|---|---|
HowOftenVisit | How often do you visit the space? |
HowUsing | What brought you to this space? |
Recognise | Do you recognise anyone in the space? |
SpokenToNew | Have you spoken to anyone new while you’ve been here? |
FeelSafe | Do you feel safe in the space? |
MakesYouFeel, MakesYouFeel2, MakesYouFeel3 | Describe how the space makes you feel. |
EncourageMoreTime, EncourageMoreTime2, EncourageMoreTime3 | What would inspire you to spend more time here? / What would make your experience more comfortable? |
Comments | Further comment on the space. |
Postcode | Where do you reside? |
Shared impressions questions
Section titled “Shared impressions questions”The glossary documents these as impression rankings using the response scale Very Poor, Poor, Neutral, Good, and Very Good.
| Snowflake field | Question theme |
|---|---|
Comfort | Comfort of infrastructure |
Friendly | Friendly and welcoming |
Cleanliness | Cleanliness |
Attractiveness | Attractiveness |
Shared demographic and consent fields
Section titled “Shared demographic and consent fields”These fields are part of the intercept record but are not rich questionnaire prompts in the same way as the perception and custom-question fields.
| Snowflake field | Meaning |
|---|---|
Agreed | Consent or agreement flag for the interview record |
Age | Respondent age grouping |
Gender | Respondent gender grouping |
Country | Respondent country value where collected |
Structural and label fields
Section titled “Structural and label fields”Some fields are present in the intercept record but are not respondent answers. They are section labels, publication controls, or report-layout markers.
| Snowflake field | Meaning |
|---|---|
COMLabel, GinninderryLabel, ArthurGreyLowTrafficArea | Project or section label fields |
StartNewReportColumn, StartNewReportColumnAGLTA | Report layout control fields |
FormInserted, FormUpdated | Record lifecycle timestamps |
ShiftCheckInGuid, AuditGuid, InterceptGuid, InterceptID | Record and audit linkage identifiers |
Notes on repeated columns
Section titled “Notes on repeated columns”- Fields ending in
2or3usually represent additional answers to the same prompt. - Not every project-specific question set is populated in every audit.
- Where a field appears in the Snowflake table but no explicit prompt is currently defined in the dashboard source, it should be treated as project-specific or structural until a stronger codebook source is added.