mbnc: Municipal Benchmarking Network Canada (MBNC) dataset. MBNC...
In jdallmann/winnipegr: winnipeg open data aggregator

Description Usage Format Source Examples

Municipal Benchmarking Network Canada (MBNC) dataset. MBNC collects and distributes efficiency statistics on participating canadian municipalities. Data pulled on 2019-12-27. Original names standardized with the janitor::clean_names function.

mbnc

A data frame with 21 columns:

measure_type_cd: MBNC classification of measurement.
municipality_id: MBNC unique municipality identifier.
fiscal_year: Fiscal year of measurement.
program_area: MBNC classification of measurement area.
municipality: Name of municipality.
section_desc: MBNC desciption of of measurement area.
measure_number: Unique identifier of measure.
measure_name: Name of measure (non-unique).
numerator: Numerator of measure (where applicable).
denominator: Denominator of measure (where applicable).
result: Either the measured result or numerator/denominator (where applicable).
numerator_definition: Definition of the numerator.
denominator_definition: Definition of the denominator.
notes: Further notes on the measure.
mpmp_measure: Whether the measure is used in mpmp.
cao_measure: Whether the measure is used in cao.
measure_category: Broad measure category.
year_created: First Year measure was instituted.
other: Other notes and peculiarities in the measure.
influencing_factor: Things contributing to the measure result.
measure: Verbose name of measure with ID. Paste of measure_name and measure_number.

Municipal Benchmarking Network Canada. Public measures. http://mbncanada.ca/

## Not run: 
 data(mbnc)

## End(Not run)
## Not run: 
# To tidy the dataset & remove notes
tidy_mbnc <- winnipegr::mbnc %>%
    select(municipality, fiscal_year, measure, result) %>%
    pivot_wider(names_from = measure, values_from = result)

## End(Not run)