# Data dictionary

One row per month, canton and event type. The file is in long format and
is sparse: a combination that produced no publications has no row, which
means the same thing as a count of zero.

| Column | Type | Description |
|---|---|---|
| `month` | date | First day of the calendar month in which the publication appeared in the SHAB. |
| `canton` | string | Two-letter code of the canton whose register office published the entry. XX where the publication carries no canton. |
| `event_type` | string | Prospex's classification of what the publication announces. |
| `event_count` | integer | Publications classified into this month, canton and type. |
| `n_events_with_amount` | integer | Of those, how many stated both a prior and a new nominal capital. Zero outside CAPITAL_INCREASED. |
| `capital_delta_sum_chf` | number | Sum of new minus prior nominal capital, in CHF, over the events counted in n_events_with_amount. Empty when withheld. |
| `capital_delta_median_chf` | number | Median of the same differences, in CHF. Even-length samples take the mean of the two middle values. Empty when withheld. |
| `capital_suppressed` | boolean | True where fewer than three events carried an amount and the two capital measures are withheld. |