event_registrations
Households that registered for an event night. One row is one household at one event.
- One row is
- one household at one event
- Columns
- 6
- Rows in Sample
- 603
- Rows in Standard
- 6,134
- Rows in Full
- 63,327
Columns
| Column | Type | What it holds | Values or range |
|---|---|---|---|
| registration_idkey | integer | Unique id for the row. | |
| event_id | integer | Links to events. | |
| household_id | integer | The travelling party's account. Links to households. | |
| registered_at | date and time | When they signed up. | 2019-02-15 07:41 to 2025-11-21 22:53 |
| party_size | integer | People registered. | 1 to 6 |
| attended | true/false | True when they showed up. |
How it connects
This table points to
- event_id matches events.event_id
- household_id matches households.household_id
First five rows
Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.
| registration_id | event_id | household_id | registered_at | party_size | attended |
|---|---|---|---|---|---|
| 11000026 | 7001 | 1004707 | 2019-02-16 15:00:13 | 5 | true |
| 11000268 | 7001 | 1240307 | 2019-02-18 17:19:50 | 4 | true |
| 11000357 | 7002 | 1091507 | 2019-03-06 13:53:36 | 3 | true |
| 11000400 | 7002 | 1134607 | 2019-03-08 19:40:15 | 3 | true |
| 11000421 | 7002 | 1154007 | 2019-03-01 09:52:40 | 1 | true |