I was helping a researcher who's looking for "the breakdown of the prostitution offences by each offence (e.i. incidents for s.213, s.286.1 etc)".
From this table:
35-10-0177-01 - Incident-based crime statistics, by detailed violations, Canada, provinces, territories and Census Metropolitan Areas
We can get the breakdown of the prostitution offences (classified under Total Commodification of sexual activity violations, and Total Prostitution) by types of offences.
Next, in order to map those types of offences to criminal codes (such as s.213, s.286.1 etc), we consulted the questionnaire and the reporting guide linked from this page: http://www23.statcan.gc.ca/imdb/p3Instr.pl?Function=getInstrumentList&Item_Id=55196&UL=1V&
Basically, we figured out that on the questionnaire(PDF), there is the code for "Prostitution Total" (046) as well as the more specific codes below it; and from the reporting guide (p. 86), it shows how that code is linked to criminal code (section 213 etc). Although the codes in the stats don't align with the codes on the questionnaire, for example, bawdy house 3110 vs. 047, we can just match them up by the same description (i.e. bawdy house).
However, there are still some critical problems -- the questions in the questionnaire don't entirely reflect the crime hierarchy of stats, for example, there's no "Total Commodification of sexual activity violations" and its breakdown on the questionnaire, and we suspect it's because the questionnaire/reporting guide on the website needs to be updated. Furthermore, since the researcher is interested in the impact of the 2014 legislation, it would be useful to get access to the questionnaires/reporting guide of different times, which are unavailable from the website.
Sorry for this rambling email. I'd appreciate it if you can shed some light on this.
I’ve received the following response from subject matter:
“If your researcher hasn’t seen the tables of concordance contained in the 2019 UCR manual (attached), it could be very useful. It is a comprehensive lookup table that cross references all Criminal Code sections to their respective UCR2 violation codes.
The 3-digit UCR codes mentioned, such as ‘Prostitution Total (046)’, come for the old UCR1 Aggregate survey, which is no longer in use and has not been for a long time.
All of our current online CODR (new CANSIM) tables are based on the 4-digit UCR2 codes.”
"... [data tables] are readily available via the website. These are customizable and downloadable. Below is the CAN/PROV/CMA table, there are also similar police service level tables that can be found on the site as well.
Incident-based crime statistics, by detailed violations, Canada, provinces, territories and Census Metropolitan Areas
"[The manual] is not available on the website, we distribute it to our partners, but also to anyone who requests it”