data-raw/prep_monthly_ccg_data_raw.R

monthly_ccg_data_raw <- structure(list(data_collection = c("MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA",
                                                  "MRSA", "MRSA", "MRSA", "MRSA", "MRSA", "MRSA"), ccg_code = c("00C",
                                                                                                                "00D", "00D", "00D", "00D", "00D", "00D", "00D", "00J", "00J",
                                                                                                                "00J", "00J", "00J", "00K", "00L", "00L", "00L", "00L", "00M",
                                                                                                                "00M", "00M", "00N", "00N", "00N", "00N", "00N", "00N", "00P",
                                                                                                                "00P", "00P", "00P", "00Q", "00R", "00R", "00R", "00R", "00T",
                                                                                                                "00T", "00T", "00T", "00T", "00T", "00T", "00T", "00T", "00V",
                                                                                                                "00X", "00Y", "00Y", "00Y", "00Y", "00Y", "01A", "01A", "01A",
                                                                                                                "01A", "01A", "01A", "01C", "01C", "01C", "01C", "01D", "01G",
                                                                                                                "01G", "01H", "01H", "01J", "01J", "01R", "01R", "01R", "01R",
                                                                                                                "01T", "01T", "01T", "01V", "01V", "01W", "01X", "01X", "01X",
                                                                                                                "01X", "01X", "01Y", "01Y", "01Y", "01Y", "01Y", "01Y", "02A",
                                                                                                                "02A", "02A", "02D", "02D", "02E", "02F", "02F", "02F", "02F",
                                                                                                                "02G", "02G", "02G", "02H", "02H", "02H", "02H", "02H", "02H",
                                                                                                                "02M", "02M", "02M", "02N", "02P", "02P", "02P", "02Q", "02R",
                                                                                                                "02R", "02R", "02R", "02R", "02R", "02R", "02T", "02T", "02T",
                                                                                                                "02V", "02V", "02V", "02V", "02W", "02W", "02X", "02X", "02Y",
                                                                                                                "03A", "03A", "03A", "03A", "03A", "03A", "03A", "03C", "03C",
                                                                                                                "03C", "03C", "03C", "03D", "03D", "03D", "03E", "03E", "03G",
                                                                                                                "03G", "03G", "03G", "03H", "03J", "03J", "03K", "03L", "03L",
                                                                                                                "03M", "03M", "03M", "03N", "03N", "03Q", "03Q", "03Q", "03Q",
                                                                                                                "03Q", "03Q", "03Q", "03Q", "03Q", "03R", "03R", "03R", "03R",
                                                                                                                "03R", "03T", "03T", "03V", "03W", "03W", "03X", "04C", "04C",
                                                                                                                "04C", "04C", "04D", "04D", "04E", "04E", "04E", "04E", "04F",
                                                                                                                "04F", "04F", "04F", "04F", "04G", "04G", "04G", "04G", "04G",
                                                                                                                "04G", "04G", "04H", "04H", "04J", "04J", "04J", "04K", "04K",
                                                                                                                "04K", "04K", "04L", "04L", "04L", "04R", "04R", "04R", "04R",
                                                                                                                "04R", "04R", "04R", "04V", "04V", "04X", "04X", "04X", "04Y",
                                                                                                                "04Y", "04Y", "05A", "05A", "05A", "05A", "05A", "05C", "05C",
                                                                                                                "05D", "05D", "05D", "05D", "05F", "05F", "05G", "05H", "05J",
                                                                                                                "05L", "05L", "05L", "05L", "05L", "05N", "05N", "05P", "05P",
                                                                                                                "05P", "05P", "05P", "05Q", "05Q", "05Q", "05Q", "05R", "05T",
                                                                                                                "05T", "05T", "05T", "05V", "05W", "05W", "05W", "05W", "05W",
                                                                                                                "05W", "05X", "05X", "05Y", "05Y", "05Y", "06A", "06D", "06F",
                                                                                                                "06F", "06F", "06F", "06F", "06H", "06H", "06H", "06H", "06H",
                                                                                                                "06H", "06H", "06K", "06K", "06K", "06K", "06K", "06K", "06L",
                                                                                                                "06L", "06L", "06N", "06N", "06N", "06N", "06N", "06P", "06P",
                                                                                                                "06P", "06P", "06Q", "06Q", "06Q", "06Q", "06Q", "06T", "06T",
                                                                                                                "06V", "06W", "06W", "06W", "06W", "06Y", "07G", "07G", "07G",
                                                                                                                "07G", "07G", "07G", "07H", "07H", "07H", "07H", "07J", "07J",
                                                                                                                "07J", "07J", "07K", "07K", "07K", "07K", "07K", "07K", "07K",
                                                                                                                "07K", "07K", "07L", "07L", "07L", "07M", "07M", "07M", "07M",
                                                                                                                "07M", "07M", "07M", "07M", "07N", "07N", "07N", "07N", "07N",
                                                                                                                "07N", "07P", "07P", "07P", "07P", "07P", "07P", "07Q", "07Q",
                                                                                                                "07R", "07R", "07R", "07R", "07R", "07T", "07T", "07T", "07V",
                                                                                                                "07V", "07V", "07V", "07W", "07W", "07W", "07W", "07W", "07W",
                                                                                                                "07X", "07X", "07X", "07X", "07X", "07Y", "07Y", "07Y", "07Y",
                                                                                                                "08A", "08A", "08A", "08A", "08C", "08D", "08D", "08D", "08D",
                                                                                                                "08E", "08E", "08E", "08E", "08E", "08E", "08E", "08F", "08F",
                                                                                                                "08F", "08G", "08G", "08G", "08G", "08G", "08H", "08H", "08H",
                                                                                                                "08H", "08J", "08J", "08J", "08J", "08J", "08K", "08K", "08K",
                                                                                                                "08K", "08K", "08L", "08L", "08L", "08L", "08M", "08M", "08M",
                                                                                                                "08M", "08M", "08M", "08M", "08N", "08N", "08N", "08N", "08P",
                                                                                                                "08P", "08P", "08P", "08Q", "08Q", "08Q", "08R", "08T", "08T",
                                                                                                                "08T", "08T", "08V", "08V", "08V", "08V", "08V", "08W", "08W",
                                                                                                                "08X", "08Y", "08Y", "08Y", "08Y", "09A", "09C", "09C", "09C",
                                                                                                                "09C", "09C", "09D", "09D", "09E", "09F", "09G", "09G", "09G",
                                                                                                                "09G", "09G", "09H", "09H", "09J", "09J", "09J", "09J", "09J",
                                                                                                                "09J", "09J", "09L", "09L", "09L", "09N", "09N", "09N", "09N",
                                                                                                                "09P", "09P", "09P", "09P", "09W", "09W", "09W", "09X", "09X",
                                                                                                                "09Y", "09Y", "09Y", "10A", "10A", "10A", "10A", "10A", "10A",
                                                                                                                "10A", "10A", "10A", "10C", "10C", "10D", "10E", "10E", "10E",
                                                                                                                "10E", "10E", "10G", "10G", "10G", "10H", "10H", "10H", "10H",
                                                                                                                "10K", "10L", "10M", "10N", "10N", "10Q", "10Q", "10Q", "10Q",
                                                                                                                "10Q", "10R", "10R", "10R", "10R", "10W", "10W", "10Y", "10Y",
                                                                                                                "10Y", "10Y", "10Y", "10Y", "11A", "11A", "11A", "11C", "11C",
                                                                                                                "11C", "11C", "11D", "11D", "11E", "11E", "11H", "11H", "11H",
                                                                                                                "11H", "11H", "11H", "11H", "11H", "11H", "11H", "11H", "11H",
                                                                                                                "11J", "11J", "11J", "11J", "11J", "11J", "11M", "11M", "11M",
                                                                                                                "11M", "11M", "11M", "11M", "11N", "11N", "11N", "11N", "11T",
                                                                                                                "11T", "11T", "11T", "11T", "11T", "11T", "11X", "11X", "11X",
                                                                                                                "11X", "11X", "11X", "12A", "12A", "12A", "12A", "12A", "12D",
                                                                                                                "12F", "12F", "12F", "13P", "13P", "13P", "13P", "13P", "13P",
                                                                                                                "13T", "13T", "13T", "13T", "13T", "14L", "14L", "14L", "14L",
                                                                                                                "14L", "14L", "14L", "14L", "14L", "99A", "99A", "99A", "99A",
                                                                                                                "99A", "99A", "99A", "99A", "99A", "99C", "99C", "99C", "99E",
                                                                                                                "99E", "99E", "99E", "99E", "99E", "99F", "99F", "99F", "99F",
                                                                                                                "99F", "99F", "99G", "99G", "99G", "99G", "99G", "99H", "99H",
                                                                                                                "99H", "99H", "99H", "99J", "99J", "99J", "99J", "99K", "99K",
                                                                                                                "99K", "99K", "99M", "99M", "99N", "99N", "99N", "99N", "99N",
                                                                                                                "99N", "99N", "99P", "99P", "99P", "99P", "99P", "99P", "99Q",
                                                                                                                "99Q", "99Q"), fyear6 = c("201617", "201617", "201617", "201617",
                                                                                                                                          "201617", "201617", "201718", "201718", "201617", "201617", "201617",
                                                                                                                                          "201718", "201718", "201617", "201617", "201617", "201617", "201617",
                                                                                                                                          "201617", "201617", "201718", "201617", "201617", "201617", "201718",
                                                                                                                                          "201718", "201718", "201617", "201617", "201718", "201718", "201718",
                                                                                                                                          "201617", "201617", "201617", "201617", "201617", "201617", "201617",
                                                                                                                                          "201617", "201617", "201617", "201617", "201617", "201718", "201718",
                                                                                                                                          "201617", "201617", "201617", "201617", "201718", "201718", "201617",
                                                                                                                                          "201617", "201617", "201617", "201718", "201718", "201617", "201617",
                                                                                                                                          "201617", "201718", "201617", "201617", "201617", "201617", "201617",
                                                                                                                                          "201617", "201718", "201617", "201617", "201718", "201718", "201617",
                                                                                                                                          "201617", "201718", "201617", "201617", "201617", "201617", "201617",
                                                                                                                                          "201617", "201617", "201718", "201617", "201617", "201617", "201617",
                                                                                                                                          "201718", "201718", "201617", "201617", "201718", "201617", "201718",
                                                                                                                                          "201718", "201617", "201617", "201617", "201617", "201617", "201617",
                                                                                                                                          "201617", "201617", "201617", "201617", "201617", "201718", "201718",
                                                                                                                                          "201617", "201617", "201617", "201617", "201617", "201718", "201718",
                                                                                                                                          "201617", "201617", "201617", "201617", "201617", "201718", "201718",
                                                                                                                                          "201718", "201617", "201718", "201718", "201617", "201617", "201617",
                                                                                                                                          "201718", "201617", "201617", "201718", "201718", "201718", "201617",
                                                                                                                                          "201617", "201617", "201617", "201718", "201718", "201718", "201617",
                                                                                                                                          "201617", "201617", "201718", "201718", "201617", "201617", "201617",
                                                                                                                                          "201617", "201718", "201617", "201617", "201617", "201718", "201617",
                                                                                                                                          "201617", "201617", "201617", "201617", "201617", "201617", "201617",
                                                                                                                                          "201718", "201617", "201718", "201617", "201617", "201617", "201617",
                                                                                                                                          "201617", "201718", "201718", "201718", "201718", "201617", "201617",
                                                                                                                                          "201617", "201617", "201718", "201617", "201617", "201617", "201617",
                                                                                                                                          "201718", "201718", "201617", "201617", "201617", "201617", "201617",
                                                                                                                                          "201718", "201617", "201617", "201617", "201718", "201617", "201617",
                                                                                                                                          "201617", "201718", "201718", "201617", "201617", "201617", "201617",
                                                                                                                                          "201718", "201718", "201718", "201718", "201718", "201617", "201617",
                                                                                                                                          "201718", "201617", "201617", "201718", "201718", "201617", "201617",
                                                                                                                                          "201617", "201617", "201617", "201617", "201617", "201617", "201617",
                                                                                                                                          "201718", "201617", "201718", "201617", "201617", "201718", "201617",
                                                                                                                                          "201617", "201617", "201617", "201617", "201718", "201718", "201718",
                                                                                                                                          "201617", "201617", "201617", "201617", "201718", "201718", "201718",
                                                                                                                                          "201718", "201617", "201617", "201617", "201617", "201617", "201617",
                                                                                                                                          "201718", "201718", "201617", "201617", "201617", "201617", "201617",
                                                                                                                                          "201718", "201718", "201617", "201617", "201617", "201617", "201617",
                                                                                                                                          "201617", "201617", "201617", "201617", "201718", "201617", "201617",
                                                                                                                                          "201617", "201718", "201718", "201718", "201617", "201617", "201617",
                                                                                                                                          "201617", "201718", "201617", "201617", "201617", "201617", "201617",
                                                                                                                                          "201617", "201718", "201617", "201617", "201617", "201617", "201617",
                                                                                                                                          "201718", "201718", "201617", "201617", "201617", "201617", "201617",
                                                                                                                                          "201718", "201617", "201718", "201718", "201617", "201617", "201617",
                                                                                                                                          "201617", "201718", "201617", "201617", "201617", "201718", "201617",
                                                                                                                                          "201617", "201617", "201617", "201718", "201617", "201617", "201617",
                                                                                                                                          "201617", "201617", "201718", "201718", "201617", "201617", "201617",
                                                                                                                                          "201617", "201617", "201718", "201718", "201617", "201617", "201617",
                                                                                                                                          "201617", "201617", "201617", "201617", "201718", "201617", "201617",
                                                                                                                                          "201617", "201617", "201617", "201617", "201718", "201718", "201718",
                                                                                                                                          "201617", "201617", "201718", "201617", "201617", "201617", "201617",
                                                                                                                                          "201617", "201617", "201718", "201718", "201617", "201617", "201617",
                                                                                                                                          "201718", "201718", "201718", "201617", "201617", "201617", "201617",
                                                                                                                                          "201718", "201718", "201617", "201718", "201617", "201617", "201617",
                                                                                                                                          "201617", "201718", "201617", "201617", "201617", "201617", "201617",
                                                                                                                                          "201718", "201718", "201617", "201617", "201617", "201617", "201718",
                                                                                                                                          "201718", "201617", "201617", "201617", "201617", "201718", "201617",
                                                                                                                                          "201617", "201617", "201718", "201617", "201617", "201718", "201718",
                                                                                                                                          "201718", "201617", "201617", "201718", "201718", "201617", "201617",
                                                                                                                                          "201617", "201617", "201718", "201718", "201718", "201617", "201718",
                                                                                                                                          "201718", "201617", "201617", "201617", "201617", "201718", "201617",
                                                                                                                                          "201617", "201617", "201718", "201617", "201617", "201718", "201718",
                                                                                                                                          "201718", "201617", "201617", "201617", "201718", "201718", "201617",
                                                                                                                                          "201617", "201718", "201718", "201617", "201617", "201617", "201617",
                                                                                                                                          "201617", "201718", "201718", "201617", "201617", "201718", "201718",
                                                                                                                                          "201617", "201617", "201617", "201718", "201617", "201617", "201617",
                                                                                                                                          "201617", "201617", "201617", "201617", "201617", "201617", "201617",
                                                                                                                                          "201617", "201617", "201718", "201617", "201718", "201617", "201617",
                                                                                                                                          "201617", "201617", "201617", "201617", "201617", "201617", "201617",
                                                                                                                                          "201718", "201718", "201617", "201718", "201617", "201718", "201617",
                                                                                                                                          "201617", "201617", "201617", "201718", "201617", "201617", "201617",
                                                                                                                                          "201617", "201617", "201617", "201617", "201718", "201718", "201617",
                                                                                                                                          "201617", "201617", "201617", "201617", "201718", "201718", "201617",
                                                                                                                                          "201617", "201617", "201718", "201617", "201617", "201617", "201617",
                                                                                                                                          "201718", "201617", "201617", "201718", "201617", "201617", "201617",
                                                                                                                                          "201617", "201617", "201617", "201718", "201718", "201718", "201617",
                                                                                                                                          "201718", "201718", "201617", "201617", "201617", "201617", "201718",
                                                                                                                                          "201617", "201617", "201718", "201617", "201617", "201718", "201718",
                                                                                                                                          "201718", "201617", "201617", "201617", "201617", "201617", "201617",
                                                                                                                                          "201617", "201617", "201718", "201617", "201718", "201718", "201718",
                                                                                                                                          "201617", "201718", "201617", "201617", "201617", "201617", "201617",
                                                                                                                                          "201718", "201617", "201617", "201718", "201617", "201617", "201617",
                                                                                                                                          "201718", "201617", "201617", "201617", "201718", "201617", "201617",
                                                                                                                                          "201617", "201617", "201617", "201617", "201617", "201617", "201718",
                                                                                                                                          "201718", "201718", "201718", "201617", "201617", "201617", "201718",
                                                                                                                                          "201718", "201718", "201617", "201617", "201617", "201617", "201617",
                                                                                                                                          "201718", "201718", "201617", "201617", "201617", "201617", "201617",
                                                                                                                                          "201617", "201617", "201617", "201617", "201617", "201718", "201617",
                                                                                                                                          "201617", "201617", "201617", "201718", "201718", "201617", "201617",
                                                                                                                                          "201617", "201718", "201718", "201718", "201617", "201617", "201718",
                                                                                                                                          "201617", "201617", "201617", "201617", "201617", "201718", "201617",
                                                                                                                                          "201617", "201617", "201718", "201718", "201617", "201617", "201617",
                                                                                                                                          "201617", "201617", "201617", "201718", "201718", "201718", "201617",
                                                                                                                                          "201617", "201617", "201617", "201617", "201617", "201718", "201718",
                                                                                                                                          "201718", "201617", "201617", "201617", "201617", "201617", "201617",
                                                                                                                                          "201617", "201718", "201718", "201617", "201617", "201617", "201617",
                                                                                                                                          "201718", "201718", "201617", "201617", "201617", "201718", "201718",
                                                                                                                                          "201617", "201617", "201617", "201718", "201718", "201617", "201617",
                                                                                                                                          "201617", "201617", "201617", "201617", "201617", "201617", "201617",
                                                                                                                                          "201718", "201617", "201617", "201617", "201617", "201718", "201718",
                                                                                                                                          "201718", "201617", "201617", "201617", "201718", "201718", "201718",
                                                                                                                                          "201617", "201617", "201718"), year_no = c(2016, 2016, 2016,
                                                                                                                                                                                     2016, 2016, 2017, 2017, 2017, 2016, 2017, 2017, 2017, 2017, 2016,
                                                                                                                                                                                     2016, 2016, 2017, 2017, 2016, 2017, 2017, 2016, 2016, 2016, 2017,
                                                                                                                                                                                     2017, 2017, 2016, 2016, 2017, 2017, 2017, 2016, 2016, 2016, 2017,
                                                                                                                                                                                     2016, 2016, 2016, 2016, 2016, 2016, 2017, 2017, 2017, 2017, 2016,
                                                                                                                                                                                     2016, 2016, 2016, 2017, 2017, 2016, 2016, 2016, 2017, 2017, 2017,
                                                                                                                                                                                     2016, 2016, 2016, 2017, 2017, 2016, 2016, 2016, 2017, 2017, 2017,
                                                                                                                                                                                     2016, 2017, 2017, 2017, 2016, 2017, 2017, 2016, 2017, 2016, 2016,
                                                                                                                                                                                     2016, 2016, 2017, 2017, 2016, 2016, 2017, 2017, 2017, 2017, 2016,
                                                                                                                                                                                     2017, 2017, 2017, 2017, 2017, 2016, 2016, 2016, 2017, 2016, 2016,
                                                                                                                                                                                     2016, 2016, 2016, 2017, 2017, 2017, 2017, 2016, 2017, 2017, 2016,
                                                                                                                                                                                     2016, 2017, 2017, 2016, 2016, 2016, 2016, 2017, 2017, 2017, 2017,
                                                                                                                                                                                     2016, 2017, 2017, 2016, 2016, 2017, 2017, 2016, 2016, 2017, 2017,
                                                                                                                                                                                     2017, 2016, 2016, 2017, 2017, 2017, 2017, 2017, 2016, 2016, 2017,
                                                                                                                                                                                     2017, 2017, 2016, 2016, 2016, 2016, 2017, 2016, 2016, 2016, 2017,
                                                                                                                                                                                     2017, 2016, 2017, 2017, 2016, 2017, 2016, 2016, 2017, 2016, 2017,
                                                                                                                                                                                     2016, 2016, 2017, 2017, 2017, 2017, 2017, 2017, 2017, 2016, 2016,
                                                                                                                                                                                     2017, 2017, 2017, 2017, 2017, 2017, 2016, 2017, 2017, 2016, 2016,
                                                                                                                                                                                     2017, 2017, 2017, 2017, 2016, 2016, 2017, 2017, 2016, 2016, 2016,
                                                                                                                                                                                     2017, 2017, 2016, 2016, 2016, 2016, 2017, 2017, 2017, 2017, 2017,
                                                                                                                                                                                     2016, 2016, 2017, 2016, 2016, 2017, 2017, 2016, 2016, 2017, 2016,
                                                                                                                                                                                     2016, 2016, 2016, 2017, 2017, 2017, 2016, 2017, 2017, 2017, 2017,
                                                                                                                                                                                     2016, 2016, 2017, 2016, 2017, 2017, 2017, 2017, 2016, 2016, 2016,
                                                                                                                                                                                     2017, 2017, 2017, 2017, 2017, 2017, 2017, 2016, 2016, 2016, 2016,
                                                                                                                                                                                     2017, 2017, 2016, 2016, 2016, 2017, 2017, 2017, 2017, 2016, 2016,
                                                                                                                                                                                     2016, 2017, 2017, 2016, 2016, 2017, 2017, 2017, 2016, 2017, 2017,
                                                                                                                                                                                     2017, 2017, 2017, 2016, 2017, 2016, 2017, 2017, 2016, 2016, 2016,
                                                                                                                                                                                     2016, 2016, 2017, 2017, 2016, 2016, 2016, 2017, 2017, 2017, 2017,
                                                                                                                                                                                     2016, 2016, 2016, 2017, 2017, 2017, 2017, 2017, 2017, 2016, 2016,
                                                                                                                                                                                     2017, 2017, 2017, 2016, 2017, 2017, 2017, 2016, 2016, 2017, 2017,
                                                                                                                                                                                     2017, 2016, 2016, 2017, 2016, 2017, 2017, 2017, 2016, 2016, 2016,
                                                                                                                                                                                     2016, 2017, 2017, 2017, 2016, 2016, 2017, 2017, 2016, 2016, 2017,
                                                                                                                                                                                     2017, 2016, 2016, 2016, 2016, 2016, 2017, 2017, 2017, 2017, 2016,
                                                                                                                                                                                     2016, 2017, 2016, 2016, 2016, 2017, 2017, 2017, 2017, 2017, 2016,
                                                                                                                                                                                     2016, 2016, 2017, 2017, 2017, 2016, 2016, 2016, 2016, 2017, 2017,
                                                                                                                                                                                     2016, 2017, 2016, 2016, 2016, 2016, 2017, 2016, 2017, 2017, 2016,
                                                                                                                                                                                     2016, 2017, 2017, 2016, 2016, 2016, 2016, 2017, 2017, 2016, 2016,
                                                                                                                                                                                     2017, 2017, 2017, 2016, 2016, 2017, 2017, 2016, 2017, 2017, 2017,
                                                                                                                                                                                     2017, 2016, 2016, 2017, 2017, 2016, 2016, 2017, 2017, 2017, 2017,
                                                                                                                                                                                     2017, 2017, 2017, 2017, 2016, 2016, 2016, 2017, 2017, 2016, 2016,
                                                                                                                                                                                     2017, 2017, 2016, 2017, 2017, 2017, 2017, 2016, 2017, 2017, 2017,
                                                                                                                                                                                     2017, 2016, 2017, 2017, 2017, 2016, 2016, 2016, 2016, 2017, 2017,
                                                                                                                                                                                     2017, 2016, 2017, 2017, 2017, 2016, 2016, 2017, 2017, 2016, 2016,
                                                                                                                                                                                     2017, 2017, 2016, 2016, 2016, 2017, 2016, 2016, 2016, 2017, 2017,
                                                                                                                                                                                     2016, 2017, 2016, 2016, 2016, 2016, 2017, 2016, 2016, 2017, 2017,
                                                                                                                                                                                     2017, 2017, 2017, 2017, 2016, 2017, 2016, 2016, 2017, 2017, 2017,
                                                                                                                                                                                     2016, 2017, 2016, 2016, 2016, 2017, 2017, 2017, 2017, 2016, 2016,
                                                                                                                                                                                     2017, 2016, 2016, 2017, 2017, 2016, 2016, 2016, 2017, 2016, 2016,
                                                                                                                                                                                     2017, 2016, 2017, 2017, 2017, 2017, 2016, 2016, 2016, 2017, 2017,
                                                                                                                                                                                     2017, 2017, 2017, 2017, 2016, 2017, 2017, 2016, 2016, 2016, 2017,
                                                                                                                                                                                     2017, 2017, 2017, 2017, 2017, 2017, 2017, 2017, 2017, 2016, 2017,
                                                                                                                                                                                     2017, 2017, 2016, 2016, 2017, 2017, 2017, 2017, 2017, 2017, 2017,
                                                                                                                                                                                     2016, 2017, 2016, 2016, 2017, 2017, 2017, 2017, 2017, 2017, 2017,
                                                                                                                                                                                     2016, 2017, 2017, 2017, 2016, 2017, 2016, 2017, 2016, 2016, 2016,
                                                                                                                                                                                     2016, 2016, 2017, 2017, 2017, 2017, 2017, 2017, 2017, 2016, 2017,
                                                                                                                                                                                     2017, 2017, 2017, 2017, 2016, 2016, 2016, 2017, 2017, 2017, 2017,
                                                                                                                                                                                     2016, 2016, 2017, 2017, 2016, 2016, 2016, 2016, 2017, 2017, 2017,
                                                                                                                                                                                     2016, 2016, 2016, 2017, 2017, 2017, 2016, 2016, 2017, 2017, 2017,
                                                                                                                                                                                     2017, 2016, 2017, 2017, 2016, 2016, 2016, 2016, 2017, 2017, 2016,
                                                                                                                                                                                     2016, 2017, 2017, 2017, 2016, 2016, 2016, 2017, 2017, 2017, 2017,
                                                                                                                                                                                     2017, 2017, 2016, 2016, 2016, 2016, 2017, 2017, 2017, 2017, 2017,
                                                                                                                                                                                     2016, 2017, 2017, 2016, 2016, 2016, 2016, 2017, 2017, 2016, 2016,
                                                                                                                                                                                     2017, 2017, 2017, 2017, 2016, 2017, 2017, 2017, 2017, 2016, 2017,
                                                                                                                                                                                     2017, 2017, 2017, 2016, 2016, 2017, 2017, 2016, 2017, 2017, 2017,
                                                                                                                                                                                     2016, 2017, 2016, 2016, 2016, 2016, 2017, 2017, 2017, 2016, 2016,
                                                                                                                                                                                     2017, 2017, 2017, 2017, 2017, 2017, 2017), month_no = c(10, 7,
                                                                                                                                                                                                                                             8, 10, 11, 1, 4, 5, 9, 1, 3, 5, 6, 9, 7, 10, 2, 3, 8, 2, 4, 10,
                                                                                                                                                                                                                                             11, 12, 5, 6, 7, 8, 10, 5, 7, 7, 8, 9, 12, 3, 7, 8, 9, 10, 11,
                                                                                                                                                                                                                                             12, 1, 3, 5, 7, 9, 8, 9, 11, 6, 7, 7, 9, 12, 1, 5, 6, 8, 10,
                                                                                                                                                                                                                                             11, 5, 1, 7, 10, 7, 2, 1, 7, 12, 3, 5, 6, 9, 1, 6, 8, 1, 12,
                                                                                                                                                                                                                                             7, 9, 12, 1, 4, 7, 8, 1, 2, 5, 7, 11, 1, 5, 3, 4, 7, 9, 10, 12,
                                                                                                                                                                                                                                             1, 7, 8, 11, 11, 12, 1, 3, 4, 6, 10, 2, 3, 9, 8, 5, 6, 11, 10,
                                                                                                                                                                                                                                             11, 12, 3, 4, 5, 6, 12, 5, 6, 11, 12, 2, 6, 8, 10, 4, 5, 4, 8,
                                                                                                                                                                                                                                             12, 1, 2, 5, 6, 7, 8, 11, 3, 5, 6, 9, 10, 11, 12, 4, 7, 8, 12,
                                                                                                                                                                                                                                             4, 1, 10, 1, 2, 9, 1, 8, 11, 7, 12, 4, 8, 10, 1, 2, 3, 4, 5,
                                                                                                                                                                                                                                             6, 7, 7, 9, 2, 3, 5, 1, 2, 2, 11, 7, 7, 7, 10, 2, 3, 1, 6, 7,
                                                                                                                                                                                                                                             12, 1, 7, 7, 8, 12, 6, 7, 7, 8, 10, 12, 5, 6, 7, 4, 5, 8, 9,
                                                                                                                                                                                                                                             5, 8, 11, 6, 7, 11, 12, 3, 9, 10, 11, 12, 1, 2, 4, 9, 7, 1, 2,
                                                                                                                                                                                                                                             5, 9, 11, 1, 12, 2, 4, 5, 6, 8, 11, 10, 3, 5, 6, 4, 6, 1, 1,
                                                                                                                                                                                                                                             11, 7, 9, 11, 4, 6, 8, 12, 12, 1, 2, 5, 7, 7, 11, 12, 1, 2, 7,
                                                                                                                                                                                                                                             9, 2, 3, 7, 8, 1, 2, 4, 5, 6, 11, 2, 11, 1, 6, 10, 12, 10, 11,
                                                                                                                                                                                                                                             12, 3, 5, 7, 10, 12, 1, 2, 4, 6, 7, 10, 11, 1, 3, 6, 1, 4, 5,
                                                                                                                                                                                                                                             10, 12, 1, 3, 7, 11, 2, 3, 4, 9, 11, 1, 2, 4, 8, 12, 2, 11, 1,
                                                                                                                                                                                                                                             4, 5, 9, 8, 9, 11, 2, 6, 7, 7, 8, 1, 3, 8, 10, 2, 4, 7, 8, 9,
                                                                                                                                                                                                                                             10, 12, 2, 4, 6, 7, 9, 11, 6, 7, 8, 10, 1, 2, 3, 5, 6, 10, 11,
                                                                                                                                                                                                                                             12, 4, 5, 6, 7, 9, 10, 11, 5, 7, 10, 4, 8, 9, 11, 12, 4, 11,
                                                                                                                                                                                                                                             2, 3, 8, 11, 4, 7, 7, 8, 9, 12, 5, 6, 8, 11, 1, 2, 4, 9, 12,
                                                                                                                                                                                                                                             2, 7, 8, 1, 4, 5, 4, 10, 11, 6, 7, 8, 10, 1, 3, 4, 5, 6, 1, 6,
                                                                                                                                                                                                                                             7, 7, 9, 12, 3, 5, 8, 10, 2, 6, 9, 2, 4, 5, 6, 9, 1, 3, 4, 6,
                                                                                                                                                                                                                                             9, 2, 4, 5, 9, 10, 11, 12, 1, 6, 7, 9, 1, 6, 7, 10, 11, 3, 4,
                                                                                                                                                                                                                                             9, 10, 1, 2, 8, 10, 12, 2, 9, 10, 11, 3, 7, 12, 6, 10, 7, 10,
                                                                                                                                                                                                                                             11, 2, 10, 7, 1, 2, 6, 7, 1, 5, 11, 4, 7, 9, 1, 3, 7, 9, 3, 7,
                                                                                                                                                                                                                                             8, 11, 2, 3, 5, 7, 7, 9, 1, 8, 9, 6, 7, 9, 10, 12, 7, 9, 12,
                                                                                                                                                                                                                                             2, 8, 7, 1, 2, 6, 8, 9, 12, 1, 2, 3, 4, 6, 7, 9, 6, 4, 8, 9,
                                                                                                                                                                                                                                             12, 2, 4, 1, 3, 4, 1, 3, 5, 7, 5, 12, 3, 1, 2, 8, 10, 1, 2, 4,
                                                                                                                                                                                                                                             1, 4, 5, 6, 10, 4, 11, 12, 1, 2, 3, 4, 1, 3, 7, 7, 2, 3, 5, 12,
                                                                                                                                                                                                                                             2, 7, 4, 7, 8, 9, 10, 11, 1, 2, 3, 4, 5, 6, 7, 11, 1, 3, 4, 5,
                                                                                                                                                                                                                                             6, 8, 9, 12, 1, 3, 4, 7, 7, 9, 1, 3, 9, 10, 11, 12, 2, 3, 4,
                                                                                                                                                                                                                                             9, 10, 11, 3, 5, 7, 10, 12, 3, 4, 7, 7, 7, 3, 5, 7, 8, 10, 12,
                                                                                                                                                                                                                                             2, 4, 7, 10, 2, 5, 6, 9, 11, 12, 1, 2, 3, 4, 5, 6, 7, 8, 11,
                                                                                                                                                                                                                                             12, 1, 2, 5, 6, 7, 12, 2, 3, 7, 8, 9, 10, 4, 7, 7, 12, 2, 3,
                                                                                                                                                                                                                                             5, 7, 7, 1, 3, 4, 5, 11, 1, 3, 4, 5, 7, 11, 1, 2, 10, 1, 2, 3,
                                                                                                                                                                                                                                             8, 6, 8, 9, 10, 12, 4, 6, 7, 10, 11, 3, 5, 6, 7, 2, 3, 7), total_cases = c(2,
                                                                                                                                                                                                                                                                                                                        1, 1, 1, 1, 1, 1, 1, 1, 2, 1, 1, 1, 1, 1, 1, 2, 1, 2, 1, 2, 1,
                                                                                                                                                                                                                                                                                                                        1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 1, 1, 1, 1, 2, 3, 1, 3, 1, 1, 3,
                                                                                                                                                                                                                                                                                                                        1, 3, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 3, 2, 1, 2, 1, 1, 1, 1, 2,
                                                                                                                                                                                                                                                                                                                        1, 2, 1, 1, 1, 1, 1, 1, 1, 1, 2, 1, 1, 2, 1, 1, 2, 1, 1, 1, 1,
                                                                                                                                                                                                                                                                                                                        3, 2, 2, 2, 1, 1, 1, 2, 2, 1, 1, 1, 2, 1, 1, 1, 1, 1, 1, 1, 1,
                                                                                                                                                                                                                                                                                                                        1, 2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 1, 2, 1, 1,
                                                                                                                                                                                                                                                                                                                        1, 1, 1, 1, 1, 1, 1, 2, 1, 1, 1, 1, 1, 1, 1, 1, 2, 1, 2, 2, 1,
                                                                                                                                                                                                                                                                                                                        1, 1, 1, 2, 1, 1, 1, 2, 1, 1, 1, 1, 1, 1, 1, 2, 1, 1, 1, 1, 1,
                                                                                                                                                                                                                                                                                                                        3, 1, 1, 1, 1, 1, 1, 2, 1, 1, 1, 1, 2, 2, 1, 1, 1, 1, 1, 1, 1,
                                                                                                                                                                                                                                                                                                                        1, 2, 1, 1, 1, 1, 1, 1, 1, 2, 1, 2, 1, 1, 1, 1, 1, 1, 3, 2, 1,
                                                                                                                                                                                                                                                                                                                        1, 2, 1, 1, 1, 1, 1, 1, 2, 1, 1, 1, 1, 1, 1, 1, 1, 2, 1, 1, 1,
                                                                                                                                                                                                                                                                                                                        1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
                                                                                                                                                                                                                                                                                                                        1, 1, 1, 1, 2, 1, 1, 1, 1, 1, 1, 1, 3, 1, 1, 1, 1, 1, 1, 1, 2,
                                                                                                                                                                                                                                                                                                                        1, 1, 1, 1, 1, 1, 2, 1, 1, 2, 2, 1, 1, 1, 1, 1, 2, 2, 1, 2, 1,
                                                                                                                                                                                                                                                                                                                        1, 2, 1, 2, 1, 2, 1, 1, 1, 1, 2, 2, 1, 1, 1, 1, 1, 3, 1, 1, 1,
                                                                                                                                                                                                                                                                                                                        1, 1, 1, 1, 1, 3, 2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
                                                                                                                                                                                                                                                                                                                        1, 1, 1, 1, 1, 1, 2, 1, 1, 1, 1, 2, 1, 1, 1, 1, 1, 1, 2, 2, 1,
                                                                                                                                                                                                                                                                                                                        1, 2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 2, 1, 1, 1, 2, 1, 1, 1, 2,
                                                                                                                                                                                                                                                                                                                        2, 1, 1, 2, 1, 1, 1, 1, 1, 1, 1, 1, 2, 1, 1, 2, 1, 2, 2, 1, 2,
                                                                                                                                                                                                                                                                                                                        1, 2, 1, 1, 1, 1, 1, 1, 2, 1, 1, 1, 1, 1, 3, 1, 1, 2, 1, 1, 1,
                                                                                                                                                                                                                                                                                                                        1, 1, 2, 1, 1, 1, 1, 1, 1, 1, 1, 2, 2, 1, 1, 1, 1, 1, 1, 1, 1,
                                                                                                                                                                                                                                                                                                                        1, 2, 1, 2, 1, 1, 1, 1, 1, 1, 1, 1, 2, 1, 2, 2, 2, 1, 1, 2, 2,
                                                                                                                                                                                                                                                                                                                        1, 2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 1, 1, 1, 1, 1, 2, 1, 1, 1,
                                                                                                                                                                                                                                                                                                                        1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 1, 1, 1, 2,
                                                                                                                                                                                                                                                                                                                        2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 1,
                                                                                                                                                                                                                                                                                                                        1, 1, 1, 1, 2, 2, 1, 2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
                                                                                                                                                                                                                                                                                                                        2, 2, 1, 1, 1, 1, 1, 1, 1, 1, 2, 1, 1, 2, 1, 1, 2, 1, 1, 2, 1,
                                                                                                                                                                                                                                                                                                                        3, 1, 1, 2, 1, 2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 2, 2, 2, 3, 2,
                                                                                                                                                                                                                                                                                                                        4, 3, 4, 2, 2, 5, 1, 2, 1, 1, 2, 2, 2, 1, 2, 2, 2, 1, 1, 1, 2,
                                                                                                                                                                                                                                                                                                                        1, 1, 1, 3, 2, 1, 1, 1, 1, 1, 1, 1, 2, 1, 1, 1, 1, 2, 2, 1, 2,
                                                                                                                                                                                                                                                                                                                        2, 1, 1, 2, 1, 1, 2, 1, 2, 1, 1, 1, 3, 1, 1, 3, 2, 1, 1, 1, 1,
                                                                                                                                                                                                                                                                                                                        2, 3, 1, 2, 1, 2, 2, 1, 1, 1, 2, 1, 1, 2, 1, 2, 1, 1, 1, 1, 2,
                                                                                                                                                                                                                                                                                                                        1, 1, 1, 1, 1, 2, 2, 1, 2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
                                                                                                                                                                                                                                                                                                                        1, 1, 2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1),
                              apportioned = c(1, 1, 0, 1, 1, 1, 0, 0, 1, 2, 0, 1, 0, 1,
                                              0, 0, 1, 0, 2, 0, 1, 1, 0, 0, 1, 0, 0, 1, 1, 0, 0, 2, 1,
                                              0, 1, 1, 0, 0, 1, 1, 1, 0, 1, 0, 1, 0, 0, 1, 1, 0, 0, 0,
                                              0, 0, 0, 1, 1, 0, 1, 1, 1, 1, 0, 0, 0, 0, 0, 1, 1, 1, 1,
                                              1, 1, 0, 1, 1, 0, 1, 0, 1, 1, 0, 0, 0, 0, 2, 1, 1, 1, 0,
                                              1, 0, 0, 0, 0, 1, 1, 0, 1, 0, 0, 1, 0, 1, 1, 0, 1, 1, 0,
                                              1, 0, 0, 0, 0, 1, 0, 1, 1, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0,
                                              1, 0, 0, 0, 1, 1, 1, 0, 0, 1, 1, 1, 0, 0, 1, 1, 0, 1, 1,
                                              1, 1, 0, 0, 2, 0, 1, 0, 1, 1, 1, 1, 0, 1, 0, 1, 2, 1, 0,
                                              0, 1, 0, 1, 1, 0, 0, 1, 1, 0, 0, 0, 1, 1, 1, 1, 1, 0, 0,
                                              0, 0, 0, 0, 0, 1, 1, 1, 0, 1, 0, 1, 0, 0, 0, 0, 1, 0, 1,
                                              1, 0, 0, 0, 1, 0, 0, 0, 1, 1, 0, 0, 0, 1, 0, 1, 0, 0, 1,
                                              1, 0, 1, 0, 0, 1, 0, 0, 1, 1, 0, 1, 0, 1, 0, 1, 1, 1, 0,
                                              0, 0, 0, 1, 0, 0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 1, 0, 0,
                                              1, 0, 0, 1, 1, 0, 1, 1, 0, 0, 0, 1, 1, 0, 1, 0, 0, 0, 1,
                                              1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 2, 1, 1, 0, 1, 0, 1, 1,
                                              0, 0, 0, 0, 0, 0, 1, 1, 0, 1, 1, 0, 0, 2, 0, 0, 0, 1, 0,
                                              0, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 1, 1, 1, 0, 0, 0, 0,
                                              1, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0,
                                              2, 0, 1, 1, 1, 1, 0, 1, 0, 0, 0, 0, 0, 1, 1, 0, 1, 1, 1,
                                              0, 1, 1, 1, 1, 0, 1, 0, 0, 0, 1, 0, 1, 1, 1, 0, 0, 1, 0,
                                              1, 1, 0, 1, 0, 1, 1, 1, 1, 0, 1, 0, 0, 0, 1, 1, 0, 0, 1,
                                              1, 1, 1, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 1,
                                              1, 0, 0, 1, 1, 0, 0, 1, 0, 1, 1, 0, 0, 1, 1, 0, 1, 1, 0,
                                              1, 1, 0, 1, 1, 1, 1, 2, 1, 1, 1, 2, 0, 1, 1, 1, 1, 1, 0,
                                              1, 1, 0, 0, 0, 0, 0, 0, 1, 1, 2, 1, 0, 0, 0, 1, 0, 1, 0,
                                              0, 1, 1, 0, 0, 0, 0, 0, 0, 1, 0, 1, 1, 0, 0, 1, 1, 0, 1,
                                              0, 1, 1, 1, 0, 0, 0, 1, 1, 1, 1, 0, 1, 0, 0, 1, 1, 0, 0,
                                              0, 0, 1, 1, 2, 1, 2, 1, 0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0,
                                              0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0,
                                              0, 1, 0, 1, 0, 1, 1, 0, 0, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0,
                                              0, 1, 1, 1, 1, 0, 0, 2, 0, 1, 0, 0, 1, 0, 1, 1, 1, 0, 1,
                                              0, 1, 1, 0, 1, 1, 1, 1, 0, 1, 0, 1, 0, 0, 0, 1, 0, 0, 1,
                                              0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 1, 1, 0, 1, 1, 1, 0, 1,
                                              1, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 2, 0, 1, 2, 0,
                                              0, 1, 0, 0, 0, 1, 1, 0, 0, 1, 0, 1, 0, 0, 0, 1, 0, 0, 0,
                                              0, 1, 2, 0, 0, 0, 0, 1, 1, 0, 1, 0, 1, 0, 0, 1, 0, 0, 1,
                                              0, 1, 0, 0, 1, 0, 1, 0, 0, 0, 1, 0, 1, 0, 1, 0), nhs_trust_pir = c(1,
                                                                                                                 1, 0, 1, 1, 1, 0, 1, 1, 2, 0, 1, 0, 1, 1, 0, 2, 0, 2, 0,
                                                                                                                 1, 1, 0, 0, 1, 0, 1, 1, 1, 0, 0, 1, 1, 0, 1, 1, 1, 1, 1,
                                                                                                                 1, 1, 0, 1, 0, 1, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 1, 1, 0,
                                                                                                                 1, 1, 1, 1, 0, 0, 0, 0, 0, 1, 1, 1, 0, 1, 1, 0, 0, 1, 0,
                                                                                                                 1, 0, 1, 1, 0, 1, 0, 0, 2, 1, 1, 1, 0, 1, 1, 0, 1, 1, 1,
                                                                                                                 1, 0, 1, 0, 0, 1, 0, 1, 1, 1, 1, 1, 0, 1, 0, 0, 0, 0, 1,
                                                                                                                 0, 1, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 1, 0, 1, 1, 1, 1,
                                                                                                                 1, 0, 0, 1, 1, 1, 0, 1, 1, 1, 0, 1, 1, 1, 1, 1, 0, 1, 0,
                                                                                                                 1, 0, 1, 1, 1, 1, 0, 1, 0, 1, 2, 1, 0, 0, 1, 0, 2, 1, 0,
                                                                                                                 0, 1, 1, 0, 0, 0, 1, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0,
                                                                                                                 1, 1, 1, 1, 0, 1, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0,
                                                                                                                 0, 0, 0, 1, 0, 0, 0, 1, 0, 0, 1, 0, 0, 1, 0, 1, 0, 0, 0,
                                                                                                                 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 1, 0, 0,
                                                                                                                 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 1, 0, 0,
                                                                                                                 1, 1, 0, 0, 1, 1, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0,
                                                                                                                 0, 1, 1, 0, 0, 1, 0, 1, 0, 1, 1, 0, 1, 0, 0, 1, 0, 0, 0,
                                                                                                                 1, 0, 0, 1, 1, 0, 0, 2, 1, 0, 0, 1, 0, 0, 0, 0, 2, 2, 1,
                                                                                                                 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0,
                                                                                                                 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 1, 1, 2, 0, 1, 0, 0, 1,
                                                                                                                 0, 1, 0, 0, 0, 0, 0, 2, 1, 0, 1, 0, 1, 0, 1, 1, 2, 1, 1,
                                                                                                                 1, 1, 0, 1, 1, 0, 1, 1, 1, 0, 0, 1, 0, 1, 1, 0, 1, 0, 1,
                                                                                                                 1, 1, 1, 0, 1, 0, 0, 0, 1, 1, 1, 0, 1, 1, 1, 1, 0, 1, 1,
                                                                                                                 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 1, 0, 0, 1, 1, 0,
                                                                                                                 0, 1, 0, 1, 1, 0, 1, 1, 1, 0, 0, 0, 0, 1, 1, 0, 1, 1, 1,
                                                                                                                 1, 2, 0, 1, 1, 2, 0, 1, 1, 1, 1, 1, 0, 1, 1, 0, 0, 0, 0,
                                                                                                                 0, 0, 1, 1, 2, 0, 0, 0, 0, 1, 0, 1, 0, 0, 1, 0, 0, 0, 0,
                                                                                                                 0, 1, 0, 1, 0, 1, 1, 1, 0, 1, 1, 1, 1, 0, 1, 0, 1, 0, 0,
                                                                                                                 0, 1, 1, 1, 1, 0, 1, 0, 0, 1, 1, 0, 0, 0, 1, 1, 1, 2, 1,
                                                                                                                 2, 1, 0, 0, 0, 0, 1, 0, 1, 1, 0, 0, 0, 0, 1, 0, 0, 0, 1,
                                                                                                                 0, 0, 1, 0, 1, 1, 1, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 1,
                                                                                                                 1, 0, 1, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 1, 1, 1, 1, 0,
                                                                                                                 0, 1, 0, 1, 0, 0, 1, 0, 1, 0, 1, 0, 1, 0, 2, 1, 0, 1, 0,
                                                                                                                 1, 1, 0, 1, 0, 1, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1,
                                                                                                                 0, 0, 0, 0, 0, 1, 2, 0, 1, 0, 1, 0, 1, 1, 1, 1, 0, 1, 0,
                                                                                                                 1, 1, 1, 0, 1, 1, 2, 0, 2, 0, 1, 1, 0, 0, 1, 0, 0, 0, 2,
                                                                                                                 1, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 0, 0, 1, 2, 0, 0, 0,
                                                                                                                 1, 1, 1, 1, 1, 0, 1, 1, 0, 1, 0, 0, 1, 0, 1, 0, 0, 1, 0,
                                                                                                                 1, 0, 0, 0, 1, 0, 1, 0, 1, 0), ccg_pir = c(1, 0, 1, 0, 0,
                                                                                                                                                            0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 1, 0, 1, 1, 0, 1, 1,
                                                                                                                                                            0, 1, 0, 0, 0, 1, 1, 1, 0, 1, 0, 0, 1, 2, 0, 2, 0, 1, 2,
                                                                                                                                                            1, 2, 1, 0, 0, 0, 1, 1, 1, 1, 0, 0, 0, 1, 1, 1, 0, 0, 0,
                                                                                                                                                            1, 2, 0, 2, 1, 0, 0, 0, 0, 0, 0, 1, 1, 0, 1, 1, 1, 0, 1,
                                                                                                                                                            1, 0, 1, 1, 1, 1, 1, 1, 1, 0, 0, 2, 1, 0, 0, 0, 2, 0, 0,
                                                                                                                                                            1, 0, 0, 0, 0, 0, 0, 1, 1, 0, 1, 1, 1, 1, 0, 1, 0, 1, 1,
                                                                                                                                                            1, 1, 1, 1, 1, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0,
                                                                                                                                                            0, 0, 1, 0, 0, 0, 0, 1, 1, 0, 0, 0, 1, 0, 1, 0, 1, 0, 0,
                                                                                                                                                            0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0, 1, 1, 0, 1, 0, 0, 0, 1,
                                                                                                                                                            2, 0, 0, 1, 0, 1, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0,
                                                                                                                                                            0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
                                                                                                                                                            0, 1, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0,
                                                                                                                                                            0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 1, 1, 1, 1, 0, 0,
                                                                                                                                                            0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0,
                                                                                                                                                            0, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0,
                                                                                                                                                            0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
                                                                                                                                                            0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0,
                                                                                                                                                            0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0,
                                                                                                                                                            0, 1, 0, 0, 0, 0, 1, 0, 1, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0,
                                                                                                                                                            0, 0, 1, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
                                                                                                                                                            0, 1, 0, 0, 0, 1, 2, 0, 1, 0, 0, 2, 1, 1, 1, 0, 1, 0, 1,
                                                                                                                                                            0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 2, 0, 0, 1, 0, 0, 1, 1, 1,
                                                                                                                                                            2, 1, 0, 1, 0, 1, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 1, 0,
                                                                                                                                                            0, 2, 0, 0, 0, 1, 0, 0, 1, 0, 0, 1, 1, 0, 1, 1, 0, 0, 0,
                                                                                                                                                            1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 1, 1, 0, 1, 1, 1, 0, 0,
                                                                                                                                                            0, 0, 1, 1, 1, 0, 0, 0, 1, 0, 0, 0, 1, 1, 1, 1, 0, 1, 0,
                                                                                                                                                            0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0,
                                                                                                                                                            0, 1, 0, 1, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 1, 1,
                                                                                                                                                            0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0,
                                                                                                                                                            0, 0, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, 1,
                                                                                                                                                            0, 0, 1, 1, 0, 1, 0, 1, 1, 0, 0, 0, 1, 0, 0, 1, 0, 1, 1,
                                                                                                                                                            5, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 1, 0, 0, 1, 0, 0, 0, 0,
                                                                                                                                                            2, 1, 1, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 1, 2, 2,
                                                                                                                                                            0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 1, 1, 0, 0, 0,
                                                                                                                                                            0, 0, 0, 1, 0, 1, 1, 0, 1, 0, 0, 2, 1, 0, 0, 0, 1, 0, 0,
                                                                                                                                                            0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0,
                                                                                                                                                            0, 0, 0, 0, 1, 0, 0, 1, 0, 1, 0, 1, 1, 0, 1, 0, 1, 1, 1,
                                                                                                                                                            0, 1, 0, 1, 0, 1), third_party_pir = c(0, 0, 0, 0, 0, 0,
                                                                                                                                                                                                   1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0,
                                                                                                                                                                                                   0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
                                                                                                                                                                                                   0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 2, 0, 0, 0, 0, 0, 0, 0,
                                                                                                                                                                                                   0, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,
                                                                                                                                                                                                   0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0,
                                                                                                                                                                                                   0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
                                                                                                                                                                                                   0, 0, 0, 0, 0, 1, 0, 1, 0, 1, 0, 0, 0, 0, 1, 0, 1, 0, 0,
                                                                                                                                                                                                   0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 0,
                                                                                                                                                                                                   0, 0, 0, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0,
                                                                                                                                                                                                   1, 0, 0, 1, 0, 1, 0, 1, 1, 0, 0, 1, 1, 1, 1, 0, 0, 0, 1,
                                                                                                                                                                                                   0, 1, 1, 2, 1, 1, 0, 1, 0, 1, 1, 1, 3, 2, 1, 1, 2, 0, 1,
                                                                                                                                                                                                   0, 0, 0, 0, 2, 0, 1, 1, 0, 1, 0, 1, 1, 2, 1, 0, 1, 1, 1,
                                                                                                                                                                                                   1, 0, 0, 1, 1, 1, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0,
                                                                                                                                                                                                   1, 1, 1, 1, 2, 0, 1, 1, 0, 1, 1, 0, 2, 1, 0, 0, 1, 1, 0,
                                                                                                                                                                                                   0, 1, 0, 1, 1, 0, 1, 1, 1, 1, 1, 1, 2, 1, 1, 0, 0, 1, 2,
                                                                                                                                                                                                   1, 1, 1, 1, 0, 1, 1, 1, 1, 2, 0, 1, 1, 1, 1, 2, 1, 0, 0,
                                                                                                                                                                                                   0, 1, 1, 0, 1, 1, 0, 1, 1, 1, 1, 1, 0, 0, 1, 0, 1, 1, 1,
                                                                                                                                                                                                   0, 0, 0, 0, 0, 1, 1, 0, 1, 1, 0, 1, 0, 1, 2, 1, 1, 0, 1,
                                                                                                                                                                                                   1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 2, 0, 0, 1, 0, 1, 1, 1,
                                                                                                                                                                                                   1, 0, 0, 1, 0, 0, 0, 1, 1, 0, 0, 0, 1, 0, 0, 1, 1, 0, 0,
                                                                                                                                                                                                   0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
                                                                                                                                                                                                   0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0,
                                                                                                                                                                                                   0, 1, 0, 1, 0, 0, 1, 0, 1, 0, 1, 0, 0, 1, 1, 0, 0, 0, 0,
                                                                                                                                                                                                   0, 0, 1, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0,
                                                                                                                                                                                                   0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0,
                                                                                                                                                                                                   1, 0, 0, 0, 0, 1, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 1,
                                                                                                                                                                                                   1, 0, 0, 0, 1, 1, 0, 0, 1, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0,
                                                                                                                                                                                                   0, 0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1,
                                                                                                                                                                                                   0, 0, 1, 0, 0, 1, 1, 0, 1, 1, 2, 0, 1, 0, 0, 1, 0, 1, 0,
                                                                                                                                                                                                   1, 0, 0, 2, 1, 1, 1, 0, 1, 1, 1, 2, 1, 0, 1, 1, 0, 0, 0,
                                                                                                                                                                                                   1, 0, 0, 0, 0, 1, 0, 1, 2, 1, 1, 1, 1, 4, 2, 3, 1, 0, 0,
                                                                                                                                                                                                   1, 1, 1, 0, 2, 1, 1, 0, 1, 0, 0, 1, 0, 0, 1, 0, 1, 0, 1,
                                                                                                                                                                                                   0, 0, 0, 0, 0, 1, 1, 1, 2, 1, 0, 1, 1, 1, 1, 0, 0, 0, 1,
                                                                                                                                                                                                   0, 0, 1, 0, 2, 0, 2, 0, 0, 0, 0, 1, 0, 2, 0, 0, 0, 1, 0,
                                                                                                                                                                                                   1, 1, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 1, 0, 0, 1, 1, 1, 1,
                                                                                                                                                                                                   0, 1, 1, 1, 0, 1, 0, 2, 2, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0,
                                                                                                                                                                                                   1, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
                                                                                                                                                                                                   0, 0, 0, 0, 0), fmonth = c(7, 4, 5, 7, 8, 12, 1, 2, 6, 12,
                                                                                                                                                                                                                              0, 2, 3, 6, 4, 7, 11, 0, 5, 11, 1, 7, 8, 9, 2, 3, 4, 5, 7,
                                                                                                                                                                                                                              2, 4, 4, 5, 6, 9, 0, 4, 5, 6, 7, 8, 9, 12, 0, 2, 4, 6, 5,
                                                                                                                                                                                                                              6, 8, 3, 4, 4, 6, 9, 12, 2, 3, 5, 7, 8, 2, 12, 4, 7, 4, 11,
                                                                                                                                                                                                                              12, 4, 9, 0, 2, 3, 6, 12, 3, 5, 12, 9, 4, 6, 9, 12, 1, 4,
                                                                                                                                                                                                                              5, 12, 11, 2, 4, 8, 12, 2, 0, 1, 4, 6, 7, 9, 12, 4, 5, 8,
                                                                                                                                                                                                                              8, 9, 12, 0, 1, 3, 7, 11, 0, 6, 5, 2, 3, 8, 7, 8, 9, 0, 1,
                                                                                                                                                                                                                              2, 3, 9, 2, 3, 8, 9, 11, 3, 5, 7, 1, 2, 1, 5, 9, 12, 11,
                                                                                                                                                                                                                              2, 3, 4, 5, 8, 0, 2, 3, 6, 7, 8, 9, 1, 4, 5, 9, 1, 12, 7,
                                                                                                                                                                                                                              12, 11, 6, 12, 5, 8, 4, 9, 1, 5, 7, 12, 11, 0, 1, 2, 3, 4,
                                                                                                                                                                                                                              4, 6, 11, 0, 2, 12, 11, 11, 8, 4, 4, 4, 7, 11, 0, 12, 3,
                                                                                                                                                                                                                              4, 9, 12, 4, 4, 5, 9, 3, 4, 4, 5, 7, 9, 2, 3, 4, 1, 2, 5,
                                                                                                                                                                                                                              6, 2, 5, 8, 3, 4, 8, 9, 0, 6, 7, 8, 9, 12, 11, 1, 6, 4, 12,
                                                                                                                                                                                                                              11, 2, 6, 8, 12, 9, 11, 1, 2, 3, 5, 8, 7, 0, 2, 3, 1, 3,
                                                                                                                                                                                                                              12, 12, 8, 4, 6, 8, 1, 3, 5, 9, 9, 12, 11, 2, 4, 4, 8, 9,
                                                                                                                                                                                                                              12, 11, 4, 6, 11, 0, 4, 5, 12, 11, 1, 2, 3, 8, 11, 8, 12,
                                                                                                                                                                                                                              3, 7, 9, 7, 8, 9, 0, 2, 4, 7, 9, 12, 11, 1, 3, 4, 7, 8, 12,
                                                                                                                                                                                                                              0, 3, 12, 1, 2, 7, 9, 12, 0, 4, 8, 11, 0, 1, 6, 8, 12, 11,
                                                                                                                                                                                                                              1, 5, 9, 11, 8, 12, 1, 2, 6, 5, 6, 8, 11, 3, 4, 4, 5, 12,
                                                                                                                                                                                                                              0, 5, 7, 11, 1, 4, 5, 6, 7, 9, 11, 1, 3, 4, 6, 8, 3, 4, 5,
                                                                                                                                                                                                                              7, 12, 11, 0, 2, 3, 7, 8, 9, 1, 2, 3, 4, 6, 7, 8, 2, 4, 7,
                                                                                                                                                                                                                              1, 5, 6, 8, 9, 1, 8, 11, 0, 5, 8, 1, 4, 4, 5, 6, 9, 2, 3,
                                                                                                                                                                                                                              5, 8, 12, 11, 1, 6, 9, 11, 4, 5, 12, 1, 2, 1, 7, 8, 3, 4,
                                                                                                                                                                                                                              5, 7, 12, 0, 1, 2, 3, 12, 3, 4, 4, 6, 9, 0, 2, 5, 7, 11,
                                                                                                                                                                                                                              3, 6, 11, 1, 2, 3, 6, 12, 0, 1, 3, 6, 11, 1, 2, 6, 7, 8,
                                                                                                                                                                                                                              9, 12, 3, 4, 6, 12, 3, 4, 7, 8, 0, 1, 6, 7, 12, 11, 5, 7,
                                                                                                                                                                                                                              9, 11, 6, 7, 8, 0, 4, 9, 3, 7, 4, 7, 8, 11, 7, 4, 12, 11,
                                                                                                                                                                                                                              3, 4, 12, 2, 8, 1, 4, 6, 12, 0, 4, 6, 0, 4, 5, 8, 11, 0,
                                                                                                                                                                                                                              2, 4, 4, 6, 12, 5, 6, 3, 4, 6, 7, 9, 4, 6, 9, 11, 5, 4, 12,
                                                                                                                                                                                                                              11, 3, 5, 6, 9, 12, 11, 0, 1, 3, 4, 6, 3, 1, 5, 6, 9, 11,
                                                                                                                                                                                                                              1, 12, 0, 1, 12, 0, 2, 4, 2, 9, 0, 12, 11, 5, 7, 12, 11,
                                                                                                                                                                                                                              1, 12, 1, 2, 3, 7, 1, 8, 9, 12, 11, 0, 1, 12, 0, 4, 4, 11,
                                                                                                                                                                                                                              0, 2, 9, 11, 4, 1, 4, 5, 6, 7, 8, 12, 11, 0, 1, 2, 3, 4,
                                                                                                                                                                                                                              8, 12, 0, 1, 2, 3, 5, 6, 9, 12, 0, 1, 4, 4, 6, 12, 0, 6,
                                                                                                                                                                                                                              7, 8, 9, 11, 0, 1, 6, 7, 8, 0, 2, 4, 7, 9, 0, 1, 4, 4, 4,
                                                                                                                                                                                                                              0, 2, 4, 5, 7, 9, 11, 1, 4, 7, 11, 2, 3, 6, 8, 9, 12, 11,
                                                                                                                                                                                                                              0, 1, 2, 3, 4, 5, 8, 9, 12, 11, 2, 3, 4, 9, 11, 0, 4, 5,
                                                                                                                                                                                                                              6, 7, 1, 4, 4, 9, 11, 0, 2, 4, 4, 12, 0, 1, 2, 8, 12, 0,
                                                                                                                                                                                                                              1, 2, 4, 8, 12, 11, 7, 12, 11, 0, 5, 3, 5, 6, 7, 9, 1, 3,
                                                                                                                                                                                                                              4, 7, 8, 0, 2, 3, 4, 11, 0, 4), month_string = c("October",
                                                                                                                                                                                                                                                                               "July", "August", "October", "November", "January", "April",
                                                                                                                                                                                                                                                                               "May", "September", "January", "March", "May", "June", "September",
                                                                                                                                                                                                                                                                               "July", "October", "February", "March", "August", "February",
                                                                                                                                                                                                                                                                               "April", "October", "November", "December", "May", "June",
                                                                                                                                                                                                                                                                               "July", "August", "October", "May", "July", "July", "August",
                                                                                                                                                                                                                                                                               "September", "December", "March", "July", "August", "September",
                                                                                                                                                                                                                                                                               "October", "November", "December", "January", "March", "May",
                                                                                                                                                                                                                                                                               "July", "September", "August", "September", "November", "June",
                                                                                                                                                                                                                                                                               "July", "July", "September", "December", "January", "May",
                                                                                                                                                                                                                                                                               "June", "August", "October", "November", "May", "January",
                                                                                                                                                                                                                                                                               "July", "October", "July", "February", "January", "July",
                                                                                                                                                                                                                                                                               "December", "March", "May", "June", "September", "January",
                                                                                                                                                                                                                                                                               "June", "August", "January", "December", "July", "September",
                                                                                                                                                                                                                                                                               "December", "January", "April", "July", "August", "January",
                                                                                                                                                                                                                                                                               "February", "May", "July", "November", "January", "May",
                                                                                                                                                                                                                                                                               "March", "April", "July", "September", "October", "December",
                                                                                                                                                                                                                                                                               "January", "July", "August", "November", "November", "December",
                                                                                                                                                                                                                                                                               "January", "March", "April", "June", "October", "February",
                                                                                                                                                                                                                                                                               "March", "September", "August", "May", "June", "November",
                                                                                                                                                                                                                                                                               "October", "November", "December", "March", "April", "May",
                                                                                                                                                                                                                                                                               "June", "December", "May", "June", "November", "December",
                                                                                                                                                                                                                                                                               "February", "June", "August", "October", "April", "May",
                                                                                                                                                                                                                                                                               "April", "August", "December", "January", "February", "May",
                                                                                                                                                                                                                                                                               "June", "July", "August", "November", "March", "May", "June",
                                                                                                                                                                                                                                                                               "September", "October", "November", "December", "April",
                                                                                                                                                                                                                                                                               "July", "August", "December", "April", "January", "October",
                                                                                                                                                                                                                                                                               "January", "February", "September", "January", "August",
                                                                                                                                                                                                                                                                               "November", "July", "December", "April", "August", "October",
                                                                                                                                                                                                                                                                               "January", "February", "March", "April", "May", "June", "July",
                                                                                                                                                                                                                                                                               "July", "September", "February", "March", "May", "January",
                                                                                                                                                                                                                                                                               "February", "February", "November", "July", "July", "July",
                                                                                                                                                                                                                                                                               "October", "February", "March", "January", "June", "July",
                                                                                                                                                                                                                                                                               "December", "January", "July", "July", "August", "December",
                                                                                                                                                                                                                                                                               "June", "July", "July", "August", "October", "December",
                                                                                                                                                                                                                                                                               "May", "June", "July", "April", "May", "August", "September",
                                                                                                                                                                                                                                                                               "May", "August", "November", "June", "July", "November",
                                                                                                                                                                                                                                                                               "December", "March", "September", "October", "November",
                                                                                                                                                                                                                                                                               "December", "January", "February", "April", "September",
                                                                                                                                                                                                                                                                               "July", "January", "February", "May", "September", "November",
                                                                                                                                                                                                                                                                               "January", "December", "February", "April", "May", "June",
                                                                                                                                                                                                                                                                               "August", "November", "October", "March", "May", "June",
                                                                                                                                                                                                                                                                               "April", "June", "January", "January", "November", "July",
                                                                                                                                                                                                                                                                               "September", "November", "April", "June", "August", "December",
                                                                                                                                                                                                                                                                               "December", "January", "February", "May", "July", "July",
                                                                                                                                                                                                                                                                               "November", "December", "January", "February", "July", "September",
                                                                                                                                                                                                                                                                               "February", "March", "July", "August", "January", "February",
                                                                                                                                                                                                                                                                               "April", "May", "June", "November", "February", "November",
                                                                                                                                                                                                                                                                               "January", "June", "October", "December", "October", "November",
                                                                                                                                                                                                                                                                               "December", "March", "May", "July", "October", "December",
                                                                                                                                                                                                                                                                               "January", "February", "April", "June", "July", "October",
                                                                                                                                                                                                                                                                               "November", "January", "March", "June", "January", "April",
                                                                                                                                                                                                                                                                               "May", "October", "December", "January", "March", "July",
                                                                                                                                                                                                                                                                               "November", "February", "March", "April", "September", "November",
                                                                                                                                                                                                                                                                               "January", "February", "April", "August", "December", "February",
                                                                                                                                                                                                                                                                               "November", "January", "April", "May", "September", "August",
                                                                                                                                                                                                                                                                               "September", "November", "February", "June", "July", "July",
                                                                                                                                                                                                                                                                               "August", "January", "March", "August", "October", "February",
                                                                                                                                                                                                                                                                               "April", "July", "August", "September", "October", "December",
                                                                                                                                                                                                                                                                               "February", "April", "June", "July", "September", "November",
                                                                                                                                                                                                                                                                               "June", "July", "August", "October", "January", "February",
                                                                                                                                                                                                                                                                               "March", "May", "June", "October", "November", "December",
                                                                                                                                                                                                                                                                               "April", "May", "June", "July", "September", "October", "November",
                                                                                                                                                                                                                                                                               "May", "July", "October", "April", "August", "September",
                                                                                                                                                                                                                                                                               "November", "December", "April", "November", "February",
                                                                                                                                                                                                                                                                               "March", "August", "November", "April", "July", "July", "August",
                                                                                                                                                                                                                                                                               "September", "December", "May", "June", "August", "November",
                                                                                                                                                                                                                                                                               "January", "February", "April", "September", "December",
                                                                                                                                                                                                                                                                               "February", "July", "August", "January", "April", "May",
                                                                                                                                                                                                                                                                               "April", "October", "November", "June", "July", "August",
                                                                                                                                                                                                                                                                               "October", "January", "March", "April", "May", "June", "January",
                                                                                                                                                                                                                                                                               "June", "July", "July", "September", "December", "March",
                                                                                                                                                                                                                                                                               "May", "August", "October", "February", "June", "September",
                                                                                                                                                                                                                                                                               "February", "April", "May", "June", "September", "January",
                                                                                                                                                                                                                                                                               "March", "April", "June", "September", "February", "April",
                                                                                                                                                                                                                                                                               "May", "September", "October", "November", "December", "January",
                                                                                                                                                                                                                                                                               "June", "July", "September", "January", "June", "July", "October",
                                                                                                                                                                                                                                                                               "November", "March", "April", "September", "October", "January",
                                                                                                                                                                                                                                                                               "February", "August", "October", "December", "February",
                                                                                                                                                                                                                                                                               "September", "October", "November", "March", "July", "December",
                                                                                                                                                                                                                                                                               "June", "October", "July", "October", "November", "February",
                                                                                                                                                                                                                                                                               "October", "July", "January", "February", "June", "July",
                                                                                                                                                                                                                                                                               "January", "May", "November", "April", "July", "September",
                                                                                                                                                                                                                                                                               "January", "March", "July", "September", "March", "July",
                                                                                                                                                                                                                                                                               "August", "November", "February", "March", "May", "July",
                                                                                                                                                                                                                                                                               "July", "September", "January", "August", "September", "June",
                                                                                                                                                                                                                                                                               "July", "September", "October", "December", "July", "September",
                                                                                                                                                                                                                                                                               "December", "February", "August", "July", "January", "February",
                                                                                                                                                                                                                                                                               "June", "August", "September", "December", "January", "February",
                                                                                                                                                                                                                                                                               "March", "April", "June", "July", "September", "June", "April",
                                                                                                                                                                                                                                                                               "August", "September", "December", "February", "April", "January",
                                                                                                                                                                                                                                                                               "March", "April", "January", "March", "May", "July", "May",
                                                                                                                                                                                                                                                                               "December", "March", "January", "February", "August", "October",
                                                                                                                                                                                                                                                                               "January", "February", "April", "January", "April", "May",
                                                                                                                                                                                                                                                                               "June", "October", "April", "November", "December", "January",
                                                                                                                                                                                                                                                                               "February", "March", "April", "January", "March", "July",
                                                                                                                                                                                                                                                                               "July", "February", "March", "May", "December", "February",
                                                                                                                                                                                                                                                                               "July", "April", "July", "August", "September", "October",
                                                                                                                                                                                                                                                                               "November", "January", "February", "March", "April", "May",
                                                                                                                                                                                                                                                                               "June", "July", "November", "January", "March", "April",
                                                                                                                                                                                                                                                                               "May", "June", "August", "September", "December", "January",
                                                                                                                                                                                                                                                                               "March", "April", "July", "July", "September", "January",
                                                                                                                                                                                                                                                                               "March", "September", "October", "November", "December",
                                                                                                                                                                                                                                                                               "February", "March", "April", "September", "October", "November",
                                                                                                                                                                                                                                                                               "March", "May", "July", "October", "December", "March", "April",
                                                                                                                                                                                                                                                                               "July", "July", "July", "March", "May", "July", "August",
                                                                                                                                                                                                                                                                               "October", "December", "February", "April", "July", "October",
                                                                                                                                                                                                                                                                               "February", "May", "June", "September", "November", "December",
                                                                                                                                                                                                                                                                               "January", "February", "March", "April", "May", "June", "July",
                                                                                                                                                                                                                                                                               "August", "November", "December", "January", "February",
                                                                                                                                                                                                                                                                               "May", "June", "July", "December", "February", "March", "July",
                                                                                                                                                                                                                                                                               "August", "September", "October", "April", "July", "July",
                                                                                                                                                                                                                                                                               "December", "February", "March", "May", "July", "July", "January",
                                                                                                                                                                                                                                                                               "March", "April", "May", "November", "January", "March",
                                                                                                                                                                                                                                                                               "April", "May", "July", "November", "January", "February",
                                                                                                                                                                                                                                                                               "October", "January", "February", "March", "August", "June",
                                                                                                                                                                                                                                                                               "August", "September", "October", "December", "April", "June",
                                                                                                                                                                                                                                                                               "July", "October", "November", "March", "May", "June", "July",
                                                                                                                                                                                                                                                                               "February", "March", "July")), class = "data.frame", row.names = c(NA,
                                                                                                                                                                                                                                                                                                                                                  -714L), .Names = c("data_collection", "ccg_code", "fyear6", "year_no",
                                                                                                                                                                                                                                                                                                                                                                     "month_no", "total_cases", "apportioned", "nhs_trust_pir", "ccg_pir",
                                                                                                                                                                                                                                                                                                                                                                     "third_party_pir", "fmonth", "month_string"))

head(monthly_ccg_data_raw)

cdi_prior_hc_data <- structure(list(org_code = c("R0A", "R0A", "R0A", "R0A", "R0A",
                                                 "R0A", "R0A", "R0A", "R0A", "R0A", "R0A", "R0A", "R0A"), year_no = c(2017,
                                                                                                                      2017, 2017, 2017, 2017, 2017, 2017, 2017, 2017, 2017, 2018, 2018,
                                                                                                                      2018), month_no = c(10, 11, 12, 3, 4, 5, 6, 7, 8, 9, 1, 2, 3),
                                    data_collection = c("C. difficile", "C. difficile", "C. difficile",
                                                        "C. difficile", "C. difficile", "C. difficile", "C. difficile",
                                                        "C. difficile", "C. difficile", "C. difficile", "C. difficile",
                                                        "C. difficile", "C. difficile"), fyear6 = c("201718", "201718",
                                                                                                    "201718", "201617", "201718", "201718", "201718", "201718",
                                                                                                    "201718", "201718", "201718", "201718", "201718"), total_cases = c(15,
                                                                                                                                                                       13, 16, 22, 15, 12, 16, 20, 19, 21, 23, 18, 25), apportioned = c(7,
                                                                                                                                                                                                                                        12, 6, 12, 13, 8, 10, 14, 11, 12, 16, 12, 17), nhs_trust_pir = c(NA_real_,
                                                                                                                                                                                                                                                                                                         NA_real_, NA_real_, NA_real_, NA_real_, NA_real_, NA_real_,
                                                                                                                                                                                                                                                                                                         NA_real_, NA_real_, NA_real_, NA_real_, NA_real_, NA_real_
                                                                                                                                                                                                                                        ), ccg_pir = c(NA_real_, NA_real_, NA_real_, NA_real_, NA_real_,
                                                                                                                                                                                                                                                       NA_real_, NA_real_, NA_real_, NA_real_, NA_real_, NA_real_,
                                                                                                                                                                                                                                                       NA_real_, NA_real_), third_party_pir = c(NA_real_, NA_real_,
                                                                                                                                                                                                                                                                                                NA_real_, NA_real_, NA_real_, NA_real_, NA_real_, NA_real_,
                                                                                                                                                                                                                                                                                                NA_real_, NA_real_, NA_real_, NA_real_, NA_real_), hoha = c(8,
                                                                                                                                                                                                                                                                                                                                                            12, 7, NA, 13, 8, 11, 14, 11, 15, 16, 12, 17), coha = c(5,
                                                                                                                                                                                                                                                                                                                                                                                                                    0, 6, NA, 0, 0, 0, 0, 0, 1, 5, 2, 2), coia = c(0, 0, 2, NA,
                                                                                                                                                                                                                                                                                                                                                                                                                                                                   0, 0, 0, 0, 0, 0, 1, 1, 2), coca = c(0, 0, 1, NA, 0, 0, 0,
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        0, 0, 1, 1, 3, 4), phc_all_blank = c(2, 0, 0, NA, 2, 4, 5,
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             6, 8, 4, 0, 0, 0), phc_unknown_3_mo = c(0, 1, 0, NA, 0, 0,
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     0, 0, 0, 0, 0, 0, 0), fmonth = c(7, 8, 9, 12, 1, 2, 3, 4,
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      5, 6, 10, 11, 12), month_string = c("October", "November",
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          "December", "March", "April", "May", "June", "July", "August",
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          "September", "January", "February", "March")), class = c("tbl_df",
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   "tbl", "data.frame"), row.names = c(NA, -13L), .Names = c("org_code",
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             "year_no", "month_no", "data_collection", "fyear6", "total_cases",
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             "apportioned", "nhs_trust_pir", "ccg_pir", "third_party_pir",
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             "hoha", "coha", "coia", "coca", "phc_all_blank", "phc_unknown_3_mo",
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             "fmonth", "month_string"))

devtools::use_data(monthly_ccg_data_raw)
devtools::use_data(cdi_prior_hc_data, overwrite = TRUE)
PublicHealthEngland/hcaidcs documentation built on Jan. 19, 2024, 8:38 a.m.