The CODES field can be found in the codelist_cube_description table and is a comma seperated list filter ids, which can be found in the codes table with the ID field.
SELECT IS_ID, CODES FROM codelist_cube_description;| IS_ID | CODES |
|---|---|
| 1 | 10, 1962, 1975 |
| 2 | 10, 1964 |
| 3 | 11, 1962, 1975 |
| ... | ... |
These CODES are the filter ids for a given topic. You can find the definitions of these CODES by performing the following query:
SELECT CLID, ID, DESCRP FROM code WHERE ID IN (11, 1962, 1975);| CLID | ID | DESCRP |
|---|---|---|
| 1 | 11 | In commercial building |
| 68 | 1962 | Persons |
| 69 | 1975 | All usual residents in households |